Overview website: http://ilrdss.isws.illinois.edu/fox/
The data is at Box share, gltg-source-data/Fox River Watershed Database
Information about the database including schema: http://ilrdss.sws.uiuc.edu/fox/fox_report_phase1.asp?ws=3
Presentation at Nutrient Monitoring Council that explains what kinds of query Jong Lee did to extract the data from the database.
SQL statement from MS ACCESS:
SELECT TBLSample.Station_ID, TBLSample.Sample_Code, TBLSample.IDLoc, TBLResults.IDLoc, TBLParameter_Codes.Full_Name, TBLParameter_Codes.Short_Name, TBLSample.Start_Date, TBLResults.Result_Value, TBLParameter_Group.Parameter_Group INTO temp FROM TBLParameter_Group INNER JOIN (TBLQAPP_Group_Codes INNER JOIN (TBLQAPPGroups INNER JOIN (TBLParameter_Codes INNER JOIN (TBLSample INNER JOIN TBLResults ON TBLSample.Sample_Code = TBLResults.Sample_Code) ON TBLParameter_Codes.Parameter_Code = TBLResults.Parameter_Code) ON TBLQAPPGroups.Parameter_Code = TBLParameter_Codes.Parameter_Code) ON TBLQAPP_Group_Codes.QAPPCode = TBLQAPPGroups.QAPPCode) ON TBLParameter_Group.Parameter_Group = TBLQAPP_Group_Codes.Parameter_Group WHERE (((TBLParameter_Group.Parameter_Group)=9 Or (TBLParameter_Group.Parameter_Group)=10));