<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">putea sa le imorti si pe acelea, pt comuna zambreasca vreau sa spun ca am folosit imaginile yahoo.<br><br>Razvan Preda<br><br>--- On <b>Tue, 8/24/10, Cristian Draghici <i><cristian.draghici@gmail.com></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From: Cristian Draghici <cristian.draghici@gmail.com><br>Subject: Re: [Talk-ro] Import automatizat pentru limita localitatilor (via cultura.ro)<br>To: "OSM Romania" <talk-ro@openstreetmap.org><br>Date: Tuesday, August 24, 2010, 3:12 PM<br><br><div id="yiv629694550">Salut<div><br></div><div>Am importat limitele localitatilor din Teleorman pe baza datelor din <a rel="nofollow" target="_blank" href="http://cultura.ro">cultura.ro</a> (exceptand pe cele deja existente -> Alexandria, Peretu, Buzescu, Zambreasca, Rosiorii de
Vede).</div>
<div><br></div><div>Changeset-ul e aici:</div><div><a rel="nofollow" target="_blank" href="http://www.openstreetmap.org/browse/changeset/5578846">http://www.openstreetmap.org/browse/changeset/5578846</a></div><div><br></div><div><br></div><div>Modalitatea de operare:</div>
<div>- pentru fiecare contur din <a rel="nofollow" target="_blank" href="http://cultura.ro">cultura.ro</a> se obtine nume</div><div>- se localizeaza POI-ul corespondent in OSM (cautare fara diacritice pentru nume in acelasi judet)</div><div>- se iau atributele din POI (nume cu diacritice corecte, siruta:code)</div>
<div>- se cauta un poligon (planet_osm_polygon) pentru acelasi nume in judet (e.g. pentru eliminare Alexandria care fusese deja desenata in Teleorman)</div><div>- daca se gaseste duplicat poligonul e abandonat si se pastreaza datele existente</div>
<div>- daca nu, se creaza un nou poligon la care se adauga name, place_name, admin_level, boundary pe baza conturului din <a rel="nofollow" target="_blank" href="http://cultura.ro">cultura.ro</a>.</div><div><br></div><div><br></div><div>Astept comentarii, opinii, sugestii, etc.</div>
<div><br></div><div>Multumesc,</div><div>Cristi</div><div><br></div><div>PS daca e cazul de revert, nu ma deranjeaza - dar user-ul meu nu are acces pentru revert.</div><div><br></div><div><br></div><div><br><div class="yiv629694550gmail_quote">
2010/7/30 Cristian Draghici <span dir="ltr"><<a rel="nofollow" ymailto="mailto:cristian.draghici@gmail.com" target="_blank" href="/mc/compose?to=cristian.draghici@gmail.com">cristian.draghici@gmail.com</a>></span><br><blockquote class="yiv629694550gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<br><br><div class="yiv629694550gmail_quote"><div class="yiv629694550im">2010/7/30 Ciprian Talaba <span dir="ltr"><<a rel="nofollow" ymailto="mailto:cipriantalaba@gmail.com" target="_blank" href="/mc/compose?to=cipriantalaba@gmail.com">cipriantalaba@gmail.com</a>></span><br></div><blockquote class="yiv629694550gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Salutare,<div class="yiv629694550im"><br><br><div class="yiv629694550gmail_quote">2010/7/30 Ioan Indreias <span dir="ltr"><<a rel="nofollow" ymailto="mailto:indreias@gmail.com" target="_blank" href="/mc/compose?to=indreias@gmail.com">indreias@gmail.com</a>></span><div><br><blockquote class="yiv629694550gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Salut Ciprian,<div><br></div><div>Atata timp cat importul CLC nu afecteaza poligoane marcate cu tag-ul boundary sau place este foarte bine.</div><div><br></div></blockquote></div><div><br>Cat timp acestea nu au si landuse=* nu ar trebuie sa fie probleme.<br>
</div><div><blockquote class="yiv629694550gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div></div><div>In plus importul CLC ar trebui sa evite modificarea poligoanelor care au tag-ul "name" sau "place_name" (nu ne dorim sa devina invizibile).</div>
</blockquote></div><div><br>Trebuie sa facem un inventar al poligoanelor cu name sau place_name si care au landuse=* (cel mai probabil residential) si sa tragem niste concluzii.<br></div></div></div></blockquote><div><br>
</div>
<div>Sunt destul de multe (1550).</div><div>Asta pentru ca in importul Arad, etc s-a folosit landuse=residential.</div><div><br></div><div><font face="'courier new', monospace"><br></font></div>
<div><font face="'courier new', monospace">openmapdb=# select osm_id, boundary, place, name, place_name, landuse from planet_osm_polygon where (boundary is not null or place is not null or name is not null) and landuse is not null limit 10;</font></div>
<div><font face="'courier new', monospace"> osm_id | boundary | place | name | place_name | landuse </font></div><div><font face="'courier new', monospace">----------+----------+---------+-------------+------------+-------------</font></div>
<div><font face="'courier new', monospace"> 45422508 | | town | | Nădlac | residential</font></div><div><font face="'courier new', monospace"> 26411049 | | | Checea | | residential</font></div>
<div><font face="'courier new', monospace"> 45422894 | | village | | Șeitin | residential</font></div><div><font face="'courier new', monospace"> 47717690 | | village | Peregu Mare | | residential</font></div>
<div><font face="'courier new', monospace"> 47717688 | | village | Semlac | | residential</font></div><div><font face="'courier new', monospace"> 25189409 | | | Bobda | | residential</font></div>
<div><font face="'courier new', monospace"> 22723543 | | village | Satu Mare | | residential</font></div><div><font face="'courier new', monospace"> 22723542 | | village | Secusigiu | | residential</font></div>
<div><font face="'courier new', monospace"> 26410987 | | | Dinias | | residential</font></div><div><font face="'courier new', monospace"> 45422506 | | village | | Munar | residential</font></div>
<div><font face="'courier new', monospace">(10 rows)</font></div><div><font face="'courier new', monospace"><br></font></div><div><font face="'courier new', monospace">openmapdb=# select count(*) from planet_osm_polygon where (boundary is not null or place is not null or name is not null) and landuse is not null;</font></div>
<div><font face="'courier new', monospace"> count </font></div><div><font face="'courier new', monospace">-------</font></div><div><font face="'courier new', monospace"> 1550</font></div>
<div><font face="'courier new', monospace">(1 row)</font></div><div><br></div><font color="#888888"><div>--</div><div>Cristi</div></font></div>
</blockquote></div><br><br>
</div>
</div><br>-----Inline Attachment Follows-----<br><br><div class="plainMail">_______________________________________________<br>Talk-ro mailing list<br><a ymailto="mailto:Talk-ro@openstreetmap.org" href="/mc/compose?to=Talk-ro@openstreetmap.org">Talk-ro@openstreetmap.org</a><br><a href="http://lists.openstreetmap.org/listinfo/talk-ro" target="_blank">http://lists.openstreetmap.org/listinfo/talk-ro</a><br></div></blockquote></td></tr></table><br>