Id	Code	Select the type of water source being inspected	Select the agency inspecting this water source	Enter the date of source inspection	Region	District	Enter the name of settlement / village where the source is located	Distance to nearest settlement (KM)	Select the agency that established this water source	Enter the date when the source was established	Enter the water source name	Source gpspoint	Enter water source Latitude in decimal degrees	Enter water source Longitude in decimal degrees	Enter Elevation (m.a.s.l)	Enter GPS Precision (m)	Enter number of water sources in a cluster	Water Source Photographs	Select the category of users for this water source	Is this a permanent status water source?	For how many months in a year is this water source in use (#)?	Is this water source currently functioning?	Non functioning reason	No. of persons using	No. of Camels using the source	No. of Cattle using the source	No. of Sheep/Goats using the source	Area irrigated using the source (ha)	Is the source protected?	What is the depth of this borehole (m)?	Type of Casing	Casing size (inches)	What is the current static water level of this borehole (m)?	What is the yield of this borehole (m3/hr)?	How long is this borehole operated in a day (hr)?	What is the borehole draw down (m)?	After pumping, how long does this borehole take to recover (hr)?	What is the depth of this dug well (m)?	What is the current static water level of this dug well (m)?	What is the yield of this dug well (m3/hr)?	How long is this dug well operated in a day (hr)?	What is the dug well draw down (m)?	After pumping, how long does this dug well take to recover (hr)?	What is the depth of this dam (m)?	What is the length of this dam (m)?	What is the width of this dam (m)?	What is the depth of this berkad (m)?	What is the length of this berkad (m)?	What is the width of this berkad (m)?	What is the cumulative discharge rate of this spring (m3/hr)?	What is the depth of this source (m)?	What is the length of this source (m)?	What is the width of this source (m)?	What is the yield of the source (m3/hr)?	What type of reservoir is used for this source?	Reservoir capacity (m3)	Pipeline type	Pipeline length (m)	How many House Holds (HH) are connected to this water source?	How many kiosks/water points are connected to this source?	How many animal troughs are connected to this source?	Source used for water trucking during emergency?	No. of trucks / day	Average truck capacity (m3)	Pump type	Pump model	Pump capacity (m3/hr)	Pump level (m)	Power source	Generator/Solar type	Generator capacity (kVA/kWh)	What type/model is the solar used?	What capacity is the solar (kWh)?	Condition of supply system	Additional notes on supply & distribution system condition	Any visible physical problem (color, odor)?	Please describe the color, odor and smell of water	Temperature	PH	Electrical Conductivity (µs/cm)	Total Dissolved Solids (mg/l)	Water sample code. (if taken)	Management type	Water & Sanitation Committee (WSC)?	Year established	WSC members male	WSC members female	DIs water for human use charged?	Current cost of 20 ltr jerrican (USD/20ltr)	Is water for animal use charged?	Current cost for Livestock (USD/100ltr)	What is the name of the operator/caretaker for this water source?	What is the phone number of the operator/caretaker?	Which agency carried out last intervention on this water source?	Recent interventions	Last intervention date	Proposed intervention description	Additional Notes	Metadata Tag
7014	—	Dug Well	FGS Ministry of Energy and Water Resources	2022-03-24	Bakool	xudur	Bullow	1.0	IOM	24/03/2022	Eel liifow	—	4.1239897	43.8929898	463.0	—	—	—	rural urban	no	9	No	Due to shortage of rainy season the water level went down	2900	280	120	350	0.0	—	—	—	—	—	—	—	—	—	13.0	6.0	4.0	6.0	6.0	1.0	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	25.0	Stainless Steel	10.0	25	2	2	no	—	—	Submersible Pump	Florence	1.5	12.0	Solar	—	—	—	17280.0	good	No bad condition there during distribution time	no	—	—	—	—	—	—	Private/Individual	—	—	—	—	yes	0.2	yes	—	—	—	IOM	24-Mar-22	Constructed of 25 miter cubic water tank installation of solar system and submersible pupm fiencing for protection	Back up generator and spare partes/ fuel	—	—
7257	—	Borehole	Galmudug Ministry of Energy and Water Resources	2022-03-24	Galgaduud	cadaado	Biyo gaduud	8.0	—	—	Biyo gaduud	—	6.3074377	46.5797585	331.0	—	0	—	rural urban	yes	—	Yes	—	15000	800	—	30000	—	—	170.0	pvc	8.0	94.7	28.0	17.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	64.0	Galvanised Steel	74.0	35	1	2	yes	8	9.0	Submersible Pump	Franglin	—	110.0	Hybrid - Solar/Generator	Perkin	30.0	JAM72S09	16.0	fair	1. pump is old 2. Small storage	no	—	35.8	6.59	3230.0	1620.0	—	Communal	yes	—	4	1	yes	0.015	yes	—	—	—	IRC	Solar	—	—	—	—
8486	—	Dam	FGS Ministry of Energy and Water Resources	2022-03-24	Bakool	xudur	Bullow	1.0	Community_	24/03/2022	Salah habiib	—	4.1229852	43.8974343	472.0	—	1	—	rural urban	no	2	No	Due to shortage of rainy seasone the dam hasn't held enough water	5000	500	300	1500	0.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	4.0	100.0	60.0	—	—	—	—	—	—	—	—	Other	0.0	Other	0.0	2500	0	0	no	—	—	No Pump	—	—	—	—	—	—	—	—	poor	The dam has no any water source structure system such fiencing elevated water tank water kisks even blastic bags people normaly fetch water from there using man power that may cause risk sometimes.	no	—	—	—	—	—	—	Private/Individual	—	—	—	—	no	—	no	—	—	—	—	—	N/A	Water infrastructural systems	—	—
7803	—	Dug Well	FGS Ministry of Energy and Water Resources	2022-03-24	Bakool	xudur	Bullow area	1.0	Community_	25/03/2022	Saweeda12	—	4.1262701	43.8898909	465.0	—	18	—	urban rural	no	10	Yes	—	1600	800	120	600	0.0	—	—	—	—	—	—	—	—	—	13.0	12.0	1.0	12.0	12.5	3.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	3	no	—	—	No Pump	—	—	—	—	—	—	—	—	good	Rehabilatation	no	—	15.0	7.0	5000.0	500.0	—	Communal	no	—	—	—	no	—	no	—	—	—	—	25-Mar-22	N/A	Construction of water infrastructures	—	—
7247	—	Borehole	FGS Ministry of Energy and Water Resources	2022-03-24	Middle Shabelle	balcad	Gololey	0.0	Somjet	13/10/2015	Maxamed Isaaq	—	2.4496145	45.3527411	91.0	—	—	—	rural	yes	—	Yes	—	4867	300	650	2500	14.0	—	120.0	pvc	6.0	—	—	20.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	15.0	Galvanised Steel	45.0	450	2	2	yes	2	20.0	Submersible Pump	7.5kw	—	76.0	Solar	—	—	—	300.0	good	It's in a good condition	no	—	—	—	—	—	—	Private/Individual	—	—	—	—	yes	0.02	yes	—	—	—	Private	18-Sep-15	Submersible pump	Generator room, elevated water tank, generator pipeline extension and submersible pump	—	—
7260	—	Borehole	Galmudug Ministry of Energy and Water Resources	2022-03-24	Galgaduud	cadaado	Bowda dhogore	2.0	Not specified	—	Bowda dhogore	—	5.9767633	46.4643167	317.0	—	1	—	rural	yes	—	Yes	—	3000	350	—	30000	—	—	140.0	pvc	6.0	—	—	10.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	40.0	Galvanised Steel	130.0	45	1	2	yes	10	9.0	Submersible Pump	Granfos	—	100.0	Hybrid - Solar/Generator	ITG.I84GB	32.0	JS330	16.0	fair	1. Supply system normally good 2. But EC, TDS, & Salinity are very high.	no	—	34.5	6.25	4730.0	2360.0	—	Private/Individual	—	—	—	—	yes	0.04	yes	—	—	—	NRC	Water tank	—	2018-02-20	—	—
8575	—	Dug Well	FGS Ministry of Energy and Water Resources	2022-03-24	Middle Shabelle	jowhar	Garaash	0.0	Other	14/06/2016	Garaash	—	2.7465939	45.4802803	107.0	—	16	—	rural	no	6	Yes	—	187	—	—	—	—	—	—	—	—	—	—	—	—	—	9.0	6.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Other	—	Other	—	15	—	—	no	—	—	No Pump	—	—	—	—	—	—	—	—	poor	It damaged by the recent floods and it's not potable	no	—	—	—	—	—	—	Other	—	—	—	—	no	—	no	—	—	—	—	—	—	Installation of hand pump and deepening of the source	—	—
7826	—	Dug Well	Galmudug Ministry of Energy and Water Resources	2022-03-24	Galgaduud	cadaado	Gidheys	0.0	Community	—	Abdi-sw	—	6.01813	46.6820733	300.0	—	1	—	urban	yes	—	Yes	—	15	—	—	—	—	—	—	—	—	—	—	—	—	—	20.0	7.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	25.0	Galvanised Steel	25.0	1	0	0	—	—	—	Submersible Pump	Not specified	—	18.0	Solar	—	—	—	—	poor	Not have irrigation distribution pipes for farm proposed this source and require supply for irrigation for 0.5 Hectare farm.	no	—	35.0	7.03	3800.0	1900.0	—	Private/Individual	—	—	—	—	no	—	no	—	—	—	CPD	Tank	—	2015-11-23	—	—
7392	—	Dug Well	FGS Ministry of Energy and Water Resources	2022-03-24	Bakool	xudur	Saweeda shallow well	1.0	GRRN	24/03/2022	Saweeda shallow well	—	4.1268699	43.8912627	474.0	—	15	—	rural urban	yes	—	Yes	—	1900	0	0	0	0.0	—	—	—	—	—	—	—	—	—	10.0	6.0	15.0	12.0	9.0	1.0	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	25.0	PVC	6.0	0	0	0	no	—	—	Submersible Pump	Hanti	1.5	9.0	Generator	Gengfa	5.0	—	—	fair	Less of capacity of water pumping systems	no	—	17.0	6.0	5000.0	600.0	—	Private/Individual	—	—	—	—	yes	0.3	no	—	—	—	GRRN	24-Mar-22	Elevated water tank and submersible pupm caretaker room	Rehabilatation of water tank digging the well in depth of 2 miter installation of solar system	—	—
7012	—	Borehole	FGS Ministry of Energy and Water Resources	2022-03-24	Bakool	xudur	Shiekh aweys	0.5	ADA	24/03/2022	Shiekh awes borehole	—	4.119833	43.8939899	472.0	—	5	—	urban rural	yes	—	Yes	—	2500	500	250	1500	0.0	—	142.0	gi	6.0	21.0	6.0	3.0	1.0	2.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	50.0	Stainless Steel	15.0	300	18	3	yes	10	45.0	Submersible Pump	Florence	7.5	140.0	Solar	—	—	—	15600.0	good	Functioning properly	no	—	15.0	7.0	3000.0	250.0	—	Private-Public-Partnership	—	—	—	—	yes	0.2	yes	—	—	—	ACF	24-Mar-22	Replaced of submersible pupm pvc tube	July	—	—