SELECT * FROM samples WHERE sample_no=2040
SELECT person_no,first_name,last_name FROM people
SELECT * FROM refs WHERE ref_no=2094
SELECT sql FROM sqlite_master WHERE tbl_name='samples';
SELECT * FROM register WHERE sample_no=2040 ORDER BY register_no ASC
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spondias' AND (junior_species='mombin' OR junior_species='mombin')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spondias' AND (species='mombin' OR species='mombin') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Spondias' AND (species='mombin' OR species='mombin')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spondias' AND (junior_species='mombin' OR junior_species='mombin')
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='Spondias' AND (species='mombin' OR species='mombin') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stemmadenia' AND (junior_species='donnellsmithii' OR junior_species='donnellsmithi')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stemmadenia' AND (species='donnellsmithii' OR species='donnellsmithi') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Stemmadenia' AND (species='donnellsmithii' OR species='donnellsmithi')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stemmadenia' AND (junior_species='donnellsmithii' OR junior_species='donnellsmithi')
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='Stemmadenia' AND (species='donnellsmithii' OR species='donnellsmithi') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Astrocaryum' AND (junior_species='mexicanum' OR junior_species='mexicanum')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Astrocaryum' AND (species='mexicanum' OR species='mexicanum') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Astrocaryum' AND (species='mexicanum' OR species='mexicanum')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Astrocaryum' AND (junior_species='mexicanum' OR junior_species='mexicanum')
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='Astrocaryum' AND (species='mexicanum' OR species='mexicanum') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quararibea' AND (junior_species='funebris' OR junior_species='funebris')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quararibea' AND (species='funebris' OR species='funebris') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Quararibea' AND (species='funebris' OR species='funebris')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quararibea' AND (junior_species='funebris' OR junior_species='funebris')
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='funebris' OR species='funebris') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protium' AND (junior_species='confusum' OR junior_species='confusum')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protium' AND (species='confusum' OR species='confusum') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Protium' AND (species='confusum' OR species='confusum')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protium' AND (junior_species='confusum' OR junior_species='confusum')
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='confusum' OR species='confusum') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celtis' AND (junior_species='schippii' OR junior_species='schippi')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Celtis' AND (species='schippii' OR species='schippi') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Celtis' AND (species='schippii' OR species='schippi')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celtis' AND (junior_species='schippii' OR junior_species='schippi')
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='Celtis' AND (species='schippii' OR species='schippi') ORDER BY year,last_names
SELECT 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,year
SELECT *,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_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' AND (junior_species='amazonia' OR junior_species='amazonia')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Terminalia' AND (species='amazonia' OR species='amazonia') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Terminalia' AND (species='amazonia' OR species='amazonia')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' AND (junior_species='amazonia' OR junior_species='amazonia')
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='Terminalia' AND (species='amazonia' OR species='amazonia') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alchornea' AND (junior_species='latifolia' OR junior_species='latifolia')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alchornea' AND (species='latifolia' OR species='latifolia') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Alchornea' AND (species='latifolia' OR species='latifolia')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alchornea' AND (junior_species='latifolia' OR junior_species='latifolia')
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='latifolia' OR species='latifolia') ORDER BY year,last_names
SELECT 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,year
SELECT *,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_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='sapindoides' OR junior_species='sapindoides')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Inga' AND (species='sapindoides' OR species='sapindoides') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Inga' AND (species='sapindoides' OR species='sapindoides')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='sapindoides' OR junior_species='sapindoides')
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='sapindoides' OR species='sapindoides') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platymiscium' AND (junior_species='dimorphandrum' OR junior_species='dimorphandrum')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Platymiscium' AND (species='dimorphandrum' OR species='dimorphandrum') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Platymiscium' AND (species='dimorphandrum' OR species='dimorphandrum')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platymiscium' AND (junior_species='dimorphandrum' OR junior_species='dimorphandrum')
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='Platymiscium' AND (species='dimorphandrum' OR species='dimorphandrum') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pleuranthodendron' AND (junior_species='lindenii' OR junior_species='lindeni')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pleuranthodendron' AND (species='lindenii' OR species='lindeni') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Pleuranthodendron' AND (species='lindenii' OR species='lindeni')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pleuranthodendron' AND (junior_species='lindenii' OR junior_species='lindeni')
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='Pleuranthodendron' AND (species='lindenii' OR species='lindeni') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nectandra' AND (junior_species='lundellii' OR junior_species='lundelli')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nectandra' AND (species='lundellii' OR species='lundelli') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Nectandra' AND (species='lundellii' OR species='lundelli')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nectandra' AND (junior_species='lundellii' OR junior_species='lundelli')
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='lundellii' OR species='lundelli') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bunchosia' AND (junior_species='polystachia' OR junior_species='polystachia')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bunchosia' AND (species='polystachia' OR species='polystachia') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Bunchosia' AND (species='polystachia' OR species='polystachia')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bunchosia' AND (junior_species='polystachia' OR junior_species='polystachia')
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='Bunchosia' AND (species='polystachia' OR species='polystachia') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miconia' AND (junior_species='impetiolaris' OR junior_species='impetiolaris')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Miconia' AND (species='impetiolaris' OR species='impetiolaris') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Miconia' AND (species='impetiolaris' OR species='impetiolaris')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miconia' AND (junior_species='impetiolaris' OR junior_species='impetiolaris')
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='Miconia' AND (species='impetiolaris' OR species='impetiolaris') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mouriri' AND (junior_species='exilis' OR junior_species='exilis')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mouriri' AND (species='exilis' OR species='exilis') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Mouriri' AND (species='exilis' OR species='exilis')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mouriri' AND (junior_species='exilis' OR junior_species='exilis')
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='Mouriri' AND (species='exilis' OR species='exilis') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guarea' AND (junior_species='glabra' OR junior_species='glabra')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Guarea' AND (species='glabra' OR species='glabra') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Guarea' AND (species='glabra' OR species='glabra')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guarea' AND (junior_species='glabra' OR junior_species='glabra')
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='Guarea' AND (species='glabra' OR species='glabra') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guarea' AND (junior_species='grandifolia' OR junior_species='grandifolia')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Guarea' AND (species='grandifolia' OR species='grandifolia') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Guarea' AND (species='grandifolia' OR species='grandifolia')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guarea' AND (junior_species='grandifolia' OR junior_species='grandifolia')
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='Guarea' AND (species='grandifolia' OR species='grandifolia') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='guajavoides' OR junior_species='guajavoides')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ficus' AND (species='guajavoides' OR species='guajavoides') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Ficus' AND (species='guajavoides' OR species='guajavoides')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='guajavoides' OR junior_species='guajavoides')
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='Ficus' AND (species='guajavoides' OR species='guajavoides') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poulsenia' AND (junior_species='armata' OR junior_species='armata')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Poulsenia' AND (species='armata' OR species='armata') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Poulsenia' AND (species='armata' OR species='armata')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poulsenia' AND (junior_species='armata' OR junior_species='armata')
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='Poulsenia' AND (species='armata' OR species='armata') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pourouma' 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='Pourouma' AND (species='bicolor' OR species='bicolor') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Pourouma' AND (species='bicolor' OR species='bicolor')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pourouma' 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='Pourouma' AND (species='bicolor' OR species='bicolor') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Virola' AND (junior_species='koschnyi' OR junior_species='koschnyii')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Virola' AND (species='koschnyi' OR species='koschnyii') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Virola' AND (species='koschnyi' OR species='koschnyii')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Virola' AND (junior_species='koschnyi' OR junior_species='koschnyii')
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='koschnyi' OR species='koschnyii') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heisteria' AND (junior_species='media' OR junior_species='media')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heisteria' AND (species='media' OR species='media') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Heisteria' AND (species='media' OR species='media')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heisteria' AND (junior_species='media' OR junior_species='media')
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='media' OR species='media') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coccoloba' AND (junior_species='tuerckheimii' OR junior_species='tuerckheimi')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coccoloba' AND (species='tuerckheimii' OR species='tuerckheimi') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Coccoloba' AND (species='tuerckheimii' OR species='tuerckheimi')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coccoloba' AND (junior_species='tuerckheimii' OR junior_species='tuerckheimi')
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='Coccoloba' AND (species='tuerckheimii' OR species='tuerckheimi') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guettarda' AND (junior_species='macrosperma' OR junior_species='macrosperma')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Guettarda' AND (species='macrosperma' OR species='macrosperma') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Guettarda' AND (species='macrosperma' OR species='macrosperma')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guettarda' AND (junior_species='macrosperma' OR junior_species='macrosperma')
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='Guettarda' AND (species='macrosperma' OR species='macrosperma') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psychotria' AND (junior_species='simiarum' OR junior_species='simiarum')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psychotria' AND (species='simiarum' OR species='simiarum') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Psychotria' AND (species='simiarum' OR species='simiarum')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psychotria' AND (junior_species='simiarum' OR junior_species='simiarum')
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='Psychotria' AND (species='simiarum' OR species='simiarum') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zanthoxylum' AND (junior_species='ekmanii' OR junior_species='ekmani')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zanthoxylum' AND (species='ekmanii' OR species='ekmani') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Zanthoxylum' AND (species='ekmanii' OR species='ekmani')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zanthoxylum' AND (junior_species='ekmanii' OR junior_species='ekmani')
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='Zanthoxylum' AND (species='ekmanii' OR species='ekmani') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zanthoxylum' AND (junior_species='riedelianum' OR junior_species='riedelianum')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zanthoxylum' AND (species='riedelianum' OR species='riedelianum') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Zanthoxylum' AND (species='riedelianum' OR species='riedelianum')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zanthoxylum' AND (junior_species='riedelianum' OR junior_species='riedelianum')
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='Zanthoxylum' AND (species='riedelianum' OR species='riedelianum') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='izabalensis' OR junior_species='izabalensis')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pouteria' AND (species='izabalensis' OR species='izabalensis') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Pouteria' AND (species='izabalensis' OR species='izabalensis')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='izabalensis' OR junior_species='izabalensis')
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='Pouteria' AND (species='izabalensis' OR species='izabalensis') ORDER BY year,last_names
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rinorea' AND (junior_species='hummelii' OR junior_species='hummeli')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rinorea' AND (species='hummelii' OR species='hummeli') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Rinorea' AND (species='hummelii' OR species='hummeli')
SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rinorea' AND (junior_species='hummelii' OR junior_species='hummeli')
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='Rinorea' AND (species='hummelii' OR species='hummeli') ORDER BY year,last_names
SELECT * FROM register WHERE sample_no=2040
SELECT genus FROM register WHERE register_no IN (75640,12277,13068,34109,87478,79206,87666,31094,13502,29075) AND species REGEXP '^[a-z]*$'
The Ecological Register: Bladen Nature Reserve (valley floor, transect 3)
Bladen Nature Reserve (valley floor, transect 3)
Basic information
Sample name: Bladen Nature Reserve (valley floor, transect 3)

