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=1863 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1863SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1678SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1863 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antechinus' AND (junior_species='stuartii' OR junior_species='stuarti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Antechinus' AND (species='stuartii' OR species='stuarti') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Antechinus' AND (species='stuartii' OR species='stuarti')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antechinus' AND (junior_species='stuartii' OR junior_species='stuarti')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='Antechinus' AND (species='stuartii' OR species='stuarti') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antechinus' AND (junior_species='flavipes' OR junior_species='flavipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Antechinus' AND (species='flavipes' OR species='flavipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Antechinus' AND (species='flavipes' OR species='flavipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antechinus' AND (junior_species='flavipes' OR junior_species='flavipes')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='Antechinus' AND (species='flavipes' OR species='flavipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antechinus' AND (junior_species='godmani' OR junior_species='godmanii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Antechinus' AND (species='godmani' OR species='godmanii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Antechinus' AND (species='godmani' OR species='godmanii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antechinus' AND (junior_species='godmani' OR junior_species='godmanii')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='Antechinus' AND (species='godmani' OR species='godmanii') 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='Hypsiprymnodon' AND (junior_species='moschatus' OR junior_species='moschatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypsiprymnodon' AND (species='moschatus' OR species='moschatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypsiprymnodon' AND (species='moschatus' OR species='moschatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsiprymnodon' AND (junior_species='moschatus' OR junior_species='moschatus')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='Hypsiprymnodon' AND (species='moschatus' OR species='moschatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perameles' AND (junior_species='nasuta' OR junior_species='nasuta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perameles' AND (species='nasuta' OR species='nasuta') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perameles' AND (junior_species='nasuta' OR junior_species='nasuta')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='Perameles' AND (species='nasuta' OR species='nasuta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Isoodon' AND (junior_species='macrourus' OR junior_species='macrourus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Isoodon' AND (species='macrourus' OR species='macrourus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Isoodon' AND (junior_species='macrourus' OR junior_species='macrourus')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='Isoodon' AND (species='macrourus' OR species='macrourus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melomys' AND (junior_species='cervinipes' OR junior_species='cervinipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melomys' AND (species='cervinipes' OR species='cervinipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melomys' AND (species='cervinipes' OR species='cervinipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melomys' AND (junior_species='cervinipes' OR junior_species='cervinipes')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='Melomys' AND (species='cervinipes' OR species='cervinipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uromys' AND (junior_species='caudimaculatus' OR junior_species='caudimaculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Uromys' AND (species='caudimaculatus' OR species='caudimaculatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Uromys' AND (species='caudimaculatus' OR species='caudimaculatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uromys' AND (junior_species='caudimaculatus' OR junior_species='caudimaculatus')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='Uromys' AND (species='caudimaculatus' OR species='caudimaculatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hydromys' AND (junior_species='chrysogaster' OR junior_species='chrysogaster')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hydromys' AND (species='chrysogaster' OR species='chrysogaster') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hydromys' AND (species='chrysogaster' OR species='chrysogaster')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hydromys' AND (junior_species='chrysogaster' OR junior_species='chrysogaster')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='Hydromys' AND (species='chrysogaster' OR species='chrysogaster') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rattus' AND (junior_species='leucopus' OR junior_species='leucopus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rattus' AND (species='leucopus' OR species='leucopus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rattus' AND (species='leucopus' OR species='leucopus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rattus' AND (junior_species='leucopus' OR junior_species='leucopus')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='Rattus' AND (species='leucopus' OR species='leucopus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rattus' AND (junior_species='fuscipes' OR junior_species='fuscipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rattus' AND (species='fuscipes' OR species='fuscipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rattus' AND (species='fuscipes' OR species='fuscipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rattus' AND (junior_species='fuscipes' OR junior_species='fuscipes')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='Rattus' AND (species='fuscipes' OR species='fuscipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rattus' AND (junior_species='lutreolus' OR junior_species='lutreolus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rattus' AND (species='lutreolus' OR species='lutreolus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rattus' AND (species='lutreolus' OR species='lutreolus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rattus' AND (junior_species='lutreolus' OR junior_species='lutreolus')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='Rattus' AND (species='lutreolus' OR species='lutreolus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rattus' AND (junior_species='sordidus' OR junior_species='sordidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rattus' AND (species='sordidus' OR species='sordidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rattus' AND (species='sordidus' OR species='sordidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rattus' AND (junior_species='sordidus' OR junior_species='sordidus')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='Rattus' AND (species='sordidus' OR species='sordidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rattus' AND (junior_species='rattus' OR junior_species='rattus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rattus' AND (species='rattus' OR species='rattus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rattus' AND (junior_species='rattus' OR junior_species='rattus')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='Rattus' AND (species='rattus' OR species='rattus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mus' AND (junior_species='musculus' OR junior_species='musculus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mus' AND (species='musculus' OR species='musculus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mus' AND (junior_species='musculus' OR junior_species='musculus')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='Mus' AND (species='musculus' OR species='musculus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1863 The Ecological Register: Southern Atherton Tableland
Southern Atherton Tableland
Basic information
Sample name: Southern Atherton Tableland

Reference: W. F. Laurance. 1992. Abundance estimates of small mammals in Australian tropical rainforest: a comparison of four trapping methods. Wildlife Research 19:651-655 [ER 1678]
Geography
Country: Australia

State: Queensland


Coordinate: 17° 31' S, 145° 37' E
Coordinate basis: based on nearby landmark

Geography comments: "the southern Atherton Tableland" (coordinate based on Millaa Millaa)
elevation 600 to 900 m

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Altered habitat: fragment

Substrate: ground surface

MAT: 18.8

MAP: 2800.0

Habitat comments: "Rainforests in this area are mostly complex notophyll vine-forest... having a complex structure, many epiphytes and lianas, and continuous canopy" and there is "a pronounced wet season from January to April"
MAP stated in text; MAT is for Millaa Millaa Falls and is from Greenwood (2005, Palaios)

Methods
Life forms: rodents,other small mammals

Sites: 52

Sampling methods: quadrat,baited,cage traps,Elliott traps

Sample size: 3183 individuals

Years: 1986, 1987

Seasons: dry,wet or monsoon

Net or trap nights: 15750

Sampling comments: "52 small (30 x 30 m) trapping grids in 10 forest fragments (1.4-590 ha in area), and five 'control sites' in continuous forest... trapping grids were arrayed along a single gradsect line (Gillison 1984), which is a transect situated along a maximum elevational gradient... Mammal populations were censused 6-7 times at each grid over a 14-month period (July 1986- August 1987), with each census consisting of five consecutive nights of trapping... Terrestrial trapping (15 750 trap-nights) involved 12 Elliott box-traps (10 x 11x 30 cm) and six wire-mesh cage-traps (20 x 22 x 48 cm), baited with rolled oats and vanilla essence and placed on the ground in a cross-shaped configuration within each grid. Nineteen grids were initially censused in the early dry season (July-August 1986), then all 52 grids were censused three times each, during the late dry season (August-December 1986), the wet season (January-April 1987), and the following dry season (May-August 1987"

Metadata
Sample number: 1863

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-12-29 16:48:41

Modified: 2015-12-29 05:48:41

Abundance distribution
16 species
5 singletons
total count 3183
extrapolated richness: 25.7
Fisher's α: 2.198
geometric series k: 0.6278
Hurlbert's PIE: 0.7413
Shannon's H: 1.4756
Good's u: 0.9984
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Antechinus stuartii8
Antechinus flavipes8
Antechinus godmani3
Trichosurus vulpecula372.1 kg folivore
Hypsiprymnodon moschatus7
Perameles nasuta10992 g
Isoodon macrourus170.3 g
Melomys cervinipes1078
Uromys caudimaculatus601
Hydromys chrysogaster6
Rattus leucopus501
Rattus fuscipes919
Rattus lutreolus1
Rattus sordidus1
Rattus rattus1121 g
Mus musculus117.6 g