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=4293 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=4293SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3904SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=4293 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinolophus' AND (junior_species='lemanensis' OR junior_species='lemanensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinolophus' AND (species='lemanensis' OR species='lemanensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhinolophus' AND (species='lemanensis' OR species='lemanensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinolophus' AND (junior_species='lemanensis' OR junior_species='lemanensis')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='Rhinolophus' AND (species='lemanensis' OR species='lemanensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinolophus' 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='Rhinolophus' AND (species='dehmi' OR species='dehmii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhinolophus' AND (species='dehmi' OR species='dehmii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinolophus' 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='Rhinolophus' AND (species='dehmi' OR species='dehmii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megaderma' AND (junior_species='franconica' OR junior_species='franconica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megaderma' AND (species='franconica' OR species='franconica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megaderma' AND (species='franconica' OR species='franconica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megaderma' AND (junior_species='franconica' OR junior_species='franconica')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='Megaderma' AND (species='franconica' OR species='franconica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miostrellus' AND (junior_species='petersbuchensis' OR junior_species='petersbuchensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Miostrellus' AND (species='petersbuchensis' OR species='petersbuchensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Miostrellus' AND (species='petersbuchensis' OR species='petersbuchensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miostrellus' AND (junior_species='petersbuchensis' OR junior_species='petersbuchensis')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='Miostrellus' AND (species='petersbuchensis' OR species='petersbuchensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' 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='Myotis' AND (species='reductus' OR species='reductus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myotis' AND (species='reductus' OR species='reductus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' 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='Myotis' AND (species='reductus' OR species='reductus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plecotus' AND (junior_species='schoepfelii' OR junior_species='schoepfeli')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Plecotus' AND (species='schoepfelii' OR species='schoepfeli') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plecotus' AND (species='schoepfelii' OR species='schoepfeli')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plecotus' AND (junior_species='schoepfelii' OR junior_species='schoepfeli')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='Plecotus' AND (species='schoepfelii' OR species='schoepfeli') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eptesicus' AND (junior_species='campanensis' OR junior_species='campanensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eptesicus' AND (species='campanensis' OR species='campanensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eptesicus' AND (species='campanensis' OR species='campanensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eptesicus' AND (junior_species='campanensis' OR junior_species='campanensis')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='Eptesicus' AND (species='campanensis' OR species='campanensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Submyotodon' AND (junior_species='peterbuchensis' OR junior_species='peterbuchensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Submyotodon' AND (species='peterbuchensis' OR species='peterbuchensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Submyotodon' AND (species='peterbuchensis' OR species='peterbuchensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Submyotodon' AND (junior_species='peterbuchensis' OR junior_species='peterbuchensis')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='Submyotodon' AND (species='peterbuchensis' OR species='peterbuchensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' AND (junior_species='sanctialbani' OR junior_species='sanctialbanii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myotis' AND (species='sanctialbani' OR species='sanctialbanii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myotis' AND (species='sanctialbani' OR species='sanctialbanii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' AND (junior_species='sanctialbani' OR junior_species='sanctialbanii')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='Myotis' AND (species='sanctialbani' OR species='sanctialbanii') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=4293
Reference:V. V. Rosina and M. Rummel. 2012. The bats (Chiroptera, Mammalia) from the Early Miocene of Petersbuch (Bavaria, Southern Germany). Geobios45:463-478 [ER 3904]
Geography
Country: Germany
State: Bavaria
Coordinate:48.978657° N, 11.199542° E
Coordinate basis: estimated from map
Time interval: Early Miocene
Zone: MN 3/4
Geography comments: Petersbuch 28 is located in a stone quarry near the town of Petersbuch, Bavaria, Southern Germany
Petersbuch 28 contains fauna from MN 3 as well as early MN 4 such as Democricetodon and Megacricetodon, suggesting upper MN 3/lowest MN 4 as the date for Petersbuch 28
•
Environment
Lithology: claystone
Taphonomic context: bird accumulation,fissure fill
Habitat comments: Petersbuch 28 is a karst fissure fill consisting of "reddish to brown clayey loam"
Accumulation was most likely through bird pellets but may be due to natural causes, or both
Methods
Life forms: bats
Sampling methods: quarry
Sample size: 702 specimens
Sampling comments: 603 bat specimens were recovered from Petersbuch 28
Examined material is mostly dentary and maxillary fragments
Metadata
Sample number: 4293
Contributor: Jack Nesbitt
Enterer: Jack Nesbitt
Created: 2023-06-05 15:38:30
Modified: 2023-06-05 05:56:16
Abundance distribution
9 species
0 singletons
total count 702
extrapolated richness: 10.6
Fisher's α: 1.456
geometric series k: 0.5385
Hurlbert's PIE: 0.7018
Shannon's H: 1.4035
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.