Datasheet

14
Data Retrieval, Processing and Final Storage in the Nile Basin Database
Detailed Outline of Data Trajectory
Step
Operation
Hardware Involved
Software Involved
User Action
1
~ Periodic automatic measurement of
meteorological parameters
~ pre-processing and storage in the
datalogger’s RAM
~ Sensors
~ Datalogger
~ Campbell Scientific Datalogger
Operating System (OS)
~ METSTAT datalogger program
~ None
2
~ Transfer of accumulated
measurements from logger’s RAM to
portable SM4M/SM192 Storage
Module; each single transfer exercise
results in a separate data file
~ Datalogger
~ SM4M/SM192
Storage Module
~ CR10KD Keyboard
Display
~ Campbell Scientific Datalogger
Operating System (OS)
~ METSTAT datalogger program
~ Connect SM4M to datalogger
~ Type in proper keyboard
commands
The user can choose between
automatic or manually invoked data
transfer
3
~ Transfer of data files from SM4M or
SM192 Storage Module to PC
~ SM4M/SM192
Storage Module
~ SC532A Interface
~ PC
StgModule component of
PC208W datalogger support
software
~ Connect SM4M/SM192 to SC532
~ Activate StgModule Software
~ Establish connection between PC
and SM4M/SM 192
~ Invoke data transfer
4
~ Separating and/or rearranging
individual meteorological parameters
from a complete, original data file
~ PC
~ Report (Split) component of
PC208W datalogger support
software
~ Activate Report software
~ Open appropriate pre-defined
parameter file
~ Select input data file
~ Run Split
~ First, visual data quality check
5
~ Exporting separated/rearranged
meteorological parameters to comma
separated ASCII file
~ PC
~ Report (Split) component of
PC208W datalogger support
software
~ Activate Report software
~ Open appropriate pre-defined
parameter file
~ Select input data file
~ Select and define output data file
~ Run Split
6
~ Importing comma separated ASCII
file into MS Access and restructuring
data to NBD format
~ Initial (automatic) quality control
~ PC
~ MS Access
~ (predefined tables in NBD
NEW DATA folder)
~ Activate MS Access
~ Open appropriate database file
~ Import ASCII file in predefined
table
~ Final check of data and
corrections
7
~ Final Storage in the NBD
~ PC
~ MS Access
~ (predefined tables and queries
in NBD NEW DATA folder)
~ Activate predefined query to
restructure data format and finally
store/append data into NBD.
8
~ Further quality control, dissemination
and use of data stored in the NBD
(described elsewhere)
~ PC
~ MS Access
~ (NBD folder)
~ Open ap propriate NBD file
~ Open appropriate table
~ Export data into desired
application program or file for
further analysis or data
dissemination (see chapter 7)
Table 1: Comprehensive Data Trajectory