have a cities of the world CSV dataset compiled from the USGS GNIS Server (US) and US NGA GNS Server (non-US), that I have placed into the public domain. Below is a link and metadata of the layout.
Column 1: ISO 3166-1 alpha-2 country code. Column 2: US FIPS 5-2 1st level administrative division code (e.g., state/province). Column 3: NGA GNS Feature Description (DSG) code. Column 4: NGA GNS Unique Feature Identifier (UFI). Column 5: ISO 639-1 alpha-2/3 code for language corresponding to the feature name. Column 6: Language script (e.g., latin, arabic, chinese, etc) corresponding to the feature name. Column 7: Feature name. Column 8: Latitude coordinate of the area centroid. Column 9: Longitude coordinate of the area centroid.
发布评论
评论（3）
http://www.maxmind.com/app/geolitecity
尽管作为替代方案，您有吗考虑过利用 Google 地图 API？它是免费的，并且他们提供了集成您的应用程序的良好说明。
http://www.maxmind.com/app/geolitecity
Although as an alternative, have you considered tapping into the Google Maps API? It's free, and they provide good instructions to integrate your app.
有一个从 USGS GNIS 服务器（美国）和 US NGA GNS 服务器（非美国）编译的世界城市 CSV 数据集，我已将其放入公共领域。下面是布局的链接和元数据。
第 1 列：ISO 3166-1 alpha-2 国家/地区代码。
第 2 栏：美国 FIPS 5-2 一级行政区划代码（例如州/省）。
第 3 栏：NGA GNS 功能描述 (DSG) 代码。
第 4 栏：NGA GNS 独特功能标识符 (UFI)。
第 5 列：与功能名称对应的语言的 ISO 639-1 alpha-2/3 代码。
第6列：与特征名称对应的语言文字（例如拉丁语、阿拉伯语、中文等）。
第 7 列：功能名称。
第8列：区域质心的纬度坐标。
第 9 列：区域质心的经度坐标。
http://www.opengeocode.org/下载.php#cities
have a cities of the world CSV dataset compiled from the USGS GNIS Server (US) and US NGA GNS Server (non-US), that I have placed into the public domain. Below is a link and metadata of the layout.
Column 1: ISO 3166-1 alpha-2 country code.
Column 2: US FIPS 5-2 1st level administrative division code (e.g., state/province).
Column 3: NGA GNS Feature Description (DSG) code.
Column 4: NGA GNS Unique Feature Identifier (UFI).
Column 5: ISO 639-1 alpha-2/3 code for language corresponding to the feature name.
Column 6: Language script (e.g., latin, arabic, chinese, etc) corresponding to the feature name.
Column 7: Feature name.
Column 8: Latitude coordinate of the area centroid.
Column 9: Longitude coordinate of the area centroid.
http://www.opengeocode.org/download.php#cities
您可以从这里使用 Mysql / SQL 中的城市/州/国家数据库 -
http://myip.ms /info/cities_sql_database/World_Cities_SQL_Mysql_Database.html
You can use cities / states/ countries database in Mysql / SQL from here -
http://myip.ms/info/cities_sql_database/World_Cities_SQL_Mysql_Database.html