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=1379 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1379SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=918SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1379 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micaelamys' 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='Micaelamys' AND (species='namaquensis' OR species='namaquensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Micaelamys' AND (species='namaquensis' OR species='namaquensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micaelamys' 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='Micaelamys' AND (species='namaquensis' OR species='namaquensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elephantulus' AND (junior_species='myurus' OR junior_species='myurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elephantulus' AND (species='myurus' OR species='myurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elephantulus' AND (species='myurus' OR species='myurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elephantulus' AND (junior_species='myurus' OR junior_species='myurus')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='myurus' OR species='myurus') 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 senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocidura' AND (junior_species='spp.' OR junior_species='spp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crocidura' AND (species='spp.' OR species='spp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crocidura' AND (species='spp.' OR species='spp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocidura' AND (junior_species='spp.' OR junior_species='spp.')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='spp.' OR species='spp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acomys' AND (junior_species='spinosissimus' OR junior_species='spinosissimus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acomys' AND (species='spinosissimus' OR species='spinosissimus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acomys' AND (species='spinosissimus' OR species='spinosissimus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acomys' AND (junior_species='spinosissimus' OR junior_species='spinosissimus')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='Acomys' AND (species='spinosissimus' OR species='spinosissimus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendromys' AND (junior_species='spp.' OR junior_species='spp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendromys' AND (species='spp.' OR species='spp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendromys' AND (species='spp.' OR species='spp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendromys' AND (junior_species='spp.' OR junior_species='spp.')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='spp.' OR species='spp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhabdomys' AND (junior_species='dilectus' OR junior_species='dilectus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhabdomys' AND (species='dilectus' OR species='dilectus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhabdomys' AND (species='dilectus' OR species='dilectus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhabdomys' AND (junior_species='dilectus' OR junior_species='dilectus')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='Rhabdomys' AND (species='dilectus' OR species='dilectus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aethomys' AND (junior_species='ineptus' OR junior_species='ineptus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aethomys' AND (species='ineptus' OR species='ineptus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aethomys' AND (species='ineptus' OR species='ineptus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aethomys' AND (junior_species='ineptus' OR junior_species='ineptus')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='ineptus' OR species='ineptus') 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='Graphiurus' AND (junior_species='spp.' OR junior_species='spp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Graphiurus' AND (species='spp.' OR species='spp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Graphiurus' AND (species='spp.' OR species='spp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphiurus' AND (junior_species='spp.' OR junior_species='spp.')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='spp.' OR species='spp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mus' AND (junior_species='minutoides' OR junior_species='minutoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mus' AND (species='minutoides' OR species='minutoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mus' AND (species='minutoides' OR species='minutoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mus' AND (junior_species='minutoides' OR junior_species='minutoides')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='Mus' AND (species='minutoides' OR species='minutoides') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1379 The Ecological Register: Telperion/Ezemvelo Nature Reserve
Telperion/Ezemvelo Nature Reserve
Basic information
Sample name: Telperion/Ezemvelo Nature Reserve

Reference: D. M. Fagir, E. A. Ueckermann, I. G. Horak, N. C. Bennett, and H. Lutermann. 2014. The Namaqua rock mouse (Micaelamys namaquensis) as a potential reservoir and host of arthropod vectors of diseases of medical and veterinary importance in South Africa. Parasites & Vectors 7(366):1-11 [ER 918]
Geography
Country: South Africa

State: Northern Cape


Coordinate: 25° 41' S, 28° 56' E
Coordinate basis: stated in text

Environment
Habitat: tropical/subtropical savanna

Protection: nature reserve

Substrate: ground surface

Methods
Life forms: rodents,other small mammals

Sites: 16

Sampling methods: no design,baited,Sherman traps

Sample size: 460 individuals

Years: 2010, 2011

Sampling comments: "72 live-Sherman traps" baited with "a mixture of peanut butter and oates" were used in each of 16 plots, "8 rocky outcrops and 8 grasslands" (sampling effort unclear)

Metadata
Sample number: 1379

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-02-25 10:10:37

Modified: 2015-02-24 23:12:08

Abundance distribution
11 species
1 singleton
total count 460
extrapolated richness: 13.9
Fisher's α: 2.026
geometric series k: 0.5629
Hurlbert's PIE: 0.5019
Shannon's H: 1.1367
Good's u: 0.9978
Each square represents a species. Square sizes are proportional to counts.
Register