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=1821 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1821SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1594SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1821 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='cinereus' OR junior_species='cinereus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sorex' AND (species='cinereus' OR species='cinereus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='cinereus' OR junior_species='cinereus')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='Sorex' AND (species='cinereus' OR species='cinereus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Blarina' AND (junior_species='brevicauda' OR junior_species='brevicauda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Blarina' AND (species='brevicauda' OR species='brevicauda') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Blarina' AND (junior_species='brevicauda' OR junior_species='brevicauda')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='Blarina' AND (species='brevicauda' OR species='brevicauda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tamias' AND (junior_species='striatus' OR junior_species='striatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tamias' AND (species='striatus' OR species='striatus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tamias' AND (junior_species='striatus' OR junior_species='striatus')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='Tamias' AND (species='striatus' OR species='striatus') 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='Peromyscus' AND (junior_species='maniculatus' OR junior_species='maniculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Peromyscus' AND (species='maniculatus' OR species='maniculatus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peromyscus' AND (junior_species='maniculatus' OR junior_species='maniculatus')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='Peromyscus' AND (species='maniculatus' OR species='maniculatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myodes' AND (junior_species='gapperi' OR junior_species='gapperii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myodes' AND (species='gapperi' OR species='gapperii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myodes' AND (junior_species='gapperi' OR junior_species='gapperii')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='Myodes' AND (species='gapperi' OR species='gapperii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Napaeozapus' AND (junior_species='insignis' OR junior_species='insignis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Napaeozapus' AND (species='insignis' OR species='insignis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Napaeozapus' AND (junior_species='insignis' OR junior_species='insignis')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='Napaeozapus' AND (species='insignis' OR species='insignis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1821
Reference:J. A. McDonnell, D. L. Euler, and T. P. Clark. 1984. A test of predicted impacts of cottage development on small mammals. Wildlife Society Bulletin12(2):156-161 [ER 1594]
Geography
Country: Canada
State: Ontario
Coordinate:44° 47' N, 78° 39' W
Coordinate basis: based on nearby landmark
Geography comments: "in the District Municipalities of Muskoka and Haliburton, central Ontario... within a 20-km radius of Kinmount" (coordinate based on Kinmount)
•
Environment
Habitat: temperate broadleaf/mixed forest
Substrate: ground surface
MAT: 5.0
WMT: 18.4
CMT: -11.0
MAP: 1000.0
Habitat comments: "the Georgian Bay section of the Great Lakes Forest Region" (dominated by sugar maple according to Carleton 2003)
climate data are for the District of Muskoka or the County of Haliburton and are from Eimers and Dillon (2002, Biogeochemistry): MAP 786 to 1213 mm
Methods
Life forms: rodents,other small mammals
Sampling methods: line transect,baited,Sherman traps
Sample size: 3152 individuals
Years: 1981
Days: 9
Seasons: summer
Nets or traps: 837
Net or trap nights: 7533
Sampling comments: "A total of 93 segments was selected... Within each segment, 9 Sherman live traps (9 x 8 x 23 cm) were placed so that 1 set of 3 traps was placed evenly along each of 3 parallel transects located 1, 25, and 37 m from the shore" of a given lake; "Trapping was conducted in July and August of 1981. Three trapping periods of 3 nights each provided 81 trap nights/segment. Traps were baited with a mixture of rolled oats, peanut butter, and skim milk powder"
Metadata
Sample number: 1821
Contributor: John Alroy
Enterer: John Alroy
Created: 2015-12-12 10:53:34
Modified: 2015-12-11 23:53:34
Abundance distribution
7 species
0 singletons
total count 3152
extrapolated richness: 7.6
Fisher's α: 0.852
geometric series k: 0.3232
Hurlbert's PIE: 0.5782
Shannon's H: 1.0872
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.