Project

General

Profile

Download (5.68 KB) Statistics
| Revision:

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

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 
                        <authortaxoncode>
71 
                            <_alt>
72 
                                <1>$ScientificNameOriginal</1>
73 4707 aaronmk 
                                <3>$ScientificName</3>
74 4621 aaronmk 
                            </_alt>
75 
                        </authortaxoncode>
76 
                        <taxondetermination>
77 
                            <party_id>
78 
                                <party>
79 
                                    <givenname><_namePart><first>$IdentifiedBy</first></_namePart></givenname>
80 
                                    <middlename><_namePart><middle>$IdentifiedBy</middle></_namePart></middlename>
81 
                                    <surname><_namePart><last>$IdentifiedBy</last></_namePart></surname>
82 
                                </party>
83 
                            </party_id>
84 4718 aaronmk 
                            <taxonpath_id>
85 
                                <taxonpath>
86 4703 aaronmk 
                                    <family>$Family</family>
87 
                                    <genus>$Genus</genus>
88 
                                    <scientificname>$ScientificName</scientificname>
89 
                                    <scientificnameauthor>$AuthorOfScientificName</scientificnameauthor>
90 
                                    <species>$SpecificEpithet</species>
91 
                                    <subspecies>$InfraspecificEpithet</subspecies>
92 4718 aaronmk 
                                </taxonpath>
93 
                            </taxonpath_id>
94 4621 aaronmk 
                        </taxondetermination>
95 
                        <taxondetermination>
96 
                            <isoriginal>true</isoriginal>
97 4718 aaronmk 
                            <taxonpath_id>
98 
                                <taxonpath>
99 4703 aaronmk 
                                    <family>$GBIFFamilyOriginal</family>
100 
                                    <genus>$GBIFGenusOriginal</genus>
101 
                                    <scientificname>$ScientificNameOriginal</scientificname>
102 4718 aaronmk 
                                </taxonpath>
103 
                            </taxonpath_id>
104 4621 aaronmk 
                        </taxondetermination>
105 
                        <verbatimcollectorname>$Collector</verbatimcollectorname>
106 
                    </taxonoccurrence>
107 
                </locationevent>
108 
                <locationnarrative>$Locality</locationnarrative>
109 4726 aaronmk 
                <locationplace>
110 4727 aaronmk 
                    <placepath_id>
111 
                        <placepath>
112 
                            <country>$Country</country>
113 
                            <county>$County</county>
114 
                            <stateprovince>$StateProvince</stateprovince>
115 
                        </placepath>
116 
                    </placepath_id>
117 4726 aaronmk 
                </locationplace>
118 4621 aaronmk 
            </location>
119 
        </path>
120 
    </_simplifyPath>
121 3641 aaronmk 
</VegBIEN>
122 4726 aaronmk 
Inserted 29 new rows into database