Campbell PC208W Manual de usuario descargar pdf (Pagina 41)

Data Retrieval, Processing and Final Storage in the Lake Victoria Basin Database

Processing in MS Access and Final Storage into the LVBD

6.2 MS Access Database “LVBD Final Processing”

The remaining data processing activities are carried out in a MS Access database called “LVBD_FinalProcessing.

mdb”. If the user is applying the recommended directory structure, this file is stored in the sub folder C:\MyDbase\

Pre_LVBD.

This database contains several pre-defined objects including 11 tables and 5 append queries. Table and query 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 four different classes.

Group 1 is formed by the auxiliary tables in which to import the respective comma separated ASCII files generated in •

Report.

Class 2 constitutes of a single ID-converter table used to relate the short datalogger IDs to a final official station •

identifier.

Group 3 consists of the tables in final LVBD format in which the fully processed new information is kept up to being added •

to the LVBD.

Lastly, class 4 is formed by the respective append queries used to generate the LVBD format table from the related •

auxiliary one.

No.

1.1

1.2

1.3

1.4

1.5

3.1

3.2

3.3

3.4

3.5

4.1

4.2

4.3

4.4

4.5

Object

HydroDay

HydroHour

MetDay

MetHour

MetRain

ID Converter

Additional Daily Hydro

AWLRS

Additional

Hydrographs AWLRS

Additional Daily Clim AWS

Additional Hourly Clim

AWS

Additional Hyetographs

AWS

Daily Hydro AWLRS

Hydrograph AWLRS

Daily Clim AWS

Hourly Clim AWS

Hyetograph AWS

Typettable

table

append query

Function

pre-deﬁned table in which to import comma separated ASCII

ﬁle “hyddayXX.txt” generated by Report (see paragraph 5.3)

ditto for “hydhrXX.txt”

ditto for “metdayXX.txt”

ditto for “methrXX.txt”

ditto for “metrnXX.txt”

table relating datalogger IDs to Hydromet station number or

other identiﬁer

pre-deﬁned table in LVBD format for storage of fully proc-

essed daily hydrometric data; from this table the data is ap-

pended to the appropriate corresponding table in the LVBD

ditto for hourly hydrometric data

ditto for daily climatological data

ditto for hourly climatological data

ditto for 5-minutes rainfall series

pre-deﬁned append query to transfer the contents of table

“hydroDay” into ﬁnal LVBD format in table “Additional Daily

Hydro AWLRS”

ditto for hydroHour

ditto for MetDay

ditto for MetHour

ditto for MetRain

Table 4: Database objects and their function in MS Access database “LVBD_FinalProcessing.mdb”.

1 2 ... 36 37 38 39 40 41 42 43 44 45 46 ... 61 62

Comentarios a estos manuales

Sin comentarios

Campbell PC208W Manual de usuario Pagina 41

Comentarios a estos manuales

Relacionado con productos y manuales para Software Campbell PC208W