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=587 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=587SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=290SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=587 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phanaeus' AND (junior_species='igneus' OR junior_species='igneus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phanaeus' AND (species='igneus' OR species='igneus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phanaeus' AND (species='igneus' OR species='igneus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phanaeus' AND (junior_species='igneus' OR junior_species='igneus')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='Phanaeus' AND (species='igneus' OR species='igneus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phanaeus' AND (junior_species='vindex' OR junior_species='vindex')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phanaeus' AND (species='vindex' OR species='vindex') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phanaeus' AND (species='vindex' OR species='vindex')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phanaeus' AND (junior_species='vindex' OR junior_species='vindex')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='Phanaeus' AND (species='vindex' OR species='vindex') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' AND (junior_species='chalcites' OR junior_species='chalcites')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canthon' AND (species='chalcites' OR species='chalcites') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthon' AND (species='chalcites' OR species='chalcites')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' AND (junior_species='chalcites' OR junior_species='chalcites')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='Canthon' AND (species='chalcites' OR species='chalcites') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' AND (junior_species='pilularius' OR junior_species='pilularius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canthon' AND (species='pilularius' OR species='pilularius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthon' AND (species='pilularius' OR species='pilularius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthon' AND (junior_species='pilularius' OR junior_species='pilularius')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='Canthon' AND (species='pilularius' OR species='pilularius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Deltochilum' AND (junior_species='gibbosum' OR junior_species='gibbosum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Deltochilum' AND (species='gibbosum' OR species='gibbosum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Deltochilum' AND (species='gibbosum' OR species='gibbosum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Deltochilum' AND (junior_species='gibbosum' OR junior_species='gibbosum')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='Deltochilum' AND (species='gibbosum' OR species='gibbosum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boreocanthon' AND (junior_species='depressipennis' OR junior_species='depressipennis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boreocanthon' AND (species='depressipennis' OR species='depressipennis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boreocanthon' AND (species='depressipennis' OR species='depressipennis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boreocanthon' AND (junior_species='depressipennis' OR junior_species='depressipennis')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='Boreocanthon' AND (species='depressipennis' OR species='depressipennis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanocanthon' AND (junior_species='bispinatus' OR junior_species='bispinatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanocanthon' AND (species='bispinatus' OR species='bispinatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanocanthon' AND (species='bispinatus' OR species='bispinatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanocanthon' AND (junior_species='bispinatus' OR junior_species='bispinatus')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='Melanocanthon' AND (species='bispinatus' OR species='bispinatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanocanthon' AND (junior_species='granulifer' OR junior_species='granulifer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanocanthon' AND (species='granulifer' OR species='granulifer') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanocanthon' AND (species='granulifer' OR species='granulifer')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanocanthon' AND (junior_species='granulifer' OR junior_species='granulifer')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='Melanocanthon' AND (species='granulifer' OR species='granulifer') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ateuchus' AND (junior_species='lecontei' OR junior_species='leconteii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ateuchus' AND (species='lecontei' OR species='leconteii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ateuchus' AND (species='lecontei' OR species='leconteii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ateuchus' AND (junior_species='lecontei' OR junior_species='leconteii')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='Ateuchus' AND (species='lecontei' OR species='leconteii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='pennsylvanicus' OR junior_species='pennsylvanicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='pennsylvanicus' OR species='pennsylvanicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='pennsylvanicus' OR species='pennsylvanicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='pennsylvanicus' OR junior_species='pennsylvanicus')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='Onthophagus' AND (species='pennsylvanicus' OR species='pennsylvanicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='hecate' OR junior_species='hecate')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='hecate' OR species='hecate') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='hecate' OR species='hecate')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='hecate' OR junior_species='hecate')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='Onthophagus' AND (species='hecate' OR species='hecate') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='oklahomensis' OR junior_species='oklahomensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='oklahomensis' OR species='oklahomensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='oklahomensis' OR species='oklahomensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='oklahomensis' OR junior_species='oklahomensis')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='Onthophagus' AND (species='oklahomensis' OR species='oklahomensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='tuberculifrons' OR junior_species='tuberculifrons')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='tuberculifrons' OR species='tuberculifrons') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='tuberculifrons' OR species='tuberculifrons')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='tuberculifrons' OR junior_species='tuberculifrons')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='Onthophagus' AND (species='tuberculifrons' OR species='tuberculifrons') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Copris' AND (junior_species='minutus' OR junior_species='minutus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Copris' AND (species='minutus' OR species='minutus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Copris' AND (species='minutus' OR species='minutus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Copris' AND (junior_species='minutus' OR junior_species='minutus')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='Copris' AND (species='minutus' OR species='minutus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geotrupes' AND (junior_species='egeriei' OR junior_species='egerieii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Geotrupes' AND (species='egeriei' OR species='egerieii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Geotrupes' AND (species='egeriei' OR species='egerieii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geotrupes' AND (junior_species='egeriei' OR junior_species='egerieii')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='Geotrupes' AND (species='egeriei' OR species='egerieii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='campestris' OR junior_species='campestris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphodius' AND (species='campestris' OR species='campestris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphodius' AND (species='campestris' OR species='campestris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='campestris' OR junior_species='campestris')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='Aphodius' AND (species='campestris' OR species='campestris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='lividus' OR junior_species='lividus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphodius' AND (species='lividus' OR species='lividus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphodius' AND (species='lividus' OR species='lividus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='lividus' OR junior_species='lividus')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='Aphodius' AND (species='lividus' OR species='lividus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ataenius' AND (junior_species='imbricatus' OR junior_species='imbricatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ataenius' AND (species='imbricatus' OR species='imbricatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ataenius' AND (species='imbricatus' OR species='imbricatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ataenius' AND (junior_species='imbricatus' OR junior_species='imbricatus')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='Ataenius' AND (species='imbricatus' OR species='imbricatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ataenius' AND (junior_species='platensis' OR junior_species='platensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ataenius' AND (species='platensis' OR species='platensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ataenius' AND (species='platensis' OR species='platensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ataenius' AND (junior_species='platensis' OR junior_species='platensis')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='Ataenius' AND (species='platensis' OR species='platensis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=587 The Ecological Register: Blackbeard Island
Blackbeard Island
Basic information
Sample name: Blackbeard Island

Reference: G. T. Fincher. 1975. Dung beetles of Blackbeard Island (Coleoptera: Scarabaeidae). Coleopterists Bulletin 29(4):319-320 [ER 290]
Geography
Country: United States

State: Georgia


Coordinate: 31° 29' N, 81° 13' W
Coordinate basis: based on nearby landmark

Geography comments: coordinate based on Blackbeard Island

Environment
Habitat: tropical/subtropical moist broadleaf forest

Substrate: ground surface

WMT: 28.7

CMT: 10.8

MAP: 1330.0

Habitat comments: "forested mainly with live oaks"
climate data based on station 72207 (Savannah/Hilton Head International Airport)

Methods
Life forms: scarab beetles

Sampling methods: pitfall traps

Sample size: 19203 individuals

Years: 1970

Days: 4

Nets or traps: 146

Net or trap nights: 584

Sampling comments: "Ninety-six feces-baitedpit traps were placed throughout the island near roadways during the first visit (July 6-9), and 50 traps were placed during the second visit (September 21-24). Swine feces was used as bait, and the traps wereemptiedand baited twice daily"

Metadata
Sample number: 587

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-27 09:49:18

Modified: 2015-09-28 07:32:06

Abundance distribution
19 species
1 singleton
total count 19203
extrapolated richness: 21.4
Fisher's α: 2.081
geometric series k: 0.6234
Hurlbert's PIE: 0.8195
Shannon's H: 1.9183
Good's u: 0.9999
Each square represents a species. Square sizes are proportional to counts.
Register