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>$Barcode</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</value>
26 26 
                        </_nullIf>
27 27 
                    </longitude>
28 
                    <namedplace_id>
29 
                        <namedplace>
30 
                            <rank>county</rank>
31 
                            <parent_id>
32 
                                <namedplace>
33 
                                    <rank>stateProvince</rank>
34 
                                    <parent_id>
35 
                                        <namedplace>
36 
                                            <rank>country</rank>
37 
                                            <placename>$Country</placename>
38 
                                        </namedplace>
39 
                                    </parent_id>
40 
                                </namedplace>
41 
                            </parent_id>
42 
                        </namedplace>
43 
                    </namedplace_id>
44 
                </locationdetermination>
28 
                </locationcoords>
45 29 
                <locationevent>
46 30 
                    <taxonoccurrence>
47 31 
                        <aggregateoccurrence>
......
141 125 
                        </3>
142 126 
                    </_merge>
143 127 
                </locationnarrative>
128 
                <locationplace>
129 
                    <namedplace_id>
130 
                        <namedplace>
131 
                            <rank>county</rank>
132 
                            <parent_id>
133 
                                <namedplace>
134 
                                    <rank>stateProvince</rank>
135 
                                    <parent_id>
136 
                                        <namedplace>
137 
                                            <rank>country</rank>
138 
                                            <placename>$Country</placename>
139 
                                        </namedplace>
140 
                                    </parent_id>
141 
                                </namedplace>
142 
                            </parent_id>
143 
                        </namedplace>
144 
                    </namedplace_id>
145 
                </locationplace>
144 146 
            </location>
145 147 
        </path>
146 148 
    </_simplifyPath>
147 149 
</VegBIEN>
148 
Inserted 22 new rows into database
150 
Inserted 24 new rows into database

Also available in: Unified diff