Capital Projects Database (CPDB) - Projects (Points)
Spatial data at the point level can be joined to the tabular Capital Projects dataset using the FSM ID. A majority of the spatial data was made available on NYC Open Data by agency partners. Some geometries were created manually, while others relied on 'Fuzzy String Matching'. This process relied on a join to DCP's Facilities Database and DPR's Parks Properties to match project descriptions to physical locations.
To explore the data, please visit <a href="https://capitalplanning.nyc.gov/map#10/40.7128/-74.0807">Capital Planning Explorer</a>
For additional information, please visit <a href="https://www.ibo.nyc.ny.us/iboreports/IBOCBG.pdf">A Guide to The Capital Budget</a>
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/capital-projects-database-cpdb-projects-points-h2ic-zdws\".\"capital_projects_database_cpdb_projects_points\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.