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=3376 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3376SELECT 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=3376 ORDER BY register_no ASCSELECT 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='Dinaromys' AND (junior_species='bogdanovi' OR junior_species='bogdanovii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dinaromys' AND (species='bogdanovi' OR species='bogdanovii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dinaromys' AND (species='bogdanovi' OR species='bogdanovii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dinaromys' AND (junior_species='bogdanovi' OR junior_species='bogdanovii')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='Dinaromys' AND (species='bogdanovi' OR species='bogdanovii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' AND (junior_species='arvalis' OR junior_species='arvalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microtus' AND (species='arvalis' OR species='arvalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microtus' AND (species='arvalis' OR species='arvalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' AND (junior_species='arvalis' OR junior_species='arvalis')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='arvalis' OR species='arvalis') 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 * FROM register WHERE sample_no=3376 The Ecological Register: Caverna degli Orsi (sondage A, Unit 10.2)
Caverna degli Orsi (sondage A, Unit 10.2)
Basic information
Sample name: Caverna degli Orsi (sondage A, Unit 10.2)

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: 3

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: rodents

Sampling methods: quarry

Sample size: 17 specimens

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

Metadata
Sample number: 3376

Contributor: John Alroy

Enterer: John Alroy

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

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

Abundance distribution
7 species
3 singletons
total count 17
extrapolated richness: 18.4
Fisher's α: 4.451
geometric series k: 0.7418
Hurlbert's PIE: 0.7757
Shannon's H: 1.7315
Good's u: 0.8306
Each square represents a species. Square sizes are proportional to counts.
Register
Arvicola amphibius1
"Arvicola terrestris"
Myodes glareolus3
"Clethrionomys glareolus"
Chionomys nivalis6
Dinaromys bogdanovi2
Microtus arvalis1
Microtus (Terricola) sp.1
"gr. multiplex-subterraneus"
Apodemus (Sylvaemus) sp.3