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=1660 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1660SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1139SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1660 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Devadatta' AND (junior_species='podolestoides' OR junior_species='podolestoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Devadatta' AND (species='podolestoides' OR species='podolestoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Devadatta' AND (species='podolestoides' OR species='podolestoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Devadatta' AND (junior_species='podolestoides' OR junior_species='podolestoides')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='Devadatta' AND (species='podolestoides' OR species='podolestoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaea' AND (junior_species='impar' OR junior_species='impar')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphaea' AND (species='impar' OR species='impar') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euphaea' AND (species='impar' OR species='impar')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaea' AND (junior_species='impar' OR junior_species='impar')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='Euphaea' AND (species='impar' OR species='impar') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vestalis' AND (junior_species='amnicola' OR junior_species='amnicola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vestalis' AND (species='amnicola' OR species='amnicola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vestalis' AND (species='amnicola' OR species='amnicola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vestalis' AND (junior_species='amnicola' OR junior_species='amnicola')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='Vestalis' AND (species='amnicola' OR species='amnicola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prodasineura' AND (junior_species='hyperythra' OR junior_species='hyperythra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prodasineura' AND (species='hyperythra' OR species='hyperythra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prodasineura' AND (species='hyperythra' OR species='hyperythra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prodasineura' AND (junior_species='hyperythra' OR junior_species='hyperythra')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='Prodasineura' AND (species='hyperythra' OR species='hyperythra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prodasineura' AND (junior_species='verticalis' OR junior_species='verticalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prodasineura' AND (species='verticalis' OR species='verticalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prodasineura' AND (species='verticalis' OR species='verticalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prodasineura' AND (junior_species='verticalis' OR junior_species='verticalis')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='Prodasineura' AND (species='verticalis' OR species='verticalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xiphiagrion' AND (junior_species='cyanomelas' OR junior_species='cyanomelas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xiphiagrion' AND (species='cyanomelas' OR species='cyanomelas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xiphiagrion' AND (species='cyanomelas' OR species='cyanomelas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xiphiagrion' AND (junior_species='cyanomelas' OR junior_species='cyanomelas')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='Xiphiagrion' AND (species='cyanomelas' OR species='cyanomelas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coeliccia' AND (junior_species='nemoricola' OR junior_species='nemoricola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coeliccia' AND (species='nemoricola' OR species='nemoricola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coeliccia' AND (species='nemoricola' OR species='nemoricola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coeliccia' AND (junior_species='nemoricola' OR junior_species='nemoricola')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='Coeliccia' AND (species='nemoricola' OR species='nemoricola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coeliccia' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coeliccia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coeliccia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coeliccia' AND (junior_species='sp.' OR junior_species='sp.')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='Coeliccia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliogomphus' AND (junior_species='borneensis' OR junior_species='borneensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliogomphus' AND (species='borneensis' OR species='borneensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliogomphus' AND (species='borneensis' OR species='borneensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliogomphus' AND (junior_species='borneensis' OR junior_species='borneensis')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='Heliogomphus' AND (species='borneensis' OR species='borneensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Indaeschna' AND (junior_species='grubaueri' OR junior_species='grubauerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Indaeschna' AND (species='grubaueri' OR species='grubauerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Indaeschna' AND (species='grubaueri' OR species='grubauerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Indaeschna' AND (junior_species='grubaueri' OR junior_species='grubauerii')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='Indaeschna' AND (species='grubaueri' OR species='grubauerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agrionoptera' AND (junior_species='sexlineata' OR junior_species='sexlineata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agrionoptera' AND (species='sexlineata' OR species='sexlineata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agrionoptera' AND (species='sexlineata' OR species='sexlineata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agrionoptera' AND (junior_species='sexlineata' OR junior_species='sexlineata')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='Agrionoptera' AND (species='sexlineata' OR species='sexlineata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cratilla' AND (junior_species='metallica' OR junior_species='metallica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cratilla' AND (species='metallica' OR species='metallica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cratilla' AND (species='metallica' OR species='metallica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cratilla' AND (junior_species='metallica' OR junior_species='metallica')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='Cratilla' AND (species='metallica' OR species='metallica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='chrysis' OR junior_species='chrysis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthetrum' AND (species='chrysis' OR species='chrysis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthetrum' AND (species='chrysis' OR species='chrysis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='chrysis' OR junior_species='chrysis')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='Orthetrum' AND (species='chrysis' OR species='chrysis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='pruinosum' OR junior_species='pruinosum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthetrum' AND (species='pruinosum' OR species='pruinosum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthetrum' AND (species='pruinosum' OR species='pruinosum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='pruinosum' OR junior_species='pruinosum')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='Orthetrum' AND (species='pruinosum' OR species='pruinosum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pantala' AND (junior_species='flavescens' OR junior_species='flavescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pantala' AND (species='flavescens' OR species='flavescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pantala' AND (species='flavescens' OR species='flavescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pantala' AND (junior_species='flavescens' OR junior_species='flavescens')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='Pantala' AND (species='flavescens' OR species='flavescens') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1660 The Ecological Register: Eucalyptus Camp
Eucalyptus Camp
Basic information
Sample name: Eucalyptus Camp

Sample aka: Maliau Basin

Reference: Y. F. Ng, H. S. Yong, R. A. Dow, and M. Hämäläinen. 2008. Dragonflies (Insecta: Odonata) from the Maliau Basin, Sabah, Malaysia. Journal of Science and Technology in the Tropics 4:13-18 [ER 1139]
Geography
Country: Malaysia

State: Sabah


Coordinate: 4° 52' 18" N, 116° 49' 35" E
Coordinate basis: stated in text

Geography comments: "in the southern part of Sabah"
altitude 950 to 1000 m

Environment
Habitat: tropical/subtropical moist broadleaf forest

Substrate: water edge

Habitat comments: "lower montane hill forest and heath forest" with most collections made near pools or streams

Methods
Life forms: odonates

Sampling methods: no design,other nets

Sample size: 55 individuals

Years: 2006

Days: 6

Sampling comments: collecting was "on 18-23 April 2006... conducted using hand held nets"

Metadata
Sample number: 1660

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-06-29 21:13:49

Modified: 2015-06-29 11:13:49

Abundance distribution
15 species
6 singletons
total count 55
extrapolated richness: 32.4
Fisher's α: 6.794
geometric series k: 0.8548
Hurlbert's PIE: 0.8919
Shannon's H: 2.4157
Good's u: 0.8916
Each square represents a species. Square sizes are proportional to counts.
Register