Occurrence Download

Read full text Summarise with VIRAT
Authors: GBIF.org User
Cited by: 0

Summary

No summary yet. VIRAT can read this paper and write a plain-language summary of its aim, methods, key findings and limitations.

Summarise with VIRAT Free to try with your Science Catalogs account.

Abstract

A dataset containing 4430054 records in GBIF matching the query: SELECT kingdom, kingdomkey, phylum, phylumkey, class, classkey, "order", orderkey, family, familykey, genus, genuskey, species, specieskey, PRINTF('%04d-%02d', "year", "month") yearmonth, GBIF_EEARGCODE(10000, decimallatitude, decimallongitude, 0.0) eeacellcode, IF(ISNULL(kingdomkey), NULL, SUM(COUNT(*)) OVER ( PARTITION BY kingdomkey, GBIF_EEARGCODE(10000, decimallatitude, decimallongitude, 0.0), PRINTF('%04d-%02d', "year", "month"))) kingdomcount, IF(ISNULL(phylumkey), NULL, SUM(COUNT(*)) OVER ( PARTITION BY phylumkey, GBIF_EEARGCODE(10000, decimallatitude, decimallongitude, 0.0), PRINTF('%04d-%02d', "year", "month"))) phylumcount, IF(ISNULL(classkey), NULL, SUM(COUNT(*)) OVER ( PARTITION BY classkey, GBIF_EEARGCODE(10000, decimallatitude, decimallongitude, 0.0), PRINTF('%04d-%02d', "year", "month"))) classcount, IF(ISNULL(orderkey), NULL, SUM(COUNT(*)) OVER ( PARTITION BY orderkey, GBIF_EEARGCODE(10000, decimallatitude, decimallongitude, 0.0), PRINTF('%04d-%02d', "year", "month"))) ordercount, IF(ISNULL(familykey), NULL, SUM(COUNT(*)) OVER ( PARTITION BY familykey, GBIF_EEARGCODE(10000, decimallatitude, decimallongitude, 0.0), PRINTF('%04d-%02d', "year", "month"))) familycount, IF(ISNULL(genuskey), NULL, SUM(COUNT(*)) OVER ( PARTITION BY genuskey, GBIF_EEARGCODE(10000, decimallatitude, decimallongitude, 0.0), PRINTF('%04d-%02d', "year", "month"))) genuscount, COUNT(DISTINCT recordedby) distinctobservers, COUNT(*) occurrences FROM occurrence WHERE occurrence.countrycode = 'PT' AND (occurrence.decimallatitude >= 34.6654 AND occurrence.decimallatitude = -14.05877 AND occurrence.decimallongitude

Fields of Study & Subjects

Species Distribution and Climate Change Ecology and Vegetation Dynamics Studies Botany and Plant Ecology Studies

Publication details

Journal / source
Global Biodiversity Information Facility
Publication date
1 January 2026
Language
EN
Document type
Dataset