DOI: 10.15468/dl.5rwkhf
title: Occurrence Download

description: A dataset containing 21822152 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.1042705 54.39041, -0.1564819 54.39035, -0.1562298 54.34661, -0.2084076 54.34654, -0.3129143 54.34631, -0.3124108 54.3026, -0.3646554 54.30245, -0.3640692 54.25876, -0.4162799 54.25859, -0.5208509 54.25819, -0.5195972 54.1927, -0.5457081 54.19259, -0.5452704 54.17077, -0.6236144 54.17039, -0.7282461 54.16981, -0.7270793 54.1262, -0.7793851 54.12587, -0.7781377 54.08228, -0.8304088 54.08193, -0.9350976 54.08117, -0.9336026 54.03761, -0.9859363 54.03719, -0.9843618 53.99366, -1.03666 53.99322, -1.141403 53.99227, -1.13822 53.91615, -1.15129 53.91603, -1.150831 53.90516, -1.242367 53.90425, -1.34716 53.90312, -1.342877 53.81624, -1.447527 53.81502, -1.445228 53.77162, -1.49754 53.77098, -1.495164 53.72761, -1.652137 53.72555, -1.646907 53.63889, -1.751458 53.63741, -1.747306 53.57248, -1.773411 53.5721, -1.77201 53.55047, -1.850332 53.54928, -1.847413 53.50605, -1.899603 53.50523, -1.896609 53.46202, -1.948763 53.46118, -2.053209 53.45944, -2.046752 53.3731, -2.151052 53.37127, -2.144302 53.28505, -2.248456 53.28313, -2.241415 53.19702, -2.345425 53.19502, -2.338096 53.10901, -2.441959 53.10693, -2.434345 53.02104, -2.538062 53.01887, -2.530165 52.93309, -2.526232 52.89024, -2.577916 52.88913, -2.573912 52.84631, -2.62556 52.84518, -2.619454 52.78099, -2.645235 52.78042, -2.643185 52.75904, -2.720531 52.75729, -2.712119 52.67184, -2.815081 52.66944, -2.802069 52.54147, -2.853377 52.54025, -2.848983 52.49764, -2.900256 52.4964, -2.891344 52.41128, -2.993703 52.40873, -2.984523 52.32372, -2.97539 52.23882, -3.077294 52.23621, -3.067897 52.15142, -3.058547 52.06674, -3.053889 52.02444, -3.104518 52.02312, -3.099795 51.98084, -3.150389 51.9795, -3.131311 51.81068, -3.232012 51.80796, -3.222241 51.72372, -3.212519 51.63959, -3.202845 51.55556, -3.193219 51.47163, -3.186031 51.40876, -3.210875 51.40808, -3.208466 51.38714, -3.283003 51.38508, -3.273175 51.30138, -3.253665 51.1343, -3.234344 50.96765, -3.215211 50.80143, -3.196264 50.63564, -3.186859 50.55291, -3.093406 50.55543, -3.093122 50.55284, -3.09011 50.55292, -3.081317 50.47287, -3.072283 50.39034, -3.063292 50.30793, -3.054345 50.22562, -3.04544 50.14342, -2.950531 50.14587, -2.933398 49.98177, -2.924893 49.89989, -2.877908 49.90107, -2.873738 49.86017, -2.82686 49.86132, -2.822768 49.82044, -2.814613 49.73877, -2.806496 49.65721, -2.713531 49.65942, -2.697945 49.49662, -2.617194 49.49847, -2.616254 49.48831, -2.604732 49.48857, -2.598194 49.41749, -2.590755 49.33636, -2.499161 49.33837, -2.492018 49.25734, -2.44641 49.25831, -2.442916 49.21784, -2.397413 49.21879, -2.393991 49.17834, -2.387173 49.09752, -2.296671 49.09936, -2.290141 49.01865, -2.222559 49.01997, -2.220979 48.9998, -2.198488 49.00023, -2.193807 48.93979, -2.148949 48.94063, -2.145901 48.90037, -2.101145 48.90119, -2.098168 48.86096, -2.092233 48.78057, -2.003218 48.78215, -1.997562 48.70187, -1.908953 48.70337, -1.903573 48.6232, -1.81537 48.62462, -1.810262 48.54456, -1.722464 48.5459, -1.717625 48.46595, -1.63023 48.46721, -1.586591 48.46782, -1.584364 48.42788, -1.540825 48.42847, -1.538664 48.38856, -1.473521 48.38941, -1.472488 48.36946, -1.450808 48.36974, -1.447762 48.30994, -1.361324 48.31099, -1.35752 48.23136, -1.27148 48.23234, -1.267933 48.15282, -1.182291 48.15373, -1.09814 48.15456, -1.098092 48.15332, -1.096758 48.15334, -1.093751 48.07516, -1.008661 48.07594, -0.966175 48.0763, -0.9648304 48.03664, -0.9224431 48.03698, -0.9211605 47.99735, -0.8366222 47.99799, -0.8343001 47.9188, -0.6661662 47.91989, -0.6643204 47.84081, -0.5807233 47.84127, -0.5181293 47.84156, -0.5177705 47.82181, -0.4969401 47.8219, -0.4959091 47.76269, -0.3403213 47.76325, -0.3402036 47.75339, -0.3298546 47.75342, -0.3290576 47.68443, -0.2465543 47.68464, -0.16421 47.68478, -0.1637574 47.60605, 0 47.60616, 0.04087961 47.60616, 0.0408233 47.56683, 0.0816864 47.56681, 0.08157399 47.52751, 0.1633068 47.52743, 0.2451981 47.52728, 0.2445246 47.44878, 0.3263488 47.44858, 0.4904688 47.44799, 0.489124 47.36962, 0.5711937 47.36924, 0.6534192 47.3688, 0.7358004 47.3683, 0.7976881 47.36789, 0.7971414 47.34831, 0.8177759 47.34817, 0.816097 47.28949, 0.9811811 47.2882, 1.14688 47.28667, 1.143747 47.20855, 1.226599 47.2077, 1.309604 47.20678, 1.39276 47.2058, 1.476068 47.20476, 1.559527 47.20366, 1.632677 47.20264, 1.63212 47.19289, 1.642575 47.19274, 1.638657 47.12453, 1.973679 47.11926, 2.311075 47.11297, 2.650817 47.10563, 2.992878 47.09722, 3.337229 47.08772, 3.683841 47.07712, 4.032682 47.06539, 4.383721 47.0525, 4.736926 47.03845, 5.092263 47.02322, 5.181426 47.01922, 5.195522 47.09663, 5.285056 47.09254, 5.37472 47.08837, 5.464514 47.08412, 5.554436 47.07979, 5.644488 47.07539, 5.734667 47.07091, 5.824973 47.06635, 5.915406 47.06171, 6.005966 47.057, 6.09665 47.0522, 6.18746 47.04733, 6.278394 47.04238, 6.29546 47.11962, 6.386761 47.11456, 6.569733 47.1042, 6.753193 47.09352, 6.845105 47.08805, 6.863714 47.16525, 6.955991 47.15967, 7.048388 47.15402, 7.140904 47.14827, 7.233538 47.14245, 7.253216 47.21964, 7.346215 47.2137, 7.532563 47.20157, 7.553071 47.27877, 7.646668 47.27255, 7.740379 47.26624, 7.750916 47.30485, 7.797877 47.30166, 7.8085 47.34029, 7.949741 47.33055, 8.044044 47.32394, 8.065986 47.4012, 8.160652 47.39448, 8.25543 47.38767, 8.277972 47.46496, 8.373112 47.45803, 8.468364 47.451, 8.491511 47.52834, 8.587125 47.52119, 8.598864 47.55988, 8.646775 47.55626, 8.658603 47.59497, 8.802691 47.58395, 8.826808 47.66138, 8.923256 47.65389, 8.941606 47.71201, 8.965783 47.71011, 8.971929 47.72949, 9.044548 47.72376, 9.141465 47.71604, 9.166568 47.79358, 9.263848 47.78572, 9.289321 47.86332, 9.386963 47.85533, 9.412808 47.93299, 9.510814 47.92487, 9.537034 48.0026, 9.635403 47.99433, 9.662001 48.07212, 9.760733 48.06372, 9.787713 48.14157, 9.886808 48.13303, 9.914171 48.21094, 9.927898 48.24993, 9.977682 48.24559, 9.991506 48.2846, 10.04138 48.28022, 10.06227 48.33876, 10.08727 48.33656, 10.09427 48.35608, 10.16934 48.34942, 10.19761 48.42754, 10.29806 48.41853, 10.35506 48.57377, 10.35663 48.57362, 10.35709 48.57485, 10.45659 48.56578, 10.48578 48.64412, 10.50776 48.70293, 10.53316 48.70059, 10.54052 48.72021, 10.61682 48.71314, 10.67453 48.8653, 10.68092 48.86471, 10.68279 48.86962, 10.77876 48.86061, 10.80903 48.93925, 10.83943 49.01798, 10.85468 49.05739, 10.90624 49.05248, 10.9216 49.0919, 10.97325 49.08696, 11.0042 49.16584, 11.06653 49.3239, 11.17074 49.31377, 11.2024 49.39289, 11.23421 49.47211, 11.26616 49.55143, 11.29825 49.63084, 11.33049 49.71034, 11.36289 49.78994, 11.39543 49.86964, 11.42812 49.94943, 11.46096 50.02932, 11.49395 50.10929, 11.5271 50.18937, 11.5604 50.26953, 11.59385 50.34979, 11.62746 50.43014, 11.66123 50.51058, 11.69516 50.59111, 11.58632 50.60211, 11.65405 50.76356, 11.72242 50.92538, 11.61247 50.93649, 11.64659 51.01759, 11.68087 51.09878, 11.71532 51.18006, 11.60453 51.19123, 11.70793 51.43578, 11.59631 51.447, 11.63079 51.52875, 11.66544 51.61059, 11.60934 51.61621, 11.62665 51.65718, 11.5705 51.66278, 11.62244 51.78586, 11.56607 51.79148, 11.58339 51.83256, 11.52697 51.83817, 11.54424 51.87929, 11.57892 51.96159, 11.52228 51.96721, 11.53961 52.00841, 11.48291 52.01401, 11.53489 52.13778, 11.42819 52.14828, 11.43034 52.15345, 11.42323 52.15415, 11.45562 52.23166, 11.49033 52.31443, 11.37595 52.32562, 11.4105 52.40853, 11.2959 52.41965, 11.33029 52.5027, 11.27285 52.50825, 11.29003 52.54982, 11.23253 52.55535, 11.28407 52.68024, 11.16865 52.69128, 11.20288 52.7747, 11.08723 52.78568, 11.1213 52.86925, 11.0054 52.88015, 11.0393 52.96386, 10.92316 52.97469, 10.95689 53.05854, 10.84051 53.0693, 10.87406 53.15329, 10.75744 53.16398, 10.79081 53.24811, 10.61555 53.26399, 10.63205 53.30613, 10.57359 53.31137, 10.59004 53.35354, 10.48765 53.36266, 10.49173 53.37322, 10.47711 53.37451, 10.5057 53.44842, 10.38845 53.45876, 10.42094 53.54336, 10.30344 53.55363, 10.24474 53.55872, 10.26078 53.60109, 10.20201 53.60615, 10.218 53.64856, 10.10037 53.65862, 10.13213 53.74355, 10.01425 53.75354, 9.925911 53.76094, 9.933721 53.78221, 9.904267 53.78466, 9.927689 53.84851, 9.809675 53.85829, 9.75071 53.86313, 9.766107 53.90576, 9.707081 53.91058, 9.722428 53.95324, 9.604282 53.96281, 9.545252 53.96755, 9.560369 54.01027, 9.501278 54.01498, 9.516344 54.05774, 9.398069 54.0671, 9.338975 54.07173, 9.353809 54.11454, 9.294654 54.11916, 9.309436 54.162, 9.191035 54.17115, 9.072754 54.18018, 9.101704 54.26603, 8.98318 54.27497, 8.864779 54.28378, 8.893147 54.36981, 8.774503 54.37854, 8.655985 54.38714, 8.567179 54.39351, 8.574041 54.41506, 8.544432 54.41717, 8.565005 54.48186, 8.327869 54.49851, 8.354685 54.58493, 8.235941 54.59311, 8.117329 54.60116, 8.028457 54.60711, 8.034928 54.62876, 8.005297 54.63073, 8.024691 54.69571, 7.905973 54.70354, 7.676346 54.71836, 7.677897 54.72379, 7.670497 54.72426, 7.693802 54.80567, 7.575122 54.81317, 7.45658 54.82053, 7.33818 54.82777, 7.249473 54.83312, 7.255355 54.85488, 7.225781 54.85664, 7.243404 54.92197, 6.770314 54.94931, 6.65241 54.95583, 6.674129 55.04318, 6.555997 55.04962, 6.438016 55.05592, 6.320187 55.06211, 6.202512 55.06817, 6.084992 55.07411, 5.967629 55.07992, 5.850422 55.08562, 5.733375 55.09119, 5.616487 55.09664, 5.49976 55.10197, 5.383195 55.10718, 5.266794 55.11227, 5.150557 55.11724, 5.034486 55.1221, 4.918582 55.12683, 4.802846 55.13145, 4.687279 55.13595, 4.571882 55.14033, 4.456657 55.1446, 4.341604 55.14875, 4.226725 55.15278, 4.11202 55.1567, 3.997491 55.16051, 3.984407 55.07253, 3.529557 55.08655, 3.303213 55.09289, 3.29275 55.00763, 3.28923 55.00773, 3.288894 55.00498, 3.179882 55.00787, 3.067534 55.01075, 2.955371 55.01352, 2.843392 55.01619, 2.7316 55.01875, 2.619995 55.0212, 2.508579 55.02354, 2.501409 54.94652, 2.487535 54.94681, 2.486519 54.93581, 2.389522 54.93775, 2.168362 54.94189, 1.947966 54.94561, 1.838058 54.94732, 1.835058 54.90332, 1.780266 54.90413, 1.777363 54.86015, 1.722709 54.86093, 1.613546 54.86243, 1.504579 54.86382, 1.395808 54.86512, 1.287234 54.86632, 1.283044 54.77838, 1.067195 54.78047, 0.9595675 54.78137, 0.9580071 54.73743, 0.9043558 54.73784, 0.9028867 54.69392, 0.8493723 54.69431, 0.7424934 54.69501, 0.6358152 54.69561, 0.6347834 54.65172, 0.5816061 54.65198, 0.5806633 54.60811, 0.4216921 54.60876, 0.3159639 54.60908, 0.3149419 54.5214, 0.209758 54.52163, 0.1047771 54.52176, 0.1045233 54.45606, 0.07837341 54.45608, 0.07831014 54.43419, 0 54.43421, -0.1044389 54.43417, -0.1042705 54.39041))', decimalLatitude, decimalLongitude) = TRUE GROUP BY "year", eeaCellCode, classKey, class ORDER BY "year" DESC, eeaCellCode ASC, classKey ASC;

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