Framework for WASH Sector Data Improvements in Data-Poor Environments , Applied to Accra , Ghana

Improvements in water, sanitation and hygiene (WASH) service provision are hampered by limited open data availability. This paper presents a data integration framework, collects the data and develops a material flow model, which aids data-based policy and infrastructure development for the WASH sector. This model provides a robust quantitative mapping of the complete anthropogenic WASH flow-cycle: from raw water intake to water use, wastewater and excreta generation, discharge and treatment. This approach integrates various available sources using a process-chain bottom-up engineering approach to improve the quality of WASH planning. The data integration framework and the modelling methodology are applied to the Greater Accra Metropolitan Area (GAMA), Ghana. The highest level of understanding of the GAMA WASH sector is achieved, promoting scenario testing for future WASH developments. The results show 96% of the population had access to improved safe water in 2010 if sachet and bottled water was included, but only 67% if excluded. Additionally, 66% of 338,000 m3 per day of generated wastewater is unsafely disposed locally, with 23% entering open drains, and 11% sewage pipes, indicating poor sanitation coverage. Total treated wastewater is <0.5% in 2014, with only 18% of 43,000 m3 per day treatment capacity operational. The combined data sets are made available to support research and sustainable development activities.


Introduction
According to the WHO and UNICEF in 2015, 2.4 billion people (33% of the global population) lacked access to improved sanitation facilities and 663 million people (9% of the global population) The datasets are compared, integrated, and used either to calculate parameters or as input variables in material conversion steps.A conversion step x = 1, 2, 3, …, n, is described by a set of flows j = 1, 2, 3, …, n which can be an input I_(x,j), or output O_(x,j), and calculated using one or more variables and parameters.In addition to standard flow estimates, spatial distributions for the cityregion districts k = 1, 2, 3, …, n were calculated so as to reflect spatial differences.
The system boundaries and conversion steps are chosen to depict the entire urban water and sanitation system, from raw-water intake to final discharge of untreated and treated wastewater.An overview of the 9 steps and 28 flows quantified as part of the study can be found in Figure 1 below.Since all water and sanitation flows are mapped, a complete description of the flows is obtained.
The nine conversion steps are then translated into a series of 34 material flow equations, which are described in the next sections with parameters listed in Table 1 below, alongside related variables and evaluated parameters.In Section 2.2, the methodology to obtain or calculate variable data and parameters is described for a specific area, including the amount of human urine and faeces generated in the context of developing countries.This framework specifies what data needed to be collected, and this can be repeated for other case studies.

Centralized Source Water Treatment
The estimates for raw to potable water were based derived from literature values on raw water treatment capacity, W, and treated water values at the plant sites, so as to derive the source water output value from central treatment plants, Equation (1).The parameter value ∝ for source water treatment plant efficiency was estimated to be 0.85 based on the difference between capacity and actual treated output.
O , = ∝ W (1) It was also assumed that there are no losses in the conversion from raw water to potable water at a central treatment site, such that raw water input equals potable water output, Equation (2), to estimate water abstraction.

Centralized Source Water Treatment
The estimates for raw to potable water were based derived from literature values on raw water treatment capacity, W, and treated water values at the plant sites, so as to derive the source water output value from central treatment plants, Equation (1).The parameter value ∝ for source water treatment plant efficiency was estimated to be 0.85 based on the difference between capacity and actual treated output.O 1,1 = ∝ W l (1) It was also assumed that there are no losses in the conversion from raw water to potable water at a central treatment site, such that raw water input equals potable water output, Equation (2), to estimate water abstraction.

Potable Water Distribution
The spatial distribution of central water treated supply was estimated using a three-step procedure.First, the total water lost in the pipe line system was established using Equation (3) for distribution losses and Equation (4) for water intake after distribution.
The distribution losses were established based on inputs I, a pipe loss parameter β representing leaked water, and the distribution of central output to each area φ k with index k = 1, 2, ..., n.The total aggregated supplied values were allocated to districts based on the calculated spatial distribution parameter φ for each district k, from the distribution of population members in piped areas per district including proportional reduction for the percentage of supply days (see online Supplementary Materials C).It was also assumed that the potable water input into distribution was equivalent to output from the central source water treatment plants, Equation (5).
The value for physical losses from pipeline system leakages was from the literature found to be 27% of treated water volume [16].The value relates solely to leakage estimates, as opposed to Non-Revenue Water (NRW) which takes into account all unaccounted for water including non-paid usage.

Domestic Water Use
Total water use for domestic purposes was established via bottom-up analysis.The population is divided into socio-economic, m = 1, 2, . . ., n and age groups p = 1, 2, . . ., n to differentiate between water user types.The total water use is based on the multiplication of a parameter, γ, denoting water consumption in liters per capita for a socio-economic group, with the number of people P in a socio-economic group, resulting in Equation (6).It was further assumed that local losses occurred at a rate of δ at household sites resulting in Equation (7), converting centrally distributed piped water I 3,1 into water losses O 3,1 .Thereby water available to households (and thereby outputs from households) from centralised water sources become Equation (8), and total available water including local water sourcing is expressed as Equation (9).
O 3,1 = δI 3,1 To obtain socio-economic groups occupation and employment values were translated into income groupings of low-medium-high income and related to non-drinking water sourcing access per household income category using sequential association, resulting in 30 groups per district, based on the ranking of private pipe access > public tap/stand pipe > protected spring or well or rainfall > tanker/vendor supply > unprotected spring or well or waterbodies in relation to income categories.Subsequently, groups with piped water access were split into rationed and continuous supply using supply rationing proportions to obtain the population P m per socio-economic group values for Equation (6).

