全国行政区划数据（excel和sql）

# -------------------------------------------------------- # Host: 192.168.1.109 # Database: ally # Server version: 5.5.23 # Server OS: Win32 # HeidiSQL version: 5.0.0.3272 # Date/time: 2014-07-25 16:16:14 # -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET NAMES utf8 */; /*!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' */; # Dumping structure for table ally.t_prov_city_area_street DROP TABLE IF EXISTS `t_prov_city_area_street`; CREATE TABLE IF NOT EXISTS `t_prov_city_area_street` ( `id` int(11) NOT NULL AUTO_INCREMENT, `code` varchar(11) DEFAULT NULL, `parentId` varchar(11) DEFAULT NULL, `name` varchar(50) DEFAULT NULL, `level` tinyint(1) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=47496 DEFAULT CHARSET=utf8 COMMENT='全国省市区街道'; # Dumping data for table ally.t_prov_city_area_street: 48,370 rows DELETE FROM `t_prov_city_area_street`; /*!40000 ALTER TABLE `t_prov_city_area_street` DISABLE KEYS */; INSERT INTO `t_prov_city_area_street` (`id`, `code`, `parentId`, `name`, `level`) VALUES (1, '11', '0', '北京市', 1), (2, '1101', '11', '市辖区', 2), (3, '110101', '1101', '东城区', 3), (4, '110101001', '110101', '东华门街道', 4), (5, '110101002', '110101', '景山街道', 4), (6, '110101003', '110101', '交道口街道', 4), (7, '110101004', '110101', '安定门街道', 4), (8, '110101005', '110101', '北新桥街道', 4), (9, '110101006', '110101', '东四街道', 4), (10, '110101007', '110101', '朝阳门街道', 4), (11, '110101008', '110101', '建国门街道', 4), (12, '110101009', '110101', '东直门街道', 4), (13, '110101010', '110101', '和平里街道', 4), (14, '110102', '1101', '西城区', 3), (15, '110102001', '110102', '西长安街街道', 4), (16, '110102003', '110102', '新街口街道', 4), (17, '110102007', '110102', '月坛街道', 4), (18, '110102009', '110102', '展览路街道', 4), (19, '110102010', '110102', '德胜街道', 4), (20, '110102011', '110102', '金融街街道', 4), (21, '110102012', '110102', '什刹海街道', 4), (22, '110103', '1101', '崇文区', 3), (23, '110103001', '110103', '前门街道', 4), (24, '110103002', '110103', '崇文门外街道', 4), (25, '110103003', '110103', '东花市街道', 4), (26, '110103004', '110103', '龙潭街道', 4), (27, '110103005', '110103', '体育馆路街道', 4), (28, '110103006', '110103', '天坛街道', 4), (29, '110103007', '110103', '永定门外街道', 4), (30, '110104', '1101', '宣武区', 3), (31, '110104001', '110104', '大栅栏街道', 4), (32, '110104002', '110104', '天桥街道', 4), (33, '110104003', '110104', '椿树街道', 4), (34, '110104004', '110104', '陶然亭街道', 4), (35, '110104005', '110104', '广安门内街道', 4), (36, '110104006', '110104', '牛街街道', 4), (37, '110104007', '110104', '白纸坊街道', 4), (38, '110104008', '110104', '广安门外街道', 4), (39, '110105', '1101', '朝阳区', 3), (40, '110105001', '110105', '建外街道', 4), (41, '110105002', '110105', '朝外街道', 4), (42, '110105003', '110105', '呼家楼街道', 4), (43, '110105004', '110105', '三里屯街道', 4), (44, '110105005', '110105', '左家庄街道', 4), (45, '110105006', '110105', '香河园街道', 4), (46, '110105007', '110105', '和平街街道', 4), (47, '110105008', '110105', '安贞街道', 4), (48, '110105009', '110105', '亚运村街道', 4), (49, '110105010', '110105', '小关街道', 4), (50, '110105011', '110105', '酒仙桥街道', 4), (51, '110105012', '110105', '麦子店街道', 4), (52, '110105013', '110105', '团结湖街道', 4), (53, '110105014', '110105', '六里屯街道', 4), (54, '110105015', '110105', '八里庄街道', 4), (55, '110105016', '110105', '双井街道', 4), (56, '110105017', '110105', '劲松街道', 4), (57, '110105018', '110105', '潘家园街道', 4), (58, '110105019', '110105', '垡头街道', 4), (59, '110105021', '110105', '南磨房地区', 4), (60, '110105022', '110105', '高碑店地区', 4), (61, '110105023', '110105', '将台地区', 4), (62, '110105024', '110105', '太阳宫地区', 4), (63, '110105025', '110105', '大屯街道', 4), (64, '110105026', '110105', '望京街道', 4), (65, '110105027', '110105', '小红门地区', 4), (66, '110105028', '110105', '十八里店地区', 4), (67, '110105029', '110105', '平房地区', 4), (68, '110105030', '110105', '东风地区', 4), (69, '110105031', '110105', '奥运村地区', 4), (70, '110105032', '110105', '来广营地区', 4), (71, '110105033', '110105', '常营回族地区', 4), (72, '110105034', '110105', '三间房地区', 4), (73, '110105035', '110105', '管庄地区', 4), (74, '110105036', '110105', '金盏地区', 4), (75, '110105037', '110105', '孙河地区', 4), (76, '110105038', '110105', '崔各庄地区', 4), (77, '110105039', '110105', '东坝地区', 4), (78, '110105040', '110105', '黑庄户地区', 4), (79, '110105041', '110105', '豆各庄地区', 4), (80, '110105042', '110105', '王四营地区', 4), (81, '110105400', '110105', '首都机场街道', 4), (82, '110105501', '110105', '望京开发街道', 4), (83, '110106', '1101', '丰台区', 3), (84, '110106001', '110106', '右安门街道', 4), (85, '110106002', '110106', '太平桥街道', 4), (86, '110106003', '110106', '西罗园街道', 4), (87, '110106004', '110106', '大红门街道', 4), (88, '110106005', '110106', '南苑街道', 4), (89, '110106006', '110106', '东高地街道', 4), (90, '110106007', '110106', '东铁匠营街道', 4), (91, '110106008', '110106', '卢沟桥街道', 4), (92, '110106009', '110106', '丰台街道', 4), (93, '110106010', '110106', '新村街道', 4), (94, '110106011', '110106', '长辛店街道', 4), (95, '110106012', '110106', '云岗街道', 4), (96, '110106013', '110106', '方庄地区', 4), (97, '110106014', '110106', '宛平城地区', 4), (98, '110106015', '110106', '马家堡街道', 4), (99, '110106016', '110106', '和义街道', 4), (100, '110106100', '110106', '长辛店镇', 4), (101, '110106101', '110106', '王佐镇', 4), (102, '110106201', '110106', '卢沟桥乡', 4), (103, '110106202', '110106', '花乡', 4), (104, '110106203', '110106', '南苑乡', 4), (105, '110107', '1101', '石景山区', 3), (106, '110107001', '110107', '八宝山街道', 4), (107, '110107002', '110107', '老山街道', 4), (108, '110107003', '110107', '八角街道', 4), (109, '110107004', '110107', '古城街道', 4), (110, '110107005', '110107', '苹果园街道', 4), (111, '110107006', '110107', '金顶街街道', 4), (112, '110107009', '110107', '广宁街道', 4), (113, '110107010', '110107', '五里坨街道', 4), (114, '110107011', '110107', '鲁谷社区行政事务管理中心', 4), (115, '110108', '1101', '海淀区', 3), (116, '110108001', '110108', '万寿路街道', 4), (117, '110108002', '110108', '永定路街道', 4), (118, '110108003', '110108', '羊坊店街道', 4), (119, '110108004', '110108', '甘家口街道', 4), (120, '110108005', '110108', '八里庄街道', 4), (121, '110108006', '110108', '紫竹院街道', 4), (122, '110108007', '110108', '北下关街道', 4), (123, '110108008', '110108', '北太平庄街道', 4), (124, '110108010', '110108', '学院路街道', 4), (125, '110108011', '110108', '中关村街道', 4), (126, '110108012', '110108', '海淀街道', 4), (127, '110108013', '110108', '青龙桥街道', 4), (128, '110108014', '110108', '清华园街道', 4), (129, '110108015', '110108', '燕园街道', 4), (130, '110108016', '110108', '香山街道', 4), (131, '110108017', '110108', '清河街道', 4), (132, '110108018', '110108', '花园路街道', 4), (133, '110108019', '110108', '西三旗街道', 4), (134, '110108020', '110108