This document summarizes the occurence of CEC data in the eSMR dataset, and summarizes the associated permits. Data was obtained from the CIWQS Discoverer tool (from Rassam).

The original dataset includes data from 2001 and 2006 through 2016 (as well as dates labeled in years 1899, 1900, and 9999). The dataset summarized here was filtered to include monitoring data from 2008 through 2015.

eSMR Data

In the eSMR data, there were:


Table 1. Number of facilities that sampled for each constituent and total number of samples across the entire dataset.

Parameter Number of Facilities Total Number of Samples
Bis (2-Ethylhexyl) Phthalate 333 14,731
Di-n-butyl Phthalate 305 6,013
N-Nitrosodimethylamine 302 9,098
Butylbenzyl Phthalate 266 4,631
Diazinon 96 2,423
Chlorpyrifos 81 1,109
Dichlorodifluoromethane 79 2,491
1,2,3-Trichloropropane 57 937
Atrazine 43 266
Tert-Butyl Alcohol (TBA) 39 637
Tert-Amyl Methyl Ether (TAME) 35 449
Ethyl-Tert Butyl Ether (ETBE) 34 329


Table 2. Total number of facilities sampling for each constituent (from the table above) by Major and Minor facilitiy types.

Parameter Major Facilities Minor Facilities N/A Total
Bis (2-Ethylhexyl) Phthalate 215 117 1 333
Di-n-butyl Phthalate 201 103 1 305
N-Nitrosodimethylamine 203 98 1 302
Butylbenzyl Phthalate 174 91 1 266
Diazinon 74 22 0 96
Chlorpyrifos 62 19 0 81
Dichlorodifluoromethane 43 36 0 79
1,2,3-Trichloropropane 32 24 1 57
Atrazine 28 15 0 43
Tert-Butyl Alcohol (TBA) 14 24 1 39
Tert-Amyl Methyl Ether (TAME) 15 20 0 35
Ethyl-Tert Butyl Ether (ETBE) 15 19 0 34


Table 3. Number of facilities monitoring for each constituent by year.

2008 2009 2010 2011 2012 2013 2014 2015
Bis (2-Ethylhexyl) Phthalate 21 33 102 182 235 247 262 240
Di-n-butyl Phthalate 18 24 85 162 207 213 229 208
N-Nitrosodimethylamine 16 24 89 161 205 211 223 204
Butylbenzyl Phthalate 16 20 74 142 180 185 200 175
Diazinon 0 4 16 42 50 57 71 63
Chlorpyrifos 0 1 10 27 35 40 58 55
Dichlorodifluoromethane 3 7 20 26 35 42 45 36
1,2,3-Trichloropropane 0 5 11 26 34 33 38 32
Atrazine 0 2 7 9 12 15 26 18
Tert-Butyl Alcohol (TBA) 1 4 5 9 20 23 24 18
Tert-Amyl Methyl Ether (TAME) 1 2 6 10 19 19 20 14
Ethyl-Tert Butyl Ether (ETBE) 1 2 6 9 18 19 16 14



Figure 1. Number of facilities monitoring for each constituent by year (this shows the same information as the table above).



Figure 2. Number of facilities monitoring for each constituent by region. The numbers in the titles (n =) represent the total number of active facilities in each region.



Permit Types

To determine the types of permits associated with the CEC monitoring data, the ‘Reg_Meas_Id’ field associated with each sample in the eSMR data downloaded with the Discoverer tool was used to join the monitoring data with the permit data contained in the ‘Regulatory Measures’ flat file (reg_meas_export.csv), at: http://jasperreports/JasperReports/FlatFiles/

The ‘Regulatory Measures’ flat file contains fields labeled ‘REG MEASURE TYPE’ and ‘PROGRAM CATEGORY’ which both appear to contain information about the permit type associated with each sample. The following table lists the REG MEASURE TYPE / PROGRAM CATEGORY combinations found in the eSMR data associated with CECs.

Permit Type Count
Amendment / NPDESWW 75
Enrollee - NPDES / UNREGS 1
NPDES Permits / ANIMALWASTE 324
NPDES Permits / DOD 674
NPDES Permits / NPDESWW 41680
Reclamation Requirements / WDR 316
WDR / WDR 44

Based on this information, I attemped to classify the permits as either NPDES or WDR. Any of the entries in the table above containing the string ‘NPDES’ were first classified as NPDES, and any remaining entries containing the string ‘WDR’ were classified as WDR permits, with the following results:

Permit Type Count
NPDES 42754
WDR 360