The Ecological Register: Box Elder Creek

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=3542 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3542SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3221SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3542 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scalopus' AND (junior_species='aquaticus' OR junior_species='aquaticus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scalopus' AND (species='aquaticus' OR species='aquaticus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scalopus' AND (junior_species='aquaticus' OR junior_species='aquaticus')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='Scalopus' AND (species='aquaticus' OR species='aquaticus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvilagus' AND (junior_species='floridanus' OR junior_species='floridanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sylvilagus' AND (species='floridanus' OR species='floridanus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvilagus' AND (junior_species='floridanus' OR junior_species='floridanus')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='Sylvilagus' AND (species='floridanus' OR species='floridanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cynomys' AND (junior_species='ludovicianus' OR junior_species='ludovicianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cynomys' AND (species='ludovicianus' OR species='ludovicianus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cynomys' AND (species='ludovicianus' OR species='ludovicianus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cynomys' AND (junior_species='ludovicianus' OR junior_species='ludovicianus')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='ludovicianus' OR species='ludovicianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ictidomys' AND (junior_species='tridecemlineatus' OR junior_species='tridecemlineatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ictidomys' AND (species='tridecemlineatus' OR species='tridecemlineatus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ictidomys' AND (junior_species='tridecemlineatus' OR junior_species='tridecemlineatus')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='Ictidomys' AND (species='tridecemlineatus' OR species='tridecemlineatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geomys' AND (junior_species='bursarius' OR junior_species='bursarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Geomys' AND (species='bursarius' OR species='bursarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Geomys' AND (species='bursarius' OR species='bursarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geomys' AND (junior_species='bursarius' OR junior_species='bursarius')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='Geomys' AND (species='bursarius' OR species='bursarius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaetodipus' AND (junior_species='hispidus' OR junior_species='hispidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chaetodipus' AND (species='hispidus' OR species='hispidus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaetodipus' AND (junior_species='hispidus' OR junior_species='hispidus')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='hispidus' OR species='hispidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peromyscus' 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='Peromyscus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Peromyscus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peromyscus' 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='Peromyscus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sigmodon' AND (junior_species='hispidus' OR junior_species='hispidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sigmodon' AND (species='hispidus' OR species='hispidus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sigmodon' AND (junior_species='hispidus' OR junior_species='hispidus')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='Sigmodon' AND (species='hispidus' OR species='hispidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' 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='Microtus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microtus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' 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='Microtus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odocoileus' AND (junior_species='virginianus' OR junior_species='virginianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Odocoileus' AND (species='virginianus' OR species='virginianus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odocoileus' AND (junior_species='virginianus' OR junior_species='virginianus')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='Odocoileus' AND (species='virginianus' OR species='virginianus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3542 The Ecological Register: Box Elder Creek

Box Elder Creek

Basic information

Sample name: Box Elder Creek

Reference: K. S. Smith. 1992. A Holocene mammalian fauna from Box Elder Creek, Caddo County, Oklahoma. Proceedings of the Oklahoma Academy of Science 72:39-44 [ER 3221]

Geography

Country: United States

State: Oklahoma

Coordinate: 34° 54' N, 98° 22' W

Coordinate basis: based on nearby landmark

Time interval: Holocene

Ma: 0.00244

Age basis: radiocarbon (uncalibrated)

Geography comments: "At the D.G. Smith Ranch, immediately north of Apache and on the north side of Oklahoma Highway 19" (coordinate based on Apache)
"Unweathered mollusc shells associated with the vertebrate remains, taken from deep in the deposit, were radiocarbon dated (Beta Analytic, Inc. No. 41698) at 2,440±80 YBP" (presumed to be uncalibrated because the error is symmetrically distributed)

•

Environment

Lithology: claystone

Taphonomic context: fluvial deposit

Archaeology: stone tools

Habitat comments: "A dark silty deposit, presumably the remnants of an old beaver dam" also called a "lens-shaped dark clay deposit"
a single "projectile point" identified "as a Gary point" was found in association with the Odocoileus specimen

Methods

Life forms: rodents,ungulates,other small mammals

Sampling methods: quarry,screenwash

Sample size: 63 specimens

Years: 1990

Sampling comments: "Approximately one ton of the dark matrix was removed and screen-washed" (i.e., 907 kg)

Metadata

Sample number: 3542

Contributor: John Alroy

Enterer: John Alroy

Created: 2019-09-15 17:23:49

Modified: 2023-09-11 10:47:10

Abundance distribution

10 species

4 singletons

total count 63

extrapolated richness: 22.2

Fisher's α: 3.349

geometric series k: 0.6695

Hurlbert's PIE: 0.6157

Shannon's H: 1.4542

Good's u: 0.9370

Each square represents a species. Square sizes are proportional to counts.

• Find matching samples

Register

Scalopus aquaticus	1	94.9 g
Sylvilagus floridanus	1	1.1 kg herbivore
Cynomys ludovicianus	3
Ictidomys tridecemlineatus	3	160 g
"Spermophilus tridecemlineatus"
Geomys bursarius	9
"6 upper molars, 1 incisor, and a few partial teeth" (meaning at least two)
Chaetodipus hispidus	5	32.1 g
Peromyscus sp.	1
leucopus or maniculatus
Sigmodon hispidus	2	89.4 g
Microtus sp.	37
ochrogaster or pinetorum
Odocoileus virginianus	1	75 kg herbivore