Project

General

Profile

« Previous | Next » 

Revision 6795

mappings/VegCore-VegBIEN.csv: institutionCode: Removed mapping to sourcename.matched_source_id, which is now autopopulated. Split any list of institutionCodes apart using new _split().

View differences:

inputs/MO/Specimen/VegBIEN.csv
21 21
CollectionCode,/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
22 22
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
23 23
InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
24
InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/matched_source_id/source/shortname",
25
InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name",
24
InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
26 25
CollectorNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/1",
27 26
ScientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",
28 27
Collector,/location/locationevent/taxonoccurrence/collector_id/party/fullname,
inputs/TRTE/Specimen/test.xml.ref
61 61
                                                <sourcelist>
62 62
                                                    <name>$institutionCode</name>
63 63
                                                    <sourcename>
64
                                                        <matched_source_id><source><shortname>$institutionCode</shortname></source></matched_source_id>
65
                                                        <name>$institutionCode</name>
64
                                                        <name>
65
                                                            <_split>
66
                                                                <separator>, </separator>
67
                                                                <value>$institutionCode</value>
68
                                                            </_split>
69
                                                        </name>
66 70
                                                    </sourcename>
67 71
                                                </sourcelist>
68 72
                                            </institution_id>
......
322 326
        </path>
323 327
    </_setDefault>
324 328
</VegBIEN>
325
Inserted 36 new rows into database
329
Inserted 35 new rows into database
inputs/UNCC/Specimen/VegBIEN.csv
62 62
HAVING count(*) > 1
63 63
-----"
64 64
herbarium,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
65
herbarium,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/matched_source_id/source/shortname",
66
herbarium,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name",
65
herbarium,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
67 66
accession,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,"Globally unique, although occasionally duplicated. [1]
68 67

  
69 68
[1] Using the following query:
inputs/.herbaria/herbaria/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
herbariumAcronym,"/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
herbariumAcronym,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
8
herbariumAcronym,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/matched_source_id/source/shortname",
9
herbariumAcronym,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name",
8
herbariumAcronym,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
10 9
City,,"** No non-empty join mapping for OMIT ** Just importing whether a datasource is a herbarium, for now"
11 10
CoordinatesVerbatim,,"** No non-empty join mapping for OMIT ** Just importing whether a datasource is a herbarium, for now"
12 11
Country,,"** No non-empty join mapping for OMIT ** Just importing whether a datasource is a herbarium, for now"
inputs/REMIB/Specimen/test.xml.ref
58 58
                                                <sourcelist>
59 59
                                                    <name>$acronym</name>
60 60
                                                    <sourcename>
61
                                                        <matched_source_id><source><shortname>$acronym</shortname></source></matched_source_id>
62
                                                        <name>$acronym</name>
61
                                                        <name>
62
                                                            <_split>
63
                                                                <separator>, </separator>
64
                                                                <value>$acronym</value>
65
                                                            </_split>
66
                                                        </name>
63 67
                                                    </sourcename>
64 68
                                                </sourcelist>
65 69
                                            </institution_id>
......
222 226
        </path>
223 227
    </_setDefault>
224 228
</VegBIEN>
225
Inserted 34 new rows into database
229
Inserted 33 new rows into database
inputs/ARIZ/Specimen/test.xml.ref
89 89
                                                <sourcelist>
90 90
                                                    <name>$InstitutionCode</name>
91 91
                                                    <sourcename>
92
                                                        <matched_source_id><source><shortname>$InstitutionCode</shortname></source></matched_source_id>
93
                                                        <name>$InstitutionCode</name>
92
                                                        <name>
93
                                                            <_split>
94
                                                                <separator>, </separator>
95
                                                                <value>$InstitutionCode</value>
96
                                                            </_split>
97
                                                        </name>
94 98
                                                    </sourcename>
95 99
                                                </sourcelist>
96 100
                                            </institution_id>
......
374 378
        </path>
375 379
    </_setDefault>
376 380
</VegBIEN>
377
Inserted 46 new rows into database
381
Inserted 45 new rows into database
inputs/TRT/Specimen/test.xml.ref
80 80
                                                <sourcelist>
81 81
                                                    <name>$institutionCode</name>
82 82
                                                    <sourcename>
83
                                                        <matched_source_id><source><shortname>$institutionCode</shortname></source></matched_source_id>
84
                                                        <name>$institutionCode</name>
83
                                                        <name>
84
                                                            <_split>
85
                                                                <separator>, </separator>
86
                                                                <value>$institutionCode</value>
87
                                                            </_split>
88
                                                        </name>
85 89
                                                    </sourcename>
86 90
                                                </sourcelist>
87 91
                                            </institution_id>
......
360 364
        </path>
361 365
    </_setDefault>
362 366
</VegBIEN>
363
Inserted 44 new rows into database
367
Inserted 43 new rows into database
inputs/TRTE/Specimen/VegBIEN.csv
28 28
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
29 29
id,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
30 30
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
31
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/matched_source_id/source/shortname",
32
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name",
31
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
33 32
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
34 33
recordNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/1",
35 34
scientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/2",
mappings/for_review/VegCore-VegBIEN.csv
118 118
catalogNumber,"//institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
119 119
occurrenceID,"//institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
120 120
institutionCode,"//institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
121
institutionCode,"//institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/matched_source_id/source/shortname",
122 121
institutionCode,"//institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name",
123 122
occurrenceID,//specimenreplicate/sourceaccessioncode,
124 123
stemCount,//plantobservation/stemcount,
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/matched_source_id/source/shortname",
18
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name",
17
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
19 18
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
20 19
id,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
21 20
establishmentMeans,"/location/locationevent/taxonoccurrence/iscultivated/_alt/2/_map:[cultivated=t,wild=f,*=]/value",
inputs/MT/Specimen/test.xml.ref
26 26
                                                <sourcelist>
27 27
                                                    <name>$institutionCode</name>
28 28
                                                    <sourcename>
29
                                                        <matched_source_id><source><shortname>$institutionCode</shortname></source></matched_source_id>
30
                                                        <name>$institutionCode</name>
29
                                                        <name>
30
                                                            <_split>
31
                                                                <separator>, </separator>
32
                                                                <value>$institutionCode</value>
33
                                                            </_split>
34
                                                        </name>
31 35
                                                    </sourcename>
32 36
                                                </sourcelist>
33 37
                                            </institution_id>
......
132 136
        </path>
133 137
    </_setDefault>
134 138
</VegBIEN>
135
Inserted 27 new rows into database
139
Inserted 26 new rows into database
inputs/XAL/Specimen/VegBIEN.csv
21 21
darwin:CollectionCode,/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
22 22
darwin:CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
23 23
darwin:InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
24
darwin:InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/matched_source_id/source/shortname",
25
darwin:InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name",
24
darwin:InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
26 25
darwin:CollectorNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/1",
27 26
darwin:ScientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",
28 27
darwin:Collector,/location/locationevent/taxonoccurrence/collector_id/party/fullname,
inputs/NCU/Specimen/VegBIEN.csv
25 25
SpecimenPK,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
26 26
CatalogSeriesPrefix,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name/_alt/1",
27 27
OwnerInstitution,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name/_alt/2",
28
CatalogSeriesPrefix,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/matched_source_id/source/shortname/_alt/1",
29
OwnerInstitution,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/matched_source_id/source/shortname/_alt/2",
30
CatalogSeriesPrefix,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_alt/1",
31
OwnerInstitution,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_alt/2",
28
CatalogSeriesPrefix,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value/_alt/1",
29
OwnerInstitution,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value/_alt/2",
32 30
SpecimenPK,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
33 31
firstCollectorRemarks,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/1","Actually the collector's number, not remarks"
34 32
CurrentScientificNameWithAuthor,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/2",
inputs/NCU/Specimen/test.xml.ref
53 53
                                                        </_alt>
