Project

General

Profile

« Previous | Next » 

Revision 7865

Added by Aaron Marcuse-Kubitza almost 12 years ago

inputs/UNCC/Specimen/map.csv: Mapped flower, fruit -> reproductiveCondition using translation is from e-mail conv between Jim Matthews at Habitat Assessment and Bob Peet on 2010-12-2~3

View differences:

inputs/UNCC/Specimen/map.csv
30 30 
county,county,,
31 31 
campus,cultivated,/_alt/2/_map:[*=true]/value,"""this refers to occurrence on the UNCC campus, but I do not know the meaning of the codes. Presumably C = cultivated"" (https://projects.nceas.ucsb.edu/nceas/attachments/download/723/UNCC-validate_rkp_bb_rkp.xlsx#Campus)"
32 32 
leaves,*leaves,,
33 
flower,*flower,,
34 
fruit,*fruit,,
33 
flower,reproductiveCondition,"/_join/1/_map:[A=absent,I=immature,M=mature]/value",Translation is from e-mail conv between Jim Matthews at Habitat Assessment <jim@habitatassessment.com> and Bob Peet on 2010-12-2~3
34 
fruit,reproductiveCondition,"/_join/2/_map:[A=absent,I=immature,M=mature]/value",Translation is from e-mail conv between Jim Matthews at Habitat Assessment <jim@habitatassessment.com> and Bob Peet on 2010-12-2~3
35 35 
root,*root,,
36 36 
locality,locality,,
37 37 
habitat,habitat,,
inputs/UNCC/Specimen/VegBIEN.csv
50 50 
loanto,"/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/1/_join/6/_label[label=""loaned to""]/value",
51 51 
inorout,"/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/1/_join/7/_label[label=""in or out""]/value",
52 52 
collectno,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2,
53 
flower,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/reproductivecondition/_join/1/_map:[A=absent,I=immature,M=mature]/value",Translation is from e-mail conv between Jim Matthews at Habitat Assessment <jim@habitatassessment.com> and Bob Peet on 2010-12-2~3
54 
fruit,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/reproductivecondition/_join/2/_map:[A=absent,I=immature,M=mature]/value",Translation is from e-mail conv between Jim Matthews at Habitat Assessment <jim@habitatassessment.com> and Bob Peet on 2010-12-2~3
53 55 
accession,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else","Globally unique, although occasionally duplicated. [1]
54 56 

  		




  55
  57
  
    
[1] Using the following query:


  		




  ......




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


  		




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


  		




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


  		




  126
  
  
    
flower,,** No join mapping for *flower ** 


  		




  127
  
  
    
fruit,,** No join mapping for *fruit ** 


  		




  128
  128
  
    
herbarium,,"** No join mapping for specimenDonor/_map:[UNCCD=UNCC,*=*]/value ** ""The name or acronym in use by the institution that donated the collection"" (https://projects.nceas.ucsb.edu/nceas/attachments/download/593/UNCC-validation-Peet.xlsx#institutionCode). UNCCD likely = UNCC database."


  		




  129
  129
  
    
leaves,,** No join mapping for *leaves ** 


  		




  130
  130
  
    
root,,** No join mapping for *root ** 


  		












  

    
      inputs/UNCC/Specimen/test.xml.ref
    
  





  68
  68
  
    
                                    </notes>


  		




  69
  69
  
    
                                    <plantobservation>


  		




  70
  70
  
    
                                        <authorplantcode>$collectno</authorplantcode>


  		




  
  71
  
    
                                        <reproductivecondition>


  		




  
  72
  
    
                                            <_join>


  		




  
  73
  
    
                                                <1>


  		




  
  74
  
    
                                                    <_map>


  		




  
  75
  
    
                                                        <A>absent</A>


  		




  
  76
  
    
                                                        <I>immature</I>


  		




  
  77
  
    
                                                        <M>mature</M>


  		




  
  78
  
    
                                                        <value>$flower</value>


  		




  
  79
  
    
                                                    </_map>


  		




  
  80
  
    
                                                </1>


  		




  
  81
  
    
                                                <2>


  		




  
  82
  
    
                                                    <_map>


  		




  
  83
  
    
                                                        <A>absent</A>


  		




  
  84
  
    
                                                        <I>immature</I>


  		




  
  85
  
    
                                                        <M>mature</M>


  		




  
  86
  
    
                                                        <value>$fruit</value>


  		




  
  87
  
    
                                                    </_map>


  		




  
  88
  
    
                                                </2>


  		




  
  89
  
    
                                            </_join>


  		




  
  90
  
    
                                        </reproductivecondition>


  		




  71
  91
  
    
                                        <specimenreplicate>


  		




  72
  92
  
    
                                            <catalognumber_dwc>$accession</catalognumber_dwc>


  		




  73
  93
  
    
                                            <collectionnumber>$collectno</collectionnumber>


  		












  

    
      inputs/UNCC/Specimen/new_terms.csv
    
  





  11
  11
  
    
collday,dayCollected,,


  		




  12
  12
  
    
collyear,yearCollected,,


  		




  13
  13
  
    
campus,cultivated,/_alt/2/_map:[*=true]/value,"""this refers to occurrence on the UNCC campus, but I do not know the meaning of the codes. Presumably C = cultivated"" (https://projects.nceas.ucsb.edu/nceas/attachments/download/723/UNCC-validate_rkp_bb_rkp.xlsx#Campus)"


  		




  
  14
  
    
flower,reproductiveCondition,"/_join/1/_map:[A=absent,I=immature,M=mature]/value",Translation is from e-mail conv between Jim Matthews at Habitat Assessment <jim@habitatassessment.com> and Bob Peet on 2010-12-2~3


  		




  
  15
  
    
fruit,reproductiveCondition,"/_join/2/_map:[A=absent,I=immature,M=mature]/value",Translation is from e-mail conv between Jim Matthews at Habitat Assessment <jim@habitatassessment.com> and Bob Peet on 2010-12-2~3


  		




  14
  16
  
    
comment1,occurrenceRemarks,/_join/1,


  		




  15
  17
  
    
comment2,occurrenceRemarks,/_join/2,


  		




  16
  18
  
    
comment3,occurrenceRemarks,/_join/3,


  		












  

    
      inputs/UNCC/Specimen/unmapped_terms.csv
    
  





  1
  1
  
    
specimenDonor


  		




  2
  2
  
    
*leaves


  		




  3
  
  
    
*flower


  		




  4
  
  
    
*fruit


  		




  5
  3
  
    
*root


  		




  6
  4
  
    
associatedMedia


  		




  7
  5
  
    
*filler


  		












Also available in:  Unified diff