Project

General

Profile

« Previous | Next » 

Revision 4066

Added by Aaron Marcuse-Kubitza over 12 years ago

mappings/DwC2-VegBIEN.specimens.csv, VegCSV-VegBIEN.specimens.csv: occurrenceID: Mapped to location.authorlocationcode instead of sourceaccessioncode so that it would not override any location- or event-related IDs in location.authorlocationcode merely by being mapped to the sourceaccessioncode field (which takes precedence over the authorlocationcode when specified)

View differences:

mappings/DwC.cs-VegBIEN.specimens.csv
1 1 
DwC,VegBIEN:,Comments
2 
institutionCode,/location/authorlocationcode/_alt/3/_merge/1,
3 
collectionCode,/location/authorlocationcode/_alt/3/_merge/2/_merge/1,
4 
collectionID,/location/authorlocationcode/_alt/3/_merge/2/_merge/2,
5 
catalogNumber,"/location/authorlocationcode/_alt/3/_merge/3/_if[@name=""if indirect voucher""]/else",
2 
globalUniqueIdentifier,/location/authorlocationcode/_alt/3,
3 
id,/location/authorlocationcode/_alt/3,
4 
occurrenceID,/location/authorlocationcode/_alt/3,
5 
institutionCode,/location/authorlocationcode/_alt/4/_merge/1,
6 
collectionCode,/location/authorlocationcode/_alt/4/_merge/2/_merge/1,
7 
collectionID,/location/authorlocationcode/_alt/4/_merge/2/_merge/2,
8 
catalogNumber,"/location/authorlocationcode/_alt/4/_merge/3/_if[@name=""if indirect voucher""]/else",
6 9 
verbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",
7 10 
maximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
8 11 
maximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
......
112 115 
locality,/location/locationnarrative/_merge/1,
113 116 
verbatimLocality,/location/locationnarrative/_merge/2,
114 117 
habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?"
115 
globalUniqueIdentifier,/location/sourceaccessioncode/_alt/1,
116 
id,/location/sourceaccessioncode/_alt/1,
117 
occurrenceID,/location/sourceaccessioncode/_alt/1,
118 
locationID,/location/sourceaccessioncode/_alt/2,
118 
locationID,/location/sourceaccessioncode,
119 119 
acceptedNameUsage,,
120 120 
acceptedNameUsageID,,
121 121 
accessRights,,** No non-empty join mapping for dcterms:accessRights **
inputs/SpeciesLink/test/import.specimens.xml.ref
2 2 
<VegBIEN>
3 3 
    <location id="-1">
4 4 
        <authorlocationcode>
5 
            <_merge>
6 
                <1>
5 
            <_alt>
6 
                <3>$dwc_dwcore_GlobalUniqueIdentifier</3>
7 
                <4>
7 8 
                    <_merge>
8 
                        <0>$dwc_dwcore_InstitutionCode</0>
9 
                        <1>$conceptual_darwin_2003_1_0_InstitutionCode</1>
10 
                        <2>$dwc_terms_institutionCode</2>
11 
                    </_merge>
12 
                </1>
13 
                <2>
14 
                    <_merge>
15 9 
                        <1>
16 10 
                            <_merge>
17 
                                <0>$dwc_dwcore_CollectionCode</0>
18 
                                <1>$conceptual_darwin_2003_1_0_CollectionCode</1>
19 
                                <2>$dwc_terms_collectionCode</2>
11 
                                <0>$dwc_dwcore_InstitutionCode</0>
12 
                                <1>$conceptual_darwin_2003_1_0_InstitutionCode</1>
13 
                                <2>$dwc_terms_institutionCode</2>
20 14 
                            </_merge>
21 15 
                        </1>
22 
                        <2>$dwc_terms_collectionID</2>
23 
                    </_merge>
24 
                </2>
25 
                <3>
26 
                    <_if name="if indirect voucher">
27 
                        <else>
16 
                        <2>
28 17 
                            <_merge>
29 
                                <0>$dwc_dwcore_CatalogNumber</0>
30 
                                <1>$conceptual_darwin_2003_1_0_CatalogNumber</1>
31 
                                <2>$dwc_terms_catalogNumber</2>
18 
                                <1>
19 
                                    <_merge>
20 
                                        <0>$dwc_dwcore_CollectionCode</0>
21 
                                        <1>$conceptual_darwin_2003_1_0_CollectionCode</1>
22 
                                        <2>$dwc_terms_collectionCode</2>
23 
                                    </_merge>
24 
                                </1>
25 
                                <2>$dwc_terms_collectionID</2>
32 26 
                            </_merge>
33 
                        </else>
34 
                    </_if>
35 
                </3>
36 
            </_merge>
27 
                        </2>
28 
                        <3>
29 
                            <_if name="if indirect voucher">
30 
                                <else>
31 
                                    <_merge>
32 
                                        <0>$dwc_dwcore_CatalogNumber</0>
33 
                                        <1>$conceptual_darwin_2003_1_0_CatalogNumber</1>
34 
                                        <2>$dwc_terms_catalogNumber</2>
35 
                                    </_merge>
36 
                                </else>
37 
                            </_if>
38 
                        </3>
39 
                    </_merge>
40 
                </4>
41 
            </_alt>
37 42 
        </authorlocationcode>
38 43 
        <elevation>
39 44 
            <_avg>
......
758 763 
                <2>$dwc_terms_locality</2>
759 764 
            </_merge>
760 765 
        </locationnarrative>
761 
        <sourceaccessioncode>$dwc_dwcore_GlobalUniqueIdentifier</sourceaccessioncode>
762 766 
    </location>
