DOI: 10.15468/dl.dscp33
title: Occurrence Download

description: A dataset containing 750 records in GBIF matching the query:
SELECT
 kingdom,
 kingdomkey,
 phylum,
 phylumkey,
 class,
 classkey,
 "order",
 orderkey,
 family,
 familykey,
 genus,
 genuskey,
 species,
 specieskey,
 GBIF_ISEA3HCODE(10, decimallatitude, decimallongitude, 0.0) isea3hcellcode,
 COUNT(*) occurrences
FROM
 occurrence
WHERE
 occurrence.countrycode = 'FR'
 AND (occurrence.decimallatitude &gt;= 41.28423 AND occurrence.decimallatitude &lt;= 51.10574 AND (occurrence.decimallongitude &gt;= -4.87448 AND occurrence.decimallongitude &lt;= 9.72219) AND GBIF_WITHIN('POLYGON ((2.53221 51.10574, 1.66432 50.96666, 1.5453 50.86235, 1.54798 50.66042, 1.41969 50.14819, 0.8327 49.98265, 0.06645 49.81354, -0.15549 49.49119, -1.00628 49.49648, -1.2705 49.79769, -2.16885 49.8981, -1.69326 48.80422, -2.75014 48.78308, -3.40012 49.06844, -4.87448 48.62455, -4.78464 48.00627, -4.31388 47.67145, -3.5378 47.6621, -3.25704 47.26332, -2.90077 47.27373, -2.65492 47.25707, -2.44236 46.75299, -2.33307 46.54572, -1.9562 46.48919, -1.67234 46.23804, -1.28374 45.6504, -1.27426 45.20493, -1.40222 44.6552, -1.41169 44.29977, -1.58646 43.67595, -1.83555 43.37853, -1.55538 42.99847, -1.06754 42.81695, 0.79873 42.51063, 2.18851 42.23267, 3.32302 42.30074, 3.15642 42.58436, 3.13712 42.91961, 3.25289 43.13427, 3.55679 43.20663, 4.0808 43.3549, 5.27296 43.12372, 6.09343 42.9016, 6.70991 42.956, 7.06348 43.33223, 7.70676 43.6082, 8.46173 42.44621, 8.64554 41.65843, 9.07883 41.28423, 9.39394 41.31049, 9.72219 42.24927, 9.50555 43.14209, 9.27577 43.09614, 9.17074 42.82041, 8.50112 42.49873, 7.75272 43.72637, 7.86722 44.24669, 7.10435 44.37462, 7.13752 44.75369, 7.29176 45.22923, 7.29176 45.87135, 7.39548 46.81634, 8.59793 49.07371, 7.61294 49.25702, 6.70006 49.41641, 5.70749 49.8004, 4.8743 50.03949, 4.91053 50.25684, 4.28745 50.27857, 3.57019 50.72052, 3.04132 50.9199, 2.53221 51.10574))', occurrence.decimallatitude, occurrence.decimallongitude) = TRUE)
 AND occurrence.occurrencestatus = 'PRESENT'
 AND (CAST(occurrence.taxonkey AS INTEGER) = 2494422 OR CAST(occurrence.acceptedtaxonkey AS INTEGER) = 2494422 OR CAST(occurrence.kingdomkey AS INTEGER) = 2494422 OR CAST(occurrence.phylumkey AS INTEGER) = 2494422 OR CAST(occurrence.classkey AS INTEGER) = 2494422 OR CAST(occurrence.orderkey AS INTEGER) = 2494422 OR CAST(occurrence.familykey AS INTEGER) = 2494422 OR CAST(occurrence.genuskey AS INTEGER) = 2494422 OR CAST(occurrence.specieskey AS INTEGER) = 2494422)
 AND occurrence.hasgeospatialissues = FALSE
 AND NOT GBIF_STRINGARRAYCONTAINS(occurrence.issue, 'TAXON_MATCH_FUZZY', TRUE)
 AND (occurrence.distancefromcentroidinmeters &gt;= 2000.0 OR occurrence.distancefromcentroidinmeters IS NULL)
 AND NOT occurrence.basisofrecord IN ('FOSSIL_SPECIMEN', 'LIVING_SPECIMEN')
 AND (occurrence.specieskey IS NOT NULL AND occurrence.hascoordinate = TRUE)
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,
 GBIF_ISEA3HCODE(10, decimallatitude, decimallongitude, 0.0)

 The dataset's 750 records were derived from 5591 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0008622-251009101135966/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.