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=4230 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=4230SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3856SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=4230 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stephanorhinus' AND (junior_species='etruscus' OR junior_species='etruscus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stephanorhinus' AND (species='etruscus' OR species='etruscus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stephanorhinus' AND (species='etruscus' OR species='etruscus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stephanorhinus' AND (junior_species='etruscus' OR junior_species='etruscus')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='Stephanorhinus' AND (species='etruscus' OR species='etruscus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' 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='Equus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Equus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' 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='Equus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bovidae' 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='Bovidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bovidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bovidae' 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='Bovidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=4230
Reference:P. Kiberd. 2006. Bundu Farm: a report on archaeological and palaeoenvironmental assemblages from a pan site in Bushmanland, Northern Cape, South Africa. South African Archaeological Bulletin61:189-201 [ER 3856]
Geography
Country: Spain
Coordinate:37.72° N, -2.41° W
Coordinate basis: estimated from map
Time interval: Early Pleistocene
Ma: 1.2
Age basis: zone
Geography comments: "7 km west of the town of Orce" (see Fig. 1)
age estimated at 1.2 Ma based on the occurrence of Allophaiomys aff. lavocati (not included in the data table), although paleomagnetic data and U series/ESR dates have been published elsewhere
Habitat comments: "near the margins" of an ancient lake
lithologies at the six levels are unfossiliferous whitish limestones (1), green clays (2), brown whitish clays (3), unfossiliferous whitish nodulous limestones (4), clays (fossiliferous level within 5), and dark brown clays (6)
Oldowan lithic artefacts are described elsewhere
there are numerous "tooth-marked bones" in levels 2, 3, and 5 but "Hominins also contributed to the accumulation and modification of the faunal assemblage", and there are cut marks and percussion marks
Methods
Life forms: ungulates
Sampling methods: quarry
Sample size: 6 specimens
Years: 2017 - 2020
Metadata
Sample number: 4230
Contributor: John Alroy
Enterer: John Alroy
Created: 2023-04-19 20:08:33
Modified: 2023-04-19 10:08:33
Abundance distribution
3 species
1 singleton
total count 6
extrapolated richness: 7.7
Fisher's α: 2.388
geometric series k: 0.5774
Hurlbert's PIE: 0.5333
Shannon's H: 1.0114
Good's u: 0.8810
Each square represents a species. Square sizes are proportional to counts.