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=3371 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3371SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3092SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3371 ORDER BY register_no ASCSELECT 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='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='Gazella' AND (junior_species='cuvieri' OR junior_species='cuvierii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gazella' AND (species='cuvieri' OR species='cuvierii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gazella' AND (species='cuvieri' OR species='cuvierii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gazella' AND (junior_species='cuvieri' OR junior_species='cuvierii')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='Gazella' AND (species='cuvieri' OR species='cuvierii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bos' AND (junior_species='primigenius' OR junior_species='primigenius')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='Bos' AND (species='primigenius' OR species='primigenius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bos' AND (species='primigenius' OR species='primigenius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bos' AND (junior_species='primigenius' OR junior_species='primigenius')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='Bos' AND (species='primigenius' OR species='primigenius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ammotragus' AND (junior_species='lervia' OR junior_species='lervia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ammotragus' AND (species='lervia' OR species='lervia') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ammotragus' AND (junior_species='lervia' OR junior_species='lervia')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='Ammotragus' AND (species='lervia' OR species='lervia') 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='Struthio' AND (junior_species='camelus' OR junior_species='camelus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Struthio' AND (species='camelus' OR species='camelus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Struthio' AND (species='camelus' OR species='camelus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Struthio' AND (junior_species='camelus' OR junior_species='camelus')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='Struthio' AND (species='camelus' OR species='camelus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mauremys' AND (junior_species='leprosa' OR junior_species='leprosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mauremys' AND (species='leprosa' OR species='leprosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mauremys' AND (species='leprosa' OR species='leprosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mauremys' AND (junior_species='leprosa' OR junior_species='leprosa')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='Mauremys' AND (species='leprosa' OR species='leprosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Testudo' AND (junior_species='graeca' OR junior_species='graeca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Testudo' AND (species='graeca' OR species='graeca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Testudo' AND (species='graeca' OR species='graeca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Testudo' AND (junior_species='graeca' OR junior_species='graeca')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='Testudo' AND (species='graeca' OR species='graeca') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3371 The Ecological Register: Ifri El Baroud (Unit B2)
Ifri El Baroud (Unit B2)
Basic information
Sample name: Ifri El Baroud (Unit B2)

Sample aka: Gunpowder Cave

Reference: A. Potě, M. Kehl, M. Broich, Y. Carrión Marco, R. Hutterer, T. Jentke, J. Linstädter, J. A. López-Sáez, A. Mikdad, J. Morales, S. Pérez-Díaz, M. Portillo, C. Schmid, P. Vidal-Matutano, and G.-C. Weniger. 2019. Human occupation and environmental change in the western Maghreb during the Last Glacial Maximum (LGM) and the Late Glacial. New evidence from the Iberomaurusian site Ifri El Baroud (northeast Morocco). Quaternary Science Reviews 220:87-110 [ER 3092]
Geography
Country: Morocco

State: Guercif


Coordinate: 34° 45' N, 3° 18' W
Coordinate basis: stated in text

Time interval: Late Pleistocene

Max Ma: 0.01243

Min Ma: 0.01204

Age basis: radiocarbon (uncalibrated)

Geography comments: "at the foot of the Ich Chaboun Massif"
there are four 14C dates on plant material ranging from 12430 +/- 40 to 12040 +/- 40 "yr BP Uncalibrated"

•
Environment
Lithology: limestone

Taphonomic context: cave,human accumulation

Habitat comments: "the sediments of unit B2 consist mainly of carbonates and organic matter, whereas siliceous compounds are few... Ash and charcoal occur abundantly... Fire activity is remarkable... Taphonomic evidence of cut-marks, percussion damage and thermal modification show that most of the faunal remains were brought and processed into the cave by humans"

Methods
Life forms: ungulates,other small mammals,birds,turtles

Sampling methods: quarry

Sample size: 628 specimens

Sampled by: 2015

Metadata
Sample number: 3371

Contributor: John Alroy

Enterer: John Alroy

Created: 2019-08-27 12:33:16

Modified: 2019-08-27 02:33:38

Abundance distribution
9 species
1 singleton
total count 628
extrapolated richness: 11.4
Fisher's α: 1.488
geometric series k: 0.4686
Hurlbert's PIE: 0.4988
Shannon's H: 1.0844
Good's u: 0.9984
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Equus sp.19
Alcelaphus buselaphus6143 kg grazer-browser
Gazella cuvieri16
Bos primigenius2
Ammotragus lervia4080 kg
Lepus capensis1
Struthio camelus430111 kg grazer-browser
Mauremys leprosa100
Testudo graeca14