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=3736 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3736SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3371SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3736 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipposideros' 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='Hipposideros' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipposideros' 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='Hipposideros' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sus' 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='Sus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sus' 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='Sus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervus' AND (junior_species='unicolor' OR junior_species='unicolor')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cervus' AND (species='unicolor' OR species='unicolor') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervus' AND (junior_species='unicolor' OR junior_species='unicolor')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''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='Cervus' AND (species='unicolor' OR species='unicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rodentia' 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='Rodentia' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rodentia' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rodentia' 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='Rodentia' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyprinidae' 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='Cyprinidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyprinidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyprinidae' 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='Cyprinidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Indochinamon' 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='Indochinamon' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Indochinamon' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Indochinamon' 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='Indochinamon' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Margaritifera' AND (junior_species='laosensis' OR junior_species='laosensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Margaritifera' AND (species='laosensis' OR species='laosensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Margaritifera' AND (species='laosensis' OR species='laosensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Margaritifera' AND (junior_species='laosensis' OR junior_species='laosensis')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='Margaritifera' AND (species='laosensis' OR species='laosensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gastropoda' 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='Gastropoda' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gastropoda' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gastropoda' 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='Gastropoda' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3736 The Ecological Register: Spirit Cave (Layer 2A)
Spirit Cave (Layer 2A)
Basic information
Sample name: Spirit Cave (Layer 2A)

Reference: C. Conrad, C. Higham, M. Eda, and B. Marwick. 2016. Palaeoecology and forager subsistence strategies during the Pleistocene - Holocene transition: A reinvestigation of the zooarchaeological assemblage from Spirit Cave, Mae Hong Son Province, Thailand. Asian Perspectives 55(1):2-27 [ER 3371]
Geography
Country: Thailand

State: Mae Hong Son


Coordinate: 19° 34' N, 98° 16' E
Time interval: Holocene

Ma: 0.00852

Age basis: radiocarbon (uncalibrated)

Geography comments: "Spirit Cave is located in the karstic upland region of Mae Hong Son Province, northwest Thailand"
Coordinates are not given in the text, they were instead taken from the Wikipedia article for the site
Dates for the site were obtained from nine "samples of bamboo charcoal" and published by Gormon (1970)
One date was obtained for Layer 2A, ranging from 10414-8590 cal. B.P.

•
Environment
Lithology: limestone

Taphonomic context: cave,human accumulation

Archaeology: ceramics,stone tools

Habitat comments: "An initial survey of the three chambers that comprise the cave complex suggested an intact and rich archaeological deposit in the middle cave section"
"the middle cave proved promising for archaeological excavation, with cord-marked pottery sherds, flakes, and quartzite cores visible on the surface" and this chamber was subsequently excavated "between June and July 1966"

Methods
Life forms: bats,rodents,ungulates,fishes,crustaceans,clams,snails

Sampling methods: quarry,screenwash,surface

Sample size: 33 specimens

Sampled by: C.F. Gormon

Years: 1966

Sampling comments: "Excavation used 1 m squares following the natural strata" and "fine-grained screening (1 mm mesh)" of the "5 layers at the site"
"After an interval of 48 years [since the original 1966 excavations] and 4 different storage locations at the University of Otago, only part of the original collection has been located"
Therefore, "the Spirit Cave assemblage is a subset of the original collection, it does not represent the complete assemblage"
"...our reanalysis deals with only a minute portion of the original assemblage excavated and recovered by Gorman"

Metadata
Sample number: 3736

Contributor: Benjamin Carter

Enterer: Benjamin Carter

Created: 2021-05-18 10:20:28

Modified: 2023-04-28 01:02:04

Abundance distribution
8 species
2 singletons
total count 33
extrapolated richness: 15.5
Fisher's α: 3.359
geometric series k: 0.7306
Hurlbert's PIE: 0.7888
Shannon's H: 1.7630
Good's u: 0.9446
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Hipposideros sp.88.3 g
also 7 Chiroptera indet.
Sus sp.1
Cervus unicolor1100 kg grazer-browser
"Rusa unicolor"
Rodentia indet.2
also 60 Mammalia indet.
Cyprinidae indet.8
Indochinamon sp.2
Margaritifera laosensis2
Gastropoda indet.9