Re: Source apportionment modeling files

Doug Boyer to: Erik Snyder, Zarena Post 03/09/2012 02:25 PM

Cc: "Dick Karp", "Jim Smith", "Stephen Davis", "Weining Zhao"

From: "Doug Boyer" <Doug.Boyer@tceq.texas.gov>

To: Erik Snyder/R6/USEPA/US@EPA, "Zarena Post" <Zarena.Post@tceq.texas.gov>

Cc: "Dick Karp" <Dick.Karp@tceq.texas.gov>, "Jim Smith" <Jim.Smith@tceq.texas.gov>, "Stephen 

Davis" <Stephen.Davis@tceq.texas.gov>, "Weining Zhao" <Weining.Zhao@tceq.texas.gov>

History: This message has been forwarded.

2 attachments

Hi Erik,

As we discussed this morning, attached are the design value component files for the Matagorda 

and Hood/Wise APCA runs (7-zipped). For each file the top group is the APCA baseline run 

and the bottom is the APCA future run (total or source category/region). The values not in 

brackets are used to calculate the RRF (future/base, 2nd to last column) and the DVf (last 

column). 

How did we calculate the contribution to the design value from APCA source 

regions/categories?

1. Our IDL procedures find the modeled daily eight-hour maxima and corresponding cell indices 

(i,j,hour) from the NxN cell array around each monitor from the APCA run's total hourly 

concentration output (base and future years). 

2. The future year APCA component ozone concentration files (e.g. Hood County or IC/BC) 

were read to extract the data at the same cell indices as above. The component data is also 

summed at this step to get accumulated source region/category totals.

3. The contribution to the future design values are then calculated as the (future 

component/total base)*(Observed Baseline Design Value). Or (Step 2/Step 1)*DVb.

If you want to get a little dirty, you can follow the formulas in the 

"Hood-Wise_DVf_Contribution_wPies.xlsx" file previously provided. I used the regular APCA 

output files that contain the NxN cell average rather than the maximum as in Step 1 above. I 

had to pick the days used in the standard DVf calculation and find the maximum modeled hour. 

I averaged those from the base and future to get the nominator and denominator of the RRF. 

You'll see that the final contribution to the DVf are quite close but not exact (avg vs max).

Confused yet? If so, let's talk again.
Doug

______________________________________

Doug Boyer

Texas Commission on Environmental Quality

Air Quality Division

(512) 239-1523

doug.boyer@tceq.texas.gov

Please consider the environment before printing this email

>>> Zarena Post 3/9/2012 7:56 AM >>>

Hi, Erik,

As we discussed yesterday, attached is a corrected version of the Matagorda_DVf_Contribution 

spreadsheet. I've appended "corrected" to the file name to distinguish it from the original.

Here is a summary of the changes in Matagorda contribution to various HGB monitors, as a 

result of corrections:

Matagorda contribution to MACP in 2006 goes from 1.05 to 0.70 ppb (Figure 26)

Matagorda contribution to HNWA in 2006 goes from 1.86 to 1.54 ppb (Figure 30)

Matagorda contribution to TXCT in 2006 goes from 1.63 to 0.55 ppb (Figure 32)

Matagorda contribution to WALV in 2006 remains unchanged at 0.46 ppb.

Let us know if you need anything else.

Thanks!

Zarena

>>> Erik Snyder <Snyder.Erik@epamail.epa.gov> 3/6/2012 4:14 PM >>>

That will work fine. I'll grab them first thing in the morning and let you know that I have them.

Thanks for the quick turnaround.

-Erik

Lead Regional Air Quality Modeler

EPA Region 6

Phone: 214-665-7305

Fax: 214-665-7263

email: snyder.erik@epa.gov
From: "Zarena Post" <Zarena.Post@tceq.texas.gov>

To: Erik Snyder/R6/USEPA/US@EPA

Cc: "Doug Boyer" <Doug.Boyer@tceq.texas.gov>, "Jim Smith" <Jim.Smith@tceq.texas.gov>, "Stephen Davis" 

<Stephen.Davis@tceq.texas.gov>, "Zhaohua Fang" <Zhaohua.Fang@tceq.texas.gov>

Date: 03/06/2012 03:32 PM

Subject: Re: Source apportionment modeling files

Hi, Erik, 

 

I've posted a bunch of APCA-related files on our FTP site that will mirror at 2 AM tomorrow 

morning - unless you want them sooner, just let us know pretty quick. 

 

The address will be ftp://amdaftp.tceq.texas.gov/pub/file_transfer/forEPA/ and within that 

directory will be a folder called "TCEQ Ozone TSD". You should be able to log in 

anonymously. I've included the APCA output files for both HGB and DFW; and 4 spreadsheets 

- 2 wavy bacon (one each for HGB and DFW) and 2 DVf contribution (one each for HGB and 

DFW). 

 

Let us know if you have any questions. 

 

Thanks! 

Zarena

>>> Erik Snyder <Snyder.Erik@epamail.epa.gov> 3/6/2012 11:43 AM >>>

Hi Zarena,

I am writing to request the supporting materials for the comments that TCEQ provided for the proposed 

designations area in Houston and Dallas. Could you provide the source original apportionment files from 

the modeling run (I believe they are csv format). Could you also provide the information used for the 

graphics supplied in the letter. When I looked at the time series plots of the source apportionment, it did 

not appear that the actual county was plotted in the graphics in the color pdf version we received. 

Due to our deadlines, we are trying to turn a summary of comments received around quickly and this 

information would help greatly in this process. 

Please call me to discuss or if you have any questions

Thanks,

Erik

Lead Regional Air Quality Modeler

EPA Region 6

Phone: 214-665-7305

Fax: 214-665-7263
email: snyder.erik@epa.gov