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

Cristian Draghici cristian.draghici at gmail.com
Thu Aug 26 14:53:06 BST 2010


Salut

Am adaugat localitati din: Calarasi, Dolj, Constanta, Ialomita, Olt.

Changeset-urile aici:
http://wiki.openstreetmap.org/wiki/Import_www.cultura.ro

Toate bune,
--
Cristi

2010/8/25 Ioan Indreias <indreias la gmail.com>

> 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
>>
>>
>
> _______________________________________________
> 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/20100826/01148ba8/attachment.html>


More information about the Talk-ro mailing list