View In:   ArcGIS Online Map Viewer

Parent Layer: SCC Water Services

Name: Water Pipes

Display Field: site_name

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: This dataset is intended to represent the location and basic attributes of known, recorded, water pipe assets within the Sunshine Coast LGA. Features within this dataset have been captured by various Sunshine Coast Council personnel and methodologies. Keywords: Irrigation, Irrigation Network, Irrigation Pipes, Pipes, Open Space, Parks, Watering System, Landscaping, Landscaping maintenance.

Service Item Id: 1d5ff8d70f8542bd8c4497096b467100

Copyright Text: Source: Sunshine Coast Council Information Communication Technology Services Branch (Asset Information Services); ___________ Branch

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 144448.0

Max Scale: 300.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: 472698.94130000006
YMin: 7018303.8243
XMax: 514881.0429999996
YMax: 7071788.7234
Spatial Reference: 7856  (7856)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [0, 112, 255, 255]
Width: 3
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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: true, defaultValue: null, modelName: SHAPE.STLength(), required: true )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• 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: 25, 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: 25, defaultValue: null, modelName: ModifyUser )
• GeomMthd ( type: esriFieldTypeString, alias: GeomMthd, editable: true, nullable: true, length: 50, defaultValue: null, 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... )
• LegacyAssetID ( type: esriFieldTypeString, alias: LegacyAssetID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LegacyAssetID )
• 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... )
• InstalledDate ( type: esriFieldTypeDate, alias: InstalledDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ConstructionDate )
• AssetSource ( type: esriFieldTypeString, alias: AssetSource, editable: true, nullable: true, 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 )
• ProjectNo ( type: esriFieldTypeString, alias: ProjectNo, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectNo )
• DrawingNo ( type: esriFieldTypeString, alias: DrawingNo, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DrawingNo )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 500, defaultValue: null, modelName: Comments )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• 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 )
• DrawingLink ( type: esriFieldTypeString, alias: DrawingLink, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DrawingLink )
• AssetManager ( type: esriFieldTypeString, alias: AssetManager, editable: true, nullable: true, 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: true, length: 30, defaultValue: Unknown, modelName: MaintainedBy_1 , 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_1 , Coded Values: [Beerwah Precinct: Beerwah Precinct] , [Buderim Precinct: Buderim Precinct] , [Bulcock Street/Caloundra Espla: Bulcock Street/Caloundra Espla] , ...23 more... )
• site_name ( type: esriFieldTypeString, alias: site_name, editable: true, nullable: true, length: 40, defaultValue: null, modelName: site_name )
• RevisionNumber ( type: esriFieldTypeSmallInteger, alias: RevisionNumber, editable: true, nullable: true, defaultValue: null, modelName: RevisionNumber )
• Material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 30, defaultValue: Unknown, modelName: Material_1 , Coded Values: [Copper: Copper] , [Polyethylene: Polyethylene] , [Unknown: Unknown] , ...4 more... )
• FeatureTypeCode ( type: esriFieldTypeString, alias: FeatureTypeCode, editable: true, nullable: true, length: 4, defaultValue: null, modelName: FeatureTypeCode , Coded Values: [WP01: Domestic Service] , [WP02: Irrigation Pipe] , [WP03: Fire Service] , ...1 more... )
• WaterQuality ( type: esriFieldTypeString, alias: WaterQuality, editable: true, nullable: true, length: 30, defaultValue: Unknown, modelName: WaterQuality_1 , Coded Values: [Potable: Potable] , [Raw/Untreated: Raw/Untreated] , [Recycled Non-potable: Recycled Non-potable] , ...1 more... )
• Placement ( type: esriFieldTypeString, alias: Placement, editable: true, nullable: true, length: 30, defaultValue: Unknown, modelName: Placement_1 , Coded Values: [Unknown: Unknown] , [Surface: Surface] , [Underground: Underground] )
• 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: 30, defaultValue: null, modelName: Division , Coded Values: [Division 1: Division 1] , [Division 2: Division 2] , [Division 3: Division 3] , ...8 more... )
• Length_m ( type: esriFieldTypeDouble, alias: Length_m, editable: true, nullable: true, defaultValue: null, modelName: Length_m )
• Diameter_mm ( type: esriFieldTypeString, alias: Diameter_mm, editable: true, nullable: true, length: 30, defaultValue: Unknown, modelName: Diameter_mm , Coded Values: [Unknown: Unknown] , [100: 100] , [19: 19] , ...12 more... )
• DataQuality ( type: esriFieldTypeString, alias: DataQuality, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DataQuality , Coded Values: [A - High Accuracy: A - High Accuracy] , [B - Relative Accuracy (+/- 300mm): B - Relative Accuracy (+/- 300mm)] , [C - Low Accuracy: C - Low Accuracy] , ...2 more... )
• FinanceAssetNo ( type: esriFieldTypeString, alias: FinanceAssetNo, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FinanceAssetNo )
• FinDate ( type: esriFieldTypeString, alias: FinDate, editable: true, nullable: true, length: 10, defaultValue: null, modelName: FinDate )
• ReplacedAssetNo ( type: esriFieldTypeString, alias: ReplacedAssetNo, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ReplacedAssetNo )
• 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 )

Templates:

• Name: Water Pipes - Irrigation
  Description:
  Prototype:
  ROWSTAMP: 0
  MXSITEID: OPS
  MXASSETNUM: NON-SCC
  DispDate: null
  ReplacedAssetNo: null
  FinDate: null
  FinanceAssetNo: null
  DataQuality: null
  Diameter_mm: Unknown
  GeomMthd: null
  LegacyAssetID: null
  Status: null
  Owner: null
  InstalledDate: null
  AssetSource: Unknown
  Location: null
  ProjectNo: null
  DrawingNo: null
  Notes: null
  StatusChangeReason: null
  central_asset_id: null
  site_code: null
  DrawingLink: null
  AssetManager: Unknown
  MaintainedBy: Unknown
  ServicePrecinct: Unknown
  site_name: null
  RevisionNumber: null
  Material: Unknown
  FeatureTypeCode: null
  WaterQuality: Unknown
  Placement: Unknown
  Locality: null
  Division: null
  Length_m: null
  
  Drawing Tool: esriFeatureEditToolLine

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: 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 Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata