Water Quality Database Development

Water Quality Database Development 07 Water Quality Database Development 05 Water Quality Database Development 08 Water Quality Database Development 01 Water Quality Database Development 06 Water Quality Database Development 03 Water Quality Database Development 02 Water Quality Database Development 04
Overview

Water & Air was tasked with examining more than 40 years of surface-water related data from 13 river basins in the Suwannee River Water Management District (SRWMD). The data were evaluated for quality control purposes and trend identification for a 7,640 square mile area within the SRWMD. To accomplish this, an in-house database was created and populated with data provided by the District. Using customized reports, graphs, and maps, the database provides tools for trend and statistical analyses. The data, generated by ongoing monthly sample efforts, are added and compared against historical data. To ensure that only quality data are archived for future use, outlying data, or lack thereof, are presented to the reviewer automatically upon monthly import of the new data. The water quality data, existing in a live state, are housed at Water & Air and are accessible to the SRWMD resource managers via the web.

Task Summary

  • Reviewed historical and newly acquired water quality data for spurious points.
  • Reviewed historical and current data for geographic trends.
  • Created and maintained a database to increase efficient and effective quality control review and identification of temporal and geographic trends.

Results

Since the demonstration to the SRWMD of Water & Air’s original data refinement tools, the project has been expanded to include groundwater data in addition to the surface water data. The database continues to evolve as the District and Water & Air’s project managers envision new ways to express the data and derive tangible conclusions about the last four decades of Florida’s valuable water resources.

Contact Us
info@waterandair.com

6821 SW Archer Road
Gainesville, FL 32608

352.372.1500
800.242.4927 (Toll Free)
352.378.1500 (Fax)

GS-10F-0358N
Schedules: 899-1 & 899-8



CAGE Code: 9U915

800.242.4927 (Toll Free) • 6821 SW Archer Road, Gainesville, FL 32608 • info@waterandair.com