View In:   ArcGIS Online Map Viewer

Name: Water Main

Display Field: material

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: { "desc": "This dataset is a component of SA Water corporate Water Reticulation Asset Register and contains the location and description of all Water Mains. A water main is a pipe in a water reticulation system. Also see Reclaimed Water Main and other Waste Water datasets." }

Service Item Id: ab709801cdb44730a539d8891c713652

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 144447.638572

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

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: false
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: true
Supports Query With LOD Spatial Reference: true
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:

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

Templates:

• Name: Water Main
  Description:
  Prototype:
  notes: null
  installdate: null
  lining_date: null
  noting_page: null
  dcdbshiftdate: null
  pressurerating: null
  cpcdate: null
  maintainer: SAW
  operator: SAW
  sleevediameter: null
  id: null
  externaldiameter: null
  plan_number: none
  lining_page: null
  materiallogic: null
  contract: null
  cathodicprotection: NP
  installdate_dq: null
  sleevematerial: null
  abandondate: null
  work_reference: null
  noting_date: null
  work_ref_type: null
  gazettal_day: null
  cpfilenumber: null
  noting_day: null
  internaldiameter: null
  platethickness: null
  assetstatus: INSERVICE
  status: GAZ
  materialunv: null
  nominaldiameter: null
  gazettal_page: null
  abandondate_dq: null
  c_value: null
  nogdate: null
  docket_year: null
  gulletid: null
  giscrid: null
  availability: AV
  free_asset: 0
  lining_code: null
  enabled: 1
  extrainfo: null
  nominaldiameterunv: null
  sys_id: 0
  horizontal_acc: null
  noting_year: null
  subtype: 5
  dataquality: 2ACM
  pressurezoneid: null
  conversion: null
  gazettal_month: null
  owner: SAW
  docket_ref: null
  date_created: null
  below_ground: 1
  noting_code: null
  edit_tracking_id: null
  gazettal_year: null
  jointtype: null
  potability: 2
  material: null
  date_modified: null
  shutoffblockid: null
  historicid: null
  noting_month: null
  featurequality: null
  
  Drawing Tool: esriFeatureEditToolLine

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata