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=4319 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=4319SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3918SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=4319 ORDER BY register_no ASCSELECT 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 senior_genus genus,senior_species species FROM itis WHERE junior_genus='Testudinidae' 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='Testudinidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Testudinidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Testudinidae' 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='Testudinidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maioricalacerta' AND (junior_species='rafelinensis' OR junior_species='rafelinensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Maioricalacerta' AND (species='rafelinensis' OR species='rafelinensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Maioricalacerta' AND (species='rafelinensis' OR species='rafelinensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maioricalacerta' AND (junior_species='rafelinensis' OR junior_species='rafelinensis')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='Maioricalacerta' AND (species='rafelinensis' OR species='rafelinensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dopasia' 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='Dopasia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dopasia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dopasia' 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='Dopasia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colubrinae' 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='Colubrinae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colubrinae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colubrinae' 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='Colubrinae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vipera' AND (junior_species='natiensis' OR junior_species='natiensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vipera' AND (species='natiensis' OR species='natiensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vipera' AND (species='natiensis' OR species='natiensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vipera' AND (junior_species='natiensis' OR junior_species='natiensis')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='Vipera' AND (species='natiensis' OR species='natiensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nesiotites' AND (junior_species='rafelinensis' OR junior_species='rafelinensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nesiotites' AND (species='rafelinensis' OR species='rafelinensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nesiotites' AND (species='rafelinensis' OR species='rafelinensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nesiotites' AND (junior_species='rafelinensis' OR junior_species='rafelinensis')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='Nesiotites' AND (species='rafelinensis' OR species='rafelinensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tragomys' AND (junior_species='macpheei' OR junior_species='macpheeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tragomys' AND (species='macpheei' OR species='macpheeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tragomys' AND (species='macpheei' OR species='macpheeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tragomys' AND (junior_species='macpheei' OR junior_species='macpheeii')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='Tragomys' AND (species='macpheei' OR species='macpheeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cricetinae' 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='Cricetinae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cricetinae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cricetinae' 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='Cricetinae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypnomys' 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='Hypnomys' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypnomys' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypnomys' 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='Hypnomys' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypolagus' AND (junior_species='balearicus' OR junior_species='balearicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypolagus' AND (species='balearicus' OR species='balearicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypolagus' AND (species='balearicus' OR species='balearicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypolagus' AND (junior_species='balearicus' OR junior_species='balearicus')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='Hypolagus' AND (species='balearicus' OR species='balearicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotragus' AND (junior_species='palomboi' OR junior_species='palomboii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myotragus' AND (species='palomboi' OR species='palomboii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myotragus' AND (species='palomboi' OR species='palomboii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotragus' AND (junior_species='palomboi' OR junior_species='palomboii')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='Myotragus' AND (species='palomboi' OR species='palomboii') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=4319 The Ecological Register: Caló den Rafelino
Caló den Rafelino
Basic information
Sample name: Caló den Rafelino

Sample aka: CdR

Reference: P. Bover, J. Rofes, S. Bailon, J. Agustí, G. Cuenca-Bescós, E. Torres, and J. A. Alcover. 2014. Late Miocene/Early Pliocene vertebrate fauna from Mallorca (Balearic Islands, Western Mediterranean): an update. Integrative Zoology 9:183-196 [ER 3918]
Geography
Country: Spain

State: Balearic Islands


Coordinate: 39.556866° N, 3.369305° E
Coordinate basis: estimated from map

Time interval: Early Pliocene

Max Ma: 7.2

Min Ma: 3.6

Age basis: other

Geography comments: The CdR locality is situated on the eastern coast of Mallorca on the cliffs at the edge of the Caló den Rafelino

Faunal comparisons indicate an Early Pliocene chronology but "a Messinian chronology cannot be completely discarded

Environment
Lithology: breccia

Taphonomic context: cave

Habitat comments: "Red silt of karstic origin which are the floor sediment of a collapsed cave in the Upper Miocene limestone of the so-called Reef Complex"

"The bones obtained from this breccia were mainly broken, worn and eroded"

Methods
Life forms: rodents,ungulates,other small mammals,birds,lizards,snakes,turtles

Sampling methods: quarry

Sample size: 290 specimens

Sampling comments: Several fish teeth were recovered from CdR, as well as a single bird bone

Counts excluded:
Vipera sp. - 2

Metadata
Sample number: 4319

Contributor: Jack Nesbitt

Enterer: Jack Nesbitt

Created: 2023-06-29 13:15:41

Modified: 2023-06-29 03:44:07

Abundance distribution
12 species
4 singletons
total count 290
extrapolated richness: 22.3
Fisher's α: 2.525
geometric series k: 0.6178
Hurlbert's PIE: 0.4988
Shannon's H: 1.1470
Good's u: 0.9863
Each square represents a species. Square sizes are proportional to counts.
Register