Hi Stefan,
Thank you for your email.
I wrote a bit of code to deal with the three cases found so far, but thought worth bringing up.
Was the 1212 global nodes with image tags? Or just for Europe?
Best regards,
Stuart
On Sun, Jan 19, 2020, 19:21 Stefan Keller sfkeller@gmail.com wrote:
Stuart
I've made a query on my local PG/PostGIS database os OSM Switzerland loaded using osm2pgsql (I call it EOSMDBOne). There I can do queries like "SELECT count(*) FROM osm_point WHERE (tags->'image') ilike 'File:%';"
The total osm_points with image tag was 1212. The majority of image tag values contains 'https://commons.wikimedia.org/wiki/File:...', namely 849. I only found 38 image tags with a value beginning with 'File:'. Tag wikimedia_commons occurs 293 times in osm_points of my db (which is close to taginfo.osm.ch).
So to me that's now a dilemma is to choose between the key "image" with value https://commons.wikimedia.org/wiki/File:...' versus the key "wikimedia_commons" with values either "File:..." or "Category:...".
As a consumer of OSM data I would document and implement both for now.
In any case the wiki page about image [1] is outdated regarding "formatted as File:image.jpg" when saying
a Wikimedia Commons filename (formatted as File:image.jpg) - although
this is commonly tagged as wikimedia_commons=*
:Stefan
[1] https://wiki.openstreetmap.org/wiki/Key:image
Am So., 19. Jan. 2020 um 16:44 Uhr schrieb European Water Project europeanwaterproject@gmail.com:
Hi Andreas,
One more piece of information which you may or may not know or not even
be interested in ::
The d/d5 in the second two urls is the first and second alphanumeric
characters of the md5 hash code of "Drinking_fountain_in_Palmerston_North.jpg" (without the quotes).
Best regards,
Stuart
https://en.wikipedia.org/wiki/MD5
On Sun, 19 Jan 2020 at 15:53, European Water Project <
europeanwaterproject@gmail.com> wrote:
Hi Andreas,
Page url :
https://commons.wikimedia.org/wiki/File:Drinking_fountain_in_Palmerston_Nort...
File url :
https://upload.wikimedia.org/wikipedia/commons/d/d5/Drinking_fountain_in_Pal...
thumbnail url :
https://upload.wikimedia.org/wikipedia/commons/thumb/d/d5/Drinking_fountain_...
Thanks,
Stuart
On Sun, 19 Jan 2020 at 14:03, Andreas Bürki abuerki@anidor.com wrote:
Am 19.01.2020 um 11:00 schrieb European Water Project:
Hello,
I have noticed that the links to images in wikimedia commons for fountain nodes ( but I assume it is the same for other nodes, ways
and
relations) are sometimes saved as the page url, sometimes as the file url and sometimes as a thumbnail image url.
Would it make sense for someone to run a bot and convert all
wikimedia
commons image links to the root image link? Especially the thumbnail image links .. maybe it's not such a big deal.
For example,
https://www.openstreetmap.org/node/6465995645 has image link
https://commons.wikimedia.org/wiki/File:Drinking_fountain_in_Palmerston_Nort...
https://www.openstreetmap.org/node/6431460585 has image link
https://upload.wikimedia.org/wikipedia/commons/5/5c/Israel_Hiking_Map_%D7%91...
https://www.openstreetmap.org/node/286879718 has image link
https://upload.wikimedia.org/wikipedia/commons/thumb/8/86/House_%26_square_o...
Which one is the "root image" link?
cheeers, h.
Best regards,
Stuart
talk-ch mailing list talk-ch@openstreetmap.ch http://lists.openstreetmap.ch/mailman/listinfo/talk-ch
--
Andreas Bürki
abuerki@anidor.com S/MIME certificate - SHA-256 fingerprint:
8A:1A:C2:93:10:4B:CE:91:2C:80:79:44:24:1D:38:CA:EE:0E:89:C9:A5:A4:A0:03:FF:5A:FB:D1:15:18:B5:45
GnuPG - GPG fingerprint: 5DA7 5F48 25BD D2D7 E488 05DF 5A99 A321 7E42 0227
talk-ch mailing list talk-ch@openstreetmap.ch http://lists.openstreetmap.ch/mailman/listinfo/talk-ch
talk-ch mailing list talk-ch@openstreetmap.ch http://lists.openstreetmap.ch/mailman/listinfo/talk-ch
talk-ch mailing list talk-ch@openstreetmap.ch http://lists.openstreetmap.ch/mailman/listinfo/talk-ch