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=2671 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2671SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2434SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2671 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apocricetus' AND (junior_species='barrierei' OR junior_species='barriereii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apocricetus' AND (species='barrierei' OR species='barriereii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apocricetus' AND (species='barrierei' OR species='barriereii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apocricetus' AND (junior_species='barrierei' OR junior_species='barriereii')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='Apocricetus' AND (species='barrierei' OR species='barriereii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calomyscus' 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='Calomyscus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calomyscus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calomyscus' 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='Calomyscus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myocricetodon' 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='Myocricetodon' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myocricetodon' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myocricetodon' 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='Myocricetodon' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Promimomys' AND (junior_species='insuliferus' OR junior_species='insuliferus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Promimomys' AND (species='insuliferus' OR species='insuliferus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Promimomys' AND (species='insuliferus' OR species='insuliferus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Promimomys' AND (junior_species='insuliferus' OR junior_species='insuliferus')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='Promimomys' AND (species='insuliferus' OR species='insuliferus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Occitanomys' AND (junior_species='montheleni' OR junior_species='monthelenii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Occitanomys' AND (species='montheleni' OR species='monthelenii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Occitanomys' AND (species='montheleni' OR species='monthelenii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Occitanomys' AND (junior_species='montheleni' OR junior_species='monthelenii')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='Occitanomys' AND (species='montheleni' OR species='monthelenii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paraethomys' AND (junior_species='jaegeri' OR junior_species='jaegerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paraethomys' AND (species='jaegeri' OR species='jaegerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paraethomys' AND (species='jaegeri' OR species='jaegerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paraethomys' AND (junior_species='jaegeri' OR junior_species='jaegerii')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='Paraethomys' AND (species='jaegeri' OR species='jaegerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apodemus' AND (junior_species='gudrunae' OR junior_species='gudrunae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apodemus' AND (species='gudrunae' OR species='gudrunae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apodemus' AND (species='gudrunae' OR species='gudrunae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apodemus' AND (junior_species='gudrunae' OR junior_species='gudrunae')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='Apodemus' AND (species='gudrunae' OR species='gudrunae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apodemus' AND (junior_species='jeanteti' OR junior_species='jeantetii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apodemus' AND (species='jeanteti' OR species='jeantetii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apodemus' AND (species='jeanteti' OR species='jeantetii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apodemus' AND (junior_species='jeanteti' OR junior_species='jeantetii')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='Apodemus' AND (species='jeanteti' OR species='jeantetii') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2671 The Ecological Register: Font Estramar
Font Estramar
Basic information
Sample name: Font Estramar

Reference: J.-P. Aguilar, J. Michaux, B. Bachelet, M. Calvet, and J.-P. Faillat. 1991. Les nouvelles faunes de rongeurs proches de la limite Mio-Pliocene en Roussillon. Implications biostratigraphiques et biogeographiques. Palaeovertebrata 20(4):147-174 [ER 2434]
Geography
Country: France


Coordinate: 42° 52' N, 2° 58' E
Coordinate basis: based on nearby landmark

Time interval: Early Pliocene

Zone: MN14

Age basis: zone

Geography comments: coordinate based on Font Estramar
"Pliocène inferieur" and shown in Table 2 as approximately 4.5 Ma (probably MN14)

•
Environment
Substrate: ground surface

Habitat comments: "karstique"

Methods
Life forms: rodents

Sample size: 99 specimens

Years: 1989

Sampling comments: no discussion of collecting methods or other taxa

Metadata
Sample number: 2671

Contributor: John Alroy

Enterer: John Alroy

Created: 2017-03-05 13:34:34

Modified: 2017-03-05 02:34:34

Abundance distribution
8 species
3 singletons
total count 99
extrapolated richness: 14.6
Fisher's α: 2.053
geometric series k: 0.5752
Hurlbert's PIE: 0.6725
Shannon's H: 1.3948
Good's u: 0.9697
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Apocricetus barrierei26
"Cricetus barrierei"
Calomyscus sp.1
Myocricetodon sp. 21
Promimomys cf. insuliferus3
"quelques fragment" (presumably at least 3)
Occitanomys cf. montheleni8
Paraethomys cf. jaegeri11
Apodemus cf. gudrunae1
Apodemus jeanteti48