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=4248 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=4248SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3871SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=4248 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='chihliensis' OR junior_species='chihliensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canis' AND (species='chihliensis' OR species='chihliensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canis' AND (species='chihliensis' OR species='chihliensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='chihliensis' OR junior_species='chihliensis')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='chihliensis' OR species='chihliensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coelodonta' AND (junior_species='nihowanensis' OR junior_species='nihowanensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coelodonta' AND (species='nihowanensis' OR species='nihowanensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coelodonta' AND (species='nihowanensis' OR species='nihowanensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coelodonta' AND (junior_species='nihowanensis' OR junior_species='nihowanensis')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='Coelodonta' AND (species='nihowanensis' OR species='nihowanensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Proboscidipparion' AND (junior_species='sinense' OR junior_species='sinense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Proboscidipparion' AND (species='sinense' OR species='sinense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Proboscidipparion' AND (species='sinense' OR species='sinense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Proboscidipparion' AND (junior_species='sinense' OR junior_species='sinense')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='Proboscidipparion' AND (species='sinense' OR species='sinense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='sanmeniensis' OR junior_species='sanmeniensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Equus' AND (species='sanmeniensis' OR species='sanmeniensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Equus' AND (species='sanmeniensis' OR species='sanmeniensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='sanmeniensis' OR junior_species='sanmeniensis')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='Equus' AND (species='sanmeniensis' OR species='sanmeniensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sus' AND (junior_species='lydekkeri' OR junior_species='lydekkerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sus' AND (species='lydekkeri' OR species='lydekkerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sus' AND (species='lydekkeri' OR species='lydekkerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sus' AND (junior_species='lydekkeri' OR junior_species='lydekkerii')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='Sus' AND (species='lydekkeri' OR species='lydekkerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muntiacus' AND (junior_species='lacustris' OR junior_species='lacustris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Muntiacus' AND (species='lacustris' OR species='lacustris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Muntiacus' AND (species='lacustris' OR species='lacustris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muntiacus' AND (junior_species='lacustris' OR junior_species='lacustris')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='Muntiacus' AND (species='lacustris' OR species='lacustris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eucladoceros' AND (junior_species='boulei' OR junior_species='bouleii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eucladoceros' AND (species='boulei' OR species='bouleii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eucladoceros' AND (species='boulei' OR species='bouleii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eucladoceros' AND (junior_species='boulei' OR junior_species='bouleii')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='Eucladoceros' AND (species='boulei' OR species='bouleii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Axis' AND (junior_species='shansius' OR junior_species='shansius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Axis' AND (species='shansius' OR species='shansius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Axis' AND (species='shansius' OR species='shansius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Axis' AND (junior_species='shansius' OR junior_species='shansius')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='Axis' AND (species='shansius' OR species='shansius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spirocerus' AND (junior_species='wongi' OR junior_species='wongii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spirocerus' AND (species='wongi' OR species='wongii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spirocerus' AND (species='wongi' OR species='wongii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spirocerus' AND (junior_species='wongi' OR junior_species='wongii')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='Spirocerus' AND (species='wongi' OR species='wongii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bison' AND (junior_species='palaeosinensis' OR junior_species='palaeosinensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bison' AND (species='palaeosinensis' OR species='palaeosinensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bison' AND (species='palaeosinensis' OR species='palaeosinensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bison' AND (junior_species='palaeosinensis' OR junior_species='palaeosinensis')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='Bison' AND (species='palaeosinensis' OR species='palaeosinensis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=4248
Reference:W. Dong, L. M. Zhang, and W. H. Liu. 2017. New material of the Early Pleistocene mammalian fauna from Chutoulang, Chifeng, eastern Nei Mongol, China and binary faunal similarity analyses. Vertebrata PalAsiatica55(3):257-275 [ER 3871]
Geography
Country: China
State: Nei Mongol
Coordinate:42° 19' 45" N, 118° 39' 12" E
Coordinate basis: stated in text
Formation: Dongliang
Time interval: Early Pleistocene
Max Ma: 1.6
Min Ma: 1.4
Age basis: other
Geography comments: "2.13 km northeast" of Chutoulang, whicih is "about 22.5 km west" of Chifeng City (this is one of several sites in the area)
from "the lower part of Dongliang Formation"
the age estimate of 1.4 to 1.6 Ma is based on faunal comparisons
•
Environment
Lithology: claystone
Habitat comments: "The fossils were unearthed from a main layer of reddish and brownish clay or sandy clay with a thickness of 5–7 m and with a sandwiched layer of grayish silt"
the formation is "a series of fluvial-lacustrine deposits" but the paleoenvironment is not discussed any further
Methods
Life forms: carnivores,ungulates
Sampling methods: quarry
Sample size: 33 specimens
Years: 2012
Sampling comments: from a "paleontological excavation"
Metadata
Sample number: 4248
Contributor: John Alroy
Enterer: John Alroy
Created: 2023-04-23 12:00:09
Modified: 2023-04-23 02:00:41
Abundance distribution
10 species
3 singletons
total count 33
extrapolated richness: 22.8
Fisher's α: 4.880
geometric series k: 0.7459
Hurlbert's PIE: 0.7642
Shannon's H: 1.8651
Good's u: 0.9161
Each square represents a species. Square sizes are proportional to counts.