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=3255 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3255SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3021SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3255 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notamacropus' AND (junior_species='agilis' OR junior_species='agilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Notamacropus' AND (species='agilis' OR species='agilis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notamacropus' AND (junior_species='agilis' OR junior_species='agilis')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='Notamacropus' AND (species='agilis' OR species='agilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bos' AND (junior_species='taurus' OR junior_species='taurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bos' AND (species='taurus' OR species='taurus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bos' AND (junior_species='taurus' OR junior_species='taurus')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='Bos' AND (species='taurus' OR species='taurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macrotis' AND (junior_species='lagotis' OR junior_species='lagotis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macrotis' AND (species='lagotis' OR species='lagotis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macrotis' AND (species='lagotis' OR species='lagotis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macrotis' AND (junior_species='lagotis' OR junior_species='lagotis')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='Macrotis' AND (species='lagotis' OR species='lagotis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Felis' AND (junior_species='catus' OR junior_species='catus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Felis' AND (species='catus' OR species='catus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Felis' AND (species='catus' OR species='catus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Felis' AND (junior_species='catus' OR junior_species='catus')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='Felis' AND (species='catus' OR species='catus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='lupus' OR junior_species='lupus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canis' AND (species='lupus' OR species='lupus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='lupus' OR junior_species='lupus')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='Canis' AND (species='lupus' OR species='lupus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lagorchestes' AND (junior_species='conspicillatus' OR junior_species='conspicillatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lagorchestes' AND (species='conspicillatus' OR species='conspicillatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lagorchestes' AND (species='conspicillatus' OR species='conspicillatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lagorchestes' AND (junior_species='conspicillatus' OR junior_species='conspicillatus')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='Lagorchestes' AND (species='conspicillatus' OR species='conspicillatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onychogalea' AND (junior_species='unguifera' OR junior_species='unguifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onychogalea' AND (species='unguifera' OR species='unguifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onychogalea' AND (species='unguifera' OR species='unguifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onychogalea' AND (junior_species='unguifera' OR junior_species='unguifera')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='Onychogalea' AND (species='unguifera' OR species='unguifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Osphranter' AND (junior_species='rufus' OR junior_species='rufus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Osphranter' AND (species='rufus' OR species='rufus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Osphranter' AND (junior_species='rufus' OR junior_species='rufus')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='Osphranter' AND (species='rufus' OR species='rufus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichosurus' AND (junior_species='vulpecula' OR junior_species='vulpecula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trichosurus' AND (species='vulpecula' OR species='vulpecula') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichosurus' AND (junior_species='vulpecula' OR junior_species='vulpecula')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='Trichosurus' AND (species='vulpecula' OR species='vulpecula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Grallina' AND (junior_species='cyanoleuca' OR junior_species='cyanoleuca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Grallina' AND (species='cyanoleuca' OR species='cyanoleuca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Grallina' AND (species='cyanoleuca' OR species='cyanoleuca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Grallina' AND (junior_species='cyanoleuca' OR junior_species='cyanoleuca')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='Grallina' AND (species='cyanoleuca' OR species='cyanoleuca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocyphaps' AND (junior_species='lophotes' OR junior_species='lophotes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ocyphaps' AND (species='lophotes' OR species='lophotes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ocyphaps' AND (species='lophotes' OR species='lophotes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocyphaps' AND (junior_species='lophotes' OR junior_species='lophotes')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='Ocyphaps' AND (species='lophotes' OR species='lophotes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geopelia' AND (junior_species='placida' OR junior_species='placida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Geopelia' AND (species='placida' OR species='placida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Geopelia' AND (species='placida' OR species='placida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geopelia' AND (junior_species='placida' OR junior_species='placida')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='Geopelia' AND (species='placida' OR species='placida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corvus' AND (junior_species='spp.' OR junior_species='spp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Corvus' AND (species='spp.' OR species='spp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Corvus' AND (species='spp.' OR species='spp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corvus' AND (junior_species='spp.' OR junior_species='spp.')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='Corvus' AND (species='spp.' OR species='spp.') 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='Ardeotis' 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='Ardeotis' AND (species='australis' OR species='australis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ardeotis' AND (species='australis' OR species='australis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ardeotis' 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='Ardeotis' AND (species='australis' OR species='australis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pomatostomus' 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='Pomatostomus' AND (species='temporalis' OR species='temporalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pomatostomus' AND (species='temporalis' OR species='temporalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pomatostomus' 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='Pomatostomus' AND (species='temporalis' OR species='temporalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cracticus' AND (junior_species='nigrogularis' OR junior_species='nigrogularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cracticus' AND (species='nigrogularis' OR species='nigrogularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cracticus' AND (species='nigrogularis' OR species='nigrogularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cracticus' AND (junior_species='nigrogularis' OR junior_species='nigrogularis')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='Cracticus' AND (species='nigrogularis' OR species='nigrogularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artamus' AND (junior_species='cinereus' OR junior_species='cinereus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Artamus' AND (species='cinereus' OR species='cinereus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Artamus' AND (species='cinereus' OR species='cinereus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artamus' AND (junior_species='cinereus' OR junior_species='cinereus')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='Artamus' AND (species='cinereus' OR species='cinereus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamirostra' AND (junior_species='melanosternon' OR junior_species='melanosternon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hamirostra' AND (species='melanosternon' OR species='melanosternon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hamirostra' AND (species='melanosternon' OR species='melanosternon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamirostra' AND (junior_species='melanosternon' OR junior_species='melanosternon')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='Hamirostra' AND (species='melanosternon' OR species='melanosternon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Burhinus' AND (junior_species='grallarius' OR junior_species='grallarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Burhinus' AND (species='grallarius' OR species='grallarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Burhinus' AND (species='grallarius' OR species='grallarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Burhinus' AND (junior_species='grallarius' OR junior_species='grallarius')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='Burhinus' AND (species='grallarius' OR species='grallarius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centropus' AND (junior_species='phasianinus' OR junior_species='phasianinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Centropus' AND (species='phasianinus' OR species='phasianinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Centropus' AND (species='phasianinus' OR species='phasianinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centropus' AND (junior_species='phasianinus' OR junior_species='phasianinus')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='Centropus' AND (species='phasianinus' OR species='phasianinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Varanus' AND (junior_species='panoptes' OR junior_species='panoptes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Varanus' AND (species='panoptes' OR species='panoptes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Varanus' AND (species='panoptes' OR species='panoptes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Varanus' AND (junior_species='panoptes' OR junior_species='panoptes')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='panoptes' OR species='panoptes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Varanus' AND (junior_species='gouldii' OR junior_species='gouldi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Varanus' AND (species='gouldii' OR species='gouldi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Varanus' AND (species='gouldii' OR species='gouldi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Varanus' AND (junior_species='gouldii' OR junior_species='gouldi')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='gouldii' OR species='gouldi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlamydosaurus' AND (junior_species='kingii' OR junior_species='kingi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlamydosaurus' AND (species='kingii' OR species='kingi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlamydosaurus' AND (species='kingii' OR species='kingi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlamydosaurus' AND (junior_species='kingii' OR junior_species='kingi')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='Chlamydosaurus' AND (species='kingii' OR species='kingi') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3255
Reference:S. J. Dawson, P. J. Adams, K. E. Moseby, K. I. Waddington, H. T. Kobryn, P. W. Bateman, and P. A. Fleming. 2018. Peak hour in the bush: linear anthropogenic clearings funnel predator and prey species. Austral Ecology43(2):159-171 [ER 3021]
Geography
Country: Australia
State: Western Australia
Coordinate:17° 56' 12" S, 122° 47' 23" E
Coordinate basis: stated in text
•
Environment
Habitat: tropical/subtropical savanna
Protection: unknown
Substrate: ground surface
Habitat comments: "The West Kimberley region, in the north‐west of Western Australia, has a tropical, monsoonal climate, with an annual average of 500 mm of rainfall during November to April" and sampling was in Pindan vegetation (i.e., open woodland)
Methods
Life forms: carnivores,ungulates,other large mammals,other small mammals,birds,lizards
Focal species: Macrotis lagotis
Sampling methods: line transect,automatic cameras
Sample size: 1049 captures or sightings
Years: 2015, 2016
Days: 40
Nets or traps: 35
Net or trap nights: 927
Camera type: digital
Cameras paired: no
Sampling comments: "A camera trap array was made up of paired cameras, with one camera positioned on a seismic line (seismic station), and another camera ~20 m from the seismic line in adjacent vegetation (control station)... Cameras were not baited and positioned at a height of 400 mm on a metal stake... Four camera models were used as follows: three Reconyx models (HC500, HC600 and PC900) and Scoutguard SG860C (white flash model)"
in other words, cameras were not paired in the conventional sense because they were too far apart
sampling was from "4/12/2015 – 13/1/2016" with camera arrays placed 150 m apart
because pairs were 20 m apart, average spacing cannot be computed meaningfully
Metadata
Sample number: 3255
Contributor: John Alroy
Enterer: John Alroy
Created: 2019-03-10 21:05:34
Modified: 2019-03-10 10:05:34
Abundance distribution
24 species
5 singletons
total count 1049
extrapolated richness: 36.3
Fisher's α: 4.377
geometric series k: 0.7664
Hurlbert's PIE: 0.7297
Shannon's H: 1.7800
Good's u: 0.9952
Each square represents a species. Square sizes are proportional to counts.