Project

General

Profile

« Previous | Next » 

Revision 13939

Added by Aaron Marcuse-Kubitza over 10 years ago

fix: inputs/Madidi/LocationObservation/postprocess.sql: populated missing eventDate from PlotInventoryName (authorEventCode)

View differences:

trunk/inputs/Madidi/LocationObservation/postprocess.sql
1 1 
SELECT util.search_path_append('util');
2 2 

  		




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


  		




  
  4
  
    
$$"authorEventCode"$$);


  		




  
  5
  
    

  		




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


  		




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


  		




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


  		












  

    
      trunk/inputs/Madidi/LocationObservation/test.xml.ref
    
  





  19
  19
  
    
                            </project_id>


  		




  20
  20
  
    
                            <authoreventcode>$authorEventCode</authoreventcode>


  		




  21
  21
  
    
                            <commclass><commdetermination><commconcept_id><commconcept><commdescription>$communityName</commdescription></commconcept></commconcept_id></commdetermination></commclass>


  		




  
  22
  
    
                            <obsenddate><_dateRangeEnd><value>$eventDate</value></_dateRangeEnd></obsenddate>


  		




  
  23
  
    
                            <obsstartdate><_dateRangeStart><value>$eventDate</value></_dateRangeStart></obsstartdate>


  		




  22
  24
  
    
                            <soilsample>


  		




  23
  25
  
    
                                <acidity_fraction><_percent_to_fraction><value>$acidity_percent</value></_percent_to_fraction></acidity_fraction>


  		




  24
  26
  
    
                                <calcium_fraction><_percent_to_fraction><value>$calcium_percent</value></_percent_to_fraction></calcium_fraction>


  		












Also available in:  Unified diff