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=2507 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2507SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2343SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2507 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trilaccogaulus' AND (junior_species='bettae' OR junior_species='bettae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trilaccogaulus' AND (species='bettae' OR species='bettae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trilaccogaulus' AND (species='bettae' OR species='bettae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trilaccogaulus' AND (junior_species='bettae' OR junior_species='bettae')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='Trilaccogaulus' AND (species='bettae' OR species='bettae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mylagaulus' AND (junior_species='vetus' OR junior_species='vetus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mylagaulus' AND (species='vetus' OR species='vetus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mylagaulus' AND (species='vetus' OR species='vetus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mylagaulus' AND (junior_species='vetus' OR junior_species='vetus')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='Mylagaulus' AND (species='vetus' OR species='vetus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marmotini' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Marmotini' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Marmotini' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marmotini' AND (junior_species='indet.' OR junior_species='indet.')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='Marmotini' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spermophilus' AND (junior_species='jerae' OR junior_species='jerae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spermophilus' AND (species='jerae' OR species='jerae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spermophilus' AND (species='jerae' OR species='jerae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spermophilus' AND (junior_species='jerae' OR junior_species='jerae')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='Spermophilus' AND (species='jerae' OR species='jerae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cynomys' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cynomys' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cynomys' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cynomys' AND (junior_species='sp.' OR junior_species='sp.')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='Cynomys' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euroxenomys' AND (junior_species='inconnexus' OR junior_species='inconnexus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euroxenomys' AND (species='inconnexus' OR species='inconnexus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euroxenomys' AND (species='inconnexus' OR species='inconnexus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euroxenomys' AND (junior_species='inconnexus' OR junior_species='inconnexus')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='Euroxenomys' AND (species='inconnexus' OR species='inconnexus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mookomys' AND (junior_species='thrinax' OR junior_species='thrinax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mookomys' AND (species='thrinax' OR species='thrinax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mookomys' AND (species='thrinax' OR species='thrinax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mookomys' AND (junior_species='thrinax' OR junior_species='thrinax')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='Mookomys' AND (species='thrinax' OR species='thrinax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mookomys' AND (junior_species='formicarum' OR junior_species='formicarum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mookomys' AND (species='formicarum' OR species='formicarum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mookomys' AND (species='formicarum' OR species='formicarum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mookomys' AND (junior_species='formicarum' OR junior_species='formicarum')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='Mookomys' AND (species='formicarum' OR species='formicarum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peridiomys' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Peridiomys' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Peridiomys' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peridiomys' AND (junior_species='sp.' OR junior_species='sp.')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='Peridiomys' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peridiomys' AND (junior_species='halis' OR junior_species='halis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Peridiomys' AND (species='halis' OR species='halis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Peridiomys' AND (species='halis' OR species='halis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peridiomys' AND (junior_species='halis' OR junior_species='halis')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='Peridiomys' AND (species='halis' OR species='halis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perognathus' AND (junior_species='ancenensis' OR junior_species='ancenensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perognathus' AND (species='ancenensis' OR species='ancenensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perognathus' AND (species='ancenensis' OR species='ancenensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perognathus' AND (junior_species='ancenensis' OR junior_species='ancenensis')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='ancenensis' OR species='ancenensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perognathus' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perognathus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perognathus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perognathus' AND (junior_species='sp.' OR junior_species='sp.')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='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cupidinimus' AND (junior_species='madisonensis' OR junior_species='madisonensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cupidinimus' AND (species='madisonensis' OR species='madisonensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cupidinimus' AND (species='madisonensis' OR species='madisonensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cupidinimus' AND (junior_species='madisonensis' OR junior_species='madisonensis')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='Cupidinimus' AND (species='madisonensis' OR species='madisonensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cupidinimus' AND (junior_species='eurekensis' OR junior_species='eurekensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cupidinimus' AND (species='eurekensis' OR species='eurekensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cupidinimus' AND (species='eurekensis' OR species='eurekensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cupidinimus' AND (junior_species='eurekensis' OR junior_species='eurekensis')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='Cupidinimus' AND (species='eurekensis' OR species='eurekensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phelosaccomys' AND (junior_species='annae' OR junior_species='annae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phelosaccomys' AND (species='annae' OR species='annae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phelosaccomys' AND (species='annae' OR species='annae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phelosaccomys' AND (junior_species='annae' OR junior_species='annae')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='Phelosaccomys' AND (species='annae' OR species='annae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Copemys' AND (junior_species='lindsayi' OR junior_species='lindsayii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Copemys' AND (species='lindsayi' OR species='lindsayii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Copemys' AND (species='lindsayi' OR species='lindsayii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Copemys' AND (junior_species='lindsayi' OR junior_species='lindsayii')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='Copemys' AND (species='lindsayi' OR species='lindsayii') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2507 The Ecological Register: Anceney
Anceney
Basic information
Sample name: Anceney

Reference: J. F. Sutton and W. W. Korth. 1995. Rodents (Mammalia) from the Barstovian (Miocene) Anceney local fauna, Montana. Annals of Carnegie Museum 64(4):267-314 [ER 2343]
Geography
Country: United States

State: Montana


Coordinate: 45° 40' N, 111° 18' W
Coordinate basis: stated in text

Formation: Madison Valley

Time interval: Early Miocene

Ma: 17.1

Geography comments: "approximately 21 km (13 mi) west of Bozeman... along Route 131 (center, N 1/2, sec. 13, T2S, R3E)"
said to be early Barstovian
2008 AEO age estimate

Environment
Substrate: ground surface

Lithology: sandstone

Habitat comments: "channel accumulations of sands, gravel, clays, and tuffaceous materials"

Methods
Life forms: rodents

Sampling methods: screenwash

Sample size: 1035 specimens

Sampling comments: only rodents are listed; other small mammals are not described

Metadata
Sample number: 2507

Contributor: John Alroy

Enterer: John Alroy

Created: 2017-02-13 12:24:28

Modified: 2017-02-13 01:44:23

Abundance distribution
16 species
3 singletons
total count 1035
extrapolated richness: 22.4
Fisher's α: 2.686
geometric series k: 0.6581
Hurlbert's PIE: 0.6800
Shannon's H: 1.5623
Good's u: 0.9971
Each square represents a species. Square sizes are proportional to counts.
Register