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
