Name: Water Service Connection

Display Field: SAPOBJECTID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 518609.8186
YMin: 6883080.2061
XMax: 554068.4649
YMax: 6933055.2168
Spatial Reference: 28356 (28356)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"WATER_CATEGORY","defaultSymbol":{"type":"esriSLS","style":"esriSLSSolid","color":[112,0,143,255],"width":1},"defaultLabel":"","uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[50,57,146,255],"width":2},"value":"POTABLE","label":"Potable"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[197,0,255,255],"width":2},"value":"RECYCLED A+","label":"RECYCLED A+; RECYCLED B; RECYCLED C"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[197,0,255,255],"width":2},"value":"RECYCLED B","label":"RECYCLED A+; RECYCLED B; RECYCLED C"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[197,0,255,255],"width":2},"value":"RECYCLED C","label":"RECYCLED A+; RECYCLED B; RECYCLED C"}],"fieldDelimiter":","},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field: WATER_CATEGORY

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• SAPOBJECTID (type: esriFieldTypeString, alias: SAPOBJECTID, SQL Type: sqlTypeOther, length: 18, nullable: true, editable: true)
• CLASS (type: esriFieldTypeString, alias: CLASS, SQL Type: sqlTypeOther, length: 18, nullable: true, editable: true)
• GIS_USER_STATUS (type: esriFieldTypeString, alias: GIS_USER_STATUS, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• OBJECT_TYPE (type: esriFieldTypeString, alias: OBJECT_TYPE, SQL Type: sqlTypeOther, length: 10, nullable: false, editable: true)
• GIS_SYSTEM_STATUS (type: esriFieldTypeString, alias: GIS_SYSTEM_STATUS, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• GIS_MANUFACTURER (type: esriFieldTypeString, alias: GIS_MANUFACTURER, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• GIS_MANUSERIALNO (type: esriFieldTypeString, alias: GIS_MANUSERIALNO, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• GIS_MODEL_NUMBER (type: esriFieldTypeString, alias: GIS_MODEL_NUMBER, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• GIS_PROJECT_DEVELOPER_APPL_ID (type: esriFieldTypeString, alias: GIS_PROJECT_DEVELOPER_APPL_ID, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• GIS_DRAWING_NUMBER (type: esriFieldTypeString, alias: GIS_DRAWING_NUMBER, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• ASSET_LEVEL_ACCURACY (type: esriFieldTypeString, alias: ASSET_LEVEL_ACCURACY, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [A+: A+ +/- 10mm Absolute Location/Survey], [A: A +/- 50mm Absolute Location/Survey], [B: B +/- 500mm No-Dig Survey], ... 4 more ...)
• ASSET_POSITIONAL_ACCURACY (type: esriFieldTypeString, alias: ASSET_POSITIONAL_ACCURACY, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [A: A +/- 50mm Absolute Location/Survey], [B: B +/- 300mm Absolute Location/Survey], [C: C +/- 300mm Relative position], ... 2 more ...)
• PHOTO_LINK (type: esriFieldTypeString, alias: PHOTO_LINK, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• PHOTO_LEGACY (type: esriFieldTypeString, alias: PHOTO_LEGACY, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• GIS_ACQUISITION_METHOD (type: esriFieldTypeString, alias: GIS_ACQUISITION_METHOD, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [CAPEX: Capital Expenditure], [CONTR: Contributed], [DON: Donated], ... 2 more ...)
• GIS_STARTUP_DATE (type: esriFieldTypeDate, alias: GIS_STARTUP_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GIS_ASSET_FUNDING_BASIS (type: esriFieldTypeString, alias: GIS_ASSET_FUNDING_BASIS, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [GCCC: GCCC], [DEV: Developer], [SG: State Government], ... 3 more ...)
• FUNCTIONAL_LOC (type: esriFieldTypeString, alias: FUNCTIONAL_LOC, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• SUPERORD_EQUIP (type: esriFieldTypeString, alias: SUPERORD_EQUIP, SQL Type: sqlTypeOther, length: 18, nullable: true, editable: true)
• GIS_CUSTODIAN (type: esriFieldTypeString, alias: ASSET_MANAGER, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true, Coded Values: [51003030: Manager Property Services], [51000811: Manager Parks and Recreational Services], [51000989: Manager Community Venues and Services], ... 8 more ...)
• GIS_DESCRIPTION (type: esriFieldTypeString, alias: GIS_DESCRIPTION, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• SORT_FIELD (type: esriFieldTypeString, alias: SORT_FIELD, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• GIS_OWNER (type: esriFieldTypeString, alias: GIS_OWNER, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [COMB: Commonwealth Bureau Meteorol], [COMG: Commonwealth Government], [DE: Dept Education], ... 14 more ...)
• RE_ENRICH (type: esriFieldTypeString, alias: RE_ENRICH, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• SYNCERRORDESC (type: esriFieldTypeString, alias: SYNCERRORDESC, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• SYNCDATE (type: esriFieldTypeDate, alias: SYNCDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GIS_EQUIPMENT_CATEGORY (type: esriFieldTypeString, alias: GIS_EQUIPMENT_CATEGORY, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• GIS_ACQUISITION_PROJECT (type: esriFieldTypeString, alias: GIS_ACQUISITION_PROJECT, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• WATER_SRV_CONNECTN_MATERIAL (type: esriFieldTypeString, alias: WATER_SRV_CONNECTN_MATERIAL, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [DI: Ductile Iron], [COPPER: Copper], [PE: Polyethylene])
• WATER_SRV_CONNECTN_CLASS (type: esriFieldTypeString, alias: WATER_SRV_CONNECTN_CLASS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [PN6: PN6], [PN6.3: PN6.3], [PN8: PN8], ... 37 more ...)
• SYNCSTATUS (type: esriFieldTypeInteger, alias: SYNCSTATUS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CREATED_USER (type: esriFieldTypeString, alias: CREATED_USER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CREATED_DATE (type: esriFieldTypeDate, alias: CREATED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LAST_EDITED_USER (type: esriFieldTypeString, alias: LAST_EDITED_USER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LAST_EDITED_DATE (type: esriFieldTypeDate, alias: LAST_EDITED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DATA_SOURCE (type: esriFieldTypeString, alias: DATA_SOURCE, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [SKE: Sketch], [HIS: Historical Records], [EDF: Electronic Drawing File], ... 4 more ...)
• CONDUIT (type: esriFieldTypeString, alias: CONDUIT, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [YES: Yes], [NO: No])
• WATER_SRV_CONNECTN_USE (type: esriFieldTypeString, alias: WATER_SRV_CONNECTN_USE, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [SERVICE-FIRE: Fire Service], [SERVICE-DOMESTIC: Domestic Service])
• WATER_CATEGORY (type: esriFieldTypeString, alias: WATER_CATEGORY, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [POTABLE: Potable], [NON-DRINKING: Potable Wtr in purple A+ pipes], [RECYCLED A: Rec water pipes-class A water], ... 1 more ...)
• WATER_PIPE_LINING (type: esriFieldTypeString, alias: WATER_PIPE_LINING, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [FBC: Fusion Bonded Coated], [CL: Cement Lined - Normal], [CL_SR: Cement Ln - Sulphate Resistant], ... 6 more ...)
• RELINING_DATE (type: esriFieldTypeDate, alias: RELINING_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• RELINING_MATERIAL (type: esriFieldTypeString, alias: RELINING_MATERIAL, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [CONCRETE: Concrete], [CURED IN-PLACE PIPE: Cured in-place pipe], [POLY VINYL CHLORIDE: Poly Vinyl Chloride], ... 7 more ...)
• RELINING_LENGTH_M (type: esriFieldTypeDouble, alias: RELINING_LENGTH_M, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RELINING_INTERNAL_DIAMETER_MM (type: esriFieldTypeDouble, alias: RELINING_INTERNAL_DIAMETER_MM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WATER_PIPE_PROTECTION (type: esriFieldTypeString, alias: WATER_PIPE_PROTECTION, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [TBA: TBA], [FBC: Fusion Bonded Coated], [FBE: Fusion Bonded Epoxy], ... 11 more ...)
• FROM_SAPID (type: esriFieldTypeString, alias: FROM_SAPID, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• TO_SAPID (type: esriFieldTypeString, alias: TO_SAPID, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• DIAMETER_MM (type: esriFieldTypeDouble, alias: DIAMETER_MM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LENGTH_M (type: esriFieldTypeDouble, alias: LENGTH_M, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Types:

ID: POTABLE
Name: Potable
Domains:

• Field Name: ASSET_LEVEL_ACCURACY
  Inherited
  
• Field Name: ASSET_POSITIONAL_ACCURACY
  Inherited
  
• Field Name: GIS_ACQUISITION_METHOD
  Inherited
  
• Field Name: GIS_ASSET_FUNDING_BASIS
  Inherited
  
• Field Name: GIS_CUSTODIAN
  Inherited
  
• Field Name: GIS_OWNER
  Inherited
  
• Field Name: WATER_SRV_CONNECTN_MATERIAL
  Inherited
  
• Field Name: WATER_SRV_CONNECTN_CLASS
  Inherited
  
• Field Name: DATA_SOURCE
  Inherited
  
• Field Name: CONDUIT
  Inherited
  
• Field Name: WATER_SRV_CONNECTN_USE
  Inherited
  
• Field Name: WATER_CATEGORY
  Inherited
  
• Field Name: WATER_PIPE_LINING
  Inherited
  
• Field Name: RELINING_MATERIAL
  Inherited
  
• Field Name: WATER_PIPE_PROTECTION
  Inherited
  
Templates:

Name: POTABLE
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• CLASS: WATER_SRV_CONNECTN
• OBJECT_TYPE: WACN
• GIS_EQUIPMENT_CATEGORY: W
• WATER_CATEGORY: POTABLE

---

ID: RECYCLED A+
Name: RECYCLED A+; RECYCLED B; RECYCLED C
Domains:

• Field Name: ASSET_LEVEL_ACCURACY
  Inherited
  
• Field Name: ASSET_POSITIONAL_ACCURACY
  Inherited
  
• Field Name: GIS_ACQUISITION_METHOD
  Inherited
  
• Field Name: GIS_ASSET_FUNDING_BASIS
  Inherited
  
• Field Name: GIS_CUSTODIAN
  Inherited
  
• Field Name: GIS_OWNER
  Inherited
  
• Field Name: WATER_SRV_CONNECTN_MATERIAL
  Inherited
  
• Field Name: WATER_SRV_CONNECTN_CLASS
  Inherited
  
• Field Name: DATA_SOURCE
  Inherited
  
• Field Name: CONDUIT
  Inherited
  
• Field Name: WATER_SRV_CONNECTN_USE
  Inherited
  
• Field Name: WATER_CATEGORY
  Inherited
  
• Field Name: WATER_PIPE_LINING
  Inherited
  
• Field Name: RELINING_MATERIAL
  Inherited
  
• Field Name: WATER_PIPE_PROTECTION
  Inherited
  
Templates:

Name: RECYCLED A+
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• CLASS: WATER_SRV_CONNECTN
• OBJECT_TYPE: WACN
• GIS_EQUIPMENT_CATEGORY: W
• WATER_CATEGORY: RECYCLED A+

---

ID: RECYCLED B
Name: RECYCLED A+; RECYCLED B; RECYCLED C
Domains:

• Field Name: ASSET_LEVEL_ACCURACY
  Inherited
  
• Field Name: ASSET_POSITIONAL_ACCURACY
  Inherited
  
• Field Name: GIS_ACQUISITION_METHOD
  Inherited
  
• Field Name: GIS_ASSET_FUNDING_BASIS
  Inherited
  
• Field Name: GIS_CUSTODIAN
  Inherited
  
• Field Name: GIS_OWNER
  Inherited
  
• Field Name: WATER_SRV_CONNECTN_MATERIAL
  Inherited
  
• Field Name: WATER_SRV_CONNECTN_CLASS
  Inherited
  
• Field Name: DATA_SOURCE
  Inherited
  
• Field Name: CONDUIT
  Inherited
  
• Field Name: WATER_SRV_CONNECTN_USE
  Inherited
  
• Field Name: WATER_CATEGORY
  Inherited
  
• Field Name: WATER_PIPE_LINING
  Inherited
  
• Field Name: RELINING_MATERIAL
  Inherited
  
• Field Name: WATER_PIPE_PROTECTION
  Inherited
  
Templates:

Name: RECYCLED B
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• CLASS: WATER_SRV_CONNECTN
• OBJECT_TYPE: WACN
• GIS_EQUIPMENT_CATEGORY: W
• WATER_CATEGORY: RECYCLED B

---

ID: RECYCLED C
Name: RECYCLED A+; RECYCLED B; RECYCLED C
Domains:

• Field Name: ASSET_LEVEL_ACCURACY
  Inherited
  
• Field Name: ASSET_POSITIONAL_ACCURACY
  Inherited
  
• Field Name: GIS_ACQUISITION_METHOD
  Inherited
  
• Field Name: GIS_ASSET_FUNDING_BASIS
  Inherited
  
• Field Name: GIS_CUSTODIAN
  Inherited
  
• Field Name: GIS_OWNER
  Inherited
  
• Field Name: WATER_SRV_CONNECTN_MATERIAL
  Inherited
  
• Field Name: WATER_SRV_CONNECTN_CLASS
  Inherited
  
• Field Name: DATA_SOURCE
  Inherited
  
• Field Name: CONDUIT
  Inherited
  
• Field Name: WATER_SRV_CONNECTN_USE
  Inherited
  
• Field Name: WATER_CATEGORY
  Inherited
  
• Field Name: WATER_PIPE_LINING
  Inherited
  
• Field Name: RELINING_MATERIAL
  Inherited
  
• Field Name: WATER_PIPE_PROTECTION
  Inherited
  
Templates:

Name: RECYCLED C
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• CLASS: WATER_SRV_CONNECTN
• OBJECT_TYPE: WACN
• GIS_EQUIPMENT_CATEGORY: W
• WATER_CATEGORY: RECYCLED C

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/20/2023 3:21:19 AM

Schema Last Edit Date: 7/20/2023 3:21:19 AM

Data Last Edit Date: 7/20/2023 3:21:19 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat