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=1459 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1459SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=972SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1459 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dipodomys' AND (junior_species='merriami' OR junior_species='merriamii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dipodomys' AND (species='merriami' OR species='merriamii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dipodomys' AND (junior_species='merriami' OR junior_species='merriamii')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='Dipodomys' AND (species='merriami' OR species='merriamii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perognathus' AND (junior_species='longimembris' OR junior_species='longimembris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perognathus' AND (species='longimembris' OR species='longimembris') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perognathus' AND (junior_species='longimembris' OR junior_species='longimembris')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='Perognathus' AND (species='longimembris' OR species='longimembris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ammospermophilus' AND (junior_species='leucurus' OR junior_species='leucurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ammospermophilus' AND (species='leucurus' OR species='leucurus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ammospermophilus' AND (junior_species='leucurus' OR junior_species='leucurus')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='Ammospermophilus' AND (species='leucurus' OR species='leucurus') 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 * FROM register WHERE sample_no=1459 The Ecological Register: Edwards Air Force Base
Edwards Air Force Base
Basic information
Sample name: Edwards Air Force Base

Reference: M. J. O'Farrell, W. A. Clark, F. H. Emmerson, S. M. Juarez, F. R. Kay, T. M. O'Farrel, and T. Y. Goodlett. 1994. Use of a mesh live trap for small mammals: are results from Sherman live traps deceptive?. Journal of Mammalogy 75(3):692-699 [ER 972]
Geography
Country: United States

State: California


Coordinate: 34° 54' N, 117° 53' W
Coordinate basis: based on nearby landmark

Geography comments: coordinate based on Edwards Air Force Base

•
Environment
Habitat: desert/xeric shrubland

Substrate: ground surface

MAT: 18.1

MAP: 112.0

Habitat comments: climate data are based on Webb et al. (2009, Journal of Wildlife Management)

Methods
Life forms: rodents

Sites: 3

Sampling methods: baited,cage traps,Sherman traps

Sample size: 386 individuals

Years: 1992

Days: 4

Nets or traps: 240

Net or trap nights: 960

Sampling comments: "live traps custom-made of hardware cloth" and Sherman traps both baited with "a mixture of crimped oats, wild-bird seed, and peanut butter"; sampling was on three "6 by 10-station grids with 20-m spacing" over four days, apparently with only 40 traps per grid per type

Metadata
Sample number: 1459

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-03-02 16:33:23

Modified: 2015-10-09 06:28:59

Abundance distribution
4 species
0 singletons
total count 386
extrapolated richness: 4.1
Fisher's α: 0.622
geometric series k: 0.3620
Hurlbert's PIE: 0.4991
Shannon's H: 0.8971
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Dipodomys merriami25340.4 g
Perognathus longimembris997.5 g
Ammospermophilus leucurus2290.8 g
Peromyscus maniculatus1219.1 g