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=3671 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3671SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3298SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3671 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptoblepharus' AND (junior_species='plagiocephalus' OR junior_species='plagiocephalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cryptoblepharus' AND (species='plagiocephalus' OR species='plagiocephalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cryptoblepharus' AND (species='plagiocephalus' OR species='plagiocephalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptoblepharus' AND (junior_species='plagiocephalus' OR junior_species='plagiocephalus')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='Cryptoblepharus' AND (species='plagiocephalus' OR species='plagiocephalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenophorus' AND (junior_species='inermis' OR junior_species='inermis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ctenophorus' AND (species='inermis' OR species='inermis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ctenophorus' AND (species='inermis' OR species='inermis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenophorus' AND (junior_species='inermis' OR junior_species='inermis')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='Ctenophorus' AND (species='inermis' OR species='inermis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenotus' AND (junior_species='atlas' OR junior_species='atlas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ctenotus' AND (species='atlas' OR species='atlas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ctenotus' AND (species='atlas' OR species='atlas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenotus' AND (junior_species='atlas' OR junior_species='atlas')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='Ctenotus' AND (species='atlas' OR species='atlas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenotus' AND (junior_species='leonhardii' OR junior_species='leonhardi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ctenotus' AND (species='leonhardii' OR species='leonhardi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ctenotus' AND (species='leonhardii' OR species='leonhardi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenotus' AND (junior_species='leonhardii' OR junior_species='leonhardi')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='Ctenotus' AND (species='leonhardii' OR species='leonhardi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenotus' AND (junior_species='schomburgkii' OR junior_species='schomburgki')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ctenotus' AND (species='schomburgkii' OR species='schomburgki') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ctenotus' AND (species='schomburgkii' OR species='schomburgki')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ctenotus' AND (junior_species='schomburgkii' OR junior_species='schomburgki')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='Ctenotus' AND (species='schomburgkii' OR species='schomburgki') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplodactylus' AND (junior_species='granariensis' OR junior_species='granariensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diplodactylus' AND (species='granariensis' OR species='granariensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diplodactylus' AND (species='granariensis' OR species='granariensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplodactylus' AND (junior_species='granariensis' OR junior_species='granariensis')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='Diplodactylus' AND (species='granariensis' OR species='granariensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplodactylus' AND (junior_species='pulcher' OR junior_species='pulcher')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diplodactylus' AND (species='pulcher' OR species='pulcher') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diplodactylus' AND (species='pulcher' OR species='pulcher')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplodactylus' AND (junior_species='pulcher' OR junior_species='pulcher')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='Diplodactylus' AND (species='pulcher' OR species='pulcher') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplodactylus' AND (junior_species='squarrosus' OR junior_species='squarrosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diplodactylus' AND (species='squarrosus' OR species='squarrosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diplodactylus' AND (species='squarrosus' OR species='squarrosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplodactylus' AND (junior_species='squarrosus' OR junior_species='squarrosus')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='Diplodactylus' AND (species='squarrosus' OR species='squarrosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplodactylus' AND (junior_species='strophurus' OR junior_species='strophurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diplodactylus' AND (species='strophurus' OR species='strophurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diplodactylus' AND (species='strophurus' OR species='strophurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplodactylus' AND (junior_species='strophurus' OR junior_species='strophurus')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='Diplodactylus' AND (species='strophurus' OR species='strophurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Egernia' AND (junior_species='depressa' OR junior_species='depressa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Egernia' AND (species='depressa' OR species='depressa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Egernia' AND (species='depressa' OR species='depressa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Egernia' AND (junior_species='depressa' OR junior_species='depressa')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='depressa' OR species='depressa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Egernia' AND (junior_species='inornata' OR junior_species='inornata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Egernia' AND (species='inornata' OR species='inornata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Egernia' AND (species='inornata' OR species='inornata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Egernia' AND (junior_species='inornata' OR junior_species='inornata')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='inornata' OR species='inornata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gehyra' AND (junior_species='variegata' OR junior_species='variegata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gehyra' AND (species='variegata' OR species='variegata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gehyra' AND (species='variegata' OR species='variegata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gehyra' AND (junior_species='variegata' OR junior_species='variegata')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='Gehyra' AND (species='variegata' OR species='variegata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lerista' AND (junior_species='macropisthopus' OR junior_species='macropisthopus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lerista' AND (species='macropisthopus' OR species='macropisthopus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lerista' AND (species='macropisthopus' OR species='macropisthopus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lerista' AND (junior_species='macropisthopus' OR junior_species='macropisthopus')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='Lerista' AND (species='macropisthopus' OR species='macropisthopus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lerista' AND (junior_species='muelleri' OR junior_species='muellerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lerista' AND (species='muelleri' OR species='muellerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lerista' AND (species='muelleri' OR species='muellerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lerista' AND (junior_species='muelleri' OR junior_species='muellerii')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='Lerista' AND (species='muelleri' OR species='muellerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Menetia' AND (junior_species='greyii' OR junior_species='greyi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Menetia' AND (species='greyii' OR species='greyi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Menetia' AND (species='greyii' OR species='greyi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Menetia' AND (junior_species='greyii' OR junior_species='greyi')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='Menetia' AND (species='greyii' OR species='greyi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Moloch' AND (junior_species='horridus' OR junior_species='horridus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Moloch' AND (species='horridus' OR species='horridus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Moloch' AND (species='horridus' OR species='horridus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Moloch' AND (junior_species='horridus' OR junior_species='horridus')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='Moloch' AND (species='horridus' OR species='horridus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pogona' AND (junior_species='minor' OR junior_species='minor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pogona' AND (species='minor' OR species='minor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pogona' AND (species='minor' OR species='minor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pogona' AND (junior_species='minor' OR junior_species='minor')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='Pogona' AND (species='minor' OR species='minor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhynchoedura' AND (junior_species='ornata' OR junior_species='ornata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhynchoedura' AND (species='ornata' OR species='ornata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhynchoedura' AND (species='ornata' OR species='ornata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhynchoedura' AND (junior_species='ornata' OR junior_species='ornata')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='Rhynchoedura' AND (species='ornata' OR species='ornata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Varanus' AND (junior_species='caudolineatus' OR junior_species='caudolineatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Varanus' AND (species='caudolineatus' OR species='caudolineatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Varanus' AND (species='caudolineatus' OR species='caudolineatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Varanus' AND (junior_species='caudolineatus' OR junior_species='caudolineatus')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='Varanus' AND (species='caudolineatus' OR species='caudolineatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ramphotyphlops' AND (junior_species='hamatus' OR junior_species='hamatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ramphotyphlops' AND (species='hamatus' OR species='hamatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ramphotyphlops' AND (species='hamatus' OR species='hamatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ramphotyphlops' AND (junior_species='hamatus' OR junior_species='hamatus')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='Ramphotyphlops' AND (species='hamatus' OR species='hamatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vermicella' AND (junior_species='bertholdi' OR junior_species='bertholdii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vermicella' AND (species='bertholdi' OR species='bertholdii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vermicella' AND (species='bertholdi' OR species='bertholdii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vermicella' AND (junior_species='bertholdi' OR junior_species='bertholdii')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='Vermicella' AND (species='bertholdi' OR species='bertholdii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vermicella' AND (junior_species='semifasciata' OR junior_species='semifasciata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vermicella' AND (species='semifasciata' OR species='semifasciata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vermicella' AND (species='semifasciata' OR species='semifasciata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vermicella' AND (junior_species='semifasciata' OR junior_species='semifasciata')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='Vermicella' AND (species='semifasciata' OR species='semifasciata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sminthopsis' AND (junior_species='crassicaudata' OR junior_species='crassicaudata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sminthopsis' AND (species='crassicaudata' OR species='crassicaudata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sminthopsis' AND (species='crassicaudata' OR species='crassicaudata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sminthopsis' AND (junior_species='crassicaudata' OR junior_species='crassicaudata')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='Sminthopsis' AND (species='crassicaudata' OR species='crassicaudata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sminthopsis' AND (junior_species='youngsoni' OR junior_species='youngsonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sminthopsis' AND (species='youngsoni' OR species='youngsonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sminthopsis' AND (species='youngsoni' OR species='youngsonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sminthopsis' AND (junior_species='youngsoni' OR junior_species='youngsonii')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='Sminthopsis' AND (species='youngsoni' OR species='youngsonii') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3671 The Ecological Register: Atley Station
Atley Station
Basic information
Sample name: Atley Station

