AQS User Notes for June 23, 2011
Topics:
SO2 Design Values
Removal of ½ MDL substitution for HAPS and NATTS parameters + List of HAPS and NATTS Required Parameters for which ½ MDL substitution will end
Discoverer users – “NAAQS_Averages_V” update
1. SO2 Design Values are available
Via AQS Standard Retrievals – AMP480 Design Value Report Example:
Via Discoverer
Use the SO2_Design_Values folder. These queries will take time to run, so we recommend limiting your query as much as possible before running it. You can use the Workbook Wizard to select the state, county and site, as well as the Design Value Year, before running the query. The new SO2_Design_Values folder contains these fields:
State code
County code
Tribal code
Site ID
Parameter code
Pollutant name
DV Year (the year for which you are calculating the Design Value)
Design value
Street address
Local site ID
Local site name
Latitude
Longitude
State name
County name
Tribal name
City name
Urbanized area
CBSA name
Year DV POC (The POC used to supply the data for the year this design value was calculated.) Year DV Complete Quarters
Year DV 99th percentile
Year DV Complete Ind (Completeness Indicator – Y or N)
Year DV Cert IND (Certification Indicator – Y or N)
Year DV-1 POC (The POC used in this year. “DV-1” is the year prior to the year for which you are calculating the Design Value.) Year DV-1 Complete Quarters
Year DV-1 99th percentile
Year DV-1 Complete Ind (Completeness Indicator – Y or N)
Year DV-1 Cert IND (Certification Indicator – Y or N)
Year DV-2 POC (The POC used in this year. “DV-2” is two years prior to the year for which you are calculating the Design Value.) Year DV-2 Complete Quarters
Year DV-2 99th percentile
Year DV-2 Complete Ind (Completeness Indicator – Y or N)
Year DV-2 Cert IND (Certification Indicator – Y or N)
Standard ID
Standard description
Statistic name
Primary standard level Standard units code
Standard units name
Three year design validity
Each row is a 3-year summary and includes annual statistics and quarterly statistics. Each row also has the site metadata.
Example of one row:
Reminder that Design Values are the metrics (i.e., statistics) that are compared to the NAAQS levels to determine compliance. (Refer to 40 CFR Part 50, Appendix T.) SO2 Design Values are calculated at the sitelevel. The design value for the primary 1-hour NAAQS is the 3-year average of annual 99th percentile daily maximum 1-hour values for a monitoring site, or “the 1-hour primary standard design value.” Data from two or monitors in the same year at the same site, reported to AQS under different POCs, are not to be combined to meet data completeness requirements.
2. ½ MDL substitution
We propose to remove 1/2 MDL substitution for parameters classified in AQS as being HAPS (Hazardous Air Pollutants) or NATTS Required (Required compounds to be collected in the National Air Toxics Network) by the end of CY 2011. A list of these parameters is included. All ½ MDL substituted data in AQS back to CY1993 would be recalculated.
Currently in AQS, 1/2 MDL substitution is being performed for most parameters. It is not done for 74 pollutants that have the “Parameter Classification” of “1/2 MDL Substitution Suppressed.”
For parameters that have 1/2 MDL substitution, the reported sample measurement is always stored.
If the reported sample measurement > Absolute Minimum Sample Value, then the reported sample measurement is accepted by AQS. If the reported value is below the method detection limit (MDL) then the standard sample measurement would have 1/2 of the federal MDL substituted.
Any comments on removing ½ MDL substitution should be sent by July 29, 2011 to AQSTeam@epa.gov
3. DISCOVERER users who use “NAAQS_Averages_V”:
The units code and units description are now available in this folder.
List of HAPS and NATTS Required Parameters for which ½ MDL substitution will end:
|
AQS Parameter Code |
Parameter Description |
|
12102 |
Antimony (Tsp) Stp |
|
12103 |
Arsenic (Tsp) Stp |
|
12105 |
Beryllium (Tsp) Stp |
|
12110 |
Cadmium (Tsp) Stp |
|
12112 |
Chromium (Tsp) Stp |
|
12113 |
Cobalt (Tsp) Stp |
|
12115 |
Chromium Vi (Tsp) Stp |
|
12128 |
Lead (Tsp) Stp |
|
12132 |
Manganese (Tsp) Stp |
|
12136 |
Nickel (Tsp) Stp |
|
12142 |
Mercury (Tsp) Stp |
|
12152 |
Phosphorus (Tsp) Stp |
|
12154 |
Selenium (Tsp) Stp |
|
12803 |
Asbestos Amphibole (Tsp) |
|
14102 |
Antimony (Tsp) Lc |
|
14103 |
Arsenic (Tsp) Lc |
|
14105 |
Beryllium (Tsp) Lc |
|
14110 |
Cadmium (Tsp) Lc |
|
14112 |
Chromium (Tsp) Lc |
|
14113 |
Cobalt (Tsp) Lc |
|
14115 |
Chromium Vi (Tsp) Lc |
|
14128 |
Lead (Tsp) Lc Non-Frm/Fem |
|
14132 |
Manganese (Tsp) Lc |
|
14136 |
Nickel (Tsp) Lc |
|
14142 |
Mercury (Tsp) Lc |
|
14154 |
Selenium (Tsp) Lc |
|
16601 |
1,2-Epoxybutane (Tsp)Stp |
|
16714 |
Hexamethylene Diisocyanate |
|
16722 |
N-Nitrosodimethylamine (Tsp) Stp |
|
16725 |
1,2,4-Trichlorobenzene (Tsp) Stp |
|
16729 |
1,4-Dichlorobenzene (Tsp) Stp |
|
16767 |
Bis (2-Chloroethyl)Ether (Tsp) Stp |
|
16782 |
Hexachlorobutadiene (Tsp) Stp |
|
16788 |
Nitrobenzene (Tsp) Stp |
|
16797 |
Phenol (Tsp) Stp |
|
16807 |
Hexachloroethane (Tsp) Stp |
|
16826 |
Hexachlorocyclopentadiene (Tsp) Stp |
|
16901 |
Epichlorohydrin(Dup) |
|
16914 |
Isophorone (Tsp) Stp |
|
17141 |
Naphthalene (Tsp) Stp |
|
17149 |
Fluorene (Tsp) Stp |
|
17150 |
Phenanthrene (Tsp) Stp |
|
17151 |
Anthracene (Tsp) Stp |
|
17199 |
Polycyclic Organic Matter (Tsp) Stp |
|
17204 |
Pyrene (Tsp) Stp |
|
17208 |
Chrysene (Tsp) Stp |
|
17211 |
Coronene (Tsp) Stp |
|
17212 |
Perylene (Tsp) Stp |
|
17215 |
Benzo[A]Anthracene (Tsp) Stp |
|
17220 |
Benzo[B]Fluoranthene (Tsp) Stp |
|
17223 |
Benzo[K]Fluoranthene (Tsp) Stp |
|
17224 |
Benzo[E]Pyrene (Tsp) Stp |
|
17242 |
Benzo[A]Pyrene (Tsp) Stp |
|
17301 |
O-Cresol (Tsp) Stp |
|
17302 |
M-Cresol (Tsp) Stp |
|
17303 |
P-Cresol (Tsp) Stp |
|
17710 |
O-Toluidine (Tsp) Stp |
|
17716 |
3,3'-Dichlorobenzidene (Tsp) Stp |
|
17725 |
Pentachloronitrobenzene (Tsp) Stp |
|
17804 |
Hexachlorobenzene (Tsp) Stp |
|
17808 |
Pentachlorophenol (Tsp) Stp |
|
17833 |
Polychlorinated Biphenyls (Pcbs) |
|
17902 |
Dibenzo[B,E][1,4]Dioxin,2,3,7,8-Tetrachloro (Tsp) Stp |
|
17906 |
2,4-Toluene Diisocyanate |
|
18202 |
Dibenzofuran (Tsp) Stp |
|
42153 |
Carbon Disulfide |
|
42215 |
Chlorine |
|
42302 |
Hydrochloric Acid |
|
42303 |
Hydrofluoric Acid |
|
43153 |
Methoxychlor |
|
43166 |
1,1-Dichloroethenylidene Bis(4-Chlorobenzene) |
|
43218 |
1,3-Butadiene |
|
43231 |
N-Hexane |
|
43250 |
2,2,4-Trimethylpentane |
|
43301 |
Methanol |
|
43335 |
3-Chloropropene |
|
43352 |
Dichloroethyl Ether |
|
43372 |
Methyl Tert-Butyl Ether |
|
43438 |
Ethyl Acrylate |
|
43441 |
Methyl Methacrylate |
|
43447 |
Vinyl Acetate |
|
43502 |
Formaldehyde |
|
43503 |
Acetaldehyde |
|
43504 |
Propionaldehyde |
|
43505 |
Acrolein - Unverified |
|
43509 |
Acrolein - Verified |
|
43560 |
Methyl Isobutyl Ketone |
|
43601 |
Ethylene Oxide |
|
43602 |
Propylene Oxide |
|
43702 |
Acetonitrile |
|
43704 |
Acrylonitrile |
|
43756 |
2-Nitropropane |
|
43801 |
Chloromethane |
|
43802 |
Dichloromethane |
|
43803 |
Chloroform |
|
43804 |
Carbon Tetrachloride |
|
43806 |
Bromoform |
|
43808 |
Methyl Iodide |
|
43812 |
Chloroethane |
|
43813 |
1,1-Dichloroethane |
|
43814 |
Methyl Chloroform |
|
43815 |
Ethylene Dichloride |
|
43817 |
Tetrachloroethylene |
|
43818 |
1,1,2,2-Tetrachloroethane |
|
43819 |
Bromomethane |
|
43820 |
1,1,2-Trichloroethane |
|
43824 |
Trichloroethylene |
|
43826 |
1,1-Dichloroethylene |
|
43829 |
1,2-Dichloropropane |
|
43830 |
Trans-1,3-Dichloropropene |
|
43831 |
Cis-1,3-Dichloropropene |
|
43835 |
Chloroprene |
|
43841 |
1,3-Dichloropropene(Total) |
|
43843 |
Ethylene Dibromide |
|
43844 |
Hexachlorobutadiene |
|
43860 |
Vinyl Chloride |
|
43861 |
Vinyl Bromide |
|
45102 |
Xylene(S) |
|
45201 |
Benzene |
|
45202 |
Toluene |
|
45203 |
Ethylbenzene |
|
45204 |
O-Xylene |
|
45205 |
M-Xylene |
|
45206 |
P-Xylene |
|
45210 |
Isopropylbenzene |
|
45220 |
Styrene |
|
45300 |
Phenol |
|
45301 |
Biphenyl |
|
45704 |
4,4-Methylenedianiline |
|
45705 |
Nitrobenzene |
|
45732 |
4,4-Methylenediphenyl Diisocyanate (Mdi) |
|
45801 |
Chlorobenzene |
|
45807 |
1,4-Dichlorobenzene |
|
45809 |
Benzyl Chloride |
|
45810 |
1,2,4-Trichlorobenzene |
|
46201 |
1,4-Dioxane |
|
82103 |
Arsenic Pm10 Stp |
|
82105 |
Beryllium Pm10 Stp |
|
82110 |
Cadmium Pm10 Stp |
|
82112 |
Chromium Pm10 Stp |
|
82128 |
Lead Pm10 Stp |
|
82132 |
Manganese Pm10 Stp |
|
82136 |
Nickel Pm10 Stp |
|
82142 |
Mercury Pm10 Stp |
|
85102 |
Antimony Pm10 Lc |
|
85103 |
Arsenic Pm10 Lc |
|
85105 |
Beryllium Pm10 Lc |
|
85110 |
Cadmium Pm10 Lc |
|
85112 |
Chromium Pm10 Lc |
|
85113 |
Cobalt Pm10 Lc |
|
85128 |
Lead Pm10 Lc |
|
85132 |
Manganese Pm10 Lc |
|
85136 |
Nickel Pm10 Lc |
|
85142 |
Mercury Pm10 Lc |
|
85154 |
Selenium Pm10 Lc |
|
88103 |
Arsenic Pm2.5 Lc |
|
88105 |
Beryllium Pm2.5 Lc |
|
88110 |
Cadmium Pm2.5 Lc |
|
88112 |
Chromium Pm2.5 Lc |
|
88128 |
Lead Pm2.5 Lc |
|
88132 |
Manganese Pm2.5 Lc |
|
88136 |
Nickel Pm2.5 Lc |
|
88142 |
Mercury Pm2.5 Lc |
|
92142 |
Mercury Compounds |