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=4075 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=4075SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3087SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=4075 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gallus' AND (junior_species='gallus' OR junior_species='gallus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gallus' AND (species='gallus' OR species='gallus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gallus' AND (species='gallus' OR species='gallus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gallus' AND (junior_species='gallus' OR junior_species='gallus')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='Gallus' AND (species='gallus' OR species='gallus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mustela' 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='Mustela' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mustela' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mustela' 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='Mustela' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meles' AND (junior_species='meles' OR junior_species='meles')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Meles' AND (species='meles' OR species='meles') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meles' AND (junior_species='meles' OR junior_species='meles')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='Meles' AND (species='meles' OR species='meles') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ursus' AND (junior_species='arctos' OR junior_species='arctos')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ursus' AND (species='arctos' OR species='arctos') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ursus' AND (junior_species='arctos' OR junior_species='arctos')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='Ursus' AND (species='arctos' OR species='arctos') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Felis' AND (junior_species='silvestris' OR junior_species='silvestris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Felis' AND (species='silvestris' OR species='silvestris') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Felis' AND (junior_species='silvestris' OR junior_species='silvestris')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='Felis' AND (species='silvestris' OR species='silvestris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervus' AND (junior_species='elaphus' OR junior_species='elaphus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cervus' AND (species='elaphus' OR species='elaphus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervus' AND (junior_species='elaphus' OR junior_species='elaphus')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='Cervus' AND (species='elaphus' OR species='elaphus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Castor' AND (junior_species='fiber' OR junior_species='fiber')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Castor' AND (species='fiber' OR species='fiber') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Castor' AND (species='fiber' OR species='fiber')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Castor' AND (junior_species='fiber' OR junior_species='fiber')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='Castor' AND (species='fiber' OR species='fiber') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cricetus' AND (junior_species='cricetus' OR junior_species='cricetus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cricetus' AND (species='cricetus' OR species='cricetus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cricetus' AND (species='cricetus' OR species='cricetus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cricetus' AND (junior_species='cricetus' OR junior_species='cricetus')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='Cricetus' AND (species='cricetus' OR species='cricetus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' 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='Lepus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lepus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' 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='Lepus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=4075
Reference:J. Wilczynski, B. Miekina, G. Lipecki, L. Lougas, A. Marciszak, B. Rzebik-Kowalska, E. Stworzewicz, Z. Szyndlar, and K. Wertz. 2012. Faunal remains from Borsuka Cave - an example of local climate variability during Late Pleistocene in southern Poland. Acta zoologica cracoviensia55(2):131-155 [ER 3087]
Geography
Country: Poland
Coordinate:50° 9' 54" N, 19° 42' 12" E
Coordinate basis: stated in text
Time interval: Holocene
Section: 3087
Unit number: 2
Unit order: above to below
Max Ma: 0.004175
Min Ma: 0.00392
Age basis: radiocarbon (uncalibrated)
Geography comments: "Borsuka Cave is located about 20 km west of Kraków, in the Kraków Valleys Landscape Park".
"A mandible fragment from a wildcat and a fragment of humerus bone of a badger, both obtained from layer III, were radiocarbon dated to 3,920 ± 35 BP and 4,175 ± 35 BP, respectively".
•
Environment
Lithology: claystone
Taphonomic context: cave,human accumulation
Archaeology: ceramics,stone tools
Habitat comments: "Layer III consists of red-dark brown clayish sediment, within which there were numerous strongly weathered siliceous chunks measuring up to 50 cm in diameter".
This layer yielded almost 188 flint artefacts. These contain both Mesolithic and Eneolithic/Early Bronze Age specimens, including microliths, flakes, and discoid cores. Intense human activity is also evidenced by the many small fragments of burned bones from this layer".
Methods
Life forms: carnivores,rodents,ungulates,other small mammals,birds
Sampling methods: quarry
Sample size: 32 specimens
Years: 2008 - 2010
Sampling comments: "A trench of 4 x 3 m was situated next to the visible cave entrance and oriented with its longer side along the north-south axis. It covered a ditch of modern times, with dimensions of c. 120 x 120 cm and a depth of approximately 80 cm. In total, the excavation reached a depth of 2.5 m over an area of 12 m2".
Metadata
Sample number: 4075
Contributor: Benjamin Carter
Enterer: Benjamin Carter
Created: 2023-02-20 15:53:13
Modified: 2023-04-29 00:46:29
Abundance distribution
9 species
5 singletons
total count 32
extrapolated richness: 27.6
Fisher's α: 4.163
geometric series k: 0.7071
Hurlbert's PIE: 0.6875
Shannon's H: 1.5972
Good's u: 0.8457
Each square represents a species. Square sizes are proportional to counts.