I would like to know the azimuth and tilt of a polygon / surface in a PostGIS database. The azimuth should be given e.g. from 0° to 360° degrees. The altitude should be between 0° to 90°. An example result table:
sid |*azimuth | tilt |*geom--------------------------- 0 | 0 | 0 | ... 1 | 90 | 45 | ... So sid 0 would represent a north facing wall and sid 1 a East facing roof with 45° degree slope.
I assume the functions ST_Centroid and ST_Azimuth will probably involved in the solution, but I am not sure how to put those together...
أكثر...
sid |*azimuth | tilt |*geom--------------------------- 0 | 0 | 0 | ... 1 | 90 | 45 | ... So sid 0 would represent a north facing wall and sid 1 a East facing roof with 45° degree slope.
I assume the functions ST_Centroid and ST_Azimuth will probably involved in the solution, but I am not sure how to put those together...
أكثر...