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=3374 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3374SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3095SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3374 ORDER BY register_no ASCSELECT 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 senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ursus' AND (junior_species='spelaeus' OR junior_species='spelaeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ursus' AND (species='spelaeus' OR species='spelaeus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ursus' AND (species='spelaeus' OR species='spelaeus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ursus' AND (junior_species='spelaeus' OR junior_species='spelaeus')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='spelaeus' OR species='spelaeus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='lupus' OR junior_species='lupus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canis' AND (species='lupus' OR species='lupus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='lupus' OR junior_species='lupus')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='Canis' AND (species='lupus' OR species='lupus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arvicola' AND (junior_species='amphibius' OR junior_species='amphibius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arvicola' AND (species='amphibius' OR species='amphibius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arvicola' AND (species='amphibius' OR species='amphibius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arvicola' AND (junior_species='amphibius' OR junior_species='amphibius')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='Arvicola' AND (species='amphibius' OR species='amphibius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myodes' AND (junior_species='glareolus' OR junior_species='glareolus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myodes' AND (species='glareolus' OR species='glareolus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myodes' AND (species='glareolus' OR species='glareolus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myodes' AND (junior_species='glareolus' OR junior_species='glareolus')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='Myodes' AND (species='glareolus' OR species='glareolus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chionomys' AND (junior_species='nivalis' OR junior_species='nivalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chionomys' AND (species='nivalis' OR species='nivalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chionomys' AND (species='nivalis' OR species='nivalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chionomys' AND (junior_species='nivalis' OR junior_species='nivalis')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='Chionomys' AND (species='nivalis' OR species='nivalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' AND (junior_species='agrestis' OR junior_species='agrestis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microtus' AND (species='agrestis' OR species='agrestis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microtus' AND (species='agrestis' OR species='agrestis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' AND (junior_species='agrestis' OR junior_species='agrestis')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='Microtus' AND (species='agrestis' OR species='agrestis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' 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='Microtus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microtus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' 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='Microtus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apodemus' 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='Apodemus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apodemus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apodemus' 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='Apodemus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glis' AND (junior_species='glis' OR junior_species='glis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glis' AND (species='glis' OR species='glis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glis' AND (species='glis' OR species='glis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glis' AND (junior_species='glis' OR junior_species='glis')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='Glis' AND (species='glis' OR species='glis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Talpa' AND (junior_species='europaea' OR junior_species='europaea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Talpa' AND (species='europaea' OR species='europaea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Talpa' AND (species='europaea' OR species='europaea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Talpa' AND (junior_species='europaea' OR junior_species='europaea')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='Talpa' AND (species='europaea' OR species='europaea') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3374 The Ecological Register: Caverna degli Orsi (sondage A, Unit 10)
Caverna degli Orsi (sondage A, Unit 10)
Basic information
Sample name: Caverna degli Orsi (sondage A, Unit 10)

Reference: C. Berto and G. Rubinato. 2013. The upper Pleistocene mammal record from Caverna degli Orsi (San Dorligo della Valle - Dolina, Trieste, Italy): A faunal complex between eastern and western Europe. Quaternary International 284:7-14 [ER 3095]
Geography
Country: Italy


Coordinate: 45° 37' N, 13° 51' E
Coordinate basis: based on nearby landmark

Time interval: Late Pleistocene

Section: 3095

Unit number: 1

Unit order: above to below

Geography comments: "about 12 km SE from Trieste, in the karst territory of San Dorligo della Valle - Dolina... on the northwestern slope of Monte Carso" (coordinate based on San Dorligo della Valle)
there is "no geochronometric dating" but faunal and archaeological evidence suggests that the sequence spans "MIS 5 to 2"

•
Environment
Lithology: claystone

Taphonomic context: cave

Habitat comments: "silty clay loam or clay loam"
there are artifacts "ascribed to Mousterian industry" from Units 11 and 13 in sondage A and 118 and 120 in sondage B
this was "a cave frequented by cave bears and other large carnivores with sporadic human presence" but the mode of accumulation is not discussed

Methods
Life forms: carnivores,rodents,other small mammals

Sampling methods: quarry

Sample size: 35 specimens

Sampling comments: excavations were "carried out between 1993 and 2004"

Metadata
Sample number: 3374

Contributor: John Alroy

Enterer: John Alroy

Created: 2019-08-27 15:14:31

Modified: 2023-04-29 00:58:35

Abundance distribution
11 species
5 singletons
total count 35
extrapolated richness: 29.5
Fisher's α: 5.517
geometric series k: 0.7628
Hurlbert's PIE: 0.7655
Shannon's H: 1.9045
Good's u: 0.8604
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Lepus sp.2
Ursus spelaeus4
Canis lupus143 kg carnivore
Arvicola amphibius1
"Arvicola terrestris"
Myodes glareolus4
"Clethrionomys glareolus"
Chionomys nivalis15
Microtus agrestis1
Microtus sp.2
"gr. multiplex-subterraneus"
Apodemus sp.3
Glis glis1
Talpa europaea1