{ "layers": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 0, "name": "Water Valve", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 2500, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": {"editDateField": "ACTION_DATE"}, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "WaterValveMaintFieldHistory", "relatedTableId": 4, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GIS_TAG", "composite": true, "catalogID": "{5C958575-A1BC-4D31-8390-C741229203C1}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "extent": { "xmin": 6037570.458926946, "ymin": 2154258.155062154, "xmax": 6084946.851931065, "ymax": 2206636.2118789256, "spatialReference": { "wkid": 102646, "latestWkid": 2230, "xyTolerance": 2.56000000238419E-4, "zTolerance": 2, "mTolerance": 0.001, "falseX": -118608900, "falseY": -91259500, "xyUnits": 3.597970630767777E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102646, "latestWkid": 2230, "xyTolerance": 2.56000000238419E-4, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -1.18608899999975E8, "falseY": -9.12594999999041E7, "xyUnits": 31249.999970896202, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "61c5995d63389b5780efdbf198b1ecd6", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA8AAAAPCAYAAAA71pVKAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABGklEQVQoka2SwS4DURSGvzu3SitBkFBsuvAgpCsWbCxkOniUPkrbGSsLmhCJCA/ShY22Q1IpibazmLnSkZZxZ5oK//ImX853/3NS/CGpf4aVwGxsY4gsgVQYvgD5jr1yD0Ilw4fNZaS7g5etcbb4Ono/eVjAdI+Qj5dUN9oxsBIY7i5OrqLJlPMdoILZOgZVHRp8wcVmAS9zMfaTU/0a1tMWNnc/tTMR1biU8x2sxqyurWTAJAmk0mHhGxPBxqB9bbLoY7bnOF16SwQPXuYJul0d3szdUnetsNWkTHt7OOu2DpdEgOVef64jfR4xGExMe/v46ur7oUSPxF59pqRs6q0CxcZMWGLYRa+Hszbabzw8NICbRPWx8C/yAZX0YBG1oJ/vAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 11, "height": 11, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "GIS_TAG", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "MAINT_AREA", "type": "esriFieldTypeString", "alias": "MAINT_AREA", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "MAINT_AREA" }, { "name": "ACTION_DATE", "type": "esriFieldTypeDate", "alias": "ACTION_DATE", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ACTION_DATE" }, { "name": "GIS_TAG", "type": "esriFieldTypeString", "alias": "Valve ID", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "GIS_TAG" }, { "name": "OWNER", "type": "esriFieldTypeString", "alias": "Agency", "domain": { "type": "codedValue", "name": "WaterAgency", "description": "Water System Agency", "codedValues": [ { "name": "Irvine Ranch Water District", "code": "IRWD" }, { "name": "Laguna Beach Water", "code": "LBW" }, { "name": "Mesa Consolidated Water District", "code": "MCWD" }, { "name": "Metropolitan Water District", "code": "MWD" }, { "name": "Newport Beach", "code": "NB" }, { "name": "Orange County", "code": "OC" }, { "name": "Santa Ana Heights Water", "code": "SAHW" }, { "name": "Unknown", "code": "UNK" }, { "name": "Private", "code": "PVT" }, { "name": "OTHER", "code": "OTH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "OWNER" }, { "name": "VALVE_FUNCTION", "type": "esriFieldTypeString", "alias": "Valve Function", "domain": { "type": "codedValue", "name": "dmnFunction", "description": "Function of the Valve", "codedValues": [ { "name": "Distribution Valve", "code": "DV" }, { "name": "Hydrant Valve", "code": "HV" }, { "name": "Domestic Service", "code": "DS" }, { "name": "Fire Service", "code": "FS" }, { "name": "Pressure Regulation", "code": "PRV" }, { "name": "Air Valve", "code": "AV" }, { "name": "Interconnect", "code": "IC" }, { "name": "Check Valve", "code": "CV" }, { "name": "Pump Station/Plant", "code": "PLNT" }, { "name": "Blow Off Valve", "code": "BO" }, { "name": "Zone Valve", "code": "ZONE" }, { "name": "Reclaimed Valve", "code": "RV" }, { "name": "Tapping Valve", "code": "TV" }, { "name": "Transmission Valve", "code": "TRAN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "VALVE_FUNCTION" }, { "name": "VALVE_TYPE", "type": "esriFieldTypeString", "alias": "Valve Type", "domain": { "type": "codedValue", "name": "WaterValveType", "description": "Water System Valve Type", "codedValues": [ { "name": "Butterfly Valve", "code": "BFV" }, { "name": "Gate Valve", "code": "GV" }, { "name": "Surge Valve", "code": "SV" }, { "name": "Plug Valve", "code": "PV" }, { "name": "Ball Valve", "code": "BALL" }, { "name": "Unknown", "code": "UNK" }, { "name": "Gate Valve By-Pass", "code": "GVBP" }, { "name": "Resilient Wedge Gate Valve", "code": "RWGV" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "VALVE_TYPE" }, { "name": "HYDRANT_VALVE", "type": "esriFieldTypeString", "alias": "Hydrant Valve", "domain": { "type": "codedValue", "name": "Yes_No", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "Not Available", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "HYDRANT_VALVE" }, { "name": "VALVE_SIZE", "type": "esriFieldTypeInteger", "alias": "Valve Size", "domain": { "type": "codedValue", "name": "Water System Diameter", "description": "Water System Diameters", "codedValues": [ { "name": "0 Inch", "code": 0 }, { "name": "1 Inch", "code": 1 }, { "name": "2 Inch", "code": 2 }, { "name": "3 Inch", "code": 3 }, { "name": "4 Inch", "code": 4 }, { "name": "6 Inch", "code": 6 }, { "name": "8 Inch", "code": 8 }, { "name": "10 Inch", "code": 10 }, { "name": "12 Inch", "code": 12 }, { "name": "14 Inch", "code": 14 }, { "name": "16 Inch", "code": 16 }, { "name": "18 Inch", "code": 18 }, { "name": "20 Inch", "code": 20 }, { "name": "24 Inch", "code": 24 }, { "name": "27 Inch", "code": 27 }, { "name": "30 Inch", "code": 30 }, { "name": "33 Inch", "code": 33 }, { "name": "36 Inch", "code": 36 }, { "name": "42 Inch", "code": 42 }, { "name": "48 Inch", "code": 48 }, { "name": "54 Inch", "code": 54 }, { "name": "60 Inch", "code": 60 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "VALVE_SIZE" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "Date Install/Replace", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_DATE" }, { "name": "CURRENT_POSITION", "type": "esriFieldTypeString", "alias": "Current Position", "domain": { "type": "codedValue", "name": "dmnCurrentPosition", "description": "Current Position of the Valve", "codedValues": [ { "name": "Open", "code": "OPN" }, { "name": "Closed", "code": "CLS" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "CURRENT_POSITION" }, { "name": "ABANDONED", "type": "esriFieldTypeString", "alias": "Abandoned?", "domain": { "type": "codedValue", "name": "Yes_No", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "Not Available", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "Abandoned" }, { "name": "NORMAL_CLOSED", "type": "esriFieldTypeString", "alias": "Normally Closed", "domain": { "type": "codedValue", "name": "Yes_No", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "Not Available", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "NORMAL_CLOSED" }, { "name": "TURNS_CLOSE", "type": "esriFieldTypeString", "alias": "Turns to Close", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "TURNS_CLOSE" }, { "name": "DEPTH_NUT", "type": "esriFieldTypeSmallInteger", "alias": "Depth", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DEPTH_NUT" }, { "name": "OPERATION_STATUS", "type": "esriFieldTypeString", "alias": "Operational Status", "domain": { "type": "codedValue", "name": "WaterValveStatus", "description": "Status of Water Valve", "codedValues": [ { "name": "OK", "code": "OK" }, { "name": "Broken", "code": "BRK" }, { "name": "Packing Leak", "code": "PCLK" }, { "name": "Rounded Nut", "code": "RN" }, { "name": "Insufficient Turns", "code": "INST" }, { "name": "Unable to Locate", "code": "UTL" }, { "name": "Abandoned", "code": "ABAN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "OPERATION_STATUS" }, { "name": "VALVE_ACTIVITY", "type": "esriFieldTypeString", "alias": "Activity", "domain": { "type": "codedValue", "name": "WaterValveActivity", "description": "Field Activity", "codedValues": [ { "name": "Exercise Valve", "code": "EXE" }, { "name": "Update Info", "code": "UPDT" }, { "name": "Installation", "code": "INST" }, { "name": "Repair/Replacement", "code": "RPR" }, { "name": "Remove/Abandon", "code": "ABAN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "VALVE_ACTIVITY" }, { "name": "CREW_UPDATE_BY", "type": "esriFieldTypeString", "alias": "Crew Update", "domain": { "type": "codedValue", "name": "ValveCrew", "description": "List of crew turning valves", "codedValues": [ { "name": "asanchez", "code": "asanchez" }, { "name": "dhill", "code": "dhill" }, { "name": "gpichardo", "code": "gpichardo" }, { "name": "javina", "code": "javina" }, { "name": "jcarranza", "code": "jcarranza" }, { "name": "mcurry", "code": "mcurry" }, { "name": "mmeadow", "code": "mmeadow" }, { "name": "mosullivan", "code": "mosullivan" }, { "name": "rguadarrama", "code": "rguadarrama" }, { "name": "swebber", "code": "swebber" }, { "name": "twilliams ", "code": "twilliams " } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "CREW_UPDATE_BY" }, { "name": "FIELD_COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FIELD_COMMENTS" }, { "name": "MAINT_DATE", "type": "esriFieldTypeDate", "alias": "MAINT_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "MAINT_DATE" }, { "name": "CHECK_VALVE", "type": "esriFieldTypeString", "alias": "Check Valve", "domain": { "type": "codedValue", "name": "YES_NO_FULL", "description": "YES and NO full.", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "CHECK_VALVE" }, { "name": "CHECK_VALVE_TYPE", "type": "esriFieldTypeString", "alias": "Check Valve Type", "domain": { "type": "codedValue", "name": "WaterCheckVlvType", "description": "Type of Check Valve", "codedValues": [ { "name": "AVK", "code": "AVK" }, { "name": "Clow", "code": "Clow" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "CHECK_VALVE_TYPE" }, { "name": "DATE_EXERCISED", "type": "esriFieldTypeDate", "alias": "Date Exercised", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATE_EXERCISED" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R3758_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_313102_GIS_T", "fields": "GIS_TAG", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S1462_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Water Valve", "description": "", "prototype": { "attributes": { "CHECK_VALVE_TYPE": null, "MAINT_AREA": null, "DATE_EXERCISED": null, "GIS_TAG": null, "OWNER": null, "VALVE_FUNCTION": null, "VALVE_TYPE": null, "HYDRANT_VALVE": null, "VALVE_SIZE": null, "INSTALL_DATE": null, "CURRENT_POSITION": null, "ABANDONED": null, "NORMAL_CLOSED": null, "TURNS_CLOSE": null, "DEPTH_NUT": null, "OPERATION_STATUS": null, "VALVE_ACTIVITY": null, "CREW_UPDATE_BY": null, "FIELD_COMMENTS": null, "MAINT_DATE": null, "CHECK_VALVE": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 1, "name": "Hydrant", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 2500, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": {"editDateField": "ACTION_DATE"}, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 1, "name": "WaterHydrantMaintFieldHistory", "relatedTableId": 5, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GIS_TAG", "composite": true, "catalogID": "{1CACE595-47DA-4873-8E00-90E3728D3004}" }, { "id": 2, "name": "WaterHydrantFieldInspect", "relatedTableId": 8, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GIS_TAG", "composite": true, "catalogID": "{2BDAA51F-BEB8-4E7E-8947-FF57D0847CC8}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "extent": { "xmin": 6037572.99494122, "ymin": 2154272.204234138, "xmax": 6084874.930848971, "ymax": 2206627.2858754843, "spatialReference": { "wkid": 102646, "latestWkid": 2230, "xyTolerance": 2.56000000238419E-4, "zTolerance": 2, "mTolerance": 0.001, "falseX": -118608900, "falseY": -91259500, "xyUnits": 3.597970630767777E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102646, "latestWkid": 2230, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -118608900, "falseY": -91259500, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "8910019e2d04f48e459db13957a73723", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABKElEQVQ4jbWRMUsDQRCFv03WylYl2WBhqdhZiiI22ljZJVmI/iwLDSymESsbK5FYWIlNMGVMkb1DbQXRu6zcEUOSS7xg8MHB3mPn23kzkhkl/wew4yTL/ibOLcT/TjQ5zz9NByjabYTNIzM3nKnX2NP+OtpqQurUVHsyoGz3EbQxhfqQb3INoIHuHFC0DEJk/1LlJUcYOIxqTgxsCldxJ2CSgDDcwqgLUpV5pOSt/cxE9n3nvtKLe3HK9hAYAfxRcuCcnariyFsk4C0J6PKMtqu/DjHSZ3eXjrpMAmrqgVLnmEqrRXXlY2xx9ECIx60IxkWAeWV4txpt7xOdaLuHQ1BT14P2MOBERJs4pWg3epMOY1+IObLZO6pL/mhT47cQxYHoS9XMa/wG68tkHLfaadsAAAAASUVORK5CYII=", "contentType": "image/png", "width": 12, "height": 12, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "HYDRANTID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "GIS_TAG", "type": "esriFieldTypeString", "alias": "GIS ID", "domain": null, "editable": false, "nullable": true, "length": 15, "defaultValue": null, "modelName": "GIS_TAG" }, { "name": "HYDRANTID", "type": "esriFieldTypeString", "alias": "Hydrant Number", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "HYDRANTID" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "Manufacturer", "domain": { "type": "codedValue", "name": "dmnHydManufacturer", "description": "Manufacturer of the Hydrant", "codedValues": [ { "name": "Jones A", "code": "Jones A" }, { "name": "LB Iron Works", "code": "LB Iron Works" }, { "name": "Greenberg", "code": "Greenberg" }, { "name": "Mueller", "code": "Mueller" }, { "name": "Corey", "code": "Corey" }, { "name": "American", "code": "American" }, { "name": "Dresser", "code": "Dresser" }, { "name": "Pohaten", "code": "Pohaten" }, { "name": "Pacific States", "code": "Pacific States" }, { "name": "Kennedy", "code": "Kennedy" }, { "name": "Jones B", "code": "Jones B" }, { "name": "Jones C", "code": "Jones C" }, { "name": "Iowa", "code": "Iowa" }, { "name": "Rensselaer", "code": "Rensselaer" }, { "name": "AVK", "code": "AVK" }, { "name": "AVK-A", "code": "AVK-A" }, { "name": "AVK-B", "code": "AVK-B" }, { "name": "Jones", "code": "Jones" }, { "name": "Rich", "code": "Rich" }, { "name": "Clow A", "code": "Clow A" }, { "name": "Clow B", "code": "Clow B" }, { "name": "Jones (Smart)", "code": "Jones (Smart)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "BARRELTYPE", "type": "esriFieldTypeString", "alias": "Barrel Type", "domain": { "type": "codedValue", "name": "dmnHydrantBarrelType", "description": "Barrel Type of the Hydrant", "codedValues": [ { "name": "Wet Barrel", "code": "W" }, { "name": "Dry Barrel", "code": "D" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "BARRELTYPE" }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Date Install/Replace", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALLDATE" }, { "name": "STATICPSI", "type": "esriFieldTypeSmallInteger", "alias": "Static PSI", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "STATICPSI" }, { "name": "PORTS2IN", "type": "esriFieldTypeSmallInteger", "alias": "2.5 Inch Outlets", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PORTS2IN" }, { "name": "PORTS4IN", "type": "esriFieldTypeSmallInteger", "alias": "4 Inch Outlets", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PORTS4IN" }, { "name": "FRESHLYPAINTED", "type": "esriFieldTypeString", "alias": "Freshly Painted", "domain": { "type": "codedValue", "name": "YES_NO_FULL", "description": "YES and NO full.", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "FRESHLYPAINTED" }, { "name": "DATEPAINTED", "type": "esriFieldTypeDate", "alias": "Date Last Painted", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATEPAINTED" }, { "name": "INSERVICE", "type": "esriFieldTypeString", "alias": "In Service", "domain": { "type": "codedValue", "name": "YES_NO_FULL", "description": "YES and NO full.", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "INSERVICE" }, { "name": "OPERATIONCOMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "OPERATIONCOMMENTS" }, { "name": "CREW_UPDATE_BY", "type": "esriFieldTypeString", "alias": "Crew Update", "domain": { "type": "codedValue", "name": "ValveCrew", "description": "List of crew turning valves", "codedValues": [ { "name": "asanchez", "code": "asanchez" }, { "name": "dhill", "code": "dhill" }, { "name": "gpichardo", "code": "gpichardo" }, { "name": "javina", "code": "javina" }, { "name": "jcarranza", "code": "jcarranza" }, { "name": "mcurry", "code": "mcurry" }, { "name": "mmeadow", "code": "mmeadow" }, { "name": "mosullivan", "code": "mosullivan" }, { "name": "rguadarrama", "code": "rguadarrama" }, { "name": "swebber", "code": "swebber" }, { "name": "twilliams ", "code": "twilliams " } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "CREW_UPDATE_BY" }, { "name": "ACTION_DATE", "type": "esriFieldTypeDate", "alias": "Updated Date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ACTION_DATE" }, { "name": "CHECK_VALVE", "type": "esriFieldTypeString", "alias": "Check Valve", "domain": { "type": "codedValue", "name": "YES_NO_FULL", "description": "YES and NO full.", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "CHECK_VALVE" }, { "name": "CHECK_VALVE_TYPE", "type": "esriFieldTypeString", "alias": "Check Valve Type", "domain": { "type": "codedValue", "name": "WaterCheckVlvType", "description": "Type of Check Valve", "codedValues": [ { "name": "AVK", "code": "AVK" }, { "name": "Clow", "code": "Clow" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "CHECK_VALVE_TYPE" }, { "name": "HYD_MAIN_INSPECT", "type": "esriFieldTypeString", "alias": "Hydrant Maintained and Inspected?", "domain": { "type": "codedValue", "name": "NAYesNoFullText", "description": "Yes No NA full text", "codedValues": [ { "name": "NA", "code": "NA" }, { "name": "NO", "code": "NO" }, { "name": "YES", "code": "YES" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "HYD_MAIN_INSPECT" }, { "name": "HYD_FLUSH", "type": "esriFieldTypeString", "alias": "Hydrant Flushed?", "domain": { "type": "codedValue", "name": "NAYesNoFullText", "description": "Yes No NA full text", "codedValues": [ { "name": "NA", "code": "NA" }, { "name": "NO", "code": "NO" }, { "name": "YES", "code": "YES" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "HYD_FLUSH" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "R3804_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_314747_GIS_T", "fields": "GIS_TAG", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S1478_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Hydrant", "description": "", "prototype": { "attributes": { "HYD_MAIN_INSPECT": null, "HYD_FLUSH": null, "HYDRANTID": null, "MANUFACTURER": null, "BARRELTYPE": null, "INSTALLDATE": null, "STATICPSI": null, "PORTS2IN": null, "PORTS4IN": null, "FRESHLYPAINTED": null, "DATEPAINTED": null, "INSERVICE": null, "OPERATIONCOMMENTS": null, "CREW_UPDATE_BY": null, "CHECK_VALVE_TYPE": null, "CHECK_VALVE": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 2, "name": "Water Main", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 2500, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "", "copyrightText": "", "editFieldsInfo": {"editDateField": "ACTION_DATE"}, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 3, "name": "WaterLineMaintFieldHistory", "relatedTableId": 6, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "PIPE_TAG", "composite": true, "catalogID": "{BFF225F4-2AD7-4E77-A11A-FA43300510AF}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "hasMetadata": true, "extent": { "xmin": 6037390.382734776, "ymin": 2153382.254581332, "xmax": 6084954.130875081, "ymax": 2206439.900550753, "spatialReference": { "wkid": 102646, "latestWkid": 2230, "xyTolerance": 2.56000000238419E-4, "zTolerance": 2, "mTolerance": 0.001, "falseX": -118608900, "falseY": -91259500, "xyUnits": 3.597970630767777E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102646, "latestWkid": 2230, "xyTolerance": 2.56000000238419E-4, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -1.18608899999975E8, "falseY": -9.12594999999041E7, "xyUnits": 31249.999970896202, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 0, 112, 255, 255 ], "width": 0.1 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "PIPE_TAG", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "PIPE_TAG", "type": "esriFieldTypeString", "alias": "Pipe Tag", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "PIPE_TAG" }, { "name": "AGENCY_COD", "type": "esriFieldTypeString", "alias": "Agency Code", "domain": { "type": "codedValue", "name": "WaterAgency", "description": "Water System Agency", "codedValues": [ { "name": "Irvine Ranch Water District", "code": "IRWD" }, { "name": "Laguna Beach Water", "code": "LBW" }, { "name": "Mesa Consolidated Water District", "code": "MCWD" }, { "name": "Metropolitan Water District", "code": "MWD" }, { "name": "Newport Beach", "code": "NB" }, { "name": "Orange County", "code": "OC" }, { "name": "Santa Ana Heights Water", "code": "SAHW" }, { "name": "Unknown", "code": "UNK" }, { "name": "Private", "code": "PVT" }, { "name": "OTHER", "code": "OTH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "AGENCY_COD" }, { "name": "DIAMETER", "type": "esriFieldTypeInteger", "alias": "Diameter", "domain": { "type": "codedValue", "name": "Water System Diameter", "description": "Water System Diameters", "codedValues": [ { "name": "0 Inch", "code": 0 }, { "name": "1 Inch", "code": 1 }, { "name": "2 Inch", "code": 2 }, { "name": "3 Inch", "code": 3 }, { "name": "4 Inch", "code": 4 }, { "name": "6 Inch", "code": 6 }, { "name": "8 Inch", "code": 8 }, { "name": "10 Inch", "code": 10 }, { "name": "12 Inch", "code": 12 }, { "name": "14 Inch", "code": 14 }, { "name": "16 Inch", "code": 16 }, { "name": "18 Inch", "code": 18 }, { "name": "20 Inch", "code": 20 }, { "name": "24 Inch", "code": 24 }, { "name": "27 Inch", "code": 27 }, { "name": "30 Inch", "code": 30 }, { "name": "33 Inch", "code": 33 }, { "name": "36 Inch", "code": 36 }, { "name": "42 Inch", "code": 42 }, { "name": "48 Inch", "code": 48 }, { "name": "54 Inch", "code": 54 }, { "name": "60 Inch", "code": 60 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DIAMETER" }, { "name": "MATERIAL_C", "type": "esriFieldTypeString", "alias": "Material Code", "domain": { "type": "codedValue", "name": "WaterLineMaterial", "description": "Water Line Material Code", "codedValues": [ { "name": "Asbestos Cement Pipe", "code": "ACP" }, { "name": "Cast Iron Pipe", "code": "CIP" }, { "name": "Copper Pipe", "code": "CU" }, { "name": "Ductile Iron Pipe", "code": "DIP" }, { "name": "Flexible Fabric Reinforced Pipe", "code": "FFRP" }, { "name": "Gunited Steel", "code": "GS" }, { "name": "Gunited Steel", "code": "GUN" }, { "name": "High Density Polyethylene", "code": "HDPE" }, { "name": "Mortar Lined Cement Coated Steel Pipe", "code": "MLCCSP" }, { "name": "Polyvinyl Chloride (Plastic)", "code": "PVC" }, { "name": "Reinforced Concrete Steel Cylinder Pipe", "code": "RCSCP" }, { "name": "Standard Steel Pipe", "code": "SSP" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "MATERIAL_C" }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "Pipe Type", "domain": { "type": "codedValue", "name": "WaterLineType", "description": "Water Line Type", "codedValues": [ { "name": "Lateral", "code": "L" }, { "name": "Main", "code": "M" }, { "name": "Service", "code": "S" }, { "name": "Irrigation Main", "code": "I" }, { "name": "Irrigation Service", "code": "T" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "TYPE" }, { "name": "SYSTEMTYPE", "type": "esriFieldTypeString", "alias": "Water System Type", "domain": { "type": "codedValue", "name": "WaterSystemType", "description": "Domestic or Rclaimed Water System", "codedValues": [ { "name": "Domestic Water", "code": "D" }, { "name": "Reclaimed Water", "code": "R" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1, "defaultValue": "D", "modelName": "SystemType" }, { "name": "PRESSURE_C", "type": "esriFieldTypeString", "alias": "Pressure Class", "domain": { "type": "codedValue", "name": "WaterPressureCode", "description": "Water Line Pressure Code", "codedValues": [ { "name": "C150", "code": "C150" }, { "name": "C200", "code": "C200" }, { "name": "C250", "code": "C250" }, { "name": "C350", "code": "C350" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "PRESSURE_C" }, { "name": "PRESSURE_Z", "type": "esriFieldTypeString", "alias": "Pressure Zone", "domain": { "type": "codedValue", "name": "WaterPressureZone", "description": "Water Line Pressure Zone", "codedValues": [ { "name": "99", "code": "99" }, { "name": "Zone 1", "code": "1" }, { "name": "Zone 2", "code": "2" }, { "name": "Zone 2R-12", "code": "2R-12" }, { "name": "Zone 2R-16", "code": "2R-16" }, { "name": "Zone 3R-17", "code": "3R-17" }, { "name": "Zone 3R-9", "code": "3R-9" }, { "name": "Zone 3R-6", "code": "3R-6" }, { "name": "Zone 3R-14", "code": "3R-14" }, { "name": "Zone 3R-11", "code": "3R-11" }, { "name": "Zone 3", "code": "3" }, { "name": "Zone 3R-15", "code": "3R-15" }, { "name": "Zone 3R-10", "code": "3R-10" }, { "name": "Zone 3R-8", "code": "3R-8" }, { "name": "Zone 4R-7", "code": "4R-7" }, { "name": "Zone 4", "code": "4" }, { "name": "Zone5", "code": "5" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "PRESSURE_Z" }, { "name": "INSTALL_YE", "type": "esriFieldTypeDate", "alias": "Install Year", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_YE" }, { "name": "SOURCE_NAM", "type": "esriFieldTypeString", "alias": "Source", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "SOURCE_NAM" }, { "name": "SOURCE_DAT", "type": "esriFieldTypeDate", "alias": "Source Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "SOURCE_DAT" }, { "name": "ABANDONED", "type": "esriFieldTypeString", "alias": "Abandoned?", "domain": { "type": "codedValue", "name": "Yes_No", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "Not Available", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "ABANDONED" }, { "name": "ABAND_YEAR", "type": "esriFieldTypeDate", "alias": "Abandoned Year", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ABAND_YEAR" }, { "name": "RELINED_YN", "type": "esriFieldTypeString", "alias": "Relined?", "domain": { "type": "codedValue", "name": "YES_NO_FULL", "description": "YES and NO full.", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "RELINED_YN" }, { "name": "RELINE_TYP", "type": "esriFieldTypeString", "alias": "Reline Type", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "RELINE_TYP" }, { "name": "RELINE_YEA", "type": "esriFieldTypeString", "alias": "Reline Year", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "RELINE_YEA" }, { "name": "REMARKS", "type": "esriFieldTypeString", "alias": "Remarks", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "REMARKS" }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "EnabledDomain", "description": "", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "Enabled" }, { "name": "REVISED_DATE", "type": "esriFieldTypeDate", "alias": "Revised Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "REVISED_DATE" }, { "name": "ACTION_DATE", "type": "esriFieldTypeDate", "alias": "Activity Date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ACTION_DATE" }, { "name": "CREW_UPDATE_BY", "type": "esriFieldTypeString", "alias": "Crew Update", "domain": { "type": "codedValue", "name": "ValveCrew", "description": "List of crew turning valves", "codedValues": [ { "name": "asanchez", "code": "asanchez" }, { "name": "dhill", "code": "dhill" }, { "name": "gpichardo", "code": "gpichardo" }, { "name": "javina", "code": "javina" }, { "name": "jcarranza", "code": "jcarranza" }, { "name": "mcurry", "code": "mcurry" }, { "name": "mmeadow", "code": "mmeadow" }, { "name": "mosullivan", "code": "mosullivan" }, { "name": "rguadarrama", "code": "rguadarrama" }, { "name": "swebber", "code": "swebber" }, { "name": "twilliams ", "code": "twilliams " } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "CREW_UPDATE_BY" }, { "name": "PLAN_LINK", "type": "esriFieldTypeString", "alias": "Plan Link", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "PLAN_LINK" }, { "name": "PLAN_TEXT_LINK", "type": "esriFieldTypeString", "alias": "Plan Text Link", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "PLAN_TEXT_LINK" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Shape.STLength()", "required": true } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R3842_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_314789_PIPE_", "fields": "PIPE_TAG", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S1493_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Water Main", "description": "", "prototype": { "attributes": { "PLAN_TEXT_LINK": null, "PIPE_TAG": null, "AGENCY_COD": null, "DIAMETER": null, "MATERIAL_C": null, "TYPE": null, "SYSTEMTYPE": "D", "PRESSURE_C": null, "PRESSURE_Z": null, "INSTALL_YE": null, "SOURCE_NAM": null, "SOURCE_DAT": null, "ABANDONED": "N", "ABAND_YEAR": null, "RELINED_YN": null, "RELINE_TYP": null, "RELINE_YEA": null, "REMARKS": null, "ENABLED": 1, "REVISED_DATE": null, "PLAN_LINK": null, "CREW_UPDATE_BY": null } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 3, "name": "Air Vac", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 6000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": {"editDateField": "ACTION_DATE"}, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 4, "name": "WaterAirVacsMaintFieldHistory", "relatedTableId": 7, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "NODE_TAG", "composite": true, "catalogID": "{E32C6232-6377-4DC0-BE08-EAE01EB21597}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "extent": { "xmin": 6037412.221966803, "ymin": 2161849.529341221, "xmax": 6076395.782867104, "ymax": 2206235.1615745574, "spatialReference": { "wkid": 102646, "latestWkid": 2230, "xyTolerance": 2.56000000238419E-4, "zTolerance": 2, "mTolerance": 0.001, "falseX": -118608900, "falseY": -91259500, "xyUnits": 3.597970630767777E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102646, "latestWkid": 2230, "xyTolerance": 2.56000000238419E-4, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -1.18608899999975E8, "falseY": -9.12594999999041E7, "xyUnits": 31249.999970896202, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "6ad6ad592c3f5ba34f96d58e12d47bbf", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABIElEQVQ4jbWRIU8DQRBG37QLFgMJ/AQIDtmAwIBBoWvw7V1D8OcbwrV1CAySoDAoRBEogmmohCpIICEYQgrckN3QS9u7cg0NX7LJ7uzO2/lmDBPK/A8gUMMrBSJm3TmiTUNuxwN4usYLC0Rc0JAnFyvrMr4WydNkXzqjARXdROkQSnMgXpcW0KKiW+wq/RATP9rTebooNWmPNHwgZ64SOE4CuqxSkxOyFHFDSZd6PTHxhfCRmdyz4+k2MAT4o0y8U/JjZZR0jhzPaYB7fF0k/KWJVjnWmeE0CajLNb7uEOgdgbynJtsPlAcC+UwCAN7ceIr4epWoxNMNBCGU8/7wIOBQ7CSOKOuK67Tw9WNvimkuqcrjcFHpU7B2wK5MTTzGb93EXVAuekYDAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 12, "height": 12, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "NODE_TAG", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "NODE_TAG", "type": "esriFieldTypeString", "alias": "GIS Tag", "domain": null, "editable": true, "nullable": true, "length": 7, "defaultValue": null, "modelName": "node_tag" }, { "name": "AGENCY_CODE", "type": "esriFieldTypeString", "alias": "Owner Jurisdiction", "domain": { "type": "codedValue", "name": "WaterAgency", "description": "Water System Agency", "codedValues": [ { "name": "Irvine Ranch Water District", "code": "IRWD" }, { "name": "Laguna Beach Water", "code": "LBW" }, { "name": "Mesa Consolidated Water District", "code": "MCWD" }, { "name": "Metropolitan Water District", "code": "MWD" }, { "name": "Newport Beach", "code": "NB" }, { "name": "Orange County", "code": "OC" }, { "name": "Santa Ana Heights Water", "code": "SAHW" }, { "name": "Unknown", "code": "UNK" }, { "name": "Private", "code": "PVT" }, { "name": "OTHER", "code": "OTH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "agency_code" }, { "name": "ARV_MANUF", "type": "esriFieldTypeString", "alias": "Type", "domain": { "type": "codedValue", "name": "AirVacManufacturer", "description": "Manufacturer list of Air Vacs", "codedValues": [ { "name": "APCO", "code": "APCO" }, { "name": "A.R.I.", "code": "A.R.I." }, { "name": "ClaVal", "code": "ClaVal" }, { "name": "Crispin", "code": "Crispin" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "ARV_MANUF" }, { "name": "ARV_SIZE", "type": "esriFieldTypeString", "alias": "Size", "domain": { "type": "codedValue", "name": "AirVacSize", "description": "Size of AirVac", "codedValues": [ { "name": "1", "code": "1" }, { "name": "2", "code": "2" }, { "name": "3", "code": "3" }, { "name": "4", "code": "4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 5, "defaultValue": "2", "modelName": "ARV_SIZE" }, { "name": "ARV_PRESS_ZONE", "type": "esriFieldTypeString", "alias": "Pressure Zone", "domain": { "type": "codedValue", "name": "WaterPressureZone", "description": "Water Line Pressure Zone", "codedValues": [ { "name": "99", "code": "99" }, { "name": "Zone 1", "code": "1" }, { "name": "Zone 2", "code": "2" }, { "name": "Zone 2R-12", "code": "2R-12" }, { "name": "Zone 2R-16", "code": "2R-16" }, { "name": "Zone 3R-17", "code": "3R-17" }, { "name": "Zone 3R-9", "code": "3R-9" }, { "name": "Zone 3R-6", "code": "3R-6" }, { "name": "Zone 3R-14", "code": "3R-14" }, { "name": "Zone 3R-11", "code": "3R-11" }, { "name": "Zone 3", "code": "3" }, { "name": "Zone 3R-15", "code": "3R-15" }, { "name": "Zone 3R-10", "code": "3R-10" }, { "name": "Zone 3R-8", "code": "3R-8" }, { "name": "Zone 4R-7", "code": "4R-7" }, { "name": "Zone 4", "code": "4" }, { "name": "Zone5", "code": "5" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "ARV_PRESS_ZONE" }, { "name": "ARV_VLV_REPLACED", "type": "esriFieldTypeDate", "alias": "Install/Replace", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ARV_VLV_REPLACED" }, { "name": "ARV_VLV_CAN", "type": "esriFieldTypeString", "alias": "Can", "domain": { "type": "codedValue", "name": "YES_NO_FULL", "description": "YES and NO full.", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": "YES", "modelName": "ARV_VLV_CAN" }, { "name": "ARV_CAN_REPLACE", "type": "esriFieldTypeString", "alias": "Can Replaced", "domain": { "type": "codedValue", "name": "YES_NO_FULL", "description": "YES and NO full.", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "ARV_CAN_REPLACE" }, { "name": "ARV_VLV_POS", "type": "esriFieldTypeString", "alias": "Current Position", "domain": { "type": "codedValue", "name": "AirVacPosition", "description": "Open or Closed", "codedValues": [ { "name": "OPEN", "code": "OPEN" }, { "name": "CLOSED", "code": "CLOSED" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": "OPEN", "modelName": "ARV_VLV_POS" }, { "name": "ARV_VLV_DEPTH", "type": "esriFieldTypeString", "alias": "Depth to Valve", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "ARV_VLV_DEPTH" }, { "name": "ARV_VLV_CON", "type": "esriFieldTypeString", "alias": "Operating Status", "domain": { "type": "codedValue", "name": "AirVacValveCond", "description": "Condition of AirVac", "codedValues": [ { "name": "GOOD", "code": "GOOD" }, { "name": "BAD", "code": "BAD" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 15, "defaultValue": "GOOD", "modelName": "ARV_VLV_CON" }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "COMMENTS" }, { "name": "CREW_UPDATE", "type": "esriFieldTypeString", "alias": "Updated By", "domain": { "type": "codedValue", "name": "ValveCrew", "description": "List of crew turning valves", "codedValues": [ { "name": "asanchez", "code": "asanchez" }, { "name": "dhill", "code": "dhill" }, { "name": "gpichardo", "code": "gpichardo" }, { "name": "javina", "code": "javina" }, { "name": "jcarranza", "code": "jcarranza" }, { "name": "mcurry", "code": "mcurry" }, { "name": "mmeadow", "code": "mmeadow" }, { "name": "mosullivan", "code": "mosullivan" }, { "name": "rguadarrama", "code": "rguadarrama" }, { "name": "swebber", "code": "swebber" }, { "name": "twilliams ", "code": "twilliams " } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "CREW_UPDATE" }, { "name": "ACTION_DATE", "type": "esriFieldTypeDate", "alias": "Activity Date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ACTION_DATE" }, { "name": "MAINT_AREA", "type": "esriFieldTypeString", "alias": "Maintenance Area", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "MAINT_AREA" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R3866_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_315581_NODE_", "fields": "NODE_TAG", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S1501_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Air Vac", "description": "", "prototype": { "attributes": { "MAINT_AREA": null, "NODE_TAG": null, "AGENCY_CODE": null, "ARV_MANUF": null, "ARV_SIZE": "2", "ARV_PRESS_ZONE": null, "ARV_VLV_REPLACED": null, "ARV_VLV_CAN": "YES", "ARV_CAN_REPLACE": null, "ARV_VLV_POS": "OPEN", "ARV_VLV_DEPTH": null, "ARV_VLV_CON": "GOOD", "COMMENTS": null, "CREW_UPDATE": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 9, "name": "Incident Location", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "extent": { "xmin": 6042321.5684493035, "ymin": 2161615.4986026436, "xmax": 6073238.972821727, "ymax": 2181148.7751528174, "spatialReference": { "wkid": 102646, "latestWkid": 2230, "xyTolerance": 2.56000000238419E-4, "zTolerance": 2, "mTolerance": 0.001, "falseX": -118608900, "falseY": -91259500, "xyUnits": 3.597970630767777E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102646, "latestWkid": 2230, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -118608900, "falseY": -91259500, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 230, 0, 0, 255 ], "size": 12, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.6 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "QuestTicket", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "QuestTicket", "type": "esriFieldTypeString", "alias": "Quest Ticket", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "QuestTicket" }, { "name": "IncidentDate", "type": "esriFieldTypeDate", "alias": "Incident Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "IncidentDate" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "Comments" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "R7113_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S2153_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Incident Location", "description": "", "prototype": { "attributes": { "IncidentDate": null, "Comments": null, "QuestTicket": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 } ], "tables": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 4, "name": "NBGIS.GISDATA.WaterValveMaintFieldHistory", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "WaterValveMaintField", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "GIS_TAG", "composite": true, "catalogID": "{5C958575-A1BC-4D31-8390-C741229203C1}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "ACTION_DATE", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "GIS_TAG", "type": "esriFieldTypeString", "alias": "Valve ID", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "GIS_TAG" }, { "name": "OWNER", "type": "esriFieldTypeString", "alias": "Agency", "domain": { "type": "codedValue", "name": "WaterAgency", "description": "Water System Agency", "codedValues": [ { "name": "Irvine Ranch Water District", "code": "IRWD" }, { "name": "Laguna Beach Water", "code": "LBW" }, { "name": "Mesa Consolidated Water District", "code": "MCWD" }, { "name": "Metropolitan Water District", "code": "MWD" }, { "name": "Newport Beach", "code": "NB" }, { "name": "Orange County", "code": "OC" }, { "name": "Santa Ana Heights Water", "code": "SAHW" }, { "name": "Unknown", "code": "UNK" }, { "name": "Private", "code": "PVT" }, { "name": "OTHER", "code": "OTH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "OWNER" }, { "name": "VALVE_FUNCTION", "type": "esriFieldTypeString", "alias": "Valve Function", "domain": { "type": "codedValue", "name": "dmnFunction", "description": "Function of the Valve", "codedValues": [ { "name": "Distribution Valve", "code": "DV" }, { "name": "Hydrant Valve", "code": "HV" }, { "name": "Domestic Service", "code": "DS" }, { "name": "Fire Service", "code": "FS" }, { "name": "Pressure Regulation", "code": "PRV" }, { "name": "Air Valve", "code": "AV" }, { "name": "Interconnect", "code": "IC" }, { "name": "Check Valve", "code": "CV" }, { "name": "Pump Station/Plant", "code": "PLNT" }, { "name": "Blow Off Valve", "code": "BO" }, { "name": "Zone Valve", "code": "ZONE" }, { "name": "Reclaimed Valve", "code": "RV" }, { "name": "Tapping Valve", "code": "TV" }, { "name": "Transmission Valve", "code": "TRAN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "VALVE_FUNCTION" }, { "name": "VALVE_TYPE", "type": "esriFieldTypeString", "alias": "Valve Type", "domain": { "type": "codedValue", "name": "WaterValveType", "description": "Water System Valve Type", "codedValues": [ { "name": "Butterfly Valve", "code": "BFV" }, { "name": "Gate Valve", "code": "GV" }, { "name": "Surge Valve", "code": "SV" }, { "name": "Plug Valve", "code": "PV" }, { "name": "Ball Valve", "code": "BALL" }, { "name": "Unknown", "code": "UNK" }, { "name": "Gate Valve By-Pass", "code": "GVBP" }, { "name": "Resilient Wedge Gate Valve", "code": "RWGV" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "VALVE_TYPE" }, { "name": "HYDRANT_VALVE", "type": "esriFieldTypeString", "alias": "Hydrant Valve", "domain": { "type": "codedValue", "name": "Yes_No", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "Not Available", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "HYDRANT_VALVE" }, { "name": "VALVE_SIZE", "type": "esriFieldTypeInteger", "alias": "Valve Size", "domain": { "type": "codedValue", "name": "Water System Diameter", "description": "Water System Diameters", "codedValues": [ { "name": "0 Inch", "code": 0 }, { "name": "1 Inch", "code": 1 }, { "name": "2 Inch", "code": 2 }, { "name": "3 Inch", "code": 3 }, { "name": "4 Inch", "code": 4 }, { "name": "6 Inch", "code": 6 }, { "name": "8 Inch", "code": 8 }, { "name": "10 Inch", "code": 10 }, { "name": "12 Inch", "code": 12 }, { "name": "14 Inch", "code": 14 }, { "name": "16 Inch", "code": 16 }, { "name": "18 Inch", "code": 18 }, { "name": "20 Inch", "code": 20 }, { "name": "24 Inch", "code": 24 }, { "name": "27 Inch", "code": 27 }, { "name": "30 Inch", "code": 30 }, { "name": "33 Inch", "code": 33 }, { "name": "36 Inch", "code": 36 }, { "name": "42 Inch", "code": 42 }, { "name": "48 Inch", "code": 48 }, { "name": "54 Inch", "code": 54 }, { "name": "60 Inch", "code": 60 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "VALVE_SIZE" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "Date Install/Replace", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_DATE" }, { "name": "CURRENT_POSITION", "type": "esriFieldTypeString", "alias": "Current Position", "domain": { "type": "codedValue", "name": "dmnCurrentPosition", "description": "Current Position of the Valve", "codedValues": [ { "name": "Open", "code": "OPN" }, { "name": "Closed", "code": "CLS" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "CURRENT_POSITION" }, { "name": "ABANDONED", "type": "esriFieldTypeString", "alias": "Abandoned?", "domain": { "type": "codedValue", "name": "Yes_No", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "Not Available", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "Abandoned" }, { "name": "NORMAL_CLOSED", "type": "esriFieldTypeString", "alias": "Normally Closed", "domain": { "type": "codedValue", "name": "Yes_No", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "Not Available", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "NORMAL_CLOSED" }, { "name": "TURNS_CLOSE", "type": "esriFieldTypeString", "alias": "Turns to Close", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "TURNS_CLOSE" }, { "name": "DEPTH_NUT", "type": "esriFieldTypeSmallInteger", "alias": "Depth", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DEPTH_NUT" }, { "name": "OPERATION_STATUS", "type": "esriFieldTypeString", "alias": "Operational Status", "domain": { "type": "codedValue", "name": "WaterValveStatus", "description": "Status of Water Valve", "codedValues": [ { "name": "OK", "code": "OK" }, { "name": "Broken", "code": "BRK" }, { "name": "Packing Leak", "code": "PCLK" }, { "name": "Rounded Nut", "code": "RN" }, { "name": "Insufficient Turns", "code": "INST" }, { "name": "Unable to Locate", "code": "UTL" }, { "name": "Abandoned", "code": "ABAN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "OPERATION_STATUS" }, { "name": "VALVE_ACTIVITY", "type": "esriFieldTypeString", "alias": "Activity", "domain": { "type": "codedValue", "name": "WaterValveActivity", "description": "Field Activity", "codedValues": [ { "name": "Exercise Valve", "code": "EXE" }, { "name": "Update Info", "code": "UPDT" }, { "name": "Installation", "code": "INST" }, { "name": "Repair/Replacement", "code": "RPR" }, { "name": "Remove/Abandon", "code": "ABAN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "VALVE_ACTIVITY" }, { "name": "CREW_UPDATE_BY", "type": "esriFieldTypeString", "alias": "Crew Update", "domain": { "type": "codedValue", "name": "ValveCrew", "description": "List of crew turning valves", "codedValues": [ { "name": "asanchez", "code": "asanchez" }, { "name": "dhill", "code": "dhill" }, { "name": "gpichardo", "code": "gpichardo" }, { "name": "javina", "code": "javina" }, { "name": "jcarranza", "code": "jcarranza" }, { "name": "mcurry", "code": "mcurry" }, { "name": "mmeadow", "code": "mmeadow" }, { "name": "mosullivan", "code": "mosullivan" }, { "name": "rguadarrama", "code": "rguadarrama" }, { "name": "swebber", "code": "swebber" }, { "name": "twilliams ", "code": "twilliams " } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "CREW_UPDATE_BY" }, { "name": "FIELD_COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FIELD_COMMENTS" }, { "name": "ACTION_DATE", "type": "esriFieldTypeDate", "alias": "Updated Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ACTION_DATE" }, { "name": "MAINT_AREA", "type": "esriFieldTypeString", "alias": "MAINT_AREA", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "MAINT_AREA" }, { "name": "CHECK_VALVE", "type": "esriFieldTypeString", "alias": "Check Valve", "domain": { "type": "codedValue", "name": "YES_NO_FULL", "description": "YES and NO full.", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "CHECK_VALVE" }, { "name": "CHECK_VALVE_TYPE", "type": "esriFieldTypeString", "alias": "Check Valve Type", "domain": { "type": "codedValue", "name": "WaterCheckVlvType", "description": "Type of Check Valve", "codedValues": [ { "name": "AVK", "code": "AVK" }, { "name": "Clow", "code": "Clow" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "CHECK_VALVE_TYPE" }, { "name": "DATE_EXERCISED", "type": "esriFieldTypeDate", "alias": "Date Exercised", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATE_EXERCISED" } ], "indexes": [ { "name": "R3764_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_313507_GIS_T", "fields": "GIS_TAG", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "NBGIS.GISDATA.WaterValveMaintFieldHistory", "description": "", "prototype": { "attributes": { "CHECK_VALVE_TYPE": null, "DATE_EXERCISED": null, "GIS_TAG": null, "OWNER": null, "VALVE_FUNCTION": null, "VALVE_TYPE": null, "HYDRANT_VALVE": null, "VALVE_SIZE": null, "INSTALL_DATE": null, "CURRENT_POSITION": null, "ABANDONED": null, "NORMAL_CLOSED": null, "TURNS_CLOSE": null, "DEPTH_NUT": null, "OPERATION_STATUS": null, "VALVE_ACTIVITY": null, "CREW_UPDATE_BY": null, "FIELD_COMMENTS": null, "ACTION_DATE": null, "MAINT_AREA": null, "CHECK_VALVE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 5, "name": "NBGIS.GISDATA.WaterHydrantMaintFieldHistory", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 1, "name": "WaterHydrantMaintField", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "GIS_TAG", "composite": true, "catalogID": "{1CACE595-47DA-4873-8E00-90E3728D3004}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "ACTION_DATE", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "GIS_TAG", "type": "esriFieldTypeString", "alias": "GIS ID", "domain": null, "editable": false, "nullable": true, "length": 15, "defaultValue": null, "modelName": "GIS_TAG" }, { "name": "HYDRANTID", "type": "esriFieldTypeString", "alias": "Hydrant Number", "domain": null, "editable": false, "nullable": true, "length": 20, "defaultValue": null, "modelName": "HYDRANTID" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "Manufacturer", "domain": { "type": "codedValue", "name": "dmnHydManufacturer", "description": "Manufacturer of the Hydrant", "codedValues": [ { "name": "Jones A", "code": "Jones A" }, { "name": "LB Iron Works", "code": "LB Iron Works" }, { "name": "Greenberg", "code": "Greenberg" }, { "name": "Mueller", "code": "Mueller" }, { "name": "Corey", "code": "Corey" }, { "name": "American", "code": "American" }, { "name": "Dresser", "code": "Dresser" }, { "name": "Pohaten", "code": "Pohaten" }, { "name": "Pacific States", "code": "Pacific States" }, { "name": "Kennedy", "code": "Kennedy" }, { "name": "Jones B", "code": "Jones B" }, { "name": "Jones C", "code": "Jones C" }, { "name": "Iowa", "code": "Iowa" }, { "name": "Rensselaer", "code": "Rensselaer" }, { "name": "AVK", "code": "AVK" }, { "name": "AVK-A", "code": "AVK-A" }, { "name": "AVK-B", "code": "AVK-B" }, { "name": "Jones", "code": "Jones" }, { "name": "Rich", "code": "Rich" }, { "name": "Clow A", "code": "Clow A" }, { "name": "Clow B", "code": "Clow B" }, { "name": "Jones (Smart)", "code": "Jones (Smart)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": false, "nullable": true, "length": 30, "defaultValue": null, "modelName": "MANUFACTURER" }, { "name": "BARRELTYPE", "type": "esriFieldTypeString", "alias": "Barrel Type", "domain": { "type": "codedValue", "name": "dmnHydrantBarrelType", "description": "Barrel Type of the Hydrant", "codedValues": [ { "name": "Wet Barrel", "code": "W" }, { "name": "Dry Barrel", "code": "D" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": false, "nullable": true, "length": 15, "defaultValue": null, "modelName": "BARRELTYPE" }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Date Install/Replace", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALLDATE" }, { "name": "STATICPSI", "type": "esriFieldTypeSmallInteger", "alias": "Static PSI", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "STATICPSI" }, { "name": "PORTS2IN", "type": "esriFieldTypeSmallInteger", "alias": "2.5 Inch Outlets", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "PORTS2IN" }, { "name": "PORTS4IN", "type": "esriFieldTypeSmallInteger", "alias": "4 Inch Outlets", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "PORTS4IN" }, { "name": "FRESHLYPAINTED", "type": "esriFieldTypeString", "alias": "Freshly Painted", "domain": { "type": "codedValue", "name": "YES_NO_FULL", "description": "YES and NO full.", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": false, "nullable": true, "length": 10, "defaultValue": null, "modelName": "FRESHLYPAINTED" }, { "name": "DATEPAINTED", "type": "esriFieldTypeDate", "alias": "Date Last Painted", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATEPAINTED" }, { "name": "INSERVICE", "type": "esriFieldTypeString", "alias": "In Service", "domain": { "type": "codedValue", "name": "YES_NO_FULL", "description": "YES and NO full.", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": false, "nullable": true, "length": 10, "defaultValue": null, "modelName": "INSERVICE" }, { "name": "OPERATIONCOMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": false, "nullable": true, "length": 100, "defaultValue": null, "modelName": "OPERATIONCOMMENTS" }, { "name": "CREW_UPDATE_BY", "type": "esriFieldTypeString", "alias": "Crew Update", "domain": { "type": "codedValue", "name": "ValveCrew", "description": "List of crew turning valves", "codedValues": [ { "name": "asanchez", "code": "asanchez" }, { "name": "dhill", "code": "dhill" }, { "name": "gpichardo", "code": "gpichardo" }, { "name": "javina", "code": "javina" }, { "name": "jcarranza", "code": "jcarranza" }, { "name": "mcurry", "code": "mcurry" }, { "name": "mmeadow", "code": "mmeadow" }, { "name": "mosullivan", "code": "mosullivan" }, { "name": "rguadarrama", "code": "rguadarrama" }, { "name": "swebber", "code": "swebber" }, { "name": "twilliams ", "code": "twilliams " } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": false, "nullable": true, "length": 25, "defaultValue": null, "modelName": "CREW_UPDATE_BY" }, { "name": "ACTION_DATE", "type": "esriFieldTypeDate", "alias": "Updated Date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ACTION_DATE" }, { "name": "CHECK_VALVE", "type": "esriFieldTypeString", "alias": "Check Valve", "domain": { "type": "codedValue", "name": "YES_NO_FULL", "description": "YES and NO full.", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": false, "nullable": true, "length": 10, "defaultValue": null, "modelName": "CHECK_VALVE" }, { "name": "CHECK_VALVE_TYPE", "type": "esriFieldTypeString", "alias": "Check Valve Type", "domain": { "type": "codedValue", "name": "WaterCheckVlvType", "description": "Type of Check Valve", "codedValues": [ { "name": "AVK", "code": "AVK" }, { "name": "Clow", "code": "Clow" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": false, "nullable": true, "length": 20, "defaultValue": null, "modelName": "CHECK_VALVE_TYPE" }, { "name": "HYD_MAIN_INSPECT", "type": "esriFieldTypeString", "alias": "Hydrant Maintained and Inspected?", "domain": { "type": "codedValue", "name": "NAYesNoFullText", "description": "Yes No NA full text", "codedValues": [ { "name": "NA", "code": "NA" }, { "name": "NO", "code": "NO" }, { "name": "YES", "code": "YES" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "HYD_MAIN_INSPECT" }, { "name": "HYD_FLUSH", "type": "esriFieldTypeString", "alias": "Hydrant Flush?", "domain": { "type": "codedValue", "name": "NAYesNoFullText", "description": "Yes No NA full text", "codedValues": [ { "name": "NA", "code": "NA" }, { "name": "NO", "code": "NO" }, { "name": "YES", "code": "YES" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "HYD_FLUSH" } ], "indexes": [ { "name": "R3805_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_314748_GIS_T", "fields": "GIS_TAG", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "NBGIS.GISDATA.WaterHydrantMaintFieldHistory", "description": "", "prototype": { "attributes": { "HYD_MAIN_INSPECT": null, "HYD_FLUSH": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 6, "name": "NBGIS.GISDATA.WaterLineMaintFieldHistory", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 3, "name": "WaterLineMaintField", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PIPE_TAG", "composite": true, "catalogID": "{BFF225F4-2AD7-4E77-A11A-FA43300510AF}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "ACTION_DATE", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "PIPE_TAG", "type": "esriFieldTypeString", "alias": "Pipe Tag", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "PIPE_TAG" }, { "name": "AGENCY_COD", "type": "esriFieldTypeString", "alias": "Agency Code", "domain": { "type": "codedValue", "name": "WaterAgency", "description": "Water System Agency", "codedValues": [ { "name": "Irvine Ranch Water District", "code": "IRWD" }, { "name": "Laguna Beach Water", "code": "LBW" }, { "name": "Mesa Consolidated Water District", "code": "MCWD" }, { "name": "Metropolitan Water District", "code": "MWD" }, { "name": "Newport Beach", "code": "NB" }, { "name": "Orange County", "code": "OC" }, { "name": "Santa Ana Heights Water", "code": "SAHW" }, { "name": "Unknown", "code": "UNK" }, { "name": "Private", "code": "PVT" }, { "name": "OTHER", "code": "OTH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "AGENCY_COD" }, { "name": "DIAMETER", "type": "esriFieldTypeInteger", "alias": "Diameter", "domain": { "type": "codedValue", "name": "Water System Diameter", "description": "Water System Diameters", "codedValues": [ { "name": "0 Inch", "code": 0 }, { "name": "1 Inch", "code": 1 }, { "name": "2 Inch", "code": 2 }, { "name": "3 Inch", "code": 3 }, { "name": "4 Inch", "code": 4 }, { "name": "6 Inch", "code": 6 }, { "name": "8 Inch", "code": 8 }, { "name": "10 Inch", "code": 10 }, { "name": "12 Inch", "code": 12 }, { "name": "14 Inch", "code": 14 }, { "name": "16 Inch", "code": 16 }, { "name": "18 Inch", "code": 18 }, { "name": "20 Inch", "code": 20 }, { "name": "24 Inch", "code": 24 }, { "name": "27 Inch", "code": 27 }, { "name": "30 Inch", "code": 30 }, { "name": "33 Inch", "code": 33 }, { "name": "36 Inch", "code": 36 }, { "name": "42 Inch", "code": 42 }, { "name": "48 Inch", "code": 48 }, { "name": "54 Inch", "code": 54 }, { "name": "60 Inch", "code": 60 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DIAMETER" }, { "name": "MATERIAL_C", "type": "esriFieldTypeString", "alias": "Material Code", "domain": { "type": "codedValue", "name": "WaterLineMaterial", "description": "Water Line Material Code", "codedValues": [ { "name": "Asbestos Cement Pipe", "code": "ACP" }, { "name": "Cast Iron Pipe", "code": "CIP" }, { "name": "Copper Pipe", "code": "CU" }, { "name": "Ductile Iron Pipe", "code": "DIP" }, { "name": "Flexible Fabric Reinforced Pipe", "code": "FFRP" }, { "name": "Gunited Steel", "code": "GS" }, { "name": "Gunited Steel", "code": "GUN" }, { "name": "High Density Polyethylene", "code": "HDPE" }, { "name": "Mortar Lined Cement Coated Steel Pipe", "code": "MLCCSP" }, { "name": "Polyvinyl Chloride (Plastic)", "code": "PVC" }, { "name": "Reinforced Concrete Steel Cylinder Pipe", "code": "RCSCP" }, { "name": "Standard Steel Pipe", "code": "SSP" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "MATERIAL_C" }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "Pipe Type", "domain": { "type": "codedValue", "name": "WaterLineType", "description": "Water Line Type", "codedValues": [ { "name": "Lateral", "code": "L" }, { "name": "Main", "code": "M" }, { "name": "Service", "code": "S" }, { "name": "Irrigation Main", "code": "I" }, { "name": "Irrigation Service", "code": "T" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "TYPE" }, { "name": "SYSTEMTYPE", "type": "esriFieldTypeString", "alias": "Water System Type", "domain": { "type": "codedValue", "name": "WaterSystemType", "description": "Domestic or Rclaimed Water System", "codedValues": [ { "name": "Domestic Water", "code": "D" }, { "name": "Reclaimed Water", "code": "R" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1, "defaultValue": "D", "modelName": "SystemType" }, { "name": "PRESSURE_C", "type": "esriFieldTypeString", "alias": "Pressure Class", "domain": { "type": "codedValue", "name": "WaterPressureCode", "description": "Water Line Pressure Code", "codedValues": [ { "name": "C150", "code": "C150" }, { "name": "C200", "code": "C200" }, { "name": "C250", "code": "C250" }, { "name": "C350", "code": "C350" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "PRESSURE_C" }, { "name": "PRESSURE_Z", "type": "esriFieldTypeString", "alias": "Pressure Zone", "domain": { "type": "codedValue", "name": "WaterPressureZone", "description": "Water Line Pressure Zone", "codedValues": [ { "name": "99", "code": "99" }, { "name": "Zone 1", "code": "1" }, { "name": "Zone 2", "code": "2" }, { "name": "Zone 2R-12", "code": "2R-12" }, { "name": "Zone 2R-16", "code": "2R-16" }, { "name": "Zone 3R-17", "code": "3R-17" }, { "name": "Zone 3R-9", "code": "3R-9" }, { "name": "Zone 3R-6", "code": "3R-6" }, { "name": "Zone 3R-14", "code": "3R-14" }, { "name": "Zone 3R-11", "code": "3R-11" }, { "name": "Zone 3", "code": "3" }, { "name": "Zone 3R-15", "code": "3R-15" }, { "name": "Zone 3R-10", "code": "3R-10" }, { "name": "Zone 3R-8", "code": "3R-8" }, { "name": "Zone 4R-7", "code": "4R-7" }, { "name": "Zone 4", "code": "4" }, { "name": "Zone5", "code": "5" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "PRESSURE_Z" }, { "name": "INSTALL_YE", "type": "esriFieldTypeDate", "alias": "Install Year", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_YE" }, { "name": "SOURCE_NAM", "type": "esriFieldTypeString", "alias": "Source", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "SOURCE_NAM" }, { "name": "SOURCE_DAT", "type": "esriFieldTypeDate", "alias": "Source Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "SOURCE_DAT" }, { "name": "ABANDONED", "type": "esriFieldTypeString", "alias": "Abandoned?", "domain": { "type": "codedValue", "name": "Yes_No", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "Not Available", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "ABANDONED" }, { "name": "ABAND_YEAR", "type": "esriFieldTypeDate", "alias": "Abandoned Year", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ABAND_YEAR" }, { "name": "RELINED_YN", "type": "esriFieldTypeString", "alias": "Relined?", "domain": { "type": "codedValue", "name": "YES_NO_FULL", "description": "YES and NO full.", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "RELINED_YN" }, { "name": "RELINE_TYP", "type": "esriFieldTypeString", "alias": "Reline Type", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "RELINE_TYP" }, { "name": "RELINE_YEA", "type": "esriFieldTypeString", "alias": "Reline Year", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "RELINE_YEA" }, { "name": "REMARKS", "type": "esriFieldTypeString", "alias": "Remarks", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "REMARKS" }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "EnabledDomain", "description": "", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "Enabled" }, { "name": "REVISED_DATE", "type": "esriFieldTypeDate", "alias": "Revised Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "REVISED_DATE" }, { "name": "ACTION_DATE", "type": "esriFieldTypeDate", "alias": "Activity Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ACTION_DATE" }, { "name": "CREW_UPDATE_BY", "type": "esriFieldTypeString", "alias": "Crew Update", "domain": { "type": "codedValue", "name": "ValveCrew", "description": "List of crew turning valves", "codedValues": [ { "name": "asanchez", "code": "asanchez" }, { "name": "dhill", "code": "dhill" }, { "name": "gpichardo", "code": "gpichardo" }, { "name": "javina", "code": "javina" }, { "name": "jcarranza", "code": "jcarranza" }, { "name": "mcurry", "code": "mcurry" }, { "name": "mmeadow", "code": "mmeadow" }, { "name": "mosullivan", "code": "mosullivan" }, { "name": "rguadarrama", "code": "rguadarrama" }, { "name": "swebber", "code": "swebber" }, { "name": "twilliams ", "code": "twilliams " } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "CREW_UPDATE_BY" } ], "indexes": [ { "name": "R3843_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_314790_PIPE_", "fields": "PIPE_TAG", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "NBGIS.GISDATA.WaterLineMaintFieldHistory", "description": "", "prototype": { "attributes": { "ACTION_DATE": null, "CREW_UPDATE_BY": null, "PIPE_TAG": null, "AGENCY_COD": null, "DIAMETER": null, "MATERIAL_C": null, "TYPE": null, "SYSTEMTYPE": "D", "PRESSURE_C": null, "PRESSURE_Z": null, "INSTALL_YE": null, "SOURCE_NAM": null, "SOURCE_DAT": null, "ABANDONED": "N", "ABAND_YEAR": null, "RELINED_YN": null, "RELINE_TYP": null, "RELINE_YEA": null, "REMARKS": null, "ENABLED": 1, "REVISED_DATE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 7, "name": "NBGIS.GISDATA.WaterAirVacsMaintFieldHistory", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 4, "name": "WaterAirVacsMaintField", "relatedTableId": 3, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "NODE_TAG", "composite": true, "catalogID": "{E32C6232-6377-4DC0-BE08-EAE01EB21597}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "ACTION_DATE", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "NODE_TAG", "type": "esriFieldTypeString", "alias": "GIS Tag", "domain": null, "editable": true, "nullable": true, "length": 7, "defaultValue": null, "modelName": "node_tag" }, { "name": "AGENCY_CODE", "type": "esriFieldTypeString", "alias": "Owner Jurisdiction", "domain": { "type": "codedValue", "name": "WaterAgency", "description": "Water System Agency", "codedValues": [ { "name": "Irvine Ranch Water District", "code": "IRWD" }, { "name": "Laguna Beach Water", "code": "LBW" }, { "name": "Mesa Consolidated Water District", "code": "MCWD" }, { "name": "Metropolitan Water District", "code": "MWD" }, { "name": "Newport Beach", "code": "NB" }, { "name": "Orange County", "code": "OC" }, { "name": "Santa Ana Heights Water", "code": "SAHW" }, { "name": "Unknown", "code": "UNK" }, { "name": "Private", "code": "PVT" }, { "name": "OTHER", "code": "OTH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "agency_code" }, { "name": "ARV_MANUF", "type": "esriFieldTypeString", "alias": "Type", "domain": { "type": "codedValue", "name": "AirVacManufacturer", "description": "Manufacturer list of Air Vacs", "codedValues": [ { "name": "APCO", "code": "APCO" }, { "name": "A.R.I.", "code": "A.R.I." }, { "name": "ClaVal", "code": "ClaVal" }, { "name": "Crispin", "code": "Crispin" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "ARV_MANUF" }, { "name": "ARV_SIZE", "type": "esriFieldTypeString", "alias": "Size", "domain": { "type": "codedValue", "name": "AirVacSize", "description": "Size of AirVac", "codedValues": [ { "name": "1", "code": "1" }, { "name": "2", "code": "2" }, { "name": "3", "code": "3" }, { "name": "4", "code": "4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 5, "defaultValue": "2", "modelName": "ARV_SIZE" }, { "name": "ARV_PRESS_ZONE", "type": "esriFieldTypeString", "alias": "Pressure Zone", "domain": { "type": "codedValue", "name": "WaterPressureZone", "description": "Water Line Pressure Zone", "codedValues": [ { "name": "99", "code": "99" }, { "name": "Zone 1", "code": "1" }, { "name": "Zone 2", "code": "2" }, { "name": "Zone 2R-12", "code": "2R-12" }, { "name": "Zone 2R-16", "code": "2R-16" }, { "name": "Zone 3R-17", "code": "3R-17" }, { "name": "Zone 3R-9", "code": "3R-9" }, { "name": "Zone 3R-6", "code": "3R-6" }, { "name": "Zone 3R-14", "code": "3R-14" }, { "name": "Zone 3R-11", "code": "3R-11" }, { "name": "Zone 3", "code": "3" }, { "name": "Zone 3R-15", "code": "3R-15" }, { "name": "Zone 3R-10", "code": "3R-10" }, { "name": "Zone 3R-8", "code": "3R-8" }, { "name": "Zone 4R-7", "code": "4R-7" }, { "name": "Zone 4", "code": "4" }, { "name": "Zone5", "code": "5" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "ARV_PRESS_ZONE" }, { "name": "ARV_VLV_REPLACED", "type": "esriFieldTypeDate", "alias": "Install/Replace", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ARV_VLV_REPLACED" }, { "name": "ARV_VLV_CAN", "type": "esriFieldTypeString", "alias": "Can", "domain": { "type": "codedValue", "name": "YES_NO_FULL", "description": "YES and NO full.", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": "YES", "modelName": "ARV_VLV_CAN" }, { "name": "ARV_CAN_REPLACE", "type": "esriFieldTypeString", "alias": "Can Replaced", "domain": { "type": "codedValue", "name": "YES_NO_FULL", "description": "YES and NO full.", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "ARV_CAN_REPLACE" }, { "name": "ARV_VLV_POS", "type": "esriFieldTypeString", "alias": "Current Position", "domain": { "type": "codedValue", "name": "AirVacPosition", "description": "Open or Closed", "codedValues": [ { "name": "OPEN", "code": "OPEN" }, { "name": "CLOSED", "code": "CLOSED" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": "OPEN", "modelName": "ARV_VLV_POS" }, { "name": "ARV_VLV_DEPTH", "type": "esriFieldTypeString", "alias": "Depth to Valve", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "ARV_VLV_DEPTH" }, { "name": "ARV_VLV_CON", "type": "esriFieldTypeString", "alias": "Operating Status", "domain": { "type": "codedValue", "name": "AirVacValveCond", "description": "Condition of AirVac", "codedValues": [ { "name": "GOOD", "code": "GOOD" }, { "name": "BAD", "code": "BAD" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 15, "defaultValue": "GOOD", "modelName": "ARV_VLV_CON" }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "COMMENTS" }, { "name": "CREW_UPDATE", "type": "esriFieldTypeString", "alias": "Updated By", "domain": { "type": "codedValue", "name": "ValveCrew", "description": "List of crew turning valves", "codedValues": [ { "name": "asanchez", "code": "asanchez" }, { "name": "dhill", "code": "dhill" }, { "name": "gpichardo", "code": "gpichardo" }, { "name": "javina", "code": "javina" }, { "name": "jcarranza", "code": "jcarranza" }, { "name": "mcurry", "code": "mcurry" }, { "name": "mmeadow", "code": "mmeadow" }, { "name": "mosullivan", "code": "mosullivan" }, { "name": "rguadarrama", "code": "rguadarrama" }, { "name": "swebber", "code": "swebber" }, { "name": "twilliams ", "code": "twilliams " } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "CREW_UPDATE" }, { "name": "ACTION_DATE", "type": "esriFieldTypeDate", "alias": "Activity Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ACTION_DATE" } ], "indexes": [ { "name": "R3868_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_315583_NODE_", "fields": "NODE_TAG", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "NBGIS.GISDATA.WaterAirVacsMaintFieldHistory", "description": "", "prototype": { "attributes": { "CREW_UPDATE": null, "ACTION_DATE": null, "NODE_TAG": null, "AGENCY_CODE": null, "ARV_MANUF": null, "ARV_SIZE": "2", "ARV_PRESS_ZONE": null, "ARV_VLV_REPLACED": null, "ARV_VLV_CAN": "YES", "ARV_CAN_REPLACE": null, "ARV_VLV_POS": "OPEN", "ARV_VLV_DEPTH": null, "ARV_VLV_CON": "GOOD", "COMMENTS": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 8, "name": "NBGIS.GISDATA.WaterHydrantFieldInspect", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": {"creationDateField": "DateInspected"}, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 2, "name": "WaterHydrantMaintField", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "GIS_TAG", "composite": true, "catalogID": "{2BDAA51F-BEB8-4E7E-8947-FF57D0847CC8}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "DateInspected", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "LidWhite", "type": "esriFieldTypeString", "alias": "Lid to valve white?", "domain": { "type": "codedValue", "name": "NAYesNoFullText", "description": "Yes No NA full text", "codedValues": [ { "name": "NA", "code": "NA" }, { "name": "NO", "code": "NO" }, { "name": "YES", "code": "YES" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": false, "length": 10, "defaultValue": null, "modelName": "LidWhite" }, { "name": "PaintedLid", "type": "esriFieldTypeString", "alias": "Painted lid white?", "domain": { "type": "codedValue", "name": "NAYesNoFullText", "description": "Yes No NA full text", "codedValues": [ { "name": "NA", "code": "NA" }, { "name": "NO", "code": "NO" }, { "name": "YES", "code": "YES" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": false, "length": 10, "defaultValue": null, "modelName": "PaintedLid" }, { "name": "AttachDechlorinator", "type": "esriFieldTypeString", "alias": "Attach dechlorinator?", "domain": { "type": "codedValue", "name": "NAYesNoFullText", "description": "Yes No NA full text", "codedValues": [ { "name": "NA", "code": "NA" }, { "name": "NO", "code": "NO" }, { "name": "YES", "code": "YES" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": false, "length": 10, "defaultValue": null, "modelName": "AttachDechlorinator" }, { "name": "FlowStopValveOff", "type": "esriFieldTypeString", "alias": "Flow stops when isolation valve is off?", "domain": { "type": "codedValue", "name": "NAYesNoFullText", "description": "Yes No NA full text", "codedValues": [ { "name": "NA", "code": "NA" }, { "name": "NO", "code": "NO" }, { "name": "YES", "code": "YES" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": false, "length": 10, "defaultValue": null, "modelName": "FlowStopValveOff" }, { "name": "FlowValveFlowClear", "type": "esriFieldTypeString", "alias": "Open Iso valve and flow until water clear?", "domain": { "type": "codedValue", "name": "NAYesNoFullText", "description": "Yes No NA full text", "codedValues": [ { "name": "NA", "code": "NA" }, { "name": "NO", "code": "NO" }, { "name": "YES", "code": "YES" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": false, "length": 10, "defaultValue": null, "modelName": "FlowValveFlowClear" }, { "name": "RenoveDechlorinator", "type": "esriFieldTypeString", "alias": "Remove dechlorinator?", "domain": { "type": "codedValue", "name": "NAYesNoFullText", "description": "Yes No NA full text", "codedValues": [ { "name": "NA", "code": "NA" }, { "name": "NO", "code": "NO" }, { "name": "YES", "code": "YES" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": false, "length": 10, "defaultValue": null, "modelName": "RenoveDechlorinator" }, { "name": "HydrantRust", "type": "esriFieldTypeString", "alias": "Inspect hydrant for rust?", "domain": { "type": "codedValue", "name": "NAYesNoFullText", "description": "Yes No NA full text", "codedValues": [ { "name": "NA", "code": "NA" }, { "name": "NO", "code": "NO" }, { "name": "YES", "code": "YES" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": false, "length": 10, "defaultValue": null, "modelName": "HydrantRust" }, { "name": "GreaseHydrant", "type": "esriFieldTypeString", "alias": "Grease threads to hydrant?", "domain": { "type": "codedValue", "name": "NAYesNoFullText", "description": "Yes No NA full text", "codedValues": [ { "name": "NA", "code": "NA" }, { "name": "NO", "code": "NO" }, { "name": "YES", "code": "YES" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": false, "length": 10, "defaultValue": null, "modelName": "GreaseHydrant" }, { "name": "PaintedHydrant", "type": "esriFieldTypeString", "alias": "Painted hydrant?", "domain": { "type": "codedValue", "name": "NAYesNoFullText", "description": "Yes No NA full text", "codedValues": [ { "name": "NA", "code": "NA" }, { "name": "NO", "code": "NO" }, { "name": "YES", "code": "YES" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": false, "length": 10, "defaultValue": null, "modelName": "PaintedHydrant" }, { "name": "ReplacePlasticCaps", "type": "esriFieldTypeString", "alias": "Replace plastic caps with bronze/iron caps?", "domain": { "type": "codedValue", "name": "NAYesNoFullText", "description": "Yes No NA full text", "codedValues": [ { "name": "NA", "code": "NA" }, { "name": "NO", "code": "NO" }, { "name": "YES", "code": "YES" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": false, "length": 10, "defaultValue": null, "modelName": "ReplacePlasticCaps" }, { "name": "InspectHydrantNumber", "type": "esriFieldTypeString", "alias": "Inspect hydrant number?", "domain": { "type": "codedValue", "name": "NAYesNoFullText", "description": "Yes No NA full text", "codedValues": [ { "name": "NA", "code": "NA" }, { "name": "NO", "code": "NO" }, { "name": "YES", "code": "YES" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": false, "length": 10, "defaultValue": null, "modelName": "InspectHydrantNumber" }, { "name": "IsHydrantNumbered", "type": "esriFieldTypeString", "alias": "Is hydrant numbered?", "domain": { "type": "codedValue", "name": "NAYesNoFullText", "description": "Yes No NA full text", "codedValues": [ { "name": "NA", "code": "NA" }, { "name": "NO", "code": "NO" }, { "name": "YES", "code": "YES" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": false, "length": 10, "defaultValue": null, "modelName": "IsHydrantNumbered" }, { "name": "ReplaceHydrantNumber", "type": "esriFieldTypeString", "alias": "Replace hydrant number?", "domain": { "type": "codedValue", "name": "NAYesNoFullText", "description": "Yes No NA full text", "codedValues": [ { "name": "NA", "code": "NA" }, { "name": "NO", "code": "NO" }, { "name": "YES", "code": "YES" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": false, "length": 10, "defaultValue": null, "modelName": "ReplaceHydrantNumber" }, { "name": "InspectBlueDot", "type": "esriFieldTypeString", "alias": "Inspect blue dot?", "domain": { "type": "codedValue", "name": "NAYesNoFullText", "description": "Yes No NA full text", "codedValues": [ { "name": "NA", "code": "NA" }, { "name": "NO", "code": "NO" }, { "name": "YES", "code": "YES" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": false, "length": 10, "defaultValue": null, "modelName": "InspectBlueDot" }, { "name": "ReplaceBlueDot", "type": "esriFieldTypeString", "alias": "Replace blue dot?", "domain": { "type": "codedValue", "name": "NAYesNoFullText", "description": "Yes No NA full text", "codedValues": [ { "name": "NA", "code": "NA" }, { "name": "NO", "code": "NO" }, { "name": "YES", "code": "YES" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": false, "length": 10, "defaultValue": null, "modelName": "ReplaceBlueDot" }, { "name": "AdditionalComments", "type": "esriFieldTypeString", "alias": "Additional Comments", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AdditionalComments" }, { "name": "DateInspected", "type": "esriFieldTypeDate", "alias": "Date Inspected", "domain": null, "editable": false, "nullable": false, "length": 8, "defaultValue": null, "modelName": "DateInspected" }, { "name": "GIS_TAG", "type": "esriFieldTypeString", "alias": "GIS_TAG", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "GIS_TAG" }, { "name": "CREW_UPDATE_BY", "type": "esriFieldTypeString", "alias": "Crew Update", "domain": { "type": "codedValue", "name": "ValveCrew", "description": "List of crew turning valves", "codedValues": [ { "name": "asanchez", "code": "asanchez" }, { "name": "dhill", "code": "dhill" }, { "name": "gpichardo", "code": "gpichardo" }, { "name": "javina", "code": "javina" }, { "name": "jcarranza", "code": "jcarranza" }, { "name": "mcurry", "code": "mcurry" }, { "name": "mmeadow", "code": "mmeadow" }, { "name": "mosullivan", "code": "mosullivan" }, { "name": "rguadarrama", "code": "rguadarrama" }, { "name": "swebber", "code": "swebber" }, { "name": "twilliams ", "code": "twilliams " } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "CREW_UPDATE_BY" } ], "indexes": [ { "name": "R5531_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_318657_GIS_T", "fields": "GIS_TAG", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "NBGIS.GISDATA.WaterHydrantFieldInspect", "description": "", "prototype": { "attributes": { "GIS_TAG": null, "CREW_UPDATE_BY": null, "LidWhite": " ", "PaintedLid": " ", "AttachDechlorinator": " ", "FlowStopValveOff": " ", "FlowValveFlowClear": " ", "RenoveDechlorinator": " ", "HydrantRust": " ", "GreaseHydrant": " ", "PaintedHydrant": " ", "ReplacePlasticCaps": " ", "InspectHydrantNumber": " ", "IsHydrantNumbered": " ", "ReplaceHydrantNumber": " ", "InspectBlueDot": " ", "ReplaceBlueDot": " ", "AdditionalComments": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 } ] }