[kawsper]

I’ve started playing with data from OpenStreetMap. It started with me trying to fetch all the places where I could get water when moving around Copenhagen, which turned out not to be as easy as first envisioned, because OSM seems to have a lot of different ways to categorise available water, which makes sense, OSM and the tagging system isn't there to support only my usecase, and describing my idea doesn't fit 1:1 with the model.

I identified the following tags to look out for:

amenity=drinking_water, https://wiki.openstreetmap.org/wiki/Tag:amenity%3Ddrinking_w...

man_made=water_tap, https://wiki.openstreetmap.org/wiki/Tag:man_made%3Dwater_tap

amenity=water_point, https://wiki.openstreetmap.org/wiki/Tag:amenity%3Dwater_poin...

drinking_water=*, https://wiki.openstreetmap.org/wiki/Key:drinking_water

It's a tough problem to map out the world and describe it, especially when everyone can add or modify the data, but anything that could improve the experience of importing like osm2pgsql would be welcome.

[Aachen]

I don't understand how this doesn't fit your use case. The tags are for different things, e.g.

> for places where you can get larger amounts of "drinking water" for filling a fresh water holding tank, such as found on caravans, RVs and boats

versus

> a man-made construction providing access to water, supplied by centralized water distribution system (unlike in case of man_made=water_well [...]). The tag man_made=water_tap is used for publicly usable water taps, such as those in the cities and graveyards. Water taps may provide potable and technical water, which can be specified with drinking_water=yes and drinking_water=no.

And another tag for when you're not mapping a separate water point, but indicating whether a given feature has drinking water (for example a well or mountain hut).

You're saying that it's tough when anyone can mess with the data rather than working in a structured way, but these tags have distinct definitions and seem perfectly sensible to me (there are much worse examples like highway=track, which spawned huge discussions in various places within the community). How do these tags not match your use case to select which tags you need and display those in the way you want (e.g. as list or map)?

[francisofascii]

When features are sometimes tagged specifically and other times tagged more generically, it is impossible to get valid results. You either have to filter on the more specific tag (leaving out valid features) or include the generic tagged features (including features that should not be).

[matkoniecz]

In this case it should not be a problem - listing mapped places suitable to get drinking water is quite reasonable here.

[francisofascii]

Not really. Sometimes you specifically want a water fountain where the water shoots upwards. Not a faucet.

[Aachen]

If only we paid people to map everything to the detail you specifically need. I've never seen a public faucet that does what you describe, only in American movies in high schools (so those aren't public and most mappers won't know they're there or, even if, you wouldn't be allowed to use it as a non-student). I'm not sure the tagging scheme is the problem here: even if you'd enforce using the right tag by giving everyone mandatory training and exams so they tag everything perfectly, you'd not get this sort of detail necessarily, at least not without doubling the number of contributors as compared to today. (And that's from a German/Dutch perspective, countries which are already pretty well-mapped. In Belgium you probably need to quadruple the force or more.)

[matkoniecz]

then exclude `man_made=water_tap`

in this case extreme fragmentation of tagging is actually useful

[jmkb]

You missed (at least) one: https://wiki.openstreetmap.org/wiki/Tag:man_made%3Ddrinking_...

[snickerer]

I spent 20 months of my life traveling around Europe and Asia and I found the sources to fill up my camper's water tank mostly using OSM data! It works very well in most areas.

I used the the app Maps.me for that (which by the way I would not recommend anymore). Maps.me's internal search function is not intuitive but I found out the right key words to get to drinking water sources.

To your list I would add the search for springs. Especially in mountainous areas you often find usable springs (sometimes pipes coming out of a wall) with drinking water.

[matkoniecz]

> I used the the app Maps.me for that (which by the way I would not recommend anymore).

Organic Maps is its successor - https://organicmaps.app/