Georeferenced genbank sequence accession numbers from GBIF

<blockquote> <p>Request =&nbsp;I am interested in only occurrence records that have both coordinates and accessions. Unfortunately, it appears that while I can specify &ldquo;Including coordinates&rdquo; in Advance search, there is no &ldquo;Including accessions&rdquo;.</p> </blockquote> <p>GBIF: Custom HiveSQL query on the GBIF occurrence store.</p> <pre><code class="language-sql">SELECT o.associatedSequences, o.gbifID, o.decimalLatitude, o.decimalLongitude, o.kingdom, o.phylum, o.class, o.order_, o.family, o.genus, o.species, o.infraspecificEpithet, o.basisOfRecord, o.v_geodeticdatum, o.coordinateuncertaintyinmeters, o.issue FROM prod_h.occurrence_hdfs o WHERE o.associatedSequences IS NOT NULL AND o.decimalLatitude IS NOT NULL AND o.hasgeospatialissues = false</code></pre> <p>98 GBIF datasets contributed to this data export.</p> <p>Total records =&nbsp;9,181,930</p>