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
8358	—	Dug Well	FGS Ministry of Energy and Water Resources	2022-03-24	Middle Shabelle	balcad	Horseed	0.0	Muslim Charity	10/09/2017	Maxamed Cisman	—	2.3652327	45.3849967	108.0	—	—	—	urban	yes	—	Yes	—	1879	—	—	—	—	—	—	—	—	—	—	—	—	—	21.0	19.5	—	1.0	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	10.0	Galvanised Steel	18.0	80	1	—	no	—	—	Submersible Pump	2.2kw	—	19.0	Generator	Gangfa 115	—	—	—	good	It's in a good condition	no	—	—	—	—	—	—	Private/Individual	—	—	—	—	no	—	no	—	—	—	—	—	—	Deepening, Decementation, supply of generator and GI pipes, construction of water kiosk and elevated water tank.	—	—
7135	—	Borehole	FGS Ministry of Energy and Water Resources	2022-03-24	Middle Shabelle	balcad	Qalimow	0.0	Community_	15/10/1989	Xaaji Cismaan	—	2.5879204	45.370365	92.0	—	—	—	rural	yes	—	Yes	—	4875	500	800	5000	—	—	160.0	gi	8.0	—	—	12.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	15.0	Galvanised Steel	78.0	389	2	3	yes	2	10.0	Submersible Pump	15kw	—	75.0	Generator	Perkins	30.0	—	—	good	It's in a good condition	no	—	—	—	—	—	—	Private/Individual	—	—	—	—	yes	0.05	yes	—	—	—	ICRC	19-Jun-07	Rehabilitation	Water tank, generator, submersible pump, solar and GI pipes	—	—
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	—	—
7265	—	Borehole	Galmudug Ministry of Energy and Water Resources	2022-03-24	Galgaduud	cadaado	Gidheys	0.2	—	—	Gidheys	—	6.0153517	46.6795467	297.0	—	0	—	rural urban	yes	—	Yes	—	35000	1500	—	85000	—	—	280.0	pvc	8.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	29.0	Galvanised Steel	190.0	100	1	1	yes	21	9.0	Submersible Pump	Granfos	—	122.0	Solar	—	—	JS 300	20.0	fair	1. Most HH not have water taps 2. Motor is not functioning	no	—	36.3	6.71	2850.0	1410.0	—	Communal	yes	—	4	1	yes	0.015	yes	—	—	—	—	—	—	—	—	—
7326	—	Borehole	FGS Ministry of Energy and Water Resources	2022-03-24	Bay	qansax_dheere	Wadajir	1.0	Former Somali Government	24/03/1970	EEL YARROW	—	2.8761051	43.0066776	387.0	—	4	—	urban	no	0	No	The water source was stopped before 15 years cause of lack of generator and lack of pipeline and lack of water tank and lack of casing lack of berked and animals drinking water berked	0	—	—	—	—	—	120.0	other	8.0	0.0	0.0	0.0	60.0	0.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Plastic tank	300.0	Other	0.0	0	0	0	no	—	—	No Pump	—	—	—	—	—	—	—	—	poor	There is no supply system	no	—	22.0	—	—	—	—	Utility/Local Authority	—	—	—	—	yes	0.25	yes	—	—	—	ADRA	25-Mar-06	Rehabilitation	needs generator, pipeline, kiosks , casing and also need water tank, generator room, fancing and digging in additional to needs berked,and animals drinking water berked	—	—
7271	—	Dug Well	FGS Ministry of Energy and Water Resources	2022-03-24	Middle Shabelle	balcad	Gololey	0.0	Private	11/07/1991	Geeloow	—	2.4490354	45.3558818	93.0	—	—	—	rural	yes	—	Yes	—	4789	—	500	380	—	—	—	—	—	—	—	—	—	—	60.0	51.0	—	8.0	—	—	—	—	—	—	—	—	—	—	—	—	—	Plastic tank	10.0	Galvanised Steel	25.0	280	1	2	no	—	—	Submersible Pump	5.5kw	—	58.0	Generator	Gangfa 115	—	—	—	good	It's in a good condition	no	—	—	—	—	—	—	Private/Individual	—	—	—	—	yes	0.05	yes	—	—	—	Private	19-Sep-19	Submersible pump	Full rehabilitation	—	—
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	—	—
7263	—	Borehole	Galmudug Ministry of Energy and Water Resources	2022-03-24	Galgaduud	cadaado	Bali Higis	3.0	Individual	21/01/2009	Bali higis	—	6.1674787	46.6330098	318.0	—	0	—	rural urban	yes	—	Yes	—	6400	500	20	85000	1.0	—	220.0	pvc	8.0	108.0	16.0	12.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	60.0	Galvanised Steel	80.0	30	2	2	yes	16	8.0	Submersible Pump	Granfos	—	108.0	Hybrid - Solar/Generator	Doutz	36.0	Pm340	24.0	fair	1. Needs implementation of water supply system for IDPs residents(4km)	no	—	35.0	6.83	3460.0	1750.0	—	Private/Individual	—	—	—	—	yes	0.015	yes	—	—	—	PAH	1. Pump and pipes 2. Motor	—	—	—	—
7277	—	Borehole	Galmudug Ministry of Energy and Water Resources	2022-03-24	Galgaduud	cadaado	Godinlabe	0.0	—	—	Durdur	—	5.8743101	46.6313549	294.0	—	0	—	rural urban	yes	—	Yes	—	3000	—	—	35000	—	—	204.0	gi	8.0	—	—	18.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	80.0	Galvanised Steel	340.0	1500	2	3	yes	10	8.0	Submersible Pump	Kaprari	—	50.0	Hybrid - Solar/Generator	Doutz	36.0	Js300	16.0	poor	1. Most water tanks are old and leaching 2. Motor stoped function 3. and pump replacement 4. Distribution pipes of 4 km host communities.	no	—	35.2	6.66	3790.0	1900.0	—	Private/Individual	—	—	—	—	yes	0.021	yes	—	—	—	NRC	Water Tank	—	—	—	—
8346	—	Borehole	FGS Ministry of Energy and Water Resources	2022-03-24	Middle Shabelle	balcad	Qalimow	0.0	Former Somali Government	12/09/1960	Qalimow	—	2.588428	45.3702117	93.0	—	—	—	rural	yes	—	No	About 20 years ago, lack of submersible pump and GI Pipes	3840	480	350	500	—	—	120.0	pvc	8.0	—	—	12.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	25.0	Galvanised Steel	30.0	248	1	2	no	—	—	Submersible Pump	10kw	—	75.0	Generator	Duos	30.0	—	—	poor	It's a normal condition	no	—	—	—	—	—	—	Private/Individual	—	—	—	—	no	—	no	—	—	—	Community_e	18-Oct-99	Rehabilitation	Full rehabilitation and supply of GI pipes and Generator	—	—