Project

General

Profile

« Previous | Next » 

Revision 3180

Added by Aaron Marcuse-Kubitza over 12 years ago

mappings/DwC2-VegBIEN.specimens.csv: Mapped institutionCode. This will enable datasources to use specimenreplicate's institution_id index for duplicate elimination.

View differences:

mappings/DwC2-VegBIEN.specimens.csv
42 42 
collectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9
43 43 
fieldNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/3,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53
44 44 
institutionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,,8
45 
institutionCode,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/institution_id/party/organizationname,,
45 46 
acceptedNameUsage,,,135
46 47 
acceptedNameUsageID,,,128
47 48 
associatedMedia,,,36
......
100 101 
individualCount,,Brad: OMIT; not relevant for DwC plant specimen data.,25
101 102 
individualID,,"Brad: OMIT; db-specific element, not relevant to VB/VX",24
102 103 
informationWithheld,,,16
103 
institutionCode,,,
104 104 
island,,,62
105 105 
islandGroup,,,61
106 106 
latestAgeOrHighestStage,,,110
mappings/DwC-VegBIEN.specimens.csv
141 141 
fieldNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/3,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53
142 142 
InstitutionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,,8
143 143 
institutionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,,8
144 
InstitutionCode,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/institution_id/party/organizationname,,
145 
institutionCode,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/institution_id/party/organizationname,,
144 146 
AcceptedNameUsage,,** No non-empty join mapping for acceptedNameUsage **
145 147 
AcceptedNameUsageID,,** No non-empty join mapping for acceptedNameUsageID **
146 148 
AccessRights,,** No non-empty join mapping for accessRights **
......
202 204 
IndividualCount,,** No non-empty join mapping for individualCount **
203 205 
IndividualID,,** No non-empty join mapping for individualID **
204 206 
InformationWithheld,,** No non-empty join mapping for informationWithheld **
205 
InstitutionCode,,** No non-empty join mapping for institutionCode **
206 207 
Island,,** No non-empty join mapping for island **
207 208 
IslandGroup,,** No non-empty join mapping for islandGroup **
208 209 
JulianDay,,** No non-empty join mapping for julianDay **
......
350 351 
individualCount,,Brad: OMIT; not relevant for DwC plant specimen data.,25
351 352 
individualID,,"Brad: OMIT; db-specific element, not relevant to VB/VX",24
352 353 
informationWithheld,,,16
353 
institutionCode,,,
354 354 
island,,,62
355 355 
islandGroup,,,61
356 356 
julianDay,,** No non-empty join mapping for day **
inputs/MT/test/import.specimens.out.ref
1 
Inserted 17 new rows into database
1 
Inserted 18 new rows into database
inputs/MT/test/VegBIEN.specimens.xml.ref
47 47 
        <datasource_id><party><organizationname>MT</organizationname></party></datasource_id>
48 48 
        <sourceaccessioncode>1</sourceaccessioncode>
49 49 
        <collectionnumber>urn:lsid:biocol.org:col:14437</collectionnumber>
50 
        <institution_id><party><organizationname>Universit&#233; de Montr&#233;al Biodiversity Centre</organizationname></party></institution_id>
50 51 
    </specimenreplicate>
51 52 
    <specimenreplicate id="1">
52 53 
        <taxonoccurrence_id>
......
95 96 
        <datasource_id><party><organizationname>MT</organizationname></party></datasource_id>
96 97 
        <sourceaccessioncode>2</sourceaccessioncode>
97 98 
        <collectionnumber>urn:lsid:biocol.org:col:14437</collectionnumber>
99 
        <institution_id><party><organizationname>Universit&#233; de Montr&#233;al Biodiversity Centre</organizationname></party></institution_id>
98 100 
    </specimenreplicate>
