[Tile-serving] [osm2pgsql-dev/osm2pgsql] osm2pgsql to pmtiles / Looking for a simple way to generate community map and data projects (Discussion #2463)

[Tobias]

> The goal of osm2pgsql is to import OSM data into a postgis database and keep it updated.

Part of this discussion is to challenge and evolve this framing. I am quite sure that the community is looking for a solution for the cases described; and we can either evolve existing tools or build new once… – Both is fine; lets talk about both.

> If your ideal setup doesn't have a database and you're only after daily updates, why are you starting with osm2pgsql?

As you said, the tooling osm2pgsql provides is great. Personally I spend a lot of time learning it. It would be great to be able to start a project with the same tooling and return pmtiles and be able to transition to rending from DB (eg. when more .sql is needed) and then to minutely updates at some point, when needed. It would allow projects to transition more easily from an experiment to a production ready app.

> You certainly can create an osm2pgsql database and export a planet's worth of vector tiles…

It would be great if we shared more about the process for this: How?…

> …, but why?

I tried to explain that above. Pmtiles opens up hosting vector data to a whole new user group with much lower cost and especially much simpler – just one file vs. managing servers.

> It's going to take much longer than a setup optimized for generating the planet like tilemaker or planetiler.

One key difference to me is: For now, those apps are focussed on generating data optimized for the usage on a map style. However, IMO the big advantage of osm2pgsql today is that it does this but also provides a way to export opinionated OSM data. Which is something that I hope many of those coming topic based OSM data processing pipelines will provide. Not just show data but also allow exporting/using them as cleaned and processed OSM data. https://en.osm.town/@tordans/112637637684642696 has a few quotes on this topic which I find myself getting back to again and again.

For example: https://radinfra.de/ is great to show processed bike infrastructure data from OSM. But the export (which in our case is not public) just as or more valuable. Same for https://www.osm-verkehrswende.org/cqi/map/?anzeige=cqi&map=14.9%2F52.4989%2F13.4166&filters=usable-yes where the visual map is just one thing, but the exported, processed data would be just as useful for analysis and routing use cases.


-- 
Reply to this email directly or view it on GitHub:
https://github.com/osm2pgsql-dev/osm2pgsql/discussions/2463#discussioncomment-16485866
You are receiving this because you are subscribed to this thread.

Message ID: <osm2pgsql-dev/osm2pgsql/repo-discussions/2463/comments/16485866 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20260408/b1bdc3d8/attachment-0001.htm>