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 pump resulted in significant 

down time for the ozone monitor located at Northeast Airport in Philadelphia County 

(NEA) (AQS Monitor ID 42-101-0024). The down time lasted from 9/16/2009 – 

10/26/2009 (42 days) and resulted in 71% data collection during the ozone season. 

Section 2.3(b) of Appendix I to 40 CFR Part 50 requires three consecutive years of data 

with data availability of at least 90% on average, with a minimum data completeness in 

any one year of at least 75%. Furthermore, 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 the appropriate Regional Administrator.” 

The City of Philadelphia, Department of Public Health, Air Management Services 

(AMS), has analyzed the meteorological and ambient monitoring data for the 2009 Ozone 

season and determined that the use of the null 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 determine 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 create 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 was used to demonstrate the conservative 

approach. 

For the 2009 Ozone season, the 4th highest 8-hr ozone value at NEA was 0.072 ppm. 

Based on the 4th highest value for 2009 and Figure 1, historical data shows that 

temperatures at or below 74F would not exceed 0.072 ppm. The temperature of 74F was 

chosen as it represents not only the maximum temperature but the maximum daily 8-hr 

value that would not exceed the 4th 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 Appendix C). It is important to note that 

AMS has chosen the 4th highest 8-hr ozone value as the level to count the missing days as 

opposed to “the level of the standard” as described in Section 2.3(b) of Appendix I to 40 

CFR Part 50. The use of the 4th 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 Philadelphia (see Figure 2) were included. Cells 

highlighted in “orange” represented days when the NEA monitor was down. Cells 

highlighted in “orange” with an “X” represent 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 “yellow” 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 4th

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 Garden 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/climate/index.php?wfo=phi

c. Data downloaded 3/26/10. 

(3) During the ozone season (April 1 – October 31), create a profile 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 monitoring and weather data for 2009. 

b. Based on Figure 1, determine the maximum temperature (and 

maximum 8-hr value) that falls below the 4th 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: Figures
Page 8 of 33 

Figure 1. Maximum Daily 8-hr Ozone Concentration versus Temperature 

Max Daily 8-hr O3 Concentration vs Temperature

at 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

Temperature (F)

Max Daily 8-hr O3 Concentration (ppm)

Max Daily 8-hr Ozone Value 4th Highest 8-hr Ozone @ NEA (2009)

Max temperature and max 8-hr ozone value below 4th highest 2009 8-hr Ozone value. 
Page 9 of 33 

Figure 2. Ozone Monitors Near Northeast Airport (42-101-0024) 
Page 10 of 33 

APPENDIX B: Tables
Page 11 of 33 

Table 1. 2009 Daily Maximum 8-hr Ozone Data 

Date 

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 

fil it

20090401 0.036 0.024 0.037 0.033 0.037 0.022 0.043 0.034 0.04 20090402 0.035 0.028 0.036 0.038 0.033 0.029 0.039 0.036 0.04 20090403 0.045 0.042 0.046 0.047 0.044 0.042 0.046 0.048 0.049 20090404 0.048 0.042 0.049 0.051 0.049 0.045 0.049 0.051 0.053 20090405 0.054 0.043 0.055 0.055 0.052 0.05 0.056 0.054 0.059 20090406 0.04 0.035 0.04 0.042 0.04 0.029 0.043 0.041 0.048 20090407 0.044 0.036 0.044 0.045 0.045 0.037 0.043 0.044 0.046 20090408 0.045 0.035 0.045 0.048 0.045 0.038 0.045 0.046 0.052 20090409 0.055 0.045 0.055 0.056 0.054 0.047 0.055 0.057 0.06 20090410 0.055 0.049 0.056 0.058 0.059 0.042 0.056 0.063 0.062 20090411 0.044 0.038 0.043 0.043 0.043 0.038 0.047 0.041 0.047 20090412 0.05 0.044 0.051 0.048 0.049 0.043 0.051 0.049 0.052 20090413 0.045 0.038 0.046 0.046 0.046 0.04 0.047 0.047 0.048 20090414 0.044 0.04 0.044 0.042 0.038 0.036 0.054 0.048 0.046 20090415 0.037 0.033 0.038 0.036 0.034 0.033 0.051 0.047 0.045 20090416 0.05 0.039 0.052 0.049 0.048 0.047 0.051 0.047 0.052 
Page 12 of 33 

