Page 1 of 1

Loading large amount of points for use with Google Maps API

Posted: Tue Jul 11, 2006 5:20 pm
by Luke
I have a list of about 2500 lattitude/longitude coordinates that will need to be loaded into a PHP page that will turn them into 4 different map overlays (4 counties). What would be the best way to store these coordinates and load them into my application? Database?

Posted: Tue Jul 11, 2006 5:52 pm
by Benjamin
I can't think of a better solution than a database table or two.

Posted: Tue Jul 11, 2006 6:09 pm
by Luke
Maybe identical tables for each of the 4 counties. This information will never change though. They would only need coordinate_x and coordinate_y columns wouldn't they?

Posted: Tue Jul 11, 2006 6:52 pm
by Benjamin
I don't really have enough information to answer that, but something like this maybe..

Code: Select all

CREATE TABLE `LocationData` (
  `LocationID` int(10) NOT NULL auto_increment,
  `County` varchar(2) default NULL,
  `Latitude` decimal(10,6) default NULL,
  `Longitude` decimal(10,6) default NULL,
  PRIMARY KEY  (`LocationID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

Posted: Wed Jul 12, 2006 1:27 am
by Luke
yea that would be better.