Coordinate: 27° 9' S, 52° 19' W
clearly a small fragment based on the figured satellite photo
climate data are for Chapecó and are from Velasco-Molina (2016, Geoderma)
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=1573 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1573SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1065SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1573 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Placidula' AND (junior_species='euryanassa' OR junior_species='euryanassa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Placidula' AND (species='euryanassa' OR species='euryanassa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Placidula' AND (species='euryanassa' OR species='euryanassa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Placidula' AND (junior_species='euryanassa' OR junior_species='euryanassa')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='Placidula' AND (species='euryanassa' OR species='euryanassa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mechanitis' AND (junior_species='lysimnia' OR junior_species='lysimnia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mechanitis' AND (species='lysimnia' OR species='lysimnia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mechanitis' AND (species='lysimnia' OR species='lysimnia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mechanitis' AND (junior_species='lysimnia' OR junior_species='lysimnia')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='Mechanitis' AND (species='lysimnia' OR species='lysimnia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Astraptes' AND (junior_species='naxos' OR junior_species='naxos')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Astraptes' AND (species='naxos' OR species='naxos') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Astraptes' AND (species='naxos' OR species='naxos')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Astraptes' AND (junior_species='naxos' OR junior_species='naxos')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='Astraptes' AND (species='naxos' OR species='naxos') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Actinote' AND (junior_species='melanisans' OR junior_species='melanisans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Actinote' AND (species='melanisans' OR species='melanisans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Actinote' AND (species='melanisans' OR species='melanisans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Actinote' AND (junior_species='melanisans' OR junior_species='melanisans')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='Actinote' AND (species='melanisans' OR species='melanisans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anartia' AND (junior_species='amathea' OR junior_species='amathea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anartia' AND (species='amathea' OR species='amathea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anartia' AND (species='amathea' OR species='amathea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anartia' AND (junior_species='amathea' OR junior_species='amathea')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='Anartia' AND (species='amathea' OR species='amathea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='besckei' OR junior_species='besckeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliconius' AND (species='besckei' OR species='besckeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliconius' AND (species='besckei' OR species='besckeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='besckei' OR junior_species='besckeii')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='Heliconius' AND (species='besckei' OR species='besckeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Actinote' AND (junior_species='thalia' OR junior_species='thalia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Actinote' AND (species='thalia' OR species='thalia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Actinote' AND (species='thalia' OR species='thalia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Actinote' AND (junior_species='thalia' OR junior_species='thalia')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='Actinote' AND (species='thalia' OR species='thalia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cybdelis' AND (junior_species='phaesyla' OR junior_species='phaesyla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cybdelis' AND (species='phaesyla' OR species='phaesyla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cybdelis' AND (species='phaesyla' OR species='phaesyla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cybdelis' AND (junior_species='phaesyla' OR junior_species='phaesyla')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='Cybdelis' AND (species='phaesyla' OR species='phaesyla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Telenassa' AND (junior_species='teletusa' OR junior_species='teletusa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Telenassa' AND (species='teletusa' OR species='teletusa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Telenassa' AND (species='teletusa' OR species='teletusa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Telenassa' AND (junior_species='teletusa' OR junior_species='teletusa')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='Telenassa' AND (species='teletusa' OR species='teletusa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tegosa' AND (junior_species='claudina' OR junior_species='claudina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tegosa' AND (species='claudina' OR species='claudina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tegosa' AND (species='claudina' OR species='claudina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tegosa' AND (junior_species='claudina' OR junior_species='claudina')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='Tegosa' AND (species='claudina' OR species='claudina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epityches' AND (junior_species='eupompe' OR junior_species='eupompe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Epityches' AND (species='eupompe' OR species='eupompe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Epityches' AND (species='eupompe' OR species='eupompe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epityches' AND (junior_species='eupompe' OR junior_species='eupompe')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='Epityches' AND (species='eupompe' OR species='eupompe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Episcada' AND (junior_species='philoclea' OR junior_species='philoclea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Episcada' AND (species='philoclea' OR species='philoclea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Episcada' AND (species='philoclea' OR species='philoclea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Episcada' AND (junior_species='philoclea' OR junior_species='philoclea')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='Episcada' AND (species='philoclea' OR species='philoclea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dynomine' AND (junior_species='myrrhina' OR junior_species='myrrhina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dynomine' AND (species='myrrhina' OR species='myrrhina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dynomine' AND (species='myrrhina' OR species='myrrhina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dynomine' AND (junior_species='myrrhina' OR junior_species='myrrhina')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='Dynomine' AND (species='myrrhina' OR species='myrrhina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='herato' OR junior_species='herato')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliconius' AND (species='herato' OR species='herato') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliconius' AND (species='herato' OR species='herato')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='herato' OR junior_species='herato')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='Heliconius' AND (species='herato' OR species='herato') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Biblis' AND (junior_species='hyperia' OR junior_species='hyperia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Biblis' AND (species='hyperia' OR species='hyperia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Biblis' AND (species='hyperia' OR species='hyperia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Biblis' AND (junior_species='hyperia' OR junior_species='hyperia')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='Biblis' AND (species='hyperia' OR species='hyperia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Doxocopa' AND (junior_species='zunilda' OR junior_species='zunilda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Doxocopa' AND (species='zunilda' OR species='zunilda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Doxocopa' AND (species='zunilda' OR species='zunilda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Doxocopa' AND (junior_species='zunilda' OR junior_species='zunilda')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='Doxocopa' AND (species='zunilda' OR species='zunilda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurybia' AND (junior_species='pergaea' OR junior_species='pergaea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurybia' AND (species='pergaea' OR species='pergaea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurybia' AND (species='pergaea' OR species='pergaea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurybia' AND (junior_species='pergaea' OR junior_species='pergaea')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='Eurybia' AND (species='pergaea' OR species='pergaea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dismorphia' AND (junior_species='astyocha' OR junior_species='astyocha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dismorphia' AND (species='astyocha' OR species='astyocha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dismorphia' AND (species='astyocha' OR species='astyocha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dismorphia' AND (junior_species='astyocha' OR junior_species='astyocha')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='Dismorphia' AND (species='astyocha' OR species='astyocha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heraclides' AND (junior_species='hectoride' OR junior_species='hectoride')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heraclides' AND (species='hectoride' OR species='hectoride') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heraclides' AND (species='hectoride' OR species='hectoride')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heraclides' AND (junior_species='hectoride' OR junior_species='hectoride')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='Heraclides' AND (species='hectoride' OR species='hectoride') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanessa' AND (junior_species='braziliensis' OR junior_species='braziliensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vanessa' AND (species='braziliensis' OR species='braziliensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vanessa' AND (species='braziliensis' OR species='braziliensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanessa' AND (junior_species='braziliensis' OR junior_species='braziliensis')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='Vanessa' AND (species='braziliensis' OR species='braziliensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoebis' AND (junior_species='neocypris' OR junior_species='neocypris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phoebis' AND (species='neocypris' OR species='neocypris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phoebis' AND (species='neocypris' OR species='neocypris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoebis' AND (junior_species='neocypris' OR junior_species='neocypris')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='Phoebis' AND (species='neocypris' OR species='neocypris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipotryris' AND (junior_species='euclea' OR junior_species='euclea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hipotryris' AND (species='euclea' OR species='euclea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hipotryris' AND (species='euclea' OR species='euclea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipotryris' AND (junior_species='euclea' OR junior_species='euclea')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='Hipotryris' AND (species='euclea' OR species='euclea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='syma' OR junior_species='syma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelpha' AND (species='syma' OR species='syma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelpha' AND (species='syma' OR species='syma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='syma' OR junior_species='syma')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='Adelpha' AND (species='syma' OR species='syma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diaethria' AND (junior_species='candrena' OR junior_species='candrena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diaethria' AND (species='candrena' OR species='candrena') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diaethria' AND (species='candrena' OR species='candrena')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diaethria' AND (junior_species='candrena' OR junior_species='candrena')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='Diaethria' AND (species='candrena' OR species='candrena') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1573