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=1670 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1670SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1145SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1670 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crinia' AND (junior_species='georgiana' OR junior_species='georgiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crinia' AND (species='georgiana' OR species='georgiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crinia' AND (species='georgiana' OR species='georgiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crinia' AND (junior_species='georgiana' OR junior_species='georgiana')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='Crinia' AND (species='georgiana' OR species='georgiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helioporus' AND (junior_species='inornatus' OR junior_species='inornatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Helioporus' AND (species='inornatus' OR species='inornatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Helioporus' AND (species='inornatus' OR species='inornatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helioporus' AND (junior_species='inornatus' OR junior_species='inornatus')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='Helioporus' AND (species='inornatus' OR species='inornatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnodynastes' AND (junior_species='dorsalis' OR junior_species='dorsalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Limnodynastes' AND (species='dorsalis' OR species='dorsalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Limnodynastes' AND (species='dorsalis' OR species='dorsalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnodynastes' AND (junior_species='dorsalis' OR junior_species='dorsalis')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='Limnodynastes' AND (species='dorsalis' OR species='dorsalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Christinus' AND (junior_species='marmoratus' OR junior_species='marmoratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Christinus' AND (species='marmoratus' OR species='marmoratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Christinus' AND (species='marmoratus' OR species='marmoratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Christinus' AND (junior_species='marmoratus' OR junior_species='marmoratus')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='Christinus' AND (species='marmoratus' OR species='marmoratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplodactylus' AND (junior_species='lateroides' OR junior_species='lateroides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diplodactylus' AND (species='lateroides' OR species='lateroides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diplodactylus' AND (species='lateroides' OR species='lateroides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplodactylus' AND (junior_species='lateroides' OR junior_species='lateroides')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='Diplodactylus' AND (species='lateroides' OR species='lateroides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pogona' 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='Pogona' AND (species='minor' OR species='minor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pogona' AND (species='minor' OR species='minor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pogona' 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='Pogona' AND (species='minor' OR species='minor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acritoscincus' AND (junior_species='trilineatus' OR junior_species='trilineatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acritoscincus' AND (species='trilineatus' OR species='trilineatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acritoscincus' AND (species='trilineatus' OR species='trilineatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acritoscincus' AND (junior_species='trilineatus' OR junior_species='trilineatus')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='Acritoscincus' AND (species='trilineatus' OR species='trilineatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptoblepharus' AND (junior_species='buchananii' OR junior_species='buchanani')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cryptoblepharus' AND (species='buchananii' OR species='buchanani') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cryptoblepharus' AND (species='buchananii' OR species='buchanani')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptoblepharus' AND (junior_species='buchananii' OR junior_species='buchanani')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='Cryptoblepharus' AND (species='buchananii' OR species='buchanani') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenotus' AND (junior_species='delli' OR junior_species='dellii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ctenotus' AND (species='delli' OR species='dellii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ctenotus' AND (species='delli' OR species='dellii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenotus' AND (junior_species='delli' OR junior_species='dellii')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='Ctenotus' AND (species='delli' OR species='dellii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenotus' AND (junior_species='labilladieri' OR junior_species='labilladierii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ctenotus' AND (species='labilladieri' OR species='labilladierii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ctenotus' AND (species='labilladieri' OR species='labilladierii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenotus' AND (junior_species='labilladieri' OR junior_species='labilladierii')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='Ctenotus' AND (species='labilladieri' OR species='labilladierii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Egernia' AND (junior_species='napoleonis' OR junior_species='napoleonis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Egernia' AND (species='napoleonis' OR species='napoleonis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Egernia' AND (species='napoleonis' OR species='napoleonis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Egernia' AND (junior_species='napoleonis' OR junior_species='napoleonis')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='Egernia' AND (species='napoleonis' OR species='napoleonis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemiergis' AND (junior_species='initialis' OR junior_species='initialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemiergis' AND (species='initialis' OR species='initialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemiergis' AND (species='initialis' OR species='initialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemiergis' AND (junior_species='initialis' OR junior_species='initialis')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='Hemiergis' AND (species='initialis' OR species='initialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lerista' AND (junior_species='distinguenda' OR junior_species='distinguenda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lerista' AND (species='distinguenda' OR species='distinguenda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lerista' AND (species='distinguenda' OR species='distinguenda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lerista' AND (junior_species='distinguenda' OR junior_species='distinguenda')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='Lerista' AND (species='distinguenda' OR species='distinguenda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Menetia' AND (junior_species='greyii' OR junior_species='greyi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Menetia' AND (species='greyii' OR species='greyi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Menetia' AND (species='greyii' OR species='greyi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Menetia' AND (junior_species='greyii' OR junior_species='greyi')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='Menetia' AND (species='greyii' OR species='greyi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Morethia' AND (junior_species='obscura' OR junior_species='obscura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Morethia' AND (species='obscura' OR species='obscura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Morethia' AND (species='obscura' OR species='obscura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Morethia' AND (junior_species='obscura' OR junior_species='obscura')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='Morethia' AND (species='obscura' OR species='obscura') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1670 The Ecological Register: Huntly Mine (frogs and lizards)
Huntly Mine (frogs and lizards)
Basic information
Sample name: Huntly Mine (frogs and lizards)

