Name: Community_Water_Systems_June_11_2025_Table

Display Field: PWS_NAME

Type: Table

Description: Community water system service area boundaries describe the geographic area that receives drinking water from a given community water system. Knowing these boundaries help to connect water system data (such as, compliance status) with water system customers.This dataset contains ~44,000 unique service areas across all 50 states. While not 100% comprehensive, these systems cover 99% of all public water system consumers.  ~40% of systems are sourced from state/utility databases. The remaining systems, those with no state supplied boundary, were modeled using machine learning techniques. This effort used state sourced service areas to train a model on dozens of explanatory variables including drinking water intakes in order to approximate service areas where none are publicly available.This dataset used the 2023 Quarter 4 Safe Drinking Water Information System for establishing the universe of community water systems.For detailed information on this dataset, visit our GitHub repository: https://github.com/USEPA/ORD_SAB_ModelIf you encounter any discrepancies or issues , please contact us.***Version 1.2 was updated on 02/05/25***

Copyright Text: US EPA

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• PWS_NAME (type: esriFieldTypeString, alias: Public Water System (PWS) Name, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• PWSID (type: esriFieldTypeString, alias: Public Water System ID, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• REGISTRY_ID (type: esriFieldTypeString, alias: Facility Registry Service ID (FRS ID), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• EPA_REGION (type: esriFieldTypeString, alias: EPA Region, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• ZIP_CODE_SERVED (type: esriFieldTypeString, alias: Zip Code(s) Served , SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• CITY_SERVED (type: esriFieldTypeString, alias: City(ies) Served, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• COUNTY_SERVED (type: esriFieldTypeString, alias: County(ies) Served, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• ANSI_ENTITY_CODE (type: esriFieldTypeString, alias: ANSI Entity Code (County), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TRIBE_SERVED (type: esriFieldTypeString, alias: Tribe(s) Served, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• BIA_TRIBE_CODE (type: esriFieldTypeString, alias: Bureau of Indian Affairs Tribe Code, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• PRIMACY_TYPE (type: esriFieldTypeString, alias: Primacy Type, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• PRIMACY_AGENCY (type: esriFieldTypeString, alias: Primacy Agency, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• PWS_TYPE (type: esriFieldTypeString, alias: Public Water System Type, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• OWNER_TYPE (type: esriFieldTypeString, alias: Ownership, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• SCHOOL_OR_DAYCARE (type: esriFieldTypeString, alias: Serves School or Daycare (Y/N), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• WHOLESALER (type: esriFieldTypeString, alias: Wholesaler (Y/N), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• SOURCE_WATER_TYPE (type: esriFieldTypeString, alias: Source Water Type, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• POPULATION_SERVED_COUNT (type: esriFieldTypeInteger, alias: Population Served (Count), SQL Type: sqlTypeOther, nullable: true, editable: true)
• POPULATION_CATEGORY_SERVED (type: esriFieldTypeString, alias: Population Served (Range), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• SERVICE_CONNECTIONS_COUNT (type: esriFieldTypeInteger, alias: Service Connections (Count), SQL Type: sqlTypeOther, nullable: true, editable: true)
• COMP_PERIOD_BEGIN_FYQTR (type: esriFieldTypeString, alias: Enforcement/Compliance Reporting Period (Fiscal Year-Quarter), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• VIOLATIONS_NON_RTC_COUNT (type: esriFieldTypeInteger, alias: Violations (Count), SQL Type: sqlTypeOther, nullable: true, editable: true)
• VIOLATIONS_NON_RTC_COUNT_RANGE (type: esriFieldTypeString, alias: Violations (Count, Range), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• HBV_NON_RTC_COUNT (type: esriFieldTypeInteger, alias: Health Based Violations (Count), SQL Type: sqlTypeOther, nullable: true, editable: true)
• HBV_NON_RTC_COUNT_RANGE (type: esriFieldTypeString, alias: Health Based Violations (Count, Range), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• HB_RULES_VIOL_NONRTC (type: esriFieldTypeString, alias: Health Based Rules Violated, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• HBV_COUNT_QTRS_5YRS (type: esriFieldTypeInteger, alias: Health Based Violations (5-years, Count of Quarters), SQL Type: sqlTypeOther, nullable: true, editable: true)
• HBV_COUNT_QTRS_5YRS_RANGE (type: esriFieldTypeString, alias: Health Based Violations (5-years, Count of Quarters, Range), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• HB_RULES_VIOLATED_5YRS (type: esriFieldTypeString, alias: Health Based Rule(s) in Violation (5-Years), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• LCR_VIOL_NONRTC_COUNT (type: esriFieldTypeInteger, alias: Lead and Copper Rule Violations (Count), SQL Type: sqlTypeOther, nullable: true, editable: true)
• LCR_VIOL_NONRTC_COUNT_RANGE (type: esriFieldTypeString, alias: Lead and Copper Rule Violations (Count, Range), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• LCR_VIOL_COUNT_QTRS_5YRS (type: esriFieldTypeInteger, alias: Lead and Copper Rule Violations (5-years, Count of Quarters), SQL Type: sqlTypeOther, nullable: true, editable: true)
• LCR_VIOL_COUNT_QTRS_5YRS_RANGE (type: esriFieldTypeString, alias: Lead and Copper Rule Violations (5-years, Count of Quarters, Range), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• MR_VIOL_COUNT_QTRS_5YRS (type: esriFieldTypeInteger, alias: Monitoring and Reporting Violations (5-years, Count of Quarters), SQL Type: sqlTypeOther, nullable: true, editable: true)
• MR_VIOL_COUNT_QTRS_5YRS_RANGE (type: esriFieldTypeString, alias: Monitoring and Reporting Violations (5-years, Count of Quarters, Range), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• FEA_VIOL_NONRTC_COUNT (type: esriFieldTypeInteger, alias: Formal Enforcement Actions (Count), SQL Type: sqlTypeOther, nullable: true, editable: true)
• FEA_VIOL_NONRTC_COUNT_RANGE (type: esriFieldTypeString, alias: Formal Enforcement Actions (Count, Range), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• LEAD_ALE_5YRS_YN (type: esriFieldTypeString, alias: Lead Action Level Exceedances (5-years, Y/N), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• LEAD_ALE_COUNT_5YRS (type: esriFieldTypeInteger, alias: Lead Action Level Exceedances (5-years, Count), SQL Type: sqlTypeOther, nullable: true, editable: true)
• LEAD_ALE_COUNT_5YRS_RANGE (type: esriFieldTypeString, alias: Lead Action Level Exceedances (5-years, Count, Range), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• LEAD_SAMPLE_COUNT_5YRS (type: esriFieldTypeDouble, alias: Lead Samples Between 10-15ppb (5-years, Count), SQL Type: sqlTypeOther, nullable: true, editable: true)
• LEAD_SAMPLE_COUNT_5YRS_RANGE (type: esriFieldTypeString, alias: Lead Samples Between 10-15ppb (5-years, Count, Range), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• ENF_PRIORITY_SYS (type: esriFieldTypeString, alias: Enforcement Priority System (Y/N), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• SS_OUTSTAND_PERFORM (type: esriFieldTypeString, alias: Sanitary Survey Outstanding Performer (Y/N), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• SS_OUTSTAND_PERFORM_BEGIN_DATE (type: esriFieldTypeDateOnly, alias: Sanitary Survey Outstanding Performer (Begin Date), SQL Type: sqlTypeOther, nullable: true, editable: true)
• TRMT_4LOG_OR_GREATER (type: esriFieldTypeString, alias: 4-Log Treatment or Greater (Y/N), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• SS_DATE_MOST_RECENT (type: esriFieldTypeDateOnly, alias: Most Recent Complete Sanitary Survey (Date), SQL Type: sqlTypeOther, nullable: true, editable: true)
• SS_SURVEY_OVERDUE (type: esriFieldTypeString, alias: Sanitary Survey Overdue (Y/N), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• SS_VISIT_TYPE (type: esriFieldTypeString, alias: Sanitary Survey Visit Type, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• SS_SIGD_OR_SAND_INFRA_YN (type: esriFieldTypeString, alias: Sanitary Survey Significant Deficiency or Sanitary Defect (Infrastructure Related Survey Elements), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• SS_SIGD_OR_SAND_CAP_YN (type: esriFieldTypeString, alias: Sanitary Survey Significant Deficiency or Sanitary Defect (Capacity Related Survey Elements), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• MANAGEMENT_OPS_EVAL_CODE (type: esriFieldTypeString, alias: Management Sanitary Survey Element Results (Most Recent Complete Survey), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• SOURCE_WATER_EVAL_CODE (type: esriFieldTypeString, alias: Source Water Sanitary Survey Element Results (Most Recent Complete Survey), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• SECURITY_EVAL_CODE (type: esriFieldTypeString, alias: Security Sanitary Survey Element Results (Most Recent Complete Survey), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• PUMPS_EVAL_CODE (type: esriFieldTypeString, alias: Pumps Sanitary Survey Element Results (Most Recent Complete Survey), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• OTHER_EVAL_CODE (type: esriFieldTypeString, alias: Other Sanitary Survey Element Results (Most Recent Complete Survey), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• COMPLIANCE_EVAL_CODE (type: esriFieldTypeString, alias: Operator Compliance Sanitary Survey Element Results (Most Recent Complete Survey), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• DATA_VERIFICATION_EVAL_CODE (type: esriFieldTypeString, alias: Data Verification Sanitary Survey Element Results (Most Recent Complete Survey), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• TREATMENT_EVAL_CODE (type: esriFieldTypeString, alias: Treatment Sanitary Survey Element Results (Most Recent Complete Survey), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• FINISHED_WATER_STOR_EVAL_CODE (type: esriFieldTypeString, alias: Finished Water Storage Sanitary Survey Element Results (Most Recent Complete Survey), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• DISTRIBUTION_EVAL_CODE (type: esriFieldTypeString, alias: Distribution Sanitary Survey Element Results (Most Recent Complete Survey), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• FINANCIAL_EVAL_CODE (type: esriFieldTypeString, alias: Financial Sanitary Survey Element Results (Most Recent Complete Survey), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• STATE_DWSRF_DAC (type: esriFieldTypeString, alias: Disadvantaged Community (State Definition), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• DWSRF_AWARDS_10YRS_COUNT (type: esriFieldTypeInteger, alias: Drinking Water State Revolving Fund Loan(s)/Grant(s) Received (10-Years, Count), SQL Type: sqlTypeOther, nullable: true, editable: true)
• DWSRF_AWARDS_10YRS_COUNT_RANGE (type: esriFieldTypeString, alias: Drinking Water State Revolving Fund Loan(s)/Grant(s) Received (10-Years, Count, Range), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• PWS_MHI_WEIGHT (type: esriFieldTypeDouble, alias: Median Household Income, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PCT_LOWINC (type: esriFieldTypeDouble, alias: Percent of Population Low Income, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PCT_RURAL (type: esriFieldTypeDouble, alias: Percent of Population Rural, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PCT_UNEMPLY (type: esriFieldTypeDouble, alias: Percent of Population Unemployed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PCT_LOWINC_RANGE (type: esriFieldTypeString, alias: Percent of Population Low Income, Range, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• PCT_RURAL_RANGE (type: esriFieldTypeString, alias: Percent of Population Rural, Range, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• PCT_UNEMPLY_RANGE (type: esriFieldTypeString, alias: Percent of Population Unemployed, Range, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• DFR_URL (type: esriFieldTypeString, alias: Additional Enforcement/Compliance Details, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Shape_Length (type: esriFieldTypeDouble, alias: Shape_Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape_Area (type: esriFieldTypeDouble, alias: Shape_Area, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: Community_Water_Systems_June_11_2025_Table
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/12/2025 1:26:57 AM

Schema Last Edit Date: 6/12/2025 1:26:57 AM

Data Last Edit Date: 6/12/2025 1:26:57 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat