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=472 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=472SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=231SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=472 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agkistrodon' AND (junior_species='contortrix' OR junior_species='contortrix')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agkistrodon' AND (species='contortrix' OR species='contortrix') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agkistrodon' AND (species='contortrix' OR species='contortrix')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agkistrodon' AND (junior_species='contortrix' OR junior_species='contortrix')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='contortrix' OR species='contortrix') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carphophis' AND (junior_species='vermis' OR junior_species='vermis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carphophis' AND (species='vermis' OR species='vermis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carphophis' AND (species='vermis' OR species='vermis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carphophis' AND (junior_species='vermis' OR junior_species='vermis')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='Carphophis' AND (species='vermis' OR species='vermis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cemophora' AND (junior_species='coccinea' OR junior_species='coccinea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cemophora' AND (species='coccinea' OR species='coccinea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cemophora' AND (species='coccinea' OR species='coccinea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cemophora' AND (junior_species='coccinea' OR junior_species='coccinea')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='Cemophora' AND (species='coccinea' OR species='coccinea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coluber' AND (junior_species='constrictor' OR junior_species='constrictor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coluber' AND (species='constrictor' OR species='constrictor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coluber' AND (species='constrictor' OR species='constrictor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coluber' AND (junior_species='constrictor' OR junior_species='constrictor')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='Coluber' AND (species='constrictor' OR species='constrictor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diadophis' AND (junior_species='punctatus' OR junior_species='punctatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diadophis' AND (species='punctatus' OR species='punctatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diadophis' AND (species='punctatus' OR species='punctatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diadophis' AND (junior_species='punctatus' OR junior_species='punctatus')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='Diadophis' AND (species='punctatus' OR species='punctatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaphe' AND (junior_species='guttata' OR junior_species='guttata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaphe' AND (species='guttata' OR species='guttata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaphe' AND (species='guttata' OR species='guttata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaphe' AND (junior_species='guttata' OR junior_species='guttata')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='Elaphe' AND (species='guttata' OR species='guttata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heterodon' AND (junior_species='platirhinos' OR junior_species='platirhinos')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heterodon' AND (species='platirhinos' OR species='platirhinos') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heterodon' AND (species='platirhinos' OR species='platirhinos')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heterodon' AND (junior_species='platirhinos' OR junior_species='platirhinos')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='Heterodon' AND (species='platirhinos' OR species='platirhinos') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lampropeltis' AND (junior_species='getula' OR junior_species='getula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lampropeltis' AND (species='getula' OR species='getula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lampropeltis' AND (species='getula' OR species='getula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lampropeltis' AND (junior_species='getula' OR junior_species='getula')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='Lampropeltis' AND (species='getula' OR species='getula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lampropeltis' AND (junior_species='triangulum' OR junior_species='triangulum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lampropeltis' AND (species='triangulum' OR species='triangulum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lampropeltis' AND (species='triangulum' OR species='triangulum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lampropeltis' AND (junior_species='triangulum' OR junior_species='triangulum')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='Lampropeltis' AND (species='triangulum' OR species='triangulum') 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='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='Sistrurus' AND (junior_species='miliarius' OR junior_species='miliarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sistrurus' AND (species='miliarius' OR species='miliarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sistrurus' AND (species='miliarius' OR species='miliarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sistrurus' AND (junior_species='miliarius' OR junior_species='miliarius')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='Sistrurus' AND (species='miliarius' OR species='miliarius') 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='Storeria' AND (junior_species='occipitomaculata' OR junior_species='occipitomaculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Storeria' AND (species='occipitomaculata' OR species='occipitomaculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Storeria' AND (species='occipitomaculata' OR species='occipitomaculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Storeria' AND (junior_species='occipitomaculata' OR junior_species='occipitomaculata')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='occipitomaculata' OR species='occipitomaculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tantilla' AND (junior_species='gracilis' OR junior_species='gracilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tantilla' AND (species='gracilis' OR species='gracilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tantilla' AND (species='gracilis' OR species='gracilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tantilla' AND (junior_species='gracilis' OR junior_species='gracilis')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='Tantilla' AND (species='gracilis' OR species='gracilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophis' AND (junior_species='sirtalis' OR junior_species='sirtalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thamnophis' AND (species='sirtalis' OR species='sirtalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thamnophis' AND (species='sirtalis' OR species='sirtalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophis' AND (junior_species='sirtalis' OR junior_species='sirtalis')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='sirtalis' OR species='sirtalis') 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 senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='carolinensis' OR junior_species='carolinensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anolis' AND (species='carolinensis' OR species='carolinensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anolis' AND (species='carolinensis' OR species='carolinensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='carolinensis' OR junior_species='carolinensis')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='Anolis' AND (species='carolinensis' OR species='carolinensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aspidoscelis' AND (junior_species='sexlineatus' OR junior_species='sexlineatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aspidoscelis' AND (species='sexlineatus' OR species='sexlineatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aspidoscelis' AND (species='sexlineatus' OR species='sexlineatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aspidoscelis' AND (junior_species='sexlineatus' OR junior_species='sexlineatus')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='Aspidoscelis' AND (species='sexlineatus' OR species='sexlineatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eumeces' AND (junior_species='anthracinus' OR junior_species='anthracinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eumeces' AND (species='anthracinus' OR species='anthracinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eumeces' AND (species='anthracinus' OR species='anthracinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eumeces' AND (junior_species='anthracinus' OR junior_species='anthracinus')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='anthracinus' OR species='anthracinus') 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='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='Sceloporus' AND (junior_species='undulatus' OR junior_species='undulatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sceloporus' AND (species='undulatus' OR species='undulatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sceloporus' AND (species='undulatus' OR species='undulatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sceloporus' AND (junior_species='undulatus' OR junior_species='undulatus')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='Sceloporus' AND (species='undulatus' OR species='undulatus') 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 * FROM register WHERE sample_no=472 The Ecological Register: Needle's Eye
Needle's Eye
Basic information
Sample name: Needle's Eye

Sample aka: Jack Mountain range

Reference: V. A. Cobb and J. A. Summerhill. 1996. A one-year study of the species diversity and relative abundance of snakes and lizards in the Jack Mountain region of Hot Spring County, Arkansas. Proceedings Arkansas Academy of Science 50:120-126 [ER 231]
Geography
Country: United States

State: Arkansas


Coordinate: 34° 22' N, 93° 10' W
Coordinate basis: based on nearby landmark

Geography comments: about 5 km north of Bismarck (basis of coordinate) west of U.S. Highway 7

Environment
Habitat: temperate broadleaf/mixed forest

Substrate: ground surface

WMT: 27.5

CMT: 5.1

MAP: 1265.0

Habitat comments: "oak-hickory-pine forest"
climate data based on station 72340 (North Little Rock Municipal Airport)

Methods
Life forms: lizards,snakes

Sampling methods: drift fences,funnel traps,hand capture

Sample size: 235 individuals

Years: 1995

Sampling comments: combination of hand capture and drift fences + funnel traps
recaptures excluded from counts

Metadata
Sample number: 472

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-19 12:14:21

Modified: 2014-04-26 10:05:11

Abundance distribution
24 species
4 singletons
total count 235
extrapolated richness: 36.3
Fisher's α: 6.691
geometric series k: 0.8475
Hurlbert's PIE: 0.8955
Shannon's H: 2.5970
Good's u: 0.9831
Each square represents a species. Square sizes are proportional to counts.
Register