DOI: 10.15468/dl.6vc5p8
title: Occurrence Download

description: A dataset containing 8428533 records in GBIF matching the query:
SELECT PRINTF('%04d-%02d', "year", "month") AS yearMonth, GBIF_EEARGCode( 1000, decimalLatitude, decimalLongitude, COALESCE(coordinateUncertaintyInMeters, 1000) ) AS eeaCellCode, familyKey, family, speciesKey, species, datasetKey, COALESCE(sex, 'NOT_SUPPLIED') AS sex, COALESCE(occurrence.lifestage.concept, 'NOT_SUPPLIED') AS lifestage, COUNT(*) AS occurrences FROM occurrence WHERE countryCode = 'FR' AND occurrenceStatus = 'PRESENT' AND "year" &gt;= 2000 AND hasCoordinate = TRUE AND speciesKey IN (2578415,3204123,2049512,8107588,3465658,5252608,1862517,7792496,5124000,2582112,1862293,10868302,2623806,1311477,2128482,2049512,3203682,1394825,1380587,11339291,2569005,1383378,1376611,2583288,2095352,2583139,2597864,2588159,7398514,1398716,1367416,1364940,1386255,2575077,2578415,1368356,2623806,1364395,1373308,4556282,1375303,4500201,1375103,1373303,5894340,1379754,1749558,12240176,1398771,1365087,2072474,4484532,5259885,5255411,2619156,1379237,3517956,8929087,1380005,1391808,1375162,1368314,1398762,2620585,1741820,2536891,2574583,1739605,12188179,5262446,5878447,3386532,3203611,2611817,2611746,2576657,2618444,2611418,3361963,2574757,2576685,7261759,2432836,2433272,2561040,12188179,3462492,2623806,2575469,2574885,2083970,5252608,2083015,2597954,2611548,1792996,1771245,3524384,2611222,5103998,2583154,1875607,2611410,2620595,1820406,12206766,8581394,2569005,5109882,1873079,1940575,4484527,5020442,4549921,6005825,2187021,1814338,8927100,1216929,2016038,5218878,1749558,2548311,5252608,2574328,5251836,2576515,3498900,5254468,2574583,2615960,5894152,5259902,2552195,5240180,2513815,8606465,2618634,2613980,2562043,3524384,5503589,3466607,2583361,7490263,5509315,3517565,12245799,5265654,5218887,9317615,2493070,2493052,2490719,8202676,2433433,5219243,2433875,7901064,5231763,2492962,7705930,2434255,5219362,5218644,1861319,5739317,2494422,2012126,2069937,7984698,5164206,8067418,4484527,8275777,8294966,5231190,5844936,2492942,2489104,2492943,2491498,2487879,2492606,2492576,2493012,5161787,5712981,7642580,5254458,2558944,3542166,5424036,5251961,8426726,2618364,8242151,3203698,2597789,2611631,5252482,9661097,2569390,2574639,2626078,2573488,5251362,5252601,2611909,7245308,2583315,3514837,2611911,2575106,2569149,2611410,2617004,2611508,2555201,2611222,8107588,2615794,2548374,2611786,2554082,7989271,2563232,2575163,2574627,2567416,3203625,2563160,5258072,2626252,2620494,8107588,2616214,2568251,2618179,2562344,5251668,2619967,2594421,7782820,9733231,3562901,8059984,2563893,7369982,2568833,5254468,7518870,2615939,8360332,5424034,5255244,5262655,2625787,2616163,9713443,2554082,1862765,5124250,5124250,1862837,1747141,1739128,1741056,1384049,1392842,1766205,1766210,1771040,1862401,4525627,1789695,5109855,1873919,1873903,1873051,5126517,1877032,5123971,9687328,2031562,4431356,4990191,1311433,9809229,1428345,4432672,2028238,2036052,1707345,6005594,1782560,4534719,1096893,1536449,5706486,1149372,5858758,9258179,8376501,2611508,2029290,11344292,2042933,2051533,2026035,1386255,2051535,9531777,1399303,2037925,9582548,2068870,5251675,9683310,2284059,10535773,3222355,2598633,2562826,10051494,2611222,10814577,2615812,8242336,5259918,10227831,5895566,2283982,2568796,9302986,4556299,3531130,2283983,2284218,10458857,2611905,4554435,3203607,2611893,7485478,10057300,1048979,1420540,10632956,9860467,9989291,2479226,10447419,10591262,7254555,4556287,4554457,2597936,3503863,5494291,2620657,2598977,2611907,5503589,2617204,5259820,2562826,2282736,2599552,2611897,2284059,2611909,2573666,2616317,4556341,9652118,2623814,2568251,3203651,5262591,7873446,3203674,10183807,7523992,4554372,7440012,10109406,3480020,4281453,5427453,2284122,4554493,9973513,10453360,2598977,7636936,5494300,4556361,2611911,8669905,10210314,2611545,2521367,2593188,3519106,7640526,10499747,2593188,5260301,3479491,10295542,10295542,3505549,2432953,2567857,9751035,9695387,7504660,5251836,2624652,2538993,7254015,5255711,3204123,1379737,5044918,1380025,1379044,1391191,1392156,1378906,1379722,7600425,6348687,2611418,9172435,2562043,5894233,5489282,5489289,5894284,2611746,2526345,5249271,3491355,3389383,7905592,3539673,2611558,3457057,2598066,2619225,2623632,2575558,5894152,2582283,2582036,9269347,2582422,2530373,9025616,8210844,2566117,8190651,4501516,1365532,4556520,10535773,10210741,9929369,9302986,2492462,2492956,10053514,2284059,4556501,4556036,4556615,2284195,2284177,10051494,10825955,10695615,10642219,10295542,10624303,10394864,10230572,10493296,10892964,11796385,10235988,4346564,8321970,1376738,1368310,1379650,1373607,1398751,1384049,1390278,1740623,7663030,8247017,7936811,2086988,8026254,9198247,1737131,1806134,1376477,1396152,1363229,1399303,4502351,1375188,5372392) AND NOT ARRAY_CONTAINS(issue, 'ZERO_COORDINATE') AND NOT ARRAY_CONTAINS(issue, 'COORDINATE_OUT_OF_RANGE') AND NOT ARRAY_CONTAINS(issue, 'COORDINATE_INVALID') AND NOT ARRAY_CONTAINS(issue, 'COUNTRY_COORDINATE_MISMATCH') AND "month" IS NOT NULL GROUP BY yearMonth, datasetKey, eeaCellCode, familyKey, family, speciesKey, species, sex, lifestage ORDER BY yearMonth DESC, eeaCellCode ASC, speciesKey ASC; 

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