NYC Climate Budgeting Report: New Climate Investments And Reallocations In Executive Plan

List of capital and expense programs with a positive climate impact that are newly funded or reallocated in the current budget, in millions of dollars. Expense data is only reported for one year. Capital data is reported for the plan window. This dataset will be updated once per year with the release of the Executive Budget.

This data can be used to create visualizations similar to the tables 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-new-climate-yvbp-zcpt\".\"nyc_climate_budgeting_report_new_climate\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.