[postgis-users] Multicurve

Clifford Snow clifford at snowandsnow.us
Mon Jan 14 16:44:42 PST 2019


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190114/7730c2b1/attachment.html>


More information about the postgis-users mailing list