<html><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:10pt">Rob<br><br>This wikie page describes the hiking routes. The tags are generally found on relations descrbiing the route. The following tags are used<br>route=hiking<br>network= iwn, nwn, rwn or lwn<br><br>For example, see this Overpass request to extract such routes. Zoom in to an area and run the script.<br>http://overpass-turbo.eu/s/2kU<br><br><div><span><br></span></div><div> </div><div><span style="font-style:italic;color:rgb(0, 0, 191);font-weight:bold;">Pierre <br></span><br></div> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 10pt;"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 12pt;"> <div dir="ltr"> <hr size="1"> <font face="Arial" size="2">
<b><span style="font-weight:bold;">De :</span></b> Rob Goethals / SNP <Rob.Goethals@snp.nl><br> <b><span style="font-weight: bold;">À :</span></b> "'dev@openstreetmap.org'" <dev@openstreetmap.org> <br> <b><span style="font-weight: bold;">Envoyé le :</span></b> Vendredi 31 janvier 2014 10h57<br> <b><span style="font-weight: bold;">Objet :</span></b> [OSM-dev] where can I find rwn_ref values in Postgis-database?<br> </font> </div> <div class="y_msg_container"><br><div id="yiv9809521394"><style><!--
#yiv9809521394
_filtered #yiv9809521394 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}
#yiv9809521394
#yiv9809521394 p.yiv9809521394MsoNormal, #yiv9809521394 li.yiv9809521394MsoNormal, #yiv9809521394 div.yiv9809521394MsoNormal
{margin:0cm;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri", "sans-serif";}
#yiv9809521394 a:link, #yiv9809521394 span.yiv9809521394MsoHyperlink
{color:blue;text-decoration:underline;}
#yiv9809521394 a:visited, #yiv9809521394 span.yiv9809521394MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
#yiv9809521394 span.yiv9809521394E-mailStijl17
{font-family:"Calibri", "sans-serif";color:windowtext;}
#yiv9809521394 .yiv9809521394MsoChpDefault
{font-family:"Calibri", "sans-serif";}
_filtered #yiv9809521394 {margin:70.85pt 70.85pt 70.85pt 70.85pt;}
#yiv9809521394 div.yiv9809521394WordSection1
{}
--></style><div><div class="yiv9809521394WordSection1"><div class="yiv9809521394MsoNormal"><span lang="EN-US">Hi,</span></div><div class="yiv9809521394MsoNormal"><span lang="EN-US"> </span></div><div class="yiv9809521394MsoNormal"><span lang="EN-US">I am setting up our own WMS-server with OSM-data to be able to give it our own lay-out. The base is a postgresql/postgis database which I fill with the osm2psql-command.</span></div><div class="yiv9809521394MsoNormal"><span lang="EN-US">On the Belgium maps I like to put the numbers belonging to the hiking network. On <a rel="nofollow" target="_blank" href="http://www.openstreetmap.org/">www.openstreetmap.org</a> I can see that the values are put in the rwn_ref tag. But where do I find these hiking network numbers in the database? I can see there is a rwn_ref-column in the planet_osm_line table. But the hiking network numbers are not in that column. I searched every logical place in the database but
couldn’t find it anywhere.</span></div><div class="yiv9809521394MsoNormal"><span lang="EN-US"> </span></div><div class="yiv9809521394MsoNormal"><span lang="EN-US">Can somebody out there please help me find the rwn_ref-tag values so I can lay-out them and put them on our map?</span></div><div class="yiv9809521394MsoNormal"><span lang="EN-US"> </span></div><div class="yiv9809521394MsoNormal"><span lang="EN-US">Thank you.</span></div><div class="yiv9809521394MsoNormal"><span lang="EN-US">Kind regards,</span></div><div class="yiv9809521394MsoNormal"><span lang="EN-US">Rob.</span></div></div></div></div><br>_______________________________________________<br>dev mailing list<br><a ymailto="mailto:dev@openstreetmap.org" href="mailto:dev@openstreetmap.org">dev@openstreetmap.org</a><br><a href="https://lists.openstreetmap.org/listinfo/dev" target="_blank">https://lists.openstreetmap.org/listinfo/dev</a><br><br><br></div> </div> </div>
</div></body></html>