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=2815 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2815SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2081SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2815 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' AND (junior_species='uniflora' OR junior_species='uniflora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eugenia' AND (species='uniflora' OR species='uniflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eugenia' AND (species='uniflora' OR species='uniflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' AND (junior_species='uniflora' OR junior_species='uniflora')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='Eugenia' AND (species='uniflora' OR species='uniflora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrcianthes' AND (junior_species='pungens' OR junior_species='pungens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrcianthes' AND (species='pungens' OR species='pungens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrcianthes' AND (species='pungens' OR species='pungens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrcianthes' AND (junior_species='pungens' OR junior_species='pungens')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='Myrcianthes' AND (species='pungens' OR species='pungens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urera' AND (junior_species='baccifera' OR junior_species='baccifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Urera' AND (species='baccifera' OR species='baccifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Urera' AND (species='baccifera' OR species='baccifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urera' AND (junior_species='baccifera' OR junior_species='baccifera')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='Urera' AND (species='baccifera' OR species='baccifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ruprechtia' AND (junior_species='laxiflora' OR junior_species='laxiflora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ruprechtia' AND (species='laxiflora' OR species='laxiflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ruprechtia' AND (species='laxiflora' OR species='laxiflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ruprechtia' AND (junior_species='laxiflora' OR junior_species='laxiflora')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='Ruprechtia' AND (species='laxiflora' OR species='laxiflora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Duranta' AND (junior_species='serratifolia' OR junior_species='serratifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Duranta' AND (species='serratifolia' OR species='serratifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Duranta' AND (species='serratifolia' OR species='serratifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Duranta' AND (junior_species='serratifolia' OR junior_species='serratifolia')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='Duranta' AND (species='serratifolia' OR species='serratifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysophyllum' AND (junior_species='marginatum' OR junior_species='marginatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chrysophyllum' AND (species='marginatum' OR species='marginatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chrysophyllum' AND (species='marginatum' OR species='marginatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysophyllum' AND (junior_species='marginatum' OR junior_species='marginatum')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='Chrysophyllum' AND (species='marginatum' OR species='marginatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ruprechtia' AND (junior_species='apetala' OR junior_species='apetala')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ruprechtia' AND (species='apetala' OR species='apetala') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ruprechtia' AND (species='apetala' OR species='apetala')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ruprechtia' AND (junior_species='apetala' OR junior_species='apetala')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='Ruprechtia' AND (species='apetala' OR species='apetala') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Handroanthus' AND (junior_species='impetiginosus' OR junior_species='impetiginosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Handroanthus' AND (species='impetiginosus' OR species='impetiginosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Handroanthus' AND (species='impetiginosus' OR species='impetiginosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Handroanthus' AND (junior_species='impetiginosus' OR junior_species='impetiginosus')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='Handroanthus' AND (species='impetiginosus' OR species='impetiginosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Piper' AND (junior_species='tucumanum' OR junior_species='tucumanum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Piper' AND (species='tucumanum' OR species='tucumanum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Piper' AND (species='tucumanum' OR species='tucumanum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Piper' AND (junior_species='tucumanum' OR junior_species='tucumanum')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='Piper' AND (species='tucumanum' OR species='tucumanum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pisonia' AND (junior_species='zapallo' OR junior_species='zapallo')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pisonia' AND (species='zapallo' OR species='zapallo') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pisonia' AND (species='zapallo' OR species='zapallo')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pisonia' AND (junior_species='zapallo' OR junior_species='zapallo')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='Pisonia' AND (species='zapallo' OR species='zapallo') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnamomum' AND (junior_species='porphyrium' OR junior_species='porphyrium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cinnamomum' AND (species='porphyrium' OR species='porphyrium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cinnamomum' AND (species='porphyrium' OR species='porphyrium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnamomum' AND (junior_species='porphyrium' OR junior_species='porphyrium')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='Cinnamomum' AND (species='porphyrium' OR species='porphyrium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' AND (junior_species='triflora' OR junior_species='triflora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Terminalia' AND (species='triflora' OR species='triflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Terminalia' AND (species='triflora' OR species='triflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' AND (junior_species='triflora' OR junior_species='triflora')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='triflora' OR species='triflora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allophylus' AND (junior_species='edulis' OR junior_species='edulis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Allophylus' AND (species='edulis' OR species='edulis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Allophylus' AND (species='edulis' OR species='edulis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allophylus' AND (junior_species='edulis' OR junior_species='edulis')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='Allophylus' AND (species='edulis' OR species='edulis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Solanum' AND (junior_species='riparium' OR junior_species='riparium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Solanum' AND (species='riparium' OR species='riparium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Solanum' AND (species='riparium' OR species='riparium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Solanum' AND (junior_species='riparium' OR junior_species='riparium')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='Solanum' AND (species='riparium' OR species='riparium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Blepharocalyx' AND (junior_species='salicifolius' OR junior_species='salicifolius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Blepharocalyx' AND (species='salicifolius' OR species='salicifolius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Blepharocalyx' AND (species='salicifolius' OR species='salicifolius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Blepharocalyx' AND (junior_species='salicifolius' OR junior_species='salicifolius')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='Blepharocalyx' AND (species='salicifolius' OR species='salicifolius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrsine' AND (junior_species='laetevirens' OR junior_species='laetevirens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrsine' AND (species='laetevirens' OR species='laetevirens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrsine' AND (species='laetevirens' OR species='laetevirens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrsine' AND (junior_species='laetevirens' OR junior_species='laetevirens')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='Myrsine' AND (species='laetevirens' OR species='laetevirens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parapiptadenia' AND (junior_species='excelsa' OR junior_species='excelsa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parapiptadenia' AND (species='excelsa' OR species='excelsa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parapiptadenia' AND (species='excelsa' OR species='excelsa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parapiptadenia' AND (junior_species='excelsa' OR junior_species='excelsa')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='Parapiptadenia' AND (species='excelsa' OR species='excelsa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urera' AND (junior_species='caracasana' OR junior_species='caracasana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Urera' AND (species='caracasana' OR species='caracasana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Urera' AND (species='caracasana' OR species='caracasana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urera' AND (junior_species='caracasana' OR junior_species='caracasana')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='Urera' AND (species='caracasana' OR species='caracasana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cupania' AND (junior_species='vernalis' OR junior_species='vernalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cupania' AND (species='vernalis' OR species='vernalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cupania' AND (species='vernalis' OR species='vernalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cupania' AND (junior_species='vernalis' OR junior_species='vernalis')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='vernalis' OR species='vernalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vassobia' AND (junior_species='breviflora' OR junior_species='breviflora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vassobia' AND (species='breviflora' OR species='breviflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vassobia' AND (species='breviflora' OR species='breviflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vassobia' AND (junior_species='breviflora' OR junior_species='breviflora')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='Vassobia' AND (species='breviflora' OR species='breviflora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boehmeria' AND (junior_species='caudata' OR junior_species='caudata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boehmeria' AND (species='caudata' OR species='caudata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boehmeria' AND (species='caudata' OR species='caudata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boehmeria' AND (junior_species='caudata' OR junior_species='caudata')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='Boehmeria' AND (species='caudata' OR species='caudata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cedrela' AND (junior_species='lilloi' OR junior_species='lilloii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cedrela' AND (species='lilloi' OR species='lilloii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cedrela' AND (species='lilloi' OR species='lilloii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cedrela' AND (junior_species='lilloi' OR junior_species='lilloii')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='Cedrela' AND (species='lilloi' OR species='lilloii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Juglans' AND (junior_species='australis' OR junior_species='australis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Juglans' AND (species='australis' OR species='australis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Juglans' AND (species='australis' OR species='australis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Juglans' AND (junior_species='australis' OR junior_species='australis')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='Juglans' AND (species='australis' OR species='australis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tipuana' AND (junior_species='tipu' OR junior_species='tipu')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tipuana' AND (species='tipu' OR species='tipu') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tipuana' AND (species='tipu' OR species='tipu')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tipuana' AND (junior_species='tipu' OR junior_species='tipu')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='Tipuana' AND (species='tipu' OR species='tipu') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Citrus' AND (junior_species='aurantium' OR junior_species='aurantium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Citrus' AND (species='aurantium' OR species='aurantium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Citrus' AND (species='aurantium' OR species='aurantium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Citrus' AND (junior_species='aurantium' OR junior_species='aurantium')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='Citrus' AND (species='aurantium' OR species='aurantium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fagara' AND (junior_species='naranjillo' OR junior_species='naranjillo')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fagara' AND (species='naranjillo' OR species='naranjillo') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fagara' AND (species='naranjillo' OR species='naranjillo')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fagara' AND (junior_species='naranjillo' OR junior_species='naranjillo')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='Fagara' AND (species='naranjillo' OR species='naranjillo') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pentapanax' AND (junior_species='angelicifolius' OR junior_species='angelicifolius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pentapanax' AND (species='angelicifolius' OR species='angelicifolius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pentapanax' AND (species='angelicifolius' OR species='angelicifolius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pentapanax' AND (junior_species='angelicifolius' OR junior_species='angelicifolius')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='Pentapanax' AND (species='angelicifolius' OR species='angelicifolius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enterolobium' AND (junior_species='contortisiliquum' OR junior_species='contortisiliquum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Enterolobium' AND (species='contortisiliquum' OR species='contortisiliquum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Enterolobium' AND (species='contortisiliquum' OR species='contortisiliquum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enterolobium' AND (junior_species='contortisiliquum' OR junior_species='contortisiliquum')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='Enterolobium' AND (species='contortisiliquum' OR species='contortisiliquum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xylosma' AND (junior_species='pubescens' OR junior_species='pubescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xylosma' AND (species='pubescens' OR species='pubescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xylosma' AND (species='pubescens' OR species='pubescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xylosma' AND (junior_species='pubescens' OR junior_species='pubescens')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='Xylosma' AND (species='pubescens' OR species='pubescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anadenanthera' AND (junior_species='colubrina' OR junior_species='colubrina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anadenanthera' AND (species='colubrina' OR species='colubrina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anadenanthera' AND (species='colubrina' OR species='colubrina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anadenanthera' AND (junior_species='colubrina' OR junior_species='colubrina')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='Anadenanthera' AND (species='colubrina' OR species='colubrina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carica' AND (junior_species='quercifolia' OR junior_species='quercifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carica' AND (species='quercifolia' OR species='quercifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carica' AND (species='quercifolia' OR species='quercifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carica' AND (junior_species='quercifolia' OR junior_species='quercifolia')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='Carica' AND (species='quercifolia' OR species='quercifolia') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2815 The Ecological Register: Parque Biológico Sierra de San Javier (old growth forest, 1991)
Parque Biológico Sierra de San Javier (old growth forest, 1991)
Basic information
Sample name: Parque Biológico Sierra de San Javier (old growth forest, 1991)

