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=3189 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3189SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2979SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3189 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalcolestes' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chalcolestes' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chalcolestes' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalcolestes' AND (junior_species='sp.' OR junior_species='sp.')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='Chalcolestes' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lestes' AND (junior_species='barbarus' OR junior_species='barbarus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lestes' AND (species='barbarus' OR species='barbarus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lestes' AND (species='barbarus' OR species='barbarus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lestes' AND (junior_species='barbarus' OR junior_species='barbarus')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='Lestes' AND (species='barbarus' OR species='barbarus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lestes' AND (junior_species='virens' OR junior_species='virens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lestes' AND (species='virens' OR species='virens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lestes' AND (species='virens' OR species='virens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lestes' AND (junior_species='virens' OR junior_species='virens')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='Lestes' AND (species='virens' OR species='virens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythromma' AND (junior_species='viridulum' OR junior_species='viridulum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythromma' AND (species='viridulum' OR species='viridulum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythromma' AND (species='viridulum' OR species='viridulum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythromma' AND (junior_species='viridulum' OR junior_species='viridulum')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='Erythromma' AND (species='viridulum' OR species='viridulum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ischnura' AND (junior_species='elegans' OR junior_species='elegans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ischnura' AND (species='elegans' OR species='elegans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ischnura' AND (species='elegans' OR species='elegans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ischnura' AND (junior_species='elegans' OR junior_species='elegans')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='Ischnura' AND (species='elegans' OR species='elegans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercion' AND (junior_species='lindeni' OR junior_species='lindenii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cercion' AND (species='lindeni' OR species='lindenii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cercion' AND (species='lindeni' OR species='lindenii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercion' AND (junior_species='lindeni' OR junior_species='lindenii')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='Cercion' AND (species='lindeni' OR species='lindenii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coenagrion' AND (junior_species='puella' OR junior_species='puella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coenagrion' AND (species='puella' OR species='puella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coenagrion' AND (species='puella' OR species='puella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coenagrion' AND (junior_species='puella' OR junior_species='puella')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='Coenagrion' AND (species='puella' OR species='puella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coenagrion' AND (junior_species='pulchellum' OR junior_species='pulchellum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coenagrion' AND (species='pulchellum' OR species='pulchellum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coenagrion' AND (species='pulchellum' OR species='pulchellum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coenagrion' AND (junior_species='pulchellum' OR junior_species='pulchellum')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='Coenagrion' AND (species='pulchellum' OR species='pulchellum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coenagrion' AND (junior_species='scitulum' OR junior_species='scitulum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coenagrion' AND (species='scitulum' OR species='scitulum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coenagrion' AND (species='scitulum' OR species='scitulum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coenagrion' AND (junior_species='scitulum' OR junior_species='scitulum')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='Coenagrion' AND (species='scitulum' OR species='scitulum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anax' AND (junior_species='imperator' OR junior_species='imperator')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anax' AND (species='imperator' OR species='imperator') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anax' AND (species='imperator' OR species='imperator')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anax' AND (junior_species='imperator' OR junior_species='imperator')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='Anax' AND (species='imperator' OR species='imperator') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anax' AND (junior_species='parthenope' OR junior_species='parthenope')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anax' AND (species='parthenope' OR species='parthenope') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anax' AND (species='parthenope' OR species='parthenope')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anax' AND (junior_species='parthenope' OR junior_species='parthenope')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='Anax' AND (species='parthenope' OR species='parthenope') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aeshna' AND (junior_species='mixta' OR junior_species='mixta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aeshna' AND (species='mixta' OR species='mixta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aeshna' AND (species='mixta' OR species='mixta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aeshna' AND (junior_species='mixta' OR junior_species='mixta')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='Aeshna' AND (species='mixta' OR species='mixta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aeshna' AND (junior_species='affinis' OR junior_species='affinis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aeshna' AND (species='affinis' OR species='affinis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aeshna' AND (species='affinis' OR species='affinis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aeshna' AND (junior_species='affinis' OR junior_species='affinis')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='Aeshna' AND (species='affinis' OR species='affinis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Libellula' AND (junior_species='depressa' OR junior_species='depressa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Libellula' AND (species='depressa' OR species='depressa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Libellula' AND (species='depressa' OR species='depressa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Libellula' AND (junior_species='depressa' OR junior_species='depressa')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='Libellula' AND (species='depressa' OR species='depressa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='cancellatum' OR junior_species='cancellatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthetrum' AND (species='cancellatum' OR species='cancellatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthetrum' AND (species='cancellatum' OR species='cancellatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='cancellatum' OR junior_species='cancellatum')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='cancellatum' OR species='cancellatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='brunneum' OR junior_species='brunneum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthetrum' AND (species='brunneum' OR species='brunneum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthetrum' AND (species='brunneum' OR species='brunneum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='brunneum' OR junior_species='brunneum')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='brunneum' OR species='brunneum') 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='Sympetrum' AND (junior_species='striolatum' OR junior_species='striolatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sympetrum' AND (species='striolatum' OR species='striolatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sympetrum' AND (species='striolatum' OR species='striolatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sympetrum' AND (junior_species='striolatum' OR junior_species='striolatum')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='Sympetrum' AND (species='striolatum' OR species='striolatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sympetrum' AND (junior_species='fonscolombei' OR junior_species='fonscolombeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sympetrum' AND (species='fonscolombei' OR species='fonscolombeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sympetrum' AND (species='fonscolombei' OR species='fonscolombeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sympetrum' AND (junior_species='fonscolombei' OR junior_species='fonscolombeii')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='Sympetrum' AND (species='fonscolombei' OR species='fonscolombeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sympetrum' AND (junior_species='sanguineum' OR junior_species='sanguineum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sympetrum' AND (species='sanguineum' OR species='sanguineum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sympetrum' AND (species='sanguineum' OR species='sanguineum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sympetrum' AND (junior_species='sanguineum' OR junior_species='sanguineum')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='Sympetrum' AND (species='sanguineum' OR species='sanguineum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sympetrum' AND (junior_species='meridionale' OR junior_species='meridionale')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sympetrum' AND (species='meridionale' OR species='meridionale') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sympetrum' AND (species='meridionale' OR species='meridionale')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sympetrum' AND (junior_species='meridionale' OR junior_species='meridionale')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='Sympetrum' AND (species='meridionale' OR species='meridionale') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sympetrum' AND (junior_species='depressiusculum' OR junior_species='depressiusculum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sympetrum' AND (species='depressiusculum' OR species='depressiusculum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sympetrum' AND (species='depressiusculum' OR species='depressiusculum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sympetrum' AND (junior_species='depressiusculum' OR junior_species='depressiusculum')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='Sympetrum' AND (species='depressiusculum' OR species='depressiusculum') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3189 The Ecological Register: Castel Porziano
Castel Porziano
Basic information
Sample name: Castel Porziano

Reference: G. Carchini, T. Pacione, C. Tanzilli, M. Di Domenico, and A. Solimini. 2004. Temporal variation of an Odonata species assemblage (Rome, Italy). Odonatologica 33(2):157-168 [ER 2979]
Geography
Country: Italy

State: Roma


Coordinate: 41° 45' N, 12° 24' E
Coordinate basis: based on nearby landmark

Geography comments: coordinate based on Castel Porziano

Environment
Habitat: Mediterranean woodland

Protection: unprotected

Substrate: ground surface

Habitat comments: "pristine Mediterranean woodland"

Methods
Life forms: odonates

Sampling methods: no design,other nets

Sample size: 1837 individuals

Years: 1997, 1998

Seasons: spring,summer,autumn

Sampling comments: "records are based on the presence of adults... During 1997, 16 ponds were surveyed from mid-March to October. During 1998 the ponds were increased to 23, and, due to climatic variations, the observation period was from mid April to late November" and specimens were "caught with an entomological net" and marked

Metadata
Sample number: 3189

Contributor: John Alroy

Enterer: John Alroy

Created: 2019-01-05 17:37:42

Modified: 2019-01-05 06:37:42

Abundance distribution
22 species
1 singleton
total count 1837
extrapolated richness: 25.2
Fisher's α: 3.514
geometric series k: 0.7433
Hurlbert's PIE: 0.8657
Shannon's H: 2.3597
Good's u: 0.9995
Each square represents a species. Square sizes are proportional to counts.
Register