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=1223 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1223SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=858SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1223 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aethomys' AND (junior_species='chrysophilus' OR junior_species='chrysophilus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aethomys' AND (species='chrysophilus' OR species='chrysophilus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aethomys' AND (species='chrysophilus' OR species='chrysophilus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aethomys' AND (junior_species='chrysophilus' OR junior_species='chrysophilus')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='Aethomys' AND (species='chrysophilus' OR species='chrysophilus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aethomys' AND (junior_species='namaquensis' OR junior_species='namaquensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aethomys' AND (species='namaquensis' OR species='namaquensis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aethomys' AND (junior_species='namaquensis' OR junior_species='namaquensis')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='Aethomys' AND (species='namaquensis' OR species='namaquensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocidura' AND (junior_species='hirta' OR junior_species='hirta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crocidura' AND (species='hirta' OR species='hirta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crocidura' AND (species='hirta' OR species='hirta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocidura' AND (junior_species='hirta' OR junior_species='hirta')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='Crocidura' AND (species='hirta' OR species='hirta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendromys' AND (junior_species='melanotis' OR junior_species='melanotis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendromys' AND (species='melanotis' OR species='melanotis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendromys' AND (species='melanotis' OR species='melanotis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendromys' AND (junior_species='melanotis' OR junior_species='melanotis')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='Dendromys' AND (species='melanotis' OR species='melanotis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elephantulus' AND (junior_species='brachyrhynchus' OR junior_species='brachyrhynchus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elephantulus' AND (species='brachyrhynchus' OR species='brachyrhynchus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elephantulus' AND (species='brachyrhynchus' OR species='brachyrhynchus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elephantulus' AND (junior_species='brachyrhynchus' OR junior_species='brachyrhynchus')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='Elephantulus' AND (species='brachyrhynchus' OR species='brachyrhynchus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphiurus' AND (junior_species='murinus' OR junior_species='murinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Graphiurus' AND (species='murinus' OR species='murinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Graphiurus' AND (species='murinus' OR species='murinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphiurus' AND (junior_species='murinus' OR junior_species='murinus')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='Graphiurus' AND (species='murinus' OR species='murinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lemniscomys' AND (junior_species='rosalia' OR junior_species='rosalia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lemniscomys' AND (species='rosalia' OR species='rosalia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lemniscomys' AND (species='rosalia' OR species='rosalia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lemniscomys' AND (junior_species='rosalia' OR junior_species='rosalia')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='Lemniscomys' AND (species='rosalia' OR species='rosalia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mastomys' 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='Mastomys' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mastomys' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mastomys' 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='Mastomys' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Otomys' AND (junior_species='angoniensis' OR junior_species='angoniensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Otomys' AND (species='angoniensis' OR species='angoniensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Otomys' AND (species='angoniensis' OR species='angoniensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Otomys' AND (junior_species='angoniensis' OR junior_species='angoniensis')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='Otomys' AND (species='angoniensis' OR species='angoniensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saccostomus' AND (junior_species='campestris' OR junior_species='campestris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Saccostomus' AND (species='campestris' OR species='campestris') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saccostomus' AND (junior_species='campestris' OR junior_species='campestris')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='Saccostomus' AND (species='campestris' OR species='campestris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Steatomys' AND (junior_species='pratensis' OR junior_species='pratensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Steatomys' AND (species='pratensis' OR species='pratensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Steatomys' AND (species='pratensis' OR species='pratensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Steatomys' AND (junior_species='pratensis' OR junior_species='pratensis')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='Steatomys' AND (species='pratensis' OR species='pratensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gerbilliscus' AND (junior_species='leucogaster' OR junior_species='leucogaster')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gerbilliscus' AND (species='leucogaster' OR species='leucogaster') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gerbilliscus' AND (species='leucogaster' OR species='leucogaster')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gerbilliscus' AND (junior_species='leucogaster' OR junior_species='leucogaster')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='Gerbilliscus' AND (species='leucogaster' OR species='leucogaster') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1223 The Ecological Register: Mokolodi Nature Reserve
Mokolodi Nature Reserve
Basic information
Sample name: Mokolodi Nature Reserve

Reference: E. R. Saetnan and C. Skarpe. 2006. The effect of ungulate grazing on a small mammal community in southeastern Botswana. African Zoology 41(1):9-16 [ER 858]
Geography
Country: Botswana


Coordinate: 24° 45' S, 25° 55' E
Coordinate basis: stated in text

Geography comments: "15 km southwest of the capital Gaborone"
altitude 1020 to 1306 m

Environment
Habitat: tropical/subtropical savanna

Altered habitat: secondary forest

Protection: nature reserve

Substrate: ground surface

MAT: 22.0

MAP: 538.0

Habitat comments: "mixed shrub and tree savanna... dominated by Acacia tortilis"; the area was a cattle ranch through 1986
MAP stated in text; MAT is for Gaborone and is from Titus et al. (2012)

Methods
Life forms: rodents,other small mammals

Sites: 6

Sampling methods: quadrat,baited,Sherman traps

Sample size: 252 individuals

Years: 1998

Days: 15

Nets or traps: 384

Net or trap nights: 5760

Sampling comments: "three pairs of 2.25 ha (150 × 150 m) exclosure and control plots, with 30 m between the exclosure and control plots in each pair, and 1–2 km between each pair... Small mammals were trapped in an 80 × 80 m square in the northwestern corner of every control and exclosure plot" using one medium and one large peanut butter, rolled oats, dried fruit and bacon fat-baited Sherman trap at each station; there were 64 stations per plot

Metadata
Sample number: 1223

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-02-16 11:44:36

Modified: 2015-10-04 10:29:25

Abundance distribution
12 species
4 singletons
total count 252
extrapolated richness: 20.9
Fisher's α: 2.623
geometric series k: 0.6539
Hurlbert's PIE: 0.7255
Shannon's H: 1.6088
Good's u: 0.9842
Each square represents a species. Square sizes are proportional to counts.
Register