[OSM-dev] osm2pgsql: avoid addition to planet_osm_point when importing ways?

Stefan Keller sfkeller at gmail.com
Sun Sep 27 15:24:41 UTC 2015

Hi Kai and Paul, dear all

Is there a solution to configure or lua-script osm2pgsql to populate
osm_points only with nodes which onle have "user defined" tags (i.e.
no osm_timestamp,osm_changeset,osm_version,osm_uid)?

This would cut down the no. rows in table osm_point about ten times

And: I can't imagine who needs these "way supporting" coordinates
there (since there's osm_nodes).
Does anybody know?


2013-09-15 21:09 GMT+02:00 Kai Krueger <kakrueger at gmail.com>:
> Nick Whitelegg-2 wrote
>> Is there a way to tell osm2pgsql to *only* import the ways into
>> planet_osm_line and not put anything into planet_osm_point at all?
> One option is to use the lua tag processing features. That gives you a lot
> of flexibility in determining what to import into the database.
> It mostly allows you to transform tags, e.g. for normalisation, but it also
> allows you to filter based on tags which objects are added to the rendering
> tables (and if they should be treated as polygons or lines)
> If you don't want any points in your rendering tables, then you can simple
> make the lua function "filter_tag_nodes" (
> https://github.com/openstreetmap/osm2pgsql/blob/master/style.lua#L71 )
> return 1. In this case all nodes get discarded from the points table.
> Kai
> --
> View this message in context: http://gis.19327.n5.nabble.com/osm2pgsql-avoid-addition-to-planet-osm-point-when-importing-ways-tp5777583p5777678.html
> Sent from the Developer Discussion mailing list archive at Nabble.com.
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> https://lists.openstreetmap.org/listinfo/dev

More information about the dev mailing list