20090417 0.052 0.044 0.057 0.056 0.055 0.055 0.058 0.058 0.06 20090418 0.067 0.057 0.069 0.064 0.063 0.066 0.071 0.068 0.046 20090419 0.051 0.045 0.052 0.056 0.051 0.052 0.051 0.052 20090420 0.043 0.039 0.044 0.04 0.043 0.042 0.048 0.043 0.042 20090421 0.043 0.034 0.045 0.049 0.045 0.042 0.041 0.047 0.054 20090422 0.031 0.025 0.031 0.037 0.033 0.036 0.033 0.034 0.04 20090423 0.042 0.034 0.043 0.044 0.042 0.043 0.042 0.044 0.047 20090424 0.058 0.046 0.06 0.059 0.056 0.054 0.061 0.06 0.064 20090425 0.063 0.051 0.068 0.067 0.058 0.061 0.069 0.067 0.076 20090426 0.062 0.05 0.064 0.065 0.058 0.064 0.065 0.063 0.07 20090427 0.064 0.047 0.067 0.068 0.061 0.07 0.058 0.064 0.072 20090428 0.068 0.048 0.073 0.065 0.057 0.069 0.066 0.064 0.067 20090429 0.046 0.035 0.044 0.028 0.04 0.034 0.041 0.034 0.032 20090430 0.048 0.037 0.05 0.049 0.044 0.041 0.047 0.048 0.05 20090501 0.024 0.019 0.028 0.028 0.026 0.027 0.033 0.031 0.034 20090502 0.039 0.028 0.039 0.04 0.035 0.04 0.037 0.035 0.035 20090503 0.039 0.034 0.041 0.034 0.041 0.031 0.042 0.039 0.036 20090504 0.037 0.033 0.033 0.04 0.026 0.041 0.044 0.056 0.042 20090505 0.036 0.031 0.035 0.036 0.027 0.035 0.044 0.03 0.039 20090506 0.038 0.03 0.039 0.038 0.036 0.031 0.038 0.039 0.038 20090507 0.027 0.018 0.03 0.038 0.026 0.031 0.032 0.032 0.031 20090508 0.059 0.039 0.061 0.055 0.056 0.055 0.057 0.059 0.059 20090509 0.056 0.041 0.059 0.052 0.051 0.055 0.057 0.056 0.057 20090510 0.043 0.037 0.045 0.044 0.045 0.044 0.042 0.046 0.048 20090511 0.034 0.023 0.036 0.03 0.029 0.036 0.039 0.032 0.032 20090512 0.049 0.04 0.051 0.051 0.049 0.053 0.052 0.049 0.055 20090513 0.062 0.052 0.061 0.063 0.061 0.057 0.059 0.063 0.065 20090514 0.044 0.034 0.047 0.044 0.044 0.037 0.048 0.046 0.048 20090515 0.046 0.032 0.046 0.053 0.043 0.056 0.048 0.045 0.055 
Page 13 of 33 

