[postgis-users] Multicurve

[Simon (SPDBA) Greener]

Could you not create a table with a generic geometry column without typmodbor constraints? The tell ogr2ogr not to overwrite the extant table?

⁣Sent from BlueMail ​

On 15 Jan. 2019, 11:45, at 11:45, Clifford Snow <clifford at snowandsnow.us> wrote:
>I went back over my efforts to gather all of the Washington State
>counties
>road networks into PostGIS. I was mistaken when I said the problem was
>in
>shapefiles, it turns out I'm seeing multicurves in FileGDB. I apologize
>for
>reporting the problem as a shapefile issue. It's a FileGDB issue.
>
>On to FileGDB. Using King County GIS data as an example, when
>attempting to
>load the data [1] using ogr2ogr, I get an error:
>"Geometry type (MultiCurve) does not match column type
>(MultiLineString)"
>
>The command being used is:
>ogr2ogr -overwrite -f "PostgreSQL" PG:"host=localhost user=user_name
>password=user_password dbname=gisstuff"
>"KingCounty_GDB_transportation.gdb"
>"trans_network_line" -nln test -lco GEOMETRY_NAME=geom
>
>Adding the ogr2ogr option -nlt MULTILINESTRING bring in all of the
>data,
>but it looks like the multicurve has been converted to multilinestring.
>
>I've answered my question by using the -nlt option, but I'm curious, is
>there a way to bring in multicurve geometry into PostGIS from mixed
>data
>like the King County transportation data in [1]?
>
>[1] ftp://ftp.kingcounty.gov/gis-web/GISData/transportationGDB.zip
>
>Again, let me say sorry to jumping to the conclusion I was seeing the
>data
>in shapefiles.
>
>Clifford
>
>-- 
>@osm_seattle
>osm_seattle.snowandsnow.us
>OpenStreetMap: Maps with a human touch
>
>
>------------------------------------------------------------------------
>
>_______________________________________________
>postgis-users mailing list
>postgis-users at lists.osgeo.org
>https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190115/f36d3681/attachment.html>