View In:   ArcGIS Online map viewer

Name: Streetlights

Display Field: STREET_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Street light pole locations in the City of Rancho Cordova, including City-owned street lights and street lights owned by other agencies. This data is used by city staff to inventory and help manage street lights for maintenance and billing purposes.This latest version of the street light data was obtained from Sacramento County GIS in July 2012 when the City began maintaining street light inventories. The data was supplemented by the Rancho Cordova Public Works department and consultants working on the City's street light retrofit project. This work has added additional information such as fixture, lamp type and wattage for all lights. The data is updated as needed and subject to change without notice.

Definition Expression: N/A

Copyright Text: City of Rancho Cordova and Sacramento County GIS.

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: 6751440.009711936
YMin: 1945616.0447811931
XMax: 6794090.697048187
YMax: 1992745.371126026
Spatial Reference: 102642  (2226)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [112, 153, 0, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label:
Description:
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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID , editable: false , nullable: false )
• LAMP_HT ( type: esriFieldTypeDouble , alias: LAMP_HT , editable: true , nullable: true )
• FIX_TYPE ( type: esriFieldTypeString , alias: FIX_TYPE , editable: true , nullable: true , length: 254 , Coded Values: [Cobra: Cobra] , [Other: Other] , [Pendant: Pendant] , ...3 more... )
• LAMP_TYPE ( type: esriFieldTypeString , alias: LAMP_TYPE , editable: true , nullable: true , length: 254 , Coded Values: [HE: High Efficiency HPS] , [HS: High Pressure Sodium] , [LED: LED] , ...4 more... )
• LAMP_WATT ( type: esriFieldTypeDouble , alias: LAMP_WATT , editable: true , nullable: true )
• DECORATIVE ( type: esriFieldTypeString , alias: DECORATIVE , editable: true , nullable: true , length: 254 , Coded Values: [Yes: Yes] , [No: No] )
• FXT_QTY ( type: esriFieldTypeSmallInteger , alias: FXT_QTY , editable: true , nullable: true , Range: [0, 5] )
• PEC ( type: esriFieldTypeString , alias: PEC , editable: true , nullable: true , length: 254 , Coded Values: [Yes: Yes] , [No: No] )
• LOCATION ( type: esriFieldTypeString , alias: LOCATION , editable: true , nullable: true , length: 254 )
• STREET_NUMBR ( type: esriFieldTypeString , alias: STREET NUMBR , editable: true , nullable: true , length: 254 )
• STREET_NAME ( type: esriFieldTypeString , alias: STREET NAME , editable: true , nullable: true , length: 254 )
• MAINTAINED ( type: esriFieldTypeString , alias: MAINTAINED , editable: true , nullable: true , length: 254 , Coded Values: [RC: Rancho Cordova] , [COUNTY: Sacramento County] , [SMUD: SMUD] , ...3 more... )
• POLE_CATEGORY ( type: esriFieldTypeString , alias: POLE_CATEGORY , editable: true , nullable: true , length: 254 , Coded Values: [SAFETY: Safety] , [NON SAFETY: Non Safety] )
• POLE_MATERIAL ( type: esriFieldTypeString , alias: POLE_MATERIAL , editable: true , nullable: true , length: 254 , Coded Values: [G: Galvanized Steel] , [P: Painted Steel] , [PSD: Painted Steel Decorative] , ...5 more... )
• POWER_SUPPLY ( type: esriFieldTypeString , alias: POWER_SUPPLY , editable: true , nullable: true , length: 254 , Coded Values: [SERVICE CAN: Service Can] , [INDIVIDUAL FEED: Individual Feed] )
• SERVICE_CAN ( type: esriFieldTypeString , alias: SERVICE_CAN , editable: true , nullable: true , length: 254 )
• POLE_COMMENT ( type: esriFieldTypeString , alias: POLE_COMMENT , editable: true , nullable: true , length: 254 )
• OWNER ( type: esriFieldTypeString , alias: OWNER , editable: true , nullable: true , length: 254 , Coded Values: [RC: Rancho Cordova] , [COUNTY: Sacramento County] , [SMUD: SMUD] , ...6 more... )
• COMPTYPE ( type: esriFieldTypeDouble , alias: COMPTYPE , editable: true , nullable: true )
• COMPKEY ( type: esriFieldTypeDouble , alias: COMPKEY , editable: true , nullable: true )
• DISTYPE ( type: esriFieldTypeString , alias: DISTYPE , editable: true , nullable: true , length: 254 )
• PLANID ( type: esriFieldTypeString , alias: PLANID , editable: true , nullable: true , length: 254 )
• BANNER_MOUNT ( type: esriFieldTypeString , alias: BANNER_MOUNT , editable: true , nullable: true , length: 254 , Coded Values: [Y: YES] , [N: NO] , [U: UNKNOWN] , ...2 more... )
• BANNER_TYPE ( type: esriFieldTypeString , alias: BANNER_TYPE , editable: true , nullable: true , length: 254 , Coded Values: [CORC: City Of Rancho Cordova] , [AAC: All American City] , [CCA: California Capital Airshow] , ...4 more... )
• POINT_X ( type: esriFieldTypeDouble , alias: POINT_X , editable: true , nullable: true )
• POINT_Y ( type: esriFieldTypeDouble , alias: POINT_Y , editable: true , nullable: true )
• STREET_TYPE ( type: esriFieldTypeString , alias: STREET_TYPE , editable: true , nullable: true , length: 25 , Coded Values: [Arterial: Arterial] , [Collector: Collector] , [Local: Local] , ...3 more... )
• PNUM ( type: esriFieldTypeString , alias: PNUM , editable: true , nullable: true , length: 10 )
• ID ( type: esriFieldTypeString , alias: ID , editable: true , nullable: true , length: 10 )
• UNITID ( type: esriFieldTypeString , alias: UNITID , editable: true , nullable: true , length: 10 )
• CREATED_BY ( type: esriFieldTypeString , alias: CREATED BY , editable: false , nullable: true , length: 35 )
• CREATE_DATE ( type: esriFieldTypeDate , alias: CREATE DATE , editable: false , nullable: true , length: 8 )
• EDITED_BY ( type: esriFieldTypeString , alias: EDITED BY , editable: false , nullable: true , length: 35 )
• EDIT_DATE ( type: esriFieldTypeDate , alias: EDIT DATE , editable: false , nullable: true , length: 8 )
• LAMP_DISTYPE ( type: esriFieldTypeString , alias: LAMP_DISTYPE , editable: true , nullable: true , length: 8 , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...7 more... )
• SERVICE_AREA ( type: esriFieldTypeString , alias: SERVICE_AREA , editable: true , nullable: true , length: 10 )
• INSPECTION_DATE ( type: esriFieldTypeDate , alias: INSPECTION DATE , editable: true , nullable: true , length: 8 )
• INSPECTION_STATUS ( type: esriFieldTypeString , alias: INSPECTION STATUS , editable: true , nullable: true , length: 20 , Coded Values: [Verified: Verified] , [Added: Added] , [Moved: Moved] , ...4 more... )
• INSPECTED_BY ( type: esriFieldTypeString , alias: INSPECTED BY , editable: true , nullable: true , length: 25 , Coded Values: [Victor Ramos: Victor Ramos] , [Other Staff: Other Staff] , [Other: Other] , ...4 more... )
• INSPECTION_NOTES ( type: esriFieldTypeString , alias: INSPECTION NOTES , editable: true , nullable: true , length: 255 )
• POLE_LABEL ( type: esriFieldTypeString , alias: POLE_LABEL , editable: true , nullable: true , length: 12 )
• SMUD_SERVICE_LOC ( type: esriFieldTypeString , alias: SMUD_SERVICE_LOC , editable: true , nullable: true , length: 150 )
• INSTALL_DATE ( type: esriFieldTypeDate , alias: INSTALL_DATE , editable: true , nullable: true , length: 8 )
• Model_Number ( type: esriFieldTypeString , alias: Model_Number , editable: true , nullable: true , length: 50 )
• Small_Cell_Present ( type: esriFieldTypeString , alias: Small_Cell_Present , editable: true , nullable: true , length: 5 , Coded Values: [Yes: Yes] , [No: No] )
• Small_Cell_Vendor_Name ( type: esriFieldTypeString , alias: Small_Cell_Vendor_Name , editable: true , nullable: true , length: 50 )
• Small_Cell_Vendor_Phone_Number ( type: esriFieldTypeString , alias: Small_Cell_Vendor_Phone_Number , editable: true , nullable: true , length: 30 )
• Small_Cell_Permit_ID ( type: esriFieldTypeString , alias: Small_Cell_Permit_ID , editable: true , nullable: true , length: 30 )
• Small_Cell_Pole_Foundation ( type: esriFieldTypeString , alias: Small_Cell_Pole_Foundation , editable: true , nullable: true , length: 20 , Coded Values: [Standard: Standard] , [Enhanced: Enhanced] )
• IN_FIELD_LABELED ( type: esriFieldTypeString , alias: IN_FIELD_LABELED , editable: true , nullable: true , length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• GlobalID ( type: esriFieldTypeGlobalID , alias: GlobalID , editable: false , nullable: false , length: 38 )

Templates:

• Name: Streetlights
  Description:
  Prototype:
  IN_FIELD_LABELED: null
  Small_Cell_Pole_Foundation: Standard
  LAMP_HT: null
  FIX_TYPE: null
  LAMP_TYPE: null
  LAMP_WATT: null
  DECORATIVE: null
  FXT_QTY: null
  PEC: null
  LOCATION: null
  STREET_NUMBR: null
  STREET_NAME: null
  MAINTAINED: DEVELOPER
  POLE_CATEGORY: null
  POLE_MATERIAL: null
  POWER_SUPPLY: null
  SERVICE_CAN: null
  POLE_COMMENT: null
  OWNER: DEVELOPER
  COMPTYPE: null
  COMPKEY: null
  DISTYPE: null
  PLANID: null
  BANNER_MOUNT: null
  BANNER_TYPE: null
  POINT_X: null
  POINT_Y: null
  STREET_TYPE: null
  PNUM: null
  ID: null
  UNITID: null
  Small_Cell_Permit_ID: null
  Small_Cell_Vendor_Phone_Number: null
  Small_Cell_Vendor_Name: null
  Small_Cell_Present: No
  LAMP_DISTYPE: null
  SERVICE_AREA: null
  INSPECTION_DATE: null
  INSPECTION_STATUS: null
  INSPECTED_BY: null
  INSPECTION_NOTES: null
  POLE_LABEL: null
  SMUD_SERVICE_LOC: null
  INSTALL_DATE: null
  Model_Number: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Create,Query,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports Query With Historic Moment: false

Supported Operations:   Query   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates