Layers:

Layer: DPU Public Viewer (905041)

Name: DPU Public Viewer

Display Field: county

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 376b3b4f58f244289e788fd55ea265ed

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 612192.3510933071
YMin: 590023.4373306483
XMax: 728371.0718193948
YMax: 747389.9989092201
Spatial Reference: 102685  (2248)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: N/A
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [255, 255, 255, 255]
Size: 12.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Default Label: Other
UniqueValueInfos:
• Value: Lead
  Label: Lead
  Description: N/A
  Symbol:
  
• Value: Assumed Lead
  Label: Assumed Lead
  Description: N/A
  Symbol:
  
• Value: Galvanized Requiring Replacement
  Label: Galvanized Requiring Replacement
  Description: N/A
  Symbol:
  
• Value: Non-Lead
  Label: Non-Lead
  Description: N/A
  Symbol:
  
• Value: Unknown
  Label: Unknown
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: true

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: 00 OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: 01 GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: 02 created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: 03 created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: 04 last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: 05 last_edited_date, length: 8 )
• county ( type: esriFieldTypeString, alias: 06 County, length: 255 )
• system ( type: esriFieldTypeString, alias: 07 System, length: 50 , Coded Values: [0: Unknown] , [7: Hutton] , [8: Mountain Lake Park] , ...17 more... )
• pwsid ( type: esriFieldTypeString, alias: 08 PWSID, length: 255 , Coded Values: [Carmel Cove: MD1111144] , [Cherry Hill Asssisted Living: MD1110025] , [Deep Creek Lake (Day Use): MD1111020] , ...25 more... )
• mde_pws_type ( type: esriFieldTypeString, alias: 09 mde_pws_type, length: 255 , Coded Values: [Community (C): Community (C)] , [Transient (T): Transient (T)] , [Non-Transient Non-Community (NTNC) : Non-Transient Non-Community (NTNC)] )
• utacm_account ( type: esriFieldTypeInteger, alias: 10 County Utility Account )
• service_account ( type: esriFieldTypeString, alias: 11 Account Number, length: 255 )
• service_address ( type: esriFieldTypeString, alias: 12 Address, length: 255 )
• location_id ( type: esriFieldTypeString, alias: 13 Other Location Identifier, length: 255 )
• latitude ( type: esriFieldTypeDouble, alias: 14 Latitude )
• longitude ( type: esriFieldTypeDouble, alias: 15 Longitude )
• mde_building_type ( type: esriFieldTypeString, alias: 16 Connection Type, length: 255 , Coded Values: [Residential (Single-Family): Residential (Single-Family)] , [Residential (Multi-Family): Residential (Multi-Family)] , [Residential (School Dormitory): Residential (School Dormitory)] , ...17 more... )
• identifier_type ( type: esriFieldTypeString, alias: 17 Identifier, length: 255 , Coded Values: [Street Address: Street Address] , [Lot/Block: Lot/Block] , [Intersection: Intersection] , ...5 more... )
• zipcode ( type: esriFieldTypeInteger, alias: 18 ZIP Code )
• mde_entire_sl_senario ( type: esriFieldTypeString, alias: 19 Entire Service Line Senario, length: 255 , Coded Values: [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): 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)] , [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): 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)] , [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): 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)] , ...1 more... )
• ownership_1 ( type: esriFieldTypeString, alias: 20 Ownership 1st Portion - Utility, length: 255 , Coded Values: [System: System] , [Customer: Customer] , [Shared by both System and Customer: Shared by both System and Customer] )
• ownership_2 ( type: esriFieldTypeString, alias: 21 Ownership 2nd Portion - Customer, length: 255 , Coded Values: [System: System] , [Customer: Customer] , [Shared by both System and Customer: Shared by both System and Customer] )
• active_1 ( type: esriFieldTypeString, alias: 22 Activity Status Utility 1, length: 255 , Coded Values: [Currently Active: Currently Active] , [Currently Inactive: Currently Inactive] , [Don't Know: Don't Know] )
• active_2 ( type: esriFieldTypeString, alias: 23 Activity Status Customer 2, length: 255 , Coded Values: [Currently Active: Currently Active] , [Currently Inactive: Currently Inactive] , [Don't Know: Don't Know] )
• sl_comments ( type: esriFieldTypeString, alias: 24 Overall service line comments, length: 500 )
• pointofentry ( type: esriFieldTypeString, alias: 25 Point-of-Entry Treatment, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [Don't Know: Don't Know] )
• mde_pointofusefaucet ( type: esriFieldTypeString, alias: 26 Treatment at Point of Use?, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [Don't Know: Don't Know] )
• mde_interior_lead_pipes ( type: esriFieldTypeString, alias: 27 Lead pipes in Building?, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [Don't Know: Don't Know] )
• copperwithlead ( type: esriFieldTypeString, alias: 28 Copper Pipes with Lead Solder Before Lead Ban, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [Don't Know: Don't Know] )
• year_built ( type: esriFieldTypeString, alias: 29 Year Building Constructed, length: 255 )
• year_source ( type: esriFieldTypeString, alias: 30 Building Construction Info Source, length: 255 )
• year_original_plumming ( type: esriFieldTypeString, alias: 31 Year of ORIGINAL plumbing material installed in building, length: 255 , Coded Values: [Don't Know or Unknown: Don't Know or Unknown] , [2024 and After: 2024 and After] , [1973 through 2023: 1973 through 2023] , ...49 more... )
• samplingsite ( type: esriFieldTypeString, alias: 32 LCR, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [Don't Know: Don't Know] )
• mde_lcr_tier_ntncws ( type: esriFieldTypeString, alias: 33 LCR NTCWS Tier, length: 255 , Coded Values: [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: 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] , [Tier 2 = Building that Contains Copper Pipes with Lead Solder Installed Before 1983: Tier 2 = Building that Contains Copper Pipes with Lead Solder Installed Before 1983] )
• mde_lcr_tier_community ( type: esriFieldTypeString, alias: 34 LCR Community Tier, length: 255 , Coded Values: [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: 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] , [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: 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] , [Tier 3 = Single-Family Structure that Contains Copper Pipes with Lead Solder Installed Before 1983: Tier 3 = Single-Family Structure that Contains Copper Pipes with Lead Solder Installed Before 1983] , ...1 more... )
• building_comments ( type: esriFieldTypeString, alias: 35 Building related comments, length: 255 )
• sl_material ( type: esriFieldTypeString, alias: 36 Material of water main, length: 255 , Coded Values: [DIP - Ductile Iron Pipe: DIP - Ductile Iron Pipe] , [CIP - Cast Iron Pipe: CIP - Cast Iron Pipe] , [Iron Pipe (specific type unknown): Iron Pipe (specific type unknown)] , ...14 more... )
• sl_valve_pb ( type: esriFieldTypeString, alias: 40 Does the valve connecting the water main to the service line contain more than 8% lead ?, length: 255 , Coded Values: [Yes - Valve currently contains more than 8% Lead: Yes - Valve currently contains more than 8% Lead] , [No: No] , [Don't Know: Don't Know] , ...1 more... )
• utilassetid ( type: esriFieldTypeString, alias: 41 Utility Asset ID, length: 255 )
• utilsource ( type: esriFieldTypeString, alias: 42 Utility Source, length: 255 , Coded Values: [Installation record (e.g., tap card): Installation record (e.g., tap card)] , [Water sampling only with no records: Water sampling only with no records] , [Field inspection only with no records: Field inspection only with no records] , ...6 more... )
• utilmaterial ( type: esriFieldTypeString, alias: 43 Utility Material, length: 255 , Coded Values: [Don't Know or Unknown: Don't Know or Unknown] , [Likely Lead (prediction with no threshold set - considered as unknown): Likely Lead (prediction with no threshold set - considered as unknown)Lead] , [Likely Non-Lead (prediction with no threshold set - considered as unknown): Likely Non-Lead (prediction with no threshold set - considered as unknown)] , ...16 more... )
• utildiameter ( type: esriFieldTypeString, alias: 44 Utility Diameter, length: 255 , Coded Values: [0.5: 1/2"] , [0.75: 3/4"] , [1: 1"] , ...12 more... )
• utilinstalldate ( type: esriFieldTypeString, alias: 45 Utility Install Date, length: 255 )
• mde_line_replaced1 ( type: esriFieldTypeString, alias: 46 Is the CURRENT service line pipe (1st Portion) a replacement of the previous service line reported in the water system's most recent submittal of the inventory spreadsheet?, length: 255 , Coded Values: [Yes - This CURRENT service line is the replacement of the previous service line: Yes - This CURRENT service line is the replacement of the previous service line] )
• mde_pipe_material1 ( type: esriFieldTypeString, alias: 47 MATERIAL of CURRENT service line pipe -- Utility 1st portion of service line, length: 255 , Coded Values: [Don't Know or Unknown: Don't Know or Unknown] , [Likely Lead (prediction with no threshold set - considered as unknown): Likely Lead (prediction with no threshold set - considered as unknown)Lead] , [Likely Non-Lead (prediction with no threshold set - considered as unknown): Likely Non-Lead (prediction with no threshold set - considered as unknown)] , ...16 more... )
• mde_material_source1 ( type: esriFieldTypeString, alias: 48 Basis of MATERIAL Determination of the Current Service Line Pipe -- Utility 1st portion of service line, length: 500 , Coded Values: [1. Pipe material obtained directly from records AND Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation): 1. Pipe material obtained directly from records AND Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)] , [2. Pipe material obtained directly from ONLY Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation): 2. Pipe material obtained directly from ONLY Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)] , [3. Pipe material obtained directly from records AND Field Investigation via Non-Exposed Service line Pipe Inspection: 3. Pipe material obtained directly from records AND Field Investigation via Non-Exposed Service line Pipe Inspection] , ...7 more... )
• mde_past_lead1 ( type: esriFieldTypeString, alias: 49 Was Utility 1st portion of service line pipe ever lead in the past?, length: 255 , Coded Values: [Yes - Lead in the Past: Yes - Lead in the Past] , [No - Never lead confirmed through documented records: No - Never lead confirmed through documented records] , [Don't Know: Don't Know] , ...2 more... )
• mde_past_lead1_method ( type: esriFieldTypeString, alias: 50 If water system is able to confirm whether or not the Utility 1st portion of the service line was Lead in the past, please provide description of method used, length: 255 )
• mde_pipe_diameter1 ( type: esriFieldTypeString, alias: 51 DIAMETER* of CURRENT service line pipe --Utility 1st portion of service, length: 255 , Coded Values: [Don't Know or Unknown': Don't Know or Unknown] , [Less than 1': Less than 1"] , [Greater than or equal to 1", but less than 2: Greater than or equal to 1", but less than 2"] , ...2 more... )
• mde_pipe_diameter1_source ( type: esriFieldTypeString, alias: 52 Basis of DIAMETER Determination of the Curent Service Line Pipe -- Utility 1st portion of service line, length: 255 , Coded Values: [1. Pipe diameter obtained directly from records AND Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation): 1. Pipe diameter obtained directly from records AND Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)] , [2. Pipe diameter obtained directly from ONLY Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation): 2. Pipe diameter obtained directly from ONLY Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)] , [3. Pipe diameter obtained directly from records AND Field Investigation via Non-Exposed Service line Pipe Inspection: 3. Pipe diameter obtained directly from records AND Field Investigation via Non-Exposed Service line Pipe Inspection] , ...3 more... )
• mde_pipe_install1 ( type: esriFieldTypeString, alias: 53 INSTALLATION YEAR* of CURRENT service line pipe --Utility 1st portion of service line, length: 255 , Coded Values: [Don't Know or Unknown: Don't Know or Unknown] , [2024 and After: 2024 and After] , [1973 through 2023: 1973 through 2023] , ...49 more... )
• mde_pipe_install1_source ( type: esriFieldTypeString, alias: 54 If Installation year of the 1st portion of the service line was determined based on the year the water system was built or the year the structure was built, please provide the description of source(s) used the year built was obtained (e.g., SDAT), length: 500 , Coded Values: [1. Installation year obtained directly from records: 1. Installation year obtained directly from records] , [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: 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] , [3. Installation year based on year the structure was built -- Applicable only if the structure was built in or after 1973: 3. Installation year based on year the structure was built -- Applicable only if the structure was built in or after 1973] , ...1 more... )
• mde_pipe1_determine ( type: esriFieldTypeString, alias: 55 Other Basis of Determination -- 1st portion of service line, length: 255 )
• mde_material_records1 ( type: esriFieldTypeString, alias: 56 Records used to obtain material, length: 255 )
• mde_diameter_records1 ( type: esriFieldTypeString, alias: 57 Records used to obtain diameter, length: 255 )
• mde_installation_records1 ( type: esriFieldTypeString, alias: 58 Records used to obtain installation year, length: 255 )
• mde_other_records1 ( type: esriFieldTypeString, alias: 59 Other Records used, length: 255 )
• mde_pipe_prediction1 ( type: esriFieldTypeString, alias: 60 Pipe material prediction method, length: 255 , Coded Values: [Interpolation: Interpolation] , [Statistical and/or Machine Learning Modeling: Statistical and/or Machine Learning Modeling] , [Other Analytics/Predictive Method pre-approved by MDE (Please provide details in "Other Analytics/Predictive Method(s)"): Other Analytics/Predictive Method pre-approved by MDE (Please provide details in "Other Analytics/Predictive Method(s)")] )
• mde_pipe_prediction_material1 ( type: esriFieldTypeString, alias: 61 Pipe material prediction of Utility, length: 255 , Coded Values: [Unknown: Unknown] , [Likely Lead: Likely Lead] , [Likely Lead-lined Galvanized (Iron or Steel): Likely Lead-lined Galvanized (Iron or Steel)] , ...12 more... )
• mde_pipe_prediction_prob1 ( type: esriFieldTypeDouble, alias: 63 Pipe material probablity )
• utilverified ( type: esriFieldTypeString, alias: 64 Utility Side Verified, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [Don't Know: Don't Know] )
• utilverifdate ( type: esriFieldTypeDate, alias: 65 Utility Verification Date, length: 8 )
• utilstatus ( type: esriFieldTypeString, alias: 66 Utility Status, length: 255 , Coded Values: [0: Unknown] , [1: Lead] , [2: Non-Lead] , ...1 more... )
• mde_field_verification1 ( type: esriFieldTypeString, alias: 67 Exposed Service Line, length: 255 , Coded Values: [ONLY 1 location visually inspected (WITHOUT excavation): ONLY 1 location visually inspected (WITHOUT excavation)] , [ONLY 1 location visually inspected (WITH excavation): ONLY 1 location visually inspected (WITH excavation)] , [2 or more locations visually inspected (WITHOUT excavation at any of the locations): 2 or more locations visually inspected (WITHOUT excavation at any of the locations)] , ...2 more... )
• mde_field_exposed1 ( type: esriFieldTypeString, alias: 68 Excavation Type, length: 255 , Coded Values: [Mechanical Excavation: Mechanical Excavation] , [Vacuum/Hydro Excavation: Vacuum/Hydro Excavation] , [Both Mechanical and Vacuum/Hydro Excavations: Both Mechanical and Vacuum/Hydro Excavations] )
• mde_field_visual1 ( type: esriFieldTypeString, alias: 69 Visual Inspection Method, length: 255 )
• mde_field_materialtest1 ( type: esriFieldTypeString, alias: 70 Material Test perform, length: 255 )
• mde_field_materialremote1 ( type: esriFieldTypeString, alias: 71 Method material verification without excavation, length: 255 , Coded Values: [Metal Detector: Metal Detector] , [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)"): 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)")] )
• mde_field_diameterremote1 ( type: esriFieldTypeString, alias: 72 Method of diameter verification without excavation, length: 255 , Coded Values: [Ground-Penetrating Radar (GPR): Ground-Penetrating Radar (GPR)] , [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)"): 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)")] )
• mde_field_tool_model1 ( type: esriFieldTypeString, alias: 73 Make and model of Instrument used, length: 255 )
• mde_feild_metaldetector1 ( type: esriFieldTypeString, alias: 74 Number of segments used by metal detector, length: 255 , Coded Values: [All 3 required segments: All 3 required segments] , [Only 1 or 2 of the required segments [Applicable only if SL pipe material is Lead]: Only 1 or 2 of the required segments [Applicable only if SL pipe material is Lead]] , [The entire length of service line pipe: The entire length of service line pipe] )
• mde_gpr1 ( type: esriFieldTypeString, alias: 75 Number of segments used by GPR, length: 255 , Coded Values: [All 3 required segments: All 3 required segments] , [The entire length of service line pipe: The entire length of service line pipe] )
• mde_cctv1 ( type: esriFieldTypeString, alias: 76 CCTV was used to gather info, length: 255 , Coded Values: [Yes - Method conducted: Yes - Method conducted] )
• mde_field_nonexposedmethod1 ( type: esriFieldTypeString, alias: 77 Other Non Exposed method used, length: 255 )
• mde_valve1 ( type: esriFieldTypeString, alias: 78 Valve on 1st portion status, length: 255 , Coded Values: [Yes - Valve contains more than 8% Lead: Yes - Valve contains more than 8% Lead] , [No: No] , [Don't Know: Don't Know] , ...1 more... )
• mde_notes1_utility ( type: esriFieldTypeString, alias: 79 Utility Side Notes, length: 255 )
• mde_line_replaced2 ( type: esriFieldTypeString, alias: 80 Is the CURRENT service line pipe (2nd Portion) a replacement of the previous service line reported in the water system's most recent submittal of the inventory spreadsheet?, length: 255 , Coded Values: [Yes - Lead in the Past: Yes - Lead in the Past] , [No - Never lead confirmed through documented records: No - Never lead confirmed through documented records] , [Don't Know: Don't Know] , ...2 more... )
• custassetid ( type: esriFieldTypeString, alias: 81 Customer Asset ID, length: 255 )
• custsource ( type: esriFieldTypeString, alias: 82 Customer Source, length: 255 , Coded Values: [Installation record (e.g., tap card): Installation record (e.g., tap card)] , [Water sampling only with no records: Water sampling only with no records] , [Field inspection only with no records: Field inspection only with no records] , ...6 more... )
• custmaterial ( type: esriFieldTypeString, alias: 83 Customer Material, length: 255 , Coded Values: [Unknown - Material Unknown: Unknown - Material Unknown] , [Unknown - Likely Lead: Unknown - Likely Lead] , [Unknown - Unlikely Lead: Unknown - Unlikely Lead] , ...17 more... )
• custdiameter ( type: esriFieldTypeString, alias: 84 Customer Diameter, length: 255 , Coded Values: [0.5: 1/2"] , [0.75: 3/4"] , [1: 1"] , ...12 more... )
• custinstalldate ( type: esriFieldTypeDate, alias: 85 Customer Install Date, length: 8 )
• mde_pipe_material2 ( type: esriFieldTypeString, alias: 86 MATERIAL of CURRENT service line pipe -- Customer 2nd portion of service line, length: 255 , Coded Values: [Don't Know or Unknown: Don't Know or Unknown] , [Likely Lead (prediction with no threshold set - considered as unknown): Likely Lead (prediction with no threshold set - considered as unknown)] , [Likely Non-Lead (prediction with no threshold set - considered as unknown): Likely Non-Lead (prediction with no threshold set - considered as unknown)] , ...16 more... )
• mde_material_source2 ( type: esriFieldTypeString, alias: 87 Basis of MATERIAL Determination of the Current Service Line Pipe -- Customer 2nd portion of service line, length: 500 , Coded Values: [1. Pipe material obtained directly from records AND Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation): 1. Pipe material obtained directly from records AND Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)] , [2. Pipe material obtained directly from ONLY Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation): 2. Pipe material obtained directly from ONLY Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)] , [3. Pipe material obtained directly from records AND Field Investigation via Non-Exposed Service line Pipe Inspection: 3. Pipe material obtained directly from records AND Field Investigation via Non-Exposed Service line Pipe Inspection] , ...7 more... )
• mde_past_lead2 ( type: esriFieldTypeString, alias: 88 Was Customer 2nd portion of service line pipe ever lead in the past?, length: 255 , Coded Values: [Yes - Lead in the Past: Yes - Lead in the Past] , [No - Never lead confirmed through documented records: No - Never lead confirmed through documented records] , [Don't Know: Don't Know] , ...2 more... )
• mde_past_lead2_method ( type: esriFieldTypeString, alias: 089 If water system is able to confirm whether or not the Customer 2nd portion of the service line was Lead in the past, please provide description of method used, length: 255 )
• pipe_diameter2 ( type: esriFieldTypeString, alias: 090 Customer Diameter, length: 255 , Coded Values: [0.5: 1/2"] , [0.75: 3/4"] , [1: 1"] , ...12 more... )
• mde_pipe_diameter2 ( type: esriFieldTypeString, alias: 091 DIAMETER* of CURRENT service line pipe --Customer 2nd portion of service, length: 255 , Coded Values: [Don't Know or Unknown: Don't Know or Unknown] , [Less than 1": Less than 1"] , [Greater than or equal to 1", but less than 2": Greater than or equal to 1", but less than 2"] , ...3 more... )
• mde_pipe_diameter2_source ( type: esriFieldTypeString, alias: 092 Basis of DIAMETER Determination of the Curent Service Line Pipe -- Customer 2nd portion of service line, length: 500 , Coded Values: [1. Pipe diameter obtained directly from records AND Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation): 1. Pipe diameter obtained directly from records AND Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)] , [2. Pipe diameter obtained directly from ONLY Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation): 2. Pipe diameter obtained directly from ONLY Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)] , [3. Pipe diameter obtained directly from records AND Field Investigation via Non-Exposed Service line Pipe Inspection: 3. Pipe diameter obtained directly from records AND Field Investigation via Non-Exposed Service line Pipe Inspection] , ...3 more... )
• mde_pipe_install2 ( type: esriFieldTypeString, alias: 093 Installation Date of 2nd portion, length: 255 , Coded Values: [Don't Know or Unknown: Don't Know or Unknown] , [2024 and After: 2024 and After] , [1973 through 2023: 1973 through 2023] , ...49 more... )
• mde_pipe_install2_source ( type: esriFieldTypeString, alias: 094 If Installation year of the 2nd portion of the service line was determined based on the year the water system was built or the year the structure was built, please provide the description of source(s) used the year built was obtained (e.g., SDAT), length: 500 )
• mde_pipe2_determine ( type: esriFieldTypeString, alias: 095 Other Basis of Determination -- 2nd portion of service line, length: 255 )
• mde_material_records2 ( type: esriFieldTypeString, alias: 096 Records used to obtain material, length: 255 )
• mde_diameter_records2 ( type: esriFieldTypeString, alias: 097 Records used to obtain diameter, length: 255 )
• mde_installation_records2 ( type: esriFieldTypeString, alias: 098 Records used to obtain installation year, length: 255 )
• mde_other_records2 ( type: esriFieldTypeString, alias: 099 Other Records used, length: 255 )
• mde_pipe_prediction2 ( type: esriFieldTypeString, alias: 100 Pipe material prediction method, length: 255 , Coded Values: [Interpolation: Interpolation] , [Statistical and/or Machine Learning Modeling: Statistical and/or Machine Learning Modeling] , [Other Analytics/Predictive Method pre-approved by MDE (Please provide details in "Other Analytics/Predictive Method(s)"): Other Analytics/Predictive Method pre-approved by MDE (Please provide details in "Other Analytics/Predictive Method(s)")] )
• mde_pipe_prediction_material2 ( type: esriFieldTypeString, alias: 101 Pipe material prediction of Utility, length: 255 , Coded Values: [Unknown: Unknown] , [Likely Lead: Likely Lead] , [Likely Lead-lined Galvanized (Iron or Steel): Likely Lead-lined Galvanized (Iron or Steel)] , ...12 more... )
• mde_pipe_prediction_prob2 ( type: esriFieldTypeDouble, alias: 102 Pipe material probablity )
• custverified ( type: esriFieldTypeString, alias: 103 Customer Side Verified, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [Don't Know: Don't Know] )
• custverifdate ( type: esriFieldTypeDate, alias: 104 Customer Verification Date, length: 8 )
• custverifmethod ( type: esriFieldTypeString, alias: 105 Customer Verification Method, length: 255 , Coded Values: [Visual inspection at meter pit: Visual inspection at meter pit] , [Customer self-identification: Customer self-identification] , [CCTV Inspection at Curb Box - Internal: CCTV Inspection at Curb Box - Internal] , ...7 more... )
• custstatus ( type: esriFieldTypeString, alias: 106 Customer Status, length: 255 , Coded Values: [0: Unknown] , [1: Lead] , [2: Non-Lead] , ...1 more... )
• mde_field_verification2 ( type: esriFieldTypeString, alias: 107 Exposed Service Line, length: 255 , Coded Values: [ONLY 1 location visually inspected (WITHOUT excavation): ONLY 1 location visually inspected (WITHOUT excavation)] , [ONLY 1 location visually inspected (WITH excavation): ONLY 1 location visually inspected (WITH excavation)] , [2 or more locations visually inspected (WITHOUT excavation at any of the locations): 2 or more locations visually inspected (WITHOUT excavation at any of the locations)] , ...2 more... )
• mde_field_exposed2 ( type: esriFieldTypeString, alias: 108 Excavation Type, length: 255 , Coded Values: [Mechanical Excavation: Mechanical Excavation] , [Vacuum/Hydro Excavation: Vacuum/Hydro Excavation] , [Both Mechanical and Vacuum/Hydro Excavations: Both Mechanical and Vacuum/Hydro Excavations] )
• mde_field_visual2 ( type: esriFieldTypeString, alias: 109 Visual Inspection Method, length: 255 )
• mde_field_materialtest2 ( type: esriFieldTypeString, alias: 110 Material Test perform, length: 255 )
• mde_field_materialremote2 ( type: esriFieldTypeString, alias: 112 Method material verification without excavation, length: 255 , Coded Values: [Metal Detector: Metal Detector] , [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)"): 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)")] )
• mde_field_diameterremote2 ( type: esriFieldTypeString, alias: 113 Method of diameter verification without excavation, length: 255 , Coded Values: [Ground-Penetrating Radar (GPR): Ground-Penetrating Radar (GPR)] , [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)"): 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)")] )
• mde_field_tool_model2 ( type: esriFieldTypeString, alias: 114 Make and model of Instrument used, length: 255 )
• mde_feild_metaldetector2 ( type: esriFieldTypeString, alias: 115 Number of segments used by metal detector, length: 255 , Coded Values: [All 3 required segments: All 3 required segments] , [Only 1 or 2 of the required segments [Applicable only if SL pipe material is Lead]: Only 1 or 2 of the required segments [Applicable only if SL pipe material is Lead]] , [The entire length of service line pipe: The entire length of service line pipe] )
• mde_gpr2 ( type: esriFieldTypeString, alias: 116 Number of segments used by GPR, length: 255 , Coded Values: [All 3 required segments: All 3 required segments] , [The entire length of service line pipe: The entire length of service line pipe] )
• mde_cctv2 ( type: esriFieldTypeString, alias: 117 CCTV was used to gather info, length: 255 , Coded Values: [Yes - Method conducted: Yes - Method conducted] )
• mde_field_nonexposedmethod2 ( type: esriFieldTypeString, alias: 118 Other Non Exposed method used, length: 255 )
• mde_valve2 ( type: esriFieldTypeString, alias: 119 Valve Material to 2nd part, length: 255 , Coded Values: [Yes - Valve contains more than 8% Lead: Yes - Valve contains more than 8% Lead] , [No: No] , [Don't Know: Don't Know] , ...1 more... )
• custnotes ( type: esriFieldTypeString, alias: 120 Customer Side Notes, length: 255 )
• bothsidesstatus ( type: esriFieldTypeString, alias: 121 Entire Service Line Status, length: 255 )
• replacestatus ( type: esriFieldTypeString, alias: 122 Replacement Status, length: 255 , Coded Values: [Doesn't Need Replacement: Doesn't Need Replacement] , [Needs Replacement: Needs Replacement] , [Scheduled Replacement: Scheduled Replacement] , ...1 more... )
• scheddate ( type: esriFieldTypeDate, alias: 123 Utility Side Scheduled Replacement Date, length: 8 )
• utilreplacedate ( type: esriFieldTypeDate, alias: 124 Utility Replacement Date, length: 8 )
• custscheddate ( type: esriFieldTypeDate, alias: 125 Customer Side Scheduled Replacement Date, length: 8 )
• custreplacedate ( type: esriFieldTypeDate, alias: 126 Customer Side Replacement Date, length: 8 )
• replacereason ( type: esriFieldTypeString, alias: 127 Reason for Replacement, length: 255 , Coded Values: [Lead: Lead] , [Other: Other] )
• custnotified ( type: esriFieldTypeString, alias: 128 Notified Customer, length: 255 )
• notifydate ( type: esriFieldTypeDate, alias: 129 Notification Date, length: 8 )
• sensitivepop ( type: esriFieldTypeString, alias: 130 Sensitive Population, length: 255 , Coded Values: [Yes - School: Yes - School] , [Yes - Day Care: Yes - Day Care] , [Yes - Other: Yes - Other] , ...1 more... )
• disadvantaged ( type: esriFieldTypeString, alias: 131 Disadvantaged Neighborhood, length: 255 )
• otherfittings ( type: esriFieldTypeString, alias: 132Other Fittings Containing Lead, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [Don't Know: Don't Know] )
• yearstructbuilt ( type: esriFieldTypeSmallInteger, alias: 200 Year Structure Built )
• everlead ( type: esriFieldTypeString, alias: 201 Ever Lead?, length: 15 , Coded Values: [Yes: Yes] , [No: No] , [Don't Know: Don't Know] )
• mde_meter_lead ( type: esriFieldTypeString, alias: 202 MDE Service Line Meter Contain Lead?, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [Don't Know: Don't Know] )
• mde_util_diameter ( type: esriFieldTypeString, alias: MDE Utility Side Diameter, length: 255 , Coded Values: [Don't Know or Unknown: Don't Know or Unknown] , [Less than 1": Less than 1"] , [Greater than or equal to 1", but less than 2": Greater than or equal to 1", but less than 2"] , ...3 more... )
• mde_util_diameter_determine ( type: esriFieldTypeString, alias: MDE Utility Diameter Determination, length: 255 , Coded Values: [1. Pipe diameter obtained directly from records AND Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation): 1. Pipe diameter obtained directly from records AND Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)] , [2. Pipe diameter obtained directly from ONLY Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation): 2. Pipe diameter obtained directly from ONLY Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)] , [3. Pipe diameter obtained directly from records AND Field Investigation via Non-Exposed Service line Pipe Inspection: 3. Pipe diameter obtained directly from records AND Field Investigation via Non-Exposed Service line Pipe Inspection] , ...3 more... )
• mde_util_installdate ( type: esriFieldTypeString, alias: MDE Utility Install Date, length: 255 )
• mde_util_1972 ( type: esriFieldTypeString, alias: MDE Utility Determination Prior to May 17 1972, length: 255 , Coded Values: [Don't Know or Unknown: Don't Know or Unknown] , [2024 and After: 2024 and After] , [1973 through 2023: 1973 through 2023] , ...49 more... )
• servicelineinstalldate ( type: esriFieldTypeString, alias: Utility Install Date Notes, length: 50 )
• utilverifmethod ( type: esriFieldTypeString, alias: Utility Verification Method, length: 100 , Coded Values: [Visual inspection at meter pit: Visual inspection at meter pit] , [Customer self-identification: Customer self-identification] , [CCTV Inspection at Curb Box - Internal: CCTV Inspection at Curb Box - Internal] , ...7 more... )
• mde_util_vis_inspection ( type: esriFieldTypeString, alias: MDE Utility Visual Inspection Method, length: 255 , Coded Values: [ONLY 1 location visually inspected (WITHOUT excavation): ONLY 1 location visually inspected (WITHOUT excavation)] , [ONLY 1 location visually inspected (WITH excavation): ONLY 1 location visually inspected (WITH excavation)] , [Entire 2nd portion was unearthed and visually inspected: Entire 2nd portion was unearthed and visually inspected] , ...3 more... )
• mde_cust_mat_verifi ( type: esriFieldTypeString, alias: MDE Customer Material Verification, length: 319 , Coded Values: [1. Pipe material obtained directly from records AND Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation): 1. Pipe material obtained directly from records AND Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)] , [2. Pipe material obtained directly from ONLY Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation): 2. Pipe material obtained directly from ONLY Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)] , [3. Pipe material obtained directly from records AND Field Investigation via Non-Exposed Service line Pipe Inspection: 3. Pipe material obtained directly from records AND Field Investigation via Non-Exposed Service line Pipe Inspection] , ...8 more... )
• mde_cust_diameter_determine ( type: esriFieldTypeString, alias: MDE Customer Diameter Determination, length: 255 , Coded Values: [1. Pipe diameter obtained directly from records AND Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation): 1. Pipe diameter obtained directly from records AND Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)] , [2. Pipe diameter obtained directly from ONLY Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation): 2. Pipe diameter obtained directly from ONLY Field Investigation via Visual Inspection of Exposed Service Line Pipe (with or without Excavation)] , [3. Pipe diameter obtained directly from records AND Field Investigation via Non-Exposed Service line Pipe Inspection: 3. Pipe diameter obtained directly from records AND Field Investigation via Non-Exposed Service line Pipe Inspection] , ...3 more... )
• mde_cust_1972 ( type: esriFieldTypeString, alias: MDE Customer Size Beofore 1972, length: 255 , Coded Values: [Don't Know or Unknown: Don't Know or Unknown] , [2024 and After: 2024 and After] , [1973 through 2023: 1973 through 2023] , ...49 more... )
• buildingtype ( type: esriFieldTypeString, alias: Building Type, length: 255 )
• Shape ( type: esriFieldTypeGeometry, alias: SHAPE )
• util_sl_segments ( type: esriFieldTypeString, alias: 020 Utility Segments, length: 50 , Coded Values: [1: 1] , [More than 1: More than 1] )
• cust_sl_segments ( type: esriFieldTypeString, alias: 022 Customer Segments, length: 255 , Coded Values: [1: 1] , [More than 1: More than 1] )
• util_connector_past ( type: esriFieldTypeString, alias: 400 util_connector_past, length: 255 , Coded Values: [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.: 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.] )
• util_connector_leadlenght ( type: esriFieldTypeString, alias: 401 util_connector_leadlenght, length: 255 , Coded Values: [NA- Connector NOT Lead: Length Not Applicable - Connector NOT Lead] , [NA- No Connector Present : Length Not Applicable - No Connector Present] , [Connector material (and/or presence of connector) unknown: Connector material (and/or presence of connector) unknown] , ...16 more... )
• util_connector_material ( type: esriFieldTypeString, alias: 402 util_connector_material, length: 255 , Coded Values: [Length of previous Lead connector was less than length in EPA's connector definition: Length of previous Lead connector was less than length in EPA's connector definition] , [Length of previous Lead connector was equal to length in EPA's connector definition: Length of previous Lead connector was equal to length in EPA's connector definition] , [Length of previous Lead connector was greater than length in EPA's connector definition: Length of previous Lead connector was greater than length in EPA's connector definition] , ...1 more... )
• cust_connector_past ( type: esriFieldTypeString, alias: 403 Customer Connector Lead in Past, length: 255 , Coded Values: [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.: 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.] )
• cust_connector_leadlenght ( type: esriFieldTypeString, alias: 404 Customer Connector Lenght, length: 255 , Coded Values: [NA- Connector NOT Lead: Length Not Applicable - Connector NOT Lead] , [NA- No Connector Present : Length Not Applicable - No Connector Present] , [Connector material (and/or presence of connector) unknown: Connector material (and/or presence of connector) unknown] , ...16 more... )
• cust_connector_material ( type: esriFieldTypeString, alias: 404 Customer Connector Matieral, length: 255 , Coded Values: [Length of previous Lead connector was less than length in EPA's connector definition: Length of previous Lead connector was less than length in EPA's connector definition] , [Length of previous Lead connector was equal to length in EPA's connector definition: Length of previous Lead connector was equal to length in EPA's connector definition] , [Length of previous Lead connector was greater than length in EPA's connector definition: Length of previous Lead connector was greater than length in EPA's connector definition] , ...1 more... )
• util_connector_past1 ( type: esriFieldTypeString, alias: 410 Utility 1A Connector Replaced?, length: 255 , Coded Values: [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.: 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.] )
• util_connector_leadlenght1 ( type: esriFieldTypeString, alias: 411 Utility 1A Connector Lenght if Lead, length: 255 , Coded Values: [NA- Connector NOT Lead: Length Not Applicable - Connector NOT Lead] , [NA- No Connector Present : Length Not Applicable - No Connector Present] , [Connector material (and/or presence of connector) unknown: Connector material (and/or presence of connector) unknown] , ...16 more... )
• util_connector_material1 ( type: esriFieldTypeString, alias: 412 Utilty 1A Connector Material, length: 255 , Coded Values: [Length of previous Lead connector was less than length in EPA's connector definition: Length of previous Lead connector was less than length in EPA's connector definition] , [Length of previous Lead connector was equal to length in EPA's connector definition: Length of previous Lead connector was equal to length in EPA's connector definition] , [Length of previous Lead connector was greater than length in EPA's connector definition: Length of previous Lead connector was greater than length in EPA's connector definition] , ...1 more... )
• cust_connector_past1 ( type: esriFieldTypeString, alias: 413 Customer 2A Connector Replaced?, length: 255 , Coded Values: [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.: 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.] )
• cust_connector_leadlenght1 ( type: esriFieldTypeString, alias: 414 Connector 2A Connector Replaced?, length: 255 , Coded Values: [NA- Connector NOT Lead: Length Not Applicable - Connector NOT Lead] , [NA- No Connector Present : Length Not Applicable - No Connector Present] , [Connector material (and/or presence of connector) unknown: Connector material (and/or presence of connector) unknown] , ...16 more... )
• cust_connector_material1 ( type: esriFieldTypeString, alias: 415 Connector 2A Connector Lenght if Lead, length: 255 , Coded Values: [Length of previous Lead connector was less than length in EPA's connector definition: Length of previous Lead connector was less than length in EPA's connector definition] , [Length of previous Lead connector was equal to length in EPA's connector definition: Length of previous Lead connector was equal to length in EPA's connector definition] , [Length of previous Lead connector was greater than length in EPA's connector definition: Length of previous Lead connector was greater than length in EPA's connector definition] , ...1 more... )
• user_txtcustomername ( type: esriFieldTypeString, alias: 901 Customer Name, length: 255 )
• user_customermailingaddress ( type: esriFieldTypeString, alias: 902 Mailing Address Street, length: 255 )
• user_customermailingcity ( type: esriFieldTypeString, alias: 903 Mailing City, length: 255 )
• user_customermailstate ( type: esriFieldTypeString, alias: 904 Mailing State, length: 255 )
• user_customermailzip ( type: esriFieldTypeString, alias: 905 Mailing Zip, length: 255 )
• user_txtcustomeraddress ( type: esriFieldTypeString, alias: 906 Mailing Address Full, length: 255 )
• user_customerhomephone ( type: esriFieldTypeString, alias: 907 Customer Phone, length: 255 )
• user_occupname ( type: esriFieldTypeString, alias: 908 Occupant Name, length: 255 )
• user_occuphomephone ( type: esriFieldTypeString, alias: 909 Occupant Phone, length: 255 )
• gis_GISDBADMIN_DPU_W_LeadServic ( type: esriFieldTypeString, alias: gis_GISDBADMIN_DPU_W_LeadServic, length: 512 )