{ "currentVersion" : 12, "id" : 0, "name" : "Water Service Connection", "type" : "Feature Layer", "serviceItemId" : "9eaaf2f4f2764e29b22123f2e5dbc9fd", "cacheMaxAge" : 30, "isView" : true, "isUpdatableView" : true, "sourceSchemaChangesAllowed" : true, "displayField" : "SAPOBJECTID", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1780867340566, "schemaLastEditDate" : 1780866562774, "dataLastEditDate" : 1780867340566 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "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" : "esriDecimalDegrees" }, "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" : 153.18848201920321, "ymin" : -28.1769494916348, "xmax" : 153.55071443796987, "ymax" : -27.720226710409094, "spatialReference" : { "wkid" : 4326, "latestWkid" : 4326 } }, "spatialReference" : { "wkid" : 4326, "latestWkid" : 4326 }, "drawingInfo":{"renderer":{"type":"uniqueValue","field1":"WATER_CATEGORY","defaultSymbol":{"type":"esriSLS","style":"esriSLSSolid","color":[112,0,143,255],"width":1},"defaultLabel":"","uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[50,57,146,255],"width":2},"value":"POTABLE","label":"Potable"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[197,0,255,255],"width":2},"value":"RECYCLED A+","label":"RECYCLED A+; RECYCLED B; RECYCLED C"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[197,0,255,255],"width":2},"value":"RECYCLED B","label":"RECYCLED A+; RECYCLED B; RECYCLED C"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[197,0,255,255],"width":2},"value":"RECYCLED C","label":"RECYCLED A+; RECYCLED B; RECYCLED C"}],"fieldDelimiter":","},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "viewSourceHasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "WATER_CATEGORY", "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" : "SAP Object ID", "sqlType" : "sqlTypeOther", "length" : 18, "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"SAP system identifier for the water service connection asset.\",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "CLASS", "type" : "esriFieldTypeString", "alias" : "Class", "sqlType" : "sqlTypeOther", "length" : 18, "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : null, "defaultValue" : "WATER_SRV_CONNECTN", "description" : "{\"value\":\"Classification code indicating the feature type, defaulting to WATER_SRV_CONNECTN.\",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "GIS_USER_STATUS", "type" : "esriFieldTypeString", "alias" : "GIS User Status", "sqlType" : "sqlTypeOther", "length" : 60, "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Status codes representing the GIS user's categorization of the feature condition or state.\",\"fieldValueType\":\"orderedOrRanked\"}" }, { "name" : "OBJECT_TYPE", "type" : "esriFieldTypeString", "alias" : "Object Type", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : false, "editable" : true, "isViewOverride" : true, "domain" : null, "defaultValue" : "WACN", "description" : "{\"value\":\"Type code for the object, defaulting to WACN indicating water service connection.\",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "ASSET_LEVEL_ACCURACY", "type" : "esriFieldTypeString", "alias" : "Asset Level Accuracy", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "isViewOverride" : 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, "description" : "{\"value\":\"Accuracy level of the asset's location detail, ranging from F (not applicable) to A+ (highest accuracy).\",\"fieldValueType\":\"orderedOrRanked\"}" }, { "name" : "ASSET_POSITIONAL_ACCURACY", "type" : "esriFieldTypeString", "alias" : "Asset Positional Accuracy", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "isViewOverride" : 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, "description" : "{\"value\":\"Positional accuracy of the asset's geographic location, with values from E (low) to A (high).\",\"fieldValueType\":\"orderedOrRanked\"}" }, { "name" : "FUNCTIONAL_LOC", "type" : "esriFieldTypeString", "alias" : "Functional Location", "sqlType" : "sqlTypeOther", "length" : 40, "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Functional location identifier detailing the operational network or zone for the asset.\",\"fieldValueType\":\"locationOrPlaceName\"}" }, { "name" : "SUPERORD_EQUIP", "type" : "esriFieldTypeString", "alias" : "Superior Equipment", "sqlType" : "sqlTypeOther", "length" : 18, "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Identifier for the superior or parent equipment related to this asset, if applicable.\",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "WATER_SRV_CONNECTN_MATERIAL", "type" : "esriFieldTypeString", "alias" : "Connection Material", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : { "type" : "codedValue", "name" : "WATER_SRV_CONNECTN_MATERIAL", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Ductile Iron", "code" : "DI" }, { "name" : "Copper", "code" : "COPPER" }, { "name" : "Polyethylene", "code" : "PE" } ] }, "defaultValue" : null, "description" : "{\"value\":\"Material used for the water service connection pipe, such as ductile iron, copper, or polyethylene.\",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "WATER_SRV_CONNECTN_CLASS", "type" : "esriFieldTypeString", "alias" : "Connection Class", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : { "type" : "codedValue", "name" : "WATER_SRV_CONNECTN_CLASS", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "PN6", "code" : "PN6" }, { "name" : "PN6.3", "code" : "PN6.3" }, { "name" : "PN8", "code" : "PN8" }, { "name" : "PN9", "code" : "PN9" }, { "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" : "Type A", "code" : "Type A" }, { "name" : "SN5000", "code" : "SN5000" }, { "name" : "SN8000", "code" : "SN8000" }, { "name" : "SN10000", "code" : "SN10000" }, { "name" : "FLCL", "code" : "FLCL" }, { "name" : "Class X", "code" : "X" }, { "name" : "Class Y", "code" : "Y" }, { "name" : "Class Z", "code" : "Z" }, { "name" : "TBA", "code" : "TBA" }, { "name" : "2mm", "code" : "2MM" }, { "name" : "4.8mm", "code" : "4.8MM" }, { "name" : "5mm", "code" : "5MM" }, { "name" : "6mm", "code" : "6MM" }, { "name" : "7mm", "code" : "7MM" }, { "name" : "8mm", "code" : "8MM" }, { "name" : "9mm", "code" : "9MM" }, { "name" : "10mm", "code" : "10MM" }, { "name" : "11mm", "code" : "11MM" }, { "name" : "12mm", "code" : "12MM" }, { "name" : "15mm", "code" : "15MM" }, { "name" : "18mm", "code" : "18MM" }, { "name" : "20mm", "code" : "20MM" }, { "name" : "35mm", "code" : "35MM" }, { "name" : "100mm", "code" : "100MM" }, { "name" : "Type A", "code" : "TYPE A" }, { "name" : "Type B", "code" : "TYPE B" }, { "name" : "Type C", "code" : "TYPE C" }, { "name" : "Type D", "code" : "TYPE D" }, { "name" : "16mm", "code" : "16MM" } ] }, "defaultValue" : null, "description" : "{\"value\":\"Class specification for the water service connection pipe indicating pressure or structural class.\",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "DATA_SOURCE", "type" : "esriFieldTypeString", "alias" : "Data Source", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "isViewOverride" : 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, "description" : "{\"value\":\"Source type of the data, e.g., sketch, historical records, aerial image, or field survey.\",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "CONDUIT", "type" : "esriFieldTypeString", "alias" : "Conduit Presence", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : { "type" : "codedValue", "name" : "YES_NO_ONLY", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Yes", "code" : "YES" }, { "name" : "No", "code" : "NO" } ] }, "defaultValue" : null, "description" : "{\"value\":\"Indicates whether a conduit is present for the water service connection (Yes or No).\",\"fieldValueType\":\"binary\"}" }, { "name" : "WATER_SRV_CONNECTN_USE", "type" : "esriFieldTypeString", "alias" : "Connection Use", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : { "type" : "codedValue", "name" : "WATER_SRV_CONNECTN_USE", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Fire Service", "code" : "SERVICE-FIRE" }, { "name" : "Domestic Service", "code" : "SERVICE-DOMESTIC" } ] }, "defaultValue" : null, "description" : "{\"value\":\"Use type of the water service connection, either for fire service or domestic service.\",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "WATER_CATEGORY", "type" : "esriFieldTypeString", "alias" : "Water Category", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : { "type" : "codedValue", "name" : "WATER_CATEGORY", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Potable", "code" : "POTABLE" }, { "name" : "Potable Wtr in purple A+ pipes", "code" : "NON-DRINKING" }, { "name" : "Rec water pipes-class A water", "code" : "RECYCLED A" }, { "name" : "Rec water below class A", "code" : "RECYCLED" } ] }, "defaultValue" : null, "description" : "{\"value\":\"Category of water, such as potable, non-drinking potable, or recycled water.\",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "WATER_PIPE_LINING", "type" : "esriFieldTypeString", "alias" : "Pipe Lining", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : { "type" : "codedValue", "name" : "WATER_PIPE_LINING", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Fusion Bonded Coated", "code" : "FBC" }, { "name" : "Cement Lined - Normal", "code" : "CL" }, { "name" : "Cement Ln - Sulphate Resistant", "code" : "CL_SR" }, { "name" : "Cement Ln - Calcium Aluminate", "code" : "CL_AC" }, { "name" : "Plasticesed PVC", "code" : "PVC" }, { "name" : "Fusion Bonded Epoxy", "code" : "FBE" }, { "name" : "Urethyne", "code" : "URE" }, { "name" : "Unlined", "code" : "UNLINED" }, { "name" : "TBA", "code" : "TBA" } ] }, "defaultValue" : null, "description" : "{\"value\":\"Type of internal lining on the water pipe, e.g., cement lined, fusion bonded epoxy, or unlined.\",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "RELINING_DATE", "type" : "esriFieldTypeDate", "alias" : "Relining Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Date when the pipe was last relined or rehabilitated.\",\"fieldValueType\":\"dateAndTime\"}", "precision" : 1 }, { "name" : "RELINING_MATERIAL", "type" : "esriFieldTypeString", "alias" : "Relining Material", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "isViewOverride" : 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, "description" : "{\"value\":\"Material used in the relining process such as concrete, cured in-place pipe, or glass reinforced plastic.\",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "RELINING_LENGTH_M", "type" : "esriFieldTypeDouble", "alias" : "Relining Length (m)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Length of the relined section of pipe in meters.\",\"fieldValueType\":\"measurement\"}" }, { "name" : "RELINING_INTERNAL_DIAMETER_MM", "type" : "esriFieldTypeDouble", "alias" : "Relining Internal Diameter (mm)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Internal diameter of the relined pipe section in millimeters.\",\"fieldValueType\":\"measurement\"}" }, { "name" : "WATER_PIPE_PROTECTION", "type" : "esriFieldTypeString", "alias" : "Pipe Protection", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : { "type" : "codedValue", "name" : "WATER_PIPE_PROTECTION", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "TBA", "code" : "TBA" }, { "name" : "Fusion Bonded Coated", "code" : "FBC" }, { "name" : "Fusion Bonded Epoxy", "code" : "FBE" }, { "name" : "Fusion Bonded Polyethelene", "code" : "FBPE" }, { "name" : "Plastic Wrapped", "code" : "PLASTIC WRAPPED" }, { "name" : "Tape Wrapped", "code" : "TAPE WRAPPED" }, { "name" : "Concrete Encased", "code" : "CONCRETE ENCASED" }, { "name" : "Cathodic", "code" : "CATHODIC" }, { "name" : "Uncoated", "code" : "UNCOATED" }, { "name" : "PCRETE", "code" : "PC" }, { "name" : "PE Sleeved", "code" : "PS" }, { "name" : "Zinc-Aluminium Alloy Coating", "code" : "ZINC-ALUMINIUM ALLOY" }, { "name" : "Galvanised or Zinc Painted", "code" : "ZINC" }, { "name" : "Epoxy Paint or Coating", "code" : "EPOXY" } ] }, "defaultValue" : null, "description" : "{\"value\":\"Type of external protection on the water pipe, such as fusion bonded coating or concrete encasement.\",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "DIAMETER_MM", "type" : "esriFieldTypeDouble", "alias" : "Diameter (mm)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Diameter of the water service connection pipe in millimeters.\",\"fieldValueType\":\"measurement\"}" }, { "name" : "LENGTH_M", "type" : "esriFieldTypeDouble", "alias" : "Length (m)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Length of the water service connection pipe in meters.\",\"fieldValueType\":\"measurement\"}" } ], "indexes" : [ { "name" : "PK__WATER_SE__F4B70D85EF40D97F", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_935.WATER_SERVICE_CONNECTION_WATER_SERVICE_CONNECTION_Shape_sidx", "fields" : "SHAPE", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "I18SAPOBJECTID", "fields" : "SAPOBJECTID", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "WATER_CATEGORY_Index", "fields" : "WATER_CATEGORY", "isAscending" : true, "isUnique" : false, "description" : "WATER_CATEGORY_Index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [ { "id" : "POTABLE", "name" : "Potable", "domains" : { "ASSET_LEVEL_ACCURACY" : {"type" : "inherited"}, "ASSET_POSITIONAL_ACCURACY" : {"type" : "inherited"}, "GIS_ACQUISITION_METHOD" : {"type" : "inherited"}, "GIS_ASSET_FUNDING_BASIS" : {"type" : "inherited"}, "GIS_CUSTODIAN" : {"type" : "inherited"}, "GIS_OWNER" : {"type" : "inherited"}, "WATER_SRV_CONNECTN_MATERIAL" : {"type" : "inherited"}, "WATER_SRV_CONNECTN_CLASS" : {"type" : "inherited"}, "DATA_SOURCE" : {"type" : "inherited"}, "CONDUIT" : {"type" : "inherited"}, "WATER_SRV_CONNECTN_USE" : {"type" : "inherited"}, "WATER_CATEGORY" : {"type" : "inherited"}, "WATER_PIPE_LINING" : {"type" : "inherited"}, "RELINING_MATERIAL" : {"type" : "inherited"}, "WATER_PIPE_PROTECTION" : {"type" : "inherited"} }, "templates" : [ { "name" : "POTABLE", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "LENGTH_M" : null, "DIAMETER_MM" : null, "SAPOBJECTID" : null, "CLASS" : "WATER_SRV_CONNECTN", "GIS_USER_STATUS" : null, "OBJECT_TYPE" : "WACN", "GIS_SYSTEM_STATUS" : 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" : null, "FUNCTIONAL_LOC" : null, "SUPERORD_EQUIP" : null, "GIS_CUSTODIAN" : null, "GIS_DESCRIPTION" : null, "SORT_FIELD" : null, "GIS_OWNER" : null, "RE_ENRICH" : null, "SYNCERRORDESC" : null, "SYNCDATE" : null, "GIS_EQUIPMENT_CATEGORY" : "W", "GIS_ACQUISITION_PROJECT" : null, "WATER_SRV_CONNECTN_MATERIAL" : null, "WATER_SRV_CONNECTN_CLASS" : null, "SYNCSTATUS" : null, "CREATED_USER" : null, "CREATED_DATE" : null, "LAST_EDITED_USER" : null, "LAST_EDITED_DATE" : null, "DATA_SOURCE" : null, "CONDUIT" : null, "WATER_SRV_CONNECTN_USE" : null, "WATER_CATEGORY" : "POTABLE", "WATER_PIPE_LINING" : null, "RELINING_DATE" : null, "RELINING_MATERIAL" : null, "RELINING_LENGTH_M" : null, "RELINING_INTERNAL_DIAMETER_MM" : null, "WATER_PIPE_PROTECTION" : null, "FROM_SAPID" : null, "TO_SAPID" : null } } } ] }, { "id" : "RECYCLED A+", "name" : "RECYCLED A+; RECYCLED B; RECYCLED C", "domains" : { "ASSET_LEVEL_ACCURACY" : {"type" : "inherited"}, "ASSET_POSITIONAL_ACCURACY" : {"type" : "inherited"}, "GIS_ACQUISITION_METHOD" : {"type" : "inherited"}, "GIS_ASSET_FUNDING_BASIS" : {"type" : "inherited"}, "GIS_CUSTODIAN" : {"type" : "inherited"}, "GIS_OWNER" : {"type" : "inherited"}, "WATER_SRV_CONNECTN_MATERIAL" : {"type" : "inherited"}, "WATER_SRV_CONNECTN_CLASS" : {"type" : "inherited"}, "DATA_SOURCE" : {"type" : "inherited"}, "CONDUIT" : {"type" : "inherited"}, "WATER_SRV_CONNECTN_USE" : {"type" : "inherited"}, "WATER_CATEGORY" : {"type" : "inherited"}, "WATER_PIPE_LINING" : {"type" : "inherited"}, "RELINING_MATERIAL" : {"type" : "inherited"}, "WATER_PIPE_PROTECTION" : {"type" : "inherited"} }, "templates" : [ { "name" : "RECYCLED A+", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "LENGTH_M" : null, "DIAMETER_MM" : null, "SAPOBJECTID" : null, "CLASS" : "WATER_SRV_CONNECTN", "GIS_USER_STATUS" : null, "OBJECT_TYPE" : "WACN", "GIS_SYSTEM_STATUS" : 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" : null, "FUNCTIONAL_LOC" : null, "SUPERORD_EQUIP" : null, "GIS_CUSTODIAN" : null, "GIS_DESCRIPTION" : null, "SORT_FIELD" : null, "GIS_OWNER" : null, "RE_ENRICH" : null, "SYNCERRORDESC" : null, "SYNCDATE" : null, "GIS_EQUIPMENT_CATEGORY" : "W", "GIS_ACQUISITION_PROJECT" : null, "WATER_SRV_CONNECTN_MATERIAL" : null, "WATER_SRV_CONNECTN_CLASS" : null, "SYNCSTATUS" : null, "CREATED_USER" : null, "CREATED_DATE" : null, "LAST_EDITED_USER" : null, "LAST_EDITED_DATE" : null, "DATA_SOURCE" : null, "CONDUIT" : null, "WATER_SRV_CONNECTN_USE" : null, "WATER_CATEGORY" : "RECYCLED A+", "WATER_PIPE_LINING" : null, "RELINING_DATE" : null, "RELINING_MATERIAL" : null, "RELINING_LENGTH_M" : null, "RELINING_INTERNAL_DIAMETER_MM" : null, "WATER_PIPE_PROTECTION" : null, "FROM_SAPID" : null, "TO_SAPID" : null } } } ] }, { "id" : "RECYCLED B", "name" : "RECYCLED A+; RECYCLED B; RECYCLED C", "domains" : { "ASSET_LEVEL_ACCURACY" : {"type" : "inherited"}, "ASSET_POSITIONAL_ACCURACY" : {"type" : "inherited"}, "GIS_ACQUISITION_METHOD" : {"type" : "inherited"}, "GIS_ASSET_FUNDING_BASIS" : {"type" : "inherited"}, "GIS_CUSTODIAN" : {"type" : "inherited"}, "GIS_OWNER" : {"type" : "inherited"}, "WATER_SRV_CONNECTN_MATERIAL" : {"type" : "inherited"}, "WATER_SRV_CONNECTN_CLASS" : {"type" : "inherited"}, "DATA_SOURCE" : {"type" : "inherited"}, "CONDUIT" : {"type" : "inherited"}, "WATER_SRV_CONNECTN_USE" : {"type" : "inherited"}, "WATER_CATEGORY" : {"type" : "inherited"}, "WATER_PIPE_LINING" : {"type" : "inherited"}, "RELINING_MATERIAL" : {"type" : "inherited"}, "WATER_PIPE_PROTECTION" : {"type" : "inherited"} }, "templates" : [ { "name" : "RECYCLED B", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "LENGTH_M" : null, "DIAMETER_MM" : null, "SAPOBJECTID" : null, "CLASS" : "WATER_SRV_CONNECTN", "GIS_USER_STATUS" : null, "OBJECT_TYPE" : "WACN", "GIS_SYSTEM_STATUS" : 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" : null, "FUNCTIONAL_LOC" : null, "SUPERORD_EQUIP" : null, "GIS_CUSTODIAN" : null, "GIS_DESCRIPTION" : null, "SORT_FIELD" : null, "GIS_OWNER" : null, "RE_ENRICH" : null, "SYNCERRORDESC" : null, "SYNCDATE" : null, "GIS_EQUIPMENT_CATEGORY" : "W", "GIS_ACQUISITION_PROJECT" : null, "WATER_SRV_CONNECTN_MATERIAL" : null, "WATER_SRV_CONNECTN_CLASS" : null, "SYNCSTATUS" : null, "CREATED_USER" : null, "CREATED_DATE" : null, "LAST_EDITED_USER" : null, "LAST_EDITED_DATE" : null, "DATA_SOURCE" : null, "CONDUIT" : null, "WATER_SRV_CONNECTN_USE" : null, "WATER_CATEGORY" : "RECYCLED B", "WATER_PIPE_LINING" : null, "RELINING_DATE" : null, "RELINING_MATERIAL" : null, "RELINING_LENGTH_M" : null, "RELINING_INTERNAL_DIAMETER_MM" : null, "WATER_PIPE_PROTECTION" : null, "FROM_SAPID" : null, "TO_SAPID" : null } } } ] }, { "id" : "RECYCLED C", "name" : "RECYCLED A+; RECYCLED B; RECYCLED C", "domains" : { "ASSET_LEVEL_ACCURACY" : {"type" : "inherited"}, "ASSET_POSITIONAL_ACCURACY" : {"type" : "inherited"}, "GIS_ACQUISITION_METHOD" : {"type" : "inherited"}, "GIS_ASSET_FUNDING_BASIS" : {"type" : "inherited"}, "GIS_CUSTODIAN" : {"type" : "inherited"}, "GIS_OWNER" : {"type" : "inherited"}, "WATER_SRV_CONNECTN_MATERIAL" : {"type" : "inherited"}, "WATER_SRV_CONNECTN_CLASS" : {"type" : "inherited"}, "DATA_SOURCE" : {"type" : "inherited"}, "CONDUIT" : {"type" : "inherited"}, "WATER_SRV_CONNECTN_USE" : {"type" : "inherited"}, "WATER_CATEGORY" : {"type" : "inherited"}, "WATER_PIPE_LINING" : {"type" : "inherited"}, "RELINING_MATERIAL" : {"type" : "inherited"}, "WATER_PIPE_PROTECTION" : {"type" : "inherited"} }, "templates" : [ { "name" : "RECYCLED C", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "LENGTH_M" : null, "DIAMETER_MM" : null, "SAPOBJECTID" : null, "CLASS" : "WATER_SRV_CONNECTN", "GIS_USER_STATUS" : null, "OBJECT_TYPE" : "WACN", "GIS_SYSTEM_STATUS" : 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" : null, "FUNCTIONAL_LOC" : null, "SUPERORD_EQUIP" : null, "GIS_CUSTODIAN" : null, "GIS_DESCRIPTION" : null, "SORT_FIELD" : null, "GIS_OWNER" : null, "RE_ENRICH" : null, "SYNCERRORDESC" : null, "SYNCDATE" : null, "GIS_EQUIPMENT_CATEGORY" : "W", "GIS_ACQUISITION_PROJECT" : null, "WATER_SRV_CONNECTN_MATERIAL" : null, "WATER_SRV_CONNECTN_CLASS" : null, "SYNCSTATUS" : null, "CREATED_USER" : null, "CREATED_DATE" : null, "LAST_EDITED_USER" : null, "LAST_EDITED_DATE" : null, "DATA_SOURCE" : null, "CONDUIT" : null, "WATER_SRV_CONNECTN_USE" : null, "WATER_CATEGORY" : "RECYCLED C", "WATER_PIPE_LINING" : null, "RELINING_DATE" : null, "RELINING_MATERIAL" : null, "RELINING_LENGTH_M" : null, "RELINING_INTERNAL_DIAMETER_MM" : null, "WATER_PIPE_PROTECTION" : null, "FROM_SAPID" : null, "TO_SAPID" : null } } } ] } ], "templates" : [], "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" }