Accessing the Database and retrieving data

1. Accessing the Database and retrieving data WATER SUPPLY DATABASE (WSDB) ACCESS & DATA RETRIEVAL Joshua Mpairwe

2. Objective • How do I access the database? • How do I get the update forms? • How do I get sources with wrong coordinates? • How do I get indicator trends of a region? • How do I get the standard reports? • How do I get raw data of a region? • How do I get Maps? • How do I get Administrative units? Joshua Mpairwe

3. How do I access the database? • It can be accessed through the internet with the address www.mwe.go.ug • Here look for “useful Resources” • Click “The Water Supply Database” • Enter your login details and gain access to the database NB: • Your user type is “National Viewer” • The user type is limited to only viewing the data BUT can NOT EDIT, DELETE or ADD any data to the database. • Contact MIS for login details Joshua Mpairwe

4. How do I get the update forms? • Click “Update Forms” • Click “Form 4: Point Water Source (Print)” • Use the filters to select the sub-county of your choice and the click “GO” NB: • You can export to excel or print it directly in the standard format • WSDB has only got “DROPDOWN LIST” filters which work from:- • Left to Right • Top to Bottom

5. Update Form Example

6. How do I get sources with wrong coordinates? • Click “Update Forms” • Click “Wrong Coordinates (Point Sources)” • Use the filters to select the administrative unit of your choice then click “Go” NB: • The report tells you which coordinate is wrong (whether Easting or Northing) • You can export the list to excel

7. How I get standard reports?

8. Report features • Reportnumbers • Filter selection • Reportheaders Joshua Mpairwe

9. How do I get indicator trends of a region? • Click “View Data”. • Look for “Trend Analysis Reports”; the under these words are 3 sub-links namely:- • National Trend Analysis This report shows the national indicator trends since 2010. • District Trend Analysis This report show the District indicator trends since 2010 • Sub-county Trend Analysis This report shows the Sub-county indicator trends since 2010 • Click on the report of your choice; then use the filters to generate the trend report of you choice NB: • You can “Export to Excel” & “Print” these reports

10. National Trend Analysis Report • Click “View Data” • Click “National Trend Analysis” • Select a down time of your choice • Click “GO” to generate report NB: • You can “Export to Excel” & “Print” these reports

11. District Trend Analysis Report • Click “View Data” • Click “District Trend Analysis” • Select an Indicator from the drop down list then click “GO” to generate report NB: • You can “Export to Excel” & “Print” these reports

12. Sub-county Trend Analysis Report • Click “View Data” • Click “Sub-county Trend Analysis” • First Select region from which the sub-county(s) whose trends you would like to view • Second select the an Indicator from the drop down list then click “GO” to generate report NB: • You can “Export to Excel” & “Print” these reports

13. How I get raw data of a region? • Click “View Data”? • Click • Form 1: Records List Report • This has all the record fields/information • Form 1: Records List Report (Mini) • This has only the key fields/information • Form 2: Records List Report • This has all the record fields/information of form 2

14. How do I get Administrative? • Click “View Data”? • Click • List of Administrative Units • List of Mother District • List of Mother Admin • List of All Surface Area Figures • List of Municipal Councils • List of Town Boards • List of Town Councils

15. How do I get the maps? • Click “View Maps”? • Click • District Shade Maps