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=4358 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=4358SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3952SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=4358 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='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='Equus' AND (junior_species='ferus' OR junior_species='ferus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Equus' AND (species='ferus' OR species='ferus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='ferus' OR junior_species='ferus')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='ferus' OR species='ferus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyprinus' AND (junior_species='carpio' OR junior_species='carpio')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyprinus' AND (species='carpio' OR species='carpio') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyprinus' AND (species='carpio' OR species='carpio')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyprinus' AND (junior_species='carpio' OR junior_species='carpio')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='Cyprinus' AND (species='carpio' OR species='carpio') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Silurus' AND (junior_species='glanis' OR junior_species='glanis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Silurus' AND (species='glanis' OR species='glanis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Silurus' AND (species='glanis' OR species='glanis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Silurus' AND (junior_species='glanis' OR junior_species='glanis')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='Silurus' AND (species='glanis' OR species='glanis') 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=4358 The Ecological Register: Noviodunum (TPF sector, Getic period)
Noviodunum (TPF sector, Getic period)
Basic information
Sample name: Noviodunum (TPF sector, Getic period)

Reference: S. Stanc, A.-D. Stanica, L. Bejenaru, and M. Danu. 2021. Archaeological animal remains from Noviodunum fortress. International Journal of Conservation Science 12(1):195-204 [ER 3952]
Geography
Country: Romania


Coordinate: 45° 16' 12" N, 28° 39' 30" E
Coordinate basis: based on nearby landmark

Time interval: Holocene

Max Ma: 0.00235

Min Ma: 0.00215

Age basis: other

Geography comments: "about 3 km east of the actual town of Isaccea... from the TPF sector of Noviodunum" (coordinate based on Noviodunum)
"two archaeological complexes have been attributed to the Getic period (4th-3rd centuries BC), of which a pit contained faunal remains"

•
Environment
Lithology: not described

Taphonomic context: human accumulation,settlement

Archaeology: buildings

Habitat comments: there are many "Culturally derived fractured bones" and also "burn marks" and traces left by the teeth of other animals (dog most often"), so the "remains have a cultural origin"

Methods
Life forms: ungulates,birds,fishes

Sampling methods: quarry

Sample size: 23 specimens

Years: 2014

Sampling comments: "The faunal remains were hand-collected and not sieved"

Metadata
Sample number: 4358

Contributor: John Alroy

Enterer: John Alroy

Created: 2023-08-25 15:22:46

Modified: 2023-08-25 05:39:36

Abundance distribution
7 species
3 singletons
total count 23
extrapolated richness: 16.4
Fisher's α: 3.427
geometric series k: 0.6813
Hurlbert's PIE: 0.7292
Shannon's H: 1.6067
Good's u: 0.8696
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Bos taurus3337 kg
Caprinae indet.4
Ovis aries or Capra hircus
Sus scrofa domesticus1054 kg herbivore
"Sus domesticus"
Equus ferus caballus1422 kg
"Equus caballus"
Cyprinus carpio3
Silurus glanis1
Aves indet.1