Project

General

Profile

« Previous | Next » 

Revision 11754

inputs/CVS/: prepended the table name to each column name to prevent column collisions, using the steps at http://wiki.vegpath.org/Left-joining_a_datasource

View differences:

inputs/CVS/stemCount_/map.csv
1 1
CVS,VegCore,Filter,Comments
2 2
taxonImportance_ID,aggregateOrganismObservationID__taxon_presence,,
3 3
taxonObservation_ID,taxonOccurrenceID,,
4
stratum_ID,*stratum_id,,
4
stratum_ID,*stemCount_--stratum_id,,
5 5
cover,coverPercent,,
6
basalArea,*basalarea,,
7
biomass,*biomass,,
8
inferenceArea,*inferencearea,,
9
cust_cvs_StemFrequency,*cust_cvs_StemFrequency,,
10
taxonImportance_dba_src_ID,*taxonImportance_dba_src_ID,,
11
taxonImportance_entry_herbLineID,*taxonImportance_entry_herbLineID,,
12
taxonImportance_entry_treeLineID,*taxonImportance_entry_treeLineID,,
13
cust_cvs_corner1Presence,*cust_cvs_corner1Presence,,
14
cust_cvs_corner2Presence,*cust_cvs_corner2Presence,,
15
cust_cvs_corner3Presence,*cust_cvs_corner3Presence,,
16
cust_cvs_corner4Presence,*cust_cvs_corner4Presence,,
17
cust_cvs_corner5Presence,*cust_cvs_corner5Presence,,
18
cust_cvs_originalCoverCode,*cust_cvs_originalCoverCode,,
6
basalArea,*stemCount_--basalarea,,
7
biomass,*stemCount_--biomass,,
8
inferenceArea,*stemCount_--inferencearea,,
9
cust_cvs_StemFrequency,*stemCount_--cust_cvs_StemFrequency,,
10
taxonImportance_dba_src_ID,*stemCount_--taxonImportance_dba_src_ID,,
11
taxonImportance_entry_herbLineID,*stemCount_--taxonImportance_entry_herbLineID,,
12
taxonImportance_entry_treeLineID,*stemCount_--taxonImportance_entry_treeLineID,,
13
cust_cvs_corner1Presence,*stemCount_--cust_cvs_corner1Presence,,
14
cust_cvs_corner2Presence,*stemCount_--cust_cvs_corner2Presence,,
15
cust_cvs_corner3Presence,*stemCount_--cust_cvs_corner3Presence,,
16
cust_cvs_corner4Presence,*stemCount_--cust_cvs_corner4Presence,,
17
cust_cvs_corner5Presence,*stemCount_--cust_cvs_corner5Presence,,
18
cust_cvs_originalCoverCode,*stemCount_--cust_cvs_originalCoverCode,,
19 19
STEMCOUNT_ID,aggregateOrganismObservationID__individual_count,,
20 20
stemDiameter,diameterBreastHeight_cm,,
21
stemDiameterAccuracy,*stemdiameteraccuracy,,
21
stemDiameterAccuracy,*stemCount_--stemdiameteraccuracy,,
22 22
stemHeight,height_m,,
23
stemHeightAccuracy,*stemheightaccuracy,,
23
stemHeightAccuracy,*stemCount_--stemheightaccuracy,,
24 24
stemCount,individualCount,,
25
stemTaxonArea,*stemtaxonarea,,
26
stemCount_dba_src_ID,*stemCount_dba_src_ID,,
27
cust_cvs_ddh,*cust_cvs_ddh,,
28
cust_cvs_ddhAccuracy,*cust_cvs_ddhAccuracy,,
29
cust_cvs_isPlanted,*cust_cvs_isPlanted,,
30
cust_cvs_subsamplingFactor,*cust_cvs_subsamplingFactor,,
31
stemCount_entry_herbLineID,*stemCount_entry_herbLineID,,
32
stemCount_entry_treeLineID,*stemCount_entry_treeLineID,,
33
entry_recordCount,*entry_recordCount,,
34
entry_sortOrder,*entry_sortOrder,,
25
stemTaxonArea,*stemCount_--stemtaxonarea,,
26
stemCount_dba_src_ID,*stemCount_--stemCount_dba_src_ID,,
27
cust_cvs_ddh,*stemCount_--cust_cvs_ddh,,
28
cust_cvs_ddhAccuracy,*stemCount_--cust_cvs_ddhAccuracy,,
29
cust_cvs_isPlanted,*stemCount_--cust_cvs_isPlanted,,
30
cust_cvs_subsamplingFactor,*stemCount_--cust_cvs_subsamplingFactor,,
31
stemCount_entry_herbLineID,*stemCount_--stemCount_entry_herbLineID,,
32
stemCount_entry_treeLineID,*stemCount_--stemCount_entry_treeLineID,,
33
entry_recordCount,*stemCount_--entry_recordCount,,
34
entry_sortOrder,*stemCount_--entry_sortOrder,,
inputs/CVS/stemCount_/new_terms.csv
1 1
taxonImportance_ID,aggregateOrganismObservationID__taxon_presence,,
2
stratum_ID,*stemCount_--stratum_id,,
2 3
cover,coverPercent,,
4
basalArea,*stemCount_--basalarea,,
5
biomass,*stemCount_--biomass,,
6
inferenceArea,*stemCount_--inferencearea,,
7
cust_cvs_StemFrequency,*stemCount_--cust_cvs_StemFrequency,,
8
taxonImportance_dba_src_ID,*stemCount_--taxonImportance_dba_src_ID,,
9
taxonImportance_entry_herbLineID,*stemCount_--taxonImportance_entry_herbLineID,,
10
taxonImportance_entry_treeLineID,*stemCount_--taxonImportance_entry_treeLineID,,
11
cust_cvs_corner1Presence,*stemCount_--cust_cvs_corner1Presence,,
12
cust_cvs_corner2Presence,*stemCount_--cust_cvs_corner2Presence,,
13
cust_cvs_corner3Presence,*stemCount_--cust_cvs_corner3Presence,,
14
cust_cvs_corner4Presence,*stemCount_--cust_cvs_corner4Presence,,
15
cust_cvs_corner5Presence,*stemCount_--cust_cvs_corner5Presence,,
16
cust_cvs_originalCoverCode,*stemCount_--cust_cvs_originalCoverCode,,
3 17
STEMCOUNT_ID,aggregateOrganismObservationID__individual_count,,
4 18
stemDiameter,diameterBreastHeight_cm,,
19
stemDiameterAccuracy,*stemCount_--stemdiameteraccuracy,,
20
stemHeightAccuracy,*stemCount_--stemheightaccuracy,,
21
stemTaxonArea,*stemCount_--stemtaxonarea,,
22
stemCount_dba_src_ID,*stemCount_--stemCount_dba_src_ID,,
23
cust_cvs_ddh,*stemCount_--cust_cvs_ddh,,
24
cust_cvs_ddhAccuracy,*stemCount_--cust_cvs_ddhAccuracy,,
25
cust_cvs_isPlanted,*stemCount_--cust_cvs_isPlanted,,
26
cust_cvs_subsamplingFactor,*stemCount_--cust_cvs_subsamplingFactor,,
27
stemCount_entry_herbLineID,*stemCount_--stemCount_entry_herbLineID,,
28
stemCount_entry_treeLineID,*stemCount_--stemCount_entry_treeLineID,,
29
entry_recordCount,*stemCount_--entry_recordCount,,
30
entry_sortOrder,*stemCount_--entry_sortOrder,,
inputs/CVS/stemCount_/unmapped_terms.csv
1 1
aggregateOrganismObservationID__taxon_presence
2
*stratum_id
3
*basalarea
4
*biomass
5
*inferencearea
6
*cust_cvs_StemFrequency
7
*taxonImportance_dba_src_ID
8
*taxonImportance_entry_herbLineID
9
*taxonImportance_entry_treeLineID
10
*cust_cvs_corner1Presence
11
*cust_cvs_corner2Presence
12
*cust_cvs_corner3Presence
13
*cust_cvs_corner4Presence
14
*cust_cvs_corner5Presence
15
*cust_cvs_originalCoverCode
2
*stemCount_--stratum_id
3
*stemCount_--basalarea
4
*stemCount_--biomass
5
*stemCount_--inferencearea
6
*stemCount_--cust_cvs_StemFrequency
7
*stemCount_--taxonImportance_dba_src_ID
8
*stemCount_--taxonImportance_entry_herbLineID
9
*stemCount_--taxonImportance_entry_treeLineID
10
*stemCount_--cust_cvs_corner1Presence
11
*stemCount_--cust_cvs_corner2Presence
12
*stemCount_--cust_cvs_corner3Presence
13
*stemCount_--cust_cvs_corner4Presence
14
*stemCount_--cust_cvs_corner5Presence
15
*stemCount_--cust_cvs_originalCoverCode
16 16
aggregateOrganismObservationID__individual_count
17
*stemdiameteraccuracy
18
*stemheightaccuracy
19
*stemtaxonarea
20
*stemCount_dba_src_ID
21
*cust_cvs_ddh
22
*cust_cvs_ddhAccuracy
23
*cust_cvs_isPlanted
24
*cust_cvs_subsamplingFactor
25
*stemCount_entry_herbLineID
26
*stemCount_entry_treeLineID
27
*entry_recordCount
28
*entry_sortOrder
17
*stemCount_--stemdiameteraccuracy
18
*stemCount_--stemheightaccuracy
19
*stemCount_--stemtaxonarea
20
*stemCount_--stemCount_dba_src_ID
21
*stemCount_--cust_cvs_ddh
22
*stemCount_--cust_cvs_ddhAccuracy
23
*stemCount_--cust_cvs_isPlanted
24
*stemCount_--cust_cvs_subsamplingFactor
25
*stemCount_--stemCount_entry_herbLineID
26
*stemCount_--stemCount_entry_treeLineID
27
*stemCount_--entry_recordCount
28
*stemCount_--entry_sortOrder
inputs/CVS/plantConcept_/map.csv
1 1
CVS,VegCore,Filter,Comments
2 2
PLANTCONCEPT_ID,PLANTCONCEPT_ID,,
3
PLANTNAME_ID,*PLANTNAME_ID,,
4
plantConcept_reference_ID,*plantConcept_reference_ID,,
3
PLANTNAME_ID,*plantConcept_--PLANTNAME_ID,,
4
plantConcept_reference_ID,*plantConcept_--plantConcept_reference_ID,,
5 5
plantname,taxonName,,
6 6
plantNameWithAuthority,scientificName,,
7
plantCode,*plantCode,,
8
plantDescription,*plantDescription,,
9
plantConcept_accessionCode,*plantConcept_accessionCode,,
10
plantConcept_dba_src_ID,*plantConcept_dba_src_ID,,
11
plantConcept_entry_sppID,*plantConcept_entry_sppID,,
12
USDAPlantsCode,*USDAPlantsCode,,
13
VascularPlant,*VascularPlant,,
7
plantCode,*plantConcept_--plantCode,,
8
plantDescription,*plantConcept_--plantDescription,,
9
plantConcept_accessionCode,*plantConcept_--plantConcept_accessionCode,,
10
plantConcept_dba_src_ID,*plantConcept_--plantConcept_dba_src_ID,,
11
plantConcept_entry_sppID,*plantConcept_--plantConcept_entry_sppID,,
12
USDAPlantsCode,*plantConcept_--USDAPlantsCode,,
13
VascularPlant,*plantConcept_--VascularPlant,,
14 14
denorm_kingdom,kingdom,,
15 15
denorm_division,division_main,,"must be _alt-ed with Division because this is missing in 2 rows that have Division, and different from Division in 1 row"
16
denorm_category,*category,,
16
denorm_category,*plantConcept_--category,,
17 17
denorm_family,family,,
18 18
denorm_genus,genus_main,,must be _alt-ed with genus because this is missing in 1 row that has genus
19 19
denorm_species,specificEpithet,,"unlike VegBank, this is in fact the epithet, not the full name"
......
21 21
denorm_triName,infraspecificEpithet,,
22 22
denorm_quadAbbr,infraspecificRank2,,sometimes misparsed as the last + sign in the plantNameWithAuthority
23 23
denorm_quadName,infraspecificEpithet2,,sometimes misparsed as the part after the last + sign in the plantNameWithAuthority
24
denorm_hybridX,*hybridX,,
24
denorm_hybridX,*plantConcept_--hybridX,,
25 25
taxonLevel,taxonRank,,
26 26
taxonRank,OMIT#taxonRank,,Omitted because taxonLevel contains this information in text form
27
lowestParentName,*lowestParentName,,
28
lowestParentConcept_ID,*lowestParentConcept_ID,,
29
lowestChildRank,*lowestChildRank,,
27
lowestParentName,*plantConcept_--lowestParentName,,
28
lowestParentConcept_ID,*plantConcept_--lowestParentConcept_ID,,
29
lowestChildRank,*plantConcept_--lowestChildRank,,
30 30
commonName,vernacularName,,
31
growthForm_short,*growthForm_short,,
32
woody,*woody,,
33
exotic,*exotic,,
34
usda_code,*usda_code,,
35
usda_growthForm,*usda_growthForm,,
36
sensitiveSpeciesFuzzPlot,*sensitiveSpeciesFuzzPlot,,
31
growthForm_short,*plantConcept_--growthForm_short,,
32
woody,*plantConcept_--woody,,
33
exotic,*plantConcept_--exotic,,
34
usda_code,*plantConcept_--usda_code,,
35
usda_growthForm,*plantConcept_--usda_growthForm,,
36
sensitiveSpeciesFuzzPlot,*plantConcept_--sensitiveSpeciesFuzzPlot,,
37 37
Kingdom,DUPLICATE#of:denorm_kingdom#Kingdom,,
38
Subkingdom,*Subkingdom,,
38
Subkingdom,*plantConcept_--Subkingdom,,
39 39
Division,division_normalized,,
40 40
Class,class,,
41
Subclass,*Subclass,,
41
Subclass,*plantConcept_--Subclass,,
42 42
Order,order,,
43
composite family,*composite family,,
43
composite family,*plantConcept_--composite family,,
44 44
family,DUPLICATE#of:denorm_family#family,,
45
tribe,*tribe,,
46
composite genus,*composite genus,,
45
tribe,*plantConcept_--tribe,,
46
composite genus,*plantConcept_--composite genus,,
47 47
genus,genus_normalized,,"unlike VegBank, does *not* include genus author"
48 48
subgenus,subgenus,,
49
section,*section,,
50
composite species,*composite species,,
49
section,*plantConcept_--section,,
50
composite species,*plantConcept_--composite species,,
51 51
species,speciesBinomial,,full taxonomic name at that rank
52 52
subspecies,EQUIV#to:species#subspecies,,full taxonomic name at that rank
53 53
composite variety,EQUIV#to:species#composite variety,,full taxonomic name at that rank
inputs/CVS/plantConcept_/new_terms.csv
1
PLANTNAME_ID,*plantConcept_--PLANTNAME_ID,,
2
plantConcept_reference_ID,*plantConcept_--plantConcept_reference_ID,,
1 3
plantname,taxonName,,
2 4
plantNameWithAuthority,scientificName,,
5
plantCode,*plantConcept_--plantCode,,
6
plantDescription,*plantConcept_--plantDescription,,
7
plantConcept_accessionCode,*plantConcept_--plantConcept_accessionCode,,
8
plantConcept_dba_src_ID,*plantConcept_--plantConcept_dba_src_ID,,
9
plantConcept_entry_sppID,*plantConcept_--plantConcept_entry_sppID,,
10
USDAPlantsCode,*plantConcept_--USDAPlantsCode,,
11
VascularPlant,*plantConcept_--VascularPlant,,
3 12
denorm_kingdom,kingdom,,
4 13
denorm_division,division_main,,"must be _alt-ed with Division because this is missing in 2 rows that have Division, and different from Division in 1 row"
5
denorm_category,*category,,
14
denorm_category,*plantConcept_--category,,
6 15
denorm_family,family,,
7 16
denorm_genus,genus_main,,must be _alt-ed with genus because this is missing in 1 row that has genus
8 17
denorm_species,specificEpithet,,"unlike VegBank, this is in fact the epithet, not the full name"
......
10 19
denorm_triName,infraspecificEpithet,,
11 20
denorm_quadAbbr,infraspecificRank2,,sometimes misparsed as the last + sign in the plantNameWithAuthority
12 21
denorm_quadName,infraspecificEpithet2,,sometimes misparsed as the part after the last + sign in the plantNameWithAuthority
13
denorm_hybridX,*hybridX,,
22
denorm_hybridX,*plantConcept_--hybridX,,
14 23
taxonLevel,taxonRank,,
24
lowestParentName,*plantConcept_--lowestParentName,,
25
lowestParentConcept_ID,*plantConcept_--lowestParentConcept_ID,,
26
lowestChildRank,*plantConcept_--lowestChildRank,,
27
growthForm_short,*plantConcept_--growthForm_short,,
28
woody,*plantConcept_--woody,,
29
exotic,*plantConcept_--exotic,,
30
usda_code,*plantConcept_--usda_code,,
31
usda_growthForm,*plantConcept_--usda_growthForm,,
32
sensitiveSpeciesFuzzPlot,*plantConcept_--sensitiveSpeciesFuzzPlot,,
33
Subkingdom,*plantConcept_--Subkingdom,,
15 34
Division,division_normalized,,
35
Subclass,*plantConcept_--Subclass,,
36
composite family,*plantConcept_--composite family,,
37
tribe,*plantConcept_--tribe,,
38
composite genus,*plantConcept_--composite genus,,
39
section,*plantConcept_--section,,
40
composite species,*plantConcept_--composite species,,
16 41
composite variety,EQUIV#to:species#composite variety,,full taxonomic name at that rank
inputs/CVS/plantConcept_/unmapped_terms.csv
1 1
PLANTCONCEPT_ID
2
*PLANTNAME_ID
3
*plantConcept_reference_ID
4
*plantCode
5
*plantDescription
6
*plantConcept_accessionCode
7
*plantConcept_dba_src_ID
8
*plantConcept_entry_sppID
9
*USDAPlantsCode
10
*VascularPlant
2
*plantConcept_--PLANTNAME_ID
3
*plantConcept_--plantConcept_reference_ID
4
*plantConcept_--plantCode
5
*plantConcept_--plantDescription
6
*plantConcept_--plantConcept_accessionCode
7
*plantConcept_--plantConcept_dba_src_ID
8
*plantConcept_--plantConcept_entry_sppID
9
*plantConcept_--USDAPlantsCode
10
*plantConcept_--VascularPlant
11 11
division_main
12
*category
12
*plantConcept_--category
13 13
genus_main
14 14
infraspecificRank
15 15
infraspecificRank2
16 16
infraspecificEpithet2
17
*hybridX
18
*lowestParentName
19
*lowestParentConcept_ID
20
*lowestChildRank
17
*plantConcept_--hybridX
18
*plantConcept_--lowestParentName
19
*plantConcept_--lowestParentConcept_ID
20
*plantConcept_--lowestChildRank
21 21
vernacularName
22
*growthForm_short
23
*woody
24
*exotic
25
*usda_code
26
*usda_growthForm
27
*sensitiveSpeciesFuzzPlot
28
*Subkingdom
22
*plantConcept_--growthForm_short
23
*plantConcept_--woody
24
*plantConcept_--exotic
25
*plantConcept_--usda_code
26
*plantConcept_--usda_growthForm
27
*plantConcept_--sensitiveSpeciesFuzzPlot
28
*plantConcept_--Subkingdom
29 29
division_normalized
30
*Subclass
31
*composite family
32
*tribe
33
*composite genus
30
*plantConcept_--Subclass
31
*plantConcept_--composite family
32
*plantConcept_--tribe
33
*plantConcept_--composite genus
34 34
genus_normalized
35 35
subgenus
36
*section
37
*composite species
36
*plantConcept_--section
37
*plantConcept_--composite species
38 38
speciesBinomial
inputs/CVS/observation_/map.csv
1 1
CVS,VegCore,Filter,Comments
2 2
OBSERVATION_ID,eventID,,
3
PREVIOUSOBS_ID,*PREVIOUSOBS_ID,,
3
PREVIOUSOBS_ID,*observation_--PREVIOUSOBS_ID,,
4 4
PLOT_ID,locationID,,
5 5
PROJECT_ID,projectID,,
6 6
authorObsCode,authorEventCode,,
7 7
obsStartDate,startDate,,
8 8
obsEndDate,endDate,,
9
dateAccuracy,*dateAccuracy,,
10
dateEntered,*dateEntered,,
11
COVERMETHOD_ID,*COVERMETHOD_ID,,
12
coverDispersion,*coverDispersion,,
13
autoTaxonCover,*autoTaxonCover,,
14
STRATUMMETHOD_ID,*STRATUMMETHOD_ID,,
9
dateAccuracy,*observation_--dateAccuracy,,
10
dateEntered,*observation_--dateEntered,,
11
COVERMETHOD_ID,*observation_--COVERMETHOD_ID,,
12
coverDispersion,*observation_--coverDispersion,,
13
autoTaxonCover,*observation_--autoTaxonCover,,
14
STRATUMMETHOD_ID,*observation_--STRATUMMETHOD_ID,,
15 15
methodNarrative,samplingProtocol,,
16
taxonObservationArea,*taxonObservationArea,,
17
stemSizeLimit,*stemSizeLimit,,
18
stemObservationArea,*stemObservationArea,,
19
stemSampleMethod,*stemSampleMethod,,
20
originalData,*originalData,,
21
effortLevel,*effortLevel,,
22
plotValidationLevel,*plotValidationLevel,,
23
floristicQuality,*floristicQuality,,
24
bryophyteQuality,*bryophyteQuality,,
25
lichenQuality,*lichenQuality,,
26
observationNarrative,*observationNarrative,,
27
landscapeNarrative,*landscapeNarrative,,
28
homogeneity,*homogeneity,,
29
phenologicAspect,*phenologicAspect,,
30
representativeness,*representativeness,,
31
standMaturity,*standMaturity,,
32
successionalStatus,*successionalStatus,,
33
basalArea,*basalArea,,
34
hydrologicRegime,*hydrologicRegime,,
35
soilMoistureRegime,*soilMoistureRegime,,
36
soilDrainage,*soilDrainage,,
37
waterSalinity,*waterSalinity,,
38
waterDepth,*waterDepth,,
39
shoreDistance,*shoreDistance,,
40
soilDepth,*soilDepth,,
41
organicDepth,*organicDepth,,
42
SOILTAXON_ID,*SOILTAXON_ID,,
43
soilTaxonSrc,*soilTaxonSrc,,
44
soilTaxonComplex,*soilTaxonComplex,,
45
soilMapUnit,*soilMapUnit,,
46
percentBedRock,*percentBedRock,,
47
percentRockGravel,*percentRockGravel,,
48
percentWood,*percentWood,,
49
percentLitter,*percentLitter,,
50
percentBareSoil,*percentBareSoil,,
51
percentWater,*percentWater,,
52
percentOther,*percentOther,,
53
nameOther,*nameOther,,
54
treeHt,*treeHt,,
55
shrubHt,*shrubHt,,
56
fieldHt,*fieldHt,,
57
nonvascularHt,*nonvascularHt,,
58
submergedHt,*submergedHt,,
59
treeCover,*treeCover,,
60
shrubCover,*shrubCover,,
61
fieldCover,*fieldCover,,
62
nonvascularCover,*nonvascularCover,,
63
floatingCover,*floatingCover,,
64
submergedCover,*submergedCover,,
65
dominantStratum,*dominantStratum,,
66
growthform1Type,*growthform1Type,,
67
growthform2Type,*growthform2Type,,
68
growthform3Type,*growthform3Type,,
69
growthform1Cover,*growthform1Cover,,
70
growthform2Cover,*growthform2Cover,,
71
growthform3Cover,*growthform3Cover,,
72
totalCover,*totalCover,,
73
accessionCode,*accessionCode,,
74
notesPublic,*notesPublic,,
75
notesMgt,*notesMgt,,
76
revisions,*revisions,,
77
cust_cvs_CowardinSystem,*cust_cvs_CowardinSystem,,
78
cust_cvs_mcnab_LFI_asp,*cust_cvs_mcnab_LFI_asp,,
79
cust_cvs_mcnab_LFI_45,*cust_cvs_mcnab_LFI_45,,
80
cust_cvs_mcnab_LFI_90,*cust_cvs_mcnab_LFI_90,,
81
cust_cvs_mcnab_LFI_135,*cust_cvs_mcnab_LFI_135,,
82
cust_cvs_mcnab_LFI_180,*cust_cvs_mcnab_LFI_180,,
83
cust_cvs_mcnab_LFI_225,*cust_cvs_mcnab_LFI_225,,
84
cust_cvs_mcnab_LFI_270,*cust_cvs_mcnab_LFI_270,,
85
cust_cvs_mcnab_LFI_315,*cust_cvs_mcnab_LFI_315,,
86
cust_cvs_mcnab_TSI_asp,*cust_cvs_mcnab_TSI_asp,,
87
cust_cvs_mcnab_TSI_45,*cust_cvs_mcnab_TSI_45,,
88
cust_cvs_mcnab_TSI_90,*cust_cvs_mcnab_TSI_90,,
89
cust_cvs_mcnab_TSI_135,*cust_cvs_mcnab_TSI_135,,
90
cust_cvs_mcnab_TSI_180,*cust_cvs_mcnab_TSI_180,,
91
cust_cvs_mcnab_TSI_225,*cust_cvs_mcnab_TSI_225,,
92
cust_cvs_mcnab_TSI_270,*cust_cvs_mcnab_TSI_270,,
93
cust_cvs_mcnab_TSI_315,*cust_cvs_mcnab_TSI_315,,
94
cust_cvs_mcnab_LFI,*cust_cvs_mcnab_LFI,,
95
cust_cvs_mcnab_TSI,*cust_cvs_mcnab_TSI,,
96
cust_cvs_LeafType,*cust_cvs_LeafType,,
97
cust_cvs_LeafPhenology,*cust_cvs_LeafPhenology,,
98
cust_cvs_CanopyHeight,*cust_cvs_CanopyHeight,,
99
cust_cvs_compassType,*cust_cvs_compassType,,
100
cust_cvs_LocationSource,*cust_cvs_LocationSource,,
101
cust_cvs_GPSLocationX,*cust_cvs_GPSLocationX,,
102
cust_cvs_GPSLocationY,*cust_cvs_GPSLocationY,,
103
cust_cvs_Ownership,*cust_cvs_Ownership,,
104
cust_cvs_taxaRichness,*cust_cvs_taxaRichness,,
105
cust_cvs_lengthSoilProbe,*cust_cvs_lengthSoilProbe,,
106
cust_cvs_percentHistosol,*cust_cvs_percentHistosol,,
107
cust_cvs_percentBedrock,*cust_cvs_percentBedrock,,
108
cust_cvs_percentBoulder,*cust_cvs_percentBoulder,,
109
cust_cvs_percentGravelCobble,*cust_cvs_percentGravelCobble,,
110
cust_cvs_percentMineralSoil,*cust_cvs_percentMineralSoil,,
111
cust_cvs_percentCWD,*cust_cvs_percentCWD,,
112
cust_cvs_percentFWD,*cust_cvs_percentFWD,,
113
cust_cvs_percentDuff,*cust_cvs_percentDuff,,
114
cust_cvs_percentLitter,*cust_cvs_percentLitter,,
115
cust_cvs_percentNonVasc,*cust_cvs_percentNonVasc,,
116
cust_cvs_percentWater,*cust_cvs_percentWater,,
117
cust_cvs_percentOther,*cust_cvs_percentOther,,
118
cust_cvs_percentOtherName,*cust_cvs_percentOtherName,,
119
cust_cvs_samplingLevel,*cust_cvs_samplingLevel,,
120
cust_cvs_postDsgPoly,*cust_cvs_postDsgPoly,,
121
cust_cvs_stemsSampled,*cust_cvs_stemsSampled,,
122
cust_cvs_stemSamplingNarrative,*cust_cvs_stemSamplingNarrative,,
123
cust_eep_plotLastPlantedDate,*cust_eep_plotLastPlantedDate,,
124
cust_eep_plotNotSampled,*cust_eep_plotNotSampled,,
125
cust_eep_plotNotSampledReason,*cust_eep_plotNotSampledReason,,
126
entry_ares_herbs,*entry_ares_herbs,,
127
entry_ares_trees,*entry_ares_trees,,
128
entry_currentLandUse,*entry_currentLandUse,,
129
entry_depth,*entry_depth,,
130
entry_elevationUnits,*entry_elevationUnits,,
131
entry_formerLandUse,*entry_formerLandUse,,
132
entry_identificationNarrative,*entry_identificationNarrative,,
133
entry_IntensiveModuleList,*entry_IntensiveModuleList,,
134
entry_moduleSize_Overall,*entry_moduleSize_Overall,,
135
entry_moduleSizeX,*entry_moduleSizeX,,
136
entry_moduleSizeY,*entry_moduleSizeY,,
137
entry_photosTaken,*entry_photosTaken,,
138
entry_physClass,*entry_physClass,,
139
entry_plot_X,*entry_plot_X,,
140
entry_plot_Y,*entry_plot_Y,,
141
entry_soilModulesSampled,*entry_soilModulesSampled,,
142
entry_subsequentObsNum,*entry_subsequentObsNum,,
143
entry_taxonomicAuthority_ID,*entry_taxonomicAuthority_ID,,
144
entry_taxonomicAuthorityDate,*entry_taxonomicAuthorityDate,,
145
entry_team,*entry_team,,
146
entry_plot,*entry_plot,,
147
entry_numberOfModules,*entry_numberOfModules,,
148
errors,*errors,,
149
dba_src_ID,*dba_src_ID,,
150
dba_notes,*dba_notes,,
151
numberOfTaxa,*numberOfTaxa,,
152
SOILOBS_ID,*SOILOBS_ID,,
153
soilHorizon,*soilHorizon,,
154
soilDepthTop,*soilDepthTop,,
155
soilDepthBottom,*soilDepthBottom,,
156
soilColor,*soilColor,,
16
taxonObservationArea,*observation_--taxonObservationArea,,
17
stemSizeLimit,*observation_--stemSizeLimit,,
18
stemObservationArea,*observation_--stemObservationArea,,
19
stemSampleMethod,*observation_--stemSampleMethod,,
20
originalData,*observation_--originalData,,
21
effortLevel,*observation_--effortLevel,,
22
plotValidationLevel,*observation_--plotValidationLevel,,
23
floristicQuality,*observation_--floristicQuality,,
24
bryophyteQuality,*observation_--bryophyteQuality,,
25
lichenQuality,*observation_--lichenQuality,,
26
observationNarrative,*observation_--observationNarrative,,
27
landscapeNarrative,*observation_--landscapeNarrative,,
28
homogeneity,*observation_--homogeneity,,
29
phenologicAspect,*observation_--phenologicAspect,,
30
representativeness,*observation_--representativeness,,
31
standMaturity,*observation_--standMaturity,,
32
successionalStatus,*observation_--successionalStatus,,
33
basalArea,*observation_--basalArea,,
34
hydrologicRegime,*observation_--hydrologicRegime,,
35
soilMoistureRegime,*observation_--soilMoistureRegime,,
36
soilDrainage,*observation_--soilDrainage,,
37
waterSalinity,*observation_--waterSalinity,,
38
waterDepth,*observation_--waterDepth,,
39
shoreDistance,*observation_--shoreDistance,,
40
soilDepth,*observation_--soilDepth,,
41
organicDepth,*observation_--organicDepth,,
42
SOILTAXON_ID,*observation_--SOILTAXON_ID,,
43
soilTaxonSrc,*observation_--soilTaxonSrc,,
44
soilTaxonComplex,*observation_--soilTaxonComplex,,
45
soilMapUnit,*observation_--soilMapUnit,,
46
percentBedRock,*observation_--percentBedRock,,
47
percentRockGravel,*observation_--percentRockGravel,,
48
percentWood,*observation_--percentWood,,
49
percentLitter,*observation_--percentLitter,,
50
percentBareSoil,*observation_--percentBareSoil,,
51
percentWater,*observation_--percentWater,,
52
percentOther,*observation_--percentOther,,
53
nameOther,*observation_--nameOther,,
54
treeHt,*observation_--treeHt,,
55
shrubHt,*observation_--shrubHt,,
56
fieldHt,*observation_--fieldHt,,
57
nonvascularHt,*observation_--nonvascularHt,,
58
submergedHt,*observation_--submergedHt,,
59
treeCover,*observation_--treeCover,,
60
shrubCover,*observation_--shrubCover,,
61
fieldCover,*observation_--fieldCover,,
62
nonvascularCover,*observation_--nonvascularCover,,
63
floatingCover,*observation_--floatingCover,,
64
submergedCover,*observation_--submergedCover,,
65
dominantStratum,*observation_--dominantStratum,,
66
growthform1Type,*observation_--growthform1Type,,
67
growthform2Type,*observation_--growthform2Type,,
68
growthform3Type,*observation_--growthform3Type,,
69
growthform1Cover,*observation_--growthform1Cover,,
70
growthform2Cover,*observation_--growthform2Cover,,
71
growthform3Cover,*observation_--growthform3Cover,,
72
totalCover,*observation_--totalCover,,
73
accessionCode,*observation_--accessionCode,,
74
notesPublic,*observation_--notesPublic,,
75
notesMgt,*observation_--notesMgt,,
76
revisions,*observation_--revisions,,
77
cust_cvs_CowardinSystem,*observation_--cust_cvs_CowardinSystem,,
78
cust_cvs_mcnab_LFI_asp,*observation_--cust_cvs_mcnab_LFI_asp,,
79
cust_cvs_mcnab_LFI_45,*observation_--cust_cvs_mcnab_LFI_45,,
80
cust_cvs_mcnab_LFI_90,*observation_--cust_cvs_mcnab_LFI_90,,
81
cust_cvs_mcnab_LFI_135,*observation_--cust_cvs_mcnab_LFI_135,,
82
cust_cvs_mcnab_LFI_180,*observation_--cust_cvs_mcnab_LFI_180,,
83
cust_cvs_mcnab_LFI_225,*observation_--cust_cvs_mcnab_LFI_225,,
84
cust_cvs_mcnab_LFI_270,*observation_--cust_cvs_mcnab_LFI_270,,
85
cust_cvs_mcnab_LFI_315,*observation_--cust_cvs_mcnab_LFI_315,,
86
cust_cvs_mcnab_TSI_asp,*observation_--cust_cvs_mcnab_TSI_asp,,
87
cust_cvs_mcnab_TSI_45,*observation_--cust_cvs_mcnab_TSI_45,,
88
cust_cvs_mcnab_TSI_90,*observation_--cust_cvs_mcnab_TSI_90,,
89
cust_cvs_mcnab_TSI_135,*observation_--cust_cvs_mcnab_TSI_135,,
90
cust_cvs_mcnab_TSI_180,*observation_--cust_cvs_mcnab_TSI_180,,
91
cust_cvs_mcnab_TSI_225,*observation_--cust_cvs_mcnab_TSI_225,,
92
cust_cvs_mcnab_TSI_270,*observation_--cust_cvs_mcnab_TSI_270,,
93
cust_cvs_mcnab_TSI_315,*observation_--cust_cvs_mcnab_TSI_315,,
94
cust_cvs_mcnab_LFI,*observation_--cust_cvs_mcnab_LFI,,
95
cust_cvs_mcnab_TSI,*observation_--cust_cvs_mcnab_TSI,,
96
cust_cvs_LeafType,*observation_--cust_cvs_LeafType,,
97
cust_cvs_LeafPhenology,*observation_--cust_cvs_LeafPhenology,,
98
cust_cvs_CanopyHeight,*observation_--cust_cvs_CanopyHeight,,
99
cust_cvs_compassType,*observation_--cust_cvs_compassType,,
100
cust_cvs_LocationSource,*observation_--cust_cvs_LocationSource,,
101
cust_cvs_GPSLocationX,*observation_--cust_cvs_GPSLocationX,,
102
cust_cvs_GPSLocationY,*observation_--cust_cvs_GPSLocationY,,
103
cust_cvs_Ownership,*observation_--cust_cvs_Ownership,,
104
cust_cvs_taxaRichness,*observation_--cust_cvs_taxaRichness,,
105
cust_cvs_lengthSoilProbe,*observation_--cust_cvs_lengthSoilProbe,,
106
cust_cvs_percentHistosol,*observation_--cust_cvs_percentHistosol,,
107
cust_cvs_percentBedrock,*observation_--cust_cvs_percentBedrock,,
108
cust_cvs_percentBoulder,*observation_--cust_cvs_percentBoulder,,
109
cust_cvs_percentGravelCobble,*observation_--cust_cvs_percentGravelCobble,,
110
cust_cvs_percentMineralSoil,*observation_--cust_cvs_percentMineralSoil,,
111
cust_cvs_percentCWD,*observation_--cust_cvs_percentCWD,,
112
cust_cvs_percentFWD,*observation_--cust_cvs_percentFWD,,
113
cust_cvs_percentDuff,*observation_--cust_cvs_percentDuff,,
114
cust_cvs_percentLitter,*observation_--cust_cvs_percentLitter,,
115
cust_cvs_percentNonVasc,*observation_--cust_cvs_percentNonVasc,,
116
cust_cvs_percentWater,*observation_--cust_cvs_percentWater,,
117
cust_cvs_percentOther,*observation_--cust_cvs_percentOther,,
118
cust_cvs_percentOtherName,*observation_--cust_cvs_percentOtherName,,
119
cust_cvs_samplingLevel,*observation_--cust_cvs_samplingLevel,,
120
cust_cvs_postDsgPoly,*observation_--cust_cvs_postDsgPoly,,
121
cust_cvs_stemsSampled,*observation_--cust_cvs_stemsSampled,,
122
cust_cvs_stemSamplingNarrative,*observation_--cust_cvs_stemSamplingNarrative,,
123
cust_eep_plotLastPlantedDate,*observation_--cust_eep_plotLastPlantedDate,,
124
cust_eep_plotNotSampled,*observation_--cust_eep_plotNotSampled,,
125
cust_eep_plotNotSampledReason,*observation_--cust_eep_plotNotSampledReason,,
126
entry_ares_herbs,*observation_--entry_ares_herbs,,
127
entry_ares_trees,*observation_--entry_ares_trees,,
128
entry_currentLandUse,*observation_--entry_currentLandUse,,
129
entry_depth,*observation_--entry_depth,,
130
entry_elevationUnits,*observation_--entry_elevationUnits,,
131
entry_formerLandUse,*observation_--entry_formerLandUse,,
132
entry_identificationNarrative,*observation_--entry_identificationNarrative,,
133
entry_IntensiveModuleList,*observation_--entry_IntensiveModuleList,,
134
entry_moduleSize_Overall,*observation_--entry_moduleSize_Overall,,
135
entry_moduleSizeX,*observation_--entry_moduleSizeX,,
136
entry_moduleSizeY,*observation_--entry_moduleSizeY,,
137
entry_photosTaken,*observation_--entry_photosTaken,,
138
entry_physClass,*observation_--entry_physClass,,
139
entry_plot_X,*observation_--entry_plot_X,,
140
entry_plot_Y,*observation_--entry_plot_Y,,
141
entry_soilModulesSampled,*observation_--entry_soilModulesSampled,,
142
entry_subsequentObsNum,*observation_--entry_subsequentObsNum,,
143
entry_taxonomicAuthority_ID,*observation_--entry_taxonomicAuthority_ID,,
144
entry_taxonomicAuthorityDate,*observation_--entry_taxonomicAuthorityDate,,
145
entry_team,*observation_--entry_team,,
146
entry_plot,*observation_--entry_plot,,
147
entry_numberOfModules,*observation_--entry_numberOfModules,,
148
errors,*observation_--errors,,
149
dba_src_ID,*observation_--dba_src_ID,,
150
dba_notes,*observation_--dba_notes,,
151
numberOfTaxa,*observation_--numberOfTaxa,,
152
SOILOBS_ID,*observation_--SOILOBS_ID,,
153
soilHorizon,*observation_--soilHorizon,,
154
soilDepthTop,*observation_--soilDepthTop,,
155
soilDepthBottom,*observation_--soilDepthBottom,,
156
soilColor,*observation_--soilColor,,
157 157
soilOrganic,organic_percent,,
158 158
soilTexture,texture,,
159 159
soilSand,sand_percent,,
160 160
soilSilt,silt_percent,,
161 161
soilClay,clay_percent,,
162
soilCoarse,*soilCoarse,,
162
soilCoarse,*observation_--soilCoarse,,
163 163
soilPH,ph,,
164 164
exchangeCapacity,cationExchangeCapacity_cmol_kg,,
165 165
baseSaturation,baseSaturation_percent,,
166
soilDescription,*soilDescription,,
167
cust_cvs_collectionName,*cust_cvs_collectionName,,
168
cust_cvs_Lab,*cust_cvs_Lab,,
169
cust_cvs_N,*cust_cvs_N,,
170
cust_cvs_S,*cust_cvs_S,,
171
cust_cvs_P,*cust_cvs_P,,
172
cust_cvs_Ca_ppm,*cust_cvs_Ca_ppm,,
173
cust_cvs_Mg_ppm,*cust_cvs_Mg_ppm,,
174
cust_cvs_K_ppm,*cust_cvs_K_ppm,,
175
cust_cvs_Na_ppm,*cust_cvs_Na_ppm,,
176
cust_cvs_percent_Ca,*cust_cvs_percent_Ca,,
177
cust_cvs_percent_Mg,*cust_cvs_percent_Mg,,
178
cust_cvs_percent_K,*cust_cvs_percent_K,,
179
cust_cvs_percent_Na,*cust_cvs_percent_Na,,
180
cust_cvs_percent_Othr,*cust_cvs_percent_Othr,,
181
cust_cvs_percent_H,*cust_cvs_percent_H,,
182
cust_cvs_B_ppm,*cust_cvs_B_ppm,,
183
cust_cvs_Fe_ppm,*cust_cvs_Fe_ppm,,
184
cust_cvs_Mn_ppm,*cust_cvs_Mn_ppm,,
185
cust_cvs_Cu_ppm,*cust_cvs_Cu_ppm,,
186
cust_cvs_Zn_ppm,*cust_cvs_Zn_ppm,,
187
cust_cvs_Al_ppm,*cust_cvs_Al_ppm,,
188
cust_cvs_Density,*cust_cvs_Density,,
189
cust_cvs_Ca_over_Mg_ppm,*cust_cvs_Ca_over_Mg_ppm,,
190
soilObs_dba_src_ID,*soilObs_dba_src_ID,,
166
soilDescription,*observation_--soilDescription,,
167
cust_cvs_collectionName,*observation_--cust_cvs_collectionName,,
168
cust_cvs_Lab,*observation_--cust_cvs_Lab,,
169
cust_cvs_N,*observation_--cust_cvs_N,,
170
cust_cvs_S,*observation_--cust_cvs_S,,
171
cust_cvs_P,*observation_--cust_cvs_P,,
172
cust_cvs_Ca_ppm,*observation_--cust_cvs_Ca_ppm,,
173
cust_cvs_Mg_ppm,*observation_--cust_cvs_Mg_ppm,,
174
cust_cvs_K_ppm,*observation_--cust_cvs_K_ppm,,
175
cust_cvs_Na_ppm,*observation_--cust_cvs_Na_ppm,,
176
cust_cvs_percent_Ca,*observation_--cust_cvs_percent_Ca,,
177
cust_cvs_percent_Mg,*observation_--cust_cvs_percent_Mg,,
178
cust_cvs_percent_K,*observation_--cust_cvs_percent_K,,
179
cust_cvs_percent_Na,*observation_--cust_cvs_percent_Na,,
180
cust_cvs_percent_Othr,*observation_--cust_cvs_percent_Othr,,
181
cust_cvs_percent_H,*observation_--cust_cvs_percent_H,,
182
cust_cvs_B_ppm,*observation_--cust_cvs_B_ppm,,
183
cust_cvs_Fe_ppm,*observation_--cust_cvs_Fe_ppm,,
184
cust_cvs_Mn_ppm,*observation_--cust_cvs_Mn_ppm,,
185
cust_cvs_Cu_ppm,*observation_--cust_cvs_Cu_ppm,,
186
cust_cvs_Zn_ppm,*observation_--cust_cvs_Zn_ppm,,
187
cust_cvs_Al_ppm,*observation_--cust_cvs_Al_ppm,,
188
cust_cvs_Density,*observation_--cust_cvs_Density,,
189
cust_cvs_Ca_over_Mg_ppm,*observation_--cust_cvs_Ca_over_Mg_ppm,,
190
soilObs_dba_src_ID,*observation_--soilObs_dba_src_ID,,
inputs/CVS/observation_/new_terms.csv
1 1
OBSERVATION_ID,eventID,,
2
PREVIOUSOBS_ID,*observation_--PREVIOUSOBS_ID,,
3
dateAccuracy,*observation_--dateAccuracy,,
4
dateEntered,*observation_--dateEntered,,
5
COVERMETHOD_ID,*observation_--COVERMETHOD_ID,,
6
coverDispersion,*observation_--coverDispersion,,
7
autoTaxonCover,*observation_--autoTaxonCover,,
8
STRATUMMETHOD_ID,*observation_--STRATUMMETHOD_ID,,
2 9
methodNarrative,samplingProtocol,,
10
taxonObservationArea,*observation_--taxonObservationArea,,
11
stemSizeLimit,*observation_--stemSizeLimit,,
12
stemObservationArea,*observation_--stemObservationArea,,
13
stemSampleMethod,*observation_--stemSampleMethod,,
14
originalData,*observation_--originalData,,
15
effortLevel,*observation_--effortLevel,,
16
plotValidationLevel,*observation_--plotValidationLevel,,
17
floristicQuality,*observation_--floristicQuality,,
18
bryophyteQuality,*observation_--bryophyteQuality,,
19
lichenQuality,*observation_--lichenQuality,,
20
observationNarrative,*observation_--observationNarrative,,
21
landscapeNarrative,*observation_--landscapeNarrative,,
22
homogeneity,*observation_--homogeneity,,
23
phenologicAspect,*observation_--phenologicAspect,,
24
representativeness,*observation_--representativeness,,
25
standMaturity,*observation_--standMaturity,,
26
successionalStatus,*observation_--successionalStatus,,
27
basalArea,*observation_--basalArea,,
28
hydrologicRegime,*observation_--hydrologicRegime,,
29
soilMoistureRegime,*observation_--soilMoistureRegime,,
30
soilDrainage,*observation_--soilDrainage,,
31
waterSalinity,*observation_--waterSalinity,,
32
waterDepth,*observation_--waterDepth,,
33
shoreDistance,*observation_--shoreDistance,,
34
soilDepth,*observation_--soilDepth,,
35
organicDepth,*observation_--organicDepth,,
36
SOILTAXON_ID,*observation_--SOILTAXON_ID,,
37
soilTaxonSrc,*observation_--soilTaxonSrc,,
38
soilTaxonComplex,*observation_--soilTaxonComplex,,
39
soilMapUnit,*observation_--soilMapUnit,,
40
percentBedRock,*observation_--percentBedRock,,
41
percentRockGravel,*observation_--percentRockGravel,,
42
percentWood,*observation_--percentWood,,
43
percentLitter,*observation_--percentLitter,,
44
percentBareSoil,*observation_--percentBareSoil,,
45
percentWater,*observation_--percentWater,,
46
percentOther,*observation_--percentOther,,
47
nameOther,*observation_--nameOther,,
48
treeHt,*observation_--treeHt,,
49
shrubHt,*observation_--shrubHt,,
50
fieldHt,*observation_--fieldHt,,
51
nonvascularHt,*observation_--nonvascularHt,,
52
submergedHt,*observation_--submergedHt,,
53
treeCover,*observation_--treeCover,,
54
shrubCover,*observation_--shrubCover,,
55
fieldCover,*observation_--fieldCover,,
56
nonvascularCover,*observation_--nonvascularCover,,
57
floatingCover,*observation_--floatingCover,,
58
submergedCover,*observation_--submergedCover,,
59
dominantStratum,*observation_--dominantStratum,,
60
growthform1Type,*observation_--growthform1Type,,
61
growthform2Type,*observation_--growthform2Type,,
62
growthform3Type,*observation_--growthform3Type,,
63
growthform1Cover,*observation_--growthform1Cover,,
64
growthform2Cover,*observation_--growthform2Cover,,
65
growthform3Cover,*observation_--growthform3Cover,,
66
totalCover,*observation_--totalCover,,
67
accessionCode,*observation_--accessionCode,,
68
notesPublic,*observation_--notesPublic,,
69
notesMgt,*observation_--notesMgt,,
70
revisions,*observation_--revisions,,
71
cust_cvs_CowardinSystem,*observation_--cust_cvs_CowardinSystem,,
72
cust_cvs_mcnab_LFI_asp,*observation_--cust_cvs_mcnab_LFI_asp,,
73
cust_cvs_mcnab_LFI_45,*observation_--cust_cvs_mcnab_LFI_45,,
74
cust_cvs_mcnab_LFI_90,*observation_--cust_cvs_mcnab_LFI_90,,
75
cust_cvs_mcnab_LFI_135,*observation_--cust_cvs_mcnab_LFI_135,,
76
cust_cvs_mcnab_LFI_180,*observation_--cust_cvs_mcnab_LFI_180,,
77
cust_cvs_mcnab_LFI_225,*observation_--cust_cvs_mcnab_LFI_225,,
78
cust_cvs_mcnab_LFI_270,*observation_--cust_cvs_mcnab_LFI_270,,
79
cust_cvs_mcnab_LFI_315,*observation_--cust_cvs_mcnab_LFI_315,,
80
cust_cvs_mcnab_TSI_asp,*observation_--cust_cvs_mcnab_TSI_asp,,
81
cust_cvs_mcnab_TSI_45,*observation_--cust_cvs_mcnab_TSI_45,,
82
cust_cvs_mcnab_TSI_90,*observation_--cust_cvs_mcnab_TSI_90,,
83
cust_cvs_mcnab_TSI_135,*observation_--cust_cvs_mcnab_TSI_135,,
84
cust_cvs_mcnab_TSI_180,*observation_--cust_cvs_mcnab_TSI_180,,
85
cust_cvs_mcnab_TSI_225,*observation_--cust_cvs_mcnab_TSI_225,,
86
cust_cvs_mcnab_TSI_270,*observation_--cust_cvs_mcnab_TSI_270,,
87
cust_cvs_mcnab_TSI_315,*observation_--cust_cvs_mcnab_TSI_315,,
88
cust_cvs_mcnab_LFI,*observation_--cust_cvs_mcnab_LFI,,
89
cust_cvs_mcnab_TSI,*observation_--cust_cvs_mcnab_TSI,,
90
cust_cvs_LeafType,*observation_--cust_cvs_LeafType,,
91
cust_cvs_LeafPhenology,*observation_--cust_cvs_LeafPhenology,,
92
cust_cvs_CanopyHeight,*observation_--cust_cvs_CanopyHeight,,
93
cust_cvs_compassType,*observation_--cust_cvs_compassType,,
94
cust_cvs_LocationSource,*observation_--cust_cvs_LocationSource,,
95
cust_cvs_GPSLocationX,*observation_--cust_cvs_GPSLocationX,,
96
cust_cvs_GPSLocationY,*observation_--cust_cvs_GPSLocationY,,
97
cust_cvs_Ownership,*observation_--cust_cvs_Ownership,,
98
cust_cvs_taxaRichness,*observation_--cust_cvs_taxaRichness,,
99
cust_cvs_lengthSoilProbe,*observation_--cust_cvs_lengthSoilProbe,,
100
cust_cvs_percentHistosol,*observation_--cust_cvs_percentHistosol,,
101
cust_cvs_percentBedrock,*observation_--cust_cvs_percentBedrock,,
102
cust_cvs_percentBoulder,*observation_--cust_cvs_percentBoulder,,
103
cust_cvs_percentGravelCobble,*observation_--cust_cvs_percentGravelCobble,,
104
cust_cvs_percentMineralSoil,*observation_--cust_cvs_percentMineralSoil,,
105
cust_cvs_percentCWD,*observation_--cust_cvs_percentCWD,,
106
cust_cvs_percentFWD,*observation_--cust_cvs_percentFWD,,
107
cust_cvs_percentDuff,*observation_--cust_cvs_percentDuff,,
108
cust_cvs_percentLitter,*observation_--cust_cvs_percentLitter,,
109
cust_cvs_percentNonVasc,*observation_--cust_cvs_percentNonVasc,,
110
cust_cvs_percentWater,*observation_--cust_cvs_percentWater,,
111
cust_cvs_percentOther,*observation_--cust_cvs_percentOther,,
112
cust_cvs_percentOtherName,*observation_--cust_cvs_percentOtherName,,
113
cust_cvs_samplingLevel,*observation_--cust_cvs_samplingLevel,,
114
cust_cvs_postDsgPoly,*observation_--cust_cvs_postDsgPoly,,
115
cust_cvs_stemsSampled,*observation_--cust_cvs_stemsSampled,,
116
cust_cvs_stemSamplingNarrative,*observation_--cust_cvs_stemSamplingNarrative,,
117
cust_eep_plotLastPlantedDate,*observation_--cust_eep_plotLastPlantedDate,,
118
cust_eep_plotNotSampled,*observation_--cust_eep_plotNotSampled,,
119
cust_eep_plotNotSampledReason,*observation_--cust_eep_plotNotSampledReason,,
120
entry_ares_herbs,*observation_--entry_ares_herbs,,
121
entry_ares_trees,*observation_--entry_ares_trees,,
122
entry_currentLandUse,*observation_--entry_currentLandUse,,
123
entry_depth,*observation_--entry_depth,,
124
entry_elevationUnits,*observation_--entry_elevationUnits,,
125
entry_formerLandUse,*observation_--entry_formerLandUse,,
126
entry_identificationNarrative,*observation_--entry_identificationNarrative,,
127
entry_IntensiveModuleList,*observation_--entry_IntensiveModuleList,,
128
entry_moduleSize_Overall,*observation_--entry_moduleSize_Overall,,
129
entry_moduleSizeX,*observation_--entry_moduleSizeX,,
130
entry_moduleSizeY,*observation_--entry_moduleSizeY,,
131
entry_photosTaken,*observation_--entry_photosTaken,,
132
entry_physClass,*observation_--entry_physClass,,
133
entry_plot_X,*observation_--entry_plot_X,,
134
entry_plot_Y,*observation_--entry_plot_Y,,
135
entry_soilModulesSampled,*observation_--entry_soilModulesSampled,,
136
entry_subsequentObsNum,*observation_--entry_subsequentObsNum,,
137
entry_taxonomicAuthority_ID,*observation_--entry_taxonomicAuthority_ID,,
138
entry_taxonomicAuthorityDate,*observation_--entry_taxonomicAuthorityDate,,
139
entry_team,*observation_--entry_team,,
140
entry_plot,*observation_--entry_plot,,
141
entry_numberOfModules,*observation_--entry_numberOfModules,,
142
errors,*observation_--errors,,
143
dba_src_ID,*observation_--dba_src_ID,,
144
dba_notes,*observation_--dba_notes,,
145
numberOfTaxa,*observation_--numberOfTaxa,,
146
SOILOBS_ID,*observation_--SOILOBS_ID,,
147
soilHorizon,*observation_--soilHorizon,,
148
soilDepthTop,*observation_--soilDepthTop,,
149
soilDepthBottom,*observation_--soilDepthBottom,,
150
soilColor,*observation_--soilColor,,
151
soilCoarse,*observation_--soilCoarse,,
3 152
soilPH,ph,,
153
soilDescription,*observation_--soilDescription,,
154
cust_cvs_collectionName,*observation_--cust_cvs_collectionName,,
155
cust_cvs_Lab,*observation_--cust_cvs_Lab,,
156
cust_cvs_N,*observation_--cust_cvs_N,,
157
cust_cvs_S,*observation_--cust_cvs_S,,
158
cust_cvs_P,*observation_--cust_cvs_P,,
159
cust_cvs_Ca_ppm,*observation_--cust_cvs_Ca_ppm,,
160
cust_cvs_Mg_ppm,*observation_--cust_cvs_Mg_ppm,,
161
cust_cvs_K_ppm,*observation_--cust_cvs_K_ppm,,
162
cust_cvs_Na_ppm,*observation_--cust_cvs_Na_ppm,,
163
cust_cvs_percent_Ca,*observation_--cust_cvs_percent_Ca,,
164
cust_cvs_percent_Mg,*observation_--cust_cvs_percent_Mg,,
165
cust_cvs_percent_K,*observation_--cust_cvs_percent_K,,
166
cust_cvs_percent_Na,*observation_--cust_cvs_percent_Na,,
167
cust_cvs_percent_Othr,*observation_--cust_cvs_percent_Othr,,
168
cust_cvs_percent_H,*observation_--cust_cvs_percent_H,,
169
cust_cvs_B_ppm,*observation_--cust_cvs_B_ppm,,
170
cust_cvs_Fe_ppm,*observation_--cust_cvs_Fe_ppm,,
171
cust_cvs_Mn_ppm,*observation_--cust_cvs_Mn_ppm,,
172
cust_cvs_Cu_ppm,*observation_--cust_cvs_Cu_ppm,,
173
cust_cvs_Zn_ppm,*observation_--cust_cvs_Zn_ppm,,
174
cust_cvs_Al_ppm,*observation_--cust_cvs_Al_ppm,,
175
cust_cvs_Density,*observation_--cust_cvs_Density,,
176
cust_cvs_Ca_over_Mg_ppm,*observation_--cust_cvs_Ca_over_Mg_ppm,,
177
soilObs_dba_src_ID,*observation_--soilObs_dba_src_ID,,
inputs/CVS/observation_/unmapped_terms.csv
1
*PREVIOUSOBS_ID
2
*dateAccuracy
3
*dateEntered
4
*COVERMETHOD_ID
5
*coverDispersion
6
*autoTaxonCover
7
*STRATUMMETHOD_ID
8
*taxonObservationArea
9
*stemSizeLimit
10
*stemObservationArea
11
*stemSampleMethod
12
*originalData
13
*effortLevel
14
*plotValidationLevel
15
*floristicQuality
16
*bryophyteQuality
17
*lichenQuality
18
*observationNarrative
19
*landscapeNarrative
20
*homogeneity
21
*phenologicAspect
22
*representativeness
23
*standMaturity
24
*successionalStatus
25
*basalArea
26
*hydrologicRegime
27
*soilMoistureRegime
28
*soilDrainage
29
*waterSalinity
30
*waterDepth
31
*shoreDistance
32
*soilDepth
33
*organicDepth
34
*SOILTAXON_ID
35
*soilTaxonSrc
36
*soilTaxonComplex
37
*soilMapUnit
38
*percentBedRock
39
*percentRockGravel
40
*percentWood
41
*percentLitter
42
*percentBareSoil
43
*percentWater
44
*percentOther
45
*nameOther
46
*treeHt
47
*shrubHt
48
*fieldHt
49
*nonvascularHt
50
*submergedHt
51
*treeCover
52
*shrubCover
53
*fieldCover
54
*nonvascularCover
55
*floatingCover
56
*submergedCover
57
*dominantStratum
58
*growthform1Type
59
*growthform2Type
60
*growthform3Type
61
*growthform1Cover
62
*growthform2Cover
63
*growthform3Cover
64
*totalCover
65
*accessionCode
66
*notesPublic
67
*notesMgt
68
*revisions
69
*cust_cvs_CowardinSystem
70
*cust_cvs_mcnab_LFI_asp
71
*cust_cvs_mcnab_LFI_45
72
*cust_cvs_mcnab_LFI_90
73
*cust_cvs_mcnab_LFI_135
74
*cust_cvs_mcnab_LFI_180
75
*cust_cvs_mcnab_LFI_225
76
*cust_cvs_mcnab_LFI_270
77
*cust_cvs_mcnab_LFI_315
78
*cust_cvs_mcnab_TSI_asp
79
*cust_cvs_mcnab_TSI_45
80
*cust_cvs_mcnab_TSI_90
81
*cust_cvs_mcnab_TSI_135
82
*cust_cvs_mcnab_TSI_180
83
*cust_cvs_mcnab_TSI_225
84
*cust_cvs_mcnab_TSI_270
85
*cust_cvs_mcnab_TSI_315
86
*cust_cvs_mcnab_LFI
87
*cust_cvs_mcnab_TSI
88
*cust_cvs_LeafType
89
*cust_cvs_LeafPhenology
90
*cust_cvs_CanopyHeight
91
*cust_cvs_compassType
92
*cust_cvs_LocationSource
93
*cust_cvs_GPSLocationX
94
*cust_cvs_GPSLocationY
95
*cust_cvs_Ownership
96
*cust_cvs_taxaRichness
97
*cust_cvs_lengthSoilProbe
98
*cust_cvs_percentHistosol
99
*cust_cvs_percentBedrock
100
*cust_cvs_percentBoulder
101
*cust_cvs_percentGravelCobble
102
*cust_cvs_percentMineralSoil
103
*cust_cvs_percentCWD
104
*cust_cvs_percentFWD
105
*cust_cvs_percentDuff
106
*cust_cvs_percentLitter
107
*cust_cvs_percentNonVasc
108
*cust_cvs_percentWater
109
*cust_cvs_percentOther
110
*cust_cvs_percentOtherName
111
*cust_cvs_samplingLevel
112
*cust_cvs_postDsgPoly
113
*cust_cvs_stemsSampled
114
*cust_cvs_stemSamplingNarrative
115
*cust_eep_plotLastPlantedDate
116
*cust_eep_plotNotSampled
117
*cust_eep_plotNotSampledReason
118
*entry_ares_herbs
119
*entry_ares_trees
120
*entry_currentLandUse
121
*entry_depth
122
*entry_elevationUnits
123
*entry_formerLandUse
124
*entry_identificationNarrative
125
*entry_IntensiveModuleList
126
*entry_moduleSize_Overall
127
*entry_moduleSizeX
128
*entry_moduleSizeY
129
*entry_photosTaken
130
*entry_physClass
131
*entry_plot_X
132
*entry_plot_Y
133
*entry_soilModulesSampled
134
*entry_subsequentObsNum
135
*entry_taxonomicAuthority_ID
136
*entry_taxonomicAuthorityDate
137
*entry_team
138
*entry_plot
139
*entry_numberOfModules
140
*errors
141
*dba_src_ID
142
*dba_notes
143
*numberOfTaxa
144
*SOILOBS_ID
145
*soilHorizon
146
*soilDepthTop
147
*soilDepthBottom
148
*soilColor
149
*soilCoarse
150
*soilDescription
151
*cust_cvs_collectionName
152
*cust_cvs_Lab
153
*cust_cvs_N
154
*cust_cvs_S
155
*cust_cvs_P
156
*cust_cvs_Ca_ppm
157
*cust_cvs_Mg_ppm
158
*cust_cvs_K_ppm
159
*cust_cvs_Na_ppm
160
*cust_cvs_percent_Ca
161
*cust_cvs_percent_Mg
162
*cust_cvs_percent_K
163
*cust_cvs_percent_Na
164
*cust_cvs_percent_Othr
165
*cust_cvs_percent_H
166
*cust_cvs_B_ppm
167
*cust_cvs_Fe_ppm
168
*cust_cvs_Mn_ppm
169
*cust_cvs_Cu_ppm
170
*cust_cvs_Zn_ppm
171
*cust_cvs_Al_ppm
172
*cust_cvs_Density
173
*cust_cvs_Ca_over_Mg_ppm
174
*soilObs_dba_src_ID
1
*observation_--PREVIOUSOBS_ID
2
*observation_--dateAccuracy
3
*observation_--dateEntered
4
*observation_--COVERMETHOD_ID
5
*observation_--coverDispersion
6
*observation_--autoTaxonCover
7
*observation_--STRATUMMETHOD_ID
8
*observation_--taxonObservationArea
9
*observation_--stemSizeLimit
10
*observation_--stemObservationArea
11
*observation_--stemSampleMethod
12
*observation_--originalData
13
*observation_--effortLevel
14
*observation_--plotValidationLevel
15
*observation_--floristicQuality
16
*observation_--bryophyteQuality
17
*observation_--lichenQuality
18
*observation_--observationNarrative
19
*observation_--landscapeNarrative
20
*observation_--homogeneity
21
*observation_--phenologicAspect
22
*observation_--representativeness
23
*observation_--standMaturity
24
*observation_--successionalStatus
25
*observation_--basalArea
26
*observation_--hydrologicRegime
27
*observation_--soilMoistureRegime
28
*observation_--soilDrainage
29
*observation_--waterSalinity
30
*observation_--waterDepth
31
*observation_--shoreDistance
32
*observation_--soilDepth
33
*observation_--organicDepth
34
*observation_--SOILTAXON_ID
35
*observation_--soilTaxonSrc
36
*observation_--soilTaxonComplex
37
*observation_--soilMapUnit
38
*observation_--percentBedRock
39
*observation_--percentRockGravel
40
*observation_--percentWood
41
*observation_--percentLitter
42
*observation_--percentBareSoil
43
*observation_--percentWater
44
*observation_--percentOther
45
*observation_--nameOther
46
*observation_--treeHt
47
*observation_--shrubHt
48
*observation_--fieldHt
49
*observation_--nonvascularHt
50
*observation_--submergedHt
51
*observation_--treeCover
52
*observation_--shrubCover
53
*observation_--fieldCover
54
*observation_--nonvascularCover
55
*observation_--floatingCover
56
*observation_--submergedCover
57
*observation_--dominantStratum
58
*observation_--growthform1Type
59
*observation_--growthform2Type
60
*observation_--growthform3Type
61
*observation_--growthform1Cover
62
*observation_--growthform2Cover
63
*observation_--growthform3Cover
64
*observation_--totalCover
65
*observation_--accessionCode
66
*observation_--notesPublic
67
*observation_--notesMgt
68
*observation_--revisions
69
*observation_--cust_cvs_CowardinSystem
70
*observation_--cust_cvs_mcnab_LFI_asp
71
*observation_--cust_cvs_mcnab_LFI_45
72
*observation_--cust_cvs_mcnab_LFI_90
73
*observation_--cust_cvs_mcnab_LFI_135
74
*observation_--cust_cvs_mcnab_LFI_180
75
*observation_--cust_cvs_mcnab_LFI_225
76
*observation_--cust_cvs_mcnab_LFI_270
77
*observation_--cust_cvs_mcnab_LFI_315
78
*observation_--cust_cvs_mcnab_TSI_asp
79
*observation_--cust_cvs_mcnab_TSI_45
80
*observation_--cust_cvs_mcnab_TSI_90
81
*observation_--cust_cvs_mcnab_TSI_135
82
*observation_--cust_cvs_mcnab_TSI_180
83
*observation_--cust_cvs_mcnab_TSI_225
84
*observation_--cust_cvs_mcnab_TSI_270
85
*observation_--cust_cvs_mcnab_TSI_315
86
*observation_--cust_cvs_mcnab_LFI
87
*observation_--cust_cvs_mcnab_TSI
88
*observation_--cust_cvs_LeafType
89
*observation_--cust_cvs_LeafPhenology
90
*observation_--cust_cvs_CanopyHeight
91
*observation_--cust_cvs_compassType
92
*observation_--cust_cvs_LocationSource
93
*observation_--cust_cvs_GPSLocationX
94
*observation_--cust_cvs_GPSLocationY
95
*observation_--cust_cvs_Ownership
96
*observation_--cust_cvs_taxaRichness
97
*observation_--cust_cvs_lengthSoilProbe
98
*observation_--cust_cvs_percentHistosol
99
*observation_--cust_cvs_percentBedrock
100
*observation_--cust_cvs_percentBoulder
101
*observation_--cust_cvs_percentGravelCobble
102
*observation_--cust_cvs_percentMineralSoil
103
*observation_--cust_cvs_percentCWD
104
*observation_--cust_cvs_percentFWD
105
*observation_--cust_cvs_percentDuff
106
*observation_--cust_cvs_percentLitter
107
*observation_--cust_cvs_percentNonVasc
108
*observation_--cust_cvs_percentWater
109
*observation_--cust_cvs_percentOther
110
*observation_--cust_cvs_percentOtherName
111
*observation_--cust_cvs_samplingLevel
112
*observation_--cust_cvs_postDsgPoly
113
*observation_--cust_cvs_stemsSampled
114
*observation_--cust_cvs_stemSamplingNarrative
115
*observation_--cust_eep_plotLastPlantedDate
116
*observation_--cust_eep_plotNotSampled
117
*observation_--cust_eep_plotNotSampledReason
118
*observation_--entry_ares_herbs
119
*observation_--entry_ares_trees
120
*observation_--entry_currentLandUse
121
*observation_--entry_depth
122
*observation_--entry_elevationUnits
123
*observation_--entry_formerLandUse
124
*observation_--entry_identificationNarrative
125
*observation_--entry_IntensiveModuleList
126
*observation_--entry_moduleSize_Overall
127
*observation_--entry_moduleSizeX
128
*observation_--entry_moduleSizeY
129
*observation_--entry_photosTaken
130
*observation_--entry_physClass
131
*observation_--entry_plot_X
132
*observation_--entry_plot_Y
133
*observation_--entry_soilModulesSampled
134
*observation_--entry_subsequentObsNum
135
*observation_--entry_taxonomicAuthority_ID
136
*observation_--entry_taxonomicAuthorityDate
137
*observation_--entry_team
138
*observation_--entry_plot
139
*observation_--entry_numberOfModules
140
*observation_--errors
141
*observation_--dba_src_ID
142
*observation_--dba_notes
143
*observation_--numberOfTaxa
144
*observation_--SOILOBS_ID
145
*observation_--soilHorizon
146
*observation_--soilDepthTop
147
*observation_--soilDepthBottom
148
*observation_--soilColor
149
*observation_--soilCoarse
150
*observation_--soilDescription
151
*observation_--cust_cvs_collectionName
152
*observation_--cust_cvs_Lab
153
*observation_--cust_cvs_N
154
*observation_--cust_cvs_S
155
*observation_--cust_cvs_P
156
*observation_--cust_cvs_Ca_ppm
157
*observation_--cust_cvs_Mg_ppm
158
*observation_--cust_cvs_K_ppm
159
*observation_--cust_cvs_Na_ppm
160
*observation_--cust_cvs_percent_Ca
161
*observation_--cust_cvs_percent_Mg
162
*observation_--cust_cvs_percent_K
163
*observation_--cust_cvs_percent_Na
164
*observation_--cust_cvs_percent_Othr
165
*observation_--cust_cvs_percent_H
166
*observation_--cust_cvs_B_ppm
167
*observation_--cust_cvs_Fe_ppm
168
*observation_--cust_cvs_Mn_ppm
169
*observation_--cust_cvs_Cu_ppm
170
*observation_--cust_cvs_Zn_ppm
171
*observation_--cust_cvs_Al_ppm
172
*observation_--cust_cvs_Density
173
*observation_--cust_cvs_Ca_over_Mg_ppm
174
*observation_--soilObs_dba_src_ID
inputs/CVS/taxonObservation_/map.csv
1 1
CVS,VegCore,Filter,Comments
2
PLANTCONCEPT_ID,*PLANTCONCEPT_ID,,
2
PLANTCONCEPT_ID,*taxonObservation_--PLANTCONCEPT_ID,,
3 3
TAXONOBSERVATION_ID,taxonOccurrenceID,,
4 4
OBSERVATION_ID,eventID,,
5 5
authorPlantName,originalTaxonName,,
6
taxonObservation_reference_ID,*taxonObservation_reference_ID,,
7
currentTaxonInterpPlantConcept_ID,*currentTaxonInterpPlantConcept_ID,,
8
taxonInferenceArea,*taxonInferenceArea,,
9
taxonObservation_accessionCode,*taxonObservation_accessionCode,,
10
taxonObservation_dba_src_ID,*taxonObservation_dba_src_ID,,
11
cust_cvs_corner1Presence,*cust_cvs_corner1Presence,,
12
cust_cvs_corner2Presence,*cust_cvs_corner2Presence,,
13
cust_cvs_corner3Presence,*cust_cvs_corner3Presence,,
14
cust_cvs_corner4Presence,*cust_cvs_corner4Presence,,
15
cust_cvs_corner5Presence,*cust_cvs_corner5Presence,,
16
entry_herbLineID,*entry_herbLineID,,
17
entry_treeLineID,*entry_treeLineID,,
18
taxonObservation_entry_sppID,*taxonObservation_entry_sppID,,
19
entry_unknownSp,*entry_unknownSp,,
20
entry_sortOrder,*entry_sortOrder,,
21
cust_cvs_collectionFlag,*cust_cvs_collectionFlag,,
22
taxonObservationNotes,*taxonObservationNotes,,
23
temp_taxonUpToDate,*temp_taxonUpToDate,,
24
TAXONINTERPRETATION_ID,*TAXONINTERPRETATION_ID,,
6
taxonObservation_reference_ID,*taxonObservation_--taxonObservation_reference_ID,,
7
currentTaxonInterpPlantConcept_ID,*taxonObservation_--currentTaxonInterpPlantConcept_ID,,
8
taxonInferenceArea,*taxonObservation_--taxonInferenceArea,,
9
taxonObservation_accessionCode,*taxonObservation_--taxonObservation_accessionCode,,
10
taxonObservation_dba_src_ID,*taxonObservation_--taxonObservation_dba_src_ID,,
11
cust_cvs_corner1Presence,*taxonObservation_--cust_cvs_corner1Presence,,
12
cust_cvs_corner2Presence,*taxonObservation_--cust_cvs_corner2Presence,,
13
cust_cvs_corner3Presence,*taxonObservation_--cust_cvs_corner3Presence,,
14
cust_cvs_corner4Presence,*taxonObservation_--cust_cvs_corner4Presence,,
15
cust_cvs_corner5Presence,*taxonObservation_--cust_cvs_corner5Presence,,
16
entry_herbLineID,*taxonObservation_--entry_herbLineID,,
17
entry_treeLineID,*taxonObservation_--entry_treeLineID,,
18
taxonObservation_entry_sppID,*taxonObservation_--taxonObservation_entry_sppID,,
19
entry_unknownSp,*taxonObservation_--entry_unknownSp,,
20
entry_sortOrder,*taxonObservation_--entry_sortOrder,,
21
cust_cvs_collectionFlag,*taxonObservation_--cust_cvs_collectionFlag,,
22
taxonObservationNotes,*taxonObservation_--taxonObservationNotes,,
23
temp_taxonUpToDate,*taxonObservation_--temp_taxonUpToDate,,
24
TAXONINTERPRETATION_ID,*taxonObservation_--TAXONINTERPRETATION_ID,,
25 25
stemLocation_ID,stemID,,
26 26
interpretationDate,dateIdentified,,
27
taxonInterpretation_PLANTNAME_ID,*taxonInterpretation_PLANTNAME_ID,,
28
taxonInterpretation_PARTY_ID,*taxonInterpretation_PARTY_ID,,
29
ROLE_ID,*ROLE_ID,,
27
taxonInterpretation_PLANTNAME_ID,*taxonObservation_--taxonInterpretation_PLANTNAME_ID,,
28
taxonInterpretation_PARTY_ID,*taxonObservation_--taxonInterpretation_PARTY_ID,,
29
ROLE_ID,*taxonObservation_--ROLE_ID,,
30 30
interpretationType,identificationType,,
31
reference_ID,*reference_ID,,
31
reference_ID,*taxonObservation_--reference_ID,,
32 32
originalInterpretation,taxon_determination__is_original,,
33 33
currentInterpretation,taxon_determination__is_current,,
34 34
taxonFit,identificationQualifier,,
......
36 36
collector_ID,UNUSED#collector_ID,,
37 37
collectionNumber,collectorNumber,,
38 38
collectionDate,dateCollected,,
39
museum_ID,*museum_ID,,
39
museum_ID,*taxonObservation_--museum_ID,,
40 40
museumAccessionNumber,accessionNumber,,
41
groupType,*groupType,,
41
groupType,*taxonObservation_--groupType,,
42 42
notes,occurrenceRemarks,,
43
notesPublic,*notesPublic,,
44
notesMgt,*notesMgt,,
45
revisions,*revisions,,
46
taxonInterpretation_dba_src_ID,*taxonInterpretation_dba_src_ID,,
47
taxonInterpretation_accessionCode,*taxonInterpretation_accessionCode,,
48
*PLANTNAME_ID,*PLANTNAME_ID,,
49
*plantConcept_reference_ID,*plantConcept_reference_ID,,
43
notesPublic,*taxonObservation_--notesPublic,,
44
notesMgt,*taxonObservation_--notesMgt,,
45
revisions,*taxonObservation_--revisions,,
46
taxonInterpretation_dba_src_ID,*taxonObservation_--taxonInterpretation_dba_src_ID,,
47
taxonInterpretation_accessionCode,*taxonObservation_--taxonInterpretation_accessionCode,,
48
*PLANTNAME_ID,*taxonObservation_--PLANTNAME_ID,,
49
*plantConcept_reference_ID,*taxonObservation_--plantConcept_reference_ID,,
50 50
taxonName,taxonName,,
51 51
scientificName,scientificName,,
52
*plantCode,*plantCode,,
53
*plantDescription,*plantDescription,,
54
*plantConcept_accessionCode,*plantConcept_accessionCode,,
55
*plantConcept_dba_src_ID,*plantConcept_dba_src_ID,,
56
*plantConcept_entry_sppID,*plantConcept_entry_sppID,,
57
*USDAPlantsCode,*USDAPlantsCode,,
58
*VascularPlant,*VascularPlant,,
52
*plantCode,*taxonObservation_--plantCode,,
53
*plantDescription,*taxonObservation_--plantDescription,,
54
*plantConcept_accessionCode,*taxonObservation_--plantConcept_accessionCode,,
55
*plantConcept_dba_src_ID,*taxonObservation_--plantConcept_dba_src_ID,,
56
*plantConcept_entry_sppID,*taxonObservation_--plantConcept_entry_sppID,,
57
*USDAPlantsCode,*taxonObservation_--USDAPlantsCode,,
58
*VascularPlant,*taxonObservation_--VascularPlant,,
59 59
kingdom,kingdom,,
60 60
division_main,division_main,,"must be _alt-ed with Division because this is missing in 2 rows that have Division, and different from Division in 1 row"
61
*category,*category,,
61
*category,*taxonObservation_--category,,
62 62
family,family,,
63 63
genus_main,genus_main,,must be _alt-ed with genus because this is missing in 1 row that has genus
64 64
specificEpithet,specificEpithet,,"unlike VegBank, this is in fact the epithet, not the full name"
......
66 66
infraspecificEpithet,infraspecificEpithet,,
67 67
infraspecificRank2,infraspecificRank2,,sometimes misparsed as the last + sign in the plantNameWithAuthority
68 68
infraspecificEpithet2,infraspecificEpithet2,,sometimes misparsed as the part after the last + sign in the plantNameWithAuthority
69
*hybridX,*hybridX,,
69
*hybridX,*taxonObservation_--hybridX,,
70 70
taxonRank,taxonRank,,
71 71
OMIT#taxonRank,OMIT#taxonRank,,Omitted because taxonLevel contains this information in text form
72
*lowestParentName,*lowestParentName,,
73
*lowestParentConcept_ID,*lowestParentConcept_ID,,
74
*lowestChildRank,*lowestChildRank,,
72
*lowestParentName,*taxonObservation_--lowestParentName,,
73
*lowestParentConcept_ID,*taxonObservation_--lowestParentConcept_ID,,
74
*lowestChildRank,*taxonObservation_--lowestChildRank,,
75 75
vernacularName,vernacularName,,
76
*growthForm_short,*growthForm_short,,
77
*woody,*woody,,
78
*exotic,*exotic,,
79
*usda_code,*usda_code,,
80
*usda_growthForm,*usda_growthForm,,
81
*sensitiveSpeciesFuzzPlot,*sensitiveSpeciesFuzzPlot,,
76
*growthForm_short,*taxonObservation_--growthForm_short,,
77
*woody,*taxonObservation_--woody,,
78
*exotic,*taxonObservation_--exotic,,
79
*usda_code,*taxonObservation_--usda_code,,
80
*usda_growthForm,*taxonObservation_--usda_growthForm,,
81
*sensitiveSpeciesFuzzPlot,*taxonObservation_--sensitiveSpeciesFuzzPlot,,
82 82
DUPLICATE#of:denorm_kingdom#Kingdom,DUPLICATE#of:denorm_kingdom#Kingdom,,
83
*Subkingdom,*Subkingdom,,
83
*Subkingdom,*taxonObservation_--Subkingdom,,
84 84
division_normalized,division_normalized,,
85 85
class,class,,
86
*Subclass,*Subclass,,
86
*Subclass,*taxonObservation_--Subclass,,
87 87
order,order,,
88
*composite family,*composite family,,
88
*composite family,*taxonObservation_--composite family,,
89 89
DUPLICATE#of:denorm_family#family,DUPLICATE#of:denorm_family#family,,
90
*tribe,*tribe,,
91
*composite genus,*composite genus,,
90
*tribe,*taxonObservation_--tribe,,
91
*composite genus,*taxonObservation_--composite genus,,
92 92
genus_normalized,genus_normalized,,"unlike VegBank, does *not* include genus author"
93 93
subgenus,subgenus,,
94
*section,*section,,
95
*composite species,*composite species,,
94
*section,*taxonObservation_--section,,
95
*composite species,*taxonObservation_--composite species,,
96 96
speciesBinomial,speciesBinomial,,full taxonomic name at that rank
97 97
EQUIV#to:species#subspecies,EQUIV#to:species#subspecies,,full taxonomic name at that rank
98 98
EQUIV#to:species#composite variety,EQUIV#to:species#composite variety,,full taxonomic name at that rank
99 99
EQUIV#to:species#variety,EQUIV#to:species#variety,,full taxonomic name at that rank
100
division,*division,,
100
division,*taxonObservation_--division,,
101 101
genus,genus,,
102 102
:plot,observationGranularity,,
inputs/CVS/taxonObservation_/new_terms.csv
1
PLANTCONCEPT_ID,*taxonObservation_--PLANTCONCEPT_ID,,
1 2
OBSERVATION_ID,eventID,,
3
currentTaxonInterpPlantConcept_ID,*taxonObservation_--currentTaxonInterpPlantConcept_ID,,
4
taxonInferenceArea,*taxonObservation_--taxonInferenceArea,,
5
taxonObservation_accessionCode,*taxonObservation_--taxonObservation_accessionCode,,
6
taxonObservation_dba_src_ID,*taxonObservation_--taxonObservation_dba_src_ID,,
7
cust_cvs_corner1Presence,*taxonObservation_--cust_cvs_corner1Presence,,
8
cust_cvs_corner2Presence,*taxonObservation_--cust_cvs_corner2Presence,,
9
cust_cvs_corner3Presence,*taxonObservation_--cust_cvs_corner3Presence,,
10
cust_cvs_corner4Presence,*taxonObservation_--cust_cvs_corner4Presence,,
11
cust_cvs_corner5Presence,*taxonObservation_--cust_cvs_corner5Presence,,
12
entry_herbLineID,*taxonObservation_--entry_herbLineID,,
13
entry_treeLineID,*taxonObservation_--entry_treeLineID,,
14
taxonObservation_entry_sppID,*taxonObservation_--taxonObservation_entry_sppID,,
15
entry_unknownSp,*taxonObservation_--entry_unknownSp,,
16
entry_sortOrder,*taxonObservation_--entry_sortOrder,,
17
cust_cvs_collectionFlag,*taxonObservation_--cust_cvs_collectionFlag,,
18
taxonObservationNotes,*taxonObservation_--taxonObservationNotes,,
19
temp_taxonUpToDate,*taxonObservation_--temp_taxonUpToDate,,
20
TAXONINTERPRETATION_ID,*taxonObservation_--TAXONINTERPRETATION_ID,,
2 21
stemLocation_ID,stemID,,
3 22
interpretationDate,dateIdentified,,
23
taxonInterpretation_PLANTNAME_ID,*taxonObservation_--taxonInterpretation_PLANTNAME_ID,,
24
taxonInterpretation_PARTY_ID,*taxonObservation_--taxonInterpretation_PARTY_ID,,
25
ROLE_ID,*taxonObservation_--ROLE_ID,,
26
reference_ID,*taxonObservation_--reference_ID,,
4 27
collectionDate,dateCollected,,
28
museum_ID,*taxonObservation_--museum_ID,,
29
groupType,*taxonObservation_--groupType,,
30
notesPublic,*taxonObservation_--notesPublic,,
31
notesMgt,*taxonObservation_--notesMgt,,
32
revisions,*taxonObservation_--revisions,,
33
taxonInterpretation_dba_src_ID,*taxonObservation_--taxonInterpretation_dba_src_ID,,
34
taxonInterpretation_accessionCode,*taxonObservation_--taxonInterpretation_accessionCode,,
35
*PLANTNAME_ID,*taxonObservation_--PLANTNAME_ID,,
36
*plantConcept_reference_ID,*taxonObservation_--plantConcept_reference_ID,,
37
*plantCode,*taxonObservation_--plantCode,,
38
*plantDescription,*taxonObservation_--plantDescription,,
39
*plantConcept_accessionCode,*taxonObservation_--plantConcept_accessionCode,,
40
*plantConcept_dba_src_ID,*taxonObservation_--plantConcept_dba_src_ID,,
41
*plantConcept_entry_sppID,*taxonObservation_--plantConcept_entry_sppID,,
42
*USDAPlantsCode,*taxonObservation_--USDAPlantsCode,,
43
*VascularPlant,*taxonObservation_--VascularPlant,,
44
*category,*taxonObservation_--category,,
45
*hybridX,*taxonObservation_--hybridX,,
46
*lowestParentName,*taxonObservation_--lowestParentName,,
47
*lowestParentConcept_ID,*taxonObservation_--lowestParentConcept_ID,,
48
*lowestChildRank,*taxonObservation_--lowestChildRank,,
49
*growthForm_short,*taxonObservation_--growthForm_short,,
50
*woody,*taxonObservation_--woody,,
51
*exotic,*taxonObservation_--exotic,,
52
*usda_code,*taxonObservation_--usda_code,,
53
*usda_growthForm,*taxonObservation_--usda_growthForm,,
54
*sensitiveSpeciesFuzzPlot,*taxonObservation_--sensitiveSpeciesFuzzPlot,,
55
*Subkingdom,*taxonObservation_--Subkingdom,,
56
*Subclass,*taxonObservation_--Subclass,,
57
*composite family,*taxonObservation_--composite family,,
58
*tribe,*taxonObservation_--tribe,,
59
*composite genus,*taxonObservation_--composite genus,,
60
*section,*taxonObservation_--section,,
61
*composite species,*taxonObservation_--composite species,,
62
division,*taxonObservation_--division,,
... This diff was truncated because it exceeds the maximum size that can be displayed.

Also available in: Unified diff