## Page 1 of 33 

# DATA SUBSTITUTION ANALYSIS:
AQS SITE ID: 42-101-0024
POLLUTANT: OZONE (44201)

YEAR: 2009

CITY OF PHILADELPHIA

DEPARTMENT OF PUBLIC HEALTH

AIR MANAGEMENT SERVICES

3/29/10

## Page 2 of 33 Table of Contents

Summary.............................................................................. Page 3 Methodology............................................................................ Page 4 Analysis (Steps)........................................................................ Page 5 Appendix..................................................................... ......... Page 6 – 19 Appendix A: Figures................................................. ......... Page 7 – 9 Appendix B: Tables.............................................................. Page 10 – 18 Appendix C: Raw Data............................................ ......... Page 19 Appendix D: Correspondence with Andrew Hass, EPA Region III......... Page 20 – 33

## Page 3 of 33 Summary

During the 2009 Ozone Season, the failure of an exhaust fan pu mp resulted in significant

down time for the ozone monitor located at Northeast Airport in Philadelphia County
(NEA) (AQS Monitor ID 42-101-0024). Th e down time lasted from 9/16/2009 – 10/26/2009 (42 days) and resulted in 71% da ta collection during the ozone season. Section 2.3(b) of Appendix I to 40 CFR Part 50 requires three consecu tive years of data with data availability of at least 90% on av erage, with a minimum data completeness in any one year of at least 75%. Furt hermore, this section also states: “... When computing whether the minimum data completeness requirements have been met, meteorological or ambient data may be sufficient to demonstrate that meteorological conditions on missing days were not conducive to concentrations above the level of the standard. Missing days assumed less than the level of the standard are counted for the purpose of meeting the data completeness requirement, subject to the approval of th e appropriate Regional Administrator.”

The City of Philadelphia, Department of Public Health, Air Management Services (AMS), has analyzed the meteorological a nd ambient monitoring data for the 2009 Ozone

season and determined that the use of the nul l data code, “BG”, for the following 29 days is appropriate:

Dates Day Count

9/16/09 – 9/17/09 2

9/19/09 1

9/26/09 1

9/29/09 – 10/2/09 4

10/4/09 – 10/8/09 5

10/11/09 – 10/26/09 16

TOTAL 29

## Page 4 of 33 Methodology

AMS used a conservative approach to determ ine what missing days should be counted as valid days in regards to data completeness. Temperature plays a vital role in the formation of ozone. Ozone data and daily high temperature data from 1997 – 2008 were compiled for the NEA monitoring site to crea te a profile of maximum daily 8-hr ozone values at various temperatures during the ozone season (see Figure 1) . Ozone data prior

to the administration of the NOx SIP Call wa s used to demonstrate the conservative approach.

For the 2009 Ozone season, the 4 th 

## highest 8-hr ozone va lue at NEA was 0.072 ppm.

Based on the 4 th 

## highest value for 2009 and Figure 1, historical data shows that temperatures at or below 74F would not ex ceed 0.072 ppm. The temperature of 74F was chosen as it represents not only the maxi mum temperature but the maximum daily 8-hr

value that would not exceed the 4 th 

## highest value for 2009. In the initial analysis presented to Andrew Hass of EPA Region III, a temperature of 73F was chosen using

