Datasheet

40
Data Retrieval, Processing and Final Storage in the Nile Basin Database
Data Processing in MS Access and Final Storage into the NBD
This database file (NBD_Pre Processing.mdb) contains several pre-defined objects including 4 tables and
3 process-append queries. The database tables and queries names are listed in table 4 together with a brief
description of their function.
As indicated by their numbering, the various database objects listed in table 4 are divided into three different
groups.
Group 1 consists of 3 auxiliary tables in which to import the respective comma separated ASCII files generated •
in Report (see chapter 5).
Group 2 consists of a single ID-converter table used to convert into a final station identification code in •
accordance with either the Hydromet coding system or the one which is in force in each country of the Nile
Basin.
Group 3 consists of 3 process-append database queries specifically designed to generate records in the final •
NBD database format from data in the respective auxiliary table in Group 1 and to automatically append these
records into the appropriate file and table of the NBD database.
Group
Group 1
1.1
1.2
1.3
Group 2
Group 3
3.1
3.2
3.3
Object Name
Meteo-Daily
Meteo-Hourly
Meteo-5minRain
ID Converter
Meteo_Daily AWS
Meteo_Hourly AWS
Meteo_5minRain AWS
Type
Table
Table
Table
Table
Query
Query
Query
Function
Pre-defined table in which to import comma separated ASCII
file “metdayXX.txt” generated by Report (see paragraph 5.3)
Ditto for “methrXX.txt”
Ditto for “metrnXX.txt”
Table relating datalogger IDs to Hydromet station number or
other identifier
A pre-defined query used to process data from the respec-
tive auxiliary table “Meteo_Daily” in order to generate records
in the NBD format, and to automatically append/store such
records in the NBD table “AWS Meteo _Daily Data”
Ditto for auxiliary table “Meteo-Hourly” and final NBD table
“AWS Meteo _Hourly Data”
Ditto for auxiliary table “Meteo-5minRain” and final NBD table
“AWS Meteo _5minRain Data”
Table 3: Database objects and their function in MS Access database file “NBD_Pre Processing.mdb”.
The final NBD tables in which the processed data will ultimately be stored/appended are located in the following
database files (including the whole folder/directory path):
NBD tables (a) “AWS Meteo _Daily Data” (b) “AWS Meteo _Hourly Data” and (c) “AWS Meteo _5minRain Data” are
located in:
C:\MyDbase\NBD\Daily Hydro-Meteorological Data\Daily Clim Kenya.mdb – for data observed at the •
meteorological stations in Kenya (for the time being there is only one such station established by the Project)
C:\MyDbase\NBD\Daily Hydro-Meteorological Data\Daily Clim Rwanda.mdb – for data observed at the •
meteorological stations in Rwanda (there is only one such station).
C:\MyDbase\NBD\Daily Hydro-Meteorological Data\Daily Clim Uganda.mdb – for data observed at the •
meteorological stations in Uganda (there are three such stations established by the previous project and 2
more by the present project in Uganda).
The above paths (folder/directory structure) are included into the respective pre-designed MS Access queries
indicated in table 4 and should not be changed by the user as any change of the folder/directory structure will result
in loss of the processed data.
The individual database items in a particular object group are subject to similar final processing. For example,