Global database of 78,707 major cities, including latitude and longitude coordinate values, countries, provinces

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,

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.

Download to: http://blog.erdaicms.com

Global database of 78,707 major cities, including latitude and longitude coordinate values, countries, provinces