View In:   ArcGIS Online Map Viewer

Name: Temp.DBO.Streetlights

Display Field: RoadName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

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: 1848952.1035000002
YMin: 3850468.7956
XMax: 2070438.2074999996
YMax: 4063915.0844
Spatial Reference: 3460  (3460)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: LightingType
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [230, 0, 0, 255]
Size: 5.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Default Label:
UniqueValueInfos:
• Value: BOL
  Label: Bollard
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [87, 147, 173, 255]
  Size: 5.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: FAIRY
  Label: Fairy Lights LED
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [153, 32, 32, 255]
  Size: 5.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: FL
  Label: Fluorescent Tube
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [30, 30, 138, 255]
  Size: 5.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: HPS
  Label: High Pressure Sodium
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [35, 161, 37, 255]
  Size: 5.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: LED
  Label: Light Emitting Diodes
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 115, 223, 255]
  Size: 5.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: MH
  Label: Metal Halide
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [176, 151, 77, 255]
  Size: 5.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: MV
  Label: Mercury Vapour
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [71, 76, 150, 255]
  Size: 5.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: OTHER
  Label: Other
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [43, 158, 114, 255]
  Size: 5.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: SOL
  Label: Solar LED
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [138, 51, 67, 255]
  Size: 5.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
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: true, 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 )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )

Types:

ID: BOL
Name: Bollard
Domains:
• LightingType:
  Inherited
• PoleType:
  Inherited
• Circuit_Type:
  Inherited
• Status:
  Inherited
Templates:
• Name: BOL
  Description:
  Prototype:
  ArmType: null
  Pole_No: 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
  InstallationDate: null
  CWID: null
  Disp: null
  Edited_Date: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: FAIRY
Name: Fairy Lights LED
Domains:
• LightingType:
  Inherited
• PoleType:
  Inherited
• Circuit_Type:
  Inherited
• Status:
  Inherited
Templates:
• Name: FAIRY
  Description:
  Prototype:
  ArmType: null
  Pole_No: 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
  InstallationDate: null
  CWID: null
  Disp: null
  Edited_Date: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: FL
Name: Fluorescent Tube
Domains:
• LightingType:
  Inherited
• PoleType:
  Inherited
• Circuit_Type:
  Inherited
• Status:
  Inherited
Templates:
• Name: FL
  Description:
  Prototype:
  ArmType: null
  Pole_No: 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
  InstallationDate: null
  CWID: null
  Disp: null
  Edited_Date: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: HPS
Name: High Pressure Sodium
Domains:
• LightingType:
  Inherited
• PoleType:
  Inherited
• Circuit_Type:
  Inherited
• Status:
  Inherited
Templates:
• Name: HPS
  Description:
  Prototype:
  ArmType: null
  Pole_No: 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
  InstallationDate: null
  CWID: null
  Disp: null
  Edited_Date: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: LED
Name: Light Emitting Diodes
Domains:
• LightingType:
  Inherited
• PoleType:
  Inherited
• Circuit_Type:
  Inherited
• Status:
  Inherited
Templates:
• Name: LED
  Description:
  Prototype:
  ArmType: null
  Pole_No: 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
  InstallationDate: null
  CWID: null
  Disp: null
  Edited_Date: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: MH
Name: Metal Halide
Domains:
• LightingType:
  Inherited
• PoleType:
  Inherited
• Circuit_Type:
  Inherited
• Status:
  Inherited
Templates:
• Name: MH
  Description:
  Prototype:
  ArmType: null
  Pole_No: 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
  InstallationDate: null
  CWID: null
  Disp: null
  Edited_Date: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: MV
Name: Mercury Vapour
Domains:
• LightingType:
  Inherited
• PoleType:
  Inherited
• Circuit_Type:
  Inherited
• Status:
  Inherited
Templates:
• Name: MV
  Description:
  Prototype:
  ArmType: null
  Pole_No: 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
  InstallationDate: null
  CWID: null
  Disp: null
  Edited_Date: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: OTHER
Name: Other
Domains:
• LightingType:
  Inherited
• PoleType:
  Inherited
• Circuit_Type:
  Inherited
• Status:
  Inherited
Templates:
• Name: OTHER
  Description:
  Prototype:
  ArmType: null
  Pole_No: 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
  InstallationDate: null
  CWID: null
  Disp: null
  Edited_Date: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: SOL
Name: Solar LED
Domains:
• LightingType:
  Inherited
• PoleType:
  Inherited
• Circuit_Type:
  Inherited
• Status:
  Inherited
Templates:
• Name: SOL
  Description:
  Prototype:
  ArmType: null
  Pole_No: 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
  InstallationDate: null
  CWID: null
  Disp: null
  Edited_Date: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

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: false

Supports Coordinates Quantization: true

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