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=3797 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3797SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3412SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3797 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eremophilus' AND (junior_species='mustisii' OR junior_species='mustisi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eremophilus' AND (species='mustisii' OR species='mustisi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eremophilus' AND (species='mustisii' OR species='mustisi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eremophilus' AND (junior_species='mustisii' OR junior_species='mustisi')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='Eremophilus' AND (species='mustisii' OR species='mustisi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pygidium' AND (junior_species='bogotensis' OR junior_species='bogotensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pygidium' AND (species='bogotensis' OR species='bogotensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pygidium' AND (species='bogotensis' OR species='bogotensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pygidium' AND (junior_species='bogotensis' OR junior_species='bogotensis')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='Pygidium' AND (species='bogotensis' OR species='bogotensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kinosternon' AND (junior_species='leucostomum' OR junior_species='leucostomum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Kinosternon' AND (species='leucostomum' OR species='leucostomum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Kinosternon' AND (species='leucostomum' OR species='leucostomum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kinosternon' AND (junior_species='leucostomum' OR junior_species='leucostomum')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='Kinosternon' AND (species='leucostomum' OR species='leucostomum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anatidae' 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='Anatidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anatidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anatidae' 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='Anatidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Penelope' AND (junior_species='montagnii' OR junior_species='montagni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Penelope' AND (species='montagnii' OR species='montagni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Penelope' AND (species='montagnii' OR species='montagni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Penelope' AND (junior_species='montagnii' OR junior_species='montagni')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='Penelope' AND (species='montagnii' OR species='montagni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amazona' AND (junior_species='mercenaria' OR junior_species='mercenaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amazona' AND (species='mercenaria' OR species='mercenaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amazona' AND (species='mercenaria' OR species='mercenaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amazona' AND (junior_species='mercenaria' OR junior_species='mercenaria')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='Amazona' AND (species='mercenaria' OR species='mercenaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasypus' AND (junior_species='novemcinctus' OR junior_species='novemcinctus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dasypus' AND (species='novemcinctus' OR species='novemcinctus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasypus' AND (junior_species='novemcinctus' OR junior_species='novemcinctus')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='Dasypus' AND (species='novemcinctus' OR species='novemcinctus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leopardus' AND (junior_species='pardalis' OR junior_species='pardalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leopardus' AND (species='pardalis' OR species='pardalis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leopardus' AND (junior_species='pardalis' OR junior_species='pardalis')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='Leopardus' AND (species='pardalis' OR species='pardalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cerdocyon' AND (junior_species='thous' OR junior_species='thous')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cerdocyon' AND (species='thous' OR species='thous') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cerdocyon' AND (junior_species='thous' OR junior_species='thous')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='Cerdocyon' AND (species='thous' OR species='thous') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nasua' AND (junior_species='nasua' OR junior_species='nasua')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nasua' AND (species='nasua' OR species='nasua') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nasua' AND (junior_species='nasua' OR junior_species='nasua')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='Nasua' AND (species='nasua' OR species='nasua') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odocoileus' AND (junior_species='virginianus' OR junior_species='virginianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Odocoileus' AND (species='virginianus' OR species='virginianus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odocoileus' AND (junior_species='virginianus' OR junior_species='virginianus')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='Odocoileus' AND (species='virginianus' OR species='virginianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cavia' AND (junior_species='anolaimae' OR junior_species='anolaimae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cavia' AND (species='anolaimae' OR species='anolaimae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cavia' AND (species='anolaimae' OR species='anolaimae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cavia' AND (junior_species='anolaimae' OR junior_species='anolaimae')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='Cavia' AND (species='anolaimae' OR species='anolaimae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cavia' AND (junior_species='porcellus' OR junior_species='porcellus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cavia' AND (species='porcellus' OR species='porcellus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cavia' AND (species='porcellus' OR species='porcellus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cavia' AND (junior_species='porcellus' OR junior_species='porcellus')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='Cavia' AND (species='porcellus' OR species='porcellus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasyprocta' 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='Dasyprocta' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dasyprocta' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasyprocta' 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='Dasyprocta' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cuniculus' AND (junior_species='paca' OR junior_species='paca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cuniculus' AND (species='paca' OR species='paca') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cuniculus' AND (junior_species='paca' OR junior_species='paca')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='Cuniculus' AND (species='paca' OR species='paca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cuniculus' AND (junior_species='taczanowskii' OR junior_species='taczanowski')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cuniculus' AND (species='taczanowskii' OR species='taczanowski') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cuniculus' AND (species='taczanowskii' OR species='taczanowski')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cuniculus' AND (junior_species='taczanowskii' OR junior_species='taczanowski')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='Cuniculus' AND (species='taczanowskii' OR species='taczanowski') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3797 The Ecological Register: Aguazuque Occupation 1
Aguazuque Occupation 1
Basic information
Sample name: Aguazuque Occupation 1

Reference: M. F. Martínez-Polanco. 2019. Beyond white-tailed deer hunting in Aguazuque: Archaeofaunal data from an archaic site at Sabana de Bogotá, Colombia. International Journal of Osteoarchaeology 29(1):108-116 [ER 3412]
Geography
Country: Colombia

State: Soacha


Coordinate: 4° 36' 8" N, 74° 16' 35" W
Coordinate basis: based on nearby landmark

Time interval: Holocene

Ma: 0.005069

Age basis: radiocarbon (uncalibrated)

Geography comments: "in Soacha, Cundinamarca in the south of Bogotâ"
exact coordinate is given on Wikipedia
there is a single uncalibrated C14 date for this occupation of 5069 +/- 47 BP on bone

•
Environment
Lithology: not described

Taphonomic context: human accumulation

Habitat comments: "an open-air and multicomponent site, situated on a terrace"
"preceramic... faunal remains were associated with ritual practices with animals... found in smalls pits"
it is not clear what other archaeological features are present, if any, but lithics, structures, and burials are present in higher occupations

Methods
Life forms: carnivores,rodents,ungulates,other large mammals,birds,turtles,fishes

Sampling methods: quarry,screenwash

Sample size: 533 specimens

Sampled by: G. Correal

Sampling comments: "excavated by Gonzalo Correal in the 1980s. He excavated two test pits: Unit 1 (12 m2) and Unit 2 (16 grids of 2 × 2 m, 64 m2). On this site, faunal remains were collected manually; a screen mesh of 2 × 2 mm and sieves of 20 mm, 40 mm, and 60 mm were used to recover small fauna remains"

Metadata
Sample number: 3797

Contributor: John Alroy

Enterer: John Alroy

Created: 2021-06-10 20:26:14

Modified: 2021-06-10 10:26:14

Abundance distribution
16 species
7 singletons
total count 533
extrapolated richness: 35.4
Fisher's α: 3.106
geometric series k: 0.6993
Hurlbert's PIE: 0.7306
Shannon's H: 1.5509
Good's u: 0.9869
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Eremophilus mustisii129
Pygidium bogotensis45
Kinosternon leucostomum1
Anatidae indet.1
Penelope montagnii1706 g frugivore
Amazona mercenaria3340 g
Dasypus novemcinctus24.4 kg invertivore
Leopardus pardalis18.4 kg carnivore
Cerdocyon thous15.2 kg carnivore-frugivore
Nasua nasua14.4 kg invertivore-frugivore
Odocoileus virginianus21475 kg herbivore
Cavia anolaimae107
Cavia porcellus21
Dasyprocta sp.1
Cuniculus paca27.4 kg frugivore
Cuniculus taczanowskii3