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