Occurrence Download

A dataset containing 4102631 records in GBIF matching the query: SELECT kingdom, kingdomkey, phylum, phylumkey, class, classkey, "order", orderkey, family, familykey, genus, genuskey, species, specieskey, PRINTF('%04d-%02d-%02d', "year", "month", "day") AS yearmonthday, GBIF_EEARGCODE( 1000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters,1000) ) AS eeacellcode, COUNT(*) AS occurrences FROM occurrence WHERE countrycode = 'BE' AND "year" >= 2016 AND specieskey IS NOT NULL AND hascoordinate AND (occurrence.taxonkey IN ('196', '220') OR occurrence.acceptedtaxonkey IN ('196', '220') OR occurrence.kingdomkey IN ('196', '220') OR occurrence.phylumkey IN ('196', '220') OR occurrence.classkey IN ('196', '220') OR occurrence.orderkey IN ('196', '220') OR occurrence.familykey IN ('196', '220') OR occurrence.genuskey IN ('196', '220') OR occurrence.specieskey IN ('196', '220')) GROUP BY kingdom, kingdomkey, phylum, phylumkey, class, classkey, "order", orderkey, family, familykey, genus, genuskey, species, specieskey, "year", "month", "day", GBIF_EEARGCODE( 1000, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters,1000) ) The dataset's 4102631 records were derived from 65 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0003878-260226173443078/datasets/export for details. Data from some individual datasets included in this download may be licensed under less restrictive terms.