99 101 
</VegBIEN>
inputs/MT/maps/VegBIEN.specimens.csv
7 7 
collectionCode,/collectioncode_dwc,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,12
8 8 
id,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/sourceaccessioncode","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19
9 9 
collectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9
10 
institutionCode,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/institution_id/party/organizationname,,
10 11 
basisOfRecord,,** No non-empty join mapping for basisOfRecord **
11 12 
countryCode,,** No non-empty join mapping for countryCode **
12 13 
datasetName,,** No non-empty join mapping for datasetName **
13 14 
individualCount,,** No non-empty join mapping for individualCount **
14 
institutionCode,,** No non-empty join mapping for institutionCode **
15 15 
language,,** No non-empty join mapping for language **
16 16 
occurrenceRemarks,,** No non-empty join mapping for occurrenceRemarks **
17 17 
rights,,** No non-empty join mapping for rights **
inputs/XAL/test/import.specimens.out.ref
1 
Inserted 42 new rows into database
1 
Inserted 43 new rows into database
inputs/XAL/test/VegBIEN.specimens.xml.ref
127 127 
        <datasource_id><party><organizationname>XAL</organizationname></party></datasource_id>
128 128 
        <catalognumber_dwc>K400001</catalognumber_dwc>
129 129 
        <collectionnumber>7086</collectionnumber>
130 
        <institution_id><party><organizationname>IE</organizationname></party></institution_id>
130 131 
    </specimenreplicate>
131 132 
    <specimenreplicate id="1">
132 133 
        <taxonoccurrence_id>
......
255 256 
        <datasource_id><party><organizationname>XAL</organizationname></party></datasource_id>
256 257 
        <catalognumber_dwc>K400002</catalognumber_dwc>
257 258 
        <collectionnumber>1216</collectionnumber>
259 
        <institution_id><party><organizationname>IE</organizationname></party></institution_id>
258 260 
    </specimenreplicate>
259 261 
</VegBIEN>
inputs/XAL/maps/VegBIEN.specimens.csv
35 35 
CatalogNumber,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/catalognumber_dwc","Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
36 36 
CollectorNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1/_alt/1,,22
37 37 
FieldNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/3,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53
38 
InstitutionCode,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/institution_id/party/organizationname,,
38 39 
BasisOfRecord,,** No non-empty join mapping for BasisOfRecord **
39 40 
DateLastModified,,** No non-empty join mapping for DateLastModified **
40 41 
IndividualCount,,** No non-empty join mapping for IndividualCount **
41 
InstitutionCode,,** No non-empty join mapping for InstitutionCode **
42 42 
JulianDay,,** No non-empty join mapping for JulianDay **
43 43 
PreparationType,,** No non-empty join mapping for PreparationType **
44 44 
PreviousCatalogNumber,,** No non-empty join mapping for PreviousCatalogNumber **
inputs/NY/test/VegBIEN.specimens.xml.ref
106 106 
        <catalognumber_dwc>00682023</catalognumber_dwc>
107 107 
        <sourceaccessioncode>816590</sourceaccessioncode>
108 108 
        <collectionnumber>9877</collectionnumber>
109 
        <institution_id><party><organizationname>NY</organizationname></party></institution_id>
109 110 
    </specimenreplicate>
110 111 
    <specimenreplicate id="1">
111 112 
        <taxonoccurrence_id>
......
188 189 
        <catalognumber_dwc>200996</catalognumber_dwc>
189 190 
        <sourceaccessioncode>220541</sourceaccessioncode>
190 191 
        <collectionnumber>545</collectionnumber>
192 
        <institution_id><party><organizationname>NY</organizationname></party></institution_id>
191 193 
    </specimenreplicate>
