PART I: MAIN REPORT 11
CHAPTER 1: WATER AND SEWERAGE SECTOR PERFORMANCE DATABASE 11
1.1. Water Sector Performance Database 11
1.2. Consulting service contract for development of water and sewerage sector performance database 11
2.1. Review of current performance indicators and questionnaires 13
2.2. Review Process 13
2.3. Revised performance indicators and questionnaires for year 2015 15
2.3.1. Performance Indicators for Water Services (2015) 15
2.3.2. Questionnaires 2015 16
3.1. Updated Water Sector Performance Database 2013 and 2014 18
3.1.1. Data Collection 18
3.1.2. Verification and Data Inputs Correction 18
3.1.3. Update water sector performance database 2013 and 2014. 19
3.2.1. Performance Indicators of Utilities 19
3.2.3. Quartiles 19
3.2.4. Quartiles for data 2013 and 2014 20
3.3. Combined Report for Water Services 40
CHAPTER 4: ASSESSMENT AND RECOMMENDATIOS FOR WATER SERVICES 43
4.1. Design capacity 43
4.1.1. Evaluation: 43
4.1.2. Recommendation B1: 44
4.2. Service coverage 47
4.2.1. Evaluation 47
4.2.2. Recommendation B2 48
4.3. Unaccounted and Non – Revenue Water 50
4.3.1. Evaluation 50
4.4. Domestic Water Consumption 53
4.4.1. Evaluation 53
4.4.2. Recommendation B4: 53
4.5. Ratio of Capacity Utilization 53
4.5.1. Evaluation 53
4.5.2. Recommendation B5: 54
4.6. Quality of service 57
4.6.1. Evaluation 57
4.6.2. Recommendation B6 58
4.7. Economic and Financial Matters 58
4.7.1. Evaluation 58
CHAPTER 5: PERFORMANCE INDICATORS AND QUESTIONAIRE FOR WASTEWATER TREATMENT SERVICES 71
5.1. Development of Indicator Set and Questionnaire for WWT Services 71
5.1.1. Survey on existing data system 71
5.1.2. Development of Indicator Set 71
5.1.3. Establishing standard forms for National report and Utility Individual Report 72
5.1.4. Development of Questionnaire 72
5.1.5. Establishing the excel sheets 73
5.2. Proposed Indicators and Questionnaire for Wastewater Treatment Services 73
CHAPTER 6: PERFORMANCE DATABASE FOR WASTEWATER 74
TREATMENT SERVICES 2014 74
6.1. Development of Performance Database for Wastewater Treatment Services 2014 74
6.1.1. Training on Performance Database for Wastewater Treatment Services 74
6.1.2. Data collection: 74
6.1.3. Verification and Data Inputs Correction 74
6.1.4. Development of Performance Database for Wastewater Treatment Services 2014 74
6.2. Performance Indicators of Utilities 75
6.2.1. Performance Indicators 75
6.2.2. Quartile 75
6.3. Combined Report for Wastewater Treatment Services 83
CHAPTER 7: ASSESSMENT AND RECOMMENDATION FOR WASTEWATER TREATMENT SERVICES 85
7.1. Design Capacity of WWTPs 85
7.1.1.Evaluation 85
7.1.2.Recommendation C1: 89
7.2. Treatment Process 89
7.2.1.Influent to WWTP: 89
7.2.2.Technical requirements for effluent 91
7.2.3.Recommendation C2: 94
7.2.4.Treatment Process 95
7.2.5.Recommendation C3: 95
7.3. Service Coverage 98
7.4. Ratio of Capacity Utilization 99
7.5. Quality of Service 101
7.5.1. Quality of influent at WWTPs 101
7.5.2. Quality of effluent (after treatment): 101
7.5.3. Quality control 102
7.6. Economic – Financial Matters 108
CHAPTER 8: UPGRADE AND EXPANSION OF DATABASE WEBSITE 113
8.1. Website upgrade 113
8.1.1. Reviewing the operation of the developed database Website. 113
8.1.2. Correction of errors and maintaining the operation of existing Website (the data of year 2011, 2012) to continue the update of urban water supply data of year 2013 and 2014. 113
8.1.3. Improved contents 114
8.2. Extension of Database Website. 115
8.2.1. Database structure design: 115
8.2.2. Website layout 116
8.2.3. The main menus and windows of Database Website’s homepage. 118
8.3. Training and Manual for use of Website. 119
CHAPTER 9: DEVELOPMENT OF IBNet TOOLKIT FOR VIETNAM DATABASE 120
9.1. Development of IBNet Toolkit for Vietnam Database 120
9.1.1. IBNET Toolkit 120
9.1.2. Application of IBNet Toolkit for Vietnam 120
9.2. Application of IBNet Toolkit for Vietnam Sector Database 121
9.2.1. Application of IBNet Toolkit for Sector Database 121
CHAPTER 10: CONCLUSIONS AND RECOMMENDATIONS 122
10.1. Conclusions 122
10.1.1. Completed Tasks 122
10.1.2. Overall assessment 122
10.2. Recommendations 122
10.2.1. Overall recommendations on sector database 122
10.2.1. Recommendations for Water Service 124
10.2.1. Recommendations for Wastewater Treatment Services 124
PART II: ANNEXES 125