18 reputation
3
bio website
location
age
visits member for 2 years
seen Dec 15 '13 at 13:35

Nov
14
awarded  Popular Question
Apr
11
awarded  Scholar
Apr
11
accepted How to design a database for continents, countries, regions, cities and POIs?
Apr
9
comment How to design a database for continents, countries, regions, cities and POIs?
@Russell Actually what we need is some hierarchical base for relationship between countries, cities, regions, etc. Main goal of the application will be collecting tourist data from many sources about specific cities, regions, countries and so on, and store it in database. Let's say we will have city Rome, we collect some info about this city into database from couple sources. And we need to know that Rome is in province Rome, sub-region Lazio in region Lazio, country Italy. So system should be flexible to allow create such relation from real world.
Apr
9
comment How to design a database for continents, countries, regions, cities and POIs?
In our model we can consider city as point not as polygon, so it won't be in same table. Our main goal is mining data about elements (from continents to POIs), but we need have it in some hierarchical tree which can handle most common situations of organization.
Apr
9
awarded  Student
Apr
9
asked How to design a database for continents, countries, regions, cities and POIs?