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 
"}
EOF

See the Splitgraph documentation for more information.