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=1717 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1717SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1184SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1717 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenolophus' AND (junior_species='infuscatus' OR junior_species='infuscatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stenolophus' AND (species='infuscatus' OR species='infuscatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stenolophus' AND (species='infuscatus' OR species='infuscatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenolophus' AND (junior_species='infuscatus' OR junior_species='infuscatus')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='Stenolophus' AND (species='infuscatus' OR species='infuscatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calathus' AND (junior_species='opaculus' OR junior_species='opaculus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calathus' AND (species='opaculus' OR species='opaculus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calathus' AND (species='opaculus' OR species='opaculus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calathus' AND (junior_species='opaculus' OR junior_species='opaculus')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='Calathus' AND (species='opaculus' OR species='opaculus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paratachys' AND (junior_species='pumilus' OR junior_species='pumilus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paratachys' AND (species='pumilus' OR species='pumilus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paratachys' AND (species='pumilus' OR species='pumilus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paratachys' AND (junior_species='pumilus' OR junior_species='pumilus')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='Paratachys' AND (species='pumilus' OR species='pumilus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scarites' AND (junior_species='subterraneus' OR junior_species='subterraneus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scarites' AND (species='subterraneus' OR species='subterraneus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scarites' AND (species='subterraneus' OR species='subterraneus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scarites' AND (junior_species='subterraneus' OR junior_species='subterraneus')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='Scarites' AND (species='subterraneus' OR species='subterraneus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calathus' AND (junior_species='gregarius' OR junior_species='gregarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calathus' AND (species='gregarius' OR species='gregarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calathus' AND (species='gregarius' OR species='gregarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calathus' AND (junior_species='gregarius' OR junior_species='gregarius')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='Calathus' AND (species='gregarius' OR species='gregarius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clivina' AND (junior_species='striatopunctata' OR junior_species='striatopunctata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Clivina' AND (species='striatopunctata' OR species='striatopunctata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Clivina' AND (species='striatopunctata' OR species='striatopunctata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clivina' AND (junior_species='striatopunctata' OR junior_species='striatopunctata')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='Clivina' AND (species='striatopunctata' OR species='striatopunctata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='crassispina' OR junior_species='crassispina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amara' AND (species='crassispina' OR species='crassispina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amara' AND (species='crassispina' OR species='crassispina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='crassispina' OR junior_species='crassispina')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='Amara' AND (species='crassispina' OR species='crassispina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlaenius' AND (junior_species='lithophilus' OR junior_species='lithophilus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlaenius' AND (species='lithophilus' OR species='lithophilus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlaenius' AND (species='lithophilus' OR species='lithophilus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlaenius' AND (junior_species='lithophilus' OR junior_species='lithophilus')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='Chlaenius' AND (species='lithophilus' OR species='lithophilus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agonum' AND (junior_species='lutulentum' OR junior_species='lutulentum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agonum' AND (species='lutulentum' OR species='lutulentum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agonum' AND (species='lutulentum' OR species='lutulentum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agonum' AND (junior_species='lutulentum' OR junior_species='lutulentum')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='Agonum' AND (species='lutulentum' OR species='lutulentum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='rubripes' OR junior_species='rubripes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Harpalus' AND (species='rubripes' OR species='rubripes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Harpalus' AND (species='rubripes' OR species='rubripes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='rubripes' OR junior_species='rubripes')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='Harpalus' AND (species='rubripes' OR species='rubripes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='melanarius' OR junior_species='melanarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterostichus' AND (species='melanarius' OR species='melanarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterostichus' AND (species='melanarius' OR species='melanarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostichus' AND (junior_species='melanarius' OR junior_species='melanarius')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='Pterostichus' AND (species='melanarius' OR species='melanarius') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1717 The Ecological Register: East Pond (shrub thicket)
East Pond (shrub thicket)
Basic information
Sample name: East Pond (shrub thicket)

Sample aka: Jamaica Bay Wildlife Refuge

Reference: Z. Neculiseanu. 2011. Seasonal changes in abundance and diversity of ground beetles (Coleoptera: Carabidae) in two natural habitats of the Jamaica Bay Wildlife Refuge. Oltenia, Studii si Comunicari, Stiintele Naturii 27(2):51-58 [ER 1184]
Geography
Country: United States

State: New York


Coordinate: 40° 37' N, 73° 50' W
Coordinate basis: based on nearby landmark

Geography comments: "on the east side of Cross Bay Boulevard, Queens" (coordinate based on Broad Channel)

•
Environment
Habitat: temperate broadleaf/mixed forest

Protection: wildlife protected area

Substrate: ground surface

Habitat comments: "semi-open, consisting of many species of herbaceous plants, bushes and some scarcely growing trees"

Methods
Life forms: ground beetles

Sampling methods: line transect,pitfall traps

Sample size: 20 individuals

Days: 21

Seasons: spring,summer,autumn

Nets or traps: 10

Net or trap nights: 210

Sampling comments: "10 pitfall traps were installed in May, July and October... The distance between the set traps was 10 m. The traps were exposed for 7 days in each of the above month"

Metadata
Sample number: 1717

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-07-21 20:51:08

Modified: 2015-07-21 10:51:08

Abundance distribution
11 species
8 singletons
total count 20
extrapolated richness: 59.8
Fisher's α: 10.032
geometric series k: 0.8232
Hurlbert's PIE: 0.8158
Shannon's H: 2.0806
Good's u: 0.6052
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Stenolophus infuscatus3
Calathus opaculus7
Paratachys pumilus1
Scarites subterraneus2
Calathus gregarius1
Clivina striatopunctata1
Amara crassispina1
Chlaenius lithophilus1
Agonum lutulentum1
Harpalus rubripes1
Pterostichus melanarius1