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=31 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=31SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=5SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=31 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alstonia' AND (junior_species='congensis' OR junior_species='congensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alstonia' AND (species='congensis' OR species='congensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alstonia' AND (species='congensis' OR species='congensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alstonia' AND (junior_species='congensis' OR junior_species='congensis')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='Alstonia' AND (species='congensis' OR species='congensis') 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='Lepisanthes' AND (junior_species='senegalensis' OR junior_species='senegalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepisanthes' AND (species='senegalensis' OR species='senegalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lepisanthes' AND (species='senegalensis' OR species='senegalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepisanthes' AND (junior_species='senegalensis' OR junior_species='senegalensis')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='Lepisanthes' AND (species='senegalensis' OR species='senegalensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Balsamocitrus' AND (junior_species='dawei' OR junior_species='daweii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Balsamocitrus' AND (species='dawei' OR species='daweii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Balsamocitrus' AND (species='dawei' OR species='daweii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Balsamocitrus' AND (junior_species='dawei' OR junior_species='daweii')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='Balsamocitrus' AND (species='dawei' OR species='daweii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capparis' AND (junior_species='afzelii' OR junior_species='afzeli')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Capparis' AND (species='afzelii' OR species='afzeli') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Capparis' AND (species='afzelii' OR species='afzeli')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capparis' AND (junior_species='afzelii' OR junior_species='afzeli')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='Capparis' AND (species='afzelii' OR species='afzeli') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celtis' AND (junior_species='brownii' OR junior_species='browni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Celtis' AND (species='brownii' OR species='browni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Celtis' AND (species='brownii' OR species='browni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celtis' AND (junior_species='brownii' OR junior_species='browni')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='brownii' OR species='browni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celtis' AND (junior_species='soyauxii' OR junior_species='soyauxi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Celtis' AND (species='soyauxii' OR species='soyauxi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Celtis' AND (species='soyauxii' OR species='soyauxi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celtis' AND (junior_species='soyauxii' OR junior_species='soyauxi')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='soyauxii' OR species='soyauxi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celtis' 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='Celtis' AND (species='zenkeri' OR species='zenkerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Celtis' AND (species='zenkeri' OR species='zenkerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celtis' 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='Celtis' AND (species='zenkeri' OR species='zenkerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysophyllum' AND (junior_species='albidum' OR junior_species='albidum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chrysophyllum' AND (species='albidum' OR species='albidum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chrysophyllum' AND (species='albidum' OR species='albidum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysophyllum' AND (junior_species='albidum' OR junior_species='albidum')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='Chrysophyllum' AND (species='albidum' OR species='albidum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysophyllum' AND (junior_species='n.' OR junior_species='n.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chrysophyllum' AND (species='n.' OR species='n.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chrysophyllum' AND (species='n.' OR species='n.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysophyllum' AND (junior_species='n.' OR junior_species='n.')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='Chrysophyllum' AND (species='n.' OR species='n.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cola' AND (junior_species='cordifolia' OR junior_species='cordifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cola' AND (species='cordifolia' OR species='cordifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cola' AND (species='cordifolia' OR species='cordifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cola' AND (junior_species='cordifolia' OR junior_species='cordifolia')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='Cola' AND (species='cordifolia' OR species='cordifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cynometra' AND (junior_species='alexandri' OR junior_species='alexandrii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cynometra' AND (species='alexandri' OR species='alexandrii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cynometra' AND (species='alexandri' OR species='alexandrii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cynometra' AND (junior_species='alexandri' OR junior_species='alexandrii')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='Cynometra' AND (species='alexandri' OR species='alexandrii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dialium' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dialium' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dialium' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dialium' AND (junior_species='sp.' OR junior_species='sp.')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='Dialium' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drypetes' AND (junior_species='ugandensis' OR junior_species='ugandensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Drypetes' AND (species='ugandensis' OR species='ugandensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Drypetes' AND (species='ugandensis' OR species='ugandensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drypetes' AND (junior_species='ugandensis' OR junior_species='ugandensis')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='Drypetes' AND (species='ugandensis' OR species='ugandensis') 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='Entandrophragma' AND (junior_species='utile' OR junior_species='utile')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Entandrophragma' AND (species='utile' OR species='utile') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Entandrophragma' AND (species='utile' OR species='utile')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Entandrophragma' AND (junior_species='utile' OR junior_species='utile')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='utile' OR species='utile') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='brachylepis' OR junior_species='brachylepis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ficus' AND (species='brachylepis' OR species='brachylepis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ficus' AND (species='brachylepis' OR species='brachylepis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='brachylepis' OR junior_species='brachylepis')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='Ficus' AND (species='brachylepis' OR species='brachylepis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lannea' AND (junior_species='welwitschii' OR junior_species='welwitschi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lannea' AND (species='welwitschii' OR species='welwitschi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lannea' AND (species='welwitschii' OR species='welwitschi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lannea' AND (junior_species='welwitschii' OR junior_species='welwitschi')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='Lannea' AND (species='welwitschii' OR species='welwitschi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepidoturus' AND (junior_species='laxiflorus' OR junior_species='laxiflorus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepidoturus' AND (species='laxiflorus' OR species='laxiflorus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lepidoturus' AND (species='laxiflorus' OR species='laxiflorus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepidoturus' AND (junior_species='laxiflorus' OR junior_species='laxiflorus')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='Lepidoturus' AND (species='laxiflorus' OR species='laxiflorus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mimusops' AND (junior_species='ugandensis' OR junior_species='ugandensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mimusops' AND (species='ugandensis' OR species='ugandensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mimusops' AND (species='ugandensis' OR species='ugandensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mimusops' AND (junior_species='ugandensis' OR junior_species='ugandensis')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='Mimusops' AND (species='ugandensis' OR species='ugandensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rinorea' AND (junior_species='ardisiaeflora' OR junior_species='ardisiaeflora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rinorea' AND (species='ardisiaeflora' OR species='ardisiaeflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rinorea' AND (species='ardisiaeflora' OR species='ardisiaeflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rinorea' AND (junior_species='ardisiaeflora' OR junior_species='ardisiaeflora')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='Rinorea' AND (species='ardisiaeflora' OR species='ardisiaeflora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strychnos' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Strychnos' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Strychnos' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strychnos' AND (junior_species='sp.' OR junior_species='sp.')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='Strychnos' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tapura' AND (junior_species='fischeri' OR junior_species='fischerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tapura' AND (species='fischeri' OR species='fischerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tapura' AND (species='fischeri' OR species='fischerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tapura' AND (junior_species='fischeri' OR junior_species='fischerii')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='Tapura' AND (species='fischeri' OR species='fischerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turraea' AND (junior_species='floribunda' OR junior_species='floribunda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turraea' AND (species='floribunda' OR species='floribunda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turraea' AND (species='floribunda' OR species='floribunda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turraea' AND (junior_species='floribunda' OR junior_species='floribunda')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='Turraea' AND (species='floribunda' OR species='floribunda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uvariopsis' AND (junior_species='n.' OR junior_species='n.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Uvariopsis' AND (species='n.' OR species='n.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Uvariopsis' AND (species='n.' OR species='n.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uvariopsis' AND (junior_species='n.' OR junior_species='n.')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='Uvariopsis' AND (species='n.' OR species='n.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=31
Habitat comments: JA: MAP range is estimated as 1780 to 1900 mm; MAT, CMT, and WMT are based on the "mean temperature of the air" figures for Masindi (which is close to the forest) that are given on p. 30
Methods
Life forms: trees
Sites: 1
Site length: 122
Site width: 30.5
Sampling methods: quadrat
Sample size: 349 individuals
Size min: 10
Sampling comments: see p. 85
The sample plots, 122 m. (400 ft.) square (= 1-418 ha. = 3 673 acres), were marked out by chain and compass. Each was divided into four strips 122 x 30 5 m. (400 x 100 ft.), and all trees over 10 cm. (4 in.) d.b.h. were measured
Metadata
Sample number: 31
Contributor: John Alroy
Enterer: John Alroy
Modifier no: John Alroy
Created: 2013-01-25 14:11:19
Modified: 2017-11-11 09:38:48
Abundance distribution
25 species
13 singletons
total count 349
extrapolated richness: 63.1
Fisher's α: 6.168
geometric series k: 0.8206
Hurlbert's PIE: 0.8138
Shannon's H: 2.0720
Good's u: 0.9628
Each square represents a species. Square sizes are proportional to counts.