Occurrence Download

A dataset containing 1807 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") yearmonthday, COUNT(*) occurrences, MIN(GBIF_TEMPORALUNCERTAINTY(eventdate, eventtime)) mintemporaluncertainty, MIN(COALESCE(coordinateuncertaintyinmeters, 1000)) mincoordinateuncertaintyinmeters FROM occurrence WHERE occurrence.countrycode = 'FR' AND (occurrence.level0gid = 'FRA.6.8_1' OR occurrence.level1gid = 'FRA.6.8_1' OR occurrence.level2gid = 'FRA.6.8_1' OR occurrence.level3gid = 'FRA.6.8_1') AND (occurrence.decimallatitude >= 49.40535 AND occurrence.decimallatitude = 5.10036 AND occurrence.decimallongitude = 2000.0 OR occurrence.distancefromcentroidinmeters IS NULL) AND NOT occurrence.basisofrecord IN ('FOSSIL_SPECIMEN', 'LIVING_SPECIMEN') AND (occurrence.classificationdetails['d7dddbf4-2cf0-4f39-9b2a-bb099caae36c']['specieskey'] '' AND occurrence."year" IS NOT NULL AND occurrence."month" IS NOT NULL AND occurrence."day" IS NOT NULL) GROUP BY occurrence.kingdom, occurrence.kingdomkey, occurrence.phylum, occurrence.phylumkey, occurrence.class, occurrence.classkey, occurrence."order", occurrence.orderkey, occurrence.family, occurrence.familykey, occurrence.genus, occurrence.genuskey, occurrence.species, occurrence.specieskey, PRINTF('%04d-%02d-%02d', "year", "month", "day") The dataset's 1807 records were derived from 27 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0011112-260208012135463/datasets/export for details. Data from some individual datasets included in this download may be licensed under less restrictive terms.