在地图上绘制100k纬度 - 经度位置 [英] plotting 100k latitude-longitude locations on map

问题描述

我有大约100k个位置存储在MySQL服务器中。

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

我想在地图中绘制，但是当我将它导出到.csv文件，然后转换为.kml文件，文件大小超过20mb，而Google Map API对.kml文件的限制为3mb。
.csv文件大约是2.5mb，但是我不能将.csv文件加载到Google Map中。

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?

推荐答案

使用Google Fusion Tables - 它们在toto中支持100,000个图层和5个图层 >。它们的闪电速度也非常快，因为您通过在Google服务器上运行的SQL类型语言访问它们 - 即您上传数据时的位置。

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.

CSV格式导入Google云端硬盘中的Fusion Table，并获取该表格的键，然后使用您的Javascript中的键。

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.

我使用Fusion Tables创建了以下网站，我在Javascript中是零！请参阅Skyscan网站此处。

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

这篇关于在地图上绘制100k纬度 - 经度位置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！