ABCDEFGHIJKLMNO
1
2
EcoSpark's Data Analysis Calculator
Please fill in the "Yellow-Highlighted" cells below.
3
4
5
6
Study Status: Valid
7
8
Index Calculations and Ratings
9
Site CodeWAT-WAT-01Note: If <100 BMI's are found the study is Invalid.
10
SchoolMonarch Park C.I IndexValueRatingIndex Criteria Rating
11
Teacher/OrganizerJ. Jackson% Worm (Oligochatea, Nematoda and Tubellaria)1%UnimpairedIndexImpairedPotentially ImpairedUnimpaired
12
WatershedWaterfront% Midge (Chironomidae)2%Unimpaired% Worm> 30%10% to 30%< 10%
13
SubwatershedWaterfront% Aquatic Sowbug (Isopoda)0%Unimpaired% Midge> 40%10% to 40%< 10%
14
Stream/RiverAmes Creek% Snails (Gastropoda)0%Potentially Impaired% Aquatic Sowbug> 5%1% to 5%< 1%
15
Nearest IntersectionGlen Stewart ParkNumber of Taxonomic Groups5Impaired% Snails-----< 1% or > 10%1% to 10%
16
Coordinates (Lat/Long)43.678498, -79.293312% Dominant Taxon93%Impaired# of Taxonomic Groups< 11------≥ 11
17
Monitoring DateOctober 4th, 2019% EPT (Ephemeroptera, Plecoptera, Trichoptera)0%Impaired% Dominant Taxon> 45%40% to 45%< 40
18
% Diptera (Diptera, Chironomidae, Culicidae, Simuliidae, Tabanidae, Tipulidae)6%Impaired% EPT< 5%5% to 10%> 10%
19
BMI Tally% Insects (All Diptera, Anisoptera, Coleoptera, Ephemeroptera, Hemiptera, Megaloptera, Plecoptera, Tricoptera, Zygoptera)6%Impaired% Diptera< 15% or > 50%
15% to 20%, or 45% to 50%
20% to 45%
20
TaxaCommon NameToleranceCountHilsenhoff Biotic Index (HBI)6.01Potentially Impaired% Insects< 40% or > 90%
40% to 50%, or 80% to 90%
50% to 80%
21
CoelenterateHydras80Benthic Aggregate Assessment (BAA) Overall ResultPotentially ImpairedHBI> 76 to 7< 6
22
TurbellariaFlatworms80
23
NematodaRoundworms80Physical Data Collected
24
OligochaetaAquatic Earth Worms81ParameterResultRiparian, Substrate and Canopy Cover Types
25
HirudineaLeeches80Site Length (m)Riparian VegetationSubstrateOverhead Forest Cover
26
IsopodaSow Bugs80Number of Transects1-None1-Sand/Silt <2mm1-None
27
PelecypodaClams, Mussels60Minimum Wetted Width (m)0.42-Cultivated2- Pebble 2-8mm2-1-25%
28
AmiphipodaScuds6109Maximum Stream Depth (mm)3-Meadow3- Gravel 8-64mm3-26-50%
29
DecapodaCrayfish50Maximum Hydraulic Head (mm)4-Scrubland4- Cobble 64-256mm4-50-75%
30
HydracarinaWater Mites60Riparian Vegetation Left Bank (1.5-10m)5-Forest, Mostly Coniferous5- Boulder >256mm5->75%
31
EphemeropteraMayflies50Riparian Vegetation Left Bank (10-30m)6- Forest, Mostly Deciduous
32
AnisopteraDragonflies50Riparian Vegetation Left Bank (30-100m)
33
ZygopteraDamselflies70Riparian Vegetation Right Bank (1.5-10m)
34
PlecopteraStoneflies10Riparian Vegetation Right Bank (10-30m)
35
HemipteraTrue Bugs50Riparian Vegetation Right Bank (30-100m)
36
MegalopteraFishlies, Alderflies40Dominate Substrate (1st Dominate)
37
TrichopteraCaddisflies40Dominate Substrate (2nd Dominate)
38
LepidopteraAquatic Moths50Overhead Canopy/Forest Cover
39
ColeopteraBeetles40
40
GastropodaSnails, Limpets80Chemical Data CollectedChemistry Conversion Chart
41
ChironomidaeMidges72ParameterResultsRatingUnitsConversion
42
TabanidaeHorse and Deer Flies50Temperature (°C)11.8GoodPPT to PPM
Multiply result by 1000
43
CulicidaeMosquitos50pH (Drops)N/APPM to PPTDivide result by 1000
44
CeratopogonidaeNo-See-Ums60pH (Probe)8.43Fairµꓢ/cm to mS/cmDivide result by 1000
45
TipulidaeCrane Flies31Dissolved Oxygen (Tablets|ppm)N/AmS/cm to µꓢ/cm
Multiply result by 1000
46
SimulidaeBlack Flies60Dissolved Oxygen (Probe|mg/L)N/A
47
Misc. DipteraMisc. True FliesN/A4Conductivity (Probe| µꓢ/cm)2600Poor
48
UnknownUnknownN/A0Turbidity (Cup|JTU/NTU)0Excellent
49
Total BMIs (excl. Unknown)117Turbidity (Tube|cm)N/A
50
Total BMIs117Total Dissolved Solids (ppm)1800Poor
51
Salinity (ppt)1.3Poor
52
Ammonia (ppm)N/A
53
54
Observations
55
Site ObservationsPollution Sources
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100