Project

General

Profile

« Previous | Next » 

Revision 10385

Added by Aaron Marcuse-Kubitza almost 11 years ago

inputs/BRIT/specimen_flat/: translated multi-column filters with _join() to postprocessing derived columns, using the steps at wiki.vegpath.org/Adding_new-style_import_to_a_datasource#Translating-filters-to-postprocessing-derived-columns

View differences:

postprocess.sql
26 26 

  		




  27
  27
  
    
SELECT mk_derived_col((:table_str, 'diameterBreastHeight_cm'), $$_avg("DBH_Min"   , "DBH_Max"   )$$); -- runtime: 0.3 s ("Time: 326.615 ms") @starscream


  		




  28
  28
  
    
SELECT mk_derived_col((:table_str, 'height_m'),                $$_avg("Height_Min", "Height_Max")$$); -- runtime: 0.3 s ("Time: 346.548 ms") @starscream


  		




  
  29
  
    

  		




  
  30
  
    
SELECT mk_derived_col((:table_str, 'recordedBy'),


  		




  
  31
  
    
$$_join("Collector_Abbrev_Name", "Collection_Team")$$)


  		




  
  32
  
    
; -- runtime: 0.3 s ("Time: 281.817 ms") @starscream


  		




  
  33
  
    
SELECT mk_derived_col((:table_str, 'locality'),


  		




  
  34
  
    
$$_join("Locality_Summary", "Locality_Description", "Locality_Site_Specific")$$)


  		




  
  35
  
    
; -- runtime: 0.3 s ("Time: 254.771 ms") @starscream


  		












Also available in:  Unified diff