54 54
                                                    </name>
55 55
                                                    <sourcename>
56
                                                        <matched_source_id>
57
                                                            <source>
58
                                                                <shortname>
56
                                                        <name>
57
                                                            <_split>
58
                                                                <separator>, </separator>
59
                                                                <value>
59 60
                                                                    <_alt>
60 61
                                                                        <1>$CatalogSeriesPrefix</1>
61 62
                                                                        <2>$OwnerInstitution</2>
62 63
                                                                    </_alt>
63
                                                                </shortname>
64
                                                            </source>
65
                                                        </matched_source_id>
66
                                                        <name>
67
                                                            <_alt>
68
                                                                <1>$CatalogSeriesPrefix</1>
69
                                                                <2>$OwnerInstitution</2>
70
                                                            </_alt>
64
                                                                </value>
65
                                                            </_split>
71 66
                                                        </name>
72 67
                                                    </sourcename>
73 68
                                                </sourcelist>
......
202 197
        </path>
203 198
    </_setDefault>
204 199
</VegBIEN>
205
Inserted 42 new rows into database
200
Inserted 40 new rows into database
inputs/ACAD/Specimen/VegBIEN.csv
28 28
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
29 29
id,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
30 30
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
31
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/matched_source_id/source/shortname",
32
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name",
31
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
33 32
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
34 33
recordNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/1",
35 34
scientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/2",
inputs/ACAD/Specimen/test.xml.ref
61 61
                                                <sourcelist>
62 62
                                                    <name>$institutionCode</name>
63 63
                                                    <sourcename>
64
                                                        <matched_source_id><source><shortname>$institutionCode</shortname></source></matched_source_id>
65
                                                        <name>$institutionCode</name>
64
                                                        <name>
65
                                                            <_split>
66
                                                                <separator>, </separator>
67
                                                                <value>$institutionCode</value>
68
                                                            </_split>
69
                                                        </name>
66 70
                                                    </sourcename>
67 71
                                                </sourcelist>
68 72
                                            </institution_id>
......
323 327
        </path>
324 328
    </_setDefault>
325 329
</VegBIEN>
326
Inserted 48 new rows into database
330
Inserted 47 new rows into database
inputs/WIN/Specimen/VegBIEN.csv
29 29
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
30 30
id,"/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/matched_source_id/source/shortname",
33
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name",
32
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
34 33
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
35 34
recordNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/1",
36 35
scientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/2",
inputs/WIN/Specimen/test.xml.ref
66 66
                                                <sourcelist>
67 67
                                                    <name>$institutionCode</name>
68 68
                                                    <sourcename>
69
                                                        <matched_source_id><source><shortname>$institutionCode</shortname></source></matched_source_id>
70
                                                        <name>$institutionCode</name>
69
                                                        <name>
70
                                                            <_split>
71
                                                                <separator>, </separator>
72
                                                                <value>$institutionCode</value>
73
                                                            </_split>
74
                                                        </name>
71 75
                                                    </sourcename>
72 76
                                                </sourcelist>
73 77
                                            </institution_id>
......
298 302
        </path>
299 303
    </_setDefault>
300 304
</VegBIEN>
301
Inserted 38 new rows into database
305
Inserted 37 new rows into database
inputs/QFA/Specimen/VegBIEN.csv
28 28
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
29 29
id,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
30 30
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
31
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/matched_source_id/source/shortname",
32
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name",
31
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
33 32
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
34 33
recordNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/1",
35 34
scientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/2",
inputs/QFA/Specimen/test.xml.ref
61 61
                                                <sourcelist>
62 62
                                                    <name>$institutionCode</name>
63 63
                                                    <sourcename>
64
                                                        <matched_source_id><source><shortname>$institutionCode</shortname></source></matched_source_id>
