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 The Ecological Register: Borsuka Cave (Layer III)
Borsuka Cave (Layer III)
Basic information
Sample name: Borsuka Cave (Layer III)

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 cracoviensia 55(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.
Register
Gallus gallus domesticus129.1 g frugivore-granivore
"Gallus gallus forma domestica"
Mustela sp.2
eversmanii or putorius
Meles meles1611 kg invertivore-herbivore
Ursus arctos1156 kg frugivore-carnivore
Felis silvestris14.5 kg carnivore
Cervus elaphus1104 kg
Castor fiber1
Cricetus cricetus6
Lepus sp.3