Project

General

Profile

« Previous | Next » 

Revision 10993

Added by Aaron Marcuse-Kubitza about 11 years ago

inputs/VegBank/taxonobservation_/postprocess.sql: added primary key. note that the inserted row count changes, most likely because the rows are now in sorted order.

View differences:

inputs/VegBank/taxonobservation_/postprocess.sql
4 4 
SELECT mk_derived_col((:table_str, 'scientificName'),
5 5 
$$_alt("scientificName_verbatim", "scientificName__for_nearest_taxon_concept")$$)
6 6 
; -- runtime: 15 s ("Time: 12334.893 ms") @starscream
7 

  		




  
  8
  
    
SELECT mk_derived_col((:table_str, 'identificationID'),


  		




  
  9
  
    
$$_join("taxonOccurrenceID"::text, "identificationID__taxon_determination"::text)$$)


  		




  
  10
  
    
; -- runtime: 20 s ("Time: 21724.277 ms") @starscream


  		




  
  11
  
    

  		




  
  12
  
    

  		




  
  13
  
    
SELECT create_if_not_exists($$ALTER TABLE $$||:table_str||$$ ADD PRIMARY KEY ("identificationID")$$); -- runtime: 20 s ("Time: 19328.716 ms") @starscream


  		












  

    
      inputs/VegBank/taxonobservation_/map.csv
    
  





  18
  18
  
    
int_currplantcommon,vernacularName,,


  		




  19
  19
  
    
int_currplantcode,*taxonobservation_--int_currplantcode,,


  		




  20
  20
  
    
taxonobservation_accessioncode,*taxonobservation_--taxonobservation_accessioncode,,


  		




  21
  
  
    
taxoninterpretation_id,*taxonobservation_--taxoninterpretation_id,,


  		




  
  21
  
    
taxoninterpretation_id,identificationID__taxon_determination,,


  		




  22
  22
  
    
stemlocation_id,*taxonobservation_--stemlocation_id,,


  		




  23
  23
  
    
taxoninterpretation_plantname_id,*taxonobservation_--taxoninterpretation_plantname_id,,


  		




  24
  24
  
    
taxoninterpretation_party_id,*taxonobservation_--taxoninterpretation_party_id,,


  		












  

    
      inputs/VegBank/taxonobservation_/test.xml.ref
    
  





  148
  148
  
    
        </path>


  		




  149
  149
  
    
    </_setDefault>


  		




  150
  150
  
    
</VegBIEN>


  		




  151
  
  
    
Inserted 16 new rows into database


  		




  
  151
  
    
Inserted 21 new rows into database


  		












  

    
      inputs/VegBank/taxonobservation_/new_terms.csv
    
  





  14
  14
  
    
int_currplantcommon,vernacularName,,


  		




  15
  15
  
    
int_currplantcode,*taxonobservation_--int_currplantcode,,


  		




  16
  16
  
    
taxonobservation_accessioncode,*taxonobservation_--taxonobservation_accessioncode,,


  		




  17
  
  
    
taxoninterpretation_id,*taxonobservation_--taxoninterpretation_id,,


  		




  
  17
  
    
taxoninterpretation_id,identificationID__taxon_determination,,


  		




  18
  18
  
    
stemlocation_id,*taxonobservation_--stemlocation_id,,


  		




  19
  19
  
    
taxoninterpretation_plantname_id,*taxonobservation_--taxoninterpretation_plantname_id,,


  		




  20
  20
  
    
taxoninterpretation_party_id,*taxonobservation_--taxoninterpretation_party_id,,


  		












  

    
      inputs/VegBank/taxonobservation_/unmapped_terms.csv
    
  





  11
  11
  
    
vernacularName


  		




  12
  12
  
    
*taxonobservation_--int_currplantcode


  		




  13
  13
  
    
*taxonobservation_--taxonobservation_accessioncode


  		




  14
  
  
    
*taxonobservation_--taxoninterpretation_id


  		




  
  14
  
    
identificationID__taxon_determination


  		




  15
  15
  
    
*taxonobservation_--stemlocation_id


  		




  16
  16
  
    
*taxonobservation_--taxoninterpretation_plantname_id


  		




  17
  17
  
    
*taxonobservation_--taxoninterpretation_party_id


  		












Also available in:  Unified diff