FREE ELECTRONIC LIBRARY - Thesis, dissertations, books

Pages:     | 1 |   ...   | 4 | 5 ||

«NILE BASIN INITIATIVE Initiative du Bassin du Nil Information Products for Nile Basin Water Resources Management The ...»

-- [ Page 6 ] --

A second small window, called “Show Table”, will appear on the screen. Proceed and select the database table which contains the target data for exchange (say the “AWS Meteo_Daily Data” as an example given in Step E3) by highlighting the table name from the list displayed in the “Show Table” window; click on “Add” and then click “Close”

button to close the show table window. The computer screen looks now as shown below:

–  –  –

The view shown above is called “Query 1: Select Query”. It is in this view where the user has to select/design a query which will look into the specified database table and select the data records targeted for transfer/exchange.

Step E5: Proceed and double click on each of the field names displayed in the small window (with the name of the queried table displayed on its top) located in the upper left corner of the above view; in our illustrative example the name of the queried table is “AWS Meteo_Daily Data” (shown on the top of the small window) and the field names to double click are “Station-ID”, “Date”, “Source”, “Avg_T” and so on.

The result of this operation is illustrated on the screen shown below:

The next to do is to use “Criteria” field (located in the lower part of the above view) to specify the NBD Station IDs and the time period (i.e. the begin and end dates) written down under the Step E1.

Step E6: First specify the station IDs by clicking in the “Criteria” cell under “Station-ID” and type the selected station ID. Then proceed and specify the begin and the end dates of the time period of interest by clicking the “Criteria” cell under “Date” and by typing the following or similar text “between#01-Jul-98#and#30-Jul-98#” in the cell;

depending on the specific time period for which the data records are to be extracted from the main database table.

The result of Step E6 is illustrated below:

–  –  –

Step E7: Select “Datasheet View” under “View” of the MS Access main menu to see if the query is selecting properly the desired data records; if it is not, change/amend the query criteria accordingly.

Once it has been verified that the query is selecting the desired data from the appropriate main database table in

correct manner, proceed and copy the selected data records into a new table as follows:

Step E8: Go to the Query Design view and select “Make-Table Query”“ from Query” of the MS Access main menu.

Type any preferred name for new table in the blank space behind “Table Name” (say “Meteo Daily for Transfer”).

Select the option “Another Database” and type below the path and name of your new blank database file; type here the Windows/DOS convention path which was written down under Step E2, i.e. C:\MyDbase\Transfer.mdb

Finally click on “OK”

Step E9: While still in the Query Design View, select “Run” from the “Query” main menu bar and click “Yes” to confirm that you want to copy the specified number of records into the table located in the new database file (in our example: table “Meteo Daily for Transfer” located in the new database file “Transfer.mdb” in folder “MyDbase”).

The extracted data are now located in “Transfer” file on hard disk and is ready for dissemination; to complete the procedure, proceed with the next final two steps.

Step E10: In case the user opts to use a diskette for disseminating/transferring data, he/she should proceed and copy the file “Transfer.mdb” from hard disk to the diskette using Windows Explorer utility for the purpose.

The diskette with the extracted data records is now ready for dissemination to other users.

Step E11: In case the extracted data are planned to be disseminated by e-mail, it is recommended to make the “Transfer” file as small as possible. For this purpose the user is directed to compress the file by using either the PKZIP or WINZIP utility before the file is e-mailed to other users as a file attachment.

Step E11 completes description of procedures for creating an Access “Transfer” database file and storage of the

–  –  –

selected data from any main database file/table into the newly created file as described in the steps E10 and E11.

Data stored in the “Transfer” file can now easily be transferred to other users either by e-mail or on a floppy disk.

If there is a need to transfer data from more than one station, and for different data records, the user should just repeat the steps described above but for other stations and/or different data records. In this case each station will have its data in a separate table but in the same Access “Transfer” file.

–  –  –

Annexes Annex 1: Consecutive Steps in Connecting Storage Module SM4M/SM192 to PC.

Annex 2: Consecutive Steps in Retrieving Raw Data Files form SM4M/SM192 Storage Module to PC.

Annex 3: Consecutive Steps in Processing Raw Data Files in Report.

Annex 4: Consecutive Steps in Final Processing of Report Output Files in MS Access and Appending Processed New Data Sets to NBD.

Annex 5: General Design of the Append Queries for Pre-Processing of the Report Output Files in MS Access.

Annex 6: Design of the ID Converter Table.

–  –  –

The above steps are discussed in detail in paragraph 5.2.2 of this manual.

Annex 2: Consecutive Steps in Retrieving Raw Data Files from SM4M or SM192 Storage

–  –  –

Annex 3: Consecutive Steps in Processing Raw Data Files in Report.

Annex 3:Consecutive Steps in Processing Raw Data Files in Report.

