Name: Street Light Fixture

Display Field: BADGEID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Light fixture, or lamp types found on poles in the City of San Jose, CA. The city is working to replace all lamps in the city from the yellow low pressure sodium (LPS) to white light emitting diodes (LED) to improve visibility and cost.This layer is updated on a weekly basis. The data includes records of removed streetlights as historical reference. It also includes around 4000 fixture records introduced from DOT's maintenance database. These maintenance records are incomplete, contains no location and still needs to be reconciled. Please be mindful when conducting queries.

Copyright Text: City of San Jose

Default Visibility: false

Max Result Window: N/A

Max Record Count: 2000

Standard Max Record Count No Geometry: 32000

Max Record Count Factor: 1

Standard MaxRecord Count: 32000

Tile Max Record Count: 8000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 6115510.951385334
YMin: 1885548.3689846396
XMax: 6215267.2021081
YMax: 1991158.2637355775
Spatial Reference: 102643  (2227)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: LEDSTATUS
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 0
  Label: LPS
  Description: N/A
  Symbol:
  
• Value: 1
  Label: LED
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports Result Pagination Token: false
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Cache Hint: false
Supports Query With Current User: true
Supports Query With Result Type: true

HasZ: false

HasM: false

Has Attachments: false

Has Last Edit Time: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: N/A

Fields:

