Three point ARC to MULTILINESTRING

[JohanNL]

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.

[Paul Ramsey-3]

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@...> 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@...
>  http://postgis.refractions.net/mailman/listinfo/postgis-users
>

_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

[brindahl]

Paul
Do we have any documentation on this?  I checked latest but there is limited info there.

This is a great post but I don't think anyone answered it.
http://postgis.refractions.net/pipermail/postgis-devel/2007-September/002778.html

I would love to add this to the asSVG since SVG handles circular arcs.  Where are we on the other issues  for support (i.e area(), psql2shp, length(), etc.)?

Thanks!
Bruce Rindahl

 Paul Ramsey wrote:

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@... 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@...
 http://postgis.refractions.net/mailman/listinfo/postgis-users

    

_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users


  

_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

[Regina Obe]

Not to mention transform support.  Last I tried you can't transform circular strings.

---

From: postgis-users-bounces@... [mailto:postgis-users-bounces@...] On Behalf Of Bruce Rindahl
Sent: Friday, April 18, 2008 11:50 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Three point ARC to MULTILINESTRING

Paul
Do we have any documentation on this?  I checked latest but there is limited info there.

This is a great post but I don't think anyone answered it.
http://postgis.refractions.net/pipermail/postgis-devel/2007-September/002778.html

I would love to add this to the asSVG since SVG handles circular arcs.  Where are we on the other issues  for support (i.e area(), psql2shp, length(), etc.)?

Thanks!
Bruce Rindahl

 Paul Ramsey wrote:

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@... 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@...
 http://postgis.refractions.net/mailman/listinfo/postgis-users

    

_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users


  

---

The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer.

---

Help make the earth a greener place. If at all possible resist printing this email and join us in saving paper.

_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

[JohanNL]

Thanks Paul! It works perfect.

Johan.

Paul Ramsey-3 wrote:

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 <[e-mail]> 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
>  [e-mail]
>  http://postgis.refractions.net/mailman/listinfo/postgis-users
>
_______________________________________________
postgis-users mailing list
[e-mail]
http://postgis.refractions.net/mailman/listinfo/postgis-users