Step Action C1 Activate Report by clicking the Report tab on the PC208W toolbar.

C2 Choose Open from the File menu to activate a pre-defined parameter file.

C3 Navigate to the location on hard drive, which contains the parameter files. This is “C:\CAMPBELL\FILES\PARAMETR” if the Recommended Directory Structure is used. Highlight the concerned parameter file and click OK.

C4 Activate the Input File(s) sub-window and select the Input Data File. To this end click “Browse” in the Input Data File box and navigate to the location on hard disk which contains the data files. Highlight the appropriate file and click OK.

C5 Switch to the Output File sub-window by clicking its tab at the top-mid of the current Split screen.

C6 Select location for, and give a name to, the resulting Output file. To this end click “Browse” in the Output Data box. Navigate to the desired folder on the hard drive and type in an output file name according to the convention discussed in paragraph Click OK.

C7 Finalize the routine by selecting Go from the Run menu.

The above steps are discussed in detail in the paragraphs 5.3.2 of this manual.

Annex 4: Consecutive Steps in Final Processing of Report Output Files in MS Access and Appending Fully Processed New Data Sets to NBD.

Annex 4: Consecutive Steps in Final Processing of Report Output Files in MS Access and Appending Fully Processed New Data Sets to NBD.

Step Action D1 Open the MS Access file “NBD_PreProcessing.mdb” in folder C:\MyDbase\NBD NEW DATA\Kenya Preprocessing – for Kenya, or C:\MyDbase\NBD NEW DATA\Rwanda Preprocessing – for Rwanda, or C:\MyDbase\NBD NEW DATA\Uganda Preprocessing - for Uganda.

D2 Highlight the appropriate auxiliary table and click “Open”. See Table 4 in paragraph 6.2 for an overview of the auxiliary tables (Group 1).

D3 Select all records by simultaneously keying CTRL and A, or clicking Select All Records in the Edit menu.

D4 Delete all records by choosing Delete Records from the Edit menu, or by pressing the ‘Delete’ key.

D5 Close auxiliary table.

D6 In the database window, select Get External Data from the File menu. Choose the sub command Import.

D7 In the subsequent window, navigate to the folder containing the Report output files and select the concerned one. Use the appropriate Windows Explorer commands. If the recommended directory structure is used, these files are stored in folder C:\CAMPBELL\FILES\OUTPUT. Make sure the ‘Files of type:’ box below-left is in “Text Files”.

D8 Click Import.

D9 Select “Delimited” and click “Next”.

D10 Select “comma” and click “Next”.

D11 Check “In an Existing Table:” and navigate in the related list box to the appropriate auxiliary table. Click “Next”.

D12 Click OK.

D13 Finalize data processing and storage into the NBD by activating the appropriate pre-defined append query. See Table 5 in paragraph 6.4 for the required combination of query, input and output file.

D14 Click Yes.

D15 Click Yes.

D16 New set of data have been stored/appended in the NBD; open the respective NBD table to check the final results.

The above steps are discussed in detail in the paragraphs 5.3.2 of this manual.

–  –  –

Annex 5: General Design of the Append Queries for Final Processing of the Report Output Files in MS Access.

The function of the pre-defined append queries is to perform the final processing steps in MS Access. This


• two separate text fields containing day and month, and year respectively, are converted into a single date field;

• short datalogger ID (due to the logger’s memory configuration limited to a number below 255) is transferred into an official numerical station identifier, in case of Hydromet-IDs consisting of 8 digits;

• automatic quality control: checking if the data values are within an expected range;

• adding of ‘source’ value: indicating the origin of the data set;

• re-arranging column structure to NBD format.

The window below presents the design of the “Meteo_Daily AWS” append query, which uses “Meteo_Daily” as auxiliary source table and “AWS Meteo_Daily Data” as the final destination table in the NBD.

The query employs two tables: ID-Converter and an auxiliary MS Access table, in this case Meteo_Daily. The tables are linked through the Datalogger-ID field.

Field 1 is used to transfer the (short) datalogger ID into a permanent unique station identifier.

Field 2 serves to convert the two fields “Year” and “MM-DD” into a single date.

Field 3 has the function to add a source value to the final data table. The number 104 has been allocated for data stemming from the FAO GCP/IRAF/304/JPN and FAO GCP/INT/752/ITA Projects’ Monitoring Network.

Field 4 to 10 contain the actual data values.

Automatic quality control is accomplished by specifying validation rules in the target tables.

The design of the other append queries is analog. Input (auxiliary) and Output table should be changed according to the combinations presented in Table 5 in paragraph 6.2.

The first three fields are identical for all queries, while the remaining fields depend on the data contents of the auxiliary table.

An overview of the various auxiliary tables (Group 1) is given in Table 4 in paragraph 6.2.

–  –  –

