FHWA and EPA National Near-Road Study - Detroit

25 Appendix - Integrated Sample Data - Cartridges

SAS Dataset (Not available online.)

September 29, 2010 thru June 20, 2011
Acetaldehyde
SampleType	# of Samples	% by Sample Type	# of Samples w/ No Sample Collection Errors/ Warnings (Flag_ Acetaldehyde = 0)	% of Samples w/ No Sample Collection Errors/ Warnings (Flag_ Acetaldehyde = 0)	# of Samples w/ Sample Collection Errors/ Warnings (Flag_ Acetaldehyde = 1)	% of Samples w/ Sample Collection Errors/ Warnings (Flag_ Acetaldehyde = 1)
Field Blank	13	8	13	100	0	0
Field Control	6	4	6	100	0	0
Field Dup	2	1	2	100	0	0
Lab Dup	0	0	0	100	0	0
Sample	144	87	130	90	14	10
Total	165		151		14
Formaldehyde
SampleType	# of Samples	% by Sample Type	# of Samples w/ No Sample Collection Errors/ Warnings (Flag_ Formaldehyde = 0)	% of Samples w/ No Sample Collection Errors/ Warnings (Flag_ Formaldehyde = 0)	# of Samples w/ Sample Collection Errors/ Warnings (Flag_ Formaldehyde = 1)	% of Samples w/ Sample Collection Errors/ Warnings (Flag_ Formaldehyde = 1)
Field Blank	13	8	13	100	0	0
Field Control	6	4	6	100	0	0
Field Dup	2	1	2	100	0	0
Lab Dup	0	0	0	100	0	0
Sample	144	87	130	90	14	10
Total	165		151		14
Acrolein
SampleType	# of Samples	% by Sample Type	# of Samples w/ No Sample Collection Errors/ Warnings (Flag_ Acrolein = 0)	% of Samples w/ No Sample Collection Errors/ Warnings (Flag_ Acrolein = 0)	# of Samples w/ Sample Collection Errors/ Warnings (Flag_ Acrolein = 1)	% of Samples w/ Sample Collection Errors/ Warnings (Flag_ Acrolein = 1)
Field Blank	13	8	13	100	0	0
Field Control	6	4	6	100	0	0
Field Dup	2	1	2	100	0	0
Lab Dup	0	0	0	100	0	0
Sample	144	87	130	90	14	10
Total	165		151		14

Variables for Carbonyl Data (samples collected using cartridges: Method TO-11A).

id = station1, station2, station3, station4

location = 10 meter, 100 meter, 300 meter, Upwind

SampleType = Field Blank, Field Control, Field Duplicate, Lab Duplicate, Sample

SampleDateTime = Date and Time of Sample

Acetaldehyde = µg/m³

Acrolein = µg/m³

Formaldehyde = µg/m³

BATCH = batch number of DNSH cartridge

Flag_Carbonyl = 0 or 1; 0 = valid data; 1 = invalid data (relates to the entire sample, across all pollutants)

Flag_Acetaldehyde = 0 or 1; 0 = valid data; 1 = invalid data

Flag_Acrolein = 0 or 1; 0 = valid data; 1 = invalid data

Flag_Formaldehyde = 0 or 1; 0 = valid data; 1 = invalid data

Data_Review_Comment = text field

Acetaldehyde_mdl = method detection limit for acetaldehyde (µg/m³)

Acrolein_mdl = method detection limit for acrolein µg/m³

Formaldehyde_mdl = method detection limit for formaldehyde (µg/m³)

Acetaldehyde_ppb = Acetaldehyde (ppb) (uncorrected for background)

Acrolein_ppb = Acrolein (ppb) (uncorrected for background)

Formaldehyde_ppb = Formaldehyde (ppb) (uncorrected for background)

Acetaldehyde_ppb_mdl = Acetaldehyde (ppb) method detection limit

Acrolein_ppb_mdl = Acrolein (ppb) method detection limit

Formaldehyde_ppb_mdl = Formaldehyde (ppb) method detection limit

Acetaldehyde_detect = 0 or 1; 0 = method detection limit value substitution (only occurs when measured value - background = negative value); 1 = actual value

Acrolein_detect = 0 or 1; 0 = method detection limit value substitution (only occurs when measured value - background = negative value); 1 = actual value

Formaldehyde_detect = 0 or 1; 0 = method detection limit substitution; 1 = below method detection limit

Acetaldehyde_BL = Acetaldehyde (µg/m³) background value

Acetaldehyde_ppb_BL = Acetaldehyde (ppb) background value

Acrolein_BL = Acrolein (µg/m³) background value

Acrolein_ppb_BL = Acrolein (ppb) background value

Acetaldehyde_BLCorrected = Acetaldehyde background corrected (µg/m³)

Acrolein_BLCorrected = Acrolein background corrected (µg/m³)

Acetaldehyde_ppb_BLCorrected = Acetaldehyde (ppb) background corrected

Acrolein_ppb_BLCorrected = Acrolein (ppb) background corrected

fcom = text field (field comment)