NJ EPHT Project Staff20080529Public Drinking Water Quality dataset for New Jersey: Compliance PeriodThis data set (NCDM_COMP_PRD) contains the information needed to calculate Environmental Public Health Tracking (EPHT) quarterly measures of contaminants in public water supplies for arsenic. Data are derived from State Drinking Water Act databases. The data set contains one record per compliance period for each community public water system (PWS). Population served and number of service connections are also available.;
;
This data set contributes to the Environmental Public Health Tracking Network. The EPHT cooperative aggreement 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 is one of three data sets that can be used to calculate the nationally consistent measures for water contaminants.1999010120061231Time Period End DateIn WorkAnnually-75.559791000000004-73.89398099999999741.35742700000000138.928767999999998FIPS 5-2 (State);New JerseyNONEhazarddrinking waterarsenicFIPS 5-2 (State)New JerseyNoneThese are aggregate summary measures of contaminant levels in finished water and the potential for population exposure and not true exposure estimates, therefore they should not be used in any epidemiologic investigations of health outcome and environmental linkages.;
;
NJ EPHT Project StaffNJ Department of HealthPhysical3635 Quakerbridge RoadMercervilleNJ08619United States Of America609-588-7495609-588-7599NJ.EPHT@doh.state.nj.usM-F; 9PM - 5PM ESTNoneNoneNoneData were extracted from the SDWIS database in to SAS format (ver.9.1, SP4) running on a Windows XP platformNoneData for all New Jersey Public Water Systems are complete and verified between January 1, 1999 and December 31, 2006. Missing data are indicated by the code "-999" in the appropriate fields.Cration of XML files successfully performed.20080528CWG DW Team released final version of programming code for generation of staging tables20080501NJDEP generated test staging tables using CWG DW Team SQL code.20080501NJDEP transferred test staging tables to NJDHSS EPHT20080502NJDHSS began test runs of CWG DW team SAS code to generate drinking water NCDM tables.20080513Creation of water NCDM tables successfully performed.20080516Var. Pos. Variable Name Variable Description;
10 ArsenicCompliancePeriod - 1=1999-2001, 2=2002-2004, 3=2005-2006;
11 ArsenicMeanConcentration - Mean arsenic concentration (ug/l);
1 PWSIdentifier - Water system identifier;
2 PWSNameText - Name of PWS;
9 PrimarySourceCode - SW=surface water, GW=groundwater, GU=groundwater under direct SW influence, GUP=purchased groundwater under direct SW influence, SWP=purchased surface water, GWP=purchased groundwater;
8 RetailPopulationServedValue - Number of persons served;
7 RetailServiceConnectionsValue - Number of service connections;
4 ServedCityText - City of service ;
3 ServedCountyText - County of service;
6 ServedStateCode - New Jersey;
5 StateFIPSCode - FIPS code for NJ;
Due to a decrease in the arsenic standard in New Jersey, in 2006, from 50ug/l to 5ug/l, data appear to indicate that arsenic levels throughout the state PWS have substantially decreased. This artifact is mostly attributed to an accompanying change in the regulatory practical quantitation limit (PQL). The PQL was decreased by an order of magnitude and resulted in a similar improvement in the limit of detection (LOD) of the analytical method and instrumentation in all regulated laboratories. Thus, the calculated average levels of As within the PWS before 2006 appear to be higher because with the methods used here data reported as "less than the LOD" were transformed into numbers by dividing the LOD by 2. This enables a computation of an average, but for high LODs the calculated averages are spuriously high.NJ EPHT Project StaffNJ Department of HealthPhysical3635 Quakerbridge RoadMercervilleNJ08619United States Of America609-588-7495609-588-7599NJ.EPHT@doh.state.nj.usM-F; 9PM - 5PM ESTName of SAS-generated data set NCDM_COMP_PRD;
;
Name of XML file NCDM_COMP_PRD.XML;
In preparation of data, every effort has been made to offer the most current, and correct data possible. Nevertheless, inadvertent errors in data may occur. The NJEPHTN and National EPHTN disclaim any responsibility for data errors and accuracy of the information that may be contained within the SDWIS/SDWA database. The state and national EPHTN also reserve the right to make changes at any time without notice. These data are distributed through the national environmental public health tracking portal.20080529NJ EPHT Project StaffNJ Department of HealthPhysical3635 Quakerbridge RoadMercervilleNJ08619United States Of America609-588-7495609-588-7599NJ.EPHT@doh.state.nj.usM-F; 9PM - 5PM ESTEPHTN Tracking Network Profile Version 1.2NoneNone