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=3293 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3293SELECT 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=3293 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coptodactyla' AND (junior_species='subaenea' OR junior_species='subaenea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coptodactyla' AND (species='subaenea' OR species='subaenea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coptodactyla' AND (species='subaenea' OR species='subaenea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coptodactyla' AND (junior_species='subaenea' OR junior_species='subaenea')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='Coptodactyla' AND (species='subaenea' OR species='subaenea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='bornemisszanus' OR junior_species='bornemisszanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='bornemisszanus' OR species='bornemisszanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='bornemisszanus' OR species='bornemisszanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='bornemisszanus' OR junior_species='bornemisszanus')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='Onthophagus' AND (species='bornemisszanus' OR species='bornemisszanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='jangga' OR junior_species='jangga')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='jangga' OR species='jangga') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='jangga' OR species='jangga')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='jangga' OR junior_species='jangga')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='Onthophagus' AND (species='jangga' OR species='jangga') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3293
The Ecological Register: Davies Creek (dung beetles, early wet season)
Sample name: Davies Creek (dung beetles, 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: scarab beetles
Sampling methods: quadrat,hand capture
Sample size: 23 individuals
Years: 1995 - 1997
Seasons: wet or monsoon
Nets or traps: 144
Net or trap nights: 1116
Trap spacing: 0.05
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: 3293
Contributor: John Alroy
Enterer: John Alroy
Created: 2019-03-24 18:43:45
Modified: 2019-03-24 08:40:42
Abundance distribution
3 species
0 singletons
total count 23
extrapolated richness: 4.3
Fisher's α: 0.921
geometric series k: 0.3333
Hurlbert's PIE: 0.3340
Shannon's H: 0.6699
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.