Project

General

Profile

« Previous | Next » 

Revision 7527

Added by Aaron Marcuse-Kubitza about 12 years ago

mappings/VegCore.htm: Regenerated from wiki. Brad's new DwC ID terms spreadsheet has now been added, and a number of the ID terms clarified, disambiguated, and recategorized. In particular, institutionCode has now been split into the custodialInstitutions and collectingInstitution, to differentiate between which institution has the specimen vs. stamped the specimen. This distinction is important because the catalogNumber, stamped on the specimen, is only unique within the collectingInstitution. Most datasources don't unambiguously specify which institution their institutionCode is referring to, so it has been assumed to be custodialInstitutions unless a data dictionary says otherwise (as is the case for UNCC). In addition, a MatchedTaxonDetermination table has been added with the *_matched fields from TNRS.

View differences:

inputs/SpeciesLink/Specimen/new_terms.csv
1 1 
dwc_dwcore_GlobalUniqueIdentifier,occurrenceID,,
2 2 
dwc_dwcore_DateLastModified,modified,,
3 3 
dwc_dwcore_BasisOfRecord,basisOfRecord,,
4 
dwc_dwcore_InstitutionCode,institutionCode,,
5 
dwc_dwcore_CollectionCode,collectionCode,,
4 
dwc_dwcore_InstitutionCode,custodialInstitutions,,
5 
dwc_dwcore_CollectionCode,collection,,
6 6 
dwc_dwcore_CatalogNumber,catalogNumber,,
7 7 
dwc_dwcore_Remarks,taxonRemarks,,
8 8 
dwc_dwcore_ScientificName,taxonName,,
......
28 28 
dwc_dwcore_Collector,recordedBy,,
29 29 
dwc_dwcore_Sex,sex,,
30 30 
dwc_curatorial_IdentifiedBy,identifiedBy,,
31 
dwc_curatorial_CollectorNumber,recordNumber,/_alt/3,
32 
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)
31 
dwc_curatorial_CollectorNumber,collectorNumber,/_alt/3,
32 
dwc_curatorial_FieldNumber,collectorNumber,/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
33 33 
-----
34 34 
SELECT count(*) FROM ""SpeciesLink"".specimens
35 35 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
......
42 42 
dwc_geospatial_VerbatimLongitude,verbatimLongitude,,Contains a mix of DMS and other verbatim coordinates
43 43 
http__purl_org_dc_terms_modified,modified,,
44 44 
dwc_terms_collectionID,collectionID,,
45 
dwc_terms_institutionCode,institutionCode,,
46 
dwc_terms_collectionCode,collectionCode,,
45 
dwc_terms_institutionCode,custodialInstitutions,,
46 
dwc_terms_collectionCode,collection,,
47 47 
dwc_terms_basisOfRecord,basisOfRecord,,
48 48 
dwc_terms_identifiedBy,identifiedBy,,
49 49 
dwc_terms_dateIdentified,dateIdentified,,
50 50 
dwc_terms_typeStatus,typeStatus,,
51 51 
dwc_terms_catalogNumber,catalogNumber,,
52 52 
dwc_terms_occurrenceRemarks,occurrenceRemarks,,
53 
dwc_terms_recordNumber,recordNumber,/_alt/1,
53 
dwc_terms_recordNumber,collectorNumber,/_alt/1,
54 54 
dwc_terms_recordedBy,recordedBy,,
55 55 
dwc_terms_individualCount,individualCount,,
56 56 
dwc_terms_sex,sex,,
......
62 62 
dwc_terms_year,year,,
63 63 
dwc_terms_month,month,,
64 64 
dwc_terms_day,day,,
65 
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)
65 
dwc_terms_fieldNumber,collectorNumber,/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
66 66 
-----
67 67 
SELECT count(*) FROM ""SpeciesLink"".specimens
68 68 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
......
92 92 
dwc_terms_infraspecificEpithet,infraspecificEpithet,,
93 93 
dwc_terms_scientificNameAuthorship,scientificNameAuthorship,/_alt/1,
94 94 
conceptual_darwin_2003_1_0_DateLastModified,modified,,
95 
conceptual_darwin_2003_1_0_InstitutionCode,institutionCode,,
96 
conceptual_darwin_2003_1_0_CollectionCode,collectionCode,,
95 
conceptual_darwin_2003_1_0_InstitutionCode,custodialInstitutions,,
96 
conceptual_darwin_2003_1_0_CollectionCode,collection,,
97 97 
conceptual_darwin_2003_1_0_CatalogNumber,catalogNumber,,
98 98 
conceptual_darwin_2003_1_0_ScientificName,taxonName,,
99 99 
conceptual_darwin_2003_1_0_BasisOfRecord,basisOfRecord,,
......
111 111 
conceptual_darwin_2003_1_0_MonthIdentified,monthIdentified,,
112 112 
conceptual_darwin_2003_1_0_DayIdentified,dayIdentified,,
113 113 
conceptual_darwin_2003_1_0_TypeStatus,typeStatus,,
114 
conceptual_darwin_2003_1_0_CollectorNumber,recordNumber,/_alt/3,
115 
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)
114 
conceptual_darwin_2003_1_0_CollectorNumber,collectorNumber,/_alt/3,
115 
conceptual_darwin_2003_1_0_FieldNumber,collectorNumber,/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
116 116 
-----
117 117 
SELECT count(*) FROM ""SpeciesLink"".specimens
118 118 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
inputs/NY/Specimen/map.csv
1 1 
NY,VegCore,Filter,Comments
2 2 
key,OMIT,,UniqueNYInternalRecordNumber is a better pkey
3 3 
DateLastModified,modified,,
4 
InstitutionCode,institutionCode,,
5 
CollectionCode,collectionCode,,
4 
InstitutionCode,custodialInstitutions,,
5 
CollectionCode,collection,,
6 6 
CatalogNumber,catalogNumber,,
7 7 
ScientificName,taxonName,,
8 8 
BasisOfRecord,basisOfRecord,,
......
21 21 
DayIdentified,dayIdentified,,
22 22 
TypeStatus,typeStatus,,
23 23 
CollectorNumber,UNUSED,,
24 
FieldNumber,recordNumber,,Usage inconsistent with DwC definition
24 
FieldNumber,collectorNumber,,Usage inconsistent with DwC definition
25 25 
Collector,recordedBy,,
26 26 
YearCollected,yearCollected,,
27 27 
MonthCollected,monthCollected,,
inputs/Madidi/IndividualObservation/test.xml.ref
43 43 
                                        <authorplantcode>$Tree</authorplantcode>
44 44 
                                        <specimenreplicate>
45 45 
                                            <catalognumber_dwc>$SpecimenID</catalognumber_dwc>
46 
                                            <collectionnumber>$CollectionNumber</collectionnumber>
46 47 
                                            <institution_id>
47 48 
                                                <sourcelist>
48 49 
                                                    <name>$Institutions</name>
