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=1446 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1446SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=960SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1446 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaetodipus' AND (junior_species='hispidus' OR junior_species='hispidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chaetodipus' AND (species='hispidus' OR species='hispidus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaetodipus' AND (junior_species='hispidus' OR junior_species='hispidus')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='Chaetodipus' AND (species='hispidus' OR species='hispidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Reithrodontomys' AND (junior_species='montanus' OR junior_species='montanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Reithrodontomys' AND (species='montanus' OR species='montanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Reithrodontomys' AND (species='montanus' OR species='montanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Reithrodontomys' AND (junior_species='montanus' OR junior_species='montanus')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='Reithrodontomys' AND (species='montanus' OR species='montanus') 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='Peromyscus' AND (junior_species='leucopus' OR junior_species='leucopus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Peromyscus' AND (species='leucopus' OR species='leucopus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peromyscus' AND (junior_species='leucopus' OR junior_species='leucopus')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='leucopus' OR species='leucopus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' AND (junior_species='ochrogaster' OR junior_species='ochrogaster')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microtus' AND (species='ochrogaster' OR species='ochrogaster') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' AND (junior_species='ochrogaster' OR junior_species='ochrogaster')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='ochrogaster' OR species='ochrogaster') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1446 The Ecological Register: North of Stillwater (heavily grazed grassland, March)
North of Stillwater (heavily grazed grassland, March)
Basic information
Sample name: North of Stillwater (heavily grazed grassland, March)

Reference: G. D. Schnell, R. D. Owen, R. K. Chesser, and P. G. Risser. 1980. Populations of small mammals in north-central Oklahoma. Southwestern Naturalist 25(1):67-80 [ER 960]
Geography
Country: United States

State: Oklahoma


Coordinate: 36° 27' N, 97° 4' W
Coordinate basis: based on nearby landmark

Geography comments: "37 km N Stillwater in Pawnee and Noble counties" (coordinate extrapoldated from that of Stillwater)

•
Environment
Habitat: temperate savanna

Altered habitat: pasture

Substrate: ground surface

MAT: 15.1

WMT: 26.9

CMT: 2.8

MAP: 859.0

Habitat comments: climate data are for neighboring Payne County and are based on Cobb and Hawker (1916, USDA "Soil Survey of Payne County, Oklahoma")

Methods
Life forms: rodents

Sampling methods: quadrat,baited,Sherman traps

Sample size: 43 individuals

Years: 1975

Days: 19

Nets or traps: 150

Net or trap nights: 2850

Sampling comments: "Sherman live traps... arranged in grids and lines" and baited "with a mixture of rolled oats and peanut butter"; each grid included 144 stations "15 m apart" but this one had "an additional six stations at the south end"

Metadata
Sample number: 1446

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-03-02 12:31:47

Modified: 2015-10-08 09:42:28

Abundance distribution
5 species
2 singletons
total count 43
extrapolated richness: 11.3
Fisher's α: 1.465
geometric series k: 0.4111
Hurlbert's PIE: 0.3095
Shannon's H: 0.7061
Good's u: 0.9546
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Chaetodipus hispidus132.1 g
Reithrodontomys montanus4
Peromyscus maniculatus3519.1 g
Peromyscus leucopus221.0 g
Microtus ochrogaster133.9 g