Coordinate: 9° 9' N, 79° 51' W
elevation based on sample 2774
counts and basal area painfully hand-calculated from a complete list of individuals
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=2027 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2027SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2084SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2027 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alseis' AND (junior_species='blackiana' OR junior_species='blackiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alseis' AND (species='blackiana' OR species='blackiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alseis' AND (species='blackiana' OR species='blackiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alseis' AND (junior_species='blackiana' OR junior_species='blackiana')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='Alseis' AND (species='blackiana' OR species='blackiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brosimum' AND (junior_species='alicastrum' OR junior_species='alicastrum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brosimum' AND (species='alicastrum' OR species='alicastrum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brosimum' AND (species='alicastrum' OR species='alicastrum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brosimum' AND (junior_species='alicastrum' OR junior_species='alicastrum')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='Brosimum' AND (species='alicastrum' OR species='alicastrum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calophyllum' AND (junior_species='longifolium' OR junior_species='longifolium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calophyllum' AND (species='longifolium' OR species='longifolium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calophyllum' AND (species='longifolium' OR species='longifolium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calophyllum' AND (junior_species='longifolium' OR junior_species='longifolium')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='Calophyllum' AND (species='longifolium' OR species='longifolium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coussarea' AND (junior_species='curvigemmia' OR junior_species='curvigemmia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coussarea' AND (species='curvigemmia' OR species='curvigemmia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coussarea' AND (species='curvigemmia' OR species='curvigemmia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coussarea' AND (junior_species='curvigemmia' OR junior_species='curvigemmia')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='Coussarea' AND (species='curvigemmia' OR species='curvigemmia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cupania' AND (junior_species='sylvatica' OR junior_species='sylvatica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cupania' AND (species='sylvatica' OR species='sylvatica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cupania' AND (species='sylvatica' OR species='sylvatica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cupania' AND (junior_species='sylvatica' OR junior_species='sylvatica')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='Cupania' AND (species='sylvatica' OR species='sylvatica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Faramea' AND (junior_species='occidentalis' OR junior_species='occidentalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Faramea' AND (species='occidentalis' OR species='occidentalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Faramea' AND (species='occidentalis' OR species='occidentalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Faramea' AND (junior_species='occidentalis' OR junior_species='occidentalis')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='Faramea' AND (species='occidentalis' OR species='occidentalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' AND (junior_species='intermedia' OR junior_species='intermedia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Garcinia' AND (species='intermedia' OR species='intermedia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Garcinia' AND (species='intermedia' OR species='intermedia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' AND (junior_species='intermedia' OR junior_species='intermedia')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='Garcinia' AND (species='intermedia' OR species='intermedia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guapira' AND (junior_species='standleyanum' OR junior_species='standleyanum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Guapira' AND (species='standleyanum' OR species='standleyanum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Guapira' AND (species='standleyanum' OR species='standleyanum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guapira' AND (junior_species='standleyanum' OR junior_species='standleyanum')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='Guapira' AND (species='standleyanum' OR species='standleyanum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gustavia' AND (junior_species='superba' OR junior_species='superba')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gustavia' AND (species='superba' OR species='superba') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gustavia' AND (species='superba' OR species='superba')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gustavia' AND (junior_species='superba' OR junior_species='superba')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='Gustavia' AND (species='superba' OR species='superba') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heisteria' AND (junior_species='concinna' OR junior_species='concinna')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heisteria' AND (species='concinna' OR species='concinna') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heisteria' AND (species='concinna' OR species='concinna')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heisteria' AND (junior_species='concinna' OR junior_species='concinna')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='Heisteria' AND (species='concinna' OR species='concinna') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hirtella' AND (junior_species='triandra' OR junior_species='triandra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hirtella' AND (species='triandra' OR species='triandra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hirtella' AND (species='triandra' OR species='triandra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hirtella' AND (junior_species='triandra' OR junior_species='triandra')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='Hirtella' AND (species='triandra' OR species='triandra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='quaternata' OR junior_species='quaternata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Inga' AND (species='quaternata' OR species='quaternata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Inga' AND (species='quaternata' OR species='quaternata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='quaternata' OR junior_species='quaternata')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='Inga' AND (species='quaternata' OR species='quaternata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Licania' AND (junior_species='platypus' OR junior_species='platypus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Licania' AND (species='platypus' OR species='platypus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Licania' AND (species='platypus' OR species='platypus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Licania' AND (junior_species='platypus' OR junior_species='platypus')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='Licania' AND (species='platypus' OR species='platypus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Luehea' AND (junior_species='seemannii' OR junior_species='seemanni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Luehea' AND (species='seemannii' OR species='seemanni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Luehea' AND (species='seemannii' OR species='seemanni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Luehea' AND (junior_species='seemannii' OR junior_species='seemanni')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='Luehea' AND (species='seemannii' OR species='seemanni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maquira' AND (junior_species='costaricana' OR junior_species='costaricana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Maquira' AND (species='costaricana' OR species='costaricana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Maquira' AND (species='costaricana' OR species='costaricana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maquira' AND (junior_species='costaricana' OR junior_species='costaricana')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='Maquira' AND (species='costaricana' OR species='costaricana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macrocnemum' AND (junior_species='roseum' OR junior_species='roseum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macrocnemum' AND (species='roseum' OR species='roseum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macrocnemum' AND (species='roseum' OR species='roseum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macrocnemum' AND (junior_species='roseum' OR junior_species='roseum')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='Macrocnemum' AND (species='roseum' OR species='roseum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oenocarpus' AND (junior_species='mapora' OR junior_species='mapora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oenocarpus' AND (species='mapora' OR species='mapora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oenocarpus' AND (species='mapora' OR species='mapora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oenocarpus' AND (junior_species='mapora' OR junior_species='mapora')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='Oenocarpus' AND (species='mapora' OR species='mapora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protium' AND (junior_species='panamense' OR junior_species='panamense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protium' AND (species='panamense' OR species='panamense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protium' AND (species='panamense' OR species='panamense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protium' AND (junior_species='panamense' OR junior_species='panamense')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='Protium' AND (species='panamense' OR species='panamense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protium' AND (junior_species='tenuifolium' OR junior_species='tenuifolium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protium' AND (species='tenuifolium' OR species='tenuifolium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protium' AND (species='tenuifolium' OR species='tenuifolium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protium' AND (junior_species='tenuifolium' OR junior_species='tenuifolium')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='Protium' AND (species='tenuifolium' OR species='tenuifolium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quararibea' AND (junior_species='asterolepis' OR junior_species='asterolepis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quararibea' AND (species='asterolepis' OR species='asterolepis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quararibea' AND (species='asterolepis' OR species='asterolepis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quararibea' AND (junior_species='asterolepis' OR junior_species='asterolepis')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='Quararibea' AND (species='asterolepis' OR species='asterolepis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quassia' AND (junior_species='amara' OR junior_species='amara')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quassia' AND (species='amara' OR species='amara') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quassia' AND (species='amara' OR species='amara')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quassia' AND (junior_species='amara' OR junior_species='amara')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='Quassia' AND (species='amara' OR species='amara') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorocea' AND (junior_species='affinis' OR junior_species='affinis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sorocea' AND (species='affinis' OR species='affinis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sorocea' AND (species='affinis' OR species='affinis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorocea' AND (junior_species='affinis' OR junior_species='affinis')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='Sorocea' AND (species='affinis' OR species='affinis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Swartzia' AND (junior_species='simplex' OR junior_species='simplex')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Swartzia' AND (species='simplex' OR species='simplex') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Swartzia' AND (species='simplex' OR species='simplex')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Swartzia' AND (junior_species='simplex' OR junior_species='simplex')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='Swartzia' AND (species='simplex' OR species='simplex') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tabernaemontana' AND (junior_species='arborea' OR junior_species='arborea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tabernaemontana' AND (species='arborea' OR species='arborea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tabernaemontana' AND (species='arborea' OR species='arborea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tabernaemontana' AND (junior_species='arborea' OR junior_species='arborea')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='Tabernaemontana' AND (species='arborea' OR species='arborea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichilia' AND (junior_species='tuberculata' OR junior_species='tuberculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trichilia' AND (species='tuberculata' OR species='tuberculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trichilia' AND (species='tuberculata' OR species='tuberculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichilia' AND (junior_species='tuberculata' OR junior_species='tuberculata')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='Trichilia' AND (species='tuberculata' OR species='tuberculata') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2027