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=4296 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=4296SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3907SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=4296 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ursus' AND (junior_species='dolinensis' OR junior_species='dolinensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ursus' AND (species='dolinensis' OR species='dolinensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ursus' AND (species='dolinensis' OR species='dolinensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ursus' AND (junior_species='dolinensis' OR junior_species='dolinensis')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='Ursus' AND (species='dolinensis' OR species='dolinensis') 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='Hippopotamus' 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='Hippopotamus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hippopotamus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hippopotamus' 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='Hippopotamus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sus' AND (junior_species='strozzii' OR junior_species='strozzi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sus' AND (species='strozzii' OR species='strozzi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sus' AND (species='strozzii' OR species='strozzi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sus' AND (junior_species='strozzii' OR junior_species='strozzi')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='Sus' AND (species='strozzii' OR species='strozzi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudodama' AND (junior_species='farnetensis' OR junior_species='farnetensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudodama' AND (species='farnetensis' OR species='farnetensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudodama' AND (species='farnetensis' OR species='farnetensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudodama' AND (junior_species='farnetensis' OR junior_species='farnetensis')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='Pseudodama' AND (species='farnetensis' OR species='farnetensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Praemegaceros' 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='Praemegaceros' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Praemegaceros' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Praemegaceros' 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='Praemegaceros' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bison' 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='Bison' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bison' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bison' 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='Bison' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=4296 The Ecological Register: Frantoio (Arda River)
Frantoio (Arda River)
Basic information
Sample name: Frantoio (Arda River)

Reference: F. Bona and B. Sala. 2016. Villafranchian-Galerian mammal faunas transition in South-Western Europe. The case of the late Early Pleistocene mammal fauna of the Frantoio locality, Arda River (Castell Arquato, Piacenza, Northern Italy). Geobios 49:329-347 [ER 3907]
Geography
Country: Italy

State: Emilia Romagna


Coordinate: 44.854424° N, 9.874545° E
Coordinate basis: based on nearby landmark

Formation: Castell'Arquato

Time interval: Early Pleistocene

Ma: 0.99

Age basis: paleomag

Geography comments: The Frantoio locality is situated in the Arda River site near Castell'Arquato, Emilia Romagna

Specific coordinates or maps are not provided therefore given coordinates are based on the nearby town of Castell'Arquato

Magnetostratigraphy has dated the fossiliferous level to the uppermost Jaramillo subchron (0.99 Ma)

Environment
Lithology: claystone

Taphonomic context: fluvial deposit

Habitat comments: The mammalian remains were collected from a continental clay layer

The faunal composition indicates a palaeoenvironment consisting of inundated woodlands on an alluvial plain with patches of grassland

It can be inferred that the remains were transported by the river and deposited in a lagoon/marsh where decomposition occured without further transport

Methods
Life forms: carnivores,ungulates

Sampling methods: surface

Sample size: 41 specimens

Sampling comments: 61 remains were collected between 2006-2015 consisting of 7 taxa

At the time of publishing no field excavations were carried out, with remains being collected immediately after flood episodes

Metadata
Sample number: 4296

Contributor: Jack Nesbitt

Enterer: Jack Nesbitt

Created: 2023-06-09 13:27:35

Modified: 2023-06-09 03:27:35

Abundance distribution
7 species
0 singletons
total count 41
extrapolated richness: 9.9
Fisher's α: 2.427
geometric series k: 0.7230
Hurlbert's PIE: 0.7726
Shannon's H: 1.6819
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.
Register