[postgis-tickets] [PostGIS] #3805: No way to create geography that croses -180..180 (date-line)

[PostGIS]

#3805: No way to create geography that croses -180..180 (date-line)
-----------------------+---------------------------
 Reporter:  OlegSerov  |      Owner:  pramsey
     Type:  defect     |     Status:  new
 Priority:  medium     |  Milestone:  PostGIS 2.3.4
Component:  postgis    |    Version:  2.3.x
 Keywords:             |
-----------------------+---------------------------
 1. Alaska vs alberta:
 SELECT ST_GeogFromText('POLYGON((-116.614 61.7534,-109.804
 61.7534,-109.804 57.5029,-116.614 57.5029,-116.614 61.7534))') &&
 (ST_GeogFromText(' POLYGON((172.347846 71.441059,-173.233993
 71.441059,-158.815832 71.441059,-144.397672 71.441059,-129.979511
 71.441059,-129.979511 51.175092,-144.397672 51.175092,-158.815832
 51.175092,-173.233993 51.175092,172.347846 51.175092,172.347846
 71.441059))'));

 Returns TRUE, should return FALSE;


 2. 2 parts of Alaska vs alberta

 SELECT

 ST_GeogFromText('POLYGON((-116.614 61.7534,-109.804 61.7534,-109.804
 57.5029,-116.614 57.5029,-116.614 61.7534))') &&
 ST_GeogFromText('MULTIPOLYGON(((-179.999990 71.441059,-167.494870
 71.441059,-154.989750 71.441059,-142.484631 71.441059,-129.979511
 71.441059,-129.979511 51.175092,-142.484631 51.175092,-154.989750
 51.175092,-167.494870 51.175092,-179.999990 51.175092,-179.999990
 71.441059)),((172.347846 71.441059,179.999990 71.441059,179.999990
 51.175092,172.347846 51.175092,172.347846 71.441059)))');

 Returns TRUE, should return false


 Version:  PostgreSQL 9.3.17 on x86_64-unknown-linux-gnu, compiled by gcc
 (Ubuntu 4.8.4-2ubuntu1~14.04.3) 4.8.4, 64-bit POSTGIS="2.3.2 r15302"
 GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL
 1.10.1, released 2013/08/26" LIBXML="2.9.1" LIBJSON="0.11.99" RASTER

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3805>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.