data.sql

-- phpMyAdmin SQL Dump
-- version 4.6.4
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: 2017-08-02 07:38:19
-- 服务器版本： 5.6.35
-- PHP Version: 7.1.6

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `cubingchina`
--

--
-- 转存表中的数据 `config`
--

INSERT INTO `config` (`id`, `title`, `title_zh`, `content`, `content_zh`, `status`) VALUES
('disclaimer', 'Disclaimer', '免责声明', '<p style="box-sizing:border-box;margin-top:0px;margin-bottom:1.1em;color:#3F3F3F;font-family:&quot;font-size:18px;text-align:justify;white-space:normal;background-color:#F6F6F6;outline:none !important;">\r\n	Cubing China is an information sharing platform for speedsolving competitions. The information is provided by various organizing teams, and while we endeavour to urge all the organizing teams to keep the information up to date and correct, we make no representations or warranties of any kind, express or implied, about the completeness, accuracy, reliability, suitability or availability with respect to the information posted on our website and take no responsibilities for any behaviors of any organizing team or any individual organizer. These behaviors will include but not limited to the following.\r\n</p>\r\n<ol style="box-sizing:border-box;margin-top:0px;margin-bottom:1.1em;color:#3F3F3F;font-family:&quot;font-size:18px;text-align:justify;white-space:normal;background-color:#F6F6F6;outline:none !important;">\r\n	<li style="box-sizing:border-box;outline:none !important;">\r\n		The actual implementation detail may not meet the information listed on Cubing China that are preannounced by the organizing team. Due to certain reasons, the organizing team may change the following pieces of information and their implementation:&nbsp;<br style="box-sizing:border-box;outline:none !important;" />\r\na. The date and the venue of the competition&nbsp;<br style="box-sizing:border-box;outline:none !important;" />\r\nb. The schedule and events of the competition&nbsp;<br style="box-sizing:border-box;outline:none !important;" />\r\nc. The number of prizes&nbsp;<br style="box-sizing:border-box;outline:none !important;" />\r\nd. The number of cash prizes&nbsp;<br style="box-sizing:border-box;outline:none !important;" />\r\ne. The money transferring time and method of cash prizes&nbsp;<br style="box-sizing:border-box;outline:none !important;" />\r\nCubing China is not responsible for any loss, damage, cost, or expense due to the incomplete, inaccurate information posted by any organizing team or any misbehavior of any organizing team or any individual organizer.\r\n	</li>\r\n	<li style="box-sizing:border-box;outline:none !important;">\r\n		Cubing China offers online payment service to collect registration fees for competitions using our website. Any changes after the registration are not part of our payment service. Please contact the corresponding organizing team for further payments or refunds regarding your registration fees.\r\n	</li>\r\n	<li style="box-sizing:border-box;outline:none !important;">\r\n		Cubing China does not oversee the money usage of any organizing team. For details of expenditure on registration fees, please contact the corresponding organizing team of competitions which you participated.\r\n	</li>\r\n	<li style="box-sizing:border-box;outline:none !important;">\r\n		Cubing China does not sell any gifts or souvenirs at the moment, please contact the corresponding organizing team for customer service regarding gifts or souvenirs.\r\n	</li>\r\n	<li style="box-sizing:border-box;outline:none !important;">\r\n		Cubing China takes no responsibilities for any accidents or disputes happened at the venue.\r\n	</li>\r\n	<li style="box-sizing:border-box;outline:none !important;">\r\n		Cubing China takes no responsibilities for any accidents or disputes happened throughout the whole organizing process of any competitions whether it is within the organizing team or between the organizing team and a third party.\r\n	</li>\r\n	<li style="box-sizing:border-box;outline:none !important;">\r\n		Results of non-WCA competitions will not be posted on Cubing China. Please contact the corresponding organizing team or related organizations for further announcements regarding your results.\r\n	</li>\r\n	<li style="box-sizing:border-box;outline:none !important;">\r\n		Cubing China does not hold the copyright to any text, figure or illustration posted on our website. We do not endorse any views expressed or products or services offered by any organizing team.\r\n	</li>\r\n</ol>', '<p style="box-sizing:border-box;margin-top:0px;margin-bottom:1.1em;color:#3F3F3F;font-family:&quot;font-size:18px;text-align:justify;white-space:normal;background-color:#F6F6F6;outline:none !important;">\r\n	粗饼网只是赛事信息公开发布的平台与各比赛主办团队并无任何约束关系，不对各地主办团队的具体行为负责。这些具体行为包括且不限于：\r\n</p>\r\n<ol style="box-sizing:border-box;margin-top:0px;margin-bottom:1.1em;color:#3F3F3F;font-family:&quot;font-size:18px;text-align:justify;white-space:normal;background-color:#F6F6F6;outline:none !important;">\r\n	<li style="box-sizing:border-box;outline:none !important;">\r\n		比赛具体实施与公布信息不符：&nbsp;<br style="box-sizing:border-box;outline:none !important;" />\r\na. 比赛基本信息（比赛时间、地点、交通、住宿等）与公布信息不符。&nbsp;<br style="box-sizing:border-box;outline:none !important;" />\r\nb. 比赛当日比赛项目、轮次、时间与公布的赛程不同。&nbsp;<br style="box-sizing:border-box;outline:none !important;" />\r\nc. 比赛当日发放的奖品种类、数量与宣传上有差别。&nbsp;<br style="box-sizing:border-box;outline:none !important;" />\r\nd. 比赛奖金的数目、发放的时间与方式与赛前公示有出入。&nbsp;<br style="box-sizing:border-box;outline:none !important;" />\r\n相关赛事信息以主办方官方公布的信息为准，若因以上原因导致参赛选手未能完赛或产生经济等方面损失与粗饼网无关。\r\n	</li>\r\n	<li style="box-sizing:border-box;outline:none !important;">\r\n		赛事相关费用的增补与退还，由各地主办团队负责。粗饼网仅提供代收比赛报名费的业务，对于具体的增补、退还请联系比赛主办团队。\r\n	</li>\r\n	<li style="box-sizing:border-box;outline:none !important;">\r\n		赛事报名费的明细开支，由各地主办团队负责。粗饼网仅提供代收部分赛事报名费。\r\n	</li>\r\n	<li style="box-sizing:border-box;outline:none !important;">\r\n		比赛周边各类纪念品的出售、售后。粗饼目前没有任何周边纪念品出售，各类比赛周边纪念品的出售、售后请联系比赛主办方。\r\n	</li>\r\n	<li style="box-sizing:border-box;outline:none !important;">\r\n		比赛现场的意外事件。任何在比赛现场发生的意外或纠纷与粗饼网无关。\r\n	</li>\r\n	<li style="box-sizing:border-box;outline:none !important;">\r\n		主办团队内部纠纷或与第三方产生的纠纷。主办团队在比赛筹备、筹办、组织、实施的过程中产生的任何形式的纠纷与粗饼网无关，请联系利益相关方处理矛盾或纠纷。\r\n	</li>\r\n	<li style="box-sizing:border-box;outline:none !important;">\r\n		非WCA比赛的成绩公示、成绩查询。对于非WCA比赛，请联系该赛事认证方、比赛组织团队查询比赛成绩。\r\n	</li>\r\n	<li style="box-sizing:border-box;outline:none !important;">\r\n		粗饼网所使用的文字、图片均是相关赛事的新闻报道，本站不持有相关版权。所有由用户发布的信息，不代表本站观点。\r\n	</li>\r\n</ol>', 1);

--
-- 转存表中的数据 `faq_category`
--

INSERT INTO `faq_category` (`id`, `user_id`, `name`, `name_zh`, `date`, `status`) VALUES
(2, 2, 'For Organizers', '主办须知', 0, 1),
(1, 2, 'For Competitiors', '选手须知', 0, 1);

--
-- 转存表中的数据 `migration`
--

INSERT INTO `migration` (`version`, `apply_time`) VALUES
('m000000_000000_base', 1483599389),
('m170105_055652_add_coloums_for_pay_table', 1483599389),
('m170115_091016_competition_application', 1490882233),
('m170225_225755_add_column_reason', 1490882233),
('m170322_132036_add_coordinates', 1490887266),
('m170330_084501_add_create_time_and_update_time', 1490887266),
('m170330_134430_create_table_preferred_event', 1490888212),
('m170410_124332_add_unique_index', 1491901361),
('m170414_074455_add_confirm_time', 1492158571),
('m170423_124259_split_events', 1495523748),
('m170529_020116_move_passport_info', 1496282800),
('m170529_063322_entourage_limit', 1496282800),
('m170605_045721_add_accept_time', 1497368635),
('m170617_122508_add_podiums_options', 1497775631),
('m170704_115254_add_cancel_time', 1499436386),
('m170704_182916_add_refund_columns', 1499436386),
('m170706_164824_add_cancellation_end_and_reopen_time', 1499436386),
('m170706_180859_add_has_been_full', 1499436386),
('m170716_101024_add_guest_paid', 1500419754),
('m170716_192203_rename_heat_to_group', 1500768920),
('m170726_050625_add_more_podiums_options', 1501137990);

--
-- 转存表中的数据 `news_template`
--

