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=3731 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3731SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3369SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3731 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='lupus' OR junior_species='lupus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canis' AND (species='lupus' OR species='lupus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='lupus' OR junior_species='lupus')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='lupus' OR species='lupus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervus' AND (junior_species='elaphus' OR junior_species='elaphus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cervus' AND (species='elaphus' OR species='elaphus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervus' AND (junior_species='elaphus' OR junior_species='elaphus')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='Cervus' AND (species='elaphus' OR species='elaphus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capreolus' AND (junior_species='pygargus' OR junior_species='pygargus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Capreolus' AND (species='pygargus' OR species='pygargus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Capreolus' AND (species='pygargus' OR species='pygargus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capreolus' AND (junior_species='pygargus' OR junior_species='pygargus')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='Capreolus' AND (species='pygargus' OR species='pygargus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Moschus' 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='Moschus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Moschus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Moschus' 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='Moschus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caprinae' 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='Caprinae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caprinae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caprinae' 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='Caprinae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Procapra' AND (junior_species='gutturosa' OR junior_species='gutturosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Procapra' AND (species='gutturosa' OR species='gutturosa') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Procapra' AND (junior_species='gutturosa' OR junior_species='gutturosa')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='Procapra' AND (species='gutturosa' OR species='gutturosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marmota' AND (junior_species='bobak' OR junior_species='bobak')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Marmota' AND (species='bobak' OR species='bobak') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Marmota' AND (species='bobak' OR species='bobak')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marmota' AND (junior_species='bobak' OR junior_species='bobak')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='Marmota' AND (species='bobak' OR species='bobak') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' 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='Lepus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lepus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' 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='Lepus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panthera' 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='Panthera' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Panthera' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panthera' 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='Panthera' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aves' 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='Aves' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aves' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aves' 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='Aves' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3731 The Ecological Register: Zongri type-site (Layer 2)
Zongri type-site (Layer 2)
Basic information
Sample name: Zongri type-site (Layer 2)

Reference: L. Ren, G. Dong, F. Liu, J. D'alpoim-Guedes, R. K. Flad, M. Ma, H. Li, Y. Yang, Y. Liu, D. Zhang, G. Li, J. Li, and F. Chen. 2020. Foraging and farming: archaeobotanical and zooarchaeological evidence for Neolithic exchange on the Tibetan Plateau. Antiquity 94(375):637-652 [ER 3369]
Geography
Country: China

State: Qinghai


Coordinate: 35° 25' N, 100° 20' E
Coordinate basis: estimated from map

Time interval: Holocene

Section: 3369

Unit number: 2

Unit order: above to below

Max Ma: 0.00394

Min Ma: 0.0037

Age basis: radiocarbon (uncalibrated)

Geography comments: Site is one of many located "in the eastern Gonghe Basin of the north-eastern Tibetan Plateau, all located above 2600m asl"
"Ten charred millet seeds were selected from three cultural layers and two ash pits... for AMS radiocarbon dating"
Layer 2 radiocarbon dates range from 3940 to 3700 BP (2437-2090 cal. B.C.) "at 95.4% confidence"

•
Environment
Lithology: not described

Taphonomic context: human accumulation

Archaeology: bone tools,burials,ceramics,hearths,stone tools,other artifacts

Habitat comments: Site was "first investigated in 1982 by the Qinghai Provincial Institute of Cultural Relics and Archaeology... yielded two burials and a pottery kiln" Further excavations conducted between 1994 and 1996 "uncovered a total of 341 tombs, 18 ash pits and 18 sacrificial pits, and over 30 000 artefacts, including ceramic sherds, lithics, animal remains and bone objects"

Methods
Life forms: carnivores,rodents,ungulates,other small mammals,birds

Sampling methods: quarry,screenwash

Sample size: 364 specimens

Sampling comments: "In 2015, we excavated a small trench measuring 4 × 4m at the Zongri type-site, identifying three distinct cultural layers"
"Systematic archaeobotanical and zooarchaeological sampling was conducted for all features and layers encountered in the trench: 92 soil samples were taken... which contained 4150 charred plant seeds and 3132 fragments of animal bone"
"fragments of animal bones were floated from soil samples"

Metadata
Sample number: 3731

Contributor: Benjamin Carter

Enterer: Benjamin Carter

Created: 2021-05-15 13:22:34

Modified: 2023-04-29 02:52:09

Abundance distribution
10 species
0 singletons
total count 364
extrapolated richness: 11.7
Fisher's α: 1.901
geometric series k: 0.6124
Hurlbert's PIE: 0.7280
Shannon's H: 1.6303
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Canis lupus familiaris343 kg carnivore
"Canis familiaris"
Cervus elaphus65104 kg
Capreolus pygargus10
"Capreolus capreolus"
Moschus sp.51
Caprinae indet.165
Procapra gutturosa2030 kg
also 18 Antilopinae indet.
Marmota bobak36
also 1 Rodentia indet.
Lepus sp.4
Panthera sp.2
also 4 Felidae indet.
Aves indet.8