[postgis-users] ST_Intersects

Mahesh Ghule mahesh.ghule at gmail.com
Mon Jun 13 06:54:46 PDT 2011


Hello Guys,

After lot of head scratching I have decided to post this email.
We have a PostGIS 1.5.1 on PostgreSQL 8.4

*select
ST_AsText('0105000020E6100000010000000102000000020000009FAEEE586C8C5240029CDEC5FBF94D406B44300E2EDB5140D591239D81D14C40'::geography)
as TextFootPrint,*
*
 ST_Intersects('0105000020E6100000010000000102000000020000009FAEEE586C8C5240029CDEC5FBF94D406B44300E2EDB5140D591239D81D14C40'::geography,
ST_GeographyFromText('POLYGON((0 10,170 10,170 5,0 5,0 10))')) as
Intersects;*

yields following result

TextFootPrint
                  |          Intersects
-------------------------------------------------------------------------------------------------------------------
MULTILINESTRING((74.194113 59.952996,71.424686 57.636768))      |          t


Which as I understand is not correct. The footprint is a line string
somewhere over Russia and the Polygon is a band in north hemisphere just
above equator.
Also when I visualise the both geographies as KML in google earth I can see
them thousands of miles apart.

This is just one example footprint where I have tens of thousand more in my
DB like this.

Please help me understand what is going on?


Regards,
Mahesh
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110613/925f30e8/attachment.html>


More information about the postgis-users mailing list