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=1943 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1943SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1744SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1943 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasyprocta' AND (junior_species='punctata' OR junior_species='punctata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dasyprocta' AND (species='punctata' OR species='punctata') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasyprocta' AND (junior_species='punctata' OR junior_species='punctata')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='Dasyprocta' AND (species='punctata' OR species='punctata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aramides' AND (junior_species='cajanea' OR junior_species='cajanea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aramides' AND (species='cajanea' OR species='cajanea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aramides' AND (species='cajanea' OR species='cajanea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aramides' AND (junior_species='cajanea' OR junior_species='cajanea')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='Aramides' AND (species='cajanea' OR species='cajanea') 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='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='Crypturellus' AND (junior_species='soui' OR junior_species='souii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crypturellus' AND (species='soui' OR species='souii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crypturellus' AND (species='soui' OR species='souii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crypturellus' AND (junior_species='soui' OR junior_species='souii')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='Crypturellus' AND (species='soui' OR species='souii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='ignobilis' OR junior_species='ignobilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='ignobilis' OR species='ignobilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='ignobilis' OR species='ignobilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='ignobilis' OR junior_species='ignobilis')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='Turdus' AND (species='ignobilis' OR species='ignobilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasypus' AND (junior_species='novemcinctus' OR junior_species='novemcinctus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dasypus' AND (species='novemcinctus' OR species='novemcinctus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasypus' AND (junior_species='novemcinctus' OR junior_species='novemcinctus')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='Dasypus' AND (species='novemcinctus' OR species='novemcinctus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptotila' AND (junior_species='plumbeiceps' OR junior_species='plumbeiceps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptotila' AND (species='plumbeiceps' OR species='plumbeiceps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptotila' AND (species='plumbeiceps' OR species='plumbeiceps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptotila' AND (junior_species='plumbeiceps' OR junior_species='plumbeiceps')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='Leptotila' AND (species='plumbeiceps' OR species='plumbeiceps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geotrygon' AND (junior_species='montana' OR junior_species='montana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Geotrygon' AND (species='montana' OR species='montana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Geotrygon' AND (species='montana' OR species='montana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geotrygon' AND (junior_species='montana' OR junior_species='montana')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='Geotrygon' AND (species='montana' OR species='montana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ortalis' AND (junior_species='columbiana' OR junior_species='columbiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ortalis' AND (species='columbiana' OR species='columbiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ortalis' AND (species='columbiana' OR species='columbiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ortalis' AND (junior_species='columbiana' OR junior_species='columbiana')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='Ortalis' AND (species='columbiana' OR species='columbiana') 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='Cerdocyon' AND (junior_species='thous' OR junior_species='thous')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cerdocyon' AND (species='thous' OR species='thous') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cerdocyon' AND (junior_species='thous' OR junior_species='thous')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='Cerdocyon' AND (species='thous' OR species='thous') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eira' AND (junior_species='barbara' OR junior_species='barbara')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eira' AND (species='barbara' OR species='barbara') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eira' AND (junior_species='barbara' OR junior_species='barbara')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='Eira' AND (species='barbara' OR species='barbara') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leopardus' AND (junior_species='pardalis' OR junior_species='pardalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leopardus' AND (species='pardalis' OR species='pardalis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leopardus' AND (junior_species='pardalis' OR junior_species='pardalis')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='Leopardus' AND (species='pardalis' OR species='pardalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odontophorus' AND (junior_species='hyperythrus' OR junior_species='hyperythrus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Odontophorus' AND (species='hyperythrus' OR species='hyperythrus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Odontophorus' AND (species='hyperythrus' OR species='hyperythrus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odontophorus' AND (junior_species='hyperythrus' OR junior_species='hyperythrus')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='Odontophorus' AND (species='hyperythrus' OR species='hyperythrus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catharus' AND (junior_species='ustulatus' OR junior_species='ustulatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catharus' AND (species='ustulatus' OR species='ustulatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catharus' AND (species='ustulatus' OR species='ustulatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catharus' AND (junior_species='ustulatus' OR junior_species='ustulatus')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='Catharus' AND (species='ustulatus' OR species='ustulatus') 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 * FROM register WHERE sample_no=1943 The Ecological Register: Parque Nacional Natural Farallones de Cali (forest)
Parque Nacional Natural Farallones de Cali (forest)
Basic information
Sample name: Parque Nacional Natural Farallones de Cali (forest)

Reference: D. M. Mosquera-Muñoz, G. Corredor, P. Cardona, and I. Armbrecht. 2014. Fototrampeo de aves caminadoras y mamíferos asociados en el piedemonte de Farallones de Cali. Boletin Cientifico del Centro de Museos de la Universidad de Caldas 18(2):144-156 [ER 1744]
Geography
Country: Colombia


Coordinate: 3° 15' N, 76° 39' W
Coordinate basis: based on nearby landmark

Geography comments: "en el corregimiento de Pance, vereda El Peón, Parcelación Lomalarga en el Suroccidente del departamento del Valle del Cauca"
coordinate based on Parque Nacional Natural Farallones de Cali
elevation 1100 to 1300 m

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Altered habitat: secondary forest

Protection: national/state park

Substrate: ground surface

MAT: 19.0

MAP: 1433.0

Habitat comments: "Esta zona se caracteriza por presentar un mosaico de coberturas como bosques secundarios, matorrales y potreros"
climate data are for the municipality of Santiago de Cali in Valle del Cauca and are from Calle et al. (2013, Restoration Ecology)

Methods
Life forms: carnivores,rodents,ungulates,other large mammals,other small mammals,birds

Sampling methods: baited,automatic cameras

Sample size: 1179 captures or sightings

Years: 2013

Net or trap nights: 1242

Camera type: digital

Cameras paired: no

Trap spacing: 2

Sampling comments: 15 corn baited Cuddeback Capture and Reconyx RM45 Rapidfire cameras were installed between January and November 2013, spaced approximately 2 km and operating for 24 hours a day; the number of cameras installed in this habitat is unclear

Metadata
Sample number: 1943

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-01-17 21:41:12

Modified: 2016-12-15 05:58:21

Abundance distribution
17 species
2 singletons
total count 1179
extrapolated richness: 21.6
Fisher's α: 2.815
geometric series k: 0.6871
Hurlbert's PIE: 0.7749
Shannon's H: 1.8595
Good's u: 0.9983
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Dasyprocta punctata4052.7 kg frugivore
Aramides cajanea347397 g insectivore
Didelphis marsupialis1221.0 kg
Canis lupus familiaris6143 kg carnivore
Crypturellus soui13198 g frugivore-granivore
Turdus ignobilis3461.0 g
Dasypus novemcinctus464.4 kg invertivore
Leptotila plumbeiceps56170 g
Geotrygon montana515.2 g granivore-frugivore
Ortalis columbiana5
Bos taurus18337 kg
Cerdocyon thous95.2 kg carnivore-frugivore
Eira barbara54.3 kg frugivore-carnivore
Leopardus pardalis38.4 kg carnivore
Odontophorus hyperythrus2351 g frugivore-insectivore
Catharus ustulatus130.3 g insectivore-frugivore
Felis catus1
"Felis silvestris catus"