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=4271 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=4271SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3891SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=4271 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='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='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='Pseudodama' AND (junior_species='nestii' OR junior_species='nesti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudodama' AND (species='nestii' OR species='nesti') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudodama' AND (species='nestii' OR species='nesti')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudodama' AND (junior_species='nestii' OR junior_species='nesti')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='nestii' OR species='nesti') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Praemegaceros' AND (junior_species='verticornis' OR junior_species='verticornis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Praemegaceros' AND (species='verticornis' OR species='verticornis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Praemegaceros' AND (species='verticornis' OR species='verticornis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Praemegaceros' AND (junior_species='verticornis' OR junior_species='verticornis')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='verticornis' OR species='verticornis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptobos' 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='Leptobos' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptobos' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptobos' 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='Leptobos' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ursus' 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='Ursus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ursus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ursus' 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='Ursus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='arnensis' OR junior_species='arnensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canis' AND (species='arnensis' OR species='arnensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canis' AND (species='arnensis' OR species='arnensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='arnensis' OR junior_species='arnensis')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='Canis' AND (species='arnensis' OR species='arnensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='falconeri' OR junior_species='falconerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canis' AND (species='falconeri' OR species='falconerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canis' AND (species='falconeri' OR species='falconerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='falconeri' OR junior_species='falconerii')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='Canis' AND (species='falconeri' OR species='falconerii') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=4271 The Ecological Register: Collecurti bonebed
Collecurti bonebed
Basic information
Sample name: Collecurti bonebed

Reference: P. P. A. Mazza and D. Ventra. 2011. Pleistocene debris-flow deposition of the hippopotamus-bearing Collecurti bonebed (Macerata, Central Italy): Taphonomic and paleoenvironmental analysis. Palaeogeography, Palaeoclimatology, Palaeoecology 310:296-314 [ER 3891]
Geography
Country: Italy

State: Macerata


Coordinate: 42.963333° N, 12.922222° E
Coordinate basis: stated in text

Formation: Colfiorito basin

Time interval: Early Pleistocene

Unit number: 3

Unit order: above to below

Ma: 1.05

Age basis: paleomag

Geography comments: Located near Voltellina roughly 56 km SW of Macerata

"The multi-individual bonebed of Collecurti has been dated at around 1 Ma by biochronology and paleomagnetism"

"Paleomagnetic data (Coltorti et al., 1998) show that the fossiliferous bed occurs within the base of a 5 m stratigraphic interval attributed to the normal polarity Jaramillo subchron (C1r.In), and its age is therefore approximately 1.05 Ma"

Environment
Lithology: siliciclastic (mixed)

Taphonomic context: fluvial deposit

Habitat comments: "An interval approximately 40 m thick, dominated by massive to horizontally bedded clay and silt, comprising peat layers and a few organic-rich and fossiliferous interbeds (including the Collecurti bonebed)."

The fossiliferous unit 3 is composed of sandy clay containing carbonate and chert clasts

Very sparse ("virtually absent") evidence of weathering at the site, as well as no evidence of carnivore ravaging or trampling.

"All taxa are unsorted"

The taphonomic evidence suggests the elephant/cervid remains and the hippopotamus remains originate from two different taphonomic histories and were mixed by a debris flow

The debris flow seems to have buried the hippopotamus carcasses while they were in an "advanced state of decomposition" while adding the bones from uphill (likely "fluvially reworked")

The hippopotamus remains lay long enough to be skeletonized and disarticulated without being exposed to weathering agents or scavengers. They were therefore likely decomposing in a "quiet waterbody"

Methods
Life forms: carnivores,ungulates

Sampling methods: quarry

Sample size: 441 specimens

Sampling comments: The excavation site is located at "shallow depth" below crop terrain

Specimen orientation was recorded in the field

Taxonomy, anatomy, quantification, relative amounts, age spectrum, body size, articulation, selection, and bone modification were all obtained after preparation

There were 496 specimens acquired from the side, of which 441 were identified anatomically and taxonomically, 2 were identified only anatomically, with 53 being unidentified

A total of 9 species and 8 genera were identified

Metadata
Sample number: 4271

Contributor: Jack Nesbitt

Enterer: Jack Nesbitt

Created: 2023-05-17 15:07:18

Modified: 2023-05-17 05:07:18

Abundance distribution
9 species
3 singletons
total count 441
extrapolated richness: 16.1
Fisher's α: 1.601
geometric series k: 0.4726
Hurlbert's PIE: 0.1655
Shannon's H: 0.4506
Good's u: 0.9932
Each square represents a species. Square sizes are proportional to counts.
Register