Tags


Click a tag to remove it from package

Edit Species Groups of Package

Edit Parameter of Package

Edit DOI Package

Choose a project for this package

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

829 Global EPTO Database

DOI Info:

  • DOI: 10.18728/igb-fred-829.3
  • How to cite: 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-03-20 ) Global EPTO Database. IGB Leibniz-Institute of Freshwater Ecology and Inland Fisheries. dataset. https://doi.org/10.18728/igb-fred-829.3
  • Previous DOI version :10.18728/igb-fred-828.2
  • Successor DOI version :10.18728/igb-fred-837.4
  • This Data has been updated! You will be redirected to the latest version within a few seconds. Press STOP to stay on this specific version.

    DOI history

    Date DOI PackageId Note
    2023-01-1810.18728/igb-fred-811.0811
    2023-03-2010.18728/igb-fred-827.1827
    2023-03-2010.18728/igb-fred-828.2828
    2023-03-2010.18728/igb-fred-829.3829this package
    2023-06-2610.18728/igb-fred-837.4837 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.

 

Species Groups
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
The data of this work are licensed under:Attribution-NonCommercial 4.0 International
Project
GLOWABIO Global freshwater biodiversity research Project Website

Metadata files

TitleUpload dateFiletypeLicenceActions
Column_explanation.pdf20. Mar. 2023 15:42.pdfCC BY-NC 4.0 Download
Table_S1.pdf13. Jan. 2023 16:29.pdfCC BY-NC 4.0 Download

Data files (e.g. excel)

TitlecreatedFiletypeActions
Global_EPTO_Database.zip 20. Mar. 2023 15:36 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 free CC BY 4.0 Licence.

  • 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)