Project

General

Profile

« Previous | Next » 

Revision 11235

added inputs/VegBank/verify/input_cols.txt, input_cols.unmapped.txt (with runscript to filter input_cols.unmapped.txt)

View differences:

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