View In:   ArcGIS Online Map Viewer

Name: Road_Street_Lights

Display Field: road_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This dataset comprises points for street lights (both active and inactive) either maintained or paid for its use by the County of San Diego Special Districts. Street light information was collected from recorded documents and information provided by asset management systems. All features have a unique ID that corresponds to the county's asset management system.The layer contains features located on public roads and in some cases private roads. Public road names in the features' attributes aren't always the official names as maintained by the addressing authority for the jurisdiction in which the road is located. Official road names may not match the common or local name used to identify the road.Roads corresponding to the features in this layer are comprised of road segments that are individually identified by a unique, and persistent, ID (ACCELA_ID) found in the ROAD_SEGMENTS layer. Maintained to and from measurements for the features are in relation to the start of the road segment.

Service Item Id: c1a301662a42492ba7063faf76e5d4b7

Copyright Text: LUEG-GIS, County of San Diego, Department of Public Works

Default Visibility: true

MaxRecordCount: 2000

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

Extent:

XMin: 6247774.264498472
YMin: 1782950.2825094014
XMax: 6582241.507964224
YMax: 2096814.3736119717
Spatial Reference: 102646  (2230)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [75, 158, 93, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
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: 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:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• accela_id ( modelName: accela_id, nullable: true, editable: true, defaultValue: null, length: 100, alias: ACCELA_ID, type: esriFieldTypeString )
• street_light_id ( modelName: street_light_id, nullable: true, editable: true, defaultValue: null, length: 200, alias: STREET_LIGHT_ID, type: esriFieldTypeString )
• road_name ( modelName: road_name, nullable: true, editable: true, defaultValue: null, length: 200, alias: ROAD_NAME, type: esriFieldTypeString )
• road_id ( modelName: road_id, nullable: true, editable: true, defaultValue: null, length: 20, alias: ROAD_ID, type: esriFieldTypeString )
• road_seq_number ( modelName: road_seq_number, nullable: true, editable: true, defaultValue: null, length: 40, alias: ROAD_SEQ_NUMBER, type: esriFieldTypeString )
• from_street ( modelName: from_street, nullable: true, editable: true, defaultValue: null, length: 200, alias: FROM_STREET, type: esriFieldTypeString )
• to_street ( modelName: to_street, nullable: true, editable: true, defaultValue: null, length: 200, alias: TO_STREET, type: esriFieldTypeString )
• gis_from_position ( modelName: gis_from_position, nullable: true, editable: true, defaultValue: null, alias: GIS_FROM_POSITION, type: esriFieldTypeDouble )
• legacy_from_position ( modelName: legacy_from_position, nullable: true, editable: true, defaultValue: null, alias: LEGACY_FROM_POSITION, type: esriFieldTypeDouble )
• inventory_date ( modelName: inventory_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: INVENTORY_DATE, type: esriFieldTypeDate )
• expiration_date ( modelName: expiration_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: EXPIRATION_DATE, type: esriFieldTypeDate )
• burn_date ( modelName: burn_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: BURN_DATE, type: esriFieldTypeDate )
• location ( modelName: location, nullable: true, editable: true, defaultValue: null, length: 200, alias: LOCATION, type: esriFieldTypeString )
• address ( modelName: address, nullable: true, editable: true, defaultValue: null, length: 200, alias: ADDRESS, type: esriFieldTypeString )
• project ( modelName: project, nullable: true, editable: true, defaultValue: null, length: 200, alias: PROJECT, type: esriFieldTypeString )
• rate ( modelName: rate, nullable: true, editable: true, defaultValue: null, length: 100, alias: RATE, type: esriFieldTypeString , Coded Values: [LS1A: LS1A] , [LS2A: LS2A] , [Other/Undetermined: Other/Undetermined] )
• owner ( modelName: owner, nullable: true, editable: true, defaultValue: null, length: 100, alias: OWNER, type: esriFieldTypeString , Coded Values: [COUNTY: COUNTY] , [SDGE: SDGE] , [DEVELOPER: DEVELOPER] , ...1 more... )
• lamp_size ( modelName: lamp_size, nullable: true, editable: true, defaultValue: null, length: 100, alias: LAMP_SIZE, type: esriFieldTypeString )
• luminare_type ( modelName: luminare_type, nullable: true, editable: true, defaultValue: null, length: 100, alias: LUMINARE_TYPE, type: esriFieldTypeString , Coded Values: [COBRA HEAD: COBRA HEAD] , [BELL: BELL] , [HAT: HAT] , ...4 more... )
• light_type ( modelName: light_type, nullable: true, editable: true, defaultValue: null, length: 100, alias: LIGHT_TYPE, type: esriFieldTypeString , Coded Values: [LED: LED] , [LPS: LPS] , [HPS: HPS] , ...1 more... )
• pole_type ( modelName: pole_type, nullable: true, editable: true, defaultValue: null, length: 100, alias: POLE_TYPE, type: esriFieldTypeString , Coded Values: [WOOD: WOOD] , [METAL: METAL] , [FIBERGLASS: FIBERGLASS] , ...3 more... )
• sdge_pole_no ( modelName: sdge_pole_no, nullable: true, editable: true, defaultValue: null, length: 32, alias: SDGE_POLE_NO, type: esriFieldTypeString )
• photo_exists ( modelName: photo_exists, nullable: true, editable: true, defaultValue: null, length: 2, alias: PHOTO_EXISTS, type: esriFieldTypeString , Coded Values: [Y: Y] , [N: N] , [U: Other/Undetermined] )
• photo_date ( modelName: photo_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: PHOTO_DATE, type: esriFieldTypeDate )
• photo_link ( modelName: photo_link, nullable: true, editable: true, defaultValue: null, length: 200, alias: PHOTO_LINK, type: esriFieldTypeString )
• as_built_link ( modelName: as_built_link, nullable: true, editable: true, defaultValue: null, length: 200, alias: AS_BUILT_LINK, type: esriFieldTypeString )
• energized_link ( modelName: energized_link, nullable: true, editable: true, defaultValue: null, length: 200, alias: ENERGIZED_LINK, type: esriFieldTypeString )
• photo_file_name ( modelName: photo_file_name, nullable: true, editable: true, defaultValue: null, length: 100, alias: PHOTO_FILE_NAME, type: esriFieldTypeString )
• as_built_file_name ( modelName: as_built_file_name, nullable: true, editable: true, defaultValue: null, length: 100, alias: AS_BUILT_FILE_NAME, type: esriFieldTypeString )
• comments ( modelName: comments, nullable: true, editable: true, defaultValue: null, length: 1000, alias: COMMENTS, type: esriFieldTypeString )
• maintenance_div ( modelName: maintenance_div, nullable: true, editable: true, defaultValue: null, length: 100, alias: MAINTENANCE_DIV, type: esriFieldTypeString , Coded Values: [1 - DIVISION 1: 1 - DIVISION 1] , [2 - DIVISION 2: 2 - DIVISION 2] , [Other/Undetermined: Other/Undetermined] )
• road_station ( modelName: road_station, nullable: true, editable: true, defaultValue: null, length: 100, alias: ROAD_STATION, type: esriFieldTypeString , Coded Values: [14: 14] , [15: 15] , [17: 17] , ...10 more... )
• street_dist ( modelName: street_dist, nullable: true, editable: true, defaultValue: null, length: 200, alias: STREET_DIST, type: esriFieldTypeString , Coded Values: [000 - STREET DISTRICT 000: 000 - STREET DISTRICT 000] , [001 - ALPINE: 001 - ALPINE] , [004 - JULIAN: 004 - JULIAN] , ...98 more... )
• supervisor_dist ( modelName: supervisor_dist, nullable: true, editable: true, defaultValue: null, length: 100, alias: SUPERVISOR_DIST, type: esriFieldTypeString , Coded Values: [1 - SUPERVISOR DISTRICT 1: 1 - SUPERVISOR DISTRICT 1] , [2 - SUPERVISOR DISTRICT 2: 2 - SUPERVISOR DISTRICT 2] , [3 - SUPERVISOR DISTRICT 3: 3 - SUPERVISOR DISTRICT 3] , ...3 more... )
• community_group ( modelName: community_group, nullable: true, editable: true, defaultValue: null, length: 100, alias: COMMUNITY_GROUP, type: esriFieldTypeString , Coded Values: [ALPINE CPG: ALPINE CPG] , [BONSALL CSG: BONSALL CSG] , [BORREGO SPRINGS CSG: BORREGO SPRINGS CSG] , ...27 more... )
• neighborhood ( modelName: neighborhood, nullable: true, editable: true, defaultValue: null, length: 100, alias: NEIGHBORHOOD, type: esriFieldTypeString )
• thomas_guide ( modelName: thomas_guide, nullable: true, editable: true, defaultValue: null, length: 200, alias: THOMAS_GUIDE, type: esriFieldTypeString )
• ca_road_sys ( modelName: ca_road_sys, nullable: true, editable: true, defaultValue: null, length: 200, alias: CA_ROAD_SYS, type: esriFieldTypeString )
• highway_planning_system ( modelName: highway_planning_system, nullable: true, editable: true, defaultValue: null, length: 200, alias: HIGHWAY_PLANNING_SYSTEM, type: esriFieldTypeString )
• asset_status ( modelName: asset_status, nullable: true, editable: true, defaultValue: null, length: 50, alias: ASSET_STATUS, type: esriFieldTypeString , Coded Values: [ACTIVE: Active] , [EXPIRED: Expired] , [UNKNOWN: Unknown] )
• creator ( modelName: creator, nullable: true, editable: true, defaultValue: null, length: 255, alias: CREATOR, type: esriFieldTypeString )
• created ( modelName: created, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: CREATED, type: esriFieldTypeDate )
• editor ( modelName: editor, nullable: true, editable: true, defaultValue: null, length: 255, alias: EDITOR, type: esriFieldTypeString )
• edited ( modelName: edited, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: EDITED, type: esriFieldTypeDate )

Templates:

• Name: Road_Street_Lights
  Description:
  Prototype:
  road_station: null
  community_group: null
  energized_link: null
  project: null
  expiration_date: null
  as_built_file_name: null
  inventory_date: null
  lamp_size: null
  maintenance_div: null
  light_type: null
  rate: null
  ca_road_sys: null
  legacy_from_position: null
  as_built_link: null
  supervisor_dist: null
  road_seq_number: null
  sdge_pole_no: null
  photo_link: null
  from_street: null
  burn_date: null
  pole_type: null
  owner: null
  editor: null
  road_name: null
  thomas_guide: null
  creator: null
  address: null
  comments: null
  edited: null
  accela_id: null
  street_light_id: null
  created: null
  street_dist: null
  road_id: null
  photo_date: null
  to_street: null
  asset_status: null
  luminare_type: null
  gis_from_position: null
  highway_planning_system: null
  photo_file_name: null
  location: null
  photo_exists: null
  neighborhood: 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: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

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