Project

General

Profile

« Previous | Next » 

Revision 6106

Added by Aaron Marcuse-Kubitza about 12 years ago

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

View differences:

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