Salut<div><br></div><div>Am importat limitele localitatilor din Teleorman pe baza datelor din <a 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 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 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 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="gmail_quote">
2010/7/30 Cristian Draghici <span dir="ltr"><<a href="mailto:cristian.draghici@gmail.com">cristian.draghici@gmail.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<br><br><div class="gmail_quote"><div class="im">2010/7/30 Ciprian Talaba <span dir="ltr"><<a href="mailto:cipriantalaba@gmail.com" target="_blank">cipriantalaba@gmail.com</a>></span><br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Salutare,<div class="im"><br><br><div class="gmail_quote">2010/7/30 Ioan Indreias <span dir="ltr"><<a href="mailto:indreias@gmail.com" target="_blank">indreias@gmail.com</a>></span><div><br><blockquote class="gmail_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="gmail_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>