<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=utf-8">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=WordSection1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Wim, <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>You can do these offsets in pixel values at a class level, just
not a feature level. This pretty much does what you are describing, although
it gets a little funky when the lines are diagonal and not straight. <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> CLASS<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> STYLE<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> COLOR 0 0 0<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> WIDTH 2<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> END<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> STYLE<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> COLOR 255 0 0<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> WIDTH 2<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> OFFSET 10 10<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> END<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> STYLE<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> COLOR 0 255 0<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> WIDTH 2<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> OFFSET -10 -10<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> END<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'> END<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>David.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
mapserver-users-bounces@lists.osgeo.org
[mailto:mapserver-users-bounces@lists.osgeo.org] <b>On Behalf Of </b>Wim
Vanbelle<br>
<b>Sent:</b> Thursday, August 12, 2010 9:32 AM<br>
<b>To:</b> mapserver-users@lists.osgeo.org<br>
<b>Subject:</b> Re: [mapserver-users] Offset values from database<o:p></o:p></span></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal style='margin-bottom:12.0pt'>Maybe this pic helps elaborate
on what i'm trying to accomplish: <a
href="http://fileshare.myroute.be/exchange/asymmetriclinedrawing.png">http://fileshare.myroute.be/exchange/asymmetriclinedrawing.png</a><br>
It should be noted that the distance between the 2 (new) lines, should be a
fixed value over the zoomlevels. It must not be the case that at the furthest
zoomlevel the lines are further apart.<br>
<br>
I've looked all over for this, but never really found a proper solution. I
tried cartographic symbol drawing, but it only draws on the same side every
time. Maybe I'm just doing it wrong :).<br>
<br>
<o:p></o:p></p>
<div>
<p class=MsoNormal>On 12 August 2010 16:28, Wim Vanbelle <<a
href="mailto:wimvanbelle@gmail.com">wimvanbelle@gmail.com</a>> wrote:<o:p></o:p></p>
<p class=MsoNormal>Hello,<br>
<br>
thanks for your feedback.<br>
<br>
The issue with this, is that the underlying linestrings (the 2 that would lie
on top of eachother), have different colors :(.<br>
<br>
So they have to be moved apart from one another. I have not found a way to do
this with asymmetric line drawing either, as it will always offset to the same
side.<br>
<br>
This is why i would need the offset value to be configurable in the database. I
could select a different pixel offset for each line and they would always
appear next to eachtoher (no matter what zoomlevel).<br>
<br>
I can elaborate on the problem more if I am a little too confusing !<o:p></o:p></p>
<div>
<div>
<p class=MsoNormal style='margin-bottom:12.0pt'><br>
<br>
<o:p></o:p></p>
<div>
<p class=MsoNormal>On 12 August 2010 16:20, Cristiano Sumariva <<a
href="mailto:sumariva@gmail.com" target="_blank">sumariva@gmail.com</a>>
wrote:<o:p></o:p></p>
<p class=MsoNormal style='margin-bottom:12.0pt'>If it is a display problem why
not try create some special symbology to overlap one line with another using
different symbol strokes. So the user will se that are 2 lines overlayed.<o:p></o:p></p>
<div>
<p class=MsoNormal>2010/8/12 Wim Vanbelle <<a
href="mailto:wimvanbelle@gmail.com" target="_blank">wimvanbelle@gmail.com</a>><o:p></o:p></p>
<div>
<div>
<p class=MsoNormal>Hi David,<br>
<br>
I read that documentation before though. I was hoping it just hadn't been
updated... Is this possibly a feature for 6.0 ?<br>
<br>
Are there any other ways how one could offset a feature in pixels, rather than
in lat/long coords?<br>
<br>
Maybe I should elaborate on the original problem a little. Consider 2 line
segments that lie above one another. The general idea is to 'offset' them a
given x , y value, so they will both display next to one another, rather than
on top of eachother.<br>
<br>
If you would however perform this code simply on lat/long values, it would
imply, that when scaling your map at the most detailed zoom level, the lines
would lie very far apart, and when zoomed out, they would appear to lie on top
of eachother.<br>
<br>
I find it hard to believe that I would need to pre calculate all the data in
order to obtain geometry objects for each zoom level.<br>
<br>
Maybe some veterans have some good insight in this :).<o:p></o:p></p>
<div>
<div>
<p class=MsoNormal style='margin-bottom:12.0pt'><o:p> </o:p></p>
<div>
<p class=MsoNormal>On 12 August 2010 15:26, Fawcett, David (MPCA) <<a
href="mailto:David.Fawcett@state.mn.us" target="_blank">David.Fawcett@state.mn.us</a>>
wrote:<o:p></o:p></p>
<div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:11.0pt;color:#1F497D'>Wim, </span><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:11.0pt;color:#1F497D'> </span><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:11.0pt;color:#1F497D'>If you don’t want me to tell you, you
will likely want to look at the mapfile documentation at: <a
href="http://mapserver.org/mapfile/style.html" target="_blank">http://mapserver.org/mapfile/style.html</a></span><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:11.0pt;color:#1F497D'> </span><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:11.0pt;color:#1F497D'>[Spoiler Alert]</span><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:11.0pt;color:#1F497D'>You can’t use values from an attribute
table to set the value of this property</span><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:11.0pt;color:#1F497D'>[/Spoiler Alert]</span><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:11.0pt;color:#1F497D'> </span><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:11.0pt;color:#1F497D'>David.</span><o:p></o:p></p>
<div style='border:none;border-top:solid windowtext 1.0pt;padding:3.0pt 0in 0in 0in;
border-color:-moz-use-text-color -moz-use-text-color'>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span
style='font-size:10.0pt'>From:</span></b><span style='font-size:10.0pt'> <a
href="mailto:mapserver-users-bounces@lists.osgeo.org" target="_blank">mapserver-users-bounces@lists.osgeo.org</a>
[mailto:<a href="mailto:mapserver-users-bounces@lists.osgeo.org" target="_blank">mapserver-users-bounces@lists.osgeo.org</a>]
<b>On Behalf Of </b>Wim Vanbelle<br>
<b>Sent:</b> Thursday, August 12, 2010 5:48 AM<o:p></o:p></span></p>
<div>
<p class=MsoNormal><span style='font-size:10.0pt'><br>
<b>To:</b> <a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a><o:p></o:p></span></p>
</div>
<p class=MsoNormal><b><span style='font-size:10.0pt'>Subject:</span></b><span
style='font-size:10.0pt'> [mapserver-users] Offset values from database</span><o:p></o:p></p>
</div>
<div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Hi,
<br>
<br>
I'm trying to load offset X, Y data from the postgis database.<br>
<br>
Each feature has an offset value defined there.<br>
<br>
My mapfile (relevant part) looks like this:<br>
<br>
In the layer:<br>
DATA
"geom_mercator from map_links using unique Id using SRID=900913"<br>
<br>
STYLE<br>
WIDTH 6<br>
COLOR 0 255 0<br>
ANTIALIAS TRUE<br>
ANGLE AUTO<br>
OFFSET [offsetX] [offsetY]<br>
END<br>
<br>
Please don't tell me the offsetX, Y values cannot be read from the database.
That would be a huge issue for me.<br>
<br>
Thank you for your time.<br>
<br>
Best regards<o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</div>
<p class=MsoNormal>_______________________________________________<br>
mapserver-users mailing list<o:p></o:p></p>
<div>
<p class=MsoNormal><br>
<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a><o:p></o:p></p>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><a
href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><o:p></o:p></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</body>
</html>