Name: Recycled Vertical Pressure Main

Display Field: ASSETID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 5000

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -5120763.26772284
YMin: 2036.05706365815
XMax: 6120763.26772284
YMax: 19997963.9429363
Spatial Reference: 28356 (28356)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"SUBTYPECD","field2":null,"field3":null,"defaultSymbol":null,"defaultLabel":null,"uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"b380438ce505f9796b7cc98181e43c63","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA8AAAAPCAYAAAA71pVKAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAeBJREFUKJF9k01oE0EUx38xs27STdtkBcMWtFRdU2opUVHx0IJoCH4gvUSsRezZ5tKDF9GbNw8iWBTRk3hxD6LiQVHxVA148KMFA9VCIcYgHaU1mw6proeCbjap7zbz/r//mzfzRtA6QpZl9UkpLcMwFqWUH4BaUCQCaz1N5mwf6UyX7O6JKiNRV+rnN0rzc/rHNy+UcxUotYLNo4zd2MvBYwItilrdjBBNthPfukXtOLAZe+cr8+WFopwq+OHQYc5c3082FyK0RidgM3AIuW59kalTQEkApMmO7mboyP/Afwb9Q1lOn3/CnXEBsJ3UcBQj5hd5eCzygzZiaGgNBpuwB4GoADCIbwtWKPCMR9wmxT5GyDcYbKSr1zTNAQGgEW4Pwu95DUCRAi5jdJL4mwsjNFvusQRAnV9uEM6Q4zGKXQzSQbwhp1j+PW9VPgmAKkufgX6/oIde8lxqujCABb7MlstvpwWApy9NLqhKdgNJvaXaFyvUkXx9DngCwFG3nuYYf2DQeSJCZE3Qw6PIu5n73JwA34Q5TJ7Mkde7sY8nSDY9eA2XWaZnvlPNwur8+cfTc7g2PGqdy1XKpYk2YqkwWoeHV6vhzrl69eE9deWi3zD4MbhbvuwATtOZVXMbfwBpcY66XyowiAAAAABJRU5ErkJggg==","contentType":"image/png","width":11,"height":11,"angle":0,"xoffset":0,"yoffset":0},"value":"31151","label":"VERTICAL PIPE","description":""}],"fieldDelimiter":","},"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field: SUBTYPECD

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ENABLED (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• ANCILLARYROLE (type: esriFieldTypeSmallInteger, alias: Ancillary Role, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASSETID (type: esriFieldTypeString, alias: Asset ID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• STATUS (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [ASDES: AS DESIGNED], [ASCON: AS CONSTRUCTED], [DEC: DE-COMMISSIONED], ... 6 more ...)
• SUBTYPECD (type: esriFieldTypeInteger, alias: SubtypeCD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WATERTYPE (type: esriFieldTypeString, alias: Water Type, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true, Coded Values: [POT: POTABLE], [NOP: NON-POTABLE], [REC: RECYCLED])
• OPERATIONALID (type: esriFieldTypeString, alias: Operational ID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• MATERIAL (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [AC: ASBESTOS CEMENT], [CI: CAST IRON], [CU: COPPER], ... 17 more ...)
• DIAMETER (type: esriFieldTypeInteger, alias: Diameter (mm), SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: UNKNOWN], [10: 10 MM], [12: 12 MM], ... 61 more ...)
• MEASUREDLENGTH (type: esriFieldTypeDouble, alias: Measured Length (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• LENGTHSOURCE (type: esriFieldTypeString, alias: Length Source, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [FM: FIELD MEASUREMENT], [MS: MAPPING SYSTEM], [UNK: UNKNOWN], ... 1 more ...)
• PLANNO (type: esriFieldTypeString, alias: Plan No, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• AMENDEDPLANNO (type: esriFieldTypeString, alias: Ammended Plan Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FOLIONO (type: esriFieldTypeString, alias: Folio Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ASCONDATE (type: esriFieldTypeDate, alias: Ascon Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• OWNER (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [QUU: QUEENSLAND URBAN UTILITIES], [DEV: DEVELOPER], [PRIV: PRIVATE], ... 10 more ...)
• OWNERDETAILS (type: esriFieldTypeString, alias: Owner Details, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• FUNDINGSOURCE (type: esriFieldTypeString, alias: Funding Source, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [QUU: QUEENSLAND URBAN UTILITIES], [DEV: DEVELOPER], [GOV: GOVERNMENT], ... 2 more ...)
• PROJECTNO (type: esriFieldTypeString, alias: Project Number, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• LOCALGOVAREA (type: esriFieldTypeString, alias: Local Government Area, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [BCC: BRISBANE CITY COUNCIL], [ICC: IPSWICH CITY COUNCIL], [LVRC: LOCKYER VALLEY REGIONAL COUNCIL], ... 12 more ...)
• COMMENTS (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 186, nullable: true, editable: true)
• TRUNKMAINNAME (type: esriFieldTypeString, alias: Set Number, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [TB0_NA: UNKNOWN], [TB0006: S6-RAFTING GROUND TO TARRAGINDI], [TB0007: S7-HOLTS HILL TO MT VICTORIA], ... 321 more ...)
• LINING (type: esriFieldTypeString, alias: Lining, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [C: CEMENT], [PE: POLYETHYLENE], [NON: NONE], ... 2 more ...)
• OPERATIONALROUGHNESSMM (type: esriFieldTypeDouble, alias: Operational Rougness (mm), SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOTALFITTINGK (type: esriFieldTypeDouble, alias: Total Fitting (k), SQL Type: sqlTypeOther, nullable: true, editable: true)
• PROTECTION (type: esriFieldTypeString, alias: Protection, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [CEUNT: CONCRETE ENCASED (U/TREATED)], [DTW: DENSO TAPED WRAPPED], [DW: DOUBLE WRAPPED], ... 26 more ...)
• USASSETID (type: esriFieldTypeString, alias: US Asset ID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• DSASSETID (type: esriFieldTypeString, alias: DS Asset ID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• FUNCTIONALDIAMETER (type: esriFieldTypeInteger, alias: Functional Diameter (mm), SQL Type: sqlTypeOther, nullable: true, editable: true)
• PIPECLASS (type: esriFieldTypeString, alias: Pipe Class, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [6: 6], [9: 9], [12: 12], ... 16 more ...)
• RETIRED (type: esriFieldTypeString, alias: Retired, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [N: NO], [Y: YES], [U: UNKNOWN], ... 1 more ...)
• RETIREDDATE (type: esriFieldTypeDate, alias: Retired Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• EQUIPMENTNO (type: esriFieldTypeString, alias: Equipment No, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• SUBNET (type: esriFieldTypeString, alias: Subnetwork, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [TRUNK: OPERATIONAL TRUNK], [RETIC: OPERATIONAL RETICULATION])
• ABOVEGROUND (type: esriFieldTypeString, alias: Partially/All Above Ground, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [N: NO], [Y: YES], [U: UNKNOWN], ... 1 more ...)
• ALIGNMENT (type: esriFieldTypeString, alias: Alignment, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• COATING (type: esriFieldTypeString, alias: Coating, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• CREATEDATE (type: esriFieldTypeDate, alias: Create Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CREATEUSER (type: esriFieldTypeString, alias: Create User, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• GPSCOORDX (type: esriFieldTypeDouble, alias: GPS Coordinate X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GPSCOORDY (type: esriFieldTypeDouble, alias: GPS Coordinate Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GPSDRMS (type: esriFieldTypeDouble, alias: GPS DMRS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• JOINTTYPE (type: esriFieldTypeString, alias: Joint Type, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [RRJ: RUBBER RING JOINT], [FLG: FLANGE], [WJ: WELDED JOINT], ... 5 more ...)
• LEGACYASSETID (type: esriFieldTypeString, alias: Legacy Asset ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• OPERATINGPRESSURE (type: esriFieldTypeDouble, alias: Operating Pressure (kPa), SQL Type: sqlTypeOther, nullable: true, editable: true)
• PIPEUNITLENGTH (type: esriFieldTypeDouble, alias: Pipe Unit Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RELINED (type: esriFieldTypeString, alias: Relined, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [N: NO], [Y: YES], [U: UNKNOWN], ... 1 more ...)
• ROCKEXCAVATION (type: esriFieldTypeString, alias: Rock Excavation, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [N: NO], [Y: YES], [U: UNKNOWN], ... 1 more ...)
• STREET (type: esriFieldTypeString, alias: Street, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SUBURB (type: esriFieldTypeString, alias: Suburb, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• SUI_FEATURECODE (type: esriFieldTypeString, alias: Subsurface Feature Code, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• SUI_QUALITYRATING (type: esriFieldTypeString, alias: Subsurface Quality Rating, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [QLA: QL-A], [QLB: QL-B], [QLC: QL-C], ... 2 more ...)
• SUI_QUALITYRATINGDATE (type: esriFieldTypeDate, alias: Subsurface Quality Rating Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SUI_QUALITYRATINGSOURCE (type: esriFieldTypeString, alias: Subsurface Quality Source, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [QLD1: QL-D - Utility Owner Records], [QLD2: QL-D - DBYD Inquiry], [QLD3: QL-D - Design Plan], ... 12 more ...)
• UPDATEDATE (type: esriFieldTypeDate, alias: Update 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)
• INTERNALDIAMETER (type: esriFieldTypeDouble, alias: Internal Diameter (mm), SQL Type: sqlTypeOther, nullable: true, editable: true)
• INTERNALDIAMETER_LU_KEYCODE (type: esriFieldTypeString, alias: Diameter Material Lining PipeClass Keycode, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• FUNCTIONALDIAMETER_LU_KEYCODE (type: esriFieldTypeString, alias: Diameter Material Keycode, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• WATERTRACEWEIGHT (type: esriFieldTypeInteger, alias: Water Trace Weight, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OPERATIONALROUGHNESSC (type: esriFieldTypeDouble, alias: Operational Roughess C, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Types:

ID: 31151
Name: VERTICAL PIPE
Domains:

• Field Name: ENABLED
  Inherited
  
• Field Name: STATUS
  Inherited
  
• Field Name: WATERTYPE
  Inherited
  
• Field Name: MATERIAL
  Inherited
  
• Field Name: DIAMETER
  Inherited
  
• Field Name: LENGTHSOURCE
  Inherited
  
• Field Name: OWNER
  Inherited
  
• Field Name: FUNDINGSOURCE
  Inherited
  
• Field Name: LOCALGOVAREA
  Inherited
  
• Field Name: TRUNKMAINNAME
  Inherited
  
• Field Name: LINING
  Inherited
  
• Field Name: PROTECTION
  Inherited
  
• Field Name: PIPECLASS
  Inherited
  
• Field Name: RETIRED
  Inherited
  
• Field Name: SUBNET
  Inherited
  
• Field Name: ABOVEGROUND
  Inherited
  
• Field Name: JOINTTYPE
  Inherited
  
• Field Name: RELINED
  Inherited
  
• Field Name: ROCKEXCAVATION
  Inherited
  
• Field Name: SUI_QUALITYRATING
  Inherited
  
• Field Name: SUI_QUALITYRATINGSOURCE
  Inherited
  
Templates:

Name: VERTICAL PIPE
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• ENABLED: 1
• STATUS: ASCON
• SUBTYPECD: 31151
• WATERTYPE: REC
• MATERIAL: UPVC
• DIAMETER: 100
• OWNER: QUU
• LOCALGOVAREA: BCC
• RETIRED: N
• OPERATINGPRESSURE: 35
• RELINED: N
• SUI_QUALITYRATING: QLD
• SUI_QUALITYRATINGSOURCE: QLD4

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/27/2025 12:31:40 AM

Schema Last Edit Date: 8/5/2022 3:23:02 AM

Data Last Edit Date: 8/5/2022 3:23:02 AM

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