Author: Abt Associates Inc.

Date Created:

Date Modified: 5/11/2011

Purpose: This file determines NPDES ID's for all manufacturer DQ Survey ID's.

File Contents:

Worksheet Contents

PCS-ICIS Contains NPDES ID's, states, and source database

Expiration Dates by 

Survey ID Crosswalks NPDES permit expiration date with DQ Survey ID

Expiration Dates by 

NPDES Provides permit expiration date for all NPDES permits

NPDES 

Determination Crosswalks NPDES ID with DQ survey ID

Missing NPDES Lists survey ID's who's NPDES ID could not be located in PCS-ICIS

NPDES for PCS Pull Contains list of NPDES ID's for PCS pull

Input Files:

External data used in calculations/analysis:

NPDES Facs with Cooling Water.xls

The original version of this file contains, or is linked to a file that contains, confidential business information (CBI), or information 

that could be used to reveal CBI. As a result, the values for any variables determined by EPA to be CBI, or that could be used to 

reveal CBI, have been concealed.
NPDES ID State Database CW in ICIS? State Database IDs in PCS IDs in ICIS

TXR05F763 TX PCS AK ICIS 136 97

TX0006289 TX PCS AL PCS

KY0001350 KY PCS AR ICIS

SC0036111 SC PCS AZ PCS

OH0006068 OH PCS CA ICIS

ORG753535 OR PCS CO ICIS

OR0001341 OR PCS CT ICIS

OR0000558 OR PCS DE PCS

LA0003522 LA PCS FL PCS

LA0029963 LA PCS GA ICIS

MI0004715 MI PCS HI ICIS

WV0005169 WV PCS IA PCS

ME0000175 ME PCS ID ICIS

LA0000418 LA PCS IL ICIS

KY0000388 KY PCS IN ICIS

OH0004774 OH PCS KS PCS

KY0095877 KY PCS KY PCS

WA0000124 WA PCS LA PCS

KY0002712 KY PCS MA ICIS

WYR000146 WY PCS MD ICIS

LA0005584 LA PCS ME PCS

WA0003492 WA PCS MI PCS

VA0029521 VA PCS MN PCS

KY0002305 KY PCS MO PCS

LA0103284 LA PCS MS PCS

LA0006131 LA PCS MT ICIS

LA0002950 LA PCS NC PCS

MI0000949 MI PCS ND PCS

NC0003298 NC PCS NE ICIS

KY0000086 KY PCS NH ICIS

SC0001759 SC PCS NJ PCS

KS0000761 KS PCS NM ICIS

SC0020506 SC PCS NV ICIS

ME0002020 ME PCS NY ICIS

LA0045683 LA PCS OH PCS

LA0007260 LA PCS OK ICIS

DE0000051 DE PCS OR PCS

AL0002682 AL PCS PA ICIS

LA0005738 LA PCS RI ICIS

NJ0001511 NJ PCS SC PCS

SC0000876 SC PCS SD ICIS

OR0001708 OR PCS TN ICIS

ME0002321 ME PCS TX PCS

NJ0000370 NJ PCS UT ICIS

SC0003557 SC PCS VA PCS

AL0002755 AL PCS VT PCS

TX0007536 TX PCS WA PCS

IA0001503 IA PCS WI ICIS

LA0005941 LA PCS WV PCS

WA0000540 WA PCS WY PCS

OR0000752 OR PCS VI ICIS
NPDES ID State Database CW in ICIS? State Database IDs in PCS IDs in ICIS

TX0006050 TX PCS

MI0002381 MI PCS

KS0000248 KS PCS

WV0004359 WV PCS

NJ0004448 NJ PCS

NJ0005401 NJ PCS

LA0054691 LA PCS

LA0006041 LA PCS

TX0007412 TX PCS

WA0003697 WA PCS

OH0010855 OH PCS

ME0002003 ME PCS

OH0002461 OH PCS

WA0003671 WA PCS

VA0003018 VA PCS

LA0003646 LA PCS

LA0020800 LA PCS

MI0003450 MI PCS

NJ0002283 NJ PCS

WA0000281 WA PCS

LA0056171 LA PCS

AL0000035 AL PCS

VA0003646 VA PCS

MN0055301 MN PCS

MN0002208 MN PCS

LA0007617 LA PCS

WA0000922 WA PCS

OH0101079 OH PCS

SC0000868 SC PCS

OH0004481 OH PCS

FL0002763 FL PCS

WV0003336 WV PCS

AL0003158 AL PCS

TX0099228 TX PCS

NC0003191 NC PCS

NC0000680 NC PCS

OH0000957 OH PCS

ND0000248 ND PCS

TX0000876 TX PCS

TX0124311 TX PCS

MN0001643 MN PCS

MS0002941 MS PCS

MS0036412 MS PCS

WA0000078 WA PCS

ME0002534 ME PCS

DE0000655 DE PCS

ME0000167 ME PCS

TX0088528 TX PCS

TX0000027 TX PCS

TX0061999 TX PCS

MN0001929 MN PCS
NPDES ID State Database CW in ICIS? State Database IDs in PCS IDs in ICIS

LA0005665 LA PCS

MI0042170 MI PCS

ME0021521 ME PCS

ND0000094 ND PCS

