Project

General

Profile

Download (10 KB) Statistics
| Revision:

root/inputs/NY/Specimen/test.xml.ref @ 4965

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 
                    <_alt>
9 
                        <1>$UniqueNYInternalRecordNumber</1>
10 
                        <2>
11 
                            <_join>
12 
                                <1>$InstitutionCode</1>
13 
                                <2>$CollectionCode</2>
14 
                                <3>$CatalogNumber</3>
15 
                            </_join>
16 
                        </2>
17 
                    </_alt>
18 
                </authorlocationcode>
19 4753 aaronmk 
                <elevation_m>
20 4621 aaronmk 
                    <_avg>
21 4820 aaronmk 
                        <max>$MaximumElevation</max>
22 4621 aaronmk 
                        <min>
23 4822 aaronmk 
                            <_nullIf>
24 
                                <null>.</null>
25 
                                <value>$MinimumElevation</value>
26 
                            </_nullIf>
27 4621 aaronmk 
                        </min>
28 
                    </_avg>
29 4753 aaronmk 
                </elevation_m>
30 4726 aaronmk 
                <locationcoords>
31 4753 aaronmk 
                    <coordsaccuracy_deg><_noCV><value>$CoordinatePrecision</value></_noCV></coordsaccuracy_deg>
32 4621 aaronmk 
                    <footprintgeometry_dwc>$BoundingBox</footprintgeometry_dwc>
33 4753 aaronmk 
                    <latitude_deg>
34 4621 aaronmk 
                        <_nullIf>
35 
                            <null>0</null>
36 
                            <type>float</type>
37 
                            <value>$Latitude</value>
38 
                        </_nullIf>
39 4753 aaronmk 
                    </latitude_deg>
40 
                    <longitude_deg>
41 4621 aaronmk 
                        <_nullIf>
42 
                            <null>0</null>
43 
                            <type>float</type>
44 
                            <value>$Longitude</value>
45 
                        </_nullIf>
46 4753 aaronmk 
                    </longitude_deg>
47 4726 aaronmk 
                </locationcoords>
48 4621 aaronmk 
                <locationevent>
49 
                    <taxonoccurrence>
50 
                        <aggregateoccurrence>
51 
                            <collectiondate>
52 
                                <_date>
53 
                                    <day>
54 
                                        <_nullIf>
55 
                                            <null>0</null>
56 
                                            <type>float</type>
57 
                                            <value>$DayCollected</value>
58 
                                        </_nullIf>
59 
                                    </day>
60 
                                    <month>
61 
                                        <_nullIf>
62 
                                            <null>0</null>
63 
                                            <type>float</type>
64 
                                            <value>$MonthCollected</value>
65 
                                        </_nullIf>
66 
                                    </month>
67 
                                    <year>
68 
                                        <_nullIf>
69 
                                            <null>0</null>
70 
                                            <type>float</type>
71 
                                            <value>$YearCollected</value>
72 
                                        </_nullIf>
73 
                                    </year>
74 
                                </_date>
75 
                            </collectiondate>
76 
                            <count>$IndividualCount</count>
77 
                            <notes>
78 4684 aaronmk 
                                <_join>
79 4621 aaronmk 
                                    <1>$Notes</1>
80 
                                    <2>
81 
                                        <_label>
82 
                                            <label>plant fungus</label>
83 
                                            <value>$PlantFungusDescription</value>
84 
                                        </_label>
85 
                                    </2>
86 4684 aaronmk 
                                </_join>
87 4621 aaronmk 
                            </notes>
88 
                            <plantobservation>
89 
                                <collectionnumber>$FieldNumber</collectionnumber>
90 
                                <definedvalue fkey="tablerecord_id">
91 
                                    <userdefined_id>
92 
                                        <userdefined>
93 
                                            <tablename>plantobservation</tablename>
94 
                                            <userdefinedname>sex</userdefinedname>
95 
                                        </userdefined>
96 
                                    </userdefined_id>
97 
                                    <definedvalue>$Sex</definedvalue>
98 
                                </definedvalue>
99 
                                <specimenreplicate>
100 
                                    <catalognumber_dwc>$CatalogNumber</catalognumber_dwc>
101 
                                    <collectioncode_dwc>$CollectionCode</collectioncode_dwc>
102 
                                    <institution_id><party><organizationname>$InstitutionCode</organizationname></party></institution_id>
103 
                                    <sourceaccessioncode>$UniqueNYInternalRecordNumber</sourceaccessioncode>
104 
                                </specimenreplicate>
105 
                            </plantobservation>
106 
                        </aggregateoccurrence>
