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=3283 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3283SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3036SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3283 ORDER BY register_no ASCSELECT 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='Cervus' AND (junior_species='canadensis' OR junior_species='canadensis')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='Cervus' AND (species='canadensis' OR species='canadensis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervus' AND (junior_species='canadensis' OR junior_species='canadensis')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='Cervus' AND (species='canadensis' OR species='canadensis') 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='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='Neogale' AND (junior_species='vison' OR junior_species='vison')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neogale' AND (species='vison' OR species='vison') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neogale' AND (junior_species='vison' OR junior_species='vison')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='Neogale' AND (species='vison' OR species='vison') 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='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='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='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=3283 The Ecological Register: Canadian National Railway (fall)
Canadian National Railway (fall)
Basic information
Sample name: Canadian National Railway (fall)

Sample aka: Greater Sudbury

Reference: J. N. Popp and J. Hamr. 2018. Seasonal use of railways by wildlife. Diversity 10(104):1-10 [ER 3036]
Geography
Country: Canada

State: Ontario


Coordinate: 46° 15' 30" N, 80° 50' 15" W
Coordinate basis: stated in text as range

Geography comments: "approximately 20 km of the transcontinental Canadian National Railway (CNR) located 20–40 km south of the City of Greater Sudbury... from 46º20'30", 80º50'30" to 46º11'30", 80º50'00"... The studied section of the railway ranged in elevation from 200 to 230 m above sea level"

•
Environment
Habitat: temperate broadleaf/mixed forest

Protection: unprotected

Substrate: ground surface

Habitat comments: the train line "traversed 5 major wetlands, Great Lakes-St. Lawrence conifer-hardwood mixed forest [26], and approximately 3 km of open grasslands"

Methods
Life forms: carnivores,ungulates,other small mammals

Sampling methods: line transect,automatic cameras

Sample size: 116 captures or sightings

Years: 2015

Days: 91

Seasons: autumn

Nets or traps: 10

Camera type: digital

Cameras paired: no

Trap spacing: 2

Sampling comments: "From the beginning of July 2015 to the end of June 2016, 10 trail cameras (brands: Bushnell, Stealth Cam, Tasco) were placed along the 20 km stretch of studied railway, one every 2 km, attached to rail-side trees and directly facing the railway... regardless of the number of animals in an image, one photo was considered a single capture event... all capture events recorded within one hour from the initial capture were omitted from the data set"
trap days are not reported, but the study lasted almost exactly one year and the data were divided into four seasons, so there were about 91 days of sampling per season
birds are listed but usable counts are not provided

Metadata
Sample number: 3283

Contributor: John Alroy

Enterer: John Alroy

Created: 2019-03-16 14:37:44

Modified: 2019-03-16 03:39:54

Abundance distribution
9 species
2 singletons
total count 116
extrapolated richness: 14.1
Fisher's α: 2.279
geometric series k: 0.5849
Hurlbert's PIE: 0.5744
Shannon's H: 1.3299
Good's u: 0.9829
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Ursus americanus5115 kg browser-insectivore
Cervus canadensis7329 kg browser-grazer
Lepus americanus51.4 kg browser
Martes americana1946 g
Neogale vison1950 g
"Neovison neovison"
Alces alces12421 kg herbivore
Procyon lotor25.5 kg carnivore-granivore
Vulpes vulpes105.3 kg carnivore-insectivore
Canis lupus7343 kg carnivore
"Canis lupus" and "Canis lycon" combined, including supposed hybrids