[OSM-talk] An open letter to OSMF board members.

Hartmut Holzgraefe hartmut at php.net
Mon Jun 6 14:35:57 UTC 2022


On 06.06.22 14:35, ndrw6 wrote:
> but historically any changes to these tables they were difficult to deploy

to get even more off-topic: the "historically" part needs to be stressed 
here. When you have enough storage space to share you can do an 
osm2pgsql import using --hstore-all --hstore-only and then add views 
that present the imported data with "virtual" columns as individual 
styles expect.

I copied this approach from the German fork of the CartoOSM style, and 
I'm able to render some 30+ different base styles and almost 20 
different overlays from a single osm2pgsql import that way.

Whenever a specific style adds a new column I can easily recreate the 
views without having to re-import the actual tables.

This requires some 1TB of disk space for the hstore-all data plus 
indexes for a full planet database, but that's not an unrealistic 
storage side for any serious server anymore I'd say ...

 > The style is global, which mean it does not adapts to regional 
tagging conventions.
[...]
 > However, the same zoom level means very different things in Norway 
and in Singapore.
[...]
 >  A small object in the middle of the field can by a landmark, yet in 
the middle of city centers we want to be much more selective

now here things get more interesting ... here some meta data like 
"population density" (would most likely require an external data source, 
although some guesses could be made from building and road density?) and 
"POI / feature density" could be added as an extra data source that 
could be folded into SQL queries or with a little extra code work even 
into Mapnik itself?

And no, I don't have a clear concept or plan for this, just 
brainstorming for now ...

-- 
hartmut



More information about the talk mailing list