65
                                                        <name>$institutionCode</name>
64
                                                        <name>
65
                                                            <_split>
66
                                                                <separator>, </separator>
67
                                                                <value>$institutionCode</value>
68
                                                            </_split>
69
                                                        </name>
66 70
                                                    </sourcename>
67 71
                                                </sourcelist>
68 72
                                            </institution_id>
......
337 341
        </path>
338 342
    </_setDefault>
339 343
</VegBIEN>
340
Inserted 48 new rows into database
344
Inserted 47 new rows into database
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/matched_source_id/source/shortname",
18
InstitutionCD,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name",
17
InstitutionCD,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
19 18
ScientificNameOriginal,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/1",
20 19
ScientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",
21 20
Collector,/location/locationevent/taxonoccurrence/collector_id/party/fullname,
inputs/GBIF/Specimen/test.xml.ref
33 33
                                                <sourcelist>
34 34
                                                    <name>$InstitutionCD</name>
35 35
                                                    <sourcename>
36
                                                        <matched_source_id><source><shortname>$InstitutionCD</shortname></source></matched_source_id>
37
                                                        <name>$InstitutionCD</name>
36
                                                        <name>
37
                                                            <_split>
38
                                                                <separator>, </separator>
39
                                                                <value>$InstitutionCD</value>
40
                                                            </_split>
41
                                                        </name>
38 42
                                                    </sourcename>
39 43
                                                </sourcelist>
40 44
                                            </institution_id>
......
331 335
        </path>
332 336
    </_setDefault>
333 337
</VegBIEN>
334
Inserted 48 new rows into database
338
Inserted 47 new rows into database
inputs/JBM/Specimen/VegBIEN.csv
29 29
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
30 30
id,"/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/matched_source_id/source/shortname",
33
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name",
32
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
34 33
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
35 34
recordNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/1",
36 35
scientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/2",
inputs/JBM/Specimen/test.xml.ref
64 64
                                                <sourcelist>
65 65
                                                    <name>$institutionCode</name>
66 66
                                                    <sourcename>
67
                                                        <matched_source_id><source><shortname>$institutionCode</shortname></source></matched_source_id>
68
                                                        <name>$institutionCode</name>
67
                                                        <name>
68
                                                            <_split>
69
                                                                <separator>, </separator>
70
                                                                <value>$institutionCode</value>
71
                                                            </_split>
72
                                                        </name>
69 73
                                                    </sourcename>
70 74
                                                </sourcelist>
71 75
                                            </institution_id>
......
284 288
        </path>
285 289
    </_setDefault>
286 290
</VegBIEN>
287
Inserted 39 new rows into database
291
Inserted 38 new rows into database
inputs/UBC/Specimen/VegBIEN.csv
28 28
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
29 29
id,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
30 30
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
31
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/matched_source_id/source/shortname",
32
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name",
31
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
33 32
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
34 33
recordNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/1",
35 34
scientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/2",
inputs/UBC/Specimen/test.xml.ref
61 61
                                                <sourcelist>
62 62
                                                    <name>$institutionCode</name>
63 63
                                                    <sourcename>
64
                                                        <matched_source_id><source><shortname>$institutionCode</shortname></source></matched_source_id>
65
                                                        <name>$institutionCode</name>
64
                                                        <name>
65
                                                            <_split>
66
                                                                <separator>, </separator>
67
                                                                <value>$institutionCode</value>
68
                                                            </_split>
69
                                                        </name>
66 70
                                                    </sourcename>
67 71
                                                </sourcelist>
68 72
                                            </institution_id>
......
323 327
        </path>
324 328
    </_setDefault>
325 329
</VegBIEN>
326
Inserted 44 new rows into database
330
Inserted 43 new rows into database
inputs/HIBG/Specimen/VegBIEN.csv
28 28
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
29 29
id,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
30 30
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
31
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/matched_source_id/source/shortname",
32
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name",
31
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
33 32
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
34 33
recordNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/1",
35 34
scientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/2",
inputs/HIBG/Specimen/test.xml.ref
61 61
                                                <sourcelist>
