Project

General

Profile

« Previous | Next » 

Revision 11804

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

View differences:

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