Non-Domestic Water Use
The total water use for non-domestic purposes was established using Equation (10).The parameter ε denotes the proportion of central distributed flows I 4,1 for non-domestic purposes, which with the addition of locally sourced water I 4,2 , and output losses O 4,2 , so as to obtain total non-domestic water use and outputs O 4,1 .The parameter ε is differentiated for three sectors of the economy n = 1, 2, . . ., n and was based on values of 21%, 11%, and 13% water use share from total GWCL central pipe water supplied by commercial, industrial, and institutional sectors, respectively [16].Similarly, to domestic water use, a local water loss ratio was assumed using parameter ζ to obtain water consumed and output from non-domestic users Equation (11).As a result, total non-domestic waste water generation O 4,2 can be estimated from water influx I 4,1 minus local loss outputs O 4,1 resulting in Equation (12).
The used water value can be translated to generated wastewater by taking into account on-site losses, such as from evaporation, local leakage, or incorporation into products.Such losses have been estimated to vary between 10% and 40% in urban water systems [17].In the absence of indicative data, a loss value of 10% was assumed for both the parameter δ to calculate Equation (7) and parameter ζ to calculate Equation (11) for domestic and non-domestic losses, respectively.

Local Water Sourcing
The values for local water sourcing by decentralised means, such as boreholes, springs, wells and water bodies, were indirectly estimated since technology capacity data is not available.The domestic usage was derived from literature value D for each water source type O = 1, 2, . . ., n, such that O 5,1 = D o Equation (13).Company sourcing was determined from the list of licensed users in the water use register of the Water Resources Commission [18].The number of companies sourcing water locally, N n , was multiplied by a parameter for the amount sourced η, resulting in Equation (14).Total local water sourced inputs are equal to both non-domestic and domestic water outputs Equation (15).

Human Excreta Production
The amount of urine and faeces generated was based on population members P m,p by age group p = 1, 2, . . ., n per district m = 1, 2, . . ., n.The values were multiplied by the parameter ϑ denoting litres of urine excreted per age group resulting in Equation ( 16), to obtain Urine output O 6,1 .Similarly for excreta the parameter κ was used denoting faeces excreted per day per age group resulting in Equation (17).It was further assumed that there were no losses between human excreta production and toilet inputs yielding Equations ( 18) and (19).
The values used for parameter ϑ were 1.16 L and 0.8 L of urine excreted per day for groups of 15+ and 0-14 years, respectively.And for parameter κ values of 0.33 and 0.13 kg of faeces excreted per day for the 15+ and 0-14 year age groups were used, respectively.The parameter values were derived from a literature review of 15 studies (see online Supplementary Materials A).

Sewage Discharge at Collection Point
The calculated wastewater values were translated into discharge into local terrains, open drains, or sewage pipes based on a proportion of wastewater discharged λ per discharge route q = 1, 2, 3 for generated wastewater.Three discharge routes were assumed q = 1 for local soils, q = 2 for open drains, and q = 3 for sewage pipes, resulting in three equations Equations ( 20)- (22).Proportions were established from liquid waste disposal census data (see online Supplementary Materials C).The assumptions were made that sewage piped wastewater is routed towards treatment systems, open drain discharge is disposed into waterbodies, and local terrain discharge enters soils.

Toilet Use
The discharge of human excreta I 8,3 starts with the sum of urine and faeces inputs Equation (23).First, the proportion of inputs to outputs in terms of toilet types µ r were established based on r = 1 for open defecation, r = 2 for pan and bucket latrines, r = 3, for private water closets, r = 4 for pit latrines and septic tanks, and r = 5 for public toilets.A combined output route for open defecation and pan and bucket latrines Equation (24), was made, since these are not connected to sewage systems.Also a combined output route was made for private water closets and public toilets Equation (25), as a proportion of these are connected to the centralised sewage system.The third route is for pit latrines, which are emptied by cesspit tanker vehicles.
O 8,4 = λ r (µ 3 + µ 5 )I 8,3 Leakage losses into the sub-soil were estimated using Equation (26).The equation takes the loss proportion based on a private systems subsoil leakage rate ξ, and a public systems leakage rate ν, and multiplies it with the total excreta discharge I 8,3 accounting for the proportion routed to private toilets not connected to central sewage systems (1 − λ r )µ 3 , the proportion of pit latrines µ 4 , and the proportion of public toilets not connected to sewage systems (1 − λ r )µ 5 , with the parameter λ r denoting the proportion of water closets and public toilets connected to sewage systems.It was assumed that the human excreta that was not leaked was collected by cesspit emptier vehicles for further treatment or disposal Equation (27).
The equations takes into account that in case of pit latrine or septic tanks systems discharge, it was taken into account that a large liquid share will drain into the sub-surface due to bottom latrine porosity and septic drain field discharge.The sub-soil drainage rate was assumed different for public and private toilet systems because public systems have better structures which are more efficiently enclosed and emptied within weeks to months, whilst private systems typically have more porous structures and are emptied once every five to ten years.Values were established at 87% leakage for sub-soil leakage from private systems ξ, and 50% for leakage from public systems ν, based on literature values [19][20][21][22][23][24][25].

Sewage Treatment
The proportion of sewage treated in centralized treatment plants was established in two ways.First, the proportion of wastewater treated in sewage plants, and proportion of human excreta treated in sewage plants was established, from the three input routes cesspit emptier collection Equation (28), centralised piped intake of human excreta Equation (29), and for centralized piped intake of wastewater Equation (30).
Thereby taking into account the proportion of wastewater which is centrally treated, and σ, the proportion of human excreta that is centrally treated, this results in the amount of centrally treated Sewage Equation (31).The residual sewage is not treated and disposed of at cesspit emptier truck dump sites, or by direct discharge into the sea or other water bodies, as represented by Equation (32).These values should match up with the top-down calculation of sewage treated in centralised waste water treatment plants, based on operational sewage treatment capacity S s , and the sewage treatment plant efficiency υ s , for each technology s = 1, 2, . . ., n. Thereby the treatment output should equate to Equation (33).Finally, the sum of treated and untreated discharged outputs should be equivalent to inputs from the three input routes cesspit emptiers, centralised piped human excreta intake, and centralised piped wastewater intake Equation (34).
O 9,1 = υ s S s (σ(I 9,1 + I 9,3 ) + I 9,2 ) The treatment capacity of sewage plants per technology was evaluated by creating an inventory of treatment plants, starting with a survey carried out in 2011-2012 on the operational status of all sewage treatment plants (STPs) in GAMA [26], which for this paper was reviewed and updated with newer studies and local news report updates as referenced in the results.

