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=1850 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1850SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1650SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1850 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='Dipodomys' AND (junior_species='ordii' OR junior_species='ordi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dipodomys' AND (species='ordii' OR species='ordi') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dipodomys' AND (junior_species='ordii' OR junior_species='ordi')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='ordii' OR species='ordi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perognathus' AND (junior_species='flavus' OR junior_species='flavus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perognathus' AND (species='flavus' OR species='flavus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perognathus' AND (junior_species='flavus' OR junior_species='flavus')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='flavus' OR species='flavus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaetodipus' AND (junior_species='intermedius' OR junior_species='intermedius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chaetodipus' AND (species='intermedius' OR species='intermedius') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaetodipus' AND (junior_species='intermedius' OR junior_species='intermedius')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='intermedius' OR species='intermedius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaetodipus' AND (junior_species='penicillatus' OR junior_species='penicillatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chaetodipus' AND (species='penicillatus' OR species='penicillatus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaetodipus' AND (junior_species='penicillatus' OR junior_species='penicillatus')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='penicillatus' OR species='penicillatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neotoma' AND (junior_species='spp.' OR junior_species='spp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neotoma' AND (species='spp.' OR species='spp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neotoma' AND (species='spp.' OR species='spp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neotoma' AND (junior_species='spp.' OR junior_species='spp.')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='Neotoma' AND (species='spp.' OR species='spp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peromyscus' AND (junior_species='eremicus' OR junior_species='eremicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Peromyscus' AND (species='eremicus' OR species='eremicus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peromyscus' AND (junior_species='eremicus' OR junior_species='eremicus')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='eremicus' OR species='eremicus') 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='Onychomys' AND (junior_species='arenicola' OR junior_species='arenicola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onychomys' AND (species='arenicola' OR species='arenicola') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onychomys' AND (junior_species='arenicola' OR junior_species='arenicola')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='Onychomys' AND (species='arenicola' OR species='arenicola') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1850 The Ecological Register: Jornada Validation Site (1971)
Jornada Validation Site (1971)
Basic information
Sample name: Jornada Validation Site (1971)

Reference: J. G. Hallett. 1982. Habitat Selection and the Community Matrix of a Desert Small-Mammal Fauna. Ecology 63(5):1400-1410 [ER 1650]
Geography
Country: United States

State: New Mexico


Coordinate: 32.5° N, -106.8° W
Coordinate basis: stated in text

Geography comments: "~40 km north northeast of Las Cruces"
coordinate is based on Knapp et al. (2008, Global Change Biology)

Environment
Habitat: desert/xeric shrubland

Substrate: ground surface

MAT: 14.4

MAP: 264.0

Habitat comments: "creosote bush" was "the predominant shrub"
climate data are from Knapp et al. (2008) and are for the Jornada Experimental Range

Methods
Life forms: rodents

Sites: 1

Site length: 100

Site width: 100

Sampling methods: quadrat,baited,Sherman traps

Sample size: 253 individuals

Years: 1971

Days: 16

Nets or traps: 100

Net or trap nights: 1600

Sampling comments: "Rodent populations were followed from May 1971 through January 1974... data were collected... by live-trapping on a 10 x 10 grid (1 ha) with 10-m trap spacing. Sherman live traps baited with cracked milo were run on four consecutive nights at roughly bimonthly intervals. Two traps were placed at alternate stations, and double-trap stations were changed each trap night"
sampling effort presumably 100 traps x 4 nights x 4 sampling periods (May, July, September, November)

Metadata
Sample number: 1850

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-12-20 20:57:12

Modified: 2015-12-20 09:57:12

Abundance distribution
9 species
1 singleton
total count 253
extrapolated richness: 11.6
Fisher's α: 1.822
geometric series k: 0.5392
Hurlbert's PIE: 0.6466
Shannon's H: 1.4293
Good's u: 0.9961
Each square represents a species. Square sizes are proportional to counts.
Register