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.
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.