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=3292 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3292SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3042SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3292 ORDER BY register_no ASCSELECT 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='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='Perameles' AND (junior_species='nasuta' OR junior_species='nasuta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perameles' AND (species='nasuta' OR species='nasuta') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perameles' AND (junior_species='nasuta' OR junior_species='nasuta')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='Perameles' AND (species='nasuta' OR species='nasuta') 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='Dasyurus' AND (junior_species='hallucatus' OR junior_species='hallucatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dasyurus' AND (species='hallucatus' OR species='hallucatus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasyurus' AND (junior_species='hallucatus' OR junior_species='hallucatus')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='hallucatus' OR species='hallucatus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3292
The Ecological Register: Davies Creek (mammals, early wet season)
Sample name: Davies Creek (mammals, early wet season)
Reference:K. Vernes, L. C. Pope, C. J. Hill, and F. Bärlocher. 2005. Seasonality, dung specificity and competition in dung beetle assemblages in the Australian Wet Tropics, north-eastern Australia. Journal of Tropical Ecology21:1-8 [ER 3042]
Habitat comments: "The study area was located in wet sclerophyll forest... The climate of the area is tropical, with a distinct wet season from January to April. Annual rainfall is probably about 1200-1400 mm, based on the nearby weather stations"
Methods
Life forms: rodents,other small mammals
Sampling methods: quadrat,baited,other traps
Sample size: 184 captures or sightings
Years: 1995 - 1997
Seasons: wet or monsoon
Nets or traps: 144
Net or trap nights: 1116
Sampling comments: "Mammals were trapped in collapsible platform cat traps... Nine trapping grids were used; the primary site as an 8 x 6-trap grid (48 traps in total)... where eight traps were spaced at 50-m intervals along each line, with the six traps spaced at 100-m intervals. Eight smaller 'satellite' grids, each consisting of 12 traps (three lines of four traps) were distributed evenly" and with the same spacing
"Trapping was undertaken as a series of ten field trips between February 1995 and January 1997. During each trapping period, each site was typically trapped for 3-5 consecutive nights. Traps were baited late each afternoon with a mixture of rolled oats, peanut butter, honey and vanilla essence rolled into small (30 mm diameter) balls... All dung beneath the trap was collected for dietary analyses... and all dung beetles associated with the dung were collected and immediately preserved"
this sample was collected between November and January
Metadata
Sample number: 3292
Contributor: John Alroy
Enterer: John Alroy
Created: 2019-03-24 18:15:53
Modified: 2019-03-24 07:17:26
Abundance distribution
5 species
1 singleton
total count 184
extrapolated richness: 6.6
Fisher's α: 0.948
geometric series k: 0.3178
Hurlbert's PIE: 0.5895
Shannon's H: 1.0657
Good's u: 0.9946
Each square represents a species. Square sizes are proportional to counts.