Error combining LineString and MultiLineString

[rustprooflabs]

Error combining LineString and MultiLineString

[rustprooflabs]

Reported: osm2pgsql-dev/osm2pgsql#1386

[rustprooflabs]

Workaround?

In the meantime this might work as a simple workaround that's easy to undo when the blocking issue is resolved.

In Lua: the tables blocked by this could have two columns, geom and geom2 (horrible name...) with the relation (multilinestring) in geom2. Avoids the conflict at the cost of an additional column and code

In SQL: Create view to using ST_Multi() to combine the two columns for easy querying

[rustprooflabs]

Workaround?

In the meantime this might work as a simple workaround that's easy to undo when the blocking issue is resolved.

In Lua: the tables blocked by this could have two columns, geom and geom2 (horrible name...) with the relation (multilinestring) in geom2. Avoids the conflict at the cost of an additional column and code

In SQL: Create view to using ST_Multi() to combine the two columns for easy querying

Multiple geoms in a single table do not work for this. Attempting to add two geometry columns (one linestring the other multilinestring) results in error from osm2pgsql. On every row, one of the two geometries would be NULL, seems to be the issue.

ERROR: Failed to execute Lua function 'osm2pgsql.process_relation': ./style/road.lua:140: Error in 'add_row': Missing geometry transformation for column 'geom_s'.

Throwing error appears to be intentional, found here: https://github.com/openstreetmap/osm2pgsql/blob/c73c6f13352bc79ad0fcf7142061c012dec3674a/src/output-flex.cpp#L921-L925

[rustprooflabs]

Should be fixed. Need to test and hopefully implement.

osm2pgsql-dev/osm2pgsql#1386 (comment)

Related:

osm2pgsql-dev/osm2pgsql#1736

Multiple geometries mentioned in #2 (comment) also looks to be implemented. osm2pgsql-dev/osm2pgsql#1746. While I'm not concerned with that functionality in this issue, it does open up some interesting opportunities.