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=3792 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3792SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3408SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3792 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odocoileus' AND (junior_species='virginianus' OR junior_species='virginianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Odocoileus' AND (species='virginianus' OR species='virginianus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odocoileus' AND (junior_species='virginianus' OR junior_species='virginianus')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='Odocoileus' AND (species='virginianus' OR species='virginianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Procyon' AND (junior_species='lotor' OR junior_species='lotor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Procyon' AND (species='lotor' OR species='lotor') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Procyon' AND (junior_species='lotor' OR junior_species='lotor')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='Procyon' AND (species='lotor' OR species='lotor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='latrans' OR junior_species='latrans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canis' AND (species='latrans' OR species='latrans') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='latrans' OR junior_species='latrans')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='latrans' OR species='latrans') 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='Mephitis' AND (junior_species='mephitis' OR junior_species='mephitis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mephitis' AND (species='mephitis' OR species='mephitis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mephitis' AND (junior_species='mephitis' OR junior_species='mephitis')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='Mephitis' AND (species='mephitis' OR species='mephitis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sciurus' AND (junior_species='carolinensis' OR junior_species='carolinensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sciurus' AND (species='carolinensis' OR species='carolinensis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sciurus' AND (junior_species='carolinensis' OR junior_species='carolinensis')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='Sciurus' AND (species='carolinensis' OR species='carolinensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvilagus' AND (junior_species='floridanus' OR junior_species='floridanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sylvilagus' AND (species='floridanus' OR species='floridanus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvilagus' AND (junior_species='floridanus' OR junior_species='floridanus')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='Sylvilagus' AND (species='floridanus' OR species='floridanus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3792
Reference:C. Pelletier-Guittier, J. Théau, and J. Dupras. 2020. Use of hedgerows by mammals in an intensive agricultural landscape. Agriculture, Ecosystems and Environment302:107079 [ER 3408]
Geography
Country: Canada
State: Québec
Coordinate:45° 20' N, 73° 26' W
Coordinate basis: estimated from map
Geography comments: "We conducted our research on private properties in the regional county municipality (RCM) of Roussillon, in southern Québec, Canada"
•
Environment
Habitat: temperate broadleaf/mixed forest
Altered habitat: cropland
Protection: unprotected
Substrate: ground surface
Disturbance: agriculture
Habitat comments: "The region was selected for its intensive agriculture landscape and the low number of woodlots"
"Agriculture covers 73 % of the RCM, and the average area occupied by each farm has grown steadily in the past decade as a result of agricultural intensification"
"The crops adjacent to the hedgerows were mostly grains and cereals, but some were vegetables"
Methods
Life forms: carnivores,rodents,ungulates,other small mammals
Sampling methods: no design,automatic cameras
Sample size: 420 captures or sightings
Years: 2018
Seasons: spring,summer,autumn
Nets or traps: 23
Net or trap nights: 1572
Camera type: digital
Cameras paired: no
Sampling comments: "Twenty-three hedgerows were selected on the RCM territory based on the following criteria: (1) presence of agricultural fields on each side; (2) width > 3 m; (3) length > 300 m; and (4) relatively homogenous vegetation"
"Sampled hedgerows averaged 7 m and 662 m in width and length, respectively"
"Hedgerow use by medium- to large-sized mammals was surveyed using SpyPoint Force 10 infrared-triggered camera traps (GG Telecom, Québec, Canada)"
One camera was placed at mid-length of each hedgerow and was attached to an iron post or secured to vegetation so that the infrared beam was set at a height of 0.65 m"
"Cameras were installed with a 30° angle so they could capture the animals passing through that side of the hedgerow"
"Hedgerow sampling was conducted over 18 weeks in 2018, from late spring to early fall (May to September)"
"To segregate independent detections of the same species, individuals detected within a period of 30 min were counted as one"
Metadata
Sample number: 3792
Contributor: Benjamin Carter
Enterer: Benjamin Carter
Created: 2021-06-10 15:19:04
Modified: 2021-06-13 23:47:45
Abundance distribution
7 species
0 singletons
total count 420
extrapolated richness: 8.1
Fisher's α: 1.193
geometric series k: 0.4551
Hurlbert's PIE: 0.6420
Shannon's H: 1.2889
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.