Revision 10387
Added by Aaron Marcuse-Kubitza over 11 years ago
| postprocess.sql | ||
|---|---|---|
| 24 | 24 |
$$CASE WHEN "locality__area__main" IS NOT NULL THEN "occurrenceRemarks_verbatim" END$$) |
| 25 | 25 |
; -- runtime: 0.3 s ("Time: 311.190 ms") @starscream
|
| 26 | 26 |
|
| 27 |
SELECT mk_derived_col((:table_str, 'diameterBreastHeight_cm'), $$_avg("diameterBreastHeight_min_cm_verbatim", "diameterBreastHeight_max_cm_verbatim")$$); -- runtime: 0.3 s ("Time: 326.615 ms") @starscream
|
|
| 28 |
SELECT mk_derived_col((:table_str, 'height_m'), $$_avg("height_min_m_verbatim" , "height_max_m_verbatim" )$$); -- runtime: 0.3 s ("Time: 346.548 ms") @starscream
|
|
| 27 |
SELECT mk_derived_col((:table_str, 'diameterBreastHeight_cm'), $$_avg("diameterBreastHeight_min_cm", "diameterBreastHeight_max_cm")$$); -- runtime: 0.3 s ("Time: 326.615 ms") @starscream
|
|
| 28 |
SELECT mk_derived_col((:table_str, 'height_m'), $$_avg("height_min_m" , "height_max_m" )$$); -- runtime: 0.3 s ("Time: 346.548 ms") @starscream
|
|
| 29 | 29 |
|
| 30 | 30 |
SELECT mk_derived_col((:table_str, 'recordedBy'), |
| 31 | 31 |
$$_join("recordedBy_primary", "recordedBy_additional")$$)
|
Also available in: Unified diff
bugfix: inputs/BRIT/specimen_flat/postprocess.sql: diameterBreastHeight_cm, height_m: use newly NULL-mapped versions of columns instead of the *_verbatim columns