Name: Street Light (Traffic Signal Only)

Display Field: LIGHT_ID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: INTERNAL NOTES:Data Manager: Peter Martin & Jeff GrimesThe GIS Office manages the following field: ASSET_ID. This field is alpha-numeric and based on the SignGridfeature class found on SDE (PW_Signs dataset). The SignGrid digits are represented by the first two letters of the ASSET_ID (ex: "AA") and are an exact match to the GRIDID field in that feature class. The streetlights are number sequentially as they are surveyed (or new ones added) and that number is reflected in the final digits of the ASSET_ID (ex: "BG296"). Important: Any streetlight with a JURISDICTION of "CALTRANS" should NOT receive an actual ASSET_ID. In 2017, Olivia created a script that will auto-generate the ASSET IDs; however some work needed to be done in order to keep the CALTRANS fields from populating.Other information: The dataset contains other fields that, in the past, have represented the streetlight ID. Those fields are "LIGHT_ID" and "OLD_ASSET_ID". Both fields are populated only by Public Works staff. The LIGHT_ID field will no longer have data added to it by any office, however the Public Works staff who are surveying the street lights will add data to the OLD_ASSET_ID field as needed. This information is to be kept per Public Works.

Copyright Text: City of Bakersfield

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: false

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 6202673.6332472265
YMin: 2282361.5366015583
XMax: 6315263.375258893
YMax: 2349295.8016828895
Spatial Reference: 102645  (2229)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: FIXTURE_TYPE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: COLONIAL
  Label: COLONIAL CARRIAGE STYLE - MILL CREEK
  Description: N/A
  Symbol:
  
• Value: ELEC HEAD
  Label: ELECTROLIER HEAD
  Description: N/A
  Symbol:
  
• Value: FL
  Label: FLOOD LIGHT
  Description: N/A
  Symbol:
  
• Value: HEX
  Label: HEXAGONAL POST TOP
  Description: N/A
  Symbol:
  
• Value: HPS
  Label: HPS COBRA HEAD
  Description: N/A
  Symbol:
  
• Value: LED COBRA-A
  Label: LED COBRA
  Description: N/A
  Symbol:
  
• Value: LED COBRA-B
  Label: LED COBRA
  Description: N/A
  Symbol:
  
• Value: LED COBRA-C
  Label: LED COBRA
  Description: N/A
  Symbol:
  
• Value: LED COBRA-D
  Label: LED COBRA
  Description: N/A
  Symbol:
  
• Value: LED COBRA-E
  Label: LED COBRA
  Description: N/A
  Symbol:
  
• Value: LED COBRA HEAD - CREE TYPE A
  Label: LED COBRA
  Description: N/A
  Symbol:
  
• Value: LED COBRA HEAD - CREE TYPE B
  Label: LED COBRA
  Description: N/A
  Symbol:
  
• Value: LED COBRA-OTHER
  Label: LED COBRA
  Description: N/A
  Symbol:
  
• Value: OTHER
  Label: OTHER FIXTURE TYPE
  Description: N/A
  Symbol:
  
• Value: ROUND
  Label: ROUND POST TOP
  Description: N/A
  Symbol:
  
