Assign every place a country code #16
Description
It would be ideal if each source dataset contained the ISO country-code for each place, unfortunately, this is rare.
This issue is to investigate a method of ensuring that each place is associated with an ISO code at import-time.
One way this could be achieved is to enforce hierarchies for each place and use that to find the country.
Another way would be to PIP each place as it's imported, but this comes with the complexity of requiring countries (and dependencies) to be imported prior to other data.
We could also consider relaxing the requirement to say that the country code is allowed to be NULL during import but is computed later, after all the data imported via a post-processing script. -it depends on how we intend to use it.
Some advantages to having mandatory country codes:
- Issues like Improved place ontology #4 can be resolved
- Fast filtering and searching per-country
- Easy to cut regional extracts from a planet database
- etc.
We would also need to develop a convention for places for which an ISO code is not relevant, just as: ocean, continent, planet