Project

General

Profile

« Previous | Next » 

Revision 13964

Added by Aaron Marcuse-Kubitza over 10 years ago

fix: inputs/Madidi/LocationObservation/postprocess.sql: parse Spanish dates

View differences:

postprocess.sql
1 1 
SELECT util.search_path_append('util');
2 2 

  		




  3
  
  
    
SELECT mk_derived_col((:table_str, 'eventDate'),


  		




  
  3
  
    
SELECT mk_derived_col((:table_str, 'verbatimEventDate'),


  		




  4
  4
  
    
$$"authorEventCode"$$);


  		




  5
  5
  
    

  		




  
  6
  
    
SELECT mk_derived_col((:table_str, 'eventDate'),


  		




  
  7
  
    
$$util.date_from_spanish("verbatimEventDate")$$);


  		




  
  8
  
    

  		




  6
  9
  
    
SELECT mk_derived_col((:table_str, 'locationRemarks'),


  		




  7
  10
  
    
$$_alt("locationRemarks_1", "locationRemarks_2")$$);


  		




  8
  11
  
    
	-- _alt() is fine because only one of these is ever populated


  		












Also available in:  Unified diff