Revision 6112
Added by Aaron Marcuse-Kubitza about 12 years ago
inputs/.geoscrub/geoscrub_cleaned_unique/create.sql | ||
---|---|---|
28 | 28 |
|
29 | 29 |
ALTER TABLE :table ALTER COLUMN "latitudeDecimalVerbatim" TYPE double precision; |
30 | 30 |
ALTER TABLE :table ALTER COLUMN "longitudeDecimalVerbatim" TYPE double precision; |
31 |
|
|
32 |
CREATE INDEX ON :table ("latitudeDecimalVerbatim", "longitudeDecimalVerbatim"); |
Also available in: Unified diff
inputs/.geoscrub/geoscrub_cleaned_unique/create.sql: Removed no longer needed index on latitudeDecimalVerbatim, longitudeDecimalVerbatim, which is now on geoscrub_cultivated instead