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=2524 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2524SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2354SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2524 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphiperatherium' AND (junior_species='frequens' OR junior_species='frequens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amphiperatherium' AND (species='frequens' OR species='frequens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amphiperatherium' AND (species='frequens' OR species='frequens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphiperatherium' AND (junior_species='frequens' OR junior_species='frequens')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='Amphiperatherium' AND (species='frequens' OR species='frequens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lantanotherium' AND (junior_species='sansaniense' OR junior_species='sansaniense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lantanotherium' AND (species='sansaniense' OR species='sansaniense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lantanotherium' AND (species='sansaniense' OR species='sansaniense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lantanotherium' AND (junior_species='sansaniense' OR junior_species='sansaniense')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='Lantanotherium' AND (species='sansaniense' OR species='sansaniense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Galerix' AND (junior_species='symeonidisi' OR junior_species='symeonidisii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Galerix' AND (species='symeonidisi' OR species='symeonidisii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Galerix' AND (species='symeonidisi' OR species='symeonidisii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Galerix' AND (junior_species='symeonidisi' OR junior_species='symeonidisii')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='Galerix' AND (species='symeonidisi' OR species='symeonidisii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dinosorex' AND (junior_species='zapfei' OR junior_species='zapfeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dinosorex' AND (species='zapfei' OR species='zapfeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dinosorex' AND (species='zapfei' OR species='zapfeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dinosorex' AND (junior_species='zapfei' OR junior_species='zapfeii')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='Dinosorex' AND (species='zapfei' OR species='zapfeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocidosoricinae' 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='Crocidosoricinae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crocidosoricinae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocidosoricinae' 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='Crocidosoricinae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mygalea' 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='Mygalea' AND (species='jaegeri' OR species='jaegerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mygalea' AND (species='jaegeri' OR species='jaegerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mygalea' 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='Mygalea' AND (species='jaegeri' OR species='jaegerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paleptesicus' AND (junior_species='noctuloides' OR junior_species='noctuloides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paleptesicus' AND (species='noctuloides' OR species='noctuloides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paleptesicus' AND (species='noctuloides' OR species='noctuloides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paleptesicus' AND (junior_species='noctuloides' OR junior_species='noctuloides')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='Paleptesicus' AND (species='noctuloides' OR species='noctuloides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paleptesicus' 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='Paleptesicus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paleptesicus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paleptesicus' 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='Paleptesicus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Keramidomys' AND (junior_species='thaleri' OR junior_species='thalerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Keramidomys' AND (species='thaleri' OR species='thalerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Keramidomys' AND (species='thaleri' OR species='thalerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Keramidomys' AND (junior_species='thaleri' OR junior_species='thalerii')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='Keramidomys' AND (species='thaleri' OR species='thalerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spermophilinus' AND (junior_species='besanus' OR junior_species='besanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spermophilinus' AND (species='besanus' OR species='besanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spermophilinus' AND (species='besanus' OR species='besanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spermophilinus' AND (junior_species='besanus' OR junior_species='besanus')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='Spermophilinus' AND (species='besanus' OR species='besanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Blackia' AND (junior_species='miocaenica' OR junior_species='miocaenica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Blackia' AND (species='miocaenica' OR species='miocaenica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Blackia' AND (species='miocaenica' OR species='miocaenica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Blackia' AND (junior_species='miocaenica' OR junior_species='miocaenica')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='Blackia' AND (species='miocaenica' OR species='miocaenica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteroxerus' AND (junior_species='rubricati' OR junior_species='rubricatii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heteroxerus' AND (species='rubricati' OR species='rubricatii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heteroxerus' AND (species='rubricati' OR species='rubricatii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteroxerus' AND (junior_species='rubricati' OR junior_species='rubricatii')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='rubricati' OR species='rubricatii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eumyarion' 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='Eumyarion' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eumyarion' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eumyarion' 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='Eumyarion' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Democricetodon' AND (junior_species='mutilus' OR junior_species='mutilus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Democricetodon' AND (species='mutilus' OR species='mutilus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Democricetodon' AND (species='mutilus' OR species='mutilus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Democricetodon' AND (junior_species='mutilus' OR junior_species='mutilus')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='Democricetodon' AND (species='mutilus' OR species='mutilus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megacricetodon' AND (junior_species='bavaricus' OR junior_species='bavaricus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megacricetodon' AND (species='bavaricus' OR species='bavaricus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megacricetodon' AND (species='bavaricus' OR species='bavaricus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megacricetodon' AND (junior_species='bavaricus' OR junior_species='bavaricus')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='Megacricetodon' AND (species='bavaricus' OR species='bavaricus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megacricetodon' AND (junior_species='minor' OR junior_species='minor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megacricetodon' AND (species='minor' OR species='minor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megacricetodon' AND (species='minor' OR species='minor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megacricetodon' AND (junior_species='minor' OR junior_species='minor')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='Megacricetodon' AND (species='minor' OR species='minor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miodyromys' AND (junior_species='vagus' OR junior_species='vagus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Miodyromys' AND (species='vagus' OR species='vagus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Miodyromys' AND (species='vagus' OR species='vagus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miodyromys' AND (junior_species='vagus' OR junior_species='vagus')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='Miodyromys' AND (species='vagus' OR species='vagus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microdyromys' AND (junior_species='complicatus' OR junior_species='complicatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microdyromys' AND (species='complicatus' OR species='complicatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microdyromys' AND (species='complicatus' OR species='complicatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microdyromys' AND (junior_species='complicatus' OR junior_species='complicatus')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='complicatus' OR species='complicatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prolagus' AND (junior_species='oeningensis' OR junior_species='oeningensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prolagus' AND (species='oeningensis' OR species='oeningensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prolagus' AND (species='oeningensis' OR species='oeningensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prolagus' AND (junior_species='oeningensis' OR junior_species='oeningensis')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='Prolagus' AND (species='oeningensis' OR species='oeningensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lagopsis' AND (junior_species='penai' OR junior_species='penaii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lagopsis' AND (species='penai' OR species='penaii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lagopsis' AND (species='penai' OR species='penaii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lagopsis' AND (junior_species='penai' OR junior_species='penaii')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='Lagopsis' AND (species='penai' OR species='penaii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Viverridae' 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='Viverridae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Viverridae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Viverridae' 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='Viverridae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudaelurus' AND (junior_species='quadridentatus' OR junior_species='quadridentatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudaelurus' AND (species='quadridentatus' OR species='quadridentatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudaelurus' AND (species='quadridentatus' OR species='quadridentatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudaelurus' AND (junior_species='quadridentatus' OR junior_species='quadridentatus')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='Pseudaelurus' AND (species='quadridentatus' OR species='quadridentatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cainotherium' AND (junior_species='bavaricum' OR junior_species='bavaricum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cainotherium' AND (species='bavaricum' OR species='bavaricum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cainotherium' AND (species='bavaricum' OR species='bavaricum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cainotherium' AND (junior_species='bavaricum' OR junior_species='bavaricum')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='Cainotherium' AND (species='bavaricum' OR species='bavaricum') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2524 The Ecological Register: Oggenhausen 2
Oggenhausen 2
Basic information
Sample name: Oggenhausen 2

Reference: R. Böttcher, E. P. J. Heizmann, M. W. Rasser, and R. Ziegler. 2009. Biostratigraphy and palaeoecology of a Middle Miocene (Karpathian, MN 5) fauna from the northern margin of the North Alpine Foreland Basin (Oggenhausen 2, SW Germany. Neues Jahrbuch für Geologie und Paläontologie - Abhandlungen 254(1-2):237-260 [ER 2354]
Geography
Country: Germany


Coordinate: 48° 40' N, 10° 9' E
Coordinate basis: based on nearby landmark

Time interval: Middle Miocene

Zone: MN5

Ma: 15.5

Geography comments: "directly SW of the town Oggenhausen" (coordinate based on Heidenheim an der Brenz)
"Early/Middle Miocene transition (mammal unit MN 5)" and specifically in the early part of MN 5 before the Early/Middle Miocene boundary (this interpretation of MN 5 differs from that of Costeur and Legendre 2008, which I am following and which indicates an age of about 15.5 Ma for early MN 5)

Environment
Substrate: ground surface

Lithology: claystone

Habitat comments: "clays and marls mixed with fragments and grit of Upper Jurassic Limestone, resembling ejecta of the nearby Ries impact"

Methods
Life forms: bats,carnivores,rodents,ungulates,other small mammals

Sites: 1

Sampling methods: screenwash

Sample size: 381 specimens

Sampling comments: "a sample of about 600 kg which has been screen washed with a minimum mesh size of 0.5 mm"
numerous gastropods are also present

Metadata
Sample number: 2524

Contributor: John Alroy

Enterer: John Alroy

Created: 2017-02-14 10:28:31

Modified: 2023-09-08 11:50:24

Abundance distribution
23 species
5 singletons
total count 381
extrapolated richness: 35.7
Fisher's α: 5.382
geometric series k: 0.8060
Hurlbert's PIE: 0.8322
Shannon's H: 2.2206
Good's u: 0.9869
Each square represents a species. Square sizes are proportional to counts.
Register