‹ › ×

    FRED
    • Contact
    • GDPR policy
    • Imprint
    • About
    • Sign Up
    • Login
    • SEARCH
    • Search and find
    • Packages
    • Map
    • By Category ...
      • Study sites
      • Sampling sites
      • Parameters
      • Sampling types
      • Species groups
      • Current DOIs

    811 Global EPTO Database

    DOI Info:

    • DOI: 10.18728/igb-fred-811.0
    • Citation suggestion: Afroditi Grigoropoulou https://orcid.org/0000-0002-7884-097X, Suhaila Ab Hamid, Raul Acosta, Emmanuel Olusegun Akindele, Salman A Al-Shami, Florian Altermatt, Giuseppe Amatulli, David G Angeler, Francis O Arimoro, Jukka Aroviita, Anna Astorga-Roine, Rafael Costa Bastos, Nuria Bonada, Nikos Buckas, Cecilia Brand, Vanessa Bremerich, Alex Bush, Qinghua Cai, Marcos Callisto, Kai Chen, Paulo Vilela Cruz, Olivier Dangles, Russell Death, Xiling Deng, Eduardo Dominguez, David Dudgeon, Tor Erik Eriksen, Ana Paula Justino Faria, Maria Joao Feio, Camino Fernandez-Alaez, Mathieu Floury, Francisco Garcia-Criado, Jorge Garcia-Giron, Wolfram Graf, Mira Gronroos, Peter Haase, Neusa Hamada, Fengzhi He, Jani Heino, Ralph Holzenthal, Kaisa-Leena Huttunen, Dean Jacobsen, Sonja C Jähnig, Walter Jetz, Richard K Johnson, Leandro Juen, Vincent Kalkman, Vassiliki Kati, Unique N Keke, Ricardo Koroiva, Mathias Kuemmerlen, Simone Daniela Langhans, Raphael Ligeiro, Kris Van Looy, Alain Maasri, Richard Marchant, Jaime Ricardo Garcia Marquez, Renato Tavares Martins, Adriano S Melo, Leon Metzeling, Maria Laura Miserendino, S Jannicke Moe, Carlos Molineri, Timo Muotka, Kaisa-Riikka Mustonen, Heikki Mykrä, Jeane Marcelle Cavalcante do Nascimento, Francisco Valente-Neto, Peter J Neu, Carolina Nieto, Steffen U Pauls, Dennis R Paulson, Blanca Rios-Touma, Marciel Elio Rodrigues, Fabio de Oliveira Roque, Juan Carlos Salazar Salina, Schmera Denes, Astrid Schmidt-Kloiber, Deep Narayan Shah, John P Simaika, Tadeu Siqueira, Ram Devi Tachamo-Shah, Günther Theischinger, Ross Thompson, Jonathan D Tonkin, Yusdiel Torres-Cambas, Colin Townsend, Eren Turak, Laura Twardochleb, Beixin Wang, Liubov Yanygina, Carmen Zamora, Sami Domisch (2023-01-18 ) Global EPTO Database. IGB Leibniz-Institute of Freshwater Ecology and Inland Fisheries. dataset. https://doi.org/10.18728/igb-fred-811.0
    • DOI history

      Date DOI PackageId Note
      2023-01-1810.18728/igb-fred-811.0811this package latest
    Title
    Global EPTO Database
    Sampling interval
    Irregular Interval
    Description

    Comprehensive table including all the occurrence records of the Global EPTO Database. 

     

    Main type of variables contained: A total of 8,368,467 occurrence records globally, of which 8,319,689 (99%) are publicly available. Each record is attributed to the corresponding drainage basin and sub-catchment based on the high-resolution Hydrography90m dataset and is accompanied by the elevation value of its location based on the MERIT Hydro Digital Elevation Model. In addition, we added for each record the information regarding the respective freshwater ecoregion and protected area status.

     

    Spatial location and grain: The database covers the global spatial extent, with 86% of the observation records having coordinates with at least four decimal digits, corresponding to a 11.1 m precision at the equator, in the WGS84 coordinate reference system. 

     

    Time period and grain: Sampling years span from 1951 to 2021. 99% of the records have information on the year of the observation, 95% on the year and month, while 94% have a complete date, including the day of observation. In the case of 7 sub-datasets, exact dates can be retrieved upon communication with the individual data contributors. 

     

    Major taxa and level of measurement: Ephemeroptera, Plecoptera, Trichoptera and Odonata at the genus taxonomic level.We provide species names for 7,727,980 (93%) records without further taxonomic verification.  

     

    50 datasets are included in the file 'Global_EPTO_Database.csv' (zipped). The link to each individual dataset is available in the 'Table_S1.pdf' and in the column ‘FRED_link-DOI’ within the dataset.

    The 'Table_S1.pdf' can be also found in the Supplementary Material of the publication, in .xlsx format. 

    The whole dataset is visualised in https://geo.igb-berlin.de/ (links can be found in the field "GeoNode references/GeoNode maps") below. 

    For individual dataset visualisation, a link to https://geo.igb-berlin.de/ can be found in the field ‘GeoNode references’ in the FRED entry of each dataset.

     

    Authors: Afroditi Grigoropoulou, Suhaila Ab Hamid, Raúl Acosta, Emmanuel Olusegun Akindele, Salman A. Al-Shami, Florian Altermatt, Giuseppe Amatulli, David G. Angeler, Francis O. Arimoro, Jukka Aroviita, Anna Astorga-Roine, Rafael Costa Bastos, Núria Bonada, Nikos Buckas, Cecilia Brand, Vanessa Bremerich, Alex Bush, Qinghua Cai, Marcos Callisto, Kai Chen, Paulo Vilela Cruz, Olivier Dangles, Russell Death, Xiling Deng, Eduardo Domínguez, David Dudgeon, Tor Erik Eriksen, Ana Paula Justino Faria, Maria João Feio, Camino Fernández-Aláez, Mathieu Floury, Francisco García-Criado, Jorge García-Girón, Wolfram Graf, Mira Gronroos, Peter Haase, Neusa Hamada, Fengzhi He, Jani Heino, Ralph Holzenthal, Kaisa-Leena Huttunen, Dean Jacobsen, Sonja C. Jähnig, Walter Jetz, Richard K. Johnson, Leandro Juen, Vincent Kalkman, Vassiliki Kati, Unique N. Keke, Ricardo Koroiva, Mathias Kuemmerlen, Simone Daniela Langhans, Raphael Ligeiro, Kris Van Looy, Alain Maasri, Richard Marchant, Jaime Ricardo Garcia Marquez, Renato Tavares Martins, Adriano S. Melo, Leon Metzeling, Maria Laura Miserendino, S. Jannicke Moe, Carlos Molineri, Timo Muotka, Kaisa-Riikka Mustonen, Heikki Mykrä, Jeane Marcelle Cavalcante do Nascimento, Francisco Valente-Neto, Peter J. Neu, Carolina Nieto, Steffen U. Pauls, Dennis R. Paulson, Blanca Rios-Touma, Marciel Elio Rodrigues, Fabio de Oliveira Roque, Juan Carlos Salazar Salina, Schmera Dénes, Astrid Schmidt-Kloiber, Deep Narayan Shah, John P. Simaika, Tadeu Siqueira, Ram Devi Tachamo-Shah, Günther Theischinger, Ross Thompson, Jonathan D. Tonkin,, Yusdiel Torres-Cambas, Colin Townsend, Eren Turak, Laura Twardochleb, Beixin Wang, Liubov Yanygina, Carmen Zamora-Muñoz and Sami Domisch

     

    All the metadata details are available in the FRED entries of the individual datasets.

     

    Keywords
    biodiversity, aquatic insects, Ephemeroptera, Plecoptera, Trichoptera, Odonata, observation records, global dataset
    Study site
    _global
    GeoNode references

    GeoNode maps

    • Global EPTO Database - Sites per order
    • Global EPTO Database - Density of sites
    • Datasets of the Global EPTO Database
    Contact
    Afroditi Grigoropoulou
    Licence for data
    All rights reserved. Please send a request to Afroditi Grigoropoulou if you like to use this data. Mind our data policy: IGB Data Policy
    Project
    GLOWABIO Global freshwater biodiversity research Project Website

    Metadata files

    TitleUpload dateFiletypeLicenceActions
    Table_S1.pdf13. Jan. 2023 16:29.pdfODC-By Download
    Column_explanation.pdf30. Nov. 2022 11:25.pdfODC-By Download

    Data files (e.g. excel)

    TitlecreatedFiletypeActions
    Global_EPTO_Database.zip 30. Nov. 2022 12:52 datatable: .zip Download

    Machine Readable Metadata Files

    FRED provides all metadata of this package in a maschine readable format. There is a pure XML file and one EML file in Ecological Metadata Language. Both files are published under the freeODC-ByLicence.

    • Global_EPTO_Database.xml
    • Global_EPTO_Database.eml

    You are about to leaving FRED and visting a third party website. We are not responsible for the content or availability of linked sites.

    To remain on our site, click Cancel.

    Parsing data File

    Estimated Time:

    Why does it take so much time?

    While parsing a file, the database has to perform various tasks, some of them needs a lot of CPU and memory for larger files.

    • preprocessing: means automatic detection of headlines, table body, format values or csv-separators
    • copying: means read the file cell by cell and copy all elements to the database. During this format settings can be calculated (for example iso-time)
    • analyzing: check out for different data types (can be time, numeric or text)