Name: Sewer Treatment Plant

Display Field: NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 600000

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:

{"symbolLayerDrawing":{"type":"CIMSymbolLayerDrawing","symbolLayers":[{"type":"CIMSymbolLayerIdentifier","symbolReferenceName":"Symbol_387","symbolLayerName":"Level_0"}],"useSymbolLayerDrawing":true},"renderer":{"type":"uniqueValue","field1":"SUBTYPECD","field2":null,"field3":null,"defaultSymbol":null,"defaultLabel":null,"uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"223f33422efa43ad0ace2a795d220e50","imageData":"iVBORw0KGgoAAAANSUhEUgAAABwAAAATCAYAAACDW21BAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAdJJREFUSIm9lU1LG1EUhp9MbiaJU3Q0JtY0IQsjRQQXDV10EcFFFUuDq/6CQvo7XLnsPn+gIG5ctC7cddFFURDpStRN27H4EZqEYGySiYs7QzudzCTVoQcGzjnz8j537hw4gv8c4s/ibHWi0BPNEuZNIRB3BSPUmahM71T3XUAJq+5ZwsCiJ6plY4036W0qDmBPNEt23jWDgSkKhGRahr+AKDcvsUDZ98EAd4swrwMmabsn/MSpkbvDNg779z2BiRgkVThrwfc6JOKQ0eBb06mbjEKtDW0gHoaHMdmPe/h6AgGufsFHA15k4OAnjEdBKHDRguMaPJuS/2jzBF7NwFFdPospb09foAlcd2BEQNEy0VWIhKHRhaxmfU1E5qkovDu9BzCpwtMUvP0Cy49gIdFfV2vC53M4vIKljJ/jACDIKZvTYesUxmKQ09waTYVZHZ5Myiu/M/CoAe2uhCZi8ir7mkRgXB109CGAMxrsXcKHr5DXIW1N4JiAx6O/dc8HXONQwAtr/HOjkLN6P1pOjV0/iLjfXf8rcOWT3zmHi9d5P6DJPlAAMEpu4b1CejuB3Q7rYUE5YJRNqbiA2R0MIGSsUcYkmH0IeO5DO+y9FVxUHdUtsal0TTpcTEcAAAAASUVORK5CYII=","contentType":"image/png","width":21,"height":14,"angle":0,"xoffset":0,"yoffset":0},"value":"22803","label":"TREATMENT PLANT","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)
• NAME (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• DIAMETER (type: esriFieldTypeInteger, alias: Diameter (mm), SQL Type: sqlTypeOther, nullable: true, editable: true)
• SL (type: esriFieldTypeDouble, alias: Surface Level (mAHD), SQL Type: sqlTypeOther, nullable: true, editable: true)
• SLSOURCE (type: esriFieldTypeString, alias: Surface Level Source, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [DRAW: DRAWING], [GPS: GPS], [DEM: DEM])
• IL (type: esriFieldTypeDouble, alias: Invert Level (mAHD), SQL Type: sqlTypeOther, nullable: true, editable: true)
• DEPTH (type: esriFieldTypeDouble, alias: Depth (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• 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)
• OFFLINEENDDATE (type: esriFieldTypeDate, alias: Offline End Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• OFFLINESTARTDATE (type: esriFieldTypeDate, alias: Offline Start 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)
• SEWERLINENAME (type: esriFieldTypeString, alias: Sewer Line Name, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• LOCATIONDESCRIPTION (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeOther, length: 240, nullable: true, editable: true)
• LOCATIONCLASSIFICATION (type: esriFieldTypeString, alias: Location Classification, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [PAR: IN PARCEL], [UNK: UNKNOWN], [OTH: OTHER], ... 1 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])
• ANCILLARYROLE (type: esriFieldTypeSmallInteger, alias: Ancillary Role, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: None], [1: Source], [2: Sink])
• CAPACITY (type: esriFieldTypeDouble, alias: Capacity (L), SQL Type: sqlTypeOther, 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])
• 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)
• LEGACYASSETID (type: esriFieldTypeString, alias: Legacy Asset ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• OPERATIONALDATE (type: esriFieldTypeDate, alias: Operational Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SCADAENABLED (type: esriFieldTypeString, alias: SCADA Enabled, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [N: NO], [Y: YES], [U: UNKNOWN], ... 1 more ...)
• SCADANUMBER (type: esriFieldTypeString, alias: Scada Number, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• SEWERTRACEWEIGHT (type: esriFieldTypeInteger, alias: Sewer Trace Weight, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STREET (type: esriFieldTypeString, alias: Street, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• STREETNUMBER (type: esriFieldTypeString, alias: Street Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• SUBURB (type: esriFieldTypeString, alias: Suburb, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• SYMBOLROTATION (type: esriFieldTypeDouble, alias: Symbol Rotation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• 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)
• 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 ...)
• INFOLINK (type: esriFieldTypeString, alias: Infolink, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)

Types:

ID: 22803
Name: TREATMENT PLANT
Domains:

• Field Name: STATUS
  Inherited
  
• Field Name: SLSOURCE
  Inherited
  
• Field Name: OWNER
  Inherited
  
• Field Name: FUNDINGSOURCE
  Inherited
  
• Field Name: LOCALGOVAREA
  Inherited
  
• Field Name: LOCATIONCLASSIFICATION
  Inherited
  
• Field Name: RETIRED
  Inherited
  
• Field Name: SUBNET
  Inherited
  
• Field Name: ANCILLARYROLE
  Inherited
  
• Field Name: ENABLED
  Inherited
  
• Field Name: SCADAENABLED
  Inherited
  
• Field Name: SUI_QUALITYRATING
  Inherited
  
• Field Name: SUI_QUALITYRATINGSOURCE
  Inherited
  
Templates:

Name: TREATMENT PLANT
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• SUI_QUALITYRATINGSOURCE: QLD4
• STATUS: ASCON
• SUBTYPECD: 22803
• OWNER: QUU
• LOCALGOVAREA: BCC
• RETIRED: N
• ANCILLARYROLE: 0
• ENABLED: 1
• SYMBOLROTATION: 0
• SUI_QUALITYRATING: QLD

---

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: 4/25/2023 12:57:29 PM

Data Last Edit Date: 4/25/2023 12:57:29 PM

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