Thanks. I couldn't see how this would help as this is structural not mathematical.
But I am trying to bring the parts back together. S On Tue, 22 Jan 2019 10:01:36 +1100, Martin Davis <mtncl...@gmail.com> wrote:
Could the problem be the use of the ogr2ogr option -nlt POLYGON ? Some of the input geometries are multipolygons, and it sounds like the way to >handle this with ogr2ogr is to use GEOMETRY or PROMOTE_TO_MULTI [1][2] [1] https://www.gdal.org/ogr2ogr.html [2] https://gis.stackexchange.com/a/195223 On Mon, Jan 21, 2019 at 1:00 PM Simon Greener <si...@spatialdbadvisor.com> wrote:The shapefile (from OSM) can be accessed here: https://www.dropbox.com/s/jbptp3ycmc8cqzi/gis_osm_county_a_free_1.rar?dl=0 The command used to load is: ogr2ogr -overwrite -progress -skipfailures -a_srs "EPSG:4326" ^ -f "PostgreSQL" PG:"dbname='gisdb' host='localhost' port='5432' user='postgres' ^ gis_osm_county_a_free_1.shp -nln data.osm_county -nlt POLYGON ^ -lco LAUNDER=YES -lco GEOMETRY_NAME=geog4326 -lco GEOM_TYPE=geography -lco FID=ID -lco DIM=2 -lco SPATIAL_INDEX=YES Am I missing something with the ogr2ogr command for the load?
-- Regards Simon -------------------------------------------------------------------------------------------------------- Spatial Advice & Solutions Architecture Database Spatial Stored Procedure Designer Oracle Spatial, SQL Server, PostGIS, MySQL, ArcSDE FME Awarded "2011 Oracle Spatial Excellence Award for Education and Research" A: 39 Cliff View Drive, Allens Rivulet, 7150, Tas, Aust W: www.spdba.com.au E: si...@spdba.com.au V: +61 362 396 397 M: +61 418 396 391 GITC Supplier: T1005 Skype: sggreener Long: 147.20515 (147° 12' 18" E) Lat: -43.01530 (43° 00' 55" S) GeoHash: r22em9r98wg NAC:W80CK 7SWP3
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
