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=1984 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1984SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1779SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1984 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capreolus' 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='Capreolus' AND (species='capreolus' OR species='capreolus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capreolus' 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='Capreolus' AND (species='capreolus' OR species='capreolus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vulpes' AND (junior_species='vulpes' OR junior_species='vulpes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vulpes' AND (species='vulpes' OR species='vulpes') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vulpes' AND (junior_species='vulpes' OR junior_species='vulpes')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='Vulpes' AND (species='vulpes' OR species='vulpes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Homo' AND (junior_species='sapiens' OR junior_species='sapiens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Homo' AND (species='sapiens' OR species='sapiens') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Homo' AND (junior_species='sapiens' OR junior_species='sapiens')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='Homo' AND (species='sapiens' OR species='sapiens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='lupus' OR junior_species='lupus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canis' AND (species='lupus' OR species='lupus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='lupus' OR junior_species='lupus')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='Canis' AND (species='lupus' OR species='lupus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervus' AND (junior_species='elaphus' OR junior_species='elaphus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cervus' AND (species='elaphus' OR species='elaphus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervus' AND (junior_species='elaphus' OR junior_species='elaphus')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='Cervus' AND (species='elaphus' OR species='elaphus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ursus' AND (junior_species='arctos' OR junior_species='arctos')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ursus' AND (species='arctos' OR species='arctos') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ursus' AND (junior_species='arctos' OR junior_species='arctos')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='Ursus' AND (species='arctos' OR species='arctos') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='lupus' OR junior_species='lupus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canis' AND (species='lupus' OR species='lupus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='lupus' OR junior_species='lupus')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='Canis' AND (species='lupus' OR species='lupus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1984
Reference:I. Dorresteijn, J. Schultner, D. G. Nimmo, J. Fischer, J. Hanspach, T. Kuemmerle, L. Kehoe, and E. G. Ritchie. 2015. Incorporating anthropogenic effects into trophic ecology: predator-prey interactions in a human-dominated landscape. Proceedings of the Royal Society B282(20151602):1-8 [ER 1779]
Geography
Country: Romania
Coordinate:45° 48' N, 24° 9' E
Coordinate basis: based on nearby landmark
Geography comments: "4900 km2 in the foothills of the Carpathian Mountains in southern Transylvania" (map indicates that the region is roughly within the counties of Sibiu and Brasov and centered perhaps to the east of the city of Sibiu, basis of coordinate)
•
Environment
Habitat: temperate broadleaf/mixed forest
Substrate: ground surface
MAT: 8.8
MAP: 642.0
Habitat comments: "The region contains 28% forest, 24% pasture and 37% arable land. The remaining land cover includes villages, water bodies and permanent crops. Forests are dominated by hornbeam (Carpinus betulus), oak (Quercus sp.) and beech (Fagus sylvatica)... We surveyed wild mammal, human and dog presence in forests"
climate data are for Sibiu and are from Ionita et al. (2013, Theor Appl Climatol)
Methods
Life forms: carnivores,primates,ungulates
Site area: 300000
Sampling methods: no design,baited,automatic cameras
Sample size: 3152 captures or sightings
Years: 2013
Net or trap nights: 3042
Camera type: digital
Cameras paired: no
Trap spacing: 1.5
Sampling comments: "We surveyed... using remote, heat and motion, passive infrared Bushnell Trophy Cam HD Max cameras between May and August 2013... we divided the study area into grid cells of 5 x 5 km... n = 120" and "placed one camera in the middle of each grid or in the nearest forest patch if no forest was present... Cameras were rotated in four rounds... cameras were spaced more than 1.5 km apart... We used 179 camera locations in total... However, only 138 locations were used for modelling... we placed cameras alongside animal and human paths, and used a lure of honey and wolf urine to attract bears and wolves, respectively. Lures were deployed at 75% of the locations (selected randomly)" (exact number of cameras is unclear; effective surveyed area was 5 x 5 x 120 = 3000 km2)
Metadata
Sample number: 1984
Contributor: John Alroy
Enterer: John Alroy
Created: 2016-01-30 15:05:58
Modified: 2016-12-16 09:41:10
Abundance distribution
7 species
0 singletons
total count 3152
extrapolated richness: 7.6
Fisher's α: 0.852
geometric series k: 0.3113
Hurlbert's PIE: 0.4883
Shannon's H: 1.0459
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.