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
106	BHAWLU009	Borehole	Somaliland_MoWRD	2019-11-30	Awdal	Lughaye	Kalowla	0.0	COOPI - Cooperazione Internazionale	17-02-95	Kalawla bore hole one	—	10.5519	43.8516	99.0	4.9	2	1575099051362.jpg	Rural Urban	Yes	—	Yes	—	—	80	0	2000	0.0	—	95.0	GI	6.0	—	—	12.0	2.0	24.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	—	Stainless Steel	25.0	2	2	6	Yes	2	50.0	No Pump	Lowara UK	10.0	95.0	Solar	—	—	—	—	Good	—	Yes	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	2001-06-12	—	—	Strategic Water Sources Survey – WSS_NATl
6081	SPAWBA012	Spring	Somaliland_MoWRD	2019-11-30	Awdal	Baki	Qabri baxar velly	—	—	—	Qabri baxar spring	—	10.2882	43.7136	385.0	4.9	1	1575089473729.jpg	—	no	12	Yes	—	—	70	0	2000	5.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	0.0	—	—	—	—	Other	—	Other	0.0	150	0	0	no	—	—	—	—	—	—	No Pump	—	—	—	—	—	I	no	—	—	—	—	—	—	—	no	—	—	—	no	—	no	—	—	—	—	—	—	—	—	Strategic Water Sources Survey – WSS_NATl
2349	DWAWBA067	Dug Well	Somaliland_MoWRD	2019-11-29	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	2019-05-29	Extra generator	—	Strategic Water Sources Survey – WSS_NATl
5491	DMAWBO014	Dam	Somaliland_MoWRD	2019-11-29	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_NATl
16	BHAWBO009	Borehole	Somaliland_MoWRD	2019-11-29	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_NATl
14	BHAWBO007	Borehole	Somaliland_MoWRD	2019-11-29	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.	2017-03-28	It needs installation of solar and water points Replacement of animal troughs	—	Strategic Water Sources Survey – WSS_NATl
6079	SPAWBA010	Spring	Somaliland_MoWRD	2019-11-29	Awdal	Baki	Garabo dadar	—	—	—	Garabo dadar spring	—	10.2343	43.6394	459.0	4.7	1	1575036013474.jpg	—	yes	—	Yes	—	—	70	0	2000	7.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	12.0	—	—	—	—	Other	—	Other	0.0	0	0	0	no	—	—	—	—	—	—	No Pump	—	—	—	—	—	Is good condition thise spring	no	—	—	—	—	—	—	—	—	—	—	—	no	—	no	—	—	—	—	—	—	Gabyans and sand dam	—	Strategic Water Sources Survey – WSS_NATl
12	BHAWBO005	Borehole	Somaliland_MoWRD	2019-11-29	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	—	02-03-18	5	2	Yes	0.6	Yes	—	—	—	—	No intervention	—	Increasing construction of animal troughs and water points.	—	Strategic Water Sources Survey – WSS_NATl
5496	DMAWBO019	Dam	Somaliland_MoWRD	2019-11-29	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_NATl
15	BHAWBO008	Borehole	Somaliland_MoWRD	2019-11-29	Awdal	Borama	Afraag	0.0	UNICEF - United Nations Children's Fund	03-08-15	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_NATl