Project

General

Profile

« Previous | Next » 

Revision 6109

Added by Aaron Marcuse-Kubitza about 12 years ago

inputs/.geoscrub/geoscrub_cleaned_unique/create.sql: Added index on latitudeDecimalVerbatim, longitudeDecimalVerbatim for use by analytical_stem_view

View differences:

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