Project

General

Profile

« Previous | Next » 

Revision 7699

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/UNCC/Specimen/map.csv: herbarium->specimenIndexer: Replace UNCCD (UNCC database?) with UNCC

View differences:

inputs/UNCC/Specimen/map.csv
8 8 
GROUP BY herbarium, accession
9 9 
HAVING count(*) > 1
10 10 
-----"
11 
herbarium,specimenIndexer,,"""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)"
11 
herbarium,specimenIndexer,"/_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."
12 12 
family,family,,
13 13 
genus,genus,,
14 14 
species,specificEpithet,,
inputs/UNCC/Specimen/VegBIEN.csv
26 26 
GROUP BY herbarium, accession
27 27 
HAVING count(*) > 1
28 28 
-----"
29 
herbarium,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/then/_first/1","""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)"
29 
herbarium,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/then/_first/1/_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."
30 30 
accession,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else","Globally unique, although occasionally duplicated. [1] Bob says this is actually the catalogNumber.
31 31 

  		




  32
  32
  
    
[1] Using the following query:


  		




  ......




  74
  74
  
    
GROUP BY herbarium, accession


  		




  75
  75
  
    
HAVING count(*) > 1


  		




  76
  76
  
    
-----"


  		




  77
  
  
    
herbarium,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name/_first/1","""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)"


  		




  78
  
  
    
herbarium,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_first/1","""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)"


  		




  
  77
  
    
herbarium,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name/_first/1/_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."


  		




  
  78
  
    
herbarium,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_first/1/_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."


  		




  79
  79
  
    
collectno,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",


  		




  80
  80
  
    
SciName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/3",


  		




  81
  81
  
    
collector,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_join/1,


  		












  

    
      inputs/UNCC/Specimen/test.xml.ref
    
  





  9
  9
  
    
                    <location>


  		




  10
  10
  
    
                        <authorlocationcode>


  		




  11
  11
  
    
                            <_join>


  		




  12
  
  
    
                                <1>$herbarium</1>


  		




  
  12
  
    
                                <1>


  		




  
  13
  
    
                                    <_map>


  		




  
  14
  
    
                                        <UNCCD>UNCC</UNCCD>


  		




  
  15
  
    
                                        <*>*</*>


  		




  
  16
  
    
                                        <value>$herbarium</value>


  		




  
  17
  
    
                                    </_map>


  		




  
  18
  
    
                                </1>


  		




  13
  19
  
    
                                <3>$accession</3>


  		




  14
  20
  
    
                            </_join>


  		




  15
  21
  
    
                        </authorlocationcode>


  		




  ......




  99
  105
  
    
                                            <collectionnumber>$collectno</collectionnumber>


  		




  100
  106
  
    
                                            <institution_id>


  		




  101
  107
  
    
                                                <sourcelist>


  		




  102
  
  
    
                                                    <name>$herbarium</name>


  		




  103
  
  
    
                                                    <sourcename><name>$herbarium</name></sourcename>


  		




  
  108
  
    
                                                    <name>


  		




  
  109
  
    
                                                        <_map>


  		




  
  110
  
    
                                                            <UNCCD>UNCC</UNCCD>


  		




  
  111
  
    
                                                            <*>*</*>


  		




  
  112
  
    
                                                            <value>$herbarium</value>


  		




  
  113
  
    
                                                        </_map>


  		




  
  114
  
    
                                                    </name>


  		




  
  115
  
    
                                                    <sourcename>


  		




  
  116
  
    
                                                        <name>


  		




  
  117
  
    
                                                            <_map>


  		




  
  118
  
    
                                                                <UNCCD>UNCC</UNCCD>


  		




  
  119
  
    
                                                                <*>*</*>


  		




  
  120
  
    
                                                                <value>$herbarium</value>


  		




  
  121
  
    
                                                            </_map>


  		




  
  122
  
    
                                                        </name>


  		




  
  123
  
    
                                                    </sourcename>


  		




  104
  124
  
    
                                                </sourcelist>


  		




  105
  125
  
    
                                            </institution_id>


  		




  106
  126
  
    
                                        </specimenreplicate>


  		












  

    
      inputs/UNCC/Specimen/new_terms.csv
    
  





  1
  
  
    
herbarium,specimenIndexer,,"""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)"


  		




  
  1
  
    
herbarium,specimenIndexer,"/_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."


  		




  2
  2
  
    
usdaRank,taxonRank,/_alt/1,


  		




  3
  3
  
    
infrarank,taxonRank,/_alt/2,


  		




  4
  4
  
    
infraname,infraspecificEpithet,,


  		












Also available in:  Unified diff