Data Science for Agriculture
How to manage and manipulate data for agricultural research
The Plots table in the Portal database can be joined to the Surveys table
by joining plot_id to plot_id and the Species table can be joined to
the Surveys table by joining species_id to species_id.
The Portal mammal data include data from a number of different
experimental manipulations. You want to do a time-series analysis of the
natural population dynamics of all of the rodent species at the site, so
write a query that returns the year, month, day, genus and species
of every individual captured on the Control plots. Choose only
rodent species (i.e., species for which the taxa field in the
species table is Rodent) and exclude all individuals that have not been
identified to genus (i.e., species for which the species_id field in the
species table is UR). For easier viewing, sort the results alphabetically by
genus and species and then chronologically.
Save this query as data_from_controls.