[postgis-devel] [PostGIS] #1610: Support for larger objects in ST_Intersection(geography)

PostGIS trac at osgeo.org
Thu Feb 23 22:15:04 PST 2012


#1610: Support for larger objects in ST_Intersection(geography)
---------------------------+------------------------------------------------
 Reporter:  realityexists  |       Owner:  pramsey      
     Type:  enhancement    |      Status:  new          
 Priority:  medium         |   Milestone:  PostGIS 2.0.0
Component:  postgis        |     Version:  trunk        
 Keywords:                 |  
---------------------------+------------------------------------------------
 Please enhance ST_Intersection(geography) and ST_Intersects(geography) to
 handle larger shapes than they currently support and shapes touching the
 poles by internally transforming to a Gnomic projection as necessary. A
 simple test case:


 {{{
 WITH data AS
 (
     SELECT ST_GeogFromText('POLYGON((170 50,170 72,-130 72,-130 50,170
 50))') AS poly1,
         ST_GeogFromText('POLYGON((-170 68,-170 90,-141 90,-141 68,-170
 68))') AS poly2
 )
 SELECT ST_AsText(ST_Intersection(poly1, poly2))
 FROM data
 }}}

 Expected result: POLYGON((-170 74.053793645338,-141 73.4268621378904,-141
 68,-170 68,-170 74.053793645338))

 Current result: POLYGON((-130 58.1309106133234,-130
 65.0979231965232,-86.8913306802836 49.9999999999887,-104.762597274101
 49.9999999999887,-130 58.1309106133234))

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1610>
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.


More information about the postgis-devel mailing list