Какой Мой IP Adddress - Показать Ваш IP-адрес IPv4 & IPv6. Вы можете видеть свой IP-адрес в Интернете на интерактивной карте. Мой IP-адрес - IPv4 и IPv6
IPv4 and IPv6 Live Whois Lookup
Мой Аккаунт  | 
Выход
Вход  |  Зарегистрироваться        
Information

whois database download

Cities database in SQL / Mysql
Cities States Countries Mysql Sql Database Download

Отчет - ТОП Мировые Хостинг Компании,
Nov 2017
Загрузить Отчет  »
Myip.ms

World Cities/States/Countries SQL & Mysql & Excel Database (Ноябрь 2017 year)     +   Website Script (optional)

We Provide Cities / States / Countries database in Microsoft SQL / Oracle / Mysql / Excel formats for use in your applications. All cities / states / countries have their latitude and longitude filled for display on Google map. For example, on user registration page on your website.


Cities States Countries Mysql Sql Database Download

Countries Cities HTML, Php, Jquery Ajax Script for Website


Cities SQL Database Reviews
Our downloadable SQL database have details of -

 



Example of Use (php/jquery script, includes all countries/states/cities) -

 

Страна:
Регионы:
Города:




We tested cities database on Mysql / Oracle / Microsoft SQL Server. Cities SQL Demo has the same table structure as the full version. But it only has 5 selected countries (USA/China/France/Brazil/India), all states for those selected countries and limit 5 cities records for each state. Complete list of cities you can see in the example above or by using this link.

  • Price for the full version (Cities/States/Countries SQL & MySQL Database) is   US$249 / 0.12 Bitcoin

  • Price for the PHP Script is FREE (with Cities SQL & MySQL Database). Limited Time Offer. Normal Price is US$50. Cities PHP Script for Website compatible with MySQL only (not MSSQL). It uses Php / Mysql / Jquery / Html and displays countries/states/cities drop-down ajax list in the same way as you see in our example above.

  • Price for the full version (Cities/States/Countries MySQL Database) + Complete Script for Website (Php/Mysql/Jquery/Html)
    is  US$249 / 0.12 Bitcoin  (Limited Time Offer).    Normal Price is $299.

  • License - Our cities database is licensed under the GNU general public license which means it may be used by our customers on as many websites as they like.





Buy Now - Select Cities Database, Ноябрь 2017




Current Version: Ноябрь 2017


Свяжитесь с нами для получения дополнительной информации -
bitcoin payment

Наш Bitcoin (BTC) кошелёк :
18oq3LjB48584CMwYoseaQGtxRXd4Qvdqo

Bitcoin инструкция по оплате



A. Cities in Excel Format -



B. Cities in SQL / MySQL Format (truncated) -

/*************************************************************/;
/* A. CREATE TABLE STATEMENT - Microsoft SQL Server / Oracle */;
/*************************************************************/;

/************************************/;
/* COUNTRIES SQL Table  253 records */;
/************************************/;
CREATE TABLE countries (
  countryID varchar(3) NOT NULL,
  countryName nvarchar(100) NOT NULL,
  localName nvarchar(100),
  webCode varchar(2),
  region varchar(50),
  continent varchar(25),
  latitude float NOT NULL,
  longitude float NOT NULL,
  surfaceArea float NOT NULL,
  population int NOT NULL,
  PRIMARY KEY (countryID),
  UNIQUE (webCode),
  UNIQUE (countryName)
);
/************************************/;
/* STATES SQL Table  ~4,480 records */;
/************************************/;
CREATE TABLE states (
  stateID int NOT NULL,
  stateName nvarchar(100) NOT NULL,
  countryID varchar(3) NOT NULL,
  latitude float NOT NULL,
  longitude float NOT NULL,
  PRIMARY KEY (stateID),
  UNIQUE (countryID, stateName)
);
/*************************************/;
/* CITIES SQL Table  ~176,000 records */;
/*************************************/;
CREATE TABLE cities (
  cityID int NOT NULL,
  cityName nvarchar(100) 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)
);



/*************************************************************/;
/* B.   CREATE TABLE STATEMENT - MySQL Server                */;
/*************************************************************/;

