Project

General

Profile

« Previous | Next » 

Revision 6596

Added by Aaron Marcuse-Kubitza about 12 years ago

mappings/VegCore-VegBIEN.csv: Mapped dcterms:rights

View differences:

inputs/VASCAN/Taxon/test.xml.ref
7 7 
                <next>parent_id</next>
8 8 
                <path>
9 9 
                    <location>
10 
                        <accessconditions>$rights</accessconditions>
10 11 
                        <locationevent>
11 12 
                            <taxonoccurrence>
12 13 
                                <taxondetermination>
inputs/TRTE/Specimen/VegBIEN.csv
10 10 
collectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/1",
11 11 
collectionID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/2",
12 12 
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else",
13 
rights,/location/accessconditions,
13 14 
verbatimElevation,"/location/elevation_m/_alt/1/_units:[to=m,to=]/value",
14 15 
id,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
15 16 
recordNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
......
107 108 
occurrenceRemarks,,** No join mapping for occurrenceRemarks **
108 109 
ownerInstitutionCode,,** No join mapping for ownerInstitutionCode **
109 110 
previousIdentifications,,** No join mapping for previousIdentifications **
110 
rights,,** No join mapping for dcterms:rights **
111 111 
rightsHolder,,** No join mapping for dcterms:rightsHolder **
112 112 
type,,** No join mapping for dcterms:type **
113 113 
verbatimCoordinateSystem,,** No join mapping for verbatimCoordinateSystem **
inputs/TRTE/Specimen/unmapped_terms.csv
12 12 
dcterms:modified
13 13 
previousIdentifications
14 14 
datasetName
15 
dcterms:rights
16 15 
ownerInstitutionCode
17 16 
dcterms:rightsHolder
18 17 
datasetID
mappings/for_review/VegCore-VegBIEN.csv
23 23 
locationID,"/location/sourceaccessioncode/_if[@name=""if geovalidation""]/else",
24 24 
locationName,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
25 25 
locationID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
26 
dcterms:rights,//location/accessconditions,
26 27 
dcterms:accessRights,//location/accesslevel,
27 28 
plotArea_m2,//location/area_m2,
28 29 
plotArea_ha,//location/area_m2/_ha_to_m2/value,
inputs/MT/Specimen/VegBIEN.csv
6 6 
institutionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/then",
7 7 
collectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/1",
8 8 
collectionID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/2",
9 
rights,/location/accessconditions,
9 10 
id,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
10 11 
locality,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1,
11 12 
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
......
36 37 
datasetName,,** No join mapping for datasetName **
37 38 
language,,** No join mapping for dcterms:language **
38 39 
occurrenceRemarks,,** No join mapping for occurrenceRemarks **
39 
rights,,** No join mapping for dcterms:rights **
40 40 
rightsHolder,,** No join mapping for dcterms:rightsHolder **
41 41 
type,,** No join mapping for dcterms:type **
inputs/MT/Specimen/test.xml.ref
8 8 
                <path>
9 9 
                    <location>
10 10 
                        <authorlocationcode>$id</authorlocationcode>
11 
                        <accessconditions>$rights</accessconditions>
11 12 
                        <iscultivated><_locationnarrative_is_cultivated><locationnarrative>$locality</locationnarrative></_locationnarrative_is_cultivated></iscultivated>
12 13 
                        <locationevent>
13 14 
                            <taxonoccurrence>
inputs/MT/Specimen/unmapped_terms.csv
1 1 
dcterms:language
2 2 
occurrenceRemarks
3 3 
dcterms:type
4 
dcterms:rights
5 4 
datasetName
6 5 
dcterms:rightsHolder
7 6 
basisOfRecord
inputs/ACAD/Specimen/VegBIEN.csv
10 10 
collectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/1",
11 11 
collectionID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/2",
12 12 
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else",
13 
rights,/location/accessconditions,
13 14 
verbatimElevation,"/location/elevation_m/_alt/1/_units:[to=m,to=]/value",
14 15 
id,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
15 16 
recordNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
......
105 106 
occurrenceRemarks,,** No join mapping for occurrenceRemarks **
106 107 
ownerInstitutionCode,,** No join mapping for ownerInstitutionCode **
107 108 
reproductiveCondition,,** No join mapping for reproductiveCondition **
108 
rights,,** No join mapping for dcterms:rights **
109 109 
rightsHolder,,** No join mapping for dcterms:rightsHolder **
110 110 
type,,** No join mapping for dcterms:type **
111 111 
verbatimDepth,,** No join mapping for verbatimDepth **
inputs/ACAD/Specimen/test.xml.ref
24 24 
                                </2>
25 25 
                            </_alt>
26 26 
                        </authorlocationcode>
27 
                        <accessconditions>$rights</accessconditions>
27 28 
                        <elevation_m>
28 29 
                            <_units>
29 30 
                                <to>m</to>
inputs/ACAD/Specimen/unmapped_terms.csv
11 11 
dcterms:type
12 12 
identificationRemarks
13 13 
dcterms:rightsHolder
14 
dcterms:rights
15 14 
occurrenceRemarks
16 15 
ownerInstitutionCode
17 16 
dcterms:bibliographicCitation
inputs/WIN/Specimen/VegBIEN.csv
10 10 
collectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/1",
11 11 
collectionID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/2",
12 12 
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else",
13 
rights,/location/accessconditions,
13 14 
verbatimElevation,"/location/elevation_m/_alt/1/_units:[to=m,to=]/value",
14 15 
minimumElevationInMeters,/location/elevation_m/_alt/2/_avg/min,
15 16 
id,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
......
99 100 
nomenclaturalCode,,** No join mapping for nomenclaturalCode **
100 101 
occurrenceRemarks,,** No join mapping for occurrenceRemarks **
101 102 
ownerInstitutionCode,,** No join mapping for ownerInstitutionCode **
102 
rights,,** No join mapping for dcterms:rights **
103 103 
rightsHolder,,** No join mapping for dcterms:rightsHolder **
104 104 
type,,** No join mapping for dcterms:type **
105 105 
verbatimCoordinateSystem,,** No join mapping for verbatimCoordinateSystem **
inputs/WIN/Specimen/test.xml.ref
24 24 
                                </2>
25 25 
                            </_alt>
26 26 
                        </authorlocationcode>
27 
                        <accessconditions>$rights</accessconditions>
27 28 
                        <elevation_m>
28 29 
                            <_alt>
29 30 
                                <1>
inputs/WIN/Specimen/unmapped_terms.csv
4 4 
verbatimSRS
5 5 
datasetID
6 6 
dcterms:bibliographicCitation
7 
dcterms:rights
8 7 
occurrenceRemarks
9 8 
dcterms:type
10 9 
verbatimEventDate
inputs/QFA/Specimen/VegBIEN.csv
10 10 
collectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/1",
11 11 
collectionID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/2",
12 12 
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else",
13 
rights,/location/accessconditions,
13 14 
verbatimElevation,"/location/elevation_m/_alt/1/_units:[to=m,to=]/value",
14 15 
id,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
15 16 
recordNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
......
105 106 
occurrenceRemarks,,** No join mapping for occurrenceRemarks **
106 107 
ownerInstitutionCode,,** No join mapping for ownerInstitutionCode **
107 108 
preparations,,** No join mapping for preparations **
108 
rights,,** No join mapping for dcterms:rights **
109 109 
rightsHolder,,** No join mapping for dcterms:rightsHolder **
110 110 
type,,** No join mapping for dcterms:type **
111 111 
typeStatus,,** No join mapping for typeStatus **
inputs/QFA/Specimen/test.xml.ref
24 24 
                                </2>
25 25 
                            </_alt>
26 26 
                        </authorlocationcode>
27 
                        <accessconditions>$rights</accessconditions>
27 28 
                        <elevation_m>
28 29 
                            <_units>
29 30 
                                <to>m</to>
