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=1589 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1589SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1077SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1589 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enallagma' AND (junior_species='ebrium' OR junior_species='ebrium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Enallagma' AND (species='ebrium' OR species='ebrium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Enallagma' AND (species='ebrium' OR species='ebrium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enallagma' AND (junior_species='ebrium' OR junior_species='ebrium')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='ebrium' OR species='ebrium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enallagma' AND (junior_species='geminatum' OR junior_species='geminatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Enallagma' AND (species='geminatum' OR species='geminatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Enallagma' AND (species='geminatum' OR species='geminatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enallagma' AND (junior_species='geminatum' OR junior_species='geminatum')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='geminatum' OR species='geminatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ischnura' AND (junior_species='posita' OR junior_species='posita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ischnura' AND (species='posita' OR species='posita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ischnura' AND (species='posita' OR species='posita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ischnura' AND (junior_species='posita' OR junior_species='posita')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='posita' OR species='posita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ischnura' AND (junior_species='verticalis' OR junior_species='verticalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ischnura' AND (species='verticalis' OR species='verticalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ischnura' AND (species='verticalis' OR species='verticalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ischnura' AND (junior_species='verticalis' OR junior_species='verticalis')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='verticalis' OR species='verticalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gomphus' AND (junior_species='furcifer' OR junior_species='furcifer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gomphus' AND (species='furcifer' OR species='furcifer') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gomphus' AND (species='furcifer' OR species='furcifer')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gomphus' AND (junior_species='furcifer' OR junior_species='furcifer')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='furcifer' OR species='furcifer') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anax' AND (junior_species='junius' OR junior_species='junius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anax' AND (species='junius' OR species='junius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anax' AND (species='junius' OR species='junius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anax' AND (junior_species='junius' OR junior_species='junius')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='junius' OR species='junius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetragoneuria' AND (junior_species='cynosura' OR junior_species='cynosura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetragoneuria' AND (species='cynosura' OR species='cynosura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetragoneuria' AND (species='cynosura' OR species='cynosura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetragoneuria' AND (junior_species='cynosura' OR junior_species='cynosura')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='Tetragoneuria' AND (species='cynosura' OR species='cynosura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Libellula' AND (junior_species='luctuosa' OR junior_species='luctuosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Libellula' AND (species='luctuosa' OR species='luctuosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Libellula' AND (species='luctuosa' OR species='luctuosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Libellula' AND (junior_species='luctuosa' OR junior_species='luctuosa')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='luctuosa' OR species='luctuosa') 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='Plathemis' AND (junior_species='lydia' OR junior_species='lydia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Plathemis' AND (species='lydia' OR species='lydia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plathemis' AND (species='lydia' OR species='lydia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plathemis' AND (junior_species='lydia' OR junior_species='lydia')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='Plathemis' AND (species='lydia' OR species='lydia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leucorrhinia' AND (junior_species='intacta' OR junior_species='intacta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leucorrhinia' AND (species='intacta' OR species='intacta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leucorrhinia' AND (species='intacta' OR species='intacta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leucorrhinia' AND (junior_species='intacta' OR junior_species='intacta')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='Leucorrhinia' AND (species='intacta' OR species='intacta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sympetrum' AND (junior_species='vicinum' OR junior_species='vicinum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sympetrum' AND (species='vicinum' OR species='vicinum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sympetrum' AND (species='vicinum' OR species='vicinum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sympetrum' AND (junior_species='vicinum' OR junior_species='vicinum')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='vicinum' OR species='vicinum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachydiplax' AND (junior_species='longipennis' OR junior_species='longipennis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachydiplax' AND (species='longipennis' OR species='longipennis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachydiplax' AND (species='longipennis' OR species='longipennis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachydiplax' AND (junior_species='longipennis' OR junior_species='longipennis')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='Pachydiplax' AND (species='longipennis' OR species='longipennis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tramea' AND (junior_species='lacerata' OR junior_species='lacerata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tramea' AND (species='lacerata' OR species='lacerata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tramea' AND (species='lacerata' OR species='lacerata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tramea' AND (junior_species='lacerata' OR junior_species='lacerata')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='lacerata' OR species='lacerata') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1589 The Ecological Register: East Twin Pond (larvae)
East Twin Pond (larvae)
Basic information
Sample name: East Twin Pond (larvae)

Reference: E. J. Kormondy and J. L. Gower. 1965. Life history variations in an association of Odonata. Ecology 46(6):882-886 [ER 1077]
Geography
Country: United States

State: Pennsylvania


Coordinate: 41° 39' N, 80° 25' W
Coordinate basis: based on nearby landmark

Geography comments: "five miles south of Linesville" (basis of coordinate)

•
Environment
Habitat: lake

Protection: unprotected

Substrate: open water

Habitat comments: the pond "arose about 50 years ago from the bisecting of a 0.7-acre impoundment by a roadway" and has "a maximum depth of 1.0 m and a surface area of 0.3 acres"

Methods
Life forms: odonates

Sampling methods: no design,sieves

Sample size: 229 individuals

Years: 1961, 1962

Sampling comments: "the larval population was sampled eight times. A square frame was constructed of two lengths of steel 25 X 4 mm hinged near their ends to enclose a basal area of .25 M2. Fine-mesh nylon was attached to the frame forming a bag about 1 m long. In operation, the opened frame was dropped into the water from a boat"

Metadata
Sample number: 1589

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-05-23 19:24:54

Modified: 2020-01-14 09:45:14

Abundance distribution
14 species
2 singletons
total count 229
extrapolated richness: 20.5
Fisher's α: 3.288
geometric series k: 0.7327
Hurlbert's PIE: 0.8162
Shannon's H: 1.9401
Good's u: 0.9913
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Enallagma ebrium33
Enallagma geminatum1
Ischnura posita3
Ischnura verticalis43
Gomphus furcifer3
Anax junius4
Tetragoneuria cynosura57
Libellula luctuosa2
Libellula quadrimaculata1
Plathemis lydia5
Leucorrhinia intacta13
Sympetrum vicinum56
Pachydiplax longipennis2
Tramea lacerata6