Status, Topics, and Questions regarding the Federal Land Manager Environmental Database (FED) March 20, 2011

1. Status, Topics, and Questions regarding the Federal Land Manager Environmental Database (FED) March 20, 2011

2. Recent Activities… • Updated existing datasets through 2010: • CASTNet Dry Chemistry • EPA Nitrogen Dioxide - Hourly • EPA Ozone - Hourly • EPA PM10 Mass (81102) - Daily • EPA PM10 Mass (81102) - Hourly • EPA PM2.5 Mass (88502) - Daily • EPA PM2.5 Mass (88502) - Hourly • EPA PM2.5 Mass FRM (88101) - Daily • EPA PM2.5 Speciation - Daily • IMPROVE Aerosol • IMPROVE Aerosol, RHR (New Equation), with substituted data • NADP Atmospheric Integrated Research Monitoring Network • NADP National Trends Network

3. Recent Activities (continued)… • Acquired and imported additional datasets • CASTNet Multi-Layer Model data • CASTNet Ozone • EPA Carbon Monoxide (CO) – Hourly • EPA Sulfur Dioxide (SO2) – Hourly

4. Database Inventory (in staging)

5. Refined the FED website • Removed more VIEWS-specific references and resources • Removed pages, content, and code specific to VIEWS • Refined the user management subsystem • Made other refinements and infrastructural improvements • Upgraded various third-party software components • Upgraded the operating system and web server software • Migrated the FTP server to a newer machine with larger hard drives • Refined the FED database • Made various improvements to the integrated database schema • Refined the metadata management subsystem • Updated metadata references for new and updated datasets • Modified and optimized various indexes and table keys

6. Recent Activities (continued)… • Created a local SAS environment • Installed and configured SAS in preparation for: • Generating the IMPROVE RHR metrics (via Debbie Miller’s scripts) • Generating the various ozone metrics (via Debbie Miller’s scripts) • Worked with Scott Copeland to better understand Debbie Miller’s SAS scripts • Made preliminary design plans for reorganizing and “tightening” the scripts into a redistributable SAS package • Investigated the mechanisms for “driving” SAS from other programs (i.e. integrating it into the import process)

7. Short Term Activities… • Development Tasks • Finish mapping the metadata for various new datasets • Move all recently imported data from the staging database to the production database • Finish pending refinements of the FED website • Re-factor the Trends and Composition tools • Migrate relevant tools from the NASA ROSES project to the FED website • Google Maps display tool (for NetCDF, HDF, and other spatial files) • Data Availability and Timeline tool • Data and Metadata File Explorer • Additional datasets to be imported • The full complement of ozone metrics and summaries • Meteorological data (see questions) • Forest Service water quality data • Night Sky brightness imagery • Others (? – see questions)

8. Other Topics… • Obtaining a complete set of ozone data is confusing and difficult • Different databases and websites (AQS, CASTNet, POMS, ARD, etc.) • Different metadata schemes (sites, parameter, methods, etc.) • Organization and availability of source data files on the FED website • Organization of datasets, selection controls, and filtering choices on the online FED tools • Re-factoring of the Trends and Composition tool • Other questions…

9. Questions… • Do the following items (from the SOW) refer exclusively to AQS datasets? • Hourly PM 2.5 concentrations • Hourly PM10 concentrations • Hourly NO2 concentrations • Hourly SO2 concentrations • Hourly CO concentrations • Do the following items (from the SOW) refer exclusively to CASTNet datasets (and/or others, like NADP)? • Weekly wet deposition concentrations, including Ca, Cl, K, Mg, Na, NH4, NO3, SO4, Hg (mg/l and eq/l) • Weekly wet deposition, including Ca, Cl, K, Mg, Na, NH4, NO3, SO4, Hg (kg/ha) • Annual mean deposition concentrations, including Ca, Cl, K, Mg, Na, NH4, NO3, SO4, Hg (mg/l and eq/l) • 3- and 5-year averages of annual mean deposition concentrations (mg/l), including Ca, Cl, K, Mg, Na, NH4, NO3, SO4, Hg • Annual total wet deposition, including Ca, Cl, K, Mg, Na, NH4, NO3, SO4, Hg • 3- and 5- year averages of annual total wet deposition, including Ca, Cl, K, Mg, Na, NH4, NO3, SO4, Hg

10. Questions… • Where do we get the required meteorological data? • Temperature • Relative humidity • Scalar wind speed and wind direction • Vector wind speed and wind direction • Dew point • Solar radiation • Rainfall • Barometric pressure • How should the following derived datasets be generated and/or obtained? • Interpolated values of summary statistics, determined at park locations • Interpolated estimates of air quality condition, determined at park locations • Monitors used to compute trends for each park

11. Questions… • How should the following be obtained and/or derived, and presented on the website? • Time series plots of any data parameter (beyond current VIEWS functionality) • Tables with lists of park units exceeding NAAQS standards • Tables with summary ozone statistics (annual 4th-highest 8-hour, annual maximum 3-month W126, 3-year average of annual 4th-highest 8-hour, annual 1st and 2nd highest 1-hour, mean, median, 90th percentile, etc.) by monitoring site and park and forest resouce • Tables with summary visibility statistics (annual mean deciview and extinction on the best, median, and worst days) by park • Tables with annual air quality condition information (??) • Other data and metadata

12. Thank you.

13. Data Availability and Timeline Tool

14. Google Maps Spatial Display Tool

15. Data and Metadata File Explorer