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=1581 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1581SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1071SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1581 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agriocnemis' AND (junior_species='femina' OR junior_species='femina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agriocnemis' AND (species='femina' OR species='femina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agriocnemis' AND (species='femina' OR species='femina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agriocnemis' AND (junior_species='femina' OR junior_species='femina')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='femina' OR species='femina') 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='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='Ischnura' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ischnura' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ischnura' 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='Ischnura' AND (species='sp.' OR species='sp.') 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='Diplocodes' 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='Diplocodes' AND (species='trivialis' OR species='trivialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diplocodes' AND (species='trivialis' OR species='trivialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplocodes' 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='Diplocodes' AND (species='trivialis' OR species='trivialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocothemis' AND (junior_species='servilia' OR junior_species='servilia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crocothemis' AND (species='servilia' OR species='servilia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crocothemis' AND (species='servilia' OR species='servilia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocothemis' AND (junior_species='servilia' OR junior_species='servilia')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='Crocothemis' AND (species='servilia' OR species='servilia') 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='Trithemis' 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='Trithemis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trithemis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trithemis' 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='Trithemis' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhyothemis' AND (junior_species='variegata' OR junior_species='variegata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhyothemis' AND (species='variegata' OR species='variegata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhyothemis' AND (species='variegata' OR species='variegata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhyothemis' AND (junior_species='variegata' OR junior_species='variegata')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='Rhyothemis' AND (species='variegata' OR species='variegata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neurothemis' AND (junior_species='tullia' OR junior_species='tullia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neurothemis' AND (species='tullia' OR species='tullia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neurothemis' AND (species='tullia' OR species='tullia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neurothemis' AND (junior_species='tullia' OR junior_species='tullia')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='tullia' OR species='tullia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anax' AND (junior_species='guttatus' OR junior_species='guttatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anax' AND (species='guttatus' OR species='guttatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anax' AND (species='guttatus' OR species='guttatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anax' AND (junior_species='guttatus' OR junior_species='guttatus')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='Anax' AND (species='guttatus' OR species='guttatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tramea' AND (junior_species='limbata' OR junior_species='limbata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tramea' AND (species='limbata' OR species='limbata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tramea' AND (species='limbata' OR species='limbata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tramea' AND (junior_species='limbata' OR junior_species='limbata')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='Tramea' AND (species='limbata' OR species='limbata') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1581 The Ecological Register: Madurai (partially weeded)
Madurai (partially weeded)
Basic information
Sample name: Madurai (partially weeded)

Reference: M. Kandibane, S. Raguraman, and N. Ganapathy. 2005. Relative abundance and diversity of Odonata in an irrigated rice field of Madurai, Tamil Nadu. Zoos' Print Journal 20(11):2051-2052 [ER 1071]
Geography
Country: India

State: Tamil Nadu


Coordinate: 9° 54' N, 78° 6' E
Coordinate basis: based on nearby landmark

Geography comments: "at the Wetlands of Agricultural College and Research Institute, Madurai" (coordinate based on Madurai)

•
Environment
Habitat: tropical/subtropical dry broadleaf forest

Altered habitat: cropland

Substrate: ground surface

Methods
Life forms: odonates

Sampling methods: no design,sweep nets

Sample size: 205 individuals

Years: 2000

Days: 9

Seasons: wet or monsoon

Sampling comments: "The collection of adult dragonflies and damselflies... was done with sweep net... Sampling was taken at weekly intervals and a total of nine samplings taken during Kharif (2000)"

Metadata
Sample number: 1581

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-05-22 13:35:23

Modified: 2015-05-22 03:35:23

Abundance distribution
12 species
0 singletons
total count 205
extrapolated richness: 13.6
Fisher's α: 2.782
geometric series k: 0.7772
Hurlbert's PIE: 0.8373
Shannon's H: 2.1049
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Agriocnemis femina femina64
Agriocnemis pygmaea22
Ischnura sp.10
Pantala flavescens31
Diplocodes trivialis24
Crocothemis servilia18
Orthetrum sabina5
Trithemis sp.4
Rhyothemis variegata6
Neurothemis tullia5
Anax guttatus4
Tramea limbata12