Revision 4726
Added by Aaron Marcuse-Kubitza about 12 years ago
| test.xml.ref | ||
|---|---|---|
| 5 | 5 |
<path> |
| 6 | 6 |
<location> |
| 7 | 7 |
<sourceaccessioncode>$PlotCD</sourceaccessioncode> |
| 8 |
<locationdetermination>
|
|
| 8 |
<locationcoords>
|
|
| 9 | 9 |
<latitude> |
| 10 | 10 |
<_nullIf> |
| 11 | 11 |
<null>0</null> |
| ... | ... | |
| 20 | 20 |
<value>$DecimalLongitude</value> |
| 21 | 21 |
</_nullIf> |
| 22 | 22 |
</longitude> |
| 23 |
<namedplace_id> |
|
| 24 |
<namedplace> |
|
| 25 |
<rank>county</rank> |
|
| 26 |
<placename>$County</placename> |
|
| 27 |
<parent_id> |
|
| 28 |
<namedplace> |
|
| 29 |
<rank>stateProvince</rank> |
|
| 30 |
<placename>$StateProvince</placename> |
|
| 31 |
</namedplace> |
|
| 32 |
</parent_id> |
|
| 33 |
</namedplace> |
|
| 34 |
</namedplace_id> |
|
| 35 |
</locationdetermination> |
|
| 23 |
</locationcoords> |
|
| 36 | 24 |
<locationevent> |
| 37 | 25 |
<taxonoccurrence> |
| 38 | 26 |
<aggregateoccurrence> |
| ... | ... | |
| 83 | 71 |
</taxondetermination> |
| 84 | 72 |
</taxonoccurrence> |
| 85 | 73 |
</locationevent> |
| 74 |
<locationplace> |
|
| 75 |
<namedplace_id> |
|
| 76 |
<namedplace> |
|
| 77 |
<rank>county</rank> |
|
| 78 |
<placename>$County</placename> |
|
| 79 |
<parent_id> |
|
| 80 |
<namedplace> |
|
| 81 |
<rank>stateProvince</rank> |
|
| 82 |
<placename>$StateProvince</placename> |
|
| 83 |
</namedplace> |
|
| 84 |
</parent_id> |
|
| 85 |
</namedplace> |
|
| 86 |
</namedplace_id> |
|
| 87 |
</locationplace> |
|
| 86 | 88 |
</location> |
| 87 | 89 |
</path> |
| 88 | 90 |
</_simplifyPath> |
| 89 | 91 |
</VegBIEN> |
| 90 |
Inserted 13 new rows into database |
|
| 92 |
Inserted 14 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