Project

General

Profile

« Previous | Next » 

Revision 4631

Added by Aaron Marcuse-Kubitza over 12 years ago

inputs/SpeciesLink/Specimen/src.csv, map.csv: Switched from using root prefixes to full column names, because the namespace mapping functionality can be handled much better by treating each namespace-qualified term as its own term rather than as a term and a prefix

View differences:

inputs/SpeciesLink/Specimen/src.csv
1 
"SpeciesLink[Veg+,dwc_dwcore_,dwc_curatorial_,dwc_geospatial_,http__purl_org_,dwc_terms_,conceptual_darwin_2003_1_0_]",Veg+,Comments,Original name
2 
GlobalUniqueIdentifier,GlobalUniqueIdentifier,,dwc_dwcore_GlobalUniqueIdentifier
3 
DateLastModified,DateLastModified,,dwc_dwcore_DateLastModified
4 
BasisOfRecord,BasisOfRecord,,dwc_dwcore_BasisOfRecord
5 
InstitutionCode,InstitutionCode,,dwc_dwcore_InstitutionCode
6 
CollectionCode,CollectionCode,,dwc_dwcore_CollectionCode
7 
CatalogNumber,CatalogNumber,,dwc_dwcore_CatalogNumber
8 
Remarks,Remarks,,dwc_dwcore_Remarks
9 
ScientificName,ScientificName,,dwc_dwcore_ScientificName
10 
Kingdom,Kingdom,,dwc_dwcore_Kingdom
11 
Phylum,Phylum,,dwc_dwcore_Phylum
12 
Class,Class,,dwc_dwcore_Class
13 
Order,Order,,dwc_dwcore_Order
14 
Family,Family,,dwc_dwcore_Family
15 
Genus,Genus,,dwc_dwcore_Genus
16 
SpecificEpithet,SpecificEpithet,,dwc_dwcore_SpecificEpithet
17 
InfraspecificEpithet,InfraspecificEpithet,,dwc_dwcore_InfraspecificEpithet
18 
AuthorYearOfScientificName,AuthorYearOfScientificName,,dwc_dwcore_AuthorYearOfScientificName
19 
Continent,Continent,,dwc_dwcore_Continent
20 
Country,Country,,dwc_dwcore_Country
21 
StateProvince,StateProvince,,dwc_dwcore_StateProvince
22 
County,County,,dwc_dwcore_County
23 
Locality,Locality,,dwc_dwcore_Locality
24 
MinimumElevationInMeters,MinimumElevationInMeters,,dwc_dwcore_MinimumElevationInMeters
25 
MaximumElevationInMeters,MaximumElevationInMeters,,dwc_dwcore_MaximumElevationInMeters
26 
MinimumDepthInMeters,MinimumDepthInMeters,,dwc_dwcore_MinimumDepthInMeters
27 
MaximumDepthInMeters,MaximumDepthInMeters,,dwc_dwcore_MaximumDepthInMeters
28 
DayOfYear,DayOfYear,,dwc_dwcore_DayOfYear
29 
Collector,Collector,,dwc_dwcore_Collector
30 
Sex,Sex,,dwc_dwcore_Sex
31 
IdentifiedBy,IdentifiedBy,,dwc_curatorial_IdentifiedBy
32 
CollectorNumber,CollectorNumber,,dwc_curatorial_CollectorNumber
33 
FieldNumber,FieldNumber,,dwc_curatorial_FieldNumber
34 
TypeStatus,TypeStatus,,dwc_curatorial_TypeStatus
35 
IndividualCount,IndividualCount,,dwc_curatorial_IndividualCount
36 
DecimalLatitude,DecimalLatitude,,dwc_geospatial_DecimalLatitude
37 
DecimalLongitude,DecimalLongitude,,dwc_geospatial_DecimalLongitude
38 
VerbatimLatitude,VerbatimLatitude,,dwc_geospatial_VerbatimLatitude
39 
VerbatimLongitude,VerbatimLongitude,,dwc_geospatial_VerbatimLongitude
40 
dc_terms_modified,dc_terms_modified,,http__purl_org_dc_terms_modified
41 
collectionID,collectionID,,dwc_terms_collectionID
42 
institutionCode,institutionCode,,dwc_terms_institutionCode
43 
collectionCode,collectionCode,,dwc_terms_collectionCode
44 
basisOfRecord,basisOfRecord,,dwc_terms_basisOfRecord
45 
identifiedBy,identifiedBy,,dwc_terms_identifiedBy
46 
dateIdentified,dateIdentified,,dwc_terms_dateIdentified
47 
typeStatus,typeStatus,,dwc_terms_typeStatus
48 
catalogNumber,catalogNumber,,dwc_terms_catalogNumber
49 
occurrenceRemarks,occurrenceRemarks,,dwc_terms_occurrenceRemarks
50 
recordNumber,recordNumber,,dwc_terms_recordNumber
51 
recordedBy,recordedBy,,dwc_terms_recordedBy
52 
individualCount,individualCount,,dwc_terms_individualCount
53 
sex,sex,,dwc_terms_sex
54 
preparations,preparations,,dwc_terms_preparations
55 
otherCatalogNumbers,otherCatalogNumbers,,dwc_terms_otherCatalogNumbers
56 
eventTime,eventTime,,dwc_terms_eventTime
57 
startDayOfYear,startDayOfYear,,dwc_terms_startDayOfYear
58 
endDayOfYear,endDayOfYear,,dwc_terms_endDayOfYear
59 
year,year,,dwc_terms_year
60 
month,month,,dwc_terms_month
61 
day,day,,dwc_terms_day
62 
fieldNumber,fieldNumber,,dwc_terms_fieldNumber
63 
continent,continent,,dwc_terms_continent
64 
country,country,,dwc_terms_country
65 
stateProvince,stateProvince,,dwc_terms_stateProvince
66 
county,county,,dwc_terms_county
67 
locality,locality,,dwc_terms_locality
68 
minimumElevationInMeters,minimumElevationInMeters,,dwc_terms_minimumElevationInMeters
69 
maximumElevationInMeters,maximumElevationInMeters,,dwc_terms_maximumElevationInMeters
70 
minimumDepthInMeters,minimumDepthInMeters,,dwc_terms_minimumDepthInMeters
71 
maximumDepthInMeters,maximumDepthInMeters,,dwc_terms_maximumDepthInMeters
72 
verbatimLatitude,verbatimLatitude,,dwc_terms_verbatimLatitude
73 
verbatimLongitude,verbatimLongitude,,dwc_terms_verbatimLongitude
74 
decimalLatitude,decimalLatitude,,dwc_terms_decimalLatitude
75 
decimalLongitude,decimalLongitude,,dwc_terms_decimalLongitude
76 
coordinateUncertaintyInMeters,coordinateUncertaintyInMeters,,dwc_terms_coordinateUncertaintyInMeters
77 
scientificName,scientificName,,dwc_terms_scientificName
78 
kingdom,kingdom,,dwc_terms_kingdom
79 
phylum,phylum,,dwc_terms_phylum
80 
class,class,,dwc_terms_class
81 
order,order,,dwc_terms_order
82 
family,family,,dwc_terms_family
83 
genus,genus,,dwc_terms_genus
84 
specificEpithet,specificEpithet,,dwc_terms_specificEpithet
85 
infraspecificEpithet,infraspecificEpithet,,dwc_terms_infraspecificEpithet
86 
scientificNameAuthorship,scientificNameAuthorship,,dwc_terms_scientificNameAuthorship
87 
DateLastModified,DateLastModified,,conceptual_darwin_2003_1_0_DateLastModified
88 
InstitutionCode,InstitutionCode,,conceptual_darwin_2003_1_0_InstitutionCode
89 
CollectionCode,CollectionCode,,conceptual_darwin_2003_1_0_CollectionCode
90 
CatalogNumber,CatalogNumber,,conceptual_darwin_2003_1_0_CatalogNumber
91 
ScientificName,ScientificName,,conceptual_darwin_2003_1_0_ScientificName
92 
BasisOfRecord,BasisOfRecord,,conceptual_darwin_2003_1_0_BasisOfRecord
93 
Kingdom,Kingdom,,conceptual_darwin_2003_1_0_Kingdom
94 
Phylum,Phylum,,conceptual_darwin_2003_1_0_Phylum
95 
Class,Class,,conceptual_darwin_2003_1_0_Class
96 
Order,Order,,conceptual_darwin_2003_1_0_Order
97 
Family,Family,,conceptual_darwin_2003_1_0_Family
98 
Genus,Genus,,conceptual_darwin_2003_1_0_Genus
99 
Species,Species,,conceptual_darwin_2003_1_0_Species
100 
Subspecies,Subspecies,,conceptual_darwin_2003_1_0_Subspecies
101 
ScientificNameAuthor,ScientificNameAuthor,,conceptual_darwin_2003_1_0_ScientificNameAuthor
102 
IdentifiedBy,IdentifiedBy,,conceptual_darwin_2003_1_0_IdentifiedBy
103 
YearIdentified,YearIdentified,,conceptual_darwin_2003_1_0_YearIdentified
104 
MonthIdentified,MonthIdentified,,conceptual_darwin_2003_1_0_MonthIdentified
105 
DayIdentified,DayIdentified,,conceptual_darwin_2003_1_0_DayIdentified
106 
TypeStatus,TypeStatus,,conceptual_darwin_2003_1_0_TypeStatus
107 
CollectorNumber,CollectorNumber,,conceptual_darwin_2003_1_0_CollectorNumber
108 
FieldNumber,FieldNumber,,conceptual_darwin_2003_1_0_FieldNumber
109 
Collector,Collector,,conceptual_darwin_2003_1_0_Collector
110 
YearCollected,YearCollected,,conceptual_darwin_2003_1_0_YearCollected
111 
MonthCollected,MonthCollected,,conceptual_darwin_2003_1_0_MonthCollected
112 
DayCollected,DayCollected,,conceptual_darwin_2003_1_0_DayCollected
113 
JulianDay,JulianDay,,conceptual_darwin_2003_1_0_JulianDay
114 
TimeOfDay,TimeOfDay,,conceptual_darwin_2003_1_0_TimeOfDay
115 
ContinentOcean,ContinentOcean,,conceptual_darwin_2003_1_0_ContinentOcean
116 
Country,Country,,conceptual_darwin_2003_1_0_Country
117 
StateProvince,StateProvince,,conceptual_darwin_2003_1_0_StateProvince
118 
County,County,,conceptual_darwin_2003_1_0_County
119 
Locality,Locality,,conceptual_darwin_2003_1_0_Locality
120 
Longitude,Longitude,,conceptual_darwin_2003_1_0_Longitude
121 
Latitude,Latitude,,conceptual_darwin_2003_1_0_Latitude
122 
CoordinatePrecision,CoordinatePrecision,,conceptual_darwin_2003_1_0_CoordinatePrecision
123 
BoundingBox,BoundingBox,,conceptual_darwin_2003_1_0_BoundingBox
124 
MinimumElevation,MinimumElevation,,conceptual_darwin_2003_1_0_MinimumElevation
125 
MaximumElevation,MaximumElevation,,conceptual_darwin_2003_1_0_MaximumElevation
126 
MinimumDepth,MinimumDepth,,conceptual_darwin_2003_1_0_MinimumDepth
127 
MaximumDepth,MaximumDepth,,conceptual_darwin_2003_1_0_MaximumDepth
128 
Sex,Sex,,conceptual_darwin_2003_1_0_Sex
129 
PreparationType,PreparationType,,conceptual_darwin_2003_1_0_PreparationType
130 
IndividualCount,IndividualCount,,conceptual_darwin_2003_1_0_IndividualCount
131 
PreviousCatalogNumber,PreviousCatalogNumber,,conceptual_darwin_2003_1_0_PreviousCatalogNumber
132 
RelationshipType,RelationshipType,,conceptual_darwin_2003_1_0_RelationshipType
133 
RelatedCatalogItem,RelatedCatalogItem,,conceptual_darwin_2003_1_0_RelatedCatalogItem
134 
Notes,Notes,,conceptual_darwin_2003_1_0_Notes
1 
SpeciesLink[Veg+],Veg+,Comments
2 
dwc_dwcore_GlobalUniqueIdentifier,GlobalUniqueIdentifier,
3 
dwc_dwcore_DateLastModified,DateLastModified,
4 
dwc_dwcore_BasisOfRecord,BasisOfRecord,
5 
dwc_dwcore_InstitutionCode,InstitutionCode,
6 
dwc_dwcore_CollectionCode,CollectionCode,
7 
dwc_dwcore_CatalogNumber,CatalogNumber,
8 
dwc_dwcore_Remarks,Remarks,
9 
dwc_dwcore_ScientificName,ScientificName,
10 
dwc_dwcore_Kingdom,Kingdom,
11 
dwc_dwcore_Phylum,Phylum,
12 
dwc_dwcore_Class,Class,
13 
dwc_dwcore_Order,Order,
14 
dwc_dwcore_Family,Family,
15 
dwc_dwcore_Genus,Genus,
16 
dwc_dwcore_SpecificEpithet,SpecificEpithet,
17 
dwc_dwcore_InfraspecificEpithet,InfraspecificEpithet,
18 
dwc_dwcore_AuthorYearOfScientificName,AuthorYearOfScientificName,
19 
dwc_dwcore_Continent,Continent,
20 
dwc_dwcore_Country,Country,
21 
dwc_dwcore_StateProvince,StateProvince,
22 
dwc_dwcore_County,County,
23 
dwc_dwcore_Locality,Locality,
24 
dwc_dwcore_MinimumElevationInMeters,MinimumElevationInMeters,
25 
dwc_dwcore_MaximumElevationInMeters,MaximumElevationInMeters,
26 
dwc_dwcore_MinimumDepthInMeters,MinimumDepthInMeters,
27 
dwc_dwcore_MaximumDepthInMeters,MaximumDepthInMeters,
28 
dwc_dwcore_DayOfYear,DayOfYear,
29 
dwc_dwcore_Collector,Collector,
30 
dwc_dwcore_Sex,Sex,
31 
dwc_curatorial_IdentifiedBy,IdentifiedBy,
32 
dwc_curatorial_CollectorNumber,CollectorNumber,
33 
dwc_curatorial_FieldNumber,FieldNumber,
34 
dwc_curatorial_TypeStatus,TypeStatus,
35 
dwc_curatorial_IndividualCount,IndividualCount,
36 
dwc_geospatial_DecimalLatitude,DecimalLatitude,
37 
dwc_geospatial_DecimalLongitude,DecimalLongitude,
38 
dwc_geospatial_VerbatimLatitude,VerbatimLatitude,
39 
dwc_geospatial_VerbatimLongitude,VerbatimLongitude,
40 
http__purl_org_dc_terms_modified,dc_terms_modified,
41 
dwc_terms_collectionID,collectionID,
42 
dwc_terms_institutionCode,institutionCode,
43 
dwc_terms_collectionCode,collectionCode,
44 
dwc_terms_basisOfRecord,basisOfRecord,
45 
dwc_terms_identifiedBy,identifiedBy,
46 
dwc_terms_dateIdentified,dateIdentified,
47 
dwc_terms_typeStatus,typeStatus,
48 
dwc_terms_catalogNumber,catalogNumber,
49 
dwc_terms_occurrenceRemarks,occurrenceRemarks,
50 
dwc_terms_recordNumber,recordNumber,
51 
dwc_terms_recordedBy,recordedBy,
52 
dwc_terms_individualCount,individualCount,
53 
dwc_terms_sex,sex,
54 
dwc_terms_preparations,preparations,
55 
dwc_terms_otherCatalogNumbers,otherCatalogNumbers,
56 
dwc_terms_eventTime,eventTime,
57 
dwc_terms_startDayOfYear,startDayOfYear,
58 
dwc_terms_endDayOfYear,endDayOfYear,
59 
dwc_terms_year,year,
60 
dwc_terms_month,month,
61 
dwc_terms_day,day,
62 
dwc_terms_fieldNumber,fieldNumber,
63 
dwc_terms_continent,continent,
64 
dwc_terms_country,country,
65 
dwc_terms_stateProvince,stateProvince,
66 
dwc_terms_county,county,
67 
dwc_terms_locality,locality,
68 
dwc_terms_minimumElevationInMeters,minimumElevationInMeters,
69 
dwc_terms_maximumElevationInMeters,maximumElevationInMeters,
70 
dwc_terms_minimumDepthInMeters,minimumDepthInMeters,
71 
dwc_terms_maximumDepthInMeters,maximumDepthInMeters,
72 
dwc_terms_verbatimLatitude,verbatimLatitude,
73 
dwc_terms_verbatimLongitude,verbatimLongitude,
74 
dwc_terms_decimalLatitude,decimalLatitude,
75 
dwc_terms_decimalLongitude,decimalLongitude,
76 
dwc_terms_coordinateUncertaintyInMeters,coordinateUncertaintyInMeters,
77 
dwc_terms_scientificName,scientificName,
78 
dwc_terms_kingdom,kingdom,
79 
dwc_terms_phylum,phylum,
80 
dwc_terms_class,class,
81 
dwc_terms_order,order,
82 
dwc_terms_family,family,
83 
dwc_terms_genus,genus,
84 
dwc_terms_specificEpithet,specificEpithet,
85 
dwc_terms_infraspecificEpithet,infraspecificEpithet,
86 
dwc_terms_scientificNameAuthorship,scientificNameAuthorship,
87 
conceptual_darwin_2003_1_0_DateLastModified,DateLastModified,
88 
conceptual_darwin_2003_1_0_InstitutionCode,InstitutionCode,
89 
conceptual_darwin_2003_1_0_CollectionCode,CollectionCode,
90 
conceptual_darwin_2003_1_0_CatalogNumber,CatalogNumber,
91 
conceptual_darwin_2003_1_0_ScientificName,ScientificName,
92 
conceptual_darwin_2003_1_0_BasisOfRecord,BasisOfRecord,
93 
conceptual_darwin_2003_1_0_Kingdom,Kingdom,
94 
conceptual_darwin_2003_1_0_Phylum,Phylum,
95 
conceptual_darwin_2003_1_0_Class,Class,
96 
conceptual_darwin_2003_1_0_Order,Order,
97 
conceptual_darwin_2003_1_0_Family,Family,
98 
conceptual_darwin_2003_1_0_Genus,Genus,
99 
conceptual_darwin_2003_1_0_Species,Species,
100 
conceptual_darwin_2003_1_0_Subspecies,Subspecies,
101 
conceptual_darwin_2003_1_0_ScientificNameAuthor,ScientificNameAuthor,
102 
conceptual_darwin_2003_1_0_IdentifiedBy,IdentifiedBy,
103 
conceptual_darwin_2003_1_0_YearIdentified,YearIdentified,
104 
conceptual_darwin_2003_1_0_MonthIdentified,MonthIdentified,
105 
conceptual_darwin_2003_1_0_DayIdentified,DayIdentified,
106 
conceptual_darwin_2003_1_0_TypeStatus,TypeStatus,
107 
conceptual_darwin_2003_1_0_CollectorNumber,CollectorNumber,
108 
conceptual_darwin_2003_1_0_FieldNumber,FieldNumber,
109 
conceptual_darwin_2003_1_0_Collector,Collector,
110 
conceptual_darwin_2003_1_0_YearCollected,YearCollected,
111 
conceptual_darwin_2003_1_0_MonthCollected,MonthCollected,
112 
conceptual_darwin_2003_1_0_DayCollected,DayCollected,
113 
conceptual_darwin_2003_1_0_JulianDay,JulianDay,
114 
conceptual_darwin_2003_1_0_TimeOfDay,TimeOfDay,
115 
conceptual_darwin_2003_1_0_ContinentOcean,ContinentOcean,
116 
conceptual_darwin_2003_1_0_Country,Country,
117 
conceptual_darwin_2003_1_0_StateProvince,StateProvince,
118 
conceptual_darwin_2003_1_0_County,County,
119 
conceptual_darwin_2003_1_0_Locality,Locality,
120 
conceptual_darwin_2003_1_0_Longitude,Longitude,
121 
conceptual_darwin_2003_1_0_Latitude,Latitude,
122 
conceptual_darwin_2003_1_0_CoordinatePrecision,CoordinatePrecision,
123 
conceptual_darwin_2003_1_0_BoundingBox,BoundingBox,
124 
conceptual_darwin_2003_1_0_MinimumElevation,MinimumElevation,
125 
conceptual_darwin_2003_1_0_MaximumElevation,MaximumElevation,
126 
conceptual_darwin_2003_1_0_MinimumDepth,MinimumDepth,
127 
conceptual_darwin_2003_1_0_MaximumDepth,MaximumDepth,
128 
conceptual_darwin_2003_1_0_Sex,Sex,
129 
conceptual_darwin_2003_1_0_PreparationType,PreparationType,
130 
conceptual_darwin_2003_1_0_IndividualCount,IndividualCount,
131 
conceptual_darwin_2003_1_0_PreviousCatalogNumber,PreviousCatalogNumber,
132 
conceptual_darwin_2003_1_0_RelationshipType,RelationshipType,
133 
conceptual_darwin_2003_1_0_RelatedCatalogItem,RelatedCatalogItem,
134 
conceptual_darwin_2003_1_0_Notes,Notes,
inputs/SpeciesLink/Specimen/map.csv
1 
"SpeciesLink[Veg+,dwc_dwcore_,dwc_curatorial_,dwc_geospatial_,http__purl_org_,dwc_terms_,conceptual_darwin_2003_1_0_]",Veg+,Comments
2 
AuthorYearOfScientificName,ScientificNameAuthor/_alt/3,
3 
ScientificNameAuthor,ScientificNameAuthor/_alt/2,
4 
scientificNameAuthorship,ScientificNameAuthor/_alt/1,
5 
DayOfYear,JulianDay/_alt/2,
6 
JulianDay,JulianDay/_alt/1,
7 
CollectorNumber,recordNumber/_alt/3,
8 
FieldNumber,recordNumber/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
1 
SpeciesLink[Veg+],Veg+,Comments
2 
dwc_dwcore_GlobalUniqueIdentifier,occurrenceID,
3 
dwc_dwcore_DateLastModified,dcterms:modified,
4 
dwc_dwcore_BasisOfRecord,BasisOfRecord,
5 
dwc_dwcore_InstitutionCode,institutionCode,
6 
dwc_dwcore_CollectionCode,collectionCode,
7 
dwc_dwcore_CatalogNumber,catalogNumber,
8 
dwc_dwcore_Remarks,taxonRemarks,
9 
dwc_dwcore_ScientificName,scientificName,
10 
dwc_dwcore_Kingdom,kingdom,
11 
dwc_dwcore_Phylum,phylum,
12 
dwc_dwcore_Class,class,
13 
dwc_dwcore_Order,order,
14 
dwc_dwcore_Family,family,
15 
dwc_dwcore_Genus,genus,
16 
dwc_dwcore_SpecificEpithet,specificEpithet,
17 
dwc_dwcore_InfraspecificEpithet,infraspecificEpithet,
18 
dwc_dwcore_AuthorYearOfScientificName,ScientificNameAuthor/_alt/3,
19 
dwc_dwcore_Continent,continent,
20 
dwc_dwcore_Country,country,
21 
dwc_dwcore_StateProvince,stateProvince,
22 
dwc_dwcore_County,county,
23 
dwc_dwcore_Locality,locality,
24 
dwc_dwcore_MinimumElevationInMeters,minimumElevationInMeters,
25 
dwc_dwcore_MaximumElevationInMeters,maximumElevationInMeters,
26 
dwc_dwcore_MinimumDepthInMeters,minimumDepthInMeters,
27 
dwc_dwcore_MaximumDepthInMeters,maximumDepthInMeters,
28 
dwc_dwcore_DayOfYear,JulianDay/_alt/2,
29 
dwc_dwcore_Collector,recordedBy,
30 
dwc_dwcore_Sex,sex,
31 
dwc_curatorial_IdentifiedBy,identifiedBy,
32 
dwc_curatorial_CollectorNumber,recordNumber/_alt/3,
33 
dwc_curatorial_FieldNumber,recordNumber/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
9 34 
-----
10 35 
SELECT count(*) FROM ""SpeciesLink"".specimens
11 36 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
12 37 
-----"
13 
recordNumber,recordNumber/_alt/1,
14 
dc_terms_modified,dcterms:modified,
38 
dwc_curatorial_TypeStatus,TypeStatus,
39 
dwc_curatorial_IndividualCount,individualCount,
40 
dwc_geospatial_DecimalLatitude,decimalLatitude,
41 
dwc_geospatial_DecimalLongitude,decimalLongitude,
42 
dwc_geospatial_VerbatimLatitude,verbatimLatitude,
43 
dwc_geospatial_VerbatimLongitude,verbatimLongitude,
44 
http__purl_org_dc_terms_modified,dcterms:modified,
45 
dwc_terms_collectionID,collectionID,
46 
dwc_terms_institutionCode,institutionCode,
47 
dwc_terms_collectionCode,collectionCode,
48 
dwc_terms_basisOfRecord,basisOfRecord,
49 
dwc_terms_identifiedBy,identifiedBy,
50 
dwc_terms_dateIdentified,dateIdentified,
51 
dwc_terms_typeStatus,typeStatus,
52 
dwc_terms_catalogNumber,catalogNumber,
53 
dwc_terms_occurrenceRemarks,occurrenceRemarks,
54 
dwc_terms_recordNumber,recordNumber/_alt/1,
55 
dwc_terms_recordedBy,recordedBy,
56 
dwc_terms_individualCount,individualCount,
57 
dwc_terms_sex,sex,
58 
dwc_terms_preparations,preparations,
59 
dwc_terms_otherCatalogNumbers,otherCatalogNumbers,
60 
dwc_terms_eventTime,eventTime,
61 
dwc_terms_startDayOfYear,startDayOfYear,
62 
dwc_terms_endDayOfYear,endDayOfYear,
63 
dwc_terms_year,year,
64 
dwc_terms_month,month,
65 
dwc_terms_day,day,
66 
dwc_terms_fieldNumber,recordNumber/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
67 
-----
68 
SELECT count(*) FROM ""SpeciesLink"".specimens
69 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
70 
-----"
71 
dwc_terms_continent,continent,
72 
dwc_terms_country,country,
73 
dwc_terms_stateProvince,stateProvince,
74 
dwc_terms_county,county,
75 
dwc_terms_locality,locality,
76 
dwc_terms_minimumElevationInMeters,minimumElevationInMeters,
77 
dwc_terms_maximumElevationInMeters,maximumElevationInMeters,
78 
dwc_terms_minimumDepthInMeters,minimumDepthInMeters,
79 
dwc_terms_maximumDepthInMeters,maximumDepthInMeters,
80 
dwc_terms_verbatimLatitude,verbatimLatitude,
81 
dwc_terms_verbatimLongitude,verbatimLongitude,
82 
dwc_terms_decimalLatitude,decimalLatitude,
83 
dwc_terms_decimalLongitude,decimalLongitude,
84 
dwc_terms_coordinateUncertaintyInMeters,coordinateUncertaintyInMeters,
85 
dwc_terms_scientificName,scientificName,
86 
dwc_terms_kingdom,kingdom,
87 
dwc_terms_phylum,phylum,
88 
dwc_terms_class,class,
89 
dwc_terms_order,order,
90 
dwc_terms_family,family,
91 
dwc_terms_genus,genus,
92 
dwc_terms_specificEpithet,specificEpithet,
93 
dwc_terms_infraspecificEpithet,infraspecificEpithet,
94 
dwc_terms_scientificNameAuthorship,ScientificNameAuthor/_alt/1,
95 
conceptual_darwin_2003_1_0_DateLastModified,dcterms:modified,
96 
conceptual_darwin_2003_1_0_InstitutionCode,institutionCode,
97 
conceptual_darwin_2003_1_0_CollectionCode,collectionCode,
98 
conceptual_darwin_2003_1_0_CatalogNumber,catalogNumber,
99 
conceptual_darwin_2003_1_0_ScientificName,scientificName,
100 
conceptual_darwin_2003_1_0_BasisOfRecord,BasisOfRecord,
101 
conceptual_darwin_2003_1_0_Kingdom,kingdom,
102 
conceptual_darwin_2003_1_0_Phylum,phylum,
103 
conceptual_darwin_2003_1_0_Class,class,
104 
conceptual_darwin_2003_1_0_Order,order,
105 
conceptual_darwin_2003_1_0_Family,family,
106 
conceptual_darwin_2003_1_0_Genus,genus,
107 
conceptual_darwin_2003_1_0_Species,specificEpithet,
108 
conceptual_darwin_2003_1_0_Subspecies,infraspecificEpithet,
109 
conceptual_darwin_2003_1_0_ScientificNameAuthor,ScientificNameAuthor/_alt/2,
110 
conceptual_darwin_2003_1_0_IdentifiedBy,identifiedBy,
111 
conceptual_darwin_2003_1_0_YearIdentified,yearIdentified,
112 
conceptual_darwin_2003_1_0_MonthIdentified,monthIdentified,
113 
conceptual_darwin_2003_1_0_DayIdentified,dayIdentified,
114 
conceptual_darwin_2003_1_0_TypeStatus,TypeStatus,
115 
conceptual_darwin_2003_1_0_CollectorNumber,recordNumber/_alt/3,
116 
conceptual_darwin_2003_1_0_FieldNumber,recordNumber/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
117 
-----
118 
SELECT count(*) FROM ""SpeciesLink"".specimens
119 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
120 
-----"
121 
conceptual_darwin_2003_1_0_Collector,recordedBy,
122 
conceptual_darwin_2003_1_0_YearCollected,yearCollected,
123 
conceptual_darwin_2003_1_0_MonthCollected,monthCollected,
124 
conceptual_darwin_2003_1_0_DayCollected,dayCollected,
125 
conceptual_darwin_2003_1_0_JulianDay,JulianDay/_alt/1,
126 
conceptual_darwin_2003_1_0_TimeOfDay,eventTime,
127 
conceptual_darwin_2003_1_0_ContinentOcean,continent,
128 
conceptual_darwin_2003_1_0_Country,country,
129 
conceptual_darwin_2003_1_0_StateProvince,stateProvince,
130 
conceptual_darwin_2003_1_0_County,county,
131 
conceptual_darwin_2003_1_0_Locality,locality,
132 
conceptual_darwin_2003_1_0_Longitude,verbatimLongitude,
133 
conceptual_darwin_2003_1_0_Latitude,verbatimLatitude,
134 
conceptual_darwin_2003_1_0_CoordinatePrecision,coordinatePrecision,
135 
conceptual_darwin_2003_1_0_BoundingBox,footprintWKT,
136 
conceptual_darwin_2003_1_0_MinimumElevation,minimumElevationInMeters,
137 
conceptual_darwin_2003_1_0_MaximumElevation,maximumElevationInMeters,
138 
conceptual_darwin_2003_1_0_MinimumDepth,minimumDepthInMeters,
139 
conceptual_darwin_2003_1_0_MaximumDepth,maximumDepthInMeters,
140 
conceptual_darwin_2003_1_0_Sex,sex,
141 
conceptual_darwin_2003_1_0_PreparationType,preparations,
142 
conceptual_darwin_2003_1_0_IndividualCount,individualCount,
143 
conceptual_darwin_2003_1_0_PreviousCatalogNumber,otherCatalogNumbers,
144 
conceptual_darwin_2003_1_0_RelationshipType,relationshipOfResource,
145 
conceptual_darwin_2003_1_0_RelatedCatalogItem,relatedResourceID,
146 
conceptual_darwin_2003_1_0_Notes,fieldNotes,
inputs/SpeciesLink/Specimen/map.full.csv
1 
"SpeciesLink[Veg+,dwc_dwcore_,dwc_curatorial_,dwc_geospatial_,http__purl_org_,dwc_terms_,conceptual_darwin_2003_1_0_]",Veg+,Comments
2 
JulianDay,JulianDay/_alt/1,
3 
DayOfYear,JulianDay/_alt/2,
4 
scientificNameAuthorship,ScientificNameAuthor/_alt/1,
5 
ScientificNameAuthor,ScientificNameAuthor/_alt/2,
6 
AuthorYearOfScientificName,ScientificNameAuthor/_alt/3,
7 
boundingBox,boundingBox
8 
catalogNumber,catalogNumber
9 
class,class
10 
collectionCode,collectionCode
11 
collectionID,collectionID
12 
collector,collector
13 
continent,continent
14 
continentOcean,continentOcean
15 
coordinatePrecision,coordinatePrecision
16 
coordinateUncertaintyInMeters,coordinateUncertaintyInMeters
17 
country,country
18 
county,county
19 
dateIdentified,dateIdentified
20 
dayCollected,dayCollected
21 
dayIdentified,dayIdentified
22 
dc_terms_modified,dcterms:modified,
23 
decimalLatitude,decimalLatitude
24 
decimalLongitude,decimalLongitude
25 
family,family
26 
genus,genus
27 
globalUniqueIdentifier,globalUniqueIdentifier
28 
identifiedBy,identifiedBy
29 
individualCount,individualCount
30 
infraspecificEpithet,infraspecificEpithet
31 
institutionCode,institutionCode
32 
kingdom,kingdom
33 
latitude,latitude
34 
locality,locality
35 
longitude,longitude
36 
maximumDepth,maximumDepth
37 
maximumDepthInMeters,maximumDepthInMeters
38 
maximumElevation,maximumElevation
39 
maximumElevationInMeters,maximumElevationInMeters
40 
minimumDepth,minimumDepth
41 
minimumDepthInMeters,minimumDepthInMeters
42 
minimumElevation,minimumElevation
43 
minimumElevationInMeters,minimumElevationInMeters
44 
monthCollected,monthCollected
45 
monthIdentified,monthIdentified
46 
notes,notes
47 
order,order
48 
phylum,phylum
49 
recordNumber,recordNumber/_alt/1,
50 
FieldNumber,recordNumber/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
1 
SpeciesLink[Veg+],Veg+,Comments
2 
conceptual_darwin_2003_1_0_BasisOfRecord,BasisOfRecord,
3 
dwc_dwcore_BasisOfRecord,BasisOfRecord,
4 
conceptual_darwin_2003_1_0_JulianDay,JulianDay/_alt/1,
5 
dwc_dwcore_DayOfYear,JulianDay/_alt/2,
6 
dwc_terms_scientificNameAuthorship,ScientificNameAuthor/_alt/1,
7 
conceptual_darwin_2003_1_0_ScientificNameAuthor,ScientificNameAuthor/_alt/2,
8 
dwc_dwcore_AuthorYearOfScientificName,ScientificNameAuthor/_alt/3,
9 
conceptual_darwin_2003_1_0_TypeStatus,TypeStatus,
10 
dwc_curatorial_TypeStatus,TypeStatus,
11 
dwc_terms_basisOfRecord,basisOfRecord,
12 
conceptual_darwin_2003_1_0_CatalogNumber,catalogNumber,
13 
dwc_dwcore_CatalogNumber,catalogNumber,
14 
dwc_terms_catalogNumber,catalogNumber,
15 
conceptual_darwin_2003_1_0_Class,class,
16 
dwc_dwcore_Class,class,
17 
dwc_terms_class,class,
18 
conceptual_darwin_2003_1_0_CollectionCode,collectionCode,
19 
dwc_dwcore_CollectionCode,collectionCode,
20 
dwc_terms_collectionCode,collectionCode,
21 
dwc_terms_collectionID,collectionID,
22 
conceptual_darwin_2003_1_0_ContinentOcean,continent,
23 
dwc_dwcore_Continent,continent,
24 
dwc_terms_continent,continent,
25 
conceptual_darwin_2003_1_0_CoordinatePrecision,coordinatePrecision,
26 
dwc_terms_coordinateUncertaintyInMeters,coordinateUncertaintyInMeters,
27 
conceptual_darwin_2003_1_0_Country,country,
28 
dwc_dwcore_Country,country,
29 
dwc_terms_country,country,
30 
conceptual_darwin_2003_1_0_County,county,
31 
dwc_dwcore_County,county,
32 
dwc_terms_county,county,
33 
dwc_terms_dateIdentified,dateIdentified,
34 
dwc_terms_day,day,
35 
conceptual_darwin_2003_1_0_DayCollected,dayCollected,
36 
conceptual_darwin_2003_1_0_DayIdentified,dayIdentified,
37 
conceptual_darwin_2003_1_0_DateLastModified,dcterms:modified,
38 
dwc_dwcore_DateLastModified,dcterms:modified,
39 
http__purl_org_dc_terms_modified,dcterms:modified,
40 
dwc_geospatial_DecimalLatitude,decimalLatitude,
41 
dwc_terms_decimalLatitude,decimalLatitude,
42 
dwc_geospatial_DecimalLongitude,decimalLongitude,
43 
dwc_terms_decimalLongitude,decimalLongitude,
44 
dwc_terms_endDayOfYear,endDayOfYear,
45 
conceptual_darwin_2003_1_0_TimeOfDay,eventTime,
46 
dwc_terms_eventTime,eventTime,
47 
conceptual_darwin_2003_1_0_Family,family,
48 
dwc_dwcore_Family,family,
49 
dwc_terms_family,family,
50 
conceptual_darwin_2003_1_0_Notes,fieldNotes,
51 
conceptual_darwin_2003_1_0_BoundingBox,footprintWKT,
52 
conceptual_darwin_2003_1_0_Genus,genus,
53 
dwc_dwcore_Genus,genus,
54 
dwc_terms_genus,genus,
55 
conceptual_darwin_2003_1_0_IdentifiedBy,identifiedBy,
56 
dwc_curatorial_IdentifiedBy,identifiedBy,
57 
dwc_terms_identifiedBy,identifiedBy,
58 
conceptual_darwin_2003_1_0_IndividualCount,individualCount,
59 
dwc_curatorial_IndividualCount,individualCount,
60 
dwc_terms_individualCount,individualCount,
61 
conceptual_darwin_2003_1_0_Subspecies,infraspecificEpithet,
62 
dwc_dwcore_InfraspecificEpithet,infraspecificEpithet,
63 
dwc_terms_infraspecificEpithet,infraspecificEpithet,
64 
conceptual_darwin_2003_1_0_InstitutionCode,institutionCode,
65 
dwc_dwcore_InstitutionCode,institutionCode,
66 
dwc_terms_institutionCode,institutionCode,
67 
conceptual_darwin_2003_1_0_Kingdom,kingdom,
68 
dwc_dwcore_Kingdom,kingdom,
69 
dwc_terms_kingdom,kingdom,
70 
conceptual_darwin_2003_1_0_Locality,locality,
71 
dwc_dwcore_Locality,locality,
72 
dwc_terms_locality,locality,
73 
conceptual_darwin_2003_1_0_MaximumDepth,maximumDepthInMeters,
74 
dwc_dwcore_MaximumDepthInMeters,maximumDepthInMeters,
75 
dwc_terms_maximumDepthInMeters,maximumDepthInMeters,
76 
conceptual_darwin_2003_1_0_MaximumElevation,maximumElevationInMeters,
77 
dwc_dwcore_MaximumElevationInMeters,maximumElevationInMeters,
78 
dwc_terms_maximumElevationInMeters,maximumElevationInMeters,
79 
conceptual_darwin_2003_1_0_MinimumDepth,minimumDepthInMeters,
80 
dwc_dwcore_MinimumDepthInMeters,minimumDepthInMeters,
81 
dwc_terms_minimumDepthInMeters,minimumDepthInMeters,
82 
conceptual_darwin_2003_1_0_MinimumElevation,minimumElevationInMeters,
83 
dwc_dwcore_MinimumElevationInMeters,minimumElevationInMeters,
84 
dwc_terms_minimumElevationInMeters,minimumElevationInMeters,
85 
dwc_terms_month,month,
86 
conceptual_darwin_2003_1_0_MonthCollected,monthCollected,
87 
conceptual_darwin_2003_1_0_MonthIdentified,monthIdentified,
88 
dwc_dwcore_GlobalUniqueIdentifier,occurrenceID,
89 
dwc_terms_occurrenceRemarks,occurrenceRemarks,
90 
conceptual_darwin_2003_1_0_Order,order,
91 
dwc_dwcore_Order,order,
92 
dwc_terms_order,order,
93 
conceptual_darwin_2003_1_0_PreviousCatalogNumber,otherCatalogNumbers,
94 
dwc_terms_otherCatalogNumbers,otherCatalogNumbers,
95 
conceptual_darwin_2003_1_0_Phylum,phylum,
96 
dwc_dwcore_Phylum,phylum,
97 
dwc_terms_phylum,phylum,
98 
conceptual_darwin_2003_1_0_PreparationType,preparations,
99 
dwc_terms_preparations,preparations,
100 
dwc_terms_recordNumber,recordNumber/_alt/1,
101 
conceptual_darwin_2003_1_0_FieldNumber,recordNumber/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
51 102 
-----
52 103 
SELECT count(*) FROM ""SpeciesLink"".specimens
53 104 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
54 105 
-----"
55 
CollectorNumber,recordNumber/_alt/3,
56 
recordedBy,recordedBy
57 
remarks,remarks
58 
scientificName,scientificName
59 
sex,sex
60 
species,species
61 
specificEpithet,specificEpithet
62 
stateProvince,stateProvince
63 
subspecies,subspecies
64 
verbatimLatitude,verbatimLatitude
65 
verbatimLongitude,verbatimLongitude
66 
yearCollected,yearCollected
67 
yearIdentified,yearIdentified
106 
dwc_curatorial_FieldNumber,recordNumber/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
107 
-----
108 
SELECT count(*) FROM ""SpeciesLink"".specimens
109 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
110 
-----"
111 
dwc_terms_fieldNumber,recordNumber/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
112 
-----
113 
SELECT count(*) FROM ""SpeciesLink"".specimens
114 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
115 
-----"
116 
conceptual_darwin_2003_1_0_CollectorNumber,recordNumber/_alt/3,
117 
dwc_curatorial_CollectorNumber,recordNumber/_alt/3,
118 
conceptual_darwin_2003_1_0_Collector,recordedBy,
119 
dwc_dwcore_Collector,recordedBy,
120 
dwc_terms_recordedBy,recordedBy,
121 
conceptual_darwin_2003_1_0_RelatedCatalogItem,relatedResourceID,
122 
conceptual_darwin_2003_1_0_RelationshipType,relationshipOfResource,
123 
conceptual_darwin_2003_1_0_ScientificName,scientificName,
124 
dwc_dwcore_ScientificName,scientificName,
125 
dwc_terms_scientificName,scientificName,
126 
conceptual_darwin_2003_1_0_Sex,sex,
127 
dwc_dwcore_Sex,sex,
128 
dwc_terms_sex,sex,
129 
conceptual_darwin_2003_1_0_Species,specificEpithet,
130 
dwc_dwcore_SpecificEpithet,specificEpithet,
131 
dwc_terms_specificEpithet,specificEpithet,
132 
dwc_terms_startDayOfYear,startDayOfYear,
133 
conceptual_darwin_2003_1_0_StateProvince,stateProvince,
134 
dwc_dwcore_StateProvince,stateProvince,
135 
dwc_terms_stateProvince,stateProvince,
136 
dwc_dwcore_Remarks,taxonRemarks,
137 
dwc_terms_typeStatus,typeStatus,
138 
conceptual_darwin_2003_1_0_Latitude,verbatimLatitude,
139 
dwc_geospatial_VerbatimLatitude,verbatimLatitude,
140 
dwc_terms_verbatimLatitude,verbatimLatitude,
141 
conceptual_darwin_2003_1_0_Longitude,verbatimLongitude,
142 
dwc_geospatial_VerbatimLongitude,verbatimLongitude,
143 
dwc_terms_verbatimLongitude,verbatimLongitude,
144 
dwc_terms_year,year,
145 
conceptual_darwin_2003_1_0_YearCollected,yearCollected,
146 
conceptual_darwin_2003_1_0_YearIdentified,yearIdentified,
inputs/SpeciesLink/Specimen/VegBIEN.csv
1 
"SpeciesLink[Veg+,dwc_dwcore_,dwc_curatorial_,dwc_geospatial_,http__purl_org_,dwc_terms_,conceptual_darwin_2003_1_0_]",VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
2 
globalUniqueIdentifier,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1",
3 
institutionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/1",
4 
collectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/1",
5 
collectionID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/2",
6 
catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else",
7 
maximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
8 
maximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
9 
minimumElevation,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
10 
minimumElevationInMeters,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
11 
minimumElevation,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
12 
minimumElevationInMeters,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
13 
maximumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
14 
maximumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
15 
minimumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
16 
minimumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
17 
coordinateUncertaintyInMeters,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,
18 
coordinatePrecision,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,
19 
boundingBox,/location/locationdetermination/footprintgeometry_dwc,
20 
decimalLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",
21 
latitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
22 
verbatimLatitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
23 
decimalLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
24 
longitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
25 
verbatimLongitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
26 
county,"/location/locationdetermination/namedplace_id/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
27 
stateProvince,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
28 
country,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
29 
continent,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
30 
continentOcean,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
31 
dayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
32 
monthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
33 
yearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
34 
individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
35 
notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
36 
recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/1,
37 
FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
1 
SpeciesLink[Veg+],VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments
2 
dwc_dwcore_GlobalUniqueIdentifier,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/1",
3 
conceptual_darwin_2003_1_0_InstitutionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/1",
4 
dwc_dwcore_InstitutionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/1",
5 
dwc_terms_institutionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/1",
6 
conceptual_darwin_2003_1_0_CollectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/1",
7 
dwc_dwcore_CollectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/1",
8 
dwc_terms_collectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/1",
9 
dwc_terms_collectionID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/2/_join/2",
10 
conceptual_darwin_2003_1_0_CatalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else",
11 
dwc_dwcore_CatalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else",
12 
dwc_terms_catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_join/3/_if[@name=""if indirect voucher""]/else",
13 
conceptual_darwin_2003_1_0_MaximumElevation,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
14 
dwc_dwcore_MaximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
15 
dwc_terms_maximumElevationInMeters,"/location/elevation/_alt/2/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
16 
conceptual_darwin_2003_1_0_MinimumElevation,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
17 
dwc_dwcore_MinimumElevationInMeters,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
18 
dwc_terms_minimumElevationInMeters,"/location/elevation/_alt/2/_avg/min/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
19 
conceptual_darwin_2003_1_0_MinimumElevation,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
20 
dwc_dwcore_MinimumElevationInMeters,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
21 
dwc_terms_minimumElevationInMeters,"/location/elevationrange/_range/from/_units:[default=m,to=m,to=]/value/_rangeStart/value/_replace:[""\bca\.?""=]/value",
22 
conceptual_darwin_2003_1_0_MaximumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
23 
dwc_dwcore_MaximumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
24 
dwc_terms_maximumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/1/_replace:[""\bca\.?""=]/value",
25 
conceptual_darwin_2003_1_0_MinimumElevation,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
26 
dwc_dwcore_MinimumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
27 
dwc_terms_minimumElevationInMeters,"/location/elevationrange/_range/to/_units:[default=m,to=m,to=]/value/_alt/2/_rangeEnd/value/_replace:[""\bca\.?""=]/value",
28 
dwc_terms_coordinateUncertaintyInMeters,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/1,
29 
conceptual_darwin_2003_1_0_CoordinatePrecision,/location/locationdetermination/coordsaccuracy/_noCV/value/_alt/2,
30 
conceptual_darwin_2003_1_0_BoundingBox,/location/locationdetermination/footprintgeometry_dwc,
31 
dwc_geospatial_DecimalLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",
32 
dwc_terms_decimalLatitude,"/location/locationdetermination/latitude/_alt/1/_nullIf:[null=0,type=float]/value",
33 
conceptual_darwin_2003_1_0_Latitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
34 
dwc_geospatial_VerbatimLatitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
35 
dwc_terms_verbatimLatitude,"/location/locationdetermination/latitude/_alt/2/_nullIf:[null=0,type=float]/value",
36 
dwc_geospatial_DecimalLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
37 
dwc_terms_decimalLongitude,"/location/locationdetermination/longitude/_alt/1/_nullIf:[null=0,type=float]/value",
38 
conceptual_darwin_2003_1_0_Longitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
39 
dwc_geospatial_VerbatimLongitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
40 
dwc_terms_verbatimLongitude,"/location/locationdetermination/longitude/_alt/2/_nullIf:[null=0,type=float]/value",
41 
conceptual_darwin_2003_1_0_County,"/location/locationdetermination/namedplace_id/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
42 
dwc_dwcore_County,"/location/locationdetermination/namedplace_id/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
43 
dwc_terms_county,"/location/locationdetermination/namedplace_id/_forEach:[in:[],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=county]/placename",
44 
conceptual_darwin_2003_1_0_StateProvince,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
45 
dwc_dwcore_StateProvince,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
46 
dwc_terms_stateProvince,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=stateProvince]/placename",
47 
conceptual_darwin_2003_1_0_Country,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
48 
dwc_dwcore_Country,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
49 
dwc_terms_country,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,stateProvince,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=country]/placename",
50 
conceptual_darwin_2003_1_0_ContinentOcean,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
51 
dwc_dwcore_Continent,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
52 
dwc_terms_continent,"/location/locationdetermination/namedplace_id/_forEach:[in:[county,stateProvince,country,],do=""namedplace[rank=_val]/parent_id""]/namedplace[rank=continent]/placename",
53 
conceptual_darwin_2003_1_0_DayCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
54 
conceptual_darwin_2003_1_0_MonthCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
55 
conceptual_darwin_2003_1_0_YearCollected,"/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
56 
conceptual_darwin_2003_1_0_IndividualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
57 
dwc_curatorial_IndividualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
58 
dwc_terms_individualCount,/location/locationevent/taxonoccurrence/aggregateoccurrence/count,
59 
conceptual_darwin_2003_1_0_Notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
60 
dwc_terms_recordNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/1,
61 
conceptual_darwin_2003_1_0_FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
38 62 
-----
39 63 
SELECT count(*) FROM ""SpeciesLink"".specimens
40 64 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
41 65 
-----"
42 
CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/3,
43 
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"
44 
catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
45 
collectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/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
46 
collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/2,
47 
institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
48 
globalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
49 
recordNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1,
50 
FieldNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
66 
dwc_curatorial_FieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
51 67 
-----
52 68 
SELECT count(*) FROM ""SpeciesLink"".specimens
53 69 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
54 70 
-----"
55 
CollectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/3,
56 
scientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2/_alt/2,
57 
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first,
58 
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle,
59 
identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last,
60 
scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",
61 
scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname/_alt/1",
62 
ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname/_alt/2",
63 
AuthorYearOfScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname/_alt/3",
64 
infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last",
65 
subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last",
66 
species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
67 
specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
68 
genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
69 
family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
70 
order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",
71 
class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",
72 
phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",
73 
kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",
74 
dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_*/date/_dateRangeStart/value,
75 
dayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
76 
monthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
77 
yearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
78 
remarks,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/notes,
79 
collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
80 
recordedBy,/location/locationevent/taxonoccurrence/verbatimcollectorname,
81 
catalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
82 
maximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
83 
maximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
84 
minimumDepth,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
85 
minimumDepthInMeters,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
86 
locality,/location/locationnarrative/_merge/1,
87 
DayOfYear,,** No join mapping for JulianDay/_alt/2 **
88 
JulianDay,,** No join mapping for JulianDay/_alt/1 **
89 
dc_terms_modified,,** No join mapping for dcterms:modified **
71 
dwc_terms_fieldNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
72 
-----
73 
SELECT count(*) FROM ""SpeciesLink"".specimens
74 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
75 
-----"
76 
conceptual_darwin_2003_1_0_CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/3,
77 
dwc_curatorial_CollectorNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber/_alt/3,
78 
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"
79 
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"
80 
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"
81 
conceptual_darwin_2003_1_0_CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
82 
dwc_dwcore_CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
83 
dwc_terms_catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
84 
conceptual_darwin_2003_1_0_CollectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/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
85 
dwc_dwcore_CollectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/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
86 
dwc_terms_collectionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/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
87 
dwc_terms_collectionID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectioncode_dwc/_join/2,
88 
conceptual_darwin_2003_1_0_InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
89 
dwc_dwcore_InstitutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
90 
dwc_terms_institutionCode,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname,
91 
dwc_dwcore_GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
92 
dwc_terms_recordNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/1,
93 
conceptual_darwin_2003_1_0_FieldNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
94 
-----
95 
SELECT count(*) FROM ""SpeciesLink"".specimens
96 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
97 
-----"
98 
dwc_curatorial_FieldNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
99 
-----
100 
SELECT count(*) FROM ""SpeciesLink"".specimens
101 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
102 
-----"
103 
dwc_terms_fieldNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
104 
-----
105 
SELECT count(*) FROM ""SpeciesLink"".specimens
106 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
107 
-----"
108 
conceptual_darwin_2003_1_0_CollectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/3,
109 
dwc_curatorial_CollectorNumber,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/1/_alt/3,
110 
conceptual_darwin_2003_1_0_ScientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2/_alt/2,
111 
dwc_dwcore_ScientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2/_alt/2,
112 
dwc_terms_scientificName,/location/locationevent/taxonoccurrence/authortaxoncode/_alt/2/_alt/2,
113 
conceptual_darwin_2003_1_0_IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first,
114 
dwc_curatorial_IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first,
115 
dwc_terms_identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/givenname/_namePart/first,
116 
conceptual_darwin_2003_1_0_IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle,
117 
dwc_curatorial_IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle,
118 
dwc_terms_identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/middlename/_namePart/middle,
119 
conceptual_darwin_2003_1_0_IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last,
120 
dwc_curatorial_IdentifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last,
121 
dwc_terms_identifiedBy,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/party/surname/_namePart/last,
122 
conceptual_darwin_2003_1_0_ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",
123 
dwc_dwcore_ScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",
124 
dwc_terms_scientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[],do=""plantname[rank=_val]/parent_id""]/plantname[rank=binomial]/plantname",
125 
dwc_terms_scientificNameAuthorship,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname/_alt/1",
126 
conceptual_darwin_2003_1_0_ScientificNameAuthor,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname/_alt/2",
127 
dwc_dwcore_AuthorYearOfScientificName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=authority]/plantname/_alt/3",
128 
conceptual_darwin_2003_1_0_Subspecies,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last",
129 
dwc_dwcore_InfraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last",
130 
dwc_terms_infraspecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subspecies]/plantname/_name/last",
131 
conceptual_darwin_2003_1_0_Species,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
132 
dwc_dwcore_SpecificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
133 
dwc_terms_specificEpithet,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=species]/plantname",
134 
conceptual_darwin_2003_1_0_Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
135 
dwc_dwcore_Genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
136 
dwc_terms_genus,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=genus]/plantname",
137 
conceptual_darwin_2003_1_0_Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
138 
dwc_dwcore_Family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
139 
dwc_terms_family,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=family]/plantname",
140 
conceptual_darwin_2003_1_0_Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",
141 
dwc_dwcore_Order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",
142 
dwc_terms_order,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=order]/plantname",
143 
conceptual_darwin_2003_1_0_Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",
144 
dwc_dwcore_Class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",
145 
dwc_terms_class,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=class]/plantname",
146 
conceptual_darwin_2003_1_0_Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",
147 
dwc_dwcore_Phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",
148 
dwc_terms_phylum,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=subkingdom]/plantname",
149 
conceptual_darwin_2003_1_0_Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",
150 
dwc_dwcore_Kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",
151 
dwc_terms_kingdom,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/plantconcept/plantname_id/_forEach:[in:[binomial,authority,subspecies,species,genus,family,order,class,subkingdom,],do=""plantname[rank=_val]/parent_id""]/plantname[rank=kingdom]/plantname",
152 
dwc_terms_dateIdentified,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/1/_*/date/_dateRangeStart/value,
153 
conceptual_darwin_2003_1_0_DayIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/day/_nullIf:[null=0,type=float]/value",
154 
conceptual_darwin_2003_1_0_MonthIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/month/_nullIf:[null=0,type=float]/value",
155 
conceptual_darwin_2003_1_0_YearIdentified,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/determinationdate/_alt/2/_date/year/_nullIf:[null=0,type=float]/value",
156 
dwc_dwcore_Remarks,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/notes,
157 
conceptual_darwin_2003_1_0_Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
158 
dwc_dwcore_Collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
159 
dwc_terms_recordedBy,/location/locationevent/taxonoccurrence/verbatimcollectorname,
160 
conceptual_darwin_2003_1_0_CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
161 
dwc_dwcore_CatalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
162 
dwc_terms_catalogNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
163 
conceptual_darwin_2003_1_0_MaximumDepth,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
164 
dwc_dwcore_MaximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
165 
dwc_terms_maximumDepthInMeters,"/location/locationevent/waterdepth/_avg/max/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
166 
conceptual_darwin_2003_1_0_MinimumDepth,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
167 
dwc_dwcore_MinimumDepthInMeters,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
168 
dwc_terms_minimumDepthInMeters,"/location/locationevent/waterdepth/_avg/min/_units:[default=m,to=m,to=]/value/_replace:[""\bca\.?""=]/value",
169 
conceptual_darwin_2003_1_0_Locality,/location/locationnarrative/_merge/1,
170 
dwc_dwcore_Locality,/location/locationnarrative/_merge/1,
171 
dwc_terms_locality,/location/locationnarrative/_merge/1,
172 
conceptual_darwin_2003_1_0_BasisOfRecord,,** No join mapping for BasisOfRecord **
173 
conceptual_darwin_2003_1_0_DateLastModified,,** No join mapping for dcterms:modified **
174 
conceptual_darwin_2003_1_0_JulianDay,,** No join mapping for JulianDay/_alt/1 **
175 
conceptual_darwin_2003_1_0_PreparationType,,** No join mapping for preparations **
176 
conceptual_darwin_2003_1_0_PreviousCatalogNumber,,** No join mapping for otherCatalogNumbers **
177 
conceptual_darwin_2003_1_0_RelatedCatalogItem,,** No join mapping for relatedResourceID **
178 
conceptual_darwin_2003_1_0_RelationshipType,,** No join mapping for relationshipOfResource **
179 
conceptual_darwin_2003_1_0_TimeOfDay,,** No join mapping for eventTime **
180 
conceptual_darwin_2003_1_0_TypeStatus,,** No join mapping for TypeStatus **
181 
dwc_curatorial_TypeStatus,,** No join mapping for TypeStatus **
182 
dwc_dwcore_BasisOfRecord,,** No join mapping for BasisOfRecord **
183 
dwc_dwcore_DateLastModified,,** No join mapping for dcterms:modified **
184 
dwc_dwcore_DayOfYear,,** No join mapping for JulianDay/_alt/2 **
185 
dwc_terms_basisOfRecord,,** No join mapping for basisOfRecord **
186 
dwc_terms_day,,** No join mapping for day **
187 
dwc_terms_endDayOfYear,,** No join mapping for endDayOfYear **
188 
dwc_terms_eventTime,,** No join mapping for eventTime **
189 
dwc_terms_month,,** No join mapping for month **
190 
dwc_terms_occurrenceRemarks,,** No join mapping for occurrenceRemarks **
191 
dwc_terms_otherCatalogNumbers,,** No join mapping for otherCatalogNumbers **
192 
dwc_terms_preparations,,** No join mapping for preparations **
193 
dwc_terms_startDayOfYear,,** No join mapping for startDayOfYear **
194 
dwc_terms_typeStatus,,** No join mapping for typeStatus **
195 
dwc_terms_year,,** No join mapping for year **
196 
http__purl_org_dc_terms_modified,,** No join mapping for dcterms:modified **
inputs/SpeciesLink/Specimen/test.xml.ref
11 11 
                            <_join>
