[postgis-users] Point with azimuth

[Hubert Świetlicki]

Hi!
I'm planning to use PostGIS in my web application for storing data about
specific address points on a map and roads geometry. And then - via
MapServer - I will publish the data as WMS.
I'd like to ask you what is the usual way to store the point in PostGIS? It
may seem really trivial, I know. But - I'd like to give to the user some
additional possibilities. Firstly, the point will be displayed as an
rectangle and the user can rotate it (set azimuth) before saving. It also
will be labeled with a string. All of it - the coordinates, the angle and
the label - will be visible via WMS.
My solution is to store the point as - in fact - an rectangle (POLYGON) in
geometry db column, the label separately as the next column.
What do you think?

Best regards,

Hubert
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20101115/ac5187a7/attachment.html>