Revision 6106
Added by Aaron Marcuse-Kubitza over 11 years ago
| inputs/.geoscrub/geoscrub_cleaned_unique/create.sql | ||
|---|---|---|
| 25 | 25 |
|
| 26 | 26 |
ALTER TABLE :table ADD PRIMARY KEY ("geoscrubID");
|
| 27 | 27 |
ALTER TABLE :table ADD UNIQUE ("sourceID");
|
| 28 |
|
|
| 29 |
ALTER TABLE :table ALTER COLUMN "latitudeDecimalVerbatim" TYPE double precision; |
|
| 30 |
ALTER TABLE :table ALTER COLUMN "longitudeDecimalVerbatim" TYPE double precision; |
|
Also available in: Unified diff
inputs/.geoscrub/geoscrub_cleaned_unique/create.sql: Change latitudeDecimalVerbatim, longitudeDecimalVerbatim types to double precision to allow merge-joining with coordinates.latitude_deg, longitude_deg in analytical_stem_view