MS0000191 MS PCS

SC0038121 SC PCS

LA0000604 LA PCS

MI0000892 MI PCS

NC0000752 NC PCS

AL0000396 AL PCS

LA0056651 LA PCS

DE0000256 DE PCS

WA0051152 WA PCS

MI0000191 MI PCS

LA0003115 LA PCS

ME0002160 ME PCS

AL0002674 AL PCS

IA0003620 IA PCS

WV0002399 WV PCS

MI0001210 MI PCS

MS0031704 MS PCS

LA0000761 LA PCS

WV0000167 WV PCS

LA0079961 LA PCS

LA0003301 LA PCS

MN0000345 MN PCS

AL0000817 AL PCS

VA0000299 VA PCS

TX0004715 TX PCS

AL0055239 AL PCS

IA0063762 IA PCS

TX0006483 TX PCS

SC0001783 SC PCS

LA0000213 LA PCS

AR0001830 AR ICIS FALSE

CA0000787 CA ICIS FALSE

CA0004847 CA ICIS FALSE

CO0000621 CO ICIS FALSE

CT0000434 CT ICIS FALSE

CT0000957 CT ICIS FALSE

GA0000345 GA ICIS FALSE

GA0001104 GA ICIS FALSE

GA0001201 GA ICIS FALSE

GA0003646 GA ICIS FALSE

GA0004049 GA ICIS FALSE

GA0032620 GA ICIS FALSE

GA0047988 GA ICIS FALSE

GA0049336 GA ICIS FALSE

GA0049673 GA ICIS FALSE

HI0000116 HI ICIS FALSE

ID00035DD ID ICIS FALSE
NPDES ID State Database CW in ICIS? State Database IDs in PCS IDs in ICIS

IL0002526 IL ICIS FALSE

IL0002631 IL ICIS FALSE

IL0002640 IL ICIS FALSE

IL0003794 IL ICIS FALSE

IL0004073 IL ICIS FALSE

ILR000118 IL ICIS FALSE

IN0000108 IN ICIS FALSE

IN0001295 IN ICIS FALSE

MD0001341 MD ICIS FALSE

MD0001422 MD ICIS FALSE

NH0000230 NH ICIS FALSE

NH0001562 NH ICIS FALSE

NY0000191 NY ICIS FALSE

NY0001406 NY ICIS FALSE

NY0001406 NY ICIS FALSE

NY0001732 NY ICIS FALSE

NY0001775 NY ICIS FALSE

NY0001856 NY ICIS FALSE

NY0002143 NY ICIS FALSE

NY0002330 NY ICIS FALSE

NY0003336 NY ICIS FALSE

NY0004413 NY ICIS FALSE

NY0005525 NY ICIS FALSE

NY0006807 NY ICIS FALSE

NY0006912 NY ICIS FALSE

NY0008443 NY ICIS FALSE

PA0000124 PA ICIS FALSE

PA0002143 PA ICIS FALSE

PA0002551 PA ICIS FALSE

PA0004073 PA ICIS FALSE

PA0004472 PA ICIS FALSE

PA0007510 PA ICIS FALSE

PA0008869 PA ICIS FALSE

PA0008893 PA ICIS FALSE

PA0011096 PA ICIS FALSE

PA0011568 PA ICIS FALSE

PA0012572 PA ICIS FALSE

PA0012777 PA ICIS FALSE

PA0094510 PA ICIS FALSE

TN0002232 TN ICIS FALSE

UT0000647 UT ICIS FALSE

VI0000027 VI ICIS FALSE

WI0000540 WI ICIS FALSE

WI0001848 WI ICIS FALSE

AR0001210 AR ICIS TRUE

AR0035386 AR ICIS TRUE

CA0005053 CA ICIS TRUE

IL0002593 IL ICIS TRUE

IL0041009 IL ICIS TRUE

IL0061930 IL ICIS TRUE

IN0000027 IN ICIS TRUE
NPDES ID State Database CW in ICIS? State Database IDs in PCS IDs in ICIS

IN0000094 IN ICIS TRUE

IN0000175 IN ICIS TRUE

IN0000205 IN ICIS TRUE

IN0000281 IN ICIS TRUE

IN0001350 IN ICIS TRUE

IN0002101 IN ICIS TRUE

MA0003832 MA ICIS TRUE

MA0003905 MA ICIS TRUE

MT0000477 MT ICIS TRUE

NH0000655 NH ICIS TRUE

NY0001368 NY ICIS TRUE

NY0001643 NY ICIS TRUE

NY0108251 NY ICIS TRUE

PA0001562 PA ICIS TRUE

PA0002208 PA ICIS TRUE

PA0006327 PA ICIS TRUE

PA0012629 PA ICIS TRUE

TN0002259 TN ICIS TRUE

TN0002356 TN ICIS TRUE

TN0002640 TN ICIS TRUE

TN0002844 TN ICIS TRUE

VI0000019 VI ICIS TRUE

WI0000531 WI ICIS TRUE

WI0000825 WI ICIS TRUE

WI0003026 WI ICIS TRUE

WI0003620 WI ICIS TRUE

WI0003620 WI ICIS TRUE

WI0003671 WI ICIS TRUE

WI0026042 WI ICIS TRUE

