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 jibble.org. 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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_bin

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


Subject
Views
Written By
Posted
GIS functions not available?
9721
November 23, 2005 11:37AM
4803
December 07, 2005 11:03AM
5224
January 05, 2006 12:11PM
6813
June 11, 2007 10:23AM
5712
August 31, 2007 04:22AM


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.