Hello
I have the following table which has polygons, i need to create a multipolygon
from these polygons
i tried to use the following query, but the result are strange
331;"POLYGON((-14161.75 2241.76 2600,-14161.75 2241.76 2900,-14161.75 1941.76
2900,-14161.75 1941.76 2600,-14161.75 2241.76 2600))"
338;"POLYGON((-9336.75 2241.76 2600,-9336.75 2241.76 2900,-9336.75 1941.76
2900,-9336.75 1941.76 2600,-9336.75 2241.76 2600))"
341;"POLYGON((-14161.75 1941.76 2600,-14161.75 2241.76 2600,-9336.75 2241.76
2600,-9336.75 1941.76 2600,-14161.75 1941.76 2600))"
344;"POLYGON((-14161.75 1941.76 2900,-14161.75 1941.76 2600,-9336.75 1941.76
2600,-9336.75 1941.76 2900,-14161.75 1941.76 2900))"
347;"POLYGON((-14161.75 2241.76 2900,-14161.75 1941.76 2900,-9336.75 1941.76
2900,-9336.75 2241.76 2900,-14161.75 2241.76 2900))"
350;"POLYGON((-14161.75 2241.76 2600,-14161.75 2241.76 2900,-9336.75 2241.76
2900,-9336.75 2241.76 2600,-14161.75 2241.76 2600))"
331;"POLYGON((-14161.75 2241.76 2600,-14161.75 2241.76 2900,-14161.75 1941.76
2900,-14161.75 1941.76 2600,-14161.75 2241.76 2600))"
SELECT asEwkt(ST_Multi(ST_Union(ARRAY(SELECT the_geom FROM faces_obj))));
the result
"MULTIPOLYGON(((-14161.75 1941.76 2750,-14161.75 2241.76 2750,-9336.75 2241.76
2600,-9336.75 1941.76 2750,-14161.75 1941.76 2600)))"
Kind regards
Ihab
_________________________________________________________________
Show them the way! Add maps and directions to your party invites.
http://www.microsoft.com/windows/windowslive/products/events.aspx_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
