Project

General

Profile

« Previous | Next » 

Revision 4504

intersect, union: Made case- and punctuation-insensitive. mappings/Veg+-VegBIEN.csv: Removed no longer needed duplicate entries for each first letter case, which must now be removed for case- and punctuation-insensitive intersect/union to work. Note that the SpeciesLink `svn diff` hides _alt entry 0, which contains one of the removed duplicate columns that appears in the diff.

View differences:

test.xml.ref
11 11
                                <0>$dwc_dwcore_InstitutionCode</0>
12 12
                                <1>$dwc_terms_institutionCode</1>
13 13
                                <2>$conceptual_darwin_2003_1_0_InstitutionCode</2>
14
                                <3>$dwc_dwcore_InstitutionCode</3>
15
                                <4>$dwc_terms_institutionCode</4>
16
                                <5>$conceptual_darwin_2003_1_0_InstitutionCode</5>
17 14
                            </_alt>
18 15
                        </1>
19 16
                        <2>
......
23 20
                                        <0>$dwc_dwcore_CollectionCode</0>
24 21
                                        <1>$dwc_terms_collectionCode</1>
25 22
                                        <2>$conceptual_darwin_2003_1_0_CollectionCode</2>
26
                                        <3>$dwc_dwcore_CollectionCode</3>
27
                                        <4>$dwc_terms_collectionCode</4>
28
                                        <5>$conceptual_darwin_2003_1_0_CollectionCode</5>
29 23
                                    </_alt>
30 24
                                </1>
31 25
                                <2>$dwc_terms_collectionID</2>
......
36 30
                                <0>$dwc_dwcore_CatalogNumber</0>
37 31
                                <1>$dwc_terms_catalogNumber</1>
38 32
                                <2>$conceptual_darwin_2003_1_0_CatalogNumber</2>
39
                                <3>$dwc_dwcore_CatalogNumber</3>
40
                                <4>$dwc_terms_catalogNumber</4>
41
                                <5>$conceptual_darwin_2003_1_0_CatalogNumber</5>
42 33
                            </_alt>
43 34
                        </3>
44 35
                    </_join>
......
60 51
                                        <0>$conceptual_darwin_2003_1_0_MaximumElevation</0>
61 52
                                        <1>$dwc_dwcore_MaximumElevationInMeters</1>
62 53
                                        <2>$dwc_terms_maximumElevationInMeters</2>
63
                                        <3>$dwc_dwcore_MaximumElevationInMeters</3>
64
                                        <4>$dwc_terms_maximumElevationInMeters</4>
65 54
                                    </_alt>
66 55
                                </value>
67 56
                            </_replace>
......
83 72
                                                <0>$conceptual_darwin_2003_1_0_MinimumElevation</0>
84 73
                                                <1>$dwc_dwcore_MinimumElevationInMeters</1>
85 74
                                                <2>$dwc_terms_minimumElevationInMeters</2>
86
                                                <3>$dwc_dwcore_MinimumElevationInMeters</3>
87
                                                <4>$dwc_terms_minimumElevationInMeters</4>
88 75
                                            </_alt>
89 76
                                        </value>
90 77
                                    </_replace>
......
112 99
                                                <0>$conceptual_darwin_2003_1_0_MinimumElevation</0>
113 100
                                                <1>$dwc_dwcore_MinimumElevationInMeters</1>
114 101
                                                <2>$dwc_terms_minimumElevationInMeters</2>
115
                                                <3>$dwc_dwcore_MinimumElevationInMeters</3>
116
                                                <4>$dwc_terms_minimumElevationInMeters</4>
117 102
                                            </_alt>
118 103
                                        </value>
119 104
                                    </_replace>
......
137 122
                                                <0>$conceptual_darwin_2003_1_0_MaximumElevation</0>
138 123
                                                <1>$dwc_dwcore_MaximumElevationInMeters</1>
139 124
                                                <2>$dwc_terms_maximumElevationInMeters</2>
140
                                                <3>$dwc_dwcore_MaximumElevationInMeters</3>
141
                                                <4>$dwc_terms_maximumElevationInMeters</4>
142 125
                                            </_alt>
143 126
                                        </value>
144 127
                                    </_replace>
......
153 136
                                                        <0>$conceptual_darwin_2003_1_0_MinimumElevation</0>
154 137
                                                        <1>$dwc_dwcore_MinimumElevationInMeters</1>
