january 22 2003 marama mane vu science meeting n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
January 22, 2003 MARAMA Mane-VU Science Meeting PowerPoint Presentation
Download Presentation
January 22, 2003 MARAMA Mane-VU Science Meeting

Loading in 2 Seconds...

play fullscreen
1 / 19

January 22, 2003 MARAMA Mane-VU Science Meeting - PowerPoint PPT Presentation


  • 136 Views
  • Uploaded on

Combined Aerosol & Trajectory Tool (CATT) Development R. Husar, K. Hoijarvi, J. Colson, S. Falke Center for Air Pollution Impact and Trend Analysis (CAPITA) Washington University in St. Louis Project Officer: Serpil Kayin MARAMA. January 22, 2003 MARAMA Mane-VU Science Meeting.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'January 22, 2003 MARAMA Mane-VU Science Meeting' - dominic


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
january 22 2003 marama mane vu science meeting

Combined Aerosol & Trajectory Tool (CATT)DevelopmentR. Husar, K. Hoijarvi, J. Colson, S. FalkeCenter for Air Pollution Impact and Trend Analysis (CAPITA)Washington University in St. LouisProject Officer: Serpil KayinMARAMA

January 22, 2003

MARAMA Mane-VU Science Meeting

project background
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)
slide3

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, NH 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 paired chemical/trajectory analysis

data input pmf unmix source profiles and residence time

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

project objectives
Project Objectives
  • Implement a relational database that incorporates both the PMF/UNMIX results and gridded trajectory data.
  • Develop specific SQL filtering and aggregation queries for
    • aggregated trajectory data based on chemical specifications
    • aggregated chemical data based on geographic specifications
  • 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 the addition of chemical and trajectory data.
relational database

PMF/UNMIX Data

ATAD Residence Time

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)

CAPITA

SQL

Database

database structure
Database Structure

The dTrajResTime and dSourceApptables share the site_code and date keys thereby allowing paired queries to the SQL database.

sql queries
SQL Queries

SELECT Lat as lat,

Lon as lon,

Loc_Code as loc_code,

SUM(ResTime) AS [VALUE]

FROM dTrajResTime

WHERE ([Date] IN

(SELECT datetime

FROM dSourceApp

WHERE (Loc_Code = 'loc_code')

sql_filter_clause))

GROUP BY GridCode, Lat, Lon, Loc_Code

ORDER BY Lon ASC

Settings that are unique to a specific query are designated by red text

browsing atad trajectory and residence time
Browsing ATAD Trajectory and Residence Time
  • Residence time and ATAD trajectory data superimposed for June 1, 2000.
browsing chemical data
Browsing Chemical Data

Query/Retrieval/Rendering of chemical data from SQL server

seasonal residence time retrieval and rendering
Seasonal Residence Time Retrieval and Rendering

Lye Brook, JJA

Lye Brook, DJF

Gr Smoky Mtn, JJA

Gr Smoky Mt, DJF

paired chemical source restime data lye brook pmf source c6 sulfate titanium
Paired 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

catt data flow processing and rendering
CATT data flow, processing, and rendering

‘View’ Processing

Data Sources

Multi-dimensional

Data Cube

Spatial Portrayal

Spatial Overlay

Aerosol Data

Trajectory Time

CATT Browser

Spatial Slice

CAPITA

or transferred SQL RDB

Wrapper

Time Slice

Time Portrayal

Time Overlay

Wrapper

VIEWS

Other Data

(GIS, Met., …)

Wrapper

catt project status
CATT Project Status

Current effort to finalize queries and user interface

‘Public’ testing and user feedback is expected to being in April

slide17

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, NH 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

project deliverables
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 renderd 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.
project status summary
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