weather data from the Penn State web site
( http://climate.met.psu.edu/data/mesonet/datainv.php ). For the final analysis, data from the National Weather Service was used (see Ap pendix C). It is important to note that

AMS has chosen the 4 th 

## highest 8-hr ozone value as the level to count the missing days as opposed to “the level of the standard” as desc ribed in Section 2.3(b) of Appendix I to 40

CFR Part 50. The use of the 4 th 

## highest value continues the conservative approach used by AMS.

Table 1, shows the maximum daily 8-hr ozone data from the 2009 Ozone season. Monitors from neighboring counties of Philadelp hia (see Figure 2) were included. Cells highlighted in “orange” represented days when the NEA monitor was down. Cells highlighted in “orange” with an “X” represen t days that AMS deems appropriate for use in the data completeness calculation. These days are summarized below:

Dates Day Count

9/16/09 – 9/17/09 2

9/19/09 1

9/26/09 1

9/29/09 – 10/2/09 4

10/4/09 – 10/8/09 5

10/11/09 – 10/26/09 16

TOTAL 29

Cells highlighted in “yello w” represent the maximum daily 8-hr ozone value.

In addition to the meteorological data, ambient monitoring data from neighboring counties provide additional evidence that levels on the 29 days were well below the 4 th



## highest 8-hr ozone value at NEA. The maximum daily 8-hr ozone value for the 29 days was 0.048 ppm.

## Page 5 of 33 Analysis

Steps:
(1) Download ambient monitoring data from AQS (maximum daily 8-hr ozone values, AMP 435 Report).

a. The daily maximum 8-hr values are identified in column “Daily Max Sample Value” when the “Duration” column equals “8-HR RUN AVG

BEGIN HOUR”.

b. Data from the following sites were downloaded:

AQS SITE ID COUNTY, STATE SITE NAME PERIOD
42-101-0024 Philadelphia County, PA Northeast Airport 1997 – 2009
42-101-0004 Philadelphia County, PA AMS Lab 4/1/09 – 10/31/09
42-017-0012 Bucks County, PA Bristol 4/1/09 – 10/31/09
42-029-0100 Chester County, PA New Ga rden Airport 4/1/09 – 10/31/09
42-045-0002 Delaware County, PA Chester 4/1/09 – 10/31/09
42-091-0013 Montgomery County, PA Norristown 4/1/09 – 10/31/09
34-029-0006 Ocean County, NJ Colliers Mills 4/1/09 – 10/31/09
34-015-0002 Gloucester County, NJ Clarksboro 4/1/09 – 10/31/09
24-015-0003 Cecil County, MD Fair Hill 4/1/09 – 10/31/09



## c. Data was downloaded on 3/5/10, 3/8/10, 3/19/10.

d. See Figure 2. Ozone Monitors near Northeast Airport (42-101-0024).
(2) Download daily weather data from the National Weather Service at PHL airport.

a. 1997 – 2004 data: http://www.erh.noaa.gov/phi/localclimate.html#Archives

b. 2005 – 2009 data: http://www.weather.gov/c limate/index.php?wfo=phi

c. Data downloaded 3/26/10.
(3) During the ozone season (April 1 – Octobe r 31), create a pr ofile of maximum daily 8-hr ozone values versus temperature

a. Merge data from steps (1) and (2), to create a table of maximum daily 8-hr ozone value and count for each temperature.

b. See Figure 1. Maximum Daily 8-hr Ozone Concentration versus
Temperature
(4) Analyze 2009 Ozone data

a. Create a table of ambient monito ring and weather data for 2009.

b. Based on Figure 1, determine the maximum temperature (and
maximum 8-hr value) that falls below the 4 th 

## highest 8-hr ozone value

for 2009.

c. Based on (4)(b), identify days that should be counted towards data completeness.

d. See Table 1. 2009 Ozone Analysis.
(5) All data is provided on CD as an attachment.

## Page 6 of 33 

# APPENDIX

## Page 7 of 33 

# APPENDIX A: FiguresPage 8 of 33Figure 1. Maximum Daily 8-hr OzoneConcentration versus TemperatureMax Daily 8-hr O3 Concentration vs Temperatureat NEA (42-101-024)** weather data from PHL airport; April - October; 1997 - 2008 **0.0000.0200.0400.0600.0800.1000.1200.140 38 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101Temperature (F)

Max Daily 8-hr O3 Concentration (ppm)Max Daily 8-hr Ozone Value4th Highest 8-hr Ozone @ NEA (2009)Max temperature and max8-hr ozone value below 4thhighest 2009 8-hr Ozonevalue.Page 9 of 33Figure 2. Ozone Monitors Near Northeast Airport (42-101-0024)

## Page 10 of 33 

# APPENDIX B: TablesPage 11 of 33Table 1. 2009 Daily Maximum 8-hr Ozone DataDate Max Temp @ PHL airport, F (data from NOAA) NEA (Phila) 42-101-0024 LAB (Phila) 42-101-0004 Bristol (Bucks) 42-017-0012 New Garden Airport (Chester) 42-029-0100 Chester (Delaware) 42-045-0002 Norristown (Montgomery) 42-091-0013 Colliers Mills (Ocean County, NJ) 34-029-0006 Clarksboro (Gloucester County, NJ) 34-015-0002 Fair Hill (Cecil County, MD) 24-015-0003 Monitor down at NEA X Allow data based on weather and monitoring data max 8-hr value from regional monitors20090401 0.036 0.024 0.037 0.0330.037 0.022 0.043 0.034 0.0420090402 0.035 0.028 0.036 0.0380.033 0.029 0.039 0.036 0.0420090403 0.045 0.042 0.046 0.0470.044 0.042 0.046 0.048 0.04920090404 0.048 0.042 0.049 0.0510.049 0.045 0.049 0.051 0.05320090405 0.054 0.043 0.055 0.0550.052 0.05 0.056 0.054 0.05920090406 0.04 0.035 0.04 0.0420.04 0.029 0.043 0.041 0.04820090407 0.044 0.036 0.044 0.0450.045 0.037 0.043 0.044 0.04620090408 0.045 0.035 0.045 0.0480.045 0.038 0.045 0.046 0.05220090409 0.055 0.045 0.055 0.0560.054 0.047 0.055 0.057 0.0620090410 0.055 0.049 0.056 0.0580.059 0.042 0.056 0.063 0.06220090411 0.044 0.038 0.043 0.0430.043 0.038 0.047 0.041 0.04720090412 0.05 0.044 0.051 0.0480.049 0.043 0.051 0.049 0.05220090413 0.045 0.038 0.046 0.0460.046 0.04 0.047 0.047 0.04820090414 0.044 0.04 0.044 0.0420.038 0.036 0.054 0.048 0.04620090415 0.037 0.033 0.038 0.0360.034 0.033 0.051 0.047 0.04520090416 0.05 0.039 0.052 0.0490.048 0.047 0.051 0.047 0.052Page 12 of 3320090417 0.052 0.044 0.057 0.0560.055 0.055 0.058 0.058 0.0620090418 0.067 0.057 0.069 0.0640.063 0.066 0.071 0.068 0.04620090419 0.051 0.045 0.052 0.0560.051 0.052 0.051 0.05220090420 0.043 0.039 0.044 0.040.043 0.042 0.048 0.043 0.04220090421 0.043 0.034 0.045 0.0490.045 0.042 0.041 0.047 0.05420090422 0.031 0.025 0.031 0.0370.033 0.036 0.033 0.034 0.0420090423 0.042 0.034 0.043 0.0440.042 0.043 0.042 0.044 0.04720090424 0.058 0.046 0.06 0.0590.056 0.054 0.061 0.06 0.06420090425 0.063 0.051 0.068 0.0670.058 0.061 0.069 0.067 0.07620090426 0.062 0.05 0.064 0.0650.058 0.064 0.065 0.063 0.0720090427 0.064 0.047 0.067 0.0680.061 0.07 0.058 0.064 0.07220090428 0.068 0.048 0.073 0.0650.057 0.069 0.066 0.064 0.06720090429 0.046 0.035 0.044 0.0280.04 0.034 0.041 0.034 0.03220090430 0.048 0.037 0.05 0.0490.044 0.041 0.047 0.048 0.0520090501 0.024 0.019 0.028 0.0280.026 0.027 0.033 0.031 0.03420090502 0.039 0.028 0.039 0.040.035 0.04 0.037 0.035 0.03520090503 0.039 0.034 0.041 0.0340.041 0.031 0.042 0.039 0.03620090504 0.037 0.033 0.033 0.040.026 0.041 0.044 0.056 0.04220090505 0.036 0.031 0.035 0.0360.027 0.035 0.044 0.03 0.03920090506 0.038 0.03 0.039 0.0380.036 0.031 0.038 0.039 0.03820090507 0.027 0.018 0.03 0.0380.026 0.031 0.032 0.032 0.03120090508 0.059 0.039 0.061 0.0550.056 0.055 0.057 0.059 0.05920090509 0.056 0.041 0.059 0.0520.051 0.055 0.057 0.056 0.05720090510 0.043 0.037 0.045 0.0440.045 0.044 0.042 0.046 0.04820090511 0.034 0.023 0.036 0.030.029 0.036 0.039 0.032 0.03220090512 0.049 0.04 0.051 0.0510.049 0.053 0.052 0.049 0.05520090513 0.062 0.052 0.061 0.0630.061 0.057 0.059 0.063 0.06520090514 0.044 0.034 0.047 0.0440.044 0.037 0.048 0.046 0.04820090515 0.046 0.032 0.046 0.0530.043 0.056 0.048 0.045 0.055Page 13 of 3320090516 0.031 0.021 0.031 0.0320.03 0.031 0.028 0.032 0.03220090517 0.044 0.041 0.044 0.0370.039 0.045 0.043 0.043 0.04120090518 0.043 0.036 0.044 0.0450.043 0.047 0.046 0.046 0.04920090519 0.049 0.036 0.055 0.0550.05 0.053 0.049 0.053 0.06120090520 0.059 0.05 0.065 0.0650.063 0.067 0.07 0.062 0.06820090521 0.058 0.045 0.064 0.060.056 0.064 0.064 0.059 0.06220090522 0.06 0.044 0.063 0.0650.056 0.062 0.064 0.061 0.06820090523 0.063 0.036 0.065 0.0490.046 0.061 0.059 0.05 0.05220090524 0.048 0.035 0.051 0.0420.039 0.051 0.043 0.043 0.04520090525 0.057 0.048 0.063 0.0560.063 0.058 0.069 0.066 0.05820090526 0.039 0.032 0.038 0.0360.037 0.038 0.042 0.041 0.03920090527 0.031 0.021 0.03 0.0260.026 0.026 0.032 0.031 0.02520090528 0.024 0.02 0.024 0.0280.021 0.023 0.028 0.023 0.02920090529 0.026 0.018 0.025 0.0340.03 0.033 0.028 0.03 0.03720090530 0.054 0.045 0.056 0.0540.055 0.058 0.057 0.06 0.05620090531 0.059 0.047 0.061 0.0550.057 0.061 0.063 0.062 0.05620090601 0.048 0.035 0.051 0.0470.046 0.05 0.048 0.048 0.0520090602 0.061 0.045 0.064 0.0450.054 0.062 0.069 0.057 0.05220090603 0.041 0.034 0.043 0.0410.042 0.041 0.05 0.048 0.04720090604 0.033 0.028 0.029 0.0290.034 0.03 0.042 0.03 0.0320090605 0.037 0.028 0.036 0.0330.023 0.034 0.046 0.037 0.03420090606 0.047 0.032 0.049 0.0420.044 0.047 0.052 0.049 0.04520090607 0.068 0.05 0.068 0.0570.056 0.065 0.056 0.058 0.0620090608 0.064 0.044 0.056 0.0540.054 0.063 0.056 0.054 0.05320090609 0.033 0.021 0.034 0.0350.035 0.021 0.038 0.04 0.03920090610 0.041 0.031 0.037 0.0660.043 0.043 0.029 0.045 0.06420090611 0.02 0.015 0.018 0.0230.022 0.019 0.029 0.019 0.02820090612 0.048 0.034 0.046 0.0440.046 0.048 0.051 0.049 0.04620090613 0.04 0.032 0.039 0.0430.036 0.042 0.039 0.037 0.049Page 14 of 3320090614 0.046 0.037 0.047 0.0410.041 0.045 0.038 0.047 0.04420090615 0.049 0.038 0.051 0.0490.046 0.051 0.036 0.052 0.04820090616 0.038 0.03 0.04 0.0310.034 0.036 0.036 0.031 0.0320090617 0.027 0.019 0.028 0.0250.027 0.026 0.027 0.025 0.02520090618 0.034 0.025 0.036 0.0290.035 0.03 0.039 0.036 0.03120090619 0.036 0.027 0.036 0.0410.039 0.04 0.04 0.042 0.04220090620 0.032 0.028 0.032 0.0350.034 0.036 0.037 0.037 0.03720090621 0.029 0.027 0.029 0.0310.032 0.035 0.03 0.033 0.03220090622 0.03 0.025 0.029 0.0370.03 0.035 0.034 0.026 0.03820090623 0.042 0.032 0.039 0.0430.041 0.046 0.045 0.043 0.04420090624 0.037 0.029 0.031 0.0460.042 0.043 0.035 0.041 0.04820090625 0.065 0.051 0.069 0.0630.064 0.065 0.045 0.072 0.06820090626 0.075 0.059 0.076 0.0780.072 0.071 0.067 0.076 0.08320090627 0.043 0.03 0.042 0.0390.04 0.044 0.045 0.046 0.04320090628 0.045 0.036 0.045 0.0440.043 0.047 0.052 0.048 0.04620090629 0.055 0.043 0.055 0.0530.053 0.058 0.06 0.06 0.05320090630 0.056 0.039 0.055 0.0560.052 0.052 0.055 0.057 0.05720090701 86 0.064 0.057 0.067 0.0540.057 0.062 0.06 0.066 0.05620090702 83 0.056 0.041 0.057 0.0470.048 0.057 0.065 0.056 0.04720090703 82 0.041 0.03 0.042 0.0390.04 0.044 0.042 0.044 0.03920090704 83 0.04 0.033 0.041 0.0450.045 0.044 0.042 0.048 0.04720090705 80 0.045 0.038 0.052 0.0440.049 0.047 0.055 0.054 0.04620090706 85 0.039 0.049 0.058 0.0540.054 0.057 0.06 0.059 0.05820090707 880.051 0.057 0.06 0.061 0.067 0.059 0.067 0.06420090708 800.027 0.038 0.035 0.038 0.04 0.04 0.04 0.03620090709 810.039 0.046 0.047 0.05 0.049 0.04 0.046 0.04920090710 830.046 0.06 0.06 0.062 0.06 0.054 0.053 0.06120090711 820.04 0.053 0.045 0.046 0.05 0.054 0.05 0.04620090712 860.035 0.046 0.046 0.047 0.049 0.047 0.048 0.049Page 15 of 3320090713 840.044 0.058 0.054 0.052 0.061 0.044 0.053 0.05420090714 840.04 0.051 0.053 0.053 0.055 0.053 0.055 0.05220090715 870.059 0.077 0.069 0.07 0.075 0.071 0.07 0.07220090716 910.051 0.074 0.057 0.061 0.07 0.08 0.066 0.07720090717 880.047 0.058 0.053 0.057 0.054 0.06 0.06 0.05520090718 830.037 0.047 0.044 0.047 0.048 0.051 0.051 0.04520090719 840.035 0.044 0.042 0.044 0.046 0.046 0.051 0.04420090720 0.063 0.052 0.063 0.0640.06 0.065 0.058 0.058 0.05820090721 0.031 0.028 0.033 0.0340.034 0.036 0.04 0.036 0.03720090722 0.057 0.047 0.053 0.0540.053 0.058 0.044 0.055 0.04820090723 0.033 0.031 0.032 0.0310.029 0.037 0.038 0.034 0.02620090724 0.055 0.042 0.057 0.0480.05 0.057 0.055 0.058 0.0520090725 0.061 0.048 0.057 0.0540.053 0.061 0.053 0.057 0.05620090726 0.058 0.046 0.057 0.0540.049 0.059 0.05 0.055 0.05420090727 0.056 0.041 0.056 0.0560.047 0.053 0.045 0.049 0.05920090728 0.058 0.046 0.054 0.0530.048 0.058 0.051 0.051 0.04820090729 0.046 0.034 0.044 0.040.041 0.045 0.047 0.044 0.04520090730 0.055 0.048 0.054 0.0530.053 0.058 0.057 0.059 0.05420090731 0.042 0.031 0.045 0.0370.039 0.042 0.042 0.041 0.04220090801 0.06 0.054 0.058 0.050.054 0.06 0.05 0.052 0.04520090802 0.033 0.028 0.034 0.036 0.037 0.033 0.034 0.03720090803 860.05 0.065 0.058 0.055 0.06 0.069 0.062 0.05420090804 890.046 0.063 0.05 0.05 0.061 0.055 0.053 0.05120090805 0.064 0.052 0.065 0.0540.057 0.061 0.07 0.067 0.05620090806 0.022 0.031 0.035 0.0340.03 0.046 0.03 0.024 0.03420090807 0.029 0.034 0.042 0.0430.043 0.046 0.043 0.045 0.04320090808 0.028 0.053 0.057 0.060.065 0.058 0.045 0.058 0.05820090809 0.042 0.033 0.046 0.040.045 0.041 0.047 0.05 0.04420090810 0.061 0.049 0.062 0.0510.055 0.062 0.069 0.067 0.052Page 16 of 3320090811 0.056 0.046 0.057 0.0540.055 0.058 0.061 0.059 0.05520090812 0.047 0.041 0.044 0.0490.045 0.044 0.047 0.048 0.05120090813 0.034 0.031 0.034 0.0410.029 0.03 0.036 0.036 0.04620090814 0.064 0.057 0.064 0.0490.063 0.056 0.055 0.071 0.04920090815 0.084 0.072 0.073 0.0590.07 0.068 0.061 0.067 0.06520090816 0.073 0.063 0.074 0.0580.064 0.07 0.072 0.074 0.06520090817 0.072 0.058 0.071 0.060.063 0.071 0.085 0.069 0.06120090818 0.068 0.052 0.063 0.060.054 0.059 0.052 0.054 0.07120090819 0.063 0.048 0.063 0.0560.052 0.057 0.062 0.058 0.06620090820 0.049 0.035 0.039 0.0390.043 0.047 0.041 0.041 0.04320090821 0.041 0.028 0.035 0.0330.033 0.037 0.039 0.035 0.03920090822 0.033 0.023 0.025 0.0360.038 0.035 0.021 0.037 0.03820090823 0.042 0.036 0.04 0.0390.041 0.044 0.04 0.047 0.04220090824 0.045 0.04 0.044 0.0430.047 0.046 0.047 0.048 0.04520090825 0.05 0.043 0.046 0.0430.049 0.049 0.051 0.055 0.04820090826 0.069 0.058 0.067 0.0560.057 0.07 0.071 0.061 0.05520090827 0.026 0.025 0.023 0.0440.037 0.032 0.026 0.039 0.04620090828 0.032 0.027 0.031 0.0320.034 0.035 0.036 0.035 0.03320090829 0.023 0.021 0.026 0.0290.027 0.027 0.029 0.031 0.03220090830 0.049 0.041 0.049 0.0440.046 0.053 0.05 0.051 0.04520090831 0.027 0.02 0.023 0.0250.027 0.032 0.024 0.025 0.02720090901 76 0.043 0.038 0.036 0.0390.041 0.04 0.04 0.035 0.03820090902 79 0.058 0.052 0.055 0.0610.058 0.053 0.053 0.054 0.06420090903 80 0.048 0.043 0.043 0.0550.048 0.054 0.04 0.044 0.05520090904 84 0.051 0.041 0.049 0.0460.051 0.051 0.06 0.055 0.04720090905 85 0.053 0.046 0.046 0.0490.052 0.054 0.049 0.054 0.05120090906 78 0.033 0.028 0.03 0.0420.034 0.041 0.027 0.032 0.04420090907 76 0.03 0.026 0.029 0.0250.027 0.032 0.028 0.026 0.02520090908 75 0.033 0.028 0.03 0.0350.033 0.039 0.033 0.03 0.032Page 17 of 3320090909 75 0.03 0.028 0.027 0.030.03 0.03 0.033 0.03 0.03320090910 70 0.029 0.024 0.027 0.0290.024 0.032 0.03 0.029 0.0320090911 67 0.021 0.017 0.02 0.0190.019 0.025 0.028 0.019 0.0220090912 70 0.016 0.01 0.014 0.0130.013 0.018 0.018 0.016 0.01420090913 81 0.038 0.03 0.036 0.0340.037 0.039 0.035 0.039 0.03620090914 81 0.039 0.032 0.038 0.0420.041 0.044 0.04 0.044 0.04420090915 81 0.031 0.031 0.034 0.040.041 0.041 0.039 0.043 0.0420090916 71X 0.018 0.018 0.02 0.0120.0260.024 0.02 0.01820090917 65X 0.014 0.014 0.018 0.012 0.020.0230.018 0.01820090918 770.028 0.033 0.037 0.03 0.042 0.034 0.029 0.03820090919 71X 0.028 0.029 0.033 0.0320.0370.032 0.033 0.03220090920 760.048 0.054 0.053 0.049 0.058 0.047 0.052 0.05120090921 780.03 0.039 0.039 0.037 0.038 0.036 0.04 0.03820090922 780.021 0.029 0.03 0.03 0.027 0.031 0.03 0.03120090923 830.018 0.028 0.035 0.026 0.032 0.029 0.028 0.03720090924 830.029 0.039 0.041 0.041 0.044 0.045 0.043 0.03420090925 750.02 0.027 0.029 0.029 0.031 0.026 0.03 0.0320090926 69X 0.021 0.026 0.0280.030.030.027 0.028 0.02820090927 750.021 0.026 0.029 0.027 0.032 0.03 0.03 0.03120090928 790.029 0.041 0.04 0.041 0.041 0.044 0.043 0.04220090929 70X 0.018 0.023 0.024 0.0240.0290.025 0.026 0.02620090930 64X 0.013 0.012 0.02 0.0160.0250.017 0.016 0.02120091001 59X 0.022 0.026 0.03 0.030.0330.028 0.03 0.03120091002 68X 0.029 0.0340.0390.04 0.034 0.038 0.0380.03920091003 760.022 0.032 0.042 0.035 0.038 0.03 0.038 0.04120091004 74X 0.032 0.044 0.039 0.041 0.0450.0480.043 0.03920091005 68X 0.016 0.023 0.023 0.0220.0290.025 0.023 0.02420091006 68X 0.028 0.031 0.031 0.030.0320.0320.031 0.03120091007 72X 0.022 0.028 0.03 0.0290.0340.031 0.03 0.031Page 18 of 3320091008 67X 0.025 0.029 0.029 0.0280.0310.0310.029 0.0320091009 800.032 0.043 0.049 0.046 0.04 0.046 0.049 0.05320091010 760.014 0.021 0.024 0.024 0.022 0.024 0.024 0.02420091011 66X 0.026 0.032 0.032 0.033 0.0310.0340.0340.03120091012 55X 0.016 0.018 0.017 0.023 0.0140.0250.021 0.0220091013 68X 0.023 0.026 0.029 0.028 0.027 0.03 0.0280.03120091014 53X 0.017 0.021 0.022 0.018 0.022 0.02 0.020.02320091015 50X 0.013 0.014 0.015 0.0120.0160.02 0.011 0.01520091016 46X 0.013 0.015 0.017 0.013 0.0170.0190.013 0.01820091017 48X 0.018 0.02 0.022 0.021 0.021 0.021 0.0160.02320091018 49X 0.021 0.025 0.029 0.026 0.024 0.023 0.0240.0320091019 57X 0.021 0.0270.0320.029 0.029 0.03 0.026 0.03120091020 68X 0.02 0.0260.0310.019 0.028 0.027 0.027 0.02620091021 74X 0.031 0.0330.0440.038 0.036 0.034 0.038 0.03920091022 73X 0.009 0.017 0.032 0.023 0.0260.0380.037 0.03320091023 65X 0.021 0.024 0.023 0.025 0.020.030.027 0.02320091024 71X 0.022 0.026 0.027 0.026 0.0230.030.029 0.02720091025 63X 0.023 0.0290.0310.03 0.03 0.028 0.0280.03120091026 64X 0.022 0.025 0.024 0.027 0.0160.0320.028 0.02620091027 59 0.009 0.009 0.01 0.0130.007 0.008 0.027 0.011 0.01920091028 64 0.024 0.016 0.022 0.0210.017 0.018 0.036 0.022 0.02220091029 57 0.014 0.013 0.013 0.0180.019 0.014 0.014 0.01820091030 59 0.031 0.022 0.033 0.0330.033 0.023 0.033 0.03320091031 72 0.026 0.02 0.027 0.0260.026 0.024 0.029 0.025

## Page 19 of 33 

# APPENDIX C: Data

See attached CD for:
(1) Monthly weather data (2) AMP 435 reports
(3) Access database

## Page 20 of 33 

# APPENDIX D: Correspondence with Andrew Hass of EPA, Region IIIHenry Kim/Health/Phila

03/10/2010 04:21 PM To hass.andrew@epa.gov

cc Thomas Huynh/Health/Phila@Phila

bcc

Subject AMS 2009 Ozone Data: Missing Days analysis



### Drew.

As I mentioned in our 3/5/10 phone call, attached is a preliminary analysis of our 2009 Ozone data. Any comments you provide would be useful. Thanks.

******************************************************************************** In summary, there are 28 missing days that should be considered valid.



### Dates Day Count

9/16/09

– 9/17/09 2

9/19/09

– 9/20/09 2

9/26/09 1

9/29/09

– 10/2/09 4

10/5/09

– 10/8/09 4

10/11/09

– 10/20/09 10

10/22/09

– 10/26/09 5

TOTAL 28

Here's a short write-up of the analysis:

Steps: (1) download maximum daily 8-hr ozone values from 1997

– 2008 at NEA site (AQS AMP 435 report) (2) download weather data to compute maximum daily temperature from 1997

– 2008 ( http://climate.met.psu.edu/data/mesonet/datainv.php) (3) during the ozone season (April 1

– October 31), create a profile of maximum daily 8-hr ozone values versus temperature (see excel attachment: Max 8-hr O3 vs Temp at NEA (1997-2008).xls) (4) download the 2009 maximum daily 8-hr ozone values for all sites in Philadelphia and surrounding counties (Bucks, Chester, Delaware, & Montgomery Counties in PA) and identify down time at NEA (see excel attachment: 2009 O3 Data - HRK.xls)

Description: AMS used a conservative approach to determine what missing days should be counted as valid days. Temperature plays a vital role in the formation of ozone. Ozone data and temperature data from 1997

– 2008 were compiled to create a profile of maximum daily 8-hr ozone values at various temperatures during the ozone season (MAX8). The 4th highest 8-hr ozone value at NEA for 2009 was 0.072 ppm. Based on the 4th high value for 2009 and the MAX8 profile, historical data shows that temperatures at or below 73F would not exceed 0.072 ppm. Additionally, monitoring data from local counties were compared on days when the temperature was 73F or less to assure monitoring data remained less than the 2009 4th high value at NEA.

### *****************************************************************************

------------------------------------------------------------------------------ Henry Kim Chief, Program Services Air Management Services Department of Public Health City of Philadelphia 321 University Ave Philadelphia, PA 19104

Phone: 215-685-9439

Fax: 215-685-7593 E-mail: henry.kim@phila.govHenry Kim/Health/Phila

03/22/2010 04:13 PM To hass.andrew@epa.gov

cc

bcc

Subject Fw: AMS 2009 Ozone Data: Missing Days analysis



### Drew.

Based on our conservation from 3/18/10, attached are the following: (1) map of the NEA ozone monitor and neighboring monitors (2) 2009 maximum 8-hr daily values: this version includes ozone data from Ocean County (NJ), Gloucester County (NJ), and Cecil County (MD) .

Thanks.

------------------------------------------------------------------------------ Henry Kim Chief, Program Services Air Management Services Department of Public Health City of Philadelphia 321 University Ave Philadelphia, PA 19104

Phone: 215-685-9439

Fax: 215-685-7593 E-mail: henry.kim@phila.gov

----- Forwarded by Henry Kim/Health/Phila on 03/22/2010 04:10 PM -----

Henry Kim/Health/Phila

03/10/2010 04:21 PM To hass.andrew@epa.gov

cc Thomas Huynh/Health/Phila@Phila

Subject AMS 2009 Ozone Data: Missing Days analysis



### Drew.

As I mentioned in our 3/5/10 phone call, attached is a preliminary analysis of our 2009 Ozone data. Any comments you provide would be useful. Thanks.

******************************************************************************** In summary, there are 28 missing days that should be considered valid.



### Dates Day Count

9/16/09

– 9/17/09 2

9/19/09

– 9/20/09 2

### 9/26/09 1

9/29/09

– 10/2/09 4

10/5/09

– 10/8/09 4

10/11/09

– 10/20/09 10

10/22/09

– 10/26/09 5

TOTAL 28

Here's a short write-up of the analysis:

Steps: (1) download maximum daily 8-hr ozone values from 1997

– 2008 at NEA site (AQS AMP 435 report) (2) download weather data to compute maximum daily temperature from 1997

– 2008 ( http://climate.met.psu.edu/data/mesonet/datainv.php) (3) during the ozone season (April 1

– October 31), create a profile of maximum daily 8-hr ozone values versus temperature (see excel attachment: Max 8-hr O3 vs Temp at NEA (1997-2008).xls) (4) download the 2009 maximum daily 8-hr ozone values for all sites in Philadelphia and surrounding counties (Bucks, Chester, Delaware, & Montgomery Counties in PA) and identify down time at NEA (see excel attachment: 2009 O3 Data - HRK.xls)

Description: AMS used a conservative approach to determine what missing days should be counted as valid days. Temperature plays a vital role in the formation of ozone. Ozone data and temperature data from 1997

– 2008 were compiled to create a profile of maximum daily 8-hr ozone values at various temperatures during the ozone season (MAX8). The 4th highest 8-hr ozone value at NEA for 2009 was 0.072 ppm. Based on the 4th high value for 2009 and the MAX8 profile, historical data shows that temperatures at or below 73F would not exceed 0.072 ppm. Additionally, monitoring data from local counties were compared on days when the temperature was 73F or less to assure monitoring data remained less than the 2009 4th high value at NEA.

*****************************************************************************

------------------------------------------------------------------------------ Henry Kim Chief, Program Services Air Management Services Department of Public Health City of Philadelphia 321 University Ave Philadelphia, PA 19104

Phone: 215-685-9439

Fax: 215-685-7593 E-mail: henry.kim@phila.govHass.Andrew@epamail.epa.g

ov

03/22/2010 04:20 PM To Henry.Kim@phila.gov

cc

bcc

Subject Re: Fw: AMS 2009 Ozone Data: Missing Days analysis

History: This message has been forwarded.



### Henry,

Thanks for the info. Per our discussion last week, this approach is acceptable. You have done a good j ob showin g nearb y monitors concentrations from the da y s missin g as well as showed meteorolo gy more then likely would not have played a part creating high concentrations of ozone. I have a call into HQ to see how AQS handles the data completeness claculations.

I will provide you updated info when available.

Hope you had a good weekend.

Drew

From: Henry.Kim@phila.gov

To: Andrew Hass/R3/USEPA/US@EPA

Date: 03/22/2010 04:13 PM

Subject: Fw: AMS 2009 Ozone Data: Missing Days analysis



### Drew.

Based on our conservation from 3/18/10, attached are the following:

(1) map of the NEA ozone monitor and neighboring monitors (2) 2009 maximum 8-hr daily values: this version includes ozone data from Ocean County (NJ),

Gloucester County (NJ), and Cecil County (MD) .

Thanks.

------------------------------------------------------------------------------ Henry Kim Chief, Program Services Air Management Services Department of Public Health

### Cit y of Philadelphia 321 University Ave Philadelphia, PA 19104

Phone: 215-685-9439

Fax: 215-685-7593

E-mail: henry.kim@phila.gov

----- Forwarded by Henry Kim/Health/Phila on 03/22/2010 04:10 PM -----

Henry Kim/Health/Phila

03/10/2010 04:21 PM To hass.andrew@epa.gov

cc Thomas Huynh/Health/Phila@Phila

Subject AMS 2009 Ozone Data: Missing Days analysis



### Drew.

As I mentioned in our 3/5/10 phone call, attached is a preliminary analysis of our 2009 Ozone data. Any

comments you provide would be useful. Thanks.

********************************************************************************

In summary, there are 28 missing days that should be considered valid.

Dates Day Count

9/16/09

– 9/17/09 2

9/19/09

– 9/20/09 2

9/26/09 1

9/29/09

– 10/2/09 4

10/5/09

– 10/8/09 4

10/11/09

– 10/20/09 10

10/22/09

– 10/26/09 5

TOTAL 28

Here's a short write-up of the analysis:

Steps:

(1) download maximum daily 8-hr ozone values from 1997

– 2008 at NEA site (AQS AMP 435 report) (2) download weather data to compute maximum daily temperature from 1997

– 2008 (

### http :// climate

. met

. psu

. edu / data / mesonet / datainv

. php ) (3) during the ozone season (April 1

– October 31), create a profile of maximum daily 8-hr ozone values

versus temperature (see excel attachment: Max 8-hr O3 vs Temp at NEA (1997-2008).xls) (4) download the 2009 maximum daily 8-hr ozone values for all sites in Philadelphia and surrounding counties (Bucks, Chester, Delaware, & Montgomery Counties in PA) and identify down time at NEA (see

excel attachment: 2009 O3 Data - HRK.xls)

Description: AMS used a conservative approach to determine what missing days should be counted as valid days. Temperature plays a vital role in the formation of ozone. Ozone data and temperature data from 1997

– 2008 were compiled to create a profile of maximum daily 8-hr ozone values at various temperatures during the ozone season (MAX8). The 4th highest 8-hr ozone value at NEA for 2009 was 0.072 ppm. Based on the 4th high value for 2009 and the MAX8 profile, historical data shows that temperatures at or below 73F would not exceed 0.072 ppm. Additionally, monitoring data from local counties were compared on days when the temperature was 73F or less to assure monitoring data remained less than the 2009

4th high value at NEA.

*****************************************************************************

------------------------------------------------------------------------------ Henry Kim Chief, Program Services Air Management Services Department of Public Health City of Philadelphia 321 University Ave Philadelphia, PA 19104

Phone: 215-685-9439

Fax: 215-685-7593 E-mail: henry.kim@phila.gov [attachment "Max 8-hr O3 vs Temp at NEA ( 1997-2008).xls" deleted by Andrew Hass/R3/USEPA/US] [attachment "2009 O3 Data - HRK.xls" deleted by Andrew Hass/R3/USEPA/US] [attachment "O3 Map.pdf" deleted by Andrew Hass/R3/USEPA/US] [attachment " 2009 O3 Data (2010.03.19) - HRK.xls"

deleted by Andrew Hass/R3/USEPA/US]Hass.Andrew@epamail.epa.g

ov

03/25/2010 03:19 PM To Henry.Kim@phila.gov

cc Wilkie.Walter@epamail.epa.gov

bcc

Subject Process for data substitution

History: This message has been replied to and forwarded.



### Henry,

I want to provide you what is the process to properly get the ozone data substitution final for the missing

days in 2009.

1 )Put the Null Data code "BG" for all the missing days in AQS that Phila AMS is proposing have counted

