I need to create a mysql database for different cities in the world with following details
- Longitude
- Latitude
- City
- Time Zone
I have tried lots of search results and found Geolite
As the database contains nearly 400 thousand records, i am afraid to save those data in my database.Also time zone is not there with this list.
Is there any online API/XML to get the details by passing city name to get details or do i have to use the geolite data to saved in my database. Thanks you.