Application to the Greater Accra Metropolitan Area
The study subject GAMA was defined on the basis of the administrative districts governed by assemblies with decentralized power by the Government of Ghana since 1993 [27].The geographic boundary definition of GAMA as a city region used in this paper was defined by local stakeholders using the Metropolitan and Municipal District Assembly (MMDA) structures in the country [10]; for details, see Table S1 in Supplementary Material C. The definition includes 15 districts, with the Accra and Tema Metropolitan Districts as the most populous and home to the majority of economic activity.The used spatial outline of MMDAs in GAMA is shown in Figure 2, and the historic boundary development of the MMDAs since 1988 can be found in the online Supplementary Material A. The year 2010 was selected as the year of analysis as this is the last year with baseline data from the Ghanaian Census; nevertheless, more recent figures were included when available.
Water 2018, 10, x FOR PEER REVIEW 10 of 25

Application to the Greater Accra Metropolitan Area
The study subject GAMA was defined on the basis of the administrative districts governed by assemblies with decentralized power by the Government of Ghana since 1993 [27].The geographic boundary definition of GAMA as a city region used in this paper was defined by local stakeholders using the Metropolitan and Municipal District Assembly (MMDA) structures in the country [10]; for details, see Table S1 in Supplementary Material C. The definition includes 15 districts, with the Accra and Tema Metropolitan Districts as the most populous and home to the majority of economic activity.The used spatial outline of MMDAs in GAMA is shown in Figure 2, and the historic boundary development of the MMDAs since 1988 can be found in the online Supplementary Material A. The year 2010 was selected as the year of analysis as this is the last year with baseline data from the Ghanaian Census; nevertheless, more recent figures were included when available.

Data Collection and Integration
The data required for WASH descriptive modelling as specified by the framework was sourced from documentation and from local authorities and water company officers.For data collection from documentation, several hundred literature studies, reports, news articles, and media reports were screened, out of which key datasets were incorporated into the study, in order to provide the most comprehensive quantification feasible within the limited data availability.The data screening criteria included: (1) time-data post 2008 was considered, (2) location-data relevant to GAMA was taken into account; (3) system boundaries-data with clearly defined system boundaries and units was preferred.The flow assessment was limited to the year 2010, primarily due to availability of household infrastructure use data from the Ghana Statistical Service [28][29][30][31][32][33][34][35][36][37][38][39][40][41][42].If data from recent years were available, these were incorporated into the study.Moreover, as part of the study, contact was sought with local officers in GAMA at the Ghana Water Company Limited (GWCL) to update water treatment, pipeline system, and rationing data (GWCL, Managing Director Frederick Christian Lokko, personal communication, 19 November 2015).In addition to WASH flow data, surface water quality measurements were collected and integrated from the literature to provide for a summary of known datasets in this domain.The data were collected and integrated in MS Excel spreadsheets and in QGIS [43] for spatial mapping purposes.The calculations were carried out in MS Excel for each of the 15 MMDAs, and subsequently aggregated to provide for the total GAMA estimates.

Data Collection and Integration
The data required for WASH descriptive modelling as specified by the framework was sourced from documentation and from local authorities and water company officers.For data collection from documentation, several hundred literature studies, reports, news articles, and media reports were screened, out of which key datasets were incorporated into the study, in order to provide the most comprehensive quantification feasible within the limited data availability.The data screening criteria included: (1) time-data post 2008 was considered, (2) location-data relevant to GAMA was taken into account; (3) system boundaries-data with clearly defined system boundaries and units was preferred.The flow assessment was limited to the year 2010, primarily due to availability of household infrastructure use data from the Ghana Statistical Service [28][29][30][31][32][33][34][35][36][37][38][39][40][41][42].If data from recent years were available, these were incorporated into the study.Moreover, as part of the study, contact was sought with local officers in GAMA at the Ghana Water Company Limited (GWCL) to update water treatment, pipeline system, and rationing data (GWCL, Managing Director Frederick Christian Lokko, personal communication, 19 November 2015).In addition to WASH flow data, surface water quality measurements were collected and integrated from the literature to provide for a summary of known datasets in this domain.The data were collected and integrated in MS Excel spreadsheets and in Water 2018, 10, 1278 11 of 24 QGIS [43] for spatial mapping purposes.The calculations were carried out in MS Excel for each of the 15 MMDAs, and subsequently aggregated to provide for the total GAMA estimates.

Raw Water to Source Water
The estimates for raw to potable water were derived from literature values on raw water treatment capacity and treated water values at the plant sites.The three central water treatment sites, (see Table 2), operating in GAMA informed the treatment capacity value W in Equation (1).
Historic figures for treated potable water supplied into the centralised distribution network were taken from [15,44,45] and complemented with 2014 plus 2015 values provided by GWCL.The parameter value ∝ for source water treatment plant efficiency was estimated to be 0.85 based on the difference between capacity and actual treated output.
The values for local water sourcing by decentralised means, such as boreholes, springs, wells and water bodies, were indirectly estimated since technology capacity could not be located.The domestic usage was derived from total bottom-up use estimates (see Supplementary Material C), and company sourcing was determined from the list of licensed users in the water use register of the Water Resources Commission [18].The number of companies sourcing water locally, N n , as per Equation ( 14), was thereby estimated to be 7 within the GAMA region.The parameter for the amount-sourced η was conservatively estimated at 1000 m 3 per day for each company.* Conventional technologies are defined following the American Water Works Association (AWWA) guidelines.