towards meeting data completeness requirements. 2) Put together and send R3 a package documenting the justification for why this ozone data would not have exceeded the ozone NAAQS on the missing day. - 40 CFR Pt 50 App. I Sec . 2.2(b) give a descrpition of what is suffucient to show a day would not

have had an ozone concentration above theNAAQS

-what you provided me already is acceptable... j ust needs to be submitted in a more formal packa g e 3) Once received R3 will review and, if RA approves the package, will put a concurrence flag in AQS

Since the Data Substitution package needs regional Administrator approval, it should come from the same person at Phila AMS who signs off on the Annual Monitoring Network Plans. The Data Substitution

package needs to be sent to Shawn Garvin - the R3 Regional Administrator.

Please let me know if you have any questions or need add'l info.

Thanks.

DrewHenry Kim/Health/Phila

03/26/2010 10:55 AM To Hass.Andrew@epamail.epa.gov

cc Wilkie.Walter@epamail.epa.gov, Thomas Huynh/Health/Phila

bcc

Subject Re: Process for data substitution



### Drew.

Thanks for all your help.

Just a few questions: (1) In the formal submittal, should I also submit the raw data (weather data, AMP435 reports, etc) or just the summaries (similar to what I sent earlier)? (2) Can AMS submit the ozone data substitution request in the same letter as the ozone data certification

