<div dir="ltr">Sziasztok!<br><br>Páran már ismertek, de azt hiszem ez az első levelem a csoportba, úgyhogy kezdem egy kis bemutatkozással.<br>Fehérváron
 földmérőként, majd az ELTÉn térképészként végeztem, azóta pedig a 
KSH-ban vagyok térinformatikus, a térstatisztikai rendszer 
fejlesztésében veszek részt. OSM-et eddig nagyon koca módon 
szerkesztgettem: ha valami durva hibát találtam, belenyúltam 1-2 helyen.<br><br>Az aktuális problémám: szükségem lenne egy Magyarország közigazgatási határai (település) térképre Esri shape-ben (.shp).<br><b>Lehet, hogy elbonyolítottam, várom az ötleteket.</b><br>Kis
 keresgélés után az tűnt a legegyszerűbbnek, ha a kérésemet beírom az 
overpass-ba, az eredményt meg QGIS-ben átalakítom shp-be.<br><br>Kis tanulással erre jutottam:<br><div class="prettyprint" style="background-color: rgb(250, 250, 250); border-color: rgb(187, 187, 187); border-style: solid; border-width: 1px; word-wrap: break-word;"><code class="prettyprint"><div class="subprettyprint"><span style="color: #800;" class="styled-by-prettify">// Magyarország települései</span><span style="color: #000;" class="styled-by-prettify"><br><br></span><span style="color: #660;" class="styled-by-prettify">[</span><span style="color: #000;" class="styled-by-prettify">bbox</span><span style="color: #660;" class="styled-by-prettify">:</span><span style="color: #066;" class="styled-by-prettify">45.7</span><span style="color: #660;" class="styled-by-prettify">,</span><span style="color: #066;" class="styled-by-prettify">16.1</span><span style="color: #660;" class="styled-by-prettify">,</span><span style="color: #066;" class="styled-by-prettify">48.6</span><span style="color: #660;" class="styled-by-prettify">,</span><span style="color: #066;" class="styled-by-prettify">23</span><span style="color: #660;" class="styled-by-prettify">];</span><span style="color: #000;" class="styled-by-prettify"><br></span><span style="color: #660;" class="styled-by-prettify">(</span><span style="color: #000;" class="styled-by-prettify"><br>  node<br>      </span><span style="color: #660;" class="styled-by-prettify">[</span><span style="color: #080;" class="styled-by-prettify">"ksh_ref"</span><span style="color: #660;" class="styled-by-prettify">]</span><span style="color: #000;" class="styled-by-prettify"><br>     </span><span style="color: #660;" class="styled-by-prettify">[</span><span style="color: #080;" class="styled-by-prettify">"is_in:subregion"</span><span style="color: #660;" class="styled-by-prettify">!=</span><span style="color: #080;" class="styled-by-prettify">"Budapesti"</span><span style="color: #660;" class="styled-by-prettify">];</span><span style="color: #000;" class="styled-by-prettify"><br></span><span style="color: #660;" class="styled-by-prettify">);</span><span style="color: #000;" class="styled-by-prettify"><br></span><span style="color: #660;" class="styled-by-prettify">(</span><span style="color: #000;" class="styled-by-prettify"><br>  rel</span><span style="color: #660;" class="styled-by-prettify">(</span><span style="color: #000;" class="styled-by-prettify">bn</span><span style="color: #660;" class="styled-by-prettify">)</span><span style="color: #000;" class="styled-by-prettify"><br>    </span><span style="color: #660;" class="styled-by-prettify">[</span><span style="color: #080;" class="styled-by-prettify">"boundary"</span><span style="color: #660;" class="styled-by-prettify">=</span><span style="color: #080;" class="styled-by-prettify">"administrative"</span><span style="color: #660;" class="styled-by-prettify">]</span><span style="color: #000;" class="styled-by-prettify"><br>    </span><span style="color: #660;" class="styled-by-prettify">[</span><span style="color: #080;" class="styled-by-prettify">"admin_level"</span><span style="color: #660;" class="styled-by-prettify">=</span><span style="color: #080;" class="styled-by-prettify">"8"</span><span style="color: #660;" class="styled-by-prettify">]</span><span style="color: #000;" class="styled-by-prettify"><br></span><span style="color: #660;" class="styled-by-prettify">);</span><span style="color: #000;" class="styled-by-prettify"><br></span><span style="color: #660;" class="styled-by-prettify">(.</span><span style="color: #000;" class="styled-by-prettify">_</span><span style="color: #660;" class="styled-by-prettify">;>;);</span><span style="color: #000;" class="styled-by-prettify"><br></span><span style="color: #008;" class="styled-by-prettify">out</span><span style="color: #660;" class="styled-by-prettify">;</span></div></code></div><br>illetve kerületekkel:<br><div class="prettyprint" style="background-color: rgb(250, 250, 250); border-color: rgb(187, 187, 187); border-style: solid; border-width: 1px; word-wrap: break-word;"><code class="prettyprint"><div class="subprettyprint"><code class="prettyprint"><span style="color: #800;" class="styled-by-prettify">// Magyarország települései</span><span style="color: #000;" class="styled-by-prettify"> Bp. kerületeivel<br></span></code><span style="color: #660;" class="styled-by-prettify">[</span><span style="color: #000;" class="styled-by-prettify">bbox</span><span style="color: #660;" class="styled-by-prettify">:</span><span style="color: #066;" class="styled-by-prettify">45.7</span><span style="color: #660;" class="styled-by-prettify">,</span><span style="color: #066;" class="styled-by-prettify">16.1</span><span style="color: #660;" class="styled-by-prettify">,</span><span style="color: #066;" class="styled-by-prettify">48.6</span><span style="color: #660;" class="styled-by-prettify">,</span><span style="color: #066;" class="styled-by-prettify">23</span><span style="color: #660;" class="styled-by-prettify">];</span><span style="color: #000;" class="styled-by-prettify"><br></span><span style="color: #660;" class="styled-by-prettify">(</span><span style="color: #000;" class="styled-by-prettify"><br>  node<br>      </span><span style="color: #660;" class="styled-by-prettify">[</span><span style="color: #080;" class="styled-by-prettify">"ksh_ref"</span><span style="color: #660;" class="styled-by-prettify">]</span><span style="color: #000;" class="styled-by-prettify"><br>     </span><span style="color: #660;" class="styled-by-prettify">[</span><span style="color: #080;" class="styled-by-prettify">"name"</span><span style="color: #660;" class="styled-by-prettify">!=</span><span style="color: #080;" class="styled-by-prettify">"Budapest"</span><span style="color: #660;" class="styled-by-prettify">];</span><span style="color: #000;" class="styled-by-prettify"><br></span><span style="color: #660;" class="styled-by-prettify">)->.</span><span style="color: #000;" class="styled-by-prettify">kp</span><span style="color: #660;" class="styled-by-prettify">;</span><span style="color: #000;" class="styled-by-prettify"><br></span><span style="color: #660;" class="styled-by-prettify">(</span><span style="color: #000;" class="styled-by-prettify"><br>  rel</span><span style="color: #660;" class="styled-by-prettify">(</span><span style="color: #000;" class="styled-by-prettify">bn</span><span style="color: #660;" class="styled-by-prettify">.</span><span style="color: #000;" class="styled-by-prettify">kp</span><span style="color: #660;" class="styled-by-prettify">)</span><span style="color: #000;" class="styled-by-prettify"><br>    </span><span style="color: #660;" class="styled-by-prettify">[</span><span style="color: #080;" class="styled-by-prettify">"boundary"</span><span style="color: #660;" class="styled-by-prettify">=</span><span style="color: #080;" class="styled-by-prettify">"administrative"</span><span style="color: #660;" class="styled-by-prettify">]</span><span style="color: #000;" class="styled-by-prettify"><br>    </span><span style="color: #660;" class="styled-by-prettify">[</span><span style="color: #080;" class="styled-by-prettify">"admin_level"</span><span style="color: #660;" class="styled-by-prettify">=</span><span style="color: #080;" class="styled-by-prettify">"8"</span><span style="color: #660;" class="styled-by-prettify">];</span><span style="color: #000;" class="styled-by-prettify"><br>  rel</span><span style="color: #660;" class="styled-by-prettify">(</span><span style="color: #000;" class="styled-by-prettify">bn</span><span style="color: #660;" class="styled-by-prettify">.</span><span style="color: #000;" class="styled-by-prettify">kp</span><span style="color: #660;" class="styled-by-prettify">)</span><span style="color: #000;" class="styled-by-prettify"><br>    </span><span style="color: #660;" class="styled-by-prettify">[</span><span style="color: #080;" class="styled-by-prettify">"boundary"</span><span style="color: #660;" class="styled-by-prettify">=</span><span style="color: #080;" class="styled-by-prettify">"administrative"</span><span style="color: #660;" class="styled-by-prettify">]</span><span style="color: #000;" class="styled-by-prettify"><br>    </span><span style="color: #660;" class="styled-by-prettify">[</span><span style="color: #080;" class="styled-by-prettify">"admin_level"</span><span style="color: #660;" class="styled-by-prettify">=</span><span style="color: #080;" class="styled-by-prettify">"9"</span><span style="color: #660;" class="styled-by-prettify">]</span><span style="color: #000;" class="styled-by-prettify"><br></span><span style="color: #660;" class="styled-by-prettify">);</span><span style="color: #000;" class="styled-by-prettify"><br></span><span style="color: #660;" class="styled-by-prettify">(.</span><span style="color: #000;" class="styled-by-prettify">_</span><span style="color: #660;" class="styled-by-prettify">;>;);</span><span style="color: #000;" class="styled-by-prettify"><br></span><span style="color: #008;" class="styled-by-prettify">out</span><span style="color: #660;" class="styled-by-prettify">;</span></div></code></div>Közben kipucoltam a ksh_ref-tag-et az adatbázisban, és pár településnek igyekeztem helyre rázni a középpontját (admin_center)<br><br>Tisztább lenne a letöltött OSM forrás, ha<br><div class="prettyprint" style="background-color: rgb(250, 250, 250); border-color: rgb(187, 187, 187); border-style: solid; border-width: 1px; word-wrap: break-word;"><code class="prettyprint"><div class="subprettyprint"><code class="prettyprint"><span style="color: #660;" class="styled-by-prettify">(.</span><span style="color: #000;" class="styled-by-prettify">_</span><span style="color: #660;" class="styled-by-prettify">;>;);</span><span style="color: #000;" class="styled-by-prettify"><br></span></code><span style="color: #660;" class="styled-by-prettify"></span></div></code></div>helyett használhatnám az<br><div class="prettyprint" style="background-color: rgb(250, 250, 250); border-color: rgb(187, 187, 187); border-style: solid; border-width: 1px; word-wrap: break-word;"><code class="prettyprint"><div class="subprettyprint"><span style="color: #606;" class="styled-by-prettify">out geom;</span><span style="color: #660;" class="styled-by-prettify"></span></div></code></div>parancsot, mert ekkor csak a poligonok jönnének le, nem az összes way, node minden adatukkal. <b>De ezt nem nyitotta meg a QGIS. Ezzel van valakinek tapasztalata?</b><br><br>Sajnos a határoknak csak nevük van, a ksh_ref az admin_center node-on van.<br>Ezért letöltöttem egy táblázatot is név-ksh_ref kapcsolathoz:<br><div class="prettyprint" style="background-color: rgb(250, 250, 250); border-color: rgb(187, 187, 187); border-style: solid; border-width: 1px; word-wrap: break-word;"><code class="prettyprint"><div class="subprettyprint"><span style="color: #606;" class="styled-by-prettify">[out:csv(::id,"name","ksh_ref")];<br>(<br>  node<br>      ["ksh_ref"]<br>);<br><br>out;</span><span style="color: #660;" class="styled-by-prettify"></span></div></code></div><br>QGIS-be betöltöttem az osm-et, hozzákapcsoltam a csv-t, és az eredményt elmentettem shp-be.<br>Azonban még mindig pár problémám:<br><ol><li>Gadács
 bent van Somogyszilen belül, és valamiért kétszer van meg a poligonja -
 azon túl, hogy Somogyszil szépen lyukas, ahogy kell. Persze kézzel 
