Community Energy

Annual natural gas and electricity consumption for all meters within the Berkeley city limits, except those on the UCB and LBNL campus. Categorized by sector.

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 \"cityofberkeley-info/community-energy-jfw3-qg7m\".\"community_energy\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.