763 767 
</VegBIEN>
764 768 
Inserted 40 new rows into database
inputs/MO/maps/VegBIEN.specimens.csv
1 1 
MO[DwC],VegBIEN:,Comments
2 
InstitutionCode,/location/authorlocationcode/_alt/3/_merge/1,
3 
CollectionCode,/location/authorlocationcode/_alt/3/_merge/2/_merge/1,
4 
CatalogNumber,"/location/authorlocationcode/_alt/3/_merge/3/_if[@name=""if indirect voucher""]/else",
2 
InstitutionCode,/location/authorlocationcode/_alt/4/_merge/1,
3 
CollectionCode,/location/authorlocationcode/_alt/4/_merge/2/_merge/1,
4 
CatalogNumber,"/location/authorlocationcode/_alt/4/_merge/3/_if[@name=""if indirect voucher""]/else",
5 5 
MaximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
6 6 
MinimumElevation,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
7 7 
MinimumElevation,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
inputs/QMOR/maps/VegBIEN.specimens.csv
1 1 
QMOR[DwC],VegBIEN:,Comments
2 
institutionCode,/location/authorlocationcode/_alt/3/_merge/1,
3 
collectionCode,/location/authorlocationcode/_alt/3/_merge/2/_merge/1,
4 
collectionID,/location/authorlocationcode/_alt/3/_merge/2/_merge/2,
5 
catalogNumber,"/location/authorlocationcode/_alt/3/_merge/3/_if[@name=""if indirect voucher""]/else",
2 
id,/location/authorlocationcode/_alt/3,
3 
institutionCode,/location/authorlocationcode/_alt/4/_merge/1,
4 
collectionCode,/location/authorlocationcode/_alt/4/_merge/2/_merge/1,
5 
collectionID,/location/authorlocationcode/_alt/4/_merge/2/_merge/2,
6 
catalogNumber,"/location/authorlocationcode/_alt/4/_merge/3/_if[@name=""if indirect voucher""]/else",
6 7 
verbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",
7 8 
maximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
8 9 
minimumElevationInMeters,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
......
50 51 
recordedBy,/location/locationevent/taxonoccurrence/verbatimcollectorname,
51 52 
locality,/location/locationnarrative/_merge/1,
52 53 
habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?"
53 
id,/location/sourceaccessioncode/_alt/1,
54 54 
acceptedNameUsage,,** No non-empty join mapping for acceptedNameUsage **
55 55 
basisOfRecord,,** No non-empty join mapping for basisOfRecord **
56 56 
behavior,,** No non-empty join mapping for behavior **
mappings/DwC2-VegBIEN.specimens.csv
1 1 
DwC,VegBIEN:,Comments
2 
institutionCode,/location/authorlocationcode/_alt/3/_merge/1,
3 
collectionCode,/location/authorlocationcode/_alt/3/_merge/2/_merge/1,
4 
collectionID,/location/authorlocationcode/_alt/3/_merge/2/_merge/2,
5 
catalogNumber,"/location/authorlocationcode/_alt/3/_merge/3/_if[@name=""if indirect voucher""]/else",
2 
occurrenceID,/location/authorlocationcode/_alt/3,
3 
institutionCode,/location/authorlocationcode/_alt/4/_merge/1,
4 
collectionCode,/location/authorlocationcode/_alt/4/_merge/2/_merge/1,
5 
collectionID,/location/authorlocationcode/_alt/4/_merge/2/_merge/2,
6 
catalogNumber,"/location/authorlocationcode/_alt/4/_merge/3/_if[@name=""if indirect voucher""]/else",
6 7 
verbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",
7 8 
maximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
8 9 
minimumElevationInMeters,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
......
65 66 
locality,/location/locationnarrative/_merge/1,
66 67 
verbatimLocality,/location/locationnarrative/_merge/2,
67 68 
habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?"
68 
occurrenceID,/location/sourceaccessioncode/_alt/1,
69 
locationID,/location/sourceaccessioncode/_alt/2,
69 
locationID,/location/sourceaccessioncode,
70 70 
acceptedNameUsage,,
71 71 
acceptedNameUsageID,,
72 72 
associatedMedia,,
mappings/DwC-VegBIEN.specimens.csv
1 1 
DwC,VegBIEN:,Comments
2 
InstitutionCode,/location/authorlocationcode/_alt/3/_merge/1,
3 
institutionCode,/location/authorlocationcode/_alt/3/_merge/1,
4 
CollectionCode,/location/authorlocationcode/_alt/3/_merge/2/_merge/1,
5 
collectionCode,/location/authorlocationcode/_alt/3/_merge/2/_merge/1,
6 
CollectionID,/location/authorlocationcode/_alt/3/_merge/2/_merge/2,
7 
collectionID,/location/authorlocationcode/_alt/3/_merge/2/_merge/2,
8 
CatalogNumber,"/location/authorlocationcode/_alt/3/_merge/3/_if[@name=""if indirect voucher""]/else",
9 
catalogNumber,"/location/authorlocationcode/_alt/3/_merge/3/_if[@name=""if indirect voucher""]/else",
2 
GlobalUniqueIdentifier,/location/authorlocationcode/_alt/3,
3 
Id,/location/authorlocationcode/_alt/3,
4 
OccurrenceID,/location/authorlocationcode/_alt/3,
5 
globalUniqueIdentifier,/location/authorlocationcode/_alt/3,
6 
id,/location/authorlocationcode/_alt/3,
7 
occurrenceID,/location/authorlocationcode/_alt/3,
8 
InstitutionCode,/location/authorlocationcode/_alt/4/_merge/1,
9 
institutionCode,/location/authorlocationcode/_alt/4/_merge/1,
10 
CollectionCode,/location/authorlocationcode/_alt/4/_merge/2/_merge/1,
11 
collectionCode,/location/authorlocationcode/_alt/4/_merge/2/_merge/1,
12 
CollectionID,/location/authorlocationcode/_alt/4/_merge/2/_merge/2,
13 
collectionID,/location/authorlocationcode/_alt/4/_merge/2/_merge/2,
14 
CatalogNumber,"/location/authorlocationcode/_alt/4/_merge/3/_if[@name=""if indirect voucher""]/else",
15 
catalogNumber,"/location/authorlocationcode/_alt/4/_merge/3/_if[@name=""if indirect voucher""]/else",
10 16 
VerbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",
11 17 
verbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",
12 18 
MaximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
......
225 231 
verbatimLocality,/location/locationnarrative/_merge/2,
226 232 
Habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?"
227 233 
habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?"
228 
GlobalUniqueIdentifier,/location/sourceaccessioncode/_alt/1,
229 
Id,/location/sourceaccessioncode/_alt/1,
230 
OccurrenceID,/location/sourceaccessioncode/_alt/1,
231 
globalUniqueIdentifier,/location/sourceaccessioncode/_alt/1,
232 
id,/location/sourceaccessioncode/_alt/1,
233 
occurrenceID,/location/sourceaccessioncode/_alt/1,
234 
LocationID,/location/sourceaccessioncode/_alt/2,
235 
locationID,/location/sourceaccessioncode/_alt/2,
234 
LocationID,/location/sourceaccessioncode,
235 
locationID,/location/sourceaccessioncode,
236 236 
AcceptedNameUsage,,** No non-empty join mapping for acceptedNameUsage **
237 237 
AcceptedNameUsageID,,** No non-empty join mapping for acceptedNameUsageID **
238 238 
AccessRights,,** No non-empty join mapping for accessRights **
inputs/MT/test/import.specimens.xml.ref
2 2 
<VegBIEN>
3 3 
    <location id="-1">
