SET IDENTITY_INSERT [dbo].[Area] ON
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (1, 1, N'东城区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (2, 1, N'西城区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (3, 1, N'崇文区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (4, 1, N'宣武区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (5, 1, N'朝阳区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (6, 1, N'丰台区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (7, 1, N'石景山区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (8, 1, N'海淀区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (9, 1, N'门头沟区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (10, 1, N'房山区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (11, 1, N'通州区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (12, 1, N'顺义区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (13, 1, N'昌平区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (14, 1, N'大兴区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (15, 1, N'怀柔区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (16, 1, N'平谷区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (17, 1, N'密云县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (18, 1, N'延庆县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (19, 2, N'和平区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (20, 2, N'河东区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (21, 2, N'河西区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (22, 2, N'南开区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (23, 2, N'河北区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (24, 2, N'红桥区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (25, 2, N'塘沽区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (26, 2, N'汉沽区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (27, 2, N'大港区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (28, 2, N'东丽区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (29, 2, N'西青区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (30, 2, N'津南区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (31, 2, N'北辰区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (32, 2, N'武清区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (33, 2, N'宝坻区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (34, 2, N'宁河县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (35, 2, N'静海县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (36, 2, N'蓟县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (37, 3, N'长安区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (38, 3, N'桥东区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (39, 3, N'桥西区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (40, 3, N'新华区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (41, 3, N'井陉矿区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (42, 3, N'裕华区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (43, 3, N'井陉县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (44, 3, N'正定县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (45, 3, N'栾城县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (46, 3, N'行唐县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (47, 3, N'灵寿县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (48, 3, N'高邑县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (49, 3, N'深泽县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (50, 3, N'赞皇县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (51, 3, N'无极县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (52, 3, N'平山县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (53, 3, N'元氏县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (54, 3, N'赵县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (55, 3, N'辛集市', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (56, 3, N'藁城市', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (57, 3, N'晋州市', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (58, 3, N'新乐市', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (59, 3, N'鹿泉市', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (60, 4, N'路南区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (61, 4, N'路北区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (62, 4, N'古冶区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (63, 4, N'开平区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (64, 4, N'丰南区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (65, 4, N'丰润区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (66, 4, N'滦县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (67, 4, N'滦南县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (68, 4, N'乐亭县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (69, 4, N'迁西县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (70, 4, N'玉田县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (71, 4, N'唐海县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (72, 4, N'遵化市', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (73, 4, N'迁安市', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (74, 5, N'海港区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (75, 5, N'山海关区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (76, 5, N'北戴河区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (77, 5, N'青龙县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (78, 5, N'昌黎县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (79, 5, N'抚宁县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (80, 5, N'卢龙县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (81, 6, N'邯山区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (82, 6, N'丛台区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (83, 6, N'复兴区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (84, 6, N'峰峰矿区', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (85, 6, N'邯郸县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (86, 6, N'临漳县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (87, 6, N'成安县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (88, 6, N'大名县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (89, 6, N'涉县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (90, 6, N'磁县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (91, 6, N'肥乡县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (92, 6, N'永年县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (93, 6, N'邱县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (94, 6, N'鸡泽县', 1)
INSERT [dbo].[Area] ([Id], [CityId], [Name], [State]) VALUES (95, 6, N