12 12 
                                <1>
13 13 
                                    <_alt>
14 
                                        <0>$dwc_dwcore_InstitutionCode</0>
15 
                                        <1>$dwc_terms_institutionCode</1>
16 
                                        <2>$conceptual_darwin_2003_1_0_InstitutionCode</2>
14 
                                        <0>$conceptual_darwin_2003_1_0_InstitutionCode</0>
15 
                                        <1>$dwc_dwcore_InstitutionCode</1>
16 
                                        <2>$dwc_terms_institutionCode</2>
17 17 
                                    </_alt>
18 18 
                                </1>
19 19 
                                <2>
20 20 
                                    <_join>
21 21 
                                        <1>
22 22 
                                            <_alt>
23 
                                                <0>$dwc_dwcore_CollectionCode</0>
24 
                                                <1>$dwc_terms_collectionCode</1>
25 
                                                <2>$conceptual_darwin_2003_1_0_CollectionCode</2>
23 
                                                <0>$conceptual_darwin_2003_1_0_CollectionCode</0>
24 
                                                <1>$dwc_dwcore_CollectionCode</1>
25 
                                                <2>$dwc_terms_collectionCode</2>
26 26 
                                            </_alt>
27 27 
                                        </1>
28 28 
                                        <2>$dwc_terms_collectionID</2>