Annex 6: Design of the ID Converter Table The ID Converter table serves to transfer the datalogger IDs to official station identifiers. Due to memory allocation, the datalogger ID is a short integer between 1 and 254, which does not allow for proper station numbering in a comprehensive hydrometeorological network.

The following screen presents the design of the ID Converter table.

The first field contains the datalogger ID, while the second stores the corresponding station ID: the official station identifier assigned by the hydrometeorological service. The remaining fields are used for adding station specific information. Their purpose is mainly to avoid confusion while adding records to the ID Converter table.

In data view, this table is shown below. The Uganda situation is presented on the screen below (note that the fourth record has been added for the illustration purpose only).

For stations established by the FAO GCP/RAF/304/JPN and GCP/INT/752/ITA Projects in The Nile Basin, Add or modify the records as appropriate, i.e. in accordance of the actual station ID and other data for each station.

–  –  –

Pages:     | 1 |   ...   | 4 | 5 ||

Similar works:

«CREEP FEEDING BEEF CALVES CIRCULAR E-848 OKLAHOMA COOPERATIVE EXTENSION SERVICE DIVISION OF AGRICULTURAL SCIENCES AND NATURAL RESOURCES OKLAHOMA STATE UNIVERSITY CREEP FEEDING BEEF CALVES Keith S. Lusby Extension Beef Cattle Specialist Oklahoma State University Role of Creep Feeding Creep feeding used to be thought of simply as a method of increasing weaning weights of nursing calves. Programs were limited to free-choice grainbased mixes and were often unprofitable because intakes of creep...»

«Hygienic Implications of Small-Scale Composting in New York State Final Report of the Cold Compost Project Prepared by The Cornell Waste Management Institute Ithaca, NY Ellen Z. Harrison Director May 2004 Cold Compost Project – Final Report Acknowledgements This project was made possible by funding received from the Cornell University Agricultural Experiment Station and Cornell Cooperative Extension. Useful comments on the fact sheet developed to reflect this project were received from...»

«SUPPORT DOCUMENT FOR COMPOST QUALITY CRITERIA NATIONAL STANDARD OF CANADA (CAN/BNQ 0413-200) THE CANADIAN COUNCIL OF MINISTERS OF THE ENVIRONMENT (CCME) GUIDELINES AGRICULTURE AND AGRI-FOOD CANADA (AAFC) CRITERIA FOREWORD The Support Document for Compost Quality Criteria National Standard of Canada (CAN/BNQ 0413-200) The Canadian Council of Ministers of the Environment (CCME) Guidelines and Agriculture and Agri-Food Canada (AAFC) Criteria was made possible by an Agriculture and Agri-Food Canada...»

«Journal Submittal INVESTIGATIONS INTO LIQUID COMPOST EXTRACTS (“TEAS”) FOR THE CONTROL OF PLANT PATHOGENIC FUNGI William F. Brinton Andreas Tränkner 1 (Extract from Biocycle Paper presented in Phoenix, AZ) Introduction The potential disease suppressive characteristics of composts is well known and is the subject of increasing scientific efforts, dating from reports as early as 1973 (Hunt et al, 1973). New interest is seen with the use of liquid extracts for disease control. Compost...»

«Implementation of a Composting Program at the University of Delaware: Sustainability Report Fall Semester 2009 Steven Adler Kristin Blaha Rachel Lipman Kurt Saunders Julie Wang Executive Summary The Composting Crusaders endeavor is to implement composting into the University of Delaware’s sustainability initiative. Composting requires a 3:1 ratio of carbon to nitrogen using organic materials that fertilizes soil and plants, and it further reduces the burden wrought by overflowing landfills on...»

«Testimony of LeRoy T. Carlson, Jr. Chairman – United States Cellular Corporation Senate Commerce Committee Subcommittee on Communications, Technology and the Internet April 9, 2013 Chairman Pryor, Ranking Member Wicker and members of the subcommittee, I am Ted Carlson, Chairman of United States Cellular Corporation. Thank you for the opportunity to speak with you today. I am pleased to provide you with my observations on the state of rural communications and the challenges we face in serving...»

«Guide to Recovering and Composting Organics in Maine Maine Department of Environmental Protection Guide to Recovering and Composting Organics in Maine Pre-consumer food scraps ready for composting. Photo by Mike Burden, University of Missouri College of Agriculture Mark A. King and George M. MacDonald Maine Department of Environmental Protection Bureau of Remediation and Waste Management Sustainability Division March 2016 www.maine.gov/dep MAINE DEPARTMENT OF ENVIRONMENTAL PROTECTION 17 State...»

<<  HOME   |    CONTACTS
2016 www.dis.xlibx.info - Thesis, dissertations, books

Materials of this site are available for review, all rights belong to their respective owners.
If you do not agree with the fact that your material is placed on this site, please, email us, we will within 1-2 business days delete him.