[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:  closed
  Priority:  medium     |  Milestone:  PostGIS 2.3.4
 Component:  postgis    |    Version:  2.3.x
Resolution:  invalid    |   Keywords:
------------------------+---------------------------

Comment (by OlegSerov):

 Let's assume that you are right in the fact that && should somehow work
 differently from "ST_Intersects".

 But there is still an issue with ST_Intersection:
 {{{
 SELECT ST_Intersection(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))')));
 ERROR:  Error performing intersection: TopologyException: Input geom 1 is
 invalid: Self-intersection at or near point -19284319.888845518
 6619014.660591769 at -19284319.888845518 6619014.660591769
 CONTEXT:  SQL function "st_intersection" statement 1

 }}}

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3805#comment:2>
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.