DOI: 10.15468/dl.3apr8n
title: Occurrence Download

description: A dataset containing 1262 records in GBIF matching the query:

SELECT 
 publishingcountry AS countryCode,
 CASE 
 WHEN classKey IN ('359') THEN 'Mammals'
 WHEN classKey IN ('212') THEN 'Birds'
 WHEN familyKey IN ('1103', '1104', '494', '495', '1105', '496', '497', '1106', '498', '499', '1107', '537', '538', '1153', '547', '1162', '548', '549', '550', '1163', '1164', '1165', '1166', '1167', '1305', '1067', '1306', '1307', '1308', '1068', '1069', '587', '1310', '588', '589', '1311', '1312', '1313', '590', '708', '890', '774', '889', '773', '772', '888', '765', '879') THEN 'Bony Fish'
 WHEN classKey IN ('131') THEN 'Amphibians'
 WHEN classKey IN ('216') THEN 'Insects'
 WHEN classKey IN ('11418114', '11569602', '11592253', '11493978') THEN 'Reptiles'
 WHEN phylumKey IN ('52') THEN 'Molluscs'
 WHEN classKey IN ('367') THEN 'Arachnids'
 WHEN classKey IN ('220', '196') THEN 'Flowering Plants'
 WHEN classKey IN ('194', '244', '228', '282') THEN 'Gymnosperms'
 WHEN orderKey IN ('392') THEN 'Ferns'
 WHEN phylumKey IN ('35') THEN 'Mosses'
 WHEN phylumKey IN ('95') THEN 'Sac Fungi'
 WHEN phylumKey IN ('34') THEN 'Basidiomycota'
 END AS taxon_group,
 COUNT(*) AS occurrence_count,
 COUNT(DISTINCT speciesKey) AS species_count
FROM occurrence
WHERE 
 hasCoordinate = TRUE
 AND hasgeospatialissues = FALSE
 AND speciesKey IS NOT NULL
 AND basisOfRecord != 'FOSSIL_SPECIMEN'
 AND taxonrank = 'SPECIES'
 AND publishingcountry IS NOT NULL
 AND "year" &lt;= 2024
 AND (
 classKey IN ('359', '212', '131', '216', '11418114', '11569602', '11592253', '11493978', '367', '220', '196', '194', '244', '228', '282')
 OR familyKey IN ('1103', '1104', '494', '495', '1105', '496', '497', '1106', '498', '499', '1107', '537', '538', '1153', '547', '1162', '548', '549', '550', '1163', '1164', '1165', '1166', '1167', '1305', '1067', '1306', '1307', '1308', '1068', '1069', '587', '1310', '588', '589', '1311', '1312', '1313', '590', '708', '890', '774', '889', '773', '772', '888', '765', '879')
 OR phylumKey IN ('52', '35', '95', '34')
 OR orderKey IN ('392')
 )
GROUP BY 
 publishingcountry,
 CASE 
 WHEN classKey IN ('359') THEN 'Mammals'
 WHEN classKey IN ('212') THEN 'Birds'
 WHEN familyKey IN ('1103', '1104', '494', '495', '1105', '496', '497', '1106', '498', '499', '1107', '537', '538', '1153', '547', '1162', '548', '549', '550', '1163', '1164', '1165', '1166', '1167', '1305', '1067', '1306', '1307', '1308', '1068', '1069', '587', '1310', '588', '589', '1311', '1312', '1313', '590', '708', '890', '774', '889', '773', '772', '888', '765', '879') THEN 'Bony Fish'
 WHEN classKey IN ('131') THEN 'Amphibians'
 WHEN classKey IN ('216') THEN 'Insects'
 WHEN classKey IN ('11418114', '11569602', '11592253', '11493978') THEN 'Reptiles'
 WHEN phylumKey IN ('52') THEN 'Molluscs'
 WHEN classKey IN ('367') THEN 'Arachnids'
 WHEN classKey IN ('220', '196') THEN 'Flowering Plants'
 WHEN classKey IN ('194', '244', '228', '282') THEN 'Gymnosperms'
 WHEN orderKey IN ('392') THEN 'Ferns'
 WHEN phylumKey IN ('35') THEN 'Mosses'
 WHEN phylumKey IN ('95') THEN 'Sac Fungi'
 WHEN phylumKey IN ('34') THEN 'Basidiomycota'
 END
ORDER BY publishingcountry, taxon_group


 The dataset's 1262 records were derived from 51041 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0022048-260208012135463/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.