inputs/QFA/Specimen/unmapped_terms.csv
1 
dcterms:rights
2 1 
associatedSequences
3 2 
institutionID
4 3 
datasetName
inputs/JBM/Specimen/VegBIEN.csv
10 10 
collectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/1",
11 11 
collectionID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/2",
12 12 
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else",
13 
rights,/location/accessconditions,
13 14 
minimumElevationInMeters,/location/elevation_m/_alt/2/_avg/min,
14 15 
id,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
15 16 
recordNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
......
83 84 
modified,,** No join mapping for dcterms:modified **
84 85 
nomenclaturalCode,,** No join mapping for nomenclaturalCode **
85 86 
ownerInstitutionCode,,** No join mapping for ownerInstitutionCode **
86 
rights,,** No join mapping for dcterms:rights **
87 87 
rightsHolder,,** No join mapping for dcterms:rightsHolder **
88 88 
type,,** No join mapping for dcterms:type **
inputs/JBM/Specimen/test.xml.ref
24 24 
                                </2>
25 25 
                            </_alt>
26 26 
                        </authorlocationcode>
27 
                        <accessconditions>$rights</accessconditions>
27 28 
                        <elevation_m><_avg><min>$minimumElevationInMeters</min></_avg></elevation_m>
28 29 
                        <iscultivated>
29 30 
                            <_locationnarrative_is_cultivated>
......
280 281 
        </path>
281 282 
    </_setDefault>
282 283 
</VegBIEN>
283 
Inserted 38 new rows into database
284 
Inserted 37 new rows into database
inputs/JBM/Specimen/unmapped_terms.csv
7 7 
nomenclaturalCode
8 8 
dynamicProperties
9 9 
datasetName
10 
dcterms:rights
11 10 
dcterms:type
12 11 
datasetID
13 12 
countryCode
inputs/UBC/Specimen/VegBIEN.csv
10 10 
collectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/1",
11 11 
collectionID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/2",
12 12 
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else",
13 
rights,/location/accessconditions,
13 14 
verbatimElevation,"/location/elevation_m/_alt/1/_units:[to=m,to=]/value",
14 15 
id,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
15 16 
recordNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
......
112 113 
preparations,,** No join mapping for preparations **
113 114 
previousIdentifications,,** No join mapping for previousIdentifications **
114 115 
references,,** No join mapping for dcterms:references **
115 
rights,,** No join mapping for dcterms:rights **
116 116 
rightsHolder,,** No join mapping for dcterms:rightsHolder **
117 117 
type,,** No join mapping for dcterms:type **
118 118 
typeStatus,,** No join mapping for typeStatus **
inputs/UBC/Specimen/test.xml.ref
24 24 
                                </2>
25 25 
                            </_alt>
26 26 
                        </authorlocationcode>
27 
                        <accessconditions>$rights</accessconditions>
27 28 
                        <elevation_m>
28 29 
                            <_units>
29 30 
                                <to>m</to>
inputs/UBC/Specimen/unmapped_terms.csv
2 2 
nomenclaturalCode
3 3 
occurrenceRemarks
4 4 
dcterms:rightsHolder
5 
dcterms:rights
6 5 
preparations
7 6 
geodeticDatum
8 7 
associatedReferences
inputs/HIBG/Specimen/VegBIEN.csv
10 10 
collectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/1",
11 11 
collectionID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/2",
12 12 
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else",
13 
rights,/location/accessconditions,
13 14 
verbatimElevation,"/location/elevation_m/_alt/1/_units:[to=m,to=]/value",
14 15 
id,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
15 16 
recordNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
......
113 114 
ownerInstitutionCode,,** No join mapping for ownerInstitutionCode **
114 115 
references,,** No join mapping for dcterms:references **
115 116 
reproductiveCondition,,** No join mapping for reproductiveCondition **
116 
rights,,** No join mapping for dcterms:rights **
117 117 
rightsHolder,,** No join mapping for dcterms:rightsHolder **
118 118 
type,,** No join mapping for dcterms:type **
119 119 
verbatimCoordinateSystem,,** No join mapping for verbatimCoordinateSystem **
inputs/HIBG/Specimen/test.xml.ref
24 24 
                                </2>
