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=2177 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2177SELECT 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=2177 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 * FROM register WHERE sample_no=2177 The Ecological Register: Ziemupe Nature Reserve (2005)
Ziemupe Nature Reserve (2005)
Basic information
Sample name: Ziemupe Nature Reserve (2005)

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: 156 individuals

Years: 2005

Days: 14

Seasons: summer

Nets or traps: 90

Net or trap nights: 1260

Sampling comments: "faunistic data were obtained also by use of pitfall traps... Pitfall traps were arranged on three transects parallel in-between (interval between them was 7-8 m) and perpendicular to the coast. Every of three 60 m a long transect started at white dune then crossed typical grey dune and ended at dry coastal meadow. The distance between traps was 2 m. The exposition period lasted two weeks"

Metadata
Sample number: 2177

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-08-04 12:50:34

Modified: 2016-08-04 02:53:14

Abundance distribution
6 species
1 singleton
total count 156
extrapolated richness: 8.4
Fisher's α: 1.239
geometric series k: 0.3935
Hurlbert's PIE: 0.4911
Shannon's H: 0.9792
Good's u: 0.9936
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Myrmeleotettix maculatus106
Omocestus haemorrhoidalis30
Chorthippus brunneus12
Chorthippus vagans4
Decticus verrucivorus3
Oedipoda coerulescens1