Project

General

Profile

« Previous | Next » 

Revision 7812

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/UNCC/Specimen/map.csv: Removed mappings to reproductiveCondition because we don't know what the single-letter codes mean

View differences:

inputs/UNCC/Specimen/map.csv
29 29 
state,stateProvince,,
30 30 
county,county,,
31 31 
campus,occurrenceRemarks,"/_join/5/_label[label=""campus""]/value",
32 
leaves,reproductiveCondition,"/_map:[A=*,I=*,M=*]/value","Main values are A, I, and M. What do they mean?"
33 
flower,reproductiveCondition,"/_map:[A=*,I=*,M=*]/value","Main values are A, I, and M. What do they mean?"
34 
fruit,reproductiveCondition,"/_map:[A=*,I=*,M=*]/value","Main values are A, I, and M. What do they mean?"
35 
root,reproductiveCondition,"/_map:[A=*,I=*,M=*]/value","Main values are A, I, and M. What do they mean?"
32 
leaves,*leaves,,
33 
flower,*flower,,
34 
fruit,*fruit,,
35 
root,*root,,
36 36 
locality,locality,,
37 37 
habitat,habitat,,
38 38 
comment1,occurrenceRemarks,/_join/1,
inputs/UNCC/Specimen/VegBIEN.csv
51 51 
loanto,"/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/1/_join/6/_label[label=""loaned to""]/value",
52 52 
inorout,"/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/1/_join/7/_label[label=""in or out""]/value",
53 53 
collectno,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2,
54 
flower,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/reproductivecondition/_map:[A=*,I=*,M=*]/value","Main values are A, I, and M. What do they mean?"
55 
fruit,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/reproductivecondition/_map:[A=*,I=*,M=*]/value","Main values are A, I, and M. What do they mean?"
56 
leaves,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/reproductivecondition/_map:[A=*,I=*,M=*]/value","Main values are A, I, and M. What do they mean?"
57 
root,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/reproductivecondition/_map:[A=*,I=*,M=*]/value","Main values are A, I, and M. What do they mean?"
58 54 
accession,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else","Globally unique, although occasionally duplicated. [1] Bob says this is actually the catalogNumber.
59 55 

  		




  60
  56
  
    
[1] Using the following query:


  		




  ......




  129
  125
  
    
state,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2,


  		




  130
  126
  
    
state,/location/locationplace/*_id/place/stateprovince,


  		




  131
  127
  
    
filler,,"** No join mapping for *filler ** Where used, same as family"


  		




  
  128
  
    
flower,,** No join mapping for *flower ** 


  		




  
  129
  
    
fruit,,** No join mapping for *fruit ** 


  		




  
  130
  
    
leaves,,** No join mapping for *leaves ** 


  		




  
  131
  
    
root,,** No join mapping for *root ** 


  		




  132
  132
  
    
sheetno,,** No join mapping for associatedMedia ** ?


  		












  

    
      inputs/UNCC/Specimen/test.xml.ref
    
  





  85
  85
  
    
                                    </notes>


  		




  86
  86
  
    
                                    <plantobservation>


  		




  87
  87
  
    
                                        <authorplantcode>$collectno</authorplantcode>


  		




  88
  
  
    
                                        <reproductivecondition>


  		




  89
  
  
    
                                            <_map>


  		




  90
  
  
    
                                                <A>*</A>


  		




  91
  
  
    
                                                <I>*</I>


  		




  92
  
  
    
                                                <M>*</M>


  		




  93
  
  
    
                                                <value>


  		




  94
  
  
    
                                                    <_alt>


  		




  95
  
  
    
                                                        <0>$flower</0>


  		




  96
  
  
    
                                                        <1>$fruit</1>


  		




  97
  
  
    
                                                        <2>$leaves</2>


  		




  98
  
  
    
                                                        <3>$root</3>


  		




  99
  
  
    
                                                    </_alt>


  		




  100
  
  
    
                                                </value>


  		




  101
  
  
    
                                            </_map>


  		




  102
  
  
    
                                        </reproductivecondition>


  		




  103
  88
  
    
                                        <specimenreplicate>


  		




  104
  89
  
    
                                            <catalognumber_dwc>$accession</catalognumber_dwc>


  		




  105
  90
  
    
                                            <collectionnumber>$collectno</collectionnumber>


  		












  

    
      inputs/UNCC/Specimen/new_terms.csv
    
  





  11
  11
  
    
collday,dayCollected,,


  		




  12
  12
  
    
collyear,yearCollected,,


  		




  13
  13
  
    
campus,occurrenceRemarks,"/_join/5/_label[label=""campus""]/value",


  		




  14
  
  
    
leaves,reproductiveCondition,"/_map:[A=*,I=*,M=*]/value","Main values are A, I, and M. What do they mean?"


  		




  15
  
  
    
flower,reproductiveCondition,"/_map:[A=*,I=*,M=*]/value","Main values are A, I, and M. What do they mean?"


  		




  16
  
  
    
fruit,reproductiveCondition,"/_map:[A=*,I=*,M=*]/value","Main values are A, I, and M. What do they mean?"


  		




  17
  
  
    
root,reproductiveCondition,"/_map:[A=*,I=*,M=*]/value","Main values are A, I, and M. What do they mean?"


  		




  18
  14
  
    
comment1,occurrenceRemarks,/_join/1,


  		




  19
  15
  
    
comment2,occurrenceRemarks,/_join/2,


  		




  20
  16
  
    
comment3,occurrenceRemarks,/_join/3,


  		












  

    
      inputs/UNCC/Specimen/unmapped_terms.csv
    
  





  
  1
  
    
*leaves


  		




  
  2
  
    
*flower


  		




  
  3
  
    
*fruit


  		




  
  4
  
    
*root


  		




  1
  5
  
    
associatedMedia


  		




  2
  6
  
    
*filler


  		












Also available in:  Unified diff