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=498 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=498SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=245SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=498 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithobates' AND (junior_species='sylvaticus' OR junior_species='sylvaticus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lithobates' AND (species='sylvaticus' OR species='sylvaticus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lithobates' AND (species='sylvaticus' OR species='sylvaticus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithobates' AND (junior_species='sylvaticus' OR junior_species='sylvaticus')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='sylvaticus' OR species='sylvaticus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anaxyrus' AND (junior_species='americanus' OR junior_species='americanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anaxyrus' AND (species='americanus' OR species='americanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anaxyrus' AND (species='americanus' OR species='americanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anaxyrus' AND (junior_species='americanus' OR junior_species='americanus')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='Anaxyrus' AND (species='americanus' OR species='americanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyla' AND (junior_species='crucifer' OR junior_species='crucifer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hyla' AND (species='crucifer' OR species='crucifer') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hyla' AND (species='crucifer' OR species='crucifer')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyla' AND (junior_species='crucifer' OR junior_species='crucifer')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='Hyla' AND (species='crucifer' OR species='crucifer') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithobates' AND (junior_species='catesbeianus' OR junior_species='catesbeianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lithobates' AND (species='catesbeianus' OR species='catesbeianus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lithobates' AND (species='catesbeianus' OR species='catesbeianus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithobates' AND (junior_species='catesbeianus' OR junior_species='catesbeianus')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='catesbeianus' OR species='catesbeianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithobates' AND (junior_species='palustris' OR junior_species='palustris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lithobates' AND (species='palustris' OR species='palustris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lithobates' AND (species='palustris' OR species='palustris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithobates' AND (junior_species='palustris' OR junior_species='palustris')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='palustris' OR species='palustris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithobates' AND (junior_species='clamitans' OR junior_species='clamitans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lithobates' AND (species='clamitans' OR species='clamitans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lithobates' AND (species='clamitans' OR species='clamitans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithobates' AND (junior_species='clamitans' OR junior_species='clamitans')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='clamitans' OR species='clamitans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ambystoma' AND (junior_species='opacum' OR junior_species='opacum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ambystoma' AND (species='opacum' OR species='opacum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ambystoma' AND (species='opacum' OR species='opacum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ambystoma' AND (junior_species='opacum' OR junior_species='opacum')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='opacum' OR species='opacum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plethodon' AND (junior_species='cinereus' OR junior_species='cinereus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Plethodon' AND (species='cinereus' OR species='cinereus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plethodon' AND (species='cinereus' OR species='cinereus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plethodon' AND (junior_species='cinereus' OR junior_species='cinereus')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='Plethodon' AND (species='cinereus' OR species='cinereus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notophthalmus' AND (junior_species='viridescens' OR junior_species='viridescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Notophthalmus' AND (species='viridescens' OR species='viridescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Notophthalmus' AND (species='viridescens' OR species='viridescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notophthalmus' AND (junior_species='viridescens' OR junior_species='viridescens')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='Notophthalmus' AND (species='viridescens' OR species='viridescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemidactylium' AND (junior_species='scutatum' OR junior_species='scutatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemidactylium' AND (species='scutatum' OR species='scutatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemidactylium' AND (species='scutatum' OR species='scutatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemidactylium' AND (junior_species='scutatum' OR junior_species='scutatum')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='Hemidactylium' AND (species='scutatum' OR species='scutatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ambystoma' AND (junior_species='maculatum' OR junior_species='maculatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ambystoma' AND (species='maculatum' OR species='maculatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ambystoma' AND (species='maculatum' OR species='maculatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ambystoma' AND (junior_species='maculatum' OR junior_species='maculatum')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='maculatum' OR species='maculatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurycea' AND (junior_species='bilineata' OR junior_species='bilineata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurycea' AND (species='bilineata' OR species='bilineata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurycea' AND (species='bilineata' OR species='bilineata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurycea' AND (junior_species='bilineata' OR junior_species='bilineata')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='Eurycea' AND (species='bilineata' OR species='bilineata') 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='Nerodia' AND (junior_species='sipedon' OR junior_species='sipedon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nerodia' AND (species='sipedon' OR species='sipedon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nerodia' AND (species='sipedon' OR species='sipedon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nerodia' AND (junior_species='sipedon' OR junior_species='sipedon')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='sipedon' OR species='sipedon') 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 * FROM register WHERE sample_no=498 The Ecological Register: South Hadley (funnel traps)
South Hadley (funnel traps)
Basic information
Sample name: South Hadley (funnel traps)

Reference: C. L. Jenkins, K. McGarigal, and L. R. Gamble. 2003. Comparative effectiveness of two trapping techniques for surveying the abundance and diversity of reptiles and amphibians along drift fence arrays. Herpetological Review 34(1):39-42 [ER 245]
Geography
Country: United States

State: Massachusetts


Coordinate: 42° 15' 30" N, 72° 34' 30" W
Coordinate basis: based on nearby landmark

Geography comments: coordinate based on South Hadley

Environment
Habitat: temperate broadleaf/mixed forest

Substrate: water edge

WMT: 23.3

CMT: -1.5

MAP: 1198.0

Habitat comments: climate data based on station 72508 (Bradley International Airport)

Methods
Life forms: snakes,frogs,salamanders

Sampling methods: drift fences,funnel traps

Sample size: 1622 individuals

Days: 103

Sampling comments: drift fences were "ca. 2-5 m from the shore"

Metadata
Sample number: 498

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-20 15:12:36

Modified: 2014-04-26 07:38:30

Abundance distribution
15 species
1 singleton
total count 1622
extrapolated richness: 18.9
Fisher's α: 2.284
geometric series k: 0.6416
Hurlbert's PIE: 0.8071
Shannon's H: 1.8596
Good's u: 0.9994
Each square represents a species. Square sizes are proportional to counts.
Register