DOI: 10.15468/dl.4nx5qt
title: Occurrence Download

description: A dataset containing 681817 records in GBIF matching the query:
SELECT
 kingdom,
 kingdomkey,
 phylum,
 phylumkey,
 class,
 classkey,
 "order",
 orderkey,
 family,
 familykey,
 genus,
 genuskey,
 species,
 specieskey,
 "year",
 GBIF_EQDGCODE(2, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)) eqdcellcode,
 IF(ISNULL(kingdomkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY kingdomkey, GBIF_EQDGCODE(2, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), "year")) kingdomcount,
 IF(ISNULL(phylumkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY phylumkey, GBIF_EQDGCODE(2, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), "year")) phylumcount,
 IF(ISNULL(classkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY classkey, GBIF_EQDGCODE(2, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), "year")) classcount,
 IF(ISNULL(orderkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY orderkey, GBIF_EQDGCODE(2, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), "year")) ordercount,
 IF(ISNULL(familykey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY familykey, GBIF_EQDGCODE(2, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), "year")) familycount,
 IF(ISNULL(genuskey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY genuskey, GBIF_EQDGCODE(2, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), "year")) genuscount,
 COUNT(*) occurrences,
 MIN(GBIF_TEMPORALUNCERTAINTY(eventdate, eventtime)) mintemporaluncertainty,
 MIN(COALESCE(coordinateuncertaintyinmeters, 1000)) mincoordinateuncertaintyinmeters
FROM
 occurrence
