![]() ![]() Key fields uniquely identify the records within each file, and may be used to join and relate data between files.įor example, in the SDWA_PUB_WATER_SYSTEMS.csv file, each row describes a public water system in a particular quarter, and is uniquely identified by the values of the key fields SUBMISSIONYEARQUARTER and PWSID. Key fields for each table are listed in bold below. The ZIP file contains several comma-separated value (CSV) files. ![]() ![]() The Safe Drinking Water Information System (SDWIS) contains information on public water systems from the Public Water System Supervision (PWSS) Program, including monitoring, enforcement, and violation data related to requirements established by the Safe Drinking Water Act (SDWA). These files contain the most up-to-date data from SDWIS, and more information regarding facility evaluations, enforcements, and violations. The SDWA Dataset files were published in July 2021 to reflect the latest SDWIS release and are refreshed quarterly, as described on About the Data. These downloads provide national data for key EPA/State Drinking Water Dashboard metrics, which are some of the SDWIS data elements most commonly used in the enforcement and compliance program. The Enforcement and Compliance History Online (ECHO) system incorporates Public Water Systems data from EPA's Safe Drinking Water Information System (SDWIS) database. State Review Framework Tracker Recommendations.EPA/State Dashboards (Air, Wastewater, Drinking Water, Hazardous Waste, Pesticides).Quarterly NPDES Noncompliance Report Search.Wastewater/Stormwater/Biosolids Facility Search.
0 Comments
Leave a Reply. |