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=1535 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1535SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1036SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1535 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anisodactylus' AND (junior_species='punctatipennis' OR junior_species='punctatipennis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anisodactylus' AND (species='punctatipennis' OR species='punctatipennis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anisodactylus' AND (species='punctatipennis' OR species='punctatipennis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anisodactylus' AND (junior_species='punctatipennis' OR junior_species='punctatipennis')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='Anisodactylus' AND (species='punctatipennis' OR species='punctatipennis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlaenius' AND (junior_species='bioculatus' OR junior_species='bioculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlaenius' AND (species='bioculatus' OR species='bioculatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlaenius' AND (species='bioculatus' OR species='bioculatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlaenius' AND (junior_species='bioculatus' OR junior_species='bioculatus')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='Chlaenius' AND (species='bioculatus' OR species='bioculatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlaenius' AND (junior_species='micans' OR junior_species='micans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlaenius' AND (species='micans' OR species='micans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlaenius' AND (species='micans' OR species='micans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlaenius' AND (junior_species='micans' OR junior_species='micans')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='Chlaenius' AND (species='micans' OR species='micans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlaenius' AND (junior_species='ocreatus' OR junior_species='ocreatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlaenius' AND (species='ocreatus' OR species='ocreatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlaenius' AND (species='ocreatus' OR species='ocreatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlaenius' AND (junior_species='ocreatus' OR junior_species='ocreatus')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='Chlaenius' AND (species='ocreatus' OR species='ocreatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlaenius' AND (junior_species='pallipes' OR junior_species='pallipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlaenius' AND (species='pallipes' OR species='pallipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlaenius' AND (species='pallipes' OR species='pallipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlaenius' AND (junior_species='pallipes' OR junior_species='pallipes')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='Chlaenius' AND (species='pallipes' OR species='pallipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='jankowskii' OR junior_species='jankowski')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carabus' AND (species='jankowskii' OR species='jankowski') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carabus' AND (species='jankowskii' OR species='jankowski')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carabus' AND (junior_species='jankowskii' OR junior_species='jankowski')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='Carabus' AND (species='jankowskii' OR species='jankowski') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dolichus' AND (junior_species='halensis' OR junior_species='halensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dolichus' AND (species='halensis' OR species='halensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dolichus' AND (species='halensis' OR species='halensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dolichus' AND (junior_species='halensis' OR junior_species='halensis')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='Dolichus' AND (species='halensis' OR species='halensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='chalcentus' OR junior_species='chalcentus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Harpalus' AND (species='chalcentus' OR species='chalcentus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Harpalus' AND (species='chalcentus' OR species='chalcentus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='chalcentus' OR junior_species='chalcentus')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='Harpalus' AND (species='chalcentus' OR species='chalcentus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='sinicus' OR junior_species='sinicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Harpalus' AND (species='sinicus' OR species='sinicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Harpalus' AND (species='sinicus' OR species='sinicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='sinicus' OR junior_species='sinicus')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='Harpalus' AND (species='sinicus' OR species='sinicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nebria' AND (junior_species='chinensis' OR junior_species='chinensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nebria' AND (species='chinensis' OR species='chinensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nebria' AND (species='chinensis' OR species='chinensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nebria' AND (junior_species='chinensis' OR junior_species='chinensis')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='Nebria' AND (species='chinensis' OR species='chinensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nebria' AND (junior_species='coreica' OR junior_species='coreica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nebria' AND (species='coreica' OR species='coreica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nebria' AND (species='coreica' OR species='coreica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nebria' AND (junior_species='coreica' OR junior_species='coreica')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='Nebria' AND (species='coreica' OR species='coreica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='fortis' OR junior_species='fortis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterostichus' AND (species='fortis' OR species='fortis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterostichus' AND (species='fortis' OR species='fortis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='fortis' OR junior_species='fortis')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='Pterostichus' AND (species='fortis' OR species='fortis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synuchus' AND (junior_species='arcuaticollis' OR junior_species='arcuaticollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Synuchus' AND (species='arcuaticollis' OR species='arcuaticollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Synuchus' AND (species='arcuaticollis' OR species='arcuaticollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synuchus' AND (junior_species='arcuaticollis' OR junior_species='arcuaticollis')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='Synuchus' AND (species='arcuaticollis' OR species='arcuaticollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synuchus' AND (junior_species='cycloderus' OR junior_species='cycloderus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Synuchus' AND (species='cycloderus' OR species='cycloderus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Synuchus' AND (species='cycloderus' OR species='cycloderus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synuchus' AND (junior_species='cycloderus' OR junior_species='cycloderus')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='Synuchus' AND (species='cycloderus' OR species='cycloderus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synuchus' AND (junior_species='nitidus' OR junior_species='nitidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Synuchus' AND (species='nitidus' OR species='nitidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Synuchus' AND (species='nitidus' OR species='nitidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synuchus' AND (junior_species='nitidus' OR junior_species='nitidus')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='Synuchus' AND (species='nitidus' OR species='nitidus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1535 The Ecological Register: Naju City (native forest)
Naju City (native forest)
Basic information
Sample name: Naju City (native forest)

Reference: Y. Do and G. J. Joo. 2013. The effect of fragmentation and intensive management on carabid beetles in coniferous forest. Applied Ecology and Environmental Research 11(3):451-461 [ER 1036]
Geography
Country: South Korea


Coordinate: 35° 2' N, 126° 43' E
Coordinate basis: based on nearby landmark

Geography comments: coordinate based on Naju
elevation of sites is 127, 125, and 65 m

•
Environment
Habitat: temperate coniferous forest

Substrate: ground surface

Habitat comments: "dominated by Pinus densiflora"

Methods
Life forms: ground beetles

Sites: 3

Sampling methods: no design,pitfall traps

Sample size: 1058 individuals

Years: 2010

Nets or traps: 12

Sampling comments: "four pitfall traps (90 mm diameter, 100 mm deep plastic cups) at least 10 m apart in an irregular line at each study site... emptied on a monthly basis during one growing season (May to September 2010)"

Metadata
Sample number: 1535

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-05-14 20:17:04

Modified: 2015-05-14 10:21:49

Abundance distribution
15 species
0 singletons
total count 1058
extrapolated richness: 15.5
Fisher's α: 2.475
geometric series k: 0.7983
Hurlbert's PIE: 0.8979
Shannon's H: 2.4261
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
Anisodactylus punctatipennis140
Chlaenius bioculatus30
Chlaenius micans22
Chlaenius ocreatus21
Chlaenius pallipes7
Carabus jankowskii104
Dolichus halensis164
Harpalus chalcentus11
Harpalus sinicus23
Nebria chinensis49
Nebria coreica55
Pterostichus fortis89
Synuchus arcuaticollis84
Synuchus cycloderus116
Synuchus nitidus143