DOI: 10.15468/dl.vth3ec
title: Occurrence Download

description: A dataset containing 58184 records in GBIF matching the query:
SELECT
 kingdom,
 kingdomkey,
 phylum,
 phylumkey,
 class,
 classkey,
 "order",
 orderkey,
 family,
 familykey,
 genus,
 genuskey,
 species,
 specieskey,
 "year",
 GBIF_EQDGCODE(3, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)) eqdcellcode,
 IF(ISNULL(kingdomkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY kingdomkey, GBIF_EQDGCODE(3, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), "year")) kingdomcount,
 IF(ISNULL(phylumkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY phylumkey, GBIF_EQDGCODE(3, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), "year")) phylumcount,
 IF(ISNULL(classkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY classkey, GBIF_EQDGCODE(3, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), "year")) classcount,
 IF(ISNULL(orderkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY orderkey, GBIF_EQDGCODE(3, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), "year")) ordercount,
 IF(ISNULL(familykey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY familykey, GBIF_EQDGCODE(3, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), "year")) familycount,
 IF(ISNULL(genuskey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY genuskey, GBIF_EQDGCODE(3, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000)), "year")) genuscount,
 COUNT(*) occurrences,
 MIN(GBIF_TEMPORALUNCERTAINTY(eventdate, eventtime)) mintemporaluncertainty,
 MIN(COALESCE(coordinateuncertaintyinmeters, 1000)) mincoordinateuncertaintyinmeters
FROM
 occurrence
