Project

General

Profile

« Previous | Next » 

Revision 7433

Added by Aaron Marcuse-Kubitza almost 12 years ago

mappings/VegCore-VegBIEN.csv: institutionCode list->sourcename mapping: _split(): Also match ; as a separator, and match separators with or without a following space

View differences:

inputs/TRT/Specimen/VegBIEN.csv
34 34 
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
35 35 
id,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
36 36 
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
37 
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
37 
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator=""[,;] *""]/value",
38 38 
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
39 39 
recordNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",
40 40 
scientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/2",
inputs/MO/Specimen/test.xml.ref
68 68 
                                                    <sourcename>
69 69 
                                                        <name>
70 70 
                                                            <_split>
71 
                                                                <separator>, </separator>
71 
                                                                <separator>[,;] *</separator>
72 72 
                                                                <value>$InstitutionCode</value>
73 73 
                                                            </_split>
74 74 
                                                        </name>
mappings/VegCore-VegBIEN.csv
176 176 
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
177 177 
occurrenceID,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
178 178 
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
179 
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
179 
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator=""[,;] *""]/value",
180 180 
occurrenceID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
181 181 
stemCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemcount,
182 182 
authorStemCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/authorstemcode,
inputs/Madidi/IndividualObservation/VegBIEN.csv
27 27 
SpecimenID,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
28 28 
SpecimenID,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
29 29 
Institutions,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
30 
Institutions,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
30 
Institutions,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator=""[,;] *""]/value",
31 31 
Trunk,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/authorstemcode,
32 32 
Diameter,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/diameterbreastheight_m/_cm_to_m/value,
33 33 
TotalHeight,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/height_m,
inputs/UNCC/Specimen/VegBIEN.csv
72 72 
HAVING count(*) > 1
73 73 
-----"
74 74 
herbarium,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
75 
herbarium,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
75 
herbarium,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator=""[,;] *""]/value",
76 76 
collectno,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",
77 77 
SciName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/3",
78 78 
collector,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_join/1,
inputs/.herbaria/ih/VegBIEN.csv
5 5 
:specimen,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/cond/_eq:[right=plot]/left",
6 6 
acronym,"/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",
7 7 
acronym,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
8 
acronym,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
8 
acronym,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator=""[,;] *""]/value",
9 9 
AddEmail,,** No join mapping for *AddEmail **
10 10 
AddEmuUserId,,** No join mapping for *AddEmuUserId **
11 11 
AddPhysCity,,** No join mapping for *AddPhysCity **
inputs/REMIB/Specimen/test.xml.ref
60 60 
                                                    <sourcename>
61 61 
                                                        <name>
62 62 
                                                            <_split>
63 
                                                                <separator>, </separator>
63 
                                                                <separator>[,;] *</separator>
64 64 
                                                                <value>$acronym</value>
65 65 
                                                            </_split>
66 66 
                                                        </name>
inputs/ARIZ/Specimen/test.xml.ref
92 92 
                                                    <sourcename>
93 93 
                                                        <name>
94 94 
                                                            <_split>
95 
                                                                <separator>, </separator>
95 
                                                                <separator>[,;] *</separator>
96 96 
                                                                <value>$InstitutionCode</value>
97 97 
                                                            </_split>
98 98 
                                                        </name>
inputs/MO/Specimen/VegBIEN.csv
22 22 
CollectorNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else",
23 23 
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
24 24 
InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
25 
InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
25 
InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator=""[,;] *""]/value",
26 26 
CollectorNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",
27 27 
ScientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/3",
28 28 
Collector,/location/locationevent/taxonoccurrence/collector_id/party/fullname,
inputs/TRTE/Specimen/test.xml.ref
64 64 
                                                    <sourcename>
65 65 
                                                        <name>
66 66 
                                                            <_split>
67 
                                                                <separator>, </separator>
67 
                                                                <separator>[,;] *</separator>
68 68 
                                                                <value>$institutionCode</value>
69 69 
                                                            </_split>
70 70 
                                                        </name>
