Hudson River Lower Food Web Survey

This database contains data on water chemistry, physical characteristics, plankton, and zoobenthos of the Hudson River Estuary. The spatial extent is the entire tidal Hudson River from Manhattan to Troy, New York, USA, and the temporal extent is February 2025 through March 2026. These data were collected as part of the Lower Food Web Survey conducted by the Cary Institute of Ecosystem Studies. The data are provided under the Creative Commons CC-BY-NC-SA 4.0 license; they may be used in any medium or format for noncommercial purposes, provided that attribution is given to the creator. The data have undergone QAQC but errors may remain.This is a relational database, available for download as an SQLite file. Here is an example workflow for bringing data from the database into an R session:1) Load the DBI and RSQLite packages into your R session:<i>library(DBI)</i><i>library(RSQLite)</i>2) Connect to the database:<i>db &lt;- dbConnect(SQLite(),'filepath')</i>where ‘filepath’ is replaced by the full filepath of the location where the database is saved, including the name of the file itself.3) You can then read tables in using the dbReadTable function, e.g.:<i>chem &lt;- dbReadTable(db,"CHEM")</i>Or you can query tables using the dbGetQuery function and SQL syntax, e.g.:<i>chemSub &lt;- dbGetQuery(db,'SELECT chemID, SRP FROM CHEM WHERE chemID&lt;6')</i>4) When you’re done reading data from the database into your session, you can disconnect from the database using:<i>dbDisconnect(db)</i>The database may also be accessed with other statistical software; with DB Browser for SQLite; and probably in other ways.Because this is a relational database, most uses of the data will require table join operations. A database schema, included with the files posted here, may be useful in understanding the structure of different tables in the database and the primary and foreign key fields that link those tables. Other useful sources of information include the table definitions file, which defines each column in each table; and the field and lab protocol files that describe methods in detail.Note that the Lower Food Web Survey builds on decades of previous work by researchers at the Cary Institute. There is substantial overlap between the Lower Food Web Survey and the previous work in terms of the variables measured and the methods used. Data from the previous work can be found here, and in particular in this repository.