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
1606	BHSLXU007	Borehole	Somaliland_MoWRD	11/3/2019	Sool	Xudun	Sarmaanyo	2.0	—	8/6/2016	Sarmaanyo BH1	—	9.484	47.9874	921.0	4.3	0	1572752589915.jpg	Urban	Yes	—	No	Since july 2016,cracks of surface casing	—	—	—	—	—	—	350.0	PVC	8.0	100.0	8.0	4.0	—	0.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	32.0	Galvanised Steel	400.0	0	2	6	Yes	5	6.0	Submersible Pump	Lowara	15.0	330.0	Generator	Perkins	45.0	—	—	Good	—	No	—	—	—	—	—	—	Communal	—	8/10/2019	5	2	No	—	No	—	—	—	—	No intervention	—	Increasing the number of animal troughs. Fixing the doors and windows of care taker room. Solar installation	—	Strategic Water Sources Survey – WSS_NAT
5907	DMSNCR001	Dam	Somaliland_MoWRD	11/3/2019	Sanaag	Ceerigaabo	Jiidali	3.0	ARC	8/4/2016	jiidali Dam	—	10.6813	47.6903	1398.0	4.288	0	1572841556553.jpg	—	No	6	Yes	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	2.0	60.0	60.0	—	—	—	—	—	—	—	—	Steel tank	—	Galvanised Steel	60.0	0	1	2	No	—	—	—	—	—	—	No Pump	—	—	—	—	—	Good condition	no	—	16.7	—	557.0	415.0	—	—	—	—	—	—	No	—	No	—	—	—	—	—	—	New elevation water tank plastic sheit sollar system water pump and fence	—	Strategic Water Sources Survey – WSS_NAT
5491	DMAWBO014	Dam	Somaliland_MoWRD	11/29/2019	Awdal	Borama	Hol hol	0.0	Chinese Government	8/3/1970	Hol hol	—	9.9207	43.1412	1494.0	4.288	0	1575005878786.jpg	—	Yes	—	Yes	—	—	20	100	200	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	3.0	100.0	100.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	No Pump	—	—	—	—	—	There's no any supply system is not function	yes	The color of water is greenish	11.0	9.3	1604.0	600.0	—	—	—	—	—	—	No	—	No	—	—	—	—	—	—	It needs plastic bag It needs animal troughs and water points. This village is suitable function	—	Strategic Water Sources Survey – WSS_NAT
14	BHAWBO007	Borehole	Somaliland_MoWRD	11/29/2019	Awdal	Borama	Afraaga	0.5	Kuwait Government	29-11-03	Afraag BH1	—	9.9432	43.0761	1361.0	3.2	1	1575008843134.jpg	Rural Urban	Yes	—	Yes	—	—	500	1500	1000	—	—	134.0	GI	8.0	100.0	7.0	4.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	26.0	Galvanised Steel	500.0	0	1	3	Yes	6	8.0	Submersible Pump	Lowara	18.5	117.0	Generator	Perkins	40.0	—	—	Good	—	No	—	15.0	8.12	1332.0	940.0	—	Communal	—	24-04-03	4	3	Yes	0.6	Yes	—	—	—	CARE Somalia	Construction of elevated water tank Pipe line extention.	3/28/2017	It needs installation of solar and water points Replacement of animal troughs	—	Strategic Water Sources Survey – WSS_NAT
97	BHAWBO083	Borehole	Somaliland_MoWRD	11/29/2019	Awdal	borama	Cunaqabad	0.0	UNICEF - United Nations Children's Fund	3/8/2017	Afraag BH5	—	9.9314	43.0772	1373.0	4.3	1	1575017426807.jpg	—	Yes	—	No	Since june 2017,there is no system but at this time the function on going	—	—	—	—	—	—	301.0	GI	8.0	100.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Poor	There is no water supply system but at this time preparing function from Afraag to Borama	Yes	—	—	—	—	—	—	Communal	—	—	—	—	No	—	No	—	—	—	—	—	—	At this time the function on going	—	Strategic Water Sources Survey – WSS_NAT
12	BHAWBO005	Borehole	Somaliland_MoWRD	11/29/2019	Awdal	Borama	Degmo laqas	0.0	—	29-10-18	Degmolaqas	—	9.9464	43.0747	1361.0	4.3	0	1575011716453.jpg	Rural	Yes	—	Yes	—	—	0	100	500	0.0	—	204.0	GI	8.0	80.0	10.0	5.0	—	0.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	50.0	Galvanised Steel	30.0	0	1	2	No	—	—	Submersible Pump	Grundfos	18.0	120.0	Hybrid - Solar/Generator	Iveco	60.0	Photovoltaic	22.5	Good	—	No	—	15.0	8.16	1360.0	973.0	—	Communal	—	2/3/2018	5	2	Yes	0.6	Yes	—	—	—	—	No intervention	—	Increasing construction of animal troughs and water points.	—	Strategic Water Sources Survey – WSS_NAT
2349	DWAWBA067	Dug Well	Somaliland_MoWRD	11/29/2019	Awdal	Baki	Garabo dadar	—	UNICEF - United Nations Children's Fund	6/15/2018	Garabo dadar shellow	—	10.2204	43.6264	495.0	4.9	1	1575033401493.jpg	—	yes	—	Yes	—	1000	—	—	—	—	Yes	—	—	—	—	—	—	—	—	4.0	2.0	3.0	9.0	2.0	—	—	—	—	—	—	—	—	—	—	—	—	Steel tank	—	Stainless Steel	5000.0	65	5	0	no	—	—	—	Grundfos	3.0	4.0	Submersible Pump	—	—	Banal 24	240.0	—	Is good condition of supply system	No	—	—	—	—	—	—	—	Yes	6/22/2016	4	3	Yes	0.3	No	—	—	—	—	Reservoir and pipeline	5/29/2019	Extra generator	—	Strategic Water Sources Survey – WSS_NAT
16	BHAWBO009	Borehole	Somaliland_MoWRD	11/29/2019	Awdal	Borama	Afraag	1.0	—	29-06-17	Afraag BH3	—	9.9355	43.081	1372.0	3.2	0	1575015890300.jpg	Rural	Yes	—	Yes	—	—	120	250	50	10.0	—	250.0	GI	6.0	100.0	5.0	10.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	50.0	Galvanised Steel	50.0	0	1	3	No	—	—	Submersible Pump	Grundfos	7.5	144.0	Hybrid - Solar/Generator	Perkins	45.0	Photovoltaic	22.5	Good	—	No	—	28.0	7.07	1551.0	1100.0	—	Communal	—	25-03-17	10	0	Yes	0.6	Yes	—	—	—	—	—	—	Replacement pipe line and pump water Rehabilitation animal troughs and water points	—	Strategic Water Sources Survey – WSS_NAT
5496	DMAWBO019	Dam	Somaliland_MoWRD	11/29/2019	Awdal	Borama	Abuqays	1.0	Chinese Government	8/3/1970	Abuqays	—	9.9276	43.1106	1428.0	3.216	0	1575007203483.jpg	—	Yes	—	Yes	—	—	10	50	100	0.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	3.0	60.0	60.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	There's no any supply system is not function	yes	The color of water is greenish and algae	—	—	—	—	—	—	—	—	—	—	No	—	No	—	—	—	—	—	—	It needs plastic bag It needs animal troughs and water points	—	Strategic Water Sources Survey – WSS_NAT
15	BHAWBO008	Borehole	Somaliland_MoWRD	11/29/2019	Awdal	Borama	Afraag	0.0	UNICEF - United Nations Children's Fund	3/8/2015	Afraag BH2	—	9.9431	43.0761	1361.0	3.2	1	1575010676823.jpg	Urban	Yes	—	Yes	—	—	—	—	—	—	—	200.0	GI	8.0	75.0	0.0	0.0	—	0.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	0.0	—	—	—	—	—	No	—	—	—	—	—	—	—	—	—	—	—	Poor	There's no any supply system but at this time the preparing function from afraag to borama	No	—	—	—	—	—	—	Communal	—	—	—	—	No	—	No	—	—	—	—	—	—	At this time the company Shaba preparing pipe line extention from afraag to Borama. The function on going	—	Strategic Water Sources Survey – WSS_NAT