SELECT DISTINCT ON ("latitudeDecimalVerbatim", "longitudeDecimalVerbatim") "latitudeDecimalVerbatim" , "longitudeDecimalVerbatim" , "isCultivated" , "isCultivatedReason" FROM geoscrub_cleaned_unique ; ALTER TABLE :table ADD PRIMARY KEY ("latitudeDecimalVerbatim", "longitudeDecimalVerbatim");