Coordinate: 10° 25' 19" N, 84° 0' 54" W
climate data based on Kennedy and Horn (2008)
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=399 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=399SELECT 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=399 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='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='caryophyllaceus' OR junior_species='caryophyllaceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eleutherodactylus' AND (species='caryophyllaceus' OR species='caryophyllaceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eleutherodactylus' AND (species='caryophyllaceus' OR species='caryophyllaceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='caryophyllaceus' OR junior_species='caryophyllaceus')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='caryophyllaceus' OR species='caryophyllaceus') 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='cruentus' OR junior_species='cruentus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eleutherodactylus' AND (species='cruentus' OR species='cruentus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eleutherodactylus' AND (species='cruentus' OR species='cruentus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='cruentus' OR junior_species='cruentus')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='cruentus' OR species='cruentus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='diastema' OR junior_species='diastema')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eleutherodactylus' AND (species='diastema' OR species='diastema') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eleutherodactylus' AND (species='diastema' OR species='diastema')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='diastema' OR junior_species='diastema')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='diastema' OR species='diastema') 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='ridens' OR junior_species='ridens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eleutherodactylus' AND (species='ridens' OR species='ridens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eleutherodactylus' AND (species='ridens' OR species='ridens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='ridens' OR junior_species='ridens')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='ridens' OR species='ridens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='talamancae' OR junior_species='talamancae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eleutherodactylus' AND (species='talamancae' OR species='talamancae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eleutherodactylus' AND (species='talamancae' OR species='talamancae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='talamancae' OR junior_species='talamancae')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='talamancae' OR species='talamancae') 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='Lithobates' AND (junior_species='warszewitschii' OR junior_species='warszewitschi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lithobates' AND (species='warszewitschii' OR species='warszewitschi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lithobates' AND (species='warszewitschii' OR species='warszewitschi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithobates' AND (junior_species='warszewitschii' OR junior_species='warszewitschi')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='Lithobates' AND (species='warszewitschii' OR species='warszewitschi') 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='Ameiva' AND (junior_species='festiva' OR junior_species='festiva')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ameiva' AND (species='festiva' OR species='festiva') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ameiva' AND (species='festiva' OR species='festiva')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ameiva' AND (junior_species='festiva' OR junior_species='festiva')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='Ameiva' AND (species='festiva' OR species='festiva') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nothopsis' AND (junior_species='rugosus' OR junior_species='rugosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nothopsis' AND (species='rugosus' OR species='rugosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nothopsis' AND (species='rugosus' OR species='rugosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nothopsis' AND (junior_species='rugosus' OR junior_species='rugosus')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='Nothopsis' AND (species='rugosus' OR species='rugosus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=399