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=121 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=121SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=39SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=121 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Copaifera' AND (junior_species='salikounda' OR junior_species='salikounda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Copaifera' AND (species='salikounda' OR species='salikounda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Copaifera' AND (species='salikounda' OR species='salikounda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Copaifera' AND (junior_species='salikounda' OR junior_species='salikounda')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='Copaifera' AND (species='salikounda' OR species='salikounda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorophora' 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='Chlorophora' AND (species='excelsa' OR species='excelsa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlorophora' AND (species='excelsa' OR species='excelsa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorophora' 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='Chlorophora' AND (species='excelsa' OR species='excelsa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dacryodes' AND (junior_species='klaineana' OR junior_species='klaineana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dacryodes' AND (species='klaineana' OR species='klaineana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dacryodes' AND (species='klaineana' OR species='klaineana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dacryodes' AND (junior_species='klaineana' OR junior_species='klaineana')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='Dacryodes' AND (species='klaineana' OR species='klaineana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ricinodendron' AND (junior_species='heudelotii' OR junior_species='heudeloti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ricinodendron' AND (species='heudelotii' OR species='heudeloti') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ricinodendron' AND (species='heudelotii' OR species='heudeloti')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ricinodendron' AND (junior_species='heudelotii' OR junior_species='heudeloti')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='Ricinodendron' AND (species='heudelotii' OR species='heudeloti') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Entandrophragma' AND (junior_species='angolense' OR junior_species='angolense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Entandrophragma' AND (species='angolense' OR species='angolense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Entandrophragma' AND (species='angolense' OR species='angolense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Entandrophragma' AND (junior_species='angolense' OR junior_species='angolense')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='Entandrophragma' AND (species='angolense' OR species='angolense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' AND (junior_species='superba' OR junior_species='superba')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Terminalia' AND (species='superba' OR species='superba') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Terminalia' AND (species='superba' OR species='superba')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' AND (junior_species='superba' OR junior_species='superba')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='superba' OR species='superba') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Omphalocarpum' AND (junior_species='elatum' OR junior_species='elatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Omphalocarpum' AND (species='elatum' OR species='elatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Omphalocarpum' AND (species='elatum' OR species='elatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Omphalocarpum' AND (junior_species='elatum' OR junior_species='elatum')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='Omphalocarpum' AND (species='elatum' OR species='elatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celtis' AND (junior_species='mildbraedii' OR junior_species='mildbraedi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Celtis' AND (species='mildbraedii' OR species='mildbraedi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Celtis' AND (species='mildbraedii' OR species='mildbraedi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celtis' AND (junior_species='mildbraedii' OR junior_species='mildbraedi')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='Celtis' AND (species='mildbraedii' OR species='mildbraedi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Piptadeniastrum' AND (junior_species='africanum' OR junior_species='africanum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Piptadeniastrum' AND (species='africanum' OR species='africanum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Piptadeniastrum' AND (species='africanum' OR species='africanum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Piptadeniastrum' AND (junior_species='africanum' OR junior_species='africanum')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='Piptadeniastrum' AND (species='africanum' OR species='africanum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quassia' AND (junior_species='gabonensis' OR junior_species='gabonensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quassia' AND (species='gabonensis' OR species='gabonensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quassia' AND (species='gabonensis' OR species='gabonensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quassia' AND (junior_species='gabonensis' OR junior_species='gabonensis')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='gabonensis' OR species='gabonensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xylia' AND (junior_species='evansii' OR junior_species='evansi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xylia' AND (species='evansii' OR species='evansi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xylia' AND (species='evansii' OR species='evansi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xylia' AND (junior_species='evansii' OR junior_species='evansi')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='Xylia' AND (species='evansii' OR species='evansi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Distemonanthus' AND (junior_species='benthamianus' OR junior_species='benthamianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Distemonanthus' AND (species='benthamianus' OR species='benthamianus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Distemonanthus' AND (species='benthamianus' OR species='benthamianus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Distemonanthus' AND (junior_species='benthamianus' OR junior_species='benthamianus')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='Distemonanthus' AND (species='benthamianus' OR species='benthamianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Irvingia' AND (junior_species='gabonensis' OR junior_species='gabonensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Irvingia' AND (species='gabonensis' OR species='gabonensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Irvingia' AND (species='gabonensis' OR species='gabonensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Irvingia' AND (junior_species='gabonensis' OR junior_species='gabonensis')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='Irvingia' AND (species='gabonensis' OR species='gabonensis') 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='Guarea' AND (junior_species='cedrata' OR junior_species='cedrata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Guarea' AND (species='cedrata' OR species='cedrata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Guarea' AND (species='cedrata' OR species='cedrata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guarea' AND (junior_species='cedrata' OR junior_species='cedrata')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='Guarea' AND (species='cedrata' OR species='cedrata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aningeria' AND (junior_species='robusta' OR junior_species='robusta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aningeria' AND (species='robusta' OR species='robusta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aningeria' AND (species='robusta' OR species='robusta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aningeria' AND (junior_species='robusta' OR junior_species='robusta')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='Aningeria' AND (species='robusta' OR species='robusta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nesogordonia' AND (junior_species='papaverifera' OR junior_species='papaverifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nesogordonia' AND (species='papaverifera' OR species='papaverifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nesogordonia' AND (species='papaverifera' OR species='papaverifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nesogordonia' AND (junior_species='papaverifera' OR junior_species='papaverifera')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='Nesogordonia' AND (species='papaverifera' OR species='papaverifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sterculia' AND (junior_species='rhinopetala' OR junior_species='rhinopetala')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sterculia' AND (species='rhinopetala' OR species='rhinopetala') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sterculia' AND (species='rhinopetala' OR species='rhinopetala')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sterculia' AND (junior_species='rhinopetala' OR junior_species='rhinopetala')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='Sterculia' AND (species='rhinopetala' OR species='rhinopetala') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strombosia' AND (junior_species='glaucescens' OR junior_species='glaucescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Strombosia' AND (species='glaucescens' OR species='glaucescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Strombosia' AND (species='glaucescens' OR species='glaucescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strombosia' AND (junior_species='glaucescens' OR junior_species='glaucescens')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='Strombosia' AND (species='glaucescens' OR species='glaucescens') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=121 The Ecological Register: Kade site F
Kade site F
Basic information
Sample name: Kade site F

Reference: M. D. Swaine and J. B. Hall. 1988. The mosaic theory of forest regeneration and the determination of forest composition in Ghana. Journal of Tropical Ecology 4(3):253-269 [ER 39]
Geography
Country: Ghana

State: Kwaebibirem


Coordinate: 6° 9' N, 0° 55' W
Coordinate basis: stated in text

Geography comments: elevation is for the Agricultural Research Station and is from Epp (1987, Journal of Tropical Ecology)

Environment
Habitat: tropical/subtropical moist broadleaf forest

Substrate: ground surface

MAT: 28.0

MAP: 1179.0

Dry months: 4

Habitat comments: climate data are for the station and are based on Owusu-Bennoah et al. (2000, West African Journal of Applied Ecology), who state that "80 pe cent" of rainfall falls "from March to mid-July and from September to November"

Methods
Life forms: trees

Sites: 1

Site length: 50

Site width: 50

Sampling methods: quadrat

Sample size: 37 individuals

Years: 1974-1975

Size min: 10

Sampling comments: basal area is not given by Lawson et al. (1970)

Metadata
Sample number: 121

Contributor: John Alroy

Enterer: Albert Garcia Selles

Created: 2013-03-04 10:21:31

Modified: 2017-11-11 23:01:30

Abundance distribution
19 species
10 singletons
total count 37
extrapolated richness: 71.2
Fisher's α: 15.676
geometric series k: 0.8799
Hurlbert's PIE: 0.8896
Shannon's H: 2.6372
Good's u: 0.7398
Each square represents a species. Square sizes are proportional to counts.
Register