<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
</style>
</head>
<body class='hmmessage'>
Thanks Paul. <br><br>I also noticed that some other functions too have this limitation (such as ST_CONTAINS). Is there a table/matrix somewhere that lists which function supports XYZM?<br><br>Satish<br><br>> Date: Wed, 5 Aug 2009 10:36:46 -0700<br>> From: pramsey@opengeo.org<br>> To: postgis-users@postgis.refractions.net<br>> Subject: Re: [postgis-users] ST_UNION drops M coordinate<br>> <br>> Yes, we just don't support the higher dimension in the operation. GEOS<br>> was extended to 3 dimensional handling some time ago, but never got<br>> pushed farther when we added M at postgis 1.0. Probably fixable, but<br>> with a reasonable amount of careful work to catch every case.<br>> <br>> P<br>> <br>> On Wed, Aug 5, 2009 at 10:22 AM, Satish Murthy<satish_m@hotmail.com> wrote:<br>> ><br>> > When I do this (notice the second ST_COLLECT):<br>> > select ST_AsEWKT (ST_COLLECT (geom)) from (<br>> > select (ST_DUMP(geom)).geom from (select p_geom as geom from (<br>> > select ST_COLLECT (geom_col, st_GeomFromEWKT('Point(1 -1 0 10)')) as<br>> > p_geom from tab) a<br>> > )as b ) as c<br>> > I get:<br>> > "MULTIPOINT(71.1 -42.31 10 10,1 -1 0 10,1 -1 0 10)"<br>> > This is fine, except that "1 -1 0 10" gets repeated.<br>> ><br>> > BUT---<br>> > When I do (I use ST_UNION here):<br>> > select ST_AsEWKT (ST_COLLECT (geom)) from (<br>> > select (ST_DUMP(geom)).geom from (select p_geom as geom from (<br>> > select ST_UNION (geom_col, st_GeomFromEWKT('Point(1 -1 0 10)')) as p_geom<br>> > from tab) a<br>> > )as b ) as c<br>> > I get this:<br>> > "MULTIPOINT(1 -1 0,71.1 -42.31 10)"<br>> > No repetition, but the M coordinate is missing.<br>> ><br>> > Any pointers on what's going wrong here?<br>> ><br>> ><br>> > ________________________________<br>> > Are you an untamed, bizarre or daring explorer? Find out now! Drag n' drop<br>> > _______________________________________________<br>> > postgis-users mailing list<br>> > postgis-users@postgis.refractions.net<br>> > http://postgis.refractions.net/mailman/listinfo/postgis-users<br>> ><br>> ><br>> _______________________________________________<br>> postgis-users mailing list<br>> postgis-users@postgis.refractions.net<br>> http://postgis.refractions.net/mailman/listinfo/postgis-users<br><br /><hr />Date India’s Teen Diva. Find out if you hit it off with her or are her fiery opposite. <a href='http://www.WindowsLivePlanet.com/DateDiva' target='_new'>Drag n’ drop</a></body>
</html>