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=1261 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1261SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=883SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1261 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhyncholestes' AND (junior_species='raphanurus' OR junior_species='raphanurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhyncholestes' AND (species='raphanurus' OR species='raphanurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhyncholestes' AND (species='raphanurus' OR species='raphanurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhyncholestes' AND (junior_species='raphanurus' OR junior_species='raphanurus')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='Rhyncholestes' AND (species='raphanurus' OR species='raphanurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dromiciops' AND (junior_species='gliroides' OR junior_species='gliroides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dromiciops' AND (species='gliroides' OR species='gliroides') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dromiciops' AND (junior_species='gliroides' OR junior_species='gliroides')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='Dromiciops' AND (species='gliroides' OR species='gliroides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligoryzomys' AND (junior_species='longicaudatus' OR junior_species='longicaudatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oligoryzomys' AND (species='longicaudatus' OR species='longicaudatus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligoryzomys' AND (junior_species='longicaudatus' OR junior_species='longicaudatus')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='Oligoryzomys' AND (species='longicaudatus' OR species='longicaudatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abrothrix' AND (junior_species='olivaceus' OR junior_species='olivaceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Abrothrix' AND (species='olivaceus' OR species='olivaceus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abrothrix' AND (junior_species='olivaceus' OR junior_species='olivaceus')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='Abrothrix' AND (species='olivaceus' OR species='olivaceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abrothrix' AND (junior_species='longipilis' OR junior_species='longipilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Abrothrix' AND (species='longipilis' OR species='longipilis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abrothrix' AND (junior_species='longipilis' OR junior_species='longipilis')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='Abrothrix' AND (species='longipilis' OR species='longipilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abrothrix' AND (junior_species='sanborni' OR junior_species='sanbornii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Abrothrix' AND (species='sanborni' OR species='sanbornii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Abrothrix' AND (species='sanborni' OR species='sanbornii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abrothrix' AND (junior_species='sanborni' OR junior_species='sanbornii')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='Abrothrix' AND (species='sanborni' OR species='sanbornii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Akodon' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Akodon' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Akodon' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Akodon' AND (junior_species='sp.' OR junior_species='sp.')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='Akodon' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Loxodontomys' AND (junior_species='micropus' OR junior_species='micropus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Loxodontomys' AND (species='micropus' OR species='micropus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Loxodontomys' AND (junior_species='micropus' OR junior_species='micropus')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='Loxodontomys' AND (species='micropus' OR species='micropus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1261
The Ecological Register: Valle de la Picada (425 m)
Reference:B. D. Patterson, P. L. Meserve, and B. K. Lang. 1989. Distribution and abundance of small mammals along an elevational transect in temperate rainforests of Chile. Journal of Mammalogy70(1):67-78 [ER 883]
Geography
Country: Chile
Coordinate:41° 2' S, 72° 30' W
Coordinate basis: stated in text
•
Environment
Habitat: temperate broadleaf/mixed forest
Protection: national/state park
Substrate: ground surface
MAT: 9.9
MAP: 1783.0
Habitat comments: temperate rainforest
climate data are for Puerto Montt and from Lara et al. (2005, Journal of Biogeography)
Methods
Life forms: rodents,other small mammals
Sampling methods: line transect,Sherman traps,snap traps
Sample size: 124 individuals
Years: 1984
Days: 7
Sampling comments: three trap lines each consisting of 10 Sherman traps and 45 museum special snap traps "placed ca. 7 m apart"; most individuals were caught in the snap traps
Metadata
Sample number: 1261
Contributor: John Alroy
Enterer: John Alroy
Created: 2015-02-17 21:15:43
Modified: 2015-12-01 02:21:48
Abundance distribution
8 species
1 singleton
total count 124
extrapolated richness: 10.2
Fisher's α: 1.910
geometric series k: 0.5769
Hurlbert's PIE: 0.7705
Shannon's H: 1.7004
Good's u: 0.9919
Each square represents a species. Square sizes are proportional to counts.