......
30 30 
                                </2>
31 31 
                                <3>
32 32 
                                    <_alt>
33 
                                        <0>$dwc_dwcore_CatalogNumber</0>
34 
                                        <1>$dwc_terms_catalogNumber</1>
35 
                                        <2>$conceptual_darwin_2003_1_0_CatalogNumber</2>
33 
                                        <0>$conceptual_darwin_2003_1_0_CatalogNumber</0>
34 
                                        <1>$dwc_dwcore_CatalogNumber</1>
35 
                                        <2>$dwc_terms_catalogNumber</2>
36 36 
                                    </_alt>
37 37 
                                </3>
38 38 
                            </_join>
......
226 226 
                            <rank>county</rank>
227 227 
                            <placename>
228 228 
                                <_alt>
229 
                                    <0>$dwc_dwcore_County</0>
230 
                                    <1>$dwc_terms_county</1>
231 
                                    <2>$conceptual_darwin_2003_1_0_County</2>
229 
                                    <0>$conceptual_darwin_2003_1_0_County</0>
230 
                                    <1>$dwc_dwcore_County</1>
231 
                                    <2>$dwc_terms_county</2>
232 232 
                                </_alt>
233 233 
                            </placename>
234 234 
                            <parent_id>
......
236 236 
                                    <rank>stateProvince</rank>
