78,707 major cities in the world MySQL database, including latitude and longitude coordinate values

The world's 78,707 major cities information MySQL database, including latitude and longitude coordinate values, has been exported to the SQL file, because it is relatively large, there is 10M, so this is exported separately, for the upgrade failed to manually import students,

650) this.width=650; "class=" AlignCenter size-full wp-image-98 "src=" http://blog.erdaicms.com/wp-content/uploads/ 2016/03/1-25.png "alt=" global 78,707 major cities data "width=" 638 "height=" style= "height:auto;vertical-align:middle;border:0" px;margin:0px auto;text-align:center; "/>

This data is mainly used for weather forecast plug-in, the weather report plug-in, need to first from the library, query the city's ID, in the ID passed to the interface, return to the weather forecast data.

Here can not upload attachments, download please go to the official blog: http://blog.erdaicms.com/lvyou/97

78,707 major cities in the world MySQL database, including latitude and longitude coordinate values