/*
Navicat SQL Server Data Transfer
Source Server : 121.42.179.208
Source Server Version : 105000
Source Host : 121.42.179.208:1433
Source Database : EastAgriculture
Source Schema : db_wechat_jz
Target Server Type : SQL Server
Target Server Version : 105000
File Encoding : 65001
Date: 2016-02-04 09:02:42
*/
-- ----------------------------
-- Table structure for areas
-- ----------------------------
DROP TABLE [db_wechat_jz].[areas]
GO
CREATE TABLE [db_wechat_jz].[areas] (
[id] NVARCHAR(10) NULL ,
[areaname] NVARCHAR(100) NULL ,
[parentid] NVARCHAR(10) NULL ,
[shortname] NVARCHAR(50) NULL ,
[lng] NVARCHAR(30) NULL ,
[lat] NVARCHAR(30) NULL ,
[LEVEL] INT NULL ,
[POSITION] NVARCHAR(100) NULL ,
[sort] INT NULL
)
GO
-- ----------------------------
-- Records of areas
-- ----------------------------
INSERT INTO [db_wechat_jz].[areas] ([id], [areaname], [parentid], [shortname], [lng], [lat], [LEVEL], [POSITION], [sort]) VALUES (N'110000', N'北京', N'0', N'北京', N'116.405289', N'39.904987', N'1', N'tr_0', N'1')
GO
GO
INSERT INTO [db_wechat_jz].[areas] ([id], [areaname], [parentid], [shortname], [lng], [lat], [LEVEL], [POSITION], [sort]) VALUES (N'110100', N'北京市', N'110000', N'北京', N'116.405289', N'39.904987', N'2', N'tr_0 tr_110000', N'1')
GO
GO
INSERT INTO [db_wechat_jz].[areas] ([id], [areaname], [parentid], [shortname], [lng], [lat], [LEVEL], [POSITION], [sort]) VALUES (N'110101', N'东城区', N'110100', N'东城', N'116.418755', N'39.917545', N'3', N'tr_0 tr_110000 tr_110100', N'3')
GO
GO
INSERT INTO [db_wechat_jz].[areas] ([id], [areaname], [parentid], [shortname], [lng], [lat], [LEVEL], [POSITION], [sort]) VALUES (N'110102', N'西城区', N'110100', N'西城', N'116.366791', N'39.91531', N'3', N'tr_0 tr_110000 tr_110100', N'15')
GO
GO
INSERT INTO [db_wechat_jz].[areas] ([id], [areaname], [parentid], [shortname], [lng], [lat], [LEVEL], [POSITION], [sort]) VALUES (N'110105', N'朝阳区', N'110100', N'朝阳', N'116.486412', N'39.92149', N'3', N'tr_0 tr_110000 tr_110100', N'2')
GO
GO
INSERT INTO [db_wechat_jz].[areas] ([id], [areaname], [parentid], [shortname], [lng], [lat], [LEVEL], [POSITION], [sort]) VALUES (N'110106', N'丰台区', N'110100', N'丰台', N'116.286964', N'39.863644', N'3', N'tr_0 tr_110000 tr_110100', N'6')
GO
GO
INSERT INTO [db_wechat_jz].[areas] ([id], [areaname], [parentid], [shortname], [lng], [lat], [LEVEL], [POSITION], [sort]) VALUES (N'110107', N'石景山区', N'110100', N'石景山', N'116.195442', N'39.9146', N'3', N'tr_0 tr_110000 tr_110100', N'12')
GO
GO
INSERT INTO [db_wechat_jz].[areas] ([id], [areaname], [parentid], [shortname], [lng], [lat], [LEVEL], [POSITION], [sort]) VALUES (N'110108', N'海淀区', N'110100', N'海淀', N'116.310318', N'39.956074', N'3', N'tr_0 tr_110000 tr_110100', N'7')
GO
GO
INSERT INTO [db_wechat_jz].[areas] ([id], [areaname], [parentid], [shortname], [lng], [lat], [LEVEL], [POSITION], [sort]) VALUES (N'110109', N'门头沟区', N'110100', N'门头沟', N'116.105377', N'39.937183', N'3', N'tr_0 tr_110000 tr_110100', N'9')
GO
GO
INSERT INTO [db_wechat_jz].[areas] ([id], [areaname], [parentid], [shortname], [lng], [lat], [LEVEL], [POSITION], [sort]) VALUES (N'110111', N'房山区', N'110100', N'房山', N'116.13916', N'39.735535', N'3', N'tr_0 tr_110000 tr_110100', N'5')
GO
GO
INSERT INTO [db_wechat_jz].[areas] ([id], [areaname], [parentid], [shortname], [lng], [lat], [LEVEL], [POSITION], [sort]) VALUES (N'110112', N'通州区', N'110100', N'通州', N'116.6586', N'39.902485', N'3', N'tr_0 tr_110000 tr_110100', N'14')
GO
GO
INSERT INTO [db_wechat_jz].[areas] ([id], [areaname], [parentid], [shortname], [lng], [lat], [LEVEL], [POSITION], [sort]) VALUES (N'110113', N'顺义区', N'110100', N'顺义', N'116.653526', N'40.128937', N'3', N'tr_0 tr_110000 tr_110100', N'13')
GO
GO
INSERT INTO [db_wechat_jz].[areas] ([id], [areaname], [parentid], [shortname], [lng], [lat], [LEVEL], [POSITION], [sort]) VALUES (N'110114', N'昌平区', N'110100', N'昌平', N'116.235909', N'40.218086', N'3', N'tr_0 tr_110000 tr_110100', N'1')
GO
GO
INSERT INTO [db_wechat_jz].[areas] ([id], [areaname], [parentid], [shortname], [lng], [lat], [LEVEL], [POSITION], [sort]) VALUES (N'110115', N'大兴区', N'110100', N'大兴', N'116.338036', N'39.728909', N'3', N'tr_0 tr_110000 tr_110100', N'4')
GO
GO
INSERT INTO [db_wechat_jz].[areas] ([id], [areaname], [parentid], [shortname], [lng], [lat], [LEVEL], [POSITION], [sort]) VALUES (N'110116', N'怀柔区', N'110100', N'怀柔', N'116.637123', N'40.324272', N'3', N'tr_0 tr_110000 tr_110100', N'8')
GO
GO
INSERT INTO [db_wechat_jz].[areas] ([id], [areaname], [parentid], [shortname], [lng], [lat], [LEVEL], [POSITION], [sort]) VALUES (N'110117', N'平谷区', N'110100', N'平谷', N'117.112335', N'40.144783', N'3', N'tr_0 tr_110000 tr_110100', N'11')
GO
GO
INSERT INTO [db_wechat_jz].[areas] ([id], [areaname], [parentid], [shortname], [lng], [lat], [LEVEL], [POSITION], [sort]) VALUES (N'110228', N'密云县', N'110100', N'密云', N'116.843353', N'40.377361', N'3', N'tr_0 tr_110000 tr_110100', N'10')
GO
GO
INSERT INTO [db_wechat_jz].[areas] ([id], [areaname], [parentid], [shortname], [lng], [lat], [LEVEL], [POSITION], [sort]) VALUES (N'110229', N'延庆县', N'110100', N'延庆', N'115.985008', N'40.465324', N'3', N'tr_0 tr_110000 tr_110100', N'16')
GO
GO
INSERT INTO [db_wechat_jz].[areas] ([id], [areaname], [parentid], [shortname], [lng], [lat], [LEVEL], [POSITION], [sort]) VALUES (N'120000', N'天津', N'0', N'天津', N'117.190186', N'39.125595', N'1', N'tr_0', N'2')
GO
GO
INSERT INTO [db_wechat_jz].[areas] ([id], [areaname], [parentid], [shortname], [lng], [lat], [LEVEL], [POSITION], [sort]) VALUES (N'120100', N'天津市', N'120000', N'天津', N'117.190186', N'39.125595', N'2', N'tr_0 tr_120000', N'1')
GO
GO
INSERT INTO [db_wechat_jz].[areas] ([id], [areaname], [parentid], [shortname], [lng], [lat], [LEVEL], [POSITION], [sort]) VALUES (N'120101', N'和平区', N'120100', N'和平', N'117.195908', N'39.118328', N'3', N'tr_0 tr_120000 tr_120100', N'7')
GO
GO
INSERT INTO [db_wechat_jz].[areas] ([id], [areaname], [parentid], [shortname], [lng], [lat], [LEVEL], [POSITION], [sort]) VALUES (N'120102', N'河东区', N'120100', N'河东', N'117.22657', N'39.122124', N'3', N'tr_0 tr_120000 tr_120100', N'6')
GO
GO
INSERT INTO [db_wechat_jz].[areas] ([id], [areaname], [parentid], [shortname], [lng], [lat], [LEVEL], [POSITION], [sort]) VALUES (N'120103', N'河西区', N'120100', N'河西', N'117.217537', N'39.101898', N'3', N'tr_0 tr_120000 tr_120100', N'8')
GO
GO
INSERT INTO [db_wechat_jz].[areas] ([id], [areaname], [parentid], [shortname], [lng], [lat], [LEVEL], [POSITION], [sort]) VALUES (N'120104', N'南开区', N'120100', N'南开', N'117.164146', N'39.120476', N'3', N'tr_0 tr_120000 tr_120100', N'13')
GO
GO
INSERT INTO [db_wechat_jz].[areas] ([id], [areaname], [parentid], [shortname], [lng], [lat], [LEVEL], [POSITION], [sort]) VALUES (N'120105', N'河北区', N'120100', N'河北', N'117.201569', N'39.156631', N'3', N'tr_0 tr_120000 tr_120100', N'5')
GO
GO
INSERT INTO [db_wechat_jz].[areas] ([id], [areaname], [parentid], [shortname], [lng], [lat], [LEVEL], [POSITION], [sort]) VALUES (N'120106', N'红桥区', N'120100', N'红桥', N'117.1633', N'39.175068', N'3', N'tr_0 tr_120000 tr_120100', N'9')
GO
GO
INSERT INTO [db_wechat_jz].[areas] ([id], [areaname], [parentid], [shortname], [lng], [lat], [LEVEL], [POSITION], [sort]) VALUES (N'120110', N'东丽区', N'120100', N'东丽', N'117.313965', N'39.087765', N'3', N'tr_0 tr_120000 tr_120100', N'4')
GO
GO
INSERT INTO [db_wechat_jz].[areas] ([id], [areaname], [parentid], [shortname], [lng], [lat], [LEVEL], [POSITION], [sort]) VALUES (N'120111', N'西青区', N'120100', N'西青', N'117.012245', N'39.139446', N'3', N'tr_0 tr_120000 tr_120100', N'16')
GO
GO
I
