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=371 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=371SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=168SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=371 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litoria' AND (junior_species='aurea' OR junior_species='aurea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Litoria' AND (species='aurea' OR species='aurea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Litoria' AND (species='aurea' OR species='aurea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litoria' AND (junior_species='aurea' OR junior_species='aurea')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='Litoria' AND (species='aurea' OR species='aurea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnodynastes' AND (junior_species='peronii' OR junior_species='peroni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Limnodynastes' AND (species='peronii' OR species='peroni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Limnodynastes' AND (species='peronii' OR species='peroni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnodynastes' AND (junior_species='peronii' OR junior_species='peroni')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='Limnodynastes' AND (species='peronii' OR species='peroni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnodynastes' AND (junior_species='tasmaniensis' OR junior_species='tasmaniensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Limnodynastes' AND (species='tasmaniensis' OR species='tasmaniensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Limnodynastes' AND (species='tasmaniensis' OR species='tasmaniensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnodynastes' AND (junior_species='tasmaniensis' OR junior_species='tasmaniensis')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='Limnodynastes' AND (species='tasmaniensis' OR species='tasmaniensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litoria' AND (junior_species='peronii' OR junior_species='peroni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Litoria' AND (species='peronii' OR species='peroni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Litoria' AND (species='peronii' OR species='peroni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litoria' AND (junior_species='peronii' OR junior_species='peroni')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='Litoria' AND (species='peronii' OR species='peroni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crinia' AND (junior_species='signifera' OR junior_species='signifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crinia' AND (species='signifera' OR species='signifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crinia' AND (species='signifera' OR species='signifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crinia' AND (junior_species='signifera' OR junior_species='signifera')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='Crinia' AND (species='signifera' OR species='signifera') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=371 The Ecological Register: Lake Domis
Lake Domis
Basic information
Sample name: Lake Domis

Sample aka: Homebush Bay

Reference: G. H. Pyke and A. W. White. 1999. Dynamics of co-occurring frog species in three ponds utilized by the endangered Green and Golden Bell Frog Litoria aurea. Australian Zoologist 31(1):230-239 [ER 168]
Geography
Country: Australia

State: New South Wales


Coordinate: 33° 51' S, 151° 4' E
Coordinate basis: based on nearby landmark

Geography comments: coordinate based on Homebush Bay

Environment
Habitat: temperate wetland

Protection: unprotected

Substrate: water edge

WMT: 22.9

CMT: 12.7

MAP: 1152.0

Habitat comments: climate data based on station 94767 (Sydney airport)

Methods
Life forms: frogs

Sampling methods: hand capture

Sample size: 774 individuals

Years: 1993 - 1996

Metadata
Sample number: 371

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-14 09:43:53

Modified: 2020-01-14 04:39:25

Abundance distribution
5 species
0 singletons
total count 774
extrapolated richness: 5.1
Fisher's α: 0.716
geometric series k: 0.4507
Hurlbert's PIE: 0.7099
Shannon's H: 1.3471
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.
Register