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=398 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=398SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=183SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=398 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrobates' AND (junior_species='pumilo' OR junior_species='pumilo')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendrobates' AND (species='pumilo' OR species='pumilo') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendrobates' AND (species='pumilo' OR species='pumilo')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrobates' AND (junior_species='pumilo' OR junior_species='pumilo')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='Dendrobates' AND (species='pumilo' OR species='pumilo') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ololygon' AND (junior_species='elaeochroa' OR junior_species='elaeochroa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ololygon' AND (species='elaeochroa' OR species='elaeochroa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ololygon' AND (species='elaeochroa' OR species='elaeochroa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ololygon' AND (junior_species='elaeochroa' OR junior_species='elaeochroa')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='Ololygon' AND (species='elaeochroa' OR species='elaeochroa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='biporcatus' OR junior_species='biporcatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eleutherodactylus' AND (species='biporcatus' OR species='biporcatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eleutherodactylus' AND (species='biporcatus' OR species='biporcatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='biporcatus' OR junior_species='biporcatus')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='Eleutherodactylus' AND (species='biporcatus' OR species='biporcatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='bransfordii' OR junior_species='bransfordi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eleutherodactylus' AND (species='bransfordii' OR species='bransfordi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eleutherodactylus' AND (species='bransfordii' OR species='bransfordi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='bransfordii' OR junior_species='bransfordi')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='Eleutherodactylus' AND (species='bransfordii' OR species='bransfordi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='cerasinus' OR junior_species='cerasinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eleutherodactylus' AND (species='cerasinus' OR species='cerasinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eleutherodactylus' AND (species='cerasinus' OR species='cerasinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='cerasinus' OR junior_species='cerasinus')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='Eleutherodactylus' AND (species='cerasinus' OR species='cerasinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='crassidigitus' OR junior_species='crassidigitus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eleutherodactylus' AND (species='crassidigitus' OR species='crassidigitus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eleutherodactylus' AND (species='crassidigitus' OR species='crassidigitus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='crassidigitus' OR junior_species='crassidigitus')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='Eleutherodactylus' AND (species='crassidigitus' OR species='crassidigitus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='fitzingeri' OR junior_species='fitzingerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eleutherodactylus' AND (species='fitzingeri' OR species='fitzingerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eleutherodactylus' AND (species='fitzingeri' OR species='fitzingerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='fitzingeri' OR junior_species='fitzingerii')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='Eleutherodactylus' AND (species='fitzingeri' OR species='fitzingerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='mimus' OR junior_species='mimus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eleutherodactylus' AND (species='mimus' OR species='mimus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eleutherodactylus' AND (species='mimus' OR species='mimus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='mimus' OR junior_species='mimus')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='Eleutherodactylus' AND (species='mimus' OR species='mimus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' 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='Eleutherodactylus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eleutherodactylus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' 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='Eleutherodactylus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gastrophryne' AND (junior_species='pictiventris' OR junior_species='pictiventris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gastrophryne' AND (species='pictiventris' OR species='pictiventris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gastrophryne' AND (species='pictiventris' OR species='pictiventris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gastrophryne' AND (junior_species='pictiventris' OR junior_species='pictiventris')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='Gastrophryne' AND (species='pictiventris' OR species='pictiventris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oedipina' 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='Oedipina' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oedipina' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oedipina' 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='Oedipina' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepidoblepharis' AND (junior_species='xanthostigma' OR junior_species='xanthostigma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepidoblepharis' AND (species='xanthostigma' OR species='xanthostigma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lepidoblepharis' AND (species='xanthostigma' OR species='xanthostigma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepidoblepharis' AND (junior_species='xanthostigma' OR junior_species='xanthostigma')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='Lepidoblepharis' AND (species='xanthostigma' OR species='xanthostigma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Norops' AND (junior_species='capito' OR junior_species='capito')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Norops' AND (species='capito' OR species='capito') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Norops' AND (species='capito' OR species='capito')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Norops' AND (junior_species='capito' OR junior_species='capito')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='Norops' AND (species='capito' OR species='capito') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Norops' AND (junior_species='humilis' OR junior_species='humilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Norops' AND (species='humilis' OR species='humilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Norops' AND (species='humilis' OR species='humilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Norops' AND (junior_species='humilis' OR junior_species='humilis')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='Norops' AND (species='humilis' OR species='humilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Norops' AND (junior_species='limifrons' OR junior_species='limifrons')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Norops' AND (species='limifrons' OR species='limifrons') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Norops' AND (species='limifrons' OR species='limifrons')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Norops' AND (junior_species='limifrons' OR junior_species='limifrons')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='Norops' AND (species='limifrons' OR species='limifrons') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mabuya' AND (junior_species='unimarginata' OR junior_species='unimarginata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mabuya' AND (species='unimarginata' OR species='unimarginata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mabuya' AND (species='unimarginata' OR species='unimarginata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mabuya' AND (junior_species='unimarginata' OR junior_species='unimarginata')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='Mabuya' AND (species='unimarginata' OR species='unimarginata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphenomorphus' AND (junior_species='cherriei' OR junior_species='cherrieii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sphenomorphus' AND (species='cherriei' OR species='cherrieii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sphenomorphus' AND (species='cherriei' OR species='cherrieii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphenomorphus' AND (junior_species='cherriei' OR junior_species='cherrieii')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='Sphenomorphus' AND (species='cherriei' OR species='cherrieii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coniophanes' AND (junior_species='fissidens' OR junior_species='fissidens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coniophanes' AND (species='fissidens' OR species='fissidens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coniophanes' AND (species='fissidens' OR species='fissidens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coniophanes' AND (junior_species='fissidens' OR junior_species='fissidens')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='Coniophanes' AND (species='fissidens' OR species='fissidens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ninia' AND (junior_species='maculata' OR junior_species='maculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ninia' AND (species='maculata' OR species='maculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ninia' AND (species='maculata' OR species='maculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ninia' AND (junior_species='maculata' OR junior_species='maculata')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='Ninia' AND (species='maculata' OR species='maculata') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=398 The Ecological Register: La Selva Biological Station (old cacao)
La Selva Biological Station (old cacao)
Basic information
Sample name: La Selva Biological Station (old cacao)

Reference: J. T. Heinen. 1992. Comparisons of the leaf litter herpetofauna in abandoned cacao plantations and primary rain forest in Costa Rica: some implications for faunal restoration. Biotropica 24(3):431-439 [ER 183]
Geography
Country: Costa Rica

State: Heredia


Coordinate: 10° 25' 19" N, 84° 0' 54" W
Coordinate basis: based on nearby landmark

Geography comments: coordinate based on Wikipedia page

Environment
Habitat: tropical/subtropical dry broadleaf forest

Altered habitat: plantation

Substrate: ground surface

MAT: 26.0

MAP: 4260.0

Habitat comments: "cacao plantation abandoned 5 years previously"
climate data based on Kennedy and Horn (2008)

Methods
Life forms: lizards,snakes,frogs,salamanders

Sites: 25

Site area: 0.062

Sampling methods: quadrat,hand capture

Sample size: 147 individuals

Years: 1990

Sampling comments: 25 5 x 5 m plots

Metadata
Sample number: 398

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-14 15:17:00

Modified: 2014-04-26 01:21:14

Abundance distribution
19 species
8 singletons
total count 147
extrapolated richness: 44.4
Fisher's α: 5.812
geometric series k: 0.7891
Hurlbert's PIE: 0.7210
Shannon's H: 1.8551
Good's u: 0.9459
Each square represents a species. Square sizes are proportional to counts.
Register