[postgis-users] multipoint2point

[Kevin Neufeld]

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,  <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
>>
>>     
>
>
>
>