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=2312 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2312SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2252SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2312 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hetaerina' AND (junior_species='miniata' OR junior_species='miniata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hetaerina' AND (species='miniata' OR species='miniata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hetaerina' AND (species='miniata' OR species='miniata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hetaerina' AND (junior_species='miniata' OR junior_species='miniata')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='miniata' OR species='miniata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='adamsi' OR junior_species='adamsii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Argia' AND (species='adamsi' OR species='adamsii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argia' AND (species='adamsi' OR species='adamsii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='adamsi' OR junior_species='adamsii')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='adamsi' OR species='adamsii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perissolestes' AND (junior_species='remotus' OR junior_species='remotus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perissolestes' AND (species='remotus' OR species='remotus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perissolestes' AND (species='remotus' OR species='remotus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perissolestes' AND (junior_species='remotus' OR junior_species='remotus')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='Perissolestes' AND (species='remotus' OR species='remotus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psaironeura' AND (junior_species='remissa' OR junior_species='remissa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psaironeura' AND (species='remissa' OR species='remissa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psaironeura' AND (species='remissa' OR species='remissa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psaironeura' AND (junior_species='remissa' OR junior_species='remissa')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='Psaironeura' AND (species='remissa' OR species='remissa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protoneura' 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='Protoneura' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protoneura' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protoneura' 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='Protoneura' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrodiplax' AND (junior_species='fusca' OR junior_species='fusca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythrodiplax' AND (species='fusca' OR species='fusca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythrodiplax' AND (species='fusca' OR species='fusca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrodiplax' AND (junior_species='fusca' OR junior_species='fusca')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='Erythrodiplax' AND (species='fusca' OR species='fusca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrodiplax' AND (junior_species='umbrata' OR junior_species='umbrata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythrodiplax' AND (species='umbrata' OR species='umbrata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythrodiplax' AND (species='umbrata' OR species='umbrata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrodiplax' AND (junior_species='umbrata' OR junior_species='umbrata')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='Erythrodiplax' AND (species='umbrata' OR species='umbrata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligoclada' AND (junior_species='umbricola' OR junior_species='umbricola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oligoclada' AND (species='umbricola' OR species='umbricola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oligoclada' AND (species='umbricola' OR species='umbricola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligoclada' AND (junior_species='umbricola' OR junior_species='umbricola')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='Oligoclada' AND (species='umbricola' OR species='umbricola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhodopygia' AND (junior_species='cardinalis' OR junior_species='cardinalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhodopygia' AND (species='cardinalis' OR species='cardinalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhodopygia' AND (species='cardinalis' OR species='cardinalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhodopygia' AND (junior_species='cardinalis' OR junior_species='cardinalis')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='Rhodopygia' AND (species='cardinalis' OR species='cardinalis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2312 The Ecological Register: Quebrada San Isidro (PC1)
Quebrada San Isidro (PC1)
Basic information
Sample name: Quebrada San Isidro (PC1)

Sample aka: Reserva Natural Cabildo Verde

Reference: C. Garzón Sanabria and E. Realpe. 2009. Diversidad de Odonata (Insecta) en la Reserva Natural Cabildo-Verde (Sabana de Torres-Santander, Colombia), una aproximación hacia la conservación. Caldasia 31(2):459-470 [ER 2252]
Geography
Country: Colombia


Coordinate: 7° 24' N, 73° 30' W
Coordinate basis: based on political unit

Geography comments: "en la Reserva Natural Cabildo Verde y sus alrededores en el Municipio de Sabana de Torres (Santander)" (coordinate based on Sabana de Torres)
elevation 100 to 300 m

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Altered habitat: secondary forest

Protection: nature reserve

Substrate: ground surface

MAP: 4000.0

Habitat comments: "El ecosistema que conforma la reserva natural Cabildo Verde es Bosque Hùmedo Tropical (BHT), que corresponde a un bosque secundario en recuperación, con un régimen de precipitación anual marcando una tendencia estacional con periodos lluviosos que se extienden de marzo a junio y de agosto a noviembre... La Temperatura oscila entre un rango de 27.87 - 35.4 ºC" (not clear what this means as a table gives MAT as ">24ºC")

Methods
Life forms: odonates

Sampling methods: no design,hand capture

Sample size: 39 individuals

Days: 12

Seasons: dry,wet or monsoon

Sampling comments: "Se realizaron dos salidas de campo de seis días cada una, de acuerdo al régimen climâtico de la zona, la primera jornada se realizo durante época seca y la segunda en época de lluvias, donde se colectó el material en cada estación de muestreo. La recolecta de los ejemplares se realizo siguiendo el método tradicional de jameo, (colecta activa), incluyendo solo individuos en estado adulto, con un esfuerzo de muestreo de dos personas y una intensidad de 7 horas diarias distribuidas de la siguiente manera entre 08:30-13:00 y 14:00-16:30 teniendo en cuenta el horario de actividad de los individuos, realizândose el mismo esfuerzo en cada una de las estaciones"

Metadata
Sample number: 2312

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-10-21 15:16:51

Modified: 2018-06-30 11:28:27

Abundance distribution
9 species
2 singletons
total count 39
extrapolated richness: 15.1
Fisher's α: 3.668
geometric series k: 0.7711
Hurlbert's PIE: 0.8482
Shannon's H: 2.0100
Good's u: 0.9500
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Hetaerina miniata7
Argia adamsi8
Perissolestes remotus5
Psaironeura remissa6
Protoneura sp. 16
Erythrodiplax fusca1
Erythrodiplax umbrata1
Oligoclada umbricola3
Rhodopygia cardinalis2