Occurrence Download

A dataset containing 7969 records in GBIF matching the query: SELECT kingdom, kingdomkey, phylum, phylumkey, class, classkey, "order", orderkey, family, familykey, genus, genuskey, species, specieskey, "year", GBIF_EEARGCODE(1000, decimallatitude, decimallongitude, 0.0) eeacellcode, COUNT(*) occurrences, MIN(GBIF_TEMPORALUNCERTAINTY(eventdate, eventtime)) mintemporaluncertainty, MIN(COALESCE(coordinateuncertaintyinmeters, 1000)) mincoordinateuncertaintyinmeters FROM occurrence WHERE occurrence.basisofrecord IN ('OBSERVATION', 'MACHINE_OBSERVATION', 'HUMAN_OBSERVATION', 'MATERIAL_SAMPLE', 'MATERIAL_CITATION', 'OCCURRENCE', 'PRESERVED_SPECIMEN') AND occurrence.countrycode = 'BE' AND occurrence.hascoordinate = TRUE AND occurrence.hasgeospatialissues = FALSE AND occurrence.occurrencestatus = 'PRESENT' AND (CAST(occurrence.taxonkey AS INTEGER) = 5218786 OR CAST(occurrence.acceptedtaxonkey AS INTEGER) = 5218786 OR CAST(occurrence.kingdomkey AS INTEGER) = 5218786 OR CAST(occurrence.phylumkey AS INTEGER) = 5218786 OR CAST(occurrence.classkey AS INTEGER) = 5218786 OR CAST(occurrence.orderkey AS INTEGER) = 5218786 OR CAST(occurrence.familykey AS INTEGER) = 5218786 OR CAST(occurrence.genuskey AS INTEGER) = 5218786 OR CAST(occurrence.specieskey AS INTEGER) = 5218786) AND (occurrence."year" >= 2000 AND occurrence."year"