Layer: Water Hydrant (ID:3)

View In: Map Viewer

Name: Water Hydrant

Display Field: SAPOBJECTID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Custodian Organisation: City of Gold Coast. Custodian Position: Manager Business Performance - GCWW. Point of Contact Position: Coordinator Data Services - GCW. Point of Contact Details: Michael Shanley.

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"db3370f71c2c2e4ec92cdeddea0c5b32","imageData":"iVBORw0KGgoAAAANSUhEUgAAABIAAAASCAYAAABWzo5XAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAt9JREFUOI2t1GlI03EYB/Dv5o5/0zWdtnm0zYhMy9QUryhJomIVam06p4UdMsiONwbhi6AXkfkigjQjK3DmMU1NpBCRDhIJRcN7pnmF53RT3NE2t9YLae0fkwj6vn2e34ff8fCj4T+FtlkhXly3W8SnZfj6MBIAeNvtjvnJWVPrmodHY2edVPtXSCyuYgeFcCq+ThlS57VWyrzW6lqW8NiO4uzcV7ernp2+tyl0ILOay+Ower9MGASRoWxkSUIRLPIFQdCg11swPLKAshdq5rdFS+GlK81Rzx+lZLqFwvnsNvWEUXAhfQfOZsaATvdw1ny8PSEUcJEQF4zC++341LsqU1xvHix7mHKHBJ2/3CRVTxijxUk8yDP2Q28wg0LZAADAaLTAYrWBYNJQkH8IF6+1YFFrvRWfUf+4s06qdUL+POLm+IwZ8vQILC3pkZ3XBh6XjvryMwCAN63DKCkfRb4iDKmnIqA4F4a7xQOMcBErqxModkKzC+a9PC4dQgEXs3Mr7p/SJXtC/QEMIJBHpMAV0ugsxL6QraBSKc5mg8mGKlU3AKCnf4kEsdlMAMAPB/xJd+S7lW5b1lnors0mswNPqsfd7shstgEAmAyqkQQFC72W2rt1gVqdwdns501DRelJAEDT60GUuaBT0xszyWLR+0lQAJ9oApD39v0YEuNFAAAqlQIvLwIAwGD8HoX1dTuqG0ZAp1HQN7TygAR1fNDdCBGxckuUowxPT9IJSbHbHahU9aBvRI8Th/ldBfnJahKkUqV9V9Z0yTXL0/VFpUOUqzkhOJK8ywlI06IQFyNEzct+tHzUIDaCozet2o7+qpMmO0ce11hb/1n+rmOuskQ5SitRjmLndgJ+XCYmZ0zQ6NYBAMcPbpvj+XjFKBTxa24hAJBJo2sbGvpakhKsTyen1o6NTeg5Q2N6SlDAFntijN9sIJ9VmiWLLfpzndtvRCKJXAMg2/Si3GTT/+hf8xOePAR4JjTHqAAAAABJRU5ErkJggg==","contentType":"image/png","width":13,"height":13,"angle":0,"xoffset":0,"yoffset":0}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: true

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
SAPOBJECTID (type: esriFieldTypeString, alias: SAPOBJECTID, SQL Type: sqlTypeOther, length: 18, nullable: true, editable: true)
CLASS (type: esriFieldTypeString, alias: CLASS, SQL Type: sqlTypeOther, length: 18, nullable: true, editable: true)
GIS_USER_STATUS (type: esriFieldTypeString, alias: GIS_USER_STATUS, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
OBJECT_TYPE (type: esriFieldTypeString, alias: OBJECT_TYPE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
GIS_SYSTEM_STATUS (type: esriFieldTypeString, alias: GIS_SYSTEM_STATUS, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
WATER_CATEGORY (type: esriFieldTypeString, alias: Water category, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [POTABLE: Potable], [NON-DRINKING: Potable Wtr in purple A+ pipe], [RECYCLED A: Rec water pipes-class A water], ... 1 more ...)
HYDRANT_USE (type: esriFieldTypeString, alias: HYDRANT_USE, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [FLUSH: Flush Hydrant], [FIRE FIGHTING: Fire Fighting], [OPERATIONAL: Operational], ... 1 more ...)
HYDRANT_TYPE (type: esriFieldTypeString, alias: HYDRANT_TYPE, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [SPRING: Spring Hydrant], [PILLAR: Pillar Hydrant], [FILLING POINT: Filling Point])
HYDRANT_MATERIAL (type: esriFieldTypeString, alias: HYDRANT_MATERIAL, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [TBA: TBA], [STEEL: Steel], [DUCTILE IRON: Ductile Iron], ... 3 more ...)
HYDRANT_LINING (type: esriFieldTypeString, alias: HYDRANT_LINING, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [CEMENT: Cement], [EPOXY: Epoxy], [FUSION BONDED: Fusion Bonded], ... 1 more ...)
HYDRANT_PROTECTION (type: esriFieldTypeString, alias: HYDRANT_PROTECTION, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [PAINTED: Painted], [POWDERCOATED: Powdercoated], [GALVANISED: Galvanised], ... 6 more ...)
DIAMETER_MM (type: esriFieldTypeDouble, alias: DIAMETER_MM, SQL Type: sqlTypeOther, nullable: true, editable: true)
ROTATION (type: esriFieldTypeString, alias: Rotation angle, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
GIS_MANUFACTURER (type: esriFieldTypeString, alias: GIS_MANUFACTURER, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
GIS_MANUSERIALNO (type: esriFieldTypeString, alias: GIS_MANUSERIALNO, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
GIS_MODEL_NUMBER (type: esriFieldTypeString, alias: GIS_MODEL_NUMBER, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
GIS_PROJECT_DEVELOPER_APPL_ID (type: esriFieldTypeString, alias: GIS_PROJECT_DEVELOPER_APPL_ID, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
GIS_DRAWING_NUMBER (type: esriFieldTypeString, alias: GIS_DRAWING_NUMBER, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
ASSET_LEVEL_ACCURACY (type: esriFieldTypeString, alias: ASSET_LEVEL_ACCURACY, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [A+: A+ +/- 10mm Absolute Location/Survey], [A: A +/- 50mm Absolute Location/Survey], [B: B +/- 500mm No-Dig Survey], ... 4 more ...)
ASSET_POSITIONAL_ACCURACY (type: esriFieldTypeString, alias: ASSET_POSITIONAL_ACCURACY, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [A: A +/- 50mm Absolute Location/Survey], [B: B +/- 300mm Absolute Location/Survey], [C: C +/- 300mm Relative position], ... 2 more ...)
PHOTO_LINK (type: esriFieldTypeString, alias: Photo Link, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
PHOTO_LEGACY (type: esriFieldTypeString, alias: Photo Legacy, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
GIS_ACQUISITION_METHOD (type: esriFieldTypeString, alias: GIS_ACQUISITION_METHOD, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [CAPEX: Capital Expenditure], [CONTR: Contributed], [DON: Donated], ... 2 more ...)
GIS_STARTUP_DATE (type: esriFieldTypeDate, alias: STARTUP_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
GIS_ASSET_FUNDING_BASIS (type: esriFieldTypeString, alias: GIS_ASSET_FUNDING_BASIS, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [GCCC: GCCC], [DEV: Developer], [SG: State Government], ... 3 more ...)
FUNCTIONAL_LOC (type: esriFieldTypeString, alias: FUNCTIONAL_LOC, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
SUPERORD_EQUIP (type: esriFieldTypeString, alias: SUPERORD_EQUIPMENT, SQL Type: sqlTypeOther, length: 18, nullable: true, editable: true)
GIS_DESCRIPTION (type: esriFieldTypeString, alias: GIS_DESCRIPTION, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
SORT_FIELD (type: esriFieldTypeString, alias: SORT_FIELD, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
GIS_EQUIPMENT_CATEGORY (type: esriFieldTypeString, alias: Equipment Category, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
GIS_OWNER (type: esriFieldTypeString, alias: GIS_OWNER, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [COMB: Commonwealth Bureau Meteorol], [COMG: Commonwealth Government], [DE: Dept Education], ... 14 more ...)
GIS_CUSTODIAN (type: esriFieldTypeString, alias: ASSET_MANAGER, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true, Coded Values: [51003030: Manager Property Services], [51000811: Manager Parks and Recreational Services], [51000989: Manager Community Venues and Services], ... 10 more ...)
RE_ENRICH (type: esriFieldTypeString, alias: Re-Enrich, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [NO: No], [YES: Yes], [TBA: TBA])
ENABLED (type: esriFieldTypeSmallInteger, alias: ENABLED, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
SYNCSTATUS (type: esriFieldTypeSmallInteger, alias: SYNCSTATUS, SQL Type: sqlTypeOther, nullable: true, editable: true)
SYNCERRORDESC (type: esriFieldTypeString, alias: SYNCERRORDESC, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
SYNCDATE (type: esriFieldTypeDate, alias: SYNCDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
CREATED_USER (type: esriFieldTypeString, alias: CREATED_USER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CREATED_DATE (type: esriFieldTypeDate, alias: CREATED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
LAST_EDITED_USER (type: esriFieldTypeString, alias: LAST_EDITED_USER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
LAST_EDITED_DATE (type: esriFieldTypeDate, alias: LAST_EDITED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
GIS_ACQUISITION_PROJECT (type: esriFieldTypeString, alias: GIS_ACQUISITION_PROJECT, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
DATA_SOURCE (type: esriFieldTypeString, alias: DATA_SOURCE, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [SKE: Sketch], [HIS: Historical Records], [EDF: Electronic Drawing File], ... 4 more ...)

Templates:

CLASS: HYDRANT
OBJECT_TYPE: WTHY
GIS_EQUIPMENT_CATEGORY: W
RE_ENRICH: NO
ENABLED: 1

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/20/2023 3:16:25 AM

Schema Last Edit Date: 7/20/2023 3:16:25 AM

Data Last Edit Date: 7/20/2023 3:16:25 AM

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