Name: Sewer Vertical Pressure Main

Display Field: SEWERLINENAME

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: 491830.519563389
YMin: 6906267.43867441
XMax: 516891.46763783
YMax: 6967201.96104378
Spatial Reference: 28356 (28356)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"SUBTYPECD","field2":null,"field3":null,"defaultSymbol":null,"defaultLabel":null,"uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"d49a8d32f84e3bc2aaed40ee5341b093","imageData":"iVBORw0KGgoAAAANSUhEUgAAABYAAAAWCAYAAADEtGw7AAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAhZJREFUOI21lLtuE0EUhj9n10qIg0ADAtni0vAASJuWJ8DiISjs2pKX2rQxIrX3NdwinoCV6GgoYaNEcETBbXHsoZgZe3bsdSwkTrOe4znf/ue2Mf/J4l0uvYCOhi7ApVL5qUj+z+CBUkkkMgKSBbSdPxJhCDQgv1SqX/eSjeAUelpksk2RhiQSeTeE7BX0rwQPYerSdvYTKO3lQyCqhvRSSMZwXAtOoeegC+Dc+o+Aa8Ac+ALMgNvAgad+CBNf+RI8UCrRpqbMgALoAM0go5Z9ntt71z3lA6UyV/MlOBZJtG1SAdwH9qi3uxbe9JTHpi/HYSl6AF+BO1dAffgn4J49a0iWQgmcJXArACyAH1ZZWJompvauoQOlklORPAazAAv7R2ODsvfAW+AR8DSAH2GmxtU6FkmAfKfN+2CfH4HfATgC/njnOZyBLcUJFEPjaLPBngBvgMespsLZDNj3zlqpApFK83KgqzeAHwDPa7L5XlVztjZujf39XJdl9wbwDbhZAwrVBjZ1P5bgcVmOUui2ICkwE3CwHri0Bat5d2rnSmWIVMEADXim4XPHBh3WKP8FXGA2c28VO/K/dBXwCRQp9DVMOpjZLaiOoMY062H1XdkYMt+xNm5jyAZK5ZHItAXtcAqCDPM5vHzt1bYWDGBT6qRmzXv+qmLGMgeKhoEWmxhbF8Sml4HZTjDl2hazE9i3XYHO/gJjoapsJ4gQYQAAAABJRU5ErkJggg==","contentType":"image/png","width":16,"height":16,"angle":0,"xoffset":0,"yoffset":0},"value":"21151","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)
• 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: [ABS: ACRYLONITRILE BUTADIENE STYRENE], [AC: ASBESTOS CEMENT], [BC: BOX CULVERT], ... 24 more ...)
• DIAMETER (type: esriFieldTypeInteger, alias: Diameter (mm), SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [40: 40 MM], [50: 50 MM], [60: 60 MM], ... 87 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)
• 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)
• SEWERLINENO (type: esriFieldTypeString, alias: Sewer Line No, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• SEWERLINENAME (type: esriFieldTypeString, alias: Sewer Line Name, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [RM001: RM001 - WATSON RD PS RISING MAIN], [RM002: RM002 - BEATTY RD PS RISING MAIN], [RM005: RM005 - BARRAMUL ST (PASHEN ST) PS RISING MAIN], ... 464 more ...)
• LINING (type: esriFieldTypeString, alias: Lining, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [C: CEMENT], [PE: POLYETHELYNE], [P: PLASTIC], ... 7 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)
• 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 (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: [4: 4], [5: 5], [6: 6], ... 37 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 ...)
• 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], ... 14 more ...)
• LEGACYASSETID (type: esriFieldTypeString, alias: Legacy Asset ID, SQL Type: sqlTypeOther, length: 20, 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 ...)
• SCHEMEBOUNDARY (type: esriFieldTypeString, alias: Scheme Boundary, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [1: Luggage Point], [2: Oxley Creek], [2F: Fairfield], ... 25 more ...)
• SOILTYPE (type: esriFieldTypeString, alias: Soil Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [UNK: UNKNOWN], [ASH: ASH], [CLAY: CLAY], ... 11 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)
• OPERATIONALROUGHNESSC (type: esriFieldTypeDouble, alias: Operational Roughess C, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FUNCTIONALDIAMETER_LU_KEYCODE (type: esriFieldTypeString, alias: Diameter Material Keycode, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• INTERNALDIAMETER_LU_KEYCODE (type: esriFieldTypeString, alias: Diameter Material Lining PipeClass Keycode, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• ENABLED (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• ROUGHNESSFORMULA (type: esriFieldTypeString, alias: Roughness Formula, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)

Types:

ID: 21151
Name: VERTICAL PIPE
Domains:

• Field Name: STATUS
  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: SEWERLINENAME
  Inherited
  
• Field Name: LINING
  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: SCHEMEBOUNDARY
  Inherited
  
• Field Name: SOILTYPE
  Inherited
  
• Field Name: SUI_QUALITYRATING
  Inherited
  
• Field Name: SUI_QUALITYRATINGSOURCE
  Inherited
  
• Field Name: ENABLED
  Inherited
  
Templates:

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

Attributes:

• STATUS: ASCON
• SUBTYPECD: 21151
• MATERIAL: PE
• DIAMETER: 150
• MEASUREDLENGTH: 0
• LENGTHSOURCE: FM
• OWNER: QUU
• LOCALGOVAREA: BCC
• LINING: N
• PIPECLASS: SN8
• JOINTTYPE: RRJ
• RELINED: N
• ROCKEXCAVATION: N
• SUI_QUALITYRATING: QLD
• SUI_QUALITYRATINGSOURCE: QLD4

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/25/2023 12:57:55 PM

Schema Last Edit Date: 1/31/2023 12:19:37 AM

Data Last Edit Date: 1/31/2023 12:19:37 AM

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