[postgis-users] multipoint2point

[Richard Greenwood]

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,  <jj.wag at gmx.de> 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"
> <richard.greenwood at gmail.com>
> To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
> 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,  <jj.wag at gmx.de> 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
>>> postgis-users at postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>
>>
>>
>>
>> --
>> Richard Greenwood
>> richard.greenwood at gmail.com
>> www.greenwoodmap.com
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



-- 
Richard Greenwood
richard.greenwood at gmail.com
www.greenwoodmap.com