Name: Water Main

Display Field: material

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: This dataset is a component of South Australian Water Corporation (SA Water) corporate Water Reticulation Asset Register and contains the location and description of all Water Mains in South Australia. A water main is a pipe in a water reticulation system.

Service Item Id: 68525ad902b946cf876e00abc6f6556e

Copyright Text: South Australian Water Corporation

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 1.4874458605300002E7
YMin: -4587481.138
XMax: 1.5696177010899998E7
YMax: -3160716.7654
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [0, 112, 255, 255]
Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

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

Fields:

• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• enabled ( type: esriFieldTypeSmallInteger, alias: ENABLED , Coded Values: [0: False] , [1: True] )
• material ( type: esriFieldTypeString, alias: Pipe Material, length: 10 , Coded Values: [DICL: Ductile Iron Concrete Lined] , [MSCL: Mild Steel Concrete Lined] , [CU: Copper] , ...27 more... )
• nominaldiameter ( type: esriFieldTypeInteger, alias: Nominal Diameter , Coded Values: [0: 0] , [15: 15] , [20: 20] , ...76 more... )
• status ( type: esriFieldTypeString, alias: Current Status, length: 4 , Coded Values: [GAZ: Gazetted - New] , [ABR: Gazetted - Abandoned Replaced] , [AB: Gazetted - Abandoned Not Replaced] , ...10 more... )
• gazettal_day ( type: esriFieldTypeSmallInteger, alias: Gazettal Day , Range: [0, 31] )
• gazettal_month ( type: esriFieldTypeSmallInteger, alias: Gazettal Month , Range: [0, 12] )
• gazettal_year ( type: esriFieldTypeSmallInteger, alias: Gazettal Year , Range: [1870, 2020] )
• gazettal_page ( type: esriFieldTypeSmallInteger, alias: Gazettal Page )
• availability ( type: esriFieldTypeString, alias: Availability for Use, length: 10 , Coded Values: [AV: Available] , [NA: Not Available] , [AP: Application Only] , ...29 more... )
• below_ground ( type: esriFieldTypeSmallInteger, alias: Below Ground , Coded Values: [0: False] , [1: True] )
• docket_ref ( type: esriFieldTypeInteger, alias: Docket Ref )
• docket_year ( type: esriFieldTypeSmallInteger, alias: Docket Year , Range: [1870, 2020] )
• free_asset ( type: esriFieldTypeSmallInteger, alias: Free Asset , Coded Values: [1: Yes] , [0: No] , [2: Unknown] )
• contract ( type: esriFieldTypeString, alias: Contract Number, length: 12 )
• plan_number ( type: esriFieldTypeString, alias: Plan Number, length: 20 )
• owner ( type: esriFieldTypeString, alias: Owner of Asset, length: 3 , Coded Values: [SAW: SA Water] , [OTH: Other] )
• nogdate ( type: esriFieldTypeString, alias: NOG Date, length: 8 )
• notes ( type: esriFieldTypeString, alias: Notes and Comments, length: 32 )
• shutoffblockid ( type: esriFieldTypeInteger, alias: Shut Off Block ID )
• id ( type: esriFieldTypeInteger, alias: ID )
• conversion ( type: esriFieldTypeString, alias: CONVERSION, length: 20 )
• subtype ( type: esriFieldTypeInteger, alias: Subtype )
• noting_day ( type: esriFieldTypeSmallInteger, alias: Noting Day , Range: [0, 31] )
• noting_month ( type: esriFieldTypeSmallInteger, alias: Noting Month , Range: [0, 12] )
• noting_year ( type: esriFieldTypeSmallInteger, alias: Noting Year , Range: [1870, 2020] )
• externaldiameter ( type: esriFieldTypeInteger, alias: External Diameter )
• internaldiameter ( type: esriFieldTypeInteger, alias: Internal Diameter )
• gulletid ( type: esriFieldTypeInteger, alias: Gullet ID )
• lining_code ( type: esriFieldTypeString, alias: Lining Code, length: 2 , Coded Values: [CA: Concrete Lining Book A] , [CB: Concrete Lining Book B] , [CC: Concrete Lining Book C] , ...10 more... )
• lining_date ( type: esriFieldTypeString, alias: Lining Date, length: 8 )
• lining_page ( type: esriFieldTypeSmallInteger, alias: Lining Page )
• sys_id ( type: esriFieldTypeSmallInteger, alias: Sys id )
• noting_code ( type: esriFieldTypeString, alias: Noting Code, length: 4 )
• noting_date ( type: esriFieldTypeString, alias: Noting Date, length: 8 )
• noting_page ( type: esriFieldTypeSmallInteger, alias: Noting Page )
• featurequality ( type: esriFieldTypeString, alias: Feature Quality, length: 4 , Coded Values: [NPAR: NPAR - Location Unknown] , [GP5: GPS - 5m] , [NV: Not Verified] , ...7 more... )
• pressurezoneid ( type: esriFieldTypeSmallInteger, alias: Pressure Zone ID )
• jointtype ( type: esriFieldTypeString, alias: Joint Type, length: 4 , Coded Values: [RR: Rubber Ring] , [RRR: Restrained Rubber Ring] , [LEAD: Lead] , ...10 more... )
• platethickness ( type: esriFieldTypeSmallInteger, alias: Pipe Platethickness )
• extrainfo ( type: esriFieldTypeString, alias: Pipe Specifications, length: 20 , Coded Values: [S2: Series 2] , [S1: Series 1] , [SINT: Sintakote] , ...6 more... )
• materiallogic ( type: esriFieldTypeInteger, alias: MATERIALLOGIC )
• c_value ( type: esriFieldTypeDouble, alias: Coeff Friction )
• pressurerating ( type: esriFieldTypeDouble, alias: Pressure Rating )
• sleevematerial ( type: esriFieldTypeString, alias: Sleeve Material, length: 10 , Coded Values: [DICL: Ductile Iron Concrete Lined] , [MSCL: Mild Steel Concrete Lined] , [CU: Copper] , ...27 more... )
• sleevediameter ( type: esriFieldTypeInteger, alias: Sleeve Diameter , Coded Values: [0: 0] , [20: 20] , [25: 25] , ...72 more... )
• materialunv ( type: esriFieldTypeString, alias: MATERIALUNV, length: 10 )
• nominaldiameterunv ( type: esriFieldTypeInteger, alias: NOMINALDIAMETERUNV )
• potability ( type: esriFieldTypeSmallInteger, alias: Potability , Coded Values: [0: Not Allocated] , [1: Potable system - raw water] , [2: Potable system - drinking water (ADWG compliant)] , ...3 more... )
• date_created ( type: esriFieldTypeDate, alias: DATE_CREATED, length: 8 )
• date_modified ( type: esriFieldTypeDate, alias: DATE_MODIFIED, length: 8 )
• edit_tracking_id ( type: esriFieldTypeInteger, alias: Edit Tracking ID )
• cathodicprotection ( type: esriFieldTypeString, alias: CATHODICPROTECTION, length: 10 , Coded Values: [NP: Not Protected] , [IC: Impressed Current] , [SP: Sacrificially Protected] , ...1 more... )
• cpfilenumber ( type: esriFieldTypeString, alias: CPFILENUMBER, length: 50 )
• assetstatus ( type: esriFieldTypeString, alias: AssetStatus, length: 50 , Coded Values: [INSERVICE: In service] , [NOTINUSE: Not in service] , [PLANNED: Planned] , ...4 more... )
• dataquality ( type: esriFieldTypeString, alias: DataQuality, length: 50 , Coded Values: [2ACM: AsCon - manual] , [1ACA: AsCon - auto] , [3DDM: Design - manual] , ...7 more... )
• dcdbshiftdate ( type: esriFieldTypeDate, alias: DCDBSHIFTDATE, length: 8 )
• historicid ( type: esriFieldTypeInteger, alias: HISTORICID )
• cpcdate ( type: esriFieldTypeDate, alias: CPCDATE, length: 8 )
• giscrid ( type: esriFieldTypeInteger, alias: GIS Correction ID )
• installdate ( type: esriFieldTypeDate, alias: INSTALLDATE, length: 8 )
• horizontal_acc ( type: esriFieldTypeString, alias: Horizontal Accuracy, length: 10 , Coded Values: [GPS_50mm: GPS 50mm] , [GPS_200mm: GPS 200mm] , [GPS_300mm: GPS 300mm] , ...4 more... )
• installdate_dq ( type: esriFieldTypeString, alias: installdate_dq, length: 8 , Coded Values: [AsConDMY: AsCon DMY] , [AsConMY: AsCon MY] , [AsConY: AsCon Y] , ...8 more... )
• maintainer ( type: esriFieldTypeString, alias: MAINTAINER, length: 12 , Coded Values: [SAW: SA Water] , [OTH: Other] )
• operator ( type: esriFieldTypeString, alias: OPERATOR, length: 12 , Coded Values: [SAW: SA Water] , [OTH: Other] )
• abandondate ( type: esriFieldTypeDate, alias: ABANDONDATE, length: 8 )
• abandondate_dq ( type: esriFieldTypeString, alias: ABANDONDATE_DQ, length: 8 , Coded Values: [AsConDMY: AsCon DMY] , [AsConMY: AsCon MY] , [AsConY: AsCon Y] , ...8 more... )
• work_reference ( type: esriFieldTypeString, alias: Work Reference, length: 30 )
• work_ref_type ( type: esriFieldTypeString, alias: Work Reference Type, length: 30 , Coded Values: [ThirdPartyWorks: Third Party Works] , [Output: Output] , [WorkOrder: Work Order] , ...5 more... )
• shape ( type: esriFieldTypeGeometry, alias: Shape )
• st_length(shape) ( type: esriFieldTypeDouble, alias: st_length(shape) )

