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=4287 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=4287SELECT 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=4287 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='Leporidae' 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='Leporidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leporidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leporidae' 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='Leporidae' 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=4287 The Ecological Register: Barranc de la Boella (El Forn 3)
Barranc de la Boella (El Forn 3)
Basic information
Sample name: Barranc de la Boella (El Forn 3)

Sample aka: BB (EF3)

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: 3

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)

EF3 is located in Unit II of El Forn, below EF2 and above EF4

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"

EF3 shows the lowest levels of abrasion (9.8%) out of the BB sites, mostly stage 1 indicating limited exposure to low-intensity water flows

EF3 shows the highest levels of weathering (72.4%) out of the BB sites, mostly associated with dry fractures (88%)

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

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

Carnivore tooth marks were present on 9% of the remains at EF3

Methods
Life forms: ungulates,other small mammals,birds

Sampling methods: quarry

Sample size: 42 specimens

Sampling comments: 134 faunal remains were identified at EF3

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

Metadata
Sample number: 4287

Contributor: Jack Nesbitt

Enterer: Jack Nesbitt

Created: 2023-05-31 10:31:59

Modified: 2023-05-31 00:51:43

Abundance distribution
10 species
6 singletons
total count 42
extrapolated richness: 29.9
Fisher's α: 4.152
geometric series k: 0.7299
Hurlbert's PIE: 0.7445
Shannon's H: 1.7082
Good's u: 0.8571
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Mammuthus meridionalis1
Hippopotamus antiquus6
Stephanorhinus hundsheimensis3
Cervus elaphus17104 kg
Dama cf. vallonetensis1
Megaloceros savini1
Equus sp.10
Bovini indet.1
Leporidae indet.1
Aves indet.1