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=1610 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1610SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1096SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1610 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calopteryx' AND (junior_species='haemorrhoidalis' OR junior_species='haemorrhoidalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calopteryx' AND (species='haemorrhoidalis' OR species='haemorrhoidalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calopteryx' AND (species='haemorrhoidalis' OR species='haemorrhoidalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calopteryx' AND (junior_species='haemorrhoidalis' OR junior_species='haemorrhoidalis')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='Calopteryx' AND (species='haemorrhoidalis' OR species='haemorrhoidalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calopteryx' AND (junior_species='splendens' OR junior_species='splendens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calopteryx' AND (species='splendens' OR species='splendens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calopteryx' AND (species='splendens' OR species='splendens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calopteryx' AND (junior_species='splendens' OR junior_species='splendens')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='Calopteryx' AND (species='splendens' OR species='splendens') 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='Enallagma' AND (junior_species='cyathigerum' OR junior_species='cyathigerum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Enallagma' AND (species='cyathigerum' OR species='cyathigerum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Enallagma' AND (species='cyathigerum' OR species='cyathigerum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enallagma' AND (junior_species='cyathigerum' OR junior_species='cyathigerum')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='cyathigerum' OR species='cyathigerum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coenagrion' AND (junior_species='mercuriale' OR junior_species='mercuriale')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coenagrion' AND (species='mercuriale' OR species='mercuriale') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coenagrion' AND (species='mercuriale' OR species='mercuriale')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coenagrion' AND (junior_species='mercuriale' OR junior_species='mercuriale')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='mercuriale' OR species='mercuriale') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coenagrion' AND (junior_species='caerulescens' OR junior_species='caerulescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coenagrion' AND (species='caerulescens' OR species='caerulescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coenagrion' AND (species='caerulescens' OR species='caerulescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coenagrion' AND (junior_species='caerulescens' OR junior_species='caerulescens')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='caerulescens' OR species='caerulescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coenagrion' AND (junior_species='scitulum' OR junior_species='scitulum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coenagrion' AND (species='scitulum' OR species='scitulum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coenagrion' AND (species='scitulum' OR species='scitulum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coenagrion' AND (junior_species='scitulum' OR junior_species='scitulum')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='scitulum' OR species='scitulum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gomphus' AND (junior_species='pulchellus' OR junior_species='pulchellus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gomphus' AND (species='pulchellus' OR species='pulchellus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gomphus' AND (species='pulchellus' OR species='pulchellus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gomphus' AND (junior_species='pulchellus' OR junior_species='pulchellus')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='Gomphus' AND (species='pulchellus' OR species='pulchellus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gomphus' AND (junior_species='simillimus' OR junior_species='simillimus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gomphus' AND (species='simillimus' OR species='simillimus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gomphus' AND (species='simillimus' OR species='simillimus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gomphus' AND (junior_species='simillimus' OR junior_species='simillimus')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='Gomphus' AND (species='simillimus' OR species='simillimus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ophiogomphus' AND (junior_species='cecilia' OR junior_species='cecilia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ophiogomphus' AND (species='cecilia' OR species='cecilia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ophiogomphus' AND (species='cecilia' OR species='cecilia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ophiogomphus' AND (junior_species='cecilia' OR junior_species='cecilia')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='Ophiogomphus' AND (species='cecilia' OR species='cecilia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onychogomphus' AND (junior_species='forcipatus' OR junior_species='forcipatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onychogomphus' AND (species='forcipatus' OR species='forcipatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onychogomphus' AND (species='forcipatus' OR species='forcipatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onychogomphus' AND (junior_species='forcipatus' OR junior_species='forcipatus')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='Onychogomphus' AND (species='forcipatus' OR species='forcipatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onychogomphus' AND (junior_species='uncatus' OR junior_species='uncatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onychogomphus' AND (species='uncatus' OR species='uncatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onychogomphus' AND (species='uncatus' OR species='uncatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onychogomphus' AND (junior_species='uncatus' OR junior_species='uncatus')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='Onychogomphus' AND (species='uncatus' OR species='uncatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brachytron' AND (junior_species='pratense' OR junior_species='pratense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brachytron' AND (species='pratense' OR species='pratense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brachytron' AND (species='pratense' OR species='pratense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brachytron' AND (junior_species='pratense' OR junior_species='pratense')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='Brachytron' AND (species='pratense' OR species='pratense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordulegaster' AND (junior_species='boltonii' OR junior_species='boltoni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cordulegaster' AND (species='boltonii' OR species='boltoni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cordulegaster' AND (species='boltonii' OR species='boltoni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordulegaster' AND (junior_species='boltonii' OR junior_species='boltoni')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='Cordulegaster' AND (species='boltonii' OR species='boltoni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Libellula' AND (junior_species='fulva' OR junior_species='fulva')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Libellula' AND (species='fulva' OR species='fulva') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Libellula' AND (species='fulva' OR species='fulva')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Libellula' AND (junior_species='fulva' OR junior_species='fulva')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='fulva' OR species='fulva') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='cancellatum' OR junior_species='cancellatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthetrum' AND (species='cancellatum' OR species='cancellatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthetrum' AND (species='cancellatum' OR species='cancellatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='cancellatum' OR junior_species='cancellatum')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='cancellatum' OR species='cancellatum') 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='coerulescens' OR junior_species='coerulescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthetrum' AND (species='coerulescens' OR species='coerulescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthetrum' AND (species='coerulescens' OR species='coerulescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='coerulescens' OR junior_species='coerulescens')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='coerulescens' OR species='coerulescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sympetrum' AND (junior_species='fonscolombii' OR junior_species='fonscolombi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sympetrum' AND (species='fonscolombii' OR species='fonscolombi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sympetrum' AND (species='fonscolombii' OR species='fonscolombi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sympetrum' AND (junior_species='fonscolombii' OR junior_species='fonscolombi')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='fonscolombii' OR species='fonscolombi') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1610 The Ecological Register: Canal de Vergières
Canal de Vergières
Basic information
Sample name: Canal de Vergières

Reference: P. Schridde and F. Suhling. 1994. Larval dragonfly communities in different habitats of a Mediterranean running water system. Advances in Odonatology 6:89-100 [ER 1096]
Geography
Country: France


Coordinate: 43° 38' N, 4° 49' E
Coordinate basis: based on nearby landmark

Geography comments: coordinate based on Saint-Martin-de-Crau

Environment
Habitat: Mediterranean woodland

Altered habitat: cropland

Substrate: lake bottom/stream bed

Methods
Life forms: odonates

Sites: 10

Sampling methods: no design

Sample size: 1508 individuals

Sampling comments: methods unclear because key page is missing from PDF, but sampling is definitely of larvae and collections were made at ten locations within the canal

Metadata
Sample number: 1610

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-05-29 18:40:10

Modified: 2015-05-29 08:40:10

Abundance distribution
19 species
6 singletons
total count 1508
extrapolated richness: 30.6
Fisher's α: 3.064
geometric series k: 0.6945
Hurlbert's PIE: 0.7072
Shannon's H: 1.6002
Good's u: 0.9960
Each square represents a species. Square sizes are proportional to counts.
Register