Thank you for reply. But I'm afraid that such solution won't fit our system, because for example there can be situation when POI belong to region. And also I think it can cause some problems with ORM.
Michal K. On Mon, Apr 9, 2012 at 2:22 PM, Francois Hugues <[email protected]>wrote: > I think it could be better to have a table for each kind of object because > they will have different attributes (for an example, in a matter of scale, > a POI belong to a city, a city belong to a province which is part of a > sub_region which is included into a state and the continent is composed of > several states). > > Hugues > > -----Message d'origine----- > De : [email protected] [mailto: > [email protected]] De la part de mkubenka > Envoyé : lundi 9 avril 2012 13:31 > À : [email protected] > Objet : [postgis-users] How to design a database for continents, > countries, regions, cities and POIs? > > I'm brand new to GIS programming and I am designing a GIS application. > Target > is to create system with continents, countries, regions (including states, > sub-regions, provinces), cities and places in cities. Each of this elements > will contain some text information and related stuff. As database we are > going to use PostgreSQL with PostGIS. > > My question is how to design database for this system? I was thinking of 2 > tables polygons and points, but I'm not sure if it's good way of thinking. > > -- > View this message in context: > http://postgis.17.n6.nabble.com/How-to-design-a-database-for-continents-countries-regions-cities-and-POIs-tp4715669p4715669.html > Sent from the PostGIS - User mailing list archive at Nabble.com. > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