20090516 0.031 0.021 0.031 0.032 0.03 0.031 0.028 0.032 0.032 20090517 0.044 0.041 0.044 0.037 0.039 0.045 0.043 0.043 0.041 20090518 0.043 0.036 0.044 0.045 0.043 0.047 0.046 0.046 0.049 20090519 0.049 0.036 0.055 0.055 0.05 0.053 0.049 0.053 0.061 20090520 0.059 0.05 0.065 0.065 0.063 0.067 0.07 0.062 0.068 20090521 0.058 0.045 0.064 0.06 0.056 0.064 0.064 0.059 0.062 20090522 0.06 0.044 0.063 0.065 0.056 0.062 0.064 0.061 0.068 20090523 0.063 0.036 0.065 0.049 0.046 0.061 0.059 0.05 0.052 20090524 0.048 0.035 0.051 0.042 0.039 0.051 0.043 0.043 0.045 20090525 0.057 0.048 0.063 0.056 0.063 0.058 0.069 0.066 0.058 20090526 0.039 0.032 0.038 0.036 0.037 0.038 0.042 0.041 0.039 20090527 0.031 0.021 0.03 0.026 0.026 0.026 0.032 0.031 0.025 20090528 0.024 0.02 0.024 0.028 0.021 0.023 0.028 0.023 0.029 20090529 0.026 0.018 0.025 0.034 0.03 0.033 0.028 0.03 0.037 20090530 0.054 0.045 0.056 0.054 0.055 0.058 0.057 0.06 0.056 20090531 0.059 0.047 0.061 0.055 0.057 0.061 0.063 0.062 0.056 20090601 0.048 0.035 0.051 0.047 0.046 0.05 0.048 0.048 0.05 20090602 0.061 0.045 0.064 0.045 0.054 0.062 0.069 0.057 0.052 20090603 0.041 0.034 0.043 0.041 0.042 0.041 0.05 0.048 0.047 20090604 0.033 0.028 0.029 0.029 0.034 0.03 0.042 0.03 0.03 20090605 0.037 0.028 0.036 0.033 0.023 0.034 0.046 0.037 0.034 20090606 0.047 0.032 0.049 0.042 0.044 0.047 0.052 0.049 0.045 20090607 0.068 0.05 0.068 0.057 0.056 0.065 0.056 0.058 0.06 20090608 0.064 0.044 0.056 0.054 0.054 0.063 0.056 0.054 0.053 20090609 0.033 0.021 0.034 0.035 0.035 0.021 0.038 0.04 0.039 20090610 0.041 0.031 0.037 0.066 0.043 0.043 0.029 0.045 0.064 20090611 0.02 0.015 0.018 0.023 0.022 0.019 0.029 0.019 0.028 20090612 0.048 0.034 0.046 0.044 0.046 0.048 0.051 0.049 0.046 20090613 0.04 0.032 0.039 0.043 0.036 0.042 0.039 0.037 0.049 
Page 14 of 33 

20090614 0.046 0.037 0.047 0.041 0.041 0.045 0.038 0.047 0.044 20090615 0.049 0.038 0.051 0.049 0.046 0.051 0.036 0.052 0.048 20090616 0.038 0.03 0.04 0.031 0.034 0.036 0.036 0.031 0.03 20090617 0.027 0.019 0.028 0.025 0.027 0.026 0.027 0.025 0.025 20090618 0.034 0.025 0.036 0.029 0.035 0.03 0.039 0.036 0.031 20090619 0.036 0.027 0.036 0.041 0.039 0.04 0.04 0.042 0.042 20090620 0.032 0.028 0.032 0.035 0.034 0.036 0.037 0.037 0.037 20090621 0.029 0.027 0.029 0.031 0.032 0.035 0.03 0.033 0.032 20090622 0.03 0.025 0.029 0.037 0.03 0.035 0.034 0.026 0.038 20090623 0.042 0.032 0.039 0.043 0.041 0.046 0.045 0.043 0.044 20090624 0.037 0.029 0.031 0.046 0.042 0.043 0.035 0.041 0.048 20090625 0.065 0.051 0.069 0.063 0.064 0.065 0.045 0.072 0.068 20090626 0.075 0.059 0.076 0.078 0.072 0.071 0.067 0.076 0.083 20090627 0.043 0.03 0.042 0.039 0.04 0.044 0.045 0.046 0.043 20090628 0.045 0.036 0.045 0.044 0.043 0.047 0.052 0.048 0.046 20090629 0.055 0.043 0.055 0.053 0.053 0.058 0.06 0.06 0.053 20090630 0.056 0.039 0.055 0.056 0.052 0.052 0.055 0.057 0.057 20090701 86 0.064 0.057 0.067 0.054 0.057 0.062 0.06 0.066 0.056 20090702 83 0.056 0.041 0.057 0.047 0.048 0.057 0.065 0.056 0.047 20090703 82 0.041 0.03 0.042 0.039 0.04 0.044 0.042 0.044 0.039 20090704 83 0.04 0.033 0.041 0.045 0.045 0.044 0.042 0.048 0.047 20090705 80 0.045 0.038 0.052 0.044 0.049 0.047 0.055 0.054 0.046 20090706 85 0.039 0.049 0.058 0.054 0.054 0.057 0.06 0.059 0.058 20090707 88 0.051 0.057 0.06 0.061 0.067 0.059 0.067 0.064 20090708 80 0.027 0.038 0.035 0.038 0.04 0.04 0.04 0.036 20090709 81 0.039 0.046 0.047 0.05 0.049 0.04 0.046 0.049 20090710 83 0.046 0.06 0.06 0.062 0.06 0.054 0.053 0.061 20090711 82 0.04 0.053 0.045 0.046 0.05 0.054 0.05 0.046 20090712 86 0.035 0.046 0.046 0.047 0.049 0.047 0.048 0.049 
Page 15 of 33 

