SELECT
DISTINCT ON ("latitudeDecimalVerbatim", "longitudeDecimalVerbatim")
  "latitudeDecimalVerbatim"
, "longitudeDecimalVerbatim"
, "isCultivated"
, "isCultivatedReason"
FROM geoscrub_cleaned_unique
WHERE
"latitudeDecimalVerbatim" IS NOT NULL
AND "longitudeDecimalVerbatim" IS NOT NULL
;

ALTER TABLE :table ADD PRIMARY KEY ("latitudeDecimalVerbatim", "longitudeDecimalVerbatim");