Reference: M. D. Craig, A. H. Grigg, R. J. Hobbs, and G. E. S. J. Hardy. 2014. Does coarse woody debris density and volume influence the terrestrial vertebrate community in restored bauxite mines?. Forest Ecology and Management 318:142-150 [ER 1145]
Geography
Country: Australia

State: Western Australia


Coordinate: 32° 36' S, 116° 6' E
Coordinate basis: stated in text

Geography comments: "approximately 10 km north of Dwellingup in the northern jarrah forest of south-west Western Australia"
elevation is for the Huntly Bauxite Mine and is from Kew and Gilkes (2006, Geoderma)

•
Environment
Habitat: Mediterranean woodland

Altered habitat: secondary forest

Substrate: ground surface

Disturbance: mining

MAP: 1240.0

Habitat comments: "Mediterranean, with cool, wet winters and warm, dry summers... The jarrah forest prior to mining is dominated by two eucalypts, E. marginata and Corymbia calophylla... the minesite consists of a mosaic of unmined jarrah forest and restored mine pits of varying ages"

Methods
Life forms: lizards,frogs

Sites: 12

Sampling methods: line transect,drift fences,funnel traps,pitfall traps

Sample size: 213 individuals

Years: 2006, 2007

Days: 16

Seasons: winter,spring,summer,autumn

Nets or traps: 132

Net or trap nights: 2112

Sampling comments: "12 three-year old restored mine pits chosen to cover a broad range of habitat pile densities... We sampled terrestrial vertebrates using single trapping arrays at each site, which consisted of nine pit-traps... located every 3 m along 29 m aluminium fly-wire drift-fences, two paired funnel traps placed along drift fences, approximately 7 m from each end, four Elliott traps placed 5 m either side of the two end pit-traps and single Sheffield cage-traps placed at one end of the drift fence... Vertebrates on all arrays were sampled for four consecutive nights in spring (9th to 13th October 2006), summer (27th November to 1st December 2006), autumn (12th to 16th March 2007) and winter (7th to 11th May 2007). All reptiles and mammals captured were individually marked and released at their site of capture" (frogs and lizards are assumed to have been captured using pitfall and funnel traps)

Metadata
Sample number: 1670

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-07-03 11:19:59

Modified: 2018-06-09 06:25:09

Abundance distribution
15 species
3 singletons
total count 213
extrapolated richness: 24.0
Fisher's α: 3.681
geometric series k: 0.7326
Hurlbert's PIE: 0.7855
Shannon's H: 1.9127
Good's u: 0.9861
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Crinia georgiana78
Helioporus inornatus2
Limnodynastes dorsalis1
Christinus marmoratus1
Diplodactylus lateroides8
Pogona minor2
Acritoscincus trilineatus24
Cryptoblepharus buchananii2
Ctenotus delli1
Ctenotus labilladieri6
Egernia napoleonis10
Hemiergis initialis9
Lerista distinguenda2
Menetia greyii18
Morethia obscura49