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=1848 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1848SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1643SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1848 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaetodipus' AND (junior_species='formosus' OR junior_species='formosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chaetodipus' AND (species='formosus' OR species='formosus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaetodipus' AND (junior_species='formosus' OR junior_species='formosus')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='formosus' OR species='formosus') ORDER BY year,last_namesSELECT 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='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='Xerospermophilus' AND (junior_species='tereticaudus' OR junior_species='tereticaudus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xerospermophilus' AND (species='tereticaudus' OR species='tereticaudus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xerospermophilus' AND (junior_species='tereticaudus' OR junior_species='tereticaudus')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='Xerospermophilus' AND (species='tereticaudus' OR species='tereticaudus') 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='Neotoma' AND (junior_species='lepida' OR junior_species='lepida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neotoma' AND (species='lepida' OR species='lepida') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neotoma' AND (junior_species='lepida' OR junior_species='lepida')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='lepida' OR species='lepida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onychomys' AND (junior_species='torridus' OR junior_species='torridus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onychomys' AND (species='torridus' OR species='torridus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onychomys' AND (junior_species='torridus' OR junior_species='torridus')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='torridus' OR species='torridus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Reithrodontomys' AND (junior_species='megalotis' OR junior_species='megalotis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Reithrodontomys' AND (species='megalotis' OR species='megalotis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Reithrodontomys' AND (junior_species='megalotis' OR junior_species='megalotis')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='megalotis' OR species='megalotis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1848 The Ecological Register: Las Vegas Valley
Las Vegas Valley
Basic information
Sample name: Las Vegas Valley

Reference: T. Garland Jr and W. G. Bradley. 1984. Effects of a highway on Mojave Desert rodent populations. American Midland Naturalist 111(1):47-56 [ER 1643]
Geography
Country: United States

State: Nevada


Coordinate: 36° 21' 27" N, 115° 20' 26" W
Coordinate basis: stated in text

Geography comments: "in the Las Vegas Valley... R59E, T 18 S, Section 26... The trapping grid overlapped U.S. Highway 95... Elevation averaged 896 m"

Environment
Habitat: desert/xeric shrubland

Substrate: ground surface

MAT: 17.9

MAP: 160.0

Habitat comments: "a creosote bush (Larrea tridentata) community"
climate data are from Amundson et al. (1989, Geoderma) and are for a point at 840 m in the Las Vegas Valley

Methods
Life forms: rodents

Site area: 9

Sampling methods: quadrat,baited,Sherman traps

Sample size: 612 individuals

Days: 48

Nets or traps: 250

Net or trap nights: 12000

Sampling comments: "A 9-ha, 250-station grid (25x10) was marked with wooden stakes placed at 20-m intervals. Rows were oriented parallel to the highway... Twelve trapping periods were conducted. One Sherman live trap (7.6x7.6x25.4 cm) baited with oats was placed at or within 1 m of each grid stake... Traps were checked the next 4 mornings"

Metadata
Sample number: 1848

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-12-20 16:30:12

Modified: 2015-12-20 05:30:12

Abundance distribution
8 species
1 singleton
total count 612
extrapolated richness: 9.6
Fisher's α: 1.299
geometric series k: 0.4494
Hurlbert's PIE: 0.7190
Shannon's H: 1.5002
Good's u: 0.9984
Each square represents a species. Square sizes are proportional to counts.
Register