View In:   ArcGIS Online Map Viewer

Parent Layer: Electrical Infrastructure

Name: Electrical Lights

Display Field: site_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This dataset is intended to represent the location and basic attributes of known, recorded, Sunshine Coast Council owned Electrical Light assets within the Sunshine Coast LGA. Features within this dataset have been captured by various Sunshine Coast Council personnel and methodologies. Dataset re-projected to GDA2020 on 01/06/2020 by the GDA2020 Transformation Project Team.

Service Item Id: 1d5ff8d70f8542bd8c4497096b467100

Copyright Text: Source: Sunshine Coast Council Digital and Asset Management Branch (Asset Information Services); Transport Infrastructure Management Branch.

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.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: 469147.54980000015
YMin: 7018379.0403
XMax: 514964.4930999996
YMax: 7073561.0776
Spatial Reference: 7856  (7856)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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: 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: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Purpose ( type: esriFieldTypeString, alias: Purpose, editable: true, nullable: false, length: 30, defaultValue: Unknown, modelName: Purp , Coded Values: [Amenity - Strip Light: Amenity - Strip Light] , [Unknown: Unknown] , [Amenity - Direction Light: Amenity - Direction Light] , ...14 more... )
• LampType ( type: esriFieldTypeString, alias: LampType, editable: true, nullable: false, length: 30, defaultValue: Unknown, modelName: LamTy , Coded Values: [LED: LED] , [Fluorescent: Fluorescent] , [Halogen: Halogen] , ...7 more... )
• SupportType ( type: esriFieldTypeString, alias: SupportType, editable: true, nullable: false, length: 30, defaultValue: Unknown, modelName: SupTy , Coded Values: [Pedestal: Pedestal] , [Unknown: Unknown] , [Not Applicable: Not Applicable] , ...1 more... )
• BracketType ( type: esriFieldTypeString, alias: BracketType, editable: true, nullable: false, length: 30, defaultValue: Unknown, modelName: BraTy , Coded Values: [Pole Bracket Arm: Pole Bracket Arm] , [Wall: Wall] , [Ground: Ground] , ...3 more... )
• BracketLength ( type: esriFieldTypeDouble, alias: BracketLength, editable: true, nullable: true, defaultValue: null, modelName: BracketLength )
• Tariff ( type: esriFieldTypeString, alias: Tariff, editable: true, nullable: false, length: 30, defaultValue: Unknown, modelName: Tarr , Coded Values: [Metered: Metered] , [Rate 3: Rate 3] , [Rate 8: Rate 8] , ...2 more... )
• NoOfLuminaire ( type: esriFieldTypeDouble, alias: NoOfLuminaire, editable: true, nullable: true, defaultValue: null, modelName: NoOfLuminaire )
• LampHeight ( type: esriFieldTypeDouble, alias: LampHeight, editable: true, nullable: true, defaultValue: null, modelName: LampHeight )
• Wattage ( type: esriFieldTypeDouble, alias: Wattage, editable: true, nullable: true, defaultValue: null, modelName: Wattage )
• ModelNumber ( type: esriFieldTypeString, alias: ModelNumber, editable: true, nullable: true, length: 500, defaultValue: null, modelName: ModelNumber )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Manufacturer )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Comments )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreateDate )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: CreateUser )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: ModifyDate )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: ModifyUser )
• GeomMthd ( type: esriFieldTypeString, alias: GeomMthd, editable: true, nullable: true, length: 50, defaultValue: Unknown, modelName: GeomMthd , Coded Values: [Supplied Digital XML (ADAC): Supplied Digital XML (ADAC)] , [Supplied Digital CAD (ADAC): Supplied Digital CAD (ADAC)] , [Supplied Digital CAD/ GIS (Other): Supplied Digital CAD/ GIS (Other)] , ...8 more... )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Status , Coded Values: [Active: Active] , [Closed: Closed] , [Disposed: Disposed] , ...3 more... )
• Owner ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Owner , Coded Values: [Council: Council] , [Private: Private] , [State: State] , ...6 more... )
• InstalledDate ( type: esriFieldTypeDate, alias: InstalledDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ConstructionDate )
• AssetSource ( type: esriFieldTypeString, alias: AssetSource, editable: true, nullable: false, length: 30, defaultValue: Unknown, modelName: FinSource , Coded Values: [Capital: Capital] , [Contributed: Contributed] , [Discovery: Discovery] , ...4 more... )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 500, defaultValue: null, modelName: LocationDesc )
• Locality ( type: esriFieldTypeString, alias: Locality, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Locality , Coded Values: [ALEXANDRA HEADLAND: ALEXANDRA HEADLAND] , [AROONA: AROONA] , [BALD KNOB: BALD KNOB] , ...140 more... )
• Division ( type: esriFieldTypeString, alias: Division, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Division , Coded Values: [Division 1: Division 1] , [Division 2: Division 2] , [Division 3: Division 3] , ...8 more... )
• ProjectNo ( type: esriFieldTypeString, alias: ProjectNo, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectNo )
• DataQuality ( type: esriFieldTypeString, alias: DataQuality, editable: true, nullable: false, length: 50, defaultValue: D: Schematic only, modelName: QualityLevel , Coded Values: [A: Absolute 3 Dimensions: A: Absolute 3 Dimensions] , [B: +- 300mm: B: +- 300mm] , [C: Interpreted: C: Interpreted] , ...2 more... )
• DocumentReference ( type: esriFieldTypeString, alias: DocumentReference, editable: true, nullable: true, length: 200, defaultValue: null, modelName: DocumentReference )
• central_asset_id ( type: esriFieldTypeString, alias: central_asset_id, editable: true, nullable: true, length: 20, defaultValue: null, modelName: central_asset_id )
• site_code ( type: esriFieldTypeString, alias: site_code, editable: true, nullable: true, length: 10, defaultValue: null, modelName: site_code )
• UniqueID ( type: esriFieldTypeString, alias: UniqueID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: UniqueID )
• FeatureTypeCode ( type: esriFieldTypeString, alias: FeatureTypeCode, editable: true, nullable: false, length: 4, defaultValue: null, modelName: FeatureTypeCode , Coded Values: [EL01: Amenity Light] , [EL02: Carpark Light] , [EL03: Path Light] , ...3 more... )
• Colour ( type: esriFieldTypeString, alias: Colour, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Colour )
• site_name ( type: esriFieldTypeString, alias: site_name, editable: true, nullable: true, length: 40, defaultValue: null, modelName: site_name )
• ReplacedAssetNo ( type: esriFieldTypeString, alias: ReplacedAssetNo, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ReplacedAssetNo )
• Quantity ( type: esriFieldTypeSmallInteger, alias: Quantity, editable: true, nullable: true, defaultValue: null, modelName: Quantity )
• AssetManager ( type: esriFieldTypeString, alias: AssetManager, editable: true, nullable: false, length: 30, defaultValue: Unknown, modelName: AssetManager_1 , Coded Values: [Environmental Operations: Environmental Operations] , [Private: Private] , [Property Management: Property Management] , ...24 more... )
• MaintainedBy ( type: esriFieldTypeString, alias: MaintainedBy, editable: true, nullable: false, length: 30, defaultValue: Unknown, modelName: MaintainedBy , Coded Values: [Federal: Federal] , [Sport and Community Venues: Sport and Community Venues] , [Business Development: Business Development] , ...27 more... )
• ServicePrecinct ( type: esriFieldTypeString, alias: ServicePrecinct, editable: true, nullable: true, length: 30, defaultValue: Unknown, modelName: ServicePrecinct , Coded Values: [Beerwah Precinct: Beerwah Precinct] , [Buderim Precinct: Buderim Precinct] , [Bulcock Street/Caloundra Espla: Bulcock Street/Caloundra Espla] , ...23 more... )
• DispDate ( type: esriFieldTypeDate, alias: DispDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DispDate )
• StatusChangeReason ( type: esriFieldTypeString, alias: StatusChangeReason, editable: true, nullable: true, length: 500, defaultValue: null, modelName: StatusChangeReason )
• LegacyAssetID ( type: esriFieldTypeString, alias: LegacyAssetID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LegacyAssetID )
• GlareShieldFitting ( type: esriFieldTypeString, alias: GlareShieldFitting, editable: true, nullable: true, length: 30, defaultValue: None, modelName: GlareShieldFitting , Coded Values: [Front: Front] , [Rear: Rear] , [Left: Left] , ...3 more... )
• GlareShieldType ( type: esriFieldTypeString, alias: GlareShieldType, editable: true, nullable: true, length: 30, defaultValue: None, modelName: GlareShieldType , Coded Values: [Unique: Unique] , [Adhesive: Adhesive] , [Baffle: Baffle] , ...2 more... )
• GlareShieldPartNumber ( type: esriFieldTypeString, alias: GlareShieldPartNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GlareShieldPart_number )
• GlareShieldInstallDate ( type: esriFieldTypeDate, alias: GlareShieldInstallDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GlareShieldInstallDate )
• TopControlSocket ( type: esriFieldTypeString, alias: TopControlSocket, editable: true, nullable: true, length: 30, defaultValue: None, modelName: TopControlSocket , Coded Values: [Nema - 3: Nema - 3] , [Nema - 7: Nema - 7] , [Zhaga: Zhaga] , ...1 more... )
• TopSensor ( type: esriFieldTypeString, alias: TopSensor, editable: true, nullable: true, length: 100, defaultValue: null, modelName: TopSensor )
• BottomControlSocket ( type: esriFieldTypeString, alias: BottomControlSocket, editable: true, nullable: true, length: 30, defaultValue: None, modelName: BottomControlSocket , Coded Values: [Nema - 3: Nema - 3] , [Nema - 7: Nema - 7] , [Zhaga: Zhaga] , ...1 more... )
• BottomSensor ( type: esriFieldTypeString, alias: BottomSensor, editable: true, nullable: true, length: 100, defaultValue: null, modelName: BottomSensor )
• Telecell_ID ( type: esriFieldTypeString, alias: Telecell_ID, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Telecell_ID )
• Telecell_SerialNo ( type: esriFieldTypeString, alias: Telecell_SerialNo, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Telecell_SerialNo )
• ColourTemp ( type: esriFieldTypeString, alias: ColourTemp_K, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ColourTemp , Coded Values: [2200: 2200] , [2700: 2700] , [3000: 3000] , ...4 more... )
• Optics ( type: esriFieldTypeString, alias: Optics, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Optics )

