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	olneyfh, Olney Creek Olney Creek Olney Creek Subbasin Skykomish River Basin WRIA 7 - Snohomish	2006, Ambient Project9/13/2006 Ambient Snohomish County	32	8	4	9	19	6	1	58.0%	6.6%	15.4%	595	36	5	3	3	3	5	5	1	5	1	5	Details
2	olneysb, Olney Creek Olney Creek Olney Creek Subbasin Skykomish River Basin WRIA 7 - Snohomish	2006, Ambient Project9/12/2006 Ambient Snohomish County	26	8	4	6	15	4	2	41.3%	5.9%	22.5%	555	28	3	3	3	3	3	3	1	5	1	3	Details
3	BARCLAY, Barclay Cr...Barclay Creek Skykomish River Subbasin Skykomish River Basin WRIA 7 - Snohomish	2006, Ambient Project8/1/2006 Ambient Snohomish County	40	11	6	10	21	2	5	47.4%	12.0%	18.2%	574	42	5	5	3	5	5	1	5	5	3	5	Details
4	elwell, Elwell Creek Elwell Creek Skykomish River Subbasin Skykomish River Basin WRIA 7 - Snohomish	2006, Ambient Project9/20/2006 Ambient Snohomish County	34	8	4	5	15	4	0	38.9%	11.7%	23.5%	350	32	5	3	3	3	3	3	1	5	3	3	Details
5	E2640, Foss River trib...Foss River tributary Skykomish River Subbasin Skykomish River Basin WRIA 7 - Snohomish	2008, ESA Water Qual...9/8/2008 ESA Water Quality / Macroinvertebrate King County - Roads	28	6	4	7	11	3	3	49.5%	11.8%	7.6%	93	34	3	3	3	3	3	3	3	5	3	5	Details
6	E2646, Foss River trib...Foss River tributary Skykomish River Subbasin Skykomish River Basin WRIA 7 - Snohomish	2009, ESA Water Qual...8/24/2009 ESA Water Quality / Macroinvertebrate King County - Roads	41	7	4	9	17	4	7	74.7%	6.9%	3.7%	525	34	5	3	3	3	3	3	5	3	1	5	Details
7	foye, Foye Creek Foye Creek Skykomish River Subbasin Skykomish River Basin WRIA 7 - Snohomish	2006, Ambient Project8/8/2006 Ambient Snohomish County	31	5	8	6	14	5	1	50.3%	19.1%	19.8%	559	36	5	3	5	3	3	5	1	5	3	3	Details
8	hogarty, Hogarty Creek Hogarty Creek Skykomish River Subbasin Skykomish River Basin WRIA 7 - Snohomish	2006, Ambient Project9/7/2006 Ambient Snohomish County	39	9	6	9	21	5	9	65.3%	9.2%	32.6%	513	38	5	5	3	3	5	5	5	3	1	3	Details
9	skytrmann, Skykomish ...Skykomish River tributary Skykomish River Subbasin Skykomish River Basin WRIA 7 - Snohomish	2006, Ambient Project9/20/2006 Ambient Snohomish County	37	8	8	6	22	6	1	45.1%	10.9%	11.2%	550	40	5	3	5	3	5	5	1	5	3	5	Details
10	carpup, Carpenter Cre...Carpenter Creek (Woods Creek) Woods Creek Subbasin Skykomish River Basin WRIA 7 - Snohomish	2006, Ambient Project9/7/2006 Ambient Snohomish County	27	7	4	7	17	2	1	40.7%	16.9%	11.6%	551	30	3	3	3	3	3	1	1	5	3	5	Details
11	cresup, Creswell Creek Creswell Creek Woods Creek Subbasin Skykomish River Basin WRIA 7 - Snohomish	2006, Ambient Project9/6/2006 Ambient Snohomish County	40	6	9	11	20	5	5	42.4%	16.6%	2.0%	573	46	5	3	5	5	5	5	5	5	3	5	Details
12	woodshand, Woods Cr...Woods Creek E Fork Woods Creek Subbasin Skykomish River Basin WRIA 7 - Snohomish	2006, Ambient Project9/25/2006 Ambient Snohomish County	40	7	5	11	21	7	0	38.8%	7.1%	18.1%	552	38	5	3	3	5	5	5	1	5	1	5	Details
13	WCWF, Woods Creek ...Woods Creek W Fork Woods Creek Subbasin Skykomish River Basin WRIA 7 - Snohomish	2006, Ambient Project8/31/2006 Ambient Snohomish County	41	8	7	8	20	6	0	53.8%	6.0%	21.6%	632	34	5	3	3	3	5	5	1	5	1	3	Details
14	woodsfr, Woods Creek ...Woods Creek W Fork Woods Creek Subbasin Skykomish River Basin WRIA 7 - Snohomish	2006, Ambient Project9/13/2006 Ambient Snohomish County	44	9	5	10	23	7	1	36.6%	8.2%	10.4%	576	40	5	5	3	5	5	5	1	5	1	5	Details

14 scores generated from 710 sample taxa on Wednesday, September 08, 2010 2:15:28 AM. (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).