2019年最新行政区划数据库

USE [Dsyc] GO /****** Object: Table [dbo].[Areas] Script Date: 02/20/2019 10:52:21 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Areas]( [ID] [int] IDENTITY(1,1) NOT NULL, [ParentId] [int] NULL, [LevelType] [int] NULL, [Name] [nvarchar](50) NULL, [ShortName] [nvarchar](50) NULL, [ParentPath] [nvarchar](50) NULL, [Province] [nvarchar](50) NULL, [City] [nvarchar](50) NULL, [District] [nvarchar](50) NULL, [ProvinceShortName] [nvarchar](50) NULL, [CityShortName] [nvarchar](50) NULL, [DistrictShortName] [nvarchar](50) NULL, [ProvincePinyin] [nvarchar](50) NULL, [CityPinyin] [nvarchar](50) NULL, [DistrictPinyin] [nvarchar](50) NULL, [Pinyin] [nvarchar](50) NULL, [Jianpin] [nvarchar](50) NULL, [FirstChar] [nvarchar](50) NULL, [CityCode] [nvarchar](50) NULL, [ZipCode] [nvarchar](50) NULL, [Lng] [nvarchar](50) NULL, [Lat] [nvarchar](50) NULL, [Remark1] [nvarchar](50) NULL, [Remark2] [nvarchar](50) NULL, CONSTRAINT [PK_areas] 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 SET IDENTITY_INSERT [dbo].[Areas] ON INSERT [dbo].[Areas] ([ID], [ParentId], [LevelType], [Name], [ShortName], [ParentPath], [Province], [City], [District], [ProvinceShortName], [CityShortName], [DistrictShortName], [ProvincePinyin], [CityPinyin], [DistrictPinyin], [Pinyin], [Jianpin], [FirstChar], [CityCode], [ZipCode], [Lng], [Lat], [Remark1], [Remark2]) VALUES (1, 0, 1, N'北京市', N'北京', N'110000', N'北京市', N'', N'', N'北京', N'', N'', N'beijing', N'', N'', N'beijing', N'BJ', N'B', N'110000', N'', N'116.40717', N'39.90469', N'', N'') INSERT [dbo].[Areas] ([ID], [ParentId], [LevelType], [Name], [ShortName], [ParentPath], [Province], [City], [District], [ProvinceShortName], [CityShortName], [DistrictShortName], [ProvincePinyin], [CityPinyin], [DistrictPinyin], [Pinyin], [Jianpin], [FirstChar], [CityCode], [ZipCode], [Lng], [Lat], [Remark1], [Remark2]) VALUES (2, 1, 2, N'东城区', N'东城', N'110000,110101', N'北京市', N'东城区', N'', N'北京', N'东城', N'', N'beijing', N'dongcheng', N'', N'dongcheng', N'DC', N'D', N'110101', N'', N'116.41637', N'39.92855', N'', N'') INSERT [dbo].[Areas] ([ID], [ParentId], [LevelType], [Name], [ShortName], [ParentPath], [Province], [City], [District], [ProvinceShortName], [CityShortName], [DistrictShortName], [ProvincePinyin], [CityPinyin], [DistrictPinyin], [Pinyin], [Jianpin], [FirstChar], [CityCode], [ZipCode], [Lng], [Lat], [Remark1], [Remark2]) VALUES (3, 2, 3, N'东华门街道', NULL, N'110000,110101,110101001', N'北京市', N'东城区', N'东华门街道', N'北京', N'东城', NULL, N'beijing', N'dongcheng', N'donghuamenjiedao', N'donghuamenjiedao', N'DHMJD', N'D', N'110101001', N'', N'116.4028', N'39.91583', N'', N'') INSERT [dbo].[Areas] ([ID], [ParentId], [LevelType], [Name], [ShortName], [ParentPath], [Province], [City], [District], [ProvinceShortName], [CityShortName], [DistrictShortName], [ProvincePinyin], [CityPinyin], [DistrictPinyin], [Pinyin], [Jianpin], [FirstChar], [CityCode], [ZipCode], [Lng], [Lat], [Remark1], [Remark2]) VALUES (4, 2, 3, N'景山街道', NULL, N'110000,110101,110101002', N'北京市', N'东城区', N'景山街道', N'北京', N'东城', NULL, N'beijing', N'dongcheng', N'jingshanjiedao', N'jingshanjiedao', N'JSJD', N'J', N'110101002', N'', N'116.400531', N'39.930386', N'', N'') INSERT [dbo].[Areas] ([ID], [ParentId], [LevelType], [Name], [ShortName], [ParentPath], [Province], [City], [District], [ProvinceShortName], [CityShortName], [DistrictShortName], [ProvincePinyin], [CityPinyin], [DistrictPinyin], [Pinyin], [Jianpin], [FirstChar], [CityCode], [ZipCode], [Lng], [Lat], [Remark1], [Remark2]) VALUES (5, 2, 3, N'交道口街道', NULL, N'110000,110101,110101003', N'北京市', N'东城区', N'交道口街道', N'北京', N'东城', NULL, N'beijing', N'dongcheng', N'jiaodaokoujiedao', N'jiaodaokoujiedao', N'JDKJD', N'J', N'110101003', N'', N'116.39829', N'39.93702', N'', N'') INSERT [dbo].