To find your way among the different data here a few key things to know:

1. Data is grouped based on the different variables and represented by a four letter code
a. METB = data related to the measurement of metabolism (e.g., light intensity, dissolved oxygen)
b. NUTU = data related to the uptake of ammonium (e.g., nutrient concentrations)
c. CONS = data related to consumers (e.g., consumer survey data, abundance and size data)
d. CNP = data related to stoichiometry (e.g., nutrient ratios of biofilm, organic matter)
e. BOMS = data related to benthic organic matter
f. PBIO = data related to primary producer biomass
g. CHEM = data related to water chemistry
h. SITE = data related to site information (e.g., GPS, reach length, canopy cover, sediment size)
i. Species/InvertsSpecies = data related to species (e.g., abbreviations, length-weight regression coefficients)
j. Calibrate = Data related to sensor calibration (e.g., check for sensors functionality after shipping)

2. Within each group data is devided based on variabe and scale
a. Variables: The first number after the group letter designation represents different variables (e.g., METB1 = dissolved oxygen, METB2 = light intensity)
b. Scales: The second number represents scale with 1 representing patch scale data, 2 is reach scale data (experimental), and 3 network scale data (synoptic). Methods are often scale dependent.

Please have a close look at the Table Names in the link provided on the previous webpage (Datebase Table Structures).

To get data you want, follow the steps detailed below

Example 1. Select Data From Single Table

Steps

In "Select A Table" dropdown list, Select Light table, the table colums will be populated to the listbox below.

Select Biome, SiteType, SiteNumber, ReachType, Light(lux) in the column list.

Click the right arrow, the selected columns will be copied to the right listbox. You can use buttons on the right to move up, move down or remove.

Select SiteType in the column list, click up arrow, it will be copied to the up text box, enter E in the vlaue text box, click "Add Filter" button.

Now we are ready, click the button "Add selected table and columns" to generate the sql command, the selected table and columns will be cleared

There will be a popup message, which is for Example 2. just click OK. Scroll down to the bottom, you will see query and filter textArea will be filled.

Click "Generate CSV File" button. The csv file will be generated and downloaded.

Example 2. Combine 2 tables

Display Biome, SiteType, SiteNumber, ReachType, Light(lux) values from Light table

Add Barometer(kpa), DissolvedOxygen(mg/L), Tempture(C) values from DO table

On same Biome, SiteType, SiteNumber, Patch Number, ReachType, Patch Treatment and Timestamp

Only interested in site type E for Light and site number 1 for DO

Steps

Follow all the steps detailed in example one, however, before we actaully generate the CSV file we will add the columns from a different table. Note, this can be done multiple times if necessary.

After clickes OK button on the information dialog,

Select DO table in "Select A Table" dropdown list

Select Barometer(kpa), DissolvedOxygen(mg/L), Tempture(C). Note: If the field was already selected in last Step, do not need select it again.

Click the right arrow, the selected columns will be copied to the right

Select SiteNumber, click up arrow, it will be copied to the up text box, enter 1 in the vlaue text box, click "Add Filter" button. Note: For the filters, we have to redo them for the second table as well. Otherwise it will apply to all the records.

Select primary keys Biome, SiteType, SiteNumber, PatchNumber, PatchTreatment, TimeStamp, Note: for timestamp, they must exactly match, we cannot build in a "buffer" saying that the timestamp should match within a minute. If you want do it, you have to manually modify the query. There are consequences, because in one minute, there may have several records.

Click down arrow, the primary keys will be copied to Join Columns box

Click button "Add selected table and columns" to generate the new sql command

You can take a look the query and filter. If you know SQL, you can make adjustments.

Click Generate CSV File button, then you can download the file