<div dir="ltr">Köszi<br><br>nekem ez jött ki,ami biztatóan egybevág a tieddel:<div>(sajnos mindet egyesével végig kell nézni, mert van ahol jogosan van ott, de a felével kb már megvagyok)</div><div><br><div>Intersection: wayid: 84034290 polyid: 228345235 https://www.openstreetmap.org/edit?way=84034290</div><div>Intersection: wayid: 93323620 polyid: 122207043 https://www.openstreetmap.org/edit?way=93323620</div><div>Intersection: wayid: 100166364 polyid: 368618789 https://www.openstreetmap.org/edit?way=100166364</div><div>Intersection: wayid: 144011536 polyid: 228348827 https://www.openstreetmap.org/edit?way=144011536</div><div>Intersection: wayid: 172222466 polyid: 228292713 https://www.openstreetmap.org/edit?way=172222466</div><div>Intersection: wayid: 172222468 polyid: 228292713 https://www.openstreetmap.org/edit?way=172222468</div><div>Intersection: wayid: 173076042 polyid: 368618789 https://www.openstreetmap.org/edit?way=173076042</div><div>Intersection: wayid: 173184141 polyid: 368618789 https://www.openstreetmap.org/edit?way=173184141</div><div>Intersection: wayid: 189313296 polyid: 228292713 https://www.openstreetmap.org/edit?way=189313296</div><div>Intersection: wayid: 282710783 polyid: 570085630 https://www.openstreetmap.org/edit?way=282710783</div><div>Intersection: wayid: 296659383 polyid: 464346163 https://www.openstreetmap.org/edit?way=296659383</div><div>Intersection: wayid: 318560658 polyid: 228382739 https://www.openstreetmap.org/edit?way=318560658</div><div>Intersection: wayid: 318560660 polyid: 228382739 https://www.openstreetmap.org/edit?way=318560660</div><div>Intersection: wayid: 318560664 polyid: 228382739 https://www.openstreetmap.org/edit?way=318560664</div><div>Intersection: wayid: 318560665 polyid: 228382739 https://www.openstreetmap.org/edit?way=318560665</div><div>Intersection: wayid: 318560668 polyid: 228382739 https://www.openstreetmap.org/edit?way=318560668</div><div>Intersection: wayid: 318560669 polyid: 228382739 https://www.openstreetmap.org/edit?way=318560669</div><div>Intersection: wayid: 318560670 polyid: 228382739 https://www.openstreetmap.org/edit?way=318560670</div><div>Intersection: wayid: 319257089 polyid: 228354520 https://www.openstreetmap.org/edit?way=319257089</div><div>Intersection: wayid: 328797477 polyid: 328797468 https://www.openstreetmap.org/edit?way=328797477</div><div>Intersection: wayid: 368618784 polyid: 368618789 https://www.openstreetmap.org/edit?way=368618784</div><div>Intersection: wayid: 368618785 polyid: 368618789 https://www.openstreetmap.org/edit?way=368618785</div><div>Intersection: wayid: 383480709 polyid: 383480737 https://www.openstreetmap.org/edit?way=383480709</div><div>Intersection: wayid: 383480711 polyid: 383480737 https://www.openstreetmap.org/edit?way=383480711</div><div>Intersection: wayid: 383480713 polyid: 383480737 https://www.openstreetmap.org/edit?way=383480713</div><div>Intersection: wayid: 383480714 polyid: 383480737 https://www.openstreetmap.org/edit?way=383480714</div><div>Intersection: wayid: 383480716 polyid: 383480737 https://www.openstreetmap.org/edit?way=383480716</div><div>Intersection: wayid: 383480728 polyid: 383480737 https://www.openstreetmap.org/edit?way=383480728</div><div>Intersection: wayid: 386935979 polyid: 475927619 https://www.openstreetmap.org/edit?way=386935979</div><div>Intersection: wayid: 470202881 polyid: 228382926 https://www.openstreetmap.org/edit?way=470202881</div><div>Intersection: wayid: 470202882 polyid: 228382926 https://www.openstreetmap.org/edit?way=470202882</div><div>Intersection: wayid: 472616691 polyid: 563979281 https://www.openstreetmap.org/edit?way=472616691</div><div>Intersection: wayid: 479709468 polyid: 464346163 https://www.openstreetmap.org/edit?way=479709468</div><div>Intersection: wayid: 479709469 polyid: 464346163 https://www.openstreetmap.org/edit?way=479709469</div><div>Intersection: wayid: 484962047 polyid: 484962034 https://www.openstreetmap.org/edit?way=484962047</div><div>Intersection: wayid: 484962048 polyid: 484962034 https://www.openstreetmap.org/edit?way=484962048</div><div>Intersection: wayid: 484962049 polyid: 484962034 https://www.openstreetmap.org/edit?way=484962049</div><div>Intersection: wayid: 485634600 polyid: 485634598 https://www.openstreetmap.org/edit?way=485634600</div><div>Intersection: wayid: 485634605 polyid: 485634606 https://www.openstreetmap.org/edit?way=485634605</div><div>Intersection: wayid: 493329402 polyid: 383480737 https://www.openstreetmap.org/edit?way=493329402</div><div>Intersection: wayid: 493329407 polyid: 383480737 https://www.openstreetmap.org/edit?way=493329407</div><div>Intersection: wayid: 493329409 polyid: 383480737 https://www.openstreetmap.org/edit?way=493329409</div><div>Intersection: wayid: 493329411 polyid: 383480737 https://www.openstreetmap.org/edit?way=493329411</div><div>Intersection: wayid: 493329414 polyid: 383480737 https://www.openstreetmap.org/edit?way=493329414</div><div>Intersection: wayid: 496458234 polyid: 496458236 https://www.openstreetmap.org/edit?way=496458234</div><div>Intersection: wayid: 497953841 polyid: 300580110 https://www.openstreetmap.org/edit?way=497953841</div><div>Intersection: wayid: 515527360 polyid: 243326205 https://www.openstreetmap.org/edit?way=515527360</div><div>Intersection: wayid: 544332716 polyid: 228349044 https://www.openstreetmap.org/edit?way=544332716</div><div>Intersection: wayid: 544332717 polyid: 228349044 https://www.openstreetmap.org/edit?way=544332717</div><div>Intersection: wayid: 544332718 polyid: 228349044 https://www.openstreetmap.org/edit?way=544332718</div><div>Intersection: wayid: 570085629 polyid: 570085630 https://www.openstreetmap.org/edit?way=570085629</div><div>Intersection: wayid: 586095948 polyid: 380378515 https://www.openstreetmap.org/edit?way=586095948</div><div>Intersection: wayid: 586095949 polyid: 380378515 https://www.openstreetmap.org/edit?way=586095949</div><br><br>2018. június 14., csütörtök 16:04:38 UTC+2 időpontban KAMI KAMI a következőt írta:<blockquote class="gmail_quote" style="margin: 0;margin-left: 0.8ex;border-left: 1px #ccc solid;padding-left: 1ex;"><div dir="ltr"><div>Hello,</div><div><br></div><div>Itt egy lista, ami most hirtelen összedobtam, hogy leessen belőle dolgozni, javítani:</div><div><br></div><div>Így állítottam elő a listát:<br>SELECT planet_osm_line.osm_id<br> FROM planet_osm_line, (select * from planet_osm_polygon where landuse='industrial') land<br> WHERE planet_osm_line.access='no' and ST_Contains(land.way, planet_osm_line.way)<br> ORDER BY planet_osm_line.osm_id<br><br></div><div>Példa: <a href="https://www.openstreetmap.org/way/38866991" target="_blank" rel="nofollow" onmousedown="this.href='https://www.google.com/url?q\x3dhttps%3A%2F%2Fwww.openstreetmap.org%2Fway%2F38866991\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNE2qxGR-KKuDbymIal3PJqZ41MnfQ';return true;" onclick="this.href='https://www.google.com/url?q\x3dhttps%3A%2F%2Fwww.openstreetmap.org%2Fway%2F38866991\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNE2qxGR-KKuDbymIal3PJqZ41MnfQ';return true;">https://www.openstreetmap.org/<wbr>way/38866991</a></div><div><br></div><div><br></div><div>38786903</div><div>38866991<br>50564617<br>100166364<br>126986177<br>129490933<br>129490942<br>129490949<br>135931190<br>135931193<br>135931201<br>144011536<br>157690599<br>165273742<br>172222466<br>173076042<br>173184141<br>221059118<br>224524099<br>240859478<br>276431910<br>288461386<br>289623356<br>292619896<br>292619906<br>292619911<br>292619921<br>292619922<br>292712320<br>296659383<br>306171362<br>311596040<br>313831991<br>313831999<br>313832002<br>313832018<br>313835642<br>313843860<br>313844139<br>313844140<br>318560658<br>318560660<br>318560664<br>318560668<br>318785625<br>318785626<br>318785627<br>319257089<br>319797852<br>319797857<br>319797859<br>319797870<br>319797876<br>319797878<br>331753709<br>331753710<br>331753714<br>331753718<br>331753719<br>331753720<br>331753726<br>331753728<br>331753729<br>331753730<br>331753732<br>331753734<br>332555135<br>337796053<br>345466498<br>345466499<br>345466500<br>353726077<br>368618784<br>368618785<br>382010726<br>382010728<br>382010731<br>382010735<br>383480709<br>383480711<br>383480713<br>383480714<br>383480716<br>383480728<br>399308223<br>399308228<br>399308230<br>399308238<br>399308253<br>405942576<br>405942577<br>419181421<br>419181422<br>431467277<br>438388765<br>447918805<br>447918811<br>450506644<br>450506645<br>470202881<br>470202882<br>479709468<br>479709469<br>484962047<br>484962048<br>484962048<br>484962049<br>485634600<br>493329402<br>493329407<br>493329409<br>493329411<br>493329414<br>495699872<br>495699873<br>495699874<br>496458233<br>496458234<br>509766137<br>509766138<br>525310438<br>544332716<br>544332717<br>544332718<br>546687522<br>546687522<br>547529637<br><br><br></div></div><div><br clear="all"><div><div><div dir="ltr">Üdvözlettel / Best Regards:<br><br>Kálmán (KAMI) Szalai<br></div></div></div>
<br><div class="gmail_quote">2018. június 14. 15:22 KAMI911 KAMI911 írta, <span dir="ltr"><<a href="javascript:" target="_blank" gdf-obfuscated-mailto="nxrMMEXuBQAJ" rel="nofollow" onmousedown="this.href='javascript:';return true;" onclick="this.href='javascript:';return true;">kam...@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>Sziasztok,</div><div><br></div><div>Csak a landuse=industrial polygonokban akarjátok ezeket keresni?<br></div></div><div><br clear="all"><div><div><div dir="ltr">Üdvözlettel / Best Regards:<br><br>Kálmán (KAMI) Szalai<br></div></div></div><div><div>
<br><div class="gmail_quote">2018. június 14. 14:28 Zsolt Medgyesi írta, <span dir="ltr"><<a href="javascript:" target="_blank" gdf-obfuscated-mailto="nxrMMEXuBQAJ" rel="nofollow" onmousedown="this.href='javascript:';return true;" onclick="this.href='javascript:';return true;">zmed...@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Jó ötlet. <br>Most egyenlőre irkálok egy saját kis programot, mert viszonylag kevés adatról van szó, de ha a jövőben lesz valami hasonló probléma, akkor szerintem ez lesz.<div><br></div><div>Zsolt<span><br><br>2018. június 14., csütörtök 14:21:56 UTC+2 időpontban Ferenc Veres a következőt írta:<blockquote class="gmail_quote" style="margin:0;margin-left:0.8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
<br>2018.06.14. 13:56 keltezéssel, Zsolt Medgyesi írta:
<br>> A keresésnél én is az Overpass Turbo-val próbálkozta, de egyenlőre
<br>> eredménytelenül (is_in és pivot trükközés). Ha találtam valamit szólok.
<br>
<br>PGSQL?
<br>
<br>(Csak megírni nem tudom a query-t (így hirtelen). Nekem csak olyan van
<br>ami megnézi hogy milyen utcák vannak egy konkrét városban és asszem
<br>Dömcsi írta nekem. Valami hasonló lehet. Persze kicsit hosszú a setup ha
<br>nincs OSM adatbázisod.)
<br>
<br> $query = "SELECT <a href="http://ways.name" rel="nofollow" target="_blank" onmousedown="this.href='http://www.google.com/url?q\x3dhttp%3A%2F%2Fways.name\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNEr3aBaWxvAqwqMjuaYgBGVHXAxwQ';return true;" onclick="this.href='http://www.google.com/url?q\x3dhttp%3A%2F%2Fways.name\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNEr3aBaWxvAqwqMjuaYgBGVHXAxwQ';return true;">ways.name</a> as name,ways.osm_id as osm_id "
<br> . "FROM planet_osm_line ways, planet_osm_polygon polys "
<br> . "WHERE ST_Contains(polys.way, ways.way) "
<br> . "AND ways.highway != '' AND <a href="http://ways.name" rel="nofollow" target="_blank" onmousedown="this.href='http://www.google.com/url?q\x3dhttp%3A%2F%2Fways.name\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNEr3aBaWxvAqwqMjuaYgBGVHXAxwQ';return true;" onclick="this.href='http://www.google.com/url?q\x3dhttp%3A%2F%2Fways.name\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNEr3aBaWxvAqwqMjuaYgBGVHXAxwQ';return true;">ways.name</a> != ''"
<br> . "AND polys.admin_level IN('8','9') "
<br> . "AND <a href="http://polys.name" rel="nofollow" target="_blank" onmousedown="this.href='http://www.google.com/url?q\x3dhttp%3A%2F%2Fpolys.name\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNHsw7svzMRWi1FcIYh-QsXbZEpuWg';return true;" onclick="this.href='http://www.google.com/url?q\x3dhttp%3A%2F%2Fpolys.name\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNHsw7svzMRWi1FcIYh-QsXbZEpuWg';return true;">polys.name</a> = :name";
<br>
<br>(A ":name" egy PHP-PDO-s behelyettesítés a város nevére, a többi sima
<br>PGSQL.)
<br>
<br>Feri
<br>
<br></blockquote></span></div></div><span>
<p></p>
-- <br>
Magyar OSM Levelezőlista - <a href="javascript:" target="_blank" gdf-obfuscated-mailto="nxrMMEXuBQAJ" rel="nofollow" onmousedown="this.href='javascript:';return true;" onclick="this.href='javascript:';return true;">openstreet...@<wbr>googlegroups.com</a><br>
leiratkozás: <a href="javascript:" target="_blank" gdf-obfuscated-mailto="nxrMMEXuBQAJ" rel="nofollow" onmousedown="this.href='javascript:';return true;" onclick="this.href='javascript:';return true;">openstreetmap-hungary+<wbr>unsubscribe@googlegroups.com</a><br>
--- <br></span>
Azért kapta ezt az üzenetet, mert feliratkozott a Google Csoportok „openstreetmap-hungary” csoportjára.<span><br>
Az erről a csoportról és az ahhoz kapcsolódó e-mailekről való leiratkozáshoz küldjön egy e-amailt a(z) <a href="javascript:" target="_blank" gdf-obfuscated-mailto="nxrMMEXuBQAJ" rel="nofollow" onmousedown="this.href='javascript:';return true;" onclick="this.href='javascript:';return true;">openstreetmap-hungary+<wbr>unsubscribe@googlegroups.com</a> címre.<br></span>
További lehetőségekért látogasson el ide: <a href="https://groups.google.com/d/optout" target="_blank" rel="nofollow" onmousedown="this.href='https://groups.google.com/d/optout';return true;" onclick="this.href='https://groups.google.com/d/optout';return true;">https://groups.google.com/d/<wbr>optout</a>.<br>
</blockquote></div><br></div></div></div>
</blockquote></div><br></div>
</blockquote></div></div>