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=1604 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1604SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1091SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1604 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercion' AND (junior_species='calamorum' OR junior_species='calamorum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cercion' AND (species='calamorum' OR species='calamorum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cercion' AND (species='calamorum' OR species='calamorum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercion' AND (junior_species='calamorum' OR junior_species='calamorum')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='Cercion' AND (species='calamorum' OR species='calamorum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Somatochlora' AND (junior_species='viridiaenea' OR junior_species='viridiaenea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Somatochlora' AND (species='viridiaenea' OR species='viridiaenea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Somatochlora' AND (species='viridiaenea' OR species='viridiaenea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Somatochlora' AND (junior_species='viridiaenea' OR junior_species='viridiaenea')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='Somatochlora' AND (species='viridiaenea' OR species='viridiaenea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enallagma' AND (junior_species='circulatum' OR junior_species='circulatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Enallagma' AND (species='circulatum' OR species='circulatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Enallagma' AND (species='circulatum' OR species='circulatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enallagma' AND (junior_species='circulatum' OR junior_species='circulatum')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='Enallagma' AND (species='circulatum' OR species='circulatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sympetrum' AND (junior_species='croceolum' OR junior_species='croceolum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sympetrum' AND (species='croceolum' OR species='croceolum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sympetrum' AND (species='croceolum' OR species='croceolum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sympetrum' AND (junior_species='croceolum' OR junior_species='croceolum')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='croceolum' OR species='croceolum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sympetrum' AND (junior_species='striolatum' OR junior_species='striolatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sympetrum' AND (species='striolatum' OR species='striolatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sympetrum' AND (species='striolatum' OR species='striolatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sympetrum' AND (junior_species='striolatum' OR junior_species='striolatum')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='striolatum' OR species='striolatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sympetrum' AND (junior_species='eroticum' OR junior_species='eroticum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sympetrum' AND (species='eroticum' OR species='eroticum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sympetrum' AND (species='eroticum' OR species='eroticum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sympetrum' AND (junior_species='eroticum' OR junior_species='eroticum')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='eroticum' OR species='eroticum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Libellula' 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='Libellula' AND (species='quadrimaculata' OR species='quadrimaculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Libellula' AND (species='quadrimaculata' OR species='quadrimaculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Libellula' 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='Libellula' AND (species='quadrimaculata' OR species='quadrimaculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aeshnidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aeshnidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aeshnidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aeshnidae' AND (junior_species='indet.' OR junior_species='indet.')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='Aeshnidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epitheca' AND (junior_species='bimaculata' OR junior_species='bimaculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Epitheca' AND (species='bimaculata' OR species='bimaculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Epitheca' AND (species='bimaculata' OR species='bimaculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epitheca' AND (junior_species='bimaculata' OR junior_species='bimaculata')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='Epitheca' AND (species='bimaculata' OR species='bimaculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coenagrion' AND (junior_species='lanceolatum' OR junior_species='lanceolatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coenagrion' AND (species='lanceolatum' OR species='lanceolatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coenagrion' AND (species='lanceolatum' OR species='lanceolatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coenagrion' AND (junior_species='lanceolatum' OR junior_species='lanceolatum')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='Coenagrion' AND (species='lanceolatum' OR species='lanceolatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corduliidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Corduliidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Corduliidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corduliidae' AND (junior_species='indet.' OR junior_species='indet.')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='Corduliidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Libellulidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Libellulidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Libellulidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Libellulidae' AND (junior_species='indet.' OR junior_species='indet.')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='Libellulidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythromma' AND (junior_species='humerale' OR junior_species='humerale')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythromma' AND (species='humerale' OR species='humerale') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythromma' AND (species='humerale' OR species='humerale')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythromma' AND (junior_species='humerale' OR junior_species='humerale')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='Erythromma' AND (species='humerale' OR species='humerale') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coenagrion' AND (junior_species='ecornutum' OR junior_species='ecornutum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coenagrion' AND (species='ecornutum' OR species='ecornutum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coenagrion' AND (species='ecornutum' OR species='ecornutum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coenagrion' AND (junior_species='ecornutum' OR junior_species='ecornutum')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='Coenagrion' AND (species='ecornutum' OR species='ecornutum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordulia' AND (junior_species='aenea' OR junior_species='aenea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cordulia' AND (species='aenea' OR species='aenea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cordulia' AND (species='aenea' OR species='aenea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordulia' AND (junior_species='aenea' OR junior_species='aenea')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='Cordulia' AND (species='aenea' OR species='aenea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Somatochlora' AND (junior_species='graeseri' OR junior_species='graeserii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Somatochlora' AND (species='graeseri' OR species='graeserii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Somatochlora' AND (species='graeseri' OR species='graeserii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Somatochlora' AND (junior_species='graeseri' OR junior_species='graeserii')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='Somatochlora' AND (species='graeseri' OR species='graeserii') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1604 The Ecological Register: Kushiro Marsh (Quadrat F1)
Kushiro Marsh (Quadrat F1)
Basic information
Sample name: Kushiro Marsh (Quadrat F1)

Sample aka: Lake Takkobu

Reference: H. Ubukata and Y. Kurauchi. 2007. Assessment of lake environment using dragonfly assemblage: A case study at Lake Takkobu, Kushiro Marsh, northern Japan. Japanese Journal of Limnology 68:131-144 [ER 1091]
Geography
Country: Japan


Coordinate: 43° 6' N, 144° 24' E
Coordinate basis: based on nearby landmark

Geography comments: coordinate based on Kushiro-shitsugen National Park

Environment
Habitat: temperate wetland

Substrate: water edge

Methods
Life forms: odonates

Sampling methods: no design,butterfly nets,visual

Sample size: 357 captures or sightings

Years: 2004

Sampling comments: visual survey of adults, with hand captures with a butterfly net in cases of difficult identification

Metadata
Sample number: 1604

Contributor: John Alroy

Enterer: John Alroy

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

Modified: 2015-05-26 10:30:33

Abundance distribution
16 species
1 singleton
total count 357
extrapolated richness: 19.8
Fisher's α: 3.439
geometric series k: 0.7197
Hurlbert's PIE: 0.7797
Shannon's H: 1.9534
Good's u: 0.9972
Each square represents a species. Square sizes are proportional to counts.
Register