View In:   ArcGIS Online Map Viewer

Name: Streetlights

Display Field: AreaName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: b2949b1b4600485da7d3046f4518131e

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 10000.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

Supports Datum Transformation: true

Extent:

XMin: 2019864.0991390496
YMin: 692480.1106387228
XMax: 2079841.4250503033
YMax: 779687.0999383032
Spatial Reference: 102719  (2264)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: HID
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label: Unkown
UniqueValueInfos:
• Value: LED
  Label: LED
  Description: N/A
  Symbol:
  
• Value: Mercury
  Label: Mercury
  Description: N/A
  Symbol:
  
• Value: Metal
  Label: Metal
  Description: N/A
  Symbol:
  
• Value: Sodium
  Label: Sodium
  Description: N/A
  Symbol:
  
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: false
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: HID

Fields:

• Street ( type: esriFieldTypeString, alias: Street Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Street )
• DIS ( type: esriFieldTypeString, alias: DIS, editable: true, nullable: true, length: 15, defaultValue: null, modelName: DIS )
• Source ( type: esriFieldTypeString, alias: Source, editable: true, nullable: true, length: 10, defaultValue: DEP, modelName: Source , Coded Values: [APEX: Apex] , [DEP: DEP] )
• Owner ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 50, defaultValue: PUB, modelName: Owner , Coded Values: [PRIV: Private] , [PUB: Town of Cary] )
• Lumen ( type: esriFieldTypeInteger, alias: Lumen, editable: true, nullable: true, defaultValue: 9500, modelName: Lumen , Coded Values: [9500: 9500] , [22000: 22000] , [28500: 28500] , ...9 more... )
• Pole ( type: esriFieldTypeString, alias: Pole, editable: true, nullable: true, length: 10, defaultValue: Decorative, modelName: Pole , Coded Values: [Metal: Metal] , [Wood: Wood] , [Fiberglass: Fiberglass] , ...1 more... )
• Fixture ( type: esriFieldTypeString, alias: Fixture, editable: true, nullable: true, length: 40, defaultValue: Decorative, modelName: Fixture , Coded Values: [LED: LED] , [Shoe: Shoe] , [Enclosed: Enclosed] , ...1 more... )
• Installation ( type: esriFieldTypeString, alias: Installation, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Installation )
• HID ( type: esriFieldTypeString, alias: Bulb Type, editable: true, nullable: true, length: 10, defaultValue: null, modelName: HID , Coded Values: [LED: LED] , [Sodium: Sodium] , [Metal: Metal] , ...1 more... )
• Cable ( type: esriFieldTypeString, alias: Cable, editable: true, nullable: true, length: 15, defaultValue: Underground, modelName: Cable , Coded Values: [Underground: Undergound] , [Overhead: Overhead] )
• Account ( type: esriFieldTypeString, alias: Account, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Account )
• DateVerified ( type: esriFieldTypeDate, alias: DateVerified, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateVerified )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Notes )
• Duplicate ( type: esriFieldTypeSmallInteger, alias: Duplicate, editable: true, nullable: true, defaultValue: null, modelName: Duplicate )
• Watts ( type: esriFieldTypeSmallInteger, alias: Watts, editable: true, nullable: true, defaultValue: null, modelName: Watts , Coded Values: [0: 0] , [25: 25] , [50: 50] , ...12 more... )
• FacilityID ( type: esriFieldTypeString, alias: Facility ID, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FacilityID )
• BillTo ( type: esriFieldTypeString, alias: Bill To, editable: true, nullable: true, length: 10, defaultValue: null, modelName: BillTo )
• LightType ( type: esriFieldTypeString, alias: Light Type, editable: true, nullable: true, length: 25, defaultValue: Streetlight, modelName: LightType , Coded Values: [Other: Other (located in parking lots or other properties)] , [Streetlight: Streetlight] )
• Problem ( type: esriFieldTypeString, alias: Problem, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Problem , Coded Values: [Light Out: Light Out] , [Continuously On: Continuously On] , [Cycling On and Off: Cycling On and Off] , ...2 more... )
• DateInstalled ( type: esriFieldTypeDate, alias: DateInstalled, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateInstalled )
• AreaName ( type: esriFieldTypeString, alias: AreaName, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AreaName )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Address ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Address )
• BillType ( type: esriFieldTypeString, alias: BillType, editable: true, nullable: true, length: 25, defaultValue: null, modelName: BillType , Coded Values: [Other: Other (located in parking lots or other properties)] , [Streetlight: Streetlight] )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• 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 )
• YearAdded ( type: esriFieldTypeString, alias: Year Added, editable: true, nullable: true, length: 4, defaultValue: null, modelName: YearAdded )

