You could use -nlt geometry but that won't convert simple objects to multi objects. You could do it in steps:
1. use -where to get lines and -nlt MultiLine 2. use -where to get polys with -nlt MutliPolygon 3. combine the two tables into a single Geometry table Rich On Mon, May 15, 2017 at 6:25 PM, Stephen Woodbridge <[email protected] > 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: >> >> PROMOTE_POLY_TO_MULTI >> PROMOTE_LINE_TO_MULTI >> >> 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/t > mp-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) > > > > --- > This email has been checked for viruses by Avast antivirus software. > https://www.avast.com/antivirus > > _______________________________________________ > gdal-dev mailing list > [email protected] > https://lists.osgeo.org/mailman/listinfo/gdal-dev > -- Richard W. Greenwood, PLS www.greenwoodmap.com
_______________________________________________ gdal-dev mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/gdal-dev