Reference: S. W. Brewer, M. Rejmânek, M. A. H. Webb, and P. V. A. Fine. 2003. Relationships of phytogeography and diversity of tropical tree species with limestone topography in southern Belize. Journal of Biogeography 30:1669-1688 [ER 2094]
Geography
Country: Belize


Coordinate: 16° 29' N, 88° 53' W
Coordinate basis: based on nearby landmark

Geography comments: the reserve "encompasses the watershed of the Bladen Branch of the Monkey River" (coordinate based on Bladen Nature Reserve)
elevation 60 to 250 m

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Protection: nature reserve

Substrate: ground surface

MAP: 2750.0

Habitat comments: "tropical wet seasonal" with "a strong dry season from February to May" and "evergreen forests"; undisturbed since Mayan times but "some mahogany... were removed from the area in more recent times"
MAP 2500 to 3000 mm

Methods
Life forms: trees

Sites: 1

Site length: 500

Site width: 2

Sampling methods: belt transect

Sample size: 106 individuals

Years: 1999

Seasons: dry

Size min: 5

Basal area: 5.132

Sampling comments: "In the dry season of 1999, one transect 2 x 500 m (0.1 ha) was placed"
basal area (total 5.132 m2 per 0.1 ha) summed by hand from figures in Appendix 1