• Value: SQUARE
  Label: SQUARE POST TOP
  Description: N/A
  Symbol:
  
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: false
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: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• LIGHT_ID ( type: esriFieldTypeString, alias: LIGHT_ID, length: 10 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• JURISDICTION ( type: esriFieldTypeString, alias: JURISDICTION, length: 25 , Coded Values: [COB: CITY OF BAKERSFIELD] , [OUTSIDE: OUTSIDE CITY LIMITS] , [KERN: COUNTY OF KERN] , ...5 more... )
• ASSET_ID ( type: esriFieldTypeString, alias: ASSET ID, length: 6 )
• OLD_ASSET_ID ( type: esriFieldTypeString, alias: OLD ASSET ID, length: 15 )
• ASSET_LOC ( type: esriFieldTypeString, alias: ASSET LOCATION, length: 60 )
• POLE_TYPE_ARM ( type: esriFieldTypeString, alias: POLE TYPE ARM, length: 50 , Coded Values: [DEC LONG: DECORATIVE - ACORN LONG ARM] , [DEC SHORT: DECORATIVE - ACORN SHORT ARM] , [TRAFFIC: TRAFFIC SIGNAL] , ...9 more... )
• POLE_TYPE_POST ( type: esriFieldTypeString, alias: POLE POST TOP, length: 50 , Coded Values: [AGG DIRECT: AGGREGATE DIRECT BURY 14FT] , [AGG FLANGE: AGGREGATE FLANGE MOUNT 14FT] , [ALUMINUM FLANGE: ALUMINUM FLANGE MOUNT 14FT] , ...2 more... )
• POLE_TYPE_ELECTROLIERS ( type: esriFieldTypeString, alias: POLE ELECTROLIERS, length: 80 , Coded Values: [BELCOURT AT SEVEN OAKS: BELCOURT AT SEVEN OAKS] , [BR MOHAWK: BRIDGE MOHAWK DECORATIVE ACORN BLACK] , [BR NC DEC: BRIDGE NORTH CHESTER DECORATIVE ACORN] , ...18 more... )
• POLE_TYPE_OTHER ( type: esriFieldTypeString, alias: POLE TYPE OTHER, length: 50 , Coded Values: [MC: MILL CREEK STYLE] , [MLK: MLK BLVD DECORATIVE POLE] , [LOS PORTALES: LOS PORTALES STYLE] , ...3 more... )
• TRAFFIC_SIGNAL ( type: esriFieldTypeString, alias: TRAFFIC SIGNAL, length: 5 , Coded Values: [YES: YES] , [NO: NO] )
• FIXTURE_TYPE ( type: esriFieldTypeString, alias: FIXTURE TYPE, length: 50 , Coded Values: [COLONIAL: COLONIAL CARRIAGE STYLE - MILL CREEK] , [ELEC HEAD: ELECTROLIER HEAD] , [ELEC HEAD (37W): ELECTROLIER HEAD (37W): HOLOPHANE: GPD3 P20 40K MVOLT MS GL3 GN PR7 NL1X1] , ...17 more... )
• TECHNOLOGY ( type: esriFieldTypeString, alias: TECHNOLOGY, length: 20 , Coded Values: [FL: FLUORESCENT] , [HPS: HPS] , [IND: INDUCTION] , ...2 more... )
• WATTAGE ( type: esriFieldTypeString, alias: WATTAGE, length: 15 , Coded Values: [35: 35] , [50: 50] , [70: 70] , ...88 more... )
• VOLTAGE ( type: esriFieldTypeString, alias: VOLTAGE, length: 15 , Coded Values: [120-277V: 120-277V] , [120V: 120V] , [208V: 208V] , ...5 more... )
• SOURCE_TYPE ( type: esriFieldTypeString, alias: SOURCE TYPE, length: 30 , Coded Values: [DISCONNECT: DISCONNECT SWITCH] , [OVERHEAD: OVERHEAD FEED] , [PED NON-MET: PEDESTAL - NON-METERED] , ...6 more... )
• SOURCE_LOC ( type: esriFieldTypeString, alias: SOURCE LOCATION, length: 50 )
• SOURCE_ID ( type: esriFieldTypeString, alias: SOURCE ID NUMBER, length: 20 )
• ASSETID_NUM ( type: esriFieldTypeSmallInteger, alias: ASSETID NUMBER )
• ASSETID_GRIDID ( type: esriFieldTypeString, alias: GRID ID, length: 2 )
• MAINT_DATE ( type: esriFieldTypeDate, alias: LAST MAINT DATE, length: 8 )
• NOTES ( type: esriFieldTypeString, alias: NOTES, length: 400 )
• IMAGE ( type: esriFieldTypeString, alias: IMAGE, length: 75 )
• BILLING_NUM ( type: esriFieldTypeString, alias: PGE BILLING, length: 40 )
• STATUS ( type: esriFieldTypeString, alias: STATUS, length: 30 , Coded Values: [NOT INSPECTED: NOT INSPECTED] , [FOLLOWUP: FOLLOW-UP REQUIRED] , [FOR REVIEW: FOR REVIEW] , ...14 more... )
• METERNUM ( type: esriFieldTypeString, alias: METER NUMBER, length: 15 )
• FIXTURE_TYPE2 ( type: esriFieldTypeString, alias: FIXTURE_TYPE2, length: 50 , Coded Values: [COLONIAL: COLONIAL CARRIAGE STYLE - MILL CREEK] , [ELEC HEAD: ELECTROLIER HEAD] , [ELEC HEAD (37W): ELECTROLIER HEAD (37W): HOLOPHANE: GPD3 P20 40K MVOLT MS GL3 GN PR7 NL1X1] , ...17 more... )
• FIXTURE_TYPE3 ( type: esriFieldTypeString, alias: FIXTURE_TYPE3, length: 50 , Coded Values: [COLONIAL: COLONIAL CARRIAGE STYLE - MILL CREEK] , [ELEC HEAD: ELECTROLIER HEAD] , [ELEC HEAD (37W): ELECTROLIER HEAD (37W): HOLOPHANE: GPD3 P20 40K MVOLT MS GL3 GN PR7 NL1X1] , ...17 more... )
• WATTAGE2 ( type: esriFieldTypeString, alias: WATTAGE2, length: 15 , Coded Values: [35: 35] , [50: 50] , [70: 70] , ...88 more... )
• WATTAGE3 ( type: esriFieldTypeString, alias: WATTAGE3, length: 15 , Coded Values: [35: 35] , [50: 50] , [70: 70] , ...88 more... )
• TECHNOLOGY2 ( type: esriFieldTypeString, alias: TECHNOLOGY2, length: 20 , Coded Values: [FL: FLUORESCENT] , [HPS: HPS] , [IND: INDUCTION] , ...2 more... )
• TECHNOLOGY3 ( type: esriFieldTypeString, alias: TECHNOLOGY3, length: 20 , Coded Values: [FL: FLUORESCENT] , [HPS: HPS] , [IND: INDUCTION] , ...2 more... )
• INSTALL_DATE ( type: esriFieldTypeDate, alias: INSTALL_DATE, length: 8 )
• OLD_WATTAGE ( type: esriFieldTypeString, alias: OLD_WATTAGE, length: 155 , Coded Values: [35: 35] , [50: 50] , [70: 70] , ...88 more... )
• OLD_TECHNOLOGY ( type: esriFieldTypeString, alias: OLD_TECHNOLOGY, length: 20 , Coded Values: [FL: FLUORESCENT] , [HPS: HPS] , [IND: INDUCTION] , ...2 more... )
• RETRO_FIT ( type: esriFieldTypeDate, alias: RETRO_FIT, length: 8 )
• OLD_FIXTURE ( type: esriFieldTypeString, alias: OLD_FIXTURE, length: 50 , Coded Values: [COLONIAL: COLONIAL CARRIAGE STYLE - MILL CREEK] , [ELEC HEAD: ELECTROLIER HEAD] , [ELEC HEAD (37W): ELECTROLIER HEAD (37W): HOLOPHANE: GPD3 P20 40K MVOLT MS GL3 GN PR7 NL1X1] , ...17 more... )
• Picture ( type: esriFieldTypeBlob, alias: Picture )

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

  Iteminfo   Thumbnail   Metadata