0 0 #N/A #N/A
NPDES EXPIRATION YEARS

Survey ID 

(Westat/SAIC) Survey ID (Abt) NPDES Expiration Manual Notes

Final Expiration 

Date Year Month

TXR05F763, TX0006289 #N/A 200606

Used TX0006289 because no 

expiration date available for 

TXR05F763 200606 2006 06

NY0006912 200803 200803 2008 03

MT0000477 200810 200810 2008 10

KY0001350 200710 200710 2007 10

VI0000027 199508 199508 1995 08

SC0036111 200608 200608 2006 08

OH0006068 200602 200602 2006 02

ORG753535, OR0001341 #N/A 2003 and 2001 201000 2010 00

PA0011568 200802 200802 2008 02

OR0000558 200005 200005 2000 05

LA0003522 200709 200709 2007 09

LA0029963 200708 200708 2007 08

ILR000118 #N/A 201000 2010 00

ID00035DD #N/A 201000 2010 00

MI0004715 200610 200610 2006 10

WV0005169 200711 200711 2007 11

ME0000175 200407 200407 2004 07

LA0000418 200601 200601 2006 01

KY0000388 200603 200603 2006 03

OH0004774 200108 200108 2001 08

KY0095877 200208 200208 2002 08

IN0001350 199209 199209 1992 09

NY0001732 200703 200703 2007 03

WA0000124 199605 199605 1996 05

KY0002712 200208 200208 2002 08

WYR000146 200208 200208 2002 08

LA0005584 200611 200611 2006 11

WA0003492 198804 198804 1988 04

PA0008893 200608 200608 2006 08

PA0006327 200310 200310 2003 10

VA0029521 200805 200805 2008 05

NY0001775 200405 200405 2004 05

PA0001562 200612 200612 2006 12

KY0002305 200710 200710 2007 10

CA0004847 200804 200804 2008 04

LA0103284 200209 200209 2002 09

LA0006131 200807 200807 2008 07

LA0002950 200304 200304 2003 04

MI0000949 200610 200610 2006 10

IL0004073 199709 199709 1997 09

NH0000230 200512 200512 2005 12

UT0000647 200809 200809 2008 09

CO0000621 200810 200810 2008 10

NY0004413 200703 200703 2007 03

NC0003298 200111 200111 2001 11

CA0005053 200503 200503 2005 03

KY0000086 200405 200405 2004 05
NPDES EXPIRATION YEARS

Survey ID 

(Westat/SAIC) Survey ID (Abt) NPDES Expiration Manual Notes

Final Expiration 

Date Year Month

SC0001759 200804 200804 2008 04

KS0000761 200612 200612 2006 12

SC0020506 #N/A 201000 2010 00

ME0002020 200707 200707 2007 07

NY0001406 200705 200705 2007 05

AL0003018 #N/A 201000 2010 00

LA0045683 200409 200409 2004 09

IN0002101 200209 200209 2002 09

WI0000531 200306 200306 2003 06

NY0108251 200707 200707 2007 07

IN0000094 200105 200105 2001 05

PA0004073 200407 200407 2004 07

LA0007260 #N/A 201000 2010 00

NY0006807 200806 200806 2008 06

DE0000051 199409 199409 1994 09

WI0026042 200603 200603 2006 03

WI0000540 200312 200312 2003 12

AL0002682 200612 200612 2006 12

LA0005738 200401 200401 2004 01

AR0001830 200610 200610 2006 10

NJ0001511 199804 199804 1998 04

SC0000876 200608 200608 2006 08

OR0001708 200411 200411 2004 11

NY0002330 200902 200902 2009 02

ME0002321 200706 200706 2007 06

NY0001856 200409 200409 2004 09

IN0001295 199412 199412 1994 12

NJ0000370 200002 200002 2000 02

SC0003557 200409 200409 2004 09

AL0002755 200507 200507 2005 07

TX0007536 199410 199410 1994 10

AR0035386 200811 200811 2008 11

IA0001503 200409 200409 2004 09

PA0007510 200302 200302 2003 02

LA0005941 199610 199610 1996 10

WA0000540 200706 200706 2007 06

OR0000752 197707 200700

Expiration year is so old that I 

updated to 30 years later 200700 2007 00

TX0006050 200502 200502 2005 02

NY0000191 200502 200502 2005 02

MI0002381 200710 200710 2007 10

KS0000248 200412 200412 2004 12

NY0002143 200508 200508 2005 08

VI0000019 200108 200108 2001 08

WV0004359 200506 200506 2005 06

NJ0004448 199801 199801 1998 01

NJ0005401 200406 200406 2004 06

IN0000175 199308 199308 1993 08

GA0047988 200705 200705 2007 05

TN0002844 200407 200407 2004 07
NPDES EXPIRATION YEARS

Survey ID 

(Westat/SAIC) Survey ID (Abt) NPDES Expiration Manual Notes

Final Expiration 

Date Year Month

LA0054691 199205 199205 1992 05

LA0006041 199708 199708 1997 08

TX0007412 199609 199609 1996 09

WA0003697 200607 200607 2006 07

IL0002640 200203 200203 2002 03

PA0012777 200802 200802 2008 02

OH0010855 200310 200310 2003 10

ME0002003 200203 200203 2002 03

