百度地图-在线加载县市区

CREATE TABLE [dbo].[Whir.Region]( [Id] [int] IDENTITY(1,1) NOT NULL, [Code] [int] NULL, [ParentCode] [int] NULL, [Name] [nvarchar](50) NULL, [Level] [int] NULL, [Latitude] [nvarchar](50) NULL, [Longitude] [nvarchar](50) NULL, CONSTRAINT [PK_Whir.Region] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Whir.Region', @level2type=N'COLUMN',@level2name=N'Id' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'区域代码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Whir.Region', @level2type=N'COLUMN',@level2name=N'Code' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上级代码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Whir.Region', @level2type=N'COLUMN',@level2name=N'ParentCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'地区名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Whir.Region', @level2type=N'COLUMN',@level2name=N'Name' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'层级' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Whir.Region', @level2type=N'COLUMN',@level2name=N'Level' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'纬度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Whir.Region', @level2type=N'COLUMN',@level2name=N'Latitude' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'经度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Whir.Region', @level2type=N'COLUMN',@level2name=N'Longitude' GO SET IDENTITY_INSERT [dbo].[Whir.Region] ON INSERT [dbo].[Whir.Region] ([Id], [Code], [ParentCode], [Name], [Level], [Latitude], [Longitude]) VALUES (1, 110000, 0, N'北京市', 1, N'39.929986', N'116.395645') INSERT [dbo].[Whir.Region] ([Id], [Code], [ParentCode], [Name], [Level], [Latitude], [Longitude]) VALUES (2, 110100, 110000, N'市辖区', 2, N'', N'') INSERT [dbo].[Whir.Region] ([Id], [Code], [ParentCode], [Name], [Level], [Latitude], [Longitude]) VALUES (3, 110101, 110100, N'东城区', 3, N'39.938574', N'116.421885') INSERT [dbo].[Whir.Region] ([Id], [Code], [ParentCode], [Name], [Level], [Latitude], [Longitude]) VALUES (4, 110102, 110100, N'西城区', 3, N'9.93428', N'116.37319') INSERT [dbo].[Whir.Region] ([Id], [Code], [ParentCode], [Name], [Level], [Latitude], [Longitude]) VALUES (5, 110105, 110100, N'朝阳区', 3, N'39.958953', N'116.521695') INSERT [dbo].[Whir.Region] ([Id], [Code], [ParentCode], [Name], [Level], [Latitude], [Longitude]) VALUES (6, 110106, 110100, N'丰台区', 3, N'9.841938', N'116.25837') INSERT [dbo].[Whir.Region] ([Id], [Code], [ParentCode], [Name], [Level], [Latitude], [Longitude]) VALUES (7, 110107, 110100, N'石景山区', 3, N'39.938867', N'116.184556') INSERT [dbo].[Whir.Region] ([Id], [Code], [ParentCode], [Name], [Level], [Latitude], [Longitude]) VALUES (8, 110108, 110100, N'海淀区', 3, N'40.033162', N'116.239678') INSERT [dbo].[Whir.Region] ([Id], [Code], [ParentCode], [Name], [Level], [Latitude], [Longitude]) VALUES (9, 110109, 110100, N'门头沟区', 3, N'40.000893', N'115.795795') INSERT [dbo].[Whir.Region] ([Id], [Code], [ParentCode], [Name], [Level], [Latitude], [Longitude]) VALUES (10, 110111, 110100, N'房山区', 3, N'39.726753', N'115.862836') INSERT [dbo].[Whir.Region] ([Id], [Code], [ParentCode], [Name], [Level], [Latitude], [Longitude]) VALUES (11, 110112, 110100, N'通州区', 3, N'39.809815', N'116.740079') INSERT [dbo].[Whir.Region] ([Id], [Code], [ParentCode], [Name], [Level], [Latitude], [Longitude]) VALUES (12, 110113, 110100, N'顺义区', 3, N'40.154951', N'116.728229') INSERT [dbo].[Whir.Region] �