world cities database

Hi

I need a world cities database, with longitude/latitude and timezones. Does anyone have one and would share it or does anyone know where to find one?
I would very much appreciate any suggestions.

Thanks!

 

Most likely this can help you. but without the timezone.

http://www.maxmind.com/app/worldcities

 

even try this http://worldcitiesdatabase.com/world-city-latitude-longitude.aspx for latitude and longitude for smallest of small cities

 

You can take it for free at my site

 

I would reconment Googling this, we used one database which offered a zipcode asp.net script as well calling the information per location. However the script itself didn't work nor did the radius feature. Hope this helps:

Hemant
www.Templeofgroove.com
www.Hamonster.com

Domain List:

WWW.AUCTIONEER.CO.IN
WWW.CLOTHINGSTORE.CO.IN
WWW.COMPARABLE.CO.IN
WWW.CONNECTING.CO.IN
WWW.CORRECTING.CO.IN
WWW.DEJAY.US
WWW.DESIDEEJAY.US
WWW.EARNER.CO.IN
WWW.EARNER.US
WWW.EVENTPLANNING.CO.IN
WWW.EVENTZA.COM
WWW.EXISTING.CO.IN
WWW.EXPANDING.CO.IN
WWW.FABRICATING.CO.IN
WWW.FLIPPER.CO.IN
WWW.FLIPPING.CO.IN
WWW.GENERATING.CO.IN
WWW.IMPRESSIVE.CO.IN
WWW.OUTRIGHT.CO.IN
WWW.PARTNERS.CO.IN
WWW.PERFORMING.CO.IN
WWW.RESPOND.CO.IN
WWW.RESPONDS.CO.IN
WWW.RESPONDS.NAME
WWW.RUSSELLPETERS.BIZ
WWW.RUSSELLPETERS.INFO
WWW.RUSSELLPETERS.MOBI
WWW.RUSSELLPETERS.ORG
WWW.RUSSELLPETERS.US
WWW.SEXPARTNERS.BIZ
WWW.SEXPARTNERS.CO.IN
WWW.SUGARCANE.CO.IN
WWW.TAKEN.CO.IN
WWW.VISITS.CO.IN
WWW.WEBCONSULTANT.CO.IN
WWW.WEBCONSULTING.CO.IN
WWW.ACQUIRES.BIZ
WWW.ACQUIRES.IN
WWW.CORRECTED.BIZ
WWW.CORRECTED.IN
WWW.CORRECTING.BIZ
WWW.CORRECTING.IN
WWW.CORRECTING.US
WWW.DEVELOPING.CO.IN
WWW.EARNERS.IN
WWW.IMPRESSED.BIZ
WWW.IMPRESSED.IN
WWW.LOCKED.WS
WWW.RESPOND.CC
WWW.RESPONDS.ASIA
WWW.RESPONDS.BIZ
WWW.RESPONDS.CC
WWW.RESPONDS.ME
WWW.RESPONDS.TV
WWW.RESPONDS.US
WWW.RESPONDS.WS
WWW.WEBDEVELOPING.CO.IN
WWW.WEBDEVELOPING.US

 

You can take a look at GeoDataSource's World Cities Database:

http://www.geodatasource.com/cities.html

They offer free and paid editions of world cities database.

 

I used the one at citydatabase.us

It has just about everything you need. It even have zip codes and such. Plus it's only $10, cheaper then anyone else

 

We have Database for sale of all the Countries, broken up to States/Regions, Counties and all the Cities with their Suburbs/Neighbourhoods (in Excel and SQL format).

Example: United Kingdom has over 44,000 Cities with Suburbs or Neighbourhoods

United Kingdom > England > Yorkshire & Humberside > West Yorkshire > Leeds > Beeston

We charge £49 per Country. For extra information please contact us by worldcitiesdata@gmail.com

 

Hi..i tried to order on the site..but google says it not handle payment for the site anymore.. Can i order with paypal from you?

 

I found a cities database that is very good, is orderable through paypal and is pretty cheap ($5 - $15 depending on which version you choose). The website is at www.world-database.com

 

You can use fresh 2013 year world cities MSSQL/MySQL Database with PHP script from here -

http://myip.ms/info/cities_sql_database/World_Cities_SQL_Mysql_Database.html

SQL script -

1. /***************************************/;
2. /* CITIES MySQL Table ~106,000 records */;
3. /***************************************/;
4. CREATE TABLE `cities` (
5. `cityID` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
6. `cityName` varchar(50) NOT NULL,
7. `stateID` smallint(5) unsigned NOT NULL DEFAULT '0',
8. `countryID` varchar(3) NOT NULL DEFAULT '',
9. `latitude` double NOT NULL DEFAULT '0',
10. `longitude` double NOT NULL DEFAULT '0',
11. PRIMARY KEY (`cityID`),
12. UNIQUE KEY `unq` (`countryID`,`stateID`,`cityID`),
13. KEY `cityName` (`cityName`),
14. KEY `stateID` (`stateID`),
15. KEY `countryID` (`countryID`),
16. KEY `latitude` (`latitude`),
17. KEY `longitude` (`longitude`)
18. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
19. /***************************************/;

 

http://dev.maxmind.com/geoip/legacy/geolite/