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=3849 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3849SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3684SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3849 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sarcophilus' 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='Sarcophilus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sarcophilus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sarcophilus' 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='Sarcophilus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thylacinus' AND (junior_species='cynocephalus' OR junior_species='cynocephalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thylacinus' AND (species='cynocephalus' OR species='cynocephalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thylacinus' AND (species='cynocephalus' OR species='cynocephalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thylacinus' AND (junior_species='cynocephalus' OR junior_species='cynocephalus')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='cynocephalus' OR species='cynocephalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diprotodon' 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='Diprotodon' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diprotodon' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diprotodon' 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='Diprotodon' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thylacoleo' AND (junior_species='carnifex' OR junior_species='carnifex')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thylacoleo' AND (species='carnifex' OR species='carnifex') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thylacoleo' AND (species='carnifex' OR species='carnifex')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thylacoleo' AND (junior_species='carnifex' OR junior_species='carnifex')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='Thylacoleo' AND (species='carnifex' OR species='carnifex') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Troposodon' AND (junior_species='minor' OR junior_species='minor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Troposodon' AND (species='minor' OR species='minor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Troposodon' AND (species='minor' OR species='minor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Troposodon' AND (junior_species='minor' OR junior_species='minor')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='Troposodon' AND (species='minor' OR species='minor') ORDER BY year,last_namesSELECT 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='Macropus' AND (junior_species='titan' OR junior_species='titan')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macropus' AND (species='titan' OR species='titan') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macropus' AND (species='titan' OR species='titan')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macropus' AND (junior_species='titan' OR junior_species='titan')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='Macropus' AND (species='titan' OR species='titan') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protemnodon' 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='Protemnodon' AND (species='anak' OR species='anak') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protemnodon' AND (species='anak' OR species='anak')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protemnodon' 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='Protemnodon' AND (species='anak' OR species='anak') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protemnodon' AND (junior_species='brehus' OR junior_species='brehus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protemnodon' AND (species='brehus' OR species='brehus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protemnodon' AND (species='brehus' OR species='brehus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protemnodon' AND (junior_species='brehus' OR junior_species='brehus')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='Protemnodon' AND (species='brehus' OR species='brehus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Velesunio' AND (junior_species='ambiguus' OR junior_species='ambiguus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Velesunio' AND (species='ambiguus' OR species='ambiguus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Velesunio' AND (species='ambiguus' OR species='ambiguus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Velesunio' AND (junior_species='ambiguus' OR junior_species='ambiguus')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='Velesunio' AND (species='ambiguus' OR species='ambiguus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corbicula' AND (junior_species='australis' OR junior_species='australis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Corbicula' AND (species='australis' OR species='australis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Corbicula' AND (species='australis' OR species='australis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corbicula' AND (junior_species='australis' OR junior_species='australis')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='Corbicula' AND (species='australis' OR species='australis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plotiopsis' AND (junior_species='balonnensis' OR junior_species='balonnensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Plotiopsis' AND (species='balonnensis' OR species='balonnensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plotiopsis' AND (species='balonnensis' OR species='balonnensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plotiopsis' AND (junior_species='balonnensis' OR junior_species='balonnensis')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='Plotiopsis' AND (species='balonnensis' OR species='balonnensis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3849
Reference:G. J. Price and I. H. Sobbe. 2005. Pleistocene palaeoecology and environmental change on the Darling Downs, Southeastern Queensland, Australia. Memoirs of the Queensland Museum51(1):171-201 [ER 3684]
Geography
Country: Australia
State: Queensland
Coordinate:27° 56' S, 151° 51' E
Coordinate basis: estimated from map
Time interval: Late Pleistocene
Section: 3684
Unit number: 1
Unit order: below to above
Max Ma: 0.0948
Min Ma: 0.0753
Age basis: U/Th
Geography comments: Site QML1396 is located in the Darling Downs, southeastern Queensland, which encompasses low rolling hills and plains west of the Great Dividing Range.
"QML1396 is exposed laterally over 70 metres in the southern bank of Kings Creek, in the southern Darling Downs".
U/Th series dates for Horizon B range from 94800 ± 3700 to 75300 ± 2700 BP (Price et al. 2011).
•
Environment
Lithology: siliciclastic (mixed)
Taphonomic context: fluvial deposit
Habitat comments: "Fluvial sediments of the region consist of clays, silts and sands that are generally derived from the erosion of Mesozoic sandstones and Miocene basalts of the Great Dividing Range".
"The modern Kings Creek catchment is fed by several mainly dry or intermittent watercourses, resulting in a relatively small geographic sampling area".
"As the Pleistocene catchment area was likely not markedly larger than present, it is unlikely that material from QML1396 was subjected to long distance fluvial transport".
"The entire deposit is characterised by a fining-upwards sequence ... with vertebrate fossil material generally restricted to Horizons B and D. The majority of the lower portion of Horizon B is below the modern water table".
Methods
Life forms: other large mammals,clams,snails
Sampling methods: screenwash
Sample size: 136 specimens
Sampling comments: "A section was measured representing the entire depositional sequence exposed in the creek bank".
"Fossils were recovered by in situ collecting and sieving of sediment specifically to target smaller specimens".
"Sediments were washed using graded sieves of 10 mm to 1 mm".
"Approximately 200 kg of sediment was processed from Horizon B".
Due to its position below the water table, "collecting of Horizon B was generally possible only during drought conditions", with most material collected in November and December 2002.
Metadata
Sample number: 3849
Contributor: Benjamin Carter
Enterer: Benjamin Carter
Created: 2022-01-18 16:27:55
Modified: 2023-09-11 10:47:29
Abundance distribution
12 species
6 singletons
total count 136
extrapolated richness: 29.5
Fisher's α: 3.174
geometric series k: 0.7007
Hurlbert's PIE: 0.7035
Shannon's H: 1.5020
Good's u: 0.9560
Each square represents a species. Square sizes are proportional to counts.