Occurrence Download

A dataset containing 947830 records in GBIF matching the query: SELECT "year", GBIF_EEARGCode( 10000, decimalLatitude, decimalLongitude, COALESCE(coordinateUncertaintyInMeters, 1000) ) AS eeaCellCode, classKey, class, speciesKey, species, COUNT(*) AS occurrences, MIN(COALESCE(coordinateUncertaintyInMeters, 1000)) AS minCoordinateUncertaintyInMeters, MIN(GBIF_TEMPORALUNCERTAINTY(eventdate, eventtime)) AS minTemporalUncertainty, IF(ISNULL(classKey), NULL, SUM(COUNT(*)) OVER (PARTITION BY classKey)) AS classCount FROM occurrence WHERE occurrenceStatus = 'PRESENT' AND NOT occurrence.basisofrecord IN ('FOSSIL_SPECIMEN', 'LIVING_SPECIMEN') AND speciesKey IN (5754817, 4567113, 2685484, 2685383, 2685326, 2685580, 2685318, 2685361, 2685552, 2685464, 2685308, 2685654, 2685400, 2369165, 1364478, 1364517, 1364531, 9809222, 5384889, 2398623, 2398675, 2398623, 2398669, 2398682, 2398664, 2398634, 3152633, 3935859, 3152614, 2981303, 2979559, 2979474, 2981177, 2978730, 2979775, 2979000, 2980432, 2978604, 2979408, 2978548, 2978552, 2978771, 2979292, 5370687, 5370688, 5370755, 3056835, 3056259, 8159460, 3056384, 3057221, 4527322, 2064632, 4309455, 2271208, 10595482, 4459446, 1102084, 4449493, 1248774, 4492363, 2392311, 5277297, 1047525, 2153823, 3100375, 3100377, 2408186, 3142611, 1412626, 1412616, 5209181, 5209174, 5209188, 5209173, 5209184, 5209252, 5574054, 5415455, 5415453, 4543508, 4373187, 4543512, 4333247, 4333235, 9240761, 2480637, 7100404, 3189863, 7262908, 3189884, 7262958, 3189866, 3189882, 3189836, 3189846, 3189870, 3189883, 7263145, 3189837) AND speciesKey IS NOT NULL AND GBIF_Within('POLYGON ((-14.31175 30.26388, 68.13666 30.26388, 68.13666 82.96604, -14.31175 82.96604, -14.31175 30.26388)) ', decimalLatitude, decimalLongitude) = TRUE AND "year" >= 1950 AND "year" IS NOT NULL AND hasCoordinate = TRUE AND NOT GBIF_STRINGARRAYCONTAINS(issue, 'ZERO_COORDINATE', TRUE) AND NOT GBIF_STRINGARRAYCONTAINS(issue, 'COORDINATE_OUT_OF_RANGE', TRUE) AND NOT GBIF_STRINGARRAYCONTAINS(issue, 'COORDINATE_INVALID', TRUE) AND NOT GBIF_STRINGARRAYCONTAINS(issue, 'COUNTRY_COORDINATE_MISMATCH', TRUE) AND NOT GBIF_STRINGARRAYCONTAINS(issue, 'TAXON_MATCH_FUZZY', TRUE) AND ( LOWER(identificationVerificationStatus) NOT IN ( 'unverified', 'unvalidated', 'not validated', 'under validation', 'not able to validate', 'control could not be conclusive due to insufficient knowledge', 'uncertain', 'unconfirmed', 'unconfirmed - not reviewed', 'validation requested' ) OR identificationVerificationStatus IS NULL ) GROUP BY "year", eeaCellCode, speciesKey, species, classKey, class ORDER BY "year" DESC, eeaCellCode ASC, speciesKey ASC; The dataset's 947830 records were derived from 6794 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0027377-260208012135463/datasets/export for details. Data from some individual datasets included in this download may be licensed under less restrictive terms.