Municipal Building Energy Use

This dataset contains the energy consumption for every building that is owned and occupied by the City of Norfolk. The dataset tracks electricity, natural gas, and water consumption by meter; most energy meters are tied to one building. The energy consumption data is collected in EnergyCAP, a system of record that tracks Norfolk’s energy management and utility bill accounting. This data originates from monthly utility bills submitted by Norfolk’s energy vendors. In this dataset, users can explore the amount of electricity, natural gas and propane consumed monthly by municipal buildings in Norfolk as well as follow energy expenditure trends. The data is updated weekly.

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 \"norfolk-gov/municipal-building-energy-use-9v4p-ntch\".\"municipal_building_energy_use\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.