Types:

ID: 9
Name: Supernatant
Domains:
• enabled:
  Inherited
• material:
  Inherited
• nominaldiameter:
  Inherited
• status:
  Inherited
• gazettal_day:
  Inherited
• gazettal_month:
  Inherited
• gazettal_year:
  Inherited
• availability:
  Inherited
• below_ground:
  Inherited
• docket_year:
  Inherited
• free_asset:
  Inherited
• owner:
  Inherited
• noting_day:
  Inherited
• noting_month:
  Inherited
• noting_year:
  Inherited
• lining_code:
  Inherited
• featurequality:
  Inherited
• jointtype:
  Inherited
• extrainfo:
  Inherited
• sleevematerial:
  Inherited
• sleevediameter:
  Inherited
• potability:
  Inherited
• cathodicprotection:
  Inherited
• assetstatus:
  Inherited
• dataquality:
  Inherited
• horizontal_acc:
  Inherited
• installdate_dq:
  Inherited
• maintainer:
  Inherited
• operator:
  Inherited
• abandondate_dq:
  Inherited
• work_ref_type:
  Inherited

---

ID: 1
Name: Distribution
Domains:
• enabled:
  Inherited
• material:
  Inherited
• nominaldiameter:
  Inherited
• status:
  Inherited
• gazettal_day:
  Inherited