Source Water Distribution
The spatial distribution of central water treated supplies was estimated using a three-step procedure.First, the total water lost in the pipeline system was established using the pipe loss parameter β and Equations ( 3) and (4).The value for physical losses from the pipeline system leakages was from the literature and found to be 27% of treated water volume [16].The value relates solely to leakage estimates, as opposed to Non-Revenue Water (NRW), which takes into account all unaccounted-for water including non-paid usage.Second, the spatial areas and population therein with continuous piped supply and 2+ days of rationed supply per week were calculated including the percentage of days with no supply.The spatial maps and allocation (see Figure 3) were created on the basis of a piped area and a rationing scheme map obtained from GWCL, and census population data [28][29][30][31][32][33][34][35][36][37][38][39][40][41][42].The rationing scheme in place is imposed on approximately 63% of the area with central pipe supply.Finally, the total aggregated supplied values were allocated to districts based on the calculated spatial distribution parameter φ for each district k, from the distribution of population members in piped areas per district including proportional reduction for the percentage of supply days (see online Supplementary Material C).

Potable Water Use and Local Sourcing
The total water use for non-domestic purposes was established via the parameter ε for proportion of central distributed flows used for non-domestic purposes.The parameter was based on values of 21%, 11%, and 13% water use share from total GWCL central pipe water supplied by commercial, industrial, and institutional sectors, respectively [16].Total water use for domestic purposes was established via bottom-up analysis.
Firstly, socio-economic groups were established per district using population numbers for employment status, occupation, and non-drinking water sourcing [28][29][30][31][32][33][34][35][36][37][38][39][40][41][42].The occupation and employment values were translated into income groupings of low-medium-high income and related to non-drinking water sourcing access per household income category.The method was sequential association, resulting in 30 groups per district, based on the ranking of private pipe access > public tap/stand pipe > protected spring or well or rainfall > tanker/vendor supply > unprotected spring or well or waterbodies in relation to income categories.Subsequently, groups with piped water access were split into rationed and continuous supply using supply rationing proportions (Supplementary Material C) to obtain the population P per socio-economic group values for Equation (6).
Secondly, to achieve the demand data, the number of people in each group was multiplied by a water consumption per capita value, taking into account the income status and supply type.The values used for the parameter γ , water consumption per capita by socio-economic group, are summarised in Table 3 as obtained from four literature studies [55,56].
Thirdly, per capita use values per socio-economic group were multiplied by population numbers and aggregated to the district level to obtain total water use and sourcing categories including decentralised, improved protected, unimproved decentralised, and tanker/vendor-based pipe supply.Decentralised pipe-based supply was calculated by subtracting central pipe supply delivered (Section 2.2.3) from total domestic pipe supply as calculated, including correction for supply to nondomestic customers.

Potable Water Use and Local Sourcing
The total water use for non-domestic purposes was established via the parameter ε for proportion of central distributed flows used for non-domestic purposes.The parameter was based on values of 21%, 11%, and 13% water use share from total GWCL central pipe water supplied by commercial, industrial, and institutional sectors, respectively [16].Total water use for domestic purposes was established via bottom-up analysis.
Firstly, socio-economic groups were established per district using population numbers for employment status, occupation, and non-drinking water sourcing [28][29][30][31][32][33][34][35][36][37][38][39][40][41][42].The occupation and employment values were translated into income groupings of low-medium-high income and related to non-drinking water sourcing access per household income category.The method was sequential association, resulting in 30 groups per district, based on the ranking of private pipe access > public tap/stand pipe > protected spring or well or rainfall > tanker/vendor supply > unprotected spring or well or waterbodies in relation to income categories.Subsequently, groups with piped water access were split into rationed and continuous supply using supply rationing proportions (Supplementary Material C) to obtain the population P m per socio-economic group values for Equation (6).
Secondly, to achieve the demand data, the number of people in each group was multiplied by a water consumption per capita value, taking into account the income status and supply type.The values used for the parameter γ, water consumption per capita by socio-economic group, are summarised in Table 3 as obtained from four literature studies [55,56].
Thirdly, per capita use values per socio-economic group were multiplied by population numbers and aggregated to the district level to obtain total water use and sourcing categories including decentralised, improved protected, unimproved decentralised, and tanker/vendor-based pipe supply.Decentralised pipe-based supply was calculated by subtracting central pipe supply delivered (Section 2.2.3) from total domestic pipe supply as calculated, including correction for supply to non-domestic customers.

Wastewater and Human Excreta Generation
The used water value can be translated into generated wastewater by taking into account on-site losses, such as from evaporation, local leakage, or incorporation into products.Such losses have been estimated to vary between 10% and 40% in urban water systems [17].In the absence of indicative data, a loss value of 10% was assumed for both the parameter δ in Equation ( 7) and parameter ζ in Equation ( 11) for domestic and non-domestic losses, respectively.
The amount of urine and faeces generated was based on population members by age group P m,p per district.The values were multiplied by the parameter ϑ values of 1.16 L and 0.8 L of urine excreted per day for groups of 15+ and 0-14 years, respectively, and by the parameter κ values of 0.33 and 0.13 kg of faeces excreted per day for the 15+ and 0-14 year age groups, respectively.The parameter values were derived from a literature review of 15 studies (see online Supplementary Material A).
The discharge of human excreta was informed by the parameter µ r describing the proportion of toilet types used by the population with data from [28][29][30][31][32][33][34][35][36][37][38][39][40][41][42] (see online Supplementary Material C).The excreta routed into water closet (W.C.) was split into two groups: W.C. connected to sewage systems, and W.C. connected to septic tanks, expressed via proportions using the parameter λ q based on liquid waste disposal data [28][29][30][31][32][33][34][35][36][37][38][39][40][41][42].In the case of pit latrine or septic tanks systems discharge, it was taken into account that a large liquid share will drain into the sub-surface due to bottom latrine porosity and septic drain field discharge.The sub-soil drainage rate was assumed different for public and private toilet systems, because public systems have better structures which are more efficiently enclosed and contained, and emptied within weeks to months, whilst private systems typically have more porous leak-prone structures and are emptied once every five to ten years.Values were established at 87% leakage for sub-soil leakage from private systems ξ, and 50% for leakage from public systems ν, based on literature values [19,21,23].