INSERT INTO `news_template` (`id`, `name`, `title`, `title_zh`, `content`, `content_zh`) VALUES
(1, '比赛公示及报名', '{$competition->name} Announcement and Registration', '{$competition->name_zh}公示及报名', '{$competition->name} will take place on {date(\'M. j\' . ($competition->end_date > 0 && date(\'Y\', $competition->date) != date(\'Y\', $competition->end_date) ? \' Y\' : \'\'), $competition->date) . ($competition->end_date > 0 ? \' - \' . (date(\'Y\', $competition->date) != date(\'Y\', $competition->end_date) ? date(\'M. j Y\', $competition->end_date) : (date(\'n\', $competition->date) != date(\'n\', $competition->end_date) ? date(\'M. j\', $competition->end_date) : date(\'j\', $competition->end_date))) : \'\')} in {$competition->location[0]->city->name}, {$competition->location[0]->province->name}. The online registration {$competition->reg_start<=time() ? \'is open\': \'will be open on \' . date(\'M.j H:i\', $competition->reg_start)}. Please check out the <a href="{$competition->url}">competition website</a> for more information and registration.', '{$competition->name_zh}将于{date(\'Y年n月j日\', $competition->date) . ($competition->end_date > 0 ? \'至\' . (date(\'Y\', $competition->date) != date(\'Y\', $competition->end_date) ? date(\'Y年n月j日\', $competition->end_date) : (date(\'n\', $competition->date) != date(\'n\', $competition->end_date) ? date(\'n月j日\', $competition->end_date) : date(\'j日\', $competition->end_date))) : \'\')}在{$competition->location[0]->province->name_zh}{$competition->location[0]->city->name_zh}举行。在线报名{$competition->reg_start<=time() ? \'已开放\': date(\'将于m月d日 H:i开放\', $competition->reg_start)}，请点击<a href="{$competition->url}">比赛网站</a>报名及查阅更多相关信息。'),
(2, 'WCA比赛成绩公示', '{$winner->name} wins {$competition->name}', '{$competition->name_zh}成绩公布：{$winner->name_zh}夺冠', '<p>\r\n	{$winner->link} won the {$competition->name} with an average of {$winner->score}. {$runnerUp->link} finished second ({$runnerUp->score}) and {$secondRunnerUp->link} finished third ({$secondRunnerUp->score}).<br />\r\nFull results are on the&nbsp;<a href="/results/competition/{$competition->wca_competition_id}">Cubing China page</a>.\r\n{$records}\r\n</p>', '<p>\r\n	{$winner->link_zh}以{$event->name_zh}平均{$winner->score_zh}的成绩夺得{$competition->name_zh}冠军！{$runnerUp->link_zh}和{$secondRunnerUp->link_zh}分获亚军和季军，成绩分别为{$runnerUp->score_zh}和{$secondRunnerUp->score_zh}。<br />\r\n详细赛果请点击<a href="/results/competition/{$competition->wca_competition_id}">比赛成绩页</a>查阅。\r\n{$records_zh}\r\n</p>');

--
-- 转存表中的数据 `region`
--

