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