NYC Climate Budgeting Report: Climate Alignment Assessment and Capital Climate Investments

This dataset rates all projects in the capital budget with over $50,000 with their climate alignment and categorizes investments that are related to climate. Amounts are in thousands. This dataset will be updated once a year during the Executive Budget.

This data can be used to create visualizations similar to the charts featured in the Climate Investments section of the FY25 New York City Climate Budgeting publication (https://www.nyc.gov/assets/omb/downloads/pdf/exec24-nyccb.pdf).

You can find the complete collection of Climate Budget data by <a href="https://data.cityofnewyork.us/browse?Data-Collection_Data-Collection=Climate+Budgeting" rel="noopener noreferrer" target="_blank">clicking here.</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/nyc-climate-budgeting-report-climate-alignment-c99a-c5ux\".\"nyc_climate_budgeting_report_climate_alignment\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.