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
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 Reviews220: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.