database and analytical tool development for the management of data derived from us doe (netl)...
TRANSCRIPT
![Page 1: Database and Analytical Tool Development for the Management of Data Derived from US DOE (NETL) Funded Fine Particulate (PM 2.5 ) Research](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649e4f5503460f94b46ba2/html5/thumbnails/1.jpg)
Database and Analytical Tool Development for the
Management of Data Derived from US DOE (NETL) Funded
Fine Particulate (PM2.5) Research
![Page 2: Database and Analytical Tool Development for the Management of Data Derived from US DOE (NETL) Funded Fine Particulate (PM 2.5 ) Research](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649e4f5503460f94b46ba2/html5/thumbnails/2.jpg)
Project Objectives
Primary objective is to develop a comprehensive, web-based application for:
•Integrating the ambient air quality data being collected under multiple on-going DOE-sponsored monitoring programs in the Upper Ohio River Valley (UORV) region
•Creating a publicly-available tool for accessing, displaying, analyzing and interpreting these air quality data
![Page 3: Database and Analytical Tool Development for the Management of Data Derived from US DOE (NETL) Funded Fine Particulate (PM 2.5 ) Research](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649e4f5503460f94b46ba2/html5/thumbnails/3.jpg)
Project Team Leaders
Dr. Robinson P. Khosah, Ph.DAdvanced Technology Systems, Inc.
Dr. Kevin Crist, Ph.DOhio University
Dr. Kuruvilla John, Ph.DTexas A&M University-Kingsville
![Page 4: Database and Analytical Tool Development for the Management of Data Derived from US DOE (NETL) Funded Fine Particulate (PM 2.5 ) Research](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649e4f5503460f94b46ba2/html5/thumbnails/4.jpg)
Application Platform
• Development - Microsoft Visual Studio .NET• Database - Microsoft SQL Server 2000 Enterprise
Edition• Web/Application Server - Microsoft Internet
Information Services
![Page 5: Database and Analytical Tool Development for the Management of Data Derived from US DOE (NETL) Funded Fine Particulate (PM 2.5 ) Research](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649e4f5503460f94b46ba2/html5/thumbnails/5.jpg)
• Server Hardware and Software With Terabyte-Scale Data Capacity
• Servers Located in Pittsburgh, PA; Athens, OH and Kingsville, TX For Redundancy and Availability.
Database Features
![Page 6: Database and Analytical Tool Development for the Management of Data Derived from US DOE (NETL) Funded Fine Particulate (PM 2.5 ) Research](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649e4f5503460f94b46ba2/html5/thumbnails/6.jpg)
Data Collection Sites
![Page 7: Database and Analytical Tool Development for the Management of Data Derived from US DOE (NETL) Funded Fine Particulate (PM 2.5 ) Research](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649e4f5503460f94b46ba2/html5/thumbnails/7.jpg)
EPA and NCDC Sites
![Page 8: Database and Analytical Tool Development for the Management of Data Derived from US DOE (NETL) Funded Fine Particulate (PM 2.5 ) Research](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649e4f5503460f94b46ba2/html5/thumbnails/8.jpg)
NESCAUM and MARAMA Sites
![Page 9: Database and Analytical Tool Development for the Management of Data Derived from US DOE (NETL) Funded Fine Particulate (PM 2.5 ) Research](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649e4f5503460f94b46ba2/html5/thumbnails/9.jpg)
Measured Parameters• Gases: CO, SO2, Nitrogen Oxides, Ammonia, Ozone, VOC’s
and Hydrogen Peroxide.
• PM Sampling: PM10, PM2.5 , PM2.5-10 and TSP
• PM Chemistry : Mass, Ions, Metals, Elements, Nitrate,Sulfate, Organic Carbon/Elemental Carbon (OC/EC), Semi-volatile organics and Organic speciation
• Meteorological Parameters: Relative Humidity, Wind Speed, Wind Direction, Temperature, Precipitation and Pressure
![Page 10: Database and Analytical Tool Development for the Management of Data Derived from US DOE (NETL) Funded Fine Particulate (PM 2.5 ) Research](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649e4f5503460f94b46ba2/html5/thumbnails/10.jpg)
Web-Based Retrieval System• XML Web Services
• Tabular Datasets
HTTP
Web Forms andTables
Mis
c.
Da
taS
ou
rce
PM
Dat
a S
ou
rce
XML Web Services Mis
c.
Da
taS
ou
rce
Ge
og
rap
hic
Da
taS
ou
rce
...linkedexternal
data
queryinterface
output
![Page 11: Database and Analytical Tool Development for the Management of Data Derived from US DOE (NETL) Funded Fine Particulate (PM 2.5 ) Research](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649e4f5503460f94b46ba2/html5/thumbnails/11.jpg)
XML Web Services• Create custom interfaces using MS Visual
Studio .NET• Methods -pre-programmed procedures to
retrieve data and perform analysis calculations.
• Properties -assignable property values. Used for data retrieval and analysis calculations.
![Page 12: Database and Analytical Tool Development for the Management of Data Derived from US DOE (NETL) Funded Fine Particulate (PM 2.5 ) Research](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649e4f5503460f94b46ba2/html5/thumbnails/12.jpg)
Web Service Interface
![Page 13: Database and Analytical Tool Development for the Management of Data Derived from US DOE (NETL) Funded Fine Particulate (PM 2.5 ) Research](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649e4f5503460f94b46ba2/html5/thumbnails/13.jpg)
Offline Datasets
• Datasets Can Be Downloaded For Further Use Locally
• Datasets Are Cached At The Server To Reduce Database Resource Demands
• Offline Datasets Are Available In NARSTO, CSV And XML Formats
![Page 14: Database and Analytical Tool Development for the Management of Data Derived from US DOE (NETL) Funded Fine Particulate (PM 2.5 ) Research](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649e4f5503460f94b46ba2/html5/thumbnails/14.jpg)
Standard ad hoc Query Builder
2) Select Output Criteria
1) Select Input Criteria
3) Execute Query
![Page 15: Database and Analytical Tool Development for the Management of Data Derived from US DOE (NETL) Funded Fine Particulate (PM 2.5 ) Research](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649e4f5503460f94b46ba2/html5/thumbnails/15.jpg)
Standard ad hoc Query Builder
Screenshot - Tabular Results with Paging Enabled 4) View Table of Results
![Page 16: Database and Analytical Tool Development for the Management of Data Derived from US DOE (NETL) Funded Fine Particulate (PM 2.5 ) Research](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649e4f5503460f94b46ba2/html5/thumbnails/16.jpg)
Standard ad hoc Query Builder
Screenshot - Tabular Results with Download Option
5) Save Results Locally
![Page 17: Database and Analytical Tool Development for the Management of Data Derived from US DOE (NETL) Funded Fine Particulate (PM 2.5 ) Research](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649e4f5503460f94b46ba2/html5/thumbnails/17.jpg)
1) Choose Parameters
2) Choose Date Range
3) View Results Or Download Data File
GIS ad hoc Query Builder
![Page 18: Database and Analytical Tool Development for the Management of Data Derived from US DOE (NETL) Funded Fine Particulate (PM 2.5 ) Research](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649e4f5503460f94b46ba2/html5/thumbnails/18.jpg)
1) Click data cart tool.
3) When features are selected, results appear below. Deselect features if desired.
2) Single click or draw box around features of active layer/s to select. Selected features appear with red outline.
4) Press continue.
GIS Query Data Cart
![Page 19: Database and Analytical Tool Development for the Management of Data Derived from US DOE (NETL) Funded Fine Particulate (PM 2.5 ) Research](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649e4f5503460f94b46ba2/html5/thumbnails/19.jpg)
GIS Visualization Tools
1
2 3
1
2
3
•Zoom in on the area of interest
•Turn layers on or off for visual clarification
•Make layers active
![Page 20: Database and Analytical Tool Development for the Management of Data Derived from US DOE (NETL) Funded Fine Particulate (PM 2.5 ) Research](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649e4f5503460f94b46ba2/html5/thumbnails/20.jpg)
1) Click buffer tool. 2) Select any feature of any active layer.
GIS Buffer Tool
![Page 21: Database and Analytical Tool Development for the Management of Data Derived from US DOE (NETL) Funded Fine Particulate (PM 2.5 ) Research](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649e4f5503460f94b46ba2/html5/thumbnails/21.jpg)
All EPA sites within 20 miles of Pittsburgh have been selected
Geographic Characteristics
![Page 22: Database and Analytical Tool Development for the Management of Data Derived from US DOE (NETL) Funded Fine Particulate (PM 2.5 ) Research](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649e4f5503460f94b46ba2/html5/thumbnails/22.jpg)
Plume Dispersion
![Page 23: Database and Analytical Tool Development for the Management of Data Derived from US DOE (NETL) Funded Fine Particulate (PM 2.5 ) Research](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649e4f5503460f94b46ba2/html5/thumbnails/23.jpg)
Wind Characteristics
Comparison by Sites
Plume Dispersion
Cluster Analysis
Pollution Rose
Meteorological Influence
Time Series Plot
Trajectory Analysis
(Trajectory Animation)
Analysis Tools
View Flash Demo
![Page 24: Database and Analytical Tool Development for the Management of Data Derived from US DOE (NETL) Funded Fine Particulate (PM 2.5 ) Research](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649e4f5503460f94b46ba2/html5/thumbnails/24.jpg)
GIS Visualization: Spatial Averaging Kriging techniques used to spatially average ground level
data over a region.
![Page 25: Database and Analytical Tool Development for the Management of Data Derived from US DOE (NETL) Funded Fine Particulate (PM 2.5 ) Research](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649e4f5503460f94b46ba2/html5/thumbnails/25.jpg)
Stakeholder Website• Go-Live date for performance trials:
June 15, 2004• Password protected• Upload datasets• Edit datasets• Download datasets• Poll data with XML Web Services• Forum capabilities with ASP.NET Web
Forums• Associate notes with specific data values
![Page 26: Database and Analytical Tool Development for the Management of Data Derived from US DOE (NETL) Funded Fine Particulate (PM 2.5 ) Research](https://reader036.vdocuments.us/reader036/viewer/2022062408/56649e4f5503460f94b46ba2/html5/thumbnails/26.jpg)
Discussion