U.S. Forest Service ARM All-Hands Call November 4th, 2015
FED Tools Demonstration Outline – Shawn McClure, CIRA
|
Website
· FED home page for the U.S. Forest Service Water Quality Data ( FED website à Data Access à U.S.F.S. Water Quality Data )
o Integrated Database Tools: Tools for exploring the data from the integrated FED database
o Documentation: Various documents and reference materials
o Source Data Queries: Some predefined queries of the original source data as received from the Forest Service
o Original Source Files: FTP links to the original source data files received from the Forest Service
Introduction
· FED System Architecture Diagram
· FED Data Import Process Diagram
Tools and Resources
Explore monitoring site locations on a map (by Project)
· “Choose a network or dataset” dropdown
· Google Map
o Monitoring site locations (red teardrop icons)
o Selected site (yellow teardrop icon)
o Mousing-over a site shows info window (SiteName, SiteCode)
o Zooming in / Zooming out (mouse wheel or map controls)
o Panning (mouse hand)
o Map or Satellite view
o De-select all link
o Reset view link
· Tabs (Reports)
o Site Metadata
§ Title: Site Name (Site Code)
§ Basic site metadata table
§ Site parameters table
· Parameter name
· Start date of available data
· End date of available data
· Number of records
· Minimum parameter value
· Maximum parameter value
· Average parameter value
§ Select all Parameters checkbox
§ “Get raw data…” button
· Raw Data Report
· Click on link (text file renders in browser)
· Right-click on link and select “Open in new tab/window”
· Right-click on link and select “Save link as…”
§ “View charts…” button
· Site data chart report
· One chart for each Parameter selected
· Very general-purpose, no control over charting options
· Show chart data link
· Chart data in Microsoft Excel
o Site Data Charts
§ Very general-purpose, no control over charting options
§ Defaults to bar chart
§ Mouse-over chart bars shows data point(s)
§ “Show chart data” link
§ “Chart data in Microsoft Excel” link
§ Start Date and End Date controls
o Site Sampling Calendar
§ Shows the entire temporal range of available data at the selected Site
§ Highlights the sampling days
§ Clicking on a sampling day will show a popup of data for that day
o List of Project Sites
§ Shows a list of all the monitoring sites for the selected Project/Wilderness
§ “Export to text file…” link
Explore monitoring site locations on a map (by Wilderness)
· “Choose a network or dataset” dropdown: Now shows Wilderness Areas instead of Projects
· All the bullets discussed above (for the “Explore monitoring site locations on a map (by Project)” link) apply almost identically for this link as well.
Query the database using the Query Wizard (FS water data only)
· A general-purpose tool for querying and filtering the integrated database to obtain raw data and charts
· Reports tab
o Click the radio button for the desired report
o Raw Data report: Obtain raw observational data
o Interactive Charts: Visualize observational data with charts and graphs
o Extinction Composition: Not applicable to the water quality data
o Extinction Trends: Not applicable to the water quality data
o Mouse-over underlined terms to view their definition
· Datasets tab
o Shows a table of all the available Datasets (Projects), sorted by Dataset (Project) name
o Dataset (Project) name
o Description
o Sampling Frequency
o Start year for available data
o End year for available data
· Sites tab
o Site name
o Site code
§ Truncated for the water quality data
§ You can click the “Export” button to obtain metadata for selected Sites
o State
o Latitude
o Longitude
o Elevation
o Start
o End
· Parameters tab
o Parameter name
o Parameter code
o Parameter type
o Acquisition method
o Units
o AQS ID
· Dates tab
o Select by Years and Months
o Select by Date Range
· Aggregations tab
o Not applicable to the water quality data
· Fields tab
o Choose output fields to include in your data file
· Options tab
o Set a variety of output and formatting options
· Raw Data Report
o Click on link (text file renders in browser)
o Right-click on link and select “Open in new tab/window”
o Right-click on link and select “Save link as…”
· Interactive Charts Report
o X-axis (date axis) label formatting options:
§ Date Axis Label Format
§ Date Axis Label Step
§ Date Axis Label Angle
Query the database using the Query Wizard (all datasets)
· Datasets tab: Now shows all available datasets, both air and water quality
· All the bullets discussed above (for the “Query the database using the Query Wizard (FS water data only)” link) apply almost identically for this link as well.
View a list of all sampling Sites – Displays a sortable table of sampling Site metadata from the imported metadata file provided by the Forest Service
View a list of all sampling Visits – Displays a sortable table of sampling Visits metadata from the imported metadata file provided by the Forest Service
View Project metadata statistics – Displays a sortable table of Project statistics from the integrated database.
View Site metadata statistics – Displays a sortable table of Site statistics from the integrated database.
Download the original source files (as provided by the U.S.F.S.) – A link to the FTP site where the original water data files provided by the U.S. Forest Service are stored
Download the original Sites metadata file (*.csv) – A link to the original Sites metadata file provided by the U.S. Forest Service
Download the original Visits metadata file (*.csv) – A link to the original Visits metadata file provided by the U.S. Forest Service
Download the original Measurements data file (*.csv) – A link to the original Measurements metadata file provided by the U.S. Forest Service
All-hands meeting demonstration outline (11/4/2015) – ( This document )
For questions or problems, please contact:
Shawn McClure
CIRA, Colorado State University
Email: Shawn.McClure@colostate.edu
Phone: 970-491-8455