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=1692 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1692SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1165SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1692 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Accipiter' AND (junior_species='trinotatus' OR junior_species='trinotatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Accipiter' AND (species='trinotatus' OR species='trinotatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Accipiter' AND (species='trinotatus' OR species='trinotatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Accipiter' AND (junior_species='trinotatus' OR junior_species='trinotatus')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='Accipiter' AND (species='trinotatus' OR species='trinotatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cacomantis' AND (junior_species='sepulcralis' OR junior_species='sepulcralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cacomantis' AND (species='sepulcralis' OR species='sepulcralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cacomantis' AND (species='sepulcralis' OR species='sepulcralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cacomantis' AND (junior_species='sepulcralis' OR junior_species='sepulcralis')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='Cacomantis' AND (species='sepulcralis' OR species='sepulcralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceyx' AND (junior_species='fallax' OR junior_species='fallax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ceyx' AND (species='fallax' OR species='fallax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ceyx' AND (species='fallax' OR species='fallax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceyx' AND (junior_species='fallax' OR junior_species='fallax')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='fallax' OR species='fallax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichastoma' AND (junior_species='celebense' OR junior_species='celebense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trichastoma' AND (species='celebense' OR species='celebense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trichastoma' AND (species='celebense' OR species='celebense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichastoma' AND (junior_species='celebense' OR junior_species='celebense')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='Trichastoma' AND (species='celebense' OR species='celebense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficedula' AND (junior_species='rufigula' OR junior_species='rufigula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ficedula' AND (species='rufigula' OR species='rufigula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ficedula' AND (species='rufigula' OR species='rufigula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficedula' AND (junior_species='rufigula' OR junior_species='rufigula')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='Ficedula' AND (species='rufigula' OR species='rufigula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyornis' AND (junior_species='rufigastra' OR junior_species='rufigastra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyornis' AND (species='rufigastra' OR species='rufigastra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyornis' AND (species='rufigastra' OR species='rufigastra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyornis' AND (junior_species='rufigastra' OR junior_species='rufigastra')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='Cyornis' AND (species='rufigastra' OR species='rufigastra') 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='Culicicapa' AND (junior_species='helianthea' OR junior_species='helianthea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culicicapa' AND (species='helianthea' OR species='helianthea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culicicapa' AND (species='helianthea' OR species='helianthea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culicicapa' AND (junior_species='helianthea' OR junior_species='helianthea')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='Culicicapa' AND (species='helianthea' OR species='helianthea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycephala' AND (junior_species='sulfuriventer' OR junior_species='sulfuriventer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachycephala' AND (species='sulfuriventer' OR species='sulfuriventer') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycephala' AND (species='sulfuriventer' OR species='sulfuriventer')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycephala' AND (junior_species='sulfuriventer' OR junior_species='sulfuriventer')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='Pachycephala' AND (species='sulfuriventer' OR species='sulfuriventer') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthreptes' AND (junior_species='malacensis' OR junior_species='malacensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthreptes' AND (species='malacensis' OR species='malacensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthreptes' AND (species='malacensis' OR species='malacensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthreptes' AND (junior_species='malacensis' OR junior_species='malacensis')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='Anthreptes' AND (species='malacensis' OR species='malacensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aethopyga' AND (junior_species='siparaja' OR junior_species='siparaja')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aethopyga' AND (species='siparaja' OR species='siparaja') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aethopyga' AND (species='siparaja' OR species='siparaja')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aethopyga' AND (junior_species='siparaja' OR junior_species='siparaja')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='siparaja' OR species='siparaja') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicaeum' AND (junior_species='aureolimbatum' OR junior_species='aureolimbatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dicaeum' AND (species='aureolimbatum' OR species='aureolimbatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dicaeum' AND (species='aureolimbatum' OR species='aureolimbatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicaeum' AND (junior_species='aureolimbatum' OR junior_species='aureolimbatum')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='aureolimbatum' OR species='aureolimbatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicaeum' AND (junior_species='celebicum' OR junior_species='celebicum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dicaeum' AND (species='celebicum' OR species='celebicum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dicaeum' AND (species='celebicum' OR species='celebicum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicaeum' AND (junior_species='celebicum' OR junior_species='celebicum')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='celebicum' OR species='celebicum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zosterops' AND (junior_species='atrifrons' OR junior_species='atrifrons')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zosterops' AND (species='atrifrons' OR species='atrifrons') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zosterops' AND (species='atrifrons' OR species='atrifrons')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zosterops' AND (junior_species='atrifrons' OR junior_species='atrifrons')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='Zosterops' AND (species='atrifrons' OR species='atrifrons') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1692 The Ecological Register: Palolo Valley (forest garden, 2000 and 2001)
Palolo Valley (forest garden, 2000 and 2001)
Basic information
Sample name: Palolo Valley (forest garden, 2000 and 2001)

Sample aka: Lore Lindu National Park

Reference: M. Waltert, A. Mardiastuti, and M. Mühlenberg. 2005. Effects of deforestation and forest modification on understorey birds in Central Sulawesi, Indonesia. Bird Conservation International 15(3):257-273 [ER 1165]
Geography
Country: Indonesia

State: Central Sulawesi


Coordinate: 1° 12' S, 120° 8' E
Coordinate basis: stated in text

Geography comments: "near Kamarora Field Station at the forest border"

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Altered habitat: secondary forest

Protection: national/state park

Substrate: ground surface

Disturbance: agriculture

MAT: 24.5

MAP: 1970.0

Habitat comments: "a mosaic of old small-scale subsistence farms, recently abandoned farms and regenerating secondary forest... upper and middle layers of the forest were largely intact"
there is no nearby climate station; climate data are based on Falk et al. (2005, Meteorologische Zeitschrift) who report on a quite nearby location

Methods
Life forms: birds

Sampling methods: quadrat,mist nets

Sample size: 80 individuals

Years: 2000, 2001

Net or trap nights: 68

Sampling comments: "A combination of 6- and 12-m-long mist-nets, 2.7 m high with 16 mm mesh, was used to produce a single 102-m net-line for which narrow trails were cut in the understorey. Net trails were positioned on a systematic grid, using a spacing of 100 m, with trails being parallel to each other... The whole net line was then moved to another net trail, 100 m away within each 16 ha study site, resulting in a total of eight 102-m lines per study site and 40 (8 × 5 study sites) in total. The sampling effort amounted to c. 680 net-hours for each study site" and there were 10 net-hours per day

Metadata
Sample number: 1692

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-07-07 15:44:50

Modified: 2015-07-07 08:00:54

Abundance distribution
14 species
3 singletons
total count 80
extrapolated richness: 25.2
Fisher's α: 4.913
geometric series k: 0.7761
Hurlbert's PIE: 0.8212
Shannon's H: 2.1006
Good's u: 0.9637
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Accipiter trinotatus2146 g
Cacomantis sepulcralis1 insectivore
Ceyx fallax1318.0 g
Trichastoma celebense2723.6 g
Ficedula rufigula1111.6 g
Cyornis rufigastra718.3 g
Hypothymis azurea511.1 g insectivore
Culicicapa helianthea28.4 g
Pachycephala sulfuriventer321.4 g
Anthreptes malacensis212.0 g frugivore-nectarivore
Aethopyga siparaja16.7 g insectivore
Dicaeum aureolimbatum38.1 g
Dicaeum celebicum16.5 g
Zosterops atrifrons210.0 g