Sewage Treatment
The treatment of sewage was calculated by creating an inventory of treatment plants, their technology and capacity.The main dataset was taken from a survey carried out in 2011-2012 on the operational status of all sewage treatment plants (STPs) in GAMA [26], which, for this publication, was reviewed and updated with newer studies and local news report updates as referenced in the results.

Results: Water, Sanitation and Hygiene Data for the Greater Accra Metropolitan Area in Ghana
The complete year 2010 analysis results for the GAMA are presented in Figures 4 and 5 as Sankey diagrams below, from raw water to wastewater discharge, and from human excreta generation to discharge, respectively.The results for individual components and districts are presented in detail in Sections 3.1-3.6below.An overview of parameters established to carry out the material flow analysis is provided in Table 1, as described in Section 2.1.The areas in GAMA supplied by the pipe and rationing scheme as of August 2015 are shown in Figure 3.The evolution of total central water treatment capacity in GAMA from 1980 to 2015 is displayed in Figure S1 in Supplementary Material B. The domestic water use in the districts of GAMA in 2010 is shown in Figure S2 in Supplementary Material B. The wastewater and human excreta generation estimates in GAMA per district for 2010 by sink are provided in Figure S3 in Supplementary Material B. The proportions of wastewater and human excreta ending up in the environment and collected via sewage pipes and cesspit-tankers are illustrated in Figure S4 in Supplementary Material B. Figures S1-S4 are available in Supplementary Material B.
Water 2018, 10, x FOR PEER REVIEW 14 of 25

Results: Water, Sanitation and Hygiene Data for the Greater Accra Metropolitan Area in Ghana
The complete year 2010 analysis results for the GAMA are presented in Figures 4 and 5 as Sankey diagrams below, from raw water to wastewater discharge, and from human excreta generation to discharge, respectively.The results for individual components and districts are presented in detail in Sections 3.1-3.6below.An overview of parameters established to carry out the material flow analysis is provided in Table 1, as described in Section 2.1.The areas in GAMA supplied by the pipe and rationing scheme as of August 2015 are shown in Figure 3

Central Source Water Treatment and Distribution
The calculated 1980-2015 GAMA central water treatment capacity is shown below in Figure 6A, as well as total estimated water supply to GAMA residents from 1980 to 2015 (Figure 6B), and the 2010 distribution per district (Figure 6A).The results showed that total water supplied increased by 40% from 2010 to 2015, or from 285 to 374 m 3 per day, due to expansions at Kpong treatment and the

Central Source Water Treatment and Distribution
The calculated 1980-2015 GAMA central water treatment capacity is shown below in Figure 6A, as well as total estimated water supply to GAMA residents from 1980 to 2015 (Figure 6B), and the 2010 distribution per district (Figure 6A).The results showed that total water supplied increased by 40% from 2010 to 2015, or from 285 to 374 m 3 per day, due to expansions at Kpong treatment and the Teshie desalination plant opening.In total, the central pipe network supplied ~66% of the population with potable water in 2010, and approximately 50% utilised it as their main drinking water source.The ~16% difference is plausibly explained by diminished water quality due to ageing metal pipes introducing rust, occasional soil plus faecal contamination from burst pipes, and general distrust of pipe-supplied water from previous contamination incidents [59][60][61].The outcome of the 2014/2015 supply expansion on water access is not clear, beyond that it appears to have significantly improved the water rationing situation that was imposed by GWCL [53].

Central Source Water Treatment and Distribution
The calculated 1980-2015 GAMA central water treatment capacity is shown below in Figure 6A, as well as total estimated water supply to GAMA residents from 1980 to 2015 (Figure 6B), and the 2010 distribution per district (Figure 6A).The results showed that total water supplied increased by 40% from 2010 to 2015, or from 285 to 374 m 3 per day, due to expansions at Kpong treatment and the Teshie desalination plant opening.In total, the central pipe network supplied ~66% of the population with potable water in 2010, and approximately 50% utilised it as their main drinking water source.The ~16% difference is plausibly explained by diminished water quality due to ageing metal pipes introducing rust, occasional soil plus faecal contamination from burst pipes, and general distrust of pipe-supplied water from previous contamination incidents [59][60][61].The outcome of the 2014/2015 supply expansion on water access is not clear, beyond that it appears to have significantly improved the water rationing situation that was imposed by GWCL [53].
Since the late 1990s, the use of sachet water has grown considerably, as the small 250-500 mL plastic bags are a conveniently available source of drinking water [14].Several hundred small to large filling companies of sachet waters have sprung into existence, which supplied sachets to a total of 29% of households in 2010 as a main drinking water source [28][29][30][31][32][33][34][35][36][37][38][39][40][41][42].Bottled water only served 1% of the population for their drinking water.If sachets and bottled water would be of consistently supplied at high water quality and counted as improved water sources, a total of 96% of the population had access to improved safe water in 2010, otherwise only 67% had improved safe water access in 2010.

Domestic and Non-Domestic Water Consumption
Total domestic water use from all sources was calculated at 298 thousand m 3 per day, of which 211 thousand m 3 was from the central GWCL pipe system, 74 thousand m 3 from improved decentralised sources, and 13 thousand m 3 from unimproved decentralised sources.An overview per district is shown in Figure 7 including central pipe, improved decentralised, and unprotected decentralised sources.Total non-domestic supplies were estimated at 77 thousand m 3 per day in 2010.
plastic bags are a conveniently available source of drinking water [14].Several hundred small to large filling companies of sachet waters have sprung into existence, which supplied sachets to a total of 29% of households in 2010 as a main drinking water source [28][29][30][31][32][33][34][35][36][37][38][39][40][41][42].Bottled water only served 1% of the population for their drinking water.If sachets and bottled water would be of consistently supplied at high water quality and counted as improved water sources, a total of 96% of the population had access to improved safe water in 2010, otherwise only 67% had improved safe water access in 2010.

Domestic and Non-Domestic Water Consumption
Total domestic water use from all sources was calculated at 298 thousand m 3 per day, of which 211 thousand m 3 was from the central GWCL pipe system, 74 thousand m 3 from improved decentralised sources, and 13 thousand m 3 from unimproved decentralised sources.An overview per district is shown in Figure 7 including central pipe, improved decentralised, and unprotected decentralised sources.Total non-domestic supplies were estimated at 77 thousand m 3 per day in 2010.

