[汇总表+主从表两个方案]全国省市区联动数据库（mysql版本）

-- MySQL dump 10.13 Distrib 5.6.23, for Win64 (x86_64) -- -- Host: localhost Database: housetransaction -- ------------------------------------------------------ -- Server version 5.6.25-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!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 */; -- -- Table structure for table `area` -- DROP TABLE IF EXISTS `area`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `area` ( `id` varchar(50) NOT NULL, `parent_id` int(11) NOT NULL, `name` varchar(200) NOT NULL, `short_name` varchar(200) NOT NULL, `longitude` float NOT NULL, `latitude` float NOT NULL, `level` int(11) NOT NULL, `sort` int(11) NOT NULL, `status` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `area` -- LOCK TABLES `area` WRITE; /*!40000 ALTER TABLE `area` DISABLE KEYS */; INSERT INTO `area` VALUES ('110100',0,'北京市','北京',116.405,39.905,1,1,1),('110101',110100,'东城区','东城',116.419,39.9175,3,3,1),('110101001',110101,'东华门街道','东华门街道',116.41,39.918,4,5,1),('110101002',110101,'景山街道','景山街道',116.41,39.9269,4,12,1),('110101003',110101,'交道口街道','交道口街道',116.405,39.9366,4,11,1),('110101004',110101,'安定门街道','安定门街道',116.404,39.9443,4,1,1),('110101005',110101,'北新桥街道','北新桥街道',116.424,39.942,4,2,1),('110101006',110101,'东四街道','东四街道',116.424,39.9303,4,7,1),('110101007',110101,'朝阳门街道','朝阳门街道',116.428,39.9188,4,3,1),('110101008',110101,'建国门街道','建国门街道',116.426,39.9104,4,10,1),('110101009',110101,'东直门街道','东直门街道',116.44,39.9341,4,8,1),('110101010',110101,'和平里街道','和平里街道',116.423,39.9546,4,9,1),('110101011',110101,'前门街道','前门街道',116.408,39.898,4,14,1),('110101012',110101,'崇文门外街道','崇文门外街道',116.413,39.8974,4,4,1),('110101013',110101,'东花市街道','东花市街道',116.429,39.8991,4,6,1),('110101014',110101,'龙潭街道','龙潭街道',116.437,39.8872,4,13,1),('110101015',110101,'体育馆路街道','体育馆路街道',116.419,39.9175,4,16,1),('110101016',110101,'天坛街道','天坛街道',116.4,39.8897,4,15,1),('110101017',110101,'永定门外街道','永定门外街道',116.401,39.866,4,17,1),('110102',110100,'西城区','西城',116.367,39.9153,3,15,1),('110102001',110102,'西长安街街道','西长安街街道',116.367,39.9153,4,13,1),('110102003',110102,'新街口街道','新街口街道',116.371,39.9431,4,12,1),('110102007',110102,'月坛街道','月坛街道',116.344,39.9151,4,14,1),('110102009',110102,'展览路街道','展览路街道',116.367,39.9153,4,15,1),('110102010',110102,'德胜街道','德胜街道',116.367,39.9153,4,4,1),('110102011',110102,'金融街街道','金融街街道',116.367,39.9153,4,7,1),('110102012',110102,'什刹海街道','什刹海街道',116.367,39.9153,4,9,1),('110102013',110102,'大栅栏街道','大栅栏街道',116.394,39.8935,4,3,1),('110102014',110102,'天桥街道','天桥街道',116.387,39.8849,4,11,1),('110102015',110102,'椿树街道','椿树街道',116.376,39.8991,4,2,1),('110102016',110102,'陶然亭街道','陶然亭街道',116.381,39.8835,4,10,1),('110102017',110102,'广安门内街道','广安门内街道',116.363,39.8895,4,5,1),('110102018',110102,'牛街街道','牛街街道',116.367,39.9153,4,8,1),('110102019',110102,'白纸坊街道','白纸坊街道',116.364,39.8771,4,1,1),('110102020',110102,'广安门外街道','广安门外街道',116.34,39.8905,4,6,1),('110105',110100,'朝阳区','朝阳',116.486,39.9215,3,2,1),('110105001',110105,'建外街道','建外街道',116.486,39.9215,4,18,1),('110105002',110105,'朝外街道','朝外街道',116.486,39.9215,4,5,1),('110105003',110105,'呼家楼街道','呼家楼街道',116.464,39.9209,4,16,1),('110105004',110105,'三里屯街道','三里屯街道',116.448,39.9371,4,29,1),('110105005',110105,'左家庄街道','左家庄街道',116.452,39.9494,4,43,1),('110105006',110105,'香河园街道','香河园街道',116.439,39.9612,4,39,1),('110105007',110105,'和平街街道','和平街街道',116.486,39.9215,4,15,1),('110105008',110105,'安贞街道','安贞街道',116.401,39.968,4,1,1),('110105009',110105,'亚运村街道','亚运村街道',116.409,39.9842,4,42,1),('110105010',110105,'小关街道','小关街道',116.413,39.9775,4,40,1),('110105011',110105,'酒仙桥街道','酒仙桥街道',116.49,39.9643,4,21,1),('110105012',110105,'麦子店街道','麦子店街道',116.472,39.9469,4,24,1),('110105013',110105,'团结湖街道','团结湖街道',116.463,39.9315,4,35,1),('110105014',110105,'六里屯街道','六里屯街道',116.48,39.9282,4,23,1),('110105015',110105,'八里庄街道','八里庄街道',116.479,39.915,4,3,1),('110105016',110105,'双井街道','双井街道',116.449,39.888,4,32,1),('110105017',110105,'劲松街道','劲松街道',116.46,39.8849,4,19,1),('110105018',110105,'潘家园街道','潘家园街道',116.451,39.8749,4,26,1),('110105019',110105,'垡头街道','垡头街道',116.511,39.8676,4,11,1),('110105021',110105,'南磨房','南磨房',116.478,39.8836,4,25,1),('110105022',110105,'高碑店','高碑店',116.534,39.9046,4,12,1),('110105023',110105,'将台','将台',116.489,39.9689,4,17,1),('110105024',110105,'太阳宫','太阳宫',116.443,39.9731,4,34,1),('110105025',110105,'大屯街道','大屯街道',116.486,39.9215,4,7,1),('110105026',110105,'望京街道','望京街道',116.469,39.9928,4,36,1),('110105027',110105,'小红门','小红门',116.449,39.8137,4,41,1),('110105028',110105,'十八里店','十八里店',116.483,39.8514,4,30,1),('110105029',110105,'平房','平房',116.486,39.9215,4,27,1),('110105030',110105,'东风','东风',116.486,39.9215,4,9,1),('110105031',110105,'奥运村街道','奥运村街道',116.486,39.9215,4,2,1),('110105032',110105,'来广营','来广营',116.434,40.032,4,22,1),('110105033',110105,'常营','常营',116.587,39.9324,4,4,1),('110105034',110105,'三间房','三间房',116.58,39.908,4,28,1),('110105035',110105,'管庄','管庄',116.593,39.9107,4,13,1),('110105036',110105,'金盏','金盏',116.569,40.003,4,20,1),('110105037',110105,'孙河','孙河',116.524,40.0411,4,33,1),('110105038',110105,'崔各庄','崔各庄',116.515,40.0007,4,6,1),('110105039',110105,'东坝','东坝',116.546,39.9687,4,8,1),('110105040',110105,'黑庄户','黑庄户',116.597,39.8533,4,14,1),('110105041',110105,'豆各庄','豆各庄',116.573,39.873,4,10,1),('110105042',110105,'王四营','王四营',116.531,39.8752,4,38,1),('110105043',110105,'首都机场街道','首都机场街道',116.591,40.0482,4,31,1),('110105501',110105,'望京开发街道','望京开发街道',116.486,39.9215,4,37,1),('110106',110100,'丰台区','丰台',116.287,39.8636,3,6,1),('110106001',110106,'右安门街道','右安门街道',116.37,39.8612,4,18,1),('110106002',110106,'太平桥街道','太平桥街道',116.32,39.8834,4,13,1),('110106003',110106,'西罗园街道','西罗园街道',116.384,39.8644,4,16,1),('110106004',110106,'大红门街道','大红门街道',116.407,39.8383,4,1,1),('110106005',110106,'南苑街道','南苑街道',116.394,39.8053,4,12,1),('110106006',110106,'东高地街道','东高地街道',116.421,39.8072,4,2,1),('110106007',110106,'东铁匠营街道','东铁