155 138
                                                        <2>$dwc_terms_minimumElevationInMeters</2>
156
                                                        <3>$dwc_dwcore_MinimumElevationInMeters</3>
157
                                                        <4>$dwc_terms_minimumElevationInMeters</4>
158 139
                                                    </_alt>
159 140
                                                </value>
160 141
                                            </_replace>
......
189 170
                                <_alt>
190 171
                                    <0>$dwc_geospatial_DecimalLatitude</0>
191 172
                                    <1>$dwc_terms_decimalLatitude</1>
192
                                    <2>$dwc_geospatial_DecimalLatitude</2>
193
                                    <3>$dwc_terms_decimalLatitude</3>
194 173
                                </_alt>
195 174
                            </value>
196 175
                        </_nullIf>
......
204 183
                                    <0>$conceptual_darwin_2003_1_0_Latitude</0>
205 184
                                    <1>$dwc_geospatial_VerbatimLatitude</1>
206 185
                                    <2>$dwc_terms_verbatimLatitude</2>
207
                                    <3>$dwc_geospatial_VerbatimLatitude</3>
208
                                    <4>$dwc_terms_verbatimLatitude</4>
209 186
                                </_alt>
210 187
                            </value>
211 188
                        </_nullIf>
......
222 199
                                <_alt>
223 200
                                    <0>$dwc_geospatial_DecimalLongitude</0>
224 201
                                    <1>$dwc_terms_decimalLongitude</1>
225
                                    <2>$dwc_geospatial_DecimalLongitude</2>
226
                                    <3>$dwc_terms_decimalLongitude</3>
227 202
                                </_alt>
228 203
                            </value>
229 204
                        </_nullIf>
......
237 212
                                    <0>$conceptual_darwin_2003_1_0_Longitude</0>
238 213
                                    <1>$dwc_geospatial_VerbatimLongitude</1>
239 214
                                    <2>$dwc_terms_verbatimLongitude</2>
240
                                    <3>$dwc_geospatial_VerbatimLongitude</3>
241
                                    <4>$dwc_terms_verbatimLongitude</4>
242 215
                                </_alt>
243 216
                            </value>
244 217
                        </_nullIf>
......
257 230
                                    <0>$dwc_dwcore_County</0>
258 231
                                    <1>$dwc_terms_county</1>
259 232
                                    <2>$conceptual_darwin_2003_1_0_County</2>
260
                                    <3>$dwc_dwcore_County</3>
261
                                    <4>$dwc_terms_county</4>
262
                                    <5>$conceptual_darwin_2003_1_0_County</5>
263 233
                                </_alt>
264 234
                            </placename>
265 235
                            <parent_id>
......
270 240
                                            <0>$dwc_dwcore_StateProvince</0>
271 241
                                            <1>$dwc_terms_stateProvince</1>
272 242
                                            <2>$conceptual_darwin_2003_1_0_StateProvince</2>
273
                                            <3>$dwc_dwcore_StateProvince</3>
274
                                            <4>$dwc_terms_stateProvince</4>
275
                                            <5>$conceptual_darwin_2003_1_0_StateProvince</5>
276 243
                                        </_alt>
277 244
                                    </placename>
278 245
                                    <parent_id>
......
283 250
                                                    <0>$dwc_dwcore_Country</0>
284 251
                                                    <1>$dwc_terms_country</1>
285 252
                                                    <2>$conceptual_darwin_2003_1_0_Country</2>
286
                                                    <3>$dwc_dwcore_Country</3>
287
                                                    <4>$dwc_terms_country</4>
288
                                                    <5>$conceptual_darwin_2003_1_0_Country</5>
289 253
                                                </_alt>
290 254
                                            </placename>
291 255
                                            <parent_id>
......
296 260
                                                            <0>$dwc_dwcore_Continent</0>
297 261
                                                            <1>$dwc_terms_continent</1>
298 262
                                                            <2>$conceptual_darwin_2003_1_0_ContinentOcean</2>
299
                                                            <3>$dwc_dwcore_Continent</3>
300
                                                            <4>$dwc_terms_continent</4>
301 263
                                                        </_alt>
302 264
                                                    </placename>
303 265
                                                </namedplace>
......
414 376
                            <0>$dwc_curatorial_IndividualCount</0>
415 377
                            <1>$dwc_terms_individualCount</1>
416 378
                            <2>$conceptual_darwin_2003_1_0_IndividualCount</2>
