Project

General

Profile

Download (9.98 KB) Statistics
| Revision:

root/inputs/NCU/Specimen/test.xml.ref @ 10565

1 3641 aaronmk 
Put template:
2 
<VegBIEN>
3 6403 aaronmk 
    <_setDefault id="-1">
4 6736 aaronmk 
        <source_id><source><shortname>NCU</shortname></source></source_id>
5 4621 aaronmk 
        <path>
6 6403 aaronmk 
            <_simplifyPath>
7 
                <next>parent_id</next>
8 
                <path>
9 
                    <location>
10 
                        <authorlocationcode>
11 
                            <_alt>
12 6737 aaronmk 
                                <1>$SpecimenPK</1>
13 6403 aaronmk 
                                <2>
14 
                                    <_join>
15 6737 aaronmk 
                                        <1>
16 
                                            <_alt>
17 
                                                <1>$CatalogSeriesPrefix</1>
18 
                                                <2>$OwnerInstitution</2>
19 
                                            </_alt>
20 
                                        </1>
21 
                                        <2>$CollectionGUID</2>
22 
                                        <3>$CatalogNumber</3>
23 6403 aaronmk 
                                    </_join>
24 
                                </2>
25 
                            </_alt>
26 
                        </authorlocationcode>
27 10564 aaronmk 
                        <iscultivated><_locationnarrative_is_cultivated><locationnarrative>$VerbatimLocality</locationnarrative></_locationnarrative_is_cultivated></iscultivated>
28 6403 aaronmk 
                        <locationevent>
29 
                            <taxonoccurrence>
30 
                                <aggregateoccurrence>
31 6737 aaronmk 
                                    <collectiondate>$CollectionDate</collectiondate>
32 
                                    <notes>$Description</notes>
33 6403 aaronmk 
                                    <plantobservation>
34 7190 aaronmk 
                                        <authorplantcode>$firstCollectorRemarks</authorplantcode>
35 6403 aaronmk 
                                        <specimenreplicate>
36 6737 aaronmk 
                                            <catalognumber_dwc>$CatalogNumber</catalognumber_dwc>
37 
                                            <collectioncode_dwc>$CollectionGUID</collectioncode_dwc>
38 7198 aaronmk 
                                            <collectionnumber>$firstCollectorRemarks</collectionnumber>
39 6737 aaronmk 
                                            <institution_id>
40 6791 aaronmk 
                                                <sourcelist>
41 6737 aaronmk 
                                                    <name>
42 
                                                        <_alt>
43 
                                                            <1>$CatalogSeriesPrefix</1>
44 
                                                            <2>$OwnerInstitution</2>
45 
                                                        </_alt>
46 
                                                    </name>
47 6791 aaronmk 
                                                    <sourcename>
48 6795 aaronmk 
                                                        <name>
49 
                                                            <_split>
50 7433 aaronmk 
                                                                <separator>[,;] *</separator>
51 6795 aaronmk 
                                                                <value>
52 6791 aaronmk 
                                                                    <_alt>
53 
                                                                        <1>$CatalogSeriesPrefix</1>
54 
                                                                        <2>$OwnerInstitution</2>
55 
                                                                    </_alt>
56 6795 aaronmk 
                                                                </value>
57 
                                                            </_split>
58 6791 aaronmk 
                                                        </name>
59 
                                                    </sourcename>
60 
                                                </sourcelist>
61 6737 aaronmk 
                                            </institution_id>
62 
                                            <sourceaccessioncode>$SpecimenPK</sourceaccessioncode>
63 6403 aaronmk 
                                        </specimenreplicate>
64 
                                    </plantobservation>
65 
                                </aggregateoccurrence>
66 6737 aaronmk 
                                <collector_id><party><fullname>$firstCollectorName</fullname></party></collector_id>
67 10563 aaronmk 
                                <iscultivated>$cultivated</iscultivated>
68 6737 aaronmk 
                                <sourceaccessioncode>$SpecimenPK</sourceaccessioncode>
69 6403 aaronmk 
                                <taxondetermination>
70 
                                    <taxonverbatim_id>
71 
                                        <taxonverbatim>
72 
                                            <taxonlabel_id>
73 5657 aaronmk 
                                                <taxonlabel>
74 6737 aaronmk 
                                                    <taxonomicname>
75 
                                                        <_alt>
76 
                                                            <1>$CurrentScientificNameWithAuthor</1>
77 
                                                            <2>$CurrentScientificName</2>
