1 / 11

Project Background

abram
Télécharger la présentation

Project Background

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. MARAMA/NESCAUM/LADCO Project:Source Apportionment of Air Quality Monitoring Data:Paired Aerosol / Trajectory Database AnalysisTool DevelopmentR. Husar, K. Hoijarvi, J. Colson, S. Falke, CAPITAProject Officer, Serpil Kayin, MARAMAProject Period: September 2002 – July 2003Progress Report: Dec 2002

  2. Project Background • The source-receptor relationship of particulate matter can be estimated by a number of empirical observation-based techniques. Some techniques are based chemical fingerprinting others on meteorological transport techniques. • A particularly attractive source-attribution technique, Paired Aerosol / Trajectory Analysis developed by Poirot and Wishinski. It combines the chemical and transport techniques by: • Establishing the major aerosol types at a specific receptor location and time (PMF and UNMIX) • Estimating the geographic transport regions for each aerosol type (Residence Time Analysis)

  3. Secondary Coal Avg. Mass: 3.2 ug/m3 (42%) Species: S, OC, EC, Na Summer Maximum Biomass Smoke Avg. Mass: 2.4 ug/m3 (32%) Species: OC, EC, S, K Summer Maximum East Coast Residual Oil Avg. Mass: 0.38 ug/m3 (5%) Species: OC, EC, S, Si, Ni, V Winter Maximum Illustration of Paired Chemical and Trajectory Analysis, Lye Brook, VT Wishinski and Poirot (2002)Based on Positive Matrix Factorization, PMF results from B. Coutant and ATAD trajectories from K. Gebhart High Secondary Coal contribution (yellow-red) originates from Upper Ohio River region Low Secondary Coal values (green-blue) occur during transport from Quebec High Biomass Smoke is transported from the N-NW direction Low Biomass Smoke occurs during transport from Quebec and the Ohio RV Region High Residual Oil aerosol type is transported from the East Coast Megalopolis Low Residual Oil occurs during transport from Quebec Project Goal: Develop an interactive data query and analysis tool for the above paired chemical/trajectory analysis

  4. Typical Source Profiles Prepared by Battelle and Sonoma Tech. Inc. Data Input: PMF/UNMIX Source Profiles and Residence Time Residence Time (calculated as “hours per 80 x 80 km grid cell”) at each 16 site and receptor day, were calculated by P. Wishinski, VT DEC The ResTime calculations are based on daily ATAD trajectories provided K. Gebhart, CIRA. Source attribution results (PMF and UNMIX) for 16 receptor sites between Illinois and New England using IMPROVE and CastNet data have been completed by a previous project. The results of the Battelle/Sonoma PMF and UNMIX modeling are source profile time series for each location

  5. Project Deliverables • Implement a relational database that incorporates both the PMF/UNMIX results and for gridded trajectory data. • Develop specific SQL filtering and aggregation queries for • aggregated trajectory data based on chemical conditions • aggregated chemical data based on geographic conditions • Develop a graphic interface for user input (query) and for data output as rendered images or as exportable numeric data. • Transfer the resulting database to a designated SQL server and provide instructions for addition of chemical and trajectory data.

  6. Deliverable 1: Relational database • PMF and UNMIX data transfer to SQL • The PMF and UNMIX results were provided to us as Excel spreadsheet. • The metadata for the PMF and UNMIX were obtained verbally from R. Poirot. • The spreadsheet data were reformatted and imported in the SQL server two tables (ChemFactTable and LocTable) • Residence Time data transfer to SQL • The residence time data were provided by P. Wishinski on CDROM including full metadata documentation • The data were imported into two SQL tables (ResTimeFactTable and LocTable) • Deliverable Status: Complete

  7. Deliverable 2,3: SQL Filtering/Aggregation/Rendering Tool Chemical Data Residence Time Data Query/Retrieval/Rendering of chemical data from SQL server Status: Developed, User interface needs testing and feedback Query/Retrieval/Rendering of residence time data from SQL server Status: Developed, User interface needs testing and feedback

  8. Deliverable 2,3:SQL Filtering/Aggregation/Rendering ToolSeasonal Residence Time, e.g. Sum ResTime for Loc=LYBR, Date between June-Sept Gr Smoky Mtn, DJF Lye Brook, DJF Lye Brook, JJA Gr Smoky Mtn, JJA

  9. Deliverable 2,3:SQL Filtering/Aggregation/Rendering ToolTesting the ATAD Trajectory and Residence Time Data Consistency • Residence time and ATAD trajectory data superimposed for June 1, 2000.

  10. Deliverable 2,3:SQL Filtering/Aggregation/Rendering ToolPaired Chemical ‘Source’/ResTime Data, LYE BROOK, PMF Source C6 Sulfate, Titanium ResTime for High C6 (BioSmoke?) Chemical Conditions ResTime for Low C6 (BioSmoke?) Chemical Conditions Query/Retrieval/Rendering of PAIRED data from SQL server Status: - Query partially developed – Needs user input, testing - User Interface partially developed – Needs user input, testing

  11. Project Status/Summary • Relational Database of PMF/UNMIX and trajectory data: Complete • Develop specific SQL filtering and aggregation queries • Chemical filtering/aggregation: Developed, needs testing and feedback • Trajectory filtering/aggregation: Developed, needs testing and feedback • Paired Chemical/Trajectory data: Partially developed, needs user input, testing, feedback • Graphic interface for user input (query) and for data output: Partially developed, needs user input, testing, feedback • Transfer the resulting database to a designated SQL server: Not done Project Milestones Jan-June 2003 • Feb 1, 03: Complete initial queries, user interface and displays • Apr 1, 03: Finalize design/implementation of queries, user interface and displays • Apr-Jun 03: ‘Public’ testing and user feedback • July 03: Tool delivery

More Related