Layer: Recycled Service Valve (ID:2)

View In: Map Viewer

Name: Recycled Service Valve

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:

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"NORMALPOSITION","field2":null,"field3":null,"defaultSymbol":null,"defaultLabel":null,"uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"f3f6cd16388a0833ad92947c97e9bfbc","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAW9JREFUKJGd0jtrVEEUAOBv8ZIrviIXQa5YqJBCIQZBEXu7LCRoo51hUyzEVxErEcTCShBERZFFxCI2PgL5D2abbGEjKipajI2jnUwKtci9y2YJCJ5uDuc7c+Ywmf+MbKPkEmPKcrwRwqdJev+EL4pi7nWMN5vsEAJosXqSh2e5uCFc4NFcjLNhqHOHkQ4XHuT5iXZKx9bBxbI8/TGE1nlc3WCscxhN6egCd+qbM3gbwq1ZGtuqwkE8g9vYiuu0DMJf7CmqwvkBXKPRKjfGlkWOTNHLIB9468jaQtyoWtcIdmJTWe4XQq++cRWb4SeuIKGNZ9hXwW/YG8Kb/qi78vzd15QOb8dlPK0KuzhT4d0I/Gjzvg8PpDTTofuZ7MnQRms8zZ+JorgmRn3YZOVVUVxajvEuGkPW97VxO6divFfn+kuZjvH+EsuTef64m9KhLtk4v4/z5WBZzk+F8Hyw2bov12RFShP1+QNeov5+g/EXHwVvtM6DQDAAAAAASUVORK5CYII=","contentType":"image/png","width":10,"height":10,"angle":0,"xoffset":0,"yoffset":0},"value":"0","label":"CLOSED","description":""},{"symbol":{"type":"esriPMS","url":"7863cb23ebed6925b3d704e108f6f8d1","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAa9JREFUKJGdks9LVFEUxz/jXGfEyR88B+xJkZJhOGXI2EJz2aptEDGIKCNChrZJyIULNyYUBOEPVEQRcyOu/QuUUmcm0rfQgpiELhlc0Y1zn/Zj8XrOvBQEz+4evp9zzznfI7hgiLOSTdPc0MK8nfHLr1aM1LlgdMp4+n1VDa60UwwSADOGbTQzbnXRcyYYGWMy0as6UN7Kcp6AnKe75mWwcatP3/WA0Rnz4X5axq91QnrodFvmIxAluiEyylv3ZwGw/0W+vh7DJ0KOMBc2H0PdAIhCSL4iDjngUYaKQKkjvPUkC7tQoMjJGVUUGrPUW62knBkD2Vnz8uFmDNJvoDqehQDyS8HvM6tAOqB9iA0UANgHsDYAaFjthXsTELrigIc/oKxcbpy0WlwW3M5IXZcXgk/9oBYdof4Iy50OHAzDr132Vl7w+QQUlbp9+x0f7B2EXPBu1IUvP+BPOGL0888vAWC1kIzOGM82k2oY8P1vh96DS1eZSsTViMdHgESbGo3M8f74fnD6Z0rXqnWEUctvI8q3kmrzeaJNLuYW85yc1UIS9B33rdKglsA9v9z4C844jIrFEefSAAAAAElFTkSuQmCC","contentType":"image/png","width":10,"height":10,"angle":0,"xoffset":0,"yoffset":0},"value":"1","label":"OPEN","description":""}],"fieldDelimiter":","},"transparency":0,"labelingInfo":[{"labelPlacement":"esriServerPointLabelPlacementAboveRight","where":null,"labelExpression":"[ASSETID]","useCodedValues":true,"symbol":{"type":"esriTS","color":[76,0,115,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"center","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[255,255,255,255],"haloSize":1,"font":{"family":"Arial","size":9,"style":"normal","weight":"bold","decoration":"none"}},"minScale":2500,"maxScale":0}]}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field: GlobalID

