text: CREATE TABLE IF NOT EXISTS gbif2020
  (gbif_gbifid UNSIGNED INT,
  gbif_eventdate VARCHAR(255),
  gbif_kingdom VARCHAR(255),
  gbif_phylum VARCHAR(255),
  gbif_class VARCHAR(255),
  gbif_order VARCHAR(255),
  gbif_family VARCHAR(255),
  gbif_genus VARCHAR(255),
  gbif_infraspecificepithet VARCHAR(255),
  gbif_species VARCHAR(255),
  gbif_locality LONGTEXT,
  gbif_publishingorgkey VARCHAR(255),
  gbif_taxonkey VARCHAR(255),
  gbif_lastinterpreted VARCHAR(255),
  gbif_institutioncode VARCHAR(255),
  gbif_coordinateuncertaintyinmeters VARCHAR(255),
  gbif_decimallatitude FLOAT NOT NULL,
  gbif_decimallongitude FLOAT NOT NULL,
  taxonomicgroup VARCHAR(255)
  )
  CHARACTER SET utf8mb4;
  
  CREATE TABLE IF NOT EXISTS gbif2020_coordinate
  (gbif_gbifid UNSIGNED INT,
  coordinate POINT NOT NULL SRID 4326,
  SPATIAL INDEX idx_coord (coordinate)
  )
  CHARACTER SET utf8mb4;
  
  CREATE TABLE IF NOT EXISTS gbif2020_org_lookup
  (gbif_publishingorgkey VARCHAR(255) PRIMARY KEY,
  title VARCHAR(255)
  )
  CHARACTER SET utf8mb4;
  