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=3880 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3880SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3693SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3880 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dromaius' AND (junior_species='novaehollandiae' OR junior_species='novaehollandiae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dromaius' AND (species='novaehollandiae' OR species='novaehollandiae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dromaius' AND (species='novaehollandiae' OR species='novaehollandiae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dromaius' AND (junior_species='novaehollandiae' OR junior_species='novaehollandiae')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='Dromaius' AND (species='novaehollandiae' OR species='novaehollandiae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chenonetta' AND (junior_species='jubata' OR junior_species='jubata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chenonetta' AND (species='jubata' OR species='jubata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chenonetta' AND (species='jubata' OR species='jubata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chenonetta' AND (junior_species='jubata' OR junior_species='jubata')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='Chenonetta' AND (species='jubata' OR species='jubata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tribonyx' AND (junior_species='mortierii' OR junior_species='mortieri')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tribonyx' AND (species='mortierii' OR species='mortieri') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tribonyx' AND (species='mortierii' OR species='mortieri')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tribonyx' AND (junior_species='mortierii' OR junior_species='mortieri')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='Tribonyx' AND (species='mortierii' OR species='mortieri') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vombatus' 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='Vombatus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vombatus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vombatus' 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='Vombatus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Propleopus' 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='Propleopus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Propleopus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Propleopus' 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='Propleopus' AND (species='sp.' OR species='sp.') 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='Notamacropus' 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='Notamacropus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Notamacropus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notamacropus' 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='Notamacropus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Osphranter' 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='Osphranter' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Osphranter' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Osphranter' 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='Osphranter' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protemnodon' 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='Protemnodon' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protemnodon' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protemnodon' 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='Protemnodon' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sthenurus' 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='Sthenurus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sthenurus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sthenurus' 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='Sthenurus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT 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='Zygomaturus' AND (junior_species='trilobus' OR junior_species='trilobus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zygomaturus' AND (species='trilobus' OR species='trilobus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zygomaturus' AND (species='trilobus' OR species='trilobus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zygomaturus' AND (junior_species='trilobus' OR junior_species='trilobus')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='Zygomaturus' AND (species='trilobus' OR species='trilobus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3880
The Ecological Register: Lancefield Swamp (Peel Trench, Mayne Site - 2004-2005 excavations)
Reference:J. Dortch, M. Cupper, R. Grün, B. Harpley, K. Lee, and J. Field. 2016. The timing and cause of megafauna mass deaths at Lancefield Swamp, south-eastern Australia. Quaternary Science Reviews145:161-182 [ER 3693]
Geography
Country: Australia
State: Victoria
Coordinate:37° 17' S, 144° 43' E
Coordinate basis: stated in text
Time interval: Late Pleistocene
Max Ma: 0.0729
Min Ma: 0.0311
Age basis: OSL
Geography comments: "Lancefield Swamp is a spring-fed swamp adjacent to the small town of Lancefield, in southern-central Victoria, Australia".
"The swamp is located on a 10 km wide shallow basalt plain in the upper catchment of the Maribyrnong Basin at 500 m asl".
A single OSL date from the bone bed of the Peel Trench at the Mayne site yielded a minimum age of 31.1 ± 2.9 ka BP. The underlying unit was dated to 72.9 ± 12.6 ka BP.
•
Environment
Lithology: siliciclastic (mixed)
Taphonomic context: lake deposit
Habitat comments: "The swamp features two depressions, one each at the western and eastern ends".
"The western depression is known as the Classic Site and the eastern depression as the Mayne Site".
The bone beds consist of mottled or speckled clay with >5% gravel. The sediment is unconsolidated and contains a dense, interlocking matrix of bones".
Taphonomic analysis indicates the faunal remains "represent an accumulation of multiple waterhole death events, impacted by some carnivore activity, with isolated areas of channel cutting and filling".
Methods
Life forms: other large mammals,other small mammals,birds
Sampling methods: quarry,screenwash
Sample size: 320 specimens
Years: 2004, 2005
Sampling comments: "Systematic excavation involved extending the Classic and Mayne Site trenches".
"In the Mayne Site ... in the area excavated by Peel (2001), all back fill was removed by hand and systematically excavated across ∼4 m2 north of the excavation trench.
"All sediment was wet-sieved through 3 and 5 mm mesh screens".
Metadata
Sample number: 3880
Contributor: Benjamin Carter
Enterer: Benjamin Carter
Created: 2022-02-03 17:30:25
Modified: 2022-02-03 23:54:03
Abundance distribution
12 species
5 singletons
total count 320
extrapolated richness: 23.7
Fisher's α: 2.461
geometric series k: 0.6104
Hurlbert's PIE: 0.4727
Shannon's H: 1.1053
Good's u: 0.9844
Each square represents a species. Square sizes are proportional to counts.