192 194 
</VegBIEN>
inputs/NY/maps/VegBIEN.specimens.csv
41 41 
UniqueNYInternalRecordNumber,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/sourceaccessioncode","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19
42 42 
CollectorNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1/_alt/1,,22
43 43 
FieldNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/3,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53
44 
InstitutionCode,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/institution_id/party/organizationname,,
44 45 
BasisOfRecord,,** No non-empty join mapping for BasisOfRecord **
45 46 
DateLastModified,,** No non-empty join mapping for DateLastModified **
46 47 
IndividualCount,,** No non-empty join mapping for IndividualCount **
47 
InstitutionCode,,** No non-empty join mapping for InstitutionCode **
48 48 
JulianDay,,** No non-empty join mapping for JulianDay **
49 49 
PreparationType,,** No non-empty join mapping for PreparationType **
50 50 
PreviousCatalogNumber,,** No non-empty join mapping for PreviousCatalogNumber **
inputs/ACAD/test/import.specimens.out.ref
1 
Inserted 33 new rows into database
1 
Inserted 34 new rows into database
inputs/ACAD/test/VegBIEN.specimens.xml.ref
121 121 
        <catalognumber_dwc>11186</catalognumber_dwc>
122 122 
        <sourceaccessioncode>8</sourceaccessioncode>
123 123 
        <collectionnumber>urn:lsid:biocol.org:col:13294</collectionnumber>
124 
        <institution_id><party><organizationname>Acadia University</organizationname></party></institution_id>
124 125 
    </specimenreplicate>
125 126 
    <specimenreplicate id="1">
126 127 
        <taxonoccurrence_id>
......
237 238 
        <catalognumber_dwc>12602</catalognumber_dwc>
238 239 
        <sourceaccessioncode>17</sourceaccessioncode>
239 240 
        <collectionnumber>urn:lsid:biocol.org:col:13294</collectionnumber>
241 
        <institution_id><party><organizationname>Acadia University</organizationname></party></institution_id>
240 242 
    </specimenreplicate>
241 243 
</VegBIEN>
inputs/ACAD/maps/VegBIEN.specimens.csv
26 26 
id,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/sourceaccessioncode","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19
27 27 
recordNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1/_alt/2,,22
28 28 
collectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9
29 
institutionCode,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/institution_id/party/organizationname,,
29 30 
basisOfRecord,,** No non-empty join mapping for basisOfRecord **
30 31 
bibliographicCitation,,** No non-empty join mapping for bibliographicCitation **
31 32 
dynamicProperties,,** No non-empty join mapping for dynamicProperties **
......
33 34 
georeferenceSources,,** No non-empty join mapping for georeferenceSources **
34 35 
georeferenceVerificationStatus,,** No non-empty join mapping for georeferenceVerificationStatus **
35 36 
identificationRemarks,,** No non-empty join mapping for identificationRemarks **
36 
institutionCode,,** No non-empty join mapping for institutionCode **
37 37 
language,,** No non-empty join mapping for language **
38 38 
locationRemarks,,** No non-empty join mapping for locationRemarks **
39 39 
modified,,** No non-empty join mapping for modified **
inputs/ARIZ/test/import.specimens.out.ref
1 
Inserted 33 new rows into database
1 
Inserted 34 new rows into database
inputs/ARIZ/test/VegBIEN.specimens.xml.ref
83 83 
        <catalognumber_dwc>104</catalognumber_dwc>
84 84 
        <sourceaccessioncode>Herbarium:ARIZ:dbsn104</sourceaccessioncode>
85 85 
        <collectionnumber>36</collectionnumber>
86 
        <institution_id><party><organizationname>Herbarium</organizationname></party></institution_id>
86 87 
    </specimenreplicate>
87 88 
    <specimenreplicate id="1">
88 89 
        <taxonoccurrence_id>
......
160 161 
        <catalognumber_dwc>198483</catalognumber_dwc>
161 162 
        <sourceaccessioncode>Herbarium:ARIZ:dbsn198483</sourceaccessioncode>
162 163 
        <collectionnumber>172</collectionnumber>
164 
        <institution_id><party><organizationname>Herbarium</organizationname></party></institution_id>
163 165 
    </specimenreplicate>
