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=2207 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2207SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2181SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2207 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chorthippus' AND (junior_species='apricarius' OR junior_species='apricarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chorthippus' AND (species='apricarius' OR species='apricarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chorthippus' AND (species='apricarius' OR species='apricarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chorthippus' AND (junior_species='apricarius' OR junior_species='apricarius')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='Chorthippus' AND (species='apricarius' OR species='apricarius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chorthippus' AND (junior_species='biguttulus' OR junior_species='biguttulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chorthippus' AND (species='biguttulus' OR species='biguttulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chorthippus' AND (species='biguttulus' OR species='biguttulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chorthippus' AND (junior_species='biguttulus' OR junior_species='biguttulus')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='Chorthippus' AND (species='biguttulus' OR species='biguttulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chorthippus' AND (junior_species='montanus' OR junior_species='montanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chorthippus' AND (species='montanus' OR species='montanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chorthippus' AND (species='montanus' OR species='montanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chorthippus' AND (junior_species='montanus' OR junior_species='montanus')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='Chorthippus' AND (species='montanus' OR species='montanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chorthippus' AND (junior_species='parallelus' OR junior_species='parallelus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chorthippus' AND (species='parallelus' OR species='parallelus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chorthippus' AND (species='parallelus' OR species='parallelus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chorthippus' AND (junior_species='parallelus' OR junior_species='parallelus')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='Chorthippus' AND (species='parallelus' OR species='parallelus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysochraon' AND (junior_species='dispar' OR junior_species='dispar')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chrysochraon' AND (species='dispar' OR species='dispar') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chrysochraon' AND (species='dispar' OR species='dispar')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysochraon' AND (junior_species='dispar' OR junior_species='dispar')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='Chrysochraon' AND (species='dispar' OR species='dispar') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euthystira' AND (junior_species='brachyptera' OR junior_species='brachyptera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euthystira' AND (species='brachyptera' OR species='brachyptera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euthystira' AND (species='brachyptera' OR species='brachyptera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euthystira' AND (junior_species='brachyptera' OR junior_species='brachyptera')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='Euthystira' AND (species='brachyptera' OR species='brachyptera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gomphocerippus' AND (junior_species='rufus' OR junior_species='rufus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gomphocerippus' AND (species='rufus' OR species='rufus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gomphocerippus' AND (species='rufus' OR species='rufus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gomphocerippus' AND (junior_species='rufus' OR junior_species='rufus')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='Gomphocerippus' AND (species='rufus' OR species='rufus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Omocestus' AND (junior_species='viridulus' OR junior_species='viridulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Omocestus' AND (species='viridulus' OR species='viridulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Omocestus' AND (species='viridulus' OR species='viridulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Omocestus' AND (junior_species='viridulus' OR junior_species='viridulus')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='Omocestus' AND (species='viridulus' OR species='viridulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetrix' AND (junior_species='undulata' OR junior_species='undulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetrix' AND (species='undulata' OR species='undulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetrix' AND (species='undulata' OR species='undulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetrix' AND (junior_species='undulata' OR junior_species='undulata')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='Tetrix' AND (species='undulata' OR species='undulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Decticus' AND (junior_species='verrucivorus' OR junior_species='verrucivorus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Decticus' AND (species='verrucivorus' OR species='verrucivorus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Decticus' AND (species='verrucivorus' OR species='verrucivorus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Decticus' AND (junior_species='verrucivorus' OR junior_species='verrucivorus')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='Decticus' AND (species='verrucivorus' OR species='verrucivorus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metrioptera' AND (junior_species='brachyptera' OR junior_species='brachyptera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Metrioptera' AND (species='brachyptera' OR species='brachyptera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Metrioptera' AND (species='brachyptera' OR species='brachyptera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metrioptera' AND (junior_species='brachyptera' OR junior_species='brachyptera')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='Metrioptera' AND (species='brachyptera' OR species='brachyptera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metrioptera' AND (junior_species='roeselii' OR junior_species='roeseli')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Metrioptera' AND (species='roeselii' OR species='roeseli') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Metrioptera' AND (species='roeselii' OR species='roeseli')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metrioptera' AND (junior_species='roeselii' OR junior_species='roeseli')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='Metrioptera' AND (species='roeselii' OR species='roeseli') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pholidoptera' AND (junior_species='griseoaptera' OR junior_species='griseoaptera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pholidoptera' AND (species='griseoaptera' OR species='griseoaptera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pholidoptera' AND (species='griseoaptera' OR species='griseoaptera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pholidoptera' AND (junior_species='griseoaptera' OR junior_species='griseoaptera')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='Pholidoptera' AND (species='griseoaptera' OR species='griseoaptera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tettigonia' AND (junior_species='cantans' OR junior_species='cantans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tettigonia' AND (species='cantans' OR species='cantans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tettigonia' AND (species='cantans' OR species='cantans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tettigonia' AND (junior_species='cantans' OR junior_species='cantans')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='Tettigonia' AND (species='cantans' OR species='cantans') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2207 The Ecological Register: Hrubý Jeseník Mountains (sweep netting)
Hrubý Jeseník Mountains (sweep netting)
Basic information
Sample name: Hrubý Jeseník Mountains (sweep netting)

Reference: S. Rada, M. Mazalova, J. Sipos, and T. Kuras. 2014. Impacts of mowing, grazing and edge effect on Orthoptera of submontane grasslands: perspectives for biodiversity protection. Polish Journal of Ecology 62:123-138 [ER 2181]
Geography
Country: Czech Republic


Coordinate: 50° 5' N, 17° 10' E
Coordinate basis: based on nearby landmark

Geography comments: "in the submontane area of the Hrubý Jeseník Mts., in the north-eastern part of the Czech Republic, neighbouring Poland" in an "area of approximately 180 ha" (coordinate based on Hrubý Jeseník)
altitude 730 to 830 m

•
Environment
Habitat: temperate savanna

Altered habitat: pasture

Substrate: ground surface

MAT: 6.5

MAP: 900.0

Habitat comments: "grassland... almost completely surrounded by forest"; grazing intensity was low and "meadows were not fertilised" but "were cut once a year using rotary mower without conditioner"

Methods
Life forms: orthopterans

Sites: 12

Sampling methods: no design,sweep nets

Sample size: 461 individuals

Years: 2010

Days: 3

Sampling comments: "We selected 12 study patches which differed in management (mowing, grazing or both) and in timing of the treatments... Average size of the individual patches was about 3 ha (the smallest covered the area of 0.6 ha, the largest the area of 6.7 ha)... Representative numbers of sampling spots for each patch were derived from an area of particular patch (1 spot for 0.5 ha). For every sampling day we recorded 72 sam- pling spots in total... One sampling on a sampling spot comprised series of 10 sweeps... The diameter of the sweep net was 35 cm. The sweep netting was conducted during three visits (23rd of July, 15th of August and 19th of September 2010)"

Metadata
Sample number: 2207

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-08-06 20:41:57

Modified: 2016-08-06 10:44:14

Abundance distribution
14 species
0 singletons
total count 461
extrapolated richness: 16.8
Fisher's α: 2.726
geometric series k: 0.7443
Hurlbert's PIE: 0.8621
Shannon's H: 2.1451
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
Chorthippus apricarius16
Chorthippus biguttulus77
Chorthippus montanus2
Chorthippus parallelus80
Chrysochraon dispar48
Euthystira brachyptera27
Gomphocerippus rufus93
Omocestus viridulus57
Tetrix undulata2
Decticus verrucivorus6
Metrioptera brachyptera3
Metrioptera roeselii40
Pholidoptera griseoaptera2
Tettigonia cantans8