Revision 11754
Added by Aaron Marcuse-Kubitza about 11 years ago
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,, |
Also available in: Unified diff
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