Waste Water and Human Excreta Generation
The total amount of wastewater generated was estimated at 338 thousand m 3 per day in 2010, of which 268 thousand m 3 was from the domestic origin.Values for human excreta were estimated at a total amount of 4070 m 3 of urine and 1040 m 3 of faeces generated per day.An overview of the wastewater, urine, and faeces generated per district is shown below in Figure 8.

Waste Water and Human Excreta Generation
The total amount of wastewater generated was estimated at 338 thousand m 3 per day in 2010, of which 268 thousand m 3 was from the domestic origin.Values for human excreta were estimated at a total amount of 4070 m 3 of urine and 1040 m 3 of faeces generated per day.An overview of the wastewater, urine, and faeces generated per district is shown below in Figure 8.

Wastewater and Sanitation Collection
The generated wastewater mainly ends up in open-drains connected to local lagoons and the sea, with less than 5% of households and buildings connected to a sewer system [62].The two main sewage systems in GAMA are established in the Accra Metropolitan and Tema Metropolitan Districts, with a few minor systems in existence at the site of University of Ghana Legon, hotels and

Wastewater and Sanitation Collection
The generated wastewater mainly ends up in open-drains connected to local lagoons and the sea, with less than 5% of households and buildings connected to a sewer system [62].The two main sewage systems in GAMA are established in the Accra Metropolitan and Tema Metropolitan Districts, with a few minor systems in existence at the site of University of Ghana Legon, hotels and large companies.
On the basis of sewerage figures, an estimated 222 thousand m 3 of wastewater generated in 2015 is discharged directly into the environment, 78 thousand m 3 into open-drains, and 38 thousand m 3 into a sewage pipe network.In terms of sanitation, 91% of human excreta or 4642 m 3 per day is estimated to end up in a variety of toilets systems, and 9% or 468 m 3 per day is directly discharged into the environment via either open defaecation or the use of bucket/pan latrines.However, there is a large variation between districts, as shown in the breakdown of toilet usage for GAMA in Table 4 below [28][29][30][31][32][33][34][35][36][37][38][39][40][41][42].Moreover, a large proportion of the population frequents public toilets which are usually 16 or 32 seater types of various make-up (e.g., W.C., improved pit latrines).Total improved toilet access in GAMA was estimated at 81% with a variation from 54% to 93% between districts.Data on public toilets installed is sparse, but generally, the hygienic standards of these toilets are low: in a survey study of four neighbourhoods, it was found that between 17% and 80% of public toilets are equipped with handwashing stations, and in 40% to 88% of public toilets, faecal matter is visibly present [63].
The numbers of private and public W.C. connected to the sewage systems are a minority.Total excreta entering W.C. is estimated at 1620 m 3 per day, of which 478 m 3 enters sewage pipes with the majority flowing into septic tanks.The primary collection is thereby carried out via cesspit-tankers, which suck human excreta out of pit latrines and septic tanks.A total estimate of 4165 m 3 per day of excreta enters septic tanks and pit latrine systems, out of which 2854 m 3 leaks into the sub-soil due to the porous latrine bottom and septic-tank field discharge.The remaining 1298 m 3 of excreta is collected via cesspit-emptier services, which, in 2010, were primarily emptied untreated at the 'Lavender Hill' site into the sea.The collected excreta values are similar to reported values by the approximately 125 cesspit-tankers in use in GAMA [62,64].Cesspit-tankers transport human excreta to the disposal site, which can be either treatment facility or the environment (e.g., lagoon or sea).Proportional values for human excreta and wastewater discharge route per district can be found in Figure 9 below.

Waste Water Treatment Capacity
The analysis found that the majority of STPs in GAMA are currently no longer operational due to historic breakdowns, in agreement with previous reports [65].As a consequence, any sewage routed into the central pipe systems in Acrra Metropolitan Area and Tema Districts is discharged untreated into the sea below the Korle Lagoon and into the Sakumo lagoon, respectively [62].The total amount of treated liquid waste in 2010 based on treatment capacity, as described below, was negligible at <0.01% for wastewater and human excreta.Since then, the situation has improved slightly with, as of 2014, a total of 0.5% of wastewater and 8% of human excreta estimated to have been treated.
In total, four larger public treatment plants have been built since 1997 with a joint capacity of 43 thousand m 3 , of which two were operational in 2016: The other existing significant larger STPs are mostly privately owned, for example, at the La Palm Royal Beach Hotel, Golden Tulip Hotel, and Nestle Ghana, with a joint service capacity of 750 m 3 per day.A small number of smaller plants have also been built, of which a total estimated 112 m 3 per day capacity is still operational, as dozens of older smaller plants have significantly degraded or have been removed [26].

