Project

General

Profile

Download (5.5 KB) Statistics
| Revision:

root/inputs/GBIF/Specimen/test.xml.ref @ 4843

1 3641 aaronmk 
Put template:
2 
<VegBIEN>
3 4621 aaronmk 
    <_simplifyPath id="-1">
4 
        <next>parent_id</next>
5 
        <path>
6 
            <location>
7 
                <authorlocationcode>
8 
                    <_join>
9 
                        <1>$InstitutionCD</1>
10 
                        <2>$CollectionCD</2>
11 
                        <3>$CatalogNO</3>
12 
                    </_join>
13 
                </authorlocationcode>
14 4753 aaronmk 
                <elevation_m>
15 4621 aaronmk 
                    <_avg>
16 4820 aaronmk 
                        <max>$MaximumElevationInMeter</max>
17 4822 aaronmk 
                        <min>$MinimumElevationInMeter</min>
18 4621 aaronmk 
                    </_avg>
19 4753 aaronmk 
                </elevation_m>
20 4726 aaronmk 
                <locationcoords>
21 4753 aaronmk 
                    <latitude_deg>
22 4621 aaronmk 
                        <_alt>
23 
                            <1>
24 
                                <_nullIf>
25 
                                    <null>0</null>
26 
                                    <type>float</type>
27 
                                    <value>$DecimalLatitude</value>
28 
                                </_nullIf>
29 
                            </1>
30 
                            <2>
31 
                                <_nullIf>
32 
                                    <null>0</null>
33 
                                    <type>float</type>
34 
                                    <value>$VerbatimLatitude</value>
35 
                                </_nullIf>
36 
                            </2>
37 
                        </_alt>
38 4753 aaronmk 
                    </latitude_deg>
39 
                    <longitude_deg>
40 4621 aaronmk 
                        <_alt>
41 
                            <1>
42 
                                <_nullIf>
43 
                                    <null>0</null>
44 
                                    <type>float</type>
45 
                                    <value>$DecimalLongitude</value>
46 
                                </_nullIf>
47 
                            </1>
48 
                            <2>
49 
                                <_nullIf>
50 
                                    <null>0</null>
51 
                                    <type>float</type>
52 
                                    <value>$VerbatimLongitude</value>
53 
                                </_nullIf>
54 
                            </2>
55 
                        </_alt>
56 4753 aaronmk 
                    </longitude_deg>
57 4726 aaronmk 
                </locationcoords>
58 4621 aaronmk 
                <locationevent>
59 
                    <taxonoccurrence>
60 
                        <aggregateoccurrence>
61 
                            <collectiondate><_date><date>$LatestDateCollected</date></_date></collectiondate>
62 
                            <plantobservation>
63 
                                <specimenreplicate>
64 
                                    <catalognumber_dwc>$CatalogNO</catalognumber_dwc>
65 
                                    <collectioncode_dwc>$CollectionCD</collectioncode_dwc>
66 
                                    <institution_id><party><organizationname>$InstitutionCD</organizationname></party></institution_id>
67 
                                </specimenreplicate>
68 
                            </plantobservation>
69 
                        </aggregateoccurrence>
70 4833 aaronmk 
                        <authortaxoncode>$ScientificNameOriginal</authortaxoncode>
71 4621 aaronmk 
                        <taxondetermination>
72 
                            <party_id>
73 
                                <party>
74 
                                    <givenname><_namePart><first>$IdentifiedBy</first></_namePart></givenname>
75 
                                    <middlename><_namePart><middle>$IdentifiedBy</middle></_namePart></middlename>
76 
                                    <surname><_namePart><last>$IdentifiedBy</last></_namePart></surname>
77 
                                </party>
78 
                            </party_id>
79 4718 aaronmk 
                            <taxonpath_id>
80 
                                <taxonpath>
81 4703 aaronmk 
                                    <family>$Family</family>
82 
                                    <genus>$Genus</genus>
83 
                                    <scientificname>$ScientificName</scientificname>
84 
                                    <scientificnameauthor>$AuthorOfScientificName</scientificnameauthor>
85 
                                    <species>$SpecificEpithet</species>
86 
                                    <subspecies>$InfraspecificEpithet</subspecies>
87 4718 aaronmk 
                                </taxonpath>
88 
                            </taxonpath_id>
89 4621 aaronmk 
                        </taxondetermination>
90 
                        <taxondetermination>
91 
                            <isoriginal>true</isoriginal>
92 4718 aaronmk 
                            <taxonpath_id>
93 
                                <taxonpath>
94 4703 aaronmk 
                                    <family>$GBIFFamilyOriginal</family>
95 
                                    <genus>$GBIFGenusOriginal</genus>
96 
                                    <scientificname>$ScientificNameOriginal</scientificname>
97 4718 aaronmk 
                                </taxonpath>
98 
                            </taxonpath_id>
99 4621 aaronmk 
                        </taxondetermination>
100 
                        <verbatimcollectorname>$Collector</verbatimcollectorname>
101 
                    </taxonoccurrence>
102 
                </locationevent>
103 
                <locationnarrative>$Locality</locationnarrative>
104 4726 aaronmk 
                <locationplace>
105 4727 aaronmk 
                    <placepath_id>
106 
                        <placepath>
107 
                            <country>$Country</country>
108 
                            <county>$County</county>
109 
                            <stateprovince>$StateProvince</stateprovince>
110 
                        </placepath>
111 
                    </placepath_id>
112 4726 aaronmk 
                </locationplace>
113 4621 aaronmk 
            </location>
114 
        </path>
115 
    </_simplifyPath>
116 3641 aaronmk 
</VegBIEN>
117 4726 aaronmk 
Inserted 29 new rows into database