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=666 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=666SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=343SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=666 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphistomus' AND (junior_species='calcaratus' OR junior_species='calcaratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amphistomus' AND (species='calcaratus' OR species='calcaratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amphistomus' AND (species='calcaratus' OR species='calcaratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphistomus' AND (junior_species='calcaratus' OR junior_species='calcaratus')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='Amphistomus' AND (species='calcaratus' OR species='calcaratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphistomus' AND (junior_species='complanatus' OR junior_species='complanatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amphistomus' AND (species='complanatus' OR species='complanatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amphistomus' AND (species='complanatus' OR species='complanatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphistomus' AND (junior_species='complanatus' OR junior_species='complanatus')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='Amphistomus' AND (species='complanatus' OR species='complanatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepanus' AND (junior_species='globulus' OR junior_species='globulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepanus' AND (species='globulus' OR species='globulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lepanus' AND (species='globulus' OR species='globulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepanus' AND (junior_species='globulus' OR junior_species='globulus')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='Lepanus' AND (species='globulus' OR species='globulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monoplistes' AND (junior_species='curvipes' OR junior_species='curvipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Monoplistes' AND (species='curvipes' OR species='curvipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Monoplistes' AND (species='curvipes' OR species='curvipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monoplistes' AND (junior_species='curvipes' OR junior_species='curvipes')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='Monoplistes' AND (species='curvipes' OR species='curvipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Temnoplectron' AND (junior_species='aeneopiceum' OR junior_species='aeneopiceum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Temnoplectron' AND (species='aeneopiceum' OR species='aeneopiceum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Temnoplectron' AND (species='aeneopiceum' OR species='aeneopiceum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Temnoplectron' AND (junior_species='aeneopiceum' OR junior_species='aeneopiceum')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='Temnoplectron' AND (species='aeneopiceum' OR species='aeneopiceum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Temnoplectron' AND (junior_species='bornemisszai' OR junior_species='bornemisszaii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Temnoplectron' AND (species='bornemisszai' OR species='bornemisszaii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Temnoplectron' AND (species='bornemisszai' OR species='bornemisszaii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Temnoplectron' AND (junior_species='bornemisszai' OR junior_species='bornemisszaii')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='Temnoplectron' AND (species='bornemisszai' OR species='bornemisszaii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Temnoplectron' AND (junior_species='politulum' OR junior_species='politulum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Temnoplectron' AND (species='politulum' OR species='politulum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Temnoplectron' AND (species='politulum' OR species='politulum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Temnoplectron' AND (junior_species='politulum' OR junior_species='politulum')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='Temnoplectron' AND (species='politulum' OR species='politulum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='darlingtoni' OR junior_species='darlingtonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='darlingtoni' OR species='darlingtonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='darlingtoni' OR species='darlingtonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='darlingtoni' OR junior_species='darlingtonii')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='darlingtoni' OR species='darlingtonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='dicranocerus' OR junior_species='dicranocerus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='dicranocerus' OR species='dicranocerus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='dicranocerus' OR species='dicranocerus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='dicranocerus' OR junior_species='dicranocerus')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='dicranocerus' OR species='dicranocerus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='waminda' OR junior_species='waminda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='waminda' OR species='waminda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='waminda' OR species='waminda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='waminda' OR junior_species='waminda')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='waminda' OR species='waminda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='wilgi' OR junior_species='wilgii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='wilgi' OR species='wilgii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='wilgi' OR species='wilgii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='wilgi' OR junior_species='wilgii')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='wilgi' OR species='wilgii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coptodactyla' AND (junior_species='depressa' OR junior_species='depressa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coptodactyla' AND (species='depressa' OR species='depressa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coptodactyla' AND (species='depressa' OR species='depressa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coptodactyla' AND (junior_species='depressa' OR junior_species='depressa')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='depressa' OR species='depressa') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=666 The Ecological Register: Wongabel State Forest
Wongabel State Forest
Basic information
Sample name: Wongabel State Forest

Reference: H. F. Howden, A. T. Howden, and R. I. Storey. 1991. Nocturnal perching to scarabaeine dung beetles (Coleoptera, Scarabaeidae) in an Australian tropical rain forest. Biotropica 23(1):51-57 [ER 343]
Geography
Country: Australia

State: Queensland


Coordinate: 17° 19' S, 145° 28' E
Geography comments: "8 km south of Atherton"

Environment
Habitat: tropical/subtropical moist broadleaf forest

Protection: national/state forest

Substrate: ground surface

WMT: 27.8

CMT: 21.5

MAP: 1405.0

Habitat comments: "tropical, wet, evergreen forest"
MAP stated in text; CMT and WMT based on climate station 94287 (Aeroglen airport)

Methods
Life forms: scarab beetles

Sites: 1

Sampling methods: baited,pitfall traps

Sample size: 97 individuals

Years: 1988, 1989

Days: 2

Net or trap nights: 15

Sampling comments: two one-day nocturnal dung trap surveys, with the first using six "human feces"-baited traps and the second using six traps baited with "fermenting fruits" and three baited "with commercial mushrooms"
additional data on perching beetles are NOT entered because they are not representative of the actual community at this site

Metadata
Sample number: 666

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-30 21:21:26

Modified: 2015-10-01 10:51:54

Abundance distribution
12 species
5 singletons
total count 97
extrapolated richness: 26.7
Fisher's α: 3.605
geometric series k: 0.7363
Hurlbert's PIE: 0.7690
Shannon's H: 1.7350
Good's u: 0.9489
Each square represents a species. Square sizes are proportional to counts.
Register