Capital Projects

All major infrastructure and information technology projects with a budget of $25 million or more that are currently active (in the design, procurement, or construction phase).

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-n7gv-k5yt\".\"capital_projects\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.