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=2587 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2587SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2393SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2587 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sciuroides' AND (junior_species='siderolithicus' OR junior_species='siderolithicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sciuroides' AND (species='siderolithicus' OR species='siderolithicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sciuroides' AND (species='siderolithicus' OR species='siderolithicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sciuroides' AND (junior_species='siderolithicus' OR junior_species='siderolithicus')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='Sciuroides' AND (species='siderolithicus' OR species='siderolithicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Suevosciurus' 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='Suevosciurus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Suevosciurus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Suevosciurus' 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='Suevosciurus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protadelomys' 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='Protadelomys' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protadelomys' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protadelomys' 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='Protadelomys' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Remys' 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='Remys' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Remys' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Remys' 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='Remys' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paradelomys' 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='Paradelomys' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paradelomys' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paradelomys' 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='Paradelomys' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elfomys' AND (junior_species='engesseri' OR junior_species='engesserii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elfomys' AND (species='engesseri' OR species='engesserii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elfomys' AND (species='engesseri' OR species='engesserii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elfomys' AND (junior_species='engesseri' OR junior_species='engesserii')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='Elfomys' AND (species='engesseri' OR species='engesserii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudoltinomys' AND (junior_species='crebrum' OR junior_species='crebrum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudoltinomys' AND (species='crebrum' OR species='crebrum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudoltinomys' AND (species='crebrum' OR species='crebrum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudoltinomys' AND (junior_species='crebrum' OR junior_species='crebrum')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='Pseudoltinomys' AND (species='crebrum' OR species='crebrum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Estellomys' AND (junior_species='ibericus' OR junior_species='ibericus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Estellomys' AND (species='ibericus' OR species='ibericus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Estellomys' AND (species='ibericus' OR species='ibericus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Estellomys' AND (junior_species='ibericus' OR junior_species='ibericus')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='Estellomys' AND (species='ibericus' OR species='ibericus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Patriotheridomys' 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='Patriotheridomys' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Patriotheridomys' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Patriotheridomys' 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='Patriotheridomys' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theridomyinae' 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='Theridomyinae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Theridomyinae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theridomyinae' 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='Theridomyinae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2587
Reference:J. J. Hooker and M. Weidmann. 2007. A diverse rodent fauna from the middle Bartonian (Eocene) of Les Alleveys, Switzerland: snapshot of the early theridomyid radiation. Swiss Journal of Geosciences100:469-493 [ER 2393]
Geography
Country: Switzerland
Coordinate:46° 39' N, 6° 32' E
Coordinate basis: based on nearby landmark
Time interval: Middle Eocene
Zone: MP15/16
Ma: 38
Geography comments: "within the commune of La Sarraz... at the western extremity of Mormont" (coordinate based on Le Mormont)
"entirely middle Bartonian... slightly older than Robiac, the reference locality for MP16"; shown on a chart as in between MP15 and MP16 and roughly 38 Ma
•
Environment
Substrate: ground surface
Lithology: sandstone
Habitat comments: "red clay alternating with sandy layers with quartz and ferruginous pisoliths. It was from these coarse layers that almost all the fossils were collected"
Methods
Life forms: rodents
Sampling methods: screenwash
Sample size: 112 specimens
Sampling comments: "one of us (MW) extracted nearly 500 kg of sediment from the fissure (Fig. 1e), emptying it completely. After washing and sieving, this material yielded a total of about 700 teeth and innumerable bone fragments of mammals, rare reptile teeth and numerous teeth of marine fish (pycnodont bony fish and odontaspid sharks), the last reworked from the Cretaceous limestones"
numerous undescribed taxa are listed in Table 1
Metadata
Sample number: 2587
Contributor: John Alroy
Enterer: John Alroy
Created: 2017-02-17 21:35:00
Modified: 2023-09-08 12:17:20
Abundance distribution
10 species
2 singletons
total count 112
extrapolated richness: 16.0
Fisher's α: 2.656
geometric series k: 0.6637
Hurlbert's PIE: 0.7550
Shannon's H: 1.6673
Good's u: 0.9825
Each square represents a species. Square sizes are proportional to counts.