Name: Sewer Vertical Gravity 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: 506160.382576792
YMin: 6964888.04260198
XMax: 506161.479823232
YMax: 6964888.3952975
Spatial Reference: 28356 (28356)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"SUBTYPECD","field2":null,"field3":null,"defaultSymbol":null,"defaultLabel":null,"uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"184bf8493add8905661201aff658354c","imageData":"iVBORw0KGgoAAAANSUhEUgAAABYAAAAWCAYAAADEtGw7AAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAn5JREFUOI21lF9r01AYxn9NsrTsD86022zYQLwRBMURdzE/gFBsLfsS3aWXXgndJ/C6vfZ+lF6UfQfDBoLoLkRQTxhsx7FusGZN4kWaJlnTOQWfm+QczvnleZ9z3mj8J2m3WfS9gqnqVAFyrmGXe9L+Z7BTMaxAkU0ULKCMH84HmkTUAAU75xrb0z6SCRZ1GoEvWzda8rECTX4QNdpml+0/gsVLuvhh2ZF+uXB+BboKJR1UJbWlIepYZodnU8GiTiOCej58PgPPg5U5KOZhMITDM7j04OEdmI12+1iiRivpfAx2KoYV+LIJIWBfglWCmYS7WQ3uFsL3T6ewNAtLeuzcqRjtKPMxONClhU8ZwJawuQy56zkl9GgxhM8psfNAly0II0lG0QD42ofHizdDk/D9E1gvxpFMRBFNnrvwYCENCICjSzB00NMHR0ENzyM6UKdiWOWetDUIGyBaqKqTzt4fwpsvsGXAu800/F4Bjl1YGWUf6NIC7Ft13t638Lkr4a0bwiLlNTgfpJY7MIpirYcQNRygHGSAXz+FiwPYuh87i9QfwvxMPM65hgCZythGoTr0JsEby7D7Iruaowt4UhwPnYnrhpK3YVBdXYAfF7A6lw1K6sqfOJNu9DIGm91BU9SplnSs/T4Y+URnZSgA7GPYKMVuc0OjDTINBvBcXqkaP9eL4f1cKmQ777vw8RQsI/HfUGgm/3Qp8FoPIeps49NaL4bX6OAENDVuGM+DeR2eL6e+1TY7tJMTE8WaHdpOxbADTXZLOuVS8fqKhBRsYMfsxNlOBQOMSjJFnQbQSLYq4IxukPBcdtZ6iCzGjQ0yKq8NcXdOA/0VOKnbAiP9BqmH3TUxQ+GzAAAAAElFTkSuQmCC","contentType":"image/png","width":16,"height":16,"angle":0,"xoffset":0,"yoffset":0},"value":"21251","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: [MS1001: MS1001 - AUCHENFLOWER BR SEWER], [MS1002: MS1002 - SOUTH BRISBANE SUB MAIN AND SYPHON], [MS1003: MS1003 - SOUTH BRISBANE SUB MAIN BR L NO 1], ... 408 more ...)
• PUMPSTATIONCATCHMENT (type: esriFieldTypeString, alias: Pump Station Catchment, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true, Coded Values: [Berrinba: Berrinba], [Gatton: Gatton], [Plainland: Plainland], ... 338 more ...)
• TREATMENTCATCHMENT (type: esriFieldTypeString, alias: Treatment Plant Catchment, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• 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: 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: [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)
• WATERWAYCATCHMENT (type: esriFieldTypeString, alias: Waterway Catchment, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• INTERNALDIAMETER (type: esriFieldTypeDouble, alias: Internal Diameter (mm), SQL Type: sqlTypeOther, nullable: true, editable: true)
• ROUGHNESSFORMULA (type: esriFieldTypeString, alias: Roughness Formula, 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])

Types:

ID: 21251
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: PUMPSTATIONCATCHMENT
  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: 21251
• 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: 10/13/2022 6:00:41 AM

Data Last Edit Date: 10/13/2022 6:00:41 AM

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