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=2206 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2206SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2180SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2206 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allotruxalis' AND (junior_species='gracilis' OR junior_species='gracilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Allotruxalis' AND (species='gracilis' OR species='gracilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Allotruxalis' AND (species='gracilis' OR species='gracilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allotruxalis' AND (junior_species='gracilis' OR junior_species='gracilis')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='Allotruxalis' AND (species='gracilis' OR species='gracilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metaleptea' AND (junior_species='adspersa' OR junior_species='adspersa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Metaleptea' AND (species='adspersa' OR species='adspersa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Metaleptea' AND (species='adspersa' OR species='adspersa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metaleptea' AND (junior_species='adspersa' OR junior_species='adspersa')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='Metaleptea' AND (species='adspersa' OR species='adspersa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parorphula' AND (junior_species='graminea' OR junior_species='graminea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parorphula' AND (species='graminea' OR species='graminea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parorphula' AND (species='graminea' OR species='graminea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parorphula' AND (junior_species='graminea' OR junior_species='graminea')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='Parorphula' AND (species='graminea' OR species='graminea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aleuas' AND (junior_species='lineatus' OR junior_species='lineatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aleuas' AND (species='lineatus' OR species='lineatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aleuas' AND (species='lineatus' OR species='lineatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aleuas' AND (junior_species='lineatus' OR junior_species='lineatus')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='Aleuas' AND (species='lineatus' OR species='lineatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amblytropidia' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amblytropidia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amblytropidia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amblytropidia' AND (junior_species='sp.' OR junior_species='sp.')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='Amblytropidia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orphulella' AND (junior_species='punctata' OR junior_species='punctata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orphulella' AND (species='punctata' OR species='punctata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orphulella' AND (species='punctata' OR species='punctata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orphulella' AND (junior_species='punctata' OR junior_species='punctata')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='Orphulella' AND (species='punctata' OR species='punctata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peruvia' AND (junior_species='nigromarginata' OR junior_species='nigromarginata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Peruvia' AND (species='nigromarginata' OR species='nigromarginata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Peruvia' AND (species='nigromarginata' OR species='nigromarginata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peruvia' AND (junior_species='nigromarginata' OR junior_species='nigromarginata')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='Peruvia' AND (species='nigromarginata' OR species='nigromarginata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhammatocerus' AND (junior_species='brunneri' OR junior_species='brunnerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhammatocerus' AND (species='brunneri' OR species='brunnerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhammatocerus' AND (species='brunneri' OR species='brunnerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhammatocerus' AND (junior_species='brunneri' OR junior_species='brunnerii')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='Rhammatocerus' AND (species='brunneri' OR species='brunnerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhammatocerus' AND (junior_species='pictus' OR junior_species='pictus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhammatocerus' AND (species='pictus' OR species='pictus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhammatocerus' AND (species='pictus' OR species='pictus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhammatocerus' AND (junior_species='pictus' OR junior_species='pictus')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='Rhammatocerus' AND (species='pictus' OR species='pictus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Staurorhectus' AND (junior_species='longicornis' OR junior_species='longicornis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Staurorhectus' AND (species='longicornis' OR species='longicornis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Staurorhectus' AND (species='longicornis' OR species='longicornis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Staurorhectus' AND (junior_species='longicornis' OR junior_species='longicornis')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='Staurorhectus' AND (species='longicornis' OR species='longicornis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cylindrotettix' AND (junior_species='chacoensis' OR junior_species='chacoensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cylindrotettix' AND (species='chacoensis' OR species='chacoensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cylindrotettix' AND (species='chacoensis' OR species='chacoensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cylindrotettix' AND (junior_species='chacoensis' OR junior_species='chacoensis')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='Cylindrotettix' AND (species='chacoensis' OR species='chacoensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cylindrotettix' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cylindrotettix' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cylindrotettix' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cylindrotettix' AND (junior_species='sp.' OR junior_species='sp.')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='Cylindrotettix' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichroplus' AND (junior_species='elongatus' OR junior_species='elongatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dichroplus' AND (species='elongatus' OR species='elongatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dichroplus' AND (species='elongatus' OR species='elongatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichroplus' AND (junior_species='elongatus' OR junior_species='elongatus')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='Dichroplus' AND (species='elongatus' OR species='elongatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichroplus' AND (junior_species='misionensis' OR junior_species='misionensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dichroplus' AND (species='misionensis' OR species='misionensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dichroplus' AND (species='misionensis' OR species='misionensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichroplus' AND (junior_species='misionensis' OR junior_species='misionensis')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='Dichroplus' AND (species='misionensis' OR species='misionensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ronderosia' AND (junior_species='bergi' OR junior_species='bergii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ronderosia' AND (species='bergi' OR species='bergii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ronderosia' AND (species='bergi' OR species='bergii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ronderosia' AND (junior_species='bergi' OR junior_species='bergii')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='Ronderosia' AND (species='bergi' OR species='bergii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abracris' AND (junior_species='flavolineata' OR junior_species='flavolineata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Abracris' AND (species='flavolineata' OR species='flavolineata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Abracris' AND (species='flavolineata' OR species='flavolineata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abracris' AND (junior_species='flavolineata' OR junior_species='flavolineata')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='Abracris' AND (species='flavolineata' OR species='flavolineata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chromacris' AND (junior_species='speciosa' OR junior_species='speciosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chromacris' AND (species='speciosa' OR species='speciosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chromacris' AND (species='speciosa' OR species='speciosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chromacris' AND (junior_species='speciosa' OR junior_species='speciosa')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='Chromacris' AND (species='speciosa' OR species='speciosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Staleochlora' AND (junior_species='viridicata' OR junior_species='viridicata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Staleochlora' AND (species='viridicata' OR species='viridicata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Staleochlora' AND (species='viridicata' OR species='viridicata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Staleochlora' AND (junior_species='viridicata' OR junior_species='viridicata')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='Staleochlora' AND (species='viridicata' OR species='viridicata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xyleus' AND (junior_species='discoideus' OR junior_species='discoideus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xyleus' AND (species='discoideus' OR species='discoideus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xyleus' AND (species='discoideus' OR species='discoideus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xyleus' AND (junior_species='discoideus' OR junior_species='discoideus')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='Xyleus' AND (species='discoideus' OR species='discoideus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zoniopoda' AND (junior_species='iheringi' OR junior_species='iheringii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zoniopoda' AND (species='iheringi' OR species='iheringii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zoniopoda' AND (species='iheringi' OR species='iheringii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zoniopoda' AND (junior_species='iheringi' OR junior_species='iheringii')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='Zoniopoda' AND (species='iheringi' OR species='iheringii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ommexecha' AND (junior_species='virens' OR junior_species='virens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ommexecha' AND (species='virens' OR species='virens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ommexecha' AND (species='virens' OR species='virens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ommexecha' AND (junior_species='virens' OR junior_species='virens')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='Ommexecha' AND (species='virens' OR species='virens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetrix' AND (junior_species='subulata' OR junior_species='subulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetrix' AND (species='subulata' OR species='subulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetrix' AND (species='subulata' OR species='subulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetrix' AND (junior_species='subulata' OR junior_species='subulata')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='Tetrix' AND (species='subulata' OR species='subulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tridactylus' AND (junior_species='politus' OR junior_species='politus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tridactylus' AND (species='politus' OR species='politus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tridactylus' AND (species='politus' OR species='politus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tridactylus' AND (junior_species='politus' OR junior_species='politus')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='Tridactylus' AND (species='politus' OR species='politus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2206 The Ecological Register: Floresta Nacional de Chapecó (ârea 3)
Floresta Nacional de Chapecó (ârea 3)
Basic information
Sample name: Floresta Nacional de Chapecó (ârea 3)

Reference: C. J. Lutinski, J. A. Lutinski, M. K. M. da Costa, and F. R. M. Garcia. 2011. Análise faunística de gafanhotos na Floresta Nacional de Chapecó, Santa Catarina. Pesquisa Florestal Brasileira 31(65):43-50 [ER 2180]
Geography
Country: Brazil

State: Santa Catarina


Coordinate: 27° 5' 50" S, 52° 46' 40" W
Coordinate basis: stated in text

Geography comments: "na Gleba I da Floresta Nacional de Chapecó (Flona) localizada no Município de Guatambù, Santa Catarina, na localidade da Fazenda Zandavalli"

Environment
Habitat: tropical/subtropical dry broadleaf forest

Altered habitat: plantation

Protection: national/state forest

Substrate: ground surface

Habitat comments: original vegetation was apparently "mata com araucâria (Floresta Ombrófila Mista) e Floresta Estacional Decidual" but now "uma plantaçäo de pínus (Pinus taeda Linnaeus e Pinus elliottii Engelm) com 45 anos de idade"

Methods
Life forms: orthopterans

Sampling methods: sweep nets,other nets,malaise traps,pitfall traps

Sample size: 252 individuals

Years: 2003, 2004

Sampling comments: "As amostragens foram semanais no período de dezembro de 2003 a dezembro de 2004. Nas coletas foram utilizadas armadilhas do tipo ativo, caso da rede de varredura e guarda-chuva entomológico e as armadilhas passivas 'pitfall' e 'malaise'. O esforço amostral empregado por coleta, igualmente em cada ârea, consistiu em 20 minutos de varredura para rede de varredura em aproximadamente 60 sacudidelas em um total de 10 arbustos para o guarda-chuva entomológico; em 10 armadilhas tipo 'pitfall' distribuídas a intervalos de 10 m entre si em transectos lineares perpendiculares da borda para o interior; e uma armadilha do tipo 'malaise' instalada na regiäo central de cada uma das âreas"

Metadata
Sample number: 2206

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-08-06 20:12:01

Modified: 2018-06-30 11:03:40

Abundance distribution
23 species
4 singletons
total count 252
extrapolated richness: 33.9
Fisher's α: 6.156
geometric series k: 0.8456
Hurlbert's PIE: 0.9077
Shannon's H: 2.6421
Good's u: 0.9842
Each square represents a species. Square sizes are proportional to counts.
Register