root/inputs/.geoscrub/geoscrub_cultivated/create.sql @ 6143
| 1 | 6110 | aaronmk | 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"); |