Analysis: Benthic Index of Biotic Integrity

Each of the above downloads is in a comma delimited, tabular fomat. The first row contains the column headers, and the rest of the rows are the data. The files can be easily imported (or pasted) into MS Excel, MS Access and other database software.

If the scores downloaded are visit scores (not aggregates), that score table can be joined to the sample table on the surrogate key VisitID (as opposed to the natural key composed of Agency, Site Code, and Visit Date). Sites can be identified with the surrogate key SiteID (as opposed to the natural key composed of Agency, and Site Code).