City of Berkeley

Close
Author
Energy Office
Description
Energy and water data by site.
Category
Natural Resources
Tags
energy, water, budget
Rating
Current value: 0 out of 5
Data Provided By
PG&E and EBMUD
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

Year
year
Department
department
idsite
idsite
Site
site
End Use
end_use
Annual Cost
annual_cost
Annual Water (Gallons)
annual_water_gallons
Annual Elec (kWh)
annual_elec_kwh
Annual Nat Gas (Therms)
annual_nat_gas_therms
Annual Energy (kWheq)
annual_energy_kwheq
Location 1
location_1
Zip Codes
:@computed_region_5s6d_2f32
Council Districts_uniq_prepend
:@computed_region_b3wi_w8ix
Council Districts_from_hg3u_n7v4
:@computed_region_fhmw_rucx
Council Districts_from_c8zs_8y7x
:@computed_region_u3y2_d2ws
Council Districts
:@computed_region_x3q3_gi3e
Census Tracts
:@computed_region_5bih_7r3y
Police Beats
:@computed_region_3ini_iehf

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.