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=506 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=506SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=249SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=506 ORDER BY register_no ASCSELECT 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 senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litoria' AND (junior_species='lesueurii' OR junior_species='lesueuri')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Litoria' AND (species='lesueurii' OR species='lesueuri') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Litoria' AND (species='lesueurii' OR species='lesueuri')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litoria' AND (junior_species='lesueurii' OR junior_species='lesueuri')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='lesueurii' OR species='lesueuri') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Niveoscincus' AND (junior_species='coventryi' OR junior_species='coventryii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Niveoscincus' AND (species='coventryi' OR species='coventryii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Niveoscincus' AND (species='coventryi' OR species='coventryii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Niveoscincus' AND (junior_species='coventryi' OR junior_species='coventryii')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='Niveoscincus' AND (species='coventryi' OR species='coventryii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nannoscincus' AND (junior_species='maccoyi' OR junior_species='maccoyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nannoscincus' AND (species='maccoyi' OR species='maccoyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nannoscincus' AND (species='maccoyi' OR species='maccoyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nannoscincus' AND (junior_species='maccoyi' OR junior_species='maccoyii')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='Nannoscincus' AND (species='maccoyi' OR species='maccoyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eulamprus' AND (junior_species='tympanum' OR junior_species='tympanum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eulamprus' AND (species='tympanum' OR species='tympanum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eulamprus' AND (species='tympanum' OR species='tympanum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eulamprus' AND (junior_species='tympanum' OR junior_species='tympanum')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='Eulamprus' AND (species='tympanum' OR species='tympanum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudemoia' AND (junior_species='spenceri' OR junior_species='spencerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudemoia' AND (species='spenceri' OR species='spencerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudemoia' AND (species='spenceri' OR species='spencerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudemoia' AND (junior_species='spenceri' OR junior_species='spencerii')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='Pseudemoia' AND (species='spenceri' OR species='spencerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eulamprus' AND (junior_species='heatwolei' OR junior_species='heatwoleii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eulamprus' AND (species='heatwolei' OR species='heatwoleii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eulamprus' AND (species='heatwolei' OR species='heatwoleii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eulamprus' AND (junior_species='heatwolei' OR junior_species='heatwoleii')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='Eulamprus' AND (species='heatwolei' OR species='heatwoleii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lampropholis' AND (junior_species='guichenoti' OR junior_species='guichenotii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lampropholis' AND (species='guichenoti' OR species='guichenotii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lampropholis' AND (species='guichenoti' OR species='guichenotii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lampropholis' AND (junior_species='guichenoti' OR junior_species='guichenotii')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='Lampropholis' AND (species='guichenoti' OR species='guichenotii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saproscincus' AND (junior_species='mustelina' OR junior_species='mustelina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Saproscincus' AND (species='mustelina' OR species='mustelina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Saproscincus' AND (species='mustelina' OR species='mustelina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saproscincus' AND (junior_species='mustelina' OR junior_species='mustelina')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='Saproscincus' AND (species='mustelina' OR species='mustelina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudemoia' AND (junior_species='entrecasteauxii' OR junior_species='entrecasteauxi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudemoia' AND (species='entrecasteauxii' OR species='entrecasteauxi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudemoia' AND (species='entrecasteauxii' OR species='entrecasteauxi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudemoia' AND (junior_species='entrecasteauxii' OR junior_species='entrecasteauxi')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='Pseudemoia' AND (species='entrecasteauxii' OR species='entrecasteauxi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lampropholis' AND (junior_species='delicata' OR junior_species='delicata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lampropholis' AND (species='delicata' OR species='delicata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lampropholis' AND (species='delicata' OR species='delicata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lampropholis' AND (junior_species='delicata' OR junior_species='delicata')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='Lampropholis' AND (species='delicata' OR species='delicata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Egernia' AND (junior_species='saxatilis' OR junior_species='saxatilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Egernia' AND (species='saxatilis' OR species='saxatilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Egernia' AND (species='saxatilis' OR species='saxatilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Egernia' AND (junior_species='saxatilis' OR junior_species='saxatilis')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='Egernia' AND (species='saxatilis' OR species='saxatilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemiergis' AND (junior_species='decresiensis' OR junior_species='decresiensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemiergis' AND (species='decresiensis' OR species='decresiensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemiergis' AND (species='decresiensis' OR species='decresiensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemiergis' AND (junior_species='decresiensis' OR junior_species='decresiensis')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='Hemiergis' AND (species='decresiensis' OR species='decresiensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tiliqua' AND (junior_species='nigrolutea' OR junior_species='nigrolutea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tiliqua' AND (species='nigrolutea' OR species='nigrolutea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tiliqua' AND (species='nigrolutea' OR species='nigrolutea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tiliqua' AND (junior_species='nigrolutea' OR junior_species='nigrolutea')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='Tiliqua' AND (species='nigrolutea' OR species='nigrolutea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Austrelaps' AND (junior_species='ramsayi' OR junior_species='ramsayii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Austrelaps' AND (species='ramsayi' OR species='ramsayii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Austrelaps' AND (species='ramsayi' OR species='ramsayii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Austrelaps' AND (junior_species='ramsayi' OR junior_species='ramsayii')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='Austrelaps' AND (species='ramsayi' OR species='ramsayii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudonaja' AND (junior_species='textilis' OR junior_species='textilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudonaja' AND (species='textilis' OR species='textilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudonaja' AND (species='textilis' OR species='textilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudonaja' AND (junior_species='textilis' OR junior_species='textilis')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='Pseudonaja' AND (species='textilis' OR species='textilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinoplocephalus' AND (junior_species='nigrescens' OR junior_species='nigrescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinoplocephalus' AND (species='nigrescens' OR species='nigrescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhinoplocephalus' AND (species='nigrescens' OR species='nigrescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinoplocephalus' AND (junior_species='nigrescens' OR junior_species='nigrescens')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='Rhinoplocephalus' AND (species='nigrescens' OR species='nigrescens') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=506 The Ecological Register: Queanbeyan
Queanbeyan
Basic information
Sample name: Queanbeyan

Reference: R. Goldingay, G. Daly, and F. Lemckert. 1996. Assessing the impacts of logging on reptiles and frogs in the montane forests of southern New South Wales. Wildlife Research 23:495-510 [ER 249]
Geography
Country: Australia

State: New South Wales


Coordinate: 35° 47' S, 149° 38' E
Coordinate basis: stated in text

Geography comments: Tallaganda, Badja, Bendoura, and Berlang State Forests
coordinate is the midpoint of the four reported ones
elevation 700 - 1200 m

Environment
Habitat: tropical/subtropical dry broadleaf forest

Protection: national/state forest

Substrate: ground surface

Disturbance: selective logging

WMT: 20.0

CMT: 6.2

MAP: 1200.0

Habitat comments: "moist forest, dry forest, and non-commercial forest" (all dominated by Eucalyptus)
CMT and WMT based on climate station 94926 (Canberra airport), which is at a similar altitude but has lower MAP

Methods
Life forms: lizards,snakes,frogs

Sites: 20

Site area: 30

Sampling methods: belt transect,quadrat

Sample size: 785 individuals

Years: 1993

Sampling comments: 20 500 x 30 m transects

Metadata
Sample number: 506

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-20 21:08:58

Modified: 2018-06-30 11:12:04

Abundance distribution
17 species
6 singletons
total count 785
extrapolated richness: 28.5
Fisher's α: 3.063
geometric series k: 0.7197
Hurlbert's PIE: 0.8354
Shannon's H: 2.0119
Good's u: 0.9924
Each square represents a species. Square sizes are proportional to counts.
Register