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=1088 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1088SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=753SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1088 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sericornis' AND (junior_species='frontalis' OR junior_species='frontalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sericornis' AND (species='frontalis' OR species='frontalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sericornis' AND (species='frontalis' OR species='frontalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sericornis' AND (junior_species='frontalis' OR junior_species='frontalis')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='Sericornis' AND (species='frontalis' OR species='frontalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eopsaltria' AND (junior_species='georgiana' OR junior_species='georgiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eopsaltria' AND (species='georgiana' OR species='georgiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eopsaltria' AND (species='georgiana' OR species='georgiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eopsaltria' AND (junior_species='georgiana' OR junior_species='georgiana')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='Eopsaltria' AND (species='georgiana' OR species='georgiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Malurus' AND (junior_species='elegans' OR junior_species='elegans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Malurus' AND (species='elegans' OR species='elegans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Malurus' AND (species='elegans' OR species='elegans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Malurus' AND (junior_species='elegans' OR junior_species='elegans')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='Malurus' AND (species='elegans' OR species='elegans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acanthiza' AND (junior_species='apicalis' OR junior_species='apicalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acanthiza' AND (species='apicalis' OR species='apicalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acanthiza' AND (species='apicalis' OR species='apicalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acanthiza' AND (junior_species='apicalis' OR junior_species='apicalis')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='Acanthiza' AND (species='apicalis' OR species='apicalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycephala' AND (junior_species='pectoralis' OR junior_species='pectoralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachycephala' AND (species='pectoralis' OR species='pectoralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycephala' AND (species='pectoralis' OR species='pectoralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycephala' AND (junior_species='pectoralis' OR junior_species='pectoralis')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='pectoralis' OR species='pectoralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melithreptus' AND (junior_species='lunatus' OR junior_species='lunatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melithreptus' AND (species='lunatus' OR species='lunatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melithreptus' AND (species='lunatus' OR species='lunatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melithreptus' AND (junior_species='lunatus' OR junior_species='lunatus')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='Melithreptus' AND (species='lunatus' OR species='lunatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emblema' AND (junior_species='oculata' OR junior_species='oculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Emblema' AND (species='oculata' OR species='oculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Emblema' AND (species='oculata' OR species='oculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emblema' AND (junior_species='oculata' OR junior_species='oculata')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='Emblema' AND (species='oculata' OR species='oculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylidonyris' AND (junior_species='novaehollandiae' OR junior_species='novaehollandiae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phylidonyris' AND (species='novaehollandiae' OR species='novaehollandiae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phylidonyris' AND (species='novaehollandiae' OR species='novaehollandiae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylidonyris' AND (junior_species='novaehollandiae' OR junior_species='novaehollandiae')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='Phylidonyris' AND (species='novaehollandiae' OR species='novaehollandiae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colluricincla' AND (junior_species='harmonica' OR junior_species='harmonica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colluricincla' AND (species='harmonica' OR species='harmonica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colluricincla' AND (species='harmonica' OR species='harmonica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colluricincla' AND (junior_species='harmonica' OR junior_species='harmonica')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='Colluricincla' AND (species='harmonica' OR species='harmonica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coracina' AND (junior_species='novaehollandiae' OR junior_species='novaehollandiae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coracina' AND (species='novaehollandiae' OR species='novaehollandiae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coracina' AND (species='novaehollandiae' OR species='novaehollandiae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coracina' AND (junior_species='novaehollandiae' OR junior_species='novaehollandiae')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='Coracina' AND (species='novaehollandiae' OR species='novaehollandiae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pomatostomus' AND (junior_species='superciliosus' OR junior_species='superciliosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pomatostomus' AND (species='superciliosus' OR species='superciliosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pomatostomus' AND (species='superciliosus' OR species='superciliosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pomatostomus' AND (junior_species='superciliosus' OR junior_species='superciliosus')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='Pomatostomus' AND (species='superciliosus' OR species='superciliosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Petroica' AND (junior_species='multicolor' OR junior_species='multicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Petroica' AND (species='multicolor' OR species='multicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Petroica' AND (species='multicolor' OR species='multicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Petroica' AND (junior_species='multicolor' OR junior_species='multicolor')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='Petroica' AND (species='multicolor' OR species='multicolor') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1088
Reference:R. D. Wooller and A. V. Milewski. 1981. Site-fidelity in some birds of the understorey in Karri Forest. Emu81:171-173 [ER 753]
Geography
Country: Australia
State: Western Australia
Coordinate:-34.44° S, 116.05° E
Coordinate basis: based on nearby landmark
Geography comments: "along an overgrown track off House Brook Road in the Big Brook State Forest near Pemberton" (coordinate based on Pemberton)
•
Environment
Habitat: Mediterranean woodland
Protection: national/state forest
Substrate: ground surface
MAT: 15.5
WMT: 20.1
CMT: 11.5
MAP: 1179.0
Habitat comments: "Karri forest... fairly undisturbed by fire or logging for over forty years"
climate data are for Pemberton and are from Smettem et al. (2013)
Methods
Life forms: birds
Sampling methods: mist nets
Sample size: 72 individuals
Years: 1979
Days: 6
Nets or traps: 20
Net or trap nights: 120
Metadata
Sample number: 1088
Contributor: John Alroy
Enterer: John Alroy
Created: 2014-08-24 15:13:19
Modified: 2018-06-30 11:13:21
Abundance distribution
12 species
1 singleton
total count 72
extrapolated richness: 17.2
Fisher's α: 4.112
geometric series k: 0.7729
Hurlbert's PIE: 0.8705
Shannon's H: 2.2366
Good's u: 0.9869
Each square represents a species. Square sizes are proportional to counts.