DOI: 10.15468/dl.s6w6gp
title: Occurrence Download

description: A dataset containing 52336 records in GBIF matching the query:
SELECT
 -- identifiants
 gbifid, occurrenceid, datasetkey, publishingorgkey,

 -- taxonomie
 scientificName, kingdom, phylum, class, "order", family, genus, species,
 taxonkey, acceptedtaxonkey, specieskey, genericname, specificepithet, taxonRank,

 -- dates / statut
 eventDate, "day", "month", "year", occurrenceStatus, basisOfRecord, individualCount, modified,

 -- géo
 decimalLatitude, decimalLongitude, coordinateUncertaintyInMeters, countryCode,

 -- provenance
 datasetName, institutionCode, collectionCode, license,

 -- rang par espèce (la plus récente = rn=1)
 ROW_NUMBER() OVER (
 PARTITION BY speciesKey
 ORDER BY eventDate DESC NULLS LAST, modified DESC NULLS LAST, gbifid DESC
 ) AS rn

 FROM occurrence
 WHERE
 occurrenceStatus = 'PRESENT'
 AND GBIF_Within('POLYGON((-0.62696540257814 44.83893984433639, -0.606868525319881 44.83700591361369, -0.613564747505371 44.83168041255293, -0.612613263492882 44.82663635836818, -0.614905786653996 44.825262909501554, -0.615035831219034 44.823073088341594, -0.60670215973083 44.82189526001835, -0.60296531634044 44.81842342259135, -0.595994604527314 44.820461274111516, -0.589210775998489 44.82537123813, -0.575724355758608 44.81677195552841, -0.573914872111344 44.810741484461, -0.564408332308028 44.81328084833266, -0.556906906087269 44.81250609644465, -0.534696904702319 44.82429168209618, -0.536610999795324 44.825970921908585, -0.533325408508252 44.8278736203793, -0.548000601862399 44.83568740495512, -0.537713527518042 44.84767352395536, -0.539134174040589 44.856924492727984, -0.536694157075253 44.867608111971535, -0.541119996982707 44.868778270970175, -0.535637286066868 44.882393360700526, -0.535238245056216 44.88887522391005, -0.538988865039807 44.90162288302589, -0.547870450785225 44.916694199525466, -0.550601135805705 44.91596883600239, -0.551419492528857 44.91396980290623, -0.553572923104322 44.91518611906768, -0.56203175718993 44.91272684488203, -0.570147542731449 44.912958318734525, -0.569522711565008 44.91033587510324, -0.571082324717217 44.909413298555194, -0.577734997584026 44.90777062927247, -0.580326338487455 44.90900657356239, -0.5757140153383 44.865993443119095, -0.587862617322578 44.860979573954275, -0.593855250666291 44.85318251219275, -0.620065379765616 44.863966746356645, -0.630925713859778 44.8716567986183, -0.634191268819579 44.86536341884081, -0.631450435712986 44.86384255104119, -0.6383230365804 44.860734156546506, -0.638698891050312 44.85916259230479, -0.637010869557431 44.85857442087453, -0.638510357982969 44.85691914862792, -0.636054080525669 44.85505289338499, -0.637144097237905 44.85196809381584, -0.632137777300611 44.851396678727866, -0.633487752003083 44.84637555752382, -0.630439267964461 44.84550920176031, -0.630420855296093 44.84385324305541, -0.62696540257814 44.83893984433639))', decimalLatitude, decimalLongitude) = TRUE

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