Revision 11235
Added by Aaron Marcuse-Kubitza about 11 years ago
inputs/VegBank/verify/input_cols.unmapped.txt | ||
---|---|---|
1 |
*stratumtype_id |
|
2 |
*stratum_id |
|
3 |
*taxonobservation_--plantname_id |
|
4 |
*taxonobservation_--plantconcept_id |
|
5 |
*taxonobservation_--stemlocation_id |
|
6 |
*taxonobservation_--taxoninterpretation_plantname_id |
|
7 |
*taxonobservation_--taxoninterpretation_party_id |
|
8 |
*taxonobservation_--role_id |
|
9 |
*taxonobservation_--reference_id |
|
10 |
*taxonobservation_--originalinterpretation |
|
11 |
*taxonobservation_--currentinterpretation |
|
12 |
*taxonobservation_--museum_id |
|
13 |
*taxonobservation_--grouptype |
|
14 |
*taxonobservation_--notespublic |
|
15 |
*taxonobservation_--notesmgt |
|
16 |
*taxonobservation_--revisions |
|
17 |
*taxonobservation_--emb_taxoninterpretation |
|
18 |
*taxonobservation_--taxoninterpretation_accessioncode |
|
19 |
*taxonobservation_--taxonobservation_reference_id |
|
20 |
*taxonobservation_--taxoninferencearea |
|
21 |
*taxonobservation_--emb_taxonobservation |
|
22 |
*taxonobservation_--int_origplantconcept_id |
|
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 |
*Subkingdom |
|
34 |
*Superdivision |
|
35 |
*Division |
|
36 |
*Subdivision |
|
37 |
*Subclass |
|
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 |
*stemlocation_--stemhealth |
|
52 |
*stemlocation_--emb_stemlocation |
|
53 |
*stratum--observation_id |
|
54 |
*stratum--stratummethod_id |
|
55 |
*stratum--stratumname |
|
56 |
*stratum--stratumheight |
|
57 |
*stratum--stratumbase |
|
58 |
*stratum--stratumcover |
|
59 |
*stratum--stratumdescription |
|
60 |
*stratumtype--stratummethod_id |
|
61 |
*stratumtype--stratumindex |
|
62 |
*stratumtype--stratumdescription |
|
63 |
*observation_--previousobs_id |
|
64 |
*observation_--dateaccuracy |
|
65 |
*observation_--covermethod_id |
|
66 |
*observation_--coverdispersion |
|
67 |
*observation_--autotaxoncover |
|
68 |
*observation_--stratummethod_id |
|
69 |
*observation_--taxonobservationarea |
|
70 |
*observation_--stemsizelimit |
|
71 |
*observation_--stemobservationarea |
|
72 |
*observation_--stemsamplemethod |
|
73 |
*observation_--originaldata |
|
74 |
*observation_--effortlevel |
|
75 |
*observation_--plotvalidationlevel |
|
76 |
*observation_--floristicquality |
|
77 |
*observation_--bryophytequality |
|
78 |
*observation_--lichenquality |
|
79 |
*observation_--observationnarrative |
|
80 |
*observation_--landscapenarrative |
|
81 |
*observation_--homogeneity |
|
82 |
*observation_--phenologicaspect |
|
83 |
*observation_--representativeness |
|
84 |
*observation_--standmaturity |
|
85 |
*observation_--successionalstatus |
|
86 |
*observation_--basalarea |
|
87 |
*observation_--hydrologicregime |
|
88 |
*observation_--soilmoistureregime |
|
89 |
*observation_--soildrainage |
|
90 |
*observation_--watersalinity |
|
91 |
*observation_--waterdepth |
|
92 |
*observation_--shoredistance |
|
93 |
*observation_--soildepth |
|
94 |
*observation_--organicdepth |
|
95 |
*observation_--soiltaxon_id |
|
96 |
*observation_--soiltaxonsrc |
|
97 |
*observation_--percentbedrock |
|
98 |
*observation_--percentrockgravel |
|
99 |
*observation_--percentwood |
|
100 |
*observation_--percentlitter |
|
101 |
*observation_--percentbaresoil |
|
102 |
*observation_--percentwater |
|
103 |
*observation_--percentother |
|
104 |
*observation_--nameother |
|
105 |
*observation_--treeht |
|
106 |
*observation_--shrubht |
|
107 |
*observation_--fieldht |
|
108 |
*observation_--nonvascularht |
|
109 |
*observation_--submergedht |
|
110 |
*observation_--treecover |
|
111 |
*observation_--shrubcover |
|
112 |
*observation_--fieldcover |
|
113 |
*observation_--nonvascularcover |
|
114 |
*observation_--floatingcover |
|
115 |
*observation_--submergedcover |
|
116 |
*observation_--dominantstratum |
|
117 |
*observation_--growthform1type |
|
118 |
*observation_--growthform2type |
|
119 |
*observation_--growthform3type |
|
120 |
*observation_--growthform1cover |
|
121 |
*observation_--growthform2cover |
|
122 |
*observation_--growthform3cover |
|
123 |
*observation_--totalcover |
|
124 |
*observation_--notespublic |
|
125 |
*observation_--notesmgt |
|
126 |
*observation_--revisions |
|
127 |
*observation_--dateentered |
|
128 |
*observation_--emb_observation |
|
129 |
*observation_--interp_orig_ci_id |
|
130 |
*observation_--interp_orig_cc_id |
|
131 |
*observation_--interp_orig_sciname |
|
132 |
*observation_--interp_orig_code |
|
133 |
*observation_--interp_orig_party_id |
|
134 |
*observation_--interp_orig_partyname |
|
135 |
*observation_--interp_current_ci_id |
|
136 |
*observation_--interp_current_cc_id |
|
137 |
*observation_--interp_current_sciname |
|
138 |
*observation_--interp_current_code |
|
139 |
*observation_--interp_current_party_id |
|
140 |
*observation_--interp_current_partyname |
|
141 |
*observation_--interp_bestfit_ci_id |
|
142 |
*observation_--interp_bestfit_cc_id |
|
143 |
*observation_--interp_bestfit_sciname |
|
144 |
*observation_--interp_bestfit_code |
|
145 |
*observation_--interp_bestfit_party_id |
|
146 |
*observation_--interp_bestfit_partyname |
|
147 |
*observation_--toptaxon1name |
|
148 |
*observation_--toptaxon2name |
|
149 |
*observation_--toptaxon3name |
|
150 |
*observation_--toptaxon4name |
|
151 |
*observation_--toptaxon5name |
|
152 |
*observation_--numberoftaxa |
|
153 |
*observation_--accessioncode |
|
154 |
*observation_--soilobs_id |
|
155 |
*observation_--soilhorizon |
|
156 |
*observation_--soildepthtop |
|
157 |
*observation_--soildepthbottom |
|
158 |
*observation_--soilcolor |
|
159 |
*observation_--soilcoarse |
|
160 |
*observation_--soildescription |
|
161 |
*observation_--emb_soilobs |
|
162 |
*plot_--reference_id |
|
163 |
*plot_--confidentialityreason |
|
164 |
*plot_--authore |
|
165 |
*plot_--authorn |
|
166 |
*plot_--authorzone |
|
167 |
*plot_--authordatum |
|
168 |
*plot_--authorlocation |
|
169 |
*plot_--azimuth |
|
170 |
*plot_--dsgpoly |
|
171 |
*plot_--standsize |
|
172 |
*plot_--placementmethod |
|
173 |
*plot_--permanence |
|
174 |
*plot_--layoutnarrative |
|
175 |
*plot_--elevationaccuracy |
|
176 |
*plot_--topoposition |
|
177 |
*plot_--surficialdeposits |
|
178 |
*plot_--rocktype |
|
179 |
*plot_--submitter_surname |
|
180 |
*plot_--submitter_givenname |
|
181 |
*plot_--submitter_email |
|
182 |
*plot_--notespublic |
|
183 |
*plot_--notesmgt |
|
184 |
*plot_--revisions |
|
185 |
*plot_--dateentered |
|
186 |
*plot_--emb_plot |
|
187 |
*plot_--plotrationalenarrative |
|
188 |
*plot_--accessioncode |
|
189 |
*plot_--quadrangle |
|
190 |
*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 |
in_place "$top_file" grep -F '*' |
|
11 |
} |
|
12 |
|
|
13 |
all() |
|
14 |
{ |
|
15 |
echo_func |
|
16 |
filter |
|
17 |
} |
|
18 |
|
|
19 |
fi |
|
0 | 20 |
inputs/VegBank/verify/input_cols.txt | ||
---|---|---|
1 |
sort_col |
|
2 |
locationID |
|
3 |
eventID |
|
4 |
*stratumtype_id |
|
5 |
*stratum_id |
|
6 |
aggregateOrganismObservationID__taxon_presence |
|
7 |
aggregateOrganismObservationID__individual_count |
|
8 |
aggregateOrganismObservationID |
|
9 |
taxonOccurrenceID__overall_plot |
|
10 |
*taxonobservation_--plantname_id |
|
11 |
*taxonobservation_--plantconcept_id |
|
12 |
identificationID |
|
13 |
*taxonobservation_--stemlocation_id |
|
14 |
*taxonobservation_--taxoninterpretation_plantname_id |
|
15 |
*taxonobservation_--taxoninterpretation_party_id |
|
16 |
*taxonobservation_--role_id |
|
17 |
identificationType |
|
18 |
*taxonobservation_--reference_id |
|
19 |
*taxonobservation_--originalinterpretation |
|
20 |
*taxonobservation_--currentinterpretation |
|
21 |
identificationQualifier |
|
22 |
identificationVerificationStatus |
|
23 |
UNUSED#collector_id |
|
24 |
collectorNumber |
|
25 |
*taxonobservation_--museum_id |
|
26 |
accessionNumber |
|
27 |
*taxonobservation_--grouptype |
|
28 |
occurrenceRemarks |
|
29 |
*taxonobservation_--notespublic |
|
30 |
*taxonobservation_--notesmgt |
|
31 |
*taxonobservation_--revisions |
|
32 |
dateIdentified |
|
33 |
dateCollected |
|
34 |
*taxonobservation_--emb_taxoninterpretation |
|
35 |
*taxonobservation_--taxoninterpretation_accessioncode |
|
36 |
originalScientificName |
|
37 |
*taxonobservation_--taxonobservation_reference_id |
|
38 |
*taxonobservation_--taxoninferencearea |
|
39 |
*taxonobservation_--emb_taxonobservation |
|
40 |
*taxonobservation_--int_origplantconcept_id |
|
41 |
EQUIV#to:authorplantname#int_origplantscifull |
|
42 |
originalTaxonName |
|
43 |
originalVernacularName |
|
44 |
*taxonobservation_--int_origplantcode |
|
45 |
*taxonobservation_--int_currplantconcept_id |
|
46 |
scientificName_verbatim |
|
47 |
taxonName |
|
48 |
vernacularName |
|
49 |
*taxonobservation_--int_currplantcode |
|
50 |
*taxonobservation_--taxonobservation_accessioncode |
|
51 |
*plantconcept_--plantconcept_reference_id |
|
52 |
scientificName__for_nearest_taxon_concept |
|
53 |
*plantconcept_--plantcode |
|
54 |
*plantconcept_--plantdescription |
|
55 |
*plantconcept_--d_obscount |
|
56 |
*plantconcept_--d_currentaccepted |
|
57 |
*plantconcept_--plantconcept_accessioncode |
|
58 |
kingdom |
|
59 |
*Subkingdom |
|
60 |
*Superdivision |
|
61 |
*Division |
|
62 |
*Subdivision |
|
63 |
class |
|
64 |
*Subclass |
|
65 |
order |
|
66 |
family |
|
67 |
genus |
|
68 |
EQUIV#to:plantname#Species |
|
69 |
EQUIV#to:plantname#Subspecies |
|
70 |
EQUIV#to:plantname#Variety |
|
71 |
EQUIV#to:plantname#Forma |
|
72 |
DUPLICATE#of:plantconcept_plantname#plantname |
|
73 |
*taxonobservation_--plantname_reference_id |
|
74 |
*taxonobservation_--dateentered |
|
75 |
observationGranularity |
|
76 |
scientificName |
|
77 |
coverPercent |
|
78 |
*stemcount_--basalarea |
|
79 |
*stemcount_--biomass |
|
80 |
*stemcount_--inferencearea |
|
81 |
*stemcount_--stratumbase |
|
82 |
*stemcount_--stratumheight |
|
83 |
*stemcount_--emb_taxonimportance |
|
84 |
*stemcount_--covercode |
|
85 |
diameterBreastHeight_cm |
|
86 |
*stemcount_--stemdiameteraccuracy |
|
87 |
height_m |
|
88 |
*stemcount_--stemheightaccuracy |
|
89 |
individualCount |
|
90 |
*stemcount_--stemtaxonarea |
|
91 |
*stemcount_--emb_stemcount |
|
92 |
stemID |
|
93 |
UNUSED#stemcode |
|
94 |
UNUSED#stemxposition |
|
95 |
UNUSED#stemyposition |
|
96 |
*stemlocation_--stemhealth |
|
97 |
*stemlocation_--emb_stemlocation |
|
98 |
OMIT#stemdiameter |
|
99 |
OMIT#stemdiameteraccuracy |
|
100 |
OMIT#stemheight |
|
101 |
OMIT#stemheightaccuracy |
|
102 |
OMIT#stemcount |
|
103 |
OMIT#stemtaxonarea |
|
104 |
OMIT#emb_stemcount |
|
105 |
individualID |
|
106 |
*stratum--observation_id |
|
107 |
*stratum--stratummethod_id |
|
108 |
*stratum--stratumname |
|
109 |
*stratum--stratumheight |
|
110 |
*stratum--stratumbase |
|
111 |
*stratum--stratumcover |
|
112 |
*stratum--stratumdescription |
|
113 |
*stratumtype--stratummethod_id |
|
114 |
*stratumtype--stratumindex |
|
115 |
stratum__name |
|
116 |
*stratumtype--stratumdescription |
|
117 |
*observation_--previousobs_id |
|
118 |
projectID |
|
119 |
authorEventCode |
|
120 |
*observation_--dateaccuracy |
|
121 |
*observation_--covermethod_id |
|
122 |
*observation_--coverdispersion |
|
123 |
*observation_--autotaxoncover |
|
124 |
*observation_--stratummethod_id |
|
125 |
samplingProtocol |
|
126 |
*observation_--taxonobservationarea |
|
127 |
*observation_--stemsizelimit |
|
128 |
*observation_--stemobservationarea |
|
129 |
*observation_--stemsamplemethod |
|
130 |
*observation_--originaldata |
|
131 |
*observation_--effortlevel |
|
132 |
*observation_--plotvalidationlevel |
|
133 |
*observation_--floristicquality |
|
134 |
*observation_--bryophytequality |
|
135 |
*observation_--lichenquality |
|
136 |
*observation_--observationnarrative |
|
137 |
*observation_--landscapenarrative |
|
138 |
*observation_--homogeneity |
|
139 |
*observation_--phenologicaspect |
|
140 |
*observation_--representativeness |
|
141 |
*observation_--standmaturity |
|
142 |
*observation_--successionalstatus |
|
143 |
*observation_--basalarea |
|
144 |
*observation_--hydrologicregime |
|
145 |
*observation_--soilmoistureregime |
|
146 |
*observation_--soildrainage |
|
147 |
*observation_--watersalinity |
|
148 |
*observation_--waterdepth |
|
149 |
*observation_--shoredistance |
|
150 |
*observation_--soildepth |
|
151 |
*observation_--organicdepth |
|
152 |
*observation_--soiltaxon_id |
|
153 |
*observation_--soiltaxonsrc |
|
154 |
*observation_--percentbedrock |
|
155 |
*observation_--percentrockgravel |
|
156 |
*observation_--percentwood |
|
157 |
*observation_--percentlitter |
|
158 |
*observation_--percentbaresoil |
|
159 |
*observation_--percentwater |
|
160 |
*observation_--percentother |
|
161 |
*observation_--nameother |
|
162 |
*observation_--treeht |
|
163 |
*observation_--shrubht |
|
164 |
*observation_--fieldht |
|
165 |
*observation_--nonvascularht |
|
166 |
*observation_--submergedht |
|
167 |
*observation_--treecover |
|
168 |
*observation_--shrubcover |
|
169 |
*observation_--fieldcover |
|
170 |
*observation_--nonvascularcover |
|
171 |
*observation_--floatingcover |
|
172 |
*observation_--submergedcover |
|
173 |
*observation_--dominantstratum |
|
174 |
*observation_--growthform1type |
|
175 |
*observation_--growthform2type |
|
176 |
*observation_--growthform3type |
|
177 |
*observation_--growthform1cover |
|
178 |
*observation_--growthform2cover |
|
179 |
*observation_--growthform3cover |
|
180 |
*observation_--totalcover |
|
181 |
*observation_--notespublic |
|
182 |
*observation_--notesmgt |
|
183 |
*observation_--revisions |
|
184 |
startDate |
|
185 |
endDate |
|
186 |
*observation_--dateentered |
|
187 |
*observation_--emb_observation |
|
188 |
*observation_--interp_orig_ci_id |
|
189 |
*observation_--interp_orig_cc_id |
|
190 |
*observation_--interp_orig_sciname |
|
191 |
*observation_--interp_orig_code |
|
192 |
*observation_--interp_orig_party_id |
|
193 |
*observation_--interp_orig_partyname |
|
194 |
*observation_--interp_current_ci_id |
|
195 |
*observation_--interp_current_cc_id |
|
196 |
*observation_--interp_current_sciname |
|
197 |
*observation_--interp_current_code |
|
198 |
*observation_--interp_current_party_id |
|
199 |
*observation_--interp_current_partyname |
|
200 |
*observation_--interp_bestfit_ci_id |
|
201 |
*observation_--interp_bestfit_cc_id |
|
202 |
*observation_--interp_bestfit_sciname |
|
203 |
*observation_--interp_bestfit_code |
|
204 |
*observation_--interp_bestfit_party_id |
|
205 |
*observation_--interp_bestfit_partyname |
|
206 |
*observation_--toptaxon1name |
|
207 |
*observation_--toptaxon2name |
|
208 |
*observation_--toptaxon3name |
|
209 |
*observation_--toptaxon4name |
|
210 |
*observation_--toptaxon5name |
|
211 |
*observation_--numberoftaxa |
|
212 |
*observation_--accessioncode |
|
213 |
*observation_--soilobs_id |
|
214 |
*observation_--soilhorizon |
|
215 |
*observation_--soildepthtop |
|
216 |
*observation_--soildepthbottom |
|
217 |
*observation_--soilcolor |
|
218 |
organic_percent |
|
219 |
texture |
|
220 |
sand_percent |
|
221 |
silt_percent |
|
222 |
clay_percent |
|
223 |
*observation_--soilcoarse |
|
224 |
ph |
|
225 |
cationExchangeCapacity_cmol_kg |
|
226 |
baseSaturation_percent |
|
227 |
*observation_--soildescription |
|
228 |
*observation_--emb_soilobs |
|
229 |
emb_soilobs |
|
230 |
locationName |
|
231 |
*plot_--reference_id |
|
232 |
parentLocationID |
|
233 |
coordinateUncertaintyInMeters__from_coords |
|
234 |
accessRights_verbatim |
|
235 |
*plot_--confidentialityreason |
|
236 |
decimalLatitude |
|
237 |
decimalLongitude |
|
238 |
*plot_--authore |
|
239 |
*plot_--authorn |
|
240 |
*plot_--authorzone |
|
241 |
*plot_--authordatum |
|
242 |
*plot_--authorlocation |
|
243 |
locality |
|
244 |
*plot_--azimuth |
|
245 |
*plot_--dsgpoly |
|
246 |
footprintWKT |
|
247 |
plotArea_m2 |
|
248 |
*plot_--standsize |
|
249 |
*plot_--placementmethod |
|
250 |
*plot_--permanence |
|
251 |
*plot_--layoutnarrative |
|
252 |
elevationInMeters |
|
253 |
*plot_--elevationaccuracy |
|
254 |
UNUSED#elevationrange |
|
255 |
slopeAspect |
|
256 |
minSlopeAspect |
|
257 |
maxSlopeAspect |
|
258 |
slopeGradient |
|
259 |
minSlopeGradient |
|
260 |
maxSlopeGradient |
|
261 |
*plot_--topoposition |
|
262 |
landform |
|
263 |
*plot_--surficialdeposits |
|
264 |
*plot_--rocktype |
|
265 |
stateProvince |
|
266 |
country |
|
267 |
*plot_--submitter_surname |
|
268 |
*plot_--submitter_givenname |
|
269 |
*plot_--submitter_email |
|
270 |
*plot_--notespublic |
|
271 |
*plot_--notesmgt |
|
272 |
*plot_--revisions |
|
273 |
*plot_--dateentered |
|
274 |
*plot_--emb_plot |
|
275 |
*plot_--plotrationalenarrative |
|
276 |
*plot_--accessioncode |
|
277 |
continent |
|
278 |
DUPLICATE#of:country#area|country|territory |
|
279 |
DUPLICATE#of:stateprovince#region|state|province |
|
280 |
county |
|
281 |
*plot_--quadrangle |
|
282 |
*plot_--Geographic Name |
|
283 |
accessRights |
|
284 |
coordinateUncertaintyInMeters__from_fuzzing |
|
285 |
coordinateUncertaintyInMeters |
|
286 |
taxonOccurrenceID |
Also available in: Unified diff
added inputs/VegBank/verify/input_cols.txt, input_cols.unmapped.txt (with runscript to filter input_cols.unmapped.txt)