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=3848 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3848SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3683SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3848 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notamacropus' AND (junior_species='agilis' OR junior_species='agilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Notamacropus' AND (species='agilis' OR species='agilis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notamacropus' AND (junior_species='agilis' OR junior_species='agilis')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='Notamacropus' AND (species='agilis' OR species='agilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notamacropus' AND (junior_species='parryi' OR junior_species='parryii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Notamacropus' AND (species='parryi' OR species='parryii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Notamacropus' AND (species='parryi' OR species='parryii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notamacropus' AND (junior_species='parryi' OR junior_species='parryii')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='Notamacropus' AND (species='parryi' OR species='parryii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Osphranter' AND (junior_species='robustus' OR junior_species='robustus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Osphranter' AND (species='robustus' OR species='robustus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Osphranter' AND (junior_species='robustus' OR junior_species='robustus')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='Osphranter' AND (species='robustus' OR species='robustus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Petrogale' 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='Petrogale' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Petrogale' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Petrogale' 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='Petrogale' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Petaurus' AND (junior_species='norfolcensis' OR junior_species='norfolcensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Petaurus' AND (species='norfolcensis' OR species='norfolcensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Petaurus' AND (species='norfolcensis' OR species='norfolcensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Petaurus' AND (junior_species='norfolcensis' OR junior_species='norfolcensis')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='Petaurus' AND (species='norfolcensis' OR species='norfolcensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Isoodon' AND (junior_species='macrourus' OR junior_species='macrourus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Isoodon' AND (species='macrourus' OR species='macrourus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Isoodon' AND (junior_species='macrourus' OR junior_species='macrourus')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='Isoodon' AND (species='macrourus' OR species='macrourus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bettongia' AND (junior_species='tropica' OR junior_species='tropica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bettongia' AND (species='tropica' OR species='tropica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bettongia' AND (species='tropica' OR species='tropica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bettongia' AND (junior_species='tropica' OR junior_species='tropica')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='Bettongia' AND (species='tropica' OR species='tropica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phascogale' AND (junior_species='tapoatafa' OR junior_species='tapoatafa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phascogale' AND (species='tapoatafa' OR species='tapoatafa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phascogale' AND (species='tapoatafa' OR species='tapoatafa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phascogale' AND (junior_species='tapoatafa' OR junior_species='tapoatafa')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='Phascogale' AND (species='tapoatafa' OR species='tapoatafa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sminthopsis' AND (junior_species='murina' OR junior_species='murina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sminthopsis' AND (species='murina' OR species='murina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sminthopsis' AND (species='murina' OR species='murina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sminthopsis' AND (junior_species='murina' OR junior_species='murina')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='Sminthopsis' AND (species='murina' OR species='murina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conilurus' AND (junior_species='penicillatus' OR junior_species='penicillatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Conilurus' AND (species='penicillatus' OR species='penicillatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Conilurus' AND (species='penicillatus' OR species='penicillatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conilurus' AND (junior_species='penicillatus' OR junior_species='penicillatus')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='Conilurus' AND (species='penicillatus' OR species='penicillatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesembriomys' AND (junior_species='gouldii' OR junior_species='gouldi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mesembriomys' AND (species='gouldii' OR species='gouldi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mesembriomys' AND (species='gouldii' OR species='gouldi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesembriomys' AND (junior_species='gouldii' OR junior_species='gouldi')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='Mesembriomys' AND (species='gouldii' OR species='gouldi') 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='Rattus' AND (junior_species='tunneyi' OR junior_species='tunneyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rattus' AND (species='tunneyi' OR species='tunneyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rattus' AND (species='tunneyi' OR species='tunneyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rattus' AND (junior_species='tunneyi' OR junior_species='tunneyii')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='Rattus' AND (species='tunneyi' OR species='tunneyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melomys' AND (junior_species='burtoni' OR junior_species='burtonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melomys' AND (species='burtoni' OR species='burtonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melomys' AND (species='burtoni' OR species='burtonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melomys' AND (junior_species='burtoni' OR junior_species='burtonii')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='Melomys' AND (species='burtoni' OR species='burtonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zyzomys' AND (junior_species='argurus' OR junior_species='argurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zyzomys' AND (species='argurus' OR species='argurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zyzomys' AND (species='argurus' OR species='argurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zyzomys' AND (junior_species='argurus' OR junior_species='argurus')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='Zyzomys' AND (species='argurus' OR species='argurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudomys' AND (junior_species='gracilicaudatus' OR junior_species='gracilicaudatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudomys' AND (species='gracilicaudatus' OR species='gracilicaudatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudomys' AND (species='gracilicaudatus' OR species='gracilicaudatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudomys' AND (junior_species='gracilicaudatus' OR junior_species='gracilicaudatus')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='Pseudomys' AND (species='gracilicaudatus' OR species='gracilicaudatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudomys' AND (junior_species='patrius' OR junior_species='patrius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudomys' AND (species='patrius' OR species='patrius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudomys' AND (species='patrius' OR species='patrius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudomys' AND (junior_species='patrius' OR junior_species='patrius')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='Pseudomys' AND (species='patrius' OR species='patrius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudomys' 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='Pseudomys' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudomys' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudomys' 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='Pseudomys' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3848 The Ecological Register: Hay Cave (SU3)
Hay Cave (SU3)
Basic information
Sample name: Hay Cave (SU3)

Reference: H. Lourandos, B. David, N. Roche, C. Rowe, A. Holden, and S. J. Clarke. 2012. Hay Cave: A 30 000 year cultural sequence from the Mitchell-Palmer limestone zone, north Queensland, Australia. In Peopled landscapes: archaeological and biogeographic approaches to landscapes (eds. S. Haberle, B. David), pp. 27-63 [ER 3683]
Geography
Country: Australia

State: Queensland


Coordinate: 16° 6' S, 144° 7' E
Coordinate basis: stated in text

Time interval: Late Pleistocene

Max Ma: 0.032

Min Ma: 0.02324

Age basis: radiocarbon (uncalibrated)

Geography comments: "Hay Cave is a large limestone cave positioned between the Mitchell and Palmer rivers, towards the northern limits of the Mitchell-Palmer limestone belt, 140 km west of the eastern Australian coastline" in Far-North Queensland.
Stratigraphic Unit 3 (SU3) contains the deepest excavated levels, with a near-basal date of 29,700 ± 1100 BP from XU60. The three deeper excavation units were likely deposited from around 32,000 years ago. The upper boundary layer of SU3 has a radiocarbon date of 23,240 ± 320 BP.

•
Environment
Lithology: limestone

Taphonomic context: cave

Archaeology: stone tools

Habitat comments: The lowermost stratigraphic unit (SU3) is highly compact and clayey. It is culturally sterile compared to the upper units, with no stratigraphic evidence of hearths, although several flaked stone artefacts were present.
The few stone artefacts suggest overall low levels of site use during this time.

Methods
Life forms: rodents,other large mammals,other small mammals

Sampling methods: quarry,screenwash

Sample size: 105 specimens

Years: 1996

Sampling comments: Archaeological excavations were undertaken in 1996.
"Four juxtaposed 50 x 50 cm squares were excavated, the deepest of which (M30) was removed in 63 Excavation Units (XU) of mean 2.0 cm thickness and following Stratigraphic Units (SU) where visible".
"All sediments were sieved in 3 mm mesh sieves".

Metadata
Sample number: 3848

Contributor: Benjamin Carter

Enterer: Benjamin Carter

Created: 2022-01-18 13:03:49

Modified: 2022-01-18 06:01:06

Abundance distribution
18 species
10 singletons
total count 105
extrapolated richness: 56.4
Fisher's α: 6.253
geometric series k: 0.7954
Hurlbert's PIE: 0.7098
Shannon's H: 1.7810
Good's u: 0.9053
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Notamacropus agilis114 kg browser-grazer
"Macropus agilis"
Notamacropus parryi5
"Macropus parryi"
Osphranter robustus114 kg
"Macropus robustus"
Petrogale sp.49
also 25 Macropodidae indet.
Petaurus norfolcensis2
Isoodon macrourus170.3 g
Bettongia tropica1
Phascogale tapoatafa1
also 1 Phascogale sp. and 2 Dasyuridae indet.
Sminthopsis murina1
Conilurus penicillatus6
Mesembriomys gouldii1
Uromys caudimaculatus1
Rattus tunneyi2
also 13 Rattus sp.
Melomys burtoni3
Zyzomys argurus1
Pseudomys gracilicaudatus26
Pseudomys patrius1
Pseudomys sp.2
"sp. 1"; also 156 Muridae indet.