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
470	BHBYBA046	Borehole	FGS_MoEWR	2019-09-19	Bay	Baydhaba	Bula Jadid	2.0	UNHCR - United Nations High Commission for Refugees	11-03-19	Ceelka Soolarka	—	3.1385	43.6389	466.0	4.7	—	68891091585.jpg	Rural Urban	No	—	No	Is a new borehole and under construction	—	—	—	—	—	—	160.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	No	—	—	—	—	—	—	—	—	—	—	—	—	—	No	—	—	—	—	—	—	Communal	—	—	—	—	No	—	—	—	—	—	—	—	—	Solar repair, 20 m3 storage tank, 2 kiosk, 40m pipeline, fence, care taker room, toilet.	—	Strategic Water Sources Survey – WSS_NATl
782	BHGLDH036	Borehole	FGS_MoEWR	2019-09-19	Galgaduud	Dhusa Marreb	Mareer guur	2.0	Former Somali Government	24-03-74	MareerGuur	—	5.7559	46.5087	278.0	3.2	1	68873348442.jpg	Rural Urban	Yes	—	Yes	—	—	200	20	1000000	10.0	—	105.0	—	—	21.0	12.0	24.0	3.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	172.0	PVC	1000.0	700	2	3	Yes	20	9.0	No Pump	—	—	—	—	—	—	—	—	Good	Shortage of water Tank	No	—	30.0	7.53	1480.0	3540.0	—	Communal	—	15-11-00	5	0	Yes	0.001	Yes	—	—	—	NRC - Norwegian Refugee Council	Construction solar	2018-05-16	1. Construction of an other tank 2. Changing the motor	—	Strategic Water Sources Survey – WSS_NATl
779	BHGLDH033	Borehole	FGS_MoEWR	2019-09-19	Galgaduud	Dhusa Marreb	Between waaberi and Waxarcadde	5.0	Personal(Dhoobshax)	23-05-14	SHABAX	—	5.5375	46.3977	251.0	4.3	1	68882543998.jpg	Rural Urban	Yes	—	Yes	—	—	100	150	100000	10.0	—	174.0	—	—	10.0	70.0	10.0	7.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	770.0	PVC	2500.0	3640	1	0	Yes	12	9.0	Submersible Pump	—	—	—	—	—	—	—	—	Poor	Its has no water trought	No	—	32.0	7.0	2430.0	2220.0	—	Private/Individual	—	—	—	—	Yes	0.02	Yes	—	—	—	NRC - Norwegian Refugee Council	Water Tank	2017-06-01	1. Constructing Solar 2. Construction of water trought 3. Pum is needed rehabilitation	—	Strategic Water Sources Survey – WSS_NATl
3898	DWMDHO040	Dug Well	FGS_MoEWR	2019-09-19	Mudug	Hobyo	Baadwein	—	Community	5/26/2017	Baadwein Dug Well	—	5.3201	47.9168	112.0	—	145	1569592119346.jpg	—	yes	—	Yes	—	32500	500	100	1550	0.5	No	—	—	—	—	—	—	—	—	10.0	6.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	10000	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	No	—	29.7	8.12	2160.0	1062.0	—	—	Yes	12/16/1985	3	2	No	—	No	—	—	—	Community	Deepening and cleaning	2018-02-23	New borehole and solar system	—	Strategic Water Sources Survey – WSS_NATl
776	BHGLDH031	Borehole	FGS_MoEWR	2019-09-19	Galgaduud	Dhusa Marreb	Dayax	—	ICRC - International Committee of The Red Cross	20-07-18	Ceel cagaf	—	5.5385	46.3835	256.0	4.3	4	68878100383.jpg	Urban	Yes	—	Yes	—	—	—	—	—	—	—	120.0	—	—	2.21	20.0	19.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	24.0	Galvanised Steel	—	850	5	2	Yes	10	10.8	Submersible Pump	—	10.0	28.0	Solar	—	—	—	—	Fair	—	No	—	30.0	7.39	2415.0	1960.0	—	Communal	—	—	—	—	No	—	No	—	—	—	—	—	—	1. Pipe and supply	—	Strategic Water Sources Survey – WSS_NATl
6730	BKMDHO012	Berkad	FGS_MoEWR	2019-09-19	Mudug	Hobyo	Barak Ise	0.02	Community	02/13/2010	Barak Isse Berkad	—	5.5574	47.6486	119.0	4.288	15	1568877088281.jpg	—	no	4	Yes	—	—	300	50	1000	0.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	10.0	20.0	15.0	—	—	—	—	—	Concrete/Masonry tank	—	—	—	3000	0	0	no	—	—	—	—	—	—	No Pump	—	—	—	—	—	No supply techniques	no	—	31.8	7.05	4135.0	1310.0	—	—	yes	1/22/2011	7	2	no	—	no	—	—	—	Community	Cleaning	2019-03-10	New borehole and full rehabilitation to these Berkads	—	Strategic Water Sources Survey – WSS_NATl
762	BHGLDH020	Borehole	FGS_MoEWR	2019-09-19	Galgaduud	Dhusa Marreb	Kax ina baarey	6.0	EHH	24-05-17	Kax ina baarey	—	5.5156	46.3641	256.0	3.2	2	68884832197.jpg	Rural Urban	Yes	—	Yes	—	—	200	50	50000	1.0	—	120.0	—	—	6.0	80.0	12.0	1.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	960.0	PVC	500.0	200	1	3	Yes	15	10.0	—	—	—	—	—	—	—	—	—	Good	Its very good condition	No	—	32.7	7.06	1840.0	1467.0	—	Private/Individual	—	—	—	—	Yes	0.01	Yes	—	—	—	—	No intervention	—	1. Construction an other tank 2. Pum and motor is needed rehabilitation	—	Strategic Water Sources Survey – WSS_NATl
758	BHGLDH017	Borehole	FGS_MoEWR	2019-09-19	Galgaduud	Dhusa Marreb	Ceeldheer	3.0	Ahmed Salad Naxar	13-02-12	Ceeldheer	—	5.3685	46.1855	264.0	3.2	0	68888019392.jpg	Rural	Yes	—	Yes	—	—	30	10	30000	12.0	—	42.0	—	—	3.0	18.0	12.0	2.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	176.0	PVC	2000.0	160	0	2	Yes	5	8.0	Submersible Pump	—	—	—	—	—	—	—	—	Fair	Uncover of water tank	No	—	33.6	6.91	2078.0	1604.0	—	Private/Individual	—	—	—	—	Yes	0.01	Yes	—	—	—	NRC - Norwegian Refugee Council	Rehabilitation of water tank and water supply	2018-11-20	1. Construction of water tank 2. Covering water tank 3. Construction kiosks 4. Construction of solar	—	Strategic Water Sources Survey – WSS_NATl
739	BHGLDH004	Borehole	FGS_MoEWR	2019-09-19	Galgaduud	Dhusa Marreb	Ceel baraf	1.0	NRC - Norwegian Refugee Council	01-01-19	Ceel Baraf2	—	5.2366	45.8229	332.0	4.3	0	—	Rural	No	—	No	This source stopped before three days, Pum is blocked and nd then the people is trucking fromGuricel	—	—	—	—	—	—	153.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Lowara	—	—	—	—	—	—	—	—	—	—	—	—	7.5	2944.0	—	—	Private	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Strategic Water Sources Survey – WSS_NATl
1331	BHMDHO050	Borehole	FGS_MoEWR	2019-09-19	Mudug	Hobyo	Gawaan	40.0	GSA - General Service Agency	18-04-10	Gawaan BH	—	5.3314	48.325	165.0	—	0	1569152043802.jpg	Rural Urban	Yes	—	Yes	—	—	800	400	40000	0.0	—	240.0	PVC	8.0	120.0	24.0	24.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	50.0	Galvanised Steel	30000.0	18000	1	3	Yes	8	10.0	Submersible Pump	Franklin	15.0	170.0	Hybrid - Solar/Generator	Dos	60.0	Jeck	250.0	Good	—	No	—	29.1	7.4	2390.0	1180.0	—	Communal	—	10-05-06	4	2	Yes	0.001	Yes	—	—	—	Community	Pumps, pipelines and generator	2013-03-17	Large tanks and pipelines with full rehabilitation	—	Strategic Water Sources Survey – WSS_NATl