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=2196 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2196SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2174SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2196 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oedipoda' AND (junior_species='miniata' OR junior_species='miniata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oedipoda' AND (species='miniata' OR species='miniata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oedipoda' AND (species='miniata' OR species='miniata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oedipoda' AND (junior_species='miniata' OR junior_species='miniata')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='Oedipoda' AND (species='miniata' OR species='miniata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calliptamus' AND (junior_species='italicus' OR junior_species='italicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calliptamus' AND (species='italicus' OR species='italicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calliptamus' AND (species='italicus' OR species='italicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calliptamus' AND (junior_species='italicus' OR junior_species='italicus')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='Calliptamus' AND (species='italicus' OR species='italicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Locusta' AND (junior_species='migratoria' OR junior_species='migratoria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Locusta' AND (species='migratoria' OR species='migratoria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Locusta' AND (species='migratoria' OR species='migratoria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Locusta' AND (junior_species='migratoria' OR junior_species='migratoria')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='Locusta' AND (species='migratoria' OR species='migratoria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eromopeza' AND (junior_species='gibberto' OR junior_species='gibberto')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eromopeza' AND (species='gibberto' OR species='gibberto') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eromopeza' AND (species='gibberto' OR species='gibberto')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eromopeza' AND (junior_species='gibberto' OR junior_species='gibberto')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='Eromopeza' AND (species='gibberto' OR species='gibberto') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrgodera' AND (junior_species='armata' OR junior_species='armata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyrgodera' AND (species='armata' OR species='armata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyrgodera' AND (species='armata' OR species='armata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrgodera' AND (junior_species='armata' OR junior_species='armata')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='Pyrgodera' AND (species='armata' OR species='armata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Schistocerca' AND (junior_species='gregaria' OR junior_species='gregaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Schistocerca' AND (species='gregaria' OR species='gregaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Schistocerca' AND (species='gregaria' OR species='gregaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Schistocerca' AND (junior_species='gregaria' OR junior_species='gregaria')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='Schistocerca' AND (species='gregaria' OR species='gregaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dociostaurus' AND (junior_species='maroccanus' OR junior_species='maroccanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dociostaurus' AND (species='maroccanus' OR species='maroccanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dociostaurus' AND (species='maroccanus' OR species='maroccanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dociostaurus' AND (junior_species='maroccanus' OR junior_species='maroccanus')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='Dociostaurus' AND (species='maroccanus' OR species='maroccanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrgomorpha' AND (junior_species='cognata' OR junior_species='cognata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyrgomorpha' AND (species='cognata' OR species='cognata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyrgomorpha' AND (species='cognata' OR species='cognata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrgomorpha' AND (junior_species='cognata' OR junior_species='cognata')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='Pyrgomorpha' AND (species='cognata' OR species='cognata') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2196 The Ecological Register: Akhlamad (4:00 PM)
Akhlamad (4:00 PM)
Basic information
Sample name: Akhlamad (4:00 PM)

Reference: A. Jabbari, M. Modarres Awal, L. Fekrat, J. Karimi, and M. Rashki. 2015. On the short-horned grasshopper (Orthoptera: Caelifera) fauna of northeastern Iran with some information on sweep sampling capture rates. Iranian Journal of Animal Biosystematics 11(1):33-42 [ER 2174]
Geography
Country: Iran

State: Khorasan-e-Razavi


Coordinate: 36.594398° N, 58.9464° E
Coordinate basis: stated in text

•
Environment
Habitat: temperate savanna

Substrate: ground surface

Disturbance: grazing

Habitat comments: "rangeland... with mixed-grass vegetation and low grazzing pressure"

Methods
Life forms: orthopterans

Sampling methods: no design,sweep nets

Sample size: 145 individuals

Years: 2014

Days: 9

Seasons: summer,autumn

Sampling comments: "sampled over three consecutive days for three sampling periods between June and September. Twenty low and fast sweeps... were taken"

Metadata
Sample number: 2196

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-08-04 21:04:30

Modified: 2016-08-04 11:04:30

Abundance distribution
8 species
0 singletons
total count 145
extrapolated richness: 8.9
Fisher's α: 1.823
geometric series k: 0.7197
Hurlbert's PIE: 0.7605
Shannon's H: 1.7244
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
Oedipoda miniata60
Calliptamus italicus24
Locusta migratoria6
Eromopeza gibberto23
Pyrgodera armata9
Schistocerca gregaria9
Dociostaurus maroccanus7
Pyrgomorpha cognata7