Revision 6179
Added by Aaron Marcuse-Kubitza over 11 years ago
| test.xml.ref | ||
|---|---|---|
| 28 | 28 |
<country>$countryVerbatim</country> |
| 29 | 29 |
<matched_place_id> |
| 30 | 30 |
<place> |
| 31 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
|
|
| 31 |
<source_id><source><shortname>geoscrub</shortname></source></source_id>
|
|
| 32 | 32 |
<coordinates_id> |
| 33 | 33 |
<coordinates> |
| 34 |
<reference_id><reference><shortname>geoscrub</shortname></reference></reference_id>
|
|
| 34 |
<source_id><source><shortname>geoscrub</shortname></source></source_id>
|
|
| 35 | 35 |
<latitude_deg> |
| 36 | 36 |
<_nullIf> |
| 37 | 37 |
<null>0</null> |
| ... | ... | |
| 53 | 53 |
<stateprovince>$stateProvinceStd</stateprovince> |
| 54 | 54 |
<distance_to_country_m><_km_to_m><value>$distErrCountry</value></_km_to_m></distance_to_country_m> |
| 55 | 55 |
<distance_to_state_m><_km_to_m><value>$distErrStateProvince</value></_km_to_m></distance_to_state_m> |
| 56 |
<georeference_valid>
|
|
| 56 |
<geosource_valid>
|
|
| 57 | 57 |
<_and> |
| 58 | 58 |
<1>$isInCountry</1> |
| 59 | 59 |
<2>$isInStateProvince</2> |
| 60 | 60 |
</_and> |
| 61 |
</georeference_valid>
|
|
| 61 |
</geosource_valid>
|
|
| 62 | 62 |
</place> |
| 63 | 63 |
</matched_place_id> |
| 64 | 64 |
<stateprovince>$stateProvinceVerbatim</stateprovince> |
Also available in: Unified diff
schemas/vegbien.sql: Renamed reference -> source to make this table more broadly applicable, and because this now stores the datasource metadata