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=1603 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1603SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1090SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1603 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemicordulia' AND (junior_species='mindana' OR junior_species='mindana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemicordulia' AND (species='mindana' OR species='mindana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemicordulia' AND (species='mindana' OR species='mindana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemicordulia' AND (junior_species='mindana' OR junior_species='mindana')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='Hemicordulia' AND (species='mindana' OR species='mindana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Idionyx' AND (junior_species='philippa' OR junior_species='philippa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Idionyx' AND (species='philippa' OR species='philippa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Idionyx' AND (species='philippa' OR species='philippa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Idionyx' AND (junior_species='philippa' OR junior_species='philippa')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='Idionyx' AND (species='philippa' OR species='philippa') ORDER BY year,last_namesSELECT 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='Acisoma' AND (junior_species='panorpoides' OR junior_species='panorpoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acisoma' AND (species='panorpoides' OR species='panorpoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acisoma' AND (species='panorpoides' OR species='panorpoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acisoma' AND (junior_species='panorpoides' OR junior_species='panorpoides')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='Acisoma' AND (species='panorpoides' OR species='panorpoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplacina' AND (junior_species='braueri' OR junior_species='brauerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diplacina' AND (species='braueri' OR species='brauerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diplacina' AND (species='braueri' OR species='brauerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplacina' AND (junior_species='braueri' OR junior_species='brauerii')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='Diplacina' AND (species='braueri' OR species='brauerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplacina' AND (junior_species='nana' OR junior_species='nana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diplacina' AND (species='nana' OR species='nana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diplacina' AND (species='nana' OR species='nana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplacina' AND (junior_species='nana' OR junior_species='nana')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='Diplacina' AND (species='nana' OR species='nana') 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='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='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='Orthetrum' AND (junior_species='testaceum' OR junior_species='testaceum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthetrum' AND (species='testaceum' OR species='testaceum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthetrum' AND (species='testaceum' OR species='testaceum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='testaceum' OR junior_species='testaceum')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='testaceum' OR species='testaceum') 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='Vestalis' AND (junior_species='melania' OR junior_species='melania')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vestalis' AND (species='melania' OR species='melania') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vestalis' AND (species='melania' OR species='melania')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vestalis' AND (junior_species='melania' OR junior_species='melania')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='melania' OR species='melania') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinocypha' AND (junior_species='colorata' OR junior_species='colorata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinocypha' AND (species='colorata' OR species='colorata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhinocypha' AND (species='colorata' OR species='colorata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinocypha' AND (junior_species='colorata' OR junior_species='colorata')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='Rhinocypha' AND (species='colorata' OR species='colorata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agriocnemis' AND (junior_species='rubescens' OR junior_species='rubescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agriocnemis' AND (species='rubescens' OR species='rubescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agriocnemis' AND (species='rubescens' OR species='rubescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agriocnemis' AND (junior_species='rubescens' OR junior_species='rubescens')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='rubescens' OR species='rubescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceriagrion' AND (junior_species='lieftincki' OR junior_species='lieftinckii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ceriagrion' AND (species='lieftincki' OR species='lieftinckii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ceriagrion' AND (species='lieftincki' OR species='lieftinckii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceriagrion' AND (junior_species='lieftincki' OR junior_species='lieftinckii')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='Ceriagrion' AND (species='lieftincki' OR species='lieftinckii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pericnemis' 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='Pericnemis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pericnemis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pericnemis' 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='Pericnemis' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudagrion' AND (junior_species='pilidorsum' OR junior_species='pilidorsum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudagrion' AND (species='pilidorsum' OR species='pilidorsum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudagrion' AND (species='pilidorsum' OR species='pilidorsum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudagrion' AND (junior_species='pilidorsum' OR junior_species='pilidorsum')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='pilidorsum' OR species='pilidorsum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Teinobasis' AND (junior_species='filamentum' OR junior_species='filamentum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Teinobasis' AND (species='filamentum' OR species='filamentum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Teinobasis' AND (species='filamentum' OR species='filamentum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Teinobasis' AND (junior_species='filamentum' OR junior_species='filamentum')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='Teinobasis' AND (species='filamentum' OR species='filamentum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Risiocnemis' AND (junior_species='flammea' OR junior_species='flammea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Risiocnemis' AND (species='flammea' OR species='flammea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Risiocnemis' AND (species='flammea' OR species='flammea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Risiocnemis' AND (junior_species='flammea' OR junior_species='flammea')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='Risiocnemis' AND (species='flammea' OR species='flammea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Risiocnemis' AND (junior_species='tendipes' OR junior_species='tendipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Risiocnemis' AND (species='tendipes' OR species='tendipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Risiocnemis' AND (species='tendipes' OR species='tendipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Risiocnemis' AND (junior_species='tendipes' OR junior_species='tendipes')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='Risiocnemis' AND (species='tendipes' OR species='tendipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drepanosticta' AND (junior_species='lestoides' OR junior_species='lestoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Drepanosticta' AND (species='lestoides' OR species='lestoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Drepanosticta' AND (species='lestoides' OR species='lestoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drepanosticta' AND (junior_species='lestoides' OR junior_species='lestoides')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='Drepanosticta' AND (species='lestoides' OR species='lestoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prodasineura' AND (junior_species='integra' OR junior_species='integra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prodasineura' AND (species='integra' OR species='integra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prodasineura' AND (species='integra' OR species='integra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prodasineura' AND (junior_species='integra' OR junior_species='integra')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='integra' OR species='integra') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1603 The Ecological Register: Barangay Danugan (Site 7)
Barangay Danugan (Site 7)
Basic information
Sample name: Barangay Danugan (Site 7)

Sample aka: Pualas

Reference: A. D. Malawani, N. M. Ampang-Macabuat, O. M. Nuņeza, and R. J. T. Villanueva. 2014. Odonata of Lanao del Sur, Mindanao, Philippines. International Research Journal of Biological Sciences 3(1):42-48 [ER 1090]
Geography
Country: Philippines

State: Lanao del Sur


Coordinate: 7° 47' 24" N, 124° 4' 26" E
Coordinate basis: stated in text

Environment
Habitat: lake

Substrate: water edge

Habitat comments: a pond in an area "covered with forest patches... well vegetated with trees... people come to the place to get water despite the water pipes that were installed from the spring to the houses"

Methods
Life forms: odonates

Sampling methods: no design,sweep nets,hand capture,visual

Sample size: 89 individuals

Years: 2012

Sampling comments: "sweep nets, hand-grabbing and visual encounter surveys. The collection of Odonata was principally based on adult specimens"

Metadata
Sample number: 1603

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-05-26 20:17:30

Modified: 2016-10-21 04:43:51

Abundance distribution
22 species
5 singletons
total count 89
extrapolated richness: 42.2
Fisher's α: 9.349
geometric series k: 0.8763
Hurlbert's PIE: 0.9110
Shannon's H: 2.7196
Good's u: 0.9458
Each square represents a species. Square sizes are proportional to counts.
Register