<div dir="ltr"><div>Hi Stephen </div><div>How can you explain that the st_offsetcurve make offset according to line direction.</div><div> </div><div>For example</div><div>SELECT ST_OffsetCurve (geom, -20) as geom_off</div>
<div>FROM table</div><div>WHERE id_arc in (1690,1693)</div><div> </div><div>give me the result that you can see in the attached image rendering in qgis</div><div>(One Direction on the left, the other on the right).</div><div>
</div><div>So I have the dirction information inside the arc geometry.</div><div> </div><div> </div><div> </div><div>Thanks</div><div>fb</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">2013/5/16 Stephen Woodbridge <span dir="ltr"><<a href="mailto:woodbri@swoodbridge.com" target="_blank">woodbri@swoodbridge.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">How do you define arc direction?<br>
If you had a function:<br>
<br>
select getArcDirection(arc);<br>
<br>
What would you expect the output to be?<br>
<br>
In your image, the arc direction is a function of the labeling algorithm in combination with this that of the arc. For example if the label were flipped upside down and written along the underside of the line then the arc direction symbol would have to be reversed. So we can see that it is a function of the label and not just the arc alone.<br>
<br>
postgis does not do rendering so it can not define that.<br>
<br>
-Steve<div class="im"><br>
<br>
On 5/16/2013 11:14 AM, franco base wrote:<br>
</div><blockquote style="margin:0px 0px 0px 0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid" class="gmail_quote"><div class="im">
I send again message because it was blocked for the attcahed file too big<br>
<br>
<br>
I have a public transport network with an arc for 2 Point(the bus stop).<br>
I'd know without using the points information arc direction like in qgis<br>
(as you can see from the attached imagine with arc_id and direction)<br>
<br>
<br>
2013/5/14 Nicolas Ribot <<a href="mailto:nicolas.ribot@gmail.com" target="_blank">nicolas.ribot@gmail.com</a><br></div>
<mailto:<a href="mailto:nicolas.ribot@gmail.com" target="_blank">nicolas.ribot@gmail.<u></u>com</a>>><div class="im"><br>
<br>
Hi,<br>
<br>
If you want to materialize direction from start to end of line, you<br>
can use st_startPoint and st_endpoint to determines the right ends.<br>
What is your use case ?<br>
<br>
Nicolas<br>
<br>
<br>
On 14 May 2013 13:49, franco base <<a href="mailto:frenk.calza@gmail.com" target="_blank">frenk.calza@gmail.com</a><br></div><div class="im">
<mailto:<a href="mailto:frenk.calza@gmail.com" target="_blank">frenk.calza@gmail.com</a>><u></u>> wrote:<br>
<br>
Hi.<br>
I know tgis function but doesn't work.<br>
Myabe my question isn't correct.<br>
I'd have a binary value according to the arc direction.<br>
For example, in qgis I can view this information:<br>
I can see an arrow on my arc according to direction.<br>
I'd have the same using postgis.<br>
<br>
Thanks<br>
<br>
<br>
<br></div>
2013/5/14 Paolo Corti <<a href="mailto:pcorti@gmail.com" target="_blank">pcorti@gmail.com</a> <mailto:<a href="mailto:pcorti@gmail.com" target="_blank">pcorti@gmail.com</a>>><div class="im"><br>
<br>
On Tue, May 14, 2013 at 6:03 PM, franco base<br></div><div class="im">
<<a href="mailto:frenk.calza@gmail.com" target="_blank">frenk.calza@gmail.com</a> <mailto:<a href="mailto:frenk.calza@gmail.com" target="_blank">frenk.calza@gmail.com</a>><u></u>> wrote:<br>
> Hi.<br>
> I have a question for the list.<br>
><br>
> Is there a postgis function to have line direction?<br>
><br>
<br>
<a href="http://postgis.refractions.net/docs/ST_Azimuth.html" target="_blank">http://postgis.refractions.<u></u>net/docs/ST_Azimuth.html</a><br>
<br>
regards<br>
p<br>
<br>
--<br>
Paolo Corti<br>
Geospatial software developer<br>
web: <a href="http://www.paolocorti.net" target="_blank">http://www.paolocorti.net</a><br>
twitter: @capooti<br>
skype: capooti<br>
______________________________<u></u>_________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br></div>
<mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a>><div class="im"><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-<u></u>bin/mailman/listinfo/postgis-<u></u>users</a><br>
<br>
<br>
<br>
______________________________<u></u>_________________<br>
postgis-users mailing list<br></div>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a> <mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a>><div class="im">
<br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-<u></u>bin/mailman/listinfo/postgis-<u></u>users</a><br>
<br>
<br>
<br>
______________________________<u></u>_________________<br>
postgis-users mailing list<br></div>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a> <mailto:<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.<u></u>osgeo.org</a>><div class="im">
<br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-<u></u>bin/mailman/listinfo/postgis-<u></u>users</a><br>
<br>
<br>
<br>
<br>
<br>
______________________________<u></u>_________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-<u></u>bin/mailman/listinfo/postgis-<u></u>users</a><br>
<br>
</div></blockquote><div class="HOEnZb"><div class="h5">
<br>
______________________________<u></u>_________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-<u></u>bin/mailman/listinfo/postgis-<u></u>users</a><br>
</div></div></blockquote></div><br></div>