USE [TaxAdmin8]
GO
/****** Object:  Table [dbo].[Region]    Script Date: 3/6/2018 1:54:10 PM ******/
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'100000', NULL, N'中国', N'中国', N'中国', 0, NULL, NULL, N'China', 116.368324, 39.9150848, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'110000', N'100000', N'北京市', N'北京', N'中国,北京', 1, NULL, NULL, N'Beijing', 116.405289, 39.9049873, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'110100', N'110000', N'北京市', N'北京', N'中国,北京,北京市', 2, N'010       ', 100000, N'Beijing', 116.405289, 39.9049873, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'110101', N'110100', N'东城区', N'东城', N'中国,北京,北京市,东城区', 3, N'010       ', 100010, N'Dongcheng', 116.410049, 39.93157, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'110102', N'110100', N'西城区', N'西城', N'中国,北京,北京市,西城区', 3, N'010       ', 100032, N'Xicheng', 116.360031, 39.9305, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'110105', N'110100', N'朝阳区', N'朝阳', N'中国,北京,北京市,朝阳区', 3, N'010       ', 100020, N'Chaoyang', 116.485481, 39.9484, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'110106', N'110100', N'丰台区', N'丰台', N'中国,北京,北京市,丰台区', 3, N'010       ', 100071, N'Fengtai', 116.286247, 39.8585, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'110107', N'110100', N'石景山区', N'石景山', N'中国,北京,北京市,石景山区', 3, N'010       ', 100043, N'Shijingshan', 116.2229, 39.90564, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'110108', N'110100', N'海淀区', N'海淀', N'中国,北京,北京市,海淀区', 3, N'010       ', 100089, N'Haidian', 116.298119, 39.95931, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'110109', N'110100', N'门头沟区', N'门头沟', N'中国,北京,北京市,门头沟区', 3, N'010       ', 102300, N'Mentougou', 116.101372, 39.94043, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'110111', N'110100', N'房山区', N'房山', N'中国,北京,北京市,房山区', 3, N'010       ', 102488, N'Fangshan', 116.14257, 39.74786, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'110112', N'110100', N'通州区', N'通州', N'中国,北京,北京市,通州区', 3, N'010       ', 101149, N'Tongzhou', 116.657158, 39.90966, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'110113', N'110100', N'顺义区', N'顺义', N'中国,北京,北京市,顺义区', 3, N'010       ', 101300, N'Shunyi', 116.654167, 40.1302, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'110114', N'110100', N'昌平区', N'昌平', N'中国,北京,北京市,昌平区', 3, N'010       ', 102200, N'Changping', 116.2312, 40.22072, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'110115', N'110100', N'大兴区', N'大兴', N'中国,北京,北京市,大兴区', 3, N'010       ', 102600, N'Daxing', 116.341492, 39.72668, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'110116', N'110100', N'怀柔区', N'怀柔', N'中国,北京,北京市,怀柔区', 3, N'010       ', 101400, N'Huairou', 116.631683, 40.31602, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'110117', N'110100', N'平谷区', N'平谷', N'中国,北京,北京市,平谷区', 3, N'010       ', 101200, N'Pinggu', 117.12133, 40.14056, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'110228', N'110100', N'密云县', N'密云', N'中国,北京,北京市,密云县', 3, N'010       ', 101500, N'Miyun', 116.842949, 40.37618, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'110229', N'110100', N'延庆县', N'延庆', N'中国,北京,北京市,延庆县', 3, N'010       ', 102100, N'Yanqing', 115.974937, 40.45672, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130000', N'100000', N'河北省', N'河北', N'中国,河北省', 1, NULL, NULL, N'Hebei', 114.502464, 38.045475, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130100', N'130000', N'石家庄市', N'石家庄', N'中国,河北省,石家庄市', 2, N'0311      ', 50011, N'Shijiazhuang', 114.502464, 38.045475, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130102', N'130100', N'长安区', N'长安', N'中国,河北省,石家庄市,长安区', 3, N'0311      ', 50011, N'Chang''an', 114.539063, 38.03665, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130104', N'130100', N'桥西区', N'桥西', N'中国,河北省,石家庄市,桥西区', 3, N'0311      ', 50091, N'Qiaoxi', 114.469772, 38.03221, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130105', N'130100', N'新华区', N'新华', N'中国,河北省,石家庄市,新华区', 3, N'0311      ', 50051, N'Xinhua', 114.463257, 38.05088, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130107', N'130100', N'井陉矿区', N'井陉矿区', N'中国,河北省,石家庄市,井陉矿区', 3, N'0311      ', 50100, N'Jingxingkuangqu', 114.065178, 38.06705, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130108', N'130100', N'裕华区', N'裕华', N'中国,河北省,石家庄市,裕华区', 3, N'0311      ', 50031, N'Yuhua', 114.531151, 38.00604, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130109', N'130100', N'藁城区', N'藁城', N'中国,河北省,石家庄市,藁城区', 3, N'0311      ', 52160, N'Gaocheng', 114.84671, 38.02162, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130110', N'130100', N'鹿泉区', N'鹿泉', N'中国,河北省,石家庄市,鹿泉区', 3, N'0311      ', 50200, N'Luquan', 114.313469, 38.08782, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130111', N'130100', N'栾城区', N'栾城', N'中国,河北省,石家庄市,栾城区', 3, N'0311      ', 51430, N'Luancheng', 114.648338, 37.90022, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130121', N'130100', N'井陉县', N'井陉', N'中国,河北省,石家庄市,井陉县', 3, N'0311      ', 50300, N'Jingxing', 114.14257, 38.03688, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130123', N'130100', N'正定县', N'正定', N'中国,河北省,石家庄市,正定县', 3, N'0311      ', 50800, N'Zhengding', 114.57296, 38.14445, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130125', N'130100', N'行唐县', N'行唐', N'中国,河北省,石家庄市,行唐县', 3, N'0311      ', 50600, N'Xingtang', 114.553162, 38.43654, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130126', N'130100', N'灵寿县', N'灵寿', N'中国,河北省,石家庄市,灵寿县', 3, N'0311      ', 50500, N'Lingshou', 114.382591, 38.30845, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130127', N'130100', N'高邑县', N'高邑', N'中国,河北省,石家庄市,高邑县', 3, N'0311      ', 51330, N'Gaoyi', 114.61142, 37.61556, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130128', N'130100', N'深泽县', N'深泽', N'中国,河北省,石家庄市,深泽县', 3, N'0311      ', 52560, N'Shenze', 115.203583, 38.18353, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130129', N'130100', N'赞皇县', N'赞皇', N'中国,河北省,石家庄市,赞皇县', 3, N'0311      ', 51230, N'Zanhuang', 114.387749, 37.66135, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130130', N'130100', N'无极县', N'无极', N'中国,河北省,石家庄市,无极县', 3, N'0311      ', 52460, N'Wuji', 114.97509, 38.17653, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130131', N'130100', N'平山县', N'平山', N'中国,河北省,石家庄市,平山县', 3, N'0311      ', 50400, N'Pingshan', 114.186, 38.25994, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130132', N'130100', N'元氏县', N'元氏', N'中国,河北省,石家庄市,元氏县', 3, N'0311      ', 51130, N'Yuanshi', 114.525391, 37.76668, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130133', N'130100', N'赵县', N'赵县', N'中国,河北省,石家庄市,赵县', 3, N'0311      ', 51530, N'Zhaoxian', 114.776123, 37.75628, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130181', N'130100', N'辛集市', N'辛集', N'中国,河北省,石家庄市,辛集市', 3, N'0311      ', 52360, N'Xinji', 115.206261, 37.94079, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130183', N'130100', N'晋州市', N'晋州', N'中国,河北省,石家庄市,晋州市', 3, N'0311      ', 52260, N'Jinzhou', 115.04348, 38.03135, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130184', N'130100', N'新乐市', N'新乐', N'中国,河北省,石家庄市,新乐市', 3, N'0311      ', 50700, N'Xinle', 114.68985, 38.34417, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130200', N'130000', N'唐山市', N'唐山', N'中国,河北省,唐山市', 2, N'0315      ', 63000, N'Tangshan', 118.175392, 39.6351128, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130202', N'130200', N'路南区', N'路南', N'中国,河北省,唐山市,路南区', 3, N'0315      ', 63000, N'Lunan', 118.154312, 39.62505, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130203', N'130200', N'路北区', N'路北', N'中国,河北省,唐山市,路北区', 3, N'0315      ', 63000, N'Lubei', 118.20079, 39.62436, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130204', N'130200', N'古冶区', N'古冶', N'中国,河北省,唐山市,古冶区', 3, N'0315      ', 63100, N'Guye', 118.458031, 39.71993, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130205', N'130200', N'开平区', N'开平', N'中国,河北省,唐山市,开平区', 3, N'0315      ', 63021, N'Kaiping', 118.261711, 39.67128, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130207', N'130200', N'丰南区', N'丰南', N'中国,河北省,唐山市,丰南区', 3, N'0315      ', 63300, N'Fengnan', 118.112823, 39.56483, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130208', N'130200', N'丰润区', N'丰润', N'中国,河北省,唐山市,丰润区', 3, N'0315      ', 64000, N'Fengrun', 118.129761, 39.8244, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130209', N'130200', N'曹妃甸区', N'曹妃甸', N'中国,河北省,唐山市,曹妃甸区', 3, N'0315      ', 63200, N'Caofeidian', 118.460381, 39.27307, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130223', N'130200', N'滦县', N'滦县', N'中国,河北省,唐山市,滦县', 3, N'0315      ', 63700, N'Luanxian', 118.703461, 39.74056, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130224', N'130200', N'滦南县', N'滦南', N'中国,河北省,唐山市,滦南县', 3, N'0315      ', 63500, N'Luannan', 118.6741, 39.5039, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130225', N'130200', N'乐亭县', N'乐亭', N'中国,河北省,唐山市,乐亭县', 3, N'0315      ', 63600, N'Laoting', 118.9125, 39.42561, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130227', N'130200', N'迁西县', N'迁西', N'中国,河北省,唐山市,迁西县', 3, N'0315      ', 64300, N'Qianxi', 118.316162, 40.14587, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130229', N'130200', N'玉田县', N'玉田', N'中国,河北省,唐山市,玉田县', 3, N'0315      ', 64100, N'Yutian', 117.7388, 39.90049, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130281', N'130200', N'遵化市', N'遵化', N'中国,河北省,唐山市,遵化市', 3, N'0315      ', 64200, N'Zunhua', 117.964439, 40.18741, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130283', N'130200', N'迁安市', N'迁安', N'中国,河北省,唐山市,迁安市', 3, N'0315      ', 64400, N'Qian''an', 118.700684, 39.99833, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130300', N'130000', N'秦皇岛市', N'秦皇岛', N'中国,河北省,秦皇岛市', 2, N'0335      ', 66000, N'Qinhuangdao', 119.586578, 39.94253, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130302', N'130300', N'海港区', N'海港', N'中国,河北省,秦皇岛市,海港区', 3, N'0335      ', 66000, N'Haigang', 119.610458, 39.9345, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130303', N'130300', N'山海关区', N'山海关', N'中国,河北省,秦皇岛市,山海关区', 3, N'0335      ', 66200, N'Shanhaiguan', 119.775627, 39.97869, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130304', N'130300', N'北戴河区', N'北戴河', N'中国,河北省,秦皇岛市,北戴河区', 3, N'0335      ', 66100, N'Beidaihe', 119.483879, 39.83408, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130321', N'130300', N'青龙满族自治县', N'青龙', N'中国,河北省,秦皇岛市,青龙满族自治县', 3, N'0335      ', 66500, N'Qinglong', 118.952423, 40.40743, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130322', N'130300', N'昌黎县', N'昌黎', N'中国,河北省,秦皇岛市,昌黎县', 3, N'0335      ', 66600, N'Changli', 119.165947, 39.70884, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130323', N'130300', N'抚宁县', N'抚宁', N'中国,河北省,秦皇岛市,抚宁县', 3, N'0335      ', 66300, N'Funing', 119.244873, 39.87538, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130324', N'130300', N'卢龙县', N'卢龙', N'中国,河北省,秦皇岛市,卢龙县', 3, N'0335      ', 66400, N'Lulong', 118.892883, 39.89176, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130400', N'130000', N'邯郸市', N'邯郸', N'中国,河北省,邯郸市', 2, N'0310      ', 56002, N'Handan', 114.490685, 36.6122742, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130402', N'130400', N'邯山区', N'邯山', N'中国,河北省,邯郸市,邯山区', 3, N'0310      ', 56001, N'Hanshan', 114.483749, 36.60006, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130403', N'130400', N'丛台区', N'丛台', N'中国,河北省,邯郸市,丛台区', 3, N'0310      ', 56002, N'Congtai', 114.493431, 36.61847, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130404', N'130400', N'复兴区', N'复兴', N'中国,河北省,邯郸市,复兴区', 3, N'0310      ', 56003, N'Fuxing', 114.459282, 36.61134, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130406', N'130400', N'峰峰矿区', N'峰峰矿区', N'中国,河北省,邯郸市,峰峰矿区', 3, N'0310      ', 56200, N'Fengfengkuangqu', 114.211479, 36.41937, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130421', N'130400', N'邯郸县', N'邯郸', N'中国,河北省,邯郸市,邯郸县', 3, N'0310      ', 56101, N'Handan', 114.531029, 36.59385, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130423', N'130400', N'临漳县', N'临漳', N'中国,河北省,邯郸市,临漳县', 3, N'0310      ', 56600, N'Linzhang', 114.6195, 36.33461, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130424', N'130400', N'成安县', N'成安', N'中国,河北省,邯郸市,成安县', 3, N'0310      ', 56700, N'Cheng''an', 114.669952, 36.44411, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130425', N'130400', N'大名县', N'大名', N'中国,河北省,邯郸市,大名县', 3, N'0310      ', 56900, N'Daming', 115.153618, 36.27994, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130426', N'130400', N'涉县', N'涉县', N'中国,河北省,邯郸市,涉县', 3, N'0310      ', 56400, N'Shexian', 113.691833, 36.58072, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130427', N'130400', N'磁县', N'磁县', N'中国,河北省,邯郸市,磁县', 3, N'0310      ', 56500, N'Cixian', 114.373871, 36.37392, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130428', N'130400', N'肥乡县', N'肥乡', N'中国,河北省,邯郸市,肥乡县', 3, N'0310      ', 57550, N'Feixiang', 114.79998, 36.54807, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130429', N'130400', N'永年县', N'永年', N'中国,河北省,邯郸市,永年县', 3, N'0310      ', 57150, N'Yongnian', 114.48925, 36.78356, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130430', N'130400', N'邱县', N'邱县', N'中国,河北省,邯郸市,邱县', 3, N'0310      ', 57450, N'Qiuxian', 115.174072, 36.82082, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130431', N'130400', N'鸡泽县', N'鸡泽', N'中国,河北省,邯郸市,鸡泽县', 3, N'0310      ', 57350, N'Jize', 114.8742, 36.92374, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130432', N'130400', N'广平县', N'广平', N'中国,河北省,邯郸市,广平县', 3, N'0310      ', 57650, N'Guangping', 114.946533, 36.48046, 1)
GO
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130433', N'130400', N'馆陶县', N'馆陶', N'中国,河北省,邯郸市,馆陶县', 3, N'0310      ', 57750, N'Guantao', 115.299133, 36.53719, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130434', N'130400', N'魏县', N'魏县', N'中国,河北省,邯郸市,魏县', 3, N'0310      ', 56800, N'Weixian', 114.935181, 36.36171, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130435', N'130400', N'曲周县', N'曲周', N'中国,河北省,邯郸市,曲周县', 3, N'0310      ', 57250, N'Quzhou', 114.951958, 36.77671, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130481', N'130400', N'武安市', N'武安', N'中国,河北省,邯郸市,武安市', 3, N'0310      ', 56300, N'Wu''an', 114.20153, 36.69281, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130500', N'130000', N'邢台市', N'邢台', N'中国,河北省,邢台市', 2, N'0319      ', 54001, N'Xingtai', 114.50885, 37.0682, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130502', N'130500', N'桥东区', N'桥东', N'中国,河北省,邢台市,桥东区', 3, N'0319      ', 54001, N'Qiaodong', 114.507248, 37.06801, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130503', N'130500', N'桥西区', N'桥西', N'中国,河北省,邢台市,桥西区', 3, N'0319      ', 54000, N'Qiaoxi', 114.468033, 37.05984, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130521', N'130500', N'邢台县', N'邢台', N'中国,河北省,邢台市,邢台县', 3, N'0319      ', 54001, N'Xingtai', 114.56575, 37.0456, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130522', N'130500', N'临城县', N'临城', N'中国,河北省,邢台市,临城县', 3, N'0319      ', 54300, N'Lincheng', 114.503868, 37.43977, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130523', N'130500', N'内丘县', N'内丘', N'中国,河北省,邢台市,内丘县', 3, N'0319      ', 54200, N'Neiqiu', 114.512123, 37.28671, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130524', N'130500', N'柏乡县', N'柏乡', N'中国,河北省,邢台市,柏乡县', 3, N'0319      ', 55450, N'Baixiang', 114.693321, 37.48242, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130525', N'130500', N'隆尧县', N'隆尧', N'中国,河北省,邢台市,隆尧县', 3, N'0319      ', 55350, N'Longyao', 114.776154, 37.35351, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130526', N'130500', N'任县', N'任县', N'中国,河北省,邢台市,任县', 3, N'0319      ', 55150, N'Renxian', 114.6842, 37.12575, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130527', N'130500', N'南和县', N'南和', N'中国,河北省,邢台市,南和县', 3, N'0319      ', 54400, N'Nanhe', 114.683708, 37.00488, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130528', N'130500', N'宁晋县', N'宁晋', N'中国,河北省,邢台市,宁晋县', 3, N'0319      ', 55550, N'Ningjin', 114.921173, 37.61696, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130529', N'130500', N'巨鹿县', N'巨鹿', N'中国,河北省,邢台市,巨鹿县', 3, N'0319      ', 55250, N'Julu', 115.03524, 37.21801, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130530', N'130500', N'新河县', N'新河', N'中国,河北省,邢台市,新河县', 3, N'0319      ', 55650, N'Xinhe', 115.24987, 37.52718, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130531', N'130500', N'广宗县', N'广宗', N'中国,河北省,邢台市,广宗县', 3, N'0319      ', 54600, N'Guangzong', 115.14254, 37.0746, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130532', N'130500', N'平乡县', N'平乡', N'中国,河北省,邢台市,平乡县', 3, N'0319      ', 54500, N'Pingxiang', 115.030022, 37.06317, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130533', N'130500', N'威县', N'威县', N'中国,河北省,邢台市,威县', 3, N'0319      ', 54700, N'Weixian', 115.2637, 36.9768, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130534', N'130500', N'清河县', N'清河', N'中国,河北省,邢台市,清河县', 3, N'0319      ', 54800, N'Qinghe', 115.664787, 37.07122, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130535', N'130500', N'临西县', N'临西', N'中国,河北省,邢台市,临西县', 3, N'0319      ', 54900, N'Linxi', 115.500969, 36.87078, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130581', N'130500', N'南宫市', N'南宫', N'中国,河北省,邢台市,南宫市', 3, N'0319      ', 55750, N'Nangong', 115.390678, 37.35799, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130582', N'130500', N'沙河市', N'沙河', N'中国,河北省,邢台市,沙河市', 3, N'0319      ', 54100, N'Shahe', 114.4981, 36.8577, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130600', N'130000', N'保定市', N'保定', N'中国,河北省,保定市', 2, N'0312      ', 71052, N'Baoding', 115.48233, 38.8676567, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130602', N'130600', N'新市区', N'新市', N'中国,河北省,保定市,新市区', 3, N'0312      ', 71051, N'Xinshi', 115.4587, 38.87751, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130603', N'130600', N'北市区', N'北市', N'中国,河北省,保定市,北市区', 3, N'0312      ', 71000, N'Beishi', 115.497147, 38.88322, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130604', N'130600', N'南市区', N'南市', N'中国,河北省,保定市,南市区', 3, N'0312      ', 71001, N'Nanshi', 115.528587, 38.85455, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130621', N'130600', N'满城县', N'满城', N'中国,河北省,保定市,满城县', 3, N'0312      ', 72150, N'Mancheng', 115.32296, 38.94972, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130622', N'130600', N'清苑县', N'清苑', N'中国,河北省,保定市,清苑县', 3, N'0312      ', 71100, N'Qingyuan', 115.492668, 38.76709, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130623', N'130600', N'涞水县', N'涞水', N'中国,河北省,保定市,涞水县', 3, N'0312      ', 74100, N'Laishui', 115.715172, 39.39404, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130624', N'130600', N'阜平县', N'阜平', N'中国,河北省,保定市,阜平县', 3, N'0312      ', 73200, N'Fuping', 114.196831, 38.84763, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130625', N'130600', N'徐水县', N'徐水', N'中国,河北省,保定市,徐水县', 3, N'0312      ', 72550, N'Xushui', 115.658287, 39.02099, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130626', N'130600', N'定兴县', N'定兴', N'中国,河北省,保定市,定兴县', 3, N'0312      ', 72650, N'Dingxing', 115.807861, 39.26312, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130627', N'130600', N'唐县', N'唐县', N'中国,河北省,保定市,唐县', 3, N'0312      ', 72350, N'Tangxian', 114.985161, 38.74513, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130628', N'130600', N'高阳县', N'高阳', N'中国,河北省,保定市,高阳县', 3, N'0312      ', 71500, N'Gaoyang', 115.7788, 38.70003, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130629', N'130600', N'容城县', N'容城', N'中国,河北省,保定市,容城县', 3, N'0312      ', 71700, N'Rongcheng', 115.871582, 39.0535, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130630', N'130600', N'涞源县', N'涞源', N'中国,河北省,保定市,涞源县', 3, N'0312      ', 74300, N'Laiyuan', 114.691277, 39.35388, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130631', N'130600', N'望都县', N'望都', N'中国,河北省,保定市,望都县', 3, N'0312      ', 72450, N'Wangdu', 115.1567, 38.70996, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130632', N'130600', N'安新县', N'安新', N'中国,河北省,保定市,安新县', 3, N'0312      ', 71600, N'Anxin', 115.93557, 38.93532, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130633', N'130600', N'易县', N'易县', N'中国,河北省,保定市,易县', 3, N'0312      ', 74200, N'Yixian', 115.4981, 39.34885, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130634', N'130600', N'曲阳县', N'曲阳', N'中国,河北省,保定市,曲阳县', 3, N'0312      ', 73100, N'Quyang', 114.701233, 38.62154, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130635', N'130600', N'蠡县', N'蠡县', N'中国,河北省,保定市,蠡县', 3, N'0312      ', 71400, N'Lixian', 115.577171, 38.48974, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130636', N'130600', N'顺平县', N'顺平', N'中国,河北省,保定市,顺平县', 3, N'0312      ', 72250, N'Shunping', 115.1347, 38.83854, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130637', N'130600', N'博野县', N'博野', N'中国,河北省,保定市,博野县', 3, N'0312      ', 71300, N'Boye', 115.470329, 38.4564, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130638', N'130600', N'雄县', N'雄县', N'中国,河北省,保定市,雄县', 3, N'0312      ', 71800, N'Xiongxian', 116.108727, 38.99442, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130681', N'130600', N'涿州市', N'涿州', N'中国,河北省,保定市,涿州市', 3, N'0312      ', 72750, N'Zhuozhou', 115.980621, 39.48622, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130682', N'130600', N'定州市', N'定州', N'中国,河北省,保定市,定州市', 3, N'0312      ', 73000, N'Dingzhou', 114.9902, 38.51623, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130683', N'130600', N'安国市', N'安国', N'中国,河北省,保定市,安国市', 3, N'0312      ', 71200, N'Anguo', 115.323212, 38.41391, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130684', N'130600', N'高碑店市', N'高碑店', N'中国,河北省,保定市,高碑店市', 3, N'0312      ', 74000, N'Gaobeidian', 115.87368, 39.32655, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130700', N'130000', N'张家口市', N'张家口', N'中国,河北省,张家口市', 2, N'0313      ', 75000, N'Zhangjiakou', 114.884094, 40.8119, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130702', N'130700', N'桥东区', N'桥东', N'中国,河北省,张家口市,桥东区', 3, N'0313      ', 75000, N'Qiaodong', 114.8943, 40.78844, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130703', N'130700', N'桥西区', N'桥西', N'中国,河北省,张家口市,桥西区', 3, N'0313      ', 75061, N'Qiaoxi', 114.869621, 40.81945, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130705', N'130700', N'宣化区', N'宣化', N'中国,河北省,张家口市,宣化区', 3, N'0313      ', 75100, N'Xuanhua', 115.06543, 40.60957, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130706', N'130700', N'下花园区', N'下花园', N'中国,河北省,张家口市,下花园区', 3, N'0313      ', 75300, N'Xiahuayuan', 115.287437, 40.50236, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130721', N'130700', N'宣化县', N'宣化', N'中国,河北省,张家口市,宣化县', 3, N'0313      ', 75100, N'Xuanhua', 115.154968, 40.56618, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130722', N'130700', N'张北县', N'张北', N'中国,河北省,张家口市,张北县', 3, N'0313      ', 76450, N'Zhangbei', 114.714317, 41.15977, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130723', N'130700', N'康保县', N'康保', N'中国,河北省,张家口市,康保县', 3, N'0313      ', 76650, N'Kangbao', 114.600311, 41.85225, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130724', N'130700', N'沽源县', N'沽源', N'中国,河北省,张家口市,沽源县', 3, N'0313      ', 76550, N'Guyuan', 115.688591, 41.66959, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130725', N'130700', N'尚义县', N'尚义', N'中国,河北省,张家口市,尚义县', 3, N'0313      ', 76750, N'Shangyi', 113.971336, 41.07782, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130726', N'130700', N'蔚县', N'蔚县', N'中国,河北省,张家口市,蔚县', 3, N'0313      ', 75700, N'Yuxian', 114.588921, 39.84067, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130727', N'130700', N'阳原县', N'阳原', N'中国,河北省,张家口市,阳原县', 3, N'0313      ', 75800, N'Yangyuan', 114.150513, 40.10361, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130728', N'130700', N'怀安县', N'怀安', N'中国,河北省,张家口市,怀安县', 3, N'0313      ', 76150, N'Huai''an', 114.38559, 40.67425, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130729', N'130700', N'万全县', N'万全', N'中国,河北省,张家口市,万全县', 3, N'0313      ', 76250, N'Wanquan', 114.7405, 40.76694, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130730', N'130700', N'怀来县', N'怀来', N'中国,河北省,张家口市,怀来县', 3, N'0313      ', 75400, N'Huailai', 115.517731, 40.41536, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130731', N'130700', N'涿鹿县', N'涿鹿', N'中国,河北省,张家口市,涿鹿县', 3, N'0313      ', 75600, N'Zhuolu', 115.22403, 40.37636, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130732', N'130700', N'赤城县', N'赤城', N'中国,河北省,张家口市,赤城县', 3, N'0313      ', 75500, N'Chicheng', 115.831871, 40.91438, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130733', N'130700', N'崇礼县', N'崇礼', N'中国,河北省,张家口市,崇礼县', 3, N'0313      ', 76350, N'Chongli', 115.27993, 40.97519, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130800', N'130000', N'承德市', N'承德', N'中国,河北省,承德市', 2, N'0314      ', 67000, N'Chengde', 117.939156, 40.9762039, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130802', N'130800', N'双桥区', N'双桥', N'中国,河北省,承德市,双桥区', 3, N'0314      ', 67000, N'Shuangqiao', 117.9432, 40.97466, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130803', N'130800', N'双滦区', N'双滦', N'中国,河北省,承德市,双滦区', 3, N'0314      ', 67001, N'Shuangluan', 117.744873, 40.95375, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130804', N'130800', N'鹰手营子矿区', N'鹰手营子矿区', N'中国,河北省,承德市,鹰手营子矿区', 3, N'0314      ', 67200, N'Yingshouyingzikuangqu', 117.659851, 40.54744, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130821', N'130800', N'承德县', N'承德', N'中国,河北省,承德市,承德县', 3, N'0314      ', 67400, N'Chengde', 118.176392, 40.76985, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130822', N'130800', N'兴隆县', N'兴隆', N'中国,河北省,承德市,兴隆县', 3, N'0314      ', 67300, N'Xinglong', 117.500732, 40.41709, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130823', N'130800', N'平泉县', N'平泉', N'中国,河北省,承德市,平泉县', 3, N'0314      ', 67500, N'Pingquan', 118.701958, 41.01839, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130824', N'130800', N'滦平县', N'滦平', N'中国,河北省,承德市,滦平县', 3, N'0314      ', 68250, N'Luanping', 117.332764, 40.94148, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130825', N'130800', N'隆化县', N'隆化', N'中国,河北省,承德市,隆化县', 3, N'0314      ', 68150, N'Longhua', 117.7297, 41.31412, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130826', N'130800', N'丰宁满族自治县', N'丰宁', N'中国,河北省,承德市,丰宁满族自治县', 3, N'0314      ', 68350, N'Fengning', 116.6492, 41.20481, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130827', N'130800', N'宽城满族自治县', N'宽城', N'中国,河北省,承德市,宽城满族自治县', 3, N'0314      ', 67600, N'Kuancheng', 118.49176, 40.60829, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130828', N'130800', N'围场满族蒙古族自治县', N'围场', N'中国,河北省,承德市,围场满族蒙古族自治县', 3, N'0314      ', 68450, N'Weichang', 117.7601, 41.94368, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130900', N'130000', N'沧州市', N'沧州', N'中国,河北省,沧州市', 2, N'0317      ', 61001, N'Cangzhou', 116.85746, 38.31058, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130902', N'130900', N'新华区', N'新华', N'中国,河北省,沧州市,新华区', 3, N'0317      ', 61000, N'Xinhua', 116.866432, 38.31438, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130903', N'130900', N'运河区', N'运河', N'中国,河北省,沧州市,运河区', 3, N'0317      ', 61001, N'Yunhe', 116.857063, 38.31352, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130921', N'130900', N'沧县', N'沧县', N'中国,河北省,沧州市,沧县', 3, N'0317      ', 61000, N'Cangxian', 116.878166, 38.29361, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130922', N'130900', N'青县', N'青县', N'中国,河北省,沧州市,青县', 3, N'0317      ', 62650, N'Qingxian', 116.803162, 38.58345, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130923', N'130900', N'东光县', N'东光', N'中国,河北省,沧州市,东光县', 3, N'0317      ', 61600, N'Dongguang', 116.536682, 37.8857, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130924', N'130900', N'海兴县', N'海兴', N'中国,河北省,沧州市,海兴县', 3, N'0317      ', 61200, N'Haixing', 117.497581, 38.13958, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130925', N'130900', N'盐山县', N'盐山', N'中国,河北省,沧州市,盐山县', 3, N'0317      ', 61300, N'Yanshan', 117.230919, 38.05647, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130926', N'130900', N'肃宁县', N'肃宁', N'中国,河北省,沧州市,肃宁县', 3, N'0317      ', 62350, N'Suning', 115.829712, 38.42272, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130927', N'130900', N'南皮县', N'南皮', N'中国,河北省,沧州市,南皮县', 3, N'0317      ', 61500, N'Nanpi', 116.70224, 38.04109, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130928', N'130900', N'吴桥县', N'吴桥', N'中国,河北省,沧州市,吴桥县', 3, N'0317      ', 61800, N'Wuqiao', 116.3847, 37.62546, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130929', N'130900', N'献县', N'献县', N'中国,河北省,沧州市,献县', 3, N'0317      ', 62250, N'Xianxian', 116.126953, 38.19228, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130930', N'130900', N'孟村回族自治县', N'孟村', N'中国,河北省,沧州市,孟村回族自治县', 3, N'0317      ', 61400, N'Mengcun', 117.104118, 38.05338, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130981', N'130900', N'泊头市', N'泊头', N'中国,河北省,沧州市,泊头市', 3, N'0317      ', 62150, N'Botou', 116.578239, 38.08359, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130982', N'130900', N'任丘市', N'任丘', N'中国,河北省,沧州市,任丘市', 3, N'0317      ', 62550, N'Renqiu', 116.1033, 38.71124, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130983', N'130900', N'黄骅市', N'黄骅', N'中国,河北省,沧州市,黄骅市', 3, N'0317      ', 61100, N'Huanghua', 117.338829, 38.3706, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'130984', N'130900', N'河间市', N'河间', N'中国,河北省,沧州市,河间市', 3, N'0317      ', 62450, N'Hejian', 116.0993, 38.44549, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'131000', N'130000', N'廊坊市', N'廊坊', N'中国,河北省,廊坊市', 2, N'0316      ', 65000, N'Langfang', 116.713875, 39.5292435, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'131002', N'131000', N'安次区', N'安次', N'中国,河北省,廊坊市,安次区', 3, N'0316      ', 65000, N'Anci', 116.703079, 39.52057, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'131003', N'131000', N'广阳区', N'广阳', N'中国,河北省,廊坊市,广阳区', 3, N'0316      ', 65000, N'Guangyang', 116.710693, 39.52278, 1)
GO
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'131022', N'131000', N'固安县', N'固安', N'中国,河北省,廊坊市,固安县', 3, N'0316      ', 65500, N'Gu''an', 116.299156, 39.43833, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'131023', N'131000', N'永清县', N'永清', N'中国,河北省,廊坊市,永清县', 3, N'0316      ', 65600, N'Yongqing', 116.500908, 39.32069, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'131024', N'131000', N'香河县', N'香河', N'中国,河北省,廊坊市,香河县', 3, N'0316      ', 65400, N'Xianghe', 117.00634, 39.76133, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'131025', N'131000', N'大城县', N'大城', N'中国,河北省,廊坊市,大城县', 3, N'0316      ', 65900, N'Daicheng', 116.653526, 38.70534, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'131026', N'131000', N'文安县', N'文安', N'中国,河北省,廊坊市,文安县', 3, N'0316      ', 65800, N'Wen''an', 116.458458, 38.87325, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'131028', N'131000', N'大厂回族自治县', N'大厂', N'中国,河北省,廊坊市,大厂回族自治县', 3, N'0316      ', 65300, N'Dachang', 116.989159, 39.88649, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'131081', N'131000', N'霸州市', N'霸州', N'中国,河北省,廊坊市,霸州市', 3, N'0316      ', 65700, N'Bazhou', 116.391541, 39.12569, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'131082', N'131000', N'三河市', N'三河', N'中国,河北省,廊坊市,三河市', 3, N'0316      ', 65200, N'Sanhe', 117.072289, 39.98358, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'131100', N'130000', N'衡水市', N'衡水', N'中国,河北省,衡水市', 2, N'0318      ', 53000, N'Hengshui', 115.665993, 37.735096, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'131102', N'131100', N'桃城区', N'桃城', N'中国,河北省,衡水市,桃城区', 3, N'0318      ', 53000, N'Taocheng', 115.675293, 37.73499, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'131121', N'131100', N'枣强县', N'枣强', N'中国,河北省,衡水市,枣强县', 3, N'0318      ', 53100, N'Zaoqiang', 115.725761, 37.51027, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'131122', N'131100', N'武邑县', N'武邑', N'中国,河北省,衡水市,武邑县', 3, N'0318      ', 53400, N'Wuyi', 115.887482, 37.80181, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'131123', N'131100', N'武强县', N'武强', N'中国,河北省,衡水市,武强县', 3, N'0318      ', 53300, N'Wuqiang', 115.982262, 38.04138, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'131124', N'131100', N'饶阳县', N'饶阳', N'中国,河北省,衡水市,饶阳县', 3, N'0318      ', 53900, N'Raoyang', 115.725578, 38.23529, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'131125', N'131100', N'安平县', N'安平', N'中国,河北省,衡水市,安平县', 3, N'0318      ', 53600, N'Anping', 115.518761, 38.23388, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'131126', N'131100', N'故城县', N'故城', N'中国,河北省,衡水市,故城县', 3, N'0318      ', 53800, N'Gucheng', 115.970757, 37.34773, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'131127', N'131100', N'景县', N'景县', N'中国,河北省,衡水市,景县', 3, N'0318      ', 53500, N'Jingxian', 116.269043, 37.6926, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'131128', N'131100', N'阜城县', N'阜城', N'中国,河北省,衡水市,阜城县', 3, N'0318      ', 53700, N'Fucheng', 116.14431, 37.86881, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'131181', N'131100', N'冀州市', N'冀州', N'中国,河北省,衡水市,冀州市', 3, N'0318      ', 53200, N'Jizhou', 115.579338, 37.55082, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'131182', N'131100', N'深州市', N'深州', N'中国,河北省,衡水市,深州市', 3, N'0318      ', 53800, N'Shenzhou', 115.559929, 38.00109, 1)

INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'640000', N'100000', N'宁夏回族自治区', N'宁夏', N'中国,宁夏回族自治区', 1, NULL, NULL, N'Ningxia', 106.278175, 38.46637, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'640100', N'640000', N'银川市', N'银川', N'中国,宁夏回族自治区,银川市', 2, N'0951      ', 750004, N'Yinchuan', 106.278175, 38.46637, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'640104', N'640100', N'兴庆区', N'兴庆', N'中国,宁夏回族自治区,银川市,兴庆区', 3, N'0951      ', 750001, N'Xingqing', 106.288719, 38.47392, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'640105', N'640100', N'西夏区', N'西夏', N'中国,宁夏回族自治区,银川市,西夏区', 3, N'0951      ', 750021, N'Xixia', 106.15023, 38.49137, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'640106', N'640100', N'金凤区', N'金凤', N'中国,宁夏回族自治区,银川市,金凤区', 3, N'0951      ', 750011, N'Jinfeng', 106.242607, 38.47294, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'640121', N'640100', N'永宁县', N'永宁', N'中国,宁夏回族自治区,银川市,永宁县', 3, N'0951      ', 750100, N'Yongning', 106.2517, 38.27559, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'640122', N'640100', N'贺兰县', N'贺兰', N'中国,宁夏回族自治区,银川市,贺兰县', 3, N'0951      ', 750200, N'Helan', 106.349823, 38.5544, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'640181', N'640100', N'灵武市', N'灵武', N'中国,宁夏回族自治区,银川市,灵武市', 3, N'0951      ', 750004, N'Lingwu', 106.339989, 38.10266, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'640200', N'640000', N'石嘴山市', N'石嘴山', N'中国,宁夏回族自治区,石嘴山市', 2, N'0952      ', 753000, N'Shizuishan', 106.376175, 39.01333, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'640202', N'640200', N'大武口区', N'大武口', N'中国,宁夏回族自治区,石嘴山市,大武口区', 3, N'0952      ', 753000, N'Dawukou', 106.377167, 39.01226, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'640205', N'640200', N'惠农区', N'惠农', N'中国,宁夏回族自治区,石嘴山市,惠农区', 3, N'0952      ', 753600, N'Huinong', 106.711449, 39.13193, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'640221', N'640200', N'平罗县', N'平罗', N'中国,宁夏回族自治区,石嘴山市,平罗县', 3, N'0952      ', 753400, N'Pingluo', 106.54538, 38.90429, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'640300', N'640000', N'吴忠市', N'吴忠', N'中国,宁夏回族自治区,吴忠市', 2, N'0953      ', 751100, N'Wuzhong', 106.199409, 37.9861641, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'640302', N'640300', N'利通区', N'利通', N'中国,宁夏回族自治区,吴忠市,利通区', 3, N'0953      ', 751100, N'Litong', 106.20311, 37.98512, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'640303', N'640300', N'红寺堡区', N'红寺堡', N'中国,宁夏回族自治区,吴忠市,红寺堡区', 3, N'0953      ', 751900, N'Hongsibao', 106.198219, 37.99747, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'640323', N'640300', N'盐池县', N'盐池', N'中国,宁夏回族自治区,吴忠市,盐池县', 3, N'0953      ', 751500, N'Yanchi', 107.407066, 37.7833, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'640324', N'640300', N'同心县', N'同心', N'中国,宁夏回族自治区,吴忠市,同心县', 3, N'0953      ', 751300, N'Tongxin', 105.914177, 36.98116, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'640381', N'640300', N'青铜峡市', N'青铜峡', N'中国,宁夏回族自治区,吴忠市,青铜峡市', 3, N'0953      ', 751600, N'Qingtongxia', 106.07489, 38.02004, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'640400', N'640000', N'固原市', N'固原', N'中国,宁夏回族自治区,固原市', 2, N'0954      ', 756000, N'Guyuan', 106.28524, 36.0045624, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'640402', N'640400', N'原州区', N'原州', N'中国,宁夏回族自治区,固原市,原州区', 3, N'0954      ', 756000, N'Yuanzhou', 106.287781, 36.00374, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'640422', N'640400', N'西吉县', N'西吉', N'中国,宁夏回族自治区,固原市,西吉县', 3, N'0954      ', 756200, N'Xiji', 105.731071, 35.96616, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'640423', N'640400', N'隆德县', N'隆德', N'中国,宁夏回族自治区,固原市,隆德县', 3, N'0954      ', 756300, N'Longde', 106.12426, 35.61718, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'640424', N'640400', N'泾源县', N'泾源', N'中国,宁夏回族自治区,固原市,泾源县', 3, N'0954      ', 756400, N'Jingyuan', 106.33902, 35.49072, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'640425', N'640400', N'彭阳县', N'彭阳', N'中国,宁夏回族自治区,固原市,彭阳县', 3, N'0954      ', 756500, N'Pengyang', 106.644623, 35.85076, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'640500', N'640000', N'中卫市', N'中卫', N'中国,宁夏回族自治区,中卫市', 2, N'0955      ', 751700, N'Zhongwei', 105.189568, 37.51495, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'640502', N'640500', N'沙坡头区', N'沙坡头', N'中国,宁夏回族自治区,中卫市,沙坡头区', 3, N'0955      ', 755000, N'Shapotou', 105.189621, 37.51044, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'640521', N'640500', N'中宁县', N'中宁', N'中国,宁夏回族自治区,中卫市,中宁县', 3, N'0955      ', 751200, N'Zhongning', 105.68515, 37.49149, 1)
INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'640522', N'640500', N'海原县', N'海原', N'中国,宁夏回族自治区,中卫市,海原县', 3, N'0955      ', 751800, N'Haiyuan', 105.647118, 36.56498, 1)
GO