Occurrence Download

A dataset containing 6762498 records in GBIF matching the query:SELECT 'year', GBIF_EEARGCode(1000, decimalLatitude, decimalLongitude, COALESCE(coordinateUncertaintyInMeters, 1000)) AS eeaCellCode, kingdomKey, kingdom, familyKey, family, speciesKey, species, COUNT() AS occurrences, MIN(COALESCE(coordinateUncertaintyInMeters, 1000)) AS minCoordinateUncertaintyInMeters, MIN(GBIF_TemporalUncertainty(eventDate)) AS minTemporalUncertainty, IF(ISNULL(familyKey), NULL, SUM(COUNT()) OVER (PARTITION BY familyKey)) AS familyCount FROM occurrence WHERE occurrenceStatus = 'PRESENT' AND countryCode = 'DE' AND kingdomKey = 1 AND hasCoordinate = TRUE AND (coordinateUncertaintyInMeters <= 1000 OR coordinateUncertaintyInMeters IS NULL) AND speciesKey IS NOT NULL AND NOT ARRAY_CONTAINS(issue, 'ZERO_COORDINATE') AND NOT ARRAY_CONTAINS(issue, 'COORDINATE_OUT_OF_RANGE') AND NOT ARRAY_CONTAINS(issue, 'COORDINATE_INVALID') AND NOT ARRAY_CONTAINS(issue, 'COUNTRY_COORDINATE_MISMATCH') GROUP BY 'year', eeaCellCode, kingdomKey, kingdom, familyKey, family, speciesKey, species ORDER BY 'year' DESC, eeaCellCode ASC, speciesKey ASC; The dataset's 6762498 records were derived from 2015 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0015637-240506114902167/datasets/export for details. Data from some individual datasets included in this download may be licensed under less restrictive terms.