Re: [postgis-users] Inside / Outside of geography polygons

2019-08-09 Thread Christian Pschierer
Hi Darafei, yes, the MakeBox example was not a good one. Even though the basic question -- which rule determines inside and outside of a large geography polygon -- remains the same. But the problem is a different one: SELECT ST_Dist

[postgis-users] ST_EstimatedExtent and identifier case sensitivity rules

2019-08-09 Thread Mateusz Loskot
Hi, I create a table using: CREATE TABLE "AbCdEfG" (...) I run: SELECT ST_EstimatedExtent('public', 'AbCdEfG', 'g') Using PostGIS 2.1.3, this fails with "public.abcdefg relation does not exist" Using PostGIS 2.5.2, it succeeds. Using 2.1.3, am I just lucky to hit this regression fixed in 2.1

Re: [postgis-users] Inside / Outside of geography polygons

2019-08-09 Thread Komяpa
Hi Christian, To understand the query please try plotting your polygon on a globe and then imagine axis aligned box that will contain it (one side parallel to equator, other parallel to 0 and third to 90th meridian). You will see that your "large" geometry is really 40 degrees wide spot around ant