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 <cliff...@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@lists.osgeo.org >https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
