Revision 4726
Added by Aaron Marcuse-Kubitza about 12 years ago
| test.xml.ref | ||
|---|---|---|
| 93 | 93 |
</to> |
| 94 | 94 |
</_range> |
| 95 | 95 |
</elevationrange> |
| 96 |
<locationdetermination>
|
|
| 96 |
<locationcoords>
|
|
| 97 | 97 |
<latitude> |
| 98 | 98 |
<_nullIf> |
| 99 | 99 |
<null>0</null> |
| ... | ... | |
| 108 | 108 |
<value>$longitude</value> |
| 109 | 109 |
</_nullIf> |
| 110 | 110 |
</longitude> |
| 111 |
<namedplace_id> |
|
| 112 |
<namedplace> |
|
| 113 |
<rank>county</rank> |
|
| 114 |
<placename>$County</placename> |
|
| 115 |
<parent_id> |
|
| 116 |
<namedplace> |
|
| 117 |
<rank>stateProvince</rank> |
|
| 118 |
<placename>$StateProvince</placename> |
|
| 119 |
<parent_id> |
|
| 120 |
<namedplace> |
|
| 121 |
<rank>country</rank> |
|
| 122 |
<placename>$Country</placename> |
|
| 123 |
<parent_id> |
|
| 124 |
<namedplace> |
|
| 125 |
<rank>continent</rank> |
|
| 126 |
<placename>$ContinentOcean</placename> |
|
| 127 |
</namedplace> |
|
| 128 |
</parent_id> |
|
| 129 |
</namedplace> |
|
| 130 |
</parent_id> |
|
| 131 |
</namedplace> |
|
| 132 |
</parent_id> |
|
| 133 |
</namedplace> |
|
| 134 |
</namedplace_id> |
|
| 135 |
</locationdetermination> |
|
| 111 |
</locationcoords> |
|
| 136 | 112 |
<locationevent> |
| 137 | 113 |
<taxonoccurrence> |
| 138 | 114 |
<aggregateoccurrence> |
| ... | ... | |
| 207 | 183 |
</taxonoccurrence> |
| 208 | 184 |
</locationevent> |
| 209 | 185 |
<locationnarrative>$Locality</locationnarrative> |
| 186 |
<locationplace> |
|
| 187 |
<namedplace_id> |
|
| 188 |
<namedplace> |
|
| 189 |
<rank>county</rank> |
|
| 190 |
<placename>$County</placename> |
|
| 191 |
<parent_id> |
|
| 192 |
<namedplace> |
|
| 193 |
<rank>stateProvince</rank> |
|
| 194 |
<placename>$StateProvince</placename> |
|
| 195 |
<parent_id> |
|
| 196 |
<namedplace> |
|
| 197 |
<rank>country</rank> |
|
| 198 |
<placename>$Country</placename> |
|
| 199 |
<parent_id> |
|
| 200 |
<namedplace> |
|
| 201 |
<rank>continent</rank> |
|
| 202 |
<placename>$ContinentOcean</placename> |
|
| 203 |
</namedplace> |
|
| 204 |
</parent_id> |
|
| 205 |
</namedplace> |
|
| 206 |
</parent_id> |
|
| 207 |
</namedplace> |
|
| 208 |
</parent_id> |
|
| 209 |
</namedplace> |
|
| 210 |
</namedplace_id> |
|
| 211 |
</locationplace> |
|
| 210 | 212 |
</location> |
| 211 | 213 |
</path> |
| 212 | 214 |
</_simplifyPath> |
| 213 | 215 |
</VegBIEN> |
| 214 |
Inserted 26 new rows into database |
|
| 216 |
Inserted 28 new rows into database |
|
Also available in: Unified diff
schemas/vegbien.sql: Split locationdetermination into locationcoords and locationplace, so that coordinate determinations can be made separately from place determinations