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] �
- 1
- 2
- 3
- 4
前往页