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

Cristian Draghici cristian.draghici at gmail.com
Fri Aug 27 16:50:58 BST 2010


Astazi Mehedinti, Gorj, Dambovita, Prahova, Braila, Tulcea, Arges.

http://wiki.openstreetmap.org/wiki/Import_www.cultura.ro

Salutari
--
Cristi

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

> 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/20100827/8b0b9551/attachment.html>


More information about the Talk-ro mailing list