全世界国家对应城市及国内城市地区街道数据库

/* Navicat MySQL Data Transfer Source Server : 192.168.88.2 Source Server Version : 50626 Source Host : 192.168.88.2:3306 Source Database : search Target Server Type : MYSQL Target Server Version : 50626 File Encoding : 65001 Date: 2015-11-19 10:51:05 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for t_region -- ---------------------------- DROP TABLE IF EXISTS `t_region`; CREATE TABLE `t_region` ( `CODE` varchar(20) NOT NULL COMMENT '区位码', `country_code` varchar(20) DEFAULT NULL COMMENT '国家代码', `region_name_e` varchar(80) DEFAULT NULL COMMENT '地区名称英文', `region_name_c` varchar(50) DEFAULT NULL COMMENT '地区名称中文', `level` varchar(20) DEFAULT NULL COMMENT '级别', `upper_region` varchar(20) DEFAULT NULL COMMENT '上级地区', PRIMARY KEY (`CODE`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='地区'; -- ---------------------------- -- Records of t_region -- ---------------------------- INSERT INTO `t_region` VALUES ('11', 'CN', 'beijingshi', '北京市', '1', '0'); INSERT INTO `t_region` VALUES ('1101', 'CN', 'shixiaqu', '市辖区', '2', '11'); INSERT INTO `t_region` VALUES ('110101', 'CN', 'dongchengqu', '东城区', '3', '1101'); INSERT INTO `t_region` VALUES ('110101001', 'CN', 'donghuamenjiedao', '东华门街道', '4', '110101'); INSERT INTO `t_region` VALUES ('110101002', 'CN', 'jingshanjiedao', '景山街道', '4', '110101'); INSERT INTO `t_region` VALUES ('110101003', 'CN', 'jiaodaokoujiedao', '交道口街道', '4', '110101'); INSERT INTO `t_region` VALUES ('110101004', 'CN', 'andingmenjiedao', '安定门街道', '4', '110101'); INSERT INTO `t_region` VALUES ('110101005', 'CN', 'beixinqiaojiedao', '北新桥街道', '4', '110101'); INSERT INTO `t_region` VALUES ('110101006', 'CN', 'dongsijiedao', '东四街道', '4', '110101'); INSERT INTO `t_region` VALUES ('110101007', 'CN', 'chaoyangmenjiedao', '朝阳门街道', '4', '110101'); INSERT INTO `t_region` VALUES ('110101008', 'CN', 'jianguomenjiedao', '建国门街道', '4', '110101'); INSERT INTO `t_region` VALUES ('110101009', 'CN', 'dongzhimenjiedao', '东直门街道', '4', '110101'); INSERT INTO `t_region` VALUES ('110101010', 'CN', 'hepinglijiedao', '和平里街道', '4', '110101'); INSERT INTO `t_region` VALUES ('110102', 'CN', 'xichengqu', '西城区', '3', '1101'); INSERT INTO `t_region` VALUES ('110102001', 'CN', 'xizhanganjiejiedao', '西长安街街道', '4', '110102'); INSERT INTO `t_region` VALUES ('110102003', 'CN', 'xinjiekoujiedao', '新街口街道', '4', '110102'); INSERT INTO `t_region` VALUES ('110102007', 'CN', 'yuetanjiedao', '月坛街道', '4', '110102'); INSERT INTO `t_region` VALUES ('110102009', 'CN', 'zhanlanlujiedao', '展览路街道', '4', '110102'); INSERT INTO `t_region` VALUES ('110102010', 'CN', 'deshengjiedao', '德胜街道', '4', '110102'); INSERT INTO `t_region` VALUES ('110102011', 'CN', 'jinrongjiejiedao', '金融街街道', '4', '110102'); INSERT INTO `t_region` VALUES ('110102012', 'CN', 'shenchahaijiedao', '什刹海街道', '4', '110102'); INSERT INTO `t_region` VALUES ('110103', 'CN', 'chongwenqu', '崇文区', '3', '1101'); INSERT INTO `t_region` VALUES ('110103001', 'CN', 'qianmenjiedao', '前门街道', '4', '110103'); INSERT INTO `t_region` VALUES ('110103002', 'CN', 'chongwenmenwaijiedao', '崇文门外街道', '4', '110103'); INSERT INTO `t_region` VALUES ('110103003', 'CN', 'donghuashijiedao', '东花市街道', '4', '110103'); INSERT INTO `t_region` VALUES ('110103004', 'CN', 'longtanjiedao', '龙潭街道', '4', '110103'); INSERT INTO `t_region` VALUES ('110103005', 'CN', 'tiyuguanlujiedao', '体育馆路街道', '4', '110103'); INSERT INTO `t_region` VALUES ('110103006', 'CN', 'tiantanjiedao', '天坛街道', '4', '110103'); INSERT INTO `t_region` VALUES ('110103007', 'CN', 'yongdingmenwaijiedao', '永定门外街道', '4', '110103'); INSERT INTO `t_region` VALUES ('110104', 'CN', 'xuanwuqu', '宣武区', '3', '1101'); INSERT INTO `t_region` VALUES ('110104001', 'CN', 'dazhalanjiedao', '大栅栏街道', '4', '110104'); INSERT INTO `t_region` VALUES ('110104002', 'CN', 'tianqiaojiedao', '天桥街道', '4', '110104'); INSERT INTO `t_region` VALUES ('110104003', 'CN', 'chunshujiedao', '椿树街道', '4', '110104'); INSERT INTO `t_region` VALUES ('110104004', 'CN', 'taorantingjiedao', '陶然亭街道', '4', '110104'); INSERT INTO `t_region` VALUES ('110104005', 'CN', 'guanganmenneijiedao', '广安门内街道', '4', '110104'); INSERT INTO `t_region` VALUES ('110104006', 'CN', 'niujiejiedao', '牛街街道', '4', '110104'); INSERT INTO `t_region` VALUES ('110104007', 'CN', 'baizhifangjiedao', '白纸坊街道', '4', '110104'); INSERT INTO `t_region` VALUES ('110104008', 'CN', 'guanganmenwaijiedao', '广安门外街道', '4', '110104'); INSERT INTO `t_region` VALUES ('110105', 'CN', 'chaoyangqu', '朝阳区', '3', '1101'); INSERT INTO `t_region` VALUES ('110105001', 'CN', 'jianwaijiedao', '建外街道', '4', '110105'); INSERT INTO `t_region` VALUES ('110105002', 'CN', 'chaowaijiedao', '朝外街道', '4', '110105'); INSERT INTO `t_region` VALUES ('110105003', 'CN', 'hujialoujiedao', '呼家楼街道', '4', '110105'); INSERT INTO `t_region` VALUES ('110105004', 'CN', 'sanlitunjiedao', '三里屯街道', '4', '110105'); INSERT INTO `t_region` VALUES ('110105005', 'CN', 'zuojiazhuangjiedao', '左家庄街道', '4', '110105'); INSERT INTO `t_region` VALUES ('110105006', 'CN', 'xiangheyuanjiedao', '香河园街道', '4', '110105'); INSERT INTO `t_region` VALUES ('110105007', 'CN', 'hepingjiejiedao', '和平街街道', '4', '110105'); INSERT INTO `t_region` VALUES ('110105008', 'CN', 'anzhenjiedao', '安贞街道', '4', '110105'); INSERT INTO `t_region` VALUES ('110105009', 'CN', 'yayuncunjiedao', '亚运村街道', '4', '110105'); INSERT INTO `t_region` VALUES ('110105010', 'CN', 'xiaoguanjiedao', '小关街道', '4', '110105'); INSERT INTO `t_region` VALUES ('110105011', 'CN', 'jiuxianqiaojiedao', '酒仙桥街道', '4', '110105'); INSERT INTO `t_region` VALUES ('110105012', 'CN', 'maizidianjiedao', '麦子店街道', '4', '110105'); INSERT INTO `t_region` VALUES ('110105013', 'CN', 'tuanjiehujiedao', '团结湖街道', '4', '110105'); INSERT INTO `t_region` VALUES ('110105014', 'CN', 'liulitunjiedao', '六里屯街道', '4', '110105'); INSERT INTO `t_region` VALUES ('110105015', 'CN', 'balizhuangjiedao', '八里庄街道', '4', '110105'); INSERT INTO `t_region` VALUES ('110105016', 'CN', 'shuangjingjiedao', '双井街道', '4', '110105'); INSERT INTO `t_region` VALUES ('110105017', 'CN', 'jingsongjiedao', '劲松街道', '4', '110105'); INSERT INTO `t_region` VALUES ('110105018', 'CN', 'panjiayuanjiedao', '潘家园街道', '4', '110105'); INSERT INTO `t_region` VALUES ('110105019', 'CN', 'fatoujiedao', '垡头街道', '4', '110105'); INSERT INTO `t_region` VALUES ('110105021', 'CN', 'nanmofangdiqu', '南磨房地区', '4', '110105'); INSERT INTO `t_region` VALUES ('110105022', 'CN', 'gaobeidiandiqu', '高碑店地区', '4', '110105'); INSERT INTO `t_region` VALUES ('110105023', 'CN', 'jiangtaidiqu', '将台地区', '4', '110105'); INSERT INTO `t_region` VALUES ('110105024', 'CN', 'taiyanggongdiqu', '太阳宫地区', '4', '110105'); INSERT INTO `t_region` VALUES ('110105025', 'CN', 'datunjiedao', '大屯街道', '4', '110105'); INSERT INTO `t_region` VALUES ('110105026', 'CN', 'wangjingjiedao', '望京街道', '4', '110105'); INSERT INTO `t_region` VALUES ('110105027', 'CN', 'xiaohongmendiqu', '小红门地区', '4', '110105'); INSERT INTO `t_region` VALUES ('110105028', 'CN', 'shibalidiandiqu', '十八里店地区', '4', '110105'); INSERT INTO `t_region` VALUES ('110105029', 'CN', 'pingfangdiqu', '平房地区', '4', '110105'); INSERT INTO `t_region` VALUES ('110105030', 'CN', 'dongfengdiqu', '东风地区', '4',