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