Capital Open Budget
The capital budget is used for one-time infrastructure and improvement projects. The following data provide appropriation-to-date and expenses-to-date metrics for active capital projects, which can be funded through multiple fiscal year capital budgets. These metrics can be drilled down to the department, project, and subproject levels.
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 \"datahub-austintexas-gov/capital-open-budget-ad5y-pg42\".\"capital_open_budget\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.
