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=3994 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3994SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3746SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3994 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diprotodon' AND (junior_species='optatum' OR junior_species='optatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diprotodon' AND (species='optatum' OR species='optatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diprotodon' AND (species='optatum' OR species='optatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diprotodon' AND (junior_species='optatum' OR junior_species='optatum')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='optatum' OR species='optatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phascolonus' AND (junior_species='gigas' OR junior_species='gigas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phascolonus' AND (species='gigas' OR species='gigas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phascolonus' AND (species='gigas' OR species='gigas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phascolonus' AND (junior_species='gigas' OR junior_species='gigas')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='Phascolonus' AND (species='gigas' OR species='gigas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasiorhinus' AND (junior_species='latifrons' OR junior_species='latifrons')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasiorhinus' AND (species='latifrons' OR species='latifrons') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasiorhinus' AND (junior_species='latifrons' OR junior_species='latifrons')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='Lasiorhinus' AND (species='latifrons' OR species='latifrons') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sarcophilus' AND (junior_species='harrisii' OR junior_species='harrisi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sarcophilus' AND (species='harrisii' OR species='harrisi') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sarcophilus' AND (junior_species='harrisii' OR junior_species='harrisi')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='harrisii' OR species='harrisi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasyurus' AND (junior_species='viverrinus' OR junior_species='viverrinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dasyurus' AND (species='viverrinus' OR species='viverrinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dasyurus' AND (species='viverrinus' OR species='viverrinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasyurus' AND (junior_species='viverrinus' OR junior_species='viverrinus')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='Dasyurus' AND (species='viverrinus' OR species='viverrinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasycercus' AND (junior_species='cristicauda' OR junior_species='cristicauda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dasycercus' AND (species='cristicauda' OR species='cristicauda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dasycercus' AND (species='cristicauda' OR species='cristicauda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasycercus' AND (junior_species='cristicauda' OR junior_species='cristicauda')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='Dasycercus' AND (species='cristicauda' OR species='cristicauda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macropus' AND (junior_species='ferragus' OR junior_species='ferragus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macropus' AND (species='ferragus' OR species='ferragus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macropus' AND (species='ferragus' OR species='ferragus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macropus' AND (junior_species='ferragus' OR junior_species='ferragus')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='ferragus' OR species='ferragus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notamacropus' AND (junior_species='eugenii' OR junior_species='eugeni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Notamacropus' AND (species='eugenii' OR species='eugeni') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notamacropus' AND (junior_species='eugenii' OR junior_species='eugeni')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='eugenii' OR species='eugeni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Osphranter' AND (junior_species='rufus' OR junior_species='rufus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Osphranter' AND (species='rufus' OR species='rufus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Osphranter' AND (junior_species='rufus' OR junior_species='rufus')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='rufus' OR species='rufus') 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='Onychogalea' AND (junior_species='lunata' OR junior_species='lunata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onychogalea' AND (species='lunata' OR species='lunata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onychogalea' AND (species='lunata' OR species='lunata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onychogalea' AND (junior_species='lunata' OR junior_species='lunata')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='Onychogalea' AND (species='lunata' OR species='lunata') 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='Protemnodon' AND (junior_species='roechus' OR junior_species='roechus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protemnodon' AND (species='roechus' OR species='roechus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protemnodon' AND (species='roechus' OR species='roechus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protemnodon' AND (junior_species='roechus' OR junior_species='roechus')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='roechus' OR species='roechus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sthenurus' AND (junior_species='atlas' OR junior_species='atlas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sthenurus' AND (species='atlas' OR species='atlas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sthenurus' AND (species='atlas' OR species='atlas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sthenurus' AND (junior_species='atlas' OR junior_species='atlas')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='Sthenurus' AND (species='atlas' OR species='atlas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sthenurus' AND (junior_species='tindalei' OR junior_species='tindaleii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sthenurus' AND (species='tindalei' OR species='tindaleii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sthenurus' AND (species='tindalei' OR species='tindaleii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sthenurus' AND (junior_species='tindalei' OR junior_species='tindaleii')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='Sthenurus' AND (species='tindalei' OR species='tindaleii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bettongia' AND (junior_species='lesueur' OR junior_species='lesueur')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bettongia' AND (species='lesueur' OR species='lesueur') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bettongia' AND (species='lesueur' OR species='lesueur')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bettongia' AND (junior_species='lesueur' OR junior_species='lesueur')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='lesueur' OR species='lesueur') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bettongia' AND (junior_species='penicillata' OR junior_species='penicillata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bettongia' AND (species='penicillata' OR species='penicillata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bettongia' AND (species='penicillata' OR species='penicillata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bettongia' AND (junior_species='penicillata' OR junior_species='penicillata')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='penicillata' OR species='penicillata') 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 senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leporillus' AND (junior_species='apicalis' OR junior_species='apicalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leporillus' AND (species='apicalis' OR species='apicalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leporillus' AND (species='apicalis' OR species='apicalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leporillus' AND (junior_species='apicalis' OR junior_species='apicalis')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='Leporillus' AND (species='apicalis' OR species='apicalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leporillus' AND (junior_species='conditor' OR junior_species='conditor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leporillus' AND (species='conditor' OR species='conditor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leporillus' AND (species='conditor' OR species='conditor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leporillus' AND (junior_species='conditor' OR junior_species='conditor')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='Leporillus' AND (species='conditor' OR species='conditor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aspidites' AND (junior_species='ramsayi' OR junior_species='ramsayii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aspidites' AND (species='ramsayi' OR species='ramsayii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aspidites' AND (species='ramsayi' OR species='ramsayii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aspidites' AND (junior_species='ramsayi' OR junior_species='ramsayii')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='Aspidites' AND (species='ramsayi' OR species='ramsayii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tiliqua' AND (junior_species='rugosa' OR junior_species='rugosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tiliqua' AND (species='rugosa' OR species='rugosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tiliqua' AND (species='rugosa' OR species='rugosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tiliqua' AND (junior_species='rugosa' OR junior_species='rugosa')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='Tiliqua' AND (species='rugosa' OR species='rugosa') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3994
Reference:R. Grün, R. Wells, S. Eggins, N. Spooner, M. Aubert, L. Brown, and E. Rhodes. 2008. Electron spin resonance dating of South Australian megafauna sites. Australian Journal of Earth Sciences55:917-935 [ER 3746]
Geography
Country: Australia
State: South Australia
Coordinate:32° 28' S, 137° 42' E
Coordinate basis: stated in text
Time interval: Late Pleistocene
Max Ma: 0.061
Min Ma: 0.047
Age basis: ESR
Geography comments: Cooper's Dune is an eroding sand dune located on the shore of Dempsey Lake, near Port Augusta, South Australia.
Robust closed system U-series ESR (CSUS-ESR) age estimates on megafauna from the Cooper's Dune deposit range from 61-47 ka.
•
Environment
Lithology: sandstone
Taphonomic context: aeolian deposit
Habitat comments: "The eroded surface of Cooper’s Dune is covered by a lag of bones, stones and stone artefacts, that have derived from wind deflation of the bed of Dempsey Lake, which is now an ephemeral lake".
"There are two stratigraphic horizons beneath the modern sand drift. The upper is a reddish-brown sand containing the remains of burrowing marsupials as well as evidence of human occupation. The lower horizon was a carbonate-cemented light-brown sand containing carbonate-encrusted shells of land snails and bones of extinct megafauna. The megafaunal remains are thus not contemporaneous with the artefacts".
"Coring of the dune revealed several carbonate-cemented horizons indicating that the dune represented a series of intermittent aeolian events rather than a single period of intense aeolian activity. Some articulated vertebrate remains have been collected in situ, but most are fragmentary and widely scattered. Sand movement has probably contributed to this dispersal, but there is also evidence of scavenger activity".
Methods
Life forms: rodents,other large mammals,other small mammals,lizards,snakes
Sampling methods: surface
Sample size: 754 specimens
Sampled by: D. L. G. Williams
Years: 1979
Sampling comments: No specific excavation details are available. The faunal counts were collected by the sample enterer during a collections visit to the South Australian Museum in September 2022.
In addition to the counts below, numerous gastropod shells and eggshell fragments (mostly of Genyornis newtoni) were also present. Counts of these specimens were not obtained due to time constraints.
Metadata
Sample number: 3994
Contributor: Benjamin Carter
Enterer: Benjamin Carter
Created: 2022-09-09 14:09:24
Modified: 2022-09-09 06:19:25
Abundance distribution
22 species
4 singletons
total count 754
extrapolated richness: 30.8
Fisher's α: 4.242
geometric series k: 0.7573
Hurlbert's PIE: 0.7526
Shannon's H: 1.9573
Good's u: 0.9947
Each square represents a species. Square sizes are proportional to counts.