Project

General

Profile

« Previous | Next » 

Revision 11924

Added by Aaron Marcuse-Kubitza about 11 years ago

fix: inputs/TEX/Specimen*/map.csv, postprocess.sql: habitat: also placed in occurrenceRemarks so that this field gets parsed for growth form information, as requested by Brad (wiki.vegpath.org/TEX_validation#2013-2-26)

View differences:

inputs/TEX/Specimen/postprocess.sql
4 4 
SELECT mk_derived_col((:table_str, 'dateCollected'),
5 5 
$$_alt("dateCollected__scrubbed", "dateCollected__verbatim")$$)
6 6 
; -- runtime: 2 s ("Time: 1734.640 ms") @starscream
7 

  		




  
  8
  
    

  		




  
  9
  
    
SELECT mk_derived_col((:table_str, 'occurrenceRemarks'),


  		




  
  10
  
    
$$_join("specimenDescription", "habitat")$$)


  		




  
  11
  
    
; -- runtime: 1 s ("1113.080 ms") @starscream


  		












  

    
      inputs/TEX/Specimen/map.csv
    
  





  31
  31
  
    
ELEVATION,verbatimElevation,,


  		




  32
  32
  
    
ECOLOGICAL INFORMATION,habitat,,


  		




  33
  33
  
    
UTM,*UTM,,


  		




  34
  
  
    
SPECIMEN NOTES,occurrenceRemarks,,


  		




  
  34
  
    
SPECIMEN NOTES,specimenDescription,,


  		




  35
  35
  
    
DET NOTES,identificationRemarks,,


  		




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


  		




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


  		












  

    
      inputs/TEX/Specimen/new_terms.csv
    
  





  16
  16
  
    
LONG SECONDS,longitude_sec,,


  		




  17
  17
  
    
LOCATION,locality,,


  		




  18
  18
  
    
ECOLOGICAL INFORMATION,habitat,,


  		




  19
  
  
    
SPECIMEN NOTES,occurrenceRemarks,,


  		




  
  19
  
    
SPECIMEN NOTES,specimenDescription,,


  		




  20
  20
  
    
DET NOTES,identificationRemarks,,


  		




  21
  21
  
    
DATA EDITED DATE,modified,,


  		












  

    
      inputs/TEX/Specimen/unmapped_terms.csv
    
  





  7
  7
  
    
*LONG EW


  		




  8
  8
  
    
*SOURCE OF LATLONG


  		




  9
  9
  
    
*UTM


  		




  
  10
  
    
specimenDescription


  		




  10
  11
  
    
identificationRemarks


  		




  11
  12
  
    
*DATA ENTRY BY


  		




  12
  13
  
    
*DATA ENTRY DATE


  		












  

    
      inputs/TEX/Specimen2/postprocess.sql
    
  





  34
  34
  
    
SELECT mk_derived_col((:table_str, 'identifiedBy'),


  		




  35
  35
  
    
$$_join_words("identifiedBy__first", "identifiedBy__last")$$)


  		




  36
  36
  
    
; -- runtime: 0.3 s ("Time: 267.310 ms") @starscream


  		




  
  37
  
    

  		




  
  38
  
    

  		




  
  39
  
    
SELECT mk_derived_col((:table_str, 'occurrenceRemarks'),


  		




  
  40
  
    
$$_join("specimenDescription", "habitat")$$)


  		




  
  41
  
    
; -- runtime: 0.2 s ("158.403 ms") @starscream


  		












  

    
      inputs/TEX/Specimen2/map.csv
    
  





  14
  14
  
    
COUNTY,county,,


  		




  15
  15
  
    
LOCALITY,locality,,


  		




  16
  16
  
    
VEGETATION,habitat,,


  		




  17
  
  
    
PLANT DATA,occurrenceRemarks,, = specimenDescription


  		




  
  17
  
    
PLANT DATA,specimenDescription,,


  		




  18
  18
  
    
ELEVATION,verbatimElevation,,


  		




  19
  19
  
    
LATITUDE,latitude_DMS,,


  		




  20
  20
  
    
LONGITUDE,longitude_DMS,,


  		












  

    
      inputs/TEX/Specimen2/new_terms.csv
    
  





  1
  1
  
    
HERBARIUM,collection,,


  		




  2
  2
  
    
SPECIES AUTHORITY,scientificNameAuthorship,,


  		




  3
  3
  
    
VEGETATION,habitat,,


  		




  4
  
  
    
PLANT DATA,occurrenceRemarks,, = specimenDescription


  		




  
  4
  
    
PLANT DATA,specimenDescription,,


  		




  5
  5
  
    
EXACT DATE,dateCollected__scrubbed,,


  		




  6
  6
  
    
GENERAL DATE,dateCollected__verbatim,,


  		




  7
  7
  
    
COLLECTOR 1 FIRST NAME,recordedBy__primary__first,,


  		












  

    
      inputs/TEX/Specimen2/unmapped_terms.csv
    
  





  1
  1
  
    
*row_num


  		




  2
  2
  
    
*SUBSPECIES AUTHOR


  		




  3
  3
  
    
*VARIETY AUTHOR


  		




  
  4
  
    
specimenDescription


  		




  4
  5
  
    
dateCollected__scrubbed


  		




  5
  6
  
    
dateCollected__verbatim


  		




  6
  7
  
    
recordedBy__primary__first


  		












Also available in:  Unified diff