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=1089 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1089SELECT 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=1089 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='Zosterops' AND (junior_species='lateralis' OR junior_species='lateralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zosterops' AND (species='lateralis' OR species='lateralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zosterops' AND (species='lateralis' OR species='lateralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zosterops' AND (junior_species='lateralis' OR junior_species='lateralis')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='lateralis' OR species='lateralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthochaera' AND (junior_species='carunculata' OR junior_species='carunculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthochaera' AND (species='carunculata' OR species='carunculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthochaera' AND (species='carunculata' OR species='carunculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthochaera' AND (junior_species='carunculata' OR junior_species='carunculata')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='Anthochaera' AND (species='carunculata' OR species='carunculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhipidura' AND (junior_species='fuliginosa' OR junior_species='fuliginosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhipidura' AND (species='fuliginosa' OR species='fuliginosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhipidura' AND (species='fuliginosa' OR species='fuliginosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhipidura' AND (junior_species='fuliginosa' OR junior_species='fuliginosa')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='Rhipidura' AND (species='fuliginosa' OR species='fuliginosa') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1089
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: 128 individuals
Years: 1980
Days: 6
Nets or traps: 20
Net or trap nights: 120
Metadata
Sample number: 1089
Contributor: John Alroy
Enterer: John Alroy
Created: 2014-08-24 15:15:59
Modified: 2018-06-30 11:13:32
Abundance distribution
12 species
4 singletons
total count 128
extrapolated richness: 19.9
Fisher's α: 3.243
geometric series k: 0.7318
Hurlbert's PIE: 0.8552
Shannon's H: 2.0825
Good's u: 0.9688
Each square represents a species. Square sizes are proportional to counts.