inputs/UNCC/Specimen/map.csv
8 8 
GROUP BY herbarium, accession
9 9 
HAVING count(*) > 1
10 10 
-----"
11 
herbarium,institutionCode,,
11 
herbarium,collectingInstitution,,"""The name or acronym in use by the institution that donated the collection"" (https://projects.nceas.ucsb.edu/nceas/attachments/download/593/UNCC-validation-Peet.xlsx#institutionCode)"
12 12 
family,family,,
13 13 
genus,genus,,
14 14 
species,specificEpithet,,
......
21 21 
collector1,recordedBy,/_join/2,
22 22 
collector2,recordedBy,/_join/3,
23 23 
collector3,recordedBy,/_join/4,
24 
collectno,recordNumber,,
24 
collectno,collectorNumber,,
25 25 
collmonth,monthCollected,,
26 26 
collday,dayCollected,,
27 27 
collyear,yearCollected,,
inputs/JBM/Specimen/unmapped_terms.csv
6 6 
rightsHolder
7 7 
nomenclaturalCode
8 8 
dynamicProperties
9 
datasetName
9 
dataset
10 10 
type
11 11 
datasetID
12 12 
countryCode
inputs/UBC/Specimen/VegBIEN.csv
88 88 
basisOfRecord,,** No join mapping for basisOfRecord **
89 89 
bibliographicCitation,,** No join mapping for bibliographicCitation **
90 90 
datasetID,,** No join mapping for datasetID **
91 
datasetName,,** No join mapping for datasetName **
91 
datasetName,,** No join mapping for dataset **
92 92 
disposition,,** No join mapping for disposition **
93 93 
geodeticDatum,,** No join mapping for geodeticDatum **
94 94 
georeferenceSources,,** No join mapping for georeferenceSources **
inputs/HIBG/Specimen/map.csv
1 1 
HIBG,VegCore,Filter,Comments
2 
id,datasourceRecordID,,
2 
id,dataProviderRecordID,,
3 3 
county,county,,
4 4 
dateIdentified,dateIdentified,,
5 5 
rightsHolder,rightsHolder,,
......
22 22 
georeferenceSources,georeferenceSources,,
23 23 
identifiedBy,identifiedBy,,
24 24 
locality,locality,,
25 
datasetName,datasetName,,
25 
datasetName,dataset,,
26 26 
bibliographicCitation,bibliographicCitation,,
27 27 
datasetID,datasetID,,
28 
institutionCode,institutionCode,,
29 
recordNumber,recordNumber,,
28 
institutionCode,custodialInstitutions,,
29 
recordNumber,collectorNumber,,
30 30 
order,order,,
31 31 
kingdom,kingdom,,
32 32 
specificEpithet,specificEpithet,,
......
54 54 
scientificName,scientificName,,
55 55 
verbatimElevation,verbatimElevation,,
56 56 
scientificNameAuthorship,scientificNameAuthorship,,
57 
collectionCode,collectionCode,,
57 
collectionCode,collection,,
58 58 
language,language,,
59 59 
ownerInstitutionCode,ownerInstitutionCode,,
60 60 
class,class,,
inputs/HIBG/Specimen/unmapped_terms.csv
6 6 
dynamicProperties
7 7 
basisOfRecord
8 8 
georeferenceSources
9 
datasetName
9 
dataset
10 10 
bibliographicCitation
11 11 
datasetID
12 12 
informationWithheld
inputs/SpeciesLink/Specimen/VegBIEN.csv
14 14 
dwc_dwcore_CatalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/cond/_exists",
15 15 
dwc_dwcore_GlobalUniqueIdentifier,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/cond/_exists",
16 16 
dwc_terms_catalogNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/cond/_exists",
17 
conceptual_darwin_2003_1_0_InstitutionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/then",
18 
dwc_dwcore_InstitutionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/then",
19 
dwc_terms_institutionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/then",
17 
conceptual_darwin_2003_1_0_InstitutionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/then/_first/2",
18 
dwc_dwcore_InstitutionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/then/_first/2",
19 
dwc_terms_institutionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/then/_first/2",
20 20 
conceptual_darwin_2003_1_0_CollectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/1",
21 21 
dwc_dwcore_CollectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/1",
22 22 
dwc_terms_collectionCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/2/_join/1",
......
114 114 
dwc_dwcore_CatalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
115 115 
dwc_dwcore_GlobalUniqueIdentifier,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
116 116 
dwc_terms_catalogNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
117 
conceptual_darwin_2003_1_0_InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
118 
dwc_dwcore_InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
119 
dwc_terms_institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
120 
conceptual_darwin_2003_1_0_InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator=""[,;] *""]/value",
121 
dwc_dwcore_InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator=""[,;] *""]/value",
122 
dwc_terms_institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator=""[,;] *""]/value",
117 
conceptual_darwin_2003_1_0_InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name/_first/2",
118 
dwc_dwcore_InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name/_first/2",
119 
dwc_terms_institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name/_first/2",
120 
conceptual_darwin_2003_1_0_InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_first/2/_split:[separator=""[,;] *""]/value",
121 
dwc_dwcore_InstitutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_first/2/_split:[separator=""[,;] *""]/value",
122 
dwc_terms_institutionCode,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_first/2/_split:[separator=""[,;] *""]/value",
123 123 
dwc_dwcore_GlobalUniqueIdentifier,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/sourceaccessioncode,
124 124 
dwc_terms_recordNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3/_alt/1",
125 125 
conceptual_darwin_2003_1_0_FieldNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3/_alt/2","Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
inputs/bien_web/observation/new_terms.csv
3 3 
taxonAuthor,scientificNameAuthorship,,
4 4 
taxonMorphospecies,scientificNameWithMorphospecies,,
5 5 
countyParish,county,,
6 
collectionNumber,recordNumber,,
7 6 
observationDate,dateCollected,,
8 7 
plotCode,locationName,,
9 8 
plotMethod,samplingProtocol,,
inputs/Madidi/IndividualObservation/VegBIEN.csv
13 13 
PlotName,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
14 14 
PlotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
15 15 
Sequence,/location/authorlocationcode,
16 
CollectionNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
16 17 
Sequence,"/location/locationevent/_if[@name=""if subplot""]/cond/_exists",
17 18 
PlotInventoryName,"/location/locationevent/_if[@name=""if subplot""]/else/authoreventcode",
18 19 
PlotInventoryName,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",
......
24 25 
CurrentDetQualifier,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonfit",
25 26 
TreeNotes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,
26 27 
Tree,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/1,
28 
CollectionNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2,
27 29 
SpecimenID,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",
30 
CollectionNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else",
28 31 
SpecimenID,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",
29 32 
Institutions,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",
30 33 
Institutions,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator=""[,;] *""]/value",
......
37 40 
PlotName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",
38 41 
Tree,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/1",
39 42 
Tag,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/2",
43 
CollectionNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",
40 44 
FieldNameFullName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/1",
41 45 
CurrentDet,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/2",
42 46 
SeniorCollector,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_first/1/_merge/1,
......
44 48 
CollectorStringShortened,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_first/2,
45 49 
CollectorAbbrev,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_first/3,
46 50 
HabitName,/location/locationevent/taxonoccurrence/growthform,
51 
CollectionNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",
47 52 
CurrentDetRank,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank",
48 53 
FieldFamilyFullName,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,variety,subspecies,species,genus,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=family]/taxonepithet",
49 54 
CurrentDetRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/rank,
......
60 65 
MorphoSpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/morphoname,
61 66 
FieldNameFullName,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/taxonname,
62 67 
SpecimenID,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
68 
CollectionNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then",
63 69 
PlotID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/cond/_exists",
64 70 
Sequence,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/cond/_exists",
65 71 
PlotID,"/location/sourceaccessioncode/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1",
......
83 89 
CauseOfDeath4,,** No non-empty join mapping for UNUSED **
84 90 
CauseOfDeath5,,** No non-empty join mapping for UNUSED **
85 91 
Circumference,,** No join mapping for *Circumference **
86 
CollectionNumber,,** No join mapping for *CollectionNumber **
87 92 
CommonName,,** No join mapping for *CommonName **
88 93 
CompoundLeaf,,** No non-empty join mapping for UNUSED **
89 94 
CompoundLeafID,,** No non-empty join mapping for UNUSED **
inputs/Madidi/IndividualObservation/unmapped_terms.csv
1 1 
*OrientationXDegrees
2 2 
*OrientationYDegrees
3 3 
*WasCollected
4 
*CollectionNumber
5 4 
*InstitutionString
6 5 
*RepresentativeSpecimenID
7 6 
*RepresentativeSpecimenSeniorCollector
inputs/UNCC/Specimen/new_terms.csv
1 
herbarium,institutionCode,,
1 
herbarium,collectingInstitution,,"""The name or acronym in use by the institution that donated the collection"" (https://projects.nceas.ucsb.edu/nceas/attachments/download/593/UNCC-validation-Peet.xlsx#institutionCode)"
2 2 
usdaRank,taxonRank,/_alt/1,
3 3 
infrarank,taxonRank,/_alt/2,
4 4 
infraname,infraspecificEpithet,,
......
7 7 
collector1,recordedBy,/_join/2,
8 8 
collector2,recordedBy,/_join/3,
9 9 
collector3,recordedBy,/_join/4,
10 
collectno,recordNumber,,
10 
collectno,collectorNumber,,
11 11 
collmonth,monthCollected,,
12 12 
collday,dayCollected,,
13 13 
collyear,yearCollected,,
inputs/SALVIAS-CSV/Organism/new_terms.csv
11 11 
tag1,tag,/_alt/2/_alt/2,"The second tag supercedes the first. The stem tag supercedes the tree tag. Brad: Another type of code, typically a number, used by the original data provider to indicate an individual tree. These are numbers on physical tags attached to the tree. Tag2 Is the same thing, only used if the first tag was lost. Obviously not a good system as it's possible a tree tag could be lost and changed more than once."
12 12 
x_position,organismX_m,,"""x coordinate in meters"" (x_position definition at <http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data>). Brad: These are important, fundamental values of many tree plots"
13 13 
y_position,organismY_m,,"""y coordinate in meters"" (y_position definition at <http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data>). Brad: See comment above for x_position"
14 
voucher_string,recordNumber,/_alt/2,"Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."
15 
coll_number,recordNumber,/_alt/1,Brad: Map instead as for voucher_string
14 
voucher_string,collectorNumber,/_alt/2,"Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."
15 
coll_number,collectorNumber,/_alt/1,Brad: Map instead as for voucher_string
16 16 
coll_lastname,recordedBy_surName,,"Brad: This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick."
17 17 
coll_firstname,recordedBy_givenName,,Brad: See comment above
18 18 
specific_authority,scientificNameAuthorship,,Brad: This is the author of the scientificName.
inputs/UNCC/Specimen/test.xml.ref
85 85 
                                            <institution_id>
86 86 
                                                <sourcelist>
87 87 
                                                    <name>$herbarium</name>
88 
                                                    <sourcename>
89 
                                                        <name>
90 
                                                            <_split>
91 
                                                                <separator>[,;] *</separator>
92 
                                                                <value>$herbarium</value>
93 
                                                            </_split>
94 
                                                        </name>
95 
                                                    </sourcename>
88 
                                                    <sourcename><name>$herbarium</name></sourcename>
96 89 
                                                </sourcelist>
97 90 
                                            </institution_id>
98 91 
                                        </specimenreplicate>
inputs/SALVIAS-CSV/Organism/map.csv
18 18 
tag2,tag,/_alt/2/_alt/1,"The second tag supercedes the first. The stem tag supercedes the tree tag. Brad: See commend for tag1. Your mapping for tag2 looks correct. Probably both values would go here, only nested, with one superceding the other."
19 19 
x_position,organismX_m,,"""x coordinate in meters"" (x_position definition at <http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data>). Brad: These are important, fundamental values of many tree plots"
20 20 
y_position,organismY_m,,"""y coordinate in meters"" (y_position definition at <http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data>). Brad: See comment above for x_position"
21 
voucher_string,recordNumber,/_alt/2,"Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."
22 
coll_number,recordNumber,/_alt/1,Brad: Map instead as for voucher_string
21 
voucher_string,collectorNumber,/_alt/2,"Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."
22 
coll_number,collectorNumber,/_alt/1,Brad: Map instead as for voucher_string
23 23 
collector_code,*collector_code,,Brad: OMIT
24 24 
coll_lastname,recordedBy_surName,,"Brad: This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick."
25 25 
coll_firstname,recordedBy_givenName,,Brad: See comment above
inputs/MT/Specimen/map.csv
1 1 
MT,VegCore,Filter,Comments
2 
id,datasourceRecordID,,
2 
id,dataProviderRecordID,,
3 3 
establishmentMeans,establishmentMeans,,
4 4 
locality,locality,,
5 5 
language,language,,
6 6 
collectionID,collectionID,,
7 7 
occurrenceRemarks,occurrenceRemarks,,
8 8 
type,type,,
9 
institutionCode,institutionCode,,
9 
institutionCode,custodialInstitutions,,
10 10 
rights,rights,,
11 11 
family,family,,
12 12 
continent,continent,,
13 
collectionCode,collectionCode,,
14 
datasetName,datasetName,,
13 
collectionCode,collection,,
14 
datasetName,dataset,,
15 15 
rightsHolder,rightsHolder,,
16 16 
genus,genus,,
17 17 
basisOfRecord,basisOfRecord,,
inputs/MT/Specimen/VegBIEN.csv
29 29 
continent,/location/locationplace/*_id/place/continent,
30 30 
basisOfRecord,,** No join mapping for basisOfRecord **
31 31 
countryCode,,** No join mapping for countryCode **
32 
datasetName,,** No join mapping for datasetName **
32 
datasetName,,** No join mapping for dataset **
33 33 
language,,** No join mapping for language **
34 34 
occurrenceRemarks,,** No join mapping for occurrenceRemarks **
35 35 
rightsHolder,,** No join mapping for rightsHolder **
inputs/MT/Specimen/unmapped_terms.csv
1 1 
language
2 2 
occurrenceRemarks
3 3 
type
4 
datasetName
4 
dataset
5 5 
rightsHolder
6 6 
basisOfRecord
7 7 
countryCode
inputs/XAL/Specimen/map.csv
1 1 
XAL:/content/record/,VegCore,Filter,Comments
2 2 
darwin:DateLastModified,modified,,
3 
darwin:InstitutionCode,institutionCode,,
4 
darwin:CollectionCode,collectionCode,,
3 
darwin:InstitutionCode,custodialInstitutions,,
4 
darwin:CollectionCode,collection,,
5 5 
darwin:CatalogNumber,catalogNumber,,
6 6 
darwin:ScientificName,taxonName,,
7 7 
darwin:BasisOfRecord,basisOfRecord,,
......
19 19 
darwin:MonthIdentified,monthIdentified,,
20 20 
darwin:DayIdentified,dayIdentified,,
21 21 
darwin:TypeStatus,typeStatus,,
22 
darwin:CollectorNumber,recordNumber,,
22 
darwin:CollectorNumber,collectorNumber,,
23 23 
darwin:FieldNumber,UNUSED,,This historical DwC term (http://rs.tdwg.org/dwc/terms/history/index.htm#fieldNumber-2009-04-24) has close to the same meaning as recordNumber (http://rs.tdwg.org/dwc/terms/#recordNumber).
24 24 
darwin:Collector,recordedBy,,
25 25 
darwin:YearCollected,yearCollected,,
inputs/XAL/Specimen/new_terms.csv
1 1 
darwin:DateLastModified,modified,,
2 
darwin:InstitutionCode,institutionCode,,
3 
darwin:CollectionCode,collectionCode,,
2 
darwin:InstitutionCode,custodialInstitutions,,
3 
darwin:CollectionCode,collection,,
4 4 
darwin:CatalogNumber,catalogNumber,,
5 5 
darwin:ScientificName,taxonName,,
6 6 
darwin:BasisOfRecord,basisOfRecord,,
......
18 18 
darwin:MonthIdentified,monthIdentified,,
19 19 
darwin:DayIdentified,dayIdentified,,
20 20 
darwin:TypeStatus,typeStatus,,
21 
darwin:CollectorNumber,recordNumber,,
21 
darwin:CollectorNumber,collectorNumber,,
22 22 
darwin:Collector,recordedBy,,
23 23 
darwin:YearCollected,yearCollected,,
24 24 
darwin:MonthCollected,monthCollected,,
inputs/NCU/Specimen/map.csv
4 4 
CollectionObjectTypeID,*CollectionObjectTypeID,,
5 5 
CollectionObjectID,*CollectionObjectID,,
6 6 
database,*database,,
7 
OwnerInstitution,institutionCode,/_alt/2,
7 
OwnerInstitution,custodialInstitutions,/_alt/2,
8 8 
CollectionGUID,collectionID,,
9 9 
OriginalTaxonLabel,originalScientificName,,
10 10 
CurrentScientificName,taxonName,,
......
13 13 
CollectionDate,dateCollected,,
14 14 
BarCode,OMIT,,"Omitted because this isn't specified on all rows, but SpecimenPK is"
15 15 
CatalogNumber,catalogNumber,,
16 
CatalogSeriesPrefix,institutionCode,/_alt/1,
16 
CatalogSeriesPrefix,custodialInstitutions,/_alt/1,
17 17 
Description,organismNotes,,
18 18 
LandOwner,*LandOwner,,
19 19 
BlockLocationReason,*BlockLocationReason,,
......
31 31 
Loc_AltN,verbatimLatitude,,
32 32 
Loc_AltE,verbatimLongitude,,
33 33 
firstCollectorName,recordedBy,,
34 
firstCollectorRemarks,recordNumber,,"Actually the collector's number, not remarks"
34 
firstCollectorRemarks,collectorNumber,,"Actually the collector's number, not remarks"
35 35 
LastAnnotationLabelTaxon,*LastAnnotationLabelTaxon,,
36 36 
LastAnnotationDateVerbatim,*LastAnnotationDateVerbatim,,
37 37 
LastAnnotationRemarks,*LastAnnotationRemarks,,
inputs/NCU/Specimen/new_terms.csv
1 1 
SpecimenPK,occurrenceID,,
2 
OwnerInstitution,institutionCode,/_alt/2,
2 
OwnerInstitution,custodialInstitutions,/_alt/2,
3 3 
CollectionGUID,collectionID,,
4 4 
OriginalTaxonLabel,originalScientificName,,
5 5 
CurrentScientificName,taxonName,,
6 6 
CurrentScientificNameWithAuthor,scientificName,,
7 7 
CollectionDate,dateCollected,,
8 
CatalogSeriesPrefix,institutionCode,/_alt/1,
8 
CatalogSeriesPrefix,custodialInstitutions,/_alt/1,
9 9 
Description,organismNotes,,
10 10 
CityLocality,verbatimLocality,/_alt/2,
11 11 
Latitude1,decimalLatitude,,
......
13 13 
Loc_AltN,verbatimLatitude,,
14 14 
Loc_AltE,verbatimLongitude,,
15 15 
firstCollectorName,recordedBy,,
16 
firstCollectorRemarks,recordNumber,,"Actually the collector's number, not remarks"
16 
firstCollectorRemarks,collectorNumber,,"Actually the collector's number, not remarks"
inputs/bien2_traits/TraitObservation/new_terms.csv
1 1 
TraitObservationID,occurrenceID,,
2 
InfraspecificRank,taxonRank,,
3 2 
Taxon,taxonName,,
4 3 
AuthorOfScientificName,scientificNameAuthorship,,
5 4 
LocalityDescription,verbatimLocality,,
inputs/TEAM/VL/map.csv
1 1 
TEAM,VegCore,Filter,Comments
2 
Id,datasourceRecordID,,
2 
Id,dataProviderRecordID,,
3 3 
Observation Date,eventDate,,
4 4 
Family,family,,
5 5 
Genus,genus,,
inputs/TEAM/VT/map.csv
1 1 
TEAM,VegCore,Filter,Comments
2 
Id,datasourceRecordID,,
2 
Id,dataProviderRecordID,,
3 3 
Observation Date,eventDate,,
4 4 
Family,family,,
5 5 
Genus,genus,,
inputs/ACAD/Specimen/map.csv
1 1 
ACAD,VegCore,Filter,Comments
2 
id,datasourceRecordID,,
2 
id,dataProviderRecordID,,
3 3 
basisOfRecord,basisOfRecord,,
4 4 
identifiedBy,identifiedBy,,
5 5 
collectionID,collectionID,,
......
7 7 
geodeticDatum,geodeticDatum,,
8 8 
reproductiveCondition,reproductiveCondition,,
9 9 
decimalLongitude,decimalLongitude,,
10 
institutionCode,institutionCode,,
10 
institutionCode,custodialInstitutions,,
11 11 
continent,continent,,
12 12 
recordedBy,recordedBy,,
13 13 
county,county,,
......
26 26 
specificEpithet,specificEpithet,,
27 27 
identificationRemarks,identificationRemarks,,
28 28 
rightsHolder,rightsHolder,,
29 
recordNumber,recordNumber,,
29 
recordNumber,collectorNumber,,
30 30 
eventDate,eventDate,,
31 31 
rights,rights,,
32 32 
occurrenceRemarks,occurrenceRemarks,,
......
42 42 
decimalLatitude,decimalLatitude,,
43 43 
genus,genus,,
44 44 
ownerInstitutionCode,ownerInstitutionCode,,
45 
collectionCode,collectionCode,,
45 
collectionCode,collection,,
46 46 
bibliographicCitation,bibliographicCitation,,
47 47 
catalogNumber,catalogNumber,,
48 48 
country,country,,
inputs/WIN/Specimen/map.csv
1 1 
WIN,VegCore,Filter,Comments
2 
id,datasourceRecordID,,
2 
id,dataProviderRecordID,,
3 3 
municipality,municipality,,
4 4 
verbatimLongitude,verbatimLongitude,,
5 5 
rightsHolder,rightsHolder,,
......
14 14 
occurrenceRemarks,occurrenceRemarks,,
15 15 
verbatimElevation,verbatimElevation,,
16 16 
eventDate,eventDate,,
17 
recordNumber,recordNumber,,
17 
recordNumber,collectorNumber,,
18 18 
county,county,,
19 19 
type,type,,
20 20 
stateProvince,stateProvince,,
......
27 27 
habitat,habitat,,
28 28 
identifiedBy,identifiedBy,,
29 29 
minimumElevationInMeters,minimumElevationInMeters,,
30 
datasetName,datasetName,,
30 
datasetName,dataset,,
31 31 
basisOfRecord,basisOfRecord,,
32 32 
collectionID,collectionID,,
33 
collectionCode,collectionCode,,
33 
collectionCode,collection,,
34 34 
verbatimCoordinates,verbatimCoordinates,,
35 35 
decimalLatitude,decimalLatitude,,
36 
institutionCode,institutionCode,,
36 
institutionCode,custodialInstitutions,,
37 37 
catalogNumber,catalogNumber,,
38 38 
verbatimLatitude,verbatimLatitude,,
39 39 
identificationRemarks,identificationRemarks,,
inputs/WIN/Specimen/VegBIEN.csv
82 82 
basisOfRecord,,** No join mapping for basisOfRecord **
83 83 
bibliographicCitation,,** No join mapping for bibliographicCitation **
84 84 
datasetID,,** No join mapping for datasetID **
85 
datasetName,,** No join mapping for datasetName **
85 
datasetName,,** No join mapping for dataset **
86 86 
geodeticDatum,,** No join mapping for geodeticDatum **
87 87 
identificationRemarks,,** No join mapping for identificationRemarks **
88 88 
language,,** No join mapping for language **
inputs/WIN/Specimen/unmapped_terms.csv
7 7 
occurrenceRemarks
8 8 
type
9 9 
verbatimEventDate
10 
datasetName
10 
dataset
11 11 
basisOfRecord
12 12 
identificationRemarks
13 13 
nomenclaturalCode
inputs/SALVIAS/plotObservations/map.csv
21 21 
y_position,organismY_m,,"""y coordinate in meters"" (y_position definition at <http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data>). Brad: See comment above for x_position"
22 22 
dist,*dist,,
23 23 
perp_dist,*perp_dist,,
24 
SourceVoucher,recordNumber,/_alt/2,"Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."
25 
coll_number,recordNumber,/_alt/1,Brad: Map instead as for voucher_string
24 
SourceVoucher,collectorNumber,/_alt/2,"Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."
25 
coll_number,collectorNumber,/_alt/1,Brad: Map instead as for voucher_string
26 26 
collector_code,*collector_code,,Brad: OMIT
27 27 
coll_inits,*coll_inits,,
28 28 
coll_lastname,recordedBy_surName,,"Brad: This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick."
inputs/SALVIAS/plotObservations/new_terms.csv
13 13 
tag1,tag,/_alt/2,"The second tag supercedes the first. Brad: Another type of code, typically a number, used by the original data provider to indicate an individual tree. These are numbers on physical tags attached to the tree. Tag2 Is the same thing, only used if the first tag was lost. Obviously not a good system as it's possible a tree tag could be lost and changed more than once."
14 14 
x_position,organismX_m,,"""x coordinate in meters"" (x_position definition at <http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data>). Brad: These are important, fundamental values of many tree plots"
15 15 
y_position,organismY_m,,"""y coordinate in meters"" (y_position definition at <http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data>). Brad: See comment above for x_position"
16 
SourceVoucher,recordNumber,/_alt/2,"Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."
17 
coll_number,recordNumber,/_alt/1,Brad: Map instead as for voucher_string
16 
SourceVoucher,collectorNumber,/_alt/2,"Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."
17 
coll_number,collectorNumber,/_alt/1,Brad: Map instead as for voucher_string
18 18 
coll_lastname,recordedBy_surName,,"Brad: This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick."
19 19 
coll_firstname,recordedBy_givenName,,Brad: See comment above
20 20 
det_by,identifiedBy,,
inputs/U/Specimen/map.csv
1 1 
U,VegCore,Filter,Comments
2 
ID,datasourceRecordID,,
2 
ID,dataProviderRecordID,,
3 3 
Barcode,catalogNumber,,
4 4 
Collector,recordedBy,/_join/1,
5 5 
Prefix,UNUSED,,
6 
Number,recordNumber,,
6 
Number,collectorNumber,,
7 7 
Suffix,UNUSED,,
8 8 
Addcoll,recordedBy,/_join/2,
9 9 
Colldd,dayCollected,,
inputs/U/Specimen/new_terms.csv
1 
Number,recordNumber,,
1 
Number,collectorNumber,,
2 2 
Addcoll,recordedBy,/_join/2,
3 3 
Colldd,dayCollected,,
4 4 
Collmm,monthCollected,,
inputs/GBIF/Specimen/map.csv
4 4 
Collector,recordedBy,,
5 5 
3,*3,,
6 6 
LatestDateCollected,dateCollected,,
7 
InstitutionCD,institutionCode,,
8 
CollectionCD,collectionCode,,
7 
InstitutionCD,custodialInstitutions,,
8 
CollectionCD,collection,,
9 9 
CatalogNO,catalogNumber,,
10 10 
LastDateModified,modified,,
11 11 
IdentifiedBy,identifiedBy,,
inputs/GBIF/Specimen/new_terms.csv
1 1 
LatestDateCollected,dateCollected,,
2 
InstitutionCD,institutionCode,,
3 
CollectionCD,collectionCode,,
2 
InstitutionCD,custodialInstitutions,,
3 
CollectionCD,collection,,
4 4 
CatalogNO,catalogNumber,,
5 5 
LastDateModified,modified,,
6 6 
ScientificNameOriginal,originalTaxonName,,
inputs/QFA/Specimen/map.csv
1 1 
QFA,VegCore,Filter,Comments
2 
id,datasourceRecordID,,
2 
id,dataProviderRecordID,,
3 3 
rights,rights,,
4 
recordNumber,recordNumber,,
4 
recordNumber,collectorNumber,,
5 5 
family,family,,
6 6 
associatedSequences,associatedSequences,,
7 7 
institutionID,UNUSED,,
8 8 
specificEpithet,specificEpithet,,
9 
datasetName,datasetName,,
9 
datasetName,dataset,,
10 10 
locality,locality,,
11 11 
verbatimElevation,verbatimElevation,,
12 12 
typeStatus,typeStatus,,
......
14 14 
identifiedBy,identifiedBy,,
15 15 
associatedReferences,associatedReferences,,
16 16 
kingdom,kingdom,,
17 
institutionCode,institutionCode,,
17 
institutionCode,custodialInstitutions,,
18 18 
catalogNumber,catalogNumber,,
19 19 
verbatimSRS,verbatimSRS,,
20 20 
verbatimLongitude,verbatimLongitude,,
......
40 40 
country,country,,
41 41 
language,language,,
42 42 
eventDate,eventDate,,
43 
collectionCode,collectionCode,,
43 
collectionCode,collection,,
44 44 
scientificName,scientificName,,
45 45 
stateProvince,stateProvince,,
46 46 
scientificNameAuthorship,scientificNameAuthorship,,
inputs/QFA/Specimen/VegBIEN.csv
87 87 
basisOfRecord,,** No join mapping for basisOfRecord **
88 88 
bibliographicCitation,,** No join mapping for bibliographicCitation **
89 89 
datasetID,,** No join mapping for datasetID **
90 
datasetName,,** No join mapping for datasetName **
90 
datasetName,,** No join mapping for dataset **
91 91 
geodeticDatum,,** No join mapping for geodeticDatum **
92 92 
institutionID,,** No non-empty join mapping for UNUSED **
93 93 
language,,** No join mapping for language **
inputs/QFA/Specimen/unmapped_terms.csv
1 1 
associatedSequences
2 
datasetName
2 
dataset
3 3 
typeStatus
4 4 
verbatimEventDate
5 5 
associatedReferences
inputs/JBM/Specimen/map.csv
1 1 
JBM,VegCore,Filter,Comments
2 
id,datasourceRecordID,,
2 
id,dataProviderRecordID,,
3 3 
minimumElevationInMeters,minimumElevationInMeters,,
4 4 
verbatimLatitude,verbatimLatitude,,
5 5 
modified,modified,,
6 
recordNumber,recordNumber,,
6 
recordNumber,collectorNumber,,
7 7 
recordedBy,recordedBy,,
8 8 
ownerInstitutionCode,ownerInstitutionCode,,
9 9 
language,language,,
......
23 23 
dynamicProperties,dynamicProperties,,
24 24 
sex,sex,,
25 25 
family,family,,
26 
datasetName,datasetName,,
26 
datasetName,dataset,,
27 27 
scientificName,scientificName,,
28 28 
eventDate,eventDate,,
29 29 
habitat,habitat,,
30 30 
country,country,,
31 31 
rights,rights,,
32 32 
decimalLongitude,decimalLongitude,,
33 
collectionCode,collectionCode,,
33 
collectionCode,collection,,
34 34 
type,type,,
35 35 
order,order,,
36 36 
kingdom,kingdom,,
37 
institutionCode,institutionCode,,
37 
institutionCode,custodialInstitutions,,
38 38 
datasetID,datasetID,,
39 39 
countryCode,countryCode,,
40 40 
catalogNumber,catalogNumber,,
inputs/JBM/Specimen/VegBIEN.csv
70 70 
basisOfRecord,,** No join mapping for basisOfRecord **
71 71 
countryCode,,** No join mapping for countryCode **
72 72 
datasetID,,** No join mapping for datasetID **
73 
datasetName,,** No join mapping for datasetName **
73 
datasetName,,** No join mapping for dataset **
74 74 
dynamicProperties,,** No join mapping for dynamicProperties **
75 75 
geodeticDatum,,** No join mapping for geodeticDatum **
76 76 
language,,** No join mapping for language **
inputs/UBC/Specimen/map.csv
1 1 
UBC,VegCore,Filter,Comments
2 
id,datasourceRecordID,,
3 
collectionCode,collectionCode,,
2 
id,dataProviderRecordID,,
3 
collectionCode,collection,,
4 4 
identificationQualifier,identificationQualifier,,
5 5 
institutionID,UNUSED,,
6 6 
taxonRank,taxonRank,,
......
10 10 
rightsHolder,rightsHolder,,
11 11 
verbatimLongitude,verbatimLongitude,,
12 12 
rights,rights,,
13 
recordNumber,recordNumber,,
13 
recordNumber,collectorNumber,,
14 14 
preparations,preparations,,
15 15 
taxonRemarks,taxonRemarks,,
16 16 
geodeticDatum,geodeticDatum,,
......
23 23 
language,language,,
24 24 
ownerInstitutionCode,ownerInstitutionCode,,
25 25 
family,family,,
26 
datasetName,datasetName,,
26 
datasetName,dataset,,
27 27 
modified,modified,,
28 28 
eventDate,eventDate,,
29 29 
georeferencedDate,georeferencedDate,,
......
55 55 
previousIdentifications,previousIdentifications,,
56 56 
identifiedBy,identifiedBy,,
57 57 
associatedSequences,associatedSequences,,
58 
institutionCode,institutionCode,,
58 
institutionCode,custodialInstitutions,,
inputs/UBC/Specimen/unmapped_terms.csv
8 8 
disposition
9 9 
language
10 10 
ownerInstitutionCode
11 
datasetName
11 
dataset
12 12 
modified
13 13 
georeferencedDate
14 14 
georeferenceSources
inputs/HIBG/Specimen/VegBIEN.csv
86 86 
basisOfRecord,,** No join mapping for basisOfRecord **
87 87 
bibliographicCitation,,** No join mapping for bibliographicCitation **
88 88 
datasetID,,** No join mapping for datasetID **
89 
datasetName,,** No join mapping for datasetName **
89 
datasetName,,** No join mapping for dataset **
90 90 
dynamicProperties,,** No join mapping for dynamicProperties **
91 91 
geodeticDatum,,** No join mapping for geodeticDatum **
92 92 
georeferenceSources,,** No join mapping for georeferenceSources **
inputs/SpeciesLink/Specimen/map.csv
2 2 
dwc_dwcore_GlobalUniqueIdentifier,occurrenceID,,
3 3 
dwc_dwcore_DateLastModified,modified,,
4 4 
dwc_dwcore_BasisOfRecord,basisOfRecord,,
5 
dwc_dwcore_InstitutionCode,institutionCode,,
6 
dwc_dwcore_CollectionCode,collectionCode,,
5 
dwc_dwcore_InstitutionCode,custodialInstitutions,,
6 
dwc_dwcore_CollectionCode,collection,,
7 7 
dwc_dwcore_CatalogNumber,catalogNumber,,
8 8 
dwc_dwcore_Remarks,taxonRemarks,,
9 9 
dwc_dwcore_ScientificName,taxonName,,
......
29 29 
dwc_dwcore_Collector,recordedBy,,
30 30 
dwc_dwcore_Sex,sex,,
31 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)
32 
dwc_curatorial_CollectorNumber,collectorNumber,/_alt/3,
33 
dwc_curatorial_FieldNumber,collectorNumber,/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
34 34 
-----
35 35 
SELECT count(*) FROM ""SpeciesLink"".specimens
36 36 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
......
43 43 
dwc_geospatial_VerbatimLongitude,verbatimLongitude,,Contains a mix of DMS and other verbatim coordinates
44 44 
http__purl_org_dc_terms_modified,modified,,
45 45 
dwc_terms_collectionID,collectionID,,
46 
dwc_terms_institutionCode,institutionCode,,
47 
dwc_terms_collectionCode,collectionCode,,
46 
dwc_terms_institutionCode,custodialInstitutions,,
47 
dwc_terms_collectionCode,collection,,
48 48 
dwc_terms_basisOfRecord,basisOfRecord,,
49 49 
dwc_terms_identifiedBy,identifiedBy,,
50 50 
dwc_terms_dateIdentified,dateIdentified,,
51 51 
dwc_terms_typeStatus,typeStatus,,
52 52 
dwc_terms_catalogNumber,catalogNumber,,
53 53 
dwc_terms_occurrenceRemarks,occurrenceRemarks,,
54 
dwc_terms_recordNumber,recordNumber,/_alt/1,
54 
dwc_terms_recordNumber,collectorNumber,/_alt/1,
55 55 
dwc_terms_recordedBy,recordedBy,,
56 56 
dwc_terms_individualCount,individualCount,,
57 57 
dwc_terms_sex,sex,,
......
63 63 
dwc_terms_year,year,,
64 64 
dwc_terms_month,month,,
65 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)
66 
dwc_terms_fieldNumber,collectorNumber,/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
67 67 
-----
68 68 
SELECT count(*) FROM ""SpeciesLink"".specimens
69 69 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
......
93 93 
dwc_terms_infraspecificEpithet,infraspecificEpithet,,
94 94 
dwc_terms_scientificNameAuthorship,scientificNameAuthorship,/_alt/1,
95 95 
conceptual_darwin_2003_1_0_DateLastModified,modified,,
96 
conceptual_darwin_2003_1_0_InstitutionCode,institutionCode,,
97 
conceptual_darwin_2003_1_0_CollectionCode,collectionCode,,
96 
conceptual_darwin_2003_1_0_InstitutionCode,custodialInstitutions,,
97 
conceptual_darwin_2003_1_0_CollectionCode,collection,,
98 98 
conceptual_darwin_2003_1_0_CatalogNumber,catalogNumber,,
99 99 
conceptual_darwin_2003_1_0_ScientificName,taxonName,,
100 100 
conceptual_darwin_2003_1_0_BasisOfRecord,basisOfRecord,,
......
112 112 
conceptual_darwin_2003_1_0_MonthIdentified,monthIdentified,,
113 113 
conceptual_darwin_2003_1_0_DayIdentified,dayIdentified,,
114 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)
115 
conceptual_darwin_2003_1_0_CollectorNumber,collectorNumber,/_alt/3,
116 
conceptual_darwin_2003_1_0_FieldNumber,collectorNumber,/_alt/2,"Usage inconsistent with DwC definition. This field is instead identical to recordNumber, as the following query returns zero: (takes 23 sec)
117 117 
-----
118 118 
SELECT count(*) FROM ""SpeciesLink"".specimens
119 119 
WHERE COALESCE(""dwc_curatorial_FieldNumber"", ""dwc_terms_fieldNumber"", ""conceptual_darwin_2003_1_0_FieldNumber"") != ""dwc_terms_recordNumber""
inputs/bien_web/observation/map.csv
1 1 
bien_web,VegCore,Filter,Comments
2 2 
observationID,occurrenceID,,
3 3 
dataSourceID,*dataSourceID,,
4 
dataSourceName,institutionCode,,
4 
dataSourceName,custodialInstitutions,,
5 5 
dataSourceNamePrimary,*dataSourceNamePrimary,,
6 6 
plotID,locationID,,
7 7 
observationType,observationGranularity,,
......
27 27 
stateProvinceError,*stateProvinceError,,
28 28 
localityDescription,*localityDescription,,
29 29 
collector,recordedBy,,
30 
collectionNumber,recordNumber,,
30 
collectionNumber,collectorNumber,,
31 31 
identifiedBy,identifiedBy,,
32 32 
observationDate,dateCollected,,
33 33 
plotCode,locationName,,
inputs/Madidi/IndividualObservation/map.csv
15 15 
SeniorCollector,recordedBy,/_first/1/_merge/1,
16 16 
CollectorString,recordedBy,/_first/1/_merge/2,
17 17 
CollectorStringShortened,recordedBy,/_first/2,
18 
CollectionNumber,*CollectionNumber,,
19 
Institutions,institutionCode,,
18 
CollectionNumber,collectorNumber,,
19 
Institutions,custodialInstitutions,,
20 20 
InstitutionString,*InstitutionString,,
21 21 
CollectorAbbrev,recordedBy,/_first/3,
22 22 
CurrentDet,scientificName,,
inputs/Madidi/IndividualObservation/new_terms.csv
6 6 
SeniorCollector,recordedBy,/_first/1/_merge/1,
7 7 
CollectorString,recordedBy,/_first/1/_merge/2,
8 8 
CollectorStringShortened,recordedBy,/_first/2,
9 
Institutions,institutionCode,,
9 
Institutions,custodialInstitutions,,
10 10 
CollectorAbbrev,recordedBy,/_first/3,
11 11 
CurrentDet,scientificName,,
12 12 
CurrentDetRank,taxonRank,,
inputs/UNCC/Specimen/VegBIEN.csv
8 8 
GROUP BY herbarium, accession
9 9 
HAVING count(*) > 1
10 10 
-----"
11 
herbarium,"/_if[@name=""if specimen""]/else/source/shortname/_first/1",
12 11 
accession,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/cond/_exists","Globally unique, although occasionally duplicated. [1] Bob says this is actually the catalogNumber.
13 12 

  		




  14
  13
  
    
[1] Using the following query:


  		




  ......




  27
  26
  
    
GROUP BY herbarium, accession


  		




  28
  27
  
    
HAVING count(*) > 1


  		




  29
  28
  
    
-----"


  		




  30
  
  
    
herbarium,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/then",


  		




  
  29
  
    
herbarium,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/then/_first/1","""The name or acronym in use by the institution that donated the collection"" (https://projects.nceas.ucsb.edu/nceas/attachments/download/593/UNCC-validation-Peet.xlsx#institutionCode)"


  		




  31
  30
  
    
accession,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else","Globally unique, although occasionally duplicated. [1] Bob says this is actually the catalogNumber.


  		




  32
  31
  
    

  		




  33
  32
  
    
[1] Using the following query:


  		




  ......




  71
  70
  
    
GROUP BY herbarium, accession


  		




  72
  71
  
    
HAVING count(*) > 1


  		




  73
  72
  
    
-----"


  		




  74
  
  
    
herbarium,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name",


  		




  75
  
  
    
herbarium,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_split:[separator=""[,;] *""]/value",


  		




  
  73
  
    
herbarium,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/name/_first/1","""The name or acronym in use by the institution that donated the collection"" (https://projects.nceas.ucsb.edu/nceas/attachments/download/593/UNCC-validation-Peet.xlsx#institutionCode)"


  		




  
  74
  
    
herbarium,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name/_first/1","""The name or acronym in use by the institution that donated the collection"" (https://projects.nceas.ucsb.edu/nceas/attachments/download/593/UNCC-validation-Peet.xlsx#institutionCode)"


  		




  76
  75
  
    
collectno,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",


  		




  77
  76
  
    
SciName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/3",


  		




  78
  77
  
    
collector,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_join/1,


  		












  

    
      inputs/.herbaria/ih/new_terms.csv
    
  





  1
  
  
    
acronym,institutionCode,,


  		




  
  1
  
    
acronym,custodialInstitutions,,


  		












  

    
      inputs/.herbaria/ih/map.csv
    
  





  1
  1
  
    
herbaria,VegCore,Filter,Comments


  		




  2
  2
  
    
eparties_key,*eparties_key,,


  		




  3
  3
  
    
NamOrganisation,*NamOrganisation,,


  		




  4
  
  
    
acronym,institutionCode,,


  		




  
  4
  
    
acronym,custodialInstitutions,,


  		




  5
  5
  
    
IhhInstitutionType,*IhhInstitutionType,,


  		




  6
  6
  
    
NamBranch,*NamBranch,,


  		




  7
  7
  
    
NamDepartment,*NamDepartment,,


  		












  

    
      inputs/CVS/taxonObservation_/map.csv
    
  





  34
  34
  
    
taxonFit,identificationQualifier,,


  		




  35
  35
  
    
taxonConfidence,*taxonConfidence,,


  		




  36
  36
  
    
collector_ID,*collector_ID,,


  		




  37
  
  
    
collectionNumber,*collectionNumber,,


  		




  
  37
  
    
collectionNumber,collectorNumber,,


  		




  38
  38
  
    
collectionDate,dateCollected,,


  		




  39
  39
  
    
museum_ID,*museum_ID,,


  		




  40
  40
  
    
museumAccessionNumber,catalogNumber,,


  		












  

    
      inputs/CVS/taxonObservation_/unmapped_terms.csv
    
  





  26
  26
  
    
*currentInterpretation


  		




  27
  27
  
    
*taxonConfidence


  		




  28
  28
  
    
*collector_ID


  		




  29
  
  
    
*collectionNumber


  		




  30
  29
  
    
*museum_ID


  		




  31
  30
  
    
*groupType


  		




  32
  31
  
    
*notesPublic


  		












  

    
      inputs/CVS/taxonObservation_/test.xml.ref
    
  





  14
  14
  
    
                                    <collectiondate>$collectionDate</collectiondate>


  		




  15
  15
  
    
                                    <notes>$notes</notes>


  		




  16
  16
  
    
                                    <plantobservation>


  		




  17
  
  
    
                                        <specimenreplicate><catalognumber_dwc>$museumAccessionNumber</catalognumber_dwc></specimenreplicate>


  		




  
  17
  
    
                                        <authorplantcode>$collectionNumber</authorplantcode>


  		




  
  18
  
    
                                        <specimenreplicate>


  		




  
  19
  
    
                                            <catalognumber_dwc>$museumAccessionNumber</catalognumber_dwc>


  		




  
  20
  
    
                                            <collectionnumber>$collectionNumber</collectionnumber>


  		




  
  21
  
    
                                        </specimenreplicate>


  		




  18
  22
  
    
                                        <stemobservation><sourceaccessioncode>$stemLocation_ID</sourceaccessioncode></stemobservation>


  		




  19
  23
  
    
                                    </plantobservation>


  		




  20
  24
  
    
                                </aggregateoccurrence>


  		




  21
  
  
    
                                <authortaxoncode>$authorPlantName</authortaxoncode>


  		




  
  25
  
    
                                <authortaxoncode>$collectionNumber</authortaxoncode>


  		




  22
  26
  
    
                                <collector_id>


  		




  23
  27
  
    
                                    <party>


  		




  24
  28
  
    
                                        <fullname>


  		












  

    
      inputs/CVS/taxonObservation_/VegBIEN.csv
    
  





  6
  6
  
    
museumAccessionNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1/_if[@name=""if specimen""]/cond/_exists",


  		




  7
  7
  
    
museumAccessionNumber,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_if[@name=""if plot""]/else/_alt/2/_if[@name=""if catalogNumber""]/then/_join/3/_if[@name=""if indirect voucher""]/else",


  		




  8
  8
  
    
TAXONOBSERVATION_ID,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",


  		




  
  9
  
    
collectionNumber,"/location/iscultivated/_or/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",


  		




  9
  10
  
    
OBSERVATION_ID,"/location/locationevent/_if[@name=""if subplot""]/else/sourceaccessioncode",


  		




  10
  11
  
    
OBSERVATION_ID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/cond/_exists",


  		




  11
  12
  
    
OBSERVATION_ID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/sourceaccessioncode",


  		




  ......




  13
  14
  
    
taxonFit,"/location/locationevent/taxonoccurrence/_if[@name=""if has accepted name""]/then/taxondetermination:[determinationtype=accepted]/taxonfit",


  		




  14
  15
  
    
collectionDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1,


  		




  15
  16
  
    
notes,/location/locationevent/taxonoccurrence/aggregateoccurrence/notes,


  		




  
  17
  
    
collectionNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/authorplantcode/_first/2,


  		




  16
  18
  
    
museumAccessionNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",


  		




  
  19
  
    
collectionNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else",


  		




  17
  20
  
    
museumAccessionNumber,"/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",


  		




  18
  21
  
    
stemLocation_ID,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/stemobservation/sourceaccessioncode,


  		




  19
  22
  
    
OBSERVATION_ID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists",


  		




  20
  23
  
    
stemLocation_ID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_if[@name=""if individual""]/cond/_exists",


  		




  
  24
  
    
collectionNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3",


  		




  21
  25
  
    
authorPlantName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/1",


  		




  22
  26
  
    
plantNameWithAuthority,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/2",


  		




  23
  27
  
    
plantname,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/3/_first/3",


  		




  24
  28
  
    
givenName,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_join_words/1,


  		




  25
  29
  
    
surName,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_join_words/2,


  		




  26
  30
  
    
TAXONOBSERVATION_ID,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",


  		




  
  31
  
    
collectionNumber,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists",


  		




  27
  32
  
    
TAXONOBSERVATION_ID,/location/locationevent/taxonoccurrence/sourceaccessioncode/_first/1,


  		




  28
  33
  
    
taxonLevel,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/_if[@name=""if has explicit parent""]/else/rank",


  		




  29
  34
  
    
variety,"/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/*_id/taxonlabel/parent_id/taxonlabel/parent_id/_forEach:[in:[cultivar,forma,],do=""taxonlabel[rank=_val]/parent_id""]/taxonlabel[rank=variety]/taxonepithet",


  		




  ......




  66
  71
  
    
taxonFit,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/taxonfit,


  		




  67
  72
  
    
authorPlantName,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonverbatim/taxonname,


  		




  68
  73
  
    
museumAccessionNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",


  		




  
  74
  
    
collectionNumber,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then",


  		




  69
  75
  
    
Division,,** No join mapping for *Division/_alt/2 ** 


  		




  70
  76
  
    
PARTY_ID,,** No join mapping for *PARTY_ID ** 


  		




  71
  77
  
    
PLANTCONCEPT_ID,,** No join mapping for *PLANTCONCEPT_ID ** 


  		




  ......




  77
  83
  
    
USDAPlantsCode,,** No join mapping for *USDAPlantsCode ** 


  		




  78
  84
  
    
VascularPlant,,** No join mapping for *VascularPlant ** 


  		




  79
  85
  
    
accessionCode,,** No join mapping for *accessionCode ** 


  		




  80
  
  
    
collectionNumber,,** No join mapping for *collectionNumber ** 


  		




  81
  86
  
    
collector_ID,,** No join mapping for *collector_ID ** 


  		




  82
  87
  
    
commonName,,** No join mapping for *commonName ** 


  		




  83
  88
  
    
composite family,,** No join mapping for *composite family/_alt/2 ** 


  		












  

    
      inputs/REMIB/Specimen/new_terms.csv
    
  





  1
  
  
    
acronym,institutionCode,,


  		




  
  1
  
    
acronym,custodialInstitutions,,


  		




  2
  2
  
    
long_deg,decimalLongitude,,


  		




  3
  3
  
    
lat_deg,decimalLatitude,,


  		




  4
  4
  
    
coll_day,dayCollected,,


  		












  

    
      inputs/REMIB/Specimen/map.csv
    
  





  1
  1
  
    
REMIB,VegCore,Filter,Comments


  		




  2
  
  
    
acronym,institutionCode,,


  		




  
  2
  
    
acronym,custodialInstitutions,,


  		




  3
  3
  
    
accession_number,catalogNumber,,"Not globally unique, only (usually) unique within the institution providing the data (""acronym""). Note that there are nevertheless 11,869 rows where an accession_number appears multiple times within the same institution. [1]


  		




  4
  4
  
    

  		




  5
  5
  
    
[1] Using the following query:


  		












  

    
      inputs/ARIZ/Specimen/map.csv
    
  





  2
  2
  
    
GlobalUniqueIdentifier,occurrenceID,,


  		




  3
  3
  
    
DateLastModified,modified,,


  		




  4
  4
  
    
BasisOfRecord,basisOfRecord,,


  		




  5
  
  
    
InstitutionCode,collectionCode,,Column names are reversed


  		




  6
  
  
    
CollectionCode,institutionCode,,Column names are reversed


  		




  
  5
  
    
InstitutionCode,collection,,Column names are reversed


  		




  
  6
  
    
CollectionCode,custodialInstitutions,,Column names are reversed


  		




  7
  7
  
    
CatalogNumber,catalogNumber,/_alt/2,Don't overwrite CatalogNumberNumeric


  		




  8
  8
  
    
CatalogNumberNumeric,catalogNumber,/_alt/1,


  		




  9
  9
  
    
Collector,recordedBy,,


  		




  10
  
  
    
CollectorNumber,recordNumber,/_first/1,


  		




  11
  
  
    
FieldNumber,recordNumber,/_first/2,Identical to CollectorNumber


  		




  
  10
  
    
CollectorNumber,collectorNumber,/_first/1,


  		




  
  11
  
    
FieldNumber,collectorNumber,/_first/2,Identical to CollectorNumber


  		




  12
  12
  
    
YearCollected,yearCollected,,


  		




  13
  13
  
    
MonthCollected,monthCollected,,


  		




  14
  14
  
    
DayCollected,dayCollected,,


  		












  

    
      inputs/MO/Specimen/map.csv
    
  





  1
  1
  
    
MO,VegCore,Filter,Comments


  		




  2
  2
  
    
CatalogNumber,catalogNumber,,


  		




  3
  3
  
    
DateLastModified,modified,,


  		




  4
  
  
    
InstitutionCode,institutionCode,,


  		




  5
  
  
    
CollectionCode,collectionCode,,


  		




  
  4
  
    
InstitutionCode,custodialInstitutions,,


  		




  
  5
  
    
CollectionCode,collection,,


  		




  6
  6
  
    
ScientificName,taxonName,,


  		




  7
  7
  
    
BasisOfRecord,basisOfRecord,,


  		




  8
  8
  
    
Kingdom,kingdom,,


  		




  ......




  13
  13
  
    
ScientificNameAuthor,scientificNameAuthorship,,


  		




  14
  14
  
    
IdentifiedBy,identifiedBy,,


  		




  15
  15
  
    
TypeStatus,typeStatus,,


  		




  16
  
  
    
CollectorNumber,recordNumber,,


  		




  
  16
  
    
CollectorNumber,collectorNumber,,


  		




  17
  17
  
    
Collector,recordedBy,,


  		




  18
  18
  
    
DayCollected,dayCollected,,


  		




  19
  19
  
    
MonthCollected,monthCollected,,


  		












  

    
      inputs/VegBank/taxonobservation_/map.csv
    
  





  29
  29
  
    
taxonfit,identificationQualifier,,


  		




  30
  30
  
    
taxonconfidence,*taxonconfidence,,


  		




  31
  31
  
    
collector_id,*collector_id,,


  		




  32
  
  
    
collectionnumber,*collectionnumber,,


  		




  
  32
  
    
collectionnumber,collectorNumber,,


  		




  33
  33
  
    
museum_id,*museum_id,,


  		




  34
  34
  
    
museumaccessionnumber,catalogNumber,,


  		




  35
  35
  
    
grouptype,*grouptype,,


  		












  

    
      inputs/TRTE/Specimen/map.csv
    
  





  1
  1
  
    
TRTE,VegCore,Filter,Comments


  		




  2
  
  
    
id,datasourceRecordID,,


  		




  3
  
  
    
collectionCode,collectionCode,,


  		




  
  2
  
    
id,dataProviderRecordID,,


  		




  
  3
  
    
collectionCode,collection,,


  		




  4
  4
  
    
genus,genus,,


  		




  5
  5
  
    
bibliographicCitation,bibliographicCitation,,


  		




  6
  6
  
    
verbatimLongitude,verbatimLongitude,,


  		




  ......




  15
  15
  
    
verbatimLatitude,verbatimLatitude,,


  		




  16
  16
  
    
family,family,,


  		




  17
  17
  
    
locality,locality,,


  		




  18
  
  
    
recordNumber,recordNumber,,


  		




  
  18
  
    
recordNumber,collectorNumber,,


  		




  19
  19
  
    
basisOfRecord,basisOfRecord,,


  		




  20
  20
  
    
country,country,,


  		




  21
  21
  
    
associatedTaxa,associatedTaxa,,


  		




  ......




  26
  26
  
    
verbatimEventDate,verbatimEventDate,,


  		




  27
  27
  
    
municipality,municipality,,


  		




  28
  28
  
    
geodeticDatum,geodeticDatum,,


  		




  29
  
  
    
institutionCode,institutionCode,,


  		




  
  29
  
    
institutionCode,custodialInstitutions,,


  		




  30
  30
  
    
nomenclaturalCode,nomenclaturalCode,,


  		




  31
  31
  
    
modified,modified,,


  		




  32
  32
  
    
previousIdentifications,previousIdentifications,,


  		




  33
  
  
    
datasetName,datasetName,,


  		




  
  33
  
    
datasetName,dataset,,


  		




  34
  34
  
    
rights,rights,,


  		




  35
  35
  
    
ownerInstitutionCode,ownerInstitutionCode,,


  		




  36
  36
  
    
county,county,,


  		












  

    
      mappings/VegCore.tables.redmine
    
  





  9
  9
  
    
[[VegCore#Geovalidation|Geovalidation]]


  		




  10
  10
  
    
[[VegCore#Location|Location]]


  		




  11
  11
  
    
[[VegCore#LocationObservation|LocationObservation]]


  		




  12
  
  
    
[[VegCore#SoilObservation|SoilObservation]]


  		




  13
  12
  
    
[[VegCore#Subplot|Subplot]]


  		




  14
  13
  
    
[[VegCore#SubplotObservation|SubplotObservation]]


  		




  
  14
  
    
[[VegCore#SoilObservation|SoilObservation]]


  		




  15
  15
  
    
[[VegCore#GeologicalContext|GeologicalContext]]


  		




  16
  16
  
    
[[VegCore#Community|Community]]


  		




  17
  17
  
    
[[VegCore#Taxon|Taxon]]


  		




  ......




  20
  20
  
    
[[VegCore#TaxonOccurrence|TaxonOccurrence]]


  		




  21
  21
  
    
[[VegCore#TaxonDetermination|TaxonDetermination]]


  		




  22
  22
  
    
[[VegCore#OriginalTaxonDetermination|OriginalTaxonDetermination]]


  		




  
  23
  
    
[[VegCore#MatchedTaxonDetermination|MatchedTaxonDetermination]]


  		




  23
  24
  
    
[[VegCore#AcceptedTaxonDetermination|AcceptedTaxonDetermination]]


  		




  24
  25
  
    
[[VegCore#TaxonObservation|TaxonObservation]]


  		




  25
  26
  
    
[[VegCore#AggregateObservation|AggregateObservation]]


  		












  

    
      mappings/for_review/VegCore-VegBIEN.csv
    
  





  1
  1
  
    
VegCore,VegBIEN:/_setDefault:[source_id/source/shortname/_env:[name=source]]/path/_simplifyPath:[next=parent_id]/path,Comments


  		




  2
  2
  
    
catalogNumber,"/_if[@name=""if specimen""]/cond/_exists",


  		




  3
  
  
    
datasourceRecordID,"/_if[@name=""if specimen""]/cond/_exists",


  		




  
  3
  
    
dataProviderRecordID,"/_if[@name=""if specimen""]/cond/_exists",


  		




  4
  4
  
    
occurrenceID,"/_if[@name=""if specimen""]/cond/_exists",


  		




  5
  
  
    
institutionCode,"/_if[@name=""if specimen""]/else/source/shortname",


  		




  
  5
  
    
custodialInstitutions,"/_if[@name=""if specimen""]/else/source/shortname",


  		




  6
  6
  
    
observationGranularity,"/_if[@name=""if specimen""]/else/source/observationtype",


  		




  7
  7
  
    
referenceType,"/_if[@name=""if specimen""]/else/source/sourcetype",


  		




  8
  8
  
    
subplot,"/location/_if[@name=""if subplot""]/cond/_exists",


  		




  ......




  11
  11
  
    
locationID,"/location/authorlocationcode/_if[@name=""if locationID""]/cond/_exists",


  		




  12
  12
  
    
authorEventCode,"/location/authorlocationcode/_if[@name=""if locationID""]/else",


  		




  13
  13
  
    
observationGranularity,"/location/authorlocationcode/_if[@name=""if plot""]/cond",


  		




  14
  
  
    
datasourceRecordID,"/location/authorlocationcode/_if[@name=""if plot""]/else",


  		




  
  14
  
    
dataProviderRecordID,"/location/authorlocationcode/_if[@name=""if plot""]/else",


  		




  15
  15
  
    
occurrenceID,"/location/authorlocationcode/_if[@name=""if plot""]/else",


  		




  16
  16
  
    
catalogNumber,"/location/authorlocationcode/_if[@name=""if catalogNumber""]/cond/_exists",


  		




  17
  17
  
    
catalogNumber,"/location/authorlocationcode/_if[@name=""if specimen""]/cond/_exists",


  		




  18
  
  
    
datasourceRecordID,"/location/authorlocationcode/_if[@name=""if specimen""]/cond/_exists",


  		




  
  18
  
    
dataProviderRecordID,"/location/authorlocationcode/_if[@name=""if specimen""]/cond/_exists",


  		




  19
  19
  
    
occurrenceID,"/location/authorlocationcode/_if[@name=""if specimen""]/cond/_exists",


  		




  20
  
  
    
institutionCode,"/location/authorlocationcode/_if[@name=""if specimen""]/then",


  		




  21
  
  
    
collectionCode,"/location/authorlocationcode/_if[@name=""if catalogNumber""]/then",


  		




  
  20
  
    
collectingInstitution,"/location/authorlocationcode/_if[@name=""if specimen""]/then",


  		




  
  21
  
    
custodialInstitutions,"/location/authorlocationcode/_if[@name=""if specimen""]/then",


  		




  
  22
  
    
collection,"/location/authorlocationcode/_if[@name=""if catalogNumber""]/then",


  		




  22
  23
  
    
collectionID,"/location/authorlocationcode/_if[@name=""if catalogNumber""]/then",


  		




  23
  24
  
    
voucherType,"/location/authorlocationcode/_if[@name=""if indirect voucher""]/cond",


  		




  24
  25
  
    
catalogNumber,"/location/authorlocationcode/_if[@name=""if indirect voucher""]/else",


  		




  ......




  38
  39
  
    
verbatimElevation_m,//location/elevation_m,


  		




  39
  40
  
    
verbatimElevation_m,//location/elevationrange_m,


  		




  40
  41
  
    
verbatimElevation_m,//location/elevationrange_m,


  		




  
  42
  
    
collectorNumber,"//location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists",


  		




  41
  43
  
    
individualID,"//location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists",


  		




  42
  44
  
    
individualObservationID,"//location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists",


  		




  43
  45
  
    
occurrenceID,"//location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists",


  		




  44
  
  
    
recordNumber,"//location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists",


  		




  45
  46
  
    
taxonOccurrenceID,"//location/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists",


  		




  46
  47
  
    
oldGrowth,"//location/iscultivated/_if[@name=""if TaxonOccurrence""]/else",


  		




  47
  48
  
    
cultivated,"//location/iscultivated/_if[@name=""if TaxonOccurrence""]/else",


  		




  ......




  165
  166
  
    
intercept_cm,//aggregateoccurrence/linecover_m/_cm_to_m/value,


  		




  166
  167
  
    
organismNotes,//aggregateoccurrence/notes,


  		




  167
  168
  
    
individualCode,//plantobservation/authorplantcode,


  		




  168
  
  
    
recordNumber,//plantobservation/authorplantcode,


  		




  
  169
  
    
collectorNumber,//plantobservation/authorplantcode,


  		




  169
  170
  
    
sex,"//plantobservation/definedvalue[*_id/userdefined[tablename=plantobservation,userdefinedname=sex]]/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"


  		




  170
  171
  
    
individualObservationID,//plantobservation/sourceaccessioncode,


  		




  171
  172
  
    
individualID,//plantobservation/sourceaccessioncode,


  		




  172
  173
  
    
voucherType,"//specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/cond",


  		




  173
  174
  
    
catalogNumber,"//specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/else",


  		




  174
  
  
    
collectionCode,//specimenreplicate/collectioncode_dwc,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name


  		




  
  175
  
    
collection,//specimenreplicate/collectioncode_dwc,Brad: Not sure if mapping correct. DwC element; code for entire collection; often same as InstitutionCode; Aaron: Combining with InstitutionCode to create collection name


  		




  175
  176
  
    
collectionID,//specimenreplicate/collectioncode_dwc,


  		




  176
  177
  
    
voucherType,"//specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/cond",


  		




  177
  
  
    
recordNumber,"//specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else",


  		




  
  178
  
    
collectorNumber,"//specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/else",


  		




  178
  179
  
    
catalogNumber,"//institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",


  		




  179
  
  
    
datasourceRecordID,"//institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",


  		




  
  180
  
    
dataProviderRecordID,"//institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",


  		




  180
  181
  
    
occurrenceID,"//institution_id/sourcelist/_if[@name=""if specimen""]/cond/_exists",


  		




  181
  
  
    
institutionCode,"//institution_id/sourcelist/_if[@name=""if specimen""]/then/name",


  		




  182
  
  
    
institutionCode,"//institution_id/sourcelist/sourcename/name/_split:[separator=""[,;] *""]/value",


  		




  183
  
  
    
datasourceRecordID,//specimenreplicate/sourceaccessioncode,


  		




  
  182
  
    
collectingInstitution,"//institution_id/sourcelist/_if[@name=""if specimen""]/then/name",


  		




  
  183
  
    
custodialInstitutions,"//institution_id/sourcelist/_if[@name=""if specimen""]/then/name",


  		




  
  184
  
    
collectingInstitution,"//institution_id/sourcelist/_if[@name=""if specimen""]/then/sourcename/name",


  		




  
  185
  
    
custodialInstitutions,"//institution_id/sourcelist/sourcename/name/_split:[separator=""[,;] *""]/value",


  		




  
  186
  
    
dataProviderRecordID,//specimenreplicate/sourceaccessioncode,


  		




  184
  187
  
    
occurrenceID,//specimenreplicate/sourceaccessioncode,


  		




  185
  188
  
    
stemCount,//plantobservation/stemcount,


  		




  186
  189
  
    
authorStemCode,//stemobservation/authorstemcode,


  		




  ......




  214
  217
  
    
authorTaxonCode,"//taxonoccurrence/authortaxoncode/_if[@name=""if individual""]/else",


  		




  215
  218
  
    
individualCode,"//taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then",


  		




  216
  219
  
    
tag,"//taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then",


  		




  217
  
  
    
recordNumber,"//taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then",


  		




  
  220
  
    
collectorNumber,"//taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then",


  		




  218
  221
  
    
originalTaxonName,"//taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then",


  		




  219
  222
  
    
scientificName,"//taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then",


  		




  220
  223
  
    
taxonName,"//taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then",


  		




  ......




  222
  225
  
    
recordedBy_givenName,//party/fullname,


  		




  223
  226
  
    
recordedBy_surName,//party/fullname,


  		




  224
  227
  
    
growthForm,//taxonoccurrence/growthform,


  		




  225
  
  
    
datasourceRecordID,"//taxonoccurrence/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists",


  		




  
  228
  
    
collectorNumber,"//taxonoccurrence/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists",


  		




  
  229
  
    
dataProviderRecordID,"//taxonoccurrence/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists",


  		




  226
  230
  
    
individualID,"//taxonoccurrence/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists",


  		




  227
  231
  
    
individualObservationID,"//taxonoccurrence/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists",


  		




  228
  232
  
    
occurrenceID,"//taxonoccurrence/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists",


  		




  229
  
  
    
recordNumber,"//taxonoccurrence/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists",


  		




  230
  233
  
    
taxonOccurrenceID,"//taxonoccurrence/iscultivated/_if[@name=""if TaxonOccurrence""]/cond/_exists",


  		




  231
  234
  
    
oldGrowth,"//taxonoccurrence/iscultivated/_if[@name=""if TaxonOccurrence""]/then",


  		




  232
  235
  
    
cultivated,"//taxonoccurrence/iscultivated/_if[@name=""if TaxonOccurrence""]/then",


  		




  ......




  236
  239
  
    
aggregateOrganismObservationID,"//taxonoccurrence/sourceaccessioncode/_if[@name=""if organism in AggregateOccurrence""]/cond/_exists",


  		




  237
  240
  
    
individualObservationID,"//taxonoccurrence/sourceaccessioncode/_if[@name=""if organism in AggregateOccurrence""]/else",


  		




  238
  241
  
    
individualID,"//taxonoccurrence/sourceaccessioncode/_if[@name=""if organism in AggregateOccurrence""]/else",


  		




  239
  
  
    
datasourceRecordID,//taxonoccurrence/sourceaccessioncode,


  		




  
  242
  
    
dataProviderRecordID,//taxonoccurrence/sourceaccessioncode,


  		




  240
  243
  
    
occurrenceID,//taxonoccurrence/sourceaccessioncode,


  		




  241
  244
  
    
identifiedBy,//taxonoccurrence/taxondetermination[]/*_id/party/fullname,


  		




  242
  245
  
    
parentScientificNameID,//taxonoccurrence/taxondetermination[]/*_id/taxonverbatim/*_id/taxonlabel/taxonlabel/sourceaccessioncode,


  		




  ......




  319
  322
  
    
voucherType,"//specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/cond",


  		




  320
  323
  
    
catalogNumber,"//specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",


  		




  321
  324
  
    
voucherType,"//specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/cond",


  		




  322
  
  
    
recordNumber,"//specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then",


  		




  
  325
  
    
collectorNumber,"//specimenreplicate/collectionnumber/_if[@name=""if indirect voucher""]/then",


  		




  323
  326
  
    
temperature_C,//locationevent/temperature_c,


  		




  324
  327
  
    
maximumDepthInMeters,//locationevent/waterdepth_m,


  		




  325
  328
  
    
minimumDepthInMeters,//locationevent/waterdepth_m,


  		












  

    
      inputs/.TNRS/public.unscrubbed_taxondetermination_view/new_terms.csv
    
  





  9
  9
  
    
Name_matched_accepted_family,family,/_first/1,Contains family based on matched name


  		




  10
  10
  
    
Genus_matched,genus,,


  		




  11
  11
  
    
Specific_epithet_matched,specificEpithet,,


  		




  12
  
  
    
Infraspecific_rank,OMIT,,Omitted because Name_matched_rank is populated more often


  		




  13
  12
  
    
Infraspecific_epithet_matched,infraspecificEpithet,,


  		




  14
  13
  
    
Unmatched_terms,morphospecies,,


  		




  15
  14
  
    
Accepted_name,acceptedTaxonName,/_first/1,


  		












  

    
      inputs/TRT/Specimen/unmapped_terms.csv
    
  





  15
  15
  
    
georeferencedDate


  		




  16
  16
  
    
bibliographicCitation


  		




  17
  17
  
    
nomenclaturalCode


  		




  18
  
  
    
datasetName


  		




  
  18
  
    
dataset


  		




  19
  19
  
    
ownerInstitutionCode


  		




  20
  20
  
    
basisOfRecord


  		




  21
  21
  
    
georeferenceSources


  		








... This diff was truncated because it exceeds the maximum size that can be displayed.



Also available in:  Unified diff