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=3990 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3990SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3743SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3990 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='mesomelas' OR junior_species='mesomelas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canis' AND (species='mesomelas' OR species='mesomelas') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='mesomelas' OR junior_species='mesomelas')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='Canis' AND (species='mesomelas' OR species='mesomelas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' AND (junior_species='capensis' OR junior_species='capensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepus' AND (species='capensis' OR species='capensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lepus' AND (species='capensis' OR species='capensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' AND (junior_species='capensis' OR junior_species='capensis')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='capensis' OR species='capensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Procavia' AND (junior_species='capensis' OR junior_species='capensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Procavia' AND (species='capensis' OR species='capensis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Procavia' AND (junior_species='capensis' OR junior_species='capensis')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='Procavia' AND (species='capensis' OR species='capensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oreotragus' AND (junior_species='oreotragus' OR junior_species='oreotragus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oreotragus' AND (species='oreotragus' OR species='oreotragus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oreotragus' AND (species='oreotragus' OR species='oreotragus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oreotragus' AND (junior_species='oreotragus' OR junior_species='oreotragus')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='Oreotragus' AND (species='oreotragus' OR species='oreotragus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oryx' AND (junior_species='gazella' OR junior_species='gazella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oryx' AND (species='gazella' OR species='gazella') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oryx' AND (junior_species='gazella' OR junior_species='gazella')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='Oryx' AND (species='gazella' OR species='gazella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alcelaphus' AND (junior_species='buselaphus' OR junior_species='buselaphus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alcelaphus' AND (species='buselaphus' OR species='buselaphus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alcelaphus' AND (junior_species='buselaphus' OR junior_species='buselaphus')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='Alcelaphus' AND (species='buselaphus' OR species='buselaphus') 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='Parotomys' AND (junior_species='brantsii' OR junior_species='brantsi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parotomys' AND (species='brantsii' OR species='brantsi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parotomys' AND (species='brantsii' OR species='brantsi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parotomys' AND (junior_species='brantsii' OR junior_species='brantsi')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='Parotomys' AND (species='brantsii' OR species='brantsi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mus' 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='Mus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mus' 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='Mus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chersobius' AND (junior_species='signatus' OR junior_species='signatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chersobius' AND (species='signatus' OR species='signatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chersobius' AND (species='signatus' OR species='signatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chersobius' AND (junior_species='signatus' OR junior_species='signatus')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='Chersobius' AND (species='signatus' OR species='signatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psammobates' AND (junior_species='tentorius' OR junior_species='tentorius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psammobates' AND (species='tentorius' OR species='tentorius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psammobates' AND (species='tentorius' OR species='tentorius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psammobates' AND (junior_species='tentorius' OR junior_species='tentorius')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='Psammobates' AND (species='tentorius' OR species='tentorius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chersina' AND (junior_species='angulata' OR junior_species='angulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chersina' AND (species='angulata' OR species='angulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chersina' AND (species='angulata' OR species='angulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chersina' AND (junior_species='angulata' OR junior_species='angulata')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='Chersina' AND (species='angulata' OR species='angulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aves' 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='Aves' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aves' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aves' 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='Aves' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Serpentes' 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='Serpentes' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Serpentes' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Serpentes' 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='Serpentes' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Choromytilus' AND (junior_species='meridionalis' OR junior_species='meridionalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Choromytilus' AND (species='meridionalis' OR species='meridionalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Choromytilus' AND (species='meridionalis' OR species='meridionalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Choromytilus' AND (junior_species='meridionalis' OR junior_species='meridionalis')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='Choromytilus' AND (species='meridionalis' OR species='meridionalis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3990
The Ecological Register: Spitzkloof A Rockshelter (MIS 2)
Reference:G. Dewar and B. A. Stewart. 2017. Early maritime desert dwellers in Namaqualand, South Africa: a Holocene perspective on Pleistocene peopling. The Journal of Island and Coastal Archaeology12:44-64 [ER 3743]
Geography
Country: South Africa
State: Northern Cape
Coordinate:28° 51' S, 17° 4' E
Coordinate basis: stated in text
Time interval: Late Pleistocene
Section: 3743
Unit number: 1
Unit order: above to below
Max Ma: 0.01975
Min Ma: 0.01955
Age basis: radiocarbon (uncalibrated)
Geography comments: "Spitzkloof A Rockshelter is located in the northern hinterland of Namaqualand, otherwise known as the Richtersveld, in northwestern Northern Cape province, South Africa. The site is 30 km inland from the Atlantic Ocean and 30 km south of the Orange River".
The upper MIS 2 layers have been radiocarbon dated to 23 kyr cal. BP (19,750 ± 80 to 19,550 ± 60 uncal. years BP).
•
Environment
Lithology: sandstone
Taphonomic context: human accumulation,rock shelter
Archaeology: stone tools,other artifacts
Habitat comments: "The rockshelter is one of three consecutive dome-shaped hollows eroded from a folded outcrop of quartzite from the Stinkfontein subgroup".
"The 23 ka cal. BP strata at Spitzkloof yielded one identified ostrich eggshell flask mouth and 1179 g of eggshell fragments, representing five ostrich eggshells. There is also more evidence for social interactions, with ochre appearing for the first time, along with a bone bead, two large ostrich eggshell bead preforms, and two complete beads".
"The assemblage represents a subsistence strategy that suggests an opportunistic and broad diet, with people also hunting the highest ranked or largest species".
Methods
Life forms: carnivores,rodents,ungulates,other large mammals,other small mammals,birds,snakes,turtles,clams
Sampling methods: quarry,screenwash
Sample size: 1035 specimens
Years: 2010
Sampling comments: "Excavation began in April 2010 by establishing a two-by-two m2 grid near the top of the deposit. Three square meters were excavated in a step-like fashion, using standard archaeological methods".
"The sediment was sieved through both 1 mm and 3 mm mesh".
Metadata
Sample number: 3990
Contributor: Benjamin Carter
Enterer: Benjamin Carter
Created: 2022-08-30 12:18:29
Modified: 2023-05-30 01:55:45
Abundance distribution
15 species
4 singletons
total count 1035
extrapolated richness: 26.2
Fisher's α: 2.486
geometric series k: 0.6165
Hurlbert's PIE: 0.2817
Shannon's H: 0.7105
Good's u: 0.9961
Each square represents a species. Square sizes are proportional to counts.