[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