inputs/MT/Specimen/VegBIEN.csv
14 14 
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/2,
15 15 
id,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
16 16 
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
17 
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
17 
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator=""[,;] *""]/value",
18 18 
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
19 19 
id,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
20 20 
establishmentMeans,"/location/locationevent/taxonoccurrence/iscultivated/_alt/2/_map:[cultivated=t,wild=f,*=]/value",
inputs/MT/Specimen/test.xml.ref
28 28 
                                                    <sourcename>
29 29 
                                                        <name>
30 30 
                                                            <_split>
31 
                                                                <separator>, </separator>
31 
                                                                <separator>[,;] *</separator>
32 32 
                                                                <value>$institutionCode</value>
33 33 
                                                            </_split>
34 34 
                                                        </name>
inputs/XAL/Specimen/VegBIEN.csv
25 25 
darwin:CollectorNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else",
26 26 
darwin:CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
27 27 
darwin:InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
28 
darwin:InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
28 
darwin:InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator=""[,;] *""]/value",
29 29 
darwin:CollectorNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",
30 30 
darwin:ScientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/3",
31 31 
darwin:Collector,/location/locationevent/taxonoccurrence/collector_id/party/fullname,
inputs/NCU/Specimen/VegBIEN.csv
26 26 
SpecimenPK,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
27 27 
CatalogSeriesPrefix,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name/_alt/1",
28 28 
OwnerInstitution,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name/_alt/2",
29 
CatalogSeriesPrefix,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value/_alt/1",
30 
OwnerInstitution,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value/_alt/2",
29 
CatalogSeriesPrefix,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator=""[,;] *""]/value/_alt/1",
30 
OwnerInstitution,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator=""[,;] *""]/value/_alt/2",
31 31 
SpecimenPK,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
32 32 
firstCollectorRemarks,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3","Actually the collector's number, not remarks"
33 33 
CurrentScientificNameWithAuthor,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/2",
inputs/NCU/Specimen/test.xml.ref
56 56 
                                                    <sourcename>
57 57 
                                                        <name>
58 58 
                                                            <_split>
59 
                                                                <separator>, </separator>
59 
                                                                <separator>[,;] *</separator>
60 60 
                                                                <value>
61 61 
                                                                    <_alt>
62 62 
                                                                        <1>$CatalogSeriesPrefix</1>
inputs/ACAD/Specimen/VegBIEN.csv
30 30 
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
31 31 
id,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
32 32 
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
33 
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
33 
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator=""[,;] *""]/value",
34 34 
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
35 35 
recordNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",
36 36 
scientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/2",
inputs/ACAD/Specimen/test.xml.ref
64 64 
                                                    <sourcename>
65 65 
                                                        <name>
66 66 
                                                            <_split>
67 
                                                                <separator>, </separator>
67 
                                                                <separator>[,;] *</separator>
68 68 
                                                                <value>$institutionCode</value>
69 69 
                                                            </_split>
70 70 
                                                        </name>
inputs/WIN/Specimen/VegBIEN.csv
31 31 
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
32 32 
id,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
33 33 
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
34 
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
34 
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator=""[,;] *""]/value",
35 35 
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
36 36 
recordNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",
37 37 
scientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/2",
inputs/WIN/Specimen/test.xml.ref
69 69 
                                                    <sourcename>
70 70 
                                                        <name>
71 71 
                                                            <_split>
72 
                                                                <separator>, </separator>
72 
                                                                <separator>[,;] *</separator>
73 73 
                                                                <value>$institutionCode</value>
74 74 
                                                            </_split>
75 75 
                                                        </name>
inputs/GBIF/Specimen/VegBIEN.csv
14 14 
CollectionCD,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name
15 15 
CatalogNO,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
16 16 
InstitutionCD,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
17 
InstitutionCD,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
17 
InstitutionCD,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator=""[,;] *""]/value",
18 18 
ScientificNameOriginal,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/1",
19 19 
ScientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/3",
20 20 
Collector,/location/locationevent/taxonoccurrence/collector_id/party/fullname,
inputs/GBIF/Specimen/test.xml.ref
35 35 
                                                    <sourcename>
36 36 
                                                        <name>
37 37 
                                                            <_split>
38 
                                                                <separator>, </separator>
