[postgis-users] Multicurve

Simon (SPDBA) Greener simon at spatialdbadvisor.com
Mon Jan 14 17:46:06 PST 2019

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
>road networks into PostGIS. I was mistaken when I said the problem was
>shapefiles, it turns out I'm seeing multicurves in FileGDB. I apologize
>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
>The command being used is:
>ogr2ogr -overwrite -f "PostgreSQL" PG:"host=localhost user=user_name
>password=user_password dbname=gisstuff"
>"trans_network_line" -nln test -lco GEOMETRY_NAME=geom
>Adding the ogr2ogr option -nlt MULTILINESTRING bring in all of the
>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
>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
>in shapefiles.
>OpenStreetMap: Maps with a human touch
>postgis-users mailing list
>postgis-users at lists.osgeo.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190115/f36d3681/attachment.html>

More information about the postgis-users mailing list