[Talk-ro] Import automatizat pentru limita localitatilor (via cultura.ro)

Ioan Indreias indreias at gmail.com
Wed Aug 25 15:49:25 BST 2010


sure - acum am vazut - in chrome cache-ul e foarte "naravas" - dupa un
refresh am vazut actualizarile tale.
thx.

2010/8/25 Cristian Draghici <cristian.draghici la gmail.com>

> :-)
>
> Cele cu changeset in tabel sunt deja importate.
>
> --
> Cristi
>
>
> 2010/8/25 Ioan Indreias <indreias la gmail.com>
>
> excelent - as sugera sa numim judetele care au fost importate de tine cu
>> "Teleorman - done (diciu)" iar pentru judetele care au fost deja importate
>> sa incercam sa gasim "user-ul OSM" si sa-l marcam ca atare.
>>
>> sau ceva similar, ca sa vedem cum merge progresul acestui import.
>>
>> Nini
>>
>>
>> 2010/8/25 Cristian Draghici <cristian.draghici la gmail.com>
>>
>>> O sa tin evidenta importului aici:
>>>
>>> http://wiki.openstreetmap.org/wiki/Import_www.cultura.ro
>>>
>>> --
>>> Cristi
>>>
>>>
>>>
>>> 2010/8/25 Cristian Draghici <cristian.draghici la gmail.com>
>>>
>>> Salut
>>>>
>>>> Am continuat cu limitele localitatilor din Giurgiu.
>>>>
>>>> Changeset-ul este:
>>>> http://www.openstreetmap.org/browse/changeset/5589673
>>>>
>>>> Am exclus din import localitatile existente din judet: (Daia,
>>>> Dobreni,Giurgiu, Grădiștea, Mogoșești, Prundu, Valea
>>>> Dragului, Vărăști, Varlaam).
>>>>
>>>> Toate bune,
>>>> --
>>>> Cristi
>>>>
>>>> 2010/8/24 Razvan Preda <rap_raz la yahoo.com>
>>>>
>>>> putea sa le imorti si pe acelea, pt comuna zambreasca vreau sa spun ca
>>>>> am folosit imaginile yahoo.
>>>>>
>>>>> Razvan Preda
>>>>>
>>>>> --- On *Tue, 8/24/10, Cristian Draghici <cristian.draghici la gmail.com>*wrote:
>>>>>
>>>>>
>>>>> From: Cristian Draghici <cristian.draghici la gmail.com>
>>>>> Subject: Re: [Talk-ro] Import automatizat pentru limita localitatilor
>>>>> (via cultura.ro)
>>>>>
>>>>> To: "OSM Romania" <talk-ro la openstreetmap.org>
>>>>> Date: Tuesday, August 24, 2010, 3:12 PM
>>>>>
>>>>>
>>>>> Salut
>>>>>
>>>>> Am importat limitele localitatilor din Teleorman pe baza datelor din
>>>>> cultura.ro (exceptand pe cele deja existente -> Alexandria, Peretu,
>>>>> Buzescu, Zambreasca, Rosiorii de Vede).
>>>>>
>>>>> Changeset-ul e aici:
>>>>> http://www.openstreetmap.org/browse/changeset/5578846
>>>>>
>>>>>
>>>>> Modalitatea de operare:
>>>>> - pentru fiecare contur din cultura.ro se obtine nume
>>>>> - se localizeaza POI-ul corespondent in OSM (cautare fara diacritice
>>>>> pentru nume in acelasi judet)
>>>>> - se iau atributele din POI (nume cu diacritice corecte, siruta:code)
>>>>> - se cauta un poligon (planet_osm_polygon) pentru acelasi nume in judet
>>>>> (e.g. pentru eliminare Alexandria care fusese deja desenata in Teleorman)
>>>>> - daca se gaseste duplicat poligonul e abandonat si se pastreaza datele
>>>>> existente
>>>>> - daca nu, se creaza un nou poligon la care se adauga name, place_name,
>>>>> admin_level, boundary pe baza conturului din cultura.ro.
>>>>>
>>>>>
>>>>> Astept comentarii, opinii, sugestii, etc.
>>>>>
>>>>> Multumesc,
>>>>> Cristi
>>>>>
>>>>> PS daca e cazul de revert, nu ma deranjeaza - dar user-ul meu nu are
>>>>> acces pentru revert.
>>>>>
>>>>>
>>>>>
>>>>> 2010/7/30 Cristian Draghici <cristian.draghici la gmail.com<http://mc/compose?to=cristian.draghici@gmail.com>
>>>>> >
>>>>>
>>>>>
>>>>>
>>>>> 2010/7/30 Ciprian Talaba <cipriantalaba la gmail.com<http://mc/compose?to=cipriantalaba@gmail.com>
>>>>> >
>>>>>
>>>>> Salutare,
>>>>>
>>>>>
>>>>> 2010/7/30 Ioan Indreias <indreias la gmail.com<http://mc/compose?to=indreias@gmail.com>
>>>>> >
>>>>>
>>>>> Salut Ciprian,
>>>>>
>>>>> Atata timp cat importul CLC nu afecteaza poligoane marcate cu tag-ul
>>>>> boundary sau place este foarte bine.
>>>>>
>>>>>
>>>>> Cat timp acestea nu au si landuse=* nu ar trebuie sa fie probleme.
>>>>>
>>>>>
>>>>> In plus importul CLC ar trebui sa evite modificarea poligoanelor care
>>>>> au tag-ul "name" sau "place_name" (nu ne dorim sa devina invizibile).
>>>>>
>>>>>
>>>>> 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.
>>>>>
>>>>>
>>>>>  Sunt destul de multe (1550).
>>>>> Asta pentru ca in importul Arad, etc s-a folosit landuse=residential.
>>>>>
>>>>>
>>>>> 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;
>>>>>   osm_id  | boundary |  place  |    name     | place_name |   landuse
>>>>>
>>>>>
>>>>> ----------+----------+---------+-------------+------------+-------------
>>>>>  45422508 |          | town    |             | Nădlac     | residential
>>>>>  26411049 |          |         | Checea      |            | residential
>>>>>  45422894 |          | village |             | Șeitin     | residential
>>>>>  47717690 |          | village | Peregu Mare |            | residential
>>>>>  47717688 |          | village | Semlac      |            | residential
>>>>>  25189409 |          |         | Bobda       |            | residential
>>>>>  22723543 |          | village | Satu Mare   |            | residential
>>>>>  22723542 |          | village | Secusigiu   |            | residential
>>>>>  26410987 |          |         | Dinias      |            | residential
>>>>>  45422506 |          | village |             | Munar      | residential
>>>>> (10 rows)
>>>>>
>>>>> 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;
>>>>>  count
>>>>> -------
>>>>>   1550
>>>>> (1 row)
>>>>>
>>>>> --
>>>>> Cristi
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> -----Inline Attachment Follows-----
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> Talk-ro mailing list
>>>>> Talk-ro la openstreetmap.org<http://mc/compose?to=Talk-ro@openstreetmap.org>
>>>>> http://lists.openstreetmap.org/listinfo/talk-ro
>>>>>
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> Talk-ro mailing list
>>>>> Talk-ro la openstreetmap.org
>>>>> http://lists.openstreetmap.org/listinfo/talk-ro
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>> _______________________________________________
>>> Talk-ro mailing list
>>> Talk-ro la openstreetmap.org
>>> http://lists.openstreetmap.org/listinfo/talk-ro
>>>
>>>
>>
>> _______________________________________________
>> Talk-ro mailing list
>> Talk-ro la openstreetmap.org
>> http://lists.openstreetmap.org/listinfo/talk-ro
>>
>>
>
>
>
> _______________________________________________
> Talk-ro mailing list
> Talk-ro la openstreetmap.org
> http://lists.openstreetmap.org/listinfo/talk-ro
>
>
-------------- partea urm�toare --------------
Un ata�ament HTML a fost eliminat   
URL: <http://lists.openstreetmap.org/pipermail/talk-ro/attachments/20100825/93f56e66/attachment.html>


More information about the Talk-ro mailing list