Correct. ST_Dump is your friend here.
http://postgis.refractions.net/documentation/manual-svn/ST_Dump.html
SELECT (ST_Dump(my_multipoint)).geom
FROM my_multipoint_table;
Cheers,
Kevin
Richard Greenwood wrote:
I do not think you would 'cast' a multi point to a point, I think it
would be a disaggregation, but I do not know what command(s) to use.
Maybe repost your question with a new subject line such as
'disaggregate multi point'.
Good luck,
Rich
On Tue, Sep 15, 2009 at 2:03 AM, <[email protected]> wrote:
thank you very much ST_MULTI works fine and solves my problem, is there a
function to cast a MULTIPOINT to POINT?
----- Original Message ----- From: "Richard Greenwood"
<[email protected]>
To: "PostGIS Users Discussion" <[email protected]>
Sent: Tuesday, September 15, 2009 5:25 AM
Subject: Re: [postgis-users] multipoint2point
You could use st_multi() to cast them al to multi point:
ST_Multi(geometry)
Returns the geometry as a MULTI* geometry. If the geometry is
already a MULTI*, it is returned unchanged.
SELECT ST_MULTI(wkb_geometry) FROM table;
On Mon, Sep 14, 2009 at 6:22 AM, <[email protected]> wrote:
Hi,
I have a postgistable with different geometrytyps in one table: points
and
multipoints (get this information via ST_GeometryType).
UMN Mapserver have no problems to show the geometrys, but if I try to
export
this table via ogr2ogr there is an error:
Attempt to write non-poin(MULTIPOINT) to point shapefile.
How can I cast all my geometrys to point?
Jo
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
--
Richard Greenwood
[email protected]
www.greenwoodmap.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
