[postgis-users] Rounding the angle of the polygon

[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.