View In:   ArcGIS Online Map Viewer

Name: Streetlight Poles

Display Field: uniqueid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Provides approximate locations of streetlights owned and maintained by the City of Salinas. Streetlight types, pole types, pole IDs and other ancillary attributes are provided. 

Service Item Id: d461f50f6bca4326bba6436fcf5bf884

Copyright Text: Originator: City of Salinas, Public Works Department, GIS Division

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: 5774581.297147885
YMin: 2114701.86096856
XMax: 5802098.039358392
YMax: 2161149.1968794763
Spatial Reference: 102644  (2228)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: pole_material
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: ALUMINUM
  Label: ALUMINUM
  Description: N/A
  Symbol:
  
• Value: CAST IRON
  Label: CAST IRON
  Description: N/A
  Symbol:
  
• Value: GALVANIZED
  Label: GALVANIZED
  Description: N/A
  Symbol:
  
• Value: STEEL
  Label: STEEL
  Description: N/A
  Symbol:
  
• Value: WOOD
  Label: WOOD
  Description: N/A
  Symbol:
  
• Value: UNKNOWN
  Label: UNKNOWN
  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 TrueCurve: false
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: true
Supports Query With LOD Spatial Reference: true
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: pole_material

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: globalid, alias: GlobalID )
• uniqueid ( nullable: true, editable: true, defaultValue: null, length: 40, type: esriFieldTypeString, modelName: uniqueid, alias: UniqueID )
• asset_id ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: asset_id, alias: PG&E Badge Number )
• location_desc ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: location_desc, alias: Location/Description )
• pole_material ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: pole_material, alias: Pole Material )
• pole_height_ft ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: pole_height_ft, alias: Pole Height (ft) )
• mast_arm_length_ft ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: mast_arm_length_ft, alias: Mast Arm Length (ft) )
• pole_use ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: pole_use, alias: Pole Use )
• luminaire_model ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: luminaire_model, alias: Luminaire Model )
• lamp_wattage ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: lamp_wattage, alias: Lamp Wattage )
• is_energized ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: is_energized, alias: Is Energized )
• fixture_seq ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: fixture_seq, alias: Fixture Sequence )
• status ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: status, alias: Status )
• date_installed ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: date_installed, alias: Date Installed )
• comments_city ( nullable: true, editable: true, defaultValue: null, length: 4000, type: esriFieldTypeString, modelName: comments_city, alias: Comments )
• ownership ( nullable: true, editable: true, defaultValue: City of Salinas, length: 255, type: esriFieldTypeString, modelName: ownership, alias: ownership , Coded Values: [City of Salinas: City of Salinas] , [CalTrans: CalTrans] , [Monterey County: Monterey County] , ...2 more... )
• maintenace ( nullable: true, editable: true, defaultValue: City of Salinas, length: 255, type: esriFieldTypeString, modelName: maintenace, alias: maintenace , Coded Values: [City of Salinas: City of Salinas] , [CalTrans: CalTrans] , [Monterey County: Monterey County] , ...2 more... )
• traffic_sig_mount ( nullable: true, editable: true, defaultValue: 0, type: esriFieldTypeSmallInteger, modelName: traffic_sig_mount, alias: traffic_sig_mount , Coded Values: [1: Yes] , [0: No] )

Types:

ID: ALUMINUM
Name: ALUMINUM
Domains:
• ownership:
  Inherited
• traffic_sig_mount:
  Inherited
• activeflag:
  Inherited
• maintenace:
  Inherited
Templates:
• Name: ALUMINUM
  Description:
  Prototype:
  comments_city: null
  luminaire_model: null
  pole_material: ALUMINUM
  asset_id: null
  mast_arm_length_ft: null
  lamp_wattage: null
  maintenace: City of Salinas
  fixture_seq: null
  ownership: City of Salinas
  date_installed: null
  pole_height_ft: null
  traffic_sig_mount: 0
  location_desc: null
  is_energized: null
  uniqueid: null
  pole_use: null
  status: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: CAST IRON
Name: CAST IRON
Domains:
• ownership:
  Inherited
• traffic_sig_mount:
  Inherited
• activeflag:
  Inherited
• maintenace:
  Inherited
Templates:
• Name: CAST IRON
  Description:
  Prototype:
  comments_city: null
  luminaire_model: null
  pole_material: CAST IRON
  asset_id: null
  mast_arm_length_ft: null
  lamp_wattage: null
  maintenace: City of Salinas
  fixture_seq: null
  ownership: City of Salinas
  date_installed: null
  pole_height_ft: null
  traffic_sig_mount: 0
  location_desc: null
  is_energized: null
  uniqueid: null
  pole_use: null
  status: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: GALVANIZED
Name: GALVANIZED
Domains:
• ownership:
  Inherited
• traffic_sig_mount:
  Inherited
• activeflag:
  Inherited
• maintenace:
  Inherited
Templates:
• Name: GALVANIZED
  Description:
  Prototype:
  comments_city: null
  luminaire_model: null
  pole_material: GALVANIZED
  asset_id: null
  mast_arm_length_ft: null
  lamp_wattage: null
  maintenace: City of Salinas
  fixture_seq: null
  ownership: City of Salinas
  date_installed: null
  pole_height_ft: null
  traffic_sig_mount: 0
  location_desc: null
  is_energized: null
  uniqueid: null
  pole_use: null
  status: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: STEEL
Name: STEEL
Domains:
• ownership:
  Inherited
• traffic_sig_mount:
  Inherited
• activeflag:
  Inherited
• maintenace:
  Inherited
Templates:
• Name: STEEL
  Description:
  Prototype:
  comments_city: null
  luminaire_model: null
  pole_material: STEEL
  asset_id: null
  mast_arm_length_ft: null
  lamp_wattage: null
  maintenace: City of Salinas
  fixture_seq: null
  ownership: City of Salinas
  date_installed: null
  pole_height_ft: null
  traffic_sig_mount: 0
  location_desc: null
  is_energized: null
  uniqueid: null
  pole_use: null
  status: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: WOOD
Name: WOOD
Domains:
• ownership:
  Inherited
• traffic_sig_mount:
  Inherited
• activeflag:
  Inherited
• maintenace:
  Inherited
Templates:
• Name: WOOD
  Description:
  Prototype:
  comments_city: null
  luminaire_model: null
  pole_material: WOOD
  asset_id: null
  mast_arm_length_ft: null
  lamp_wattage: null
  maintenace: City of Salinas
  fixture_seq: null
  ownership: City of Salinas
  date_installed: null
  pole_height_ft: null
  traffic_sig_mount: 0
  location_desc: null
  is_energized: null
  uniqueid: null
  pole_use: null
  status: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: UNKNOWN
Name: UNKNOWN
Domains:
• ownership:
  Inherited
• traffic_sig_mount:
  Inherited
• activeflag:
  Inherited
• maintenace:
  Inherited
Templates:
• Name: UNKNOWN
  Description:
  Prototype:
  comments_city: null
  luminaire_model: null
  pole_material: UNKNOWN
  asset_id: null
  mast_arm_length_ft: null
  lamp_wattage: null
  maintenace: City of Salinas
  fixture_seq: null
  ownership: City of Salinas
  date_installed: null
  pole_height_ft: null
  traffic_sig_mount: 0
  location_desc: null
  is_energized: null
  uniqueid: null
  pole_use: null
  status: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Extract

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata