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=1219 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1219SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=857SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1219 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Proechimys' 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='Proechimys' AND (species='longicaudatus' OR species='longicaudatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Proechimys' AND (species='longicaudatus' OR species='longicaudatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Proechimys' 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='Proechimys' AND (species='longicaudatus' OR species='longicaudatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oecomys' AND (junior_species='bicolor' OR junior_species='bicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oecomys' AND (species='bicolor' OR species='bicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oecomys' AND (species='bicolor' OR species='bicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oecomys' AND (junior_species='bicolor' OR junior_species='bicolor')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='Oecomys' AND (species='bicolor' OR species='bicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marmosa' AND (junior_species='demerarae' OR junior_species='demerarae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Marmosa' AND (species='demerarae' OR species='demerarae') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marmosa' AND (junior_species='demerarae' OR junior_species='demerarae')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='Marmosa' AND (species='demerarae' OR species='demerarae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylaeamys' AND (junior_species='acritus' OR junior_species='acritus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hylaeamys' AND (species='acritus' OR species='acritus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylaeamys' AND (junior_species='acritus' OR junior_species='acritus')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='Hylaeamys' AND (species='acritus' OR species='acritus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marmosops' AND (junior_species='ocellatus' OR junior_species='ocellatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Marmosops' AND (species='ocellatus' OR species='ocellatus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marmosops' AND (junior_species='ocellatus' OR junior_species='ocellatus')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='Marmosops' AND (species='ocellatus' OR species='ocellatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euryoryzomys' AND (junior_species='nitidus' OR junior_species='nitidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euryoryzomys' AND (species='nitidus' OR species='nitidus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euryoryzomys' AND (junior_species='nitidus' OR junior_species='nitidus')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='Euryoryzomys' AND (species='nitidus' OR species='nitidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Akodon' AND (junior_species='dayi' OR junior_species='dayii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Akodon' AND (species='dayi' OR species='dayii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Akodon' AND (species='dayi' OR species='dayii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Akodon' AND (junior_species='dayi' OR junior_species='dayii')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='dayi' OR species='dayii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligoryzomys' AND (junior_species='microtis' OR junior_species='microtis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oligoryzomys' AND (species='microtis' OR species='microtis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oligoryzomys' AND (species='microtis' OR species='microtis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligoryzomys' AND (junior_species='microtis' OR junior_species='microtis')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='microtis' OR species='microtis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metachirus' AND (junior_species='nudicaudatus' OR junior_species='nudicaudatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Metachirus' AND (species='nudicaudatus' OR species='nudicaudatus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metachirus' AND (junior_species='nudicaudatus' OR junior_species='nudicaudatus')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='Metachirus' AND (species='nudicaudatus' OR species='nudicaudatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neacomys' AND (junior_species='spinosus' OR junior_species='spinosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neacomys' AND (species='spinosus' OR species='spinosus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neacomys' AND (junior_species='spinosus' OR junior_species='spinosus')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='Neacomys' AND (species='spinosus' OR species='spinosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Didelphis' AND (junior_species='marsupialis' OR junior_species='marsupialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Didelphis' AND (species='marsupialis' OR species='marsupialis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Didelphis' AND (junior_species='marsupialis' OR junior_species='marsupialis')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='Didelphis' AND (species='marsupialis' OR species='marsupialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesomys' AND (junior_species='hispidus' OR junior_species='hispidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mesomys' AND (species='hispidus' OR species='hispidus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesomys' AND (junior_species='hispidus' OR junior_species='hispidus')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='Mesomys' AND (species='hispidus' OR species='hispidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marmosa' AND (junior_species='murina' OR junior_species='murina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Marmosa' AND (species='murina' OR species='murina') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marmosa' AND (junior_species='murina' OR junior_species='murina')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='Marmosa' AND (species='murina' OR species='murina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oecomys' AND (junior_species='roberti' OR junior_species='robertii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oecomys' AND (species='roberti' OR species='robertii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oecomys' AND (junior_species='roberti' OR junior_species='robertii')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='Oecomys' AND (species='roberti' OR species='robertii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monodelphis' AND (junior_species='kunsi' OR junior_species='kunsii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Monodelphis' AND (species='kunsi' OR species='kunsii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monodelphis' AND (junior_species='kunsi' OR junior_species='kunsii')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='Monodelphis' AND (species='kunsi' OR species='kunsii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gracilinanus' 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='Gracilinanus' AND (species='agilis' OR species='agilis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gracilinanus' 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='Gracilinanus' AND (species='agilis' OR species='agilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Necromys' AND (junior_species='lenguarum' OR junior_species='lenguarum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Necromys' AND (species='lenguarum' OR species='lenguarum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Necromys' AND (species='lenguarum' OR species='lenguarum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Necromys' AND (junior_species='lenguarum' OR junior_species='lenguarum')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='Necromys' AND (species='lenguarum' OR species='lenguarum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oecomys' AND (junior_species='trinitatis' OR junior_species='trinitatis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oecomys' AND (species='trinitatis' OR species='trinitatis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oecomys' AND (junior_species='trinitatis' OR junior_species='trinitatis')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='Oecomys' AND (species='trinitatis' OR species='trinitatis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1219 The Ecological Register: El Refugio Huanchaca Biological Station
El Refugio Huanchaca Biological Station
Basic information
Sample name: El Refugio Huanchaca Biological Station

Sample aka: Noel Kempff Mercado National Park

Reference: L. H. Emmons. 2009. Long-term variation in small mammal abundance in forest and savanna of Bolivian Cerrado. Biotropica 41(4):493-502 [ER 857]
Geography
Country: Bolivia

State: Santa Cruz


Coordinate: -14.751° S, -61.028° W
Coordinate basis: stated in text

•
Environment
Habitat: tropical/subtropical dry broadleaf forest

Protection: national/state park

Substrate: ground surface

MAT: 25.5

MAP: 1481.0

Habitat comments: "Forest with deciduous canopy... covered with native vegetation" and "now undisturbed"
MAP stated in text; MAT is for NKMNP and is from Gosling et al. (2005)

Methods
Life forms: rodents,other small mammals

Sampling methods: line transect,baited,Sherman traps,Tomahawk traps

Sample size: 537 individuals

Years: 1998 - 2007

Nets or traps: 130

Net or trap nights: 13118

Sampling comments: "five parallel lines spaced 150 m apart, with 15 trap stations spaced at 20-m intervals on each line; for a footprint of 16.8 ha or about 18 ha with an added buffer"; there was one Sherman trap per station, one Tomahawk trap at every third station, and six Sherman traps placed in trees at random on each line "for a total of 130 traps/plot"; traps were baited with rolled oats and raisins
coutns are of individuals

Metadata
Sample number: 1219

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-02-16 11:12:50

Modified: 2015-10-04 10:21:03

Abundance distribution
18 species
4 singletons
total count 537
extrapolated richness: 25.4
Fisher's α: 3.589
geometric series k: 0.7270
Hurlbert's PIE: 0.7817
Shannon's H: 2.0089
Good's u: 0.9926
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Proechimys longicaudatus226
Oecomys 'bicolor'52
Marmosa demerarae4883.6 g
"Micoureus demerarae"
Hylaeamys acritus4357.0 g
Marmosops ocellatus4231.3 g
Euryoryzomys nitidus4267.8 g
Akodon dayi32
Oligoryzomys microtis10
Metachirus nudicaudatus8372 g insectivore-frugivore
Neacomys spinosus823.8 g
Didelphis marsupialis61.0 kg
Mesomys hispidus6193 g
Marmosa murina541.1 g
Oecomys roberti530.1 g
Monodelphis kunsi110.4 g
Gracilinanus agilis123.5 g insectivore-frugivore
Necromys lenguarum1
Oecomys trinitatis166.1 g