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=2028 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2028SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2085SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2028 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='fusiformis' OR junior_species='fusiformis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quercus' AND (species='fusiformis' OR species='fusiformis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quercus' AND (species='fusiformis' OR species='fusiformis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='fusiformis' OR junior_species='fusiformis')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='Quercus' AND (species='fusiformis' OR species='fusiformis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celtis' AND (junior_species='reticulata' OR junior_species='reticulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Celtis' AND (species='reticulata' OR species='reticulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Celtis' AND (species='reticulata' OR species='reticulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celtis' AND (junior_species='reticulata' OR junior_species='reticulata')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='Celtis' AND (species='reticulata' OR species='reticulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='texana' OR junior_species='texana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diospyros' AND (species='texana' OR species='texana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='texana' OR species='texana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='texana' OR junior_species='texana')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='Diospyros' AND (species='texana' OR species='texana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carya' AND (junior_species='illinoinensis' OR junior_species='illinoinensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carya' AND (species='illinoinensis' OR species='illinoinensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carya' AND (species='illinoinensis' OR species='illinoinensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carya' AND (junior_species='illinoinensis' OR junior_species='illinoinensis')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='Carya' AND (species='illinoinensis' OR species='illinoinensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prosopis' AND (junior_species='glandulosa' OR junior_species='glandulosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prosopis' AND (species='glandulosa' OR species='glandulosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prosopis' AND (species='glandulosa' OR species='glandulosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prosopis' AND (junior_species='glandulosa' OR junior_species='glandulosa')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='Prosopis' AND (species='glandulosa' OR species='glandulosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bumelia' AND (junior_species='lanuginosa' OR junior_species='lanuginosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bumelia' AND (species='lanuginosa' OR species='lanuginosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bumelia' AND (species='lanuginosa' OR species='lanuginosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bumelia' AND (junior_species='lanuginosa' OR junior_species='lanuginosa')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='Bumelia' AND (species='lanuginosa' OR species='lanuginosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ulmus' AND (junior_species='crassifolia' OR junior_species='crassifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ulmus' AND (species='crassifolia' OR species='crassifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ulmus' AND (species='crassifolia' OR species='crassifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ulmus' AND (junior_species='crassifolia' OR junior_species='crassifolia')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='Ulmus' AND (species='crassifolia' OR species='crassifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vachellia' AND (junior_species='farnesiana' OR junior_species='farnesiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vachellia' AND (species='farnesiana' OR species='farnesiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vachellia' AND (species='farnesiana' OR species='farnesiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vachellia' AND (junior_species='farnesiana' OR junior_species='farnesiana')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='Vachellia' AND (species='farnesiana' OR species='farnesiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Condalia' AND (junior_species='hookeri' OR junior_species='hookerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Condalia' AND (species='hookeri' OR species='hookerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Condalia' AND (species='hookeri' OR species='hookerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Condalia' AND (junior_species='hookeri' OR junior_species='hookerii')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='Condalia' AND (species='hookeri' OR species='hookerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Morus' AND (junior_species='celtidifolia' OR junior_species='celtidifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Morus' AND (species='celtidifolia' OR species='celtidifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Morus' AND (species='celtidifolia' OR species='celtidifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Morus' AND (junior_species='celtidifolia' OR junior_species='celtidifolia')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='Morus' AND (species='celtidifolia' OR species='celtidifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bumelia' AND (junior_species='celastrina' OR junior_species='celastrina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bumelia' AND (species='celastrina' OR species='celastrina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bumelia' AND (species='celastrina' OR species='celastrina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bumelia' AND (junior_species='celastrina' OR junior_species='celastrina')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='Bumelia' AND (species='celastrina' OR species='celastrina') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2028 The Ecological Register: Northeastern Coastal Plain of Coahuila (Quercus fusiformis forest)
Northeastern Coastal Plain of Coahuila (Quercus fusiformis forest)
Basic information
Sample name: Northeastern Coastal Plain of Coahuila (Quercus fusiformis forest)

Reference: J. A. Encina-Domínguez, E. M. Rocha, J. A. Meave, and A. Zárate-Lupercio. 2011. Community structure and oristic composition of Quercus fusiformis and Carya illinoinensis forests of the Northeastern Coastal Plain, Coahuila, Mexico. Revista Mexicana de Biodiversidad 82:607-622 [ER 2085]
Geography
Country: Mexico

State: Coahuila


Coordinate: 29° 4' N, 100° 41' W
Coordinate basis: based on nearby landmark

Geography comments: "along the San Diego and Escondido rivers, as well as in areas south of Ciudad Acuña, at elevations ranging between 270 and 320 m"
the 19 sites are centered around Jiménez (basis of coordinate)

•
Environment
Habitat: tropical/subtropical dry broadleaf forest

Substrate: ground surface

MAT: 22.0

MAP: 425.0

Habitat comments: MAT > 22º C and MAP 350 to 500 mm

Methods
Life forms: trees

Sites: 19

Site area: 1.9

Sampling methods: quadrat

Sample size: 735 individuals

Size min: 5

Basal area: 24.36

Sampling comments: "At each site we established a circular plot with an area of 1000 m2"

Metadata
Sample number: 2028

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-06-07 11:31:49

Modified: 2016-06-07 01:31:49

Abundance distribution
11 species
2 singletons
total count 735
extrapolated richness: 15.3
Fisher's α: 1.835
geometric series k: 0.5442
Hurlbert's PIE: 0.6027
Shannon's H: 1.3283
Good's u: 0.9973
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Quercus fusiformis439
Celtis reticulata80
Diospyros texana111
Carya illinoinensis37
Prosopis glandulosa30
Bumelia lanuginosa24
Ulmus crassifolia7
Vachellia farnesiana3
"Acacia farnesiana"
Condalia hookeri2
Morus celtidifolia1
Bumelia celastrina1