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=3347 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3347SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3074SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3347 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eremotherium' AND (junior_species='laurillardi' OR junior_species='laurillardii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eremotherium' AND (species='laurillardi' OR species='laurillardii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eremotherium' AND (species='laurillardi' OR species='laurillardii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eremotherium' AND (junior_species='laurillardi' OR junior_species='laurillardii')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='Eremotherium' AND (species='laurillardi' OR species='laurillardii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catonyx' 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='Catonyx' AND (species='cuvieri' OR species='cuvierii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catonyx' AND (species='cuvieri' OR species='cuvierii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catonyx' 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='Catonyx' AND (species='cuvieri' OR species='cuvierii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glossotherium' 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='Glossotherium' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glossotherium' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glossotherium' 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='Glossotherium' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Holmesina' AND (junior_species='paulacoutoi' OR junior_species='paulacoutoii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Holmesina' AND (species='paulacoutoi' OR species='paulacoutoii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Holmesina' AND (species='paulacoutoi' OR species='paulacoutoii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Holmesina' AND (junior_species='paulacoutoi' OR junior_species='paulacoutoii')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='Holmesina' AND (species='paulacoutoi' OR species='paulacoutoii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pampatherium' AND (junior_species='humboldtii' OR junior_species='humboldti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pampatherium' AND (species='humboldtii' OR species='humboldti') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pampatherium' AND (species='humboldtii' OR species='humboldti')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pampatherium' AND (junior_species='humboldtii' OR junior_species='humboldti')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='Pampatherium' AND (species='humboldtii' OR species='humboldti') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notiomastodon' AND (junior_species='platensis' OR junior_species='platensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Notiomastodon' AND (species='platensis' OR species='platensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Notiomastodon' AND (species='platensis' OR species='platensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notiomastodon' AND (junior_species='platensis' OR junior_species='platensis')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='Notiomastodon' AND (species='platensis' OR species='platensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Toxodon' AND (junior_species='platensis' OR junior_species='platensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Toxodon' AND (species='platensis' OR species='platensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Toxodon' AND (species='platensis' OR species='platensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Toxodon' AND (junior_species='platensis' OR junior_species='platensis')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='Toxodon' AND (species='platensis' OR species='platensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xenorhinotherium' AND (junior_species='bahiense' OR junior_species='bahiense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xenorhinotherium' AND (species='bahiense' OR species='bahiense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xenorhinotherium' AND (species='bahiense' OR species='bahiense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xenorhinotherium' AND (junior_species='bahiense' OR junior_species='bahiense')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='Xenorhinotherium' AND (species='bahiense' OR species='bahiense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Smilodon' AND (junior_species='populator' OR junior_species='populator')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Smilodon' AND (species='populator' OR species='populator') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Smilodon' AND (species='populator' OR species='populator')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Smilodon' AND (junior_species='populator' OR junior_species='populator')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='Smilodon' AND (species='populator' OR species='populator') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaeolama' AND (junior_species='major' OR junior_species='major')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Palaeolama' AND (species='major' OR species='major') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Palaeolama' AND (species='major' OR species='major')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaeolama' AND (junior_species='major' OR junior_species='major')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='Palaeolama' AND (species='major' OR species='major') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mazama' 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='Mazama' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mazama' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mazama' 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='Mazama' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tayassu' AND (junior_species='pecari' OR junior_species='pecarii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tayassu' AND (species='pecari' OR species='pecarii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tayassu' AND (junior_species='pecari' OR junior_species='pecarii')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='Tayassu' AND (species='pecari' OR species='pecarii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='neogeus' OR junior_species='neogeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Equus' AND (species='neogeus' OR species='neogeus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Equus' AND (species='neogeus' OR species='neogeus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='neogeus' OR junior_species='neogeus')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='neogeus' OR species='neogeus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hippidion' AND (junior_species='principale' OR junior_species='principale')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hippidion' AND (species='principale' OR species='principale') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hippidion' AND (species='principale' OR species='principale')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hippidion' AND (junior_species='principale' OR junior_species='principale')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='Hippidion' AND (species='principale' OR species='principale') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3347 The Ecological Register: Jirau Paleontological Site
Jirau Paleontological Site
Basic information
Sample name: Jirau Paleontological Site

Reference: H. I. de Araújo-Júnior, K. O. Porpino, C. L. Ximenes, and L. P. Bergqvist. 2013. Unveiling the taphonomy of elusive natural tank deposits: A study case in the Pleistocene of northeastern Brazil. Palaeogeography, Palaeoclimatology, Palaeoecology 378:52-74 [ER 3074]
Geography
Country: Brazil

State: Cearâ


Coordinate: 3° 21' 23" S, 39° 42' 20" W
Coordinate basis: stated in text

Time interval: Late Pleistocene

Geography comments: "35 km northwest of Itapipoca City"
age assignment is based on faunal correlation

Environment
Substrate: ground surface

Lithology: conglomerate

Taphonomic context: lake deposit

Habitat comments: "an intermediary layer (about 1 m thick), characterized by debris flow sedimentation, consisting of conglomerate supported by feldspatic clayey-sandy matrix, with fossils, rounded quartz pebbles and rock fragments from tank walls"

Methods
Life forms: carnivores,ungulates,other large mammals

Sampling methods: quarry

Sample size: 1322 specimens

Years: 2003 - 2008

Sampling comments: "horns, teeth, and xenarthran osteoderms" were excluded from the counts, so five xenarthrans present in the fauna are not included in the inventory

Metadata
Sample number: 3347

Contributor: John Alroy

Enterer: John Alroy

Created: 2019-08-25 17:21:09

Modified: 2019-08-25 10:51:07

Abundance distribution
14 species
3 singletons
total count 1322
extrapolated richness: 20.6
Fisher's α: 2.185
geometric series k: 0.5818
Hurlbert's PIE: 0.2477
Shannon's H: 0.6477
Good's u: 0.9977
Each square represents a species. Square sizes are proportional to counts.
Register