Discussion
The study provides an integrated framework for aiding policymaking, using a approach based on material balances.It provides a comprehensive overview of key macro aspects of the WASH system for an urban environment, and to the knowledge of the authors, specifically for the case study of GAMA, it is the first bottom-up analysis based on mass balances, drawing from both literature and locally provided data and information.The WASH material flow methodology as outlined herein is a prerequisite for carrying out scenario analyses, because it provides a sound quantitative basis to rapidly examine the current status of water and sanitation flows, including validation via mass balances to reduce the plausibility of errors.Moreover, this physical flow-based bottom-up analysis combined with accurate WASH sector supply and demand data, provides a robust and unique platform for evaluating future scenarios to improve the urban WASH sector.
The quality of results is reliant on parameter accuracy.Data for the parameter on leakage in the pipe system was found to be limited with only rough estimates of pipe loss values based on the difference between the quantity of water sold and water treated.Additional analyses on physical loss from pipe leakages and improvements in order to reduce non-revenue water would be beneficial, as also indicated by the GWCL.A second area with limited data available was water use in non-domestic sectors, with only indirect estimates available from the GWCL.Data could be generated by carrying out company water use surveys, and by expanding water metering and meter maintenance within GWCL systems.
A large variation was found in parameters for water use per capita by socio-economic variables, income levels, the cost of water, and whether rationing is imposed.The challenge with the range of parameter values is that studies often only include potable water drawn from central pipe systems, and sourcing from other systems is not measured (Banafo, 2013;Lamptey, 2010).The values for rationing are therefore likely biased to lower values, since it can be expected that, when piped supplies are rationed, the population will source water from tankers/vendors or local systems.An exception is the study of [58], but here, only continuous to intermittently well supplied households were analysed.The key aspect of importance that deserves more analysis was found to be the difference between public flat rates and public variable rates, as set by the Public Utilities Regulation Commission (PURC), and private charges for water, which are typically ten to fifteen higher then public rates [72].
The key limitation in the study is the availability of more recent household data than 2010 to provide for a more up-to-date analysis.In particular, figures on household use of non-drinking and drinking water sources, toilets types, and liquid waste discharge were not available.The consequence is that it is difficult to analyse whether improved water and sanitation flows are on track at the level of households per district.A more frequent sub-survey, ideally in line with medium-term development plans of 2014, 2018, and 2022 in GAMA districts, could solve this planning deficit.
Another challenge is the interpretation of key indicators, such as access to improved sources of water, as these depend on definitions, e.g., which sources are included or excluded.In particular, the use of sachet water is key since in the WHO and United Nations (UN) definition it is not to be counted as improved.One reason is that water quality of sachets has been found to vary significantly, with occasionally elevated bacterial levels and faecal coliform counts [14].Notwithstanding, the availability of water sachets in GAMA presents one important improvement in recent times relative to no sachets.
Accra provides a transferable and representative case study because the WASH development level and data availability is similar to other developing countries.Urban planning in many developing countries is limited by the absence of an updated data-driven integrated assessment of urban water flows from raw water to wastewater treatment and discharge.The modelling methodology presented here provides well-defined flow-cycle phases for describing WASH-related flows and performance metrics to accurately characterize WASH flow-cycle.The following eight flow-cycle phases were established in this modelling methodology: (1) central water treatment; (2) potable water distribution; (3) local water sourcing; (4) domestic and non-domestic water use; (5) wastewater generation and toilet use; (6) human excreta production; (7) sewage transport; and (8) sewage treatment.The eight life-cycle phases were established as a standardized set to enable calculations of water and wastewater flows from sourcing to disposal, including sanitation.In comparison to currently available methods, this set of eight WASH flow-cycle phases provides an improved understanding of key data input requirements for WASH planning.These flow-cycle phases can be applied to an entire city or to districts to map potable water treatment, toilets requirements, wastewater treatment, and transport infrastructure needs relative to the current situation.The results can be used to obtain: (1) more accurate midto long-term scenarios for infrastructure requirements, at all levels of governance within the urban environment; and (2) quantification of the costs and benefits of system efficiency improvements, such as pipe loss reductions, versus water treatment expansions.
To highlight the main characteristics described above, the following metrics were applied to describe the WASH map: (1) fresh water use in m 3 , (2) wastewater generated in m 3 , (3) urine and excreta generated in m 3 , (4) proportion of adequately treated sewage in %.This bottom-up physical modelling methodology, consisting of well-defined flow-cycle phases and performance metrics, promotes the identification of the bottlenecks in WASH flows and WASH planning.In addition, this resource-flow modelling methodology also facilitates scenario testing to overcome these WASH flow and planning bottlenecks with minimal infrastructure material, energy, labour, time and financial investments and with maximal improvements in fresh water supply and wastewater treatment.In this way, optimal and efficient policies, prioritization and investments can be implemented to improve urban WASH sectors.

Conclusions
A data integration framework and a modelling methodology have been developed for obtaining a baseline understanding of water and sanitation systems in developing countries, where up-to-date district level data is not available.The framework and the model have been applied to GAMA, Ghana.For this application, data has been collected both from documents (e.g., journal articles, local studies and reports) and via personal communications from officials and local WASH service suppliers.The exact data needed was specified by the framework.Once all the data required by the framework was available, descriptive modelling calculations were performed based on the mass balance of water and sanitation flows.
On the basis of the flow data assessment, the WASH landscape has been mapped for GAMA and made available in one place for the first time.In this way, important insights have been gained on centralised raw water treatment, decentralised water sourcing, potable water rationing, improved water use, wastewater and excreta generation, toilet usage, toilet excreta collection, wastewater collection, and wastewater treatment.This framework and the corresponding modelling methodology offer a baseline understanding and open up avenues for improving the WASH sector in developing countries by repeating further data collection efforts guided by the steps and frameworks presented in this paper.

Supplementary Materials:
The following are available online at http://www.mdpi.com/2073-4441/10/9/1278/s1, Supplementary Material A (containing Table S1: Overview of change in GAMA administrative regions 1988-2012); Supplementary Material B (containing Figure S1: Total central water treatment capacity in GAMA in m 3 from 1980-2015, Figure S2: Total domestic water use estimate in GAMA per district for 2010 by supply source, Figure S3: Total wastewater and human excreta generation estimate in GAMA per district for 2010 by sink, Figure S4: Proportion of wastewater and human excreta ending up in the environment and collected via sewage pipes and cesspit-tankers); Supplementary Material C (containing Table S2: Water consumption in litres per capita per day by income, water sourcing, and rationing from secondary sources plus estimates, Table S3: Proportion of population with central pipe access in rationed areas and with continuous supply and final % of central water distribution per district, Table S4: Proportion of wastewater discharged onto local soils λ q = 1 , into open drains λ q = 2 , and into sewage pipes λ q = 3 , Table S5: Population proportion parameter values µ_r for use of toilet types and defaecation practices, Table S6: Toilet use proportions in GAMA districts as per the 2010 population census, Table S7: Parameters established for the material flow analysis.);Supplementary Material D (containing Table S8: Literature overview of studies on human urine excretion, Table S9: Literature overview of studies on human faeces excretion).

