@datafire/epa_gov_sdw

DataFire integration for U.S. EPA Enforcement and Compliance History Online (ECHO) - Safe Drinking Water Act

Downloads in past

Stats

StarsIssuesVersionUpdatedCreatedSize
@datafire/epa_gov_sdw
133316.0.03 years ago7 years agoMinified + gzip package size for @datafire/epa_gov_sdw in KB

Popular Searches

Readme

@datafire/epagovsdw
Client library for U.S. EPA Enforcement and Compliance History Online (ECHO) - Safe Drinking Water Act

Installation and Usage

npm install --save @datafire/epa_gov_sdw
let epa_gov_sdw = require('@datafire/epa_gov_sdw').create();

.then(data => {
  console.log(data);
});

Description

Enforcement and Compliance History Online (ECHO) is a tool developed and maintained by EPA's Office of Enforcement and Compliance Assurance for public use. ECHO provides integrated compliance and enforcement information for over 1 million regulated facilities nationwide.
SDW Rest Services provides multiple service endpoints, each with specific capabilities, to search and retrieve data on public water systems regulated under the Safe Drinking Water Act (SDWA).  The returned results reflect data drawn from EPA's Federal Safe Drinking Water Information System (SDWIS) database.
\ The getsystems, getqid, and getdownload end points are meant to be used together. \ The recommended use scenario for getsystems, getqid, and getdownoad is: \ 1) Use getsystems to validate passed query parameters, obtain summary statistics and to obtain a queryid (QID). QIDs are time sensitive and will be valid for approximately 30 minutes. 2) Use getqid, with the returned QID, to paginate through arrays of water system results. 3) Use getdownload, with the returned QID, to generate a Comma Separated Value (CSV) file of water system information that meets the QID query criteria. \ \ Use the qcolumns parameter to customize your search results. Use the Metadata service endpoint for a list of available output objects, their Column Ids, and their definitions to help you build your customized output. \ Additional ECHO Resources: Web Services, About ECHO's Data, Data Downloads

Actions

sdwrestservices.getdownload.get

Based on the QID obtained from a getsystems query, return a comma separated value (CSV) file of the water systems found.
epa_gov_sdw.sdw_rest_services.get_download.get({
  "qid": ""
}, context)

Input

  • input object
output string: Output Format Flag. Enter one of the following keywords: qid required string: Query ID Selector. Enter the QueryID number from a previously run query. qcolumns string: Used to customize service output. A list of comma-separated column IDs of output objects that will be returned in the service query object or download. Use the metadata service endpoint for a complete list of Ids and definitions.

Output

  • output file

sdwrestservices.getdownload.post

Based on the QID obtained from a getsystems query, return a comma separated value (CSV) file of the water systems found.
epa_gov_sdw.sdw_rest_services.get_download.post({
  "qid": ""
}, context)

Input

  • input object
output string: Output Format Flag. Enter one of the following keywords: qid required string: Query ID Selector. Enter the QueryID number from a previously run query. qcolumns string: Used to customize service output. A list of comma-separated column IDs of output objects that will be returned in the service query object or download. Use the metadata service endpoint for a complete list of Ids and definitions.

Output

  • output file

sdwrestservices.getqid.get

GETQID is passed with a query ID corresponding to a previously run getsystems query. It then returns a Systems object containing all matching water systems. The main purpose of GETQID is for large querysets that contain multiple pages (responsesets) of output. GETQID allows for pagination and for the selection and sorting of columns. 
epa_gov_sdw.sdw_rest_services.get_qid.get({
  "qid": ""
}, context)