WHERE
 (CAST(occurrence.taxonkey AS INTEGER) IN (2718767, 8427624, 2986302, 2688176, 2925561, 3188642, 2705610, 2730407, 4152259, 12262828, 2684610, 2702503, 2918574, 3176197, 2985930, 2970418, 5401673, 2925303, 5420380, 2888485, 4128792, 8669627, 2925786, 2928783, 3084719, 5358460, 5406755, 5406665, 9568522, 3084611, 3169830, 2705426, 3068937, 5620016, 3172492, 7999386, 2928774, 2979257, 2766636, 5289739, 5289612, 6109637, 2705953, 2985940, 2957966, 5289686, 5548401, 3086282, 3083851, 2930222, 3146717, 2715068, 5289998, 3067891, 2709108, 3103209, 2874173, 3085381, 5679765, 8228544, 2706277, 2891930, 2703243, 4110514, 2874714, 3173340, 3034128, 2925357, 2764202, 7467639, 2854474, 2650774, 5914287, 5381239, 2687632, 5275404, 2995015, 8234521, 3039514, 4083193, 3792084, 2702870, 2651816, 2651826, 2766846, 5329904, 5301979, 2684921) OR CAST(occurrence.acceptedtaxonkey AS INTEGER) IN (2718767, 8427624, 2986302, 2688176, 2925561, 3188642, 2705610, 2730407, 4152259, 12262828, 2684610, 2702503, 2918574, 3176197, 2985930, 2970418, 5401673, 2925303, 5420380, 2888485, 4128792, 8669627, 2925786, 2928783, 3084719, 5358460, 5406755, 5406665, 9568522, 3084611, 3169830, 2705426, 3068937, 5620016, 3172492, 7999386, 2928774, 2979257, 2766636, 5289739, 5289612, 6109637, 2705953, 2985940, 2957966, 5289686, 5548401, 3086282, 3083851, 2930222, 3146717, 2715068, 5289998, 3067891, 2709108, 3103209, 2874173, 3085381, 5679765, 8228544, 2706277, 2891930, 2703243, 4110514, 2874714, 3173340, 3034128, 2925357, 2764202, 7467639, 2854474, 2650774, 5914287, 5381239, 2687632, 5275404, 2995015, 8234521, 3039514, 4083193, 3792084, 2702870, 2651816, 2651826, 2766846, 5329904, 5301979, 2684921) OR CAST(occurrence.kingdomkey AS INTEGER) IN (2718767, 8427624, 2986302, 2688176, 2925561, 3188642, 2705610, 2730407, 4152259, 12262828, 2684610, 2702503, 2918574, 3176197, 2985930, 2970418, 5401673, 2925303, 5420380, 2888485, 4128792, 8669627, 2925786, 2928783, 3084719, 5358460, 5406755, 5406665, 9568522, 3084611, 3169830, 2705426, 3068937, 5620016, 3172492, 7999386, 2928774, 2979257, 2766636, 5289739, 5289612, 6109637, 2705953, 2985940, 2957966, 5289686, 5548401, 3086282, 3083851, 2930222, 3146717, 2715068, 5289998, 3067891, 2709108, 3103209, 2874173, 3085381, 5679765, 8228544, 2706277, 2891930, 2703243, 4110514, 2874714, 3173340, 3034128, 2925357, 2764202, 7467639, 2854474, 2650774, 5914287, 5381239, 2687632, 5275404, 2995015, 8234521, 3039514, 4083193, 3792084, 2702870, 2651816, 2651826, 2766846, 5329904, 5301979, 2684921) OR CAST(occurrence.phylumkey AS INTEGER) IN (2718767, 8427624, 2986302, 2688176, 2925561, 3188642, 2705610, 2730407, 4152259, 12262828, 2684610, 2702503, 2918574, 3176197, 2985930, 2970418, 5401673, 2925303, 5420380, 2888485, 4128792, 8669627, 2925786, 2928783, 3084719, 5358460, 5406755, 5406665, 9568522, 3084611, 3169830, 2705426, 3068937, 5620016, 3172492, 7999386, 2928774, 2979257, 2766636, 5289739, 5289612, 6109637, 2705953, 2985940, 2957966, 5289686, 5548401, 3086282, 3083851, 2930222, 3146717, 2715068, 5289998, 3067891, 2709108, 3103209, 2874173, 3085381, 5679765, 8228544, 2706277, 2891930, 2703243, 4110514, 2874714, 3173340, 3034128, 2925357, 2764202, 7467639, 2854474, 2650774, 5914287, 5381239, 2687632, 5275404, 2995015, 8234521, 3039514, 4083193, 3792084, 2702870, 2651816, 2651826, 2766846, 5329904, 5301979, 2684921) OR CAST(occurrence.classkey AS INTEGER) IN (2718767, 8427624, 2986302, 2688176, 2925561, 3188642, 2705610, 2730407, 4152259, 12262828, 2684610, 2702503, 2918574, 3176197, 2985930, 2970418, 5401673, 2925303, 5420380, 2888485, 4128792, 8669627, 2925786, 2928783, 3084719, 5358460, 5406755, 5406665, 9568522, 3084611, 3169830, 2705426, 3068937, 5620016, 3172492, 7999386, 2928774, 2979257, 2766636, 5289739, 5289612, 6109637, 2705953, 2985940, 2957966, 5289686, 5548401, 3086282, 3083851, 2930222, 3146717, 2715068, 5289998, 3067891, 2709108, 3103209, 2874173, 3085381, 5679765, 8228544, 2706277, 2891930, 2703243, 4110514, 2874714, 3173340, 3034128, 2925357, 2764202, 7467639, 2854474, 2650774, 5914287, 5381239, 2687632, 5275404, 2995015, 8234521, 3039514, 4083193, 3792084, 2702870, 2651816, 2651826, 2766846, 5329904, 5301979, 2684921) OR CAST(occurrence.orderkey AS INTEGER) IN (2718767, 8427624, 2986302, 2688176, 2925561, 3188642, 2705610, 2730407, 4152259, 12262828, 2684610, 2702503, 2918574, 3176197, 2985930, 2970418, 5401673, 2925303, 5420380, 2888485, 4128792, 8669627, 2925786, 2928783, 3084719, 5358460, 5406755, 5406665, 9568522, 3084611, 3169830, 2705426, 3068937, 5620016, 3172492, 7999386, 2928774, 2979257, 2766636, 5289739, 5289612, 6109637, 2705953, 2985940, 2957966, 5289686, 5548401, 3086282, 3083851, 2930222, 3146717, 2715068, 5289998, 3067891, 2709108, 3103209, 2874173, 3085381, 5679765, 8228544, 2706277, 2891930, 2703243, 4110514, 2874714, 3173340, 3034128, 2925357, 2764202, 7467639, 2854474, 2650774, 5914287, 5381239, 2687632, 5275404, 2995015, 8234521, 3039514, 4083193, 3792084, 2702870, 2651816, 2651826, 2766846, 5329904, 5301979, 2684921) OR CAST(occurrence.familykey AS INTEGER) IN (2718767, 8427624, 2986302, 2688176, 2925561, 3188642, 2705610, 2730407, 4152259, 12262828, 2684610, 2702503, 2918574, 3176197, 2985930, 2970418, 5401673, 2925303, 5420380, 2888485, 4128792, 8669627, 2925786, 2928783, 3084719, 5358460, 5406755, 5406665, 9568522, 3084611, 3169830, 2705426, 3068937, 5620016, 3172492, 7999386, 2928774, 2979257, 2766636, 5289739, 5289612, 6109637, 2705953, 2985940, 2957966, 5289686, 5548401, 3086282, 3083851, 2930222, 3146717, 2715068, 5289998, 3067891, 2709108, 3103209, 2874173, 3085381, 5679765, 8228544, 2706277, 2891930, 2703243, 4110514, 2874714, 3173340, 3034128, 2925357, 2764202, 7467639, 2854474, 2650774, 5914287, 5381239, 2687632, 5275404, 2995015, 8234521, 3039514, 4083193, 3792084, 2702870, 2651816, 2651826, 2766846, 5329904, 5301979, 2684921) OR CAST(occurrence.genuskey AS INTEGER) IN (2718767, 8427624, 2986302, 2688176, 2925561, 3188642, 2705610, 2730407, 4152259, 12262828, 2684610, 2702503, 2918574, 3176197, 2985930, 2970418, 5401673, 2925303, 5420380, 2888485, 4128792, 8669627, 2925786, 2928783, 3084719, 5358460, 5406755, 5406665, 9568522, 3084611, 3169830, 2705426, 3068937, 5620016, 3172492, 7999386, 2928774, 2979257, 2766636, 5289739, 5289612, 6109637, 2705953, 2985940, 2957966, 5289686, 5548401, 3086282, 3083851, 2930222, 3146717, 2715068, 5289998, 3067891, 2709108, 3103209, 2874173, 3085381, 5679765, 8228544, 2706277, 2891930, 2703243, 4110514, 2874714, 3173340, 3034128, 2925357, 2764202, 7467639, 2854474, 2650774, 5914287, 5381239, 2687632, 5275404, 2995015, 8234521, 3039514, 4083193, 3792084, 2702870, 2651816, 2651826, 2766846, 5329904, 5301979, 2684921) OR CAST(occurrence.specieskey AS INTEGER) IN (2718767, 8427624, 2986302, 2688176, 2925561, 3188642, 2705610, 2730407, 4152259, 12262828, 2684610, 2702503, 2918574, 3176197, 2985930, 2970418, 5401673, 2925303, 5420380, 2888485, 4128792, 8669627, 2925786, 2928783, 3084719, 5358460, 5406755, 5406665, 9568522, 3084611, 3169830, 2705426, 3068937, 5620016, 3172492, 7999386, 2928774, 2979257, 2766636, 5289739, 5289612, 6109637, 2705953, 2985940, 2957966, 5289686, 5548401, 3086282, 3083851, 2930222, 3146717, 2715068, 5289998, 3067891, 2709108, 3103209, 2874173, 3085381, 5679765, 8228544, 2706277, 2891930, 2703243, 4110514, 2874714, 3173340, 3034128, 2925357, 2764202, 7467639, 2854474, 2650774, 5914287, 5381239, 2687632, 5275404, 2995015, 8234521, 3039514, 4083193, 3792084, 2702870, 2651816, 2651826, 2766846, 5329904, 5301979, 2684921))
 AND occurrence.hasgeospatialissues = FALSE
 AND NOT GBIF_STRINGARRAYCONTAINS(occurrence.issue, 'TAXON_MATCH_FUZZY', TRUE)
 AND (occurrence.distancefromcentroidinmeters &gt;= 2000.0 OR occurrence.distancefromcentroidinmeters IS NULL)
 AND NOT occurrence.basisofrecord IN ('FOSSIL_SPECIMEN', 'LIVING_SPECIMEN')
 AND occurrence.occurrencestatus = 'PRESENT'
 AND (occurrence.specieskey IS NOT NULL AND occurrence."year" IS NOT NULL AND occurrence.hascoordinate = TRUE)
GROUP BY
 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",
 GBIF_EQDGCODE(2, occurrence.decimallatitude, occurrence.decimallongitude, COALESCE(occurrence.coordinateuncertaintyinmeters, 1000))

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