Project

General

Profile

« Previous | Next » 

Revision 9920

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/.geoscrub/geoscrub_output/postprocess.sql: coords index: added rest of input columns so this can be used to check the existence of a result by input. added runtime (55 s). use idempotent create_if_not_exists().

View differences:

postprocess.sql
1 
SELECT util.search_path_append('util');
2 

  		




  1
  3
  
    
ALTER TABLE :table ALTER COLUMN decimallatitude SET NOT NULL;


  		




  2
  4
  
    
ALTER TABLE :table ALTER COLUMN decimallongitude SET NOT NULL;


  		




  3
  5
  
    

  		




  4
  
  
    
CREATE INDEX ON :table (decimallatitude, decimallongitude);


  		




  
  6
  
    
-- runtime: 55 s ("real 0m53.677s")


  		




  
  7
  
    
SELECT create_if_not_exists($$CREATE INDEX geoscrub_output_input ON geoscrub_output (decimallatitude, decimallongitude, country, stateprovince, county)$$);


  		












Also available in:  Unified diff