Project

General

Profile

« Previous | Next » 

Revision 4726

schemas/vegbien.sql: Split locationdetermination into locationcoords and locationplace, so that coordinate determinations can be made separately from place determinations

View differences:

test.xml.ref
99 99
                        </to>
100 100
                    </_range>
101 101
                </elevationrange>
102
                <locationdetermination>
102
                <locationcoords>
103 103
                    <latitude>
104 104
                        <_nullIf>
105 105
                            <null>0</null>
......
114 114
                            <value>$LongDec</value>
115 115
                        </_nullIf>
116 116
                    </longitude>
117
                    <namedplace_id>
118
                        <namedplace>
119
                            <rank>county</rank>
120
                            <placename>$pol2</placename>
121
                            <parent_id>
122
                                <namedplace>
123
                                    <rank>stateProvince</rank>
124
                                    <placename>$PolDiv1</placename>
125
                                    <parent_id>
126
                                        <namedplace>
127
                                            <rank>country</rank>
128
                                            <placename>$Country</placename>
129
                                            <parent_id>
130
                                                <namedplace>
131
                                                    <rank>continent</rank>
132
                                                    <placename>$MajorGeo</placename>
133
                                                </namedplace>
134
                                            </parent_id>
135
                                        </namedplace>
136
                                    </parent_id>
137
                                </namedplace>
138
                            </parent_id>
139
                        </namedplace>
140
                    </namedplace_id>
141
                </locationdetermination>
117
                </locationcoords>
142 118
                <locationevent>
143 119
                    <method_id><method><name>$PlotMethod</name></method></method_id>
144 120
                    <project_id><project><sourceaccessioncode>$project_id</sourceaccessioncode></project></project_id>
......
283 259
                        </3>
284 260
                    </_merge>
285 261
                </locationnarrative>
262
                <locationplace>
263
                    <namedplace_id>
264
                        <namedplace>
265
                            <rank>county</rank>
266
                            <placename>$pol2</placename>
267
                            <parent_id>
268
                                <namedplace>
269
                                    <rank>stateProvince</rank>
270
                                    <placename>$PolDiv1</placename>
271
                                    <parent_id>
272
                                        <namedplace>
273
                                            <rank>country</rank>
274
                                            <placename>$Country</placename>
275
                                            <parent_id>
276
                                                <namedplace>
277
                                                    <rank>continent</rank>
278
                                                    <placename>$MajorGeo</placename>
279
                                                </namedplace>
280
                                            </parent_id>
281
                                        </namedplace>
282
                                    </parent_id>
283
                                </namedplace>
284
                            </parent_id>
285
                        </namedplace>
286
                    </namedplace_id>
287
                </locationplace>
286 288
                <notespublic>$plot_notes</notespublic>
287 289
                <slopeaspect><_compass><value>$slope_aspect</value></_compass></slopeaspect>
288 290
                <slopegradient>$slope_gradient</slopegradient>
......
290 292
        </path>
291 293
    </_simplifyPath>
292 294
</VegBIEN>
293
Inserted 23 new rows into database
295
Inserted 25 new rows into database

Also available in: Unified diff