Mch Bridge

Data Menu

File	Rows	Status

Upload Preview

Stations Preview

Station Database Details

Table Name: stations

Statistics

Summary	Value

Table Column Description

Column Name	Description
*Station	Unique Identifier of Station
*StationName	Name of the station
*StationName2	Code of Station
*Longitude	Longitude of the station
*Latitude	Latitude of the station
*Altitude	Altitude of the station
*Longitude2	Longitude in decimal format
*Latitude2	Latitude in decimal format
*DMSLongitude	Longitude in DMS format
*DMSLatitude	Latitude in DMS format
Statee	Statee of the Station
Catchment	Catchment of the Station
Subcatchment	Subcatchment of the Station
RegManagmt	RegManagmt of the Station
OperatnlRegion	OperatnlRegion of the Station
HydroReg	HydroReg of the Station
RH	RH of the Station
Municipality	Municipality of the Station
CodeB	CodeB of the Station
CodeG	CodeG of the Station
CodeCB	CodeCB of the Station
CodePB	CodePB of the Station
CodeE	CodeE of the Station
CodeCL	CodeCL of the Station
CodeHG	CodeHG of the Station
CodePG	CodePG of the Station
CodeNw	CodeNw of the Station
Code1	Code1 of the Station
Code2	Code2 of the Station
Code3	Code3 of the Station
MaxOrdStrgLvl	MaxOrdStrgLvl of the Station
MaxOrdStrgVol	MaxOrdStrgVol of the Station
MaxExtStrgLvl	MaxExtStrgLvl of the Station
MaxExtStrgVol	MaxExtStrgVol of the Station
SpillwayLevel	SpillwayLevel of the Station
SpillwayStorage	SpillwayStorage of the Station
FreeSpillwayLevel	FreeSpillwayLevel of the Station
FreeSpillwayStorage	FreeSpillwayStorage of the Station
DeadStrgLevel	DeadStrgLevel of the Station
DeadStrgCapac	DeadStrgCapac of the Station
UsableStorageCapLev	UsableStorageCapLev of the Station
UsableStorage	UsableStorage of the Station
Key1fil	Key1fil of the Station
Key2fil	Key2fil of the Station
Key3fil	Key3fil of the Station
CritLevelSta	CritLevelSta of the Station
CritLevelSta	CritLevelSta of the Station
MinLevelSta	MinLevelSta of the Station
MaxLevelSta	MaxLevelSta of the Station
CritFlow	MaxLevelSta of the Station
MinDischarge	MinDischarge of the Station
MaxDischarge	MaxDischarge of the Station
Distance	Distance of the Station
Infrastructure	Infrastructure of the Station
Type	Type of the Station
Usee	Usee of the Station

*Required columns

File	Rows	Status
precip.csv	0/30
precip2.csv	90/90
wl.csv	20/30

Stations

Data file containing stations can be previewed in a map that shows the name of the each stations after clicking on each of them.

Station Groups and Variable Types Stations

Data file containing stations groups or variable types stations are previewed by providing a table with the content of the file.

Time Series

Data files for each time series are plotted in order to be previewed.

The CSV files must have the following header columns for the stations, station groups, variable types stations, and time series tables

Otherwise, data will not be uplaoded properly

Sample files can be found here for the different tables

Stations

The data file containing the stations data should have the following columns

StationName2, Longitude, Latitude, Altitude, Longitude2, Latitude2, DMSLongitude, DMSLatitude, Statee, Catchment, Subcatchment, RegManagmt, OperatnlRegion, HydroReg, RH, Municipality, CodeB, CodeG, CodeCB, CodePB, CodeE, CodeCL, CodeHG, CodePG, CodeNw, Code1, Code2, Code3, MaxOrdStrgLvl, MaxOrdStrgVol, MaxExtStrgLvl, MaxExtStrgVol, SpillwayLevel, SpillwayStorage, FreeSpillwayLevel, FreeSpillwayStorage, DeadStrgLevel, DeadStrgCapac, UsableStorageCapLev, UsableStorage, Key1fil, Key2fil, Key3fil, CritLevelSta, CritLevelSta, MinLevelSta, MaxLevelSta, CritFlow, MinDischarge, MaxDischarge, Distance, Infrastructure, Type, Usee

Stations Groups

The data file containing the stations groups data should have the following columns

StnGroup
Sequen
Station

Variable Types Stations

The data file containing the variable types stations data should have the following columns

StationType
Sequen
Variable

Time Series

The data files containing the time series might have different columns, but all of them should have a column called table_name with at least the first cell containing the name of the table to insert in the MCH database. For example, for daily precipitation data the name of the table is ddprecipitation

It is strongly suggested that the user knows the name of the table associated with the type of variable that one wants to uploads

MCH Database Tables