417
                            <3>$dwc_curatorial_IndividualCount</3>
418
                            <4>$dwc_terms_individualCount</4>
419
                            <5>$conceptual_darwin_2003_1_0_IndividualCount</5>
420 379
                        </_alt>
421 380
                    </count>
422 381
                    <notes>$conceptual_darwin_2003_1_0_Notes</notes>
......
438 397
                                        <3>$dwc_curatorial_FieldNumber</3>
439 398
                                        <4>$dwc_terms_fieldNumber</4>
440 399
                                        <5>$conceptual_darwin_2003_1_0_FieldNumber</5>
441
                                        <6>$dwc_curatorial_FieldNumber</6>
442
                                        <7>$dwc_terms_fieldNumber</7>
443
                                        <8>$conceptual_darwin_2003_1_0_FieldNumber</8>
444
                                        <9>$dwc_curatorial_FieldNumber</9>
445
                                        <10>$dwc_terms_fieldNumber</10>
446
                                        <11>$conceptual_darwin_2003_1_0_FieldNumber</11>
447 400
                                    </_alt>
448 401
                                </2>
449 402
                            </_alt>
......
460 413
                                    <0>$dwc_dwcore_Sex</0>
461 414
                                    <1>$dwc_terms_sex</1>
462 415
                                    <2>$conceptual_darwin_2003_1_0_Sex</2>
463
                                    <3>$dwc_dwcore_Sex</3>
464
                                    <4>$dwc_terms_sex</4>
465
                                    <5>$conceptual_darwin_2003_1_0_Sex</5>
466 416
                                </_alt>
467 417
                            </definedvalue>
468 418
                        </definedvalue>
......
472 422
                                    <0>$dwc_dwcore_CatalogNumber</0>
473 423
                                    <1>$dwc_terms_catalogNumber</1>
474 424
                                    <2>$conceptual_darwin_2003_1_0_CatalogNumber</2>
475
                                    <3>$dwc_dwcore_CatalogNumber</3>
476
                                    <4>$dwc_terms_catalogNumber</4>
477
                                    <5>$conceptual_darwin_2003_1_0_CatalogNumber</5>
478 425
                                </_alt>
479 426
                            </catalognumber_dwc>
480 427
                            <collectioncode_dwc>
......
484 431
                                            <0>$dwc_dwcore_CollectionCode</0>
485 432
                                            <1>$dwc_terms_collectionCode</1>
486 433
                                            <2>$conceptual_darwin_2003_1_0_CollectionCode</2>
487
                                            <3>$dwc_dwcore_CollectionCode</3>
488
                                            <4>$dwc_terms_collectionCode</4>
489
                                            <5>$conceptual_darwin_2003_1_0_CollectionCode</5>
490 434
                                        </_alt>
491 435
                                    </1>
492 436
                                    <2>$dwc_terms_collectionID</2>
......
499 443
                                            <0>$dwc_dwcore_InstitutionCode</0>
500 444
                                            <1>$dwc_terms_institutionCode</1>
501 445
                                            <2>$conceptual_darwin_2003_1_0_InstitutionCode</2>
502
                                            <3>$dwc_dwcore_InstitutionCode</3>
503
                                            <4>$dwc_terms_institutionCode</4>
504
                                            <5>$conceptual_darwin_2003_1_0_InstitutionCode</5>
505 446
                                        </_alt>
506 447
                                    </organizationname>
507 448
                                </party>
......
529 470
                                        <3>$dwc_curatorial_FieldNumber</3>
530 471
                                        <4>$dwc_terms_fieldNumber</4>
531 472
                                        <5>$conceptual_darwin_2003_1_0_FieldNumber</5>
532
                                        <6>$dwc_curatorial_FieldNumber</6>
533
                                        <7>$dwc_terms_fieldNumber</7>
534
                                        <8>$conceptual_darwin_2003_1_0_FieldNumber</8>
535
                                        <9>$dwc_curatorial_FieldNumber</9>
536
                                        <10>$dwc_terms_fieldNumber</10>
537
                                        <11>$conceptual_darwin_2003_1_0_FieldNumber</11>
538 473
                                    </_alt>
539 474
                                </2>
540 475
                            </_alt>
......
544 479
                                <0>$dwc_dwcore_ScientificName</0>
545 480
                                <1>$dwc_terms_scientificName</1>
546 481
                                <2>$conceptual_darwin_2003_1_0_ScientificName</2>
