Biotic Integrity Scores

Area

Project

Site Code, City or County

Aggregation

Taxa Resolution

Metric

Replicate Handling

Taxa Attributes

Year Latest per SiteAll

From To

Number of Organisms per Sample

Min: Max: FlagOmit

Row	Site Code, Location	Year, Project	Quantities											Scores											View Samples
Row	Site Code, Location	Year, Project																							View Samples
1	PaddenBgham1, Padd...Padden Creek Bellingham Bay Subbasin Whatcom-Chuckanut Basin WRIA 1 - Nooksack	2003, City of Bellingha...9/16/2003 City of Bellingham Macroinvertebrate Monitoring Program City of Bellingham	22.8	1.8	1.8	1.8	6.0	3.0	0.0	82.2%	0.3%	36.7%	2383.3	16.0	3.0	1.0	1.0	1.0	1.0	2.0	1.0	1.5	1.0	3.5	Details
2	PaddenBgham2, Padd...Padden Creek Bellingham Bay Subbasin Whatcom-Chuckanut Basin WRIA 1 - Nooksack	2003, City of Bellingha...9/16/2003 City of Bellingham Macroinvertebrate Monitoring Program City of Bellingham	23.5	2.0	0.8	3.3	7.5	3.3	0.3	77.9%	1.6%	40.3%	682.8	18.0	3.5	1.0	1.0	1.0	1.5	2.5	1.0	2.5	1.0	3.0	Details
3	PaddenBgham3, Padd...Padden Creek Bellingham Bay Subbasin Whatcom-Chuckanut Basin WRIA 1 - Nooksack	2003, City of Bellingha...9/17/2003 City of Bellingham Macroinvertebrate Monitoring Program City of Bellingham	17.0	2.5	0.0	1.8	3.3	0.5	0.5	71.5%	1.9%	21.2%	647.3	15.5	2.5	1.0	1.0	1.0	1.0	1.0	1.0	2.5	1.0	3.5	Details
4	PaddenBgham4, Padd...Padden Creek Bellingham Bay Subbasin Whatcom-Chuckanut Basin WRIA 1 - Nooksack	2003, City of Bellingha...9/17/2003 City of Bellingham Macroinvertebrate Monitoring Program City of Bellingham	15.8	0.5	2.0	1.0	3.8	2.0	0.0	80.7%	4.9%	6.4%	390.8	18.0	2.5	1.0	1.0	1.0	1.0	2.0	1.0	2.5	1.5	4.5	Details
5	PaddenBgham5, Padd...Padden Creek Bellingham Bay Subbasin Whatcom-Chuckanut Basin WRIA 1 - Nooksack	2003, City of Bellingha...9/17/2003 City of Bellingham Macroinvertebrate Monitoring Program City of Bellingham	20.3	2.5	2.8	1.0	4.3	1.8	1.3	70.8%	20.2%	1.4%	386.5	21.5	2.5	1.0	1.5	1.0	1.0	1.5	1.5	3.0	3.5	5.0	Details
6	PaddenBgham6, Padd...Padden Creek Bellingham Bay Subbasin Whatcom-Chuckanut Basin WRIA 1 - Nooksack	2001, City of Bellingha...9/23/2001 City of Bellingham Macroinvertebrate Monitoring Program City of Bellingham	34.3	3.3	4.8	8.5	11.8	2.5	0.8	70.5%	17.6%	0.4%	1085.5	32.0	5.0	1.5	3.0	3.5	3.0	2.5	1.5	3.0	4.0	5.0	Details
7	WhatBghamCem, Wh...Whatcom Creek Bellingham Bay Subbasin Whatcom-Chuckanut Basin WRIA 1 - Nooksack	2003, City of Bellingha...9/16/2003 City of Bellingham Macroinvertebrate Monitoring Program City of Bellingham	21.0	2.8	2.5	1.3	3.3	0.8	0.0	79.3%	2.8%	8.7%	2550.8	17.0	2.5	1.0	1.5	1.0	1.0	1.0	1.0	2.0	1.0	5.0	Details
8	WhatBghamJames, W...Whatcom Creek Bellingham Bay Subbasin Whatcom-Chuckanut Basin WRIA 1 - Nooksack	2007, City of Bellingha...9/25/2007 City of Bellingham Macroinvertebrate Monitoring Program City of Bellingham	20.8	2.8	1.0	2.3	6.3	1.0	0.0	68.6%	1.5%	43.3%	348.5	16.0	3.0	1.5	1.0	1.0	1.0	1.0	1.0	3.0	1.0	2.5	Details
9	WhatBghamMidFalls, ...Whatcom Creek Bellingham Bay Subbasin Whatcom-Chuckanut Basin WRIA 1 - Nooksack	2007, City of Bellingha...9/26/2007 City of Bellingham Macroinvertebrate Monitoring Program City of Bellingham	19.0	4.0	2.3	1.8	6.3	1.0	0.0	67.9%	2.5%	45.0%	339.8	16.5	3.0	1.0	1.5	1.0	1.0	1.0	1.0	3.5	1.0	2.5	Details
10	WhatBghamRacine, W...Whatcom Creek Bellingham Bay Subbasin Whatcom-Chuckanut Basin WRIA 1 - Nooksack	2007, City of Bellingha...9/25/2007 City of Bellingham Macroinvertebrate Monitoring Program City of Bellingham	19.0	4.3	1.3	1.5	4.3	1.3	0.0	64.0%	4.0%	65.6%	327.8	16.5	3.0	2.0	1.0	1.0	1.0	1.5	1.0	4.0	1.0	1.0	Details