237 237 
                                    <placename>
238 238 
                                        <_alt>
239 
                                            <0>$dwc_dwcore_StateProvince</0>
240 
                                            <1>$dwc_terms_stateProvince</1>
241 
                                            <2>$conceptual_darwin_2003_1_0_StateProvince</2>
239 
                                            <0>$conceptual_darwin_2003_1_0_StateProvince</0>
240 
                                            <1>$dwc_dwcore_StateProvince</1>
241 
                                            <2>$dwc_terms_stateProvince</2>
242 242 
                                        </_alt>
243 243 
                                    </placename>
244 244 
                                    <parent_id>
......
246 246 
                                            <rank>country</rank>
247 247 
                                            <placename>
248 248 
                                                <_alt>
249 
                                                    <0>$dwc_dwcore_Country</0>
250 
                                                    <1>$dwc_terms_country</1>
251 
                                                    <2>$conceptual_darwin_2003_1_0_Country</2>
249 
                                                    <0>$conceptual_darwin_2003_1_0_Country</0>
250 
                                                    <1>$dwc_dwcore_Country</1>
251 
                                                    <2>$dwc_terms_country</2>
252 252 
                                                </_alt>
253 253 
                                            </placename>
254 254 
                                            <parent_id>
......
256 256 
                                                    <rank>continent</rank>