38 
                                                                <separator>[,;] *</separator>
39 39 
                                                                <value>$InstitutionCD</value>
40 40 
                                                            </_split>
41 41 
                                                        </name>
inputs/QFA/Specimen/VegBIEN.csv
31 31 
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
32 32 
id,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
33 33 
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
34 
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
34 
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator=""[,;] *""]/value",
35 35 
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
36 36 
recordNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",
37 37 
scientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/2",
inputs/QFA/Specimen/test.xml.ref
64 64 
                                                    <sourcename>
65 65 
                                                        <name>
66 66 
                                                            <_split>
67 
                                                                <separator>, </separator>
67 
                                                                <separator>[,;] *</separator>
68 68 
                                                                <value>$institutionCode</value>
69 69 
                                                            </_split>
70 70 
                                                        </name>
inputs/JBM/Specimen/VegBIEN.csv
30 30 
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
31 31 
id,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
32 32 
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
33 
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
33 
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator=""[,;] *""]/value",
34 34 
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
35 35 
recordNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",
36 36 
scientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/2",
inputs/JBM/Specimen/test.xml.ref
67 67 
                                                    <sourcename>
68 68 
                                                        <name>
69 69 
                                                            <_split>
70 
                                                                <separator>, </separator>
70 
                                                                <separator>[,;] *</separator>
71 71 
                                                                <value>$institutionCode</value>
72 72 
                                                            </_split>
73 73 
                                                        </name>
inputs/UBC/Specimen/VegBIEN.csv
32 32 
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
33 33 
id,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
34 34 
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
35 
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
35 
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator=""[,;] *""]/value",
36 36 
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
37 37 
recordNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",
38 38 
scientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/2",
inputs/UBC/Specimen/test.xml.ref
64 64 
                                                    <sourcename>
65 65 
                                                        <name>
66 66 
                                                            <_split>
67 
                                                                <separator>, </separator>
67 
                                                                <separator>[,;] *</separator>
68 68 
                                                                <value>$institutionCode</value>
69 69 
                                                            </_split>
70 70 
                                                        </name>
inputs/HIBG/Specimen/VegBIEN.csv
30 30 
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
31 31 
id,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
32 32 
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
33 
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
33 
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator=""[,;] *""]/value",
34 34 
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
35 35 
recordNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",
36 36 
scientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/2",
inputs/HIBG/Specimen/test.xml.ref
64 64 
                                                    <sourcename>
65 65 
                                                        <name>
66 66 
                                                            <_split>
67 
                                                                <separator>, </separator>
67 
                                                                <separator>[,;] *</separator>
68 68 
                                                                <value>$institutionCode</value>
69 69 
                                                            </_split>
70 70 
                                                        </name>
inputs/SpeciesLink/Specimen/VegBIEN.csv
117 117 
conceptual_darwin_2003_1_0_InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
118 118 
dwc_dwcore_InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
119 119 
dwc_terms_institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
120 
conceptual_darwin_2003_1_0_InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
121 
dwc_dwcore_InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
122 
dwc_terms_institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
120 
conceptual_darwin_2003_1_0_InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator=""[,;] *""]/value",
121 
dwc_dwcore_InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator=""[,;] *""]/value",
122 
dwc_terms_institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator=""[,;] *""]/value",
123 123 
dwc_dwcore_GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
124 124 
dwc_terms_recordNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3/_alt/1",
125 125 
conceptual_darwin_2003_1_0_FieldNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3/_alt/2","Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
inputs/SpeciesLink/Specimen/test.xml.ref
191 191 
                                                    <sourcename>
192 192 
                                                        <name>
193 193 
                                                            <_split>
194 
                                                                <separator>, </separator>
194 
                                                                <separator>[,;] *</separator>
195 195 
                                                                <value>
196 196 
                                                                    <_alt>
197 197 
                                                                        <0>$conceptual_darwin_2003_1_0_InstitutionCode</0>
