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=200 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=200SELECT 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=200 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Voacanga' AND (junior_species='africana' OR junior_species='africana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Voacanga' AND (species='africana' OR species='africana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Voacanga' AND (species='africana' OR species='africana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Voacanga' AND (junior_species='africana' OR junior_species='africana')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='Voacanga' AND (species='africana' OR species='africana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Haplocoelum' AND (junior_species='inoploeum' OR junior_species='inoploeum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Haplocoelum' AND (species='inoploeum' OR species='inoploeum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Haplocoelum' AND (species='inoploeum' OR species='inoploeum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Haplocoelum' AND (junior_species='inoploeum' OR junior_species='inoploeum')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='Haplocoelum' AND (species='inoploeum' OR species='inoploeum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' AND (junior_species='boivinii' OR junior_species='boivini')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Terminalia' AND (species='boivinii' OR species='boivini') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Terminalia' AND (species='boivinii' OR species='boivini')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' AND (junior_species='boivinii' OR junior_species='boivini')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='boivinii' OR species='boivini') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Manilkara' AND (junior_species='sansibarensis' OR junior_species='sansibarensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Manilkara' AND (species='sansibarensis' OR species='sansibarensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Manilkara' AND (species='sansibarensis' OR species='sansibarensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Manilkara' AND (junior_species='sansibarensis' OR junior_species='sansibarensis')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='Manilkara' AND (species='sansibarensis' OR species='sansibarensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adansonia' AND (junior_species='digitata' OR junior_species='digitata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adansonia' AND (species='digitata' OR species='digitata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adansonia' AND (species='digitata' OR species='digitata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adansonia' AND (junior_species='digitata' OR junior_species='digitata')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='Adansonia' AND (species='digitata' OR species='digitata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bourreria' AND (junior_species='petiolaris' OR junior_species='petiolaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bourreria' AND (species='petiolaris' OR species='petiolaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bourreria' AND (species='petiolaris' OR species='petiolaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bourreria' AND (junior_species='petiolaris' OR junior_species='petiolaris')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='Bourreria' AND (species='petiolaris' OR species='petiolaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Manilkara' AND (junior_species='sulcata' OR junior_species='sulcata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Manilkara' AND (species='sulcata' OR species='sulcata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Manilkara' AND (species='sulcata' OR species='sulcata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Manilkara' AND (junior_species='sulcata' OR junior_species='sulcata')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='Manilkara' AND (species='sulcata' OR species='sulcata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cussonia' AND (junior_species='zimmermannii' OR junior_species='zimmermanni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cussonia' AND (species='zimmermannii' OR species='zimmermanni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cussonia' AND (species='zimmermannii' OR species='zimmermanni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cussonia' AND (junior_species='zimmermannii' OR junior_species='zimmermanni')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='Cussonia' AND (species='zimmermannii' OR species='zimmermanni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='consolatae' OR junior_species='consolatae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diospyros' AND (species='consolatae' OR species='consolatae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='consolatae' OR species='consolatae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='consolatae' OR junior_species='consolatae')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='Diospyros' AND (species='consolatae' OR species='consolatae') 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='Pandanus' AND (junior_species='kirkii' OR junior_species='kirki')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pandanus' AND (species='kirkii' OR species='kirki') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pandanus' AND (species='kirkii' OR species='kirki')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pandanus' AND (junior_species='kirkii' OR junior_species='kirki')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='Pandanus' AND (species='kirkii' OR species='kirki') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allophylus' AND (junior_species='pervillei' OR junior_species='pervilleii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Allophylus' AND (species='pervillei' OR species='pervilleii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Allophylus' AND (species='pervillei' OR species='pervilleii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allophylus' AND (junior_species='pervillei' OR junior_species='pervilleii')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='Allophylus' AND (species='pervillei' OR species='pervilleii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='cordatum' OR junior_species='cordatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syzygium' AND (species='cordatum' OR species='cordatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syzygium' AND (species='cordatum' OR species='cordatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='cordatum' OR junior_species='cordatum')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='Syzygium' AND (species='cordatum' OR species='cordatum') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=200 The Ecological Register: Machopeni
Machopeni
Basic information
Sample name: Machopeni

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° 55' 29" S, 39° 42' 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 moist broadleaf forest

Altered habitat: disturbed forest

Protection: forest reserve

Substrate: ground surface

Disturbance: selective logging

WMT: 34.0

CMT: 21.0

MAP: 1860.0

Habitat comments: "evergreen moist forest" with "Signs of harvesting of building poles"

Methods
Life forms: trees

Sites: 1

Site area: 0.1

Sampling methods: line transect

Sample size: 50 individuals

Years: 2004-2005

Days: 20

Size min: 10

Basal area: 0.236

Sampling comments: one 20 x 50 m plot

Metadata
Sample number: 200

Contributor: John Alroy

Enterer: Albert Garcia Selles

Created: 2013-03-21 15:29:11

Modified: 2017-11-11 00:24:42

Abundance distribution
13 species
3 singletons
total count 50
extrapolated richness: 25.1
Fisher's α: 5.705
geometric series k: 0.7980
Hurlbert's PIE: 0.8441
Shannon's H: 2.1946
Good's u: 0.9431
Each square represents a species. Square sizes are proportional to counts.
Register