#2294: osm import to postgresql via osm2pgsql with --output=flex option to provide a better table layout -------------------------+------------------------- Reporter: astrid_emde | Owner: osgeolive@… Type: task | Status: new Priority: normal | Milestone: Component: OSGeoLive | Keywords: -------------------------+------------------------- 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 -- Ticket URL: <https://trac.osgeo.org/osgeolive/ticket/2294> OSGeoLive <https://live.osgeo.org/> self-contained bootable DVD, USB thumb drive or Virtual Machine based on Lubuntu, that allows you to try a wide variety of open source geospatial software without installing anything.
_______________________________________________ osgeolive mailing list osgeolive@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/osgeolive