View In:   ArcGIS Online Map Viewer

Name: OSD City Street Lights

Display Field: CW_ASSETID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This dataset represents the locations and attributes of streetlight assets owned by incorporated cities and maintained under contract by the Los Angeles County Department of Public Works (DPW), Operational Services Division (OSD). Unlike the County’s standard streetlight inventory, which consists of assets within unincorporated areas, this layer specifically includes streetlights within participating cities such as Lakewood, Carson, La Mirada, and Temple City.Each asset represents an individual streetlight, including its location, ownership, maintenance responsibility, and associated identifiers used for asset management and operational tracking.The dataset supports asset inventory management, maintenance operations, and integration with the County’s Asset Management System (Trimble Unity Maintain / Cityworks), while also enabling coordination with partner cities that retain ownership of the assets.Field Definitions / Attribute Overview:This dataset contains key attribute fields describing each city street light asset. Note that values may be missing as this is an ongoing effort to reconcile and input our asset data. Notable/unique fields for City Street Lights include:CW_ASSETID – Unique asset identifier assigned within the Cityworks / Trimble Unity Maintain system.STATUS – Operational status of the streetlight asset (e.g., Active, Inactive, Proposed).OWNER – Entity that owns the streetlight asset (typically the incorporated city).MAINT_BY – OSD Unit responsible for maintenance.LOCATION – General location description of the streetlight.STREET – Name of the roadway where the streetlight is located.CITY – Name of the incorporated city in which the asset is located.CITYID – Unique identifier assigned by the city for the streetlight asset.CITYPID – City project identifier associated with the asset.C_SUB_AREA – Sub-area or zone within the city used for organizational or operational grouping.EFFTRANSD – Effective transaction date representing when the asset record was last updated or transferred within the system.ICON_ID – Identifier used for map symbology representation.ICON_TXT – Text value associated with map display or labeling.LS – Numeric field associated with rate schedule or internal classificationORIG_INST_DATE – Original installation date of the curb paint asset, when available. LAST_MAINT_DATE – Date the curb paint asset was last maintained, when available.Last updated or update frequency: 2026Loaded May 2026 per Ticket #259688

