<html>
<head>
<title></title>
<meta name="GENERATOR" content="MSHTML 8.00.6001.18812"></meta>
</head>
<body>
<div align="left">You can use st_dump for that pupose. Then you will get one row per point in your multipoint.</div>
<div align="left"> </div>
<div align="left">select (st_dump(the_multipoint)).geom from thetable</div>
<div align="left"> </div>
<div align="left">/Nicklas<br />
<br />
2009-09-15 wrote:<br />
<br />
thank you very much ST_MULTI works fine and solves my problem, is there a <br />
>function to cast a MULTIPOINT to POINT?<br />
><br />
><br />
>----- Original Message ----- <br />
>From: "Richard Greenwood"
<richard.greenwood@gmail.com></richard.greenwood@gmail.com><br />
>To: "PostGIS Users Discussion"
<postgis-users@postgis.refractions.net></postgis-users@postgis.refractions.net><br />
>Sent: Tuesday, September 15, 2009 5:25 AM<br />
>Subject: Re: [postgis-users] multipoint2point<br />
><br />
><br />
>> You could use st_multi() to cast them al to multi point:<br />
>> ST_Multi(geometry)<br />
>><br />
>> Returns the geometry as a MULTI* geometry. If the geometry is<br />
>> already a MULTI*, it is returned unchanged.<br />
>><br />
>> SELECT ST_MULTI(wkb_geometry) FROM table;<br />
>><br />
>><br />
>> On Mon, Sep 14, 2009 at 6:22 AM,
<jj.wag@gmx.de></jj.wag@gmx.de>wrote:<br />
>>> Hi,<br />
>>> I have a postgistable with different geometrytyps in one table: points <br />
>>> and<br />
>>> multipoints (get this information via ST_GeometryType).<br />
>>> UMN Mapserver have no problems to show the geometrys, but if I try to <br />
>>> export<br />
>>> this table via ogr2ogr there is an error:<br />
>>> Attempt to write non-poin(MULTIPOINT) to point shapefile.<br />
>>> How can I cast all my geometrys to point?<br />
>>> Jo<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 />
>><br />
>> -- <br />
>> Richard Greenwood<br />
>> richard.greenwood@gmail.com<br />
>> www.greenwoodmap.com<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 />
></div>
</body>
</html>