> On Jan 21, 2019, at 1:46 PM, Simon Greener <si...@spatialdbadvisor.com> wrote: > > Thanks Paul. > > However, I get the same number of distinct st_isvalidreason results.
Something is awry here, because I get only 'Valid Geometry’ as a validity check result… I loaded your shape file, I have 42 irish counties, I didn’t even try to use geography, just used geometry and they are all valid to start with. I can even push them through a couple casts and they remain valid (as I would hope they would, since the coordinates shouldn’t change) select distinct st_isvalidreason(geom::geography::geometry) from county; P > > Is there anything I can do with ogr2ogr when loading to help? > > Simon > > On Tue, 22 Jan 2019 08:34:02 +1100, Paul Ramsey <pram...@cleverelephant.ca> > wrote: > >> +proj=gnom +lat_0=53.35 +lon_0=-6.26 +x_0=0 +y_0=0 +ellps=WGS84 +units=m >> +no_defs > > > -- > 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