4 4 
        <authorlocationcode>
5 
            <_merge>
6 
                <1>$institutionCode</1>
7 
                <2>
5 
            <_alt>
6 
                <3>$id</3>
7 
                <4>
8 8 
                    <_merge>
9 
                        <1>$collectionCode</1>
10 
                        <2>$collectionID</2>
9 
                        <1>$institutionCode</1>
10 
                        <2>
11 
                            <_merge>
12 
                                <1>$collectionCode</1>
13 
                                <2>$collectionID</2>
14 
                            </_merge>
15 
                        </2>
11 16 
                    </_merge>
12 
                </2>
13 
            </_merge>
17 
                </4>
18 
            </_alt>
14 19 
        </authorlocationcode>
15 20 
        <locationdetermination>
16 21 
            <namedplace_id>
......
125 130 
            </taxonoccurrence>
126 131 
        </locationevent>
127 132 
        <locationnarrative>$locality</locationnarrative>
128 
        <sourceaccessioncode>$id</sourceaccessioncode>
129 133 
    </location>
130 134 
</VegBIEN>
131 135 
Inserted 22 new rows into database
inputs/MT/maps/VegBIEN.specimens.csv
1 1 
MT[DwC],VegBIEN:,Comments
2 
institutionCode,/location/authorlocationcode/_alt/3/_merge/1,
3 
collectionCode,/location/authorlocationcode/_alt/3/_merge/2/_merge/1,
4 
collectionID,/location/authorlocationcode/_alt/3/_merge/2/_merge/2,
2 
id,/location/authorlocationcode/_alt/3,
3 
institutionCode,/location/authorlocationcode/_alt/4/_merge/1,
4 
collectionCode,/location/authorlocationcode/_alt/4/_merge/2/_merge/1,
5 
collectionID,/location/authorlocationcode/_alt/4/_merge/2/_merge/2,
5 6 
continent,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
6 7 
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
7 8 
id,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/sourceaccessioncode,
......
15 16 
genus,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
16 17 
family,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
17 18 
locality,/location/locationnarrative/_merge/1,
18 
id,/location/sourceaccessioncode/_alt/1,
19 19 
basisOfRecord,,** No non-empty join mapping for basisOfRecord **
20 20 
countryCode,,** No non-empty join mapping for countryCode **
21 21 
datasetName,,** No non-empty join mapping for datasetName **
inputs/XAL/maps/VegBIEN.specimens.csv
1 1 
"XAL[DwC,darwin:]:/content/record/",VegBIEN:,Comments
2 
InstitutionCode,/location/authorlocationcode/_alt/3/_merge/1,
3 
CollectionCode,/location/authorlocationcode/_alt/3/_merge/2/_merge/1,
4 
CatalogNumber,"/location/authorlocationcode/_alt/3/_merge/3/_if[@name=""if indirect voucher""]/else",
2 
InstitutionCode,/location/authorlocationcode/_alt/4/_merge/1,
3 
CollectionCode,/location/authorlocationcode/_alt/4/_merge/2/_merge/1,
4 
CatalogNumber,"/location/authorlocationcode/_alt/4/_merge/3/_if[@name=""if indirect voucher""]/else",
5 5 
MaximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
6 6 
MinimumElevation,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
7 7 
MinimumElevation,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
inputs/NY/test/import.specimens.xml.ref
2 2 
<VegBIEN>
3 3 
    <location id="-1">
4 4 
        <authorlocationcode>
5 
            <_merge>
6 
                <1>$InstitutionCode</1>
7 
                <2>$CollectionCode</2>
8 
                <3><_if name="if indirect voucher"><else>$CatalogNumber</else></_if></3>
9 
            </_merge>
5 
            <_alt>
6 
                <3>$UniqueNYInternalRecordNumber</3>
7 
                <4>
8 
                    <_merge>
9 
                        <1>$InstitutionCode</1>
10 
                        <2>$CollectionCode</2>
11 
                        <3><_if name="if indirect voucher"><else>$CatalogNumber</else></_if></3>
12 
                    </_merge>
13 
                </4>
14 
            </_alt>
10 15 
        </authorlocationcode>
11 16 
        <elevation>
12 17 
            <_avg>
......
480 485 
                </3>
481 486 
            </_merge>
482 487 
        </locationnarrative>
483 
        <sourceaccessioncode>$UniqueNYInternalRecordNumber</sourceaccessioncode>
484 488 
    </location>
