Export of GBIF record counts by 1 degree cell, addressed on south-west of cell

tom.sql

CREATE TABLE tim.tom_export ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' AS
SELECT 
  CAST(decimalLatitude AS INT) AS lat,
  CAST(decimalLongitude AS INT) AS lng,
  count(*) AS total
FROM 
  prod_a.occurrence_hdfs
WHERE
  hasGeospatialIssues=0 AND decimalLatitude IS NOT NULL AND decimalLatitude IS NOT NULL
GROUP BY
  CAST(decimalLatitude AS INT),
  CAST(decimalLongitude AS INT)