{ "currentVersion" : 12, "id" : 8, "name" : "Sewer Pipe Non Pressure", "type" : "Feature Layer", "serviceItemId" : "9dcbe2f62a1e4bd0a718805d0d8ce030", "cacheMaxAge" : 30, "displayField" : "SAPOBJECTID", "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.", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1689823093963, "schemaLastEditDate" : 1689823093963, "dataLastEditDate" : 1689823093963 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : true, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeLengthFieldName" : "Shape__Length", "units" : "esriMeters" }, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolyline", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : 520854.46899999958, "ymin" : 6883111.26, "xmax" : 554075.26449999958, "ymax" : 6934783.546, "spatialReference" : { "wkid" : 28356, "latestWkid" : 28356 } }, "spatialReference" : { "wkid" : 28356, "latestWkid" : 28356 }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[78,78,78,255],"width":2}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : true, "enableZDefaults" : true, "zDefault" : 0, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "SAPOBJECTID", "type" : "esriFieldTypeString", "alias" : "SAPOBJECTID", "sqlType" : "sqlTypeOther", "length" : 18, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CLASS", "type" : "esriFieldTypeString", "alias" : "CLASS", "sqlType" : "sqlTypeOther", "length" : 18, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "PIPE_NON_PRESSURE" }, { "name" : "GIS_USER_STATUS", "type" : "esriFieldTypeString", "alias" : "USER_STATUS", "sqlType" : "sqlTypeOther", "length" : 60, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OBJECT_TYPE", "type" : "esriFieldTypeString", "alias" : "OBJECT_TYPE", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "SENP" }, { "name" : "GIS_SYSTEM_STATUS", "type" : "esriFieldTypeString", "alias" : "SYSTEM_STATUS", "sqlType" : "sqlTypeOther", "length" : 60, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PIPE_NON_PRESSURE_USE", "type" : "esriFieldTypeString", "alias" : "Pipe non-pressure Use", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "PIPE_NON_PRESSURE_USE", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Conduit Pipe (enveloper)", "code" : "CONDUIT PIPE" }, { "name" : "Disused Non Pressure Pipe", "code" : "DISUSED" }, { "name" : "Treated Wastewater Pipe", "code" : "EFFLUENT" }, { "name" : "Directs excessive wastewater", "code" : "OVERFLOW" }, { "name" : "Treated Wastewater Reuse Pipe", "code" : "REUSE" }, { "name" : "Scour Main", "code" : "SCOUR" }, { "name" : "Stub Pipe", "code" : "STUB" }, { "name" : "Trunk Sewer", "code" : "TRUNK" }, { "name" : "Ventilation Main", "code" : "VENT" }, { "name" : "Syphon Main", "code" : "SYPHON" }, { "name" : "Reticulation Sewer", "code" : "RETICULATION" }, { "name" : "Vacuum", "code" : "VACUUM" } ] }, "defaultValue" : null }, { "name" : "PIPE_NON_PRESSURE_CLASS", "type" : "esriFieldTypeString", "alias" : "Pipe non-pressure Class", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "PIPE_NON_PRESSURE_CLASS", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Class Sewer Extra Heavy", "code" : "SN8 (SEH)" }, { "name" : "Class 2", "code" : "2" }, { "name" : "Class 4", "code" : "4" }, { "name" : "Class 6", "code" : "6" }, { "name" : "Class 8", "code" : "8" }, { "name" : "Class 9", "code" : "9" }, { "name" : "Class 10", "code" : "10" }, { "name" : "Class 12", "code" : "12" }, { "name" : "Class 15", "code" : "15" }, { "name" : "Class 16", "code" : "16" }, { "name" : "Class 18", "code" : "18" }, { "name" : "Class 20", "code" : "20" }, { "name" : "Class 35", "code" : "35" }, { "name" : "Class 50", "code" : "50" }, { "name" : "PN1", "code" : "PN1" }, { "name" : "PN6", "code" : "PN6" }, { "name" : "PN6.3", "code" : "PN6.3" }, { "name" : "PN8", "code" : "PN8" }, { "name" : "PN10", "code" : "PN10" }, { "name" : "PN12", "code" : "PN12" }, { "name" : "PN12.5", "code" : "PN12.5" }, { "name" : "PN16", "code" : "PN16" }, { "name" : "PN18", "code" : "PN18" }, { "name" : "PN20", "code" : "PN20" }, { "name" : "PN35", "code" : "PN35" }, { "name" : "Ductile iron flanged class", "code" : "FLCL" }, { "name" : "SN4", "code" : "SN4" }, { "name" : "SN6", "code" : "SN6" }, { "name" : "SN8", "code" : "SN8" }, { "name" : "SN10", "code" : "SN10" }, { "name" : "SN12", "code" : "SN12" }, { "name" : "SN15", "code" : "SN15" }, { "name" : "SN20", "code" : "SN20" }, { "name" : "SN5000", "code" : "SN5000" }, { "name" : "SN8000", "code" : "SN8000" }, { "name" : "SN10000", "code" : "SN10000" }, { "name" : "SDR7.4", "code" : "SDR7.4" }, { "name" : "SDR9", "code" : "SDR9" }, { "name" : "SDR11", "code" : "SDR11" }, { "name" : "SDR13.5", "code" : "SDR13.5" }, { "name" : "SDR17", "code" : "SDR17" }, { "name" : "Class A", "code" : "A" }, { "name" : "Class B", "code" : "B" }, { "name" : "Class C", "code" : "C" }, { "name" : "Class D", "code" : "D" }, { "name" : "Class V", "code" : "V" }, { "name" : "Class X", "code" : "X" }, { "name" : "Class Y", "code" : "Y" }, { "name" : "Class Z", "code" : "Z" }, { "name" : "TBA", "code" : "TBA" }, { "name" : "SN64000", "code" : "SN64000" }, { "name" : "SDR21", "code" : "SDR21" } ] }, "defaultValue" : null }, { "name" : "PIPE_NON_PRESSURE_MATERIAL", "type" : "esriFieldTypeString", "alias" : "Pipe non-pressure Material", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "PIPE_NON_PRESSURE_MATERIAL", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "PolyVinylChloride", "code" : "PVC" }, { "name" : "Medium Density Polyethylene", "code" : "MDPE" }, { "name" : "PolyVinylChlor Unplasticised", "code" : "PVC-U" }, { "name" : "PolyVinylChloride Modified", "code" : "PVC-M" }, { "name" : "Asbestos Cement", "code" : "AC" }, { "name" : "Acrylonitrile Butadiene Styren", "code" : "ABS" }, { "name" : "Cast Iron", "code" : "CI" }, { "name" : "Ductile Iron", "code" : "DI" }, { "name" : "High Density Polyethylene", "code" : "HDPE" }, { "name" : "Glass Fibre Reinforced Plastic", "code" : "GRP" }, { "name" : "Mild Steel", "code" : "MS" }, { "name" : "Polyethylene", "code" : "PE" }, { "name" : "Polypropylene", "code" : "PP" }, { "name" : "Polyethylene 100", "code" : "PE-100" }, { "name" : "Fibre Reinforced Concrete", "code" : "FRC" }, { "name" : "Reinforced Concrete Pipe", "code" : "RCP" }, { "name" : "Pcrete", "code" : "PCRETE" }, { "name" : "Structural Wall Polypropylene", "code" : "SWPP" }, { "name" : "Vitrified Clay", "code" : "VC" }, { "name" : "Polyester Resin Concrete", "code" : "PRC" }, { "name" : "Concrete", "code" : "CONCRETE" }, { "name" : "Stainless Steel", "code" : "SS" } ] }, "defaultValue" : null }, { "name" : "PIPE_NON_PRESSURE_LINING", "type" : "esriFieldTypeString", "alias" : "Pipe non-pressure Lining", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "PIPE_NON_PRESSURE_LINING", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Cement Lined Normal", "code" : "CL" }, { "name" : "CL - Sulphate Resitant", "code" : "CL_SR" }, { "name" : "CL - Calcium Aluminate", "code" : "CL_AC" }, { "name" : "Plasticesed PVC", "code" : "PVC" }, { "name" : "Fusion Bonded Epoxy", "code" : "FBE" }, { "name" : "TBA", "code" : "TBA" }, { "name" : "Urethane Lined", "code" : "UL" }, { "name" : "Epoxy Lined", "code" : "EL" }, { "name" : "Unlined", "code" : "UNLINED" }, { "name" : "Fusion Bonded Polyethylene", "code" : "FBPE" }, { "name" : "Polyethylene", "code" : "PE" } ] }, "defaultValue" : null }, { "name" : "PIPE_NON_PRESSURE_PROTECTION", "type" : "esriFieldTypeString", "alias" : "Pipe non-pressure Protection", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "PIPE_NON_PRESSURE_PROTECTION", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Fusion Bonded Epoxy", "code" : "FBE" }, { "name" : "Fusion Bonded Polyethelene", "code" : "FBPE" }, { "name" : "TBA", "code" : "TBA" }, { "name" : "Plastic Wrapped", "code" : "PLASTIC WRAPPED" }, { "name" : "Tape Wrapped", "code" : "TAPE WRAPPED" }, { "name" : "Concrete Encased", "code" : "CONCRETE ENCASED" }, { "name" : "Expoxy Paint", "code" : "EXPOXY PAINT" }, { "name" : "Uncoated", "code" : "UNCOATED" }, { "name" : "Sheathed", "code" : "SHEATHED" }, { "name" : "PE Sleeved", "code" : "PS" } ] }, "defaultValue" : null }, { "name" : "SEWER_PIPE_EMBEDMENT", "type" : "esriFieldTypeString", "alias" : "Sewer pipe Embedment", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "SEWER_PIPE_EMBEDMENT", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "WSAA Sewerage embedment type 1", "code" : "TYPE 1" }, { "name" : "WSAA Sewerage embedment type 2", "code" : "TYPE 2" }, { "name" : "WSAA Sewerage embedment type 3", "code" : "TYPE 3" }, { "name" : "WSAA Sewerage embedment type 4", "code" : "TYPE 4" }, { "name" : "WSAA Sewerage embedment type 5", "code" : "TYPE 5" }, { "name" : "WSAA Sewerage embedment type 6", "code" : "TYPE 6" }, { "name" : "WSAA Sewerage embedment type 7", "code" : "TYPE 7" }, { "name" : "WSAA Sewerage embedment type 8", "code" : "TYPE 8" }, { "name" : "WSAA Sewerage embedment type 9", "code" : "TYPE 9" }, { "name" : "WSAA Sewerage embedment typ 10", "code" : "TYPE 10" }, { "name" : "WSAA Sewerage embedment typ 11", "code" : "TYPE 11" }, { "name" : "WSAA Sewerage embedment typ 12", "code" : "TYPE 12" }, { "name" : "WSAA Sewerage embedment typ 13", "code" : "TYPE 13" }, { "name" : "Enveloper Pipe", "code" : "ENVELOPER PIPE" }, { "name" : "Natural", "code" : "NATURAL" }, { "name" : "Concrete Bed and Surround on Piles", "code" : "CONCBS ON PILES" }, { "name" : "Thrust Bored or Trenchless Method", "code" : "NONE" }, { "name" : "Granular Bed and Haunch", "code" : "GBH" }, { "name" : "Concrete Bed and Surround", "code" : "CONC BS" }, { "name" : "Granular Bed and Surround", "code" : "GBS" }, { "name" : "Above Ground", "code" : "ABOVE GROUND" }, { "name" : "GBS on Cement Stabilised Support", "code" : "GBS ON CSS" }, { "name" : "Cement Stabilised Bed and Surround", "code" : "CEM STAB BS" }, { "name" : "GBS on Geo-Textile Pillow", "code" : "GBS ON GTP" }, { "name" : "GBS and Surround on Piles", "code" : "GBS ON PILES" }, { "name" : "GBS on Concrete Support", "code" : "GBS ON CONC" } ] }, "defaultValue" : null }, { "name" : "LINE_NUMBER", "type" : "esriFieldTypeString", "alias" : "Line number", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DIAMETER_MM", "type" : "esriFieldTypeDouble", "alias" : "Diameter in millimetres", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "UPSTREAM_INVERT_LEVEL", "type" : "esriFieldTypeDouble", "alias" : "Upstream invert level in metres", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "UPSTREAM_SURFACE_LEVEL", "type" : "esriFieldTypeDouble", "alias" : "Upstream surface level in metres", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DOWNSTREAM_SURFACE_LEVEL", "type" : "esriFieldTypeDouble", "alias" : "Downstream surface level in metres", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ALIGNMENT_M", "type" : "esriFieldTypeDouble", "alias" : "Alignment in metres", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "AVERAGE_DEPTH_M", "type" : "esriFieldTypeDouble", "alias" : "Average depth in metres", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GRADE", "type" : "esriFieldTypeDouble", "alias" : "Grade", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "JOINT_TYPE", "type" : "esriFieldTypeString", "alias" : "Joint type", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "JOINT_TYPE_1", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "TBA", "code" : "TBA" }, { "name" : "Rubber Ring - Default Value", "code" : "RR" }, { "name" : "Solvent Welded Joint (PVC)", "code" : "SWJ" }, { "name" : "Welded Joint (Mild Steel Pipe)", "code" : "WJ" }, { "name" : "Mechanical Compression Joint", "code" : "MCJ" }, { "name" : "Butt Weld (PE Pipe)", "code" : "BW" }, { "name" : "Electrofusion Weld (PE Pipe)", "code" : "EFW" }, { "name" : "Flanged Joint", "code" : "FJ" }, { "name" : "Rubber Ring Joint", "code" : "RRJ" }, { "name" : "Rubber Ring", "code" : "RRRJ" } ] }, "defaultValue" : null }, { "name" : "ROCK_EXCAVATED", "type" : "esriFieldTypeSmallInteger", "alias" : "Rock excavated", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "BOOLEAN_2", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "NO", "code" : 0 }, { "name" : "YES", "code" : 1 } ] }, "defaultValue" : null }, { "name" : "LENGTH_M", "type" : "esriFieldTypeDouble", "alias" : "Length in metres", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "RELINING_MATERIAL", "type" : "esriFieldTypeString", "alias" : "RELINING_MATERIAL", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "RELINING_MATERIAL", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Concrete", "code" : "CONCRETE" }, { "name" : "Cured in-place pipe", "code" : "CURED IN-PLACE PIPE" }, { "name" : "Poly Vinyl Chloride", "code" : "POLY VINYL CHLORIDE" }, { "name" : "Spiral Wound PVC", "code" : "SPIRAL WOUND PVC" }, { "name" : "TBA", "code" : "TBA" }, { "name" : "Glass Reinforced Plastic", "code" : "GRP" }, { "name" : "Sprayed Geopolymer", "code" : "SPRAYED GEOPOLYMER" }, { "name" : "Polyethylene", "code" : "PE" }, { "name" : "Kevlar Hose Pipe", "code" : "KEVLAR (HOSE PIPE)" }, { "name" : "Steel Re-enforced polyethylene", "code" : "STEEL RE-ENFORCED POLYETHYLENE" } ] }, "defaultValue" : null }, { "name" : "RELINING_LENGTH_M", "type" : "esriFieldTypeDouble", "alias" : "RELINING_LENGTH_M", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "RELINING_DATE", "type" : "esriFieldTypeDate", "alias" : "RELINING_DATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "FROM_SAPID", "type" : "esriFieldTypeString", "alias" : "From SAPID for Modelling", "sqlType" : "sqlTypeOther", "length" : 40, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TO_SAPID", "type" : "esriFieldTypeString", "alias" : "To SAPID for Modelling", "sqlType" : "sqlTypeOther", "length" : 40, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GIS_MANUFACTURER", "type" : "esriFieldTypeString", "alias" : "MANUFACTURER", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GIS_MANUSERIALNO", "type" : "esriFieldTypeString", "alias" : "MANUSERIALNO", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GIS_MODEL_NUMBER", "type" : "esriFieldTypeString", "alias" : "MODEL_NUMBER", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GIS_PROJECT_DEVELOPER_APPL_ID", "type" : "esriFieldTypeString", "alias" : "GIS_PROJECT_DEVELOPER_APPL_ID", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GIS_DRAWING_NUMBER", "type" : "esriFieldTypeString", "alias" : "DRAWING_NUMBER", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ASSET_LEVEL_ACCURACY", "type" : "esriFieldTypeString", "alias" : "ASSET_LEVEL_ACCURACY", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "ASSET_LEVEL_ACCURACY", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "A+ +/- 10mm Absolute Location/Survey", "code" : "A+" }, { "name" : "A +/- 50mm Absolute Location/Survey", "code" : "A" }, { "name" : "B +/- 500mm No-Dig Survey", "code" : "B" }, { "name" : "C Relative Position", "code" : "C" }, { "name" : "D Existing records/site inspection", "code" : "D" }, { "name" : "E \u003e 5000mm Mud Map/ digitised", "code" : "E" }, { "name" : "F Not Applicable/Available", "code" : "F" } ] }, "defaultValue" : null }, { "name" : "ASSET_POSITIONAL_ACCURACY", "type" : "esriFieldTypeString", "alias" : "ASSET_POSITIONAL_ACCURACY", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "ASSET_POSITIONAL_ACCURACY", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "A +/- 50mm Absolute Location/Survey", "code" : "A" }, { "name" : "B +/- 300mm Absolute Location/Survey", "code" : "B" }, { "name" : "C +/- 300mm Relative position", "code" : "C" }, { "name" : "D +/- 5000mm Site Inspection", "code" : "D" }, { "name" : "E \u003e 5000mm Mud Map/assumed", "code" : "E" } ] }, "defaultValue" : null }, { "name" : "PHOTO_LINK", "type" : "esriFieldTypeString", "alias" : "Photo Link", "sqlType" : "sqlTypeOther", "length" : 150, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PHOTO_LEGACY", "type" : "esriFieldTypeString", "alias" : "Photo Legacy", "sqlType" : "sqlTypeOther", "length" : 150, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GIS_ACQUISITION_METHOD", "type" : "esriFieldTypeString", "alias" : "Acquisition Method", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "ACQUISITION_METHOD_1", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Capital Expenditure", "code" : "CAPEX" }, { "name" : "Contributed", "code" : "CONTR" }, { "name" : "Donated", "code" : "DON" }, { "name" : "Unknown", "code" : "UN" }, { "name" : "Operational Expenditure", "code" : "OPEX" } ] }, "defaultValue" : null }, { "name" : "GIS_STARTUP_DATE", "type" : "esriFieldTypeDate", "alias" : "STARTUP_DATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "GIS_ASSET_FUNDING_BASIS", "type" : "esriFieldTypeString", "alias" : "Asset Funding Basis", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "ASSET_FUNDING_BASIS", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "GCCC", "code" : "GCCC" }, { "name" : "Developer", "code" : "DEV" }, { "name" : "State Government", "code" : "SG" }, { "name" : "Federal Government", "code" : "FG" }, { "name" : "Unknown", "code" : "UN" }, { "name" : "Other Entity", "code" : "OE" } ] }, "defaultValue" : "GCCC" }, { "name" : "FUNCTIONAL_LOC", "type" : "esriFieldTypeString", "alias" : "FUNCTIONAL_LOC", "sqlType" : "sqlTypeOther", "length" : 40, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SUPERORD_EQUIP", "type" : "esriFieldTypeString", "alias" : "SUPERORD_EQUIPMENT", "sqlType" : "sqlTypeOther", "length" : 18, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GIS_DESCRIPTION", "type" : "esriFieldTypeString", "alias" : "DESCRIPTION", "sqlType" : "sqlTypeOther", "length" : 40, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SORT_FIELD", "type" : "esriFieldTypeString", "alias" : "SORT_FIELD", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GIS_EQUIPMENT_CATEGORY", "type" : "esriFieldTypeString", "alias" : "Equipment Category", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : "S" }, { "name" : "GIS_OWNER", "type" : "esriFieldTypeString", "alias" : "GIS_OWNER", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "GIS_OWNER", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Commonwealth Bureau Meteorol", "code" : "COMB" }, { "name" : "Commonwealth Government", "code" : "COMG" }, { "name" : "Dept Education", "code" : "DE" }, { "name" : "Dept Main Roads", "code" : "DMR" }, { "name" : "Energex", "code" : "EN" }, { "name" : "Gold Coast City Council", "code" : "GCCC" }, { "name" : "Logan City Council", "code" : "LCC" }, { "name" : "Private", "code" : "P" }, { "name" : "State Emergency Service", "code" : "SES" }, { "name" : "State Government", "code" : "SG" }, { "name" : "Telstra", "code" : "TEL" }, { "name" : "Queensland Parks & Wildlife Service", "code" : "QPWS" }, { "name" : "SEQ Water", "code" : "SEQW" }, { "name" : "Queensland Rail", "code" : "QR" }, { "name" : "TBA", "code" : "TBA" }, { "name" : "Joint Owned", "code" : "JO" }, { "name" : "TWEED SHIRE COUNCIL", "code" : "TSC" } ] }, "defaultValue" : null }, { "name" : "GIS_CUSTODIAN", "type" : "esriFieldTypeString", "alias" : "ASSET_MANAGER", "sqlType" : "sqlTypeOther", "length" : 12, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "CUSTODIAN", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Manager Property Services", "code" : "51003030" }, { "name" : "Manager Parks and Recreational Services", "code" : "51000811" }, { "name" : "Manager Community Venues and Services", "code" : "51000989" }, { "name" : "Manager Health Regulatory and Lifeguard Services", "code" : "51000468" }, { "name" : "Chief Information Officer", "code" : "51003322" }, { "name" : "Manager Waste and Resource Management", "code" : "51001206" }, { "name" : "Manager Safe and Liveable Communities", "code" : "51001196" }, { "name" : "Manager City Libraries", "code" : "51000992" }, { "name" : "Manager Fleet", "code" : "51002436" }, { "name" : "Director Gold Coast Water and Waste", "code" : "51100218" }, { "name" : "Manager City Assets", "code" : "51002358" }, { "name" : "Chief Innovation and Economy Officer", "code" : "51103482" }, { "name" : "Manager Strategy Risk and Performance", "code" : "51102614" } ] }, "defaultValue" : null }, { "name" : "RE_ENRICH", "type" : "esriFieldTypeString", "alias" : "Re-Enrich", "sqlType" : "sqlTypeOther", "length" : 3, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YES_NO", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "No", "code" : "NO" }, { "name" : "Yes", "code" : "YES" }, { "name" : "TBA", "code" : "TBA" } ] }, "defaultValue" : null }, { "name" : "SYNCSTATUS", "type" : "esriFieldTypeSmallInteger", "alias" : "SYNCSTATUS", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SYNCERRORDESC", "type" : "esriFieldTypeString", "alias" : "SYNCERRORDESC", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SYNCDATE", "type" : "esriFieldTypeDate", "alias" : "SYNCDATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "CREATED_USER", "type" : "esriFieldTypeString", "alias" : "CREATED_USER", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CREATED_DATE", "type" : "esriFieldTypeDate", "alias" : "CREATED_DATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "LAST_EDITED_USER", "type" : "esriFieldTypeString", "alias" : "LAST_EDITED_USER", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LAST_EDITED_DATE", "type" : "esriFieldTypeDate", "alias" : "LAST_EDITED_DATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "DOWNSTREAM_INVERT_LEVEL", "type" : "esriFieldTypeDouble", "alias" : "DOWNSTREAM_INVERT_LEVEL", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "RELINING_INTERNAL_DIAMETER_MM", "type" : "esriFieldTypeDouble", "alias" : "RELINING_INTERNAL_DIAMETER_MM", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GCW_JOINT_TYPE", "type" : "esriFieldTypeString", "alias" : "gcw_JOINT_TYPE", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "GCW_JOINT_TYPE", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Rubber Ring - Default Value", "code" : "RR" }, { "name" : "Solvent Welded Joint (PVC)", "code" : "SWJ" }, { "name" : "Welded Joint (Mild Steel Pipe)", "code" : "WJ" }, { "name" : "Mechanical Compression Joint", "code" : "MCJ" }, { "name" : "Butt Weld (PE Pipe)", "code" : "BW" }, { "name" : "Electrofusion Weld (PE Pipe)", "code" : "EFW" }, { "name" : "Flanged Joint", "code" : "FJ" }, { "name" : "Rubber Ring Restrained Joint", "code" : "RRRJ" } ] }, "defaultValue" : null }, { "name" : "GIS_ACQUISITION_PROJECT", "type" : "esriFieldTypeString", "alias" : "GIS_ACQUISITION_PROJECT", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DATA_SOURCE", "type" : "esriFieldTypeString", "alias" : "DATA_SOURCE", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "DATA_SOURCE", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Sketch", "code" : "SKE" }, { "name" : "Historical Records", "code" : "HIS" }, { "name" : "Electronic Drawing File", "code" : "EDF" }, { "name" : "Design", "code" : "DES" }, { "name" : "Aerial Image/Photo", "code" : "AIR" }, { "name" : "Field Pick-Up", "code" : "FPU" }, { "name" : "Survey Plan", "code" : "SUR" } ] }, "defaultValue" : null }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__BEFOREYO__F4B70D859BBD9776", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_935.BEFOREYOUDIG_SEWER_PIPE_NON_PRESSURE2_Shape_sidx", "fields" : "SHAPE", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "I93SAPOBJECTID", "fields" : "SAPOBJECTID", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Sewer Pipe Non Pressure", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "DATA_SOURCE" : null, "GIS_ACQUISITION_PROJECT" : null, "SAPOBJECTID" : null, "CLASS" : "PIPE_NON_PRESSURE", "GIS_USER_STATUS" : null, "OBJECT_TYPE" : "SENP", "GIS_SYSTEM_STATUS" : null, "PIPE_NON_PRESSURE_USE" : null, "PIPE_NON_PRESSURE_CLASS" : null, "PIPE_NON_PRESSURE_MATERIAL" : null, "PIPE_NON_PRESSURE_LINING" : null, "PIPE_NON_PRESSURE_PROTECTION" : null, "SEWER_PIPE_EMBEDMENT" : null, "LINE_NUMBER" : null, "DIAMETER_MM" : null, "UPSTREAM_INVERT_LEVEL" : null, "UPSTREAM_SURFACE_LEVEL" : null, "DOWNSTREAM_SURFACE_LEVEL" : null, "ALIGNMENT_M" : null, "AVERAGE_DEPTH_M" : null, "GRADE" : null, "JOINT_TYPE" : null, "ROCK_EXCAVATED" : null, "LENGTH_M" : null, "RELINING_MATERIAL" : null, "RELINING_LENGTH_M" : null, "RELINING_DATE" : null, "FROM_SAPID" : null, "TO_SAPID" : null, "GIS_MANUFACTURER" : null, "GIS_MANUSERIALNO" : null, "GIS_MODEL_NUMBER" : null, "GIS_PROJECT_DEVELOPER_APPL_ID" : null, "GIS_DRAWING_NUMBER" : null, "ASSET_LEVEL_ACCURACY" : null, "ASSET_POSITIONAL_ACCURACY" : null, "PHOTO_LINK" : null, "PHOTO_LEGACY" : null, "GIS_ACQUISITION_METHOD" : null, "GIS_STARTUP_DATE" : null, "GIS_ASSET_FUNDING_BASIS" : "GCCC", "FUNCTIONAL_LOC" : null, "SUPERORD_EQUIP" : null, "GIS_DESCRIPTION" : null, "SORT_FIELD" : null, "GIS_EQUIPMENT_CATEGORY" : "S", "GIS_OWNER" : null, "GIS_CUSTODIAN" : null, "RE_ENRICH" : null, "SYNCSTATUS" : null, "SYNCERRORDESC" : null, "SYNCDATE" : null, "CREATED_USER" : null, "CREATED_DATE" : null, "LAST_EDITED_USER" : null, "LAST_EDITED_DATE" : null, "DOWNSTREAM_INVERT_LEVEL" : null, "RELINING_INTERNAL_DIAMETER_MM" : null, "GCW_JOINT_TYPE" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel", "supportedConvertFileFormats" : "JSON,PBF", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 2000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }