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=2145 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2145SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2151SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2145 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arcyptera' AND (junior_species='carpentieri' OR junior_species='carpentierii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arcyptera' AND (species='carpentieri' OR species='carpentierii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arcyptera' AND (species='carpentieri' OR species='carpentierii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arcyptera' AND (junior_species='carpentieri' OR junior_species='carpentierii')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='Arcyptera' AND (species='carpentieri' OR species='carpentierii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calliptamus' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calliptamus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calliptamus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calliptamus' AND (junior_species='sp.' OR junior_species='sp.')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='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celes' AND (junior_species='variabilis' OR junior_species='variabilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Celes' AND (species='variabilis' OR species='variabilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Celes' AND (species='variabilis' OR species='variabilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celes' AND (junior_species='variabilis' OR junior_species='variabilis')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='Celes' AND (species='variabilis' OR species='variabilis') 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='scalaris' OR junior_species='scalaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chorthippus' AND (species='scalaris' OR species='scalaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chorthippus' AND (species='scalaris' OR species='scalaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chorthippus' AND (junior_species='scalaris' OR junior_species='scalaris')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='scalaris' OR species='scalaris') 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='Ephippiger' AND (junior_species='ephippiger' OR junior_species='ephippiger')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ephippiger' AND (species='ephippiger' OR species='ephippiger') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ephippiger' AND (species='ephippiger' OR species='ephippiger')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ephippiger' AND (junior_species='ephippiger' OR junior_species='ephippiger')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='Ephippiger' AND (species='ephippiger' OR species='ephippiger') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euchorthippus' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euchorthippus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euchorthippus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euchorthippus' AND (junior_species='sp.' OR junior_species='sp.')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='Euchorthippus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gampsocleis' AND (junior_species='glabra' OR junior_species='glabra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gampsocleis' AND (species='glabra' OR species='glabra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gampsocleis' AND (species='glabra' OR species='glabra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gampsocleis' AND (junior_species='glabra' OR junior_species='glabra')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='Gampsocleis' AND (species='glabra' OR species='glabra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gryllus' AND (junior_species='campestris' OR junior_species='campestris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gryllus' AND (species='campestris' OR species='campestris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gryllus' AND (species='campestris' OR species='campestris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gryllus' AND (junior_species='campestris' OR junior_species='campestris')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='Gryllus' AND (species='campestris' OR species='campestris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmeleottetix' 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='Myrmeleottetix' AND (species='maculatus' OR species='maculatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrmeleottetix' AND (species='maculatus' OR species='maculatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmeleottetix' 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='Myrmeleottetix' 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='petraeus' OR junior_species='petraeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Omocestus' AND (species='petraeus' OR species='petraeus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Omocestus' AND (species='petraeus' OR species='petraeus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Omocestus' AND (junior_species='petraeus' OR junior_species='petraeus')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='petraeus' OR species='petraeus') 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='Platycleis' AND (junior_species='tessellata' OR junior_species='tessellata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Platycleis' AND (species='tessellata' OR species='tessellata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Platycleis' AND (species='tessellata' OR species='tessellata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platycleis' AND (junior_species='tessellata' OR junior_species='tessellata')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='tessellata' OR species='tessellata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenobothrus' AND (junior_species='lineatus' OR junior_species='lineatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stenobothrus' AND (species='lineatus' OR species='lineatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stenobothrus' AND (species='lineatus' OR species='lineatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenobothrus' AND (junior_species='lineatus' OR junior_species='lineatus')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='Stenobothrus' AND (species='lineatus' OR species='lineatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenobothrus' AND (junior_species='nigromaculatus' OR junior_species='nigromaculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stenobothrus' AND (species='nigromaculatus' OR species='nigromaculatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stenobothrus' AND (species='nigromaculatus' OR species='nigromaculatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenobothrus' AND (junior_species='nigromaculatus' OR junior_species='nigromaculatus')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='Stenobothrus' AND (species='nigromaculatus' OR species='nigromaculatus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2145 The Ecological Register: Cevennes National Park (S2)
Cevennes National Park (S2)
Basic information
Sample name: Cevennes National Park (S2)

Reference: J. Fonderflick, A. Besnard, A. Beuret, M. Dalmais, and B. Schatz. 2014. The impact of grazing management on Orthoptera abundance varies over the season in Mediterranean steppe-like grassland. Acta Oecologica 60:7-16 [ER 2151]
Geography
Country: France


Coordinate: 44° 17' N, 3° 31' E
Coordinate basis: stated in text

Geography comments: "on a high limestone plateau (Causse Mejean)" and specifically on "an experimental farm... managed by the Cevennes National Park"
altitude 950 to 1100 m

•
Environment
Habitat: temperate savanna

Altered habitat: pasture

Protection: national/state park

Substrate: ground surface

WMT: 23.0

CMT: 3.0

MAP: 1000.0

Habitat comments: "steppe-like grasslands with some cultivated zones" with a "mixed continental and Mediterranean climate... This study was carried out in seven pasture areas, five of which had been grazed by sheep every year for at least 10 years, and two of which had not been grazed (ungrazed grassland) for at least six years and were used as control plots"

Methods
Life forms: orthopterans

Sites: 7

Sampling methods: line transect,hand capture,visual

Sample size: 1214 individuals

Years: 2010

Seasons: summer

Sampling comments: "We randomly placed 25 10-m2 plots in each of the seven pastures" and performed a sampling session "lasting 4-5 days" and specifically starting on 26 July; "we counted and identified Orthoptera (Ensifera and Califera) along a permanent 10-m2 line-transect (10 m in length 1 m in width, defined by two permanent wooden markers)"; most identifications were visual but "a local sample" was drawn to establish "a mean ratio of the two species" in each of three genera; the ratio apparently does not affect the actual reported counts

Metadata
Sample number: 2145

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-07-25 17:20:11

Modified: 2016-07-25 07:20:11

Abundance distribution
16 species
1 singleton
total count 1214
extrapolated richness: 19.0
Fisher's α: 2.603
geometric series k: 0.6573
Hurlbert's PIE: 0.7002
Shannon's H: 1.5861
Good's u: 0.9992
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Arcyptera carpentieri10
Calliptamus sp.15
Celes variabilis6
Chorthippus biguttulus25
Chorthippus scalaris13
Decticus verrucivorus4
Ephippiger ephippiger10
Euchorthippus sp.357
Gampsocleis glabra2
Gryllus campestris1
Myrmeleottetix maculatus14
Omocestus petraeus59
Platycleis albopunctata22
Platycleis tessellata9
Stenobothrus lineatus126
Stenobothrus nigromaculatus541