Home

Uganda Water Action Plan

Contents

1. eee HET t HHHH 9t s eee sette THU RETE 1122124 IHETIHEHIRHTURUEEHUHUBOHIIGHESETE BE eo pu _ 0 Haie teret Pn ae 0007000062400 SH SEHE iiu 42 silii seeoovesussoe fni inii 211221 11 02222 222022 1080 i ii ror 5 1020221122222227 HENIE 5 29852111199205222 4222222 811510155 220904221 44205994 149929994 29 999992050 ie State PATH to files for updating etc Figure 34 Pull down menu for Miscellaneous 8 1 Placing of files In order to safeguard data which are imported into or exported from the data base the data are placed in specific areas The DWD program has been preselected to use the 4 user s private paradox area C PDOX_HAV This area will be used to place data which are being exported out of the data base and when impor ting DWD will search in this area for the d
2. F2 Quit DWD 1 0 Figure 6 box to enter coments 49 gt Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan Page 13 Directorate of Water Development Annex 11 Location and identification data 1 4 v 1 of 36 x 21 Quit F3 Up amp Down Ctrl PgOn Ctri PgUp DWD Figure 7 When the text has been entered as much text as possible will be shown on the screen OTHER INFORMATION Location No 75703 Waterpoint No 1 Here a comment on the individual sampling may be written When a comment is to be entered the cursor is placed in the comment field and the alt F5 keys are pressed whereupon this box to enter the text appears When the text has been written the F2 lt Hydrochemical sampling dates Date Sampling method Discharge When the comment has been written F2 is pres sed The box will disappear and the first lines of the entered comment can immediately be seen on the screen figure 8 If the comment is to be edited or inspected the box may be fetched again by pressing lt alt gt F5 4 4 Search process In the data file being handled it is possible to page through the records by means of the ctrl PgDn or Ctrl PgUp keys Furthermore a specific record can be found if a search function is being used If you wish to search for a water point in a given parish you press Alt F
3. 42 Directorate of Water Development Annex 11 Now change directory to C AGIS by typing l cd Magis and press Enter et Type AGIS DWD and press Enter AtlasGIS is now starting It takes some time because it is a very big program Please be patient After some time a map of Uganda appears on screen d SD Md If you want to show some of the information transferred from the database you do the follo wing 1 Select File and press Enter 4 2 Select Datapoint and press Enter EJ 3 Select Use and press Enter 6 Now the system suggests to look the direc tory C AGIS UGANDA which happens to be the correct directory 4 Press lt Space gt to get a list of possible files The information on the waterpoints are stored in GRWDATA The information on yield tests are stored in YIELDATA The information on hydrochemical data are stored in WATERQUA Choose one of them only one can be active at a time amp AtlasGIS might ask you if the index is to be 45 rebuilt Answer Yes to this Now to show the points at the screen this 5 Select View from the main menu 6 Select Redraw Now the screen is redrawn showing the posi tions of waterpoints You zoom in on a smal ler area by selecting View Map In This brings a cursor to the screen Click on the area which you want to zoom into You can get the available information on any
4. Location and identification data 7 5 Location No 75703 4 F1 Waterpoint No 1 Waterpoint NAMUNGALWE H CENTRE District IGANGA County KIGULU Subcounty NAMUNGALWE Parish NAMUNGALWE Project No WOD4033 Type of waterpoint Borehole Date of Siting Method F1J Siting organisation F1 Approx discharge spring L min Coordinates in UTM or GEOGRAPHIC U G G UTM Zone 36 East North South Geogr DD MM SS Long 33 30 00 Lat 00 44 00 N N S Altitude Waterpoint owner Private Communal Instituttonal Waterpoint use Domestic Irrigation Livestock Industry Waterpoint abandoned due to Low yield Quality Technical at Date 1 of 36 ae 21 Quit F3 Up F4 Down Ctrl PgDn NextRec Ctrl PgUp Prev Rec DWO Figure 8 First screen image of the main table in the database Explanation to the fields The Location No DATATYPE N identifies the location of the waterpoint as regards District County Subcounty and Parish These combinations are stored in the Location table explained la ter This field has a so called LookUp facili ty When the cursor is placed in this field you can go to the location table simply by pressing F1 Once you enter the location table you find the location in question the following way 1 Move the cursor to the Dname field 2 Press lt Ctrl gt z This brings up a box in which you may enter a search criteria Let s take that you seek l
5. Installation data List of accepted point types This table is a LookupTable used GR_WATER Identification and location data List of accepted borehole sealing types This table is a LookupTable used by GR WATER Installation data List of accepted casing well materials This table is a LookupTable used by GR WATER Installation data List of accepted aquifer types This table is a used HYDROGEO Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan Page 3 3 11 12 13 14 15 16 17 18 19 20 SAMPMETH SAMPPRES BOREDIAM FILTSLOT YIELDTST GEOLOGY HYDROGEO HYDRCHEM HYDRDATA PARLIST Annex Report Volume 2 Directorate of Water Development Annex 10 List of accepted sampling methods for hydrochemical data This table is a LookupTable used by HYDROCHEM List of accepted sample preservation methods This table is a LookupTable used by HYDROCHEM File with borehole well diameters in different depth intervals The records in this file are related to records in GR WATER by NationaldNo and SerialNo The relation between GR WATER and BOREDIAM is a one to many relation File with filter slot sizes and diameters in different depth intervals The records in this file are related to records in GR WATER by NationaldNo and SerialNo The relation between GR WATER and FILTSLOT is one to many relation F
6. 2 40 uer AME _ ape teg 1s version 1 0 mmn Groundwater database DWO Danida arr 24 EE 333 oes HER Specify UserID TCA Password 4 at Figure 3 Display shown when DWD is activated Initials and password must be ente red before the data base can be ope rated When the program has been called DWD s start up display figure 4 is shown where user id and password must be entered in order to get access to the data base When this user information has been entered some rights are assigned to the user in a way so that some users are allowed to carry out all functions in the data base where as others are prevented from making changes in the basic data material and are therefore only allowed to inspect search and extract data Assignment of rights is described in section 11 On the display figure 4 the user id e g TCA is entered and subsequently the personal pass word If correctly corresponding initials and Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan 8 Directorate of Water Development Annex 11 password are entered DWD s main menu is shown If incorrect initials or password are inserted 2 more attempts are granted before the program is interrupted Please note that the program distinguishes between capital ang small letters in t
7. ft 2 2 25 Tables amp graphs Export to Export to spreadsheet spreadsheet word processing word proces sing GIS etc GIS etc Figure 1 System diagram With pre defined reports in the form of tables plots and data files DWD may be used for repor ting The users may carry out this form of reporting without extensive knowledge of Paradox and the other software types used The reporting takes place solely by indication in menus and dialogue boxes and by entering statements of periods etc Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan Page 4 Directorate of Water Development Annex 11 The optional data base and the user control led reporting must however cover all the special treatment carried out in connection with the daily work Data may be extracted in a format which may be imported by standard soft jware or which may be processed further in Paradox Menu guidance The user interface has been adapted to modern standards and is based on the CUA standard The data base is operated by means of menus dialogue boxes The program may be operated by both keyboard and mouse The individual choices are made by pointing and thereupon pressing Enter or by clicking the mouse on the required choice The menus are all based on pull down menus in which the possible choices are listed The general screen has been d
8. Up F4 Down Ctrl Pgdn Ctrl PgUp Figure 16 Screen image of the waterpoint ty pes Type of waterpoint Borehole 4 Dug Well Protected Spring 4 11 Pump types Data Import Export Report GIS Options Quit Type of pump installation Pump type Bucket lt Centrifugal pump Handpump Submersible pump 1 of 4 F2 Quit F3 Up F4 Gown Ctrl PgUp DWO Figure 17 Screen image of the pump types Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan gt Page 28 Directorate of Water Development Annex 11 4 12 Ring material Data Import Export Report GIS Options Quit Casing well ring material leq Type of material Black casing Bricks Concrete Mild steel Other PVC 1 of 6 21 Quit 73 Up F4 Down Ctri PgOn NextRec Ctrl PgUp Prev Rec OW Figure 18 Screen image of the ring materials 4 13 Pipe material Data Import Export Report GIS Options Quit Riser pipe material C 1 4 a ad F2 Quit F3 Up F4 Down Ctrl PgOn Ctrl PgUp DWD Figure 19 Screen image of the pipe materials Pipe material Galvanized iron Stainless steel Mild steel Uu al i Annex Report Volume 2 WAP Doc 011 Final fov ep Uganda Water Action Plan Page 29 Directorate of Water Development 11 4 14 Rod material Data Import
9. The records are sorted in ascending order accor ding to the value of Depth You can only have one record for each depth Press F4 to return to the master table or F3 to go to Aquifer type depth and yield Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan Page 23 Directorate of Water Development Annex 11 The fifth screen image Other information Data Export Report GIS Options Quit Location and identification data Cis OTHER INFORMATION a Location No 75703 Waterpoint No 1 This is a report of the drilling of the borehole 5 Hydrochemical sampling dates Sampling method Discharge sock 04 Air lift sampling Pumping 2 27 04 94 Air lift sampling 7 1 of 36 F2 Quit F3 Up F4 Down Ctri PgD0n Ctri PgUp OWD Figure 12 Fifth screen image of the main table in the database The fifth screen gives information on Other information Here you may input any comment relating to the waterpoint Press Alt 4FS to enter Edit mode Now you can type in your text When finished press F2 to return to the master table As described above the text or part of it will be shown on screen The last part holds the link to the Hydrochemi cal samples If you want to enter information on Hydrochemi cal analyses you should do it this way Goto the box named Hydrochemical sampling dates by pressing F4 Enter the date of sampling When this is done press Alt
10. 2 7 Delivery The system will be handed over to DWD in form of the specified database files the basic location file based on the CENSUS database names and numbers for districts counties subcounties and parishes Furthermore the source code of the software will be delivered The system will be delivered with a user s manual Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan Page 3 1 Directorate of Water Development Annex 10 3 SPECIFIC REQUIREMENTS 3 1 Definitions The database will be built as a relational database keeping information separated in individual files divided after their contents The individual files will be linked together using common fields Some of the database files are used as LookUpTables which means that user input is checked against the contents of a file If the input does not conform with the possible choices the user will be notified and asked to reenter the input Another possibility is to press F1 and use the arrow keys to select among the possible choices followed by a F2 keypress This will transfer the selected information to the database field question In the screen images the fields with table lookup are marked with F1 The LookUpTables are marked with an in the overview below The overview of the database will be as shown below RODMAT PIPEMAT INSTPUMP ILOCTABLE BOREFILT POINTYPE SEALTYPE INSTMAT GEOSET 2 3 4 3 6 7 8
11. optional searches in the data base i e the user may connect the individual registers as he wishes set up concrete search criteria point out specific data etc In this way the user of DWD can always find data which are of interest at a given time Exchange of data Data which in this way have been chosen in the data base are shown in a table on the screen The table may immediately be inspected and data may also be exported to other software where a special processing of data may take place e g statistical analysis Protection of data The operation of the data base has been orga nized in a way so that some users are allowed to enter edit and delete parts of the data material whereas other users may only inspect data and print out reports etc Annex Report Volume 2 WAP Doc O11 Final e Uganda Water Action Plan Page 7 Directorate of Water Development Annex 11 3 How to start the program The DWD program may be started by means of PARA DOX 4 5 UK version by executing the script of DWD SC It is advisable to install a menu choice in the upstart menu of each individual user which sees to it that the user is guided correctly into DWD View Ask Report Create Modi fy Image Forms Tools uM pts uk GLa ese fin 2419752 22 21222212112142212120 2222212 si
12. 3 generations of backups Make a backup each mor ning before you start entering data Annex Report Volume 2 WAP Doc 011 Final REPRINTED BY DEVELOPMENT SYSTEMS LTD BOX 5332 KAMPALA TEL 257574 2 47
13. 9 22 A Y a a a a A A GR WATER TESTTYPE 21 1 MAIN DATABASE AQUITYPE SAMPMETH SAMPPRES 10 11 12 A A v v v Y v BOREDIAM FILTSLOT YIELDTST GEOLOGY HYDROGEO HYDRCHE 13 14 15 16 17 18 A HYDRDATA PARLIST 19 20 Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan Page 3 2 Directorate of Water Development Annex 10 List of database files 1 2 3 4 5 6 7 8 9 10 GR_WATER PIPEMAT INSTPUMP LOCTABLE BOREFILT POINTYPE SEALTYPE INSTMAT AQUITYPE Main database file containing one record per borehole dug well protected spring The description includes IDENTIFICATION AND LOCATION DATA CONSTRUCTION DATA INSTALLATION DATA part of GEOLOGICAL AND HYDROGEOLOGICAL DATA OTHER INFORMATION List of accepted pumping rod materials This table is a LookupTable used by GR_WATER Installation data List of accepted riser pipe materials This table is a LookupTabie used by GR_WATER Installation data List of pump types This table is a LookupTable used by GR_WATER Installation data List of locations in Uganda The list contains a unique number for each location and form each location the name of DISTRICT COUNTY SUBCOUNTY PARISH and ENUMERATION AREA Information on borehole filter development This table is a LookupTable used by
14. Domestic y DELLS ss Livestock Industrial Waterpoint abandoned Low yield Water quality Technical 2 CONSTRUCTION DATA Date for completion of construction day month year Total depth of borehole well at date of completion m From From From From 8 Borehole well diameter 8 Casing well ring diameter mm Length m Casing well ring material PVC Mild steel Concrete Bricks Other Bottom of casing well lining m b g 1 Borehole sealing None Cement Bentonite Filter slot size amp intervals mm From mm From mm From Development of borehole filters Gravel pack Natural dev Spring Height x Width m H W No of spring outlets 3 INSTALLATION DATA Type of pump installation Submersible pump Centrifugal pump Handpump Bucket Date of pump installation day month year Name of pump Pump capacity Pump installation intake depth o m b g l Riser pipe material Galvanized iron Stainless steel Riser pipe diameter mm Pumping rod material Galvanized iron Stainless steel Pumping rod diameter mm GROUNDWATER INFORMATION 4 GEOLOGICAL AND HYDROGEOLOGICAL DATA Depth to bedrock m b g l Overall geological setting Lithology From Description m b g 1 From To From To From To From To From To Aquifer depth tor of aquifer type and yield Depth m b g 1 Overburden Yield m h Depth m b g 1 Bedroc
15. Export Report GIS Options Quit Pumping rod material Jay 1 3 8 F2 Quit F3 Up F4 Down Ctrt Pgdn Ctri PgUp OW Figure 20 Screen image of the pumping rod ma terials Rod material Galvanized iron Stainless steel Wire 4 15 Filter development Data Import Export Report GIS Options Quit Development of borehole filters Gravel pack 4 Natural dev zd 3 1 of 2 9 2 Quit Up F4 Down Ctrl Pgbn Ctrl PgUp DWD Figure 21 Screen image of the filter develop ments Annex Report Volume 2 WAP Doc 011 Finai Uganda Water Action Plan Page 30 Directorate of Water Development Annex 11 4 16 Parameter list Data Import Export Report GIS Options Quit List of parameters ere raar l Parameter Ammonium NH4 Bicarbonate HCO3 Calcium Ca Carbonate 03 Chloride CL Conductivity uS cm Faecal coli No 100 mi Fluoride F mg l Free Carbon dioxide CO2 mg l Hardness CaCO3 mg l Magnesium Mg mg Manganese Mn mg t F2 Quit Up F4 Down Ctri PgDn NextRec Ctri PgUp Prev Rec DWD Figure 22 Screen image of the hydrochemical parameter list 4 17 Sampling methods Data Import Export Report GIS Options Quit Sampling methods for Hydrochemical cate 24 Sampling methods Air lift sampling Bucket Pumping E gute l i ies ETE e
16. SEALING MATERIAL FILTER SLOT SIZES etc j as shown below The screen image shown below contains the required information but will not necessarily be the final edition The number of choices as regards Borehole Sealing Material should be limited by a table lookup facility a Oe Annex Report Volume 2 WAP Doc 011 Final e fey Uganda Water Action Plan Page 3 7 Directorate of Water Development Annex 10 Date for completion of construction day month year Total depth of borehole well at date of completion m _ Borehole well diameter mm From To mm From To mm From To mm From To Casing well ring diameter mm Length m Bottom of casing well lining m b g 1 Borehole sealing None Cement Bentonite Other Filter slot size amp intervals mm From To mm From To mm From To Development of borehole filters Spring Height x Width m H No of spring outlets Annex Report Volume 2 Gravel pack Natural dev x W WAP Doc 011 Final Uganda Water Action Plan Page 3 8 Directorate of Water Development Annex 10 3 1 4 Installation data Various data on the installation of Casing pumps etc should be stored in the database as shown below Any input to the fields CASING WELL RING MATERIAL TYPE OF PUMP RISER PIPE MATERIAL and PUMPING ROD MATERIAL should checked against a table lookup to assure uniform contents of the fields Casing well ring ma
17. Try to move between the two files by means of the 2 functional keys F3 and F4 Inside each file the TAB keys are used to move from field to field The functional key F6 is used to mark that a particular field should be included in the se lection When F6 has been pressed a check mark appears another touch on F6 removes the check mark again When a relation is to be created between the two fields the two fields which are to be related are selected thereupon the cursor are moved to the field in the first file press F5 here and a label e g xx is entered whereupon the cursor is moved to the corresponding field in the se cond file here F5 is pressed and the same label xx is entered By this marking a re lation has been created between the two files by means of the selected fields and the entered labels Finally it is possible to lay down some cri teria in the individual fields which must be met before data can be included in the selection procedure This requires a nomination of the condition s in each individual field When the conditions the relations and the marking of the fields have been carried out the query may be started by pressing F2 The table will now show the data which fulfilled all requirements made at the selection More detailed information as to how relations between the files are made and how requirements are made etc can be obtained by reading PARADOX chapters 5 and 6 which deal with the
18. data collection format is organized in the two major groups and seven sub headings given above Data may be entered as one of several given options as numeric and date format as descriptive text The use of codes has been avoided in order to minimize the risk of interpretational and entry errors Descriptive text is used to store e g geological descriptions in the original Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action lan Page 1 8 Directorate of Water Development Annex 9 form without introducing any new elements of interpretation during a coding process prior to date entry The data collection and reporting format is a clear text questionnaire designed for professionals involved in groundwater development The format covers all potential groundwater sources i e protected springs dug wells and shallow and deep boreholes and closely follows the menu operated database software 1 3 5 Database operation and maintenance Data entry has been initiated as an additional activity aiming at reducing the present backlog of data and developing the database up to a point where the database is fully up dated and operational The database should eventually be established within the Water Resources Department in Entebbe and thus share facilities with the already developed surface water database The office should be staffed with permanent staff qualified in database management and hydrogeology as well as data ent
19. h to open the screen with hydrochemical information Now the follo wing screen image appears Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan Page 24 Directorate of Water Development 11 A Data Export Report GIS Options Quit Hydrochemical data 1 4 Location 75703 Waterpoint No 1 Date 25 04 94 Sampling method Air lift sampling 24 F1 Preservation method Other F1 Discharge volume 1 Parameter Result F L DateOfAnalysis Ammonius NH4 2 f 26 04 94 Conductivity 1 4 26 04 94 Hardness CaCO3 5 3 26 04 94 pH 10 26 04 94 Potassium K 6 CCS w EA z 9 1 of 6 E s F2 Quit F3 Up 4 Down DWD Figure 13 Fifth screen image of the main table in the database The sixth screen gives information on Hydroche mical analyses Like the other screen images this is also divi ded into two parts The upper part The blue fields contain information on the sampling whe reas the pink fields contain information on the chemical analyses performed For each parameter press F1 to show the list of parameters you may enter Parameter name according to the list of parameters Attribute one character Result DATATYPE N Field or laboratory analysis DATATYPE A1 Date of analysis DATATYPE D Be aware that you can only have one analysis of the same parameter from one waterpo
20. largest of the activities under the RTWSP During the programme preparation and planning stages of the STWSP the programme has been fully integrated into DWD and this model is expected to continue during the implementation phases Annex Report Volume 2 WAP Doc 011 Final e e Uganda Water Action Plan Page 1 5 Directorate of Water Development Annex 9 Computerized databases are yet to be established in accordance with DWD requirements 1 2 9 Other programmes Minor construction activities are undertaken by Lutheran World Foundation LWF in Moroti district 40 boreholes and 20 protected springs per year The International Fund for Agricultural Development IFAD is to construct about 100 boreholes in Hoima district An additional 80 boreholes are constructed annually under Italian aid programmes in Hoima Mubende and Kotido districts No readily available databases are maintained and DWD does not receive teports from these programmes 1 2 10 Comparative analysis and conclusions on database need A vast amount of groundwater information has over the years been accumulated within the DWD but tne data has not been compiled in a systematic manner and is therefore not readily accessible Various manual data extraction exercises have been made by individual programmes for specific purposes but this has neither resulted in a systematic data organization nor improvement of data accessibility nere are at pre
21. the LookUp tables before they are to be used from the master table Almost all of the tables have MultiRecord struc ture which means that several records from the database appear simultaneously on screen You may scroll the information using the arrow keys or the lt PgUp gt and lt PgDn gt keys Neen eee ee ee en ee ee eee Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan 2 26 Directorate of Water Development Annex 11 4 8 Siting methods Data Import Export Report GIS Options Quit Siting Method 14 Siting Method lt None Resistivity Topographic Ctri PgDn NextRec Ctrt PgUp Prev Rec OWD 1 of 4 F2 Quit F3 Up F4 Down Figure 14 Screen image of the siting methods 4 9 Drilling methods Data Import Export Report GIS Options Quit Drilling Methods 134 F2 Quit F3 Up amp Down NextRec Ctrl PgUp Prev Rec DWD Figure 15 Screen image of the drilling me thods Drilling Methods Air rotary 4 Hand auger Hand dug Other Percussion drill Annex Report Volume 2 WAP Doc 011 Final Ne of Uganda Water Action Plan Page 27 Directorate of Water Development Annex 4 10 Waterpoint types Data Import Export Report GIS Options Quit Type of waterpoint C Joy a WD 1 of 3 g 2 Quit
22. the main database GR WATER Field Name Id national SerialNo Waterpoint Id project WaterpointType GridType UTMZone GridEast GridNS Longitude Latitude N S Altitude PrivateOwnership CommunalOwnership InstitutionOwnership Domestic use Irrigation Livestock Industrial AbandonLowYield AbandonQuality AbandonTechnical CompletionDate TotalDepth CasingWellRingDiameter CasingWellRingLength BottomCasingWellLining BoreholeSealing BoreholeFilters SpringHeight SpringWidth NoOfSpringOutlets RingMaterial PumpType DateOfPumpInstallation NameOfPump PumpCapacity IntakeDepth PipeMaterial PipeDiameter RodMaterial Field Type N Identification of location S Borehole number A20 Name of waterpoint A10 Local identification A16 Type of waterpoint Al UTM or Geographic coordinates Pe 0 gt 26 0 0 2 2 PRP ee POO 2 2 2 2 2 2 He H OV O gt gt OV ON 2 20 16 16 Zone no 36 is default UTM East UTM North Longitude DD MM SS Latitude DD MM SS N orth or S outh Altitude in meters Ownership Waterpoint use Abandoned due to low yield Abandoned due to quality Abandoned due to Technical problems Day of completion Total depth Riser pipe material Riser pipe diameter Pumping rod material Annex Report Volume 2 WAP Doe 011 Final Uganda Water Action Plan Page 3 14 Directorate of Water Develo
23. undertaken by the Geological Survey and the Water Development Department WDD now reorganized as the Directorate of Water Development DWD The total number of boreholes is close to 14 000 of which almost all carry a more or less comprehensive of record There are furthermore in the order of 15 20 000 identified springs of which some 30 are pxotected and an unknown number of dug wells for which records in general do not exist Following the end of the civil war in 1986 borehole reha bilitation and construction activities has again gained momentum with several large scale programmes presently being implemented These programmes are almost invariably financed by international and bi lateral donor agencies and NGOs The degree of individual project coordination with DWD varies from negligible to full integration as the DWD does not have sufficient staff and other resources for coordinating all the groundwater development activities under the different pro grammes The DWD may furthermore not always be the contractor for these programmes and the need for record keeping and data collection thus tends to be defined by the individual pro grammes r ther than by the DWD In order to facilitate efficient and appropriate groundwater reso rces management by the DWD it has been decided to pre pare a design for a national groundwater databank It should be realized that such a databank will emphasize groundwater vailability and quality rather tha
24. user s manual In figure 29 it can be seen how a selection with a connection between two files can be carried out A relation is made between the 2 files GR water the Groundwater database and Loctable by means of the field Id nationalber of sta tion The relation is stated by the entered label xx Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan Page 36 Directorate of Water Development Annex 11 By means of V the fields GR WATER 5Id national GR WATER SerialNo GR WATER Waterpoint and LOCTABLE Dname LOCTABLE Ccname have been selected for inclusion in the final data set When F2 is pressed the selected data will appear in a reply table as shown in figure 31 The selected data may now be inspected by means of the arrow keys or a mouse Annex Report Volume 2 WAP Doc 011 Final y Uganda Water Action Plan Directorate of Water Development Annex Report Volume 2 Data Export Report GIS Options Quit Answer ANSWER SerialNo Waterpoint BALAWOLI S BOROBORO S S BUDINI S S BUGONZA umm BUSOTAHOWESE f RUNDU KAMULI SHOW GROUND KANANAGE I uet KIANI SAWMILL 23 KYEEYA VILLAGE pc An SE UN perrete 142922 7 1939490 24 te 902 0699990922302 529 79 1929 199 99 99 9993 2 1 92 14 4994 199449990900094 I221311321123312551213131222 331158 444 244444 494 9
25. when you are stan ding in the National ID field This brings up a box where you can specify District County Subcounty and Parish A search is started and if one or more waterpoints exist within this pa rish the first one will be shown Now Ctrl PgDn and Ctrl PgUp can be used to locate the waterpoint in question If you wish to search for data for a given date you must place the cursor in the date field and press Ctrl Z and enter the required date in the small box which has appeared in the centre of the screen The entering is ended with Enter If this date has data they will be shown on the Annex Report Volume 2 WAP Doc Ot l Final Uganda Water Action Plan 22 Page 14 Directorate of Water Development Annex 11 screen after a short search If not you will be told that the search was without result 4 5 Creation of a new record To create new record press the INS key clear diagram will appear on the screen The diagram may now be filled in with the relevant information and F2 should be pressed The en tered information is now saved in the data base 4 6 Delete a record If a record is to be deleted in the file you must search for the information attached to the given record When the information ppears on the screen you press the DEL key A box will then appear on the screen in which you are asked to confirm that the current record is to be deleted from the file of records If the Ok key is activate
26. 1 9 9 94 2 22 524581 05222 2 p ses 559525229 tt Spe cesses os hoes 04992292 TOO 0050 99990909 094 9499099094 9497949999999 920000 9229 93 94940044 299 092 COOHSTDE OED T OT 1994 69991 499099449 020 Hint f 221 i HH e H 52550559 3 in inni HESRHIHESHHIESEHIHI BIER 71522111511 The table contains data which meet the set of criterions DWD 1 0 Figure 30 Result of the search If however you wish to treat the selected data they must be exported out of DWD This can easily be done by using DWD s export function Export of selected data In connection with the Search function an export function has been built in which can export the selected data to external programs Data may be exported to several different file formats Thus it is possible immediately to export data to Quattro Pro in comma separated ascii files in PARADOX tables dBASE IV Lotus 1 2 3 and VisiCalc When the inspection of the selected data has ended a box will immediately appear on the screen where it must be stated in which format the selected data are to be saved The system has been pre selected to to Quattro Pro but by using the arrow keys or the mouse the required format can be indicated ard the session is finished by pressing the OK key Page 37 Annex 11 WAP Doc 011 Final Uganda Water Action Plan Directorate of Wat
27. 824 UG 95 wt E j 4 rate a 2 F 2 2 M DEvELOPMET GROUNDWATER DATABASE ANNEX REPORT VOLUME 2 DOC 011 MINISTRY OF NATURAL RESOURCES DIRECTORATE OF WATER DEVELOPMENT 1995 924 1645 1415 T 1s a B amet dopo us 2 pen gt x 0 i A i T 5 lt x ae ve gt Ta e 2 as P 2 secre nist p Me E g em _ gece nape a a A MNA UE Ee i w oor PL RR Umm P og 2 a mm ER 2 ix MR 2 12 LIT is ee UGANDA WATER ACTION PLAN WATER RESOURCES DEVELOPMENT AND MANAGEMENT GROUNDWATER DATABASE ANNEX REPORT VOLUME 2 DOC 011 MINISTRY OF NATURAL RESOURCES DIRECTORATE OF WATER 1995 LIBRARY IRC PO Box 93190 2509 AD THE HAGUE Tel 31 70 30 689 80 Fax 31 70 35 899 64 BARCODE Q LO 82G 4 Uganda Water Action Plan Directorate of Water Development VOLUME 2 LIST OF CONTENTS Abbreviations Annex 9 GROUNDWATER DATABASE AND DATABASE LINKS Annex 10 DWD GROUNDWATER DATABASE SPECIFICATION OF REQUIREMENTS Annex 11 DWD GROUNDWATER DATABASE USER S MANUAL Annex Report Volume 2 WAP Doc 011 Final a RA Uganda Water Action Plan Directorate of Water Development LIST OF A
28. BBREVIATIONS AfDB CLICOM Danida DWD GIS GPS HYDATA HYDROCHEM IFAD KFW LWF NEIC NGO NURP RTWSP RUWASA STWSP SWIP UNICEF UTM WATSAN WB WDD African Development Bank Climatological database Danish International Development Assistance Directorate of Water Development Geographic Information System Global Poistioning System Hydrological database Hydrochemical database International Fund for Agricultural Development Kreditanstalt f r Widerafbau Lutheran World Foundation National Environmental Information Centre Non Governmental Organisation Northern Uganda Reconstruction Project Rural Towns Water and Sanitation Programme Rural Water and Sanitation East Uganda Project Small Towns Water and Sanitation Programme South West Integrated Health and Water Programme United Nations Childrens Fund Universal Transverse Mercator projection National Water and Sanitation Programme World Bank Water Development Department Now DWD Annex Report Volume 2 WAP Doc 011 Final ANNEX 9 GROUNDWATER DATABASE AND DATABASE LINKS Uganda Water Action Plan Directorate of Water Development ANNEX 9 LIST OF CONTENTS GROUNDWATER DATABASE AND DATABASE LINKS 1 1 1 1 Introduction 1 1 1 2 Ongoing groundwater development programmes and database status 1 2 1 3 Objectives and requirements 1 6 1 4 Use of the groundwater database 1 8 1 5 Relations between the groundwater database and external databases 1 9 Append
29. CTION 1 1 Objectives 1 2 References 1 3 Reading guide 2 GENERAL DESCRIPTION 2 1 System description 2 2 The functions of the software 2 3 Limitations 2 4 Future for the software 2 5 User profile 2 6 Requirements to the development phase 227 Delivery 3 SPECIFIC REQUIREMENTS 3 1 Definitions 3 2 Reports 3 3 GIS capabilities 4 EXTERNAL INTERFACE REQUIREMENTS 4 1 User interface 4 2 Hardware interface 4 3 Software interface 3 REQUIREMENTS TO THE PERFORMANCE OF THE SOFTWARE 6 QUALITY FACTORS 1 1 p 2 1 3 1 3 1 3 18 3 19 5 1 6 1 Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan Page 1 1 Directorate of Water Development Annex 10 1 INTRODUCTION Groundwater has played a significant role in domestic water supply in Uganda with construction of tubewells commencing in the early part of this century and private drilling contractors in operation as early as in the mid 1920s Other drilling activities have been undertaken by the Geological Survey and the Water Development Department WDD now reorganized as the Directorate of Water Development DWD The total number of boreholes is close to 14 000 of which almost all carry a more or less comprehensive of record There are furthermore in the order of 15 20 000 identified springs of which some 30 are protected and an unknown number of dug wells for which records in general do not exist
30. Directorate of Water Development Annex 9 Database users should be able to receive data in print out as well as diskette formats and all data should be linked to specific grid coordinates in order for the users to combine such data with other area characteristics and thereby develop a fully integrated geographical information system The database must be operated and up dated by DWD staff only thereby ensuring a consistent and correct database management DWD must ensure that information is readily Qbtainable upon request and within a reasonable time If necessary a fee to cover the direct costs involved in such data submission could be charged LS Relations between the groundwater database and external databases The DWD groundwater database is intended to be the first step in a phase which eventually will constitute a DWD management information system The groundwater database will receive data from the various projects which are in operation in Uganda However the present uncoordinated and inhomogeneous designs of individual project databases prevent DWD from obtaining computerized exchange of uniform and standardised data for water resources management purposes with most project databases Therefore input to the proposed DWD groundwater database is paper based using predesigned forms see Appendix 1 1 1 5 1 External databases of interest Three external databases have been identified as having data which may be of interest in a groundwa
31. Following the end of the civil war in 1986 borehole rehabilitation and construction activities has again gained momentum with several large scale programmes presently being implemented These programmes are almost invariably financed by international and bi lateral donor agencies and NGOs The degree of individual project coordination with DWD varies from negligible to full integration as the DWD does not have sufficient staff and other resources for coordinating all the groundwater development activities under the different programmes The DWD may furthermore not always be the contractor for these programmes and the need for record keeping and data collection thus tends to be defined by the individual programmes rather than by the DWD In order to facilitate efficient and appropriate groundwater resources management by the DWD it has been decided to prepare a design for a national groundwater databank It should be realized that such a databank will emphasize groundwater availability and quality rather than detailed technical data on individual installations A reasonable amount of technical data for waterpoint installations have been included though and it is believed that this database in addition to detailed information on the groundwater situation may also serve most of the requirements for information about technical installations at individual groundwater abstraction points boreholes dug wells and protected springs _ The databank is int
32. X Meer F2 Quit H Up tf4 Down Prev Rec DWD Figure 23 Screen image of the sampling met hods Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan Page 31 Directorate of Water Development Annex 11 4 18 Preservation methods Data Import Export Report GIS Options Quit Sample preservation methods Sample preservation methods Acid None Other 1 of 3 and F2 Quit F3 Up F4 Down Ctrl PgDn Ctrl PgUp DWD Figure 24 Screen image of the sample preserva tion methods 1 0f 3 Qm F2 Quit Up F4 Down Ctri Pgdn Ctri P9Up DWO Figure 25 Screen image of the aquifer types 4 19 Aquifer types Data Import Export Report GIS Options Quit Aquifer types Aquifer types 4 Fracture Overburden Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan Page 32 Directorate of Water Development Annex 11 C M COMM MCCC M M M C 9 4 20 Location table Data Import Export Report GIS Options Quit Location table 1 4 3 1 of 4233 J _ F2 Quit F3 Up F4 Sa Ctri PgDn Ctrl PgUp DWD Figure 26 Screen image of the location table Location No 11101 District APAC No 1 Count
33. a field When the contents of a field is to be erased the cursor is moved to the field When in the correct field press lt Ctrl gt lt Backspace gt Where do I find the data which I have exported Data which have been exported are found in the directory C PDOX_DWD What do I do if I get the message UNEXPECTED CONDITION LINK RANGE and Paradox aborts directly to DOS This is one of the worse problems since Paradox is not able to recover from an error which have occurred in one or more tables The problem is that a table might have been corrupted due to some hardware or software problem The solution is to repair the tables with the Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan Page 50 Directorate of Water Development Annex 11 built in tool TUTILITY Je From the DOS prompt you simply type TUTILITY and press Enter Now the utility program starts From the main menu Table is chosen Select the table GR WATER and choose verify If a problem is found the program will ask for a name for a copy of the old version Type f x OLDGRW Now TUTILITY will repair the damages found Repeat this procedure for the following tables BOREFILT FILTSLOT GEOLOGY 2 HYDROGEO and 7 HYDRCHEM and HYDRDATA if any data have been entered 2202222 2 What I if the script is cancelled by the error F
34. able You get into the first one by pressing F4 Now you may enter one or more records with in formation on Borehole well diameters From and To DATATYPES N is start and end of the interval as m b g l whereas Diameter is given in mm If you want to input more records you simply move the cursor to the next free record The records are sorted by the From field in ascending order You leave the box by pressing F4 go to Filter slot size amp intervals or F3 if you wish to return to the master table If you choose to enter information on Filter slot size amp intervals this is done in exactly the same way as explained above You leave the box by pressing F3 go to Boreho le well diameters or F4 if you wish to return to the master table Spring Height and Spring Width DATATYPES N are given in meters No of spring outlets DATATYPE S is self ex planatory Third part of the database Installation data Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan Page 19 Directorate of Water Development Annex 11 Data Import Export Report GIS Options Quit Location and identification Gata 14 INSTALLATION DATA a Location No 75703 Waterpoint No 1 Casing well material F1 Type of pump 11 Date of installation Organisation F1 Name of pump Capacity m3 hour Intake depth 6 9 1 Riser pipe material F1 Diame
35. able information This should include Location and identification data Installation data Construction data Geological data Hydrogeological data and Hydrochemical data 2 Reports on district level such as Information on the waterpoints type location name etc Information on yield test data from all waterpoints within a district Annex Report Volume 2 IRC me WAP Doc Oll Final E ane Cento Fax 34 s 35 36 40 64 Uganda Water Action Plan 3 12 Directorate of Water Development Annex 17 3 3 GIS capabilities To strengthen the overview of data it has been decided to implement a Geographic Information System GIS and link it to the database via files It has not yet been decided which system to use but it must be able to be executed in the same hardware environment as the groundwater database The system should be able to show locations of the waterpoints on a Uganda Map and it should be possible to click on a waterpoint and get detailed information on screen The system should be able to print out maps on ordinary printertypes Annex Report Volume 2 _ WAP Doc 011 Final Uganda Water Action Plan Page 4 1 Directorate of Water Development Annex 10 4 EXTERNAL INTERFACE REQUIREMENTS 4 1 User interface The user interface should bee based on a menu driven approach Wherever possible the input should be controlled against predefined tables This will assure a more sys
36. an Page 3 11 Directorate of Water Development Annex 10 Sulphate 50 7 mg l Chloride mg l Nitrate NO4 mg l Ammonium NH4 mg l Tot Iron Fe 4 Fe mg l Manganese mg l Fluoride mg l Free Carbon dioxide CO mg l 24 Tot dissolved solids mg l Faecal coli no 100ml Other chemical data Y N 3 1 7 Yield test flow and water level data As described in the part on the hydrochemical part 3 1 6 it should be possible to store an unlimited number of yield test data to each location Date of test day month year Duration of test hrs Type of test Pump test Air lift test Natural flow Transmissivity m 24h Specific capacity m h m Discharge during testing m h Static water level m b g 1 Date day month year Other Static water level data Y N Hydrofracturing Y N if Y day month year Other test pumping yield data Y N Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan gt Page 3 12 Directorate of Water Development Annex 10 3 1 8 Other information This part of the database is left open for any input relevant to the location Here any special circumstances may be described in plain text No checks on the contents will be performed Annex Report Volume 2 WAP Doc 011 Final gt Uganda Water Action Plan Directorate of Water Development Page 3 13 Annex 10 3 1 9 Database file structures Structure for
37. and borehole emergency rehabilitation in the Luwero triangle and activities in other parts of Uganda since 1984 Construction activities related to groundwater under SWIP comprise tubewells and spring protection in the districts of Masaka Rakai Mbarara Kasese Bushenyi Rukungiri and Kabale SWIP has its main office in Mbarara and the programme is only partially coordinated by DWD Data is maintained in the form of hard copies only and presently includes some 1 700 boreholes and approx 4 000 protected springs The current construction rate under the SWIP programme is 250 boreholes and 800 protected springs per year SWIP has two GPS units but they are not being routinely used and borehole location data in terms of coordinates are not available Water quality data only includes a limited number of physical parameters No chemical control is carried out 1 2 3 World Bank Northern Uganda Reconstruction Project NURP NURP is an integrated reconstruction programme which includes urban and rural water supply and groundwater development activities in nine districts Apac Gulu Lira Kitgum Soroti Kumi Palissa Arua and Moyo Drilling work is being carried out by DWD and these activities are expected to run for three years and to include a total of 360 boreholes With DWD as the drilling agency the reporting follows standard DWD formats No computerized databases are maintained 1 2 4 Plan International Plan International has recently cal
38. ata to be entered It is possible to divide the different types of input and output data according to subject By means of a sub menu it is possible to designate different areas drives as places for new stan dard code lists for updating Arop files Water chemistry data for import plus a statement of one s own private paradox work area Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan Page 45 Directorate of Water Development Annex 11 7 he The entries are carried out by means of a dia dialogue box as shown below Export Report Graphics Misc o ot abode eet sits State path for private PARADOX directory C PDOX_DWD OK x Quit 2 4 rane 74 1 0 Figure 35 Input box for entering a directory 8 2 Print out medium Here you may choose whether reports print outs should be sent to a file to a printer or to the Screen The pre selection is screen After each report you are asked whether it should be printed out as well but you have to pass this menu choice to direct a printout to a text file When a file has been selected the user is asked for a file name every time a printout is gene rated Afterwards the report will be traceable with this name and the extension rpt 8 3 Periods of waiting when messages are shown When a message is displayed it remains on the screen for a given amount of ti
39. ay carry out orders and you may afterwards return to DWD by writing EXIT Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan _ Page 48 Directorate of Water Development Annex 11 9 Quit The program may be quitted in two ways Either you quit the program and go to Paradox or you quit DWD and Paradox and go to DOS Annex Report Volume 2 pi WAP Doc 011 Final a 4 2D aha 05 7 Uganda Water Action Plan Page 49 Directorate of Water Development Annex 11 Annex A Questions and answers What do I do if I have modified the contents of a field but immediately regret it and want to keep the previous version If you have changed or erased the contents of a field the original version can be recreated by pressing ctrl u What do I do if I by error delete a record If you have deleted a record and regret in imme diately after the record can be recovered by pressing lt 1 gt It only goes for the last record and only if you have not left it If more records are deleted only the last one can be recovered How do I alter the contents of a field without retyping all of it Place the cursor in the field to be modified Press lt Alt gt F5 and use the arrow keys to move the cursor to the right position Use the Ins key to insert characters etc or Backspace to erase Leave this mode by pressing Enter How do I erase the contents of
40. been developed in collaboration with DWD s relevant professional staff However the databases have been developed for RUWASA s use only and have not been correlated to other programmes data registration The RUWASA data registration furthermore gives high priority to construction information for project monitoring purposes and is thus not directly suitable for groundwater registration and or monitoring The databases related to groundwater development presently maintained by RUWASA are a hydrogeological and borehole database a water quality database and individual databases for protected springs dug wells and hand augered boreholes Location data for all waterpoints are being established as grid coordinates by use of Global Positioning System GPS Full chemical water quality testing is carried out more or less as a routine procedure and all waterpoints are as a minimum tested for physical parameters All RUWASA databases have been prepared using dBASE IV software and the project has recently defined activities to establish links between their individual databases and to make the RUWASA databank compatible to the DWD requirements Annex Report Volume 2 WAP Doc 011 Final ee 4 M Uganda Water Action Plan Page 1 3 Directorate of Water Development Annex 9 1 2 2 UNICEF South West Integrated Project SWIP The SWIP programme was launched by UNICEF in 1987 following a period of handpump
41. ble have now been selected and the extent of the search may be specified as to the fields to be included and as to how the two registers should be tied together etc Data Export Report GIS Options Quit Query Gr water GR WATER 14 national SerialNo Waterpoint t 1 ls Number Dname Ccname Ssname 2 4 22221555222 snm oe paces e9000 6153 229221222 ae 6 4 44 2 990 6 4994 6 00 4 2 9999000069 666646024 0469 669 494924 9 n 124412 DII 444944 possess 1 F21 Ask SPSS F4 Down Figure 29 Search boxes in which relations and conditions as regards the search are created For each of the selected files a window will appear where the fields of the files are repre sented partly by their field names and partly by a box In each of these boxes it may be stated whether this particular field is to be included in the selection procedure whether it is to be used to create a relation to another file or whether a condition regarding the con tents of this field should be made WAP Doc O11 Final Uganda Water Action Plan Page 35 E Directorate of Water Development Annex 11 In order to be able to operate on the screen it is necessary to know how to move about between the different files how to create relations etc
42. cedure is carried out in the correct manner a new user is added if the entry was wrong an error message will appear on the screen and the pro cess must be repeated E Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan Page 47 Directorate of Water Development 11 you wish to change your password do as fol lows Options User list Change Hereafter you must enter your present password then the new one and finally as a control the new password once more If this procedure is carried out in the correct manner the new pass word will be registered if not an error message will appear on the screen Options User list Right This function can should only be selected by a user A table is shown on the screen containing all initials of all users of DWD Opposite each user the user s password and a code figure are shown stating the rights which the individual user has in the system There are three degrees of rights O 1 and 2 0 gives the right to inspect data but no right to correct delete or add data in the data base 1 gives the right to inspect edit and add data in the data base and finally 2 gives the right to inspect edit and add data in the data base and the right to assign rights to other users Only one user should have this right 8 5 Go to 008 If this function is chosen DWD is suspended and you will return to DOS In DOS you m
43. choices are shown by pressing F1 Approx discharge spring may hold the amount of discharge in L min The coordinates of the water may be stored in two ways Either as Geographical or as UTM If given in UTM the zone must be specified The geographic coordinates are given as DD MM S8 DATATYPE A8 Remember to specify if it is North or South of Equator Only coordinates given in LONGITUDE and LATITUDE are transferred to the AtlasGIS files No conversions between the UTM and geographic coordinates are done this version of the database ae Annex Report Volume 2 WAP Doc O11 Final Uganda Water Action Plan Page 17 Directorate of Water Development Annex 11 The Altitude DATATYPE N field may hold the altitude in meters above sea level In the Waterpoint owner DATATYPE A1 fields you may specify the type of the owner simply by entering a X in either of the fields In the Waterpoint use DATATYPE A1 an X may be entered in one or more of the fields If the waterpoint is abandoned DATATYPE DATE for some reason this may be registered by en tering an X in one or more of the fields The date of abandoning may be entered in the last field of the screen Now onwards to the next image Construction data Data Import Export Report GIS Options Quit Location and identification data 10 4 CONSTRUCTION DATA a Location No 75703 Waterpoint No 1 Completion date 1 12 90 4 Total de
44. ction 1 3 3 System description The database has been designed to include basically two different types of data i e waterpoint information and groundwater information The waterpoint information includes 1 identification and location data 2 construction data and 3 pump installation data The groundwater information is given under another three headings 4 geological and hydrogeological data 5 hydrochemical data and 6 yield test flow and water level data Further to these six headings a category 7 other information has been included which may include e g information on ownership and users etc The database is first and foremost intended as a groundwater database which also includes the most frequently used installation data It is envisaged that it will be operated and maintained by professional staff at DWD head office and that a relatively uniform level of quality control and data reliability thus can be ensured prior to entry in the database The database is designed to receive and store data to be reported in a standard format from the individual implementation programmes and at a later stage from monitoring activities carried out at decentralized e g district level Another key point in the design has been to ensure full compatibility and interaction with other planned DWD databases and to the extent possible with external databases e g census data 1 3 4 Data collection format and reporting procedures The
45. cture for information Field Name SamplePreservationMethod on Pumptypes INSTPUMP Field Type on Parameters PARLIST Field Type A30 A10 on Riser pipe materials PIPEMAT Field Type on Pointtypes POINTYPE Field Type on Pumping rod materials RODMAT Field Type on Sampling methods SAMPMETH Field Type on Sample preservation SAMPPRES Field Type A5 Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan Uis 3017 Directorate of Water Development sp TL ee Structure for information on Sealing methods SEALTYPE Field Name Field Type ap COND 4m eue Gub aP np ae Op ow CUP AD AD a exp am emm an dD nb P 4 Gm es Cum SealingMaterial 16 Structure for information yield test types TESTTYPE Field Name Field Type Testtype 15 Structure for information on Overall geological settings GEOSET Field Name Field Type ap ap ow a ume Cf ow ow a up o gt ap mm ap OverallGeologicalSetting A50 3 2 Reports The system should be prepared with some standard reports It has not yet bees 77 72 which types but the following types have been discussed 1 Report a single waterpoint giving the avail
46. d the record with the information on the client will be deleted if however the Quit key which is preselected is pressed the process will be interrupted and nothing has been deleted Please note that only records which have no related records the ones in the pink fields on the screens can be deleted As long as there exist related records deletion of the master record will be rejected In such cases each of the related records must be deleted prior to deleting the master record Only users with right on level 1 or higher may delete data 4 7 Location and identification data This part of the database forms the central part of the data storage facilities Here almost all data are stored in the master file GR WATER and in related detail tables such as xx xx and xx This part of the database presents its fi elds in 5 successive screen images holding information on Identification and location Construction Installation Geology and hydrology Other information and water chemistry Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan Page 15 Directorate of Water Development Annex 11 The screen images will be explained in the fol lowing You move between the images by pressing lt PgDn gt lt PgUp gt or by using the lt Arrow gt keys at the last or first field in each screen First Identification and Location data Data Import Export Report GIS Options Quit
47. d Type N Sx N A10 Fracture Overburden N Yield in m3 h Structure for information on Hydrochemical samples HYDRCHEM Field Name Id national SerialNo DateOfSampling SamplingMethod SamplePreservation DischargeVolume Field Type Structure for information on Hydrochemical data HYDRDATA Field Name Id national SerialNo DateOfSampling Parameter Attribute Result Field Lab Date Field Type N S D A30 From PARLIST Al N Al Measurement or analysis D Date of laboratory analysis Structure for information on Casing well ring materials INSTMAT Field Name RingMaterial Field Type aA we ded Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan Directorate of Water Development Page 3 16 Annex 10 Structure for information Field Name oa Cui ap af op uum Of RED OP Gum yu PumpType Structure for infc mation Field Name Parameter Unit Structure for information Field Name RiserPipeMaterial Structure for information Field Name ume eu Um ap ume us ap CONS ap d ue Ge GD ap m PointType Structure for information Field Name PumpingRodMaterial Structure for information Field Name SamplingMethod Stru
48. d be able to handle input being entered manually into the database There should exist possibilities of printing reports to screen printer or to a file The should Annex Report Volume 2 WAP Doc 011 Final to LA 4 Uganda Water Action Plan Page 2 3 Directorate of Water Development Annex 10 be facilities for exporting data to common standard software e g spreadsheets database standards and to comma separated ASCII files The software should be capable of exporting relevant information to a GIS system The system should be menu driven The dialogue should be in English 2 3 Limitations The system will be developed to be executed on IBM PC or compatibles Since DWD at present has no network facilities the system will act as a standalone application to the users However facilities for concurrent updating of the databases should be built in to secure future demands The system will be dependant of the available information from the data deliverers If the system is not updated on a regular basis or if the quality assurance of the input the system will not be able to give useful information 2 4 Future for the software The DWD groundwater database is meant to be the very first step in creating an information management system for groundwater data As mentioned above this part of the system will cover information on the points boreholes dug wells and protected springs and if available on the hydrochemical
49. datapoint on screen This is done in this way j Annex Report Volume 2 WAP Doc 011 Final Annex Report Volume 2 Uganda Water Action Plan Page 43 Directorate of Water Development Annex 11 1 Select Edit from the main menu 2 Select Datapoint from the Edit menu 3 Select PopUp from the Datapoint menu Now a cursor appears on screen Move it to a datapoint and click the mouse but ton A window will appear on screen showing the data for this point When finished press lt Done gt to select another one or to finish Remember that even though you can alter the information on the waterpoints here it has no effect in the groundwater database These are two different systems You end the AtlasGIS by returning to the File menu and choose Quit Do not save the current mapfile WAP Doc 011 Final Uganda Water Action Plan Page 44 Directorate of Water Development Annex 11 e 8 Options Miscellaneous contains a number of different functions The functions cover e g a temporary suspension and also a change of the user id rt Report Graphics Misc Quit 7 Placing of files Print out medium iiis Periods of waiting 22 EIER HR EH LEE Check L st of users Go to DOS ae a att iiti BUSINESS 11111111 HH 22 2222520022251 fiti SHIRE pun
50. e contractor for these pro grammes and the need for record keeping and data collection thus tends to be defined by the individual programmes rather than by DWD In order to facilitate efficient and appropriate groundwater resources management by DWD it has been decided to prepare a design for a national groundwater databank It should be realized that such a databank will emphasize groundwater availability and quality rather than detailed technical data on individual installations A reasonable amount of technical data for waterpoint installations have been included though and it is believed that this database in addition to detailed information on the groundwater situation may also serve most of the requirements for information about technical installations at individual groundwater extraction points boreholes dug wells and protected springs The databank is intended to be one of a larger number of databases on water resources water supply facilities construction work cost and monitoring etc which eventually should constitute a DWD management information system The proposed databank will thus fulfil the DWD requirements for groundwater information but may be supplemented by individual project databases as and when appropriate It should furthermore be mandatory for future implementation programmes or contractors of boreholes dug wells and protected springs to submit groundwater data to DWD following the proposed database format Annex R
51. e in the record where the cursor is Regret is activated simply by pres sing lt Ctrl U gt 4 1 Editing of data When a result should be changed or entered manu ally the arrow keys are used to move the cursor to the required field Thereupon the result may be entered If an incorrect result has been inserted in the field which needs to be corrected it is necessary first to delete it by means of the Backspace key which deletes back wards or the lt Ctrl gt lt Backspace gt and then the new value may be entered If it is a keying error entered values texts may be edited by pressing lt alt gt lt F5 gt in this way it is not ne cessary to alter the entire contents of the field in question When the display has been corrected it is possible to go on to the next item which needs to be corrected or controlled and at the same time the data base is brought up to date When changes of the data file in question have been made it is possible to leave the editor by using F2 which makes the program return to the main menu It is important to understand that corrections which are made on these displays are a fact as soon as the record with the corrected data is left i e if the keys PgDn Down arrow Up arrow are used to go on to the next record Thus it is only possible to regret the corrections for the record which the cursor points at Regrets are made by pressing Ctrl U 4 2 How to enter dates All dates in DWD must ob
52. elevant available groundwater data in order to prepare an overview of the groundwater resources in terms of quantity quality and availability The database will serve as an efficient tool in groundwater resources management and constitute an important basis for planning of future groundwater development activities through combination with e g census data whereby detailed information on coverage and service level may be compiled Groundwater monitoring will further be enhanced A e 1 3 2 Functional requirements The database will include static as well as dynamic data Static data are geology drilling dimensions and location whereas dynamic data which may change with time are e g water level chemistry and pump installation data The database is designed to include at all times the latest available information on dynamic data When updating such data the format will automatically indicate that other earlier data are available and that these are stored in related databases The basic record identification will be the national I D number which is unique for each waterpoint Such I D may be supplemented by a local I D given by the individual projects of contractors The national I D includes a district and waterpoint type identifica tion code and is given automatically upon data entry This is to ensure a unique numbering system when receiving data from a large number of different construction sites simulta neous
53. ended to be one of a larger number of databases on water resources water supply facilities construction work cost and monitoring etc which eventually should constitute a DWD management information system The proposed databank will thus fulfil the DWD requirements for groundwater information but may be supplemented by individual project databases as and when these feel a need for it It should furthermore be mandatory for future implementation programmes or contractors of boreholes dug wells and protected springs to submit groundwater data to the DWD following the proposed database format 1 1 Objectives The purpose of developing a national groundwater database is to provide a tool for storage analyze and presentation of groundwater data The system must provide means of quality Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan Page 1 2 Directorate of Water Development Annex 10 control quality assurance of the data being entered into the system The system should be capable of functioning as well as a tool in the daily work as a system for creating overviews 1 2 References M UGANDA WATER ACTION PLAN Water resources and management PHASE II Inception report December 1993 1 3 Reading guide The description of the specifications of requirements is organized such a way that chapter 2 contains an overall system design and a general description of the functions the system is supposed to execute Furthermore
54. eport Volume 2 WAP Doc 011 Final Uganda Water Action EE Page 1 2 Directorate of Water 4 i Annex 9 1 2 Ongoing groundwater development programmes and database status The present groundwater development activities in Uganda are undertaken by a relatively large number of programmes and projects The overall annual construction rate is 3 500 waterpoints of which 1 600 are boreholes deep and shallow hand augered 1 600 protected springs and 300 are large dug wells 1 2 1 Danida Rural Water and Sanitation East Uganda Project The RUWASA programme started pilot activities in 1989 and full scale construction in 1991 The programme covers eight districts in south eastern Uganda Mukono Jinja Kamuli Iganga Tororo Pallisa Mbale and Kapchorwa and is envisaged to have a 10 year implementation period during which it is estimated to construct a total of 10 000 waterpoints The programme is restricted to rural areas and practically all extraction facilities will be hand operated point sources thus providing a large number of observation points but only limited groundwater extraction The number of waterpoints constructed by RUWASA so far is 1 900 900 boreholes 800 protected springs and 200 dug wells and the present annual construction rate is 500 boreholes 300 protected springs and 110 dug wells RUWASA is fully integrated into DWD and maintains databases which have
55. er Development Page 38 Annex Data rt Export R cue Graphics Misc RR eue 4221 941222 9111227 ii 1 1 1 Bio EE dBASE IV Seien 1 2 3 Release 2 VISICALC dif R uu Hing m RENE Tnm i bela oss iat tee racer 221222 2 12224 He n i uc mm c s gt iu um 1702 16944 _ DE 9 69 9 9 9400 9 ii HH Here 492 mr apum Figure 31 Dialogue box to state the format in which data are to be saved You will now be asked to give the data a file name and the data will be exported in the re quired format The data will be stored in the directory stated as privatdir under Placing of files Privatdir has been preselected to C PDOX Depending on the format chosen for exporting the data the file will get its surname The table below shows the possible surnames Export file format Surname Quattro Pro LOTUS dBASE VisiCalc 1 2 3 IV Annex Report Volume 2 WAP Doc 011 Final amp y Uganda Water Action Plan Page 39 Directorate of Water Development A
56. eters etc Press F4 to enter this part You may enter one ore more records in this sec tion but only the first one will be visible You can scroll the information by using PgDn lt PgUp gt or the arrow keys Date DATATYPE DATE is the date of the yield test Durat DATATYPE N is given in hours with decimals if necessary Test type DATATYPE A11 has LookUp help Press F1 for help Transmiss DATATYPE N holds information on transmissivity Spec Capaci DATATYPE N holds information on the specific capacity Discharge DATATYPE N is the discharge during test Static Water Level DATATYPE N is self explana tory Date DATATYPE DATE is the date of the static water level HydrFrDate DATATYPE DATE is the date of hydro fracturing Return to the master table by pressing cv ia The records are sorted Annex Report Volume 2 WAP Doc 011 Fixal Uganda Water Action Plan Page 21 Directorate of Water Development Annex 11 The fourth screen image Geological and hydroge ological data Data Import Export Report GIS Options Quit Location and identification GEOLOGICAL AND HYDROGEOLOGICAL DATA Location No 7570 Waterpoint No Depth to bedrock 27 m 5 4 1 Ov geol settings Drilling method F1 Lithology Description Black top soil Clay mica sand Gravel bolders Aquifer type depth and yield Depth m Type Yield m3 h 24 F
57. he login procedure If a non registered user wishes to use DWD it is necessary to ask a registered user to be added to the system as a new user See section 8 add user and assign rights Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan Page 9 Directorate of Water Development Annex 11 4 Viewing and editing data In DWD data are edited viewed in specific data entry schemes for defined for each of the data base files In the DATA menu data are divided into two different groups divided by a separator line The main database which holds the majority of the data input is found above the separator line whereas all tables which are used as lookup tables are located below this line The contents of these files are normally not subject to changes however they may be modified by users with such rights In the sections 4 1 to 4 6 you will find a general description of how data are added edited or removed After this a description of each of the database files is given Data Export Report GIS Options Quit MM Ground water database Siting Methods Drilling methods Waterpoint type Pump type Ring material material EHE Rod material Filter development Parameter list Sampling methods Preservation methods Aquifer types Geological settings Locat on table Organisations Figure 4 The DATA curtain If you choose Data on the main men
58. ield No Of Boreholes does not exist This means that the script the program is in an error state which is not handled The pro blem is that there is a record in the database which has an empty field within Waterpoint No It is most certain the last one entered Do the following 1 Press Ctrl q to exit the script 2 Press F2 to end the tables You might do 7 this a number of times until the message Nothing to process now appears T 3 Press F8 to empty the screen 4 Exit Paradox from the menu 5 Start Paradox as usual from DOS you might want to switch the PC off and on to start the normal way Search for the last record entered using the lt Ctrl gt z function When it is found the record must be deleted and the information re entered It is most likely that it is an empty record with no other information than the Location No How do I backup the data in the database You do the following 1 Leave the database system and go to DOS 2 Type CPBACKUP GRWATER C GRW CALL DATA __ q Annex Report Volume 2 WAP Doc 011 Final m 7 v ee ee Uganda Water Action Plan Page 51 Directorate of Water Development Annex 11 and press lt Enter gt Now the IBM standard backup system starts It asks for a floppy disk to be inserted into the A drive 3 When finished terminate the backup pro cedure Store the floppy in a safe place Have 2 or
59. ified and tested for applicability It was demonstrated that this auxiliary programme satisfies the basic ena for data ail and export to other relevant database formats The database operated by Ministry of Finance and Economic Planning is based on dBASE and exchange of data on selected projects will be a standard routine However only the financial part is computerized whereas the project profiles are written in WordPerfect The DWD database will be able to deliver any information in a number of different formats The built in general query facilities will enable export of data from the various files of the database in the following formats spreadsheet files Quattro Lotus 1 2 3 and DIF format database files dBASE Paradox ASCII files comma separated The proposed groundwater database will thus be able to exchange information with databases containing other relevant information Annex Report Volume 2 WAP Doc 011 Final 4 by rt e FORMS FOR GROUNDWATER DATABASE APPENDIX 1 1 W OI INFORMATION 1 IDENTIFICATION AND LOCATION DATA Type of waterpoint Borehole Dug Well Protected Spring Identification National I D No Project I D No Location LONGITUDE LATITUDE UTM if UTM ZONE Number Longitude E Latitude N S Altitude UTM E UTM N S Altitude District County Sub County Parish Village Waterpoint Waterpoint ownership Private Communal Institutional Waterpoint use
60. ile with yield test flow and water level data The records in this file are related to records in GR WATER by NationalIdNo and SerialNo The relation between GR WATER YIELDTST is a one to many relation File with geological description of the location The records in this file are related to records in GR WATER by NationaIdNo and SerialNo The relation between GR WATER and GEOLOGY is a one to many relation File with aquifer type yield and depth The records in this file are related to records in GR WATER by NationalIdNo and SerialNo The relation between GR WATER and HYDROGEO IS one to many relation File with hydrochemical sample information The records in this file are related to records in GR WATER by NationaldNo and SerialNo The relation between GR WATER and HYDRCHEM IS a one to many relation File with results of hydrochemical analyse of groundwater The records in this file are related to records in GR WATER by NationaldNo and SerialNo The relation between HYDRCHEM and HYDRDATA is a one to many relation List of parameters and units used to describe the hydrochemical WAP Doc 011 Final Uganda Water Action Plan Page 3 4 Directorate of Water Development Annex 10 analyses This table is a LookupTable used by HYDRDATA 21 TESTTYPE List of accepted testtypes for yield test This table is a J LookupTable used by YIELDTST 22 GEOSET List of types of overall geological settings This table is a Lo
61. int on a specific sampling date since data are uniquely identified by Waterpoint No Date and Parame ter If you try to enter the same parameter twice you will get an error message on the screen saying that the key already exists In es e aex Report Volume 2 EB 4 m _ Doc 011 Final Uganda Water Action Plan Page 25 Directorate of Water Development Annex 11 this case you must delete the last to skip the error status You can scroll between the chemical analysis in the database by pressing lt PgUp gt or lt PgDn gt if the cursor in the upper part of the screen ima ge You may even scroll to analyses from other waterpoints When you press lt F2 gt for Quit you are automatically taken to the record from which you called the Hydrochemical samples This marks the end of the description of the master table GR_WATER LookUp tables The following paragraphs from 4 8 to 4 21 cover the tables being used as LookUp tables Various fields in the master table are controlled by the contents of these tables to assure uniform in put This is very important since the possibili ties of making queries will depend of the lity of the field information The LookUp tables may be modified in the same way as the master table However it requires that you have rights to enter modify data The LookUp values must be present in the tables prior to using them The correct way will be to update
62. ion and construction details and regularly reports to DWD 1 2 7 Directorate of Water Development DWD and UNICEF Water Sanitation Pro gramme The WATSAN programme coordinated by DWD is dependent on funding from various sources such as Government and donor agencies mainly UNICEF The programme carries out spring protection borehole rehabilitation and recently a shallow well programme was started The construction rate varies in accordance with available funding and is on average 200 augered boreholes dug wells and 500 protected springs per vear Standard DWD hard copy reporting is used 1 2 8 WB AfDB and KFW Rural Towns Water and Sanitation Programme RTWSP The RTWSP encompasses a number of activities for development of urban and small towns water supply This type of water supply will partly be based on surface water but to a variable degree also on groundwater from tubewells and springs The total number of towns expected to be covered by the programme is more than 60 within an estimated implementation period of 10 years Feasibility studies and demand studies are far from completed and the total number of groundwater extraction points to be developed is therefore difficult to establish It is envisaged however that the total number of groundwater extraction points under the three programmes will be more than one thousand The Small Towns Water and Sanitation Programme STWSP which is about to commence pilot activities is by far the
63. ish Name Village A50 Enumeration area Name Dcode S District code Ccode S County code Scode S Subcounty code Pcode S Parish code Enum S Enumeration area code 3 1 2 Identification and location data The database should be able to store the following data items on identification and location It will be necessary to be able to store the coordinates in two ways namely as UTM coordinates and as longitude latitude The UTM coordinates requires a zone number as well as Uganda covers two UTM zones zone 35 and 36 The screen image shown below contains the required information but will not necessarily be the final edition Annex Report Volume 2 WAP Doc Olt Final Uganda Water Action Plan Directorate of Water Development Type of waterpoint Identification Location District Parish Waterpoint ownership Waterpoint use Waterpoint abandoned 3 1 3 Construction data It is necessary to keep information on the construction of the borehole dug well or Borehole National I D No Grid N S County Village Private Domestic Low yield 2 Irrig _ Dug Well __ Page 3 6 Annex 10 Protected Spring _ Project I D No Altitude sub County Waterpoint Communal Water quality Livestock 2 Institutional Industrial Technical protected spring This will comprise DATE FOR COMPLETION TOTAL DEPTH DIAMETERS OF THE BOREHOLE
64. ithin a district This is actually not a real report but a list of hydro chemical parameters which ex ceed WHO Guideline values The values are shown on screen Annex Report Volume 2 WAP Doc 011 Final e ej 2r 1 5 Uganda Water Action Plan Page 41 Directorate of Water Development Annex 11 7 GIS It is possible to extract selected data and transfer these to the AtlasGIS system which is also installed on the computer This is to be used for presentation purposes and for spatial analyses on data You transfer data simply by selecting each of the three parts shown below Only data with Longitude and Latitude are trans ferred GIS Options Quit Transfer Location data Transfer WQ data Transfer YieldData Transfer datapoints to Atlas format Figure 33 Transfer data to AtlasGIS Data are transferred to DBASE format which is used by AtlasGIS The files are automatically copied to the directory in which the GIS data reside It is beyond the scope of this user manual to explain the use of the GIS A very good tutorial is delivered with the system and working your way through it will give a very good introduc tion to the world of GIS However a few comments on the use of the GIS is given here If you want to start the AtlasGIS you must first leave the database and return to DOS Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan
65. ivided into three parts In the top line the possible overall choices are listed also called the main menu When a choice is made in the main menu either a sub menu will appear in the form of a pull down menu with new menu points or a function will be carried out In the bottom line additional comments on the current choice appear highlighted on the main menu or the sub menus The remaining intermediate 23 lines 2 24 are used as work area i e in this area input dia grams reports etc are shown Dialogue boxes In many places the operation is based on the use of so called dialogic boxes where the user in a box on the screen must make a choice or enter a value or a name After the pointing out or en tering the choice must be confirmed This is done by pointing at an OK key and pressing En ter The alternative is to regret the choice by activating an Exit key Annex Report Volume 2 WAP Doc 011 Final ai Uganda Water Action Plan Page 5 Directorate of Water Development Annex 11 If a mouse is used the required selection must be chosen by a click on the mouse and then on either the OK key or the Exit key 1125529122223 1401221122101 thry 4 ret 446 ad 2 E 111125151 10 22 Figure 2 Example of a dialogue box In figure 3 an example of a dialogue box is shown In this exanple the user is asked to state the prin
66. ix 1 1 Annex Report Volume 2 WAP Doc 011 Final P Uganda Water Action Plan Page 1 1 Directorate of Water Development Annex 9 1 GROUNDWATER DATABASE AND DATABASE LINKS 1 1 Introduction Groundwater has played a significant role in domestic water supply in Uganda with construction of tubewells commencing in the early part of this century and private drilling contractors in operation as early as in the mid 1920s Other drilling activities have been undertaken by the Geological Survey and the Water Development Department WDD now reorganized as the Directorate of Water Development DWD The total number of boreholes is close to 14 000 of which almost all carry a more or less comprehensive record Furthermore there are in the order of 15 20 000 identified springs of which some 5 000 are protected and an unknown number of dug wells for which records in general do not exist Following the end of the civil war in 1986 borehole rehabilitation and construction activities have again gained momentum with several large scale programmes presently being implemented These programmes are almost invariably financed by international and bi lateral donor agencies and NGOs The degree of individual project coordination with DWD varies from negligible to full integration as DWD does not have sufficient staff and other resources for coordinating all the groundwater development activities under the different programmes DWD may furthermore not always be th
67. k Yield m h 5 HYDROCHEMICAL DATA Date of sampling day month year Sampling method Pumping Air lift sampling Bucket Sample preservation None Acid Other For pump and air lift samples Discharge before sampling liter Tot alkalinity mg 1 Hardness mg l Calcium Ca mg 1 mg l 25 mg l Potassium K mg l Carbonate C03 mg l Bicarbonate HCO4 mg 1 Sulphate 5047 mg 1 Chloride Cl mg l Nitrate NO mg l Ammonium NH4 mg l Tot Iron Fe Fe mg 1 Manganese 2 mg 1 Fluoride F mg 1 E Free Carbon dioxide CO mg 1 Tot dissolved solids mg 1 i Faecal coli 100 1 6 YIELD TEST FLOW AND WATER LEVEL DATA Date of test day month year Duration of test hrs Type of test Pump test i Air lift test 0 Natural flow _ Transmissivity m day Specific capacity m h m Discharge during testing m h Static water level m b g 1 Date day month year Other Static water level data Y N X Hydrofracturing Y N if Y day month year Other test pumping yield data Y N 4 OTHER INFORMATION eet ee nnn enn eee ne nn eee ANNEX 10 DWD GROUNDWATER DATABASE SPECIFICATION OF REQUIREMENTS DWD Groundwater database Specification of requirements July 1994 Uganda Water Action Plan Directorate of Water Development ANNEX 10 LIST OF CONTENTS 1 INTRODU
68. led for pre qualification of drilling contractors to construct boreholes in Luwero district No specific reporting format has been developed and the production rate is expected to be 100 boreholes per year 1 2 5 WaterAid British WaterAid has an ongoing shallow well construction rehabilitation programme in Kabarole district totalling 180 wells per year Some 40 hand augered boreholes have recently been completed in Mbale district and a new programme is about to be launched Kitgum district with an annual production of about 250 hand augered boreholes Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan Page 1 4 Directorate of Water Development Annex 9 Spring protection is ongoing in Rukungiri district with 700 springs protected already and a construction rate of 500 per year over the next two years The activities in Bushenyi district have now been halted due to lack of funding after protection of a total of 120 springs All spring borehole and well sites are located by use of GPS four units in operation and three more under procurement and there are plans to do test pumping for all new bore holes The programme furthermore carries out limited water quality tests basically physical parameters 1 2 6 CARE The annua construction rate under the CARE programme is 50 new boreholes and some rehabilitation in addition to a few protected springs CARE maintains a lotus database with iocat
69. ly All waterpoints are registered with indication of district county sub county parish village and waterpoint name as well as with grid coordinates This is to facilitate data extraction in accordance with administrative boundaries as well as area wise extraction following standard grid references The grid references and map drawing facilities have been given particular attention in order to ensure an easy integration of the database with possible future Geographical Information Systems GIS to be established under the aus pices of DWD or otherwise It is envisaged that the groundwater database users broadly will fall into one of the following three groups DWD Management as national resources administration authority individual projects agencies and contractors when planning construction of new facilities and Annex Report Volume 2 WAP Doc O11 Final a A Uganda Water Action Plan Page 1 7 Directorate of Water Development Annex 9 district authorities as the local water resources authority and as representatives for local waterpoint operation and maintenance organizations The requirements of these individual users will obviously not always coincide and the database therefore offers a high degree of flexibility and combination potential in data extr action Data extraction possibilities will thus include area wise extraction as well as cross sectional subject specific extra
70. me Depending on the speed of the hardware and the user s patience the periods of waiting may be too short or too long That is why it is possible to change the period of time during which the mes sages are displayed on the screen You change the time by selecting Periods of waiting in the Options pull down menu Your choice will bring forth a slide gauge on the screen which you may use to alter the period of Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan Page 46 Directorate of Water Development Annex 11 waiting of the mouse the arrow keys or lt by writing the desired period of waiting When the mouse or the arrow keys are used the slide gauge is moved in the required direction depending on whether the period of waiting should be shorter or longer You may also state the required period by writing the figures period of 2500 is preselected it may be regu B lated within the interval of 0 8000 Data Export Report Misc Quit Figure 36 Slide gauge to state period of wait ing when messages are shown 8 4 User list mE Here it is possible to add a new user of DWD to change your own password and to assign rights in the system If a new user is to be added you must choose Options User list Create Hereafter the new user s initials and password must be entered As a confirmation the password must be entered once more and if this pro
71. n detailed technical data on individ al installations A reasonable amount of technical data for waterpoint installations have been included though and it is believed that khis database in addition to detailed information on the groundwater situation may also serve most of the requirements for information about techni cal installations at individual groundwater abstraction points boreholes dug wells and protected springs The databank is intended to be one of a larger number of databases on water resources water supply facilities con struction work cost and monitoring etc which eventually should constitute a DWD management information system The proposed databank will thus fulfil the DWD requirements for groundwater information but may be supplemented by individual project databases as and when these feel a need for it It should furthermore be mandatory for future implementation programmes or contractors of boreholes dug wells and protec Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action P lan Page 2 Directorate of Water Development Annex 11 ted springs to submit groundwater data to the DWD following the proposed database format The purpose f developing a national groundwater database is to provide a tool for storage analyze and presentation of groundwater data The system provides means of quality con trol quality assurance of the data being entered into the System The system should be capable of f
72. nnex 11 6 Reports Some routines for reporting purposes have been developed so far However these will only form a subset of reporting requirements for the fu ture When requirements evolve new standard reports can be included in the system Generally reports may be printed on Screen printer or to a file If Screen is selected you have the possibility of copying the information to a printer after viewing it on screen You leave a report shown on screen by pressing F2 The Report menu curtain is shown below Data Export Report GIS Options Quit Waterpoint i District Water levels WHO Guidelines 0009 seco iit Hi Report waterpoint Figure 32 The Report curtain So far there are four choices Waterpoint This choice prints out all information about one single waterpoint The waterpoint is selected in a list which ap pears on screen This choice prints out data from the following tables GR WATER BOREDIAM FILTSLOT YIELDTST GEOLOGY and HYDRO GEO Annex Report Volume 2 WAP Doc 011 Uganda Water Action Plan Directorate of Wat r Development District Water levels WHO Guidelines Page 40 Annex 11 This report prints out infor mation on the waterpoints wit hin a district Start by selecting the dis trict from the list shown on screen This report prints out infor mation on water levels at each waterpoint w
73. nts is crucial Therefore it has been decided that the coordinates to the point must be given at least to the village enumeration area level Coordinates should be given either as latitude longitude or as UTM in zone 35 36 2 1 System description The DWD groundwater database shall serve two purposes namely Systematize the data on groundwater from various sources in Uganda and Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan Page 2 2 Directorate of Water Development 10 Provide information the quantity and quality of the groundwater resource The information will come from various sources each using their own systems for data storage It is anticipated that DWD will receive data from the drilling operators in form of schemes filled out with the required information These schemes will be considered being the original input to the system The overview of the system will look like this t z 25 2 25 22 25 38 92 52 8 2 Data input schemes 42 25 gt 5 Water level time series Y B groundwater database 25 2 25 25 25 2 36 22 25 25 2 2 2 2 25 Meteorological data precipitation a Tables graphs Export to Export to spreadsheet spreadsheet word processing word processing GIS etc GIS etc 2 2 The functions of the software The software shoul
74. o Low yield Quality Technical at Date 1 of 36 F2 Quit F3 Up F4 Down Ctrl PgDn NextRec Ctrl PgUp Prev Rec DwD Figure 5 The first screen image of the data base When the cursor is to be moved from one level to another the F3 or the F4 buttons are pressed Depending of which level you are in you can scroll the information on waterpoint level or at detail level simply by pressing PgUp PgDn Crtl PgUp Pgdn or the Arrow keys When a data item is to be entered or changed the arrow keys are used to bring the cursor to the field in question Now data may be entered If something is already written in the field this may be emptied by pressing the Backspace or the Ctrl Backspace button Now the new value can be entered If only part of the field is subject to change the value string may be edited by pressing Alt 4 F5 This will avoid that the entire value string is to be re ente red When the actual screen image is modified you can go to the next page by pressing an arrow key or the PgDn key You can also continue to the next record by pressing Ctrl 4 PgDn It is important to notice that any change being made Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan Page 11 Directorate of Water Development Annex 11 is in effect as soon as you continue to another record If you want to regret your modifications this is only possibl
75. ocation in KAMULI district Then you 3 Enter KAMULI and press Enter it is necessary to enter the Now the cursor is placed at the first occurren ce of KAMULI if found Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan 16 Directorate of Water Development Annex 11 4 Now move the cursor to the County field Find the correct county and move on to subcounty and repeat moving the cursor until also the correct Parish is found Having found the right location you press F2 which 5 brings you back to the main table and 6 supplies the names of the location in the pink fields below the number Now the Waterpoint number is supplied too This is done automatically and should not be changed If a record is deleted at a later sta ge the serial number is not reused thus leaving an empty number in the row The Waterpoint field DATATYPE S allows input of a name or an identification of the water point No tests are performed on the user input The Project No DATATYPE A25 can contain a local identification code being used Input is automatically converted to capitals to ensure some degree of uniform input Type of waterpoint DATATYPE A16 is a LookUp field Input is controlled against the table POINTYPE Press F1 to choose the correct type Date of Siting DATATYPE DATE is self explana tory Method DATATYPE A11 is the siting method The possible
76. okupTable used by GR WATER Identification of boreholes dug wells and protected springs Today no standardized way of giving a location a unique number exists The various donor organizations and drilling operators keep their own numbering systems Therefore a national groundwater database should be able to assign one single and unique identification of each individual location As the Census Department operates a number system covering DISTRICT COUNTY SUBCOUNTY PARISH and ENUMERATION The proposed unique identification code should be as follows jejejje sjejs District code County code Subcounty code Parish code s Serial No On basis of the Census data files a database covering all locations in Uganda should be formed When assigning a number to a location for a borehole a dug well or a protected spring only location numbers which are found in this database should be accepted AII necessary location names will be found in this database and therefore they will not have to be stored within the groundwater database Annex Report Volume 2 WAP Doc 011 Final ry 3 4 a Uganda Water Action Plan Page 3 5 Directorate of Water Development 10 The structure of the location database will be as shown below Field Name Field Type Description Number N National ID No Dname A25 District Name Ccname A25 County Name Ssname A25 SubCounty Name Pname A25 Par
77. pment Annex 10 RodDiameter Pumping rod diameter DepthToBedrock N OverallGeologicalSetting A25 OtherInformation M240 Structure for Borehole diameters BOREDIAM Field Name Field Type Id national Ne Identification SerialNo S From N Depth from TO N Depth to a Diameter N Diameter in mn Structure for information on Filter slot sizes FILTSLOT Field Name Id national SerialNo From To Diameter Field Type N Identification S N Depth from N Depth to N Diameter in mm Structure for information on Yield test YIELDTST Field Name Id national SerialNo DateOfTest Duration TestType Transmissivity SpecificCapacity DischargeDuringTesting StaticWaterLevel StaticWaterLevelDate Hydrofracturing HydrofracturingDate Field Type S P Structure for information on Geology GEOLOGY Field Name eu am Ub ap om uu uum ow oD Id national Field Type ap aus JUD COND amp aw p Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan Directorate of Water Development SerialNo LithologyFrom LithologyTo Description Page 3 15 Annex 10 S N Depth from N Depth to A50 Description of lithology free text Structure for information on Hydrogeology HYDROGEO Field Name Id national SerialNo Depth Type Yield Fiel
78. pth 45 Organisation F1 Casing well ring diameter 152 4 mm Length 27 m Bottom of c w lining 5 27 5 9 1 Borehole sealing F1 Development of filters F1 Borehole well diameter Filter slot size amp intervals From From To Diameter m Spring Height x Width m H No of spring outlets 1 of 36 J F2 Quit 73 Up F4 Down Ctri PgDn Ctri PgUp DWD Figure 9 Second screen image of the main table in the database Completion date DATATYPE DATE is self explana tory Total depth DATATYPE N is the depth in metres Organisation DATATYPE A10 is the name of the organisation responsible for the construction By pressing F1 the possible organisations are listed Choose one by moving the cursor and press F2 Casing well ring diameter DATATYPE N is given in mm Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan Page 18 Directorate of Water Development Annex 11 Length DATATYPE N is the length of the casing e weii ring in metres Bottom of c w lining DATATYPE N is given in metres Borehole sealing DATATYPE A16 holds informa tion on the sealing material used Press F1 for LookUp help Development of filters DATATYPE A16 holds information on the borehole filter material x used Press F1 for LookUp help The two boxes with pink fields differ from the ah rest of the fields on this screen They are related tables to the master t
79. ption m b g 1 From To From To MR EI From To Aquifer type yield and depth top of aquifer Depth m b g l Fracture Overburden Yield m h Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan Page 3 10 Directorate of Water Development Annex 10 3 1 6 Hydrochemical data The storage of hydrochemical data is important though water analyses are not part of the standard programme in several of the donor programmes It should be possible to store an unlimited number of chemical analyses to each location The parameters should not be limited to a predefined selection as the parameters of interest changes according to the geological conditions Below is shown a preliminary screen image of the hydrochemical part of the database The parameters shown are only meant as examples The parameters being entered by the dataentry operators should be checked against a lookup table to assure uniform input Date of sampling day month year Sampling method Pumping Air lift sampling Bucket For pump and air lift samples Discharge before sampling liter Turbidity O Temp time of sampling Conductivity N uS cm pH Tot alkalinity CaCO3 mg l Hardness mg l Calcium Ca mg l Magnesium Mg mg l Sodium Na mg l Potassium K mg l Carbonate CO mg l Bicarbonate HCO4 mg l Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Pl
80. quality of the water It is the intension that the system at a later stage will be extended with new facilities such as cost calculations drilling production rates project information etc 2 5 User profile The users of the system will primarily be the technical staff at DWD and to some extent also the management of DWD The users are assumed to have a basic knowledge to computers 2 6 Requirements to the development phase The DWD groundwater database will be developed in a prototype version This version will form the basis for the resulting database which will be finished during the WAP Phase II project The prototype serves several purposes i e to verify the extent and structure of the database to demonstrate and validate the functionality of the database Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan Page 2 4 Directorate of Water Development Annex 10 The prototype is developed in Paradox 4 5 UK version but it has not yet been decided whether the resulting system will be developed using this or other standard database software The DWD will provide a limited number of old borehole files converted into a paper format which fits the input requirements of the prototype All necessary conversions to the units used by the new system must have been performed prior to entering data into the database This conversion will form part of the quality assurance system which must be established
81. racture 36 Fracture 8 5 1 of 36 F2 Quit F3 Up Figure 11 Fourth screen image of the main table in the database Depth to bedrock DATATYPE N is given in meters ne gels Ov geol settings DATATYPE A50 is an overall description of the geology Press F1 for LookUp help You will find a number of standard texts describing the geology Drilling method DATATYPE A16 is self explana tory Press F1 for LookUp help The description of Lithology follows the same outline as described above for Borehole well diameters etc Press F4 to move to the pink fields From and To fields DATATYPE N given in meters describe the interval for which the description is valid Description DATATYPE A50 is a free format description of the lithology You can put in as many records to each borehole as necessary The records are sorted in ascending order accor ding to the value of From Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan Page 22 Directorate of Water Development Annex 11 Press F3 to return to the master table or F4 to go to Aquifer type depth and yield The information on Aquifer type depth and yield acts the same way as described for Lithology Depth DATATYPE N is the aquifer depth Type DATATYPE A10 holds the aquifer type Press F1 for LookUp help Yield DATATYPE N holds the actual yield in m3 hour You can put in as many records to each borehole t as necessary
82. ry operators An important aspect of data entry is quality control which must include not only a direct check of data transformation and entry errors but also a qualified assessment of the data value prior to entry It has e g been noted that some chemical data are grossly incorrect and the pre entry assessment must therefore ensure that such data are omitted from the database in order not to distort e g average calculations etc Quality control should be established at two levels 1 control of data transformation from various original documents to new standard formats including data quality assessment and ii check of data entry errors and omissions This quality control could be carried out by a qualified senior hydrogeologist Database maintenance should be a continuous process based on mandatory reports submitted by the individual implementors in the DWD prescribed database format Such reports should be carefully scrutinized by qualified professionals and if necessary queries requesting clarification addressed to the report submitter before data entry 1 4 Use of the groundwater database The database is intended to accommodate the groundwater information needs of internal DWD staff as well as requests from external bodies It is furthermore intended as a corner stone in a future groundwater management and monitoring system N M Annex Report Volume 2 WAP Doc 011 Final 5 0 Uganda Water Action Plan Page 1 9
83. s User friendliness How easy is it to get acquainted with the system for users without much computer experience Reusability 2 How much of the application is reusable for other purposes Integrity 5 The ability of the application to protect its data Efficiency 3 How fast is the system able to retrieve required information Annex Report Volume 2 WAP Doc 011 Final ANNEX 11 DWD GROUNDWATER DATABASE USER S MANUAL DWD Groundwater database User s manual April July 1994 1 Table of contents l Introductlon and objective i tie VA ew 2 System deacrlptiloh 6639 ois eS ive 3 How to start the program 22 2 2 2 22 22 222 2 5 2 7 4 Viewing and editing data 9 5v EXDOFCING Eso ae Vc CR SOA 33 5 ReDOFEUS 7 GIS eee ee eee ee ee ee en eee ee eee 41 8 ODCIONS EE we EV RU eee eee 44 9s QUIE 48 Annex A Questions and Answers EEEE 49 Uganda Water Action Plan Page Directorate of Water Development Annex 11 1 Introduction and objective Groundwater has played a significant role in domestic water supply in Uganda with construction of tubewells commencing in the early part of this century and lprivate drilling contrac tors in operation as early as in the mid 1920s Other drill ing activities have been
84. sent no guidelines as to what type of data should be recorded in relation to groundwater development activities and no requirements or procedures for reporting of such data to DWD Individual projects have established hard copy and few computerized formats which basically fulfil their own reporting and monitoring needs rather than the requirements of a national groundwater resources database It should be noted though that several projocts recently have approached DWD in order to establish database formats and that obvicusly there is a clearly expressed need for this As only a limited number of the ongoing programmes mairitain computerized databases there are very few considerations to be made in terms of compatibility of individual formats It has been recommended by several projects however that the new format be estaolished by vse of dBASE IV compatible software and combined with appropriate GIS software for production of maps Arc Info is the GIS software currently in use at the National Environmental Informat on Centre NEIC at the Biomass project in the Department of Forestry whereas UNICEF use AtlasGIS Annex Report Volume 2 WAP Doc OL 1 Final Q Uganda Water Action Plan mE Page L6 Directorate of Water Development un 9 1 3 Objectives and requirements 1 3 1 Objectives of the national groundwater database The objectives of establishing a national database is to organize and systematize all r
85. serve the following syntax dd mm yyyy i e a new date must be entered by stating the day number followed by a full stop then number of month followed by a full stop and finally the year As an example the following dates are correct 1 01 94 1 1 1994 31 10 83 Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan 3 mE Page 12 Directorate of Water Development 11 ll whereas the dates shown below are unacceptable i lst Jan 94 1 1 1994 31 10 84 29 2 1994 31 11 80 4 3 How to enter notes and comments In some displays e g in case of other infor mation it is possible to enter a comment in a memo box The box is fetched by pressing lt alt gt F5 after which it is possible to enter comments It is possible to write a text corres ponding to approximately 64 kB P Data Import Export Report Gis Options Quit Location and identification data Supervision gt Comment 1I1 4 Here it is possible to write a com a ment on the individual sampling When a comment is to be entered the cursor is placed in the comment field and th alt F5 keys are pressed whereupon this box for entering text will ap pear When the text is written is pr ssed and the amount of text for which there is room in the com ment field is shown on the display If you wish to make corrections you can re call the text box by pressing alt F5
86. tematic contents of the data fields 4 2 Hardware interface The system should be able to run on IBM PC s or true compatibles The possible future introduction of a network in DWD should be taken into consideration by the system developers 4 3 Software interface For thee time being no data on groundwater are computerized within DWD Up to now all files are kept in a paperbased database However a number of the drilling operators are maintaining databases to some extent The exchange of information from these databases should be taken into consideration Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan Page 5 1 Directorate of Water Development Annex 10 5 REQUIREMENTS TO THE PERFORMANCE OF THE SOFTWARE There no specific requirements to the performance of the software as regards response time at queries Response times at retrieving individual records in the database shou J reasonable Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan Page 6 1 Directorate of Water Development Annex 10 6 QUALITY FACTORS Quality factors 1 Not critical 2 Not so critical 3 Important 4 Very important 5 Most important Reliability 5 The probability of having the system running for a given period without errors Maintenance 3 How long time does it take to find and correct errors Possibility of expansion 5 How easy is it to expand the system with new feature
87. ter mm Pumping rod material Fl Diameter mm Yield test flow and water level data Date Durat Test type Transmiss Spec Capaci 1 12 90 0 33 Air lift test F1 Discharge Static Vater Level Date HydrFrDate 1 12 90 1 of 36 LI F2 Quit F3 Up F4 Down Ctri PgDn Ctrl PgUp DWO Figure 10 Third screen image of the main table in the database Casing well ring material DATATYPE A16 has LookUp help Press F1 for help Type of pump DATATYPE A16 has LookUp help Press F1 for help Date of installation DATATYPE D is self ex planatory Organisation DATATYPE A10 holds the name of the organisation responsible for the installa tion Press F1 for help Name of pump DATATYPE A20 is a free format field Input is converted to capitals to assure some degree of uniform input Capacity DATATYPE N is the pump capacity in m3 hour Intake depth DATATYPE N is given in meters 4 1 Riser pipe material DATATYPE A16 holds infor mation on the material used Press F1 for help Pumping rod material DATATYPE A16 holds infor mation on the material used Press F1 for help The Diameters DATATYPES N are given in mm Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan Page 20 Directorate of Water Development Annex 1 M The last part of this page holds information on yield tests The functionality is as described for Borehole well diam
88. ter medium to be used the screen the printer or transport to a file If a mouse is used a click must be made opposite the medium by which the print out is to take place and thereupon the OK key must be clicked If the keyboard is used the dot is moved about by means of the up arrow key and the down arrow key and subsequently the Tab key to highlight one of the keys OK or Exit and thereupon the Return key It is also possible to press the Alt key initial letter in this case e g lt alt gt 0 or lt alt gt A If the OK is selected a new choice of print medium has been made if Exit is chosen the print medium is the same as when the dialogue box was fetched Presentation of data In order to get as much information as possible from the data base some standard reports have been built in which makes it possible very Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan Directorate of Water Development Page 6 Annex 11 quickly to carry out some standard reporting of data Documentation is available both in the form of tables and as graphical presentation Search routine As mentioned above DWD has a number of built in standard tools to illustrate the condition of the groundwater However it may at times be necessary to carry out special analyses of data and groups of data into which it is not imme diately possible to build routines in the soft ware Therefore it is made possible to carry out
89. ter resources management context Therefore the possibilities for data exchange with these databases have been assessed The three databases are the climate CLICOM database at the Meteorological Department in Kampala the surface water database HYDATA operated by the Water Resources Department in Entebbe the project database operated by Ministry of Finance and Economic Planning 1 5 2 Exchange of data with external databases The Meteorological Department is using a PC software CLICOM which is developed in USA The database reportedly contains information on monthly rainfall from some 150 Stations scattered all over Uganda According to the documentation the software is able to exchange data in LOTUS 1 2 3 format but due to hardware problems this has not been verified yet apium Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan 1 10 Directorate of Water Development B Annex 9 The database operated by the Water Resources Department contains information on the water levels rating curves and discharges Data is stored in the database system HY DATA developed by Institute of Hydrology Wallingford UK The database system contains a number of facilities for data processing and quality assurance which meet most of the present requirements of the users The facilities for data exchange from HYDATA to other systems are limited However a programme file already installed has been ident
90. terial E PVC Mildstee Concrete ___ Bricks __ Other Type of pump installation _ Submersible pump _ Centrifugal pump __ Handpump Bucket Date of pump installation day month year Name of pump Pump capacity Pump installation intake depth m 6 5 1 Riser pipe material Galvanized iron Stainless steel Y Riser pipe diameter Pumping rod material Galvanized iron Stainless steel Wire Pumping rod diameter P m me il P h MMQ M XM M B MY A Q M E Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan Page 3 9 Directorate of Water Development Annex 10 3 1 5 Geological and hydrogeological data This part of the database should contain information on the geological and hydrogeological conditions at the location The field OVERALL GEOLOGICAL SETTING should contain a short description in words No checks of the contents should be performed A number of records should be available to describe the lithology in various depth intervals In the hydrogeological part the database should contain information on overburden in which depth is it found and depths and yields of possible fractures Depth to bedrock mb g l Overall geological setting Lithology From To Descri
91. the limitations of the system is stated here Chapter 3 contains a more thorough description of the elements which are supposed to be covered by the system Chapter 4 describes the external framework to other existing and future systems which will exchange information with the groundwater database Annex Report Volume 2 WAP Doc 011 Final Sy Uganda Water Action Plan Page 2 1 Directorate of Water Development Annex 10 2 GENERAL DESCRIPTION The DWD groundwater database is going to contain various types of information on the Uganda groundwater The information will come from various sources i e DWD itself the main drilling operators such as RUWASA Unicef SWIP WaterAid etc Department of Hydrology Entebbe under DWD Meteorological Department in Kampala Census Department The groundwater database should be capable of handling data on s boreholes dug wells protected springs The information of each individual point should cover Identification and location data Construction data Installation data Geological and hydrogeological data s Hydrochemical data Yield test flow and water level data Other information textual description The system developers are aware of the fact that not all of this information will be available and the system should accept partial input However as the system later on should be capable of presenting information on maps the location of the poi
92. u a curtain is shown where you can choose the type of data which should be modified viewed etc If you want to edit or add data to the central groundwater database GR WATER Identification and location data are chosen Now a screen image will appear on screen fig 6 showing the first part of the information on a water point The screen is divided into two levels which in this example gives the data from the Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan Page 10 Directorate of Water Development Annies master record blue fields with white letters and or numbers and the related detail records pink fields with white letters and or numbers On top of some of the screen images two red fields may appear These are DisplayOnly fields which cannot be changed Data Import Export Report GIS Options Quit Location and identification data 1 4 Location No 75703 1 Waterpoint No 1 Waterpoint NAMUNGALWE H CENTRE Project No 004033 Type of waterpoint Borehole Date of Siting Method F1 Siting organisation FV Approx discharge spring L min Coordinates in UTM or GEOGRAPHIC U G G UTM Zone 36 East North South Geogr DD MM SS Long 33 30 00 Lat 00 44 00 N N S Altitude Waterpoint owner Private Communal Institutional Waterpoint use Domestic Irrigation Livestock Industry Waterpoint abandoned due t
93. unctioning as well a tool in the daily work as a system for creating over views The developers are aware that there is an angois development of turnkey groundwater database systems However since none of those which were assessed during January and February 1994 were able to store the required information it was decided to develop this system It was found that it was important to begin the process of storing the vast amounts of waterpoint information in this phase If a standard system at a later stage proves to fulfil the requirements it should be considered to convert the data to such a system This will of course the mainte nance of the database systen po Annex Report Volume 2 _ WAP Doc 011 Final Uganda Water Action Plan Page 3 Directorate of Water Development Annex 11 2 System description The overall design has been outlined below 5 25 gt 2 25 2 2 2 gt lt Data input schemes me 2 2 2 2 2 2 25 26 36 Water level time series CUM GU UND Gum ae MAD CRM cee em Cum ee ow ee uude ee oe oe uum ae 2 2 groundwater database ttti amp 5 22 gt Meteorological data precipitation 25
94. y KOLE No 1 Subcounty ABOKE No 1 Parish OGWANGACUMA 23 1 4 21 Organisations Data Export Report GIS Options Quit Organisations Os e 4 1 5 9P F2 Quit F3 Up F4 Down Ctrl Pgdn Ctrl PgUp DWO Figure 27 Screen image of the organisations _ table Organisations DWD OTHER RUWASA SWIR Annex Report Volume 2 2 WAP Doc 011 Final Uganda Water Action Plan Page 33 Directorate of Water Development Annex 11 Xs 5 Exporting data In order to obtain maximum information from the data base a function has been built in which enables you to carry out an optional search in the data base and export the selected data to another type of software That the search is optional means that the user may choose the files in which to search the variables to be found how the relations between the different files should be the conditions which the se lected data must fulfil and the format in which they are to be exported The figure shows the display appearing when Export is selected in the main menu The figure shows a dialogue box with the records in which searches may be made immediately Opposite each of the 12 file names is a box in which you must write an X if you wish to include the file in the following search The X is entered by placing the cursor in the required box and by pressing any ke
95. y or by clicking on the box by means of the mouse An X is removed by pres sing clicking once more Data Export Report GIS Options Quit 966664 0066666600 0060 06665 227 HR Un X Groundwater DB Location table diam Filter diam t Yield tests Eu J Geology m SU Hydrology 2 224 12222221212 11212222 22 40 eese sese ete shoes pester sorties etos sy eecscoccescescccenpssccceccosnergsssessococsescosssreeesensyvevesersgcssuessrgscsesesesessesceswrececegesasases se Figure 28 List of records constituting the searches Annex Report Volume 2 WAP Doc 011 Final Uganda Water Action Plan Directorate of Water Development Page 34 Annex 11 Annex Report Volume 2 You mark the individual records by moving the cursor to the box opposite the individual record and pressing the space bar In the same manner a mark is removed by moving the cursor to the box with the X and pressing the space bar In the example shown above the Groundwater table and the Location table have been marked If the OK key is used to quit a new display will show a list of existing annual data bases Here the annual databases which are to be included in the search can be selected The selection is ended by pressing the OK key The Groundwater table and the Location ta

Download Pdf Manuals

Related Search

Related Contents

PYLE Audio PSWLE82 User's Manual  取扱説明書 - ネットワークジャパン  SEPT15N plaquette - AFI Distribution  ガソリン吹きこぼれに関する実態調査報告書  TA18 active subwoofer user manual  Quick start guide  FHD552-X LCD-Bildschirm  9191 Monitor - Hewlett  Sony DSC-W50/B Marketing Specifications  User InstrUctIon ManUal talon™ self retractIng  

Copyright © All rights reserved. Failed to retrieve file