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=2182 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2182SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2170SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2182 ORDER BY register_no ASCSELECT 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='Aleuas' 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='Aleuas' AND (species='gracilis' OR species='gracilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aleuas' AND (species='gracilis' OR species='gracilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aleuas' 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='Aleuas' AND (species='gracilis' OR species='gracilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aleuas' AND (junior_species='vitticollis' OR junior_species='vitticollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aleuas' AND (species='vitticollis' OR species='vitticollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aleuas' AND (species='vitticollis' OR species='vitticollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aleuas' AND (junior_species='vitticollis' OR junior_species='vitticollis')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='vitticollis' OR species='vitticollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allotruxalis' AND (junior_species='strigata' OR junior_species='strigata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Allotruxalis' AND (species='strigata' OR species='strigata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Allotruxalis' AND (species='strigata' OR species='strigata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allotruxalis' AND (junior_species='strigata' OR junior_species='strigata')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='strigata' OR species='strigata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amblytropidia' AND (junior_species='robusta' OR junior_species='robusta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amblytropidia' AND (species='robusta' OR species='robusta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amblytropidia' AND (species='robusta' OR species='robusta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amblytropidia' AND (junior_species='robusta' OR junior_species='robusta')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='robusta' OR species='robusta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amblytropidia' AND (junior_species='sola' OR junior_species='sola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amblytropidia' AND (species='sola' OR species='sola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amblytropidia' AND (species='sola' OR species='sola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amblytropidia' AND (junior_species='sola' OR junior_species='sola')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='sola' OR species='sola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Borellia' AND (junior_species='bruneri' OR junior_species='brunerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Borellia' AND (species='bruneri' OR species='brunerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Borellia' AND (species='bruneri' OR species='brunerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Borellia' AND (junior_species='bruneri' OR junior_species='brunerii')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='Borellia' AND (species='bruneri' OR species='brunerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Borellia' AND (junior_species='pallida' OR junior_species='pallida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Borellia' AND (species='pallida' OR species='pallida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Borellia' AND (species='pallida' OR species='pallida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Borellia' AND (junior_species='pallida' OR junior_species='pallida')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='Borellia' AND (species='pallida' OR species='pallida') 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='Dichroplus' AND (junior_species='conspersus' OR junior_species='conspersus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dichroplus' AND (species='conspersus' OR species='conspersus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dichroplus' AND (species='conspersus' OR species='conspersus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichroplus' AND (junior_species='conspersus' OR junior_species='conspersus')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='conspersus' OR species='conspersus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichroplus' AND (junior_species='silveiraguidoi' OR junior_species='silveiraguidoii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dichroplus' AND (species='silveiraguidoi' OR species='silveiraguidoii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dichroplus' AND (species='silveiraguidoi' OR species='silveiraguidoii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichroplus' AND (junior_species='silveiraguidoi' OR junior_species='silveiraguidoii')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='silveiraguidoi' OR species='silveiraguidoii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fenestra' AND (junior_species='bohlsii' OR junior_species='bohlsi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fenestra' AND (species='bohlsii' OR species='bohlsi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fenestra' AND (species='bohlsii' OR species='bohlsi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fenestra' AND (junior_species='bohlsii' OR junior_species='bohlsi')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='Fenestra' AND (species='bohlsii' OR species='bohlsi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notopomala' AND (junior_species='glaucipes' OR junior_species='glaucipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Notopomala' AND (species='glaucipes' OR species='glaucipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Notopomala' AND (species='glaucipes' OR species='glaucipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notopomala' AND (junior_species='glaucipes' OR junior_species='glaucipes')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='Notopomala' AND (species='glaucipes' OR species='glaucipes') 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='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='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='Scotussa' AND (junior_species='cliens' OR junior_species='cliens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scotussa' AND (species='cliens' OR species='cliens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scotussa' AND (species='cliens' OR species='cliens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scotussa' AND (junior_species='cliens' OR junior_species='cliens')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='Scotussa' AND (species='cliens' OR species='cliens') 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='Staleochlora' AND (junior_species='arcuata' OR junior_species='arcuata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Staleochlora' AND (species='arcuata' OR species='arcuata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Staleochlora' AND (species='arcuata' OR species='arcuata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Staleochlora' AND (junior_species='arcuata' OR junior_species='arcuata')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='arcuata' OR species='arcuata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xyleus' AND (junior_species='laevipes' OR junior_species='laevipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xyleus' AND (species='laevipes' OR species='laevipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xyleus' AND (species='laevipes' OR species='laevipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xyleus' AND (junior_species='laevipes' OR junior_species='laevipes')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='laevipes' OR species='laevipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zoniopoda' AND (junior_species='tarsata' OR junior_species='tarsata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zoniopoda' AND (species='tarsata' OR species='tarsata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zoniopoda' AND (species='tarsata' OR species='tarsata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zoniopoda' AND (junior_species='tarsata' OR junior_species='tarsata')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='tarsata' OR species='tarsata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oriencospia' AND (junior_species='angustirostris' OR junior_species='angustirostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oriencospia' AND (species='angustirostris' OR species='angustirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oriencospia' AND (species='angustirostris' OR species='angustirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oriencospia' AND (junior_species='angustirostris' OR junior_species='angustirostris')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='Oriencospia' AND (species='angustirostris' OR species='angustirostris') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2182 The Ecological Register: Säo Rafael (Área B)
Säo Rafael (Área B)
Basic information
Sample name: Säo Rafael (Área B)

Reference: N. L. de Carvalho, E. C. Costa, D. B. Souza, and J. Garlet. 2012. Anlisis faunstico de acridomorfos (Orthoptera: Acridoidea y Eumastacoidea) en So Sep, RS, Brasil. Revista Colombiana de Entomologa 38(2):299-305 [ER 2170]
Geography
Country: Brazil

State: Rio Grande do Sul


Coordinate: 30° 9' 38" S, 53° 33' 55" W
Coordinate basis: stated in text

Geography comments: "municipio de Säo Sepé"

•
Environment
Habitat: tropical/subtropical savanna

Substrate: ground surface

MAT: 17.0

MAP: 1500.0

Habitat comments: "El ârea B posee 92 ha de campo nativo, nunca ha estado sujeta a actividades de cultivo... El clima de la región, conforme la clasificación de Köppen es Cfa, que corresponde a Subtropical Templado Hùmedo"

Methods
Life forms: orthopterans

Sampling methods: no design,other nets

Sample size: 463 individuals

Years: 2009

Days: 20

Sampling comments: "Fueron realizados 40 muestreos entre enero y mayo de 2009, en las âreas descriptas (20 muestras en cada ârea). Para las colectas fue utilizada una red de recolección propuesta por Costa y Carvalho (2009), que consiste en un aro de hierro de 0,005 m (medida del grosor del aro) con 1,5 m de longitud por 1,3 m de altura... El muestreo fue realizado al azar, al igual que el recorrido. En cada distancia, fueron retiradas aleatoriamente por sorteo ocho muestras"

Metadata
Sample number: 2182

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-08-04 17:35:18

Modified: 2016-08-04 07:35:18

Abundance distribution
22 species
0 singletons
total count 463
extrapolated richness: 24.3
Fisher's α: 4.805
geometric series k: 0.8509
Hurlbert's PIE: 0.9136
Shannon's H: 2.7342
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Aleuas lineatus10
Aleuas gracilis6
Aleuas vitticollis26
Allotruxalis strigata11
Amblytropidia robusta9
Amblytropidia sola27
Borellia bruneri6
Borellia pallida3
Cylindrotettix chacoensis4
Dichroplus conspersus42
Dichroplus silveiraguidoi89
Fenestra bohlsii19
Notopomala glaucipes34
Orphulella punctata13
Parorphula graminea9
Rhammatocerus pictus32
Scotussa cliens55
Staurorhectus longicornis longicornis26
Staleochlora arcuata iguazuensis10
Xyleus laevipes6
Zoniopoda tarsata16
Oriencospia angustirostris10