List of offers / databases of the country / city

Question

I am looking for something similar to a list of facebook offers from cities and countries. You can see what I'm talking about when you try to create a new event on facebook, click to add an address, and then start typing in the City field.

I prefer to find a working suggestion tool in jQuery (with date), but the city / country database will do the trick too.

Answer 1

Here you will find: http://geolite.maxmind.com/download/worldcities/

. jQuery () "". , , , : -)

Answer 2

http://www.geonames.org/

Answer 3

Freebase Suggest - jQuery, . ("type": ["/location/country"]) , , , .

, , ..

Answer 4

: http://www.wunderground.com/

API , /: http://www.wunderground.com/weather/api/d/documentation.html#auto

Answer 5

, API Google.

http://code.google.com/intl/sk-SK/apis/maps/documentation/javascript/places.html#places_autocomplete

, , GMA (free vs business) . , GMA.

Answer 6

/ Microsoft SQL/Mysql

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

Cities / Countries Table structure -

CREATE TABLE cities (
  cityID int NOT NULL,
  cityName varchar(50) NOT NULL,
  stateID int NOT NULL,
  countryID varchar(3) NOT NULL,
  latitude float NOT NULL,
  longitude float NOT NULL,
  PRIMARY KEY (cityID),
  UNIQUE (countryID,stateID,cityID)
);

CREATE TABLE countries (
  countryID varchar(3) NOT NULL,
  countryName varchar(52) NOT NULL,
  localName varchar(45) NOT NULL,
  webCode varchar(2) NOT NULL,
  region varchar(26) NOT NULL,
  continent varchar(15) NOT NULL,
  latitude float NOT NULL,
  longitude float NOT NULL,
  surfaceArea float NOT NULL,
  population int NOT NULL,
  PRIMARY KEY (countryID),
  UNIQUE (webCode),
  UNIQUE (countryName)
);