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=2653 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2653SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2425SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2653 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaeosciurus' AND (junior_species='goti' OR junior_species='gotii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Palaeosciurus' AND (species='goti' OR species='gotii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Palaeosciurus' AND (species='goti' OR species='gotii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaeosciurus' AND (junior_species='goti' OR junior_species='gotii')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='Palaeosciurus' AND (species='goti' OR species='gotii') 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='Microdyromys' AND (junior_species='legidensis' OR junior_species='legidensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microdyromys' AND (species='legidensis' OR species='legidensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microdyromys' AND (species='legidensis' OR species='legidensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microdyromys' AND (junior_species='legidensis' OR junior_species='legidensis')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='Microdyromys' AND (species='legidensis' OR species='legidensis') 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='Eomys' AND (junior_species='reductus' OR junior_species='reductus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eomys' AND (species='reductus' OR species='reductus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eomys' AND (species='reductus' OR species='reductus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eomys' AND (junior_species='reductus' OR junior_species='reductus')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='Eomys' AND (species='reductus' OR species='reductus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eomys' AND (junior_species='huerzeleri' OR junior_species='huerzelerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eomys' AND (species='huerzeleri' OR species='huerzelerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eomys' AND (species='huerzeleri' OR species='huerzelerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eomys' AND (junior_species='huerzeleri' OR junior_species='huerzelerii')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='Eomys' AND (species='huerzeleri' OR species='huerzelerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eomyodon' AND (junior_species='volkeri' OR junior_species='volkerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eomyodon' AND (species='volkeri' OR species='volkerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eomyodon' AND (species='volkeri' OR species='volkerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eomyodon' AND (junior_species='volkeri' OR junior_species='volkerii')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='Eomyodon' AND (species='volkeri' OR species='volkerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eomyodon' AND (junior_species='pusillus' OR junior_species='pusillus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eomyodon' AND (species='pusillus' OR species='pusillus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eomyodon' AND (species='pusillus' OR species='pusillus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eomyodon' AND (junior_species='pusillus' OR junior_species='pusillus')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='Eomyodon' AND (species='pusillus' OR species='pusillus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eucricetodon' AND (junior_species='dubius' OR junior_species='dubius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eucricetodon' AND (species='dubius' OR species='dubius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eucricetodon' AND (species='dubius' OR species='dubius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eucricetodon' AND (junior_species='dubius' OR junior_species='dubius')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='dubius' OR species='dubius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eucricetodon' AND (junior_species='liber' OR junior_species='liber')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eucricetodon' AND (species='liber' OR species='liber') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eucricetodon' AND (species='liber' OR species='liber')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eucricetodon' AND (junior_species='liber' OR junior_species='liber')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='liber' OR species='liber') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudocricetodon' AND (junior_species='montalbanensis' OR junior_species='montalbanensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudocricetodon' AND (species='montalbanensis' OR species='montalbanensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudocricetodon' AND (species='montalbanensis' OR species='montalbanensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudocricetodon' AND (junior_species='montalbanensis' OR junior_species='montalbanensis')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='Pseudocricetodon' AND (species='montalbanensis' OR species='montalbanensis') 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='Plesiosminthus' AND (junior_species='conjunctus' OR junior_species='conjunctus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Plesiosminthus' AND (species='conjunctus' OR species='conjunctus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plesiosminthus' AND (species='conjunctus' OR species='conjunctus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plesiosminthus' AND (junior_species='conjunctus' OR junior_species='conjunctus')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='conjunctus' OR species='conjunctus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2653 The Ecological Register: Herrlingen 9
Herrlingen 9
Basic information
Sample name: Herrlingen 9

Reference: R. Ziegler. 1994. Rodentia (Mammalia) aus den oberoligozänen Spaltenfüllungen Herrlingen 8 und Herrlingen 9 be Ulm (Baden-Württemberg). Stuttgarter Beiträge zur Naturkunde. Serie B (Geologie und Paläontologie) 196:1-81 [ER 2425]
Geography
Country: Germany

State: Baden-Württemberg


Coordinate: 48° 25' N, 9° 54' E
Coordinate basis: based on nearby landmark

Time interval: Late Oligocene

Zone: MP29

Age basis: zone

Geography comments: "in der Mitte der vierten Abbausohle Reste der Füllung" of the "Herrlinger Wiessjura-Steinbruch, ca. 8 km W Ulm... 100 m N von Herrlingen 8" (coordinate based on Herrlingen)

Environment
Substrate: ground surface

Lithology: claystone

Habitat comments: "eine Spalte mit grünlichgrauem, fossilführendem Spaltenlehm"

Methods
Life forms: rodents

Sampling methods: screenwash

Sample size: 746 specimens

Years: 1991

Sampling comments: "geschlåmmte and ausgelesene Material" (meaning screenwashed sediment)
additional taxa other than Propalaeochoerus gergovianus (count not given) are not discussed; other small mammals are presumed to be present based on the composition of the other Herrlingen samples

Metadata
Sample number: 2653

Contributor: John Alroy

Enterer: John Alroy

Created: 2017-02-25 09:48:51

Modified: 2017-02-24 22:48:51

Abundance distribution
14 species
1 singleton
total count 746
extrapolated richness: 17.2
Fisher's α: 2.446
geometric series k: 0.6418
Hurlbert's PIE: 0.7501
Shannon's H: 1.7599
Good's u: 0.9987
Each square represents a species. Square sizes are proportional to counts.
Register