Re: [postgis-users] Find out if polygon is circle

2015-02-05 Thread Bernecker, Wolfgang
Thanks to all of you very much for your insightful replies! The circles are computer-generated with 15-20 points (I should've mentioned that from the beginning). I very much like the compactness-approach as well as the LineToCurve. I will try out these approaches and let you know about my

Re: [postgis-users] Find out if polygon is circle

2015-02-05 Thread RĂ©mi Cura
Hey, your question is a little bit un-precise. If you try to find circle that have been drawn by a CAD program for instance (perfect circle), you can use ST_LineToCurve(). If you are trying to detect polygons that look like circle (maybe the border is very close to a circle, but overall it is

Re: [postgis-users] Find out if polygon is circle

2015-02-05 Thread Brent Wood
I have many different polygons in my database and would like to know if there's any way to find out if a polygon has the shape of a circle. I searched both on Google and in the Postgis documentation but couldn't find someone with the same question. The lines joining the vertices of a

Re: [postgis-users] Find out if polygon is circle

2015-02-04 Thread Martijn Meijers
I have many different polygons in my database and would like to know if there's any way to find out if a polygon has the shape of a circle. You could try to compute compactness for the shapes. See e.g.

[postgis-users] Find out if polygon is circle

2015-02-04 Thread Bernecker, Wolfgang
Hi all, this is my first time writing to this mailing list, please let me know if I'm disregarding any rules. I have many different polygons in my database and would like to know if there's any way to find out if a polygon has the shape of a circle. I searched both on Google and in the Postgis