Reference: T. A. Easdale, J. R. Healey, H. R. Grau, and A. Malizia. 2007. Tree life histories in a montane subtropical forest: species differ independently by shade-tolerance, turnover rate and substrate preference. Journal of Ecology 95:1234-1249 [ER 2081]
Geography
Country: Argentina

State: Tucumân


Coordinate: 26° 45' 45" S, 65° 20' 0" W
Coordinate basis: estimated from map

Geography comments: coordinate estimated from map in Appendix S1
plots are respectively at 910, 886, 1001, 1002, 996, 990, 985, and 973 m

•
Environment
Habitat: temperate broadleaf/mixed forest

Substrate: ground surface

MAT: 18.0

MAP: 1450.0

Habitat comments: "semi-deciduous forests"
MAP 1300 to 1600 mm (figure does not agree with that for sample 213)

Methods
Life forms: trees

Sites: 8

Site area: 8

Sampling methods: quadrat

Sample size: 2063 individuals

Years: 1991

Size min: 10

Basal area: 30.4

Sampling comments: eight 1 ha plots
not the same as sample 213, which is a single 4 ha plot

Metadata
Sample number: 2815

Contributor: John Alroy

Enterer: John Alroy

Created: 2017-11-23 12:32:13

Modified: 2017-11-23 01:43:05

Abundance distribution
31 species
1 singleton
total count 2063
extrapolated richness: 35.5
Fisher's α: 5.175
geometric series k: 0.8337
Hurlbert's PIE: 0.9206
Shannon's H: 2.7446
Good's u: 0.9995
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Eugenia uniflora202
Myrcianthes pungens234
Urera baccifera69
Ruprechtia laxiflora79
Duranta serratifolia19
Chrysophyllum marginatum24
Ruprechtia apetala17
Handroanthus impetiginosus12
"Tabebuia impetiginosa"
Piper tucumanum228
Pisonia zapallo185
Cinnamomum porphyrium212
Terminalia triflora220
Allophylus edulis113
Solanum riparium70
Blepharocalyx salicifolius134
Myrsine laetevirens51
Parapiptadenia excelsa105
Urera caracasana17
Cupania vernalis8
Vassobia breviflora3
Boehmeria caudata4
Cedrela lilloi9
Juglans australis10
Tipuana tipu13
Citrus aurantium5
Fagara naranjillo4
Pentapanax angelicifolius3
Enterolobium contortisiliquum1
Xylosma pubescens4
Anadenanthera colubrina4
Carica quercifolia4