Project

General

Profile

« Previous | Next » 

Revision 10999

Added by Aaron Marcuse-Kubitza about 11 years ago

inputs/VegBank/: added taxon_observation.** left-join of the tables, using the steps at http://wiki.vegpath.org/Left-joining_a_datasource

View differences:

inputs/VegBank/import_order.txt
4 4 
taxonobservation_
5 5 
stemcount_
6 6 
stemlocation_
7 
taxon_observation.**
inputs/VegBank/taxon_observation.**/postprocess.sql
1 
SELECT util.search_path_append('util');
2 

  		




  
  3
  
    
SELECT force_update_view(:table_str, $$


  		




  
  4
  
    
SELECT "identificationID" AS row_num, *


  		




  
  5
  
    
FROM              taxonobservation_


  		




  
  6
  
    
NATURAL LEFT JOIN stemcount_


  		




  
  7
  
    
NATURAL LEFT JOIN stemlocation_


  		




  
  8
  
    
NATURAL LEFT JOIN observation_


  		




  
  9
  
    
NATURAL LEFT JOIN plot_


  		




  
  10
  
    
$$);


  		




  
  11
  
    

  		




  
  12
  
    
SELECT mk_subset_by_row_num_func(:table_str, 'row_num');


  		












  

    
      inputs/VegBank/taxon_observation.**/run
    
  





  
  1
  
    
#!/bin/bash -e


  		




  
  2
  
    
. "$(dirname "${BASH_SOURCE[0]}")"/../../../lib/runscripts/view.run


  		




  0
  3
  
    

  		












Also available in:  Unified diff