OH0002461 200310 200310 2003 10

WA0003671 199909 199909 1999 09

VA0003018 200501 200501 2005 01

IL0002526 200607 200607 2006 07

IL0003794 200407 200407 2004 07

LA0003646 200405 200405 2004 05

GA0003646 200804 200804 2008 04

IL0002631 200508 200508 2005 08

PA0002551 200112 200112 2001 12

CA0000787 200808 200808 2008 08

LA0020800 200412 200412 2004 12

NY0003336 200601 200601 2006 01

0 #N/A 201000 2010 00

CT0000434 200509 200509 2005 09

MI0003450 200610 200610 2006 10

NJ0002283 200105 200105 2001 05

PA0011096 200405 200405 2004 05

WA0000281 200806 200806 2008 06

LA0056171 200412 200412 2004 12

AL0000035 200409 200409 2004 09

AR0001210 199110 199110 1991 10

WI0003671 200503 200503 2005 03

NH0001562 199705 199705 1997 05

VA0003646 200702 200702 2007 02

TN0002640 200311 200311 2003 11

PA0002143 200301 200301 2003 01

MN0055301 200107 200107 2001 07

GA0049336 200206 200206 2002 06

MN0002208 200512 200512 2005 12

LA0007617 199811 199811 1998 11

WA0000922 200408 200408 2004 08

OH0101079 200701 200701 2007 01

SC0000868 200603 200603 2006 03

HI0000116 200505 200505 2005 05

TN0002232 200810 200810 2008 10

OH0004481 200403 200403 2004 03

FL0002763 200708 200708 2007 08

PA0094510 200612 200612 2006 12

CT0000957 199607 199607 1996 07

PA0004472 200612 200612 2006 12

WV0003336 200802 200802 2008 02
NPDES EXPIRATION YEARS

Survey ID 

(Westat/SAIC) Survey ID (Abt) NPDES Expiration Manual Notes

Final Expiration 

Date Year Month

NY0008443 200607 200607 2006 07

IN0000205 199109 199109 1991 09

AL0003158 200409 200409 2004 09

TX0099228 200602 200602 2006 02

NC0003191 200304 200304 2003 04

NH0000655 199901 199901 1999 01

NC0000680 200205 200205 2002 05

OH0000957 200610 200610 2006 10

ND0000248 200703 200703 2007 03

TX0000876TX0124311 #N/A 201000 2010 00

MN0001643 199610 199610 1996 10

MS0002941 200502 200502 2005 02

GA0032620 200803 200803 2008 03

MS0036412 200510 200510 2005 10

WA0000078 200608 200608 2006 08

GA0004049 200203 200203 2002 03

NY0001643 200409 200409 2004 09

GA0000345 200207 200207 2002 07

ME0002534 200606 200606 2006 06

DE0000655 200302 200302 2003 02

ME0000167 200209 200209 2002 09

WI0001848 200506 200506 2005 06

TX0088528TX0000027TX0061999 #N/A 201000 2010 00

IN0000108 199502 199502 1995 02

PA0002208 200608 200608 2006 08

WI0003026 200206 200206 2002 06

MN0001929 200806 200806 2008 06

PA0012629 200505 200505 2005 05

LA0005665 200808 200808 2008 08

MI0042170 200310 200310 2003 10

NY0001368 200706 200706 2007 06

MA0003832 200809 200809 2008 09

IL0002593 200203 200203 2002 03

ME0021521 200809 200809 2008 09

GA0001201 200307 200307 2003 07

ND0000094 200806 200806 2008 06

MS0000191 200802 200802 2008 02

SC0038121 200802 200802 2008 02

LA0000604 199711 199711 1997 11

WI0003620 200701 200701 2007 01

MI0000892 200610 200610 2006 10

NC0000752 200205 200205 2002 05

MD0001341 200701 200701 2007 01

AL0000396 200808 200808 2008 08

LA0056651 200801 200801 2008 01

MA0003905 199809 199809 1998 09

WI0003620 200701 200701 2007 01

DE0000256 200208 200208 2002 08

WA0051152 200001 200001 2000 01
NPDES EXPIRATION YEARS

Survey ID 

(Westat/SAIC) Survey ID (Abt) NPDES Expiration Manual Notes

Final Expiration 

Date Year Month

MD0001422 200604 200604 2006 04

TN0002356 200707 200707 2007 07

MI0000191 200010 200010 2000 10

LA0003115 199912 199912 1999 12

ME0002160 200003 200003 2000 03

AL0002674 200509 200509 2005 09

GA0001104 200208 200208 2002 08

IA0003620 200303 200303 2003 03

WV0002399 200611 200611 2006 11

MI0001210 200710 200710 2007 10

IN0000027 199102 199102 1991 02

MS0031704 200709 200709 2007 09

PA0012572 200311 200311 2003 11

LA0000761 199112 199112 1991 12

WV0000167 200606 200606 2006 06

GA0049673 #N/A 201000 2010 00

PA0000124 200607 200607 2006 07

LA0079961 200708 200708 2007 08

LA0003301 200611 200611 2006 11

WI0000825 200809 200809 2008 09

NY0005525 200610 200610 2006 10

MN0000345 200306 200306 2003 06

TN0002259 200409 200409 2004 09

