0920-1175 Data Dictionary – Drinking Water (Community Monitoring)

[NCEH] Environmental Public Health Tracking Network (Tracking Network)

Att4C Drinking Water Form

OMB: 0920-1175

Document [docx]
Download: docx | pdf

Data Dictionary – Drinking Water 7

Shape1

CDC estimates the average public reporting burden for this collection of information as 50 hours per response, including the time for reviewing instructions, searching existing data/information sources, gathering and maintaining the data/information needed, and completing and reviewing the collection of information. An agency may not conduct or sponsor, and a person is not required to respond to a collection of information unless it displays a currently valid OMB control number. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden to CDC/ATSDR Information Collection Review Office, 1600 Clifton Road NE, MS HS 21-8, Atlanta, Georgia 30333; ATTN: PRA (0920-1175).



Shape2

Form Approved

OMB No. 0920-1175

Exp. Date 07/31/2023

Data Dictionary – Drinking Water

`



Purpose and Use of this Document

This data set contributes to the Environmental Public Health Tracking Network. The EPHT cooperative agreement states that “by September 30, 2008 […all grantees must] track and make available core environmental health tracking measures on the State and National EPHT Network […including …] data/information on key water contaminants, as defined through the Content workgroup process.” The Content Workgroup Water Team identified initial contaminants of concern for the national EPHT program, identified nationally consistent data sources, and developed nationally consistent indicators and measures. This data set can be used to calculate the nationally consistent measures for the initial contaminants of concern.

This data set contains the information needed to calculate Environmental Public Health Tracking (EPHT) measures of contaminants in public water supply for arsenic, disinfection byproducts, nitrates, atrazine, di(2-ethylhexyl) phthalate (DEHP), radium, tetrachloroethene (tetrachloroethylene) (PCE), trichloroethene (trichloroethylene (TCE), and uranium. Data are derived from state Safe Drinking Water Act databases. The data set consists of two tables:

1. PWS Inventory. This file is required and contains descriptive and locational information about each public water system (PWS) with which water quality data is provided. This dataset should only include Community Water Systems (CWS) as defined and regulated by the Safe Drinking Water Act. It does not include Non-Transient Non-Community (NTNC) and Transient Non-Community water systems (TNC). There is one record for every year that a CWS was active, delivering drinking water to customers, and in which water quality data is complete. CWS that were once active and are currently inactive should be included if State's data support this scenario.

2. Drinking Water Quality Sampling Results. This file is required and contains one record for each community water system (CWS) for the mean and maximum concentrations per year of each of arsenic, disinfection byproducts (HAA5 and TTHM), nitrates, atrazine, di(2-ethylhexyl) phthalate (DEHP), radium, tetrachloroethene (tetrachloroethylene) (PCE), trichloroethene (trichloroethylene) (TCE), and uranium; and the mean concentrations per quarter of disinfection byproducts, nitrates and atrazine.





Version History V.18.1

18.0 This version has been updated to remove three sample level variables and any mention of sample level data throughout the document.

18.1 this version has added new analytes lead, PFOS and PFOA

Field Name

Description

[Insert info here]



Data Dictionary

PWS Inventory (all variables are required)

Field Name/Schema Name

Field Description

Format

Allowed Values

StateFIPSCode

State FIPS code

AN(2)

FIPS State Code

PWSIDNumber

PWS identifier

AN(9)

nine-character value consisting of the 2-letter state abbreviation followed by 7 numbers

YearAssociatedTo

Year data are associated to with regards to sampling results

Text(4)

YYYY. 1999 through latest complete year (e.g., 2021)

YearPulled

Year that these data were pulled from state records

Text(4)

YYYY. 1999 through latest year.

PWSName

Name of PWS

AN(40)

Any; “U” = Unknown; “NS” = Not submitted

PrincipalCountyServed FIPS

Principal county FIPS served by the CWS

AN(5)

Any; “U” = Unknown; “NS” = Not submitted

PrincipalCityFeatureID

Principal city, town or village Feature ID served by the CWS

N(10)


9999999999;”-999” for Missing; “-888” for Not Submitted

Feature ID can be obtained from: http://geonames.usgs.gov/domestic/download_data.htm

TotalConnections

Number of residential service connections

N(7)

1-9999999”

SystemPopulation

Permanent population uniquely served by the CWS

N(8)

10-99999999 ”

PrimarySourceCode

Type of water source

AN(3)

GU = ground water under direct influence of surface water, GUP = purchased ground water under direct influence of surface water, GW = ground water, GWP = purchased ground water, SW = surface water, SWP = purchased surface water; “U” = Unknown; “NS” = Not submitted

Latitude

Latitude in NAD83 decimal degrees describing approximate center of retail service area of water system

N(10)

00.0000000 to 90.000000;”-99.99” for Missing; “-88.88” for Not Submitted.

Longitude

Longitude in NAD83 decimal degrees describing approximate center of retail service area of water system

N(11)

-180.000000 to 180.000000;”-999” for Missing; “-888” for Not Submitted.

LocationDerivationCode

Code describing how approximate latitude/longitude location was derived

AN(3)

SA = Service area polygon centroid; MFL = Mean of 1 or more facility locations that are expected to be proximate to service area extent; PCS = GNIS coordinates for Principal City Served; GSH = The geocoded address of water system headquarters; PNS - GNIS coordinates for Principal County Served; O= Other (e.g., zip code, etc.)

-999” = Missing; “-888” = Not Submitted; (See “Appendix A. Service Area Location Derivation Guidance of the How-To Guide” on EPHTN Share Point site for more information & guidance for deriving water system locations.)


Drinking Water Quality Sampling Results

Field Name/Schema Name

Field Description

Format

Allowed Values

Required (Y/N)


PWSIDNumber


PWS identifier


AN(9)

Nine-character value consisting of the 2-letter state abbreviation followed by 7 numbers


Y

StateFIPSCode

State FIPS code

AN(2)

FIPS State Code

Y

Year

Year

Text(4)

YYYY; 1999 through latest complete year (e.g., 2011)

Y

AnalyteCode

USEPA Analyte code for required constituents (arsenic, nitrate, TTHM, HAA5, atrazine, PCE, TCE, DEHP, radium, uranium, lead, PFOS, PFOA).

N(4)

1005=Arsenic

2050=Atrazine

2456=HAA5

2950=TTHM

2039=DEHP

1040=Nitrate

2987=PCE

2984=TCE

4010=Combined Radium

226 & 228

4006=Uranium (see How-To-Guide for converting gross alpha particle activity to U in ug/L) 1030=Lead

2805=PFOS

2806=PFOA

Y

ConcentrationUnits

The analyte-specific units of summary-level measures as reported in the Concentration field. Each analyte has a standard unit for this dataset.

AN(6)

ug/L” allowed only for (Arsenic, TTHM, HAA5, Atrazine, DEHP, PCE,TCE, uranium, lead, PFOS, PFOA); “mg/L” allowed only for (Nitrate as nitrogen); “pCi/L” allowed only for (Radium)

Y

Concentration

Reported summary-level concentration

6.4


>0 for summary-level measure

Y

DateSampled

Date last sampled (summary-level data)

YYYY-MM-DD

A valid date from 1/1/1999 through December 31st of the latest complete year (e.g., 2011-12-31).

Y

AggregationType

Type of summary operation performed (i.e., mean or max) for summary-level data.

AN(3)

X” = Mean (for Annual and Quarterly data); “MX” = Maximum (For Annual Data ONLY; DO NOT SUBMIT FOR QUARTERLY DATA

90X = annual 90th percentile

Y

NumSamplingLocations

Number of compliance sampling locations from which summary-level records were derived.

N(4)

1-9999; “-888” for Not Submitted

Y

SummaryTimePeriod

Year or Quarter for summary-level data

AN(10)

YYYY for annual summarized values; YYYY-Q for quarterly summarized values Allowed Only for Analyte Codes 2050, 2456, 2950 and 1040

Y

NumSamples

Number of samples used in calculating the mean/max/90th percentile for a given analyte during a quarter or year.

N(4)

1-XXXX

Y

NumNonDetects

The number of samples that were non-detections for summary-level data.

N(4)

0-XXXX (XXXX must be no greater than NumSamples)

Y




CDC’s Environmental Public Health Tracking PRogram

Contact us: [email protected]

Visit the Tracking Network today: www.cdc.gov/ephtracking

Follow us on social media:

  • Twitter (@CDC_EPHTracking)

  • Facebook (facebook.com/CDCEPHTracking)


Centers for Disease Control and Prevention | Environmental Public Health Tracking Program

File Typeapplication/vnd.openxmlformats-officedocument.wordprocessingml.document
File TitleGeocoding-standards_Final_10.2018
AuthorTodd Roufs
File Modified0000-00-00
File Created2023-09-02

© 2024 OMB.report | Privacy Policy