Hoi,
made a script to add new name:XX values to Openstreetmap using wikipedia links from OSM and interlanguage links from Wikipedias.
-> http://toolserver.org/~kentaur/osm_wp/show_osm_wp.php
Currently it can be used for 4 target languages: English, German, Russian and Estonian.
Source is at https://svn.toolserver.org/svnroot/kentaur/php/osm_wp/
-- Raul
Nice, one comment: I think we name:xx only if it's different from from name-Value. So e.g. for name="Bundesstraße 455" we don't need name:de="Bundesstraße 455"
Or do you know, why you have for http://www.openstreetmap.org/browse/relation/59464 no OSM-name in your table?
Greetings Tim
Zitat von Raul Kern raunator@gmail.com:
Hoi,
made a script to add new name:XX values to Openstreetmap using wikipedia links from OSM and interlanguage links from Wikipedias.
-> http://toolserver.org/~kentaur/osm_wp/show_osm_wp.php
Currently it can be used for 4 target languages: English, German, Russian and Estonian.
Source is at https://svn.toolserver.org/svnroot/kentaur/php/osm_wp/
-- Raul
Maps-l mailing list Maps-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/maps-l
Currently using planet_point, planet_line and planet_polygon to search for wikipedia tags.
osm_mapnik=> SELECT osm_id, name FROM planet_line WHERE osm_id=-59464 LIMIT 1; osm_id | name --------+------ -59464 |
I'll add planet_rels to the search.
-- Raul
2012/1/27 Tim Alder tim.alder@s2002.tu-chemnitz.de:
Nice, one comment: I think we name:xx only if it's different from from name-Value. So e.g. for name="Bundesstraße 455" we don't need name:de="Bundesstraße 455"
Or do you know, why you have for http://www.openstreetmap.org/browse/relation/59464 no OSM-name in your table?
Greetings Tim
Zitat von Raul Kern raunator@gmail.com:
Hoi,
made a script to add new name:XX values to Openstreetmap using wikipedia links from OSM and interlanguage links from Wikipedias.
-> http://toolserver.org/~kentaur/osm_wp/show_osm_wp.php
Currently it can be used for 4 target languages: English, German, Russian and Estonian.
Source is at https://svn.toolserver.org/svnroot/kentaur/php/osm_wp/
-- Raul
Maps-l mailing list Maps-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/maps-l
Maps-l mailing list Maps-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/maps-l
Am 27.01.2012 14:08, schrieb Raul Kern:
Hoi,
Hi
made a script to add new name:XX values to Openstreetmap using wikipedia links from OSM and interlanguage links from Wikipedias.
I like it, but IÄve some questions: - does the generated .osc-file only contain the items I personally marked as okay or all changes marked by anyone? How can I upload changes made by others under my username without violating the license? Would be better to couple it with a session, so only my own changes are uploaded by me. - Why do you display items where the proposed name:xx tag is identical to the existing name-tag? - Would you mind adding a not-okay button, which hides the item (at least for my session)? - How often is the list updated
Thank you for building and publishing that tool. If you put a Flattr button on it, I'll give you some Cents ;)
Peter
2012/1/30 Peter Körner osm-lists@mazdermind.de:
- Would you mind adding a not-okay button, which hides the item (at least for my session)?
Yep, this would be a good addition. Maybe it could also accumulate those negative votes and hide them eternally once a threshold is reached.
Cheers Colin
2012/1/30 Peter Körner osm-lists@mazdermind.de:
I like it, but IÄve some questions: - does the generated .osc-file only contain the items I personally marked as okay or all changes marked by anyone? How can I upload changes made by others under my username without violating the license? Would be better to couple it with a session, so only my own changes are uploaded by me.
It's now session based.
- Why do you display items where the proposed name:xx tag is identical to the existing name-tag?
Those shouldn't be displayed.
- Would you mind adding a not-okay button, which hides the item (at least for my session)?
Will add it later.
- How often is the list updated
The OSM wikipedia links and interlanguage links are fetched weekly.
______
I wonder why osm_id and tags don't match in planet_polygon:
osm_mapnik=> SELECT osm_id, name, tags->'wikipedia' AS wikipedia FROM planet_polygon WHERE osm_id=-1685716; osm_id | name | wikipedia ----------+-------+----------- -1685716 | Utøya | Utøya (1 row)
As if these name and wikipedia tags belong to relation 1685716. Whereas they are actually properities of way 4171584 (http://www.openstreetmap.org/browse/relation/1685716, http://www.openstreetmap.org/browse/way/4171584)
How should I then query for wikipedia tags from this OSM database?
-- Raul
Hi
I wonder why osm_id and tags don't match in planet_polygon:
osm_mapnik=> SELECT osm_id, name, tags->'wikipedia' AS wikipedia FROM planet_polygon WHERE osm_id=-1685716; osm_id | name | wikipedia ----------+-------+----------- -1685716 | Utøya | Utøya (1 row)
As if these name and wikipedia tags belong to relation 1685716. Whereas they are actually properities of way 4171584 (http://www.openstreetmap.org/browse/relation/1685716, http://www.openstreetmap.org/browse/way/4171584)
Because you're querying a rendering-database which is preprocessed in order to prduce good rendering results ans -times. One of te preprocessing steps taken is, in the polygon-build phase, "if the relation does not have any interesting tags, copy them from the outer way". This may be wrong or right in the sense of how Relations are defined (there are different definitions for that, btw.), but it's just how our impiorter handles it.
Refer to http://wiki.openstreetmap.org/wiki/Relation:multipolygon#Tagging for one of the definitions.
Peter
BTW: I increase the speed of my add-tags-tool for adding name:XX and Wikipedia-Tags to places. The tool ask now directly Nominatim if the Parameter "types" is "no".
Different tools for the same job.
Greetings Tim
Example (Municipalities of Saxony): http://toolserver.org/~kolossos/osm-add-tags/index.php?lang=de&bbox=11%2...
Project page: http://wiki.openstreetmap.org/wiki/JOSM/Plugins/RemoteControl/Add-tags
Am 27.01.2012 14:08, schrieb Raul Kern:
Hoi,
made a script to add new name:XX values to Openstreetmap using wikipedia links from OSM and interlanguage links from Wikipedias.
-> http://toolserver.org/~kentaur/osm_wp/show_osm_wp.php
Currently it can be used for 4 target languages: English, German, Russian and Estonian.
Source is at https://svn.toolserver.org/svnroot/kentaur/php/osm_wp/
-- Raul
Maps-l mailing list Maps-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/maps-l
message got stuck in the mailing list as I posted using wrong sender. Sorry for late reply, still maybe an open issue.
Stephan Knauss writes:
Hi Raul,
Raul Kern writes:
made a script to add new name:XX values to Openstreetmap using wikipedia links from OSM and interlanguage links from Wikipedias.
Personally I see no problem here. But OSM is sometimes more strict. Wikipedia is CC-BY-SA which is no compatible source for OSM as it requires the derived work be CC as well. With the license change to ODbL this is not possible.
It all depends whether a bulk import of names from Wikipedia into OSM is considered a derived work.
Please clarify with OSM on legal-talk before investing a lot of effort that would later need to be reverted.
Hope it works because I'm a big fan of the name:xx tags and I would love to have this for other languages as well.
Stephan
Am 30.01.2012 21:41, schrieb Stephan Knauss:
Hi Raul, Raul Kern writes:
made a script to add new name:XX values to Openstreetmap using wikipedia links from OSM and interlanguage links from Wikipedias.
Personally I see no problem here. But OSM is sometimes more strict. Wikipedia is CC-BY-SA which is no compatible source for OSM as it requires the derived work be CC as well. With the license change to ODbL this is not possible. It all depends whether a bulk import of names from Wikipedia into OSM is considered a derived work. Please clarify with OSM on legal-talk before investing a lot of effort that would later need to be reverted. Hope it works because I'm a big fan of the name:xx tags and I would love to have this for other languages as well. Stephan
We had a discussion about this topic on legal-talk last April: http://lists.openstreetmap.org/pipermail/legal-talk/2011-April/005907.html
So nobody answer me there with arguments for a problem.
Greetings Kolossos