AL0000817 200512 200512 2005 12

PA0008869 200510 200510 2005 10

IN0000281 199908 199908 1999 08

IL0041009 200103 200103 2001 03

VA0000299 200806 200806 2008 06

TX0004715 200109 200109 2001 09

AL0055239 200509 200509 2005 09

IA0063762 200502 200502 2005 02

IL0061930 200304 200304 2003 04

TX0006483 200607 200607 2006 07

SC0001783 200005 200005 2000 05

LA0000213 198707 198707 1987 07
Based on NPDES Pull from PCS done by Kim Ferzoco on 12/23/2003

NPDES ID EXPIRATION DATE

ALR320113 200303

AL0003158 200409

AL0002755 200507

AL0000035 200409

AL0000396 200808

AL0000817 200512

AL0002674 200509

AL0002682 200612

AR0001210 199110

AR0001830 200610

AR0035386 200811

CA0000787 200808

CA0004847 200804

CA0005053 200503

CO0000621 200810

CT0000957 199607

CT0000434 200509

DE0000051 199409

DE0000655 200302

DE0000256 200208

FLR05B628 200602

FLR05D058 200512

FLR10C836 200304

FLR10C988 200304

FLR10D076 200304

FL0002763 200708

GA0032620 200803

GA0003646 200804

GA0000345 200207

GA0049336 200206

GA0001201 200307

GA0047988 200705

GA0001104 200208

HI0000116 200505

IA0003620 200303

IA0001503 200409

IA0063762 200502

IA0071170 200511

IL0041009 200103

IL0002593 200203

IL0002640 200203

IL0061930 200304

IL0004073 199709

IL0002631 200508

IL0002526 200607

IL0003794 200407

IN0000205 199109

IN0000094 200105

IN0000027 199102

IN0000108 199502

IN0000281 199908

IN0061077 200607

IN0002101 200209

IN0000175 199308

IN0001350 199209

KS0000761 200612

KS0000248 200412

KY0001350 200710

KY0002305 200710

KY0000388 200603

KY0000086 200405

KYR100893 200709

KYR104237 200709

KY0095877 200208

KY0002712 200208

LA0000604 199711

LA0079961 200708

LAR10B884 200409
NPDES ID EXPIRATION DATE

LAR10C022 200409

LA0003646 200405

LA0003522 200709

LA0006131 200807

LA0005584 200611

LA0056651 200801

LA0007617 199811

LAR05M735 200604

LA0005738 200401

LAG670006 200801

LA0045683 200409

LA0054691 199205

LA0029963 200708

LAR10B899 200409

LAR10B978 200409

LA0005941 199610

LA0056171 200412

LAR10B920 200409

LA0006041 199708

LA0002950 200304

LA0000418 200601

LA0003115 199912

LA0003301 200611

LA0005665 200808

LA0000761 199112

LA0020800 200412

MA0003905 199809

MA0003832 200809

MD0001341 200701

MD0001422 200604

ME0002321 200706

ME0002003 200203

ME0002160 200003

ME0000167 200209

ME0000175 200407

ME0002020 200707

ME0002534 200606

ME0021521 200809

MI0003450 200610

MI0002381 200710

MI0004715 200610

MI0001210 200710

MI0000892 200610

MI0042170 200310

MI0000949 200610

MN0000345 200306

MN0001643 199610

MN0001929 200806

MN0055301 200107

MN0002208 200512

MS0036412 200510

MS0000191 200802

MS0042595 200807

MS0002941 200502

MS0031704 200709

MS0045501 200301

MTR000104 199411

MT0000477 200810

MT0028321 200206

NCS000211 200801

NC0003191 200304

NCS000106 199912

NC0000752 200205

NC0000680 200205

NCG040023 200303

NCS000101 200504

NC0003298 200111

ND0000094 200806

ND0000248 200703

NH0000230 200512
NPDES ID EXPIRATION DATE

NH0001562 199705

NH0000655 199901

NJ0001511 199804

NJ0026662 199103

NJ0026671 199103

NJ0005401 200406

NJ0002283 200105

NJ0000370 200002

NJ0110051 200705

NJ0004448 199801

NJ0139572 200705

NY0005525 200610

NY0004413 200703

NY0002143 200508

NY0001406 200705

NY0001775 200405

NY0001856 200409

NY0003336 200601

NY0001643 200409

NY0108251 200707

NY0001732 200703

NY0006912 200803

NY0002330 200902

NY0000191 200502

NY0001368 200706

NY0008443 200607

NY0006807 200806

OH0002461 200310

OH0010855 200310

OH0004774 200108

OH0101079 200701

OH0004481 200403

OH0006068 200602

OH0000957 200610

OR0001708 200411

ORG753538 200301

OR0000558 200005

ORG753535 200301

OR0001341 200107

PA0004472 200612

PA0002208 200608

PA0001562 200612

PA0002143 200301

PA0002551 200112

PA0008869 200510

PA0011533 200403

PA0012629 200505

PA0012777 200802

PA0011096 200405

PA0094510 200612

PA0000124 200607

PA0011568 200802

PA0006327 200310

PA0004073 200407

PA0012572 200311

PA0008893 200608

SC0038121 200802

SC0036111 200608

SC0000868 200603

SC0042960 200604

SC0000876 200608

