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=4176 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=4176SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3828SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=4176 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='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='Ovis' AND (junior_species='aries' OR junior_species='aries')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ovis' AND (species='aries' OR species='aries') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ovis' AND (junior_species='aries' OR junior_species='aries')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='Ovis' AND (species='aries' OR species='aries') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capra' AND (junior_species='aegagrus' OR junior_species='aegagrus')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Capra' AND (species='aegagrus' OR species='aegagrus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capra' AND (junior_species='aegagrus' OR junior_species='aegagrus')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''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='Capra' AND (species='aegagrus' OR species='aegagrus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervidae' 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='Cervidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cervidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervidae' 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='Cervidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gallus' AND (junior_species='gallus' OR junior_species='gallus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gallus' AND (species='gallus' OR species='gallus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gallus' AND (species='gallus' OR species='gallus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gallus' AND (junior_species='gallus' OR junior_species='gallus')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='Gallus' AND (species='gallus' OR species='gallus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=4176 The Ecological Register: Contrada Castro (Period A)
Contrada Castro (Period A)
Basic information
Sample name: Contrada Castro (Period A)

Reference: A. Castrorao Barba, C. Speciale, R. Miccichè, F. Pisciotta, C. Aleo Nero, P. Marino, and G. Bazan. 2021. The Sicilian countryside in the Early Middle Ages: human-environment interactions at Contrada Castro. Environmental Archaeology x:1-16 [ER 3828]
Geography
Country: Italy

State: Palermo


Coordinate: 37.77° N, 13.30° E
Coordinate basis: estimated from map

Time interval: Holocene

Section: 3828

Unit number: 1

Unit order: below to above

Max Ma: 0.0011

Min Ma: 0.00105

Age basis: other

Geography comments: estimated from satellite map based on Fig. 1
"late 8th-9th c. AD" based on a "typological study of the site" and on two confirming radiocarbon dates (only 1 sd ranges are given, and it is not clear if they are calibrated)

Environment
Lithology: not described

Taphonomic context: human accumulation,settlement

Archaeology: buildings,ceramics

Habitat comments: "a square building" with "pottery kilns" that yielded "production waste"
"35% of the identified elements bore evidence" of gnawing "likely caused by dogs" and there are also "dismembering marks made with large tools"

Methods
Life forms: ungulates,birds

Sample size: 79 specimens

Years: 2017 - 2019

Sampling comments: full counts of plant species based on seeds and wood charcoal are also given
there are two infant burials below the Period A building structure, immediately predating it

Metadata
Sample number: 4176

Contributor: John Alroy

Enterer: John Alroy

Created: 2023-03-20 19:59:53

Modified: 2023-05-30 06:22:17

Abundance distribution
6 species
1 singleton
total count 79
extrapolated richness: 8.5
Fisher's α: 1.509
geometric series k: 0.4940
Hurlbert's PIE: 0.6736
Shannon's H: 1.3220
Good's u: 0.9873
Each square represents a species. Square sizes are proportional to counts.
Register
Bos taurus34337 kg
Sus scrofa domesticus2754 kg herbivore
"Sus domesticus"
Ovis aries1041 kg
also 53 indeterminate ovines
Capra aegagrus hircus322 kg browser-grazer
"Capra hircus"
Cervidae indet.1
Cervus or Dama
Gallus gallus429.1 g frugivore-granivore