62 62
                                                    <name>$institutionCode</name>
63 63
                                                    <sourcename>
64
                                                        <matched_source_id><source><shortname>$institutionCode</shortname></source></matched_source_id>
65
                                                        <name>$institutionCode</name>
64
                                                        <name>
65
                                                            <_split>
66
                                                                <separator>, </separator>
67
                                                                <value>$institutionCode</value>
68
                                                            </_split>
69
                                                        </name>
66 70
                                                    </sourcename>
67 71
                                                </sourcelist>
68 72
                                            </institution_id>
inputs/SpeciesLink/Specimen/VegBIEN.csv
94 94
conceptual_darwin_2003_1_0_InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
95 95
dwc_dwcore_InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
96 96
dwc_terms_institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
97
conceptual_darwin_2003_1_0_InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/matched_source_id/source/shortname",
98
dwc_dwcore_InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/matched_source_id/source/shortname",
99
dwc_terms_institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/matched_source_id/source/shortname",
100
conceptual_darwin_2003_1_0_InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name",
101
dwc_dwcore_InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name",
102
dwc_terms_institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name",
97
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",
98
dwc_dwcore_InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
99
dwc_terms_institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
103 100
dwc_dwcore_GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
104 101
dwc_terms_recordNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/1/_alt/1",
105 102
conceptual_darwin_2003_1_0_FieldNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/1/_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
171 171
                                                        </_alt>
172 172
                                                    </name>
173 173
                                                    <sourcename>
174
                                                        <matched_source_id>
175
                                                            <source>
176
                                                                <shortname>
174
                                                        <name>
175
                                                            <_split>
176
                                                                <separator>, </separator>
177
                                                                <value>
177 178
                                                                    <_alt>
178 179
                                                                        <0>$conceptual_darwin_2003_1_0_InstitutionCode</0>
179 180
                                                                        <1>$dwc_dwcore_InstitutionCode</1>
180 181
                                                                        <2>$dwc_terms_institutionCode</2>
181 182
                                                                    </_alt>
182
                                                                </shortname>
183
                                                            </source>
184
                                                        </matched_source_id>
185
                                                        <name>
186
                                                            <_alt>
187
                                                                <0>$conceptual_darwin_2003_1_0_InstitutionCode</0>
188
                                                                <1>$dwc_dwcore_InstitutionCode</1>
189
                                                                <2>$dwc_terms_institutionCode</2>
190
                                                            </_alt>
183
                                                                </value>
184
                                                            </_split>
191 185
                                                        </name>
192 186
                                                    </sourcename>
193 187
                                                </sourcelist>
......
759 753
        </path>
760 754
    </_setDefault>
761 755
</VegBIEN>
762
Inserted 48 new rows into database
756
Inserted 47 new rows into database
inputs/bien_web/observation/VegBIEN.csv
24 24
collectionNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber,
25 25
observationID,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
26 26
dataSourceName,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
27
dataSourceName,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/matched_source_id/source/shortname",
28
dataSourceName,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name",
27
dataSourceName,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
29 28
observationID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
30 29
plotCode,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
31 30
plotID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
inputs/bien_web/observation/test.xml.ref
24 24
                                                <sourcelist>
25 25
                                                    <name>$dataSourceName</name>
26 26
                                                    <sourcename>
27
                                                        <matched_source_id><source><shortname>$dataSourceName</shortname></source></matched_source_id>
28
                                                        <name>$dataSourceName</name>
27
                                                        <name>
28
                                                            <_split>
29
                                                                <separator>, </separator>
30
                                                                <value>$dataSourceName</value>
31
                                                            </_split>
32
                                                        </name>
29 33
                                                    </sourcename>
30 34
                                                </sourcelist>
31 35
                                            </institution_id>