SC0001783 200005

SC0001759 200804

SC0003557 200409

TN0002259 200409

TN0002640 200311

TN0002844 200407

TN0002356 200707

TN0002232 200810

TX0006483 200607
NPDES ID EXPIRATION DATE

TX0124915 200509

TX0006050 200502

TX0007536 199410

TX0006289 200606

TX0004715 200109

TX0007412 199609

TX0088528 200602

TX0000876 200405

TX0124311 200609

TX0099228 200602

TX0000027 200602

TX0061999 200602

UT0000647 200809

VA0000299 200806

VA0003646 200702

VA0029521 200805

VA0003018 200501

VI0000019 200108

VI0000027 199508

WA0000922 200408

WA0000540 200706

WA0000281 200806

WA0000078 200608

WA0000124 199605

WA0003492 198804

WA0003697 200607

WA0003671 199909

WA0051152 200001

WI0000540 200312

WI0000825 200809

WI0000531 200306

WI0001848 200506

WI0003671 200503

WI0026042 200603

WI0003026 200206

WI0003620 200701

WV0002313 200606

WV0002399 200611

WV0003336 200802

WV0000167 200606

WV0111732 200512

WV0005169 200711

WV0004359 200506

WV0077089 200607

WV0110051 200603

AL0055239 200509

GA0004049 200203

IN0001295 199412

LA0103284 200209

MI0000191 200010

OR0000752 197707

PA0007510 200302

WYR000146 200208

LA0000213 198707
NPDES DETERMINATIONS

Survey ID 

(Westat/SAIC) Survey ID (Abt) DQ Database DQ Database Adjusted Manual NPDES NOTES

0000TX00531 TXR05F763, TX0006289 TXR05F763, TX0006289

00NY0006912 NY0006912 NY0006912

00MT0000477 MT0000477 MT0000477

00KY0001350 KY0001350 KY0001350

00VI0000027 VI0000027 VI0000027

00SC0036111 SC0036111 SC0036111

00OH0006068 OH0006068 OH0006068

00000101409 ORG753535, OR0001341 ORG753535, OR0001341

00PA0011568 PA0011568 PA0011568

000R0000558 OR0000558 OR0000558

00LA0003522 LA0003522 LA0003522

00LA0029963 LA0029963 LA0029963

00ILR000118 ILR000118 ILR000118

00ID00035DD ID00035DD ID00035DD

00MI0004715 MI0004715 MI0004715

00WV0005169 WV0005169 WV0005169

00ME0000175 ME0000175 ME0000175

00LA0000418 LA0000418 LA0000418

00KY0000388 KY0000388 KY0000388

000H0004774 OH0004774 OH0004774

00KY0095877 KY0095877 KY0095877

00IN0001350 IN0001350 IN0001350

00NY0001732 NY0001732 NY0001732

00WA0000124 WA0000124 WA0000124

00KY0002712 KY0002712 KY0002712

00WYR000146 WYR000146 WYR000146

00LA0005584 LA0005584 LA0005584

00WA0003492 WA0003492 WA0003492

00PA0008893 PA0008893 PA0008893

00PA0006327 PA0006327 PA0006327

00VA0029521 VA0029521 VA0029521

00NY0001775 NY0001775 NY0001775

00PA0001562 PA0001562 PA0001562

00KY0002305 KY0002305 KY0002305

00CA0004847 CA0004847 CA0004847

00LA0103284 LA0103284 LA0103284

00LA0006131 LA0006131 LA0006131

00LA0002950 LA0002950 LA0002950

00MI0000949 MI0000949 MI0000949

00IL0004073 IL0004073 IL0004073

00NH0000230 NH0000230 NH0000230

00UT0000647 UT0000647 UT0000647

0CO-0000621 CO0000621 CO0000621

NY-000-4413 NY0004413 NY0004413

00NC0003298 NC0003298 NC0003298

00CA0005053 CA0005053 CA0005053
NPDES DETERMINATIONS

Survey ID 

(Westat/SAIC) Survey ID (Abt) DQ Database DQ Database Adjusted Manual NPDES NOTES

00KY0000086 KY0000086 KY0000086

00SC0001759 SC0001759 SC0001759

I-WA09-P002 KS0000761 KS0000761

00SC0020506 SC0020506 SC0020506

00ME0002020 ME0002020 ME0002020

00NY-001406 NY0001406 NY0001406

00AL0003018 AL0003018 AL0003018

00LA0045683 LA0045683 LA0045683

00IN0002101 IN0002101 IN0002101

00WI0000531 WI0000531 WI0000531

00NY0108251 NY0108251 NY0108251

00IN0000094 IN0000094 IN0000094

00PA0004073 PA0004073 PA0004073

00LA0007260 LA0007260 LA0007260

00NY0006807 NY0006807 NY0006807

00DE0000051 DE0000051 DE0000051

0WI00260425 WI0026042 WI0026042

WI0000540-6 WI0000540 WI0000540

00AL0002682 AL0002682 AL0002682

00LA0005738 LA0005738 LA0005738

00AR0001830 AR0001830 AR0001830

00NJ0001511 NJ0001511 NJ0001511

00SC0000876 SC0000876 SC0000876

99999999999 OR0001708 OR0001708

