Project

General

Profile

« Previous | Next » 

Revision 4979

Added by Aaron Marcuse-Kubitza almost 12 years ago

inputs/*/*/map.csv: Prefix a * to every term that's not in Veg+ for easy identification of unmapped terms when editing map.csv. Note that canon will remove the * when it finds a matching Veg+ term.

View differences:

inputs/CTFS/Subplot/map.csv
4 4 
QuadratName,OMIT,,QuadratID is used for the same purpose
5 5 
StartX,subplotX,,
6 6 
StartY,subplotY,,
7 
DimX,DimX,,
8 
DimY,DimY,,
7 
DimX,*DimX,,
8 
DimY,*DimY,,
inputs/CTFS/PlotObservation/map.csv
4 4 
PlotCensusNumber,fieldNumber,,
5 5 
StartDate,startDate,,
6 6 
EndDate,endDate,,
7 
Description,Description,,
7 
Description,*Description,,
inputs/CTFS/TaxonOccurrence/map.csv
1 1 
CTFS,VegCore,Filter,Comments
2 
FamilyID,FamilyID,,
3 
GenusID,GenusID,,
4 
SpeciesID,SpeciesID,,
5 
SubSpeciesID,SubSpeciesID,,
2 
FamilyID,*FamilyID,,
3 
GenusID,*GenusID,,
4 
SpeciesID,*SpeciesID,,
5 
SubSpeciesID,*SubSpeciesID,,
6 6 
SpeciesInvID,taxonOccurrenceID,,
7 7 
CensusID,eventID,,
8 8 
PlotID,locationID,,
9 
SubSpeciesCurrentTaxonFlag,SubSpeciesCurrentTaxonFlag,,
10 
SubSpeciesObsoleteTaxonFlag,SubSpeciesObsoleteTaxonFlag,,
9 
SubSpeciesCurrentTaxonFlag,*SubSpeciesCurrentTaxonFlag,,
10 
SubSpeciesObsoleteTaxonFlag,*SubSpeciesObsoleteTaxonFlag,,
11 11 
SubSpeciesName,subspecies,,
12 
SubSpeciesMnemonic,SubSpeciesMnemonic,,
13 
SubSpeciesAuthority,SubSpeciesAuthority,,
12 
SubSpeciesMnemonic,*SubSpeciesMnemonic,,
13 
SubSpeciesAuthority,*SubSpeciesAuthority,,
14 14 
InfraSpecificLevel,UNUSED,,
15 
SpeciesCurrentTaxonFlag,SpeciesCurrentTaxonFlag,,
16 
SpeciesObsoleteTaxonFlag,SpeciesObsoleteTaxonFlag,,
17 
SpeciesReferenceID,SpeciesReferenceID,,
15 
SpeciesCurrentTaxonFlag,*SpeciesCurrentTaxonFlag,,
16 
SpeciesObsoleteTaxonFlag,*SpeciesObsoleteTaxonFlag,,
17 
SpeciesReferenceID,*SpeciesReferenceID,,
18 18 
SpeciesName,specificEpithet,,
19 
SpeciesMnemonic,SpeciesMnemonic,,
20 
SpeciesAuthority,SpeciesAuthority,,
21 
IDLevel,IDLevel,,
22 
FieldFamily,FieldFamily,,
23 
Description,Description,,
19 
SpeciesMnemonic,*SpeciesMnemonic,,
20 
SpeciesAuthority,*SpeciesAuthority,,
21 
IDLevel,*IDLevel,,
22 
FieldFamily,*FieldFamily,,
23 
Description,*Description,,
24 24 
Genus,genus,,
25 
GenusReferenceID,GenusReferenceID,,
26 
GenusAuthority,GenusAuthority,,
25 
GenusReferenceID,*GenusReferenceID,,
26 
GenusAuthority,*GenusAuthority,,
27 27 
Family,family,,
28 
ReferenceID,ReferenceID,,
29 
row_num,row_num,,
28 
ReferenceID,*ReferenceID,,
29 
row_num,*row_num,,
inputs/CVS/Organism/map.csv
6 6 
locationAccuracy-m,coordinateUncertaintyInMeters,,
7 7 
publicLatitude,decimalLatitude,,
8 8 
publicLongitude,decimalLongitude,,
9 
confidentialityStatus,confidentialityStatus,,
9 
confidentialityStatus,*confidentialityStatus,,
10 10 
state,stateProvince,,
11 11 
county,county,,
12 12 
currentTaxonName sec Weakley 2006,scientificName,,
inputs/CVS/Organism/unmapped_terms.csv
1 
confidentialityStatus
1 
*confidentialityStatus
inputs/REMIB/Specimen/VegBIEN.csv
51 51 
country,/location/locationplace/*_id/placepath/country,
52 52 
county,/location/locationplace/*_id/placepath/county,
53 53 
state,/location/locationplace/*_id/placepath/stateprovince,
54 
lat_min,,** No join mapping for lat_min **
55 
lat_sec,,** No join mapping for lat_sec **
56 
long_min,,** No join mapping for long_min **
57 
long_sec,,** No join mapping for long_sec **
54 
lat_min,,** No join mapping for *lat_min **
55 
lat_sec,,** No join mapping for *lat_sec **
56 
long_min,,** No join mapping for *long_min **
57 
long_sec,,** No join mapping for *long_sec **
58 58 
preparation,,** No join mapping for preparations **
inputs/CTFS/StemObservation/map.csv
1 1 
CTFS,VegCore,Filter,Comments
2 
FamilyID,FamilyID,,
3 
GenusID,GenusID,,
4 
SpeciesID,SpeciesID,,
5 
SubSpeciesID,SubSpeciesID,,
6 
TreeID,TreeID,,
2 
FamilyID,*FamilyID,,
3 
GenusID,*GenusID,,
4 
SpeciesID,*SpeciesID,,
5 
SubSpeciesID,*SubSpeciesID,,
6 
TreeID,*TreeID,,
7 7 
StemID,authorStemCode,,
8 8 
MeasureID,individualID,,
9 9 
CensusID,eventID,,
10 10 
DBH,diameterBreastHeight_cm,,Assuming units based on the range and precision of values. Not documented in <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/CTFS/_src/ctfs-comments_worksheet.xls>.
11 
HOM,HOM,,
12 
PrimaryStem,PrimaryStem,,
13 
ExactDate,ExactDate,,
11 
HOM,*HOM,,
12 
PrimaryStem,*PrimaryStem,,
13 
ExactDate,*ExactDate,,
14 14 
StemTag,tag,,
15 
StemDescription,StemDescription,,
15 
StemDescription,*StemDescription,,
16 16 
QuadratID,subplot,,Not globally unique; unique only within Site
17 17 
PlotID,locationID,,
18 18 
Tag,tag,,
19 19 
x,organismX,,
20 20 
y,organismY,,
21 
SubSpeciesCurrentTaxonFlag,SubSpeciesCurrentTaxonFlag,,
22 
SubSpeciesObsoleteTaxonFlag,SubSpeciesObsoleteTaxonFlag,,
21 
SubSpeciesCurrentTaxonFlag,*SubSpeciesCurrentTaxonFlag,,
22 
SubSpeciesObsoleteTaxonFlag,*SubSpeciesObsoleteTaxonFlag,,
23 23 
SubSpeciesName,subspecies,,
24 
SubSpeciesMnemonic,SubSpeciesMnemonic,,
25 
SubSpeciesAuthority,SubSpeciesAuthority,,
26 
InfraSpecificLevel,InfraSpecificLevel,,
27 
SpeciesCurrentTaxonFlag,SpeciesCurrentTaxonFlag,,
28 
SpeciesObsoleteTaxonFlag,SpeciesObsoleteTaxonFlag,,
29 
SpeciesReferenceID,SpeciesReferenceID,,
24 
SubSpeciesMnemonic,*SubSpeciesMnemonic,,
25 
SubSpeciesAuthority,*SubSpeciesAuthority,,
26 
InfraSpecificLevel,*InfraSpecificLevel,,
27 
SpeciesCurrentTaxonFlag,*SpeciesCurrentTaxonFlag,,
28 
SpeciesObsoleteTaxonFlag,*SpeciesObsoleteTaxonFlag,,
29 
SpeciesReferenceID,*SpeciesReferenceID,,
30 30 
SpeciesName,specificEpithet,,
31 
SpeciesMnemonic,SpeciesMnemonic,,
31 
SpeciesMnemonic,*SpeciesMnemonic,,
32 32 
SpeciesAuthority,scientificNameAuthorship,,
33 
IDLevel,IDLevel,,
34 
FieldFamily,FieldFamily,,
35 
Description,Description,,
33 
IDLevel,*IDLevel,,
34 
FieldFamily,*FieldFamily,,
35 
Description,*Description,,
36 36 
Genus,genus,,
37 
GenusReferenceID,GenusReferenceID,,
38 
GenusAuthority,GenusAuthority,,
37 
GenusReferenceID,*GenusReferenceID,,
38 
GenusAuthority,*GenusAuthority,,
39 39 
Family,family,,
40 
ReferenceID,ReferenceID,,
41 
row_num,row_num,,
40 
ReferenceID,*ReferenceID,,
41 
row_num,*row_num,,
inputs/CTFS/StemObservation/unmapped_terms.csv
1 
FamilyID
2 
GenusID
3 
SpeciesID
4 
SubSpeciesID
5 
TreeID
6 
HOM
7 
PrimaryStem
8 
ExactDate
9 
StemDescription
10 
SubSpeciesCurrentTaxonFlag
11 
SubSpeciesObsoleteTaxonFlag
12 
SubSpeciesMnemonic
13 
SubSpeciesAuthority
14 
InfraSpecificLevel
15 
SpeciesCurrentTaxonFlag
16 
SpeciesObsoleteTaxonFlag
17 
SpeciesReferenceID
18 
SpeciesMnemonic
19 
IDLevel
20 
FieldFamily
21 
Description
22 
GenusReferenceID
23 
GenusAuthority
24 
ReferenceID
25 
row_num
1 
*FamilyID
2 
*GenusID
3 
*SpeciesID
4 
*SubSpeciesID
5 
*TreeID
6 
*HOM
7 
*PrimaryStem
8 
*ExactDate
9 
*StemDescription
10 
*SubSpeciesCurrentTaxonFlag
11 
*SubSpeciesObsoleteTaxonFlag
12 
*SubSpeciesMnemonic
13 
*SubSpeciesAuthority
14 
*InfraSpecificLevel
15 
*SpeciesCurrentTaxonFlag
16 
*SpeciesObsoleteTaxonFlag
17 
*SpeciesReferenceID
18 
*SpeciesMnemonic
19 
*IDLevel
20 
*FieldFamily
21 
*Description
22 
*GenusReferenceID
23 
*GenusAuthority
24 
*ReferenceID
25 
*row_num
inputs/CTFS/Subplot/unmapped_terms.csv
1 
DimX
2 
DimY
1 
*DimX
2 
*DimY
inputs/CTFS/PlotObservation/unmapped_terms.csv
1 
Description
1 
*Description
inputs/CTFS/TaxonOccurrence/unmapped_terms.csv
1 
FamilyID
2 
GenusID
3 
SpeciesID
4 
SubSpeciesID
5 
SubSpeciesCurrentTaxonFlag
6 
SubSpeciesObsoleteTaxonFlag
7 
SubSpeciesMnemonic
8 
SubSpeciesAuthority
9 
SpeciesCurrentTaxonFlag
10 
SpeciesObsoleteTaxonFlag
11 
SpeciesReferenceID
12 
SpeciesMnemonic
13 
SpeciesAuthority
14 
IDLevel
15 
FieldFamily
16 
Description
17 
GenusReferenceID
18 
GenusAuthority
19 
ReferenceID
20 
row_num
1 
*FamilyID
2 
*GenusID
3 
*SpeciesID
4 
*SubSpeciesID
5 
*SubSpeciesCurrentTaxonFlag
6 
*SubSpeciesObsoleteTaxonFlag
7 
*SubSpeciesMnemonic
8 
*SubSpeciesAuthority
9 
*SpeciesCurrentTaxonFlag
10 
*SpeciesObsoleteTaxonFlag
11 
*SpeciesReferenceID
12 
*SpeciesMnemonic
13 
*SpeciesAuthority
14 
*IDLevel
15 
*FieldFamily
16 
*Description
17 
*GenusReferenceID
18 
*GenusAuthority
19 
*ReferenceID
20 
*row_num
inputs/TEAM/VL/map.csv
6 6 
Species,specificEpithet,,
7 7 
Names of Collectors,recordedBy,,
8 8 
Diameter at 1.3m,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>)"
9 
Max Diameter,Max Diameter,,
10 
Max Diameter POM,Max Diameter POM,,
11 
Condition Codes,Condition Codes,,
12 
Location Codes,Location Codes,,
13 
Sampling Period,Sampling Period,,
14 
Comments,Comments,,
15 
Data Level,Data Level,,
16 
Sampling Unit Name,Sampling Unit Name,,
9 
Max Diameter,*Max Diameter,,
10 
Max Diameter POM,*Max Diameter POM,,
11 
Condition Codes,*Condition Codes,,
12 
Location Codes,*Location Codes,,
13 
Sampling Period,*Sampling Period,,
14 
Comments,*Comments,,
15 
Data Level,*Data Level,,
16 
Sampling Unit Name,*Sampling Unit Name,,
17 17 
Latitude,decimalLatitude,,
18 18 
Longitude,decimalLongitude,,
19 19 
Method,samplingProtocol,,
......
23 23 
Tree Number,tag,,
24 24 
Site Name,projectName,,
25 25 
1ha Plot Number,plotName,,
26 
Protocol Version,Protocol Version,,
27 
Data Set Creator Institution,Data Set Creator Institution,,
28 
Data Set Creator Scientist,Data Set Creator Scientist,,
29 
Data Set Contact,Data Set Contact,,
26 
Protocol Version,*Protocol Version,,
27 
Data Set Creator Institution,*Data Set Creator Institution,,
28 
Data Set Creator Scientist,*Data Set Creator Scientist,,
29 
Data Set Contact,*Data Set Contact,,
inputs/TEAM/VL/VegBIEN.csv
24 24 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
25 25 
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
26 26 
Names of Collectors,/location/locationevent/taxonoccurrence/verbatimcollectorname,
27 
Comments,,** No join mapping for Comments **
28 
Condition Codes,,** No join mapping for Condition Codes **
29 
Data Level,,** No join mapping for Data Level **
30 
Data Set Contact,,** No join mapping for Data Set Contact **
31 
Data Set Creator Institution,,** No join mapping for Data Set Creator Institution **
32 
Data Set Creator Scientist,,** No join mapping for Data Set Creator Scientist **
33 
Location Codes,,** No join mapping for Location Codes **
34 
Max Diameter,,** No join mapping for Max Diameter **
35 
Max Diameter POM,,** No join mapping for Max Diameter POM **
36 
Protocol Version,,** No join mapping for Protocol Version **
37 
Sampling Period,,** No join mapping for Sampling Period **
38 
Sampling Unit Name,,** No join mapping for Sampling Unit Name **
27 
Comments,,** No join mapping for *Comments **
28 
Condition Codes,,** No join mapping for *Condition Codes **
29 
Data Level,,** No join mapping for *Data Level **
30 
Data Set Contact,,** No join mapping for *Data Set Contact **
31 
Data Set Creator Institution,,** No join mapping for *Data Set Creator Institution **
32 
Data Set Creator Scientist,,** No join mapping for *Data Set Creator Scientist **
33 
Location Codes,,** No join mapping for *Location Codes **
34 
Max Diameter,,** No join mapping for *Max Diameter **
35 
Max Diameter POM,,** No join mapping for *Max Diameter POM **
36 
Protocol Version,,** No join mapping for *Protocol Version **
37 
Sampling Period,,** No join mapping for *Sampling Period **
38 
Sampling Unit Name,,** No join mapping for *Sampling Unit Name **
inputs/TEAM/VL/unmapped_terms.csv
1 
Max Diameter
2 
Max Diameter POM
3 
Condition Codes
4 
Location Codes
5 
Sampling Period
6 
Comments
7 
Data Level
8 
Sampling Unit Name
9 
Protocol Version
10 
Data Set Creator Institution
11 
Data Set Creator Scientist
12 
Data Set Contact
1 
*Max Diameter
2 
*Max Diameter POM
3 
*Condition Codes
4 
*Location Codes
5 
*Sampling Period
6 
*Comments
7 
*Data Level
8 
*Sampling Unit Name
9 
*Protocol Version
10 
*Data Set Creator Institution
11 
*Data Set Creator Scientist
12 
*Data Set Contact
inputs/TEAM/VT/map.csv
6 6 
Species,specificEpithet,,
7 7 
Names of Collectors,recordedBy,,
8 8 
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>)"
9 
POM Height,POM Height,,
10 
New Diameter,New Diameter,,
11 
New POM Height,New POM Height,,
12 
Condition Codes,Condition Codes,,
13 
Sampling Period,Sampling Period,,
14 
Comments,Comments,,
15 
Data Level,Data Level,,
16 
Sampling Unit Name,Sampling Unit Name,,
9 
POM Height,*POM Height,,
10 
New Diameter,*New Diameter,,
11 
New POM Height,*New POM Height,,
12 
Condition Codes,*Condition Codes,,
13 
Sampling Period,*Sampling Period,,
14 
Comments,*Comments,,
15 
Data Level,*Data Level,,
16 
Sampling Unit Name,*Sampling Unit Name,,
17 17 
Latitude,decimalLatitude,,
18 18 
Longitude,decimalLongitude,,
19 19 
Spatial Method,samplingProtocol,,
......
23 23 
Tree Number,tag,,
24 24 
Site Name,projectName,,
25 25 
1ha Plot Number,plotName,,
26 
Protocol Version,Protocol Version,,
27 
Data Set Creator Institution,Data Set Creator Institution,,
28 
Data Set Creator Scientist,Data Set Creator Scientist,,
29 
Data Set Contact,Data Set Contact,,
26 
Protocol Version,*Protocol Version,,
27 
Data Set Creator Institution,*Data Set Creator Institution,,
28 
Data Set Creator Scientist,*Data Set Creator Scientist,,
29 
Data Set Contact,*Data Set Contact,,
inputs/TEAM/VT/VegBIEN.csv
24 24 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
25 25 
Species,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
26 26 
Names of Collectors,/location/locationevent/taxonoccurrence/verbatimcollectorname,
27 
Comments,,** No join mapping for Comments **
28 
Condition Codes,,** No join mapping for Condition Codes **
29 
Data Level,,** No join mapping for Data Level **
30 
Data Set Contact,,** No join mapping for Data Set Contact **
31 
Data Set Creator Institution,,** No join mapping for Data Set Creator Institution **
32 
Data Set Creator Scientist,,** No join mapping for Data Set Creator Scientist **
33 
New Diameter,,** No join mapping for New Diameter **
34 
New POM Height,,** No join mapping for New POM Height **
35 
POM Height,,** No join mapping for POM Height **
36 
Protocol Version,,** No join mapping for Protocol Version **
37 
Sampling Period,,** No join mapping for Sampling Period **
38 
Sampling Unit Name,,** No join mapping for Sampling Unit Name **
27 
Comments,,** No join mapping for *Comments **
28 
Condition Codes,,** No join mapping for *Condition Codes **
29 
Data Level,,** No join mapping for *Data Level **
30 
Data Set Contact,,** No join mapping for *Data Set Contact **
31 
Data Set Creator Institution,,** No join mapping for *Data Set Creator Institution **
32 
Data Set Creator Scientist,,** No join mapping for *Data Set Creator Scientist **
33 
New Diameter,,** No join mapping for *New Diameter **
34 
New POM Height,,** No join mapping for *New POM Height **
35 
POM Height,,** No join mapping for *POM Height **
36 
Protocol Version,,** No join mapping for *Protocol Version **
37 
Sampling Period,,** No join mapping for *Sampling Period **
38 
Sampling Unit Name,,** No join mapping for *Sampling Unit Name **
inputs/TEAM/VT/unmapped_terms.csv
1 
POM Height
2 
New Diameter
3 
New POM Height
4 
Condition Codes
5 
Sampling Period
6 
Comments
7 
Data Level
8 
Sampling Unit Name
9 
Protocol Version
10 
Data Set Creator Institution
11 
Data Set Creator Scientist
12 
Data Set Contact
1 
*POM Height
2 
*New Diameter
3 
*New POM Height
4 
*Condition Codes
5 
*Sampling Period
6 
*Comments
7 
*Data Level
8 
*Sampling Unit Name
9 
*Protocol Version
10 
*Data Set Creator Institution
11 
*Data Set Creator Scientist
12 
*Data Set Contact
inputs/TEAM/TEAM_Sites/map.csv
1 1 
TEAM,VegCore,Filter,Comments
2 2 
Site Name,projectName,,
3 3 
Name,plotName,,
4 
1ha Plot Coordinate,1ha Plot Coordinate,,
4 
1ha Plot Coordinate,*1ha Plot Coordinate,,
5 5 
Longitude,decimalLongitude,,
6 6 
Latitude,decimalLatitude,,
7 7 
CollectionDate,eventDate,,
inputs/TEAM/TEAM_Sites/VegBIEN.csv
8 8 
CollectionDate,/location/locationevent/obsenddate/_*/date/_alt/2/_dateRangeEnd/value,
9 9 
CollectionDate,/location/locationevent/obsstartdate/_*/date/_alt/2/_dateRangeStart/value,
10 10 
Name,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/1/_first/2/_if[@name=""if is organism""]/cond/_exists",
11 
1ha Plot Coordinate,,** No join mapping for 1ha Plot Coordinate **
11 
1ha Plot Coordinate,,** No join mapping for *1ha Plot Coordinate **
inputs/TEAM/TEAM_Sites/unmapped_terms.csv
1 
1ha Plot Coordinate
1 
*1ha Plot Coordinate
inputs/Madidi/Organism/map.csv
1 1 
Madidi,VegCore,Filter,Comments
2 2 
Expedition,projectName,,
3 3 
Inventory name,plotName,,
4 
Number of inventory (general),Number of inventory (general),,
5 
Number of inventory (expedition),Number of inventory (expedition),,
6 
"Type Inventory (C, PP, TP)","Type Inventory (C, PP, TP)",,
4 
Number of inventory (general),*Number of inventory (general),,
5 
Number of inventory (expedition),*Number of inventory (expedition),,
6 
"Type Inventory (C, PP, TP)","*Type Inventory (C, PP, TP)",,
7 7 
Inventory code,locationID,,
8 8 
Tag number,tag,,
9 9 
Tree number,recordNumber,,
10 10 
Number of subplot,subplot,,
11 11 
Index collector,recordedBy,,
12 12 
Specimen,catalogNumber,,
13 
Similar specimen,Similar specimen,,
14 
Plot specimen,Plot specimen,,
15 
Expedition specimen,Expedition specimen,,
16 
Project specimen,Project specimen,,
13 
Similar specimen,*Similar specimen,,
14 
Plot specimen,*Plot specimen,,
15 
Expedition specimen,*Expedition specimen,,
16 
Project specimen,*Project specimen,,
17 17 
Field family,verbatimFamily,,
18 18 
Field name,verbatimGenus,,Often = Genera
19 19 
Family (revised),family,,
......
24 24 
Autor (revised),scientificNameAuthorship,,
25 25 
Determined by,identifiedBy,,
26 26 
Qualifier,identificationQualifier,,
27 
Common name,Common name,,
28 
Circumference,Circumference,,
27 
Common name,*Common name,,
28 
Circumference,*Circumference,,
29 29 
Diameter,diameterBreastHeight_cm,,Assuming units based on the range and precision of values
30 30 
Trunk,authorStemCode,,
31 31 
Total height,height,,
32 
Bole height,Bole height,,trunk height
32 
Bole height,*Bole height,,trunk height
33 33 
Habit,verbatimGrowthForm,,
34 
Phenology,Phenology,,
35 
Crown position,Crown position,,
36 
Crown shape,Crown shape,,
34 
Phenology,*Phenology,,
35 
Crown position,*Crown position,,
36 
Crown shape,*Crown shape,,
37 37 
Liana presence,lianaInfestation,,
38 
Basal area,Basal area,,"Would be basalDiameter, but need formula to translate"
38 
Basal area,*Basal area,,"Would be basalDiameter, but need formula to translate"
39 39 
Subplot X,organismX,,
40 40 
Subplot Y,organismY,,
41 
Plot X,Plot X,,
42 
Plot Y,Plot Y,,
41 
Plot X,*Plot X,,
42 
Plot Y,*Plot Y,,
43 43 
Observations,fieldNotes,,
inputs/Madidi/Organism/VegBIEN.csv
43 43 
Field name,/location/locationevent/taxonoccurrence/taxondetermination[isoriginal=true]/*_id/taxonpath/genus,Often = Genera
44 44 
Index collector,/location/locationevent/taxonoccurrence/verbatimcollectorname,
45 45 
Specimen,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then",
46 
Basal area,,"** No join mapping for Basal area ** Would be basalDiameter, but need formula to translate"
47 
Bole height,,** No join mapping for Bole height ** trunk height
48 
Circumference,,** No join mapping for Circumference **
49 
Common name,,** No join mapping for Common name **
50 
Crown position,,** No join mapping for Crown position **
51 
Crown shape,,** No join mapping for Crown shape **
52 
Expedition specimen,,** No join mapping for Expedition specimen **
53 
Number of inventory (expedition),,** No join mapping for Number of inventory (expedition) **
54 
Number of inventory (general),,** No join mapping for Number of inventory (general) **
55 
Phenology,,** No join mapping for Phenology **
56 
Plot X,,** No join mapping for Plot X **
57 
Plot Y,,** No join mapping for Plot Y **
58 
Plot specimen,,** No join mapping for Plot specimen **
59 
Project specimen,,** No join mapping for Project specimen **
60 
Similar specimen,,** No join mapping for Similar specimen **
61 
"Type Inventory (C, PP, TP)",,"** No join mapping for Type Inventory (C, PP, TP) ** "
46 
Basal area,,"** No join mapping for *Basal area ** Would be basalDiameter, but need formula to translate"
47 
Bole height,,** No join mapping for *Bole height ** trunk height
48 
Circumference,,** No join mapping for *Circumference **
49 
Common name,,** No join mapping for *Common name **
50 
Crown position,,** No join mapping for *Crown position **
51 
Crown shape,,** No join mapping for *Crown shape **
52 
Expedition specimen,,** No join mapping for *Expedition specimen **
53 
Number of inventory (expedition),,** No join mapping for *Number of inventory (expedition) **
54 
Number of inventory (general),,** No join mapping for *Number of inventory (general) **
55 
Phenology,,** No join mapping for *Phenology **
56 
Plot X,,** No join mapping for *Plot X **
57 
Plot Y,,** No join mapping for *Plot Y **
58 
Plot specimen,,** No join mapping for *Plot specimen **
59 
Project specimen,,** No join mapping for *Project specimen **
60 
Similar specimen,,** No join mapping for *Similar specimen **
61 
"Type Inventory (C, PP, TP)",,"** No join mapping for *Type Inventory (C, PP, TP) ** "
inputs/Madidi/Organism/unmapped_terms.csv
1 
Number of inventory (general)
2 
Number of inventory (expedition)
3 
"Type Inventory (C, PP, TP)"
4 
Similar specimen
5 
Plot specimen
6 
Expedition specimen
7 
Project specimen
8 
Common name
9 
Circumference
10 
Bole height
11 
Phenology
12 
Crown position
13 
Crown shape
14 
Basal area
15 
Plot X
16 
Plot Y
1 
*Number of inventory (general)
2 
*Number of inventory (expedition)
3 
"*Type Inventory (C, PP, TP)"
4 
*Similar specimen
5 
*Plot specimen
6 
*Expedition specimen
7 
*Project specimen
8 
*Common name
9 
*Circumference
10 
*Bole height
11 
*Phenology
12 
*Crown position
13 
*Crown shape
14 
*Basal area
15 
*Plot X
16 
*Plot Y
inputs/Madidi/Plot/map.csv
1 1 
Madidi,VegCore,Filter,Comments
2 
Inventory number,Inventory number,,Not globally unique
2 
Inventory number,*Inventory number,,Not globally unique
3 3 
Expedition number,projectID,,Consistent (globally unique) between PPM and PT data
4 4 
Expedition name,projectName,,Consistent (globally unique) between PPM and PT data
5 
Number of inventory (expedition),Number of inventory (expedition),,The number of the event within the project
5 
Number of inventory (expedition),*Number of inventory (expedition),,The number of the event within the project
6 6 
Inventory name,plotName,,
7 7 
Inventory code,locationID,,
8 8 
First evaluation,eventDate,,
9 
Installed and evaluated by,Installed and evaluated by,,"Need a way to store a verbatim list of people, or a function to parse it and insert it iteratively into party"
10 
Collaborators,Collaborators,,"Need a way to store a verbatim list of people, or a function to parse it and insert it iteratively into party"
11 
Related Epilocs,Related Epilocs,,"It appears to be a list of people, some with #s after them. It doesn't seem like the definition of Epiloc at <http://rithm.wikispaces.com/Tropicos.Epiloc>, which relates to individual specimens, not whole plots."
9 
Installed and evaluated by,*Installed and evaluated by,,"Need a way to store a verbatim list of people, or a function to parse it and insert it iteratively into party"
10 
Collaborators,*Collaborators,,"Need a way to store a verbatim list of people, or a function to parse it and insert it iteratively into party"
11 
Related Epilocs,*Related Epilocs,,"It appears to be a list of people, some with #s after them. It doesn't seem like the definition of Epiloc at <http://rithm.wikispaces.com/Tropicos.Epiloc>, which relates to individual specimens, not whole plots."
12 12 
Area,plotArea_ha,,"""0.1 ha transects"" (""Madidi Transects"" description in <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/BIEN2.datasources.xlsx>)"
13 
Number of stems,Number of stems,,Do we want to store this data?
14 
Number of trees,Number of trees,,Do we want to store this data?
15 
Coordinates,Coordinates,,Concatenation of Latitude (DMS) and Longitude (DMS)
13 
Number of stems,*Number of stems,,Do we want to store this data?
14 
Number of trees,*Number of trees,,Do we want to store this data?
15 
Coordinates,*Coordinates,,Concatenation of Latitude (DMS) and Longitude (DMS)
16 16 
Latitude,decimalLatitude,,
17 17 
Longitude,decimalLongitude,,
18 18 
Latitude (DMS),latitude_DMS,,
......
44 44 
Vegetation type,communityID,,
45 45 
Topographical situation,landform,,
46 46 
Slope,slopeGradient,,
47 
Soil sample,Soil sample,,Always empty
47 
Soil sample,*Soil sample,,Always empty
48 48 
pH acuoso (ISRIC 4–– 1 - 14),ph,,
49 49 
Conductividad electrica (ASPT 6–µS/cm– 1 - 10000),conductivity,,
50 50 
Nitrógeno total (ISRIC 6–%–0.0014),nitrogen_percent,,Assuming units are % based on the range of values
inputs/Madidi/Plot/VegBIEN.csv
102 102 
GROUP BY ""Minimum altitude"" , ""Locality""
103 103 
-----
104 104 
[2] This map shows both flat and mountainous regions: <https://maps.google.com/maps/ms?ie=UTF8&hl=en&t=h&msa=0&msid=103363035880599665829.00047e9cf84b87448387d&ll=-13.96448,-68.380065&spn=3.730927,4.669189&z=7>"
105 
Collaborators,,"** No join mapping for Collaborators ** Need a way to store a verbatim list of people, or a function to parse it and insert it iteratively into party"
106 
Coordinates,,** No join mapping for Coordinates ** Concatenation of Latitude (DMS) and Longitude (DMS)
107 
Installed and evaluated by,,"** No join mapping for Installed and evaluated by ** Need a way to store a verbatim list of people, or a function to parse it and insert it iteratively into party"
108 
Inventory number,,** No join mapping for Inventory number ** Not globally unique
109 
Number of inventory (expedition),,** No join mapping for Number of inventory (expedition) ** The number of the event within the project
110 
Number of stems,,** No join mapping for Number of stems ** Do we want to store this data?
111 
Number of trees,,** No join mapping for Number of trees ** Do we want to store this data?
112 
Related Epilocs,,"** No join mapping for Related Epilocs ** It appears to be a list of people, some with #s after them. It doesn't seem like the definition of Epiloc at <http://rithm.wikispaces.com/Tropicos.Epiloc>, which relates to individual specimens, not whole plots."
113 
Soil sample,,** No join mapping for Soil sample ** Always empty
105 
Collaborators,,"** No join mapping for *Collaborators ** Need a way to store a verbatim list of people, or a function to parse it and insert it iteratively into party"
106 
Coordinates,,** No join mapping for *Coordinates ** Concatenation of Latitude (DMS) and Longitude (DMS)
107 
Installed and evaluated by,,"** No join mapping for *Installed and evaluated by ** Need a way to store a verbatim list of people, or a function to parse it and insert it iteratively into party"
108 
Inventory number,,** No join mapping for *Inventory number ** Not globally unique
109 
Number of inventory (expedition),,** No join mapping for *Number of inventory (expedition) ** The number of the event within the project
110 
Number of stems,,** No join mapping for *Number of stems ** Do we want to store this data?
111 
Number of trees,,** No join mapping for *Number of trees ** Do we want to store this data?
112 
Related Epilocs,,"** No join mapping for *Related Epilocs ** It appears to be a list of people, some with #s after them. It doesn't seem like the definition of Epiloc at <http://rithm.wikispaces.com/Tropicos.Epiloc>, which relates to individual specimens, not whole plots."
113 
Soil sample,,** No join mapping for *Soil sample ** Always empty
inputs/Madidi/Plot/unmapped_terms.csv
1 
Inventory number
2 
Number of inventory (expedition)
3 
Installed and evaluated by
4 
Collaborators
5 
Related Epilocs
6 
Number of stems
7 
Number of trees
8 
Coordinates
9 
Soil sample
1 
*Inventory number
2 
*Number of inventory (expedition)
3 
*Installed and evaluated by
4 
*Collaborators
5 
*Related Epilocs
6 
*Number of stems
7 
*Number of trees
8 
*Coordinates
9 
*Soil sample
inputs/UNCC/Specimen/map.csv
43 43 
inorout,fieldNotes,"/_join/7/_label[label=""in or out""]/value",
44 44 
sheetno,associatedMedia,,?
45 45 
cultivated,cultivated,,Ignore other values
46 
filler,filler,,"Where used, same as family"
46 
filler,*filler,,"Where used, same as family"
inputs/UNCC/Specimen/VegBIEN.csv
59 59 
country,/location/locationplace/*_id/placepath/country,
60 60 
county,/location/locationplace/*_id/placepath/county,
61 61 
state,/location/locationplace/*_id/placepath/stateprovince,
62 
filler,,"** No join mapping for filler ** Where used, same as family"
62 
filler,,"** No join mapping for *filler ** Where used, same as family"
63 63 
flower,,"** No join mapping for reproductiveCondition/_map:[A=*,I=*,M=*]/value ** Main values are A, I, and M. What do they mean?"
64 64 
fruit,,"** No join mapping for reproductiveCondition/_map:[A=*,I=*,M=*]/value ** Main values are A, I, and M. What do they mean?"
65 65 
leaves,,"** No join mapping for reproductiveCondition/_map:[A=*,I=*,M=*]/value ** Main values are A, I, and M. What do they mean?"
inputs/UNCC/Specimen/unmapped_terms.csv
3 3 
reproductiveCondition
4 4 
reproductiveCondition
5 5 
associatedMedia
6 
filler
6 
*filler
inputs/ACAD/Specimen/map.csv
1 1 
ACAD,VegCore,Filter,Comments
2 
id,occurrenceID,,
3 
basisOfRecord,basisOfRecord,,
4 
identifiedBy,identifiedBy,,
5 
collectionID,collectionID,,
6 
class,class,,
7 
geodeticDatum,geodeticDatum,,
8 
reproductiveCondition,reproductiveCondition,,
9 
decimalLongitude,decimalLongitude,,
10 
institutionCode,institutionCode,,
11 
continent,continent,,
12 
recordedBy,recordedBy,,
13 
county,county,,
14 
order,order,,
15 
georeferenceSources,georeferenceSources,,
16 
language,dcterms:language,,
17 
georeferenceVerificationStatus,georeferenceVerificationStatus,,
18 
verbatimElevation,verbatimElevation,,
19 
locationRemarks,locationRemarks,,
20 
dateIdentified,dateIdentified,,
21 
verbatimDepth,verbatimDepth,,
22 
municipality,municipality,,
23 
infraspecificEpithet,infraspecificEpithet,,
24 
modified,dcterms:modified,,
25 
type,dcterms:type,,
26 
specificEpithet,specificEpithet,,
27 
identificationRemarks,identificationRemarks,,
28 
rightsHolder,dcterms:rightsHolder,,
29 
recordNumber,recordNumber,,
30 
eventDate,eventDate,,
31 
rights,dcterms:rights,,
32 
occurrenceRemarks,occurrenceRemarks,,
33 
habitat,habitat,,
34 
family,family,,
35 
stateProvince,stateProvince,,
36 
scientificNameAuthorship,scientificNameAuthorship,,
37 
scientificName,scientificName,,
38 
taxonRank,taxonRank,,
39 
phylum,phylum,,
40 
locality,locality,,
41 
kingdom,kingdom,,
42 
decimalLatitude,decimalLatitude,,
43 
genus,genus,,
44 
ownerInstitutionCode,ownerInstitutionCode,,
45 
collectionCode,collectionCode,,
46 
bibliographicCitation,dcterms:bibliographicCitation,,
47 
catalogNumber,catalogNumber,,
48 
country,country,,
49 
dynamicProperties,dynamicProperties,,
2 
id,*occurrenceID,,
3 
basisOfRecord,*basisOfRecord,,
4 
identifiedBy,*identifiedBy,,
5 
collectionID,*collectionID,,
6 
class,*class,,
7 
geodeticDatum,*geodeticDatum,,
8 
reproductiveCondition,*reproductiveCondition,,
9 
decimalLongitude,*decimalLongitude,,
10 
institutionCode,*institutionCode,,
11 
continent,*continent,,
12 
recordedBy,*recordedBy,,
13 
county,*county,,
14 
order,*order,,
15 
georeferenceSources,*georeferenceSources,,
16 
language,*dcterms:language,,
17 
georeferenceVerificationStatus,*georeferenceVerificationStatus,,
18 
verbatimElevation,*verbatimElevation,,
19 
locationRemarks,*locationRemarks,,
20 
dateIdentified,*dateIdentified,,
21 
verbatimDepth,*verbatimDepth,,
22 
municipality,*municipality,,
23 
infraspecificEpithet,*infraspecificEpithet,,
24 
modified,*dcterms:modified,,
25 
type,*dcterms:type,,
26 
specificEpithet,*specificEpithet,,
27 
identificationRemarks,*identificationRemarks,,
28 
rightsHolder,*dcterms:rightsHolder,,
29 
recordNumber,*recordNumber,,
30 
eventDate,*eventDate,,
31 
rights,*dcterms:rights,,
32 
occurrenceRemarks,*occurrenceRemarks,,
33 
habitat,*habitat,,
34 
family,*family,,
35 
stateProvince,*stateProvince,,
36 
scientificNameAuthorship,*scientificNameAuthorship,,
37 
scientificName,*scientificName,,
38 
taxonRank,*taxonRank,,
39 
phylum,*phylum,,
40 
locality,*locality,,
41 
kingdom,*kingdom,,
42 
decimalLatitude,*decimalLatitude,,
43 
genus,*genus,,
44 
ownerInstitutionCode,*ownerInstitutionCode,,
45 
collectionCode,*collectionCode,,
46 
bibliographicCitation,*dcterms:bibliographicCitation,,
47 
catalogNumber,*catalogNumber,,
48 
country,*country,,
49 
dynamicProperties,*dynamicProperties,,
inputs/SALVIAS-CSV/Organism/map.csv
13 13 
-----"
14 14 
subplot,subplot,,
15 15 
individual_code,recordNumber,,"Brad: Code, if any, used by the data provider to indicate an individual tree. Scope is unknown, although typically this value is unique only within plot, or sometimes only within subplot."
16 
ind_id,ind_id,,Brad: OMIT
16 
ind_id,*ind_id,,Brad: OMIT
17 17 
tag1,tag,/_alt/2/_alt/2,"The second tag supercedes the first. The stem tag supercedes the tree tag. Brad: Another type of code, typically a number, used by the original data provider to indicate an individual tree. These are numbers on physical tags attached to the tree. Tag2 Is the same thing, only used if the first tag was lost. Obviously not a good system as it's possible a tree tag could be lost and changed more than once."
18 18 
tag2,tag,/_alt/2/_alt/1,"The second tag supercedes the first. The stem tag supercedes the tree tag. Brad: See commend for tag1. Your mapping for tag2 looks correct. Probably both values would go here, only nested, with one superceding the other."
19 19 
x_position,organismX,,"Brad: These are important, fundamental values of many tree plots"
20 20 
y_position,organismY,,Brad: See comment above for x_position
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 
collector_code,collector_code,,Brad: OMIT
23 
collector_code,*collector_code,,Brad: OMIT
24 24 
coll_lastname,recordedBy.surName,,"Brad: This is the collector of a separate specimen which vouchers this tree or species. I worry that vouchers are not properly accommodated in VegX. Again, we need to check with Nick."
25 25 
coll_firstname,recordedBy.givenName,,Brad: See comment above
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 
fam_status,fam_status,,Brad: OMIT. This will be determined later by using TNRS.
28 
gen_status,gen_status,,Brad: OMIT. This will be determined later by using TNRS.
29 
species_status,species_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."
27 
fam_status,*fam_status,,Brad: OMIT. This will be determined later by using TNRS.
28 
gen_status,*gen_status,,Brad: OMIT. This will be determined later by using TNRS.
29 
species_status,*species_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."
30 30 
family,family,,
31 31 
genus,genus,,
32 32 
specific_epithet,specificEpithet,,
......
34 34 
infra_rank_1,taxonRank,,
35 35 
infra_ep_1,infraspecificEpithet,,
36 36 
cf_aff,identificationQualifier,,"Brad: Not sure where this goes. Indicator of identification uncertainty. 'cf.'=similar to the species listed, 'aff.'=related to the species list, but not the same. You'll need to check with Bob and with Nick where these go in VegX and VegBank."
37 
comments,comments,,Brad: OMIT
37 
comments,*comments,,Brad: OMIT
38 38 
habit,verbatimGrowthForm,,"Brad: This is growth form (tree, shrub, herb, etc.). It is an observation of a trait."
39 39 
no_of_individuals,individualCount,,"Brad: This is a count of number of indiiduals for an *aggregate* observation. For VegBank, I'm not sure. Not exactly the same as stemCount. An individual tree could have 3 stems but would still only count as 1. We need to check with Bob on this."
40 40 
cover_percent,coverPercent,,
inputs/SALVIAS-CSV/Organism/VegBIEN.csv
78 78 
det_type,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/cond/_eq:[right=indirect]/left","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."
79 79 
coll_number,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then/_alt/1",Brad: Map instead as for voucher_string
80 80 
voucher_string,"/location/locationevent/taxonoccurrence/voucher/*_id/specimenreplicate/catalognumber_dwc/_if[@name=""if indirect voucher""]/then/_alt/2","Brad: OMIT. This is the verbatim text, which includes both collectors name and collection number. I would use coll_number, below."
81 
collector_code,,** No join mapping for collector_code ** Brad: OMIT
82 
comments,,** No join mapping for comments ** Brad: OMIT
83 
fam_status,,** No join mapping for fam_status ** Brad: OMIT. This will be determined later by using TNRS.
84 
gen_status,,** No join mapping for gen_status ** Brad: OMIT. This will be determined later by using TNRS.
85 
ind_id,,** No join mapping for ind_id ** Brad: OMIT
86 
species_status,,"** No join mapping for species_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."
81 
collector_code,,** No join mapping for *collector_code ** Brad: OMIT
82 
comments,,** No join mapping for *comments ** Brad: OMIT
83 
fam_status,,** No join mapping for *fam_status ** Brad: OMIT. This will be determined later by using TNRS.
84 
gen_status,,** No join mapping for *gen_status ** Brad: OMIT. This will be determined later by using TNRS.
85 
ind_id,,** No join mapping for *ind_id ** Brad: OMIT
86 
species_status,,"** No join mapping for *species_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."
inputs/SALVIAS-CSV/Organism/unmapped_terms.csv
1 
ind_id
2 
collector_code
3 
fam_status
4 
gen_status
5 
species_status
6 
comments
1 
*ind_id
2 
*collector_code
3 
*fam_status
4 
*gen_status
5 
*species_status
6 
*comments
inputs/SALVIAS-CSV/Plot/map.csv
35 35 
soil_texture,texture,,
36 36 
holdridge_life_zone,communityID,,
37 37 
life_zone_code,communityName,,
38 
observation_type,observation_type,,"Brad: SALVIAS internal metadata indicating whether the record represents an individual or aggregate observation. Rather than storing, use to decide where to store in VegX.; Aaron: VegX aggregateOrganismObservation table is missing many fields available in individualOrganismObservation, so we're mapping to individualOrganismObservation regardless of observation type"
38 
observation_type,*observation_type,,"Brad: SALVIAS internal metadata indicating whether the record represents an individual or aggregate observation. Rather than storing, use to decide where to store in VegX.; Aaron: VegX aggregateOrganismObservation table is missing many fields available in individualOrganismObservation, so we're mapping to individualOrganismObservation regardless of observation type"
39 39 
plot_methodology,samplingProtocol,,
40 40 
plot_area_ha,plotArea_ha,,"Brad: Area in hectares. Is there any way to store units?; Aaron: VegX plot area annotation says ""Total area of the plot in square meters."" so units are fixed"
41 
recensused,recensused,,"Brad: This is a 0/1 value, internal to SALVIAS. 1 indicates that a  plot has >1 set of values, from different census events.; Aaron: Different censuses are distinguished in organisms data by different census_no values"
41 
recensused,*recensused,,"Brad: This is a 0/1 value, internal to SALVIAS. 1 indicates that a  plot has >1 set of values, from different census events.; Aaron: Different censuses are distinguished in organisms data by different census_no values"
42 42 
date_start,startDate,,
43 43 
date_finish,endDate,,
inputs/SALVIAS-CSV/Plot/VegBIEN.csv
46 46 
pol1,/location/locationplace/*_id/placepath/stateprovince,Brad: No; pol1=stateProvince
47 47 
slope_aspect,/location/slopeaspect_deg/_alt/1/_compass/value,
48 48 
slope_gradient,/location/slopegradient_fraction/_alt/1,
49 
observation_type,,"** No join mapping for observation_type ** Brad: SALVIAS internal metadata indicating whether the record represents an individual or aggregate observation. Rather than storing, use to decide where to store in VegX.; Aaron: VegX aggregateOrganismObservation table is missing many fields available in individualOrganismObservation, so we're mapping to individualOrganismObservation regardless of observation type"
50 
recensused,,"** No join mapping for recensused ** Brad: This is a 0/1 value, internal to SALVIAS. 1 indicates that a  plot has >1 set of values, from different census events.; Aaron: Different censuses are distinguished in organisms data by different census_no values"
49 
observation_type,,"** No join mapping for *observation_type ** Brad: SALVIAS internal metadata indicating whether the record represents an individual or aggregate observation. Rather than storing, use to decide where to store in VegX.; Aaron: VegX aggregateOrganismObservation table is missing many fields available in individualOrganismObservation, so we're mapping to individualOrganismObservation regardless of observation type"
50 
recensused,,"** No join mapping for *recensused ** Brad: This is a 0/1 value, internal to SALVIAS. 1 indicates that a  plot has >1 set of values, from different census events.; Aaron: Different censuses are distinguished in organisms data by different census_no values"
inputs/SALVIAS-CSV/Plot/unmapped_terms.csv
1 
observation_type
2 
recensused
1 
*observation_type
2 
*recensused
inputs/CVS/Organism/VegBIEN.csv
12 12 
currentTaxonName sec Weakley 2006,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/taxonomicname,
13 13 
county,/location/locationplace/*_id/placepath/county,
14 14 
state,/location/locationplace/*_id/placepath/stateprovince,
15 
confidentialityStatus,,** No join mapping for confidentialityStatus **
15 
confidentialityStatus,,** No join mapping for *confidentialityStatus **
16 16 
realLatitude,,** No non-empty join mapping for PRIVATE **
17 17 
realLongitude,,** No non-empty join mapping for PRIVATE **
inputs/REMIB/Specimen/map.csv
17 17 
county,county,,
18 18 
locality,locality,,
19 19 
long_deg,decimalLongitude,,
20 
long_min,long_min,,
21 
long_sec,long_sec,,
20 
long_min,*long_min,,
21 
long_sec,*long_sec,,
22 22 
lat_deg,decimalLatitude,,
23 
lat_min,lat_min,,
24 
lat_sec,lat_sec,,
23 
lat_min,*lat_min,,
24 
lat_sec,*lat_sec,,
25 25 
coll_day,dayCollected,,
26 26 
coll_month,monthCollected,,
27 27 
coll_year,yearCollected,,
inputs/REMIB/Specimen/unmapped_terms.csv
1 
long_min
2 
long_sec
3 
lat_min
4 
lat_sec
1 
*long_min
2 
*long_sec
3 
*lat_min
4 
*lat_sec
5 5 
preparations
inputs/CTFS/StemObservation/VegBIEN.csv
25 25 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
26 26 
SpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
27 27 
SubSpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/1,
28 
Description,,** No join mapping for Description **
29 
ExactDate,,** No join mapping for ExactDate **
30 
FamilyID,,** No join mapping for FamilyID **
31 
FieldFamily,,** No join mapping for FieldFamily **
32 
GenusAuthority,,** No join mapping for GenusAuthority **
33 
GenusID,,** No join mapping for GenusID **
34 
GenusReferenceID,,** No join mapping for GenusReferenceID **
35 
HOM,,** No join mapping for HOM **
36 
IDLevel,,** No join mapping for IDLevel **
37 
InfraSpecificLevel,,** No join mapping for InfraSpecificLevel **
38 
PrimaryStem,,** No join mapping for PrimaryStem **
39 
ReferenceID,,** No join mapping for ReferenceID **
40 
SpeciesCurrentTaxonFlag,,** No join mapping for SpeciesCurrentTaxonFlag **
41 
SpeciesID,,** No join mapping for SpeciesID **
42 
SpeciesMnemonic,,** No join mapping for SpeciesMnemonic **
43 
SpeciesObsoleteTaxonFlag,,** No join mapping for SpeciesObsoleteTaxonFlag **
44 
SpeciesReferenceID,,** No join mapping for SpeciesReferenceID **
45 
StemDescription,,** No join mapping for StemDescription **
46 
SubSpeciesAuthority,,** No join mapping for SubSpeciesAuthority **
47 
SubSpeciesCurrentTaxonFlag,,** No join mapping for SubSpeciesCurrentTaxonFlag **
48 
SubSpeciesID,,** No join mapping for SubSpeciesID **
49 
SubSpeciesMnemonic,,** No join mapping for SubSpeciesMnemonic **
50 
SubSpeciesObsoleteTaxonFlag,,** No join mapping for SubSpeciesObsoleteTaxonFlag **
51 
TreeID,,** No join mapping for TreeID **
52 
row_num,,** No join mapping for row_num **
28 
Description,,** No join mapping for *Description **
29 
ExactDate,,** No join mapping for *ExactDate **
30 
FamilyID,,** No join mapping for *FamilyID **
31 
FieldFamily,,** No join mapping for *FieldFamily **
32 
GenusAuthority,,** No join mapping for *GenusAuthority **
33 
GenusID,,** No join mapping for *GenusID **
34 
GenusReferenceID,,** No join mapping for *GenusReferenceID **
35 
HOM,,** No join mapping for *HOM **
36 
IDLevel,,** No join mapping for *IDLevel **
37 
InfraSpecificLevel,,** No join mapping for *InfraSpecificLevel **
38 
PrimaryStem,,** No join mapping for *PrimaryStem **
39 
ReferenceID,,** No join mapping for *ReferenceID **
40 
SpeciesCurrentTaxonFlag,,** No join mapping for *SpeciesCurrentTaxonFlag **
41 
SpeciesID,,** No join mapping for *SpeciesID **
42 
SpeciesMnemonic,,** No join mapping for *SpeciesMnemonic **
43 
SpeciesObsoleteTaxonFlag,,** No join mapping for *SpeciesObsoleteTaxonFlag **
44 
SpeciesReferenceID,,** No join mapping for *SpeciesReferenceID **
45 
StemDescription,,** No join mapping for *StemDescription **
46 
SubSpeciesAuthority,,** No join mapping for *SubSpeciesAuthority **
47 
SubSpeciesCurrentTaxonFlag,,** No join mapping for *SubSpeciesCurrentTaxonFlag **
48 
SubSpeciesID,,** No join mapping for *SubSpeciesID **
49 
SubSpeciesMnemonic,,** No join mapping for *SubSpeciesMnemonic **
50 
SubSpeciesObsoleteTaxonFlag,,** No join mapping for *SubSpeciesObsoleteTaxonFlag **
51 
TreeID,,** No join mapping for *TreeID **
52 
row_num,,** No join mapping for *row_num **
inputs/CTFS/Subplot/VegBIEN.csv
9 9 
PlotID,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/1/_first/2/_if[@name=""if is organism""]/cond/_exists",
10 10 
StartX,/location/sublocationxposition_m,
11 11 
StartY,/location/sublocationyposition_m,
12 
DimX,,** No join mapping for DimX **
13 
DimY,,** No join mapping for DimY **
12 
DimX,,** No join mapping for *DimX **
13 
DimY,,** No join mapping for *DimY **
14 14 
QuadratName,,** No non-empty join mapping for OMIT ** QuadratID is used for the same purpose
inputs/CTFS/PlotObservation/VegBIEN.csv
13 13 
EndDate,/location/locationevent/obsenddate/_*/date/_alt/1,
14 14 
StartDate,/location/locationevent/obsstartdate/_*/date/_alt/1,
15 15 
PlotID,"/location/locationevent/taxonoccurrence/authortaxoncode/_first/1/_first/2/_if[@name=""if is organism""]/cond/_exists",
16 
Description,,** No join mapping for Description **
16 
Description,,** No join mapping for *Description **
inputs/CTFS/TaxonOccurrence/VegBIEN.csv
12 12 
Genus,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/genus,
13 13 
SpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
14 14 
SubSpeciesName,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/subspecies/_alt/1,
15 
Description,,** No join mapping for Description **
16 
FamilyID,,** No join mapping for FamilyID **
17 
FieldFamily,,** No join mapping for FieldFamily **
18 
GenusAuthority,,** No join mapping for GenusAuthority **
19 
GenusID,,** No join mapping for GenusID **
20 
GenusReferenceID,,** No join mapping for GenusReferenceID **
21 
IDLevel,,** No join mapping for IDLevel **
15 
Description,,** No join mapping for *Description **
16 
FamilyID,,** No join mapping for *FamilyID **
17 
FieldFamily,,** No join mapping for *FieldFamily **
18 
GenusAuthority,,** No join mapping for *GenusAuthority **
19 
GenusID,,** No join mapping for *GenusID **
20 
GenusReferenceID,,** No join mapping for *GenusReferenceID **
21 
IDLevel,,** No join mapping for *IDLevel **
22 22 
InfraSpecificLevel,,** No non-empty join mapping for UNUSED **
23 
ReferenceID,,** No join mapping for ReferenceID **
24 
SpeciesAuthority,,** No join mapping for SpeciesAuthority **
25 
SpeciesCurrentTaxonFlag,,** No join mapping for SpeciesCurrentTaxonFlag **
26 
SpeciesID,,** No join mapping for SpeciesID **
27 
SpeciesMnemonic,,** No join mapping for SpeciesMnemonic **
28 
SpeciesObsoleteTaxonFlag,,** No join mapping for SpeciesObsoleteTaxonFlag **
29 
SpeciesReferenceID,,** No join mapping for SpeciesReferenceID **
30 
SubSpeciesAuthority,,** No join mapping for SubSpeciesAuthority **
31 
SubSpeciesCurrentTaxonFlag,,** No join mapping for SubSpeciesCurrentTaxonFlag **
32 
SubSpeciesID,,** No join mapping for SubSpeciesID **
33 
SubSpeciesMnemonic,,** No join mapping for SubSpeciesMnemonic **
34 
SubSpeciesObsoleteTaxonFlag,,** No join mapping for SubSpeciesObsoleteTaxonFlag **
35 
row_num,,** No join mapping for row_num **
23 
ReferenceID,,** No join mapping for *ReferenceID **
24 
SpeciesAuthority,,** No join mapping for *SpeciesAuthority **
25 
SpeciesCurrentTaxonFlag,,** No join mapping for *SpeciesCurrentTaxonFlag **
26 
SpeciesID,,** No join mapping for *SpeciesID **
27 
SpeciesMnemonic,,** No join mapping for *SpeciesMnemonic **
28 
SpeciesObsoleteTaxonFlag,,** No join mapping for *SpeciesObsoleteTaxonFlag **
29 
SpeciesReferenceID,,** No join mapping for *SpeciesReferenceID **
30 
SubSpeciesAuthority,,** No join mapping for *SubSpeciesAuthority **
31 
SubSpeciesCurrentTaxonFlag,,** No join mapping for *SubSpeciesCurrentTaxonFlag **
32 
SubSpeciesID,,** No join mapping for *SubSpeciesID **
33 
SubSpeciesMnemonic,,** No join mapping for *SubSpeciesMnemonic **
34 
SubSpeciesObsoleteTaxonFlag,,** No join mapping for *SubSpeciesObsoleteTaxonFlag **
35 
row_num,,** No join mapping for *row_num **
inputs/VegBank/stemlocation/new_terms.csv
1 
stemlocation_id,stemID,,
2 
stemcount_id,individualID,,
3 
stemcode,authorStemCode,,
4 
stemxposition,organismX,,
5 
stemyposition,organismY,,
inputs/CTFS/Plot/map.csv
1 1 
CTFS,VegCore,Filter,Comments
2 
CountryID,CountryID,,
2 
CountryID,*CountryID,,
3 3 
PlotID,locationID,,
4 4 
PlotName,plotName,,
5 5 
LocationName,locality,,
......
14 14 
GROUP BY ""Elevation""::real , ""LocationName""
15 15 
ORDER BY ""Elevation""::real DESC
16 16 
-----"
17 
ReferenceX,ReferenceX,,Rarely used
18 
ReferenceY,ReferenceY,,Rarely used
17 
ReferenceX,*ReferenceX,,Rarely used
18 
ReferenceY,*ReferenceY,,Rarely used
19 19 
SizeOfSite,plotArea_ha,,"""Size in hectares"" (SizeOfSite comments in <https://projects.nceas.ucsb.edu/nceas/projects/bien/repository/raw/inputs/CTFS/_src/ctfs-comments_worksheet.xls>)"
20 20 
ShapeOfSite,footprintWKT,,
21 21 
DescriptionOfSite,locality,,
22 22 
CountryName,country,,
23 
row_num,row_num,,
23 
row_num,*row_num,,
inputs/FIA/Organism/VegBIEN.csv
18 18 
SpecificEpithet,/location/locationevent/taxonoccurrence/taxondetermination[!isoriginal]/*_id/taxonpath/species,
19 19 
County,/location/locationplace/*_id/placepath/county,
20 20 
StateProvince,/location/locationplace/*_id/placepath/stateprovince,
21 
HOM,,** No join mapping for HOM **
21 
HOM,,** No join mapping for *HOM **
inputs/FIA/Organism/map.csv
11 11 
StateProvince,stateProvince,,
12 12 
County,county,,
13 13 
DBH,diameterBreastHeight_in,,Assuming units based on the range and precision of values and location inside the U.S.
14 
HOM,HOM,,
14 
HOM,*HOM,,
15 15 
BasalDiameter,basalDiameter,,
16 16 
Height,height,,
inputs/SALVIAS/plotMetadata/VegBIEN.csv
48 48 
plot_notes,/location/notespublic,
49 49 
slope_aspect,/location/slopeaspect_deg/_alt/1/_compass/value,
50 50 
slope_gradient,/location/slopegradient_fraction/_alt/1,
51 
AccessCode,,** No join mapping for AccessCode **
52 
Country_index,,** No join mapping for Country_index **
53 
ElevSource,,** No join mapping for ElevSource **
54 
MethodCode,,** No join mapping for MethodCode **
55 
PrecipSource,,** No join mapping for PrecipSource **
56 
PrimOwnerID,,** No join mapping for PrimOwnerID **
57 
PrimOwnerID_index,,** No join mapping for PrimOwnerID_index **
58 
RevisionComments,,** No join mapping for RevisionComments **
59 
SiteName,,** No join mapping for SiteName **
60 
TempSource,,** No join mapping for TempSource **
61 
bearing,,** No join mapping for bearing **
62 
lat_long_accuracy,,** No join mapping for lat_long_accuracy **
63 
lat_string,,** No join mapping for lat_string **
64 
long_string,,** No join mapping for long_string **
65 
new_world,,** No join mapping for new_world **
66 
orig_filename,,** No join mapping for orig_filename **
67 
plot_administrator,,** No join mapping for plot_administrator **
68 
plot_administrator_index,,** No join mapping for plot_administrator_index **
69 
pol1_type,,** No join mapping for pol1_type **
70 
pol2_type,,** No join mapping for pol2_type **
71 
project_id_index,,** No join mapping for project_id_index **
72 
recensused,,"** No join mapping for recensused ** Brad: This is a 0/1 value, internal to SALVIAS. 1 indicates that a  plot has >1 set of values, from different census events.; Aaron: Different censuses are distinguished in organisms data by different census_no values"
73 
tmp_del,,** No join mapping for tmp_del **
74 
topography_desc,,** No join mapping for topography_desc **
75 
vegetation_1,,** No join mapping for vegetation_1 **
76 
vegetation_2,,** No join mapping for vegetation_2 **
51 
AccessCode,,** No join mapping for *AccessCode **
52 
Country_index,,** No join mapping for *Country_index **
53 
ElevSource,,** No join mapping for *ElevSource **
54 
MethodCode,,** No join mapping for *MethodCode **
55 
PrecipSource,,** No join mapping for *PrecipSource **
56 
PrimOwnerID,,** No join mapping for *PrimOwnerID **
57 
PrimOwnerID_index,,** No join mapping for *PrimOwnerID_index **
58 
RevisionComments,,** No join mapping for *RevisionComments **
59 
SiteName,,** No join mapping for *SiteName **
60 
TempSource,,** No join mapping for *TempSource **
61 
bearing,,** No join mapping for *bearing **
62 
lat_long_accuracy,,** No join mapping for *lat_long_accuracy **
63 
lat_string,,** No join mapping for *lat_string **
64 
long_string,,** No join mapping for *long_string **
65 
new_world,,** No join mapping for *new_world **
66 
orig_filename,,** No join mapping for *orig_filename **
67 
plot_administrator,,** No join mapping for *plot_administrator **
68 
plot_administrator_index,,** No join mapping for *plot_administrator_index **
69 
pol1_type,,** No join mapping for *pol1_type **
70 
pol2_type,,** No join mapping for *pol2_type **
71 
project_id_index,,** No join mapping for *project_id_index **
72 
recensused,,"** No join mapping for *recensused ** Brad: This is a 0/1 value, internal to SALVIAS. 1 indicates that a  plot has >1 set of values, from different census events.; Aaron: Different censuses are distinguished in organisms data by different census_no values"
73 
tmp_del,,** No join mapping for *tmp_del **
74 
topography_desc,,** No join mapping for *topography_desc **
75 
vegetation_1,,** No join mapping for *vegetation_1 **
76 
vegetation_2,,** No join mapping for *vegetation_2 **
inputs/CTFS/Plot/unmapped_terms.csv
1 
CountryID
2 
ReferenceX
3 
ReferenceY
4 
row_num
1 
*CountryID
2 
*ReferenceX
3 
*ReferenceY
4 
*row_num
inputs/SALVIAS/plotMetadata/map.csv
1 1 
SALVIAS,VegCore,Filter,Comments
2 2 
PlotID,locationID,,"Brad: This is artificial internal database ID; a unique identifier within SALVIAS DB to each plot, within the table plotMetadata."
3 
orig_filename,orig_filename,,
4 
AccessCode,AccessCode,,
3 
orig_filename,*orig_filename,,
4 
AccessCode,*AccessCode,,
5 5 
project_id,projectID,,
6 
PrimOwnerID,PrimOwnerID,,
6 
PrimOwnerID,*PrimOwnerID,,
7 7 
SiteCode,plotName,,Brad: plotCode is as-assigned by data provider; guranteed to be unique only within dataset (=project)
8 
SiteName,SiteName,,
9 
new_world,new_world,,
8 
SiteName,*SiteName,,
9 
new_world,*new_world,,
10 10 
MajorGeo,continent,,
11 11 
Country,country,,
12 12 
PolDiv1,stateProvince,,Brad: No; pol1=stateProvince
13 
pol1_type,pol1_type,,
13 
pol1_type,*pol1_type,,
14 14 
pol2,county,,Brad: No pol2=countyParish
15 
pol2_type,pol2_type,,
16 
lat_string,lat_string,,
17 
long_string,long_string,,
15 
pol2_type,*pol2_type,,
16 
lat_string,*lat_string,,
17 
long_string,*long_string,,
18 18 
LatDec,decimalLatitude,,
19 19 
LongDec,decimalLongitude,,
20 
lat_long_accuracy,lat_long_accuracy,,
20 
lat_long_accuracy,*lat_long_accuracy,,
21 21 
Elev,elevationInMeters,,Brad: Mean elevation in meters. This is a constrained decimal value; is there no place for this in VegX other than verbatimElevation? Check with Nick.
22 22 
elev_max_m,maximumElevationInMeters,,
23 23 
elev_min_m,minimumElevationInMeters,,
24 24 
Precip,precipitation,,
25 
ElevSource,ElevSource,,
25 
ElevSource,*ElevSource,,
26 26 
Temp,temperature,,
27 
PrecipSource,PrecipSource,,
28 
TempSource,TempSource,,
29 
bearing,bearing,,
27 
PrecipSource,*PrecipSource,,
28 
TempSource,*TempSource,,
29 
bearing,*bearing,,
30 30 
slope_aspect,slopeAspect,,
31 31 
slope_gradient,slopeGradient,,
32 32 
clay_percent,clay_percent,,
......
46 46 
soil_conductivity,conductivity,,
47 47 
organic_percent,organic_percent,,
48 48 
soil_texture,texture,,
49 
RevisionComments,RevisionComments,,
49 
RevisionComments,*RevisionComments,,
50 50 
Locality_Description,locality,,"Brad: No; this is free text description of locality where plot was situated, same as for DwC. Not a description of vegetation. Most likely='namedPlace.placeDescription' in VB; not sure about VX, again need to ask Nick where locality descriptions live in VX"
51 
topography_desc,topography_desc,,
52 
vegetation_1,vegetation_1,,
53 
vegetation_2,vegetation_2,,
51 
topography_desc,*topography_desc,,
52 
vegetation_1,*vegetation_1,,
53 
vegetation_2,*vegetation_2,,
54 54 
Habitat,habitat,,
55 55 
life_zone_code,communityID,,
56 56 
life_zone,communityName,,
57 57 
PlotMethod,samplingProtocol,,
58 
MethodCode,MethodCode,,
58 
MethodCode,*MethodCode,,
59 59 
plot_area_ha,plotArea_ha,,"Brad: Area in hectares. Is there any way to store units?; Aaron: VegX plot area annotation says ""Total area of the plot in square meters."" so units are fixed"
60 
recensused,recensused,,"Brad: This is a 0/1 value, internal to SALVIAS. 1 indicates that a  plot has >1 set of values, from different census events.; Aaron: Different censuses are distinguished in organisms data by different census_no values"
60 
recensused,*recensused,,"Brad: This is a 0/1 value, internal to SALVIAS. 1 indicates that a  plot has >1 set of values, from different census events.; Aaron: Different censuses are distinguished in organisms data by different census_no values"
61 61 
date_start,startDate,,
62 62 
date_finish,endDate,,
63 
plot_administrator,plot_administrator,,
63 
plot_administrator,*plot_administrator,,
64 64 
plot_notes,plotNotes,,
65 
tmp_del,tmp_del,,
66 
Country_index,Country_index,,
67 
PrimOwnerID_index,PrimOwnerID_index,,
68 
plot_administrator_index,plot_administrator_index,,
69 
project_id_index,project_id_index,,
65 
tmp_del,*tmp_del,,
66 
Country_index,*Country_index,,
67 
PrimOwnerID_index,*PrimOwnerID_index,,
68 
plot_administrator_index,*plot_administrator_index,,
69 
project_id_index,*project_id_index,,
inputs/CTFS/Plot/VegBIEN.csv
24 24 
DescriptionOfSite,/location/locationnarrative/_merge/1,
25 25 
LocationName,/location/locationnarrative/_merge/1,
26 26 
CountryName,/location/locationplace/*_id/placepath/country,
27 
CountryID,,** No join mapping for CountryID **
28 
ReferenceX,,** No join mapping for ReferenceX ** Rarely used
29 
ReferenceY,,** No join mapping for ReferenceY ** Rarely used
30 
row_num,,** No join mapping for row_num **
27 
CountryID,,** No join mapping for *CountryID **
28 
ReferenceX,,** No join mapping for *ReferenceX ** Rarely used
29 
ReferenceY,,** No join mapping for *ReferenceY ** Rarely used
30 
row_num,,** No join mapping for *row_num **
inputs/FIA/Organism/unmapped_terms.csv
1 
HOM
1 
*HOM
inputs/SALVIAS/plotMetadata/unmapped_terms.csv
1 
orig_filename
2 
AccessCode
3 
PrimOwnerID
4 
SiteName
5 
new_world
6 
pol1_type
7 
pol2_type
8 
lat_string
9 
long_string
10 
lat_long_accuracy
11 
ElevSource
12 
PrecipSource
13 
TempSource
14 
bearing
15 
RevisionComments
16 
topography_desc
17 
vegetation_1
18 
vegetation_2
19 
MethodCode
20 
recensused
21 
plot_administrator
22 
tmp_del
23 
Country_index
24 
PrimOwnerID_index
25 
plot_administrator_index
26 
project_id_index
1 
*orig_filename
2 
*AccessCode
3 
*PrimOwnerID
4 
*SiteName
5 
*new_world
6 
*pol1_type
7 
*pol2_type
8 
*lat_string
9 
*long_string
10 
*lat_long_accuracy
11 
*ElevSource
12 
*PrecipSource
13 
*TempSource
14 
*bearing
15 
*RevisionComments
16 
*topography_desc
17 
*vegetation_1
18 
*vegetation_2
19 
*MethodCode
20 
*recensused
21 
*plot_administrator
22 
*tmp_del
23 
*Country_index
24 
*PrimOwnerID_index
25 
*plot_administrator_index
26 
*project_id_index
inputs/SALVIAS/stems/map.csv
1 1 
SALVIAS,VegCore,Filter,Comments
2 2 
stem_id,stemID,,
3 
origrecord_id_stems,origrecord_id_stems,,
3 
origrecord_id_stems,*origrecord_id_stems,,
4 4 
PlotObsID,individualID,,
5 5 
NoInd,stemCount,,
6 6 
basal_diam,basalDiameter,,
......
14 14 
stem_canopy_form,canopyForm,,
15 15 
stem_canopy_position,canopyPosition,,
16 16 
stem_liana_infestation,lianaInfestation,,
17 
tmp_del,tmp_del,,
18 
plotobs_id_index,plotobs_id_index,,
17 
tmp_del,*tmp_del,,
18 
plotobs_id_index,*plotobs_id_index,,
... This diff was truncated because it exceeds the maximum size that can be displayed.

Also available in: Unified diff