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=2399 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2399SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2293SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2399 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='albopictus' OR junior_species='albopictus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedes' AND (species='albopictus' OR species='albopictus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedes' AND (species='albopictus' OR species='albopictus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='albopictus' OR junior_species='albopictus')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='albopictus' OR species='albopictus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='vexans' OR junior_species='vexans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aedes' AND (species='vexans' OR species='vexans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aedes' AND (species='vexans' OR species='vexans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aedes' AND (junior_species='vexans' OR junior_species='vexans')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='vexans' OR species='vexans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochlerotatus' AND (junior_species='koreicus' OR junior_species='koreicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ochlerotatus' AND (species='koreicus' OR species='koreicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ochlerotatus' AND (species='koreicus' OR species='koreicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochlerotatus' AND (junior_species='koreicus' OR junior_species='koreicus')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='Ochlerotatus' AND (species='koreicus' OR species='koreicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='lindesayi' OR junior_species='lindesayii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='lindesayi' OR species='lindesayii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='lindesayi' OR species='lindesayii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='lindesayi' OR junior_species='lindesayii')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='Anopheles' AND (species='lindesayi' OR species='lindesayii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='pullus' OR junior_species='pullus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='pullus' OR species='pullus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='pullus' OR species='pullus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='pullus' OR junior_species='pullus')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='Anopheles' AND (species='pullus' OR species='pullus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='sinensis' OR junior_species='sinensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='sinensis' OR species='sinensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='sinensis' OR species='sinensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='sinensis' OR junior_species='sinensis')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='Anopheles' AND (species='sinensis' OR species='sinensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='sineroides' OR junior_species='sineroides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopheles' AND (species='sineroides' OR species='sineroides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopheles' AND (species='sineroides' OR species='sineroides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopheles' AND (junior_species='sineroides' OR junior_species='sineroides')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='Anopheles' AND (species='sineroides' OR species='sineroides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Armigeres' AND (junior_species='subalbatus' OR junior_species='subalbatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Armigeres' AND (species='subalbatus' OR species='subalbatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Armigeres' AND (species='subalbatus' OR species='subalbatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Armigeres' AND (junior_species='subalbatus' OR junior_species='subalbatus')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='Armigeres' AND (species='subalbatus' OR species='subalbatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='bitaeniorhynchus' OR junior_species='bitaeniorhynchus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='bitaeniorhynchus' OR species='bitaeniorhynchus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='bitaeniorhynchus' OR species='bitaeniorhynchus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='bitaeniorhynchus' OR junior_species='bitaeniorhynchus')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='Culex' AND (species='bitaeniorhynchus' OR species='bitaeniorhynchus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='mimeticus' OR junior_species='mimeticus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='mimeticus' OR species='mimeticus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='mimeticus' OR species='mimeticus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='mimeticus' OR junior_species='mimeticus')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='Culex' AND (species='mimeticus' OR species='mimeticus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='orientalis' OR junior_species='orientalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='orientalis' OR species='orientalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='orientalis' OR species='orientalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='orientalis' OR junior_species='orientalis')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='Culex' AND (species='orientalis' OR species='orientalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='pipiens' OR junior_species='pipiens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='pipiens' OR species='pipiens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='pipiens' OR species='pipiens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='pipiens' OR junior_species='pipiens')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='Culex' AND (species='pipiens' OR species='pipiens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='tritaeniorhynchus' OR junior_species='tritaeniorhynchus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culex' AND (species='tritaeniorhynchus' OR species='tritaeniorhynchus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='tritaeniorhynchus' OR species='tritaeniorhynchus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' AND (junior_species='tritaeniorhynchus' OR junior_species='tritaeniorhynchus')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='Culex' AND (species='tritaeniorhynchus' OR species='tritaeniorhynchus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' 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='Culex' AND (species='vagans' OR species='vagans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culex' AND (species='vagans' OR species='vagans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culex' 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='Culex' AND (species='vagans' OR species='vagans') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2399 The Ecological Register: Dongducheon
Dongducheon
Basic information
Sample name: Dongducheon

Reference: H. C. Kim, K. W. Lee, R. S. Richards, S. S. Schleich, W. E. Herman, and T. A. Klein. 2003. Seasonal prevalence of mosquitoes collected from light traps in Korea (1999-2000). Korean Journal of Entomology 33(1):9-16 [ER 2293]
Geography
Country: South Korea

State: Gyeonggi


Coordinate: 37° 55' N, 127° 4' E
Coordinate basis: based on nearby landmark

Geography comments: on an unspecified US Army installation (coordinate based on Dongducheon)

Environment
Habitat: temperate broadleaf/mixed forest

Altered habitat: inhabited area

Protection: unprotected

Substrate: ground surface

Habitat comments: none given

Methods
Life forms: mosquitoes

Sampling methods: no design,light traps

Sample size: 10089 individuals

Years: 1999, 2000

Sampling comments: mosquitoes were "collected using New Jersey light traps... the light trap sites were selected at least 100 m from the nearest external light sources and 25-50 m away from multistory buildings... The traps were operated... 1-4 times weekly" over an unclear sampling interval

Metadata
Sample number: 2399

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-12-26 19:46:28

Modified: 2020-01-14 05:07:46

Abundance distribution
14 species
1 singleton
total count 10089
extrapolated richness: 16.6
Fisher's α: 1.600
geometric series k: 0.5130
Hurlbert's PIE: 0.5927
Shannon's H: 1.1496
Good's u: 0.9999
Each square represents a species. Square sizes are proportional to counts.
Register