Input

  • input object
 output string (values: JSONP, JSON, XML): Output Format Flag. Enter one of the following keywords: qid required string: Query ID Selector. Enter the QueryID number from a previously run query. pageno number: Indicates the number of the page to display. It is used only when the results are paginated. callback string: JSONP Callback. For use with JSONP and GEOJSONP output only. Enter a name of the function in which to wrap the JSON response. newsort number: Output Sort Column. Enter the number of the column on which the data will be sorted. If unpopulated results will sort on the first column. descending string (values: Y, N): Output Sort Column Descending Flag. Enter Y to column identified in the newsort parameter descending. Enter N to use ascending sort order. Used only when newsort parameter is populated. qcolumns string: Used to customize service output. A list of comma-separated column IDs of output objects that will be returned in the service query object or download. Use the metadata service endpoint for a complete list of Ids and definitions.

Output

  • output object: Root Object
Results required sdw02

sdwrestservices.getqid.post

GETQID is passed with a query ID corresponding to a previously run getsystems query. It then returns a Systems object containing all matching water systems. The main purpose of GETQID is for large querysets that contain multiple pages (responsesets) of output. GETQID allows for pagination and for the selection and sorting of columns. 
epa_gov_sdw.sdw_rest_services.get_qid.post({
  "qid": ""
}, context)

Input

  • input object
output string (values: JSONP, JSON, XML): Output Format Flag. Enter one of the following keywords: qid required string: Query ID Selector. Enter the QueryID number from a previously run query. pageno number: Indicates the number of the page to display. It is used only when the results are paginated. callback string: JSONP Callback. For use with JSONP and GEOJSONP output only. Enter a name of the function in which to wrap the JSON response. newsort number: Output Sort Column. Enter the number of the column on which the data will be sorted. If unpopulated results will sort on the first column. descending string (values: Y, N): Output Sort Column Descending Flag. Enter Y to column identified in the newsort parameter descending. Enter N to use ascending sort order. Used only when newsort parameter is populated. qcolumns string: Used to customize service output. A list of comma-separated column IDs of output objects that will be returned in the service query object or download. Use the metadata service endpoint for a complete list of Ids and definitions.

Output

  • output object: Root Object
 Results required sdw02

sdwrestservices.getsystems.get

Returns an array of public water systems that meet the specified search criteria.
epa_gov_sdw.sdw_rest_services.get_systems.get({}, context)

Input

  • input object
