Project

General

Profile

« Previous | Next » 

Revision 13947

fix: mappings/VegCore-VegBIEN.csv: mapped DwC year/month/day, which are split-date alternatives to eventDate. this fixes the missing eventDate in FIA.

View differences:

trunk/inputs/FIA/PLOT/test.xml.ref
9 9
                    <location>
10 10
                        <authorlocationcode>$locationName</authorlocationcode>
11 11
                        <sourceaccessioncode>$locationID</sourceaccessioncode>
12
                        <locationevent>
13
                            <obsenddate>
14
                                <_date>
15
                                    <day>
16
                                        <_nullIf>
17
                                            <null>0</null>
18
                                            <type>float</type>
19
                                            <value>$day</value>
20
                                        </_nullIf>
21
                                    </day>
22
                                    <month>
23
                                        <_nullIf>
24
                                            <null>0</null>
25
                                            <type>float</type>
26
                                            <value>$month</value>
27
                                        </_nullIf>
28
                                    </month>
29
                                    <year>
30
                                        <_nullIf>
31
                                            <null>0</null>
32
                                            <type>float</type>
33
                                            <value>$year</value>
34
                                        </_nullIf>
35
                                    </year>
36
                                </_date>
37
                            </obsenddate>
38
                            <obsstartdate>
39
                                <_date>
40
                                    <day>
41
                                        <_nullIf>
42
                                            <null>0</null>
43
                                            <type>float</type>
44
                                            <value>$day</value>
45
                                        </_nullIf>
46
                                    </day>
47
                                    <month>
48
                                        <_nullIf>
49
                                            <null>0</null>
50
                                            <type>float</type>
51
                                            <value>$month</value>
52
                                        </_nullIf>
53
                                    </month>
54
                                    <year>
55
                                        <_nullIf>
56
                                            <null>0</null>
57
                                            <type>float</type>
58
                                            <value>$year</value>
59
                                        </_nullIf>
60
                                    </year>
61
                                </_date>
62
                            </obsstartdate>
63
                        </locationevent>
12 64
                        <locationplace>
13 65
                            <place_id>
14 66
                                <place>
......
63 115
        </path>
64 116
    </_setDefault>
65 117
</VegBIEN>
66
Inserted 10 new rows into database
118
Inserted 12 new rows into database
trunk/inputs/FIA/PLOT/unmapped_terms.csv
8 8
*COUNTYCD
9 9
*PLOT--PLOT_STATUS_CD
10 10
*PLOT--PLOT_NONSAMPLE_REASN_CD
11
year
12
month
13
day
14 11
*PLOT--REMPER
15 12
*PLOT--KINDCD
16 13
*PLOT--DESIGNCD
trunk/inputs/FIA/taxon_observation.**/test.xml.ref
158 158
                                    </taxondetermination>
159 159
                                </taxonoccurrence>
160 160
                            </locationevent>
161
                            <obsenddate>
162
                                <_date>
163
                                    <day>
164
                                        <_nullIf>
165
                                            <null>0</null>
166
                                            <type>float</type>
167
                                            <value>$day</value>
168
                                        </_nullIf>
169
                                    </day>
170
                                    <month>
171
                                        <_nullIf>
172
                                            <null>0</null>
173
                                            <type>float</type>
174
                                            <value>$month</value>
175
                                        </_nullIf>
176
                                    </month>
177
                                    <year>
178
                                        <_nullIf>
179
                                            <null>0</null>
180
                                            <type>float</type>
181
                                            <value>$year</value>
182
                                        </_nullIf>
183
                                    </year>
184
                                </_date>
185
                            </obsenddate>
186
                            <obsstartdate>
187
                                <_date>
188
                                    <day>
189
                                        <_nullIf>
190
                                            <null>0</null>
191
                                            <type>float</type>
192
                                            <value>$day</value>
193
                                        </_nullIf>
194
                                    </day>
195
                                    <month>
196
                                        <_nullIf>
197
                                            <null>0</null>
198
                                            <type>float</type>
199
                                            <value>$month</value>
200
                                        </_nullIf>
201
                                    </month>
202
                                    <year>
203
                                        <_nullIf>
204
                                            <null>0</null>
205
                                            <type>float</type>
206
                                            <value>$year</value>
207
                                        </_nullIf>
208
                                    </year>
209
                                </_date>
210
                            </obsstartdate>
161 211
                        </locationevent>
162 212
                        <locationplace>
163 213
                            <place_id>
trunk/inputs/FIA/taxon_observation.**/unmapped_terms.csv
386 386
*PLOT--PREV_PLT_CN
387 387
*PLOT--PLOT_STATUS_CD
388 388
*PLOT--PLOT_NONSAMPLE_REASN_CD
389
year
390
month
391
day
392 389
*PLOT--REMPER
393 390
*PLOT--KINDCD
394 391
*PLOT--DESIGNCD
trunk/mappings/VegCore-VegBIEN.csv
312 312
event__participant,/location/locationevent/locationeventcontributor[!*_id/party]/*_id/party/fullname,use [!...] negative lookahead assertion so that multiple event__participant columns will properly map to separate locationeventcontributor rows
313 313
endDate,/location/locationevent/obsenddate/_alt/1,
314 314
eventDate,/location/locationevent/obsenddate/_alt/2/_dateRangeEnd/value,
315
day,"/location/locationevent/obsenddate/_alt/3/_date/day/_nullIf:[null=0,type=float]/value",
316
month,"/location/locationevent/obsenddate/_alt/3/_date/month/_nullIf:[null=0,type=float]/value",
317
year,"/location/locationevent/obsenddate/_alt/3/_date/year/_nullIf:[null=0,type=float]/value",
315 318
startDate,/location/locationevent/obsstartdate/_alt/1,
316 319
eventDate,/location/locationevent/obsstartdate/_alt/2/_dateRangeStart/value,
320
day,"/location/locationevent/obsstartdate/_alt/3/_date/day/_nullIf:[null=0,type=float]/value",
321
month,"/location/locationevent/obsstartdate/_alt/3/_date/month/_nullIf:[null=0,type=float]/value",
322
year,"/location/locationevent/obsstartdate/_alt/3/_date/year/_nullIf:[null=0,type=float]/value",
317 323
precipitation_m,/location/locationevent/precipitation_m,
318 324
precipitation_mm,/location/locationevent/precipitation_m/_mm_to_m/value,
319 325
acidity_percent,/location/locationevent/soilsample/acidity_fraction/_percent_to_fraction/value,
trunk/mappings/for_review/VegCore-VegBIEN.csv
312 312
event__participant,//locationevent/locationeventcontributor[]/*_id/party/fullname,use [!...] negative lookahead assertion so that multiple event__participant columns will properly map to separate locationeventcontributor rows
313 313
endDate,//locationevent/obsenddate,
314 314
eventDate,//locationevent/obsenddate,
315
day,//locationevent/obsenddate,
316
month,//locationevent/obsenddate,
317
year,//locationevent/obsenddate,
315 318
startDate,//locationevent/obsstartdate,
316 319
eventDate,//locationevent/obsstartdate,
320
day,//locationevent/obsstartdate,
321
month,//locationevent/obsstartdate,
322
year,//locationevent/obsstartdate,
317 323
precipitation_m,//locationevent/precipitation_m,
318 324
precipitation_mm,//locationevent/precipitation_m/_mm_to_m/value,
319 325
acidity_percent,//soilsample/acidity_fraction/_percent_to_fraction/value,

Also available in: Unified diff