letter?

------------------------------------------------------------------------------ Henry Kim Chief, Program Services Air Management Services Department of Public Health City of Philadelphia 321 University Ave Philadelphia, PA 19104

Phone: 215-685-9439

Fax: 215-685-7593 E-mail: henry.kim@phila.gov

Hass.Andrew@epamail.epa.gov

Hass.Andrew@epamail.epa.g

ov

03/25/2010 03:19 PM To Henry.Kim@phila.gov

cc Wilkie.Walter@epamail.epa.gov

Subject Process for data substitution



### Henry,

I want to provide you what is the process to properly get the ozone data substitution final for the missing

days in 2009.

1 )Put the Null Data code "BG" for all the missing days in AQS that Phila AMS is proposing have counted

towards meeting data completeness requirements. 2) Put together and send R3 a package documenting the justification for why this ozone data would not have exceeded the ozone NAAQS on the missing day.

### - 40 CFR Pt 50 A pp. I Sec. 2.2 ( b ) g ive a descrpition of what is suffucient to show a da y would no t

have had an ozone concentration above theNAAQS

-what you provided me already is acceptable... j ust needs to be submitted in a more formal packa g e 3) Once received R3 will review and, if RA approves the package, will put a concurrence flag in AQS

Since the Data Substitution package needs regional Administrator approval, it should come from the same person at Phila AMS who signs off on the Annual Monitoring Network Plans. The Data Substitution

