Name: Street Light (all)

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: false

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:
Simple Renderer:
Symbol:
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: 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