Opened 3 years ago

Last modified 3 years ago

#2294 new task

osm import to postgresql via osm2pgsql with --output=flex option to provide a better table layout

Reported by: astrid_emde Owned by: osgeolive@…
Priority: normal Milestone:
Component: OSGeoLive Keywords:
Cc:

Description

With the script load_postgis.sh we import the osm data to PostgreSQL see

https://github.com/OSGeo/OSGeoLive/blob/master/bin/load_postgis.sh#L104

From osm2pgsql 1.3.0 version there is a new mode for export that is very flexible and the new way to use osm2pgsql (--output=flex) see

https://osm2pgsql.org/doc/manual.html#the-flex-output

We could use this flex mode for the osm data import. This would enable us to provide tables that have a more reasonable layout.

Here you can find some lua configuration file examples: https://github.com/openstreetmap/osm2pgsql/tree/master/flex-config

We would have to discuss whether this is a good change and see which other projects/quickstarts are effected. I guess it is a milestone for OSGeoLive 15

Change history (1)

comment:1 by darkblueb, 3 years ago

one piece of wisdom here may be " Create what the rendering/querying engine expects"

Note: See TracTickets for help on using tickets.