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=3899 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3899SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3701SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3899 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrolagus' AND (junior_species='goodfellowi' OR junior_species='goodfellowii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendrolagus' AND (species='goodfellowi' OR species='goodfellowii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendrolagus' AND (species='goodfellowi' OR species='goodfellowii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrolagus' AND (junior_species='goodfellowi' OR junior_species='goodfellowii')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='Dendrolagus' AND (species='goodfellowi' OR species='goodfellowii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dorcopsulus' 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='Dorcopsulus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dorcopsulus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dorcopsulus' 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='Dorcopsulus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thylogale' 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='Thylogale' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thylogale' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thylogale' 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='Thylogale' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phalanger' AND (junior_species='carmelitae/vestitus' OR junior_species='carmelitae/vestitus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phalanger' AND (species='carmelitae/vestitus' OR species='carmelitae/vestitus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phalanger' AND (species='carmelitae/vestitus' OR species='carmelitae/vestitus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phalanger' AND (junior_species='carmelitae/vestitus' OR junior_species='carmelitae/vestitus')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='Phalanger' AND (species='carmelitae/vestitus' OR species='carmelitae/vestitus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phalanger' AND (junior_species='orientalis' OR junior_species='orientalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phalanger' AND (species='orientalis' OR species='orientalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phalanger' AND (species='orientalis' OR species='orientalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phalanger' AND (junior_species='orientalis' OR junior_species='orientalis')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='Phalanger' AND (species='orientalis' OR species='orientalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phalanger' AND (junior_species='gymnotis' OR junior_species='gymnotis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phalanger' AND (species='gymnotis' OR species='gymnotis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phalanger' AND (species='gymnotis' OR species='gymnotis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phalanger' AND (junior_species='gymnotis' OR junior_species='gymnotis')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='Phalanger' AND (species='gymnotis' OR species='gymnotis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudochirulus' AND (junior_species='forbesi' OR junior_species='forbesii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudochirulus' AND (species='forbesi' OR species='forbesii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudochirulus' AND (species='forbesi' OR species='forbesii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudochirulus' AND (junior_species='forbesi' OR junior_species='forbesii')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='Pseudochirulus' AND (species='forbesi' OR species='forbesii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudochirops' AND (junior_species='corinnae' OR junior_species='corinnae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudochirops' AND (species='corinnae' OR species='corinnae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudochirops' AND (species='corinnae' OR species='corinnae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudochirops' AND (junior_species='corinnae' OR junior_species='corinnae')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='Pseudochirops' AND (species='corinnae' OR species='corinnae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudochirops' AND (junior_species='cupreus' OR junior_species='cupreus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudochirops' AND (species='cupreus' OR species='cupreus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudochirops' AND (species='cupreus' OR species='cupreus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudochirops' AND (junior_species='cupreus' OR junior_species='cupreus')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='Pseudochirops' AND (species='cupreus' OR species='cupreus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Echymipera' 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='Echymipera' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Echymipera' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Echymipera' 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='Echymipera' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peroryctes' 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='Peroryctes' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Peroryctes' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peroryctes' 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='Peroryctes' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anisomys' AND (junior_species='imitator' OR junior_species='imitator')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anisomys' AND (species='imitator' OR species='imitator') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anisomys' AND (species='imitator' OR species='imitator')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anisomys' AND (junior_species='imitator' OR junior_species='imitator')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='Anisomys' AND (species='imitator' OR species='imitator') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyomys' AND (junior_species='goliath' OR junior_species='goliath')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hyomys' AND (species='goliath' OR species='goliath') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hyomys' AND (species='goliath' OR species='goliath')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyomys' AND (junior_species='goliath' OR junior_species='goliath')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='Hyomys' AND (species='goliath' OR species='goliath') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mallomys' AND (junior_species='rothschildi' OR junior_species='rothschildii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mallomys' AND (species='rothschildi' OR species='rothschildii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mallomys' AND (species='rothschildi' OR species='rothschildii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mallomys' AND (junior_species='rothschildi' OR junior_species='rothschildii')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='Mallomys' AND (species='rothschildi' OR species='rothschildii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uromys' AND (junior_species='caudimaculatus' OR junior_species='caudimaculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Uromys' AND (species='caudimaculatus' OR species='caudimaculatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Uromys' AND (species='caudimaculatus' OR species='caudimaculatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uromys' AND (junior_species='caudimaculatus' OR junior_species='caudimaculatus')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='Uromys' AND (species='caudimaculatus' OR species='caudimaculatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uromys' AND (junior_species='anak' OR junior_species='anak')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Uromys' AND (species='anak' OR species='anak') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Uromys' AND (species='anak' OR species='anak')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uromys' AND (junior_species='anak' OR junior_species='anak')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='Uromys' AND (species='anak' OR species='anak') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dobsonia' AND (junior_species='magna' OR junior_species='magna')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dobsonia' AND (species='magna' OR species='magna') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dobsonia' AND (species='magna' OR species='magna')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dobsonia' AND (junior_species='magna' OR junior_species='magna')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='Dobsonia' AND (species='magna' OR species='magna') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rousettus' AND (junior_species='amplexicaudatus' OR junior_species='amplexicaudatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rousettus' AND (species='amplexicaudatus' OR species='amplexicaudatus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rousettus' AND (junior_species='amplexicaudatus' OR junior_species='amplexicaudatus')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='Rousettus' AND (species='amplexicaudatus' OR species='amplexicaudatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipposideros' AND (junior_species='diadema' OR junior_species='diadema')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hipposideros' AND (species='diadema' OR species='diadema') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipposideros' AND (junior_species='diadema' OR junior_species='diadema')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='Hipposideros' AND (species='diadema' OR species='diadema') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thylacinus' 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='Thylacinus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thylacinus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thylacinus' 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='Thylacinus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pythonidae' 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='Pythonidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pythonidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pythonidae' 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='Pythonidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lizard' 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='Lizard' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lizard' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lizard' 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='Lizard' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Casuarius' AND (junior_species='bennetti' OR junior_species='bennettii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Casuarius' AND (species='bennetti' OR species='bennettii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Casuarius' AND (species='bennetti' OR species='bennettii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Casuarius' AND (junior_species='bennetti' OR junior_species='bennettii')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='Casuarius' AND (species='bennetti' OR species='bennettii') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3899
The Ecological Register: Kiowa Rockshelter (Level 7)
Reference:D. Gaffney, G. R. Summerhayes, S. Luu, J. Menzies, K. Douglass, M. Spitzer, and S. Bulmer. 2021. Small game hunting in montane rainforests: Specialised capture and broad spectrum foraging in the Late Pleistocene to Holocene New Guinea Highlands. Quaternary Science Reviews253:106742 [ER 3701]
Geography
Country: Papua New Guinea
State: Chimbu
Coordinate:5° 54' 30" S, 145° 8' 50" E
Time interval: Holocene
Section: 3701
Unit number: 5
Unit order: above to below
Max Ma: 0.008846
Min Ma: 0.0081
Age basis: radiocarbon (uncalibrated)
Geography comments: "Kiowa is an irregularly shaped limestone rockshelter, about 6 m × 5.5 m, located in Chimbu province of the Central New Guinea Highlands".
"A small tributary to the Mae River is located about 20 m from the site".
Dates for Levels 7-8 of the deposit range from 8846 ± 56 BP to 8100 ± 40 BP.
•
Environment
Lithology: limestone
Taphonomic context: human accumulation,rock shelter
Archaeology: bone tools,hearths,stone tools
Habitat comments: "Kiowa was first occupied during the terminal Pleistocene, with regular occupations continuing until the Mid-Late Holocene ... Level 3 represents the most recent undisturbed habitation deposit, with all underlying levels down to base of excavations characterised by radiating ash lenses, denoting short-duration hearths".
"Few bone and shell artefacts and pottery sherds were excavated from Kiowa; lithics comprise the bulk of the cultural material".
Methods
Life forms: bats,rodents,other large mammals,other small mammals,birds,lizards,snakes
Sampling methods: quarry
Sample size: 325 specimens
Years: 1960
Sampling comments: "During the 1960 excavations at Kiowa sieves were not used and specimens were collected by hand".
"Following excavation, all cranial and mandibular material along with worked bone, eggshell, and large bones were kept for later analysis. However, due to transportation difficulties only a small subsample of post-cranial material filling two c. 30 × 30 cm bags from each level was retained".
Metadata
Sample number: 3899
Contributor: Benjamin Carter
Enterer: Benjamin Carter
Created: 2022-02-19 11:29:30
Modified: 2023-04-29 06:14:46
Abundance distribution
23 species
9 singletons
total count 325
extrapolated richness: 49.7
Fisher's α: 5.653
geometric series k: 0.7815
Hurlbert's PIE: 0.5010
Shannon's H: 1.3901
Good's u: 0.9724
Each square represents a species. Square sizes are proportional to counts.