I'll do some more checks to see if ogr2ogr really is the problem. Simon Sent from BlueMail
On 22 Jan. 2019, 15:22, at 15:22, Martin Davis <mtncl...@gmail.com> wrote: >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
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
