DOI: 10.15468/dl.dfthns
title: Occurrence Download

description: A dataset containing 29764437 records in GBIF matching the query:
SELECT "year", GBIF_EEARGCode( 1000, decimalLatitude, decimalLongitude, COALESCE(coordinateUncertaintyInMeters, 1000) ) AS eeaCellCode, classKey, class, COUNT(*) AS occurrences, MIN(COALESCE(coordinateUncertaintyInMeters, 1000)) AS minCoordinateUncertaintyInMeters, MIN(GBIF_TemporalUncertainty(eventDate, null)) AS minTemporalUncertainty FROM occurrence WHERE classKey IN (131, 359, 137, 255, 216, 229, 212, 11418114, 225, 214, 11592253, 220, 196, 7228684, 7073593) AND occurrenceStatus = 'PRESENT' AND "year" &gt;= 2000 AND hasCoordinate = TRUE 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 (LOWER(identificationVerificationStatus) NOT IN ( 'unverified', 'unvalidated', 'not validated', 'under validation', 'not able to validate', 'control could not be conclusive due to insufficient knowledge', 'uncertain', 'unconfirmed', 'unconfirmed - not reviewed', 'validation requested' ) OR identificationVerificationStatus IS NULL)AND COALESCE(coordinateUncertaintyInMeters, 1000) &lt;= 10000AND GBIF_Within('POLYGON ((-0.1083511 55.42496, -0.1354718 55.42494, -0.1353599 55.40279, -0.2167336 55.40268, -0.3254153 55.40244, -0.4343059 55.4021, -0.4328736 55.31358, -0.650558 55.31262, -0.6489514 55.2463, -0.6761526 55.24615, -0.6755961 55.22405, -0.7572095 55.22358, -0.8662061 55.22285, -0.8647822 55.17868, -0.9192672 55.17828, -0.9177577 55.13414, -1.081248 55.1328, -1.079474 55.08868, -1.133982 55.08818, -1.132124 55.04409, -1.186593 55.04357, -1.29568 55.04246, -1.29356 54.99839, -1.348089 54.9978, -1.345885 54.95375, -1.509501 54.95183, -1.507037 54.90782, -1.561585 54.90713, -1.559038 54.86314, -1.613546 54.86243, -1.722709 54.86093, -1.719903 54.81697, -1.774468 54.81618, -1.771581 54.77225, -1.9353 54.76975, -1.932155 54.72584, -1.986736 54.72496, -1.98351 54.68108, -2.03805 54.68018, -2.147273 54.67829, -2.140753 54.59609, -2.147565 54.59597, -2.14713 54.59049, -2.358626 54.58656, -2.351006 54.499, -2.460088 54.49683, -2.456117 54.45309, -2.510641 54.45197, -2.506593 54.40826, -2.561075 54.40712, -2.670177 54.40476, -2.661589 54.31742, -2.770525 54.31497, -2.763852 54.24954, -2.791049 54.24891, -2.788809 54.22711, -2.979354 54.22256, -2.969815 54.13545, -3.078598 54.13272, -3.068764 54.04572, -3.177379 54.04291, -3.167252 53.95602, -3.275699 53.95311, -3.266581 53.87718, -3.280112 53.87681, -3.278807 53.86597, -3.373562 53.86334, -3.365528 53.79833, -3.392561 53.79757, -3.389869 53.77592, -3.47097 53.7736, -3.462722 53.70868, -3.489714 53.70789, -3.48695 53.68627, -3.567925 53.68388, -3.559466 53.61904, -3.586416 53.61824, -3.583583 53.59664, -3.664432 53.59419, -3.655763 53.52944, -3.682671 53.52862, -3.679768 53.50705, -3.760492 53.50454, -3.749034 53.42102, -3.752389 53.42091, -3.75202 53.41822, -3.856109 53.41491, -3.844008 53.32881, -3.951285 53.32531, -3.938912 53.23933, -4.046022 53.23575, -4.033381 53.14989, -4.027085 53.10699, -4.080453 53.10518, -4.074091 53.06231, -4.127417 53.06048, -4.114576 52.97483, -4.221023 52.9711, -4.20792 52.88558, -4.201393 52.84285, -4.254432 52.84096, -4.247841 52.79827, -4.300839 52.79636, -4.287543 52.71105, -4.393335 52.70718, -4.379783 52.62199, -4.366301 52.53691, -4.471606 52.53298, -4.45787 52.44801, -4.444204 52.36315, -4.549028 52.35916, -4.535113 52.27442, -4.521267 52.18978, -4.510928 52.12636, -4.536941 52.12536, -4.533484 52.10424, -4.611522 52.10121, -4.58355 51.93248, -4.576601 51.89036, -4.628284 51.88834, -4.621274 51.84626, -4.672919 51.84422, -4.658797 51.76013, -4.644745 51.67614, -4.630762 51.59226, -4.623797 51.55036, -4.674942 51.54833, -4.667917 51.50646, -4.719024 51.50442, -4.704875 51.42077, -4.676786 51.25378, -4.567134 50.59002, -4.513878 50.26071, -4.500723 50.17865, -4.409325 50.18215, -4.408521 50.17703, -4.402434 50.17726, -4.390425 50.10041, -4.377675 50.01855, -4.364985 49.9368, -4.352356 49.85516, -4.339786 49.77363, -4.24384 49.77718, -4.219426 49.61441, -4.207305 49.53319, -4.159797 49.5349, -4.153825 49.49433, -4.106422 49.49602, -4.100532 49.45547, -4.088793 49.37445, -4.07711 49.29355, -3.983085 49.29683, -3.960413 49.13532, -3.890389 49.13769, -3.88762 49.11753, -3.864314 49.11832, -3.856073 49.05787, -3.845131 48.97738, -3.764034 48.98005, -3.762698 48.97, -3.751126 48.97037, -3.731245 48.81976, -3.63924 48.82269, -3.628966 48.74251, -3.583147 48.74394, -3.578092 48.70389, -3.532375 48.7053, -3.527396 48.66527, -3.517471 48.5853, -3.426531 48.58803, -3.416906 48.50816, -3.348988 48.51016, -3.346637 48.4902, -3.324032 48.49086, -3.31704 48.43104, -3.271952 48.43233, -3.267367 48.39248, -3.222379 48.39375, -3.217867 48.35393, -3.208874 48.27437, -3.119385 48.27683, -3.110681 48.19738, -3.021588 48.19975, -3.013172 48.1204, -2.924474 48.12269, -2.916341 48.04344, -2.828037 48.04564, -2.820186 47.9665, -2.732274 47.96862, -2.724701 47.88958, -2.63718 47.89162, -2.629883 47.81269, -2.542752 47.81465, -2.535728 47.73582, -2.40567 47.73861, -2.402349 47.69924, -2.359131 47.70013, -2.355876 47.66078, -2.291208 47.66209, -2.289628 47.64242, -2.268105 47.64285, -2.263421 47.58389, -2.177601 47.58555, -2.171615 47.50704, -2.086179 47.50862, -2.043518 47.50939, -2.040711 47.47017, -1.998145 47.47092, -1.995402 47.43173, -1.9105 47.43317, -1.905265 47.35487, -1.820745 47.35624, -1.778542 47.3569, -1.776106 47.31779, -1.733998 47.31843, -1.731625 47.27935, -1.647636 47.28058, -1.643137 47.20249, -1.559527 47.20366, -1.476068 47.20476, -1.472043 47.12678, -1.326751 47.12855, -1.325846 47.10907, -1.305142 47.10931, -1.302477 47.05092, -1.219924 47.05182, -1.178704 47.05226, -1.177101 47.01336, -1.135975 47.01377, -1.134431 46.97491, -0.9909842 46.97624, -0.9903109 46.95681, -0.9698704 46.95699, -0.9678964 46.89876, -0.8863956 46.89942, -0.8050469 46.90002, -0.8028661 46.82248, -0.6410658 46.82349, -0.6393321 46.74607, -0.558879 46.74649, -0.4785785 46.74685, -0.3984311 46.74716, -0.3973554 46.66985, -0.3175772 46.67009, -0.1634434 46.67042, -0.1634158 46.66559, -0.1584541 46.6656, -0.1580537 46.59323, -0.07894999 46.59331, 0 46.59334, 0.07894999 46.59331, 0.07873755 46.51623, 0.1576284 46.51615, 0.315869 46.51583, 0.3852911 46.51562, 0.3851615 46.50599, 0.3950851 46.50596, 0.3941565 46.43863, 0.4734441 46.43833, 0.5528832 46.43797, 0.6324733 46.43756, 0.7122141 46.43709, 0.7103044 46.36027, 0.7899815 46.35975, 0.9497846 46.35854, 1.110184 46.3571, 1.107213 46.28041, 1.18742 46.27961, 1.267775 46.27875, 1.348277 46.27783, 1.428926 46.27685, 1.509722 46.27582, 1.590664 46.27472, 1.671752 46.27357, 1.747905 46.27243, 1.747612 46.26765, 1.752693 46.26757, 1.748304 46.19583, 1.910772 46.19324, 2.566378 46.18043, 3.904455 46.14264, 4.244412 46.13054, 4.415187 46.12408, 4.500771 46.12075, 4.511278 46.18736, 4.522011 46.18694, 4.523518 46.19646, 4.598725 46.19346, 4.684798 46.18997, 4.771001 46.18641, 4.857334 46.18278, 4.943796 46.17907, 5.030386 46.1753, 5.117105 46.17145, 5.203951 46.16753, 5.290925 46.16354, 5.378025 46.15948, 5.465251 46.15534, 5.552603 46.15114, 5.64008 46.14685, 5.727681 46.1425, 5.815407 46.13807, 5.827028 46.19501, 5.849022 46.19389, 5.852918 46.21289, 6.007192 46.20488, 6.183965 46.19545, 6.361223 46.18572, 6.538962 46.17568, 6.628011 46.17054, 6.636833 46.20845, 6.68146 46.20584, 6.690359 46.24377, 6.735074 46.24114, 6.824593 46.23582, 6.914229 46.23043, 7.003982 46.22496, 7.093851 46.21941, 7.103297 46.25729, 7.148334 46.25448, 7.157859 46.29239, 7.474332 46.2721, 7.48429 46.30998, 7.529674 46.307, 7.539712 46.3449, 7.585183 46.34189, 7.67621 46.3358, 7.767349 46.32963, 7.858599 46.32337, 7.879572 46.39916, 8.06288 46.38634, 8.073639 46.42424, 8.119594 46.42098, 8.130436 46.4589, 8.176478 46.4556, 8.268645 46.44895, 8.360921 46.44222, 8.383273 46.51806, 8.475897 46.5112, 8.568627 46.50427, 8.591557 46.58014, 8.684635 46.57308, 8.777819 46.56594, 8.801332 46.64185, 8.894863 46.63459, 8.988498 46.62723, 9.012599 46.70318, 9.106581 46.6957, 9.118792 46.7337, 9.165883 46.72991, 9.178181 46.76793, 9.31979 46.75642, 9.344834 46.83247, 9.439612 46.82464, 9.452297 46.86269, 9.499786 46.85873, 9.51256 46.89679, 9.560135 46.89281, 9.655361 46.88476, 9.681362 46.9609, 9.776934 46.95273, 9.799994 47.0194, 9.811975 47.01837, 9.81528 47.0279, 9.899214 47.02062, 9.912562 47.05875, 9.96062 47.05455, 9.974059 47.09268, 10.0222 47.08845, 10.03573 47.1266, 10.08396 47.12233, 10.09759 47.1605, 10.24261 47.14753, 10.27032 47.22388, 10.36738 47.21507, 10.39546 47.29147, 10.40954 47.32971, 10.45829 47.32524, 10.47247 47.36349, 10.52131 47.35899, 10.53559 47.39726, 10.58451 47.39271, 10.59888 47.431, 10.64789 47.42642, 10.66235 47.46471, 10.71145 47.4601, 10.72601 47.49841, 10.7752 47.49376, 10.8027 47.56564, 10.80886 47.56506, 10.8107 47.56985, 10.90323 47.56101, 10.93295 47.63774, 11.03199 47.62817, 11.0621 47.70496, 11.07721 47.74339, 11.12696 47.73853, 11.14216 47.77697, 11.19199 47.77208, 11.22263 47.84901, 11.32262 47.8391, 11.38286 47.98835, 11.38915 47.98772, 11.3911 47.99254, 11.48541 47.98305, 11.51698 48.06018, 11.54074 48.1181, 11.56602 48.11553, 11.57398 48.13484, 11.64989 48.12709, 11.71021 48.27207, 11.72293 48.27076, 11.72697 48.28043, 11.81607 48.27121, 11.84873 48.34863, 11.88153 48.42615, 11.98397 48.4154, 12.05055 48.57061, 12.08406 48.64837, 12.18738 48.63735, 12.22131 48.71514, 12.25539 48.79303, 12.28963 48.87101, 12.32401 48.94908, 12.42851 48.93773, 12.46332 49.01584, 12.60415 49.32922, 12.89355 49.96039, 13.04225 50.27813, 13.07986 50.35779, 12.97026 50.37025, 13.00774 50.45005, 13.0454 50.52995, 13.08323 50.60993, 13.12124 50.69, 13.0382 50.69945, 13.04767 50.7195, 13.01999 50.72264, 13.04842 50.78281, 13.12472 50.9435, 13.06894 50.94985, 13.08805 50.9901, 13.03222 50.99643, 13.0513 51.03671, 13.08959 51.11734, 13.12807 51.19805, 13.07187 51.20444, 13.0911 51.24484, 13.03484 51.25121, 13.05404 51.29165, 13.13128 51.45363, 13.07465 51.46005, 13.094 51.50061, 13.03732 51.50702, 13.05663 51.54762, 13.0954 51.62888, 13.13435 51.71022, 13.02026 51.72311, 13.05908 51.80461, 13.09809 51.88618, 12.98343 51.89908, 13.02231 51.9808, 13.06138 52.0626, 12.94615 52.07551, 12.98509 52.15746, 13.02421 52.23949, 12.90841 52.2524, 12.9474 52.33458, 12.88937 52.34102, 12.90885 52.38215, 12.85075 52.38858, 12.90924 52.51216, 12.79261 52.52501, 12.83151 52.60756, 12.77306 52.61397, 12.7925 52.65529, 12.73399 52.66168, 12.75339 52.70304, 12.79234 52.78582, 12.67488 52.79861, 12.71368 52.88153, 12.59596 52.89425, 12.63461 52.97732, 12.54612 52.98682, 12.55575 53.00761, 12.52625 53.01077, 12.55515 53.07319, 12.49602 53.0795, 12.51526 53.12115, 12.45607 53.12744, 12.47527 53.16913, 12.41601 53.17541, 12.43518 53.21713, 12.37585 53.22339, 12.39498 53.26515, 12.33559 53.27139, 12.35468 53.31319, 12.29523 53.31941, 12.31428 53.36125, 12.25476 53.36745, 12.27377 53.40932, 12.21419 53.41551, 12.23316 53.45741, 12.17351 53.46358, 12.19244 53.50552, 12.13273 53.51168, 12.15162 53.55365, 12.09184 53.55979, 12.11069 53.6018, 12.05084 53.60792, 12.06966 53.64996, 11.97979 53.6591, 11.98915 53.68014, 11.95919 53.68318, 11.98727 53.74635, 11.86719 53.75844, 11.90445 53.8428, 11.78411 53.85482, 11.82119 53.93931, 11.70059 53.95126, 11.64032 53.95718, 11.65866 53.99951, 11.59833 54.00541, 11.61663 54.04777, 11.50339 54.05878, 11.50566 54.06408, 11.49812 54.06481, 11.53223 54.14435, 11.41118 54.15601, 11.44739 54.24098, 11.21999 54.26259, 11.22445 54.27324, 11.20929 54.27466, 11.24051 54.34919, 11.11902 54.36056, 11.05831 54.3662, 11.07593 54.40886, 11.01516 54.41447, 11.03274 54.45717, 10.91107 54.46832, 10.946 54.55383, 10.82407 54.56491, 10.70224 54.57585, 10.7366 54.66155, 10.6145 54.67241, 10.49251 54.68313, 10.5263 54.76902, 10.40404 54.77966, 10.28188 54.79016, 10.3151 54.87625, 10.19268 54.88667, 10.00924 54.90204, 10.02544 54.94518, 9.964261 54.95025, 9.980411 54.99342, 9.857939 55.00348, 9.739404 55.0131, 9.740391 55.0158, 9.736569 55.01611, 9.767246 55.09992, 9.522114 55.11946, 9.553179 55.20615, 9.430405 55.21577, 9.307751 55.22525, 9.215839 55.23227, 9.223366 55.25399, 9.19272 55.25632, 9.215288 55.32151, 9.09249 55.33077, 8.969816 55.33989, 8.999271 55.42699, 8.876333 55.43602, 8.753521 55.44492, 8.630838 55.45368, 8.659277 55.541, 8.413518 55.5582, 8.229545 55.57075, 8.243134 55.61452, 8.181778 55.61865, 8.195305 55.66245, 8.072498 55.67062, 7.949828 55.67866, 7.827296 55.68657, 7.735488 55.69241, 7.741895 55.71436, 7.711285 55.71629, 7.730484 55.78217, 7.485331 55.79739, 7.240752 55.81208, 7.057703 55.82275, 7.069452 55.86681, 7.00841 55.87031, 7.020092 55.91439, 6.897922 55.92131, 6.775902 55.9281, 6.654034 55.93476, 6.532321 55.94129, 6.410762 55.94768, 6.289359 55.95395, 6.168115 55.96009, 6.047029 55.9661, 5.926104 55.97198, 5.80534 55.97774, 5.68474 55.98336, 5.564304 55.98886, 5.444033 55.99424, 5.32393 55.99948, 5.203994 56.00461, 5.084229 56.0096, 4.964634 56.01448, 4.845211 56.01923, 4.725961 56.02385, 4.606886 56.02836, 4.487986 56.03274, 4.369264 56.037, 4.250719 56.04114, 4.132354 56.04516, 4.01417 56.04906, 3.896167 56.05284, 3.778347 56.0565, 3.765701 55.96759, 3.648456 55.97111, 3.414524 55.9778, 3.181339 55.98403, 3.06503 55.98698, 3.054784 55.89804, 2.939052 55.90086, 2.823511 55.90356, 2.708162 55.90614, 2.593007 55.90862, 2.478045 55.91098, 2.363279 55.91323, 2.248709 55.91537, 2.241201 55.82643, 1.786424 55.83386, 1.560235 55.83693, 1.557631 55.79247, 1.501304 55.79317, 1.498802 55.74872, 1.442619 55.74939, 1.330406 55.75065, 1.218397 55.75181, 1.106593 55.75287, 0.9949941 55.75382, 0.992097 55.67607, 0.9782022 55.67618, 0.9777952 55.66508, 0.8806624 55.66581, 0.6592396 55.6672, 0.5488404 55.66774, 0.5470184 55.57896, 0.4371942 55.5794, 0.3275795 55.57974, 0.218175 55.57998, 0.2176326 55.51345, 0.1903824 55.5135, 0.1902246 55.49133, 0 55.49148, -0.1086206 55.49143, -0.1083511 55.42496))', decimalLatitude, decimalLongitude) = TRUE GROUP BY "year", eeaCellCode, classKey, class ORDER BY "year" DESC, eeaCellCode ASC, classKey ASC;

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