# Host: localhost (Version: 5.1.73-community)
# Date: 2016-12-16 13:57:14
# Generator: MySQL-Front 5.3 (Build 4.234)
/*!40101 SET NAMES utf8 */;
#
# Structure for table "tb_city"
#
DROP TABLE IF EXISTS `tb_city`;
CREATE TABLE `tb_city` (
`city_id` varchar(12) NOT NULL DEFAULT '',
`city_name` varchar(50) NOT NULL DEFAULT '',
`up_id` varchar(9) NOT NULL DEFAULT '',
`kind_id` varchar(1) NOT NULL DEFAULT '' COMMENT '1省份;2城市;3区县;4街道',
PRIMARY KEY (`city_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='全国省市区街道数据';
#
# Data for table "tb_city"
#
INSERT INTO `tb_city` VALUES ('0','全国','*','0'),('11','北京','0','1'),('1101','北京市','11','2'),('110101','东城区','1101','3'),('110101001','东华门街道','110101','4'),('110101002','景山街道','110101','4'),('110101003','交道口街道','110101','4'),('110101004','安定门街道','110101','4'),('110101005','北新桥街道','110101','4'),('110101006','东四街道','110101','4'),('110101007','朝阳门街道','110101','4'),('110101008','建国门街道','110101','4'),('110101009','东直门街道','110101','4'),('110101010','和平里街道','110101','4'),('110102','西城区','1101','3'),('110102001','西长安街街道','110102','4'),('110102003','新街口街道','110102','4'),('110102007','月坛街道','110102','4'),('110102009','展览路街道','110102','4'),('110102010','德胜街道','110102','4'),('110102011','金融街街道','110102','4'),('110102012','什刹海街道','110102','4'),('110103','崇文区','1101','3'),('110103001','前门街道','110103','4'),('110103002','崇文门外街道','110103','4'),('110103003','东花市街道','110103','4'),('110103004','龙潭街道','110103','4'),('110103005','体育馆路街道','110103','4'),('110103006','天坛街道','110103','4'),('110103007','永定门外街道','110103','4'),('110104','宣武区','1101','3'),('110104001','大栅栏街道','110104','4'),('110104002','天桥街道','110104','4'),('110104003','椿树街道','110104','4'),('110104004','陶然亭街道','110104','4'),('110104005','广安门内街道','110104','4'),('110104006','牛街街道','110104','4'),('110104007','白纸坊街道','110104','4'),('110104008','广安门外街道','110104','4'),('110105','朝阳区','1101','3'),('110105001','建外街道','110105','4'),('110105002','朝外街道','110105','4'),('110105003','呼家楼街道','110105','4'),('110105004','三里屯街道','110105','4'),('110105005','左家庄街道','110105','4'),('110105006','香河园街道','110105','4'),('110105007','和平街街道','110105','4'),('110105008','安贞街道','110105','4'),('110105009','亚运村街道','110105','4'),('110105010','小关街道','110105','4'),('110105011','酒仙桥街道','110105','4'),('110105012','麦子店街道','110105','4'),('110105013','团结湖街道','110105','4'),('110105014','六里屯街道','110105','4'),('110105015','八里庄街道','110105','4'),('110105016','双井街道','110105','4'),('110105017','劲松街道','110105','4'),('110105018','潘家园街道','110105','4'),('110105019','垡头街道','110105','4'),('110105021','南磨房地区','110105','4'),('110105022','高碑店地区','110105','4'),('110105023','将台地区','110105','4'),('110105024','太阳宫地区','110105','4'),('110105025','大屯街道','110105','4'),('110105026','望京街道','110105','4'),('110105027','小红门地区','110105','4'),('110105028','十八里店地区','110105','4'),('110105029','平房地区','110105','4'),('110105030','东风地区','110105','4'),('110105031','奥运村地区','110105','4'),('110105032','来广营地区','110105','4'),('110105033','常营回族地区','110105','4'),('110105034','三间房地区','110105','4'),('110105035','管庄地区','110105','4'),('110105036','金盏地区','110105','4'),('110105037','孙河地区','110105','4'),('110105038','崔各庄地区','110105','4'),('110105039','东坝地区','110105','4'),('110105040','黑庄户地区','110105','4'),('110105041','豆各庄地区','110105','4'),('110105042','王四营地区','110105','4'),('110105400','首都机场街道','110105','4'),('110105501','望京开发街道','110105','4'),('110106','丰台区','1101','3'),('110106001','右安门街道','110106','4'),('110106002','太平桥街道','110106','4'),('110106003','西罗园街道','110106','4'),('110106004','大红门街道','110106','4'),('110106005','南苑街道','110106','4'),('110106006','东高地街道','110106','4'),('110106007','东铁匠营街道','110106','4'),('110106008','卢沟桥街道','110106','4'),('110106009','丰台街道','110106','4'),('110106010','新村街道','110106','4'),('110106011','长辛店街道','110106','4'),('110106012','云岗街道','110106','4'),('110106013','方庄地区','110106','4'),('110106014','宛平城地区','110106','4'),('110106015','马家堡街道','110106','4'),('110106016','和义街道','110106','4'),('110106100','长辛店镇','110106','4'),('110106101','王佐镇','110106','4'),('110106201','卢沟桥乡','110106','4'),('110106202','花乡','110106','4'),('110106203','南苑乡','110106','4'),('110107','石景山区','1101','3'),('110107001','八宝山街道','110107','4'),('110107002','老山街道','110107','4'),('110107003','八角街道','110107','4'),('110107004','古城街道','110107','4'),('110107005','苹果园街道','110107','4'),('110107006','金顶街街道','110107','4'),('110107009','广宁街道','110107','4'),('110107010','五里坨街道','110107','4'),('110107011','鲁谷社区行政事务管理中心','110107','4'),('110108','海淀区','1101','3'),('110108001','万寿路街道','110108','4'),('110108002','永定路街道','110108','4'),('110108003','羊坊店街道','110108','4'),('110108004','甘家口街道','110108','4'),('110108005','八里庄街道','110108','4'),('110108006','紫竹院街道','110108','4'),('110108007','北下关街道','110108','4'),('110108008','北太平庄街道','110108','4'),('110108010','学院路街道','110108','4'),('110108011','中关村街道','110108','4'),('110108012','海淀街道','110108','4'),('110108013','青龙桥街道','110108','4'),('110108014','清华园街道','110108','4'),('110108015','燕园街道','110108','4'),('110108016','香山街道','110108','4'),('110108017','清河街道','110108','4'),('110108018','花园路街道','110108','4'),('110108019','西三旗街道','110108','4'),('110108020','马连洼街道','110108','4'),('110108021','田村路街道','110108','4'),('110108022','上地街道','110108','4'),('110108023','万柳地区','110108','4'),('110108024','东升地区','110108','4'),('110108025','曙光街道','110108','4'),('110108101','温泉镇','110108','4'),('110108102','四季青镇','110108','4'),('110108103','西北旺镇','110108','4'),('110108104','苏家坨镇','110108','4'),('110108105','上庄镇','110108','4'),('110109','门头沟区','1101','3'),('110109001','大峪街道','110109','4'),('110109002','城子街道','110109','4'),('110109003','东辛房街道','110109','4'),('110109004','大台街道','110109','4'),('110109005','王平地区','110109','4'),('110109101','潭柘寺镇','110109','4'),('110109102','永定镇','110109','4'),('110109103','龙泉镇','110109','4'),('110109104','军庄镇','110109','4'),('110109105','雁翅镇','110109','4'),('110109106','斋堂镇','110109','4'),('110109107','清水镇','110109','4'),('110109108','妙峰山镇','110109','4'),('110111','房山区','1101','3'),('110111001','城关街道','110111','4'),('110111002','新镇街道','110111','4'),('110111004','向阳街道','110111','4'),('110111005','东风街道','110111','4'),('110111006','迎风街道','110111','4'),('110111007','星城街道','110111','4'),('110111008','良乡地区','110111','4'),('110111009','周口店地区','110111','4'),('110111010','琉璃河地区','110111','4'),('110111011','拱辰街道','110111','4'),('110111012','西潞街道','110111','4'),('110111101','阎�
- 1
- 2
- 3
前往页