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=1962 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1962SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1758SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1962 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meles' AND (junior_species='meles' OR junior_species='meles')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Meles' AND (species='meles' OR species='meles') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meles' AND (junior_species='meles' OR junior_species='meles')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='Meles' AND (species='meles' OR species='meles') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ursus' AND (junior_species='arctos' OR junior_species='arctos')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ursus' AND (species='arctos' OR species='arctos') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ursus' AND (junior_species='arctos' OR junior_species='arctos')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='Ursus' AND (species='arctos' OR species='arctos') 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 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='Vulpes' AND (junior_species='vulpes' OR junior_species='vulpes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vulpes' AND (species='vulpes' OR species='vulpes') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vulpes' AND (junior_species='vulpes' OR junior_species='vulpes')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='Vulpes' AND (species='vulpes' OR species='vulpes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lynx' AND (junior_species='lynx' OR junior_species='lynx')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lynx' AND (species='lynx' OR species='lynx') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lynx' AND (junior_species='lynx' OR junior_species='lynx')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='Lynx' AND (species='lynx' OR species='lynx') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Martes' 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='Martes' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Martes' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Martes' 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='Martes' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' AND (junior_species='europaeus' OR junior_species='europaeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepus' AND (species='europaeus' OR species='europaeus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' AND (junior_species='europaeus' OR junior_species='europaeus')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='Lepus' AND (species='europaeus' OR species='europaeus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' AND (junior_species='timidus' OR junior_species='timidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepus' AND (species='timidus' OR species='timidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lepus' AND (species='timidus' OR species='timidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' AND (junior_species='timidus' OR junior_species='timidus')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='Lepus' AND (species='timidus' OR species='timidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Homo' AND (junior_species='sapiens' OR junior_species='sapiens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Homo' AND (species='sapiens' OR species='sapiens') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Homo' AND (junior_species='sapiens' OR junior_species='sapiens')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='Homo' AND (species='sapiens' OR species='sapiens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apodemus' 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='Apodemus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apodemus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apodemus' 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='Apodemus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glis' AND (junior_species='glis' OR junior_species='glis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glis' AND (species='glis' OR species='glis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glis' AND (species='glis' OR species='glis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glis' AND (junior_species='glis' OR junior_species='glis')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='Glis' AND (species='glis' OR species='glis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sciurus' AND (junior_species='vulgaris' OR junior_species='vulgaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sciurus' AND (species='vulgaris' OR species='vulgaris') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sciurus' AND (junior_species='vulgaris' OR junior_species='vulgaris')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='Sciurus' AND (species='vulgaris' OR species='vulgaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rupicapra' AND (junior_species='rupicapra' OR junior_species='rupicapra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rupicapra' AND (species='rupicapra' OR species='rupicapra') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rupicapra' AND (junior_species='rupicapra' OR junior_species='rupicapra')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='Rupicapra' AND (species='rupicapra' OR species='rupicapra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervus' AND (junior_species='elaphus' OR junior_species='elaphus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cervus' AND (species='elaphus' OR species='elaphus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervus' AND (junior_species='elaphus' OR junior_species='elaphus')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='Cervus' AND (species='elaphus' OR species='elaphus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='ferus' OR junior_species='ferus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Equus' AND (species='ferus' OR species='ferus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='ferus' OR junior_species='ferus')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='Equus' AND (species='ferus' OR species='ferus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ovis' AND (junior_species='gmelini' OR junior_species='gmelinii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ovis' AND (species='gmelini' OR species='gmelinii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ovis' AND (junior_species='gmelini' OR junior_species='gmelinii')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='Ovis' AND (species='gmelini' OR species='gmelinii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capreolus' AND (junior_species='capreolus' OR junior_species='capreolus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Capreolus' AND (species='capreolus' OR species='capreolus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capreolus' AND (junior_species='capreolus' OR junior_species='capreolus')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='Capreolus' AND (species='capreolus' OR species='capreolus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ovis' AND (junior_species='aries' OR junior_species='aries')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ovis' AND (species='aries' OR species='aries') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ovis' AND (junior_species='aries' OR junior_species='aries')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='Ovis' AND (species='aries' OR species='aries') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dryocopus' AND (junior_species='martius' OR junior_species='martius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dryocopus' AND (species='martius' OR species='martius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dryocopus' AND (species='martius' OR species='martius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dryocopus' AND (junior_species='martius' OR junior_species='martius')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='Dryocopus' AND (species='martius' OR species='martius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrrhula' AND (junior_species='pyrrhula' OR junior_species='pyrrhula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyrrhula' AND (species='pyrrhula' OR species='pyrrhula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyrrhula' AND (species='pyrrhula' OR species='pyrrhula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrrhula' AND (junior_species='pyrrhula' OR junior_species='pyrrhula')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='Pyrrhula' AND (species='pyrrhula' OR species='pyrrhula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garrulus' AND (junior_species='glandarius' OR junior_species='glandarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Garrulus' AND (species='glandarius' OR species='glandarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Garrulus' AND (species='glandarius' OR species='glandarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garrulus' AND (junior_species='glandarius' OR junior_species='glandarius')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='Garrulus' AND (species='glandarius' OR species='glandarius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nucifraga' AND (junior_species='caryocatactes' OR junior_species='caryocatactes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nucifraga' AND (species='caryocatactes' OR species='caryocatactes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nucifraga' AND (species='caryocatactes' OR species='caryocatactes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nucifraga' AND (junior_species='caryocatactes' OR junior_species='caryocatactes')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='Nucifraga' AND (species='caryocatactes' OR species='caryocatactes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' 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='Turdus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' 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='Turdus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1962 The Ecological Register: Western Trento Province (2012)
Western Trento Province (2012)
Basic information
Sample name: Western Trento Province (2012)

Reference: C. Tattoni, N. Bragalanti, C. Groff, and F. Rovero. 2015. Patterns in the use of rub trees by the Eurasian Brown Bear. Hystrix 26(2):1-7 [ER 1758]
Geography
Country: Italy

State: Trento


Coordinate: 46° 10' N, 10° 45' E
Coordinate basis: stated in text

Geography comments: "the western part of Trento Province... it encompassed the Adamello-Brenta Natural Park to the west, the adjacent Paganella mountain to the East and Monte Bondone to the South"
elevation 650 to 1700 m

•
Environment
Habitat: temperate broadleaf/mixed forest

Substrate: ground surface

MAT: 4.0

MAP: 992.0

Habitat comments: "The trees are found mainly in broad leave forests (beech) but also in coniferous (spruce and fir) and mixed forests"
climate data are for Pellizano in western Trento Province and are from Carletti et al. (2009, Plant Soil)

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

Site area: 40000

Sampling methods: no design,automatic cameras

Sample size: 3305 captures or sightings

Years: 2012

Seasons: spring,summer,autumn

Nets or traps: 20

Net or trap nights: 3101

Camera type: digital

Cameras paired: no

Sampling comments: "Our camera trapping study targeted each year 20 rub trees... to ensure a representative coverage of the core area of the population (600 km2; Groff et al., 2015), we divided the area into four quadrants and selected five rub trees in each, ensuring that the distance between adjacent trees was greater than 3 km. This selection resulted in targeted rub trees (density of 0.05/km2)... Camera traps were set to function continuously... from April to November... We used UV565HD digital camera traps equipped with an infra- red LED flash for video recording... set to work... in continuous across the 24 hours"; there were "9302 camera days over the three years" and it is assumed that 1/3 pertain to 2012

Metadata
Sample number: 1962

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-01-23 20:54:48

Modified: 2016-12-15 10:26:55

Abundance distribution
24 species
5 singletons
total count 3305
extrapolated richness: 35.0
Fisher's α: 3.503
geometric series k: 0.7335
Hurlbert's PIE: 0.7980
Shannon's H: 2.0050
Good's u: 0.9985
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Meles meles7711 kg invertivore-herbivore
Ursus arctos97156 kg frugivore-carnivore
Felis catus3
Canis lupus familiaris11443 kg carnivore
Vulpes vulpes3175.3 kg carnivore-insectivore
Lynx lynx116 kg carnivore
Martes sp.143
Lepus europaeus433.4 kg herbivore
Lepus timidus34
Homo sapiens124864 kg
Apodemus sp.2
Glis glis3
Sciurus vulgaris68311 g
Rupicapra rupicapra25427 kg browser-grazer
Cervus elaphus293104 kg
Equus ferus caballus1422 kg
"Equus caballus"
Ovis gmelini1030 kg
"Ovis musimon"
Capreolus capreolus58422 kg browser
Ovis aries141 kg
Dryocopus martius2321 g
Pyrrhula pyrrhula15.2 g granivore
Garrulus glandarius6 insectivore
Nucifraga caryocatactes1
Turdus sp.2