Project

General

Profile

« Previous | Next » 

Revision 6205

inputs/.geoscrub/geoscrub_cultivated/create.sql: Fixed bug where need to filter out NULL lat/longs because primary keys can't contain NULL values

View differences:

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