Street and Highway Capital Reconstruction Projects - Block

This data is a spatial representation of street construction projects. Street and Highway capital projects are major street reconstruction projects, ranging from general street resurfacing projects to full reconstruction of the roadbed, sidewalks, sewer and water pipes and other utilities. Capital projects are essential to keep the City's infrastructure in a state of good repair.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cityofnewyork-us/street-and-highway-capital-reconstruction-projects-jvk9-k4re\".\"street_and_highway_capital_reconstruction_projects\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.