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=2357 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2357SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2264SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2357 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Danainae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Danainae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Danainae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Danainae' AND (junior_species='indet.' OR junior_species='indet.')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='Danainae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dryas' AND (junior_species='iulia' OR junior_species='iulia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dryas' AND (species='iulia' OR species='iulia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dryas' AND (species='iulia' OR species='iulia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dryas' AND (junior_species='iulia' OR junior_species='iulia')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='Dryas' AND (species='iulia' OR species='iulia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='ismenius' OR junior_species='ismenius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliconius' AND (species='ismenius' OR species='ismenius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliconius' AND (species='ismenius' OR species='ismenius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='ismenius' OR junior_species='ismenius')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='Heliconius' AND (species='ismenius' OR species='ismenius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceratinia' AND (junior_species='tutia' OR junior_species='tutia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ceratinia' AND (species='tutia' OR species='tutia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ceratinia' AND (species='tutia' OR species='tutia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceratinia' AND (junior_species='tutia' OR junior_species='tutia')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='Ceratinia' AND (species='tutia' OR species='tutia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dircena' AND (junior_species='relata' OR junior_species='relata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dircena' AND (species='relata' OR species='relata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dircena' AND (species='relata' OR species='relata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dircena' AND (junior_species='relata' OR junior_species='relata')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='Dircena' AND (species='relata' OR species='relata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Godyris' AND (junior_species='zavaleta' OR junior_species='zavaleta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Godyris' AND (species='zavaleta' OR species='zavaleta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Godyris' AND (species='zavaleta' OR species='zavaleta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Godyris' AND (junior_species='zavaleta' OR junior_species='zavaleta')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='Godyris' AND (species='zavaleta' OR species='zavaleta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ithomia' AND (junior_species='patilla' OR junior_species='patilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ithomia' AND (species='patilla' OR species='patilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ithomia' AND (species='patilla' OR species='patilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ithomia' AND (junior_species='patilla' OR junior_species='patilla')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='Ithomia' AND (species='patilla' OR species='patilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mechanitis' AND (junior_species='polymnia' OR junior_species='polymnia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mechanitis' AND (species='polymnia' OR species='polymnia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mechanitis' AND (species='polymnia' OR species='polymnia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mechanitis' AND (junior_species='polymnia' OR junior_species='polymnia')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='Mechanitis' AND (species='polymnia' OR species='polymnia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Napeogenes' AND (junior_species='tolosa' OR junior_species='tolosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Napeogenes' AND (species='tolosa' OR species='tolosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Napeogenes' AND (species='tolosa' OR species='tolosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Napeogenes' AND (junior_species='tolosa' OR junior_species='tolosa')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='Napeogenes' AND (species='tolosa' OR species='tolosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tithorea' AND (junior_species='tarricina' OR junior_species='tarricina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tithorea' AND (species='tarricina' OR species='tarricina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tithorea' AND (species='tarricina' OR species='tarricina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tithorea' AND (junior_species='tarricina' OR junior_species='tarricina')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='Tithorea' AND (species='tarricina' OR species='tarricina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlosyne' AND (junior_species='janais' OR junior_species='janais')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlosyne' AND (species='janais' OR species='janais') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlosyne' AND (species='janais' OR species='janais')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlosyne' AND (junior_species='janais' OR junior_species='janais')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='Chlosyne' AND (species='janais' OR species='janais') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eresia' AND (junior_species='alsina' OR junior_species='alsina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eresia' AND (species='alsina' OR species='alsina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eresia' AND (species='alsina' OR species='alsina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eresia' AND (junior_species='alsina' OR junior_species='alsina')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='Eresia' AND (species='alsina' OR species='alsina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eresia' AND (junior_species='coela' OR junior_species='coela')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eresia' AND (species='coela' OR species='coela') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eresia' AND (species='coela' OR species='coela')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eresia' AND (junior_species='coela' OR junior_species='coela')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='Eresia' AND (species='coela' OR species='coela') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melitaeinae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melitaeinae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melitaeinae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melitaeinae' AND (junior_species='indet.' OR junior_species='indet.')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='Melitaeinae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Morpho' AND (junior_species='peleides' OR junior_species='peleides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Morpho' AND (species='peleides' OR species='peleides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Morpho' AND (species='peleides' OR species='peleides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Morpho' AND (junior_species='peleides' OR junior_species='peleides')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='Morpho' AND (species='peleides' OR species='peleides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anartia' AND (junior_species='fatima' OR junior_species='fatima')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anartia' AND (species='fatima' OR species='fatima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anartia' AND (species='fatima' OR species='fatima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anartia' AND (junior_species='fatima' OR junior_species='fatima')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='Anartia' AND (species='fatima' OR species='fatima') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cissia' AND (junior_species='hermes' OR junior_species='hermes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cissia' AND (species='hermes' OR species='hermes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cissia' AND (species='hermes' OR species='hermes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cissia' AND (junior_species='hermes' OR junior_species='hermes')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='Cissia' AND (species='hermes' OR species='hermes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cissia' AND (junior_species='hesione' OR junior_species='hesione')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cissia' AND (species='hesione' OR species='hesione') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cissia' AND (species='hesione' OR species='hesione')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cissia' AND (junior_species='hesione' OR junior_species='hesione')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='Cissia' AND (species='hesione' OR species='hesione') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cissia' AND (junior_species='renata' OR junior_species='renata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cissia' AND (species='renata' OR species='renata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cissia' AND (species='renata' OR species='renata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cissia' AND (junior_species='renata' OR junior_species='renata')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='Cissia' AND (species='renata' OR species='renata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parides' AND (junior_species='erithalion' OR junior_species='erithalion')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parides' AND (species='erithalion' OR species='erithalion') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parides' AND (species='erithalion' OR species='erithalion')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parides' AND (junior_species='erithalion' OR junior_species='erithalion')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='Parides' AND (species='erithalion' OR species='erithalion') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='daira' OR junior_species='daira')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurema' AND (species='daira' OR species='daira') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurema' AND (species='daira' OR species='daira')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='daira' OR junior_species='daira')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='Eurema' AND (species='daira' OR species='daira') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='gratiosa' OR junior_species='gratiosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurema' AND (species='gratiosa' OR species='gratiosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurema' AND (species='gratiosa' OR species='gratiosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='gratiosa' OR junior_species='gratiosa')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='Eurema' AND (species='gratiosa' OR species='gratiosa') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2357 The Ecological Register: El Castillo (border zone)
El Castillo (border zone)
Basic information
Sample name: El Castillo (border zone)

Reference: J. Herrera-Vásquez, A. Zúñiga Saborío, and C. M. Porras Cruz. 2008. Butterflies diversity in a tropical rainforest gradient of Arenal, Costa Rica. Brenesia 70:61-64 [ER 2264]
Geography
Country: Costa Rica

State: Alajuela


Coordinate: 10° 24' 49" N, 84° 45' 30" W
Coordinate basis: stated in text as range

Geography comments: "in El Castillo, Peñas Blancas, San Ramón, Alajuela"

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Substrate: ground surface

Disturbance: grazing

MAT: 27.0

MAP: 1745.0

Habitat comments: "between the Tropical moist forest and premontane moist forest life zones" and specifically on the border between primary forest and grassland (meaning pasture)
climate data are for Peñas Blancas and are from Moya and Calvo-Alvarado (2012, Annals of Forest Science)

Methods
Life forms: butterflies

Sites: 1

Site length: 550

Site width: 15

Sampling methods: belt transect,butterfly nets

Sample size: 59 captures or sightings

Years: 2006, 2007

Sampling comments: "The investigation was conducted... during August 2006 - January 2007... There were selected three consecutive transects of 550 m long and 15 m wide each. The first transect was placed in a primary forest zone, the second one in a border zone (Taking 75 m in and 75 out of the border middle line) and the third one was located in a grassland zone. Two samples were taken one month apart. Butterflies were collected using hand nets... The sampling effort was of eight hours per habitat for a total of 42 hours by sampling month. Specimens were identified using a single code and released in the same capture place, only the rare species (when necessary) were preserved"

Metadata
Sample number: 2357

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-10-29 20:52:57

Modified: 2016-12-13 00:00:10

Abundance distribution
22 species
9 singletons
total count 59
extrapolated richness: 56.8
Fisher's α: 12.720
geometric series k: 0.8921
Hurlbert's PIE: 0.9161
Shannon's H: 2.7825
Good's u: 0.8503
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Danainae indet.1
Dryas iulia3
Heliconius ismenius1
Ceratinia tutia2
Dircena relata1
Godyris zavaleta3
Ithomia patilla3
Mechanitis polymnia2
Napeogenes tolosa1
Tithorea tarricina3
Chlosyne janais2
Eresia alsina2
Eresia coela1
Melitaeinae indet.1
Morpho peleides4
Anartia fatima7
Cissia hermes6
Cissia hesione11
Cissia renata1
Parides erithalion1
Eurema daira2
Eurema gratiosa1