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=3681 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3681SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3302SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3681 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Martes' AND (junior_species='americana' OR junior_species='americana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Martes' AND (species='americana' OR species='americana') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Martes' AND (junior_species='americana' OR junior_species='americana')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='Martes' AND (species='americana' OR species='americana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ursus' AND (junior_species='americanus' OR junior_species='americanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ursus' AND (species='americanus' OR species='americanus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ursus' AND (junior_species='americanus' OR junior_species='americanus')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='americanus' OR species='americanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lynx' AND (junior_species='canadensis' OR junior_species='canadensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lynx' AND (species='canadensis' OR species='canadensis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lynx' AND (junior_species='canadensis' OR junior_species='canadensis')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='Lynx' AND (species='canadensis' OR species='canadensis') 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='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='Pekania' AND (junior_species='pennanti' OR junior_species='pennantii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pekania' AND (species='pennanti' OR species='pennantii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pekania' AND (junior_species='pennanti' OR junior_species='pennantii')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='Pekania' AND (species='pennanti' OR species='pennantii') 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='Alces' AND (junior_species='alces' OR junior_species='alces')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alces' AND (species='alces' OR species='alces') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alces' AND (junior_species='alces' OR junior_species='alces')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='Alces' AND (species='alces' OR species='alces') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tamiasciurus' AND (junior_species='hudsonicus' OR junior_species='hudsonicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tamiasciurus' AND (species='hudsonicus' OR species='hudsonicus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tamiasciurus' AND (junior_species='hudsonicus' OR junior_species='hudsonicus')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='Tamiasciurus' AND (species='hudsonicus' OR species='hudsonicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' AND (junior_species='americanus' OR junior_species='americanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepus' AND (species='americanus' OR species='americanus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' AND (junior_species='americanus' OR junior_species='americanus')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='Lepus' AND (species='americanus' OR species='americanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rangifer' AND (junior_species='tarandus' OR junior_species='tarandus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rangifer' AND (species='tarandus' OR species='tarandus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rangifer' AND (junior_species='tarandus' OR junior_species='tarandus')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='Rangifer' AND (species='tarandus' OR species='tarandus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3681 The Ecological Register: EMEND site (retention level 100%, replicate 3)
EMEND site (retention level 100%, replicate 3)
Basic information
Sample name: EMEND site (retention level 100%, replicate 3)

Sample aka: Ecosystem Management Emulating Natural Disturbance

Reference: C. M. A. Franklin, S. E. Macdonald, and S. E. Nielsen. 2019. Can retention harvests help conserve wildlife? Evidence for vertebrates in the boreal forest. Ecosphere 10(3):1-21 [ER 3302]
Geography
Country: Canada

State: Alberta


Coordinate: 56° 46' 13" N, 118° 22' 28" W
Coordinate basis: stated in text

Geography comments: "in northwest Alberta"

Environment
Habitat: boreal forest/taiga

Protection: unprotected

Substrate: ground surface

WMT: 15.0

CMT: -16.9

Habitat comments: "Climate data from nearby Eureka River (56°29′00″ N, −118°44′00″ W) collected from 1981 to 2010 indicated mean temperatures of −16.9°C and 15.0°C for January and July, respectively (Environment Canada 2017). Mean annual snowfall and rainfall were 128.8 cm and 307.4 mm, respectively... The area is representative of the boreal mixedwood plains... The EMEND site, which is embedded in an area managed for forestry, includes 1000 ha of forest... The stands were ~120–180 yr old at the time of sampling as they experienced fires in 1895, 1877, and/or 1837"
the EMEND site is apparently embedded within a larger forest mosaic, so it is not a fragment per se
100% retention means that there was no logging

Methods
Life forms: carnivores,rodents,ungulates,other small mammals

Sampling methods: no design,baited,automatic cameras

Sample size: 149 captures or sightings

Years: 2014 - 2017

Seasons: winter,spring,autumn

Nets or traps: 2

Net or trap nights: 1557

Camera type: digital

Cameras paired: unclear

Trap spacing: 1.6

Sampling comments: "a minimum distance of 1.6‐km separated compartments characterized by the same treatment... We used 35 motion‐triggered wildlife cameras (25 Reconyx Hyperfire HC500 and 10 Reconyx Hyperfire PC900, Holmen, Wisconsin, USA) to capture use of compartments (treatments) by wildlife species from 31 October 2014 to 30 May 2017. During the sampling time period, 1–2 cameras were randomly moved within each compartment at least once every year so that each compartment had a total of 4–6 different camera locations... In the zone of detection, which was approximately 3–5 m from the camera lens, we applied 10 mL of a scented lure... The average number of camera trap nights for each compartment was 1319 ± 49" but exact figures are given
there were 35 cameras and 18 sites, so the average is just about 2
cameras were deployed on 6 November 2014 and retrieved on 28 May 2017 and rotated between five exact sites, with interruptions

Metadata
Sample number: 3681

Contributor: John Alroy

Enterer: John Alroy

Created: 2020-10-20 19:33:51

Modified: 2020-10-20 08:33:51

Abundance distribution
11 species
2 singletons
total count 149
extrapolated richness: 15.4
Fisher's α: 2.740
geometric series k: 0.6598
Hurlbert's PIE: 0.7578
Shannon's H: 1.8013
Good's u: 0.9866
Each square represents a species. Square sizes are proportional to counts.
Register