1 / 15

Accessing the Database and retrieving data

Accessing the Database and retrieving data. WATER SUPPLY DATABASE (WSDB) ACCESS & DATA RETRIEVAL. 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?

jett
Télécharger la présentation

Accessing the Database and retrieving data

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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

More Related