World City Locations Database
Geographical location (latitude, longitude, altitude) of all main cities of the world. The data has been scrapped from [Aneki World Cities site] (http://www.aneki.com/cities.html)
The repository contains the location database in below formats:
- CSV for MS EXCEL, MS EXCEL 2000
All of them are exported from MySQL using phpMyAdmin.
The table has in 10,567 rows (means 10,567 unique cities, their locations and 170 countries).
The table has 5 fields,
altitude. From their name, I hope you can understand their significance.
The sql file contains the schema to reproduce the location table in your designated database (assuming you are using mysql database engine. If you aren’t, you can easily convert the sql schema
Getting all countries of the world (170 countries)
SELECT DISTINCT(country) FROM location
Getting all cities of a country
SELECT city FROM location WHERE country = 'YOUR_COUNTRY_NAME_HERE'
Getting the location of a specific city of a specific country
SELECT latitude,longitude,altitude FROM location WHERE country='COUNTRY_NAME' AND city = 'CITY_NAME'