Transcript 030122MARAMAScienceMeeting - Capita

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
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)
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
Secondary Coal
Biomass Smoke
East Coast Residual Oil
Avg. Mass:
3.2 ug/m3 (42%)
Avg. Mass:
2.4 ug/m3 (32%)
Avg. Mass:
0.38 ug/m3 (5%)
Species:
S, OC, EC, Na
Species:
OC, EC, S, K
Species:
OC, EC, S, Si, Ni, V
Summer Maximum
Summer Maximum
Winter Maximum
High Secondary Coal contribution (yellow- High Biomass Smoke is transported from the
red) originates from Upper Ohio River region N-NW direction
High Residual Oil aerosol type is transported
from the East Coast Megalopolis
Low Secondary Coal values (green-blue)
occur during transport from Quebec
Low Residual Oil occurs during transport
from Quebec
Low Biomass Smoke occurs during transport
from Quebec and the Ohio RV Region
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
Prepared by
Typical Source Profiles
Battelle and Sonoma Tech. Inc.
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
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.
Project Objectives
1. Implement a relational database that incorporates both the PMF/UNMIX results
and gridded trajectory data.
2. Develop specific SQL filtering and aggregation queries for
•
•
aggregated trajectory data based on chemical specifications
aggregated chemical data based on geographic specifications
3. Develop a graphic interface for user input (query) and for data output as
rendered images or as exportable numeric data.
4. Transfer the resulting database to a designated SQL server and provide
instructions for the addition of chemical and trajectory data.
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)
ATAD
Residence Time
PMF/UNMIX
Data
CAPITA
SQL
Database
Database Structure
The dTrajResTime and dSourceApp tables share the
site_code and date keys thereby allowing paired
queries to the SQL database.
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
•
Residence time and ATAD trajectory data superimposed for June 1, 2000.
Browsing Chemical Data
Query/Retrieval/Rendering of chemical data from SQL server
Paired Trajectory and Chemical Data
Gr. Smoky Mtn. 1998 Pattern of PMF
Clusters c3, c5, c9
Seasonal Residence Time Retrieval and Rendering
Lye Brook, JJA
Lye Brook, DJF
Gr Smoky Mt, DJF
Gr Smoky Mtn, JJA
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
‘View’ Processing
Data Sources
Aerosol
Data
Multidimensional
Data Cube
Trajectory
Time
CAPITA
or transferred
SQL RDB
Spatial Portrayal
Spatial Overlay
CATT Browser
Spatial Slice
Wrapper
Time Slice
VIEWS
Other Data
(GIS, Met., …)
Wrapper
Wrapper
Time Portrayal
Time Overlay
CATT Project Status
Develop relational database of PMF/UNMIX and trajectory data
Develop specific SQL filtering and aggregation queries
- Chemical filtering/aggregation query
- Trajectory filtering/aggregation query
- Paired Chemical/Trajectory data query
Develop graphical user interface to database
Transfer the resulting database to a designated SQL server
Current effort to finalize queries and user interface
‘Public’ testing and user feedback is expected to being in April
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
Secondary Coal
Biomass Smoke
East Coast Residual Oil
Avg. Mass:
3.2 ug/m3 (42%)
Avg. Mass:
2.4 ug/m3 (32%)
Avg. Mass:
0.38 ug/m3 (5%)
Species:
S, OC, EC, Na
Species:
OC, EC, S, K
Species:
OC, EC, S, Si, Ni, V
Summer Maximum
Summer Maximum
Winter Maximum
High Secondary Coal contribution (yellow- High Biomass Smoke is transported from the
red) originates from Upper Ohio River region N-NW direction
High Residual Oil aerosol type is transported
from the East Coast Megalopolis
Low Secondary Coal values (green-blue)
occur during transport from Quebec
Low Residual Oil occurs during transport
from Quebec
Low Biomass Smoke occurs during transport
from Quebec and the Ohio RV Region
Project Goal:
Develop an interactive data query and analysis tool for the above paired chemical/trajectory analysis
Project Deliverables
1. Implement a relational database that incorporates both the PMF/UNMIX results
and for gridded trajectory data.
2. Develop specific SQL filtering and aggregation queries for
•
•
aggregated trajectory data based on chemical conditions
aggregated chemical data based on geographic conditions
3. Develop a graphic interface for user input (query) and for data output as renderd
images or as exportable numeric data.
4. Transfer the resulting database to a designated SQL server and provide
instructions for addition of chemical and trajectory data.
Project Status/Summary
1. Relational Database of PMF/UNMIX and trajectory data: Complete
2. 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
3. Graphic interface for user input (query) and for data output: Partially developed, needs
user input, testing, feedback
4. Transfer the resulting database to a designated SQL server: Not done
Project Milestones Jan-June 2003
1.
2.
3.
4.
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