View In:   ArcGIS Online Map Viewer

Parent Layer: Electrical Infrastructure

Name: Electrical Switchboards

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, ___________ assets within the Sunshine Coast LGA. Features within this dataset have been captured by various Sunshine Coast Council personnel and methodologies.

Service Item Id: 1d5ff8d70f8542bd8c4497096b467100

Copyright Text: Source: Sunshine Coast Council Digital and Informations Services Branch (Asset Information Services); ___________ 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: 469018.63320000004
YMin: 7018383.6194
XMax: 514964.05709999986
YMax: 7074972.6227
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 )
• MountType ( type: esriFieldTypeString, alias: Switchboard Mount Type, editable: true, nullable: false, length: 30, defaultValue: Unknown, modelName: MountTy , Coded Values: [Pole: Pole] , [Wall: Wall] , [Fence: Fence] , ...3 more... )
• Coating ( type: esriFieldTypeString, alias: Switchboard Coating, editable: true, nullable: false, length: 30, defaultValue: Unknown, modelName: SwitchboardCoa , Coded Values: [Powdercoat: Powdercoat] , [Paint: Paint] , [Galvanised: Galvanised] , ...2 more... )
• EarthStake ( type: esriFieldTypeString, alias: Switchboard Earth Stake, editable: true, nullable: false, length: 30, defaultValue: Unknown, modelName: EarthSt , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• DedicatedEarthPit ( type: esriFieldTypeString, alias: Switchboard Dedicated Earth Pit, editable: true, nullable: false, length: 30, defaultValue: Unknown, modelName: DedicatedEar , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• EarthLocationDescription ( type: esriFieldTypeString, alias: Switchboard Earth Location Description, editable: true, nullable: true, length: 150, defaultValue: null, modelName: EarthLocationDescription )
• Metering ( type: esriFieldTypeString, alias: Switchboard Metering, editable: true, nullable: false, length: 30, defaultValue: Unknown, modelName: Meter , Coded Values: [Metered: Metered] , [Rate 3: Rate 3] , [Rate 8: Rate 8] , ...1 more... )
• Material ( type: esriFieldTypeString, alias: Switchboard Mterial, editable: true, nullable: false, length: 30, defaultValue: Unknown, modelName: SwitchboardMa , Coded Values: [Aluminium: Aluminium] , [Stainless Steel: Stainless Steel] , [Sheet Steel: Sheet Steel] , ...2 more... )
• GPO ( type: esriFieldTypeString, alias: Switchboard GPO Existance, editable: true, nullable: false, length: 30, defaultValue: Unknown, modelName: GPO , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• GPOConfiguration ( type: esriFieldTypeString, alias: Switchboard GPO Configuration, editable: true, nullable: true, length: 150, defaultValue: null, modelName: GPOConfiguration )
• RCDs ( type: esriFieldTypeString, alias: Switchboard RCDs Existance, editable: true, nullable: false, length: 10, defaultValue: Unknown, modelName: RCDs , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• NoOfRCDs ( type: esriFieldTypeSmallInteger, alias: Switchboard No of RCDs, editable: true, nullable: true, defaultValue: null, modelName: NoOfRCDs )
• HandleType ( type: esriFieldTypeString, alias: Switchboard Handle Type, editable: true, nullable: false, length: 30, defaultValue: Unknown, modelName: HandleTy , Coded Values: [L Handle: L Handle] , [T Handle: T Handle] , [Wingknob: Wingknob] , ...5 more... )
• ConstructionType ( type: esriFieldTypeString, alias: Switchboard Construction Type, editable: true, nullable: false, length: 30, defaultValue: Unknown, modelName: ConstructionTy , Coded Values: [Pillar: Pillar] , [Cubicle: Cubicle] , [In Pole - Insulated enclosure: In Pole - Insulated enclosure] , ...2 more... )
• SupplyArrangement ( type: esriFieldTypeString, alias: Switchboard Supply Arrangement, editable: true, nullable: false, length: 30, defaultValue: Unknown, modelName: SupplyArrang , Coded Values: [1 Phase: 1 Phase] , [3 Phase: 3 Phase] , [Unknown: Unknown] )
• MeterNumber ( type: esriFieldTypeString, alias: Switchboard Meter Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MeterNumber )
• NationalMeterNo ( type: esriFieldTypeString, alias: Switchboard National Meter Identifier, editable: true, nullable: true, length: 150, defaultValue: null, modelName: NationalMeterNo )
• SupplyPointNumber ( type: esriFieldTypeString, alias: Supply Point Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SupplyPointNumber )
• KeyType ( type: esriFieldTypeString, alias: Switchboard Key Type, editable: true, nullable: true, length: 100, defaultValue: null, modelName: KeyType )
• NumberOfDoors ( type: esriFieldTypeSmallInteger, alias: Switchboard Number of Doors, editable: true, nullable: true, defaultValue: null, modelName: NumberOfDoors )
• Width_mm ( type: esriFieldTypeDouble, alias: Switchboard Width (mm), editable: true, nullable: true, defaultValue: null, modelName: Width_mm )
• Depth_mm ( type: esriFieldTypeDouble, alias: Switchboard Depth (mm), editable: true, nullable: true, defaultValue: null, modelName: Depth_mm )
• Height_mm ( type: esriFieldTypeDouble, alias: Switchboard Height (mm), editable: true, nullable: true, defaultValue: null, modelName: Height_mm )
• 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... )
• DataQuality ( type: esriFieldTypeString, alias: Data Quality, editable: true, nullable: true, length: 30, defaultValue: D: Schematic only, modelName: DataQuality , Coded Values: [A: Absolute 3 Dimensions: A: Absolute 3 Dimensions] , [B: +- 300mm: B: +- 300mm] , [C: Interpreted: C: Interpreted] , ...2 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: 20, defaultValue: null, modelName: Owner , Coded Values: [Council: Council] , [Private: Private] , [State: State] , ...6 more... )
• central_asset_id ( type: esriFieldTypeString, alias: central_asset_id, editable: true, nullable: true, length: 20, defaultValue: null, modelName: central_asset_id )
• Site_Name ( type: esriFieldTypeString, alias: Site Name, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Site_Name )
• FeatureTypeCode ( type: esriFieldTypeString, alias: Feature Type Code, editable: true, nullable: true, length: 4, defaultValue: null, modelName: FeatureTypeCode , Coded Values: [ES03: Main Switchboard] , [ES01: Distribution Switchboard] , [ES02: Control Gear Assembly] )
• InstalledDate ( type: esriFieldTypeDate, alias: Installed Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ConstructionDate )
• Quantity ( type: esriFieldTypeInteger, alias: Quantity, editable: true, nullable: true, defaultValue: null, modelName: Quantity )
• DedicatedEventsSection ( type: esriFieldTypeString, alias: DedicatedEventsSection, editable: true, nullable: true, length: 10, defaultValue: Unknown, modelName: DedicatedEventsSection , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• Alias ( type: esriFieldTypeString, alias: Alias, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Alias )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: UtilvecElectricalSwitchboards
  Description:
  Prototype:
  AssetType: Electrical Switchboard
  Material: Unknown
  Coating: Unknown
  EarthStake: Unknown
  ROWSTAMP: 0
  MXSITEID: OPS
  AssetSubType: Unknown
  ConstructionType: Unknown
  Metering: Unknown
  Alias: null
  MXASSETNUM: PENDING
  MountType: Unknown
  HandleType: Unknown
  EarthLocationDescription: null
  GPOConfiguration: null
  DataQuality: D: Schematic only
  NoOfRCDs: null
  DedicatedEarthPit: Unknown
  GPO: Unknown
  RCDs: Unknown
  SupplyArrangement: Unknown
  MeterNumber: null
  NationalMeterNo: null
  SupplyPointNumber: null
  KeyType: null
  NumberOfDoors: null
  Width_mm: null
  Depth_mm: null
  Height_mm: null
  GeomMthd: Unknown
  Status: Active
  Owner: null
  central_asset_id: null
  Site_Name: null
  FeatureTypeCode: null
  InstalledDate: null
  Quantity: null
  DedicatedEventsSection: Unknown
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

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

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