25 25 
                            </_alt>
26 26 
                        </authorlocationcode>
27 
                        <accessconditions>$rights</accessconditions>
27 28 
                        <elevation_m>
28 29 
                            <_units>
29 30 
                                <to>m</to>
inputs/HIBG/Specimen/unmapped_terms.csv
17 17 
associatedMedia
18 18 
nomenclaturalCode
19 19 
waterBody
20 
dcterms:rights
21 20 
dcterms:modified
22 21 
identificationRemarks
23 22 
georeferenceVerificationStatus
inputs/TRT/Specimen/VegBIEN.csv
10 10 
collectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/1",
11 11 
collectionID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/2",
12 12 
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else",
13 
rights,/location/accessconditions,
13 14 
verbatimElevation,"/location/elevation_m/_alt/1/_units:[to=m,to=]/value",
14 15 
maximumElevationInMeters,/location/elevation_m/_alt/2/_avg/max,
15 16 
minimumElevationInMeters,/location/elevation_m/_alt/2/_avg/min,
......
122 123 
ownerInstitutionCode,,** No join mapping for ownerInstitutionCode **
123 124 
previousIdentifications,,** No join mapping for previousIdentifications **
124 125 
reproductiveCondition,,** No join mapping for reproductiveCondition **
125 
rights,,** No join mapping for dcterms:rights **
126 126 
rightsHolder,,** No join mapping for dcterms:rightsHolder **
127 127 
type,,** No join mapping for dcterms:type **
128 128 
typeStatus,,** No join mapping for typeStatus **
inputs/TRT/Specimen/test.xml.ref
24 24 
                                </2>
25 25 
                            </_alt>
26 26 
                        </authorlocationcode>
27 
                        <accessconditions>$rights</accessconditions>
27 28 
                        <elevation_m>
28 29 
                            <_alt>
29 30 
                                <1>
inputs/TRT/Specimen/unmapped_terms.csv
5 5 
georeferenceProtocol
6 6 
dcterms:type
7 7 
institutionID
8 
dcterms:rights
9 8 
dcterms:rightsHolder
10 9 
georeferencedBy
11 10 
georeferenceRemarks
inputs/VASCAN/Taxon/VegBIEN.csv
1 1 
VASCAN,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments
2 
rights,/location/accessconditions,
2 3 
scientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/2",
3 4 
scientificName,"/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/null/_first/2",
4 5 
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",
......
53 54 
parentNameUsage,,** No join mapping for parentNameUsage **
54 55 
parentNameUsageID,,** No join mapping for parentNameUsageID **
55 56 
references,,** No join mapping for dcterms:references **
56 
rights,,** No join mapping for dcterms:rights **
57 57 
rightsHolder,,** No join mapping for dcterms:rightsHolder **
58 58 
subgenus,,** No join mapping for subgenus **
inputs/VASCAN/Taxon/unmapped_terms.csv
7 7 
dcterms:bibliographicCitation
8 8 
dcterms:language
9 9 
acceptedNameUsageID
10 
dcterms:rights
11 10 
datasetName
12 11 
parentNameUsage
13 12 
parentNameUsageID
inputs/TRTE/Specimen/test.xml.ref
24 24 
                                </2>
25 25 
                            </_alt>
26 26 
                        </authorlocationcode>
27 
                        <accessconditions>$rights</accessconditions>
27 28 
                        <elevation_m>
28 29 
                            <_units>
29 30 
                                <to>m</to>
mappings/VegCore-VegBIEN.csv
23 23 
locationID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode/_if[@name=""if geovalidation""]/else",
24 24 
locationName,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
25 25 
locationID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
26 
dcterms:rights,/location/accessconditions,
26 27 
dcterms:accessRights,/location/accesslevel,
27 28 
plotArea_m2,/location/area_m2,
28 29 
plotArea_ha,/location/area_m2/_ha_to_m2/value,

Also available in: Unified diff