Project

General

Profile

« Previous | Next » 

Revision 10346

Added by Aaron Marcuse-Kubitza over 11 years ago

bugfix: inputs/Madidi/LocationObservation/map.csv: resolved Notes, Notes 2 -> locationRemarks collision by _alt()ing them together. note that _alt() is fine because only one of these is ever populated.

View differences:

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

  		




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


  		




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


  		




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


  		












  

    
      inputs/Madidi/LocationObservation/map.csv
    
  





  34
  34
  
    
Funding agency,*Funding agency,,


  		




  35
  35
  
    
Collaborators,*Collaborators,,


  		




  36
  36
  
    
Installed and evaluated by,*Installed and evaluated by,,


  		




  37
  
  
    
Notes,locationRemarks,,


  		




  
  37
  
    
Notes,locationRemarks_1,,


  		




  38
  38
  
    
Interchangeable Magnesium,magnesium_percent,,Assuming units are % based on the range of values


  		




  39
  39
  
    
Interchangeable Acidity,acidity_percent,,Assuming units are % based on the range of values


  		




  40
  40
  
    
CIC,cationExchangeCapacity_cmol_kg,,


  		




  ......




  42
  42
  
    
Silt,silt_percent,,Assuming units are % based on the range of values


  		




  43
  43
  
    
Clay,clay_percent,,Assuming units are % based on the range of values


  		




  44
  44
  
    
Textural Class,texture,,


  		




  45
  
  
    
Notes 2,locationRemarks,,


  		




  
  45
  
    
Notes 2,locationRemarks_2,,


  		




  46
  46
  
    
Textural Class (select),*Textural Class (select),,


  		




  47
  47
  
    
Qualifier Available Phosphor,*Qualifier Available Phosphor,,


  		




  48
  48
  
    
Qualifier Interchangeable Calcium,*Qualifier Interchangeable Calcium,,


  		












  

    
      inputs/Madidi/LocationObservation/new_terms.csv
    
  





  18
  18
  
    
Interchangeable Acidity,acidity_percent,,Assuming units are % based on the range of values


  		




  19
  19
  
    
CIC,cationExchangeCapacity_cmol_kg,,


  		




  20
  20
  
    
Textural Class,texture,,


  		




  21
  
  
    
Notes 2,locationRemarks,,


  		




  
  21
  
    
Notes 2,locationRemarks_2,,


  		












  

    
      inputs/Madidi/LocationObservation/unmapped_terms.csv
    
  





  13
  13
  
    
*Funding agency


  		




  14
  14
  
    
*Collaborators


  		




  15
  15
  
    
*Installed and evaluated by


  		




  
  16
  
    
locationRemarks_1


  		




  
  17
  
    
locationRemarks_2


  		




  16
  18
  
    
*Textural Class (select)


  		




  17
  19
  
    
*Qualifier Available Phosphor


  		




  18
  20
  
    
*Qualifier Interchangeable Calcium


  		












Also available in:  Unified diff