Project

General

Profile

« Previous | Next » 

Revision 10419

Added by Aaron Marcuse-Kubitza almost 11 years ago

inputs/CTFS/: switched to new-style import, using the steps at wiki.vegpath.org/Adding_new-style_import_to_a_datasource

View differences:

postprocess.sql
2 2 

  		




  3
  3
  
    
-- runtime: 0.3 s ("Time: 256.926 ms") @starscream


  		




  4
  4
  
    
SELECT set_col_types(:table_str, ARRAY[


  		




  5
  
  
    
  ('minDBHcm', 'double precision')


  		




  6
  
  
    
, ('maxDBHcm', 'double precision')


  		




  
  5
  
    
  ('diameterBreastHeight_min_cm', 'double precision')


  		




  
  6
  
    
, ('diameterBreastHeight_max_cm', 'double precision')


  		




  7
  7
  
    
]::col_cast[]);


  		




  8
  8
  
    

  		




  9
  9
  
    

  		




  10
  
  
    
SELECT mk_derived_col((:table_str, 'diameterBreastHeight_cm'), $$_avg("minDBHcm", "maxDBHcm")$$); -- runtime: 0.4 s ("Time: 431.405 ms") @starscream


  		




  
  10
  
    
SELECT mk_derived_col((:table_str, 'diameterBreastHeight_cm'), $$_avg("diameterBreastHeight_min_cm", "diameterBreastHeight_max_cm")$$); -- runtime: 0.4 s ("Time: 431.405 ms") @starscream


  		












Also available in:  Unified diff