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=1947 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1947SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1747SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1947 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Proteles' AND (junior_species='cristatus' OR junior_species='cristatus')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='Proteles' AND (species='cristatus' OR species='cristatus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Proteles' AND (junior_species='cristatus' OR junior_species='cristatus')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='Proteles' AND (species='cristatus' OR species='cristatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Felis' AND (junior_species='lybica' OR junior_species='lybica')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='Felis' AND (species='lybica' OR species='lybica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Felis' AND (species='lybica' OR species='lybica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Felis' AND (junior_species='lybica' OR junior_species='lybica')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='Felis' AND (species='lybica' OR species='lybica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papio' AND (junior_species='hamadryas' OR junior_species='hamadryas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papio' AND (species='hamadryas' OR species='hamadryas') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papio' AND (junior_species='hamadryas' OR junior_species='hamadryas')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='Papio' AND (species='hamadryas' OR species='hamadryas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hystrix' AND (junior_species='africaeaustralis' OR junior_species='africaeaustralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hystrix' AND (species='africaeaustralis' OR species='africaeaustralis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hystrix' AND (junior_species='africaeaustralis' OR junior_species='africaeaustralis')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='Hystrix' AND (species='africaeaustralis' OR species='africaeaustralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvicapra' AND (junior_species='grimmia' OR junior_species='grimmia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sylvicapra' AND (species='grimmia' OR species='grimmia') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvicapra' AND (junior_species='grimmia' OR junior_species='grimmia')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='Sylvicapra' AND (species='grimmia' OR species='grimmia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pelea' AND (junior_species='capreolus' OR junior_species='capreolus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pelea' AND (species='capreolus' OR species='capreolus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pelea' AND (junior_species='capreolus' OR junior_species='capreolus')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='Pelea' AND (species='capreolus' OR species='capreolus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Raphicerus' 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='Raphicerus' AND (species='melanotis' OR species='melanotis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Raphicerus' 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='Raphicerus' AND (species='melanotis' OR species='melanotis') 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='Oreotragus' AND (junior_species='oreotragus' OR junior_species='oreotragus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oreotragus' AND (species='oreotragus' OR species='oreotragus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oreotragus' AND (species='oreotragus' OR species='oreotragus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oreotragus' AND (junior_species='oreotragus' OR junior_species='oreotragus')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='Oreotragus' AND (species='oreotragus' OR species='oreotragus') 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 * FROM register WHERE sample_no=1947 The Ecological Register: Groenefontein Nature Reserve (fynbos)
Groenefontein Nature Reserve (fynbos)
Basic information
Sample name: Groenefontein Nature Reserve (fynbos)

Reference: G. K. H. Mann, M. J. O'Riain, and D. M. Parker. 2015. The road less travelled: assessing variation in mammal detection probabilities with camera traps in a semi-arid biodiversity hotspot. Biodiversity and Conservation 24(3):531-545 [ER 1747]
Geography
Country: South Africa


Coordinate: -33.646252° S, 21.650999° E
Coordinate basis: stated in text

Geography comments: "Our study site was Groenefontein Nature Reserve... and an adjoining, privately-owned property... Both properties form part of the Rooiberg Conservancy"

Environment
Habitat: desert/xeric shrubland

Protection: nature reserve

Substrate: ground surface

MAT: 17.7

MAP: 244.0

Habitat comments: "We sampled biodiversity with camera traps in three vegetation types: fynbos, subtropical thicket, and riverine vegetation"
climate data are for Oudtshoorn and are from Schmiedel and Jürgens (2004, Plant Ecology)

Methods
Life forms: carnivores,primates,rodents,ungulates

Sampling methods: line transect,automatic cameras

Sample size: 215 captures or sightings

Years: 2012

Nets or traps: 15

Net or trap nights: 1174

Camera type: digital

Cameras paired: no

Trap spacing: 0.025

Sampling comments: the reserve is 5200 ha and adjoining property 1100 ha; it is not clear whether the cameras cover the entire area
"three 100 m transects a minimum of 1 km apart... Camera traps were placed at 25 m intervals with the first camera on the road and the remaining four in a perpendicular straight line leading away from the edge of the road... Sampling was done with Cuddeback Capture cameras... All transects were run simultaneously for a period of approximately 90 days during the period from late August to early December 2012... Camera failure was low in fynbos vegetation (two cameras failed, 26 trap nights lost)"

Metadata
Sample number: 1947

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-01-20 09:59:32

Modified: 2016-12-15 06:19:09

Abundance distribution
10 species
2 singletons
total count 215
extrapolated richness: 14.4
Fisher's α: 2.171
geometric series k: 0.5833
Hurlbert's PIE: 0.6139
Shannon's H: 1.4232
Good's u: 0.9907
Each square represents a species. Square sizes are proportional to counts.
Register
Proteles cristatus19.1 kg insectivore
"Proteles cristata"
Felis lybica16
"Felis silvestris"
Papio hamadryas1112 kg
Hystrix africaeaustralis215 kg browser
Sylvicapra grimmia2513 kg browser-grazer
Pelea capreolus1116 kg grazer
Raphicerus melanotis1289.1 kg
Mellivora capensis17.7 kg carnivore-invertivore
Oreotragus oreotragus5 browser-grazer
Panthera pardus1533 kg carnivore