Name: Water Maintenance Hole

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:

XMin: 520350.263
YMin: 6883321.256
XMax: 553935.114
YMax: 6935069.336
Spatial Reference: 28356 (28356)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"2b23b60ab5170dd6fbcaf2abc37fe148","imageData":"iVBORw0KGgoAAAANSUhEUgAAABQAAAAUCAYAAACNiR0NAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAA2BJREFUOI2tlM1PXFUYxn/n3HsZ7oxMgTaBS11obUFs+RwQNUbrV2rCdAzaRDcujAn4P7hgZufCjW6UxrjoxpjoBqqmfiTaarTIBZqqjeKipXYGtQRspzO93DvndTED0oLaRN/d+cjvPOe8z3ls/ueyb2VTGIZtjuPk/xNQREaB0dowJSIABcAHskop/5aAIpICspWKpL8/d53FxRClqmvG4LW2WOnuLjctIsejKBq7WfkNQGPMYWCysLTGqa/K3D/k0rXf3QACXF4OOfFpkX17nXRnhzsThuHAZugGsKZs4uIva/xw7jpHRpJorXwROQ4qLyIFpZS3a6eTzQw73tx8ibn5ktfXG58ADm+nMBsExpueKfP0UztQCh8YU0plgXFVlTkgImNKqcm+3jifnyzy++UwLSKjSqmjG8AwDNuA9PRMiUcPJnj9jWVGX2hKua7OGiPpV15dpqe7juEnkxNKKX79LeSLUyVGMkk++vgqmWFnFPgLaFlWCmBl1dDUaOO12CxeDOhod9OFpZCGBs3XpwMOPS4p21b8tBCwu83CcRSWhkpFUjdcWSnlAVi6Otl1oI4fF0I62l0Wfl5jaDBGYanC+QsBe++qZ/ZMwPPP7QCgqVFz7ZrZ8Kpda0ib2tTKPXfEePf9IplhmPYDXnqxkV07Q+bOBNy+u44/rgjNzdXn15bCiGDbtgfk15vi13wGQCymaWuxuJRfQ2tIJi0SCc3bx65yT2fAA/fGNg5fWamQiFtEUVTYfOU8QH29olw2uK6mvzfG5AdF7huMAfiWpVL7Ox0++azEkZGGmm+FUllwHFVQqurFdaAvIv7QYDx18ssih55I0r6vnreOFXn2mSQiklNKTfb1xHjnvSJeax0As/NlUn31iMjUFh9GUZRJJu1LrS02s/Ml+nvjvPlaC0BBKTVljMnd3eGO5152ATh/IWB1tcJAf9yPoii3Beg4Tt4Yk+vpjo+f/a7Mhyeu8PCDCRIJyxORPOABBGuGb06X0Boee6QBEclt+/UAtNZZYwxdB9zxPXfW8a1fplg0WFYVZgw4jmKg36W52fZFJKe1ntrM2JI2WuusiEwlEtbEwYduS928DhREZCqKotx2GbltHtaybgCq39K27TQ1a/1dDv4jcHPVVBz9t33r9Sd28mHPrGcjewAAAABJRU5ErkJggg==","contentType":"image/png","width":15,"height":15,"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:

Name : OBJECTID

IsSystemMaintained : True

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)
• WTR_MH_SUBTYPE (type: esriFieldTypeDouble, alias: WTR_MH_SUBTYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WTR_MAINT_HOLE_USE (type: esriFieldTypeString, alias: WTR_MAINT_HOLE_USE, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [MAINTENANCE HOLE: Maintenance Hole], [MAINTENANCE SHAFT: Maintenance Shaft], [VALVE PIT: Valve Pit])
• LENGTH_MM (type: esriFieldTypeDouble, alias: LENGTH_MM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WIDTH_MM (type: esriFieldTypeDouble, alias: WIDTH_MM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DIAMETER_MM (type: esriFieldTypeDouble, alias: DIAMETER_MM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AREA_SQM (type: esriFieldTypeDouble, alias: AREA_SQM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SURFACE_LEVEL_M (type: esriFieldTypeDouble, alias: SURFACE_LEVEL_M, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INVERT_LEVEL_M (type: esriFieldTypeDouble, alias: INVERT_LEVEL_M, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAINT_HOLE_FLOOR_CONSTRUCTION (type: esriFieldTypeString, alias: MAINT_HOLE_FLOOR_CONSTRUCTION, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [PREFABRICATED: Prefabricated], [INSITU: Built or poured in-situ])
• MAINT_HOLE_FLOOR_MATERIAL (type: esriFieldTypeString, alias: MAINT_HOLE_FLOOR_MATERIAL, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [PVC: Poly Vinyl Chloride], [PE: Polyethylene], [PP: Polypropylene], ... 4 more ...)
• MAINT_HOLE_WALL_CONSTRUCTION (type: esriFieldTypeString, alias: MAINT_HOLE_WALL_CONSTRUCTION, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [PREFABRICATED: Prefabricated], [INSITU: Built or poured in-situ])
• MAINT_HOLE_WALL_MATERIAL (type: esriFieldTypeString, alias: MAINT_HOLE_WALL_MATERIA, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [PVC: Poly Vinyl Chloride], [PE: Polyethylene], [PP: Polypropylene], ... 4 more ...)
• MAINT_HOLE_ROOF_MATERIAL (type: esriFieldTypeString, alias: MAINT_HOLE_ROOF_MATERIAL, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [PVC: Poly Vinyl Chloride], [PE: Polyethylene], [PP: Polypropylene], ... 10 more ...)
• MAINT_HOLE_LINING (type: esriFieldTypeString, alias: MAINT_HOLE_LINING, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [TBA: TBA], [PVC: Poly Vinyl Chloride], [PE: Polyethylene], ... 3 more ...)
• MAINT_LID_MATERIAL (type: esriFieldTypeString, alias: MAINT_LID_MATERIAL, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [DI: Ductile Iron], [PVC: Poly Vinyl Chloride], [PE: Polyethylene], ... 10 more ...)
• LID_SIZE_MM (type: esriFieldTypeDouble, alias: LID_SIZE_MM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ROTATION (type: esriFieldTypeString, alias: Rotation, 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: GIS_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: GIS_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])
• 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)
• RELINING_MATERIAL (type: esriFieldTypeString, alias: RELINING_MATERIAL, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [CONCRETE: Concrete], [CURED IN-PLACE PIPE: Cured in-place pipe], [POLY VINYL CHLORIDE: Poly Vinyl Chloride], ... 7 more ...)
• RELINING_DATE (type: esriFieldTypeDate, alias: RELINING_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:

Name: Water Maintenance Hole
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• CLASS: WATER_MAINT_HOLE
• OBJECT_TYPE: WTMH
• GIS_EQUIPMENT_CATEGORY: W
• RE_ENRICH: NO

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

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

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

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

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