Socrata

Close
Author
Justin Mank
Description
This dataset contains different streetlight features in the City of Santa Monica. This dataset is for reference use only and does not include most recent additions to the street light network.
Category
Public Assets
Tags
street, lights, gis
Rating
Current value: 0 out of 5
Data Provided By
Civil Engineering, Public Works Department
Source Link
http://www.smgov.net/departments/publicworks/civeng.aspx
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:

LIGHTS_
lights
the_geom
the_geom
AREA
area
PERIMETER
perimeter
LIGHTS_ID
lights_id
EH
eh
POLE_ID
pole_id
LAMP
lamp
LUMIN_TYPE
lumin_type
MODEL
model
REFRACT_TY
refract_ty
REFRACT_MT
refract_mt
BALLAST_MF
ballast_mf
BALLAST_MO
ballast_mo
BALLAST_TY
ballast_ty
DATE_INSTA
date_insta
DATE_SERV
date_serv
DATE_INSP
date_insp
FIXTURE_NU
fixture_nu
REMARKS
remarks
METERED
metered
CIRCUIT_NU
circuit_nu
MAP_REFERE
map_refere
POLE_HT_FT
pole_ht_ft
POLE_HT_IN
pole_ht_in
POLE_TYPE
pole_type
POLE_COND
pole_cond
POLE_BASE_
pole_base
POLE_USAGE
pole_usage
ARM_LENGTH
arm_length
ARM_TYPE
arm_type
POLE_MFG
pole_mfg
FINISH
finish
MATERIAL
material
BOLT_PATTE
bolt_patte
POST_TOP
post_top
NUM_FIXTUR
num_fixtur
OWNERSHIP
ownership
ADDRESS
address
ADDDESC
adddesc
STREET
street
NEAREST_IN
nearest_in
NUM_LIGHTS
num_lights
KEYCODE
keycode
CABINET_CO
cabinet_co
CABINET_NU
cabinet_nu
MODEL_NUM
model_num
SERIES
series
MULTIPLE
multiple
METER_NUM
meter_num
CUST_NUM
cust_num
SERV_NUM
serv_num
KWH_USED
kwh_used
WIFI
wifi
STRUCT_TYP
struct_typ
SYMBOL
symbol
PB_MANUFAC
pb_manufac
PB_TYPE
pb_type
PB_MOD_NUM
pb_mod_num
DRIVER_MF
driver_mf
DRIVER_MOD
driver_mod
DRIVER_TYP
driver_typ
PB_WDTH_IN
pb_wdth_in
PB_LGTH_IN
pb_lgth_in
PB_DEP_IN
pb_dep_in
LED_LIGHT
led_light
LED_MANUFA
led_manufa

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.