SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for tpt_data_jingdian
-- ----------------------------
DROP TABLE IF EXISTS `tpt_data_jingdian`;
CREATE TABLE `tpt_data_jingdian` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(67) DEFAULT NULL,
`tel` varchar(69) DEFAULT NULL,
`add` varchar(190) DEFAULT NULL,
`type` varchar(176) DEFAULT NULL,
`areaid` varchar(7) DEFAULT NULL,
`poiid` varchar(11) DEFAULT NULL,
`gcjx` varchar(11) DEFAULT NULL,
`gcjy` varchar(10) DEFAULT NULL,
`gpsx` double DEFAULT NULL,
`gpsy` double DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=324499 DEFAULT CHARSET=gbk;
-- ----------------------------
-- Records of tpt_data_jingdian
-- ----------------------------
INSERT INTO `tpt_data_jingdian` VALUES ('1', '礼王府', '', '西黄城根南街9号', '风景名胜;风景名胜;风景名胜', '110102', 'B000A81F8Z', '116.377178', '39.919584', '116.370948', '39.918193');
INSERT INTO `tpt_data_jingdian` VALUES ('2', '北京动物园(北2门)', '', '五塔寺路22号', '风景名胜;风景名胜相关;旅游景点', '110108', 'B000A81FAR', '116.333487', '39.944157', '116.327336', '39.942834');
INSERT INTO `tpt_data_jingdian` VALUES ('3', '北京动物园(东北门)', '', '西直门外大街137号北京动物园', '风景名胜;公园广场;动物园', '110108', 'B000A81FAS', '116.33513', '39.944932', '116.328975', '39.943605');
INSERT INTO `tpt_data_jingdian` VALUES ('4', '护国寺金刚殿', '010-66173524', '护国寺大街93号', '风景名胜;风景名胜;寺庙道观', '110102', 'B000A81FB7', '116.375228', '39.935893', '116.368998', '39.934503');
INSERT INTO `tpt_data_jingdian` VALUES ('5', '玲珑公园(南门)', '010-88131225', '西八里庄北里3号', '风景名胜;公园广场;公园', '110108', 'B000A81FCS', '116.295136', '39.927262', '116.289068', '39.926008');
INSERT INTO `tpt_data_jingdian` VALUES ('6', '元大都城垣遗址公园(西4门)', '', '北土城东路元大都城垣遗址公园(西4门)附近', '风景名胜;公园广场;公园', '110105', 'B000A81FGU', '116.381798', '39.975717', '116.375555', '39.974319');
INSERT INTO `tpt_data_jingdian` VALUES ('7', '北京基督教会宽街堂', '010-84039432', '地安门东大街吉祥胡同10号', '风景名胜;风景名胜;教堂', '110101', 'B000A81FGV', '116.400871', '39.933105', '116.394624', '39.9317');
INSERT INTO `tpt_data_jingdian` VALUES ('8', '三洞七楼琉璃牌坊', '', '朝阳门外大街甲12附近', '风景名胜;风景名胜;风景名胜', '110105', 'B000A81FGW', '116.443851', '39.923305', '116.437656', '39.921938');
INSERT INTO `tpt_data_jingdian` VALUES ('9', '联馨园', '', '金台西路2号', '风景名胜;公园广场;公园', '110105', 'B000A81FGX', '116.468604', '39.920847', '116.462481', '39.919535');
INSERT INTO `tpt_data_jingdian` VALUES ('10', '亚运村升旗广场', '', '北辰东路8号院', '风景名胜;公园广场;城市广场', '110105', 'B000A81FGZ', '116.403552', '39.993398', '116.397297', '39.991991');
INSERT INTO `tpt_data_jingdian` VALUES ('11', '田汉故居', '', '细管胡同9号', '风景名胜;风景名胜;风景名胜', '110101', 'B000A81FH2', '116.415566', '39.937198', '116.409324', '39.935797');
INSERT INTO `tpt_data_jingdian` VALUES ('12', '安定门健身乐园', '', '安定门东大街', '风景名胜;公园广场;公园', '110101', 'B000A81FH3', '116.414432', '39.949592', '116.408188', '39.948189');
INSERT INTO `tpt_data_jingdian` VALUES ('13', '和平街社区乐雅园', '', '青年沟路与和平里东街交汇', '风景名胜;公园广场;公园', '110105', 'B000A81FH4', '116.424696', '39.962873', '116.418461', '39.961478');
INSERT INTO `tpt_data_jingdian` VALUES ('14', '地坛公园', '010-51654966;010-64214657', '安定门外大街2号', '风景名胜;公园广场;公园', '110101', 'B000A81FMM', '116.415492', '39.953927', '116.409248', '39.952525');
INSERT INTO `tpt_data_jingdian` VALUES ('15', '祥和园(北京朝阳商业大楼东北)', '', '香河园', '风景名胜;公园广场;公园', '110105', 'B000A81FNZ', '116.440904', '39.963124', '116.434698', '39.96175');
INSERT INTO `tpt_data_jingdian` VALUES ('16', '大慈真如宝殿', '', '文津街1号北海公园', '风景名胜;风景名胜;风景名胜', '110102', 'B000A81FOH', '116.3884', '39.932254', '116.382157', '39.930853');
INSERT INTO `tpt_data_jingdian` VALUES ('17', '天王殿', '', '文津街1号北海公园', '风景名胜;风景名胜;风景名胜', '110102', 'B000A81FOJ', '116.388389', '39.931935', '116.382146', '39.930534');
INSERT INTO `tpt_data_jingdian` VALUES ('18', '九龙壁', '', '文津街1号北海公园', '风景名胜;风景名胜;风景名胜', '110102', 'B000A81FOL', '116.387633', '39.931925', '116.381391', '39.930525');
INSERT INTO `tpt_data_jingdian` VALUES ('19', '鼓楼', '010-67251888', '新街口', '风景名胜;风景名胜;风景名胜|风景名胜;公园广场;城市广场', '110101', 'B000A81FPU', '116.395939', '39.940786', '116.389692', '39.939382');
INSERT INTO `tpt_data_jingdian` VALUES ('20', '北京市朝阳区四得公园(东门)', '', '芳园西路', '风景名胜;公园广场;公园', '110105', 'B000A81FQN', '116.477081', '39.970334', '116.470981', '39.969043');
INSERT INTO `tpt_data_jingdian` VALUES ('21', '红领巾公园(东1门)', '', '石佛营路附近', '风景名胜;公园广场;公园', '110105', 'B000A81FRX', '116.495843', '39.925538', '116.489818', '39.924303');
INSERT INTO `tpt_data_jingdian` VALUES ('22', '泰康新生活广场(南门)', '', '复兴门内大街156', '风景名胜;公园广场;城市广场', '110102', 'B000A81G7I', '116.362029', '39.905894', '116.355823', '39.904522');
INSERT INTO `tpt_data_jingdian` VALUES ('23', '宝应寺', '', '登莱胡同29号', '风景名胜;风景名胜;寺庙道观', '110102', 'B000A81G8E', '116.35456', '39.888121', '116.34837', '39.886762');
INSERT INTO `tpt_data_jingdian` VALUES ('24', '报国寺', '010-63030976;010-63173169', '报国寺1号', '风景名胜;风景名胜;寺庙道观', '110102', 'B000A81GD9', '116.359528', '39.891165', '116.353328', '39.889798');
INSERT INTO `tpt_data_jingdian` VALUES ('25', '清真寺(文体路)', '', '电报局街5号', '风景名胜;风景名胜;回教寺', '110106', 'B000A81GF3', '116.286104', '39.849773', '116.28006', '39.848536');
INSERT INTO `tpt_data_jingdian` VALUES ('26', '金台书院', '010-67011700', '天坛', '风景名胜;风景名胜;风景名胜', '110101', 'B000A81GID', '116.411005', '39.891097', '116.404766', '39.889695');
INSERT INTO `tpt_data_jingdian` VALUES ('27', '护国资福禅寺', '010-60681175;010-60681595;010-60681639', '红螺东路2号', '风景名胜;风景名胜;寺庙道观', '110116', 'B000A01CD7', '116.625474', '40.375348', '116.619603', '40.374233');
INSERT INTO `tpt_data_jingdian` VALUES ('28', '番字石刻', '', '番字牌', '风景名胜;风景名胜;风景名胜', '110228', 'B000A027E2', '116.891213', '40.7398', '116.885184', '40.738494');
INSERT INTO `tpt_data_jingdian` VALUES ('29', '八大处公园', '010-88963288', '西五环', '风景名胜;公园广场;公园', '110107', 'B000A0285C', '116.180816', '39.957553', '116.174658', '39.95626');
INSERT INTO `tpt_data_jingdian` VALUES ('30', '银狐洞园区', '010-60363236;010-60363050', '佛子庄乡下英水村', '风景名胜;风景名胜;国家级景点', '110111', 'B000A02862', '115.896616', '39.801673', '115.890689', '39.800656');
INSERT INTO `tpt_data_jingdian` VALUES ('31', '金顶妙峰山', '010-61882936;010-61882937;010-61882935', '妙峰山景区管理处', '风景名胜;风景名胜;省级景点', '110109', 'B000A02866', '116.02762', '40.065098', '116.021379', '40.0638');
INSERT INTO `tpt_data_jingdian` VALUES ('32', '丫髻山旅游风景区', '010-61971063;010-61972535', '刘店乡', '风景名胜;风景名胜;风景名胜', '110117', 'B000A02880', '116.977779', '40.281242', '116.971601', '4
评论0