View In:   ArcGIS Online Map Viewer

Name: Streetlights

Display Field: PoleMaterial

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Streetlights within the City of Salisbury, classified by their owner. This data was originally collected by a Salisbury University intern in conjunction with the Eastern Shore Regional GIS Cooperative (ESRGC). The lights physical location was captured along with various attributes including: pole material, structural type, owner, condition, unique id, height, street, bulb type and meter number if present.

Service Item Id: a90ef0ab71284d6da44ab2a8b782035b

Copyright Text: City of Salisbury, Department of Information Services: GIS Division

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

Supports Datum Transformation: true

Extent:

XMin: 518668.9241999984
YMin: 74296.90960000083
XMax: 530779.2710999995
YMax: 84798.1959999986
Spatial Reference: 26985  (26985)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: LightOwner
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 1
  Label: City
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [167, 198, 54, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [153, 153, 153, 64] Width: 0
• Value: 2
  Label: County
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [158, 85, 156, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [153, 153, 153, 64] Width: 0
• Value: 3
  Label: State
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [252, 146, 31, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [153, 153, 153, 64] Width: 0
• Value: 4
  Label: Delmarva Power
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [20, 158, 206, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [153, 153, 153, 64] Width: 0
• Value: 5
  Label: Private
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [237, 81, 81, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [153, 153, 153, 64] Width: 0
• Value: 6
  Label: Other
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 222, 62, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [153, 153, 153, 64] Width: 0
Transparency: 44
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: false
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: LightOwner

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• PoleMaterial ( type: esriFieldTypeString, alias: PoleMaterial, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PoleMaterial , Coded Values: [1: METAL] , [2: WOOD] , [3: OTHER] , ...4 more... )
• LightType ( type: esriFieldTypeString, alias: LightType, editable: true, nullable: true, length: 30, defaultValue: null, modelName: LightType , Coded Values: [1: Standard Single Arm] , [2: Standard Double Arm] , [3: Decorative Globe] , ...7 more... )
• LightOwner ( type: esriFieldTypeString, alias: LightOwner, editable: true, nullable: true, length: 15, defaultValue: null, modelName: LightOwner , Coded Values: [1: City] , [2: County] , [3: State] , ...3 more... )
• LightCond ( type: esriFieldTypeString, alias: LightCond, editable: true, nullable: true, length: 25, defaultValue: null, modelName: LightCond , Coded Values: [Excellent: Excellent] , [Very Good: Very Good] , [Good: Good] , ...5 more... )
• PoleType ( type: esriFieldTypeString, alias: PoleType, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PoleType , Coded Values: [U: Utility] , [L: Light] , [T: Traffic Signal] , ...4 more... )
• PoleNumber ( type: esriFieldTypeString, alias: PoleNumber, editable: true, nullable: true, length: 12, defaultValue: null, modelName: PoleNumber )
• Collected ( type: esriFieldTypeString, alias: Collected, editable: true, nullable: true, length: 50, defaultValue: No, modelName: Collected , Coded Values: [Yes: Yes] , [No: No] )
• YearInstalled ( type: esriFieldTypeString, alias: YearInstalled, editable: true, nullable: true, length: 4, defaultValue: null, modelName: YearInstalled )
• Height ( type: esriFieldTypeString, alias: Height, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Height , Coded Values: [1: 12'] , [2: 14'] , [3: 20'] , ...3 more... )
• Street ( type: esriFieldTypeString, alias: Street, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Street )
• BulbType ( type: esriFieldTypeString, alias: BulbType, editable: true, nullable: true, length: 15, defaultValue: null, modelName: BulbType , Coded Values: [1: 125.5 LED] , [2: 100 HPS] , [3: 150 HPS] , ...14 more... )
• MeterNum ( type: esriFieldTypeString, alias: Meter#, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MeterNum )
• AccountNum ( type: esriFieldTypeString, alias: Account #, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AccountNum )
• DateOfService ( type: esriFieldTypeDate, alias: DateOfService, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateOfService )
• Comment ( type: esriFieldTypeString, alias: Comment, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Comment )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user, required: true )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date, required: true )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user, required: true )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date, required: true )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Types:

ID: 1
Name: City
Domains:
• PoleMaterial:
  Inherited
• LightType:
  Inherited
• LightOwner:
  Inherited
• LightCond:
  Inherited
• PoleType:
  Inherited
• Collected:
  Inherited
• Height:
  Inherited
• BulbType:
  Inherited
Templates:
• Name: 1
  Description:
  Prototype:
  DateOfService: null
  Comment: null
  PoleMaterial: null
  LightType: null
  LightOwner: 1
  LightCond: null
  PoleType: null
  PoleNumber: null
  Collected: No
  YearInstalled: null
  Height: null
  Street: null
  BulbType: null
  MeterNum: null
  AccountNum: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: County
Domains:
• PoleMaterial:
  Inherited
• LightType:
  Inherited
• LightOwner:
  Inherited
• LightCond:
  Inherited
• PoleType:
  Inherited
• Collected:
  Inherited
• Height:
  Inherited
• BulbType:
  Inherited
Templates:
• Name: 2
  Description:
  Prototype:
  DateOfService: null
  Comment: null
  PoleMaterial: null
  LightType: null
  LightOwner: 2
  LightCond: null
  PoleType: null
  PoleNumber: null
  Collected: No
  YearInstalled: null
  Height: null
  Street: null
  BulbType: null
  MeterNum: null
  AccountNum: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 3
Name: State
Domains:
• PoleMaterial:
  Inherited
• LightType:
  Inherited
• LightOwner:
  Inherited
• LightCond:
  Inherited
• PoleType:
  Inherited
• Collected:
  Inherited
• Height:
  Inherited
• BulbType:
  Inherited
Templates:
• Name: 3
  Description:
  Prototype:
  DateOfService: null
  Comment: null
  PoleMaterial: null
  LightType: null
  LightOwner: 3
  LightCond: null
  PoleType: null
  PoleNumber: null
  Collected: No
  YearInstalled: null
  Height: null
  Street: null
  BulbType: null
  MeterNum: null
  AccountNum: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 4
Name: Delmarva Power
Domains:
• PoleMaterial:
  Inherited
• LightType:
  Inherited
• LightOwner:
  Inherited
• LightCond:
  Inherited
• PoleType:
  Inherited
• Collected:
  Inherited
• Height:
  Inherited
• BulbType:
  Inherited
Templates:
• Name: 4
  Description:
  Prototype:
  DateOfService: null
  Comment: null
  PoleMaterial: null
  LightType: null
  LightOwner: 4
  LightCond: null
  PoleType: null
  PoleNumber: null
  Collected: No
  YearInstalled: null
  Height: null
  Street: null
  BulbType: null
  MeterNum: null
  AccountNum: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 5
Name: Private
Domains:
• PoleMaterial:
  Inherited
• LightType:
  Inherited
• LightOwner:
  Inherited
• LightCond:
  Inherited
• PoleType:
  Inherited
• Collected:
  Inherited
• Height:
  Inherited
• BulbType:
  Inherited
Templates:
• Name: 5
  Description:
  Prototype:
  DateOfService: null
  Comment: null
  PoleMaterial: null
  LightType: null
  LightOwner: 5
  LightCond: null
  PoleType: null
  PoleNumber: null
  Collected: No
  YearInstalled: null
  Height: null
  Street: null
  BulbType: null
  MeterNum: null
  AccountNum: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 6
Name: Other
Domains:
• PoleMaterial:
  Inherited
• LightType:
  Inherited
• LightOwner:
  Inherited
• LightCond:
  Inherited
• PoleType:
  Inherited
• Collected:
  Inherited
• Height:
  Inherited
• BulbType:
  Inherited
Templates:
• Name: 6
  Description:
  Prototype:
  DateOfService: null
  Comment: null
  PoleMaterial: null
  LightType: null
  LightOwner: 6
  LightCond: null
  PoleType: null
  PoleNumber: null
  Collected: No
  YearInstalled: null
  Height: null
  Street: null
  BulbType: null
  MeterNum: null
  AccountNum: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Sync,Extract,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports OidReservation: 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: true

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

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