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

alex-map alea at email.ro
Mon Aug 30 16:06:30 BST 2010


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



More information about the Talk-ro mailing list