485 489 
</VegBIEN>
486 490 
Inserted 39 new rows into database
inputs/NY/maps/VegBIEN.specimens.csv
1 1 
NY[DwC],VegBIEN:,Comments
2 
InstitutionCode,/location/authorlocationcode/_alt/3/_merge/1,
3 
CollectionCode,/location/authorlocationcode/_alt/3/_merge/2/_merge/1,
4 
CatalogNumber,"/location/authorlocationcode/_alt/3/_merge/3/_if[@name=""if indirect voucher""]/else",
2 
UniqueNYInternalRecordNumber,/location/authorlocationcode/_alt/3,
3 
InstitutionCode,/location/authorlocationcode/_alt/4/_merge/1,
4 
CollectionCode,/location/authorlocationcode/_alt/4/_merge/2/_merge/1,
5 
CatalogNumber,"/location/authorlocationcode/_alt/4/_merge/3/_if[@name=""if indirect voucher""]/else",
5 6 
MaximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
6 7 
MinimumElevation,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value/_nullIf:[null=.]/value",
7 8 
MinimumElevation,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value/_nullIf:[null=.]/value",
......
64 65 
Substrate,"/location/locationnarrative/_merge/1/_merge/2/_label[label=""substrate""]/value",
65 66 
Vegetation,"/location/locationnarrative/_merge/1/_merge/3/_label[label=""vegetation""]/value",
66 67 
Habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?"
67 
UniqueNYInternalRecordNumber,/location/sourceaccessioncode/_alt/1,
68 68 
BasisOfRecord,,** No non-empty join mapping for BasisOfRecord **
69 69 
DateLastModified,,** No non-empty join mapping for DateLastModified **
70 70 
JulianDay,,** No non-empty join mapping for JulianDay **
inputs/Madidi/maps/VegBIEN.plots.csv
36 36 
Direction,/location/slopeaspect/_compass/value/_alt/1,Part files provide either this field or Direction
37 37 
Orientación/exposicion,/location/slopeaspect/_compass/value/_alt/2,Part files provide either this field or Orientación
38 38 
Slope,/location/slopegradient,
39 
Inventory code,/location/sourceaccessioncode/_alt/2,
39 
Inventory code,/location/sourceaccessioncode,
40 40 
Collaborators,,"Need a way to store a verbatim list of people, or a function to parse it and insert it iteratively into party"
41 41 
Coordinates,,Concatenation of Latitude (DMS) and Longitude (DMS)
42 42 
Installed and evaluated by,,"Need a way to store a verbatim list of people, or a function to parse it and insert it iteratively into party"
inputs/UNCC/test/import.specimens.xml.ref
1 1 
Put template:
2 2 
<VegBIEN>
3 3 
    <location id="-1">
4 
        <authorlocationcode>$herbarium</authorlocationcode>
4 
        <authorlocationcode>
5 
            <_alt>
6 
                <3>$accession</3>
7 
                <4>$herbarium</4>
8 
            </_alt>
9 
        </authorlocationcode>
5 10 
        <locationdetermination>
6 11 
            <namedplace_id>
7 12 
                <_simplifyPath>
......
269 274 
                </3>
270 275 
            </_merge>
271 276 
        </locationnarrative>
272 
        <sourceaccessioncode>$accession</sourceaccessioncode>
273 277 
    </location>
274 278 
</VegBIEN>
275 279 
Inserted 22 new rows into database
inputs/UNCC/maps/VegBIEN.specimens.csv
1 1 
UNCC[DwC],VegBIEN:,Comments
2 
herbarium,/location/authorlocationcode/_alt/3/_merge/1,
2 
accession,/location/authorlocationcode/_alt/3,
3 
herbarium,/location/authorlocationcode/_alt/4/_merge/1,
3 4 
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
4 5 
state,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
5 6 
country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
......
40 41 
collector3,/location/locationevent/taxonoccurrence/verbatimcollectorname/_merge/4,
41 42 
locality,/location/locationnarrative/_merge/1,
42 43 
habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?"
43 
accession,/location/sourceaccessioncode/_alt/1,
44 44 
filler,,"Where used, same as family"
45 45 
flower,,"** No non-empty join mapping for reproductiveCondition/_map:[A=*,I=*,M=*]/value ** Main values are A, I, and M. What do they mean?"
46 46 
fruit,,"** No non-empty join mapping for reproductiveCondition/_map:[A=*,I=*,M=*]/value ** Main values are A, I, and M. What do they mean?"
inputs/ACAD/test/import.specimens.xml.ref
2 2 
<VegBIEN>
3 3 
    <location id="-1">
4 4 
        <authorlocationcode>
5 
            <_merge>
6 
                <1>$institutionCode</1>
7 
                <2>
5 
            <_alt>
6 
                <3>$id</3>
7 
                <4>
8 8 
                    <_merge>
9 
                        <1>$collectionCode</1>
10 
                        <2>$collectionID</2>
9 
                        <1>$institutionCode</1>
10 
                        <2>
11 
                            <_merge>
12 
                                <1>$collectionCode</1>
13 
                                <2>$collectionID</2>
14 
                            </_merge>
15 
                        </2>
16 
                        <3><_if name="if indirect voucher"><else>$catalogNumber</else></_if></3>
11 17 
                    </_merge>
12 
                </2>
13 
                <3><_if name="if indirect voucher"><else>$catalogNumber</else></_if></3>
14 
            </_merge>
18 
                </4>
19 
            </_alt>
15 20 
        </authorlocationcode>
16 21 
        <elevation>
17 22 
            <_replace>
......
190 195 
                </3>
191 196 
            </_merge>
192 197 
        </locationnarrative>
193 
        <sourceaccessioncode>$id</sourceaccessioncode>
194 198 
    </location>
195 199 
</VegBIEN>
196 200 
Inserted 38 new rows into database
inputs/ACAD/maps/VegBIEN.specimens.csv
1 1 
ACAD[DwC],VegBIEN:,Comments
2 
institutionCode,/location/authorlocationcode/_alt/3/_merge/1,
3 
collectionCode,/location/authorlocationcode/_alt/3/_merge/2/_merge/1,
4 
collectionID,/location/authorlocationcode/_alt/3/_merge/2/_merge/2,
5 
catalogNumber,"/location/authorlocationcode/_alt/3/_merge/3/_if[@name=""if indirect voucher""]/else",
2 
id,/location/authorlocationcode/_alt/3,
3 
institutionCode,/location/authorlocationcode/_alt/4/_merge/1,
4 
collectionCode,/location/authorlocationcode/_alt/4/_merge/2/_merge/1,
5 
collectionID,/location/authorlocationcode/_alt/4/_merge/2/_merge/2,
6 
catalogNumber,"/location/authorlocationcode/_alt/4/_merge/3/_if[@name=""if indirect voucher""]/else",
6 7 
verbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",
7 8 
decimalLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",
8 9 
decimalLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
......
40 41 
recordedBy,/location/locationevent/taxonoccurrence/verbatimcollectorname,
41 42 
locality,/location/locationnarrative/_merge/1,
42 43 
habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?"
43 
id,/location/sourceaccessioncode/_alt/1,
44 44 
basisOfRecord,,** No non-empty join mapping for basisOfRecord **
45 45 
bibliographicCitation,,** No non-empty join mapping for bibliographicCitation **
46 46 
dynamicProperties,,** No non-empty join mapping for dynamicProperties **
inputs/SALVIAS-CSV/test/import.organisms.xml.ref
4 4 
        <authorlocationcode>
