Project

General

Profile

« Previous | Next » 

Revision 10432

Added by Aaron Marcuse-Kubitza about 11 years ago

inputs/SpeciesLink/Specimen/map.csv: remapped identical _alt-ed fields to DUPLICATE. this avoids the need to translate these to postprocessing derived columns for new-style import, and also speeds up column-based import because there are less automatic _alts to perform to resolve filter-less collisions.

View differences:

inputs/SpeciesLink/Specimen/map.csv
6 6 
dwc_dwcore_InstitutionCode,specimenHolderInstitutions,,
7 7 
dwc_dwcore_CollectionCode,collection,,
8 8 
dwc_dwcore_CatalogNumber,accessionNumber,,
9 
dwc_dwcore_Remarks,occurrenceRemarks,/_alt/3,
9 
dwc_dwcore_Remarks,DUPLICATE#of:dwc_terms_occurrenceRemarks#dwc_dwcore_Remarks,,exact duplicate
10 10 
dwc_dwcore_ScientificName,taxonName,,
11 11 
dwc_dwcore_Kingdom,kingdom,,
12 12 
dwc_dwcore_Phylum,phylum,,
......
16 16 
dwc_dwcore_Genus,genus,,
17 17 
dwc_dwcore_SpecificEpithet,specificEpithet,,
18 18 
dwc_dwcore_InfraspecificEpithet,infraspecificEpithet,,
19 
dwc_dwcore_AuthorYearOfScientificName,scientificNameAuthorship,/_alt/3,
19 
dwc_dwcore_AuthorYearOfScientificName,DUPLICATE#of:dwc_terms_scientificNameAuthorship#dwc_dwcore_AuthorYearOfScientificName,,exact duplicate
20 20 
dwc_dwcore_Continent,continent,,
21 21 
dwc_dwcore_Country,country,,
22 22 
dwc_dwcore_StateProvince,stateProvince,,
......
30 30 
dwc_dwcore_Collector,recordedBy,,
31 31 
dwc_dwcore_Sex,sex,,
32 32 
dwc_curatorial_IdentifiedBy,identifiedBy,,
33 
dwc_curatorial_CollectorNumber,collectorNumber,/_alt/1,"identical to recordNumber because the following query returns no rows: SELECT * FROM ""SpeciesLink"".""Specimen"" WHERE NOT ""dwc_curatorial_CollectorNumber"" IS NOT DISTINCT FROM ""dwc_terms_recordNumber"""
34 
dwc_curatorial_FieldNumber,collectorNumber,/_alt/2,"Usage inconsistent with DwC definition. This field instead means the same thing as recordNumber, and values are stored under either of the two terms."
33 
dwc_curatorial_CollectorNumber,DUPLICATE#of:dwc_terms_recordNumber#dwc_curatorial_CollectorNumber,,exact duplicate
34 
dwc_curatorial_FieldNumber,DUPLICATE#of:dwc_terms_fieldNumber#dwc_curatorial_FieldNumber,,exact duplicate
35 35 
dwc_curatorial_TypeStatus,typeStatus,,
36 36 
dwc_curatorial_IndividualCount,individualCount,,
37 37 
dwc_geospatial_DecimalLatitude,decimalLatitude,,
......
47 47 
dwc_terms_dateIdentified,dateIdentified,,
48 48 
dwc_terms_typeStatus,typeStatus,,
49 49 
dwc_terms_catalogNumber,accessionNumber,,
50 
dwc_terms_occurrenceRemarks,occurrenceRemarks,/_alt/1,
50 
dwc_terms_occurrenceRemarks,occurrenceRemarks,,
51 51 
dwc_terms_recordNumber,collectorNumber,/_alt/1,
52 52 
dwc_terms_recordedBy,recordedBy,,
53 53 
dwc_terms_individualCount,individualCount,,
......
74 74 
dwc_terms_verbatimLongitude,verbatimLongitude,,
75 75 
dwc_terms_decimalLatitude,decimalLatitude,,
76 76 
dwc_terms_decimalLongitude,decimalLongitude,,
77 
dwc_terms_coordinateUncertaintyInMeters,coordinateUncertaintyInMeters,/_alt/1,
77 
dwc_terms_coordinateUncertaintyInMeters,coordinateUncertaintyInMeters,,
78 78 
dwc_terms_scientificName,taxonName,,
79 79 
dwc_terms_kingdom,kingdom,,
80 80 
dwc_terms_phylum,phylum,,
......
84 84 
dwc_terms_genus,genus,,
85 85 
dwc_terms_specificEpithet,specificEpithet,,
86 86 
dwc_terms_infraspecificEpithet,infraspecificEpithet,,
87 
dwc_terms_scientificNameAuthorship,scientificNameAuthorship,/_alt/1,
87 
dwc_terms_scientificNameAuthorship,scientificNameAuthorship,,
88 88 
conceptual_darwin_2003_1_0_DateLastModified,modified,,
89 89 
conceptual_darwin_2003_1_0_InstitutionCode,specimenHolderInstitutions,,
90 90 
conceptual_darwin_2003_1_0_CollectionCode,collection,,
......
99 99 
conceptual_darwin_2003_1_0_Genus,genus,,
100 100 
conceptual_darwin_2003_1_0_Species,specificEpithet,,
101 101 
conceptual_darwin_2003_1_0_Subspecies,subspecies,,
102 
conceptual_darwin_2003_1_0_ScientificNameAuthor,scientificNameAuthorship,/_alt/2,
102 
conceptual_darwin_2003_1_0_ScientificNameAuthor,DUPLICATE#of:dwc_terms_scientificNameAuthorship#conceptual_darwin_2003_1_0_ScientificNameAuthor,,exact duplicate
103 103 
conceptual_darwin_2003_1_0_IdentifiedBy,identifiedBy,,
104 104 
conceptual_darwin_2003_1_0_YearIdentified,yearIdentified,,
105 105 
conceptual_darwin_2003_1_0_MonthIdentified,monthIdentified,,
106 106 
conceptual_darwin_2003_1_0_DayIdentified,dayIdentified,,
107 107 
conceptual_darwin_2003_1_0_TypeStatus,typeStatus,,
108 
conceptual_darwin_2003_1_0_CollectorNumber,collectorNumber,/_alt/1,"identical to recordNumber because the following query returns no rows: SELECT * FROM ""SpeciesLink"".""Specimen"" WHERE NOT ""conceptual_darwin_2003_1_0_CollectorNumber"" IS NOT DISTINCT FROM ""dwc_terms_recordNumber"""
109 
conceptual_darwin_2003_1_0_FieldNumber,collectorNumber,/_alt/2,"Usage inconsistent with DwC definition. This field instead means the same thing as recordNumber, and values are stored under either of the two terms."
108 
conceptual_darwin_2003_1_0_CollectorNumber,DUPLICATE#of:dwc_terms_recordNumber#conceptual_darwin_2003_1_0_CollectorNumber,,exact duplicate
109 
conceptual_darwin_2003_1_0_FieldNumber,DUPLICATE#of:dwc_terms_fieldNumber#conceptual_darwin_2003_1_0_FieldNumber,,exact duplicate
110 110 
conceptual_darwin_2003_1_0_Collector,recordedBy,,
111 111 
conceptual_darwin_2003_1_0_YearCollected,yearCollected,,
112 112 
conceptual_darwin_2003_1_0_MonthCollected,monthCollected,,
......
120 120 
conceptual_darwin_2003_1_0_Locality,locality,,
121 121 
conceptual_darwin_2003_1_0_Longitude,decimalLongitude,,
122 122 
conceptual_darwin_2003_1_0_Latitude,decimalLatitude,,
123 
conceptual_darwin_2003_1_0_CoordinatePrecision,coordinateUncertaintyInMeters,/_alt/2,Assuming units based on the range and precision of values
123 
conceptual_darwin_2003_1_0_CoordinatePrecision,DUPLICATE#of:dwc_terms_coordinateUncertaintyInMeters#conceptual_darwin_2003_1_0_CoordinatePrecision,,exact duplicate
124 124 
conceptual_darwin_2003_1_0_BoundingBox,footprintWKT,,
125 125 
conceptual_darwin_2003_1_0_MinimumElevation,minimumElevationInMeters,,
126 126 
conceptual_darwin_2003_1_0_MaximumElevation,maximumElevationInMeters,,
......
132 132 
conceptual_darwin_2003_1_0_PreviousCatalogNumber,otherCatalogNumbers,,
133 133 
conceptual_darwin_2003_1_0_RelationshipType,relationshipOfResource,,
134 134 
conceptual_darwin_2003_1_0_RelatedCatalogItem,relatedResourceID,,
135 
conceptual_darwin_2003_1_0_Notes,occurrenceRemarks,/_alt/2,
135 
conceptual_darwin_2003_1_0_Notes,DUPLICATE#of:dwc_terms_occurrenceRemarks#conceptual_darwin_2003_1_0_Notes,,exact duplicate
inputs/SpeciesLink/Specimen/VegBIEN.csv
31 31 
dwc_dwcore_MaximumElevationInMeters,/location/elevation_m/_alt/2/_avg/2,
32 32 
dwc_terms_maximumElevationInMeters,/location/elevation_m/_alt/2/_avg/2,
33 33 
dwc_dwcore_GlobalUniqueIdentifier,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
34 
conceptual_darwin_2003_1_0_CollectorNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/1","identical to recordNumber because the following query returns no rows: SELECT * FROM ""SpeciesLink"".""Specimen"" WHERE NOT ""conceptual_darwin_2003_1_0_CollectorNumber"" IS NOT DISTINCT FROM ""dwc_terms_recordNumber"""
35 
dwc_curatorial_CollectorNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/1","identical to recordNumber because the following query returns no rows: SELECT * FROM ""SpeciesLink"".""Specimen"" WHERE NOT ""dwc_curatorial_CollectorNumber"" IS NOT DISTINCT FROM ""dwc_terms_recordNumber"""
36 34 
dwc_terms_recordNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/1",
37 
conceptual_darwin_2003_1_0_FieldNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/2","Usage inconsistent with DwC definition. This field instead means the same thing as recordNumber, and values are stored under either of the two terms."
38 
dwc_curatorial_FieldNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/2","Usage inconsistent with DwC definition. This field instead means the same thing as recordNumber, and values are stored under either of the two terms."
39 35 
dwc_terms_fieldNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/2","Usage inconsistent with DwC definition. This field instead means the same thing as recordNumber, and values are stored under either of the two terms."
40 36 
conceptual_darwin_2003_1_0_Locality,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1,
41 37 
dwc_dwcore_Locality,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1,
......
53 49 
conceptual_darwin_2003_1_0_IndividualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
54 50 
dwc_curatorial_IndividualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
55 51 
dwc_terms_individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
56 
dwc_terms_occurrenceRemarks,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/1/_alt/1,
57 
conceptual_darwin_2003_1_0_Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/1/_alt/2,
58 
dwc_dwcore_Remarks,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/1/_alt/3,
59 
conceptual_darwin_2003_1_0_CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2/_alt/1,"identical to recordNumber because the following query returns no rows: SELECT * FROM ""SpeciesLink"".""Specimen"" WHERE NOT ""conceptual_darwin_2003_1_0_CollectorNumber"" IS NOT DISTINCT FROM ""dwc_terms_recordNumber"""
60 
dwc_curatorial_CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2/_alt/1,"identical to recordNumber because the following query returns no rows: SELECT * FROM ""SpeciesLink"".""Specimen"" WHERE NOT ""dwc_curatorial_CollectorNumber"" IS NOT DISTINCT FROM ""dwc_terms_recordNumber"""
52 
dwc_terms_occurrenceRemarks,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/1,
61 53 
dwc_terms_recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2/_alt/1,
62 
conceptual_darwin_2003_1_0_FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2/_alt/2,"Usage inconsistent with DwC definition. This field instead means the same thing as recordNumber, and values are stored under either of the two terms."
63 
dwc_curatorial_FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2/_alt/2,"Usage inconsistent with DwC definition. This field instead means the same thing as recordNumber, and values are stored under either of the two terms."
64 54 
dwc_terms_fieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2/_alt/2,"Usage inconsistent with DwC definition. This field instead means the same thing as recordNumber, and values are stored under either of the two terms."
65 55 
conceptual_darwin_2003_1_0_Sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections"
66 56 
dwc_dwcore_Sex,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]:[@fkey=tablerecord_id]/definedvalue","Brad: OMIT. Apparently not used by this institution and of uncertain applicability to plants. With other collections, *sometimes* used for phenological information (if specimen in flower, in fruit, sterile, etc.). If so, this is important information we should keep. Bob, Nick, anywhere for phenological information in VB and VX?; Aaron: Keeping it because it's useful for some collections"
......
72 62 
dwc_dwcore_CollectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_alt/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name
73 63 
dwc_terms_collectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_alt/1,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name
74 64 
dwc_terms_collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_alt/2,
75 
conceptual_darwin_2003_1_0_CollectorNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else/_alt/1","identical to recordNumber because the following query returns no rows: SELECT * FROM ""SpeciesLink"".""Specimen"" WHERE NOT ""conceptual_darwin_2003_1_0_CollectorNumber"" IS NOT DISTINCT FROM ""dwc_terms_recordNumber"""
76 
dwc_curatorial_CollectorNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else/_alt/1","identical to recordNumber because the following query returns no rows: SELECT * FROM ""SpeciesLink"".""Specimen"" WHERE NOT ""dwc_curatorial_CollectorNumber"" IS NOT DISTINCT FROM ""dwc_terms_recordNumber"""
77 65 
dwc_terms_recordNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else/_alt/1",
78 
conceptual_darwin_2003_1_0_FieldNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else/_alt/2","Usage inconsistent with DwC definition. This field instead means the same thing as recordNumber, and values are stored under either of the two terms."
79 
dwc_curatorial_FieldNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else/_alt/2","Usage inconsistent with DwC definition. This field instead means the same thing as recordNumber, and values are stored under either of the two terms."
80 66 
dwc_terms_fieldNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else/_alt/2","Usage inconsistent with DwC definition. This field instead means the same thing as recordNumber, and values are stored under either of the two terms."
81 67 
conceptual_darwin_2003_1_0_CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
82 68 
dwc_dwcore_CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
......
89 75 
dwc_dwcore_InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_first/2/_split:[separator=""[,;] *""]/value",
90 76 
dwc_terms_institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_first/2/_split:[separator=""[,;] *""]/value",
91 77 
dwc_dwcore_GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
92 
conceptual_darwin_2003_1_0_CollectorNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3/_alt/1","identical to recordNumber because the following query returns no rows: SELECT * FROM ""SpeciesLink"".""Specimen"" WHERE NOT ""conceptual_darwin_2003_1_0_CollectorNumber"" IS NOT DISTINCT FROM ""dwc_terms_recordNumber"""
93 
dwc_curatorial_CollectorNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3/_alt/1","identical to recordNumber because the following query returns no rows: SELECT * FROM ""SpeciesLink"".""Specimen"" WHERE NOT ""dwc_curatorial_CollectorNumber"" IS NOT DISTINCT FROM ""dwc_terms_recordNumber"""
94 78 
dwc_terms_recordNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3/_alt/1",
95 
conceptual_darwin_2003_1_0_FieldNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3/_alt/2","Usage inconsistent with DwC definition. This field instead means the same thing as recordNumber, and values are stored under either of the two terms."
96 
dwc_curatorial_FieldNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3/_alt/2","Usage inconsistent with DwC definition. This field instead means the same thing as recordNumber, and values are stored under either of the two terms."
97 79 
dwc_terms_fieldNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3/_alt/2","Usage inconsistent with DwC definition. This field instead means the same thing as recordNumber, and values are stored under either of the two terms."
98 80 
conceptual_darwin_2003_1_0_ScientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/3",
99 81 
dwc_dwcore_ScientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/3",
......
102 84 
dwc_dwcore_Collector,/location/locationevent/taxonoccurrence/collector_id/party/fullname,
103 85 
dwc_terms_recordedBy,/location/locationevent/taxonoccurrence/collector_id/party/fullname,
104 86 
dwc_dwcore_GlobalUniqueIdentifier,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
105 
conceptual_darwin_2003_1_0_CollectorNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/1","identical to recordNumber because the following query returns no rows: SELECT * FROM ""SpeciesLink"".""Specimen"" WHERE NOT ""conceptual_darwin_2003_1_0_CollectorNumber"" IS NOT DISTINCT FROM ""dwc_terms_recordNumber"""
106 
dwc_curatorial_CollectorNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/1","identical to recordNumber because the following query returns no rows: SELECT * FROM ""SpeciesLink"".""Specimen"" WHERE NOT ""dwc_curatorial_CollectorNumber"" IS NOT DISTINCT FROM ""dwc_terms_recordNumber"""
107 87 
dwc_terms_recordNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/1",
108 
conceptual_darwin_2003_1_0_FieldNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/2","Usage inconsistent with DwC definition. This field instead means the same thing as recordNumber, and values are stored under either of the two terms."
109 
dwc_curatorial_FieldNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/2","Usage inconsistent with DwC definition. This field instead means the same thing as recordNumber, and values are stored under either of the two terms."
110 88 
dwc_terms_fieldNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/2","Usage inconsistent with DwC definition. This field instead means the same thing as recordNumber, and values are stored under either of the two terms."
111 89 
dwc_dwcore_GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,
112 90 
conceptual_darwin_2003_1_0_IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname,
......
153 131 
dwc_terms_infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/1/_if[@name=""if has infraspecificEpithet""]/cond",
154 132 
dwc_dwcore_InfraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
155 133 
dwc_terms_infraspecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/1/_alt/2/_join_words/5/_join_words/2,
156 
dwc_terms_scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/2/_alt/1,
157 
conceptual_darwin_2003_1_0_ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/2/_alt/2,
158 
dwc_dwcore_AuthorYearOfScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/2/_alt/3,
159 
dwc_terms_scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/author/_alt/1,
160 
conceptual_darwin_2003_1_0_ScientificNameAuthor,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/author/_alt/2,
161 
dwc_dwcore_AuthorYearOfScientificName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/author/_alt/3,
134 
dwc_terms_scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/taxonomicname/_merge_prefix/value/_alt/2/_join_words/2,
135 
dwc_terms_scientificNameAuthorship,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/author,
162 136 
conceptual_darwin_2003_1_0_Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/family,
163 137 
dwc_dwcore_Family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/family,
164 138 
dwc_terms_family,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/family,
......
178 152 
conceptual_darwin_2003_1_0_CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
179 153 
dwc_dwcore_CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
180 154 
dwc_terms_catalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
181 
conceptual_darwin_2003_1_0_CollectorNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then/_alt/1","identical to recordNumber because the following query returns no rows: SELECT * FROM ""SpeciesLink"".""Specimen"" WHERE NOT ""conceptual_darwin_2003_1_0_CollectorNumber"" IS NOT DISTINCT FROM ""dwc_terms_recordNumber"""
182 
dwc_curatorial_CollectorNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then/_alt/1","identical to recordNumber because the following query returns no rows: SELECT * FROM ""SpeciesLink"".""Specimen"" WHERE NOT ""dwc_curatorial_CollectorNumber"" IS NOT DISTINCT FROM ""dwc_terms_recordNumber"""
183 155 
dwc_terms_recordNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then/_alt/1",
184 
conceptual_darwin_2003_1_0_FieldNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then/_alt/2","Usage inconsistent with DwC definition. This field instead means the same thing as recordNumber, and values are stored under either of the two terms."
185 
dwc_curatorial_FieldNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then/_alt/2","Usage inconsistent with DwC definition. This field instead means the same thing as recordNumber, and values are stored under either of the two terms."
186 156 
dwc_terms_fieldNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then/_alt/2","Usage inconsistent with DwC definition. This field instead means the same thing as recordNumber, and values are stored under either of the two terms."
187 157 
conceptual_darwin_2003_1_0_MinimumDepth,/location/locationevent/waterdepth_m/_avg/1,
188 158 
dwc_dwcore_MinimumDepthInMeters,/location/locationevent/waterdepth_m/_avg/1,
......
193 163 
conceptual_darwin_2003_1_0_Locality,/location/locationnarrative/_merge/1,
194 164 
dwc_dwcore_Locality,/location/locationnarrative/_merge/1,
195 165 
dwc_terms_locality,/location/locationnarrative/_merge/1,
196 
dwc_terms_coordinateUncertaintyInMeters,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_m/_noCV/value/_alt/1,
197 
conceptual_darwin_2003_1_0_CoordinatePrecision,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_m/_noCV/value/_alt/2,Assuming units based on the range and precision of values
166 
dwc_terms_coordinateUncertaintyInMeters,/location/locationplace/*_id/place/*_id/coordinates/coordsaccuracy_m/_noCV/value,
198 167 
conceptual_darwin_2003_1_0_BoundingBox,/location/locationplace/*_id/place/*_id/coordinates/footprintgeometry_dwc,
199 168 
conceptual_darwin_2003_1_0_Latitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
200 169 
dwc_geospatial_DecimalLatitude,"/location/locationplace/*_id/place/*_id/coordinates/latitude_deg/_nullIf:[null=0,type=float]/value",
......
234 203 
dwc_dwcore_StateProvince,/location/locationplace/*_id/place/stateprovince,
235 204 
dwc_terms_stateProvince,/location/locationplace/*_id/place/stateprovince,
236 205 
conceptual_darwin_2003_1_0_BasisOfRecord,,** No join mapping for basisOfRecord **
206 
conceptual_darwin_2003_1_0_CollectorNumber,,** No non-empty join mapping for DUPLICATE#of:dwc_terms_recordNumber#conceptual_darwin_2003_1_0_CollectorNumber ** exact duplicate
207 
conceptual_darwin_2003_1_0_CoordinatePrecision,,** No non-empty join mapping for DUPLICATE#of:dwc_terms_coordinateUncertaintyInMeters#conceptual_darwin_2003_1_0_CoordinatePrecision ** exact duplicate
237 208 
conceptual_darwin_2003_1_0_DateLastModified,,** No join mapping for modified **
209 
conceptual_darwin_2003_1_0_FieldNumber,,** No non-empty join mapping for DUPLICATE#of:dwc_terms_fieldNumber#conceptual_darwin_2003_1_0_FieldNumber ** exact duplicate
238 210 
conceptual_darwin_2003_1_0_JulianDay,,** No non-empty join mapping for UNUSED#conceptual_darwin_2003_1_0_JulianDay **
211 
conceptual_darwin_2003_1_0_Notes,,** No non-empty join mapping for DUPLICATE#of:dwc_terms_occurrenceRemarks#conceptual_darwin_2003_1_0_Notes ** exact duplicate
239 212 
conceptual_darwin_2003_1_0_PreparationType,,** No join mapping for preparations **
240 213 
conceptual_darwin_2003_1_0_PreviousCatalogNumber,,** No join mapping for otherCatalogNumbers **
241 214 
conceptual_darwin_2003_1_0_RelatedCatalogItem,,** No join mapping for relatedResourceID **
242 215 
conceptual_darwin_2003_1_0_RelationshipType,,** No join mapping for relationshipOfResource **
216 
conceptual_darwin_2003_1_0_ScientificNameAuthor,,** No non-empty join mapping for DUPLICATE#of:dwc_terms_scientificNameAuthorship#conceptual_darwin_2003_1_0_ScientificNameAuthor ** exact duplicate
243 217 
conceptual_darwin_2003_1_0_TimeOfDay,,** No join mapping for eventTime **
244 218 
conceptual_darwin_2003_1_0_TypeStatus,,** No join mapping for typeStatus **
219 
dwc_curatorial_CollectorNumber,,** No non-empty join mapping for DUPLICATE#of:dwc_terms_recordNumber#dwc_curatorial_CollectorNumber ** exact duplicate
220 
dwc_curatorial_FieldNumber,,** No non-empty join mapping for DUPLICATE#of:dwc_terms_fieldNumber#dwc_curatorial_FieldNumber ** exact duplicate
245 221 
dwc_curatorial_TypeStatus,,** No join mapping for typeStatus **
222 
dwc_dwcore_AuthorYearOfScientificName,,** No non-empty join mapping for DUPLICATE#of:dwc_terms_scientificNameAuthorship#dwc_dwcore_AuthorYearOfScientificName ** exact duplicate
246 223 
dwc_dwcore_BasisOfRecord,,** No join mapping for basisOfRecord **
247 224 
dwc_dwcore_DateLastModified,,** No join mapping for modified **
248 225 
dwc_dwcore_DayOfYear,,** No non-empty join mapping for UNUSED#dwc_dwcore_DayOfYear **
226 
dwc_dwcore_Remarks,,** No non-empty join mapping for DUPLICATE#of:dwc_terms_occurrenceRemarks#dwc_dwcore_Remarks ** exact duplicate
249 227 
dwc_terms_basisOfRecord,,** No join mapping for basisOfRecord **
250 228 
dwc_terms_endDayOfYear,,** No non-empty join mapping for UNUSED#dwc_terms_endDayOfYear **
251 229 
dwc_terms_eventTime,,** No join mapping for eventTime **
inputs/SpeciesLink/Specimen/test.xml.ref
121 121 
                                            <2>$dwc_terms_individualCount</2>
122 122 
                                        </_alt>
123 123 
                                    </count>
124 
                                    <notes>
125 
                                        <_alt>
126 
                                            <1>$dwc_terms_occurrenceRemarks</1>
127 
                                            <2>$conceptual_darwin_2003_1_0_Notes</2>
128 
                                            <3>$dwc_dwcore_Remarks</3>
129 
                                        </_alt>
130 
                                    </notes>
124 
                                    <notes>$dwc_terms_occurrenceRemarks</notes>
131 125 
                                    <plantobservation>
132 126 
                                        <authorplantcode>
133 127 
                                            <_alt>
134 
                                                <1>
135 
                                                    <_alt>
136 
                                                        <0>$conceptual_darwin_2003_1_0_CollectorNumber</0>
137 
                                                        <1>$dwc_curatorial_CollectorNumber</1>
138 
                                                        <2>$dwc_terms_recordNumber</2>
139 
                                                    </_alt>
140 
                                                </1>
141 
                                                <2>
142 
                                                    <_alt>
143 
                                                        <0>$conceptual_darwin_2003_1_0_FieldNumber</0>
144 
                                                        <1>$dwc_curatorial_FieldNumber</1>
145 
                                                        <2>$dwc_terms_fieldNumber</2>
146 
                                                    </_alt>
147 
                                                </2>
128 
                                                <1>$dwc_terms_recordNumber</1>
129 
                                                <2>$dwc_terms_fieldNumber</2>
148 130 
                                            </_alt>
149 131 
                                        </authorplantcode>
150 132 
                                        <definedvalue fkey="tablerecord_id">
......
184 166 
                                            </collectioncode_dwc>
185 167 
                                            <collectionnumber>
186 168 
                                                <_alt>
187 
                                                    <1>
188 
                                                        <_alt>
189 
                                                            <0>$conceptual_darwin_2003_1_0_CollectorNumber</0>
190 
                                                            <1>$dwc_curatorial_CollectorNumber</1>
191 
                                                            <2>$dwc_terms_recordNumber</2>
192 
                                                        </_alt>
193 
                                                    </1>
194 
                                                    <2>
195 
                                                        <_alt>
196 
                                                            <0>$conceptual_darwin_2003_1_0_FieldNumber</0>
197 
                                                            <1>$dwc_curatorial_FieldNumber</1>
198 
                                                            <2>$dwc_terms_fieldNumber</2>
199 
                                                        </_alt>
200 
                                                    </2>
169 
                                                    <1>$dwc_terms_recordNumber</1>
170 
                                                    <2>$dwc_terms_fieldNumber</2>
201 171 
                                                </_alt>
202 172 
                                            </collectionnumber>
203 173 
                                            <institution_id>
......
427 397 
                                                                            </2>
428 398 
                                                                        </_alt>
429 399 
                                                                    </1>
430 
                                                                    <2>
431 
                                                                        <_alt>
432 
                                                                            <1>$dwc_terms_scientificNameAuthorship</1>
433 
                                                                            <2>$conceptual_darwin_2003_1_0_ScientificNameAuthor</2>
434 
                                                                            <3>$dwc_dwcore_AuthorYearOfScientificName</3>
435 
                                                                        </_alt>
436 
                                                                    </2>
400 
                                                                    <2>$dwc_terms_scientificNameAuthorship</2>
437 401 
                                                                </_join_words>
438 402 
                                                            </value>
439 403 
                                                        </_merge_prefix>
440 404 
                                                    </taxonomicname>
441 405 
                                                </taxonlabel>
442 406 
                                            </taxonlabel_id>
443 
                                            <author>
444 
                                                <_alt>
445 
                                                    <1>$dwc_terms_scientificNameAuthorship</1>
446 
                                                    <2>$conceptual_darwin_2003_1_0_ScientificNameAuthor</2>
447 
                                                    <3>$dwc_dwcore_AuthorYearOfScientificName</3>
448 
                                                </_alt>
449 
                                            </author>
407 
                                            <author>$dwc_terms_scientificNameAuthorship</author>
450 408 
                                            <family>
451 409 
                                                <_alt>
452 410 
                                                    <0>$conceptual_darwin_2003_1_0_Family</0>
......
540 498 
                                <place>
541 499 
                                    <coordinates_id>
542 500 
                                        <coordinates>
543 
                                            <coordsaccuracy_m>
544 
                                                <_noCV>
545 
                                                    <value>
546 
                                                        <_alt>
547 
                                                            <1>$dwc_terms_coordinateUncertaintyInMeters</1>
548 
                                                            <2>$conceptual_darwin_2003_1_0_CoordinatePrecision</2>
549 
                                                        </_alt>
550 
                                                    </value>
551 
                                                </_noCV>
552 
                                            </coordsaccuracy_m>
501 
                                            <coordsaccuracy_m><_noCV><value>$dwc_terms_coordinateUncertaintyInMeters</value></_noCV></coordsaccuracy_m>
553 502 
                                            <footprintgeometry_dwc>$conceptual_darwin_2003_1_0_BoundingBox</footprintgeometry_dwc>
554 503 
                                            <latitude_deg>
555 504 
                                                <_nullIf>
inputs/SpeciesLink/Specimen/new_terms.csv
4 4 
dwc_dwcore_InstitutionCode,specimenHolderInstitutions,,
5 5 
dwc_dwcore_CollectionCode,collection,,
6 6 
dwc_dwcore_CatalogNumber,accessionNumber,,
7 
dwc_dwcore_Remarks,occurrenceRemarks,/_alt/3,
7 
dwc_dwcore_Remarks,DUPLICATE#of:dwc_terms_occurrenceRemarks#dwc_dwcore_Remarks,,exact duplicate
8 8 
dwc_dwcore_ScientificName,taxonName,,
9 9 
dwc_dwcore_Kingdom,kingdom,,
10 10 
dwc_dwcore_Phylum,phylum,,
......
14 14 
dwc_dwcore_Genus,genus,,
15 15 
dwc_dwcore_SpecificEpithet,specificEpithet,,
16 16 
dwc_dwcore_InfraspecificEpithet,infraspecificEpithet,,
17 
dwc_dwcore_AuthorYearOfScientificName,scientificNameAuthorship,/_alt/3,
17 
dwc_dwcore_AuthorYearOfScientificName,DUPLICATE#of:dwc_terms_scientificNameAuthorship#dwc_dwcore_AuthorYearOfScientificName,,exact duplicate
18 18 
dwc_dwcore_Continent,continent,,
19 19 
dwc_dwcore_Country,country,,
20 20 
dwc_dwcore_StateProvince,stateProvince,,
......
27 27 
dwc_dwcore_Collector,recordedBy,,
28 28 
dwc_dwcore_Sex,sex,,
29 29 
dwc_curatorial_IdentifiedBy,identifiedBy,,
30 
dwc_curatorial_CollectorNumber,collectorNumber,/_alt/1,"identical to recordNumber because the following query returns no rows: SELECT * FROM ""SpeciesLink"".""Specimen"" WHERE NOT ""dwc_curatorial_CollectorNumber"" IS NOT DISTINCT FROM ""dwc_terms_recordNumber"""
31 
dwc_curatorial_FieldNumber,collectorNumber,/_alt/2,"Usage inconsistent with DwC definition. This field instead means the same thing as recordNumber, and values are stored under either of the two terms."
30 
dwc_curatorial_CollectorNumber,DUPLICATE#of:dwc_terms_recordNumber#dwc_curatorial_CollectorNumber,,exact duplicate
31 
dwc_curatorial_FieldNumber,DUPLICATE#of:dwc_terms_fieldNumber#dwc_curatorial_FieldNumber,,exact duplicate
32 32 
dwc_curatorial_TypeStatus,typeStatus,,
33 33 
dwc_curatorial_IndividualCount,individualCount,,
34 34 
dwc_geospatial_DecimalLatitude,decimalLatitude,,
......
44 44 
dwc_terms_dateIdentified,dateIdentified,,
45 45 
dwc_terms_typeStatus,typeStatus,,
46 46 
dwc_terms_catalogNumber,accessionNumber,,
47 
dwc_terms_occurrenceRemarks,occurrenceRemarks,/_alt/1,
47 
dwc_terms_occurrenceRemarks,occurrenceRemarks,,
48 48 
dwc_terms_recordNumber,collectorNumber,/_alt/1,
49 49 
dwc_terms_recordedBy,recordedBy,,
50 50 
dwc_terms_individualCount,individualCount,,
......
69 69 
dwc_terms_verbatimLongitude,verbatimLongitude,,
70 70 
dwc_terms_decimalLatitude,decimalLatitude,,
71 71 
dwc_terms_decimalLongitude,decimalLongitude,,
72 
dwc_terms_coordinateUncertaintyInMeters,coordinateUncertaintyInMeters,/_alt/1,
72 
dwc_terms_coordinateUncertaintyInMeters,coordinateUncertaintyInMeters,,
73 73 
dwc_terms_scientificName,taxonName,,
74 74 
dwc_terms_kingdom,kingdom,,
75 75 
dwc_terms_phylum,phylum,,
......
79 79 
dwc_terms_genus,genus,,
80 80 
dwc_terms_specificEpithet,specificEpithet,,
81 81 
dwc_terms_infraspecificEpithet,infraspecificEpithet,,
82 
dwc_terms_scientificNameAuthorship,scientificNameAuthorship,/_alt/1,
82 
dwc_terms_scientificNameAuthorship,scientificNameAuthorship,,
83 83 
conceptual_darwin_2003_1_0_DateLastModified,modified,,
84 84 
conceptual_darwin_2003_1_0_InstitutionCode,specimenHolderInstitutions,,
85 85 
conceptual_darwin_2003_1_0_CollectionCode,collection,,
......
94 94 
conceptual_darwin_2003_1_0_Genus,genus,,
95 95 
conceptual_darwin_2003_1_0_Species,specificEpithet,,
96 96 
conceptual_darwin_2003_1_0_Subspecies,subspecies,,
97 
conceptual_darwin_2003_1_0_ScientificNameAuthor,scientificNameAuthorship,/_alt/2,
97 
conceptual_darwin_2003_1_0_ScientificNameAuthor,DUPLICATE#of:dwc_terms_scientificNameAuthorship#conceptual_darwin_2003_1_0_ScientificNameAuthor,,exact duplicate
98 98 
conceptual_darwin_2003_1_0_IdentifiedBy,identifiedBy,,
99 99 
conceptual_darwin_2003_1_0_YearIdentified,yearIdentified,,
100 100 
conceptual_darwin_2003_1_0_MonthIdentified,monthIdentified,,
101 101 
conceptual_darwin_2003_1_0_DayIdentified,dayIdentified,,
102 102 
conceptual_darwin_2003_1_0_TypeStatus,typeStatus,,
103 
conceptual_darwin_2003_1_0_CollectorNumber,collectorNumber,/_alt/1,"identical to recordNumber because the following query returns no rows: SELECT * FROM ""SpeciesLink"".""Specimen"" WHERE NOT ""conceptual_darwin_2003_1_0_CollectorNumber"" IS NOT DISTINCT FROM ""dwc_terms_recordNumber"""
104 
conceptual_darwin_2003_1_0_FieldNumber,collectorNumber,/_alt/2,"Usage inconsistent with DwC definition. This field instead means the same thing as recordNumber, and values are stored under either of the two terms."
103 
conceptual_darwin_2003_1_0_CollectorNumber,DUPLICATE#of:dwc_terms_recordNumber#conceptual_darwin_2003_1_0_CollectorNumber,,exact duplicate
104 
conceptual_darwin_2003_1_0_FieldNumber,DUPLICATE#of:dwc_terms_fieldNumber#conceptual_darwin_2003_1_0_FieldNumber,,exact duplicate
105 105 
conceptual_darwin_2003_1_0_Collector,recordedBy,,
106 106 
conceptual_darwin_2003_1_0_YearCollected,yearCollected,,
107 107 
conceptual_darwin_2003_1_0_MonthCollected,monthCollected,,
......
114 114 
conceptual_darwin_2003_1_0_Locality,locality,,
115 115 
conceptual_darwin_2003_1_0_Longitude,decimalLongitude,,
116 116 
conceptual_darwin_2003_1_0_Latitude,decimalLatitude,,
117 
conceptual_darwin_2003_1_0_CoordinatePrecision,coordinateUncertaintyInMeters,/_alt/2,Assuming units based on the range and precision of values
117 
conceptual_darwin_2003_1_0_CoordinatePrecision,DUPLICATE#of:dwc_terms_coordinateUncertaintyInMeters#conceptual_darwin_2003_1_0_CoordinatePrecision,,exact duplicate
118 118 
conceptual_darwin_2003_1_0_BoundingBox,footprintWKT,,
119 119 
conceptual_darwin_2003_1_0_MinimumElevation,minimumElevationInMeters,,
120 120 
conceptual_darwin_2003_1_0_MaximumElevation,maximumElevationInMeters,,
......
126 126 
conceptual_darwin_2003_1_0_PreviousCatalogNumber,otherCatalogNumbers,,
127 127 
conceptual_darwin_2003_1_0_RelationshipType,relationshipOfResource,,
128 128 
conceptual_darwin_2003_1_0_RelatedCatalogItem,relatedResourceID,,
129 
conceptual_darwin_2003_1_0_Notes,occurrenceRemarks,/_alt/2,
129 
conceptual_darwin_2003_1_0_Notes,DUPLICATE#of:dwc_terms_occurrenceRemarks#conceptual_darwin_2003_1_0_Notes,,exact duplicate

Also available in: Unified diff