164 166 
</VegBIEN>
inputs/ARIZ/maps/VegBIEN.specimens.csv
41 41 
GlobalUniqueIdentifier,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/sourceaccessioncode","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19
42 42 
CollectorNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1/_alt/1,,22
43 43 
FieldNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/3,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53
44 
InstitutionCode,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/institution_id/party/organizationname,,
44 45 
AgeClass,,** No non-empty join mapping for lifeStage **
45 46 
BasisOfRecord,,** No non-empty join mapping for BasisOfRecord **
46 47 
CatalogNumber,,Map to nothing so it doesn't overwrite CatalogNumberNumeric
......
51 52 
HorizontalDatum,,Not used
52 53 
IdentificationModifier,,** No non-empty join mapping for identificationQualifier **
53 54 
IndividualCount,,** No non-empty join mapping for IndividualCount **
54 
InstitutionCode,,** No non-empty join mapping for InstitutionCode **
55 55 
Island,,** No non-empty join mapping for Island **
56 56 
IslandGroup,,** No non-empty join mapping for IslandGroup **
57 57 
JulianDay,,** No non-empty join mapping for JulianDay **
inputs/GBIF/test/import.specimens.out.ref
1 
Inserted 26 new rows into database
1 
Inserted 27 new rows into database
inputs/GBIF/test/VegBIEN.specimens.xml.ref
64 64 
        <collectioncode_dwc>Type herbarium, Gottingen (GOET)</collectioncode_dwc>
65 65 
        <datasource_id><party><organizationname>GBIF</organizationname></party></datasource_id>
66 66 
        <catalognumber_dwc>3390</catalognumber_dwc>
67 
        <institution_id><party><organizationname>GOET-Typen</organizationname></party></institution_id>
67 68 
    </specimenreplicate>
68 69 
    <specimenreplicate id="1">
69 70 
        <taxonoccurrence_id>
......
129 130 
        <collectioncode_dwc>Type herbarium, Gottingen (GOET)</collectioncode_dwc>
130 131 
        <datasource_id><party><organizationname>GBIF</organizationname></party></datasource_id>
131 132 
        <catalognumber_dwc>3395</catalognumber_dwc>
133 
        <institution_id><party><organizationname>GOET-Typen</organizationname></party></institution_id>
132 134 
    </specimenreplicate>
