ダウンロード

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}}

The SQL download was generated based on the following parameters provided by the user:

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"

Please cite as

Download as TSV