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
113 113
                        </to>
114 114
                    </_range>
115 115
                </elevationrange>
116
                <locationdetermination>
116
                <locationcoords>
117 117
                    <coordsaccuracy><_noCV><value>$CoordinateUncertaintyInMeters</value></_noCV></coordsaccuracy>
118 118
                    <footprintgeometry_dwc>$BoundingBox</footprintgeometry_dwc>
119 119
                    <latitude>
......
152 152
                            </2>
153 153
                        </_alt>
154 154
                    </longitude>
155
                    <namedplace_id>
156
                        <namedplace>
157
                            <rank>county</rank>
158
                            <placename>$County</placename>
159
                            <parent_id>
160
                                <namedplace>
161
                                    <rank>stateProvince</rank>
162
                                    <placename>$StateProvince</placename>
163
                                    <parent_id>
164
                                        <namedplace>
165
                                            <rank>country</rank>
166
                                            <placename>$Country</placename>
167
                                            <parent_id>
168
                                                <namedplace>
169
                                                    <rank>continent</rank>
170
                                                    <placename>$ContinentOcean</placename>
171
                                                </namedplace>
172
                                            </parent_id>
173
                                        </namedplace>
174
                                    </parent_id>
175
                                </namedplace>
176
                            </parent_id>
177
                        </namedplace>
178
                    </namedplace_id>
179
                </locationdetermination>
155
                </locationcoords>
180 156
                <locationevent>
181 157
                    <taxonoccurrence>
182 158
                        <aggregateoccurrence>
......
335 311
                    </waterdepth>
336 312
                </locationevent>
337 313
                <locationnarrative>$Locality</locationnarrative>
314
                <locationplace>
315
                    <namedplace_id>
316
                        <namedplace>
317
                            <rank>county</rank>
318
                            <placename>$County</placename>
319
                            <parent_id>
320
                                <namedplace>
321
                                    <rank>stateProvince</rank>
322
                                    <placename>$StateProvince</placename>
323
                                    <parent_id>
324
                                        <namedplace>
325
                                            <rank>country</rank>
326
                                            <placename>$Country</placename>
327
                                            <parent_id>
328
                                                <namedplace>
329
                                                    <rank>continent</rank>
330
                                                    <placename>$ContinentOcean</placename>
331
                                                </namedplace>
332
                                            </parent_id>
333
                                        </namedplace>
334
                                    </parent_id>
335
                                </namedplace>
336
                            </parent_id>
337
                        </namedplace>
338
                    </namedplace_id>
339
                </locationplace>
338 340
            </location>
339 341
        </path>
340 342
    </_simplifyPath>
341 343
</VegBIEN>
342
Inserted 27 new rows into database
344
Inserted 29 new rows into database

Also available in: Unified diff