5 5 
            <_alt>
6 6 
                <1>$subplot</1>
7 
                <3>
7 
                <4>
8 8 
                    <_if name="if indirect voucher">
9 9 
                        <cond>
10 10 
                            <_eq>
......
19 19 
                            </_alt>
20 20 
                        </else>
21 21 
                    </_if>
22 
                </3>
22 
                </4>
23 23 
            </_alt>
24 24 
        </authorlocationcode>
25 25 
        <locationevent>
inputs/SALVIAS-CSV/maps/VegBIEN.plots.csv
41 41 
locality_description,/location/locationnarrative/_merge/1,"Brad: No; this is free text description of locality where plot was situated, same as for DwC. Not a description of vegetation. Most likely='namedPlace.placeDescription' in VB; not sure about VX, again need to ask Nick where locality descriptions live in VX"
42 42 
slope_aspect,/location/slopeaspect/_compass/value,
43 43 
slope_gradient,/location/slopegradient,
44 
PLOT_ID,/location/sourceaccessioncode/_alt/2,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
44 
PLOT_ID,/location/sourceaccessioncode,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
45 45 
observation_type,,"Brad: SALVIAS internal metadata indicating whether the record represents an individual or aggregate observation. Rather than storing, use to decide where to store in VegX.; Aaron: VegX aggregateOrganismObservation table is missing many fields available in individualOrganismObservation, so we're mapping to individualOrganismObservation regardless of observation type"
46 46 
recensused,,"Brad: This is a 0/1 value, internal to SALVIAS. 1 indicates that a  plot has >1 set of values, from different census events.; Aaron: Different censuses are distinguished in organisms data by different census_no values"
inputs/SALVIAS-CSV/maps/VegBIEN.organisms.csv
1 1 
SALVIAS-CSV,VegBIEN:,Comments
2 2 
subplot,/location/authorlocationcode/_alt/1,
3 
det_type,"/location/authorlocationcode/_alt/3/_merge/3/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left","Brad: A SALVIAS value referring to the relationship between the voucher specimen and the observation. Affect how the identification of the specimen(latin name) is transferred to the observation. 'direct'=voucher specimen was collected from this same tree; they are one and the same individual. 'indirect'=voucher specimen was collected for a different individual, but the original data provider confirmed that this is the same species. 'default'=basically same as 'indirect'. 'uncollected'=no voucher specimen, data provider  asserted that this was the name but was unable to collect. The main different is that with 'direct', 'indirect', and 'default', the scientific name can be updated automatically based on the name attached to the specimen voucher (assuming you have a link to that data, presumably from a herbarium database. Whereas, if det_type='uncollected', the name can never change because there is no specimen."
4 
coll_number,"/location/authorlocationcode/_alt/3/_merge/3/_if[@name=""if indirect voucher""]/else/_alt/1",Brad: Incorrect. Map instead as for voucher_string
5 
voucher_string,"/location/authorlocationcode/_alt/3/_merge/3/_if[@name=""if indirect voucher""]/else/_alt/2","Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."
3 
det_type,"/location/authorlocationcode/_alt/4/_merge/3/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left","Brad: A SALVIAS value referring to the relationship between the voucher specimen and the observation. Affect how the identification of the specimen(latin name) is transferred to the observation. 'direct'=voucher specimen was collected from this same tree; they are one and the same individual. 'indirect'=voucher specimen was collected for a different individual, but the original data provider confirmed that this is the same species. 'default'=basically same as 'indirect'. 'uncollected'=no voucher specimen, data provider  asserted that this was the name but was unable to collect. The main different is that with 'direct', 'indirect', and 'default', the scientific name can be updated automatically based on the name attached to the specimen voucher (assuming you have a link to that data, presumably from a herbarium database. Whereas, if det_type='uncollected', the name can never change because there is no specimen."
4 
coll_number,"/location/authorlocationcode/_alt/4/_merge/3/_if[@name=""if indirect voucher""]/else/_alt/1",Brad: Incorrect. Map instead as for voucher_string
5 
voucher_string,"/location/authorlocationcode/_alt/4/_merge/3/_if[@name=""if indirect voucher""]/else/_alt/2","Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."
6 6 
census_date,/location/locationevent/obsstartdate/_*/date/_dateRangeStart/value,"This is for the subplot, not the organism, as all organisms in a subplot have the same value for it. The following query returns no rows:
7 7 
-----
8 8 
SELECT ""PLOT_ID"", subplot, count(DISTINCT census_date) AS census_date_count
inputs/REMIB/test/import.specimens.xml.ref
1 1 
Put template:
2 2 
<VegBIEN>
3 3 
    <location id="-1">
4 
        <authorlocationcode>$acronym</authorlocationcode>
4 
        <authorlocationcode>
5 
            <_alt>
6 
                <3>$accession_number</3>
7 
                <4>$acronym</4>
8 
            </_alt>
9 
        </authorlocationcode>
5 10 
        <locationdetermination>
6 11 
            <latitude>
7 12 
                <_nullIf>
......
210 215 
                </3>
211 216 
            </_merge>
212 217 
        </locationnarrative>
213 
        <sourceaccessioncode>$accession_number</sourceaccessioncode>
214 218 
    </location>
215 219 
</VegBIEN>
216 220 
Inserted 26 new rows into database
inputs/REMIB/maps/VegBIEN.specimens.csv
1 1 
REMIB[DwC],VegBIEN:,Comments
2 
acronym,/location/authorlocationcode/_alt/3/_merge/2/_merge/1,
2 
accession_number,/location/authorlocationcode/_alt/3,
3 
acronym,/location/authorlocationcode/_alt/4/_merge/2/_merge/1,
3 4 
lat_deg,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
4 5 
long_deg,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
5 6 
county,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
......
24 25 
collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
25 26 
locality,/location/locationnarrative/_merge/1,
26 27 
habitat,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?"
27 
accession_number,/location/sourceaccessioncode/_alt/1,
28 28 
lat_min,,** No input mapping for lat_min **
29 29 
lat_sec,,** No input mapping for lat_sec **
30 30 
long_min,,** No input mapping for long_min **
inputs/SALVIAS/test/import.organisms.xml.ref
4 4 
        <authorlocationcode>