WHERE
 occurrence.occurrencestatus = 'PRESENT'
 AND (occurrence.taxonkey IN (2443474, 2441842, 2443244, 3959722, 5383990, 2443466, 2442749, 2443546, 2441533, 2443451, 4071375, 8346600, 4000160, 2443457, 5544122, 9662012, 2424472, 2441454, 5224625, 5792404, 2684940, 3590483, 2733923, 2735138, 5621338, 7281591, 5217521, 2424497, 5960674, 2443326, 5790422, 2810666, 2441209, 2441046, 5787005, 2459611, 2428950, 5217323, 2430194, 2436653, 2436664, 2436529, 4267165, 8316890, 4267009, 5963046, 5963044, 5219581, 5219577, 5219571, 4267157, 4267161, 4267149, 2436616, 2436617, 5219557, 5219560, 5219558, 5219563, 5219559, 4267131, 5786340, 4267078, 7460229, 4267071, 2436535, 4267088, 5786266, 5219552, 5219544, 5707402, 5219553, 5219546, 5219550, 4267277, 5786121, 5786120, 7262062, 4267266, 4267267, 4267273, 5786125, 2436383, 9509736, 9410326, 2436393, 9291744, 9613557, 5707306, 8160643, 4266953, 9204783, 7409610, 5219548, 2441247, 2441703, 9244153, 5220103, 5219990, 2440248, 2440257, 2440145, 2440212, 2440207, 2440221, 2440206, 2440220, 2440222, 2440217, 2440048, 2433390, 2433385, 2435332, 5707023, 5218707, 5218703, 2432843, 7261770, 5706995, 2432850, 2432830, 2432826, 4265634, 5707082, 5218698, 5218648, 5218651, 5218680, 5218670, 5218683, 5218672, 8384945, 5218681, 5218690, 5218643, 5218689, 5218684, 5218645, 5218644, 5218675, 2432972, 2441011, 4262425, 5220124, 5706281, 5220130, 5220128, 2440980, 2440981, 2440945, 4262389, 5220121, 5220122, 7261381, 7261380, 7261388, 4262394, 2437650, 2437663, 2439749, 2438522, 2437225, 2438368, 2438816, 4264811, 4144259, 2435292, 2440993, 4971476, 2441215, 2441214, 4262887, 4262912, 4262911, 7859434, 2738087, 2440897, 2440896, 2440898, 2436938, 2436717, 2436749, 2436683, 2434674, 2434672, 2433635, 2434615, 5219333, 5219461, 2441018, 2441026, 8085503, 9227500, 2402728, 2402730, 2344356, 7305176, 2441165, 2441156, 2441164, 5220148, 7349281, 2441207, 2426957, 9575899, 2430467, 2732561, 2342096, 3662185, 3662755, 3662094, 3662076, 3662882, 3593837, 2440989, 2440990, 4262218, 5706471, 4262221, 3660334, 3992522, 3590325, 3592190, 3155099, 5217231, 2431146, 5217797, 5217778, 2427272, 2431101, 2424796, 10701161, 2431877, 2431130, 5217148, 2430540, 2430521, 2430530, 2430252, 5663154, 8046167, 3763583, 4097038, 4921557, 3969643, 5284080, 7522079, 4182249, 2440998, 5290048, 5290053, 2402084, 7475536, 7990192, 2423370, 2427297, 2883913, 2423153, 5218652, 7262640, 3764563, 2402231, 8479820, 2363136, 2362810, 2359615, 7970247, 8729702, 7416027, 5707385, 5219576, 5707396, 4266998, 4267000, 7262003, 7455384, 2476001, 2479545, 2495981, 5788499, 6092004, 2489032, 2493301, 2733413, 2428948, 2428946, 5789953, 2442800, 5220137, 2763088, 2424462, 2424508, 2424465, 5217566, 3616644, 2929168, 2440991, 10073041, 8187668, 8011274, 8869639, 5219446, 3624945, 7669959, 8064310, 4148645, 4147880, 3622111, 5231876, 2778202, 8087668, 7620105, 7462469, 7844550, 2971345, 2473543, 2430458, 2437546, 2432935, 2437348, 2437254, 5218693, 5220178, 4266932, 4266938, 2436432, 4266965, 4266967, 5219530, 7528726, 5219529, 5707429, 5707425, 2436424, 4266945, 4266975, 5786413, 5786406, 5786012, 9655824, 5786424, 5786423, 5786418, 7868037, 2971004, 2767106, 2766803, 2767104, 2766741, 3035874, 2738881, 2475906, 2479882, 5844228, 5232243, 2479617, 2489028, 2486347, 5232283, 4096611, 5786010, 3669732, 7282186, 7280469, 5620276, 7284419, 3959001, 3948643, 2433399, 5219633, 5786559, 5786560, 9932528, 5786561, 5219629, 2470852, 2440505, 2433401, 2441222, 2433403, 9022612, 2441535, 7755704, 8072617, 2443503, 9802482, 11041715, 2760239, 2760237, 2760200, 2760243, 2758886, 2758896, 2758867, 2758929, 10802512, 2758892, 2758820, 2459608, 4096841, 10829544, 3073586, 2886044, 7582362, 2886053, 3015037, 3014660, 3016123, 3014624, 5550177, 2482267, 4311512, 9555046, 9301372, 8724264, 9424203, 8783081, 9459191, 8899546, 9152161, 8750262, 8843868, 8940651, 8789660, 9220486, 8871232, 8762800, 9499554, 9392653, 9182758, 8934292, 6101193, 9460773, 2482178, 9510484, 3936453, 3955530) OR occurrence.acceptedtaxonkey IN (2443474, 2441842, 2443244, 3959722, 5383990, 2443466, 2442749, 2443546, 2441533, 2443451, 4071375, 8346600, 4000160, 2443457, 5544122, 9662012, 2424472, 2441454, 5224625, 5792404, 2684940, 3590483, 2733923, 2735138, 5621338, 7281591, 5217521, 2424497, 5960674, 2443326, 5790422, 2810666, 2441209, 2441046, 5787005, 2459611, 2428950, 5217323, 2430194, 2436653, 2436664, 2436529, 4267165, 8316890, 4267009, 5963046, 5963044, 5219581, 5219577, 5219571, 4267157, 4267161, 4267149, 2436616, 2436617, 5219557, 5219560, 5219558, 5219563, 5219559, 4267131, 5786340, 4267078, 7460229, 4267071, 2436535, 4267088, 5786266, 5219552, 5219544, 5707402, 5219553, 5219546, 5219550, 4267277, 5786121, 5786120, 7262062, 4267266, 4267267, 4267273, 5786125, 2436383, 9509736, 9410326, 2436393, 9291744, 9613557, 5707306, 8160643, 4266953, 9204783, 7409610, 5219548, 2441247, 2441703, 9244153, 5220103, 5219990, 2440248, 2440257, 2440145, 2440212, 2440207, 2440221, 2440206, 2440220, 2440222, 2440217, 2440048, 2433390, 2433385, 2435332, 5707023, 5218707, 5218703, 2432843, 7261770, 5706995, 2432850, 2432830, 2432826, 4265634, 5707082, 5218698, 5218648, 5218651, 5218680, 5218670, 5218683, 5218672, 8384945, 5218681, 5218690, 5218643, 5218689, 5218684, 5218645, 5218644, 5218675, 2432972, 2441011, 4262425, 5220124, 5706281, 5220130, 5220128, 2440980, 2440981, 2440945, 4262389, 5220121, 5220122, 7261381, 7261380, 7261388, 4262394, 2437650, 2437663, 2439749, 2438522, 2437225, 2438368, 2438816, 4264811, 4144259, 2435292, 2440993, 4971476, 2441215, 2441214, 4262887, 4262912, 4262911, 7859434, 2738087, 2440897, 2440896, 2440898, 2436938, 2436717, 2436749, 2436683, 2434674, 2434672, 2433635, 2434615, 5219333, 5219461, 2441018, 2441026, 8085503, 9227500, 2402728, 2402730, 2344356, 7305176, 2441165, 2441156, 2441164, 5220148, 7349281, 2441207, 2426957, 9575899, 2430467, 2732561, 2342096, 3662185, 3662755, 3662094, 3662076, 3662882, 3593837, 2440989, 2440990, 4262218, 5706471, 4262221, 3660334, 3992522, 3590325, 3592190, 3155099, 5217231, 2431146, 5217797, 5217778, 2427272, 2431101, 2424796, 10701161, 2431877, 2431130, 5217148, 2430540, 2430521, 2430530, 2430252, 5663154, 8046167, 3763583, 4097038, 4921557, 3969643, 5284080, 7522079, 4182249, 2440998, 5290048, 5290053, 2402084, 7475536, 7990192, 2423370, 2427297, 2883913, 2423153, 5218652, 7262640, 3764563, 2402231, 8479820, 2363136, 2362810, 2359615, 7970247, 8729702, 7416027, 5707385, 5219576, 5707396, 4266998, 4267000, 7262003, 7455384, 2476001, 2479545, 2495981, 5788499, 6092004, 2489032, 2493301, 2733413, 2428948, 2428946, 5789953, 2442800, 5220137, 2763088, 2424462, 2424508, 2424465, 5217566, 3616644, 2929168, 2440991, 10073041, 8187668, 8011274, 8869639, 5219446, 3624945, 7669959, 8064310, 4148645, 4147880, 3622111, 5231876, 2778202, 8087668, 7620105, 7462469, 7844550, 2971345, 2473543, 2430458, 2437546, 2432935, 2437348, 2437254, 5218693, 5220178, 4266932, 4266938, 2436432, 4266965, 4266967, 5219530, 7528726, 5219529, 5707429, 5707425, 2436424, 4266945, 4266975, 5786413, 5786406, 5786012, 9655824, 5786424, 5786423, 5786418, 7868037, 2971004, 2767106, 2766803, 2767104, 2766741, 3035874, 2738881, 2475906, 2479882, 5844228, 5232243, 2479617, 2489028, 2486347, 5232283, 4096611, 5786010, 3669732, 7282186, 7280469, 5620276, 7284419, 3959001, 3948643, 2433399, 5219633, 5786559, 5786560, 9932528, 5786561, 5219629, 2470852, 2440505, 2433401, 2441222, 2433403, 9022612, 2441535, 7755704, 8072617, 2443503, 9802482, 11041715, 2760239, 2760237, 2760200, 2760243, 2758886, 2758896, 2758867, 2758929, 10802512, 2758892, 2758820, 2459608, 4096841, 10829544, 3073586, 2886044, 7582362, 2886053, 3015037, 3014660, 3016123, 3014624, 5550177, 2482267, 4311512, 9555046, 9301372, 8724264, 9424203, 8783081, 9459191, 8899546, 9152161, 8750262, 8843868, 8940651, 8789660, 9220486, 8871232, 8762800, 9499554, 9392653, 9182758, 8934292, 6101193, 9460773, 2482178, 9510484, 3936453, 3955530) OR occurrence.kingdomkey IN (2443474, 2441842, 2443244, 3959722, 5383990, 2443466, 2442749, 2443546, 2441533, 2443451, 4071375, 8346600, 4000160, 2443457, 5544122, 9662012, 2424472, 2441454, 5224625, 5792404, 2684940, 3590483, 2733923, 2735138, 5621338, 7281591, 5217521, 2424497, 5960674, 2443326, 5790422, 2810666, 2441209, 2441046, 5787005, 2459611, 2428950, 5217323, 2430194, 2436653, 2436664, 2436529, 4267165, 8316890, 4267009, 5963046, 5963044, 5219581, 5219577, 5219571, 4267157, 4267161, 4267149, 2436616, 2436617, 5219557, 5219560, 5219558, 5219563, 5219559, 4267131, 5786340, 4267078, 7460229, 4267071, 2436535, 4267088, 5786266, 5219552, 5219544, 5707402, 5219553, 5219546, 5219550, 4267277, 5786121, 5786120, 7262062, 4267266, 4267267, 4267273, 5786125, 2436383, 9509736, 9410326, 2436393, 9291744, 9613557, 5707306, 8160643, 4266953, 9204783, 7409610, 5219548, 2441247, 2441703, 9244153, 5220103, 5219990, 2440248, 2440257, 2440145, 2440212, 2440207, 2440221, 2440206, 2440220, 2440222, 2440217, 2440048, 2433390, 2433385, 2435332, 5707023, 5218707, 5218703, 2432843, 7261770, 5706995, 2432850, 2432830, 2432826, 4265634, 5707082, 5218698, 5218648, 5218651, 5218680, 5218670, 5218683, 5218672, 8384945, 5218681, 5218690, 5218643, 5218689, 5218684, 5218645, 5218644, 5218675, 2432972, 2441011, 4262425, 5220124, 5706281, 5220130, 5220128, 2440980, 2440981, 2440945, 4262389, 5220121, 5220122, 7261381, 7261380, 7261388, 4262394, 2437650, 2437663, 2439749, 2438522, 2437225, 2438368, 2438816, 4264811, 4144259, 2435292, 2440993, 4971476, 2441215, 2441214, 4262887, 4262912, 4262911, 7859434, 2738087, 2440897, 2440896, 2440898, 2436938, 2436717, 2436749, 2436683, 2434674, 2434672, 2433635, 2434615, 5219333, 5219461, 2441018, 2441026, 8085503, 9227500, 2402728, 2402730, 2344356, 7305176, 2441165, 2441156, 2441164, 5220148, 7349281, 2441207, 2426957, 9575899, 2430467, 2732561, 2342096, 3662185, 3662755, 3662094, 3662076, 3662882, 3593837, 2440989, 2440990, 4262218, 5706471, 4262221, 3660334, 3992522, 3590325, 3592190, 3155099, 5217231, 2431146, 5217797, 5217778, 2427272, 2431101, 2424796, 10701161, 2431877, 2431130, 5217148, 2430540, 2430521, 2430530, 2430252, 5663154, 8046167, 3763583, 4097038, 4921557, 3969643, 5284080, 7522079, 4182249, 2440998, 5290048, 5290053, 2402084, 7475536, 7990192, 2423370, 2427297, 2883913, 2423153, 5218652, 7262640, 3764563, 2402231, 8479820, 2363136, 2362810, 2359615, 7970247, 8729702, 7416027, 5707385, 5219576, 5707396, 4266998, 4267000, 7262003, 7455384, 2476001, 2479545, 2495981, 5788499, 6092004, 2489032, 2493301, 2733413, 2428948, 2428946, 5789953, 2442800, 5220137, 2763088, 2424462, 2424508, 2424465, 5217566, 3616644, 2929168, 2440991, 10073041, 8187668, 8011274, 8869639, 5219446, 3624945, 7669959, 8064310, 4148645, 4147880, 3622111, 5231876, 2778202, 8087668, 7620105, 7462469, 7844550, 2971345, 2473543, 2430458, 2437546, 2432935, 2437348, 2437254, 5218693, 5220178, 4266932, 4266938, 2436432, 4266965, 4266967, 5219530, 7528726, 5219529, 5707429, 5707425, 2436424, 4266945, 4266975, 5786413, 5786406, 5786012, 9655824, 5786424, 5786423, 5786418, 7868037, 2971004, 2767106, 2766803, 2767104, 2766741, 3035874, 2738881, 2475906, 2479882, 5844228, 5232243, 2479617, 2489028, 2486347, 5232283, 4096611, 5786010, 3669732, 7282186, 7280469, 5620276, 7284419, 3959001, 3948643, 2433399, 5219633, 5786559, 5786560, 9932528, 5786561, 5219629, 2470852, 2440505, 2433401, 2441222, 2433403, 9022612, 2441535, 7755704, 8072617, 2443503, 9802482, 11041715, 2760239, 2760237, 2760200, 2760243, 2758886, 2758896, 2758867, 2758929, 10802512, 2758892, 2758820, 2459608, 4096841, 10829544, 3073586, 2886044, 7582362, 2886053, 3015037, 3014660, 3016123, 3014624, 5550177, 2482267, 4311512, 9555046, 9301372, 8724264, 9424203, 8783081, 9459191, 8899546, 9152161, 8750262, 8843868, 8940651, 8789660, 9220486, 8871232, 8762800, 9499554, 9392653, 9182758, 8934292, 6101193, 9460773, 2482178, 9510484, 3936453, 3955530) OR occurrence.phylumkey IN (2443474, 2441842, 2443244, 3959722, 5383990, 2443466, 2442749, 2443546, 2441533, 2443451, 4071375, 8346600, 4000160, 2443457, 5544122, 9662012, 2424472, 2441454, 5224625, 5792404, 2684940, 3590483, 2733923, 2735138, 5621338, 7281591, 5217521, 2424497, 5960674, 2443326, 5790422, 2810666, 2441209, 2441046, 5787005, 2459611, 2428950, 5217323, 2430194, 2436653, 2436664, 2436529, 4267165, 8316890, 4267009, 5963046, 5963044, 5219581, 5219577, 5219571, 4267157, 4267161, 4267149, 2436616, 2436617, 5219557, 5219560, 5219558, 5219563, 5219559, 4267131, 5786340, 4267078, 7460229, 4267071, 2436535, 4267088, 5786266, 5219552, 5219544, 5707402, 5219553, 5219546, 5219550, 4267277, 5786121, 5786120, 7262062, 4267266, 4267267, 4267273, 5786125, 2436383, 9509736, 9410326, 2436393, 9291744, 9613557, 5707306, 8160643, 4266953, 9204783, 7409610, 5219548, 2441247, 2441703, 9244153, 5220103, 5219990, 2440248, 2440257, 2440145, 2440212, 2440207, 2440221, 2440206, 2440220, 2440222, 2440217, 2440048, 2433390, 2433385, 2435332, 5707023, 5218707, 5218703, 2432843, 7261770, 5706995, 2432850, 2432830, 2432826, 4265634, 5707082, 5218698, 5218648, 5218651, 5218680, 5218670, 5218683, 5218672, 8384945, 5218681, 5218690, 5218643, 5218689, 5218684, 5218645, 5218644, 5218675, 2432972, 2441011, 4262425, 5220124, 5706281, 5220130, 5220128, 2440980, 2440981, 2440945, 4262389, 5220121, 5220122, 7261381, 7261380, 7261388, 4262394, 2437650, 2437663, 2439749, 2438522, 2437225, 2438368, 2438816, 4264811, 4144259, 2435292, 2440993, 4971476, 2441215, 2441214, 4262887, 4262912, 4262911, 7859434, 2738087, 2440897, 2440896, 2440898, 2436938, 2436717, 2436749, 2436683, 2434674, 2434672, 2433635, 2434615, 5219333, 5219461, 2441018, 2441026, 8085503, 9227500, 2402728, 2402730, 2344356, 7305176, 2441165, 2441156, 2441164, 5220148, 7349281, 2441207, 2426957, 9575899, 2430467, 2732561, 2342096, 3662185, 3662755, 3662094, 3662076, 3662882, 3593837, 2440989, 2440990, 4262218, 5706471, 4262221, 3660334, 3992522, 3590325, 3592190, 3155099, 5217231, 2431146, 5217797, 5217778, 2427272, 2431101, 2424796, 10701161, 2431877, 2431130, 5217148, 2430540, 2430521, 2430530, 2430252, 5663154, 8046167, 3763583, 4097038, 4921557, 3969643, 5284080, 7522079, 4182249, 2440998, 5290048, 5290053, 2402084, 7475536, 7990192, 2423370, 2427297, 2883913, 2423153, 5218652, 7262640, 3764563, 2402231, 8479820, 2363136, 2362810, 2359615, 7970247, 8729702, 7416027, 5707385, 5219576, 5707396, 4266998, 4267000, 7262003, 7455384, 2476001, 2479545, 2495981, 5788499, 6092004, 2489032, 2493301, 2733413, 2428948, 2428946, 5789953, 2442800, 5220137, 2763088, 2424462, 2424508, 2424465, 5217566, 3616644, 2929168, 2440991, 10073041, 8187668, 8011274, 8869639, 5219446, 3624945, 7669959, 8064310, 4148645, 4147880, 3622111, 5231876, 2778202, 8087668, 7620105, 7462469, 7844550, 2971345, 2473543, 2430458, 2437546, 2432935, 2437348, 2437254, 5218693, 5220178, 4266932, 4266938, 2436432, 4266965, 4266967, 5219530, 7528726, 5219529, 5707429, 5707425, 2436424, 4266945, 4266975, 5786413, 5786406, 5786012, 9655824, 5786424, 5786423, 5786418, 7868037, 2971004, 2767106, 2766803, 2767104, 2766741, 3035874, 2738881, 2475906, 2479882, 5844228, 5232243, 2479617, 2489028, 2486347, 5232283, 4096611, 5786010, 3669732, 7282186, 7280469, 5620276, 7284419, 3959001, 3948643, 2433399, 5219633, 5786559, 5786560, 9932528, 5786561, 5219629, 2470852, 2440505, 2433401, 2441222, 2433403, 9022612, 2441535, 7755704, 8072617, 2443503, 9802482, 11041715, 2760239, 2760237, 2760200, 2760243, 2758886, 2758896, 2758867, 2758929, 10802512, 2758892, 2758820, 2459608, 4096841, 10829544, 3073586, 2886044, 7582362, 2886053, 3015037, 3014660, 3016123, 3014624, 5550177, 2482267, 4311512, 9555046, 9301372, 8724264, 9424203, 8783081, 9459191, 8899546, 9152161, 8750262, 8843868, 8940651, 8789660, 9220486, 8871232, 8762800, 9499554, 9392653, 9182758, 8934292, 6101193, 9460773, 2482178, 9510484, 3936453, 3955530) OR occurrence.classkey IN (2443474, 2441842, 2443244, 3959722, 5383990, 2443466, 2442749, 2443546, 2441533, 2443451, 4071375, 8346600, 4000160, 2443457, 5544122, 9662012, 2424472, 2441454, 5224625, 5792404, 2684940, 3590483, 2733923, 2735138, 5621338, 7281591, 5217521, 2424497, 5960674, 2443326, 5790422, 2810666, 2441209, 2441046, 5787005, 2459611, 2428950, 5217323, 2430194, 2436653, 2436664, 2436529, 4267165, 8316890, 4267009, 5963046, 5963044, 5219581, 5219577, 5219571, 4267157, 4267161, 4267149, 2436616, 2436617, 5219557, 5219560, 5219558, 5219563, 5219559, 4267131, 5786340, 4267078, 7460229, 4267071, 2436535, 4267088, 5786266, 5219552, 5219544, 5707402, 5219553, 5219546, 5219550, 4267277, 5786121, 5786120, 7262062, 4267266, 4267267, 4267273, 5786125, 2436383, 9509736, 9410326, 2436393, 9291744, 9613557, 5707306, 8160643, 4266953, 9204783, 7409610, 5219548, 2441247, 2441703, 9244153, 5220103, 5219990, 2440248, 2440257, 2440145, 2440212, 2440207, 2440221, 2440206, 2440220, 2440222, 2440217, 2440048, 2433390, 2433385, 2435332, 5707023, 5218707, 5218703, 2432843, 7261770, 5706995, 2432850, 2432830, 2432826, 4265634, 5707082, 5218698, 5218648, 5218651, 5218680, 5218670, 5218683, 5218672, 8384945, 5218681, 5218690, 5218643, 5218689, 5218684, 5218645, 5218644, 5218675, 2432972, 2441011, 4262425, 5220124, 5706281, 5220130, 5220128, 2440980, 2440981, 2440945, 4262389, 5220121, 5220122, 7261381, 7261380, 7261388, 4262394, 2437650, 2437663, 2439749, 2438522, 2437225, 2438368, 2438816, 4264811, 4144259, 2435292, 2440993, 4971476, 2441215, 2441214, 4262887, 4262912, 4262911, 7859434, 2738087, 2440897, 2440896, 2440898, 2436938, 2436717, 2436749, 2436683, 2434674, 2434672, 2433635, 2434615, 5219333, 5219461, 2441018, 2441026, 8085503, 9227500, 2402728, 2402730, 2344356, 7305176, 2441165, 2441156, 2441164, 5220148, 7349281, 2441207, 2426957, 9575899, 2430467, 2732561, 2342096, 3662185, 3662755, 3662094, 3662076, 3662882, 3593837, 2440989, 2440990, 4262218, 5706471, 4262221, 3660334, 3992522, 3590325, 3592190, 3155099, 5217231, 2431146, 5217797, 5217778, 2427272, 2431101, 2424796, 10701161, 2431877, 2431130, 5217148, 2430540, 2430521, 2430530, 2430252, 5663154, 8046167, 3763583, 4097038, 4921557, 3969643, 5284080, 7522079, 4182249, 2440998, 5290048, 5290053, 2402084, 7475536, 7990192, 2423370, 2427297, 2883913, 2423153, 5218652, 7262640, 3764563, 2402231, 8479820, 2363136, 2362810, 2359615, 7970247, 8729702, 7416027, 5707385, 5219576, 5707396, 4266998, 4267000, 7262003, 7455384, 2476001, 2479545, 2495981, 5788499, 6092004, 2489032, 2493301, 2733413, 2428948, 2428946, 5789953, 2442800, 5220137, 2763088, 2424462, 2424508, 2424465, 5217566, 3616644, 2929168, 2440991, 10073041, 8187668, 8011274, 8869639, 5219446, 3624945, 7669959, 8064310, 4148645, 4147880, 3622111, 5231876, 2778202, 8087668, 7620105, 7462469, 7844550, 2971345, 2473543, 2430458, 2437546, 2432935, 2437348, 2437254, 5218693, 5220178, 4266932, 4266938, 2436432, 4266965, 4266967, 5219530, 7528726, 5219529, 5707429, 5707425, 2436424, 4266945, 4266975, 5786413, 5786406, 5786012, 9655824, 5786424, 5786423, 5786418, 7868037, 2971004, 2767106, 2766803, 2767104, 2766741, 3035874, 2738881, 2475906, 2479882, 5844228, 5232243, 2479617, 2489028, 2486347, 5232283, 4096611, 5786010, 3669732, 7282186, 7280469, 5620276, 7284419, 3959001, 3948643, 2433399, 5219633, 5786559, 5786560, 9932528, 5786561, 5219629, 2470852, 2440505, 2433401, 2441222, 2433403, 9022612, 2441535, 7755704, 8072617, 2443503, 9802482, 11041715, 2760239, 2760237, 2760200, 2760243, 2758886, 2758896, 2758867, 2758929, 10802512, 2758892, 2758820, 2459608, 4096841, 10829544, 3073586, 2886044, 7582362, 2886053, 3015037, 3014660, 3016123, 3014624, 5550177, 2482267, 4311512, 9555046, 9301372, 8724264, 9424203, 8783081, 9459191, 8899546, 9152161, 8750262, 8843868, 8940651, 8789660, 9220486, 8871232, 8762800, 9499554, 9392653, 9182758, 8934292, 6101193, 9460773, 2482178, 9510484, 3936453, 3955530) OR occurrence.orderkey IN (2443474, 2441842, 2443244, 3959722, 5383990, 2443466, 2442749, 2443546, 2441533, 2443451, 4071375, 8346600, 4000160, 2443457, 5544122, 9662012, 2424472, 2441454, 5224625, 5792404, 2684940, 3590483, 2733923, 2735138, 5621338, 7281591, 5217521, 2424497, 5960674, 2443326, 5790422, 2810666, 2441209, 2441046, 5787005, 2459611, 2428950, 5217323, 2430194, 2436653, 2436664, 2436529, 4267165, 8316890, 4267009, 5963046, 5963044, 5219581, 5219577, 5219571, 4267157, 4267161, 4267149, 2436616, 2436617, 5219557, 5219560, 5219558, 5219563, 5219559, 4267131, 5786340, 4267078, 7460229, 4267071, 2436535, 4267088, 5786266, 5219552, 5219544, 5707402, 5219553, 5219546, 5219550, 4267277, 5786121, 5786120, 7262062, 4267266, 4267267, 4267273, 5786125, 2436383, 9509736, 9410326, 2436393, 9291744, 9613557, 5707306, 8160643, 4266953, 9204783, 7409610, 5219548, 2441247, 2441703, 9244153, 5220103, 5219990, 2440248, 2440257, 2440145, 2440212, 2440207, 2440221, 2440206, 2440220, 2440222, 2440217, 2440048, 2433390, 2433385, 2435332, 5707023, 5218707, 5218703, 2432843, 7261770, 5706995, 2432850, 2432830, 2432826, 4265634, 5707082, 5218698, 5218648, 5218651, 5218680, 5218670, 5218683, 5218672, 8384945, 5218681, 5218690, 5218643, 5218689, 5218684, 5218645, 5218644, 5218675, 2432972, 2441011, 4262425, 5220124, 5706281, 5220130, 5220128, 2440980, 2440981, 2440945, 4262389, 5220121, 5220122, 7261381, 7261380, 7261388, 4262394, 2437650, 2437663, 2439749, 2438522, 2437225, 2438368, 2438816, 4264811, 4144259, 2435292, 2440993, 4971476, 2441215, 2441214, 4262887, 4262912, 4262911, 7859434, 2738087, 2440897, 2440896, 2440898, 2436938, 2436717, 2436749, 2436683, 2434674, 2434672, 2433635, 2434615, 5219333, 5219461, 2441018, 2441026, 8085503, 9227500, 2402728, 2402730, 2344356, 7305176, 2441165, 2441156, 2441164, 5220148, 7349281, 2441207, 2426957, 9575899, 2430467, 2732561, 2342096, 3662185, 3662755, 3662094, 3662076, 3662882, 3593837, 2440989, 2440990, 4262218, 5706471, 4262221, 3660334, 3992522, 3590325, 3592190, 3155099, 5217231, 2431146, 5217797, 5217778, 2427272, 2431101, 2424796, 10701161, 2431877, 2431130, 5217148, 2430540, 2430521, 2430530, 2430252, 5663154, 8046167, 3763583, 4097038, 4921557, 3969643, 5284080, 7522079, 4182249, 2440998, 5290048, 5290053, 2402084, 7475536, 7990192, 2423370, 2427297, 2883913, 2423153, 5218652, 7262640, 3764563, 2402231, 8479820, 2363136, 2362810, 2359615, 7970247, 8729702, 7416027, 5707385, 5219576, 5707396, 4266998, 4267000, 7262003, 7455384, 2476001, 2479545, 2495981, 5788499, 6092004, 2489032, 2493301, 2733413, 2428948, 2428946, 5789953, 2442800, 5220137, 2763088, 2424462, 2424508, 2424465, 5217566, 3616644, 2929168, 2440991, 10073041, 8187668, 8011274, 8869639, 5219446, 3624945, 7669959, 8064310, 4148645, 4147880, 3622111, 5231876, 2778202, 8087668, 7620105, 7462469, 7844550, 2971345, 2473543, 2430458, 2437546, 2432935, 2437348, 2437254, 5218693, 5220178, 4266932, 4266938, 2436432, 4266965, 4266967, 5219530, 7528726, 5219529, 5707429, 5707425, 2436424, 4266945, 4266975, 5786413, 5786406, 5786012, 9655824, 5786424, 5786423, 5786418, 7868037, 2971004, 2767106, 2766803, 2767104, 2766741, 3035874, 2738881, 2475906, 2479882, 5844228, 5232243, 2479617, 2489028, 2486347, 5232283, 4096611, 5786010, 3669732, 7282186, 7280469, 5620276, 7284419, 3959001, 3948643, 2433399, 5219633, 5786559, 5786560, 9932528, 5786561, 5219629, 2470852, 2440505, 2433401, 2441222, 2433403, 9022612, 2441535, 7755704, 8072617, 2443503, 9802482, 11041715, 2760239, 2760237, 2760200, 2760243, 2758886, 2758896, 2758867, 2758929, 10802512, 2758892, 2758820, 2459608, 4096841, 10829544, 3073586, 2886044, 7582362, 2886053, 3015037, 3014660, 3016123, 3014624, 5550177, 2482267, 4311512, 9555046, 9301372, 8724264, 9424203, 8783081, 9459191, 8899546, 9152161, 8750262, 8843868, 8940651, 8789660, 9220486, 8871232, 8762800, 9499554, 9392653, 9182758, 8934292, 6101193, 9460773, 2482178, 9510484, 3936453, 3955530) OR occurrence.familykey IN (2443474, 2441842, 2443244, 3959722, 5383990, 2443466, 2442749, 2443546, 2441533, 2443451, 4071375, 8346600, 4000160, 2443457, 5544122, 9662012, 2424472, 2441454, 5224625, 5792404, 2684940, 3590483, 2733923, 2735138, 5621338, 7281591, 5217521, 2424497, 5960674, 2443326, 5790422, 2810666, 2441209, 2441046, 5787005, 2459611, 2428950, 5217323, 2430194, 2436653, 2436664, 2436529, 4267165, 8316890, 4267009, 5963046, 5963044, 5219581, 5219577, 5219571, 4267157, 4267161, 4267149, 2436616, 2436617, 5219557, 5219560, 5219558, 5219563, 5219559, 4267131, 5786340, 4267078, 7460229, 4267071, 2436535, 4267088, 5786266, 5219552, 5219544, 5707402, 5219553, 5219546, 5219550, 4267277, 5786121, 5786120, 7262062, 4267266, 4267267, 4267273, 5786125, 2436383, 9509736, 9410326, 2436393, 9291744, 9613557, 5707306, 8160643, 4266953, 9204783, 7409610, 5219548, 2441247, 2441703, 9244153, 5220103, 5219990, 2440248, 2440257, 2440145, 2440212, 2440207, 2440221, 2440206, 2440220, 2440222, 2440217, 2440048, 2433390, 2433385, 2435332, 5707023, 5218707, 5218703, 2432843, 7261770, 5706995, 2432850, 2432830, 2432826, 4265634, 5707082, 5218698, 5218648, 5218651, 5218680, 5218670, 5218683, 5218672, 8384945, 5218681, 5218690, 5218643, 5218689, 5218684, 5218645, 5218644, 5218675, 2432972, 2441011, 4262425, 5220124, 5706281, 5220130, 5220128, 2440980, 2440981, 2440945, 4262389, 5220121, 5220122, 7261381, 7261380, 7261388, 4262394, 2437650, 2437663, 2439749, 2438522, 2437225, 2438368, 2438816, 4264811, 4144259, 2435292, 2440993, 4971476, 2441215, 2441214, 4262887, 4262912, 4262911, 7859434, 2738087, 2440897, 2440896, 2440898, 2436938, 2436717, 2436749, 2436683, 2434674, 2434672, 2433635, 2434615, 5219333, 5219461, 2441018, 2441026, 8085503, 9227500, 2402728, 2402730, 2344356, 7305176, 2441165, 2441156, 2441164, 5220148, 7349281, 2441207, 2426957, 9575899, 2430467, 2732561, 2342096, 3662185, 3662755, 3662094, 3662076, 3662882, 3593837, 2440989, 2440990, 4262218, 5706471, 4262221, 3660334, 3992522, 3590325, 3592190, 3155099, 5217231, 2431146, 5217797, 5217778, 2427272, 2431101, 2424796, 10701161, 2431877, 2431130, 5217148, 2430540, 2430521, 2430530, 2430252, 5663154, 8046167, 3763583, 4097038, 4921557, 3969643, 5284080, 7522079, 4182249, 2440998, 5290048, 5290053, 2402084, 7475536, 7990192, 2423370, 2427297, 2883913, 2423153, 5218652, 7262640, 3764563, 2402231, 8479820, 2363136, 2362810, 2359615, 7970247, 8729702, 7416027, 5707385, 5219576, 5707396, 4266998, 4267000, 7262003, 7455384, 2476001, 2479545, 2495981, 5788499, 6092004, 2489032, 2493301, 2733413, 2428948, 2428946, 5789953, 2442800, 5220137, 2763088, 2424462, 2424508, 2424465, 5217566, 3616644, 2929168, 2440991, 10073041, 8187668, 8011274, 8869639, 5219446, 3624945, 7669959, 8064310, 4148645, 4147880, 3622111, 5231876, 2778202, 8087668, 7620105, 7462469, 7844550, 2971345, 2473543, 2430458, 2437546, 2432935, 2437348, 2437254, 5218693, 5220178, 4266932, 4266938, 2436432, 4266965, 4266967, 5219530, 7528726, 5219529, 5707429, 5707425, 2436424, 4266945, 4266975, 5786413, 5786406, 5786012, 9655824, 5786424, 5786423, 5786418, 7868037, 2971004, 2767106, 2766803, 2767104, 2766741, 3035874, 2738881, 2475906, 2479882, 5844228, 5232243, 2479617, 2489028, 2486347, 5232283, 4096611, 5786010, 3669732, 7282186, 7280469, 5620276, 7284419, 3959001, 3948643, 2433399, 5219633, 5786559, 5786560, 9932528, 5786561, 5219629, 2470852, 2440505, 2433401, 2441222, 2433403, 9022612, 2441535, 7755704, 8072617, 2443503, 9802482, 11041715, 2760239, 2760237, 2760200, 2760243, 2758886, 2758896, 2758867, 2758929, 10802512, 2758892, 2758820, 2459608, 4096841, 10829544, 3073586, 2886044, 7582362, 2886053, 3015037, 3014660, 3016123, 3014624, 5550177, 2482267, 4311512, 9555046, 9301372, 8724264, 9424203, 8783081, 9459191, 8899546, 9152161, 8750262, 8843868, 8940651, 8789660, 9220486, 8871232, 8762800, 9499554, 9392653, 9182758, 8934292, 6101193, 9460773, 2482178, 9510484, 3936453, 3955530) OR occurrence.genuskey IN (2443474, 2441842, 2443244, 3959722, 5383990, 2443466, 2442749, 2443546, 2441533, 2443451, 4071375, 8346600, 4000160, 2443457, 5544122, 9662012, 2424472, 2441454, 5224625, 5792404, 2684940, 3590483, 2733923, 2735138, 5621338, 7281591, 5217521, 2424497, 5960674, 2443326, 5790422, 2810666, 2441209, 2441046, 5787005, 2459611, 2428950, 5217323, 2430194, 2436653, 2436664, 2436529, 4267165, 8316890, 4267009, 5963046, 5963044, 5219581, 5219577, 5219571, 4267157, 4267161, 4267149, 2436616, 2436617, 5219557, 5219560, 5219558, 5219563, 5219559, 4267131, 5786340, 4267078, 7460229, 4267071, 2436535, 4267088, 5786266, 5219552, 5219544, 5707402, 5219553, 5219546, 5219550, 4267277, 5786121, 5786120, 7262062, 4267266, 4267267, 4267273, 5786125, 2436383, 9509736, 9410326, 2436393, 9291744, 9613557, 5707306, 8160643, 4266953, 9204783, 7409610, 5219548, 2441247, 2441703, 9244153, 5220103, 5219990, 2440248, 2440257, 2440145, 2440212, 2440207, 2440221, 2440206, 2440220, 2440222, 2440217, 2440048, 2433390, 2433385, 2435332, 5707023, 5218707, 5218703, 2432843, 7261770, 5706995, 2432850, 2432830, 2432826, 4265634, 5707082, 5218698, 5218648, 5218651, 5218680, 5218670, 5218683, 5218672, 8384945, 5218681, 5218690, 5218643, 5218689, 5218684, 5218645, 5218644, 5218675, 2432972, 2441011, 4262425, 5220124, 5706281, 5220130, 5220128, 2440980, 2440981, 2440945, 4262389, 5220121, 5220122, 7261381, 7261380, 7261388, 4262394, 2437650, 2437663, 2439749, 2438522, 2437225, 2438368, 2438816, 4264811, 4144259, 2435292, 2440993, 4971476, 2441215, 2441214, 4262887, 4262912, 4262911, 7859434, 2738087, 2440897, 2440896, 2440898, 2436938, 2436717, 2436749, 2436683, 2434674, 2434672, 2433635, 2434615, 5219333, 5219461, 2441018, 2441026, 8085503, 9227500, 2402728, 2402730, 2344356, 7305176, 2441165, 2441156, 2441164, 5220148, 7349281, 2441207, 2426957, 9575899, 2430467, 2732561, 2342096, 3662185, 3662755, 3662094, 3662076, 3662882, 3593837, 2440989, 2440990, 4262218, 5706471, 4262221, 3660334, 3992522, 3590325, 3592190, 3155099, 5217231, 2431146, 5217797, 5217778, 2427272, 2431101, 2424796, 10701161, 2431877, 2431130, 5217148, 2430540, 2430521, 2430530, 2430252, 5663154, 8046167, 3763583, 4097038, 4921557, 3969643, 5284080, 7522079, 4182249, 2440998, 5290048, 5290053, 2402084, 7475536, 7990192, 2423370, 2427297, 2883913, 2423153, 5218652, 7262640, 3764563, 2402231, 8479820, 2363136, 2362810, 2359615, 7970247, 8729702, 7416027, 5707385, 5219576, 5707396, 4266998, 4267000, 7262003, 7455384, 2476001, 2479545, 2495981, 5788499, 6092004, 2489032, 2493301, 2733413, 2428948, 2428946, 5789953, 2442800, 5220137, 2763088, 2424462, 2424508, 2424465, 5217566, 3616644, 2929168, 2440991, 10073041, 8187668, 8011274, 8869639, 5219446, 3624945, 7669959, 8064310, 4148645, 4147880, 3622111, 5231876, 2778202, 8087668, 7620105, 7462469, 7844550, 2971345, 2473543, 2430458, 2437546, 2432935, 2437348, 2437254, 5218693, 5220178, 4266932, 4266938, 2436432, 4266965, 4266967, 5219530, 7528726, 5219529, 5707429, 5707425, 2436424, 4266945, 4266975, 5786413, 5786406, 5786012, 9655824, 5786424, 5786423, 5786418, 7868037, 2971004, 2767106, 2766803, 2767104, 2766741, 3035874, 2738881, 2475906, 2479882, 5844228, 5232243, 2479617, 2489028, 2486347, 5232283, 4096611, 5786010, 3669732, 7282186, 7280469, 5620276, 7284419, 3959001, 3948643, 2433399, 5219633, 5786559, 5786560, 9932528, 5786561, 5219629, 2470852, 2440505, 2433401, 2441222, 2433403, 9022612, 2441535, 7755704, 8072617, 2443503, 9802482, 11041715, 2760239, 2760237, 2760200, 2760243, 2758886, 2758896, 2758867, 2758929, 10802512, 2758892, 2758820, 2459608, 4096841, 10829544, 3073586, 2886044, 7582362, 2886053, 3015037, 3014660, 3016123, 3014624, 5550177, 2482267, 4311512, 9555046, 9301372, 8724264, 9424203, 8783081, 9459191, 8899546, 9152161, 8750262, 8843868, 8940651, 8789660, 9220486, 8871232, 8762800, 9499554, 9392653, 9182758, 8934292, 6101193, 9460773, 2482178, 9510484, 3936453, 3955530) OR occurrence.specieskey IN (2443474, 2441842, 2443244, 3959722, 5383990, 2443466, 2442749, 2443546, 2441533, 2443451, 4071375, 8346600, 4000160, 2443457, 5544122, 9662012, 2424472, 2441454, 5224625, 5792404, 2684940, 3590483, 2733923, 2735138, 5621338, 7281591, 5217521, 2424497, 5960674, 2443326, 5790422, 2810666, 2441209, 2441046, 5787005, 2459611, 2428950, 5217323, 2430194, 2436653, 2436664, 2436529, 4267165, 8316890, 4267009, 5963046, 5963044, 5219581, 5219577, 5219571, 4267157, 4267161, 4267149, 2436616, 2436617, 5219557, 5219560, 5219558, 5219563, 5219559, 4267131, 5786340, 4267078, 7460229, 4267071, 2436535, 4267088, 5786266, 5219552, 5219544, 5707402, 5219553, 5219546, 5219550, 4267277, 5786121, 5786120, 7262062, 4267266, 4267267, 4267273, 5786125, 2436383, 9509736, 9410326, 2436393, 9291744, 9613557, 5707306, 8160643, 4266953, 9204783, 7409610, 5219548, 2441247, 2441703, 9244153, 5220103, 5219990, 2440248, 2440257, 2440145, 2440212, 2440207, 2440221, 2440206, 2440220, 2440222, 2440217, 2440048, 2433390, 2433385, 2435332, 5707023, 5218707, 5218703, 2432843, 7261770, 5706995, 2432850, 2432830, 2432826, 4265634, 5707082, 5218698, 5218648, 5218651, 5218680, 5218670, 5218683, 5218672, 8384945, 5218681, 5218690, 5218643, 5218689, 5218684, 5218645, 5218644, 5218675, 2432972, 2441011, 4262425, 5220124, 5706281, 5220130, 5220128, 2440980, 2440981, 2440945, 4262389, 5220121, 5220122, 7261381, 7261380, 7261388, 4262394, 2437650, 2437663, 2439749, 2438522, 2437225, 2438368, 2438816, 4264811, 4144259, 2435292, 2440993, 4971476, 2441215, 2441214, 4262887, 4262912, 4262911, 7859434, 2738087, 2440897, 2440896, 2440898, 2436938, 2436717, 2436749, 2436683, 2434674, 2434672, 2433635, 2434615, 5219333, 5219461, 2441018, 2441026, 8085503, 9227500, 2402728, 2402730, 2344356, 7305176, 2441165, 2441156, 2441164, 5220148, 7349281, 2441207, 2426957, 9575899, 2430467, 2732561, 2342096, 3662185, 3662755, 3662094, 3662076, 3662882, 3593837, 2440989, 2440990, 4262218, 5706471, 4262221, 3660334, 3992522, 3590325, 3592190, 3155099, 5217231, 2431146, 5217797, 5217778, 2427272, 2431101, 2424796, 10701161, 2431877, 2431130, 5217148, 2430540, 2430521, 2430530, 2430252, 5663154, 8046167, 3763583, 4097038, 4921557, 3969643, 5284080, 7522079, 4182249, 2440998, 5290048, 5290053, 2402084, 7475536, 7990192, 2423370, 2427297, 2883913, 2423153, 5218652, 7262640, 3764563, 2402231, 8479820, 2363136, 2362810, 2359615, 7970247, 8729702, 7416027, 5707385, 5219576, 5707396, 4266998, 4267000, 7262003, 7455384, 2476001, 2479545, 2495981, 5788499, 6092004, 2489032, 2493301, 2733413, 2428948, 2428946, 5789953, 2442800, 5220137, 2763088, 2424462, 2424508, 2424465, 5217566, 3616644, 2929168, 2440991, 10073041, 8187668, 8011274, 8869639, 5219446, 3624945, 7669959, 8064310, 4148645, 4147880, 3622111, 5231876, 2778202, 8087668, 7620105, 7462469, 7844550, 2971345, 2473543, 2430458, 2437546, 2432935, 2437348, 2437254, 5218693, 5220178, 4266932, 4266938, 2436432, 4266965, 4266967, 5219530, 7528726, 5219529, 5707429, 5707425, 2436424, 4266945, 4266975, 5786413, 5786406, 5786012, 9655824, 5786424, 5786423, 5786418, 7868037, 2971004, 2767106, 2766803, 2767104, 2766741, 3035874, 2738881, 2475906, 2479882, 5844228, 5232243, 2479617, 2489028, 2486347, 5232283, 4096611, 5786010, 3669732, 7282186, 7280469, 5620276, 7284419, 3959001, 3948643, 2433399, 5219633, 5786559, 5786560, 9932528, 5786561, 5219629, 2470852, 2440505, 2433401, 2441222, 2433403, 9022612, 2441535, 7755704, 8072617, 2443503, 9802482, 11041715, 2760239, 2760237, 2760200, 2760243, 2758886, 2758896, 2758867, 2758929, 10802512, 2758892, 2758820, 2459608, 4096841, 10829544, 3073586, 2886044, 7582362, 2886053, 3015037, 3014660, 3016123, 3014624, 5550177, 2482267, 4311512, 9555046, 9301372, 8724264, 9424203, 8783081, 9459191, 8899546, 9152161, 8750262, 8843868, 8940651, 8789660, 9220486, 8871232, 8762800, 9499554, 9392653, 9182758, 8934292, 6101193, 9460773, 2482178, 9510484, 3936453, 3955530))
 AND occurrence.hasgeospatialissues = FALSE
 AND NOT GBIF_STRINGARRAYCONTAINS(occurrence.issue, 'TAXON_MATCH_FUZZY', TRUE)
 AND (occurrence.distancefromcentroidinmeters &gt;= 2000.0 OR occurrence.distancefromcentroidinmeters IS NULL)
 AND NOT occurrence.basisofrecord IN ('FOSSIL_SPECIMEN', 'LIVING_SPECIMEN')
 AND (occurrence.specieskey IS NOT NULL AND occurrence."year" IS NOT NULL AND occurrence.hascoordinate = TRUE)
GROUP BY
 occurrence.kingdom,
 occurrence.kingdomkey,
 occurrence.phylum,
 occurrence.phylumkey,
 occurrence.class,
 occurrence.classkey,
 occurrence."order",
 occurrence.orderkey,
 occurrence.family,
 occurrence.familykey,
 occurrence.genus,
 occurrence.genuskey,
 occurrence.species,
 occurrence.specieskey,
 occurrence."year",
 GBIF_EQDGCODE(3, decimallatitude, decimallongitude, COALESCE(coordinateuncertaintyinmeters, 1000))

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