Project

General

Profile

« Previous | Next » 

Revision 11488

Added by Aaron Marcuse-Kubitza about 11 years ago

bugfix: inputs/VegBank/plot_/postprocess.sql: coordinateUncertaintyInMeters__from_fuzzing: need to convert km to m in the fuzzing radii. updated derived cols runtimes.

View differences:

postprocess.sql
35 35 
  LANGUAGE sql IMMUTABLE
36 36 
  COST 100;
37 37 

  		




  38
  
  
    
SELECT mk_derived_col((:table_str, 'accessRights'), $$map_access_rights("accessRights_verbatim")$$); -- runtime: 1 s ("Time: 1270.464 ms") @starscream


  		




  
  38
  
    
SELECT mk_derived_col((:table_str, 'accessRights'), $$map_access_rights("accessRights_verbatim")$$); -- runtime: 1 s ("Time: 1167.547 ms") @starscream


  		




  39
  39
  
    

  		




  40
  40
  
    
CREATE OR REPLACE FUNCTION map_fuzzing(value integer)


  		




  41
  41
  
    
  RETURNS double precision AS


  		




  ......




  52
  52
  
    
6      Full embargo on data               7


  		




  53
  53
  
    
" (http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1581&entity=dba_fielddescription)


  		




  54
  54
  
    
*/


  		




  55
  
  
    
SELECT util._map('0=>NULL, 1=>1, 2=>10, 3=>100, 4=>NULL, 5=>NULL, 6=>NULL', $1::text)::double precision


  		




  
  55
  
    
SELECT public._km_to_m(util._map('0=>NULL, 1=>1, 2=>10, 3=>100, 4=>NULL, 5=>NULL, 6=>NULL', $1::text)::double precision)


  		




  56
  56
  
    
$BODY$


  		




  57
  57
  
    
  LANGUAGE sql IMMUTABLE


  		




  58
  58
  
    
  COST 100;


  		




  59
  59
  
    

  		




  60
  
  
    
SELECT mk_derived_col((:table_str, 'coordinateUncertaintyInMeters__from_fuzzing'), $$map_fuzzing("accessRights_verbatim")$$); -- runtime: 1 s ("Time: 1134.143 ms") @starscream


  		




  
  60
  
    
SELECT mk_derived_col((:table_str, 'coordinateUncertaintyInMeters__from_fuzzing'), $$map_fuzzing("accessRights_verbatim")$$); -- runtime: 1 s ("Time: 1064.189 ms") @starscream


  		




  61
  61
  
    

  		




  62
  62
  
    

  		




  63
  63
  
    
SELECT mk_derived_col((:table_str, 'coordinateUncertaintyInMeters'),


  		




  64
  64
  
    
$$GREATEST("coordinateUncertaintyInMeters__from_fuzzing", "coordinateUncertaintyInMeters__from_coords")$$)


  		




  65
  
  
    
; -- runtime: 1 s ("Time: 712.548 ms") @starscream


  		




  
  65
  
    
; -- runtime: 0.5 s ("Time: 586.453 ms") @starscream


  		












Also available in:  Unified diff