Project

General

Profile

« Previous | Next » 

Revision 10944

Added by Aaron Marcuse-Kubitza about 11 years ago

inputs/VegBank/: 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/VegBank/stemcount_/map.csv
9 9 
GROUP BY taxonobservation_id
10 10 
HAVING count(distinct taxonimportance_id) > 1
11 11 
-----"
12 
stratum_id,*stratum_id,,
12 
stratum_id,*stemcount_--stratum_id,,
13 13 
cover,coverPercent,,
14 
basalarea,*basalarea,,
15 
biomass,*biomass,,
16 
inferencearea,*inferencearea,,
17 
stratumbase,*stratumbase,,
18 
stratumheight,*stratumheight,,
19 
emb_taxonimportance,*emb_taxonimportance,,
20 
covercode,*covercode,,
14 
basalarea,*stemcount_--basalarea,,
15 
biomass,*stemcount_--biomass,,
16 
inferencearea,*stemcount_--inferencearea,,
17 
stratumbase,*stemcount_--stratumbase,,
18 
stratumheight,*stemcount_--stratumheight,,
19 
emb_taxonimportance,*stemcount_--emb_taxonimportance,,
20 
covercode,*stemcount_--covercode,,
21 21 
stemcount_id,aggregateOrganismObservationID__individual_count,,
22 22 
stemdiameter,diameterBreastHeight_cm,,"""The diameter of the stem in centimeters"" (stemDiameter definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemcount&entity=dba_tabledescription&where=where_tablename>)"
23 
stemdiameteraccuracy,*stemdiameteraccuracy,,
23 
stemdiameteraccuracy,*stemcount_--stemdiameteraccuracy,,
24 24 
stemheight,height_m,,"""The measured height of the stem in meters"" (stemHeight definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemcount&entity=dba_tabledescription&where=where_tablename>)"
25 
stemheightaccuracy,*stemheightaccuracy,,
25 
stemheightaccuracy,*stemcount_--stemheightaccuracy,,
26 26 
stemcount,individualCount,,
27 
stemtaxonarea,*stemtaxonarea,,
28 
emb_stemcount,*emb_stemcount,,
27 
stemtaxonarea,*stemcount_--stemtaxonarea,,
28 
emb_stemcount,*stemcount_--emb_stemcount,,
inputs/VegBank/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 
stratumbase,*stemcount_--stratumbase,,
8 
stratumheight,*stemcount_--stratumheight,,
9 
emb_taxonimportance,*stemcount_--emb_taxonimportance,,
10 
covercode,*stemcount_--covercode,,
3 11 
stemcount_id,aggregateOrganismObservationID__individual_count,,
4 12 
stemdiameter,diameterBreastHeight_cm,,"""The diameter of the stem in centimeters"" (stemDiameter definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemcount&entity=dba_tabledescription&where=where_tablename>)"
13 
stemdiameteraccuracy,*stemcount_--stemdiameteraccuracy,,
14 
stemheightaccuracy,*stemcount_--stemheightaccuracy,,
15 
stemtaxonarea,*stemcount_--stemtaxonarea,,
16 
emb_stemcount,*stemcount_--emb_stemcount,,
inputs/VegBank/stemcount_/unmapped_terms.csv
1 1 
aggregateOrganismObservationID__taxon_presence
2 
*stratum_id
3 
*basalarea
4 
*biomass
5 
*inferencearea
6 
*stratumbase
7 
*stratumheight
8 
*emb_taxonimportance
9 
*covercode
2 
*stemcount_--stratum_id
3 
*stemcount_--basalarea
4 
*stemcount_--biomass
5 
*stemcount_--inferencearea
6 
*stemcount_--stratumbase
7 
*stemcount_--stratumheight
8 
*stemcount_--emb_taxonimportance
9 
*stemcount_--covercode
10 10 
aggregateOrganismObservationID__individual_count
11 
*stemdiameteraccuracy
12 
*stemheightaccuracy
13 
*stemtaxonarea
14 
*emb_stemcount
11 
*stemcount_--stemdiameteraccuracy
12 
*stemcount_--stemheightaccuracy
13 
*stemcount_--stemtaxonarea
14 
*stemcount_--emb_stemcount
inputs/VegBank/observation_/map.csv
1 1 
VegBank,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 
dateaccuracy,*dateaccuracy,,
8 
covermethod_id,*covermethod_id,,
9 
coverdispersion,*coverdispersion,,
10 
autotaxoncover,*autotaxoncover,,
11 
stratummethod_id,*stratummethod_id,,
7 
dateaccuracy,*observation_--dateaccuracy,,
8 
covermethod_id,*observation_--covermethod_id,,
9 
coverdispersion,*observation_--coverdispersion,,
10 
autotaxoncover,*observation_--autotaxoncover,,
11 
stratummethod_id,*observation_--stratummethod_id,,
12 12 
methodnarrative,samplingProtocol,,
13 
taxonobservationarea,*taxonobservationarea,,
14 
stemsizelimit,*stemsizelimit,,
15 
stemobservationarea,*stemobservationarea,,
16 
stemsamplemethod,*stemsamplemethod,,
17 
originaldata,*originaldata,,
18 
effortlevel,*effortlevel,,
19 
plotvalidationlevel,*plotvalidationlevel,,
20 
floristicquality,*floristicquality,,
21 
bryophytequality,*bryophytequality,,
22 
lichenquality,*lichenquality,,
23 
observationnarrative,*observationnarrative,,
24 
landscapenarrative,*landscapenarrative,,
25 
homogeneity,*homogeneity,,
26 
phenologicaspect,*phenologicaspect,,
27 
representativeness,*representativeness,,
28 
standmaturity,*standmaturity,,
29 
successionalstatus,*successionalstatus,,
30 
basalarea,*basalarea,,
31 
hydrologicregime,*hydrologicregime,,
32 
soilmoistureregime,*soilmoistureregime,,
33 
soildrainage,*soildrainage,,
34 
watersalinity,*watersalinity,,
35 
waterdepth,*waterdepth,,
36 
shoredistance,*shoredistance,,
37 
soildepth,*soildepth,,
38 
organicdepth,*organicdepth,,
39 
soiltaxon_id,*soiltaxon_id,,
40 
soiltaxonsrc,*soiltaxonsrc,,
41 
percentbedrock,*percentbedrock,,
42 
percentrockgravel,*percentrockgravel,,
43 
percentwood,*percentwood,,
44 
percentlitter,*percentlitter,,
45 
percentbaresoil,*percentbaresoil,,
46 
percentwater,*percentwater,,
47 
percentother,*percentother,,
48 
nameother,*nameother,,
49 
treeht,*treeht,,
50 
shrubht,*shrubht,,
51 
fieldht,*fieldht,,
52 
nonvascularht,*nonvascularht,,
53 
submergedht,*submergedht,,
54 
treecover,*treecover,,
55 
shrubcover,*shrubcover,,
56 
fieldcover,*fieldcover,,
57 
nonvascularcover,*nonvascularcover,,
58 
floatingcover,*floatingcover,,
59 
submergedcover,*submergedcover,,
60 
dominantstratum,*dominantstratum,,
61 
growthform1type,*growthform1type,,
62 
growthform2type,*growthform2type,,
63 
growthform3type,*growthform3type,,
64 
growthform1cover,*growthform1cover,,
65 
growthform2cover,*growthform2cover,,
66 
growthform3cover,*growthform3cover,,
67 
totalcover,*totalcover,,
68 
notespublic,*notespublic,,
69 
notesmgt,*notesmgt,,
70 
revisions,*revisions,,
13 
taxonobservationarea,*observation_--taxonobservationarea,,
14 
stemsizelimit,*observation_--stemsizelimit,,
15 
stemobservationarea,*observation_--stemobservationarea,,
16 
stemsamplemethod,*observation_--stemsamplemethod,,
17 
originaldata,*observation_--originaldata,,
18 
effortlevel,*observation_--effortlevel,,
19 
plotvalidationlevel,*observation_--plotvalidationlevel,,
20 
floristicquality,*observation_--floristicquality,,
21 
bryophytequality,*observation_--bryophytequality,,
22 
lichenquality,*observation_--lichenquality,,
23 
observationnarrative,*observation_--observationnarrative,,
24 
landscapenarrative,*observation_--landscapenarrative,,
25 
homogeneity,*observation_--homogeneity,,
26 
phenologicaspect,*observation_--phenologicaspect,,
27 
representativeness,*observation_--representativeness,,
28 
standmaturity,*observation_--standmaturity,,
29 
successionalstatus,*observation_--successionalstatus,,
30 
basalarea,*observation_--basalarea,,
31 
hydrologicregime,*observation_--hydrologicregime,,
32 
soilmoistureregime,*observation_--soilmoistureregime,,
33 
soildrainage,*observation_--soildrainage,,
34 
watersalinity,*observation_--watersalinity,,
35 
waterdepth,*observation_--waterdepth,,
36 
shoredistance,*observation_--shoredistance,,
37 
soildepth,*observation_--soildepth,,
38 
organicdepth,*observation_--organicdepth,,
39 
soiltaxon_id,*observation_--soiltaxon_id,,
40 
soiltaxonsrc,*observation_--soiltaxonsrc,,
41 
percentbedrock,*observation_--percentbedrock,,
42 
percentrockgravel,*observation_--percentrockgravel,,
43 
percentwood,*observation_--percentwood,,
44 
percentlitter,*observation_--percentlitter,,
45 
percentbaresoil,*observation_--percentbaresoil,,
46 
percentwater,*observation_--percentwater,,
47 
percentother,*observation_--percentother,,
48 
nameother,*observation_--nameother,,
49 
treeht,*observation_--treeht,,
50 
shrubht,*observation_--shrubht,,
51 
fieldht,*observation_--fieldht,,
52 
nonvascularht,*observation_--nonvascularht,,
53 
submergedht,*observation_--submergedht,,
54 
treecover,*observation_--treecover,,
55 
shrubcover,*observation_--shrubcover,,
56 
fieldcover,*observation_--fieldcover,,
57 
nonvascularcover,*observation_--nonvascularcover,,
58 
floatingcover,*observation_--floatingcover,,
59 
submergedcover,*observation_--submergedcover,,
60 
dominantstratum,*observation_--dominantstratum,,
61 
growthform1type,*observation_--growthform1type,,
62 
growthform2type,*observation_--growthform2type,,
63 
growthform3type,*observation_--growthform3type,,
64 
growthform1cover,*observation_--growthform1cover,,
65 
growthform2cover,*observation_--growthform2cover,,
66 
growthform3cover,*observation_--growthform3cover,,
67 
totalcover,*observation_--totalcover,,
68 
notespublic,*observation_--notespublic,,
69 
notesmgt,*observation_--notesmgt,,
70 
revisions,*observation_--revisions,,
71 71 
obsstartdate,startDate,,
72 72 
obsenddate,endDate,,
73 
dateentered,*dateentered,,
74 
emb_observation,*emb_observation,,
75 
interp_orig_ci_id,*interp_orig_ci_id,,
76 
interp_orig_cc_id,*interp_orig_cc_id,,
77 
interp_orig_sciname,*interp_orig_sciname,,
78 
interp_orig_code,*interp_orig_code,,
79 
interp_orig_party_id,*interp_orig_party_id,,
80 
interp_orig_partyname,*interp_orig_partyname,,
81 
interp_current_ci_id,*interp_current_ci_id,,
82 
interp_current_cc_id,*interp_current_cc_id,,
83 
interp_current_sciname,*interp_current_sciname,,
84 
interp_current_code,*interp_current_code,,
85 
interp_current_party_id,*interp_current_party_id,,
86 
interp_current_partyname,*interp_current_partyname,,
87 
interp_bestfit_ci_id,*interp_bestfit_ci_id,,
88 
interp_bestfit_cc_id,*interp_bestfit_cc_id,,
89 
interp_bestfit_sciname,*interp_bestfit_sciname,,
90 
interp_bestfit_code,*interp_bestfit_code,,
91 
interp_bestfit_party_id,*interp_bestfit_party_id,,
92 
interp_bestfit_partyname,*interp_bestfit_partyname,,
93 
toptaxon1name,*toptaxon1name,,
94 
toptaxon2name,*toptaxon2name,,
95 
toptaxon3name,*toptaxon3name,,
96 
toptaxon4name,*toptaxon4name,,
97 
toptaxon5name,*toptaxon5name,,
98 
numberoftaxa,*numberoftaxa,,
99 
accessioncode,*accessioncode,,
100 
soilobs_id,*soilobs_id,,
101 
soilhorizon,*soilhorizon,,
102 
soildepthtop,*soildepthtop,,
103 
soildepthbottom,*soildepthbottom,,
104 
soilcolor,*soilcolor,,
73 
dateentered,*observation_--dateentered,,
74 
emb_observation,*observation_--emb_observation,,
75 
interp_orig_ci_id,*observation_--interp_orig_ci_id,,
76 
interp_orig_cc_id,*observation_--interp_orig_cc_id,,
77 
interp_orig_sciname,*observation_--interp_orig_sciname,,
78 
interp_orig_code,*observation_--interp_orig_code,,
79 
interp_orig_party_id,*observation_--interp_orig_party_id,,
80 
interp_orig_partyname,*observation_--interp_orig_partyname,,
81 
interp_current_ci_id,*observation_--interp_current_ci_id,,
82 
interp_current_cc_id,*observation_--interp_current_cc_id,,
83 
interp_current_sciname,*observation_--interp_current_sciname,,
84 
interp_current_code,*observation_--interp_current_code,,
85 
interp_current_party_id,*observation_--interp_current_party_id,,
86 
interp_current_partyname,*observation_--interp_current_partyname,,
87 
interp_bestfit_ci_id,*observation_--interp_bestfit_ci_id,,
88 
interp_bestfit_cc_id,*observation_--interp_bestfit_cc_id,,
89 
interp_bestfit_sciname,*observation_--interp_bestfit_sciname,,
90 
interp_bestfit_code,*observation_--interp_bestfit_code,,
91 
interp_bestfit_party_id,*observation_--interp_bestfit_party_id,,
92 
interp_bestfit_partyname,*observation_--interp_bestfit_partyname,,
93 
toptaxon1name,*observation_--toptaxon1name,,
94 
toptaxon2name,*observation_--toptaxon2name,,
95 
toptaxon3name,*observation_--toptaxon3name,,
96 
toptaxon4name,*observation_--toptaxon4name,,
97 
toptaxon5name,*observation_--toptaxon5name,,
98 
numberoftaxa,*observation_--numberoftaxa,,
99 
accessioncode,*observation_--accessioncode,,
100 
soilobs_id,*observation_--soilobs_id,,
101 
soilhorizon,*observation_--soilhorizon,,
102 
soildepthtop,*observation_--soildepthtop,,
103 
soildepthbottom,*observation_--soildepthbottom,,
104 
soilcolor,*observation_--soilcolor,,
105 105 
soilorganic,organic_percent,,"""Percent organic content of the soil"" (soilOrganic definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilobs&entity=dba_tabledescription&where=where_tablename>)"
106 106 
soiltexture,texture,,
107 107 
soilsand,sand_percent,,"""Percent sand in the soil horizon"" (soilSand definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilobs&entity=dba_tabledescription&where=where_tablename>)"
108 108 
soilsilt,silt_percent,,"""Percent silt in the soil horizon"" (soilSilt definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilobs&entity=dba_tabledescription&where=where_tablename>)"
109 109 
soilclay,clay_percent,,"""Percent clay in the soil horizon"" (soilClay definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilobs&entity=dba_tabledescription&where=where_tablename>)"
110 
soilcoarse,*soilcoarse,,"""percent coarse fragments in the soil"" (soilCoarse definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilobs&entity=dba_tabledescription&where=where_tablename>)"
110 
soilcoarse,*observation_--soilcoarse,,"""percent coarse fragments in the soil"" (soilCoarse definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilobs&entity=dba_tabledescription&where=where_tablename>)"
111 111 
soilph,ph,,
112 112 
exchangecapacity,cationExchangeCapacity_cmol_kg,,
113 113 
basesaturation,baseSaturation_percent,,"""Percent base saturation"" (baseSaturation definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilobs&entity=dba_tabledescription&where=where_tablename>)"
114 
soildescription,*soildescription,,
115 
emb_soilobs,*emb_soilobs,,
114 
soildescription,*observation_--soildescription,,
115 
emb_soilobs,*observation_--emb_soilobs,,
inputs/VegBank/observation_/new_terms.csv
1 1 
observation_id,eventID,,
2 
previousobs_id,*observation_--previousobs_id,,
3 
dateaccuracy,*observation_--dateaccuracy,,
4 
covermethod_id,*observation_--covermethod_id,,
5 
coverdispersion,*observation_--coverdispersion,,
6 
autotaxoncover,*observation_--autotaxoncover,,
7 
stratummethod_id,*observation_--stratummethod_id,,
2 8 
methodnarrative,samplingProtocol,,
9 
taxonobservationarea,*observation_--taxonobservationarea,,
10 
stemsizelimit,*observation_--stemsizelimit,,
11 
stemobservationarea,*observation_--stemobservationarea,,
12 
stemsamplemethod,*observation_--stemsamplemethod,,
13 
originaldata,*observation_--originaldata,,
14 
effortlevel,*observation_--effortlevel,,
15 
plotvalidationlevel,*observation_--plotvalidationlevel,,
16 
floristicquality,*observation_--floristicquality,,
17 
bryophytequality,*observation_--bryophytequality,,
18 
lichenquality,*observation_--lichenquality,,
19 
observationnarrative,*observation_--observationnarrative,,
20 
landscapenarrative,*observation_--landscapenarrative,,
21 
homogeneity,*observation_--homogeneity,,
22 
phenologicaspect,*observation_--phenologicaspect,,
23 
representativeness,*observation_--representativeness,,
24 
standmaturity,*observation_--standmaturity,,
25 
successionalstatus,*observation_--successionalstatus,,
26 
basalarea,*observation_--basalarea,,
27 
hydrologicregime,*observation_--hydrologicregime,,
28 
soilmoistureregime,*observation_--soilmoistureregime,,
29 
soildrainage,*observation_--soildrainage,,
30 
watersalinity,*observation_--watersalinity,,
31 
waterdepth,*observation_--waterdepth,,
32 
shoredistance,*observation_--shoredistance,,
33 
soildepth,*observation_--soildepth,,
34 
organicdepth,*observation_--organicdepth,,
35 
soiltaxon_id,*observation_--soiltaxon_id,,
36 
soiltaxonsrc,*observation_--soiltaxonsrc,,
37 
percentbedrock,*observation_--percentbedrock,,
38 
percentrockgravel,*observation_--percentrockgravel,,
39 
percentwood,*observation_--percentwood,,
40 
percentlitter,*observation_--percentlitter,,
41 
percentbaresoil,*observation_--percentbaresoil,,
42 
percentwater,*observation_--percentwater,,
43 
percentother,*observation_--percentother,,
44 
nameother,*observation_--nameother,,
45 
treeht,*observation_--treeht,,
46 
shrubht,*observation_--shrubht,,
47 
fieldht,*observation_--fieldht,,
48 
nonvascularht,*observation_--nonvascularht,,
49 
submergedht,*observation_--submergedht,,
50 
treecover,*observation_--treecover,,
51 
shrubcover,*observation_--shrubcover,,
52 
fieldcover,*observation_--fieldcover,,
53 
nonvascularcover,*observation_--nonvascularcover,,
54 
floatingcover,*observation_--floatingcover,,
55 
submergedcover,*observation_--submergedcover,,
56 
dominantstratum,*observation_--dominantstratum,,
57 
growthform1type,*observation_--growthform1type,,
58 
growthform2type,*observation_--growthform2type,,
59 
growthform3type,*observation_--growthform3type,,
60 
growthform1cover,*observation_--growthform1cover,,
61 
growthform2cover,*observation_--growthform2cover,,
62 
growthform3cover,*observation_--growthform3cover,,
63 
totalcover,*observation_--totalcover,,
64 
notespublic,*observation_--notespublic,,
65 
notesmgt,*observation_--notesmgt,,
66 
revisions,*observation_--revisions,,
67 
dateentered,*observation_--dateentered,,
68 
emb_observation,*observation_--emb_observation,,
69 
interp_orig_ci_id,*observation_--interp_orig_ci_id,,
70 
interp_orig_cc_id,*observation_--interp_orig_cc_id,,
71 
interp_orig_sciname,*observation_--interp_orig_sciname,,
72 
interp_orig_code,*observation_--interp_orig_code,,
73 
interp_orig_party_id,*observation_--interp_orig_party_id,,
74 
interp_orig_partyname,*observation_--interp_orig_partyname,,
75 
interp_current_ci_id,*observation_--interp_current_ci_id,,
76 
interp_current_cc_id,*observation_--interp_current_cc_id,,
77 
interp_current_sciname,*observation_--interp_current_sciname,,
78 
interp_current_code,*observation_--interp_current_code,,
79 
interp_current_party_id,*observation_--interp_current_party_id,,
80 
interp_current_partyname,*observation_--interp_current_partyname,,
81 
interp_bestfit_ci_id,*observation_--interp_bestfit_ci_id,,
82 
interp_bestfit_cc_id,*observation_--interp_bestfit_cc_id,,
83 
interp_bestfit_sciname,*observation_--interp_bestfit_sciname,,
84 
interp_bestfit_code,*observation_--interp_bestfit_code,,
85 
interp_bestfit_party_id,*observation_--interp_bestfit_party_id,,
86 
interp_bestfit_partyname,*observation_--interp_bestfit_partyname,,
87 
toptaxon1name,*observation_--toptaxon1name,,
88 
toptaxon2name,*observation_--toptaxon2name,,
89 
toptaxon3name,*observation_--toptaxon3name,,
90 
toptaxon4name,*observation_--toptaxon4name,,
91 
toptaxon5name,*observation_--toptaxon5name,,
92 
numberoftaxa,*observation_--numberoftaxa,,
93 
accessioncode,*observation_--accessioncode,,
94 
soilobs_id,*observation_--soilobs_id,,
95 
soilhorizon,*observation_--soilhorizon,,
96 
soildepthtop,*observation_--soildepthtop,,
97 
soildepthbottom,*observation_--soildepthbottom,,
98 
soilcolor,*observation_--soilcolor,,
99 
soilcoarse,*observation_--soilcoarse,,"""percent coarse fragments in the soil"" (soilCoarse definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=soilobs&entity=dba_tabledescription&where=where_tablename>)"
3 100 
soilph,ph,,
101 
soildescription,*observation_--soildescription,,
102 
emb_soilobs,*observation_--emb_soilobs,,
inputs/VegBank/observation_/unmapped_terms.csv
1 
*previousobs_id
2 
*dateaccuracy
3 
*covermethod_id
4 
*coverdispersion
5 
*autotaxoncover
6 
*stratummethod_id
7 
*taxonobservationarea
8 
*stemsizelimit
9 
*stemobservationarea
10 
*stemsamplemethod
11 
*originaldata
12 
*effortlevel
13 
*plotvalidationlevel
14 
*floristicquality
15 
*bryophytequality
16 
*lichenquality
17 
*observationnarrative
18 
*landscapenarrative
19 
*homogeneity
20 
*phenologicaspect
21 
*representativeness
22 
*standmaturity
23 
*successionalstatus
24 
*basalarea
25 
*hydrologicregime
26 
*soilmoistureregime
27 
*soildrainage
28 
*watersalinity
29 
*waterdepth
30 
*shoredistance
31 
*soildepth
32 
*organicdepth
33 
*soiltaxon_id
34 
*soiltaxonsrc
35 
*percentbedrock
36 
*percentrockgravel
37 
*percentwood
38 
*percentlitter
39 
*percentbaresoil
40 
*percentwater
41 
*percentother
42 
*nameother
43 
*treeht
44 
*shrubht
45 
*fieldht
46 
*nonvascularht
47 
*submergedht
48 
*treecover
49 
*shrubcover
50 
*fieldcover
51 
*nonvascularcover
52 
*floatingcover
53 
*submergedcover
54 
*dominantstratum
55 
*growthform1type
56 
*growthform2type
57 
*growthform3type
58 
*growthform1cover
59 
*growthform2cover
60 
*growthform3cover
61 
*totalcover
62 
*notespublic
63 
*notesmgt
64 
*revisions
65 
*dateentered
66 
*emb_observation
67 
*interp_orig_ci_id
68 
*interp_orig_cc_id
69 
*interp_orig_sciname
70 
*interp_orig_code
71 
*interp_orig_party_id
72 
*interp_orig_partyname
73 
*interp_current_ci_id
74 
*interp_current_cc_id
75 
*interp_current_sciname
76 
*interp_current_code
77 
*interp_current_party_id
78 
*interp_current_partyname
79 
*interp_bestfit_ci_id
80 
*interp_bestfit_cc_id
81 
*interp_bestfit_sciname
82 
*interp_bestfit_code
83 
*interp_bestfit_party_id
84 
*interp_bestfit_partyname
85 
*toptaxon1name
86 
*toptaxon2name
87 
*toptaxon3name
88 
*toptaxon4name
89 
*toptaxon5name
90 
*numberoftaxa
91 
*accessioncode
92 
*soilobs_id
93 
*soilhorizon
94 
*soildepthtop
95 
*soildepthbottom
96 
*soilcolor
97 
*soilcoarse
98 
*soildescription
99 
*emb_soilobs
1 
*observation_--previousobs_id
2 
*observation_--dateaccuracy
3 
*observation_--covermethod_id
4 
*observation_--coverdispersion
5 
*observation_--autotaxoncover
6 
*observation_--stratummethod_id
7 
*observation_--taxonobservationarea
8 
*observation_--stemsizelimit
9 
*observation_--stemobservationarea
10 
*observation_--stemsamplemethod
11 
*observation_--originaldata
12 
*observation_--effortlevel
13 
*observation_--plotvalidationlevel
14 
*observation_--floristicquality
15 
*observation_--bryophytequality
16 
*observation_--lichenquality
17 
*observation_--observationnarrative
18 
*observation_--landscapenarrative
19 
*observation_--homogeneity
20 
*observation_--phenologicaspect
21 
*observation_--representativeness
22 
*observation_--standmaturity
23 
*observation_--successionalstatus
24 
*observation_--basalarea
25 
*observation_--hydrologicregime
26 
*observation_--soilmoistureregime
27 
*observation_--soildrainage
28 
*observation_--watersalinity
29 
*observation_--waterdepth
30 
*observation_--shoredistance
31 
*observation_--soildepth
32 
*observation_--organicdepth
33 
*observation_--soiltaxon_id
34 
*observation_--soiltaxonsrc
35 
*observation_--percentbedrock
36 
*observation_--percentrockgravel
37 
*observation_--percentwood
38 
*observation_--percentlitter
39 
*observation_--percentbaresoil
40 
*observation_--percentwater
41 
*observation_--percentother
42 
*observation_--nameother
43 
*observation_--treeht
44 
*observation_--shrubht
45 
*observation_--fieldht
46 
*observation_--nonvascularht
47 
*observation_--submergedht
48 
*observation_--treecover
49 
*observation_--shrubcover
50 
*observation_--fieldcover
51 
*observation_--nonvascularcover
52 
*observation_--floatingcover
53 
*observation_--submergedcover
54 
*observation_--dominantstratum
55 
*observation_--growthform1type
56 
*observation_--growthform2type
57 
*observation_--growthform3type
58 
*observation_--growthform1cover
59 
*observation_--growthform2cover
60 
*observation_--growthform3cover
61 
*observation_--totalcover
62 
*observation_--notespublic
63 
*observation_--notesmgt
64 
*observation_--revisions
65 
*observation_--dateentered
66 
*observation_--emb_observation
67 
*observation_--interp_orig_ci_id
68 
*observation_--interp_orig_cc_id
69 
*observation_--interp_orig_sciname
70 
*observation_--interp_orig_code
71 
*observation_--interp_orig_party_id
72 
*observation_--interp_orig_partyname
73 
*observation_--interp_current_ci_id
74 
*observation_--interp_current_cc_id
75 
*observation_--interp_current_sciname
76 
*observation_--interp_current_code
77 
*observation_--interp_current_party_id
78 
*observation_--interp_current_partyname
79 
*observation_--interp_bestfit_ci_id
80 
*observation_--interp_bestfit_cc_id
81 
*observation_--interp_bestfit_sciname
82 
*observation_--interp_bestfit_code
83 
*observation_--interp_bestfit_party_id
84 
*observation_--interp_bestfit_partyname
85 
*observation_--toptaxon1name
86 
*observation_--toptaxon2name
87 
*observation_--toptaxon3name
88 
*observation_--toptaxon4name
89 
*observation_--toptaxon5name
90 
*observation_--numberoftaxa
91 
*observation_--accessioncode
92 
*observation_--soilobs_id
93 
*observation_--soilhorizon
94 
*observation_--soildepthtop
95 
*observation_--soildepthbottom
96 
*observation_--soilcolor
97 
*observation_--soilcoarse
98 
*observation_--soildescription
99 
*observation_--emb_soilobs
inputs/VegBank/stemlocation_/map.csv
4 4 
stemcode,UNUSED#stemcode,,
5 5 
stemxposition,UNUSED#stemxposition,,"""The X-coordinate of the stem position in m"" (stemXPosition definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemlocation&entity=dba_tabledescription&where=where_tablename>)"
6 6 
stemyposition,UNUSED#stemyposition,,"""The Y-coordinate of the stem position, as above"" (stemYPosition definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemlocation&entity=dba_tabledescription&where=where_tablename>)"
7 
stemhealth,*stemhealth,,this *is* populated
8 
emb_stemlocation,*emb_stemlocation,,
7 
stemhealth,*stemlocation_--stemhealth,,this *is* populated
8 
emb_stemlocation,*stemlocation_--emb_stemlocation,,
9 9 
taxonimportance_id,aggregateOrganismObservationID__taxon_presence,,
10 10 
stemdiameter,diameterBreastHeight_cm,,"""The diameter of the stem in centimeters"" (stemDiameter definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemcount&entity=dba_tabledescription&where=where_tablename>)"
11 
stemdiameteraccuracy,*stemdiameteraccuracy,,
11 
stemdiameteraccuracy,*stemlocation_--stemdiameteraccuracy,,
12 12 
stemheight,height_m,,"""The measured height of the stem in meters"" (stemHeight definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemcount&entity=dba_tabledescription&where=where_tablename>)"
13 
stemheightaccuracy,*stemheightaccuracy,,
13 
stemheightaccuracy,*stemlocation_--stemheightaccuracy,,
14 14 
stemcount,individualCount,,
15 
stemtaxonarea,*stemtaxonarea,,
16 
emb_stemcount,*emb_stemcount,,
15 
stemtaxonarea,*stemlocation_--stemtaxonarea,,
16 
emb_stemcount,*stemlocation_--emb_stemcount,,
inputs/VegBank/stemlocation_/new_terms.csv
1 1 
stemcount_id,aggregateOrganismObservationID__individual_count,,
2 2 
stemlocation_id,stemID,,
3 
stemhealth,*stemlocation_--stemhealth,,this *is* populated
4 
emb_stemlocation,*stemlocation_--emb_stemlocation,,
3 5 
taxonimportance_id,aggregateOrganismObservationID__taxon_presence,,
4 6 
stemdiameter,diameterBreastHeight_cm,,"""The diameter of the stem in centimeters"" (stemDiameter definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=stemcount&entity=dba_tabledescription&where=where_tablename>)"
7 
stemdiameteraccuracy,*stemlocation_--stemdiameteraccuracy,,
8 
stemheightaccuracy,*stemlocation_--stemheightaccuracy,,
9 
stemtaxonarea,*stemlocation_--stemtaxonarea,,
10 
emb_stemcount,*stemlocation_--emb_stemcount,,
inputs/VegBank/stemlocation_/unmapped_terms.csv
1 1 
aggregateOrganismObservationID__individual_count
2 
*stemhealth
3 
*emb_stemlocation
2 
*stemlocation_--stemhealth
3 
*stemlocation_--emb_stemlocation
4 4 
aggregateOrganismObservationID__taxon_presence
5 
*stemdiameteraccuracy
6 
*stemheightaccuracy
7 
*stemtaxonarea
8 
*emb_stemcount
5 
*stemlocation_--stemdiameteraccuracy
6 
*stemlocation_--stemheightaccuracy
7 
*stemlocation_--stemtaxonarea
8 
*stemlocation_--emb_stemcount
inputs/VegBank/taxonobservation_/map.csv
1 1 
VegBank,VegCore,Filter,Comments
2 
plantname_id,*plantname_id,,
3 
plantconcept_id,*plantconcept_id,,
2 
plantname_id,*taxonobservation_--plantname_id,,
3 
plantconcept_id,*taxonobservation_--plantconcept_id,,
4 4 
taxonobservation_id,taxonOccurrenceID,,
5 5 
observation_id,eventID,,
6 6 
authorplantname,originalScientificName,,
7 
taxonobservation_reference_id,*taxonobservation_reference_id,,
8 
taxoninferencearea,*taxoninferencearea,,
9 
emb_taxonobservation,*emb_taxonobservation,,
10 
int_origplantconcept_id,*int_origplantconcept_id,,
7 
taxonobservation_reference_id,*taxonobservation_--taxonobservation_reference_id,,
8 
taxoninferencearea,*taxonobservation_--taxoninferencearea,,
9 
emb_taxonobservation,*taxonobservation_--emb_taxonobservation,,
10 
int_origplantconcept_id,*taxonobservation_--int_origplantconcept_id,,
11 11 
int_origplantscifull,EQUIV#to:authorplantname#int_origplantscifull,, = originalScientificName_scrubbed
12 12 
int_origplantscinamenoauth,originalTaxonName,,
13 13 
int_origplantcommon,originalVernacularName,,
14 
int_origplantcode,*int_origplantcode,,
15 
int_currplantconcept_id,*int_currplantconcept_id,,
14 
int_origplantcode,*taxonobservation_--int_origplantcode,,
15 
int_currplantconcept_id,*taxonobservation_--int_currplantconcept_id,,
16 16 
int_currplantscifull,scientificName_verbatim,,
17 17 
int_currplantscinamenoauth,taxonName,,
18 18 
int_currplantcommon,vernacularName,,
19 
int_currplantcode,*int_currplantcode,,
20 
taxonobservation_accessioncode,*taxonobservation_accessioncode,,
21 
taxoninterpretation_id,*taxoninterpretation_id,,
22 
stemlocation_id,*stemlocation_id,,
23 
taxoninterpretation_plantname_id,*taxoninterpretation_plantname_id,,
24 
taxoninterpretation_party_id,*taxoninterpretation_party_id,,
25 
role_id,*role_id,,
19 
int_currplantcode,*taxonobservation_--int_currplantcode,,
20 
taxonobservation_accessioncode,*taxonobservation_--taxonobservation_accessioncode,,
21 
taxoninterpretation_id,*taxonobservation_--taxoninterpretation_id,,
22 
stemlocation_id,*taxonobservation_--stemlocation_id,,
23 
taxoninterpretation_plantname_id,*taxonobservation_--taxoninterpretation_plantname_id,,
24 
taxoninterpretation_party_id,*taxonobservation_--taxoninterpretation_party_id,,
25 
role_id,*taxonobservation_--role_id,,
26 26 
interpretationtype,identificationType,,
27 
reference_id,*reference_id,,
28 
originalinterpretation,*originalinterpretation,,
29 
currentinterpretation,*currentinterpretation,,
27 
reference_id,*taxonobservation_--reference_id,,
28 
originalinterpretation,*taxonobservation_--originalinterpretation,,
29 
currentinterpretation,*taxonobservation_--currentinterpretation,,
30 30 
taxonfit,identificationQualifier,,
31 31 
taxonconfidence,identificationVerificationStatus,,
32 32 
collector_id,UNUSED#collector_id,,
33 33 
collectionnumber,collectorNumber,,
34 
museum_id,*museum_id,,
34 
museum_id,*taxonobservation_--museum_id,,
35 35 
museumaccessionnumber,accessionNumber,,
36 
grouptype,*grouptype,,
36 
grouptype,*taxonobservation_--grouptype,,
37 37 
notes,occurrenceRemarks,,
38 
notespublic,*notespublic,,
39 
notesmgt,*notesmgt,,
40 
revisions,*revisions,,
38 
notespublic,*taxonobservation_--notespublic,,
39 
notesmgt,*taxonobservation_--notesmgt,,
40 
revisions,*taxonobservation_--revisions,,
41 41 
interpretationdate,dateIdentified,,
42 42 
collectiondate,dateCollected,,
43 
emb_taxoninterpretation,*emb_taxoninterpretation,,
44 
taxoninterpretation_accessioncode,*taxoninterpretation_accessioncode,,
45 
plantconcept_reference_id,*plantconcept_reference_id,,
43 
emb_taxoninterpretation,*taxonobservation_--emb_taxoninterpretation,,
44 
taxoninterpretation_accessioncode,*taxonobservation_--taxoninterpretation_accessioncode,,
45 
plantconcept_reference_id,*taxonobservation_--plantconcept_reference_id,,
46 46 
plantconcept_plantname,scientificName__for_nearest_taxon_concept,,"when int_currplantscifull also provided, this often leaves out lower ranks. however, int_currplantscifull is not always provided when this is."
47 
plantcode,*plantcode,,
48 
plantdescription,*plantdescription,,
49 
d_obscount,*d_obscount,,
50 
d_currentaccepted,*d_currentaccepted,,
51 
plantconcept_accessioncode,*plantconcept_accessioncode,,
47 
plantcode,*taxonobservation_--plantcode,,
48 
plantdescription,*taxonobservation_--plantdescription,,
49 
d_obscount,*taxonobservation_--d_obscount,,
50 
d_currentaccepted,*taxonobservation_--d_currentaccepted,,
51 
plantconcept_accessioncode,*taxonobservation_--plantconcept_accessioncode,,
52 52 
Kingdom,kingdom,,
53 
Subkingdom,*Subkingdom,,
54 
Superdivision,*Superdivision,,
55 
Division,*Division,,
56 
Subdivision,*Subdivision,,
53 
Subkingdom,*taxonobservation_--Subkingdom,,
54 
Superdivision,*taxonobservation_--Superdivision,,
55 
Division,*taxonobservation_--Division,,
56 
Subdivision,*taxonobservation_--Subdivision,,
57 57 
Class,class,,
58 
Subclass,*Subclass,,
58 
Subclass,*taxonobservation_--Subclass,,
59 59 
Order,order,,
60 60 
Family,family,,
61 61 
Genus,genus,,includes genus author
62 
Species,EQUIV#to:plantname#Species,,*full* taxonomic name at that rank
63 
Subspecies,EQUIV#to:plantname#Subspecies,,*full* taxonomic name at that rank
64 
Variety,EQUIV#to:plantname#Variety,,*full* taxonomic name at that rank
65 
Forma,EQUIV#to:plantname#Forma,,*full* taxonomic name at that rank
62 
Species,EQUIV#to:plantname#Species,,*taxonobservation_--full* taxonomic name at that rank
63 
Subspecies,EQUIV#to:plantname#Subspecies,,*taxonobservation_--full* taxonomic name at that rank
64 
Variety,EQUIV#to:plantname#Variety,,*taxonobservation_--full* taxonomic name at that rank
65 
Forma,EQUIV#to:plantname#Forma,,*taxonobservation_--full* taxonomic name at that rank
66 66 
plantname,DUPLICATE#of:plantconcept_plantname#plantname,,exact duplicate
67 
plantname_reference_id,*plantname_reference_id,,
68 
dateentered,*dateentered,,
67 
plantname_reference_id,*taxonobservation_--plantname_reference_id,,
68 
dateentered,*taxonobservation_--dateentered,,
69 69 
:plot,observationGranularity,,
inputs/VegBank/taxonobservation_/new_terms.csv
1 
plantname_id,*taxonobservation_--plantname_id,,
2 
plantconcept_id,*taxonobservation_--plantconcept_id,,
1 3 
observation_id,eventID,,
4 
taxoninferencearea,*taxonobservation_--taxoninferencearea,,
5 
emb_taxonobservation,*taxonobservation_--emb_taxonobservation,,
6 
int_origplantconcept_id,*taxonobservation_--int_origplantconcept_id,,
2 7 
int_origplantscifull,EQUIV#to:authorplantname#int_origplantscifull,, = originalScientificName_scrubbed
3 8 
int_origplantscinamenoauth,originalTaxonName,,
4 9 
int_origplantcommon,originalVernacularName,,
10 
int_origplantcode,*taxonobservation_--int_origplantcode,,
11 
int_currplantconcept_id,*taxonobservation_--int_currplantconcept_id,,
5 12 
int_currplantscifull,scientificName_verbatim,,
6 13 
int_currplantscinamenoauth,taxonName,,
7 14 
int_currplantcommon,vernacularName,,
15 
int_currplantcode,*taxonobservation_--int_currplantcode,,
16 
taxonobservation_accessioncode,*taxonobservation_--taxonobservation_accessioncode,,
17 
taxoninterpretation_id,*taxonobservation_--taxoninterpretation_id,,
18 
stemlocation_id,*taxonobservation_--stemlocation_id,,
19 
taxoninterpretation_plantname_id,*taxonobservation_--taxoninterpretation_plantname_id,,
20 
taxoninterpretation_party_id,*taxonobservation_--taxoninterpretation_party_id,,
21 
role_id,*taxonobservation_--role_id,,
22 
reference_id,*taxonobservation_--reference_id,,
23 
originalinterpretation,*taxonobservation_--originalinterpretation,,
24 
currentinterpretation,*taxonobservation_--currentinterpretation,,
25 
museum_id,*taxonobservation_--museum_id,,
26 
grouptype,*taxonobservation_--grouptype,,
27 
notespublic,*taxonobservation_--notespublic,,
28 
notesmgt,*taxonobservation_--notesmgt,,
29 
revisions,*taxonobservation_--revisions,,
8 30 
interpretationdate,dateIdentified,,
9 31 
collectiondate,dateCollected,,
32 
emb_taxoninterpretation,*taxonobservation_--emb_taxoninterpretation,,
33 
taxoninterpretation_accessioncode,*taxonobservation_--taxoninterpretation_accessioncode,,
34 
plantconcept_reference_id,*taxonobservation_--plantconcept_reference_id,,
10 35 
plantconcept_plantname,scientificName__for_nearest_taxon_concept,,"when int_currplantscifull also provided, this often leaves out lower ranks. however, int_currplantscifull is not always provided when this is."
36 
plantcode,*taxonobservation_--plantcode,,
37 
plantdescription,*taxonobservation_--plantdescription,,
38 
d_obscount,*taxonobservation_--d_obscount,,
39 
d_currentaccepted,*taxonobservation_--d_currentaccepted,,
40 
plantconcept_accessioncode,*taxonobservation_--plantconcept_accessioncode,,
41 
Subkingdom,*taxonobservation_--Subkingdom,,
42 
Superdivision,*taxonobservation_--Superdivision,,
43 
Division,*taxonobservation_--Division,,
44 
Subdivision,*taxonobservation_--Subdivision,,
45 
Subclass,*taxonobservation_--Subclass,,
11 46 
plantname,DUPLICATE#of:plantconcept_plantname#plantname,,exact duplicate
47 
plantname_reference_id,*taxonobservation_--plantname_reference_id,,
48 
dateentered,*taxonobservation_--dateentered,,
inputs/VegBank/taxonobservation_/unmapped_terms.csv
1 
*plantname_id
2 
*plantconcept_id
3 
*taxonobservation_reference_id
4 
*taxoninferencearea
5 
*emb_taxonobservation
6 
*int_origplantconcept_id
1 
*taxonobservation_--plantname_id
2 
*taxonobservation_--plantconcept_id
3 
*taxonobservation_--taxonobservation_reference_id
4 
*taxonobservation_--taxoninferencearea
5 
*taxonobservation_--emb_taxonobservation
6 
*taxonobservation_--int_origplantconcept_id
7 7 
originalVernacularName
8 
*int_origplantcode
9 
*int_currplantconcept_id
8 
*taxonobservation_--int_origplantcode
9 
*taxonobservation_--int_currplantconcept_id
10 10 
scientificName_verbatim
11 11 
vernacularName
12 
*int_currplantcode
13 
*taxonobservation_accessioncode
14 
*taxoninterpretation_id
15 
*stemlocation_id
16 
*taxoninterpretation_plantname_id
17 
*taxoninterpretation_party_id
18 
*role_id
19 
*reference_id
20 
*originalinterpretation
21 
*currentinterpretation
12 
*taxonobservation_--int_currplantcode
13 
*taxonobservation_--taxonobservation_accessioncode
14 
*taxonobservation_--taxoninterpretation_id
15 
*taxonobservation_--stemlocation_id
16 
*taxonobservation_--taxoninterpretation_plantname_id
17 
*taxonobservation_--taxoninterpretation_party_id
18 
*taxonobservation_--role_id
19 
*taxonobservation_--reference_id
20 
*taxonobservation_--originalinterpretation
21 
*taxonobservation_--currentinterpretation
22 22 
identificationVerificationStatus
23 
*museum_id
24 
*grouptype
25 
*notespublic
26 
*notesmgt
27 
*revisions
28 
*emb_taxoninterpretation
29 
*taxoninterpretation_accessioncode
30 
*plantconcept_reference_id
23 
*taxonobservation_--museum_id
24 
*taxonobservation_--grouptype
25 
*taxonobservation_--notespublic
26 
*taxonobservation_--notesmgt
27 
*taxonobservation_--revisions
28 
*taxonobservation_--emb_taxoninterpretation
29 
*taxonobservation_--taxoninterpretation_accessioncode
30 
*taxonobservation_--plantconcept_reference_id
31 31 
scientificName__for_nearest_taxon_concept
32 
*plantcode
33 
*plantdescription
34 
*d_obscount
35 
*d_currentaccepted
36 
*plantconcept_accessioncode
37 
*Subkingdom
38 
*Superdivision
39 
*Division
40 
*Subdivision
41 
*Subclass
42 
*plantname_reference_id
43 
*dateentered
32 
*taxonobservation_--plantcode
33 
*taxonobservation_--plantdescription
34 
*taxonobservation_--d_obscount
35 
*taxonobservation_--d_currentaccepted
36 
*taxonobservation_--plantconcept_accessioncode
37 
*taxonobservation_--Subkingdom
38 
*taxonobservation_--Superdivision
39 
*taxonobservation_--Division
40 
*taxonobservation_--Subdivision
41 
*taxonobservation_--Subclass
42 
*taxonobservation_--plantname_reference_id
43 
*taxonobservation_--dateentered
inputs/VegBank/plot_/map.csv
1 1 
VegBank,VegCore,Filter,Comments
2 2 
plot_id,locationID,,
3 3 
authorplotcode,locationName,,
4 
reference_id,*reference_id,,
4 
reference_id,*plot_--reference_id,,
5 5 
parent_id,parentLocationID,,
6 6 
locationaccuracy,coordinateUncertaintyInMeters__from_coords,,
7 7 
confidentialitystatus,accessRights_verbatim,,
8 
confidentialityreason,*confidentialityreason,,
8 
confidentialityreason,*plot_--confidentialityreason,,
9 9 
latitude,decimalLatitude,,
10 10 
longitude,decimalLongitude,,
11 
authore,*authore,,
12 
authorn,*authorn,,
13 
authorzone,*authorzone,,
14 
authordatum,*authordatum,,
15 
authorlocation,*authorlocation,,
11 
authore,*plot_--authore,,
12 
authorn,*plot_--authorn,,
13 
authorzone,*plot_--authorzone,,
14 
authordatum,*plot_--authordatum,,
15 
authorlocation,*plot_--authorlocation,,
16 16 
locationnarrative,locality,,
17 
azimuth,*azimuth,,
18 
dsgpoly,*dsgpoly,,
17 
azimuth,*plot_--azimuth,,
18 
dsgpoly,*plot_--dsgpoly,,
19 19 
shape,footprintWKT,,
20 20 
area,plotArea_m2,,"""Total area of the plot in m2"" (area definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename>)"
21 
standsize,*standsize,,
22 
placementmethod,*placementmethod,,
23 
permanence,*permanence,,
24 
layoutnarrative,*layoutnarrative,,
21 
standsize,*plot_--standsize,,
22 
placementmethod,*plot_--placementmethod,,
23 
permanence,*plot_--permanence,,
24 
layoutnarrative,*plot_--layoutnarrative,,
25 25 
elevation,elevationInMeters,,"has only 5 decimal places of precision, with only 9s and random #s after that. ""The elevation of the plot origin in meters above sea level"" (elevation definition at <http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename>)"
26 
elevationaccuracy,*elevationaccuracy,,
26 
elevationaccuracy,*plot_--elevationaccuracy,,
27 27 
elevationrange,UNUSED#elevationrange,,
28 28 
slopeaspect,slopeAspect,,
29 29 
minslopeaspect,minSlopeAspect,,
......
31 31 
slopegradient,slopeGradient,,
32 32 
minslopegradient,minSlopeGradient,,
33 33 
maxslopegradient,maxSlopeGradient,,
34 
topoposition,*topoposition,,
34 
topoposition,*plot_--topoposition,,
35 35 
landform,landform,,
36 
surficialdeposits,*surficialdeposits,,
37 
rocktype,*rocktype,,
36 
surficialdeposits,*plot_--surficialdeposits,,
37 
rocktype,*plot_--rocktype,,
38 38 
stateprovince,stateProvince,,
39 39 
country,country,,
40 
submitter_surname,*submitter_surname,,
41 
submitter_givenname,*submitter_givenname,,
42 
submitter_email,*submitter_email,,
43 
notespublic,*notespublic,,
44 
notesmgt,*notesmgt,,
45 
revisions,*revisions,,
46 
dateentered,*dateentered,,
47 
emb_plot,*emb_plot,,
48 
plotrationalenarrative,*plotrationalenarrative,,
49 
accessioncode,*accessioncode,,
40 
submitter_surname,*plot_--submitter_surname,,
41 
submitter_givenname,*plot_--submitter_givenname,,
42 
submitter_email,*plot_--submitter_email,,
43 
notespublic,*plot_--notespublic,,
44 
notesmgt,*plot_--notesmgt,,
45 
revisions,*plot_--revisions,,
46 
dateentered,*plot_--dateentered,,
47 
emb_plot,*plot_--emb_plot,,
48 
plotrationalenarrative,*plot_--plotrationalenarrative,,
49 
accessioncode,*plot_--accessioncode,,
50 50 
continent,continent,,
51 51 
area|country|territory,DUPLICATE#of:country#area|country|territory,,
52 52 
region|state|province,DUPLICATE#of:stateprovince#region|state|province,,
53 53 
county,county,,
54 
quadrangle,*quadrangle,,
55 
Geographic Name,*Geographic Name,,
54 
quadrangle,*plot_--quadrangle,,
55 
Geographic Name,*plot_--Geographic Name,,
inputs/VegBank/plot_/new_terms.csv
1 
reference_id,*plot_--reference_id,,
1 2 
parent_id,parentLocationID,,
2 3 
locationaccuracy,coordinateUncertaintyInMeters__from_coords,,
3 4 
confidentialitystatus,accessRights_verbatim,,
5 
confidentialityreason,*plot_--confidentialityreason,,
6 
authore,*plot_--authore,,
7 
authorn,*plot_--authorn,,
8 
authorzone,*plot_--authorzone,,
9 
authordatum,*plot_--authordatum,,
10 
authorlocation,*plot_--authorlocation,,
11 
azimuth,*plot_--azimuth,,
12 
dsgpoly,*plot_--dsgpoly,,
4 13 
shape,footprintWKT,,
14 
standsize,*plot_--standsize,,
15 
placementmethod,*plot_--placementmethod,,
16 
permanence,*plot_--permanence,,
17 
layoutnarrative,*plot_--layoutnarrative,,
18 
elevationaccuracy,*plot_--elevationaccuracy,,
19 
topoposition,*plot_--topoposition,,
20 
surficialdeposits,*plot_--surficialdeposits,,
21 
rocktype,*plot_--rocktype,,
22 
submitter_surname,*plot_--submitter_surname,,
23 
submitter_givenname,*plot_--submitter_givenname,,
24 
submitter_email,*plot_--submitter_email,,
25 
notespublic,*plot_--notespublic,,
26 
notesmgt,*plot_--notesmgt,,
27 
revisions,*plot_--revisions,,
28 
dateentered,*plot_--dateentered,,
29 
emb_plot,*plot_--emb_plot,,
30 
plotrationalenarrative,*plot_--plotrationalenarrative,,
31 
accessioncode,*plot_--accessioncode,,
5 32 
area|country|territory,DUPLICATE#of:country#area|country|territory,,
6 33 
region|state|province,DUPLICATE#of:stateprovince#region|state|province,,
34 
quadrangle,*plot_--quadrangle,,
35 
Geographic Name,*plot_--Geographic Name,,
inputs/VegBank/plot_/unmapped_terms.csv
1 
*reference_id
1 
*plot_--reference_id
2 2 
coordinateUncertaintyInMeters__from_coords
3 3 
accessRights_verbatim
4 
*confidentialityreason
5 
*authore
6 
*authorn
7 
*authorzone
8 
*authordatum
9 
*authorlocation
10 
*azimuth
11 
*dsgpoly
12 
*standsize
13 
*placementmethod
14 
*permanence
15 
*layoutnarrative
16 
*elevationaccuracy
17 
*topoposition
18 
*surficialdeposits
19 
*rocktype
20 
*submitter_surname
21 
*submitter_givenname
22 
*submitter_email
23 
*notespublic
24 
*notesmgt
25 
*revisions
26 
*dateentered
27 
*emb_plot
28 
*plotrationalenarrative
29 
*accessioncode
30 
*quadrangle
31 
*Geographic Name
4 
*plot_--confidentialityreason
5 
*plot_--authore
6 
*plot_--authorn
7 
*plot_--authorzone
8 
*plot_--authordatum
9 
*plot_--authorlocation
10 
*plot_--azimuth
11 
*plot_--dsgpoly
12 
*plot_--standsize
13 
*plot_--placementmethod
14 
*plot_--permanence
15 
*plot_--layoutnarrative
16 
*plot_--elevationaccuracy
17 
*plot_--topoposition
18 
*plot_--surficialdeposits
19 
*plot_--rocktype
20 
*plot_--submitter_surname
21 
*plot_--submitter_givenname
22 
*plot_--submitter_email
23 
*plot_--notespublic
24 
*plot_--notesmgt
25 
*plot_--revisions
26 
*plot_--dateentered
27 
*plot_--emb_plot
28 
*plot_--plotrationalenarrative
29 
*plot_--accessioncode
30 
*plot_--quadrangle
31 
*plot_--Geographic Name

Also available in: Unified diff