Database Documenation - Rural Water Supply Schemes in Tanzania

database documentation

MoWLD-GTZ Project "Support to the Water Sector Reform Programme" Email: MOWLD.GTZ@africaonline.co.tz

Data Structure The following tables show the data fields that were selected for the trial version. Sample data are used to give a better understanding on the selected data fields.

Address of scheme
Scheme_ID	Name	Region_Name	Address	Town	Telephone	Type
Mikomariro	Mikomariro Water Supply Scheme (SWs)	Mara	P.O.Box Mikomariro	Mihingo		Water Committee
Amani Group	Amani group gravity water scheme	Ruvuma	Box Namasakata	Songea		Water Committee
Angalia H/P	Angalia Handpump Scheme	Ruvuma	P.O. Tunduru			Water Committee
Arri	Arri village water supply scheme	Arusha	C/o Box DED Babati	Babati		Water Committee
Azimio H/P	Azimio Hand Pump Scheme	Ruvuma	Box Azimio	Tunduru	-	Water Committee

Villages belonging to schemes
Scheme_ID	Region	District	Ward	Village	Population
Mikomariro	Mara	Bunda	Mugeta	Mekomariro	2,498
Angalia H/P	Ruvuma	Tunduru	Mtina	Angalia	2,095
Arri	Arusha	Babati	Arri	Arri	1,420
Azimio H/P	Ruvuma	Tunduru	Misechela	Chiungo	1,352
Azimio H/P	Ruvuma	Tunduru	Mtina	Azimio	1,517

Administrative structure and population figures are from the old 1988 census. According to the official homepage of the 2002 population and housing census, by now new data have been only processed up to ward level. The publication of regional reports containing data on village level is expected to be completed by mid 2004.

Physical status of scheme
Scheme_ID	Ref_Year	Development	Repair
Mikomariro	2002	completed	functioning
Amani Group	1999	completed	functioning
Amani Group	2000	completed	functioning
Amani Group	2005	completed	functioning
Angalia H/P	2001	completed	functioning

Revenue and expences
Scheme_ID	Ref_Year	Tariff	Coll_eff	Tot_Income	Expend_Total
Babati	2001	1500/=tshs for private house connection, 4500/= tshs for commecial connection, 2000/=tshs for small institions and 8000/=tshs for hospitals all rates are per month	90
Bukongo Kati	2002			96,396.00	21,400.00
Bumilayinga Hand	1999	800 Tshs / personal / year	50	316,000.00	240,000.00
Bunda Town	2002	Flate rate is Tshs 4000 per month per House Commercial Tshs 7000 per month Metering Tshs 150 per lts	90	10,800,000.00	21,466,812.00
Burma single	1999	1000/=tshs / year / person aged 18 years old and 15000/=tshs /year / house connection	44	320,000.00

Network
Scheme_ID	Ref_Year	Dom Public Taps
Amani Group	1999	20
Azimio H/P	1999
Azimio hand	1999
Berege Water Scheme	2002
Bitimanyanga Hand	1999

Wells
Scheme_ID	Source_ID	Source_Name	Depth	Lining
Mikomariro	Izvor		0	?
Amani Group	test		0	?
Arri	Arri	Arri village area	0	?
Berege Water Scheme	Berege	BH no Do 25/59 Chisale area	111	?
Bitaraguru	Kalisumba	Kasumba		masonry

Springs
Scheme_ID	Source_ID	Source_Name	Conveyance
Amani Group	test-spring		?
Berege Water Scheme	test		?
Bukiriro	Bukirilo	Namhona spring	pipeline
Burma single	Mtupile stream	Liwili Kitesa	pipeline
Dareda	Antsi spring	Bermi	pipeline

Rivers
Scheme_ID	Source_ID	Source_Name	Conveyance
Amani Group	river_1	test river	?
Amani Group	river_2		?
Bitare	Bitare	Bitare area	pipeline
Chala	Kanzike	Chala Ntale	pipeline
Dareda	Endala river	Nou forest	pipeline

Pumps
Scheme_ID	Source_ID	Source_Name	Source Type	Pump Type	Energy Supply
Arri	Arri	Arri village area	shallow well	piston	manual
Bukumbi	Bukumbi	Victoria	dam	?	?
Bukumbi	Bukumbi	Victoria	natural lake	?	?
Bumilayinga Hand	461-1	Bumilayinga village	shallow well	piston	manual
Dumila	Borehole MG 247/97	Dumila area	deep well	centrifugal	electricity