2017 最新全国行政地址表 sqlserver mysql excel

/* Navicat SQL Server Data Transfer Source Server : 119.23.107.103 sqlserver Source Server Version : 110000 Source Host : 119.23.107.103:1433 Source Database : concrete Source Schema : dbo Target Server Type : SQL Server Target Server Version : 110000 File Encoding : 65001 Date: 2017-11-10 15:29:55 */ -- ---------------------------- -- Table structure for area -- ---------------------------- DROP TABLE [dbo].[area] GO CREATE TABLE [dbo].[area] ( [id] int NOT NULL , [name] nvarchar(255) NULL , [code] nchar(6) NULL , [pcode] nchar(6) NULL ) GO -- ---------------------------- -- Records of area -- ---------------------------- INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'1', N'北京市', N'110000', N'0 ') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'2', N'市辖区', N'110100', N'110000') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'3', N'东城区', N'110101', N'110100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'4', N'西城区', N'110102', N'110100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'5', N'朝阳区', N'110105', N'110100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'6', N'丰台区', N'110106', N'110100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'7', N'石景山区', N'110107', N'110100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'8', N'海淀区', N'110108', N'110100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'9', N'门头沟区', N'110109', N'110100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'10', N'房山区', N'110111', N'110100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'11', N'通州区', N'110112', N'110100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'12', N'顺义区', N'110113', N'110100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'13', N'昌平区', N'110114', N'110100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'14', N'大兴区', N'110115', N'110100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'15', N'怀柔区', N'110116', N'110100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'16', N'平谷区', N'110117', N'110100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'17', N'密云区', N'110118', N'110100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'18', N'延庆区', N'110119', N'110100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'19', N'天津市', N'120000', N'0 ') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'20', N'市辖区', N'120100', N'120000') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'21', N'和平区', N'120101', N'120100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'22', N'河东区', N'120102', N'120100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'23', N'河西区', N'120103', N'120100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'24', N'南开区', N'120104', N'120100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'25', N'河北区', N'120105', N'120100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'26', N'红桥区', N'120106', N'120100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'27', N'东丽区', N'120110', N'120100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'28', N'西青区', N'120111', N'120100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'29', N'津南区', N'120112', N'120100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'30', N'北辰区', N'120113', N'120100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'31', N'武清区', N'120114', N'120100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'32', N'宝坻区', N'120115', N'120100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'33', N'滨海新区', N'120116', N'120100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'34', N'宁河区', N'120117', N'120100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'35', N'静海区', N'120118', N'120100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'36', N'蓟州区', N'120119', N'120100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'37', N'河北省', N'130000', N'0 ') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'38', N'石家庄市', N'130100', N'130000') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'39', N'市辖区', N'130101', N'130100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'40', N'长安区', N'130102', N'130100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'41', N'桥西区', N'130104', N'130100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'42', N'新华区', N'130105', N'130100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'43', N'井陉矿区', N'130107', N'130100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'44', N'裕华区', N'130108', N'130100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'45', N'藁城区', N'130109', N'130100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'46', N'鹿泉区', N'130110', N'130100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'47', N'栾城区', N'130111', N'130100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'48', N'井陉县', N'130121', N'130100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'49', N'正定县', N'130123', N'130100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'50', N'行唐县', N'130125', N'130100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'51', N'灵寿县', N'130126', N'130100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'52', N'高邑县', N'130127', N'130100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'53', N'深泽县', N'130128', N'130100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'54', N'赞皇县', N'130129', N'130100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'55', N'无极县', N'130130', N'130100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'56', N'平山县', N'130131', N'130100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'57', N'元氏县', N'130132', N'130100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'58', N'赵县', N'130133', N'130100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'59', N'晋州市', N'130183', N'130100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'60', N'新乐市', N'130184', N'130100') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'61', N'唐山市', N'130200', N'130000') GO GO INSERT INTO [dbo].[area] ([id], [name], [code], [pcode]) VALUES (N'62', N'市辖区', N'130201', N'130200') GO GO INSERT INTO [dbo].[area] (