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=1579 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1579SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1070SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1579 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hetaerina' AND (junior_species='americana' OR junior_species='americana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hetaerina' AND (species='americana' OR species='americana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hetaerina' AND (species='americana' OR species='americana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hetaerina' AND (junior_species='americana' OR junior_species='americana')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='Hetaerina' AND (species='americana' OR species='americana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaemnema' AND (junior_species='domina' OR junior_species='domina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Palaemnema' AND (species='domina' OR species='domina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Palaemnema' AND (species='domina' OR species='domina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaemnema' AND (junior_species='domina' OR junior_species='domina')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='Palaemnema' AND (species='domina' OR species='domina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='oculata' OR junior_species='oculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Argia' AND (species='oculata' OR species='oculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argia' AND (species='oculata' OR species='oculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='oculata' OR junior_species='oculata')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='Argia' AND (species='oculata' OR species='oculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='oenea' OR junior_species='oenea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Argia' AND (species='oenea' OR species='oenea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argia' AND (species='oenea' OR species='oenea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='oenea' OR junior_species='oenea')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='Argia' AND (species='oenea' OR species='oenea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='tezpi' OR junior_species='tezpii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Argia' AND (species='tezpi' OR species='tezpii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argia' AND (species='tezpi' OR species='tezpii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='tezpi' OR junior_species='tezpii')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='Argia' AND (species='tezpi' OR species='tezpii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erpetogomphus' AND (junior_species='cophias' OR junior_species='cophias')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erpetogomphus' AND (species='cophias' OR species='cophias') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erpetogomphus' AND (species='cophias' OR species='cophias')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erpetogomphus' AND (junior_species='cophias' OR junior_species='cophias')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='Erpetogomphus' AND (species='cophias' OR species='cophias') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erpetogomphus' AND (junior_species='elaps' OR junior_species='elaps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erpetogomphus' AND (species='elaps' OR species='elaps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erpetogomphus' AND (species='elaps' OR species='elaps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erpetogomphus' AND (junior_species='elaps' OR junior_species='elaps')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='Erpetogomphus' AND (species='elaps' OR species='elaps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Progomphus' AND (junior_species='clendoni' OR junior_species='clendonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Progomphus' AND (species='clendoni' OR species='clendonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Progomphus' AND (species='clendoni' OR species='clendonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Progomphus' AND (junior_species='clendoni' OR junior_species='clendonii')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='Progomphus' AND (species='clendoni' OR species='clendonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Progomphus' AND (junior_species='lambertoi' OR junior_species='lambertoii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Progomphus' AND (species='lambertoi' OR species='lambertoii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Progomphus' AND (species='lambertoi' OR species='lambertoii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Progomphus' AND (junior_species='lambertoi' OR junior_species='lambertoii')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='Progomphus' AND (species='lambertoi' OR species='lambertoii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Progomphus' AND (junior_species='marcelae' OR junior_species='marcelae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Progomphus' AND (species='marcelae' OR species='marcelae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Progomphus' AND (species='marcelae' OR species='marcelae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Progomphus' AND (junior_species='marcelae' OR junior_species='marcelae')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='Progomphus' AND (species='marcelae' OR species='marcelae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllogomphoides' AND (junior_species='luisi' OR junior_species='luisii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phyllogomphoides' AND (species='luisi' OR species='luisii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phyllogomphoides' AND (species='luisi' OR species='luisii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllogomphoides' AND (junior_species='luisi' OR junior_species='luisii')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='Phyllogomphoides' AND (species='luisi' OR species='luisii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllogomphoides' AND (junior_species='pacificus' OR junior_species='pacificus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phyllogomphoides' AND (species='pacificus' OR species='pacificus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phyllogomphoides' AND (species='pacificus' OR species='pacificus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllogomphoides' AND (junior_species='pacificus' OR junior_species='pacificus')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='Phyllogomphoides' AND (species='pacificus' OR species='pacificus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brechmorhoga' AND (junior_species='praecox' OR junior_species='praecox')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brechmorhoga' AND (species='praecox' OR species='praecox') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brechmorhoga' AND (species='praecox' OR species='praecox')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brechmorhoga' AND (junior_species='praecox' OR junior_species='praecox')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='Brechmorhoga' AND (species='praecox' OR species='praecox') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macrothemis' AND (junior_species='pseudimitans' OR junior_species='pseudimitans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macrothemis' AND (species='pseudimitans' OR species='pseudimitans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macrothemis' AND (species='pseudimitans' OR species='pseudimitans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macrothemis' AND (junior_species='pseudimitans' OR junior_species='pseudimitans')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='Macrothemis' AND (species='pseudimitans' OR species='pseudimitans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paltothemis' AND (junior_species='lineatipes' OR junior_species='lineatipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paltothemis' AND (species='lineatipes' OR species='lineatipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paltothemis' AND (species='lineatipes' OR species='lineatipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paltothemis' AND (junior_species='lineatipes' OR junior_species='lineatipes')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='Paltothemis' AND (species='lineatipes' OR species='lineatipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudoleon' AND (junior_species='superbus' OR junior_species='superbus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudoleon' AND (species='superbus' OR species='superbus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudoleon' AND (species='superbus' OR species='superbus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudoleon' AND (junior_species='superbus' OR junior_species='superbus')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='Pseudoleon' AND (species='superbus' OR species='superbus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1579 The Ecological Register: Rio Pinolapa (autumn)
Rio Pinolapa (autumn)
Basic information
Sample name: Rio Pinolapa (autumn)

Reference: J. A. Gómez-Anaya and R. Novelo-Gutiérrez. 2010. Richness and structure of an Odonata larval assemblage from Río Pinolapa, Tepalcatepec, Michoacán, Mexico in relation to their habitat characteristics. Odonatologica 39(4):287-303 [ER 1070]
Geography
Country: Mexico

State: Michoacân


Coordinate: 19° 0' 31" N, 103° 1' 27" W
Coordinate basis: stated in text

Geography comments: "in the municipality of Tepalcatepec" (the stated coordinate is well to the SW of Tepalcatepec)

Environment
Habitat: desert/xeric shrubland

Substrate: ground surface

Habitat comments: unaltered shrubland based on satellite photos

Methods
Life forms: odonates

Sampling methods: no design,other nets

Sample size: 1452 individuals

Seasons: autumn

Sampling comments: "Larvae were collected twice in each season (8 trips in total) at shores, and riffles (at mid-channel) and eddies... We used an aquatic D-frame net"

Metadata
Sample number: 1579

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-05-22 12:45:32

Modified: 2015-05-22 02:45:53

Abundance distribution
16 species
1 singleton
total count 1452
extrapolated richness: 18.8
Fisher's α: 2.516
geometric series k: 0.6499
Hurlbert's PIE: 0.7110
Shannon's H: 1.6306
Good's u: 0.9993
Each square represents a species. Square sizes are proportional to counts.
Register