[postgis-users] Three point ARC to MULTILINESTRING

Paul Ramsey pramsey at cleverelephant.ca
Fri Apr 18 08:33:15 PDT 2008


Use the CIRCULARSTRING type, and the ST_CurveToLine(geometry) function
to convert it to a linestring.

CREATE TABLE test ( GEOM geometry );
INSERT INTO test VALUES ('CIRCULARSTRING(0 0, 1 1, 2 0)');
SELECT ST_AsText(ST_CurveToLine(geom)) FROM test;


P

On Fri, Apr 18, 2008 at 7:53 AM, JohanNL <johan12365 at hotmail.com> wrote:
>
>  Hi All,
>
>  I have a question. I need to store an Arc into a postgis database. As far as
>  I know, Postgis doens't support arcs. Is there another way to convert a
>  Three Point Arc to a MultiLineString?
>
>  Best regards,
>
>  Johan.
>  --
>  View this message in context: http://www.nabble.com/Three-point-ARC-to-MULTILINESTRING-tp16763471p16763471.html
>  Sent from the PostGIS - User mailing list archive at Nabble.com.
>
>  _______________________________________________
>  postgis-users mailing list
>  postgis-users at postgis.refractions.net
>  http://postgis.refractions.net/mailman/listinfo/postgis-users
>



More information about the postgis-users mailing list