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

Cristian Draghici cristian.draghici at gmail.com
Mon Aug 30 16:57:42 BST 2010 

Intelegerea mea pe baza mail-urilor din acest thread a fost ca landuse-ul se
doreste a fi completat din informatii CLC (pentru ca CLC e considerata o
sursa mai corecta pentru landuse).

Ca atare nu am folosit acest tag in importul meu pentru ca-i mult mai greu
sa corectezi automatizat decat sa importi automatizat.

Despre importul CLC sunt ceva date aici:
http://wiki.openstreetmap.org/wiki/Romania_CLC_Import

Toate bune,
Cristi


2010/8/30 Constantin Popescu <popescu.constantin la gmail.com>

> :) Asta stiam, ca m-am uitat deja la tag-ul folosit. Intrebam doar de ce nu
> s-a folosit aceasta metoda ca in toate celelalte tari. In Romania este
> primul loc unde vad aceste limite administrative folosite in modul asta. Si
> de ce in judetul Arad s-a folosit fundalul gri si in celelalte judete nu. Nu
> zic ca e corect sau nu, ca nu ma pricep.
>
> 2010/8/30 alex-map <alea la email.ro>
>
> pentru fundalul gri, este nevoie de folosirea tagului
>> landuse=residential
>>
>> On 30 Aug., 16:50, Constantin Popescu <popescu.constan... la gmail.com>
>> wrote:
>> > Salut.
>> >
>> > As avea si eu o intrebare despre aceste importuri. Asa ar trebui sa
>> arate
>> > aceste limite ? Nu vad in nicio tara sa arate asa. De obicei
>> localitatile au
>> > un fundal gri daca nu ma insel.
>> > Mi se pare si mai estetic cu acel fundal gri. Cel putin in vest unde
>> sunt
>> > multe localitati una langa alta efectul este foarte frumos.
>> > Mai mult, observ ca exista cateva situatii in care exist si fundal gri
>> si
>> > acest contur intererupt de culoare roz(?).
>> > Un import parca din aceeasi sursa dar realizat mai demult, in judetul
>> Arad
>> > s-a facut cu acel fundal gri. De ce s-a trecut la acest contur ?
>> >
>> > Toate cele bune si sper ca nu am suparat pe nimeni, e doar parerea mea
>> > personala.
>> >
>> > 2010/8/30 Cristian Draghici <cristian.dragh... la gmail.com>
>> >
>> > > 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.dragh... 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.dragh... 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 <indre... 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.dragh... la gmail.com>
>> >
>> > >>>>> :-)
>> >
>> > >>>>> Cele cu changeset in tabel sunt deja importate.
>> >
>> > >>>>> --
>> > >>>>> Cristi
>> >
>> > >>>>> 2010/8/25 Ioan Indreias <indre... 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.dragh... 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.dragh... 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_... 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.dragh... la gmail.com>* wrote:
>> >
>> > >>>>>>>>> From: Cristian Draghici <cristian.dragh... la gmail.com>
>> > >>>>>>>>> Subject: Re: [Talk-ro] Import automatizat pentru limita
>> > >>>>>>>>> localitatilor (via cultura.ro)
>> >
>> > >>>>>>>>> To: "OSM Romania" <talk... 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.dragh... la gmail.com<
>> http://mc/compose?to=cristian.dragh...@gmail.com>
>> >
>> > >>>>>>>>> 2010/7/30 Ciprian Talaba <cipriantal... la gmail.com<
>> http://mc/compose?to=cipriantal...@gmail.com>
>> >
>> > >>>>>>>>> Salutare,
>> >
>> > >>>>>>>>> 2010/7/30 Ioan Indreias <indre... la gmail.com<
>> http://mc/compose?to=indre...@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... la openstreetmap.org<
>> http://mc/compose?to=Talk...@openstreetmap.org>
>> > >>>>>>>>>http://lists.openstreetmap.org/listinfo/talk-ro
>> >
>> > >>>>>>>>> _______________________________________________
>> > >>>>>>>>> Talk-ro mailing list
>> > >>>>>>>>> Talk... la openstreetmap.org
>> > >>>>>>>>>http://lists.openstreetmap.org/listinfo/talk-ro
>> >
>> > >>>>>>> _______________________________________________
>> > >>>>>>> Talk-ro mailing list
>> > >>>>>>> Talk... la openstreetmap.org
>> > >>>>>>>http://lists.openstreetmap.org/listinfo/talk-ro
>> >
>> > >>>>>> _______________________________________________
>> > >>>>>> Talk-ro mailing list
>> > >>>>>> Talk... la openstreetmap.org
>> > >>>>>>http://lists.openstreetmap.org/listinfo/talk-ro
>> >
>> > >>>>> _______________________________________________
>> > >>>>> Talk-ro mailing list
>> > >>>>> Talk... la openstreetmap.org
>> > >>>>>http://lists.openstreetmap.org/listinfo/talk-ro
>> >
>> > >>>> _______________________________________________
>> > >>>> Talk-ro mailing list
>> > >>>> Talk... la openstreetmap.org
>> > >>>>http://lists.openstreetmap.org/listinfo/talk-ro
>> >
>> > > _______________________________________________
>> > > Talk-ro mailing list
>> > > Talk... la openstreetmap.org
>> > >http://lists.openstreetmap.org/listinfo/talk-ro
>> >
>> >
>> >
>> > _______________________________________________
>> > Talk-ro mailing list
>> > Talk... la openstreetmap.orghttp://
>> 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/abcc990c/attachment-0001.html>

More information about the Talk-ro mailing list