547
                                <3>$dwc_dwcore_ScientificName</3>
548
                                <4>$dwc_terms_scientificName</4>
549
                                <5>$conceptual_darwin_2003_1_0_ScientificName</5>
550 482
                            </_alt>
551 483
                        </2>
552 484
                    </_alt>
......
561 493
                                            <0>$dwc_curatorial_IdentifiedBy</0>
562 494
                                            <1>$dwc_terms_identifiedBy</1>
563 495
                                            <2>$conceptual_darwin_2003_1_0_IdentifiedBy</2>
564
                                            <3>$dwc_curatorial_IdentifiedBy</3>
565
                                            <4>$dwc_terms_identifiedBy</4>
566
                                            <5>$conceptual_darwin_2003_1_0_IdentifiedBy</5>
567 496
                                        </_alt>
568 497
                                    </first>
569 498
                                </_namePart>
......
575 504
                                            <0>$dwc_curatorial_IdentifiedBy</0>
576 505
                                            <1>$dwc_terms_identifiedBy</1>
577 506
                                            <2>$conceptual_darwin_2003_1_0_IdentifiedBy</2>
578
                                            <3>$dwc_curatorial_IdentifiedBy</3>
579
                                            <4>$dwc_terms_identifiedBy</4>
580
                                            <5>$conceptual_darwin_2003_1_0_IdentifiedBy</5>
581 507
                                        </_alt>
582 508
                                    </middle>
583 509
                                </_namePart>
......
589 515
                                            <0>$dwc_curatorial_IdentifiedBy</0>
590 516
                                            <1>$dwc_terms_identifiedBy</1>
591 517
                                            <2>$conceptual_darwin_2003_1_0_IdentifiedBy</2>
592
                                            <3>$dwc_curatorial_IdentifiedBy</3>
593
                                            <4>$dwc_terms_identifiedBy</4>
594
                                            <5>$conceptual_darwin_2003_1_0_IdentifiedBy</5>
595 518
                                        </_alt>
596 519
                                    </last>
597 520
                                </_namePart>
......
611 534
                                                    <0>$dwc_dwcore_ScientificName</0>
612 535
                                                    <1>$dwc_terms_scientificName</1>
613 536
                                                    <2>$conceptual_darwin_2003_1_0_ScientificName</2>
614
                                                    <3>$dwc_dwcore_ScientificName</3>
615
                                                    <4>$dwc_terms_scientificName</4>
616
                                                    <5>$conceptual_darwin_2003_1_0_ScientificName</5>
617 537
                                                </_alt>
618 538
                                            </plantname>
619 539
                                            <parent_id>
......
634 554
                                                                    <0>$dwc_dwcore_InfraspecificEpithet</0>
635 555
                                                                    <1>$dwc_terms_infraspecificEpithet</1>
636 556
                                                                    <2>$conceptual_darwin_2003_1_0_Subspecies</2>
637
                                                                    <3>$dwc_dwcore_InfraspecificEpithet</3>
638
                                                                    <4>$dwc_terms_infraspecificEpithet</4>
639 557
                                                                </_alt>
640 558
                                                            </plantname>
641 559
                                                            <parent_id>
......
646 564
                                                                            <0>$conceptual_darwin_2003_1_0_Species</0>
647 565
                                                                            <1>$dwc_dwcore_SpecificEpithet</1>
648 566
                                                                            <2>$dwc_terms_specificEpithet</2>
649
                                                                            <3>$dwc_dwcore_SpecificEpithet</3>
650
                                                                            <4>$dwc_terms_specificEpithet</4>
651 567
                                                                        </_alt>
652 568
                                                                    </plantname>
653 569
                                                                    <parent_id>
......
658 574
                                                                                    <0>$dwc_dwcore_Genus</0>
659 575
                                                                                    <1>$dwc_terms_genus</1>
660 576
                                                                                    <2>$conceptual_darwin_2003_1_0_Genus</2>
661
                                                                                    <3>$dwc_dwcore_Genus</3>
662
                                                                                    <4>$dwc_terms_genus</4>
663
                                                                                    <5>$conceptual_darwin_2003_1_0_Genus</5>
664 577
                                                                                </_alt>
665 578
                                                                            </plantname>
666 579
                                                                            <parent_id>
......
671 584
                                                                                            <0>$dwc_dwcore_Family</0>
672 585
                                                                                            <1>$dwc_terms_family</1>
