Wrong data returned from MYSQL
Posted by:
eric chang
Date: February 14, 2008 11:53AM
Using the following sql on MySQL version 4.1:
select astext(map_point) ... where contains(GeomFromText('Polygon((
39.09889382148975 -74.68677520751953,
39.0930319292927 -74.63802337646484,
39.029585766893106 -74.6685791015625,
39.0421195689398 -74.71389770507812,
39.09889382148975 -74.68677520751953))'),map_point)
query returns some data as below, which seem to be outside the polygon area specified (verified using google map api)
"POINT(39.0984 -74.713491)","
"POINT(39.098255 -74.713217)"
"POINT(39.09849 -74.713663)",
"POINT(39.098885 -74.712646)"
"POINT(39.097613 -74.713776)"
"POINT(39.098328 -74.713354)"
"POINT(39.097665 -74.713885)"
"POINT(39.098312 -74.713324)"
"POINT(39.098423 -74.713534)"
"POINT(39.098219 -74.713148)"
"POINT(39.098238 -74.713184)"
Anybody has idea what the problem might be?
really appreciate your help!
Eric
Edited 1 time(s). Last edit at 02/14/2008 12:12PM by eric chang.
Subject
Views
Written By
Posted
Wrong data returned from MYSQL
4646
February 14, 2008 11:53AM
3256
February 19, 2008 06:35AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.