Revision 6205
Added by Aaron Marcuse-Kubitza over 11 years ago
| inputs/.geoscrub/geoscrub_cultivated/create.sql | ||
|---|---|---|
| 5 | 5 |
, "isCultivated" |
| 6 | 6 |
, "isCultivatedReason" |
| 7 | 7 |
FROM geoscrub_cleaned_unique |
| 8 |
WHERE |
|
| 9 |
"latitudeDecimalVerbatim" IS NOT NULL |
|
| 10 |
AND "longitudeDecimalVerbatim" IS NOT NULL |
|
| 8 | 11 |
; |
| 9 | 12 |
|
| 10 | 13 |
ALTER TABLE :table ADD PRIMARY KEY ("latitudeDecimalVerbatim", "longitudeDecimalVerbatim");
|
Also available in: Unified diff
inputs/.geoscrub/geoscrub_cultivated/create.sql: Fixed bug where need to filter out NULL lat/longs because primary keys can't contain NULL values