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
3366	DWGDLU040	Dug Well	FGS_MoEWR	2019-10-02	Gedo	Luuq	Minyara	—	Community	5/28/2017	Gaaboow	—	3.8025	42.5669	150.0	4.0	—	1571132839576.jpg	—	no	—	Abandoned	The water quality has changed and become very salt	1400	—	—	—	—	Yes	—	—	—	—	—	—	—	—	7.0	5.0	1.02	12.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Stainless Steel	7.0	200	—	—	no	—	—	—	Afridev	1.02	—	Hand Pump	—	—	—	—	—	—	No	—	32.8	7.4	2000.0	10000.0	—	—	Yes	10/2/2015	5	5	No	—	No	—	—	—	—	—	—	This community resquest to establish new dug well since the water of this Dug Well became saline.	—	Strategic Water Sources Survey – WSS_NATl
3367	DWGDLU041	Dug Well	FGS_MoEWR	2019-10-02	Gedo	Luuq	Gumaro	—	SHRA	1/2/2016	Dubat	—	3.7941	42.5686	150.0	4.5	—	1571132720451.jpg	—	yes	—	No	The	1050	—	—	—	—	Yes	—	—	—	—	—	—	—	—	10.0	7.0	1.02	10.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Stainless Steel	10.0	150	—	—	no	—	—	—	Afridev	1.02	—	Hand Pump	—	—	—	—	—	—	No	—	32.6	7.04	1670.0	830.0	—	—	Yes	1/2/2016	5	5	No	—	No	—	—	—	—	—	—	The community request to replance the hand pump into solar system, 30m3 elevated concrete tank and two kiosks.	—	Strategic Water Sources Survey – WSS_NATl
4082	DWMSBA033	Dug Well	FGS_MoEWR	2019-10-02	Middle Shabelle	Balcad	WarSheikh	—	Community	5/10/2012	Aw Ali DW	—	2.3383	45.6586	58.0	—	9	1571154643742.jpg	—	yes	—	Yes	—	200	25	60	750	0.0	No	—	—	—	—	—	—	—	—	—	—	13.0	8.0	6.0	—	—	—	—	—	—	—	—	—	—	—	—	Other	—	Galvanised Steel	500.0	—	—	—	no	—	—	—	Franklin	11.0	50.0	Submersible Pump	Dose	10.0	—	—	—	—	No	—	34.7	7.52	1910.0	940.0	—	—	Yes	5/11/2012	4	0	No	—	No	—	—	—	—	—	—	Generator, pumps, large tanks, kiosks, animal troughs, pipelines, solar system and full rehabilitation.	—	Strategic Water Sources Survey – WSS_NATl
6873	BKTGBH015	Berkad	Somaliland_MoWRD	2019-10-02	Togdheer	Buhoodle	Qorilugud	2.0	Community	10-02-86	Qorilugud Berkad 5	—	8.5543	46.2413	765.0	4.9	7	1569992941208.jpg	—	no	—	No	—	—	0	0	0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	4.0	20.0	8.0	—	—	—	—	—	Other	—	Other	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	no	—	—	—	—	—	—	—	no	—	—	—	—	—	—	—	—	—	—	—	—	Full rehab	—	Strategic Water Sources Survey – WSS_NATl
1951	BHTGBH007	Borehole	Somaliland_MoWRD	2019-10-02	Togdheer	Buhoodle	Horufadhi	0.5	ICRC - International Committee of The Red Cross	02-10-18	Horufadhi borehole	—	8.5758	46.3973	810.0	4.9	—	1570002766935.jpg	Rural	No	—	Abandoned	Becouse the source is not excisit right now	—	0	0	0	0.0	—	320.0	Other	0.0	0.0	0.0	0.0	—	0.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Other	0.0	Other	0.0	0	—	—	—	—	—	No Pump	—	—	—	—	—	—	—	—	Poor	—	No	—	—	—	—	—	—	Utility/Local Authority	—	—	—	—	—	—	—	—	—	—	ICRC - International Committee of The Red Cross	—	—	Replacement	—	Strategic Water Sources Survey – WSS_NATl
1950	BHTGBH006	Borehole	Somaliland_MoWRD	2019-10-02	Togdheer	Buhoodle	Buhodle	0.0	Telesom Company	02-10-15	Bohodle Borehole 3	—	8.2555	46.3196	672.0	4.7	2	1570012907550.jpg	Urban	Yes	—	Yes	—	—	—	—	—	—	—	350.0	PVC	8.0	270.0	16.0	24.0	12.0	0.1	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	25.0	PVC	6.0	12000	2	4	No	—	—	Submersible Pump	Grundfos Belgium	16.0	320.0	Generator	Perkins	45.0	—	—	Fair	—	No	—	32.2	7.45	297.0	1490.0	—	Communal	—	—	—	—	No	—	No	—	—	—	—	—	—	Replacement of raiser pipe, more trughs hygein and sanitation	—	Strategic Water Sources Survey – WSS_NATl
4080	DWMSBA031	Dug Well	FGS_MoEWR	2019-10-02	Middle Shabelle	Balcad	WarSheikh	—	Community	3/1/2007	Taag Dheere Dug Well	—	2.3454	45.6326	80.0	—	1	1571160296451.jpg	—	yes	—	Yes	—	650	95	145	1125	0.0	Yes	—	—	—	—	—	—	—	—	18.0	11.0	8.0	12.0	3.0	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	—	Galvanised Steel	140.0	—	1	1	no	—	—	—	Franklin	11.0	12.0	Submersible Pump	Dose	10.0	—	—	—	—	No	—	32.5	8.2	1080.0	540.0	—	—	Yes	5/12/2015	4	2	No	—	No	—	—	—	DRC - Danish Refugee Council (Regional Office)	Pumps and pipes	2018-07-05	Solar system, tanks, generator, kiosks, animal troughs and full rehabilitation.	—	Strategic Water Sources Survey – WSS_NATl
4076	DWMSBA027	Dug Well	FGS_MoEWR	2019-10-02	Middle Shabelle	Balcad	WarSheikh	—	Community	5/10/2007	Aw Shuute DW	—	2.3552	45.6042	114.0	—	0	1571160017417.jpg	—	yes	—	Yes	—	270	39	65	450	0.0	No	—	—	—	—	—	—	—	—	—	—	—	24.0	3.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	no	—	—	—	—	—	—	—	—	—	—	—	—	—	No	—	36.0	7.25	980.0	490.0	—	—	Yes	2/11/2009	8	3	No	—	No	—	—	—	Private	Cleaning and deepening	2019-06-11	Solar system, generator, large tanks, kiosks, animal troughs, pipelines, pumps, Berkads, full rehabilitation and new borehole.	—	Strategic Water Sources Survey – WSS_NATl
4095	DWMSBA046	Dug Well	FGS_MoEWR	2019-10-02	Middle Shabelle	Balcad	WarSheikh	—	Community	7/3/1960	Marsheello DW	—	2.2983	45.7979	9.0	—	2	1571118648880.jpg	—	yes	—	Yes	—	520	45	65	560	0.0	No	—	—	—	—	—	—	—	—	8.0	6.0	—	24.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	No	—	30.6	7.93	3720.0	1860.0	—	—	Yes	11-10-00	4	1	No	—	No	—	—	—	Community	Rehabilitation of pumps	2016-05-08	Solar system, generator, large tanks, kiosks, animal troughs, pipelines, pumps and full rehabilitation.	—	Strategic Water Sources Survey – WSS_NATl
1404	BHMSBA029	Borehole	FGS_MoEWR	2019-10-02	Middle Shabelle	Balcad	WarSheikh	0.0	GTZ - German Agency for Technical Assistance	09-04-84	Qorillow BH	—	2.3533	45.7333	46.0	—	1	1571158252802.jpg	Rural	No	12	No	1987, pumps and casing were removed by Somali National Army.	—	—	—	—	—	—	75.0	—	—	63.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	No	—	—	—	—	—	—	—	—	—	—	—	—	—	No	—	—	—	—	—	—	Communal	—	09-04-88	5	4	—	—	—	—	—	—	—	—	—	New borehole, full rehabilitation with solar systems.	—	Strategic Water Sources Survey – WSS_NATl