View In:   ArcGIS Online Map Viewer

Name: STREET LIGHTS

Display Field: LIGHT_ID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 59999.99999999943

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: Street Light Location
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... )
• Creator ( type: esriFieldTypeString, alias: Creator, editable: false, nullable: true, length: 50, defaultValue: null, modelName: Creator )
• CreationDate ( type: esriFieldTypeDate, alias: CreationDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreationDate )
• LastEditor ( type: esriFieldTypeString, alias: LastEditor, editable: false, nullable: true, length: 50, defaultValue: null, modelName: LastEditor )
• LastEditDate ( type: esriFieldTypeDate, alias: LastEditDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LastEditDate )
• Cellular_Antena ( type: esriFieldTypeString, alias: Cellular Antena, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Cellular_Antena , Coded Values: [YES: YES] , [NO: NO] , [UNK: UNK] )
• Police_Camera ( type: esriFieldTypeString, alias: Police Camera, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Police_Camera , Coded Values: [YES: YES] , [NO: NO] , [UNK: UNK] )
• Shot_Spotter ( type: esriFieldTypeString, alias: Shot Spotter, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Shot_Spotter , Coded Values: [YES: YES] , [NO: NO] , [UNK: UNK] )
• 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: STREET LIGHTS
  Description:
  Prototype:
  BILLING_NUM: null
  ASSET_LOC: null
  FIXTURE_TYPE: null
  Picture: null
  LIGHT_ID: null
  JURISDICTION: null
  ASSET_ID: null
  OLD_ASSET_ID: null
  POLE_TYPE_ARM: TYPE 15-FLANGE
  POLE_TYPE_POST: null
  POLE_TYPE_ELECTROLIERS: null
  POLE_TYPE_OTHER: null
  TRAFFIC_SIGNAL: 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
  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
  Shot_Spotter: null
  Police_Camera: null
  Cellular_Antena: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Create,Update,Uploads,Editing

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   Apply Edits   Add Features   Update Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata