Home

Partners for Water and Sanitation Note on project reports

Contents

1. Choose GRASS installation path GISBASE Lookin C Program Files Quantum GIS grass 7OO09 E E My Compu E AUTHORS 7 bin D rose4769 bwidget CHANGES config COPYING E locations gml modules REQUIREMENTS html Directory Files of type Directories This should prevent the message appearing when the program is subsequently launched However if Cancel is selected the program will operate correctly but the message will appear on each launch Note GRASS is free software and does provide some additional functions As knowledge increases these functions it should be investigated 8 3 Main Terminology Project qgs file This is an overall workspace that holds the views layout and symbology of the layers It does F tat vew tayer settings Pugns not contain any data all data is held on the associated ot i W g k i a Open Project Ctrl 0 Vector Layers If an AutoCAD analogy is used this is the Open Recent Projects ara paperspace with all the modelspace data held on the sero Gie x 2 J Save Project As Ctrl Shift S A associated Vector Layers Many Project files can access a i seas inage chl i j HE Ele single data layer meaning the Vector Layer only exists once mcx ome providing a single data file with the Asset or Mapping data O ext Greg Vector Layer shp file This file contains the data associated with either in Point Polyline or
2. Scroll down to setup Partners for Water and Sanitation Page 49 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 You will come to this page Here use the round centre button to move to the fourth tab called Location You can t see Location on the screen so you need to keep going to the right Then select the third tab called Location and press the enter button Partners for Water and Sanitation Page 50 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 GPS ZZ This is the Location tab When you get here scroll down to the first box Location Format When you have selected this box press the Enter button Partners for Water and Sanitation January 2010 Page 51 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 GPS W P4 A list of options will pop up Choose the Units you want AAWSA AutoCAD maps appear to be in UTM UPS units When you have selected it press enter Then use the Quit button to go back to the main pages bi A Cute b Tai UTM Ui Partners for Water and Sanitation Page 52 January 2010 Partners for Wate
3. Partners for Water and Sanitation Note on project reports The following report has been prepared by Partners for Water and Sanitation in response to a project Terms of Reference The content of the report is based on the opinion of the author s and does not necessarily represent the opinions of the wider PfWS partnership or the project funders Any extracts from the report should only be used with prior permission of the report author s Partners for Water and Sanitation July 2010 Partners for Water and Sanitation Implementation of GIS Asset Inventory in the Addis Ababa Water and Sewerage Authority AAWSA Ethiopia TECHNICAL REPORT Submitted by Matthew Rose Atkins Ltd UK Alex Nash Atkins Ltd UK January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 Contents 1 Executive SUMINANY siiiecicsntccctcscscasccsncssccinccesseseetnctaseciseneecacsncawaconceeseacantunnaonces 3 2 DIMER O CU tety Lo n NAAANINAG 5 2 1 TTS Of Referen CE GANI 5 2 2 The Addis Ababa Water and Sewerage Authority AAWSA Sewerage I Oasis nana aaaKaR a E E NAMANA Aa na NASA NON NAL GA Mana BAGO LANA DESA kaka BEAN GALA 6 2 3 Current AAWSA GIS Asset Inventory Status 77 maasasusanawwananananasannn 8 2 4 AAWSA Capacity Baasa naa Fan aha ANNA Ka AE NAAN Na NANANG KANG sassetseceedexidensscucpeces 9 20 AAWSA PING maa
4. the sewerage network asset database by transferring the existing data that are _in AutoCAD Sewer CAD and Excel sheets Module Management 1 Information Alex Matthew 12 00 12 30 Discussions on the trat sferability i data ane the cor earns of and _manage user triendly sewerage network asset database Module Management 1 Information Alex Matthew 12 30 13 30 LUNCH BREAK 13 30 15 30 Praclical Technical process Unit demenstrations_in two groups_on_the _use_of CADs and _other options for ADB Module 2 Data collection in the field Alex Matthew Ato Gemechis 15 30 16 00 COFFEE TEA BREAK Partners for Water and Sanitation January 2010 Page 30 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 Time Activities Responsible person Facilitator s 16 30 17 30 Practical Technical support in Alex Matthew Ato Gemechis two of the offices IT sub process Unit Contd on these of CADs and_other_options_for ADB development and Module 2 Data collection in the field Day 4 8 30 9 00 Registration AAWSA Saturday 9 00 10 00 Share UK team s own ao experience of the GIS and Matthew 2010 review the capacity of the Meet at head office and go to site for data collection training and use of
5. 250 250 329 ISOP 19000 2 389 01ER a sEW 390 D1ER FOUL 0 OER o ojcirc 400 soo 87 2 isop 190001 3 2337 01ET05aa SEW 2352 01ET05A Fout o O ETO5 o ojere 200 200 41 isop 190001 4 872 01ET11 a SEW 875 D1ET11 FOUL o oveTi o ajciRc 200 200 57 5 isop 190001 5 871 01FM03 a SEW 874 01FM03 FOUL o 0 FMO3 o ajciRc 200 200 45 1 ISOP 130001 6 904 01FNO3 a SEW 911 O1FNO3 FOUL o O FN03 o olcire 200 200 88 6 ISOP 190001 A 899 01FN07 a SEW 906 01FNO7 FOUL o O FNO07 o 0 cIRC 200 200 12 8 ISOP 190001 8 929 O1FNO8 a SEW 937 01FN08 FOUL o 0 FNOB o ojere 200 200 118 8 IS0P 190001 9 917 01FN10 a SEW 924 DIFN10 FOUL o 0 FNIO o ajciRc 200 200 110 7 isop 190001 10 935 01FN11 a SEw 943 01FN11 FOUL o O EN11 o ocre 200 200 110 7i80P 190001 11 892 01FN2B a SEW 896 01FN2B FOUL o O FN02 o aicirc 200 200 82 8 ISOP 190001 12 1006 01GJ03 a SEW 1014 016J03 FOUL o O GJ03 o ajciRc 200 200 34 5 isop 190001 13 1016 016J13 a SEW 1024 016J13 FOUL o 0 6413 o olere 200 200 115 2 ISOP 190001 14 1529 016Ya SEW 1542 016Y FOUL o oloy o ajcikc soo soo 16 5 asa 190001 15 1539 01Hc a SEW 1552 01HC FOUL o O HC o ojere soo 400 51 2 AsB 190001 16 1020 01HC01 a SEW 1028 O1HCO1 FOUL o 0 O1HC o ajciRc 200 200 98 7 ISOP 190001 17 1541 01HD a SEW 1554 01HD FOUL o O HD o ajciRc soo 400 35 4 asa 180001 18 1980 01HS a 5Ew 1995 01H5 FOUL o o Hs o ojere soo soo 771 asa 190001 19 113
6. Converting CAD information to GIS format and using GIS Partners for Water and Sanitation Page 18 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 5 Next Steps 5 1 Software updates and virus protection All computers should be brought up to date using the windows downloads which are freely available on the Microsoft website Viruses should not be too difficult to control Free anti virus software is available and this should be applied In order to apply this software and to get regular updates the computers will need to be regularly connected to the internet While it might be too costly to connect all computers to the internet mobile broadband facilities now exist in Ethiopia and if the I T department were to purchase a mobile USB modem then this device would be shared on a rotational basis for providing both windows and anti virus software updates for each machine once per month for example This is a high priority investment of about 5400 If windows viruses continue to plague the authority then consideration could be given to either purchasing commercial anti virus software or moving to a different platform e g Linux One machine in each branch could be converted to Linux and the GIS and data could be placed on this machine where it would be safer This would involve no cost but some effort and skill Priority
7. Gps GRASS Graticules Interpolation MapServer Export Quick Print Spit OGR Converter Python Console Raster Layers scans jpegs etc can be imported as Layers into QGIS using the georeferencer plugin Before starting identify at least three points on the scanned map where the coordinates are known get coords from CAD backgrounds For example major road junctions To get the best possible match choose three points which are to the extents of the scanned image Open the scanned image and add the three points with the coordinates Select Create and Load to Partners for Water and Sanitation January 2010 Page 41 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 Erter E and Y coordinates macs correnpond ath the cmiected part an the mago Aami Gk the button math coe of opened ad then hes corresponding point on map carves of QGIS ta Hf in coorcinaber of thet post 4510 N 2901068 fem wen Coren come PA Select Create and Load to bring the i image into the map Note move the layers drag and drop to order the view and bring the sewers to the top 8 5 The Interface GUI See QGIS Manual for general instructions with using Quantum GIS One important area is ensuring that layers created and the overall project is created with the correct coordinate s
8. aaa ng the hydraulie Attempted installation of GIS on Head Office Engineers machine learning session with all engineers Matthew Alex 12 30 13 30 LUNCH BREAK Partners for Water and Sanitation January 2010 Page 32 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 Time Activities Responsible person Facilitator s 13 30 15 30 High level Group Work Exercise that enhance the AAWSA staffs Matthew Alex AAWSA IT skill 1 4 methods and procedures for uploading data to from AutoCAD and Sewer CAD as well as other software Continued attempts to install GIS on IT machines successful Investigation of billing system 15 30 16 00 Coffee Tea Break 16 30 17 30 Hightevel Group Work Exercise that enhance the AAWSA staffs metheds and _precedures for Matthew Alex uploading data to from AuteCAD and Sewer CAD as well as other Visit to branch office to attempt installation of GIS failed due to viruses and out of date software Collection of branch data Working on processing of branch CAD data into GIS format using manual scripting Day 7 amp 8 13 14 January 2010 Date Time Activities Responsible person Facilitator s Day 7 8 30 9 00 Registration AAWSA AAWSA Wednes day 13 9 00 10 30 Field visit to Kali
9. given and actions agreed during the training visit Resource estimate It is anticipated that this support can be carried out by one expert with relevant skilis and experience in asset database development applications and management ideally in relation to sewerage systems If considered appropriate a team of two people with complimentary skills can be considered for carrying out the support Input from the Partners for Water and Sanitation UK expert s is expected to comprise the following inputs excluding travel time Initial support 2 days preparation in the UK Up to 13 days in Ethiopia for training including a weekend 3 days for writing the draft report 2 days for writing the final report 4 days for ongoing remote support Partners for Water and Sanitation Page 27 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 The timing required to deliver formal training sessions and support coaching will be identified and agreed through negotiation between AAWSA and the UK expert s considering the range of training sessions offered and relevance to AAWSA s circumstances Further support may be likely but this is subject to discussion and agreement between those concerned Dependencies Timely feedback on reports issued and effective communication with AAWSA will be crucial to ensure t
10. with support from UK partner s South West Water and Mouchel has been offering technical advice and training to staff of the Addis Ababa Water and Sewerage Authority AAWSA in Ethiopia This support has to date focused on asset databases sewerage network design and options for effluent reuse In March 2009 during a support visit by Trevor Nott of South West Water AAWSA staff outlined a procedure for the collection and storage of asset data that will enable AAWSA to develop and maintain a quality data set for the future needs of Addis Ababa s sewerage network Available data from AAWSA such as plans of the city s sewer layout pipe gradient and materials depth diameter and length for trunk sewers types of manholes connected population etc is currently held in Sewer CAD AutoCAD and spreadsheets or archived in hard copy 2 From the Partners for Water and Sanitation website http www partnersforwater org Partners for Water and Sanitation Page 5 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 AAWSA s Head Office and 8 operational branch offices in Addis are responsible for the collection and management of liquid wastes Although all the branch offices are providing sewerage disposal service by trucks only 5 out of the total 8 branch offices are giving additional sewerage network system services AAWSA would like
11. Clearly both a demonstrated sustained effort to collect sewerage network asset data and a function information management system should be a precondition for further PfWS assistance The purpose of the capacity building is not only to increase individual skills but also to strengthen the organisational capacity and effectiveness Asset information should be collected in a standard format There are existing forms for connection boxes and septic tank emptying however these are lacking in some details required to develop and improve the asset data During the course of the workshops improved survey cards were developed both for new connections and the surveying of existing assets These are show below Partners for Water and Sanitation Page 14 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 New connection data New Sewerage Connection Data Card Addis Ababa Water and Sewerage Authority Manhole data GIS Point Data Collection Form Addis Ababa Water and Sewerage Authority or water contract number If customer house Road Name curcie Partners for Water and Sanitation Page 15 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 The data conversion process was also described in diagrammatic form although a detailed des
12. Database for the billing system The I T staff involved are well skilled in database administration SQL and have been running the billing system server since it was installed in 2001 They have also been running the finance system on an HP 3000 series computer which we think dates back to 1984 9 Although none of the branch computers are connected to the head office all of the sewerage department head office computers are stand alone the I T department does run a small LAN for the billing system This LAN is carefully protected from viruses by a refusal to extend the LAN and server access to computers other than those required for billing The finance system is a mainframe with 5 dedicated terminals and apparently no one knows how to get data in a digital format out of it let alone connect to it AAWSA computers are currently at various states of the Microsoft Windows operating system The installation of new software such as GIS usually requires up to date versions of windows During the installation we repeatedly encountered errors due to missing files and out of date software on the computers In addition to out of date software the authority computers are dangerously exposed to viruses in fact many computers contain viruses These viruses can damage or totally destroy data but just as importantly they cause a serious productivity loss The viruses prevent users from using the computers by freezing them or requiring the computer
13. GPS training 10 00 10 30 Discuss on the GIS experience sharing Matthew On site exercise data collection and GPS training 10 30 11 00 Coffee Tea Break 11 00 12 00 Conducttraining oresent_onthe use of GIS for the sewerage network asset database On site exercise data collection and GPS training 12 00 12 30 Discussions on the use of GIS On site exercise data collection and GPS training 12 30 13 30 13 30 15 30 Presentintroduce procedures and techniques to set up a computer based asset data base system On site exercise data collection and GPS training 15 30 16 00 Coffee Tea Break 16 30 4430 Presentintroduce proecedures 19 00 and techniques to set up a Alex Matthew computer based asset data base Matthew system Cont d Downloading and testing of GIS related software Day 5 amp 6 11 12 January 2010 Date Time Activities Responsible person Facilitator s Day 5 8 30 9 00 Registration AAWSA AAWSA Monday Partners for Water and Sanitation Page 31 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 Time Date Activities Responsible person Facilitator s 11 January 2010 9 00 10 30 Conduct practical demenstratioas en hew _te coll
14. Polygon objects Note it is possible to mix objects types in a Layer but this is not recommended The data in Vector Layers is held in a spreadsheet type format called Attribute Table it is important to populate the data in the correct fields Symbology This term refers to the how you want the data to display in the Project It can refer to symbol styles lines points etc The symbology is saved in the Project Not on the Vector Layer Partners for Water and Sanitation Page 37 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 8 4 Importing Data GIS Systems use three types of object data e Points e Lines e Polygons Before importing data consider which type of data you wish to convert it is best practice to keep a single object type on each layer ie don t mix line point polygon objects 8 4 1 AutoCAD In AutoCad 1 On the command line enter WBLOCK 2 In the Write Block Dialog box under source click Objects 3 Under Base Point select the base point for the block you wish to save 0 0 4 Under objects select the select Objects button 5 Select all the objects to include in the WBLOCK New Dxf File 6 Press ENTER to return to the dialog box 7 Under Objects select the Select Objects button 8 Under destination in the file name box enter the name for the WBLOCK 9 In the Location Box enter th
15. We discussed this at length during the training and provided worked examples and developed a system for one of the branches Nifas silk Lafto branch e Correct file management systems and structure need to be put in place and enforced across all braches and the head office We suggest a structure in this report e Software updates and virus protection should be implemented immediately under the auspices of the I T department who are most qualified to carry this out We strong suggest a CDM USB broadband connection modem is purchased from ETC and used to check for anti virus software updates for all machines regularly The modem should also be used to download standard windows software updates and patches An Information Technology department without hi speed access to the internet s information and resources is simply not an option it is a contradiction in terms e Branch sewerage staff should endeavour to hold monthly meeting for data transfer and to share the growing body of GIS knowledge Following these meetings best practice could be agreed and a set of written procedures developed to assist technical staff and achieve consistency of approach e Implementation of GIS as the asset inventory replacing CAD and SewerCAD as the primary repository of data We worked on this during the mission and installed Quantum GIS on the head office sewer engineer s machine carrying out this exercise with authority I T staff so that these staff can roll
16. also selected because it uses standard GIS forms such as shape shp and ESRI files which are common across commercial GIS packages such as Maplnfo and ArcVIEW The authority had numerous copies of unofficial versions of ArcVIEW however installing these presented some problems and we considered the use of software which had been tampered with to be a risky long term strategy for holding important asset information In addition to installing QGIS on the head office engineer s computer we also installed it on two of the I T department machines with I T staff so that they should become experienced in rolling it out to the branches We attempted to roll GIS out to one of the branches but failed to do so because the computers were both ridden with viruses and did not have the appropriate Microsoft updates installed Without any internet access for ether the branch of the I T department there appeared to be no prospect of getting these updates installed Partners for Water and Sanitation Page 17 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 Workshops were held with the AAWSA staff to discuss the data types fields that should be held within the GIS to suit the AAWSA sewerage system 4 3 Bulk Conversion of CAD data to GIS format Learning how to carry out the conversion of CAD data to GIS was one of the main objectives of the AAWS
17. changes Partners for Water and Sanitation Page 46 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 9 Appendix D Using the hand held GPS The authority GPS devices can be used to obtain coordinates for assets which will allow the assets to be reliably located in the GIS or AutoCAD The device is shown in the image below ie Fe This is the on off button The page button moves between the pages of the GPS The most useful page for surveying is the one show here Altitude is shown here This is not very accurate X and Y coordinate accuracy is show here This is the X coordinate This is the Y coordinate These are the grid units UTM Partners for Water and Sanitation Page 47 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 To change the grid units you need to press the menu button here The page menu pops up but you need to press the menu button again to get to the main menu Partners for Water and Sanitation Page 48 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 The main menu is a list of options Use the round button in the middle here to select different items
18. continued through the training guiding the process From the discussions we also understood that the participants main expectation was to learn how to convert CAD data to GIS and then how to carry out Sewer modelling We repeatedly stressed that unless proper systems were put in place to manage the information they had no useful modelling asset inventory or GIS work would be able to be done Partners for Water and Sanitation Page 10 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 3 2 Workshops Most of the training took the form of workshops where we discussed ways of doing this with AAWSA staff and tried to determine management improvements together Process diagrams were drawn with the assistance of AAWSA staff The GIS system was installed and some CAD data converted together each trainee attempting to carry out the processes alone GPS training was also carried out where staff learned to use the authority GPS devices and record information Information gathering forms were developed and approved by the staff We also held a workshop on the use of Google maps as a source of satellite photos for planning and mapping and discussed how this could be brought into GIS and geo referenced The most recent aerial photography of Addis Ababa appeared to have been done for the master planning project in around 1994 3 3 Presentatio
19. to be able to store access retrieve and analyse data in such a way that it can be used in the design of new sewers to serve future developments provide details to developers for connections and enable them to undertake survey design works and costing Other stakeholders including Addis Ababa Roads Authority the Ethiopian Telecommunications Corporations and Sub City Administration also need access to this data Neither they nor AAWSA s branch offices are electronically networked to AAWSA s Head Office AAWSA is looking for new techniques to store access retrieve and analyse data especially enabling the customer s side of the business Moreover the currently available data in Sewer CAD AutoCAD and spreadsheets is held independently with no system for importing exporting data between the systems A robust database system in AAWSA s Head Office and in the 5 branch offices overseeing sewer networks that can also be accessed by relevant stakeholders and gradually rolled out to the remaining 3 branches is considered of paramount importance AAWSA staff are therefore seeking external expertise to help them set up and maintain such a database either by building on their existing knowledge and systems of GIS AutoCAD and Sewer CAD or by proposing alternative user friendly software that is mutually agreed as an appropriate solution 2 2 The Addis Ababa Water and Sewerage Authority AAWSA Sewerage Service From a previous PfW
20. waypoint and press enter We need to edit this waypoint to putin the coordinates that we want to go to Partners for Water and Sanitation Page 56 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 After you press the enter button on the waypoint you can edit it Use the round button to scroll down to the location box which is here Pr ss enter when you are on this box and then use the round button to select each number and change it to the X and Y coordinate that you are trying to find Partners for Water and Sanitation Page 57 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 Editing the waypoint looks like this Use the round button in the middle to change the numbers to the ones you want When you are done press enter to get out of the editing mode Finally press the page button until you come to the compass page which should now guide you to your active goto Partners for Water and Sanitation January 2010 Page 58 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 Navigating to your active goto can be done using the page show Remember The comp
21. 10 Partners for Water and Sanitation January 2010 Page 24 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 6 Appendix A Terms of Reference Project Title Asset Management Database development support to Addis Ababa Water and Sewerage Authority Ethiopia Justification Partners for Water and Sanitation with support from UK partners South West Water and Mouchel has been offering technical advice and training to staff of the Addis Ababa Water and Sewerage Authority AAWSA in Ethiopia This support has to date focused on asset databases sewerage network design and options for effluent reuse In March 2009 during a support visit by Trevor Nott of South West Water AAWSA staff outlined a procedure for the collection and storage of asset data that will enable AAWSA to develop and maintain a quality data set for the future needs of Addis Ababa s sewerage network Available data from AAWSA such as plans of the city s sewer layout pipe gradient and materials depth diameter and length for trunk sewers types of manholes connected population etc is currently held in Sewer CAD AutoCAD and spreadsheets or archived in hard copy AAWSA s Head Office and 8 operational branch offices in Addis are responsible for the collection and management of liquid wastes Although all the branch offices are providing sewerage disposal
22. 2 01HU a SEW 1141 O1HU FOUL a O HU o aicirc 200 200 93 ISOP 190001 20 358 010Ba 8Ew 359 0108 FOUL o 0 0B o ajcirc 400 400 86 6 ISOP 190001 21 962 010Fa SEW 970 01QF FOUL o 0 OF o ajcirc 200 200 105 6 ISOP 120001 22 960 0196 a SEW 968 0106 FOUL o aac o ajciRc 200 200 727 isop 190001 23 958 010Ha 5EW 966 010H FOUL o 0 OH o ajciRc 200 200 100 4 isoP 190001 24 942 010 SEW 950 010J FOUL o ojas o aicirc 200 200 68 5 ISOP 1900017 4 KELA earch for in REFERENCE nA seach select y Advanced Help Close Partners for Water and Sanitation Page 45 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 8 7 Editing and Saving Data It is only possible to edit one layer at a time Bo NU GES 1 0 7 Kore AASA Savers LAN z 1 Select Layer dt vam Lew Silano bio halis ep ee SS eee 4 2 Select Toggle Editing 3 Add or Move Objects 4 Select Identify Features 525 003 700 099 Select Feature N oF Later Atirihnir Valur f A AGAM ee sewer manhole 10 0 099 225 000 1225 00 422901 POW KAT ibe AGE se ika AC 0 287 5 Edit Attribute Data Identify Rusulis SEYS aa 2 Toggle Editing to EE oti SAVE LEAD lab ROAD MOVE ibe UEAN LOTATGN st UAN MEN Coot EKA SA We dot FOUL To Save any changes you must toggle the editing OFF do this regularly to avoid losing any
23. A trainees however the skills required cannot realistically be acquired in a week starting from the base of never having used a GIS or Database or SQL before Essentially CAD contains drawings which are images located in some defined geographical space This information can be easily imported to GIS as an image in the correct location however the attributes of the drawing such as diameter material asset reference number etc are not stored as part of the image Rather they are written as text beside the drawings in CAD This text has to be associated with the drawings of the pipes by a complicated and manual programming process For example a program can be written to look for all text boxes near manhole objects and to extract that text to use as the asset reference Clearly the user needs to know how to program the GIS and also how to check for errors after the batch process has been done These skills take a long time to accumulate In the time allocated the most effective course of action was for Matt to perform a bulk conversion of all the existing CAD data using his programming skills to extract the best possible GIS basis from the data available and that AAWSA staff gain the skills to update and maintain the new GIS database as new assets are created or surveys undertaken AAWSA staff can import data to GIS from CAD which is used for design by using a more laborious manual process This process is described in Appendix C
24. HIGH Responsibility AAWSA Atkins to send CD with anti virus software as interim measure Target completion date April 2010 5 2 Splitting of CAD data to Branch level GIS format During the visit the available CAD data and some typical SewerCAD data was collected this has been processed to provide the basis for the GIS data for the future The GIS has been split into branch areas and has been provided on CD Each branch should nominate an engineer responsible for reviewing and checking the bulk transfer of the CAD to GIS This check should include the manhole numbering and arrangement of the sewer network A layer has been provided showing potential issues identified during the bulk transfer process this should be the starting point of the check We have also provided other sample layers for Quantum GIS and these should be reviewed and improved e AAWSA Boundary and Branch Areas e Roads e Survey Grid e Street Layout Scans In addition the raw CAD data used as the basis of the sewer records is included Partners for Water and Sanitation Page 19 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 Appendix C identifies many useful features of Quantum GIS and discusses the methodology for bringing in SewerCAD data into the Asset Inventory Priority HIGH Responsibility Atkins Target completion date March 2010 5 3 Installa
25. S ToR The conventional sewerage system of Addis Ababa city was introduced during the 1980s as part of the 1st phase of the Addis Ababa City Sewerage Project 1979 1984 During 1984 to 1986 a further medium scale sewerage line was constructed in the central and eastern parts of the city Between these two projects a total of about 100 km of sewerage has been constructed with connections to the sewers starting from 1988 The sewerage system of Addis Ababa city covers less than 10 of the area of the city or a population of approximately 150 000 There is one waste water treatment facility with limited capacity to serve the existing sewerage network The sewerage Master Plan that was prepared for the city in June 2002 has not yet been implemented due to a lack of finances Though a severe problem for the Authority is a lack of infrastructure it also faces significant gaps in the capacity to operate and maintain the existing sewerage system Partners for Water and Sanitation Page 6 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 The major challenges facing Addis Ababa Water and Sewerage Authority AAWSA include limited human resources and capacity in the management operation and maintenance of the sewerage system low levels of awareness from all parties such as decision makers household 8 public connection beneficiaries etc the nece
26. S and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 o In the sample data shown on the screen shot the following cleanup was carried out The levels quoted in the data vary from 340m to 2400m it has been assumed that the lower levels quoted need 2000m added to them The Section size is held as text 300 mm the GIS field only holds an integer therefore the mm has to be dropped A large number of records have no data and have been deleted The Node References must match those in the GIS The fields highlighted in Yellow are those to be imported to the GIS 341 12 337 22 Standard lt None gt TRUE 339 47 336 82 Standard None None 0 N A NIA N A TRUE 341 53 336 44 Standard lt None gt None 0 N A N A N A 73 59 TRUE 340 2 336 01 Standard Nones None ONA NA wa Node Data TRUE 0 0 Standard lt None gt None 0 N A N A N A TRUE 2 402 90 2 402 90 Standard lt None gt None 0 N A N A N A TA TRUE 2 403 09 2 401 98 Standard lt None gt None 0 N A N A N A N A TRUE 2 405 09 2 401 62 Standard lt None gt None 0 N A N A N A NA 240795 2401 36 Standard None5 None 0 N A N A N A N A 2406 97 2401 10 Standard None5 None N A 404 cn nd o na M NODE LINK Sheet3 23 B c D E F G H J K L M N o P Upstream Downstream Construct Defined Bend User Infiltration h Upstream Invert Downstream Invert ed S
27. The tender should it actually be implemented will more or less make the current training and implementation efforts redundant as a new system will come into place complete with technical training for the staff using it In addition to the I T infrastructure plans above the authority has a number of sewer master plans the most recent of which was completed in 2002 Work to expand the water supply capacity is underway being carried out by international consultants 3 Activities undertaken during the visit 3 1 Discussions In order to plan the capacity building exercise it was necessary to hold some discussions with AAWSA staff prior to developing the training programme A fairly detailed programme was developed prior to our arrival in country see Appendix B over email and then finalised during a teleconference with Ato Gemechis the owner of the Sewer Service core process In the event this programme was not adhered to although most of the subjects detailed were covered Site visits to the sewerage treatment plants were dropped and field GPS training was included It became apparent that the most important aspect of the training would be determining how AAWSA manages information and attempting to improve this system In order to do this significant time would have to be set aside to learn how things are done before making suggestions and targeting training This time was not really available but discussions on business processes
28. aff with infected computers e There is no functioning asset inventory or GIS Authority sewer network data asset is stored in AutoCAD or SewerCAD or hard copy based on as built drawings or design drawings mainly the latter Good hard copies have been kept as have complete records of customer connections e Some sewer modelling is carried out at branch level Network analysis activities are limited to designing new pipes prior to construction No study of the overall impact of growth is carried out for the downstream system This has serious implications for trunk sewer capacity in the long term During the visit we were able to achieve the following outputs e Installation of GIS on the head office computer and I T department computers Development of management information diagrams and agreement of responsibilities data flows target completion times etc e Development of data collection forms e Training sewer on the new GIS and I T staff in the installation of the software e Conversion of CAD data to GIS format and training staff in this process e Training in the use of the authority hand help GPS in collecting sewer asset information Partners for Water and Sanitation Page 3 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 Recommendations e Implementation of an information management procedure for sewer assets information
29. age 40 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 Screen Shot showing the cleaned up Data Exported from SewerCAD Save each of the Excel Tabs as a DBF file This is possible in Excel 2003 Save As dbf4 It is not possible to save as dbf from Excel 2007 Dedicated converters are available to purchase or it should be possible to convert Excel through ArcView 2340 22MIN Stedud Maa Nra DMA uA ma Ka Three potential tools should be investigated to create the SewerCAD data in QGIS e Join Table in fTools Data Management e Delimintor Table Import watch for 1000 separators in coordinates e Table Manager QGIS Plugin Further Investigation is required in the interim it is recommended that updates to the data is limited to Manual Inputs 8 4 4 Raster Layers Scanned Images Google Maps Quantum GIS 1 0 2 Kore AAWSA Sewer Data File Edit View Layer Settings as CERNA amp Legend Bx FH 3 SEWER POINT v o o wN SEWER LINEv03 0 001 175 000 A 175 000 350 000 N 380 000 525 000 N 525 000 700 000 N 700 000 875 000 NG 875 000 1050 000 1050 000 1225 000 NG 1225 000 1400 001 Plugins Tools Help W Fetch Python Plugins Manage Plugins Add WES layer Coordinate Capture Decorations Delimited text Dxf25hp Georeferencer Georeferencer
30. agree with e g if the duration of the course was right was it too short or too long e The course content is large but the time given was short and also the training room is not comfortable The duration of the course is very short and we didn t get time to related theory with practice We need a continuous training on the subject Just a right time It is too short Where there any aspects of the course that you think should be improved e Keep its continuity e Weneed to improve our knowledge in sewer modelling and GIS data processing and how to use GPS a data entry in the system e The application GIS is the most important for our work in our organization so it should be given due attention a lot time to deal with it e For some times in the training days there was a delay and didn t start our training course on as per the schedule Be punctual e expect your next trainings would be on software like SewerCad Which parts of the course did you find useful Partners for Water and Sanitation Page 60 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 All parts of the course were useful But the best one is the method of solving the maintenance of the broken pipe The database and GIS relationship was useful Downloading geographical maps form Google maps to get recent maps of the city How to put assets data the we found fr
31. ard None None 0 N A N A N A N A _6 GS TRUE 331 41 327 92 Standard None None 0 N A N A NA N A 7 GR TRUE 331 5 327 61 Standard lt None gt None 0 N A N A N A NA _8 GQ1 TRUE 331 17 327 45 Standard None None 0 N A N A N A N A 9 GQ TRUE 331 31 326 44 Standard None None 0 N A N A N A N A 10 GP TRUE 3274 325 69 Standard None None 0 N A N A N A NA 329 47 325 35 Standard lt None gt None 0 N A N A N A N A n n MUA MWA E FE G K L o Downstream Construct Defined Bend User Infiltration li Upstream Invert Downstream Invert ed Slope Bend Angle Defined Length Section Number of Load l Elevation m Node Elevation m Angle radians Length m Shape Section Size Sections T t FALSE 0 1 FALSE 91 5 Circular T FALSE 0 2 FALSE 101 5 Circular 0 004215 FALSE 0 2 FALSE 111 5 Circular 1 None 0 005128 FALSE 0 91 FALSE 97 5 Circular 1 None 10 915 FALSE 2 24 FALSE 30 Circular 1 None 7 99805 FALSE 0 06 FALSE 41 Circular 1 None 0 004844 FALSE 1 4 FALSE 64 Circular 1 None 0 005714 FALSE 1 24 FALSE 28 Circular 1 None 0 031077 FALSE 0 48 FALSE 32 5 Circular 1 None 11 P 100 0 008287 FALSE 0 26 FALSE 90 5 Circular 1 None 12 P01 0 008193 FALSE 0 52 FALSE 41 5 Circular 1 None 13 P 102 0 025843 FALSE 0 23 FALSE 44 5 Circular 1 None 14 P 103 0 004941 FALSE 0 51 FALSE 42 5 Circular 1 None 15 P 104 0 0062 FALSE 139 FALSE 50 Circular 1 None Partners for Water and Sanitation P
32. as an appropriate solution Aims and This project aims to provide expert skills and knowledge to enable AAWSA staff to Objectives develop an effective robust and workable centralised asset management database that can be accessed by all relevant users including operational branch Partners for Water and Sanitation Page 25 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 offices Deliverables To achieve the deliverables the following main activities are anticipated with due reference to the report from the earlier support visit prepared by Trevor Nott of South West Water available on request Share experiences in developing an asset management database Conduct practical training to AAWSA staff in sewerage network asset database management including software applications building on earlier training in GIS AutoCAD 8 Sewer CAD carried out with AAWSA Help AAWSA staff develop procedures and techniques to set up a software based asset database system collect and store asset data that will enable them to build and maintain quality data sets to meet the current and future needs of the city s sewerage network and Provide ongoing technical input through remote support to guide AAWSA as they establish a software based asset management database Key deliverables in the support to AAWSA are anticipate
33. ass only works when you are moving Partners for Water and Sanitation Page 59 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 10 AppendixE Feedback ia an Score 1 6 Regarding relevance of course content 5 5 What I learnt in this course will help me improve my 12 performance 5 5 Material and issues were current and worthwhile 12 5 16 The course was relevant to my needs 12 5 83 Regarding the quality of course design The structure and institutional modes of the course 12 encouraged learning 5 66 The course objectives were fully addressed 12 5 16 The course actively and effectively engaged me through 12 out 5 58 The duration of the course was just right 12 4 5 Overall this was a high quality course 12 5 41 Relative to other training that I have attended I would rank 12 this course as one of the best 5 41 Regarding the quality of the instructors The instructors encouraged and responded will to 12 questions 5 91 The instructors have knowledge in the course content 12 5 66 The instructors treated participants with respect 12 5 91 The instructors were well prepared and organised 12 5 75 The pace of instruction was just right 12 5 75 Comments Please comment on any of the statements in the previous sections particularly those you dis
34. att Rose Alex Nash Atkins Ltd January 2010 Time Activities Responsible person Facilitator s 13 30 15 30 Conduct wrap up meeting with Head of AAWSA s Sewerage Alex Matthew Tesfay Ato Gemechis Service Core Process Ato esus Lunch 15 30 16 00 Coffee Tea Break 16 30 17 30 Conduct wrap up meeting with top Management of AAWSA with the GM Ato Getachew Alex Matthew Tesfay Ato Gemechis Eshete andthe Deputy GM Eng esus Wondimu Tekle to agree on the way foreword Presentation of certificates The Responsible person Facilitator specified as AAWSA should be nominated to be the AAWSA s Sewerage Service Core process Optional activities are provided to give more rooms for any changes or modifications Partners for Water and Sanitation Page 35 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 8 Appendix C Converting CAD information to GIS format and using GIS This appendix provides information on specific tasks that may need to be carried out with Quantum GIS to suit Addis Ababa Water amp Sewerage Authority GIS for Wastewater Network Assets The basic tasks and areas for self learning are contained within the Quantum GIS QGIS manual which is included in the data CD and available for download at gg Quantum GIS main site latest software manuals plu
35. cesses This met with some resistance because the staff are used to working as a team where responsibility is only delegated at senior levels Junior staff did not appear to be willing to nominate themselves as being responsible for a particular role or process By explaining that responsibility for a data process was not the same thing as being senior to other staff and did not mean that the nominee would actually have to do all of the work involved in that process we were able to define the most appropriate process owners for the various steps in information processing required to gather sewer asset data We explained that the reason the flow diagram had to contain names was so that each process owner know whom they had to speak to and relay information to to ensure a smooth and timely flow of data The resultant flow diagram for one of the branches is presented below Partners for Water and Sanitation Page 12 January 2010 Sewer Network Asset Information Flows Nifaalik PAA Step131 Maa a a days aha powers received ng Step5 1 a j Project Office completes construction of main E fine or trunk As built crawings issued to Branch a Payment received by cashier Information sent to Branch office a engineering team and Head Office Process Owner n Process Owner Toshoma Data format KARD COPY Data format GIS shp CAD wg Due Date Second Wednesday of mont
36. cription of how to convert CAD data to GIS is contained in Appendix C Converting CAD information to GIS format and using GIS In general terms the process is summarised below How asset data is organised and converted on our systems in each branch Conversion process export CAD drawings as a dxf files using WBLOCK Import these to GIS using the plugin dxf to shp and then draw new GIS File Structure objects over the top of the CAD The GIS files need to be kept in drawings Add in object attributes an offical structureso that from survey data or as built drawing we don t lose them and anyone information manually from any branch can find data File Structure The CAD files need to be kept in an Offical structureso that we don t lose them and anyone CAD files from any branch can find data These are the files which are read by CAD and contain drawings of the authority assets GIS files This is the asset inventory and also a map of where our assets are Monthly copies I of the GIS files l 1 Conversion process open shape for each branch wW Copies of Sewer Model in branches file in ArcView export file as dxf are sent to the lowe which can be opened by CAD head office where fz gt they are stored CT i AE a in the same official er file structue I i We N1 L i I cps Se ee Na Model files 1 kept in offical file structure U I SewerCAD or other sewer on F i mo
37. d into a separate layer Note the text is an attribute within a point object 8 4 2 ArcView ArcView files are directly inter changeable with QGIS and can be open in either system 8 4 3 SewerCAD This process is unfinished and needs further research as skills are gained in the use of Quantum GIS To Populate the GIS with data from SewerCAD requires a number of complex steps using SewerCAD Excel and QGIS It is recommended that for small data sets the GIS is updated manually within QGIS If bulk imports this procedure is practiced on a copy of the data until the routine is perfected and repeatable The Notes below should be treated as a guide to the process which will need building upon as skills are gained in AAWSA Export SewerCAD data in grid format and export to Excel e A separate Excel Tab should be populated with the data for Nodes and another for Links e In Excel clean up the data and identify the records that are required to be updated within the GIS The screenshot below shows the format of the sample data used e When cleaning up the data it is important to consider o Whether the data you wish to import is correct o The data in the spreadsheet has the same Asset References as those held in the GIS o Any data that is not required is deleted o The fields that are to be imported match the field type in the GIS Partners for Water and Sanitation Page 39 January 2010 Partners for Water and Sanitation GI
38. d to include AAWSA staff equipped with basic principles and knowledge to set up and maintain a centralised asset management database that can be accessed by all relevant users AAWSA staff knowledgeable about basic procedures and techniques in the practical application of asset management databases appropriate for sewerage system development and management AAWSA staff s IT skills enhanced in understanding the methods and procedures for uploading data to from AutoCAD and Sewer CAD export this to from GIS and other user friendly software and to maintain a well functioning system AAWSA is to be the designated owner of the asset database having full control over data entry This is necessary to ensure consistency of asset registration for new assets and controlled amendments to the database Impact This support will help AAWSA develop an appropriate asset management database centrally controlled by AAWSA accessible and used by AAWSA staff at the Head Office in its 5 branch offices by other appropriate stakeholders and eventually in the remaining 3 branch offices Such a system can help AAWSA perform its responsibilities in managing maintaining and improving the sewerage network in Addis Ababa with greater effectiveness and efficiency Scope The purpose of Partners for Water and Sanitation support is to build the knowledge and capacity of core staff within AAWSA who are responsible for existing asset data managem
39. delling software A eae ene Exports to third parties 3 in GIS CAD hard or soft copy eee ee Conversion process import shape file from GIS OR import dxf file and add pipe attributes from GIS manually Monthly Backup to CD Model files kept in offical file structure Partners for Water and Sanitation Page 16 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 A sample file structure was suggested to the trainees for storing asset inventory GIS data o 615 DATA FILE STRUCTURE O 01 QGI5 PROJECT FILES O 01 AAWSA OVERVIEW O 02 BRANCH x DRAWINGS O 03 PLOTTED DRAWINGS B 10 PROJECT1 Extension to Area Xx B 11 PROJECT2 Extension to area Y O 98 TRAINING O 99 TEMPORARY DRAWINGS QD 02 ASSET DATA O 03 BOUNDARY DATA o O 04 MAPPING DATA 01 ROADS 02 BUILDINGS O 03 CONTOURS O 04 TEXT O 50 INCOMING DXF o 6 99 MIsC O 20091201 Data I1Dec2009 O 20100106 AAWSA Dayl O 20100114 PAWS Training These forms and diagrams are all contained in soft copy on the disks issued to participants to be used as examples to be developed by AAWSA as it refines its information gathering and management processes 4 2 GIS system installed Quantum GIS QGIS was selected as an appropriate tool to install at AAWSA This is because it is free software regularly updated simply to use and yet powerful enough for the purposes of the authority It was
40. e guaranteed latest time by which the activity would be done taking into consideration the fact that the staff would have other concurrent tasks A data gathering target was set to gather all AAWSA sewer network data over the course of a year Given there are around 3 000 manholes in the CAD system surveying these means gathering information on around 10 manholes per week per branch there are 8 branches We noted that in addition to manhole data branches should also survey connection boxes which we estimated to occur at a rate of about 3 for every manhole AAWSA staff agreed that it should be possible to collect up to 40 data points per day and therefore the information gathering could take place on one day per week per branch This will allow the GPS devices there are only 4 of them to be shared between branches In each branch there are three engineers trained in GPS survey as a result of our mission so in theory each engineer should only have to give up one day per three weeks to gather then data To accompany the information flow diagram we purchased stationary materials for each branch office including lever arch folders adhesive labels and transparent plastic envelopes so that hard copies could be managed carefully and all staff would have a central reference point for hard data flows completed with hard copies of the process flow diagrams The plastic sleeves should be marked with corresponding process steps as per the diagram
41. e 385 32738 3081 WGS 84 UTM zone 39N 32639 3016 WGS 84 UTM zone 395 32739 3082 WGS 84 UTM zone 3N 32603 2980 WGS 84 UTM zone 35 32703 3046 WGS 84 UTM zone 40N 32640 3017 WGS 84 UTM zone 405 32740 3083 proj utm zone 37 ellps WG584 datum WG584 units m no_defs Search EPSG ID Name Partners for Water and Sanitation Page 43 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 8 6 Viewing Data and Labelling Double Click on layer or right click properties to enter the Layer Properties dialog Box A full explanation of this Dialog Box is found in the Manual To explore the possibilities of the Layer Properties the following example will display the SEWER LINES with the line with varying depending on the pipe size PIPE HEIGHT will display the pipe size as text when zoomed in GAAXINAO Gmo Babae Mac La cam Arto Cali had 26 000 10t MER POINT 2 pa a TSONG png mar ee ee naw 626 000 E pie inon 5900 mow Foii concur libel Dani Dak ukol kakai sam com Grad 3 so Ox saang Paa z 600 1400 Das dires as Cats wga iow C TATA PONT paka dired igre Daa tree Ane bga darassa are let pol koma Bart Ni Ow Sage b o lah isbn Orage naases o Me wee E Ue note ordri redone wen mwn ma 3 Mite ikay maan OOS Seats Frimo Cet mb Bye Reve in Oat ek Land Woke Bre Nye tee gt a wer
42. e Dept Branch engineers Target completion date March 2011 5 7 Gaining basic GIS skills Following the initial training and workshops in the principles of GIS and developing and understanding in the data formats for both field record types and point line polygon data it is essential that the AAWSA staff develop their GIS skills To facilitate this there are a number of resources available Partners for Water and Sanitation Page 21 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 e We have provided a GIS Manual that outlines the basic routine tasks that AAWSA staff will need to carry out it is recommended that this document is updated by AAWSA as new skills are learnt and circulated to other users to encourage skill development This is particularly important with the users being located in remote branch offices e The QGIS manual provided on CD and located in C Program Files Quantum GIS docs userguide pdf e An additional QGIS user guide is provided on the CD which provides addition information relating to the 1 0 0 Kore release of the software with worked examples and description of advance features qgis 1 0 0_user_guide_en pdf e There are numerous Internet resources available these can provide o Searchable user forum at http forum qgis org o Mailing Group atfhttp ggis org o Additional software plugi
43. e location you want to save the WBLOCK new Dxf File 10 Click OK to create the new DXF file In QGIS 1 Used the DXF to Shape Converter Plugin from the menu or Icon Quantum GIS 1 0 2 Kore File Edit View Layer Settings Plugins Tools Help E ca a uy Fetch Python Plugins Ng Nd ICA Manage Plugins GB amp Fa nap o rer 4 Add WES layer a o Coordinate Capture y iy Oy Py By Decorations gt Delimited text gt are pxzsho rm Dxf25hp Converter Georeferencer Gps GRASS Graticules Interpolation La gt b b MapServer Export gt Quick Print gt Spit Zoom to Point b b OGR Converter Python Console E E Partners for Water and Sanitation January 2010 Page 38 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 2 The following dialog box will open Dxf Importer Input Dxf File fiscal Output file lees Output file type Polyline Polygon Export text labels Select the DXF file that has been created and enter the name and path of the Shape File with reference to the recommendations for AAWSA file naming system structure Enter Polygon Polyline or Point dependant on the type of data being imported If you have text objects in the data you are importing select Export Text Labels and these will be converte
44. ect the _sewerage_network connections asset data Module 3 Database principles Matthew Alex AAWSA 10 30 11 00 Coffee Tea Break 11 00 12 30 Practical ai Cont d on how to collect and locate iho sewerage Hetwerk connections by splitting in to imole individual F and a multi user Complex Module 4 GIS basics Alex Matthew 12 30 13 30 LUNCH BREAK 13 30 15 30 Conduct practical office level demenstrattons on how to store asset data of the sewerage network connections Attempt installation of GIS in IT networked computers Alex Matt 15 30 16 00 COFFEE TEA BREAK 16 30 17 30 Continue en the practical office level demonstrations on how to store asset data of the sewerage network connections buil ae hi sets Attempt installation of GIS in IT networked computers Alex Matthew Day 6 8 30 9 00 Registration AAWSA AAWSA Tuesday 12 January 2010 9 00 10 30 Exercise_on hydraulic modelling software such as CAD for the design_and analysis of sewerage so as to get ideas of the link between the design aspects_and the asset data management kk Discussion about the data we should collect and data flows AAWSA teams present their homework on data flows owners and responsibilities Matthew Alex 10 30 11 00 Coffee Tea Break 11 00 12 30 7 z
45. ed to the water and certainly sanitation networks belong to the middle or upper classes it represents a vast subsidy from the government revenues to the middle and upper classes Sanitation is set at 5 of the water bill regardless of the sanitation service offered For those customers on the sewerage network this represents a monthly cost of about 1 5 ETB 0 08 which is the cost of a short ride on a public minibus So the inconsistent situation exists where large villas in which several new 4WDs may be parked and which are connected to a well functioning sewer network pay virtually nothing for their sewer service Meanwhile on site sanitation services are not included in the price of the water bill The authority does operate a number of vacuum trucks which were in good to excellent condition Customers can request a vacuum truck service bill filling out a form in the branches Prices for the service are fixed and also subsidised below cost but typically are around 69 ETB Private operators charge a much higher unsubsidised price We were informed that all water connections are metered Note also that the authority does not connect houses which do not have water connections to the sewer network although it is unlikely that there is much demand for this service This means that all future sewer customers actually already have an account with the authority and are being charged for sanitation services The authority does not bother t
46. ent as they develop a functioning and appropriate asset management database The support will focus on the development of an enhanced database and records It will include training staff in software applications either on GIS or relevant user friendly software that could be used for a sewerage network database and remote support in helping establish the software based asset database The UK partner can propose in consultation with AAWSA staff a user friendly asset management database software system based on personal experience in the field Partners for Water and Sanitation Page 26 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 Organisation and methodology The lead contact within AAWSA will be Ato Gemechis Tilahun Process Owner of the Sewerage Service Core Process He will be supported by Eng Wondimu Tekle the Deputy General Manager Technical and Ato Zereu Girmay of AAWSA Ato Tesfaye Woredie from the Sewer Network System Unit will be available to assist with specific technical matters The Partners for Water and Sanitation UK expert will hold a teleconference discussion with AAWSA staff and other relevant stakeholders in advance of the visit to discuss how best to make the training and support visit effective This will be supported with an exchange of proposals and information in advance of the v
47. gins etc This website also provides many resources for further learning additional tools sample data and a web forum with many tips tricks for the use of QGIS provided in a searchable forum 8 1 Recommendation on GIS use within AAWSA It is recommended that AAWSA identify key members of staff to champion the use of the GIS and set up an internal user group which can drive forward the use of GIS within the organisation In addition it is recommended that AAWSA develop a set of procedures for the implementation and use of the GIS This Appendix may form the basis of the initial AAWSA GIS Procedures and User Manual to provide all users with a document describing common tasks and that the Manual that should be updated as the usage and knowledge of GIS expands within AAWSA 8 2 Initial Setup On The first installation of Quantum GIS the program will ask for the path to the GRASS installation The setup of Quantum GIS proposed does not require GRASS to provide the functions AAWSA require ee ae GRASS plugin BK QGIS couldn t find your GRASS installation Would you like to specify path GISBASE to your GRASS installation Kore Click OK and navigate to C Program Files Quantum GlS grass Select Choose c Partners for Water and Sanitation Page 36 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010
48. h bo d pent nnn show sewer connection Notes field updated fas Copy of all branch GIS Data Data Owner Shorit 8 a 2 Z 5 W lt no 3 E 5 2 o oa 2 S g z o gt w a lt 5 J EI D o c 6 B bar s N ce 7 Z N o a Step 7 2 k Step3 21 S sabta earar eee a sewer network model Customer record contact field in biling system mi a en ae Data owner amended to show sludge service and date of 1 2 z Process Owner Shorit ue A 4 aaa Ki x Data format CAD GIS magana Data format a z o Target Response Time 1 day Target response time a a ze RAP oan A a e a mae o p NA N k a mo ee Key to partise o 1 project Offce ete ta for modelling i e ala nba 4 Cr ed Otee Sewerage Team Head office nance Kwan Extern lesi rage Team Sig sem ProjectOffice F Eee me Kaka taasang i 5 2 ie maminarawawaswsaoin3 Sewerage Team www ee ee 5 5 Procetowner oa 25 SS aaa Page 13 Partners for Water and Sanitation January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 The information flow diagram also contains target response times for the various activities based on what staff felt they could easily achieve At first this was understood to be the time it took to do the activity however we explained that it was th
49. he Secretariat s quarterly reports on project progress for submission to the Steering Group On completion of the project the Partners for Water and Sanitation UK expert may be required to help produce a final project report detailing the project outcomes and impacts Approvals appropriate as Rebecca Scott UK Secretariat Eng Wondimu Tekle The Deputy General Manager Technical of AAWSA Partners for Water and Sanitation Project Manager Compiled by Melkamu Jaleta Partners for Water and Sanitation Country Manager Ethiopia Gemechis Tilahun the Sewerage Service Core Process Owner of AAWSA Date 12 October 2009 Partners for Water and Sanitation January 2010 Page 28 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 7 Appendix B Initial and Modified Programme for the visit Addis Ababa Water 6 Sewerage Authority and Partners for Water and Sanitation Asset Data Base Management Training and Technical Assistance Day18 2 5 th th 6 Addis Ababa Ethiopia h h 5 to 14 January 2010 January 2010 Date Time Activities Responsible Facilitator s person Day 1 Until 10 30 am The UK team will have rest in their hotel Tuesday 10 30 12 30 Melkamu Tesfayesus and the UK team All PfWS team Melkamu 5 to discus
50. his work is carried out successfully and efficiently This will be assisted by the Partners for Water and Sanitation Country Manager Issues Risks Risk Lack of information and documents on existing data management within AAWSA Mitigation The Country Manager will liaise with AAWSA staff to secure as much information as possible in advance of the training Risk In country health safety and security Mitigation The Country Manager amp UK Secretariat will work with the UK expert to undertake a thorough Health amp Safety and Risk Assessment procedure prior to travel Communication Strategy The key contact in Ethiopia is the Partners for Water and Sanitation Country Manager Ato Melkamu Jaleta Ato Gemechis Tilahun is the key contact for all support provided by and to AAWSA staff The Deputy General Manager Technical of AAWSA will receive regular reports from him Direct communication between the Partners for Water and Sanitation UK expert and Ato Gemechis Tilahun will be established by the Partners for Water and Sanitation Country Manager as appropriate prior to the training visit to Ethiopia Review Mechanism Project specific review mechanisms are to be agreed to by the Partners for Water and Sanitation UK expert A visit report will be prepared after the training visit in Ethiopia reporting against the visit objectives and making suitable recommendations In addition the Country Manager will feed into t
51. ilar degree of detail AutoCAD does not allow the storage of many shape attributes it is basically a program for drawing SewerCAD allows additional attributes to be associated with the shapes such as depth diameter slope roughness etc Partners for Water and Sanitation Page 8 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 2 4 AAWSA Capacity As mentioned above training on sewer modelling has been delivered by PfWS and was well received Technical staff were keen to develop sewer modelling skills further Many of the participants were versed in AutoCAD and to a lesser extent SewerCAD Some modelling with SewerCAD has been carried out and staff were keen to develop skills in this area In theory technical staff carry out maximum pipe flow calculations for each branch when considering new connections In most cases they make an expert judgement based on whether the pipe is visibly full at the lower manholes None of the sewer department technical staff have experience using databases asset inventories or GIS The closest approximation to GIS they have used is SewerCAD where some data from as built diagrams has been added to the CAD shapes None of the staff we met had experience using a GPS Some I T department staff also took part in the training and it transpired that the authority is in fact running an Oracle
52. isit Ato Gemechis of the Sewerage Service Core Process will assign a team of focal persons within AAWSA to take the support forward The Partners for Water and Sanitation UK expert will train 3 people from the Head Office and 2 people from each of the 5 branch offices making a total of up to 15 people The training will be based on relevant computer aided software identified as such in earlier communications The UK expert will also provide ongoing remote support following the visit and formal training sessions Milestone plan A 2 week support visit is proposed to take place in mid November 2009 Actual dates are subject to availability of suitable UK expertise and can be negotiated to suit all parties concerned It is hoped however that the training will take place during 2009 The visit will include A day s preparatory discussions with AAWSA staff and other key stakeholders Up to 10 days of half day training sessions in the application of software based sewerage system database management This will allow trainees to receive 2 days of formal training and allow 72 days for coaching working through practical on the job exercises A draft report is to be prepared within 4 weeks of the support visit for comment by AAWSA and key stakeholders A final report is to be prepared within 4 weeks of receipt of feedback from AAWSA and other key stakeholders Ongoing remote support to AAWSA staff is anticipated following up on advice
53. lope Bend Angle Defined Length Section Number of Load E Node Elevation m Node Elevation m m m Angle radians Length m Shape Section Size Sections Type L 0 008 FALSE 0 63 FALSE 15 Circular 0 006742 FALSE 0 03 FALSE 44 5 Circular 0 004396 FALSE 1 03 FALSE 91 Circular 0 004294 FALSE 0 1 FALSE 88 5 Circular 0 00589 FALSE 0 43 FALSE 73 Circular 0 075814 FALSE 1 81 FALSE 64 5 Circular 22 5625 FALSE 0 08 FALSE 106 5 Circular 0 010132 FALSE 0 52 FALSE 91 Circular 0 003738 FALSE 1 03 FALSE 95 5 Circular 0 003969 FALSE 0 02 FALSE 65 5 Circular 1 None 0 004203 FALSE 0 28 FALSE 64 Circular 1 None 0 004149 FALSE 0 11 FALSE 80 5 Circular 1 None 0 004138 0 007504 0 0386 FALSE 0 03 FALSE 94 5 Circular 64 5 Circular 265 P Kab M NODE LINK Sheet3 J Screen Shot showing the Raw Data Exported from SewerCAD G EXAMPLE Arada Data IMPORT xIs 2 Compatibility Mode a A FE PAMAN D E F msa Ho J a a NANANG N Ol Ground Set Rim Equal to Rim Sump Sanitary Inflow Known Total Hydraulic Hydraulic Element Elevation Ground Elevation Elevation Headloss Load Load Flow Flow Grade Line Grade Line Headloss Elevation m m Method Type Type V d Vd _ In m Out m m Description X m TRUE 331 69 329 73 Standard lt None gt None 0 N A NWA NIA NIA TRUE 332 1 329 28 Standard lt None gt None 0 N A N A N A N A GV TRUE 331 05 328 89 Standard None None 0 N A N A N A N A GU TRUE 329 97 328 42 Stand
54. m development and management Training workshop on data conversion and visit to WaterAid offices with I T staff to investigate anti virus tools because WaterAid has broadband internet whereas AAWSA I T staff have no internet access Purchasing of stationary materials for information management systems in the branches Printing on labels and downloading of software etc Alex Matthew Day 8 Thursda y 14 January 2010 8 30 9 00 Registration AAWSA 9 00 10 00 NAWSA buildi Preparation of CDs with soft copies of materials and course certificates Matthew 10 00 10 30 Discuss onthe AAWSA training participar is_feadbacks of a fornext steps Sewer modelling presentation Matthew 10 30 11 00 Coffee Tea Break 11 00 12 00 KAWSA 5 AT di 3 ify_th future followup support areas by the UkK team in areas asset database Finalisation of information flow diagram for one of the branches including tasks assigned to individuals and target response times for activities AAWSA s Participants Matthew Alex 12 00 12 30 Conducttraining TA suppoert evaluation As above AAWSA s Participants Matthew Alex T esfayesus 12 30 13 30 LUNCH BREAK Partners for Water and Sanitation January 2010 Page 34 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia M
55. mented We will discuss ways of controlling internet usage and risks posed by the internet in the body of the report Partners for Water and Sanitation Page 4 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 2 Introduction Partners for Water and Sanitation is a not for profit partnership that focuses on sharing technical expertise to build the capacity of the water and sanitation sector in Africa Our vision is to be recognized as the leading provider of professional volunteer expertise to support the achievement of the Millennium Development Goal targets for Water and Sanitation in Africa Our mission is to improve water and sanitation services and management in Africa We achieve this through matching the demand for skills and advice from our in country African partners with professionals from the UK water sector Our UK partners then provide their staff on a voluntary basis to share knowledge and technical expertise to support a diverse range of projects Our aim is to foster long term relationships with our partners to strengthen skills and performance of the water amp sanitation sector to ultimately improve water management and sanitation 2 1 Terms of Reference The Terms of reference for the project stated the following justification for the PfWS intervention Partners for Water and Sanitation
56. na aaa aaah 10 3 Activities undertaken during the visit 10 3 1 DISCUSSIONS na NANG NANU IBABA NINDA DAGAN NAIN ANGAT 10 3 2 Workshop aNG BAGAN ANA 11 3 3 Presentations maa NAA a 11 4 Outputs of the MISSION Xa A NANANA ANA RAK ARA AAAAAAAG 11 4 1 Information Management System in PlaCe eeeeeeeeeeeeeeeeeeeeeeeeeneeeeeeeeeeeeeee 11 4 2 GIS system installed aa AA GANANG AA 17 4 3 Bulk Conversion of CAD data to GIS format 1 1 maaaaananaaananaaaaaaaaaaaaaaaaanana 18 5 Neyt Steps ait sais ciscs secs ccs cens cxcaeceencncnca ceesncccnteecemscesaenuannas cena ceeacsnccsaecenacneensncenues 19 5 1 Software updates and virus ProtectiOn c cceeeeseeeeeeeeseseeeeeeeeeeseeeeeseeeeee 19 5 2 Splitting of CAD data to Branch level GIS format 1 7 maasusawawwanananananannn 19 5 3 Installation of GIS in all branch officeS nnnnnnnnnnnnnnrrrrrrtrrrrrrrrrrrrnrnrrrrnnna 20 5 4 Complete formalised system for managing information La nananana 20 5 5 Linking of Sewerage and Water customer data 7 7 2 aaaaasasasanananaasana 20 5 6 Field surveys of network assets 0 mawaananananananananananasananasanananana 21 5 7 Gaining basic GIS skills annawwwwwwwananananasunanasnananananasasananannnasananasannn 21 5 8 Development of Trunk Sewer Model eeeesseeeeeeeeeeseseseseeeeseeeeeeeeeeeeeeees 22 5 9 Exploration of opti
57. ns In addition to the workshops we conducted a number of more formal and traditional training sessions where presentations were delivered using Powerpoint to participants covering database theory information management principles GIS basics etc These presentations were distributed in soft copy at the end of the mission 4 Qutputs of the mission 4 1 Information Management System in place After our discussions with the staff and observations of the data contained in their computers one of the main objectives of the visit was to agree a system to manage asset information in the future We developed an information flow diagram for sewer asset information gathered at branch level and discussed how this would flow to the head office and external parties Note that this is based on incomplete information about how AAWSA does its business so the flow diagram should be considered more of an example which AAWSA staff should develop to more correctly reflect the way their business processes work This was repeatedly stressed however AAWSA staff did not have any major changes to make to the scheme when asked to verify it Partners for Water and Sanitation Page 11 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 After the general flow diagram was drawn we encouraged the trainees to nominate individuals responsible for various data pro
58. ns for particular tasks o Software updates including development versions of the software e Once a suitable level of GIS skills has been achieved AAWSA should consider employing a local expert for a single days training which would allow staff to raise questions relating to use of the GIS within AAWSA The biggest step change with the learning of GIS skills would be the formation of a GIS User Group within AAWSA This should be a small group which meets on a regular basis to increase the knowledge of GIS within AAWSA Potential areas for discussion should be e Sharing and learning from experiences e Developing User Guidance e Standardising the use of GIS e Planning for the future The group should consist of Engineers from the Branch and Head office representatives from the IT team and should be facilitated by a senior manager Priority MEDIUM Responsibility AAWSA Sewerage Dept Branch engineers Target completion date June 2011 5 8 Development of Trunk Sewer Model The hydraulic modelling currently carried out is limited to the sizing of new pipes to make sure they are adequately sized for the proposed use It was also reported to us that the modelling considers future scenarios for further upstream connections to the system and if this is being carried out it should be applauded However any consideration to the downstream trunk system is limited to surveying the connection point and the modelling assumes that the trunk
59. ns Ltd January 2010 1 Executive Summary Partners for Water and Sanitation PfWS is a collaboration of government private sector and NGO organisations dedicated to solving problems associated with providing access to water and sanitation in developing countries The initial focus of the partnership is Africa This report is a summary of the findings and recommendations from the visit to Ethiopia This visit consisted of a series of discussions workshops and training sessions with the Addis Ababa Water and Sewerage Authority AAWSA AAWSA requested PfWS assistance to build staff capacity in managing asset inventories and GIS The first two days consisted of determining the most appropriate capacity building and training intervention and the remainder of the visit 7 working days was training workshops and joint working From the discussions and workshops we concluded that e The authority would benefit from the introduction of information management policies and procedures currently the absence of such procedures means that data is poorly managed versions are not controlled data owners and owners of individual data processes are not defined e While the authority has modern computer hardware and is running one server with an oracle database there is a generalised problem with software updates and particularly security virus protection This poses a severe risk to data and also represents a major loss of productivity for st
60. nt for three reasons 1 One day customers will be charged for their sewerage service and the authority will need to know which customers are connected to the sewer in order to bill them correctly Customers who are not connected will and should refuse to pay for sewer networks that they do not have access to especially given they are already paying high prices for on site sanitation services Partners for Water and Sanitation Page 20 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 2 The second reason is that by linking water and sewerage customer data it will be possible to determine return to sewer flows based on metered volume consumption and to estimate expected flows in sewer mains based on the number of customers upstream of a certain point 3 The billing system is the obvious repository for all customer data and it makes sense to store customer data only once in one place Where different customer information sources exist they will quickly become inconsistent Eventually customer locations GPS locations should be stored in the billing system to facilitate better modelling and planning In the short term we propose the following steps be taken 1 Use the sewer service tick box in the billing system to record customers who have a sewerage service 2 Use the customer notes field in the billing system
61. o indicate in customer accounts in the billing system if each customer has a sewerage service or not despite the fact that the billing system allows this Partners for Water and Sanitation Page 7 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 When a customer connects to the sewer network the process is managed by the branches and the list of new customers is kept on excel spreadsheets in each branch No change is made to the billing system The reason given was that the water and sewerage departments do not communicate although this is more of a statement of fact rather than a reason The excel spreadsheets also make no reference to the water contract number by which customers are identified in the billing system The customer name and address is used free text fields which will prove very difficult to connect information in the future about water and sewerage customers 2 3 Current AAWSA GIS Asset Inventory Status Currently AAWSA does not operate a GIS or Asset Inventory for asset management purposes GIS software does exist and has been installed on some machines although this is not yet in use and is in any case an unofficial version of ArcView which has yet to be proven A fixed asset register FAR does exist for accounting purposes however we were unable to obtain a soft copy of this as the FAR is sto
62. o of the Alex Matt Ato Gemechis offices 1 _sub _process Unit _ Visit to sewer technical team to observe CAD in practice Partners for Water and Sanitation January 2010 Page 29 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Al January 2010 ex Nash Atkins Ltd Time Activities Responsible person Facilitator s 15 30 16 00 COFFEE TEA BREAK 16 00 17 30 Alex Matthew Practical Technical support in two of the Development of training presentations and discussions about the next few days Day 3 amp 4 8 9 January 2010 Date Time Activities Responsible person Ato Gemechis Facilitator s Day 3 Thursday 7 January 2010 All Day Development of Training presentations investigation of software options on_ internet Testing of software Alex Matt Day 3 Friday 8 January 2010 8 30 9 00 Registration AAWSA AAWSA 9 00 10 00 A as use of AuteCAD and or Sewer CAD for the sewerage network asset database management Presentation of the revised agenda for the week training Matthew Alex 10 00 10 30 Discussions en the use of AutoCAD and or Sewer CAD for Module Management 1 Information Matthew Alex 10 30 11 00 Coffee Tea Break 11 00 12 00 A i to develop and_manage
63. om CAD into GIS How to transfer shape files How to manage our data Principle of database General comments e We need more capacity building efforts and keep on giving such kind of trainings The course was very essential and it was given at the right time The course was dealing mostly on sewer and sanitation It would be best it it includes water aspects We would like to thank partners for water and sanitation Appendix F List of Participants for Assets Database and Management Training Shorit Zewde Selamawit Teshale Taressa Workneh Alemayehu Tadesse Ephrem Gebremeskel Habtom Gidey Daniel Assefa Habtamu Duguma Zelalem Ketema 10 Nigussu Gebreegziabher l I Rekik Tsegaye 12 Yemisirach Bishaw 13 Henok Girma 14 Eneyew Tamiru 15 Biruktawit Kassahun 16 Henok Melka ado UA Partners for Water and Sanitation Page 61 January 2010
64. ons for advanced GIS database server and asset inventory front GN AA AA AA GN 23 6 Appendix A Terms of Reference 1 111 000000aauunuuunununununununununuuuaanananaannang 25 7 Appendix B Initial and Modified Programme for the visit 29 8 Appendix C Converting CAD information to GIS format and using MOS AA AA 36 Partners for Water and Sanitation Pagei January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 8 1 Recommendation on GIS use within AAWSA cceeeeeeeeeeeeeeeteeeeeeeereeeee 36 8 2 Initial Setup seisine AA AA AA EA 36 8 3 Main Tema aaa NANG AGANG 37 8 4 Importing Och AA AA 38 841 FA SA PA AA AA AANI 38 Di AG AA AA AP 39 8 4 3 BANA AA NAAN AN 39 8 4 4 Raster Layers Scanned Images Google MapS seeeeeeeeeeeeees 41 8 5 The Interface GUI x ccsctstoutenctetatehars mranthiteretdad ieasbeatelaiecelnndn aueleteiaaasbacsetahs 42 8 6 Viewing Data and Labelling escccstcciccevecekciceticinvetecelciettecieceteiedsieteieixuatesedaietaieiees 44 8 7 Editing and Saving DAA AA 46 9 Appendix D Using the hand held GPS ccccccccssseeeseeeeeeeeeeeeeeeeeneneeeeeees 47 10 Appendix E Feedback aaa aaa aaa 60 Partners for Water and Sanitation Page ii January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atki
65. r and Sanitation TA GIS and Asset Inventory Project AAWSA Ethiopia No Matt Rose Alex Nash Atkins Ltd NG January 2010 To find a location using its X and Y coordinates you need to edit a waypoint and then goto that waypoint To do this do the following steps Press the goto button The select the option waypoint Press enter GPS 72 me saya Partners for Water and Sanitation Page 53 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 The top box in this screen allows you to search for a waypoint You Can enter any numbers or letters and a list of stored waypoints will appear below Select any waypoint it doesn t matter what one Press enter Partners for Water and Sanitation January 2010 Page 54 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 Then press the page button until you get to the active goto page Here select the active waypoint and press enter Partners for Water and Sanitation Page 55 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 Then press the page button until you get to the active goto page Here select the active
66. red on an antiquated HP computer from which only hard copies can be extracted we were told The staff were uncertain when the accounting system was installed but it runs on an HP 3000 series computer which was first released in 1973 and has not been supported since 2006 It is likely that the system in use is over 20 years old AAWSA therefore demonstrate a significant capacity to manage I T assets and stretch IT asset lives which is a very encouraging sign The closest thing to a GIS or asset inventory operated by the authority is AutoCAD again an unofficial version The SewerCAD plug in has also been installed and the authority uses this for sewer modelling and sizing of extensions to the system Participants in the workshop were particularly keen to develop sewer modelling skills We were informed that AAWSA has been transcribing sewer asset data from as constructed diagrams into SewerCAD in order to the software as a modelling tool A small fraction of the asset data has been transferred In August 2009 Adolph Spitzer delivered training on Sewer Network design which was greatly appreciated by AAWSA staff This training covered standard design for new assets but did not cover sewer modelling using SewerCAD The sewer files of AutoCAD contains around 3 000 point assets manholes and about the same number of link assets pipes We did not study the water asset files from AutoCAD but understand that the water network is also stored to a sim
67. s and refine the schedule of the January following days 2010 12 30 13 30 LUNCH BREAK 13 30 14 30 The PfWS team will conduct an Alex Matthew Melkamu and introductory discussion with Ato Gemechis Melkamu Gemechis Head of Sewerage Service Core process 14 30 15 30 The Partners for Water and Sanitation Alex Matthew Gemechis PfWS team will conduct introductory Melkamu discussions with the top Management of AAWSA 15 30 16 30 The PfWS team 4 Ato Gemechis will Alex Matthew Gemechis further refine the training 4 TA programme Melkamu of the next 7 days 16 30 17 30 PfWS team will finalise the preparation for Alex Matthew Gemechis the next day s events Day 2 8 30 9 00 Registration AAWSA AAWSA io 9 00 9 30 Presentation on the AWWSA s Asset Data Ato Gemechis Ato Melkamu Jan ar Base Status future plan and on the so far AWSSA y 2010 PAWS assessments 9 30 10 30 Discussions on the presentation and Ato Gemechis Alex amp Matthew agree on the focuses of the following AWSSA days 10 30 11 00 Coffee Tea Break 11 00 11 30 Present introduce share experience on Alex Matthew Melkamu the possible options of Asset Data Base ADB Development and Management to AAWSA team 11 30 12 30 Discussions to identify and agree on the AAWSA team Alex Matthew best option and also put the way foreword to the AAWSA s ADB dev t amp Mgmi t 12 30 13 30 LUNCH BREAK 13 30 15 30 Practical Technical support in tw
68. s to continually be re started Finally but perhaps most importantly no system of version control for data appears to be in place Technical staff collect data that they need from various sources depending on whom they know No attempt appears to be made to control versions or data quality This was acknowledged as a problem but we were not made aware of any plans to improve data management The general view was that until the branches were connected to the head office it would be impossible to work from a single version of CAD SewerCAD Partners for Water and Sanitation Page 9 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 2 5 AAWSA Plans Some time into the mission we became aware that the I T department of AAWSA have developed a terms of reference for a major upgrade of the authority I T systems The sewerage department staff were unaware of the scope of this upgrade which includes a completely new billing system asset inventory GIS branch connectivity air conditioned server room etc The total estimated cost is 1 5m When this was discussed with Ato Gemechis the head of the sewerage department there was some doubt that this tender would actually be let due to the high cost He was under the impression that it would not take place However the I T department staff informed us that it would be let in a few weeks
69. service by trucks only 5 out of the total 8 branch offices are giving additional sewerage network system services AAWSA would like to be able to store access retrieve and analyse data in such a way that it can be used in the design of new sewers to serve future developments provide details to developers for connections and enable them to undertake survey design works and costing Other stakeholders including Addis Ababa Roads Authority the Ethiopian Telecommunications Corporations and Sub City Administration also need access to this data Neither they nor AAWSA s branch offices are electronically networked to AAWSA s Head Office AAWSA is looking for new techniques to store access retrieve and analyse data especially enabling the customer s side of the business Moreover the currently available data in Sewer CAD AutoCAD and spreadsheets is held independently with no system for importing exporting data between the systems A robust database system in AAWSA s Head Office and in the 5 branch offices overseeing sewer networks that can also be accessed by relevant stakeholders and gradually rolled out to the remaining 3 branches is considered of paramount importance AAWSA staff are therefore seeking external expertise to help them set up and maintain such a database either by building on their existing knowledge and systems of GIS AutoCAD and Sewer CAD or by proposing alternative user friendly software that is mutually agreed
70. sewer has capacity Partners for Water and Sanitation Page 22 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 It is understood that the potential capacity of the trunk sewer is unknown and with AAWSAs aspiration to significantly expand the sewer network in the future it is essential that the performance of the trunk sewer is understood As data on the sewer system is collated into the Asset Repository GIS it will become possible to develop hydraulic models to allow analysis of the existing system and explore future scenarios These scenarios can include additional connections increase in water usage storm water inflow infiltration and many other variables The outputs from this modelling would allow AAWSA to develop a strategic plan to increase the capacity of the trunk sewer as the number of connections increase The development could be carried out by AAWSA or by external consultants If AAWSA considered that it has the required skills in house the most suitable software due to cost would likely be SWMM5 by the US Environmental Protection Agency EPA which is available under a free GNU licence http www epa gov ednnrmrl models swmm index htm Other software exists but would likely be prohibitive due to cost 20 000 The user guide to SWMM5 has been included in on the CD for information Once sufficient Sewerage Asset da
71. ssity of proper waste water handling the low rates of sewerage service delivery and coverage compared with the increasing demands of the population and low capacity to identify and implement alternative strategies and innovative ideas for improvement of the service Delays have been experienced in implementing the proposals for a fully conventional sewerage system in line with the revised Sewerage Master Plan Study that was prepared in 2002 by the Netherlands Engineering Consultants NEDECO in association with other Netherlands consulting firms such as DHV Consulting group and Association for Water Explorers AUE The delays in implementation were attributed by the lack of awareness of appropriate alternative sewerage options to supplement development of a conventional sewer system In addition to these we can make the following comments Like many developing utilities AAWSA is probably in the low service low revenue trap The utility is publicly run and funded and while officially they have a mandate to set tariffs it is very likely that in practice it has little to no autonomy regarding tariff setting We had a brief look at the billing system where typical bills was water and sewerage are 30 ETB per month charged exclusively based on consumption so low consumption months resulted in bills of 3 ETB This is about 1 50 per month While this tariff might be appropriate for very poor households given that the majority of houses connect
72. t Partners for Water and Sanitation Page 44 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 Fie GR Wew Laver Settings Php Took Hap addig PPS CREDO M2 RSSSRER ORSZ Ou D RAR Do 7 4 NB BN Aha NAA AA AADD Lapad Ms o w 0 SEWER POINT a Ta Nag N70 O SEWER LINBAO CM 0001 175 000 s 175 000 350 000 T gao pe 1050 000 1225 000 ka G aa EA 12251000 tago 001 4 A 4 ngg ag aa Identity Results SUWLRLLINLOT polyine 3 fo PE Va AINE Qla eg SGN exit TN or 471 299 stat 471400 YEA HAN PRIS Gat JD We carecity COMMENTS MAL CONDITION UNTO 2300010000000 000 CHO DRAWING DS NOTE Jo CH aww G man ag LOSIH irate HR mamia ISOP KANE MEKAMSSA PETERENCD TRAMPI A AU DISTING SENER LIES LAVET FDE Qe maz arc HAL TYPE UPOAN SPECICATION 2 08 210 CTO eae ime NG x Kos Data can also be viewed and edited in the attribute table data can be cut and pasted to excel or similar for analysis A b e table 0 po e LJ 5 ea 3 a Q 7 id REFERENCE ASSET_ID US_NODE_ID TYPE US INYERT US_DEPTH DS_NODE_ID DS_INVERT DS_DEPTH SHAPE HEIGHT WIDTH LENGTH MATERIAL 1 792 00vra SEW 794 00VT FOUL o ojvT o ajciRc
73. ta has been collected a number of options exist to investigate the trunk sewer and PfWS would be able to assist in the investigation of these options Priority MEDIUM Responsibility AAWSA Sewerage Dept head office engineer with support from Atkins Matt Rose Target completion date September 2010 5 9 Exploration of options for advanced GIS database server and asset inventory front end When the authority has installed a local area network and new servers in addition to making the virus protection and software improvements discussed consideration can be given to installing a fully multi user GIS database and an asset inventory front end The GIS data is the asset inventory however when the GIS files re stand alone i e not in a server based database they can only be accessed through the GIS software In the future it will be useful to be able to access the same data through a database front end Partners for Water and Sanitation Page 23 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 Multiple users on different computers GIS software Asset inventory softare or front end local area network Asset data in server bas ed data base e g MySQL or Oracle on one computer server Priority LOW Responsibility AAWSA T Dept with support from Atkins Alex Nash Target completion date July 20
74. the application out to the branches An attempt was made to install it in one of the branches but defeated due to out of date software and virus ridden computers that are effectively unusable e The authority should embark on a process of updating asset information by carrying out asset surveys This can be done as part of the day to day work at the branches We agreed with the participants that a rate of 10 manholes plus 30 connection boxes per week per branch would be an attainable rate If this is maintained the authority will have a complete asset inventory within a year Trunk lines should be prioritised e Staff GIS skills need to be developed as most staff have no experience with GIS software This should be done using the tutorials provided in the software manual by experimenting with the software by using internet use groups for advice and by sharing knowledge within AAWSA In addition to this when a certain level of expertise has been achieved AAWSA should employ local consultants who are skilled in the use of GIS to carry out a training workshop e A sewer model for the entire sewerage network or trunk sewers at a minimum should be developed This should be done in conjunction with experienced sewer modellers local or PfWS This should be done when a minimum of asset data has been collected 100 of trunk lines We estimate the authority should be ready for this training within 6 months if the other recommendations above are imple
75. ti Waste Water January Treatment Plant or one of the Matthew Alex AAWSA 2010 AAWSA s branch office to conduct on spot discussion as to how the asset data base system treatment plant branch offices for better _feeding one another Optional Presentation of new field data collection forms Presentation of data flow diagram for validation by team 10 30 11 00 Coffee Tea Break 11 00 12 30 Field visit cont d to Kaliti Waste Water Treatment Plant or one of the AAWSA s branch office to Alex Matthew AAWSA Practical exercise in data conversion from CAD to GIS on head engineer s machine now working Partners for Water and Sanitation Page 33 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 Time Activities Responsible person Facilitator s 12 30 13 30 LUNCH BREAK 13 30 15 30 G Di ions Havi through with over a week UK o Trainina TA san will discuss in two groups to mik existing e database system_development and _management and _also Continued workshop on data conversion and use of GIS on head engineer s machine Alex Matt Ato Gemechis 15 30 16 00 COFFEE TEA BREAK 16 30 17 30 dy N APA oo c pat a wilt develop_acten _plans that willead AAWSAto efficient and effective asset database syste
76. tion of GIS in all branch offices Quantum GIS QGIS is a Geospatial Information System the software is available for download it is free to use and distribute under a GNU General Public Licence We have provided the current LTS Long Term Support version of the software on CD to AAWSA version 1 0 2 Kore which should be installed in all the branch offices A number of Microsoft Windows updates will also be required to allow the software to function In addition some plugins to QGIS will allow the programme to be further refined to suit AAWSA s purposes and these should be installed and configured at the same time Further information can be found in the GIS Manual Priority HIGH Responsibility AAWSA I T Dept Target completion date April 2010 5 4 Complete formalised system for managing information The authority needs to complete the process stated during the workshops of developing information flow diagrams and assigning responsibilities and target process completion times A separate diagram should be developed for each branch office in excel printed out and distributed to staff at each branch and glued into the green folder provided A copy should be provided to the head office Priority HIGH Responsibility AAWSA Sewerage Dept Target completion date April 2010 5 5 Linking of Sewerage and Water customer data The authority should link water and sewerage customer information in the billing system This is importa
77. to note the connection box reference that the customer is connected to use the GIS unique asset ID This information should be recorded in a standard format so that the data can be queried in the Oracle database at a later stage e g the note field should contain a record stating CB Ref CBXXXXXYYYYY only 3 When customers order a vacuum truck service this event should be recorded in the customer contact part of the billing system This will facilitate planning for onsite sanitation demand and perhaps help prioritise sewer expansions 4 Customer locations should be recorded in the notes field in a standard format e g Xcoord XXXXXX Ycoord YYYYYY every time a new customer connects to the water or sewerage network This information will be available on the hard copies of the connection forms which are filled in by the crews who construct the connection box Priority MED Responsibility AAWSA I T and Billing departments Sewerage dept Target completion date June 2010 5 6 Field surveys of network assets Sewer assets need to be surveyed on the basis of manholes with the form provided in Section 4 1 We have suggested and target data collection rate of 10 manholes and 30 connection boxes per week per branch This should enable the authority to collect all asset data within a year Priority should be given to trunk sewers so that network modelling can start in July 2010 Priority MEDIUM Responsibility AAWSA Sewerag
78. ystem UTM WGS84 Zone 37 Northern Hemisphere This done using Settings and Project Properties Partners for Water and Sanitation Page 42 January 2010 Partners for Water and Sanitation GIS and Asset Inventory Project AAWSA Ethiopia Matt Rose Alex Nash Atkins Ltd January 2010 Quantum GIS 1 0 2 Kore AAWSA Sewer Layout 3 7 Project Properties File Edit View Layer Plugins Tools Help J Project Properties P General Coordinate Reference System CRS A Custom CRS Title and colors gaeh Options Project title N i Oy Py Cy CA y 4 K Cy Selection color Background color Map units Meters Decimal degrees Precision Automatic Manual ES decimal places Digitizing Enable topological editing X Avoid intersections of new polygons Snapping options Cancel Select Coordinate Reference System and choose the following e Projected Coordinate System e Universal Traverse Mercator UTM e WGS84 Zone 37 North This can be entered as the following string proj utm zone 37 ellps WGS84 datum WGS84 units m no_defs Project Properties General Coordinate Reference System CRS Enable on the Fly CRS transformation Coordinate Reference System EPSG WGS 84 UTM zone 35N 32635 WGS 84 UTM zone 355 32735 WGS 84 UTM zone 36N 32636 WGS 84 UTM zone 365 32736 WGS 84 UTM zone 37N WGS 84 UTM zone 375 32737 3080 WGS 84 UTM zone 38N 32638 3015 WGS 84 UTM zon

Download Pdf Manuals

Related Search

Related Contents

溝掘機 OM311/OM1000  i.Beat cebrax 2.0 FM  ユーザーマニュアル - KDDI Mobile  建築物外皮による空調負荷低減等技術 実証試験結果報告書 《詳細版》  Camplifier 360 - KPA Solutions  instruction manual and technical datas manuel des - Unox  La sélection de la semaine  Mic 2 - Premier  

Copyright © All rights reserved. Failed to retrieve file