[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