osmium-tool VS OSMExpress

Yes, among other things, you can filter data by tags with the Osmium Tool

Try the osmium command line tool which can filter and convert OSM data.

You can skip the PostGIS step with Osmium:

For OSM there’s a bunch of tools, for example https://github.com/osmcode/osmium-tool, but searching for venues is maybe better done with https://overpass-turbo.eu/

Hi, the value add in the commercial offering is described here:

https://protomaps.com/docs/faq#openstreetmap

I also maintain open source tooling for anyone to replicate and consume all of OSM, as well as a free download portal:

https://github.com/protomaps/OSMExpress

https://app.protomaps.com/downloads

I work a lot with OSM data, and never loaded into PostgreSql… On one project I keep data in https://github.com/protomaps/OSMExpress, another I keep it in .pbf and just handle minutely changes in memory, then even for PostgreSql there are multiple schema tables each optimized for different work, render server schema is very different from API server…

You did not specify what kind of filtering you want to do, but if you are after area extracts like whole cities or similar, best thing is OSMExpress unfortunatly it takes long time to initialize it for whole planet, but after that extracts are done in seconds.

The major open source component that runs on the server (https://github.com/protomaps/OSMExpress) is tricky to package because it depends on S2 Geometry, which itself has some tough dependencies; the users I know out there are compiling it themselves, or using the community-contributed Dockerfile. I would prefer a .deb, do you think a PPA is the right approach?