Capital Improvements 1996 to 2020

LISTING OF PROJECTS IN THE CITY'S CAPITAL IMPROVEMENTS BUDGET AND THEIR CHARACTERISTICS - Data comes from annual Capital Budgets. Many projects are listed more than once, because they appeared in more than one budget report. It is best to use "Year 1" costs only for each respective budget year to avoid double counting or use of costs that later changed. Projects with no costs in Year 1 should usually be excluded, because they may have never come to fruition. There are also separate items for each project fund. Projects are not listed separately if they were part of multiple-location projects that appeared as a single line item in a budget.

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 \"kcmo/capital-improvements-1996-to-2020-s53g-jzn9\".\"capital_improvements_1996_to_2020\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.