257 257 
                                                    <placename>
258 258 
                                                        <_alt>
259 
                                                            <0>$dwc_dwcore_Continent</0>
260 
                                                            <1>$dwc_terms_continent</1>
261 
                                                            <2>$conceptual_darwin_2003_1_0_ContinentOcean</2>
259 
                                                            <0>$conceptual_darwin_2003_1_0_ContinentOcean</0>
260 
                                                            <1>$dwc_dwcore_Continent</1>
261 
                                                            <2>$dwc_terms_continent</2>
262 262 
                                                        </_alt>
263 263 
                                                    </placename>
264 264 
                                                </namedplace>
......
300 300 
                            </collectiondate>
301 301 
                            <count>
302 302 
                                <_alt>
303 
                                    <0>$dwc_curatorial_IndividualCount</0>
304 
                                    <1>$dwc_terms_individualCount</1>
305 
                                    <2>$conceptual_darwin_2003_1_0_IndividualCount</2>
303 
                                    <0>$conceptual_darwin_2003_1_0_IndividualCount</0>
304 
                                    <1>$dwc_curatorial_IndividualCount</1>
305 
                                    <2>$dwc_terms_individualCount</2>
306 306 
                                </_alt>
307 307 
                            </count>
308 308 
                            <notes>$conceptual_darwin_2003_1_0_Notes</notes>
