Spatial Database - how to
Posted on 2008-10-16
I have some data stored as ..
I've thought of implementing spatial indexing instead of normal indexing. As a newbie i'd like to know whether this is a good idea or not.And also some steps to implement database and basic searches.
What i did till now is:
CREATE TABLE `geo` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(40) NOT NULL,
`loc` point NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO geo VALUES('some-name', GeomFromText('POINT(06.03276 -15.046306)'));
Now in such data
How can i do a search for particular location based on lat/long?
Will such search will be faster than normal indexing?
Please provide me with some best practices / ideas / implementations / sample spatial database....