Project

General

Profile

« Previous | Next » 

Revision 11438

Added by Aaron Marcuse-Kubitza almost 11 years ago

fix: inputs/VegBank/taxonobservation_/map.csv: remapped int_* to OMIT because these are not specific to the taxoninterpretation row (this is in a separate taxoninterpretation for the original determination instead). see wiki.vegpath.org/Spot-checking#2013-10-10 > Mike Lee's conference call feedback.

View differences:

postprocess.sql
2 2 

  		




  3
  3
  
    
SELECT create_if_not_exists($$CREATE INDEX $$||:table_str||%'__parent'||$$ ON $$||:table_str||$$ ("eventID")$$); -- runtime: 2 s ("2416.676 ms") @starscream


  		




  4
  4
  
    

  		




  5
  
  
    

  		




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


  		




  7
  
  
    
$$_alt("scientificName_verbatim", "scientificName__for_nearest_taxon_concept")$$)


  		




  8
  
  
    
; -- runtime: 15 s ("Time: 12334.893 ms") @starscream


  		




  9
  
  
    

  		




  10
  
  
    

  		




  11
  5
  
    
SELECT create_if_not_exists($$ALTER TABLE $$||:table_str||$$ ADD PRIMARY KEY ("identificationID")$$); -- runtime: 1 s ("Time: 1342.115 ms") @starscream


  		












Also available in:  Unified diff