......
312 312 
                                        <1>$dwc_terms_recordNumber</1>
313 313 
                                        <2>
314 314 
                                            <_alt>
315 
                                                <0>$dwc_curatorial_FieldNumber</0>
316 
                                                <1>$dwc_terms_fieldNumber</1>
317 
                                                <2>$conceptual_darwin_2003_1_0_FieldNumber</2>
315 
                                                <0>$conceptual_darwin_2003_1_0_FieldNumber</0>
316 
                                                <1>$dwc_curatorial_FieldNumber</1>
317 
                                                <2>$dwc_terms_fieldNumber</2>
318 318 
                                            </_alt>
319 319 
                                        </2>
320 320 
                                        <3>
321 321 
                                            <_alt>
322 
                                                <0>$dwc_curatorial_CollectorNumber</0>
323 
                                                <1>$conceptual_darwin_2003_1_0_CollectorNumber</1>
322 
                                                <0>$conceptual_darwin_2003_1_0_CollectorNumber</0>
323 
                                                <1>$dwc_curatorial_CollectorNumber</1>
324 324 
                                            </_alt>
325 325 
                                        </3>
326 326 
                                    </_alt>
......
334 334 
                                    </userdefined_id>
335 335 
                                    <definedvalue>
336 336 
                                        <_alt>