package needs to be sent to Shawn Garvin - the R3 Regional Administrator.

Please let me know if you have any questions or need add'l info.

Thanks.

DrewHass.Andrew@epamail.epa.g

ov

03/29/2010 12:37 PM To Henry.Kim@phila.gov

cc Thomas.Huynh@phila.gov, Wilkie.Walter@epamail.epa.gov

bcc

Subject Re: Process for data substitution



### Henry,

There is not a set format for what should/should not be submitted w/ the package. What you provided earlier is fine. However, I would recommend that you include everything that you think will make it hard for someone to question the data substitution. If you want, the raw data can be submitted as an

Appendix.

As for the letters, these are two different issues, so I would send separately. However, I am not sure if that will cause a major delay in getting this finalized and thus cause a delay in the what is needed for planning. Another issue here is how will this affect the data certification? What I mean is, once any changes are made to certified data, the data certification flag for that year is removed and that S/L agency

must re-submit another data certification letter for EPA to re-concur on. Would the best course of action be for Phila AMS to submit a data substitution package for R3 to concur, get those flags in AQS and then have AMS submit the data cert. package? This would make AMS only have to submit one data cert

package to R3. I am not an AQS expert so my rationale may not be correct.

This may be an issue, planning or AQS folks needs to discuss and see what would be the best way to

