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=2178 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2178SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2167SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2178 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmeleotettix' AND (junior_species='maculatus' OR junior_species='maculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrmeleotettix' AND (species='maculatus' OR species='maculatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrmeleotettix' AND (species='maculatus' OR species='maculatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmeleotettix' AND (junior_species='maculatus' OR junior_species='maculatus')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='Myrmeleotettix' AND (species='maculatus' OR species='maculatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Omocestus' AND (junior_species='haemorrhoidalis' OR junior_species='haemorrhoidalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Omocestus' AND (species='haemorrhoidalis' OR species='haemorrhoidalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Omocestus' AND (species='haemorrhoidalis' OR species='haemorrhoidalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Omocestus' AND (junior_species='haemorrhoidalis' OR junior_species='haemorrhoidalis')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='haemorrhoidalis' OR species='haemorrhoidalis') 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='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 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='Oedipoda' AND (junior_species='coerulescens' OR junior_species='coerulescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oedipoda' AND (species='coerulescens' OR species='coerulescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oedipoda' AND (species='coerulescens' OR species='coerulescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oedipoda' AND (junior_species='coerulescens' OR junior_species='coerulescens')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='coerulescens' OR species='coerulescens') 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 * FROM register WHERE sample_no=2178 The Ecological Register: Ziemupe Nature Reserve (2006)
Ziemupe Nature Reserve (2006)
Basic information
Sample name: Ziemupe Nature Reserve (2006)

Reference: V. Spungis. 2007. Fauna and ecology of grasshoppers (Orthoptera) in the coastal dune habitats in Ziemupe Nature Reserve, Latvia. Latvijas entomologs 44:58-68 [ER 2167]
Geography
Country: Latvia


Coordinate: 56° 53' N, 21° 10' E
Coordinate basis: based on nearby landmark

Geography comments: south of Pavilosta (basis of coordinate)

•
Environment
Habitat: temperate coniferous forest

Protection: nature reserve

Substrate: ground surface

Habitat comments: "coastal dune habitats... The white dune bordering the sea was narrow and low, gradually transforming to the grey dune. This habitat covered about 20 m wide zone. The width of typical grey dune was about 50 m. Inlands the grey dune is bordered by dry grassland near Scotch pine plantings"

Methods
Life forms: orthopterans

Sampling methods: line transect,pitfall traps

Sample size: 920 individuals

Years: 2006

Days: 224

Seasons: spring,summer,autumn

Nets or traps: 40

Net or trap nights: 8960

Sampling comments: "One transect was selected for studies during the whole non-freeze period of the year – from April to November. 40 pitfall traps were arranged on 80 m long transect. Transect started on white dune then crossed typical grey dune and ended at dry coastal meadow. The distance between traps was 2 m. The traps were emptied and refilled every two weeks from 02.04.2006 to 12.11.2006" (i.e., over a 224 day span, meaning 17 collection events)

Metadata
Sample number: 2178

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-08-04 12:55:05

Modified: 2016-08-04 02:55:05

Abundance distribution
7 species
1 singleton
total count 920
extrapolated richness: 9.4
Fisher's α: 1.030
geometric series k: 0.3238
Hurlbert's PIE: 0.1080
Shannon's H: 0.2989
Good's u: 0.9989
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Myrmeleotettix maculatus868
Omocestus haemorrhoidalis3
Chorthippus brunneus21
Chorthippus vagans16
Decticus verrucivorus6
Oedipoda coerulescens1
Tetrix subulata5