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=1955 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1955SELECT 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=1955 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='Rhynchocyon' AND (junior_species='cirnei' OR junior_species='cirneii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhynchocyon' AND (species='cirnei' OR species='cirneii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhynchocyon' AND (species='cirnei' OR species='cirneii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhynchocyon' AND (junior_species='cirnei' OR junior_species='cirneii')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='cirnei' OR species='cirneii') 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='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='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='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='Philantomba' AND (junior_species='monticola' OR junior_species='monticola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philantomba' AND (species='monticola' OR species='monticola') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philantomba' AND (junior_species='monticola' OR junior_species='monticola')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='Philantomba' AND (species='monticola' OR species='monticola') 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 * FROM register WHERE sample_no=1955
The Ecological Register: Uzungwa Scarp Forest Reserve (2013 - 2014)
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:8° 22' S, 35° 59' E
Coordinate basis: stated in text
Geography comments: coordinate based on Sorensen 2004
elevation of traps 372 to 1848 m (see below)
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... illegal bushmeat hunting is the main threat to biodiversity in the Reserve"
MAP 1800 to 2000 m
MAP 2000 to 2500 mm
Methods
Life forms: carnivores,primates,rodents,ungulates,other large mammals,other small mammals
Site area: 1500
Sampling methods: no design,automatic cameras
Sample size: 714 captures or sightings
Years: 2013, 2014
Nets or traps: 15
Net or trap nights: 850
Camera type: digital
Cameras paired: no
Sampling comments: "two grids of 15 digital camera traps (UOVision IR+, UOVision Technology, Shenzhen, China) were set sequentially at a density of 1 camera per km2. The first grid was located in the northern, remote part of the Reserve (Fig. 1), at 1,653-1,848 m, and was active during 15 December 2013–14 January 2014. The second grid was located in the southern part of the Reserve and was active during 20 January–25 February 2014, at 372–1,564 m"
Metadata
Sample number: 1955
Contributor: John Alroy
Enterer: John Alroy
Created: 2016-01-20 16:36:55
Modified: 2016-01-20 05:47:06
Abundance distribution
15 species
1 singleton
total count 714
extrapolated richness: 17.7
Fisher's α: 2.685
geometric series k: 0.6537
Hurlbert's PIE: 0.6816
Shannon's H: 1.7180
Good's u: 0.9986
Each square represents a species. Square sizes are proportional to counts.