{ "layers": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 905041, "name": "DPU Public Viewer ", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102685, "latestWkid": 2248, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -120561100, "falseY": -95444400, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "valueExpression": "var bothsidesstatus = $feature.bothsidesstatus\nvar utilstatus = $feature.utilstatus\nvar custstatus = $feature.custstatus\nvar utilsource = $feature.utilsource\nvar custsource = $feature.custsource\n\nif (utilstatus == 1 && utilsource == \"Installation record (e.g., tap card)\" || custstatus == 1 && custsource == \"Installation record (e.g., tap card)\") {\n\n return \"Lead\" \n}\nelse if (utilstatus == 1 && utilsource == \"Water sampling only with no records\" || custstatus == 1 && custsource == \"Water sampling only with no records\") {\n\n return \"Lead\" \n}\nelse if (utilstatus == 1 && utilsource == \"Field inspection only with no records\" || custstatus == 1 && custsource == \"Field inspection only with no records\") {\n\n return \"Lead\" \n}\nelse if (utilstatus == 1 && utilsource == \"Service line repair or replacement record\" || custstatus == 1 && custsource == \"Service line repair or replacement record\") {\n\n return \"Lead\" \n}\nelse if (utilstatus == 1 && utilsource == \"Statistical analysis\" || custstatus == 1 && custsource == \"Statistical analysis\") {\n\n return \"Assumed Lead\" \n}\nelse if (utilstatus == 1 && utilsource == \"Previous materials evaluation\" || custstatus == 1 && custsource == \"Previous materials evaluation\") {\n\n return \"Assumed Lead\" \n}\nelse if (utilstatus == 1 && utilsource == \"Installation date is after the lead ban\" || custstatus == 1 && custsource == \"Installation date is after the lead ban\") {\n\n return \"Assumed Lead\" \n}\nelse if (utilstatus == 1 && utilsource == \"Service line diameter is greater than 2 inches\" || custstatus == 1 && custsource == \"Service line diameter is greater than 2 inches\") {\n\n return \"Assumed Lead\" \n}\nelse if (utilstatus == 1 && utilsource == \"Other\" || custstatus == 1 && custsource == \"Other\") {\n\n return \"Assumed Lead\" \n}\nelse if (bothsidesstatus == \"Lead\" && utilsource == null && custsource == null) {\n\n return \"Assumed Lead\" \n}\nelse if (bothsidesstatus == \"Non-Lead\") {\n\n return \"Non-Lead\"\n}\nelse if (bothsidesstatus == \"Galvanized Requiring Replacement\") {\n\n return \"Galvanized Requiring Replacement\"\n}\nelse if (bothsidesstatus == \"Unknown\") {\n\n return \"Unknown\"\n}", "valueExpressionTitle": "Public Lead Category", "defaultSymbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 255, 255, 255, 255 ], "size": 12, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "defaultLabel": "Other", "uniqueValueGroups": [ { "heading": "", "classes": [ { "label": "Lead", "description": "Lead", "symbol": { "type": "esriPMS", "url": "45464c1fa6ed6d306c59af3381ec4a39", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABsAAAAbCAYAAACN1PRVAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABmElEQVRIic2WTW7CMBBG34I7IDhEJESv0B29QSR24QCV2HdbiQOUdU5AWPQQZONDUOUW1YSxbAdD86eon2QlipJ5nsn4s2dMqNl/hL0Ba2CjV6sfoACOQDkUlunwAb4W3jsC+1B4Z1ihmZAArzrmOkRGxwGobhM6AWetRGtYDZKg70D64KVERwrkwP72WCZ4AV7awGpQoiDJpo1SBW9dll/A7hks8zNqC7IS2DewcrGCxonBeoGsZKKfrqRSpWUMVre3/QdDlOo/NLduXdvsfFjd3n0zairRTtVq7ZqwzZiwVLPz1+hdZnYNjZEZT2CMCZvUiKvQP+9g8nBhwhL0lnG31xhM1kQ2Fqxyt9FFLas9O4ywznCdaOPewWQGpfhaPhCYuzLWMWMwdD867T1H7yrjrMrG4xGs0P1os1VTnXcEbcPyFX+1vnjkRcq5UlNtU9I8zOjc3F4ewdCNT/ajbK+BrEEnXrcZveZhqx9joGcw9IO6FOLeJuywmMohZxAbYKn+Zg8+a88ErvrOKKcrHxotTRdNekj9BUNlYI6714ceAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 20, "height": 20, "angle": 0, "xoffset": 0, "yoffset": 0 }, "values": [ [ "Lead" ] ] }, { "label": "Assumed Lead", "description": "Assumed Lead", "symbol": { "type": "esriPMS", "url": "4b9d053e362c18bd87237d726266f801", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABoAAAAaCAYAAACpSkzOAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAByklEQVRIic2WUWqDQBCG/4fcIcRDCCFnEPKQ3EDIW3qAQp/b10IPkL4FPEHMm2eQgocw5BZl3H90NbtuTCF0YMlG1/n2n5kdneFJNvtPoAjAimNjXSsB1AC+Of8TaBsBhxpY6IU5gKuZKnQP4ALgBUA+FSS7fxdnsuWUgARAzAUVR2Z+ZSMnAGfZ3L2gFiJOXwkYWsyRErgzSkVlzdAGQQ1EnH9SSchiAD+EFUbdgaH0graq5F6IbUcAS6NsPywSGxQx8U24pkJs2NpMczuENmgl1ZV6cgImvuA8YX6GpnnLTAi3Wok9EEaUMP6tFRxHD4zWHgsb1JyLJKDEtoL3Uj9Ic9Uvhnl/Uc+hz7JxEJzFwBM/yeLx285ikFLcVI6HkxFVseNa1fd5A6p10fDh1Er+EJI+AJKk7V0xB6sr47DbD8ZBuS90F2mQLlWqzOdcTRut+vO1IOlPpx1711S7Anjr/n5oOlwgkXqWLrzzHMYQpOrSkIe6t7SNWrrwkrBACUOK5KuDlFRz14tP6v8gXXjNvGgBDF98VZcTVdILWQik+WpCwAY5ZiUBk1/ltoOI4Vywd9kfJyWdS3XdqJgCUtOdNg3yEXvad90vk6J2t+znKhwAAAAASUVORK5CYII=", "contentType": "image/png", "width": 19, "height": 19, "angle": 0, "xoffset": 0, "yoffset": 0 }, "values": [ [ "Assumed Lead" ] ] }, { "label": "Galvanized Requiring Replacement", "description": "Galvanized Requiring Replacement", "symbol": { "type": "esriPMS", "url": "3be7b5140bb62edca17de8d1d0dc27af", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABwAAAAaCAYAAACkVDyJAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABaklEQVRIidWWQYqDMBSG/4V3kPYQBclcodCFMycQutMDFLpt1oEeYGbdG7j0CuOmhyh4i+GleWkq0VaNwvzQkkr06/vz/sQICyv6L8A1gBWAegmgAPBrxgWAn7mBsjWeFSgApJvN/cf1qm2VrT8RFPhNX1kGbLdAkuhrJ1Pl7Z0HDAHmVCFVR0AGXy4WWoQECrbtcHhcpLEB5qbKOhSQHrhiK1lxfIeez9bujxBAYYDWSlcErCrdQDTvE0A5FSgZxt3pg+73tspyCjDnGLhr1xbZTHNMTHg9RwM1jNarT0oBu52tchTQxsBtlC7xvKqy0GIIUHDI+6z0VZkk/TGJXjXKO9WxyHZnM/DGJOraL/nmoVLKAoX51K+A0u28MVIKOB71sDRnZyfQxoBuGqvM2OqLiQtcuzGYKvWIiewCpuQ558209yTFMdA0z2emC9TVNY3dpkIq9QG/OHszSPLABdKJTbv9rFr8vfQPMZte+WVTuEwAAAAASUVORK5CYII=", "contentType": "image/png", "width": 19, "height": 19, "angle": 0, "xoffset": 0, "yoffset": 0 }, "values": [ [ "Galvanized Requiring Replacement" ] ] }, { "label": "Non-Lead", "description": "Non-Lead", "symbol": { "type": "esriPMS", "url": "5cd627d7f588ddf2e6865d03b729a2da", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABoAAAAaCAYAAACpSkzOAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAjklEQVRIiWNhoBNgGQiLjBkYGNIYGBikqGh+OgMDwzN0i9KgmJpgJgMDgy+6RRCftO9gYBAUp8z49y8ZGCo9CMQRyBJKLRosiYGmgIW2xiPAqEVkAxbytZIGRi0iG7CQr5U0MGrRUAy69y8pN/X9SyIsQqsZqQVY0BoSoDqemiAdm0Wg1gq4IUELQLfEAAAruw+QgLfdUgAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 19, "height": 19, "angle": 0, "xoffset": 0, "yoffset": 0 }, "values": [ [ "Non-Lead" ] ] }, { "label": "Unknown", "description": "Unknown", "symbol": { "type": "esriPMS", "url": "6cd359373d9899914c9e112c191787fb", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABYAAAAkCAYAAACNBsqdAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABxElEQVRIid2WMW7CMABF/5CdrGThCBnSGS4AHIGRTGzsULGyMcHIEcIJYK6HHMFDmX2E6kd2ZdI4jgNVpX7JiCT24/vnEyXCLyn6t+AEwBHAEMDbK8FLAFP9favH0+AMwGY0GlUHUsoNgAsA8Sx4y4/5fI44jrHb7cy52TPgjBGkaQoOis6llFN9TfQFH41bo9VqhfV6DR1H0ge8pKvxeFy5NGIcPHe73YZ6zikEnHARgbZbo8ViQbDJOgg8pdvJZFI5bBLh5/N56KpfEzhjtnTLLbvEa9fr1Vm/qK1ePtG1q36Rr15t4q5c9Yt89fLJVb/IVy+fXPV7AMdxHOTWiGvq9bPBmXHQR1ynlLqbYxucK6WORVEEu+YapRTsP4sNPjGOoigyNqJrzlJKE4NwgakcwAcd8G53Eedqvdvn62DBUZZlRic+12VZVkM7vbSBKQb8eTgcsN/v0dHtjwdRE/jOiUqpJbNzPS94jbvSUNH16ZbrG9kIZgO0W1HP1gdurV+tXt/d7Qo+NdXPVa8QcGP9XPUKBQu7fty+q16h4If6DQaD6kRbBCHgu6mfdcPEK8Am65n+kdZs+7zGJgFz//79OFhfVt3YxHZ4wRQAAAAASUVORK5CYII=", "contentType": "image/png", "width": 27, "height": 27, "angle": 0, "xoffset": 0, "yoffset": 0 }, "values": [ [ "Unknown" ] ] } ] } ], "uniqueValueInfos": [ { "symbol": { "type": "esriPMS", "url": "45464c1fa6ed6d306c59af3381ec4a39", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABsAAAAbCAYAAACN1PRVAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABmElEQVRIic2WTW7CMBBG34I7IDhEJESv0B29QSR24QCV2HdbiQOUdU5AWPQQZONDUOUW1YSxbAdD86eon2QlipJ5nsn4s2dMqNl/hL0Ba2CjV6sfoACOQDkUlunwAb4W3jsC+1B4Z1ihmZAArzrmOkRGxwGobhM6AWetRGtYDZKg70D64KVERwrkwP72WCZ4AV7awGpQoiDJpo1SBW9dll/A7hks8zNqC7IS2DewcrGCxonBeoGsZKKfrqRSpWUMVre3/QdDlOo/NLduXdvsfFjd3n0zairRTtVq7ZqwzZiwVLPz1+hdZnYNjZEZT2CMCZvUiKvQP+9g8nBhwhL0lnG31xhM1kQ2Fqxyt9FFLas9O4ywznCdaOPewWQGpfhaPhCYuzLWMWMwdD867T1H7yrjrMrG4xGs0P1os1VTnXcEbcPyFX+1vnjkRcq5UlNtU9I8zOjc3F4ewdCNT/ajbK+BrEEnXrcZveZhqx9joGcw9IO6FOLeJuywmMohZxAbYKn+Zg8+a88ErvrOKKcrHxotTRdNekj9BUNlYI6714ceAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 20, "height": 20, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "Lead", "label": "Lead" }, { "symbol": { "type": "esriPMS", "url": "4b9d053e362c18bd87237d726266f801", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABoAAAAaCAYAAACpSkzOAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAByklEQVRIic2WUWqDQBCG/4fcIcRDCCFnEPKQ3EDIW3qAQp/b10IPkL4FPEHMm2eQgocw5BZl3H90NbtuTCF0YMlG1/n2n5kdneFJNvtPoAjAimNjXSsB1AC+Of8TaBsBhxpY6IU5gKuZKnQP4ALgBUA+FSS7fxdnsuWUgARAzAUVR2Z+ZSMnAGfZ3L2gFiJOXwkYWsyRErgzSkVlzdAGQQ1EnH9SSchiAD+EFUbdgaH0graq5F6IbUcAS6NsPywSGxQx8U24pkJs2NpMczuENmgl1ZV6cgImvuA8YX6GpnnLTAi3Wok9EEaUMP6tFRxHD4zWHgsb1JyLJKDEtoL3Uj9Ic9Uvhnl/Uc+hz7JxEJzFwBM/yeLx285ikFLcVI6HkxFVseNa1fd5A6p10fDh1Er+EJI+AJKk7V0xB6sr47DbD8ZBuS90F2mQLlWqzOdcTRut+vO1IOlPpx1711S7Anjr/n5oOlwgkXqWLrzzHMYQpOrSkIe6t7SNWrrwkrBACUOK5KuDlFRz14tP6v8gXXjNvGgBDF98VZcTVdILWQik+WpCwAY5ZiUBk1/ltoOI4Vywd9kfJyWdS3XdqJgCUtOdNg3yEXvad90vk6J2t+znKhwAAAAASUVORK5CYII=", "contentType": "image/png", "width": 19, "height": 19, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "Assumed Lead", "label": "Assumed Lead" }, { "symbol": { "type": "esriPMS", "url": "3be7b5140bb62edca17de8d1d0dc27af", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABwAAAAaCAYAAACkVDyJAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABaklEQVRIidWWQYqDMBSG/4V3kPYQBclcodCFMycQutMDFLpt1oEeYGbdG7j0CuOmhyh4i+GleWkq0VaNwvzQkkr06/vz/sQICyv6L8A1gBWAegmgAPBrxgWAn7mBsjWeFSgApJvN/cf1qm2VrT8RFPhNX1kGbLdAkuhrJ1Pl7Z0HDAHmVCFVR0AGXy4WWoQECrbtcHhcpLEB5qbKOhSQHrhiK1lxfIeez9bujxBAYYDWSlcErCrdQDTvE0A5FSgZxt3pg+73tspyCjDnGLhr1xbZTHNMTHg9RwM1jNarT0oBu52tchTQxsBtlC7xvKqy0GIIUHDI+6z0VZkk/TGJXjXKO9WxyHZnM/DGJOraL/nmoVLKAoX51K+A0u28MVIKOB71sDRnZyfQxoBuGqvM2OqLiQtcuzGYKvWIiewCpuQ558209yTFMdA0z2emC9TVNY3dpkIq9QG/OHszSPLABdKJTbv9rFr8vfQPMZte+WVTuEwAAAAASUVORK5CYII=", "contentType": "image/png", "width": 19, "height": 19, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "Galvanized Requiring Replacement", "label": "Galvanized Requiring Replacement" }, { "symbol": { "type": "esriPMS", "url": "5cd627d7f588ddf2e6865d03b729a2da", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABoAAAAaCAYAAACpSkzOAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAjklEQVRIiWNhoBNgGQiLjBkYGNIYGBikqGh+OgMDwzN0i9KgmJpgJgMDgy+6RRCftO9gYBAUp8z49y8ZGCo9CMQRyBJKLRosiYGmgIW2xiPAqEVkAxbytZIGRi0iG7CQr5U0MGrRUAy69y8pN/X9SyIsQqsZqQVY0BoSoDqemiAdm0Wg1gq4IUELQLfEAAAruw+QgLfdUgAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 19, "height": 19, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "Non-Lead", "label": "Non-Lead" }, { "symbol": { "type": "esriPMS", "url": "6cd359373d9899914c9e112c191787fb", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABYAAAAkCAYAAACNBsqdAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABxElEQVRIid2WMW7CMABF/5CdrGThCBnSGS4AHIGRTGzsULGyMcHIEcIJYK6HHMFDmX2E6kd2ZdI4jgNVpX7JiCT24/vnEyXCLyn6t+AEwBHAEMDbK8FLAFP9favH0+AMwGY0GlUHUsoNgAsA8Sx4y4/5fI44jrHb7cy52TPgjBGkaQoOis6llFN9TfQFH41bo9VqhfV6DR1H0ge8pKvxeFy5NGIcPHe73YZ6zikEnHARgbZbo8ViQbDJOgg8pdvJZFI5bBLh5/N56KpfEzhjtnTLLbvEa9fr1Vm/qK1ePtG1q36Rr15t4q5c9Yt89fLJVb/IVy+fXPV7AMdxHOTWiGvq9bPBmXHQR1ynlLqbYxucK6WORVEEu+YapRTsP4sNPjGOoigyNqJrzlJKE4NwgakcwAcd8G53Eedqvdvn62DBUZZlRic+12VZVkM7vbSBKQb8eTgcsN/v0dHtjwdRE/jOiUqpJbNzPS94jbvSUNH16ZbrG9kIZgO0W1HP1gdurV+tXt/d7Qo+NdXPVa8QcGP9XPUKBQu7fty+q16h4If6DQaD6kRbBCHgu6mfdcPEK8Am65n+kdZs+7zGJgFz//79OFhfVt3YxHZ4wRQAAAAASUVORK5CYII=", "contentType": "image/png", "width": 27, "height": 27, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "Unknown", "label": "Unknown" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 184, 233, 252, 255 ], "toColor": [ 184, 233, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 251, 179, 255 ], "toColor": [ 252, 251, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 179, 250, 255 ], "toColor": [ 252, 179, 250, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 200, 192, 255 ], "toColor": [ 252, 200, 192, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 179, 252, 205, 255 ], "toColor": [ 179, 252, 205, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 179, 188, 252, 255 ], "toColor": [ 179, 188, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 241, 212, 255 ], "toColor": [ 252, 241, 212, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 235, 215, 252, 255 ], "toColor": [ 235, 215, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 187, 215, 255 ], "toColor": [ 252, 187, 215, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 215, 252, 235, 255 ], "toColor": [ 215, 252, 235, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 224, 252, 197, 255 ], "toColor": [ 224, 252, 197, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 195, 252, 179, 255 ], "toColor": [ 195, 252, 179, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 182, 209, 252, 255 ], "toColor": [ 182, 209, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 210, 225, 255 ], "toColor": [ 252, 210, 225, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 199, 252, 255 ], "toColor": [ 252, 199, 252, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 252, 215, 182, 255 ], "toColor": [ 252, 215, 182, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 612192.3510933071, "ymin": 590023.4373306483, "xmax": 728371.0718193948, "ymax": 747389.9989092201, "spatialReference": { "wkid": 102685, "latestWkid": 2248, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -120561100, "falseY": -95444400, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalid", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "editable": false, "nullable": false, "length": 4, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "editable": false, "nullable": false, "length": 38, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "editable": true, "nullable": false, "length": 250, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "editable": true, "nullable": false, "length": 150, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "editable": true, "nullable": false, "length": 4, "domain": null } ], "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "county", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "00 OBJECTID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "01 GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "02 created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "03 created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "04 last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "05 last_edited_date", "length": 8, "domain": null }, { "name": "county", "type": "esriFieldTypeString", "alias": "06 County", "length": 255, "domain": null }, { "name": "system", "type": "esriFieldTypeString", "alias": "07 System", "length": 50, "domain": { "type": "codedValue", "name": "Water Systems", "description": "Water Systems for Garrett County", "codedValues": [ { "name": "Unknown", "code": "0" }, { "name": "Hutton", "code": "7" }, { "name": "Mountain Lake Park", "code": "8" }, { "name": "Loch Lynn Heights", "code": "10" }, { "name": "Bloomington", "code": "11" }, { "name": "Kitzmiller", "code": "12" }, { "name": "Keyser Ridge", "code": "13" }, { "name": "Chestnut Ridge", "code": "14" }, { "name": "Grantsville", "code": "15" }, { "name": "Jennings", "code": "16" }, { "name": "McHenry", "code": "17" }, { "name": "Deep Creek", "code": "Deep Creek" }, { "name": "Accident", "code": "Accident" }, { "name": "Friendsville", "code": "Friendsville" }, { "name": "Gorman", "code": "Gorman" }, { "name": "Crellin", "code": "Crellin" }, { "name": "Oakland", "code": "Oakland" }, { "name": "Deer Park", "code": "Deer Park" }, { "name": "Carmel Cove", "code": "Carmel Cove" }, { "name": "Thayerville", "code": "Thayerville" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "pwsid", "type": "esriFieldTypeString", "alias": "08 PWSID", "length": 255, "domain": { "type": "codedValue", "name": "cvd_pwsid", "description": "", "codedValues": [ { "name": "MD1111144", "code": "Carmel Cove" }, { "name": "MD1110025", "code": "Cherry Hill Asssisted Living" }, { "name": "MD1111020", "code": "Deep Creek Lake (Day Use)" }, { "name": "MD1111109", "code": "Deep Creek Lake (Shop Well)" }, { "name": "MD1110023", "code": "Glotfelty Enterprises Inc." }, { "name": "MD1111033", "code": "Herrington Manor State Park" }, { "name": "MD110230", "code": "Meadow Mountain Boys Camp" }, { "name": "MD110231", "code": "Meadow Park" }, { "name": "MD1111008", "code": "New Germany Cabin Area" }, { "name": "MD1110021", "code": "Rigidply Rafters" }, { "name": "MD1110009", "code": "Rt 40 School" }, { "name": "MD1111066", "code": "Swallow Falls State Park" }, { "name": "MD1110011", "code": "Swan Meadow School" }, { "name": "MD110225", "code": "White Oak Mobile Home" }, { "name": "MD1111158", "code": "Yellow Stone" }, { "name": "MD0110001", "code": "Accident" }, { "name": "MD0110204", "code": "Backbone Mountan Boys Camp" }, { "name": "MD0110002", "code": "Bloomington" }, { "name": "MD0110003", "code": "Crellin" }, { "name": "MD0110021", "code": "Deer Park" }, { "name": "MD0110004", "code": "Friendsville" }, { "name": "MD0110012", "code": "Gorman" }, { "name": "MD0110005", "code": "Grantsville" }, { "name": "MD0110013", "code": "Kitzmiller" }, { "name": "MD0110007", "code": "Mountain Lake Park" }, { "name": "MD0110008", "code": "Town of Oakland" }, { "name": "MD0110024", "code": "Thayerville" }, { "name": "MD1111096", "code": "McHenry" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_pws_type", "type": "esriFieldTypeString", "alias": "09 mde_pws_type", "length": 255, "domain": { "type": "codedValue", "name": "Lead_MDE Water System Type", "description": "", "codedValues": [ { "name": "Community (C)", "code": "Community (C)" }, { "name": "Transient (T)", "code": "Transient (T)" }, { "name": "Non-Transient Non-Community (NTNC)", "code": "Non-Transient Non-Community (NTNC) " } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "utacm_account", "type": "esriFieldTypeInteger", "alias": "10 County Utility Account", "domain": null }, { "name": "service_account", "type": "esriFieldTypeString", "alias": "11 Account Number", "length": 255, "domain": null }, { "name": "service_address", "type": "esriFieldTypeString", "alias": "12 Address", "length": 255, "domain": null }, { "name": "location_id", "type": "esriFieldTypeString", "alias": "13 Other Location Identifier", "length": 255, "domain": null }, { "name": "latitude", "type": "esriFieldTypeDouble", "alias": "14 Latitude", "domain": null }, { "name": "longitude", "type": "esriFieldTypeDouble", "alias": "15 Longitude", "domain": null }, { "name": "mde_building_type", "type": "esriFieldTypeString", "alias": "16 Connection Type", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_building_type", "description": "", "codedValues": [ { "name": "Residential (Single-Family)", "code": "Residential (Single-Family)" }, { "name": "Residential (Multi-Family)", "code": "Residential (Multi-Family)" }, { "name": "Residential (School Dormitory)", "code": "Residential (School Dormitory)" }, { "name": "Residential Mobile Structure (Mobile Homes, Trailers, RVs, Boats)", "code": "Residential Mobile Structure (Mobile Homes, Trailers, RVs, Boats)" }, { "name": "Non-Residential Mobile Structure (Trailers, RVs, Boats)", "code": "Non-Residential Mobile Structure (Trailers, RVs, Boats)" }, { "name": "Non-Residential (School Building, Modular/Mods, Portables/Pods)", "code": "Non-Residential (School Building, Modular/Mods, Portables/Pods)" }, { "name": "Non-Residential (Child Care Center)", "code": "Non-Residential (Child Care Center)" }, { "name": "Residential Building & In-Home Child Care Combination", "code": "Residential Building & In-Home Child Care Combination" }, { "name": "Commercial", "code": "Commercial" }, { "name": "Commercial (Single-Family Structure - formerly a residence)", "code": "Commercial (Single-Family Structure - formerly a residence)" }, { "name": "Industrial/Factory", "code": "Industrial/Factory" }, { "name": "Park/Zoo Building", "code": "Park/Zoo Building" }, { "name": "Power Production", "code": "Power Production" }, { "name": "Mixed Residential & Nonresidential", "code": "Mixed Residential & Nonresidential" }, { "name": "Empty/Unoccupied Building", "code": "Empty/Unoccupied Building" }, { "name": "School (Pre-K - 12)", "code": "School (Pre-K - 12)" }, { "name": "College/University", "code": "College/University" }, { "name": "Technical School", "code": "Technical School" }, { "name": "Other Type of School", "code": "Other Type of School" }, { "name": "Other (Please provide details in Comments)", "code": "Other (Please provide details in Comments)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "identifier_type", "type": "esriFieldTypeString", "alias": "17 Identifier", "length": 255, "domain": { "type": "codedValue", "name": "cvd_identifier_type", "description": "", "codedValues": [ { "name": "Street Address", "code": "Street Address" }, { "name": "Lot/Block", "code": "Lot/Block" }, { "name": "Intersection", "code": "Intersection" }, { "name": "Landmark", "code": "Landmark" }, { "name": "911 Address", "code": "911 Address" }, { "name": "Property Account Identifier", "code": "Property Account Identifier" }, { "name": "Map Parcel", "code": "Map Parcel" }, { "name": "Other (Please provide details in Comments)", "code": "Other (Please provide details in Comments)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "zipcode", "type": "esriFieldTypeInteger", "alias": "18 ZIP Code", "domain": null }, { "name": "mde_entire_sl_senario", "type": "esriFieldTypeString", "alias": "19 Entire Service Line Senario", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_entire_sl_senario", "description": "", "codedValues": [ { "name": "Scenario A: 1 portion - Entire line from water main to structure owned by the same entity and this single service line does NOT branch/feed into multiple downstream service lines (NOTE: Pg 4 not needed)", "code": "Scenario A: 1 portion - Entire line from water main to structure owned by the same entity and this single service line does NOT branch/feed into multiple downstream service lines (NOTE: Pg 4 not needed)" }, { "name": "Scenario B: 2 portions - Entire line from water main to structure owned by the same entity; however, the 1st portion of this service line branches/feeds into multiple 2nd portions (i.e., downstream service lines)", "code": "Scenario B: 2 portions - Entire line from water main to structure owned by the same entity; however, the 1st portion of this service line branches/feeds into multiple 2nd portions (i.e., downstream service lines)" }, { "name": "Scenario C: 2 portions - Entire line from water main to structure owned by different entities and the 1st portion of this service line does NOT branch/feed into multiple 2nd portions (i.e., downstream service lines)", "code": "Scenario C: 2 portions - Entire line from water main to structure owned by different entities and the 1st portion of this service line does NOT branch/feed into multiple 2nd portions (i.e., downstream service lines)" }, { "name": "Scenario D: 2 portions - Entire line from water main to structure owned by different entities; however, the 1st portion of this service line branches/feeds into multiple 2nd portions (i.e., downstream service lines)", "code": "Scenario D: 2 portions - Entire line from water main to structure owned by different entities; however, the 1st portion of this service line branches/feeds into multiple 2nd portions (i.e., downstream service lines)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ownership_1", "type": "esriFieldTypeString", "alias": "20 Ownership 1st Portion - Utility", "length": 255, "domain": { "type": "codedValue", "name": "cvd_ownership_1", "description": "", "codedValues": [ { "name": "System", "code": "System" }, { "name": "Customer", "code": "Customer" }, { "name": "Shared by both System and Customer", "code": "Shared by both System and Customer" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ownership_2", "type": "esriFieldTypeString", "alias": "21 Ownership 2nd Portion - Customer", "length": 255, "domain": { "type": "codedValue", "name": "cvd_ownership_1", "description": "", "codedValues": [ { "name": "System", "code": "System" }, { "name": "Customer", "code": "Customer" }, { "name": "Shared by both System and Customer", "code": "Shared by both System and Customer" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "active_1", "type": "esriFieldTypeString", "alias": "22 Activity Status Utility 1", "length": 255, "domain": { "type": "codedValue", "name": "cvd_active_1", "description": "", "codedValues": [ { "name": "Currently Active", "code": "Currently Active" }, { "name": "Currently Inactive", "code": "Currently Inactive" }, { "name": "Don't Know", "code": "Don't Know" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "active_2", "type": "esriFieldTypeString", "alias": "23 Activity Status Customer 2", "length": 255, "domain": { "type": "codedValue", "name": "cvd_active_1", "description": "", "codedValues": [ { "name": "Currently Active", "code": "Currently Active" }, { "name": "Currently Inactive", "code": "Currently Inactive" }, { "name": "Don't Know", "code": "Don't Know" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "sl_comments", "type": "esriFieldTypeString", "alias": "24 Overall service line comments", "length": 500, "domain": null }, { "name": "pointofentry", "type": "esriFieldTypeString", "alias": "25 Point-of-Entry Treatment", "length": 255, "domain": { "type": "codedValue", "name": "mde_Yes_No_DontKnow", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Don't Know", "code": "Don't Know" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_pointofusefaucet", "type": "esriFieldTypeString", "alias": "26 Treatment at Point of Use?", "length": 255, "domain": { "type": "codedValue", "name": "mde_Yes_No_DontKnow", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Don't Know", "code": "Don't Know" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_interior_lead_pipes", "type": "esriFieldTypeString", "alias": "27 Lead pipes in Building?", "length": 255, "domain": { "type": "codedValue", "name": "mde_Yes_No_DontKnow", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Don't Know", "code": "Don't Know" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "copperwithlead", "type": "esriFieldTypeString", "alias": "28 Copper Pipes with Lead Solder Before Lead Ban", "length": 255, "domain": { "type": "codedValue", "name": "mde_Yes_No_DontKnow", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Don't Know", "code": "Don't Know" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "year_built", "type": "esriFieldTypeString", "alias": "29 Year Building Constructed", "length": 255, "domain": null }, { "name": "year_source", "type": "esriFieldTypeString", "alias": "30 Building Construction Info Source", "length": 255, "domain": null }, { "name": "year_original_plumming", "type": "esriFieldTypeString", "alias": "31 Year of ORIGINAL plumbing material installed in building", "length": 255, "domain": { "type": "codedValue", "name": "mde_installation_date", "description": "", "codedValues": [ { "name": "Don't Know or Unknown", "code": "Don't Know or Unknown" }, { "name": "2024 and After", "code": "2024 and After" }, { "name": "1973 through 2023", "code": "1973 through 2023" }, { "name": "1972 (on or after May 17, i.e., 05/17/1972 - 12/31/1972)", "code": "1972 (on or after May 17, i.e., 05/17/1972 - 12/31/1972)" }, { "name": "1972 (before May 17, i.e., 01/01/1972 - 05/16/1972)", "code": "1972 (before May 17, i.e., 01/01/1972 - 05/16/1972)" }, { "name": "1972 (date and/or month unknown)", "code": "1972 (date and/or month unknown)" }, { "name": "1971 or Earlier", "code": "1971 or Earlier" }, { "name": "2023", "code": "2023" }, { "name": "2022", "code": "2022" }, { "name": "2021", "code": "2021" }, { "name": "2020", "code": "2020" }, { "name": "2019", "code": "2019" }, { "name": "2018", "code": "2018" }, { "name": "2017", "code": "2017" }, { "name": "2016", "code": "2016" }, { "name": "2015", "code": "2015" }, { "name": "2014", "code": "2014" }, { "name": "2013", "code": "2013" }, { "name": "2012", "code": "2012" }, { "name": "2011", "code": "2011" }, { "name": "2010", "code": "2010" }, { "name": "2009", "code": "2009" }, { "name": "2007", "code": "2008" }, { "name": "2006", "code": "2006" }, { "name": "2005", "code": "2005" }, { "name": "2004", "code": "2004" }, { "name": "2003", "code": "2003" }, { "name": "2002", "code": "2002" }, { "name": "2001", "code": "2001" }, { "name": "2000", "code": "2000" }, { "name": "1999", "code": "1999" }, { "name": "1998", "code": "1998" }, { "name": "1997", "code": "1997" }, { "name": "1996", "code": "1996" }, { "name": "1995", "code": "1995" }, { "name": "1994", "code": "1994" }, { "name": "1993", "code": "1993" }, { "name": "1992", "code": "1992" }, { "name": "1991", "code": "1991" }, { "name": "1990", "code": "1990" }, { "name": "1989", "code": "1989" }, { "name": "1988", "code": "1988" }, { "name": "1987", "code": "1987" }, { "name": "1986", "code": "1986" }, { "name": "1985", "code": "1985" }, { "name": "2024", "code": "2024" }, { "name": "2025", "code": "2025" }, { "name": "2026", "code": "2026" }, { "name": "2027", "code": "2027" }, { "name": "2028", "code": "2028" }, { "name": "2029", "code": "2029" }, { "name": "2030", "code": "2030" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "samplingsite", "type": "esriFieldTypeString", "alias": "32 LCR", "length": 255, "domain": { "type": "codedValue", "name": "mde_Yes_No_DontKnow", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Don't Know", "code": "Don't Know" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_lcr_tier_ntncws", "type": "esriFieldTypeString", "alias": "33 LCR NTCWS Tier", "length": 255, "domain": { "type": "codedValue", "name": "Lead LCR Non Community Tier", "description": "Lead MDE Material Prediction", "codedValues": [ { "name": "Tier 1 = Building that (1) is served by a Lead Service Line and/or (2) Contains Lead Pipes and/or (3) Contains Copper Pipes with Lead Solder Installed After 1982", "code": "Tier 1 = Building that (1) is served by a Lead Service Line and/or (2) Contains Lead Pipes and/or (3) Contains Copper Pipes with Lead Solder Installed After 1982" }, { "name": "Tier 2 = Building that Contains Copper Pipes with Lead Solder Installed Before 1983", "code": "Tier 2 = Building that Contains Copper Pipes with Lead Solder Installed Before 1983" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_lcr_tier_community", "type": "esriFieldTypeString", "alias": "34 LCR Community Tier", "length": 255, "domain": { "type": "codedValue", "name": "mde_lcr_tier_community", "description": "", "codedValues": [ { "name": "Tier 1 = Single Family Structure that (1) is Served by a Lead Service Line and/or (2) Contains Lead Pipes and/or (3) Contains Copper Pipes with Lead Solder Installed After 1982", "code": "Tier 1 = Single Family Structure that (1) is Served by a Lead Service Line and/or (2) Contains Lead Pipes and/or (3) Contains Copper Pipes with Lead Solder Installed After 1982" }, { "name": "Tier 2 = Multiple-Family Residence that (1) is Served by a Lead Service Line and/or (2) Contains Lead Pipes and/or (3) Contains Copper Pipes with Lead Solder Installed After 1982", "code": "Tier 2 = Multiple-Family Residence that (1) is Served by a Lead Service Line and/or (2) Contains Lead Pipes and/or (3) Contains Copper Pipes with Lead Solder Installed After 1982" }, { "name": "Tier 3 = Single-Family Structure that Contains Copper Pipes with Lead Solder Installed Before 1983", "code": "Tier 3 = Single-Family Structure that Contains Copper Pipes with Lead Solder Installed Before 1983" }, { "name": "Exceptional Site (Other Than Classifications Listed)", "code": "Exceptional Site (Other Than Classifications Listed)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "building_comments", "type": "esriFieldTypeString", "alias": "35 Building related comments", "length": 255, "domain": null }, { "name": "sl_material", "type": "esriFieldTypeString", "alias": "36 Material of water main", "length": 255, "domain": { "type": "codedValue", "name": "mde_service_line_material", "description": "", "codedValues": [ { "name": "DIP - Ductile Iron Pipe", "code": "DIP - Ductile Iron Pipe" }, { "name": "CIP - Cast Iron Pipe", "code": "CIP - Cast Iron Pipe" }, { "name": "Iron Pipe (specific type unknown)", "code": "Iron Pipe (specific type unknown)" }, { "name": "CIP-LJ - Cast Iron Pipe with Leaded Joints/Packing", "code": "CIP-LJ - Cast Iron Pipe with Leaded Joints/Packing" }, { "name": "Steel", "code": "Steel " }, { "name": "Copper", "code": "Copper" }, { "name": "Ceramic/Vitrified Clay", "code": "Ceramic/Vitrified Clay" }, { "name": "Reinforced Concrete", "code": "Reinforced Concrete" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Asbestos-Cement", "code": "Asbestos-Cement" }, { "name": "Fiberglass", "code": "Fiberglass" }, { "name": "PVC - Polyvinyl Chloride", "code": "PVC - Polyvinyl Chloride " }, { "name": "PB - Polybutylene", "code": "PB - Polybutylene" }, { "name": "HDPE - High Density Polyethylene", "code": "HDPE - High Density Polyethylene" }, { "name": "PEX - Cross-linked Polyethylene", "code": "PEX - Cross-linked Polyethylene" }, { "name": "Other (Please provide details in Comments)", "code": "Other (Please provide details in Comments)" }, { "name": "Don't Know", "code": "Don't Know" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "sl_valve_pb", "type": "esriFieldTypeString", "alias": "40 Does the valve connecting the water main to the service line contain more than 8% lead ?", "length": 255, "domain": { "type": "codedValue", "name": "cvd_sl_valve_pb", "description": "", "codedValues": [ { "name": "Yes - Valve currently contains more than 8% Lead", "code": "Yes - Valve currently contains more than 8% Lead" }, { "name": "No", "code": "No" }, { "name": "Don't Know", "code": "Don't Know" }, { "name": "Not Applicable - No Valve Present", "code": "Not Applicable - No Valve Present" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "utilassetid", "type": "esriFieldTypeString", "alias": "41 Utility Asset ID", "length": 255, "domain": null }, { "name": "utilsource", "type": "esriFieldTypeString", "alias": "42 Utility Source", "length": 255, "domain": { "type": "codedValue", "name": "Lead_Source", "description": "", "codedValues": [ { "name": "Installation record (e.g., tap card)", "code": "Installation record (e.g., tap card)" }, { "name": "Water sampling only with no records", "code": "Water sampling only with no records" }, { "name": "Field inspection only with no records", "code": "Field inspection only with no records" }, { "name": "Statistical analysis", "code": "Statistical analysis" }, { "name": "Previous materials evaluation", "code": "Previous materials evaluation" }, { "name": "Installation date is after the lead ban", "code": "Installation date is after the lead ban" }, { "name": "Service line diameter is greater than 2 inches", "code": "Service line diameter is greater than 2 inches" }, { "name": "Service line repair or replacement record", "code": "Service line repair or replacement record" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "utilmaterial", "type": "esriFieldTypeString", "alias": "43 Utility Material", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_pipe_material1", "description": "", "codedValues": [ { "name": "Don't Know or Unknown", "code": "Don't Know or Unknown" }, { "name": "Likely Lead (prediction with no threshold set - considered as unknown)Lead", "code": "Likely Lead (prediction with no threshold set - considered as unknown)" }, { "name": "Likely Non-Lead (prediction with no threshold set - considered as unknown)", "code": "Likely Non-Lead (prediction with no threshold set - considered as unknown)" }, { "name": "Lead", "code": "Lead" }, { "name": "Lead-lined Galvanized (Iron or Steel)", "code": "Lead-lined Galvanized (Iron or Steel)" }, { "name": "Galvanized (Iron or Steel)", "code": "Galvanized (Iron or Steel)" }, { "name": "Non-Lead (but specific type not known)", "code": "Non-Lead (but specific type not known)" }, { "name": "Non-Lead Non-Galvanized (but specific type not known)", "code": "Non-Lead Non-Galvanized (but specific type not known)" }, { "name": "Copper with Lead Solder", "code": "Copper with Lead Solder" }, { "name": "Copper (No Lead Solder)", "code": "Copper (No Lead Solder)" }, { "name": "Plastic (PVC - Polyvinyl Chloride, HDPE - High Density Polyethylene, PEX - Cross-linked Polyethylene)", "code": "Plastic (PVC - Polyvinyl Chloride, HDPE - High Density Polyethylene, PEX - Cross-linked Polyethylene)" }, { "name": "Non-Galvanized Ferrous Piping Materials (e.g., Cast Iron, Steel, etc.)", "code": "Non-Galvanized Ferrous Piping Materials (e.g., Cast Iron, Steel, etc.)" }, { "name": "Asbestos-Cement", "code": "Asbestos-Cement" }, { "name": "Brass", "code": "Brass" }, { "name": "Vinyl lined asbestos cement pipe", "code": "Vinyl lined asbestos cement pipe" }, { "name": "Coal tar lined pipes", "code": "Coal tar lined pipes" }, { "name": "Multiple (including Lead) Pipe Materials (Please provide details in Comments)", "code": "Multiple (including Lead) Pipe Materials (Please provide details in Comments)" }, { "name": "Multiple Non-Lead Pipe Materials (Please provide details in Comments)", "code": "Multiple Non-Lead Pipe Materials (Please provide details in Comments)" }, { "name": "Other Non-Lead (Specific type known -- Please provide details in Comments)", "code": "Other Non-Lead (Specific type known -- Please provide details in Comments)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "utildiameter", "type": "esriFieldTypeString", "alias": "44 Utility Diameter", "length": 255, "domain": { "type": "codedValue", "name": "cvd_epa_diameter", "description": "", "codedValues": [ { "name": "1/2\"", "code": "0.5" }, { "name": "3/4\"", "code": "0.75" }, { "name": "1\"", "code": "1" }, { "name": "1 1/4\"", "code": "1.25" }, { "name": "1 1/2\"", "code": "1.5" }, { "name": "2\"", "code": "2" }, { "name": "2 1/4\"", "code": "2.25" }, { "name": "2 1/2\"", "code": "2.5" }, { "name": "3\"", "code": "3" }, { "name": "4\"", "code": "4" }, { "name": "4 1/2\"", "code": "4.5" }, { "name": "5 1/4\"", "code": "5.25" }, { "name": "6\"", "code": "6" }, { "name": "8\"", "code": "8" }, { "name": "10\"", "code": "10" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "utilinstalldate", "type": "esriFieldTypeString", "alias": "45 Utility Install Date", "length": 255, "domain": null }, { "name": "mde_line_replaced1", "type": "esriFieldTypeString", "alias": "46 Is the CURRENT service line pipe (1st Portion) a replacement of the previous service line reported in the water system's most recent submittal of the inventory spreadsheet?", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_line_replaced1", "description": "", "codedValues": [ { "name": "Yes - This CURRENT service line is the replacement of the previous service line", "code": "Yes - This CURRENT service line is the replacement of the previous service line" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_pipe_material1", "type": "esriFieldTypeString", "alias": "47 MATERIAL of CURRENT service line pipe -- Utility 1st portion of service line", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_pipe_material1", "description": "", "codedValues": [ { "name": "Don't Know or Unknown", "code": "Don't Know or Unknown" }, { "name": "Likely Lead (prediction with no threshold set - considered as unknown)Lead", "code": "Likely Lead (prediction with no threshold set - considered as unknown)" }, { "name": "Likely Non-Lead (prediction with no threshold set - considered as unknown)", "code": "Likely Non-Lead (prediction with no threshold set - considered as unknown)" }, { "name": "Lead", "code": "Lead" }, { "name": "Lead-lined Galvanized (Iron or Steel)", "code": "Lead-lined Galvanized (Iron or Steel)" }, { "name": "Galvanized (Iron or Steel)", "code": "Galvanized (Iron or Steel)" }, { "name": "Non-Lead (but specific type not known)", "code": "Non-Lead (but specific type not known)" }, { "name": "Non-Lead Non-Galvanized (but specific type not known)", "code": "Non-Lead Non-Galvanized (but specific type not known)" }, { "name": "Copper with Lead Solder", "code": "Copper with Lead Solder" }, { "name": "Copper (No Lead Solder)", "code": "Copper (No Lead Solder)" }, { "name": "Plastic (PVC - Polyvinyl Chloride, HDPE - High Density Polyethylene, PEX - Cross-linked Polyethylene)", "code": "Plastic (PVC - Polyvinyl Chloride, HDPE - High Density Polyethylene, PEX - Cross-linked Polyethylene)" }, { "name": "Non-Galvanized Ferrous Piping Materials (e.g., Cast Iron, Steel, etc.)", "code": "Non-Galvanized Ferrous Piping Materials (e.g., Cast Iron, Steel, etc.)" }, { "name": "Asbestos-Cement", "code": "Asbestos-Cement" }, { "name": "Brass", "code": "Brass" }, { "name": "Vinyl lined asbestos cement pipe", "code": "Vinyl lined asbestos cement pipe" }, { "name": "Coal tar lined pipes", "code": "Coal tar lined pipes" }, { "name": "Multiple (including Lead) Pipe Materials (Please provide details in Comments)", "code": "Multiple (including Lead) Pipe Materials (Please provide details in Comments)" }, { "name": "Multiple Non-Lead Pipe Materials (Please provide details in Comments)", "code": "Multiple Non-Lead Pipe Materials (Please provide details in Comments)" }, { "name": "Other Non-Lead (Specific type known -- Please provide details in Comments)", "code": "Other Non-Lead (Specific type known -- Please provide details in Comments)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_material_source1", "type": "esriFieldTypeString", "alias": "48 Basis of MATERIAL Determination of the Current Service Line Pipe -- Utility 1st portion of service line", "length": 500, "domain": { "type": "codedValue", "name": "Lead MDE Material Determination", "description": "", "codedValues": [ { "name": "1. Pipe material obtained directly from records AND Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)", "code": "1. Pipe material obtained directly from records AND Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)" }, { "name": "2. Pipe material obtained directly from ONLY Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)", "code": "2. Pipe material obtained directly from ONLY Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)" }, { "name": "3. Pipe material obtained directly from records AND Field Investigation via Non-Exposed Service line Pipe Inspection", "code": "3. Pipe material obtained directly from records AND Field Investigation via Non-Exposed Service line Pipe Inspection" }, { "name": "4. Pipe material obtained directly from ONLY Field Investigation via Non-Exposed Service line Pipe Inspection", "code": "4. Pipe material obtained directly from ONLY Field Investigation via Non-Exposed Service line Pipe Inspection" }, { "name": "5. Pipe material obtained directly from records ONLY", "code": "5. Pipe material obtained directly from records ONLY" }, { "name": "6. Pipe material obtained directly from records ONLY (but Analytics/Predictive Method also performed to obtain a prediction -- Please provide the prediction under the \"Analytics/Predictive Method\" section even if prediction does not align with records)", "code": "6. Pipe material obtained directly from records ONLY (but Analytics/Predictive Method also performed to obtain a prediction -- Please provide the prediction under the \"Analytics/Predictive Method\" section even if prediction does not align with records)" }, { "name": "8. Pipe material determined to be Non-Lead based on pipe installation date on or after May 17, 1972 (Maryland's regulations pertaining to acceptable service line materials) (-- Applicable only for \"Non-Lead (but specific type not known)\" pipe material)", "code": "8. Pipe material determined to be Non-Lead based on pipe installation date on or after May 17, 1972 (Maryland's regulations pertaining to acceptable service line materials) (-- Applicable only for \"Non-Lead (but specific type not known)\" pipe material)" }, { "name": "9. Pipe material determined to be Non-Lead or Non-Lead Non-Galvanized based on pipe installation date on or after local ordinance that was in effect prior to May 17, 1972 (-- Applicable only for \"Non-Lead (but specific type not known)\" or \"Non-Lead Non-G", "code": "9. Pipe material determined to be Non-Lead or Non-Lead Non-Galvanized based on pipe installation date on or after local ordinance that was in effect prior to May 17, 1972 (-- Applicable only for \"Non-Lead (but specific type not known)\" or \"Non-Lead Non-Galvanized (but specific type not known)\" pipe material)" }, { "name": "10. Prediction of material from Analytics/Predictive Method ONLY (i.e., no records or field investigations)", "code": "10. Prediction of material from Analytics/Predictive Method ONLY (i.e., no records or field investigations)" }, { "name": "11. Other Basis of Material Determination pre-approved by MDE (Please provide details in \"Other Basis of Determination\")", "code": "11. Other Basis of Material Determination pre-approved by MDE (Please provide details in \"Other Basis of Determination\")" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_past_lead1", "type": "esriFieldTypeString", "alias": "49 Was Utility 1st portion of service line pipe ever lead in the past?", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_past_lead1", "description": "", "codedValues": [ { "name": "Yes - Lead in the Past", "code": "Yes - Lead in the Past" }, { "name": "No - Never lead confirmed through documented records", "code": "No - Never lead confirmed through documented records" }, { "name": "Don't Know", "code": "Don't Know" }, { "name": "Don't Know and Not Applicable - Corresponding 2nd portion of the service line is not galvanized", "code": "Don't Know and Not Applicable - Corresponding 2nd portion of the service line is not galvanized" }, { "name": "Don't Know and Not Applicable - 2nd portion of the service line does not exist", "code": "Don't Know and Not Applicable - 2nd portion of the service line does not exist" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_past_lead1_method", "type": "esriFieldTypeString", "alias": "50 If water system is able to confirm whether or not the Utility 1st portion of the service line was Lead in the past, please provide description of method used", "length": 255, "domain": null }, { "name": "mde_pipe_diameter1", "type": "esriFieldTypeString", "alias": "51 DIAMETER* of CURRENT service line pipe --Utility 1st portion of service", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_pipe_diameter1", "description": "", "codedValues": [ { "name": "Don't Know or Unknown", "code": "Don't Know or Unknown'" }, { "name": "Less than 1\"", "code": "Less than 1'" }, { "name": "Greater than or equal to 1\", but less than 2\"", "code": "Greater than or equal to 1\", but less than 2" }, { "name": "Greater than or equal to 2\", but less than 3\"", "code": "Greater than or equal to 2\", but less than 3\"" }, { "name": "3\"", "code": "3\"" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_pipe_diameter1_source", "type": "esriFieldTypeString", "alias": "52 Basis of DIAMETER Determination of the Curent Service Line Pipe -- Utility 1st portion of service line", "length": 255, "domain": { "type": "codedValue", "name": "Lead_MDE Diameter Determination Category", "description": "Lead_MDE Diameter Category", "codedValues": [ { "name": "1. Pipe diameter obtained directly from records AND Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)", "code": "1. Pipe diameter obtained directly from records AND Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)" }, { "name": "2. Pipe diameter obtained directly from ONLY Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)", "code": "2. Pipe diameter obtained directly from ONLY Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)" }, { "name": "3. Pipe diameter obtained directly from records AND Field Investigation via Non-Exposed Service line Pipe Inspection", "code": "3. Pipe diameter obtained directly from records AND Field Investigation via Non-Exposed Service line Pipe Inspection" }, { "name": "4. Pipe diameter obtained directly from ONLY Field Investigation via Non-Exposed Service line Pipe Inspection", "code": "4. Pipe diameter obtained directly from ONLY Field Investigation via Non-Exposed Service line Pipe Inspection" }, { "name": "5. Pipe diameter obtained directly from records ONLY", "code": "5. Pipe diameter obtained directly from records ONLY" }, { "name": "6. Other Basis of Diameter Determination pre-approved by MDE (Please provide details in \"Other Basis of Determination\")", "code": "6. Other Basis of Diameter Determination pre-approved by MDE (Please provide details in \"Other Basis of Determination\")" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_pipe_install1", "type": "esriFieldTypeString", "alias": "53 INSTALLATION YEAR* of CURRENT service line pipe --Utility 1st portion of service line", "length": 255, "domain": { "type": "codedValue", "name": "mde_installation_date", "description": "", "codedValues": [ { "name": "Don't Know or Unknown", "code": "Don't Know or Unknown" }, { "name": "2024 and After", "code": "2024 and After" }, { "name": "1973 through 2023", "code": "1973 through 2023" }, { "name": "1972 (on or after May 17, i.e., 05/17/1972 - 12/31/1972)", "code": "1972 (on or after May 17, i.e., 05/17/1972 - 12/31/1972)" }, { "name": "1972 (before May 17, i.e., 01/01/1972 - 05/16/1972)", "code": "1972 (before May 17, i.e., 01/01/1972 - 05/16/1972)" }, { "name": "1972 (date and/or month unknown)", "code": "1972 (date and/or month unknown)" }, { "name": "1971 or Earlier", "code": "1971 or Earlier" }, { "name": "2023", "code": "2023" }, { "name": "2022", "code": "2022" }, { "name": "2021", "code": "2021" }, { "name": "2020", "code": "2020" }, { "name": "2019", "code": "2019" }, { "name": "2018", "code": "2018" }, { "name": "2017", "code": "2017" }, { "name": "2016", "code": "2016" }, { "name": "2015", "code": "2015" }, { "name": "2014", "code": "2014" }, { "name": "2013", "code": "2013" }, { "name": "2012", "code": "2012" }, { "name": "2011", "code": "2011" }, { "name": "2010", "code": "2010" }, { "name": "2009", "code": "2009" }, { "name": "2007", "code": "2008" }, { "name": "2006", "code": "2006" }, { "name": "2005", "code": "2005" }, { "name": "2004", "code": "2004" }, { "name": "2003", "code": "2003" }, { "name": "2002", "code": "2002" }, { "name": "2001", "code": "2001" }, { "name": "2000", "code": "2000" }, { "name": "1999", "code": "1999" }, { "name": "1998", "code": "1998" }, { "name": "1997", "code": "1997" }, { "name": "1996", "code": "1996" }, { "name": "1995", "code": "1995" }, { "name": "1994", "code": "1994" }, { "name": "1993", "code": "1993" }, { "name": "1992", "code": "1992" }, { "name": "1991", "code": "1991" }, { "name": "1990", "code": "1990" }, { "name": "1989", "code": "1989" }, { "name": "1988", "code": "1988" }, { "name": "1987", "code": "1987" }, { "name": "1986", "code": "1986" }, { "name": "1985", "code": "1985" }, { "name": "2024", "code": "2024" }, { "name": "2025", "code": "2025" }, { "name": "2026", "code": "2026" }, { "name": "2027", "code": "2027" }, { "name": "2028", "code": "2028" }, { "name": "2029", "code": "2029" }, { "name": "2030", "code": "2030" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_pipe_install1_source", "type": "esriFieldTypeString", "alias": "54 If Installation year of the 1st portion of the service line was determined based on the year the water system was built or the year the structure was built, please provide the description of source(s) used the year built was obtained (e.g., SDAT)", "length": 500, "domain": { "type": "codedValue", "name": "mde Service Line Installation Date Determinatino", "description": "\"Basis of INSTALLATION YEAR Determination of the Curent Service Line Pipe -- 1st portion of service line", "codedValues": [ { "name": "1. Installation year obtained directly from records", "code": "1. Installation year obtained directly from records" }, { "name": "2. Installation year based on year the water system is built -- Applicable only if (a) the water system was built in or after 1973 AND (b) if structure was built prior to 1973, no reuse of existing pipe from well to structure", "code": "2. Installation year based on year the water system is built -- Applicable only if (a) the water system was built in or after 1973 AND (b) if structure was built prior to 1973, no reuse of existing pipe from well to structure" }, { "name": "3. Installation year based on year the structure was built -- Applicable only if the structure was built in or after 1973", "code": "3. Installation year based on year the structure was built -- Applicable only if the structure was built in or after 1973" }, { "name": "4. Other Basis of Installation Year Determination pre-approved by MDE (Please provide details in \"Other Basis of Determination\")", "code": "4. Other Basis of Installation Year Determination pre-approved by MDE (Please provide details in \"Other Basis of Determination\")" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_pipe1_determine", "type": "esriFieldTypeString", "alias": "55 Other Basis of Determination -- 1st portion of service line", "length": 255, "domain": null }, { "name": "mde_material_records1", "type": "esriFieldTypeString", "alias": "56 Records used to obtain material", "length": 255, "domain": null }, { "name": "mde_diameter_records1", "type": "esriFieldTypeString", "alias": "57 Records used to obtain diameter", "length": 255, "domain": null }, { "name": "mde_installation_records1", "type": "esriFieldTypeString", "alias": "58 Records used to obtain installation year", "length": 255, "domain": null }, { "name": "mde_other_records1", "type": "esriFieldTypeString", "alias": "59 Other Records used", "length": 255, "domain": null }, { "name": "mde_pipe_prediction1", "type": "esriFieldTypeString", "alias": "60 Pipe material prediction method", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_pipe_prediction1", "description": "", "codedValues": [ { "name": "Interpolation", "code": "Interpolation" }, { "name": "Statistical and/or Machine Learning Modeling", "code": "Statistical and/or Machine Learning Modeling" }, { "name": "Other Analytics/Predictive Method pre-approved by MDE (Please provide details in \"Other Analytics/Predictive Method(s)\")", "code": "Other Analytics/Predictive Method pre-approved by MDE (Please provide details in \"Other Analytics/Predictive Method(s)\")" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_pipe_prediction_material1", "type": "esriFieldTypeString", "alias": "61 Pipe material prediction of Utility", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_pipe_prediction_material1", "description": "", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "Likely Lead", "code": "Likely Lead" }, { "name": "Likely Lead-lined Galvanized (Iron or Steel)", "code": "Likely Lead-lined Galvanized (Iron or Steel)" }, { "name": "Likely Non-Lead (but specific type unknown)", "code": "Likely Non-Lead (but specific type unknown)" }, { "name": "Likely Non-Lead Non-Galvanized (but specific type not known)", "code": "Likely Non-Lead Non-Galvanized (but specific type not known)" }, { "name": "Likely Galvanized (Iron or Steel)", "code": "Likely Galvanized (Iron or Steel)" }, { "name": "Likely Copper with Lead Solder", "code": "Likely Copper with Lead Solder" }, { "name": "Likely Copper (No Lead Solder)", "code": "Likely Copper (No Lead Solder)" }, { "name": "Likely Plastic (PVC - Polyvinyl Chloride, HDPE - High Density Polyethylene, PEX - Cross-linked Polyethylene)", "code": "Likely Plastic (PVC - Polyvinyl Chloride, HDPE - High Density Polyethylene, PEX - Cross-linked Polyethylene)" }, { "name": "Likely Non-Galvanized Ferrous Piping Materials (e.g., Cast Iron, Steel, etc.)", "code": "Likely Non-Galvanized Ferrous Piping Materials (e.g., Cast Iron, Steel, etc.)" }, { "name": "Likely Asbestos-Cement", "code": "Likely Asbestos-Cement" }, { "name": "Likely Brass", "code": "Likely Brass" }, { "name": "Likely Vinyl lined asbestos cement pipe", "code": "Likely Vinyl lined asbestos cement pipe" }, { "name": "Likely Coal tar lined pipes", "code": "Likely Coal tar lined pipes" }, { "name": "Likely Other Non-Lead (Specific type known -- Please provide details in Comments)", "code": "Likely Other Non-Lead (Specific type known -- Please provide details in Comments)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_pipe_prediction_prob1", "type": "esriFieldTypeDouble", "alias": "63 Pipe material probablity", "domain": null }, { "name": "utilverified", "type": "esriFieldTypeString", "alias": "64 Utility Side Verified", "length": 255, "domain": { "type": "codedValue", "name": "cvd_utilverified", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Don't Know", "code": "Don't Know" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "utilverifdate", "type": "esriFieldTypeDate", "alias": "65 Utility Verification Date", "length": 8, "domain": null }, { "name": "utilstatus", "type": "esriFieldTypeString", "alias": "66 Utility Status", "length": 255, "domain": { "type": "codedValue", "name": "cvd_epa_status", "description": "", "codedValues": [ { "name": "Unknown", "code": "0" }, { "name": "Lead", "code": "1" }, { "name": "Non-Lead", "code": "2" }, { "name": "Galvanized Requiring Replacement", "code": "3" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_field_verification1", "type": "esriFieldTypeString", "alias": "67 Exposed Service Line", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_field_verification1", "description": "", "codedValues": [ { "name": "ONLY 1 location visually inspected (WITHOUT excavation)", "code": "ONLY 1 location visually inspected (WITHOUT excavation)" }, { "name": "ONLY 1 location visually inspected (WITH excavation)", "code": "ONLY 1 location visually inspected (WITH excavation)" }, { "name": "2 or more locations visually inspected (WITHOUT excavation at any of the locations)", "code": "2 or more locations visually inspected (WITHOUT excavation at any of the locations)" }, { "name": "2 or more locations visually inspected (WITH excavation at ONLY 1 of the locations)", "code": "2 or more locations visually inspected (WITH excavation at ONLY 1 of the locations)" }, { "name": "2 or more locations visually inspected (WITH excavation at 2 or more of the locations)", "code": "2 or more locations visually inspected (WITH excavation at 2 or more of the locations)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_field_exposed1", "type": "esriFieldTypeString", "alias": "68 Excavation Type", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_field_exposed1", "description": "", "codedValues": [ { "name": "Mechanical Excavation", "code": "Mechanical Excavation" }, { "name": "Vacuum/Hydro Excavation", "code": "Vacuum/Hydro Excavation" }, { "name": "Both Mechanical and Vacuum/Hydro Excavations", "code": "Both Mechanical and Vacuum/Hydro Excavations" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_field_visual1", "type": "esriFieldTypeString", "alias": "69 Visual Inspection Method", "length": 255, "domain": null }, { "name": "mde_field_materialtest1", "type": "esriFieldTypeString", "alias": "70 Material Test perform", "length": 255, "domain": null }, { "name": "mde_field_materialremote1", "type": "esriFieldTypeString", "alias": "71 Method material verification without excavation", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_field_materialremote1", "description": "", "codedValues": [ { "name": "Metal Detector", "code": "Metal Detector" }, { "name": "Other Non-Exposed Service Line Pipe Inspection Method(s) pre-approved by MDE (Please provide details in \"Other Non-Exposed Service Line Pipe Inspection Method(s)\")", "code": "Other Non-Exposed Service Line Pipe Inspection Method(s) pre-approved by MDE (Please provide details in \"Other Non-Exposed Service Line Pipe Inspection Method(s)\")" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_field_diameterremote1", "type": "esriFieldTypeString", "alias": "72 Method of diameter verification without excavation", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_field_diameterremote1", "description": "", "codedValues": [ { "name": "Ground-Penetrating Radar (GPR)", "code": "Ground-Penetrating Radar (GPR)" }, { "name": "Other Non-Exposed Service Line Pipe Inspection Method(s) pre-approved by MDE (Please provide details in \"Other Non-Exposed Service Line Pipe Inspection Method(s)\")", "code": "Other Non-Exposed Service Line Pipe Inspection Method(s) pre-approved by MDE (Please provide details in \"Other Non-Exposed Service Line Pipe Inspection Method(s)\")" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_field_tool_model1", "type": "esriFieldTypeString", "alias": "73 Make and model of Instrument used", "length": 255, "domain": null }, { "name": "mde_feild_metaldetector1", "type": "esriFieldTypeString", "alias": "74 Number of segments used by metal detector", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_feild_metaldetector1", "description": "", "codedValues": [ { "name": "All 3 required segments", "code": "All 3 required segments" }, { "name": "Only 1 or 2 of the required segments [Applicable only if SL pipe material is Lead]", "code": "Only 1 or 2 of the required segments [Applicable only if SL pipe material is Lead]" }, { "name": "The entire length of service line pipe", "code": "The entire length of service line pipe" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_gpr1", "type": "esriFieldTypeString", "alias": "75 Number of segments used by GPR", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_gpr1", "description": "", "codedValues": [ { "name": "All 3 required segments", "code": "All 3 required segments" }, { "name": "The entire length of service line pipe", "code": "The entire length of service line pipe" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_cctv1", "type": "esriFieldTypeString", "alias": "76 CCTV was used to gather info", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_cctv1", "description": "", "codedValues": [ { "name": "Yes - Method conducted", "code": "Yes - Method conducted" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_field_nonexposedmethod1", "type": "esriFieldTypeString", "alias": "77 Other Non Exposed method used", "length": 255, "domain": null }, { "name": "mde_valve1", "type": "esriFieldTypeString", "alias": "78 Valve on 1st portion status", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_valve1", "description": "", "codedValues": [ { "name": "Yes - Valve contains more than 8% Lead", "code": "Yes - Valve contains more than 8% Lead" }, { "name": "No", "code": "No" }, { "name": "Don't Know", "code": "Don't Know" }, { "name": "Not Applicable - No Valve Present", "code": "Not Applicable - No Valve Present" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_notes1_utility", "type": "esriFieldTypeString", "alias": "79 Utility Side Notes", "length": 255, "domain": null }, { "name": "mde_line_replaced2", "type": "esriFieldTypeString", "alias": "80 Is the CURRENT service line pipe (2nd Portion) a replacement of the previous service line reported in the water system's most recent submittal of the inventory spreadsheet?", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_past_lead1", "description": "", "codedValues": [ { "name": "Yes - Lead in the Past", "code": "Yes - Lead in the Past" }, { "name": "No - Never lead confirmed through documented records", "code": "No - Never lead confirmed through documented records" }, { "name": "Don't Know", "code": "Don't Know" }, { "name": "Don't Know and Not Applicable - Corresponding 2nd portion of the service line is not galvanized", "code": "Don't Know and Not Applicable - Corresponding 2nd portion of the service line is not galvanized" }, { "name": "Don't Know and Not Applicable - 2nd portion of the service line does not exist", "code": "Don't Know and Not Applicable - 2nd portion of the service line does not exist" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "custassetid", "type": "esriFieldTypeString", "alias": "81 Customer Asset ID", "length": 255, "domain": null }, { "name": "custsource", "type": "esriFieldTypeString", "alias": "82 Customer Source", "length": 255, "domain": { "type": "codedValue", "name": "Lead_Source", "description": "", "codedValues": [ { "name": "Installation record (e.g., tap card)", "code": "Installation record (e.g., tap card)" }, { "name": "Water sampling only with no records", "code": "Water sampling only with no records" }, { "name": "Field inspection only with no records", "code": "Field inspection only with no records" }, { "name": "Statistical analysis", "code": "Statistical analysis" }, { "name": "Previous materials evaluation", "code": "Previous materials evaluation" }, { "name": "Installation date is after the lead ban", "code": "Installation date is after the lead ban" }, { "name": "Service line diameter is greater than 2 inches", "code": "Service line diameter is greater than 2 inches" }, { "name": "Service line repair or replacement record", "code": "Service line repair or replacement record" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "custmaterial", "type": "esriFieldTypeString", "alias": "83 Customer Material", "length": 255, "domain": { "type": "codedValue", "name": "Lead_Water_Service_Material_2", "description": "", "codedValues": [ { "name": "Unknown - Material Unknown", "code": "Unknown - Material Unknown" }, { "name": "Unknown - Likely Lead", "code": "Unknown - Likely Lead" }, { "name": "Unknown - Unlikely Lead", "code": "Unknown - Unlikely Lead" }, { "name": "Non-Lead - Other", "code": "Non-Lead - Other" }, { "name": "Non-Lead - Copper", "code": "Non-Lead - Copper" }, { "name": "Non-Lead - Plastic", "code": "Non-Lead - Plastic" }, { "name": "Galvanized", "code": "Galvanized" }, { "name": "Lead", "code": "Lead" }, { "name": "Lead-lined galvanized", "code": "Lead-lined galvanized" }, { "name": "GRR", "code": "GRR" }, { "name": "Non-Lead - Built Post-1986", "code": "Non-Lead - Built Post-1986" }, { "name": "Non-Lead - Ductile Iron", "code": "Non-Lead - Ductile Iron" }, { "name": "Non-Lead - Transite", "code": "Non-Lead - Transite" }, { "name": "Copper with Lead Solder", "code": "Copper with Lead Solder" }, { "name": "Non-Lead - Asbestos-Cement", "code": "Non-Lead - Asbestos-Cement" }, { "name": "Non-Lead - Brass", "code": "Non-Lead - Brass" }, { "name": "Non-Lead - Vinyl lined asbestos cement pipe", "code": "Non-Lead - Vinyl lined asbestos cement pipe" }, { "name": "Non-Lead - Coal tar lined pipes", "code": "Non-Lead - Coal tar lined pipes" }, { "name": "Multiple (including Lead) Pipe Materials", "code": "Multiple (including Lead) Pipe Materials" }, { "name": "Non-Lead - Multiple Materials", "code": "Non-Lead - Multiple Materials " } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "custdiameter", "type": "esriFieldTypeString", "alias": "84 Customer Diameter", "length": 255, "domain": { "type": "codedValue", "name": "cvd_epa_diameter", "description": "", "codedValues": [ { "name": "1/2\"", "code": "0.5" }, { "name": "3/4\"", "code": "0.75" }, { "name": "1\"", "code": "1" }, { "name": "1 1/4\"", "code": "1.25" }, { "name": "1 1/2\"", "code": "1.5" }, { "name": "2\"", "code": "2" }, { "name": "2 1/4\"", "code": "2.25" }, { "name": "2 1/2\"", "code": "2.5" }, { "name": "3\"", "code": "3" }, { "name": "4\"", "code": "4" }, { "name": "4 1/2\"", "code": "4.5" }, { "name": "5 1/4\"", "code": "5.25" }, { "name": "6\"", "code": "6" }, { "name": "8\"", "code": "8" }, { "name": "10\"", "code": "10" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "custinstalldate", "type": "esriFieldTypeDate", "alias": "85 Customer Install Date", "length": 8, "domain": null }, { "name": "mde_pipe_material2", "type": "esriFieldTypeString", "alias": "86 MATERIAL of CURRENT service line pipe -- Customer 2nd portion of service line", "length": 255, "domain": { "type": "codedValue", "name": "Lead MDE Pipe Material", "description": "", "codedValues": [ { "name": "Don't Know or Unknown", "code": "Don't Know or Unknown" }, { "name": "Likely Lead (prediction with no threshold set - considered as unknown)", "code": "Likely Lead (prediction with no threshold set - considered as unknown)" }, { "name": "Likely Non-Lead (prediction with no threshold set - considered as unknown)", "code": "Likely Non-Lead (prediction with no threshold set - considered as unknown)" }, { "name": "Lead", "code": "Lead" }, { "name": "Lead-lined Galvanized (Iron or Steel)", "code": "Lead-lined Galvanized (Iron or Steel)" }, { "name": "Galvanized (Iron or Steel)", "code": "Galvanized (Iron or Steel)" }, { "name": "Non-Lead (but specific type not known)", "code": "Non-Lead (but specific type not known)" }, { "name": "Non-Lead Non-Galvanized (but specific type not known)", "code": "Non-Lead Non-Galvanized (but specific type not known)" }, { "name": "Copper with Lead Solder", "code": "Copper with Lead Solder" }, { "name": "Copper (No Lead Solder)", "code": "Copper (No Lead Solder)" }, { "name": "Plastic (PVC - Polyvinyl Chloride, HDPE - High Density Polyethylene, PEX - Cross-linked Polyethylene)", "code": "Plastic (PVC - Polyvinyl Chloride, HDPE - High Density Polyethylene, PEX - Cross-linked Polyethylene)" }, { "name": "Non-Galvanized Ferrous Piping Materials (e.g., Cast Iron, Steel, etc.)", "code": "Non-Galvanized Ferrous Piping Materials (e.g., Cast Iron, Steel, etc.)" }, { "name": "Asbestos-Cement", "code": "Asbestos-Cement" }, { "name": "Brass", "code": "Brass" }, { "name": "Vinyl lined asbestos cement pipe", "code": "Vinyl lined asbestos cement pipe" }, { "name": "Coal tar lined pipes", "code": "Coal tar lined pipes" }, { "name": "Multiple (including Lead) Pipe Materials (Please provide details in Comments)", "code": "Multiple (including Lead) Pipe Materials (Please provide details in Comments)" }, { "name": "Multiple Non-Lead Pipe Materials (Please provide details in Comments)", "code": "Multiple Non-Lead Pipe Materials (Please provide details in Comments)" }, { "name": "Other Non-Lead (Specific type known -- Please provide details in Comments)", "code": "Other Non-Lead (Specific type known -- Please provide details in Comments)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_material_source2", "type": "esriFieldTypeString", "alias": "87 Basis of MATERIAL Determination of the Current Service Line Pipe -- Customer 2nd portion of service line", "length": 500, "domain": { "type": "codedValue", "name": "Lead MDE Material Determination", "description": "", "codedValues": [ { "name": "1. Pipe material obtained directly from records AND Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)", "code": "1. Pipe material obtained directly from records AND Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)" }, { "name": "2. Pipe material obtained directly from ONLY Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)", "code": "2. Pipe material obtained directly from ONLY Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)" }, { "name": "3. Pipe material obtained directly from records AND Field Investigation via Non-Exposed Service line Pipe Inspection", "code": "3. Pipe material obtained directly from records AND Field Investigation via Non-Exposed Service line Pipe Inspection" }, { "name": "4. Pipe material obtained directly from ONLY Field Investigation via Non-Exposed Service line Pipe Inspection", "code": "4. Pipe material obtained directly from ONLY Field Investigation via Non-Exposed Service line Pipe Inspection" }, { "name": "5. Pipe material obtained directly from records ONLY", "code": "5. Pipe material obtained directly from records ONLY" }, { "name": "6. Pipe material obtained directly from records ONLY (but Analytics/Predictive Method also performed to obtain a prediction -- Please provide the prediction under the \"Analytics/Predictive Method\" section even if prediction does not align with records)", "code": "6. Pipe material obtained directly from records ONLY (but Analytics/Predictive Method also performed to obtain a prediction -- Please provide the prediction under the \"Analytics/Predictive Method\" section even if prediction does not align with records)" }, { "name": "8. Pipe material determined to be Non-Lead based on pipe installation date on or after May 17, 1972 (Maryland's regulations pertaining to acceptable service line materials) (-- Applicable only for \"Non-Lead (but specific type not known)\" pipe material)", "code": "8. Pipe material determined to be Non-Lead based on pipe installation date on or after May 17, 1972 (Maryland's regulations pertaining to acceptable service line materials) (-- Applicable only for \"Non-Lead (but specific type not known)\" pipe material)" }, { "name": "9. Pipe material determined to be Non-Lead or Non-Lead Non-Galvanized based on pipe installation date on or after local ordinance that was in effect prior to May 17, 1972 (-- Applicable only for \"Non-Lead (but specific type not known)\" or \"Non-Lead Non-G", "code": "9. Pipe material determined to be Non-Lead or Non-Lead Non-Galvanized based on pipe installation date on or after local ordinance that was in effect prior to May 17, 1972 (-- Applicable only for \"Non-Lead (but specific type not known)\" or \"Non-Lead Non-Galvanized (but specific type not known)\" pipe material)" }, { "name": "10. Prediction of material from Analytics/Predictive Method ONLY (i.e., no records or field investigations)", "code": "10. Prediction of material from Analytics/Predictive Method ONLY (i.e., no records or field investigations)" }, { "name": "11. Other Basis of Material Determination pre-approved by MDE (Please provide details in \"Other Basis of Determination\")", "code": "11. Other Basis of Material Determination pre-approved by MDE (Please provide details in \"Other Basis of Determination\")" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_past_lead2", "type": "esriFieldTypeString", "alias": "88 Was Customer 2nd portion of service line pipe ever lead in the past?", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_past_lead1", "description": "", "codedValues": [ { "name": "Yes - Lead in the Past", "code": "Yes - Lead in the Past" }, { "name": "No - Never lead confirmed through documented records", "code": "No - Never lead confirmed through documented records" }, { "name": "Don't Know", "code": "Don't Know" }, { "name": "Don't Know and Not Applicable - Corresponding 2nd portion of the service line is not galvanized", "code": "Don't Know and Not Applicable - Corresponding 2nd portion of the service line is not galvanized" }, { "name": "Don't Know and Not Applicable - 2nd portion of the service line does not exist", "code": "Don't Know and Not Applicable - 2nd portion of the service line does not exist" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_past_lead2_method", "type": "esriFieldTypeString", "alias": "089 If water system is able to confirm whether or not the Customer 2nd portion of the service line was Lead in the past, please provide description of method used", "length": 255, "domain": null }, { "name": "pipe_diameter2", "type": "esriFieldTypeString", "alias": "090 Customer Diameter", "length": 255, "domain": { "type": "codedValue", "name": "cvd_pipe_diameter1", "description": "", "codedValues": [ { "name": "1/2\"", "code": "0.5" }, { "name": "3/4\"", "code": "0.75" }, { "name": "1\"", "code": "1" }, { "name": "1 1/4\"", "code": "1.25" }, { "name": "1 1/2\"", "code": "1.5" }, { "name": "2\"", "code": "2" }, { "name": "2 1/4\"", "code": "2.25" }, { "name": "2 1/2\"", "code": "2.5" }, { "name": "3\"", "code": "3" }, { "name": "4\"", "code": "4" }, { "name": "4 1/2\"", "code": "4.5" }, { "name": "5 1/4\"", "code": "5.25" }, { "name": "6\"", "code": "6" }, { "name": "8\"", "code": "8" }, { "name": "10\"", "code": "10" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_pipe_diameter2", "type": "esriFieldTypeString", "alias": "091 DIAMETER* of CURRENT service line pipe --Customer 2nd portion of service", "length": 255, "domain": { "type": "codedValue", "name": "mde_serviceline_Diameter", "description": "", "codedValues": [ { "name": "Don't Know or Unknown", "code": "Don't Know or Unknown" }, { "name": "Less than 1\"", "code": "Less than 1\"" }, { "name": "Greater than or equal to 1\", but less than 2\"", "code": "Greater than or equal to 1\", but less than 2\"" }, { "name": "Greater than or equal to 2\", but less than 3\"", "code": "Greater than or equal to 2\", but less than 3\"" }, { "name": "3\"", "code": "3\"" }, { "name": "Greater than 3\"", "code": "Greater than 3\"" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_pipe_diameter2_source", "type": "esriFieldTypeString", "alias": "092 Basis of DIAMETER Determination of the Curent Service Line Pipe -- Customer 2nd portion of service line", "length": 500, "domain": { "type": "codedValue", "name": "mde_diameter_determination", "description": "", "codedValues": [ { "name": "1. Pipe diameter obtained directly from records AND Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)", "code": "1. Pipe diameter obtained directly from records AND Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)" }, { "name": "2. Pipe diameter obtained directly from ONLY Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)", "code": "2. Pipe diameter obtained directly from ONLY Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)" }, { "name": "3. Pipe diameter obtained directly from records AND Field Investigation via Non-Exposed Service line Pipe Inspection", "code": "3. Pipe diameter obtained directly from records AND Field Investigation via Non-Exposed Service line Pipe Inspection" }, { "name": "4. Pipe diameter obtained directly from ONLY Field Investigation via Non-Exposed Service line Pipe Inspection", "code": "4. Pipe diameter obtained directly from ONLY Field Investigation via Non-Exposed Service line Pipe Inspection" }, { "name": "5. Pipe diameter obtained directly from records ONLY", "code": "5. Pipe diameter obtained directly from records ONLY" }, { "name": "6. Other Basis of Diameter Determination pre-approved by MDE (Please provide details in \"Other Basis of Determination\")", "code": "6. Other Basis of Diameter Determination pre-approved by MDE (Please provide details in \"Other Basis of Determination\")" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_pipe_install2", "type": "esriFieldTypeString", "alias": "093 Installation Date of 2nd portion", "length": 255, "domain": { "type": "codedValue", "name": "mde_installation_date", "description": "", "codedValues": [ { "name": "Don't Know or Unknown", "code": "Don't Know or Unknown" }, { "name": "2024 and After", "code": "2024 and After" }, { "name": "1973 through 2023", "code": "1973 through 2023" }, { "name": "1972 (on or after May 17, i.e., 05/17/1972 - 12/31/1972)", "code": "1972 (on or after May 17, i.e., 05/17/1972 - 12/31/1972)" }, { "name": "1972 (before May 17, i.e., 01/01/1972 - 05/16/1972)", "code": "1972 (before May 17, i.e., 01/01/1972 - 05/16/1972)" }, { "name": "1972 (date and/or month unknown)", "code": "1972 (date and/or month unknown)" }, { "name": "1971 or Earlier", "code": "1971 or Earlier" }, { "name": "2023", "code": "2023" }, { "name": "2022", "code": "2022" }, { "name": "2021", "code": "2021" }, { "name": "2020", "code": "2020" }, { "name": "2019", "code": "2019" }, { "name": "2018", "code": "2018" }, { "name": "2017", "code": "2017" }, { "name": "2016", "code": "2016" }, { "name": "2015", "code": "2015" }, { "name": "2014", "code": "2014" }, { "name": "2013", "code": "2013" }, { "name": "2012", "code": "2012" }, { "name": "2011", "code": "2011" }, { "name": "2010", "code": "2010" }, { "name": "2009", "code": "2009" }, { "name": "2007", "code": "2008" }, { "name": "2006", "code": "2006" }, { "name": "2005", "code": "2005" }, { "name": "2004", "code": "2004" }, { "name": "2003", "code": "2003" }, { "name": "2002", "code": "2002" }, { "name": "2001", "code": "2001" }, { "name": "2000", "code": "2000" }, { "name": "1999", "code": "1999" }, { "name": "1998", "code": "1998" }, { "name": "1997", "code": "1997" }, { "name": "1996", "code": "1996" }, { "name": "1995", "code": "1995" }, { "name": "1994", "code": "1994" }, { "name": "1993", "code": "1993" }, { "name": "1992", "code": "1992" }, { "name": "1991", "code": "1991" }, { "name": "1990", "code": "1990" }, { "name": "1989", "code": "1989" }, { "name": "1988", "code": "1988" }, { "name": "1987", "code": "1987" }, { "name": "1986", "code": "1986" }, { "name": "1985", "code": "1985" }, { "name": "2024", "code": "2024" }, { "name": "2025", "code": "2025" }, { "name": "2026", "code": "2026" }, { "name": "2027", "code": "2027" }, { "name": "2028", "code": "2028" }, { "name": "2029", "code": "2029" }, { "name": "2030", "code": "2030" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_pipe_install2_source", "type": "esriFieldTypeString", "alias": "094 If Installation year of the 2nd portion of the service line was determined based on the year the water system was built or the year the structure was built, please provide the description of source(s) used the year built was obtained (e.g., SDAT)", "length": 500, "domain": null }, { "name": "mde_pipe2_determine", "type": "esriFieldTypeString", "alias": "095 Other Basis of Determination -- 2nd portion of service line", "length": 255, "domain": null }, { "name": "mde_material_records2", "type": "esriFieldTypeString", "alias": "096 Records used to obtain material", "length": 255, "domain": null }, { "name": "mde_diameter_records2", "type": "esriFieldTypeString", "alias": "097 Records used to obtain diameter", "length": 255, "domain": null }, { "name": "mde_installation_records2", "type": "esriFieldTypeString", "alias": "098 Records used to obtain installation year", "length": 255, "domain": null }, { "name": "mde_other_records2", "type": "esriFieldTypeString", "alias": "099 Other Records used", "length": 255, "domain": null }, { "name": "mde_pipe_prediction2", "type": "esriFieldTypeString", "alias": "100 Pipe material prediction method", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_pipe_prediction2", "description": "", "codedValues": [ { "name": "Interpolation", "code": "Interpolation" }, { "name": "Statistical and/or Machine Learning Modeling", "code": "Statistical and/or Machine Learning Modeling" }, { "name": "Other Analytics/Predictive Method pre-approved by MDE (Please provide details in \"Other Analytics/Predictive Method(s)\")", "code": "Other Analytics/Predictive Method pre-approved by MDE (Please provide details in \"Other Analytics/Predictive Method(s)\")" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_pipe_prediction_material2", "type": "esriFieldTypeString", "alias": "101 Pipe material prediction of Utility", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_pipe_prediction_material2", "description": "", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "Likely Lead", "code": "Likely Lead" }, { "name": "Likely Lead-lined Galvanized (Iron or Steel)", "code": "Likely Lead-lined Galvanized (Iron or Steel)" }, { "name": "Likely Non-Lead (but specific type unknown)", "code": "Likely Non-Lead (but specific type unknown)" }, { "name": "Likely Non-Lead Non-Galvanized (but specific type not known)", "code": "Likely Non-Lead Non-Galvanized (but specific type not known)" }, { "name": "Likely Galvanized (Iron or Steel)", "code": "Likely Galvanized (Iron or Steel)" }, { "name": "Likely Copper with Lead Solder", "code": "Likely Copper with Lead Solder" }, { "name": "Likely Copper (No Lead Solder)", "code": "Likely Copper (No Lead Solder)" }, { "name": "Likely Plastic (PVC - Polyvinyl Chloride, HDPE - High Density Polyethylene, PEX - Cross-linked Polyethylene)", "code": "Likely Plastic (PVC - Polyvinyl Chloride, HDPE - High Density Polyethylene, PEX - Cross-linked Polyethylene)" }, { "name": "Likely Non-Galvanized Ferrous Piping Materials (e.g., Cast Iron, Steel, etc.)", "code": "Likely Non-Galvanized Ferrous Piping Materials (e.g., Cast Iron, Steel, etc.)" }, { "name": "Likely Asbestos-Cement", "code": "Likely Asbestos-Cement" }, { "name": "Likely Brass", "code": "Likely Brass" }, { "name": "Likely Vinyl lined asbestos cement pipe", "code": "Likely Vinyl lined asbestos cement pipe" }, { "name": "Likely Coal tar lined pipes", "code": "Likely Coal tar lined pipes" }, { "name": "Likely Other Non-Lead (Specific type known -- Please provide details in Comments)", "code": "Likely Other Non-Lead (Specific type known -- Please provide details in Comments)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_pipe_prediction_prob2", "type": "esriFieldTypeDouble", "alias": "102 Pipe material probablity", "domain": null }, { "name": "custverified", "type": "esriFieldTypeString", "alias": "103 Customer Side Verified", "length": 255, "domain": { "type": "codedValue", "name": "mde_Yes_No_DontKnow", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Don't Know", "code": "Don't Know" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "custverifdate", "type": "esriFieldTypeDate", "alias": "104 Customer Verification Date", "length": 8, "domain": null }, { "name": "custverifmethod", "type": "esriFieldTypeString", "alias": "105 Customer Verification Method", "length": 255, "domain": { "type": "codedValue", "name": "Lead__Verification_Method_1", "description": "", "codedValues": [ { "name": "Visual inspection at meter pit", "code": "Visual inspection at meter pit" }, { "name": "Customer self-identification", "code": "Customer self-identification" }, { "name": "CCTV Inspection at Curb Box - Internal", "code": "CCTV Inspection at Curb Box - Internal" }, { "name": "CCTV inspection at Curb Box - External", "code": "CCTV inspection at Curb Box - External" }, { "name": "Water Quality Sampling - Targeted", "code": "Water Quality Sampling - Targeted" }, { "name": "Water Quality Sampling - Flushed", "code": "Water Quality Sampling - Flushed" }, { "name": "Water Quality Sampling - Sequential", "code": "Water Quality Sampling - Sequential" }, { "name": "Water Quality Sampling - Other", "code": "Water Quality Sampling - Other" }, { "name": "Mechanical Excavation at 1 location", "code": "Mechanical Excavation at 1 location" }, { "name": "Mechanical Excavation at multiple locations", "code": "Mechanical Excavation at multiple locations" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "custstatus", "type": "esriFieldTypeString", "alias": "106 Customer Status", "length": 255, "domain": { "type": "codedValue", "name": "cvd_epa_status", "description": "", "codedValues": [ { "name": "Unknown", "code": "0" }, { "name": "Lead", "code": "1" }, { "name": "Non-Lead", "code": "2" }, { "name": "Galvanized Requiring Replacement", "code": "3" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_field_verification2", "type": "esriFieldTypeString", "alias": "107 Exposed Service Line", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_field_verification1", "description": "", "codedValues": [ { "name": "ONLY 1 location visually inspected (WITHOUT excavation)", "code": "ONLY 1 location visually inspected (WITHOUT excavation)" }, { "name": "ONLY 1 location visually inspected (WITH excavation)", "code": "ONLY 1 location visually inspected (WITH excavation)" }, { "name": "2 or more locations visually inspected (WITHOUT excavation at any of the locations)", "code": "2 or more locations visually inspected (WITHOUT excavation at any of the locations)" }, { "name": "2 or more locations visually inspected (WITH excavation at ONLY 1 of the locations)", "code": "2 or more locations visually inspected (WITH excavation at ONLY 1 of the locations)" }, { "name": "2 or more locations visually inspected (WITH excavation at 2 or more of the locations)", "code": "2 or more locations visually inspected (WITH excavation at 2 or more of the locations)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_field_exposed2", "type": "esriFieldTypeString", "alias": "108 Excavation Type", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_field_exposed1", "description": "", "codedValues": [ { "name": "Mechanical Excavation", "code": "Mechanical Excavation" }, { "name": "Vacuum/Hydro Excavation", "code": "Vacuum/Hydro Excavation" }, { "name": "Both Mechanical and Vacuum/Hydro Excavations", "code": "Both Mechanical and Vacuum/Hydro Excavations" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_field_visual2", "type": "esriFieldTypeString", "alias": "109 Visual Inspection Method", "length": 255, "domain": null }, { "name": "mde_field_materialtest2", "type": "esriFieldTypeString", "alias": "110 Material Test perform", "length": 255, "domain": null }, { "name": "mde_field_materialremote2", "type": "esriFieldTypeString", "alias": "112 Method material verification without excavation", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_field_materialremote1", "description": "", "codedValues": [ { "name": "Metal Detector", "code": "Metal Detector" }, { "name": "Other Non-Exposed Service Line Pipe Inspection Method(s) pre-approved by MDE (Please provide details in \"Other Non-Exposed Service Line Pipe Inspection Method(s)\")", "code": "Other Non-Exposed Service Line Pipe Inspection Method(s) pre-approved by MDE (Please provide details in \"Other Non-Exposed Service Line Pipe Inspection Method(s)\")" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_field_diameterremote2", "type": "esriFieldTypeString", "alias": "113 Method of diameter verification without excavation", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_field_diameterremote1", "description": "", "codedValues": [ { "name": "Ground-Penetrating Radar (GPR)", "code": "Ground-Penetrating Radar (GPR)" }, { "name": "Other Non-Exposed Service Line Pipe Inspection Method(s) pre-approved by MDE (Please provide details in \"Other Non-Exposed Service Line Pipe Inspection Method(s)\")", "code": "Other Non-Exposed Service Line Pipe Inspection Method(s) pre-approved by MDE (Please provide details in \"Other Non-Exposed Service Line Pipe Inspection Method(s)\")" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_field_tool_model2", "type": "esriFieldTypeString", "alias": "114 Make and model of Instrument used", "length": 255, "domain": null }, { "name": "mde_feild_metaldetector2", "type": "esriFieldTypeString", "alias": "115 Number of segments used by metal detector", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_feild_metaldetector1", "description": "", "codedValues": [ { "name": "All 3 required segments", "code": "All 3 required segments" }, { "name": "Only 1 or 2 of the required segments [Applicable only if SL pipe material is Lead]", "code": "Only 1 or 2 of the required segments [Applicable only if SL pipe material is Lead]" }, { "name": "The entire length of service line pipe", "code": "The entire length of service line pipe" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_gpr2", "type": "esriFieldTypeString", "alias": "116 Number of segments used by GPR", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_gpr1", "description": "", "codedValues": [ { "name": "All 3 required segments", "code": "All 3 required segments" }, { "name": "The entire length of service line pipe", "code": "The entire length of service line pipe" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_cctv2", "type": "esriFieldTypeString", "alias": "117 CCTV was used to gather info", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_cctv1", "description": "", "codedValues": [ { "name": "Yes - Method conducted", "code": "Yes - Method conducted" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_field_nonexposedmethod2", "type": "esriFieldTypeString", "alias": "118 Other Non Exposed method used", "length": 255, "domain": null }, { "name": "mde_valve2", "type": "esriFieldTypeString", "alias": "119 Valve Material to 2nd part", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_valve1", "description": "", "codedValues": [ { "name": "Yes - Valve contains more than 8% Lead", "code": "Yes - Valve contains more than 8% Lead" }, { "name": "No", "code": "No" }, { "name": "Don't Know", "code": "Don't Know" }, { "name": "Not Applicable - No Valve Present", "code": "Not Applicable - No Valve Present" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "custnotes", "type": "esriFieldTypeString", "alias": "120 Customer Side Notes", "length": 255, "domain": null }, { "name": "bothsidesstatus", "type": "esriFieldTypeString", "alias": "121 Entire Service Line Status", "length": 255, "domain": null }, { "name": "replacestatus", "type": "esriFieldTypeString", "alias": "122 Replacement Status", "length": 255, "domain": { "type": "codedValue", "name": "Lead_Replacement_Status", "description": "", "codedValues": [ { "name": "Doesn't Need Replacement", "code": "Doesn't Need Replacement" }, { "name": "Needs Replacement", "code": "Needs Replacement" }, { "name": "Scheduled Replacement", "code": "Scheduled Replacement" }, { "name": "Replaced", "code": "Replaced" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "scheddate", "type": "esriFieldTypeDate", "alias": "123 Utility Side Scheduled Replacement Date", "length": 8, "domain": null }, { "name": "utilreplacedate", "type": "esriFieldTypeDate", "alias": "124 Utility Replacement Date", "length": 8, "domain": null }, { "name": "custscheddate", "type": "esriFieldTypeDate", "alias": "125 Customer Side Scheduled Replacement Date", "length": 8, "domain": null }, { "name": "custreplacedate", "type": "esriFieldTypeDate", "alias": "126 Customer Side Replacement Date", "length": 8, "domain": null }, { "name": "replacereason", "type": "esriFieldTypeString", "alias": "127 Reason for Replacement", "length": 255, "domain": { "type": "codedValue", "name": "Lead_Reason_Replacement", "description": "", "codedValues": [ { "name": "Lead", "code": "Lead" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "custnotified", "type": "esriFieldTypeString", "alias": "128 Notified Customer", "length": 255, "domain": null }, { "name": "notifydate", "type": "esriFieldTypeDate", "alias": "129 Notification Date", "length": 8, "domain": null }, { "name": "sensitivepop", "type": "esriFieldTypeString", "alias": "130 Sensitive Population", "length": 255, "domain": { "type": "codedValue", "name": "Lead_Sensitive_Population_1", "description": "", "codedValues": [ { "name": "Yes - School", "code": "Yes - School" }, { "name": "Yes - Day Care", "code": "Yes - Day Care" }, { "name": "Yes - Other", "code": "Yes - Other" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "disadvantaged", "type": "esriFieldTypeString", "alias": "131 Disadvantaged Neighborhood", "length": 255, "domain": null }, { "name": "otherfittings", "type": "esriFieldTypeString", "alias": "132Other Fittings Containing Lead", "length": 255, "domain": { "type": "codedValue", "name": "mde_Yes_No_DontKnow", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Don't Know", "code": "Don't Know" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "yearstructbuilt", "type": "esriFieldTypeSmallInteger", "alias": "200 Year Structure Built", "domain": null }, { "name": "everlead", "type": "esriFieldTypeString", "alias": "201 Ever Lead?", "length": 15, "domain": { "type": "codedValue", "name": "mde_Yes_No_DontKnow", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Don't Know", "code": "Don't Know" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_meter_lead", "type": "esriFieldTypeString", "alias": "202 MDE Service Line Meter Contain Lead?", "length": 255, "domain": { "type": "codedValue", "name": "mde_Yes_No_DontKnow", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Don't Know", "code": "Don't Know" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_util_diameter", "type": "esriFieldTypeString", "alias": "MDE Utility Side Diameter", "length": 255, "domain": { "type": "codedValue", "name": "mde_serviceline_Diameter", "description": "", "codedValues": [ { "name": "Don't Know or Unknown", "code": "Don't Know or Unknown" }, { "name": "Less than 1\"", "code": "Less than 1\"" }, { "name": "Greater than or equal to 1\", but less than 2\"", "code": "Greater than or equal to 1\", but less than 2\"" }, { "name": "Greater than or equal to 2\", but less than 3\"", "code": "Greater than or equal to 2\", but less than 3\"" }, { "name": "3\"", "code": "3\"" }, { "name": "Greater than 3\"", "code": "Greater than 3\"" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_util_diameter_determine", "type": "esriFieldTypeString", "alias": "MDE Utility Diameter Determination", "length": 255, "domain": { "type": "codedValue", "name": "mde_diameter_determination", "description": "", "codedValues": [ { "name": "1. Pipe diameter obtained directly from records AND Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)", "code": "1. Pipe diameter obtained directly from records AND Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)" }, { "name": "2. Pipe diameter obtained directly from ONLY Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)", "code": "2. Pipe diameter obtained directly from ONLY Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)" }, { "name": "3. Pipe diameter obtained directly from records AND Field Investigation via Non-Exposed Service line Pipe Inspection", "code": "3. Pipe diameter obtained directly from records AND Field Investigation via Non-Exposed Service line Pipe Inspection" }, { "name": "4. Pipe diameter obtained directly from ONLY Field Investigation via Non-Exposed Service line Pipe Inspection", "code": "4. Pipe diameter obtained directly from ONLY Field Investigation via Non-Exposed Service line Pipe Inspection" }, { "name": "5. Pipe diameter obtained directly from records ONLY", "code": "5. Pipe diameter obtained directly from records ONLY" }, { "name": "6. Other Basis of Diameter Determination pre-approved by MDE (Please provide details in \"Other Basis of Determination\")", "code": "6. Other Basis of Diameter Determination pre-approved by MDE (Please provide details in \"Other Basis of Determination\")" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_util_installdate", "type": "esriFieldTypeString", "alias": "MDE Utility Install Date", "length": 255, "domain": null }, { "name": "mde_util_1972", "type": "esriFieldTypeString", "alias": "MDE Utility Determination Prior to May 17 1972", "length": 255, "domain": { "type": "codedValue", "name": "mde_installation_date", "description": "", "codedValues": [ { "name": "Don't Know or Unknown", "code": "Don't Know or Unknown" }, { "name": "2024 and After", "code": "2024 and After" }, { "name": "1973 through 2023", "code": "1973 through 2023" }, { "name": "1972 (on or after May 17, i.e., 05/17/1972 - 12/31/1972)", "code": "1972 (on or after May 17, i.e., 05/17/1972 - 12/31/1972)" }, { "name": "1972 (before May 17, i.e., 01/01/1972 - 05/16/1972)", "code": "1972 (before May 17, i.e., 01/01/1972 - 05/16/1972)" }, { "name": "1972 (date and/or month unknown)", "code": "1972 (date and/or month unknown)" }, { "name": "1971 or Earlier", "code": "1971 or Earlier" }, { "name": "2023", "code": "2023" }, { "name": "2022", "code": "2022" }, { "name": "2021", "code": "2021" }, { "name": "2020", "code": "2020" }, { "name": "2019", "code": "2019" }, { "name": "2018", "code": "2018" }, { "name": "2017", "code": "2017" }, { "name": "2016", "code": "2016" }, { "name": "2015", "code": "2015" }, { "name": "2014", "code": "2014" }, { "name": "2013", "code": "2013" }, { "name": "2012", "code": "2012" }, { "name": "2011", "code": "2011" }, { "name": "2010", "code": "2010" }, { "name": "2009", "code": "2009" }, { "name": "2007", "code": "2008" }, { "name": "2006", "code": "2006" }, { "name": "2005", "code": "2005" }, { "name": "2004", "code": "2004" }, { "name": "2003", "code": "2003" }, { "name": "2002", "code": "2002" }, { "name": "2001", "code": "2001" }, { "name": "2000", "code": "2000" }, { "name": "1999", "code": "1999" }, { "name": "1998", "code": "1998" }, { "name": "1997", "code": "1997" }, { "name": "1996", "code": "1996" }, { "name": "1995", "code": "1995" }, { "name": "1994", "code": "1994" }, { "name": "1993", "code": "1993" }, { "name": "1992", "code": "1992" }, { "name": "1991", "code": "1991" }, { "name": "1990", "code": "1990" }, { "name": "1989", "code": "1989" }, { "name": "1988", "code": "1988" }, { "name": "1987", "code": "1987" }, { "name": "1986", "code": "1986" }, { "name": "1985", "code": "1985" }, { "name": "2024", "code": "2024" }, { "name": "2025", "code": "2025" }, { "name": "2026", "code": "2026" }, { "name": "2027", "code": "2027" }, { "name": "2028", "code": "2028" }, { "name": "2029", "code": "2029" }, { "name": "2030", "code": "2030" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "servicelineinstalldate", "type": "esriFieldTypeString", "alias": "Utility Install Date Notes", "length": 50, "domain": null }, { "name": "utilverifmethod", "type": "esriFieldTypeString", "alias": "Utility Verification Method", "length": 100, "domain": { "type": "codedValue", "name": "Lead__Verification_Method_1", "description": "", "codedValues": [ { "name": "Visual inspection at meter pit", "code": "Visual inspection at meter pit" }, { "name": "Customer self-identification", "code": "Customer self-identification" }, { "name": "CCTV Inspection at Curb Box - Internal", "code": "CCTV Inspection at Curb Box - Internal" }, { "name": "CCTV inspection at Curb Box - External", "code": "CCTV inspection at Curb Box - External" }, { "name": "Water Quality Sampling - Targeted", "code": "Water Quality Sampling - Targeted" }, { "name": "Water Quality Sampling - Flushed", "code": "Water Quality Sampling - Flushed" }, { "name": "Water Quality Sampling - Sequential", "code": "Water Quality Sampling - Sequential" }, { "name": "Water Quality Sampling - Other", "code": "Water Quality Sampling - Other" }, { "name": "Mechanical Excavation at 1 location", "code": "Mechanical Excavation at 1 location" }, { "name": "Mechanical Excavation at multiple locations", "code": "Mechanical Excavation at multiple locations" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "mde_util_vis_inspection", "type": "esriFieldTypeString", "alias": "MDE Utility Visual Inspection Method", "length": 255, "domain": { "type": "codedValue", "name": "mde_visual_inspection", "description": "", "codedValues": [ { "name": "ONLY 1 location visually inspected (WITHOUT excavation)", "code": "ONLY 1 location visually inspected (WITHOUT excavation)" }, { "name": "ONLY 1 location visually inspected (WITH excavation)", "code": "ONLY 1 location visually inspected (WITH excavation)" }, { "name": "Entire 2nd portion was unearthed and visually inspected", "code": "Entire 2nd portion was unearthed and visually inspected" }, { "name": "2 or more locations visually inspected (WITHOUT excavation at any of the locations)", "code": "2 or more locations visually inspected (WITHOUT excavation at any of the locations)" }, { "name": "2 or more locations visually inspected (WITH excavation at ONLY 1 of the locations)", "code": "2 or more locations visually inspected (WITH excavation at ONLY 1 of the locations)" }, { "name": "2 or more locations visually inspected (WITH excavation at 2 or more of the locations)", "code": "2 or more locations visually inspected (WITH excavation at 2 or more of the locations)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_cust_mat_verifi", "type": "esriFieldTypeString", "alias": "MDE Customer Material Verification", "length": 319, "domain": { "type": "codedValue", "name": "mde material verification", "description": "MDE verificaiton Method", "codedValues": [ { "name": "1. Pipe material obtained directly from records AND Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)", "code": "1. Pipe material obtained directly from records AND Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)" }, { "name": "2. Pipe material obtained directly from ONLY Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)", "code": "2. Pipe material obtained directly from ONLY Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)" }, { "name": "3. Pipe material obtained directly from records AND Field Investigation via Non-Exposed Service line Pipe Inspection", "code": "3. Pipe material obtained directly from records AND Field Investigation via Non-Exposed Service line Pipe Inspection" }, { "name": "4. Pipe material obtained directly from ONLY Field Investigation via Non-Exposed Service line Pipe Inspection", "code": "4. Pipe material obtained directly from ONLY Field Investigation via Non-Exposed Service line Pipe Inspection" }, { "name": "5. Pipe material obtained directly from records ONLY", "code": "5. Pipe material obtained directly from records ONLY" }, { "name": "6. Pipe material obtained directly from records ONLY (but Analytics/Predictive Method also performed to obtain a prediction -- Please provide the prediction under the \"Analytics/Predictive Method\" section even if prediction does not align with records)", "code": "6. Pipe material obtained directly from records ONLY (but Analytics/Predictive Method also performed to obtain a prediction -- Please provide the prediction under the \"Analytics/Predictive Method\" section even if prediction does not align with records)" }, { "name": "7. Pipe material determined to be Non-Lead based on pipe diameter greater than 3 inches (-- Applicable only for \"Non-Lead (but specific type not known)\" pipe material)", "code": "7. Pipe material determined to be Non-Lead based on pipe diameter greater than 3 inches (-- Applicable only for \"Non-Lead (but specific type not known)\" pipe material)" }, { "name": "8. Pipe material determined to be Non-Lead based on pipe installation date on or after May 17, 1972 (Maryland's regulations pertaining to acceptable service line materials) (-- Applicable only for \"Non-Lead (but specific type not known)\" pipe material)", "code": "8. Pipe material determined to be Non-Lead based on pipe installation date on or after May 17, 1972 (Maryland's regulations pertaining to acceptable service line materials) (-- Applicable only for \"Non-Lead (but specific type not known)\" pipe material)" }, { "name": "9. Pipe material determined to be Non-Lead or Non-Lead Non-Galvanized based on pipe installation date on or after local ordinance that was in effect prior to May 17, 1972 (-- Applicable only for \"Non-Lead (but specific type not known)\" or \"Non-Lead Non-G", "code": "9. Pipe material determined to be Non-Lead or Non-Lead Non-Galvanized based on pipe installation date on or after local ordinance that was in effect prior to May 17, 1972 (-- Applicable only for \"Non-Lead (but specific type not known)\" or \"Non-Lead Non-Galvanized (but specific type not known)\" pipe material)" }, { "name": "10. Prediction of material from Analytics/Predictive Method ONLY (i.e., no records or field investigations)", "code": "10. Prediction of material from Analytics/Predictive Method ONLY (i.e., no records or field investigations)" }, { "name": "11. Other Basis of Material Determination pre-approved by MDE (Please provide details in \"Other Basis of Determination\")", "code": "11. Other Basis of Material Determination pre-approved by MDE (Please provide details in \"Other Basis of Determination\")" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "mde_cust_diameter_determine", "type": "esriFieldTypeString", "alias": "MDE Customer Diameter Determination", "length": 255, "domain": { "type": "codedValue", "name": "mde_diameter_determination", "description": "", "codedValues": [ { "name": "1. Pipe diameter obtained directly from records AND Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)", "code": "1. Pipe diameter obtained directly from records AND Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)" }, { "name": "2. Pipe diameter obtained directly from ONLY Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)", "code": "2. Pipe diameter obtained directly from ONLY Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)" }, { "name": "3. Pipe diameter obtained directly from records AND Field Investigation via Non-Exposed Service line Pipe Inspection", "code": "3. Pipe diameter obtained directly from records AND Field Investigation via Non-Exposed Service line Pipe Inspection" }, { "name": "4. Pipe diameter obtained directly from ONLY Field Investigation via Non-Exposed Service line Pipe Inspection", "code": "4. Pipe diameter obtained directly from ONLY Field Investigation via Non-Exposed Service line Pipe Inspection" }, { "name": "5. Pipe diameter obtained directly from records ONLY", "code": "5. Pipe diameter obtained directly from records ONLY" }, { "name": "6. Other Basis of Diameter Determination pre-approved by MDE (Please provide details in \"Other Basis of Determination\")", "code": "6. Other Basis of Diameter Determination pre-approved by MDE (Please provide details in \"Other Basis of Determination\")" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "mde_cust_1972", "type": "esriFieldTypeString", "alias": "MDE Customer Size Beofore 1972", "length": 255, "domain": { "type": "codedValue", "name": "mde_installation_date", "description": "", "codedValues": [ { "name": "Don't Know or Unknown", "code": "Don't Know or Unknown" }, { "name": "2024 and After", "code": "2024 and After" }, { "name": "1973 through 2023", "code": "1973 through 2023" }, { "name": "1972 (on or after May 17, i.e., 05/17/1972 - 12/31/1972)", "code": "1972 (on or after May 17, i.e., 05/17/1972 - 12/31/1972)" }, { "name": "1972 (before May 17, i.e., 01/01/1972 - 05/16/1972)", "code": "1972 (before May 17, i.e., 01/01/1972 - 05/16/1972)" }, { "name": "1972 (date and/or month unknown)", "code": "1972 (date and/or month unknown)" }, { "name": "1971 or Earlier", "code": "1971 or Earlier" }, { "name": "2023", "code": "2023" }, { "name": "2022", "code": "2022" }, { "name": "2021", "code": "2021" }, { "name": "2020", "code": "2020" }, { "name": "2019", "code": "2019" }, { "name": "2018", "code": "2018" }, { "name": "2017", "code": "2017" }, { "name": "2016", "code": "2016" }, { "name": "2015", "code": "2015" }, { "name": "2014", "code": "2014" }, { "name": "2013", "code": "2013" }, { "name": "2012", "code": "2012" }, { "name": "2011", "code": "2011" }, { "name": "2010", "code": "2010" }, { "name": "2009", "code": "2009" }, { "name": "2007", "code": "2008" }, { "name": "2006", "code": "2006" }, { "name": "2005", "code": "2005" }, { "name": "2004", "code": "2004" }, { "name": "2003", "code": "2003" }, { "name": "2002", "code": "2002" }, { "name": "2001", "code": "2001" }, { "name": "2000", "code": "2000" }, { "name": "1999", "code": "1999" }, { "name": "1998", "code": "1998" }, { "name": "1997", "code": "1997" }, { "name": "1996", "code": "1996" }, { "name": "1995", "code": "1995" }, { "name": "1994", "code": "1994" }, { "name": "1993", "code": "1993" }, { "name": "1992", "code": "1992" }, { "name": "1991", "code": "1991" }, { "name": "1990", "code": "1990" }, { "name": "1989", "code": "1989" }, { "name": "1988", "code": "1988" }, { "name": "1987", "code": "1987" }, { "name": "1986", "code": "1986" }, { "name": "1985", "code": "1985" }, { "name": "2024", "code": "2024" }, { "name": "2025", "code": "2025" }, { "name": "2026", "code": "2026" }, { "name": "2027", "code": "2027" }, { "name": "2028", "code": "2028" }, { "name": "2029", "code": "2029" }, { "name": "2030", "code": "2030" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "buildingtype", "type": "esriFieldTypeString", "alias": "Building Type", "length": 255, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "name": "util_sl_segments", "type": "esriFieldTypeString", "alias": "020 Utility Segments", "length": 50, "domain": { "type": "codedValue", "name": "cvd_mde_connector_segment", "description": "number of segments", "codedValues": [ { "name": "1", "code": "1" }, { "name": "More than 1", "code": "More than 1" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "cust_sl_segments", "type": "esriFieldTypeString", "alias": "022 Customer Segments", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_connector_segment", "description": "number of segments", "codedValues": [ { "name": "1", "code": "1" }, { "name": "More than 1", "code": "More than 1" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "util_connector_past", "type": "esriFieldTypeString", "alias": "400 util_connector_past", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_connector", "description": "MDE connector segments", "codedValues": [ { "name": "Yes - The LEAD connector has been either permanently removed OR replaced with a Non-Lead connector (i.e., the CURRENT connector) since the most recent submittal of the inventory spreadsheet.", "code": "Yes - The LEAD connector has been either permanently removed OR replaced with a Non-Lead connector (i.e., the CURRENT connector) since the most recent submittal of the inventory spreadsheet." } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "util_connector_leadlenght", "type": "esriFieldTypeString", "alias": "401 util_connector_leadlenght", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_connector_lenght", "description": "MDE Connector Lenght", "codedValues": [ { "name": "Length Not Applicable - Connector NOT Lead", "code": "NA- Connector NOT Lead" }, { "name": "Length Not Applicable - No Connector Present", "code": "NA- No Connector Present " }, { "name": "Connector material (and/or presence of connector) unknown", "code": "Connector material (and/or presence of connector) unknown" }, { "name": "Lead connector -- Less than 1 ft (12 in)", "code": "Lead connector -- Less than 1 ft (12 in)" }, { "name": "Lead connector -- Equal to 1 ft (12 in)", "code": "Lead connector -- Equal to 1 ft (12 in)" }, { "name": "Lead connector -- Greater than 1 ft (12 in), but less than 1.5 ft (18 in)", "code": "Lead connector -- Greater than 1 ft (12 in), but less than 1.5 ft (18 in)" }, { "name": "Lead connector -- Equal to 1.5 ft (18 in)", "code": "Lead connector -- Equal to 1.5 ft (18 in)" }, { "name": "Lead connector -- Greater than 1.5 ft (18 in), but less than 2 ft (24 in)", "code": "Lead connector -- Greater than 1.5 ft (18 in), but less than 2 ft (24 in)" }, { "name": "Lead connector -- Equal to 2 ft (24 in)", "code": "Lead connector -- Equal to 2 ft (24 in)" }, { "name": "Lead connector -- Greater than 2 ft (24 in), but less than 2.5 ft (30 in)", "code": "Lead connector -- Greater than 2 ft (24 in), but less than 2.5 ft (30 in)" }, { "name": "Lead connector -- Equal to 2.5 ft (30 in)", "code": "Lead connector -- Equal to 2.5 ft (30 in)" }, { "name": "Lead connector -- Greater than 2.5 ft (30 in), but less than 3 ft (36 in)", "code": "Lead connector -- Greater than 2.5 ft (30 in), but less than 3 ft (36 in)" }, { "name": "Lead connector -- Equal to 3 ft (36 in)", "code": "Lead connector -- Equal to 3 ft (36 in)" }, { "name": "Lead connector -- Greater than 3 ft (36 in), but less than 3.5 ft (42 in)", "code": "Lead connector -- Greater than 3 ft (36 in), but less than 3.5 ft (42 in)" }, { "name": "Lead connector -- Equal to 3.5 ft (42 in)", "code": "Lead connector -- Equal to 3.5 ft (42 in)" }, { "name": "Lead connector -- Greater than 3.5 ft (42 in), but less than 4 ft (48 in)Lead connector -- Equal to 4 ft (48 in)", "code": "Lead connector -- Greater than 3.5 ft (42 in), but less than 4 ft (48 in)" }, { "name": "Lead connector -- Equal to 4 ft (48 in)", "code": "Lead connector -- Equal to 4 ft (48 in)" }, { "name": "Lead connector -- Greater than 4 ft (48 in)", "code": "Lead connector -- Greater than 4 ft (48 in)" }, { "name": "Lead connector -- Length unknown", "code": "Lead connector -- Length unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "util_connector_material", "type": "esriFieldTypeString", "alias": "402 util_connector_material", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_connector_previous", "description": "MDE Connector Previously", "codedValues": [ { "name": "Length of previous Lead connector was less than length in EPA's connector definition", "code": "Length of previous Lead connector was less than length in EPA's connector definition" }, { "name": "Length of previous Lead connector was equal to length in EPA's connector definition", "code": "Length of previous Lead connector was equal to length in EPA's connector definition" }, { "name": "Length of previous Lead connector was greater than length in EPA's connector definition", "code": "Length of previous Lead connector was greater than length in EPA's connector definition" }, { "name": "Length of previous Lead connector was not known", "code": "Length of previous Lead connector was not known" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "cust_connector_past", "type": "esriFieldTypeString", "alias": "403 Customer Connector Lead in Past", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_connector", "description": "MDE connector segments", "codedValues": [ { "name": "Yes - The LEAD connector has been either permanently removed OR replaced with a Non-Lead connector (i.e., the CURRENT connector) since the most recent submittal of the inventory spreadsheet.", "code": "Yes - The LEAD connector has been either permanently removed OR replaced with a Non-Lead connector (i.e., the CURRENT connector) since the most recent submittal of the inventory spreadsheet." } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "cust_connector_leadlenght", "type": "esriFieldTypeString", "alias": "404 Customer Connector Lenght", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_connector_lenght", "description": "MDE Connector Lenght", "codedValues": [ { "name": "Length Not Applicable - Connector NOT Lead", "code": "NA- Connector NOT Lead" }, { "name": "Length Not Applicable - No Connector Present", "code": "NA- No Connector Present " }, { "name": "Connector material (and/or presence of connector) unknown", "code": "Connector material (and/or presence of connector) unknown" }, { "name": "Lead connector -- Less than 1 ft (12 in)", "code": "Lead connector -- Less than 1 ft (12 in)" }, { "name": "Lead connector -- Equal to 1 ft (12 in)", "code": "Lead connector -- Equal to 1 ft (12 in)" }, { "name": "Lead connector -- Greater than 1 ft (12 in), but less than 1.5 ft (18 in)", "code": "Lead connector -- Greater than 1 ft (12 in), but less than 1.5 ft (18 in)" }, { "name": "Lead connector -- Equal to 1.5 ft (18 in)", "code": "Lead connector -- Equal to 1.5 ft (18 in)" }, { "name": "Lead connector -- Greater than 1.5 ft (18 in), but less than 2 ft (24 in)", "code": "Lead connector -- Greater than 1.5 ft (18 in), but less than 2 ft (24 in)" }, { "name": "Lead connector -- Equal to 2 ft (24 in)", "code": "Lead connector -- Equal to 2 ft (24 in)" }, { "name": "Lead connector -- Greater than 2 ft (24 in), but less than 2.5 ft (30 in)", "code": "Lead connector -- Greater than 2 ft (24 in), but less than 2.5 ft (30 in)" }, { "name": "Lead connector -- Equal to 2.5 ft (30 in)", "code": "Lead connector -- Equal to 2.5 ft (30 in)" }, { "name": "Lead connector -- Greater than 2.5 ft (30 in), but less than 3 ft (36 in)", "code": "Lead connector -- Greater than 2.5 ft (30 in), but less than 3 ft (36 in)" }, { "name": "Lead connector -- Equal to 3 ft (36 in)", "code": "Lead connector -- Equal to 3 ft (36 in)" }, { "name": "Lead connector -- Greater than 3 ft (36 in), but less than 3.5 ft (42 in)", "code": "Lead connector -- Greater than 3 ft (36 in), but less than 3.5 ft (42 in)" }, { "name": "Lead connector -- Equal to 3.5 ft (42 in)", "code": "Lead connector -- Equal to 3.5 ft (42 in)" }, { "name": "Lead connector -- Greater than 3.5 ft (42 in), but less than 4 ft (48 in)Lead connector -- Equal to 4 ft (48 in)", "code": "Lead connector -- Greater than 3.5 ft (42 in), but less than 4 ft (48 in)" }, { "name": "Lead connector -- Equal to 4 ft (48 in)", "code": "Lead connector -- Equal to 4 ft (48 in)" }, { "name": "Lead connector -- Greater than 4 ft (48 in)", "code": "Lead connector -- Greater than 4 ft (48 in)" }, { "name": "Lead connector -- Length unknown", "code": "Lead connector -- Length unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "cust_connector_material", "type": "esriFieldTypeString", "alias": "404 Customer Connector Matieral", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_connector_previous", "description": "MDE Connector Previously", "codedValues": [ { "name": "Length of previous Lead connector was less than length in EPA's connector definition", "code": "Length of previous Lead connector was less than length in EPA's connector definition" }, { "name": "Length of previous Lead connector was equal to length in EPA's connector definition", "code": "Length of previous Lead connector was equal to length in EPA's connector definition" }, { "name": "Length of previous Lead connector was greater than length in EPA's connector definition", "code": "Length of previous Lead connector was greater than length in EPA's connector definition" }, { "name": "Length of previous Lead connector was not known", "code": "Length of previous Lead connector was not known" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "util_connector_past1", "type": "esriFieldTypeString", "alias": "410 Utility 1A Connector Replaced?", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_connector", "description": "MDE connector segments", "codedValues": [ { "name": "Yes - The LEAD connector has been either permanently removed OR replaced with a Non-Lead connector (i.e., the CURRENT connector) since the most recent submittal of the inventory spreadsheet.", "code": "Yes - The LEAD connector has been either permanently removed OR replaced with a Non-Lead connector (i.e., the CURRENT connector) since the most recent submittal of the inventory spreadsheet." } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "util_connector_leadlenght1", "type": "esriFieldTypeString", "alias": "411 Utility 1A Connector Lenght if Lead", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_connector_lenght", "description": "MDE Connector Lenght", "codedValues": [ { "name": "Length Not Applicable - Connector NOT Lead", "code": "NA- Connector NOT Lead" }, { "name": "Length Not Applicable - No Connector Present", "code": "NA- No Connector Present " }, { "name": "Connector material (and/or presence of connector) unknown", "code": "Connector material (and/or presence of connector) unknown" }, { "name": "Lead connector -- Less than 1 ft (12 in)", "code": "Lead connector -- Less than 1 ft (12 in)" }, { "name": "Lead connector -- Equal to 1 ft (12 in)", "code": "Lead connector -- Equal to 1 ft (12 in)" }, { "name": "Lead connector -- Greater than 1 ft (12 in), but less than 1.5 ft (18 in)", "code": "Lead connector -- Greater than 1 ft (12 in), but less than 1.5 ft (18 in)" }, { "name": "Lead connector -- Equal to 1.5 ft (18 in)", "code": "Lead connector -- Equal to 1.5 ft (18 in)" }, { "name": "Lead connector -- Greater than 1.5 ft (18 in), but less than 2 ft (24 in)", "code": "Lead connector -- Greater than 1.5 ft (18 in), but less than 2 ft (24 in)" }, { "name": "Lead connector -- Equal to 2 ft (24 in)", "code": "Lead connector -- Equal to 2 ft (24 in)" }, { "name": "Lead connector -- Greater than 2 ft (24 in), but less than 2.5 ft (30 in)", "code": "Lead connector -- Greater than 2 ft (24 in), but less than 2.5 ft (30 in)" }, { "name": "Lead connector -- Equal to 2.5 ft (30 in)", "code": "Lead connector -- Equal to 2.5 ft (30 in)" }, { "name": "Lead connector -- Greater than 2.5 ft (30 in), but less than 3 ft (36 in)", "code": "Lead connector -- Greater than 2.5 ft (30 in), but less than 3 ft (36 in)" }, { "name": "Lead connector -- Equal to 3 ft (36 in)", "code": "Lead connector -- Equal to 3 ft (36 in)" }, { "name": "Lead connector -- Greater than 3 ft (36 in), but less than 3.5 ft (42 in)", "code": "Lead connector -- Greater than 3 ft (36 in), but less than 3.5 ft (42 in)" }, { "name": "Lead connector -- Equal to 3.5 ft (42 in)", "code": "Lead connector -- Equal to 3.5 ft (42 in)" }, { "name": "Lead connector -- Greater than 3.5 ft (42 in), but less than 4 ft (48 in)Lead connector -- Equal to 4 ft (48 in)", "code": "Lead connector -- Greater than 3.5 ft (42 in), but less than 4 ft (48 in)" }, { "name": "Lead connector -- Equal to 4 ft (48 in)", "code": "Lead connector -- Equal to 4 ft (48 in)" }, { "name": "Lead connector -- Greater than 4 ft (48 in)", "code": "Lead connector -- Greater than 4 ft (48 in)" }, { "name": "Lead connector -- Length unknown", "code": "Lead connector -- Length unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "util_connector_material1", "type": "esriFieldTypeString", "alias": "412 Utilty 1A Connector Material", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_connector_previous", "description": "MDE Connector Previously", "codedValues": [ { "name": "Length of previous Lead connector was less than length in EPA's connector definition", "code": "Length of previous Lead connector was less than length in EPA's connector definition" }, { "name": "Length of previous Lead connector was equal to length in EPA's connector definition", "code": "Length of previous Lead connector was equal to length in EPA's connector definition" }, { "name": "Length of previous Lead connector was greater than length in EPA's connector definition", "code": "Length of previous Lead connector was greater than length in EPA's connector definition" }, { "name": "Length of previous Lead connector was not known", "code": "Length of previous Lead connector was not known" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "cust_connector_past1", "type": "esriFieldTypeString", "alias": "413 Customer 2A Connector Replaced?", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_connector", "description": "MDE connector segments", "codedValues": [ { "name": "Yes - The LEAD connector has been either permanently removed OR replaced with a Non-Lead connector (i.e., the CURRENT connector) since the most recent submittal of the inventory spreadsheet.", "code": "Yes - The LEAD connector has been either permanently removed OR replaced with a Non-Lead connector (i.e., the CURRENT connector) since the most recent submittal of the inventory spreadsheet." } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "cust_connector_leadlenght1", "type": "esriFieldTypeString", "alias": "414 Connector 2A Connector Replaced?", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_connector_lenght", "description": "MDE Connector Lenght", "codedValues": [ { "name": "Length Not Applicable - Connector NOT Lead", "code": "NA- Connector NOT Lead" }, { "name": "Length Not Applicable - No Connector Present", "code": "NA- No Connector Present " }, { "name": "Connector material (and/or presence of connector) unknown", "code": "Connector material (and/or presence of connector) unknown" }, { "name": "Lead connector -- Less than 1 ft (12 in)", "code": "Lead connector -- Less than 1 ft (12 in)" }, { "name": "Lead connector -- Equal to 1 ft (12 in)", "code": "Lead connector -- Equal to 1 ft (12 in)" }, { "name": "Lead connector -- Greater than 1 ft (12 in), but less than 1.5 ft (18 in)", "code": "Lead connector -- Greater than 1 ft (12 in), but less than 1.5 ft (18 in)" }, { "name": "Lead connector -- Equal to 1.5 ft (18 in)", "code": "Lead connector -- Equal to 1.5 ft (18 in)" }, { "name": "Lead connector -- Greater than 1.5 ft (18 in), but less than 2 ft (24 in)", "code": "Lead connector -- Greater than 1.5 ft (18 in), but less than 2 ft (24 in)" }, { "name": "Lead connector -- Equal to 2 ft (24 in)", "code": "Lead connector -- Equal to 2 ft (24 in)" }, { "name": "Lead connector -- Greater than 2 ft (24 in), but less than 2.5 ft (30 in)", "code": "Lead connector -- Greater than 2 ft (24 in), but less than 2.5 ft (30 in)" }, { "name": "Lead connector -- Equal to 2.5 ft (30 in)", "code": "Lead connector -- Equal to 2.5 ft (30 in)" }, { "name": "Lead connector -- Greater than 2.5 ft (30 in), but less than 3 ft (36 in)", "code": "Lead connector -- Greater than 2.5 ft (30 in), but less than 3 ft (36 in)" }, { "name": "Lead connector -- Equal to 3 ft (36 in)", "code": "Lead connector -- Equal to 3 ft (36 in)" }, { "name": "Lead connector -- Greater than 3 ft (36 in), but less than 3.5 ft (42 in)", "code": "Lead connector -- Greater than 3 ft (36 in), but less than 3.5 ft (42 in)" }, { "name": "Lead connector -- Equal to 3.5 ft (42 in)", "code": "Lead connector -- Equal to 3.5 ft (42 in)" }, { "name": "Lead connector -- Greater than 3.5 ft (42 in), but less than 4 ft (48 in)Lead connector -- Equal to 4 ft (48 in)", "code": "Lead connector -- Greater than 3.5 ft (42 in), but less than 4 ft (48 in)" }, { "name": "Lead connector -- Equal to 4 ft (48 in)", "code": "Lead connector -- Equal to 4 ft (48 in)" }, { "name": "Lead connector -- Greater than 4 ft (48 in)", "code": "Lead connector -- Greater than 4 ft (48 in)" }, { "name": "Lead connector -- Length unknown", "code": "Lead connector -- Length unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "cust_connector_material1", "type": "esriFieldTypeString", "alias": "415 Connector 2A Connector Lenght if Lead", "length": 255, "domain": { "type": "codedValue", "name": "cvd_mde_connector_previous", "description": "MDE Connector Previously", "codedValues": [ { "name": "Length of previous Lead connector was less than length in EPA's connector definition", "code": "Length of previous Lead connector was less than length in EPA's connector definition" }, { "name": "Length of previous Lead connector was equal to length in EPA's connector definition", "code": "Length of previous Lead connector was equal to length in EPA's connector definition" }, { "name": "Length of previous Lead connector was greater than length in EPA's connector definition", "code": "Length of previous Lead connector was greater than length in EPA's connector definition" }, { "name": "Length of previous Lead connector was not known", "code": "Length of previous Lead connector was not known" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "user_txtcustomername", "type": "esriFieldTypeString", "alias": "901 Customer Name", "length": 255, "domain": null }, { "name": "user_customermailingaddress", "type": "esriFieldTypeString", "alias": "902 Mailing Address Street", "length": 255, "domain": null }, { "name": "user_customermailingcity", "type": "esriFieldTypeString", "alias": "903 Mailing City", "length": 255, "domain": null }, { "name": "user_customermailstate", "type": "esriFieldTypeString", "alias": "904 Mailing State", "length": 255, "domain": null }, { "name": "user_customermailzip", "type": "esriFieldTypeString", "alias": "905 Mailing Zip", "length": 255, "domain": null }, { "name": "user_txtcustomeraddress", "type": "esriFieldTypeString", "alias": "906 Mailing Address Full", "length": 255, "domain": null }, { "name": "user_customerhomephone", "type": "esriFieldTypeString", "alias": "907 Customer Phone", "length": 255, "domain": null }, { "name": "user_occupname", "type": "esriFieldTypeString", "alias": "908 Occupant Name", "length": 255, "domain": null }, { "name": "user_occuphomephone", "type": "esriFieldTypeString", "alias": "909 Occupant Phone", "length": 255, "domain": null }, { "name": "gis_GISDBADMIN_DPU_W_LeadServic", "type": "esriFieldTypeString", "alias": "gis_GISDBADMIN_DPU_W_LeadServic", "length": 512, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R331_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_331", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S242_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "hasZ": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "376b3b4f58f244289e788fd55ea265ed" } ], "tables": [] }