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=118 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=118SELECT 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=118 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Afzelia' AND (junior_species='bella' OR junior_species='bella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Afzelia' AND (species='bella' OR species='bella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Afzelia' AND (species='bella' OR species='bella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Afzelia' AND (junior_species='bella' OR junior_species='bella')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='Afzelia' AND (species='bella' OR species='bella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Klainedoxa' 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='Klainedoxa' AND (species='gabonensis' OR species='gabonensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Klainedoxa' AND (species='gabonensis' OR species='gabonensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Klainedoxa' 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='Klainedoxa' AND (species='gabonensis' OR species='gabonensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Albizia' AND (junior_species='ferruginea' OR junior_species='ferruginea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Albizia' AND (species='ferruginea' OR species='ferruginea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Albizia' AND (species='ferruginea' OR species='ferruginea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Albizia' AND (junior_species='ferruginea' OR junior_species='ferruginea')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='Albizia' AND (species='ferruginea' OR species='ferruginea') ORDER BY year,last_namesSELECT 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='Mammea' 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='Mammea' AND (species='africana' OR species='africana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mammea' AND (species='africana' OR species='africana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mammea' 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='Mammea' AND (species='africana' OR species='africana') 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='Ophiobotrys' AND (junior_species='zenkeri' OR junior_species='zenkerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ophiobotrys' AND (species='zenkeri' OR species='zenkerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ophiobotrys' AND (species='zenkeri' OR species='zenkerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ophiobotrys' AND (junior_species='zenkeri' OR junior_species='zenkerii')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='Ophiobotrys' AND (species='zenkeri' OR species='zenkerii') 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='Pycnanthus' AND (junior_species='angolensis' OR junior_species='angolensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pycnanthus' AND (species='angolensis' OR species='angolensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pycnanthus' AND (species='angolensis' OR species='angolensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pycnanthus' AND (junior_species='angolensis' OR junior_species='angolensis')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='Pycnanthus' AND (species='angolensis' OR species='angolensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parinari' 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='Parinari' AND (species='excelsa' OR species='excelsa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parinari' AND (species='excelsa' OR species='excelsa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parinari' 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='Parinari' AND (species='excelsa' OR species='excelsa') 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='Amphimas' AND (junior_species='pterocarpoides' OR junior_species='pterocarpoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amphimas' AND (species='pterocarpoides' OR species='pterocarpoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amphimas' AND (species='pterocarpoides' OR species='pterocarpoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphimas' AND (junior_species='pterocarpoides' OR junior_species='pterocarpoides')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='Amphimas' AND (species='pterocarpoides' OR species='pterocarpoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sterculia' AND (junior_species='oblonga' OR junior_species='oblonga')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sterculia' AND (species='oblonga' OR species='oblonga') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sterculia' AND (species='oblonga' OR species='oblonga')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sterculia' AND (junior_species='oblonga' OR junior_species='oblonga')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='oblonga' OR species='oblonga') 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='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=118 The Ecological Register: Kade site C
Kade site C
Basic information
Sample name: Kade site C

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: 59 individuals

Years: 1974-1975

Size min: 10

Basal area: 6.8053

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

Metadata
Sample number: 118

Contributor: John Alroy

Enterer: Albert Garcia Selles

Created: 2013-02-28 17:34:47

Modified: 2017-11-11 23:00:48

Abundance distribution
19 species
11 singletons
total count 59
extrapolated richness: 69.2
Fisher's α: 9.710
geometric series k: 0.8294
Hurlbert's PIE: 0.7350
Shannon's H: 2.0904
Good's u: 0.8153
Each square represents a species. Square sizes are proportional to counts.
Register