Name: Recycled Water Abandoned Pipe

Display Field: SubtypeCD

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Min. Scale: 50000

Max. Scale: 0

Default Visibility: true

Max Record Count: 4000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 17028258.8465676
YMin: -3156632.27851154
XMax: 17041511.4865213
YMax: -3069400.71699198
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[178,178,178,255],"width":4},"label":"","description":""},"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: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• CreateUser (type: esriFieldTypeString, alias: Create User, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• CreateDate (type: esriFieldTypeDate, alias: Create Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• UpdateUser (type: esriFieldTypeString, alias: Update User, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• UpdateDate (type: esriFieldTypeDate, alias: Update Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SubtypeCD (type: esriFieldTypeInteger, alias: Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [31101: Raw Water Main], [31102: Trunk Main], [31103: Reticulation Main], ... 42 more ...)
• Material (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true, Coded Values: [CI: Iron, Cast], [COPPER: Copper], [DI: Iron, Ductile], ... 14 more ...)
• NominalDiameter (type: esriFieldTypeInteger, alias: Nominal Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• MXASSETNUM (type: esriFieldTypeString, alias: Asset Id, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• MXSITEID (type: esriFieldTypeString, alias: Maximo Site Id, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DrawingNo (type: esriFieldTypeString, alias: Drawing Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• InstallDate (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• AbandonedDate (type: esriFieldTypeDate, alias: Abandoned Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DataSource (type: esriFieldTypeString, alias: Data Source, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [AC-E: AsCon - Electronic], [AC-HC: AsCon - Hard Copy], [FSur: Field Survey], ... 6 more ...)
• LegacyGlobalID (type: esriFieldTypeGUID, alias: Legacy Global Id, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• AbandonedStatus (type: esriFieldTypeString, alias: Abandoned Status, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [CRS: Could Be Returned To Service], [CNRS: Could Never Be Returned To Service])
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• DecommissionDate (type: esriFieldTypeDate, alias: DecommissionDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DecommissioningProjectNo (type: esriFieldTypeString, alias: DecommissioningProjectNo, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• SplitAssetParent (type: esriFieldTypeString, alias: SplitAssetParent, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• ADDRESS_SUBURB (type: esriFieldTypeString, alias: Address Suburb, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• ADDRESS_STREET (type: esriFieldTypeString, alias: Address Street, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• ADDRESS_NUMBER (type: esriFieldTypeString, alias: Address Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: Recycled Water Abandoned Pipe
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• CreateUser: NotCreated
• UpdateUser: NotUpdated
• DataSource: UNK
• AbandonedStatus: CRS

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/15/2025 5:48:32 AM

Schema Last Edit Date: 8/15/2025 5:48:32 AM

Data Last Edit Date: 8/15/2025 5:48:32 AM

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