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 The Ecological Register: Roussillon, Québec
Roussillon, Québec
Basic information
Sample name: Roussillon, Québec

Reference: C. Pelletier-Guittier, J. Théau, and J. Dupras. 2020. Use of hedgerows by mammals in an intensive agricultural landscape. Agriculture, Ecosystems and Environment 302: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.
Register
Odocoileus virginianus22575 kg herbivore
Procyon lotor855.5 kg carnivore-granivore
Canis latrans6412 kg carnivore-insectivore
Vulpes vulpes315.3 kg carnivore-insectivore
Mephitis mephitis91.5 kg carnivore-insectivore
Sciurus carolinensis4519 g frugivore
Sylvilagus floridanus21.1 kg herbivore