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=1480 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1480SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=991SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1480 ORDER BY register_no ASCSELECT 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 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='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='Coturnix' AND (junior_species='ypsilophora' OR junior_species='ypsilophora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coturnix' AND (species='ypsilophora' OR species='ypsilophora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coturnix' AND (species='ypsilophora' OR species='ypsilophora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coturnix' AND (junior_species='ypsilophora' OR junior_species='ypsilophora')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='Coturnix' AND (species='ypsilophora' OR species='ypsilophora') 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='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='Rhinella' AND (junior_species='marina' OR junior_species='marina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinella' AND (species='marina' OR species='marina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhinella' AND (species='marina' OR species='marina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinella' AND (junior_species='marina' OR junior_species='marina')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='Rhinella' AND (species='marina' OR species='marina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tiliqua' AND (junior_species='scincoides' OR junior_species='scincoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tiliqua' AND (species='scincoides' OR species='scincoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tiliqua' AND (species='scincoides' OR species='scincoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tiliqua' AND (junior_species='scincoides' OR junior_species='scincoides')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='scincoides' OR species='scincoides') 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='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 * FROM register WHERE sample_no=1480 The Ecological Register: Brunswick Heads Bypass
Brunswick Heads Bypass
Basic information
Sample name: Brunswick Heads Bypass

Reference: B. D. Taylor and R. L. Goldingay. 2003. Cutting the carnage: wildlife usage of road culverts in north-eastern New South Wales. Wildlife Research 30:529-537 [ER 991]
Geography
Country: Australia

State: New South Wales


Coordinate: 28° 33' S, 153° 32' E
Coordinate basis: stated in text

Geography comments: a "2.5 km bypass"

•
Environment
Habitat: tropical/subtropical dry broadleaf forest

Substrate: ground surface

Disturbance: recent fire,grazing,selective logging

Habitat comments: "coastal lowlands comprising old, low-lying dunes... that graded into the floodplain... dominated by swamp sclerophyll open forest and woodland" that "had experienced moderate to high disturbance (predominantly on the western side) from past logging, grazing and fires within the last seven years"

Methods
Life forms: rodents,other small mammals,birds,lizards,frogs

Sampling methods: no design,cage traps,Elliott traps

Sample size: 77 individuals

Years: 2000

Days: 4

Nets or traps: 145

Net or trap nights: 560

Sampling comments: four nights of trapping with 15 Elliott traps per culvert at nine culverts and two cage traps per culvert at five culverts; "Elliott traps were baited... with oats and peanut butter" and cages with "dog meat and fruit"
reported trap night figure is used despite being slightly lower than what is implied by the trap and day counts

Metadata
Sample number: 1480

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-03-04 14:22:37

Modified: 2015-03-04 03:22:37

Abundance distribution
10 species
2 singletons
total count 77
extrapolated richness: 15.7
Fisher's α: 3.065
geometric series k: 0.6879
Hurlbert's PIE: 0.7797
Shannon's H: 1.8235
Good's u: 0.9744
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Mus musculus2917.6 g
Rattus lutreolus16
Isoodon macrourus1070.3 g
Coturnix ypsilophora410.9 g granivore
Rattus rattus6121 g
Rattus fuscipes5
Rhinella marina3
Tiliqua scincoides2
Perameles nasuta1992 g
Limnodynastes peronii1