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=388 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=388SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=175SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=388 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ambystoma' AND (junior_species='texanum' OR junior_species='texanum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ambystoma' AND (species='texanum' OR species='texanum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ambystoma' AND (species='texanum' OR species='texanum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ambystoma' AND (junior_species='texanum' OR junior_species='texanum')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='Ambystoma' AND (species='texanum' OR species='texanum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Siren' AND (junior_species='intermedia' OR junior_species='intermedia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Siren' AND (species='intermedia' OR species='intermedia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Siren' AND (species='intermedia' OR species='intermedia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Siren' AND (junior_species='intermedia' OR junior_species='intermedia')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='Siren' AND (species='intermedia' OR species='intermedia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithobates' AND (junior_species='sphenocephalus' OR junior_species='sphenocephalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lithobates' AND (species='sphenocephalus' OR species='sphenocephalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lithobates' AND (species='sphenocephalus' OR species='sphenocephalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithobates' AND (junior_species='sphenocephalus' OR junior_species='sphenocephalus')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='Lithobates' AND (species='sphenocephalus' OR species='sphenocephalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eumeces' AND (junior_species='fasciatus' OR junior_species='fasciatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eumeces' AND (species='fasciatus' OR species='fasciatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eumeces' AND (species='fasciatus' OR species='fasciatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eumeces' AND (junior_species='fasciatus' OR junior_species='fasciatus')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='Eumeces' AND (species='fasciatus' OR species='fasciatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophis' AND (junior_species='proximus' OR junior_species='proximus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thamnophis' AND (species='proximus' OR species='proximus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thamnophis' AND (species='proximus' OR species='proximus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophis' AND (junior_species='proximus' OR junior_species='proximus')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='Thamnophis' AND (species='proximus' OR species='proximus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eumeces' AND (junior_species='laticeps' OR junior_species='laticeps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eumeces' AND (species='laticeps' OR species='laticeps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eumeces' AND (species='laticeps' OR species='laticeps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eumeces' AND (junior_species='laticeps' OR junior_species='laticeps')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='Eumeces' AND (species='laticeps' OR species='laticeps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scincella' AND (junior_species='lateralis' OR junior_species='lateralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scincella' AND (species='lateralis' OR species='lateralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scincella' AND (species='lateralis' OR species='lateralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scincella' AND (junior_species='lateralis' OR junior_species='lateralis')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='Scincella' AND (species='lateralis' OR species='lateralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nerodia' AND (junior_species='erythrogaster' OR junior_species='erythrogaster')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nerodia' AND (species='erythrogaster' OR species='erythrogaster') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nerodia' AND (species='erythrogaster' OR species='erythrogaster')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nerodia' AND (junior_species='erythrogaster' OR junior_species='erythrogaster')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='Nerodia' AND (species='erythrogaster' OR species='erythrogaster') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agkistrodon' AND (junior_species='piscivorus' OR junior_species='piscivorus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agkistrodon' AND (species='piscivorus' OR species='piscivorus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agkistrodon' AND (species='piscivorus' OR species='piscivorus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agkistrodon' AND (junior_species='piscivorus' OR junior_species='piscivorus')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='Agkistrodon' AND (species='piscivorus' OR species='piscivorus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Storeria' AND (junior_species='dekayi' OR junior_species='dekayii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Storeria' AND (species='dekayi' OR species='dekayii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Storeria' AND (species='dekayi' OR species='dekayii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Storeria' AND (junior_species='dekayi' OR junior_species='dekayii')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='Storeria' AND (species='dekayi' OR species='dekayii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pantherophis' AND (junior_species='obsoleta' OR junior_species='obsoleta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pantherophis' AND (species='obsoleta' OR species='obsoleta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pantherophis' AND (species='obsoleta' OR species='obsoleta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pantherophis' AND (junior_species='obsoleta' OR junior_species='obsoleta')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='Pantherophis' AND (species='obsoleta' OR species='obsoleta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Opheodrys' AND (junior_species='aestivus' OR junior_species='aestivus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Opheodrys' AND (species='aestivus' OR species='aestivus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Opheodrys' AND (species='aestivus' OR species='aestivus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Opheodrys' AND (junior_species='aestivus' OR junior_species='aestivus')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='Opheodrys' AND (species='aestivus' OR species='aestivus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Masticophis' AND (junior_species='flagellum' OR junior_species='flagellum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Masticophis' AND (species='flagellum' OR species='flagellum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Masticophis' AND (species='flagellum' OR species='flagellum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Masticophis' AND (junior_species='flagellum' OR junior_species='flagellum')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='Masticophis' AND (species='flagellum' OR species='flagellum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nerodia' AND (junior_species='rhombifer' OR junior_species='rhombifer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nerodia' AND (species='rhombifer' OR species='rhombifer') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nerodia' AND (species='rhombifer' OR species='rhombifer')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nerodia' AND (junior_species='rhombifer' OR junior_species='rhombifer')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='Nerodia' AND (species='rhombifer' OR species='rhombifer') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Virginia' AND (junior_species='valeriae' OR junior_species='valeriae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Virginia' AND (species='valeriae' OR species='valeriae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Virginia' AND (species='valeriae' OR species='valeriae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Virginia' AND (junior_species='valeriae' OR junior_species='valeriae')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='Virginia' AND (species='valeriae' OR species='valeriae') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=388 The Ecological Register: Old Sabine Bottom Wildlife Management Area (Oil)
Old Sabine Bottom Wildlife Management Area (Oil)
Basic information
Sample name: Old Sabine Bottom Wildlife Management Area (Oil)

Reference: P. M. Hampton and N. B. Ford. 2010. Impacts of active oil pumps and deer feed plots on amphibian and reptile assemblages in a floodplain. American Midland Naturalist 163(1):44-53 [ER 175]
Geography
Country: United States

State: Texas


Coordinate: 32.38° N, -95.27° W
Geography comments: coordinate based on county

Environment
Habitat: temperate broadleaf/mixed forest

Protection: wildlife protected area

Substrate: water edge

WMT: 28.2

CMT: 8.4

MAP: 1432.0

Habitat comments: "nine ephemeral ponds" in "bottomland [hardwood] forest" that is occasionally flooded
climate data based on station 72248 (Shreveport)

Methods
Life forms: lizards,snakes,turtles,frogs,salamanders

Sample size: 158 individuals

Sampling comments: "artificial cover objects and minnow traps"

Metadata
Sample number: 388

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-14 13:10:48

Modified: 2014-04-27 03:53:11

Abundance distribution
15 species
5 singletons
total count 158
extrapolated richness: 25.9
Fisher's α: 4.072
geometric series k: 0.7644
Hurlbert's PIE: 0.8458
Shannon's H: 2.1331
Good's u: 0.9684
Each square represents a species. Square sizes are proportional to counts.
Register