Project

General

Profile

« Previous | Next » 

Revision 6834

mappings/VegCore.csv: Terms: Removed namespace prefixes (dcterms:), because VegCore terms are globally unique within VegCore and there should not be multiple versions of the same VegCore term with different namespaces. Provenance is instead indicated in the Sources column, which contains not just a namespace but a full URL to each source term.

View differences:

inputs/MT/Specimen/new_terms.csv
1
type,dcterms_type,,
inputs/ACAD/Specimen/new_terms.csv
1
type,dcterms_type,,
inputs/WIN/Specimen/new_terms.csv
1
type,dcterms_type,,
inputs/QFA/Specimen/new_terms.csv
1
type,dcterms_type,,
inputs/JBM/Specimen/new_terms.csv
1
type,dcterms_type,,
inputs/UBC/Specimen/new_terms.csv
1
type,dcterms_type,,
inputs/HIBG/Specimen/new_terms.csv
1
type,dcterms_type,,
inputs/SpeciesLink/Specimen/unmapped_terms.csv
1
dcterms_modified
1
modified
2 2
basisOfRecord
3 3
day
4 4
typeStatus
5
dcterms_modified
5
modified
6 6
basisOfRecord
7 7
typeStatus
8 8
occurrenceRemarks
......
14 14
year
15 15
month
16 16
day
17
dcterms_modified
17
modified
18 18
basisOfRecord
19 19
typeStatus
20 20
day
inputs/NY/Specimen/unmapped_terms.csv
1
dcterms_modified
1
modified
2 2
basisOfRecord
3 3
typeStatus
4 4
day
inputs/UBC/Specimen/map.csv
7 7
nomenclaturalCode,nomenclaturalCode,,
8 8
verbatimElevation,verbatimElevation,,
9 9
occurrenceRemarks,occurrenceRemarks,,
10
rightsHolder,dcterms_rightsHolder,,
10
rightsHolder,rightsHolder,,
11 11
verbatimLongitude,verbatimLongitude,,
12
rights,dcterms_rights,,
12
rights,rights,,
13 13
recordNumber,recordNumber,,
14 14
preparations,preparations,,
15 15
taxonRemarks,taxonRemarks,,
......
20 20
disposition,disposition,,
21 21
country,country,,
22 22
decimalLatitude,decimalLatitude,,
23
language,dcterms_language,,
23
language,language,,
24 24
ownerInstitutionCode,ownerInstitutionCode,,
25 25
family,family,,
26 26
datasetName,datasetName,,
27
modified,dcterms_modified,,
27
modified,modified,,
28 28
eventDate,eventDate,,
29 29
georeferencedDate,georeferencedDate,,
30 30
georeferenceSources,georeferenceSources,,
31
bibliographicCitation,dcterms_bibliographicCitation,,
31
bibliographicCitation,bibliographicCitation,,
32 32
georeferencedBy,georeferencedBy,,
33 33
stateProvince,stateProvince,,
34 34
locality,locality,,
35 35
scientificNameAuthorship,scientificNameAuthorship,,
36 36
decimalLongitude,decimalLongitude,,
37
references,dcterms_references,,
37
references,references,,
38 38
habitat,habitat,,
39 39
genus,genus,,
40 40
datasetID,datasetID,,
......
46 46
verbatimLatitude,verbatimLatitude,,
47 47
verbatimCoordinates,verbatimCoordinates,,
48 48
collectionID,collectionID,,
49
type,dcterms_type,,
49
type,type,,
50 50
verbatimSRS,verbatimSRS,,
51 51
recordedBy,recordedBy,,
52 52
infraspecificEpithet,infraspecificEpithet,,
inputs/UBC/Specimen/unmapped_terms.csv
1 1
institutionID
2 2
nomenclaturalCode
3 3
occurrenceRemarks
4
dcterms_rightsHolder
4
rightsHolder
5 5
preparations
6 6
geodeticDatum
7 7
associatedReferences
8 8
basisOfRecord
9 9
disposition
10
dcterms_language
10
language
11 11
ownerInstitutionCode
12 12
datasetName
13
dcterms_modified
13
modified
14 14
georeferencedDate
15 15
georeferenceSources
16
dcterms_bibliographicCitation
16
bibliographicCitation
17 17
georeferencedBy
18
dcterms_references
18
references
19 19
datasetID
20 20
associatedMedia
21
dcterms_type
21
type
22 22
verbatimSRS
23 23
typeStatus
24 24
previousIdentifications
inputs/HIBG/Specimen/VegBIEN.csv
95 95
verbatimElevation,/location/verbatimelevation,
96 96
associatedMedia,,** No join mapping for associatedMedia ** 
97 97
basisOfRecord,,** No join mapping for basisOfRecord ** 
98
bibliographicCitation,,** No join mapping for dcterms_bibliographicCitation ** 
98
bibliographicCitation,,** No join mapping for bibliographicCitation ** 
99 99
datasetID,,** No join mapping for datasetID ** 
100 100
datasetName,,** No join mapping for datasetName ** 
101 101
dynamicProperties,,** No join mapping for dynamicProperties ** 
......
105 105
identificationRemarks,,** No join mapping for identificationRemarks ** 
106 106
informationWithheld,,** No join mapping for informationWithheld ** 
107 107
institutionID,,** No join mapping for institutionID ** 
108
language,,** No join mapping for dcterms_language ** 
108
language,,** No join mapping for language ** 
109 109
locationRemarks,,** No join mapping for locationRemarks ** 
110
modified,,** No join mapping for dcterms_modified ** 
110
modified,,** No join mapping for modified ** 
111 111
municipality,,** No join mapping for municipality ** 
112 112
nomenclaturalCode,,** No join mapping for nomenclaturalCode ** 
113 113
occurrenceRemarks,,** No join mapping for occurrenceRemarks ** 
114 114
ownerInstitutionCode,,** No join mapping for ownerInstitutionCode ** 
115
references,,** No join mapping for dcterms_references ** 
115
references,,** No join mapping for references ** 
116 116
reproductiveCondition,,** No join mapping for reproductiveCondition ** 
117
rightsHolder,,** No join mapping for dcterms_rightsHolder ** 
118
type,,** No join mapping for dcterms_type ** 
117
rightsHolder,,** No join mapping for rightsHolder ** 
118
type,,** No join mapping for type ** 
119 119
verbatimCoordinateSystem,,** No join mapping for verbatimCoordinateSystem ** 
120 120
verbatimDepth,,** No join mapping for verbatimDepth ** 
121 121
verbatimSRS,,** No join mapping for verbatimSRS ** 
inputs/SpeciesLink/Specimen/map.csv
1 1
SpeciesLink,VegCore,Filter,Comments
2 2
dwc_dwcore_GlobalUniqueIdentifier,occurrenceID,,
3
dwc_dwcore_DateLastModified,dcterms_modified,,
3
dwc_dwcore_DateLastModified,modified,,
4 4
dwc_dwcore_BasisOfRecord,basisOfRecord,,
5 5
dwc_dwcore_InstitutionCode,institutionCode,,
6 6
dwc_dwcore_CollectionCode,collectionCode,,
......
41 41
dwc_geospatial_DecimalLongitude,decimalLongitude,,
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
http__purl_org_dc_terms_modified,dcterms_modified,,
44
http__purl_org_dc_terms_modified,modified,,
45 45
dwc_terms_collectionID,collectionID,,
46 46
dwc_terms_institutionCode,institutionCode,,
47 47
dwc_terms_collectionCode,collectionCode,,
......
92 92
dwc_terms_specificEpithet,specificEpithet,,
93 93
dwc_terms_infraspecificEpithet,infraspecificEpithet,,
94 94
dwc_terms_scientificNameAuthorship,scientificNameAuthorship,/_alt/1,
95
conceptual_darwin_2003_1_0_DateLastModified,dcterms_modified,,
95
conceptual_darwin_2003_1_0_DateLastModified,modified,,
96 96
conceptual_darwin_2003_1_0_InstitutionCode,institutionCode,,
97 97
conceptual_darwin_2003_1_0_CollectionCode,collectionCode,,
98 98
conceptual_darwin_2003_1_0_CatalogNumber,catalogNumber,,
inputs/SpeciesLink/Specimen/new_terms.csv
1 1
dwc_dwcore_GlobalUniqueIdentifier,occurrenceID,,
2
dwc_dwcore_DateLastModified,dcterms_modified,,
2
dwc_dwcore_DateLastModified,modified,,
3 3
dwc_dwcore_BasisOfRecord,basisOfRecord,,
4 4
dwc_dwcore_InstitutionCode,institutionCode,,
5 5
dwc_dwcore_CollectionCode,collectionCode,,
......
40 40
dwc_geospatial_DecimalLongitude,decimalLongitude,,
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
http__purl_org_dc_terms_modified,dcterms_modified,,
43
http__purl_org_dc_terms_modified,modified,,
44 44
dwc_terms_collectionID,collectionID,,
45 45
dwc_terms_institutionCode,institutionCode,,
46 46
dwc_terms_collectionCode,collectionCode,,
......
91 91
dwc_terms_specificEpithet,specificEpithet,,
92 92
dwc_terms_infraspecificEpithet,infraspecificEpithet,,
93 93
dwc_terms_scientificNameAuthorship,scientificNameAuthorship,/_alt/1,
94
conceptual_darwin_2003_1_0_DateLastModified,dcterms_modified,,
94
conceptual_darwin_2003_1_0_DateLastModified,modified,,
95 95
conceptual_darwin_2003_1_0_InstitutionCode,institutionCode,,
96 96
conceptual_darwin_2003_1_0_CollectionCode,collectionCode,,
97 97
conceptual_darwin_2003_1_0_CatalogNumber,catalogNumber,,
inputs/NY/Specimen/VegBIEN.csv
88 88
StateProvince,/location/locationplace/*_id/place/stateprovince,
89 89
BasisOfRecord,,** No join mapping for basisOfRecord ** 
90 90
CollectorNumber,,** No non-empty join mapping for UNUSED ** 
91
DateLastModified,,** No join mapping for dcterms_modified ** 
91
DateLastModified,,** No join mapping for modified ** 
92 92
JulianDay,,** No join mapping for day ** 
93 93
PreparationType,,** No join mapping for preparations ** 
94 94
PreviousCatalogNumber,,** No join mapping for otherCatalogNumbers ** 
inputs/CVS/plot_/new_terms.csv
1 1
authorPlotCode,locationName,,
2 2
PARENT_ID,parentLocationID,,
3 3
locationAccuracy,coordinateUncertaintyInMeters,/_alt/2,
4
confidentialityStatus,dcterms_accessRights,"/_map:[./{0,1,2,3,4}=public,5=""data by request"",6=private]/value",Values defined at <http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1581&entity=dba_fielddescription&params=1581>
4
confidentialityStatus,accessRights,"/_map:[./{0,1,2,3,4}=public,5=""data by request"",6=private]/value",Values defined at <http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1581&entity=dba_fielddescription&params=1581>
5 5
confidentialityStatus,coordinateUncertaintyInMeters,"/_alt/1/_km_to_m/value/_map:[1=1,2=10,3=100,./{0,4,5,6}=]/value",Values defined at <http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1581&entity=dba_fielddescription&params=1581>
6 6
shape,footprintWKT,,
7 7
area,plotArea_m2,,"""Total area of the plot in m2"" (area definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename>)"
inputs/MT/Specimen/map.csv
2 2
id,occurrenceID,,
3 3
establishmentMeans,establishmentMeans,,
4 4
locality,locality,,
5
language,dcterms_language,,
5
language,language,,
6 6
collectionID,collectionID,,
7 7
occurrenceRemarks,occurrenceRemarks,,
8
type,dcterms_type,,
8
type,type,,
9 9
institutionCode,institutionCode,,
10
rights,dcterms_rights,,
10
rights,rights,,
11 11
family,family,,
12 12
continent,continent,,
13 13
collectionCode,collectionCode,,
14 14
datasetName,datasetName,,
15
rightsHolder,dcterms_rightsHolder,,
15
rightsHolder,rightsHolder,,
16 16
genus,genus,,
17 17
basisOfRecord,basisOfRecord,,
18 18
individualCount,individualCount,,
inputs/MT/Specimen/VegBIEN.csv
35 35
basisOfRecord,,** No join mapping for basisOfRecord ** 
36 36
countryCode,,** No join mapping for countryCode ** 
37 37
datasetName,,** No join mapping for datasetName ** 
38
language,,** No join mapping for dcterms_language ** 
38
language,,** No join mapping for language ** 
39 39
occurrenceRemarks,,** No join mapping for occurrenceRemarks ** 
40
rightsHolder,,** No join mapping for dcterms_rightsHolder ** 
41
type,,** No join mapping for dcterms_type ** 
40
rightsHolder,,** No join mapping for rightsHolder ** 
41
type,,** No join mapping for type ** 
inputs/MT/Specimen/unmapped_terms.csv
1
dcterms_language
1
language
2 2
occurrenceRemarks
3
dcterms_type
3
type
4 4
datasetName
5
dcterms_rightsHolder
5
rightsHolder
6 6
basisOfRecord
7 7
countryCode
inputs/XAL/Specimen/map.csv
1 1
XAL:/content/record/,VegCore,Filter,Comments
2
darwin:DateLastModified,dcterms_modified,,
2
darwin:DateLastModified,modified,,
3 3
darwin:InstitutionCode,institutionCode,,
4 4
darwin:CollectionCode,collectionCode,,
5 5
darwin:CatalogNumber,catalogNumber,,
inputs/XAL/Specimen/VegBIEN.csv
79 79
darwin:StateProvince,/location/locationplace/*_id/place/stateprovince,
80 80
darwin:BasisOfRecord,,** No join mapping for basisOfRecord ** 
81 81
darwin:CoordinatePrecision,,** No non-empty join mapping for UNUSED ** 
82
darwin:DateLastModified,,** No join mapping for dcterms_modified ** 
82
darwin:DateLastModified,,** No join mapping for modified ** 
83 83
darwin:FieldNumber,,** No non-empty join mapping for 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).
84 84
darwin:JulianDay,,** No join mapping for day ** 
85 85
darwin:PreparationType,,** No join mapping for preparations ** 
inputs/XAL/Specimen/new_terms.csv
1
darwin:DateLastModified,dcterms_modified,,
1
darwin:DateLastModified,modified,,
2 2
darwin:InstitutionCode,institutionCode,,
3 3
darwin:CollectionCode,collectionCode,,
4 4
darwin:CatalogNumber,catalogNumber,,
inputs/TRT/Specimen/new_terms.csv
1
type,dcterms_type,,
inputs/ARIZ/Specimen/map.csv
1 1
ARIZ,VegCore,Filter,Comments
2 2
GlobalUniqueIdentifier,occurrenceID,,
3
DateLastModified,dcterms_modified,,
3
DateLastModified,modified,,
4 4
BasisOfRecord,basisOfRecord,,
5 5
InstitutionCode,institutionCode,,
6 6
CollectionCode,collectionCode,,
inputs/NVS/Coordinates/map.csv
3 3
Project Abbreviation,projectName,,
4 4
Plot,locationName,,
5 5
Method,*Method,,
6
Type,*Type,,
6
Type,type,,
7 7
XEast Long,verbatimCoordinates,"/_join/2/_label[label=""x""]/value",
8 8
XPrecision,*XPrecision,,
9 9
YNorth Lat,verbatimCoordinates,"/_join/3/_label[label=""y""]/value",
inputs/XAL/Specimen/unmapped_terms.csv
1
dcterms_modified
1
modified
2 2
basisOfRecord
3 3
typeStatus
4 4
day
inputs/ACAD/Specimen/map.csv
13 13
county,county,,
14 14
order,order,,
15 15
georeferenceSources,georeferenceSources,,
16
language,dcterms_language,,
16
language,language,,
17 17
georeferenceVerificationStatus,georeferenceVerificationStatus,,
18 18
verbatimElevation,verbatimElevation,,
19 19
locationRemarks,locationRemarks,,
......
21 21
verbatimDepth,verbatimDepth,,
22 22
municipality,municipality,,
23 23
infraspecificEpithet,infraspecificEpithet,,
24
modified,dcterms_modified,,
25
type,dcterms_type,,
24
modified,modified,,
25
type,type,,
26 26
specificEpithet,specificEpithet,,
27 27
identificationRemarks,identificationRemarks,,
28
rightsHolder,dcterms_rightsHolder,,
28
rightsHolder,rightsHolder,,
29 29
recordNumber,recordNumber,,
30 30
eventDate,eventDate,,
31
rights,dcterms_rights,,
31
rights,rights,,
32 32
occurrenceRemarks,occurrenceRemarks,,
33 33
habitat,habitat,,
34 34
family,family,,
......
43 43
genus,genus,,
44 44
ownerInstitutionCode,ownerInstitutionCode,,
45 45
collectionCode,collectionCode,,
46
bibliographicCitation,dcterms_bibliographicCitation,,
46
bibliographicCitation,bibliographicCitation,,
47 47
catalogNumber,catalogNumber,,
48 48
country,country,,
49 49
dynamicProperties,dynamicProperties,,
inputs/ACAD/Specimen/VegBIEN.csv
93 93
stateProvince,/location/locationplace/*_id/place/stateprovince,
94 94
verbatimElevation,/location/verbatimelevation,
95 95
basisOfRecord,,** No join mapping for basisOfRecord ** 
96
bibliographicCitation,,** No join mapping for dcterms_bibliographicCitation ** 
96
bibliographicCitation,,** No join mapping for bibliographicCitation ** 
97 97
dynamicProperties,,** No join mapping for dynamicProperties ** 
98 98
geodeticDatum,,** No join mapping for geodeticDatum ** 
99 99
georeferenceSources,,** No join mapping for georeferenceSources ** 
100 100
georeferenceVerificationStatus,,** No join mapping for georeferenceVerificationStatus ** 
101 101
identificationRemarks,,** No join mapping for identificationRemarks ** 
102
language,,** No join mapping for dcterms_language ** 
102
language,,** No join mapping for language ** 
103 103
locationRemarks,,** No join mapping for locationRemarks ** 
104
modified,,** No join mapping for dcterms_modified ** 
104
modified,,** No join mapping for modified ** 
105 105
municipality,,** No join mapping for municipality ** 
106 106
occurrenceRemarks,,** No join mapping for occurrenceRemarks ** 
107 107
ownerInstitutionCode,,** No join mapping for ownerInstitutionCode ** 
108 108
reproductiveCondition,,** No join mapping for reproductiveCondition ** 
109
rightsHolder,,** No join mapping for dcterms_rightsHolder ** 
110
type,,** No join mapping for dcterms_type ** 
109
rightsHolder,,** No join mapping for rightsHolder ** 
110
type,,** No join mapping for type ** 
111 111
verbatimDepth,,** No join mapping for verbatimDepth ** 
inputs/ACAD/Specimen/unmapped_terms.csv
2 2
geodeticDatum
3 3
reproductiveCondition
4 4
georeferenceSources
5
dcterms_language
5
language
6 6
georeferenceVerificationStatus
7 7
locationRemarks
8 8
verbatimDepth
9 9
municipality
10
dcterms_modified
11
dcterms_type
10
modified
11
type
12 12
identificationRemarks
13
dcterms_rightsHolder
13
rightsHolder
14 14
occurrenceRemarks
15 15
ownerInstitutionCode
16
dcterms_bibliographicCitation
16
bibliographicCitation
17 17
dynamicProperties
inputs/WIN/Specimen/map.csv
2 2
id,occurrenceID,,
3 3
municipality,municipality,,
4 4
verbatimLongitude,verbatimLongitude,,
5
rightsHolder,dcterms_rightsHolder,,
5
rightsHolder,rightsHolder,,
6 6
scientificNameAuthorship,scientificNameAuthorship,,
7 7
associatedMedia,associatedMedia,,
8 8
verbatimSRS,verbatimSRS,,
9 9
dateIdentified,dateIdentified,,
10 10
datasetID,datasetID,,
11
bibliographicCitation,dcterms_bibliographicCitation,,
11
bibliographicCitation,bibliographicCitation,,
12 12
taxonRank,taxonRank,,
13
rights,dcterms_rights,,
13
rights,rights,,
14 14
occurrenceRemarks,occurrenceRemarks,,
15 15
verbatimElevation,verbatimElevation,,
16 16
eventDate,eventDate,,
17 17
recordNumber,recordNumber,,
18 18
county,county,,
19
type,dcterms_type,,
19
type,type,,
20 20
stateProvince,stateProvince,,
21 21
locality,locality,,
22 22
scientificName,scientificName,,
......
44 44
decimalLongitude,decimalLongitude,,
45 45
genus,genus,,
46 46
verbatimCoordinateSystem,verbatimCoordinateSystem,,
47
language,dcterms_language,,
47
language,language,,
48 48
geodeticDatum,geodeticDatum,,
49 49
ownerInstitutionCode,ownerInstitutionCode,,
inputs/WIN/Specimen/VegBIEN.csv
90 90
verbatimElevation,/location/verbatimelevation,
91 91
associatedMedia,,** No join mapping for associatedMedia ** 
92 92
basisOfRecord,,** No join mapping for basisOfRecord ** 
93
bibliographicCitation,,** No join mapping for dcterms_bibliographicCitation ** 
93
bibliographicCitation,,** No join mapping for bibliographicCitation ** 
94 94
datasetID,,** No join mapping for datasetID ** 
95 95
datasetName,,** No join mapping for datasetName ** 
96 96
geodeticDatum,,** No join mapping for geodeticDatum ** 
97 97
identificationRemarks,,** No join mapping for identificationRemarks ** 
98
language,,** No join mapping for dcterms_language ** 
98
language,,** No join mapping for language ** 
99 99
municipality,,** No join mapping for municipality ** 
100 100
nomenclaturalCode,,** No join mapping for nomenclaturalCode ** 
101 101
occurrenceRemarks,,** No join mapping for occurrenceRemarks ** 
102 102
ownerInstitutionCode,,** No join mapping for ownerInstitutionCode ** 
103
rightsHolder,,** No join mapping for dcterms_rightsHolder ** 
104
type,,** No join mapping for dcterms_type ** 
103
rightsHolder,,** No join mapping for rightsHolder ** 
104
type,,** No join mapping for type ** 
105 105
verbatimCoordinateSystem,,** No join mapping for verbatimCoordinateSystem ** 
106 106
verbatimEventDate,,** No join mapping for verbatimEventDate ** 
107 107
verbatimSRS,,** No join mapping for verbatimSRS ** 
inputs/WIN/Specimen/unmapped_terms.csv
1 1
municipality
2
dcterms_rightsHolder
2
rightsHolder
3 3
associatedMedia
4 4
verbatimSRS
5 5
datasetID
6
dcterms_bibliographicCitation
6
bibliographicCitation
7 7
occurrenceRemarks
8
dcterms_type
8
type
9 9
verbatimEventDate
10 10
datasetName
11 11
basisOfRecord
12 12
identificationRemarks
13 13
nomenclaturalCode
14 14
verbatimCoordinateSystem
15
dcterms_language
15
language
16 16
geodeticDatum
17 17
ownerInstitutionCode
inputs/SALVIAS/plotMetadata_/map.csv
2 2
MethodCode,OMIT,,Not globally unique after lookup_MethodCode_Description is combined with PlotMethod
3 3
PlotID,locationID,,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
4 4
orig_filename,*orig_filename,,
5
AccessCode,dcterms_accessRights,"/_map:[1=private,2=""metadata only"",3=public]/value","3 plots contain 3 in this field and ""del"" in tmp_del"
5
AccessCode,accessRights,"/_map:[1=private,2=""metadata only"",3=public]/value","3 plots contain 3 in this field and ""del"" in tmp_del"
6 6
project_id,projectID,,
7 7
PrimOwnerID,*PrimOwnerID,,
8 8
SiteCode,locationName,,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
inputs/SALVIAS/plotMetadata_/new_terms.csv
1 1
MethodCode,OMIT,,Not globally unique after lookup_MethodCode_Description is combined with PlotMethod
2
AccessCode,dcterms_accessRights,"/_map:[1=private,2=""metadata only"",3=public]/value","3 plots contain 3 in this field and ""del"" in tmp_del"
2
AccessCode,accessRights,"/_map:[1=private,2=""metadata only"",3=public]/value","3 plots contain 3 in this field and ""del"" in tmp_del"
3 3
SiteCode,locationName,,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
4 4
MajorGeo,continent,,
5 5
PolDiv1,stateProvince,,Brad: No; pol1=stateProvince
inputs/QFA/Specimen/map.csv
1 1
QFA,VegCore,Filter,Comments
2 2
id,occurrenceID,,
3
rights,dcterms_rights,,
3
rights,rights,,
4 4
recordNumber,recordNumber,,
5 5
family,family,,
6 6
associatedSequences,associatedSequences,,
......
18 18
catalogNumber,catalogNumber,,
19 19
verbatimSRS,verbatimSRS,,
20 20
verbatimLongitude,verbatimLongitude,,
21
rightsHolder,dcterms_rightsHolder,,
21
rightsHolder,rightsHolder,,
22 22
dateIdentified,dateIdentified,,
23 23
acceptedNameUsage,acceptedNameUsage,,
24 24
nomenclaturalCode,nomenclaturalCode,,
25
bibliographicCitation,dcterms_bibliographicCitation,,
25
bibliographicCitation,bibliographicCitation,,
26 26
taxonRank,taxonRank,,
27 27
decimalLatitude,decimalLatitude,,
28 28
genus,genus,,
29 29
basisOfRecord,basisOfRecord,,
30 30
occurrenceRemarks,occurrenceRemarks,,
31
type,dcterms_type,,
31
type,type,,
32 32
habitat,habitat,,
33 33
geodeticDatum,geodeticDatum,,
34 34
decimalLongitude,decimalLongitude,,
......
38 38
verbatimCoordinateSystem,verbatimCoordinateSystem,,
39 39
infraspecificEpithet,infraspecificEpithet,,
40 40
country,country,,
41
language,dcterms_language,,
41
language,language,,
42 42
eventDate,eventDate,,
43 43
collectionCode,collectionCode,,
44 44
scientificName,scientificName,,
inputs/QFA/Specimen/VegBIEN.csv
96 96
associatedReferences,,** No join mapping for associatedReferences ** 
97 97
associatedSequences,,** No join mapping for associatedSequences ** 
98 98
basisOfRecord,,** No join mapping for basisOfRecord ** 
99
bibliographicCitation,,** No join mapping for dcterms_bibliographicCitation ** 
99
bibliographicCitation,,** No join mapping for bibliographicCitation ** 
100 100
datasetID,,** No join mapping for datasetID ** 
101 101
datasetName,,** No join mapping for datasetName ** 
102 102
geodeticDatum,,** No join mapping for geodeticDatum ** 
103 103
institutionID,,** No join mapping for institutionID ** 
104
language,,** No join mapping for dcterms_language ** 
104
language,,** No join mapping for language ** 
105 105
nomenclaturalCode,,** No join mapping for nomenclaturalCode ** 
106 106
occurrenceRemarks,,** No join mapping for occurrenceRemarks ** 
107 107
ownerInstitutionCode,,** No join mapping for ownerInstitutionCode ** 
108 108
preparations,,** No join mapping for preparations ** 
109
rightsHolder,,** No join mapping for dcterms_rightsHolder ** 
110
type,,** No join mapping for dcterms_type ** 
109
rightsHolder,,** No join mapping for rightsHolder ** 
110
type,,** No join mapping for type ** 
111 111
typeStatus,,** No join mapping for typeStatus ** 
112 112
verbatimCoordinateSystem,,** No join mapping for verbatimCoordinateSystem ** 
113 113
verbatimEventDate,,** No join mapping for verbatimEventDate ** 
inputs/QFA/Specimen/unmapped_terms.csv
5 5
verbatimEventDate
6 6
associatedReferences
7 7
verbatimSRS
8
dcterms_rightsHolder
8
rightsHolder
9 9
acceptedNameUsage
10 10
nomenclaturalCode
11
dcterms_bibliographicCitation
11
bibliographicCitation
12 12
basisOfRecord
13 13
occurrenceRemarks
14
dcterms_type
14
type
15 15
geodeticDatum
16 16
verbatimCoordinateSystem
17
dcterms_language
17
language
18 18
ownerInstitutionCode
19 19
preparations
20 20
datasetID
inputs/GBIF/Specimen/map.csv
7 7
InstitutionCD,institutionCode,,
8 8
CollectionCD,collectionCode,,
9 9
CatalogNO,catalogNumber,,
10
LastDateModified,dcterms_modified,,
10
LastDateModified,modified,,
11 11
IdentifiedBy,identifiedBy,,
12 12
ScientificNameOriginal,originalTaxonName,,
13 13
AuthorOfScientificName,scientificNameAuthorship,,
inputs/GBIF/Specimen/VegBIEN.csv
77 77
3,,** No join mapping for *3 ** 
78 78
DecimalLatitude,,"** No non-empty join mapping for OMIT ** Contains VerbatimLatitude cast to a low-resolution float, which created spurious repeating decimals"
79 79
DecimalLongitude,,"** No non-empty join mapping for OMIT ** Contains VerbatimLongitude cast to a low-resolution float, which created spurious repeating decimals"
80
LastDateModified,,** No join mapping for dcterms_modified ** 
80
LastDateModified,,** No join mapping for modified ** 
inputs/GBIF/Specimen/new_terms.csv
2 2
InstitutionCD,institutionCode,,
3 3
CollectionCD,collectionCode,,
4 4
CatalogNO,catalogNumber,,
5
LastDateModified,dcterms_modified,,
5
LastDateModified,modified,,
6 6
ScientificNameOriginal,originalTaxonName,,
7 7
AuthorOfScientificName,scientificNameAuthorship,,
8 8
GBIFFamilyOriginal,originalFamily,,
inputs/GBIF/Specimen/unmapped_terms.csv
1 1
*0
2 2
*1
3 3
*3
4
dcterms_modified
4
modified
5 5
*25
inputs/JBM/Specimen/map.csv
2 2
id,occurrenceID,,
3 3
minimumElevationInMeters,minimumElevationInMeters,,
4 4
verbatimLatitude,verbatimLatitude,,
5
modified,dcterms_modified,,
5
modified,modified,,
6 6
recordNumber,recordNumber,,
7 7
recordedBy,recordedBy,,
8 8
ownerInstitutionCode,ownerInstitutionCode,,
9
language,dcterms_language,,
9
language,language,,
10 10
genus,genus,,
11 11
specificEpithet,specificEpithet,,
12 12
coordinateUncertaintyInMeters,coordinateUncertaintyInMeters,,
......
16 16
stateProvince,stateProvince,,
17 17
locality,locality,,
18 18
collectionID,collectionID,,
19
rightsHolder,dcterms_rightsHolder,,
19
rightsHolder,rightsHolder,,
20 20
verbatimLongitude,verbatimLongitude,,
21 21
nomenclaturalCode,nomenclaturalCode,,
22 22
county,county,,
......
28 28
eventDate,eventDate,,
29 29
habitat,habitat,,
30 30
country,country,,
31
rights,dcterms_rights,,
31
rights,rights,,
32 32
decimalLongitude,decimalLongitude,,
33 33
collectionCode,collectionCode,,
34
type,dcterms_type,,
34
type,type,,
35 35
order,order,,
36 36
kingdom,kingdom,,
37 37
institutionCode,institutionCode,,
inputs/JBM/Specimen/VegBIEN.csv
80 80
datasetName,,** No join mapping for datasetName ** 
81 81
dynamicProperties,,** No join mapping for dynamicProperties ** 
82 82
geodeticDatum,,** No join mapping for geodeticDatum ** 
83
language,,** No join mapping for dcterms_language ** 
84
modified,,** No join mapping for dcterms_modified ** 
83
language,,** No join mapping for language ** 
84
modified,,** No join mapping for modified ** 
85 85
nomenclaturalCode,,** No join mapping for nomenclaturalCode ** 
86 86
ownerInstitutionCode,,** No join mapping for ownerInstitutionCode ** 
87
rightsHolder,,** No join mapping for dcterms_rightsHolder ** 
88
type,,** No join mapping for dcterms_type ** 
87
rightsHolder,,** No join mapping for rightsHolder ** 
88
type,,** No join mapping for type ** 
inputs/JBM/Specimen/unmapped_terms.csv
1
dcterms_modified
1
modified
2 2
ownerInstitutionCode
3
dcterms_language
3
language
4 4
basisOfRecord
5 5
geodeticDatum
6
dcterms_rightsHolder
6
rightsHolder
7 7
nomenclaturalCode
8 8
dynamicProperties
9 9
datasetName
10
dcterms_type
10
type
11 11
datasetID
12 12
countryCode
inputs/UBC/Specimen/VegBIEN.csv
96 96
associatedReferences,,** No join mapping for associatedReferences ** 
97 97
associatedSequences,,** No join mapping for associatedSequences ** 
98 98
basisOfRecord,,** No join mapping for basisOfRecord ** 
99
bibliographicCitation,,** No join mapping for dcterms_bibliographicCitation ** 
99
bibliographicCitation,,** No join mapping for bibliographicCitation ** 
100 100
datasetID,,** No join mapping for datasetID ** 
101 101
datasetName,,** No join mapping for datasetName ** 
102 102
disposition,,** No join mapping for disposition ** 
......
105 105
georeferencedBy,,** No join mapping for georeferencedBy ** 
106 106
georeferencedDate,,** No join mapping for georeferencedDate ** 
107 107
institutionID,,** No join mapping for institutionID ** 
108
language,,** No join mapping for dcterms_language ** 
109
modified,,** No join mapping for dcterms_modified ** 
108
language,,** No join mapping for language ** 
109
modified,,** No join mapping for modified ** 
110 110
nomenclaturalCode,,** No join mapping for nomenclaturalCode ** 
111 111
occurrenceRemarks,,** No join mapping for occurrenceRemarks ** 
112 112
ownerInstitutionCode,,** No join mapping for ownerInstitutionCode ** 
113 113
preparations,,** No join mapping for preparations ** 
114 114
previousIdentifications,,** No join mapping for previousIdentifications ** 
115
references,,** No join mapping for dcterms_references ** 
116
rightsHolder,,** No join mapping for dcterms_rightsHolder ** 
117
type,,** No join mapping for dcterms_type ** 
115
references,,** No join mapping for references ** 
116
rightsHolder,,** No join mapping for rightsHolder ** 
117
type,,** No join mapping for type ** 
118 118
typeStatus,,** No join mapping for typeStatus ** 
119 119
verbatimSRS,,** No join mapping for verbatimSRS ** 
inputs/HIBG/Specimen/map.csv
2 2
id,occurrenceID,,
3 3
county,county,,
4 4
dateIdentified,dateIdentified,,
5
rightsHolder,dcterms_rightsHolder,,
5
rightsHolder,rightsHolder,,
6 6
verbatimSRS,verbatimSRS,,
7
references,dcterms_references,,
7
references,references,,
8 8
habitat,habitat,,
9 9
institutionID,institutionID,,
10 10
decimalLongitude,decimalLongitude,,
......
23 23
identifiedBy,identifiedBy,,
24 24
locality,locality,,
25 25
datasetName,datasetName,,
26
bibliographicCitation,dcterms_bibliographicCitation,,
26
bibliographicCitation,bibliographicCitation,,
27 27
datasetID,datasetID,,
28 28
institutionCode,institutionCode,,
29 29
recordNumber,recordNumber,,
......
36 36
associatedMedia,associatedMedia,,
37 37
nomenclaturalCode,nomenclaturalCode,,
38 38
waterBody,waterBody,,
39
rights,dcterms_rights,,
39
rights,rights,,
40 40
stateProvince,stateProvince,,
41 41
recordedBy,recordedBy,,
42 42
decimalLatitude,decimalLatitude,,
43
modified,dcterms_modified,,
43
modified,modified,,
44 44
verbatimCoordinates,verbatimCoordinates,,
45 45
continent,continent,,
46 46
identificationRemarks,identificationRemarks,,
......
49 49
municipality,municipality,,
50 50
genus,genus,,
51 51
taxonRank,taxonRank,,
52
type,dcterms_type,,
52
type,type,,
53 53
eventDate,eventDate,,
54 54
scientificName,scientificName,,
55 55
verbatimElevation,verbatimElevation,,
56 56
scientificNameAuthorship,scientificNameAuthorship,,
57 57
collectionCode,collectionCode,,
58
language,dcterms_language,,
58
language,language,,
59 59
ownerInstitutionCode,ownerInstitutionCode,,
60 60
class,class,,
inputs/HIBG/Specimen/unmapped_terms.csv
1
dcterms_rightsHolder
1
rightsHolder
2 2
verbatimSRS
3
dcterms_references
3
references
4 4
institutionID
5 5
verbatimCoordinateSystem
6 6
locationRemarks
......
9 9
basisOfRecord
10 10
georeferenceSources
11 11
datasetName
12
dcterms_bibliographicCitation
12
bibliographicCitation
13 13
datasetID
14 14
informationWithheld
15 15
verbatimDepth
......
17 17
associatedMedia
18 18
nomenclaturalCode
19 19
waterBody
20
dcterms_modified
20
modified
21 21
identificationRemarks
22 22
georeferenceVerificationStatus
23 23
occurrenceRemarks
24 24
municipality
25
dcterms_type
26
dcterms_language
25
type
26
language
27 27
ownerInstitutionCode
inputs/SpeciesLink/Specimen/VegBIEN.csv
298 298
dwc_terms_stateProvince,/location/locationplace/*_id/place/stateprovince,
299 299
conceptual_darwin_2003_1_0_BasisOfRecord,,** No join mapping for basisOfRecord ** 
300 300
conceptual_darwin_2003_1_0_CoordinatePrecision,,** No join mapping for coordinatePrecision ** 
301
conceptual_darwin_2003_1_0_DateLastModified,,** No join mapping for dcterms_modified ** 
301
conceptual_darwin_2003_1_0_DateLastModified,,** No join mapping for modified ** 
302 302
conceptual_darwin_2003_1_0_JulianDay,,** No join mapping for day/_alt/1 ** 
303 303
conceptual_darwin_2003_1_0_PreparationType,,** No join mapping for preparations ** 
304 304
conceptual_darwin_2003_1_0_PreviousCatalogNumber,,** No join mapping for otherCatalogNumbers ** 
......
308 308
conceptual_darwin_2003_1_0_TypeStatus,,** No join mapping for typeStatus ** 
309 309
dwc_curatorial_TypeStatus,,** No join mapping for typeStatus ** 
310 310
dwc_dwcore_BasisOfRecord,,** No join mapping for basisOfRecord ** 
311
dwc_dwcore_DateLastModified,,** No join mapping for dcterms_modified ** 
311
dwc_dwcore_DateLastModified,,** No join mapping for modified ** 
312 312
dwc_dwcore_DayOfYear,,** No join mapping for day/_alt/2 ** 
313 313
dwc_terms_basisOfRecord,,** No join mapping for basisOfRecord ** 
314 314
dwc_terms_day,,** No join mapping for day ** 
......
321 321
dwc_terms_startDayOfYear,,** No join mapping for startDayOfYear ** 
322 322
dwc_terms_typeStatus,,** No join mapping for typeStatus ** 
323 323
dwc_terms_year,,** No join mapping for year ** 
324
http__purl_org_dc_terms_modified,,** No join mapping for dcterms_modified ** 
324
http__purl_org_dc_terms_modified,,** No join mapping for modified ** 
inputs/NY/Specimen/map.csv
1 1
NY,VegCore,Filter,Comments
2 2
key,OMIT,,UniqueNYInternalRecordNumber is a better pkey
3
DateLastModified,dcterms_modified,,
3
DateLastModified,modified,,
4 4
InstitutionCode,institutionCode,,
5 5
CollectionCode,collectionCode,,
6 6
CatalogNumber,catalogNumber,,
inputs/CVS/plot_/map.csv
8 8
realLatitude,PRIVATE,,
9 9
realLongitude,PRIVATE,,
10 10
locationAccuracy,coordinateUncertaintyInMeters,/_alt/2,
11
confidentialityStatus,dcterms_accessRights,"/_map:[./{0,1,2,3,4}=public,5=""data by request"",6=private]/value",Values defined at <http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1581&entity=dba_fielddescription&params=1581>
11
confidentialityStatus,accessRights,"/_map:[./{0,1,2,3,4}=public,5=""data by request"",6=private]/value",Values defined at <http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1581&entity=dba_fielddescription&params=1581>
12 12
confidentialityStatus,coordinateUncertaintyInMeters,"/_alt/1/_km_to_m/value/_map:[1=1,2=10,3=100,./{0,4,5,6}=]/value",Values defined at <http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1581&entity=dba_fielddescription&params=1581>
13 13
confidentialityFieldsBlocked,*confidentialityFieldsBlocked,,
14 14
confidentialityReason,*confidentialityReason,,
inputs/ARIZ/Specimen/unmapped_terms.csv
1
dcterms_modified
1
modified
2 2
basisOfRecord
3 3
eventTime
4 4
day
inputs/ARIZ/Specimen/VegBIEN.csv
102 102
StateProvince,/location/locationplace/*_id/place/stateprovince,
103 103
AgeClass,,** No join mapping for lifeStage ** 
104 104
BasisOfRecord,,** No join mapping for basisOfRecord ** 
105
DateLastModified,,** No join mapping for dcterms_modified ** 
105
DateLastModified,,** No join mapping for modified ** 
106 106
FieldNumber,,"** No non-empty join mapping for OMIT ** Usage inconsistent with DwC definition: meaning is recordNumber. Identical to CollectorNumber [1], so does not need to be mapped.
107 107

  
108 108
[1] The following query returns no rows: SELECT * FROM ""ARIZ"".""Specimen"" WHERE ""CollectorNumber"" IS DISTINCT FROM ""FieldNumber"""
inputs/TRTE/Specimen/new_terms.csv
1
type,dcterms_type,,
inputs/NVS/Coordinates/VegBIEN.csv
17 17
Map Sheet,,** No join mapping for *Map Sheet ** 
18 18
Method,,** No join mapping for *Method ** 
19 19
Plot Obs ID,,** No join mapping for *Plot Obs ID ** 
20
Type,,** No join mapping for *Type ** 
20
Type,,** No join mapping for type ** 
21 21
Units,,** No join mapping for *Units ** 
22 22
XPrecision,,** No join mapping for *XPrecision ** 
inputs/TRT/Specimen/unmapped_terms.csv
3 3
occurrenceRemarks
4 4
associatedReferences
5 5
georeferenceProtocol
6
dcterms_type
6
type
7 7
institutionID
8
dcterms_rightsHolder
8
rightsHolder
9 9
georeferencedBy
10 10
georeferenceRemarks
11 11
geodeticDatum
......
14 14
associatedMedia
15 15
datasetID
16 16
georeferencedDate
17
dcterms_bibliographicCitation
17
bibliographicCitation
18 18
nomenclaturalCode
19 19
datasetName
20 20
ownerInstitutionCode
......
27 27
verbatimSRS
28 28
municipality
29 29
otherCatalogNumbers
30
dcterms_language
30
language
inputs/VASCAN/Taxon/map.csv
3 3
nameAccordingTo,nameAccordingTo,,
4 4
nameAccordingToID,nameAccordingToID,,
5 5
datasetID,datasetID,,
6
references,dcterms_references,,
6
references,references,,
7 7
specificEpithet,specificEpithet,,
8 8
higherClassification,higherClassification,,
9 9
genus,genus,,
10 10
order,order,,
11
rightsHolder,dcterms_rightsHolder,,
12
bibliographicCitation,dcterms_bibliographicCitation,,
13
language,dcterms_language,,
11
rightsHolder,rightsHolder,,
12
bibliographicCitation,bibliographicCitation,,
13
language,language,,
14 14
family,family,,
15 15
acceptedNameUsageID,acceptedNameUsageID,,
16
rights,dcterms_rights,,
16
rights,rights,,
17 17
taxonRank,taxonRank,,
18 18
taxonomicStatus,taxonomicStatus,,
19 19
infraspecificEpithet,infraspecificEpithet,,
......
21 21
class,class,,
22 22
parentNameUsage,parentNameUsage,,
23 23
parentNameUsageID,parentNameUsageID,,
24
modified,dcterms_modified,,
24
modified,modified,,
25 25
acceptedNameUsage,acceptedNameUsage,,
26 26
scientificNameAuthorship,scientificNameAuthorship,,
27 27
subgenus,subgenus,,
inputs/VegBank/plot_/new_terms.csv
1 1
authorplotcode,locationName,,
2 2
parent_id,parentLocationID,,
3 3
locationaccuracy,coordinateUncertaintyInMeters,/_alt/2,
4
confidentialitystatus,dcterms_accessRights,"/_map:[./{0,1,2,3,4}=public,5=""data by request"",6=private]/value",Values defined at <http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1581&entity=dba_fielddescription&params=1581>
4
confidentialitystatus,accessRights,"/_map:[./{0,1,2,3,4}=public,5=""data by request"",6=private]/value",Values defined at <http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1581&entity=dba_fielddescription&params=1581>
5 5
confidentialitystatus,coordinateUncertaintyInMeters,"/_alt/1/_km_to_m/value/_map:[1=1,2=10,3=100,./{0,4,5,6}=]/value",Values defined at <http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1581&entity=dba_fielddescription&params=1581>
6 6
shape,footprintWKT,,
7 7
area,plotArea_m2,,"""Total area of the plot in m2"" (area definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename>)"
inputs/TRT/Specimen/VegBIEN.csv
102 102
associatedMedia,,** No join mapping for associatedMedia ** 
103 103
associatedReferences,,** No join mapping for associatedReferences ** 
104 104
basisOfRecord,,** No join mapping for basisOfRecord ** 
105
bibliographicCitation,,** No join mapping for dcterms_bibliographicCitation ** 
105
bibliographicCitation,,** No join mapping for bibliographicCitation ** 
106 106
datasetID,,** No join mapping for datasetID ** 
107 107
datasetName,,** No join mapping for datasetName ** 
108 108
geodeticDatum,,** No join mapping for geodeticDatum ** 
......
114 114
georeferencedDate,,** No join mapping for georeferencedDate ** 
115 115
higherClassification,,** No join mapping for higherClassification ** 
116 116
institutionID,,** No join mapping for institutionID ** 
117
language,,** No join mapping for dcterms_language ** 
117
language,,** No join mapping for language ** 
118 118
locationRemarks,,** No join mapping for locationRemarks ** 
119 119
municipality,,** No join mapping for municipality ** 
120 120
nomenclaturalCode,,** No join mapping for nomenclaturalCode ** 
......
123 123
ownerInstitutionCode,,** No join mapping for ownerInstitutionCode ** 
124 124
previousIdentifications,,** No join mapping for previousIdentifications ** 
125 125
reproductiveCondition,,** No join mapping for reproductiveCondition ** 
126
rightsHolder,,** No join mapping for dcterms_rightsHolder ** 
127
type,,** No join mapping for dcterms_type ** 
126
rightsHolder,,** No join mapping for rightsHolder ** 
127
type,,** No join mapping for type ** 
128 128
typeStatus,,** No join mapping for typeStatus ** 
129 129
verbatimCoordinateSystem,,** No join mapping for verbatimCoordinateSystem ** 
130 130
verbatimEventDate,,** No join mapping for verbatimEventDate ** 
inputs/MO/Specimen/unmapped_terms.csv
1
dcterms_modified
1
modified
2 2
basisOfRecord
3 3
typeStatus
inputs/VegBank/plot_/map.csv
4 4
reference_id,*reference_id,,
5 5
parent_id,parentLocationID,,
6 6
locationaccuracy,coordinateUncertaintyInMeters,/_alt/2,
7
confidentialitystatus,dcterms_accessRights,"/_map:[./{0,1,2,3,4}=public,5=""data by request"",6=private]/value",Values defined at <http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1581&entity=dba_fielddescription&params=1581>
7
confidentialitystatus,accessRights,"/_map:[./{0,1,2,3,4}=public,5=""data by request"",6=private]/value",Values defined at <http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1581&entity=dba_fielddescription&params=1581>
8 8
confidentialitystatus,coordinateUncertaintyInMeters,"/_alt/1/_km_to_m/value/_map:[1=1,2=10,3=100,./{0,4,5,6}=]/value",Values defined at <http://vegbank.org/vegbank/views/dba_fielddescription_detail.jsp?view=detail&wparam=1581&entity=dba_fielddescription&params=1581>
9 9
confidentialityreason,*confidentialityreason,,
10 10
latitude,decimalLatitude,,
inputs/TRT/Specimen/map.csv
15 15
georeferenceProtocol,georeferenceProtocol,,
16 16
verbatimElevation,verbatimElevation,,
17 17
verbatimLongitude,verbatimLongitude,,
18
type,dcterms_type,,
18
type,type,,
19 19
institutionID,institutionID,,
20 20
scientificNameAuthorship,scientificNameAuthorship,,
21
rights,dcterms_rights,,
22
rightsHolder,dcterms_rightsHolder,,
21
rights,rights,,
22
rightsHolder,rightsHolder,,
23 23
georeferencedBy,georeferencedBy,,
24 24
family,family,,
25 25
recordNumber,recordNumber,,
......
42 42
georeferencedDate,georeferencedDate,,
43 43
eventDate,eventDate,,
44 44
kingdom,kingdom,,
45
bibliographicCitation,dcterms_bibliographicCitation,,
45
bibliographicCitation,bibliographicCitation,,
46 46
taxonRank,taxonRank,,
47 47
nomenclaturalCode,nomenclaturalCode,,
48 48
identificationQualifier,identificationQualifier,,
......
62 62
identifiedBy,identifiedBy,,
63 63
otherCatalogNumbers,otherCatalogNumbers,,
64 64
collectionID,collectionID,,
65
language,dcterms_language,,
65
language,language,,
66 66
recordedBy,recordedBy,,
67 67
minimumElevationInMeters,minimumElevationInMeters,,
68 68
collectionCode,collectionCode,,
inputs/MO/Specimen/VegBIEN.csv
67 67
StateProvince,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2,
68 68
StateProvince,/location/locationplace/*_id/place/stateprovince,
69 69
BasisOfRecord,,** No join mapping for basisOfRecord ** 
70
DateLastModified,,** No join mapping for dcterms_modified ** 
70
DateLastModified,,** No join mapping for modified ** 
71 71
TypeStatus,,** No join mapping for typeStatus ** 
inputs/VASCAN/Taxon/unmapped_terms.csv
1 1
nameAccordingTo
2 2
nameAccordingToID
3 3
datasetID
4
dcterms_references
4
references
5 5
higherClassification
6
dcterms_rightsHolder
7
dcterms_bibliographicCitation
8
dcterms_language
6
rightsHolder
7
bibliographicCitation
8
language
9 9
acceptedNameUsageID
10 10
datasetName
11 11
parentNameUsage
12 12
parentNameUsageID
13
dcterms_modified
13
modified
14 14
acceptedNameUsage
15 15
subgenus
16 16
nomenclaturalCode
inputs/NVS/Coordinates/unmapped_terms.csv
1 1
*Plot Obs ID
2 2
*Method
3
*Type
3
type
4 4
*XPrecision
5 5
*Units
6 6
*Map Projection
inputs/MO/Specimen/map.csv
1 1
MO,VegCore,Filter,Comments
2 2
CatalogNumber,catalogNumber,,
3
DateLastModified,dcterms_modified,,
3
DateLastModified,modified,,
4 4
InstitutionCode,institutionCode,,
5 5
CollectionCode,collectionCode,,
6 6
ScientificName,taxonName,,
inputs/VASCAN/Taxon/VegBIEN.csv
42 42
taxonRank,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonverbatim/verbatimrank,
43 43
acceptedNameUsage,,** No join mapping for acceptedNameUsage ** 
44 44
acceptedNameUsageID,,** No join mapping for acceptedNameUsageID ** 
45
bibliographicCitation,,** No join mapping for dcterms_bibliographicCitation ** 
45
bibliographicCitation,,** No join mapping for bibliographicCitation ** 
46 46
datasetID,,** No join mapping for datasetID ** 
47 47
datasetName,,** No join mapping for datasetName ** 
48 48
higherClassification,,** No join mapping for higherClassification ** 
49
language,,** No join mapping for dcterms_language ** 
50
modified,,** No join mapping for dcterms_modified ** 
49
language,,** No join mapping for language ** 
50
modified,,** No join mapping for modified ** 
51 51
nameAccordingTo,,** No join mapping for nameAccordingTo ** 
52 52
nameAccordingToID,,** No join mapping for nameAccordingToID ** 
53 53
nomenclaturalCode,,** No join mapping for nomenclaturalCode ** 
54 54
parentNameUsage,,** No join mapping for parentNameUsage ** 
55 55
parentNameUsageID,,** No join mapping for parentNameUsageID ** 
56
references,,** No join mapping for dcterms_references ** 
57
rightsHolder,,** No join mapping for dcterms_rightsHolder ** 
56
references,,** No join mapping for references ** 
57
rightsHolder,,** No join mapping for rightsHolder ** 
58 58
subgenus,,** No join mapping for subgenus ** 
mappings/VegCore.csv
1 1
VegCore,Definition,Values,Sources,Examples,Comments
2
dcterms_type,,,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(0:Record-level)(00)dcterms:type,,
3
dcterms_modified,"""I think is this merely an internal timestamp indicated when record last modified, not necessarily when determination (taxon name) last modified"" [Brad Boyle]",,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(0:Record-level)(01)dcterms:modified,,
4
dcterms_language,,,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(0:Record-level)(02)dcterms:language,,
5
dcterms_rights,,,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(0:Record-level)(03)dcterms:rights,,
6
dcterms_rightsHolder,,,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(0:Record-level)(04)dcterms:rightsHolder,,
7
dcterms_accessRights,,,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(0:Record-level)(05)dcterms:accessRights,,
8
dcterms_bibliographicCitation,,,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(0:Record-level)(06)dcterms:bibliographicCitation,,
9
dcterms_references,,,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(0:Record-level)(07)dcterms:references,,
2
type,,,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(0:Record-level)(00)dcterms:type,,
3
modified,"""I think is this merely an internal timestamp indicated when record last modified, not necessarily when determination (taxon name) last modified"" [Brad Boyle]",,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(0:Record-level)(01)dcterms:modified,,
4
language,,,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(0:Record-level)(02)dcterms:language,,
5
rights,,,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(0:Record-level)(03)dcterms:rights,,
6
rightsHolder,,,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(0:Record-level)(04)dcterms:rightsHolder,,
7
accessRights,,,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(0:Record-level)(05)dcterms:accessRights,,
8
bibliographicCitation,,,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(0:Record-level)(06)dcterms:bibliographicCitation,,
9
references,,,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(0:Record-level)(07)dcterms:references,,
10 10
institutionID,,,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(0:Record-level)(08)institutionID,,
11 11
collectionID,,,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(0:Record-level)(09)collectionID,,
12 12
datasetID,,,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(0:Record-level)(10)datasetID,,
mappings/Veg+-VegCore.csv
1 1
Veg+,VegCore,Sources,Definition
2
modified,dcterms_modified,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(0:Record-level)(01)dcterms:modified,Versions without namespace
3
language,dcterms_language,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(0:Record-level)(02)dcterms:language,Versions without namespace
4
rights,dcterms_rights,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(0:Record-level)(03)dcterms:rights,Versions without namespace
5
rightsHolder,dcterms_rightsHolder,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(0:Record-level)(04)dcterms:rightsHolder,Versions without namespace
6
accessRights,dcterms_accessRights,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(0:Record-level)(05)dcterms:accessRights,Versions without namespace
7
bibliographicCitation,dcterms_bibliographicCitation,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(0:Record-level)(06)dcterms:bibliographicCitation,Versions without namespace
8
references,dcterms_references,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(0:Record-level)(07)dcterms:references,Versions without namespace
2
dcterms_type,type,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(0:Record-level)(00)dcterms:type,Versions with namespace
3
dcterms_modified,modified,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(0:Record-level)(01)dcterms:modified,Versions with namespace
4
dcterms_language,language,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(0:Record-level)(02)dcterms:language,Versions with namespace
5
dcterms_rights,rights,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(0:Record-level)(03)dcterms:rights,Versions with namespace
6
dcterms_rightsHolder,rightsHolder,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(0:Record-level)(04)dcterms:rightsHolder,Versions with namespace
7
dcterms_accessRights,accessRights,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(0:Record-level)(05)dcterms:accessRights,Versions with namespace
8
dcterms_bibliographicCitation,bibliographicCitation,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(0:Record-level)(06)dcterms:bibliographicCitation,Versions with namespace
9
dcterms_references,references,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(0:Record-level)(07)dcterms:references,Versions with namespace
9 10
plotEventID,eventID,"(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(2:Event)(00)eventID, (3:VegBank)http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename",
10
dateLastModified,dcterms_modified,(0:DwC)(1:MaNIS)http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/(00)DateLastModified,
11
dateLastModified,modified,(0:DwC)(1:MaNIS)http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/(00)DateLastModified,
11 12
collector,recordedBy,(0:DwC)(1:MaNIS)http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/(06)Collector,
12 13
collectorNumber,recordNumber,(0:DwC)(1:MaNIS)http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/(07)CollectorNumber,
13 14
julianDay,day,(0:DwC)(1:MaNIS)http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/(15)JulianDay,
inputs/TRTE/Specimen/map.csv
2 2
id,occurrenceID,,
3 3
collectionCode,collectionCode,,
4 4
genus,genus,,
5
bibliographicCitation,dcterms_bibliographicCitation,,
5
bibliographicCitation,bibliographicCitation,,
6 6
verbatimLongitude,verbatimLongitude,,
7 7
eventDate,eventDate,,
8 8
decimalLongitude,decimalLongitude,,
9 9
catalogNumber,catalogNumber,,
10
language,dcterms_language,,
11
type,dcterms_type,,
10
language,language,,
11
type,type,,
12 12
institutionID,institutionID,,
13 13
kingdom,kingdom,,
14 14
scientificName,scientificName,,
......
28 28
geodeticDatum,geodeticDatum,,
29 29
institutionCode,institutionCode,,
30 30
nomenclaturalCode,nomenclaturalCode,,
31
modified,dcterms_modified,,
31
modified,modified,,
32 32
previousIdentifications,previousIdentifications,,
33 33
datasetName,datasetName,,
34
rights,dcterms_rights,,
34
rights,rights,,
35 35
ownerInstitutionCode,ownerInstitutionCode,,
36 36
county,county,,
37 37
infraspecificEpithet,infraspecificEpithet,,
38
rightsHolder,dcterms_rightsHolder,,
38
rightsHolder,rightsHolder,,
39 39
datasetID,datasetID,,
40 40
stateProvince,stateProvince,,
41 41
collectionID,collectionID,,
mappings/VegCore-VegBIEN.csv
24 24
locationID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode/_if[@name=""if geovalidation""]/else",
25 25
locationName,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
26 26
locationID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
27
dcterms_rights,/location/accessconditions,
28
dcterms_accessRights,/location/accesslevel,
27
rights,/location/accessconditions,
28
accessRights,/location/accesslevel,
29 29
plotArea_m2,/location/area_m2,
30 30
plotArea_ha,/location/area_m2/_ha_to_m2/value,
31 31
subplot,/location/authorlocationcode,
inputs/TRTE/Specimen/VegBIEN.csv
95 95
associatedReferences,,** No join mapping for associatedReferences ** 
96 96
associatedTaxa,,** No join mapping for associatedTaxa ** 
97 97
basisOfRecord,,** No join mapping for basisOfRecord ** 
98
bibliographicCitation,,** No join mapping for dcterms_bibliographicCitation ** 
98
bibliographicCitation,,** No join mapping for bibliographicCitation ** 
99 99
datasetID,,** No join mapping for datasetID ** 
100 100
datasetName,,** No join mapping for datasetName ** 
101 101
geodeticDatum,,** No join mapping for geodeticDatum ** 
102 102
institutionID,,** No join mapping for institutionID ** 
103
language,,** No join mapping for dcterms_language ** 
103
language,,** No join mapping for language ** 
104 104
locationRemarks,,** No join mapping for locationRemarks ** 
105
modified,,** No join mapping for dcterms_modified ** 
105
modified,,** No join mapping for modified ** 
106 106
municipality,,** No join mapping for municipality ** 
107 107
nomenclaturalCode,,** No join mapping for nomenclaturalCode ** 
108 108
occurrenceRemarks,,** No join mapping for occurrenceRemarks ** 
109 109
ownerInstitutionCode,,** No join mapping for ownerInstitutionCode ** 
110 110
previousIdentifications,,** No join mapping for previousIdentifications ** 
111
rightsHolder,,** No join mapping for dcterms_rightsHolder ** 
112
type,,** No join mapping for dcterms_type ** 
111
rightsHolder,,** No join mapping for rightsHolder ** 
112
type,,** No join mapping for type ** 
113 113
verbatimCoordinateSystem,,** No join mapping for verbatimCoordinateSystem ** 
114 114
verbatimEventDate,,** No join mapping for verbatimEventDate ** 
115 115
verbatimSRS,,** No join mapping for verbatimSRS ** 
mappings/for_review/VegCore-VegBIEN.csv
24 24
locationID,"/location/sourceaccessioncode/_if[@name=""if geovalidation""]/else",
25 25
locationName,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode",
26 26
locationID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode",
27
dcterms_rights,//location/accessconditions,
28
dcterms_accessRights,//location/accesslevel,
27
rights,//location/accessconditions,
28
accessRights,//location/accesslevel,
29 29
plotArea_m2,//location/area_m2,
30 30
plotArea_ha,//location/area_m2/_ha_to_m2/value,
31 31
subplot,//location/authorlocationcode,
inputs/TRTE/Specimen/unmapped_terms.csv
1
dcterms_bibliographicCitation
2
dcterms_language
3
dcterms_type
1
bibliographicCitation
2
language
3
type
4 4
institutionID
5 5
basisOfRecord
6 6
associatedTaxa
......
9 9
municipality
10 10
geodeticDatum
11 11
nomenclaturalCode
12
dcterms_modified
12
modified
13 13
previousIdentifications
14 14
datasetName
15 15
ownerInstitutionCode
16
dcterms_rightsHolder
... This diff was truncated because it exceeds the maximum size that can be displayed.

Also available in: Unified diff