全国4级地址库，京东数据

/* SQLyog Ultimate v9.63 MySQL - 5.6.20 : Database - edinghuo_weidian ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; CREATE DATABASE /*!32312 IF NOT EXISTS*/`edinghuo_weidian` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `imalls_1123`; /*Table structure for table `wd_loc_city` */ DROP TABLE IF EXISTS `wd_loc_city`; CREATE TABLE `wd_loc_city` ( `id` int(11) NOT NULL AUTO_INCREMENT, `province_id` int(11) DEFAULT NULL, `name` varchar(32) DEFAULT NULL, PRIMARY KEY (`id`), KEY `province_id` (`province_id`) ) ENGINE=InnoDB AUTO_INCREMENT=458 DEFAULT CHARSET=utf8; /*Data for the table `wd_loc_city` */ insert into `wd_loc_city`(`id`,`province_id`,`name`) values (1,1,'朝阳区'),(2,1,'海淀区'),(3,1,'西城区'),(4,1,'东城区'),(5,1,'崇文区'),(6,1,'宣武区'),(7,1,'丰台区'),(8,1,'石景山区'),(9,1,'门头沟'),(10,1,'房山区'),(11,1,'通州区'),(12,1,'大兴区'),(13,1,'顺义区'),(14,1,'怀柔区'),(15,1,'密云区'),(16,1,'昌平区'),(17,1,'平谷区'),(18,1,'延庆县'),(19,2,'黄浦区'),(20,2,'徐汇区'),(21,2,'长宁区'),(22,2,'静安区'),(23,2,'闸北区'),(24,2,'虹口区'),(25,2,'杨浦区'),(26,2,'宝山区'),(27,2,'闵行区'),(28,2,'嘉定区'),(29,2,'浦东新区'),(30,2,'青浦区'),(31,2,'松江区'),(32,2,'金山区'),(33,2,'奉贤区'),(34,2,'普陀区'),(35,2,'崇明县'),(36,3,'东丽区'),(37,3,'和平区'),(38,3,'河北区'),(39,3,'河东区'),(40,3,'河西区'),(41,3,'红桥区'),(42,3,'蓟县'),(43,3,'静海县'),(44,3,'南开区'),(45,3,'塘沽区'),(46,3,'西青区'),(47,3,'武清区'),(48,3,'津南区'),(49,3,'汉沽区'),(50,3,'大港区'),(51,3,'北辰区'),(52,3,'宝坻区'),(53,3,'宁河县'),(54,4,'万州区'),(55,4,'涪陵区'),(56,4,'梁平县'),(57,4,'南川区'),(58,4,'潼南县'),(59,4,'大足区'),(60,4,'黔江区'),(61,4,'武隆县'),(62,4,'丰都县'),(63,4,'奉节县'),(64,4,'开县'),(65,4,'云阳县'),(66,4,'忠县'),(67,4,'巫溪县'),(68,4,'巫山县'),(69,4,'石柱县'),(70,4,'彭水县'),(71,4,'垫江县'),(72,4,'酉阳县'),(73,4,'秀山县'),(74,4,'城口县'),(75,4,'璧山县'),(76,4,'荣昌县'),(77,4,'铜梁县'),(78,4,'合川区'),(79,4,'巴南区'),(80,4,'北碚区'),(81,4,'江津区'),(82,4,'渝北区'),(83,4,'长寿区'),(84,4,'永川区'),(85,4,'江北区'),(86,4,'南岸区'),(87,4,'九龙坡区'),(88,4,'沙坪坝区'),(89,4,'大渡口区'),(90,4,'綦江区'),(91,4,'渝中区'),(92,4,'高新区'),(93,4,'北部新区'),(94,5,'石家庄市'),(95,5,'邯郸市'),(96,5,'邢台市'),(97,5,'保定市'),(98,5,'张家口市'),(99,5,'承德市'),(100,5,'秦皇岛市'),(101,5,'唐山市'),(102,5,'沧州市'),(103,5,'廊坊市'),(104,5,'衡水市'),(105,6,'太原市'),(106,6,'大同市'),(107,6,'阳泉市'),(108,6,'晋城市'),(109,6,'朔州市'),(110,6,'晋中市'),(111,6,'忻州市'),(112,6,'吕梁市'),(113,6,'临汾市'),(114,6,'运城市'),(115,6,'长治市'),(116,7,'郑州市'),(117,7,'开封市'),(118,7,'洛阳市'),(119,7,'平顶山市'),(120,7,'焦作市'),(121,7,'鹤壁市'),(122,7,'新乡市'),(123,7,'安阳市'),(124,7,'濮阳市'),(125,7,'许昌市'),(126,7,'漯河市'),(127,7,'三门峡市'),(128,7,'南阳市'),(129,7,'商丘市'),(130,7,'周口市'),(131,7,'驻马店市'),(132,7,'信阳市'),(133,7,'济源市'),(134,8,'沈阳市'),(135,8,'大连市'),(136,8,'鞍山市'),(137,8,'抚顺市'),(138,8,'本溪市'),(139,8,'丹东市'),(140,8,'锦州市'),(141,8,'葫芦岛市'),(142,8,'营口市'),(143,8,'盘锦市'),(144,8,'阜新市'),(145,8,'辽阳市'),(146,8,'朝阳市'),(147,8,'铁岭市'),(148,9,'长春市'),(149,9,'吉林市'),(150,9,'四平市'),(151,9,'通化市'),(152,9,'白山市'),(153,9,'松原市'),(154,9,'白城市'),(155,9,'延边州'),(156,9,'辽源市'),(157,10,'哈尔滨市'),(158,10,'齐齐哈尔市'),(159,10,'鹤岗市'),(160,10,'双鸭山市'),(161,10,'鸡西市'),(162,10,'大庆市'),(163,10,'伊春市'),(164,10,'牡丹江市'),(165,10,'佳木斯市'),(166,10,'七台河市'),(167,10,'黑河市'),(168,10,'绥化市'),(169,10,'大兴安岭地区'),(170,11,'呼和浩特市'),(171,11,'包头市'),(172,11,'乌海市'),(173,11,'赤峰市'),(174,11,'乌兰察布市'),(175,11,'锡林郭勒盟'),(176,11,'呼伦贝尔市'),(177,11,'鄂尔多斯市'),(178,11,'巴彦淖尔市'),(179,11,'阿拉善盟'),(180,11,'兴安盟'),(181,11,'通辽市'),(182,12,'南京市'),(183,12,'徐州市'),(184,12,'连云港市'),(185,12,'淮安市'),(186,12,'宿迁市'),(187,12,'盐城市'),(188,12,'扬州市'),(189,12,'泰州市'),(190,12,'南通市'),(191,12,'镇江市'),(192,12,'常州市'),(193,12,'无锡市'),(194,12,'苏州市'),(195,13,'济南市'),(196,13,'青岛市'),(197,13,'淄博市'),(198,13,'枣庄市'),(199,13,'东营市'),(200,13,'潍坊市'),(201,13,'烟台市'),(202,13,'威海市'),(203,13,'莱芜市'),(204,13,'德州市'),(205,13,'临沂市'),(206,13,'聊城市'),(207,13,'滨州市'),(208,13,'菏泽市'),(209,13,'日照市'),(210,13,'泰安市'),(211,13,'济宁市'),(212,14,'铜陵市'),(213,14,'合肥市'),(214,14,'淮南市'),(215,14,'淮北市'),(216,14,'芜湖市'),(217,14,'蚌埠市'),(218,14,'马鞍山市'),(219,14,'安庆市'),(220,14,'黄山市'),(221,14,'滁州市'),(222,14,'阜阳市'),(223,14,'亳州市'),(224,14,'宿州市'),(225,14,'池州市'),(226,14,'六安市'),(227,14,'宣城市'),(228,15,'宁波市'),(229,15,'杭州市'),(230,15,'温州市'),(231,15,'嘉兴市'),(232,15,'湖州市'),(233,15,'绍兴市'),(234,15,'金华市'),(235,15,'衢州市'),(236,15,'丽水市'),(237,15,'台州市'),(238,15,'舟山市'),(239,16,'福州市'),(240,16,'厦门市'),(241,16,'三明市'),(242,16,'莆田市'),(243,16,'泉州市'),(244,16,'漳州市'),(245,16,'南平市'),(246,16,'龙岩市'),(247,16,'宁德市'),(248,17,'武汉市'),(249,17,'黄石市'),(250,17,'襄阳市'),(251,17,'十堰市'),(252,17,'荆州市'),(253,17,'宜昌市'),(254,17,'孝感市'),(255,17,'黄冈市'),(256,17,'咸宁市'),(257,17,'恩施州'),(258,17,'鄂州市'),(259,17,'荆门市'),(260,17,'随州市'),(261,17,'潜江市'),(262,17,'天门市'),(263,17,'仙桃市'),(264,17,'神农架林区'),(265,18,'长沙市'),(266,18,'株洲市'),(267,18,'湘潭市'),(268,18,'韶山市'),(269,18,'衡阳市'),(270,18,'邵阳市'),(271,18,'岳阳市'),(272,18,'常德市'),(273,18,'张家界市'),(274,18,'郴州市'),(275,18,'益阳市'),(276,18,'永州市'),(277,18,'怀化市'),(278,18,'娄底市'),(279,18,'湘西州'),(280,19,'广州市'),(281,19,'深圳市'),(282,19,'珠海市'),(283,19,'汕头市'),(284,19,'韶关市'),(285,19,'河源市'),(286,19,'梅州市'),(287,19,'惠州市'),(288,19,'汕尾市'),(289,19,'东莞市'),(290,19,'中山市'),(291,19,'江门市'),(292,19,'佛山市'),(293,19,'阳江市'),(294,19,'湛江市'),(295,19,'茂名市'),(296,19,'肇庆市'),(297,19,'云浮市'),(298,19,'清远市'),(299,19,'潮州市'),(300,19,'揭阳市'),(301,20,'南宁市'),(302,20,'柳州市'),(303,20,'桂林市'),(304,20,'梧州市'),(305,20,'北海市'),(306,20,'防城港市'),(307,20,'钦州市'),(308,20,'贵港市'),(309,20,'玉林市'),(310,20,'贺州市'),(311,20,'百色市'),(312,20,'河池市'),(313,20,'来宾市'),(314,20,'崇左市'),(315,21,'南昌市'),(316,21,'景德镇市'),(317,21,'萍乡市'),(318,21,'新余市'),(319,21,'九江市'),(320,21,'鹰潭市'),(321,21,'上饶市'),(322,21,'宜春市'),(323,21,'抚州市'),(324,21,'吉安市'),(325,21,'赣州市'),(326,22,'成都市'),(327,22,'自贡市'),(328,22,'攀枝花市'),(329,22,'泸州市'),(330,22,'绵阳市'),(331,22,'德阳市'),(332,22,'广元市'),(333,22,'遂宁市'),(334,22,'内江市'),(335,22,'乐山市'),(336,22,'宜宾市'),(33