View In:   ArcGIS Online Map Viewer

Name: Pillar Hydrant

Display Field: contract

Type: Feature Layer

Geometry Type: esriGeometryPoint

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 pillar hydrants in South Australia. Pillar hydrants are above ground connection used for fire fighting

Service Item Id: ab709801cdb44730a539d8891c713652

Copyright Text: South Australian Water Corporation

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 144448.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

Extent:

XMin: 1.49758033565E7
YMin: -4556784.810199998
XMax: 1.5695948476499997E7
YMax: -3773408.0018999986
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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 )
• ancillaryrole ( modelName: ANCILLARYROLE, nullable: true, editable: true, defaultValue: null, alias: ANCILLARYROLE, type: esriFieldTypeSmallInteger )
• enabled ( modelName: ENABLED, nullable: true, editable: true, defaultValue: 1, alias: ENABLED, 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 )
• 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 )
• id ( modelName: ID, nullable: true, editable: true, defaultValue: null, alias: ID, type: esriFieldTypeInteger )
• owner ( modelName: Owner, nullable: true, editable: true, defaultValue: SAW, length: 3, alias: Owner, type: esriFieldTypeString , Coded Values: [SAW: SA Water] , [OTH: Other] )
• notes ( modelName: NOTES, nullable: true, editable: true, defaultValue: null, length: 32, alias: Notes and Comments, type: esriFieldTypeString )
• conversion ( modelName: CONVERSION, nullable: true, editable: true, defaultValue: null, length: 20, alias: CONVERSION, type: esriFieldTypeString )
• symbolrotation ( modelName: SYMBOLROTATION, nullable: true, editable: true, defaultValue: null, alias: SYMBOLROTATION, type: esriFieldTypeDouble )
• subtype ( modelName: Subtype, nullable: true, editable: true, defaultValue: 1, alias: Subtype, type: esriFieldTypeInteger )
• status ( modelName: STATUS, nullable: true, editable: true, defaultValue: INS, length: 4, alias: Current Status, type: esriFieldTypeString , Coded Values: [INS: In Service] , [AB: Abandoned] , [INSB: In Service for Bulk Supply] )
• 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 )
• 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 )
• 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... )

Templates:

• Name: Pillar Hydrant
  Description:
  Prototype:
  abandondate_dq: null
  notes: null
  installdate: null
  noting_page: null
  docket_year: null
  dcdbshiftdate: null
  giscrid: null
  free_asset: 0
  enabled: 1
  maintainer: SAW
  operator: SAW
  horizontal_acc: null
  subtype: 1
  symbolrotation: null
  id: null
  dataquality: 2ACM
  pressurezoneid: null
  conversion: null
  owner: SAW
  docket_ref: null
  ancillaryrole: null
  contract: null
  installdate_dq: null
  abandondate: null
  noting_date: null
  assetstatus: INSERVICE
  featurequality: null
  status: INS
  
  Drawing Tool: esriFeatureEditToolPoint

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