Coordinate: 41° 50' S, 73° 40' W
altitude is for "around Senda Darwin Biological Station" and is from Farias and Jaksic (2011, J. Anim. Ecol.)
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=2738 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2738SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2464SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2738 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podocarpus' AND (junior_species='nubigena' OR junior_species='nubigena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Podocarpus' AND (species='nubigena' OR species='nubigena') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Podocarpus' AND (species='nubigena' OR species='nubigena')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podocarpus' AND (junior_species='nubigena' OR junior_species='nubigena')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='Podocarpus' AND (species='nubigena' OR species='nubigena') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nothofagus' 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='Nothofagus' AND (species='nitida' OR species='nitida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nothofagus' AND (species='nitida' OR species='nitida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nothofagus' 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='Nothofagus' AND (species='nitida' OR species='nitida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drimys' AND (junior_species='winteri' OR junior_species='winterii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Drimys' AND (species='winteri' OR species='winterii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Drimys' AND (species='winteri' OR species='winterii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drimys' AND (junior_species='winteri' OR junior_species='winterii')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='Drimys' AND (species='winteri' OR species='winterii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Weinmannia' AND (junior_species='trichosperma' OR junior_species='trichosperma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Weinmannia' AND (species='trichosperma' OR species='trichosperma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Weinmannia' AND (species='trichosperma' OR species='trichosperma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Weinmannia' AND (junior_species='trichosperma' OR junior_species='trichosperma')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='Weinmannia' AND (species='trichosperma' OR species='trichosperma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saxegothaea' AND (junior_species='conspicua' OR junior_species='conspicua')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Saxegothaea' AND (species='conspicua' OR species='conspicua') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Saxegothaea' AND (species='conspicua' OR species='conspicua')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saxegothaea' AND (junior_species='conspicua' OR junior_species='conspicua')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='Saxegothaea' AND (species='conspicua' OR species='conspicua') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Laureliopsis' AND (junior_species='philippiana' OR junior_species='philippiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Laureliopsis' AND (species='philippiana' OR species='philippiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Laureliopsis' AND (species='philippiana' OR species='philippiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Laureliopsis' AND (junior_species='philippiana' OR junior_species='philippiana')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='Laureliopsis' AND (species='philippiana' OR species='philippiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tepualia' AND (junior_species='stipularis' OR junior_species='stipularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tepualia' AND (species='stipularis' OR species='stipularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tepualia' AND (species='stipularis' OR species='stipularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tepualia' AND (junior_species='stipularis' OR junior_species='stipularis')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='Tepualia' AND (species='stipularis' OR species='stipularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crinodendron' AND (junior_species='hookerianum' OR junior_species='hookerianum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crinodendron' AND (species='hookerianum' OR species='hookerianum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crinodendron' AND (species='hookerianum' OR species='hookerianum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crinodendron' AND (junior_species='hookerianum' OR junior_species='hookerianum')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='Crinodendron' AND (species='hookerianum' OR species='hookerianum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caldcluvia' 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='Caldcluvia' AND (species='paniculata' OR species='paniculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caldcluvia' AND (species='paniculata' OR species='paniculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caldcluvia' 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='Caldcluvia' AND (species='paniculata' OR species='paniculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amomyrtus' AND (junior_species='luma' OR junior_species='luma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amomyrtus' AND (species='luma' OR species='luma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amomyrtus' AND (species='luma' OR species='luma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amomyrtus' AND (junior_species='luma' OR junior_species='luma')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='Amomyrtus' AND (species='luma' OR species='luma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gevuina' AND (junior_species='avellana' OR junior_species='avellana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gevuina' AND (species='avellana' OR species='avellana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gevuina' AND (species='avellana' OR species='avellana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gevuina' AND (junior_species='avellana' OR junior_species='avellana')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='Gevuina' AND (species='avellana' OR species='avellana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrceugenia' AND (junior_species='parviflora' OR junior_species='parviflora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrceugenia' AND (species='parviflora' OR species='parviflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrceugenia' AND (species='parviflora' OR species='parviflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrceugenia' AND (junior_species='parviflora' OR junior_species='parviflora')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='Myrceugenia' AND (species='parviflora' OR species='parviflora') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2738