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=3202 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3202SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2990SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3202 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pantala' AND (junior_species='flavescens' OR junior_species='flavescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pantala' AND (species='flavescens' OR species='flavescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pantala' AND (species='flavescens' OR species='flavescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pantala' AND (junior_species='flavescens' OR junior_species='flavescens')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='Pantala' AND (species='flavescens' OR species='flavescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhyothemis' AND (junior_species='notata' OR junior_species='notata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhyothemis' AND (species='notata' OR species='notata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhyothemis' AND (species='notata' OR species='notata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhyothemis' AND (junior_species='notata' OR junior_species='notata')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='Rhyothemis' AND (species='notata' OR species='notata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palpopleura' AND (junior_species='lucia' OR junior_species='lucia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Palpopleura' AND (species='lucia' OR species='lucia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Palpopleura' AND (species='lucia' OR species='lucia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palpopleura' AND (junior_species='lucia' OR junior_species='lucia')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='Palpopleura' AND (species='lucia' OR species='lucia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palpopleura' AND (junior_species='portia' OR junior_species='portia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Palpopleura' AND (species='portia' OR species='portia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Palpopleura' AND (species='portia' OR species='portia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palpopleura' AND (junior_species='portia' OR junior_species='portia')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='Palpopleura' AND (species='portia' OR species='portia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trithemis' AND (junior_species='kalula' OR junior_species='kalula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trithemis' AND (species='kalula' OR species='kalula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trithemis' AND (species='kalula' OR species='kalula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trithemis' AND (junior_species='kalula' OR junior_species='kalula')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='Trithemis' AND (species='kalula' OR species='kalula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trithemis' AND (junior_species='dichroa' OR junior_species='dichroa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trithemis' AND (species='dichroa' OR species='dichroa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trithemis' AND (species='dichroa' OR species='dichroa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trithemis' AND (junior_species='dichroa' OR junior_species='dichroa')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='Trithemis' AND (species='dichroa' OR species='dichroa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trithemis' AND (junior_species='dorsalis' OR junior_species='dorsalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trithemis' AND (species='dorsalis' OR species='dorsalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trithemis' AND (species='dorsalis' OR species='dorsalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trithemis' AND (junior_species='dorsalis' OR junior_species='dorsalis')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='Trithemis' AND (species='dorsalis' OR species='dorsalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocothemis' AND (junior_species='divisa' OR junior_species='divisa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crocothemis' AND (species='divisa' OR species='divisa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crocothemis' AND (species='divisa' OR species='divisa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocothemis' AND (junior_species='divisa' OR junior_species='divisa')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='Crocothemis' AND (species='divisa' OR species='divisa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocothemis' AND (junior_species='erythraea' OR junior_species='erythraea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crocothemis' AND (species='erythraea' OR species='erythraea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crocothemis' AND (species='erythraea' OR species='erythraea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocothemis' AND (junior_species='erythraea' OR junior_species='erythraea')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='Crocothemis' AND (species='erythraea' OR species='erythraea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='austeni' OR junior_species='austenii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthetrum' AND (species='austeni' OR species='austenii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthetrum' AND (species='austeni' OR species='austenii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='austeni' OR junior_species='austenii')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='Orthetrum' AND (species='austeni' OR species='austenii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='angustiventre' OR junior_species='angustiventre')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthetrum' AND (species='angustiventre' OR species='angustiventre') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthetrum' AND (species='angustiventre' OR species='angustiventre')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='angustiventre' OR junior_species='angustiventre')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='Orthetrum' AND (species='angustiventre' OR species='angustiventre') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bradinopyga' AND (junior_species='strachani' OR junior_species='strachanii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bradinopyga' AND (species='strachani' OR species='strachanii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bradinopyga' AND (species='strachani' OR species='strachanii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bradinopyga' AND (junior_species='strachani' OR junior_species='strachanii')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='Bradinopyga' AND (species='strachani' OR species='strachanii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='chrysostigma' OR junior_species='chrysostigma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthetrum' AND (species='chrysostigma' OR species='chrysostigma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthetrum' AND (species='chrysostigma' OR species='chrysostigma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='chrysostigma' OR junior_species='chrysostigma')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='Orthetrum' AND (species='chrysostigma' OR species='chrysostigma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='julia' OR junior_species='julia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthetrum' AND (species='julia' OR species='julia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthetrum' AND (species='julia' OR species='julia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='julia' OR junior_species='julia')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='Orthetrum' AND (species='julia' OR species='julia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macromia' AND (junior_species='selysi' OR junior_species='selysii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macromia' AND (species='selysi' OR species='selysii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macromia' AND (species='selysi' OR species='selysii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macromia' AND (junior_species='selysi' OR junior_species='selysii')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='Macromia' AND (species='selysi' OR species='selysii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anaciaeschna' AND (junior_species='triangulifera' OR junior_species='triangulifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anaciaeschna' AND (species='triangulifera' OR species='triangulifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anaciaeschna' AND (species='triangulifera' OR species='triangulifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anaciaeschna' AND (junior_species='triangulifera' OR junior_species='triangulifera')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='Anaciaeschna' AND (species='triangulifera' OR species='triangulifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sapho' AND (junior_species='ciliata' OR junior_species='ciliata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sapho' AND (species='ciliata' OR species='ciliata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sapho' AND (species='ciliata' OR species='ciliata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sapho' AND (junior_species='ciliata' OR junior_species='ciliata')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='Sapho' AND (species='ciliata' OR species='ciliata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocypha' AND (junior_species='dispar' OR junior_species='dispar')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlorocypha' AND (species='dispar' OR species='dispar') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlorocypha' AND (species='dispar' OR species='dispar')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocypha' AND (junior_species='dispar' OR junior_species='dispar')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='Chlorocypha' AND (species='dispar' OR species='dispar') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3202 The Ecological Register: Freetown
Freetown
Basic information
Sample name: Freetown

Reference: W. F. Kirby. 1900. Report on the Neuroptera Odonata collected by Mr. E. E. Austen at Sierra Leone during August and September 1899. Annals and Magazine of Natural History 6:67-79 [ER 2990]
Geography
Country: Sierra Leone


Coordinate: 8° 29' N, 13° 14' W
Coordinate basis: based on nearby landmark

Geography comments: from "Freetown" (basis of coordinate)

Environment
Habitat: tropical/subtropical moist broadleaf forest

Protection: unprotected

Substrate: ground surface

Methods
Life forms: odonates

Sampling methods: no design

Sample size: 183 individuals

Years: 1899

Sampling comments: all specimens were collected in August and September of 1899 by E. E. Austen

Metadata
Sample number: 3202

Contributor: John Alroy

Enterer: John Alroy

Created: 2019-02-03 19:16:06

Modified: 2019-02-03 08:16:06

Abundance distribution
18 species
3 singletons
total count 183
extrapolated richness: 28.6
Fisher's α: 4.949
geometric series k: 0.7994
Hurlbert's PIE: 0.8483
Shannon's H: 2.2141
Good's u: 0.9838
Each square represents a species. Square sizes are proportional to counts.
Register