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=3545 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3545SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3222SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3545 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvilagus' AND (junior_species='audubonii' OR junior_species='auduboni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sylvilagus' AND (species='audubonii' OR species='auduboni') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvilagus' AND (junior_species='audubonii' OR junior_species='auduboni')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='audubonii' OR species='auduboni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' AND (junior_species='californicus' OR junior_species='californicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepus' AND (species='californicus' OR species='californicus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' AND (junior_species='californicus' OR junior_species='californicus')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='Lepus' AND (species='californicus' OR species='californicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cynomys' AND (junior_species='gunnisoni' OR junior_species='gunnisonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cynomys' AND (species='gunnisoni' OR species='gunnisonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cynomys' AND (species='gunnisoni' OR species='gunnisonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cynomys' AND (junior_species='gunnisoni' OR junior_species='gunnisonii')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='gunnisoni' OR species='gunnisonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perognathinae' 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='Perognathinae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perognathinae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perognathinae' 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='Perognathinae' AND (species='indet.' OR species='indet.') 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='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='Lynx' AND (junior_species='rufus' OR junior_species='rufus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lynx' AND (species='rufus' OR species='rufus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lynx' AND (junior_species='rufus' OR junior_species='rufus')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='Lynx' AND (species='rufus' OR species='rufus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antilocapra' AND (junior_species='americana' OR junior_species='americana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Antilocapra' AND (species='americana' OR species='americana') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antilocapra' AND (junior_species='americana' OR junior_species='americana')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='Antilocapra' AND (species='americana' OR species='americana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meleagris' AND (junior_species='gallopavo' OR junior_species='gallopavo')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Meleagris' AND (species='gallopavo' OR species='gallopavo') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Meleagris' AND (species='gallopavo' OR species='gallopavo')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meleagris' AND (junior_species='gallopavo' OR junior_species='gallopavo')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='Meleagris' AND (species='gallopavo' OR species='gallopavo') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3545
The Ecological Register: Eleventh Hour Site (Room 7, Layer 3)
Reference:W. B. Gillespie. 1991. Faunal remains from 29SJ 633. In Excavations at 29SJ 633: The Eleventh Hour Site, Chaco Canyon, New Mexico (eds. F. J. Mathien), pp. 243-315 [ER 3222]
Geography
Country: United States
State: New Mexico
Coordinate:36° 3' N, 107° 58' W
Coordinate basis: based on nearby landmark
Time interval: Holocene
Section: 3222
Unit number: 3
Unit order: above to below
Max Ma: 0.0009
Min Ma: 0.0007
Age basis: other
Geography comments: "in Marcia's Rincon on the south side of Chaco Canyon in an area across the Chaco Wash from the park's Visitor's Center" (coordinate based on Chaco Wash)
dated at "late 1000s-mid 1100s and late 1100s-early 1200s" primarily on ceramic data, with no radiocarbon dating
•
Environment
Lithology: sandstone
Taphonomic context: human accumulation,midden
Archaeology: buildings,ceramics,stone tools
Habitat comments: "a 12-15-room Pueblo III house"
"a moist, brown, sandy soil with considerable amounts of charcoal, adobe, and dense concentrations of artifacts" including sherds, chipped stone, and bones
there are bone tools and burials elsewhere on the site
Methods
Life forms: carnivores,rodents,ungulates,other small mammals,birds
Sampling methods: quarry,screenwash
Sample size: 182 specimens
Sampling comments: "all soils removed were put through a 1/4-in.-mesh screen"
Metadata
Sample number: 3545
Contributor: John Alroy
Enterer: John Alroy
Created: 2019-09-17 14:07:13
Modified: 2023-04-29 02:12:59
Abundance distribution
9 species
1 singleton
total count 182
extrapolated richness: 12.8
Fisher's α: 1.988
geometric series k: 0.5829
Hurlbert's PIE: 0.6955
Shannon's H: 1.4525
Good's u: 0.9946
Each square represents a species. Square sizes are proportional to counts.