Revision 11804
Added by Aaron Marcuse-Kubitza about 11 years ago
postprocess.sql | ||
---|---|---|
56 | 56 |
SELECT mk_derived_col((:table_str, 'coordinateUncertaintyInMeters'), |
57 | 57 |
$$GREATEST("coordinateUncertaintyInMeters__from_fuzzing", "coordinateUncertaintyInMeters__from_coords")$$) |
58 | 58 |
; -- runtime: 0.2 s ("172.425 ms") @starscream |
59 |
|
|
60 |
SELECT mk_derived_col((:table_str, 'locality'), |
|
61 |
$$_join("directions_to_place", "site_name")$$) |
|
62 |
; -- runtime: 4 s ("Time: 3651.355 ms") @starscream |
Also available in: Unified diff
fix: inputs/CVS/plot_/postprocess.sql: locality: include the site name (authorLocation), because this is part of the unique specification of the place that was sampled, and Bob wants this to be included in VegBIEN