Project

General

Profile

« Previous | Next » 

Revision 4726

Added by Aaron Marcuse-Kubitza about 12 years ago

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
10 10 
                        <2>$acronym</2>
11 11 
                    </_alt>
12 12 
                </authorlocationcode>
13 
                <locationdetermination>
13 
                <locationcoords>
14 14 
                    <latitude>
15 15 
                        <_nullIf>
16 16 
                            <null>0</null>
......
25 25 
                            <value>$long_deg</value>
26 26 
                        </_nullIf>
27 27 
                    </longitude>
28 
                    <namedplace_id>
29 
                        <namedplace>
30 
                            <rank>county</rank>
31 
                            <placename>$county</placename>
32 
                            <parent_id>
33 
                                <namedplace>
34 
                                    <rank>stateProvince</rank>
35 
                                    <placename>$state</placename>
36 
                                    <parent_id>
37 
                                        <namedplace>
38 
                                            <rank>country</rank>
39 
                                            <placename>$country</placename>
40 
                                        </namedplace>
41 
                                    </parent_id>
42 
                                </namedplace>
43 
                            </parent_id>
44 
                        </namedplace>
45 
                    </namedplace_id>
46 
                </locationdetermination>
28 
                </locationcoords>
47 29 
                <locationevent>
48 30 
                    <taxonoccurrence>
49 31 
                        <aggregateoccurrence>
......
102 84 
                        </3>
103 85 
                    </_merge>
104 86 
                </locationnarrative>
87 
                <locationplace>
88 
                    <namedplace_id>
89 
                        <namedplace>
90 
                            <rank>county</rank>
91 
                            <placename>$county</placename>
92 
                            <parent_id>
93 
                                <namedplace>
94 
                                    <rank>stateProvince</rank>
95 
                                    <placename>$state</placename>
96 
                                    <parent_id>
97 
                                        <namedplace>
98 
                                            <rank>country</rank>
99 
                                            <placename>$country</placename>
100 
                                        </namedplace>
101 
                                    </parent_id>
102 
                                </namedplace>
103 
                            </parent_id>
104 
                        </namedplace>
105 
                    </namedplace_id>
106 
                </locationplace>
105 107 
            </location>
106 108 
        </path>
107 109 
    </_simplifyPath>
108 110 
</VegBIEN>
109 
Inserted 23 new rows into database
111 
Inserted 25 new rows into database

Also available in: Unified diff