5 5 
            <_alt>
6 6 
                <1>$Line</1>
7 
                <3>
7 
                <4>
8 8 
                    <_if name="if indirect voucher">
9 9 
                        <cond>
10 10 
                            <_eq>
......
19 19 
                            </_alt>
20 20 
                        </else>
21 21 
                    </_if>
22 
                </3>
22 
                </4>
23 23 
            </_alt>
24 24 
        </authorlocationcode>
25 25 
        <locationevent>
inputs/SALVIAS/maps/VegBIEN.plots.csv
41 41 
Locality_Description,/location/locationnarrative/_merge/1,"Brad: No; this is free text description of locality where plot was situated, same as for DwC. Not a description of vegetation. Most likely='namedPlace.placeDescription' in VB; not sure about VX, again need to ask Nick where locality descriptions live in VX"
42 42 
slope_aspect,/location/slopeaspect/_compass/value,
43 43 
slope_gradient,/location/slopegradient,
44 
PlotID,/location/sourceaccessioncode/_alt/2,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
44 
PlotID,/location/sourceaccessioncode,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
45 45 
AccessCode,,** No input mapping for AccessCode **
46 46 
ElevSource,,** No input mapping for ElevSource **
47 47 
Habitat,,** No input mapping for Habitat **
inputs/SALVIAS/maps/VegBIEN.organisms.csv
1 1 
SALVIAS,VegBIEN:,Comments
2 2 
Line,/location/authorlocationcode/_alt/1,
3 
DetType,"/location/authorlocationcode/_alt/3/_merge/3/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left","Brad: A SALVIAS value referring to the relationship between the voucher specimen and the observation. Affect how the identification of the specimen(latin name) is transferred to the observation. 'direct'=voucher specimen was collected from this same tree; they are one and the same individual. 'indirect'=voucher specimen was collected for a different individual, but the original data provider confirmed that this is the same species. 'default'=basically same as 'indirect'. 'uncollected'=no voucher specimen, data provider  asserted that this was the name but was unable to collect. The main different is that with 'direct', 'indirect', and 'default', the scientific name can be updated automatically based on the name attached to the specimen voucher (assuming you have a link to that data, presumably from a herbarium database. Whereas, if det_type='uncollected', the name can never change because there is no specimen."
4 
coll_number,"/location/authorlocationcode/_alt/3/_merge/3/_if[@name=""if indirect voucher""]/else/_alt/1",Brad: Incorrect. Map instead as for voucher_string
5 
SourceVoucher,"/location/authorlocationcode/_alt/3/_merge/3/_if[@name=""if indirect voucher""]/else/_alt/2","Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."
3 
DetType,"/location/authorlocationcode/_alt/4/_merge/3/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left","Brad: A SALVIAS value referring to the relationship between the voucher specimen and the observation. Affect how the identification of the specimen(latin name) is transferred to the observation. 'direct'=voucher specimen was collected from this same tree; they are one and the same individual. 'indirect'=voucher specimen was collected for a different individual, but the original data provider confirmed that this is the same species. 'default'=basically same as 'indirect'. 'uncollected'=no voucher specimen, data provider  asserted that this was the name but was unable to collect. The main different is that with 'direct', 'indirect', and 'default', the scientific name can be updated automatically based on the name attached to the specimen voucher (assuming you have a link to that data, presumably from a herbarium database. Whereas, if det_type='uncollected', the name can never change because there is no specimen."
4 
coll_number,"/location/authorlocationcode/_alt/4/_merge/3/_if[@name=""if indirect voucher""]/else/_alt/1",Brad: Incorrect. Map instead as for voucher_string
5 
SourceVoucher,"/location/authorlocationcode/_alt/4/_merge/3/_if[@name=""if indirect voucher""]/else/_alt/2","Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."
6 6 
census_date,/location/locationevent/obsenddate/_*/date/_dateRangeEnd/value/_alt/1,"This is for the subplot, not the organism, as all organisms in a subplot have the same value for it. The following query returns no rows:
7 7 
-----
8 8 
SELECT ""PlotID"", ""Line"", count(DISTINCT census_date) AS census_date_count
inputs/U/test/import.specimens.xml.ref
1 1 
Put template:
2 2 
<VegBIEN>
3 3 
    <location id="-1">
4 
        <authorlocationcode><_if name="if indirect voucher"><else>$Barcode</else></_if></authorlocationcode>
4 
        <authorlocationcode>
5 
            <_alt>
6 
                <3>$ID</3>
7 
                <4><_if name="if indirect voucher"><else>$Barcode</else></_if></4>
8 
            </_alt>
9 
        </authorlocationcode>
5 10 
        <locationdetermination>
6 11 
            <latitude>
7 12 
                <_nullIf>
......
263 268 
                </3>
264 269 
            </_merge>
265 270 
        </locationnarrative>
266 
        <sourceaccessioncode>$ID</sourceaccessioncode>
267 271 
    </location>
268 272 
</VegBIEN>
269 273 
Inserted 26 new rows into database
inputs/U/maps/VegBIEN.specimens.csv
1 1 
U[DwC],VegBIEN:,Comments
2 
Barcode,"/location/authorlocationcode/_alt/3/_merge/3/_if[@name=""if indirect voucher""]/else",
2 
ID,/location/authorlocationcode/_alt/3,
3 
Barcode,"/location/authorlocationcode/_alt/4/_merge/3/_if[@name=""if indirect voucher""]/else",
3 4 
Lat,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",
4 5 
Long,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
5 6 
Country,"/location/locationdetermination/namedplace_id/_simplifyPath:[next=""parent_id/namedplace"",require=placename]/path/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
......
34 35 
Newgazett,"/location/locationnarrative/_merge/2/_merge/1/_label[label=""gazetteer""]/value/_merge/2",Only used in 1 row
35 36 
Locnotes,/location/locationnarrative/_merge/2/_merge/2,
36 37 
Ecology,"/location/locationnarrative/_merge/3/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?"
37 
ID,/location/sourceaccessioncode/_alt/1,
38 38 
Alt,,What is this?
39 39 
Alt2,,What is this?
40 40 
Coorsyst,,** No input mapping for Coorsyst **
inputs/ARIZ/test/import.specimens.xml.ref
2 2 
<VegBIEN>
3 3 
    <location id="-1">
