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=2663 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2663SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2432SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2663 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Titanomys' AND (junior_species='visenoviensis' OR junior_species='visenoviensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Titanomys' AND (species='visenoviensis' OR species='visenoviensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Titanomys' AND (species='visenoviensis' OR species='visenoviensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Titanomys' AND (junior_species='visenoviensis' OR junior_species='visenoviensis')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='Titanomys' AND (species='visenoviensis' OR species='visenoviensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Piezodus' AND (junior_species='tomerdingensis' OR junior_species='tomerdingensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Piezodus' AND (species='tomerdingensis' OR species='tomerdingensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Piezodus' AND (species='tomerdingensis' OR species='tomerdingensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Piezodus' AND (junior_species='tomerdingensis' OR junior_species='tomerdingensis')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='Piezodus' AND (species='tomerdingensis' OR species='tomerdingensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaeomys' AND (junior_species='dehmi' OR junior_species='dehmii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Palaeomys' AND (species='dehmi' OR species='dehmii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Palaeomys' AND (species='dehmi' OR species='dehmii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaeomys' AND (junior_species='dehmi' OR junior_species='dehmii')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='Palaeomys' AND (species='dehmi' OR species='dehmii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Castoridae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Castoridae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Castoridae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Castoridae' AND (junior_species='indet.' OR junior_species='indet.')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='Castoridae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaeosciurus' AND (junior_species='feignouxi' OR junior_species='feignouxii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Palaeosciurus' AND (species='feignouxi' OR species='feignouxii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Palaeosciurus' AND (species='feignouxi' OR species='feignouxii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaeosciurus' AND (junior_species='feignouxi' OR junior_species='feignouxii')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='Palaeosciurus' AND (species='feignouxi' OR species='feignouxii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteroxerus' AND (junior_species='paulhiacensis' OR junior_species='paulhiacensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heteroxerus' AND (species='paulhiacensis' OR species='paulhiacensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heteroxerus' AND (species='paulhiacensis' OR species='paulhiacensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteroxerus' AND (junior_species='paulhiacensis' OR junior_species='paulhiacensis')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='paulhiacensis' OR species='paulhiacensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhodanomys' AND (junior_species='oscensis' OR junior_species='oscensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhodanomys' AND (species='oscensis' OR species='oscensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhodanomys' AND (species='oscensis' OR species='oscensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhodanomys' AND (junior_species='oscensis' OR junior_species='oscensis')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='Rhodanomys' AND (species='oscensis' OR species='oscensis') 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='Quercomys' AND (junior_species='bijmai' OR junior_species='bijmaii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quercomys' AND (species='bijmai' OR species='bijmaii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quercomys' AND (species='bijmai' OR species='bijmaii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercomys' AND (junior_species='bijmai' OR junior_species='bijmaii')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='Quercomys' AND (species='bijmai' OR species='bijmaii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudodyromys' 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='Pseudodyromys' AND (species='ibericus' OR species='ibericus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudodyromys' AND (species='ibericus' OR species='ibericus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudodyromys' 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='Pseudodyromys' AND (species='ibericus' OR species='ibericus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vasseuromys' AND (junior_species='rugosus' OR junior_species='rugosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vasseuromys' AND (species='rugosus' OR species='rugosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vasseuromys' AND (species='rugosus' OR species='rugosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vasseuromys' AND (junior_species='rugosus' OR junior_species='rugosus')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='Vasseuromys' AND (species='rugosus' OR species='rugosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vasseuromys' AND (junior_species='priscus' OR junior_species='priscus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vasseuromys' AND (species='priscus' OR species='priscus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vasseuromys' AND (species='priscus' OR species='priscus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vasseuromys' AND (junior_species='priscus' OR junior_species='priscus')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='Vasseuromys' AND (species='priscus' OR species='priscus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2663 The Ecological Register: Santa Cilia
Santa Cilia
Basic information
Sample name: Santa Cilia

Reference: M. A. Alvarez Sierra, R. Daams, J. I. Lacomba, N. López Martínez, A. J. van der Meulen, C. Sesé, and J. de Visser. 1990. Palaeontology and biostratigraphy (micromammals) of the continental Oligocene-Miocene deposits of the North-Central Ebro Basin (Huesca, Spain). Scripta Geologica 94:1-77 [ER 2432]
Geography
Country: Spain

State: Huesca


Coordinate: 42° 12' N, 0° 6' W
Coordinate basis: based on nearby landmark

Formation: Sariñena

Time interval: Early Miocene

Zone: MN1

Age basis: zone

Geography comments: northwest of Peraltilla and ENE of Huesca and quite close to Morrano (basis of coordinate)
local zone X (equivalent to MN1 according to Cuenca et al. 1992)

Environment
Substrate: ground surface

Lithology: claystone

Habitat comments: shown in Fig. 4 as coming from clays

Methods
Life forms: rodents

Sampling methods: screenwash

Sample size: 1327 specimens

Years: 1982 - 1985

Sampling comments: additional taxa are not discussed

Metadata
Sample number: 2663

Contributor: John Alroy

Enterer: John Alroy

Created: 2017-03-05 09:33:33

Modified: 2017-03-04 22:33:33

Abundance distribution
12 species
2 singletons
total count 1327
extrapolated richness: 15.4
Fisher's α: 1.820
geometric series k: 0.5445
Hurlbert's PIE: 0.6037
Shannon's H: 1.3851
Good's u: 0.9985
Each square represents a species. Square sizes are proportional to counts.
Register