337 
                                            <0>$dwc_dwcore_Sex</0>
338 
                                            <1>$dwc_terms_sex</1>
339 
                                            <2>$conceptual_darwin_2003_1_0_Sex</2>
337 
                                            <0>$conceptual_darwin_2003_1_0_Sex</0>
338 
                                            <1>$dwc_dwcore_Sex</1>
339 
                                            <2>$dwc_terms_sex</2>
340 340 
                                        </_alt>
341 341 
                                    </definedvalue>
342 342 
                                </definedvalue>
343 343 
                                <specimenreplicate>
344 344 
                                    <catalognumber_dwc>
345 345 
                                        <_alt>
346 
                                            <0>$dwc_dwcore_CatalogNumber</0>
347 
                                            <1>$dwc_terms_catalogNumber</1>
348 
                                            <2>$conceptual_darwin_2003_1_0_CatalogNumber</2>
346 
                                            <0>$conceptual_darwin_2003_1_0_CatalogNumber</0>
347 
                                            <1>$dwc_dwcore_CatalogNumber</1>
348 
                                            <2>$dwc_terms_catalogNumber</2>
349 349 
                                        </_alt>
350 350 
                                    </catalognumber_dwc>
351 351 
                                    <collectioncode_dwc>
352 352 
                                        <_join>
353 353 
                                            <1>
354 354 
                                                <_alt>
355 
                                                    <0>$dwc_dwcore_CollectionCode</0>
356 
                                                    <1>$dwc_terms_collectionCode</1>
357 
                                                    <2>$conceptual_darwin_2003_1_0_CollectionCode</2>
355 
                                                    <0>$conceptual_darwin_2003_1_0_CollectionCode</0>
356 
                                                    <1>$dwc_dwcore_CollectionCode</1>
357 
                                                    <2>$dwc_terms_collectionCode</2>
358 358 
                                                </_alt>
359 359 
                                            </1>
360 360 
                                            <2>$dwc_terms_collectionID</2>
......
364 364 
                                        <party>
365 365 
                                            <organizationname>
366 366 
                                                <_alt>
367 
                                                    <0>$dwc_dwcore_InstitutionCode</0>
368 
                                                    <1>$dwc_terms_institutionCode</1>
369 
                                                    <2>$conceptual_darwin_2003_1_0_InstitutionCode</2>
367 
                                                    <0>$conceptual_darwin_2003_1_0_InstitutionCode</0>
368 
                                                    <1>$dwc_dwcore_InstitutionCode</1>
369 
                                                    <2>$dwc_terms_institutionCode</2>
370 370 
                                                </_alt>
371 371 
                                            </organizationname>
372 372 
                                        </party>
......
382 382 
                                        <1>$dwc_terms_recordNumber</1>
383 383 
                                        <2>
384 384 
                                            <_alt>
385 
                                                <0>$dwc_curatorial_FieldNumber</0>
386 
                                                <1>$dwc_terms_fieldNumber</1>
387 
                                                <2>$conceptual_darwin_2003_1_0_FieldNumber</2>
385 
                                                <0>$conceptual_darwin_2003_1_0_FieldNumber</0>
386 
                                                <1>$dwc_curatorial_FieldNumber</1>
387 
                                                <2>$dwc_terms_fieldNumber</2>
388 388 
                                            </_alt>
389 389 
                                        </2>
390 390 
                                        <3>
391 391 
                                            <_alt>
392 
                                                <0>$dwc_curatorial_CollectorNumber</0>
393 
                                                <1>$conceptual_darwin_2003_1_0_CollectorNumber</1>
392 
                                                <0>$conceptual_darwin_2003_1_0_CollectorNumber</0>
393 
                                                <1>$dwc_curatorial_CollectorNumber</1>
394 394 
                                            </_alt>
395 395 
                                        </3>
396 396 
                                    </_alt>
397 397 
                                </1>
398 398 
                                <2>
399 399 
                                    <_alt>
400 
                                        <0>$dwc_dwcore_ScientificName</0>
401 
                                        <1>$dwc_terms_scientificName</1>
402 
                                        <2>$conceptual_darwin_2003_1_0_ScientificName</2>
400 
                                        <0>$conceptual_darwin_2003_1_0_ScientificName</0>
401 
                                        <1>$dwc_dwcore_ScientificName</1>
402 
                                        <2>$dwc_terms_scientificName</2>
403 403 
                                    </_alt>
404 404 
                                </2>
405 405 
                            </_alt>
......
411 411 
                                        <_namePart>
412 412 
                                            <first>
413 413 
                                                <_alt>
414 
                                                    <0>$dwc_curatorial_IdentifiedBy</0>
415 
                                                    <1>$dwc_terms_identifiedBy</1>
416 
                                                    <2>$conceptual_darwin_2003_1_0_IdentifiedBy</2>
414 
                                                    <0>$conceptual_darwin_2003_1_0_IdentifiedBy</0>
415 
                                                    <1>$dwc_curatorial_IdentifiedBy</1>
416 
                                                    <2>$dwc_terms_identifiedBy</2>
417 417 
                                                </_alt>
418 418 
                                            </first>
419 419 
                                        </_namePart>
......
422 422 
                                        <_namePart>
423 423 
                                            <middle>
424 424 
                                                <_alt>
425 
                                                    <0>$dwc_curatorial_IdentifiedBy</0>
426 
                                                    <1>$dwc_terms_identifiedBy</1>
427 
                                                    <2>$conceptual_darwin_2003_1_0_IdentifiedBy</2>
425 
                                                    <0>$conceptual_darwin_2003_1_0_IdentifiedBy</0>
426 
                                                    <1>$dwc_curatorial_IdentifiedBy</1>
427 
                                                    <2>$dwc_terms_identifiedBy</2>
428 428 
                                                </_alt>
429 429 
                                            </middle>
430 430 
                                        </_namePart>
......
433 433 
                                        <_namePart>
434 434 
                                            <last>
435 435 
                                                <_alt>
436 
                                                    <0>$dwc_curatorial_IdentifiedBy</0>
437 
                                                    <1>$dwc_terms_identifiedBy</1>
438 
                                                    <2>$conceptual_darwin_2003_1_0_IdentifiedBy</2>
436 
                                                    <0>$conceptual_darwin_2003_1_0_IdentifiedBy</0>
437 
                                                    <1>$dwc_curatorial_IdentifiedBy</1>
438 
                                                    <2>$dwc_terms_identifiedBy</2>
439 439 
                                                </_alt>
440 440 
                                            </last>
441 441 
                                        </_namePart>
......
449 449 
                                            <rank>binomial</rank>
450 450 
                                            <plantname>
451 451 
                                                <_alt>
452 
                                                    <0>$dwc_dwcore_ScientificName</0>
453 
                                                    <1>$dwc_terms_scientificName</1>
454 
                                                    <2>$conceptual_darwin_2003_1_0_ScientificName</2>
452 
                                                    <0>$conceptual_darwin_2003_1_0_ScientificName</0>
453 
                                                    <1>$dwc_dwcore_ScientificName</1>
454 
                                                    <2>$dwc_terms_scientificName</2>
455 455 
                                                </_alt>
456 456 
                                            </plantname>
457 457 
                                            <parent_id>
......
469 469 
                                                            <rank>subspecies</rank>
470 470 
                                                            <plantname>
471 471 
                                                                <_alt>
472 
                                                                    <0>$dwc_dwcore_InfraspecificEpithet</0>
473 
                                                                    <1>$dwc_terms_infraspecificEpithet</1>
474 
                                                                    <2>$conceptual_darwin_2003_1_0_Subspecies</2>
472 
                                                                    <0>$conceptual_darwin_2003_1_0_Subspecies</0>
473 
                                                                    <1>$dwc_dwcore_InfraspecificEpithet</1>
474 
                                                                    <2>$dwc_terms_infraspecificEpithet</2>
475 475 
                                                                </_alt>
476 476 
                                                            </plantname>
477 477 
                                                            <parent_id>
......
489 489 
                                                                            <rank>genus</rank>
490 490 
                                                                            <plantname>
491 491 
                                                                                <_alt>
492 
                                                                                    <0>$dwc_dwcore_Genus</0>
493 
                                                                                    <1>$dwc_terms_genus</1>
494 
                                                                                    <2>$conceptual_darwin_2003_1_0_Genus</2>
492 
                                                                                    <0>$conceptual_darwin_2003_1_0_Genus</0>
493 
                                                                                    <1>$dwc_dwcore_Genus</1>
494 
                                                                                    <2>$dwc_terms_genus</2>
495 495 
                                                                                </_alt>
496 496 
                                                                            </plantname>
497 497 
                                                                            <parent_id>
......
499 499 
                                                                                    <rank>family</rank>
500 500 
                                                                                    <plantname>
501 501 
                                                                                        <_alt>
502 
                                                                                            <0>$dwc_dwcore_Family</0>
503 
                                                                                            <1>$dwc_terms_family</1>
504 
                                                                                            <2>$conceptual_darwin_2003_1_0_Family</2>
502 
                                                                                            <0>$conceptual_darwin_2003_1_0_Family</0>
503 
                                                                                            <1>$dwc_dwcore_Family</1>
504 
                                                                                            <2>$dwc_terms_family</2>
505 505 
                                                                                        </_alt>
506 506 
                                                                                    </plantname>
507 507 
                                                                                    <parent_id>
......
509 509 
                                                                                            <rank>order</rank>
510 510 
                                                                                            <plantname>
511 511 
                                                                                                <_alt>
512 
                                                                                                    <0>$dwc_dwcore_Order</0>
513 
                                                                                                    <1>$dwc_terms_order</1>
514 
                                                                                                    <2>$conceptual_darwin_2003_1_0_Order</2>
512 
                                                                                                    <0>$conceptual_darwin_2003_1_0_Order</0>
513 
                                                                                                    <1>$dwc_dwcore_Order</1>
514 
                                                                                                    <2>$dwc_terms_order</2>
515 515 
                                                                                                </_alt>
516 516 
                                                                                            </plantname>
517 517 
                                                                                            <parent_id>
......
519 519 
                                                                                                    <rank>class</rank>
520 520 
                                                                                                    <plantname>
521 521 
                                                                                                        <_alt>
522 
                                                                                                            <0>$dwc_dwcore_Class</0>
523 
                                                                                                            <1>$dwc_terms_class</1>
524 
                                                                                                            <2>$conceptual_darwin_2003_1_0_Class</2>
522 
                                                                                                            <0>$conceptual_darwin_2003_1_0_Class</0>
523 
                                                                                                            <1>$dwc_dwcore_Class</1>
