城市，州，邮编，国家列表/脚本为sql服务器表 [英] City, State, Zip, Country list/script for sql server table

问题描述

我一直在寻找City，State，Zip，Country的最佳来源，以便在应用程序中使用。我在GeoNames.org中找到了这个集合，它看起来非常全面。但是，并没有简单的将SQL Server导入。我也相信USPS有类似的东西。

有谁知道一个很好的可靠源代码，可以很容易地将这些信息导入到SQL Server中？或者，也许甚至更好的谷歌条款？

解决方案

有一个脚本来加载博客中的数据我写了一段时间。希望它有帮助。

SQL Server Zipcode纬度/经度接近距离搜索

I have been searching around for the best source for City, State, Zip, Country to use in an application. I have found the set at GeoNames.org and it seems very comprehensive. However there is not a simple import into SQL Server. I also believe the USPS has something similar.

Does anyone know a good reliable source that is easily imported into SQL Server for this information? Or maybe even some better Googling terms?

解决方案

There is a script to load data from geonames in a blog I wrote a while ago. Hopefully it helps.

SQL Server Zipcode Latitude/Longitude proximity distance search

这篇关于城市，州，邮编，国家列表/脚本为sql服务器表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！