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=1792 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1792SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1302SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1792 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callipepla' AND (junior_species='californica' OR junior_species='californica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Callipepla' AND (species='californica' OR species='californica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Callipepla' AND (species='californica' OR species='californica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callipepla' AND (junior_species='californica' OR junior_species='californica')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='Callipepla' AND (species='californica' OR species='californica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sephanoides' AND (junior_species='sephaniodes' OR junior_species='sephaniodes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sephanoides' AND (species='sephaniodes' OR species='sephaniodes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sephanoides' AND (species='sephaniodes' OR species='sephaniodes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sephanoides' AND (junior_species='sephaniodes' OR junior_species='sephaniodes')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='Sephanoides' AND (species='sephaniodes' OR species='sephaniodes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colaptes' AND (junior_species='pitius' OR junior_species='pitius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colaptes' AND (species='pitius' OR species='pitius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colaptes' AND (species='pitius' OR species='pitius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colaptes' AND (junior_species='pitius' OR junior_species='pitius')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='Colaptes' AND (species='pitius' OR species='pitius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picoides' AND (junior_species='lignarius' OR junior_species='lignarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Picoides' AND (species='lignarius' OR species='lignarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Picoides' AND (species='lignarius' OR species='lignarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picoides' AND (junior_species='lignarius' OR junior_species='lignarius')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='Picoides' AND (species='lignarius' OR species='lignarius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Upucerthia' AND (junior_species='dumetaria' OR junior_species='dumetaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Upucerthia' AND (species='dumetaria' OR species='dumetaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Upucerthia' AND (species='dumetaria' OR species='dumetaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Upucerthia' AND (junior_species='dumetaria' OR junior_species='dumetaria')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='Upucerthia' AND (species='dumetaria' OR species='dumetaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphrastura' AND (junior_species='spinicauda' OR junior_species='spinicauda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphrastura' AND (species='spinicauda' OR species='spinicauda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphrastura' AND (species='spinicauda' OR species='spinicauda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphrastura' AND (junior_species='spinicauda' OR junior_species='spinicauda')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='Aphrastura' AND (species='spinicauda' OR species='spinicauda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptasthenura' AND (junior_species='aegithaloides' OR junior_species='aegithaloides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptasthenura' AND (species='aegithaloides' OR species='aegithaloides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptasthenura' AND (species='aegithaloides' OR species='aegithaloides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptasthenura' AND (junior_species='aegithaloides' OR junior_species='aegithaloides')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='Leptasthenura' AND (species='aegithaloides' OR species='aegithaloides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Asthenes' AND (junior_species='humicola' OR junior_species='humicola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Asthenes' AND (species='humicola' OR species='humicola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Asthenes' AND (species='humicola' OR species='humicola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Asthenes' AND (junior_species='humicola' OR junior_species='humicola')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='Asthenes' AND (species='humicola' OR species='humicola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agriornis' AND (junior_species='livida' OR junior_species='livida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agriornis' AND (species='livida' OR species='livida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agriornis' AND (species='livida' OR species='livida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agriornis' AND (junior_species='livida' OR junior_species='livida')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='Agriornis' AND (species='livida' OR species='livida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xolmis' AND (junior_species='pyrope' OR junior_species='pyrope')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xolmis' AND (species='pyrope' OR species='pyrope') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xolmis' AND (species='pyrope' OR species='pyrope')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xolmis' AND (junior_species='pyrope' OR junior_species='pyrope')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='Xolmis' AND (species='pyrope' OR species='pyrope') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaenia' AND (junior_species='albiceps' OR junior_species='albiceps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaenia' AND (species='albiceps' OR species='albiceps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaenia' AND (species='albiceps' OR species='albiceps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaenia' AND (junior_species='albiceps' OR junior_species='albiceps')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='Elaenia' AND (species='albiceps' OR species='albiceps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anairetes' AND (junior_species='parulus' OR junior_species='parulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anairetes' AND (species='parulus' OR species='parulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anairetes' AND (species='parulus' OR species='parulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anairetes' AND (junior_species='parulus' OR junior_species='parulus')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='Anairetes' AND (species='parulus' OR species='parulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colorhamphus' AND (junior_species='parvirostris' OR junior_species='parvirostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colorhamphus' AND (species='parvirostris' OR species='parvirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colorhamphus' AND (species='parvirostris' OR species='parvirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colorhamphus' AND (junior_species='parvirostris' OR junior_species='parvirostris')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='Colorhamphus' AND (species='parvirostris' OR species='parvirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Troglodytes' AND (junior_species='aedon' OR junior_species='aedon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Troglodytes' AND (species='aedon' OR species='aedon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Troglodytes' AND (species='aedon' OR species='aedon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Troglodytes' AND (junior_species='aedon' OR junior_species='aedon')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='Troglodytes' AND (species='aedon' OR species='aedon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='falklandii' OR junior_species='falklandi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='falklandii' OR species='falklandi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='falklandii' OR species='falklandi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='falklandii' OR junior_species='falklandi')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='falklandii' OR species='falklandi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zonotrichia' AND (junior_species='capensis' OR junior_species='capensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zonotrichia' AND (species='capensis' OR species='capensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zonotrichia' AND (species='capensis' OR species='capensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zonotrichia' AND (junior_species='capensis' OR junior_species='capensis')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='Zonotrichia' AND (species='capensis' OR species='capensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Curaeus' AND (junior_species='curaeus' OR junior_species='curaeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Curaeus' AND (species='curaeus' OR species='curaeus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Curaeus' AND (species='curaeus' OR species='curaeus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Curaeus' AND (junior_species='curaeus' OR junior_species='curaeus')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='Curaeus' AND (species='curaeus' OR species='curaeus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sturnella' AND (junior_species='loyca' OR junior_species='loyca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sturnella' AND (species='loyca' OR species='loyca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sturnella' AND (species='loyca' OR species='loyca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sturnella' AND (junior_species='loyca' OR junior_species='loyca')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='Sturnella' AND (species='loyca' OR species='loyca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrygilus' AND (junior_species='gayi' OR junior_species='gayii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phrygilus' AND (species='gayi' OR species='gayii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phrygilus' AND (species='gayi' OR species='gayii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrygilus' AND (junior_species='gayi' OR junior_species='gayii')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='Phrygilus' AND (species='gayi' OR species='gayii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrygilus' AND (junior_species='fruticeti' OR junior_species='fruticetii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phrygilus' AND (species='fruticeti' OR species='fruticetii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phrygilus' AND (species='fruticeti' OR species='fruticetii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrygilus' AND (junior_species='fruticeti' OR junior_species='fruticetii')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='Phrygilus' AND (species='fruticeti' OR species='fruticetii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrygilus' AND (junior_species='alaudinus' OR junior_species='alaudinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phrygilus' AND (species='alaudinus' OR species='alaudinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phrygilus' AND (species='alaudinus' OR species='alaudinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrygilus' AND (junior_species='alaudinus' OR junior_species='alaudinus')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='Phrygilus' AND (species='alaudinus' OR species='alaudinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diuca' AND (junior_species='diuca' OR junior_species='diuca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diuca' AND (species='diuca' OR species='diuca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diuca' AND (species='diuca' OR species='diuca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diuca' AND (junior_species='diuca' OR junior_species='diuca')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='Diuca' AND (species='diuca' OR species='diuca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carduelis' AND (junior_species='barbata' OR junior_species='barbata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carduelis' AND (species='barbata' OR species='barbata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carduelis' AND (species='barbata' OR species='barbata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carduelis' AND (junior_species='barbata' OR junior_species='barbata')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='Carduelis' AND (species='barbata' OR species='barbata') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1792 The Ecological Register: Estación de Investigaciones Ecológicas Mediterrâneas
Estación de Investigaciones Ecológicas Mediterrâneas
Basic information
Sample name: Estación de Investigaciones Ecológicas Mediterrâneas

