The NAtChem Database and Analysis Facility

1. The NAtChem Database and Analysis Facility Chul-Un Ro, Julie Narayan, Elton Chan, Mike Shaw, Bill Sukloff and Bob Vet

2. The NAtChem Database and Analysis Facility Databases: • NAtChem/Precipitation Chemistry • NAtChem/PM and Toxics • NAtChem/CORE • NAtChem/Pacific2001

3. NEW NAtChem/Precipitation ChemistryDatabase - Status • The entire archive was transferred from a UNIX server to a new format on a Windows2003 server • The networks included in archive are: and 16 additional historical networks • Data and products are now accessible on-line - Data Exchange Standard (DES) files - Summary Statistics files (Annual, Seasonal, Quarterly & Monthly) - Time series plots - Data summary reports - Isopleth maps

4. NAtChem/Precipitation ChemistryMonitoring Sites in 2004

5. NAtChem/Precipitation Chemistry - Results to Date • Canada-US Biannual Air Quality Progress Report • 2004 Acid Rain Science Assessment Report • NADP Annual Report • Front Lobby / EC-HQ Display • Raster grid data (in ArcView format) for various data requests • Material Corrosion Study

6. NADP Annual Report Joint product of the US National Atmospheric Deposition Program and the Canadian National Atmospheric Chemistry Database and Analysis Facility (NADP and NAtChem) The NADP 2003 Annual Summary

7. 2004 Acid Rain Science Assessment Report nss-SO4= Wet Deposition 5-Year Mean Pattern Changes 20 MT 1990-1994 15 MT 1996-2000 SO2 Emissions

8. 2004 Acid Rain Science Assessment Report Changes from 1990-1994 To 1996-2000 nssSO4= Wet Deposition SO2 Emissions -19% -25% -14% -20% ENA: -15% ENA: -21%

9. 2004 Acid Rain Science Assessment Report Mass Balance Estimates of US to Canada Transboundary Transport Results: • 45 to 75% of the sulphur wet deposited in eastern Canada is attributable to eastern US SO2 emissions • US emission reductions play a major role in lowering sulphur wet deposition in eastern Canada

10. Front Lobby / EC-HQ Display

11. NAtChem/Precipitation Chemistry - Planned Work • Develop a new set of enhanced wet deposition maps that include climatological precipitation data • Prepare papers on the Acid Rain Science Assessment results • Continue to collect/convert/quality assure/archive/analyze North American precipitation chemistry data

12. NEW NAtChem/PM and Toxics Database - Status • The networks included in archive are: and 9 additional historical networks • Data and products are now accessible on-line - Data Exchange Standard (DES) files - Summary Statistics files (Annual, Seasonal & Quarterly) - Time series plots

13. NAtChem/PMMonitoring Sites in 2002

14. NAtChem/PM and Toxics Database - Results to date • NAtChem data and products made available online at: http://www.msc.ec.gc.ca/natchem • Provided input to the Transboundary PM Report

15. NAtChem Data and Products Online • Data can be selected by: • Database type • Network • Year • Province/State • Parameter group • Has resulted in increased use of NAtChem data and products • Uses the Ontario Region server and infrastructure

16. NAtChem Data and Products Online • Data Exchange Standard (DES) data files • Summary statistics files • Overlay time series plots • Continuous time series plots • Sampling history plots – by parameter • Isopleth maps

17. NAtChem Data and Products Online

18. NAtChem Data and Products Online

19. Archived In Progress Action Pending NAtChem/CORE Database - Work to Date

20. NAtChem/CORE Database - Results to Date • Exploratory Data Analysis on Alert and CAMNet data including: • Time series modelling • Source-Receptor Modeling • Principal Component Analysis (PCA) • Positive Matrix Factorization (PMF) • Potential Source Contribution Function (PSCF)

21. NAtChem CORE Data Analysis - Alert(An example of PCA with trajectories incorporated)

22. NAtChem CORE Data Analysis - CAMNet

23. NAtChem/CORE Database - Planned Work • Analysis of Alert and CAMNet data in collaboration with CORE and CAMNet PIs inlcuding: • Statistical techniques to handle BDLs and data gaps (e.g. Kalman Filtering) • Methods to handle data sets with mixed temporal resolution • Positive Matrix Factorization with the incorporation of back trajectories

24. NAtChem/Pacific2001 Database - Work to Date • QA and preparation of files for submission to the NARSTO Data Center • Cassier Tunnel: 29 of 57 • Slocal Park: 29 of 40 • Langley: 41 of 58 • Golden Ears: 13 of 15 • Sumas Mountain: 27 of 44 • Convair 580: 34 of 36 • CFS Cessna: 22 of 23 -------------------------------------------------- • TOTAL: 195 of 273 (71%) possible files

25. NAtChem/Pacific2001 Database The Quality Assurance Package Enhancements for DES files include: • 20 new checks (date/time, metadata) • Time series plot file size dramatically reduced • Program code shared with NARSTO, NAtChem, CORE, EPA Supersites

26. NAtChem/Pacific2001 Database - Planned Work • Delivery of final Pacific2001 data files to the NARSTO Data Center on October 31, 2004 • Requires further quality assurance applied to data • To date, data files from four Principal Investigators and the Cessna have been submitted

27. The NAtChem Database and Analysis Facility - Conclusions • Web-based data and product downloads are now available and are being used by governments, universities and others • The budget, schedule and analysis work are all on track • The hiring of the NAtChem/PM scientist has been delayed