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=3335 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3335SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3066SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3335 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervus' AND (junior_species='elaphus' OR junior_species='elaphus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cervus' AND (species='elaphus' OR species='elaphus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervus' AND (junior_species='elaphus' OR junior_species='elaphus')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='elaphus' OR species='elaphus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sus' AND (junior_species='scrofa' OR junior_species='scrofa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sus' AND (species='scrofa' OR species='scrofa') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sus' AND (junior_species='scrofa' OR junior_species='scrofa')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='scrofa' OR species='scrofa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dama' AND (junior_species='dama' OR junior_species='dama')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dama' AND (species='dama' OR species='dama') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dama' AND (junior_species='dama' OR junior_species='dama')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='Dama' AND (species='dama' OR species='dama') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carnivora' 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='Carnivora' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carnivora' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carnivora' 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='Carnivora' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Testudines' 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='Testudines' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Testudines' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Testudines' 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='Testudines' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3335
The Ecological Register: Lakonis Cave I (hearth complex)
Reference:B. M. Starkovich, P. Elefanti, P. Karkanas, and E. Panagopoulou. 2018. Site use and maintenance in the Middle Paleolithic at Lakonis I (Peloponnese, Greece). Journal of Paleolithic Archaeologyx:1-30 [ER 3066]
Geography
Country: Greece
Coordinate:36° 46' N, 22° 34' E
Coordinate basis: based on nearby landmark
Time interval: Late Pleistocene
Max Ma: 0.043335
Min Ma: 0.03964
Age basis: radiocarbon (uncalibrated)
Geography comments: "on the Mani Peninsula, 3 km east of the town of Gytheion" (basis of coordinate)
"AMS dating results based on cultural material taken from well-defined hearths yielded dates of 39,640 ± 1000 BP (uncal), 43,335 ± 1800 BP (uncal), and 43,150 ± 1790 BP (uncal)... for the hearth context, while the upper bone breccia with a date of 43,010 ± 350 BP (uncal)... is broadly contemporaneous... The lower bone breccia overlies beach conglomerate deposits dated preliminary to marine oxygen isotope stage (MIS) 5a... and likely formed during MIS 4"
•
Environment
Substrate: ground surface
Lithology: breccia
Taphonomic context: cave,human accumulation
Habitat comments: "Overlying unit V is a bone breccia (Figs. 2 and 3) with lithic and charcoal remains in a reddish clayey matrix, unit IV, which preserves the site’s initial use sometime after 100 ka. In the central part of the sequence, units III and II consist of a reddish-brown sandy clay matrix containing anthropogenic remains interspersed with roofspall and boulders from the gradual overhang collapse. The uppermost unit (I) is a palimpsest of overlapping hearth lenses forming complex combustion structures"
Methods
Life forms: carnivores,ungulates,turtles
Sampling methods: quarry
Sample size: 49 specimens
Years: 1999 - 2010
Sampling comments: "excavated from 1999 to 2010"
additional indeterminate ungulate remains are present
Metadata
Sample number: 3335
Contributor: John Alroy
Enterer: John Alroy
Created: 2019-08-24 18:46:09
Modified: 2023-04-03 06:55:48
Abundance distribution
5 species
2 singletons
total count 49
extrapolated richness: 9.8
Fisher's α: 1.394
geometric series k: 0.4238
Hurlbert's PIE: 0.5149
Shannon's H: 0.9715
Good's u: 0.9592
Each square represents a species. Square sizes are proportional to counts.