管理地点的最佳方式？
我即将在网站上实现地理搜索。我真的不想在数据库中输入任何位置信息，因为根据我的经验，这样做总是浪费时间，而且没有人对结果特别满意。
我一直在研究 Google Fusion 表和使用 KML 的解决方案，如下所示： http://code.google.com/apis/maps/documentation/javascript/overlays.html#KMLLayers
有没有人在谷歌地图搜索API旁边尝试过这个（为了获取位置而不是存储我自己）并将搜索结果纬度/经度放入 Google Fusion 中？
我还听说 SQL 2008 在这方面也有很好的功能。我试图找到最具创新性的方法，但似乎有很多解决方案，找到最好的方法并不容易！
I am about to implement a geo search on a website. I really don't want to enter any location information into my database as my experience of doing so is always that it is a time drain and no-one is every particularly happy with the results.
I have been investigating Google Fusion tables and the solutions using KML such as here: http://code.google.com/apis/maps/documentation/javascript/overlays.html#KMLLayers
Has anyone tried this along side the google maps search api (to get hold of locations rather than storing myself) and putting the search results latitude/longitude into Google Fusion?
I have also heard SQL 2008 has good functionality in this area too. I am trying to find the most innovative way but it seems there are many solutions and finding the best is not easy!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
如果将融合表标记为可导出且未列出，则只需使用 Javascript 即可完成许多任务。如果身份验证是强制性的，您需要一些服务器端的工作，但例如Python 库非常出色。除此之外，我发现融合令人难以置信的快速和可靠。请记住，它是测试版，因此团队将来可能会更改 API 的任何方面。而且每秒 5 个请求的上限仍然存在，因此缓存可能会成为一个问题。
为了告诉你更多信息，你能具体说明为什么要存储谷歌搜索结果吗？
If you mark the fusion table as exportable and unlisted, you can do many tasks with Javascript only. In case authentication is mandatory, you need some server side effort, but e.g. the Python libs are excellent. Beside this I've found fusion incredible fast and reliable. Keep in mind it is Beta, so the team may change any aspect of the API in future. And there is still an upper limit of 5 requests per second, so caching might become an issue, though.
To tell you more, could you specify why you want to store google search results?
我基本上采用了在自动完成上使用 Google API，然后获取纬度和经度并使用 Linq 与存储的数据进行比较的方法。
它尚未完成，但早期迹象表明它会很快。一个缺点是 Google API 返回许多相当奇怪的结果，而不仅仅是一个城镇名称。不过，我们正在努力优化这一点。总的来说，Google Geocode API 确实非常有用。
I have basically taken the approach of using the Google API on an auto complete and then taking the latitude and longitude and comparing to the stored data using Linq.
It is not finished but early indications suggest it will be fast. The one downside is that the Google API returns lots of rather odd results rather than just a town name. We are working to optimise this though. In general the Google Geocode API is very useful indeed.