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=2560 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2560SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2381SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2560 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eucricetodon' AND (junior_species='collatus' OR junior_species='collatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eucricetodon' AND (species='collatus' OR species='collatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eucricetodon' AND (species='collatus' OR species='collatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eucricetodon' AND (junior_species='collatus' OR junior_species='collatus')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='Eucricetodon' AND (species='collatus' OR species='collatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelomyarion' AND (junior_species='vireti' OR junior_species='viretii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelomyarion' AND (species='vireti' OR species='viretii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelomyarion' AND (species='vireti' OR species='viretii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelomyarion' AND (junior_species='vireti' OR junior_species='viretii')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='Adelomyarion' AND (species='vireti' OR species='viretii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melissiodon' AND (junior_species='quercyi' OR junior_species='quercyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melissiodon' AND (species='quercyi' OR species='quercyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melissiodon' AND (species='quercyi' OR species='quercyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melissiodon' AND (junior_species='quercyi' OR junior_species='quercyii')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='Melissiodon' AND (species='quercyi' OR species='quercyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhodanomys' AND (junior_species='schlosseri' OR junior_species='schlosserii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhodanomys' AND (species='schlosseri' OR species='schlosserii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhodanomys' AND (species='schlosseri' OR species='schlosserii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhodanomys' AND (junior_species='schlosseri' OR junior_species='schlosserii')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='Rhodanomys' AND (species='schlosseri' OR species='schlosserii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudotheridomys' AND (junior_species='parvulus' OR junior_species='parvulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudotheridomys' AND (species='parvulus' OR species='parvulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudotheridomys' AND (species='parvulus' OR species='parvulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudotheridomys' AND (junior_species='parvulus' OR junior_species='parvulus')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='Pseudotheridomys' AND (species='parvulus' OR species='parvulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plesiosminthus' AND (junior_species='schaubi' OR junior_species='schaubii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Plesiosminthus' AND (species='schaubi' OR species='schaubii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plesiosminthus' AND (species='schaubi' OR species='schaubii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plesiosminthus' AND (junior_species='schaubi' OR junior_species='schaubii')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='Plesiosminthus' AND (species='schaubi' OR species='schaubii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gliravus' AND (junior_species='bruijni' OR junior_species='bruijnii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gliravus' AND (species='bruijni' OR species='bruijnii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gliravus' AND (species='bruijni' OR species='bruijnii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gliravus' AND (junior_species='bruijni' OR junior_species='bruijnii')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='Gliravus' AND (species='bruijni' OR species='bruijnii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peridyromys' AND (junior_species='murinus' OR junior_species='murinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Peridyromys' AND (species='murinus' OR species='murinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Peridyromys' AND (species='murinus' OR species='murinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peridyromys' AND (junior_species='murinus' OR junior_species='murinus')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='Peridyromys' AND (species='murinus' OR species='murinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bransatoglis' AND (junior_species='concavidens' OR junior_species='concavidens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bransatoglis' AND (species='concavidens' OR species='concavidens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bransatoglis' AND (species='concavidens' OR species='concavidens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bransatoglis' AND (junior_species='concavidens' OR junior_species='concavidens')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='Bransatoglis' AND (species='concavidens' OR species='concavidens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glirudinus' AND (junior_species='glirulus' OR junior_species='glirulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glirudinus' AND (species='glirulus' OR species='glirulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glirudinus' AND (species='glirulus' OR species='glirulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glirudinus' AND (junior_species='glirulus' OR junior_species='glirulus')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='Glirudinus' AND (species='glirulus' OR species='glirulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gliridae' 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='Gliridae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gliridae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gliridae' 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='Gliridae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteroxerus' AND (junior_species='paulhiacensis' OR junior_species='paulhiacensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heteroxerus' AND (species='paulhiacensis' OR species='paulhiacensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heteroxerus' AND (species='paulhiacensis' OR species='paulhiacensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteroxerus' AND (junior_species='paulhiacensis' OR junior_species='paulhiacensis')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='Heteroxerus' AND (species='paulhiacensis' OR species='paulhiacensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteroxerus' AND (junior_species='lavocati' OR junior_species='lavocatii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heteroxerus' AND (species='lavocati' OR species='lavocatii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heteroxerus' AND (species='lavocati' OR species='lavocatii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteroxerus' AND (junior_species='lavocati' OR junior_species='lavocatii')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='Heteroxerus' AND (species='lavocati' OR species='lavocatii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sciurus' 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='Sciurus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sciurus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sciurus' 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='Sciurus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Issiodoromys' AND (junior_species='pseudanaema' OR junior_species='pseudanaema')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Issiodoromys' AND (species='pseudanaema' OR species='pseudanaema') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Issiodoromys' AND (species='pseudanaema' OR species='pseudanaema')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Issiodoromys' AND (junior_species='pseudanaema' OR junior_species='pseudanaema')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='Issiodoromys' AND (species='pseudanaema' OR species='pseudanaema') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archaeomys' 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='Archaeomys' AND (species='laurillardi' OR species='laurillardii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Archaeomys' AND (species='laurillardi' OR species='laurillardii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archaeomys' 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='Archaeomys' AND (species='laurillardi' OR species='laurillardii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhizospalax' AND (junior_species='poirrieri' OR junior_species='poirrierii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhizospalax' AND (species='poirrieri' OR species='poirrierii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhizospalax' AND (species='poirrieri' OR species='poirrierii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhizospalax' AND (junior_species='poirrieri' OR junior_species='poirrierii')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='Rhizospalax' AND (species='poirrieri' OR species='poirrierii') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2560 The Ecological Register: Dieupentale
Dieupentale
Basic information
Sample name: Dieupentale

Reference: S. Baudelot and P. Olivier. 1978. Les rongeurs (Mammalia, Rodentia) de l'Oligocène terminal de Dieupentale (sud-ouest de la France: Tarn et Garonne). Geobios 11(1):5-19 [ER 2381]
Geography
Country: France


Coordinate: 43° 52' N, 1° 16' E
Coordinate basis: based on nearby landmark

Time interval: Late Oligocene

Zone: MP30

Ma: 23.5

Geography comments: "une trentaine de kilomètres au NNW de Toulouse dans une carrière exploitée pour une briqueterie" (coordinate based on Dieupentale)
"appartenant au niveau de Coderet" (i.e., MP30 or roughly 23.5 Ma)

Environment
Substrate: ground surface

Lithology: sandstone

Habitat comments: most or all of the described fossils are from "un niveau gréseaux gris-vert, á petits galets calcaires, de quelques cm á 50 cm d'epaisseur" and about 1.5 m higher "un niveau sableux de 0,30 m á 0,50 m á petits galets calcaires et d'argile rougeãtre"; most of the microfauna is from the latter level

Methods
Life forms: rodents

Sample size: 674 specimens

Sampling comments: insectivores, bats, lagomorphs, carnivores, and ungulates are present but not described
collection methods are unclear

Metadata
Sample number: 2560

Contributor: John Alroy

Enterer: John Alroy

Created: 2017-02-16 12:51:34

Modified: 2017-02-17 02:55:00

Abundance distribution
17 species
1 singleton
total count 674
extrapolated richness: 22.3
Fisher's α: 3.169
geometric series k: 0.7172
Hurlbert's PIE: 0.8025
Shannon's H: 1.9066
Good's u: 0.9985
Each square represents a species. Square sizes are proportional to counts.
Register