Project

General

Profile

« Previous | Next » 

Revision 10383

inputs/BRIT/specimen_flat/postprocess.sql: diameterBreastHeight_cm, height_m: updated runtimes

View differences:

inputs/BRIT/specimen_flat/postprocess.sql
24 24
$$CASE WHEN "Locality_Description" IS NOT NULL THEN "Notes_Plant" END$$)
25 25
; -- runtime: 0.3 s ("Time: 311.190 ms") @starscream
26 26

  
27
SELECT mk_derived_col((:table_str, 'diameterBreastHeight_cm'), $$_avg("DBH_Min"   , "DBH_Max"   )$$); -- runtime: 0.3 s ("Time: 392.412 ms") @starscream
28
SELECT mk_derived_col((:table_str, 'height_m'),                $$_avg("Height_Min", "Height_Max")$$); -- runtime: 0.3 s ("Time: 344.442 ms") @starscream
27
SELECT mk_derived_col((:table_str, 'diameterBreastHeight_cm'), $$_avg("DBH_Min"   , "DBH_Max"   )$$); -- runtime: 0.3 s ("Time: 326.615 ms") @starscream
28
SELECT mk_derived_col((:table_str, 'height_m'),                $$_avg("Height_Min", "Height_Max")$$); -- runtime: 0.3 s ("Time: 346.548 ms") @starscream

Also available in: Unified diff