• gazettal_month:
  Inherited
• gazettal_year:
  Inherited
• availability:
  Inherited
• below_ground:
  Inherited
• docket_year:
  Inherited
• free_asset:
  Inherited
• owner:
  Inherited
• noting_day:
  Inherited
• noting_month:
  Inherited
• noting_year:
  Inherited
• lining_code:
  Inherited
• featurequality:
  Inherited
• jointtype:
  Inherited
• extrainfo:
  Inherited
• sleevematerial:
  Inherited
• sleevediameter:
  Inherited
• potability:
  Inherited
• cathodicprotection:
  Inherited
• assetstatus:
  Inherited
• dataquality:
  Inherited
• horizontal_acc:
  Inherited
• installdate_dq:
  Inherited
• maintainer:
  Inherited
• operator:
  Inherited
• abandondate_dq:
  Inherited
• work_ref_type:
  Inherited

---

ID: 7
Name: Vent
Domains:
• enabled:
  Inherited
• material:
  Inherited
• nominaldiameter:
  Inherited
• status:
  Inherited
• gazettal_day:
  Inherited
• gazettal_month:
  Inherited
• gazettal_year:
  Inherited
• availability:
  Inherited
• below_ground:
  Inherited
• docket_year:
  Inherited
• free_asset:
  Inherited