Reference: G. G. Thompson. 1996. A lizard and snake census on Atley Station. Western Australian Naturalist 21(1):59-63 [ER 3298]
Geography
Country: Australia

State: Western Australia


Coordinate: 28° 25' S, 119° 7' E
Coordinate basis: based on nearby landmark

Geography comments: "approximately 2 km East of Zado Bore... 55 km SW of Sandstone"
coordinate based on Atley Station

Environment
Habitat: desert/xeric shrubland

Protection: unprotected

Substrate: ground surface

Habitat comments: "red loamy soils which support a vegetation consisting mainly of patches of spinifex (Triodia sp.) grasses and small trees" predominantly being Acacia

Methods
Life forms: other small mammals,lizards,snakes

Sampling methods: pitfall traps

Sample size: 246 captures or sightings

Years: 1991

Days: 30

Nets or traps: 60

Sampling comments: "Sixty 20 litre plastic buckets were installed as pit-traps with 5 m of 300 mm high fly-wire drift-fencing between 22 and 25 November 1991... The pit-traps were laid in 10 rows of 6, with approximately 50 m between rows and 30 m between pit-traps in each row" and all captured surviving specimens were marked and released (not clear if the counts are of captures or individuals)
traps were inspected "from the 22 to 30 September and 24 November to 14 December 1991"

Metadata
Sample number: 3671

Contributor: John Alroy

Enterer: John Alroy

Created: 2020-06-08 20:02:48

Modified: 2020-06-08 10:02:48

Abundance distribution
24 species
5 singletons
total count 246
extrapolated richness: 38.2
Fisher's α: 6.579
geometric series k: 0.8219
Hurlbert's PIE: 0.8198
Shannon's H: 2.3054
Good's u: 0.9797
Each square represents a species. Square sizes are proportional to counts.
Register