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=676 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=676SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=349SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=676 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antitrogus' AND (junior_species='consanguineus' OR junior_species='consanguineus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Antitrogus' AND (species='consanguineus' OR species='consanguineus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Antitrogus' AND (species='consanguineus' OR species='consanguineus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antitrogus' AND (junior_species='consanguineus' OR junior_species='consanguineus')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='Antitrogus' AND (species='consanguineus' OR species='consanguineus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antitrogus' AND (junior_species='parvulus' OR junior_species='parvulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Antitrogus' AND (species='parvulus' OR species='parvulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Antitrogus' AND (species='parvulus' OR species='parvulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antitrogus' AND (junior_species='parvulus' OR junior_species='parvulus')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='Antitrogus' AND (species='parvulus' OR species='parvulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepidiota' AND (junior_species='crinita' OR junior_species='crinita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepidiota' AND (species='crinita' OR species='crinita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lepidiota' AND (species='crinita' OR species='crinita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepidiota' AND (junior_species='crinita' OR junior_species='crinita')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='Lepidiota' AND (species='crinita' OR species='crinita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepidiota' AND (junior_species='negatoria' OR junior_species='negatoria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepidiota' AND (species='negatoria' OR species='negatoria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lepidiota' AND (species='negatoria' OR species='negatoria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepidiota' AND (junior_species='negatoria' OR junior_species='negatoria')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='Lepidiota' AND (species='negatoria' OR species='negatoria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anoplognathus' AND (junior_species='boisduvalii' OR junior_species='boisduvali')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anoplognathus' AND (species='boisduvalii' OR species='boisduvali') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anoplognathus' AND (species='boisduvalii' OR species='boisduvali')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anoplognathus' AND (junior_species='boisduvalii' OR junior_species='boisduvali')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='Anoplognathus' AND (species='boisduvalii' OR species='boisduvali') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anoplognathus' AND (junior_species='pallidicollis' OR junior_species='pallidicollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anoplognathus' AND (species='pallidicollis' OR species='pallidicollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anoplognathus' AND (species='pallidicollis' OR species='pallidicollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anoplognathus' AND (junior_species='pallidicollis' OR junior_species='pallidicollis')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='Anoplognathus' AND (species='pallidicollis' OR species='pallidicollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anoplognathus' AND (junior_species='porosus' OR junior_species='porosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anoplognathus' AND (species='porosus' OR species='porosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anoplognathus' AND (species='porosus' OR species='porosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anoplognathus' AND (junior_species='porosus' OR junior_species='porosus')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='Anoplognathus' AND (species='porosus' OR species='porosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasygnathus' AND (junior_species='trituberculatus' OR junior_species='trituberculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dasygnathus' AND (species='trituberculatus' OR species='trituberculatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dasygnathus' AND (species='trituberculatus' OR species='trituberculatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasygnathus' AND (junior_species='trituberculatus' OR junior_species='trituberculatus')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='Dasygnathus' AND (species='trituberculatus' OR species='trituberculatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Repsimus' AND (junior_species='aeneus' OR junior_species='aeneus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Repsimus' AND (species='aeneus' OR species='aeneus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Repsimus' AND (species='aeneus' OR species='aeneus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Repsimus' AND (junior_species='aeneus' OR junior_species='aeneus')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='Repsimus' AND (species='aeneus' OR species='aeneus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xylotrupes' AND (junior_species='gideon' OR junior_species='gideon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xylotrupes' AND (species='gideon' OR species='gideon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xylotrupes' AND (species='gideon' OR species='gideon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xylotrupes' AND (junior_species='gideon' OR junior_species='gideon')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='Xylotrupes' AND (species='gideon' OR species='gideon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metanastes' AND (junior_species='vulgivagus' OR junior_species='vulgivagus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Metanastes' AND (species='vulgivagus' OR species='vulgivagus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Metanastes' AND (species='vulgivagus' OR species='vulgivagus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metanastes' AND (junior_species='vulgivagus' OR junior_species='vulgivagus')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='Metanastes' AND (species='vulgivagus' OR species='vulgivagus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neodon' AND (junior_species='pecuarius' OR junior_species='pecuarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neodon' AND (species='pecuarius' OR species='pecuarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neodon' AND (species='pecuarius' OR species='pecuarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neodon' AND (junior_species='pecuarius' OR junior_species='pecuarius')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='Neodon' AND (species='pecuarius' OR species='pecuarius') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=676 The Ecological Register: Northeast of Bundaberg (1990 - 1991)
Northeast of Bundaberg (1990 - 1991)
Basic information
Sample name: Northeast of Bundaberg (1990 - 1991)

Reference: P. G. Allsopp and D. P. Logan. 1999. Seasonal flight activity of scarab beetles (Coleoptera: Scarabaeidae) associated with sugarcane in southern Queensland. Australian Journal of Entomology 38:219-226 [ER 349]
Geography
Country: Australia

State: Queensland


Coordinate: 24° 51' S, 152° 21' E
Coordinate basis: based on nearby landmark

Geography comments: "9 km north-east of Bundaberg" (basis of coordinate)

•
Environment
Habitat: tropical/subtropical dry broadleaf forest

Altered habitat: plantation

Substrate: ground surface

WMT: 27.1

CMT: 17.8

MAP: 985.0

Habitat comments: "sugarcane" (original environment assumed to be dry broadleaf based on Wikipedia climate data for Bundaberg)
climate data based on station 94380 (Gladstone)

Methods
Life forms: scarab beetles

Sites: 1

Sampling methods: no design,light traps

Sample size: 2240 individuals

Years: 1990, 1991

Days: 721

Nets or traps: 1

Net or trap nights: 721

Sampling comments: a single Minnesota light trap run every night over 103 weeks

Metadata
Sample number: 676

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-31 10:58:37

Modified: 2015-10-02 08:42:30

Abundance distribution
12 species
2 singletons
total count 2240
extrapolated richness: 15.4
Fisher's α: 1.666
geometric series k: 0.5427
Hurlbert's PIE: 0.7126
Shannon's H: 1.4756
Good's u: 0.9991
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Antitrogus consanguineus39
Antitrogus parvulus1
Lepidiota crinita6
Lepidiota negatoria1
Anoplognathus boisduvalii831
Anoplognathus pallidicollis3
Anoplognathus porosus234
Dasygnathus trituberculatus22
Repsimus aeneus255
Xylotrupes gideon24
Metanastes vulgivagus792
Neodon pecuarius32