output string (values: JSONP, JSON, XML): Output Format Flag. Enter one of the following keywords: pfn string: Facility Name Filter. Enter one or more case-insensitive facility names to filter results. Provide multiple values as a comma-delimited list. See pfntype for additional modifiers. pct string: Facility City Filter. Enter a single case-insensitive city name to filter results. pco string: Facility County Filter. Provide a single county name in combination with a state value provided via pst. pfips string: FIPS Code Filter. Enter a single 5-character Federal Information Processing Standards (FIPS) state + county value to restrict results. E.g. to limit results to Kenosha County, Wisconsin, use 55059. pst string: Facility State and State-Equivalent Filter. Provide one or more USPS postal abbreviations for states and state-equivalents to filter results. Provide multiple values as a comma-delimited list. pzip string: 5-Digit ZIP Code Filter. Provide one or more 5-digit postal zip codes to filter results. May contain multiple comma-separated values. preg string (values: 01, 02, 03, 04, 05, 06, 07, 08, 09, 10): EPA Region Filter. Provide a single value of 01 thru 10 to restrict results to a single EPA region. ptrb string: Tribe name pact string (values: Y, N, A): Active Permits/Facilities Flag. Provide Y or N to filter results to facilities with active permits. pqiv string (values: 0, GT1, GT2, GT4, GT8, 12): Quarters in Noncompliance Limiter. Enter a coded value to limit results to facilities with given quarter of noncompliance. pico string (values: Y, N): Indian Country Flag. Enter a "Y" or "N" to restrict searches to facilities inside or outside Indian Country. ppid string: Nine-digit permit IDs. May contain up to 2000 comma-separated values. powop string (values: F, S, L, M, N, P): Owner/Operator code filter. Enter one of the following codes to filter results: psystyp string (values: CWS, NCWS, NTCWS, TNCWS): Type of public water system: pswtyp string (values: SW, GW, GU, SWP, GWP, GUP): Source Water Type: ppopsv string: Estimated average daily population served by a system: pcntysv string pcs string: Current violations: pmr string (values: Y, N): Monitoring and Reporting Violations (failure to conduct regular monitoring of drinking water quality or submit monitoring results in a timely fashion). phealth string (values: Y, N): Violations of health-based drinking water standards (maximum contaminant levels, maximum residual disinfectant levels, or treatment technique rules). pother string (values: Y, N): Other violations, such as failing to issue annual consumer confidence reports or maintain required records. ppn string (values: Y, N): Public Notice Violations (failure to immediately alert consumers of serious problem with drinking water). psv string (values: Y, N): Serious Violator (unresolved serious, multiple, and/or continuing violations). A value of Y will return only SDWIS systems that are Serious Violators, while a value of N will only return SDWIS Systems that are not Serious Violators. pqs string: Quick Search. Allows entry for city, state, and/or zip code. psfs string: Single Facility Search Filter. Provide a facility name or program system identifier to limit results. For the all data search, the FRS registry identifier is also searched. ppswpol string: For CWA, pollutant names for surface water discharges. for Drinking Water, SDWIS Violation contaminant codes for unaddressed violations that have occurred in the last 3 years. May contain multiple comma-separated values. ppswvio string (values: Y, N): Used in conjuction with parameters ppswpol and ppswparam, indicates whether search should only include pollutants with violations. ppbale string: Lead Action Level Exceedance. A "Y" value will select water systems with at least 1 Lead Action Level Exceedance. pcuale string: Copper Action Level Exceedance. A "Y" value will select water systems with at least 1 Copper Action Level Exceedance. prc350v string: Rule code 350 violation. A "Y" value will select water systems with at least one rule code 350 violation. ppbv string: Lead Violations. A "Y" value will select water systems with at least 1 Lead Violation. pcuv string: Copper Violation. A "Y" value will select water systems with at least 1 Copper Violation. plcrv string: Lead or Copper rule violations. A "Y" value will select water systems with at least 1 Lead or Copper Rule Violation. pfea string (values: W, N): Formal Enforcement Actions within / not within specified date range indicator. The date range is determined by parameters pfead1 and pfead2 or by parameter pfeay. pfeay number (values: 1, 2, 3, 4, 5): Years (1 to 5) Range. This value is used to create a date range for Formal Enforcement Actions (FEA). Used along with pfea (which indicates whether to look within or outside of the date range) to find FEAs within (or not within) the number of years specified. pfeaa string (values: A, E, S): Agency associated with Formal Enforcement Actions: piea string (values: W, N): Informal Enforcement Actions within / not within specified date range. The date range is determined by parameters piead1 and piead2 or by parameter pieay. pieay number (values: 1, 2, 3, 4, 5): Years (1 to 5) Range. This value is used to create a date range for Informal Enforcement Actions (IEA). Used along with piea (which indicates whether to look within or outside of the date range) to find IEAs within (or not within) the number of years specified. pieaa string (values: E, S): Agency associated with Informal Enforcement Actions. If left blank, both agencies are included. pqis string (values: Z, GE1, GT1, GE2, GT2, GE4, GT4, GE8, GT8, GE12, GT12, 12): Significant Quarters in Noncompliance Limiter. Enter one of the following codes to limit results to facilities having given quarters of noncompliance. ppfead1 string: Formal Enforcement Action Date Range Start. Enter a date in MM/DD/YYYY format to set the start of the range for filtering by recent Formal Enforcement Action (FEA) taken against the facility within the last five years. ppfead2 string: Formal Enforcement Action Date Range End. Enter a date in MM/DD/YYYY format to set the end of the date range for filtering by recent Formal Enforcement Action (FEA) taken against the facility within the last five years. ppfeat string: Formal Enforcement Action (FEA) Code Filter. Enter one or more three-letter FEA codes to restrict results to facilities with these attributes. Use pfead1 and pfead2 parameters to further restrict this filter by entering a date range. Provide multiple codes as a comma-delimited list. pss5yr string: Sanitary Surveys (in past 5 years) flag. Values of visitreasoncode are either "SNSV" or "SNSP" in the past 5 years indicate a Sanitary Survey.
psdc string: Significant Deficiency Count (in past 5 years) flag.
psdcils string pysl string (values: W, N, NV): Last Facility Inspection within / not within Specified Date Range Indicator. The date range is determined by parameters pidt1 and pidt2 or by parameter pysly. pysly string (values: 1, 2, 3, 4, 5): Number of years (1 to 5) since last facility inspection. A value of 1 means that it has been inspected within the year. pysla string (values: E, S, A): Facility Last Inspection Code Filter. If left blank, both agencies are included. Enter a value to limit results: pidt1 string: Beginning of date range of most recent facility inspection. pidt2 string: End of date range of most recent facility inspection. pcmsflag string queryset number: Query Limiter. Enter a value to limit the number of records returned for each query. Value cannot exceed 70,000. responseset number: Response Set Limiter. Enter a value to limit the number of records per page. Value cannot exceed 1,000. callback string: JSONP Callback. For use with JSONP and GEOJSONP output only. Enter a name of the function in which to wrap the JSON response. qcolumns string: Used to customize service output. A list of comma-separated column IDs of output objects that will be returned in the service query object or download. Use the metadata service endpoint for a complete list of Ids and definitions.

