The URL can be used to link to this page

Home My WebLink About47_Water Quality Index Database SummaryNew WQI Database and Data Warehouse (2021) The previous WQI database was recently upgraded and improved to not only calculate the water quality index for streams but also to serve as a data warehouse for various programs. The database is used for the following: • Stream monitoring data (past ambient data, current fixed interval data, water quality index) • Macroinvertebrate data and bioclassifications • Habitat data and scores • QAQC data • Follow-up sampling data (fecal coliform, etc.) • Wet -weather data • Past fish data • Past lake data In addition, the database has the following features: • Stream site information • Ability to sort by watershed, stream, site, etc. • Data export based on sampling program, date, site, etc. These screenshots illustrate just a few of the capabilities and features of the database. Homepage n Water Quality Index Bugs Fish Fixed Interval Follow-up Habitat ISM QAtiQC Sites Admin Bugs Fish Fixed Interval Follow-up Habitat Instream Monitoring QA1QC Sites Streams I watersheds I Subwatersheds Rotations Excel Export Fixed Interval Import Stream Sampling Data and WQI Score Fixed Interval Sample Fixed Interval Site 16th Street Sample Date 1/20/2021 10:40AM Observers From Old App: JL, CM Follow-up Co QAIQCs FO Site ID 0114133 Watershed WQI Values B0D, mg/L ¢ 2 Fecal Coliform, cfu1100 ml Alkalinity, mg/L 47.3 Flow, cfs Cadmium, mg1L ¢ 0.00006 Hardness, mgIL COD, mg/L 15.1 TKN, mg/L Conductivity, mSIC 0.14 Lead, mgIL Copper, mg/L 0.0015 Level, fit DO, mg/L 11.41 pH DO % 93.3 Nitrate Nitrogen, mg1L Public Comments No Ambient Conditions Comments WQI Scores 136 0 51.4 0.00027 0 6.2 0.52 No G r © Return Record No. 4071 Nitrite Nitrogen, mg1L 0.0072 Temperature, °C 5.46 Temp Departure, °C 0 TDS, mg1L 90 Phosphorus, Total, 0.032 mg1L TSS, mg1L c 3.3 Turbidity, ntu 4.41 Zinc, mg1L c 0.0027 Stream WQI 78_78 PH 62.00 BOD 82.09 Temperature Departure, °C 93.00 DO % 95.66 Phosphorus, Total 100.00 Fecal Coliform 40.49 TSS 80.53 Nitrate Nitrogen, mg/L 93.77 Turbidity 84.39 Macro!nvertebrate Sampling Bugs Sample = p Return Sample Details Re crd No er Site Site lD Sample Date Observers Old App Observers FLnch GRF1 6/4/2020 Reyna Ocampo, DGS Eleazer, Shoffner, Debbie WQI Scores Bic) Classification Good -Fair EPT Richness 8.00 Biotic Index 542 Total Taxa 45.00 EPTAbundance 41.00 Richness Comments Stream Site Information (List and Details) Sampling Sites Search Assessment, Collection, and Sampling Site Site ID Stream Watershed Fixed Instream Bugs Fish Habitat I Monitoring Details 15th Street 01NB3 UT North Buffalo I/ V, V, V Alamance Church Road Big Alamance Details BACl Big Alamance �/ �/ (Ref) Creek North Buffalo Details Arboretum 01NB1 North Buffalo V Creek North Buffalo Details Audubon TBD North Buffalo Creek North Buffalo Details Aycock Street 01NB2 North Buffalo I/ I/ V Creek Details Battleground Avenue GHC2 Horsepen Creek Horsepen Creek I/ I/ I/ V V Details Benjamin Parkway 02NB1 UT North Buffalo I/ V South Buffalo Details Big Tree Way BSBIBT South Buffalo I/ V Creek Details Bluff Run Road GRC1 Richland Creek Lake Jeanette I/ V Details Branson Mill Road (Ref.) RPCIBM Polecat Creek Polecat I/ V Details Bunch GRF1 Reedy Fork Creek Reedy Fork I/ I/ I/ V V North Buffalo Details Church Street BNB2 North Buffalo I/ I/ V Creek Details College Park TBD TBD North Buffalo Details Colonial Pipeline (Bull Run) GBR1 Richland Creek Lake Jeanette V Details Cone Mills TBD TBD North Buffalo Details Fieldcrest Drive BMR1 Mile Run South Buffalo V, Site Details Site Details Site Church Street Site ID BNB2 Watershed North Buffalo Subwatershed NB2 Address 1909 Golden Gate Dr. Comments Monitoring Bugs Sampling Ne Fish Collection Habitat Asssessment V, Instream Monitoring Fixed Interval Sampling V, =© Return Record No. 16 Stream North Buffalo Latitude 36a 60.08" N Creek Longitude 79° 46' 32.59" W Rotation North Buffalo USGS Site TBD Lab Site Name Church Drainage Area, mil 14.20 Horiba Site Name Church Habitat Assessment Habitat Assessment Sample [, r 0 Return Sample Details Record No 281 Site Site ID Sample Date Observers Low Bridge Road (RefJ RSC01LB 4/1812022 Lerew, Jordan; Reyna Ocampo, Eleazer, Schneider, Peter, Shaffner, Debbie Observations Channel Modifications 5 Instream Habitat 19 Substrate 12 Pool Variety 6 Riffle Habitat 16 Bank Stability & Vegetation 14 Light Penetration 7 Riparian Vegetative Zone a Final Habitat Score 87 Comments Last rain event and amount >72 Inns Salamanders - 2 Crayfish - 2 live, 1 dead Corbicula - None FW Mussels - 1 shell Sponges - Common Export Export to Excel ❑Bugs ❑Fish ❑Fixed Interval ❑Follow-up ❑OA ❑Habitat ❑ISM Start Date 05/04/2021 End Date 05/03/2022 8 r� Watersheds ❑ Big Ala mance ❑ Brush ❑ Buffalo ❑ Bull Run ❑ Horsepen Creek ❑ Lake Jeanette ❑ North Buffalo ❑ Polecat ❑ Reddick's ❑ Reedy Fork ❑ Sandy ❑ South Buffalo ❑ Other Streams ❑ BigAlamance Creek ❑ Brush Creek ❑ Buffalo Creek ❑ Bull Run ❑ Horsepen Creek ❑ Mile Run ❑ Muddy Creek ❑ North Buffalo Creek ❑ Polecat Creek ❑ Reddicks Creek ❑ Reedy Fork Creek ❑ Richland Creek ❑ Ryan Creek ❑ Sandy Creek n�,,.,.� Q...........,.,,� Sites ❑ 16th Street ❑Alamance Church ' Road (Ref) ❑ Arboretu m ❑Audubon ❑Aycock Street ❑ Battleground Avenue ❑ Benjamin Parkway ❑ Big Tree Way ❑ Bluff Run Road ❑ Branson Mill Road (Ref.) ❑ Bunch ❑ Church Street ❑ College Park ❑ Colonial Pipeline {Bull City of Greensboro Water Quality Index for Streams (WQI) The City of Greensboro Stormwater Management Division uses a standardized Water Quality Index (WQI) to characterize and present overall water quality of the City's streams. The WQI is derived from a formula that incorporates nine (9) water quality parameters, resulting in an index value, or score, ranging from 0 to 100. Water Quality Index scores are classified as follows: 0-19 Poor 20-39 Below Average 40-59 Average 60-79 Above Average 80-100 Good The figure below represents mean WQI scores for sites within North Buffalo Creek watershed, South Buffalo Creek watershed, and the water -supply watersheds. These scores were derived from ambient water quality data collected from January 2001 to December 2019. Water Quality Index Scores from Ambient Sampling 2001-2019 100 90 80 70 60 50 PROGRAM GOAL 40 30 20 10 0 NNN N M M M MM M1* V VZ31 R C Ill M Ln Ln M 111 tD lD lD W W W r� n n N n N 000000 W W W M M M 000r1 'i '-1 'i N N N M MIT R71A M M M M 111 M W W W W W IO tDID N N N r,w w ww w m m 0)m mm 09900999o99999o90999o00999o00999o99999o99999o000000�. H,iH�HHHHHHH. tiNNNtiNH��HH ��HHHHH. HNN.�NNtiti.�titi CEj f6 @ D>—mg T O.>TQi�Op O. +u 7O6- - -g-wOmmwR 7w _wow �. > —gg6 �O4g2 -Z,gg -Z-22 -Z-22 -Z-22 �Z,gg �Z-2 Zo- Zga�Zou Water Supply Watershed =North Buffalo South Buffalo