107 4833 aaronmk 
                        <authortaxoncode>$FieldNumber</authortaxoncode>
108 4834 aaronmk 
                        <sourceaccessioncode>$UniqueNYInternalRecordNumber</sourceaccessioncode>
109 4621 aaronmk 
                        <taxondetermination>
110 
                            <party_id>
111 
                                <party>
112 
                                    <givenname><_namePart><first>$IdentifiedBy</first></_namePart></givenname>
113 
                                    <middlename><_namePart><middle>$IdentifiedBy</middle></_namePart></middlename>
114 
                                    <surname><_namePart><last>$IdentifiedBy</last></_namePart></surname>
115 
                                </party>
116 
                            </party_id>
117 4718 aaronmk 
                            <taxonpath_id>
118 
                                <taxonpath>
119 4944 aaronmk 
                                    <author>$ScientificNameAuthor</author>
120 4703 aaronmk 
                                    <class>$Class</class>
121 
                                    <family>$Family</family>
122 
                                    <genus>$Genus</genus>
123 
                                    <kingdom>$Kingdom</kingdom>
124 
                                    <order>$Order</order>
125 
                                    <phylum>$Phylum</phylum>
126 
                                    <species>$Species</species>
127 
                                    <subspecies>$Subspecies</subspecies>
128 4965 aaronmk 
                                    <taxonomicname>$ScientificName</taxonomicname>
129 4718 aaronmk 
                                </taxonpath>
130 
                            </taxonpath_id>
131 4621 aaronmk 
                            <determinationdate>
132 
                                <_date>
133 
                                    <day>
134 
                                        <_nullIf>
135 
                                            <null>0</null>
136 
                                            <type>float</type>
137 
                                            <value>$DayIdentified</value>
138 
                                        </_nullIf>
139 
                                    </day>
140 
                                    <month>
141 
                                        <_nullIf>
142 
                                            <null>0</null>
143 
                                            <type>float</type>
144 
                                            <value>$MonthIdentified</value>
145 
                                        </_nullIf>
146 
                                    </month>
147 
                                    <year>
148 
                                        <_nullIf>
149 
                                            <null>0</null>
150 
                                            <type>float</type>
151 
                                            <value>$YearIdentified</value>
152 
                                        </_nullIf>
153 
                                    </year>
154 
                                </_date>
155 
                            </determinationdate>
156 
                        </taxondetermination>
157 
                        <verbatimcollectorname>$Collector</verbatimcollectorname>
158 
                    </taxonoccurrence>
159 4753 aaronmk 
                    <waterdepth_m>
160 4621 aaronmk 
                        <_avg>
161 4820 aaronmk 
                            <max>$MaximumDepth</max>
162 
                            <min>$MinimumDepth</min>
163 4621 aaronmk 
                        </_avg>
164 4753 aaronmk 
                    </waterdepth_m>
165 4621 aaronmk 
                </locationevent>
166 
                <locationnarrative>
167 3786 aaronmk 
                    <_merge>
168 4621 aaronmk 
                        <1>
169 4684 aaronmk 
                            <_join>
170 4621 aaronmk 
                                <1>$Locality</1>
171 
                                <2>
172 
                                    <_label>
173 
                                        <label>substrate</label>
174 
                                        <value>$Substrate</value>
175 
                                    </_label>
176 
                                </2>
177 
                                <3>
178 
                                    <_label>
179 
                                        <label>vegetation</label>
180 
                                        <value>$Vegetation</value>
181 
                                    </_label>
182 
                                </3>
183 4684 aaronmk 
                            </_join>
184 4621 aaronmk 
                        </1>
185 3786 aaronmk 
                        <3>
186 
                            <_label>
187 4621 aaronmk 
                                <label>habitat</label>
188 
                                <value>$Habitat</value>
189 3786 aaronmk 
                            </_label>
190 
                        </3>
191 
                    </_merge>
192 4621 aaronmk 
                </locationnarrative>
193 4726 aaronmk 
                <locationplace>
194 4727 aaronmk 
                    <placepath_id>
195 
                        <placepath>
196 
                            <continent>$ContinentOcean</continent>
197 
                            <country>$Country</country>
198 
                            <county>$County</county>
199 
                            <stateprovince>$StateProvince</stateprovince>
200 
                        </placepath>
201 
                    </placepath_id>
202 4726 aaronmk 
                </locationplace>
203 4621 aaronmk 
            </location>
204 
        </path>
205 
    </_simplifyPath>
206 3641 aaronmk 
</VegBIEN>
207 4947 aaronmk 
Inserted 26 new rows into database