Output

  • output object: Root Object
 Results required sdw03

sdwrestservices.getsystems.post

Returns an array of public water systems that meet the specified search criteria.
epa_gov_sdw.sdw_rest_services.get_systems.post({}, context)

Input

  • input object
output string (values: JSONP, JSON, XML): Output Format Flag. Enter one of the following keywords: pfn string: Facility Name Filter. Enter one or more case-insensitive facility names to filter results. Provide multiple values as a comma-delimited list. See pfntype for additional modifiers. pct string: Facility City Filter. Enter a single case-insensitive city name to filter results. pco string: Facility County Filter. Provide a single county name in combination with a state value provided via pst. pfips string: FIPS Code Filter. Enter a single 5-character Federal Information Processing Standards (FIPS) state + county value to restrict results. E.g. to limit results to Kenosha County, Wisconsin, use 55059. pst string: Facility State and State-Equivalent Filter. Provide one or more USPS postal abbreviations for states and state-equivalents to filter results. Provide multiple values as a comma-delimited list. pzip string: 5-Digit ZIP Code Filter. Provide one or more 5-digit postal zip codes to filter results. May contain multiple comma-separated values. preg string (values: 01, 02, 03, 04, 05, 06, 07, 08, 09, 10): EPA Region Filter. Provide a single value of 01 thru 10 to restrict results to a single EPA region. ptrb string: Tribe name pact string (values: Y, N, A): Active Permits/Facilities Flag. Provide Y or N to filter results to facilities with active permits. pqiv string (values: 0, GT1, GT2, GT4, GT8, 12): Quarters in Noncompliance Limiter. Enter a coded value to limit results to facilities with given quarter of noncompliance. pico string (values: Y, N): Indian Country Flag. Enter a "Y" or "N" to restrict searches to facilities inside or outside Indian Country. ppid string: Nine-digit permit IDs. May contain up to 2000 comma-separated values. powop string (values: F, S, L, M, N, P): Owner/Operator code filter. Enter one of the following codes to filter results: psystyp string (values: CWS, NCWS, NTCWS, TNCWS): Type of public water system: pswtyp string (values: SW, GW, GU, SWP, GWP, GUP): Source Water Type: ppopsv string: Estimated average daily population served by a system: pcntysv string pcs string: Current violations: pmr string (values: Y, N): Monitoring and Reporting Violations (failure to conduct regular monitoring of drinking water quality or submit monitoring results in a timely fashion). phealth string (values: Y, N): Violations of health-based drinking water standards (maximum contaminant levels, maximum residual disinfectant levels, or treatment technique rules). pother string (values: Y, N): Other violations, such as failing to issue annual consumer confidence reports or maintain required records. ppn string (values: Y, N): Public Notice Violations (failure to immediately alert consumers of serious problem with drinking water). psv string (values: Y, N): Serious Violator (unresolved serious, multiple, and/or continuing violations). A value of Y will return only SDWIS systems that are Serious Violators, while a value of N will only return SDWIS Systems that are not Serious Violators. pqs string: Quick Search. Allows entry for city, state, and/or zip code. psfs string: Single Facility Search Filter. Provide a facility name or program system identifier to limit results. For the all data search, the FRS registry identifier is also searched. ppswpol string: For CWA, pollutant names for surface water discharges. for Drinking Water, SDWIS Violation contaminant codes for unaddressed violations that have occurred in the last 3 years. May contain multiple comma-separated values. ppswvio string (values: Y, N): Used in conjuction with parameters ppswpol and ppswparam, indicates whether search should only include pollutants with violations. ppbale string: Lead Action Level Exceedance. A "Y" value will select water systems with at least 1 Lead Action Level Exceedance. pcuale string: Copper Action Level Exceedance. A "Y" value will select water systems with at least 1 Copper Action Level Exceedance. prc350v string: Rule code 350 violation. A "Y" value will select water systems with at least one rule code 350 violation. ppbv string: Lead Violations. A "Y" value will select water systems with at least 1 Lead Violation. pcuv string: Copper Violation. A "Y" value will select water systems with at least 1 Copper Violation. plcrv string: Lead or Copper rule violations. A "Y" value will select water systems with at least 1 Lead or Copper Rule Violation. pfea string (values: W, N): Formal Enforcement Actions within / not within specified date range indicator. The date range is determined by parameters pfead1 and pfead2 or by parameter pfeay. pfeay number (values: 1, 2, 3, 4, 5): Years (1 to 5) Range. This value is used to create a date range for Formal Enforcement Actions (FEA). Used along with pfea (which indicates whether to look within or outside of the date range) to find FEAs within (or not within) the number of years specified. pfeaa string (values: A, E, S): Agency associated with Formal Enforcement Actions: piea string (values: W, N): Informal Enforcement Actions within / not within specified date range. The date range is determined by parameters piead1 and piead2 or by parameter pieay. pieay number (values: 1, 2, 3, 4, 5): Years (1 to 5) Range. This value is used to create a date range for Informal Enforcement Actions (IEA). Used along with piea (which indicates whether to look within or outside of the date range) to find IEAs within (or not within) the number of years specified. pieaa string (values: E, S): Agency associated with Informal Enforcement Actions. If left blank, both agencies are included. pqis string (values: Z, GE1, GT1, GE2, GT2, GE4, GT4, GE8, GT8, GE12, GT12, 12): Significant Quarters in Noncompliance Limiter. Enter one of the following codes to limit results to facilities having given quarters of noncompliance. ppfead1 string: Formal Enforcement Action Date Range Start. Enter a date in MM/DD/YYYY format to set the start of the range for filtering by recent Formal Enforcement Action (FEA) taken against the facility within the last five years. ppfead2 string: Formal Enforcement Action Date Range End. Enter a date in MM/DD/YYYY format to set the end of the date range for filtering by recent Formal Enforcement Action (FEA) taken against the facility within the last five years. ppfeat string: Formal Enforcement Action (FEA) Code Filter. Enter one or more three-letter FEA codes to restrict results to facilities with these attributes. Use pfead1 and pfead2 parameters to further restrict this filter by entering a date range. Provide multiple codes as a comma-delimited list. pss5yr string: Sanitary Surveys (in past 5 years) flag. Values of visitreasoncode are either "SNSV" or "SNSP" in the past 5 years indicate a Sanitary Survey.
psdc string: Significant Deficiency Count (in past 5 years) flag.
psdcils string pysl string (values: W, N, NV): Last Facility Inspection within / not within Specified Date Range Indicator. The date range is determined by parameters pidt1 and pidt2 or by parameter pysly. pysly string (values: 1, 2, 3, 4, 5): Number of years (1 to 5) since last facility inspection. A value of 1 means that it has been inspected within the year. pysla string (values: E, S, A): Facility Last Inspection Code Filter. If left blank, both agencies are included. Enter a value to limit results: pidt1 string: Beginning of date range of most recent facility inspection. pidt2 string: End of date range of most recent facility inspection. pcmsflag string queryset number: Query Limiter. Enter a value to limit the number of records returned for each query. Value cannot exceed 70,000. responseset number: Response Set Limiter. Enter a value to limit the number of records per page. Value cannot exceed 1,000. callback string: JSONP Callback. For use with JSONP and GEOJSONP output only. Enter a name of the function in which to wrap the JSON response. qcolumns string: Used to customize service output. A list of comma-separated column IDs of output objects that will be returned in the service query object or download. Use the metadata service endpoint for a complete list of Ids and definitions.

