CODEWITHSUNDEEP
google-mapscsvgoogle-maps-api-3geolocation
Eric
Eric

Reputation: 2705

plotting 100k latitude-longitude locations on map

I have about 100k locations stored in a MySQL server.

I want to plot this in a map, but when I export it to a .csv file and then convert to .kml file, the file size exceeds 20mb, whereas Google Map API has limits of 3mb for .kml file. The .csv file is about 2.5mb, but I cannot load .csv files into Google Map.

Is there any way I can do load the locations to a map?

Upvotes: 0

Views: 562

Answers (1)

Mark Setchell
Mark Setchell

Reputation: 207808

Use Google Fusion Tables - they support 100,000 points per layer and 5 layers in toto. They are lightning fast too as you access them via an SQL-type language that runs on Google's servers - exactly where your data will be when you upload it.

You load your CSV into a Fusion Table in your Google drive and get a key to that table and you then use the key in your Javascript.

I created the following website with Fusion Tables and I am a zero in Javascript! See Skyscan website here.

Upvotes: 1

Related Questions