20090713 84 0.044 0.058 0.054 0.052 0.061 0.044 0.053 0.054 20090714 84 0.04 0.051 0.053 0.053 0.055 0.053 0.055 0.052 20090715 87 0.059 0.077 0.069 0.07 0.075 0.071 0.07 0.072 20090716 91 0.051 0.074 0.057 0.061 0.07 0.08 0.066 0.077 20090717 88 0.047 0.058 0.053 0.057 0.054 0.06 0.06 0.055 20090718 83 0.037 0.047 0.044 0.047 0.048 0.051 0.051 0.045 20090719 84 0.035 0.044 0.042 0.044 0.046 0.046 0.051 0.044 20090720 0.063 0.052 0.063 0.064 0.06 0.065 0.058 0.058 0.058 20090721 0.031 0.028 0.033 0.034 0.034 0.036 0.04 0.036 0.037 20090722 0.057 0.047 0.053 0.054 0.053 0.058 0.044 0.055 0.048 20090723 0.033 0.031 0.032 0.031 0.029 0.037 0.038 0.034 0.026 20090724 0.055 0.042 0.057 0.048 0.05 0.057 0.055 0.058 0.05 20090725 0.061 0.048 0.057 0.054 0.053 0.061 0.053 0.057 0.056 20090726 0.058 0.046 0.057 0.054 0.049 0.059 0.05 0.055 0.054 20090727 0.056 0.041 0.056 0.056 0.047 0.053 0.045 0.049 0.059 20090728 0.058 0.046 0.054 0.053 0.048 0.058 0.051 0.051 0.048 20090729 0.046 0.034 0.044 0.04 0.041 0.045 0.047 0.044 0.045 20090730 0.055 0.048 0.054 0.053 0.053 0.058 0.057 0.059 0.054 20090731 0.042 0.031 0.045 0.037 0.039 0.042 0.042 0.041 0.042 20090801 0.06 0.054 0.058 0.05 0.054 0.06 0.05 0.052 0.045 20090802 0.033 0.028 0.034 0.036 0.037 0.033 0.034 0.037 20090803 86 0.05 0.065 0.058 0.055 0.06 0.069 0.062 0.054 20090804 89 0.046 0.063 0.05 0.05 0.061 0.055 0.053 0.051 20090805 0.064 0.052 0.065 0.054 0.057 0.061 0.07 0.067 0.056 20090806 0.022 0.031 0.035 0.034 0.03 0.046 0.03 0.024 0.034 20090807 0.029 0.034 0.042 0.043 0.043 0.046 0.043 0.045 0.043 20090808 0.028 0.053 0.057 0.06 0.065 0.058 0.045 0.058 0.058 20090809 0.042 0.033 0.046 0.04 0.045 0.041 0.047 0.05 0.044 20090810 0.061 0.049 0.062 0.051 0.055 0.062 0.069 0.067 0.052 
Page 16 of 33 

