I am having trouble getting any features returned when issuing an SQL
query against polygons in a MySQL spatial table.
The table <Hoods> contains three polygons, my query looks like this:
select Neighborhood
from hoods
where within(point(-123.1673, 49.2659), geom)
Alternately, I tried this:
select Neighborhood
from hoods
where 1=within(point(-123.1673, 49.2659), geom)
Since the "within" function returns 1 if the relationship is true.
But neither of these queries returns anything.
Am I missing something? Is MySQL simply not capable of this kind of
query?
Thanks.
For insights into what's up at Safe Software and what's on the development
horizon, visit Safe's blog at spatial-etl.blogspot.com.
Safe Software has also made slides available that outline enhancements planned
for FME 2007. The slides are from the "Road Ahead" presentation given on Day 2
of the FME Worldwide Users Conference. To view these slides, visit
www.safe.com/2006uc.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/fme/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/fme/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