• owner:
  Inherited
• noting_day:
  Inherited
• noting_month:
  Inherited
• noting_year:
  Inherited
• lining_code:
  Inherited
• featurequality:
  Inherited
• jointtype:
  Inherited
• extrainfo:
  Inherited
• sleevematerial:
  Inherited
• sleevediameter:
  Inherited
• potability:
  Inherited
• cathodicprotection:
  Inherited
• assetstatus:
  Inherited
• dataquality:
  Inherited
• horizontal_acc:
  Inherited
• installdate_dq:
  Inherited
• maintainer:
  Inherited
• operator:
  Inherited
• abandondate_dq:
  Inherited
• work_ref_type:
  Inherited

---

ID: 4
Name: Bypass
Domains:
• enabled:
  Inherited
• material:
  Inherited
• nominaldiameter:
  Inherited
• status:
  Inherited
• gazettal_day:
  Inherited
• gazettal_month:
  Inherited
• gazettal_year:
  Inherited
• availability:
  Inherited
• below_ground:
  Inherited
• docket_year:
  Inherited
• free_asset:
  Inherited
• owner:
  Inherited
• noting_day:
  Inherited
• noting_month:
  Inherited
• noting_year:
  Inherited
• lining_code:
  Inherited
• featurequality:
  Inherited
• jointtype:
  Inherited
• extrainfo:
  Inherited
• sleevematerial:
  Inherited
• sleevediameter:
  Inherited
• potability:
  Inherited
• cathodicprotection:
  Inherited
• assetstatus:
  Inherited
• dataquality:
  Inherited
• horizontal_acc:
  Inherited
• installdate_dq:
  Inherited
• maintainer:
  Inherited
• operator:
  Inherited
• abandondate_dq:
  Inherited
• work_ref_type:
  Inherited

---

ID: 6
Name: Transmission
Domains:
• enabled:
  Inherited
• material:
  Inherited
• nominaldiameter:
  Inherited
• status:
  Inherited
• gazettal_day:
  Inherited
• gazettal_month:
  Inherited
• gazettal_year:
  Inherited
• availability:
  Inherited
• below_ground:
  Inherited
• docket_year:
  Inherited
• free_asset:
  Inherited
• owner:
  Inherited
• noting_day:
  Inherited
• noting_month:
  Inherited
• noting_year:
  Inherited
• lining_code:
  Inherited
• featurequality:
  Inherited
• jointtype:
  Inherited
• extrainfo:
  Inherited
• sleevematerial:
  Inherited
• sleevediameter:
  Inherited
• potability:
  Inherited
• cathodicprotection:
  Inherited
• assetstatus:
  Inherited
• dataquality:
  Inherited
• horizontal_acc:
  Inherited
• installdate_dq:
  Inherited
• maintainer:
  Inherited
• operator:
  Inherited
• abandondate_dq:
  Inherited
• work_ref_type:
  Inherited

---

ID: 10
Name: Sludge
Domains:
• enabled:
  Inherited
• material:
  Inherited
• nominaldiameter:
  Inherited
• status:
  Inherited
• gazettal_day:
  Inherited
• gazettal_month:
  Inherited
• gazettal_year:
  Inherited
• availability:
  Inherited
• below_ground:
  Inherited
• docket_year:
  Inherited
• free_asset:
  Inherited
• owner:
  Inherited
