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=3558 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3558SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3231SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3558 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bos' AND (junior_species='taurus' OR junior_species='taurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bos' AND (species='taurus' OR species='taurus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bos' AND (junior_species='taurus' OR junior_species='taurus')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='Bos' AND (species='taurus' OR species='taurus') 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='Boselaphus' AND (junior_species='tragocamelus' OR junior_species='tragocamelus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boselaphus' AND (species='tragocamelus' OR species='tragocamelus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boselaphus' AND (junior_species='tragocamelus' OR junior_species='tragocamelus')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='Boselaphus' AND (species='tragocamelus' OR species='tragocamelus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Axis' AND (junior_species='axis' OR junior_species='axis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Axis' AND (species='axis' OR species='axis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Axis' AND (junior_species='axis' OR junior_species='axis')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='axis' OR species='axis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sus' AND (junior_species='scrofa' OR junior_species='scrofa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sus' AND (species='scrofa' OR species='scrofa') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sus' AND (junior_species='scrofa' OR junior_species='scrofa')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='scrofa' OR species='scrofa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' AND (junior_species='nigricollis' OR junior_species='nigricollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepus' AND (species='nigricollis' OR species='nigricollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lepus' AND (species='nigricollis' OR species='nigricollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' AND (junior_species='nigricollis' OR junior_species='nigricollis')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='nigricollis' OR species='nigricollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Osteichthyes' 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='Osteichthyes' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Osteichthyes' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Osteichthyes' 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='Osteichthyes' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3558 The Ecological Register: Khirsara (layer 1)
Khirsara (layer 1)
Basic information
Sample name: Khirsara (layer 1)

Sample aka: Gadhwali Wadi

Reference: P. P. Joglekar, G. S. Abhayan, J. Mungur-Medhi, and J. Nath. 2013. A glimpse of animal utilization pattern at Khirsara, Kachchh, Gujarat, India. Journal of Multidisciplinary Studies in Archaeology 1:1-15 [ER 3231]
Geography
Country: India

State: Gujarat


Coordinate: 23° 27' N, 69° 3' E
Coordinate basis: stated in text

Time interval: Holocene

Section: 3231

Unit number: 1

Unit order: above to below

Max Ma: 0.00445

Min Ma: 0.00385

Age basis: zone

Geography comments: near "Khirsara, a small village in western Kachchh" and the site is "locally known" as Gadhwali Wadi
"the entire deposit belongs to the mature phase of Harappan culture" (i.e., 25000 to 1900 B.C.: Possehl 2000)

•
Environment
Lithology: not described

Taphonomic context: human accumulation

Archaeology: bone tools,buildings

Habitat comments: a "fortified settlement, trapezoidal in shape (roughly 310 x 230 m)"
"Four bone fragments" appear to be tools; other tools are not discussed

Methods
Life forms: ungulates,other small mammals,fishes

Sampling methods: quarry

Sample size: 24 specimens

Years: 2010, 2011

Sampling comments: excavated "since 2010" and the material was "found during the last two seasons of excavations"

Metadata
Sample number: 3558

Contributor: John Alroy

Enterer: John Alroy

Created: 2019-09-23 18:03:48

Modified: 2023-04-29 02:20:43

Abundance distribution
7 species
3 singletons
total count 24
extrapolated richness: 20.1
Fisher's α: 3.322
geometric series k: 0.6368
Hurlbert's PIE: 0.5652
Shannon's H: 1.3122
Good's u: 0.8850
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Bos taurus indicus2337 kg
"Bos indicus"
Caprinae indet.15
goat or sheep
Boselaphus tragocamelus2263 kg browser-grazer
Axis axis140 kg browser-grazer
Sus scrofa154 kg herbivore
Lepus nigricollis2
Osteichthyes indet.1
"fish-large"