View In:   ArcGIS Online Map Viewer

Name: Proposed Street Light Location

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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

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

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• LIGHT_ID ( type: esriFieldTypeString, alias: LIGHT_ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LIGHT_ID )
• JURISDICTION ( type: esriFieldTypeString, alias: JURISDICTION, editable: true, nullable: true, length: 25, defaultValue: null, modelName: JURISDICTION , Coded Values: [COB: CITY OF BAKERSFIELD] , [OUTSIDE: OUTSIDE CITY LIMITS] , [KERN: COUNTY OF KERN] , ...5 more... )
• ASSET_ID ( type: esriFieldTypeString, alias: ASSET ID, editable: true, nullable: true, length: 6, defaultValue: null, modelName: ASSET_ID )
• OLD_ASSET_ID ( type: esriFieldTypeString, alias: OLD ASSET ID, editable: true, nullable: true, length: 15, defaultValue: null, modelName: OLD_ASSET_ID )
• ASSET_LOC ( type: esriFieldTypeString, alias: ASSET LOCATION, editable: true, nullable: true, length: 60, defaultValue: null, modelName: ASSET_LOC )
• POLE_TYPE_ARM ( type: esriFieldTypeString, alias: POLE TYPE ARM, editable: true, nullable: true, length: 50, defaultValue: TYPE 15-FLANGE, modelName: POLE_TYPE_ARM , 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: POLE_TYPE_POST , 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, editable: true, nullable: true, length: 80, defaultValue: null, modelName: POLE_TYPE_ELECTROLIERS , 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: POLE_TYPE_OTHER , 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, editable: true, nullable: true, length: 5, defaultValue: null, modelName: TRAFFIC_SIGNAL , Coded Values: [YES: YES] , [NO: NO] )
• FIXTURE_TYPE ( type: esriFieldTypeString, alias: FIXTURE TYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FIXTURE_TYPE , 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, editable: true, nullable: true, length: 20, defaultValue: LED, modelName: TECHNOLOGY , Coded Values: [FL: FLUORESCENT] , [HPS: HPS] , [IND: INDUCTION] , ...2 more... )
• WATTAGE ( type: esriFieldTypeString, alias: WATTAGE, editable: true, nullable: true, length: 15, defaultValue: null, modelName: WATTAGE , Coded Values: [35: 35] , [50: 50] , [70: 70] , ...88 more... )
• VOLTAGE ( type: esriFieldTypeString, alias: VOLTAGE, editable: true, nullable: true, length: 15, defaultValue: null, modelName: VOLTAGE , Coded Values: [120-277V: 120-277V] , [120V: 120V] , [208V: 208V] , ...5 more... )
• SOURCE_TYPE ( type: esriFieldTypeString, alias: SOURCE TYPE, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SOURCE_TYPE , Coded Values: [DISCONNECT: DISCONNECT SWITCH] , [OVERHEAD: OVERHEAD FEED] , [PED NON-MET: PEDESTAL - NON-METERED] , ...6 more... )
• SOURCE_LOC ( type: esriFieldTypeString, alias: SOURCE LOCATION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SOURCE_LOC )
• SOURCE_ID ( type: esriFieldTypeString, alias: SOURCE ID NUMBER, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SOURCE_ID )
• ASSETID_NUM ( type: esriFieldTypeSmallInteger, alias: ASSETID NUMBER, editable: true, nullable: true, defaultValue: null, modelName: ASSETID_NUM )
• ASSETID_GRIDID ( type: esriFieldTypeString, alias: GRID ID, editable: true, nullable: true, length: 2, defaultValue: null, modelName: ASSETID_GRIDID )
• MAINT_DATE ( type: esriFieldTypeDate, alias: LAST MAINT DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MAINT_DATE )
• NOTES ( type: esriFieldTypeString, alias: NOTES, editable: true, nullable: true, length: 400, defaultValue: null, modelName: NOTES )
• IMAGE ( type: esriFieldTypeString, alias: IMAGE, editable: true, nullable: true, length: 75, defaultValue: null, modelName: IMAGE )
• BILLING_NUM ( type: esriFieldTypeString, alias: PGE BILLING, editable: true, nullable: true, length: 40, defaultValue: null, modelName: BILLING_NUM )
• STATUS ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: true, length: 30, defaultValue: NOT INSPECTED, modelName: STATUS , Coded Values: [NOT INSPECTED: NOT INSPECTED] , [FOLLOWUP: FOLLOW-UP REQUIRED] , [FOR REVIEW: FOR REVIEW] , ...14 more... )
• METERNUM ( type: esriFieldTypeString, alias: METER NUMBER, editable: true, nullable: true, length: 15, defaultValue: null, modelName: METERNUM )
• FIXTURE_TYPE2 ( type: esriFieldTypeString, alias: FIXTURE_TYPE2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FIXTURE_TYPE2 , 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FIXTURE_TYPE3 , 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, editable: true, nullable: true, length: 15, defaultValue: null, modelName: WATTAGE2 , Coded Values: [35: 35] , [50: 50] , [70: 70] , ...88 more... )
• WATTAGE3 ( type: esriFieldTypeString, alias: WATTAGE3, editable: true, nullable: true, length: 15, defaultValue: null, modelName: WATTAGE3 , Coded Values: [35: 35] , [50: 50] , [70: 70] , ...88 more... )
• TECHNOLOGY2 ( type: esriFieldTypeString, alias: TECHNOLOGY2, editable: true, nullable: true, length: 20, defaultValue: null, modelName: TECHNOLOGY2 , Coded Values: [FL: FLUORESCENT] , [HPS: HPS] , [IND: INDUCTION] , ...2 more... )
• TECHNOLOGY3 ( type: esriFieldTypeString, alias: TECHNOLOGY3, editable: true, nullable: true, length: 20, defaultValue: null, modelName: TECHNOLOGY3 , Coded Values: [FL: FLUORESCENT] , [HPS: HPS] , [IND: INDUCTION] , ...2 more... )
• INSTALL_DATE ( type: esriFieldTypeDate, alias: INSTALL_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALL_DATE )
• OLD_WATTAGE ( type: esriFieldTypeString, alias: OLD_WATTAGE, editable: true, nullable: true, length: 155, defaultValue: null, modelName: OLD_WATTAGE , Coded Values: [35: 35] , [50: 50] , [70: 70] , ...88 more... )
• OLD_TECHNOLOGY ( type: esriFieldTypeString, alias: OLD_TECHNOLOGY, editable: true, nullable: true, length: 20, defaultValue: null, modelName: OLD_TECHNOLOGY , Coded Values: [FL: FLUORESCENT] , [HPS: HPS] , [IND: INDUCTION] , ...2 more... )
• RETRO_FIT ( type: esriFieldTypeDate, alias: RETRO_FIT, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RETRO_FIT )
• OLD_FIXTURE ( type: esriFieldTypeString, alias: OLD_FIXTURE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OLD_FIXTURE , 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, editable: true, nullable: true, defaultValue: null, modelName: Picture )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: Proposed Street Light Location
  Description:
  Prototype:
  Picture: null
  LIGHT_ID: null
  JURISDICTION: null
  ASSET_ID: null
  OLD_ASSET_ID: null
  ASSET_LOC: null
  POLE_TYPE_ARM: TYPE 15-FLANGE
  POLE_TYPE_POST: null
  POLE_TYPE_ELECTROLIERS: null
  POLE_TYPE_OTHER: null
  TRAFFIC_SIGNAL: null
  FIXTURE_TYPE: null
  TECHNOLOGY: LED
  WATTAGE: null
  VOLTAGE: null
  SOURCE_TYPE: null
  SOURCE_LOC: null
  SOURCE_ID: null
  ASSETID_NUM: null
  ASSETID_GRIDID: null
  MAINT_DATE: null
  NOTES: null
  IMAGE: null
  BILLING_NUM: null
  STATUS: NOT INSPECTED
  METERNUM: null
  FIXTURE_TYPE2: null
  FIXTURE_TYPE3: null
  WATTAGE2: null
  WATTAGE3: null
  TECHNOLOGY2: null
  TECHNOLOGY3: null
  INSTALL_DATE: null
  OLD_WATTAGE: null
  OLD_TECHNOLOGY: null
  RETRO_FIT: null
  OLD_FIXTURE: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: CreationDate
• Creator Field: Creator
• Edit Date Field: LastEditDate
• Editor Field: LastEditor

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

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