inputs/bien_web/observation/VegBIEN.csv
25 25 
collectionNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else",
26 26 
observationID,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
27 27 
dataSourceName,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
28 
dataSourceName,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
28 
dataSourceName,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator=""[,;] *""]/value",
29 29 
observationID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
30 30 
plotCode,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
31 31 
plotID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
inputs/bien_web/observation/test.xml.ref
27 27 
                                                    <sourcename>
28 28 
                                                        <name>
29 29 
                                                            <_split>
30 
                                                                <separator>, </separator>
30 
                                                                <separator>[,;] *</separator>
31 31 
                                                                <value>$dataSourceName</value>
32 32 
                                                            </_split>
33 33 
                                                        </name>
inputs/NY/Specimen/VegBIEN.csv
29 29 
FieldNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else",Usage inconsistent with DwC definition
30 30 
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
31 31 
InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
32 
InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
32 
InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator=""[,;] *""]/value",
33 33 
FieldNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",Usage inconsistent with DwC definition
34 34 
ScientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/3",
35 35 
Collector,/location/locationevent/taxonoccurrence/collector_id/party/fullname,
inputs/NY/Specimen/test.xml.ref
112 112 
                                                    <sourcename>
113 113 
                                                        <name>
114 114 
                                                            <_split>
115 
                                                                <separator>, </separator>
115 
                                                                <separator>[,;] *</separator>
116 116 
                                                                <value>$InstitutionCode</value>
117 117 
                                                            </_split>
118 118 
                                                        </name>
inputs/Madidi/IndividualObservation/test.xml.ref
49 49 
                                                    <sourcename>
50 50 
                                                        <name>
51 51 
                                                            <_split>
52 
                                                                <separator>, </separator>
52 
                                                                <separator>[,;] *</separator>
53 53 
                                                                <value>$Institutions</value>
54 54 
                                                            </_split>
55 55 
                                                        </name>
inputs/UNCC/Specimen/test.xml.ref
88 88 
                                                    <sourcename>
89 89 
                                                        <name>
90 90 
                                                            <_split>
91 
                                                                <separator>, </separator>
91 
                                                                <separator>[,;] *</separator>
92 92 
                                                                <value>$herbarium</value>
93 93 
                                                            </_split>
94 94 
                                                        </name>
inputs/REMIB/Specimen/VegBIEN.csv
61 61 
HAVING count(*) > 1
62 62 
-----"
63 63 
acronym,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
64 
acronym,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
64 
acronym,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator=""[,;] *""]/value",
65 65 
collector,/location/locationevent/taxonoccurrence/collector_id/party/fullname,
66 66 
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=species]/taxonepithet",
67 67 
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=genus]/taxonepithet",
inputs/ARIZ/Specimen/VegBIEN.csv
39 39 
CatalogNumberNumeric,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists/_alt/1",
40 40 
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists/_alt/2",Don't overwrite CatalogNumberNumeric
41 41 
InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
42 
InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
42 
InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator=""[,;] *""]/value",
43 43 
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
44 44 
CollectorNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",
45 45 
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/2",Contains the binomial in addition to the authority
inputs/TRT/Specimen/test.xml.ref
83 83 
                                                    <sourcename>
84 84 
                                                        <name>
85 85 
                                                            <_split>
86 
                                                                <separator>, </separator>
86 
                                                                <separator>[,;] *</separator>
87 87 
                                                                <value>$institutionCode</value>
88 88 
                                                            </_split>
89 89 
                                                        </name>
inputs/TRTE/Specimen/VegBIEN.csv
30 30 
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
31 31 
id,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
32 32 
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
33 
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
33 
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator=""[,;] *""]/value",
34 34 
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
35 35 
recordNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",
36 36 
scientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/2",
mappings/for_review/VegCore-VegBIEN.csv
176 176 
catalogNumber,"//institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
177 177 
occurrenceID,"//institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
178 178 
institutionCode,"//institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
179 
institutionCode,"//institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name",
179 
institutionCode,"//institution_id/sourcelist/sourcename/name/_split:[separator=""[,;] *""]/value",
180 180 
occurrenceID,//specimenreplicate/sourceaccessioncode,
181 181 
stemCount,//plantobservation/stemcount,
182 182 
authorStemCode,//stemobservation/authorstemcode,

Also available in: Unified diff