Project

General

Profile

« Previous | Next » 

Revision 10257

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/*/*/map.csv: added distinguishing #... suffix (e.g. UNUSED#institutionID) to the special terms OMIT, PRIVATE, UNUSED (VegCore.vegpath.org#Special-terms) to avoid creating a collision in the staging table renaming

View differences:

inputs/HIBG/Specimen/VegBIEN.csv
95 95 
georeferenceVerificationStatus,,** No join mapping for georeferenceVerificationStatus **
96 96 
identificationRemarks,,** No join mapping for identificationRemarks **
97 97 
informationWithheld,,** No join mapping for informationWithheld **
98 
institutionID,,** No non-empty join mapping for UNUSED **
98 
institutionID,,** No non-empty join mapping for UNUSED#institutionID **
99 99 
language,,** No join mapping for language **
100 100 
modified,,** No join mapping for modified **
101 101 
municipality,,** No join mapping for municipality **
inputs/bien_web/observation/new_terms.csv
9 9 
isCultivated,cultivated,,
10 10 
isCultivatedReason,cultivatedBasis,,
11 11 
pctCover,coverPercent,,
12 
observationID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
13 
dataSourceID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
14 
dataSourceName_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
15 
dataSourceNamePrimary_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
16 
plotID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
17 
observationType_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
18 
bien2_taxonomyID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
19 
bien2_DBPlotID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
20 
bien2_ObservationID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
21 
bien2_OccurID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
22 
taxonAuthorityVerbatim_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
23 
higherPlantGroup_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
24 
family_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
25 
genus_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
26 
species_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
27 
taxon_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
28 
taxonAuthor_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
29 
taxonMorphospecies_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
30 
rank_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
31 
acceptance_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
32 
country_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
33 
stateProvince_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
34 
collector_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
35 
identifiedBy_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
36 
plotCode_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
37 
plotAreaHa_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
38 
plotMinDbh_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
39 
plotMethod_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
40 
isValidLatLong_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
41 
isGeovalid_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
42 
isNewWorld_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
43 
isCultivated_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
44 
isCultivatedReason_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
45 
bien2_TraitObservationID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
46 
traitName_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
47 
traitMethod_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
48 
traitUnit_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
12 
observationID_index,OMIT#observationID_index,,Placeholder column created by MySQL to PostgreSQL translation
13 
dataSourceID_index,OMIT#dataSourceID_index,,Placeholder column created by MySQL to PostgreSQL translation
14 
dataSourceName_index,OMIT#dataSourceName_index,,Placeholder column created by MySQL to PostgreSQL translation
15 
dataSourceNamePrimary_index,OMIT#dataSourceNamePrimary_index,,Placeholder column created by MySQL to PostgreSQL translation
16 
plotID_index,OMIT#plotID_index,,Placeholder column created by MySQL to PostgreSQL translation
17 
observationType_index,OMIT#observationType_index,,Placeholder column created by MySQL to PostgreSQL translation
18 
bien2_taxonomyID_index,OMIT#bien2_taxonomyID_index,,Placeholder column created by MySQL to PostgreSQL translation
19 
bien2_DBPlotID_index,OMIT#bien2_DBPlotID_index,,Placeholder column created by MySQL to PostgreSQL translation
20 
bien2_ObservationID_index,OMIT#bien2_ObservationID_index,,Placeholder column created by MySQL to PostgreSQL translation
21 
bien2_OccurID_index,OMIT#bien2_OccurID_index,,Placeholder column created by MySQL to PostgreSQL translation
22 
taxonAuthorityVerbatim_index,OMIT#taxonAuthorityVerbatim_index,,Placeholder column created by MySQL to PostgreSQL translation
23 
higherPlantGroup_index,OMIT#higherPlantGroup_index,,Placeholder column created by MySQL to PostgreSQL translation
24 
family_index,OMIT#family_index,,Placeholder column created by MySQL to PostgreSQL translation
25 
genus_index,OMIT#genus_index,,Placeholder column created by MySQL to PostgreSQL translation
26 
species_index,OMIT#species_index,,Placeholder column created by MySQL to PostgreSQL translation
27 
taxon_index,OMIT#taxon_index,,Placeholder column created by MySQL to PostgreSQL translation
28 
taxonAuthor_index,OMIT#taxonAuthor_index,,Placeholder column created by MySQL to PostgreSQL translation
29 
taxonMorphospecies_index,OMIT#taxonMorphospecies_index,,Placeholder column created by MySQL to PostgreSQL translation
30 
rank_index,OMIT#rank_index,,Placeholder column created by MySQL to PostgreSQL translation
31 
acceptance_index,OMIT#acceptance_index,,Placeholder column created by MySQL to PostgreSQL translation
32 
country_index,OMIT#country_index,,Placeholder column created by MySQL to PostgreSQL translation
33 
stateProvince_index,OMIT#stateProvince_index,,Placeholder column created by MySQL to PostgreSQL translation
34 
collector_index,OMIT#collector_index,,Placeholder column created by MySQL to PostgreSQL translation
35 
identifiedBy_index,OMIT#identifiedBy_index,,Placeholder column created by MySQL to PostgreSQL translation
36 
plotCode_index,OMIT#plotCode_index,,Placeholder column created by MySQL to PostgreSQL translation
37 
plotAreaHa_index,OMIT#plotAreaHa_index,,Placeholder column created by MySQL to PostgreSQL translation
38 
plotMinDbh_index,OMIT#plotMinDbh_index,,Placeholder column created by MySQL to PostgreSQL translation
39 
plotMethod_index,OMIT#plotMethod_index,,Placeholder column created by MySQL to PostgreSQL translation
40 
isValidLatLong_index,OMIT#isValidLatLong_index,,Placeholder column created by MySQL to PostgreSQL translation
41 
isGeovalid_index,OMIT#isGeovalid_index,,Placeholder column created by MySQL to PostgreSQL translation
42 
isNewWorld_index,OMIT#isNewWorld_index,,Placeholder column created by MySQL to PostgreSQL translation
43 
isCultivated_index,OMIT#isCultivated_index,,Placeholder column created by MySQL to PostgreSQL translation
44 
isCultivatedReason_index,OMIT#isCultivatedReason_index,,Placeholder column created by MySQL to PostgreSQL translation
45 
bien2_TraitObservationID_index,OMIT#bien2_TraitObservationID_index,,Placeholder column created by MySQL to PostgreSQL translation
46 
traitName_index,OMIT#traitName_index,,Placeholder column created by MySQL to PostgreSQL translation
47 
traitMethod_index,OMIT#traitMethod_index,,Placeholder column created by MySQL to PostgreSQL translation
48 
traitUnit_index,OMIT#traitUnit_index,,Placeholder column created by MySQL to PostgreSQL translation
inputs/NY/Ecatalog_all/new_terms.csv
1 
pkey,OMIT,,"CatalogNumber, etc. is a better pkey"
2 
key,OMIT,,"CatalogNumber, etc. is a better pkey"
1 
pkey,OMIT#pkey,,"CatalogNumber, etc. is a better pkey"
2 
key,OMIT#key,,"CatalogNumber, etc. is a better pkey"
3 3 
PlantFungDescription,occurrenceRemarks,/_join/2,Contains the specimenDescription
4 4 
Substrate,locality,"/_join/2/_label[label=""substrate""]/value",
5 5 
Vegetation,locality,"/_join/3/_label[label=""vegetation""]/value",
6 
UniqueNYInternalRecordNumber,OMIT,,Sometimes duplicated. Omitted to avoid confusion since this is an internal-only ID.
6 
UniqueNYInternalRecordNumber,OMIT#UniqueNYInternalRecordNumber,,Sometimes duplicated. Omitted to avoid confusion since this is an internal-only ID.
inputs/Madidi/IndividualObservation/new_terms.csv
10 10 
CollectorAbbrev,recordedBy,/_first/3,
11 11 
CurrentDet,scientificName,,
12 12 
CurrentDetRank,taxonRank,,
13 
CurrentDetFamily,OMIT,,"Omitted because includes *family* author, which TNRS can’t handle"
13 
CurrentDetFamily,OMIT#CurrentDetFamily,,"Omitted because includes *family* author, which TNRS can’t handle"
14 14 
CurrentDetQualifier,identificationQualifier,,
15 15 
FieldFamilyFullName,originalFamily,,
16 16 
FieldFamilyFullName,family,,
17 
FieldFamilyHTML,OMIT,,"Omitted because includes *family* author, which TNRS can’t handle"
17 
FieldFamilyHTML,OMIT#FieldFamilyHTML,,"Omitted because includes *family* author, which TNRS can’t handle"
18 18 
FieldNameFullName,originalTaxonName,,
19 19 
FieldNameAuthors,originalScientificNameAuthorship,,
20 
FieldNameHTML,OMIT,,Adds HTML formatting to FieldNameFullName+FieldNameAuthors
20 
FieldNameHTML,OMIT#FieldNameHTML,,Adds HTML formatting to FieldNameFullName+FieldNameAuthors
21 21 
MorphoSpeciesName,morphoname,,
22 22 
Diameter,diameterBreastHeight_cm,,
23 23 
TotalHeight,height_m,,
inputs/HVAA/Specimen/map.csv
30 30 
endDayOfYear,endDayOfYear,,
31 31 
verbatimEventDate,verbatimEventDate,,
32 32 
habitat,habitat,,
33 
fieldNotes,UNUSED,,
33 
fieldNotes,UNUSED#fieldNotes,,
34 34 
fieldNumber,collectorNumber,,
35 35 
occurrenceRemarks,occurrenceRemarks,/_merge/1,
36 36 
dynamicProperties,occurrenceRemarks,/_merge/2,Contains occurrenceRemarks data
......
52 52 
geodeticDatum,geodeticDatum,,
53 53 
coordinateUncertaintyInMeters,coordinateUncertaintyInMeters,,
54 54 
footprintWKT,footprintWKT,,
55 
coordinatePrecision,UNUSED,,
55 
coordinatePrecision,UNUSED#coordinatePrecision,,
56 56 
locationRemarks,locationRemarks,,
57 57 
verbatimCoordinates,verbatimCoordinates,,
58 58 
verbatimCoordinateSystem,coordinateUnits,,
inputs/HVAA/Specimen/VegBIEN.csv
101 101 
verbatimElevation,/location/verbatimelevation,
102 102 
associatedTaxa,,** No join mapping for associatedTaxa **
103 103 
basisOfRecord,,** No join mapping for basisOfRecord **
104 
coordinatePrecision,,** No non-empty join mapping for UNUSED **
104 
coordinatePrecision,,** No non-empty join mapping for UNUSED#coordinatePrecision **
105 105 
day,,** No join mapping for day **
106 106 
disposition,,** No join mapping for disposition **
107 107 
endDayOfYear,,** No join mapping for endDayOfYear **
108 
fieldNotes,,** No non-empty join mapping for UNUSED **
108 
fieldNotes,,** No non-empty join mapping for UNUSED#fieldNotes **
109 109 
geodeticDatum,,** No join mapping for geodeticDatum **
110 110 
georeferenceProtocol,,** No join mapping for georeferenceProtocol **
111 111 
georeferenceRemarks,,** No join mapping for georeferenceRemarks **
inputs/XAL/Specimen/map.csv
21 21 
darwin:DayIdentified,dayIdentified,,
22 22 
darwin:TypeStatus,typeStatus,,
23 23 
darwin:CollectorNumber,collectorNumber,,
24 
darwin:FieldNumber,UNUSED,,This historical DwC term (http://rs.tdwg.org/dwc/terms/history/index.htm#fieldNumber-2009-04-24) has close to the same meaning as recordNumber (http://rs.tdwg.org/dwc/terms/#recordNumber).
24 
darwin:FieldNumber,UNUSED#darwin:FieldNumber,,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).
25 25 
darwin:Collector,recordedBy,,
26 26 
darwin:YearCollected,yearCollected,,
27 27 
darwin:MonthCollected,monthCollected,,
......
35 35 
darwin:Locality,locality,,
36 36 
darwin:Longitude,decimalLongitude,,
37 37 
darwin:Latitude,decimalLatitude,,
38 
darwin:CoordinatePrecision,UNUSED,,
38 
darwin:CoordinatePrecision,UNUSED#darwin:CoordinatePrecision,,
39 39 
darwin:MinimumElevation,minimumElevationInMeters,,
40 40 
darwin:MaximumElevation,maximumElevationInMeters,,
41 41 
darwin:MinimumDepth,minimumDepthInMeters,,
inputs/XAL/Specimen/VegBIEN.csv
70 70 
darwin:StateProvince,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2,
71 71 
darwin:StateProvince,/location/locationplace/*_id/place/stateprovince,
72 72 
darwin:BasisOfRecord,,** No join mapping for basisOfRecord **
73 
darwin:CoordinatePrecision,,** No non-empty join mapping for UNUSED **
73 
darwin:CoordinatePrecision,,** No non-empty join mapping for UNUSED#darwin:CoordinatePrecision **
74 74 
darwin:DateLastModified,,** No join mapping for modified **
75 
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).
75 
darwin:FieldNumber,,** No non-empty join mapping for UNUSED#darwin:FieldNumber ** 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).
76 76 
darwin:JulianDay,,** No join mapping for day **
77 77 
darwin:PreparationType,,** No join mapping for preparations **
78 78 
darwin:PreviousCatalogNumber,,** No join mapping for otherCatalogNumbers **
inputs/NCU/Specimen/map.csv
12 12 
CurrentScientificNameWithAuthor,scientificName,,
13 13 
TypeStatus,typeStatus,,
14 14 
CollectionDate,dateCollected,,
15 
BarCode,OMIT,,"Omitted because this isn't specified on all rows, but SpecimenPK is"
15 
BarCode,OMIT#BarCode,,"Omitted because this isn't specified on all rows, but SpecimenPK is"
16 16 
CatalogNumber,accessionNumber,,
17 17 
CatalogSeriesPrefix,specimenHolderInstitutions,/_alt/1,
18 18 
Description,occurrenceRemarks,,
inputs/NCU/Specimen/VegBIEN.csv
58 58 
county,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/county/_first/2,
59 59 
State,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2,
60 60 
State,/location/locationplace/*_id/place/stateprovince,
61 
BarCode,,"** No non-empty join mapping for OMIT ** Omitted because this isn't specified on all rows, but SpecimenPK is"
61 
BarCode,,"** No non-empty join mapping for OMIT#BarCode ** Omitted because this isn't specified on all rows, but SpecimenPK is"
62 62 
BlockLocationReason,,** No join mapping for *BlockLocationReason **
63 63 
BlockSpecificLocation,,** No join mapping for *BlockSpecificLocation **
64 64 
CollectionObjectID,,** No join mapping for *CollectionObjectID **
inputs/bien2_traits/TraitObservation/map.csv
1 1 
bien2_traits,VegCore,Filter,Comments
2 2 
TraitObservationID,occurrenceID,,
3 
TaxonomyID,UNUSED,,Always 0
3 
TaxonomyID,UNUSED#TaxonomyID,,Always 0
4 4 
Family,family,,
5 5 
Genus,genus,,
6 6 
SpecificEpithet,specificEpithet,,
inputs/bien2_traits/TraitObservation/VegBIEN.csv
56 56 
Region,,** No join mapping for *Region **
57 57 
SourceCitation,,** No join mapping for *SourceCitation **
58 58 
SourceID,,** No join mapping for *SourceID **
59 
TaxonomyID,,** No non-empty join mapping for UNUSED ** Always 0
59 
TaxonomyID,,** No non-empty join mapping for UNUSED#TaxonomyID ** Always 0
60 60 
URLSource,,** No join mapping for *URLSource **
61 61 
VisitingDate,,** No join mapping for *VisitingDate **
inputs/TEAM/VL/map.csv
17 17 
Sampling Unit Name,*Sampling Unit Name,,
18 18 
Latitude,decimalLatitude,,
19 19 
Longitude,decimalLongitude,,
20 
Method,OMIT,,"Just contains ""Derived"", for 357 rows"
20 
Method,OMIT#Method,,"Just contains ""Derived"", for 357 rows"
21 21 
Subplot Number,subplot,,
22 22 
1ha Plot X Coordinate,organismX_m,,"""Point of intersection {in the X axis} where the tree was observed in the 1ha plot. {m}"" (1ha Plot X Coordinate definition on p. 8 at <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/TEAM/_src/TEAM-DataPackage-20120920191251_3859/Vegetation+-+Trees+&+Lianas/Vegetation-Tree-and-Liana-Metadata-1.5.pdf>)"
23 23 
1ha Plot Y Coordinate,organismY_m,,"""Point of intersection {in the Y axis} where the tree was observed in the 1ha plot. {m}"" (1ha Plot Y Coordinate definition on p. 8 at <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/TEAM/_src/TEAM-DataPackage-20120920191251_3859/Vegetation+-+Trees+&+Lianas/Vegetation-Tree-and-Liana-Metadata-1.5.pdf>)"
inputs/TEAM/VL/VegBIEN.csv
50 50 
Location Codes,,** No join mapping for *Location Codes **
51 51 
Max Diameter,,** No join mapping for *Max Diameter **
52 52 
Max Diameter POM,,** No join mapping for *Max Diameter POM **
53 
Method,,"** No non-empty join mapping for OMIT ** Just contains ""Derived"", for 357 rows"
53 
Method,,"** No non-empty join mapping for OMIT#Method ** Just contains ""Derived"", for 357 rows"
54 54 
Protocol Version,,** No join mapping for *Protocol Version **
55 55 
Sampling Period,,** No join mapping for *Sampling Period **
56 56 
Sampling Unit Name,,** No join mapping for *Sampling Unit Name **
inputs/TEAM/VT/map.csv
17 17 
Sampling Unit Name,*Sampling Unit Name,,
18 18 
Latitude,decimalLatitude,,
19 19 
Longitude,decimalLongitude,,
20 
Spatial Method,OMIT,,"Just contains ""Derived"", for 14927 rows"
20 
Spatial Method,OMIT#Spatial Method,,"Just contains ""Derived"", for 14927 rows"
21 21 
Subplot Number,subplot,,
22 22 
1ha Plot X Coordinate,organismX_m,,"""Point of intersection {in the X axis} where the tree was observed in the 1ha plot. {m}"" (1ha Plot X Coordinate definition on p. 8 at <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/TEAM/_src/TEAM-DataPackage-20120920191251_3859/Vegetation+-+Trees+&+Lianas/Vegetation-Tree-and-Liana-Metadata-1.5.pdf>)"
23 23 
1ha Plot Y Coordinate,organismY_m,,"""Point of intersection {in the Y axis} where the tree was observed in the 1ha plot. {m}"" (1ha Plot Y Coordinate definition on p. 8 at <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/TEAM/_src/TEAM-DataPackage-20120920191251_3859/Vegetation+-+Trees+&+Lianas/Vegetation-Tree-and-Liana-Metadata-1.5.pdf>)"
inputs/TEAM/VT/VegBIEN.csv
53 53 
Protocol Version,,** No join mapping for *Protocol Version **
54 54 
Sampling Period,,** No join mapping for *Sampling Period **
55 55 
Sampling Unit Name,,** No join mapping for *Sampling Unit Name **
56 
Spatial Method,,"** No non-empty join mapping for OMIT ** Just contains ""Derived"", for 14927 rows"
56 
Spatial Method,,"** No non-empty join mapping for OMIT#Spatial Method ** Just contains ""Derived"", for 14927 rows"
57 57 
row_num,,** No join mapping for *row_num **
inputs/SALVIAS/plotMetadata_/VegBIEN.csv
69 69 
PlotID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/cond/_exists","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
70 70 
PlotID,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/1","Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
71 71 
ElevSource,,** No join mapping for *ElevSource **
72 
MethodCode,,** No non-empty join mapping for OMIT ** Not globally unique after lookup_MethodCode_Description is combined with PlotMethod
72 
MethodCode,,** No non-empty join mapping for OMIT#MethodCode ** Not globally unique after lookup_MethodCode_Description is combined with PlotMethod
73 73 
PrecipSource,,** No join mapping for *PrecipSource **
74 74 
PrimOwnerID,,** No join mapping for *PrimOwnerID **
75 75 
RevisionComments,,** No join mapping for *RevisionComments **
inputs/U/Specimen/map.csv
3 3 
ID,dataProviderRecordID,,
4 4 
Barcode,accessionNumber,,
5 5 
Collector,recordedBy,/_join/1,
6 
Prefix,UNUSED,,
6 
Prefix,UNUSED#Prefix,,
7 7 
Number,collectorNumber,,
8 
Suffix,UNUSED,,
8 
Suffix,UNUSED#Suffix,,
9 9 
Addcoll,recordedBy,/_join/2,
10 10 
Colldd,dayCollected,,
11 11 
Collmm,monthCollected,,
12 12 
Collyy,yearCollected,,
13 
DateInfo,UNUSED,,
13 
DateInfo,UNUSED#DateInfo,,
14 14 
Family,family,,
15 15 
Genus,genus,,
16 16 
cf,identificationQualifier,,
inputs/QFA/Specimen/map.csv
5 5 
recordNumber,collectorNumber,,
6 6 
family,family,,
7 7 
associatedSequences,associatedSequences,,
8 
institutionID,UNUSED,,
8 
institutionID,UNUSED#institutionID,,
9 9 
specificEpithet,specificEpithet,,
10 10 
datasetName,dataset,,
11 11 
locality,locality,,
inputs/UBC/Specimen/map.csv
3 3 
id,dataProviderRecordID,,
4 4 
collectionCode,collection,,
5 5 
identificationQualifier,identificationQualifier,,
6 
institutionID,UNUSED,,
6 
institutionID,UNUSED#institutionID,,
7 7 
taxonRank,taxonRank,,
8 8 
nomenclaturalCode,nomenclaturalCode,,
9 9 
verbatimElevation,verbatimElevation,,
inputs/HIBG/Specimen/map.csv
7 7 
verbatimSRS,verbatimSRS,,
8 8 
references,distributors,,
9 9 
habitat,habitat,,
10 
institutionID,UNUSED,,
10 
institutionID,UNUSED#institutionID,,
11 11 
decimalLongitude,decimalLongitude,,
12 12 
verbatimCoordinateSystem,coordinateUnits,,
13 13 
catalogNumber,accessionNumber,,
inputs/bien_web/observation/VegBIEN.csv
72 72 
abund10,,** No join mapping for *abund10 **
73 73 
abund2.5,,** No join mapping for *abund2.5 **
74 74 
acceptance,,** No join mapping for *acceptance **
75 
acceptance_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
75 
acceptance_index,,** No non-empty join mapping for OMIT#acceptance_index ** Placeholder column created by MySQL to PostgreSQL translation
76 76 
bien2_DBPlotID,,** No join mapping for *bien2_DBPlotID **
77 
bien2_DBPlotID_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
77 
bien2_DBPlotID_index,,** No non-empty join mapping for OMIT#bien2_DBPlotID_index ** Placeholder column created by MySQL to PostgreSQL translation
78 78 
bien2_ObservationID,,** No join mapping for *bien2_ObservationID **
79 
bien2_ObservationID_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
79 
bien2_ObservationID_index,,** No non-empty join mapping for OMIT#bien2_ObservationID_index ** Placeholder column created by MySQL to PostgreSQL translation
80 80 
bien2_OccurID,,** No join mapping for *bien2_OccurID **
81 
bien2_OccurID_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
81 
bien2_OccurID_index,,** No non-empty join mapping for OMIT#bien2_OccurID_index ** Placeholder column created by MySQL to PostgreSQL translation
82 82 
bien2_TraitObservationID,,** No join mapping for *bien2_TraitObservationID **
83 
bien2_TraitObservationID_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
83 
bien2_TraitObservationID_index,,** No non-empty join mapping for OMIT#bien2_TraitObservationID_index ** Placeholder column created by MySQL to PostgreSQL translation
84 84 
bien2_taxonomyID,,** No join mapping for *bien2_taxonomyID **
85 
bien2_taxonomyID_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
86 
collector_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
85 
bien2_taxonomyID_index,,** No non-empty join mapping for OMIT#bien2_taxonomyID_index ** Placeholder column created by MySQL to PostgreSQL translation
86 
collector_index,,** No non-empty join mapping for OMIT#collector_index ** Placeholder column created by MySQL to PostgreSQL translation
87 87 
countryError,,** No join mapping for *countryError **
88 
country_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
88 
country_index,,** No non-empty join mapping for OMIT#country_index ** Placeholder column created by MySQL to PostgreSQL translation
89 89 
dataSourceID,,** No join mapping for *dataSourceID **
90 
dataSourceID_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
90 
dataSourceID_index,,** No non-empty join mapping for OMIT#dataSourceID_index ** Placeholder column created by MySQL to PostgreSQL translation
91 91 
dataSourceNamePrimary,,** No join mapping for *dataSourceNamePrimary **
92 
dataSourceNamePrimary_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
93 
dataSourceName_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
94 
family_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
95 
genus_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
92 
dataSourceNamePrimary_index,,** No non-empty join mapping for OMIT#dataSourceNamePrimary_index ** Placeholder column created by MySQL to PostgreSQL translation
93 
dataSourceName_index,,** No non-empty join mapping for OMIT#dataSourceName_index ** Placeholder column created by MySQL to PostgreSQL translation
94 
family_index,,** No non-empty join mapping for OMIT#family_index ** Placeholder column created by MySQL to PostgreSQL translation
95 
genus_index,,** No non-empty join mapping for OMIT#genus_index ** Placeholder column created by MySQL to PostgreSQL translation
96 96 
higherPlantGroup,,** No join mapping for higherPlantGroup **
97 
higherPlantGroup_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
98 
identifiedBy_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
97 
higherPlantGroup_index,,** No non-empty join mapping for OMIT#higherPlantGroup_index ** Placeholder column created by MySQL to PostgreSQL translation
98 
identifiedBy_index,,** No non-empty join mapping for OMIT#identifiedBy_index ** Placeholder column created by MySQL to PostgreSQL translation
99 99 
isCultivatedReason,,** No join mapping for cultivatedBasis **
100 
isCultivatedReason_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
101 
isCultivated_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
102 
isGeovalid_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
100 
isCultivatedReason_index,,** No non-empty join mapping for OMIT#isCultivatedReason_index ** Placeholder column created by MySQL to PostgreSQL translation
101 
isCultivated_index,,** No non-empty join mapping for OMIT#isCultivated_index ** Placeholder column created by MySQL to PostgreSQL translation
102 
isGeovalid_index,,** No non-empty join mapping for OMIT#isGeovalid_index ** Placeholder column created by MySQL to PostgreSQL translation
103 103 
isNewWorld,,** No join mapping for isNewWorld **
104 
isNewWorld_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
105 
isValidLatLong_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
104 
isNewWorld_index,,** No non-empty join mapping for OMIT#isNewWorld_index ** Placeholder column created by MySQL to PostgreSQL translation
105 
isValidLatLong_index,,** No non-empty join mapping for OMIT#isValidLatLong_index ** Placeholder column created by MySQL to PostgreSQL translation
106 106 
localityDescription,,** No join mapping for *localityDescription **
107 
observationID_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
108 
observationType_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
109 
plotAreaHa_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
110 
plotCode_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
111 
plotID_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
112 
plotMethod_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
107 
observationID_index,,** No non-empty join mapping for OMIT#observationID_index ** Placeholder column created by MySQL to PostgreSQL translation
108 
observationType_index,,** No non-empty join mapping for OMIT#observationType_index ** Placeholder column created by MySQL to PostgreSQL translation
109 
plotAreaHa_index,,** No non-empty join mapping for OMIT#plotAreaHa_index ** Placeholder column created by MySQL to PostgreSQL translation
110 
plotCode_index,,** No non-empty join mapping for OMIT#plotCode_index ** Placeholder column created by MySQL to PostgreSQL translation
111 
plotID_index,,** No non-empty join mapping for OMIT#plotID_index ** Placeholder column created by MySQL to PostgreSQL translation
112 
plotMethod_index,,** No non-empty join mapping for OMIT#plotMethod_index ** Placeholder column created by MySQL to PostgreSQL translation
113 113 
plotMinDbh,,** No join mapping for *plotMinDbh **
114 
plotMinDbh_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
114 
plotMinDbh_index,,** No non-empty join mapping for OMIT#plotMinDbh_index ** Placeholder column created by MySQL to PostgreSQL translation
115 115 
rank,,** No join mapping for *rank **
116 
rank_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
117 
species_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
116 
rank_index,,** No non-empty join mapping for OMIT#rank_index ** Placeholder column created by MySQL to PostgreSQL translation
117 
species_index,,** No non-empty join mapping for OMIT#species_index ** Placeholder column created by MySQL to PostgreSQL translation
118 118 
stateProvinceError,,** No join mapping for *stateProvinceError **
119 
stateProvince_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
120 
taxonAuthor_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
119 
stateProvince_index,,** No non-empty join mapping for OMIT#stateProvince_index ** Placeholder column created by MySQL to PostgreSQL translation
120 
taxonAuthor_index,,** No non-empty join mapping for OMIT#taxonAuthor_index ** Placeholder column created by MySQL to PostgreSQL translation
121 121 
taxonAuthorityVerbatim,,** No join mapping for *taxonAuthorityVerbatim **
122 
taxonAuthorityVerbatim_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
122 
taxonAuthorityVerbatim_index,,** No non-empty join mapping for OMIT#taxonAuthorityVerbatim_index ** Placeholder column created by MySQL to PostgreSQL translation
123 123 
taxonMorphospecies,,** No join mapping for speciesBinomialWithMorphospecies **
124 
taxonMorphospecies_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
125 
taxon_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
124 
taxonMorphospecies_index,,** No non-empty join mapping for OMIT#taxonMorphospecies_index ** Placeholder column created by MySQL to PostgreSQL translation
125 
taxon_index,,** No non-empty join mapping for OMIT#taxon_index ** Placeholder column created by MySQL to PostgreSQL translation
126 126 
traitMethod,,** No join mapping for *traitMethod **
127 
traitMethod_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
128 
traitName_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
127 
traitMethod_index,,** No non-empty join mapping for OMIT#traitMethod_index ** Placeholder column created by MySQL to PostgreSQL translation
128 
traitName_index,,** No non-empty join mapping for OMIT#traitName_index ** Placeholder column created by MySQL to PostgreSQL translation
129 129 
traitUnit,,** No join mapping for *traitUnit **
130 
traitUnit_index,,** No non-empty join mapping for OMIT ** Placeholder column created by MySQL to PostgreSQL translation
130 
traitUnit_index,,** No non-empty join mapping for OMIT#traitUnit_index ** Placeholder column created by MySQL to PostgreSQL translation
inputs/NY/Ecatalog_all/VegBIEN.csv
79 79 
StateProvince,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2,
80 80 
StateProvince,/location/locationplace/*_id/place/stateprovince,
81 81 
BasisOfRecord,,** No join mapping for basisOfRecord **
82 
CollectorNumber,,** No non-empty join mapping for UNUSED **
82 
CollectorNumber,,** No non-empty join mapping for UNUSED#CollectorNumber **
83 83 
DateLastModified,,** No join mapping for modified **
84 84 
JulianDay,,** No join mapping for day **
85 85 
PreparationType,,** No join mapping for preparations **
......
88 88 
RelationshipType,,** No join mapping for relationshipOfResource **
89 89 
TimeOfDay,,** No join mapping for eventTime **
90 90 
TypeStatus,,** No join mapping for typeStatus **
91 
UniqueNYInternalRecordNumber,,** No non-empty join mapping for OMIT ** Sometimes duplicated. Omitted to avoid confusion since this is an internal-only ID.
92 
key,,"** No non-empty join mapping for OMIT ** CatalogNumber, etc. is a better pkey"
93 
pkey,,"** No non-empty join mapping for OMIT ** CatalogNumber, etc. is a better pkey"
91 
UniqueNYInternalRecordNumber,,** No non-empty join mapping for OMIT#UniqueNYInternalRecordNumber ** Sometimes duplicated. Omitted to avoid confusion since this is an internal-only ID.
92 
key,,"** No non-empty join mapping for OMIT#key ** CatalogNumber, etc. is a better pkey"
93 
pkey,,"** No non-empty join mapping for OMIT#pkey ** CatalogNumber, etc. is a better pkey"
inputs/Madidi/IndividualObservation/VegBIEN.csv
72 72 
Sequence,"/location/sourceaccessioncode/_first/2/_if[@name=""if locationID""]/then/_if[@name=""if subplot""]/then/_join/2",
73 73 
SubplotX,/location/sublocationxposition_m,
74 74 
SubplotY,/location/sublocationyposition_m,
75 
AreaRachilla1,,** No non-empty join mapping for UNUSED **
76 
AreaRachilla2,,** No non-empty join mapping for UNUSED **
77 
AreaRachilla3,,** No non-empty join mapping for UNUSED **
78 
AreaRachilla4,,** No non-empty join mapping for UNUSED **
79 
AreaRachilla5,,** No non-empty join mapping for UNUSED **
80 
AreaRachis1,,** No non-empty join mapping for UNUSED **
81 
AreaRachis2,,** No non-empty join mapping for UNUSED **
82 
AreaRachis3,,** No non-empty join mapping for UNUSED **
83 
AreaRachis4,,** No non-empty join mapping for UNUSED **
84 
AreaRachis5,,** No non-empty join mapping for UNUSED **
75 
AreaRachilla1,,** No non-empty join mapping for UNUSED#AreaRachilla1 **
76 
AreaRachilla2,,** No non-empty join mapping for UNUSED#AreaRachilla2 **
77 
AreaRachilla3,,** No non-empty join mapping for UNUSED#AreaRachilla3 **
78 
AreaRachilla4,,** No non-empty join mapping for UNUSED#AreaRachilla4 **
79 
AreaRachilla5,,** No non-empty join mapping for UNUSED#AreaRachilla5 **
80 
AreaRachis1,,** No non-empty join mapping for UNUSED#AreaRachis1 **
81 
AreaRachis2,,** No non-empty join mapping for UNUSED#AreaRachis2 **
82 
AreaRachis3,,** No non-empty join mapping for UNUSED#AreaRachis3 **
83 
AreaRachis4,,** No non-empty join mapping for UNUSED#AreaRachis4 **
84 
AreaRachis5,,** No non-empty join mapping for UNUSED#AreaRachis5 **
85 85 
BoleHeight,,** No join mapping for *BoleHeight **
86 
CauseOfDeath1,,** No non-empty join mapping for UNUSED **
87 
CauseOfDeath2,,** No non-empty join mapping for UNUSED **
88 
CauseOfDeath3,,** No non-empty join mapping for UNUSED **
89 
CauseOfDeath4,,** No non-empty join mapping for UNUSED **
90 
CauseOfDeath5,,** No non-empty join mapping for UNUSED **
86 
CauseOfDeath1,,** No non-empty join mapping for UNUSED#CauseOfDeath1 **
87 
CauseOfDeath2,,** No non-empty join mapping for UNUSED#CauseOfDeath2 **
88 
CauseOfDeath3,,** No non-empty join mapping for UNUSED#CauseOfDeath3 **
89 
CauseOfDeath4,,** No non-empty join mapping for UNUSED#CauseOfDeath4 **
90 
CauseOfDeath5,,** No non-empty join mapping for UNUSED#CauseOfDeath5 **
91 91 
Circumference,,** No join mapping for *Circumference **
92 92 
CommonName,,** No join mapping for vernacularName **
93 
CompoundLeaf,,** No non-empty join mapping for UNUSED **
94 
CompoundLeafID,,** No non-empty join mapping for UNUSED **
93 
CompoundLeaf,,** No non-empty join mapping for UNUSED#CompoundLeaf **
94 
CompoundLeafID,,** No non-empty join mapping for UNUSED#CompoundLeafID **
95 95 
CrownPositionName,,** No join mapping for *CrownPositionName **
96 96 
CrownShapeName,,** No join mapping for *CrownShapeName **
97 
CurrentDetFamily,,"** No non-empty join mapping for OMIT ** Omitted because includes *family* author, which TNRS can’t handle"
97 
CurrentDetFamily,,"** No non-empty join mapping for OMIT#CurrentDetFamily ** Omitted because includes *family* author, which TNRS can’t handle"
98 98 
DNASample,,** No join mapping for *DNASample **
99 
Decomposition,,** No non-empty join mapping for UNUSED **
100 
DiameterWithBark,,** No non-empty join mapping for UNUSED **
101 
DiameterWithoutBark,,** No non-empty join mapping for UNUSED **
102 
DirectionOfFall,,** No non-empty join mapping for UNUSED **
103 
DryWeight,,** No non-empty join mapping for UNUSED **
104 
FieldFamilyHTML,,"** No non-empty join mapping for OMIT ** Omitted because includes *family* author, which TNRS can’t handle"
105 
FieldNameHTML,,** No non-empty join mapping for OMIT ** Adds HTML formatting to FieldNameFullName+FieldNameAuthors
106 
HeightButtresses,,** No non-empty join mapping for UNUSED **
99 
Decomposition,,** No non-empty join mapping for UNUSED#Decomposition **
100 
DiameterWithBark,,** No non-empty join mapping for UNUSED#DiameterWithBark **
101 
DiameterWithoutBark,,** No non-empty join mapping for UNUSED#DiameterWithoutBark **
102 
DirectionOfFall,,** No non-empty join mapping for UNUSED#DirectionOfFall **
103 
DryWeight,,** No non-empty join mapping for UNUSED#DryWeight **
104 
FieldFamilyHTML,,"** No non-empty join mapping for OMIT#FieldFamilyHTML ** Omitted because includes *family* author, which TNRS can’t handle"
105 
FieldNameHTML,,** No non-empty join mapping for OMIT#FieldNameHTML ** Adds HTML formatting to FieldNameFullName+FieldNameAuthors
106 
HeightButtresses,,** No non-empty join mapping for UNUSED#HeightButtresses **
107 107 
InstitutionString,,** No join mapping for *InstitutionString **
108 108 
IsAlive,,** No join mapping for *IsAlive **
109 
LeafPhoto1,,** No non-empty join mapping for UNUSED **
110 
LeafPhoto2,,** No non-empty join mapping for UNUSED **
111 
LeafPhoto3,,** No non-empty join mapping for UNUSED **
112 
LeafPhoto4,,** No non-empty join mapping for UNUSED **
113 
LeafPhoto5,,** No non-empty join mapping for UNUSED **
109 
LeafPhoto1,,** No non-empty join mapping for UNUSED#LeafPhoto1 **
110 
LeafPhoto2,,** No non-empty join mapping for UNUSED#LeafPhoto2 **
111 
LeafPhoto3,,** No non-empty join mapping for UNUSED#LeafPhoto3 **
112 
LeafPhoto4,,** No non-empty join mapping for UNUSED#LeafPhoto4 **
113 
LeafPhoto5,,** No non-empty join mapping for UNUSED#LeafPhoto5 **
114 114 
LianaPresenceName,,** No join mapping for *LianaPresenceName **
115 
MortalityType,,** No non-empty join mapping for UNUSED **
116 
MultipleFalls,,** No non-empty join mapping for UNUSED **
117 
NitrogenContent,,** No non-empty join mapping for UNUSED **
118 
NumberFolioles1,,** No non-empty join mapping for UNUSED **
119 
NumberFolioles2,,** No non-empty join mapping for UNUSED **
120 
NumberFolioles3,,** No non-empty join mapping for UNUSED **
121 
NumberFolioles4,,** No non-empty join mapping for UNUSED **
122 
NumberFolioles5,,** No non-empty join mapping for UNUSED **
123 
NumberFoliolules1,,** No non-empty join mapping for UNUSED **
124 
NumberFoliolules2,,** No non-empty join mapping for UNUSED **
125 
NumberFoliolules3,,** No non-empty join mapping for UNUSED **
126 
NumberFoliolules4,,** No non-empty join mapping for UNUSED **
127 
NumberFoliolules5,,** No non-empty join mapping for UNUSED **
128 
NumberOfLeaves,,** No non-empty join mapping for UNUSED **
115 
MortalityType,,** No non-empty join mapping for UNUSED#MortalityType **
116 
MultipleFalls,,** No non-empty join mapping for UNUSED#MultipleFalls **
117 
NitrogenContent,,** No non-empty join mapping for UNUSED#NitrogenContent **
118 
NumberFolioles1,,** No non-empty join mapping for UNUSED#NumberFolioles1 **
119 
NumberFolioles2,,** No non-empty join mapping for UNUSED#NumberFolioles2 **
120 
NumberFolioles3,,** No non-empty join mapping for UNUSED#NumberFolioles3 **
121 
NumberFolioles4,,** No non-empty join mapping for UNUSED#NumberFolioles4 **
122 
NumberFolioles5,,** No non-empty join mapping for UNUSED#NumberFolioles5 **
123 
NumberFoliolules1,,** No non-empty join mapping for UNUSED#NumberFoliolules1 **
124 
NumberFoliolules2,,** No non-empty join mapping for UNUSED#NumberFoliolules2 **
125 
NumberFoliolules3,,** No non-empty join mapping for UNUSED#NumberFoliolules3 **
126 
NumberFoliolules4,,** No non-empty join mapping for UNUSED#NumberFoliolules4 **
127 
NumberFoliolules5,,** No non-empty join mapping for UNUSED#NumberFoliolules5 **
128 
NumberOfLeaves,,** No non-empty join mapping for UNUSED#NumberOfLeaves **
129 129 
OrientationXDegrees,,** No join mapping for *OrientationXDegrees **
130 130 
OrientationYDegrees,,** No join mapping for *OrientationYDegrees **
131 131 
Phenology1,,** No join mapping for *Phenology1 **
132 132 
Phenology2,,** No join mapping for *Phenology2 **
133 133 
Phenology3,,** No join mapping for *Phenology3 **
134 134 
Phenology4,,** No join mapping for *Phenology4 **
135 
RachisPhoto1,,** No non-empty join mapping for UNUSED **
136 
RachisPhoto2,,** No non-empty join mapping for UNUSED **
137 
RachisPhoto3,,** No non-empty join mapping for UNUSED **
138 
RachisPhoto4,,** No non-empty join mapping for UNUSED **
139 
RachisPhoto5,,** No non-empty join mapping for UNUSED **
140 
RemainingTrunkHeight,,** No non-empty join mapping for UNUSED **
135 
RachisPhoto1,,** No non-empty join mapping for UNUSED#RachisPhoto1 **
136 
RachisPhoto2,,** No non-empty join mapping for UNUSED#RachisPhoto2 **
137 
RachisPhoto3,,** No non-empty join mapping for UNUSED#RachisPhoto3 **
138 
RachisPhoto4,,** No non-empty join mapping for UNUSED#RachisPhoto4 **
139 
RachisPhoto5,,** No non-empty join mapping for UNUSED#RachisPhoto5 **
140 
RemainingTrunkHeight,,** No non-empty join mapping for UNUSED#RemainingTrunkHeight **
141 141 
RepresentativeCollectionNumber,,** No join mapping for *RepresentativeCollectionNumber **
142 142 
RepresentativeSpecimenCollectorAbbreviation,,** No join mapping for *RepresentativeSpecimenCollectorAbbreviation **
143 143 
RepresentativeSpecimenID,,** No join mapping for *RepresentativeSpecimenID **
144 144 
RepresentativeSpecimenSeniorCollector,,** No join mapping for *RepresentativeSpecimenSeniorCollector **
145 
SLAArea1,,** No non-empty join mapping for UNUSED **
146 
SLAArea10,,** No non-empty join mapping for UNUSED **
147 
SLAArea11,,** No non-empty join mapping for UNUSED **
148 
SLAArea12,,** No non-empty join mapping for UNUSED **
149 
SLAArea13,,** No non-empty join mapping for UNUSED **
150 
SLAArea14,,** No non-empty join mapping for UNUSED **
151 
SLAArea15,,** No non-empty join mapping for UNUSED **
152 
SLAArea2,,** No non-empty join mapping for UNUSED **
153 
SLAArea3,,** No non-empty join mapping for UNUSED **
154 
SLAArea4,,** No non-empty join mapping for UNUSED **
155 
SLAArea5,,** No non-empty join mapping for UNUSED **
156 
SLAArea6,,** No non-empty join mapping for UNUSED **
157 
SLAArea7,,** No non-empty join mapping for UNUSED **
158 
SLAArea8,,** No non-empty join mapping for UNUSED **
159 
SLAArea9,,** No non-empty join mapping for UNUSED **
145 
SLAArea1,,** No non-empty join mapping for UNUSED#SLAArea1 **
146 
SLAArea10,,** No non-empty join mapping for UNUSED#SLAArea10 **
147 
SLAArea11,,** No non-empty join mapping for UNUSED#SLAArea11 **
148 
SLAArea12,,** No non-empty join mapping for UNUSED#SLAArea12 **
149 
SLAArea13,,** No non-empty join mapping for UNUSED#SLAArea13 **
150 
SLAArea14,,** No non-empty join mapping for UNUSED#SLAArea14 **
151 
SLAArea15,,** No non-empty join mapping for UNUSED#SLAArea15 **
152 
SLAArea2,,** No non-empty join mapping for UNUSED#SLAArea2 **
153 
SLAArea3,,** No non-empty join mapping for UNUSED#SLAArea3 **
154 
SLAArea4,,** No non-empty join mapping for UNUSED#SLAArea4 **
155 
SLAArea5,,** No non-empty join mapping for UNUSED#SLAArea5 **
156 
SLAArea6,,** No non-empty join mapping for UNUSED#SLAArea6 **
157 
SLAArea7,,** No non-empty join mapping for UNUSED#SLAArea7 **
158 
SLAArea8,,** No non-empty join mapping for UNUSED#SLAArea8 **
159 
SLAArea9,,** No non-empty join mapping for UNUSED#SLAArea9 **
160 160 
SubplotX2,,** No join mapping for *SubplotX2 **
161 161 
SubplotY2,,** No join mapping for *SubplotY2 **
162 
Thickness1,,** No non-empty join mapping for UNUSED **
163 
Thickness10,,** No non-empty join mapping for UNUSED **
164 
Thickness11,,** No non-empty join mapping for UNUSED **
165 
Thickness12,,** No non-empty join mapping for UNUSED **
166 
Thickness13,,** No non-empty join mapping for UNUSED **
167 
Thickness14,,** No non-empty join mapping for UNUSED **
168 
Thickness15,,** No non-empty join mapping for UNUSED **
169 
Thickness2,,** No non-empty join mapping for UNUSED **
170 
Thickness3,,** No non-empty join mapping for UNUSED **
171 
Thickness4,,** No non-empty join mapping for UNUSED **
172 
Thickness5,,** No non-empty join mapping for UNUSED **
173 
Thickness6,,** No non-empty join mapping for UNUSED **
174 
Thickness7,,** No non-empty join mapping for UNUSED **
175 
Thickness8,,** No non-empty join mapping for UNUSED **
176 
Thickness9,,** No non-empty join mapping for UNUSED **
177 
TotArea1,,** No non-empty join mapping for UNUSED **
178 
TotArea10,,** No non-empty join mapping for UNUSED **
179 
TotArea11,,** No non-empty join mapping for UNUSED **
180 
TotArea12,,** No non-empty join mapping for UNUSED **
181 
TotArea13,,** No non-empty join mapping for UNUSED **
182 
TotArea14,,** No non-empty join mapping for UNUSED **
183 
TotArea15,,** No non-empty join mapping for UNUSED **
184 
TotArea2,,** No non-empty join mapping for UNUSED **
185 
TotArea3,,** No non-empty join mapping for UNUSED **
186 
TotArea4,,** No non-empty join mapping for UNUSED **
187 
TotArea5,,** No non-empty join mapping for UNUSED **
188 
TotArea6,,** No non-empty join mapping for UNUSED **
189 
TotArea7,,** No non-empty join mapping for UNUSED **
190 
TotArea8,,** No non-empty join mapping for UNUSED **
191 
TotArea9,,** No non-empty join mapping for UNUSED **
192 
TreeLeaf3Notes,,** No non-empty join mapping for UNUSED **
193 
TreeMortalityNotes,,** No non-empty join mapping for UNUSED **
194 
TreeTrunkNotes,,** No non-empty join mapping for UNUSED **
195 
VesselArea,,** No non-empty join mapping for UNUSED **
196 
VesselNumber,,** No non-empty join mapping for UNUSED **
197 
Volume1,,** No non-empty join mapping for UNUSED **
198 
Volume2,,** No non-empty join mapping for UNUSED **
162 
Thickness1,,** No non-empty join mapping for UNUSED#Thickness1 **
163 
Thickness10,,** No non-empty join mapping for UNUSED#Thickness10 **
164 
Thickness11,,** No non-empty join mapping for UNUSED#Thickness11 **
165 
Thickness12,,** No non-empty join mapping for UNUSED#Thickness12 **
166 
Thickness13,,** No non-empty join mapping for UNUSED#Thickness13 **
167 
Thickness14,,** No non-empty join mapping for UNUSED#Thickness14 **
168 
Thickness15,,** No non-empty join mapping for UNUSED#Thickness15 **
169 
Thickness2,,** No non-empty join mapping for UNUSED#Thickness2 **
170 
Thickness3,,** No non-empty join mapping for UNUSED#Thickness3 **
171 
Thickness4,,** No non-empty join mapping for UNUSED#Thickness4 **
172 
Thickness5,,** No non-empty join mapping for UNUSED#Thickness5 **
173 
Thickness6,,** No non-empty join mapping for UNUSED#Thickness6 **
174 
Thickness7,,** No non-empty join mapping for UNUSED#Thickness7 **
175 
Thickness8,,** No non-empty join mapping for UNUSED#Thickness8 **
176 
Thickness9,,** No non-empty join mapping for UNUSED#Thickness9 **
177 
TotArea1,,** No non-empty join mapping for UNUSED#TotArea1 **
178 
TotArea10,,** No non-empty join mapping for UNUSED#TotArea10 **
179 
TotArea11,,** No non-empty join mapping for UNUSED#TotArea11 **
180 
TotArea12,,** No non-empty join mapping for UNUSED#TotArea12 **
181 
TotArea13,,** No non-empty join mapping for UNUSED#TotArea13 **
182 
TotArea14,,** No non-empty join mapping for UNUSED#TotArea14 **
183 
TotArea15,,** No non-empty join mapping for UNUSED#TotArea15 **
184 
TotArea2,,** No non-empty join mapping for UNUSED#TotArea2 **
185 
TotArea3,,** No non-empty join mapping for UNUSED#TotArea3 **
186 
TotArea4,,** No non-empty join mapping for UNUSED#TotArea4 **
187 
TotArea5,,** No non-empty join mapping for UNUSED#TotArea5 **
188 
TotArea6,,** No non-empty join mapping for UNUSED#TotArea6 **
189 
TotArea7,,** No non-empty join mapping for UNUSED#TotArea7 **
190 
TotArea8,,** No non-empty join mapping for UNUSED#TotArea8 **
191 
TotArea9,,** No non-empty join mapping for UNUSED#TotArea9 **
192 
TreeLeaf3Notes,,** No non-empty join mapping for UNUSED#TreeLeaf3Notes **
193 
TreeMortalityNotes,,** No non-empty join mapping for UNUSED#TreeMortalityNotes **
194 
TreeTrunkNotes,,** No non-empty join mapping for UNUSED#TreeTrunkNotes **
195 
VesselArea,,** No non-empty join mapping for UNUSED#VesselArea **
196 
VesselNumber,,** No non-empty join mapping for UNUSED#VesselNumber **
197 
Volume1,,** No non-empty join mapping for UNUSED#Volume1 **
198 
Volume2,,** No non-empty join mapping for UNUSED#Volume2 **
199 199 
WasCollected,,** No join mapping for *WasCollected **
200 
Weight1,,** No non-empty join mapping for UNUSED **
201 
Weight10,,** No non-empty join mapping for UNUSED **
202 
Weight11,,** No non-empty join mapping for UNUSED **
203 
Weight12,,** No non-empty join mapping for UNUSED **
204 
Weight13,,** No non-empty join mapping for UNUSED **
205 
Weight14,,** No non-empty join mapping for UNUSED **
206 
Weight15,,** No non-empty join mapping for UNUSED **
207 
Weight2,,** No non-empty join mapping for UNUSED **
208 
Weight3,,** No non-empty join mapping for UNUSED **
209 
Weight4,,** No non-empty join mapping for UNUSED **
210 
Weight5,,** No non-empty join mapping for UNUSED **
211 
Weight6,,** No non-empty join mapping for UNUSED **
212 
Weight7,,** No non-empty join mapping for UNUSED **
213 
Weight8,,** No non-empty join mapping for UNUSED **
214 
Weight9,,** No non-empty join mapping for UNUSED **
215 
WeightOfBranch,,** No non-empty join mapping for UNUSED **
216 
WeightRachilla1,,** No non-empty join mapping for UNUSED **
217 
WeightRachilla2,,** No non-empty join mapping for UNUSED **
218 
WeightRachilla3,,** No non-empty join mapping for UNUSED **
219 
WeightRachilla4,,** No non-empty join mapping for UNUSED **
220 
WeightRachilla5,,** No non-empty join mapping for UNUSED **
221 
WeightRachis1,,** No non-empty join mapping for UNUSED **
222 
WeightRachis2,,** No non-empty join mapping for UNUSED **
223 
WeightRachis3,,** No non-empty join mapping for UNUSED **
224 
WeightRachis4,,** No non-empty join mapping for UNUSED **
225 
WeightRachis5,,** No non-empty join mapping for UNUSED **
226 
WidthButtresses,,** No non-empty join mapping for UNUSED **
200 
Weight1,,** No non-empty join mapping for UNUSED#Weight1 **
201 
Weight10,,** No non-empty join mapping for UNUSED#Weight10 **
202 
Weight11,,** No non-empty join mapping for UNUSED#Weight11 **
203 
Weight12,,** No non-empty join mapping for UNUSED#Weight12 **
204 
Weight13,,** No non-empty join mapping for UNUSED#Weight13 **
205 
Weight14,,** No non-empty join mapping for UNUSED#Weight14 **
206 
Weight15,,** No non-empty join mapping for UNUSED#Weight15 **
207 
Weight2,,** No non-empty join mapping for UNUSED#Weight2 **
208 
Weight3,,** No non-empty join mapping for UNUSED#Weight3 **
209 
Weight4,,** No non-empty join mapping for UNUSED#Weight4 **
210 
Weight5,,** No non-empty join mapping for UNUSED#Weight5 **
211 
Weight6,,** No non-empty join mapping for UNUSED#Weight6 **
212 
Weight7,,** No non-empty join mapping for UNUSED#Weight7 **
213 
Weight8,,** No non-empty join mapping for UNUSED#Weight8 **
214 
Weight9,,** No non-empty join mapping for UNUSED#Weight9 **
215 
WeightOfBranch,,** No non-empty join mapping for UNUSED#WeightOfBranch **
216 
WeightRachilla1,,** No non-empty join mapping for UNUSED#WeightRachilla1 **
217 
WeightRachilla2,,** No non-empty join mapping for UNUSED#WeightRachilla2 **
218 
WeightRachilla3,,** No non-empty join mapping for UNUSED#WeightRachilla3 **
219 
WeightRachilla4,,** No non-empty join mapping for UNUSED#WeightRachilla4 **
220 
WeightRachilla5,,** No non-empty join mapping for UNUSED#WeightRachilla5 **
221 
WeightRachis1,,** No non-empty join mapping for UNUSED#WeightRachis1 **
222 
WeightRachis2,,** No non-empty join mapping for UNUSED#WeightRachis2 **
223 
WeightRachis3,,** No non-empty join mapping for UNUSED#WeightRachis3 **
224 
WeightRachis4,,** No non-empty join mapping for UNUSED#WeightRachis4 **
225 
WeightRachis5,,** No non-empty join mapping for UNUSED#WeightRachis5 **
226 
WidthButtresses,,** No non-empty join mapping for UNUSED#WidthButtresses **
227 227 
row_num,,** No join mapping for *row_num **
inputs/TEAM/VT/new_terms.csv
1 1 
Observation Date,eventDate,,
2 2 
Names of Collectors,recordedBy,,
3 3 
Diameter,diameterBreastHeight_cm,,"""Tree diameter measurement. {cm}"" (Diameter definition on p. 7 at <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/TEAM/_src/TEAM-DataPackage-20120920191251_3859/Vegetation+-+Trees+&+Lianas/Vegetation-Tree-and-Liana-Metadata-1.5.pdf>)"
4 
Spatial Method,OMIT,,"Just contains ""Derived"", for 14927 rows"
4 
Spatial Method,OMIT#Spatial Method,,"Just contains ""Derived"", for 14927 rows"
5 5 
Subplot Number,subplot,,
6 6 
1ha Plot X Coordinate,organismX_m,,"""Point of intersection {in the X axis} where the tree was observed in the 1ha plot. {m}"" (1ha Plot X Coordinate definition on p. 8 at <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/TEAM/_src/TEAM-DataPackage-20120920191251_3859/Vegetation+-+Trees+&+Lianas/Vegetation-Tree-and-Liana-Metadata-1.5.pdf>)"
7 7 
1ha Plot Y Coordinate,organismY_m,,"""Point of intersection {in the Y axis} where the tree was observed in the 1ha plot. {m}"" (1ha Plot Y Coordinate definition on p. 8 at <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/TEAM/_src/TEAM-DataPackage-20120920191251_3859/Vegetation+-+Trees+&+Lianas/Vegetation-Tree-and-Liana-Metadata-1.5.pdf>)"
inputs/CTFS/TaxonOccurrence/map.csv
13 13 
SubSpeciesName,subspecies,,
14 14 
SubSpeciesMnemonic,*SubSpeciesMnemonic,,
15 15 
SubSpeciesAuthority,*SubSpeciesAuthority,,
16 
InfraSpecificLevel,UNUSED,,
16 
InfraSpecificLevel,UNUSED#InfraSpecificLevel,,
17 17 
SpecificEpithet.src.row_num,*SpecificEpithet.src.row_num,,
18 18 
SpeciesCurrentTaxonFlag,*SpeciesCurrentTaxonFlag,,
19 19 
SpeciesObsoleteTaxonFlag,*SpeciesObsoleteTaxonFlag,,
inputs/CTFS/TaxonOccurrence/VegBIEN.csv
36 36 
GenusID,,** No join mapping for *GenusID **
37 37 
GenusReferenceID,,** No join mapping for *GenusReferenceID **
38 38 
IDLevel,,** No join mapping for *IDLevel **
39 
InfraSpecificLevel,,** No non-empty join mapping for UNUSED **
39 
InfraSpecificLevel,,** No non-empty join mapping for UNUSED#InfraSpecificLevel **
40 40 
InfraspecificEpithet.src.row_num,,** No join mapping for *InfraspecificEpithet.src.row_num **
41 41 
ReferenceID,,** No join mapping for *ReferenceID **
42 42 
SpeciesCurrentTaxonFlag,,** No join mapping for *SpeciesCurrentTaxonFlag **
inputs/CTFS/Subplot/map.csv
2 2 
row_num,*row_num,,
3 3 
QuadratID,subplot,,Not globally unique; unique only within Site
4 4 
PlotID,locationID,,
5 
QuadratName,OMIT,,QuadratID is used for the same purpose
5 
QuadratName,OMIT#QuadratName,,QuadratID is used for the same purpose
6 6 
StartX,subplotX,,
7 7 
StartY,subplotY,,
8 8 
DimX,*DimX,,
inputs/CTFS/Subplot/VegBIEN.csv
17 17 
StartY,/location/sublocationyposition_m,
18 18 
DimX,,** No join mapping for *DimX **
19 19 
DimY,,** No join mapping for *DimY **
20 
QuadratName,,** No non-empty join mapping for OMIT ** QuadratID is used for the same purpose
20 
QuadratName,,** No non-empty join mapping for OMIT#QuadratName ** QuadratID is used for the same purpose
21 21 
row_num,,** No join mapping for *row_num **
inputs/TEX/Specimen2/map.csv
19 19 
LATITUDE,latitude_DMS,,
20 20 
LONGITUDE,longitude_DMS,,
21 21 
EXACT DATE,dateCollected,/_alt/1,
22 
END DATE,UNUSED,,
22 
END DATE,UNUSED#END DATE,,
23 23 
GENERAL DATE,dateCollected,/_alt/2,
24 24 
COLLECTOR 1 FIRST NAME,recordedBy,/_join/1/_join_words/1,
25 25 
COLLECTOR 1 LAST NAME,recordedBy,/_join/1/_join_words/2,
inputs/TEX/Specimen2/VegBIEN.csv
63 63 
DATABASED BY,,** No join mapping for *DATABASED BY **
64 64 
DET NOTES,,** No join mapping for identificationRemarks **
65 65 
DETERMINER INSTITUTION,,** No join mapping for *DETERMINER INSTITUTION **
66 
END DATE,,** No non-empty join mapping for UNUSED **
66 
END DATE,,** No non-empty join mapping for UNUSED#END DATE **
67 67 
LATLONG DATUM,,** No join mapping for *LATLONG DATUM **
68 68 
LATLONG SOURCE,,** No join mapping for *LATLONG SOURCE **
69 69 
SUBSPECIES AUTHOR,,** No join mapping for *SUBSPECIES AUTHOR **
inputs/BRIT/specimen_flat/map.csv
1 1 
BRIT,VegCore,Filter,Comments
2 2 
specimen_id,dataProviderRecordID,,
3 3 
Institution_Code,specimenHolderInstitutions,,
4 
Global_Unique_Identifier,UNUSED,,
4 
Global_Unique_Identifier,UNUSED#Global_Unique_Identifier,,
5 5 
Collector_Abbrev_Name,recordedBy,/_join/1,
6 6 
Collection_Team,recordedBy,/_join/2,
7 7 
Collection_Number,collectorNumber,,
......
27 27 
Country_Name,country,,
28 28 
Region_Name,stateProvince,,
29 29 
Subregion_Name,county,,
30 
Closest_Town,UNUSED,,
30 
Closest_Town,UNUSED#Closest_Town,,
31 31 
Research_Site_Name,*Research_Site_Name,,
32 32 
Project_Name,projectName,,
33 33 
Locality_Summary,locality,/_join/1,
......
49 49 
Elevation_Min,minimumElevationInMeters,,Assuming units based on the range and precision of values
50 50 
Elevation_Max,maximumElevationInMeters,,Assuming units based on the range and precision of values
51 51 
Basis_Of_Specimen,basisOfRecord,,
52 
Auxilirary_Collections,UNUSED,,
52 
Auxilirary_Collections,UNUSED#Auxilirary_Collections,,
53 53 
Collection_Method,samplingProtocol,,
54 
Dubpliate_Herbarium,UNUSED,,
54 
Dubpliate_Herbarium,UNUSED#Dubpliate_Herbarium,,
55 55 
Duplicates,*Duplicates,,# of duplicates
56 
Type_Specimen,UNUSED,,
56 
Type_Specimen,UNUSED#Type_Specimen,,
57 57 
Updated_date,modified,,
58 58 
Determined_By_Name,identifiedBy,,
59 59 
Determined_By_Date,dateIdentified,,
inputs/BRIT/specimen_flat/VegBIEN.csv
92 92 
Subregion_Name,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/county/_first/2,
93 93 
Region_Name,/location/locationplace/*_id/place/matched_place_id/place:[source_id/source/shortname=geoscrub]/stateprovince/_first/2,
94 94 
Region_Name,/location/locationplace/*_id/place/stateprovince,
95 
Auxilirary_Collections,,** No non-empty join mapping for UNUSED **
95 
Auxilirary_Collections,,** No non-empty join mapping for UNUSED#Auxilirary_Collections **
96 96 
Basis_Of_Specimen,,** No join mapping for basisOfRecord **
97 
Closest_Town,,** No non-empty join mapping for UNUSED **
98 
Dubpliate_Herbarium,,** No non-empty join mapping for UNUSED **
97 
Closest_Town,,** No non-empty join mapping for UNUSED#Closest_Town **
98 
Dubpliate_Herbarium,,** No non-empty join mapping for UNUSED#Dubpliate_Herbarium **
99 99 
Duplicates,,** No join mapping for *Duplicates ** # of duplicates
100 
Global_Unique_Identifier,,** No non-empty join mapping for UNUSED **
100 
Global_Unique_Identifier,,** No non-empty join mapping for UNUSED#Global_Unique_Identifier **
101 101 
Infra_Rank,,** No join mapping for infraspecificRank **
102 102 
Local_Name,,** No join mapping for vernacularName **
103 103 
Research_Site_Name,,** No join mapping for *Research_Site_Name **
104 104 
Soil_Description,,** No join mapping for *Soil_Description **
105 105 
Subclass_Name,,** No join mapping for *subclass **
106 
Type_Specimen,,** No non-empty join mapping for UNUSED **
106 
Type_Specimen,,** No non-empty join mapping for UNUSED#Type_Specimen **
107 107 
Updated_date,,** No join mapping for modified **
inputs/SALVIAS/plotObservations/map.csv
29 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 
fam_status,OMIT,,Brad: OMIT. This will be determined later by using TNRS.
33 
gen_status,OMIT,,Brad: OMIT. This will be determined later by using TNRS.
34 
name_status,OMIT,,"Brad: OMIT. Except, note that if species_status=3, this indicate that name is a morphospecies and not a standard latin name. Not exactly sure how to use this in BIEN, but could be useful during the name-scrubbing process with TNRS."
32 
fam_status,OMIT#fam_status,,Brad: OMIT. This will be determined later by using TNRS.
33 
gen_status,OMIT#gen_status,,Brad: OMIT. This will be determined later by using TNRS.
34 
name_status,OMIT#name_status,,"Brad: OMIT. Except, note that if species_status=3, this indicate that name is a morphospecies and not a standard latin name. Not exactly sure how to use this in BIEN, but could be useful during the name-scrubbing process with TNRS."
35 35 
SpAuthStatus,*SpAuthStatus,,
36 36 
Family,family,,
37 37 
Genus,genus,,
inputs/SALVIAS/plotObservations/VegBIEN.csv
137 137 
collector_code,,** No join mapping for *collector_code ** Brad: OMIT
138 138 
common_name,,** No join mapping for vernacularName **
139 139 
dist,,** No join mapping for *dist **
140 
fam_status,,** No non-empty join mapping for OMIT ** Brad: OMIT. This will be determined later by using TNRS.
141 
gen_status,,** No non-empty join mapping for OMIT ** Brad: OMIT. This will be determined later by using TNRS.
140 
fam_status,,** No non-empty join mapping for OMIT#fam_status ** Brad: OMIT. This will be determined later by using TNRS.
141 
gen_status,,** No non-empty join mapping for OMIT#gen_status ** Brad: OMIT. This will be determined later by using TNRS.
142 142 
height_class,,** No join mapping for *height_class **
143 143 
height_m_commercial,,** No join mapping for *height_m_commercial **
144 144 
ind_id,,** No join mapping for *ind_id ** Brad: OMIT
145 145 
infra_auth_1,,** No join mapping for *infra_auth_1 **
146 146 
morphocf,,** No join mapping for *morphocf **
147 
name_status,,"** No non-empty join mapping for OMIT ** Brad: OMIT. Except, note that if species_status=3, this indicate that name is a morphospecies and not a standard latin name. Not exactly sure how to use this in BIEN, but could be useful during the name-scrubbing process with TNRS."
147 
name_status,,"** No non-empty join mapping for OMIT#name_status ** Brad: OMIT. Except, note that if species_status=3, this indicate that name is a morphospecies and not a standard latin name. Not exactly sure how to use this in BIEN, but could be useful during the name-scrubbing process with TNRS."
148 148 
other_annotations,,** No join mapping for *other_annotations **
149 149 
perp_dist,,** No join mapping for *perp_dist **
150 150 
species_code,,** No join mapping for *species_code **
inputs/SALVIAS/plotObservations/new_terms.csv
18 18 
coll_lastname,recordedBy_surName,,"Brad: This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick."
19 19 
coll_firstname,recordedBy_givenName,,Brad: See comment above
20 20 
det_by,identifiedBy,,
21 
fam_status,OMIT,,Brad: OMIT. This will be determined later by using TNRS.
22 
gen_status,OMIT,,Brad: OMIT. This will be determined later by using TNRS.
23 
name_status,OMIT,,"Brad: OMIT. Except, note that if species_status=3, this indicate that name is a morphospecies and not a standard latin name. Not exactly sure how to use this in BIEN, but could be useful during the name-scrubbing process with TNRS."
21 
fam_status,OMIT#fam_status,,Brad: OMIT. This will be determined later by using TNRS.
22 
gen_status,OMIT#gen_status,,Brad: OMIT. This will be determined later by using TNRS.
23 
name_status,OMIT#name_status,,"Brad: OMIT. Except, note that if species_status=3, this indicate that name is a morphospecies and not a standard latin name. Not exactly sure how to use this in BIEN, but could be useful during the name-scrubbing process with TNRS."
24 24 
auth,scientificNameAuthorship,,Brad: This is the author of the scientificName.
25 25 
infra_rank_1,taxonRank,,
26 26 
infra_ep_1,infraspecificEpithet,,
inputs/SALVIAS/plotMetadata_/map.csv
1 1 
SALVIAS,VegCore,Filter,Comments
2 
MethodCode,OMIT,,Not globally unique after lookup_MethodCode_Description is combined with PlotMethod
2 
MethodCode,OMIT#MethodCode,,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 5 
AccessCode,accessRights,"/_map:[1=private,2=""metadata only"",3=public]/value","3 plots contain 3 in this field and ""del"" in tmp_del"
inputs/SALVIAS/plotMetadata_/new_terms.csv
1 
MethodCode,OMIT,,Not globally unique after lookup_MethodCode_Description is combined with PlotMethod
1 
MethodCode,OMIT#MethodCode,,Not globally unique after lookup_MethodCode_Description is combined with PlotMethod
2 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,,
inputs/U/Specimen/VegBIEN.csv
58 58 
Alt,,** No join mapping for *Alt ** What is this?
59 59 
Alt2,,** No join mapping for *Alt2 ** What is this?
60 60 
Coorsyst,,** No join mapping for *Coorsyst **
61 
DateInfo,,** No non-empty join mapping for UNUSED **
61 
DateInfo,,** No non-empty join mapping for UNUSED#DateInfo **
62 62 
EW,,** No join mapping for *EW **
63 63 
Majorarea,,** No join mapping for *Majorarea **
64 64 
NS,,** No join mapping for *NS **
65 
Prefix,,** No non-empty join mapping for UNUSED **
66 
Suffix,,** No non-empty join mapping for UNUSED **
65 
Prefix,,** No non-empty join mapping for UNUSED#Prefix **
66 
Suffix,,** No non-empty join mapping for UNUSED#Suffix **
67 67 
row_num,,** No join mapping for *row_num **
inputs/QFA/Specimen/VegBIEN.csv
90 90 
datasetID,,** No join mapping for datasetURL **
91 91 
datasetName,,** No join mapping for dataset **
92 92 
geodeticDatum,,** No join mapping for geodeticDatum **
93 
institutionID,,** No non-empty join mapping for UNUSED **
93 
institutionID,,** No non-empty join mapping for UNUSED#institutionID **
94 94 
language,,** No join mapping for language **
95 95 
nomenclaturalCode,,** No join mapping for nomenclaturalCode **
96 96 
ownerInstitutionCode,,** No join mapping for specimenOwner **
inputs/UBC/Specimen/VegBIEN.csv
95 95 
georeferenceSources,,** No join mapping for georeferenceSources **
96 96 
georeferencedBy,,** No join mapping for georeferencedBy **
97 97 
georeferencedDate,,** No join mapping for georeferencedDate **
98 
institutionID,,** No non-empty join mapping for UNUSED **
98 
institutionID,,** No non-empty join mapping for UNUSED#institutionID **
99 99 
language,,** No join mapping for language **
100 100 
modified,,** No join mapping for modified **
101 101 
nomenclaturalCode,,** No join mapping for nomenclaturalCode **
inputs/bien_web/observation/map.csv
51 51 
traitValue,measurementValue,,
52 52 
traitUnit,*traitUnit,,
53 53 
traitMethod,*traitMethod,,
54 
observationID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
55 
dataSourceID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
56 
dataSourceName_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
57 
dataSourceNamePrimary_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
58 
plotID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
59 
observationType_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
60 
bien2_taxonomyID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
61 
bien2_DBPlotID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
62 
bien2_ObservationID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
63 
bien2_OccurID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
64 
taxonAuthorityVerbatim_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
65 
higherPlantGroup_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
66 
family_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
67 
genus_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
68 
species_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
69 
taxon_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
70 
taxonAuthor_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
71 
taxonMorphospecies_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
72 
rank_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
73 
acceptance_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
74 
country_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
75 
stateProvince_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
76 
collector_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
77 
identifiedBy_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
78 
plotCode_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
79 
plotAreaHa_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
80 
plotMinDbh_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
81 
plotMethod_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
82 
isValidLatLong_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
83 
isGeovalid_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
84 
isNewWorld_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
85 
isCultivated_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
86 
isCultivatedReason_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
87 
bien2_TraitObservationID_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
88 
traitName_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
89 
traitMethod_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
90 
traitUnit_index,OMIT,,Placeholder column created by MySQL to PostgreSQL translation
54 
observationID_index,OMIT#observationID_index,,Placeholder column created by MySQL to PostgreSQL translation
55 
dataSourceID_index,OMIT#dataSourceID_index,,Placeholder column created by MySQL to PostgreSQL translation
56 
dataSourceName_index,OMIT#dataSourceName_index,,Placeholder column created by MySQL to PostgreSQL translation
57 
dataSourceNamePrimary_index,OMIT#dataSourceNamePrimary_index,,Placeholder column created by MySQL to PostgreSQL translation
58 
plotID_index,OMIT#plotID_index,,Placeholder column created by MySQL to PostgreSQL translation
59 
observationType_index,OMIT#observationType_index,,Placeholder column created by MySQL to PostgreSQL translation
60 
bien2_taxonomyID_index,OMIT#bien2_taxonomyID_index,,Placeholder column created by MySQL to PostgreSQL translation
61 
bien2_DBPlotID_index,OMIT#bien2_DBPlotID_index,,Placeholder column created by MySQL to PostgreSQL translation
62 
bien2_ObservationID_index,OMIT#bien2_ObservationID_index,,Placeholder column created by MySQL to PostgreSQL translation
63 
bien2_OccurID_index,OMIT#bien2_OccurID_index,,Placeholder column created by MySQL to PostgreSQL translation
64 
taxonAuthorityVerbatim_index,OMIT#taxonAuthorityVerbatim_index,,Placeholder column created by MySQL to PostgreSQL translation
65 
higherPlantGroup_index,OMIT#higherPlantGroup_index,,Placeholder column created by MySQL to PostgreSQL translation
66 
family_index,OMIT#family_index,,Placeholder column created by MySQL to PostgreSQL translation
67 
genus_index,OMIT#genus_index,,Placeholder column created by MySQL to PostgreSQL translation
68 
species_index,OMIT#species_index,,Placeholder column created by MySQL to PostgreSQL translation
69 
taxon_index,OMIT#taxon_index,,Placeholder column created by MySQL to PostgreSQL translation
70 
taxonAuthor_index,OMIT#taxonAuthor_index,,Placeholder column created by MySQL to PostgreSQL translation
71 
taxonMorphospecies_index,OMIT#taxonMorphospecies_index,,Placeholder column created by MySQL to PostgreSQL translation
72 
rank_index,OMIT#rank_index,,Placeholder column created by MySQL to PostgreSQL translation
73 
acceptance_index,OMIT#acceptance_index,,Placeholder column created by MySQL to PostgreSQL translation
74 
country_index,OMIT#country_index,,Placeholder column created by MySQL to PostgreSQL translation
75 
stateProvince_index,OMIT#stateProvince_index,,Placeholder column created by MySQL to PostgreSQL translation
76 
collector_index,OMIT#collector_index,,Placeholder column created by MySQL to PostgreSQL translation
77 
identifiedBy_index,OMIT#identifiedBy_index,,Placeholder column created by MySQL to PostgreSQL translation
78 
plotCode_index,OMIT#plotCode_index,,Placeholder column created by MySQL to PostgreSQL translation
79 
plotAreaHa_index,OMIT#plotAreaHa_index,,Placeholder column created by MySQL to PostgreSQL translation
80 
plotMinDbh_index,OMIT#plotMinDbh_index,,Placeholder column created by MySQL to PostgreSQL translation
81 
plotMethod_index,OMIT#plotMethod_index,,Placeholder column created by MySQL to PostgreSQL translation
82 
isValidLatLong_index,OMIT#isValidLatLong_index,,Placeholder column created by MySQL to PostgreSQL translation
83 
isGeovalid_index,OMIT#isGeovalid_index,,Placeholder column created by MySQL to PostgreSQL translation
84 
isNewWorld_index,OMIT#isNewWorld_index,,Placeholder column created by MySQL to PostgreSQL translation
85 
isCultivated_index,OMIT#isCultivated_index,,Placeholder column created by MySQL to PostgreSQL translation
86 
isCultivatedReason_index,OMIT#isCultivatedReason_index,,Placeholder column created by MySQL to PostgreSQL translation
87 
bien2_TraitObservationID_index,OMIT#bien2_TraitObservationID_index,,Placeholder column created by MySQL to PostgreSQL translation
88 
traitName_index,OMIT#traitName_index,,Placeholder column created by MySQL to PostgreSQL translation
89 
traitMethod_index,OMIT#traitMethod_index,,Placeholder column created by MySQL to PostgreSQL translation
90 
traitUnit_index,OMIT#traitUnit_index,,Placeholder column created by MySQL to PostgreSQL translation
inputs/NY/Ecatalog_all/map.csv
1 1 
NY,VegCore,Filter,Comments
2 
pkey,OMIT,,"CatalogNumber, etc. is a better pkey"
3 
key,OMIT,,"CatalogNumber, etc. is a better pkey"
2 
pkey,OMIT#pkey,,"CatalogNumber, etc. is a better pkey"
3 
key,OMIT#key,,"CatalogNumber, etc. is a better pkey"
4 4 
DateLastModified,modified,,
5 5 
InstitutionCode,specimenHolderInstitutions,,
6 6 
CollectionCode,collection,,
......
21 21 
MonthIdentified,monthIdentified,,
22 22 
DayIdentified,dayIdentified,,
23 23 
TypeStatus,typeStatus,,
24 
CollectorNumber,UNUSED,,
24 
CollectorNumber,UNUSED#CollectorNumber,,
25 25 
FieldNumber,collectorNumber,,Usage inconsistent with DwC definition
26 26 
Collector,recordedBy,,
27 27 
YearCollected,yearCollected,,
......
53 53 
PlantFungDescription,occurrenceRemarks,/_join/2,Contains the specimenDescription
54 54 
Substrate,locality,"/_join/2/_label[label=""substrate""]/value",
55 55 
Vegetation,locality,"/_join/3/_label[label=""vegetation""]/value",
56 
UniqueNYInternalRecordNumber,OMIT,,Sometimes duplicated. Omitted to avoid confusion since this is an internal-only ID.
56 
UniqueNYInternalRecordNumber,OMIT#UniqueNYInternalRecordNumber,,Sometimes duplicated. Omitted to avoid confusion since this is an internal-only ID.
inputs/Madidi/IndividualObservation/map.csv
22 22 
CollectorAbbrev,recordedBy,/_first/3,
23 23 
CurrentDet,scientificName,,
24 24 
CurrentDetRank,taxonRank,,
25 
CurrentDetFamily,OMIT,,"Omitted because includes *family* author, which TNRS can’t handle"
25 
CurrentDetFamily,OMIT#CurrentDetFamily,,"Omitted because includes *family* author, which TNRS can’t handle"
26 26 
CurrentDetQualifier,identificationQualifier,,
27 27 
RepresentativeSpecimenID,*RepresentativeSpecimenID,,
28 28 
RepresentativeSpecimenSeniorCollector,*RepresentativeSpecimenSeniorCollector,,
......
30 30 
RepresentativeSpecimenCollectorAbbreviation,*RepresentativeSpecimenCollectorAbbreviation,,
31 31 
FieldFamilyFullName,originalFamily,,
32 32 
FieldFamilyFullName,family,,
33 
FieldFamilyHTML,OMIT,,"Omitted because includes *family* author, which TNRS can’t handle"
33 
FieldFamilyHTML,OMIT#FieldFamilyHTML,,"Omitted because includes *family* author, which TNRS can’t handle"
34 34 
FieldNameFullName,originalTaxonName,,
35 35 
FieldNameAuthors,originalScientificNameAuthorship,,
36 
FieldNameHTML,OMIT,,Adds HTML formatting to FieldNameFullName+FieldNameAuthors
36 
FieldNameHTML,OMIT#FieldNameHTML,,Adds HTML formatting to FieldNameFullName+FieldNameAuthors
37 37 
MorphoSpeciesName,morphoname,,
38 38 
CommonName,vernacularName,,
39 39 
Circumference,*Circumference,,
......
53 53 
TreeNotes,occurrenceRemarks,,
54 54 
DNASample,*DNASample,,
55 55 
IsAlive,*IsAlive,,
56 
CompoundLeaf,UNUSED,,
57 
CompoundLeafID,UNUSED,,
58 
NumberFolioles1,UNUSED,,
59 
NumberFolioles2,UNUSED,,
60 
NumberFolioles3,UNUSED,,
61 
NumberFolioles4,UNUSED,,
62 
NumberFolioles5,UNUSED,,
63 
SLAArea1,UNUSED,,
64 
SLAArea2,UNUSED,,
65 
SLAArea3,UNUSED,,
66 
SLAArea4,UNUSED,,
67 
SLAArea5,UNUSED,,
68 
SLAArea6,UNUSED,,
69 
SLAArea7,UNUSED,,
70 
SLAArea8,UNUSED,,
71 
SLAArea9,UNUSED,,
72 
SLAArea10,UNUSED,,
73 
SLAArea11,UNUSED,,
74 
SLAArea12,UNUSED,,
75 
SLAArea13,UNUSED,,
76 
SLAArea14,UNUSED,,
77 
SLAArea15,UNUSED,,
78 
NumberFoliolules1,UNUSED,,
79 
NumberFoliolules2,UNUSED,,
80 
NumberFoliolules3,UNUSED,,
81 
NumberFoliolules4,UNUSED,,
82 
NumberFoliolules5,UNUSED,,
83 
TotArea1,UNUSED,,
84 
TotArea2,UNUSED,,
85 
TotArea3,UNUSED,,
86 
TotArea4,UNUSED,,
87 
TotArea5,UNUSED,,
88 
TotArea6,UNUSED,,
89 
TotArea7,UNUSED,,
90 
TotArea8,UNUSED,,
91 
TotArea9,UNUSED,,
92 
TotArea10,UNUSED,,
93 
TotArea11,UNUSED,,
94 
TotArea12,UNUSED,,
95 
TotArea13,UNUSED,,
96 
TotArea14,UNUSED,,
97 
TotArea15,UNUSED,,
98 
Weight1,UNUSED,,
99 
Weight2,UNUSED,,
100 
Weight3,UNUSED,,
101 
Weight4,UNUSED,,
102 
Weight5,UNUSED,,
103 
Weight6,UNUSED,,
104 
Weight7,UNUSED,,
105 
Weight8,UNUSED,,
106 
Weight9,UNUSED,,
107 
Weight10,UNUSED,,
108 
Weight11,UNUSED,,
109 
Weight12,UNUSED,,
110 
Weight13,UNUSED,,
111 
Weight14,UNUSED,,
112 
Weight15,UNUSED,,
113 
Thickness1,UNUSED,,
114 
Thickness2,UNUSED,,
115 
Thickness3,UNUSED,,
116 
Thickness4,UNUSED,,
117 
Thickness5,UNUSED,,
118 
Thickness6,UNUSED,,
119 
Thickness7,UNUSED,,
120 
Thickness8,UNUSED,,
121 
Thickness9,UNUSED,,
122 
Thickness10,UNUSED,,
123 
Thickness11,UNUSED,,
124 
Thickness12,UNUSED,,
125 
Thickness13,UNUSED,,
126 
Thickness14,UNUSED,,
127 
Thickness15,UNUSED,,
128 
LeafPhoto1,UNUSED,,
129 
LeafPhoto2,UNUSED,,
130 
LeafPhoto3,UNUSED,,
131 
LeafPhoto4,UNUSED,,
132 
LeafPhoto5,UNUSED,,
133 
NitrogenContent,UNUSED,,
134 
TreeLeaf3Notes,UNUSED,,
135 
AreaRachis1,UNUSED,,
136 
AreaRachis2,UNUSED,,
137 
AreaRachis3,UNUSED,,
138 
AreaRachis4,UNUSED,,
139 
AreaRachis5,UNUSED,,
140 
WeightRachis1,UNUSED,,
141 
WeightRachis2,UNUSED,,
142 
WeightRachis3,UNUSED,,
143 
WeightRachis4,UNUSED,,
144 
WeightRachis5,UNUSED,,
145 
RachisPhoto1,UNUSED,,
146 
RachisPhoto2,UNUSED,,
147 
RachisPhoto3,UNUSED,,
148 
RachisPhoto4,UNUSED,,
149 
RachisPhoto5,UNUSED,,
150 
DiameterWithBark,UNUSED,,
151 
DiameterWithoutBark,UNUSED,,
152 
Volume1,UNUSED,,
153 
Volume2,UNUSED,,
154 
DryWeight,UNUSED,,
155 
VesselNumber,UNUSED,,
156 
VesselArea,UNUSED,,
157 
NumberOfLeaves,UNUSED,,
158 
WeightOfBranch,UNUSED,,
159 
AreaRachilla1,UNUSED,,
160 
AreaRachilla2,UNUSED,,
161 
AreaRachilla3,UNUSED,,
162 
AreaRachilla4,UNUSED,,
163 
AreaRachilla5,UNUSED,,
164 
WeightRachilla1,UNUSED,,
165 
WeightRachilla2,UNUSED,,
166 
WeightRachilla3,UNUSED,,
167 
WeightRachilla4,UNUSED,,
168 
WeightRachilla5,UNUSED,,
169 
TreeTrunkNotes,UNUSED,,
170 
RemainingTrunkHeight,UNUSED,,
171 
HeightButtresses,UNUSED,,
172 
WidthButtresses,UNUSED,,
173 
DirectionOfFall,UNUSED,,
174 
MortalityType,UNUSED,,
175 
CauseOfDeath1,UNUSED,,
176 
CauseOfDeath2,UNUSED,,
177 
CauseOfDeath3,UNUSED,,
178 
CauseOfDeath4,UNUSED,,
179 
CauseOfDeath5,UNUSED,,
180 
Decomposition,UNUSED,,
181 
MultipleFalls,UNUSED,,
182 
TreeMortalityNotes,UNUSED,,
56 
CompoundLeaf,UNUSED#CompoundLeaf,,
57 
CompoundLeafID,UNUSED#CompoundLeafID,,
58 
NumberFolioles1,UNUSED#NumberFolioles1,,
59 
NumberFolioles2,UNUSED#NumberFolioles2,,
60 
NumberFolioles3,UNUSED#NumberFolioles3,,
61 
NumberFolioles4,UNUSED#NumberFolioles4,,
62 
NumberFolioles5,UNUSED#NumberFolioles5,,
63 
SLAArea1,UNUSED#SLAArea1,,
64 
SLAArea2,UNUSED#SLAArea2,,
65 
SLAArea3,UNUSED#SLAArea3,,
66 
SLAArea4,UNUSED#SLAArea4,,
67 
SLAArea5,UNUSED#SLAArea5,,
68 
SLAArea6,UNUSED#SLAArea6,,
69 
SLAArea7,UNUSED#SLAArea7,,
70 
SLAArea8,UNUSED#SLAArea8,,
71 
SLAArea9,UNUSED#SLAArea9,,
72 
SLAArea10,UNUSED#SLAArea10,,
73 
SLAArea11,UNUSED#SLAArea11,,
74 
SLAArea12,UNUSED#SLAArea12,,
75 
SLAArea13,UNUSED#SLAArea13,,
76 
SLAArea14,UNUSED#SLAArea14,,
77 
SLAArea15,UNUSED#SLAArea15,,
78 
NumberFoliolules1,UNUSED#NumberFoliolules1,,
79 
NumberFoliolules2,UNUSED#NumberFoliolules2,,
80 
NumberFoliolules3,UNUSED#NumberFoliolules3,,
81 
NumberFoliolules4,UNUSED#NumberFoliolules4,,
82 
NumberFoliolules5,UNUSED#NumberFoliolules5,,
83 
TotArea1,UNUSED#TotArea1,,
84 
TotArea2,UNUSED#TotArea2,,
85 
TotArea3,UNUSED#TotArea3,,
86 
TotArea4,UNUSED#TotArea4,,
87 
TotArea5,UNUSED#TotArea5,,
88 
TotArea6,UNUSED#TotArea6,,
89 
TotArea7,UNUSED#TotArea7,,
90 
TotArea8,UNUSED#TotArea8,,
91 
TotArea9,UNUSED#TotArea9,,
92 
TotArea10,UNUSED#TotArea10,,
93 
TotArea11,UNUSED#TotArea11,,
94 
TotArea12,UNUSED#TotArea12,,
95 
TotArea13,UNUSED#TotArea13,,
96 
TotArea14,UNUSED#TotArea14,,
97 
TotArea15,UNUSED#TotArea15,,
98 
Weight1,UNUSED#Weight1,,
99 
Weight2,UNUSED#Weight2,,
100 
Weight3,UNUSED#Weight3,,
101 
Weight4,UNUSED#Weight4,,
102 
Weight5,UNUSED#Weight5,,
103 
Weight6,UNUSED#Weight6,,
104 
Weight7,UNUSED#Weight7,,
105 
Weight8,UNUSED#Weight8,,
106 
Weight9,UNUSED#Weight9,,
107 
Weight10,UNUSED#Weight10,,
108 
Weight11,UNUSED#Weight11,,
109 
Weight12,UNUSED#Weight12,,
110 
Weight13,UNUSED#Weight13,,
111 
Weight14,UNUSED#Weight14,,
112 
Weight15,UNUSED#Weight15,,
113 
Thickness1,UNUSED#Thickness1,,
114 
Thickness2,UNUSED#Thickness2,,
115 
Thickness3,UNUSED#Thickness3,,
116 
Thickness4,UNUSED#Thickness4,,
117 
Thickness5,UNUSED#Thickness5,,
118 
Thickness6,UNUSED#Thickness6,,
119 
Thickness7,UNUSED#Thickness7,,
120 
Thickness8,UNUSED#Thickness8,,
121 
Thickness9,UNUSED#Thickness9,,
122 
Thickness10,UNUSED#Thickness10,,
123 
Thickness11,UNUSED#Thickness11,,
124 
Thickness12,UNUSED#Thickness12,,
125 
Thickness13,UNUSED#Thickness13,,
126 
Thickness14,UNUSED#Thickness14,,
127 
Thickness15,UNUSED#Thickness15,,
128 
LeafPhoto1,UNUSED#LeafPhoto1,,
129 
LeafPhoto2,UNUSED#LeafPhoto2,,
130 
LeafPhoto3,UNUSED#LeafPhoto3,,
131 
LeafPhoto4,UNUSED#LeafPhoto4,,
132 
LeafPhoto5,UNUSED#LeafPhoto5,,
133 
NitrogenContent,UNUSED#NitrogenContent,,
134 
TreeLeaf3Notes,UNUSED#TreeLeaf3Notes,,
135 
AreaRachis1,UNUSED#AreaRachis1,,
136 
AreaRachis2,UNUSED#AreaRachis2,,
137 
AreaRachis3,UNUSED#AreaRachis3,,
138 
AreaRachis4,UNUSED#AreaRachis4,,
139 
AreaRachis5,UNUSED#AreaRachis5,,
140 
WeightRachis1,UNUSED#WeightRachis1,,
141 
WeightRachis2,UNUSED#WeightRachis2,,
142 
WeightRachis3,UNUSED#WeightRachis3,,
143 
WeightRachis4,UNUSED#WeightRachis4,,
144 
WeightRachis5,UNUSED#WeightRachis5,,
145 
RachisPhoto1,UNUSED#RachisPhoto1,,
146 
RachisPhoto2,UNUSED#RachisPhoto2,,
147 
RachisPhoto3,UNUSED#RachisPhoto3,,
148 
RachisPhoto4,UNUSED#RachisPhoto4,,
149 
RachisPhoto5,UNUSED#RachisPhoto5,,
150 
DiameterWithBark,UNUSED#DiameterWithBark,,
151 
DiameterWithoutBark,UNUSED#DiameterWithoutBark,,
152 
Volume1,UNUSED#Volume1,,
153 
Volume2,UNUSED#Volume2,,
154 
DryWeight,UNUSED#DryWeight,,
155 
VesselNumber,UNUSED#VesselNumber,,
156 
VesselArea,UNUSED#VesselArea,,
157 
NumberOfLeaves,UNUSED#NumberOfLeaves,,
158 
WeightOfBranch,UNUSED#WeightOfBranch,,
159 
AreaRachilla1,UNUSED#AreaRachilla1,,
160 
AreaRachilla2,UNUSED#AreaRachilla2,,
161 
AreaRachilla3,UNUSED#AreaRachilla3,,
162 
AreaRachilla4,UNUSED#AreaRachilla4,,
163 
AreaRachilla5,UNUSED#AreaRachilla5,,
164 
WeightRachilla1,UNUSED#WeightRachilla1,,
165 
WeightRachilla2,UNUSED#WeightRachilla2,,
166 
WeightRachilla3,UNUSED#WeightRachilla3,,
167 
WeightRachilla4,UNUSED#WeightRachilla4,,
168 
WeightRachilla5,UNUSED#WeightRachilla5,,
169 
TreeTrunkNotes,UNUSED#TreeTrunkNotes,,
170 
RemainingTrunkHeight,UNUSED#RemainingTrunkHeight,,
171 
HeightButtresses,UNUSED#HeightButtresses,,
172 
WidthButtresses,UNUSED#WidthButtresses,,
173 
DirectionOfFall,UNUSED#DirectionOfFall,,
174 
MortalityType,UNUSED#MortalityType,,
175 
CauseOfDeath1,UNUSED#CauseOfDeath1,,
176 
CauseOfDeath2,UNUSED#CauseOfDeath2,,
177 
CauseOfDeath3,UNUSED#CauseOfDeath3,,
178 
CauseOfDeath4,UNUSED#CauseOfDeath4,,
179 
CauseOfDeath5,UNUSED#CauseOfDeath5,,
180 
Decomposition,UNUSED#Decomposition,,
181 
MultipleFalls,UNUSED#MultipleFalls,,
182 
TreeMortalityNotes,UNUSED#TreeMortalityNotes,,
inputs/Madidi/map.csv
29 29 
CollectorStringShortened,recordedBy,/_first/2,
30 30 
Conductividad electrica (ASPT 6–µS/cm– 1 - 10000),conductivity,,
31 31 
CurrentDet,scientificName,,
32 
CurrentDetFamily,OMIT,,"Omitted because includes *family* author, which TNRS can’t handle"
32 
CurrentDetFamily,OMIT#CurrentDetFamily,,"Omitted because includes *family* author, which TNRS can’t handle"
33 33 
CurrentDetQualifier,identificationQualifier,,
34 34 
CurrentDetRank,taxonRank,,
35 35 
Determined by,identifiedBy,,
......
43 43 
Field family,originalFamily,,
44 44 
Field name,originalGenus,,Often = Genera
45 45 
FieldFamilyFullName,originalFamily,,
46 
FieldFamilyHTML,OMIT,,"Omitted because includes *family* author, which TNRS can’t handle"
46 
FieldFamilyHTML,OMIT#FieldFamilyHTML,,"Omitted because includes *family* author, which TNRS can’t handle"
47 47 
FieldNameAuthors,originalScientificNameAuthorship,,
48 48 
FieldNameFullName,originalTaxonName,,
49 
FieldNameHTML,OMIT,,Adds HTML formatting to FieldNameFullName+FieldNameAuthors
49 
FieldNameHTML,OMIT#FieldNameHTML,,Adds HTML formatting to FieldNameFullName+FieldNameAuthors
50 50 
First evaluation,eventDate,,
51 51 
Fósforo disponible (ISRIC 14-2–mg/Kg–1.5),phosphorus_percent,,Assuming units are % based on the range of values
52 52 
Genera,genus,,
inputs/CVS/stemCount_/VegBIEN.csv
32 32 
stemHeightAccuracy,,** No join mapping for *stemheightaccuracy **
33 33 
stemTaxonArea,,** No join mapping for *stemtaxonarea **
34 34 
stratum_ID,,** No join mapping for *stratum_id **
35 
taxonImportance_ID,,** No non-empty join mapping for OMIT ** Omitted because STEMCOUNT_ID is more specific
... This diff was truncated because it exceeds the maximum size that can be displayed.

Also available in: Unified diff