20090811 0.056 0.046 0.057 0.054 0.055 0.058 0.061 0.059 0.055 20090812 0.047 0.041 0.044 0.049 0.045 0.044 0.047 0.048 0.051 20090813 0.034 0.031 0.034 0.041 0.029 0.03 0.036 0.036 0.046 20090814 0.064 0.057 0.064 0.049 0.063 0.056 0.055 0.071 0.049 20090815 0.084 0.072 0.073 0.059 0.07 0.068 0.061 0.067 0.065 20090816 0.073 0.063 0.074 0.058 0.064 0.07 0.072 0.074 0.065 20090817 0.072 0.058 0.071 0.06 0.063 0.071 0.085 0.069 0.061 20090818 0.068 0.052 0.063 0.06 0.054 0.059 0.052 0.054 0.071 20090819 0.063 0.048 0.063 0.056 0.052 0.057 0.062 0.058 0.066 20090820 0.049 0.035 0.039 0.039 0.043 0.047 0.041 0.041 0.043 20090821 0.041 0.028 0.035 0.033 0.033 0.037 0.039 0.035 0.039 20090822 0.033 0.023 0.025 0.036 0.038 0.035 0.021 0.037 0.038 20090823 0.042 0.036 0.04 0.039 0.041 0.044 0.04 0.047 0.042 20090824 0.045 0.04 0.044 0.043 0.047 0.046 0.047 0.048 0.045 20090825 0.05 0.043 0.046 0.043 0.049 0.049 0.051 0.055 0.048 20090826 0.069 0.058 0.067 0.056 0.057 0.07 0.071 0.061 0.055 20090827 0.026 0.025 0.023 0.044 0.037 0.032 0.026 0.039 0.046 20090828 0.032 0.027 0.031 0.032 0.034 0.035 0.036 0.035 0.033 20090829 0.023 0.021 0.026 0.029 0.027 0.027 0.029 0.031 0.032 20090830 0.049 0.041 0.049 0.044 0.046 0.053 0.05 0.051 0.045 20090831 0.027 0.02 0.023 0.025 0.027 0.032 0.024 0.025 0.027 20090901 76 0.043 0.038 0.036 0.039 0.041 0.04 0.04 0.035 0.038 20090902 79 0.058 0.052 0.055 0.061 0.058 0.053 0.053 0.054 0.064 20090903 80 0.048 0.043 0.043 0.055 0.048 0.054 0.04 0.044 0.055 20090904 84 0.051 0.041 0.049 0.046 0.051 0.051 0.06 0.055 0.047 20090905 85 0.053 0.046 0.046 0.049 0.052 0.054 0.049 0.054 0.051 20090906 78 0.033 0.028 0.03 0.042 0.034 0.041 0.027 0.032 0.044 20090907 76 0.03 0.026 0.029 0.025 0.027 0.032 0.028 0.026 0.025 20090908 75 0.033 0.028 0.03 0.035 0.033 0.039 0.033 0.03 0.032 
Page 17 of 33 

20090909 75 0.03 0.028 0.027 0.03 0.03 0.03 0.033 0.03 0.033 20090910 70 0.029 0.024 0.027 0.029 0.024 0.032 0.03 0.029 0.03 20090911 67 0.021 0.017 0.02 0.019 0.019 0.025 0.028 0.019 0.02 20090912 70 0.016 0.01 0.014 0.013 0.013 0.018 0.018 0.016 0.014 20090913 81 0.038 0.03 0.036 0.034 0.037 0.039 0.035 0.039 0.036 20090914 81 0.039 0.032 0.038 0.042 0.041 0.044 0.04 0.044 0.044 20090915 81 0.031 0.031 0.034 0.04 0.041 0.041 0.039 0.043 0.04 20090916 71 X 0.018 0.018 0.02 0.012 0.026 0.024 0.02 0.018 20090917 65 X 0.014 0.014 0.018 0.012 0.02 0.023 0.018 0.018 20090918 77 0.028 0.033 0.037 0.03 0.042 0.034 0.029 0.038 20090919 71 X 0.028 0.029 0.033 0.032 0.037 0.032 0.033 0.032 20090920 76 0.048 0.054 0.053 0.049 0.058 0.047 0.052 0.051 20090921 78 0.03 0.039 0.039 0.037 0.038 0.036 0.04 0.038 20090922 78 0.021 0.029 0.03 0.03 0.027 0.031 0.03 0.031 20090923 83 0.018 0.028 0.035 0.026 0.032 0.029 0.028 0.037 20090924 83 0.029 0.039 0.041 0.041 0.044 0.045 0.043 0.034 20090925 75 0.02 0.027 0.029 0.029 0.031 0.026 0.03 0.03 20090926 69 X 0.021 0.026 0.028 0.03 0.03 0.027 0.028 0.028 20090927 75 0.021 0.026 0.029 0.027 0.032 0.03 0.03 0.031 20090928 79 0.029 0.041 0.04 0.041 0.041 0.044 0.043 0.042 20090929 70 X 0.018 0.023 0.024 0.024 0.029 0.025 0.026 0.026 20090930 64 X 0.013 0.012 0.02 0.016 0.025 0.017 0.016 0.021 20091001 59 X 0.022 0.026 0.03 0.03 0.033 0.028 0.03 0.031 20091002 68 X 0.029 0.034 0.039 0.04 0.034 0.038 0.038 0.039 20091003 76 0.022 0.032 0.042 0.035 0.038 0.03 0.038 0.041 20091004 74 X 0.032 0.044 0.039 0.041 0.045 0.048 0.043 0.039 20091005 68 X 0.016 0.023 0.023 0.022 0.029 0.025 0.023 0.024 20091006 68 X 0.028 0.031 0.031 0.03 0.032 0.032 0.031 0.031 20091007 72 X 0.022 0.028 0.03 0.029 0.034 0.031 0.03 0.031 
Page 18 of 33 

