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=3444 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3444SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3129SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3444 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aepyceros' AND (junior_species='melampus' OR junior_species='melampus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aepyceros' AND (species='melampus' OR species='melampus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aepyceros' AND (junior_species='melampus' OR junior_species='melampus')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='Aepyceros' AND (species='melampus' OR species='melampus') 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='Connochaetes' AND (junior_species='taurinus' OR junior_species='taurinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Connochaetes' AND (species='taurinus' OR species='taurinus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Connochaetes' AND (junior_species='taurinus' OR junior_species='taurinus')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='Connochaetes' AND (species='taurinus' OR species='taurinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syncerus' AND (junior_species='caffer' OR junior_species='caffer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syncerus' AND (species='caffer' OR species='caffer') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syncerus' AND (junior_species='caffer' OR junior_species='caffer')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='Syncerus' AND (species='caffer' OR species='caffer') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvicapra' AND (junior_species='grimmia' OR junior_species='grimmia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sylvicapra' AND (species='grimmia' OR species='grimmia') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvicapra' AND (junior_species='grimmia' OR junior_species='grimmia')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='Sylvicapra' AND (species='grimmia' OR species='grimmia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taurotragus' AND (junior_species='oryx' OR junior_species='oryx')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Taurotragus' AND (species='oryx' OR species='oryx') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taurotragus' AND (junior_species='oryx' OR junior_species='oryx')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='Taurotragus' AND (species='oryx' OR species='oryx') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phacochoerus' AND (junior_species='spp.' OR junior_species='spp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phacochoerus' AND (species='spp.' OR species='spp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phacochoerus' AND (species='spp.' OR species='spp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phacochoerus' AND (junior_species='spp.' OR junior_species='spp.')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='Phacochoerus' AND (species='spp.' OR species='spp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='quagga' OR junior_species='quagga')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Equus' AND (species='quagga' OR species='quagga') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='quagga' OR junior_species='quagga')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='quagga' OR species='quagga') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3444 The Ecological Register: Makwe Rockshelter 2
Makwe Rockshelter 2
Basic information
Sample name: Makwe Rockshelter 2

Reference: J. R. Robinson and J. Rowan. 2017. Holocene paleoenvironmental change in southeastern Africa (Makwe Rockshelter, Zambia): Implications for the spread of pastoralism. Quaternary Science Reviews 156:57-68 [ER 3129]
Geography
Country: Zambia


Coordinate: -14.413333° S, 31.933332° E
Coordinate basis: stated in text

Time interval: Holocene

Max Ma: 0.005717

Min Ma: 0.005495

Age basis: radiocarbon (calibrated)

Geography comments: 2ii 5717±103
2i 5495±149

"Makwe Rockshelter is located in the southwestern corner of Zambia's Katete District (14º24.8' S; 31º56.0' E) approximately 1.0 km from the international border with Mozambique"


•
Environment
Lithology: not described

Taphonomic context: human accumulation,rock shelter

Archaeology: stone tools

Habitat comments: "The rockshelter is located in the northeast side of a large granite dome known as Little Makwe kopje at 1000-1050 m above sea level on the grassy, well-watered plateau of the Zambian Highveld (Phillipson, 1973, 1976). The rockshelter itself is formed by an overhang 20 m long and 9 m high extending 8.5 m into the granite dome. The presence of large boulders restricts the surface area to~45 m2"
there are lithics but no ceramics except for "A few pieces of pottery" interpreted as due "to localized disturbance and/or stratigraphic inconsistencies"

Methods
Life forms: ungulates

Sampling methods: quarry

Sample size: 39 specimens

Sampling comments: "Details of the exca-vations can be found inPhillipson (1976)." - I can't actually seem to get a copy of this volume, but I assume the years of excavation are in there.

Metadata
Sample number: 3444

Contributor: Aniko Toth

Enterer: Aniko Toth

Created: 2019-09-01 21:20:44

Modified: 2022-01-20 00:39:45

Abundance distribution
8 species
3 singletons
total count 39
extrapolated richness: 19.0
Fisher's α: 3.049
geometric series k: 0.6314
Hurlbert's PIE: 0.5540
Shannon's H: 1.3024
Good's u: 0.9257
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Aepyceros melampus351 kg browser-grazer
Alcelaphus buselaphus1143 kg grazer-browser
Connochaetes taurinus2202 kg grazer-browser
Syncerus caffer2548 kg grazer-browser
Sylvicapra grimmia413 kg browser-grazer
Taurotragus oryx1393 kg browser-grazer
"Tragelaphus oryx"
Phacochoerus spp.25
Equus quagga1279 kg grazer