Fw Follow-up on 2002 IUR database query

From: Hoffman.Wendy@epamail.epa.gov

Sent: Thursday, April 30, 2009 5:58 PM

To: Kristina Watts; Kimberly Wilson; john_bovay@abtassoc.com

Subject: Fw: Follow-up on 2002 IUR database query

I just got this from Darryl in IMD. Let me know if it's what you need.

Thanks -- Wendy

----- Forwarded by Wendy Hoffman/DC/USEPA/US on 04/30/2009 05:54 PM

-----

 

 Re: Follow-up on 2002 IUR database query (Document link: Wendy 

 Hoffman) 

 Darryl Ballard 

 to: 

 Wendy Hoffman 

 04/30/2009 05:41 PM 

Your queries contain overlapping ranges, so I am giving you the data in this 

table...

|--------------+------------+----------|

| RANGE | # REPORTS | # FORMS *|

|--------------+------------+----------|

| < 10K lbs |202 |92 |

|--------------+------------+----------|

| 10K - 25K lbs| | |

| |3,595 |882 |

|--------------+------------+----------|

| > 25K - 300K | | |

|lbs |8,548 |1,392 |

|--------------+------------+----------|

| > 300K lbs | | |

| |14,818 |2,304 |

|--------------+------------+----------|

| Total | | |

| |27,163 |2,927 |

|--------------+------------+----------|

* Not additive; a form may appear in several ranges

Note: Each IUR Site has its own Form #; therefore # Sites = # Forms

# Forms (Sites) with all reports have production < 25,000 lbs. : 107

If you have any questions or need anything else, please let me know.

Darryl Ballard

Acting Branch Chief

(202) 564-8958

Page 1
Fw Follow-up on 2002 IUR database query

|------------>

| From: |

|------------>

 

>-----------------------------------------------------------------------------------

----------------------------------------------------

-----|

 |Wendy Hoffman/DC/USEPA/US 

 |

 

>-----------------------------------------------------------------------------------

----------------------------------------------------

-----|

|------------>

| To: |

|------------>

 

>-----------------------------------------------------------------------------------

----------------------------------------------------

-----|

 |Darryl Ballard/DC/USEPA/US@EPA 

 |

 

>-----------------------------------------------------------------------------------

----------------------------------------------------

-----|

|------------>

| Date: |

|------------>

 

>-----------------------------------------------------------------------------------

----------------------------------------------------

-----|

 |04/29/2009 01:55 PM 

 |

 

>-----------------------------------------------------------------------------------

----------------------------------------------------

-----|

|------------>

| Subject: |

|------------>

 

>-----------------------------------------------------------------------------------

----------------------------------------------------

-----|

 |Follow-up on 2002 IUR database query 

 |

 

>-----------------------------------------------------------------------------------

----------------------------------------------------

-----|

Hi, Darryl -- I just heard back from my contractor, after they had a chance to look 

at the numbers you 

sent me for 2002 reports and forms. In order to do the analysis for the EA (the 

10,000 lb reporting 

threshold option), they need the following additional information:

Page 2
Fw Follow-up on 2002 IUR database query

The number of reports and sites for the following three production volume ranges:

1)The number of reports with production volume between 25,000 lbs and

300,000 lbs (we can't calculate that segment by subtracting what you gave us)

2) Number of sites (even if there are errors/duplicates) for reports with 

production volumes that are:

 a) between 10,000 lbs and 25,000 lbs

 b) between 25,000 lbs and 300,000 lbs

 3) Greater than 300,000 lbs

We do not need numbers of forms for these ranges.

Also, if this is doable, we also need the number of sites for which ALL reports 

submitted were for 

chemicals manufactured below the 25,000 lb threshold. This would allow us to 

estimate how many 

additional sites would need to complete the complete Part I as a result of the 

10,000 lb threshold 

option.

Thanks very much -- Wendy

tel. (202) 564-8794

fax: (202) 564-8893

email: hoffman.wendy@epa.gov

Page 3