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=1460 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1460SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=973SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1460 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alophoixus' AND (junior_species='pallidus' OR junior_species='pallidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alophoixus' AND (species='pallidus' OR species='pallidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alophoixus' AND (species='pallidus' OR species='pallidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alophoixus' AND (junior_species='pallidus' OR junior_species='pallidus')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='Alophoixus' AND (species='pallidus' OR species='pallidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abroscopus' AND (junior_species='superciliaris' OR junior_species='superciliaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Abroscopus' AND (species='superciliaris' OR species='superciliaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Abroscopus' AND (species='superciliaris' OR species='superciliaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abroscopus' AND (junior_species='superciliaris' OR junior_species='superciliaris')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='Abroscopus' AND (species='superciliaris' OR species='superciliaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthotomus' AND (junior_species='sutorius' OR junior_species='sutorius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthotomus' AND (species='sutorius' OR species='sutorius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthotomus' AND (species='sutorius' OR species='sutorius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthotomus' AND (junior_species='sutorius' OR junior_species='sutorius')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='Orthotomus' AND (species='sutorius' OR species='sutorius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macronous' AND (junior_species='gularis' OR junior_species='gularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macronous' AND (species='gularis' OR species='gularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macronous' AND (species='gularis' OR species='gularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macronous' AND (junior_species='gularis' OR junior_species='gularis')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='Macronous' AND (species='gularis' OR species='gularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Copsychus' AND (junior_species='malabaricus' OR junior_species='malabaricus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Copsychus' AND (species='malabaricus' OR species='malabaricus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Copsychus' AND (species='malabaricus' OR species='malabaricus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Copsychus' AND (junior_species='malabaricus' OR junior_species='malabaricus')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='Copsychus' AND (species='malabaricus' OR species='malabaricus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lonchura' AND (junior_species='striata' OR junior_species='striata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lonchura' AND (species='striata' OR species='striata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lonchura' AND (species='striata' OR species='striata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lonchura' AND (junior_species='striata' OR junior_species='striata')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='Lonchura' AND (species='striata' OR species='striata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sasia' AND (junior_species='ochracea' OR junior_species='ochracea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sasia' AND (species='ochracea' OR species='ochracea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sasia' AND (species='ochracea' OR species='ochracea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sasia' AND (junior_species='ochracea' OR junior_species='ochracea')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='Sasia' AND (species='ochracea' OR species='ochracea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alcedo' AND (junior_species='atthis' OR junior_species='atthis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alcedo' AND (species='atthis' OR species='atthis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alcedo' AND (species='atthis' OR species='atthis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alcedo' AND (junior_species='atthis' OR junior_species='atthis')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='Alcedo' AND (species='atthis' OR species='atthis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parus' AND (junior_species='major' OR junior_species='major')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parus' AND (species='major' OR species='major') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parus' AND (species='major' OR species='major')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parus' AND (junior_species='major' OR junior_species='major')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='Parus' AND (species='major' OR species='major') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Yuhina' AND (junior_species='zantholeuca' OR junior_species='zantholeuca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Yuhina' AND (species='zantholeuca' OR species='zantholeuca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Yuhina' AND (species='zantholeuca' OR species='zantholeuca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Yuhina' AND (junior_species='zantholeuca' OR junior_species='zantholeuca')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='Yuhina' AND (species='zantholeuca' OR species='zantholeuca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stachyris' AND (junior_species='nigriceps' OR junior_species='nigriceps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stachyris' AND (species='nigriceps' OR species='nigriceps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stachyris' AND (species='nigriceps' OR species='nigriceps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stachyris' AND (junior_species='nigriceps' OR junior_species='nigriceps')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='Stachyris' AND (species='nigriceps' OR species='nigriceps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stachyris' AND (junior_species='striolata' OR junior_species='striolata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stachyris' AND (species='striolata' OR species='striolata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stachyris' AND (species='striolata' OR species='striolata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stachyris' AND (junior_species='striolata' OR junior_species='striolata')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='Stachyris' AND (species='striolata' OR species='striolata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pellorneum' AND (junior_species='tickelli' OR junior_species='tickellii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pellorneum' AND (species='tickelli' OR species='tickellii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pellorneum' AND (species='tickelli' OR species='tickellii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pellorneum' AND (junior_species='tickelli' OR junior_species='tickellii')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='Pellorneum' AND (species='tickelli' OR species='tickellii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pellorneum' AND (junior_species='ruficeps' OR junior_species='ruficeps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pellorneum' AND (species='ruficeps' OR species='ruficeps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pellorneum' AND (species='ruficeps' OR species='ruficeps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pellorneum' AND (junior_species='ruficeps' OR junior_species='ruficeps')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='Pellorneum' AND (species='ruficeps' OR species='ruficeps') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1460 The Ecological Register: Bo Lu
Bo Lu
Basic information
Sample name: Bo Lu

Sample aka: Ba Be National Park

Reference: O. Sychra, I. Literák, M. H. Nguyen, and P. Podzemny. 2009. Chewing lice from wild passerines (Aves, Passeriformes) from Vietnam, with description of a new species of the genus Brueelia (Phthiraptera, Ischnocera, Philopteridae). Acta Parasitologica 54(2):154-157 [ER 973]
Geography
Country: Vietnam


Coordinate: 22° 23' N, 105° 37' E
Coordinate basis: stated in text

Geography comments: "within the Ba Be National Park... close to Ba Be Lake"

Environment
Habitat: tropical/subtropical moist broadleaf forest

Protection: national/state park

Substrate: ground surface

MAT: 22.0

MAP: 1300.0

Habitat comments: "limestone and evergreen forests"
climate data are for Ba Be National Park (sample 650) and are from Hayes et al. (2009)

Methods
Life forms: birds

Sampling methods: line transect,no design,mist nets

Sample size: 45 individuals

Years: 2008

Days: 9

Seasons: wet or monsoon

Sampling comments: "A line of about 100 m of mist nets was erected" (number of nets not stated)

Metadata
Sample number: 1460

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-03-02 20:48:04

Modified: 2018-04-21 00:44:46

Abundance distribution
14 species
4 singletons
total count 45
extrapolated richness: 28.6
Fisher's α: 6.967
geometric series k: 0.8610
Hurlbert's PIE: 0.8934
Shannon's H: 2.4139
Good's u: 0.9150
Each square represents a species. Square sizes are proportional to counts.
Register