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
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
