osmtogeojson VS overpass-turbo

no suggestions on how to deal with the file size, but I image the issue with method #1 is that Overpass/OSM JSON is not GeoJSON. You'd want to find or create a python implementation of osmtogeojson https://github.com/tyrasd/osmtogeojson (this is what overpass-turbo uses to generate the GeoJSON you're downloading form it)

Suuure... where are you in Germany?

https://overpass-turbo.eu , the sample query is already for drinking fountains. I navigated so Berlin is on the map and clicked Run, and it shows me all drinking water fountains on the map. A few of them even have image links, for example: https://imgur.com/d6UheOw

In overpass the query to do is 'craft=brewery'.

http://overpass-turbo.eu/

With mapbox, this is probably not too hard to create, though I have never worked with mapbox.

If you're interested in mapping infrastructure, you may like Overpass Turbo.

It maps all kinds of stuff, selectable via queries, such as water fountains, parking lots, etc. I've always thought it could come in handy during times of emergency, such as if FEMA needed to inform citizens of certain resources in their vicinities.

https://overpass-turbo.eu/

Example 1] - Defaults to amenity=bottled_water -- Search & select "San Francisco" and click "Run" (Click "Load" for other demo options.)

[Example 2] - Parking lots in SF https://help.openstreetmap.org/questions/67865/overpass-turb...

Example 3] - Go back to the default example of bottled water: click "Load" --> select the "bottled_water" example. Now change [amenity=drinking_water] to ["shop"="butcher"]

[Example 4] - Multiple nodes, as categories of suppliers -- Paste this into the Overpass console: https://pastebin.com/Q4X2YPvj to see nodes where shop=butcher, farm, agrarian, greengrocer

More info on this QueryLanguage / API docs:

https://wiki.openstreetmap.org/wiki/Key:shop#Supplementary_t...

https://wiki.openstreetmap.org/wiki/Overpass_API/Overpass_QL

Map courtesy of overpass-turbo.eu

OpenStreetMap can be queried with a regex, so here's places in Wales where the Welsh name is only the top row: https://overpass-turbo.eu/?w=(name:cy~/^[qwertyuiop]*$/i)%20...

There's four: a hamlet named Treopert, a mountain range in Snowdonia named Eryri, a house in Bangor University named after that mountain range, and TUI outdoor shop.