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=4297 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=4297SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3905SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=4297 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parasorex' AND (junior_species='socialis' OR junior_species='socialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parasorex' AND (species='socialis' OR species='socialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parasorex' AND (species='socialis' OR species='socialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parasorex' AND (junior_species='socialis' OR junior_species='socialis')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='Parasorex' AND (species='socialis' OR species='socialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Talpa' AND (junior_species='minuta' OR junior_species='minuta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Talpa' AND (species='minuta' OR species='minuta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Talpa' AND (species='minuta' OR species='minuta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Talpa' AND (junior_species='minuta' OR junior_species='minuta')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='minuta' OR species='minuta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plesiodimylus' AND (junior_species='chantrei' OR junior_species='chantreii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Plesiodimylus' AND (species='chantrei' OR species='chantreii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plesiodimylus' AND (species='chantrei' OR species='chantreii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plesiodimylus' AND (junior_species='chantrei' OR junior_species='chantreii')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='Plesiodimylus' AND (species='chantrei' OR species='chantreii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dinosorex' AND (junior_species='zapfei' OR junior_species='zapfeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dinosorex' AND (species='zapfei' OR species='zapfeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dinosorex' AND (species='zapfei' OR species='zapfeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dinosorex' AND (junior_species='zapfei' OR junior_species='zapfeii')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='Dinosorex' AND (species='zapfei' OR species='zapfeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Galerix' AND (junior_species='exilis' OR junior_species='exilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Galerix' AND (species='exilis' OR species='exilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Galerix' AND (species='exilis' OR species='exilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Galerix' AND (junior_species='exilis' OR junior_species='exilis')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='Galerix' AND (species='exilis' OR species='exilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prolagus' AND (junior_species='oeningensis' OR junior_species='oeningensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prolagus' AND (species='oeningensis' OR species='oeningensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prolagus' AND (species='oeningensis' OR species='oeningensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prolagus' AND (junior_species='oeningensis' OR junior_species='oeningensis')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='Prolagus' AND (species='oeningensis' OR species='oeningensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spermophilinus' AND (junior_species='bredai' OR junior_species='bredaii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spermophilinus' AND (species='bredai' OR species='bredaii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spermophilinus' AND (species='bredai' OR species='bredaii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spermophilinus' AND (junior_species='bredai' OR junior_species='bredaii')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='Spermophilinus' AND (species='bredai' OR species='bredaii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miopetaurista' AND (junior_species='crusafonti' OR junior_species='crusafontii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Miopetaurista' AND (species='crusafonti' OR species='crusafontii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Miopetaurista' AND (species='crusafonti' OR species='crusafontii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miopetaurista' AND (junior_species='crusafonti' OR junior_species='crusafontii')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='Miopetaurista' AND (species='crusafonti' OR species='crusafontii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glirudinus' AND (junior_species='undosus' OR junior_species='undosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glirudinus' AND (species='undosus' OR species='undosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glirudinus' AND (species='undosus' OR species='undosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glirudinus' AND (junior_species='undosus' OR junior_species='undosus')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='Glirudinus' AND (species='undosus' OR species='undosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muscardinus' AND (junior_species='sansaniensis' OR junior_species='sansaniensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Muscardinus' AND (species='sansaniensis' OR species='sansaniensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Muscardinus' AND (species='sansaniensis' OR species='sansaniensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muscardinus' AND (junior_species='sansaniensis' OR junior_species='sansaniensis')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='Muscardinus' AND (species='sansaniensis' OR species='sansaniensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microdyromys' AND (junior_species='complicatus' OR junior_species='complicatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microdyromys' AND (species='complicatus' OR species='complicatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microdyromys' AND (species='complicatus' OR species='complicatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microdyromys' AND (junior_species='complicatus' OR junior_species='complicatus')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='Microdyromys' AND (species='complicatus' OR species='complicatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paraglis' 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='Paraglis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paraglis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paraglis' 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='Paraglis' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eumyarion' AND (junior_species='leemanni' OR junior_species='leemannii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eumyarion' AND (species='leemanni' OR species='leemannii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eumyarion' AND (species='leemanni' OR species='leemannii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eumyarion' AND (junior_species='leemanni' OR junior_species='leemannii')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='Eumyarion' AND (species='leemanni' OR species='leemannii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megacricetodon' AND (junior_species='minor' OR junior_species='minor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megacricetodon' AND (species='minor' OR species='minor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megacricetodon' AND (species='minor' OR species='minor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megacricetodon' AND (junior_species='minor' OR junior_species='minor')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='Megacricetodon' AND (species='minor' OR species='minor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Democricetodon' AND (junior_species='brevis' OR junior_species='brevis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Democricetodon' AND (species='brevis' OR species='brevis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Democricetodon' AND (species='brevis' OR species='brevis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Democricetodon' AND (junior_species='brevis' OR junior_species='brevis')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='Democricetodon' AND (species='brevis' OR species='brevis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Democricetodon' AND (junior_species='larteti' OR junior_species='lartetii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Democricetodon' AND (species='larteti' OR species='lartetii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Democricetodon' AND (species='larteti' OR species='lartetii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Democricetodon' AND (junior_species='larteti' OR junior_species='lartetii')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='Democricetodon' AND (species='larteti' OR species='lartetii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hispanomys' AND (junior_species='aguirrei' OR junior_species='aguirreii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hispanomys' AND (species='aguirrei' OR species='aguirreii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hispanomys' AND (species='aguirrei' OR species='aguirreii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hispanomys' AND (junior_species='aguirrei' OR junior_species='aguirreii')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='Hispanomys' AND (species='aguirrei' OR species='aguirreii') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=4297 The Ecological Register: Barranc de Can Vila 1
Barranc de Can Vila 1
Basic information
Sample name: Barranc de Can Vila 1

Sample aka: BCV1

Reference: M. Furió, I. Casanovas-Vilar, S. Moyà-Solà, M. Köhler, J. Galindo, and D. M. Alba. 2011. Insectivores (Eulipotyphla; Mammalia) from the Middle Miocene of Barranc de Can Vila 1 (Vallès-Penedès Basin, Catalonia, Spain). Geobios 44:199-213 [ER 3905]
Geography
Country: Spain

State: Barcelona


Coordinate: 41.523197° N, 1.805321° E
Coordinate basis: estimated from map

Formation: Valles Penedes Basin

Time interval: Middle Miocene

Zone: MN7

Ma: 11.9

Age basis: paleomag

Geography comments: BCV1 is located near the Can Vila farmhouse outside of the town of els Hostalets de Pierola in NE of Barcelona, Catalonia

Combined magnetostratigraphic and biostratigraphic data placed the estimated age of the locality at 11.9 Ma

•
Environment
Lithology: siliciclastic (mixed)

Taphonomic context: fluvial deposit

Habitat comments: The sediments of BCV1 were deposited at the edge of the coalescence of two major alluvial fan systems

Predators such as barn owls may have been a factor in the accumulation of micromammal remains at BCV1, but it is still debated


Methods
Life forms: rodents,other small mammals

Sampling methods: quarry,screenwash

Sample size: 421 specimens

Years: 2003, 2004

Sampling comments: ~10 tons of excavated sediment was screen-washed

Furio et al described taxonomically lumped 'insectivores' (Eulipotyphla; Mammalia) from the site

Rodents and Lagomorphs are gathered from Casanovas-Vilar et al 2010 (ER 3908)

Metadata
Sample number: 4297

Contributor: Jack Nesbitt

Enterer: Jack Nesbitt

Created: 2023-06-13 10:37:00

Modified: 2023-09-11 10:54:06

Abundance distribution
17 species
1 singleton
total count 421
extrapolated richness: 20.3
Fisher's α: 3.554
geometric series k: 0.7391
Hurlbert's PIE: 0.8486
Shannon's H: 2.2487
Good's u: 0.9976
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Parasorex socialis26
Talpa minuta15
Plesiodimylus chantrei19
Dinosorex zapfei38
Galerix exilis5
Prolagus oeningensis4
Spermophilinus bredai35
Miopetaurista cf. crusafonti3
Glirudinus undosus9
Muscardinus sansaniensis6
Microdyromys complicatus5
Paraglis sp.1
Eumyarion leemanni126
Megacricetodon minor minor37
Democricetodon brevis brevis13
Democricetodon larteti72
Hispanomys cf. aguirrei7