Type ID Field: NORMALPOSITION

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: [PVC: POLYVINYL CHLORIDE], [CI: CAST IRON], [UNK: UNKNOWN], ... 3 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 ...)
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)
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)
NORMALPOSITION (type: esriFieldTypeInteger, alias: Normal Position, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: CLOSED], [1: OPEN])
TURNSTOOPEN (type: esriFieldTypeSmallInteger, alias: Turns to Open, SQL Type: sqlTypeOther, 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 ...)
PROTECTION (type: esriFieldTypeString, alias: Protection, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [FBE FBE: Fusion Bonded Epoxy], [PW: Plastic Wrapped], [FBPE: Fusion Bonded Polyethelene (includes Sintakote)], ... 1 more ...)
MANUFACTURER (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
MODEL (type: esriFieldTypeString, alias: Model, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
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])
ACTUATEDINDICATOR (type: esriFieldTypeInteger, alias: Actuated Indicator, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: NO], [1: YES], [2: UNKNOWN])
ANCILLARYROLE (type: esriFieldTypeSmallInteger, alias: Ancillary Role, SQL Type: sqlTypeOther, nullable: true, editable: true)
BONDEDINDICATOR (type: esriFieldTypeString, alias: Bonded Indicator, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [N: NO], [Y: YES], [U: UNKNOWN], ... 1 more ...)
CLOCKWISETOCLOSEINDICATOR (type: esriFieldTypeInteger, alias: Clockwise to Close Indicator, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: NO], [1: YES], [2: UNKNOWN])
CPSYSTEMSTATUS (type: esriFieldTypeInteger, alias: CP System Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: CLOSED], [1: OPEN])
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)
GPSDRMS (type: esriFieldTypeDouble, alias: GPS DMRS, SQL Type: sqlTypeOther, nullable: true, editable: true)
LEGACYASSETID (type: esriFieldTypeString, alias: Legacy Asset ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
LOCKEDINDICATOR (type: esriFieldTypeString, alias: Locked Indicator, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
OPERATINGCLASSIFICATION (type: esriFieldTypeString, alias: Operating Classification, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [CIR: CRITICAL/INSPECTION REQUIRED], [CINR: CRITICAL/ INSPECTION NOT REQUIRED], [NC: NON CRITICAL])
PRESSURESETTING (type: esriFieldTypeString, alias: Pressure Setting, SQL Type: sqlTypeOther, length: 20, 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 ...)
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)
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 ...)
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)
WATERPRESSURESYSTEMSTATUS (type: esriFieldTypeString, alias: Water Pressure System Status, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [N: NOT A BOUNDARY], [Y: BOUNDARY])
WATERSYSTEMSTATUS (type: esriFieldTypeString, alias: Water System Status, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [N: NOT A BOUNDARY], [Y: BOUNDARY])
WATERTRACEWEIGHT (type: esriFieldTypeInteger, alias: Water Trace Weight, SQL Type: sqlTypeOther, nullable: true, editable: true)
OPERABLE (type: esriFieldTypeString, alias: Operable, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [N: NO], [Y: YES], [U: UNKNOWN], ... 1 more ...)
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:

