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=1916 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1916SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1719SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1916 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Didelphis' AND (junior_species='aurita' OR junior_species='aurita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Didelphis' AND (species='aurita' OR species='aurita') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Didelphis' AND (junior_species='aurita' OR junior_species='aurita')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='aurita' OR species='aurita') 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='Tamandua' AND (junior_species='tetradactyla' OR junior_species='tetradactyla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tamandua' AND (species='tetradactyla' OR species='tetradactyla') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tamandua' AND (junior_species='tetradactyla' OR junior_species='tetradactyla')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='Tamandua' AND (species='tetradactyla' OR species='tetradactyla') 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='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='Nasua' AND (junior_species='nasua' OR junior_species='nasua')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nasua' AND (species='nasua' OR species='nasua') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nasua' AND (junior_species='nasua' OR junior_species='nasua')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='Nasua' AND (species='nasua' OR species='nasua') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Procyon' AND (junior_species='cancrivorus' OR junior_species='cancrivorus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Procyon' AND (species='cancrivorus' OR species='cancrivorus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Procyon' AND (junior_species='cancrivorus' OR junior_species='cancrivorus')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='Procyon' AND (species='cancrivorus' OR species='cancrivorus') 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='spp.' OR junior_species='spp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leopardus' AND (species='spp.' OR species='spp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leopardus' AND (species='spp.' OR species='spp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leopardus' AND (junior_species='spp.' OR junior_species='spp.')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='spp.' OR species='spp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mazama' AND (junior_species='spp.' OR junior_species='spp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mazama' AND (species='spp.' OR species='spp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mazama' AND (species='spp.' OR species='spp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mazama' AND (junior_species='spp.' OR junior_species='spp.')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='Mazama' AND (species='spp.' OR species='spp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hydrochoerus' AND (junior_species='hydrochaeris' OR junior_species='hydrochaeris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hydrochoerus' AND (species='hydrochaeris' OR species='hydrochaeris') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hydrochoerus' AND (junior_species='hydrochaeris' OR junior_species='hydrochaeris')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='Hydrochoerus' AND (species='hydrochaeris' OR species='hydrochaeris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasyprocta' AND (junior_species='azarae' OR junior_species='azarae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dasyprocta' AND (species='azarae' OR species='azarae') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasyprocta' AND (junior_species='azarae' OR junior_species='azarae')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='azarae' OR species='azarae') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1916 The Ecological Register: Tapiraí and Piedade Municipalities
Tapiraí and Piedade Municipalities
Basic information
Sample name: Tapiraí and Piedade Municipalities

Reference: K. D. Espartosa, B. T. Pinotti, and R. Pardini. 2011. Performance of camera trapping and track counts for surveying large mammals in rainforest remnants. Biodiversity and Conservation 20(12):2815-2829 [ER 1719]
Geography
Country: Brazil

State: Säo Paulo


Coordinate: 23° 50' S, 47° 28' W
Coordinate basis: based on political unit

Geography comments: "a 10,000-ha fragmented landscape in the municipalities of Tapiraí and Piedade"
altitude 800 to 880 m
bogus ranges of coordinates are given in a figure; coordinate is based instead on a rough mean for the two municipalities

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Altered habitat: secondary forest

Substrate: ground surface

Disturbance: agriculture,grazing

MAT: 18.9

MAP: 1800.0

Habitat comments: "originally covered by forest classified as 'Lower Montane Atlantic Rainforest'... reduced today to 49% of the landscape (secondary forest in intermediate to advanced stages of regeneration, Fig. 1). Remnants are surrounded by pastures (24% of the landscape), agriculture (13%), homogeneous plantation of Pinus spp. and Eucalyptus spp. (5%), and native vegetation in initial stages of regeneration (3%)"

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

Sites: 24

Sampling methods: no design,baited,automatic cameras

Sample size: 1702 captures or sightings

Years: 2006, 2007

Days: 20

Nets or traps: 36

Net or trap nights: 2496

Camera type: analog

Cameras paired: no

Trap spacing: 0.9

Sampling comments: "We sampled 24 sites located in remnants of secondary forest, which were selected to... maintain a minimum distance of 900 m between sites... We surveyed large terrestrial mammals (C1 kg) between October 2006 and July 2007, when all 24 sites (remnants) were sampled with camera traps and sand plots... In each site we set three sampling units 100-m apart... each consisting of one [film Trapa-camera] camera trap... and four sand plots (0.5 9 0.5 m each) set at 5 m from the camera... Each site (remnant) was sampled during 40 days divided into three surveys (10 or 15 days each), during which 12 of the 24 remnants were sampled simultaneously... Final sampling effort among the 24 sites varied from 90 to 118 camera-days"; baiting was with "banana... together with corn and salt" and half of the sampling used this bait type
sampling effort estimated as 24 sites x 104 camera-days

Metadata
Sample number: 1916

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-01-12 20:31:35

Modified: 2016-01-30 09:32:11

Abundance distribution
12 species
2 singletons
total count 1702
extrapolated richness: 15.3
Fisher's α: 1.743
geometric series k: 0.5217
Hurlbert's PIE: 0.4198
Shannon's H: 1.0145
Good's u: 0.9988
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Didelphis aurita12831.1 kg invertivore-frugivore
Dasypus novemcinctus764.4 kg invertivore
Tamandua tetradactyla14.8 kg insectivore
Canis lupus familiaris6143 kg carnivore
Cerdocyon thous1325.2 kg carnivore-frugivore
Nasua nasua394.4 kg invertivore-frugivore
Procyon cancrivorus45.0 kg carnivore-frugivore
Eira barbara684.3 kg frugivore-carnivore
Leopardus spp.10
Mazama spp.14
Hydrochoerus hydrochaeris158 kg grazer-browser
Dasyprocta azarae132.5 kg