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