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=1101 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1101SELECT 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=1101 ORDER BY register_no ASCSELECT 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='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='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=1101 The Ecological Register: Linggoasri (pine plantation)
Linggoasri (pine plantation)
Basic information
Sample name: Linggoasri (pine plantation)

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

Altered habitat: secondary forest

Substrate: ground surface

MAT: 26.0

MAP: 5500.0

Habitat comments: "sub-montane and montane forests" and specifically a plot of Pinus merkusii "planted in 1952"
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: 5 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: 1101

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-08-25 20:31:52

Modified: 2014-08-25 10:31:52

Abundance distribution
3 species
1 singleton
total count 5
extrapolated richness: 9.0
Fisher's α: 3.167
geometric series k: 0.7071
Hurlbert's PIE: 0.5500
Shannon's H: 1.0549
Good's u: 0.9000
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Malacocincla sepiarium2
Stachyris grammiceps2
Dicaeum trigonostigma17.1 g frugivore-nectarivore