2018年中国行政区划分五级

-- MySQL dump 10.13 Distrib 5.7.17, for macos10.12 (x86_64) -- -- Host: localhost Database: tjj -- ------------------------------------------------------ -- Server version 8.0.11 /*!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 `datas` -- DROP TABLE IF EXISTS `datas`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `datas` ( `id` bigint(36) unsigned NOT NULL, `province_name` varchar(100) DEFAULT NULL, `city_name` varchar(256) DEFAULT NULL, `area_name` varchar(256) DEFAULT NULL, `town_name` varchar(256) DEFAULT NULL, `code` varchar(256) DEFAULT NULL, `country_code` varchar(256) DEFAULT NULL, `country_name` varchar(256) DEFAULT NULL, `location` varchar(256) DEFAULT NULL, `adcode` varchar(256) DEFAULT NULL, `gd_level` varchar(256) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `datas` -- LOCK TABLES `datas` WRITE; /*!40000 ALTER TABLE `datas` DISABLE KEYS */; INSERT INTO `datas` VALUES (110101001001,'北京市','市辖区','东城区','东华门街道办事处','110101001001','111','多福巷社区居委会','116.413146,39.922958','110101','村庄'),(110101001002,'北京市','市辖区','东城区','东华门街道办事处','110101001002','111','银闸社区居委会','116.406051,39.919478','110101','村庄'),(110101001005,'北京市','市辖区','东城区','东华门街道办事处','110101001005','111','东厂社区居委会','116.408328,39.923083','110101','村庄'),(110101001006,'北京市','市辖区','东城区','东华门街道办事处','110101001006','111','智德社区居委会','116.402984,39.917822','110101','村庄'),(110101001007,'北京市','市辖区','东城区','东华门街道办事处','110101001007','111','南池子社区居委会','116.404393,39.911838','110101','村庄'),(110101001008,'北京市','市辖区','东城区','东华门街道办事处','110101001008','111','黄图岗社区居委会','116.408885,39.920967','110101','村庄'),(110101001009,'北京市','市辖区','东城区','东华门街道办事处','110101001009','111','灯市口社区居委会','116.416000,39.918361','110101','村庄'),(110101001010,'北京市','市辖区','东城区','东华门街道办事处','110101001010','111','正义路社区居委会','116.406338,39.902261','110101','村庄'),(110101001011,'北京市','市辖区','东城区','东华门街道办事处','110101001011','111','甘雨社区居委会','116.416936,39.916906','110101','村庄'),(110101001013,'北京市','市辖区','东城区','东华门街道办事处','110101001013','111','台基厂社区居委会','116.415543,39.905297','110101','村庄'),(110101001014,'北京市','市辖区','东城区','东华门街道办事处','110101001014','111','韶九社区居委会','116.407328,39.916841','110101','村庄'),(110101001015,'北京市','市辖区','东城区','东华门街道办事处','110101001015','111','王府井社区居委会','116.414757,39.914358','110101','村庄'),(110101002001,'北京市','市辖区','东城区','景山街道办事处','110101002001','111','隆福寺社区居委会','116.412882,39.926039','110101','村庄'),(110101002002,'北京市','市辖区','东城区','景山街道办事处','110101002002','111','吉祥社区居委会','116.404745,39.932053','110101','村庄'),(110101002003,'北京市','市辖区','东城区','景山街道办事处','110101002003','111','黄化门社区居委会','116.400582,39.930402','110101','村庄'),(110101002004,'北京市','市辖区','东城区','景山街道办事处','110101002004','111','钟鼓社区居委会','116.403456,39.929010','110101','村庄'),(110101002005,'北京市','市辖区','东城区','景山街道办事处','110101002005','111','魏家社区居委会','116.416054,39.929845','110101','村庄'),(110101002006,'北京市','市辖区','东城区','景山街道办事处','110101002006','111','汪芝麻社区居委会','116.412070,39.932645','110101','村庄'),(110101002008,'北京市','市辖区','东城区','景山街道办事处','110101002008','111','景山东街社区居委会','116.402242,39.925514','110101','村庄'),(110101002009,'北京市','市辖区','东城区','景山街道办事处','110101002009','111','皇城根北街社区居委会','116.406838,39.925927','110101','村庄'),(110101003001,'北京市','市辖区','东城区','交道口街道办事处','110101003001','111','交东社区居委会','116.412251,39.940607','110101','村庄'),(110101003002,'北京市','市辖区','东城区','交道口街道办事处','110101003002','111','福祥社区居委会','116.398965,39.936243','110101','村庄'),(110101003003,'北京市','市辖区','东城区','交道口街道办事处','110101003003','111','大兴社区居委会','116.409757,39.938427','110101','村庄'),(110101003005,'北京市','市辖区','东城区','交道口街道办事处','110101003005','111','府学社区居委会','116.411456,39.935190','110101','村庄'),(110101003007,'北京市','市辖区','东城区','交道口街道办事处','110101003007','111','鼓楼苑社区居委会','116.400635,39.938978','110101','村庄'),(110101003008,'北京市','市辖区','东城区','交道口街道办事处','110101003008','111','菊儿社区居委会','116.405676,39.939335','110101','村庄'),(110101003009,'北京市','市辖区','东城区','交道口街道办事处','110101003009','111','南锣鼓巷社区居委会','116.400906,39.935869','110101','乡镇'),(110101004001,'北京市','市辖区','东城区','安定门街道办事处','110101004001','111','交北头条社区居委会','116.409921,39.941843','110101','村庄'),(110101004002,'北京市','市辖区','东城区','安定门街道办事处','110101004002','111','北锣鼓巷社区居委会','116.402618,39.948140','110101','村庄'),(110101004003,'北京市','市辖区','东城区','安定门街道办事处','110101004003','111','国子监社区居委会','116.415476,39.946554','110101','村庄'),(110101004004,'北京市','市辖区','东城区','安定门街道办事处','110101004004','111','钟楼湾社区居委会','116.397712,39.942132','110101','村庄'),(110101004005,'北京市','市辖区','东城区','安定门街道办事处','110101004005','111','宝钞南社区居委会','116.401922,39.944594','110101','村庄'),(110101004006,'北京市','市辖区','东城区','安定门街道办事处','110101004006','111','五道营社区居委会','116.410045,39.947029','110101','村庄'),(110101004009,'北京市','市辖区','东城区','安定门街道办事处','110101004009','111','分司厅社区居委会','116.405262,39.942640','110101','村庄'),(110101004011,'北京市','市辖区','东城区','安定门街道办事处','110101004011','111','国旺社区居委会','116.397536,39.946825','110101','村庄'),(110101004012,'北京市','市辖区','东城区','安定门街道办事处','110101004012','111','花园社区居委会','116.403428,39.944567','110101','村庄'),(110101005001,'北京市','市辖区','东城区','北新桥街道办事处','110101005001','111','海运仓社区居委会','116.428644,39.935714','110101','村庄'),(110101005002,'北京市','市辖区','东城区','北新桥街道办事处','110101005002','111','北新仓社区居委会','116.428513,39.940835','110101','村庄'),(110101005004,'