<!DOCTYPE html><html><head>
<style type="text/css">body { font-family:'Times New Roman'; font-size:13px}</style>
</head>
<body><div>Thanks.</div><div><br></div><div>I couldn't see how this would help as this is structural not mathematical.</div><div><br></div><div>But I am trying to bring the parts back together.</div><div><br></div><div><br></div><div>S</div><div>On Tue, 22 Jan 2019 10:01:36 +1100, Martin Davis <mtnclimb@gmail.com> wrote:<br></div><br><blockquote style="margin: 0 0 0.80ex; border-left: #0000FF 2px solid; padding-left: 1ex"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div>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]</div><div><br></div><div>[1] <a href="https://www.gdal.org/ogr2ogr.html">https://www.gdal.org/ogr2ogr.html</a></div><div>[2] <a href="https://gis.stackexchange.com/a/195223">https://gis.stackexchange.com/a/195223</a></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Jan 21, 2019 at 1:00 PM Simon Greener <<a href="mailto:simon@spatialdbadvisor.com">simon@spatialdbadvisor.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div><div>The shapefile (from OSM) can be accessed here:</div><div><br></div><div><a href="https://www.dropbox.com/s/jbptp3ycmc8cqzi/gis_osm_county_a_free_1.rar?dl=0" target="_blank">https://www.dropbox.com/s/jbptp3ycmc8cqzi/gis_osm_county_a_free_1.rar?dl=0</a></div><div><br></div><div>The command used to load is:</div><div><br></div><div>ogr2ogr -overwrite -progress -skipfailures -a_srs "EPSG:4326" ^<br> -f "PostgreSQL" PG:"dbname='gisdb' host='localhost' port='5432' user='postgres' ^<br> gis_osm_county_a_free_1.shp -nln data.osm_county -nlt POLYGON ^<br> -lco LAUNDER=YES -lco GEOMETRY_NAME=geog4326 -lco GEOM_TYPE=geography -lco FID=ID -lco DIM=2 -lco SPATIAL_INDEX=YES <br></div><div><br></div><div>Am I missing something with the ogr2ogr command for the load?</div><div><br></div><div><br></div></div></blockquote></div></div></div></div>
</blockquote><br><br><br><div id="M2Signature"><div>-- </div><div><div>Regards<br></div><div><font face="Kunstler Script"><big><big><big><big>Simon</big></big></big></big></font><em><strong><br></strong></em></div><div><em><strong>--------------------------------------------------------------------------------------------------------<br></strong></em></div><div><em><strong>Spatial Advice & Solutions Architecture<br>Database Spatial Stored Procedure Designer</strong></em><br>Oracle Spatial, SQL Server, PostGIS, MySQL, ArcSDE FME<br>Awarded "2011 Oracle Spatial Excellence Award for Education and Research"<br>A: 39 Cliff View Drive, Allens Rivulet, 7150, Tas, Aust<br>W: www.spdba.com.au<br>E: simon@spdba.com.au<br>V: +61 <strong>362 396 397</strong><br>M: +61 <strong>418 396 391</strong><br>GITC Supplier: T1005<br>Skype: sggreener<br>Long: 147.20515 (147° 12' 18" E)<br>Lat: -43.01530 (43° 00' 55" S)<br>GeoHash: r22em9r98wg<br>NAC:W80CK 7SWP3</div></div></div></body></html>