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=2200 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2200SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2178SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2200 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Barbitistes' AND (junior_species='constrictus' OR junior_species='constrictus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Barbitistes' AND (species='constrictus' OR species='constrictus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Barbitistes' AND (species='constrictus' OR species='constrictus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Barbitistes' AND (junior_species='constrictus' OR junior_species='constrictus')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='Barbitistes' AND (species='constrictus' OR species='constrictus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Isophya' AND (junior_species='camptoxypha' OR junior_species='camptoxypha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Isophya' AND (species='camptoxypha' OR species='camptoxypha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Isophya' AND (species='camptoxypha' OR species='camptoxypha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Isophya' AND (junior_species='camptoxypha' OR junior_species='camptoxypha')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='Isophya' AND (species='camptoxypha' OR species='camptoxypha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaneroptera' AND (junior_species='falcata' OR junior_species='falcata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phaneroptera' AND (species='falcata' OR species='falcata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phaneroptera' AND (species='falcata' OR species='falcata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaneroptera' AND (junior_species='falcata' OR junior_species='falcata')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='Phaneroptera' AND (species='falcata' OR species='falcata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meconema' AND (junior_species='thalassinum' OR junior_species='thalassinum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Meconema' AND (species='thalassinum' OR species='thalassinum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Meconema' AND (species='thalassinum' OR species='thalassinum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meconema' AND (junior_species='thalassinum' OR junior_species='thalassinum')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='Meconema' AND (species='thalassinum' OR species='thalassinum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pholidoptera' AND (junior_species='aptera' OR junior_species='aptera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pholidoptera' AND (species='aptera' OR species='aptera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pholidoptera' AND (species='aptera' OR species='aptera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pholidoptera' AND (junior_species='aptera' OR junior_species='aptera')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='aptera' OR species='aptera') 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='Platycleis' AND (junior_species='albopunctata' OR junior_species='albopunctata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Platycleis' AND (species='albopunctata' OR species='albopunctata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Platycleis' AND (species='albopunctata' OR species='albopunctata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platycleis' AND (junior_species='albopunctata' OR junior_species='albopunctata')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='Platycleis' AND (species='albopunctata' OR species='albopunctata') 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 senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tettigonia' AND (junior_species='viridissima' OR junior_species='viridissima')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tettigonia' AND (species='viridissima' OR species='viridissima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tettigonia' AND (species='viridissima' OR species='viridissima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tettigonia' AND (junior_species='viridissima' OR junior_species='viridissima')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='viridissima' OR species='viridissima') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetrix' AND (junior_species='subulata' OR junior_species='subulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetrix' AND (species='subulata' OR species='subulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetrix' AND (species='subulata' OR species='subulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetrix' AND (junior_species='subulata' OR junior_species='subulata')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='subulata' OR species='subulata') 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='Tetrix' AND (junior_species='tenuicornis' OR junior_species='tenuicornis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetrix' AND (species='tenuicornis' OR species='tenuicornis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetrix' AND (species='tenuicornis' OR species='tenuicornis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetrix' AND (junior_species='tenuicornis' OR junior_species='tenuicornis')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='tenuicornis' OR species='tenuicornis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetrix' AND (junior_species='bipunctata' OR junior_species='bipunctata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetrix' AND (species='bipunctata' OR species='bipunctata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetrix' AND (species='bipunctata' OR species='bipunctata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetrix' AND (junior_species='bipunctata' OR junior_species='bipunctata')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='bipunctata' OR species='bipunctata') 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='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='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='brunneus' OR junior_species='brunneus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chorthippus' AND (species='brunneus' OR species='brunneus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chorthippus' AND (species='brunneus' OR species='brunneus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chorthippus' AND (junior_species='brunneus' OR junior_species='brunneus')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='brunneus' OR species='brunneus') 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='Chorthippus' AND (junior_species='vagans' OR junior_species='vagans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chorthippus' AND (species='vagans' OR species='vagans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chorthippus' AND (species='vagans' OR species='vagans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chorthippus' AND (junior_species='vagans' OR junior_species='vagans')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='vagans' OR species='vagans') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2200 The Ecological Register: Zvolen (2010)
Zvolen (2010)
Basic information
Sample name: Zvolen (2010)

Reference: A. Sliacka, A. Kristin, and L. Nado. 2013. Orthoptera assemblages of beech stand plots during early succession stages after clearcutting. Journal of Forest Science 59(3):93-100 [ER 2178]
Geography
Country: Slovakia


Coordinate: 48° 34' N, 19° 7' E
Coordinate basis: based on nearby landmark

Geography comments: "in Central Slovakia... in the Kremnickévrchy Mts., Javorie and Poľana Mts." with all sites within a few km of Zvolen (basis of coordinate)
altitude is the midpoint of eight stated values

Environment
Habitat: temperate broadleaf/mixed forest

Altered habitat: clearcut

Substrate: ground surface

Habitat comments: clearcuts "in a broadleaved forest with dominant beech Fagus sylvatica (> 70%)"

Methods
Life forms: orthopterans

Sites: 8

Sampling methods: no design,sweep nets

Sample size: 516 individuals

Years: 2010

Seasons: summer

Sampling comments: there were "Eight study plots... Orthoptera were collected by sweeping (250 sweeps/clearcut/visit" during June and August; "We used a circular sweep net (35 cm in diameter)"

Metadata
Sample number: 2200

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-08-05 19:58:00

Modified: 2016-08-05 10:01:15

Abundance distribution
20 species
1 singleton
total count 516
extrapolated richness: 24.9
Fisher's α: 4.137
geometric series k: 0.7349
Hurlbert's PIE: 0.5366
Shannon's H: 1.5260
Good's u: 0.9981
Each square represents a species. Square sizes are proportional to counts.
Register