全球城市名-多个素材 包含经纬度中文名英文名

/* Navicat MySQL Data Transfer Source Server : 本地 Source Server Version : 50540 Source Host : 127.0.0.1:3306 Source Database : erdai Target Server Type : MYSQL Target Server Version : 50540 File Encoding : 65001 Date: 2016-03-30 22:27:23 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for erdai_api_weather_static_heweather -- ---------------------------- DROP TABLE IF EXISTS `erdai_api_weather_static_heweather`; CREATE TABLE `erdai_api_weather_static_heweather` ( `mid` int(10) NOT NULL AUTO_INCREMENT, `city` varchar(100) DEFAULT NULL, `cnty` varchar(100) DEFAULT NULL, `id` varchar(50) DEFAULT NULL, `lat` varchar(50) DEFAULT NULL, `lon` varchar(50) DEFAULT NULL, `prov` varchar(20) DEFAULT NULL, PRIMARY KEY (`mid`), KEY `id` (`mid`,`city`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=78708 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of erdai_api_weather_static_heweather -- ---------------------------- INSERT INTO `erdai_api_weather_static_heweather` VALUES ('1', '南子岛', '中国', 'CN101310230', '11.26', '114.20', '海南'); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('2', 'Tokyo', 'Japan', 'JP1850147', '35.689499', '139.691711', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('3', 'Yokohama', 'Japan', 'JP1848354', '35.447781', '139.642502', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('4', 'Nagoya', 'Japan', 'JP1856057', '35.181469', '136.906403', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('5', 'Osaka', 'Japan', 'JP1853909', '34.693741', '135.502182', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('6', 'Kyoto', 'Japan', 'JP1857910', '35.021069', '135.753845', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('7', 'Nara', 'Japan', 'JP1855612', '34.685051', '135.804855', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('8', 'Kobe', 'Japan', 'JP1859171', '34.691299', '135.182999', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('9', 'Kochi', 'Japan', 'JP1859146', '33.559719', '133.531113', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('10', 'Hiroshima', 'Japan', 'JP1862415', '34.396271', '132.459366', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('11', 'Fukuoka', 'Japan', 'JP1863967', '33.606392', '130.41806', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('12', 'Kitakyushu', 'Japan', 'JP1859307', '33.833328', '130.833328', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('13', 'Nagasaki', 'Japan', 'JP1856177', '32.74472', '129.873611', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('14', 'Sendai', 'Japan', 'JP2111149', '38.26889', '140.871933', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('15', 'Nagano', 'Japan', 'JP1856215', '36.65139', '138.181107', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('16', 'Niigata', 'Japan', 'JP1855431', '37.902222', '139.023605', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('17', 'Aomori', 'Japan', 'JP2130658', '40.82444', '140.740005', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('18', 'Sapporo', 'Japan', 'JP2128295', '43.064171', '141.346939', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('19', 'Kagoshima', 'Japan', 'JP1860827', '31.560181', '130.558136', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('20', 'Naha', 'Japan', 'JP1856035', '26.2125', '127.681107', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('21', 'Delhi', 'India', 'IN1273294', '28.666668', '77.216667', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('22', 'Mumbai', 'India', 'IN1275339', '19.01441', '72.847939', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('23', 'Kolkata', 'India', 'IN1275004', '22.569719', '88.36972', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('24', 'Bhubaneswar', 'India', 'IN1275817', '20.23333', '85.833328', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('25', 'Visakhapatnam', 'India', 'IN1253102', '17.690041', '83.209251', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('26', 'Chennai', 'India', 'IN1264527', '13.08784', '80.278473', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('27', 'Madurai', 'India', 'IN1264521', '9.93333', '78.116669', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('28', 'Bangalore', 'India', 'IN1277333', '12.97623', '77.603287', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('29', 'Hyderabad', 'India', 'IN1269843', '17.37528', '78.474442', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('30', 'Nagpur', 'India', 'IN1262180', '21.15', '79.099998', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('31', 'Pune', 'India', 'IN1259229', '18.519569', '73.855347', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('32', 'Surat', 'India', 'IN1255364', '21.16667', '72.833328', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('33', 'Ahmedabad', 'India', 'IN1279233', '23.033333', '72.616669', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('34', 'Bikaner', 'India', 'IN1275665', '28.01667', '73.300003', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('35', 'Ludhiana', 'India', 'IN1264728', '30.9', '75.849998', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('36', 'Srinagar', 'India', 'IN1255634', '34.083328', '74.816673', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('37', 'Jaipur', 'India', 'IN1269515', '26.916668', '75.816666', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('38', 'Agra', 'India', 'IN1279259', '27.183332', '78.01667', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('39', 'Kanpur', 'India', 'IN1267995', '26.466667', '80.349998', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('40', 'Lucknow', 'India', 'IN1264733', '26.85', '80.916664', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('41', 'Patna', 'India', 'IN1260086', '25.6', '85.116669', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('42', 'Imphal', 'India', 'IN1269771', '24.816669', '93.949997', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('43', 'Port Blair', 'India', 'IN1259385', '11.66667', '92.75', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('44', 'Jakarta', 'Indonesia', 'ID1642911', '-6.21462', '106.845131', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('45', 'Bandung', 'Indonesia', 'ID1650357', '-6.90389', '107.618607', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('46', 'Medan', 'Indonesia', 'ID1214520', '3.58333', '98.666672', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('47', 'Padang', 'Indonesia', 'ID1633419', '-0.94924', '100.354271', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('48', 'Palembang', 'Indonesia', 'ID1633070', '-2.91673', '104.745796', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('49', 'Singkawang', 'Indonesia', 'ID1626916', '0.9', '109', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('50', 'Martapura', 'Indonesia', 'ID1636022', '-3.41667', '114.849998', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('51', 'Balikpapan', 'Indonesia', 'ID1650527', '-1.26753', '116.828873', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('52', 'Makassar', 'Indonesia', 'ID1622786', '-5.14', '119.422096', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('53', 'Palu', 'Indonesia', 'ID1633034', '-0.8917', '119.870697', null); INSERT INTO `erdai_api_weather_static_heweather` VALUES ('