10 scores generated from 853 sample taxa on Friday, September 10, 2010 6:07:21 PM. (0.17 seconds)

Legend	Excellent	Excellent/Good	–	Good	Good/Fair	–	Fair	Fair/Poor	–	Poor	Poor/Very Poor	–	Very Poor

Score Table

Scores By Year
Get a site visit score table pivotted by year. Only available when not aggregating.
Raw Sample Data
Include deficient samples Standard Sample Format Standard Sample Format Fields 1) WRIA 2) Basin 3) Subbasin 4) Stream or River 5) Agency 6) Project 7) Site Code 8) Visit Date 9) Latitude 10) Longitude 11) Sample ID 12) QC Replicate Of Sample ID 13) Collection Count 14) Positions In Stream 15) Surface Area 16) Surface Area Units 17) Deficiency Notes 18) QA/QC Result 19) Sampling Grid Squares Counted 20) Total Sampling Grid Squares 21) Taxon Serial Number 22) Taxon 23) Quantity 24) Life Stage 25) Unique 26) Damaged Samples with Taxa Attributes Samples with Taxa Attributes Fields 1) WRIA 2) Basin 3) Subbasin 4) Stream or River 5) Agency 6) Project 7) Site Code 8) Visit Date 9) Latitude 10) Longitude 11) Sample ID 12) QC Replicate Of Sample ID 13) Collection Count 14) Positions In Stream 15) Surface Area 16) Surface Area Units 17) Deficiency Notes 18) QA/QC Result 19) Sampling Grid Squares Counted 20) Total Sampling Grid Squares 21) Taxon Serial Number 22) Taxon 23) Quantity 24) Life Stage 25) Unique 26) Damaged 27) Predator 28) Long Lived 29) Tolerant 30) Intolerant 31) Clinger Wash. DOE's EIM Format (In Development) Wash. DOE's EIM Format (In Development) Fields 1) User Study ID 2) User Location ID 3) Study Location Name 4) Field Activity Type 5) Field Activity Data Originator 6) Field Activity Start Date 7) Field Activity Start Time 8) Result Additional Comment 9) Result Taxon Name 10) Result Taxon TSN 11) Result Taxon Life Stage Code
Technical Notes
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 site visit scores (not aggregates), that score table can be joined to the sample table on the natural key composed of Agency, Site Code, and Visit Date. (Site Code is guaranteed to be unique within an agency).