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=2139 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2139SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2147SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2139 ORDER BY register_no ASCSELECT 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='Amphitorus' AND (junior_species='coloradus' OR junior_species='coloradus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amphitorus' AND (species='coloradus' OR species='coloradus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amphitorus' AND (species='coloradus' OR species='coloradus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphitorus' AND (junior_species='coloradus' OR junior_species='coloradus')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='Amphitorus' AND (species='coloradus' OR species='coloradus') 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='Aulocara' AND (junior_species='femoratum' OR junior_species='femoratum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aulocara' AND (species='femoratum' OR species='femoratum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aulocara' AND (species='femoratum' OR species='femoratum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aulocara' AND (junior_species='femoratum' OR junior_species='femoratum')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='femoratum' OR species='femoratum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordillacris' AND (junior_species='crenulata' OR junior_species='crenulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cordillacris' AND (species='crenulata' OR species='crenulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cordillacris' AND (species='crenulata' OR species='crenulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordillacris' AND (junior_species='crenulata' OR junior_species='crenulata')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='Cordillacris' AND (species='crenulata' OR species='crenulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eritettix' AND (junior_species='simplex' OR junior_species='simplex')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eritettix' AND (species='simplex' OR species='simplex') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eritettix' AND (species='simplex' OR species='simplex')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eritettix' AND (junior_species='simplex' OR junior_species='simplex')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='Eritettix' AND (species='simplex' OR species='simplex') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliaula' AND (junior_species='rufa' OR junior_species='rufa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliaula' AND (species='rufa' OR species='rufa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliaula' AND (species='rufa' OR species='rufa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliaula' AND (junior_species='rufa' OR junior_species='rufa')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='Heliaula' AND (species='rufa' OR species='rufa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Opeia' AND (junior_species='obscurua' OR junior_species='obscurua')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Opeia' AND (species='obscurua' OR species='obscurua') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Opeia' AND (species='obscurua' OR species='obscurua')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Opeia' AND (junior_species='obscurua' OR junior_species='obscurua')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='obscurua' OR species='obscurua') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paropomala' 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='Paropomala' AND (species='pallida' OR species='pallida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paropomala' AND (species='pallida' OR species='pallida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paropomala' 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='Paropomala' AND (species='pallida' OR species='pallida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phlibostroma' AND (junior_species='quadrimaculatum' OR junior_species='quadrimaculatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phlibostroma' AND (species='quadrimaculatum' OR species='quadrimaculatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phlibostroma' AND (species='quadrimaculatum' OR species='quadrimaculatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phlibostroma' AND (junior_species='quadrimaculatum' OR junior_species='quadrimaculatum')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='Phlibostroma' AND (species='quadrimaculatum' OR species='quadrimaculatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psoloessa' AND (junior_species='delicatula' OR junior_species='delicatula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psoloessa' AND (species='delicatula' OR species='delicatula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psoloessa' AND (species='delicatula' OR species='delicatula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psoloessa' AND (junior_species='delicatula' OR junior_species='delicatula')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='Psoloessa' AND (species='delicatula' OR species='delicatula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psoloessa' AND (junior_species='texana' OR junior_species='texana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psoloessa' AND (species='texana' OR species='texana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psoloessa' AND (species='texana' OR species='texana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psoloessa' AND (junior_species='texana' OR junior_species='texana')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='Psoloessa' AND (species='texana' OR species='texana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syrbula' AND (junior_species='montezuma' OR junior_species='montezuma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syrbula' AND (species='montezuma' OR species='montezuma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syrbula' AND (species='montezuma' OR species='montezuma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syrbula' AND (junior_species='montezuma' OR junior_species='montezuma')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='montezuma' OR species='montezuma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arphia' AND (junior_species='conspersa' OR junior_species='conspersa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arphia' AND (species='conspersa' OR species='conspersa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arphia' AND (species='conspersa' OR species='conspersa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arphia' AND (junior_species='conspersa' OR junior_species='conspersa')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='Arphia' AND (species='conspersa' OR species='conspersa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hadrotettix' AND (junior_species='trifasciatus' OR junior_species='trifasciatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hadrotettix' AND (species='trifasciatus' OR species='trifasciatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hadrotettix' AND (species='trifasciatus' OR species='trifasciatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hadrotettix' AND (junior_species='trifasciatus' OR junior_species='trifasciatus')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='Hadrotettix' AND (species='trifasciatus' OR species='trifasciatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trimopteris' AND (junior_species='pallidipennis' OR junior_species='pallidipennis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trimopteris' AND (species='pallidipennis' OR species='pallidipennis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trimopteris' AND (species='pallidipennis' OR species='pallidipennis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trimopteris' AND (junior_species='pallidipennis' OR junior_species='pallidipennis')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='Trimopteris' AND (species='pallidipennis' OR species='pallidipennis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthippus' AND (junior_species='corallipes' OR junior_species='corallipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xanthippus' AND (species='corallipes' OR species='corallipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xanthippus' AND (species='corallipes' OR species='corallipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthippus' AND (junior_species='corallipes' OR junior_species='corallipes')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='Xanthippus' AND (species='corallipes' OR species='corallipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aeoloplides' AND (junior_species='rotundipennis' OR junior_species='rotundipennis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aeoloplides' AND (species='rotundipennis' OR species='rotundipennis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aeoloplides' AND (species='rotundipennis' OR species='rotundipennis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aeoloplides' AND (junior_species='rotundipennis' OR junior_species='rotundipennis')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='Aeoloplides' AND (species='rotundipennis' OR species='rotundipennis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dactalotum' AND (junior_species='bicolor' OR junior_species='bicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dactalotum' AND (species='bicolor' OR species='bicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dactalotum' AND (species='bicolor' OR species='bicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dactalotum' AND (junior_species='bicolor' OR junior_species='bicolor')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='Dactalotum' AND (species='bicolor' OR species='bicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hesperotettix' AND (junior_species='viridis' OR junior_species='viridis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hesperotettix' AND (species='viridis' OR species='viridis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hesperotettix' AND (species='viridis' OR species='viridis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hesperotettix' AND (junior_species='viridis' OR junior_species='viridis')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='viridis' OR species='viridis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='arizonae' OR junior_species='arizonae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanoplus' AND (species='arizonae' OR species='arizonae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanoplus' AND (species='arizonae' OR species='arizonae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='arizonae' OR junior_species='arizonae')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='arizonae' OR species='arizonae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='sanguinipes' OR junior_species='sanguinipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanoplus' AND (species='sanguinipes' OR species='sanguinipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanoplus' AND (species='sanguinipes' OR species='sanguinipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='sanguinipes' OR junior_species='sanguinipes')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='sanguinipes' OR species='sanguinipes') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2139 The Ecological Register: Sevilleta National Wildlife Refuge
Sevilleta National Wildlife Refuge
Basic information
Sample name: Sevilleta National Wildlife Refuge

Reference: A. J. Rominger, T. E. X. Miller, and S. L. Collins. 2009. Relative contributions of neutral and niche-based processes to the structure of a desert grassland grasshopper community. Oecologia 161:791-800 [ER 2147]
Geography
Country: United States

State: New Mexico


Coordinate: 34° 20' N, 106° 50' W
Coordinate basis: based on nearby landmark

Geography comments: "at the base of the Los Pinos Mountains" (coordinate based on Sevilleta National Wildlife Refuge)
elevation 1680 to 1820 m

•
Environment
Habitat: desert/xeric shrubland

Protection: wildlife protected area

Substrate: ground surface

MAT: 13.2

WMT: 25.4

CMT: 1.6

MAP: 250.0

Habitat comments: "at the interface of the Chihuahuan Desert and Great Plains biomes" and specifically "in an area of extensive desert grassland" with the dominant species being Bouteloua gracilis and B. eriopoda

Methods
Life forms: orthopterans

Sites: 102

Site area: 0.051

Sampling methods: line transect,hand capture,visual

Sample size: 1378 individuals

Sampling comments: data "were collected during July 2006 using 102 sampling points distributed across 25 km2... 62 points (hereafter 'elevation points') were arranged along three ~1-km transects (one transect numbered 22 points) at 50-m intervals across an elevation gradient from 1,686 to 1,822 m; and (2) 40 points (hereafter 'distance points') were randomly scattered across a 20-km2 area of desert grassland... Each sampling point consisted of a 1 £ 5-m transect along which grasshoppers were Xushed by the observer using a pole to disturb vegetation... grasshoppers were identified by sight in the field... and only immediately unidentifiable individuals were collected"
text claims that 1509 individuals were counted but percentages clearly indicate that 1378 were

Metadata
Sample number: 2139

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-07-24 18:50:06

Modified: 2016-07-24 08:50:06

Abundance distribution
22 species
3 singletons
total count 1378
extrapolated richness: 29.1
Fisher's α: 3.717
geometric series k: 0.7483
Hurlbert's PIE: 0.7959
Shannon's H: 1.9650
Good's u: 0.9978
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Ageneotettix deorum71
Amphitorus coloradus5
Aulocara elliotti23
Aulocara femoratum6
Cordillacris crenulata17
Eritettix simplex89
Heliaula rufa24
Opeia obscurua3
Paropomala pallida364
Phlibostroma quadrimaculatum2
Psoloessa delicatula204
Psoloessa texana441
Syrbula montezuma10
Arphia conspersa1
Hadrotettix trifasciatus53
Trimopteris pallidipennis6
Xanthippus corallipes33
Aeoloplides rotundipennis1
Dactalotum 'bicolor'1
Hesperotettix viridis2
Melanoplus arizonae13
Melanoplus sanguinipes9