MySQL Forums
Forum List  »  GIS

GIS functions not available?
Posted by: Marcus Bointon
Date: November 23, 2005 11:37AM

I'm experimenting with the spatial extensions using the UK postcode data from I've successfully converted my lat and long values into a point type field, but when I try and use any spatial functions, I just get an error. This query:

SELECT Distance(`point`, point(0,0)) FROM `jibble`

gives me:

#1305 - FUNCTION postcodes.Distance does not exist

Here's my table definition:

CREATE TABLE `jibble` (
`code` char(4) collate latin1_bin NOT NULL default '',
`x` int(11) NOT NULL default '0',
`y` int(11) NOT NULL default '0',
`long` float NOT NULL default '0',
`lat` float NOT NULL default '0',
`point` point default NULL,
PRIMARY KEY (`code`)

I'm running a stock 5.0.15 on OS X - if spatial extensions are not available (though I'm guessing they are as it allowed me to use the POINT field type), how can I find out?

Options: ReplyQuote

Written By
GIS functions not available?
November 23, 2005 11:37AM
December 07, 2005 11:03AM
January 05, 2006 12:11PM
June 11, 2007 10:23AM
August 31, 2007 04:22AM

Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.