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=1956 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1956SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1753SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1956 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrohyrax' AND (junior_species='validus' OR junior_species='validus')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendrohyrax' AND (species='validus' OR species='validus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendrohyrax' AND (species='validus' OR species='validus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrohyrax' AND (junior_species='validus' OR junior_species='validus')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''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='Dendrohyrax' AND (species='validus' OR species='validus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Loxodonta' 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='Loxodonta' AND (species='africana' OR species='africana') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Loxodonta' 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='Loxodonta' AND (species='africana' OR species='africana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Petrodromus' AND (junior_species='tetradactylus' OR junior_species='tetradactylus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Petrodromus' AND (species='tetradactylus' OR species='tetradactylus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Petrodromus' AND (species='tetradactylus' OR species='tetradactylus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Petrodromus' AND (junior_species='tetradactylus' OR junior_species='tetradactylus')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='Petrodromus' AND (species='tetradactylus' OR species='tetradactylus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhynchocyon' AND (junior_species='udzungwensis' OR junior_species='udzungwensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhynchocyon' AND (species='udzungwensis' OR species='udzungwensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhynchocyon' AND (species='udzungwensis' OR species='udzungwensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhynchocyon' AND (junior_species='udzungwensis' OR junior_species='udzungwensis')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='Rhynchocyon' AND (species='udzungwensis' OR species='udzungwensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atilax' AND (junior_species='paludinosus' OR junior_species='paludinosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Atilax' AND (species='paludinosus' OR species='paludinosus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atilax' AND (junior_species='paludinosus' OR junior_species='paludinosus')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='Atilax' AND (species='paludinosus' OR species='paludinosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bdeogale' AND (junior_species='crassicauda' OR junior_species='crassicauda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bdeogale' AND (species='crassicauda' OR species='crassicauda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bdeogale' AND (species='crassicauda' OR species='crassicauda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bdeogale' AND (junior_species='crassicauda' OR junior_species='crassicauda')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='Bdeogale' AND (species='crassicauda' OR species='crassicauda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Genetta' AND (junior_species='servalina' OR junior_species='servalina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Genetta' AND (species='servalina' OR species='servalina') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Genetta' AND (junior_species='servalina' OR junior_species='servalina')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='Genetta' AND (species='servalina' OR species='servalina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mellivora' AND (junior_species='capensis' OR junior_species='capensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mellivora' AND (species='capensis' OR species='capensis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mellivora' AND (junior_species='capensis' OR junior_species='capensis')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='Mellivora' AND (species='capensis' OR species='capensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nandinia' AND (junior_species='binotata' OR junior_species='binotata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nandinia' AND (species='binotata' OR species='binotata') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nandinia' AND (junior_species='binotata' OR junior_species='binotata')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='Nandinia' AND (species='binotata' OR species='binotata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panthera' AND (junior_species='pardus' OR junior_species='pardus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Panthera' AND (species='pardus' OR species='pardus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panthera' AND (junior_species='pardus' OR junior_species='pardus')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='Panthera' AND (species='pardus' OR species='pardus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercocebus' AND (junior_species='sanjei' OR junior_species='sanjeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cercocebus' AND (species='sanjei' OR species='sanjeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cercocebus' AND (species='sanjei' OR species='sanjeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercocebus' AND (junior_species='sanjei' OR junior_species='sanjeii')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='Cercocebus' AND (species='sanjei' OR species='sanjeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercopithecus' AND (junior_species='mitis' OR junior_species='mitis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cercopithecus' AND (species='mitis' OR species='mitis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cercopithecus' AND (species='mitis' OR species='mitis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercopithecus' AND (junior_species='mitis' OR junior_species='mitis')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='Cercopithecus' AND (species='mitis' OR species='mitis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Piliocolobus' AND (junior_species='gordonorum' OR junior_species='gordonorum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Piliocolobus' AND (species='gordonorum' OR species='gordonorum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Piliocolobus' AND (species='gordonorum' OR species='gordonorum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Piliocolobus' AND (junior_species='gordonorum' OR junior_species='gordonorum')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='Piliocolobus' AND (species='gordonorum' OR species='gordonorum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cricetomys' AND (junior_species='gambianus' OR junior_species='gambianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cricetomys' AND (species='gambianus' OR species='gambianus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cricetomys' AND (junior_species='gambianus' OR junior_species='gambianus')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='Cricetomys' AND (species='gambianus' OR species='gambianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paraxerus' AND (junior_species='vexillarius' OR junior_species='vexillarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paraxerus' AND (species='vexillarius' OR species='vexillarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paraxerus' AND (species='vexillarius' OR species='vexillarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paraxerus' AND (junior_species='vexillarius' OR junior_species='vexillarius')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='Paraxerus' AND (species='vexillarius' OR species='vexillarius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thryonomys' AND (junior_species='swinderianus' OR junior_species='swinderianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thryonomys' AND (species='swinderianus' OR species='swinderianus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thryonomys' AND (junior_species='swinderianus' OR junior_species='swinderianus')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='Thryonomys' AND (species='swinderianus' OR species='swinderianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cephalophus' AND (junior_species='harveyi' OR junior_species='harveyii')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cephalophus' AND (species='harveyi' OR species='harveyii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cephalophus' AND (junior_species='harveyi' OR junior_species='harveyii')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''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='Cephalophus' AND (species='harveyi' OR species='harveyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cephalophus' AND (junior_species='spadix' OR junior_species='spadix')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cephalophus' AND (species='spadix' OR species='spadix') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cephalophus' AND (species='spadix' OR species='spadix')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cephalophus' AND (junior_species='spadix' OR junior_species='spadix')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='Cephalophus' AND (species='spadix' OR species='spadix') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nesotragus' AND (junior_species='moschatus' OR junior_species='moschatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nesotragus' AND (species='moschatus' OR species='moschatus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nesotragus' AND (junior_species='moschatus' OR junior_species='moschatus')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='Nesotragus' AND (species='moschatus' OR species='moschatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Potamochoerus' AND (junior_species='larvatus' OR junior_species='larvatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Potamochoerus' AND (species='larvatus' OR species='larvatus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Potamochoerus' AND (junior_species='larvatus' OR junior_species='larvatus')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='Potamochoerus' AND (species='larvatus' OR species='larvatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syncerus' AND (junior_species='caffer' OR junior_species='caffer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syncerus' AND (species='caffer' OR species='caffer') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syncerus' AND (junior_species='caffer' OR junior_species='caffer')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='Syncerus' AND (species='caffer' OR species='caffer') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tragelaphus' AND (junior_species='scriptus' OR junior_species='scriptus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tragelaphus' AND (species='scriptus' OR species='scriptus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tragelaphus' AND (junior_species='scriptus' OR junior_species='scriptus')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='Tragelaphus' AND (species='scriptus' OR species='scriptus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1956 The Ecological Register: Mwanihana Forest (2013)
Mwanihana Forest (2013)
Basic information
Sample name: Mwanihana Forest (2013)

Reference: C. Hegerl, N. D. Burgess, M. R. Nielsen, E. Martin, M. Ciolli, and F. Rovero. 2015. Using camera trap data to assess the impact of bushmeat hunting on forest mammals in Tanzania. Oryx -:1-11 [ER 1753]
Geography
Country: Tanzania


Coordinate: 7° 45' S, 36° 52' E
Coordinate basis: stated in text

Geography comments: coordinate based on sample 1945

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Substrate: ground surface

WMT: 31.0

CMT: 21.0

MAP: 1875.0

Habitat comments: "covered by continuous forests, from lowland deciduous to submontane and montane evergreen forests, on an elevational gradient of c. 300 to > 2000 m... hunting is rare here"
MAP 2000 to 2500 mm

Methods
Life forms: carnivores,primates,rodents,ungulates,other large mammals,other small mammals

Site area: 6000

Sampling methods: no design,automatic cameras

Sample size: 982 captures or sightings

Years: 2013

Nets or traps: 30

Net or trap nights: 917

Camera type: digital

Cameras paired: no

Sampling comments: "60 Reconyx RM45 camera traps... distributed over three sequential arrays of 20 cameras, were placed at a density of 1 camera per 2 km2 for a minimum of 30 days. Camera trapping was conducted during July–November 2013... . To improve comparability between data from the Reserve and Mwanihana Forest 30 of the 60 cameras were selected" for analysis

Metadata
Sample number: 1956

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-01-20 16:46:03

Modified: 2016-01-20 05:46:03

Abundance distribution
22 species
3 singletons
total count 982
extrapolated richness: 29.0
Fisher's α: 3.993
geometric series k: 0.7692
Hurlbert's PIE: 0.8495
Shannon's H: 2.2045
Good's u: 0.9969
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Dendrohyrax validus41
Loxodonta africana52731 kg browser-grazer
Petrodromus tetradactylus1
Rhynchocyon udzungwensis42
Atilax paludinosus42.8 kg invertivore-carnivore
Bdeogale crassicauda169 invertivore-carnivore
Genetta servalina lowei173.0 kg carnivore-invertivore
Mellivora capensis87.7 kg carnivore-invertivore
Nandinia binotata72.7 kg frugivore-invertivore
Panthera pardus333 kg carnivore
Cercocebus sanjei81 frugivore
Cercopithecus mitis5 frugivore-folivore
Piliocolobus gordonorum2
"Procolobus gordonorum"
Cricetomys gambianus2471.4 kg frugivore-granivore
Paraxerus vexillarius27
Thryonomys swinderianus15.2 kg
Cephalophus harveyi18812 kg
Cephalophus spadix32
Nesotragus moschatus883.7 kg browser
"Neotragus moschatus"
Potamochoerus larvatus838 kg grazer-browser
Syncerus caffer5548 kg grazer-browser
Tragelaphus scriptus131 kg browser-grazer