Project

General

Profile

« Previous | Next » 

Revision 10431

bugfix: inputs/SpeciesLink/Specimen/map.csv: *CollectorNumber: moved these to the same _alt group as recordNumber, because they are actually duplicates

View differences:

inputs/SpeciesLink/Specimen/map.csv
30 30
dwc_dwcore_Collector,recordedBy,,
31 31
dwc_dwcore_Sex,sex,,
32 32
dwc_curatorial_IdentifiedBy,identifiedBy,,
33
dwc_curatorial_CollectorNumber,collectorNumber,/_alt/3,
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 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."
35 35
dwc_curatorial_TypeStatus,typeStatus,,
36 36
dwc_curatorial_IndividualCount,individualCount,,
......
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/3,
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 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."
110 110
conceptual_darwin_2003_1_0_Collector,recordedBy,,
111 111
conceptual_darwin_2003_1_0_YearCollected,yearCollected,,
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"""
34 36
dwc_terms_recordNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/1",
35 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."
36 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."
37 39
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."
38
conceptual_darwin_2003_1_0_CollectorNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/3",
39
dwc_curatorial_CollectorNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/3",
40 40
conceptual_darwin_2003_1_0_Locality,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1,
41 41
dwc_dwcore_Locality,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1,
42 42
dwc_terms_locality,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1,
......
56 56
dwc_terms_occurrenceRemarks,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/1/_alt/1,
57 57
conceptual_darwin_2003_1_0_Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/1/_alt/2,
58 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"""
59 61
dwc_terms_recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2/_alt/1,
60 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."
61 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."
62 64
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."
63
conceptual_darwin_2003_1_0_CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2/_alt/3,
64
dwc_curatorial_CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2/_alt/3,
65 65
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 66
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"
67 67
dwc_terms_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 72
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 73
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 74
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"""
75 77
dwc_terms_recordNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else/_alt/1",
76 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."
77 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."
78 80
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."
79
conceptual_darwin_2003_1_0_CollectorNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else/_alt/3",
80
dwc_curatorial_CollectorNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else/_alt/3",
81 81
conceptual_darwin_2003_1_0_CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
82 82
dwc_dwcore_CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
83 83
dwc_dwcore_GlobalUniqueIdentifier,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
......
89 89
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 90
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 91
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"""
92 94
dwc_terms_recordNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3/_alt/1",
93 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."
94 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."
95 97
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."
96
conceptual_darwin_2003_1_0_CollectorNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3/_alt/3",
97
dwc_curatorial_CollectorNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3/_alt/3",
98 98
conceptual_darwin_2003_1_0_ScientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/3",
99 99
dwc_dwcore_ScientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/3",
100 100
dwc_terms_scientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/3",
......
102 102
dwc_dwcore_Collector,/location/locationevent/taxonoccurrence/collector_id/party/fullname,
103 103
dwc_terms_recordedBy,/location/locationevent/taxonoccurrence/collector_id/party/fullname,
104 104
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"""
105 107
dwc_terms_recordNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/1",
106 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."
107 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."
108 110
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."
109
conceptual_darwin_2003_1_0_CollectorNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/3",
110
dwc_curatorial_CollectorNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/3",
111 111
dwc_dwcore_GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,
112 112
conceptual_darwin_2003_1_0_IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname,
113 113
dwc_curatorial_IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/fullname,
......
178 178
conceptual_darwin_2003_1_0_CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
179 179
dwc_dwcore_CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
180 180
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"""
181 183
dwc_terms_recordNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then/_alt/1",
182 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."
183 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."
184 186
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."
185
conceptual_darwin_2003_1_0_CollectorNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then/_alt/3",
186
dwc_curatorial_CollectorNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then/_alt/3",
187 187
conceptual_darwin_2003_1_0_MinimumDepth,/location/locationevent/waterdepth_m/_avg/1,
188 188
dwc_dwcore_MinimumDepthInMeters,/location/locationevent/waterdepth_m/_avg/1,
189 189
dwc_terms_minimumDepthInMeters,/location/locationevent/waterdepth_m/_avg/1,
inputs/SpeciesLink/Specimen/test.xml.ref
131 131
                                    <plantobservation>
132 132
                                        <authorplantcode>
133 133
                                            <_alt>
134
                                                <1>$dwc_terms_recordNumber</1>
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>
135 141
                                                <2>
136 142
                                                    <_alt>
137 143
                                                        <0>$conceptual_darwin_2003_1_0_FieldNumber</0>
......
139 145
                                                        <2>$dwc_terms_fieldNumber</2>
140 146
                                                    </_alt>
141 147
                                                </2>
142
                                                <3>
143
                                                    <_alt>
144
                                                        <0>$conceptual_darwin_2003_1_0_CollectorNumber</0>
145
                                                        <1>$dwc_curatorial_CollectorNumber</1>
146
                                                    </_alt>
147
                                                </3>
148 148
                                            </_alt>
149 149
                                        </authorplantcode>
150 150
                                        <definedvalue fkey="tablerecord_id">
......
184 184
                                            </collectioncode_dwc>
185 185
                                            <collectionnumber>
186 186
                                                <_alt>
187
                                                    <1>$dwc_terms_recordNumber</1>
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>
188 194
                                                    <2>
189 195
                                                        <_alt>
190 196
                                                            <0>$conceptual_darwin_2003_1_0_FieldNumber</0>
......
192 198
                                                            <2>$dwc_terms_fieldNumber</2>
193 199
                                                        </_alt>
194 200
                                                    </2>
195
                                                    <3>
196
                                                        <_alt>
197
                                                            <0>$conceptual_darwin_2003_1_0_CollectorNumber</0>
198
                                                            <1>$dwc_curatorial_CollectorNumber</1>
199
                                                        </_alt>
200
                                                    </3>
201 201
                                                </_alt>
202 202
                                            </collectionnumber>
203 203
                                            <institution_id>
inputs/SpeciesLink/Specimen/new_terms.csv
27 27
dwc_dwcore_Collector,recordedBy,,
28 28
dwc_dwcore_Sex,sex,,
29 29
dwc_curatorial_IdentifiedBy,identifiedBy,,
30
dwc_curatorial_CollectorNumber,collectorNumber,/_alt/3,
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 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."
32 32
dwc_curatorial_TypeStatus,typeStatus,,
33 33
dwc_curatorial_IndividualCount,individualCount,,
......
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/3,
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 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."
105 105
conceptual_darwin_2003_1_0_Collector,recordedBy,,
106 106
conceptual_darwin_2003_1_0_YearCollected,yearCollected,,

Also available in: Unified diff