Seasons greetings, fellow geo-geeks! Here’s my problem. Right now, I have organized OurAirports like this:
world : continent * continent : country * country : region * region : airport *
It’s the kind of neat data structure that people like me love, but that never quite works. First of all, not every country is divided into regions (provinces/states/etc.) and I don’t always know what region an airport is in, but I deal with that by adding an “Unassigned” pseudo-region to every country.
More importantly, not every country belongs to a single continent. The most obvious exceptions are Russia and Turkey, both of which span Europe and Asia, but there may be others that I haven’t thought of.
So here are my questions:
- Are there any countries besides Russia and Turkey that span more than one continent?
- Are there any subdivisions of the above countries that span more than one continent? For example, does Turkey have a province, or does Russia have an oblast that lies in both Asia and Europe?
I’m trying to figure out if I can link regions to continents, or if I have do have a link from every single airport.
Thanks in advance for any help.