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
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 Zoology9: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.