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.


  • No labels