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=1466 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1466SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=978SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1466 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='trowbridgii' OR junior_species='trowbridgi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sorex' AND (species='trowbridgii' OR species='trowbridgi') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='trowbridgii' OR junior_species='trowbridgi')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='trowbridgii' OR species='trowbridgi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='monticolus' OR junior_species='monticolus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sorex' AND (species='monticolus' OR species='monticolus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='monticolus' OR junior_species='monticolus')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='monticolus' OR species='monticolus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myodes' AND (junior_species='californicus' OR junior_species='californicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myodes' AND (species='californicus' OR species='californicus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myodes' AND (junior_species='californicus' OR junior_species='californicus')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='californicus' OR species='californicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='vagrans' OR junior_species='vagrans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sorex' AND (species='vagrans' OR species='vagrans') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='vagrans' OR junior_species='vagrans')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='vagrans' OR species='vagrans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='bendirii' OR junior_species='bendiri')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sorex' AND (species='bendirii' OR species='bendiri') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='bendirii' OR junior_species='bendiri')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='bendirii' OR species='bendiri') 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='Microtus' AND (junior_species='oregoni' OR junior_species='oregonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microtus' AND (species='oregoni' OR species='oregonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microtus' AND (species='oregoni' OR species='oregonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' AND (junior_species='oregoni' OR junior_species='oregonii')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='oregoni' OR species='oregonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scapanus' AND (junior_species='orarius' OR junior_species='orarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scapanus' AND (species='orarius' OR species='orarius') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scapanus' AND (junior_species='orarius' OR junior_species='orarius')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='Scapanus' AND (species='orarius' OR species='orarius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neurotrichus' AND (junior_species='gibbsii' OR junior_species='gibbsi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neurotrichus' AND (species='gibbsii' OR species='gibbsi') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neurotrichus' AND (junior_species='gibbsii' OR junior_species='gibbsi')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='Neurotrichus' AND (species='gibbsii' OR species='gibbsi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zapus' AND (junior_species='trinotatus' OR junior_species='trinotatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zapus' AND (species='trinotatus' OR species='trinotatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zapus' AND (species='trinotatus' OR species='trinotatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zapus' AND (junior_species='trinotatus' OR junior_species='trinotatus')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='trinotatus' OR species='trinotatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arborimus' AND (junior_species='longicaudus' OR junior_species='longicaudus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arborimus' AND (species='longicaudus' OR species='longicaudus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arborimus' AND (junior_species='longicaudus' OR junior_species='longicaudus')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='Arborimus' AND (species='longicaudus' OR species='longicaudus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1466
The Ecological Register: H. J. Andrews Experimental Forest
Reference:R. B. Bury and P. S. Corn. 1987. Evaluation of pitfall trapping in northwestern forests: trap arrays with drift fences. Journal of Wildlife Management51(1):112-119 [ER 978]
Geography
Country: United States
State: Oregon
Coordinate:42° 13' N, 122° 15' W
Coordinate basis: based on nearby landmark
Geography comments: "on or near the H. J. Andrews Experimental Forest" (straddling the border between Lane and Linn counties) (coordinate based on the forest)
•
Environment
Habitat: temperate broadleaf/mixed forest
Substrate: ground surface
MAT: 8.5
WMT: 17.8
CMT: 0.6
MAP: 2300.0
Habitat comments: none given
climate data are for the H. J. Andrews Experimental Forest and are from Jonsson (1999, Bryologist)
Methods
Life forms: rodents,other small mammals
Sites: 18
Sampling methods: no design,drift fences,pitfall traps
Sample size: 1971 individuals
Years: 1983
Days: 180
Nets or traps: 216
Net or trap nights: 38880
Sampling comments: each array "consisted of 2 triads spaced about 25 m apart. Each triad contained 3 5-m-long drift fences" connecting two pitfall traps and one array was in each of 18 stands
reported trap night total doesn't square with the reported number of traps and nights, so the product of the latter is used instead
Metadata
Sample number: 1466
Contributor: John Alroy
Enterer: John Alroy
Created: 2015-03-03 12:55:08
Modified: 2015-12-01 09:54:00
Abundance distribution
11 species
0 singletons
total count 1971
extrapolated richness: 11.2
Fisher's α: 1.537
geometric series k: 0.6610
Hurlbert's PIE: 0.6703
Shannon's H: 1.6013
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.