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=3020 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3020SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2789SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3020 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='communis' OR junior_species='communis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedes' AND (species='communis' OR species='communis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedes' AND (species='communis' OR species='communis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='communis' OR junior_species='communis')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='Aedes' AND (species='communis' OR species='communis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culiseta' AND (junior_species='inornata' OR junior_species='inornata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culiseta' AND (species='inornata' OR species='inornata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culiseta' AND (species='inornata' OR species='inornata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culiseta' AND (junior_species='inornata' OR junior_species='inornata')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='Culiseta' AND (species='inornata' OR species='inornata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='hexodontus' OR junior_species='hexodontus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedes' AND (species='hexodontus' OR species='hexodontus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedes' AND (species='hexodontus' OR species='hexodontus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='hexodontus' OR junior_species='hexodontus')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='Aedes' AND (species='hexodontus' OR species='hexodontus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='punctor' OR junior_species='punctor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedes' AND (species='punctor' OR species='punctor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedes' AND (species='punctor' OR species='punctor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='punctor' OR junior_species='punctor')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='Aedes' AND (species='punctor' OR species='punctor') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3020 The Ecological Register: Fort Simpson
Fort Simpson
Basic information
Sample name: Fort Simpson

Reference: D. M. McLean, P. N. Grass, B. D. Judd, L. V. Ligate, and K. K. Peter. 1977. Bunyavirus isolations from mosquitoes in the western Canadian Arctic. Journal of Hygiene 79(1):61-71 [ER 2789]
Geography
Country: Canada

State: Northwest Territories


Coordinate: 61° 52' N, 121° 21' W
Coordinate basis: based on nearby landmark

Geography comments: coordinate based on Fort Simpson

•
Environment
Habitat: boreal forest/taiga

Substrate: ground surface

Habitat comments: "The vegetation was open woodland except near Fort Smith... where it comprised boreal forest"

Methods
Life forms: mosquitoes

Sampling methods: no design,hand capture

Sample size: 7705 individuals

Years: 1976

Sampling comments: "collected by hand aspirators... between 29 May and 24 July 1976"

Metadata
Sample number: 3020

Contributor: John Alroy

Enterer: John Alroy

Created: 2018-06-09 20:27:57

Modified: 2018-06-09 10:27:57

Abundance distribution
4 species
0 singletons
total count 7705
extrapolated richness: 4.0
Fisher's α: 0.406
geometric series k: 0.2752
Hurlbert's PIE: 0.4479
Shannon's H: 0.8131
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
Aedes communis5468
Culiseta inornata114
Aedes hexodontus512
Aedes punctor1611