
Introduction
Introduction
1.1 General
The Lake Victoria Monitoring Network comprises of Automatic Hydro-meteorological Stations equipped with
electronic instruments for data acquisition and storage. Measurements are initially pre-processed and stored on site
in a digital storage and control module, commonly referred to as datalogger.
Periodically, the accumulated raw data are transferred from datalogger to a computer at the office of the hydro-
meteorological service. This is accomplished with the help of a portable data retrieval unit, which can serve several
stations during a single inspection tour. In order to enhance sustainability of the network, a visiting frequency of 1
month is proposed. Consequently, data should arrive at the office of the hydro-meteorological service with a delay
of maximum one month.
After transfer of the collected hydro-meteorological information from retrieval unit to PC, the newly imported data
should be processed, checked on consistency and possible measurement errors, and stored in a dedicated table in
the Lake Victoria Basin Database (LVBD), regarded as their final destination.
The first segment of the data trajectory, i.e. transfer of measurements form logger to retrieval unit, is covered in
two previously issued manuals:
Manual for Installation, Operation and Maintenance of Automatic Water Level Recording Stations; •
Manual for Installation, Operation and Maintenance of Automatic Meteorological Stations.•
The second part of the data track is dealt with in this manual. It covers in detail all steps involved in transferring the
accumulated hydro-climatological measurements from the retrieval unit to final storage in the LVBD in MS Access.
This includes:
installation and setup of involved hardware components;•
transfer of raw data from retrieval unit to PC in a preliminary data and file format;•
separation of individual parameters from preliminary data file to comma separated ASCII file, and first, visual •
data quality check;
import of pre-processed ASCII file into MS Access;•
rearrangement of newly imported data to final table structure using pre-defined queries, as well as a second, •
computer operated quality check;
appending new data to LVDB.•
This manual deals with data originating from both Automatic Weather Stations (AWS) and Automatic Water Level
Recording Stations (AWLRS). Since a substantial number of steps in the data trajectory apply identically to both
type of stations, no separate paragraphs for hydrometric and meteorologic information have been included for the
majority of processing actions. Only when the required operations for AWS and AWLRS are significantly different,
special station specific paragraphs have been prepared. The reader is requested to disregard the texts not applicable
for his or her situation.
1.2 Overview of the Contents of the Manual
This manual describes in detail all steps and operations involved in transferring the accumulated raw data from
retrieval unit to PC208W software on PC, processing the new information and subsequently storing it in the LVBD in
MS Access.
In order to provide the user with the complete picture of the information flow from sensor to database, chapter 2
presents a detailed outline of the comprehensive data trajectory, as well as all software and hardware components
involved, and their role.
Comentarios a estos manuales