Revision 11240
Added by Aaron Marcuse-Kubitza about 11 years ago
inputs/VegBank/verify/input_cols.unmapped.txt | ||
---|---|---|
1 |
*taxonobservation_--plantname_id |
|
2 |
*taxonobservation_--plantconcept_id |
|
3 |
*taxonobservation_--stemlocation_id |
|
4 |
*taxonobservation_--taxoninterpretation_plantname_id |
|
5 |
*taxonobservation_--taxoninterpretation_party_id |
|
6 |
*taxonobservation_--role_id |
|
7 |
*taxonobservation_--reference_id |
|
8 |
*taxonobservation_--originalinterpretation |
|
9 |
*taxonobservation_--currentinterpretation |
|
10 |
UNUSED#collector_id |
|
11 |
*taxonobservation_--museum_id |
|
12 |
*taxonobservation_--grouptype |
|
13 |
*taxonobservation_--notespublic |
|
14 |
*taxonobservation_--notesmgt |
|
15 |
*taxonobservation_--revisions |
|
16 |
*taxonobservation_--emb_taxoninterpretation |
|
17 |
*taxonobservation_--taxoninterpretation_accessioncode |
|
18 |
*taxonobservation_--taxonobservation_reference_id |
|
19 |
*taxonobservation_--taxoninferencearea |
|
20 |
*taxonobservation_--emb_taxonobservation |
|
21 |
*taxonobservation_--int_origplantconcept_id |
|
22 |
EQUIV#to:authorplantname#int_origplantscifull |
|
23 |
*taxonobservation_--int_origplantcode |
|
24 |
*taxonobservation_--int_currplantconcept_id |
|
25 |
*taxonobservation_--int_currplantcode |
|
26 |
*taxonobservation_--taxonobservation_accessioncode |
|
27 |
*plantconcept_--plantconcept_reference_id |
|
28 |
*plantconcept_--plantcode |
|
29 |
*plantconcept_--plantdescription |
|
30 |
*plantconcept_--d_obscount |
|
31 |
*plantconcept_--d_currentaccepted |
|
32 |
*plantconcept_--plantconcept_accessioncode |
|
33 |
EQUIV#to:plantname#Species |
|
34 |
EQUIV#to:plantname#Subspecies |
|
35 |
EQUIV#to:plantname#Variety |
|
36 |
EQUIV#to:plantname#Forma |
|
37 |
DUPLICATE#of:plantconcept_plantname#plantname |
|
38 |
*taxonobservation_--plantname_reference_id |
|
39 |
*taxonobservation_--dateentered |
|
40 |
*stemcount_--basalarea |
|
41 |
*stemcount_--biomass |
|
42 |
*stemcount_--inferencearea |
|
43 |
*stemcount_--stratumbase |
|
44 |
*stemcount_--stratumheight |
|
45 |
*stemcount_--emb_taxonimportance |
|
46 |
*stemcount_--covercode |
|
47 |
*stemcount_--stemdiameteraccuracy |
|
48 |
*stemcount_--stemheightaccuracy |
|
49 |
*stemcount_--stemtaxonarea |
|
50 |
*stemcount_--emb_stemcount |
|
51 |
UNUSED#stemcode |
|
52 |
UNUSED#stemxposition |
|
53 |
UNUSED#stemyposition |
|
54 |
*stemlocation_--stemhealth |
|
55 |
*stemlocation_--emb_stemlocation |
|
56 |
OMIT#stemdiameter # included as part of another table |
|
57 |
OMIT#stemdiameteraccuracy # included as part of another table |
|
58 |
OMIT#stemheight # included as part of another table |
|
59 |
OMIT#stemheightaccuracy # included as part of another table |
|
60 |
OMIT#stemcount # included as part of another table |
|
61 |
OMIT#stemtaxonarea # included as part of another table |
|
62 |
OMIT#emb_stemcount # included as part of another table |
|
63 |
*stratum--observation_id |
|
64 |
*stratum--stratummethod_id |
|
65 |
*stratum--stratumname |
|
66 |
*stratum--stratumheight |
|
67 |
*stratum--stratumbase |
|
68 |
*stratum--stratumcover |
|
69 |
*stratum--stratumdescription |
|
70 |
*stratumtype--stratummethod_id |
|
71 |
*stratumtype--stratumindex |
|
72 |
*stratumtype--stratumdescription |
|
73 |
*observation_--previousobs_id |
|
74 |
*observation_--dateaccuracy |
|
75 |
*observation_--covermethod_id |
|
76 |
*observation_--coverdispersion |
|
77 |
*observation_--autotaxoncover |
|
78 |
*observation_--stratummethod_id |
|
79 |
*observation_--taxonobservationarea |
|
80 |
*observation_--stemsizelimit |
|
81 |
*observation_--stemobservationarea |
|
82 |
*observation_--stemsamplemethod |
|
83 |
*observation_--originaldata |
|
84 |
*observation_--effortlevel |
|
85 |
*observation_--plotvalidationlevel |
|
86 |
*observation_--floristicquality |
|
87 |
*observation_--bryophytequality |
|
88 |
*observation_--lichenquality |
|
89 |
*observation_--observationnarrative |
|
90 |
*observation_--landscapenarrative |
|
91 |
*observation_--homogeneity |
|
92 |
*observation_--phenologicaspect |
|
93 |
*observation_--representativeness |
|
94 |
*observation_--standmaturity |
|
95 |
*observation_--successionalstatus |
|
96 |
*observation_--basalarea |
|
97 |
*observation_--hydrologicregime |
|
98 |
*observation_--soilmoistureregime |
|
99 |
*observation_--soildrainage |
|
100 |
*observation_--watersalinity |
|
101 |
*observation_--waterdepth |
|
102 |
*observation_--shoredistance |
|
103 |
*observation_--soildepth |
|
104 |
*observation_--organicdepth |
|
105 |
*observation_--soiltaxon_id |
|
106 |
*observation_--soiltaxonsrc |
|
107 |
*observation_--percentbedrock |
|
108 |
*observation_--percentrockgravel |
|
109 |
*observation_--percentwood |
|
110 |
*observation_--percentlitter |
|
111 |
*observation_--percentbaresoil |
|
112 |
*observation_--percentwater |
|
113 |
*observation_--percentother |
|
114 |
*observation_--nameother |
|
115 |
*observation_--treeht |
|
116 |
*observation_--shrubht |
|
117 |
*observation_--fieldht |
|
118 |
*observation_--nonvascularht |
|
119 |
*observation_--submergedht |
|
120 |
*observation_--treecover |
|
121 |
*observation_--shrubcover |
|
122 |
*observation_--fieldcover |
|
123 |
*observation_--nonvascularcover |
|
124 |
*observation_--floatingcover |
|
125 |
*observation_--submergedcover |
|
126 |
*observation_--dominantstratum |
|
127 |
*observation_--growthform1type |
|
128 |
*observation_--growthform2type |
|
129 |
*observation_--growthform3type |
|
130 |
*observation_--growthform1cover |
|
131 |
*observation_--growthform2cover |
|
132 |
*observation_--growthform3cover |
|
133 |
*observation_--totalcover |
|
134 |
*observation_--notespublic |
|
135 |
*observation_--notesmgt |
|
136 |
*observation_--revisions |
|
137 |
*observation_--dateentered |
|
138 |
*observation_--emb_observation |
|
139 |
*observation_--interp_orig_ci_id |
|
140 |
*observation_--interp_orig_cc_id |
|
141 |
*observation_--interp_orig_sciname |
|
142 |
*observation_--interp_orig_code |
|
143 |
*observation_--interp_orig_party_id |
|
144 |
*observation_--interp_orig_partyname |
|
145 |
*observation_--interp_current_ci_id |
|
146 |
*observation_--interp_current_cc_id |
|
147 |
*observation_--interp_current_sciname |
|
148 |
*observation_--interp_current_code |
|
149 |
*observation_--interp_current_party_id |
|
150 |
*observation_--interp_current_partyname |
|
151 |
*observation_--interp_bestfit_ci_id |
|
152 |
*observation_--interp_bestfit_cc_id |
|
153 |
*observation_--interp_bestfit_sciname |
|
154 |
*observation_--interp_bestfit_code |
|
155 |
*observation_--interp_bestfit_party_id |
|
156 |
*observation_--interp_bestfit_partyname |
|
157 |
*observation_--toptaxon1name |
|
158 |
*observation_--toptaxon2name |
|
159 |
*observation_--toptaxon3name |
|
160 |
*observation_--toptaxon4name |
|
161 |
*observation_--toptaxon5name |
|
162 |
*observation_--numberoftaxa |
|
163 |
*observation_--accessioncode |
|
164 |
*observation_--soilobs_id |
|
165 |
*observation_--soilhorizon |
|
166 |
*observation_--soildepthtop |
|
167 |
*observation_--soildepthbottom |
|
168 |
*observation_--soilcolor |
|
169 |
*observation_--soilcoarse |
|
170 |
*observation_--soildescription |
|
171 |
*observation_--emb_soilobs |
|
172 |
*plot_--reference_id |
|
173 |
*plot_--confidentialityreason |
|
174 |
*plot_--authore |
|
175 |
*plot_--authorn |
|
176 |
*plot_--authorzone |
|
177 |
*plot_--authordatum |
|
178 |
*plot_--authorlocation |
|
179 |
*plot_--azimuth |
|
180 |
*plot_--dsgpoly |
|
181 |
*plot_--standsize |
|
182 |
*plot_--placementmethod |
|
183 |
*plot_--permanence |
|
184 |
*plot_--layoutnarrative |
|
185 |
*plot_--elevationaccuracy |
|
186 |
UNUSED#elevationrange |
|
187 |
*plot_--topoposition |
|
188 |
*plot_--surficialdeposits |
|
189 |
*plot_--rocktype |
|
190 |
*plot_--submitter_surname |
|
191 |
*plot_--submitter_givenname |
|
192 |
*plot_--submitter_email |
|
193 |
*plot_--notespublic |
|
194 |
*plot_--notesmgt |
|
195 |
*plot_--revisions |
|
196 |
*plot_--dateentered |
|
197 |
*plot_--emb_plot |
|
198 |
*plot_--plotrationalenarrative |
|
199 |
*plot_--accessioncode |
|
200 |
DUPLICATE#of:country#area|country|territory |
|
201 |
DUPLICATE#of:stateprovince#region|state|province |
|
202 |
*plot_--quadrangle |
|
203 |
*plot_--Geographic Name |
inputs/VegBank/verify/input_cols.unmapped.txt.run | ||
---|---|---|
1 |
#!/bin/bash -e |
|
2 |
. "$(dirname "${BASH_SOURCE[0]}")"/../../../lib/runscripts/util.run |
|
3 |
.rel ../../../lib/sh/local.sh |
|
4 |
|
|
5 |
if self_not_included; then |
|
6 |
|
|
7 |
filter() |
|
8 |
{ |
|
9 |
echo_func |
|
10 |
<"${top_file/.unmapped./.}" echo_run grep -F -e '--' -e '#'\ |
|
11 |
|sed 's/^OMIT#.*$/& # included as part of another table/' >"$top_file" |
|
12 |
} |
|
13 |
|
|
14 |
all() |
|
15 |
{ |
|
16 |
echo_func |
|
17 |
filter |
|
18 |
} |
|
19 |
|
|
20 |
fi |
|
21 | 0 |
inputs/VegBank/verify/input_cols.exclude.txt | ||
---|---|---|
1 |
*taxonobservation_--plantname_id |
|
2 |
*taxonobservation_--plantconcept_id |
|
3 |
*taxonobservation_--stemlocation_id |
|
4 |
*taxonobservation_--taxoninterpretation_plantname_id |
|
5 |
*taxonobservation_--taxoninterpretation_party_id |
|
6 |
*taxonobservation_--role_id |
|
7 |
*taxonobservation_--reference_id |
|
8 |
*taxonobservation_--originalinterpretation |
|
9 |
*taxonobservation_--currentinterpretation |
|
10 |
UNUSED#collector_id |
|
11 |
*taxonobservation_--museum_id |
|
12 |
*taxonobservation_--grouptype |
|
13 |
*taxonobservation_--notespublic |
|
14 |
*taxonobservation_--notesmgt |
|
15 |
*taxonobservation_--revisions |
|
16 |
*taxonobservation_--emb_taxoninterpretation |
|
17 |
*taxonobservation_--taxoninterpretation_accessioncode |
|
18 |
*taxonobservation_--taxonobservation_reference_id |
|
19 |
*taxonobservation_--taxoninferencearea |
|
20 |
*taxonobservation_--emb_taxonobservation |
|
21 |
*taxonobservation_--int_origplantconcept_id |
|
22 |
EQUIV#to:authorplantname#int_origplantscifull |
|
23 |
*taxonobservation_--int_origplantcode |
|
24 |
*taxonobservation_--int_currplantconcept_id |
|
25 |
*taxonobservation_--int_currplantcode |
|
26 |
*taxonobservation_--taxonobservation_accessioncode |
|
27 |
*plantconcept_--plantconcept_reference_id |
|
28 |
*plantconcept_--plantcode |
|
29 |
*plantconcept_--plantdescription |
|
30 |
*plantconcept_--d_obscount |
|
31 |
*plantconcept_--d_currentaccepted |
|
32 |
*plantconcept_--plantconcept_accessioncode |
|
33 |
EQUIV#to:plantname#Species |
|
34 |
EQUIV#to:plantname#Subspecies |
|
35 |
EQUIV#to:plantname#Variety |
|
36 |
EQUIV#to:plantname#Forma |
|
37 |
DUPLICATE#of:plantconcept_plantname#plantname |
|
38 |
*taxonobservation_--plantname_reference_id |
|
39 |
*taxonobservation_--dateentered |
|
40 |
*stemcount_--basalarea |
|
41 |
*stemcount_--biomass |
|
42 |
*stemcount_--inferencearea |
|
43 |
*stemcount_--stratumbase |
|
44 |
*stemcount_--stratumheight |
|
45 |
*stemcount_--emb_taxonimportance |
|
46 |
*stemcount_--covercode |
|
47 |
*stemcount_--stemdiameteraccuracy |
|
48 |
*stemcount_--stemheightaccuracy |
|
49 |
*stemcount_--stemtaxonarea |
|
50 |
*stemcount_--emb_stemcount |
|
51 |
UNUSED#stemcode |
|
52 |
UNUSED#stemxposition |
|
53 |
UNUSED#stemyposition |
|
54 |
*stemlocation_--stemhealth |
|
55 |
*stemlocation_--emb_stemlocation |
|
56 |
OMIT#stemdiameter # included as part of another table |
|
57 |
OMIT#stemdiameteraccuracy # included as part of another table |
|
58 |
OMIT#stemheight # included as part of another table |
|
59 |
OMIT#stemheightaccuracy # included as part of another table |
|
60 |
OMIT#stemcount # included as part of another table |
|
61 |
OMIT#stemtaxonarea # included as part of another table |
|
62 |
OMIT#emb_stemcount # included as part of another table |
|
63 |
*stratum--observation_id |
|
64 |
*stratum--stratummethod_id |
|
65 |
*stratum--stratumname |
|
66 |
*stratum--stratumheight |
|
67 |
*stratum--stratumbase |
|
68 |
*stratum--stratumcover |
|
69 |
*stratum--stratumdescription |
|
70 |
*stratumtype--stratummethod_id |
|
71 |
*stratumtype--stratumindex |
|
72 |
*stratumtype--stratumdescription |
|
73 |
*observation_--previousobs_id |
|
74 |
*observation_--dateaccuracy |
|
75 |
*observation_--covermethod_id |
|
76 |
*observation_--coverdispersion |
|
77 |
*observation_--autotaxoncover |
|
78 |
*observation_--stratummethod_id |
|
79 |
*observation_--taxonobservationarea |
|
80 |
*observation_--stemsizelimit |
|
81 |
*observation_--stemobservationarea |
|
82 |
*observation_--stemsamplemethod |
|
83 |
*observation_--originaldata |
|
84 |
*observation_--effortlevel |
|
85 |
*observation_--plotvalidationlevel |
|
86 |
*observation_--floristicquality |
|
87 |
*observation_--bryophytequality |
|
88 |
*observation_--lichenquality |
|
89 |
*observation_--observationnarrative |
|
90 |
*observation_--landscapenarrative |
|
91 |
*observation_--homogeneity |
|
92 |
*observation_--phenologicaspect |
|
93 |
*observation_--representativeness |
|
94 |
*observation_--standmaturity |
|
95 |
*observation_--successionalstatus |
|
96 |
*observation_--basalarea |
|
97 |
*observation_--hydrologicregime |
|
98 |
*observation_--soilmoistureregime |
|
99 |
*observation_--soildrainage |
|
100 |
*observation_--watersalinity |
|
101 |
*observation_--waterdepth |
|
102 |
*observation_--shoredistance |
|
103 |
*observation_--soildepth |
|
104 |
*observation_--organicdepth |
|
105 |
*observation_--soiltaxon_id |
|
106 |
*observation_--soiltaxonsrc |
|
107 |
*observation_--percentbedrock |
|
108 |
*observation_--percentrockgravel |
|
109 |
*observation_--percentwood |
|
110 |
*observation_--percentlitter |
|
111 |
*observation_--percentbaresoil |
|
112 |
*observation_--percentwater |
|
113 |
*observation_--percentother |
|
114 |
*observation_--nameother |
|
115 |
*observation_--treeht |
|
116 |
*observation_--shrubht |
|
117 |
*observation_--fieldht |
|
118 |
*observation_--nonvascularht |
|
119 |
*observation_--submergedht |
|
120 |
*observation_--treecover |
|
121 |
*observation_--shrubcover |
|
122 |
*observation_--fieldcover |
|
123 |
*observation_--nonvascularcover |
|
124 |
*observation_--floatingcover |
|
125 |
*observation_--submergedcover |
|
126 |
*observation_--dominantstratum |
|
127 |
*observation_--growthform1type |
|
128 |
*observation_--growthform2type |
|
129 |
*observation_--growthform3type |
|
130 |
*observation_--growthform1cover |
|
131 |
*observation_--growthform2cover |
|
132 |
*observation_--growthform3cover |
|
133 |
*observation_--totalcover |
|
134 |
*observation_--notespublic |
|
135 |
*observation_--notesmgt |
|
136 |
*observation_--revisions |
|
137 |
*observation_--dateentered |
|
138 |
*observation_--emb_observation |
|
139 |
*observation_--interp_orig_ci_id |
|
140 |
*observation_--interp_orig_cc_id |
|
141 |
*observation_--interp_orig_sciname |
|
142 |
*observation_--interp_orig_code |
|
143 |
*observation_--interp_orig_party_id |
|
144 |
*observation_--interp_orig_partyname |
|
145 |
*observation_--interp_current_ci_id |
|
146 |
*observation_--interp_current_cc_id |
|
147 |
*observation_--interp_current_sciname |
|
148 |
*observation_--interp_current_code |
|
149 |
*observation_--interp_current_party_id |
|
150 |
*observation_--interp_current_partyname |
|
151 |
*observation_--interp_bestfit_ci_id |
|
152 |
*observation_--interp_bestfit_cc_id |
|
153 |
*observation_--interp_bestfit_sciname |
|
154 |
*observation_--interp_bestfit_code |
|
155 |
*observation_--interp_bestfit_party_id |
|
156 |
*observation_--interp_bestfit_partyname |
|
157 |
*observation_--toptaxon1name |
|
158 |
*observation_--toptaxon2name |
|
159 |
*observation_--toptaxon3name |
|
160 |
*observation_--toptaxon4name |
|
161 |
*observation_--toptaxon5name |
|
162 |
*observation_--numberoftaxa |
|
163 |
*observation_--accessioncode |
|
164 |
*observation_--soilobs_id |
|
165 |
*observation_--soilhorizon |
|
166 |
*observation_--soildepthtop |
|
167 |
*observation_--soildepthbottom |
|
168 |
*observation_--soilcolor |
|
169 |
*observation_--soilcoarse |
|
170 |
*observation_--soildescription |
|
171 |
*observation_--emb_soilobs |
|
172 |
*plot_--reference_id |
|
173 |
*plot_--confidentialityreason |
|
174 |
*plot_--authore |
|
175 |
*plot_--authorn |
|
176 |
*plot_--authorzone |
|
177 |
*plot_--authordatum |
|
178 |
*plot_--authorlocation |
|
179 |
*plot_--azimuth |
|
180 |
*plot_--dsgpoly |
|
181 |
*plot_--standsize |
|
182 |
*plot_--placementmethod |
|
183 |
*plot_--permanence |
|
184 |
*plot_--layoutnarrative |
|
185 |
*plot_--elevationaccuracy |
|
186 |
UNUSED#elevationrange |
|
187 |
*plot_--topoposition |
|
188 |
*plot_--surficialdeposits |
|
189 |
*plot_--rocktype |
|
190 |
*plot_--submitter_surname |
|
191 |
*plot_--submitter_givenname |
|
192 |
*plot_--submitter_email |
|
193 |
*plot_--notespublic |
|
194 |
*plot_--notesmgt |
|
195 |
*plot_--revisions |
|
196 |
*plot_--dateentered |
|
197 |
*plot_--emb_plot |
|
198 |
*plot_--plotrationalenarrative |
|
199 |
*plot_--accessioncode |
|
200 |
DUPLICATE#of:country#area|country|territory |
|
201 |
DUPLICATE#of:stateprovince#region|state|province |
|
202 |
*plot_--quadrangle |
|
203 |
*plot_--Geographic Name |
inputs/VegBank/verify/input_cols.exclude.txt.run | ||
---|---|---|
1 |
#!/bin/bash -e |
|
2 |
. "$(dirname "${BASH_SOURCE[0]}")"/../../../lib/runscripts/util.run |
|
3 |
.rel ../../../lib/sh/local.sh |
|
4 |
|
|
5 |
if self_not_included; then |
|
6 |
|
|
7 |
filter() |
|
8 |
{ |
|
9 |
echo_func |
|
10 |
<"${top_file/.unmapped./.}" echo_run grep -F -e '--' -e '#'\ |
|
11 |
|sed 's/^OMIT#.*$/& # included as part of another table/' >"$top_file" |
|
12 |
} |
|
13 |
|
|
14 |
all() |
|
15 |
{ |
|
16 |
echo_func |
|
17 |
filter |
|
18 |
} |
|
19 |
|
|
20 |
fi |
|
0 | 21 |
Also available in: Unified diff
inputs/VegBank/verify/input_cols.unmapped.txt*: renamed to input_cols.exclude.txt* because this now includes mapped columns as well