78 
                                                        </_alt>
79 
                                                    </taxonomicname>
80 5657 aaronmk 
                                                </taxonlabel>
81 6403 aaronmk 
                                            </taxonlabel_id>
82 6737 aaronmk 
                                            <taxonname>$CurrentScientificName</taxonname>
83 
                                            <taxonomicname>$CurrentScientificNameWithAuthor</taxonomicname>
84 6403 aaronmk 
                                        </taxonverbatim>
85 
                                    </taxonverbatim_id>
86 
                                </taxondetermination>
87 6737 aaronmk 
                                <taxondetermination>
88 
                                    <isoriginal>true</isoriginal>
89 7169 aaronmk 
                                    <taxonverbatim_id><taxonverbatim><taxonomicname>$OriginalTaxonLabel</taxonomicname></taxonverbatim></taxonverbatim_id>
90 6737 aaronmk 
                                </taxondetermination>
91 6403 aaronmk 
                            </taxonoccurrence>
92 
                        </locationevent>
93 10564 aaronmk 
                        <locationnarrative>$VerbatimLocality</locationnarrative>
94 6403 aaronmk 
                        <locationplace>
95 
                            <place_id>
96 5958 aaronmk 
                                <place>
97 
                                    <coordinates_id>
98 
                                        <coordinates>
99 
                                            <latitude_deg>
100 5969 aaronmk 
                                                <_nullIf>
101 
                                                    <null>0</null>
102 
                                                    <type>float</type>
103 6737 aaronmk 
                                                    <value>$Latitude1</value>
104 5969 aaronmk 
                                                </_nullIf>
105 5958 aaronmk 
                                            </latitude_deg>
106 
                                            <longitude_deg>
107 5969 aaronmk 
                                                <_nullIf>
108 
                                                    <null>0</null>
109 
                                                    <type>float</type>
110 6737 aaronmk 
                                                    <value>$Longitude1</value>
111 5969 aaronmk 
                                                </_nullIf>
112 5958 aaronmk 
                                            </longitude_deg>
113 6737 aaronmk 
                                            <verbatimlatitude>$Loc_AltN</verbatimlatitude>
114 
                                            <verbatimlongitude>$Loc_AltE</verbatimlongitude>
115 5958 aaronmk 
                                        </coordinates>
116 
                                    </coordinates_id>
117 10565 aaronmk 
                                    <placename_id>
118 
                                        <placename>
119 
                                            <rank>municipality</rank>
120 
                                            <placename>$CityLocality</placename>
121 
                                        </placename>
122 
                                    </placename_id>
123 5958 aaronmk 
                                    <country>$Country</country>
124 6737 aaronmk 
                                    <county>$county</county>
125 6403 aaronmk 
                                    <matched_place_id>
126 
                                        <place>
127 
                                            <source_id><source><shortname>geoscrub</shortname></source></source_id>
128 
                                            <coordinates_id>
129 
                                                <coordinates>
130 
                                                    <source_id><source><shortname>geoscrub</shortname></source></source_id>
131 
                                                    <latitude_deg>
132 
                                                        <_nullIf>
133 
                                                            <null>0</null>
134 
                                                            <type>float</type>
135 6737 aaronmk 
                                                            <value>$Latitude1</value>
136 6403 aaronmk 
                                                        </_nullIf>
137 
                                                    </latitude_deg>
138 
                                                    <longitude_deg>
139 
                                                        <_nullIf>
140 
                                                            <null>0</null>
141 
                                                            <type>float</type>
142 6737 aaronmk 
                                                            <value>$Longitude1</value>
143 6403 aaronmk 
                                                        </_nullIf>
144 
                                                    </longitude_deg>
145 
                                                </coordinates>
146 
                                            </coordinates_id>
147 
                                            <country>$Country</country>
148 6737 aaronmk 
                                            <county>$county</county>
149 6403 aaronmk 
                                            <stateprovince>$State</stateprovince>
150 
                                        </place>
151 
                                    </matched_place_id>
152 5958 aaronmk 
                                    <stateprovince>$State</stateprovince>
153 
                                </place>
154 6403 aaronmk 
                            </place_id>
155 
                        </locationplace>
156 
                    </location>
157 
                </path>
158 
            </_simplifyPath>
159 4621 aaronmk 
        </path>
160 6403 aaronmk 
    </_setDefault>
161 3641 aaronmk 
</VegBIEN>
162 10565 aaronmk 
Inserted 34 new rows into database