• OBJECTID ( nullable: false, alias: OBJECTID, type: esriFieldTypeOID )
• FACILITYID ( nullable: true, length: 20, alias: Facility Identifier, type: esriFieldTypeString )
• INTID ( nullable: true, alias: Integer ID, type: esriFieldTypeInteger )
• BADGEID ( nullable: true, length: 20, alias: Pole Number, type: esriFieldTypeString )
• IMBADGE ( nullable: true, length: 20, alias: IM Pole Number, type: esriFieldTypeString )
• LIGHTLETTER ( nullable: true, length: 10, alias: Light Letter, type: esriFieldTypeString , Coded Values: [Z: Z] , [Y: Y] , [X: X] , ...23 more... )
• LOCDESC ( nullable: true, length: 255, alias: Location Description, type: esriFieldTypeString )
• LIGHTFIXTURETYPE ( nullable: true, length: 30, alias: Light Fixture Type, type: esriFieldTypeString , Coded Values: [AIRPORT: AIRPORT] , [BANNER LIGHT: BANNER LIGHT] , [CANE: CANE] , ...25 more... )
• LAMPTYPE ( nullable: true, length: 20, alias: Lamp Type, type: esriFieldTypeString , Coded Values: [10 Watt LPS: 10 Watt LPS] , [100 Watt HPS: 100 Watt HPS] , [100 Watt MH: 100 Watt MH] , ...19 more... )
• MOUNTTYPE ( nullable: true, length: 20, alias: Mount Type, type: esriFieldTypeString , Coded Values: [MAST ARM: MAST ARM] , [POST TOP: POST TOP] , [SOFFIT: SOFFIT] , ...3 more... )
• LIGHTSTATUS ( nullable: true, length: 15, alias: Light Status, type: esriFieldTypeString , Coded Values: [EXISTING: EXISTING] , [INVESTIGATION: INVESTIGATION] , [REMOVED: REMOVED] )
• LUMINAIRECONTROLLER ( nullable: true, length: 40, alias: Luminaire Controller, type: esriFieldTypeString , Coded Values: [CABINET: CABINET] , [ITRON: ITRON] , [NETWORK ID: NETWORK ID] , ...9 more... )
• POLEUSE ( nullable: true, length: 50, alias: Pole Use, type: esriFieldTypeString , Coded Values: [ST LIGHT ONLY: ST LIGHT ONLY] , [TRAFFIC SIGNAL ONLY: TRAFFIC SIGNAL ONLY] , [PEDESTRIAN LIGHT: PEDESTRIAN LIGHT] , ...3 more... )
• VOLTAGE ( nullable: true, alias: Voltage, type: esriFieldTypeInteger , Coded Values: [120: 120] , [130: 130] , [208: 208] , ...4 more... )
• OWNERSHIP ( nullable: true, length: 50, alias: Ownership, type: esriFieldTypeString , Coded Values: [CALTRAN: CALTRAN] , [COUNTY: COUNTY] , [CSJ-AIR: CSJ-AIR] , ...8 more... )
• SECOID ( nullable: true, alias: SECO ID, type: esriFieldTypeInteger )
• ZIGBEEID ( nullable: true, length: 50, alias: ZIGBEE ID, type: esriFieldTypeString )
• LEDMANUFACTURER ( nullable: true, length: 50, alias: LED Manufacturer, type: esriFieldTypeString , Coded Values: [Cooper: Cooper] , [CREE: CREE] , [EIKO: EIKO] , ...16 more... )
• LEDMODELNAME ( nullable: true, length: 100, alias: LED Model Name, type: esriFieldTypeString , Coded Values: [AR13-48N-MV-NW-3-DB1-060-PCR7-CR-WL: AR13-48N-MV-NW-3-DB1-060-PCR7-CR-WL] , [AR13-48N-MV-NW-3-DB1-100-PCR7-CR-WL: AR13-48N-MV-NW-3-DB1-100-PCR7-CR-WL] , [AR13-48N-MV-NW-3-DB1-120-PCR7-CR-WL: AR13-48N-MV-NW-3-DB1-120-PCR7-CR-WL] , ...267 more... )
• LEDCOMMWATTAGE ( nullable: true, alias: LED Commisioned Wattage, type: esriFieldTypeDouble )
• LEDMAXWATTAGE ( nullable: true, alias: LED Max Wattage, type: esriFieldTypeDouble )
• LEDMODELID ( nullable: true, length: 10, alias: LED Model ID, type: esriFieldTypeString , Coded Values: [A: A] , [A1: A1] , [A3: A3] , ...83 more... )
• LEDINSTALDATE ( nullable: true, length: 8, alias: LED Install Date, type: esriFieldTypeDate )
• FIRSTCOMDATE ( nullable: true, length: 8, alias: First Communication Date, type: esriFieldTypeDate )
• LEDSTATUS ( nullable: true, alias: LED Status, type: esriFieldTypeInteger , Coded Values: [0: 0] , [1: 1] )
• LEDWARRANTYEXPIRATIONDATE ( nullable: true, length: 8, alias: LED warranty expiration date, type: esriFieldTypeDate )
• LEDCONVERSIONDATE ( nullable: true, length: 8, alias: LED conversion date, type: esriFieldTypeDate )
• PROJECT ( nullable: true, length: 100, alias: Project Name, type: esriFieldTypeString )
• GROUPING ( nullable: true, length: 50, alias: Grouping, type: esriFieldTypeString , Coded Values: [Collector: Collector] , [Collector High Ped: Collector High Ped] , [Collector Med Ped: Collector Med Ped] , ...14 more... )
• SLNOTES ( nullable: true, length: 255, alias: SL Program Notes, type: esriFieldTypeString )
• SHOPID ( nullable: true, length: 10, alias: Shop ID, type: esriFieldTypeString )
• PGEITEMCODE ( nullable: true, length: 20, alias: PGE Item Code, type: esriFieldTypeString , Coded Values: [HPS-Q: HPS-Q] , [LED: LED] , [S-H-100: S-H-100] , ...96 more... )
• PGESPID ( nullable: true, length: 20, alias: PGESPID, type: esriFieldTypeString )
• PGESAID ( nullable: true, length: 15, alias: PGE SA ID, type: esriFieldTypeString )
• PGERATE ( nullable: true, length: 15, alias: PG&E Rate, type: esriFieldTypeString , Coded Values: [LS1-A: LS1-A] , [LS1-E: LS1-E] , [LS1-F: LS1-F] , ...4 more... )
• ELESERVICE ( nullable: true, length: 20, alias: Electric Service, type: esriFieldTypeString , Coded Values: [OVERHEAD: OVERHEAD] , [UNDERGROUND: UNDERGROUND] , [OTHER: OTHER] , ...1 more... )
• COCOMMENT ( nullable: true, length: 255, alias: PW Connect Order Comment, type: esriFieldTypeString )
• CONUMBER ( nullable: true, length: 10, alias: PW Connect Order Number, type: esriFieldTypeString )
• COLOCATION ( nullable: true, length: 100, alias: PW Files Location, type: esriFieldTypeString )
• COHISTORY ( nullable: true, length: 255, alias: PW Connect Order History, type: esriFieldTypeString )
• LATITUDE ( nullable: true, alias: Latitude, type: esriFieldTypeDouble )
• LONGITUDE ( nullable: true, alias: Longitude, type: esriFieldTypeDouble )
• HYPERLINK ( nullable: true, length: 100, alias: Image, type: esriFieldTypeString )
• CREATIONDATE ( nullable: true, length: 8, alias: Creation Date, type: esriFieldTypeDate )
• LASTUPDATE ( nullable: true, length: 8, alias: Last Update Date, type: esriFieldTypeDate )
• SHAPE ( nullable: true, alias: Shape, type: esriFieldTypeGeometry )
• POLEJOINSTATUS ( nullable: true, length: 50, alias: Pole Join Status, type: esriFieldTypeString )
• POLEJOINDISTANCE ( nullable: true, alias: Pole Join Distance, type: esriFieldTypeDouble )
• ISDUPLICATE ( nullable: true, length: 5, alias: Is Duplicate, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• FMEDATE ( nullable: true, length: 8, alias: Date FME Last Run, type: esriFieldTypeDate )
• NOTES ( nullable: true, length: 255, alias: IM Notes, type: esriFieldTypeString )
• SHIELDDIRECTION ( nullable: true, length: 10, alias: Shield Direction, type: esriFieldTypeString , Coded Values: [Front: Front] , [Back: Back] , [Cul-de-sac: Cul-de-sac] , ...1 more... )
• ECOBRASTATUS ( nullable: true, length: 40, alias: ECobra Status, type: esriFieldTypeString , Coded Values: [Under Warranty: Under Warranty] , [Post Warranty: Post Warranty] , [Post Warranty - Replaced: Post Warranty - Replaced] , ...1 more... )
• PGEITEMCODEHISTORIC ( nullable: true, length: 20, alias: PGE Item Code Historic, type: esriFieldTypeString )
• LUMENS ( nullable: true, alias: Lumen Output, type: esriFieldTypeInteger )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata