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=1465 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1465SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=977SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1465 ORDER BY register_no ASCSELECT 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='Neotamias' AND (junior_species='minimus' OR junior_species='minimus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neotamias' AND (species='minimus' OR species='minimus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neotamias' AND (species='minimus' OR species='minimus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neotamias' AND (junior_species='minimus' OR junior_species='minimus')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='minimus' OR species='minimus') 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 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='Dipodomys' AND (junior_species='microps' OR junior_species='microps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dipodomys' AND (species='microps' OR species='microps') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dipodomys' AND (junior_species='microps' OR junior_species='microps')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='microps' OR species='microps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urocitellus' AND (junior_species='townsendii' OR junior_species='townsendi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Urocitellus' AND (species='townsendii' OR species='townsendi') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urocitellus' AND (junior_species='townsendii' OR junior_species='townsendi')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='Urocitellus' AND (species='townsendii' OR species='townsendi') 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='Perognathus' AND (junior_species='parvus' OR junior_species='parvus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perognathus' AND (species='parvus' OR species='parvus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perognathus' AND (junior_species='parvus' OR junior_species='parvus')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='parvus' OR species='parvus') 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='leucogaster' OR junior_species='leucogaster')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onychomys' AND (species='leucogaster' OR species='leucogaster') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onychomys' AND (junior_species='leucogaster' OR junior_species='leucogaster')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='leucogaster' OR species='leucogaster') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lemmiscus' AND (junior_species='curtatus' OR junior_species='curtatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lemmiscus' AND (species='curtatus' OR species='curtatus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lemmiscus' AND (junior_species='curtatus' OR junior_species='curtatus')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='Lemmiscus' AND (species='curtatus' OR species='curtatus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1465 The Ecological Register: Raft River Valley
Raft River Valley
Basic information
Sample name: Raft River Valley

Reference: D. R. Johnson. 1961. The food habits of rodents on rangelands of southern Idaho. Ecology 42(2):407-410 [ER 977]
Geography
Country: United States

State: Idaho


Coordinate: 42° 19' N, 113° 22' W
Coordinate basis: based on nearby landmark

Geography comments: "in the Raft River Valley, near Malta" with some individuals of minor species possibly but probably not captured at other sites (text is unclear) (coordinate based on Malta)

Environment
Habitat: desert/xeric shrubland

Altered habitat: pasture

Substrate: ground surface

WMT: 21.1

CMT: -2.8

MAP: 296.0

Habitat comments: "sagebrush and shadscale associations" under "heavy use by livestock"
climate data are averaged for Burley an Albion and are from Tisdale and Zappetini (1953, Journal of Range Management)

Methods
Life forms: rodents

Sites: 5

Sampling methods: line transect,baited,snap traps

Sample size: 846 individuals

Years: 1957

Sampling comments: "rolled oats" baited "Museum Special traps placed in transect lines of 50 traps each" with most trapping at five sites (number of lines not stated and no other details are given)

Metadata
Sample number: 1465

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-03-03 12:32:18

Modified: 2015-12-01 09:48:58

Abundance distribution
11 species
0 singletons
total count 846
extrapolated richness: 11.8
Fisher's α: 1.785
geometric series k: 0.6444
Hurlbert's PIE: 0.7191
Shannon's H: 1.6508
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.
Register