[postgis-users] How to design a database for continents, countries, regions, cities and POIs?

[Jerry Carter]

Question out ignorance because I was not aware that this capability existed. 

I might have a geometry for a country and separate geometries for the next layer of administrative regions (e.g. states in the United States).  But there are often minor differences in the polygons such that the polygon for the country is nearly but not exactly the union of the states.  How is this handled?

Thanks.

-=- Jerry


On Apr 11, 2012, at 11:42 AM, Michal Kubenka wrote:

> Thank you.
> 
> On Wed, Apr 11, 2012 at 2:29 PM, Sandro Santilli <strk at keybit.net> wrote:
> On Mon, Apr 09, 2012 at 11:59:14PM +0200, Michal Kubenka wrote:
> > Actually what we need is some hierarchical base for relationship between
> > countries, cities, regions, etc.
> 
> PostGIS topology supports hirearchical modeling of layers, with each object
> in upper layer defined by items of the lower layer, down to primitives.
> 
> --strk;
> 
>  ,------o-.
>  |   __/  |    Delivering high quality PostGIS 2.0 !
>  |  / 2.0 |    http://strk.keybit.net - http://vizzuality.com
>  `-o------'
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120411/b2ff8d9a/attachment.html>