The RiverWatch Database files can be found on Box.
To extract a table containing the location, time, and observations for each entry, run the following SQL statement on the RiverWatch Database:
SELECT ActivityT.SiteID, ActivityT.FieldDate, ActivityT.MBI, ActivityT.TotalOrganismsSampled, ActivityT.TaxaRichness, ActivityT.EPTTaxaRichness, SiteT.SiteName, SiteT.Latitude, SiteT.Longitude FROM ActivityT INNER JOIN SiteT ON ActivityT.SiteID=SiteT.SiteID;
ActivityT contains each citizen scientist observation with the observation date, calculated MBI and associated data. SiteT contains all observation site locations (latitude and longitude) and a site name. Joining these two tables by the common SiteID field yields a table with all the requisites for data ingestion.