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=2170 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2170SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2164SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2170 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orphulella' AND (junior_species='spp.' OR junior_species='spp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orphulella' AND (species='spp.' OR species='spp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orphulella' AND (species='spp.' OR species='spp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orphulella' AND (junior_species='spp.' OR junior_species='spp.')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='spp.' OR species='spp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ageneotettix' AND (junior_species='deorum' OR junior_species='deorum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ageneotettix' AND (species='deorum' OR species='deorum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ageneotettix' AND (species='deorum' OR species='deorum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ageneotettix' AND (junior_species='deorum' OR junior_species='deorum')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='Ageneotettix' AND (species='deorum' OR species='deorum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='mexicanus' OR junior_species='mexicanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanoplus' AND (species='mexicanus' OR species='mexicanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanoplus' AND (species='mexicanus' OR species='mexicanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='mexicanus' OR junior_species='mexicanus')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='Melanoplus' AND (species='mexicanus' OR species='mexicanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='bivittatus' OR junior_species='bivittatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanoplus' AND (species='bivittatus' OR species='bivittatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanoplus' AND (species='bivittatus' OR species='bivittatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='bivittatus' OR junior_species='bivittatus')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='Melanoplus' AND (species='bivittatus' OR species='bivittatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mermiria' 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='Mermiria' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mermiria' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mermiria' 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='Mermiria' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='femurrubrum' OR junior_species='femurrubrum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanoplus' AND (species='femurrubrum' OR species='femurrubrum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanoplus' AND (species='femurrubrum' OR species='femurrubrum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='femurrubrum' OR junior_species='femurrubrum')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='Melanoplus' AND (species='femurrubrum' OR species='femurrubrum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='packardii' OR junior_species='packardi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanoplus' AND (species='packardii' OR species='packardi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanoplus' AND (species='packardii' OR species='packardi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='packardii' OR junior_species='packardi')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='Melanoplus' AND (species='packardii' OR species='packardi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syrbula' AND (junior_species='admirabilis' OR junior_species='admirabilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syrbula' AND (species='admirabilis' OR species='admirabilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syrbula' AND (species='admirabilis' OR species='admirabilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syrbula' AND (junior_species='admirabilis' OR junior_species='admirabilis')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='Syrbula' AND (species='admirabilis' OR species='admirabilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pardalophora' AND (junior_species='haldemani' OR junior_species='haldemanii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pardalophora' AND (species='haldemani' OR species='haldemanii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pardalophora' AND (species='haldemani' OR species='haldemanii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pardalophora' AND (junior_species='haldemani' OR junior_species='haldemanii')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='Pardalophora' AND (species='haldemani' OR species='haldemanii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hippiscus' AND (junior_species='rugosus' OR junior_species='rugosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hippiscus' AND (species='rugosus' OR species='rugosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hippiscus' AND (species='rugosus' OR species='rugosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hippiscus' AND (junior_species='rugosus' OR junior_species='rugosus')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='Hippiscus' AND (species='rugosus' OR species='rugosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='confusus' OR junior_species='confusus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanoplus' AND (species='confusus' OR species='confusus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanoplus' AND (species='confusus' OR species='confusus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='confusus' OR junior_species='confusus')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='Melanoplus' AND (species='confusus' OR species='confusus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='differentialis' OR junior_species='differentialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanoplus' AND (species='differentialis' OR species='differentialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanoplus' AND (species='differentialis' OR species='differentialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='differentialis' OR junior_species='differentialis')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='Melanoplus' AND (species='differentialis' OR species='differentialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Opeia' AND (junior_species='obscura' OR junior_species='obscura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Opeia' AND (species='obscura' OR species='obscura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Opeia' AND (species='obscura' OR species='obscura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Opeia' AND (junior_species='obscura' OR junior_species='obscura')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='Opeia' AND (species='obscura' OR species='obscura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoetaliotes' AND (junior_species='nebrascensis' OR junior_species='nebrascensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phoetaliotes' AND (species='nebrascensis' OR species='nebrascensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phoetaliotes' AND (species='nebrascensis' OR species='nebrascensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoetaliotes' AND (junior_species='nebrascensis' OR junior_species='nebrascensis')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='Phoetaliotes' AND (species='nebrascensis' OR species='nebrascensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachyrhachis' AND (junior_species='kiowa' OR junior_species='kiowa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trachyrhachis' AND (species='kiowa' OR species='kiowa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trachyrhachis' AND (species='kiowa' OR species='kiowa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachyrhachis' AND (junior_species='kiowa' OR junior_species='kiowa')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='Trachyrhachis' AND (species='kiowa' OR species='kiowa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hesperotettix' AND (junior_species='speciosus' OR junior_species='speciosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hesperotettix' AND (species='speciosus' OR species='speciosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hesperotettix' AND (species='speciosus' OR species='speciosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hesperotettix' AND (junior_species='speciosus' OR junior_species='speciosus')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='Hesperotettix' AND (species='speciosus' OR species='speciosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aulocara' AND (junior_species='elliotti' OR junior_species='elliottii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aulocara' AND (species='elliotti' OR species='elliottii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aulocara' AND (species='elliotti' OR species='elliottii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aulocara' AND (junior_species='elliotti' OR junior_species='elliottii')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='Aulocara' AND (species='elliotti' OR species='elliottii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dissosteira' AND (junior_species='carolina' OR junior_species='carolina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dissosteira' AND (species='carolina' OR species='carolina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dissosteira' AND (species='carolina' OR species='carolina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dissosteira' AND (junior_species='carolina' OR junior_species='carolina')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='Dissosteira' AND (species='carolina' OR species='carolina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boopedon' AND (junior_species='maculatum' OR junior_species='maculatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boopedon' AND (species='maculatum' OR species='maculatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boopedon' AND (species='maculatum' OR species='maculatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boopedon' AND (junior_species='maculatum' OR junior_species='maculatum')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='Boopedon' AND (species='maculatum' OR species='maculatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Encoptolophus' 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='Encoptolophus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Encoptolophus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Encoptolophus' 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='Encoptolophus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2170 The Ecological Register: Kansas Agricultural Experiment Station (orchard brome)
Kansas Agricultural Experiment Station (orchard brome)
Basic information
Sample name: Kansas Agricultural Experiment Station (orchard brome)

Reference: D. A. Wilbur and R. F. Fritz. 1940. Grasshopper populations (Orthoptera, Acrididae) of typical pastures in the Bluestem region of Kansas. Journal of the Kansas Entomological Society 13(3):86-100 [ER 2164]
Geography
Country: United States

State: Kansas


Coordinate: 39° 12' N, 96° 36' W
Coordinate basis: based on nearby landmark

Geography comments: none given (the Station was in Manhattan, basis of coordinate, and is apparently not the same as Konza Prairie Biological Station)

•
Environment
Habitat: temperate savanna

Altered habitat: pasture

Substrate: ground surface

Habitat comments: "The orchard-brome grass pasture consisted of those cultivated grasses recommended for seeding in this area"

Methods
Life forms: orthopterans

Sampling methods: no design,sweep nets

Sample size: 2614 individuals

Years: 1933 - 1939

Sampling comments: "Each year the collections were started during April... and were continued throughout the growing season... Semi-weekly collections were intended but occasionally rains interfered... collecting was done by means of a specially constructed, long-handled, square net, the mouth of which was one square foot in area. Twenty-five sweeps of this net in each plot, each sweep covering about three feet, constituted a collection"

Metadata
Sample number: 2170

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-08-03 14:43:23

Modified: 2016-08-03 04:43:23

Abundance distribution
20 species
6 singletons
total count 2614
extrapolated richness: 33.2
Fisher's α: 2.946
geometric series k: 0.6920
Hurlbert's PIE: 0.6999
Shannon's H: 1.4576
Good's u: 0.9977
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Orphulella spp.64
Ageneotettix deorum1091
Melanoplus mexicanus755
Melanoplus bivittatus530
Mermiria sp.31
Melanoplus femurrubrum37
Melanoplus packardii35
Syrbula admirabilis2
Pardalophora haldemani13
Hippiscus rugosus14
Melanoplus confusus7
Melanoplus differentialis25
Opeia obscura1
Phoetaliotes nebrascensis1
Trachyrhachis kiowa kiowa2
Hesperotettix speciosus1
Aulocara elliotti2
Dissosteira carolina1
Boopedon maculatum1
Encoptolophus sp.1