DOI: 10.15468/dl.dtbe6u
title: Occurrence Download

description: A dataset containing 330158 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 GBIF_Within('MULTIPOLYGON (((2.2349656415730457 41.42275783256941, 2.1887293999976 41.46029159999787, 2.193263799997123 41.4936159000022, 2.2038111707525445 41.50390311267588, 2.2468007136311927 41.48854456997302, 2.2667978903415755 41.50476507561855, 2.2963315324986535 41.47219237527839, 2.257718251330205 41.452643467671656, 2.2349656415730457 41.42275783256941)), ((1.956264444655135 41.47562348428126, 1.945156989077803 41.467577045303685, 1.9226249999962486 41.48956430000246, 1.936105984951562 41.50781269359385, 1.9691403074462654 41.51207134553003, 1.9786579641829771 41.52324689549234, 2.0068286999970613 41.461304000001995, 2.0337250854075055 41.46988174006392, 2.05801446738336 41.51868603933372, 2.072200987863648 41.5069075995156, 2.1092408999968915 41.50610269999703, 2.109779527860626 41.5210013299452, 2.1331813074279427 41.53386537700864, 2.1611668155602137 41.51593283835202, 2.1887093970667846 41.51621320939198, 2.200278664667438 41.50158036911314, 2.182834199998718 41.48700500000258, 2.152406174634805 41.49356928101658, 2.152567900000483 41.49332520000261, 2.1826661000023324 41.48681410000122, 2.1606692000026073 41.48452400000154, 2.192068700001139 41.48758290000248, 2.1884221000022777 41.46042529999717, 2.2334696224657504 41.41509669569346, 2.1983070899478134 41.38689530281087, 2.185361377293114 41.357735057348506, 2.184663999996441 41.3807063999983, 2.1669062000019097 41.347144000001, 2.150920467056736 41.34648076562265, 2.1484374452905817 41.330104745190106, 2.1662339101568153 41.34122988716327, 2.142947214148816 41.30516505639798, 2.0982892757680363 41.33751297345159, 2.13772765727259 41.29524155782291, 2.0745096783629986 41.27639433584719, 2.0741558109358054 41.276695643891586, 2.0544029999984406 41.28526640000099, 2.0659326629666324 41.27481493772193, 2.048401922789893 41.27034605821672, 2.027330000000653 41.28660400000216, 2.038154700000743 41.276284600000054, 2.019566699999534 41.27946499999668, 2.040714799997331 41.274170299996825, 2.0236514999996023 41.275890900003134, 2.0458652582489547 41.270409134678815, 1.9444739608464525 41.26364549283873, 1.9437410927750436 41.27921632257549, 1.9248784695101788 41.29111976332298, 1.871426738257278 41.27863968176588, 1.8726680127833395 41.29344766494159, 1.846732883446164 41.30635433851917, 1.871806112621233 41.343732104371604, 1.899874711240718 41.35554295774578, 1.946364930116812 41.35062264215848, 1.954102771577166 41.367797093237, 1.9392129244402632 41.39740981800615, 1.9181583103762874 41.388299964132955, 1.8748287937170276 41.39500376053778, 1.8918114552638585 41.43047662885772, 1.9495051022276666 41.44112148150332, 1.956264444655135 41.47562348428126)), ((2.15388068726326 41.297242963339855, 2.1654195307932858 41.31782962511499, 2.1543390177043213 41.29691084872766, 2.15388068726326 41.297242963339855)), ((2.171097243651262 41.335091127798435, 2.183006340024051 41.36522115613686, 2.172609948594235 41.31703854122809, 2.171097243651262 41.335091127798435)))', decimalLatitude, decimalLongitude) = True AND occurrenceStatus = 'PRESENT' AND "year" &gt;= 2000 AND hasCoordinate = TRUE AND speciesKey IN (2492943, 2495000, 2480666, 2492956, 9717283, 9413670, 2474029, 2492462, 2487857, 9584698, 9797180, 2487871, 5229126, 2474055, 2487879, 2490955, 5845582, 2493012, 5231190, 2481240, 2487385, 5231198, 2491490, 2491498, 2492526, 8109681, 2479226, 9687165, 5231235, 5228676, 4408455, 5231240, 5228695, 2484890, 9282206, 2492576, 2493091, 2497701, 7660710, 5228199, 9616058, 2493118, 7634625, 2481861, 2493128, 9761484, 2495696, 2480850, 2498259, 7745240, 2495708, 2494686, 2490604, 9317615, 2497266, 2494200, 9409796, 2480910, 7626513, 2493219, 2480420, 2498343, 2490669, 7937336, 2490681, 9613112, 2482492, 5231438, 2474831, 10700636, 2490719, 5739361, 2480482, 2477411, 9515886, 2498415, 9367409, 2489214, 2482048, 2497921, 7806848, 2474377, 2481035, 2481037, 2492822, 2481047, 2490774, 2480537, 2490274, 7406504, 5229490, 2475443, 5959092, 2480564, 2495414, 2492854, 5229493, 6100917, 4408759, 2492867, 2490310, 8104397, 9990095, 2494422, 6100954, 4408796, 5844449, 9701857, 9705453, 7342065, 2480637) 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 330158 records were derived from 25 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0063708-240626123714530/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.