Output

  • output object: Root Object
 Results required sdw03

sdwrestservices.metadata.get

Returns the JSON Object Name and ColumnId for usage with the qcolumns parameter for getsystems endpoint.
epa_gov_sdw.sdw_rest_services.metadata.get({}, context)

Input

  • input object
output string (values: JSONP, JSON, XML): Output Format Flag. Enter one of the following keywords: callback string: JSONP Callback. For use with JSONP and GEOJSONP output only. Enter a name of the function in which to wrap the JSON response.

Output

  • output object: Root Object
Results required meta1

sdwrestservices.metadata.post

Returns the JSON Object Name and ColumnId for usage with the qcolumns parameter for getsystems endpoint.
epa_gov_sdw.sdw_rest_services.metadata.post({}, context)

Input

  • input object
output string (values: JSONP, JSON, XML): Output Format Flag. Enter one of the following keywords: callback string: JSONP Callback. For use with JSONP and GEOJSONP output only. Enter a name of the function in which to wrap the JSON response.

Output

  • output object: Root Object
Results required meta1

Definitions

meta1

  • meta1 object: Results Object
Message required string: Field to record messages (typically performance-related) about packet processing ResultColumns array
* items [meta3](#meta3)

meta3

  • meta3 object: Results Column Object
ColumnID required string ColumnName required string DataLength required string: Data length for EPA program database column. DataType required string: Data type for EPA program database column. Description required string ObjectName required string: The JSON name used for the database column.

sdw02

  • sdw02 object: Results Object
Message required string: Field to record messages (typically performance-related) about packet processing PageNo required string: The number of pages of results returned QueryID required string: Sequential number assigned to entire search result QueryRows required string: Number of query results returned WaterSystems array
* items [sdw04](#sdw04)

sdw03

  • sdw03 object: Results Object
 BadSystemIDs required string: Identifies which passed query system identifiers are invalid. CVRows required string: Summary count of the number of CWA facilities or SDWA public drinking water systems with current violations. FEARows required string: Summary count of the number of facilities with a formal enforcement action in the past five years INSPRows required string: Number of facilities with insp5yrflag populated (CWPDATELASTINSPECTION) IndianCountryRows required string: Number of facilities with tribalflag populated InfFEARows required string: Number of facilities with infea5yrflag populated (INFORMALENFACTCOUNT > 0) Message required string: Field to record messages (typically performance-related) about packet processing PageNo required string: The number of pages of results returned QueryID required string: Sequential number assigned to entire search result QueryRows required string: Number of query results returned SVRows required string: Number of facilities with currsvflag populated (CWPSTATUS = "Significant Violation") V3Rows required string: Number of facilities having one or more quarters in non-compliance (QNC) in the last three years Version required string: Version of the SDWA system service WaterSystems array
* items [sdw04](#sdw04)

sdw04

  • sdw04 object: Safe Drinking Water Search Results Object
 CitiesServed required string: County CountiesServed required string: City CuAle required string: The count of occurrences when 90th percentile sample concentrations of copper exceeded the copper action level of 1.3 mg/L in the past five years. CuViol required string: The number of copper violations in the last five years. CurrVioFlag required string: Indicates if the facility has a current violation. 1 = Yes DateLastSansurvey required string DfrUrl required string: The URL to the facility's Detailed Facility Report. EPARegion required string: The EPA region in which the facility is located FIPSCodes required string: Five-character Federal Information Processing Standards (FIPS) value: 2-character state || 3-character county FeaFlag required string: Number of formal enforcement responses during the past 5 years (20 most recent quarters) as of the last quarterly refresh. Formal enforcement actions compel a PWS to take specific actions by specific dates to return to compliance Feas required string: Number of formal enforcement responses during the past 5 years (20 most recent quarters) as of the last quarterly refresh. Formal enforcement actions compel a PWS to take specific actions by specific dates to return to compliance. GwSwCode required string: Returns "GW" if the system�source water type is ground water. Returns "SW" if the system source water type is surface water. HealthFlag required string: Indicates whether system has violations of health-based drinking water standards IeaFlag required string: Returns 0 if the system does not have informal enforcement actions in the past five years. Returns 1 if the system does have informal enforcement actions in the past five years. Ifea required string: Number of informal enforcement responses during the past 5 years (20 most recent quarters) as of the last quarterly refresh. Informal enforcement actions do not specify actions and deadlines for returning to compliance. IndianCountry required string: Indicates whether the facility is located in Indian Country Insp5yrFlag required string: Indicates if the facility has an inspection within the last 5 years. 1 = Yes LeadAndCopperViol required string: The number of lead and copper violations. MaxScore required string: A sorting score for internal use. MrFlag required string: Indicates whether system has monitoring and reporting violations NewVioFlg required string: Violations that have been reported to SDWA since end of the last official quarter. These violations are considered draft and do not reflect the official compliance status for the facility. OtherFlag required string: Indicates whether system has other violations, such as failing to issue annual consumer confidence reports or maintain required records OwnerDesc required string: Description of Owner code OwnerTypeCode required string: Owner/Operator: PWSActivityCode required string: Indicates whether systems have an active or inactive designation. PWSActivityDesc required string: Description of activity status code (ACT), e.g., active, inactive. PWSId required string: Unique identifying code for a public water system, consisting of a two-letter state or region code, followed by seven digits PWSName required string: Name of the system regulated under the Safe Drinking Water Act (SDWA) PWSTypeCode required string: Type of public water system: PWSTypeDesc required string: The type of public water system (PWS) and description of corresponding SystemType code. A public water system is a system for the provision to the public of piped water for human consumption, which has at least 15 service connections or regularly serves a PbAle required string: The count of occurrences when 90th percentile sample concentrations of lead exceeded the lead action level of 0.015 mg/L in the past five years. PbViol required string: The number of lead violations in the last five years. PnFlag required string: Indicates whether system has Public Notice Violations (failure to immediately alert consumers of serious problem with drinking water) PopulationServedCount required string: Estimated average daily population served by a system PrimarySourceCode required string: The source water type: PrimarySourceDesc required string: The source water type: QtrsWithSNC required string: The number of quarters the system was designated by EPA as a serious violator over the past 3 years (12 most recent quarters). QtrsWithVio required string: The number of quarters the system was in violation over the past three years. This includes the 12 most recent official quarters and new violations reported after the end of the last official quarter. Rc350Viol required string: The count of open health-based lead violations in the past five years. These include violations of maximum contaminant levels (MCLs), maximum residual disinfectant levels (MRDLs), or treatment technique (TT) rules. This count includes new violations that have been reported since the end of the last official quarter. RegistryID required string: An internal 12-digit Facility Registry Service (FRS) tracking number used to tie all facility data together in EPA regulatory program databases. RulesVio required string: The count of rules the system is violating as of the latest official quarter of data in the source system, SDWIS, which may lag by 3-6 months. This includes violations in the most recent official quarter and new violations reported after the end of the last official quarter. RulesVio3yr required string: The count of rules the system was in violation of over the past three years. This includes the 12 most recent official quarters and new violations reported after the end of the last official quarter. SDWA3yrComplQtrsHistory required string: The system's 3-year compliance status history by quarter (3-month period). Each character represents a quarter of compliance, going from oldest to most recent. Character values correspond to the following compliance statuses: SDWAContaminants required string: All unresolved violation contaminants or violation contaminants that have been resolved in the last 5 years. SDWAContaminantsInCurViol required string: The contaminant name and code (in SDWIS) in violation of a SDWA regulation. This includes violations in the most recent official quarter and new violations that have been reported since the end of the last official quarter. SDWAContaminantsInViol3yr required string: The contaminant name and code in violation of a SDWA regulation in the past three years SDWDateLastFea required string: Indicates the effective date of the most recent listed formal enforcement action taken against the PWS within the last five years. SDWDateLastFeaEPA required string: Indicates the effective date of the most recent listed formal enforcement action taken against the PWS by EPA within the last five years. SDWDateLastFeaSt required string: Indicates the effective date of the most recent listed formal enforcement action taken against the PWS by a state environmental agency within the last five years. SDWDateLastIea required string: Indicates the effective date of the most recent listed informal enforcement action taken against the PWS within the last five years. SDWDateLastIeaEPA required string: Indicates the effective date of the most recent listed informal enforcement action taken against the PWS by EPA within the last five years. SDWDateLastIeaSt required string: Indicates the effective date of the most recent listed informal enforcement action taken against the PWS by a state environmental agency within the last five years. SDWDateLastVisit required string: The date of the last system visit. SDWDateLastVisitEPA required string: The date of the last system visit by EPA. SDWDateLastVisitLocal required string: The date of the last system visit by a local agency. SDWDateLastVisitState required string: The date of the last system visit by a state agency. SNC required string: Indicates the system's compliance status: No Violation,�In Violation, Signficant Noncompliance, or Unknown. SNCFlag required string: Returns 1 if the system is in significant noncompliance (SNC); returns 0 if not. Sansurvey5yr required string: The number of sanitary surveys completed within the past five years. A sanitary survey is an on-site review of a system's water source, facilities, equipment, operation, and maintenance, intended to point out sanitary deficiencies and assess the system's capability to supply safe drinking water. SeriousViolator required string: Indicates whether system is a Serious Violator (has unresolved serious, multiple, and/or continuing violations that is designated as a priority candidate for formal enforcement) ServiceAreaTypeCode required string ServiceAreaTypeDesc required string SignificantDeficiencyCount required string: The number of significant deficiencies found from a sanitary survey within the past five years. SignificantDeficiencyCountIls required string SiteVisits5yrAll required string SiteVisits5yrInspections required string SiteVisits5yrOther required string StateCode required string: The state in which the system is located. TRIbalFlag required string: A flag indicating that the facility is within a tribal area. VioFlag required string: Indicates whether the system has been in violation in the past five years (1 if yes, 0 if no). Viofeanot required string: Sum of violation points accrued during past five years (20 most recent quarters) that are under formal enforcement but not yet returned to compliance, as of the last quarterly refresh ViolationCategories required string Viopaccr required string: Sum of all violation points for violations reported during the past five years (20 most recent quarters), as of the last quarterly refresh Vioremain required string: Sum of violation points that were not returned to compliance as of the last quarterly refresh. Includes points that have received formal enforcement but have not returned to compliance Viortcfea required string: Sum of violation points during past 5 years (20 most recent quarters) that received formal enforcement and returned to compliance, as of the last quarterly refresh Viortcnofea required string: Sum of violation points during past 5 years (20 most recent quarters) that did not receive formal enforcement but did return to compliance, as of the last quarterly refresh ZipCodesServed required string: ZIP code