Form 0920-1175 Community Drinking Water Monitoring Form

Form Approved

OMB No. 0920-1175

Exp. Date 04/30/2020

Data Dictionary for Data Submissions Drinking Water National Environmental Public Health Tracking Network
Characteristic	Description
Data Source	Safe Drinking Water Act/State Drinking Water Information System (SDWA/SDWIS),or SDWIS-like Data System
Purpose	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. 2. Drinking Water Quality Sampling Results.
Geographic Level	The smallest geographic unit to be represented in this data set is the county.
Restrictions	This is not a restricted access data set. Only registered users will have direct access to this data set via the national secure portal.
Instruction for Use	This data dictionary is a reference for creating the PWS Inventory data and Drinking Water Quality Sampling results data for submission. Refer to the dataset schemas for the order of variables and final data structure.

CDC estimates the average public reporting burden for this collection of information as 100 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 D-74, Atlanta, Georgia 30333; ATTN: PRA (0920-0853).

PWS Inventory Data Dictionary for Aggregate Data National Environmental Public Health Tracking Network
Field Name	Field Description	Data Type	Code Scheme	Legal Values	Field Length	Optional
Latitude	Latitude in NAD83 decimal degrees describing approximate center of retail service area of water system	Integer	00.0000000 to 90.000000, -99.99 for missing, -88.88 for Not Submitted	00.0000000 to 90.000000, -99.99 for missing, -88.88 for Not Submitted	10	Required
LocationDerivationCode	Code describing how approximate latitude/longitude location was derived	Text	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” for more guidance for deriving water system locations.)	Any of the codes in the Code Scheme column	3	Required
Longitude	Longitude in NAD83 decimal degrees describing approximate center of retail service area of water system	Integer	-180.000000 to 180.000000, -999 for Missing, -888 for Not Submitted	-180.000000 to 180.000000, -999 for Missing, -888 for Not Submitted	11	Required
PrimarySourceCode	Type of source	Text	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	Any of the codes in the Code Scheme column	3	Required
PrincipleCityFeatureID	Principal city, town or village Feature ID served by the CWS	Text	9999999999; -999 = Missing; -888 = Not Submitted Feature ID can be obtained from: http://geonames.usgs.gov/domestic/download_data.htm	9999999999, -999, -888	10	Required
PrincipleCountyServedFIPS	Principal county FIPS served by the CWS	String	County FIPS, U = Unknown, NS = Not submitted	Valid county FIPS, U, NS	5	Required
PWSIDNumber	PWS Identifier	String	XXnnnnnnn	Nine character value consisting of the 2 letter state abbreviation followed by 7 numbers	9	Required
PWSName	Name of PWS	Text	Any, U = Unknown, NS = Not Submitted	PWS Name, U, NS,	40	Required
StateFIPSCode	State FIPS code	String	FIPS	Valid state FIPS code	2	Required
SystemPopulation	Permanent population uniquely served by the CWS	Integer	10 - nnnnnnnn	10-99999999 ”	8	Required
TotalConnections	Number of residential service connections	Integer	1 - nnnnnnn	1-9999999”	7	Required
YearAssociatedTo	Year that these data are associated with regards to sampling results	Integer	YYYY	1999 through latest complete year	4	Required
YearPulled	Year that these data were pulled from state records	Integer	YYYY	1999 through latest complete year	4	Required

Drinking Water Quality Samples Data Dictionary for Aggregate Data National Environmental Public Health Tracking Network
Field Name	Field Description	Data Type	Code Scheme	Legal Values	Field Length	Optional
AggregationType	The type of summary operation performed (i.e. mean or max) for summary-level data.	Text	X = Mean Mean (for Annual and Quarterly data); MX = Maximum (For Annual Data ONLY) DO NOT SUBMIT FOR QUARTERLY DATA	X, MX	3	Required
AnalyteCode	USEPA Analyte code for required constituents (arsenic, nitrate, TTHM, HAA5, atrazine, PCE, TCE, DEHP, radium, and uranium)	String	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)	Any of the codes in the Code Scheme column	4	Required
Concentration	Reported summary-level concentration or reported concentration of sample	Integer	nnnnnn.nnnn	Reported summary-level concentration or reported concentration of sample	6,4	Required
ConcentrationUnits	The analyte-specific units of summary-level measures and individual sample values as reported in the Concentration and DetectionLimit fields. Each analyte has a standard unit for this dataset.	Text	“ug/L” allowed only for (Arsenic, TTHM, HAA5, Atrazine, DEHP, PCE,TCE, uranium); “mg/L” allowed only for (Nitrate as nitrogen); “pCi/L” allowed only for (Radium)	Ug/L, mg/L	6	Required
DateSampled	Date of sample (sample-level data) or Date last sampled (summary-level data)	Text	YYYY-MM-DD	A valid date from 1/1/1999 through December 31st of the latest complete year (e.g. 2011-12-31).	10	Required
DetectionLimit	Sample detection limit	Integer	>0 if NonDetectFlag=1 -888, if NonDetectFlag=0	>0, -888	3,6	Optional
NonDetectFlag	Flag to indicate whether sample resulted in a detection or not	Integer	1=Sample was a non-detect; 0=Sample was a detection	0, 1	1	Optional
NumNonDetects	The number of samples that were non-detections for summary-level data.	Integer	0 – nnnn (nnnn must be greater than NumSamples)	0 – 9999	4	Required
NumSamples	The number of samples that were used in calculating the mean/max for a given analyte during a quarter or year.	Integer	0 – nnnn	0 – 9999	4	Required
NumSamplingLocations	Number of compliance sampling locations available from which summary-level records were derived.	Integer	0 – nnnn; -888 = Not Submitted	0 – 9999, -888	4	Required
PWSIDNumber	PWS identifier	String	XXnnnnnnn	Nine character value consisting of the 2 letter state abbreviation followed by 7 numbers	9	Required
SamplePointID	Sampling station identifier for sample-level records only.	Text	Character ID for sampling station; -999 = missing; -888 = Not Submitted	Valid Character ID for sampling station, -999, -888	20	Optional
StateFIPSCode	State FIPS code	String	FIPS	Valid state FIPS code	2	Required
SummaryTimePeriod	Year or Quarter for summary-level data	String	YYYY for annual summarized values; YYYY-Q for quarterly summarized values (Allowed Only for AnalyteCodes 2050, 2456, 2950 and 1040)	1999 through most current year, Quarters 1-4 (Ex: 2018, 2018-4)	10	Required
Year	Year	Integer	YYYY	1999 – most current year	4	Required

Page 3 of 3