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
3195	DWBYBA041	Dug Well	FGS_MoEWR	2019-09-14	Bay	Baydhaba	Towfiq	—	Tiiroow	8/12/2010	Maleele	—	3.1247	43.6808	441.0	3.8	1	—	—	yes	—	Yes	—	800	—	—	—	—	No	—	—	—	—	—	—	—	—	8.0	7.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	160	—	—	no	—	—	—	—	—	—	No Pump	—	—	—	—	—	—	No	—	27.2	7.84	1030.0	510.0	—	—	—	—	—	—	No	—	No	—	—	—	—	—	—	Head protection	—	Strategic Water Sources Survey – WSS_NATl
508	BHBYBA069	Borehole	FGS_MoEWR	2019-09-14	Bay	Baydhaba	Kormari	0.0	—	—	Caafi one	—	3.1465	43.6564	458.0	3.9	4	—	Urban	Yes	—	Yes	—	—	—	—	—	—	—	120.0	—	—	85.0	12.0	3.0	—	1.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	30.0	Stainless Steel	114.0	100	—	—	No	—	—	Submersible Pump	—	—	—	Generator	Dos	30.0	—	—	Good	—	No	—	32.9	7.0	1320.0	660.0	—	Private/Individual	—	—	—	—	Yes	0.1	No	—	—	—	—	—	—	Pump change, pipeline change and generator repair	—	Strategic Water Sources Survey – WSS_NATl
494	BHBYBA061	Borehole	FGS_MoEWR	2019-09-14	Bay	Baydhaba	Bayhaaw	5.0	—	—	Caafi two	—	3.1398	43.6541	457.0	4.4	1	—	Rural	Yes	—	Yes	—	—	—	—	—	—	—	125.0	—	—	—	—	12.0	—	1.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	30.0	Stainless Steel	119.0	100	—	—	—	—	—	Submersible Pump	—	—	—	Generator	Dos	30.0	—	—	Good	—	No	—	31.2	7.3	1250.0	630.0	—	Private-Public-Partnership	—	—	—	—	Yes	0.1	No	—	—	—	Community	—	—	pipelin change, electricity rope, motor repaire	—	Strategic Water Sources Survey – WSS_NATl
662	BHGLCD016	Borehole	FGS_MoEWR	2019-09-14	Galgaduud	Cadaado	Bakiin cadaado	1.0	Community	14-02-14	Farjano cadaado	—	6.13801	46.64638	310.0	3.2	1	68465456722.jpg	Urban	Yes	—	Yes	—	—	—	—	—	—	—	181.0	—	—	73.0	20.0	12.0	2.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	174.0	PVC	1100.0	10166	6	0	Yes	15	18.0	No Pump	—	—	—	—	—	—	—	—	Good	1. They need Solar system	No	—	33.0	6.79	3328.0	2660.0	—	Private/Individual	—	—	—	—	Yes	0.014	No	—	—	—	CPD	Motor change	2017-03-15	Construction Water tank	—	Strategic Water Sources Survey – WSS_NATl
473	BHBYBA049	Borehole	FGS_MoEWR	2019-09-14	Bay	Baydhaba	Isha	—	Warjanay company	14-03-16	Wakalada Borehole	—	3.1159	43.6471	437.0	4.2	—	—	Urban	Yes	—	Yes	—	—	—	—	—	—	—	140.0	—	—	80.0	12.0	16.0	10.0	1.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Stainless Steel	500.0	500	—	—	No	—	—	Submersible Pump	—	12.0	120.0	Generator	JP 45	45.0	—	—	Good	—	No	—	—	—	—	—	—	Private/Individual	—	—	—	—	Yes	0.1	—	—	—	—	IOM - International Organisation of Migration	Installation of submersible pumb 15HP	2016-09-14	2000 Pipeline and generator	—	Strategic Water Sources Survey – WSS_NATl
6250	SPBYBA004	Spring	FGS_MoEWR	2019-09-14	Bay	Baydhaba	Isha Baidoa	—	Chinese Government	08-01-40	Isha Baidoa	—	3.1165	43.6467	437.0	5.0	—	—	—	yes	—	Yes	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	—	PVC	20.0	280	2	—	yes	15	10.0	—	—	—	—	No Pump	—	—	—	—	—	—	no	—	29.8	7.0	1870.0	940.0	—	—	—	—	—	—	yes	0.1	—	—	—	—	—	—	—	Generator or solar, pipeline, solar, building rehabilitation,	—	Strategic Water Sources Survey – WSS_NATl
658	BHGLCD012	Borehole	FGS_MoEWR	2019-09-14	Galgaduud	Cadaado	Waaberi cadaado 2	1.5	Community	09-08-16	Hogol Cadaado 2	—	6.1298	46.63711	312.0	3.2	1	68467265264.jpg	Urban	Yes	—	Yes	—	—	—	—	—	—	—	186.0	—	—	63.0	18.0	22.0	5.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	3100.0	PVC	2500.0	3000	2	0	Yes	9	12.0	No Pump	—	—	—	—	—	—	—	—	Good	It's very good condition	No	—	33.4	6.9	3500.0	2770.0	—	Private/Individual	—	—	—	—	Yes	0.012	No	—	—	—	CPD	Changing the motor	2016-09-17	Construction of water tank	—	Strategic Water Sources Survey – WSS_NATl
692	BHGLCD041	Borehole	FGS_MoEWR	2019-09-14	Galgaduud	Cadaado	Baxdo 1	2.5	Former Somali Government	15-12-80	Baxdo 1	—	5.7912	47.2262	174.0	4.3	2	68445846877.jpg	Rural Urban	Yes	—	Yes	—	—	400	0	150000	0.0	—	190.0	—	—	48.0	23.0	24.0	12.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	150.0	PVC	130.0	1500	0	4	Yes	15	13.0	Submersible Pump	—	—	—	—	—	—	—	—	Poor	1. The betry of solar are functiom	No	—	31.0	6.8	3460.0	2770.0	—	Private-Public-Partnership	—	—	—	—	Yes	0.01	No	—	—	—	SDRO/CARE Somalia	Water tank	2014-08-15	1. Construction of huge Water tank 2. Motor generator	—	Strategic Water Sources Survey – WSS_NATl
686	BHGLCD036	Borehole	FGS_MoEWR	2019-09-14	Galgaduud	Cadaado	Baxdo 3	1.0	Community	13-11-17	Zamzam Baxdo 3	—	5.79959	47.22235	187.0	3.2	2	68452055379.jpg	Rural Urban	Yes	—	Yes	—	—	100	0	10000	0.0	—	270.0	—	—	50.0	16.0	12.0	2.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	100.0	PVC	1000.0	3000	0	2	Yes	7	8.0	No Pump	—	—	—	—	—	—	—	—	Good	1. Motor is very low	No	—	34.0	7.15	3600.0	2079.0	—	Private/Individual	—	—	—	—	Yes	0.01	No	—	—	—	IOM - International Organisation of Migration	Water tank,	2018-06-10	Water tank storage	—	Strategic Water Sources Survey – WSS_NATl
664	BHGLCD018	Borehole	FGS_MoEWR	2019-09-14	Galgaduud	Cadaado	Gidheis	2.0	—	12-08-18	Gidhees	—	6.01529	46.67957	292.0	4.3	0	68433576575.jpg	Rural Urban	Yes	—	Yes	—	—	300	30	100000	0.0	—	208.0	—	—	50.0	17.0	11.0	3.0	1.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	24.0	PVC	80.0	3000	1	2	Yes	10	12.0	Submersible Pump	—	—	—	—	—	—	—	—	Good	Shortage water tank is going to repture Generator is very low	Yes	—	28.3	7.3	3013.0	2050.0	—	Private/Individual	—	—	—	—	Yes	0.02	Yes	—	—	—	—	No	—	Changing the generator	—	Strategic Water Sources Survey – WSS_NATl