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

Cristian Draghici cristian.draghici at gmail.com
Mon Aug 30 15:31:31 BST 2010


Azi: Caras
Severin, Buzau, Brasov, Galati, Vrancea, Timis, Sibiu, Covasna,
Hunedoara, Alba, Bacau,
Vaslui.

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

Salutari
--
Cristi

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

> 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/20100830/ff268b6a/attachment.html>


More information about the Talk-ro mailing list