00NY0002330 NY0002330 NY0002330

00ME0002321 ME0002321 ME0002321

00NY0001856 NY0001856 NY0001856

00INR00I007 IN0001295 IN0001295

00NJ0000370 NJ0000370 NJ0000370

00SC0003557 SC0003557 SC0003557

00AL0002755 AL0002755 AL0002755

00TX0007536 TX0007536 TX0007536

00AR0035386 AR0035386 AR0035386

00005625100 IA0001503 IA0001503

00PA0007510 PA0007510 PA0007510

00LA0005941 LA0005941 LA0005941

0WA000054-0 WA0000540 WA0000540

77777777777 OR0000752 OR0000752

00TX0006050 TX0006050 TX0006050

00NY0000191 NY0000191 NY0000191

00MI0002381 MI0002381 MI0002381

00KS0000248 KS0000248 KS0000248

00NY0002143 NY0002143 NY0002143

00VI0000019 VI0000019 VI0000019

00WV0004359 WV0004359 WV0004359

00NJ0004448 NJ0004448 NJ0004448
NPDES DETERMINATIONS

Survey ID 

(Westat/SAIC) Survey ID (Abt) DQ Database DQ Database Adjusted Manual NPDES NOTES

00NJ0005401 NJ0005401 NJ0005401

00IN0000175 IN0000175 IN0000175

00NYR00A977 GA0047988 GA0047988

00TN0002844 TN0002844 TN0002844

00LA0054691 LA0054691 LA0054691

00LA0006041 LA0006041 LA0006041

00TX0007412 TX0007412 TX0007412

00WA0003697 WA0003697 WA0003697

00IL0002640 IL0002640 IL0002640

00PA0012777 PA0012777 PA0012777

00OH0010855 OH0010855 OH0010855

00ME0002003 ME0002003 ME0002003

00OH0002461 OH0002461 OH0002461

00WA0003671 WA0003671 WA0003671

00VA0003018 VA0003018 VA0003018

00IL0002526 IL0002526 IL0002526

00IL0003794 IL0003794 IL0003794

00LA0003646 LA0003646 LA0003646

00GA0003646 GA0003646 GA0003646

00IL0002631 IL0002631 IL0002631

00PA0002551 PA0002551 PA0002551

00CA0000787 CA0000787 CA0000787

00LA0020800 LA0020800 LA0020800

00NY0003336 NY0003336 NY0003336

0WIS0678571 0

00CT0000434 CT0000434 CT0000434

00MI0003450 MI0003450 MI0003450

00NJ0002283 NJ0002283 NJ0002283

00PA0011096 PA0011096 PA0011096

00WA0000281 WA0000281 WA0000281

00LA0056171 LA0056171 LA0056171

00AL0000035 AL0000035 AL0000035

00AR0001210 AR0001210 AR0001210

00WI0003671 WI0003671 WI0003671

00NH0001562 NH0001562 NH0001562

00VA0003646 VA0003646 VA0003646

00TN0002640 TN0002640 TN0002640

00PA0002143 PA0002143 PA0002143

00MN0055301 MN0055301 MN0055301

00GA0049336 GA0049336 GA0049336

00MN0002208 MN0002208 MN0002208

00LA0007617 LA0007617 LA0007617

00WA0000922 WA0000922 WA0000922

0003ID00071 OH0101079 OH0101079

00SC0000868 SC0000868 SC0000868

00HI0000116 HI0000116 HI0000116
NPDES DETERMINATIONS

Survey ID 

(Westat/SAIC) Survey ID (Abt) DQ Database DQ Database Adjusted Manual NPDES NOTES

00TN0002232 TN0002232 TN0002232

0IA00002*FD OH0004481 OH0004481

00FL0002763 FL0002763 FL0002763

00PA0094510 PA0094510 PA0094510

00CT0000957 CT0000957 CT0000957

00PA0004472 PA0004472 PA0004472

00WV0003336 WV0003336 WV0003336

00NY0008443 NY0008443 NY0008443

00IN0000205 IN0000205 IN0000205

00AL0003158 AL0003158 AL0003158

00TX0099228 TX0099228 TX0099228

00NC0003191 NC0003191 NC0003191

00NH0000655 NH0000655 NH0000655

00NC0000680 NC0000680 NC0000680

3ID00003*LD OH0000957 OH0000957

00ND0000248 ND0000248 ND0000248

000TX000876

TX0000876

TX0124311 TX0000876TX0124311

00MN0001643 MN0001643 MN0001643

00MS0002941 MS0002941 MS0002941

00GA0032620 GA0032620 GA0032620

00MS0036412 MS0036412 MS0036412

0WA000007-8 WA0000078 WA0000078

00GA0004049 GA0004049 GA0004049

0NY-0001643 NY0001643 NY0001643

00GA0000345 GA0000345 GA0000345

00ME0002534 ME0002534 ME0002534

00DE0000655 DE0000655 DE0000655

00ME0000167 ME0000167 ME0000167

00WI0001848 WI0001848 WI0001848

0TPDES00348

TX0088528

TX0000027

TX0061999 TX0088528TX0000027TX0061999

00IN0000108 IN0000108 IN0000108

00PA0002208 PA0002208 PA0002208

99999999999 WI0003026 WI0003026