/***************************************/;
/* COUNTRIES MySQL Table  253 records */;
/***************************************/;
CREATE TABLE `countries` (
  `countryID` varchar(3) NOT NULL DEFAULT '',
  `countryName` varchar(52) NOT NULL DEFAULT '',
  `localName` varchar(45) NOT NULL,
  `webCode` varchar(2) NOT NULL,
  `region` varchar(26) NOT NULL,
  `continent` enum('Asia','Europe','North America','Africa','Oceania','Antarctica','South America') NOT NULL,
  `latitude` double NOT NULL DEFAULT '0',
  `longitude` double NOT NULL DEFAULT '0',
  `surfaceArea` float(10,2) NOT NULL DEFAULT '0.00',
  `population` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`countryID`),
  UNIQUE KEY `webCode` (`webCode`),
  UNIQUE KEY `countryName` (`countryName`),
  KEY `region` (`region`),
  KEY `continent` (`continent`),
  KEY `surfaceArea` (`surfaceArea`),
  KEY `population` (`population`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/**************************************/;
/* STATES MySQL Table  ~2,800 records */;
/**************************************/;
CREATE TABLE `states` (
  `stateID` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `stateName` varchar(50) NOT NULL DEFAULT '',
  `countryID` varchar(3) NOT NULL,
  `latitude` double NOT NULL DEFAULT '0',
  `longitude` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`stateID`),
  KEY `stateName` (`stateName`),
  KEY `countryID` (`countryID`),
  KEY `unq` (`countryID`,`stateName`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

/***************************************/;
/* CITIES MySQL Table  ~176,000 records */;
/***************************************/;
CREATE TABLE `cities` (
  `cityID` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `cityName` varchar(50) NOT NULL,
  `stateID` smallint(5) unsigned NOT NULL DEFAULT '0',
  `countryID` varchar(3) NOT NULL DEFAULT '',
  `latitude` double NOT NULL DEFAULT '0',
  `longitude` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`cityID`),
  UNIQUE KEY `unq` (`countryID`,`stateID`,`cityID`),
  KEY `cityName` (`cityName`),
  KEY `stateID` (`stateID`),
  KEY `countryID` (`countryID`),
  KEY `latitude` (`latitude`),
  KEY `longitude` (`longitude`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
/***************************************/;


/*************************************************************/;
/* C.  Microsoft SQL/Oracle/MySQL Common Table Data          */;
/*************************************************************/;

/* Countries Table Data */
INSERT INTO `countries` (`countryID`, `countryName`, `localName`, `webCode`, `region`, `continent`, 
`latitude`, `longitude`, `surfaceArea`, `population`) VALUES
('BRA', 'Brazil', 'Brasil', 'BR', 'South America', 'South America', -10, -55, 8547403.00, 170115000),
('CHN', 'China', 'Zhongquo', 'CN', 'Eastern Asia', 'Asia', 35, 105, 9572900.00, 1277558000),
('FRA', 'France', 'France', 'FR', 'Western Europe', 'Europe', 47, 2, 551500.00, 59225700),
('IND', 'India', 'Bharat/India', 'IN', 'Southern and Central Asia', 'Asia', 28.47, 77.03, 3287263.00, 1013662000),
('USA', 'USA', 'United States', 'US', 'North America', 'North America', 38, -97, 9363520.00, 278357000);

/* States Table Data */
INSERT INTO `states` (`stateID`, `stateName`, `countryID`, `latitude`, `longitude`) VALUES
(5, 'California', 'USA', 37.42, -122.06),
(6, 'Beijing', 'CHN', 39.93, 116.39),
(9, 'Iowa', 'USA', 43.03, -96.09),
(10, 'New York', 'USA', 40.76, -73.97),
(12, '... ....', 'CHN', 32.06, 118.78);

/* Cities Table Data */
INSERT INTO `cities` (`cityID`, `cityName`, `stateID`, `countryID`, `latitude`, `longitude`) VALUES
(7, 'Mountain View', 5, 'USA', 37.42, -122.06),
(8, 'Beijing', 6, 'CHN', 39.93, 116.39),
(11, 'Ackworth', 9, 'USA', 41.36, -93.43),
(13, 'Far Rockaway', 10, 'USA', 40.61, -73.79),
(14, 'Hebei', 11, 'CHN', 39.89, 115.28),
(15, 'Los Angeles', 5, 'USA', 34.04, -118.25),
(16, '... ... ...', 12, 'CHN', 32.06, 118.78);


  Full Cities/States/Countries MySQL & Sql source code you can download here »





Обзоры и Комментарии
comments powered by Disqus
Обзоры и Комментарии
Чтобы опубликовать этот обзор на вашем сайте / в блоге, просто скопируйте следующий HTML код и разместить его на вашей веб-странице -
Домой GoUrl.io - Bitcoin Gateway API Страны Мировой Хостинг Файлы / Отчеты Карта Сайта
GoUrl Spelling Notifications
ПОДДЕРЖИ НАС - Если вам нравится этот сайт и вы хотите поддержать дальнейшее развитие myip.ms -
Bitcoin: 1P4oi48drkGL2ZwnRdDk6NBKp83r3s9uAT       Litecoin: LRpJFfCJqZBBFiSTaTewq5mLWJTF7G29yX
Dash: XsJvyrSfQW5UFcCnpGKi1aNFprLhmJWgkJ       Dogecoin: DNoxuJq61bYLMFFRCSUZHDZeV71b6Ybref

Авторское право © 2012-2017 Myip.ms. Все права защищены.
Все или часть информации на этом сайте могут быть перепечатаны на других сайтах, но с указанием ссылки на Myip.ms

           
#1 Global Browsers, Websites & IP Database