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
13 13 
                        <value>$Elevation</value>
14 14 
                    </_replace>
15 15 
                </elevation>
16 
                <locationdetermination>
16 
                <locationcoords>
17 17 
                    <footprintgeometry_dwc>$ShapeOfSite</footprintgeometry_dwc>
18 18 
                    <latitude>
19 19 
                        <_nullIf>
......
29 29 
                            <value>$Longitude</value>
30 30 
                        </_nullIf>
31 31 
                    </longitude>
32 
                </locationcoords>
33 
                <locationnarrative>
34 
                    <_alt>
35 
                        <0>$DescriptionOfSite</0>
36 
                        <1>$LocationName</1>
37 
                    </_alt>
38 
                </locationnarrative>
39 
                <locationplace>
32 40 
                    <namedplace_id>
33 41 
                        <namedplace>
34 42 
                            <rank>county</rank>
......
45 53 
                            </parent_id>
46 54 
                        </namedplace>
47 55 
                    </namedplace_id>
48 
                </locationdetermination>
49 
                <locationnarrative>
50 
                    <_alt>
51 
                        <0>$DescriptionOfSite</0>
52 
                        <1>$LocationName</1>
53 
                    </_alt>
54 
                </locationnarrative>
56 
                </locationplace>
55 57 
            </location>
56 58 
        </path>
57 59 
    </_simplifyPath>
58 60 
</VegBIEN>
59 
Inserted 6 new rows into database
61 
Inserted 8 new rows into database

Also available in: Unified diff