inputs/NY/Specimen/VegBIEN.csv
25 25
CollectionCode,/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
26 26
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
27 27
InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
28
InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/matched_source_id/source/shortname",
29
InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name",
28
InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
30 29
FieldNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/1",Usage inconsistent with DwC definition
31 30
ScientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",
32 31
Collector,/location/locationevent/taxonoccurrence/collector_id/party/fullname,
inputs/NY/Specimen/test.xml.ref
109 109
                                                <sourcelist>
110 110
                                                    <name>$InstitutionCode</name>
111 111
                                                    <sourcename>
112
                                                        <matched_source_id><source><shortname>$InstitutionCode</shortname></source></matched_source_id>
113
                                                        <name>$InstitutionCode</name>
112
                                                        <name>
113
                                                            <_split>
114
                                                                <separator>, </separator>
115
                                                                <value>$InstitutionCode</value>
116
                                                            </_split>
117
                                                        </name>
114 118
                                                    </sourcename>
115 119
                                                </sourcelist>
116 120
                                            </institution_id>
inputs/UNCC/Specimen/test.xml.ref
79 79
                                                <sourcelist>
80 80
                                                    <name>$herbarium</name>
81 81
                                                    <sourcename>
82
                                                        <matched_source_id><source><shortname>$herbarium</shortname></source></matched_source_id>
83
                                                        <name>$herbarium</name>
82
                                                        <name>
83
                                                            <_split>
84
                                                                <separator>, </separator>
85
                                                                <value>$herbarium</value>
86
                                                            </_split>
87
                                                        </name>
84 88
                                                    </sourcename>
85 89
                                                </sourcelist>
86 90
                                            </institution_id>
......
319 323
        </path>
320 324
    </_setDefault>
321 325
</VegBIEN>
322
Inserted 30 new rows into database
326
Inserted 29 new rows into database
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/matched_source_id/source/shortname",
65
acronym,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name",
64
acronym,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
66 65
collector,/location/locationevent/taxonoccurrence/collector_id/party/fullname,
67 66
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/1/_taxon_family_require_std/family/_nullIf/value",
68 67
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/_if[@name=""if has verbatim name""]/else/matched_label_id/taxonlabel:[source_id/source/shortname=TNRS]/taxonomicname/_join_words/2/_alt/2/_join_words/1/_alt/2/_join_words/2",
inputs/ARIZ/Specimen/VegBIEN.csv
33 33
CatalogNumberNumeric,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists/_alt/1",
34 34
CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists/_alt/2",Don't overwrite CatalogNumberNumeric
35 35
InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
36
InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/matched_source_id/source/shortname",
37
InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name",
36
InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
38 37
GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
39 38
CollectorNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/1",
40 39
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/2",Contains the binomial in addition to the authority
inputs/TRT/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/matched_source_id/source/shortname",
35
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name",
34
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
36 35
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
37 36
recordNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/1",
38 37
scientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/2",
inputs/MO/Specimen/test.xml.ref
65 65
                                                <sourcelist>
66 66
                                                    <name>$InstitutionCode</name>
67 67
                                                    <sourcename>
68
                                                        <matched_source_id><source><shortname>$InstitutionCode</shortname></source></matched_source_id>
69
                                                        <name>$InstitutionCode</name>
68
                                                        <name>
69
                                                            <_split>
70
                                                                <separator>, </separator>
71
                                                                <value>$InstitutionCode</value>
72
                                                            </_split>
73
                                                        </name>
70 74
                                                    </sourcename>
71 75
                                                </sourcelist>
72 76
                                            </institution_id>
mappings/VegCore-VegBIEN.csv
118 118
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
119 119
occurrenceID,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
120 120
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
121
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/matched_source_id/source/shortname",
122
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name",
121
institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator="", ""]/value",
123 122
occurrenceID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
124 123
stemCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemcount,
125 124
authorStemCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/authorstemcode,

Also available in: Unified diff