524 
                                                                                                            <2>$dwc_terms_class</2>
525 525 
                                                                                                        </_alt>
526 526 
                                                                                                    </plantname>
527 527 
                                                                                                    <parent_id>
......
529 529 
                                                                                                            <rank>subkingdom</rank>
530 530 
                                                                                                            <plantname>
531 531 
                                                                                                                <_alt>
532 
                                                                                                                    <0>$dwc_dwcore_Phylum</0>
533 
                                                                                                                    <1>$dwc_terms_phylum</1>
534 
                                                                                                                    <2>$conceptual_darwin_2003_1_0_Phylum</2>
532 
                                                                                                                    <0>$conceptual_darwin_2003_1_0_Phylum</0>
533 
                                                                                                                    <1>$dwc_dwcore_Phylum</1>
534 
                                                                                                                    <2>$dwc_terms_phylum</2>
535 535 
                                                                                                                </_alt>
536 536 
                                                                                                            </plantname>
537 537 
                                                                                                            <parent_id>
......
539 539 
                                                                                                                    <rank>kingdom</rank>
540 540 
                                                                                                                    <plantname>
541 541 
                                                                                                                        <_alt>
542 
                                                                                                                            <0>$dwc_dwcore_Kingdom</0>
543 
                                                                                                                            <1>$dwc_terms_kingdom</1>
544 
                                                                                                                            <2>$conceptual_darwin_2003_1_0_Kingdom</2>
542 
                                                                                                                            <0>$conceptual_darwin_2003_1_0_Kingdom</0>
543 
                                                                                                                            <1>$dwc_dwcore_Kingdom</1>
544 
                                                                                                                            <2>$dwc_terms_kingdom</2>
545 545 
                                                                                                                        </_alt>
546 546 
                                                                                                                    </plantname>
547 547 
                                                                                                                </plantname>
......
600 600 
                        </taxondetermination>
601 601 
                        <verbatimcollectorname>
602 602 
                            <_alt>
603 
                                <0>$dwc_dwcore_Collector</0>
604 
                                <1>$conceptual_darwin_2003_1_0_Collector</1>
603 
                                <0>$conceptual_darwin_2003_1_0_Collector</0>
604 
                                <1>$dwc_dwcore_Collector</1>
605 605 
                                <2>$dwc_terms_recordedBy</2>
606 606 
                            </_alt>
607 607 
                        </verbatimcollectorname>
......
651 651 
                </locationevent>
652 652 
                <locationnarrative>
653 653 
                    <_alt>
654 
                        <0>$dwc_dwcore_Locality</0>
655 
                        <1>$dwc_terms_locality</1>
656 
                        <2>$conceptual_darwin_2003_1_0_Locality</2>
654 
                        <0>$conceptual_darwin_2003_1_0_Locality</0>
655 
                        <1>$dwc_dwcore_Locality</1>
656 
                        <2>$dwc_terms_locality</2>
657 657 
                    </_alt>
658 658 
                </locationnarrative>
659 659 
            </location>
inputs/SpeciesLink/Specimen/new_terms.csv
1 
AuthorYearOfScientificName
2 
DayOfYear
1 
dwc_dwcore_GlobalUniqueIdentifier
2 
dwc_dwcore_DateLastModified
3 
dwc_dwcore_BasisOfRecord
4 
dwc_dwcore_InstitutionCode
5 
dwc_dwcore_CollectionCode
6 
dwc_dwcore_CatalogNumber
7 
dwc_dwcore_Remarks
8 
dwc_dwcore_ScientificName
9 
dwc_dwcore_Kingdom
10 
dwc_dwcore_Phylum
11 
dwc_dwcore_Class
12 
dwc_dwcore_Order
13 
dwc_dwcore_Family
14 
dwc_dwcore_Genus
15 
dwc_dwcore_SpecificEpithet
16 
dwc_dwcore_InfraspecificEpithet
17 
dwc_dwcore_AuthorYearOfScientificName
18 
dwc_dwcore_Continent
19 
dwc_dwcore_Country
20 
dwc_dwcore_StateProvince
21 
dwc_dwcore_County
22 
dwc_dwcore_Locality
23 
dwc_dwcore_MinimumElevationInMeters
24 
dwc_dwcore_MaximumElevationInMeters
25 
dwc_dwcore_MinimumDepthInMeters
26 
dwc_dwcore_MaximumDepthInMeters
27 
dwc_dwcore_DayOfYear
28 
dwc_dwcore_Collector
29 
dwc_dwcore_Sex
30 
dwc_curatorial_IdentifiedBy
31 
dwc_curatorial_CollectorNumber
32 
dwc_curatorial_FieldNumber
33 
dwc_curatorial_TypeStatus
34 
dwc_curatorial_IndividualCount
35 
dwc_geospatial_DecimalLatitude
36 
dwc_geospatial_DecimalLongitude
37 
dwc_geospatial_VerbatimLatitude
38 
dwc_geospatial_VerbatimLongitude
39 
http__purl_org_dc_terms_modified
40 
dwc_terms_collectionID
41 
dwc_terms_institutionCode
42 
dwc_terms_collectionCode
43 
dwc_terms_basisOfRecord
44 
dwc_terms_identifiedBy
45 
dwc_terms_dateIdentified
46 
dwc_terms_typeStatus
47 
dwc_terms_catalogNumber
48 
dwc_terms_occurrenceRemarks
49 
dwc_terms_recordNumber
50 
dwc_terms_recordedBy
51 
dwc_terms_individualCount
52 
dwc_terms_sex
53 
dwc_terms_preparations
54 
dwc_terms_otherCatalogNumbers
55 
dwc_terms_eventTime
56 
dwc_terms_startDayOfYear
57 
dwc_terms_endDayOfYear
58 
dwc_terms_year
59 
dwc_terms_month
60 
dwc_terms_day
61 
dwc_terms_fieldNumber
62 
dwc_terms_continent
63 
dwc_terms_country
64 
dwc_terms_stateProvince
65 
dwc_terms_county
66 
dwc_terms_locality
67 
dwc_terms_minimumElevationInMeters
68 
dwc_terms_maximumElevationInMeters
69 
dwc_terms_minimumDepthInMeters
70 
dwc_terms_maximumDepthInMeters
71 
dwc_terms_verbatimLatitude
72 
dwc_terms_verbatimLongitude
73 
dwc_terms_decimalLatitude
74 
dwc_terms_decimalLongitude
75 
dwc_terms_coordinateUncertaintyInMeters
76 
dwc_terms_scientificName
77 
dwc_terms_kingdom
78 
dwc_terms_phylum
79 
dwc_terms_class
80 
dwc_terms_order
81 
dwc_terms_family
82 
dwc_terms_genus
83 
dwc_terms_specificEpithet
84 
dwc_terms_infraspecificEpithet
85 
dwc_terms_scientificNameAuthorship
86 
conceptual_darwin_2003_1_0_DateLastModified
87 
conceptual_darwin_2003_1_0_InstitutionCode
88 
conceptual_darwin_2003_1_0_CollectionCode
89 
conceptual_darwin_2003_1_0_CatalogNumber
90 
conceptual_darwin_2003_1_0_ScientificName
91 
conceptual_darwin_2003_1_0_BasisOfRecord
92 
conceptual_darwin_2003_1_0_Kingdom
93 
conceptual_darwin_2003_1_0_Phylum
94 
conceptual_darwin_2003_1_0_Class
95 
conceptual_darwin_2003_1_0_Order
96 
conceptual_darwin_2003_1_0_Family
97 
conceptual_darwin_2003_1_0_Genus
98 
conceptual_darwin_2003_1_0_Species
99 
conceptual_darwin_2003_1_0_Subspecies
100 
conceptual_darwin_2003_1_0_ScientificNameAuthor
101 
conceptual_darwin_2003_1_0_IdentifiedBy
102 
conceptual_darwin_2003_1_0_YearIdentified
103 
conceptual_darwin_2003_1_0_MonthIdentified
104 
conceptual_darwin_2003_1_0_DayIdentified
105 
conceptual_darwin_2003_1_0_TypeStatus
106 
conceptual_darwin_2003_1_0_CollectorNumber
107 
conceptual_darwin_2003_1_0_FieldNumber
108 
conceptual_darwin_2003_1_0_Collector
109 
conceptual_darwin_2003_1_0_YearCollected
110 
conceptual_darwin_2003_1_0_MonthCollected
111 
conceptual_darwin_2003_1_0_DayCollected
112 
conceptual_darwin_2003_1_0_JulianDay
113 
conceptual_darwin_2003_1_0_TimeOfDay
114 
conceptual_darwin_2003_1_0_ContinentOcean
115 
conceptual_darwin_2003_1_0_Country
116 
conceptual_darwin_2003_1_0_StateProvince
117 
conceptual_darwin_2003_1_0_County
118 
conceptual_darwin_2003_1_0_Locality
119 
conceptual_darwin_2003_1_0_Longitude
120 
conceptual_darwin_2003_1_0_Latitude
121 
conceptual_darwin_2003_1_0_CoordinatePrecision
122 
conceptual_darwin_2003_1_0_BoundingBox
123 
conceptual_darwin_2003_1_0_MinimumElevation
124 
conceptual_darwin_2003_1_0_MaximumElevation
125 
conceptual_darwin_2003_1_0_MinimumDepth
126 
conceptual_darwin_2003_1_0_MaximumDepth
127 
conceptual_darwin_2003_1_0_Sex
128 
conceptual_darwin_2003_1_0_PreparationType
129 
conceptual_darwin_2003_1_0_IndividualCount
130 
conceptual_darwin_2003_1_0_PreviousCatalogNumber
131 
conceptual_darwin_2003_1_0_RelationshipType
132 
conceptual_darwin_2003_1_0_RelatedCatalogItem
133 
conceptual_darwin_2003_1_0_Notes
inputs/SpeciesLink/Specimen/unmapped_terms.csv
1 
dcterms:modified
2 
BasisOfRecord
1 3 
ScientificNameAuthor/_alt/3
2 
ScientificNameAuthor/_alt/2
3 
ScientificNameAuthor/_alt/1
4 4 
JulianDay/_alt/2
5 
JulianDay/_alt/1
6 5 
recordNumber/_alt/3
7 6 
recordNumber/_alt/2
7 
TypeStatus
8 
dcterms:modified
9 
basisOfRecord
10 
typeStatus
11 
occurrenceRemarks
8 12 
recordNumber/_alt/1
13 
preparations
14 
otherCatalogNumbers
15 
eventTime
16 
startDayOfYear
17 
endDayOfYear
18 
year
19 
month
20 
day
21 
recordNumber/_alt/2
22 
ScientificNameAuthor/_alt/1
9 23 
dcterms:modified
24 
BasisOfRecord
25 
ScientificNameAuthor/_alt/2
26 
TypeStatus
27 
recordNumber/_alt/3
28 
recordNumber/_alt/2
29 
JulianDay/_alt/1
30 
eventTime
31 
preparations
32 
otherCatalogNumbers
33 
relationshipOfResource
34 
relatedResourceID

Also available in: Unified diff