MND06174809 MN0001929 MN0001929

00PA0012629 PA0012629 PA0012629

00LA0005665 LA0005665 LA0005665

00MI0042170 MI0042170 MI0042170

00NY0001368 NY0001368 NY0001368

00MA0003832 MA0003832 MA0003832

99999999999 IL0002593 IL0002593

00ME0021521 ME0021521 ME0021521

00GA0001201 GA0001201 GA0001201

0ND-0000094 ND0000094 ND0000094
NPDES DETERMINATIONS

Survey ID 

(Westat/SAIC) Survey ID (Abt) DQ Database DQ Database Adjusted Manual NPDES NOTES

00MS0000191 MS0000191 MS0000191

00SC0038121 SC0038121 SC0038121

00LA0000604 LA0000604 LA0000604

WI0003620-5 WI0003620 WI0003620 WI0003620

00MI0000892 MI0000892 MI0000892

00NC0000752 NC0000752 NC0000752

00MD0001341 MD0001341 MD0001341

00AL0000396 AL0000396 AL0000396

00LA0056651 LA0056651 LA0056651

00MA0003905 MA0003905 MA0003905

WI0003620-5 WI0003620 WI0003620

00DE0000256 DE0000256 DE0000256

00WA0051152 WA0051152 WA0051152

00MD0001422 MD0001422 MD0001422

00TN0002356 TN0002356 TN0002356

00MI0000191 MI0000191 MI0000191

00LA0003115 LA0003115 LA0003115

00ME0002160 ME0002160 ME0002160

00AL0002674 AL0002674 AL0002674

00GA0001104 GA0001104 GA0001104

00002326101 IA0003620 IA0003620

00WV0002399 WV0002399 WV0002399

00MI0001210 MI0001210 MI0001210

00IN0000027 IN0000027 IN0000027

00MS0031704 MS0031704 MS0031704

00PA0012572 PA0012572 PA0012572

0LAD0000761 LA0000761 LA0000761

00WV0000167 WV0000167 WV0000167

00GA0046973 GA0046973 GA0046973

00PA0000124 PA0000124 PA0000124

00LA0079961 LA0079961 LA0079961

00LA0003301 LA0003301 LA0003301

00WI0000825 WI0000825 WI0000825

00NY0005525 NY0005525 NY0005525

00MN0000345 MN0000345 MN0000345

00TN0002259 TN0002259 TN0002259

00AL0000817 AL0000817 AL0000817

00PA0008869 PA0008869 PA0008869

00IN0000281 IN0000281 IN0000281

00IL0041009 IL0041009 IL0041009

00VA0000299 VA0000299 VA0000299

00TX0004715 TX0004715 TX0004715

00AL0055239 AL0055239 AL0055239

00IA0063762 IA0063762 IA0063762

00IL0061930 IL0061930 IL0061930

00TX0006483 TX0006483 TX0006483
NPDES DETERMINATIONS

Survey ID 

(Westat/SAIC) Survey ID (Abt) DQ Database DQ Database Adjusted Manual NPDES NOTES

00SC0001783 SC0001783 SC0001783
Survey ID 

(Westat/SAIC)

Survey ID 

(Abt) Facility Name Address City State
Zip Utility Name NPDES Notes

TXR05F763, TX0006289

ORG753535, OR0001341

KS0000761 Address match

OR0001708 Address match

IN0001295 Address match

IA0001503 Address match

OR0000752 Name match

GA0047988

OH0101079 Name and Address match 

OH0004481 Name and Address match

OH0000957 Address match 

TX0000876

TX0124311

TX0088528

TX0000027

TX0061999

WI0003026 Name and Address match

MN0001929 Name match 

IL0002593 Name and Address match

IA0003620 Name and Address match

WI0003620 Address match
NPDES Notes

AL0027146

AR0036331

AR0037451

CA0001139

CA7000003

CO0000523

CO0000540

CO0000566

CO0001091

CO0001104

CT0000434

DC0000094

FL0036498

FL0183750

IA0003727

IA0060909

IL0000043

IL0002364

IL0004057

IL0036765

IN0004677

IN0052191

IN0055719

KS0078905

KS0079731

KS0079821

KY0000221

KY0001929

KY0002178

KY0022250

KY0040444

KY0041971

KY0054836

LA0000213

LA0042731

LA0062600

MA0001520

MA0002241

MA0004901

MD0000094

MI0003123

MI0005428

MI0026697

MN0000906

MN0002186

MN0002755

MN0003379

MN0045691

MO0004847

MS0000817

MT0000302

NC0005363

NC0038377

ND0024996

NJ0062391

NM0028606

NY0005207

NY0005932

NY0155519

NY0206938
NPDES Notes

OH0058378

OK0000094

OK0000108

OK0000477

OK0002429

OK0035327

PA0002062

PA0002941

PA0005011

PA0005037

SC0002064

SC0022471

SC0037401

SD0000264

TX0001015

TX0001155

TX0001627

TX0003590

TX0003611

TX0006386

TX0082651

TX0087815

UT0000094

UT0000116

VA0001015

VA0083097

VA0087645

WA0001546

WA0025151

WI0002925 double

WI0043583

WI0070785 double

WV0004731

WV0005304

WV0048500

WV0079235

WY0020311