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=4286 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=4286SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3899SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=4286 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mammuthus' 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='Mammuthus' AND (species='meridionalis' OR species='meridionalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mammuthus' AND (species='meridionalis' OR species='meridionalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mammuthus' 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='Mammuthus' AND (species='meridionalis' OR species='meridionalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hippopotamus' AND (junior_species='antiquus' OR junior_species='antiquus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hippopotamus' AND (species='antiquus' OR species='antiquus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hippopotamus' AND (species='antiquus' OR species='antiquus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hippopotamus' AND (junior_species='antiquus' OR junior_species='antiquus')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='Hippopotamus' AND (species='antiquus' OR species='antiquus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stephanorhinus' AND (junior_species='hundsheimensis' OR junior_species='hundsheimensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stephanorhinus' AND (species='hundsheimensis' OR species='hundsheimensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stephanorhinus' AND (species='hundsheimensis' OR species='hundsheimensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stephanorhinus' AND (junior_species='hundsheimensis' OR junior_species='hundsheimensis')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='hundsheimensis' OR species='hundsheimensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervus' AND (junior_species='elaphus' OR junior_species='elaphus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cervus' AND (species='elaphus' OR species='elaphus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervus' AND (junior_species='elaphus' OR junior_species='elaphus')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='Cervus' AND (species='elaphus' OR species='elaphus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dama' AND (junior_species='vallonetensis' OR junior_species='vallonetensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dama' AND (species='vallonetensis' OR species='vallonetensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dama' AND (species='vallonetensis' OR species='vallonetensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dama' AND (junior_species='vallonetensis' OR junior_species='vallonetensis')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='Dama' AND (species='vallonetensis' OR species='vallonetensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megaloceros' AND (junior_species='savini' OR junior_species='savinii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megaloceros' AND (species='savini' OR species='savinii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megaloceros' AND (species='savini' OR species='savinii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megaloceros' AND (junior_species='savini' OR junior_species='savinii')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='Megaloceros' AND (species='savini' OR species='savinii') 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='Bovini' 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='Bovini' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bovini' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bovini' 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='Bovini' AND (species='indet.' OR species='indet.') 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 * FROM register WHERE sample_no=4286 The Ecological Register: Barranc de la Boella (El Forn 2)
Barranc de la Boella (El Forn 2)
Basic information
Sample name: Barranc de la Boella (El Forn 2)

Sample aka: BB (EF2)

Reference: A. Pineda, P. Saladie, R. Huguet, I. Caceres, A. Rosas, A. Estalrrich, A. Garcia-Tabernero, and J. Vallverdu. 2017. Changing competition dynamics among predators at the late Early Pleistocene site Barranc de la Boella (Tarragona, Spain). Palaeogeography, Palaeoclimatology, Palaeoecology 477:10-26 [ER 3899]
Geography
Country: Spain

State: Catalonia


Coordinate: 41.136051° N, 1.169809° E
Coordinate basis: estimated from map

Time interval: Early Pleistocene

Section: Unit II

Unit number: 2

Unit order: above to below

Max Ma: 0.96

Min Ma: 0.781

Age basis: paleomag

Geography comments: Barranc de la Boella is located 6 km from the Mediterranean coast in a ravine in the town of la Canonja (Tarragona)

EF2 is located at the top of Unit II of El Forn, below EF1 and above EF3

Unit II was dated using palaeomagnetism and cosmogenic nuclides dates

•
Environment
Lithology: siliciclastic (mixed)

Taphonomic context: fluvial deposit

Archaeology: stone tools

Habitat comments: Barranc de la Boella formed in a "fluvio-deltaic sedimentary environment"

The sites are located in "fluvial and debris flow" deposits

Unit II contains "poorly stratified sand and gravel"

15.8% of EF2 remains are abraded (mostly stage 1), indicating limited exposure to low-intensity water flows

High levels of weathering (52.6%) are seen in EF2, mostly associated with dry fractures (75.5%)

Stage 1 weathering was predominant in EF2 indicating short exposure and low degree of destruction

Lithic artifacts were found at EF2 indicating some level of hominin presence

Carnivore tooth marks are present on 2.3% of EF2 remains

Methods
Life forms: ungulates,birds

Sampling methods: quarry

Sample size: 42 specimens

Sampling comments: 171 faunal remains were identified at EF2

Counts excluded:
Cervidae indet - Medium/small sized - 5

Metadata
Sample number: 4286

Contributor: Jack Nesbitt

Enterer: Jack Nesbitt

Created: 2023-05-30 15:08:58

Modified: 2023-05-31 00:37:38

Abundance distribution
9 species
4 singletons
total count 42
extrapolated richness: 19.8
Fisher's α: 3.514
geometric series k: 0.7018
Hurlbert's PIE: 0.7607
Shannon's H: 1.7405
Good's u: 0.9048
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Mammuthus meridionalis1
Hippopotamus antiquus5
Stephanorhinus hundsheimensis3
Cervus elaphus6104 kg
Dama cf. vallonetensis7
Megaloceros savini1
Equus sp.17
Bovini indet.1
Aves indet.1