Project

General

Profile

« Previous | Next » 

Revision 10620

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/TEX/Specimen/: translated multi-column filters to postprocessing derived columns, using the steps at http://wiki.vegpath.org/Adding_new-style_import_to_a_datasource#Translating-filters-to-postprocessing-derived-columns

View differences:

inputs/TEX/Specimen/postprocess.sql
1 
SELECT util.search_path_append('util');
2 

  		




  
  3
  
    

  		




  
  4
  
    
SELECT mk_derived_col((:table_str, 'dateCollected'),


  		




  
  5
  
    
$$_alt("COLL. DATE (EXACT)", "COLL. DATE (GENERAL)")$$)


  		




  
  6
  
    
; -- runtime: 2 s ("Time: 1734.640 ms") @starscream


  		












  

    
      inputs/TEX/Specimen/map.csv
    
  





  4
  4
  
    
ACCESSION NO.,accessionNumber,,


  		




  5
  5
  
    
COLLECTOR NAME(S),recordedBy,,


  		




  6
  6
  
    
COLLECTOR NUMBER,collectorNumber,,


  		




  7
  
  
    
COLL. DATE (EXACT),dateCollected,/_alt/1,


  		




  8
  
  
    
COLL. DATE (GENERAL),dateCollected,/_alt/2,


  		




  
  7
  
    
COLL. DATE (EXACT),dateCollected__scrubbed,,


  		




  
  8
  
    
COLL. DATE (GENERAL),dateCollected__verbatim,,


  		




  9
  9
  
    
ORIGIN,establishmentMeans,,


  		




  10
  10
  
    
PHENOLOGY,reproductiveCondition,,


  		




  11
  11
  
    
FAMILY,family,,


  		




  ......




  36
  36
  
    
DATA ENTRY BY,*DATA ENTRY BY,,


  		




  37
  37
  
    
DATA ENTRY DATE,*DATA ENTRY DATE,,


  		




  38
  38
  
    
DATA EDITED DATE,modified,,


  		




  
  39
  
    
dateCollected,dateCollected,,


  		












  

    
      inputs/TEX/Specimen/VegBIEN.csv
    
  





  8
  8
  
    
COLLECTOR NUMBER,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",


  		




  9
  9
  
    
LOCATION,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1,


  		




  10
  10
  
    
ECOLOGICAL INFORMATION,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/3,


  		




  11
  
  
    
COLL. DATE (EXACT),/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_alt/1,


  		




  12
  
  
    
COLL. DATE (GENERAL),/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_alt/2,


  		




  
  11
  
    
dateCollected,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1,


  		




  13
  12
  
    
SPECIMEN NOTES,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/1,


  		




  14
  13
  
    
COLLECTOR NUMBER,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2,


  		




  15
  14
  
    
PHENOLOGY,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/reproductivecondition,


  		




  ......




  58
  57
  
    
STATE,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2,


  		




  59
  58
  
    
STATE,/location/locationplace/*_id/place/stateprovince,


  		




  60
  59
  
    
ELEVATION,/location/verbatimelevation,


  		




  
  60
  
    
COLL. DATE (EXACT),,** No join mapping for dateCollected__scrubbed ** 


  		




  
  61
  
    
COLL. DATE (GENERAL),,** No join mapping for dateCollected__verbatim ** 


  		




  61
  62
  
    
DATA EDITED DATE,,** No join mapping for modified ** 


  		




  62
  63
  
    
DATA ENTRY BY,,** No join mapping for *DATA ENTRY BY ** 


  		




  63
  64
  
    
DATA ENTRY DATE,,** No join mapping for *DATA ENTRY DATE ** 


  		












  

    
      inputs/TEX/Specimen/test.xml.ref
    
  





  33
  33
  
    
                        <locationevent>


  		




  34
  34
  
    
                            <taxonoccurrence>


  		




  35
  35
  
    
                                <aggregateoccurrence>


  		




  36
  
  
    
                                    <collectiondate>


  		




  37
  
  
    
                                        <_alt>


  		




  38
  
  
    
                                            <1>$COLL. DATE (EXACT)</1>


  		




  39
  
  
    
                                            <2>$COLL. DATE (GENERAL)</2>


  		




  40
  
  
    
                                        </_alt>


  		




  41
  
  
    
                                    </collectiondate>


  		




  
  36
  
    
                                    <collectiondate>$dateCollected</collectiondate>


  		




  42
  37
  
    
                                    <notes>$SPECIMEN NOTES</notes>


  		




  43
  38
  
    
                                    <plantobservation>


  		




  44
  39
  
    
                                        <authorplantcode>$COLLECTOR NUMBER</authorplantcode>


  		












  

    
      inputs/TEX/Specimen/new_terms.csv
    
  





  1
  1
  
    
HERBARIUM,collection,,


  		




  2
  2
  
    
ACCESSION NO.,accessionNumber,,


  		




  3
  3
  
    
COLLECTOR NAME(S),recordedBy,,


  		




  4
  
  
    
COLL. DATE (EXACT),dateCollected,/_alt/1,


  		




  5
  
  
    
COLL. DATE (GENERAL),dateCollected,/_alt/2,


  		




  
  4
  
    
COLL. DATE (EXACT),dateCollected__scrubbed,,


  		




  
  5
  
    
COLL. DATE (GENERAL),dateCollected__verbatim,,


  		




  6
  6
  
    
ORIGIN,establishmentMeans,,


  		




  7
  7
  
    
AUTHORITY,scientificNameAuthorship,,


  		




  8
  8
  
    
INFRA RANK,infraspecificRank,,


  		












  

    
      inputs/TEX/Specimen/unmapped_terms.csv
    
  





  1
  1
  
    
*row_num


  		




  
  2
  
    
dateCollected__scrubbed


  		




  
  3
  
    
dateCollected__verbatim


  		




  2
  4
  
    
infraspecificRank


  		




  3
  5
  
    
*INFRA AUTHORITY


  		




  4
  6
  
    
*LAT NS


  		












Also available in:  Unified diff