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=1623 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1623SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1107SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1623 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='Lestes' AND (junior_species='viridis' OR junior_species='viridis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lestes' AND (species='viridis' OR species='viridis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lestes' AND (species='viridis' OR species='viridis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lestes' AND (junior_species='viridis' OR junior_species='viridis')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='Lestes' AND (species='viridis' OR species='viridis') 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='Boyeria' AND (junior_species='irene' OR junior_species='irene')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boyeria' AND (species='irene' OR species='irene') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boyeria' AND (species='irene' OR species='irene')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boyeria' AND (junior_species='irene' OR junior_species='irene')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='Boyeria' AND (species='irene' OR species='irene') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gomphus' AND (junior_species='graslinii' OR junior_species='graslini')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gomphus' AND (species='graslinii' OR species='graslini') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gomphus' AND (species='graslinii' OR species='graslini')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gomphus' AND (junior_species='graslinii' OR junior_species='graslini')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='graslinii' OR species='graslini') 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='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='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='Oxygastra' AND (junior_species='curtisii' OR junior_species='curtisi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oxygastra' AND (species='curtisii' OR species='curtisi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oxygastra' AND (species='curtisii' OR species='curtisi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxygastra' AND (junior_species='curtisii' OR junior_species='curtisi')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='Oxygastra' AND (species='curtisii' OR species='curtisi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macromia' 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='Macromia' AND (species='splendens' OR species='splendens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macromia' AND (species='splendens' OR species='splendens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macromia' 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='Macromia' AND (species='splendens' OR species='splendens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trithemis' AND (junior_species='annulata' OR junior_species='annulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trithemis' AND (species='annulata' OR species='annulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trithemis' AND (species='annulata' OR species='annulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trithemis' AND (junior_species='annulata' OR junior_species='annulata')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='annulata' OR species='annulata') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1623 The Ecological Register: Cañaveroso stream
Cañaveroso stream
Basic information
Sample name: Cañaveroso stream

Sample aka: E1

Reference: M. Ferreras-Romero, J. Márquez-Rodríguez, and A. Ruiz-García. 2009. Implications of anthropogenic disturbance factors on the Odonata assemblage in a Mediterranean fluvial system. International Journal of Odonatology 12(2):413-428 [ER 1107]
Geography
Country: Spain


Coordinate: 37° 31' N, 6° 16' W
Coordinate basis: based on nearby landmark

Geography comments: "in the catchment of the Guadiamar River" southwest of Aznalcollar (basis of coordinate)

Environment
Habitat: Mediterranean woodland

Altered habitat: pasture

Substrate: lake bottom/stream bed

Habitat comments: "originally covered by native perennial Mediterranean forest, in which Quercus ilex dominated" and the main land use is now apparently "forest exploitation (Pinus pinaster, P. pinea), and ranching of cattle, fight-bulls, and Iberian pigs"

Methods
Life forms: odonates

Sampling methods: no design,other nets

Sample size: 363 individuals

Years: 2004 - 2008

Days: 12

Sampling comments: larvae "collected with a kick net with an opening of 25 x 25 em and 250 pm mesh. Samples at each site were taken from all microhabitats, such as pool, riffle, stream bed, submerged and emerged vegetation"

Metadata
Sample number: 1623

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-05-31 20:48:48

Modified: 2015-05-31 10:48:48

Abundance distribution
12 species
3 singletons
total count 363
extrapolated richness: 19.1
Fisher's α: 2.385
geometric series k: 0.6326
Hurlbert's PIE: 0.7101
Shannon's H: 1.5195
Good's u: 0.9918
Each square represents a species. Square sizes are proportional to counts.
Register