Asset Management Executive Summary - State of Good Repair Needs (Capital Eligible)

This dataset contains information for a select number of agencies. It shows the estimated spending necessary to preserve the structural integrity for each of their fixed assets which meet the criteria for capital eligibility. The numbers can be summarized by Agency to match the Asset Management Executive Summary publication. Amounts are rounded to the nearest thousand. The dataset is updated once a year.

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/asset-management-executive-summary-state-of-good-wcpw-9chs\".\"asset_management_executive_summary_state_of_good\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.