Loading large amount of points for use with Google Maps API

XML, Perl, Python, and other languages can be discussed here, even if it isn't PHP (We might forgive you).

Moderator: General Moderators

Post Reply
User avatar
Luke
The Ninja Space Mod
Posts: 6424
Joined: Fri Aug 05, 2005 1:53 pm
Location: Paradise, CA

Loading large amount of points for use with Google Maps API

Post 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?
User avatar
Benjamin
Site Administrator
Posts: 6935
Joined: Sun May 19, 2002 10:24 pm

Post by Benjamin »

I can't think of a better solution than a database table or two.
User avatar
Luke
The Ninja Space Mod
Posts: 6424
Joined: Fri Aug 05, 2005 1:53 pm
Location: Paradise, CA

Post 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?
User avatar
Benjamin
Site Administrator
Posts: 6935
Joined: Sun May 19, 2002 10:24 pm

Post 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 ;
User avatar
Luke
The Ninja Space Mod
Posts: 6424
Joined: Fri Aug 05, 2005 1:53 pm
Location: Paradise, CA

Post by Luke »

yea that would be better.
Post Reply