{ "layers": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 0, "name": "Water Valve", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "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 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 2500, "maxScale": 0, "referenceScale": 0.0, "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 }, "defaultVisibility": 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 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "GIS_TAG", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "MAINT_AREA", "type": "esriFieldTypeString", "alias": "MAINT_AREA", "length": 10, "domain": null }, { "name": "ACTION_DATE", "type": "esriFieldTypeDate", "alias": "ACTION_DATE", "length": 8, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "GIS_TAG", "type": "esriFieldTypeString", "alias": "Valve ID", "length": 10, "domain": null }, { "name": "OWNER", "type": "esriFieldTypeString", "alias": "Agency", "length": 20, "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" } }, { "name": "VALVE_FUNCTION", "type": "esriFieldTypeString", "alias": "Valve Function", "length": 20, "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" } }, { "name": "VALVE_TYPE", "type": "esriFieldTypeString", "alias": "Valve Type", "length": 20, "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" } }, { "name": "HYDRANT_VALVE", "type": "esriFieldTypeString", "alias": "Hydrant Valve", "length": 5, "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" } }, { "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" } }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "Date Install/Replace", "length": 8, "domain": null }, { "name": "CURRENT_POSITION", "type": "esriFieldTypeString", "alias": "Current Position", "length": 10, "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" } }, { "name": "ABANDONED", "type": "esriFieldTypeString", "alias": "Abandoned?", "length": 1, "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" } }, { "name": "NORMAL_CLOSED", "type": "esriFieldTypeString", "alias": "Normally Closed", "length": 10, "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" } }, { "name": "TURNS_CLOSE", "type": "esriFieldTypeString", "alias": "Turns to Close", "length": 10, "domain": null }, { "name": "DEPTH_NUT", "type": "esriFieldTypeSmallInteger", "alias": "Depth", "domain": null }, { "name": "OPERATION_STATUS", "type": "esriFieldTypeString", "alias": "Operational Status", "length": 30, "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" } }, { "name": "VALVE_ACTIVITY", "type": "esriFieldTypeString", "alias": "Activity", "length": 30, "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" } }, { "name": "CREW_UPDATE_BY", "type": "esriFieldTypeString", "alias": "Crew Update", "length": 30, "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" } }, { "name": "FIELD_COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "length": 100, "domain": null }, { "name": "MAINT_DATE", "type": "esriFieldTypeDate", "alias": "MAINT_DATE", "length": 8, "domain": null }, { "name": "CHECK_VALVE", "type": "esriFieldTypeString", "alias": "Check Valve", "length": 10, "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" } }, { "name": "CHECK_VALVE_TYPE", "type": "esriFieldTypeString", "alias": "Check Valve Type", "length": 20, "domain": { "type": "codedValue", "name": "WaterCheckVlvType", "description": "Type of Check Valve", "codedValues": [ { "name": "AVK", "code": "AVK" }, { "name": "Clow", "code": "Clow" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DATE_EXERCISED", "type": "esriFieldTypeDate", "alias": "Date Exercised", "length": 8, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "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": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "WaterValveMaintFieldHistory", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "GIS_TAG", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{92939639-DA31-46C9-AED3-CD6AAB872FC7}" } ], "canModifyLayer": false, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 1, "name": "Hydrant", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "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 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 2500, "maxScale": 0, "referenceScale": 0.0, "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 }, "defaultVisibility": 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 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "HYDRANTID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "GIS_TAG", "type": "esriFieldTypeString", "alias": "GIS ID", "length": 15, "domain": null }, { "name": "HYDRANTID", "type": "esriFieldTypeString", "alias": "Hydrant Number", "length": 20, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 30, "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" } }, { "name": "BARRELTYPE", "type": "esriFieldTypeString", "alias": "Barrel Type", "length": 15, "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" } }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Date Install/Replace", "length": 8, "domain": null }, { "name": "STATICPSI", "type": "esriFieldTypeSmallInteger", "alias": "Static PSI", "domain": null }, { "name": "PORTS2IN", "type": "esriFieldTypeSmallInteger", "alias": "2.5 Inch Outlets", "domain": null }, { "name": "PORTS4IN", "type": "esriFieldTypeSmallInteger", "alias": "4 Inch Outlets", "domain": null }, { "name": "FRESHLYPAINTED", "type": "esriFieldTypeString", "alias": "Freshly Painted", "length": 10, "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" } }, { "name": "DATEPAINTED", "type": "esriFieldTypeDate", "alias": "Date Last Painted", "length": 8, "domain": null }, { "name": "INSERVICE", "type": "esriFieldTypeString", "alias": "In Service", "length": 10, "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" } }, { "name": "OPERATIONCOMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "length": 100, "domain": null }, { "name": "CREW_UPDATE_BY", "type": "esriFieldTypeString", "alias": "Crew Update", "length": 25, "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" } }, { "name": "ACTION_DATE", "type": "esriFieldTypeDate", "alias": "Updated Date", "length": 8, "domain": null }, { "name": "CHECK_VALVE", "type": "esriFieldTypeString", "alias": "Check Valve", "length": 10, "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" } }, { "name": "CHECK_VALVE_TYPE", "type": "esriFieldTypeString", "alias": "Check Valve Type", "length": 20, "domain": { "type": "codedValue", "name": "WaterCheckVlvType", "description": "Type of Check Valve", "codedValues": [ { "name": "AVK", "code": "AVK" }, { "name": "Clow", "code": "Clow" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "HYD_MAIN_INSPECT", "type": "esriFieldTypeString", "alias": "Hydrant Maintained and Inspected?", "length": 20, "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" } }, { "name": "HYD_FLUSH", "type": "esriFieldTypeString", "alias": "Hydrant Flushed?", "length": 20, "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" } } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "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": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "WaterHydrantFieldInspect", "relatedTableId": 8, "role": "esriRelRoleOrigin", "keyField": "GIS_TAG", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{2BDAA51F-BEB8-4E7E-8947-FF57D0847CC8}" }, { "id": 2, "name": "WaterHydrantMaintFieldHistory", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "GIS_TAG", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{98422E1C-036F-4C3B-977D-B564EEB88237}" } ], "canModifyLayer": false, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 2, "name": "Water Main", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPolyline", "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 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 2500, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSDash", "color": [ 0, 112, 255, 255 ], "width": 0.1 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": 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 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "PIPE_TAG", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PIPE_TAG", "type": "esriFieldTypeString", "alias": "Pipe Tag", "length": 10, "domain": null }, { "name": "AGENCY_COD", "type": "esriFieldTypeString", "alias": "Agency Code", "length": 4, "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" } }, { "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" } }, { "name": "MATERIAL_C", "type": "esriFieldTypeString", "alias": "Material Code", "length": 6, "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" } }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "Pipe Type", "length": 1, "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" } }, { "name": "SYSTEMTYPE", "type": "esriFieldTypeString", "alias": "Water System Type", "length": 1, "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" } }, { "name": "PRESSURE_C", "type": "esriFieldTypeString", "alias": "Pressure Class", "length": 5, "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" } }, { "name": "PRESSURE_Z", "type": "esriFieldTypeString", "alias": "Pressure Zone", "length": 5, "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" } }, { "name": "INSTALL_YE", "type": "esriFieldTypeDate", "alias": "Install Year", "length": 8, "domain": null }, { "name": "SOURCE_NAM", "type": "esriFieldTypeString", "alias": "Source", "length": 30, "domain": null }, { "name": "SOURCE_DAT", "type": "esriFieldTypeDate", "alias": "Source Date", "length": 8, "domain": null }, { "name": "ABANDONED", "type": "esriFieldTypeString", "alias": "Abandoned?", "length": 1, "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" } }, { "name": "ABAND_YEAR", "type": "esriFieldTypeDate", "alias": "Abandoned Year", "length": 8, "domain": null }, { "name": "RELINED_YN", "type": "esriFieldTypeString", "alias": "Relined?", "length": 10, "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" } }, { "name": "RELINE_TYP", "type": "esriFieldTypeString", "alias": "Reline Type", "length": 20, "domain": null }, { "name": "RELINE_YEA", "type": "esriFieldTypeString", "alias": "Reline Year", "length": 20, "domain": null }, { "name": "REMARKS", "type": "esriFieldTypeString", "alias": "Remarks", "length": 40, "domain": null }, { "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" } }, { "name": "REVISED_DATE", "type": "esriFieldTypeDate", "alias": "Revised Date", "length": 8, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "ACTION_DATE", "type": "esriFieldTypeDate", "alias": "Activity Date", "length": 8, "domain": null }, { "name": "CREW_UPDATE_BY", "type": "esriFieldTypeString", "alias": "Crew Update", "length": 30, "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" } }, { "name": "PLAN_LINK", "type": "esriFieldTypeString", "alias": "Plan Link", "length": 200, "domain": null }, { "name": "PLAN_TEXT_LINK", "type": "esriFieldTypeString", "alias": "Plan Text Link", "length": 20, "domain": null }, { "name": "Shape.STLength()", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "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": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "WaterLineMaintFieldHistory", "relatedTableId": 6, "role": "esriRelRoleOrigin", "keyField": "PIPE_TAG", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{32489633-F923-4B6F-8C44-8AAC721C8169}" } ], "canModifyLayer": false, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape.STLength()", "units": "esriFeet", "mapUnits": {"uwkid": 9003} }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 3, "name": "Air Vac", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "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 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 6000, "maxScale": 0, "referenceScale": 0.0, "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 }, "defaultVisibility": 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 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "NODE_TAG", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "NODE_TAG", "type": "esriFieldTypeString", "alias": "GIS Tag", "length": 7, "domain": null }, { "name": "AGENCY_CODE", "type": "esriFieldTypeString", "alias": "Owner Jurisdiction", "length": 4, "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" } }, { "name": "ARV_MANUF", "type": "esriFieldTypeString", "alias": "Type", "length": 20, "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" } }, { "name": "ARV_SIZE", "type": "esriFieldTypeString", "alias": "Size", "length": 5, "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" } }, { "name": "ARV_PRESS_ZONE", "type": "esriFieldTypeString", "alias": "Pressure Zone", "length": 10, "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" } }, { "name": "ARV_VLV_REPLACED", "type": "esriFieldTypeDate", "alias": "Install/Replace", "length": 8, "domain": null }, { "name": "ARV_VLV_CAN", "type": "esriFieldTypeString", "alias": "Can", "length": 10, "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" } }, { "name": "ARV_CAN_REPLACE", "type": "esriFieldTypeString", "alias": "Can Replaced", "length": 20, "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" } }, { "name": "ARV_VLV_POS", "type": "esriFieldTypeString", "alias": "Current Position", "length": 10, "domain": { "type": "codedValue", "name": "AirVacPosition", "description": "Open or Closed", "codedValues": [ { "name": "OPEN", "code": "OPEN" }, { "name": "CLOSED", "code": "CLOSED" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ARV_VLV_DEPTH", "type": "esriFieldTypeString", "alias": "Depth to Valve", "length": 20, "domain": null }, { "name": "ARV_VLV_CON", "type": "esriFieldTypeString", "alias": "Operating Status", "length": 15, "domain": { "type": "codedValue", "name": "AirVacValveCond", "description": "Condition of AirVac", "codedValues": [ { "name": "GOOD", "code": "GOOD" }, { "name": "BAD", "code": "BAD" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CREW_UPDATE", "type": "esriFieldTypeString", "alias": "Updated By", "length": 20, "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" } }, { "name": "ACTION_DATE", "type": "esriFieldTypeDate", "alias": "Activity Date", "length": 8, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "MAINT_AREA", "type": "esriFieldTypeString", "alias": "Maintenance Area", "length": 10, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "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": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "WaterAirVacsMaintFieldHistory", "relatedTableId": 7, "role": "esriRelRoleOrigin", "keyField": "NODE_TAG", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{899804A1-F743-4EFA-96D9-928846C110BB}" } ], "canModifyLayer": false, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 9, "name": "Incident Location", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "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 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "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 }, "defaultVisibility": 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 } }, "hasAttachments": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalid", "fieldName": "GLOBALID", "isEnabled": false }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "editable": false, "nullable": false, "length": 4, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "editable": true, "nullable": false, "length": 250, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "editable": true, "nullable": false, "length": 150, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "editable": true, "nullable": false, "length": 4, "domain": null } ], "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "QuestTicket", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "QuestTicket", "type": "esriFieldTypeString", "alias": "Quest Ticket", "length": 20, "domain": null }, { "name": "IncidentDate", "type": "esriFieldTypeDate", "alias": "Incident Date", "length": 8, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 1000, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R7113_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S2153_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": false, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Query,Map,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true } ], "tables": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 4, "name": "NBGIS.GISDATA.WaterValveMaintFieldHistory", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ACTION_DATE", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GIS_TAG", "type": "esriFieldTypeString", "alias": "Valve ID", "length": 10, "domain": null }, { "name": "OWNER", "type": "esriFieldTypeString", "alias": "Agency", "length": 20, "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" } }, { "name": "VALVE_FUNCTION", "type": "esriFieldTypeString", "alias": "Valve Function", "length": 20, "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" } }, { "name": "VALVE_TYPE", "type": "esriFieldTypeString", "alias": "Valve Type", "length": 20, "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" } }, { "name": "HYDRANT_VALVE", "type": "esriFieldTypeString", "alias": "Hydrant Valve", "length": 5, "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" } }, { "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" } }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "Date Install/Replace", "length": 8, "domain": null }, { "name": "CURRENT_POSITION", "type": "esriFieldTypeString", "alias": "Current Position", "length": 10, "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" } }, { "name": "ABANDONED", "type": "esriFieldTypeString", "alias": "Abandoned?", "length": 1, "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" } }, { "name": "NORMAL_CLOSED", "type": "esriFieldTypeString", "alias": "Normally Closed", "length": 10, "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" } }, { "name": "TURNS_CLOSE", "type": "esriFieldTypeString", "alias": "Turns to Close", "length": 10, "domain": null }, { "name": "DEPTH_NUT", "type": "esriFieldTypeSmallInteger", "alias": "Depth", "domain": null }, { "name": "OPERATION_STATUS", "type": "esriFieldTypeString", "alias": "Operational Status", "length": 30, "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" } }, { "name": "VALVE_ACTIVITY", "type": "esriFieldTypeString", "alias": "Activity", "length": 30, "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" } }, { "name": "CREW_UPDATE_BY", "type": "esriFieldTypeString", "alias": "Crew Update", "length": 30, "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" } }, { "name": "FIELD_COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "length": 100, "domain": null }, { "name": "ACTION_DATE", "type": "esriFieldTypeDate", "alias": "Updated Date", "length": 8, "domain": null }, { "name": "MAINT_AREA", "type": "esriFieldTypeString", "alias": "MAINT_AREA", "length": 10, "domain": null }, { "name": "CHECK_VALVE", "type": "esriFieldTypeString", "alias": "Check Valve", "length": 10, "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" } }, { "name": "CHECK_VALVE_TYPE", "type": "esriFieldTypeString", "alias": "Check Valve Type", "length": 20, "domain": { "type": "codedValue", "name": "WaterCheckVlvType", "description": "Type of Check Valve", "codedValues": [ { "name": "AVK", "code": "AVK" }, { "name": "Clow", "code": "Clow" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DATE_EXERCISED", "type": "esriFieldTypeDate", "alias": "Date Exercised", "length": 8, "domain": null } ], "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": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "WaterValveMaintField", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "GIS_TAG", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{92939639-DA31-46C9-AED3-CD6AAB872FC7}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 5, "name": "NBGIS.GISDATA.WaterHydrantMaintFieldHistory", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ACTION_DATE", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GIS_TAG", "type": "esriFieldTypeString", "alias": "GIS ID", "length": 15, "domain": null }, { "name": "HYDRANTID", "type": "esriFieldTypeString", "alias": "Hydrant Number", "length": 20, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 30, "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" } }, { "name": "BARRELTYPE", "type": "esriFieldTypeString", "alias": "Barrel Type", "length": 15, "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" } }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Date Install/Replace", "length": 8, "domain": null }, { "name": "STATICPSI", "type": "esriFieldTypeSmallInteger", "alias": "Static PSI", "domain": null }, { "name": "PORTS2IN", "type": "esriFieldTypeSmallInteger", "alias": "2.5 Inch Outlets", "domain": null }, { "name": "PORTS4IN", "type": "esriFieldTypeSmallInteger", "alias": "4 Inch Outlets", "domain": null }, { "name": "FRESHLYPAINTED", "type": "esriFieldTypeString", "alias": "Freshly Painted", "length": 10, "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" } }, { "name": "DATEPAINTED", "type": "esriFieldTypeDate", "alias": "Date Last Painted", "length": 8, "domain": null }, { "name": "INSERVICE", "type": "esriFieldTypeString", "alias": "In Service", "length": 10, "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" } }, { "name": "OPERATIONCOMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "length": 100, "domain": null }, { "name": "CREW_UPDATE_BY", "type": "esriFieldTypeString", "alias": "Crew Update", "length": 25, "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" } }, { "name": "ACTION_DATE", "type": "esriFieldTypeDate", "alias": "Updated Date", "length": 8, "domain": null }, { "name": "CHECK_VALVE", "type": "esriFieldTypeString", "alias": "Check Valve", "length": 10, "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" } }, { "name": "CHECK_VALVE_TYPE", "type": "esriFieldTypeString", "alias": "Check Valve Type", "length": 20, "domain": { "type": "codedValue", "name": "WaterCheckVlvType", "description": "Type of Check Valve", "codedValues": [ { "name": "AVK", "code": "AVK" }, { "name": "Clow", "code": "Clow" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "HYD_MAIN_INSPECT", "type": "esriFieldTypeString", "alias": "Hydrant Maintained and Inspected?", "length": 20, "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" } }, { "name": "HYD_FLUSH", "type": "esriFieldTypeString", "alias": "Hydrant Flush?", "length": 20, "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" } } ], "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": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "WaterHydrantMaintField", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "GIS_TAG", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{98422E1C-036F-4C3B-977D-B564EEB88237}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 6, "name": "NBGIS.GISDATA.WaterLineMaintFieldHistory", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ACTION_DATE", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PIPE_TAG", "type": "esriFieldTypeString", "alias": "Pipe Tag", "length": 10, "domain": null }, { "name": "AGENCY_COD", "type": "esriFieldTypeString", "alias": "Agency Code", "length": 4, "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" } }, { "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" } }, { "name": "MATERIAL_C", "type": "esriFieldTypeString", "alias": "Material Code", "length": 6, "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" } }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "Pipe Type", "length": 1, "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" } }, { "name": "SYSTEMTYPE", "type": "esriFieldTypeString", "alias": "Water System Type", "length": 1, "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" } }, { "name": "PRESSURE_C", "type": "esriFieldTypeString", "alias": "Pressure Class", "length": 5, "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" } }, { "name": "PRESSURE_Z", "type": "esriFieldTypeString", "alias": "Pressure Zone", "length": 5, "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" } }, { "name": "INSTALL_YE", "type": "esriFieldTypeDate", "alias": "Install Year", "length": 8, "domain": null }, { "name": "SOURCE_NAM", "type": "esriFieldTypeString", "alias": "Source", "length": 30, "domain": null }, { "name": "SOURCE_DAT", "type": "esriFieldTypeDate", "alias": "Source Date", "length": 8, "domain": null }, { "name": "ABANDONED", "type": "esriFieldTypeString", "alias": "Abandoned?", "length": 1, "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" } }, { "name": "ABAND_YEAR", "type": "esriFieldTypeDate", "alias": "Abandoned Year", "length": 8, "domain": null }, { "name": "RELINED_YN", "type": "esriFieldTypeString", "alias": "Relined?", "length": 10, "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" } }, { "name": "RELINE_TYP", "type": "esriFieldTypeString", "alias": "Reline Type", "length": 20, "domain": null }, { "name": "RELINE_YEA", "type": "esriFieldTypeString", "alias": "Reline Year", "length": 20, "domain": null }, { "name": "REMARKS", "type": "esriFieldTypeString", "alias": "Remarks", "length": 40, "domain": null }, { "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" } }, { "name": "REVISED_DATE", "type": "esriFieldTypeDate", "alias": "Revised Date", "length": 8, "domain": null }, { "name": "ACTION_DATE", "type": "esriFieldTypeDate", "alias": "Activity Date", "length": 8, "domain": null }, { "name": "CREW_UPDATE_BY", "type": "esriFieldTypeString", "alias": "Crew Update", "length": 30, "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" } } ], "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": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "WaterLineMaintField", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "PIPE_TAG", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{32489633-F923-4B6F-8C44-8AAC721C8169}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 7, "name": "NBGIS.GISDATA.WaterAirVacsMaintFieldHistory", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ACTION_DATE", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "NODE_TAG", "type": "esriFieldTypeString", "alias": "GIS Tag", "length": 7, "domain": null }, { "name": "AGENCY_CODE", "type": "esriFieldTypeString", "alias": "Owner Jurisdiction", "length": 4, "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" } }, { "name": "ARV_MANUF", "type": "esriFieldTypeString", "alias": "Type", "length": 20, "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" } }, { "name": "ARV_SIZE", "type": "esriFieldTypeString", "alias": "Size", "length": 5, "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" } }, { "name": "ARV_PRESS_ZONE", "type": "esriFieldTypeString", "alias": "Pressure Zone", "length": 10, "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" } }, { "name": "ARV_VLV_REPLACED", "type": "esriFieldTypeDate", "alias": "Install/Replace", "length": 8, "domain": null }, { "name": "ARV_VLV_CAN", "type": "esriFieldTypeString", "alias": "Can", "length": 10, "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" } }, { "name": "ARV_CAN_REPLACE", "type": "esriFieldTypeString", "alias": "Can Replaced", "length": 20, "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" } }, { "name": "ARV_VLV_POS", "type": "esriFieldTypeString", "alias": "Current Position", "length": 10, "domain": { "type": "codedValue", "name": "AirVacPosition", "description": "Open or Closed", "codedValues": [ { "name": "OPEN", "code": "OPEN" }, { "name": "CLOSED", "code": "CLOSED" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ARV_VLV_DEPTH", "type": "esriFieldTypeString", "alias": "Depth to Valve", "length": 20, "domain": null }, { "name": "ARV_VLV_CON", "type": "esriFieldTypeString", "alias": "Operating Status", "length": 15, "domain": { "type": "codedValue", "name": "AirVacValveCond", "description": "Condition of AirVac", "codedValues": [ { "name": "GOOD", "code": "GOOD" }, { "name": "BAD", "code": "BAD" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "CREW_UPDATE", "type": "esriFieldTypeString", "alias": "Updated By", "length": 20, "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" } }, { "name": "ACTION_DATE", "type": "esriFieldTypeDate", "alias": "Activity Date", "length": 8, "domain": null } ], "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": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "WaterAirVacsMaintField", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "NODE_TAG", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{899804A1-F743-4EFA-96D9-928846C110BB}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 8, "name": "NBGIS.GISDATA.WaterHydrantFieldInspect", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "DateInspected", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "LidWhite", "type": "esriFieldTypeString", "alias": "Lid to valve white?", "length": 10, "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" } }, { "name": "PaintedLid", "type": "esriFieldTypeString", "alias": "Painted lid white?", "length": 10, "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" } }, { "name": "AttachDechlorinator", "type": "esriFieldTypeString", "alias": "Attach dechlorinator?", "length": 10, "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" } }, { "name": "FlowStopValveOff", "type": "esriFieldTypeString", "alias": "Flow stops when isolation valve is off?", "length": 10, "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" } }, { "name": "FlowValveFlowClear", "type": "esriFieldTypeString", "alias": "Open Iso valve and flow until water clear?", "length": 10, "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" } }, { "name": "RenoveDechlorinator", "type": "esriFieldTypeString", "alias": "Remove dechlorinator?", "length": 10, "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" } }, { "name": "HydrantRust", "type": "esriFieldTypeString", "alias": "Inspect hydrant for rust?", "length": 10, "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" } }, { "name": "GreaseHydrant", "type": "esriFieldTypeString", "alias": "Grease threads to hydrant?", "length": 10, "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" } }, { "name": "PaintedHydrant", "type": "esriFieldTypeString", "alias": "Painted hydrant?", "length": 10, "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" } }, { "name": "ReplacePlasticCaps", "type": "esriFieldTypeString", "alias": "Replace plastic caps with bronze/iron caps?", "length": 10, "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" } }, { "name": "InspectHydrantNumber", "type": "esriFieldTypeString", "alias": "Inspect hydrant number?", "length": 10, "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" } }, { "name": "IsHydrantNumbered", "type": "esriFieldTypeString", "alias": "Is hydrant numbered?", "length": 10, "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" } }, { "name": "ReplaceHydrantNumber", "type": "esriFieldTypeString", "alias": "Replace hydrant number?", "length": 10, "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" } }, { "name": "InspectBlueDot", "type": "esriFieldTypeString", "alias": "Inspect blue dot?", "length": 10, "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" } }, { "name": "ReplaceBlueDot", "type": "esriFieldTypeString", "alias": "Replace blue dot?", "length": 10, "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" } }, { "name": "AdditionalComments", "type": "esriFieldTypeString", "alias": "Additional Comments", "length": 255, "domain": null }, { "name": "DateInspected", "type": "esriFieldTypeDate", "alias": "Date Inspected", "length": 8, "domain": null }, { "name": "GIS_TAG", "type": "esriFieldTypeString", "alias": "GIS_TAG", "length": 15, "domain": null }, { "name": "CREW_UPDATE_BY", "type": "esriFieldTypeString", "alias": "Crew Update", "length": 30, "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" } } ], "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": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "WaterHydrantMaintField", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "GIS_TAG", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{2BDAA51F-BEB8-4E7E-8947-FF57D0847CC8}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } } ] }