4 4 
        <authorlocationcode>
5 
            <_merge>
6 
                <1>$InstitutionCode</1>
7 
                <2>$CollectionCode</2>
8 
                <3><_if name="if indirect voucher"><else>$CatalogNumberNumeric</else></_if></3>
9 
            </_merge>
5 
            <_alt>
6 
                <3>$GlobalUniqueIdentifier</3>
7 
                <4>
8 
                    <_merge>
9 
                        <1>$InstitutionCode</1>
10 
                        <2>$CollectionCode</2>
11 
                        <3><_if name="if indirect voucher"><else>$CatalogNumberNumeric</else></_if></3>
12 
                    </_merge>
13 
                </4>
14 
            </_alt>
10 15 
        </authorlocationcode>
11 16 
        <elevation>
12 17 
            <_alt>
......
482 487 
            </waterdepth>
483 488 
        </locationevent>
484 489 
        <locationnarrative>$Locality</locationnarrative>
485 
        <sourceaccessioncode>$GlobalUniqueIdentifier</sourceaccessioncode>
486 490 
    </location>
487 491 
</VegBIEN>
488 492 
Inserted 38 new rows into database
inputs/ARIZ/maps/VegBIEN.specimens.csv
1 1 
ARIZ[DwC],VegBIEN:,Comments
2 
InstitutionCode,/location/authorlocationcode/_alt/3/_merge/1,
3 
CollectionCode,/location/authorlocationcode/_alt/3/_merge/2/_merge/1,
4 
CatalogNumberNumeric,"/location/authorlocationcode/_alt/3/_merge/3/_if[@name=""if indirect voucher""]/else",
2 
GlobalUniqueIdentifier,/location/authorlocationcode/_alt/3,
3 
InstitutionCode,/location/authorlocationcode/_alt/4/_merge/1,
4 
CollectionCode,/location/authorlocationcode/_alt/4/_merge/2/_merge/1,
5 
CatalogNumberNumeric,"/location/authorlocationcode/_alt/4/_merge/3/_if[@name=""if indirect voucher""]/else",
5 6 
VerbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",
6 7 
MaximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
7 8 
MinimumElevationInMeters,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
......
68 69 
MaximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
69 70 
MinimumDepthInMeters,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
70 71 
Locality,/location/locationnarrative/_merge/1,
71 
GlobalUniqueIdentifier,/location/sourceaccessioncode/_alt/1,
72 72 
AgeClass,,** No non-empty join mapping for lifeStage **
73 73 
BasisOfRecord,,** No non-empty join mapping for BasisOfRecord **
74 74 
CatalogNumber,,Map to nothing so it doesn't overwrite CatalogNumberNumeric
inputs/GBIF/maps/VegBIEN.specimens.csv
1 1 
GBIF[DwC],VegBIEN:,Comments
2 
InstitutionCD,/location/authorlocationcode/_alt/3/_merge/1,
3 
CollectionCD,/location/authorlocationcode/_alt/3/_merge/2/_merge/1,
4 
CatalogNO,"/location/authorlocationcode/_alt/3/_merge/3/_if[@name=""if indirect voucher""]/else",
2 
InstitutionCD,/location/authorlocationcode/_alt/4/_merge/1,
3 
CollectionCD,/location/authorlocationcode/_alt/4/_merge/2/_merge/1,
4 
CatalogNO,"/location/authorlocationcode/_alt/4/_merge/3/_if[@name=""if indirect voucher""]/else",
5 5 
MaximumElevationInMeter,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
6 6 
MinimumElevationInMeter,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
7 7 
MinimumElevationInMeter,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
inputs/NCU-NCSC/test/import.specimens.xml.ref
2 2 
<VegBIEN>
3 3 
    <location id="-1">
4 4 
        <authorlocationcode>
5 
            <_merge>
6 
                <2>$SeriesName</2>
7 
                <3><_if name="if indirect voucher"><else>$Barcode</else></_if></3>
8 
            </_merge>
5 
            <_alt>
6 
                <3>$Accession Number</3>
7 
                <4>
8 
                    <_merge>
9 
                        <2>$SeriesName</2>
10 
                        <3><_if name="if indirect voucher"><else>$Barcode</else></_if></3>
11 
                    </_merge>
12 
                </4>
13 
            </_alt>
9 14 
        </authorlocationcode>
10 15 
        <elevation>
11 16 
            <_replace>
......
135 140 
                </taxondetermination>
136 141 
            </taxonoccurrence>
137 142 
        </locationevent>
138 
        <sourceaccessioncode>$Accession Number</sourceaccessioncode>
139 143 
    </location>
