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=1725 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1725SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1191SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1725 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ischnura' AND (junior_species='delicata' OR junior_species='delicata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ischnura' AND (species='delicata' OR species='delicata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ischnura' AND (species='delicata' OR species='delicata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ischnura' AND (junior_species='delicata' OR junior_species='delicata')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='delicata' OR species='delicata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platycnemis' 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='Platycnemis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Platycnemis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platycnemis' 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='Platycnemis' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinocypha' AND (junior_species='quadrimaculata' OR junior_species='quadrimaculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinocypha' AND (species='quadrimaculata' OR species='quadrimaculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhinocypha' AND (species='quadrimaculata' OR species='quadrimaculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinocypha' AND (junior_species='quadrimaculata' OR junior_species='quadrimaculata')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='quadrimaculata' OR species='quadrimaculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lamelligomphus' AND (junior_species='formosanus' OR junior_species='formosanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lamelligomphus' AND (species='formosanus' OR species='formosanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lamelligomphus' AND (species='formosanus' OR species='formosanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lamelligomphus' AND (junior_species='formosanus' OR junior_species='formosanus')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='Lamelligomphus' AND (species='formosanus' OR species='formosanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megalogomphus' AND (junior_species='icterops' OR junior_species='icterops')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megalogomphus' AND (species='icterops' OR species='icterops') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megalogomphus' AND (species='icterops' OR species='icterops')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megalogomphus' AND (junior_species='icterops' OR junior_species='icterops')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='Megalogomphus' AND (species='icterops' OR species='icterops') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paragomphus' AND (junior_species='henryii' OR junior_species='henryi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paragomphus' AND (species='henryii' OR species='henryi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paragomphus' AND (species='henryii' OR species='henryi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paragomphus' AND (junior_species='henryii' OR junior_species='henryi')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='Paragomphus' AND (species='henryii' OR species='henryi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macromia' AND (junior_species='gerstaeckeri' OR junior_species='gerstaeckerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macromia' AND (species='gerstaeckeri' OR species='gerstaeckerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macromia' AND (species='gerstaeckeri' OR species='gerstaeckerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macromia' AND (junior_species='gerstaeckeri' OR junior_species='gerstaeckerii')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='Macromia' AND (species='gerstaeckeri' OR species='gerstaeckerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macromia' AND (junior_species='moorei' OR junior_species='mooreii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macromia' AND (species='moorei' OR species='mooreii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macromia' AND (species='moorei' OR species='mooreii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macromia' AND (junior_species='moorei' OR junior_species='mooreii')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='Macromia' AND (species='moorei' OR species='mooreii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brachythemis' AND (junior_species='contaminata' OR junior_species='contaminata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brachythemis' AND (species='contaminata' OR species='contaminata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brachythemis' AND (species='contaminata' OR species='contaminata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brachythemis' AND (junior_species='contaminata' OR junior_species='contaminata')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='Brachythemis' AND (species='contaminata' OR species='contaminata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='brunneum' OR junior_species='brunneum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthetrum' AND (species='brunneum' OR species='brunneum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthetrum' AND (species='brunneum' OR species='brunneum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='brunneum' OR junior_species='brunneum')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='brunneum' OR species='brunneum') 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='Sympetrum' AND (junior_species='frequens' OR junior_species='frequens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sympetrum' AND (species='frequens' OR species='frequens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sympetrum' AND (species='frequens' OR species='frequens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sympetrum' AND (junior_species='frequens' OR junior_species='frequens')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='Sympetrum' AND (species='frequens' OR species='frequens') 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 * FROM register WHERE sample_no=1725 The Ecological Register: Chelong
Chelong
Basic information
Sample name: Chelong

Sample aka: Kerian River Basin

Reference: Z. S. Ameilia, M. R. Che Salmah, and A. Abu Hassan. 2006. Diversity and distribution of dragonfly (Odonata: Insecta) in the Kerian River Basin, Kedah - Perak, Malaysia. USU Repository [ER 1191]
Geography
Country: Malaysia

State: Perak


Coordinate: 5° 15' N, 100° 42' E
Coordinate basis: stated in text as range

Geography comments: coordinate is the midpoint of ranges given in the text

Environment
Habitat: tropical/subtropical moist broadleaf forest

Altered habitat: plantation

Substrate: lake bottom/stream bed

Habitat comments: "forested areas, rubber and oil palm plantations, orchads, several newly constructed settlement areas and villages"

Methods
Life forms: odonates

Sites: 2

Sampling methods: no design,other nets

Sample size: 91 individuals

Years: 1998, 1999

Sampling comments: "Two stations approximately 100 meters apart were identified along each river and 10 samples were collected at each stations... Dragonfly larvae were collected by a kick sampling technique (Merrit and Cummins, 1996), using an aquatic net (390 mm x 320mm : 210μm mesh)"

Metadata
Sample number: 1725

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-08-02 10:21:31

Modified: 2015-08-02 00:21:31

Abundance distribution
13 species
2 singletons
total count 91
extrapolated richness: 20.4
Fisher's α: 4.150
geometric series k: 0.7492
Hurlbert's PIE: 0.8199
Shannon's H: 2.0834
Good's u: 0.9787
Each square represents a species. Square sizes are proportional to counts.
Register