Name: Water Vertical Pressure Main

Display Field: TRUNKMAINNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 428207.867235841
YMin: 6880062.04809877
XMax: 513113.816262277
YMax: 7020363.919907
Spatial Reference: 28356 (28356)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"SUBTYPECD","field2":null,"field3":null,"defaultSymbol":null,"defaultLabel":null,"uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"b4ae81e718d40bf51981fed24e1209f9","imageData":"iVBORw0KGgoAAAANSUhEUgAAABYAAAAWCAYAAADEtGw7AAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAmBJREFUOI21lD1v01AUhh/XaWOFCKmu+2GrZWBBQgKpcjvAwowUIXWt93RkZEJqfwFzM+OuHTLxH7hKJSRUMcBQuFar4Eo0oCbUNcONb+zE/QCJs8S59/jxe99zzq3wn6Jyq6zNIw/DbADYGCIOXfHPYDuI/Jh0G/ABN1uPSSGQAMLG2LrqI+XgQDZj0t0bRPkx6XsC2SL0tm4GB7INNAprg1MY9KAyA1UHDDO/2ySQPqG3djU4kE0NTRM4PYTLBOqLUJ2DpA+nn+DiHGYfwHRNqyeQu3nlGpzzVAFOOrDggzk9+vB0DaxZ9Rx/hNo8WPNauR1ErcxzDY5JR0U6EeA+AYwJp3TYDxXcvKOVD+uyNm5FE4Afn2Hu0fXQPPykAwurI0vGrdCLgx7cvT9GSOHXMVRtMGeKWxVL1WNYUDuI/Dh0hQJvHnk6ccpkIg7fgngF7gY8e1OE15ag3wVrEdCWittN3pd36jfah/5rBcvCrEK/l8+OILNib0USyAhwuUwnwf5LED/h3gbUFot7yRnM1PVfG0PGFD0WQAMuJsEL6/B8v/w0vWNwHmu1E+1WBdGHBvVl6H2F+nI5qKD293hN2tmDBvdDb5tANrAcn25HdcBoskoiVf2+tK7V2hiteByscpMXGOY3nFXodtRUlSkfnMH3D2oyR/fGdv6mK4JVEbeAXZxVOO9C90ClTQ0H5jJRxXKf5t9sEXqt/MJku4Veyw4iEZO2sRwXy7nGDgSwQ+i1xzdK+3h4JG942zXJjSqqTwUgSZMd9lZkGeP6AVHHU0fMpvMK0N+B83FLYBZ/AGIYyxk/1fYJAAAAAElFTkSuQmCC","contentType":"image/png","width":16,"height":16,"angle":0,"xoffset":0,"yoffset":0},"value":"11151","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:

Type ID Field: SUBTYPECD

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• 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: Plan Diameter, 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, 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 Number, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• AMENDEDPLANNO (type: esriFieldTypeString, alias: Amended 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: As Constructed 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: 5, nullable: true, editable: true, Coded Values: [TB0_NA: UNKNOWN], [TB0006: S6-RAFTING GROUND TO TARRAGINDI], [TB0007: S7-HOLTS HILL TO MT VICTORIA], ... 321 more ...)
• DMANAME (type: esriFieldTypeSmallInteger, alias: DMA Name, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [130: Acacia Ridge - P], [123: Algester - P], [86: ALLSPICE ST BOOSTER - WB114], ... 280 more ...)
• PMANAME (type: esriFieldTypeInteger, alias: Pressure Monitoring Area, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [130: Acacia Ridge - P], [123: Algester - P], [86: ALLSPICE ST BOOSTER - WB114], ... 249 more ...)
• PZONENAME (type: esriFieldTypeInteger, alias: Pressure Zone, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: ACACIA RIDGE P.R.V.], [2: ALGESTER P.R.V.], [3: ALLSPICE ST BOOSTER - WB114], ... 291 more ...)
• RESZONENAME (type: esriFieldTypeInteger, alias: Reservoir Zone, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [409: Aratula Evelyn St R140], [1: Aspley Reservoir], [716: Augustine Hts Keidges Rd R78], ... 90 more ...)
• WZONENAME (type: esriFieldTypeSmallInteger, alias: Water Supply Zone, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Acacia Ridge], [2: Aspley], [3: Bartleys Hill], ... 19 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: 12, nullable: true, editable: true)
• DSASSETID (type: esriFieldTypeString, alias: DS Asset ID, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• FUNCTIONALDIAMETER (type: esriFieldTypeInteger, alias: Functional Diameter, 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 Number, 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)
• ENABLED (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• ANCILLARYROLE (type: esriFieldTypeSmallInteger, alias: AncillaryRole, SQL Type: sqlTypeOther, 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, 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, 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: WATERTRACEWEIGHT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OPERATIONALROUGHNESSC (type: esriFieldTypeDouble, alias: Operational Roughess C , SQL Type: sqlTypeOther, nullable: true, editable: true)

Types:

ID: 11151
Name: VERTICAL PIPE
Domains:

• 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: DMANAME
  Inherited
  
• Field Name: PMANAME
  Inherited
  
• Field Name: PZONENAME
  Inherited
  
• Field Name: RESZONENAME
  Inherited
  
• Field Name: WZONENAME
  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: ENABLED
  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:

• STATUS: ASCON
• SUBTYPECD: 11151
• MATERIAL: UPVC
• WATERTYPE: POT
• DIAMETER: 100
• OWNER: QUU
• LOCALGOVAREA: BCC
• RETIRED: N
• ENABLED: 1
• 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:36 AM

Schema Last Edit Date: 9/14/2023 2:38:54 AM

Data Last Edit Date: 9/14/2023 2:38:54 AM

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