Sample aka: San Carlos de Apoquindo

Reference: S. Reid and J. J. Armesto. 2011. Interaction dynamics of avian frugivores and plants in a Chilean Mediterranean shrubland. Journal of Arid Environments 75:221-230 [ER 1302]
Geography
Country: Chile


Coordinate: 33° 23' S, 70° 31' W
Coordinate basis: stated in text

Geography comments: "in San Carlos de Apoquindo... 20 km east of downtown Santiago"
elevation 1050 to 1915 m

•
Environment
Habitat: Mediterranean woodland

Substrate: ground surface

MAT: 14.8

MAP: 434.0

Habitat comments: "matorral... predominantly evergreen sclerophyllous shrubland... Today the entire area is mainly devoted to recreational activities (e.g. hiking, mountain-biking, picnics, and horse riding), but occasional low-intensity grazing by horses and cattle still occurs. Until 1982 limited farming and firewood extraction took place in lowland areas"
"hot-dry summers and cool and mild rainy winters"

Methods
Life forms: birds

Sampling methods: no design,mist nets

Sample size: 193 individuals

Years: 2006

Net or trap nights: 110

Sampling comments: "During the months of maximum ripe fruit production (January-May 2006) we weekly set up four to six mist nets from sunrise to noon" (approximately 5 x 22 = net days)

Metadata
Sample number: 1792

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-10-25 16:11:34

Modified: 2015-10-25 05:11:34

Abundance distribution
23 species
5 singletons
total count 193
extrapolated richness: 37.0
Fisher's α: 6.806
geometric series k: 0.8542
Hurlbert's PIE: 0.9108
Shannon's H: 2.6648
Good's u: 0.9743
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Callipepla californica1312.3 g granivore
Sephanoides sephaniodes265.7 g
Colaptes pitius5159 g insectivore
Picoides lignarius234.0 g insectivore
Upucerthia dumetaria47.1 g insectivore
Aphrastura spinicauda111.5 g
Leptasthenura aegithaloides23.5 g insectivore
Asthenes humicola154.4 g
Agriornis livida1 carnivore
Xolmis pyrope135.3 g
Elaenia albiceps1615.5 g insectivore-frugivore
Anairetes parulus156.2 g insectivore
Colorhamphus parvirostris110.6 g insectivore
Troglodytes aedon71.8 g insectivore
Turdus falklandii12
Zonotrichia capensis322.1 g granivore
Curaeus curaeus483.7 g omnivore
Sturnella loyca2113 g omnivore
Phrygilus gayi2024.9 g granivore
Phrygilus fruticeti538.8 g frugivore
Phrygilus alaudinus21.9 g frugivore
Diuca diuca636.8 g granivore
Carduelis barbata115.5 g