[postgis-users] Geography/geometry

[Paul Ramsey]

> On Jan 21, 2019, at 1:46 PM, Simon Greener <simon at 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 <pramsey at 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: simon at 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