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=4331 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=4331SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3929SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=4331 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphiperatherium' AND (junior_species='frequens' OR junior_species='frequens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amphiperatherium' AND (species='frequens' OR species='frequens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amphiperatherium' AND (species='frequens' OR species='frequens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphiperatherium' AND (junior_species='frequens' OR junior_species='frequens')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='Amphiperatherium' AND (species='frequens' OR species='frequens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Galerix' AND (junior_species='symeonidisi' OR junior_species='symeonidisii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Galerix' AND (species='symeonidisi' OR species='symeonidisii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Galerix' AND (species='symeonidisi' OR species='symeonidisii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Galerix' AND (junior_species='symeonidisi' OR junior_species='symeonidisii')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='symeonidisi' OR species='symeonidisii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heterosorex' AND (junior_species='neumayrianus' OR junior_species='neumayrianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heterosorex' AND (species='neumayrianus' OR species='neumayrianus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heterosorex' AND (species='neumayrianus' OR species='neumayrianus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heterosorex' AND (junior_species='neumayrianus' OR junior_species='neumayrianus')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='Heterosorex' AND (species='neumayrianus' OR species='neumayrianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lagopsis' AND (junior_species='penai' OR junior_species='penaii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lagopsis' AND (species='penai' OR species='penaii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lagopsis' AND (species='penai' OR species='penaii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lagopsis' AND (junior_species='penai' OR junior_species='penaii')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='Lagopsis' AND (species='penai' OR species='penaii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteroxerus' AND (junior_species='rubricati' OR junior_species='rubricatii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heteroxerus' AND (species='rubricati' OR species='rubricatii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heteroxerus' AND (species='rubricati' OR species='rubricatii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteroxerus' AND (junior_species='rubricati' OR junior_species='rubricatii')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='Heteroxerus' AND (species='rubricati' OR species='rubricatii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glirudinus' AND (junior_species='modestus' OR junior_species='modestus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glirudinus' AND (species='modestus' OR species='modestus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glirudinus' AND (species='modestus' OR species='modestus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glirudinus' AND (junior_species='modestus' OR junior_species='modestus')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='modestus' OR species='modestus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microdyromys' AND (junior_species='koenigswaldi' OR junior_species='koenigswaldii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microdyromys' AND (species='koenigswaldi' OR species='koenigswaldii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microdyromys' AND (species='koenigswaldi' OR species='koenigswaldii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microdyromys' AND (junior_species='koenigswaldi' OR junior_species='koenigswaldii')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='koenigswaldi' OR species='koenigswaldii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peridyromys' AND (junior_species='murinus' OR junior_species='murinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Peridyromys' AND (species='murinus' OR species='murinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Peridyromys' AND (species='murinus' OR species='murinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peridyromys' AND (junior_species='murinus' OR junior_species='murinus')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='Peridyromys' AND (species='murinus' OR species='murinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudodryomys' AND (junior_species='ibericus' OR junior_species='ibericus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudodryomys' AND (species='ibericus' OR species='ibericus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudodryomys' AND (species='ibericus' OR species='ibericus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudodryomys' AND (junior_species='ibericus' OR junior_species='ibericus')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='Pseudodryomys' AND (species='ibericus' OR species='ibericus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Simplomys' AND (junior_species='simplicidens' OR junior_species='simplicidens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Simplomys' AND (species='simplicidens' OR species='simplicidens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Simplomys' AND (species='simplicidens' OR species='simplicidens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Simplomys' AND (junior_species='simplicidens' OR junior_species='simplicidens')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='Simplomys' AND (species='simplicidens' OR species='simplicidens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ligerimys' AND (junior_species='florancei' OR junior_species='floranceii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ligerimys' AND (species='florancei' OR species='floranceii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ligerimys' AND (species='florancei' OR species='floranceii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ligerimys' AND (junior_species='florancei' OR junior_species='floranceii')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='Ligerimys' AND (species='florancei' OR species='floranceii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ligerimys' AND (junior_species='ellipticus' OR junior_species='ellipticus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ligerimys' AND (species='ellipticus' OR species='ellipticus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ligerimys' AND (species='ellipticus' OR species='ellipticus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ligerimys' AND (junior_species='ellipticus' OR junior_species='ellipticus')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='Ligerimys' AND (species='ellipticus' OR species='ellipticus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Democricetodon' AND (junior_species='hispanicus' OR junior_species='hispanicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Democricetodon' AND (species='hispanicus' OR species='hispanicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Democricetodon' AND (species='hispanicus' OR species='hispanicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Democricetodon' AND (junior_species='hispanicus' OR junior_species='hispanicus')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='hispanicus' OR species='hispanicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megacricetodon' AND (junior_species='primitivus' OR junior_species='primitivus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megacricetodon' AND (species='primitivus' OR species='primitivus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megacricetodon' AND (species='primitivus' OR species='primitivus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megacricetodon' AND (junior_species='primitivus' OR junior_species='primitivus')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='primitivus' OR species='primitivus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eumyarion' 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='Eumyarion' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eumyarion' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eumyarion' 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='Eumyarion' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=4331 The Ecological Register: Les Cases de la Valenciana 1
Les Cases de la Valenciana 1
Basic information
Sample name: Les Cases de la Valenciana 1

Sample aka: LV1

Reference: S. Jovells-Vaqué, I. García-Paredes, M. Furió, C. Angelone, L. W. van den Hoek Ostende, M. B. Barberà, D. DeMiguel, J. Madurell-Malapeira, and I. Casanovas-Vilar. 2018. Les Cases de la Valenciana, a new early Miocene small-mammal locality from the Vallès-Penedès Basin (Catalonia, Spain). Historical Biology 30(3):404-421 [ER 3929]
Geography
Country: Spain

State: Catalonia


Coordinate: 41.435364° N, 1.842926° E
Coordinate basis: estimated from map

Formation: Vallès-Penedès Basin

Time interval: Early Miocene

Zone: MN4

Section: LV1

Unit number: 1

Unit order: below to above

Age basis: zone

Geography comments: LV1 is situated to the east of the town of Sant Sadurni d'Anoia, Catalonia, northeast Spain

Coordinates are very roughly estimated from a map in the text

The composition of the cricetid fauna correlates the locality to MN4

•
Environment
Lithology: marl

Taphonomic context: lake deposit

Habitat comments: LV1 corresponds to a marl layer interpreted to have formed in "a swampy environment"

Little specific taphonomic information is provided

Methods
Life forms: rodents,other small mammals

Sampling methods: quarry,screenwash

Sample size: 138 specimens

Years: 2012, 2013, 2014, 2015

Sampling comments: No precise methodology is given

A rich macrovertebrate fauna (NISP >400) was found at LV1 but no taxonomy or counts are provided

Metadata
Sample number: 4331

Contributor: Jack Nesbitt

Enterer: Jack Nesbitt

Created: 2023-07-13 12:38:01

Modified: 2023-07-13 02:38:01

Abundance distribution
15 species
1 singleton
total count 138
extrapolated richness: 20.0
Fisher's α: 4.281
geometric series k: 0.7862
Hurlbert's PIE: 0.8723
Shannon's H: 2.3253
Good's u: 0.9929
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Amphiperatherium frequens3
Galerix cf. symeonidisi5
Heterosorex neumayrianus2
Lagopsis penai14
Heteroxerus rubricati4
Glirudinus modestus3
Microdyromys koenigswaldi7
Peridyromys murinus5
Pseudodryomys ibericus3
Simplomys simplicidens10
Ligerimys florancei15
Ligerimys ellipticus29
Democricetodon hispanicus8
Megacricetodon primitivus29
Eumyarion sp.1