Revision 10383
Added by Aaron Marcuse-Kubitza over 11 years ago
| 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
inputs/BRIT/specimen_flat/postprocess.sql: diameterBreastHeight_cm, height_m: updated runtimes