Occurrence Download

A dataset containing 330372 records in GBIF matching the query: SELECT -- Dimensions: "month", GBIF_EEARGCode( 50000, decimalLatitude, decimalLongitude, COALESCE(coordinateUncertaintyInMeters, 1000) ) AS eeaCellCode, speciesKey, species, -- Measurements COUNT(*) AS occurrences, SUM(CASE WHEN datasetKey = 'b1047888-ae52-4179-9dd5-5448ea342a24' THEN 1 ELSE 0 END) AS xenoCantoOccurrences, MIN(COALESCE(coordinateUncertaintyInMeters, 1000)) AS minCoordinateUncertaintyInMeters, MIN(GBIF_TemporalUncertainty(eventDate, null)) AS minTemporalUncertainty FROM occurrence WHERE occurrenceStatus = 'PRESENT' AND countryCode = 'DE' AND "year" >= 2000 AND classKey = 212 AND hasCoordinate = TRUE AND (coordinateUncertaintyInMeters