{ "layers": [ { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 1, "name": "WA_Meter", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "Meters are instruments used to measure the quantity of water consumption by a customer for the purposes of billing.", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "", "relatedTableId": 7, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false } ], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": 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 } }, "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 }, "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 }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "TAG", "typeIdField": "", "subtypeField": "METERTYPE", "defaultSubtypeCode": 1, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "TAG", "type": "esriFieldTypeString", "alias": "Tag", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "TAG" }, { "name": "DATEABANDONED", "type": "esriFieldTypeDate", "alias": "DATEABANDONED", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATEABANDONED" }, { "name": "LAST_ORGANIZATION", "type": "esriFieldTypeString", "alias": "LAST_ORGANIZATION", "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" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "LAST_ORGANIZATION" }, { "name": "CAPTURE_METHOD", "type": "esriFieldTypeString", "alias": "CAPTURE_METHOD", "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" }, "editable": true, "nullable": true, "length": 4, "defaultValue": "PLAT", "modelName": "CAPTURE_METHOD" }, { "name": "LAST_USER", "type": "esriFieldTypeString", "alias": "LAST_USER", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LAST_USER" }, { "name": "EDIT_DATE", "type": "esriFieldTypeDate", "alias": "EDIT_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EDIT_DATE" }, { "name": "METER_NO", "type": "esriFieldTypeString", "alias": "METER_NO", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "METER_NO" }, { "name": "MT_SIZE", "type": "esriFieldTypeDouble", "alias": "MT_SIZE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MT_SIZE" }, { "name": "METER_TYPE_CD", "type": "esriFieldTypeString", "alias": "METER_TYPE_CD", "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" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "METER_TYPE_CD" }, { "name": "ACCOUNT_NO", "type": "esriFieldTypeString", "alias": "ACCOUNT_NO", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "ACCOUNT_NO" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "INSTALL_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_DATE" }, { "name": "METERTYPE", "type": "esriFieldTypeInteger", "alias": "METERTYPE", "domain": null, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "METERTYPE" }, { "name": "FEAT_STATUS", "type": "esriFieldTypeString", "alias": "FEAT_STATUS", "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" }, "editable": true, "nullable": true, "length": 3, "defaultValue": "ACT", "modelName": "FEAT_STATUS" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "ENABLED" }, { "name": "SERVICE_SIZE", "type": "esriFieldTypeDouble", "alias": "SERVICE_SIZE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SERVICE_SIZE" }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FacilityID" }, { "name": "DOCPOPURL", "type": "esriFieldTypeString", "alias": "DOCPOPURL", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "DOCPOPURL" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 120, "defaultValue": null, "modelName": "LOCATION" }, { "name": "IN_SCOPE", "type": "esriFieldTypeString", "alias": "IN_SCOPE", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "IN_SCOPE" }, { "name": "PROJECT", "type": "esriFieldTypeString", "alias": "PROJECT", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PROJECT" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "R36_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_36", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "WA_Meter", "description": "", "prototype": { "attributes": { "PROJECT": null, "IN_SCOPE": null, "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 } }, "drawingTool": "esriFeatureEditToolPoint" } ], "subtypes": [ { "code": 1, "name": "DetectorCheck", "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 }, "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"} } }, { "code": 2, "name": "Domestic", "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 }, "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"} } }, { "code": 3, "name": "FM", "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 }, "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"} } }, { "code": 7, "name": "LocationOnly", "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 }, "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"} } }, { "code": 6, "name": "FlatRate", "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 }, "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"} } }, { "code": 5, "name": "Removed", "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 }, "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"} } }, { "code": 4, "name": "Venturi", "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 }, "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"} } } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 2, "name": "WA_Hydrant", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "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.", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 1, "name": "", "relatedTableId": 5, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false } ], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": 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 } }, "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 }, "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 }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "STREET_NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 20, "modelName": "MANUF_MODEL_CD" }, { "name": "LOCK_MODEL_CD", "type": "esriFieldTypeString", "alias": "LOCK_MODEL_CD", "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" }, "editable": true, "nullable": true, "length": 3, "defaultValue": "UNK", "modelName": "LOCK_MODEL_CD" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 6, "modelName": "LAT_SIZE" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "SRC_MAIN_SIZE" }, { "name": "PRESSURE_ZONE", "type": "esriFieldTypeString", "alias": "PRESSURE_ZONE", "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" }, "editable": true, "nullable": true, "length": 4, "defaultValue": "UNK", "modelName": "PRESSURE_ZONE" }, { "name": "BREAKAWAY", "type": "esriFieldTypeString", "alias": "BREAKAWAY", "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" }, "editable": true, "nullable": true, "length": 3, "defaultValue": "UNK", "modelName": "BREAKAWAY" }, { "name": "FEAT_STATUS", "type": "esriFieldTypeString", "alias": "FEAT_STATUS", "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" }, "editable": true, "nullable": true, "length": 3, "defaultValue": "ACT", "modelName": "FEAT_STATUS" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "ENABLED" }, { "name": "RESP_AGENCY", "type": "esriFieldTypeString", "alias": "RESP_AGENCY", "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" }, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "RESP_AGENCY" }, { "name": "LAST_ORGANIZATION", "type": "esriFieldTypeString", "alias": "LAST_ORGANIZATION", "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" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "LAST_ORGANIZATION" }, { "name": "CAPTURE_METHOD", "type": "esriFieldTypeString", "alias": "CAPTURE_METHOD", "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" }, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "CAPTURE_METHOD" }, { "name": "LAST_USER", "type": "esriFieldTypeString", "alias": "LAST_USER", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LAST_USER" }, { "name": "TAG", "type": "esriFieldTypeString", "alias": "TAG", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "TAG" }, { "name": "DATEABANDONED", "type": "esriFieldTypeDate", "alias": "DATEABANDONED", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATEABANDONED" }, { "name": "EDIT_DATE", "type": "esriFieldTypeDate", "alias": "EDIT_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EDIT_DATE" }, { "name": "HYDRANT_ID", "type": "esriFieldTypeString", "alias": "HYDRANT_ID", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": "UNK", "modelName": "HYDRANT_ID" }, { "name": "STATIC_PRESSURE", "type": "esriFieldTypeDouble", "alias": "STATIC_PRESSURE", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "STATIC_PRESSURE" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "INSTALL_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_DATE" }, { "name": "OPER_DATE", "type": "esriFieldTypeDate", "alias": "OPER_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "OPER_DATE" }, { "name": "FAB_DATE", "type": "esriFieldTypeDate", "alias": "FAB_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "FAB_DATE" }, { "name": "BURY", "type": "esriFieldTypeDouble", "alias": "BURY", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "BURY" }, { "name": "MAX_FLOW_RATE", "type": "esriFieldTypeDouble", "alias": "MAX_FLOW_RATE", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "MAX_FLOW_RATE" }, { "name": "EDIT_COMMENT", "type": "esriFieldTypeString", "alias": "EDIT_COMMENT", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": "NONE", "modelName": "EDIT_COMMENT" }, { "name": "CITY_ENUM", "type": "esriFieldTypeString", "alias": "CITY_ENUM", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "CITY_ENUM" }, { "name": "DOCPOPURL", "type": "esriFieldTypeString", "alias": "DOCPOPURL", "domain": null, "editable": true, "nullable": true, "length": 300, "defaultValue": null, "modelName": "DOCPOPURL" }, { "name": "ELEVATION", "type": "esriFieldTypeDouble", "alias": "ELEVATION", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ELEVATION" }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FacilityID" }, { "name": "BFD_FIELDCHECK_DATE", "type": "esriFieldTypeDate", "alias": "BFD_FIELDCHECK_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "BFD_FIELDCHECK_DATE" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BFD_FIELDCHECK_STATUS" }, { "name": "LOCATION_TYPE", "type": "esriFieldTypeString", "alias": "LOCATION_TYPE", "domain": { "type": "codedValue", "name": "WA_HYDLocationType", "description": "", "codedValues": [ { "name": "INTERSECTION", "code": "INT" }, { "name": "ADDRESS", "code": "ADDR" }, { "name": "BLOCK", "code": "BLK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LOCATION_TYPE" }, { "name": "STREET_NUM", "type": "esriFieldTypeString", "alias": "STREET_NUM", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "STREET_NUM" }, { "name": "STREET_NAME", "type": "esriFieldTypeString", "alias": "STREET_NAME", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STREET_NAME" }, { "name": "CAD_ADDR", "type": "esriFieldTypeString", "alias": "CAD_ADDR", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CAD_ADDR" }, { "name": "CROSS_STREET", "type": "esriFieldTypeString", "alias": "CROSS_STREET", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CROSS_STREET" }, { "name": "CORNER_POSITION", "type": "esriFieldTypeString", "alias": "CORNER_POSITION", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CORNER_POSITION" }, { "name": "LOCATION_DESCRIPTION", "type": "esriFieldTypeString", "alias": "LOCATION_DESCRIPTION", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LOCATION_DESCRIPTION" }, { "name": "DISTRICT", "type": "esriFieldTypeString", "alias": "DISTRICT", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "DISTRICT" }, { "name": "HYDR_ZONE", "type": "esriFieldTypeInteger", "alias": "HYDR_ZONE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "HYDR_ZONE" }, { "name": "LOCATION_DESCRIPTION2", "type": "esriFieldTypeString", "alias": "LOCATION_DESCRIPTION2", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATION_DESCRIPTION2" }, { "name": "IN_SCOPE", "type": "esriFieldTypeString", "alias": "IN_SCOPE", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "IN_SCOPE" }, { "name": "PROJECT", "type": "esriFieldTypeString", "alias": "PROJECT", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PROJECT" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "R37_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_37", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "WA_Hydrant", "description": "", "prototype": { "attributes": { "PROJECT": null, "IN_SCOPE": null, "MANUF_MODEL_CD": 20, "LOCK_MODEL_CD": "UNK", "LAT_SIZE": 6, "SRC_MAIN_SIZE": 0, "PRESSURE_ZONE": "UNK", "BREAKAWAY": "UNK", "FEAT_STATUS": "ACT", "ENABLED": 1, "RESP_AGENCY": null, "LAST_ORGANIZATION": null, "CAPTURE_METHOD": null, "LAST_USER": null, "TAG": null, "DATEABANDONED": null, "EDIT_DATE": null, "HYDRANT_ID": "UNK", "STATIC_PRESSURE": 0, "INSTALL_DATE": null, "OPER_DATE": null, "FAB_DATE": null, "BURY": 0, "MAX_FLOW_RATE": 0, "EDIT_COMMENT": "NONE", "CITY_ENUM": null, "DOCPOPURL": null, "ELEVATION": null, "FacilityID": null, "BFD_FIELDCHECK_DATE": null, "BFD_FIELDCHECK_STATUS": null, "LOCATION_TYPE": null, "STREET_NUM": null, "STREET_NAME": null, "CAD_ADDR": null, "CROSS_STREET": null, "CORNER_POSITION": null, "LOCATION_DESCRIPTION": null, "DISTRICT": null, "HYDR_ZONE": null, "LOCATION_DESCRIPTION2": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 0, "name": "WA_Valve", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "Valves used to regulate flow and isolate portions of the collection system.", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 2, "name": "", "relatedTableId": 9, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false } ], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": 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 } }, "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 }, "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 }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "MANUF_CD", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "VALVE_USE" }, { "name": "MANUF_CD", "type": "esriFieldTypeString", "alias": "MANUF_CD", "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" }, "editable": true, "nullable": true, "length": 3, "defaultValue": "UNK", "modelName": "MANUF_CD" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "VLV_SIZE" }, { "name": "VLV_CLOSE_DIR", "type": "esriFieldTypeString", "alias": "VLV_CLOSE_DIR", "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" }, "editable": true, "nullable": true, "length": 3, "defaultValue": "UNK", "modelName": "VLV_CLOSE_DIR" }, { "name": "STRUCTURE", "type": "esriFieldTypeString", "alias": "STRUCTURE", "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" }, "editable": true, "nullable": true, "length": 3, "defaultValue": "UNK", "modelName": "STRUCTURE" }, { "name": "FEAT_STATUS", "type": "esriFieldTypeString", "alias": "FEAT_STATUS", "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" }, "editable": true, "nullable": true, "length": 3, "defaultValue": "ACT", "modelName": "FEAT_STATUS" }, { "name": "CONDITION", "type": "esriFieldTypeString", "alias": "CONDITION", "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" }, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "CONDITION" }, { "name": "LAST_ORGANIZATION", "type": "esriFieldTypeString", "alias": "LAST_ORGANIZATION", "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" }, "editable": true, "nullable": true, "length": 3, "defaultValue": "UNK", "modelName": "LAST_ORGANIZATION" }, { "name": "CAPTURE_METHOD", "type": "esriFieldTypeString", "alias": "CAPTURE_METHOD", "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" }, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "CAPTURE_METHOD" }, { "name": "LAST_USER", "type": "esriFieldTypeString", "alias": "LAST_USER", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": "UNK", "modelName": "LAST_USER" }, { "name": "TAG", "type": "esriFieldTypeString", "alias": "TAG", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": "UNK", "modelName": "TAG" }, { "name": "DATEABANDONED", "type": "esriFieldTypeDate", "alias": "DATEABANDONED", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATEABANDONED" }, { "name": "EDIT_DATE", "type": "esriFieldTypeDate", "alias": "EDIT_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EDIT_DATE" }, { "name": "VLV_ID", "type": "esriFieldTypeString", "alias": "VLV_ID", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": "UNK", "modelName": "VLV_ID" }, { "name": "COVER_DEPTH", "type": "esriFieldTypeDouble", "alias": "COVER_DEPTH", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "COVER_DEPTH" }, { "name": "OPNUT_DEPTH", "type": "esriFieldTypeDouble", "alias": "OPNUT_DEPTH", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "OPNUT_DEPTH" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "INSTALL_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_DATE" }, { "name": "DATE_OPERATED", "type": "esriFieldTypeDate", "alias": "DATE_OPERATED", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATE_OPERATED" }, { "name": "DOCPOPURL", "type": "esriFieldTypeString", "alias": "DOCPOPURL", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "DOCPOPURL" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BYP_VALVE_PRESENT" }, { "name": "ELEVATION", "type": "esriFieldTypeDouble", "alias": "ELEVATION", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ELEVATION" }, { "name": "MAX_TURNS", "type": "esriFieldTypeDouble", "alias": "MAX_TURNS", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MAX_TURNS" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "Enabled" }, { "name": "MAXIMUM_MAX_TORQUE", "type": "esriFieldTypeDouble", "alias": "MAXIMUM_MAX_TORQUE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MAXIMUM_MAX_TORQUE" }, { "name": "ORIENTATION", "type": "esriFieldTypeString", "alias": "ORIENTATION", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "ORIENTATION" }, { "name": "VALVE_TYPE", "type": "esriFieldTypeString", "alias": "VALVE_TYPE", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "VALVE_TYPE" }, { "name": "CITY_ENUM", "type": "esriFieldTypeString", "alias": "CITY_ENUM", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "CITY_ENUM" }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FacilityID" }, { "name": "MAXIMUM_FINAL_TORQUE", "type": "esriFieldTypeDouble", "alias": "MAXIMUM_FINAL_TORQUE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MAXIMUM_FINAL_TORQUE" }, { "name": "BYP_MAX_TURNS", "type": "esriFieldTypeDouble", "alias": "BYP_MAX_TURNS", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BYP_MAX_TURNS" }, { "name": "POSITION_LEFT", "type": "esriFieldTypeString", "alias": "POSITION_LEFT", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "POSITION_LEFT" }, { "name": "FROZEN", "type": "esriFieldTypeString", "alias": "FROZEN", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FROZEN" }, { "name": "EXERCISE", "type": "esriFieldTypeString", "alias": "EXERCISE", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "EXERCISE" }, { "name": "ACCESS", "type": "esriFieldTypeString", "alias": "ACCESS", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "ACCESS" }, { "name": "IN_SCOPE", "type": "esriFieldTypeString", "alias": "IN_SCOPE", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "IN_SCOPE" }, { "name": "PROJECT", "type": "esriFieldTypeString", "alias": "PROJECT", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PROJECT" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "R38_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_38", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "WA_Valve", "description": "", "prototype": { "attributes": { "PROJECT": null, "IN_SCOPE": null, "VALVE_USE": null, "MANUF_CD": "UNK", "VLV_SIZE": 0, "VLV_CLOSE_DIR": "UNK", "STRUCTURE": "UNK", "FEAT_STATUS": "ACT", "CONDITION": null, "LAST_ORGANIZATION": "UNK", "CAPTURE_METHOD": null, "LAST_USER": "UNK", "TAG": "UNK", "DATEABANDONED": null, "EDIT_DATE": null, "VLV_ID": "UNK", "COVER_DEPTH": 0, "OPNUT_DEPTH": 0, "INSTALL_DATE": null, "DATE_OPERATED": null, "DOCPOPURL": null, "BYP_VALVE_PRESENT": null, "ELEVATION": null, "MAX_TURNS": null, "Enabled": 1, "MAXIMUM_MAX_TORQUE": null, "ORIENTATION": null, "VALVE_TYPE": null, "CITY_ENUM": null, "FacilityID": null, "MAXIMUM_FINAL_TORQUE": null, "BYP_MAX_TURNS": null, "POSITION_LEFT": null, "FROZEN": null, "EXERCISE": null, "ACCESS": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 3, "name": "WA_Service", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "A service is a pipe that runs between the main and the customer\u2019s place of consumption.", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 3, "name": "", "relatedTableId": 8, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false } ], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape__Length", "units": "esriMeters" }, "hasMetadata": 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 } }, "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 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 70, 145, 0, 255 ], "width": 1 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "TAG", "typeIdField": "", "subtypeField": "SERVICETYPE", "defaultSubtypeCode": 1, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "TAG", "type": "esriFieldTypeString", "alias": "Tag", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "TAG" }, { "name": "DATEABANDONED", "type": "esriFieldTypeDate", "alias": "DATEABANDONED", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATEABANDONED" }, { "name": "LAST_ORGANIZATION", "type": "esriFieldTypeString", "alias": "LAST_ORGANIZATION", "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" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "LAST_ORGANIZATION" }, { "name": "CAPTURE_METHOD", "type": "esriFieldTypeString", "alias": "CAPTURE_METHOD", "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" }, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "CAPTURE_METHOD" }, { "name": "LAST_USER", "type": "esriFieldTypeString", "alias": "LAST_USER", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LAST_USER" }, { "name": "EDIT_DATE", "type": "esriFieldTypeDate", "alias": "EDIT_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EDIT_DATE" }, { "name": "CLASS_TYPE", "type": "esriFieldTypeString", "alias": "CLASS_TYPE", "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" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "CLASS_TYPE" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "INSTALL_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_DATE" }, { "name": "MATERIAL_CD", "type": "esriFieldTypeString", "alias": "MATERIAL_CD", "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" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "MATERIAL_CD" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PIP_SIZE" }, { "name": "SERVICETYPE", "type": "esriFieldTypeInteger", "alias": "SERVICETYPE", "domain": null, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "SERVICETYPE" }, { "name": "FEAT_STATUS", "type": "esriFieldTypeString", "alias": "FEAT_STATUS", "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" }, "editable": true, "nullable": true, "length": 3, "defaultValue": "ACT", "modelName": "FEAT_STATUS" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "ENABLED" }, { "name": "OWNER_CD", "type": "esriFieldTypeString", "alias": "OWNER_CD", "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" }, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "OWNER_CD" }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FacilityID" }, { "name": "LENGTH", "type": "esriFieldTypeDouble", "alias": "LENGTH", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LENGTH" }, { "name": "IN_SCOPE", "type": "esriFieldTypeString", "alias": "IN_SCOPE", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "IN_SCOPE" }, { "name": "PROJECT", "type": "esriFieldTypeString", "alias": "PROJECT", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PROJECT" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "SHAPE.STLength()" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "R39_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_39", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "WA_Service", "description": "", "prototype": { "attributes": { "IN_SCOPE": null, "PROJECT": null, "TAG": null, "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 } }, "drawingTool": "esriFeatureEditToolLine" } ], "subtypes": [ { "code": 2, "name": "DomesicGreaterThan2", "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, "SHAPE.STLength()": null }, "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"} } }, { "code": 3, "name": "FireService", "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, "SHAPE.STLength()": null }, "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"} } }, { "code": 1, "name": "DomesticLessThan2", "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, "SHAPE.STLength()": null }, "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"} } }, { "code": 4, "name": "Combined Fire and Domestic Service", "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": 4, "FEAT_STATUS": "ACT", "ENABLED": 1, "OWNER_CD": null, "FacilityID": null, "LENGTH": null, "IN_SCOPE": null, "PROJECT": null, "GlobalID": null, "SHAPE.STLength()": null }, "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"} } } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 4, "name": "WA_Main", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "A main is a water pipe operated and maintained for the purpose of transmission and/or distribution of water to customers.", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 4, "name": "", "relatedTableId": 6, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "GlobalID", "composite": false } ], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape__Length", "units": "esriMeters" }, "hasMetadata": 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 } }, "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 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 106, 128, 0, 255 ], "width": 1 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "CLASS", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CLASS", "type": "esriFieldTypeString", "alias": "CLASS", "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" }, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "CLASS" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LINE_TYPE" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "PIP_SIZE" }, { "name": "DATEABANDONED", "type": "esriFieldTypeDate", "alias": "DATEABANDONED", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATEABANDONED" }, { "name": "MATERIAL_CD", "type": "esriFieldTypeString", "alias": "MATERIAL_CD", "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" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "MATERIAL_CD" }, { "name": "COATING_TYPE_CD", "type": "esriFieldTypeString", "alias": "COATING_TYPE_CD", "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" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "COATING_TYPE_CD" }, { "name": "NORM_OP_PRESSURE", "type": "esriFieldTypeDouble", "alias": "NORM_OP_PRESSURE", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "NORM_OP_PRESSURE" }, { "name": "MAX_OP_PRESSURE", "type": "esriFieldTypeDouble", "alias": "MAX_OP_PRESSURE", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "MAX_OP_PRESSURE" }, { "name": "PRESSURE_CD", "type": "esriFieldTypeString", "alias": "PRESSURE_CD", "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" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "PRESSURE_CD" }, { "name": "PRESSURE_ZONE", "type": "esriFieldTypeString", "alias": "PRESSURE_ZONE", "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" }, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "PRESSURE_ZONE" }, { "name": "DEAD_END_IND", "type": "esriFieldTypeString", "alias": "DEAD_END_IND", "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" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "DEAD_END_IND" }, { "name": "FEAT_STATUS", "type": "esriFieldTypeString", "alias": "FEAT_STATUS", "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" }, "editable": true, "nullable": true, "length": 3, "defaultValue": "ACT", "modelName": "FEAT_STATUS" }, { "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" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "ENABLED" }, { "name": "RESP_AGENCY", "type": "esriFieldTypeString", "alias": "RESP_AGENCY", "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" }, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "RESP_AGENCY" }, { "name": "SYMBOL", "type": "esriFieldTypeString", "alias": "SYMBOL", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": "UNK", "modelName": "SYMBOL" }, { "name": "LAST_ORGANIZATION", "type": "esriFieldTypeString", "alias": "LAST_ORGANIZATION", "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" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "LAST_ORGANIZATION" }, { "name": "CAPTURE_METHOD", "type": "esriFieldTypeString", "alias": "CAPTURE_METHOD", "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" }, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "CAPTURE_METHOD" }, { "name": "LAST_USER", "type": "esriFieldTypeString", "alias": "LAST_USER", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LAST_USER" }, { "name": "TAG", "type": "esriFieldTypeString", "alias": "TAG", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": "UNK", "modelName": "TAG" }, { "name": "EDIT_DATE", "type": "esriFieldTypeDate", "alias": "EDIT_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EDIT_DATE" }, { "name": "MAIN_ID", "type": "esriFieldTypeString", "alias": "MAIN_ID", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "MAIN_ID" }, { "name": "COVER_DEPTH", "type": "esriFieldTypeDouble", "alias": "COVER_DEPTH", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "COVER_DEPTH" }, { "name": "INSTALL_DATE", "type": "esriFieldTypeDate", "alias": "INSTALL_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALL_DATE" }, { "name": "LINING_DATE", "type": "esriFieldTypeDate", "alias": "LINING_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LINING_DATE" }, { "name": "DOCPOPURL", "type": "esriFieldTypeString", "alias": "DOCPOPURL", "domain": null, "editable": true, "nullable": true, "length": 300, "defaultValue": null, "modelName": "DOCPOPURL" }, { "name": "CITY_ENUM", "type": "esriFieldTypeString", "alias": "CITY_ENUM", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "CITY_ENUM" }, { "name": "LENGTH", "type": "esriFieldTypeDouble", "alias": "LENGTH", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LENGTH" }, { "name": "LENGTH_divided_by_subsegs", "type": "esriFieldTypeDouble", "alias": "LENGTH_divided_by_subsegs", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LENGTH_divided_by_subsegs" }, { "name": "LINING_TYPE_CD", "type": "esriFieldTypeString", "alias": "LINING_TYPE_CD", "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" }, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "LINING_TYPE_CD" }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FacilityID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "IN_SCOPE", "type": "esriFieldTypeString", "alias": "IN_SCOPE", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "IN_SCOPE" }, { "name": "PROJECT", "type": "esriFieldTypeString", "alias": "PROJECT", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PROJECT" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "SHAPE.STLength()" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "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": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "WA_Main", "description": "", "prototype": { "attributes": { "IN_SCOPE": null, "PROJECT": null, "CLASS": null, "LINE_TYPE": null, "PIP_SIZE": 0, "DATEABANDONED": null, "MATERIAL_CD": null, "COATING_TYPE_CD": null, "NORM_OP_PRESSURE": 0, "MAX_OP_PRESSURE": 0, "PRESSURE_CD": null, "PRESSURE_ZONE": null, "DEAD_END_IND": null, "FEAT_STATUS": "ACT", "ENABLED": 1, "RESP_AGENCY": null, "SYMBOL": "UNK", "LAST_ORGANIZATION": null, "CAPTURE_METHOD": null, "LAST_USER": null, "TAG": "UNK", "EDIT_DATE": null, "MAIN_ID": null, "COVER_DEPTH": 0, "INSTALL_DATE": null, "LINING_DATE": null, "DOCPOPURL": null, "CITY_ENUM": null, "LENGTH": null, "LENGTH_divided_by_subsegs": null, "LINING_TYPE_CD": null, "FacilityID": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 } ], "tables": [ { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 5, "name": "AssetTrackers_DevelopmentDB.ASSET_TRACKER.Hydrant_Work_Report", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 1, "name": "", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Guid", "composite": false } ], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Contractor", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Contractor", "type": "esriFieldTypeString", "alias": "Contractor", "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" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "Contractor" }, { "name": "Project_Number", "type": "esriFieldTypeString", "alias": "Project_Number", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Project_Number" }, { "name": "Inspected_By", "type": "esriFieldTypeString", "alias": "Inspected_By", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Inspected_By" }, { "name": "Inspection_Date", "type": "esriFieldTypeDate", "alias": "Inspection_Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Inspection_Date" }, { "name": "Hydrant_Work_Activity", "type": "esriFieldTypeString", "alias": "Hydrant_Work_Activity", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Hydrant_Work_Activity" }, { "name": "New_Lat_Size", "type": "esriFieldTypeDouble", "alias": "New_Lat_Size", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "New_Lat_Size" }, { "name": "New_Src_Main_Size", "type": "esriFieldTypeDouble", "alias": "New_SRC_Main_Size", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "New_Src_Main_Size" }, { "name": "Hydrant_Install_Date", "type": "esriFieldTypeDate", "alias": "Hydrant_Install_Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Hydrant_Install_Date" }, { "name": "Additional_Work_Activity", "type": "esriFieldTypeString", "alias": "Additional_Work_Activity", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Additional_Work_Activity" }, { "name": "Hydrant_Work_Activity1", "type": "esriFieldTypeString", "alias": "Hydrant_Work_Activity1", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Hydrant_Work_Activity1" }, { "name": "Work_Activity_Date", "type": "esriFieldTypeDate", "alias": "Work_Activity_Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Work_Activity_Date" }, { "name": "Comment", "type": "esriFieldTypeString", "alias": "Comment", "domain": null, "editable": true, "nullable": true, "length": 70, "defaultValue": null, "modelName": "Comment" }, { "name": "Discrepancies", "type": "esriFieldTypeString", "alias": "Discrepancies", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Discrepancies" }, { "name": "Discrepancy_Type", "type": "esriFieldTypeString", "alias": "Discrepancy_Type", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Discrepancy_Type" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "Comments" }, { "name": "Work_Activity_Status", "type": "esriFieldTypeString", "alias": "Work_Activity_Status", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Work_Activity_Status" }, { "name": "In_Prog_Comment", "type": "esriFieldTypeString", "alias": "In_Prog_Comment", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "In_Prog_Comment" }, { "name": "In_Service", "type": "esriFieldTypeString", "alias": "In_Service", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "In_Service" }, { "name": "All_Work_Complete", "type": "esriFieldTypeString", "alias": "All_Work_Complete", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "All_Work_Complete" }, { "name": "RelObjectID", "type": "esriFieldTypeInteger", "alias": "RelObjectID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RelObjectID" }, { "name": "Lat_Size_Same", "type": "esriFieldTypeString", "alias": "Lat_Size_Same", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Lat_Size_Same" }, { "name": "Src_Main_Size_Same", "type": "esriFieldTypeString", "alias": "Src_Main_Size_Same", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Src_Main_Size_Same" }, { "name": "Guid", "type": "esriFieldTypeGUID", "alias": "Guid", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Guid" }, { "name": "Hydrant_ID", "type": "esriFieldTypeString", "alias": "Hydrant_ID", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "Hydrant_ID" }, { "name": "In_Scope", "type": "esriFieldTypeString", "alias": "In_Scope", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "In_Scope" } ], "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": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "AssetTrackers_DevelopmentDB.ASSET_TRACKER.Hydrant_Work_Report", "description": "", "prototype": { "attributes": { "Hydrant_ID": null, "In_Scope": null, "Contractor": null, "Project_Number": null, "Inspected_By": null, "Inspection_Date": null, "Hydrant_Work_Activity": null, "New_Lat_Size": null, "New_Src_Main_Size": null, "Hydrant_Install_Date": null, "Additional_Work_Activity": null, "Hydrant_Work_Activity1": null, "Work_Activity_Date": null, "Comment": null, "Discrepancies": null, "Discrepancy_Type": null, "Comments": null, "Work_Activity_Status": null, "In_Prog_Comment": null, "In_Service": null, "All_Work_Complete": null, "RelObjectID": null, "Lat_Size_Same": null, "Src_Main_Size_Same": null, "Guid": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 6, "name": "AssetTrackers_DevelopmentDB.ASSET_TRACKER.Main_Work_Report", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 4, "name": "", "relatedTableId": 4, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Guid", "composite": false } ], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Project_Number", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Project_Number", "type": "esriFieldTypeString", "alias": "Project_Number", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Project_Number" }, { "name": "Contractor", "type": "esriFieldTypeString", "alias": "Contractor", "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" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "Contractor" }, { "name": "Inspected_By", "type": "esriFieldTypeString", "alias": "Inspected_By", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Inspected_By" }, { "name": "Inspection_Date", "type": "esriFieldTypeDate", "alias": "Inspection_Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Inspection_Date" }, { "name": "Main_Work_Activity", "type": "esriFieldTypeString", "alias": "Main_Work_Activity", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Main_Work_Activity" }, { "name": "Pipe_Size_Same", "type": "esriFieldTypeString", "alias": "Pipe_Size_Same", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Pipe_Size_Same" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "New_Pipe_Size" }, { "name": "Material_Same", "type": "esriFieldTypeString", "alias": "Material_Same", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Material_Same" }, { "name": "New_Material", "type": "esriFieldTypeString", "alias": "New_Material", "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" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "New_Material" }, { "name": "Length_Same", "type": "esriFieldTypeString", "alias": "Length_Same", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Length_Same" }, { "name": "New_Length", "type": "esriFieldTypeDouble", "alias": "New_Length", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "New_Length" }, { "name": "Additional_Work_Activity", "type": "esriFieldTypeString", "alias": "Additional_Work_Activity", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Additional_Work_Activity" }, { "name": "Main_Work_Activity1", "type": "esriFieldTypeString", "alias": "Main_Work_Activity1", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Main_Work_Activity1" }, { "name": "Discrepancies", "type": "esriFieldTypeString", "alias": "Discrepancies", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Discrepancies" }, { "name": "Discrepancy_Type", "type": "esriFieldTypeString", "alias": "Discrepancy_Type", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Discrepancy_Type" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "Comments" }, { "name": "Work_Activity_Status", "type": "esriFieldTypeString", "alias": "Work_Activity_Status", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Work_Activity_Status" }, { "name": "In_Prog_Comment", "type": "esriFieldTypeString", "alias": "In_Prog_Comment", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "In_Prog_Comment" }, { "name": "In_Service", "type": "esriFieldTypeString", "alias": "In_Service", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "In_Service" }, { "name": "All_Work_Complete", "type": "esriFieldTypeString", "alias": "All_Work_Complete", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "All_Work_Complete" }, { "name": "RelObjectID", "type": "esriFieldTypeInteger", "alias": "RelGlobalID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RelObjectID" }, { "name": "Guid", "type": "esriFieldTypeGUID", "alias": "Guid", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Guid" }, { "name": "Main_ID", "type": "esriFieldTypeString", "alias": "Main_ID", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "Main_ID" }, { "name": "In_Scope", "type": "esriFieldTypeString", "alias": "In_Scope", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "In_Scope" }, { "name": "Work_Activity_Date", "type": "esriFieldTypeDate", "alias": "Work_Activity_Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Work_Activity_Date" } ], "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": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "AssetTrackers_DevelopmentDB.ASSET_TRACKER.Main_Work_Report", "description": "", "prototype": { "attributes": { "In_Scope": null, "Work_Activity_Date": null, "Project_Number": null, "Contractor": null, "Inspected_By": null, "Inspection_Date": null, "Main_Work_Activity": null, "Pipe_Size_Same": null, "New_Pipe_Size": null, "Material_Same": null, "New_Material": null, "Length_Same": null, "New_Length": null, "Additional_Work_Activity": null, "Main_Work_Activity1": null, "Discrepancies": null, "Discrepancy_Type": null, "Comments": null, "Work_Activity_Status": null, "In_Prog_Comment": null, "In_Service": null, "All_Work_Complete": null, "RelObjectID": null, "Guid": null, "Main_ID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 7, "name": "AssetTrackers_DevelopmentDB.ASSET_TRACKER.Meter_Work_Report", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Guid", "composite": false } ], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Contractor", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Contractor", "type": "esriFieldTypeString", "alias": "Contractor", "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" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "Contractor" }, { "name": "Project_Number", "type": "esriFieldTypeString", "alias": "Project_Number", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Project_Number" }, { "name": "Inspected_By", "type": "esriFieldTypeString", "alias": "Inspected_By", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Inspected_By" }, { "name": "Inspection_Date", "type": "esriFieldTypeDate", "alias": "Inspection_Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Inspection_Date" }, { "name": "Meter_Work_Activity", "type": "esriFieldTypeString", "alias": "Meter_Work_Activity", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Meter_Work_Activity" }, { "name": "MT_Size_Same", "type": "esriFieldTypeString", "alias": "MT_Size_Same", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "MT_Size_Same" }, { "name": "New_MT_Size", "type": "esriFieldTypeDouble", "alias": "New_MT_Size", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "New_MT_Size" }, { "name": "Additional_Work_Activity", "type": "esriFieldTypeString", "alias": "Additional_Work_Activity", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Additional_Work_Activity" }, { "name": "Meter_Work_Activity1", "type": "esriFieldTypeString", "alias": "Meter_Work_Activity1", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Meter_Work_Activity1" }, { "name": "Work_Activity_Date", "type": "esriFieldTypeDate", "alias": "Work_Activity_Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Work_Activity_Date" }, { "name": "Comment", "type": "esriFieldTypeString", "alias": "Comment", "domain": null, "editable": true, "nullable": true, "length": 70, "defaultValue": null, "modelName": "Comment" }, { "name": "Discrepancies", "type": "esriFieldTypeString", "alias": "Discrepancies", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Discrepancies" }, { "name": "Discrepancy_Type", "type": "esriFieldTypeString", "alias": "Discrepancy_Type", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Discrepancy_Type" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "Comments" }, { "name": "Work_Activity_Status", "type": "esriFieldTypeString", "alias": "Work_Activity_Status", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Work_Activity_Status" }, { "name": "In_Prog_Comment", "type": "esriFieldTypeString", "alias": "In_Prog_Comment", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "In_Prog_Comment" }, { "name": "In_Service", "type": "esriFieldTypeString", "alias": "In_Service", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "In_Service" }, { "name": "All_Work_Complete", "type": "esriFieldTypeString", "alias": "All_Work_Complete", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "All_Work_Complete" }, { "name": "RelObjectID", "type": "esriFieldTypeInteger", "alias": "RelObjectID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RelObjectID" }, { "name": "Meter_Install_Date", "type": "esriFieldTypeDate", "alias": "Meter_Install_Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Meter_Install_Date" }, { "name": "Guid", "type": "esriFieldTypeGUID", "alias": "Guid", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Guid" }, { "name": "Meter_No", "type": "esriFieldTypeString", "alias": "Meter_No", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Meter_No" }, { "name": "In_Scope", "type": "esriFieldTypeString", "alias": "In_Scope", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "In_Scope" } ], "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": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "AssetTrackers_DevelopmentDB.ASSET_TRACKER.Meter_Work_Report", "description": "", "prototype": { "attributes": { "Meter_No": null, "In_Scope": null, "Contractor": null, "Project_Number": null, "Inspected_By": null, "Inspection_Date": null, "Meter_Work_Activity": null, "MT_Size_Same": null, "New_MT_Size": null, "Additional_Work_Activity": null, "Meter_Work_Activity1": null, "Work_Activity_Date": null, "Comment": null, "Discrepancies": null, "Discrepancy_Type": null, "Comments": null, "Work_Activity_Status": null, "In_Prog_Comment": null, "In_Service": null, "All_Work_Complete": null, "RelObjectID": null, "Meter_Install_Date": null, "Guid": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 8, "name": "AssetTrackers_DevelopmentDB.ASSET_TRACKER.Service_Work_Report", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 3, "name": "", "relatedTableId": 3, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Guid", "composite": false } ], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Project_Number", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Project_Number", "type": "esriFieldTypeString", "alias": "Project_Number", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Project_Number" }, { "name": "Contractor", "type": "esriFieldTypeString", "alias": "Contractor", "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" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "Contractor" }, { "name": "Inspected_By", "type": "esriFieldTypeString", "alias": "Inspected_By", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Inspected_By" }, { "name": "Inspection_Date", "type": "esriFieldTypeDate", "alias": "Inspection_Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Inspection_Date" }, { "name": "Service_Work_Act", "type": "esriFieldTypeString", "alias": "Service_Work_Act", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Service_Work_Act" }, { "name": "Pipe_Size_Same", "type": "esriFieldTypeString", "alias": "Pipe_Size_Same", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Pipe_Size_Same" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "New_Pipe_Size" }, { "name": "Material_Same", "type": "esriFieldTypeString", "alias": "Material_Same", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Material_Same" }, { "name": "New_Material", "type": "esriFieldTypeString", "alias": "New_Material", "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" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "New_Material" }, { "name": "Length_Same", "type": "esriFieldTypeString", "alias": "Length_Same", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Length_Same" }, { "name": "New_Length", "type": "esriFieldTypeDouble", "alias": "New_Length", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "New_Length" }, { "name": "Additional_Work_Activity", "type": "esriFieldTypeString", "alias": "Additional_Work_Activity", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Additional_Work_Activity" }, { "name": "Service_Work_Act1", "type": "esriFieldTypeString", "alias": "Service_Work_Act1", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Service_Work_Act1" }, { "name": "Discrepancies", "type": "esriFieldTypeString", "alias": "Discrepancies", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Discrepancies" }, { "name": "Discrepancy_Type", "type": "esriFieldTypeString", "alias": "Discrepancy_Type", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Discrepancy_Type" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "Comments" }, { "name": "Work_Activity_Status", "type": "esriFieldTypeString", "alias": "Work_Activity_Status", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Work_Activity_Status" }, { "name": "In_Prog_Comment", "type": "esriFieldTypeString", "alias": "In_Prog_Comment", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "In_Prog_Comment" }, { "name": "In_Service", "type": "esriFieldTypeString", "alias": "In_Service", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "In_Service" }, { "name": "All_Work_Complete", "type": "esriFieldTypeString", "alias": "All_Work_Complete", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "All_Work_Complete" }, { "name": "RelObjectID", "type": "esriFieldTypeInteger", "alias": "RelGlobalID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RelObjectID" }, { "name": "Guid", "type": "esriFieldTypeGUID", "alias": "Guid", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Guid" }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FacilityID" }, { "name": "In_Scope", "type": "esriFieldTypeString", "alias": "In_Scope", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "In_Scope" }, { "name": "Work_Activity_Date", "type": "esriFieldTypeDate", "alias": "Work_Activity_Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Work_Activity_Date" } ], "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": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "AssetTrackers_DevelopmentDB.ASSET_TRACKER.Service_Work_Report", "description": "", "prototype": { "attributes": { "In_Scope": null, "Work_Activity_Date": null, "Project_Number": null, "Contractor": null, "Inspected_By": null, "Inspection_Date": null, "Service_Work_Act": null, "Pipe_Size_Same": null, "New_Pipe_Size": null, "Material_Same": null, "New_Material": null, "Length_Same": null, "New_Length": null, "Additional_Work_Activity": null, "Service_Work_Act1": null, "Discrepancies": null, "Discrepancy_Type": null, "Comments": null, "Work_Activity_Status": null, "In_Prog_Comment": null, "In_Service": null, "All_Work_Complete": null, "RelObjectID": null, "Guid": null, "FacilityID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }, { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 9, "name": "AssetTrackers_DevelopmentDB.ASSET_TRACKER.Valve_Work_Report", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 2, "name": "", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Guid", "composite": false } ], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Contractor", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Contractor", "type": "esriFieldTypeString", "alias": "Contractor", "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" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "Contractor" }, { "name": "Project_Number", "type": "esriFieldTypeString", "alias": "Project_Number", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Project_Number" }, { "name": "Inspected_By", "type": "esriFieldTypeString", "alias": "Inspected_By", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Inspected_By" }, { "name": "Inspection_Date", "type": "esriFieldTypeDate", "alias": "Inspection_Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Inspection_Date" }, { "name": "Valve_Work_Activity", "type": "esriFieldTypeString", "alias": "Valve_Work_Activity", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Valve_Work_Activity" }, { "name": "VLV_Size_Same", "type": "esriFieldTypeString", "alias": "VLV_Size_Same", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "VLV_Size_Same" }, { "name": "New_VLV_Size", "type": "esriFieldTypeDouble", "alias": "New_VLV_Size", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "New_VLV_Size" }, { "name": "Additional_Work_Activity", "type": "esriFieldTypeString", "alias": "Additional_Work_Activity", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Additional_Work_Activity" }, { "name": "Valve_Work_Activity1", "type": "esriFieldTypeString", "alias": "Valve_Work_Activity1", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Valve_Work_Activity1" }, { "name": "Work_Activity_Date", "type": "esriFieldTypeDate", "alias": "Work_Activity_Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Work_Activity_Date" }, { "name": "Comment", "type": "esriFieldTypeString", "alias": "Comment", "domain": null, "editable": true, "nullable": true, "length": 70, "defaultValue": null, "modelName": "Comment" }, { "name": "Discrepancies", "type": "esriFieldTypeString", "alias": "Discrepancies", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Discrepancies" }, { "name": "Discrepancy_Type", "type": "esriFieldTypeString", "alias": "Discrepancy_Type", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Discrepancy_Type" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "Comments" }, { "name": "Work_Activity_Status", "type": "esriFieldTypeString", "alias": "Work_Activity_Status", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Work_Activity_Status" }, { "name": "In_Prog_Comment", "type": "esriFieldTypeString", "alias": "In_Prog_Comment", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "In_Prog_Comment" }, { "name": "In_Service", "type": "esriFieldTypeString", "alias": "In_Service", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "In_Service" }, { "name": "All_Work_Complete", "type": "esriFieldTypeString", "alias": "All_Work_Complete", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "All_Work_Complete" }, { "name": "RelObjectID", "type": "esriFieldTypeInteger", "alias": "RelObjectID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RelObjectID" }, { "name": "Valve_Install_Date", "type": "esriFieldTypeDate", "alias": "Valve_Install_Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Valve_Install_Date" }, { "name": "Guid", "type": "esriFieldTypeGUID", "alias": "Guid", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Guid" }, { "name": "VLV_ID", "type": "esriFieldTypeString", "alias": "VLV_ID", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "VLV_ID" }, { "name": "In_Scope", "type": "esriFieldTypeString", "alias": "In_Scope", "domain": { "type": "codedValue", "name": "dYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "In_Scope" } ], "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": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "AssetTrackers_DevelopmentDB.ASSET_TRACKER.Valve_Work_Report", "description": "", "prototype": { "attributes": { "VLV_ID": null, "In_Scope": null, "Contractor": null, "Project_Number": null, "Inspected_By": null, "Inspection_Date": null, "Valve_Work_Activity": null, "VLV_Size_Same": null, "New_VLV_Size": null, "Additional_Work_Activity": null, "Valve_Work_Activity1": null, "Work_Activity_Date": null, "Comment": null, "Discrepancies": null, "Discrepancy_Type": null, "Comments": null, "Work_Activity_Status": null, "In_Prog_Comment": null, "In_Service": null, "All_Work_Complete": null, "RelObjectID": null, "Valve_Install_Date": null, "Guid": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 } ] }