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.
GeoNode maps
| Title | Upload date | Filetype | Licence | Actions |
|---|---|---|---|---|
| Column_explanation.pdf | 20. Mar. 2023 15:42 | ODC-By | Download | |
| Table_S1.pdf | 13. Jan. 2023 16:29 | ODC-By | Download |
| Title | created | Filetype | Actions |
|---|---|---|---|
| Global_EPTO_Database.zip | 20. Mar. 2023 15:36 | datatable: .zip | Download |
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.
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.
Estimated 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.