SELECT * FROM sessions,people WHERE ip=20315109220 AND enterer=person_noSELECT p.first_name AS contributor_first,p.last_name AS contributor_last,p2.first_name AS enterer_first,p2.last_name AS enterer_last,t.* FROM people p,people p2,samples t WHERE t.contributor_no=p.person_no AND t.enterer_no=p2.person_no AND t.sample_no=197 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=197SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=78SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=197 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Olea' AND (junior_species='woodiana' OR junior_species='woodiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Olea' AND (species='woodiana' OR species='woodiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Olea' AND (species='woodiana' OR species='woodiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Olea' AND (junior_species='woodiana' OR junior_species='woodiana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Olea' AND (species='woodiana' OR species='woodiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' AND (junior_species='ivorensis' OR junior_species='ivorensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Terminalia' AND (species='ivorensis' OR species='ivorensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Terminalia' AND (species='ivorensis' OR species='ivorensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' AND (junior_species='ivorensis' OR junior_species='ivorensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Terminalia' AND (species='ivorensis' OR species='ivorensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptactina' AND (junior_species='platyphylla' OR junior_species='platyphylla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptactina' AND (species='platyphylla' OR species='platyphylla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptactina' AND (species='platyphylla' OR species='platyphylla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptactina' AND (junior_species='platyphylla' OR junior_species='platyphylla')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leptactina' AND (species='platyphylla' OR species='platyphylla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artocarpus' AND (junior_species='heterophyllus' OR junior_species='heterophyllus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Artocarpus' AND (species='heterophyllus' OR species='heterophyllus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Artocarpus' AND (species='heterophyllus' OR species='heterophyllus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artocarpus' AND (junior_species='heterophyllus' OR junior_species='heterophyllus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Artocarpus' AND (species='heterophyllus' OR species='heterophyllus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antidesma' AND (junior_species='venosum' OR junior_species='venosum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Antidesma' AND (species='venosum' OR species='venosum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Antidesma' AND (species='venosum' OR species='venosum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antidesma' AND (junior_species='venosum' OR junior_species='venosum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Antidesma' AND (species='venosum' OR species='venosum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' AND (junior_species='catappa' OR junior_species='catappa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Terminalia' AND (species='catappa' OR species='catappa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Terminalia' AND (species='catappa' OR species='catappa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' AND (junior_species='catappa' OR junior_species='catappa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Terminalia' AND (species='catappa' OR species='catappa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tabebuia' AND (junior_species='pentaphylla' OR junior_species='pentaphylla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tabebuia' AND (species='pentaphylla' OR species='pentaphylla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tabebuia' AND (species='pentaphylla' OR species='pentaphylla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tabebuia' AND (junior_species='pentaphylla' OR junior_species='pentaphylla')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tabebuia' AND (species='pentaphylla' OR species='pentaphylla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysalidocarpus' AND (junior_species='pembanus' OR junior_species='pembanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chrysalidocarpus' AND (species='pembanus' OR species='pembanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chrysalidocarpus' AND (species='pembanus' OR species='pembanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysalidocarpus' AND (junior_species='pembanus' OR junior_species='pembanus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chrysalidocarpus' AND (species='pembanus' OR species='pembanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antiaris' AND (junior_species='toxicaria' OR junior_species='toxicaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Antiaris' AND (species='toxicaria' OR species='toxicaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Antiaris' AND (species='toxicaria' OR species='toxicaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antiaris' AND (junior_species='toxicaria' OR junior_species='toxicaria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Antiaris' AND (species='toxicaria' OR species='toxicaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='brevipes' OR junior_species='brevipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pouteria' AND (species='brevipes' OR species='brevipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pouteria' AND (species='brevipes' OR species='brevipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='brevipes' OR junior_species='brevipes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pouteria' AND (species='brevipes' OR species='brevipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alangium' AND (junior_species='salviifolium' OR junior_species='salviifolium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alangium' AND (species='salviifolium' OR species='salviifolium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alangium' AND (species='salviifolium' OR species='salviifolium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alangium' AND (junior_species='salviifolium' OR junior_species='salviifolium')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Alangium' AND (species='salviifolium' OR species='salviifolium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Croton' AND (junior_species='sylvaticus' OR junior_species='sylvaticus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Croton' AND (species='sylvaticus' OR species='sylvaticus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Croton' AND (species='sylvaticus' OR species='sylvaticus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Croton' AND (junior_species='sylvaticus' OR junior_species='sylvaticus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Croton' AND (species='sylvaticus' OR species='sylvaticus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Milicia' AND (junior_species='excelsa' OR junior_species='excelsa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Milicia' AND (species='excelsa' OR species='excelsa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Milicia' AND (species='excelsa' OR species='excelsa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Milicia' AND (junior_species='excelsa' OR junior_species='excelsa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Milicia' AND (species='excelsa' OR species='excelsa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordia' AND (junior_species='alliodora' OR junior_species='alliodora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cordia' AND (species='alliodora' OR species='alliodora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cordia' AND (species='alliodora' OR species='alliodora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordia' AND (junior_species='alliodora' OR junior_species='alliodora')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cordia' AND (species='alliodora' OR species='alliodora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tectona' AND (junior_species='grandis' OR junior_species='grandis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tectona' AND (species='grandis' OR species='grandis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tectona' AND (species='grandis' OR species='grandis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tectona' AND (junior_species='grandis' OR junior_species='grandis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tectona' AND (species='grandis' OR species='grandis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mangifera' AND (junior_species='indica' OR junior_species='indica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mangifera' AND (species='indica' OR species='indica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mangifera' AND (species='indica' OR species='indica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mangifera' AND (junior_species='indica' OR junior_species='indica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mangifera' AND (species='indica' OR species='indica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quassia' AND (junior_species='undulata' OR junior_species='undulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quassia' AND (species='undulata' OR species='undulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quassia' AND (species='undulata' OR species='undulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quassia' AND (junior_species='undulata' OR junior_species='undulata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Quassia' AND (species='undulata' OR species='undulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyscias' AND (junior_species='fulva' OR junior_species='fulva')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polyscias' AND (species='fulva' OR species='fulva') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polyscias' AND (species='fulva' OR species='fulva')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyscias' AND (junior_species='fulva' OR junior_species='fulva')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Polyscias' AND (species='fulva' OR species='fulva') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rauvolfia' AND (junior_species='mombasiana' OR junior_species='mombasiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rauvolfia' AND (species='mombasiana' OR species='mombasiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rauvolfia' AND (species='mombasiana' OR species='mombasiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rauvolfia' AND (junior_species='mombasiana' OR junior_species='mombasiana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rauvolfia' AND (species='mombasiana' OR species='mombasiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeis' AND (junior_species='guineensis' OR junior_species='guineensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaeis' AND (species='guineensis' OR species='guineensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaeis' AND (species='guineensis' OR species='guineensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeis' AND (junior_species='guineensis' OR junior_species='guineensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Elaeis' AND (species='guineensis' OR species='guineensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tabernaemontana' AND (junior_species='ventricosa' OR junior_species='ventricosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tabernaemontana' AND (species='ventricosa' OR species='ventricosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tabernaemontana' AND (species='ventricosa' OR species='ventricosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tabernaemontana' AND (junior_species='ventricosa' OR junior_species='ventricosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tabernaemontana' AND (species='ventricosa' OR species='ventricosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorindeia' AND (junior_species='madagascariensis' OR junior_species='madagascariensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sorindeia' AND (species='madagascariensis' OR species='madagascariensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sorindeia' AND (species='madagascariensis' OR species='madagascariensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorindeia' AND (junior_species='madagascariensis' OR junior_species='madagascariensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sorindeia' AND (species='madagascariensis' OR species='madagascariensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cedrela' AND (junior_species='mexicana' OR junior_species='mexicana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cedrela' AND (species='mexicana' OR species='mexicana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cedrela' AND (species='mexicana' OR species='mexicana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cedrela' AND (junior_species='mexicana' OR junior_species='mexicana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cedrela' AND (species='mexicana' OR species='mexicana') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=197 The Ecological Register: Makangare bwawani
Makangare bwawani
Basic information
Sample name: Makangare bwawani

Sample aka: Ngezi-Vumawimbi Forest Reserve

Reference: C. L. Nahonyo, L. B. Mwasumbi, C. A. Msuya, C. A. Masao, T. B. Suya, and C. Shingwenda. 2005. Ngezi-Vumawimbi Forest Reserves biodiversity inventory report. CARE Tanzania and Department of Commercial Crops, Fruits and Forestry 1-137 [ER 78]
Geography
Country: Tanzania

State: Zanzibar


Coordinate: 4° 54' 40" S, 39° 41' 40" E
Coordinate basis: stated in text

Geography comments: on Pemba Island
"Most areas... lie between 5 to 10 m a.s.l."

Environment
Habitat: tropical/subtropical savanna

Protection: forest reserve

Substrate: ground surface

Disturbance: hunting,selective logging

WMT: 34.0

CMT: 21.0

MAP: 1860.0

Habitat comments: grassland/forest (grass cover 70%)

Methods
Life forms: trees

Sites: 3

Site area: 0.3

Sampling methods: line transect

Sample size: 69 individuals

Years: 2004-2005

Days: 20

Size min: 10

Basal area: 2.5

Sampling comments: three 20 x 50 m plots

Metadata
Sample number: 197

Contributor: John Alroy

Enterer: Albert Garcia Selles

Created: 2013-03-21 15:09:31

Modified: 2017-11-11 00:23:32

Abundance distribution
23 species
11 singletons
total count 69
extrapolated richness: 63.4
Fisher's α: 12.081
geometric series k: 0.8816
Hurlbert's PIE: 0.8996
Shannon's H: 2.7021
Good's u: 0.8423
Each square represents a species. Square sizes are proportional to counts.
Register