-->

Harvard Forest > W&W Database

Wildlands & Woodlands Database

Instructions

The options described below may be used to download and graph data from the Wildlands & Woodlands Stewardship Science Program and to view current tables of participants, field sites, site surveys, and tree species.

If you would like to be included as a new participant, correct or update existing information, or add a new tree species, please send an email message to Emery Boose. For corrections to existing data, please include the ID number of the record to be corrected.

Download Data

Use Download Data to view and download data. Click on a particular subject to see data for that subject. Results may be filtered by selecting a particular participant or site or by searching for particular string. See the links after "Order By" for sorting options.

To save results to your computer as a CSV (comma-separated value) file, click on "Download file." Depending on your computer and browser, you may need to use the left or right mouse button. The default name of the file to be downloaded is "temp.csv." Missing values will be represented as "NA." Once the file has been downloaded to your computer, you can rename it and/or open it in a spreadsheet program such as Excel.

Click on "Carbon biomass" to download a file that contains estimated carbon biomass for each tree. Click on "By site" to download a file containing estimated stand density, basal area, and carbon biomass per hectare for the site. To see a summary table of the data you have selected, click on "Summary of selected data."

Graph Data

Use Graph Data to select data and create a graph. The graph will be displayed in a separate tab or window of your browser. To save the graph to your computer, select "File / Save page as" (or a similar command) in your browser. The name of the file to be downloaded will be "graph-xxxxxx.jpeg" where xxxxxx is a random 6-digit number. Once the file has been downloaded to your computer, you can rename it, display it (by clicking on it), and/or load it into a program such as Power Point.

1. Detailed data from a single site

Bar plots

Create a graph of stand density, basal area, or carbon biomass as a function of tree species or a graph of stand density or carbon biomass as a function of diameter class. Select a participant, site, survey, and variable for the Y-axis. Please note that these graphs show per area values and the numbers will not be correct until all of the data for the plot and survey have been entered into the database.

2. Summary data from one or more sites

Time series plots

Create a graph of summary values for one or more sites as a function of year. Select a participant (or all participants), one or more sites, and a variable for the Y-axis.

Box plots

Create a box and whisker plot of summary values for one or more sites and a given year. Select a participant (or all participants), one or more sites, and a variable for the Y-axis.

Field Sites

Use Field Sites to view a table of field sites. Each field site is uniquely identified by a code of the form "Highstead-001" where "Highstead" is the code for "Highstead Foundation" and "001" is a number between 1 and 999. This table contains (for each field site) the year when observations began, the year (if any) when observations ceased, the spatial coordinates of the site (latitude, longitude, elevation), the town, county, and state where the site is located, the treatment type, and the minimum dbh (diameter at breast height) measured.

Please note that a field site must be submitted and uploaded before data or site surveys can be entered.

Site Surveys

Use Site Surveys to view a table of site surveys for individual field sites. Site surveys may be submitted at any time and contain information on the physical and natural features of the site as well as signs of natural and human disturbance.

Participants

Use Participants to view a table of participants, associated codes, and other related information.

Tree Species

Use Tree Species to view a table of tree species, associated 6-letter codes, and scientific and common names.

Submit Data

Use Submit Data to submit new data. To do this you or your organization must be listed as a participant (if you or your organization are not currently listed, please send an email message to Emery Boose). To log in, click on Login to view this page. If you are a new user, enter your email address in the "New User" section and press Submit. Your password will be sent to your email address (return address = hfweb@fas.harvard.edu). If you are a returning user, enter your email address and password in the "Returning User" section and press Submit.

Submit Data may be used to enter new observations, new field sites, or new site surveys. Select the date type, subject, participant, and site. Use "Add" to enter new data and "Edit" to edit data already submitted but not uploaded. Use "Review Submissions" to review data entered so far. Records may be deleted if necessary by changing the value of "Delete This Record" from "no" to "yes". If a data value is missing, please leave the text box empty or select 'Missing Value' from the pull-down list.

NOTE: You must select "Add a New Observation" for each new observation. You must also press Submit to save a new observation or to edit an existing observation. If required values are missing, you'll be prompted to go back and complete them. If optional values are missing, your changes will be saved but you'll be provided with a list of missing values.

Data may be entered at any time. Data are initially stored in a temporary table where you can continue to add new data and edit existing data as time allows. When you have finished entering and checking your data, please send an email message to Emery Boose. Once your data have been uploaded to the main database, they will no longer appear in the Submit Data section but will be available for downloading and graphing using Download Data and Graph Data. If you discover errors after your data have been uploaded, please let us know the ID number of the record to be corrected (along with the correct values) and we will make the correction for you.

PLEASE CHECK YOUR DATA CAREFULLY. Accurate data entry is as important to a scientific study as data collection. To avoid repeated or skipped items, we recommend checking the number of records entered against your field sheets.