[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    [postgis-users] Point with azimuth
From:       Hubert_¦wietlicki <hubert.swietlicki () gmail ! com>
Date:       2010-11-15 19:56:31
Message-ID: AANLkTik976Zqb51RsdHvqES7RtPdh=vFVWi4S4Wjq83T () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


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

[Attachment #5 (text/html)]

<div>Hi!<br></div><div>I&#39;m planning to use PostGIS in my web applicatio=
n for storing data about specific address points on a map and roads geometr=
y. And then - via MapServer - I will publish the data as WMS.</div><div>
I&#39;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&#39;d like to give to the use=
r 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 t=
he label - will be visible via WMS.</div>
<div>My solution is to store the point as - in fact - an rectangle (POLYGON=
) in geometry db column, the label separately as the next column.</div><div=
>What do you think?</div><div><br></div><div>Best regards,</div><div><br>
</div><div>Hubert</div>


_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


[prev in list] [next in list] [prev in thread] [next in thread]