Metadata
Sample number: 2040

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-06-08 19:25:11

Modified: 2016-06-08 09:25:11

Abundance distribution
31 species
16 singletons
total count 106
geometric series index: 93.2
Fisher's α: 14.741
geometric series k: 0.8836
Hurlbert's PIE: 0.8295
Shannon's H: 2.6107
Good's u: 0.8498
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Draw sampling curves
Register
Spondias mombin3
Stemmadenia donnellsmithii1
Astrocaryum mexicanum41
Quararibea funebris1
Protium confusum5
Celtis schippii2
Garcinia intermedia1
Terminalia amazonia3
Alchornea latifolia3
Dialium guianense3
Inga sapindoides1
Platymiscium dimorphandrum1
Pleuranthodendron lindenii1
Nectandra lundellii3
Bunchosia polystachia1
Miconia impetiolaris2
Mouriri exilis1
Guarea glabra4
Guarea grandifolia1
Ficus guajavoides2
Poulsenia armata5
Pourouma 'bicolor'1
Virola koschnyi5
Heisteria media1
Coccoloba tuerckheimii1
Guettarda macrosperma1
Psychotria simiarum7
Zanthoxylum ekmanii1
Zanthoxylum riedelianum2
Pouteria izabalensis1
Rinorea hummelii1