[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