CorStat - CAP Tracking by Permit/Project
Data is extracted from TRAKiT, a web-based system that tracks building permits and projects initialized within the City of Corona. Total greenhouse gas reductions measured in CO2e measured by specific permit/project. Permits and projects are measured by the date they were applied for. Data is extracted from the City's permitting software, TRAKiT and is automatically updated and imported into CorStat on a nightly basis.
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 \"corstat-coronaca-gov/corstat-cap-tracking-by-permitproject-ac64-jjxt\".\"corstat_cap_tracking_by_permitproject\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.
