Perhaps log this as an OGR issue [1]? Probably need to bisect the problem a bit more though (e.g. reduce the input to a single failing polygon).
[1] https://github.com/OSGeo/gdal/issues On Mon, Jan 21, 2019 at 7:06 PM Simon Greener <si...@spatialdbadvisor.com> wrote: > I replaced the shapefile load script dropping ogr2ogr in favor of > shp2pgshp. > > This appears to have given me clean multipolygons as nothing was reported > by the following: > > select ST_ISValidReason(a.geog4326::geometry) > from data.osm_county as a > where ST_IsValidReason(a.geog4326::geometry) <> 'Valid Geometry' > > I discovered though this process that the original shapefile had 10 > counties that were duplicated. > I used postgresql to delete the duplicates. > > All my SQL appears to be working. > > Perhaps Martin is right: there is something wrong with the ogr2ogr load > (though I switched from -nlt POLYGON to -nlt PROMOTE_TO_MULTI and it didn't > make any difference). > > I think this request for help can now be closed. > > Thanks to all. > > regards > Simon > > > > Just ’select geom’ will return the extended hexwkb (which we should have > JTS support as a matter of convenience). If you need pure standard hex wkb, > then > > select encode(st_asbinary(geom), ‘hex’) > > will do that > > P > > On Jan 21, 2019, at 2:39 PM, Martin Davis <mtncl...@gmail.com> wrote: > > Not much help, I'm afraid. I need the geometry in WKBHex. Not sure > offhand how to get that out of PostGIS. > > Just post the WKT and let's see what that looks like. > > On Mon, Jan 21, 2019 at 1:52 PM Simon Greener <si...@spatialdbadvisor.com> > wrote: > >> Try here for an example: >> >> https://www.dropbox.com/s/n234bc6i5hj7y4o/Ireland.sql?dl=0 >> > _______________________________________________ > postgis-users mailing list > postgis-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/postgis-users > > > > > > -- > Regards > Simon > > > *--------------------------------------------------------------------------------------------------------* > > *Spatial Advice & Solutions ArchitectureDatabase 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
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
