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=2029 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2029SELECT 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=2029 ORDER BY register_no ASCSELECT 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='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='Platanus' AND (junior_species='occidentalis' OR junior_species='occidentalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Platanus' AND (species='occidentalis' OR species='occidentalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Platanus' AND (species='occidentalis' OR species='occidentalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platanus' AND (junior_species='occidentalis' OR junior_species='occidentalis')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='Platanus' AND (species='occidentalis' OR species='occidentalis') 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='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='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='Salix' AND (junior_species='nigra' OR junior_species='nigra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Salix' AND (species='nigra' OR species='nigra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Salix' AND (species='nigra' OR species='nigra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Salix' AND (junior_species='nigra' OR junior_species='nigra')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='Salix' AND (species='nigra' OR species='nigra') 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 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 * FROM register WHERE sample_no=2029
The Ecological Register: Northeastern Coastal Plain of Coahuila (Carya illinoinensis forest)
Northeastern Coastal Plain of Coahuila (Carya illinoinensis forest)
Basic information
Sample name: Northeastern Coastal Plain of Coahuila (Carya illinoinensis 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 Biodiversidad82:607-622 [ER 2085]
Geography
Country: Mexico
State: Coahuila
Coordinate:29° 4' N, 100° 41' W
Coordinate basis: based on nearby landmark
Geography comments: "on the banks of the San Diego, San Rodrigo and Arroyo de las Vacas rivers, at elevations ranging from 250 to 300 m"
the 11 sites are centered around Jiménez (basis of coordinate)
Habitat comments: MAT > 22º C and MAP 350 to 500 mm
Methods
Life forms: trees
Sites: 11
Site area: 1.1
Sampling methods: quadrat
Sample size: 333 individuals
Size min: 5
Basal area: 21.27
Sampling comments: "At each site we established a circular plot with an area of 1000 m2"
there appear to be arithmetic errors in the density (ind/ha) figures in table 2, but at least the total of 302.67 appears to be correct; I have simply multiplied the figures by 1.1 and rounded
Metadata
Sample number: 2029
Contributor: John Alroy
Enterer: John Alroy
Created: 2016-06-07 11:45:18
Modified: 2016-06-07 01:45:18
Abundance distribution
10 species
0 singletons
total count 333
extrapolated richness: 12.6
Fisher's α: 1.942
geometric series k: 0.5838
Hurlbert's PIE: 0.4075
Shannon's H: 1.0124
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.