Types:

ID: LED
Name: LED
Domains:
• Source:
  Inherited
• Owner:
  Inherited
• Lumen:
  Inherited
• Pole:
  Inherited
• Fixture:
  Inherited
• HID:
  Inherited
• Cable:
  Inherited
• Watts:
  Inherited
• LightType:
  Inherited
• Problem:
  Inherited
• BillType:
  Inherited
Templates:
• Name: LED
  Description:
  Prototype:
  Installation: null
  BillType: null
  Street: null
  DIS: null
  Source: DEP
  Owner: PUB
  Lumen: 9500
  Pole: Decorative
  Fixture: Decorative
  HID: LED
  Cable: Underground
  Account: null
  DateVerified: null
  Notes: null
  Duplicate: null
  Watts: null
  FacilityID: null
  BillTo: null
  LightType: Streetlight
  Problem: null
  DateInstalled: null
  AreaName: null
  YearAdded: null
  Address: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Mercury
Name: Mercury
Domains:
• Source:
  Inherited
• Owner:
  Inherited
• Lumen:
  Inherited
• Pole:
  Inherited
• Fixture:
  Inherited
• HID:
  Inherited
• Cable:
  Inherited
• Watts:
  Inherited
• LightType:
  Inherited
• Problem:
  Inherited
• BillType:
  Inherited
Templates:
• Name: Mercury
  Description:
  Prototype:
  Installation: null
  BillType: null
  Street: null
  DIS: null
  Source: DEP
  Owner: PUB
  Lumen: 9500
  Pole: Decorative
  Fixture: Decorative
  HID: Mercury
  Cable: Underground
  Account: null
  DateVerified: null
  Notes: null
  Duplicate: null
  Watts: null
  FacilityID: null
  BillTo: null
  LightType: Streetlight
  Problem: null
  DateInstalled: null
  AreaName: null
  YearAdded: null
  Address: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Metal
Name: Metal
Domains:
• Source:
  Inherited
• Owner:
  Inherited
• Lumen:
  Inherited
• Pole:
  Inherited
• Fixture:
  Inherited
• HID:
  Inherited
• Cable:
  Inherited
• Watts:
  Inherited
• LightType:
  Inherited
• Problem:
  Inherited
• BillType:
  Inherited
Templates:
• Name: Metal
  Description:
  Prototype:
  Installation: null
  BillType: null
  Street: null
  DIS: null
  Source: DEP
  Owner: PUB
  Lumen: 9500
  Pole: Decorative
  Fixture: Decorative
  HID: Metal
  Cable: Underground
  Account: null
  DateVerified: null
  Notes: null
  Duplicate: null
  Watts: null
  FacilityID: null
  BillTo: null
  LightType: Streetlight
  Problem: null
  DateInstalled: null
  AreaName: null
  YearAdded: null
  Address: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Sodium
Name: Sodium
Domains:
• Source:
  Inherited
• Owner:
  Inherited
• Lumen:
  Inherited
• Pole:
  Inherited
• Fixture:
  Inherited
• HID:
  Inherited
• Cable:
  Inherited
• Watts:
  Inherited
• LightType:
  Inherited
• Problem:
  Inherited
• BillType:
  Inherited
Templates:
• Name: Sodium
  Description:
  Prototype:
  Installation: null
  BillType: null
  Street: null
  DIS: null
  Source: DEP
  Owner: PUB
  Lumen: 9500
  Pole: Decorative
  Fixture: Decorative
  HID: Sodium
  Cable: Underground
  Account: null
  DateVerified: null
  Notes: null
  Duplicate: null
  Watts: null
  FacilityID: null
  BillTo: null
  LightType: Streetlight
  Problem: null
  DateInstalled: null
  AreaName: null
  YearAdded: null
  Address: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Extract,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: 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:

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