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=1449 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1449SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=962SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1449 ORDER BY register_no ASCSELECT 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='Microtus' AND (junior_species='pennsylvanicus' OR junior_species='pennsylvanicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microtus' AND (species='pennsylvanicus' OR species='pennsylvanicus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' AND (junior_species='pennsylvanicus' OR junior_species='pennsylvanicus')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='Microtus' AND (species='pennsylvanicus' OR species='pennsylvanicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zapus' AND (junior_species='hudsonius' OR junior_species='hudsonius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zapus' AND (species='hudsonius' OR species='hudsonius') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zapus' AND (junior_species='hudsonius' OR junior_species='hudsonius')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='Zapus' AND (species='hudsonius' OR species='hudsonius') 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='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 * FROM register WHERE sample_no=1449 The Ecological Register: Delta Waterfowl Research Station
Delta Waterfowl Research Station
Basic information
Sample name: Delta Waterfowl Research Station

Reference: G. C. Sanderson. 1950. Small-mammal population of a prairie grove. Journal of Mammalogy 31(1):17-25 [ER 962]
Geography
Country: Canada

State: Manitoba


Coordinate: 50° 12' N, 98° 12' W
Coordinate basis: based on nearby landmark

Geography comments: apparently somewhere near "the Delta Waterfowl Research Station, Delta, Manitoba" which is actually near Delta Beach, Manitoba (coordinate based on Delta Marsh)

•
Environment
Habitat: temperate broadleaf/mixed forest

Altered habitat: secondary forest

Substrate: ground surface

MAT: 1.5

WMT: 19.1

CMT: -19.8

MAP: 499.0

Habitat comments: "a small wooded area surrounded by prairie" that was "cleared... of trees in 1929" and "had been uncut for eighteen years when this study was made"; the "principal trees" were choke cherry, bur oak, and red osier dogwood
climate data are based on Shay (1999, University of Manitoba Field Station (Delta Marsh) Occasional Publication)

Methods
Life forms: rodents,other small mammals

Sampling methods: quadrat,baited,snap traps

Sample size: 140 individuals

Years: 1947

Days: 31

Nets or traps: 103

Net or trap nights: 2966

Sampling comments: "'museum special'" snap traps baited with "a mixture of peanut butter and bacon grease" were used... Fifty-three traps were set six to ten feet apart in a grid" and another 50 "small snap traps" were deployed "twenty days after the start of trapping" and then another "six lines of sixteen traps" were set "Eight days later"; total trap nights are stated

Metadata
Sample number: 1449

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-03-02 13:07:16

Modified: 2015-10-08 09:53:44

Abundance distribution
5 species
1 singleton
total count 140
extrapolated richness: 6.8
Fisher's α: 1.013
geometric series k: 0.3482
Hurlbert's PIE: 0.6080
Shannon's H: 1.0935
Good's u: 0.9929
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Peromyscus maniculatus bairdii6819.1 g
Microtus pennsylvanicus drummondii5335.7 g
Zapus hudsonius campestris1315.6 g
Myodes gapperi loringi524.1 g
placed in "Clethrionomys"
Sorex cinereus14.1 g