Skip common site navigation and headers
United States Environmental Protection Agency
Data & Databases
Recent Additions | Contact Us | Print Version Search:
Begin Hierarchical Links EPA Home > Water > Ground Water & Drinking Water > Data & Databases > Accessing Drinking Water Data End Hierarchical Links

 

Accessing EPA's Drinking Water Data in SDWIS/FED

There are several ways to access Safe Drinking Water Information System/Federal Version (SDWIS/FED) data. These include the following, starting with the simplest: 
  1. Browse and/or download hard copy reports

    2. The following summary tables include inventory data on water systems, violations reported by violation type and by contaminant/rule, and official Government Performance and Results Act (GPRA) data. 
  2. Access data on individual water systems on-line through Envirofacts.

    3. These include basic inventory data, violations reported, and enforcement actions taken against individual water systems since 1993.      You can also access aggregated information on all violations reported in your EPA region, state, and county since 1993 using the MS Excel PivotTables®. See below. 
       
  3. Download and manipulate SDWIS/FED data in MS Excel PivotTables®

    4. These multidimensional tables contain aggregated information on water systems; violations reported by violation type and by contaminant/rule, and GPRA data, for each year since 1993; and current Envirofacts data. You can sort, categorize, and analyze the data across several dimensions. 
  4. Access standard reports from the mainframe

    5. EPA has developed 11 reports that present either water system-specific or summary information. Users will need to obtain a mainframe ID and password, and specialized training. 
  5. Perform ad hoc queries
    • Using MS Access via ODBC

      • Using ODBC-compliant software such as MS Access or FoxPro, you can link to all SDWIS/FED production and frozen tables. You can also link to additional data tables that have been optimized for retrieval and analysis, and access a growing library of queries built in MS Access. 
    • Using the IBM Platinum Report Facility (PRF) on the mainframe

      • Production and frozen SDWIS/FED data tables are also accessible through the mainframe. Here you can build PRF or SQL queries, and run standard reports. Users will need to obtain a mainframe ID and password, and specialized training. 
Your feedback will help us better meet your drinking water data needs.

 

Safewater Home | About Our Office | Publications | Calendar | Links | Office of Water | En Español

 
Begin Site Footer

EPA Home | Privacy and Security Notice | Contact Us