Goals of the task
The goal is to compile data and information on existing and planned supply and disposal infrastructure and related capacities of the RP sectors (energy, water/ wastewater, waste and urban agriculture/ food systems) and contribute to material flow analysis (WP4) and modelling (WP5). The data gathering is based on existing literature as well as field work activities. The task is focused on physical infrastructure facilities but also reflects the whole system of each sector – including flow-based components such as consumption/ access.
Work done to achieve the goals
During the past two years, TUB analysed existing literature gathered via desktop research and during missions in all three case cities. The completion of the task relied on close cooperation with RP sector experts regarding networking with sectoral experts and authorities (counterparts) in the case cities and asking for relevant documents. RP sector experts also gave feedback on data processing, such as chart structure and data validity. During the missions, meetings between TUB or respective RP sector experts and sectoral authorities were arranged to request basic data on the topic.
The most important sources are comprehensive official reports such as masterplans, sectoral infrastructure plans, statistical yearbooks and official geodata (or at least pictures of geodata such as .jpg or .pdf, which had to be traced). When available, these were scanned first to extract coherent sets of data. Additionally, relevant data was gathered via desktop research for open documents, such as project descriptions, new articles, lectures, scientific papers or website representation of authorities. Regarding the maps, to complement readily provided geodata, satellite images and open source data such as Openstreetmap were assessed. Gathered data and information was analysed, extracted and organised in data charts, respectively arranged and compiled in sectoral maps.
Contradicting information from the different sources was highlighted in the documents. To enable RP sector experts to comment on data gaps and data validity, a column was added to the data charts. After compiling gathered data and information, it was possible to reveal data gaps. As a final step, data request letters were prepared in close cooperation with partners from WP3 and WP4 and RP sector experts and addressed to local authorities to ask for missing information or raise questions on contradicting data. This process was supported by the LPMs. As some RP tasks are partly overlapping, gathered data from other workpackages such as Task 3.6 were integrated into the datasets.
Results so far
It was possible to consolidate the data situation and contribute to material flow analysis and modelling in Kigali and Da Nang. A few data gaps remain either because the desired data does not exist or because it has not been handed out yet.
On the contrary, only very little information is available this far for Assiut. Even though the initial portfolio is very promising and a comprehensive GIS dataset does exist, these have not been provided by the General Office of Physical Planning (GOPP). Accessibility was only given to publically available documents which in this case comprise solely the map of the strategic plan but not the written document or detailed sectoral plans. A formal request for permission of access to the Strategic plan is still underway (see Task 0.3 Focal Points of the case cities). Statistical yearbooks for Assiut are not available so far. The open source documents (secondary literature) handed out revealed only a very little amount of needed hard facts and maps.
D-1.1 Compilation of quantitative and qualitative inventory of supply and disposal infrastructure for the case cities
The datasets (excel files) of Kigali and Da Nang contain most of the needed information and data. As the requirements of the RP project methodology become clearer, TUB started to add a key data table excel sheet for each sector, reflecting only the most important hard facts and aligning them in consistent data rows.
D-1.2 Visualisation (set of maps) of these facilities within the administrative boundaries
For all sectors, maps were prepared and exported as easy-to-read PDF files and compatible shapefiles. The PDF maps were edited with a thoughtful fine tuning of content, colour set and symbols to make them easily accessible for all team members and local partners. To give an example a map is attached to this document (see Fig. 15). The shapefiles were generated to be used within the modelling process. CAD-files were structured via databases with the software Vectorworks to export consistent shapefiles. The integrated databases are a crucial by-product (dbf-format) of the shapefile-export. Further TUB installed access to the RP data warehouse in cooperation with U-Tueb via File Zilla. A suitable data structure to share the data on the supply and disposal infrastructure was created and established. Shapefiles were exported, checked via the software QGIS and if applicable corrected. The shapefiles were then uploaded to the data warehouse.
With further progression of the model in Task 5.4, the requirements for integration of the maps became clearer. Upon request, TUB exported high-resolution PNG files with a similar layout of the easy-to-read PDFs which will be used as a visual background of the model.
TUB kept updating the maps as required. The only major aspect missing is the electricity distribution network of Da Nang, which is only available as a low-resolution picture. It is known, that the GIS data exists and which departments possess it. TUB continues requesting the required information through the format of the data request letter.
Fig. 15: Map of water supply infrastructure in Kigali showing water treatment plants, water tanks, pipelines