Figure 1 .
Figure 1.Overview of Water, Sanitation and Hygiene (WASH) flow calculations made in the study using mass-balance principles.

Figure 1 .
Figure 1.Overview of Water, Sanitation and Hygiene (WASH) flow calculations made in the study using mass-balance principles.

Figure 3 .
Figure 3. Zones in GAMA supplied by the pipe and rationing scheme as of August 2015 (areas with no access to pipe supply (red), areas with continuous pipe supply (blue), areas with rationed supply (yellow), water bodies (turquoise), and the pipe network (dark lines)).Source of data: Ghana Water Company Limited (GWCL), Accra, Ghana, map data © OpenStreetMap contributors.

Figure 3 .
Figure 3. Zones in GAMA supplied by the pipe and rationing scheme as of August 2015 (areas with no access to pipe supply (red), areas with continuous pipe supply (blue), areas with rationed supply (yellow), water bodies (turquoise), and the pipe network (dark lines)).Source of data: Ghana Water Company Limited (GWCL), Accra, Ghana, map data © OpenStreetMap contributors.
. The evolution of total central water treatment capacity in GAMA from 1980 to 2015 is displayed in Figure S1 in Supplementary Material B. The domestic water use in the districts of GAMA in 2010 is shown in Figure S2 in Supplementary Material B. The wastewater and human excreta generation estimates in GAMA per district for 2010 by sink are provided in Figure S3 in Supplementary Material B. The proportions of wastewater and human excreta ending up in the environment and collected via sewage pipes and cesspit-tankers are illustrated in Figure S4 in Supplementary Material B. Figures S1-S4 are available in Supplementary Material B.

Figure 4 .
Figure 4. Sankey diagram from 2010 GAMA raw water treatment to final wastewater discharge flows in m 3 per day.

Figure 4 . 25 Figure 5 .
Figure 4. Sankey diagram from 2010 GAMA raw water treatment to final wastewater discharge flows in m 3 per day.Water 2018, 10, x FOR PEER REVIEW 15 of 25

Figure 5 .
Figure 5. Sankey diagram from 2010 GAMA human excreta generation to final discharge flows in m 3 per day.A Kumasi Ventilated Improved Pit (VIP) is designed with two pits versus a single-pit VIP.

Figure 5 .
Figure 5. Sankey diagram from 2010 GAMA human excreta generation to final discharge flows in m 3 per day.A Kumasi Ventilated Improved Pit (VIP) is designed with two pits versus a single-pit VIP.

Figure 6 .
Figure 6.Centrally supplied water in GAMA.(A) Total central water treatment capacity in GAMA in m 3 from 1980 to 2015.(B) Total water produced, lost from leaks, and supplied to customers.(C) Estimated distribution of water supplied per district for 2010.

Figure 6 .
Figure 6.Centrally supplied water in GAMA.(A) Total central water treatment capacity in GAMA in m 3 from 1980 to 2015.(B) Total water produced, lost from leaks, and supplied to customers.(C) Estimated distribution of water supplied per district for 2010.

Figure 7 .
Figure 7.Total domestic water use estimate in GAMA per district for 2010 by supply source.(A) Water sourcing in the districts of GAMA by water source type in m 3 .(B) The water source types for each district as shares of total water use per district.

Figure 7 .
Figure 7.Total domestic water use estimate in GAMA per district for 2010 by supply source.(A) Water sourcing in the districts of GAMA by water source type in m 3 .(B) The water source types for each district as shares of total water use per district.

Water 2018 ,
10, x FOR PEER REVIEW 17 of 25

Figure 8 .
Figure 8.Total wastewater and human excreta (feces and urine) generation estimates in GAMA per district for 2010 by sink.(A) Feces and urine generated per district of GAMA in thousands of m 3 .(B) Wastewater generated per district of GAMA in thousands of m 3 .

Figure 8 .
Figure 8.Total wastewater and human excreta (feces and urine) generation estimates in GAMA per district for 2010 by sink.(A) Feces and urine generated per district of GAMA in thousands of m 3 .(B) Wastewater generated per district of GAMA in thousands of m 3 .

Figure 9 .
Figure 9. Proportion of wastewater and human excreta ending up in the environment and collected via sewage pipes and cesspit-tankers.(A) Share of wastewater per GAMA district discarded into the local environment, open drains or sewage pipes.(B) Share of human excreta (urine and faeces) per GAMA district disposed into the local environment, flown into sewage pipes, collected from septic tanks and pit latrines by tanker trucks, and leaked from septic tanks and pit latrines into the sub-soil.

Figure 9 .
Figure 9. Proportion of wastewater and human excreta ending up in the environment and collected via sewage pipes and cesspit-tankers.(A) Share of wastewater per GAMA district discarded into the local environment, open drains or sewage pipes.(B) Share of human excreta (urine and faeces) per GAMA district disposed into the local environment, flown into sewage pipes, collected from septic tanks and pit latrines by tanker trucks, and leaked from septic tanks and pit latrines into the sub-soil.

Table 1 .
Overview of variables and parameters established in the study.

Table 2 .
Overview of potable water treatment plants in GAMA.

Table notes :
Improved toilet access is the sum of water closet (W.C.), Kumasi VIP, and Public Toilets.W.C. is a flush toilet connected to a sewer or septic tank.

Table notes :
Improved toilet access is the sum of water closet (W.C.), Kumasi VIP, and Public Toilets.W.C. is a flush toilet connected to a sewer or septic tank.
[62][70][71] day capacity broke down in 2000, allegedly due to looting and lack of electricity cables replacement, with degradation now to the point of plant overgrowth in treatment basins[69][70][71].The sewage from the TEMA central pipe system is in consequence directly pumped into the Sakumo Lagoon; • University of Ghana Legon Sewerage (built in 2011): this operational waste stabilisation pond-based STP has a 6424 m 3 per day capacity, but in 2013/2014, it functioned at only 12% of design capacity due to limited inflows[62].
• Tema septage central sewer (built in 1997): this aerated lagoon-based STP with seven treatment ponds and a 20