• noting_day:
  Inherited
• noting_month:
  Inherited
• noting_year:
  Inherited
• lining_code:
  Inherited
• featurequality:
  Inherited
• jointtype:
  Inherited
• extrainfo:
  Inherited
• sleevematerial:
  Inherited
• sleevediameter:
  Inherited
• potability:
  Inherited
• cathodicprotection:
  Inherited
• assetstatus:
  Inherited
• dataquality:
  Inherited
• horizontal_acc:
  Inherited
• installdate_dq:
  Inherited
• maintainer:
  Inherited
• operator:
  Inherited
• abandondate_dq:
  Inherited
• work_ref_type:
  Inherited

---

ID: 2
Name: InletTunnel
Domains:
• enabled:
  Inherited
• material:
  Inherited
• nominaldiameter:
  Inherited
• status:
  Inherited
• gazettal_day:
  Inherited
• gazettal_month:
  Inherited
• gazettal_year:
  Inherited
• availability:
  Inherited
• below_ground:
  Inherited
• docket_year:
  Inherited
• free_asset:
  Inherited
• owner:
  Inherited
• noting_day:
  Inherited
• noting_month:
  Inherited
• noting_year:
  Inherited
• lining_code:
  Inherited
• featurequality:
  Inherited
• jointtype:
  Inherited
• extrainfo:
  Inherited
• sleevematerial:
  Inherited
• sleevediameter:
  Inherited
• potability:
  Inherited
• cathodicprotection:
  Inherited
• assetstatus:
  Inherited
• dataquality:
  Inherited
• horizontal_acc:
  Inherited
• installdate_dq:
  Inherited
• maintainer:
  Inherited
• operator:
  Inherited
• abandondate_dq:
  Inherited
• work_ref_type:
  Inherited

---

ID: 3
Name: OutletTunnel
Domains:
• enabled:
  Inherited
• material:
  Inherited
• nominaldiameter:
  Inherited
• status:
  Inherited
• gazettal_day:
  Inherited
• gazettal_month:
  Inherited
• gazettal_year:
  Inherited
• availability:
  Inherited
• below_ground:
  Inherited
• docket_year:
  Inherited
• free_asset:
  Inherited
• owner:
  Inherited
• noting_day:
  Inherited
• noting_month:
  Inherited
• noting_year:
  Inherited
• lining_code:
  Inherited
• featurequality:
  Inherited
• jointtype:
  Inherited
• extrainfo:
  Inherited
• sleevematerial:
  Inherited
• sleevediameter:
  Inherited
• potability:
  Inherited
• cathodicprotection:
  Inherited
• assetstatus:
  Inherited
• dataquality:
  Inherited
• horizontal_acc:
  Inherited
• installdate_dq:
  Inherited
• maintainer:
  Inherited
• operator:
  Inherited
• abandondate_dq:
  Inherited
• work_ref_type:
  Inherited

---

ID: 5
Name: Scour
Domains:
• enabled:
  Inherited
• material:
  Inherited
• nominaldiameter:
  Inherited
• status:
  Inherited
• gazettal_day:
  Inherited
• gazettal_month:
  Inherited
• gazettal_year:
  Inherited
• availability:
  Inherited
• below_ground:
  Inherited
• docket_year:
  Inherited
• free_asset:
  Inherited
• owner:
  Inherited
• noting_day:
  Inherited
• noting_month:
  Inherited
• noting_year:
  Inherited
• lining_code:
  Inherited
• featurequality:
  Inherited
• jointtype:
  Inherited
• extrainfo:
  Inherited
• sleevematerial:
  Inherited
• sleevediameter:
  Inherited
• potability:
  Inherited
• cathodicprotection:
  Inherited
• assetstatus:
  Inherited
• dataquality:
  Inherited
• horizontal_acc:
  Inherited
• installdate_dq:
  Inherited
• maintainer:
  Inherited
• operator:
  Inherited
• abandondate_dq:
  Inherited
• work_ref_type:
  Inherited

---

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata