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=2899 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2899SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2732SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2899 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alcedo' 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='Alcedo' AND (species='azurea' OR species='azurea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alcedo' AND (species='azurea' OR species='azurea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alcedo' 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='Alcedo' AND (species='azurea' OR species='azurea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Climacteris' AND (junior_species='picumnus' OR junior_species='picumnus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Climacteris' AND (species='picumnus' OR species='picumnus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Climacteris' AND (species='picumnus' OR species='picumnus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Climacteris' AND (junior_species='picumnus' OR junior_species='picumnus')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='Climacteris' AND (species='picumnus' OR species='picumnus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Malurus' AND (junior_species='cyaneus' OR junior_species='cyaneus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Malurus' AND (species='cyaneus' OR species='cyaneus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Malurus' AND (species='cyaneus' OR species='cyaneus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Malurus' AND (junior_species='cyaneus' OR junior_species='cyaneus')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='cyaneus' OR species='cyaneus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pardalotus' AND (junior_species='punctatus' OR junior_species='punctatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pardalotus' AND (species='punctatus' OR species='punctatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pardalotus' AND (species='punctatus' OR species='punctatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pardalotus' AND (junior_species='punctatus' OR junior_species='punctatus')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='Pardalotus' AND (species='punctatus' OR species='punctatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrrholaemus' AND (junior_species='sagittatus' OR junior_species='sagittatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyrrholaemus' AND (species='sagittatus' OR species='sagittatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyrrholaemus' AND (species='sagittatus' OR species='sagittatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrrholaemus' AND (junior_species='sagittatus' OR junior_species='sagittatus')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='Pyrrholaemus' AND (species='sagittatus' OR species='sagittatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptilotula' AND (junior_species='fusca' OR junior_species='fusca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ptilotula' AND (species='fusca' OR species='fusca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ptilotula' AND (species='fusca' OR species='fusca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptilotula' AND (junior_species='fusca' OR junior_species='fusca')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='Ptilotula' AND (species='fusca' OR species='fusca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eopsaltria' AND (junior_species='australis' OR junior_species='australis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eopsaltria' AND (species='australis' OR species='australis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eopsaltria' AND (species='australis' OR species='australis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eopsaltria' AND (junior_species='australis' OR junior_species='australis')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='australis' OR species='australis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhipidura' AND (junior_species='leucophrys' OR junior_species='leucophrys')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhipidura' AND (species='leucophrys' OR species='leucophrys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhipidura' AND (species='leucophrys' OR species='leucophrys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhipidura' AND (junior_species='leucophrys' OR junior_species='leucophrys')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='leucophrys' OR species='leucophrys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neochmia' AND (junior_species='temporalis' OR junior_species='temporalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neochmia' AND (species='temporalis' OR species='temporalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neochmia' AND (species='temporalis' OR species='temporalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neochmia' AND (junior_species='temporalis' OR junior_species='temporalis')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='Neochmia' AND (species='temporalis' OR species='temporalis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2899 The Ecological Register: Longneck Lagoon Nature Reserve (1965)
Longneck Lagoon Nature Reserve (1965)
Basic information
Sample name: Longneck Lagoon Nature Reserve (1965)

Reference: K. H. Egan, J. R. Farrell, and D. L. Pepper-Edwards. 1997. Historical and seasonal changes in the community of forest birds at Longneck Lagoon Nature Reserve, Scheyville, New South Wales. Corella 21(1):1-16 [ER 2732]
Geography
Country: Australia

State: New South Wales


Coordinate: 33° 36' S, 150° 54' E
Coordinate basis: stated in text

Geography comments: "7 km ENE of Windsor on the north-western edge of the Cumberland Plain"
elevation 10 to 40 m

•
Environment
Habitat: tropical/subtropical dry broadleaf forest

Altered habitat: fragment

Protection: nature reserve

Substrate: ground surface

WMT: 26.9

CMT: 16.4

MAP: 805.0

Habitat comments: "a remnant area of Grey Box-Ironbark Woodland"
sampling was at four points in two fragments, each under 1 km2
climate data are for the Richmond area and are from Anderson and Burgin (2002, Austral Ecology)

Methods
Life forms: birds

Sampling methods: no design,mist nets

Sample size: 23 individuals

Years: 1965

Sampling comments: "no details were kept on the number of nes set during each visit and for how long they were erected"

Metadata
Sample number: 2899

Contributor: John Alroy

Enterer: John Alroy

Created: 2018-04-22 10:20:49

Modified: 2018-04-22 00:20:49

Abundance distribution
9 species
3 singletons
total count 23
extrapolated richness: 22.3
Fisher's α: 5.443
geometric series k: 0.7711
Hurlbert's PIE: 0.8043
Shannon's H: 1.9300
Good's u: 0.8837
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Alcedo azurea134.9 g invertivore-carnivore
Climacteris picumnus25.4 g insectivore
Malurus cyaneus23.0 g insectivore
Pardalotus punctatus48.7 g insectivore
Pyrrholaemus sagittatus213.7 g
"Chthonicola sagittata"
Ptilotula fusca8
"Lichenostomus fuscus"
Eopsaltria australis222.2 g insectivore
Rhipidura leucophrys13.3 g insectivore
Neochmia temporalis111.4 g granivore