20091008 67 X 0.025 0.029 0.029 0.028 0.031 0.031 0.029 0.03 20091009 80 0.032 0.043 0.049 0.046 0.04 0.046 0.049 0.053 20091010 76 0.014 0.021 0.024 0.024 0.022 0.024 0.024 0.024 20091011 66 X 0.026 0.032 0.032 0.033 0.031 0.034 0.034 0.031 20091012 55 X 0.016 0.018 0.017 0.023 0.014 0.025 0.021 0.02 20091013 68 X 0.023 0.026 0.029 0.028 0.027 0.03 0.028 0.031 20091014 53 X 0.017 0.021 0.022 0.018 0.022 0.02 0.02 0.023 20091015 50 X 0.013 0.014 0.015 0.012 0.016 0.02 0.011 0.015 20091016 46 X 0.013 0.015 0.017 0.013 0.017 0.019 0.013 0.018 20091017 48 X 0.018 0.02 0.022 0.021 0.021 0.021 0.016 0.023 20091018 49 X 0.021 0.025 0.029 0.026 0.024 0.023 0.024 0.03 20091019 57 X 0.021 0.027 0.032 0.029 0.029 0.03 0.026 0.031 20091020 68 X 0.02 0.026 0.031 0.019 0.028 0.027 0.027 0.026 20091021 74 X 0.031 0.033 0.044 0.038 0.036 0.034 0.038 0.039 20091022 73 X 0.009 0.017 0.032 0.023 0.026 0.038 0.037 0.033 20091023 65 X 0.021 0.024 0.023 0.025 0.02 0.03 0.027 0.023 20091024 71 X 0.022 0.026 0.027 0.026 0.023 0.03 0.029 0.027 20091025 63 X 0.023 0.029 0.031 0.03 0.03 0.028 0.028 0.031 20091026 64 X 0.022 0.025 0.024 0.027 0.016 0.032 0.028 0.026 20091027 59 0.009 0.009 0.01 0.013 0.007 0.008 0.027 0.011 0.019 20091028 64 0.024 0.016 0.022 0.021 0.017 0.018 0.036 0.022 0.022 20091029 57 0.014 0.013 0.013 0.018 0.019 0.014 0.014 0.018 20091030 59 0.031 0.022 0.033 0.033 0.033 0.023 0.033 0.033 20091031 72 0.026 0.02 0.027 0.026 0.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 III 
Henry 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.

Page 21 of 33
*****************************************************************************

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

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

Page 22 of 33
Henry 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

Page 23 of 33
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

Page 24 of 33
Hass.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 

job showing nearby monitors concentrations from the days missing as well as showed meteorology 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

Page 25 of 33
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 (

Page 26 of 33
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] 

Page 27 of 33
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...just needs to be submitted in a more formal package

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

Page 28 of 33
Henry 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. 

Page 29 of 33
 - 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...just needs to be submitted in a more formal package

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

Page 30 of 33
Hass.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 

Page 31 of 33
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...just needs to be submitted in a more formal package

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.

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

Thanks.

Drew

Page 33 of 33