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.