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=2197 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2197SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2175SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2197 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='sanguinipes' OR junior_species='sanguinipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanoplus' AND (species='sanguinipes' OR species='sanguinipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanoplus' AND (species='sanguinipes' OR species='sanguinipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='sanguinipes' OR junior_species='sanguinipes')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='Melanoplus' AND (species='sanguinipes' OR species='sanguinipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camnula' AND (junior_species='pellucida' OR junior_species='pellucida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Camnula' AND (species='pellucida' OR species='pellucida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Camnula' AND (species='pellucida' OR species='pellucida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camnula' AND (junior_species='pellucida' OR junior_species='pellucida')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='Camnula' AND (species='pellucida' OR species='pellucida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spharagemon' AND (junior_species='collare' OR junior_species='collare')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spharagemon' AND (species='collare' OR species='collare') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spharagemon' AND (species='collare' OR species='collare')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spharagemon' AND (junior_species='collare' OR junior_species='collare')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='Spharagemon' AND (species='collare' OR species='collare') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Encoptolophus' AND (junior_species='sordidus' OR junior_species='sordidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Encoptolophus' AND (species='sordidus' OR species='sordidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Encoptolophus' AND (species='sordidus' OR species='sordidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Encoptolophus' AND (junior_species='sordidus' OR junior_species='sordidus')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='Encoptolophus' AND (species='sordidus' OR species='sordidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orphulella' AND (junior_species='speciosa' OR junior_species='speciosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orphulella' AND (species='speciosa' OR species='speciosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orphulella' AND (species='speciosa' OR species='speciosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orphulella' AND (junior_species='speciosa' OR junior_species='speciosa')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='Orphulella' AND (species='speciosa' OR species='speciosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='spp.' OR junior_species='spp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanoplus' AND (species='spp.' OR species='spp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanoplus' AND (species='spp.' OR species='spp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoplus' AND (junior_species='spp.' OR junior_species='spp.')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='Melanoplus' AND (species='spp.' OR species='spp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chortophaga' AND (junior_species='viridifasciata' OR junior_species='viridifasciata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chortophaga' AND (species='viridifasciata' OR species='viridifasciata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chortophaga' AND (species='viridifasciata' OR species='viridifasciata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chortophaga' AND (junior_species='viridifasciata' OR junior_species='viridifasciata')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='Chortophaga' AND (species='viridifasciata' OR species='viridifasciata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dissosteira' AND (junior_species='carolina' OR junior_species='carolina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dissosteira' AND (species='carolina' OR species='carolina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dissosteira' AND (species='carolina' OR species='carolina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dissosteira' AND (junior_species='carolina' OR junior_species='carolina')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='Dissosteira' AND (species='carolina' OR species='carolina') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2197 The Ecological Register: Chatterton (1944)
Chatterton (1944)
Basic information
Sample name: Chatterton (1944)

Reference: R. W. Smith. 1965. A field population of Melanoplus sanguinipes (Fab.) (Orthoptera: Acrididae) and its parasites. Canadian Journal of Zoology 43:179-201 [ER 2175]
Geography
Country: Canada

State: Ontario


Coordinate: 44° 45' N, 77° 35' W
Coordinate basis: based on political unit

Geography comments: "about 1 mile west of the village of Chatterton" (coordinate based on Hastings County)

•
Environment
Habitat: temperate broadleaf/mixed forest

Altered habitat: pasture

Substrate: ground surface

Habitat comments: "a 5-acre field of gently rolling pastureland... bounded on the north by deciduous woodland"

Methods
Life forms: orthopterans

Sampling methods: quadrat,sweep nets,other traps

Sample size: 2394 individuals

Years: 1944

Days: 21

Seasons: spring,summer,autumn

Sampling comments: populations "were sampled from early May to late September, weekly... On each sampling day two series of 20 samples were taken in close proximity to wooden markers placed at the intersections of a 30- x 40-pace grid. One series was taken with a square-yard sampler... and the other with a 15-in. net (15 sweeps of 180ยบ per sample)" (sampling was therefore over approximately 21 weeks)

Metadata
Sample number: 2197

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-08-05 14:16:18

Modified: 2016-08-05 04:16:18

Abundance distribution
8 species
0 singletons
total count 2394
extrapolated richness: 8.4
Fisher's α: 1.032
geometric series k: 0.4435
Hurlbert's PIE: 0.4262
Shannon's H: 0.9168
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Melanoplus sanguinipes1777
Camnula pellucida315
Spharagemon collare88
Encoptolophus sordidus12
Orphulella speciosa146
Melanoplus spp.28
M. femurrubrum and M. confusus
Chortophaga viridifasciata6
Dissosteira carolina22