Project

General

Profile

« Previous | Next » 

Revision 5656

schemas/vegbien.sql: taxonlabel: Renamed identifyingtaxonomicname to taxonomicname because the taxonomicname provided by the datasource is now in taxonverbatim, so there is no name collision. Note that both of these fields store the same type of information, but taxonlabel's is autogenerated while taxonverbatim's is verbatim (and is only set if provided by the datasource).

View differences:

test.xml.ref
236 236
                                                    <organizationname>TNRS</organizationname>
237 237
                                                </party>
238 238
                                            </creator_id>
239
                                            <identifyingtaxonomicname>
239
                                            <taxonomicname>
240 240
                                                <_join_words>
241 241
                                                    <1>
242 242
                                                        <_alt>
......
289 289
                                                        </_alt>
290 290
                                                    </2>
291 291
                                                </_join_words>
292
                                            </identifyingtaxonomicname>
292
                                            </taxonomicname>
293 293
                                        </taxonlabel>
294 294
                                    </matched_label_id>
295 295
                                    <creationdate>
......
338 338
                                            </path>
339 339
                                        </_simplifyPath>
340 340
                                    </creator_id>
341
                                    <identifyingtaxonomicname>
342
                                        <_join_words>
343
                                            <1>
344
                                                <_alt>
345
                                                    <1>
346
                                                        <_alt>
347
                                                            <0>$conceptual_darwin_2003_1_0_ScientificName</0>
348
                                                            <1>$dwc_dwcore_ScientificName</1>
349
                                                            <2>$dwc_terms_scientificName</2>
350
                                                        </_alt>
351
                                                    </1>
352
                                                    <2>
353
                                                        <_join_words>
354
                                                            <1>
355
                                                                <_alt>
356
                                                                    <0>$conceptual_darwin_2003_1_0_Family</0>
357
                                                                    <1>$dwc_dwcore_Family</1>
358
                                                                    <2>$dwc_terms_family</2>
359
                                                                </_alt>
360
                                                            </1>
361
                                                            <2>
362
                                                                <_alt>
363
                                                                    <0>$conceptual_darwin_2003_1_0_Genus</0>
364
                                                                    <1>$dwc_dwcore_Genus</1>
365
                                                                    <2>$dwc_terms_genus</2>
366
                                                                </_alt>
367
                                                            </2>
368
                                                            <3>
369
                                                                <_alt>
370
                                                                    <0>$conceptual_darwin_2003_1_0_Species</0>
371
                                                                    <1>$dwc_dwcore_SpecificEpithet</1>
372
                                                                    <2>$dwc_terms_specificEpithet</2>
373
                                                                </_alt>
374
                                                            </3>
375
                                                            <4>$conceptual_darwin_2003_1_0_Subspecies</4>
376
                                                            <5>
377
                                                                <_alt>
378
                                                                    <0>$dwc_dwcore_InfraspecificEpithet</0>
379
                                                                    <1>$dwc_terms_infraspecificEpithet</1>
380
                                                                </_alt>
381
                                                            </5>
382
                                                        </_join_words>
383
                                                    </2>
384
                                                </_alt>
385
                                            </1>
386
                                            <2>
387
                                                <_alt>
388
                                                    <1>$dwc_terms_scientificNameAuthorship</1>
389
                                                    <2>$conceptual_darwin_2003_1_0_ScientificNameAuthor</2>
390
                                                    <3>$dwc_dwcore_AuthorYearOfScientificName</3>
391
                                                </_alt>
392
                                            </2>
393
                                        </_join_words>
394
                                    </identifyingtaxonomicname>
395 341
                                    <parent_id>
396 342
                                        <taxonlabel>
397 343
                                            <parent_id>
......
507 453
                                            </taxonepithet>
508 454
                                        </taxonlabel>
509 455
                                    </parent_id>
456
                                    <taxonomicname>
457
                                        <_join_words>
458
                                            <1>
459
                                                <_alt>
460
                                                    <1>
461
                                                        <_alt>
462
                                                            <0>$conceptual_darwin_2003_1_0_ScientificName</0>
463
                                                            <1>$dwc_dwcore_ScientificName</1>
464
                                                            <2>$dwc_terms_scientificName</2>
465
                                                        </_alt>
466
                                                    </1>
467
                                                    <2>
468
                                                        <_join_words>
469
                                                            <1>
470
                                                                <_alt>
471
                                                                    <0>$conceptual_darwin_2003_1_0_Family</0>
472
                                                                    <1>$dwc_dwcore_Family</1>
473
                                                                    <2>$dwc_terms_family</2>
474
                                                                </_alt>
475
                                                            </1>
476
                                                            <2>
477
                                                                <_alt>
478
                                                                    <0>$conceptual_darwin_2003_1_0_Genus</0>
479
                                                                    <1>$dwc_dwcore_Genus</1>
480
                                                                    <2>$dwc_terms_genus</2>
481
                                                                </_alt>
482
                                                            </2>
483
                                                            <3>
484
                                                                <_alt>
485
                                                                    <0>$conceptual_darwin_2003_1_0_Species</0>
486
                                                                    <1>$dwc_dwcore_SpecificEpithet</1>
487
                                                                    <2>$dwc_terms_specificEpithet</2>
488
                                                                </_alt>
489
                                                            </3>
490
                                                            <4>$conceptual_darwin_2003_1_0_Subspecies</4>
491
                                                            <5>
492
                                                                <_alt>
493
                                                                    <0>$dwc_dwcore_InfraspecificEpithet</0>
494
                                                                    <1>$dwc_terms_infraspecificEpithet</1>
495
                                                                </_alt>
496
                                                            </5>
497
                                                        </_join_words>
498
                                                    </2>
499
                                                </_alt>
500
                                            </1>
501
                                            <2>
502
                                                <_alt>
503
                                                    <1>$dwc_terms_scientificNameAuthorship</1>
504
                                                    <2>$conceptual_darwin_2003_1_0_ScientificNameAuthor</2>
505
                                                    <3>$dwc_dwcore_AuthorYearOfScientificName</3>
506
                                                </_alt>
507
                                            </2>
508
                                        </_join_words>
509
                                    </taxonomicname>
510 510
                                    <taxonverbatim>
511 511
                                        <author>
512 512
                                            <_alt>

Also available in: Unified diff