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=867 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=867SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=500SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=867 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acromyrmex' AND (junior_species='versicolor' OR junior_species='versicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acromyrmex' AND (species='versicolor' OR species='versicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acromyrmex' AND (species='versicolor' OR species='versicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acromyrmex' AND (junior_species='versicolor' OR junior_species='versicolor')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='Acromyrmex' AND (species='versicolor' OR species='versicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brachymyrmex' AND (junior_species='depilis' OR junior_species='depilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brachymyrmex' AND (species='depilis' OR species='depilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brachymyrmex' AND (species='depilis' OR species='depilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brachymyrmex' AND (junior_species='depilis' OR junior_species='depilis')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='Brachymyrmex' AND (species='depilis' OR species='depilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmecocystus' AND (junior_species='depilis' OR junior_species='depilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrmecocystus' AND (species='depilis' OR species='depilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrmecocystus' AND (species='depilis' OR species='depilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmecocystus' AND (junior_species='depilis' OR junior_species='depilis')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='Myrmecocystus' AND (species='depilis' OR species='depilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmecocystus' AND (junior_species='placodops' OR junior_species='placodops')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrmecocystus' AND (species='placodops' OR species='placodops') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrmecocystus' AND (species='placodops' OR species='placodops')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmecocystus' AND (junior_species='placodops' OR junior_species='placodops')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='Myrmecocystus' AND (species='placodops' OR species='placodops') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neivamyrmex' AND (junior_species='leonardi' OR junior_species='leonardii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neivamyrmex' AND (species='leonardi' OR species='leonardii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neivamyrmex' AND (species='leonardi' OR species='leonardii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neivamyrmex' AND (junior_species='leonardi' OR junior_species='leonardii')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='Neivamyrmex' AND (species='leonardi' OR species='leonardii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='hyatti' OR junior_species='hyattii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='hyatti' OR species='hyattii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='hyatti' OR species='hyattii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='hyatti' OR junior_species='hyattii')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='Pheidole' AND (species='hyatti' OR species='hyattii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='psammophila' OR junior_species='psammophila')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='psammophila' OR species='psammophila') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='psammophila' OR species='psammophila')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='psammophila' OR junior_species='psammophila')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='Pheidole' AND (species='psammophila' OR species='psammophila') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='subdentata' OR junior_species='subdentata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheidole' AND (species='subdentata' OR species='subdentata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheidole' AND (species='subdentata' OR species='subdentata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheidole' AND (junior_species='subdentata' OR junior_species='subdentata')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='Pheidole' AND (species='subdentata' OR species='subdentata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pogonomyrmex' AND (junior_species='apache' OR junior_species='apache')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pogonomyrmex' AND (species='apache' OR species='apache') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pogonomyrmex' AND (species='apache' OR species='apache')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pogonomyrmex' AND (junior_species='apache' OR junior_species='apache')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='Pogonomyrmex' AND (species='apache' OR species='apache') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pogonomyrmex' AND (junior_species='imberbiculus' OR junior_species='imberbiculus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pogonomyrmex' AND (species='imberbiculus' OR species='imberbiculus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pogonomyrmex' AND (species='imberbiculus' OR species='imberbiculus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pogonomyrmex' AND (junior_species='imberbiculus' OR junior_species='imberbiculus')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='Pogonomyrmex' AND (species='imberbiculus' OR species='imberbiculus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pogonomyrmex' AND (junior_species='maricopa' OR junior_species='maricopa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pogonomyrmex' AND (species='maricopa' OR species='maricopa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pogonomyrmex' AND (species='maricopa' OR species='maricopa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pogonomyrmex' AND (junior_species='maricopa' OR junior_species='maricopa')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='Pogonomyrmex' AND (species='maricopa' OR species='maricopa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pogonomyrmex' AND (junior_species='rugosus' OR junior_species='rugosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pogonomyrmex' AND (species='rugosus' OR species='rugosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pogonomyrmex' AND (species='rugosus' OR species='rugosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pogonomyrmex' AND (junior_species='rugosus' OR junior_species='rugosus')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='Pogonomyrmex' AND (species='rugosus' OR species='rugosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphaenogaster' AND (junior_species='cockerelli' OR junior_species='cockerellii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphaenogaster' AND (species='cockerelli' OR species='cockerellii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphaenogaster' AND (species='cockerelli' OR species='cockerellii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphaenogaster' AND (junior_species='cockerelli' OR junior_species='cockerellii')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='Aphaenogaster' AND (species='cockerelli' OR species='cockerellii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dorymyrmex' AND (junior_species='insanus' OR junior_species='insanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dorymyrmex' AND (species='insanus' OR species='insanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dorymyrmex' AND (species='insanus' OR species='insanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dorymyrmex' AND (junior_species='insanus' OR junior_species='insanus')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='Dorymyrmex' AND (species='insanus' OR species='insanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='depilis' OR junior_species='depilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crematogaster' AND (species='depilis' OR species='depilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crematogaster' AND (species='depilis' OR species='depilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crematogaster' AND (junior_species='depilis' OR junior_species='depilis')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='Crematogaster' AND (species='depilis' OR species='depilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyphomyrmex' AND (junior_species='wheeleri' OR junior_species='wheelerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyphomyrmex' AND (species='wheeleri' OR species='wheelerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyphomyrmex' AND (species='wheeleri' OR species='wheelerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyphomyrmex' AND (junior_species='wheeleri' OR junior_species='wheelerii')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='Cyphomyrmex' AND (species='wheeleri' OR species='wheelerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Forelius' AND (junior_species='foetidus' OR junior_species='foetidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Forelius' AND (species='foetidus' OR species='foetidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Forelius' AND (species='foetidus' OR species='foetidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Forelius' AND (junior_species='foetidus' OR junior_species='foetidus')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='Forelius' AND (species='foetidus' OR species='foetidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Forelius' AND (junior_species='pruinosus' OR junior_species='pruinosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Forelius' AND (species='pruinosus' OR species='pruinosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Forelius' AND (species='pruinosus' OR species='pruinosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Forelius' AND (junior_species='pruinosus' OR junior_species='pruinosus')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='Forelius' AND (species='pruinosus' OR species='pruinosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' AND (junior_species='spinosum' OR junior_species='spinosum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetramorium' AND (species='spinosum' OR species='spinosum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetramorium' AND (species='spinosum' OR species='spinosum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramorium' AND (junior_species='spinosum' OR junior_species='spinosum')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='Tetramorium' AND (species='spinosum' OR species='spinosum') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=867 The Ecological Register: Mapimi Biosphere Reserve (Conglomerate Hill)
Mapimi Biosphere Reserve (Conglomerate Hill)
Basic information
Sample name: Mapimi Biosphere Reserve (Conglomerate Hill)

Reference: P. Rojas and C. Fragoso. 2000. Composition, diversity, and distribution of a Chihuahuan Desert ant community (Mapimí , México). Journal of Arid Environments 44:213-227 [ER 500]
Geography
Country: Mexico

State: Durango


Coordinate: 26° 24' N, 103° 51' W
Coordinate basis: based on nearby landmark

Geography comments: the reserve also extends into Coahuila and Chihuahua but is mostly in Durango
coordinate extrapolated from the town of Mapimí
altitude 1100 to 1470 m

Environment
Habitat: desert/xeric shrubland

Protection: biosphere reserve

Substrate: ground surface

MAT: 20.8

MAP: 284.0

Habitat comments: "heterogeneous xerophytic shrub" including "grasslands, shrubs of Larrea tridentata, rosette and mixed shrubs, dunes, and other vegetation subtypes"

Methods
Life forms: ants

Sampling methods: no design,pitfall traps

Sample size: 735 individuals

Years: 1987

Days: 7

Nets or traps: 25

Net or trap nights: 175

Sampling comments: 25 pitfall traps left open for 7 days

Metadata
Sample number: 867

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-04-22 13:46:02

Modified: 2015-10-04 01:31:55

Abundance distribution
19 species
3 singletons
total count 735
extrapolated richness: 25.4
Fisher's α: 3.562
geometric series k: 0.7349
Hurlbert's PIE: 0.7884
Shannon's H: 1.9410
Good's u: 0.9959
Each square represents a species. Square sizes are proportional to counts.
Register