|
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
|