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=2126 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2126SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2138SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2126 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Covasacris' AND (junior_species='pallidinota' OR junior_species='pallidinota')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Covasacris' AND (species='pallidinota' OR species='pallidinota') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Covasacris' AND (species='pallidinota' OR species='pallidinota')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Covasacris' AND (junior_species='pallidinota' OR junior_species='pallidinota')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='Covasacris' AND (species='pallidinota' OR species='pallidinota') 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='Cocytotettix' AND (junior_species='argentina' OR junior_species='argentina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cocytotettix' AND (species='argentina' OR species='argentina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cocytotettix' AND (species='argentina' OR species='argentina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cocytotettix' AND (junior_species='argentina' OR junior_species='argentina')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='Cocytotettix' AND (species='argentina' OR species='argentina') 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='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='Tucayaca' 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='Tucayaca' AND (species='gracilis' OR species='gracilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tucayaca' AND (species='gracilis' OR species='gracilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tucayaca' 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='Tucayaca' AND (species='gracilis' OR species='gracilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Baeacris' AND (junior_species='punctulatus' OR junior_species='punctulatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Baeacris' AND (species='punctulatus' OR species='punctulatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Baeacris' AND (species='punctulatus' OR species='punctulatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Baeacris' AND (junior_species='punctulatus' OR junior_species='punctulatus')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='Baeacris' AND (species='punctulatus' OR species='punctulatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Baeacris' AND (junior_species='pseudopunctulatus' OR junior_species='pseudopunctulatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Baeacris' AND (species='pseudopunctulatus' OR species='pseudopunctulatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Baeacris' AND (species='pseudopunctulatus' OR species='pseudopunctulatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Baeacris' AND (junior_species='pseudopunctulatus' OR junior_species='pseudopunctulatus')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='Baeacris' AND (species='pseudopunctulatus' OR species='pseudopunctulatus') 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='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='maculipennis' OR junior_species='maculipennis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dichroplus' AND (species='maculipennis' OR species='maculipennis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dichroplus' AND (species='maculipennis' OR species='maculipennis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichroplus' AND (junior_species='maculipennis' OR junior_species='maculipennis')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='maculipennis' OR species='maculipennis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichroplus' AND (junior_species='pratensis' OR junior_species='pratensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dichroplus' AND (species='pratensis' OR species='pratensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dichroplus' AND (species='pratensis' OR species='pratensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichroplus' AND (junior_species='pratensis' OR junior_species='pratensis')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='pratensis' OR species='pratensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leiotettix' AND (junior_species='pulcher' OR junior_species='pulcher')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leiotettix' AND (species='pulcher' OR species='pulcher') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leiotettix' AND (species='pulcher' OR species='pulcher')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leiotettix' AND (junior_species='pulcher' OR junior_species='pulcher')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='Leiotettix' AND (species='pulcher' OR species='pulcher') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scotussa' AND (junior_species='lemniscata' OR junior_species='lemniscata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scotussa' AND (species='lemniscata' OR species='lemniscata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scotussa' AND (species='lemniscata' OR species='lemniscata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scotussa' AND (junior_species='lemniscata' OR junior_species='lemniscata')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='lemniscata' OR species='lemniscata') 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='Scyllinula' AND (junior_species='variabilis' OR junior_species='variabilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scyllinula' AND (species='variabilis' OR species='variabilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scyllinula' AND (species='variabilis' OR species='variabilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scyllinula' AND (junior_species='variabilis' OR junior_species='variabilis')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='Scyllinula' AND (species='variabilis' OR species='variabilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sinipta' AND (junior_species='dalmani' OR junior_species='dalmanii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sinipta' AND (species='dalmani' OR species='dalmanii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sinipta' AND (species='dalmani' OR species='dalmanii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sinipta' AND (junior_species='dalmani' OR junior_species='dalmanii')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='Sinipta' AND (species='dalmani' OR species='dalmanii') 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='Amblytropidia' 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='Amblytropidia' AND (species='australis' OR species='australis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amblytropidia' AND (species='australis' OR species='australis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amblytropidia' 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='Amblytropidia' AND (species='australis' OR species='australis') 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='Diponthus' AND (junior_species='argentinus' OR junior_species='argentinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diponthus' AND (species='argentinus' OR species='argentinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diponthus' AND (species='argentinus' OR species='argentinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diponthus' AND (junior_species='argentinus' OR junior_species='argentinus')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='Diponthus' AND (species='argentinus' OR species='argentinus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2126 The Ecological Register: Laprida
Laprida
Basic information
Sample name: Laprida

Reference: Y. Mariottini, M. L. De Wysiecki, and C. E. Lange. 2013. Diversidad y distribución de acridios (Orthoptera: Acridoidea) en pastizales del sur de la región pampeana, Argentina. Revista de Biología Tropical 61(1):111-124 [ER 2138]
Geography
Country: Argentina

State: Buenos Aires


Coordinate: 36° 2' S, 59° 6' W
Coordinate basis: stated in text

Geography comments: "en el partido de Laprida ubicado en el Sur de la región pampeana (sub-región de la Pampa Deprimida)"

Environment
Habitat: temperate savanna

Substrate: ground surface

MAT: 14.0

WMT: 22.0

CMT: 6.0

MAP: 850.0

Habitat comments: sites were within "pastizales nativos... pastizales halófilos... pasturas implantadas... y pastizales alterados"
MAP 800 to 900 mm

Methods
Life forms: orthopterans

Sites: 12

Sampling methods: no design,sweep nets

Sample size: 1625 individuals

Years: 2005 - 2010

Days: 321

Sampling comments: "Para cada categoría se seleccionaron tres sitios dando un total de 12 sitios... La composición específica se determinó mediante 200 golpes o barridos con redes entomológicas de 40cm de diâmetro y 75cm de profundidad, a lo largo de cuatro transectas de aproximada- mente 3m de ancho y 50m de longitud cada una, en cada uno de los 12 sitios"

Metadata
Sample number: 2126

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-07-23 20:22:19

Modified: 2016-07-23 10:22:19

Abundance distribution
22 species
3 singletons
total count 1625
extrapolated richness: 28.7
Fisher's α: 3.598
geometric series k: 0.7715
Hurlbert's PIE: 0.9045
Shannon's H: 2.5014
Good's u: 0.9982
Each square represents a species. Square sizes are proportional to counts.
Register