[postgis-users] Rounding the angle of the polygon

[Christian Schwartze]

Hi,

if I got your point of question correctly, why not calculating with the
bounding box of relevant polygons?

Regards,
Christian.

Am Donnerstag, den 17.01.2008, 09:32 +0100 schrieb Witteveen, Eduard:
> Hello,
> 
> I have a large collection of polygons, where each polygon represents the shape of a building. The quality of the data is not perfect , but it can be used in a good way to give orientation in a map. However the problem is that not all the corners are 90 degrees, due to the quick-and-dirty way we gatherd the data. I want to change the corners, within a certain treshold (85-95), to become 90 degrees so it "looks" better on the orientation-map (and i think it will even improve the quality of my data, but im not sure of this).
> 
> Question: 
> 	Is there a way to round the angle of the corners to 90 degrees of a polygon, where the corner is between 85 and 95 degrees? If this can't be done in (pl)sql, what would be "the way" to do this?
> 
> Furthermore, i've did searches on the mailinglist/google/oracle/.. but i couldnt find any leads except for the "degrees" function but im not sure how this method could help me
> 
> Eduard Witteveen
> 
> 
> ************************************************************************************************
> DISCLAIMER:
> Aan de informatie in deze e-mail en ieder aangehecht databestand kunnen geen rechten 
> worden ontleend en de gemeente Aa en Hunze aanvaardt geen aansprakelijkheid voor 
> schade als gevolg van onjuistheden en/of gedateerde informatie.
> 
> Als u niet de bedoelde ontvanger bent wilt u dan dit bericht en ieder aangehecht 
> databestand verwijderen en de afzender hiervan via e-mail op de hoogte stellen.
> ************************************************************************************************
> 
> Deze mail is gescand met McAfee Webshield en bevat geen virussen.
> 
> Gemeente Aa en Hunze.
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users