[postgis-users] Storing Points and Polygons

Max postgis at lists.meisel.cn
Sun Dec 16 06:38:49 PST 2007


Hello,

because i`m a newbie to postgis i`ve got a question related to storing
point and polygons. Do i have to store points which are included in more
than one polygon, redundant?

For example: i do have two polygons:

POLYGON(1 1,1 2 ,2 2 ,2 1,1 1)
POLYGON(1 1,1 4 ,4 4 ,4 1,1 1)

in both polygons point(1,1) is included. So if i want to change the
coordinates of that point i have to change it in all polygons or can i
just have a table with points on one with polygons which refer to the
point?

How do i have to handle this problem?

best regards


Helmar



More information about the postgis-users mailing list