[gdal-dev] ogr2ogr PROMOTE_TO_MULTI with linestrings?

jratike80 jukka.rahkonen at maanmittauslaitos.fi
Mon May 15 23:58:33 PDT 2017

Stephen Woodbridge wrote
> On 5/15/2017 6:15 PM, Stephen Woodbridge wrote:
>> Hi,
>> I'm trying to load both polygons and linestrings and would like 
>> PROMOTE_TO_MULTI to work for both, but it appears to define Multipolygon 
>> type and does not work for linestrings/multilinestrings.
>> Maybe it would make more sense to have:
>> PROMOTE_TO_MULTI - work for either polygon or linestring depending on 
>> what the first object is
>> or have two options like:
>> Or maybe, I'm totally missing something in the docs.
> Sorry, forgot to add:
> ogrinfo --version
> GDAL 2.1.0, released 2016/04/25
> ogr2ogr -t_srs EPSG:4326 -nln census.roads -nlt PROMOTE_TO_MULTI -f 
> PostgreSQL -append PG:dbname=buildings host=localhost port=5432 
> user=postgres active_schema=census 
> /u/ror/buildings/data/census/tmp-11/tl_2016_06061_roads.shp
> Warning 1: Geometry to be inserted is of type Multi Line String, whereas 
> the layer geometry type is Multi Polygon.
> Insertion is likely to fail
> ERROR 1: ERROR:  Geometry type (MultiLineString) does not match column 
> type (MultiPolygon)


Please tell more details about what you plan to do. Shapefile can't contain
a mixture of lines and polygons so the error you get must mean that PostGIS
table "census.roads" already exists and it has been created as MultiPolygon.
Did you convert some polygons from another shapefile into the same table
before? Anyway the restriction is at this stage set by PostGIS which
requires multipolygons and you just can't  convert your lines into

Drop your table and start again by using -nlt GEOMETRY and you should be
fine. That makes the PostGIS table to accept any kind of geometries. If you
definitely need a mixture of MULTIpolygons and MULTIlinestrins we must add
casts somewhere but perhaps that is not what you really want.

-Jukka Rahkonen-

View this message in context: http://osgeo-org.1560.x6.nabble.com/gdal-dev-ogr2ogr-PROMOTE-TO-MULTI-with-linestrings-tp5320602p5320626.html
Sent from the GDAL - Dev mailing list archive at Nabble.com.

More information about the gdal-dev mailing list