673 586
                                                                                            <2>$conceptual_darwin_2003_1_0_Family</2>
674
                                                                                            <3>$dwc_dwcore_Family</3>
675
                                                                                            <4>$dwc_terms_family</4>
676
                                                                                            <5>$conceptual_darwin_2003_1_0_Family</5>
677 587
                                                                                        </_alt>
678 588
                                                                                    </plantname>
679 589
                                                                                    <parent_id>
......
684 594
                                                                                                    <0>$dwc_dwcore_Order</0>
685 595
                                                                                                    <1>$dwc_terms_order</1>
686 596
                                                                                                    <2>$conceptual_darwin_2003_1_0_Order</2>
687
                                                                                                    <3>$dwc_dwcore_Order</3>
688
                                                                                                    <4>$dwc_terms_order</4>
689
                                                                                                    <5>$conceptual_darwin_2003_1_0_Order</5>
690 597
                                                                                                </_alt>
691 598
                                                                                            </plantname>
692 599
                                                                                            <parent_id>
......
697 604
                                                                                                            <0>$dwc_dwcore_Class</0>
698 605
                                                                                                            <1>$dwc_terms_class</1>
699 606
                                                                                                            <2>$conceptual_darwin_2003_1_0_Class</2>
700
                                                                                                            <3>$dwc_dwcore_Class</3>
701
                                                                                                            <4>$dwc_terms_class</4>
702
                                                                                                            <5>$conceptual_darwin_2003_1_0_Class</5>
703 607
                                                                                                        </_alt>
704 608
                                                                                                    </plantname>
705 609
                                                                                                    <parent_id>
......
710 614
                                                                                                                    <0>$dwc_dwcore_Phylum</0>
711 615
                                                                                                                    <1>$dwc_terms_phylum</1>
712 616
                                                                                                                    <2>$conceptual_darwin_2003_1_0_Phylum</2>
713
                                                                                                                    <3>$dwc_dwcore_Phylum</3>
714
                                                                                                                    <4>$dwc_terms_phylum</4>
715
                                                                                                                    <5>$conceptual_darwin_2003_1_0_Phylum</5>
716 617
                                                                                                                </_alt>
717 618
                                                                                                            </plantname>
718 619
                                                                                                            <parent_id>
......
723 624
                                                                                                                            <0>$dwc_dwcore_Kingdom</0>
724 625
                                                                                                                            <1>$dwc_terms_kingdom</1>
725 626
                                                                                                                            <2>$conceptual_darwin_2003_1_0_Kingdom</2>
726
                                                                                                                            <3>$dwc_dwcore_Kingdom</3>
727
                                                                                                                            <4>$dwc_terms_kingdom</4>
728
                                                                                                                            <5>$conceptual_darwin_2003_1_0_Kingdom</5>
729 627
                                                                                                                        </_alt>
730 628
                                                                                                                    </plantname>
731 629
                                                                                                                </plantname>
......
815 713
                                            <0>$conceptual_darwin_2003_1_0_MaximumDepth</0>
816 714
                                            <1>$dwc_dwcore_MaximumDepthInMeters</1>
817 715
                                            <2>$dwc_terms_maximumDepthInMeters</2>
818
                                            <3>$dwc_dwcore_MaximumDepthInMeters</3>
819
                                            <4>$dwc_terms_maximumDepthInMeters</4>
820 716
                                        </_alt>
821 717
                                    </value>
822 718
                                </_replace>
......
836 732
                                            <0>$conceptual_darwin_2003_1_0_MinimumDepth</0>
837 733
                                            <1>$dwc_dwcore_MinimumDepthInMeters</1>
838 734
                                            <2>$dwc_terms_minimumDepthInMeters</2>
839
                                            <3>$dwc_dwcore_MinimumDepthInMeters</3>
840
                                            <4>$dwc_terms_minimumDepthInMeters</4>
841 735
                                        </_alt>
842 736
                                    </value>
843 737
                                </_replace>
......
852 746
                <0>$dwc_dwcore_Locality</0>
853 747
                <1>$dwc_terms_locality</1>
854 748
                <2>$conceptual_darwin_2003_1_0_Locality</2>
855
                <3>$dwc_dwcore_Locality</3>
856
                <4>$dwc_terms_locality</4>
857
                <5>$conceptual_darwin_2003_1_0_Locality</5>
858 749
            </_alt>
859 750
        </locationnarrative>
860 751
    </location>

Also available in: Unified diff