Field Name: STATUS
Inherited
Field Name: WATERTYPE
Inherited
Field Name: MATERIAL
Inherited
Field Name: DIAMETER
Inherited
Field Name: SLSOURCE
Inherited
Field Name: OWNER
Inherited
Field Name: FUNDINGSOURCE
Inherited
Field Name: LOCALGOVAREA
Inherited
Field Name: NORMALPOSITION
Inherited
Field Name: LOCATIONCLASSIFICATION
Inherited
Field Name: PROTECTION
Inherited
Field Name: RETIRED
Inherited
Field Name: SUBNET
Inherited
Field Name: ACTUATEDINDICATOR
Inherited
Field Name: BONDEDINDICATOR
Inherited
Field Name: CLOCKWISETOCLOSEINDICATOR
Inherited
Field Name: CPSYSTEMSTATUS
Inherited
Field Name: ENABLED
Inherited
Field Name: OPERATINGCLASSIFICATION
Inherited
Field Name: SCADAENABLED
Inherited
Field Name: SUI_QUALITYRATING
Inherited
Field Name: SUI_QUALITYRATINGSOURCE
Inherited
Field Name: WATERPRESSURESYSTEMSTATUS
Inherited
Field Name: WATERSYSTEMSTATUS
Inherited
Field Name: OPERABLE
Inherited
Field Name: LINING
Inherited
Field Name: JOINTTYPE
Inherited
Field Name: EQUIPMENTTYPE
Inherited
Field Name: EGI
Inherited
Field Name: RESPONSIBILITY_FOR_ASSET
Inherited
Field Name: AR1_PRODUCT
Inherited
Field Name: WARRANTY_STAT_TYPE
Inherited
Field Name: PRIORITY
Inherited
Field Name: AR11_MOUNTINSTALLATION
Inherited
Field Name: AR17_OPERATING_ENVIRON
Inherited
Field Name: CONDITION
Inherited
Field Name: LIKELIHOOD
Inherited
Field Name: RISK
Inherited
Field Name: RISK_RESIDUAL
Inherited
Field Name: RISK_CONTINGENCY_PLAN
Inherited
Field Name: REPLMT_COST_DATE_SOURCE
Inherited
Field Name: CONDITION_SCORE_SOURCE
Inherited
Field Name: CONSEQUENCE_SOURCE
Inherited
Field Name: TP_ZONE_FACT
Inherited
Field Name: ALIGNMENT_LOCATION
Inherited

SUBTYPECD: 38500
NORMALPOSITION: 0
ENABLED: 1

Field Name: STATUS
Inherited
Field Name: WATERTYPE
Inherited
Field Name: MATERIAL
Inherited
Field Name: DIAMETER
Inherited
Field Name: SLSOURCE
Inherited
Field Name: OWNER
Inherited
Field Name: FUNDINGSOURCE
Inherited
Field Name: LOCALGOVAREA
Inherited
Field Name: NORMALPOSITION
Inherited
Field Name: LOCATIONCLASSIFICATION
Inherited
Field Name: PROTECTION
Inherited
Field Name: RETIRED
Inherited
Field Name: SUBNET
Inherited
Field Name: ACTUATEDINDICATOR
Inherited
Field Name: BONDEDINDICATOR
Inherited
Field Name: CLOCKWISETOCLOSEINDICATOR
Inherited
Field Name: CPSYSTEMSTATUS
Inherited
Field Name: ENABLED
Inherited
Field Name: OPERATINGCLASSIFICATION
Inherited
Field Name: SCADAENABLED
Inherited
Field Name: SUI_QUALITYRATING
Inherited
Field Name: SUI_QUALITYRATINGSOURCE
Inherited
Field Name: WATERPRESSURESYSTEMSTATUS
Inherited
Field Name: WATERSYSTEMSTATUS
Inherited
Field Name: OPERABLE
Inherited
Field Name: LINING
Inherited
Field Name: JOINTTYPE
Inherited
Field Name: EQUIPMENTTYPE
Inherited
Field Name: EGI
Inherited
Field Name: RESPONSIBILITY_FOR_ASSET
Inherited
Field Name: AR1_PRODUCT
Inherited
Field Name: WARRANTY_STAT_TYPE
Inherited
Field Name: PRIORITY
Inherited
Field Name: AR11_MOUNTINSTALLATION
Inherited
Field Name: AR17_OPERATING_ENVIRON
Inherited
Field Name: CONDITION
Inherited
Field Name: LIKELIHOOD
Inherited
Field Name: RISK
Inherited
Field Name: RISK_RESIDUAL
Inherited
Field Name: RISK_CONTINGENCY_PLAN
Inherited
Field Name: REPLMT_COST_DATE_SOURCE
Inherited
Field Name: CONDITION_SCORE_SOURCE
Inherited
Field Name: CONSEQUENCE_SOURCE
Inherited
Field Name: TP_ZONE_FACT
Inherited
Field Name: ALIGNMENT_LOCATION
Inherited

SUBTYPECD: 38500
NORMALPOSITION: 1
ENABLED: 1

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/5/2022 3:23:02 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