全国、省、市、区县、乡镇、村六级地区信息表，包含百度地图坐标

SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Region]( [id] [numeric](10, 0) NOT NULL, [name] [varchar](255) NULL, [is_child] [numeric](3, 0) NULL, [level] [numeric](3, 0) NULL, [pid] [int] NULL, [sort] [int] NULL, [longcode] [varchar](12) NULL, [code] [varchar](50) NULL, [longitude] [varchar](20) NULL, [latitude] [varchar](20) NULL, [zoom] [numeric](3, 0) NULL, [precise] [int] NULL, [confidence] [int] NULL, [type] [varchar](64) NULL, [bd_cityid] [numeric](10, 0) NOT NULL, [mode] [int] NOT NULL, [created] [datetime2](7) NULL, [status] [int] NOT NULL ) ON [PRIMARY] GO INSERT [dbo].[Region] ([id], [name], [is_child], [level], [pid], [sort], [longcode], [code], [longitude], [latitude], [zoom], [precise], [confidence], [type], [bd_cityid], [mode], [created], [status]) VALUES (CAST(1 AS Numeric(10, 0)), N'中国', CAST(1 AS Numeric(3, 0)), CAST(1 AS Numeric(3, 0)), 0, 1, N'0', N'001', N'104.114129', N'37.550339', CAST(3 AS Numeric(3, 0)), NULL, NULL, NULL, CAST(1 AS Numeric(10, 0)), 30, CAST(0x07806E48DB7909390B AS DateTime2), 10) INSERT [dbo].[Region] ([id], [name], [is_child], [level], [pid], [sort], [longcode], [code], [longitude], [latitude], [zoom], [precise], [confidence], [type], [bd_cityid], [mode], [created], [status]) VALUES (CAST(2 AS Numeric(10, 0)), N'福建省', CAST(1 AS Numeric(3, 0)), CAST(2 AS Numeric(3, 0)), 1, 3, N'35', N'001001', N'117.98494311991', N'26.050118295661', CAST(8 AS Numeric(3, 0)), 0, 0, N'省', CAST(16 AS Numeric(10, 0)), 30, CAST(0x07806E48DB7909390B AS DateTime2), 10) INSERT [dbo].[Region] ([id], [name], [is_child], [level], [pid], [sort], [longcode], [code], [longitude], [latitude], [zoom], [precise], [confidence], [type], [bd_cityid], [mode], [created], [status]) VALUES (CAST(3 AS Numeric(10, 0)), N'福州市', CAST(1 AS Numeric(3, 0)), CAST(3 AS Numeric(3, 0)), 2, 1, N'3501', N'001001001', N'119.33022110713', N'26.047125496573', CAST(12 AS Numeric(3, 0)), 0, 10, N'城市', CAST(300 AS Numeric(10, 0)), 30, CAST(0x07806E48DB7909390B AS DateTime2), 10) INSERT [dbo].[Region] ([id], [name], [is_child], [level], [pid], [sort], [longcode], [code], [longitude], [latitude], [zoom], [precise], [confidence], [type], [bd_cityid], [mode], [created], [status]) VALUES (CAST(4 AS Numeric(10, 0)), N'市辖区', CAST(0 AS Numeric(3, 0)), CAST(4 AS Numeric(3, 0)), 3, 1, N'350101', N'001001001001', N'119.33022110713', N'26.047125496573', CAST(12 AS Numeric(3, 0)), 0, 10, N'城市', CAST(0 AS Numeric(10, 0)), 30, CAST(0x07806E48DB7909390B AS DateTime2), 10) INSERT [dbo].[Region] ([id], [name], [is_child], [level], [pid], [sort], [longcode], [code], [longitude], [latitude], [zoom], [precise], [confidence], [type], [bd_cityid], [mode], [created], [status]) VALUES (CAST(5 AS Numeric(10, 0)), N'鼓楼区', CAST(1 AS Numeric(3, 0)), CAST(4 AS Numeric(3, 0)), 3, 2, N'350102', N'001001001002', N'119.29063293961', N'26.097871106548', CAST(12 AS Numeric(3, 0)), 0, 20, N'区县', CAST(0 AS Numeric(10, 0)), 30, CAST(0x07806E48DB7909390B AS DateTime2), 10) INSERT [dbo].[Region] ([id], [name], [is_child], [level], [pid], [sort], [longcode], [code], [longitude], [latitude], [zoom], [precise], [confidence], [type], [bd_cityid], [mode], [created], [status]) VALUES (CAST(6 AS Numeric(10, 0)), N'鼓东街道', CAST(1 AS Numeric(3, 0)), CAST(5 AS Numeric(3, 0)), 5, 1, N'350102001', N'001001001002001', N'119.30918890057', N'26.095742498266', CAST(18 AS Numeric(3, 0)), 0, 25, N'乡镇', CAST(0 AS Numeric(10, 0)), 30, CAST(0x07806E48DB7909390B AS DateTime2), 10) INSERT [dbo].[Region] ([id], [name], [is_child], [level], [pid], [sort], [longcode], [code], [longitude], [latitude], [zoom], [precise], [confidence], [type], [bd_cityid], [mode], [created], [status]) VALUES (CAST(7 AS Numeric(10, 0)), N'中山社区', CAST(0 AS Numeric(3, 0)), CAST(6 AS Numeric(3, 0)), 6, 1, N'350102001001', N'001001001002001001', N'119.307649', N'26.101877', CAST(17 AS Numeric(3, 0)), NULL, NULL, NULL, CAST(0 AS Numeric(10, 0)), 30, CAST(0x07806