Project

General

Profile

« Previous | Next » 

Revision 11873

Added by Aaron Marcuse-Kubitza over 10 years ago

inputs/.geoscrub/import_order.txt: added county_centroids so that it would be installed by new-style import

View differences:

inputs/.geoscrub/import_order.txt
1 1 
Source
2 
county_centroids
2 3 
geoscrub_output
inputs/.geoscrub/county_centroids/postprocess.sql
1 1 
SELECT util.search_path_append('util');
2 2 

  		




  3
  3
  
    
SELECT set_col_types(:table_str, ARRAY[


  		




  4
  
  
    
  ('latitude', 'double precision')


  		




  5
  
  
    
, ('longitude', 'double precision')


  		




  6
  
  
    
, ('error_km', 'double precision')


  		




  
  4
  
    
  ('decimalLatitude', 'double precision')


  		




  
  5
  
    
, ('decimalLongitude', 'double precision')


  		




  
  6
  
    
, ('*error_km', 'double precision')


  		




  7
  7
  
    
]::col_cast[]);


  		












  

    
      inputs/.geoscrub/county_centroids/run
    
  





  
  1
  
    
#!/bin/bash -e


  		




  
  2
  
    
. "$(dirname "${BASH_SOURCE[0]}")"/../table.run


  		




  0
  3
  
    

  		












  

    
      inputs/.geoscrub/county_centroids/map.csv
    
  





  
  1
  
    
geoscrub,VegCore,Filter,Comments


  		




  
  2
  
    
row_num,*row_num,,


  		




  
  3
  
    
state,stateProvince,,


  		




  
  4
  
    
county,county,,


  		




  
  5
  
    
latitude,decimalLatitude,,


  		




  
  6
  
    
longitude,decimalLongitude,,


  		




  
  7
  
    
error_km,*error_km,,


  		












  

    
      inputs/.geoscrub/county_centroids/unmapped_terms.csv
    
  





  
  1
  
    
*row_num


  		




  
  2
  
    
*error_km


  		












Also available in:  Unified diff