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=2692 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2692SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2444SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2692 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaeosciurus' AND (junior_species='sutteri' OR junior_species='sutterii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Palaeosciurus' AND (species='sutteri' OR species='sutterii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Palaeosciurus' AND (species='sutteri' OR species='sutterii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaeosciurus' AND (junior_species='sutteri' OR junior_species='sutterii')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='sutteri' OR species='sutterii') 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='Miopetaurista' AND (junior_species='dehmi' OR junior_species='dehmii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Miopetaurista' AND (species='dehmi' OR species='dehmii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Miopetaurista' AND (species='dehmi' OR species='dehmii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miopetaurista' AND (junior_species='dehmi' OR junior_species='dehmii')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='Miopetaurista' AND (species='dehmi' OR species='dehmii') 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='Neopetes' AND (junior_species='hoeckarum' OR junior_species='hoeckarum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neopetes' AND (species='hoeckarum' OR species='hoeckarum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neopetes' AND (species='hoeckarum' OR species='hoeckarum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neopetes' AND (junior_species='hoeckarum' OR junior_species='hoeckarum')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='Neopetes' AND (species='hoeckarum' OR species='hoeckarum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glis' 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='Glis' AND (species='minor' OR species='minor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glis' AND (species='minor' OR species='minor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glis' 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='Glis' AND (species='minor' OR species='minor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Seorsumuscardinus' AND (junior_species='alpinus' OR junior_species='alpinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Seorsumuscardinus' AND (species='alpinus' OR species='alpinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Seorsumuscardinus' AND (species='alpinus' OR species='alpinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Seorsumuscardinus' AND (junior_species='alpinus' OR junior_species='alpinus')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='Seorsumuscardinus' AND (species='alpinus' OR species='alpinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glirudinus' AND (junior_species='minutus' OR junior_species='minutus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glirudinus' AND (species='minutus' OR species='minutus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glirudinus' AND (species='minutus' OR species='minutus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glirudinus' AND (junior_species='minutus' OR junior_species='minutus')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='minutus' OR species='minutus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glirulus' AND (junior_species='lissiensis' OR junior_species='lissiensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glirulus' AND (species='lissiensis' OR species='lissiensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glirulus' AND (species='lissiensis' OR species='lissiensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glirulus' AND (junior_species='lissiensis' OR junior_species='lissiensis')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='Glirulus' AND (species='lissiensis' OR species='lissiensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glirulus' 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='Glirulus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glirulus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glirulus' 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='Glirulus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microdyromys' AND (junior_species='hildebrandti' OR junior_species='hildebrandtii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microdyromys' AND (species='hildebrandti' OR species='hildebrandtii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microdyromys' AND (species='hildebrandti' OR species='hildebrandtii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microdyromys' AND (junior_species='hildebrandti' OR junior_species='hildebrandtii')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='hildebrandti' OR species='hildebrandtii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bransatoglis' AND (junior_species='fugax' OR junior_species='fugax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bransatoglis' AND (species='fugax' OR species='fugax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bransatoglis' AND (species='fugax' OR species='fugax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bransatoglis' AND (junior_species='fugax' OR junior_species='fugax')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='fugax' OR species='fugax') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2692 The Ecological Register: Oberdorf 3
Oberdorf 3
Basic information
Sample name: Oberdorf 3

Reference: H. de Bruijn. 1998. Vertebrates from the Early Miocene lignite deposits of the opencast mine Oberdorf (Western Styrian Basin, Austria): 6. Rodentia 1 (Mammalia). Annalen des Naturhistorischen Museums in Wien 99 A:99-137 [ER 2444]
Geography
Country: Austria


Coordinate: 47° 4' N, 15° 7' E
Coordinate basis: based on nearby landmark

Time interval: Early Miocene

Zone: MN4

Age basis: zone

Geography comments: "in the upper part of the section limiting the east quarry of the lignitie mine of Oberdorf to the north"; immediately east of Bårnbach according to Daxner-Höck et al. (1998) (coordinate based on Bårnbach)
"upper part of the Lower Miocene = MN4"

•
Environment
Substrate: ground surface

Lithology: claystone

Habitat comments: "The fossiliferous beds (lignitic clays containing bones as well as wood, seeds and gastropods) are interpreted as paleosols"

Methods
Life forms: rodents

Sampling methods: screenwash

Sample size: 96 specimens

Years: 1989

Sampling comments: collecting methods not discussed, but screenwashed according to Daxner-Höck et al. (1998)
amphibians including frogs, salamanders, and albanerpotontids are also present, but no carnivorans were found

Metadata
Sample number: 2692

Contributor: John Alroy

Enterer: John Alroy

Created: 2017-03-13 08:17:04

Modified: 2017-03-12 21:22:41

Abundance distribution
12 species
3 singletons
total count 96
extrapolated richness: 19.1
Fisher's α: 3.620
geometric series k: 0.7582
Hurlbert's PIE: 0.8454
Shannon's H: 2.0829
Good's u: 0.9690
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Palaeosciurus sutteri21
Spermophilinus besanus21
Miopetaurista dehmi6
Blackia miocaenica1
Neopetes hoeckarum5
"Hylopetes hoeckarum": new
Glis minor complicatus2
Seorsumuscardinus alpinus6
Glirudinus minutus8
Glirulus (Glirulus) lissiensis18
Glirulus (Paraglirulus) sp.1
Microdyromys cf. hildebrandti1
Bransatoglis fugax6