MySQL Forums
Forum List  »  GIS

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Wrong data returned from MYSQL
4326
February 14, 2008 11:53AM
3053
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.