Revision 6831
Added by Aaron Marcuse-Kubitza almost 12 years ago
inputs/UBC/Specimen/new_terms.csv | ||
---|---|---|
1 |
type,dcterms:type,, |
|
1 |
type,dcterms_type,, |
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 dcterms_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 dcterms_language **
|
|
109 | 109 |
locationRemarks,,** No join mapping for locationRemarks ** |
110 |
modified,,** No join mapping for dcterms:modified **
|
|
110 |
modified,,** No join mapping for dcterms_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 dcterms_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 dcterms_rightsHolder **
|
|
118 |
type,,** No join mapping for dcterms_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,dcterms_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,dcterms_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,dcterms_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/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 dcterms_modified ** |
inputs/GBIF/Specimen/unmapped_terms.csv | ||
---|---|---|
1 | 1 |
*0 |
2 | 2 |
*1 |
3 | 3 |
*3 |
4 |
dcterms:modified
|
|
4 |
dcterms_modified
|
|
5 | 5 |
*25 |
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 dcterms_language **
|
|
84 |
modified,,** No join mapping for dcterms_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 dcterms_rightsHolder ** |
|
88 |
type,,** No join mapping for dcterms_type ** |
inputs/JBM/Specimen/unmapped_terms.csv | ||
---|---|---|
1 |
dcterms:modified
|
|
1 |
dcterms_modified
|
|
2 | 2 |
ownerInstitutionCode |
3 |
dcterms:language
|
|
3 |
dcterms_language
|
|
4 | 4 |
basisOfRecord |
5 | 5 |
geodeticDatum |
6 |
dcterms:rightsHolder
|
|
6 |
dcterms_rightsHolder
|
|
7 | 7 |
nomenclaturalCode |
8 | 8 |
dynamicProperties |
9 | 9 |
datasetName |
10 |
dcterms:type
|
|
10 |
dcterms_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 dcterms_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 dcterms_language **
|
|
109 |
modified,,** No join mapping for dcterms_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 dcterms_references **
|
|
116 |
rightsHolder,,** No join mapping for dcterms_rightsHolder **
|
|
117 |
type,,** No join mapping for dcterms_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,dcterms_rightsHolder,,
|
|
6 | 6 |
verbatimSRS,verbatimSRS,, |
7 |
references,dcterms:references,,
|
|
7 |
references,dcterms_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,dcterms_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,dcterms_rights,,
|
|
40 | 40 |
stateProvince,stateProvince,, |
41 | 41 |
recordedBy,recordedBy,, |
42 | 42 |
decimalLatitude,decimalLatitude,, |
43 |
modified,dcterms:modified,,
|
|
43 |
modified,dcterms_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,dcterms_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,dcterms_language,,
|
|
59 | 59 |
ownerInstitutionCode,ownerInstitutionCode,, |
60 | 60 |
class,class,, |
inputs/HIBG/Specimen/unmapped_terms.csv | ||
---|---|---|
1 |
dcterms:rightsHolder
|
|
1 |
dcterms_rightsHolder
|
|
2 | 2 |
verbatimSRS |
3 |
dcterms:references
|
|
3 |
dcterms_references
|
|
4 | 4 |
institutionID |
5 | 5 |
verbatimCoordinateSystem |
6 | 6 |
locationRemarks |
... | ... | |
9 | 9 |
basisOfRecord |
10 | 10 |
georeferenceSources |
11 | 11 |
datasetName |
12 |
dcterms:bibliographicCitation
|
|
12 |
dcterms_bibliographicCitation
|
|
13 | 13 |
datasetID |
14 | 14 |
informationWithheld |
15 | 15 |
verbatimDepth |
... | ... | |
17 | 17 |
associatedMedia |
18 | 18 |
nomenclaturalCode |
19 | 19 |
waterBody |
20 |
dcterms:modified
|
|
20 |
dcterms_modified
|
|
21 | 21 |
identificationRemarks |
22 | 22 |
georeferenceVerificationStatus |
23 | 23 |
occurrenceRemarks |
24 | 24 |
municipality |
25 |
dcterms:type
|
|
26 |
dcterms:language
|
|
25 |
dcterms_type
|
|
26 |
dcterms_language
|
|
27 | 27 |
ownerInstitutionCode |
inputs/SpeciesLink/Specimen/new_terms.csv | ||
---|---|---|
1 | 1 |
dwc_dwcore_GlobalUniqueIdentifier,occurrenceID,, |
2 |
dwc_dwcore_DateLastModified,dcterms:modified,,
|
|
2 |
dwc_dwcore_DateLastModified,dcterms_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,dcterms_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,dcterms_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/SpeciesLink/Specimen/unmapped_terms.csv | ||
---|---|---|
1 |
dcterms:modified
|
|
1 |
dcterms_modified
|
|
2 | 2 |
basisOfRecord |
3 | 3 |
day |
4 | 4 |
typeStatus |
5 |
dcterms:modified
|
|
5 |
dcterms_modified
|
|
6 | 6 |
basisOfRecord |
7 | 7 |
typeStatus |
8 | 8 |
occurrenceRemarks |
... | ... | |
14 | 14 |
year |
15 | 15 |
month |
16 | 16 |
day |
17 |
dcterms:modified
|
|
17 |
dcterms_modified
|
|
18 | 18 |
basisOfRecord |
19 | 19 |
typeStatus |
20 | 20 |
day |
inputs/CVS/taxonObservation_/map.csv | ||
---|---|---|
47 | 47 |
taxonInterpretation_accessionCode,*taxonInterpretation_accessionCode,, |
48 | 48 |
PARTY_ID,*PARTY_ID,, |
49 | 49 |
salutation,*salutation,, |
50 |
givenName,recordedBy.givenName,,
|
|
50 |
givenName,recordedBy_givenName,,
|
|
51 | 51 |
middleName,*middleName,, |
52 |
surName,recordedBy.surName,,
|
|
52 |
surName,recordedBy_surName,,
|
|
53 | 53 |
suffix,*suffix,, |
54 | 54 |
entry_userInitials,*entry_userInitials,, |
55 | 55 |
organizationName,*organizationName,, |
inputs/NY/Specimen/unmapped_terms.csv | ||
---|---|---|
1 |
dcterms:modified
|
|
1 |
dcterms_modified
|
|
2 | 2 |
basisOfRecord |
3 | 3 |
typeStatus |
4 | 4 |
day |
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¶ms=1581>
|
|
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¶ms=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¶ms=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/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,dcterms_modified,,
|
|
4 | 4 |
InstitutionCode,institutionCode,, |
5 | 5 |
CollectionCode,collectionCode,, |
6 | 6 |
CatalogNumber,catalogNumber,, |
inputs/CVS/taxonObservation_/new_terms.csv | ||
---|---|---|
5 | 5 |
interpretationDate,dateIdentified,, |
6 | 6 |
collectionDate,dateCollected,, |
7 | 7 |
museumAccessionNumber,catalogNumber,, |
8 |
givenName,recordedBy.givenName,,
|
|
9 |
surName,recordedBy.surName,,
|
|
8 |
givenName,recordedBy_givenName,,
|
|
9 |
surName,recordedBy_surName,,
|
|
10 | 10 |
plantname,taxonName,, |
11 | 11 |
plantNameWithAuthority,scientificName,, |
12 | 12 |
denorm_kingdom,kingdom,/_alt/1, |
inputs/SALVIAS-CSV/Organism/map.csv | ||
---|---|---|
21 | 21 |
voucher_string,catalogNumber,/_alt/2,"Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below." |
22 | 22 |
coll_number,catalogNumber,/_alt/1,Brad: Map instead as for voucher_string |
23 | 23 |
collector_code,*collector_code,,Brad: OMIT |
24 |
coll_lastname,recordedBy.surName,,"Brad: This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick."
|
|
25 |
coll_firstname,recordedBy.givenName,,Brad: See comment above
|
|
24 |
coll_lastname,recordedBy_surName,,"Brad: This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick."
|
|
25 |
coll_firstname,recordedBy_givenName,,Brad: See comment above
|
|
26 | 26 |
det_type,voucherType,,"Brad: A SALVIAS value referring to the relationship between the voucher specimen and the observation. Affect how the identification of the specimen(latin name) is transferred to the observation. 'direct'=voucher specimen was collected from this same tree; they are one and the same individual. 'indirect'=voucher specimen was collected for a different individual, but the original data provider confirmed that this is the same species. 'default'=basically same as 'indirect'. 'uncollected'=no voucher specimen, data provider asserted that this was the name but was unable to collect. The main different is that with 'direct', 'indirect', and 'default', the scientific name can be updated automatically based on the name attached to the specimen voucher (assuming you have a link to that data, presumably from a herbarium database. Whereas, if det_type='uncollected', the name can never change because there is no specimen." |
27 | 27 |
fam_status,*fam_status,,Brad: OMIT. This will be determined later by using TNRS. |
28 | 28 |
gen_status,*gen_status,,Brad: OMIT. This will be determined later by using TNRS. |
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 dcterms_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/MT/Specimen/map.csv | ||
---|---|---|
2 | 2 |
id,occurrenceID,, |
3 | 3 |
establishmentMeans,establishmentMeans,, |
4 | 4 |
locality,locality,, |
5 |
language,dcterms:language,,
|
|
5 |
language,dcterms_language,,
|
|
6 | 6 |
collectionID,collectionID,, |
7 | 7 |
occurrenceRemarks,occurrenceRemarks,, |
8 |
type,dcterms:type,,
|
|
8 |
type,dcterms_type,,
|
|
9 | 9 |
institutionCode,institutionCode,, |
10 |
rights,dcterms:rights,,
|
|
10 |
rights,dcterms_rights,,
|
|
11 | 11 |
family,family,, |
12 | 12 |
continent,continent,, |
13 | 13 |
collectionCode,collectionCode,, |
14 | 14 |
datasetName,datasetName,, |
15 |
rightsHolder,dcterms:rightsHolder,,
|
|
15 |
rightsHolder,dcterms_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 dcterms_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 dcterms_rightsHolder ** |
|
41 |
type,,** No join mapping for dcterms_type ** |
inputs/MT/Specimen/new_terms.csv | ||
---|---|---|
1 |
type,dcterms:type,, |
|
1 |
type,dcterms_type,, |
inputs/MT/Specimen/unmapped_terms.csv | ||
---|---|---|
1 |
dcterms:language
|
|
1 |
dcterms_language
|
|
2 | 2 |
occurrenceRemarks |
3 |
dcterms:type
|
|
3 |
dcterms_type
|
|
4 | 4 |
datasetName |
5 |
dcterms:rightsHolder
|
|
5 |
dcterms_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,dcterms_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 dcterms_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,dcterms_modified,,
|
|
2 | 2 |
darwin:InstitutionCode,institutionCode,, |
3 | 3 |
darwin:CollectionCode,collectionCode,, |
4 | 4 |
darwin:CatalogNumber,catalogNumber,, |
inputs/XAL/Specimen/unmapped_terms.csv | ||
---|---|---|
1 |
dcterms:modified
|
|
1 |
dcterms_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,dcterms_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,dcterms_modified,,
|
|
25 |
type,dcterms_type,,
|
|
26 | 26 |
specificEpithet,specificEpithet,, |
27 | 27 |
identificationRemarks,identificationRemarks,, |
28 |
rightsHolder,dcterms:rightsHolder,,
|
|
28 |
rightsHolder,dcterms_rightsHolder,,
|
|
29 | 29 |
recordNumber,recordNumber,, |
30 | 30 |
eventDate,eventDate,, |
31 |
rights,dcterms:rights,,
|
|
31 |
rights,dcterms_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,dcterms_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 dcterms_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 dcterms_language **
|
|
103 | 103 |
locationRemarks,,** No join mapping for locationRemarks ** |
104 |
modified,,** No join mapping for dcterms:modified **
|
|
104 |
modified,,** No join mapping for dcterms_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 dcterms_rightsHolder **
|
|
110 |
type,,** No join mapping for dcterms_type **
|
|
111 | 111 |
verbatimDepth,,** No join mapping for verbatimDepth ** |
inputs/ACAD/Specimen/new_terms.csv | ||
---|---|---|
1 |
type,dcterms:type,, |
|
1 |
type,dcterms_type,, |
inputs/ACAD/Specimen/unmapped_terms.csv | ||
---|---|---|
2 | 2 |
geodeticDatum |
3 | 3 |
reproductiveCondition |
4 | 4 |
georeferenceSources |
5 |
dcterms:language
|
|
5 |
dcterms_language
|
|
6 | 6 |
georeferenceVerificationStatus |
7 | 7 |
locationRemarks |
8 | 8 |
verbatimDepth |
9 | 9 |
municipality |
10 |
dcterms:modified
|
|
11 |
dcterms:type
|
|
10 |
dcterms_modified
|
|
11 |
dcterms_type
|
|
12 | 12 |
identificationRemarks |
13 |
dcterms:rightsHolder
|
|
13 |
dcterms_rightsHolder
|
|
14 | 14 |
occurrenceRemarks |
15 | 15 |
ownerInstitutionCode |
16 |
dcterms:bibliographicCitation
|
|
16 |
dcterms_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,dcterms_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,dcterms_bibliographicCitation,,
|
|
12 | 12 |
taxonRank,taxonRank,, |
13 |
rights,dcterms:rights,,
|
|
13 |
rights,dcterms_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,dcterms_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,dcterms_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 dcterms_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 dcterms_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 dcterms_rightsHolder **
|
|
104 |
type,,** No join mapping for dcterms_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/new_terms.csv | ||
---|---|---|
1 |
type,dcterms:type,, |
|
1 |
type,dcterms_type,, |
inputs/WIN/Specimen/unmapped_terms.csv | ||
---|---|---|
1 | 1 |
municipality |
2 |
dcterms:rightsHolder
|
|
2 |
dcterms_rightsHolder
|
|
3 | 3 |
associatedMedia |
4 | 4 |
verbatimSRS |
5 | 5 |
datasetID |
6 |
dcterms:bibliographicCitation
|
|
6 |
dcterms_bibliographicCitation
|
|
7 | 7 |
occurrenceRemarks |
8 |
dcterms:type
|
|
8 |
dcterms_type
|
|
9 | 9 |
verbatimEventDate |
10 | 10 |
datasetName |
11 | 11 |
basisOfRecord |
12 | 12 |
identificationRemarks |
13 | 13 |
nomenclaturalCode |
14 | 14 |
verbatimCoordinateSystem |
15 |
dcterms:language
|
|
15 |
dcterms_language
|
|
16 | 16 |
geodeticDatum |
17 | 17 |
ownerInstitutionCode |
inputs/SALVIAS/plotObservations/map.csv | ||
---|---|---|
25 | 25 |
coll_number,catalogNumber,/_alt/1,Brad: Map instead as for voucher_string |
26 | 26 |
collector_code,*collector_code,,Brad: OMIT |
27 | 27 |
coll_inits,*coll_inits,, |
28 |
coll_lastname,recordedBy.surName,,"Brad: This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick."
|
|
29 |
coll_firstname,recordedBy.givenName,,Brad: See comment above
|
|
28 |
coll_lastname,recordedBy_surName,,"Brad: This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick."
|
|
29 |
coll_firstname,recordedBy_givenName,,Brad: See comment above
|
|
30 | 30 |
DetType,voucherType,,"Brad: A SALVIAS value referring to the relationship between the voucher specimen and the observation. Affect how the identification of the specimen(latin name) is transferred to the observation. 'direct'=voucher specimen was collected from this same tree; they are one and the same individual. 'indirect'=voucher specimen was collected for a different individual, but the original data provider confirmed that this is the same species. 'default'=basically same as 'indirect'. 'uncollected'=no voucher specimen, data provider asserted that this was the name but was unable to collect. The main different is that with 'direct', 'indirect', and 'default', the scientific name can be updated automatically based on the name attached to the specimen voucher (assuming you have a link to that data, presumably from a herbarium database. Whereas, if det_type='uncollected', the name can never change because there is no specimen." |
31 | 31 |
det_by,identifiedBy,, |
32 | 32 |
fam_status,OMIT,,Brad: OMIT. This will be determined later by using TNRS. |
inputs/SALVIAS/plotObservations/new_terms.csv | ||
---|---|---|
17 | 17 |
y_position,organismY_m,,"""y coordinate in meters"" (y_position definition at <http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data>). Brad: See comment above for x_position" |
18 | 18 |
SourceVoucher,catalogNumber,/_alt/2,"Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below." |
19 | 19 |
coll_number,catalogNumber,/_alt/1,Brad: Map instead as for voucher_string |
20 |
coll_lastname,recordedBy.surName,,"Brad: This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick."
|
|
21 |
coll_firstname,recordedBy.givenName,,Brad: See comment above
|
|
20 |
coll_lastname,recordedBy_surName,,"Brad: This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick."
|
|
21 |
coll_firstname,recordedBy_givenName,,Brad: See comment above
|
|
22 | 22 |
DetType,voucherType,,"Brad: A SALVIAS value referring to the relationship between the voucher specimen and the observation. Affect how the identification of the specimen(latin name) is transferred to the observation. 'direct'=voucher specimen was collected from this same tree; they are one and the same individual. 'indirect'=voucher specimen was collected for a different individual, but the original data provider confirmed that this is the same species. 'default'=basically same as 'indirect'. 'uncollected'=no voucher specimen, data provider asserted that this was the name but was unable to collect. The main different is that with 'direct', 'indirect', and 'default', the scientific name can be updated automatically based on the name attached to the specimen voucher (assuming you have a link to that data, presumably from a herbarium database. Whereas, if det_type='uncollected', the name can never change because there is no specimen." |
23 | 23 |
det_by,identifiedBy,, |
24 | 24 |
fam_status,OMIT,,Brad: OMIT. This will be determined later by using TNRS. |
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,dcterms_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,dcterms_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,dcterms_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,dcterms_rightsHolder,,
|
|
22 | 22 |
dateIdentified,dateIdentified,, |
23 | 23 |
acceptedNameUsage,acceptedNameUsage,, |
24 | 24 |
nomenclaturalCode,nomenclaturalCode,, |
25 |
bibliographicCitation,dcterms:bibliographicCitation,,
|
|
25 |
bibliographicCitation,dcterms_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,dcterms_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,dcterms_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 dcterms_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 dcterms_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 dcterms_rightsHolder **
|
|
110 |
type,,** No join mapping for dcterms_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/new_terms.csv | ||
---|---|---|
1 |
type,dcterms:type,, |
|
1 |
type,dcterms_type,, |
inputs/QFA/Specimen/unmapped_terms.csv | ||
---|---|---|
5 | 5 |
verbatimEventDate |
6 | 6 |
associatedReferences |
7 | 7 |
verbatimSRS |
8 |
dcterms:rightsHolder
|
|
8 |
dcterms_rightsHolder
|
|
9 | 9 |
acceptedNameUsage |
10 | 10 |
nomenclaturalCode |
11 |
dcterms:bibliographicCitation
|
|
11 |
dcterms_bibliographicCitation
|
|
12 | 12 |
basisOfRecord |
13 | 13 |
occurrenceRemarks |
14 |
dcterms:type
|
|
14 |
dcterms_type
|
|
15 | 15 |
geodeticDatum |
16 | 16 |
verbatimCoordinateSystem |
17 |
dcterms:language
|
|
17 |
dcterms_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,dcterms_modified,,
|
|
11 | 11 |
IdentifiedBy,identifiedBy,, |
12 | 12 |
ScientificNameOriginal,originalTaxonName,, |
13 | 13 |
AuthorOfScientificName,scientificNameAuthorship,, |
inputs/GBIF/Specimen/new_terms.csv | ||
---|---|---|
2 | 2 |
InstitutionCD,institutionCode,, |
3 | 3 |
CollectionCD,collectionCode,, |
4 | 4 |
CatalogNO,catalogNumber,, |
5 |
LastDateModified,dcterms:modified,,
|
|
5 |
LastDateModified,dcterms_modified,,
|
|
6 | 6 |
ScientificNameOriginal,originalTaxonName,, |
7 | 7 |
AuthorOfScientificName,scientificNameAuthorship,, |
8 | 8 |
GBIFFamilyOriginal,originalFamily,, |
inputs/JBM/Specimen/map.csv | ||
---|---|---|
2 | 2 |
id,occurrenceID,, |
3 | 3 |
minimumElevationInMeters,minimumElevationInMeters,, |
4 | 4 |
verbatimLatitude,verbatimLatitude,, |
5 |
modified,dcterms:modified,,
|
|
5 |
modified,dcterms_modified,,
|
|
6 | 6 |
recordNumber,recordNumber,, |
7 | 7 |
recordedBy,recordedBy,, |
8 | 8 |
ownerInstitutionCode,ownerInstitutionCode,, |
9 |
language,dcterms:language,,
|
|
9 |
language,dcterms_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,dcterms_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,dcterms_rights,,
|
|
32 | 32 |
decimalLongitude,decimalLongitude,, |
33 | 33 |
collectionCode,collectionCode,, |
34 |
type,dcterms:type,,
|
|
34 |
type,dcterms_type,,
|
|
35 | 35 |
order,order,, |
36 | 36 |
kingdom,kingdom,, |
37 | 37 |
institutionCode,institutionCode,, |
inputs/JBM/Specimen/new_terms.csv | ||
---|---|---|
1 |
type,dcterms:type,, |
|
1 |
type,dcterms_type,, |
inputs/UBC/Specimen/map.csv | ||
---|---|---|
7 | 7 |
nomenclaturalCode,nomenclaturalCode,, |
8 | 8 |
verbatimElevation,verbatimElevation,, |
9 | 9 |
occurrenceRemarks,occurrenceRemarks,, |
10 |
rightsHolder,dcterms:rightsHolder,,
|
|
10 |
rightsHolder,dcterms_rightsHolder,,
|
|
11 | 11 |
verbatimLongitude,verbatimLongitude,, |
12 |
rights,dcterms:rights,,
|
|
12 |
rights,dcterms_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,dcterms_language,,
|
|
24 | 24 |
ownerInstitutionCode,ownerInstitutionCode,, |
25 | 25 |
family,family,, |
26 | 26 |
datasetName,datasetName,, |
27 |
modified,dcterms:modified,,
|
|
27 |
modified,dcterms_modified,,
|
|
28 | 28 |
eventDate,eventDate,, |
29 | 29 |
georeferencedDate,georeferencedDate,, |
30 | 30 |
georeferenceSources,georeferenceSources,, |
31 |
bibliographicCitation,dcterms:bibliographicCitation,,
|
|
31 |
bibliographicCitation,dcterms_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,dcterms_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,dcterms_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 |
dcterms_rightsHolder
|
|
5 | 5 |
preparations |
6 | 6 |
geodeticDatum |
7 | 7 |
associatedReferences |
8 | 8 |
basisOfRecord |
9 | 9 |
disposition |
10 |
dcterms:language
|
|
10 |
dcterms_language
|
|
11 | 11 |
ownerInstitutionCode |
12 | 12 |
datasetName |
13 |
dcterms:modified
|
|
13 |
dcterms_modified
|
|
14 | 14 |
georeferencedDate |
15 | 15 |
georeferenceSources |
16 |
dcterms:bibliographicCitation
|
|
16 |
dcterms_bibliographicCitation
|
|
17 | 17 |
georeferencedBy |
18 |
dcterms:references
|
|
18 |
dcterms_references
|
|
19 | 19 |
datasetID |
20 | 20 |
associatedMedia |
21 |
dcterms:type
|
|
21 |
dcterms_type
|
|
22 | 22 |
verbatimSRS |
23 | 23 |
typeStatus |
24 | 24 |
previousIdentifications |
inputs/HIBG/Specimen/new_terms.csv | ||
---|---|---|
1 |
type,dcterms:type,, |
|
1 |
type,dcterms_type,, |
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 dcterms_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 dcterms_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 dcterms_modified ** |
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 dcterms_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_/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¶ms=1581>
|
|
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¶ms=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¶ms=1581> |
13 | 13 |
confidentialityFieldsBlocked,*confidentialityFieldsBlocked,, |
14 | 14 |
confidentialityReason,*confidentialityReason,, |
inputs/ARIZ/Specimen/map.csv | ||
---|---|---|
1 | 1 |
ARIZ,VegCore,Filter,Comments |
2 | 2 |
GlobalUniqueIdentifier,occurrenceID,, |
3 |
DateLastModified,dcterms:modified,,
|
|
3 |
DateLastModified,dcterms_modified,,
|
|
4 | 4 |
BasisOfRecord,basisOfRecord,, |
5 | 5 |
InstitutionCode,institutionCode,, |
6 | 6 |
CollectionCode,collectionCode,, |
inputs/SALVIAS-CSV/Organism/new_terms.csv | ||
---|---|---|
16 | 16 |
y_position,organismY_m,,"""y coordinate in meters"" (y_position definition at <http://salvias.net/Documents/salvias_data_dictionary.html#Plot+data>). Brad: See comment above for x_position" |
17 | 17 |
voucher_string,catalogNumber,/_alt/2,"Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below." |
18 | 18 |
coll_number,catalogNumber,/_alt/1,Brad: Map instead as for voucher_string |
19 |
coll_lastname,recordedBy.surName,,"Brad: This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick."
|
|
20 |
coll_firstname,recordedBy.givenName,,Brad: See comment above
|
|
19 |
coll_lastname,recordedBy_surName,,"Brad: This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick."
|
|
20 |
coll_firstname,recordedBy_givenName,,Brad: See comment above
|
|
21 | 21 |
det_type,voucherType,,"Brad: A SALVIAS value referring to the relationship between the voucher specimen and the observation. Affect how the identification of the specimen(latin name) is transferred to the observation. 'direct'=voucher specimen was collected from this same tree; they are one and the same individual. 'indirect'=voucher specimen was collected for a different individual, but the original data provider confirmed that this is the same species. 'default'=basically same as 'indirect'. 'uncollected'=no voucher specimen, data provider asserted that this was the name but was unable to collect. The main different is that with 'direct', 'indirect', and 'default', the scientific name can be updated automatically based on the name attached to the specimen voucher (assuming you have a link to that data, presumably from a herbarium database. Whereas, if det_type='uncollected', the name can never change because there is no specimen." |
22 | 22 |
specific_authority,scientificNameAuthorship,,Brad: This is the author of the scientificName. |
23 | 23 |
infra_rank_1,taxonRank,, |
inputs/ARIZ/Specimen/unmapped_terms.csv | ||
---|---|---|
1 |
dcterms:modified
|
|
1 |
dcterms_modified
|
|
2 | 2 |
basisOfRecord |
3 | 3 |
eventTime |
4 | 4 |
day |
inputs/TRT/Specimen/unmapped_terms.csv | ||
---|---|---|
3 | 3 |
occurrenceRemarks |
4 | 4 |
associatedReferences |
5 | 5 |
georeferenceProtocol |
6 |
dcterms:type
|
|
6 |
dcterms_type
|
|
7 | 7 |
institutionID |
8 |
dcterms:rightsHolder
|
|
8 |
dcterms_rightsHolder
|
|
9 | 9 |
georeferencedBy |
10 | 10 |
georeferenceRemarks |
11 | 11 |
geodeticDatum |
... | ... | |
14 | 14 |
associatedMedia |
15 | 15 |
datasetID |
16 | 16 |
georeferencedDate |
17 |
dcterms:bibliographicCitation
|
|
17 |
dcterms_bibliographicCitation
|
|
18 | 18 |
nomenclaturalCode |
19 | 19 |
datasetName |
20 | 20 |
ownerInstitutionCode |
... | ... | |
27 | 27 |
verbatimSRS |
28 | 28 |
municipality |
29 | 29 |
otherCatalogNumbers |
30 |
dcterms:language |
|
30 |
dcterms_language |
inputs/TRT/Specimen/new_terms.csv | ||
---|---|---|
1 |
type,dcterms:type,, |
|
1 |
type,dcterms_type,, |
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 dcterms_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 dcterms_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 dcterms_rightsHolder **
|
|
127 |
type,,** No join mapping for dcterms_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/TRT/Specimen/map.csv | ||
---|---|---|
15 | 15 |
georeferenceProtocol,georeferenceProtocol,, |
16 | 16 |
verbatimElevation,verbatimElevation,, |
17 | 17 |
verbatimLongitude,verbatimLongitude,, |
18 |
type,dcterms:type,,
|
|
18 |
type,dcterms_type,,
|
|
19 | 19 |
institutionID,institutionID,, |
20 | 20 |
scientificNameAuthorship,scientificNameAuthorship,, |
21 |
rights,dcterms:rights,,
|
|
22 |
rightsHolder,dcterms:rightsHolder,,
|
|
21 |
rights,dcterms_rights,,
|
|
22 |
rightsHolder,dcterms_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,dcterms_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,dcterms_language,,
|
|
66 | 66 |
recordedBy,recordedBy,, |
67 | 67 |
minimumElevationInMeters,minimumElevationInMeters,, |
68 | 68 |
collectionCode,collectionCode,, |
inputs/VASCAN/Taxon/map.csv | ||
---|---|---|
3 | 3 |
nameAccordingTo,nameAccordingTo,, |
4 | 4 |
nameAccordingToID,nameAccordingToID,, |
5 | 5 |
datasetID,datasetID,, |
6 |
references,dcterms:references,,
|
|
6 |
references,dcterms_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,dcterms_rightsHolder,,
|
|
12 |
bibliographicCitation,dcterms_bibliographicCitation,,
|
|
13 |
language,dcterms_language,,
|
|
14 | 14 |
family,family,, |
15 | 15 |
acceptedNameUsageID,acceptedNameUsageID,, |
16 |
rights,dcterms:rights,,
|
|
16 |
rights,dcterms_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,dcterms_modified,,
|
|
25 | 25 |
acceptedNameUsage,acceptedNameUsage,, |
26 | 26 |
scientificNameAuthorship,scientificNameAuthorship,, |
27 | 27 |
subgenus,subgenus,, |
inputs/VegBank/taxonobservation_/new_terms.csv | ||
---|---|---|
4 | 4 |
museumaccessionnumber,catalogNumber,, |
5 | 5 |
interpretationdate,dateIdentified,, |
6 | 6 |
collectiondate,dateCollected,, |
7 |
givenname,recordedBy.givenName,, |
|
8 |
surname,recordedBy.surName,, |
|
7 |
givenname,recordedBy_givenName,, |
|
8 |
surname,recordedBy_surName,, |
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 dcterms_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 dcterms_language **
|
|
104 | 104 |
locationRemarks,,** No join mapping for locationRemarks ** |
105 |
modified,,** No join mapping for dcterms:modified **
|
|
105 |
modified,,** No join mapping for dcterms_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 dcterms_rightsHolder **
|
|
112 |
type,,** No join mapping for dcterms_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/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 |
dcterms_rights,/location/accessconditions,
|
|
28 |
dcterms_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, |
... | ... | |
149 | 149 |
scientificName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/2", |
150 | 150 |
taxonName,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/3", |
151 | 151 |
recordedBy,/location/locationevent/taxonoccurrence/collector_id/party/fullname, |
152 |
recordedBy.givenName,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_join_words/1,
|
|
153 |
recordedBy.surName,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_join_words/2,
|
|
152 |
recordedBy_givenName,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_join_words/1,
|
|
153 |
recordedBy_surName,/location/locationevent/taxonoccurrence/collector_id/party/fullname/_join_words/2,
|
|
154 | 154 |
growthForm,/location/locationevent/taxonoccurrence/growthform, |
155 | 155 |
individualID,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
156 | 156 |
occurrenceID,"/location/locationevent/taxonoccurrence/iscultivated/_alt/1/_if[@name=""if TaxonOccurrence""]/cond/_exists", |
inputs/MO/Specimen/unmapped_terms.csv | ||
---|---|---|
1 |
dcterms:modified
|
|
1 |
dcterms_modified
|
|
2 | 2 |
basisOfRecord |
3 | 3 |
typeStatus |
inputs/VegBank/taxonobservation_/map.csv | ||
---|---|---|
43 | 43 |
taxoninterpretation_accessioncode,*taxoninterpretation_accessioncode,, |
44 | 44 |
party_id,*party_id,, |
45 | 45 |
salutation,*salutation,, |
46 |
givenname,recordedBy.givenName,,
|
|
46 |
givenname,recordedBy_givenName,,
|
|
47 | 47 |
middlename,*middlename,, |
48 |
surname,recordedBy.surName,,
|
|
48 |
surname,recordedBy_surName,,
|
|
49 | 49 |
organizationname,*organizationname,, |
50 | 50 |
currentname_id,*currentname_id,, |
51 | 51 |
contactinstructions,*contactinstructions,, |
inputs/TRTE/Specimen/map.csv | ||
---|---|---|
2 | 2 |
id,occurrenceID,, |
3 | 3 |
collectionCode,collectionCode,, |
4 | 4 |
genus,genus,, |
5 |
bibliographicCitation,dcterms:bibliographicCitation,,
|
|
5 |
bibliographicCitation,dcterms_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,dcterms_language,,
|
|
11 |
type,dcterms_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,dcterms_modified,,
|
|
32 | 32 |
previousIdentifications,previousIdentifications,, |
33 | 33 |
datasetName,datasetName,, |
34 |
rights,dcterms:rights,,
|
|
34 |
rights,dcterms_rights,,
|
|
35 | 35 |
ownerInstitutionCode,ownerInstitutionCode,, |
36 | 36 |
county,county,, |
37 | 37 |
infraspecificEpithet,infraspecificEpithet,, |
38 |
rightsHolder,dcterms:rightsHolder,,
|
|
38 |
rightsHolder,dcterms_rightsHolder,,
|
|
39 | 39 |
datasetID,datasetID,, |
40 | 40 |
stateProvince,stateProvince,, |
41 | 41 |
collectionID,collectionID,, |
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 |
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,,
|
|
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,, |
... | ... | |
23 | 23 |
occurrenceRemarks,,,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(1:Occurrence)(02)occurrenceRemarks,, |
24 | 24 |
recordNumber,,,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(1:Occurrence)(03)recordNumber,, |
25 | 25 |
recordedBy,"""A list (concatenated and separated) of names of people, groups, or organizations responsible for recording the original Occurrence. The primary collector or observer, especially one who applies a personal identifier (recordNumber), should be listed first."" [DwC]",,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(1:Occurrence)(04)recordedBy,, |
26 |
recordedBy.givenName,"""The given name"" [VegX] of ""The primary collector or observer, especially one who applies a personal identifier (recordNumber)"" [DwC]",,"(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(1:Occurrence)(04)recordedBy, (2:VegX)http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/parties/party/individualName/(01)givenName",,
|
|
27 |
recordedBy.surName,"""The last name"" [VegX] of ""The primary collector or observer, especially one who applies a personal identifier (recordNumber)"" [DwC]",,"(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(1:Occurrence)(04)recordedBy, (2:VegX)http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/parties/party/individualName/(02)surName",,
|
|
28 |
recordedBy.middleName,"The ""middle name or initial"" [VegBank] of ""The primary collector or observer, especially one who applies a personal identifier (recordNumber)"" [DwC]",,"(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(1:Occurrence)(04)recordedBy, (3:VegBank)http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=party&entity=dba_tabledescription&where=where_tablename#(03)middleName",,
|
|
26 |
recordedBy_givenName,"""The given name"" [VegX] of ""The primary collector or observer, especially one who applies a personal identifier (recordNumber)"" [DwC]",,"(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(1:Occurrence)(04)recordedBy, (2:VegX)http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/parties/party/individualName/(01)givenName",,
|
|
27 |
recordedBy_surName,"""The last name"" [VegX] of ""The primary collector or observer, especially one who applies a personal identifier (recordNumber)"" [DwC]",,"(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(1:Occurrence)(04)recordedBy, (2:VegX)http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/parties/party/individualName/(02)surName",,
|
|
28 |
recordedBy_middleName,"The ""middle name or initial"" [VegBank] of ""The primary collector or observer, especially one who applies a personal identifier (recordNumber)"" [DwC]",,"(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(1:Occurrence)(04)recordedBy, (3:VegBank)http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=party&entity=dba_tabledescription&where=where_tablename#(03)middleName",,
|
|
29 | 29 |
individualID,,,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(1:Occurrence)(05)individualID,, |
30 | 30 |
individualCount,,,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(1:Occurrence)(06)individualCount,, |
31 | 31 |
sex,,,(0:DwC)(0)http://rs.tdwg.org/dwc/terms/#(1:Occurrence)(07)sex,, |
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 |
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
|
|
9 | 9 |
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,
|
|
10 |
dateLastModified,dcterms_modified,(0:DwC)(1:MaNIS)http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/(00)DateLastModified,
|
|
11 | 11 |
collector,recordedBy,(0:DwC)(1:MaNIS)http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/(06)Collector, |
12 | 12 |
collectorNumber,recordNumber,(0:DwC)(1:MaNIS)http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/(07)CollectorNumber, |
13 | 13 |
julianDay,day,(0:DwC)(1:MaNIS)http://digir.net/schema/conceptual/darwin/manis/1.21/darwin2.xsd#/(15)JulianDay, |
... | ... | |
52 | 52 |
cationExchangeCapacity,cationExchangeCapacity_cmol_kg,"(3:VegBank)http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#(13)exchangeCapacity, (4:SALVIAS)(1:DB)http://nimoy.nceas.ucsb.edu/phpmyadmin/index.php?db=salvias_plots&table=plotMetadata&target=tbl_structure.php#(44)soil_cation_cap",Expanded for clarity |
53 | 53 |
baseSaturation,"?baseSaturation_percent, baseSaturation_fraction",(3:VegBank)http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilObs&entity=dba_tabledescription&where=where_tablename#(14)baseSaturation, |
54 | 54 |
taxonFit,identificationQualifier,(3:VegBank)http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=taxoninterpretation&entity=dba_tabledescription&where=where_tablename#(12)taxonFit, |
55 |
collector.givenName,recordedBy.givenName,(3:VegBank)http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=taxoninterpretation&entity=dba_tabledescription&where=where_tablename#(14)collector_ID,
|
|
56 |
collector.surName,recordedBy.surName,(3:VegBank)http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=taxoninterpretation&entity=dba_tabledescription&where=where_tablename#(14)collector_ID,
|
|
55 |
collector_givenName,recordedBy_givenName,(3:VegBank)http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=taxoninterpretation&entity=dba_tabledescription&where=where_tablename#(14)collector_ID,
|
|
56 |
collector_surName,recordedBy_surName,(3:VegBank)http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=taxoninterpretation&entity=dba_tabledescription&where=where_tablename#(14)collector_ID,
|
|
57 | 57 |
habit,verbatimGrowthForm,(4:SALVIAS)(0)http://salvias.net/Documents/salvias_data_dictionary.html#(1)Plot_data/(28)habit, |
58 | 58 |
stemTag,tag,(4:SALVIAS)(0)http://salvias.net/Documents/salvias_data_dictionary.html#(1)Plot_data/(35)stem_tag2,Number removed for clarity |
59 | 59 |
DBH,"?diameterBreastHeight_cm, diameterBreastHeight_in",(4:SALVIAS)(0)http://salvias.net/Documents/salvias_data_dictionary.html#(1)Plot_data/(36)stem_dbh,Table removed because term is unique |
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 dcterms_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 |
dcterms_references
|
|
5 | 5 |
higherClassification |
6 |
dcterms:rightsHolder |
Also available in: Unified diff
mappings/VegCore.csv: Term names: Changed special characters to _ because Redmine doesn't support special characters in HTML anchors (it removes everything except letters, numbers, _, and -)