Templates:

• Name: Electrical Lights
  Description:
  Prototype:
  ColourTemp: null
  Telecell_SerialNo: null
  Optics: null
  Purpose: Unknown
  LampType: Unknown
  SupportType: Unknown
  BracketType: Unknown
  BracketLength: null
  Tariff: Unknown
  NoOfLuminaire: null
  LampHeight: null
  Wattage: null
  ModelNumber: null
  Manufacturer: null
  Notes: null
  Telecell_ID: null
  BottomSensor: null
  BottomControlSocket: None
  TopSensor: null
  GeomMthd: Unknown
  Status: null
  Owner: null
  InstalledDate: null
  AssetSource: Unknown
  Location: null
  Locality: null
  Division: null
  ProjectNo: null
  DataQuality: D: Schematic only
  DocumentReference: null
  central_asset_id: null
  site_code: null
  UniqueID: null
  FeatureTypeCode:
  Colour: null
  site_name: null
  ReplacedAssetNo: null
  Quantity: null
  AssetManager: Unknown
  MaintainedBy: Unknown
  ServicePrecinct: Unknown
  DispDate: null
  StatusChangeReason: null
  LegacyAssetID: null
  GlareShieldFitting: None
  GlareShieldType: None
  GlareShieldPartNumber: null
  GlareShieldInstallDate: null
  TopControlSocket: None
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

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

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

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