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=1575 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1575SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1067SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1575 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ictinogomphus' AND (junior_species='tenax' OR junior_species='tenax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ictinogomphus' AND (species='tenax' OR species='tenax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ictinogomphus' AND (species='tenax' OR species='tenax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ictinogomphus' AND (junior_species='tenax' OR junior_species='tenax')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='Ictinogomphus' AND (species='tenax' OR species='tenax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplacodes' AND (junior_species='trivialis' OR junior_species='trivialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diplacodes' AND (species='trivialis' OR species='trivialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diplacodes' AND (species='trivialis' OR species='trivialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplacodes' AND (junior_species='trivialis' OR junior_species='trivialis')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='Diplacodes' AND (species='trivialis' OR species='trivialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neurothemis' AND (junior_species='ramburii' OR junior_species='ramburi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neurothemis' AND (species='ramburii' OR species='ramburi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neurothemis' AND (species='ramburii' OR species='ramburi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neurothemis' AND (junior_species='ramburii' OR junior_species='ramburi')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='Neurothemis' AND (species='ramburii' OR species='ramburi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neurothemis' AND (junior_species='terminata' OR junior_species='terminata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neurothemis' AND (species='terminata' OR species='terminata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neurothemis' AND (species='terminata' OR species='terminata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neurothemis' AND (junior_species='terminata' OR junior_species='terminata')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='Neurothemis' AND (species='terminata' OR species='terminata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='sabina' OR junior_species='sabina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthetrum' AND (species='sabina' OR species='sabina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthetrum' AND (species='sabina' OR species='sabina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='sabina' OR junior_species='sabina')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='sabina' OR species='sabina') 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 senior_genus genus,senior_species species FROM itis WHERE junior_genus='Potamarcha' AND (junior_species='congener' OR junior_species='congener')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Potamarcha' AND (species='congener' OR species='congener') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Potamarcha' AND (species='congener' OR species='congener')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Potamarcha' AND (junior_species='congener' OR junior_species='congener')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='Potamarcha' AND (species='congener' OR species='congener') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tholymis' AND (junior_species='tillarga' OR junior_species='tillarga')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tholymis' AND (species='tillarga' OR species='tillarga') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tholymis' AND (species='tillarga' OR species='tillarga')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tholymis' AND (junior_species='tillarga' OR junior_species='tillarga')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='Tholymis' AND (species='tillarga' OR species='tillarga') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trithemis' AND (junior_species='aurora' OR junior_species='aurora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trithemis' AND (species='aurora' OR species='aurora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trithemis' AND (species='aurora' OR species='aurora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trithemis' AND (junior_species='aurora' OR junior_species='aurora')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='Trithemis' AND (species='aurora' OR species='aurora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agriocnemis' AND (junior_species='pygmaea' OR junior_species='pygmaea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agriocnemis' AND (species='pygmaea' OR species='pygmaea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agriocnemis' AND (species='pygmaea' OR species='pygmaea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agriocnemis' AND (junior_species='pygmaea' OR junior_species='pygmaea')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='Agriocnemis' AND (species='pygmaea' OR species='pygmaea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ischnura' AND (junior_species='senegalensis' OR junior_species='senegalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ischnura' AND (species='senegalensis' OR species='senegalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ischnura' AND (species='senegalensis' OR species='senegalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ischnura' AND (junior_species='senegalensis' OR junior_species='senegalensis')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='Ischnura' AND (species='senegalensis' OR species='senegalensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudagrion' AND (junior_species='microcephalum' OR junior_species='microcephalum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudagrion' AND (species='microcephalum' OR species='microcephalum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudagrion' AND (species='microcephalum' OR species='microcephalum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudagrion' AND (junior_species='microcephalum' OR junior_species='microcephalum')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='Pseudagrion' AND (species='microcephalum' OR species='microcephalum') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1575 The Ecological Register: Lake Babuyan
Lake Babuyan
Basic information
Sample name: Lake Babuyan

Reference: K. T. Aspacio, C. M. Yuto, O. M. Nuņeza, and R. J. T. Villanueva. 2013. Species diversity of Odonata in selected areas of Buru-un, Iligan City and Tubod, Lanao del Norte, Philippines. ABAH Bioflux 5(2):145-155 [ER 1067]
Geography
Country: Philippines

State: Lanao del Norte


Coordinate: 7° 59' 17" N, 123° 52' 31" E
Coordinate basis: stated in text

Geography comments: "in Barangay Malingao, Tubod, Lanao del Norte"

Environment
Habitat: lake

Altered habitat: cropland

Substrate: water edge

Habitat comments: "The whole lake is S-shaped and surrounded with corn, coconut and banana fields. Fishing is a common activity in the lake"

Methods
Life forms: odonates

Sampling methods: no design,sweep nets

Sample size: 81 individuals

Years: 2012

Sampling comments: "Adult Odonata collection was done using sweep nets"

Metadata
Sample number: 1575

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-05-21 19:53:39

Modified: 2016-10-21 04:38:37

Abundance distribution
12 species
3 singletons
total count 81
extrapolated richness: 22.7
Fisher's α: 3.893
geometric series k: 0.7411
Hurlbert's PIE: 0.7872
Shannon's H: 1.8618
Good's u: 0.9642
Each square represents a species. Square sizes are proportional to counts.
Register