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=4294 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=4294SELECT 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=4294 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='Hanakia' AND (junior_species='agadjaniani' OR junior_species='agadjanianii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hanakia' AND (species='agadjaniani' OR species='agadjanianii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hanakia' AND (species='agadjaniani' OR species='agadjanianii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hanakia' AND (junior_species='agadjaniani' OR junior_species='agadjanianii')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='Hanakia' AND (species='agadjaniani' OR species='agadjanianii') 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 * FROM register WHERE sample_no=4294
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: MN3
Geography comments: Petersbuch 62 is located in a stone quarry near the town of Petersbuch, Bavaria, Southern Germany
Petersbuch 62 is placed in MN 3 based on the presence of certain faunal elements
•
Environment
Lithology: claystone
Taphonomic context: bird accumulation,fissure fill
Habitat comments: Petersbuch 62 is a karst fissure filling made of "light brown, dark brown, or reddish clayey loam" occasionally enriched with small iron ore concretions
Quality of preservation and presence of articulated remains indicates rapid deposition without reworking
Methods
Life forms: bats
Sampling methods: quarry
Sample size: 406 specimens
Sampling comments: 406 bat specimens were recovered from Petersbuch 62
Examined material is mostly dentary and maxillary fragments
Metadata
Sample number: 4294
Contributor: Jack Nesbitt
Enterer: Jack Nesbitt
Created: 2023-06-05 15:54:57
Modified: 2023-09-06 07:20:40
Abundance distribution
6 species
1 singleton
total count 406
extrapolated richness: 8.5
Fisher's α: 0.998
geometric series k: 0.3602
Hurlbert's PIE: 0.6639
Shannon's H: 1.1627
Good's u: 0.9975
Each square represents a species. Square sizes are proportional to counts.