Michigan Map Rouge River National Wet Weather Demonstration Project
The Rouge River Project
Bringing the river back to life!
Home Search About the Rouge Project Contact Us
Alliance of Rouge Communities
Community Links
Products & Data
Wildlife
Accomplishments
Combined Sewer Overflow Control
Institutional
Public Involvement
Rouge River Gateway Project
Storm Water Management
Watershed Management
Wetlands





  KEY
* No scientific background
** Some scientific and/or technical background helpful.
*** Scientific and/or technical background suggested.

Data


Representatives of developed numerous technical reports concerning the Rouge Project data analysis tools and uses. To view reports that specify other topics the rouge project addresses, click on Wetlands, Watershed Management, Geographic Information Systems/Data Management, Non-point Source Pollution, Illicit Discharges/Onsite Sewage Disposal Systems, Financial and Institutional Arrangements, Modeling and Monitoring, and Combined Sewer Overflows for general information on the program.
  1. Central Code Repository
  2. Data Access/Privileges
  3. Data Receipt and Delivery Procedures
  4. Data Screening, Validation, Reduction, and Reporting
  5. Global Positioning System Geodetic Ground Control Network
  6. Oracle Database Graphical Layout
  7. Rouge Project Office Data Needs
  8. RPO DataView CD

Central Code Repository

Taylor, Ellen

Task Product Memorandum, December 1994, 3 pages, Order Number: DAT-TPM02.00 **

The organization and documentation of program code developed for the Rouge Project is discussed. Directory structure and the code summary form used to catalog each piece of code is included.

Top


Data Access/Privileges

Reed, Les, and Ellen Taylor

Task Product Memorandum, May 1994, 8 pages, Order Number: DAT-TPM13.00 ***

This document specifies the access rules, rights and privileges for people using the Wayne County Rouge Program Office UNIX workstations. Access to the database is at the team level, rather than the individual user. Details on the team concept, accounts and rights, privileges, access rules and access tools are included.

View this document now:

Top


Data Receipt and Delivery Procedures

Bristol, Charlie and Les Reed

Task Product Memorandum, February 1995, 4 pages, Order Number: DAT-TPM22.00 **

The Rouge Project will receive, store, organize, report and make available a wide variety of data during the sampling collection projects. This document describes the levels of data availability and levels of access to the data. The document also describes the data flow through various processing steps, who handles the data and how the data distribution process works. The last section describes the procedures required for distribution and delivery of the data. A sample data transfer form has been included.

View this document now:

Top


Data Screening, Validation, Reduction, and Reporting

Thomas F. Quasebarth

Technical Memorandum, February 1996, 32 pages, Order Number: RPO-WM03A-TM05.02 *

This technical memorandum summarizes procedures required to screen, validate, reduce and report environmental measurements and laboratory analytical data collected under the Rouge Project. These procedures are designed to maximize the usability of the data and to establish standard criteria that should be consistently applied to review the environmental data collected under long-term watershed monitoring programs. The procedures pertaining to screening, validation, reduction and reporting are collectively referred to as data screening procedures, and are organized according by data type including precipitation data, streamflow data, continuous water quality data and laboratory data. The precipitation data screening objective is to identify and correct or reject unreliable or spurious data resulting from instrument problems such as power outages, obstruction of gage by debris, and clock synchronization problems. The data are collected from a network of tipping bucket rain gages at selected locations throughout the watershed. Stage/flow data screening seeks to: identify unreliable or spurious data resulting from instrument problems (i.e., power outages, displacement of probes during storm events, incorrect level setting during calibration and timing clock problems), and to ensure that rating curves are properly developed, updated, and applied to estimate stream discharge at various stage levels. These data are collected from a network of flowmeters at selected locations throughout the watershed. The continuous in-situ water quality data screening objective is to identify and correct or reject unreliable or spurious data resulting from instrument problems such as sensor damage, power outages, displacement of probes during storm events, incorrect calibration and timing clock problems. These data are collected from a network of multi-parameter water quality sondes at selected locations throughout the watershed. Lastly, laboratory data screening will identify preliminary laboratory data that were not generated in accordance with referenced procedures and methods, and to qualify those data in terms of "useable", "useable with qualifiers", or "rejected" (unusable). This is a two-stage process consisting of a data handling check and a data usability review. Careful application of these procedures will facilitate data analyses and prepare the precipitation, stage/flow, continuous in-situ water quality and laboratory data for distribution.

View this document now:

Top


Global Positioning System Geodetic Ground Control Network

Wilkerson, Kenneth

Technical Memorandum, December 1994, 5 pages, Order Number: DAT-TM18.00 ***

This technical memorandum summarizes the global positioning system (GPS) geodetic ground control network developed for use by the Rouge Project. Field work and post-processing details are included. Also included are various data sheets, visibility diagrams, observation schedules, satellite availability diagrams and plots, and NGS control lists. North American Datum 1983 (NAD 83) and North American Datum 1988 (NAVD 88) compatible coordinate lists of the final geodetic ground control network are also included. Appendices contain 190 pages.

Top


Oracle Database Graphical Layout

Capton, Victor, and Les Reed

Task Product Memorandum, May 1994, 11 pages, Order Number: DAT-TPM15.00 ***

A graphical layout is presented documenting the relationships and dependencies of the Oracle database at the Wayne County Rouge Program Office (RPO). The database will be used to store and access all the data from the Rouge River sampling collection effort including sediment, analytical dry/wet, historical flow, time series flow, time series rain, and time series water quality data.

View this document now:

Top


Rouge Project Office Data Needs

Ellen Taylor

Task Product Memorandum, October 1995, 24 pages, Order Number: DAT-TPM17.00 **

This Document is a summary of the data needs, as identified by the technical teams of the Rouge Program Office (RPO). The purpose is to define the data specifically in terms of type, users, purpose and requirements for data management. A number of attachments detail information meetings with each team. Also included is the rational behind the selection of the database management software, and the initial strategies that lead to more formal database design.

View this document now:

Top


RPO DataView CD

Data, Order Number: DATA-DV ***

The RPO Data CD contains RPO monitoring data for the sampling years 1994-2003 including: continuous water quality (conductivity, dissolved oxygen, pH and temperature), flow, rainfall, habitat, sediment, wetland vegetation and a variety of other data types. Continuous water quality (CWQ), rain and flow are monitored at 15 minute intervals. For data reduction purposes, however, the CD contains only hourly readings for flow and CWQ data and hourly sums for rainfall data.

RPO sampling data undergoes a rigorous QA/QC review process that is documented in the technical memorandum: "Data Screening, Validation, Reduction, and Reporting" also available on the CD.

Data contained on the CD are designed to be used with RPO DataView, an easy to use Microsoft Windows application developed for end users to access, browse, query and display the RPO sampling data. DataView is included on the CD along with installation instructions, system requirements and a User's Guide. The User's Guide can be downloaded below.

A copy of the RPO Data CD can be obtained from Wayne County by submitting a Rouge Project Order form. When ordering please be sure to include the title "RPO Data CD" and the order number "DATA-DV". The Rouge Project order form can be submitted by fax or email.

View this document now:

Top


Get Adobe Acrobat Reader to read PDF files


Last Updated: 5/18/02

Please address all comments and suggestions about the contents of this Web page to rougeweb@co.wayne.mi.us.

The Rouge River National Wet Weather Demonstration Project is funded, in part, by the United States Environmental Protection Agency (EPA) Grants #XP995743-01, -02, -03, -04, -05, -06, -08 and C-264000-01.