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=2062 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2062SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2111SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2062 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lindackeria' AND (junior_species='paludosa' OR junior_species='paludosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lindackeria' AND (species='paludosa' OR species='paludosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lindackeria' AND (species='paludosa' OR species='paludosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lindackeria' AND (junior_species='paludosa' OR junior_species='paludosa')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='Lindackeria' AND (species='paludosa' OR species='paludosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Astronium' AND (junior_species='graveolens' OR junior_species='graveolens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Astronium' AND (species='graveolens' OR species='graveolens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Astronium' AND (species='graveolens' OR species='graveolens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Astronium' AND (junior_species='graveolens' OR junior_species='graveolens')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='Astronium' AND (species='graveolens' OR species='graveolens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aspidosperma' AND (junior_species='parvifolium' OR junior_species='parvifolium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aspidosperma' AND (species='parvifolium' OR species='parvifolium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aspidosperma' AND (species='parvifolium' OR species='parvifolium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aspidosperma' AND (junior_species='parvifolium' OR junior_species='parvifolium')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='Aspidosperma' AND (species='parvifolium' OR species='parvifolium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Himatanthus' AND (junior_species='articulatus' OR junior_species='articulatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Himatanthus' AND (species='articulatus' OR species='articulatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Himatanthus' AND (species='articulatus' OR species='articulatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Himatanthus' AND (junior_species='articulatus' OR junior_species='articulatus')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='Himatanthus' AND (species='articulatus' OR species='articulatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Socratea' AND (junior_species='exorrhiza' OR junior_species='exorrhiza')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Socratea' AND (species='exorrhiza' OR species='exorrhiza') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Socratea' AND (species='exorrhiza' OR species='exorrhiza')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Socratea' AND (junior_species='exorrhiza' OR junior_species='exorrhiza')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='Socratea' AND (species='exorrhiza' OR species='exorrhiza') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jacaranda' AND (junior_species='copaia' OR junior_species='copaia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Jacaranda' AND (species='copaia' OR species='copaia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Jacaranda' AND (species='copaia' OR species='copaia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jacaranda' AND (junior_species='copaia' OR junior_species='copaia')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='Jacaranda' AND (species='copaia' OR species='copaia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordia' AND (junior_species='bicolor' OR junior_species='bicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cordia' AND (species='bicolor' OR species='bicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cordia' AND (species='bicolor' OR species='bicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordia' AND (junior_species='bicolor' OR junior_species='bicolor')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='Cordia' AND (species='bicolor' OR species='bicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordia' AND (junior_species='nodosa' OR junior_species='nodosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cordia' AND (species='nodosa' OR species='nodosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cordia' AND (species='nodosa' OR species='nodosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordia' AND (junior_species='nodosa' OR junior_species='nodosa')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='Cordia' AND (species='nodosa' OR species='nodosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetragastris' AND (junior_species='panamensis' OR junior_species='panamensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetragastris' AND (species='panamensis' OR species='panamensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetragastris' AND (species='panamensis' OR species='panamensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetragastris' AND (junior_species='panamensis' OR junior_species='panamensis')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='Tetragastris' AND (species='panamensis' OR species='panamensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dialium' AND (junior_species='guianense' OR junior_species='guianense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dialium' AND (species='guianense' OR species='guianense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dialium' AND (species='guianense' OR species='guianense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dialium' AND (junior_species='guianense' OR junior_species='guianense')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='Dialium' AND (species='guianense' OR species='guianense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachigali' AND (junior_species='paniculata' OR junior_species='paniculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tachigali' AND (species='paniculata' OR species='paniculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tachigali' AND (species='paniculata' OR species='paniculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachigali' AND (junior_species='paniculata' OR junior_species='paniculata')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='Tachigali' AND (species='paniculata' OR species='paniculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Symphonia' AND (junior_species='globulifera' OR junior_species='globulifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Symphonia' AND (species='globulifera' OR species='globulifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Symphonia' AND (species='globulifera' OR species='globulifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Symphonia' AND (junior_species='globulifera' OR junior_species='globulifera')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='Symphonia' AND (species='globulifera' OR species='globulifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alchornea' AND (junior_species='glandulosa' OR junior_species='glandulosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alchornea' AND (species='glandulosa' OR species='glandulosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alchornea' AND (species='glandulosa' OR species='glandulosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alchornea' AND (junior_species='glandulosa' OR junior_species='glandulosa')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='Alchornea' AND (species='glandulosa' OR species='glandulosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glycydendron' AND (junior_species='amazonicum' OR junior_species='amazonicum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glycydendron' AND (species='amazonicum' OR species='amazonicum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glycydendron' AND (species='amazonicum' OR species='amazonicum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glycydendron' AND (junior_species='amazonicum' OR junior_species='amazonicum')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='Glycydendron' AND (species='amazonicum' OR species='amazonicum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hevea' AND (junior_species='guianensis' OR junior_species='guianensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hevea' AND (species='guianensis' OR species='guianensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hevea' AND (species='guianensis' OR species='guianensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hevea' AND (junior_species='guianensis' OR junior_species='guianensis')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='Hevea' AND (species='guianensis' OR species='guianensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mabea' AND (junior_species='nitida' OR junior_species='nitida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mabea' AND (species='nitida' OR species='nitida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mabea' AND (species='nitida' OR species='nitida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mabea' AND (junior_species='nitida' OR junior_species='nitida')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='Mabea' AND (species='nitida' OR species='nitida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nealchornea' AND (junior_species='yapurensis' OR junior_species='yapurensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nealchornea' AND (species='yapurensis' OR species='yapurensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nealchornea' AND (species='yapurensis' OR species='yapurensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nealchornea' AND (junior_species='yapurensis' OR junior_species='yapurensis')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='Nealchornea' AND (species='yapurensis' OR species='yapurensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sapium' AND (junior_species='glandulosum' OR junior_species='glandulosum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sapium' AND (species='glandulosum' OR species='glandulosum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sapium' AND (species='glandulosum' OR species='glandulosum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sapium' AND (junior_species='glandulosum' OR junior_species='glandulosum')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='Sapium' AND (species='glandulosum' OR species='glandulosum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nectandra' AND (junior_species='viburnoides' OR junior_species='viburnoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nectandra' AND (species='viburnoides' OR species='viburnoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nectandra' AND (species='viburnoides' OR species='viburnoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nectandra' AND (junior_species='viburnoides' OR junior_species='viburnoides')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='Nectandra' AND (species='viburnoides' OR species='viburnoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eschweilera' AND (junior_species='gigantea' OR junior_species='gigantea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eschweilera' AND (species='gigantea' OR species='gigantea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eschweilera' AND (species='gigantea' OR species='gigantea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eschweilera' AND (junior_species='gigantea' OR junior_species='gigantea')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='Eschweilera' AND (species='gigantea' OR species='gigantea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Huberodendron' AND (junior_species='swietenioides' OR junior_species='swietenioides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Huberodendron' AND (species='swietenioides' OR species='swietenioides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Huberodendron' AND (species='swietenioides' OR species='swietenioides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Huberodendron' AND (junior_species='swietenioides' OR junior_species='swietenioides')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='Huberodendron' AND (species='swietenioides' OR species='swietenioides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theobroma' AND (junior_species='speciosum' OR junior_species='speciosum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Theobroma' AND (species='speciosum' OR species='speciosum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Theobroma' AND (species='speciosum' OR species='speciosum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theobroma' AND (junior_species='speciosum' OR junior_species='speciosum')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='Theobroma' AND (species='speciosum' OR species='speciosum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='alba' OR junior_species='alba')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Inga' AND (species='alba' OR species='alba') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Inga' AND (species='alba' OR species='alba')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='alba' OR junior_species='alba')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='alba' OR species='alba') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Virola' AND (junior_species='elongata' OR junior_species='elongata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Virola' AND (species='elongata' OR species='elongata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Virola' AND (species='elongata' OR species='elongata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Virola' AND (junior_species='elongata' OR junior_species='elongata')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='Virola' AND (species='elongata' OR species='elongata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='capitata' OR junior_species='capitata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Inga' AND (species='capitata' OR species='capitata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Inga' AND (species='capitata' OR species='capitata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='capitata' OR junior_species='capitata')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='capitata' OR species='capitata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perebea' AND (junior_species='guianensis' OR junior_species='guianensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perebea' AND (species='guianensis' OR species='guianensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perebea' AND (species='guianensis' OR species='guianensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perebea' AND (junior_species='guianensis' OR junior_species='guianensis')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='Perebea' AND (species='guianensis' OR species='guianensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudolmedia' AND (junior_species='laevigata' OR junior_species='laevigata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudolmedia' AND (species='laevigata' OR species='laevigata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudolmedia' AND (species='laevigata' OR species='laevigata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudolmedia' AND (junior_species='laevigata' OR junior_species='laevigata')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='Pseudolmedia' AND (species='laevigata' OR species='laevigata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorocea' AND (junior_species='pileata' OR junior_species='pileata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sorocea' AND (species='pileata' OR species='pileata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sorocea' AND (species='pileata' OR species='pileata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorocea' AND (junior_species='pileata' OR junior_species='pileata')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='pileata' OR species='pileata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Virola' AND (junior_species='calophylla' OR junior_species='calophylla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Virola' AND (species='calophylla' OR species='calophylla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Virola' AND (species='calophylla' OR species='calophylla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Virola' AND (junior_species='calophylla' OR junior_species='calophylla')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='Virola' AND (species='calophylla' OR species='calophylla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Siparuna' AND (junior_species='decipiens' OR junior_species='decipiens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Siparuna' AND (species='decipiens' OR species='decipiens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Siparuna' AND (species='decipiens' OR species='decipiens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Siparuna' AND (junior_species='decipiens' OR junior_species='decipiens')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='Siparuna' AND (species='decipiens' OR species='decipiens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Styrax' AND (junior_species='discolor' OR junior_species='discolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Styrax' AND (species='discolor' OR species='discolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Styrax' AND (species='discolor' OR species='discolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Styrax' AND (junior_species='discolor' OR junior_species='discolor')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='Styrax' AND (species='discolor' OR species='discolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cecropia' AND (junior_species='engleriana' OR junior_species='engleriana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cecropia' AND (species='engleriana' OR species='engleriana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cecropia' AND (species='engleriana' OR species='engleriana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cecropia' AND (junior_species='engleriana' OR junior_species='engleriana')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='Cecropia' AND (species='engleriana' OR species='engleriana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pourouma' AND (junior_species='tomentosa' OR junior_species='tomentosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pourouma' AND (species='tomentosa' OR species='tomentosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pourouma' AND (species='tomentosa' OR species='tomentosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pourouma' AND (junior_species='tomentosa' OR junior_species='tomentosa')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='Pourouma' AND (species='tomentosa' OR species='tomentosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pourouma' AND (junior_species='villosa' OR junior_species='villosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pourouma' AND (species='villosa' OR species='villosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pourouma' AND (species='villosa' OR species='villosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pourouma' AND (junior_species='villosa' OR junior_species='villosa')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='Pourouma' AND (species='villosa' OR species='villosa') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2062 The Ecological Register: Tambopata River (bamboo-dominated)
Tambopata River (bamboo-dominated)
Basic information
Sample name: Tambopata River (bamboo-dominated)

Reference: B. W. Griscom, D. C. Daly, and M. S. Ashton. 2007. Floristics of bamboo-dominated stands in lowland terra-firma forests of southwestern Amazonia. Journal of the Torrey Botanical Society 134(1):108-125 [ER 2111]
Geography
Country: Peru


Coordinate: 12° 55' S, 69° 17' W
Coordinate basis: based on nearby landmark

Geography comments: "in the department of Madre de Dios" (coordinate based on Tambopata National Reserve)
altitude is for the Tambopata National Reserve and is from Palin et al. (2011, Biotropica)

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Substrate: ground surface

MAP: 2750.0

Habitat comments: bamboo-dominated "Terra Firme Sandy-Clay" forest
"Bahuaja receives approximately 2000 m rainfall per year... with precipitation reaching approximately 3500 mm per annum at the TRC site"

Methods
Life forms: trees

Sites: 5

Site area: 0.45

Sampling methods: quadrat

Sample size: 78 individuals

Years: 1999 - 2001

Size min: 5

Sampling comments: "Two study sites were selected", namely, the Bahuaja site "accessed through the Bahuaja Lodge camp site", which is "45 km downstream" of the Tampobata Research Center site; "30 x 30 meter inventory plots were established between June 1999 and August 2001, six at the TRC site and four at the Bahuaja site... Plots were distributed in pairs, each plot of a pair separated by a minimum of 30 m" with one "a bamboo-dominated forest stand (B+)" and the other "a forest stand without bamboo (B-)" (so there are five plots in each category)

Metadata
Sample number: 2062

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-06-13 15:38:45

Modified: 2017-11-10 08:07:35

Abundance distribution
34 species
14 singletons
total count 78
extrapolated richness: 92.7
Fisher's α: 22.956
geometric series k: 0.9356
Hurlbert's PIE: 0.9530
Shannon's H: 3.3007
Good's u: 0.8235
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Lindackeria paludosa1
Astronium graveolens2
Aspidosperma parvifolium6
Himatanthus articulatus4
"Himatanthus sucuuba"
Socratea exorrhiza9
Jacaranda copaia2
Cordia 'bicolor'3
Cordia nodosa3
Tetragastris panamensis2
Dialium guianense1
Tachigali cf. paniculata2
Symphonia globulifera1
Alchornea glandulosa1
Glycydendron amazonicum1
Hevea guianensis3
Mabea nitida1
Nealchornea yapurensis1
Sapium cf. glandulosum1
Nectandra viburnoides1
Eschweilera cf. gigantea3
Huberodendron swietenioides2
Theobroma speciosum6
Inga alba3
Virola cf. elongata2
"Virola cf. elongate"
Inga aff. capitata2
Perebea guianensis3
Pseudolmedia laevigata1
Sorocea pileata1
Virola calophylla3
Siparuna decipiens2
Styrax cf. discolor2
Cecropia engleriana1
Pourouma tomentosa1
Pourouma villosa1