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_North.jpg
>>
>> File url :
>> https://upload.wikimedia.org/wikipedia/commons/d/d5/Drinking_fountain_in_Palmerston_North.jpg
>>
>> thumbnail url :
>> https://upload.wikimedia.org/wikipedia/commons/thumb/d/d5/Drinking_fountain_in_Palmerston_North.jpg/360px-Drinking_fountain_in_Palmerston_North.jpg
>>
>> 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_North.jpg
>>> >
>>> > https://www.openstreetmap.org/node/6431460585
>>> > has image link
>>> > https://upload.wikimedia.org/wikipedia/commons/5/5c/Israel_Hiking_Map_%D7%91%D7%A8%D7%96_%D7%9E%D7%99%D7%9D_1.jpeg
>>> >
>>> >
>>> > https://www.openstreetmap.org/node/286879718
>>> > has image link
>>> > https://upload.wikimedia.org/wikipedia/commons/thumb/8/86/House_%26_square_of_parliament_%283625514675%29.jpg/800px-House_%26_square_of_parliament_%283625514675%29.jpg
>>>
>>>
>>>
>>> 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