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=1098 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1098SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=759SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1098 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macropygia' AND (junior_species='emiliana' OR junior_species='emiliana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macropygia' AND (species='emiliana' OR species='emiliana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macropygia' AND (species='emiliana' OR species='emiliana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macropygia' AND (junior_species='emiliana' OR junior_species='emiliana')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='Macropygia' AND (species='emiliana' OR species='emiliana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalcophaps' AND (junior_species='indica' OR junior_species='indica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chalcophaps' AND (species='indica' OR species='indica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chalcophaps' AND (species='indica' OR species='indica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalcophaps' AND (junior_species='indica' OR junior_species='indica')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='Chalcophaps' AND (species='indica' OR species='indica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceyx' AND (junior_species='rufidorsa' OR junior_species='rufidorsa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ceyx' AND (species='rufidorsa' OR species='rufidorsa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ceyx' AND (species='rufidorsa' OR species='rufidorsa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceyx' AND (junior_species='rufidorsa' OR junior_species='rufidorsa')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='Ceyx' AND (species='rufidorsa' OR species='rufidorsa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megalaima' AND (junior_species='javensis' OR junior_species='javensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megalaima' AND (species='javensis' OR species='javensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megalaima' AND (species='javensis' OR species='javensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megalaima' AND (junior_species='javensis' OR junior_species='javensis')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='Megalaima' AND (species='javensis' OR species='javensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pitta' AND (junior_species='guajana' OR junior_species='guajana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pitta' AND (species='guajana' OR species='guajana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pitta' AND (species='guajana' OR species='guajana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pitta' AND (junior_species='guajana' OR junior_species='guajana')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='Pitta' AND (species='guajana' OR species='guajana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alophoixus' AND (junior_species='bres' OR junior_species='bres')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alophoixus' AND (species='bres' OR species='bres') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alophoixus' AND (species='bres' OR species='bres')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alophoixus' AND (junior_species='bres' OR junior_species='bres')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='bres' OR species='bres') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pellorneum' AND (junior_species='capistratum' OR junior_species='capistratum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pellorneum' AND (species='capistratum' OR species='capistratum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pellorneum' AND (species='capistratum' OR species='capistratum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pellorneum' AND (junior_species='capistratum' OR junior_species='capistratum')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='capistratum' OR species='capistratum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pellorneum' AND (junior_species='pyrrogenys' OR junior_species='pyrrogenys')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pellorneum' AND (species='pyrrogenys' OR species='pyrrogenys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pellorneum' AND (species='pyrrogenys' OR species='pyrrogenys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pellorneum' AND (junior_species='pyrrogenys' OR junior_species='pyrrogenys')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='pyrrogenys' OR species='pyrrogenys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Malacocincla' AND (junior_species='sepiarium' OR junior_species='sepiarium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Malacocincla' AND (species='sepiarium' OR species='sepiarium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Malacocincla' AND (species='sepiarium' OR species='sepiarium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Malacocincla' AND (junior_species='sepiarium' OR junior_species='sepiarium')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='Malacocincla' AND (species='sepiarium' OR species='sepiarium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Malacopteron' AND (junior_species='cinereum' OR junior_species='cinereum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Malacopteron' AND (species='cinereum' OR species='cinereum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Malacopteron' AND (species='cinereum' OR species='cinereum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Malacopteron' AND (junior_species='cinereum' OR junior_species='cinereum')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='Malacopteron' AND (species='cinereum' OR species='cinereum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stachyris' AND (junior_species='grammiceps' OR junior_species='grammiceps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stachyris' AND (species='grammiceps' OR species='grammiceps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stachyris' AND (species='grammiceps' OR species='grammiceps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stachyris' AND (junior_species='grammiceps' OR junior_species='grammiceps')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='grammiceps' OR species='grammiceps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zoothera' AND (junior_species='sibirica' OR junior_species='sibirica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zoothera' AND (species='sibirica' OR species='sibirica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zoothera' AND (species='sibirica' OR species='sibirica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zoothera' AND (junior_species='sibirica' OR junior_species='sibirica')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='Zoothera' AND (species='sibirica' OR species='sibirica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypothymis' AND (junior_species='azurea' OR junior_species='azurea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypothymis' AND (species='azurea' OR species='azurea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypothymis' AND (species='azurea' OR species='azurea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypothymis' AND (junior_species='azurea' OR junior_species='azurea')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='Hypothymis' AND (species='azurea' OR species='azurea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nectarinia' AND (junior_species='sperata' OR junior_species='sperata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nectarinia' AND (species='sperata' OR species='sperata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nectarinia' AND (species='sperata' OR species='sperata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nectarinia' AND (junior_species='sperata' OR junior_species='sperata')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='Nectarinia' AND (species='sperata' OR species='sperata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aethopyga' AND (junior_species='mystacalis' OR junior_species='mystacalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aethopyga' AND (species='mystacalis' OR species='mystacalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aethopyga' AND (species='mystacalis' OR species='mystacalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aethopyga' AND (junior_species='mystacalis' OR junior_species='mystacalis')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='Aethopyga' AND (species='mystacalis' OR species='mystacalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acrachnothera' AND (junior_species='longirostra' OR junior_species='longirostra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acrachnothera' AND (species='longirostra' OR species='longirostra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acrachnothera' AND (species='longirostra' OR species='longirostra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acrachnothera' AND (junior_species='longirostra' OR junior_species='longirostra')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='Acrachnothera' AND (species='longirostra' OR species='longirostra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acrachnothera' AND (junior_species='affinis' OR junior_species='affinis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acrachnothera' AND (species='affinis' OR species='affinis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acrachnothera' AND (species='affinis' OR species='affinis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acrachnothera' AND (junior_species='affinis' OR junior_species='affinis')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='Acrachnothera' AND (species='affinis' OR species='affinis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prionochilus' AND (junior_species='percussus' OR junior_species='percussus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prionochilus' AND (species='percussus' OR species='percussus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prionochilus' AND (species='percussus' OR species='percussus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prionochilus' AND (junior_species='percussus' OR junior_species='percussus')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='Prionochilus' AND (species='percussus' OR species='percussus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicaeum' AND (junior_species='trigonostigma' OR junior_species='trigonostigma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dicaeum' AND (species='trigonostigma' OR species='trigonostigma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dicaeum' AND (species='trigonostigma' OR species='trigonostigma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicaeum' AND (junior_species='trigonostigma' OR junior_species='trigonostigma')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='Dicaeum' AND (species='trigonostigma' OR species='trigonostigma') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1098 The Ecological Register: Linggoasri (selectively logged)
Linggoasri (selectively logged)
Basic information
Sample name: Linggoasri (selectively logged)

Sample aka: Dieng Mountains

Reference: N. S. Sodhi, M. C. K. Soh, D. M. Prawiradilaga, . Darjono, and B. Brook. 2005. Persistence of lowland rainforest birds in a recently logged area in central Java. Bird Conservation International 15(2):173-191 [ER 759]
Geography
Country: Indonesia

State: Central Java


Coordinate: 7° 0' S, 109° 30' E
Coordinate basis: stated in text

Geography comments: "in the Dieng Mountains of central Java"

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Substrate: ground surface

Disturbance: selective logging

MAT: 26.0

MAP: 5500.0

Habitat comments: "sub-montane and montane forests" that was "selectively-logged"... at least 80 years" before
climate data are for the Dieng Mountains and are based on Nijman and van Balen (1998)

Methods
Life forms: birds

Sampling methods: mist nets

Sample size: 77 individuals

Years: 2002

Days: 10

Nets or traps: 11

Net or trap nights: 110

Sampling comments: sampling was with "10–12 mist-nets (2.5 × 12.0 m, 36 mm mesh) placed along trails. During each of five sampling periods, 1.5 days of mist- netting were conducted at a site" (interpreted as two days instead of 1.5 because a short day is a day)

Metadata
Sample number: 1098

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-08-25 20:20:14

Modified: 2014-08-25 10:20:14

Abundance distribution
19 species
9 singletons
total count 77
extrapolated richness: 48.9
Fisher's α: 8.065
geometric series k: 0.8294
Hurlbert's PIE: 0.8197
Shannon's H: 2.2800
Good's u: 0.8838
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Macropygia emiliana1
Chalcophaps indica14.9 g frugivore
Ceyx rufidorsa117.6 g
Megalaima javensis1115 g
Pitta guajana281.5 g
Alophoixus bres55.4 g insectivore-frugivore
Pellorneum capistratum325.1 g insectivore
Pellorneum pyrrogenys7
Malacocincla sepiarium2
Malacopteron cinereum518.1 g insectivore
Stachyris grammiceps29
Zoothera sibirica175.5 g insectivore
Hypothymis azurea111.1 g insectivore
Nectarinia sperata1 omnivore
Aethopyga mystacalis16.0 g
Acrachnothera longirostra8
Acrachnothera affinis1
Prionochilus percussus4 omnivore
Dicaeum trigonostigma37.1 g frugivore-nectarivore