INSERT INTO `region` (`id`, `name`, `name_zh`, `pid`, `longitude`, `latitude`, `second_offset`) VALUES
(1, 'China', '中国', 0, 0.000000000, 0.000000000, 0),
(2, 'Hong Kong', '香港', 0, 0.000000000, 0.000000000, 0),
(3, 'Macau', '澳門', 0, 0.000000000, 0.000000000, 0),
(4, 'Taiwan', '中華台北', 0, 0.000000000, 0.000000000, 0),
(5, 'Afghanistan', 'Afghanistan', 0, 0.000000000, 0.000000000, 0),
(6, 'Albania', 'Albania', 0, 0.000000000, 0.000000000, 0),
(7, 'Algeria', 'Algeria', 0, 0.000000000, 0.000000000, 0),
(8, 'Angola', 'Angola', 0, 0.000000000, 0.000000000, 0),
(9, 'Anguilla', 'Anguilla', 0, 0.000000000, 0.000000000, 0),
(10, 'Antigua', 'Antigua', 0, 0.000000000, 0.000000000, 0),
(11, 'Argentina', 'Argentina', 0, 0.000000000, 0.000000000, 0),
(12, 'Armenia', 'Armenia', 0, 0.000000000, 0.000000000, 0),
(13, 'Aruba', 'Aruba', 0, 0.000000000, 0.000000000, 0),
(14, 'Australia', 'Australia', 0, 0.000000000, 0.000000000, 0),
(15, 'Austria', 'Austria', 0, 0.000000000, 0.000000000, 0),
(16, 'Azerbaijan', 'Azerbaijan', 0, 0.000000000, 0.000000000, 0),
(17, 'Bahamas', 'Bahamas', 0, 0.000000000, 0.000000000, 0),
(18, 'Bahrain', 'Bahrain', 0, 0.000000000, 0.000000000, 0),
(19, 'Bangladesh', 'Bangladesh', 0, 0.000000000, 0.000000000, 0),
(20, 'Barbados', 'Barbados', 0, 0.000000000, 0.000000000, 0),
(21, 'Belarus', 'Belarus', 0, 0.000000000, 0.000000000, 0),
(22, 'Belgium', 'Belgium', 0, 0.000000000, 0.000000000, 0),
(23, 'Belize', 'Belize', 0, 0.000000000, 0.000000000, 0),
(24, 'Benin', 'Benin', 0, 0.000000000, 0.000000000, 0),
(25, 'Bhutan', 'Bhutan', 0, 0.000000000, 0.000000000, 0),
(26, 'Bolivia', 'Bolivia', 0, 0.000000000, 0.000000000, 0),
(27, 'Bosnia and Herzegovina', 'Bosnia and Herzegovina', 0, 0.000000000, 0.000000000, 0),
(28, 'Botswana', 'Botswana', 0, 0.000000000, 0.000000000, 0),
(29, 'Brazil', 'Brazil', 0, 0.000000000, 0.000000000, 0),
(30, 'British Virgin Islands', 'British Virgin Islands', 0, 0.000000000, 0.000000000, 0),
(31, 'Brunei', 'Brunei', 0, 0.000000000, 0.000000000, 0),
(32, 'Bulgaria', 'Bulgaria', 0, 0.000000000, 0.000000000, 0),
(33, 'Burkina Faso', 'Burkina Faso', 0, 0.000000000, 0.000000000, 0),
(34, 'Cambodia', 'Cambodia', 0, 0.000000000, 0.000000000, 0),
(35, 'Cameroon', 'Cameroon', 0, 0.000000000, 0.000000000, 0),
(36, 'Canada', 'Canada', 0, 0.000000000, 0.000000000, 0),
(37, 'Central African Republic', 'Central African Republic', 0, 0.000000000, 0.000000000, 0),
(38, 'Chad', 'Chad', 0, 0.000000000, 0.000000000, 0),
(39, 'Chile', 'Chile', 0, 0.000000000, 0.000000000, 0),
(40, 'Colombia', 'Colombia', 0, 0.000000000, 0.000000000, 0),
(41, 'Comoros', 'Comoros', 0, 0.000000000, 0.000000000, 0),
(42, 'Congo', 'Congo', 0, 0.000000000, 0.000000000, 0),
(43, 'Cook Islands', 'Cook Islands', 0, 0.000000000, 0.000000000, 0),
(44, 'Costa Rica', 'Costa Rica', 0, 0.000000000, 0.000000000, 0),
(45, 'Cote d\'Ivoire', 'Cote d\'Ivoire', 0, 0.000000000, 0.000000000, 0),
(46, 'Croatia', 'Croatia', 0, 0.000000000, 0.000000000, 0),
(47, 'Cuba', 'Cuba', 0, 0.000000000, 0.000000000, 0),
(48, 'Cyprus', 'Cyprus', 0, 0.000000000, 0.000000000, 0),
(49, 'Czech Republic', 'Czech Republic', 0, 0.000000000, 0.000000000, 0),
(50, 'Denmark', 'Denmark', 0, 0.000000000, 0.000000000, 0),
(51, 'Djibouti', 'Djibouti', 0, 0.000000000, 0.000000000, 0),
(52, 'Dominica', 'Dominica', 0, 0.000000000, 0.000000000, 0),
(53, 'Dominican Republic', 'Dominican Republic', 0, 0.000000000, 0.000000000, 0),
(54, 'DR Congo', 'DR Congo', 0, 0.000000000, 0.000000000, 0),
(55, 'Ecuador', 'Ecuador', 0, 0.000000000, 0.000000000, 0),
(56, 'Egypt', 'Egypt', 0, 0.000000000, 0.000000000, 0),
(57, 'El Salvador', 'El Salvador', 0, 0.000000000, 0.000000000, 0),
(58, 'Equatorial Guinea', 'Equatorial Guinea', 0, 0.000000000, 0.000000000, 0),
(59, 'Eritrea', 'Eritrea', 0, 0.000000000, 0.000000000, 0),
(60, 'Estonia', 'Estonia', 0, 0.000000000, 0.000000000, 0),
(61, 'Ethiopia', 'Ethiopia', 0, 0.000000000, 0.000000000, 0),
(62, 'Fiji', 'Fiji', 0, 0.000000000, 0.000000000, 0),
(63, 'Finland', 'Finland', 0, 0.000000000, 0.000000000, 0),
(64, 'France', 'France', 0, 0.000000000, 0.000000000, 0),
(65, 'French Guiana', 'French Guiana', 0, 0.000000000, 0.000000000, 0),
(66, 'French Polynesia', 'French Polynesia', 0, 0.000000000, 0.000000000, 0),
(67, 'Gabon', 'Gabon', 0, 0.000000000, 0.000000000, 0),
(68, 'Gambia', 'Gambia', 0, 0.000000000, 0.000000000, 0),
(69, 'Georgia', 'Georgia', 0, 0.000000000, 0.000000000, 0),
(70, 'Germany', 'Germany', 0, 0.000000000, 0.000000000, 0),
(71, 'Ghana', 'Ghana', 0, 0.000000000, 0.000000000, 0),
(72, 'Greece', 'Greece', 0, 0.000000000, 0.000000000, 0),
(73, 'Grenada', 'Grenada', 0, 0.000000000, 0.000000000, 0),
(74, 'Guatemala', 'Guatemala', 0, 0.000000000, 0.000000000, 0),
(75, 'Guernsey', 'Guernsey', 0, 0.000000000, 0.000000000, 0),
(76, 'Guinea', 'Guinea', 0, 0.000000000, 0.000000000, 0),
(77, 'Guyana', 'Guyana', 0, 0.000000000, 0.000000000, 0),
(78, 'Haiti', 'Haiti', 0, 0.000000000, 0.000000000, 0),
(79, 'Honduras', 'Honduras', 0, 0.000000000, 0.000000000, 0),
(80, 'Hungary', 'Hungary', 0, 0.000000000, 0.000000000, 0),
(81, 'Iceland', 'Iceland', 0, 0.000000000, 0.000000000, 0),
(82, 'India', 'India', 0, 0.000000000, 0.000000000, -9000),
(83, 'Indonesia', 'Indonesia', 0, 0.000000000, 0.000000000, -3600),
(84, 'Iran', 'Iran', 0, 0.000000000, 0.000000000, -16200),
(85, 'Iraq', 'Iraq', 0, 0.000000000, 0.000000000, 0),
(86, 'Ireland', 'Ireland', 0, 0.000000000, 0.000000000, 0),
(87, 'Isle of Man', 'Isle of Man', 0, 0.000000000, 0.000000000, 0),
(88, 'Israel', 'Israel', 0, 0.000000000, 0.000000000, 0),
(89, 'Italy', 'Italy', 0, 0.000000000, 0.000000000, 0),
(90, 'Jamaica', 'Jamaica', 0, 0.000000000, 0.000000000, 0),
(91, 'Japan', 'Japan', 0, 0.000000000, 0.000000000, 3600),
(92, 'Jordan', 'Jordan', 0, 0.000000000, 0.000000000, 0),
(93, 'Kazakhstan', 'Kazakhstan', 0, 0.000000000, 0.000000000, 0),
(94, 'Kenya', 'Kenya', 0, 0.000000000, 0.000000000, 0),
(95, 'Kiribati', 'Kiribati', 0, 0.000000000, 0.000000000, 0),
(96, 'Korea', 'Korea', 0, 0.000000000, 0.000000000, 3600),
(97, 'Kosovo', 'Kosovo', 0, 0.000000000, 0.000000000, 0),
(98, 'Kuwait', 'Kuwait', 0, 0.000000000, 0.000000000, 0),
(99, 'Laos', 'Laos', 0, 0.000000000, 0.000000000, 0),
(100, 'Latvia', 'Latvia', 0, 0.000000000, 0.000000000, 0),
(101, 'Lebanon', 'Lebanon', 0, 0.000000000, 0.000000000, 0),
(102, 'Lesotho', 'Lesotho', 0, 0.000000000, 0.000000000, 0),
(103, 'Liberia', 'Liberia', 0, 0.000000000, 0.000000000, 0),
(104, 'Libya', 'Libya', 0, 0.000000000, 0.000000000, 0),
(105, 'Lithuania', 'Lithuania', 0, 0.000000000, 0.000000000, 0),
(106, 'Luxembourg', 'Luxembourg', 0, 0.000000000, 0.000000000, 0),
(107, 'Macedonia', 'Macedonia', 0, 0.000000000, 0.000000000, 0),
(108, 'Madagascar', 'Madagascar', 0, 0.000000000, 0.000000000, 0),
(109, 'Malawi', 'Malawi', 0, 0.000000000, 0.000000000, 0),
(110, 'Malaysia', 'Malaysia', 0, 0.000000000, 0.000000000, 0),
(111, 'Mali', 'Mali', 0, 0.000000000, 0.000000000, 0),
(112, 'Malta', 'Malta', 0, 0.000000000, 0.000000000, 0),
(113, 'Marshall Islands', 'Marshall Islands', 0, 0.000000000, 0.000000000, 0),
(114, 'Mauritania', 'Mauritania', 0, 0.000000000, 0.000000000, 0),
(115, 'Mauritius', 'Mauritius', 0, 0.000000000, 0.000000000, 0),
(116, 'Mayotte', 'Mayotte', 0, 0.000000000, 0.000000000, 0),
(117, 'Mexico', 'Mexico', 0, 0.000000000, 0.000000000, 0),
(118, 'Moldova', 'Moldova', 0, 0.000000000, 0.000000000, 0),
(119, 'Mongolia', 'Mongolia', 0, 0.000000000, 0.000000000, 0),
(120, 'Montenegro', 'Montenegro', 0, 0.000000000, 0.000000000, 0),
(121, 'Montserrat', 'Montserrat', 0, 0.000000000, 0.000000000, 0),
(122, 'Morocco', 'Morocco', 0, 0.000000000, 0.000000000, 0),
(123, 'Mozambique', 'Mozambique', 0, 0.000000000, 0.000000000, 0),
(124, 'Myanmar', 'Myanmar', 0, 0.000000000, 0.000000000, 0),
(125, 'Namibia', 'Namibia', 0, 0.000000000, 0.000000000, 0),
(126, 'Nauru', 'Nauru', 0, 0.000000000, 0.000000000, 0),
(127, 'Nepal', 'Nepal', 0, 0.000000000, 0.000000000, 0),
(128, 'Netherlands', 'Netherlands', 0, 0.000000000, 0.000000000, 0),
(129, 'New Caledonia', 'New Caledonia', 0, 0.000000000, 0.000000000, 0),
(130, 'New Zealand', 'New Zealand', 0, 0.000000000, 0.000000000, 0),
(131, 'Nicaragua', 'Nicaragua', 0, 0.000000000, 0.000000000, 0),
(132, 'Niger', 'Niger', 0, 0.000000000, 0.000000000, 0),
(133, 'Nigeria', 'Nigeria', 0, 0.000000000, 0.000000000, 0),
(134, 'Niue', 'Niue', 0, 0.000000000, 0.000000000, 0),
(135, 'North Korea', 'North Korea', 0, 0.000000000, 0.000000000, 0),
(136, 'Norway', 'Norway', 0, 0.000000000, 0.000000000, 0),
(137, 'Oman', 'Oman', 0, 0.000000000, 0.000000000, 0),
(138, 'Pakistan', 'Pakistan', 0, 0.000000000, 0.000000000, 0),
(139, 'Palestine', 'Palestine', 0, 0.000000000, 0.000000000, 0),
(140, 'Panama', 'Panama', 0, 0.000000000, 0.000000000, 0),
(141, 'Papua New Guinea', 'Papua New Guinea', 0, 0.000000000, 0.000000000, 0),
(142, 'Paraguay', 'Paraguay', 0, 0.000000000, 0.000000000, 0),
(143, 'Peru', 'Peru', 0, 0.000000000, 0.000000000, 0),
(144, 'Philippines', 'Philippines', 0, 0.000000000, 0.000000000, 0),
(145, 'Pitcairn Islands', 'Pitcairn Islands', 0, 0.000000000, 0.000000000, 0),
(146, 'Poland', 'Poland', 0, 0.000000000, 0.000000000, 0),
(147, 'Portugal', 'Portugal', 0, 0.000000000, 0.000000000, 0),
(148, 'Puerto Rico', 'Puerto Rico', 0, 0.000000000, 0.000000000, 0),
(149, 'Qatar', 'Qatar', 0, 0.000000000, 0.000000000, 0),
(150, 'Romania', 'Romania', 0, 0.000000000, 0.000000000, 0),
(151, 'Russia', 'Russia', 0, 0.000000000, 0.000000000, 0),
(152, 'Saint Kitts and Nevis', 'Saint Kitts and Nevis', 0, 0.000000000, 0.000000000, 0),
(153, 'Saint Lucia', 'Saint Lucia', 0, 0.000000000, 0.000000000, 0),
(154, 'Saint Vincent and the Grenadines', 'Saint Vincent and the Grenadines', 0, 0.000000000, 0.000000000, 0),
(155, 'Samoa', 'Samoa', 0, 0.000000000, 0.000000000, 0),
(156, 'San Marino', 'San Marino', 0, 0.000000000, 0.000000000, 0),
(157, 'Sao Tome and Principe', 'Sao Tome and Principe', 0, 0.000000000, 0.000000000, 0),
(158, 'Saudi Arabia', 'Saudi Arabia', 0, 0.000000000, 0.000000000, 0),
(159, 'Senegal', 'Senegal', 0, 0.000000000, 0.000000000, 0),
(160, 'Serbia', 'Serbia', 0, 0.000000000, 0.000000000, 0),
(161, 'Sierra Leone', 'Sierra Leone', 0, 0.000000000, 0.000000000, 0),
(162, 'Singapore', 'Singapore', 0, 0.000000000, 0.000000000, 0),
(163, 'Slovakia', 'Slovakia', 0, 0.000000000, 0.000000000, 0),
(164, 'Slovenia', 'Slovenia', 0, 0.000000000, 0.000000000, 0),
(165, 'Solomon Islands', 'Solomon Islands', 0, 0.000000000, 0.000000000, 0),
(166, 'Somalia', 'Somalia', 0, 0.000000000, 0.000000000, 0),
(167, 'South Africa', 'South Africa', 0, 0.000000000, 0.000000000, 0),
(168, 'South Sudan', 'South Sudan', 0, 0.000000000, 0.000000000, 0),
(169, 'Spain', 'Spain', 0, 0.000000000, 0.000000000, 0),
(170, 'Sri Lanka', 'Sri Lanka', 0, 0.000000000, 0.000000000, 0),
(171, 'Sudan', 'Sudan', 0, 0.000000000, 0.000000000, 0),
(172, 'Suriname', 'Suriname', 0, 0.000000000, 0.000000000, 0),
(173, 'Swaziland', 'Swaziland', 0, 0.000000000, 0.000000000, 0),
(174, 'Sweden', 'Sweden', 0, 0.000000000, 0.000000000, 0),
(175, 'Switzerland', 'Switzerland', 0, 0.000000000, 0.000000000, 0),
(176, 'Syria', 'Syria', 0, 0.000000000, 0.000000000, 0),
(177, 'Tanzania', 'Tanzania', 0, 0.000000000, 0.000000000, 0),
(178, 'Thailand', 'Thailand', 0, 0.000000000, 0.000000000, 0),
(179, 'Togo', 'Togo', 0, 0.000000000, 0.000000000, 0),
(180, 'Tonga', 'Tonga', 0, 0.000000000, 0.000000000, 0),
(181, 'Trinidad and Tobago', 'Trinidad and Tobago', 0, 0.000000000, 0.000000000, 0),
(182, 'Tunisia', 'Tunisia', 0, 0.000000000, 0.000000000, 0),
(183, 'Turkey', 'Turkey', 0, 0.000000000, 0.000000000, 0),
(184, 'Turks and Caicos Islands', 'Turks and Caicos Islands', 0, 0.000000000, 0.000000000, 0),
(185, 'Tuvalu', 'Tuvalu', 0, 0.000000000, 0.000000000, 0),
(186, 'Uganda', 'Uganda', 0, 0.000000000, 0.000000000, 0),
(187, 'Ukraine', 'Ukraine', 0, 0.000000000, 0.000000000, 0),
(188, 'United Arab Emirates', 'United Arab Emirates', 0, 0.000000000, 0.000000000, 0),
(189, 'United Kingdom', 'United Kingdom', 0, 0.000000000, 0.000000000, 0),
(190, 'Uruguay', 'Uruguay', 0, 0.000000000, 0.000000000, 0),
(191, 'USA', 'USA', 0, 0.000000000, 0.000000000, 0),
(192, 'Vanuatu', 'Vanuatu', 0, 0.000000000, 0.000000000, 0),
(193, 'Venezuela', 'Venezuela', 0, 0.000000000, 0.000000000, 0),
(194, 'Vietnam', 'Vietnam', 0, 0.000000000, 0.000000000, 0),
(195, 'Yemen', 'Yemen', 0, 0.000000000, 0.000000000, 0),
(196, 'Zambia', 'Zambia', 0, 0.000000000, 0.000000000, 0),
(197, 'Zimbabwe', 'Zimbabwe', 0, 0.000000000, 0.000000000, 0),
(198, 'Anhui', '安徽', 1, 0.000000000, 0.000000000, 0),
(199, 'Anqing', '安庆', 198, 117.050000000, 30.530000000, 0),
(200, 'Bengbu', '蚌埠', 198, 117.380000000, 32.920000000, 0),
(201, 'Chizhou', '池州', 198, 117.480000000, 30.670000000, 0),
(202, 'Chuzhou', '滁州', 198, 118.320000000, 32.300000000, 0),
(203, 'Fuyang', '阜阳', 198, 115.820000000, 32.900000000, 0),
(204, 'Hefei', '合肥', 198, 117.250000000, 31.830000000, 0),
(205, 'Huaibei', '淮北', 198, 116.800000000, 33.950000000, 0),
(206, 'Huainan', '淮南', 198, 117.000000000, 32.630000000, 0),
(207, 'Huangshan', '黄山', 198, 118.330000000, 29.720000000, 0),
(208, 'Liuan', '六安', 198, 116.500000000, 31.770000000, 0),
(209, 'Maanshan', '马鞍山', 198, 118.500000000, 31.700000000, 0),
(210, 'Suzhou', '宿州', 198, 116.980000000, 33.630000000, 0),
(211, 'Tongling', '铜陵', 198, 117.820000000, 30.930000000, 0),
(212, 'Wuhu', '芜湖', 198, 118.380000000, 31.330000000, 0),
(213, 'Xuancheng', '宣城', 198, 118.750000000, 30.950000000, 0),
(214, 'Haozhou', '亳州', 198, 115.780000000, 33.850000000, 0),
(215, 'Beijing', '北京', 1, 0.000000000, 0.000000000, 0),
(216, 'Changping', '昌平', 215, 116.230000000, 40.220000000, 0),
(217, 'Chaoyang', '朝阳', 215, 116.430000000, 39.920000000, 0),
(218, 'Chongwen', '崇文', 215, 116.430000000, 39.880000000, 0),
(219, 'Daxing', '大兴', 215, 116.330000000, 39.730000000, 0),
(220, 'Dongcheng', '东城', 215, 116.420000000, 39.930000000, 0),
(221, 'Fangshan', '房山', 215, 116.130000000, 39.750000000, 0),
(222, 'Fengtai', '丰台', 215, 116.280000000, 39.850000000, 0),
(223, 'Haidian', '海淀', 215, 116.300000000, 39.950000000, 0),
(224, 'Huairou', '怀柔', 215, 116.630000000, 40.320000000, 0),
(225, 'Mentougou', '门头', 215, 86.030000000, 44.300000000, 0),
(226, 'Miyun', '密云', 215, 116.830000000, 40.370000000, 0),
(227, 'Pinggu', '平谷', 215, 117.120000000, 40.130000000, 0),
(228, 'Shijingshan', '石景山', 215, 116.220000000, 39.900000000, 0),
(229, 'Shunyi', '顺义', 215, 116.650000000, 40.130000000, 0),
(230, 'Tongzhou', '通州', 215, 116.650000000, 39.920000000, 0),
(231, 'Xicheng', '西城', 215, 116.370000000, 39.920000000, 0),
(232, 'Xuanwu', '宣武', 215, 116.350000000, 39.870000000, 0),
(233, 'Yanqing', '延庆', 215, 115.970000000, 40.450000000, 0),
(234, 'Fujian', '福建', 1, 0.000000000, 0.000000000, 0),
(235, 'Fuzhou', '福州', 234, 119.300000000, 26.080000000, 0),
(236, 'Longyan', '龙岩', 234, 117.030000000, 25.100000000, 0),
(237, 'Nanping', '南平', 234, 118.170000000, 26.650000000, 0),
(238, 'Ningde', '宁德', 234, 119.520000000, 26.670000000, 0),
(239, 'Putian', '莆田', 234, 119.000000000, 25.430000000, 0),
(240, 'Quanzhou', '泉州', 234, 118.670000000, 24.880000000, 0),
(241, 'Sanming', '三明', 234, 117.620000000, 26.270000000, 0),
(242, 'Xiamen', '厦门', 234, 118.080000000, 24.480000000, 0),
(243, 'Zhangzhou', '漳州', 234, 117.650000000, 24.520000000, 0),
(244, 'Gansu', '甘肃', 1, 0.000000000, 0.000000000, 0),
(245, 'Baiyin', '白银', 244, 104.180000000, 36.550000000, 0),
(246, 'Dingxi', '定西', 244, 104.620000000, 35.580000000, 0),
(247, 'Gannan', '甘南', 244, 86.030000000, 44.300000000, 0),
(248, 'Jiayuguan', '嘉峪关', 244, 98.270000000, 39.800000000, 0),
(249, 'Jinchang', '金昌', 244, 102.180000000, 38.500000000, 0),
(250, 'Jiuquan', '酒泉', 244, 98.520000000, 39.750000000, 0),
(251, 'Lanzhou', '兰州', 244, 103.820000000, 36.070000000, 0),
(252, 'Linxia', '临夏', 244, 86.030000000, 44.300000000, 0),
(253, 'Longnan', '陇南', 244, 104.920000000, 33.400000000, 0),
(254, 'Pingliang', '平凉', 244, 106.670000000, 35.550000000, 0),
(255, 'Qingyang', '庆阳', 244, 107.630000000, 35.730000000, 0),
(256, 'Tianshui', '天水', 244, 105.720000000, 34.580000000, 0),
(257, 'Wuwei', '武威', 244, 102.630000000, 37.930000000, 0),
(258, 'Zhangye', '张掖', 244, 100.450000000, 38.930000000, 0),
(259, 'Guangdong', '广东', 1, 0.000000000, 0.000000000, 0),
(260, 'Chaozhou', '潮州', 259, 116.620000000, 23.670000000, 0),
(261, 'Dongguan', '东莞', 259, 113.750000000, 23.050000000, 0),
(262, 'Foshan', '佛山', 259, 113.120000000, 23.020000000, 0),
(263, 'Guangzhou', '广州', 259, 113.270000000, 23.130000000, 0),
(264, 'Heyuan', '河源', 259, 114.700000000, 23.730000000, 0),
(265, 'Huizhou', '惠州', 259, 114.420000000, 23.120000000, 0),
(266, 'Jiangmen', '江门', 259, 113.080000000, 22.580000000, 0),
(267, 'Jieyang', '揭阳', 259, 116.370000000, 23.550000000, 0),
(268, 'Maoming', '茂名', 259, 110.920000000, 21.670000000, 0),
(269, 'Meizhou', '梅州', 259, 116.120000000, 24.280000000, 0),
(270, 'Qingyuan', '清远', 259, 113.030000000, 23.700000000, 0),
(271, 'Shantou', '汕头', 259, 116.680000000, 23.350000000, 0),
(272, 'Shanwei', '汕尾', 259, 115.370000000, 22.780000000, 0),
(273, 'Shaoguan', '韶关', 259, 113.600000000, 24.820000000, 0),
(274, 'Shenzhen', '深圳', 259, 114.050000000, 22.550000000, 0),
(275, 'Yangjiang', '阳江', 259, 111.980000000, 21.870000000, 0),
(276, 'Yunfu', '云浮', 259, 112.030000000, 22.920000000, 0),
(277, 'Zhanjiang', '湛江', 259, 110.350000000, 21.270000000, 0),
(278, 'Zhaoqing', '肇庆', 259, 112.470000000, 23.050000000, 0),
(279, 'Zhongshan', '中山', 259, 113.380000000, 22.520000000, 0),
(280, 'Zhuhai', '珠海', 259, 113.570000000, 22.270000000, 0),
(281, 'Guangxi', '广西', 1, 0.000000000, 0.000000000, 0),
(282, 'Baise', '百色', 281, 106.620000000, 23.900000000, 0),
(283, 'North Sea', '北海', 281, 109.120000000, 21.480000000, 0),
(284, 'Chongzuo', '崇左', 281, 107.370000000, 22.400000000, 0),
(285, 'Fangchenggang', '防城港', 281, 108.350000000, 21.700000000, 0),
(286, 'Guilin', '桂林', 281, 110.280000000, 25.280000000, 0),
(287, 'Guigang', '贵港', 281, 109.600000000, 23.100000000, 0),
(288, 'Hechi', '河池', 281, 108.070000000, 24.700000000, 0),
(289, 'Hezhou', '贺州', 281, 111.550000000, 24.420000000, 0),
(290, 'Laibin', '来宾', 281, 109.230000000, 23.730000000, 0),
(291, 'Liuzhou', '柳州', 281, 109.420000000, 24.330000000, 0),
(292, 'Nanning', '南宁', 281, 108.370000000, 22.820000000, 0),
(293, 'Qinzhou', '钦州', 281, 108.620000000, 21.950000000, 0),
(294, 'Wuzhou', '梧州', 281, 111.270000000, 23.480000000, 0),
(295, 'Yulin', '玉林', 281, 110.170000000, 22.630000000, 0),
(296, 'Guizhou', '贵州', 1, 0.000000000, 0.000000000, 0),
(297, 'Anshun', '安顺', 296, 105.950000000, 26.250000000, 0),
(298, 'Bijie', '毕节', 296, 105.280000000, 27.300000000, 0),
(299, 'Guiyang', '贵阳', 296, 106.630000000, 26.650000000, 0),
(300, 'Liupanshui', '六盘水', 296, 104.830000000, 26.600000000, 0),
(301, 'Qiandongnan', '黔东南', 296, 86.030000000, 44.300000000, 0),
(302, 'Qiannan', '黔南', 296, 86.030000000, 44.300000000, 0),
(303, 'Qianxinan', '黔西南', 296, 0.000000000, 0.000000000, 0),
(304, 'Tongren', '铜仁', 296, 109.180000000, 27.720000000, 0),
(305, 'Zunyi', '遵义', 296, 106.920000000, 27.730000000, 0),
(306, 'Hainan', '海南', 1, 0.000000000, 0.000000000, 0),
(307, 'Baisha', '白沙', 306, 0.000000000, 0.000000000, 0),
(308, 'Baoting', '保亭', 306, 0.000000000, 0.000000000, 0),
(309, 'Changjiang', '昌江', 306, 0.000000000, 0.000000000, 0),
(310, 'Chengmai', '澄迈', 306, 0.000000000, 0.000000000, 0),
(311, 'Dingan', '定安', 306, 0.000000000, 0.000000000, 0),
(312, 'Dongfang', '东方', 306, 0.000000000, 0.000000000, 0),
(313, 'Haikou', '海口', 306, 110.320000000, 20.030000000, 0),
(314, 'Ledong', '乐东', 306, 0.000000000, 0.000000000, 0),
(315, 'Lingao', '临高', 306, 0.000000000, 0.000000000, 0),
(316, 'Lingshui', '陵水', 306, 0.000000000, 0.000000000, 0),
(317, 'Qionghai', '琼海', 306, 0.000000000, 0.000000000, 0),
(318, 'Qiongzhong', '琼中', 306, 0.000000000, 0.000000000, 0),
(319, 'Sansha', '三沙', 306, 0.000000000, 0.000000000, 0),
(320, 'Sanya', '三亚', 306, 109.500000000, 18.250000000, 0),
(321, 'Tunchang', '屯昌', 306, 0.000000000, 0.000000000, 0),
(322, 'Wanning', '万宁', 306, 0.000000000, 0.000000000, 0),
(323, 'Wenchang', '文昌', 306, 0.000000000, 0.000000000, 0),
(324, 'Wuzhishan', '五指山', 306, 109.520000000, 18.780000000, 0),
(325, 'Danzhou', '儋州', 306, 0.000000000, 0.000000000, 0),
(326, 'Hebei', '河北', 1, 0.000000000, 0.000000000, 0),
(327, 'Baoding', '保定', 326, 115.470000000, 38.870000000, 0),
(328, 'Cangzhou', '沧州', 326, 116.830000000, 38.300000000, 0),
(329, 'Chengde', '承德', 326, 117.930000000, 40.970000000, 0),
(330, 'Handan', '邯郸', 326, 114.480000000, 36.620000000, 0),
(331, 'Hengshui', '衡水', 326, 115.680000000, 37.730000000, 0),
(332, 'Langfang', '廊坊', 326, 116.700000000, 39.520000000, 0),
(333, 'Qinhuangdao', '秦皇岛', 326, 119.600000000, 39.930000000, 0),
(334, 'Shijiazhuang', '石家庄', 326, 114.520000000, 38.050000000, 0),
(335, 'Tangshan', '唐山', 326, 118.200000000, 39.630000000, 0),
(336, 'Xingtai', '邢台', 326, 114.480000000, 37.070000000, 0),
(337, 'Zhangjiakou', '张家口', 326, 114.880000000, 40.820000000, 0),
(338, 'Henan', '河南', 1, 0.000000000, 0.000000000, 0),
(339, 'Anyang', '安阳', 338, 114.380000000, 36.100000000, 0),
(340, 'Hebi', '鹤壁', 338, 114.280000000, 35.750000000, 0),
(341, 'Jiyuan', '济源', 338, 0.000000000, 0.000000000, 0),
(342, 'Jiaozuo', '焦作', 338, 113.250000000, 35.220000000, 0),
(343, 'Kaifeng', '开封', 338, 114.300000000, 34.800000000, 0),
(344, 'Luoyang', '洛阳', 338, 112.450000000, 34.620000000, 0),
(345, 'Nanyang', '南阳', 338, 112.520000000, 33.000000000, 0),
(346, 'Pingdingshan', '平顶山', 338, 113.180000000, 33.770000000, 0),
(347, 'Sanmenxia', '三门峡', 338, 111.200000000, 34.780000000, 0),
(348, 'Shangqiu', '商丘', 338, 115.650000000, 34.450000000, 0),
(349, 'Xinxiang', '新乡', 338, 113.900000000, 35.300000000, 0),
(350, 'Xinyang', '信阳', 338, 114.070000000, 32.130000000, 0),
(351, 'Xuchang', '许昌', 338, 113.850000000, 34.030000000, 0),
(352, 'Zhengzhou', '郑州', 338, 113.620000000, 34.750000000, 0),
(353, 'Zhoukou', '周口', 338, 114.650000000, 33.620000000, 0),
(354, 'Zhumadian', '驻马店', 338, 114.020000000, 32.980000000, 0),
(355, 'Luohe', '漯河', 338, 114.020000000, 33.580000000, 0),
(356, 'Puyang', '濮阳', 338, 115.030000000, 35.770000000, 0),
(357, 'Heilongjiang', '黑龙江', 1, 0.000000000, 0.000000000, 0),
(358, 'Daqing', '大庆', 357, 125.030000000, 46.580000000, 0),
(359, 'Daxinganling', '大兴安岭', 357, 124.120000000, 50.420000000, 0),
(360, 'Harbin', '哈尔滨', 357, 126.530000000, 45.800000000, 0),
(361, 'Hegang', '鹤岗', 357, 130.270000000, 47.330000000, 0),
(362, 'Heihe', '黑河', 357, 127.480000000, 50.250000000, 0),
(363, 'Jixi', '鸡西', 357, 130.970000000, 45.300000000, 0),
(364, 'Jiamusi', '佳木斯', 357, 130.370000000, 46.820000000, 0),
(365, 'Mudanjiang', '牡丹江', 357, 129.600000000, 44.580000000, 0),
(366, 'Qitaihe', '七台河', 357, 130.950000000, 45.780000000, 0),
(367, 'Qiqihar', '齐齐哈尔', 357, 123.950000000, 47.330000000, 0),
(368, 'Shuangyashan', '双鸭山', 357, 131.150000000, 46.630000000, 0),
(369, 'Suihua', '绥化', 357, 126.980000000, 46.630000000, 0),
(370, 'Yichun', '伊春', 357, 128.900000000, 47.730000000, 0),
(371, 'Hubei', '湖北', 1, 0.000000000, 0.000000000, 0),
(372, 'Ezhou', '鄂州', 371, 114.880000000, 30.400000000, 0),
(373, 'Enshi', '恩施', 371, 86.030000000, 44.300000000, 0),
(374, 'Huanggang', '黄冈', 371, 114.870000000, 30.450000000, 0),
(375, 'Huangshi', '黄石', 371, 115.030000000, 30.200000000, 0),
(376, 'Jingmen', '荆门', 371, 112.200000000, 31.030000000, 0),
(377, 'Jingzhou', '荆州', 371, 112.230000000, 30.330000000, 0),
(378, 'Qianjiang', '潜江', 371, 0.000000000, 0.000000000, 0),
(379, 'Shennongjia', '神农架', 371, 0.000000000, 0.000000000, 0),
(380, 'Shiyan', '十堰', 371, 110.780000000, 32.650000000, 0),
(381, 'Suizhou', '随州', 371, 113.370000000, 31.720000000, 0),
(382, 'Tianmen', '天门', 371, 0.000000000, 0.000000000, 0),
(383, 'Wuhan', '武汉', 371, 114.300000000, 30.600000000, 0),
(384, 'Xiantao', '仙桃', 371, 113.450000000, 30.370000000, 0),
(385, 'Xianning', '咸宁', 371, 114.320000000, 29.850000000, 0),
(386, 'Xiangyang', '襄阳', 371, 0.000000000, 0.000000000, 0),
(387, 'Xiaogan', '孝感', 371, 113.920000000, 30.930000000, 0),
(388, 'Yichang', '宜昌', 371, 111.280000000, 30.700000000, 0),
(389, 'Hunan', '湖南', 1, 0.000000000, 0.000000000, 0),
(390, 'Changde', '常德', 389, 111.680000000, 29.050000000, 0),
(391, 'Changsha', '长沙', 389, 112.930000000, 28.230000000, 0),
(392, 'Chenzhou', '郴州', 389, 113.020000000, 25.780000000, 0),
(393, 'Hengyang', '衡阳', 389, 112.570000000, 26.900000000, 0),
(394, 'Huaihua', '怀化', 389, 110.000000000, 27.570000000, 0),
(395, 'Loudi', '娄底', 389, 112.000000000, 27.730000000, 0),
(396, 'Shaoshan', '韶山', 389, 0.000000000, 0.000000000, 0),
(397, 'Shaoyang', '邵阳', 389, 111.470000000, 27.250000000, 0),
(398, 'Xiangtan', '湘潭', 389, 112.930000000, 27.830000000, 0),
(399, 'Xiangxi', '湘西', 389, 86.030000000, 44.300000000, 0),
(400, 'Yiyang', '益阳', 389, 112.320000000, 28.600000000, 0),
(401, 'Yongzhou', '永州', 389, 111.620000000, 26.430000000, 0),
(402, 'Yueyang', '岳阳', 389, 113.120000000, 29.370000000, 0),
(403, 'Zhangjiajie', '张家界', 389, 110.470000000, 29.130000000, 0),
(404, 'Zhuzhou', '株洲', 389, 113.130000000, 27.830000000, 0),
(405, 'Jilin', '吉林', 1, 0.000000000, 0.000000000, 0),
(406, 'Baicheng', '白城', 405, 122.830000000, 45.620000000, 0),
(407, 'Baishan', '白山', 405, 126.420000000, 41.930000000, 0),
(408, 'Changchun', '长春', 405, 125.320000000, 43.900000000, 0),
(409, 'Jilin', '吉林', 405, 126.550000000, 43.830000000, 0),
(410, 'Liaoyuan', '辽源', 405, 125.130000000, 42.880000000, 0),
(411, 'Siping', '四平', 405, 124.350000000, 43.170000000, 0),
(412, 'Songyuan', '松原', 405, 124.820000000, 45.130000000, 0),
(413, 'Tonghua', '通化', 405, 125.930000000, 41.730000000, 0),
(414, 'Yanbian', '延边', 405, 86.030000000, 44.300000000, 0),
(415, 'Jiangsu', '江苏', 1, 0.000000000, 0.000000000, 0),
(416, 'Changzhou', '常州', 415, 119.950000000, 31.780000000, 0),
(417, 'Huaian', '淮安', 415, 119.020000000, 33.620000000, 0),
(418, 'Lianyungang', '连云港', 415, 119.220000000, 34.600000000, 0),
(419, 'Nanjing', '南京', 415, 118.780000000, 32.070000000, 0),
(420, 'Nantong', '南通', 415, 120.880000000, 31.980000000, 0),
(421, 'Suzhou', '苏州', 415, 120.580000000, 31.300000000, 0),
(422, 'Suqian', '宿迁', 415, 118.280000000, 33.970000000, 0),
(423, 'Taizhou', '泰州', 415, 119.920000000, 32.450000000, 0),
(424, 'Wuxi', '无锡', 415, 120.300000000, 31.570000000, 0),
(425, 'Xuzhou', '徐州', 415, 117.180000000, 34.270000000, 0),
(426, 'Yancheng', '盐城', 415, 120.150000000, 33.350000000, 0),
(427, 'Yangzhou', '扬州', 415, 119.400000000, 32.400000000, 0),
(428, 'Zhenjiang', '镇江', 415, 119.450000000, 32.200000000, 0),
(429, 'Jiangxi', '江西', 1, 0.000000000, 0.000000000, 0),
(430, 'Fuzhou', '抚州', 429, 116.350000000, 28.000000000, 0),
(431, 'Ganzhou', '赣州', 429, 114.930000000, 25.830000000, 0),
(432, 'Ji\'an', '吉安', 429, 114.980000000, 27.120000000, 0),
(433, 'Jingdezhen', '景德镇', 429, 117.170000000, 29.270000000, 0),
(434, 'Jiujiang', '九江', 429, 116.000000000, 29.700000000, 0),
(435, 'Nanchang', '南昌', 429, 115.850000000, 28.680000000, 0),
(436, 'Pingxiang', '萍乡', 429, 113.850000000, 27.630000000, 0),
(437, 'Shangrao', '上饶', 429, 117.970000000, 28.450000000, 0),
(438, 'Xinyu', '新余', 429, 114.920000000, 27.820000000, 0),
(439, 'Yichun', '宜春', 429, 114.380000000, 27.800000000, 0),
(440, 'Yingtan', '鹰潭', 429, 117.070000000, 28.270000000, 0),
(441, 'Liaoning', '辽宁', 1, 0.000000000, 0.000000000, 0),
(442, 'Anshan', '鞍山', 441, 122.980000000, 41.100000000, 0),
(443, 'Benxi', '本溪', 441, 123.770000000, 41.300000000, 0),
(444, 'Chaoyang', '朝阳', 441, 120.450000000, 41.570000000, 0),
(445, 'Dalian', '大连', 441, 121.620000000, 38.920000000, 0),
(446, 'Dandong', '丹东', 441, 124.380000000, 40.130000000, 0),
(447, 'Fushun', '抚顺', 441, 123.980000000, 41.880000000, 0),
(448, 'Fuxin', '阜新', 441, 121.670000000, 42.020000000, 0),
(449, 'Huludao', '葫芦岛', 441, 120.830000000, 40.720000000, 0),
(450, 'Jinzhou', '锦州', 441, 121.130000000, 41.100000000, 0),
(451, 'Liaoyang', '辽阳', 441, 123.170000000, 41.270000000, 0),
(452, 'Panjin', '盘锦', 441, 122.070000000, 41.120000000, 0),
(453, 'Shenyang', '沈阳', 441, 123.430000000, 41.800000000, 0),
(454, 'Tieling', '铁岭', 441, 123.830000000, 42.280000000, 0),
(455, 'Yingkou', '营口', 441, 122.230000000, 40.670000000, 0),
(456, 'Inner Mongolia', '内蒙古', 1, 0.000000000, 0.000000000, 0),
(457, 'Alxa League', '阿拉善', 456, 105.670000000, 38.830000000, 0),
(458, 'Bayan Nur', '巴彦淖尔', 456, 107.420000000, 40.750000000, 0),
(459, 'Baotou', '包头', 456, 109.830000000, 40.650000000, 0),
(460, 'Chifeng', '赤峰', 456, 118.920000000, 42.270000000, 0),
(461, 'Ordos', '鄂尔多斯', 456, 109.800000000, 39.620000000, 0),
(462, 'Hohhot', '呼和浩特', 456, 111.730000000, 40.830000000, 0),
(463, 'Hulun Buir', '呼伦贝尔', 456, 119.770000000, 49.220000000, 0),
(464, 'Tongliao', '通辽', 456, 122.270000000, 43.620000000, 0),
(465, 'Wuhai', '乌海', 456, 106.820000000, 39.670000000, 0),
(466, 'Ulanqab', '乌兰察布', 456, 113.120000000, 40.980000000, 0),
(467, 'Xilingol League', '锡林郭', 456, 86.030000000, 44.300000000, 0),
(468, 'Hinggan League', '兴安', 456, 122.050000000, 46.080000000, 0),
(469, 'Ningxia', '宁夏', 1, 0.000000000, 0.000000000, 0),
(470, 'Guyuan', '固原', 469, 106.280000000, 36.000000000, 0),
(471, 'Shizuishan', '石嘴山', 469, 106.380000000, 39.020000000, 0),
(472, 'Wuzhong', '吴忠', 469, 106.200000000, 37.980000000, 0),
(473, 'Yinchuan', '银川', 469, 106.280000000, 38.470000000, 0),
(474, 'Zhongwei', '中卫', 469, 105.180000000, 37.520000000, 0),
(475, 'Qinghai', '青海', 1, 0.000000000, 0.000000000, 0),
(476, 'Guoluo', '果洛', 475, 86.030000000, 44.300000000, 0),
(477, 'Haibei', '海北', 475, 86.030000000, 44.300000000, 0),
(478, 'Haidong', '海东', 475, 102.120000000, 36.500000000, 0),
(479, 'Hainan', '海南', 475, 86.030000000, 44.300000000, 0),
(480, 'Haixi', '海西', 475, 86.030000000, 44.300000000, 0),
(481, 'Huangnan', '黄南', 475, 86.030000000, 44.300000000, 0),
(482, 'Xining', '西宁', 475, 101.780000000, 36.620000000, 0),
(483, 'Yushu', '玉树', 475, 86.030000000, 44.300000000, 0),
(484, 'Shandong', '山东', 1, 0.000000000, 0.000000000, 0),
(485, 'Binzhou', '滨州', 484, 117.970000000, 37.380000000, 0),
(486, 'Dezhou', '德州', 484, 116.300000000, 37.450000000, 0),
(487, 'Dongying', '东营', 484, 118.670000000, 37.430000000, 0),
(488, 'Heze', '菏泽', 484, 0.000000000, 0.000000000, 0),
(489, 'Jinan', '济南', 484, 116.980000000, 36.670000000, 0),
(490, 'Jining', '济宁', 484, 116.580000000, 35.420000000, 0),
(491, 'Laiwu', '莱芜', 484, 117.670000000, 36.220000000, 0),
(492, 'Liaocheng', '聊城', 484, 115.980000000, 36.450000000, 0),
(493, 'Linyi', '临沂', 484, 118.350000000, 35.050000000, 0),
(494, 'Qingdao', '青岛', 484, 120.380000000, 36.070000000, 0),
(495, 'Sunshine', '日照', 484, 119.520000000, 35.420000000, 0),
(496, 'Taian', '泰安', 484, 117.080000000, 36.200000000, 0),
(497, 'Weihai', '威海', 484, 122.120000000, 37.520000000, 0),
(498, 'Weifang', '潍坊', 484, 119.150000000, 36.700000000, 0),
(499, 'Yantai', '烟台', 484, 121.430000000, 37.450000000, 0),
(500, 'Zaozhuang', '枣庄', 484, 117.320000000, 34.820000000, 0),
(501, 'Zibo', '淄博', 484, 118.050000000, 36.820000000, 0),
(502, 'Shanxi', '山西', 1, 0.000000000, 0.000000000, 0),
(503, 'Changzhi', '长治', 502, 113.120000000, 36.200000000, 0),
(504, 'Datong', '大同', 502, 113.300000000, 40.080000000, 0),
(505, 'Jincheng', '晋城', 502, 112.830000000, 35.500000000, 0),
(506, 'Jinzhong', '晋中', 502, 112.750000000, 37.680000000, 0),
(507, 'Linfen', '临汾', 502, 111.520000000, 36.080000000, 0),
(508, 'Lüliang', '吕梁', 502, 111.130000000, 37.520000000, 0),
(509, 'Shuozhou', '朔州', 502, 112.430000000, 39.330000000, 0),
(510, 'Taiyuan', '太原', 502, 112.550000000, 37.870000000, 0),
(511, 'Xinzhou', '忻州', 502, 112.730000000, 38.420000000, 0),
(512, 'Yangquan', '阳泉', 502, 113.570000000, 37.850000000, 0),
(513, 'Yuncheng', '运城', 502, 110.980000000, 35.020000000, 0),
(514, 'Shaanxi', '陕西', 1, 0.000000000, 0.000000000, 0),
(515, 'Ankang', '安康', 514, 109.020000000, 32.680000000, 0),
(516, 'Baoji', '宝鸡', 514, 107.130000000, 34.370000000, 0),
(517, 'Hanzhong', '汉中', 514, 107.020000000, 33.070000000, 0),
(518, 'Shangluo', '商洛', 514, 109.930000000, 33.870000000, 0),
(519, 'Tongchuan', '铜川', 514, 108.930000000, 34.900000000, 0),
(520, 'Weinan', '渭南', 514, 109.500000000, 34.500000000, 0),
(521, 'Xi\'an', '西安', 514, 108.930000000, 34.270000000, 0),
(522, 'Xianyang', '咸阳', 514, 108.700000000, 34.330000000, 0),
(523, 'Yan\'an', '延安', 514, 109.480000000, 36.600000000, 0),
(524, 'Yulin', '榆林', 514, 109.730000000, 38.280000000, 0),
(525, 'Shanghai', '上海', 1, 0.000000000, 0.000000000, 0),
(526, 'Baoshan', '宝山', 525, 121.480000000, 31.400000000, 0),
(527, 'Changning', '长宁', 525, 121.420000000, 31.220000000, 0),
(528, 'Chongming', '崇明', 525, 121.400000000, 31.620000000, 0),
(529, 'Fengxian', '奉贤', 525, 121.470000000, 30.920000000, 0),
(530, 'Hongkou', '虹口', 525, 121.500000000, 31.270000000, 0),
(531, 'Huangpu', '黄浦', 525, 121.480000000, 31.230000000, 0),
(532, 'Jiading', '嘉定', 525, 121.270000000, 31.380000000, 0),
(533, 'Jinshan', '金山', 525, 121.330000000, 30.750000000, 0),
(534, 'Jing\'an', '静安', 525, 121.450000000, 31.230000000, 0),
(535, 'Luwan', '卢湾', 525, 121.470000000, 31.220000000, 0),
(536, 'Nanhui', '南汇', 525, 121.750000000, 31.050000000, 0),
(537, 'Putuo', '普陀', 525, 121.400000000, 31.250000000, 0),
(538, 'Pudong', '浦东', 525, 86.030000000, 44.300000000, 0),
(539, 'Qingpu', '青浦', 525, 121.120000000, 31.150000000, 0),
(540, 'Songjiang', '松江', 525, 121.220000000, 31.030000000, 0),
(541, 'Xuhui', '徐汇', 525, 121.430000000, 31.180000000, 0),
(542, 'Yangpu', '杨浦', 525, 121.520000000, 31.270000000, 0),
(543, 'Zhabei', '闸北', 525, 121.450000000, 31.250000000, 0),
(544, 'Minhang', '闵行', 525, 121.380000000, 31.120000000, 0),
(545, 'Sichuan', '四川', 1, 0.000000000, 0.000000000, 0),
(546, 'Aba', '阿坝', 545, 86.030000000, 44.300000000, 0),
(547, 'Bazhong', '巴中', 545, 106.770000000, 31.850000000, 0),
(548, 'Chengdu', '成都', 545, 104.070000000, 30.670000000, 0),
(549, 'Dazhou', '达州', 545, 107.500000000, 31.220000000, 0),
(550, 'Deyang', '德阳', 545, 104.380000000, 31.130000000, 0),
(551, 'Garzê', '甘孜', 545, 86.030000000, 44.300000000, 0),
(552, 'Guang\'an', '广安', 545, 106.630000000, 30.470000000, 0),
(553, 'Guangyuan', '广元', 545, 105.830000000, 32.430000000, 0),
(554, 'Leshan', '乐山', 545, 103.770000000, 29.570000000, 0),
(555, 'Liangshan', '凉山', 545, 86.030000000, 44.300000000, 0),
(556, 'Meishan', '眉山', 545, 103.830000000, 30.050000000, 0),
(557, 'Mianyang', '绵阳', 545, 104.730000000, 31.470000000, 0),
(558, 'Nanchong', '南充', 545, 106.080000000, 30.780000000, 0),
(559, 'Neijiang', '内江', 545, 105.050000000, 29.580000000, 0),
(560, 'Panzhihua', '攀枝花', 545, 101.720000000, 26.580000000, 0),
(561, 'Suining', '遂宁', 545, 105.570000000, 30.520000000, 0),
(562, 'Ya\'an', '雅安', 545, 103.000000000, 29.980000000, 0),
(563, 'Yibin', '宜宾', 545, 104.620000000, 28.770000000, 0),
(564, 'Ziyang', '资阳', 545, 104.650000000, 30.120000000, 0),
(565, 'Zigong', '自贡', 545, 104.780000000, 29.350000000, 0),
(566, 'Luzhou', '泸州', 545, 105.430000000, 28.870000000, 0),
(567, 'Tianjin', '天津', 1, 0.000000000, 0.000000000, 0),
(568, 'Baodi', '宝坻', 567, 117.300000000, 39.720000000, 0),
(569, 'Beichen', '北辰', 567, 117.130000000, 39.220000000, 0),
(570, 'Dagang', '大港', 567, 117.450000000, 38.830000000, 0),
(571, 'Dongli', '东丽', 567, 117.300000000, 39.080000000, 0),
(572, 'Hangu', '汉沽', 567, 117.800000000, 39.250000000, 0),
(573, 'Heping', '和平', 567, 117.200000000, 39.120000000, 0),
(574, 'Hebei', '河北', 567, 117.180000000, 39.150000000, 0),
(575, 'Hedong', '河东', 567, 117.220000000, 39.120000000, 0),
(576, 'Hexi', '河西', 567, 117.220000000, 39.120000000, 0),
(577, 'Hongqiao', '红桥', 567, 117.150000000, 39.170000000, 0),
(578, 'Jixian', '蓟县', 567, 117.400000000, 40.050000000, 0),
(579, 'Jinnan', '津南', 567, 117.380000000, 38.980000000, 0),
(580, 'Jinghai', '静海', 567, 116.920000000, 38.930000000, 0),
(581, 'Nankai', '南开', 567, 117.150000000, 39.130000000, 0),
(582, 'Ninghe', '宁河', 567, 117.820000000, 39.330000000, 0),
(583, 'Tanggu', '塘沽', 567, 117.650000000, 39.020000000, 0),
(584, 'Wuqing', '武清', 567, 117.030000000, 39.380000000, 0),
(585, 'Xiqing', '西青', 567, 117.000000000, 39.130000000, 0),
(586, 'Tibet', '西藏', 1, 0.000000000, 0.000000000, 0),
(587, 'Ngari', '阿里', 586, 80.100000000, 32.500000000, 0),
(588, 'Chamdo', '昌都', 586, 97.180000000, 31.130000000, 0),
(589, 'Lhasa', '拉萨', 586, 91.130000000, 29.650000000, 0),
(590, 'Nyingchi', '林芝', 586, 94.370000000, 29.680000000, 0),
(591, 'Nagqu', '那曲', 586, 92.070000000, 31.480000000, 0),
(592, 'Shigatse', '日喀则', 586, 88.880000000, 29.270000000, 0),
(593, 'Shannan', '山南', 586, 91.770000000, 29.230000000, 0),
(594, 'Xinjiang', '新疆', 1, 0.000000000, 0.000000000, 0),
(595, 'Aksu', '阿克苏', 594, 80.270000000, 41.170000000, 0),
(596, 'Alaer', '阿拉尔', 594, 0.000000000, 0.000000000, 0),
(597, 'Aletai', '阿勒泰', 594, 88.130000000, 47.850000000, 0),
(598, 'Bayingolin', '巴音郭楞', 594, 86.030000000, 44.300000000, 0),
(599, 'Bortala', '博尔塔拉', 594, 86.030000000, 44.300000000, 0),
(600, 'Changji', '昌吉', 594, 86.030000000, 44.300000000, 0),
(601, 'Hami', '哈密', 594, 93.520000000, 42.830000000, 0),
(602, 'Wada', '和田', 594, 79.920000000, 37.120000000, 0),
(603, 'Kashi', '喀什', 594, 75.980000000, 39.470000000, 0),
(604, 'Karamay', '克拉玛依', 594, 84.870000000, 45.600000000, 0),
(605, 'Kizilsu', '克孜勒苏', 594, 0.000000000, 0.000000000, 0),
(606, 'Shihezi', '石河子', 594, 86.030000000, 44.300000000, 0),
(607, 'Tacheng', '塔城', 594, 82.980000000, 46.750000000, 0),
(608, 'Tumushuke', '图木舒克', 594, 0.000000000, 0.000000000, 0),
(609, 'Turpan', '吐鲁番', 594, 89.170000000, 42.950000000, 0),
(610, 'Urumqi', '乌鲁木齐', 594, 87.620000000, 43.820000000, 0),
(611, 'Wujiaqu', '五家渠', 594, 0.000000000, 0.000000000, 0),
(612, 'Yili', '伊犁', 594, 86.030000000, 44.300000000, 0),
(613, 'Yunnan', '云南', 1, 0.000000000, 0.000000000, 0),
(614, 'Baoshan', '保山', 613, 99.170000000, 25.120000000, 0),
(615, 'Chuxiong', '楚雄', 613, 86.030000000, 44.300000000, 0),
(616, 'Dali', '大理', 613, 86.030000000, 44.300000000, 0),
(617, 'Dehong', '德宏', 613, 86.030000000, 44.300000000, 0),
(618, 'Diqing', '迪庆', 613, 86.030000000, 44.300000000, 0),
(619, 'Honghe', '红河', 613, 86.030000000, 44.300000000, 0),
(620, 'Kunming', '昆明', 613, 102.720000000, 25.050000000, 0),
(621, 'Lijiang', '丽江', 613, 100.230000000, 26.880000000, 0),
(622, 'Lincang', '临沧', 613, 100.080000000, 23.880000000, 0),
(623, 'Nujiang', '怒江', 613, 86.030000000, 44.300000000, 0),
(624, 'Puer', '普洱', 613, 0.000000000, 0.000000000, 0),
(625, 'Qujing', '曲靖', 613, 103.800000000, 25.500000000, 0),
(626, 'Wenshan', '文山', 613, 86.030000000, 44.300000000, 0),
(627, 'Xishuangbanna', '西双版纳', 613, 86.030000000, 44.300000000, 0),
(628, 'Yuxi', '玉溪', 613, 102.550000000, 24.350000000, 0),
(629, 'Zhaotong', '昭通', 613, 103.720000000, 27.330000000, 0),
(630, 'Zhejiang', '浙江', 1, 0.000000000, 0.000000000, 0),
(631, 'Hangzhou', '杭州', 630, 120.150000000, 30.280000000, 0),
(632, 'Huzhou', '湖州', 630, 120.080000000, 30.900000000, 0),
(633, 'Jiaxing', '嘉兴', 630, 120.750000000, 30.750000000, 0),
(634, 'Jinhua', '金华', 630, 119.650000000, 29.080000000, 0),
(635, 'Lishui', '丽水', 630, 119.920000000, 28.450000000, 0),
(636, 'Ningbo', '宁波', 630, 121.550000000, 29.880000000, 0),
(637, 'Shaoxing', '绍兴', 630, 120.570000000, 30.000000000, 0),
(638, 'Taizhou', '台州', 630, 121.430000000, 28.680000000, 0),
(639, 'Wenzhou', '温州', 630, 120.700000000, 28.000000000, 0),
(640, 'Zhoushan', '舟山', 630, 122.200000000, 30.000000000, 0),
(641, 'Quzhou', '衢州', 630, 118.870000000, 28.930000000, 0),
(642, 'Chongqing', '重庆', 1, 0.000000000, 0.000000000, 0),
(643, 'Banan', '巴南', 642, 106.520000000, 29.380000000, 0),
(644, 'New north zone', '北部新区', 642, 0.000000000, 0.000000000, 0),
(645, 'Beibei', '北碚', 642, 106.400000000, 29.800000000, 0),
(646, 'Changshou', '长寿', 642, 107.080000000, 29.870000000, 0),
(647, 'Chengkou', '城口', 642, 108.670000000, 31.950000000, 0),
(648, 'Dadukou', '大渡口', 642, 106.480000000, 29.480000000, 0),
(649, 'Dazu', '大足', 642, 105.720000000, 29.700000000, 0),
(650, 'Dianjiang', '垫江', 642, 107.350000000, 30.330000000, 0),
(651, 'Fengdu', '丰都', 642, 107.730000000, 29.870000000, 0),
(652, 'Fengjie', '奉节', 642, 109.470000000, 31.020000000, 0),
(653, 'Fuling', '涪陵', 642, 107.400000000, 29.720000000, 0),
(654, 'Gaoxin', '高新', 642, 0.000000000, 0.000000000, 0),
(655, 'Hechuan', '合川', 642, 0.000000000, 0.000000000, 0),
(656, 'Jiangbei', '江北', 642, 106.570000000, 29.600000000, 0),
(657, 'Jiangjin', '江津', 642, 0.000000000, 0.000000000, 0),
(658, 'Jiulongpo', '九龙坡', 642, 106.500000000, 29.500000000, 0),
(659, 'Kaixian', '开县', 642, 108.420000000, 31.180000000, 0),
(660, 'Liangping', '梁平', 642, 107.800000000, 30.680000000, 0),
(661, 'Nan\'an', '南岸', 642, 106.570000000, 29.520000000, 0),
(662, 'Nanchuan', '南川', 642, 0.000000000, 0.000000000, 0),
(663, 'Pengshui', '彭水', 642, 86.030000000, 44.300000000, 0),
(664, 'Qianjiang', '黔江', 642, 108.770000000, 29.530000000, 0),
(665, 'Rongchang', '荣昌', 642, 105.580000000, 29.400000000, 0),
(666, 'Shapingba', '沙坪坝', 642, 106.450000000, 29.530000000, 0),
(667, 'Shizhu', '石柱', 642, 86.030000000, 44.300000000, 0),
(668, 'Tongliang', '铜梁', 642, 106.050000000, 29.850000000, 0),
(669, 'Wanzhou', '万州', 642, 108.400000000, 30.820000000, 0),
(670, 'Wushan', '巫山', 642, 109.880000000, 31.080000000, 0),
(671, 'Wuxi', '巫溪', 642, 109.630000000, 31.400000000, 0),
(672, 'Wulong', '武隆', 642, 107.750000000, 29.330000000, 0),
(673, 'Xiushan', '秀山', 642, 86.030000000, 44.300000000, 0),
(674, 'Yongchuan', '永川', 642, 0.000000000, 0.000000000, 0),
(675, 'Youyang', '酉阳', 642, 86.030000000, 44.300000000, 0),
(676, 'Yubei', '渝北', 642, 106.630000000, 29.720000000, 0),
(677, 'Yuzhong', '渝中', 642, 106.570000000, 29.550000000, 0),
(678, 'Yunyang', '云阳', 642, 108.670000000, 30.950000000, 0),
(679, 'Zhongxian', '忠县', 642, 108.020000000, 30.300000000, 0),
(680, 'Tongnan', '潼南', 642, 105.830000000, 30.180000000, 0),
(681, 'Bishan', '璧山', 642, 106.220000000, 29.600000000, 0),
(682, 'Qijiang', '綦江', 642, 106.650000000, 29.030000000, 0),
(683, 'Hong Kong', '香港', 2, 0.000000000, 0.000000000, 0),
(684, 'Macau', '澳門', 3, 0.000000000, 0.000000000, 0),
(685, 'Taiwan', '台灣', 4, 0.000000000, 0.000000000, 0),
(686, 'Shapingba', '沙坪坝', 642, 0.000000000, 0.000000000, 0),
(687, 'Uzbekistan', 'Uzbekistan', 0, 0.000000000, 0.000000000, 0),
(688, 'Tajikistan', 'Tajikistan', 0, 0.000000000, 0.000000000, 0);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;