proceed.

Hope this help.

Drew

From: Henry.Kim@phila.gov

To: Andrew Hass/R3/USEPA/US@EPA

Cc: Walter Wilkie/R3/USEPA/US@EPA, Thomas.Huynh@phila.gov

Date: 03/26/2010 10:55 AM

Subject: Re: Process for data substitution



### Drew.

Thanks for all your help.

Just a few questions: (1) In the formal submittal, should I also submit the raw data (weather data, AMP435 reports, etc) or just

### the summaries (similar to what I sent earlier)? (2) Can AMS submit the ozone data substitution request in the same letter as the ozone data certification

letter?

------------------------------------------------------------------------------ Henry Kim Chief, Program Services Air Management Services Department of Public Health City of Philadelphia 321 University Ave Philadelphia, PA 19104

Phone: 215-685-9439

Fax: 215-685-7593

E-mail: henry.kim@phila.gov

Hass.Andrew@epamail.epa.gov

03/25/2010 03:19 PM To Henry.Kim@phila.gov

cc Wilkie.Walter@epamail.epa.gov

Subject Process for data substitution



### Henry,

I want to provide you what is the process to properly get the ozone data substitution final for the missing days in 2009.

1 )Put the Null Data code "BG" for all the missing days in AQS that Phila AMS is proposing have counted

towards meeting data completeness requirements. 2) Put together and send R3 a package documenting the justification for why this ozone data would not have exceeded the ozone NAAQS on the missing day. - 40 CFR Pt 50 App. I Sec. 2.2(b) give a descrpition of what is suffucient to show a day would not

have had an ozone concentration above theNAAQS

-what you provided me already is acceptable... j ust needs to be submitted in a more formal packa g e 3) Once received R3 will review and, if RA approves the package, will put a concurrence flag in AQS

Since the Data Substitution package needs regional Administrator approval, it should come from the same person at Phila AMS who signs off on the Annual Monitoring Network Plans. The Data Substitution

package needs to be sent to Shawn Garvin - the R3 Regional Administrator.

### Please let me know if you have any questions or need add'l info.

Thanks.

Drew