Copyright Text: Name: Haig Minasian Organization: Los Angeles County Public Works, Operational Services Division Position: Senior GIS Analyst Role: Point of Contact Email: hminasian@dpw.lacounty.gov Address: 900 s Fremont Ave City: Alhambra State: CA Postal Code: 91803 Phone: (626) 458-7104

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 6474524.99965824
YMin: 1748864.64072037
XMax: 6568763.49958362
YMax: 1866436.20671542
Spatial Reference: 102645  (2229)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [112, 168, 0, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• CW_ASSETID ( type: esriFieldTypeString, alias: TUMS Asset ID TUMS Asset ID , editable: true, nullable: true, length: 50, defaultValue: null, modelName: CW_ASSETID_ )
• ASSETNUM ( type: esriFieldTypeString, alias: MMS Asset ID , editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASSETNUM_ )
• LOCATION ( type: esriFieldTypeString, alias: Location , editable: true, nullable: true, length: 250, defaultValue: null, modelName: LOCATION_ )
• STREET ( type: esriFieldTypeString, alias: Street Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STREET )
• STATUS ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 25, defaultValue: null, modelName: STATUS , Coded Values: [UNKNOWN: UNKNOWN] , [ACTIVE: ACTIVE] , [ABANDONED: ABANDONED] , ...3 more... )
• CITY ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CITY )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 254, defaultValue: null, modelName: COMMENTS )
• EFFTRANSD ( type: esriFieldTypeDate, alias: Effective Transport Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EFFTRANSD )
• CITYID ( type: esriFieldTypeString, alias: City ID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: CITYID )
• CITYPID ( type: esriFieldTypeString, alias: City Project ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CITYPID )
• C_SUB_AREA ( type: esriFieldTypeString, alias: City Sub Area, editable: true, nullable: true, length: 10, defaultValue: null, modelName: C_SUB_AREA )
• MAINT_BY ( type: esriFieldTypeString, alias: Maintained By, editable: true, nullable: true, length: 25, defaultValue: null, modelName: MAINT_BY , Coded Values: [OSD Signal Construction: OSD Signal Construction] , [OSD Street Lighting: OSD Street Lighting] , [City: City] )
• OWNER ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 15, defaultValue: null, modelName: OWNER )
• PCA ( type: esriFieldTypeString, alias: Project PCA, editable: true, nullable: true, length: 15, defaultValue: null, modelName: PCA )
• ICON_TXT ( type: esriFieldTypeString, alias: Icon Text, editable: true, nullable: true, length: 6, defaultValue: null, modelName: ICON_TXT )
• ICON_ID ( type: esriFieldTypeString, alias: Icon ID , editable: true, nullable: true, length: 4, defaultValue: null, modelName: ICON_ID_ )
• LS_ ( type: esriFieldTypeDouble, alias: LS , editable: true, nullable: true, defaultValue: null, modelName: LS_ )
• POLE_TYPE ( type: esriFieldTypeString, alias: Pole Type , editable: true, nullable: true, length: 3, defaultValue: null, modelName: POLE_TYPE_ )
• POLE_MODEL ( type: esriFieldTypeString, alias: Pole Model , editable: true, nullable: true, length: 15, defaultValue: null, modelName: POLE_MODEL_ )
• POLE_DETAIL ( type: esriFieldTypeString, alias: Pole Detail , editable: true, nullable: true, length: 250, defaultValue: null, modelName: POLE_DETAIL_ )
• POLE_MANUF ( type: esriFieldTypeString, alias: Pole Manufacturer, editable: true, nullable: true, length: 30, defaultValue: null, modelName: POLE_MANUF )
• POLE_FT ( type: esriFieldTypeDouble, alias: Pole Ft, editable: true, nullable: true, defaultValue: null, modelName: POLE_FT )
• POLE_MAT ( type: esriFieldTypeString, alias: Pole Material, editable: true, nullable: true, length: 30, defaultValue: null, modelName: POLE_MAT )
• BASE_DETAIL ( type: esriFieldTypeString, alias: Base Detail, editable: true, nullable: true, length: 30, defaultValue: null, modelName: BASE_DETAIL )
• LUM_ABBR ( type: esriFieldTypeDouble, alias: Lumen Abbr., editable: true, nullable: true, defaultValue: null, modelName: LUM_ABBR )
• LUMEN ( type: esriFieldTypeDouble, alias: Lumen, editable: true, nullable: true, defaultValue: null, modelName: LUMEN )
• LUM_MANUF ( type: esriFieldTypeString, alias: Lumen Manufacturer, editable: true, nullable: true, length: 30, defaultValue: null, modelName: LUM_MANUF )
• LUMEN_TYPE ( type: esriFieldTypeString, alias: Lumen Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: LUMEN_TYPE )
• LUMEN_STYLE ( type: esriFieldTypeString, alias: Lumen Style, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LUMEN_STYLE )
• LUMEN_PARTNMBR ( type: esriFieldTypeString, alias: Lumen Part Number, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LUMEN_PARTNMBR )
• LAMP_ ( type: esriFieldTypeString, alias: Lamp , editable: true, nullable: true, length: 10, defaultValue: null, modelName: LAMP_ )
• LMP_PREV ( type: esriFieldTypeString, alias: Lamp Prev, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LMP_PREV )
• WATTS ( type: esriFieldTypeDouble, alias: Watts, editable: true, nullable: true, defaultValue: null, modelName: WATTS )
• W_PREV ( type: esriFieldTypeDouble, alias: Watts Prev, editable: true, nullable: true, defaultValue: null, modelName: W_PREV )
• LGT_TYPE ( type: esriFieldTypeString, alias: Light Type, editable: true, nullable: true, length: 1, defaultValue: null, modelName: LGT_TYPE )
• ARM_MODEL ( type: esriFieldTypeString, alias: Arm Model, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ARM_MODEL )
• ARM_DETAIL ( type: esriFieldTypeString, alias: Arm Detail, editable: true, nullable: true, length: 250, defaultValue: null, modelName: ARM_DETAIL )
• ARM_FT ( type: esriFieldTypeDouble, alias: Arm Ft, editable: true, nullable: true, defaultValue: null, modelName: ARM_FT )
• WIRING ( type: esriFieldTypeString, alias: Wiring, editable: true, nullable: true, length: 15, defaultValue: null, modelName: WIRING , Coded Values: [Distribution: Distribution] , [StandAlone: StandAlone] , [OVERHEAD: OVERHEAD] , ...2 more... )
• SPVOLTS ( type: esriFieldTypeString, alias: SP Volts, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SPVOLTS )
• CONDUCTORS ( type: esriFieldTypeString, alias: Conductors, editable: true, nullable: true, length: 15, defaultValue: null, modelName: CONDUCTORS )
• SPTYPE_DESCR ( type: esriFieldTypeString, alias: SP Type Description, editable: true, nullable: true, length: 250, defaultValue: null, modelName: SPTYPE_DESCR )
• DECAL ( type: esriFieldTypeString, alias: Decal , editable: true, nullable: true, length: 10, defaultValue: null, modelName: DECAL_ )
• ORIG_INST_DATE ( type: esriFieldTypeDate, alias: Original Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ORIG_INST_DATE )
• LAST_MAINT_DATE ( type: esriFieldTypeDate, alias: Last Maintained Date , editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_MAINT_DATE_ )
• CREATED_USER ( type: esriFieldTypeString, alias: Created User, editable: false, nullable: true, length: 255, defaultValue: null, modelName: CREATED_USER )
• CREATED_DATE ( type: esriFieldTypeDate, alias: Created Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CREATED_DATE )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: Last Edited User, editable: false, nullable: true, length: 255, defaultValue: null, modelName: LAST_EDITED_USER )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: Last Edited Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LAST_EDITED_DATE )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: OSD City Street Lights
  Description:
  Prototype:
  ORIG_INST_DATE: null
  LAST_MAINT_DATE: null
  CW_ASSETID: null
  ASSETNUM: null
  LOCATION: null
  STREET: null
  STATUS: null
  CITY: null
  COMMENTS: null
  EFFTRANSD: null
  CITYID: null
  CITYPID: null
  C_SUB_AREA: null
  MAINT_BY: null
  OWNER: null
  PCA: null
  ICON_TXT: null
  ICON_ID: null
  LS_: null
  POLE_TYPE: null
  POLE_MODEL: null
  POLE_DETAIL: null
  POLE_MANUF: null
  POLE_FT: null
  POLE_MAT: null
  BASE_DETAIL: null
  LUM_ABBR: null
  LUMEN: null
  LUM_MANUF: null
  LUMEN_TYPE: null
  LUMEN_STYLE: null
  LUMEN_PARTNMBR: null
  LAMP_: null
  LMP_PREV: null
  WATTS: null
  W_PREV: null
  LGT_TYPE: null
  ARM_MODEL: null
  ARM_DETAIL: null
  ARM_FT: null
  WIRING: null
  SPVOLTS: null
  CONDUCTORS: null
  SPTYPE_DESCR: null
  DECAL: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Edit Fields Info:

• Creation Date Field: CREATED_DATE
• Creator Field: CREATED_USER
• Edit Date Field: LAST_EDITED_DATE
• Editor Field: LAST_EDITED_USER

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata