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
4050	DWMSBA007	Dug Well	FGS_MoEWR	Sept. 29, 2019	Middle Shabelle	Balcad	Garas Bintow	—	Community	4/10/2008	Farjanno DW	—	2.2173	45.3973	141.0	—	2	1571156237435.jpg	—	yes	—	Yes	—	1200	500	1000	1500	—	Yes	—	—	—	—	—	—	—	—	—	—	6.0	18.0	5.0	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	—	Galvanised Steel	20.0	380	1	2	yes	3	5.0	—	Franklin	11.0	108.0	Submersible Pump	Eveko	30.0	—	—	—	—	No	—	30.6	7.2	1100.0	550.0	—	—	Yes	1/12/2009	1	0	No	—	No	—	—	—	Community	Generator and pumps	12/12/2017	Pumps, pipelines, Berkads, large tanks, Berkads and full rehabilitation.	—	Strategic Water Sources Survey – WSS_NATl
1384	BHMSBA010	Borehole	FGS_MoEWR	Sept. 29, 2019	Middle Shabelle	Balcad	Caliyale	0.0	IR - Islamic Relief Somalia	10-04-17	Sudi BH	—	2.1801	45.3801	120.0	—	9	1571160528773.jpg	Rural Urban	Yes	—	Yes	—	—	130	515	4380	0.0	—	100.0	PVC	8.0	45.0	11.0	16.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	18.0	Galvanised Steel	20.0	95	1	2	Yes	2	10.0	Submersible Pump	Franklin	11.0	85.0	Generator	Dos	30.0	—	—	Poor	—	No	—	29.4	7.68	830.0	410.0	—	Communal	—	11-02-08	1	0	No	—	No	—	—	—	Private	Generator and pumps	12/10/2017	Solar system, large storage tanks and full rehabilitation.	—	Strategic Water Sources Survey – WSS_NATl
1399	BHMSBA024	Borehole	FGS_MoEWR	Oct. 6, 2019	Middle Shabelle	Balcad	Garsale	0.0	Private	11-05-13	Garsale BH	—	2.6301	45.4003	100.0	—	0	1571160128432.jpg	Rural	Yes	—	Yes	—	—	1200	50	1580	0.0	—	45.0	PVC	8.0	35.0	11.0	4.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	11.0	Galvanised Steel	—	56	1	1	Yes	1	10.0	Submersible Pump	Franklin	20.0	42.0	Generator	Dos	12.0	—	—	Poor	—	No	—	29.4	7.8	5990.0	2960.0	—	Communal	—	11-07-15	1	1	No	—	No	—	—	—	—	—	—	Solar system, generator, large tanks and full rehabilitation.	—	Strategic Water Sources Survey – WSS_NATl
2222	BHWGHA116	Borehole	Somaliland_MoWRD	Dec. 14, 2019	Woqooyi Galbeed	Hargeisa	Qabile	0.0	Private	09-06-13	Qabile bore hole	—	10.2822	44.165	204.0	4.9	1	1576314536931.jpg	Rural Urban	Yes	—	Yes	—	—	800	0	1600	0.0	—	80.0	PVC	6.0	50.0	8.0	8.0	—	0.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	8.0	Stainless Steel	25.0	0	2	8	No	—	—	Submersible Pump	Grundfos Denmark	12.0	70.0	Solar	—	—	Hindaia banal 5	330.0	Fair	The condition of supply system is very boor becouse tanks is collabed and water kioks	Yes	—	30.3	7.86	2300.0	1160.0	—	Communal	—	14-12-15	1	0	No	—	No	—	—	—	—	—	—	Additional water tanks animal thoughts water kioks pipeline disturbution	—	Strategic Water Sources Survey – WSS_NATl
4074	DWMSBA025	Dug Well	FGS_MoEWR	Oct. 2, 2019	Middle Shabelle	Balcad	WarSheikh	—	Community	5/10/1965	New Well DW	—	2.2736	45.5836	45.0	—	0	1571158215260.jpg	—	yes	—	Yes	—	1500	300	50	1000	0.0	No	—	—	—	—	—	—	—	—	32.0	28.0	—	24.0	3.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	no	—	—	—	—	—	—	—	—	—	—	—	—	—	No	—	32.0	7.36	4040.0	2020.0	—	—	Yes	4/10/2009	1	3	No	—	No	—	—	—	—	—	—	Solar system, generator, kiosks, animal troughs, Berkads and full rehabilitation.	—	Strategic Water Sources Survey – WSS_NATl
4	BHAWBA004	Borehole	Somaliland_MoWRD	Dec. 14, 2019	Awdal	Baki	Abdi geedi	0.0	IR - Islamic Relief	14-12-17	Abdi geedi bore hole	—	10.5086	44.0493	38.0	4.9	1	1576303853264.jpg	Rural Urban	Yes	—	Yes	—	—	500	0	3000	0.0	—	100.0	PVC	6.0	16.0	5.0	10.0	—	0.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	50.0	PVC	50.0	0	2	2	No	—	—	—	Groundfos Denmark	9.0	90.0	Hybrid - Solar/Generator	France mkyl	13.0	Banal 7	400.0	Good	The condition of supply system is very good	Yes	—	29.3	8.09	3800.0	1100.0	—	Communal	—	09-07-18	1	2	No	—	No	—	—	—	Other	Solor changes. Built guard house covered water tanks	05/27/2018	Pipeline rehabilitation and animal thoughts water kiokes addition pipeline distribution	—	Strategic Water Sources Survey – WSS_NATl
501	BHBYBA065	Borehole	NRC	Oct. 20, 2014	Bay	Baydhaba	Kormari	2.0	NRC - Norwegian Refugee Council	—	Bayhaw two	—	3.1462	43.655	460.0	2.9	9	—	Rural	Yes	—	Yes	—	—	100	70	150	1.0	—	125.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	63.0	Stainless Steel	50.0	1400	—	1	No	—	—	Submersible Pump	—	15.0	30.0	Solar	—	—	60	150.0	Good	—	No	—	29.1	7.7	1150.0	570.0	—	Communal	—	—	1	2	No	—	Yes	—	—	—	—	—	—	Mator, room, fence, tailot, compum kiosk and truff	—	Water Sources Data from Partners – WSD_Pat
1324	BHMDHO044	Borehole	FGS_MoEWR	Sept. 18, 2019	Mudug	Hobyo	Xerodhagaxley	1.0	GSA - General Service Agency	16-12-12	Xerodhagaxley BH	—	5.5967	48.2358	92.0	—	0	1569519631653.jpg	—	No	12	No	2012, high salinity	—	—	—	—	—	—	196.0	PVC	8.0	90.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	No	—	—	—	—	—	—	—	—	—	—	—	Poor	Very bad condition	Yes	—	—	—	—	—	—	Communal	—	26-04-14	2	1	No	—	No	—	—	—	IRC - International Rescue Committee	—	—	New borehole and solar system	—	Strategic Water Sources Survey – WSS_NATl
1242	BHMDGK103	Borehole	Puntland_PWDA	Nov. 23, 2019	Mudug	Galkacyo	Sallax	1.5	Community	23-11-18	Sallax_Bh	—	7.2894	48.3185	327.0	4.7	—	1573630276873.jpg	Rural	Yes	—	Yes	—	—	6000	150	130000	—	—	302.0	—	—	—	12.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	40.0	—	—	—	1	2	—	—	—	Submersible Pump	Lowara 18.5	—	180.0	Generator	Perkins	50.0	—	—	Good	—	No	—	27.0	—	3500.0	1800.0	—	Communal	—	18-07-18	2	2	No	—	Yes	—	—	—	CARE Somalia	Rehabilitation	03/22/2019	Solar system Water supply extension Fencing	—	Strategic Water Sources Survey – WSS_NATl
1347	BHMDHO062	Borehole	Puntland_PWDA	Nov. 25, 2019	Mudug	Hobyo	Towfiiq BH1	0.5	SSF - Somali Stability Fund	11-07-16	Towfiiq BH1	—	6.6138	48.8711	31.0	4.7	1	1573802571961.jpg	Rural	Yes	—	Yes	—	—	1000	—	20000	—	—	80.0	—	—	—	10.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	35.0	PVC	1500.0	20	6	2	Yes	7	8.0	Submersible Pump	Lowara 11	—	66.0	Hybrid - Solar/Generator	Jp45	45.0	—	—	Good	—	No	—	31.6	—	6790.0	3400.0	—	Communal	—	23-03-19	2	—	Yes	0.03	Yes	—	—	—	CARE Somalia	Generator room	03/23/2019	Full rehabilitation Fencing	—	Strategic Water Sources Survey – WSS_NATl