DOI: 10.15468/dl.2zpfx4
title: Occurrence Download

description: A dataset containing 1519 records in GBIF matching the query:
SELECT
 kingdom,
 kingdomkey,
 phylum,
 phylumkey,
 class,
 classkey,
 "order",
 orderkey,
 family,
 familykey,
 genus,
 genuskey,
 species,
 specieskey,
 "year",
 IF(ISNULL(kingdomkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY kingdomkey, "year")) kingdomcount,
 IF(ISNULL(phylumkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY phylumkey, "year")) phylumcount,
 IF(ISNULL(classkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY classkey, "year")) classcount,
 IF(ISNULL(orderkey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY orderkey, "year")) ordercount,
 IF(ISNULL(familykey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY familykey, "year")) familycount,
 IF(ISNULL(genuskey), NULL, SUM(COUNT(*)) OVER (
 PARTITION BY genuskey, "year")) genuscount,
 COUNT(*) occurrences,
 MIN(GBIF_TEMPORALUNCERTAINTY(eventdate, eventtime)) mintemporaluncertainty,
 MIN(COALESCE(coordinateuncertaintyinmeters, 1000)) mincoordinateuncertaintyinmeters
FROM
 occurrence
WHERE
 (occurrence.level0gid = 'NZL.1_1' OR occurrence.level1gid = 'NZL.1_1' OR occurrence.level2gid = 'NZL.1_1' OR occurrence.level3gid = 'NZL.1_1')
 AND (occurrence.taxonkey IN (5554574, 7326529, 3686203, 3758717, 9961935, 7655198, 9395377, 3756590, 8110979, 8423677, 2867616, 2867568, 2867589, 3036501, 3037314, 3637384, 3636716, 3037484, 3037289, 9266918, 3635883, 3635464, 3635464, 3637717, 3037459, 3037306, 8811004, 3932870, 4927547, 2766221, 2768118, 8401316, 2768116, 4258167, 4257209, 7310982, 2853078, 2853097, 2853065, 10802810, 10921534, 10869444, 9537837, 9276354, 9618673, 5665848, 5665902, 9373403, 9439711, 9339550, 7296869, 5661288, 12164264, 5660707, 11414911, 8863147, 2756470, 5407831, 5413693, 5413751, 4931522, 7266874, 7266874, 7596106, 3138492, 3138922, 5391289, 7889845, 7065884, 5692103, 3108498, 8220663, 4933750, 4250359, 3097484, 3106878, 3108752, 7951429, 3097524, 5405164, 3105836, 8316673, 3142124, 5405174, 3108315, 4231827, 6292833, 5391285, 7065973, 7623127, 3131936, 5405320, 3111878, 3093331, 3108272, 7223014, 3108199, 3107661, 3096980, 3108566, 12206334, 3108278) OR occurrence.acceptedtaxonkey IN (5554574, 7326529, 3686203, 3758717, 9961935, 7655198, 9395377, 3756590, 8110979, 8423677, 2867616, 2867568, 2867589, 3036501, 3037314, 3637384, 3636716, 3037484, 3037289, 9266918, 3635883, 3635464, 3635464, 3637717, 3037459, 3037306, 8811004, 3932870, 4927547, 2766221, 2768118, 8401316, 2768116, 4258167, 4257209, 7310982, 2853078, 2853097, 2853065, 10802810, 10921534, 10869444, 9537837, 9276354, 9618673, 5665848, 5665902, 9373403, 9439711, 9339550, 7296869, 5661288, 12164264, 5660707, 11414911, 8863147, 2756470, 5407831, 5413693, 5413751, 4931522, 7266874, 7266874, 7596106, 3138492, 3138922, 5391289, 7889845, 7065884, 5692103, 3108498, 8220663, 4933750, 4250359, 3097484, 3106878, 3108752, 7951429, 3097524, 5405164, 3105836, 8316673, 3142124, 5405174, 3108315, 4231827, 6292833, 5391285, 7065973, 7623127, 3131936, 5405320, 3111878, 3093331, 3108272, 7223014, 3108199, 3107661, 3096980, 3108566, 12206334, 3108278) OR occurrence.kingdomkey IN (5554574, 7326529, 3686203, 3758717, 9961935, 7655198, 9395377, 3756590, 8110979, 8423677, 2867616, 2867568, 2867589, 3036501, 3037314, 3637384, 3636716, 3037484, 3037289, 9266918, 3635883, 3635464, 3635464, 3637717, 3037459, 3037306, 8811004, 3932870, 4927547, 2766221, 2768118, 8401316, 2768116, 4258167, 4257209, 7310982, 2853078, 2853097, 2853065, 10802810, 10921534, 10869444, 9537837, 9276354, 9618673, 5665848, 5665902, 9373403, 9439711, 9339550, 7296869, 5661288, 12164264, 5660707, 11414911, 8863147, 2756470, 5407831, 5413693, 5413751, 4931522, 7266874, 7266874, 7596106, 3138492, 3138922, 5391289, 7889845, 7065884, 5692103, 3108498, 8220663, 4933750, 4250359, 3097484, 3106878, 3108752, 7951429, 3097524, 5405164, 3105836, 8316673, 3142124, 5405174, 3108315, 4231827, 6292833, 5391285, 7065973, 7623127, 3131936, 5405320, 3111878, 3093331, 3108272, 7223014, 3108199, 3107661, 3096980, 3108566, 12206334, 3108278) OR occurrence.phylumkey IN (5554574, 7326529, 3686203, 3758717, 9961935, 7655198, 9395377, 3756590, 8110979, 8423677, 2867616, 2867568, 2867589, 3036501, 3037314, 3637384, 3636716, 3037484, 3037289, 9266918, 3635883, 3635464, 3635464, 3637717, 3037459, 3037306, 8811004, 3932870, 4927547, 2766221, 2768118, 8401316, 2768116, 4258167, 4257209, 7310982, 2853078, 2853097, 2853065, 10802810, 10921534, 10869444, 9537837, 9276354, 9618673, 5665848, 5665902, 9373403, 9439711, 9339550, 7296869, 5661288, 12164264, 5660707, 11414911, 8863147, 2756470, 5407831, 5413693, 5413751, 4931522, 7266874, 7266874, 7596106, 3138492, 3138922, 5391289, 7889845, 7065884, 5692103, 3108498, 8220663, 4933750, 4250359, 3097484, 3106878, 3108752, 7951429, 3097524, 5405164, 3105836, 8316673, 3142124, 5405174, 3108315, 4231827, 6292833, 5391285, 7065973, 7623127, 3131936, 5405320, 3111878, 3093331, 3108272, 7223014, 3108199, 3107661, 3096980, 3108566, 12206334, 3108278) OR occurrence.classkey IN (5554574, 7326529, 3686203, 3758717, 9961935, 7655198, 9395377, 3756590, 8110979, 8423677, 2867616, 2867568, 2867589, 3036501, 3037314, 3637384, 3636716, 3037484, 3037289, 9266918, 3635883, 3635464, 3635464, 3637717, 3037459, 3037306, 8811004, 3932870, 4927547, 2766221, 2768118, 8401316, 2768116, 4258167, 4257209, 7310982, 2853078, 2853097, 2853065, 10802810, 10921534, 10869444, 9537837, 9276354, 9618673, 5665848, 5665902, 9373403, 9439711, 9339550, 7296869, 5661288, 12164264, 5660707, 11414911, 8863147, 2756470, 5407831, 5413693, 5413751, 4931522, 7266874, 7266874, 7596106, 3138492, 3138922, 5391289, 7889845, 7065884, 5692103, 3108498, 8220663, 4933750, 4250359, 3097484, 3106878, 3108752, 7951429, 3097524, 5405164, 3105836, 8316673, 3142124, 5405174, 3108315, 4231827, 6292833, 5391285, 7065973, 7623127, 3131936, 5405320, 3111878, 3093331, 3108272, 7223014, 3108199, 3107661, 3096980, 3108566, 12206334, 3108278) OR occurrence.orderkey IN (5554574, 7326529, 3686203, 3758717, 9961935, 7655198, 9395377, 3756590, 8110979, 8423677, 2867616, 2867568, 2867589, 3036501, 3037314, 3637384, 3636716, 3037484, 3037289, 9266918, 3635883, 3635464, 3635464, 3637717, 3037459, 3037306, 8811004, 3932870, 4927547, 2766221, 2768118, 8401316, 2768116, 4258167, 4257209, 7310982, 2853078, 2853097, 2853065, 10802810, 10921534, 10869444, 9537837, 9276354, 9618673, 5665848, 5665902, 9373403, 9439711, 9339550, 7296869, 5661288, 12164264, 5660707, 11414911, 8863147, 2756470, 5407831, 5413693, 5413751, 4931522, 7266874, 7266874, 7596106, 3138492, 3138922, 5391289, 7889845, 7065884, 5692103, 3108498, 8220663, 4933750, 4250359, 3097484, 3106878, 3108752, 7951429, 3097524, 5405164, 3105836, 8316673, 3142124, 5405174, 3108315, 4231827, 6292833, 5391285, 7065973, 7623127, 3131936, 5405320, 3111878, 3093331, 3108272, 7223014, 3108199, 3107661, 3096980, 3108566, 12206334, 3108278) OR occurrence.familykey IN (5554574, 7326529, 3686203, 3758717, 9961935, 7655198, 9395377, 3756590, 8110979, 8423677, 2867616, 2867568, 2867589, 3036501, 3037314, 3637384, 3636716, 3037484, 3037289, 9266918, 3635883, 3635464, 3635464, 3637717, 3037459, 3037306, 8811004, 3932870, 4927547, 2766221, 2768118, 8401316, 2768116, 4258167, 4257209, 7310982, 2853078, 2853097, 2853065, 10802810, 10921534, 10869444, 9537837, 9276354, 9618673, 5665848, 5665902, 9373403, 9439711, 9339550, 7296869, 5661288, 12164264, 5660707, 11414911, 8863147, 2756470, 5407831, 5413693, 5413751, 4931522, 7266874, 7266874, 7596106, 3138492, 3138922, 5391289, 7889845, 7065884, 5692103, 3108498, 8220663, 4933750, 4250359, 3097484, 3106878, 3108752, 7951429, 3097524, 5405164, 3105836, 8316673, 3142124, 5405174, 3108315, 4231827, 6292833, 5391285, 7065973, 7623127, 3131936, 5405320, 3111878, 3093331, 3108272, 7223014, 3108199, 3107661, 3096980, 3108566, 12206334, 3108278) OR occurrence.genuskey IN (5554574, 7326529, 3686203, 3758717, 9961935, 7655198, 9395377, 3756590, 8110979, 8423677, 2867616, 2867568, 2867589, 3036501, 3037314, 3637384, 3636716, 3037484, 3037289, 9266918, 3635883, 3635464, 3635464, 3637717, 3037459, 3037306, 8811004, 3932870, 4927547, 2766221, 2768118, 8401316, 2768116, 4258167, 4257209, 7310982, 2853078, 2853097, 2853065, 10802810, 10921534, 10869444, 9537837, 9276354, 9618673, 5665848, 5665902, 9373403, 9439711, 9339550, 7296869, 5661288, 12164264, 5660707, 11414911, 8863147, 2756470, 5407831, 5413693, 5413751, 4931522, 7266874, 7266874, 7596106, 3138492, 3138922, 5391289, 7889845, 7065884, 5692103, 3108498, 8220663, 4933750, 4250359, 3097484, 3106878, 3108752, 7951429, 3097524, 5405164, 3105836, 8316673, 3142124, 5405174, 3108315, 4231827, 6292833, 5391285, 7065973, 7623127, 3131936, 5405320, 3111878, 3093331, 3108272, 7223014, 3108199, 3107661, 3096980, 3108566, 12206334, 3108278) OR occurrence.specieskey IN (5554574, 7326529, 3686203, 3758717, 9961935, 7655198, 9395377, 3756590, 8110979, 8423677, 2867616, 2867568, 2867589, 3036501, 3037314, 3637384, 3636716, 3037484, 3037289, 9266918, 3635883, 3635464, 3635464, 3637717, 3037459, 3037306, 8811004, 3932870, 4927547, 2766221, 2768118, 8401316, 2768116, 4258167, 4257209, 7310982, 2853078, 2853097, 2853065, 10802810, 10921534, 10869444, 9537837, 9276354, 9618673, 5665848, 5665902, 9373403, 9439711, 9339550, 7296869, 5661288, 12164264, 5660707, 11414911, 8863147, 2756470, 5407831, 5413693, 5413751, 4931522, 7266874, 7266874, 7596106, 3138492, 3138922, 5391289, 7889845, 7065884, 5692103, 3108498, 8220663, 4933750, 4250359, 3097484, 3106878, 3108752, 7951429, 3097524, 5405164, 3105836, 8316673, 3142124, 5405174, 3108315, 4231827, 6292833, 5391285, 7065973, 7623127, 3131936, 5405320, 3111878, 3093331, 3108272, 7223014, 3108199, 3107661, 3096980, 3108566, 12206334, 3108278))
 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.occurrencestatus = 'PRESENT'
 AND (occurrence.specieskey IS NOT NULL AND occurrence."year" IS NOT NULL)
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"

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