tudom törölni, de jó lenne már jól leszedni, ha lehetséges.<br></li><li>Kőszegszerdahely területe negatív lett, amikor kiszámoltattam a QGIS-szel.</li><li>Ezen kívül van kb. 30 település, aminek a területe több mint 10%-kal eltér a hivatalostól, de ezt majd egy másik posztba teszem.<br></li></ol>Szóval
 jó lenne valami egyszerű mód, amivel elő tudok állítani poligon shp-et,
 ami tartalmazza az admin_level=8 (esetleg 9 - Bp kerületei) határokat, 
és a ksh_ref-eket is. Van ötletetek?<br><br>Tudom, hogy durva lett, remélem sikerül vele megszólítanom a célközönséget. :)<br><br>-- <br> Iván<br><br><br><mytubeelement data="{"bundle":{"label_delimitor":":","percentage":"%","smart_buffer":"Smart Buffer","start_playing_when_buffered":"Start playing when buffered","sound":"Sound","desktop_notification":"Desktop Notification","continuation_on_next_line":"-","loop":"Loop","only_notify":"Only Notify","estimated_time":"Estimated Time","global_preferences":"Global Preferences","no_notification_supported_on_your_browser":"No notification style supported on your browser version","video_buffered":"Video Buffered","buffered":"Buffered","hyphen":"-","buffered_message":"The video has been buffered as requested and is ready to play.","not_supported":"Not Supported","on":"On","off":"Off","click_to_enable_for_this_site":"Click to enable for this site","desktop_notification_denied":"You have denied permission for desktop notification for this site","notification_status_delimitor":";","error":"Error","adblock_interferance_message":"Adblock (or similar extension) is known to interfere with SmartVideo. Please add this url to adblock whitelist.","calculating":"Calculating","waiting":"Waiting","will_start_buffering_when_initialized":"Will start buffering when initialized","will_start_playing_when_initialized":"Will start playing when initialized","completed":"Completed","buffering_stalled":"Buffering is stalled. Will stop.","stopped":"Stopped","hr":"Hr","min":"Min","sec":"Sec","any_moment":"Any Moment","popup_donate_to":"Donate to","extension_id":null},"prefs":{"desktopNotification":true,"soundNotification":false,"logLevel":0,"enable":true,"loop":false,"hidePopup":false,"autoPlay":false,"autoBuffer":false,"autoPlayOnBuffer":false,"autoPlayOnBufferPercentage":42,"autoPlayOnSmartBuffer":true,"quality":"medium","fshd":false,"onlyNotification":false,"enableFullScreen":true,"saveBandwidth":false,"hideAnnotations":true,"turnOffPagedBuffering":false}}" event="preferencesUpdated" id="myTubeRelayElementToPage"></mytubeelement><mytubeelement data="{"loadBundle":true}" event="relayPrefs" id="myTubeRelayElementToTab"></mytubeelement></div>