133 135 
</VegBIEN>
inputs/GBIF/maps/VegBIEN.specimens.csv
20 20 
Collector,/*_id/taxonoccurrence/verbatimcollectorname,,23
21 21 
CollectionCD,/collectioncode_dwc,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name,12
22 22 
CatalogNO,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/catalognumber_dwc","Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
23 
InstitutionCD,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/institution_id/party/organizationname,,
23 24 
GBIFFamilyOriginal,,** No non-empty join mapping for originalNameUsage/_alt/2/_name/first ** DwC doesn't fully support taxonomic redeterminations
24 25 
GBIFGenusOriginal,,** No non-empty join mapping for originalNameUsage/_alt/2/_name/middle ** DwC doesn't fully support taxonomic redeterminations
25 
InstitutionCD,,** No non-empty join mapping for InstitutionCode **
26 26 
LastDateModified,,** No non-empty join mapping for DateLastModified **
27 27 
ScientificNameOriginal,,** No non-empty join mapping for originalNameUsage/_alt/1 ** DwC doesn't fully support taxonomic redeterminations
inputs/SpeciesLink/test/import.specimens.out.ref
1 
Inserted 35 new rows into database
1 
Inserted 36 new rows into database
inputs/SpeciesLink/test/VegBIEN.specimens.xml.ref
108 108 
        <catalognumber_dwc>43226</catalognumber_dwc>
109 109 
        <sourceaccessioncode>96848826</sourceaccessioncode>
110 110 
        <collectionnumber>27</collectionnumber>
111 
        <institution_id><party><organizationname>UFPB</organizationname></party></institution_id>
111 112 
    </specimenreplicate>
112 113 
    <specimenreplicate id="1">
113 114 
        <taxonoccurrence_id>
......
215 216 
        <catalognumber_dwc>14046</catalognumber_dwc>
216 217 
        <sourceaccessioncode>96848863</sourceaccessioncode>
217 218 
        <collectionnumber>2745</collectionnumber>
219 
        <institution_id><party><organizationname>UFPB</organizationname></party></institution_id>
218 220 
    </specimenreplicate>
219 221 
</VegBIEN>
inputs/SpeciesLink/maps/VegBIEN.specimens.csv
83 83 
collectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9
84 84 
FieldNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/3,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53
85 85 
fieldNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/3,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53
86 
InstitutionCode,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/institution_id/party/organizationname,,
87 
institutionCode,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/institution_id/party/organizationname,,
86 88 
BasisOfRecord,,** No non-empty join mapping for BasisOfRecord **
87 89 
DateLastModified,,** No non-empty join mapping for DateLastModified **
88 90 
DayOfYear,,** No non-empty join mapping for JulianDay **
89 91 
IndividualCount,,** No non-empty join mapping for IndividualCount **
90 
InstitutionCode,,** No non-empty join mapping for InstitutionCode **
91 92 
JulianDay,,** No non-empty join mapping for JulianDay ** `union` would otherwise remove this input name because it's been mapped to (renamed) above
92 93 
PreparationType,,** No non-empty join mapping for PreparationType **
93 94 
PreviousCatalogNumber,,** No non-empty join mapping for PreviousCatalogNumber **
......
101 102 
endDayOfYear,,** No non-empty join mapping for endDayOfYear **
102 103 
eventTime,,** No non-empty join mapping for eventTime **
103 104 
individualCount,,** No non-empty join mapping for individualCount **
104 
institutionCode,,** No non-empty join mapping for institutionCode **
105 105 
month,,** No non-empty join mapping for month **
106 106 
occurrenceRemarks,,** No non-empty join mapping for occurrenceRemarks **
107 107 
otherCatalogNumbers,,** No non-empty join mapping for otherCatalogNumbers **
inputs/MO/test/VegBIEN.specimens.xml.ref
83 83 
        <datasource_id><party><organizationname>MO</organizationname></party></datasource_id>
84 84 
        <catalognumber_dwc>1</catalognumber_dwc>
85 85 
        <collectionnumber>10572</collectionnumber>
86 
        <institution_id><party><organizationname>MO</organizationname></party></institution_id>
86 87 
    </specimenreplicate>
87 88 
    <specimenreplicate id="1">
88 89 
        <taxonoccurrence_id>
......
178 179 
        <datasource_id><party><organizationname>MO</organizationname></party></datasource_id>
179 180 
        <catalognumber_dwc>2</catalognumber_dwc>
180 181 
        <collectionnumber>6723</collectionnumber>
182 
        <institution_id><party><organizationname>MO</organizationname></party></institution_id>
181 183 
    </specimenreplicate>
182 184 
</VegBIEN>
inputs/MO/maps/VegBIEN.specimens.csv
24 24 
convertednotes,/description/_merge/1,,
25 25 
CatalogNumber,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/catalognumber_dwc","Brad: Not sure if mapping correct. Nick, is there an element for institutional accession codes in VegX?; Aaron: This can't be used as the accession code (primary key) because some rows don't have a value for it",20
26 26 
CollectorNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/1/_alt/1,,22
27 
InstitutionCode,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/institution_id/party/organizationname,,
27 28 
BasisOfRecord,,** No non-empty join mapping for BasisOfRecord **
28 29 
DateLastModified,,** No non-empty join mapping for DateLastModified **
29 30 
IndividualCount,,** No non-empty join mapping for IndividualCount **
30 
InstitutionCode,,** No non-empty join mapping for InstitutionCode **
31 31 
TypeStatus,,** No non-empty join mapping for TypeStatus **
inputs/QMOR/test/import.specimens.out.ref
1 
Inserted 29 new rows into database
1 
Inserted 30 new rows into database
inputs/QMOR/test/VegBIEN.specimens.xml.ref
115 115 
        <catalognumber_dwc>QMOR00000001</catalognumber_dwc>
116 116 
        <sourceaccessioncode>1</sourceaccessioncode>
117 117 
        <collectionnumber>urn:lsid:biocol.org:col:34164</collectionnumber>
118 
        <institution_id><party><organizationname>Universit&#233; de Montr&#233;al Biodiversity Centre</organizationname></party></institution_id>
118 119 
    </specimenreplicate>
119 120 
    <specimenreplicate id="1">
120 121 
        <taxonoccurrence_id>
......
231 232 
        <catalognumber_dwc>QMOR00000002</catalognumber_dwc>
232 233 
        <sourceaccessioncode>2</sourceaccessioncode>
233 234 
        <collectionnumber>urn:lsid:biocol.org:col:34164</collectionnumber>
235 
        <institution_id><party><organizationname>Universit&#233; de Montr&#233;al Biodiversity Centre</organizationname></party></institution_id>
234 236 
    </specimenreplicate>
235 237 
</VegBIEN>
inputs/QMOR/maps/VegBIEN.specimens.csv
33 33 
id,":[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel,*_id/taxonoccurrence]/sourceaccessioncode","Brad: OMIT; Aaron: We need this field because it is the only ID column with an entry in every row; Brad: OK, use this as primary key",19
34 34 
collectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9
35 35 
institutionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,,8
36 
institutionCode,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/institution_id/party/organizationname,,
36 37 
acceptedNameUsage,,** No non-empty join mapping for acceptedNameUsage **
37 38 
basisOfRecord,,** No non-empty join mapping for basisOfRecord **
38 39 
behavior,,** No non-empty join mapping for behavior **
......
50 51 
identificationQualifier,,** No non-empty join mapping for identificationQualifier **
51 52 
identificationRemarks,,** No non-empty join mapping for identificationRemarks **
52 53 
individualCount,,** No non-empty join mapping for individualCount **
53 
institutionCode,,** No non-empty join mapping for institutionCode **
54 54 
language,,** No non-empty join mapping for language **
55 55 
lifeStage,,** No non-empty join mapping for lifeStage **
56 56 
locationRemarks,,** No non-empty join mapping for locationRemarks **
mappings/for_review/DwC2-VegBIEN.specimens.csv
42 42 
collectionID,/collectionnumber/_alt/2,,9
43 43 
fieldNumber,/collectionnumber/_alt/3,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53
44 44 
institutionID,//party/organizationname/_alt/1,,8
45 
institutionCode,//party/organizationname,,
45 46 
acceptedNameUsage,,,135
46 47 
acceptedNameUsageID,,,128
47 48 
associatedMedia,,,36
......
100 101 
individualCount,,Brad: OMIT; not relevant for DwC plant specimen data.,25
101 102 
individualID,,"Brad: OMIT; db-specific element, not relevant to VB/VX",24
102 103 
informationWithheld,,,16
103 
institutionCode,,,
104 104 
island,,,62
105 105 
islandGroup,,,61
106 106 
latestAgeOrHighestStage,,,110
mappings/DwC.cs-VegBIEN.specimens.csv
70 70 
collectionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/2,,9
71 71 
fieldNumber,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/collectionnumber/_alt/3,"Brad: Correct for VB, not sure about VX; Nick, is there an element in VX fo Collection Number?",53
72 72 
institutionID,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/datasource_id/party/organizationname/_alt/1,,8
73 
institutionCode,:[datasource_id/party/organizationname/_alt/2=$/_ignore/inLabel]/institution_id/party/organizationname,,
73 74 
acceptedNameUsage,,,135
74 75 
acceptedNameUsageID,,,128
75 76 
accessRights,,** No non-empty join mapping for dcterms:accessRights ** Versions without namespace
......
131 132 
individualCount,,Brad: OMIT; not relevant for DwC plant specimen data.,25
132 133 
individualID,,"Brad: OMIT; db-specific element, not relevant to VB/VX",24
133 134 
informationWithheld,,,16
134 
institutionCode,,,
135 135 
island,,,62
136 136 
islandGroup,,,61
137 137 
julianDay,,** No non-empty join mapping for day **

Also available in: Unified diff