View In:   ArcGIS Online Map Viewer

Name: Assets.DBO.Streetlights

Display Field: RoadName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Extent:

XMin: -3622300
YMin: -4120600
XMax: 2070438.2074999996
YMax: 1.12185082672E7
Spatial Reference: 3460  (3460)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: LightingType
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: BOL
  Label: Bollard
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [152, 44, 199, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: FAIRY
  Label: Fairy Lights LED
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [51, 71, 171, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: FL
  Label: Fluorescent Tube
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [71, 186, 157, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: HPS
  Label: High Pressure Sodium
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [199, 158, 56, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: LED
  Label: Light Emitting Diodes
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [255, 0, 197, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: MV
  Label: Mercury Vapour
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [45, 141, 196, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: MH
  Label: Metal Halide
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [196, 59, 43, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: OTHER
  Label: Other
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [42, 201, 50, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: SOL
  Label: Solar LED
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [171, 51, 113, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: LightingType

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• SerialNo ( type: esriFieldTypeDouble, alias: SerialNo, editable: true, nullable: true, defaultValue: null, modelName: SerialNo )
• Latitude ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: Latitude )
• Longitude ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: Longitude )
• Surburb ( type: esriFieldTypeString, alias: Surburb, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Surburb )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Location )
• CrossSt ( type: esriFieldTypeString, alias: CrossSt, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CrossSt )
• LightingType ( type: esriFieldTypeString, alias: LightingType, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LightingType , Coded Values: [HPS: High Pressure Sodium] , [LED: Light Emitting Diodes] , [MH: Metal Halide] , ...6 more... )
• Watts ( type: esriFieldTypeDouble, alias: Watts, editable: true, nullable: true, defaultValue: null, modelName: Watts )
• LightHeight ( type: esriFieldTypeDouble, alias: LightHeight, editable: true, nullable: true, defaultValue: null, modelName: LightHeight )
• PoleType ( type: esriFieldTypeString, alias: PoleType, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PoleType , Coded Values: [STEEL: Standalone steel] , [OTHER: Other] , [SOLAR: Solar Pole] , ...4 more... )
• Circuit_Type ( type: esriFieldTypeString, alias: Circuit_Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Circuit_Type , Coded Values: [MET: Metered circuit] , [UNMET: Unmetered circuit] )
• MeterNo ( type: esriFieldTypeString, alias: MeterNo, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MeterNo )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• RoadID ( type: esriFieldTypeInteger, alias: RoadID, editable: true, nullable: true, defaultValue: null, modelName: RoadID )
• RoadName ( type: esriFieldTypeString, alias: RoadName, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RoadName )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Status , Coded Values: [Active: Active] , [Planned: Planned] , [Retired: Retired] , ...2 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• CWID ( type: esriFieldTypeString, alias: CWID, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CWID )
• Created_Date ( type: esriFieldTypeDate, alias: Created_Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: Created_Date )
• Edited_Date ( type: esriFieldTypeDate, alias: Edited_Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: Edited_Date )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• ArmType ( type: esriFieldTypeString, alias: ArmType, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ArmType )
• Pole_No ( type: esriFieldTypeString, alias: Pole_No, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Pole_No )
• Disp ( type: esriFieldTypeInteger, alias: Displacement, editable: true, nullable: true, defaultValue: null, modelName: Disp )

Types:

ID: BOL
Name: BOL
Domains:
• LightingType:
  Inherited
• PoleType:
  Inherited
• Circuit_Type:
  Inherited
• Status:
  Inherited
Templates:
• Name: BOL
  Description:
  Prototype:
  Pole_No: null
  ArmType: null
  SerialNo: null
  Latitude: null
  Longitude: null
  Surburb: null
  Location: null
  CrossSt: null
  LightingType: BOL
  Watts: null
  LightHeight: null
  PoleType: null
  Circuit_Type: null
  MeterNo: null
  Comments: null
  RoadID: null
  RoadName: null
  Status: null
  Disp: null
  CWID: null
  InstallationDate: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: FAIRY
Name: FAIRY
Domains:
• LightingType:
  Inherited
• PoleType:
  Inherited
• Circuit_Type:
  Inherited
• Status:
  Inherited
Templates:
• Name: FAIRY
  Description:
  Prototype:
  Pole_No: null
  ArmType: null
  SerialNo: null
  Latitude: null
  Longitude: null
  Surburb: null
  Location: null
  CrossSt: null
  LightingType: FAIRY
  Watts: null
  LightHeight: null
  PoleType: null
  Circuit_Type: null
  MeterNo: null
  Comments: null
  RoadID: null
  RoadName: null
  Status: null
  Disp: null
  CWID: null
  InstallationDate: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: FL
Name: FL
Domains:
• LightingType:
  Inherited
• PoleType:
  Inherited
• Circuit_Type:
  Inherited
• Status:
  Inherited
Templates:
• Name: FL
  Description:
  Prototype:
  Pole_No: null
  ArmType: null
  SerialNo: null
  Latitude: null
  Longitude: null
  Surburb: null
  Location: null
  CrossSt: null
  LightingType: FL
  Watts: null
  LightHeight: null
  PoleType: null
  Circuit_Type: null
  MeterNo: null
  Comments: null
  RoadID: null
  RoadName: null
  Status: null
  Disp: null
  CWID: null
  InstallationDate: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: HPS
Name: HPS
Domains:
• LightingType:
  Inherited
• PoleType:
  Inherited
• Circuit_Type:
  Inherited
• Status:
  Inherited
Templates:
• Name: HPS
  Description:
  Prototype:
  Pole_No: null
  ArmType: null
  SerialNo: null
  Latitude: null
  Longitude: null
  Surburb: null
  Location: null
  CrossSt: null
  LightingType: HPS
  Watts: null
  LightHeight: null
  PoleType: null
  Circuit_Type: null
  MeterNo: null
  Comments: null
  RoadID: null
  RoadName: null
  Status: null
  Disp: null
  CWID: null
  InstallationDate: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: LED
Name: LED
Domains:
• LightingType:
  Inherited
• PoleType:
  Inherited
• Circuit_Type:
  Inherited
• Status:
  Inherited
Templates:
• Name: LED
  Description:
  Prototype:
  Pole_No: null
  ArmType: null
  SerialNo: null
  Latitude: null
  Longitude: null
  Surburb: null
  Location: null
  CrossSt: null
  LightingType: LED
  Watts: null
  LightHeight: null
  PoleType: null
  Circuit_Type: null
  MeterNo: null
  Comments: null
  RoadID: null
  RoadName: null
  Status: null
  Disp: null
  CWID: null
  InstallationDate: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: MV
Name: MV
Domains:
• LightingType:
  Inherited
• PoleType:
  Inherited
• Circuit_Type:
  Inherited
• Status:
  Inherited
Templates:
• Name: MV
  Description:
  Prototype:
  Pole_No: null
  ArmType: null
  SerialNo: null
  Latitude: null
  Longitude: null
  Surburb: null
  Location: null
  CrossSt: null
  LightingType: MV
  Watts: null
  LightHeight: null
  PoleType: null
  Circuit_Type: null
  MeterNo: null
  Comments: null
  RoadID: null
  RoadName: null
  Status: null
  Disp: null
  CWID: null
  InstallationDate: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: MH
Name: MH
Domains:
• LightingType:
  Inherited
• PoleType:
  Inherited
• Circuit_Type:
  Inherited
• Status:
  Inherited
Templates:
• Name: MH
  Description:
  Prototype:
  Pole_No: null
  ArmType: null
  SerialNo: null
  Latitude: null
  Longitude: null
  Surburb: null
  Location: null
  CrossSt: null
  LightingType: MH
  Watts: null
  LightHeight: null
  PoleType: null
  Circuit_Type: null
  MeterNo: null
  Comments: null
  RoadID: null
  RoadName: null
  Status: null
  Disp: null
  CWID: null
  InstallationDate: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: OTHER
Name: OTHER
Domains:
• LightingType:
  Inherited
• PoleType:
  Inherited
• Circuit_Type:
  Inherited
• Status:
  Inherited
Templates:
• Name: OTHER
  Description:
  Prototype:
  Pole_No: null
  ArmType: null
  SerialNo: null
  Latitude: null
  Longitude: null
  Surburb: null
  Location: null
  CrossSt: null
  LightingType: OTHER
  Watts: null
  LightHeight: null
  PoleType: null
  Circuit_Type: null
  MeterNo: null
  Comments: null
  RoadID: null
  RoadName: null
  Status: null
  Disp: null
  CWID: null
  InstallationDate: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: SOL
Name: SOL
Domains:
• LightingType:
  Inherited
• PoleType:
  Inherited
• Circuit_Type:
  Inherited
• Status:
  Inherited
Templates:
• Name: SOL
  Description:
  Prototype:
  Pole_No: null
  ArmType: null
  SerialNo: null
  Latitude: null
  Longitude: null
  Surburb: null
  Location: null
  CrossSt: null
  LightingType: SOL
  Watts: null
  LightHeight: null
  PoleType: null
  Circuit_Type: null
  MeterNo: null
  Comments: null
  RoadID: null
  RoadName: null
  Status: null
  Disp: null
  CWID: null
  InstallationDate: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: Created_Date
• Creator Field:
• Edit Date Field: Edited_Date
• Editor Field:

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Apply Edits   Add Features   Update Features   Delete Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata