root/inputs/.geoscrub/geoscrub_cultivated/create.sql @ 6112
| 1 |
SELECT
|
|---|---|
| 2 |
DISTINCT ON ("latitudeDecimalVerbatim", "longitudeDecimalVerbatim") |
| 3 |
"latitudeDecimalVerbatim"
|
| 4 |
, "longitudeDecimalVerbatim" |
| 5 |
, "isCultivated" |
| 6 |
, "isCultivatedReason" |
| 7 |
FROM geoscrub_cleaned_unique |
| 8 |
;
|
| 9 |
|
| 10 |
ALTER TABLE :table ADD PRIMARY KEY ("latitudeDecimalVerbatim", "longitudeDecimalVerbatim"); |