Revision 10939
Added by Aaron Marcuse-Kubitza over 10 years ago
| inputs/VegBank/plot_/postprocess.sql | ||
|---|---|---|
| 52 | 52 |
|
| 53 | 53 |
|
| 54 | 54 |
SELECT mk_derived_col((:table_str, 'coordinateUncertaintyInMeters'), |
| 55 |
$$_alt("coordinateUncertaintyInMeters__from_fuzzing", "locationaccuracy")$$)
|
|
| 56 |
; -- runtime: 1 s ("Time: 734.562 ms") @starscream
|
|
| 55 |
$$GREATEST("coordinateUncertaintyInMeters__from_fuzzing", "locationaccuracy")$$)
|
|
| 56 |
; -- runtime: 1 s ("Time: 712.548 ms") @starscream
|
|
Also available in: Unified diff
bugfix: inputs/VegBank/plot_/postprocess.sql: coordinateUncertaintyInMeters: need to use GREATEST instead of _alt() to handle cases where the coordinate uncertainty is > than the fuzzing uncertainty, where you wouldn't want to just use the smaller fuzzing uncertainty