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=858 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=858SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=493SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=858 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camponotus' AND (junior_species='herculeanus' OR junior_species='herculeanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Camponotus' AND (species='herculeanus' OR species='herculeanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Camponotus' AND (species='herculeanus' OR species='herculeanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camponotus' AND (junior_species='herculeanus' OR junior_species='herculeanus')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='Camponotus' AND (species='herculeanus' OR species='herculeanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formica' AND (junior_species='fusca' OR junior_species='fusca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Formica' AND (species='fusca' OR species='fusca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Formica' AND (species='fusca' OR species='fusca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formica' AND (junior_species='fusca' OR junior_species='fusca')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='Formica' AND (species='fusca' OR species='fusca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formica' AND (junior_species='pratensis' OR junior_species='pratensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Formica' AND (species='pratensis' OR species='pratensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Formica' AND (species='pratensis' OR species='pratensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formica' AND (junior_species='pratensis' OR junior_species='pratensis')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='Formica' AND (species='pratensis' OR species='pratensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formica' AND (junior_species='rufibarbis' OR junior_species='rufibarbis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Formica' AND (species='rufibarbis' OR species='rufibarbis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Formica' AND (species='rufibarbis' OR species='rufibarbis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formica' AND (junior_species='rufibarbis' OR junior_species='rufibarbis')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='Formica' AND (species='rufibarbis' OR species='rufibarbis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formica' AND (junior_species='sanguinea' OR junior_species='sanguinea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Formica' AND (species='sanguinea' OR species='sanguinea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Formica' AND (species='sanguinea' OR species='sanguinea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formica' AND (junior_species='sanguinea' OR junior_species='sanguinea')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='Formica' AND (species='sanguinea' OR species='sanguinea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formica' AND (junior_species='truncorum' OR junior_species='truncorum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Formica' AND (species='truncorum' OR species='truncorum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Formica' AND (species='truncorum' OR species='truncorum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formica' AND (junior_species='truncorum' OR junior_species='truncorum')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='Formica' AND (species='truncorum' OR species='truncorum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasius' AND (junior_species='niger' OR junior_species='niger')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasius' AND (species='niger' OR species='niger') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasius' AND (species='niger' OR species='niger')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasius' AND (junior_species='niger' OR junior_species='niger')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='Lasius' AND (species='niger' OR species='niger') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasius' AND (junior_species='platythorax' OR junior_species='platythorax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasius' AND (species='platythorax' OR species='platythorax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasius' AND (species='platythorax' OR species='platythorax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasius' AND (junior_species='platythorax' OR junior_species='platythorax')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='Lasius' AND (species='platythorax' OR species='platythorax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmica' AND (junior_species='rubra' OR junior_species='rubra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrmica' AND (species='rubra' OR species='rubra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrmica' AND (species='rubra' OR species='rubra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmica' AND (junior_species='rubra' OR junior_species='rubra')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='Myrmica' AND (species='rubra' OR species='rubra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmica' AND (junior_species='ruginodis' OR junior_species='ruginodis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrmica' AND (species='ruginodis' OR species='ruginodis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrmica' AND (species='ruginodis' OR species='ruginodis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmica' AND (junior_species='ruginodis' OR junior_species='ruginodis')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='Myrmica' AND (species='ruginodis' OR species='ruginodis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmica' AND (junior_species='rugulosa' OR junior_species='rugulosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrmica' AND (species='rugulosa' OR species='rugulosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrmica' AND (species='rugulosa' OR species='rugulosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmica' AND (junior_species='rugulosa' OR junior_species='rugulosa')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='Myrmica' AND (species='rugulosa' OR species='rugulosa') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=858 The Ecological Register: Cerna Studnice Hill (pitfall traps)
Cerna Studnice Hill (pitfall traps)
Basic information
Sample name: Cerna Studnice Hill (pitfall traps)

Reference: A. Véle, J. Holusa, and J. Frouz. 2009. Sampling for ants in different-aged spruce forests: A comparison of methods. European Journal of Soil Biology 45:301-305 [ER 493]
Geography
Country: Czech Republic


Coordinate: 50° 42' 30" N, 15° 12' 32" E
Coordinate basis: stated in text

Geography comments: elevation 620 to 760 m

Environment
Habitat: temperate coniferous forest

Altered habitat: plantation

Protection: unprotected

Substrate: ground surface

MAT: 7.0

MAP: 1000.0

Habitat comments: "the original beech woods were replaced by spruce monocultures so that now spruce is the predominant species in this rugged upland"

Methods
Life forms: ants

Sites: 25

Site area: 1

Sampling methods: quadrat,baited,pitfall traps

Sample size: 2362 individuals

Years: 2005, 2006

Days: 84

Nets or traps: 150

Net or trap nights: 12600

Sampling comments: five 20 x 20 m plots at each of five sites with six traps placed at the margin of each plot, with a "canned tuna fish" bait "placed 30 cm from each pitfall trap"; "Pitfall traps were deployed at each site for 2 weeks in June, July, and August in both years" (apparently meaning for six weeks in each of three years)

Metadata
Sample number: 858

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-04-20 17:40:18

Modified: 2020-01-03 01:03:31

Abundance distribution
11 species
2 singletons
total count 2362
extrapolated richness: 14.9
Fisher's α: 1.493
geometric series k: 0.5073
Hurlbert's PIE: 0.6997
Shannon's H: 1.3848
Good's u: 0.9992
Each square represents a species. Square sizes are proportional to counts.
Register