{ "layers": [ { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 1, "name": "WA_Meter", "type": "Feature Layer", "description": "Meters are instruments used to measure the quantity of water consumption by a customer for the purposes of billing.", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "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": [ 115, 133, 0, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -8539635.7548, "ymin": 4759904.835000001, "xmax": -8528247.2308, "ymax": 4773961.181999996, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 2, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 1.4892314192838538E8, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "TAG", "typeIdField": "METERTYPE", "subtypeFieldName": "METERTYPE", "subtypeField": "METERTYPE", "defaultSubtypeCode": 1, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "TAG", "type": "esriFieldTypeString", "alias": "Tag", "length": 15, "domain": null }, { "name": "DATEABANDONED", "type": "esriFieldTypeDate", "alias": "DATEABANDONED", "length": 8, "domain": null }, { "name": "LAST_ORGANIZATION", "type": "esriFieldTypeString", "alias": "LAST_ORGANIZATION", "length": 3, "domain": { "type": "codedValue", "name": "WA_VVT_Organization", "description": "", "codedValues": [ { "name": "Buchart Horn Inc", "code": "100" }, { "name": "Chesapeake Environmental Management Inc", "code": "110" }, { "name": "Enterprise Information Solutions, Inc.", "code": "120" }, { "name": "KCI Technologies, Inc.", "code": "130" }, { "name": "RKK", "code": "140" }, { "name": "Sanborn Colorado, LLC", "code": "150" }, { "name": "Johnson, Mirmiran & Thompson", "code": "160" }, { "name": "Metcaff & Eddy", "code": "170" }, { "name": "Ross Technical Services", "code": "180" }, { "name": "Russell Corrosion", "code": "190" }, { "name": "City of Baltimore", "code": "200" }, { "name": "Wachs Water Services", "code": "210" }, { "name": "EBA", "code": "220" }, { "name": "Unknown", "code": "UNK" }, { "name": "DM Enterprises", "code": "DME" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CAPTURE_METHOD", "type": "esriFieldTypeString", "alias": "CAPTURE_METHOD", "length": 4, "domain": { "type": "codedValue", "name": "WA_VVT_Capture_Method_1", "description": "", "codedValues": [ { "name": "Plat Map", "code": "PLAT" }, { "name": "Contract Drawing", "code": "CD" }, { "name": "Geometric Network", "code": "GN" }, { "name": "GPS", "code": "GPS" }, { "name": "Field Survey", "code": "SVY" }, { "name": "Laser GPS", "code": "LGPS" }, { "name": "Orthphoto Interpretation", "code": "ORTH" }, { "name": "Field Investigation/Inspection", "code": "FI" }, { "name": "Reported discrepancy", "code": "DISC" }, { "name": "Utility Viewer", "code": "UV" }, { "name": "Meter Installation", "code": "MI" }, { "name": "Geocoded", "code": "GEOC" }, { "name": "Manually estimated location", "code": "MANL" }, { "name": "As-Built", "code": "ASB" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LAST_USER", "type": "esriFieldTypeString", "alias": "LAST_USER", "length": 20, "domain": null }, { "name": "EDIT_DATE", "type": "esriFieldTypeDate", "alias": "EDIT_DATE", "length": 8, "domain": null }, { "name": "METER_NO", "type": "esriFieldTypeString", "alias": "METER_NO", "length": 10, "domain": null }, { "name": "MT_SIZE", "type": "esriFieldTypeDouble", "alias": "MT_SIZE", "domain": null }, { "name": "METER_TYPE_CD", "type": "esriFieldTypeString", "alias": "METER_TYPE_CD", "length": 1, "domain": { "type": "codedValue", "name": "WA_VVT_WSV_Meter_Type", "description": "", "codedValues": [ { "name": "Removed", "code": "2" }, { "name": "MFM-MVR", "code": "3" }, { "name": "Hersey MVR", "code": "4" }, { "name": "Flat Rate", "code": "6" }, { "name": "Sew Surchg", "code": "8" }, { "name": "Private", "code": "9" }, { "name": "Badger", "code": "B" }, { "name": "Battery", "code": "C" }, { "name": "Hersey EDC II", "code": "D" }, { "name": "Hersey EDC III", "code": "H" }, { "name": "Hersey FM", "code": "I" }, { "name": "Hersey DC", "code": "J" }, { "name": "Grinnel", "code": "L" }, { "name": "All Others", "code": "M" }, { "name": "Rockwell Comp", "code": "P" }, { "name": "MEM MCT", "code": "Q" }, { "name": "Rockwell Turbo", "code": "R" }, { "name": "Rockwell M", "code": "S" }, { "name": "Trident", "code": "T" }, { "name": "MFM Turbo", "code": "U" }, { "name": "Badger M", "code": "X" }, { "name": "Trident 8", "code": "Z" }, { "name": "Neptune-HPT", "code": "!" }, { "name": "Neptune T10 E-CDR", "code": "7" }, { "name": "AMCO", "code": "A" }, { "name": "Sensus SR 2", "code": "E" }, { "name": "Sensus SR ER", "code": "F" }, { "name": "Hersey MCT", "code": "G" }, { "name": "Neptune Compound", "code": "K" }, { "name": "Detector ICE", "code": "N" }, { "name": "Badger CMP", "code": "O" }, { "name": "Trident Turbo", "code": "W" }, { "name": "Unknown", "code": "0" }, { "name": "Neptune M", "code": "1" }, { "name": "Detector ER", "code": "V" }, { "name": "Sensus OMNI T", "code": "Y" }, { "name": "Hersey EDC IV", "code": "#" }, { "name": "Mueller FM3-MVR", "code": "$" }, { "name": "Sensus OMNI C", "code": "&" }, { "name": "Mueller FM2-MVR", "code": "5" }, { "name": "Neptune-SRII", "code": "@" }, { "name": "Sensus-OMNIC", "code": "%" }, { "name": "Sensus-Other", "code": "^" }, { "name": "Sensus-SRII", "code": "*" }, { "name": "Sensus-T10", "code": "=" }, { "name": "Sensus-ICE", "code": "+" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ACCOUNT_NO", "type": "esriFieldTypeString", "alias": "ACCOUNT_NO", "length": 15, "domain": null }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "INSTALL_DATE", "length": 8, "domain": null }, { "name": "METERTYPE", "type": "esriFieldTypeInteger", "alias": "METERTYPE", "domain": null }, { "name": "FEAT_STATUS", "type": "esriFieldTypeString", "alias": "FEAT_STATUS", "length": 3, "domain": { "type": "codedValue", "name": "WA_VVT_Feat_Status", "description": "", "codedValues": [ { "name": "Abandoned", "code": "ABD" }, { "name": "Active", "code": "ACT" }, { "name": "Proposed", "code": "PRO" }, { "name": "Under Construction", "code": "UC" }, { "name": "Removed", "code": "REM" }, { "name": "Replaced", "code": "REP" }, { "name": "Blinded Valve", "code": "BLD" }, { "name": "Could not locate in field", "code": "CNL" }, { "name": "Under Investigation", "code": "UI" }, { "name": "Proposed Abandonment", "code": "PAB" }, { "name": "Proposed Removal", "code": "PRM" }, { "name": "Proposed Replacement", "code": "PRP" }, { "name": "Proposed Upsizing", "code": "PUP" }, { "name": "Proposed Cleaning & Lining", "code": "PCL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "EnabledDomain", "description": "", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SERVICE_SIZE", "type": "esriFieldTypeDouble", "alias": "SERVICE_SIZE", "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 20, "domain": null }, { "name": "DOCPOPURL", "type": "esriFieldTypeString", "alias": "DOCPOPURL", "length": 250, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 120, "domain": null }, { "name": "IN_SCOPE", "type": "esriFieldTypeString", "alias": "IN_SCOPE", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PROJECT", "type": "esriFieldTypeString", "alias": "PROJECT", "length": 50, "domain": { "type": "codedValue", "name": "dProject", "description": "", "codedValues": [ { "name": "WC1291", "code": "1291" }, { "name": "WC1275", "code": "1275" }, { "name": "WC1287", "code": "1287" }, { "name": "WC1288", "code": "1288" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R36_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_36", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "types": [ { "domains": { "LAST_ORGANIZATION": {"type": "inherited"}, "CAPTURE_METHOD": {"type": "inherited"}, "METER_TYPE_CD": {"type": "inherited"}, "FEAT_STATUS": {"type": "inherited"}, "ENABLED": {"type": "inherited"}, "IN_SCOPE": {"type": "inherited"}, "PROJECT": {"type": "inherited"} }, "id": 1, "name": "DetectorCheck" }, { "domains": { "LAST_ORGANIZATION": {"type": "inherited"}, "CAPTURE_METHOD": {"type": "inherited"}, "METER_TYPE_CD": {"type": "inherited"}, "FEAT_STATUS": {"type": "inherited"}, "ENABLED": {"type": "inherited"}, "IN_SCOPE": {"type": "inherited"}, "PROJECT": {"type": "inherited"} }, "id": 2, "name": "Domestic" }, { "domains": { "LAST_ORGANIZATION": {"type": "inherited"}, "CAPTURE_METHOD": {"type": "inherited"}, "METER_TYPE_CD": {"type": "inherited"}, "FEAT_STATUS": {"type": "inherited"}, "ENABLED": {"type": "inherited"}, "IN_SCOPE": {"type": "inherited"}, "PROJECT": {"type": "inherited"} }, "id": 3, "name": "FM" }, { "domains": { "LAST_ORGANIZATION": {"type": "inherited"}, "CAPTURE_METHOD": {"type": "inherited"}, "METER_TYPE_CD": {"type": "inherited"}, "FEAT_STATUS": {"type": "inherited"}, "ENABLED": {"type": "inherited"}, "IN_SCOPE": {"type": "inherited"}, "PROJECT": {"type": "inherited"} }, "id": 7, "name": "LocationOnly" }, { "domains": { "LAST_ORGANIZATION": {"type": "inherited"}, "CAPTURE_METHOD": {"type": "inherited"}, "METER_TYPE_CD": {"type": "inherited"}, "FEAT_STATUS": {"type": "inherited"}, "ENABLED": {"type": "inherited"}, "IN_SCOPE": {"type": "inherited"}, "PROJECT": {"type": "inherited"} }, "id": 6, "name": "FlatRate" }, { "domains": { "LAST_ORGANIZATION": {"type": "inherited"}, "CAPTURE_METHOD": {"type": "inherited"}, "METER_TYPE_CD": {"type": "inherited"}, "FEAT_STATUS": {"type": "inherited"}, "ENABLED": {"type": "inherited"}, "IN_SCOPE": {"type": "inherited"}, "PROJECT": {"type": "inherited"} }, "id": 5, "name": "Removed" }, { "domains": { "LAST_ORGANIZATION": {"type": "inherited"}, "CAPTURE_METHOD": {"type": "inherited"}, "METER_TYPE_CD": {"type": "inherited"}, "FEAT_STATUS": {"type": "inherited"}, "ENABLED": {"type": "inherited"}, "IN_SCOPE": {"type": "inherited"}, "PROJECT": {"type": "inherited"} }, "id": 4, "name": "Venturi" } ], "subtypes": [ { "domains": { "LAST_ORGANIZATION": {"type": "inherited"}, "CAPTURE_METHOD": {"type": "inherited"}, "METER_TYPE_CD": {"type": "inherited"}, "FEAT_STATUS": {"type": "inherited"}, "ENABLED": {"type": "inherited"}, "IN_SCOPE": {"type": "inherited"}, "PROJECT": {"type": "inherited"} }, "defaultValues": { "TAG": null, "DATEABANDONED": null, "LAST_ORGANIZATION": null, "CAPTURE_METHOD": "PLAT", "LAST_USER": null, "EDIT_DATE": null, "METER_NO": null, "MT_SIZE": null, "METER_TYPE_CD": null, "ACCOUNT_NO": null, "INSTALL_DATE": null, "METERTYPE": 1, "FEAT_STATUS": "ACT", "ENABLED": 1, "SERVICE_SIZE": null, "FacilityID": null, "DOCPOPURL": null, "LOCATION": null, "IN_SCOPE": null, "PROJECT": null, "GlobalID": null }, "code": 1, "name": "DetectorCheck" }, { "domains": { "LAST_ORGANIZATION": {"type": "inherited"}, "CAPTURE_METHOD": {"type": "inherited"}, "METER_TYPE_CD": {"type": "inherited"}, "FEAT_STATUS": {"type": "inherited"}, "ENABLED": {"type": "inherited"}, "IN_SCOPE": {"type": "inherited"}, "PROJECT": {"type": "inherited"} }, "defaultValues": { "TAG": null, "DATEABANDONED": null, "LAST_ORGANIZATION": null, "CAPTURE_METHOD": "PLAT", "LAST_USER": null, "EDIT_DATE": null, "METER_NO": null, "MT_SIZE": null, "METER_TYPE_CD": null, "ACCOUNT_NO": null, "INSTALL_DATE": null, "METERTYPE": 2, "FEAT_STATUS": "ACT", "ENABLED": 1, "SERVICE_SIZE": null, "FacilityID": null, "DOCPOPURL": null, "LOCATION": null, "IN_SCOPE": null, "PROJECT": null, "GlobalID": null }, "code": 2, "name": "Domestic" }, { "domains": { "LAST_ORGANIZATION": {"type": "inherited"}, "CAPTURE_METHOD": {"type": "inherited"}, "METER_TYPE_CD": {"type": "inherited"}, "FEAT_STATUS": {"type": "inherited"}, "ENABLED": {"type": "inherited"}, "IN_SCOPE": {"type": "inherited"}, "PROJECT": {"type": "inherited"} }, "defaultValues": { "TAG": null, "DATEABANDONED": null, "LAST_ORGANIZATION": null, "CAPTURE_METHOD": "PLAT", "LAST_USER": null, "EDIT_DATE": null, "METER_NO": null, "MT_SIZE": null, "METER_TYPE_CD": null, "ACCOUNT_NO": null, "INSTALL_DATE": null, "METERTYPE": 3, "FEAT_STATUS": "ACT", "ENABLED": 1, "SERVICE_SIZE": null, "FacilityID": null, "DOCPOPURL": null, "LOCATION": null, "IN_SCOPE": null, "PROJECT": null, "GlobalID": null }, "code": 3, "name": "FM" }, { "domains": { "LAST_ORGANIZATION": {"type": "inherited"}, "CAPTURE_METHOD": {"type": "inherited"}, "METER_TYPE_CD": {"type": "inherited"}, "FEAT_STATUS": {"type": "inherited"}, "ENABLED": {"type": "inherited"}, "IN_SCOPE": {"type": "inherited"}, "PROJECT": {"type": "inherited"} }, "defaultValues": { "TAG": null, "DATEABANDONED": null, "LAST_ORGANIZATION": null, "CAPTURE_METHOD": "PLAT", "LAST_USER": null, "EDIT_DATE": null, "METER_NO": null, "MT_SIZE": null, "METER_TYPE_CD": null, "ACCOUNT_NO": null, "INSTALL_DATE": null, "METERTYPE": 7, "FEAT_STATUS": "ACT", "ENABLED": 1, "SERVICE_SIZE": null, "FacilityID": null, "DOCPOPURL": null, "LOCATION": null, "IN_SCOPE": null, "PROJECT": null, "GlobalID": null }, "code": 7, "name": "LocationOnly" }, { "domains": { "LAST_ORGANIZATION": {"type": "inherited"}, "CAPTURE_METHOD": {"type": "inherited"}, "METER_TYPE_CD": {"type": "inherited"}, "FEAT_STATUS": {"type": "inherited"}, "ENABLED": {"type": "inherited"}, "IN_SCOPE": {"type": "inherited"}, "PROJECT": {"type": "inherited"} }, "defaultValues": { "TAG": null, "DATEABANDONED": null, "LAST_ORGANIZATION": null, "CAPTURE_METHOD": "PLAT", "LAST_USER": null, "EDIT_DATE": null, "METER_NO": null, "MT_SIZE": null, "METER_TYPE_CD": null, "ACCOUNT_NO": null, "INSTALL_DATE": null, "METERTYPE": 6, "FEAT_STATUS": "ACT", "ENABLED": 1, "SERVICE_SIZE": null, "FacilityID": null, "DOCPOPURL": null, "LOCATION": null, "IN_SCOPE": null, "PROJECT": null, "GlobalID": null }, "code": 6, "name": "FlatRate" }, { "domains": { "LAST_ORGANIZATION": {"type": "inherited"}, "CAPTURE_METHOD": {"type": "inherited"}, "METER_TYPE_CD": {"type": "inherited"}, "FEAT_STATUS": {"type": "inherited"}, "ENABLED": {"type": "inherited"}, "IN_SCOPE": {"type": "inherited"}, "PROJECT": {"type": "inherited"} }, "defaultValues": { "TAG": null, "DATEABANDONED": null, "LAST_ORGANIZATION": null, "CAPTURE_METHOD": "PLAT", "LAST_USER": null, "EDIT_DATE": null, "METER_NO": null, "MT_SIZE": null, "METER_TYPE_CD": null, "ACCOUNT_NO": null, "INSTALL_DATE": null, "METERTYPE": 5, "FEAT_STATUS": "ABD", "ENABLED": 0, "SERVICE_SIZE": null, "FacilityID": null, "DOCPOPURL": null, "LOCATION": null, "IN_SCOPE": null, "PROJECT": null, "GlobalID": null }, "code": 5, "name": "Removed" }, { "domains": { "LAST_ORGANIZATION": {"type": "inherited"}, "CAPTURE_METHOD": {"type": "inherited"}, "METER_TYPE_CD": {"type": "inherited"}, "FEAT_STATUS": {"type": "inherited"}, "ENABLED": {"type": "inherited"}, "IN_SCOPE": {"type": "inherited"}, "PROJECT": {"type": "inherited"} }, "defaultValues": { "TAG": null, "DATEABANDONED": null, "LAST_ORGANIZATION": null, "CAPTURE_METHOD": "PLAT", "LAST_USER": null, "EDIT_DATE": null, "METER_NO": null, "MT_SIZE": null, "METER_TYPE_CD": null, "ACCOUNT_NO": null, "INSTALL_DATE": null, "METERTYPE": 4, "FEAT_STATUS": "ACT", "ENABLED": 1, "SERVICE_SIZE": null, "FacilityID": null, "DOCPOPURL": null, "LOCATION": null, "IN_SCOPE": null, "PROJECT": null, "GlobalID": null }, "code": 4, "name": "Venturi" } ], "relationships": [ { "id": 0, "name": "", "relatedTableId": 7, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "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}, "advancedQueryCapabilities": { "useStandardizedQueries": false, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 2, "name": "WA_Hydrant", "type": "Feature Layer", "description": "A hydrant is composed of a discharge pipe with a valve and a spout at which water may be drawn from a water main as for fighting fires.", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "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": [ 163, 0, 120, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -8539569.4022, "ymin": 4760038.8957, "xmax": -8528188.2824, "ymax": 4773982.085900001, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 2, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 1.4892314192838538E8, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "STREET_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "MANUF_MODEL_CD", "type": "esriFieldTypeSmallInteger", "alias": "MANUF_MODEL_CD", "domain": { "type": "codedValue", "name": "WA_VVT_WHY_Manuf_Model", "description": "", "codedValues": [ { "name": "AMER_DARLING--B62B", "code": 1 }, { "name": "AMER_DARLING--UNK", "code": 2 }, { "name": "AP_SMITH--BALT_STD_2_PORT", "code": 3 }, { "name": "AP_SMITH--BALT_STD_3_PORT", "code": 4 }, { "name": "AP_SMITH--UNK", "code": 5 }, { "name": "DRESSER--929", "code": 6 }, { "name": "DRESSER--UNK", "code": 7 }, { "name": "KENNEDY--K81A", "code": 8 }, { "name": "KENNEDY--UNK", "code": 9 }, { "name": "M&H--929", "code": 10 }, { "name": "M&H--UNK", "code": 11 }, { "name": "MUELLER--ASR", "code": 12 }, { "name": "MUELLER--BSR", "code": 13 }, { "name": "MUELLER--UNK", "code": 14 }, { "name": "US_PIPE--BALT_STD_2_PORT", "code": 15 }, { "name": "US_PIPE--BALT_STD_3_PORT", "code": 16 }, { "name": "US_PIPE--UNK", "code": 17 }, { "name": "WATEROUS--PACER", "code": 18 }, { "name": "WATEROUS--UNK", "code": 19 }, { "name": "UNKNOWN", "code": 20 }, { "name": "OTHER, SEE FIELD NOTES", "code": 21 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LOCK_MODEL_CD", "type": "esriFieldTypeString", "alias": "LOCK_MODEL_CD", "length": 3, "domain": { "type": "codedValue", "name": "WA_VVT_WHY_Lock_Model", "description": "", "codedValues": [ { "name": "Unknown", "code": "UNK" }, { "name": "McGard", "code": "MCG" }, { "name": "Recessed Op Nut", "code": "RON" }, { "name": "Spanner Cap", "code": "SPC" }, { "name": "Multiple", "code": "MLT" }, { "name": "Other", "code": "OTH" }, { "name": "NONE", "code": "NON" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LAT_SIZE", "type": "esriFieldTypeDouble", "alias": "LAT_SIZE", "domain": { "type": "codedValue", "name": "WA_VVT_Pipe_Size", "description": "", "codedValues": [ { "name": "0.75\"", "code": 0.75 }, { "name": "1\"", "code": 1 }, { "name": "1.5\"", "code": 1.5 }, { "name": "2\"", "code": 2 }, { "name": "2.5\"", "code": 2.5 }, { "name": "3\"", "code": 3 }, { "name": "3.5\"", "code": 3.5 }, { "name": "4\"", "code": 4 }, { "name": "4.5\"", "code": 4.5 }, { "name": "5\"", "code": 5 }, { "name": "6\"", "code": 6 }, { "name": "8\"", "code": 8 }, { "name": "9\"", "code": 9 }, { "name": "10\"", "code": 10 }, { "name": "12\"", "code": 12 }, { "name": "14\"", "code": 14 }, { "name": "16\"", "code": 16 }, { "name": "18\"", "code": 18 }, { "name": "20\"", "code": 20 }, { "name": "24\"", "code": 24 }, { "name": "30\"", "code": 30 }, { "name": "34\"", "code": 34 }, { "name": "36\"", "code": 36 }, { "name": "40\"", "code": 40 }, { "name": "42\"", "code": 42 }, { "name": "48\"", "code": 48 }, { "name": "54\"", "code": 54 }, { "name": "60\"", "code": 60 }, { "name": "66\"", "code": 66 }, { "name": "72\"", "code": 72 }, { "name": "78\"", "code": 78 }, { "name": "84\"", "code": 84 }, { "name": "96\"", "code": 96 }, { "name": "108\"", "code": 108 }, { "name": "114\"", "code": 114 }, { "name": "120\"", "code": 120 }, { "name": "126\"", "code": 126 }, { "name": "132\"", "code": 132 }, { "name": "138\"", "code": 138 }, { "name": "144\"", "code": 144 }, { "name": "Unknown", "code": 0 }, { "name": "Could Not Determine", "code": 999 }, { "name": "92\"", "code": 92 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SRC_MAIN_SIZE", "type": "esriFieldTypeDouble", "alias": "SRC_MAIN_SIZE", "domain": { "type": "codedValue", "name": "WA_VVT_Pipe_Size", "description": "", "codedValues": [ { "name": "0.75\"", "code": 0.75 }, { "name": "1\"", "code": 1 }, { "name": "1.5\"", "code": 1.5 }, { "name": "2\"", "code": 2 }, { "name": "2.5\"", "code": 2.5 }, { "name": "3\"", "code": 3 }, { "name": "3.5\"", "code": 3.5 }, { "name": "4\"", "code": 4 }, { "name": "4.5\"", "code": 4.5 }, { "name": "5\"", "code": 5 }, { "name": "6\"", "code": 6 }, { "name": "8\"", "code": 8 }, { "name": "9\"", "code": 9 }, { "name": "10\"", "code": 10 }, { "name": "12\"", "code": 12 }, { "name": "14\"", "code": 14 }, { "name": "16\"", "code": 16 }, { "name": "18\"", "code": 18 }, { "name": "20\"", "code": 20 }, { "name": "24\"", "code": 24 }, { "name": "30\"", "code": 30 }, { "name": "34\"", "code": 34 }, { "name": "36\"", "code": 36 }, { "name": "40\"", "code": 40 }, { "name": "42\"", "code": 42 }, { "name": "48\"", "code": 48 }, { "name": "54\"", "code": 54 }, { "name": "60\"", "code": 60 }, { "name": "66\"", "code": 66 }, { "name": "72\"", "code": 72 }, { "name": "78\"", "code": 78 }, { "name": "84\"", "code": 84 }, { "name": "96\"", "code": 96 }, { "name": "108\"", "code": 108 }, { "name": "114\"", "code": 114 }, { "name": "120\"", "code": 120 }, { "name": "126\"", "code": 126 }, { "name": "132\"", "code": 132 }, { "name": "138\"", "code": 138 }, { "name": "144\"", "code": 144 }, { "name": "Unknown", "code": 0 }, { "name": "Could Not Determine", "code": 999 }, { "name": "92\"", "code": 92 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PRESSURE_ZONE", "type": "esriFieldTypeString", "alias": "PRESSURE_ZONE", "length": 4, "domain": { "type": "codedValue", "name": "WA_VVT_Pressure_Zone", "description": "", "codedValues": [ { "name": "First", "code": "1" }, { "name": "Second", "code": "2" }, { "name": "Colgate Second", "code": "2C" }, { "name": "Eastern Third", "code": "3E" }, { "name": "Western Third", "code": "3W" }, { "name": "Catonsville Fourth", "code": "4C" }, { "name": "Glenarm Fourth", "code": "4G" }, { "name": "Pikesville Fourth", "code": "4P" }, { "name": "Towson Fourth", "code": "4T" }, { "name": "Falls Fifth", "code": "5F" }, { "name": "Hereford Fifth", "code": "5H" }, { "name": "Jacksonville Fifth", "code": "5J" }, { "name": "Pot Spring Fifth", "code": "5PS" }, { "name": "Reisterstown Fifth", "code": "5R" }, { "name": "Sherwood Fifth", "code": "5SH" }, { "name": "Sparks Fifth", "code": "5SP" }, { "name": "Worthington Fifth", "code": "5W" }, { "name": "Could Not Determine", "code": "CND" }, { "name": "Unknown", "code": "UNK" }, { "name": "NA - Raw Water Conduit", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "BREAKAWAY", "type": "esriFieldTypeString", "alias": "BREAKAWAY", "length": 3, "domain": { "type": "codedValue", "name": "WA_VVT_WHY_BreakAway", "description": "", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "Could Not Determine", "code": "CND" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FEAT_STATUS", "type": "esriFieldTypeString", "alias": "FEAT_STATUS", "length": 3, "domain": { "type": "codedValue", "name": "WA_VVT_Feat_Status", "description": "", "codedValues": [ { "name": "Abandoned", "code": "ABD" }, { "name": "Active", "code": "ACT" }, { "name": "Proposed", "code": "PRO" }, { "name": "Under Construction", "code": "UC" }, { "name": "Removed", "code": "REM" }, { "name": "Replaced", "code": "REP" }, { "name": "Blinded Valve", "code": "BLD" }, { "name": "Could not locate in field", "code": "CNL" }, { "name": "Under Investigation", "code": "UI" }, { "name": "Proposed Abandonment", "code": "PAB" }, { "name": "Proposed Removal", "code": "PRM" }, { "name": "Proposed Replacement", "code": "PRP" }, { "name": "Proposed Upsizing", "code": "PUP" }, { "name": "Proposed Cleaning & Lining", "code": "PCL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "ENABLED", "domain": { "type": "codedValue", "name": "EnabledDomain", "description": "", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "RESP_AGENCY", "type": "esriFieldTypeString", "alias": "RESP_AGENCY", "length": 4, "domain": { "type": "codedValue", "name": "WA_VVT_Owner_Info", "description": "", "codedValues": [ { "name": "DPW", "code": "DPW" }, { "name": "Non-DPW", "code": "NDPW" }, { "name": "Anne Arundel", "code": "AA" }, { "name": "Baltimore City", "code": "BCI" }, { "name": "Baltimore County", "code": "BCO" }, { "name": "Company Owned", "code": "CO" }, { "name": "Jointly Owned", "code": "JO" }, { "name": "State of Maryland", "code": "MD" }, { "name": "Could Not Determine", "code": "CND" }, { "name": "Unknown", "code": "UNK" }, { "name": "Harford County", "code": "HAR" }, { "name": "Privately Owned", "code": "PRI" }, { "name": "Howard County", "code": "HOW" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LAST_ORGANIZATION", "type": "esriFieldTypeString", "alias": "LAST_ORGANIZATION", "length": 3, "domain": { "type": "codedValue", "name": "WA_VVT_Organization", "description": "", "codedValues": [ { "name": "Buchart Horn Inc", "code": "100" }, { "name": "Chesapeake Environmental Management Inc", "code": "110" }, { "name": "Enterprise Information Solutions, Inc.", "code": "120" }, { "name": "KCI Technologies, Inc.", "code": "130" }, { "name": "RKK", "code": "140" }, { "name": "Sanborn Colorado, LLC", "code": "150" }, { "name": "Johnson, Mirmiran & Thompson", "code": "160" }, { "name": "Metcaff & Eddy", "code": "170" }, { "name": "Ross Technical Services", "code": "180" }, { "name": "Russell Corrosion", "code": "190" }, { "name": "City of Baltimore", "code": "200" }, { "name": "Wachs Water Services", "code": "210" }, { "name": "EBA", "code": "220" }, { "name": "Unknown", "code": "UNK" }, { "name": "DM Enterprises", "code": "DME" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CAPTURE_METHOD", "type": "esriFieldTypeString", "alias": "CAPTURE_METHOD", "length": 4, "domain": { "type": "codedValue", "name": "WA_VVT_Capture_Method_1", "description": "", "codedValues": [ { "name": "Plat Map", "code": "PLAT" }, { "name": "Contract Drawing", "code": "CD" }, { "name": "Geometric Network", "code": "GN" }, { "name": "GPS", "code": "GPS" }, { "name": "Field Survey", "code": "SVY" }, { "name": "Laser GPS", "code": "LGPS" }, { "name": "Orthphoto Interpretation", "code": "ORTH" }, { "name": "Field Investigation/Inspection", "code": "FI" }, { "name": "Reported discrepancy", "code": "DISC" }, { "name": "Utility Viewer", "code": "UV" }, { "name": "Meter Installation", "code": "MI" }, { "name": "Geocoded", "code": "GEOC" }, { "name": "Manually estimated location", "code": "MANL" }, { "name": "As-Built", "code": "ASB" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LAST_USER", "type": "esriFieldTypeString", "alias": "LAST_USER", "length": 20, "domain": null }, { "name": "TAG", "type": "esriFieldTypeString", "alias": "TAG", "length": 15, "domain": null }, { "name": "DATEABANDONED", "type": "esriFieldTypeDate", "alias": "DATEABANDONED", "length": 8, "domain": null }, { "name": "EDIT_DATE", "type": "esriFieldTypeDate", "alias": "EDIT_DATE", "length": 8, "domain": null }, { "name": "HYDRANT_ID", "type": "esriFieldTypeString", "alias": "HYDRANT_ID", "length": 15, "domain": null }, { "name": "STATIC_PRESSURE", "type": "esriFieldTypeDouble", "alias": "STATIC_PRESSURE", "domain": null }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "INSTALL_DATE", "length": 8, "domain": null }, { "name": "OPER_DATE", "type": "esriFieldTypeDate", "alias": "OPER_DATE", "length": 8, "domain": null }, { "name": "FAB_DATE", "type": "esriFieldTypeDate", "alias": "FAB_DATE", "length": 8, "domain": null }, { "name": "BURY", "type": "esriFieldTypeDouble", "alias": "BURY", "domain": null }, { "name": "MAX_FLOW_RATE", "type": "esriFieldTypeDouble", "alias": "MAX_FLOW_RATE", "domain": null }, { "name": "EDIT_COMMENT", "type": "esriFieldTypeString", "alias": "EDIT_COMMENT", "length": 255, "domain": null }, { "name": "CITY_ENUM", "type": "esriFieldTypeString", "alias": "CITY_ENUM", "length": 6, "domain": null }, { "name": "DOCPOPURL", "type": "esriFieldTypeString", "alias": "DOCPOPURL", "length": 300, "domain": null }, { "name": "ELEVATION", "type": "esriFieldTypeDouble", "alias": "ELEVATION", "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 20, "domain": null }, { "name": "BFD_FIELDCHECK_DATE", "type": "esriFieldTypeDate", "alias": "BFD_FIELDCHECK_DATE", "length": 8, "domain": null }, { "name": "BFD_FIELDCHECK_STATUS", "type": "esriFieldTypeSmallInteger", "alias": "BFD_FIELDCHECK_STATUS", "domain": { "type": "codedValue", "name": "BFD_FIELDCHECK_STATUS", "description": "", "codedValues": [ { "name": "Hydrant does not exist", "code": 0 }, { "name": "Hydrant exists", "code": 1 }, { "name": "Hydrant needs field check", "code": 2 }, { "name": "Sent to fire department for field check", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LOCATION_TYPE", "type": "esriFieldTypeString", "alias": "LOCATION_TYPE", "length": 50, "domain": { "type": "codedValue", "name": "WA_HYDLocationType", "description": "", "codedValues": [ { "name": "INTERSECTION", "code": "INT" }, { "name": "ADDRESS", "code": "ADDR" }, { "name": "BLOCK", "code": "BLK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "STREET_NUM", "type": "esriFieldTypeString", "alias": "STREET_NUM", "length": 50, "domain": null }, { "name": "STREET_NAME", "type": "esriFieldTypeString", "alias": "STREET_NAME", "length": 255, "domain": null }, { "name": "CAD_ADDR", "type": "esriFieldTypeString", "alias": "CAD_ADDR", "length": 255, "domain": null }, { "name": "CROSS_STREET", "type": "esriFieldTypeString", "alias": "CROSS_STREET", "length": 255, "domain": null }, { "name": "CORNER_POSITION", "type": "esriFieldTypeString", "alias": "CORNER_POSITION", "length": 50, "domain": { "type": "codedValue", "name": "WA_Cardinal_Direction", "description": "", "codedValues": [ { "name": "NE", "code": "NE" }, { "name": "SE", "code": "SE" }, { "name": "NW", "code": "NW" }, { "name": "SW", "code": "SW" }, { "name": "N", "code": "N" }, { "name": "S", "code": "S" }, { "name": "E", "code": "E" }, { "name": "W", "code": "W" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LOCATION_DESCRIPTION", "type": "esriFieldTypeString", "alias": "LOCATION_DESCRIPTION", "length": 50, "domain": null }, { "name": "DISTRICT", "type": "esriFieldTypeString", "alias": "DISTRICT", "length": 6, "domain": null }, { "name": "HYDR_ZONE", "type": "esriFieldTypeInteger", "alias": "HYDR_ZONE", "domain": null }, { "name": "LOCATION_DESCRIPTION2", "type": "esriFieldTypeString", "alias": "LOCATION_DESCRIPTION2", "length": 255, "domain": null }, { "name": "IN_SCOPE", "type": "esriFieldTypeString", "alias": "IN_SCOPE", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PROJECT", "type": "esriFieldTypeString", "alias": "PROJECT", "length": 50, "domain": { "type": "codedValue", "name": "dProject", "description": "", "codedValues": [ { "name": "WC1291", "code": "1291" }, { "name": "WC1275", "code": "1275" }, { "name": "WC1287", "code": "1287" }, { "name": "WC1288", "code": "1288" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R37_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_37", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "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}, "advancedQueryCapabilities": { "useStandardizedQueries": false, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 0, "name": "WA_Valve", "type": "Feature Layer", "description": "Valves used to regulate flow and isolate portions of the collection system.", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "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": [ 150, 143, 0, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -8539603.2199, "ymin": 4760024.961099997, "xmax": -8528183.072, "ymax": 4773991.601999998, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 2, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 1.4892314192838538E8, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "MANUF_CD", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "VALVE_USE", "type": "esriFieldTypeInteger", "alias": "VALVE_USE", "domain": { "type": "codedValue", "name": "WA_VVT_SystemValve_Use", "description": "", "codedValues": [ { "name": "Division Valve", "code": 2 }, { "name": "Shutoff Valve", "code": 5 }, { "name": "Hydrant Lead Valve", "code": 8 }, { "name": "Stub Valve", "code": 9 }, { "name": "In-Line Valve", "code": 12 }, { "name": "Fire Service Valve", "code": 13 }, { "name": "Domestic Service Less Than 2 Inch", "code": 14 }, { "name": "Domestic Service Greater Than 2 Inch", "code": 15 }, { "name": "Combined Fire and Domestic Service Valve", "code": 16 }, { "name": "Unknown", "code": 17 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MANUF_CD", "type": "esriFieldTypeString", "alias": "MANUF_CD", "length": 3, "domain": { "type": "codedValue", "name": "WA_VVT_WVL_Manuf", "description": "", "codedValues": [ { "name": "American Flow Control / ACIPCO", "code": "AFC" }, { "name": "American Darling", "code": "AMD" }, { "name": "Ames", "code": "AMS" }, { "name": "American AVK Co", "code": "AVK" }, { "name": "A. Y. McDonald Mfg Co", "code": "AYM" }, { "name": "Chapman", "code": "CHP" }, { "name": "Conbraco Industries Inc", "code": "CII" }, { "name": "Clow", "code": "CLO" }, { "name": "Crane", "code": "CRA" }, { "name": "Dresser", "code": "DRE" }, { "name": "East Jordan Iron Works Inc", "code": "EJI" }, { "name": "Golden Anderson", "code": "GAN" }, { "name": "Joseph G. Pollard Co Inc", "code": "JGP" }, { "name": "James Jones", "code": "JJ" }, { "name": "Jones", "code": "JON" }, { "name": "Kennedy", "code": "KEN" }, { "name": "Lindsey", "code": "LIN" }, { "name": "M and H", "code": "MH" }, { "name": "Mueller", "code": "MUE" }, { "name": "Pont-A-Mouson S.A.", "code": "PAM" }, { "name": "Pratt", "code": "PRT" }, { "name": "RMI Holland B.V.", "code": "RMI" }, { "name": "Trumbull Industries Inc", "code": "TII" }, { "name": "Tyler Pipe Industries", "code": "TPI" }, { "name": "US Pipe", "code": "USP" }, { "name": "Wilkins Div. Zurn Industries", "code": "WDZ" }, { "name": "Watts Regulator Co", "code": "WRC" }, { "name": "Stockholm Valves and Fittings", "code": "SVF" }, { "name": "Could Not Determine", "code": "CND" }, { "name": "Unknown", "code": "UNK" }, { "name": "Allis Chalmers", "code": "ALC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VLV_SIZE", "type": "esriFieldTypeDouble", "alias": "VLV_SIZE", "domain": { "type": "codedValue", "name": "WA_VVT_WVL_Size", "description": "", "codedValues": [ { "name": "0.75\"", "code": 0.75 }, { "name": "1\"", "code": 1 }, { "name": "1.5\"", "code": 1.5 }, { "name": "2\"", "code": 2 }, { "name": "2.5\"", "code": 2.5 }, { "name": "3\"", "code": 3 }, { "name": "3.5\"", "code": 3.5 }, { "name": "4\"", "code": 4 }, { "name": "5\"", "code": 5 }, { "name": "6\"", "code": 6 }, { "name": "8\"", "code": 8 }, { "name": "9\"", "code": 9 }, { "name": "10\"", "code": 10 }, { "name": "12\"", "code": 12 }, { "name": "14\"", "code": 14 }, { "name": "16\"", "code": 16 }, { "name": "18\"", "code": 18 }, { "name": "20\"", "code": 20 }, { "name": "24\"", "code": 24 }, { "name": "30\"", "code": 30 }, { "name": "34\"", "code": 34 }, { "name": "36\"", "code": 36 }, { "name": "40\"", "code": 40 }, { "name": "42\"", "code": 42 }, { "name": "48\"", "code": 48 }, { "name": "54\"", "code": 54 }, { "name": "60\"", "code": 60 }, { "name": "66\"", "code": 66 }, { "name": "72\"", "code": 72 }, { "name": "84\"", "code": 84 }, { "name": "96\"", "code": 96 }, { "name": "108\"", "code": 108 }, { "name": "114\"", "code": 114 }, { "name": "120\"", "code": 120 }, { "name": "126\"", "code": 126 }, { "name": "132\"", "code": 132 }, { "name": "138\"", "code": 138 }, { "name": "144\"", "code": 144 }, { "name": "Unknown", "code": 0 }, { "name": "Could Not Determine", "code": 999 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VLV_CLOSE_DIR", "type": "esriFieldTypeString", "alias": "VLV_CLOSE_DIR", "length": 3, "domain": { "type": "codedValue", "name": "WA_VVT_WVL_Close_Dir", "description": "", "codedValues": [ { "name": "Clockwise", "code": "CW" }, { "name": "Counter-Clockwise", "code": "CCW" }, { "name": "Could Not Determine", "code": "CND" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "STRUCTURE", "type": "esriFieldTypeString", "alias": "STRUCTURE", "length": 3, "domain": { "type": "codedValue", "name": "WA_VVT_Structure", "description": "", "codedValues": [ { "name": "Roadway Box", "code": "RBX" }, { "name": "Vault", "code": "VLT" }, { "name": "Other", "code": "OTH" }, { "name": "Could Not Determine", "code": "CND" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FEAT_STATUS", "type": "esriFieldTypeString", "alias": "FEAT_STATUS", "length": 3, "domain": { "type": "codedValue", "name": "WA_VVT_Feat_Status", "description": "", "codedValues": [ { "name": "Abandoned", "code": "ABD" }, { "name": "Active", "code": "ACT" }, { "name": "Proposed", "code": "PRO" }, { "name": "Under Construction", "code": "UC" }, { "name": "Removed", "code": "REM" }, { "name": "Replaced", "code": "REP" }, { "name": "Blinded Valve", "code": "BLD" }, { "name": "Could not locate in field", "code": "CNL" }, { "name": "Under Investigation", "code": "UI" }, { "name": "Proposed Abandonment", "code": "PAB" }, { "name": "Proposed Removal", "code": "PRM" }, { "name": "Proposed Replacement", "code": "PRP" }, { "name": "Proposed Upsizing", "code": "PUP" }, { "name": "Proposed Cleaning & Lining", "code": "PCL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CONDITION", "type": "esriFieldTypeString", "alias": "CONDITION", "length": 15, "domain": { "type": "codedValue", "name": "VALVE_CONDITION", "description": "", "codedValues": [ { "name": "FAIR", "code": "F" }, { "name": "GOOD", "code": "G" }, { "name": "INOPERABLE", "code": "IO" }, { "name": "NOT APPLICABLE", "code": "NA" }, { "name": "POOR", "code": "POR" }, { "name": "UNKNOWN", "code": "UNK" }, { "name": "DID NOT OPERATE", "code": "DNO" }, { "name": "OPERABLE", "code": "O" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LAST_ORGANIZATION", "type": "esriFieldTypeString", "alias": "LAST_ORGANIZATION", "length": 3, "domain": { "type": "codedValue", "name": "WA_VVT_Organization", "description": "", "codedValues": [ { "name": "Buchart Horn Inc", "code": "100" }, { "name": "Chesapeake Environmental Management Inc", "code": "110" }, { "name": "Enterprise Information Solutions, Inc.", "code": "120" }, { "name": "KCI Technologies, Inc.", "code": "130" }, { "name": "RKK", "code": "140" }, { "name": "Sanborn Colorado, LLC", "code": "150" }, { "name": "Johnson, Mirmiran & Thompson", "code": "160" }, { "name": "Metcaff & Eddy", "code": "170" }, { "name": "Ross Technical Services", "code": "180" }, { "name": "Russell Corrosion", "code": "190" }, { "name": "City of Baltimore", "code": "200" }, { "name": "Wachs Water Services", "code": "210" }, { "name": "EBA", "code": "220" }, { "name": "Unknown", "code": "UNK" }, { "name": "DM Enterprises", "code": "DME" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CAPTURE_METHOD", "type": "esriFieldTypeString", "alias": "CAPTURE_METHOD", "length": 4, "domain": { "type": "codedValue", "name": "WA_VVT_Capture_Method_1", "description": "", "codedValues": [ { "name": "Plat Map", "code": "PLAT" }, { "name": "Contract Drawing", "code": "CD" }, { "name": "Geometric Network", "code": "GN" }, { "name": "GPS", "code": "GPS" }, { "name": "Field Survey", "code": "SVY" }, { "name": "Laser GPS", "code": "LGPS" }, { "name": "Orthphoto Interpretation", "code": "ORTH" }, { "name": "Field Investigation/Inspection", "code": "FI" }, { "name": "Reported discrepancy", "code": "DISC" }, { "name": "Utility Viewer", "code": "UV" }, { "name": "Meter Installation", "code": "MI" }, { "name": "Geocoded", "code": "GEOC" }, { "name": "Manually estimated location", "code": "MANL" }, { "name": "As-Built", "code": "ASB" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LAST_USER", "type": "esriFieldTypeString", "alias": "LAST_USER", "length": 20, "domain": null }, { "name": "TAG", "type": "esriFieldTypeString", "alias": "TAG", "length": 15, "domain": null }, { "name": "DATEABANDONED", "type": "esriFieldTypeDate", "alias": "DATEABANDONED", "length": 8, "domain": null }, { "name": "EDIT_DATE", "type": "esriFieldTypeDate", "alias": "EDIT_DATE", "length": 8, "domain": null }, { "name": "VLV_ID", "type": "esriFieldTypeString", "alias": "VLV_ID", "length": 15, "domain": null }, { "name": "COVER_DEPTH", "type": "esriFieldTypeDouble", "alias": "COVER_DEPTH", "domain": null }, { "name": "OPNUT_DEPTH", "type": "esriFieldTypeDouble", "alias": "OPNUT_DEPTH", "domain": null }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "INSTALL_DATE", "length": 8, "domain": null }, { "name": "DATE_OPERATED", "type": "esriFieldTypeDate", "alias": "DATE_OPERATED", "length": 8, "domain": null }, { "name": "DOCPOPURL", "type": "esriFieldTypeString", "alias": "DOCPOPURL", "length": 1073741822, "domain": null }, { "name": "BYP_VALVE_PRESENT", "type": "esriFieldTypeSmallInteger", "alias": "BYP_VALVE_PRESENT", "domain": { "type": "codedValue", "name": "Boolean", "description": "", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ELEVATION", "type": "esriFieldTypeDouble", "alias": "ELEVATION", "domain": null }, { "name": "MAX_TURNS", "type": "esriFieldTypeDouble", "alias": "MAX_TURNS", "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": "esriSPTDuplicate" } }, { "name": "MAXIMUM_MAX_TORQUE", "type": "esriFieldTypeDouble", "alias": "MAXIMUM_MAX_TORQUE", "domain": null }, { "name": "ORIENTATION", "type": "esriFieldTypeString", "alias": "ORIENTATION", "length": 20, "domain": { "type": "codedValue", "name": "GATE_ORIENTATION", "description": "", "codedValues": [ { "name": "VERTICAL", "code": "VERTICAL" }, { "name": "HORIZONTAL", "code": "HORIZONTAL" }, { "name": "NOT APPLICABLE", "code": "NOT APPLICABLE" }, { "name": "UNKNOWN", "code": "UNKNOWN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VALVE_TYPE", "type": "esriFieldTypeString", "alias": "VALVE_TYPE", "length": 20, "domain": { "type": "codedValue", "name": "VALVE_TYPE", "description": "", "codedValues": [ { "name": "GATE NOT GEARED", "code": "GATE NOT GEARED" }, { "name": "INTERNAL GEARED GATE", "code": "INTERNAL GEARED GATE" }, { "name": "EXTERNAL GEARED GATE", "code": "EXTERNAL GEARED GATE" }, { "name": "GATE NOT GEARED RESILIENT WEDGE", "code": "GATE NOT GEARED RW" }, { "name": "INTERNAL GEARED GATE RESILIENT WEDGE", "code": "INTERN GEAR GATE RW" }, { "name": "BUTTERFLY", "code": "BUTTERFLY" }, { "name": "BALL", "code": "BALL" }, { "name": "CHECK", "code": "CHECK VALVE" }, { "name": "CONE", "code": "CONE" }, { "name": "UNKNOWN", "code": "UNKNOWN" }, { "name": "RISING STEM", "code": "RISING STEM" }, { "name": "OTHER", "code": "OTHER" }, { "name": "BLINDED", "code": "BLINDED" }, { "name": "NOT APPLICABLE", "code": "NOT APPLICABLE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CITY_ENUM", "type": "esriFieldTypeString", "alias": "CITY_ENUM", "length": 10, "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 20, "domain": null }, { "name": "MAXIMUM_FINAL_TORQUE", "type": "esriFieldTypeDouble", "alias": "MAXIMUM_FINAL_TORQUE", "domain": null }, { "name": "BYP_MAX_TURNS", "type": "esriFieldTypeDouble", "alias": "BYP_MAX_TURNS", "domain": null }, { "name": "POSITION_LEFT", "type": "esriFieldTypeString", "alias": "POSITION_LEFT", "length": 20, "domain": null }, { "name": "FROZEN", "type": "esriFieldTypeString", "alias": "FROZEN", "length": 20, "domain": null }, { "name": "EXERCISE", "type": "esriFieldTypeString", "alias": "EXERCISE", "length": 20, "domain": null }, { "name": "ACCESS", "type": "esriFieldTypeString", "alias": "ACCESS", "length": 20, "domain": null }, { "name": "IN_SCOPE", "type": "esriFieldTypeString", "alias": "IN_SCOPE", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PROJECT", "type": "esriFieldTypeString", "alias": "PROJECT", "length": 50, "domain": { "type": "codedValue", "name": "dProject", "description": "", "codedValues": [ { "name": "WC1291", "code": "1291" }, { "name": "WC1275", "code": "1275" }, { "name": "WC1287", "code": "1287" }, { "name": "WC1288", "code": "1288" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R38_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_38", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "", "relatedTableId": 9, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "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}, "advancedQueryCapabilities": { "useStandardizedQueries": false, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 3, "name": "WA_Service", "type": "Feature Layer", "description": "A service is a pipe that runs between the main and the customer\u2019s place of consumption.", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "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": "esriSLS", "style": "esriSLSSolid", "color": [ 70, 145, 0, 255 ], "width": 1 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -8539449.8174, "ymin": 4760017.822099999, "xmax": -8528236.9929, "ymax": 4773961.181999996, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 2, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 1.4892314192838538E8, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "TAG", "typeIdField": "SERVICETYPE", "subtypeFieldName": "SERVICETYPE", "subtypeField": "SERVICETYPE", "defaultSubtypeCode": 1, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "TAG", "type": "esriFieldTypeString", "alias": "Tag", "length": 15, "domain": null }, { "name": "DATEABANDONED", "type": "esriFieldTypeDate", "alias": "DATEABANDONED", "length": 8, "domain": null }, { "name": "LAST_ORGANIZATION", "type": "esriFieldTypeString", "alias": "LAST_ORGANIZATION", "length": 3, "domain": { "type": "codedValue", "name": "WA_VVT_Organization", "description": "", "codedValues": [ { "name": "Buchart Horn Inc", "code": "100" }, { "name": "Chesapeake Environmental Management Inc", "code": "110" }, { "name": "Enterprise Information Solutions, Inc.", "code": "120" }, { "name": "KCI Technologies, Inc.", "code": "130" }, { "name": "RKK", "code": "140" }, { "name": "Sanborn Colorado, LLC", "code": "150" }, { "name": "Johnson, Mirmiran & Thompson", "code": "160" }, { "name": "Metcaff & Eddy", "code": "170" }, { "name": "Ross Technical Services", "code": "180" }, { "name": "Russell Corrosion", "code": "190" }, { "name": "City of Baltimore", "code": "200" }, { "name": "Wachs Water Services", "code": "210" }, { "name": "EBA", "code": "220" }, { "name": "Unknown", "code": "UNK" }, { "name": "DM Enterprises", "code": "DME" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CAPTURE_METHOD", "type": "esriFieldTypeString", "alias": "CAPTURE_METHOD", "length": 4, "domain": { "type": "codedValue", "name": "WA_VVT_Capture_Method_1", "description": "", "codedValues": [ { "name": "Plat Map", "code": "PLAT" }, { "name": "Contract Drawing", "code": "CD" }, { "name": "Geometric Network", "code": "GN" }, { "name": "GPS", "code": "GPS" }, { "name": "Field Survey", "code": "SVY" }, { "name": "Laser GPS", "code": "LGPS" }, { "name": "Orthphoto Interpretation", "code": "ORTH" }, { "name": "Field Investigation/Inspection", "code": "FI" }, { "name": "Reported discrepancy", "code": "DISC" }, { "name": "Utility Viewer", "code": "UV" }, { "name": "Meter Installation", "code": "MI" }, { "name": "Geocoded", "code": "GEOC" }, { "name": "Manually estimated location", "code": "MANL" }, { "name": "As-Built", "code": "ASB" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LAST_USER", "type": "esriFieldTypeString", "alias": "LAST_USER", "length": 20, "domain": null }, { "name": "EDIT_DATE", "type": "esriFieldTypeDate", "alias": "EDIT_DATE", "length": 8, "domain": null }, { "name": "CLASS_TYPE", "type": "esriFieldTypeString", "alias": "CLASS_TYPE", "length": 3, "domain": { "type": "codedValue", "name": "WA_VVT_Pipe_Class", "description": "", "codedValues": [ { "name": "Class 22", "code": "22" }, { "name": "Class 23", "code": "23" }, { "name": "Class 24", "code": "24" }, { "name": "Class 25", "code": "25" }, { "name": "Class 50", "code": "50" }, { "name": "Class 51", "code": "51" }, { "name": "Class 52", "code": "52" }, { "name": "Class 53", "code": "53" }, { "name": "Class 54", "code": "54" }, { "name": "Class 55", "code": "55" }, { "name": "Class 56", "code": "56" }, { "name": "Class 100", "code": "100" }, { "name": "Class 150", "code": "150" }, { "name": "Class 200", "code": "200" }, { "name": "Class 250", "code": "250" }, { "name": "Class 300", "code": "300" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "INSTALL_DATE", "length": 8, "domain": null }, { "name": "MATERIAL_CD", "type": "esriFieldTypeString", "alias": "MATERIAL_CD", "length": 3, "domain": { "type": "codedValue", "name": "WA_VVT_WSP_Material", "description": "", "codedValues": [ { "name": "Cast Iron", "code": "CI" }, { "name": "Copper", "code": "COP" }, { "name": "Ductile Iron", "code": "DI" }, { "name": "Galvanized", "code": "GLV" }, { "name": "Polyethylene", "code": "PE" }, { "name": "PVC", "code": "PVC" }, { "name": "Steel", "code": "ST" }, { "name": "Unknown", "code": "UNK" }, { "name": "Lead", "code": "LD" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PIP_SIZE", "type": "esriFieldTypeDouble", "alias": "PIP_SIZE", "domain": { "type": "codedValue", "name": "WA_VVT_WSP_Pipe_Size", "description": "", "codedValues": [ { "name": ".63\"", "code": 0.63 }, { "name": ".75\"", "code": 0.75 }, { "name": "1\"", "code": 1 }, { "name": "1.25\"", "code": 1.25 }, { "name": "1.5\"", "code": 1.5 }, { "name": "2\"", "code": 2 }, { "name": "3\"", "code": 3 }, { "name": "4\"", "code": 4 }, { "name": "6\"", "code": 6 }, { "name": "8\"", "code": 8 }, { "name": "10\"", "code": 10 }, { "name": "12\"", "code": 12 }, { "name": "Unknown", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SERVICETYPE", "type": "esriFieldTypeInteger", "alias": "SERVICETYPE", "domain": null }, { "name": "FEAT_STATUS", "type": "esriFieldTypeString", "alias": "FEAT_STATUS", "length": 3, "domain": { "type": "codedValue", "name": "WA_VVT_Feat_Status", "description": "", "codedValues": [ { "name": "Abandoned", "code": "ABD" }, { "name": "Active", "code": "ACT" }, { "name": "Proposed", "code": "PRO" }, { "name": "Under Construction", "code": "UC" }, { "name": "Removed", "code": "REM" }, { "name": "Replaced", "code": "REP" }, { "name": "Blinded Valve", "code": "BLD" }, { "name": "Could not locate in field", "code": "CNL" }, { "name": "Under Investigation", "code": "UI" }, { "name": "Proposed Abandonment", "code": "PAB" }, { "name": "Proposed Removal", "code": "PRM" }, { "name": "Proposed Replacement", "code": "PRP" }, { "name": "Proposed Upsizing", "code": "PUP" }, { "name": "Proposed Cleaning & Lining", "code": "PCL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "EnabledDomain", "description": "", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OWNER_CD", "type": "esriFieldTypeString", "alias": "OWNER_CD", "length": 4, "domain": { "type": "codedValue", "name": "WA_VVT_Owner_Info", "description": "", "codedValues": [ { "name": "DPW", "code": "DPW" }, { "name": "Non-DPW", "code": "NDPW" }, { "name": "Anne Arundel", "code": "AA" }, { "name": "Baltimore City", "code": "BCI" }, { "name": "Baltimore County", "code": "BCO" }, { "name": "Company Owned", "code": "CO" }, { "name": "Jointly Owned", "code": "JO" }, { "name": "State of Maryland", "code": "MD" }, { "name": "Could Not Determine", "code": "CND" }, { "name": "Unknown", "code": "UNK" }, { "name": "Harford County", "code": "HAR" }, { "name": "Privately Owned", "code": "PRI" }, { "name": "Howard County", "code": "HOW" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 20, "domain": null }, { "name": "LENGTH", "type": "esriFieldTypeDouble", "alias": "LENGTH", "domain": null }, { "name": "IN_SCOPE", "type": "esriFieldTypeString", "alias": "IN_SCOPE", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PROJECT", "type": "esriFieldTypeString", "alias": "PROJECT", "length": 50, "domain": { "type": "codedValue", "name": "dProject", "description": "", "codedValues": [ { "name": "WC1291", "code": "1291" }, { "name": "WC1275", "code": "1275" }, { "name": "WC1287", "code": "1287" }, { "name": "WC1288", "code": "1288" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R39_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_39", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "types": [ { "domains": { "LAST_ORGANIZATION": {"type": "inherited"}, "CAPTURE_METHOD": {"type": "inherited"}, "CLASS_TYPE": {"type": "inherited"}, "MATERIAL_CD": {"type": "inherited"}, "PIP_SIZE": {"type": "inherited"}, "FEAT_STATUS": {"type": "inherited"}, "ENABLED": {"type": "inherited"}, "OWNER_CD": {"type": "inherited"}, "IN_SCOPE": {"type": "inherited"}, "PROJECT": {"type": "inherited"} }, "id": 2, "name": "DomesicGreaterThan2" }, { "domains": { "LAST_ORGANIZATION": {"type": "inherited"}, "CAPTURE_METHOD": {"type": "inherited"}, "CLASS_TYPE": {"type": "inherited"}, "MATERIAL_CD": {"type": "inherited"}, "PIP_SIZE": {"type": "inherited"}, "FEAT_STATUS": {"type": "inherited"}, "ENABLED": {"type": "inherited"}, "OWNER_CD": {"type": "inherited"}, "IN_SCOPE": {"type": "inherited"}, "PROJECT": {"type": "inherited"} }, "id": 3, "name": "FireService" }, { "domains": { "LAST_ORGANIZATION": {"type": "inherited"}, "CAPTURE_METHOD": {"type": "inherited"}, "CLASS_TYPE": {"type": "inherited"}, "MATERIAL_CD": {"type": "inherited"}, "PIP_SIZE": {"type": "inherited"}, "FEAT_STATUS": {"type": "inherited"}, "ENABLED": {"type": "inherited"}, "OWNER_CD": {"type": "inherited"}, "IN_SCOPE": {"type": "inherited"}, "PROJECT": {"type": "inherited"} }, "id": 1, "name": "DomesticLessThan2" }, { "domains": { "LAST_ORGANIZATION": {"type": "inherited"}, "CAPTURE_METHOD": {"type": "inherited"}, "CLASS_TYPE": {"type": "inherited"}, "MATERIAL_CD": {"type": "inherited"}, "PIP_SIZE": {"type": "inherited"}, "FEAT_STATUS": {"type": "inherited"}, "ENABLED": {"type": "inherited"}, "OWNER_CD": {"type": "inherited"}, "IN_SCOPE": {"type": "inherited"}, "PROJECT": {"type": "inherited"} }, "id": 4, "name": "Combined Fire and Domestic Service" } ], "subtypes": [ { "domains": { "LAST_ORGANIZATION": {"type": "inherited"}, "CAPTURE_METHOD": {"type": "inherited"}, "CLASS_TYPE": {"type": "inherited"}, "MATERIAL_CD": {"type": "inherited"}, "PIP_SIZE": {"type": "inherited"}, "FEAT_STATUS": {"type": "inherited"}, "ENABLED": {"type": "inherited"}, "OWNER_CD": {"type": "inherited"}, "IN_SCOPE": {"type": "inherited"}, "PROJECT": {"type": "inherited"} }, "defaultValues": { "TAG": "NEWJMT", "DATEABANDONED": null, "LAST_ORGANIZATION": "160", "CAPTURE_METHOD": null, "LAST_USER": null, "EDIT_DATE": null, "CLASS_TYPE": null, "INSTALL_DATE": null, "MATERIAL_CD": null, "PIP_SIZE": null, "SERVICETYPE": 2, "FEAT_STATUS": "ACT", "ENABLED": 1, "OWNER_CD": null, "FacilityID": null, "LENGTH": null, "IN_SCOPE": null, "PROJECT": null, "GlobalID": null }, "code": 2, "name": "DomesicGreaterThan2" }, { "domains": { "LAST_ORGANIZATION": {"type": "inherited"}, "CAPTURE_METHOD": {"type": "inherited"}, "CLASS_TYPE": {"type": "inherited"}, "MATERIAL_CD": {"type": "inherited"}, "PIP_SIZE": {"type": "inherited"}, "FEAT_STATUS": {"type": "inherited"}, "ENABLED": {"type": "inherited"}, "OWNER_CD": {"type": "inherited"}, "IN_SCOPE": {"type": "inherited"}, "PROJECT": {"type": "inherited"} }, "defaultValues": { "TAG": "NEWJMT", "DATEABANDONED": null, "LAST_ORGANIZATION": null, "CAPTURE_METHOD": null, "LAST_USER": null, "EDIT_DATE": null, "CLASS_TYPE": null, "INSTALL_DATE": null, "MATERIAL_CD": null, "PIP_SIZE": null, "SERVICETYPE": 3, "FEAT_STATUS": "ACT", "ENABLED": 1, "OWNER_CD": null, "FacilityID": null, "LENGTH": null, "IN_SCOPE": null, "PROJECT": null, "GlobalID": null }, "code": 3, "name": "FireService" }, { "domains": { "LAST_ORGANIZATION": {"type": "inherited"}, "CAPTURE_METHOD": {"type": "inherited"}, "CLASS_TYPE": {"type": "inherited"}, "MATERIAL_CD": {"type": "inherited"}, "PIP_SIZE": {"type": "inherited"}, "FEAT_STATUS": {"type": "inherited"}, "ENABLED": {"type": "inherited"}, "OWNER_CD": {"type": "inherited"}, "IN_SCOPE": {"type": "inherited"}, "PROJECT": {"type": "inherited"} }, "defaultValues": { "TAG": "NEWJMT", "DATEABANDONED": null, "LAST_ORGANIZATION": "160", "CAPTURE_METHOD": null, "LAST_USER": null, "EDIT_DATE": null, "CLASS_TYPE": null, "INSTALL_DATE": null, "MATERIAL_CD": null, "PIP_SIZE": null, "SERVICETYPE": 1, "FEAT_STATUS": "ACT", "ENABLED": 1, "OWNER_CD": null, "FacilityID": null, "LENGTH": null, "IN_SCOPE": null, "PROJECT": null, "GlobalID": null }, "code": 1, "name": "DomesticLessThan2" }, { "domains": { "LAST_ORGANIZATION": {"type": "inherited"}, "CAPTURE_METHOD": {"type": "inherited"}, "CLASS_TYPE": {"type": "inherited"}, "MATERIAL_CD": {"type": "inherited"}, "PIP_SIZE": {"type": "inherited"}, "FEAT_STATUS": {"type": "inherited"}, "ENABLED": {"type": "inherited"}, "OWNER_CD": {"type": "inherited"}, "IN_SCOPE": {"type": "inherited"}, "PROJECT": {"type": "inherited"} }, "defaultValues": { "TAG": "NEWJMT", "DATEABANDONED": null, "LAST_ORGANIZATION": null, "CAPTURE_METHOD": null, "LAST_USER": null, "EDIT_DATE": null, "CLASS_TYPE": null, "INSTALL_DATE": null, "MATERIAL_CD": null, "PIP_SIZE": null, "SERVICETYPE": 1, "FEAT_STATUS": "ACT", "ENABLED": 1, "OWNER_CD": null, "FacilityID": null, "LENGTH": null, "IN_SCOPE": null, "PROJECT": null, "GlobalID": null }, "code": 4, "name": "Combined Fire and Domestic Service" } ], "relationships": [ { "id": 3, "name": "", "relatedTableId": 8, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "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}, "advancedQueryCapabilities": { "useStandardizedQueries": false, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 4, "name": "WA_Main", "type": "Feature Layer", "description": "A main is a water pipe operated and maintained for the purpose of transmission and/or distribution of water to customers.", "geometryType": "esriGeometryPolyline", "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "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": "esriSLS", "style": "esriSLSSolid", "color": [ 106, 128, 0, 255 ], "width": 1 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": -8539746.8407, "ymin": 4759745.394100003, "xmax": -8528183.072, "ymax": 4773991.601999998, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 2, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 1.4892314192838538E8, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "CLASS", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CLASS", "type": "esriFieldTypeString", "alias": "CLASS", "length": 4, "domain": { "type": "codedValue", "name": "WA_VVT_Pipe_Class", "description": "", "codedValues": [ { "name": "Class 22", "code": "22" }, { "name": "Class 23", "code": "23" }, { "name": "Class 24", "code": "24" }, { "name": "Class 25", "code": "25" }, { "name": "Class 50", "code": "50" }, { "name": "Class 51", "code": "51" }, { "name": "Class 52", "code": "52" }, { "name": "Class 53", "code": "53" }, { "name": "Class 54", "code": "54" }, { "name": "Class 55", "code": "55" }, { "name": "Class 56", "code": "56" }, { "name": "Class 100", "code": "100" }, { "name": "Class 150", "code": "150" }, { "name": "Class 200", "code": "200" }, { "name": "Class 250", "code": "250" }, { "name": "Class 300", "code": "300" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LINE_TYPE", "type": "esriFieldTypeInteger", "alias": "LINE_TYPE", "domain": { "type": "codedValue", "name": "WA_VVT_Line_Type", "description": "", "codedValues": [ { "name": "Hydrant Lead", "code": 4 }, { "name": "Main Line", "code": 5 }, { "name": "Unknown", "code": 6 }, { "name": "Raw Water Conduit", "code": 1 }, { "name": "Facilities Piping", "code": 2 }, { "name": "Main - SLF", "code": 3 }, { "name": "Drain", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PIP_SIZE", "type": "esriFieldTypeDouble", "alias": "PIP_SIZE", "domain": { "type": "codedValue", "name": "WA_VVT_Pipe_Size", "description": "", "codedValues": [ { "name": "0.75\"", "code": 0.75 }, { "name": "1\"", "code": 1 }, { "name": "1.5\"", "code": 1.5 }, { "name": "2\"", "code": 2 }, { "name": "2.5\"", "code": 2.5 }, { "name": "3\"", "code": 3 }, { "name": "3.5\"", "code": 3.5 }, { "name": "4\"", "code": 4 }, { "name": "4.5\"", "code": 4.5 }, { "name": "5\"", "code": 5 }, { "name": "6\"", "code": 6 }, { "name": "8\"", "code": 8 }, { "name": "9\"", "code": 9 }, { "name": "10\"", "code": 10 }, { "name": "12\"", "code": 12 }, { "name": "14\"", "code": 14 }, { "name": "16\"", "code": 16 }, { "name": "18\"", "code": 18 }, { "name": "20\"", "code": 20 }, { "name": "24\"", "code": 24 }, { "name": "30\"", "code": 30 }, { "name": "34\"", "code": 34 }, { "name": "36\"", "code": 36 }, { "name": "40\"", "code": 40 }, { "name": "42\"", "code": 42 }, { "name": "48\"", "code": 48 }, { "name": "54\"", "code": 54 }, { "name": "60\"", "code": 60 }, { "name": "66\"", "code": 66 }, { "name": "72\"", "code": 72 }, { "name": "78\"", "code": 78 }, { "name": "84\"", "code": 84 }, { "name": "96\"", "code": 96 }, { "name": "108\"", "code": 108 }, { "name": "114\"", "code": 114 }, { "name": "120\"", "code": 120 }, { "name": "126\"", "code": 126 }, { "name": "132\"", "code": 132 }, { "name": "138\"", "code": 138 }, { "name": "144\"", "code": 144 }, { "name": "Unknown", "code": 0 }, { "name": "Could Not Determine", "code": 999 }, { "name": "92\"", "code": 92 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "DATEABANDONED", "type": "esriFieldTypeDate", "alias": "DATEABANDONED", "length": 8, "domain": null }, { "name": "MATERIAL_CD", "type": "esriFieldTypeString", "alias": "MATERIAL_CD", "length": 3, "domain": { "type": "codedValue", "name": "WA_VVT_Material", "description": "", "codedValues": [ { "name": "Asbestos Concrete Main", "code": "ASC" }, { "name": "Cast Iron Main", "code": "CI" }, { "name": "Concrete Main", "code": "CON" }, { "name": "Copper", "code": "COP" }, { "name": "Ductile Iron Main", "code": "DI" }, { "name": "PVC Pipe", "code": "PVC" }, { "name": "Steel Main", "code": "STL" }, { "name": "Wood", "code": "WOD" }, { "name": "Could Not Determine", "code": "CND" }, { "name": "Unknown", "code": "UNK" }, { "name": "High Density Polyethylene", "code": "HDP" }, { "name": "PCCP-ECP", "code": "ECP" }, { "name": "PCCP-LCP", "code": "LCP" }, { "name": "PCCP-RCCP", "code": "RCP" }, { "name": "Brick", "code": "BRK" }, { "name": "Bedrock", "code": "BED" }, { "name": "PCCP-UNK", "code": "PCU" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "COATING_TYPE_CD", "type": "esriFieldTypeString", "alias": "COATING_TYPE_CD", "length": 3, "domain": { "type": "codedValue", "name": "WA_VVT_Coating", "description": "", "codedValues": [ { "name": "Asphaltic Compound", "code": "AC" }, { "name": "Bituminous", "code": "BI" }, { "name": "Coal Tar Epoxy", "code": "CTE" }, { "name": "Copper Plating", "code": "CP" }, { "name": "Nickel Plating", "code": "NP" }, { "name": "Polyethylene", "code": "PE" }, { "name": "Polymers", "code": "POL" }, { "name": "Tin Plating", "code": "TIP" }, { "name": "Tape", "code": "TP" }, { "name": "Vitreous", "code": "VI" }, { "name": "Wrapped", "code": "WR" }, { "name": "Could Not Determine", "code": "CND" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "NORM_OP_PRESSURE", "type": "esriFieldTypeDouble", "alias": "NORM_OP_PRESSURE", "domain": null }, { "name": "MAX_OP_PRESSURE", "type": "esriFieldTypeDouble", "alias": "MAX_OP_PRESSURE", "domain": null }, { "name": "PRESSURE_CD", "type": "esriFieldTypeString", "alias": "PRESSURE_CD", "length": 3, "domain": { "type": "codedValue", "name": "WA_VVT_Pressure", "description": "", "codedValues": [ { "name": "High Pressure", "code": "HI" }, { "name": "Intermediate Pressure", "code": "INT" }, { "name": "Low Pressure", "code": "LOW" }, { "name": "Could Not Determine", "code": "CND" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PRESSURE_ZONE", "type": "esriFieldTypeString", "alias": "PRESSURE_ZONE", "length": 4, "domain": { "type": "codedValue", "name": "WA_VVT_Pressure_Zone", "description": "", "codedValues": [ { "name": "First", "code": "1" }, { "name": "Second", "code": "2" }, { "name": "Colgate Second", "code": "2C" }, { "name": "Eastern Third", "code": "3E" }, { "name": "Western Third", "code": "3W" }, { "name": "Catonsville Fourth", "code": "4C" }, { "name": "Glenarm Fourth", "code": "4G" }, { "name": "Pikesville Fourth", "code": "4P" }, { "name": "Towson Fourth", "code": "4T" }, { "name": "Falls Fifth", "code": "5F" }, { "name": "Hereford Fifth", "code": "5H" }, { "name": "Jacksonville Fifth", "code": "5J" }, { "name": "Pot Spring Fifth", "code": "5PS" }, { "name": "Reisterstown Fifth", "code": "5R" }, { "name": "Sherwood Fifth", "code": "5SH" }, { "name": "Sparks Fifth", "code": "5SP" }, { "name": "Worthington Fifth", "code": "5W" }, { "name": "Could Not Determine", "code": "CND" }, { "name": "Unknown", "code": "UNK" }, { "name": "NA - Raw Water Conduit", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "DEAD_END_IND", "type": "esriFieldTypeString", "alias": "DEAD_END_IND", "length": 1, "domain": { "type": "codedValue", "name": "WA_VVT_BooleanValues", "description": "", "codedValues": [ { "name": "True", "code": "T" }, { "name": "False", "code": "F" }, { "name": "Could Not Determine", "code": "N" }, { "name": "Unknown", "code": "U" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "FEAT_STATUS", "type": "esriFieldTypeString", "alias": "FEAT_STATUS", "length": 3, "domain": { "type": "codedValue", "name": "WA_VVT_Feat_Status", "description": "", "codedValues": [ { "name": "Abandoned", "code": "ABD" }, { "name": "Active", "code": "ACT" }, { "name": "Proposed", "code": "PRO" }, { "name": "Under Construction", "code": "UC" }, { "name": "Removed", "code": "REM" }, { "name": "Replaced", "code": "REP" }, { "name": "Blinded Valve", "code": "BLD" }, { "name": "Could not locate in field", "code": "CNL" }, { "name": "Under Investigation", "code": "UI" }, { "name": "Proposed Abandonment", "code": "PAB" }, { "name": "Proposed Removal", "code": "PRM" }, { "name": "Proposed Replacement", "code": "PRP" }, { "name": "Proposed Upsizing", "code": "PUP" }, { "name": "Proposed Cleaning & Lining", "code": "PCL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "ENABLED", "domain": { "type": "codedValue", "name": "EnabledDomain", "description": "", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "RESP_AGENCY", "type": "esriFieldTypeString", "alias": "RESP_AGENCY", "length": 4, "domain": { "type": "codedValue", "name": "WA_VVT_Owner_Info", "description": "", "codedValues": [ { "name": "DPW", "code": "DPW" }, { "name": "Non-DPW", "code": "NDPW" }, { "name": "Anne Arundel", "code": "AA" }, { "name": "Baltimore City", "code": "BCI" }, { "name": "Baltimore County", "code": "BCO" }, { "name": "Company Owned", "code": "CO" }, { "name": "Jointly Owned", "code": "JO" }, { "name": "State of Maryland", "code": "MD" }, { "name": "Could Not Determine", "code": "CND" }, { "name": "Unknown", "code": "UNK" }, { "name": "Harford County", "code": "HAR" }, { "name": "Privately Owned", "code": "PRI" }, { "name": "Howard County", "code": "HOW" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SYMBOL", "type": "esriFieldTypeString", "alias": "SYMBOL", "length": 3, "domain": null }, { "name": "LAST_ORGANIZATION", "type": "esriFieldTypeString", "alias": "LAST_ORGANIZATION", "length": 3, "domain": { "type": "codedValue", "name": "WA_VVT_Organization", "description": "", "codedValues": [ { "name": "Buchart Horn Inc", "code": "100" }, { "name": "Chesapeake Environmental Management Inc", "code": "110" }, { "name": "Enterprise Information Solutions, Inc.", "code": "120" }, { "name": "KCI Technologies, Inc.", "code": "130" }, { "name": "RKK", "code": "140" }, { "name": "Sanborn Colorado, LLC", "code": "150" }, { "name": "Johnson, Mirmiran & Thompson", "code": "160" }, { "name": "Metcaff & Eddy", "code": "170" }, { "name": "Ross Technical Services", "code": "180" }, { "name": "Russell Corrosion", "code": "190" }, { "name": "City of Baltimore", "code": "200" }, { "name": "Wachs Water Services", "code": "210" }, { "name": "EBA", "code": "220" }, { "name": "Unknown", "code": "UNK" }, { "name": "DM Enterprises", "code": "DME" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CAPTURE_METHOD", "type": "esriFieldTypeString", "alias": "CAPTURE_METHOD", "length": 4, "domain": { "type": "codedValue", "name": "WA_VVT_Capture_Method_1", "description": "", "codedValues": [ { "name": "Plat Map", "code": "PLAT" }, { "name": "Contract Drawing", "code": "CD" }, { "name": "Geometric Network", "code": "GN" }, { "name": "GPS", "code": "GPS" }, { "name": "Field Survey", "code": "SVY" }, { "name": "Laser GPS", "code": "LGPS" }, { "name": "Orthphoto Interpretation", "code": "ORTH" }, { "name": "Field Investigation/Inspection", "code": "FI" }, { "name": "Reported discrepancy", "code": "DISC" }, { "name": "Utility Viewer", "code": "UV" }, { "name": "Meter Installation", "code": "MI" }, { "name": "Geocoded", "code": "GEOC" }, { "name": "Manually estimated location", "code": "MANL" }, { "name": "As-Built", "code": "ASB" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LAST_USER", "type": "esriFieldTypeString", "alias": "LAST_USER", "length": 20, "domain": null }, { "name": "TAG", "type": "esriFieldTypeString", "alias": "TAG", "length": 15, "domain": null }, { "name": "EDIT_DATE", "type": "esriFieldTypeDate", "alias": "EDIT_DATE", "length": 8, "domain": null }, { "name": "MAIN_ID", "type": "esriFieldTypeString", "alias": "MAIN_ID", "length": 15, "domain": null }, { "name": "COVER_DEPTH", "type": "esriFieldTypeDouble", "alias": "COVER_DEPTH", "domain": null }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "INSTALL_DATE", "length": 8, "domain": null }, { "name": "LINING_DATE", "type": "esriFieldTypeDate", "alias": "LINING_DATE", "length": 8, "domain": null }, { "name": "DOCPOPURL", "type": "esriFieldTypeString", "alias": "DOCPOPURL", "length": 300, "domain": null }, { "name": "CITY_ENUM", "type": "esriFieldTypeString", "alias": "CITY_ENUM", "length": 10, "domain": null }, { "name": "LENGTH", "type": "esriFieldTypeDouble", "alias": "LENGTH", "domain": null }, { "name": "LENGTH_divided_by_subsegs", "type": "esriFieldTypeDouble", "alias": "LENGTH_divided_by_subsegs", "domain": null }, { "name": "LINING_TYPE_CD", "type": "esriFieldTypeString", "alias": "LINING_TYPE_CD", "length": 4, "domain": { "type": "codedValue", "name": "WA_VVT_Lining", "description": "", "codedValues": [ { "name": "Unknown whether lining present", "code": "UNK" }, { "name": "Cleaned and Lined with Cement Mortar", "code": "CLCM" }, { "name": "Pre-Lined with Cement Mortar", "code": "PLCM" }, { "name": "Insituform", "code": "ISF" }, { "name": "Sources indicate pipe is not lined", "code": "NON" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "IN_SCOPE", "type": "esriFieldTypeString", "alias": "IN_SCOPE", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PROJECT", "type": "esriFieldTypeString", "alias": "PROJECT", "length": 50, "domain": { "type": "codedValue", "name": "dProject", "description": "", "codedValues": [ { "name": "WC1291", "code": "1291" }, { "name": "WC1275", "code": "1275" }, { "name": "WC1287", "code": "1287" }, { "name": "WC1288", "code": "1288" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "SHAPE.STLength()", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R40_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_40", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I88MAIN_ID", "fields": "MAIN_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "", "relatedTableId": 6, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "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}, "advancedQueryCapabilities": { "useStandardizedQueries": false, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true } ], "tables": [ { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 5, "name": "AssetTrackers_DevelopmentDB.ASSET_TRACKER.Hydrant_Work_Report", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Contractor", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Contractor", "type": "esriFieldTypeString", "alias": "Contractor", "length": 30, "domain": { "type": "codedValue", "name": "dContractor", "description": "", "codedValues": [ { "name": "J. Fletcher Creamer & Son, Inc", "code": "J. Fletcher Creamer & Son, Inc" }, { "name": "Civil Construction LLC", "code": "Civil Construction LLC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Project_Number", "type": "esriFieldTypeString", "alias": "Project_Number", "length": 50, "domain": { "type": "codedValue", "name": "dProject", "description": "", "codedValues": [ { "name": "WC1291", "code": "1291" }, { "name": "WC1275", "code": "1275" }, { "name": "WC1287", "code": "1287" }, { "name": "WC1288", "code": "1288" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Inspected_By", "type": "esriFieldTypeString", "alias": "Inspected_By", "length": 50, "domain": { "type": "codedValue", "name": "dInspectors", "description": "", "codedValues": [ { "name": "Ashley Galloway", "code": "Ashley Galloway" }, { "name": "Luke Mulry", "code": "Luke Mulry" }, { "name": "Clarence Wayman", "code": "Clarence Wayman" }, { "name": "David Wiley", "code": "David Wiley" }, { "name": "Hernan Guadalupe", "code": "Hernan Guadalupe" }, { "name": "Utieyin Edema-Eyen", "code": "Utieyin Edema-Eyen" }, { "name": "Amin Alizad", "code": "Amin Alizad" }, { "name": "Amir Fayaz", "code": "Amir Fayaz" }, { "name": "Brian Brophy", "code": "Brian Brophy" }, { "name": "Fitzroy French", "code": "Fitzroy French" }, { "name": "Kia Saunders", "code": "Kia Saunders" }, { "name": "John Foster", "code": "John Foster" }, { "name": "Micheal Rebert", "code": "Micheal Rebert" }, { "name": "Prakash Shahi", "code": "Prakash Shahi" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Inspection_Date", "type": "esriFieldTypeDate", "alias": "Inspection_Date", "length": 8, "domain": null }, { "name": "Hydrant_Work_Activity", "type": "esriFieldTypeString", "alias": "Hydrant_Work_Activity", "length": 50, "domain": { "type": "codedValue", "name": "dHydrant_Work_Activity", "description": "", "codedValues": [ { "name": "Exercise/Test/Flush Fire Hydrants (Maintenance)", "code": "Exercise/Test/Flush Fire Hydrants (Maintenance)" }, { "name": "Painting/Repair of Fire Hydrants (Maintenance)", "code": "Painting/Repair of Fire Hydrants (Maintenance)" }, { "name": "Install New Fire Hydrant", "code": "Install New Fire Hydrant" }, { "name": "Replace Existing Fire Hydrant", "code": "Replace Existing Fire Hydrant" }, { "name": "Abandon", "code": "Abandon" }, { "name": "Removed from Scope", "code": "Removed from Scope" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "New_Lat_Size", "type": "esriFieldTypeDouble", "alias": "New_Lat_Size", "domain": null }, { "name": "New_Src_Main_Size", "type": "esriFieldTypeDouble", "alias": "New_SRC_Main_Size", "domain": null }, { "name": "Hydrant_Install_Date", "type": "esriFieldTypeDate", "alias": "Hydrant_Install_Date", "length": 8, "domain": null }, { "name": "Additional_Work_Activity", "type": "esriFieldTypeString", "alias": "Additional_Work_Activity", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Hydrant_Work_Activity1", "type": "esriFieldTypeString", "alias": "Hydrant_Work_Activity1", "length": 50, "domain": { "type": "codedValue", "name": "dHydrant_Work_Activity", "description": "", "codedValues": [ { "name": "Exercise/Test/Flush Fire Hydrants (Maintenance)", "code": "Exercise/Test/Flush Fire Hydrants (Maintenance)" }, { "name": "Painting/Repair of Fire Hydrants (Maintenance)", "code": "Painting/Repair of Fire Hydrants (Maintenance)" }, { "name": "Install New Fire Hydrant", "code": "Install New Fire Hydrant" }, { "name": "Replace Existing Fire Hydrant", "code": "Replace Existing Fire Hydrant" }, { "name": "Abandon", "code": "Abandon" }, { "name": "Removed from Scope", "code": "Removed from Scope" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Work_Activity_Date", "type": "esriFieldTypeDate", "alias": "Work_Activity_Date", "length": 8, "domain": null }, { "name": "Comment", "type": "esriFieldTypeString", "alias": "Comment", "length": 70, "domain": null }, { "name": "Discrepancies", "type": "esriFieldTypeString", "alias": "Discrepancies", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Discrepancy_Type", "type": "esriFieldTypeString", "alias": "Discrepancy_Type", "length": 20, "domain": { "type": "codedValue", "name": "dDiscrepancyType", "description": "", "codedValues": [ { "name": "Attribute", "code": "Attribute" }, { "name": "Geometry", "code": "Geometry" }, { "name": "Other (see comments)", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 150, "domain": null }, { "name": "Work_Activity_Status", "type": "esriFieldTypeString", "alias": "Work_Activity_Status", "length": 20, "domain": { "type": "codedValue", "name": "dWorkActivityStatus", "description": "", "codedValues": [ { "name": "Not Complete/In Progress", "code": "Not Complete" }, { "name": "Current Work Activity Complete", "code": "Current Complete" }, { "name": "All Work Activities Complete", "code": "All Complete" }, { "name": "All Work Activities Complete and Asset in Service", "code": "All Complete+Service" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "In_Prog_Comment", "type": "esriFieldTypeString", "alias": "In_Prog_Comment", "length": 150, "domain": null }, { "name": "In_Service", "type": "esriFieldTypeString", "alias": "In_Service", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "All_Work_Complete", "type": "esriFieldTypeString", "alias": "All_Work_Complete", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RelObjectID", "type": "esriFieldTypeInteger", "alias": "RelObjectID", "domain": null }, { "name": "Lat_Size_Same", "type": "esriFieldTypeString", "alias": "Lat_Size_Same", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Src_Main_Size_Same", "type": "esriFieldTypeString", "alias": "Src_Main_Size_Same", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Guid", "type": "esriFieldTypeGUID", "alias": "Guid", "length": 38, "domain": null }, { "name": "Hydrant_ID", "type": "esriFieldTypeString", "alias": "Hydrant_ID", "length": 15, "domain": null }, { "name": "In_Scope", "type": "esriFieldTypeString", "alias": "In_Scope", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R30_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G78RelObjectID", "fields": "RelObjectID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G78Guid", "fields": "Guid", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "Guid", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Query,Map,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "advancedQueryCapabilities": { "useStandardizedQueries": false, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 6, "name": "AssetTrackers_DevelopmentDB.ASSET_TRACKER.Main_Work_Report", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Project_Number", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Project_Number", "type": "esriFieldTypeString", "alias": "Project_Number", "length": 50, "domain": { "type": "codedValue", "name": "dProject", "description": "", "codedValues": [ { "name": "WC1291", "code": "1291" }, { "name": "WC1275", "code": "1275" }, { "name": "WC1287", "code": "1287" }, { "name": "WC1288", "code": "1288" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Contractor", "type": "esriFieldTypeString", "alias": "Contractor", "length": 30, "domain": { "type": "codedValue", "name": "dContractor", "description": "", "codedValues": [ { "name": "J. Fletcher Creamer & Son, Inc", "code": "J. Fletcher Creamer & Son, Inc" }, { "name": "Civil Construction LLC", "code": "Civil Construction LLC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Inspected_By", "type": "esriFieldTypeString", "alias": "Inspected_By", "length": 50, "domain": { "type": "codedValue", "name": "dInspectors", "description": "", "codedValues": [ { "name": "Ashley Galloway", "code": "Ashley Galloway" }, { "name": "Luke Mulry", "code": "Luke Mulry" }, { "name": "Clarence Wayman", "code": "Clarence Wayman" }, { "name": "David Wiley", "code": "David Wiley" }, { "name": "Hernan Guadalupe", "code": "Hernan Guadalupe" }, { "name": "Utieyin Edema-Eyen", "code": "Utieyin Edema-Eyen" }, { "name": "Amin Alizad", "code": "Amin Alizad" }, { "name": "Amir Fayaz", "code": "Amir Fayaz" }, { "name": "Brian Brophy", "code": "Brian Brophy" }, { "name": "Fitzroy French", "code": "Fitzroy French" }, { "name": "Kia Saunders", "code": "Kia Saunders" }, { "name": "John Foster", "code": "John Foster" }, { "name": "Micheal Rebert", "code": "Micheal Rebert" }, { "name": "Prakash Shahi", "code": "Prakash Shahi" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Inspection_Date", "type": "esriFieldTypeDate", "alias": "Inspection_Date", "length": 8, "domain": null }, { "name": "Main_Work_Activity", "type": "esriFieldTypeString", "alias": "Main_Work_Activity", "length": 50, "domain": { "type": "codedValue", "name": "dMain_Work_Ativity", "description": "", "codedValues": [ { "name": "CIPP Lining", "code": "CIPP Lining" }, { "name": "Internal Joint Seal Repairs", "code": "Internal Joint Seal Repairs" }, { "name": "Sliplining", "code": "Sliplining" }, { "name": "CFRP Repairs", "code": "CFRP Repairs" }, { "name": "Water Main Repairs (Maintenance)", "code": "Water Main Repairs (Maintenance)" }, { "name": "Replacement Water Main", "code": "Replacement Water Main" }, { "name": "Cleaning", "code": "Cleaning" }, { "name": "Cathodic Protection", "code": "Cathodic Protection" }, { "name": "New Water Main", "code": "New Water Main" }, { "name": "Cement-Mortar Lining", "code": "Cement-Mortar Lining" }, { "name": "Condition Assessment", "code": "Condition Assessment" }, { "name": "Abandon", "code": "Abandon" }, { "name": "Removed from Scope", "code": "Removed from Scope" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Pipe_Size_Same", "type": "esriFieldTypeString", "alias": "Pipe_Size_Same", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "New_Pipe_Size", "type": "esriFieldTypeDouble", "alias": "New_Pipe_Size", "domain": { "type": "codedValue", "name": "WA_VVT_Pipe_Size", "description": "", "codedValues": [ { "name": "0.75\"", "code": 0.75 }, { "name": "1\"", "code": 1 }, { "name": "1.5\"", "code": 1.5 }, { "name": "2\"", "code": 2 }, { "name": "2.5\"", "code": 2.5 }, { "name": "3\"", "code": 3 }, { "name": "3.5\"", "code": 3.5 }, { "name": "4\"", "code": 4 }, { "name": "4.5\"", "code": 4.5 }, { "name": "5\"", "code": 5 }, { "name": "6\"", "code": 6 }, { "name": "8\"", "code": 8 }, { "name": "9\"", "code": 9 }, { "name": "10\"", "code": 10 }, { "name": "12\"", "code": 12 }, { "name": "14\"", "code": 14 }, { "name": "16\"", "code": 16 }, { "name": "18\"", "code": 18 }, { "name": "20\"", "code": 20 }, { "name": "24\"", "code": 24 }, { "name": "30\"", "code": 30 }, { "name": "34\"", "code": 34 }, { "name": "36\"", "code": 36 }, { "name": "40\"", "code": 40 }, { "name": "42\"", "code": 42 }, { "name": "48\"", "code": 48 }, { "name": "54\"", "code": 54 }, { "name": "60\"", "code": 60 }, { "name": "66\"", "code": 66 }, { "name": "72\"", "code": 72 }, { "name": "78\"", "code": 78 }, { "name": "84\"", "code": 84 }, { "name": "96\"", "code": 96 }, { "name": "108\"", "code": 108 }, { "name": "114\"", "code": 114 }, { "name": "120\"", "code": 120 }, { "name": "126\"", "code": 126 }, { "name": "132\"", "code": 132 }, { "name": "138\"", "code": 138 }, { "name": "144\"", "code": 144 }, { "name": "Unknown", "code": 0 }, { "name": "Could Not Determine", "code": 999 }, { "name": "92\"", "code": 92 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Material_Same", "type": "esriFieldTypeString", "alias": "Material_Same", "length": 50, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "New_Material", "type": "esriFieldTypeString", "alias": "New_Material", "length": 3, "domain": { "type": "codedValue", "name": "WA_VVT_Material", "description": "", "codedValues": [ { "name": "Asbestos Concrete Main", "code": "ASC" }, { "name": "Cast Iron Main", "code": "CI" }, { "name": "Concrete Main", "code": "CON" }, { "name": "Copper", "code": "COP" }, { "name": "Ductile Iron Main", "code": "DI" }, { "name": "PVC Pipe", "code": "PVC" }, { "name": "Steel Main", "code": "STL" }, { "name": "Wood", "code": "WOD" }, { "name": "Could Not Determine", "code": "CND" }, { "name": "Unknown", "code": "UNK" }, { "name": "High Density Polyethylene", "code": "HDP" }, { "name": "PCCP-ECP", "code": "ECP" }, { "name": "PCCP-LCP", "code": "LCP" }, { "name": "PCCP-RCCP", "code": "RCP" }, { "name": "Brick", "code": "BRK" }, { "name": "Bedrock", "code": "BED" }, { "name": "PCCP-UNK", "code": "PCU" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Length_Same", "type": "esriFieldTypeString", "alias": "Length_Same", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "New_Length", "type": "esriFieldTypeDouble", "alias": "New_Length", "domain": null }, { "name": "Additional_Work_Activity", "type": "esriFieldTypeString", "alias": "Additional_Work_Activity", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Main_Work_Activity1", "type": "esriFieldTypeString", "alias": "Main_Work_Activity1", "length": 50, "domain": { "type": "codedValue", "name": "dMain_Work_Ativity", "description": "", "codedValues": [ { "name": "CIPP Lining", "code": "CIPP Lining" }, { "name": "Internal Joint Seal Repairs", "code": "Internal Joint Seal Repairs" }, { "name": "Sliplining", "code": "Sliplining" }, { "name": "CFRP Repairs", "code": "CFRP Repairs" }, { "name": "Water Main Repairs (Maintenance)", "code": "Water Main Repairs (Maintenance)" }, { "name": "Replacement Water Main", "code": "Replacement Water Main" }, { "name": "Cleaning", "code": "Cleaning" }, { "name": "Cathodic Protection", "code": "Cathodic Protection" }, { "name": "New Water Main", "code": "New Water Main" }, { "name": "Cement-Mortar Lining", "code": "Cement-Mortar Lining" }, { "name": "Condition Assessment", "code": "Condition Assessment" }, { "name": "Abandon", "code": "Abandon" }, { "name": "Removed from Scope", "code": "Removed from Scope" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Discrepancies", "type": "esriFieldTypeString", "alias": "Discrepancies", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Discrepancy_Type", "type": "esriFieldTypeString", "alias": "Discrepancy_Type", "length": 20, "domain": { "type": "codedValue", "name": "dDiscrepancyType", "description": "", "codedValues": [ { "name": "Attribute", "code": "Attribute" }, { "name": "Geometry", "code": "Geometry" }, { "name": "Other (see comments)", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 150, "domain": null }, { "name": "Work_Activity_Status", "type": "esriFieldTypeString", "alias": "Work_Activity_Status", "length": 20, "domain": { "type": "codedValue", "name": "dWorkActivityStatus", "description": "", "codedValues": [ { "name": "Not Complete/In Progress", "code": "Not Complete" }, { "name": "Current Work Activity Complete", "code": "Current Complete" }, { "name": "All Work Activities Complete", "code": "All Complete" }, { "name": "All Work Activities Complete and Asset in Service", "code": "All Complete+Service" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "In_Prog_Comment", "type": "esriFieldTypeString", "alias": "In_Prog_Comment", "length": 150, "domain": null }, { "name": "In_Service", "type": "esriFieldTypeString", "alias": "In_Service", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "All_Work_Complete", "type": "esriFieldTypeString", "alias": "All_Work_Complete", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RelObjectID", "type": "esriFieldTypeInteger", "alias": "RelGlobalID", "domain": null }, { "name": "Guid", "type": "esriFieldTypeGUID", "alias": "Guid", "length": 38, "domain": null }, { "name": "Main_ID", "type": "esriFieldTypeString", "alias": "Main_ID", "length": 15, "domain": null }, { "name": "In_Scope", "type": "esriFieldTypeString", "alias": "In_Scope", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Work_Activity_Date", "type": "esriFieldTypeDate", "alias": "Work_Activity_Date", "length": 8, "domain": null } ], "indexes": [ { "name": "R31_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G79RelObjectID", "fields": "RelObjectID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G79Guid", "fields": "Guid", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "Guid", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Query,Map,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "advancedQueryCapabilities": { "useStandardizedQueries": false, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 7, "name": "AssetTrackers_DevelopmentDB.ASSET_TRACKER.Meter_Work_Report", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Contractor", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Contractor", "type": "esriFieldTypeString", "alias": "Contractor", "length": 30, "domain": { "type": "codedValue", "name": "dContractor", "description": "", "codedValues": [ { "name": "J. Fletcher Creamer & Son, Inc", "code": "J. Fletcher Creamer & Son, Inc" }, { "name": "Civil Construction LLC", "code": "Civil Construction LLC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Project_Number", "type": "esriFieldTypeString", "alias": "Project_Number", "length": 50, "domain": { "type": "codedValue", "name": "dProject", "description": "", "codedValues": [ { "name": "WC1291", "code": "1291" }, { "name": "WC1275", "code": "1275" }, { "name": "WC1287", "code": "1287" }, { "name": "WC1288", "code": "1288" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Inspected_By", "type": "esriFieldTypeString", "alias": "Inspected_By", "length": 50, "domain": { "type": "codedValue", "name": "dInspectors", "description": "", "codedValues": [ { "name": "Ashley Galloway", "code": "Ashley Galloway" }, { "name": "Luke Mulry", "code": "Luke Mulry" }, { "name": "Clarence Wayman", "code": "Clarence Wayman" }, { "name": "David Wiley", "code": "David Wiley" }, { "name": "Hernan Guadalupe", "code": "Hernan Guadalupe" }, { "name": "Utieyin Edema-Eyen", "code": "Utieyin Edema-Eyen" }, { "name": "Amin Alizad", "code": "Amin Alizad" }, { "name": "Amir Fayaz", "code": "Amir Fayaz" }, { "name": "Brian Brophy", "code": "Brian Brophy" }, { "name": "Fitzroy French", "code": "Fitzroy French" }, { "name": "Kia Saunders", "code": "Kia Saunders" }, { "name": "John Foster", "code": "John Foster" }, { "name": "Micheal Rebert", "code": "Micheal Rebert" }, { "name": "Prakash Shahi", "code": "Prakash Shahi" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Inspection_Date", "type": "esriFieldTypeDate", "alias": "Inspection_Date", "length": 8, "domain": null }, { "name": "Meter_Work_Activity", "type": "esriFieldTypeString", "alias": "Meter_Work_Activity", "length": 50, "domain": { "type": "codedValue", "name": "dMeter_Work_Activity", "description": "", "codedValues": [ { "name": "Retrofit / Repair Ex. Water Meter", "code": "Retrofit / Repair Ex. Water Meter" }, { "name": "Replace Setting and Vault", "code": "Replace Setting and Vault" }, { "name": "Replace Existing Water Meter", "code": "Replace Existing Water Meter" }, { "name": "Abandon", "code": "Abandon" }, { "name": "New Water Meter, Setting, and Vault", "code": "New Water Meter, Setting, and Vault" }, { "name": "Removed from Scope", "code": "Removed from Scope" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MT_Size_Same", "type": "esriFieldTypeString", "alias": "MT_Size_Same", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "New_MT_Size", "type": "esriFieldTypeDouble", "alias": "New_MT_Size", "domain": null }, { "name": "Additional_Work_Activity", "type": "esriFieldTypeString", "alias": "Additional_Work_Activity", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Meter_Work_Activity1", "type": "esriFieldTypeString", "alias": "Meter_Work_Activity1", "length": 50, "domain": { "type": "codedValue", "name": "dMeter_Work_Activity", "description": "", "codedValues": [ { "name": "Retrofit / Repair Ex. Water Meter", "code": "Retrofit / Repair Ex. Water Meter" }, { "name": "Replace Setting and Vault", "code": "Replace Setting and Vault" }, { "name": "Replace Existing Water Meter", "code": "Replace Existing Water Meter" }, { "name": "Abandon", "code": "Abandon" }, { "name": "New Water Meter, Setting, and Vault", "code": "New Water Meter, Setting, and Vault" }, { "name": "Removed from Scope", "code": "Removed from Scope" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Work_Activity_Date", "type": "esriFieldTypeDate", "alias": "Work_Activity_Date", "length": 8, "domain": null }, { "name": "Comment", "type": "esriFieldTypeString", "alias": "Comment", "length": 70, "domain": null }, { "name": "Discrepancies", "type": "esriFieldTypeString", "alias": "Discrepancies", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Discrepancy_Type", "type": "esriFieldTypeString", "alias": "Discrepancy_Type", "length": 20, "domain": { "type": "codedValue", "name": "dDiscrepancyType", "description": "", "codedValues": [ { "name": "Attribute", "code": "Attribute" }, { "name": "Geometry", "code": "Geometry" }, { "name": "Other (see comments)", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 150, "domain": null }, { "name": "Work_Activity_Status", "type": "esriFieldTypeString", "alias": "Work_Activity_Status", "length": 20, "domain": { "type": "codedValue", "name": "dWorkActivityStatus", "description": "", "codedValues": [ { "name": "Not Complete/In Progress", "code": "Not Complete" }, { "name": "Current Work Activity Complete", "code": "Current Complete" }, { "name": "All Work Activities Complete", "code": "All Complete" }, { "name": "All Work Activities Complete and Asset in Service", "code": "All Complete+Service" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "In_Prog_Comment", "type": "esriFieldTypeString", "alias": "In_Prog_Comment", "length": 150, "domain": null }, { "name": "In_Service", "type": "esriFieldTypeString", "alias": "In_Service", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "All_Work_Complete", "type": "esriFieldTypeString", "alias": "All_Work_Complete", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RelObjectID", "type": "esriFieldTypeInteger", "alias": "RelObjectID", "domain": null }, { "name": "Meter_Install_Date", "type": "esriFieldTypeDate", "alias": "Meter_Install_Date", "length": 8, "domain": null }, { "name": "Guid", "type": "esriFieldTypeGUID", "alias": "Guid", "length": 38, "domain": null }, { "name": "Meter_No", "type": "esriFieldTypeString", "alias": "Meter_No", "length": 10, "domain": null }, { "name": "In_Scope", "type": "esriFieldTypeString", "alias": "In_Scope", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R32_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G80RelObjectID", "fields": "RelObjectID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G80Guid", "fields": "Guid", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "Guid", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Query,Map,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "advancedQueryCapabilities": { "useStandardizedQueries": false, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 8, "name": "AssetTrackers_DevelopmentDB.ASSET_TRACKER.Service_Work_Report", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Project_Number", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Project_Number", "type": "esriFieldTypeString", "alias": "Project_Number", "length": 50, "domain": { "type": "codedValue", "name": "dProject", "description": "", "codedValues": [ { "name": "WC1291", "code": "1291" }, { "name": "WC1275", "code": "1275" }, { "name": "WC1287", "code": "1287" }, { "name": "WC1288", "code": "1288" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Contractor", "type": "esriFieldTypeString", "alias": "Contractor", "length": 30, "domain": { "type": "codedValue", "name": "dContractor", "description": "", "codedValues": [ { "name": "J. Fletcher Creamer & Son, Inc", "code": "J. Fletcher Creamer & Son, Inc" }, { "name": "Civil Construction LLC", "code": "Civil Construction LLC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Inspected_By", "type": "esriFieldTypeString", "alias": "Inspected_By", "length": 50, "domain": { "type": "codedValue", "name": "dInspectors", "description": "", "codedValues": [ { "name": "Ashley Galloway", "code": "Ashley Galloway" }, { "name": "Luke Mulry", "code": "Luke Mulry" }, { "name": "Clarence Wayman", "code": "Clarence Wayman" }, { "name": "David Wiley", "code": "David Wiley" }, { "name": "Hernan Guadalupe", "code": "Hernan Guadalupe" }, { "name": "Utieyin Edema-Eyen", "code": "Utieyin Edema-Eyen" }, { "name": "Amin Alizad", "code": "Amin Alizad" }, { "name": "Amir Fayaz", "code": "Amir Fayaz" }, { "name": "Brian Brophy", "code": "Brian Brophy" }, { "name": "Fitzroy French", "code": "Fitzroy French" }, { "name": "Kia Saunders", "code": "Kia Saunders" }, { "name": "John Foster", "code": "John Foster" }, { "name": "Micheal Rebert", "code": "Micheal Rebert" }, { "name": "Prakash Shahi", "code": "Prakash Shahi" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Inspection_Date", "type": "esriFieldTypeDate", "alias": "Inspection_Date", "length": 8, "domain": null }, { "name": "Service_Work_Act", "type": "esriFieldTypeString", "alias": "Service_Work_Act", "length": 50, "domain": { "type": "codedValue", "name": "dService_Work_Activity", "description": "", "codedValues": [ { "name": "Renew Water Service", "code": "Renew Water Service" }, { "name": "New Water Service", "code": "New Water Service" }, { "name": "Replace Existing Water Service", "code": "Replace Existing Water Service" }, { "name": "Abandon", "code": "Abandon" }, { "name": "Removed from Scope", "code": "Removed from Scope" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Pipe_Size_Same", "type": "esriFieldTypeString", "alias": "Pipe_Size_Same", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "New_Pipe_Size", "type": "esriFieldTypeDouble", "alias": "New_Pipe_Size", "domain": { "type": "codedValue", "name": "WA_VVT_WSP_Pipe_Size", "description": "", "codedValues": [ { "name": ".63\"", "code": 0.63 }, { "name": ".75\"", "code": 0.75 }, { "name": "1\"", "code": 1 }, { "name": "1.25\"", "code": 1.25 }, { "name": "1.5\"", "code": 1.5 }, { "name": "2\"", "code": 2 }, { "name": "3\"", "code": 3 }, { "name": "4\"", "code": 4 }, { "name": "6\"", "code": 6 }, { "name": "8\"", "code": 8 }, { "name": "10\"", "code": 10 }, { "name": "12\"", "code": 12 }, { "name": "Unknown", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Material_Same", "type": "esriFieldTypeString", "alias": "Material_Same", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "New_Material", "type": "esriFieldTypeString", "alias": "New_Material", "length": 3, "domain": { "type": "codedValue", "name": "WA_VVT_WSP_Material", "description": "", "codedValues": [ { "name": "Cast Iron", "code": "CI" }, { "name": "Copper", "code": "COP" }, { "name": "Ductile Iron", "code": "DI" }, { "name": "Galvanized", "code": "GLV" }, { "name": "Polyethylene", "code": "PE" }, { "name": "PVC", "code": "PVC" }, { "name": "Steel", "code": "ST" }, { "name": "Unknown", "code": "UNK" }, { "name": "Lead", "code": "LD" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Length_Same", "type": "esriFieldTypeString", "alias": "Length_Same", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "New_Length", "type": "esriFieldTypeDouble", "alias": "New_Length", "domain": null }, { "name": "Additional_Work_Activity", "type": "esriFieldTypeString", "alias": "Additional_Work_Activity", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Service_Work_Act1", "type": "esriFieldTypeString", "alias": "Service_Work_Act1", "length": 50, "domain": { "type": "codedValue", "name": "dService_Work_Activity", "description": "", "codedValues": [ { "name": "Renew Water Service", "code": "Renew Water Service" }, { "name": "New Water Service", "code": "New Water Service" }, { "name": "Replace Existing Water Service", "code": "Replace Existing Water Service" }, { "name": "Abandon", "code": "Abandon" }, { "name": "Removed from Scope", "code": "Removed from Scope" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Discrepancies", "type": "esriFieldTypeString", "alias": "Discrepancies", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Discrepancy_Type", "type": "esriFieldTypeString", "alias": "Discrepancy_Type", "length": 20, "domain": { "type": "codedValue", "name": "dDiscrepancyType", "description": "", "codedValues": [ { "name": "Attribute", "code": "Attribute" }, { "name": "Geometry", "code": "Geometry" }, { "name": "Other (see comments)", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 150, "domain": null }, { "name": "Work_Activity_Status", "type": "esriFieldTypeString", "alias": "Work_Activity_Status", "length": 20, "domain": { "type": "codedValue", "name": "dWorkActivityStatus", "description": "", "codedValues": [ { "name": "Not Complete/In Progress", "code": "Not Complete" }, { "name": "Current Work Activity Complete", "code": "Current Complete" }, { "name": "All Work Activities Complete", "code": "All Complete" }, { "name": "All Work Activities Complete and Asset in Service", "code": "All Complete+Service" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "In_Prog_Comment", "type": "esriFieldTypeString", "alias": "In_Prog_Comment", "length": 150, "domain": null }, { "name": "In_Service", "type": "esriFieldTypeString", "alias": "In_Service", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "All_Work_Complete", "type": "esriFieldTypeString", "alias": "All_Work_Complete", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RelObjectID", "type": "esriFieldTypeInteger", "alias": "RelGlobalID", "domain": null }, { "name": "Guid", "type": "esriFieldTypeGUID", "alias": "Guid", "length": 38, "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 20, "domain": null }, { "name": "In_Scope", "type": "esriFieldTypeString", "alias": "In_Scope", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Work_Activity_Date", "type": "esriFieldTypeDate", "alias": "Work_Activity_Date", "length": 8, "domain": null } ], "indexes": [ { "name": "R33_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G81RelObjectID", "fields": "RelObjectID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G81Guid", "fields": "Guid", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "Guid", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Query,Map,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "advancedQueryCapabilities": { "useStandardizedQueries": false, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 9, "name": "AssetTrackers_DevelopmentDB.ASSET_TRACKER.Valve_Work_Report", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Contractor", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Contractor", "type": "esriFieldTypeString", "alias": "Contractor", "length": 30, "domain": { "type": "codedValue", "name": "dContractor", "description": "", "codedValues": [ { "name": "J. Fletcher Creamer & Son, Inc", "code": "J. Fletcher Creamer & Son, Inc" }, { "name": "Civil Construction LLC", "code": "Civil Construction LLC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Project_Number", "type": "esriFieldTypeString", "alias": "Project_Number", "length": 50, "domain": { "type": "codedValue", "name": "dProject", "description": "", "codedValues": [ { "name": "WC1291", "code": "1291" }, { "name": "WC1275", "code": "1275" }, { "name": "WC1287", "code": "1287" }, { "name": "WC1288", "code": "1288" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Inspected_By", "type": "esriFieldTypeString", "alias": "Inspected_By", "length": 50, "domain": { "type": "codedValue", "name": "dInspectors", "description": "", "codedValues": [ { "name": "Ashley Galloway", "code": "Ashley Galloway" }, { "name": "Luke Mulry", "code": "Luke Mulry" }, { "name": "Clarence Wayman", "code": "Clarence Wayman" }, { "name": "David Wiley", "code": "David Wiley" }, { "name": "Hernan Guadalupe", "code": "Hernan Guadalupe" }, { "name": "Utieyin Edema-Eyen", "code": "Utieyin Edema-Eyen" }, { "name": "Amin Alizad", "code": "Amin Alizad" }, { "name": "Amir Fayaz", "code": "Amir Fayaz" }, { "name": "Brian Brophy", "code": "Brian Brophy" }, { "name": "Fitzroy French", "code": "Fitzroy French" }, { "name": "Kia Saunders", "code": "Kia Saunders" }, { "name": "John Foster", "code": "John Foster" }, { "name": "Micheal Rebert", "code": "Micheal Rebert" }, { "name": "Prakash Shahi", "code": "Prakash Shahi" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Inspection_Date", "type": "esriFieldTypeDate", "alias": "Inspection_Date", "length": 8, "domain": null }, { "name": "Valve_Work_Activity", "type": "esriFieldTypeString", "alias": "Valve_Work_Activity", "length": 50, "domain": { "type": "codedValue", "name": "dValve_Work_Activity", "description": "", "codedValues": [ { "name": "Exercise Water Valves (Maintenance)", "code": "Exercise Water Valves (Maintenance)" }, { "name": "New Water Valve and Vault", "code": "New Water Valve and Vault" }, { "name": "Replace Existing Water Valve", "code": "Replace Existing Water Valve" }, { "name": "Replace Existing Vault", "code": "Replace Existing Vault" }, { "name": "Abandon", "code": "Abandon" }, { "name": "Removed from Scope", "code": "Removed from Scope" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VLV_Size_Same", "type": "esriFieldTypeString", "alias": "VLV_Size_Same", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "New_VLV_Size", "type": "esriFieldTypeDouble", "alias": "New_VLV_Size", "domain": null }, { "name": "Additional_Work_Activity", "type": "esriFieldTypeString", "alias": "Additional_Work_Activity", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Valve_Work_Activity1", "type": "esriFieldTypeString", "alias": "Valve_Work_Activity1", "length": 50, "domain": { "type": "codedValue", "name": "dValve_Work_Activity", "description": "", "codedValues": [ { "name": "Exercise Water Valves (Maintenance)", "code": "Exercise Water Valves (Maintenance)" }, { "name": "New Water Valve and Vault", "code": "New Water Valve and Vault" }, { "name": "Replace Existing Water Valve", "code": "Replace Existing Water Valve" }, { "name": "Replace Existing Vault", "code": "Replace Existing Vault" }, { "name": "Abandon", "code": "Abandon" }, { "name": "Removed from Scope", "code": "Removed from Scope" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Work_Activity_Date", "type": "esriFieldTypeDate", "alias": "Work_Activity_Date", "length": 8, "domain": null }, { "name": "Comment", "type": "esriFieldTypeString", "alias": "Comment", "length": 70, "domain": null }, { "name": "Discrepancies", "type": "esriFieldTypeString", "alias": "Discrepancies", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Discrepancy_Type", "type": "esriFieldTypeString", "alias": "Discrepancy_Type", "length": 20, "domain": { "type": "codedValue", "name": "dDiscrepancyType", "description": "", "codedValues": [ { "name": "Attribute", "code": "Attribute" }, { "name": "Geometry", "code": "Geometry" }, { "name": "Other (see comments)", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 150, "domain": null }, { "name": "Work_Activity_Status", "type": "esriFieldTypeString", "alias": "Work_Activity_Status", "length": 20, "domain": { "type": "codedValue", "name": "dWorkActivityStatus", "description": "", "codedValues": [ { "name": "Not Complete/In Progress", "code": "Not Complete" }, { "name": "Current Work Activity Complete", "code": "Current Complete" }, { "name": "All Work Activities Complete", "code": "All Complete" }, { "name": "All Work Activities Complete and Asset in Service", "code": "All Complete+Service" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "In_Prog_Comment", "type": "esriFieldTypeString", "alias": "In_Prog_Comment", "length": 150, "domain": null }, { "name": "In_Service", "type": "esriFieldTypeString", "alias": "In_Service", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "All_Work_Complete", "type": "esriFieldTypeString", "alias": "All_Work_Complete", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RelObjectID", "type": "esriFieldTypeInteger", "alias": "RelObjectID", "domain": null }, { "name": "Valve_Install_Date", "type": "esriFieldTypeDate", "alias": "Valve_Install_Date", "length": 8, "domain": null }, { "name": "Guid", "type": "esriFieldTypeGUID", "alias": "Guid", "length": 38, "domain": null }, { "name": "VLV_ID", "type": "esriFieldTypeString", "alias": "VLV_ID", "length": 15, "domain": null }, { "name": "In_Scope", "type": "esriFieldTypeString", "alias": "In_Scope", "length": 3, "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R34_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G82RelObjectID", "fields": "RelObjectID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G82Guid", "fields": "Guid", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Guid", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Query,Map,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "advancedQueryCapabilities": { "useStandardizedQueries": false, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } } ] }