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=1851 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1851SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1651SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1851 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sigmodon' AND (junior_species='hispidus' OR junior_species='hispidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sigmodon' AND (species='hispidus' OR species='hispidus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sigmodon' AND (junior_species='hispidus' OR junior_species='hispidus')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='Sigmodon' AND (species='hispidus' OR species='hispidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peromyscus' AND (junior_species='leucopus' OR junior_species='leucopus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Peromyscus' AND (species='leucopus' OR species='leucopus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peromyscus' AND (junior_species='leucopus' OR junior_species='leucopus')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='Peromyscus' AND (species='leucopus' OR species='leucopus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Reithrodontomys' AND (junior_species='montanus' OR junior_species='montanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Reithrodontomys' AND (species='montanus' OR species='montanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Reithrodontomys' AND (species='montanus' OR species='montanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Reithrodontomys' AND (junior_species='montanus' OR junior_species='montanus')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='Reithrodontomys' AND (species='montanus' OR species='montanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaetodipus' AND (junior_species='hispidus' OR junior_species='hispidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chaetodipus' AND (species='hispidus' OR species='hispidus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaetodipus' AND (junior_species='hispidus' OR junior_species='hispidus')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='Chaetodipus' AND (species='hispidus' OR species='hispidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onychomys' AND (junior_species='leucogaster' OR junior_species='leucogaster')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onychomys' AND (species='leucogaster' OR species='leucogaster') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onychomys' AND (junior_species='leucogaster' OR junior_species='leucogaster')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='Onychomys' AND (species='leucogaster' OR species='leucogaster') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neotoma' AND (junior_species='micropus' OR junior_species='micropus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neotoma' AND (species='micropus' OR species='micropus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neotoma' AND (junior_species='micropus' OR junior_species='micropus')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='Neotoma' AND (species='micropus' OR species='micropus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Baiomys' AND (junior_species='taylori' OR junior_species='taylorii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Baiomys' AND (species='taylori' OR species='taylorii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Baiomys' AND (junior_species='taylori' OR junior_species='taylorii')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='Baiomys' AND (species='taylori' OR species='taylorii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Reithrodontomys' AND (junior_species='megalotis' OR junior_species='megalotis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Reithrodontomys' AND (species='megalotis' OR species='megalotis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Reithrodontomys' AND (junior_species='megalotis' OR junior_species='megalotis')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='Reithrodontomys' AND (species='megalotis' OR species='megalotis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perognathus' AND (junior_species='flavus' OR junior_species='flavus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perognathus' AND (species='flavus' OR species='flavus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perognathus' AND (junior_species='flavus' OR junior_species='flavus')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='Perognathus' AND (species='flavus' OR species='flavus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dipodomys' AND (junior_species='ordii' OR junior_species='ordi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dipodomys' AND (species='ordii' OR species='ordi') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dipodomys' AND (junior_species='ordii' OR junior_species='ordi')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='Dipodomys' AND (species='ordii' OR species='ordi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ictidomys' AND (junior_species='tridecemlineatus' OR junior_species='tridecemlineatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ictidomys' AND (species='tridecemlineatus' OR species='tridecemlineatus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ictidomys' AND (junior_species='tridecemlineatus' OR junior_species='tridecemlineatus')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='Ictidomys' AND (species='tridecemlineatus' OR species='tridecemlineatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xerospermophilus' AND (junior_species='spilosoma' OR junior_species='spilosoma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xerospermophilus' AND (species='spilosoma' OR species='spilosoma') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xerospermophilus' AND (junior_species='spilosoma' OR junior_species='spilosoma')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='Xerospermophilus' AND (species='spilosoma' OR species='spilosoma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mus' AND (junior_species='musculus' OR junior_species='musculus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mus' AND (species='musculus' OR species='musculus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mus' AND (junior_species='musculus' OR junior_species='musculus')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='Mus' AND (species='musculus' OR species='musculus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neotoma' AND (junior_species='leucodon' OR junior_species='leucodon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neotoma' AND (species='leucodon' OR species='leucodon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neotoma' AND (species='leucodon' OR species='leucodon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neotoma' AND (junior_species='leucodon' OR junior_species='leucodon')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='Neotoma' AND (species='leucodon' OR species='leucodon') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1851 The Ecological Register: Cross Bar Cooperative Management Area
Cross Bar Cooperative Management Area
Basic information
Sample name: Cross Bar Cooperative Management Area

Reference: W. J. Priesmeyer, R. S. Matlack, and R. T. Kazmaier. 2014. Precipitation and fire impacts on small mammals in shortgrass prairie. Prairie Naturalist 46:11-20 [ER 1651]
Geography
Country: United States

State: Texas


Coordinate: 35° 21' N, 101° 51' W
Coordinate basis: based on nearby landmark

Geography comments: "16 km north of Amarillo" (coordinate extrapolated from Amarillo)

Environment
Habitat: temperate savanna

Substrate: ground surface

Disturbance: recent fire

MAT: 13.8

MAP: 497.0

Habitat comments: "a 4,856 ha shortgrass prairie that is situated at the junction of the High Plains and Rolling Plains ecoregions... Currently, this property is ungrazed but had a history of livestock use from 1932 until 1993... We conducted 2-year burns in spring (Mar–Apr) of 2002 and 2003, 2005, 2007, and 2009. We burned four-year treatments in 2003 and 2007"
climate data are for Amarillo and are from Turner et al. (2003, Soil Sci. Soc. Am. J.)

Methods
Life forms: rodents

Sampling methods: line transect,baited,Sherman traps

Sample size: 833 individuals

Years: 2004 - 2009

Seasons: spring,autumn

Nets or traps: 540

Net or trap nights: 17010

Sampling comments: "We divided the Cross Bar CMA into three treatments (e.g., 2-year fire return, 4-year fire return, and 10-year non-burned control) that were replicated three times for a total of nine experimental plots... In 2004, we began sampling small mammals two times per year within one week of prescribed burning. We con- ducted the growing-season sampling session between March and April and the dormant-season sampling session between September and November. We baited traps with oats and provided polyester bedding for thermal cover. Each sampling session consisted of a 2-week period over which nine transects were sampled. Trapping sessions lasted for three consecutive nights for a total of 1,620 trap nights per trapping session. Each transect had 15 stations spaced 15 m apart, sampled with two Sherman live traps (7.6 × 8.9 × 30.4 cm; HB Sherman Trap Company, Tallahassee, FL, USA) at each station, for a total of 18 transects and 540 small mammal live traps"

Metadata
Sample number: 1851

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-12-21 18:39:10

Modified: 2015-12-21 07:39:10

Abundance distribution
14 species
1 singleton
total count 833
extrapolated richness: 16.7
Fisher's α: 2.391
geometric series k: 0.6774
Hurlbert's PIE: 0.8647
Shannon's H: 2.1527
Good's u: 0.9988
Each square represents a species. Square sizes are proportional to counts.
Register