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
283	BHBRBO085	Borehole	Puntland_PWDA	2019-10-26	Bari	Bossaso	Boosaaso	6.0	GUMCO	—	Aaran1	—	11.242	49.2071	59.0	4.9	4	51845516.jpg	Urban	Yes	—	Yes	—	—	—	—	—	—	—	40.0	—	—	—	13.6	—	—	2.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Steel tank	500.0	Stainless Steel	6000.0	—	—	—	No	—	—	Submersible Pump	Italian Lowrance 7.5	18.0	36.0	Generator	Perkins	110.0	—	—	Good	Gumco	No	—	32.0	—	1596.0	793.0	—	Private-Public-Partnership	—	—	—	—	Yes	0.026	No	—	—	—	GUMCO	Gerator	—	Solar power	—	Strategic Water Sources Survey – WSS_NATl
277	BHBRBO079	Borehole	Puntland_PWDA	2019-10-26	Bari	Bossaso	Bossaso	4.0	GUMCO	18-04-17	Ina_aabow	—	11.2522	49.2053	47.0	19.0	3	44431179.jpg	Urban	Yes	—	Yes	—	—	—	—	—	—	—	65.0	—	—	—	—	18.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Steel tank	500.0	PVC	4000.0	—	—	—	No	—	—	Submersible Pump	Lowara 7. 5	35.0	—	Generator	Perkins 65	65.5	—	—	Good	Private company Gumco	Yes	—	27.0	—	1413.0	1342.0	—	Private-Public-Partnership	—	—	—	—	Yes	0.026	No	—	—	—	—	GUMCO	2018-01-19	New Generator	—	Strategic Water Sources Survey – WSS_NATl
1419	BHNGBU003	Borehole	Puntland_PWDA	2019-10-26	Nugaal	Burtinle	Burtinle	0.2	WV - WV - World Vision	25-06-12	Hanad BH2	—	7.6405	47.8135	501.0	—	2	1572456664602.JPG	Rural Urban	Yes	—	Yes	—	—	15000	500	150000	—	—	407.0	—	—	—	10.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	350.0	PVC	3700.0	2500	—	2	Yes	7	8.0	Submersible Pump	Grundfos	—	—	Generator	GP100	100.0	—	—	Good	—	No	—	34.8	—	2410.0	1209.0	—	Private-Public-Partnership	—	—	—	—	Yes	0.03	Yes	—	—	—	IRC - International Rescue Committee	Repair Submersible Pump and GI PIPES	2018-05-26	Solar power, Observation pipe and monitoring	—	Strategic Water Sources Survey – WSS_NATl
4949	DWSNLA007	Dug Well	Somaliland_MoWRD	2019-10-26	Sanaag	Laasqoray	Mindigale	—	Horn Relief	7/17/2003	Mindigale Dug Well	—	10.684	48.6762	823.0	4.288	10	1572070383175.jpg	—	yes	—	No	Since July 2019 its collapse and pump pipe is not work	600	—	—	—	—	Yes	—	—	—	—	—	—	—	—	12.0	6.0	4.0	5.0	11.0	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	—	PVC	1000.0	0	4	0	no	—	—	—	Grundfos	5.0	11.0	Submersible Pump	—	—	Ds72200m	200.0	—	When rain caming its broking the pipeline 150m is not function	No	—	—	—	—	—	—	—	—	—	—	—	Yes	0.01	No	—	—	—	Somaliland MoWRD - Ministry of Water Resources Development	Solar systen pump also 1km of pipeline and kiosks.	2016-09-21	New Dug Well or to put concrete ringing and pipeline replaced 200m and extra kiosk to the town installation of pump 1.4kw granfoss	—	Strategic Water Sources Survey – WSS_NATl
4389	DWSLLA025	Dug Well	Somaliland_MoWRD	2019-10-26	Sool	Laas Caanood	Las Caanood	—	Other	10/20/1940	Dhubuq-dhubuq	—	8.4593	47.4726	682.0	3.216	0	1572066780197.jpg	—	yes	—	Abandoned	Since june 2016,this Dug Well is not appear,and it has no cover.	50	50	0	200	—	No	—	—	—	—	—	—	—	—	1.5	—	0.0	0.0	0.0	—	—	—	—	—	—	—	—	—	—	—	—	Other	—	Other	0.0	—	0	2	no	—	—	—	—	—	—	No Pump	—	—	—	—	—	This Dug Well is not function,also it has no any supply system.	YES	The color of water is greenish it has algae and Bitter taste.	26.0	8.11	1227.0	1330.0	—	—	No	—	—	—	No	—	No	—	—	—	—	No intervention is carried out.	—	This Dug Well is required to construction of animal troughs, Digging the depth of Dug Well and cover.	—	Strategic Water Sources Survey – WSS_NATl
1697	BHSNCR069	Borehole	Somaliland_MoWRD	2019-10-26	Sanaag	Ceerigaabo	Hadaftimo	2.0	Manhal Foundation	27-08-09	Hadaftimo BH1	—	10.7434	48.1102	1309.0	4.3	0	1572090944938.jpg	Urban	No	8	Yes	—	—	—	—	—	—	—	357.0	PVC	8.0	212.0	8.0	8.0	10.0	0.3	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	42.0	Galvanised Steel	150.0	—	1	3	Yes	15	8.0	Submersible Pump	Lowara	16.5	365.0	Generator	Perkins	45.0	—	—	Good	It is Good all pipeline system	No	—	26.6	7.9	790.0	558.0	—	Communal	—	22-01-10	4	1	Yes	0.03	Yes	—	—	—	ACTED	Construction of Store 4x4 animal trough 2 small latrine	2017-11-21	Solar system replaced pump and risen pipe fence	—	Strategic Water Sources Survey – WSS_NATl
1420	BHNGBU004	Borehole	Puntland_PWDA	2019-10-26	Nugaal	Burtinle	Burtinle	0.2	EFAT	30-10-05	Burtinle BH2	—	7.6278	47.8278	491.0	—	1	1572445167116.JPG	Rural Urban	Yes	—	Yes	—	—	1000	0	2000	—	—	345.0	—	—	—	3.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Other	20.0	Other	0.0	0	1	2	Yes	3	6.0	Submersible Pump	Lowara 15kW	—	336.0	Generator	Dk51280	60.0	—	—	Poor	Elevated water tank	No	—	28.0	—	3600.0	1840.0	—	Communal	—	—	—	—	Yes	0.03	Yes	—	—	—	IR - Islamic Relief Somalia/Concern Worldwide Somalia	Repair GI pipe	2016-05-25	Borehole development and cleaning, GI Pipe, Elevated tank 20m cube, full rehabilitation. Solar system.	—	Strategic Water Sources Survey – WSS_NATl
1743	BHSNLA004	Borehole	Somaliland_MoWRD	2019-10-26	Sanaag	Laasqoray	Badhan	17.0	Somaliland MoWRD - Ministry of Water Resources Development	21-06-14	Xubeera 1 BH	—	10.6745	48.4882	933.0	4.3	0	1572099164586.jpg	Urban	No	8	No	Since july 2019 pump is not work and generator	—	—	—	—	—	—	380.0	PVC	8.0	265.0	16.0	8.0	55.0	1.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Concrete/Masonry tank	25.0	Galvanised Steel	200.0	—	2	3	Yes	8	8.0	Submersible Pump	Lowara	16.0	280.0	Generator	Perkins	50.0	—	—	Fair	The pipeline condition is not good condition	No	—	—	—	—	—	—	Utility/Local Authority	—	—	—	—	No	—	Yes	—	—	—	—	—	—	We proposed solar system construction of New caretaker room 300m2 New fencing New elevated water tank rehabilitation existing kiosk pipeline and troughs New mayor pump and cable	—	Strategic Water Sources Survey – WSS_NATl
2689	DWBKCE018	Dug Well	FGS_MoEWR	2019-10-26	Bakool	Ceel Barde	Salku dhooble	—	Community	8/18/1974	Ceel gaab Dw	—	4.9154	44.0235	504.0	4.288	0	1572082292770.jpg	—	yes	—	Yes	—	1500	750	120	7500	0.0	No	—	—	—	—	—	—	—	—	15.0	7.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	Other	—	Other	0.0	0	0	0	no	—	—	—	—	—	—	No Pump	—	—	—	—	—	—	No	—	30.1	7.7	3000.0	1500.0	—	—	—	—	—	—	No	—	No	—	—	—	—	—	—	Deepening, Hund pump, Motor, water strorage , Animal troughs, kiosks and well head protection	—	Strategic Water Sources Survey – WSS_NATl
1427	BHNGBU010	Borehole	Puntland_PWDA	2019-10-26	Nugaal	Burtinle	Burtinle	3.0	WDA	25-03-90	Burtinle BH1	—	7.6234	47.8358	493.0	4.9	1	—	Rural	Yes	—	No	Broken of generator	—	2500	500	30000	—	—	357.0	—	—	—	3.0	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	20.0	—	—	—	—	—	—	—	—	—	—	—	300.0	—	—	—	—	—	—	—	—	—	—	7.0	3088.0	—	—	Community	—	—	—	—	—	—	—	—	—	—	—	—	—	Improve	Drilledwell serves 4000 people and their animals General maintenace of drilledwell required	Strategic Water Sources Survey – WSS_NATl