140 144 
</VegBIEN>
141 145 
Inserted 26 new rows into database
inputs/NCU-NCSC/maps/VegBIEN.specimens.csv
1 1 
NCU-NCSC[DwC],VegBIEN:,Comments
2 
SeriesName,/location/authorlocationcode/_alt/3/_merge/2/_merge/1,
3 
Barcode,"/location/authorlocationcode/_alt/3/_merge/3/_if[@name=""if indirect voucher""]/else",
2 
Accession Number,/location/authorlocationcode/_alt/3,
3 
SeriesName,/location/authorlocationcode/_alt/4/_merge/2/_merge/1,
4 
Barcode,"/location/authorlocationcode/_alt/4/_merge/3/_if[@name=""if indirect voucher""]/else",
4 5 
Elevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",
5 6 
Accuracy,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,
6 7 
Lat (-=S),"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value/_replace:[""\?$""=]/value",
......
20 21 
Accession Number,/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/1,
21 22 
Barcode,"/location/locationevent/taxonoccurrence/sourceaccessioncode/_alt/2/_if[@name=""if indirect voucher""]/else",
22 23 
Full Taxon Name,"/location/locationevent/taxonoccurrence/taxondetermination[role=identifier]:[isoriginal=true]/*_id/plantconcept/plantname_id/_simplifyPath:[next=""parent_id/plantname"",require=plantname]/path/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",
23 
Accession Number,/location/sourceaccessioncode/_alt/1,
24 24 
Alt E/W,,** No input mapping for Alt E/W **
25 25 
Alt N/S,,** No input mapping for Alt N/S **
26 26 
FIPS,,FIPS county code
inputs/SpeciesLink/maps/VegBIEN.specimens.csv
1 1 
"SpeciesLink[DwC,dwc_dwcore_,dwc_curatorial_,dwc_geospatial_,http__purl_org_,dwc_terms_,conceptual_darwin_2003_1_0_]",VegBIEN:,Comments
2 
InstitutionCode,/location/authorlocationcode/_alt/3/_merge/1,
3 
institutionCode,/location/authorlocationcode/_alt/3/_merge/1,
4 
CollectionCode,/location/authorlocationcode/_alt/3/_merge/2/_merge/1,
5 
collectionCode,/location/authorlocationcode/_alt/3/_merge/2/_merge/1,
6 
collectionID,/location/authorlocationcode/_alt/3/_merge/2/_merge/2,
7 
CatalogNumber,"/location/authorlocationcode/_alt/3/_merge/3/_if[@name=""if indirect voucher""]/else",
8 
catalogNumber,"/location/authorlocationcode/_alt/3/_merge/3/_if[@name=""if indirect voucher""]/else",
2 
GlobalUniqueIdentifier,/location/authorlocationcode/_alt/3,
3 
InstitutionCode,/location/authorlocationcode/_alt/4/_merge/1,
4 
institutionCode,/location/authorlocationcode/_alt/4/_merge/1,
5 
CollectionCode,/location/authorlocationcode/_alt/4/_merge/2/_merge/1,
6 
collectionCode,/location/authorlocationcode/_alt/4/_merge/2/_merge/1,
7 
collectionID,/location/authorlocationcode/_alt/4/_merge/2/_merge/2,
8 
CatalogNumber,"/location/authorlocationcode/_alt/4/_merge/3/_if[@name=""if indirect voucher""]/else",
9 
catalogNumber,"/location/authorlocationcode/_alt/4/_merge/3/_if[@name=""if indirect voucher""]/else",
9 10 
MaximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
10 11 
MaximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
11 12 
maximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
......
121 122 
minimumDepthInMeters,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
122 123 
Locality,/location/locationnarrative/_merge/1,
123 124 
locality,/location/locationnarrative/_merge/1,
124 
GlobalUniqueIdentifier,/location/sourceaccessioncode/_alt/1,
125 125 
BasisOfRecord,,** No non-empty join mapping for BasisOfRecord **
126 126 
DateLastModified,,** No non-empty join mapping for DateLastModified **
127 127 
DayOfYear,,** No non-empty join mapping for JulianDay **
inputs/QMOR/test/import.specimens.xml.ref
2 2 
<VegBIEN>
3 3 
    <location id="-1">
4 4 
        <authorlocationcode>
5 
            <_merge>
6 
                <1>$institutionCode</1>
7 
                <2>
5 
            <_alt>
6 
                <3>$id</3>
7 
                <4>
8 8 
                    <_merge>
9 
                        <1>$collectionCode</1>
10 
                        <2>$collectionID</2>
9 
                        <1>$institutionCode</1>
10 
                        <2>
11 
                            <_merge>
12 
                                <1>$collectionCode</1>
13 
                                <2>$collectionID</2>
14 
                            </_merge>
15 
                        </2>
16 
                        <3><_if name="if indirect voucher"><else>$catalogNumber</else></_if></3>
11 17 
                    </_merge>
12 
                </2>
13 
                <3><_if name="if indirect voucher"><else>$catalogNumber</else></_if></3>
14 
            </_merge>
18 
                </4>
19 
            </_alt>
15 20 
        </authorlocationcode>
16 21 
        <elevation>
17 22 
            <_alt>
......
309 314 
                </3>
310 315 
            </_merge>
311 316 
        </locationnarrative>
312 
        <sourceaccessioncode>$id</sourceaccessioncode>
313 317 
    </location>
314 318 
</VegBIEN>
315 319 
Inserted 34 new rows into database
mappings/VegCSV-VegBIEN.specimens.csv
2 2 
plotArea,/location/area,
3 3 
plotName,/location/authorlocationcode/_alt/1,
4 4 
fieldNumber,/location/authorlocationcode/_alt/2,
5 
voucherType,"/location/authorlocationcode/_alt/3/_merge/3/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left",
6 
catalogNumber,"/location/authorlocationcode/_alt/3/_merge/3/_if[@name=""if indirect voucher""]/else",
5 
voucherType,"/location/authorlocationcode/_alt/4/_merge/3/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left",
6 
catalogNumber,"/location/authorlocationcode/_alt/4/_merge/3/_if[@name=""if indirect voucher""]/else",
7 7 
verbatimElevation,"/location/elevation/_alt/1/_replace:[""\bca\.?""=]/value",
8 8 
maximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
9 9 
minimumElevationInMeters,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
......
107 107 
parentLocationID,/location/parent_id/location/sourceaccessioncode,
108 108 
slopeAspect,/location/slopeaspect/_compass/value,
109 109 
slopeGradient,/location/slopegradient,
110 
locationID,/location/sourceaccessioncode/_alt/2,
110 
locationID,/location/sourceaccessioncode,
mappings/for_review/DwC2-VegBIEN.specimens.csv
1 1 
DwC,VegBIEN:,Comments
2 
occurrenceID,//location/authorlocationcode,
2 3 
institutionCode,//location/authorlocationcode,
3 4 
collectionCode,//location/authorlocationcode,
4 5 
collectionID,//location/authorlocationcode,
......
65 66 
locality,//location/locationnarrative,
66 67 
verbatimLocality,//location/locationnarrative,
67 68 
habitat,"//location/locationnarrative/_label[label=""habitat""]/value","Brad: Free-text description of vegetation community where collected, frequently redundane wrt 'Vegetation'. Bob, Nick: keep as user defined or create special element?"
68 
occurrenceID,//location/sourceaccessioncode,
69 69 
locationID,//location/sourceaccessioncode,
70 70 
acceptedNameUsage,,
71 71 
acceptedNameUsageID,,

Also available in: Unified diff