City of Berkeley

Close
Author
CityofBerkeley
Description
Streetlights with numerous attributes as captured during LED conversion 2014-2015
Category
City Government
Tags
public works
Rating
Current value: 0 out of 5
Data Provided By
City of Berkeley Public Works
Source Link
https://www.cityofberkeley.info/streetlights/
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:

FACILITYID
facilityid
INSTALLDAT
installdat
WATTAGE
wattage
the_geom
the_geom
CONDITION
condition
LASTUPDATE
lastupdate
ACCOUNT
account
ARM_LENGTH
arm_length
LATITUDE
latitude
LONGITUDE
longitude
DISTRIBUTI
distributi
CITY_FACIL
city_facil
GROUP_
group
HEADS
heads
INSTALLED
installed
PHOTOCELL
photocell
ISSUES_REP
issues_rep
MODEL_NUMB
model_numb
MOUNTING_H
mounting_h
OLD_TARIFF
old_tariff
OLD_TYPE
old_type
VOLTAGE
voltage
OLD_WATTAG
old_wattag
PGE_TARIFF
pge_tariff
PLATE_PHOT
plate_phot
POLE_CONDI
pole_condi
POLE_MATER
pole_mater
RATE
rate
SAID
said
SPID
spid
ADDRESS
address
TWIN_POLE_
twin_pole
UNIQUE_ID
unique_id
MANUFACTUR
manufactur
WARRANTY_D
warranty_d
WARRANTY_P
warranty_p
WARRANTY
warranty
AUDIT_DATE
audit_date

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.