Project

General

Profile

« Previous | Next » 

Revision 7646

Added by Aaron Marcuse-Kubitza almost 12 years ago

mappings/VegCore.htm: Regenerated from wiki. Documentation has been added on how to choose term names (https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/VegCore#Naming) and how to form globally unique ID values (https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/VegCore#Forming-IDs). Source and Specimen terms have been renamed to be self-explanatory and unambiguous (the DwC equivalents remain as synonyms). Short definitions of Source terms have been added to explain the differences between them. Source, Specimen, and Collection terms have been shortened according to the new instructions for choosing preferred term names (https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/VegCore#Naming).

View differences:

inputs/GBIF/Specimen/new_terms.csv
1 1 
LatestDateCollected,dateCollected,,
2 
InstitutionCD,custodialInstitutions,,
2 
InstitutionCD,specimenHolders,,
3 3 
CollectionCD,collection,,
4 
CatalogNO,catalogNumber,,
4 
CatalogNO,accessionNumber,,
5 5 
LastDateModified,modified,,
6 6 
ScientificNameOriginal,originalTaxonName,,
7 7 
AuthorOfScientificName,scientificNameAuthorship,,
inputs/QFA/Specimen/VegBIEN.csv
86 86 
associatedSequences,,** No join mapping for associatedSequences **
87 87 
basisOfRecord,,** No join mapping for basisOfRecord **
88 88 
bibliographicCitation,,** No join mapping for bibliographicCitation **
89 
datasetID,,** No join mapping for datasetID **
89 
datasetID,,** No join mapping for datasetURL **
90 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 **
94 94 
nomenclaturalCode,,** No join mapping for nomenclaturalCode **
95 95 
occurrenceRemarks,,** No join mapping for occurrenceRemarks **
96 
ownerInstitutionCode,,** No join mapping for ownerInstitutionCode **
96 
ownerInstitutionCode,,** No join mapping for specimenOwner **
97 97 
preparations,,** No join mapping for preparations **
98 98 
rightsHolder,,** No join mapping for rightsHolder **
99 99 
type,,** No join mapping for type **
inputs/JBM/Specimen/map.csv
5 5 
modified,modified,,
6 6 
recordNumber,collectorNumber,,
7 7 
recordedBy,recordedBy,,
8 
ownerInstitutionCode,ownerInstitutionCode,,
8 
ownerInstitutionCode,specimenOwner,,
9 9 
language,language,,
10 10 
genus,genus,,
11 11 
specificEpithet,specificEpithet,,
......
15 15 
geodeticDatum,geodeticDatum,,
16 16 
stateProvince,stateProvince,,
17 17 
locality,locality,,
18 
collectionID,collectionID,,
18 
collectionID,collectionURL,,
19 19 
rightsHolder,rightsHolder,,
20 20 
verbatimLongitude,verbatimLongitude,,
21 21 
nomenclaturalCode,nomenclaturalCode,,
......
34 34 
type,type,,
35 35 
order,order,,
36 36 
kingdom,kingdom,,
37 
institutionCode,custodialInstitutions,,
38 
datasetID,datasetID,,
37 
institutionCode,specimenHolders,,
38 
datasetID,datasetURL,,
39 39 
countryCode,countryCode,,
40 
catalogNumber,catalogNumber,,
40 
catalogNumber,accessionNumber,,
inputs/JBM/Specimen/VegBIEN.csv
69 69 
stateProvince,/location/locationplace/*_id/place/stateprovince,
70 70 
basisOfRecord,,** No join mapping for basisOfRecord **
71 71 
countryCode,,** No join mapping for countryCode **
72 
datasetID,,** No join mapping for datasetID **
72 
datasetID,,** No join mapping for datasetURL **
73 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 **
77 77 
modified,,** No join mapping for modified **
78 78 
nomenclaturalCode,,** No join mapping for nomenclaturalCode **
79 
ownerInstitutionCode,,** No join mapping for ownerInstitutionCode **
79 
ownerInstitutionCode,,** No join mapping for specimenOwner **
80 80 
rightsHolder,,** No join mapping for rightsHolder **
81 81 
type,,** No join mapping for type **
inputs/HVAA/Source/map.csv
1 1 
HVAA,VegCore,Filter,Comments
2 
:herbarium,referenceType,,
2 
:herbarium,sourceType,,
3 3 
:specimen,observationGranularity,,
inputs/HVAA/Specimen/map.csv
1 1 
HVAA,VegCore,Filter,Comments
2 
institutionCode,custodialInstitutions,,
2 
institutionCode,specimenHolders,,
3 3 
collectionCode,collection,,
4 4 
basisOfRecord,basisOfRecord,,
5 
catalogNumber,catalogNumber,,
5 
catalogNumber,accessionNumber,,
6 6 
otherCatalogNumbers,otherCatalogNumbers,,
7 
ownerInstitutionCode,ownerInstitutionCode,,
7 
ownerInstitutionCode,specimenOwner,,
8 8 
family,family,,
9 9 
scientificName,scientificName,,
10 10 
genus,genus,,
inputs/HVAA/Specimen/VegBIEN.csv
120 120 
municipality,,** No join mapping for municipality **
121 121 
occurrenceRemarks,,** No join mapping for occurrenceRemarks **
122 122 
otherCatalogNumbers,,** No join mapping for otherCatalogNumbers **
123 
ownerInstitutionCode,,** No join mapping for ownerInstitutionCode **
123 
ownerInstitutionCode,,** No join mapping for specimenOwner **
124 124 
preparations,,** No join mapping for preparations **
125 125 
rightsHolder,,** No join mapping for rightsHolder **
126 126 
startDayOfYear,,** No join mapping for startDayOfYear **
inputs/HVAA/Specimen/unmapped_terms.csv
1 1 
basisOfRecord
2 2 
otherCatalogNumbers
3 
ownerInstitutionCode
3 
specimenOwner
4 4 
identificationReferences
5 5 
identificationRemarks
6 6 
typeStatus
inputs/MT/Source/map.csv
1 1 
MT,VegCore,Filter,Comments
2 
:herbarium,referenceType,,
2 
:herbarium,sourceType,,
3 3 
:specimen,observationGranularity,,
inputs/MT/Specimen/map.csv
3 3 
establishmentMeans,establishmentMeans,,
4 4 
locality,locality,,
5 5 
language,language,,
6 
collectionID,collectionID,,
6 
collectionID,collectionURL,,
7 7 
occurrenceRemarks,occurrenceRemarks,,
8 8 
type,type,,
9 
institutionCode,custodialInstitutions,,
9 
institutionCode,specimenHolders,,
10 10 
rights,rights,,
11 11 
family,family,,
12 12 
continent,continent,,
inputs/WIN/Specimen/VegBIEN.csv
81 81 
associatedMedia,,** No join mapping for associatedMedia **
82 82 
basisOfRecord,,** No join mapping for basisOfRecord **
83 83 
bibliographicCitation,,** No join mapping for bibliographicCitation **
84 
datasetID,,** No join mapping for datasetID **
84 
datasetID,,** No join mapping for datasetURL **
85 85 
datasetName,,** No join mapping for dataset **
86 86 
geodeticDatum,,** No join mapping for geodeticDatum **
87 87 
identificationRemarks,,** No join mapping for identificationRemarks **
......
89 89 
municipality,,** No join mapping for municipality **
90 90 
nomenclaturalCode,,** No join mapping for nomenclaturalCode **
91 91 
occurrenceRemarks,,** No join mapping for occurrenceRemarks **
92 
ownerInstitutionCode,,** No join mapping for ownerInstitutionCode **
92 
ownerInstitutionCode,,** No join mapping for specimenOwner **
93 93 
rightsHolder,,** No join mapping for rightsHolder **
94 94 
type,,** No join mapping for type **
95 95 
verbatimCoordinateSystem,,** No join mapping for verbatimCoordinateSystem **
inputs/CTFS/Source/map.csv
1 1 
CTFS,VegCore,Filter,Comments
2 
:primary database,referenceType,,
2 
:primary database,sourceType,,
3 3 
:plot,observationGranularity,,
inputs/SALVIAS/Source/map.csv
1 1 
SALVIAS,VegCore,Filter,Comments
2 
:aggregator,referenceType,,
2 
:aggregator,sourceType,,
3 3 
:plot,observationGranularity,,
inputs/U/Specimen/map.csv
1 1 
U,VegCore,Filter,Comments
2 2 
ID,dataProviderRecordID,,
3 
Barcode,catalogNumber,,
3 
Barcode,accessionNumber,,
4 4 
Collector,recordedBy,/_join/1,
5 5 
Prefix,UNUSED,,
6 6 
Number,collectorNumber,,
inputs/GBIF/Specimen/map.csv
4 4 
Collector,recordedBy,,
5 5 
3,*3,,
6 6 
LatestDateCollected,dateCollected,,
7 
InstitutionCD,custodialInstitutions,,
7 
InstitutionCD,specimenHolders,,
8 8 
CollectionCD,collection,,
9 
CatalogNO,catalogNumber,,
9 
CatalogNO,accessionNumber,,
10 10 
LastDateModified,modified,,
11 11 
IdentifiedBy,identifiedBy,,
12 12 
ScientificNameOriginal,originalTaxonName,,
inputs/QFA/Specimen/map.csv
14 14 
identifiedBy,identifiedBy,,
15 15 
associatedReferences,associatedReferences,,
16 16 
kingdom,kingdom,,
17 
institutionCode,custodialInstitutions,,
18 
catalogNumber,catalogNumber,,
17 
institutionCode,specimenHolders,,
18 
catalogNumber,accessionNumber,,
19 19 
verbatimSRS,verbatimSRS,,
20 20 
verbatimLongitude,verbatimLongitude,,
21 21 
rightsHolder,rightsHolder,,
......
34 34 
decimalLongitude,decimalLongitude,,
35 35 
verbatimLatitude,verbatimLatitude,,
36 36 
establishmentMeans,establishmentMeans,,
37 
collectionID,collectionID,,
37 
collectionID,collectionURL,,
38 38 
verbatimCoordinateSystem,verbatimCoordinateSystem,,
39 39 
infraspecificEpithet,infraspecificEpithet,,
40 40 
country,country,,
......
45 45 
stateProvince,stateProvince,,
46 46 
scientificNameAuthorship,scientificNameAuthorship,,
47 47 
verbatimCoordinates,verbatimCoordinates,,
48 
ownerInstitutionCode,ownerInstitutionCode,,
48 
ownerInstitutionCode,specimenOwner,,
49 49 
recordedBy,recordedBy,,
50 50 
preparations,preparations,,
51 
datasetID,datasetID,,
51 
datasetID,datasetURL,,
52 52 
identificationQualifier,identificationQualifier,,
inputs/JBM/Source/map.csv
1 1 
JBM,VegCore,Filter,Comments
2 
:herbarium,referenceType,,
2 
:herbarium,sourceType,,
3 3 
:specimen,observationGranularity,,
inputs/UBC/Source/map.csv
1 1 
UBC,VegCore,Filter,Comments
2 
:herbarium,referenceType,,
2 
:herbarium,sourceType,,
3 3 
:specimen,observationGranularity,,
inputs/test_taxonomic_names/Source/map.csv
1 1 
test_taxonomic_names,VegCore,Filter,Comments
2 
:personal communication,referenceType,,
2 
:personal communication,sourceType,,
inputs/XAL/Source/map.csv
1 1 
XAL,VegCore,Filter,Comments
2 
:herbarium,referenceType,,
2 
:herbarium,sourceType,,
3 3 
:specimen,observationGranularity,,
inputs/XAL/Specimen/map.csv
1 1 
XAL:/content/record/,VegCore,Filter,Comments
2 2 
darwin:DateLastModified,modified,,
3 
darwin:InstitutionCode,custodialInstitutions,,
3 
darwin:InstitutionCode,specimenHolders,,
4 4 
darwin:CollectionCode,collection,,
5 
darwin:CatalogNumber,catalogNumber,,
5 
darwin:CatalogNumber,accessionNumber,,
6 6 
darwin:ScientificName,taxonName,,
7 7 
darwin:BasisOfRecord,basisOfRecord,,
8 8 
darwin:Kingdom,kingdom,,
inputs/XAL/Specimen/new_terms.csv
1 1 
darwin:DateLastModified,modified,,
2 
darwin:InstitutionCode,custodialInstitutions,,
2 
darwin:InstitutionCode,specimenHolders,,
3 3 
darwin:CollectionCode,collection,,
4 
darwin:CatalogNumber,catalogNumber,,
4 
darwin:CatalogNumber,accessionNumber,,
5 5 
darwin:ScientificName,taxonName,,
6 6 
darwin:BasisOfRecord,basisOfRecord,,
7 7 
darwin:Kingdom,kingdom,,
inputs/NCU/Source/map.csv
1 1 
NCU,VegCore,Filter,Comments
2 
:herbarium,referenceType,,
2 
:herbarium,sourceType,,
3 3 
:specimen,observationGranularity,,
inputs/NCU/Specimen/map.csv
4 4 
CollectionObjectTypeID,*CollectionObjectTypeID,,
5 5 
CollectionObjectID,*CollectionObjectID,,
6 6 
database,*database,,
7 
OwnerInstitution,custodialInstitutions,/_alt/2,
8 
CollectionGUID,collectionID,,
7 
OwnerInstitution,specimenHolders,/_alt/2,
8 
CollectionGUID,collectionURL,,
9 9 
OriginalTaxonLabel,originalScientificName,,
10 10 
CurrentScientificName,taxonName,,
11 11 
CurrentScientificNameWithAuthor,scientificName,,
12 12 
TypeStatus,typeStatus,,
13 13 
CollectionDate,dateCollected,,
14 14 
BarCode,OMIT,,"Omitted because this isn't specified on all rows, but SpecimenPK is"
15 
CatalogNumber,catalogNumber,,
16 
CatalogSeriesPrefix,custodialInstitutions,/_alt/1,
15 
CatalogNumber,accessionNumber,,
16 
CatalogSeriesPrefix,specimenHolders,/_alt/1,
17 17 
Description,organismNotes,,
18 18 
LandOwner,*LandOwner,,
19 19 
BlockLocationReason,*BlockLocationReason,,
inputs/NCU/Specimen/new_terms.csv
1 1 
SpecimenPK,occurrenceID,,
2 
OwnerInstitution,custodialInstitutions,/_alt/2,
3 
CollectionGUID,collectionID,,
2 
OwnerInstitution,specimenHolders,/_alt/2,
3 
CollectionGUID,collectionURL,,
4 4 
OriginalTaxonLabel,originalScientificName,,
5 5 
CurrentScientificName,taxonName,,
6 6 
CurrentScientificNameWithAuthor,scientificName,,
7 7 
CollectionDate,dateCollected,,
8 
CatalogSeriesPrefix,custodialInstitutions,/_alt/1,
8 
CatalogSeriesPrefix,specimenHolders,/_alt/1,
9 9 
Description,organismNotes,,
10 10 
CityLocality,verbatimLocality,/_alt/2,
11 11 
Latitude1,decimalLatitude,,
inputs/bien2_traits/TraitObservation/map.csv
21 21 
VerbatimLatitude,verbatimLatitude,,
22 22 
VerbatimLongitude,verbatimLongitude,,
23 23 
VerbatimElevation,verbatimElevation,,
24 
Source,*Source,,
24 
Source,source,,
25 25 
URLSource,*URLSource,,
26 26 
SourceCitation,*SourceCitation,,
27 27 
SourceID,*SourceID,,
inputs/bien2_traits/TraitObservation/VegBIEN.csv
55 55 
ReferenceID,,** No join mapping for *ReferenceID **
56 56 
ReferenceID_index,,** No non-empty join mapping for OMIT **
57 57 
Region,,** No join mapping for *Region **
58 
Source,,** No join mapping for *Source **
58 
Source,,** No join mapping for source **
59 59 
SourceCitation,,** No join mapping for *SourceCitation **
60 60 
SourceID,,** No join mapping for *SourceID **
61 61 
Taxon_index,,** No non-empty join mapping for OMIT **
inputs/bien2_traits/TraitObservation/unmapped_terms.csv
1 1 
*Region
2 2 
*LowerPolitical
3 
*Source
3 
source
4 4 
*URLSource
5 5 
*SourceCitation
6 6 
*SourceID
inputs/bien2_traits/Source/map.csv
1 1 
bien2_traits,VegCore,Filter,Comments
2 
:primary database,referenceType,,
2 
:primary database,sourceType,,
3 3 
:specimen,observationGranularity,,
inputs/TEAM/Source/map.csv
1 1 
TEAM,VegCore,Filter,Comments
2 
:primary database,referenceType,,
2 
:primary database,sourceType,,
3 3 
:plot,observationGranularity,,
inputs/ACAD/Source/map.csv
1 1 
ACAD,VegCore,Filter,Comments
2 
:herbarium,referenceType,,
2 
:herbarium,sourceType,,
3 3 
:specimen,observationGranularity,,
inputs/ACAD/Specimen/map.csv
2 2 
id,dataProviderRecordID,,
3 3 
basisOfRecord,basisOfRecord,,
4 4 
identifiedBy,identifiedBy,,
5 
collectionID,collectionID,,
5 
collectionID,collectionURL,,
6 6 
class,class,,
7 7 
geodeticDatum,geodeticDatum,,
8 8 
reproductiveCondition,reproductiveCondition,,
9 9 
decimalLongitude,decimalLongitude,,
10 
institutionCode,custodialInstitutions,,
10 
institutionCode,specimenHolders,,
11 11 
continent,continent,,
12 12 
recordedBy,recordedBy,,
13 13 
county,county,,
......
41 41 
kingdom,kingdom,,
42 42 
decimalLatitude,decimalLatitude,,
43 43 
genus,genus,,
44 
ownerInstitutionCode,ownerInstitutionCode,,
44 
ownerInstitutionCode,specimenOwner,,
45 45 
collectionCode,collection,,
46 46 
bibliographicCitation,bibliographicCitation,,
47 
catalogNumber,catalogNumber,,
47 
catalogNumber,accessionNumber,,
48 48 
country,country,,
49 49 
dynamicProperties,dynamicProperties,,
inputs/ACAD/Specimen/VegBIEN.csv
93 93 
modified,,** No join mapping for modified **
94 94 
municipality,,** No join mapping for municipality **
95 95 
occurrenceRemarks,,** No join mapping for occurrenceRemarks **
96 
ownerInstitutionCode,,** No join mapping for ownerInstitutionCode **
96 
ownerInstitutionCode,,** No join mapping for specimenOwner **
97 97 
rightsHolder,,** No join mapping for rightsHolder **
98 98 
type,,** No join mapping for type **
99 99 
verbatimDepth,,** No join mapping for verbatimDepth **
inputs/ACAD/Specimen/unmapped_terms.csv
10 10 
identificationRemarks
11 11 
rightsHolder
12 12 
occurrenceRemarks
13 
ownerInstitutionCode
13 
specimenOwner
14 14 
bibliographicCitation
15 15 
dynamicProperties
inputs/.NCBI/Source/map.csv
1 1 
NCBI,VegCore,Filter,Comments
2 
:primary database,referenceType,,
2 
:primary database,sourceType,,
inputs/WIN/Source/map.csv
1 1 
WIN,VegCore,Filter,Comments
2 
:herbarium,referenceType,,
2 
:herbarium,sourceType,,
3 3 
:specimen,observationGranularity,,
inputs/WIN/Specimen/map.csv
7 7 
associatedMedia,associatedMedia,,
8 8 
verbatimSRS,verbatimSRS,,
9 9 
dateIdentified,dateIdentified,,
10 
datasetID,datasetID,,
10 
datasetID,datasetURL,,
11 11 
bibliographicCitation,bibliographicCitation,,
12 12 
taxonRank,taxonRank,,
13 13 
rights,rights,,
......
29 29 
minimumElevationInMeters,minimumElevationInMeters,,
30 30 
datasetName,dataset,,
31 31 
basisOfRecord,basisOfRecord,,
32 
collectionID,collectionID,,
32 
collectionID,collectionURL,,
33 33 
collectionCode,collection,,
34 34 
verbatimCoordinates,verbatimCoordinates,,
35 35 
decimalLatitude,decimalLatitude,,
36 
institutionCode,custodialInstitutions,,
37 
catalogNumber,catalogNumber,,
36 
institutionCode,specimenHolders,,
37 
catalogNumber,accessionNumber,,
38 38 
verbatimLatitude,verbatimLatitude,,
39 39 
identificationRemarks,identificationRemarks,,
40 40 
nomenclaturalCode,nomenclaturalCode,,
......
46 46 
verbatimCoordinateSystem,verbatimCoordinateSystem,,
47 47 
language,language,,
48 48 
geodeticDatum,geodeticDatum,,
49 
ownerInstitutionCode,ownerInstitutionCode,,
49 
ownerInstitutionCode,specimenOwner,,
inputs/WIN/Specimen/unmapped_terms.csv
2 2 
rightsHolder
3 3 
associatedMedia
4 4 
verbatimSRS
5 
datasetID
5 
datasetURL
6 6 
bibliographicCitation
7 7 
occurrenceRemarks
8 8 
type
......
14 14 
verbatimCoordinateSystem
15 15 
language
16 16 
geodeticDatum
17 
ownerInstitutionCode
17 
specimenOwner
inputs/newWorld/Source/map.csv
1 1 
newWorld,VegCore,Filter,Comments
2 
:primary database,referenceType,,
2 
:primary database,sourceType,,
inputs/U/Source/map.csv
1 1 
U,VegCore,Filter,Comments
2 
:herbarium,referenceType,,
2 
:herbarium,sourceType,,
3 3 
:specimen,observationGranularity,,
inputs/GBIF/Source/map.csv
1 1 
GBIF,VegCore,Filter,Comments
2 
:aggregator,referenceType,,
2 
:aggregator,sourceType,,
3 3 
:specimen,observationGranularity,,
inputs/QFA/Source/map.csv
1 1 
QFA,VegCore,Filter,Comments
2 
:herbarium,referenceType,,
2 
:herbarium,sourceType,,
3 3 
:specimen,observationGranularity,,
inputs/QFA/Specimen/unmapped_terms.csv
14 14 
geodeticDatum
15 15 
verbatimCoordinateSystem
16 16 
language
17 
ownerInstitutionCode
17 
specimenOwner
18 18 
preparations
19 
datasetID
19 
datasetURL
inputs/JBM/Specimen/unmapped_terms.csv
1 1 
modified
2 
ownerInstitutionCode
2 
specimenOwner
3 3 
language
4 4 
basisOfRecord
5 5 
geodeticDatum
......
8 8 
dynamicProperties
9 9 
dataset
10 10 
type
11 
datasetID
11 
datasetURL
12 12 
countryCode
inputs/UBC/Specimen/map.csv
21 21 
country,country,,
22 22 
decimalLatitude,decimalLatitude,,
23 23 
language,language,,
24 
ownerInstitutionCode,ownerInstitutionCode,,
24 
ownerInstitutionCode,specimenOwner,,
25 25 
family,family,,
26 26 
datasetName,dataset,,
27 27 
modified,modified,,
......
34 34 
locality,locality,,
35 35 
scientificNameAuthorship,scientificNameAuthorship,,
36 36 
decimalLongitude,decimalLongitude,,
37 
references,references,,
37 
references,distributors,,
38 38 
habitat,habitat,,
39 39 
genus,genus,,
40 
datasetID,datasetID,,
40 
datasetID,datasetURL,,
41 41 
scientificName,scientificName,,
42 42 
dateIdentified,dateIdentified,,
43 43 
associatedMedia,associatedMedia,,
44 44 
kingdom,kingdom,,
45 
catalogNumber,catalogNumber,,
45 
catalogNumber,accessionNumber,,
46 46 
verbatimLatitude,verbatimLatitude,,
47 47 
verbatimCoordinates,verbatimCoordinates,,
48 
collectionID,collectionID,,
48 
collectionID,collectionURL,,
49 49 
type,type,,
50 50 
verbatimSRS,verbatimSRS,,
51 51 
recordedBy,recordedBy,,
......
55 55 
previousIdentifications,previousIdentifications,,
56 56 
identifiedBy,identifiedBy,,
57 57 
associatedSequences,associatedSequences,,
58 
institutionCode,custodialInstitutions,,
58 
institutionCode,specimenHolders,,
inputs/HIBG/Specimen/map.csv
4 4 
dateIdentified,dateIdentified,,
5 5 
rightsHolder,rightsHolder,,
6 6 
verbatimSRS,verbatimSRS,,
7 
references,references,,
7 
references,distributors,,
8 8 
habitat,habitat,,
9 9 
institutionID,UNUSED,,
10 10 
decimalLongitude,decimalLongitude,,
11 11 
verbatimCoordinateSystem,verbatimCoordinateSystem,,
12 
catalogNumber,catalogNumber,,
12 
catalogNumber,accessionNumber,,
13 13 
phylum,phylum,,
14 14 
family,family,,
15 15 
locationRemarks,locationRemarks,,
16 16 
reproductiveCondition,reproductiveCondition,,
17 17 
country,country,,
18 
collectionID,collectionID,,
18 
collectionID,collectionURL,,
19 19 
dynamicProperties,dynamicProperties,,
20 20 
infraspecificEpithet,infraspecificEpithet,,
21 21 
basisOfRecord,basisOfRecord,,
......
24 24 
locality,locality,,
25 25 
datasetName,dataset,,
26 26 
bibliographicCitation,bibliographicCitation,,
27 
datasetID,datasetID,,
28 
institutionCode,custodialInstitutions,,
27 
datasetID,datasetURL,,
28 
institutionCode,specimenHolders,,
29 29 
recordNumber,collectorNumber,,
30 30 
order,order,,
31 31 
kingdom,kingdom,,
......
56 56 
scientificNameAuthorship,scientificNameAuthorship,,
57 57 
collectionCode,collection,,
58 58 
language,language,,
59 
ownerInstitutionCode,ownerInstitutionCode,,
59 
ownerInstitutionCode,specimenOwner,,
60 60 
class,class,,
inputs/HIBG/Source/map.csv
1 1 
HIBG,VegCore,Filter,Comments
2 
:herbarium,referenceType,,
2 
:herbarium,sourceType,,
3 3 
:specimen,observationGranularity,,
inputs/SpeciesLink/Source/map.csv
1 1 
SpeciesLink,VegCore,Filter,Comments
2 
:aggregator,referenceType,,
2 
:aggregator,sourceType,,
3 3 
:specimen,observationGranularity,,
inputs/UBC/Specimen/unmapped_terms.csv
7 7 
basisOfRecord
8 8 
disposition
9 9 
language
10 
ownerInstitutionCode
10 
specimenOwner
11 11 
dataset
12 12 
modified
13 13 
georeferencedDate
14 14 
georeferenceSources
15 15 
bibliographicCitation
16 16 
georeferencedBy
17 
references
18 
datasetID
17 
distributors
18 
datasetURL
19 19 
associatedMedia
20 20 
type
21 21 
verbatimSRS
inputs/HIBG/Specimen/unmapped_terms.csv
1 1 
rightsHolder
2 2 
verbatimSRS
3 
references
3 
distributors
4 4 
verbatimCoordinateSystem
5 5 
dynamicProperties
6 6 
basisOfRecord
7 7 
georeferenceSources
8 8 
dataset
9 9 
bibliographicCitation
10 
datasetID
10 
datasetURL
11 11 
informationWithheld
12 12 
verbatimDepth
13 13 
geodeticDatum
......
21 21 
municipality
22 22 
type
23 23 
language
24 
ownerInstitutionCode
24 
specimenOwner
inputs/UBC/Specimen/VegBIEN.csv
87 87 
associatedSequences,,** No join mapping for associatedSequences **
88 88 
basisOfRecord,,** No join mapping for basisOfRecord **
89 89 
bibliographicCitation,,** No join mapping for bibliographicCitation **
90 
datasetID,,** No join mapping for datasetID **
90 
datasetID,,** No join mapping for datasetURL **
91 91 
datasetName,,** No join mapping for dataset **
92 92 
disposition,,** No join mapping for disposition **
93 93 
geodeticDatum,,** No join mapping for geodeticDatum **
......
99 99 
modified,,** No join mapping for modified **
100 100 
nomenclaturalCode,,** No join mapping for nomenclaturalCode **
101 101 
occurrenceRemarks,,** No join mapping for occurrenceRemarks **
102 
ownerInstitutionCode,,** No join mapping for ownerInstitutionCode **
102 
ownerInstitutionCode,,** No join mapping for specimenOwner **
103 103 
preparations,,** No join mapping for preparations **
104 104 
previousIdentifications,,** No join mapping for previousIdentifications **
105 
references,,** No join mapping for references **
105 
references,,** No join mapping for distributors **
106 106 
rightsHolder,,** No join mapping for rightsHolder **
107 107 
type,,** No join mapping for type **
108 108 
typeStatus,,** No join mapping for typeStatus **
inputs/HIBG/Specimen/VegBIEN.csv
86 86 
associatedMedia,,** No join mapping for associatedMedia **
87 87 
basisOfRecord,,** No join mapping for basisOfRecord **
88 88 
bibliographicCitation,,** No join mapping for bibliographicCitation **
89 
datasetID,,** No join mapping for datasetID **
89 
datasetID,,** No join mapping for datasetURL **
90 90 
datasetName,,** No join mapping for dataset **
91 91 
dynamicProperties,,** No join mapping for dynamicProperties **
92 92 
geodeticDatum,,** No join mapping for geodeticDatum **
......
100 100 
municipality,,** No join mapping for municipality **
101 101 
nomenclaturalCode,,** No join mapping for nomenclaturalCode **
102 102 
occurrenceRemarks,,** No join mapping for occurrenceRemarks **
103 
ownerInstitutionCode,,** No join mapping for ownerInstitutionCode **
104 
references,,** No join mapping for references **
103 
ownerInstitutionCode,,** No join mapping for specimenOwner **
104 
references,,** No join mapping for distributors **
105 105 
rightsHolder,,** No join mapping for rightsHolder **
106 106 
type,,** No join mapping for type **
107 107 
verbatimCoordinateSystem,,** No join mapping for verbatimCoordinateSystem **
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,custodialInstitutions,,
5 
dwc_dwcore_InstitutionCode,specimenHolders,,
6 6 
dwc_dwcore_CollectionCode,collection,,
7 
dwc_dwcore_CatalogNumber,catalogNumber,,
7 
dwc_dwcore_CatalogNumber,accessionNumber,,
8 8 
dwc_dwcore_Remarks,taxonRemarks,,
9 9 
dwc_dwcore_ScientificName,taxonName,,
10 10 
dwc_dwcore_Kingdom,kingdom,,
......
42 42 
dwc_geospatial_VerbatimLatitude,verbatimLatitude,,Contains a mix of DMS and other verbatim coordinates
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 
dwc_terms_collectionID,collectionID,,
46 
dwc_terms_institutionCode,custodialInstitutions,,
45 
dwc_terms_collectionID,collectionURL,,
46 
dwc_terms_institutionCode,specimenHolders,,
47 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 
dwc_terms_catalogNumber,catalogNumber,,
52 
dwc_terms_catalogNumber,accessionNumber,,
53 53 
dwc_terms_occurrenceRemarks,occurrenceRemarks,,
54 54 
dwc_terms_recordNumber,collectorNumber,/_alt/1,
55 55 
dwc_terms_recordedBy,recordedBy,,
......
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,custodialInstitutions,,
96 
conceptual_darwin_2003_1_0_InstitutionCode,specimenHolders,,
97 97 
conceptual_darwin_2003_1_0_CollectionCode,collection,,
98 
conceptual_darwin_2003_1_0_CatalogNumber,catalogNumber,,
98 
conceptual_darwin_2003_1_0_CatalogNumber,accessionNumber,,
99 99 
conceptual_darwin_2003_1_0_ScientificName,taxonName,,
100 100 
conceptual_darwin_2003_1_0_BasisOfRecord,basisOfRecord,,
101 101 
conceptual_darwin_2003_1_0_Kingdom,kingdom,,
inputs/analytical_db/Source/map.csv
1 1 
analytical_db,VegCore,Filter,Comments
2 
:aggregator,referenceType,,
2 
:aggregator,sourceType,,
3 3 
:plot,observationGranularity,,
inputs/Madidi/IndividualObservation/map.csv
11 11 
Trunk,authorStemCode,,
12 12 
Tag,tag,,
13 13 
WasCollected,*WasCollected,,
14 
SpecimenID,catalogNumber,,
14 
SpecimenID,accessionNumber,,
15 15 
SeniorCollector,recordedBy,/_first/1/_merge/1,
16 16 
CollectorString,recordedBy,/_first/1/_merge/2,
17 17 
CollectorStringShortened,recordedBy,/_first/2,
18 18 
CollectionNumber,collectorNumber,,
19 
Institutions,custodialInstitutions,,
19 
Institutions,specimenHolders,,
20 20 
InstitutionString,*InstitutionString,,
21 21 
CollectorAbbrev,recordedBy,/_first/3,
22 22 
CurrentDet,scientificName,,
inputs/UNCC/Specimen/new_terms.csv
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)"
1 
herbarium,specimenIndexer,,"""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,,
inputs/.herbaria/ih/new_terms.csv
1 
acronym,custodialInstitutions,,
1 
acronym,specimenHolders,,
inputs/REMIB/Specimen/map.csv
1 1 
REMIB,VegCore,Filter,Comments
2 
acronym,custodialInstitutions,,
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]
2 
acronym,specimenHolders,,
3 
accession_number,accessionNumber,,"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:


  		




  6
  6
  
    
-----


  		












  

    
      inputs/.TNRS/public.unscrubbed_taxondetermination_view/map.csv
    
  





  34
  34
  
    
Accepted_name_species,*Accepted_name_species,/_first/1,Also contains genus. Omitted because Accepted_name contains more info.


  		




  35
  35
  
    
Accepted_name_family,acceptedFamily,/_first/1/_nullIf:[null=Unknown]/value,


  		




  36
  36
  
    
Selected,*Selected,,


  		




  37
  
  
    
Source,*Source,,


  		




  
  37
  
    
Source,source,,


  		




  38
  38
  
    
Warnings,*Warnings,,


  		




  39
  39
  
    
Accepted_name_lsid,*Accepted_name_lsid,/_first/2,


  		




  40
  40
  
    
Accepted_scientific_name,acceptedScientificName,/_first/1,


  		












  

    
      inputs/ARIZ/Source/map.csv
    
  





  1
  1
  
    
ARIZ,VegCore,Filter,Comments


  		




  2
  
  
    
:herbarium,referenceType,,


  		




  
  2
  
    
:herbarium,sourceType,,


  		




  3
  3
  
    
:specimen,observationGranularity,,


  		












  

    
      inputs/bien_web/observation/map.csv
    
  





  1
  1
  
    
bien_web,VegCore,Filter,Comments


  		




  2
  2
  
    
observationID,occurrenceID,,


  		




  3
  3
  
    
dataSourceID,*dataSourceID,,


  		




  4
  
  
    
dataSourceName,custodialInstitutions,,


  		




  
  4
  
    
dataSourceName,specimenHolders,,


  		




  5
  5
  
    
dataSourceNamePrimary,*dataSourceNamePrimary,,


  		




  6
  6
  
    
plotID,locationID,,


  		




  7
  7
  
    
observationType,observationGranularity,,


  		












  

    
      inputs/Madidi/Source/map.csv
    
  





  1
  1
  
    
Madidi,VegCore,Filter,Comments


  		




  2
  
  
    
:primary database,referenceType,,


  		




  
  2
  
    
:primary database,sourceType,,


  		




  3
  3
  
    
:plot,observationGranularity,,


  		












  

    
      inputs/UNCC/Specimen/map.csv
    
  





  1
  1
  
    
UNCC,VegCore,Filter,Comments


  		




  2
  
  
    
accession,catalogNumber,,"Globally unique, although occasionally duplicated. [1] Bob says this is actually the catalogNumber.


  		




  
  2
  
    
accession,accessionNumber,,"Globally unique, although occasionally duplicated. [1] Bob says this is actually the catalogNumber.


  		




  3
  3
  
    

  		




  4
  4
  
    
[1] Using the following query:


  		




  5
  5
  
    
-----


  		




  ......




  8
  8
  
    
GROUP BY herbarium, accession


  		




  9
  9
  
    
HAVING count(*) > 1


  		




  10
  10
  
    
-----"


  		




  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)"


  		




  
  11
  
    
herbarium,specimenIndexer,,"""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,,


  		












  

    
      inputs/.herbaria/ih/map.csv
    
  





  1
  1
  
    
herbaria,VegCore,Filter,Comments


  		




  2
  2
  
    
eparties_key,*eparties_key,,


  		




  3
  3
  
    
NamOrganisation,*NamOrganisation,,


  		




  4
  
  
    
acronym,custodialInstitutions,,


  		




  
  4
  
    
acronym,specimenHolders,,


  		




  5
  5
  
    
IhhInstitutionType,*IhhInstitutionType,,


  		




  6
  6
  
    
NamBranch,*NamBranch,,


  		




  7
  7
  
    
NamDepartment,*NamDepartment,,


  		




  ......




  31
  31
  
    
AddEmuUserId,*AddEmuUserId,,


  		




  32
  32
  
    
irn,*irn,,


  		




  33
  33
  
    
url,*url,,


  		




  34
  
  
    
:herbarium,referenceType,,


  		




  
  34
  
    
:herbarium,sourceType,,


  		




  35
  35
  
    
:specimen,observationGranularity,,


  		












  

    
      inputs/REMIB/Source/map.csv
    
  





  1
  1
  
    
REMIB,VegCore,Filter,Comments


  		




  2
  
  
    
:aggregator,referenceType,,


  		




  
  2
  
    
:aggregator,sourceType,,


  		




  3
  3
  
    
:specimen,observationGranularity,,


  		












  

    
      inputs/FIA/Source/map.csv
    
  





  1
  1
  
    
FIA,VegCore,Filter,Comments


  		




  2
  
  
    
:primary database,referenceType,,


  		




  
  2
  
    
:primary database,sourceType,,


  		




  3
  3
  
    
:plot,observationGranularity,,


  		












  

    
      inputs/.TNRS/Source/map.csv
    
  





  1
  1
  
    
TNRS,VegCore,Filter,Comments


  		




  2
  
  
    
:aggregator,referenceType,,


  		




  
  2
  
    
:aggregator,sourceType,,


  		












  

    
      inputs/ARIZ/omoccurrences/unmapped_terms.csv
    
  





  2
  2
  
    
*dbpk


  		




  3
  3
  
    
basisOfRecord


  		




  4
  4
  
    
otherCatalogNumbers


  		




  5
  
  
    
ownerInstitutionCode


  		




  
  5
  
    
specimenOwner


  		




  6
  6
  
    
*sciname


  		




  7
  7
  
    
*tidinterpreted


  		




  8
  8
  
    
identificationReferences


  		












  

    
      inputs/bien_web/Source/map.csv
    
  





  1
  1
  
    
bien_web,VegCore,Filter,Comments


  		




  2
  
  
    
:aggregator,referenceType,,


  		




  
  2
  
    
:aggregator,sourceType,,


  		




  3
  3
  
    
:plot,observationGranularity,,


  		












  

    
      inputs/NY/Ecatalog_all/map.csv
    
  





  2
  2
  
    
pkey,OMIT,,"CatalogNumber, etc. is a better pkey"


  		




  3
  3
  
    
key,OMIT,,"CatalogNumber, etc. is a better pkey"


  		




  4
  4
  
    
DateLastModified,modified,,


  		




  5
  
  
    
InstitutionCode,custodialInstitutions,,


  		




  
  5
  
    
InstitutionCode,specimenHolders,,


  		




  6
  6
  
    
CollectionCode,collection,,


  		




  7
  
  
    
CatalogNumber,catalogNumber,,


  		




  
  7
  
    
CatalogNumber,accessionNumber,,


  		




  8
  8
  
    
ScientificName,taxonName,,


  		




  9
  9
  
    
BasisOfRecord,basisOfRecord,,


  		




  10
  10
  
    
Kingdom,kingdom,,


  		












  

    
      inputs/UNCC/Source/map.csv
    
  





  1
  1
  
    
UNCC,VegCore,Filter,Comments


  		




  2
  
  
    
:herbarium,referenceType,,


  		




  
  2
  
    
:herbarium,sourceType,,


  		




  3
  3
  
    
:specimen,observationGranularity,,


  		












  

    
      inputs/.herbaria/Source/map.csv
    
  





  1
  1
  
    
herbaria,VegCore,Filter,Comments


  		




  2
  
  
    
:primary database,referenceType,,


  		




  
  2
  
    
:primary database,sourceType,,


  		












  

    
      inputs/CVS/taxonObservation_/map.csv
    
  





  37
  37
  
    
collectionNumber,collectorNumber,,


  		




  38
  38
  
    
collectionDate,dateCollected,,


  		




  39
  39
  
    
museum_ID,*museum_ID,,


  		




  40
  
  
    
museumAccessionNumber,catalogNumber,,


  		




  
  40
  
    
museumAccessionNumber,accessionNumber,,


  		




  41
  41
  
    
groupType,*groupType,,


  		




  42
  42
  
    
notes,organismNotes,,


  		




  43
  43
  
    
notesPublic,*notesPublic,,


  		












  

    
      inputs/IUCN/Source/map.csv
    
  





  1
  1
  
    
IUCN,VegCore,Filter,Comments


  		




  2
  
  
    
:primary database,referenceType,,


  		




  
  2
  
    
:primary database,sourceType,,


  		












  

    
      inputs/.TNRS/public.unscrubbed_taxondetermination_view/unmapped_terms.csv
    
  





  5
  5
  
    
*Accepted_name_url


  		




  6
  6
  
    
*Accepted_name_species


  		




  7
  7
  
    
*Selected


  		




  8
  
  
    
*Source


  		




  
  8
  
    
source


  		




  9
  9
  
    
*Warnings


  		




  10
  10
  
    
*Accepted_name_lsid


  		




  11
  11
  
    
*Accepted_name.Time_submitted


  		












  

    
      inputs/ARIZ/omoccurrences/VegBIEN.csv
    
  





  138
  138
  
    
observeruid,,** No join mapping for *observeruid ** 


  		




  139
  139
  
    
occurrenceRemarks,,** No join mapping for occurrenceRemarks ** 


  		




  140
  140
  
    
otherCatalogNumbers,,** No join mapping for otherCatalogNumbers ** 


  		




  141
  
  
    
ownerInstitutionCode,,** No join mapping for ownerInstitutionCode ** Only populated for 547 rows


  		




  
  141
  
    
ownerInstitutionCode,,** No join mapping for specimenOwner ** Only populated for 547 rows


  		




  142
  142
  
    
preparations,,** No join mapping for preparations ** 


  		




  143
  143
  
    
previousIdentifications,,** No join mapping for previousIdentifications ** 


  		




  144
  144
  
    
processingstatus,,** No join mapping for *processingstatus ** 


  		












  

    
      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,custodialInstitutions,,


  		




  
  4
  
    
dwc_dwcore_InstitutionCode,specimenHolders,,


  		




  5
  5
  
    
dwc_dwcore_CollectionCode,collection,,


  		




  6
  
  
    
dwc_dwcore_CatalogNumber,catalogNumber,,


  		




  
  6
  
    
dwc_dwcore_CatalogNumber,accessionNumber,,


  		




  7
  7
  
    
dwc_dwcore_Remarks,taxonRemarks,,


  		




  8
  8
  
    
dwc_dwcore_ScientificName,taxonName,,


  		




  9
  9
  
    
dwc_dwcore_Kingdom,kingdom,,


  		




  ......




  41
  41
  
    
dwc_geospatial_VerbatimLatitude,verbatimLatitude,,Contains a mix of DMS and other verbatim coordinates


  		




  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
  
  
    
dwc_terms_collectionID,collectionID,,


  		




  45
  
  
    
dwc_terms_institutionCode,custodialInstitutions,,


  		




  
  44
  
    
dwc_terms_collectionID,collectionURL,,


  		




  
  45
  
    
dwc_terms_institutionCode,specimenHolders,,


  		




  46
  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
  
  
    
dwc_terms_catalogNumber,catalogNumber,,


  		




  
  51
  
    
dwc_terms_catalogNumber,accessionNumber,,


  		




  52
  52
  
    
dwc_terms_occurrenceRemarks,occurrenceRemarks,,


  		




  53
  53
  
    
dwc_terms_recordNumber,collectorNumber,/_alt/1,


  		




  54
  54
  
    
dwc_terms_recordedBy,recordedBy,,


  		




  ......




  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,custodialInstitutions,,


  		




  
  95
  
    
conceptual_darwin_2003_1_0_InstitutionCode,specimenHolders,,


  		




  96
  96
  
    
conceptual_darwin_2003_1_0_CollectionCode,collection,,


  		




  97
  
  
    
conceptual_darwin_2003_1_0_CatalogNumber,catalogNumber,,


  		




  
  97
  
    
conceptual_darwin_2003_1_0_CatalogNumber,accessionNumber,,


  		




  98
  98
  
    
conceptual_darwin_2003_1_0_ScientificName,taxonName,,


  		




  99
  99
  
    
conceptual_darwin_2003_1_0_BasisOfRecord,basisOfRecord,,


  		




  100
  100
  
    
conceptual_darwin_2003_1_0_Kingdom,kingdom,,


  		












  

    
      inputs/NY/Source/map.csv
    
  





  1
  1
  
    
NY,VegCore,Filter,Comments


  		




  2
  
  
    
:herbarium,referenceType,,


  		




  
  2
  
    
:herbarium,sourceType,,


  		




  3
  3
  
    
:specimen,observationGranularity,,


  		












  

    
      inputs/Madidi/IndividualObservation/new_terms.csv
    
  





  2
  2
  
    
PlotInventoryName,authorEventCode,,


  		




  3
  3
  
    
Tree,individualCode,,


  		




  4
  4
  
    
Trunk,authorStemCode,,


  		




  5
  
  
    
SpecimenID,catalogNumber,,


  		




  
  5
  
    
SpecimenID,accessionNumber,,


  		




  6
  6
  
    
SeniorCollector,recordedBy,/_first/1/_merge/1,


  		




  7
  7
  
    
CollectorString,recordedBy,/_first/1/_merge/2,


  		




  8
  8
  
    
CollectorStringShortened,recordedBy,/_first/2,


  		




  9
  
  
    
Institutions,custodialInstitutions,,


  		




  
  9
  
    
Institutions,specimenHolders,,


  		




  10
  10
  
    
CollectorAbbrev,recordedBy,/_first/3,


  		




  11
  11
  
    
CurrentDet,scientificName,,


  		




  12
  12
  
    
CurrentDetRank,taxonRank,,


  		












  

    
      inputs/SALVIAS-CSV/Source/map.csv
    
  





  1
  1
  
    
SALVIAS-CSV,VegCore,Filter,Comments


  		




  2
  
  
    
:aggregator,referenceType,,


  		




  
  2
  
    
:aggregator,sourceType,,


  		




  3
  3
  
    
:plot,observationGranularity,,


  		












  

    
      inputs/CVS/Source/map.csv
    
  





  1
  1
  
    
CVS,VegCore,Filter,Comments


  		




  2
  
  
    
:primary database,referenceType,,


  		




  
  2
  
    
:primary database,sourceType,,


  		




  3
  3
  
    
:plot,observationGranularity,,


  		












  

    
      inputs/REMIB/Specimen/new_terms.csv
    
  





  1
  
  
    
acronym,custodialInstitutions,,


  		




  
  1
  
    
acronym,specimenHolders,,


  		




  2
  2
  
    
long_deg,decimalLongitude,,


  		




  3
  3
  
    
lat_deg,decimalLatitude,,


  		




  4
  4
  
    
coll_day,dayCollected,,


  		












  

    
      inputs/.TNRS/public.unscrubbed_taxondetermination_view/VegBIEN.csv
    
  





  157
  157
  
    
Name_score,,** No join mapping for *Name_score ** 


  		




  158
  158
  
    
Name_submitted,,** No non-empty join mapping for OMIT ** Omitted because taxonoccurrence_id used to identify the taxonoccurrence instead


  		




  159
  159
  
    
Selected,,** No join mapping for *Selected ** 


  		




  160
  
  
    
Source,,** No join mapping for *Source ** 


  		




  
  160
  
    
Source,,** No join mapping for source ** 


  		




  161
  161
  
    
Time_submitted,,** No join mapping for *Time_submitted ** 


  		




  162
  162
  
    
Warnings,,** No join mapping for *Warnings ** 


  		












  

    
      inputs/ARIZ/omoccurrences/map.csv
    
  





  4
  4
  
    
dbpk,*dbpk,,Only populated for 2651 rows


  		




  5
  5
  
    
basisOfRecord,basisOfRecord,,


  		




  6
  6
  
    
occurrenceID,occurrenceID,/_first/2,Not populated for all rows


  		




  7
  
  
    
catalogNumber,catalogNumber,,


  		




  
  7
  
    
catalogNumber,accessionNumber,,


  		




  8
  8
  
    
institutionID,UNUSED,,


  		




  9
  9
  
    
collectionID,UNUSED,,


  		




  10
  10
  
    
institutionCode,UNUSED,,


  		




  11
  11
  
    
collectionCode,UNUSED,,


  		




  12
  12
  
    
datasetID,UNUSED,,


  		




  13
  13
  
    
otherCatalogNumbers,otherCatalogNumbers,,


  		




  14
  
  
    
ownerInstitutionCode,ownerInstitutionCode,,Only populated for 547 rows


  		




  
  14
  
    
ownerInstitutionCode,specimenOwner,,Only populated for 547 rows


  		




  15
  15
  
    
family,family,,


  		




  16
  16
  
    
scientificName,scientificName,,


  		




  17
  17
  
    
sciname,*sciname,,


  		












  

    
      inputs/NVS/Source/map.csv
    
  





  1
  1
  
    
NVS,VegCore,Filter,Comments


  		




  2
  
  
    
:primary database,referenceType,,


  		




  
  2
  
    
:primary database,sourceType,,


  		




  3
  3
  
    
:plot,observationGranularity,,


  		












  

    
      inputs/TRT/Specimen/unmapped_terms.csv
    
  





  10
  10
  
    
verbatimEventDate


  		




  11
  11
  
    
georeferenceVerificationStatus


  		




  12
  12
  
    
associatedMedia


  		




  13
  
  
    
datasetID


  		




  
  13
  
    
datasetURL


  		




  14
  14
  
    
georeferencedDate


  		




  15
  15
  
    
bibliographicCitation


  		




  16
  16
  
    
nomenclaturalCode


  		




  17
  17
  
    
dataset


  		




  18
  
  
    
ownerInstitutionCode


  		




  
  18
  
    
specimenOwner


  		




  19
  19
  
    
basisOfRecord


  		




  20
  20
  
    
georeferenceSources


  		




  21
  21
  
    
previousIdentifications


  		












  

    
      inputs/VASCAN/Taxon/map.csv
    
  





  2
  2
  
    
id,taxonID,,


  		




  3
  3
  
    
nameAccordingTo,nameAccordingTo,,


  		




  4
  4
  
    
nameAccordingToID,nameAccordingToID,,


  		




  5
  
  
    
datasetID,datasetID,,


  		




  6
  
  
    
references,references,,


  		




  
  5
  
    
datasetID,datasetURL,,


  		




  
  6
  
    
references,distributors,,


  		




  7
  7
  
    
specificEpithet,specificEpithet,,


  		




  8
  8
  
    
higherClassification,higherClassification,,


  		




  9
  9
  
    
genus,genus,,


  		












  

    
      inputs/TRT/Specimen/VegBIEN.csv
    
  





  94
  94
  
    
associatedReferences,,** No join mapping for associatedReferences ** 


  		




  95
  95
  
    
basisOfRecord,,** No join mapping for basisOfRecord ** 


  		




  96
  96
  
    
bibliographicCitation,,** No join mapping for bibliographicCitation ** 


  		




  97
  
  
    
datasetID,,** No join mapping for datasetID ** 


  		




  
  97
  
    
datasetID,,** No join mapping for datasetURL ** 


  		




  98
  98
  
    
datasetName,,** No join mapping for dataset ** 


  		




  99
  99
  
    
geodeticDatum,,** No join mapping for geodeticDatum ** 


  		




  100
  100
  
    
georeferenceProtocol,,** No join mapping for georeferenceProtocol ** 


  		




  ......




  110
  110
  
    
nomenclaturalCode,,** No join mapping for nomenclaturalCode ** 


  		




  111
  111
  
    
occurrenceRemarks,,** No join mapping for occurrenceRemarks ** 


  		




  112
  112
  
    
otherCatalogNumbers,,** No join mapping for otherCatalogNumbers ** 


  		




  113
  
  
    
ownerInstitutionCode,,** No join mapping for ownerInstitutionCode ** 


  		




  
  113
  
    
ownerInstitutionCode,,** No join mapping for specimenOwner ** 


  		




  114
  114
  
    
previousIdentifications,,** No join mapping for previousIdentifications ** 


  		




  115
  115
  
    
rightsHolder,,** No join mapping for rightsHolder ** 


  		




  116
  116
  
    
type,,** No join mapping for type ** 


  		












  

    
      inputs/VASCAN/Source/map.csv
    
  





  1
  1
  
    
VASCAN,VegCore,Filter,Comments


  		




  2
  
  
    
:herbarium,referenceType,,


  		




  
  2
  
    
:herbarium,sourceType,,


  		




  3
  3
  
    
:specimen,observationGranularity,,


  		












  

    
      inputs/TRT/Specimen/map.csv
    
  





  34
  34
  
    
verbatimCoordinates,verbatimCoordinates,,


  		




  35
  35
  
    
establishmentMeans,establishmentMeans,,


  		




  36
  36
  
    
verbatimEventDate,verbatimEventDate,,


  		




  37
  
  
    
catalogNumber,catalogNumber,,


  		




  
  37
  
    
catalogNumber,accessionNumber,,


  		




  38
  38
  
    
georeferenceVerificationStatus,georeferenceVerificationStatus,,


  		




  39
  39
  
    
stateProvince,stateProvince,,


  		




  40
  40
  
    
associatedMedia,associatedMedia,,


  		




  41
  
  
    
datasetID,datasetID,,


  		




  
  41
  
    
datasetID,datasetURL,,


  		




  42
  42
  
    
georeferencedDate,georeferencedDate,,


  		




  43
  43
  
    
eventDate,eventDate,,


  		




  44
  44
  
    
kingdom,kingdom,,


  		




  ......




  48
  48
  
    
identificationQualifier,identificationQualifier,,


  		




  49
  49
  
    
datasetName,dataset,,


  		




  50
  50
  
    
decimalLatitude,decimalLatitude,,


  		




  51
  
  
    
ownerInstitutionCode,ownerInstitutionCode,,


  		




  
  51
  
    
ownerInstitutionCode,specimenOwner,,


  		




  52
  52
  
    
basisOfRecord,basisOfRecord,,


  		




  53
  53
  
    
georeferenceSources,georeferenceSources,,


  		




  54
  54
  
    
previousIdentifications,previousIdentifications,,


  		




  55
  55
  
    
verbatimCoordinateSystem,verbatimCoordinateSystem,,


  		




  56
  56
  
    
locationRemarks,locationRemarks,,


  		




  57
  57
  
    
genus,genus,,


  		




  58
  
  
    
institutionCode,custodialInstitutions,,


  		




  
  58
  
    
institutionCode,specimenHolders,,


  		




  59
  59
  
    
higherClassification,higherClassification,,


  		




  60
  60
  
    
verbatimSRS,verbatimSRS,,


  		




  61
  61
  
    
municipality,municipality,,


  		




  62
  62
  
    
identifiedBy,identifiedBy,,


  		




  63
  63
  
    
otherCatalogNumbers,otherCatalogNumbers,,


  		




  64
  
  
    
collectionID,collectionID,,


  		




  
  64
  
    
collectionID,collectionURL,,


  		




  65
  65
  
    
language,language,,


  		




  66
  66
  
    
recordedBy,recordedBy,,


  		




  67
  67
  
    
minimumElevationInMeters,minimumElevationInMeters,,


  		












  

    
      inputs/MO/Specimen/map.csv
    
  





  1
  1
  
    
MO,VegCore,Filter,Comments


  		




  2
  
  
    
CatalogNumber,catalogNumber,,


  		




  
  2
  
    
CatalogNumber,accessionNumber,,


  		




  3
  3
  
    
DateLastModified,modified,,


  		




  4
  
  
    
InstitutionCode,custodialInstitutions,,


  		




  
  4
  
    
InstitutionCode,specimenHolders,,


  		




  5
  5
  
    
CollectionCode,collection,,


  		




  6
  6
  
    
ScientificName,taxonName,,


  		




  7
  7
  
    
BasisOfRecord,basisOfRecord,,


  		












  

    
      inputs/VASCAN/Taxon/unmapped_terms.csv
    
  





  1
  1
  
    
nameAccordingToID


  		




  2
  
  
    
datasetID


  		




  3
  
  
    
references


  		




  
  2
  
    
datasetURL


  		




  
  3
  
    
distributors


  		




  4
  4
  
    
higherClassification


  		




  5
  5
  
    
rightsHolder


  		




  6
  6
  
    
bibliographicCitation


  		












  

    
      inputs/TRT/Source/map.csv
    
  





  1
  1
  
    
TRT,VegCore,Filter,Comments


  		




  2
  
  
    
:herbarium,referenceType,,


  		




  
  2
  
    
:herbarium,sourceType,,


  		




  3
  3
  
    
:specimen,observationGranularity,,


  		












  

    
      inputs/MO/Source/map.csv
    
  





  1
  1
  
    
MO,VegCore,Filter,Comments


  		




  2
  
  
    
:herbarium,referenceType,,


  		




  
  2
  
    
:herbarium,sourceType,,


  		




  3
  3
  
    
:specimen,observationGranularity,,


  		












  

    
      inputs/VASCAN/Taxon/VegBIEN.csv
    
  





  31
  31
  
    
acceptedNameUsage,,** No join mapping for acceptedNameUsage ** 


  		




  32
  32
  
    
acceptedNameUsageID,,** No join mapping for acceptedNameUsageID ** 


  		




  33
  33
  
    
bibliographicCitation,,** No join mapping for bibliographicCitation ** 


  		




  34
  
  
    
datasetID,,** No join mapping for datasetID ** 


  		




  
  34
  
    
datasetID,,** No join mapping for datasetURL ** 


  		




  35
  35
  
    
datasetName,,** No join mapping for dataset ** 


  		




  36
  36
  
    
higherClassification,,** No join mapping for higherClassification ** 


  		




  37
  37
  
    
language,,** No join mapping for language ** 


  		




  ......




  40
  40
  
    
nomenclaturalCode,,** No join mapping for nomenclaturalCode ** 


  		




  41
  41
  
    
parentNameUsage,,** No join mapping for parentNameUsage ** 


  		




  42
  42
  
    
parentNameUsageID,,** No join mapping for parentNameUsageID ** 


  		




  43
  
  
    
references,,** No join mapping for references ** 


  		




  
  43
  
    
references,,** No join mapping for distributors ** 


  		




  44
  44
  
    
rightsHolder,,** No join mapping for rightsHolder ** 


  		




  45
  45
  
    
subgenus,,** No join mapping for subgenus ** 


  		












  

    
      inputs/VegBank/taxonobservation_/map.csv
    
  





  31
  31
  
    
collector_id,*collector_id,,


  		




  32
  32
  
    
collectionnumber,collectorNumber,,


  		




  33
  33
  
    
museum_id,*museum_id,,


  		




  34
  
  
    
museumaccessionnumber,catalogNumber,,


  		




  
  34
  
    
museumaccessionnumber,accessionNumber,,


  		




  35
  35
  
    
grouptype,*grouptype,,


  		




  36
  36
  
    
notes,organismNotes,,


  		




  37
  37
  
    
notespublic,*notespublic,,


  		








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



Also available in:  Unified diff