Project

General

Profile

« Previous | Next » 

Revision 10430

Added by Aaron Marcuse-Kubitza over 11 years ago

correction: inputs/SpeciesLink/Specimen/map.csv: FieldNumber: fixed incorrect comment that these fields are identical to recordNumber, when instead they have the same *meaning but not the same values. instead, values are stored under either of the two terms. the previous conclusion had been based on an incorrect query, which used != instead of the NULL-sensitive IS NOT DISTINCT FROM.

View differences:

inputs/SpeciesLink/Specimen/map.csv
31 31 
dwc_dwcore_Sex,sex,,
32 32 
dwc_curatorial_IdentifiedBy,identifiedBy,,
33 33 
dwc_curatorial_CollectorNumber,collectorNumber,/_alt/3,
34 
dwc_curatorial_FieldNumber,collectorNumber,/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
35 
-----
36 
SELECT count(*) FROM ""SpeciesLink"".specimens
37 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
38 
-----"
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."
39 35 
dwc_curatorial_TypeStatus,typeStatus,,
40 36 
dwc_curatorial_IndividualCount,individualCount,,
41 37 
dwc_geospatial_DecimalLatitude,decimalLatitude,,
......
64 60 
dwc_terms_year,yearCollected,,
65 61 
dwc_terms_month,monthCollected,,
66 62 
dwc_terms_day,dayCollected,,
67 
dwc_terms_fieldNumber,collectorNumber,/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
68 
-----
69 
SELECT count(*) FROM ""SpeciesLink"".specimens
70 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
71 
-----"
63 
dwc_terms_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."
72 64 
dwc_terms_continent,continent,,
73 65 
dwc_terms_country,country,,
74 66 
dwc_terms_stateProvince,stateProvince,,
......
114 106 
conceptual_darwin_2003_1_0_DayIdentified,dayIdentified,,
115 107 
conceptual_darwin_2003_1_0_TypeStatus,typeStatus,,
116 108 
conceptual_darwin_2003_1_0_CollectorNumber,collectorNumber,/_alt/3,
117 
conceptual_darwin_2003_1_0_FieldNumber,collectorNumber,/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
118 
-----
119 
SELECT count(*) FROM ""SpeciesLink"".specimens
120 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
121 
-----"
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."
122 110 
conceptual_darwin_2003_1_0_Collector,recordedBy,,
123 111 
conceptual_darwin_2003_1_0_YearCollected,yearCollected,,
124 112 
conceptual_darwin_2003_1_0_MonthCollected,monthCollected,,
inputs/SpeciesLink/Specimen/VegBIEN.csv
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 34 
dwc_terms_recordNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/1",
35 
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 is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
36 
-----
37 
SELECT count(*) FROM ""SpeciesLink"".specimens
38 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
39 
-----"
40 
dwc_curatorial_FieldNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/2","Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
41 
-----
42 
SELECT count(*) FROM ""SpeciesLink"".specimens
43 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
44 
-----"
45 
dwc_terms_fieldNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/2","Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
46 
-----
47 
SELECT count(*) FROM ""SpeciesLink"".specimens
48 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
49 
-----"
35 
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 
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 
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."
50 38 
conceptual_darwin_2003_1_0_CollectorNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/3",
51 39 
dwc_curatorial_CollectorNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/3",
52 40 
conceptual_darwin_2003_1_0_Locality,/location/iscultivated/_or/2/_locationnarrative_is_cultivated/locationnarrative/_join/1,
......
69 57 
conceptual_darwin_2003_1_0_Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/1/_alt/2,
70 58 
dwc_dwcore_Remarks,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes/_join/1/_alt/3,
71 59 
dwc_terms_recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2/_alt/1,
72 
conceptual_darwin_2003_1_0_FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
73 
-----
74 
SELECT count(*) FROM ""SpeciesLink"".specimens
75 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
76 
-----"
77 
dwc_curatorial_FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
78 
-----
79 
SELECT count(*) FROM ""SpeciesLink"".specimens
80 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
81 
-----"
82 
dwc_terms_fieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
83 
-----
84 
SELECT count(*) FROM ""SpeciesLink"".specimens
85 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
86 
-----"
60 
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 
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 
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."
87 63 
conceptual_darwin_2003_1_0_CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2/_alt/3,
88 64 
dwc_curatorial_CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2/_alt/3,
89 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"
......
97 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
98 74 
dwc_terms_collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_alt/2,
99 75 
dwc_terms_recordNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else/_alt/1",
100 
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 is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
101 
-----
102 
SELECT count(*) FROM ""SpeciesLink"".specimens
103 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
104 
-----"
105 
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 is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
106 
-----
107 
SELECT count(*) FROM ""SpeciesLink"".specimens
108 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
109 
-----"
110 
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 is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
111 
-----
112 
SELECT count(*) FROM ""SpeciesLink"".specimens
113 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
114 
-----"
76 
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 
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 
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."
115 79 
conceptual_darwin_2003_1_0_CollectorNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else/_alt/3",
116 80 
dwc_curatorial_CollectorNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else/_alt/3",
117 81 
conceptual_darwin_2003_1_0_CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
......
126 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",
127 91 
dwc_dwcore_GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
128 92 
dwc_terms_recordNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3/_alt/1",
129 
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 is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
130 
-----
131 
SELECT count(*) FROM ""SpeciesLink"".specimens
132 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
133 
-----"
134 
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 is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
135 
-----
136 
SELECT count(*) FROM ""SpeciesLink"".specimens
137 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
138 
-----"
139 
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 is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
140 
-----
141 
SELECT count(*) FROM ""SpeciesLink"".specimens
142 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
143 
-----"
93 
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 
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 
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."
144 96 
conceptual_darwin_2003_1_0_CollectorNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3/_alt/3",
145 97 
dwc_curatorial_CollectorNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3/_alt/3",
146 98 
conceptual_darwin_2003_1_0_ScientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/3",
......
151 103 
dwc_terms_recordedBy,/location/locationevent/taxonoccurrence/collector_id/party/fullname,
152 104 
dwc_dwcore_GlobalUniqueIdentifier,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
153 105 
dwc_terms_recordNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/1",
154 
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 is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
155 
-----
156 
SELECT count(*) FROM ""SpeciesLink"".specimens
157 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
158 
-----"
159 
dwc_curatorial_FieldNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/2","Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
160 
-----
161 
SELECT count(*) FROM ""SpeciesLink"".specimens
162 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
163 
-----"
164 
dwc_terms_fieldNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/2","Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
165 
-----
166 
SELECT count(*) FROM ""SpeciesLink"".specimens
167 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
168 
-----"
106 
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 
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 
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."
169 109 
conceptual_darwin_2003_1_0_CollectorNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/3",
170 110 
dwc_curatorial_CollectorNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists/_alt/3",
171 111 
dwc_dwcore_GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/3,
......
239 179 
dwc_dwcore_CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
240 180 
dwc_terms_catalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
241 181 
dwc_terms_recordNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then/_alt/1",
242 
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 is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
243 
-----
244 
SELECT count(*) FROM ""SpeciesLink"".specimens
245 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
246 
-----"
247 
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 is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
248 
-----
249 
SELECT count(*) FROM ""SpeciesLink"".specimens
250 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
251 
-----"
252 
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 is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
253 
-----
254 
SELECT count(*) FROM ""SpeciesLink"".specimens
255 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
256 
-----"
182 
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 
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 
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."
257 185 
conceptual_darwin_2003_1_0_CollectorNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then/_alt/3",
258 186 
dwc_curatorial_CollectorNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then/_alt/3",
259 187 
conceptual_darwin_2003_1_0_MinimumDepth,/location/locationevent/waterdepth_m/_avg/1,
inputs/SpeciesLink/Specimen/new_terms.csv
28 28 
dwc_dwcore_Sex,sex,,
29 29 
dwc_curatorial_IdentifiedBy,identifiedBy,,
30 30 
dwc_curatorial_CollectorNumber,collectorNumber,/_alt/3,
31 
dwc_curatorial_FieldNumber,collectorNumber,/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
32 
-----
33 
SELECT count(*) FROM ""SpeciesLink"".specimens
34 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
35 
-----"
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."
36 32 
dwc_curatorial_TypeStatus,typeStatus,,
37 33 
dwc_curatorial_IndividualCount,individualCount,,
38 34 
dwc_geospatial_DecimalLatitude,decimalLatitude,,
......
59 55 
dwc_terms_year,yearCollected,,
60 56 
dwc_terms_month,monthCollected,,
61 57 
dwc_terms_day,dayCollected,,
62 
dwc_terms_fieldNumber,collectorNumber,/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
63 
-----
64 
SELECT count(*) FROM ""SpeciesLink"".specimens
65 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
66 
-----"
58 
dwc_terms_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."
67 59 
dwc_terms_continent,continent,,
68 60 
dwc_terms_country,country,,
69 61 
dwc_terms_stateProvince,stateProvince,,
......
109 101 
conceptual_darwin_2003_1_0_DayIdentified,dayIdentified,,
110 102 
conceptual_darwin_2003_1_0_TypeStatus,typeStatus,,
111 103 
conceptual_darwin_2003_1_0_CollectorNumber,collectorNumber,/_alt/3,
112 
conceptual_darwin_2003_1_0_FieldNumber,collectorNumber,/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
113 
-----
114 
SELECT count(*) FROM ""SpeciesLink"".specimens
115 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
116 
-----"
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."
117 105 
conceptual_darwin_2003_1_0_Collector,recordedBy,,
118 106 
conceptual_darwin_2003_1_0_YearCollected,yearCollected,,
119 107 
conceptual_darwin_2003_1_0_MonthCollected,monthCollected,,

Also available in: Unified diff