Water Resources Database (WRDB) The Water Resources Database (WRDB) is a comprehensive data storage system capable of handling a vast amount of data, accommodating a wide variety of data types and diverse in- formation, and presenting data conveniently and efficiently. WRDB was originally developed by the Georgia Environmen- tal Protection Division (EPD) in association with EPA Region 4 to address the imposing data management challenges pre- sented by the Chattahoochee River Modeling Project. Since its inception, WRDB has been enhanced a number of times and applied to numerous projects in Region 4. A main goal of the system has been to provide data management and analysis tools to users possessing an assortment of professional specialties and a variety of software skill levels. Key WRDB Features The following features help make WRDB an outstanding tool for water quality data analysis and modeling: Database structures allow a thorough description of col- lected environmental data. Databases that use the industry-standard Paradox file format providing very fast access to large databases on IBM-compatible personal computers; large tables may also be stored on SQL database servers such as Oracle, MS SQL Server, and MySQL, and WRDB's administrative functions used to control access. The user interface was developed using the Paradox Ap- plication Language (PAL), taking full advantage of the Microsoft Windows graphical user interface. Databases can be imported and exported to a wide va- riety of alternative spreadsheet, database, and text file formats. All associated databases can be created, edited, and printed using spreadsheet-type on-screen data forms. Data entry and validation are done in batches, maintain- ing strict quality control. Data can be entered manually, using user-defined data entry forms, or electronically, using an intelligent data conversion program developed specifically for this soft- ware. Subsets of data can be extracted with an easy-to-use filter- ing form, or advanced queries can be used to capitalize on the strength of the underlying Paradox engine. Report-quality tables, graphs, and pictures can be gener- ated on-screen for instantaneous review and analysis or printed on any standard device or to a disk file. Data analysis includes a variety of regression, frequency analysis, and curve fitting tools. A GIS tool is included which can display AutoCAD and Arc View data with thematic mapping of water resources data. Data security is enhanced by password-protection of selected program functions. An on-line help system provides context-sensitive infor- mation to the user, supplementing the User's Manual. United States Environmental Protection Agency ------- Water resources data are stored in one or more tables that are linked to Project Support tables that include information for Stations, Station Groups, Branches, Parameter Codes (PCodes), PCode Groups, Compositing Codes (CCodes), Quality Codes (QCodes), and Data Batch Tracking. Program-specific Features In addition to WRDB's water resources data storage and analy- sis capabilities, an additional module is available to perform 305 (b) reporting and TMDL tracking. This module has the following features: Forms for editing twelve relational tables that comprise the 305(b) database Analysis of observed data to determine compliance with water quality criteria Data selection using SQL queries on any of the linked tables Ability to print detail and summary reports GIS tool to display and query reach information interac- tively. Visit the Watershed & Water Quality Modeling Technical Support Center Website http://www.epa.gov/athens/wwqtsc/index.html H;Ğl< I > ,ğ H Fnd.. I FindNral United States Environmental Protection Agency ------- |