省市区县四级联动单张表msssql.sql下载

2019最新省市县街道4级行政区域数据，自己整合的到一张表里面，可以直接生成表格数据，表格结构为CREATE TABLE [dbo].[TB_Area]( [ID] [int] IDENTITY(1,1) NOT NULL, [CODE] [nvarchar](50) NULL, [PARENT_CODE] [nvarchar](50) NULL, [NAME] [nvarchar](50) NULL, [SHORT_NAME] [nvarchar](50) NULL, [LNG] [decimal](18, 6) NULL, [LAT] [decimal](18, 6) NULL, [SORT] [int] NULL, [LEVEL] [int] NULL, CONSTRAINT [PK_TB_Area] 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'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_Area', @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'TB_Area', @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'TB_Area', @level2type=N'COLUMN',@level2name=N'PARENT_CODE' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_Area', @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'TB_Area', @level2type=N'COLUMN',@level2name=N'SHORT_NAME' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'经度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_Area', @level2type=N'COLUMN',@level2name=N'LNG' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'纬度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_Area', @level2type=N'COLUMN',@level2name=N'LAT' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'排序' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_Area', @level2type=N'COLUMN',@level2name=N'SORT' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'层级' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_Area', @level2type=N'COLUMN',@level2name=N'LEVEL' GO USE [master] GO ALTER DATABASE [AREA] SET READ_WRITE GO