RMT Data Requirements

The file system used in RMT is based on a database structure. A facility for creating a database from a series of files is included with the Program, thus eliminating the need for a separate database program.

RMT Structure of Data Files

The below describes the structure of the two input files required to run RMT, namely the INPUT DATA FILE and the STATION DATA FILE. These files are comma-delimited files (.csv) and should be created using a spreadsheet program such as Microsoft's Excel.

When constructing the input data file, you can either number the rivers individually or separate the river into reaches. Each Parameter must have a value and must be separated by a comma. You can choose to plot data for any number of the available parameters, but any empty columns should be filled with zeros.

INPUT DATA FILE: This file is a comma-delimited (.csv) file which can easily be created using a spreadsheet program. The structure of this file can be defined by the following column headers which should not be included in the final .csv file.

  • RIVER OR REACH NUMBER
  • X-COORDINATE
  • Y-COORDINATE
  • FLOW
  • SUSPENDED SOLIDS
  • BIOCHEMICAL OXYGEN DEMAND
  • PERMANGANATE VALUE
  • DISSOLVED OXYGEN
  • TEMPERATURE
  • PERCENTAGE SATURATION
  • AMMONIA
  • TOTAL OXIDIZED NITROGEN (TON)
  • PHOSPHATE
  • pH
  • ALKALINITY
  • CHLORIDE
  • TOTAL HARDNESS (TH)
  • NITRITE
  • NITRATE
  • CONDUCTIVITY
  • BIOLOGICAL INDICES

Example Input Data File

1,979,909,3.98,0,0.3,0,1.7,0,0,0.03,0,0,0,0,0,0,0,10.85,0,0,0

1,977,908,3.98,0,0.4,0,1.6,0,0,0.05,0,0,0,0,0,0,0,10.25,0,0,0

.......................

15,595,356,61.59,0,2.1,0,4.2,0,0,1.2948,0,0,0,0,0,0,0,9.3643,0,0,0

STATION DATA FILE: This file is also a comma-delimited (.csv) file which can easily be created using a spreadsheet program. This file is used to plot the location of monitoring stations, gauging stations and discharges on the map. The structure of this file can be defined by the following column headers which should not be included in the final .csv file.

  • RIVER OR REACH NUMBER
  • SITE IDENTIFICATION (i.e., monitoring, gauging or effluent)
  • SITE NUMBER
  • SITE NAME
  • X-COORDINATE
  • Y-COORDINATE

Example Station Data File

1,Monitoring,head,SOURCE,980,908

1,Monitoring,ms1,DOWNSTREAM,957,816

.......................

15,Effluent,S.3.3.,RIVER END,613,376
 

DETAILED DESCRIPTION OF RMT

rmt_2

RMT Data Requirements
RMT Structure of Data Files
Detailed Description of RMT
RMT Hardware & Software Requirements
 

Introduction to RMT

RMT, water characterization software, provides a topographical interpretation of flow and water quality data by utilizing the X and Y coordinates of a given catchment area. The unique interface allows the user full control of the visual appearance of their water-quality data, producing images suitable for reports and presentations. The RMT Program was developed as an add-on to many of the water-quality models currently in use today but can also be used independently with raw water-quality data.

The map created using RMT provides a visual representation of a given catchment area, with the width of the river representing flow and the color of the lines representing the concentration of the chosen pollutant.

The database utility used to create files for RMT can handle data on up to sixteen parameters as well as water-quality indices and biological indices. Please note, however, that data is not required for all of the parameter fields. In this event, empty fields should simply be filled with zeros. The database utility requires two data files, the structures of which are described below.

RMT also incorporates a useful zoom utility which allows you to zoom in on any area of the map. By right-clicking the mouse button, the map will zoom out to its full size. You can also specify a single river or reach to be plotted.

In order to increase the sensitivity of the map to changes in water-quality data, RMT incorporates a utility to edit the value associated with each color or to change the designated colors used for each parameter.

Once you have created a map, you may want to enhance the appearance of the output file. For this purpose, RMT includes tools for adding titles including a grid for altering the appearance of the background. This last enhancement is especially useful as it allows you to create a bitmap file which could consist of labels or even a scanned image of a map of the surrounding area.

RMT also contains a facility for plotting the location of monitoring stations, flow stations and discharge points on the map. The data for this facility is contained in the STATION DATA FILE, the structure of which is described below. For each of the records entered in this file, RMT plots a symbol representing the feature on the map. By right-clicking on any one of these symbols, a description of the feature will be given.

Once you have obtained the desired look for your map, you can choose to print the file. This opens up a Report (.rmt) file in a separate window which can either be sent to an attached printer or exported in several file formats.

rmt_1

RMT - water-quality data mapping - river management tool

RMT Categories: graphics programs, water quality
 

RMT Description

Scientific Software Group    P.O. Box 708188   Sandy, Utah 84070
Phone (801) 208-3011   Toll Free (U.S.) 1-866-620-9214    Fax (801) 302-1160    E-mail
info@scisoftware.com
Copyright 1998   Scientific Software Group    All rights reserved