DOI10.15468/dl.5mnda8

Please cite as

GBIF.org (03 March 2025) GBIF Occurrence Download https://doi.org/10.15468/dl.5mnda8
Copy BibTex RIS

 

Лицензия
Файл
23 KB SQL TSV zip
Включенные наборы данных
{{ 3783 | localNumber}}
Involved publishers
{{ 230 | localNumber}}
Involved publishing countries
{{ 31 | localNumber}}
Запрос SQL для загрузки был сгенерирован на основе параметров, предоставленных пользователем
Taxonomic dimension
Вид
Temporal dimension
Год
Randomize points within uncertainty circle
Да
Occurrence count at higher taxonomic level
Царство, Тип / Отдел, Класс, Отряд / Порядок, Семейство, Род
Include minimum coordinate uncertainty
Нет
Include minimum temporal uncertainty
Нет
Predicate
    И Применить все
  • Континент EUROPE
  • Латинское название 785
SELECT kingdom, kingdomkey, phylum, phylumkey, class, classkey, "order", orderkey, family, familykey, genus, genuskey, species, specieskey, "year", IF(ISNULL(kingdomkey), NULL, SUM(COUNT(*)) OVER ( PARTITION BY kingdomkey, "year")) kingdomcount, IF(ISNULL(phylumkey), NULL, SUM(COUNT(*)) OVER ( PARTITION BY phylumkey, "year")) phylumcount, IF(ISNULL(classkey), NULL, SUM(COUNT(*)) OVER ( PARTITION BY classkey, "year")) classcount, IF(ISNULL(orderkey), NULL, SUM(COUNT(*)) OVER ( PARTITION BY orderkey, "year")) ordercount, IF(ISNULL(familykey), NULL, SUM(COUNT(*)) OVER ( PARTITION BY familykey, "year")) familycount, IF(ISNULL(genuskey), NULL, SUM(COUNT(*)) OVER ( PARTITION BY genuskey, "year")) genuscount, COUNT(*) occurrences FROM occurrence WHERE occurrence.continent = 'EUROPE' AND (occurrence.taxonkey = 785 OR occurrence.acceptedtaxonkey = 785 OR occurrence.kingdomkey = 785 OR occurrence.phylumkey = 785 OR occurrence.classkey = 785 OR occurrence.orderkey = 785 OR occurrence.familykey = 785 OR occurrence.genuskey = 785 OR occurrence.subgenuskey = 785 OR occurrence.specieskey = 785) AND (occurrence.specieskey IS NOT NULL AND occurrence."year" IS NOT NULL) GROUP BY occurrence.taxonrank, occurrence.taxonomicstatus, occurrence.kingdom, occurrence.kingdomkey, occurrence.phylum, occurrence.phylumkey, occurrence.class, occurrence.classkey, occurrence."order", occurrence.orderkey, occurrence.family, occurrence.familykey, occurrence.genus, occurrence.genuskey, occurrence.species, occurrence.specieskey, occurrence."year"

Download as TSV