Project

General

Profile

Download (5.42 KB) Statistics
| Revision:

root/inputs/NCU-NCSC/specimens/test.xml.ref @ 4332

1 3641 aaronmk 
Put template:
2 
<VegBIEN>
3 3786 aaronmk 
    <location id="-1">
4 4003 aaronmk 
        <authorlocationcode>
5 4066 aaronmk 
            <_alt>
6 
                <3>$Accession Number</3>
7 
                <4>
8 4327 aaronmk 
                    <_join>
9 4066 aaronmk 
                        <2>$SeriesName</2>
10 4078 aaronmk 
                        <3>$Barcode</3>
11 4327 aaronmk 
                    </_join>
12 4066 aaronmk 
                </4>
13 
            </_alt>
14 4003 aaronmk 
        </authorlocationcode>
15 3996 aaronmk 
        <elevation>
16 4043 aaronmk 
            <_replace>
17 
                <\bca\.?></\bca\.?>
18 
                <value>$Elevation</value>
19 
            </_replace>
20 3996 aaronmk 
        </elevation>
21 3786 aaronmk 
        <locationdetermination>
22 4043 aaronmk 
            <coordsaccuracy><_noCV><value>$Accuracy</value></_noCV></coordsaccuracy>
23 3786 aaronmk 
            <latitude>
24 4043 aaronmk 
                <_nullIf>
25 
                    <null>0</null>
26 
                    <type>float</type>
27 
                    <value>
28 
                        <_replace>
29 
                            <\?$></\?$>
30 
                            <value>$Lat (-=S)</value>
31 
                        </_replace>
32 
                    </value>
33 
                </_nullIf>
34 3786 aaronmk 
            </latitude>
35 
            <longitude>
36 4043 aaronmk 
                <_nullIf>
37 
                    <null>0</null>
38 
                    <type>float</type>
39 
                    <value>
40 
                        <_replace>
41 
                            <\?$></\?$>
42 
                            <value>$Long (-=W)</value>
43 
                        </_replace>
44 
                    </value>
45 
                </_nullIf>
46 3786 aaronmk 
            </longitude>
47 
            <namedplace_id>
48 
                <_simplifyPath>
49 
                    <next>parent_id/namedplace</next>
50 
                    <require>placename</require>
51 
                    <path>
52 
                        <namedplace>
53 
                            <rank>county</rank>
54 
                            <placename>$County</placename>
55 
                            <parent_id>
56 
                                <namedplace>
57 
                                    <rank>stateProvince</rank>
58 
                                    <placename>$State</placename>
59 
                                    <parent_id>
60 3770 aaronmk 
                                        <namedplace>
61 3786 aaronmk 
                                            <rank>country</rank>
62 
                                            <placename>$Country</placename>
63 3770 aaronmk 
                                        </namedplace>
64 3786 aaronmk 
                                    </parent_id>
65 
                                </namedplace>
66 
                            </parent_id>
67 
                        </namedplace>
68 
                    </path>
69 
                </_simplifyPath>
70 
            </namedplace_id>
71 
        </locationdetermination>
72 
        <locationevent>
73 4043 aaronmk 
            <obsenddate><_date><date><_dateRangeEnd><value>$Collect Date</value></_dateRangeEnd></date></_date></obsenddate>
74 
            <obsstartdate><_date><date><_dateRangeStart><value>$Collect Date</value></_dateRangeStart></date></_date></obsstartdate>
75 3907 aaronmk 
            <taxonoccurrence>
76 
                <aggregateoccurrence>
77 4043 aaronmk 
                    <collectiondate><_date><date>$Collect Date</date></_date></collectiondate>
78 3907 aaronmk 
                    <plantobservation>
79 
                        <specimenreplicate>
80 4078 aaronmk 
                            <catalognumber_dwc>$Barcode</catalognumber_dwc>
81 4043 aaronmk 
                            <collectioncode_dwc>$SeriesName</collectioncode_dwc>
82 3907 aaronmk 
                            <sourceaccessioncode>$Accession Number</sourceaccessioncode>
83 
                        </specimenreplicate>
84 
                    </plantobservation>
85 
                </aggregateoccurrence>
86 4079 aaronmk 
                <authortaxoncode>$Full Taxon Name</authortaxoncode>
87 3934 aaronmk 
                <iscultivated>
88 
                    <_map>
89 
                        <cultivated>t</cultivated>
90 
                        <wild>f</wild>
91 
                        <*></*>
92 
                        <value>
93 
                            <_map>
94 
                                <Yes>cultivated</Yes>
95 
                                <No>wild</No>
96 
                                <value>$Cultivated?</value>
97 
                            </_map>
98 
                        </value>
99 
                    </_map>
100 
                </iscultivated>
101 
                <isnative>
102 
                    <_map>
103 
                        <native>t</native>
104 
                        <exotic>f</exotic>
105 
                        <*></*>
106 
                        <value>
107 
                            <_map>
108 
                                <Yes>cultivated</Yes>
109 
                                <No>wild</No>
110 
                                <value>$Cultivated?</value>
111 
                            </_map>
112 
                        </value>
113 
                    </_map>
114 
                </isnative>
115 3786 aaronmk 
                <taxondetermination>
116 
                    <plantconcept_id>
117 
                        <plantconcept>
118 
                            <plantname_id>
119 
                                <_simplifyPath>
120 4226 aaronmk 
                                    <next>parent_id</next>
121 3786 aaronmk 
                                    <path>
122 
                                        <plantname>
123 
                                            <rank>binomial</rank>
124 
                                            <plantname>$Full Taxon Name</plantname>
125 
                                        </plantname>
126 
                                    </path>
127 
                                </_simplifyPath>
128 
                            </plantname_id>
129 
                        </plantconcept>
130 
                    </plantconcept_id>
131 
                </taxondetermination>
132 3907 aaronmk 
            </taxonoccurrence>
133 3786 aaronmk 
        </locationevent>
134 
    </location>
135 3641 aaronmk 
</VegBIEN>
136 3907 aaronmk 
Inserted 26 new rows into database