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=1456 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1456SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=969SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1456 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='Neotamias' AND (junior_species='speciosus' OR junior_species='speciosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neotamias' AND (species='speciosus' OR species='speciosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neotamias' AND (species='speciosus' OR species='speciosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neotamias' AND (junior_species='speciosus' OR junior_species='speciosus')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='Neotamias' AND (species='speciosus' OR species='speciosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thomomys' AND (junior_species='bottae' OR junior_species='bottae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thomomys' AND (species='bottae' OR species='bottae') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thomomys' AND (junior_species='bottae' OR junior_species='bottae')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='Thomomys' AND (species='bottae' OR species='bottae') 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='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='Microtus' AND (species='longicaudus' OR species='longicaudus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' 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='Microtus' AND (species='longicaudus' OR species='longicaudus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zapus' AND (junior_species='princeps' OR junior_species='princeps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zapus' AND (species='princeps' OR species='princeps') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zapus' AND (junior_species='princeps' OR junior_species='princeps')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='princeps' OR species='princeps') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1456 The Ecological Register: Sierra National Forest (pitfall traps)
Sierra National Forest (pitfall traps)
Basic information
Sample name: Sierra National Forest (pitfall traps)

Reference: D. F. Williams and S. E. Braun. 1983. Comparison of pitfall and conventional traps for sampling small mammal populations. Journal of Wildlife Management 47(3):841-845 [ER 969]
Geography
Country: United States

State: California


Coordinate: 37° 25' N, 119° 10' W
Coordinate basis: based on nearby landmark

Geography comments: somewhere in Fresno County: coordinate based on Sierra National Forest
elevation 1830 to 2300 m

•
Environment
Habitat: temperate broadleaf/mixed forest

Protection: national/state forest

Substrate: ground surface

MAT: 10.8

MAP: 1065.0

Habitat comments: "mixed-conifer and red fir forests" and specifically "wet and dry meadows, riparian deciduous communities, and the successional stages of conifer forests"
climate data are for the Sierra National Forest and are from Safford et al. (2012, Forest Ecology and Management)

Methods
Life forms: rodents,other small mammals

Sampling methods: drift fences,pitfall traps

Sample size: 90 individuals

Years: 1979

Days: 11

Nets or traps: 100

Net or trap nights: 1100

Sampling comments: pitfall traps with wooden board drift fences set out at 50 sites, each with "2 trap stations located 15 m apart"

Metadata
Sample number: 1456

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-03-02 15:38:03

Modified: 2015-12-01 09:35:07

Abundance distribution
6 species
1 singleton
total count 90
extrapolated richness: 8.9
Fisher's α: 1.447
geometric series k: 0.4339
Hurlbert's PIE: 0.4492
Shannon's H: 0.9676
Good's u: 0.9891
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Sorex trowbridgii657.5 g
Neotamias speciosus1
"Tamias speciosus"
Thomomys bottae2128 g
Peromyscus maniculatus619.1 g
Microtus longicaudus530.2 g
Zapus princeps1126.2 g