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=2589 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2589SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2395SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2589 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='Paratalpa' 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='Paratalpa' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paratalpa' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paratalpa' 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='Paratalpa' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Asthenoscapter' 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='Asthenoscapter' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Asthenoscapter' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Asthenoscapter' 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='Asthenoscapter' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dimylus' AND (junior_species='paradoxus' OR junior_species='paradoxus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dimylus' AND (species='paradoxus' OR species='paradoxus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dimylus' AND (species='paradoxus' OR species='paradoxus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dimylus' AND (junior_species='paradoxus' OR junior_species='paradoxus')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='Dimylus' AND (species='paradoxus' OR species='paradoxus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dimyloides' AND (junior_species='rigassii' OR junior_species='rigassi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dimyloides' AND (species='rigassii' OR species='rigassi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dimyloides' AND (species='rigassii' OR species='rigassi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dimyloides' AND (junior_species='rigassii' OR junior_species='rigassi')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='Dimyloides' AND (species='rigassii' OR species='rigassi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Soricidae' 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='Soricidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Soricidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Soricidae' 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='Soricidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaeosciurus' AND (junior_species='feignouxi' OR junior_species='feignouxii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Palaeosciurus' AND (species='feignouxi' OR species='feignouxii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Palaeosciurus' AND (species='feignouxi' OR species='feignouxii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaeosciurus' AND (junior_species='feignouxi' OR junior_species='feignouxii')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='feignouxi' OR species='feignouxii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Steneofiber' AND (junior_species='eseri' OR junior_species='eserii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Steneofiber' AND (species='eseri' OR species='eserii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Steneofiber' AND (species='eseri' OR species='eserii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Steneofiber' AND (junior_species='eseri' OR junior_species='eserii')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='Steneofiber' AND (species='eseri' OR species='eserii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microdyromys' 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='Microdyromys' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microdyromys' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microdyromys' 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='Microdyromys' AND (species='sp.' OR species='sp.') 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='Plesiosminthus' AND (junior_species='myarion' OR junior_species='myarion')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Plesiosminthus' AND (species='myarion' OR species='myarion') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plesiosminthus' AND (species='myarion' OR species='myarion')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plesiosminthus' AND (junior_species='myarion' OR junior_species='myarion')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='myarion' OR species='myarion') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2589 The Ecological Register: Grossberg Bank
Grossberg Bank
Basic information
Sample name: Grossberg Bank

Sample aka: Laubenheim

Reference: J. J. Brinkkötter and T. Martin. 2015. Small mammals and stratigraphic position of the \"Grossberg-Bank\" (lower Oberrad Formation, MN1, early Miocene) at Laubenheim Quarry in the Mainz Basin, SW Germany, and their implications for early Miocene biostratigraphy. Paläontologische Zeitschrift 89:995-1022 [ER 2395]
Geography
Country: Germany


Coordinate: 49° 57' N, 8° 19' E
Coordinate basis: based on nearby landmark

Formation: Oberrad

Time interval: Early Miocene

Zone: MN1

Age basis: zone

Geography comments: "southeast of the center of Mainz within the districts Mainz-Weisenau, Mainz-Laubenheim, and Mainz-Hechtsheim... in the Laubenheim quarry" (coordinate based on Mainz-Laubenheim)
in "the lower Oberrad Formation... presumably of Aquitanian (Lower Miocene)" based on biostratigraphy of multiple taxa; "uppermost MN1" based on the mammals themselves

•
Environment
Substrate: ground surface

Lithology: marl

Habitat comments: "light to brownish gray, unstratified Hydrobia marl... floating cadavers" were "delivered by rivers from the hinterland of the Mainz Basin lagoon" (i.e., the greater environmental context is a lagoon)

Methods
Life forms: rodents,other small mammals

Sampling methods: screenwash,surface

Sample size: 55 specimens

Sampling comments: "Apart from brackish-marine invertebrates and aquatic vertebrates" the sample "yielded a large number of disarticulated bones, mandibles, and teeth of terrestrial vertebrates such as reptiles, birds, and mammals" (lagomorphs, ungulates, and carnivorans are listed but not described)
"The material was collected predominantly on the surface of the fossiliferous bed... a few kilograms of sediment" were collected "from the fossiliferous layer for extraction of microvertebrates" (presumably using screening)

Metadata
Sample number: 2589

Contributor: John Alroy

Enterer: John Alroy

Created: 2017-02-18 12:37:51

Modified: 2017-03-07 08:51:15

Abundance distribution
11 species
3 singletons
total count 55
extrapolated richness: 20.3
Fisher's α: 4.135
geometric series k: 0.7628
Hurlbert's PIE: 0.8300
Shannon's H: 2.0175
Good's u: 0.9468
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Amphiperatherium frequens3
Paratalpa sp.4
Asthenoscapter sp.1
Dimylus cf. paradoxus1
Dimyloides rigassii1
Soricidae indet.2
Palaeosciurus cf. feignouxi2
Steneofiber eseri15
Microdyromys sp.12
Rhodanomys schlosseri8
Plesiosminthus myarion6