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 > -- Richard Greenwood [email protected] www.greenwoodmap.com _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
