INSERT INTO `bore`.`cont_scripture` (`scripture_id`, `name`, `desc`, `img_path`, `content_path`, `trans_content_path`) VALUES 
('10000001', 
'般若波罗蜜多心经', 
'《心经》全称为《摩诃般若波罗蜜多心经》，是佛经中字数最少的一部经典著作（只有260个字）。因其字数最少、含义最深、传奇最多、影响最大，《心经》篇幅虽小，却浓缩了整个般若类经典的精华，受持读诵此经功德无量无边。 \n\n念诵《心经》能增长大智慧，福报，能去除贪、嗔、痴。常诵可增长记忆力，学业、事业、婚姻顺利，心想事成，功德无量。 ', 
'/upload/scripture/10000001.png', 
'/upload/scripture/10000001_0.txt', 
'/upload/scripture/10000001_1.txt');

INSERT INTO `bore`.`cont_scripture` (`scripture_id`, `name`, `desc`, `img_path`, `content_path`, `trans_content_path`) VALUES 
('10000002', 
'金刚经', 
'《金刚经》，全名是《金刚般若波罗蜜经》。来自印度的初期大乘佛教。主要讲述大乘佛教的空性与慈悲精神。因其包含根本般若的重要思想，在般若系大乘经中可视为一个略本。\n\n《金刚经》传入中国后，自东晋到唐朝共有六个译本，以鸠摩罗什所译《金刚般若波罗蜜经》最为流行。\n\n受持读诵此经，不但可以开慧(明心见性)，而且又可以积福(积功累德)，消业除障，增福增慧，早日圆满，助往生极乐，功德不可思议。', 
'/upload/scripture/10000002.png', 
'/upload/scripture/10000002_0.txt', 
'/upload/scripture/10000002_1.txt');

INSERT INTO `bore`.`cont_scripture` (`scripture_id`, `name`, `desc`, `img_path`, `content_path`, `trans_content_path`) VALUES 
('10000003', 
'阿弥陀经', 
'《佛说阿弥陀经》，大乘佛教经典之一，为净土宗所尊崇，被列为净土三经之一。姚秦三藏法师鸠摩罗什译。此经为佛经中极少数非由佛陀弟子提问，而由佛陀不问自说的经典。\n\n拜读此经，众生可了解阿弥陀佛名号由来与意义，再而广修福慧善根，得证自在往生极乐世界的法门，最终得到无上功德。　', 
'/upload/scripture/10000003.png', 
'/upload/scripture/10000003_0.txt', 
'/upload/scripture/10000003_1.txt');

INSERT INTO `bore`.`cont_scripture` (`scripture_id`, `name`, `desc`, `img_path`, `content_path`, `trans_content_path`) VALUES 
('10000004', 
'无量寿经', 
'《无量寿经》全称《佛说无量寿经》，亦称《大阿弥陀经》，是净土宗的基本经典之一，为“净土五经一论”中的一经，净土宗的大部分修行方法均可在该经中找到理论依据。\n\n经中介绍阿弥陀佛（无量寿佛）所发诸大愿，建立弥陀净土接引十方世界众生，以及弥陀净土的大概样貌。念诵此经，能培养我们的清净心、根本智，快速地将妄想、习气很快的洗干净。能修行积德，成就佛果。', 
'/upload/scripture/10000004.png', 
'/upload/scripture/10000004_0.txt', 
'/upload/scripture/10000004_1.txt');

INSERT INTO `bore`.`cont_scripture` (`scripture_id`, `name`, `desc`, `img_path`, `content_path`, `trans_content_path`) VALUES 
('10000005', 
'地藏经', 
'《地藏经》，又称《地藏菩萨本愿经》、《地藏本愿经》、《地藏本行经》、《地藏本誓力经》，唐朝高僧实叉难陀翻译。收于《大正藏》第十三册。属于地藏三经之一，其余两部经分别是《占察善恶业报经》和《大乘大集地藏十轮经》。佛陀赞扬了地藏菩萨「地狱不空，誓不成佛，众生度尽，方证菩提」的宏大誓愿。\n\n诵读《地藏经》，可以帮助我们消除业障，超度我们身上的远亲债主，得福得慧，离开苦难。', 
'/upload/scripture/10000005.png', 
'/upload/scripture/10000005_0.txt', 
'/upload/scripture/10000005_1.txt');


INSERT INTO `bore`.`cont_scripture` (`scripture_id`, `name`, `desc`, `img_path`, `content_path`, `trans_content_path`) VALUES 
('10000006', 
'楞严经', 
'《楞严经》，佛教经典。又称《首楞严经》、《大佛顶经》、《大佛顶首楞严经》、《中印度那烂陀大道场经》。全称《大佛顶如来密因修证了义诸菩萨万行首楞严经》。唐般剌蜜帝译。共十卷。\n\n《楞严经》，每一句都有无量意义，每一义都有无量功德。诚心持诵楞严经，一生受益无尽，能令人们在短时间内得到大福德、大智慧，容貌端严，心得安乐，消除业障，成就佛果。', 
'/upload/scripture/10000006.png', 
'/upload/scripture/10000006_0.txt', 
'/upload/scripture/10000006_1.txt');


INSERT INTO `bore`.`cont_scripture` (`scripture_id`, `name`, `desc`, `img_path`, `content_path`, `trans_content_path`) VALUES 
('10000007', 
'华严经', 
'华严经，全称《大方广佛华严经》。大乘佛教主要经典之一，华严宗亦贤首宗的立宗之经。佛法中法界之根本经典。由实叉难陀翻译，八十卷。内容记载佛陀因行果德，开显出重重无尽、事事无碍之妙旨。\n\n念诵《华严经》，能灭五无间罪，灭疾病烦恼。往生人天善处，降伏魔怨，一切如意。读诵《华严经》哪怕只有一句一偈，也会有无量无边的功德利益。', 
'/upload/scripture/10000007.png', 
'/upload/scripture/10000007_0.txt', 
'/upload/scripture/10000007_1.txt');


INSERT INTO `bore`.`cont_scripture` (`scripture_id`, `name`, `desc`, `img_path`, `content_path`, `trans_content_path`) VALUES 
('10000008', 
'楞伽经', 
'《楞伽经》全称《楞伽阿跋多罗宝经》，亦称《入楞伽经》、《大乘入楞伽经》。其译名分别出自南朝宋元嘉二十年(443年)的求那跋陀罗、北魏的菩提流支、唐代于阗（今新疆和田）僧人实叉难陀。', 
'/upload/scripture/10000008.png', 
'/upload/scripture/10000008_0.txt', 
'/upload/scripture/10000008_1.txt');


INSERT INTO `bore`.`cont_scripture` (`scripture_id`, `name`, `desc`, `img_path`, `content_path`, `trans_content_path`) VALUES 
('10000009', 
'观无量寿经', 
'《观无量寿佛经》，净土宗五经之一。本经是释尊在摩羯陀国王舍城东北方耆阇崛山（别名灵鹫山），于千二百五十人之声闻众和三万二千菩萨众之前，以王舍城所发生的宫廷事变为起因而述说的经典。\n\n念诵《观无量寿佛经》，可知晓心造诸佛之法，即“心即是佛，佛即是心”的道理。可知往生靠的是弥陀的愿力，不论罪福，真信切愿，乘佛愿力，定能往生。', 
'/upload/scripture/10000009.png', 
'/upload/scripture/10000009_0.txt', 
'/upload/scripture/10000009_1.txt');


INSERT INTO `bore`.`cont_scripture` (`scripture_id`, `name`, `desc`, `img_path`, `content_path`, `trans_content_path`) VALUES 
('10000010', 
'药师经', 
'《药师经》，全名《药师琉璃光如来本愿功德经》，由唐三藏法师玄奘奉诏译为中文。和《地藏经》一样，《药师经》是赞叹药师佛行愿的佛经，是大乘经典之一。\n\n药师法门，适合诸事不顺的人修。众生心中随所乐求，一切皆遂。求长寿得长寿。求富饶得富饶。求官位得官位。求男女得男女。修药师法门，聪明智慧，勇健威猛，如大力士，速成佛道。', 
'/upload/scripture/10000010.png', 
'/upload/scripture/10000010_0.txt', 
'/upload/scripture/10000010_1.txt');


INSERT INTO `bore`.`cont_scripture` (`scripture_id`, `name`, `desc`, `img_path`, `content_path`, `trans_content_path`) VALUES 
('10000011', 
'法华经', 
'妙法莲华经，简称《法华经》，共七卷二十八品，鸠摩罗什大师译。今收在《大正藏》第九册。为大乘佛教要典之一。妙法，意为所说教法微妙无上；莲华经，比喻经典之洁白完美。在克什米尔、尼泊尔和中国新疆、西藏等地有40多种梵文版本，分为尼泊尔体系、克什米尔体系（基尔基特）和新疆体系。\n\n念诵《法华经》，可知佛陀度众生的道理，以及在生活中如何树立正确的人生观、价值观以领悟佛法。抄写《法华经》，殊胜功德，有助开悟。', 
'/upload/scripture/10000011.png', 
'/upload/scripture/10000011_0.txt', 
'/upload/scripture/10000011_1.txt');


INSERT INTO `bore`.`cont_scripture` (`scripture_id`, `name`, `desc`, `img_path`, `content_path`, `trans_content_path`) VALUES 
('10000012', 
'六祖坛经', 
'《六祖坛经》，佛教禅宗典籍。亦称《坛经》，全称《南宗顿教最上大乘摩诃般若波罗蜜经六祖惠能大师于韶州大梵寺施法坛经》。禅宗六祖惠能说，弟子法海集录。\n\n《六祖坛经》记载惠能一生得法传法的事迹及启导门徒的言教，内容丰富，文字通俗，是研究禅宗思想渊源的重要依据。念诵本经，可增长智慧、消除业障、累积福报。化解人心中的死结，解释人的困惑。', 
'/upload/scripture/10000012.png', 
'/upload/scripture/10000012_0.txt', 
'/upload/scripture/10000012_1.txt');


INSERT INTO `bore`.`cont_scripture` (`scripture_id`, `name`, `desc`, `img_path`, `content_path`, `trans_content_path`) VALUES 
('10000013', 
'圆觉经', 
'《圆觉经》，是《大方广圆觉修多罗了义经》的简称，又作《大方广圆觉经》、《圆觉修多罗了义经》、《圆觉了义经》，佛教大乘之经典。内容记载了佛为文殊、普贤等十二位菩萨宣说如来圆觉的妙理和观行方法，全经分作序、正、流通三分，是唐、宋、明以来教（贤首、天台）、禅各宗盛行讲习的经典。\n\n念诵《圆觉经》，能常得吉神拥护，一切瘟疫、水火、盗贼、刀兵、牢狱之灾，悉皆不受。至心奉法，虽无希求，自然衣食丰足，家庭和睦，福禄绵长。', 
'/upload/scripture/10000013.png', 
'/upload/scripture/10000013_0.txt', 
'/upload/scripture/10000013_1.txt');


INSERT INTO `bore`.`cont_scripture` (`scripture_id`, `name`, `desc`, `img_path`, `content_path`, `trans_content_path`) VALUES 
('10000014', 
'佛说四十二章经', 
'《佛说四十二章经》是从印度传到中国来的第一部重要经典著作。迦叶摩腾、竺法兰把佛所说的某一段话称为一章，共选集了四十二段话，编集成了这部《佛说四十二章经》。通篇言简义丰，明了易懂。\n\n诵读本经，通摄大小乘一切教义，涵诸法要。了解佛门弟子如何修行，使我们明理增慧，愉悦身心，破迷开悟，业消智朗。', 
'/upload/scripture/10000014.png', 
'/upload/scripture/10000014_0.txt', 
'/upload/scripture/10000014_1.txt');


INSERT INTO `bore`.`cont_scripture` (`scripture_id`, `name`, `desc`, `img_path`, `content_path`, `trans_content_path`) VALUES 
('10000015', 
'大般涅槃经', 
'《大般涅槃经》，亦称《大本涅槃经》或《大涅槃经》，简称《涅槃经》。北凉昙无谶（chèn）译。一共40卷，13品。主要阐述佛身常住不灭，涅槃常乐我净，一切众生悉有佛性，一阐提和声闻、辟支佛均得成佛等大乘佛教思想。\n\n经中处处有伏藏，念诵本经，能了解其中甚深密意，能缘变所缘层层超越，扩大心量，个体阿赖耶回向境觉阿赖耶，回向一心阿赖耶。', 
'/upload/scripture/10000015.png', 
'/upload/scripture/10000015_0.txt', 
'/upload/scripture/10000015_1.txt');


INSERT INTO `bore`.`cont_scripture` (`scripture_id`, `name`, `desc`, `img_path`, `content_path`, `trans_content_path`) VALUES 
('10000016', 
'大势至菩萨念佛圆通章', 
'大势至菩萨念佛圆通章，出自《楞严经》第五卷，受到净土宗第十三代祖师印光大师的提倡，成为中国净土宗五经一论中的一品经。\n\n念诵本经，可知释迦牟尼佛询问大势至菩萨进入禅定、获得开悟的方法。“都摄六根，净念相继”，集中心思，忆佛念佛，维持净念，相续不断。', 
'/upload/scripture/10000016.png', 
'/upload/scripture/10000016_0.txt', 
'/upload/scripture/10000016_1.txt');


INSERT INTO `bore`.`cont_scripture` (`scripture_id`, `name`, `desc`, `img_path`, `content_path`, `trans_content_path`) VALUES 
('10000017', 
'佛遗教经', 
'《佛遗教经》：简称《遗教经》，又名《佛垂般涅槃略说教诫经》，一卷，姚秦·鸠摩罗什译，是佛陀释迦牟尼一生弘法言教内容的概括总结，是佛将入涅槃前对众弟子语重心长的谆谆教诲，也是佛留给后代所有想离苦得乐者的得度因缘。\n\n念诵此经典，心得安慰，日无险事，夜无恶梦，身力充盛，所做吉利。勇离恶道，受生善道。天资超越，福禄殊胜。', 
'/upload/scripture/10000017.png', 
'/upload/scripture/10000017_0.txt', 
'/upload/scripture/10000017_1.txt');


INSERT INTO `bore`.`cont_scripture` (`scripture_id`, `name`, `desc`, `img_path`, `content_path`, `trans_content_path`) VALUES 
('10000018', 
'十善业道经', 
'《十善业道经》，中文版本为唐朝实叉难陀翻译，北宋施护所译《佛为娑伽罗龙王所说大乘经》为同经异译。本经是释迦牟尼佛在娑竭罗龙宫，为龙王所宣说的经典，即诸佛菩萨有一方法，能断除一切痛苦，获取极大利益，这个方法就是修行十善业道。\n\n念诵《十善道业经》后，离杀生，即可起大慈心，永断一切嗔恚习气，身常无病，寿命长远。可明了人生的因果，成就天人果报。', 
'/upload/scripture/10000018.png', 
'/upload/scripture/10000018_0.txt', 
'/upload/scripture/10000018_1.txt');

INSERT INTO `bore`.`cont_scripture` (`scripture_id`, `name`, `desc`, `img_path`, `content_path`, `trans_content_path`) VALUES 
('10000019', 
'维摩诘经', 
'《维摩诘经》简称《维摩经》，全名是《维摩诘所说经》，亦名《不可思议解脱经》。维摩诘是一个在家的大乘佛教的居士，是著名的在家菩萨。通过他与文殊师利等人共论佛法，阐扬大乘般若性空的思想。其义旨为“弹偏斥小”“叹大褒圆”，批判一般佛弟子等所行和悟境的片面性，斥责歪曲佛道的绝对境界。\n\n诵读《维摩诘经》，能为一切众生种植善根。以众生心，作大福田，获无量胜果。所生之处，常得见佛闻法。直至三慧宏开，六通亲证，速得成佛。', 
'/upload/scripture/10000019.png', 
'/upload/scripture/10000019_0.txt', 
'/upload/scripture/10000019_1.txt');



INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000001', '八正道', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000002', '般若', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000003', '布施', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000004', '禅定', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000005', '禅宗', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000006', '持戒', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000007', '持午', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000008', '出家', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000009', '大德', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000010', '二空', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000011', '二执', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000012', '放生', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000013', '佛诞', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000014', '佛光', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000015', '佛果', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000016', '佛偈', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000017', '佛龛', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000018', '佛祖', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000019', '福报', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000020', '供养', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000021', '皈依', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000022', '开光', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000023', '六道', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000024', '六度', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000025', '六根', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000026', '六相', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000027', '涅槃', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000028', '菩提', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000029', '普佛', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000030', '七觉支', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000031', '三藏', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000032', '三毒', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000033', '三恶道', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000034', '三界', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000035', '三业', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000036', '善恶', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000037', '舍利', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000038', '神通', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000039', '十二因缘', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000040', '十善业', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000041', '实相', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000042', '四恩', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000043', '四圣谛', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000044', '万法', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000045', '往生', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000046', '无我', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000047', '五根', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000048', '五戒', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000049', '五欲', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000050', '五蕴', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000051', '小乘', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000052', '信徒', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000053', '修行', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000054', '虚空', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000055', '因果', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000056', '因缘', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000057', '智慧', '1000000001');
INSERT INTO `bore`.`cont_item` (`item_id`, `name`, `content_id`) VALUES ('10000058', '众生', '1000000001');



INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('100000', '中国', '0', '中国', '0', NULL, '中国', '116.3683244', '39.915085', 'China', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('110000', '北京', '100000', '北京', '1', NULL, '中国,北京', '116.405285', '39.904989', 'Beijing', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('110100', '北京市', '110000', '北京', '2', NULL, '中国,北京,北京市', '116.405285', '39.904989', 'Beijing', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('120000', '天津', '100000', '天津', '1', NULL, '中国,天津', '117.190182', '39.125596', 'Tianjin', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('120100', '天津市', '120000', '天津', '2', NULL, '中国,天津,天津市', '117.190182', '39.125596', 'Tianjin', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('130000', '河北省', '100000', '河北', '1', NULL, '中国,河北省', '114.502461', '38.045474', 'Hebei', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('130100', '石家庄市', '130000', '石家庄', '2', '50011', '中国,河北省,石家庄市', '114.502461', '38.045474', 'Shijiazhuang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('130200', '唐山市', '130000', '唐山', '2', '63000', '中国,河北省,唐山市', '118.175393', '39.635113', 'Tangshan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('130300', '秦皇岛市', '130000', '秦皇岛', '2', '66000', '中国,河北省,秦皇岛市', '119.586579', '39.942531', 'Qinhuangdao', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('130400', '邯郸市', '130000', '邯郸', '2', '56002', '中国,河北省,邯郸市', '114.490686', '36.612273', 'Handan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('130500', '邢台市', '130000', '邢台', '2', '54001', '中国,河北省,邢台市', '114.508851', '37.0682', 'Xingtai', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('130600', '保定市', '130000', '保定', '2', '71052', '中国,河北省,保定市', '115.482331', '38.867657', 'Baoding', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('130700', '张家口市', '130000', '张家口', '2', '75000', '中国,河北省,张家口市', '114.884091', '40.811901', 'Zhangjiakou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('130800', '承德市', '130000', '承德', '2', '67000', '中国,河北省,承德市', '117.939152', '40.976204', 'Chengde', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('130900', '沧州市', '130000', '沧州', '2', '61001', '中国,河北省,沧州市', '116.857461', '38.310582', 'Cangzhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('131000', '廊坊市', '130000', '廊坊', '2', '65000', '中国,河北省,廊坊市', '116.713873', '39.529244', 'Langfang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('131100', '衡水市', '130000', '衡水', '2', '53000', '中国,河北省,衡水市', '115.665993', '37.735097', 'Hengshui', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('140000', '山西省', '100000', '山西', '1', NULL, '中国,山西省', '112.549248', '37.857014', 'Shanxi', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('140100', '太原市', '140000', '太原', '2', '30082', '中国,山西省,太原市', '112.549248', '37.857014', 'Taiyuan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('140200', '大同市', '140000', '大同', '2', '37008', '中国,山西省,大同市', '113.295259', '40.09031', 'Datong', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('140300', '阳泉市', '140000', '阳泉', '2', '45000', '中国,山西省,阳泉市', '113.583285', '37.861188', 'Yangquan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('140400', '长治市', '140000', '长治', '2', '46000', '中国,山西省,长治市', '113.113556', '36.191112', 'Changzhi', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('140500', '晋城市', '140000', '晋城', '2', '48000', '中国,山西省,晋城市', '112.851274', '35.497553', 'Jincheng', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('140600', '朔州市', '140000', '朔州', '2', '38500', '中国,山西省,朔州市', '112.433387', '39.331261', 'Shuozhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('140700', '晋中市', '140000', '晋中', '2', '30600', '中国,山西省,晋中市', '112.736465', '37.696495', 'Jinzhong', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('140800', '运城市', '140000', '运城', '2', '44000', '中国,山西省,运城市', '111.003957', '35.022778', 'Yuncheng', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('140900', '忻州市', '140000', '忻州', '2', '34000', '中国,山西省,忻州市', '112.733538', '38.41769', 'Xinzhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('141000', '临汾市', '140000', '临汾', '2', '41000', '中国,山西省,临汾市', '111.517973', '36.08415', 'Linfen', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('141100', '吕梁市', '140000', '吕梁', '2', '33000', '中国,山西省,吕梁市', '111.134335', '37.524366', 'Lvliang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('150000', '内蒙古自治区', '100000', '内蒙古', '1', NULL, '中国,内蒙古自治区', '111.670801', '40.818311', 'Inner Mongolia', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('150100', '呼和浩特市', '150000', '呼和浩特', '2', '10000', '中国,内蒙古自治区,呼和浩特市', '111.670801', '40.818311', 'Hohhot', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('150200', '包头市', '150000', '包头', '2', '14025', '中国,内蒙古自治区,包头市', '109.840405', '40.658168', 'Baotou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('150300', '乌海市', '150000', '乌海', '2', '16000', '中国,内蒙古自治区,乌海市', '106.825563', '39.673734', 'Wuhai', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('150400', '赤峰市', '150000', '赤峰', '2', '24000', '中国,内蒙古自治区,赤峰市', '118.956806', '42.275317', 'Chifeng', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('150500', '通辽市', '150000', '通辽', '2', '28000', '中国,内蒙古自治区,通辽市', '122.263119', '43.617429', 'Tongliao', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('150600', '鄂尔多斯市', '150000', '鄂尔多斯', '2', '17004', '中国,内蒙古自治区,鄂尔多斯市', '109.99029', '39.817179', 'Ordos', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('150700', '呼伦贝尔市', '150000', '呼伦贝尔', '2', '21008', '中国,内蒙古自治区,呼伦贝尔市', '119.758168', '49.215333', 'Hulunber', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('150800', '巴彦淖尔市', '150000', '巴彦淖尔', '2', '15001', '中国,内蒙古自治区,巴彦淖尔市', '107.416959', '40.757402', 'Bayan Nur', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('150900', '乌兰察布市', '150000', '乌兰察布', '2', '12000', '中国,内蒙古自治区,乌兰察布市', '113.114543', '41.034126', 'Ulanqab', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('152200', '兴安盟', '150000', '兴安盟', '2', '137401', '中国,内蒙古自治区,兴安盟', '122.070317', '46.076268', 'Hinggan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('152500', '锡林郭勒盟', '150000', '锡林郭勒盟', '2', '26000', '中国,内蒙古自治区,锡林郭勒盟', '116.090996', '43.944018', 'Xilin Gol', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('152900', '阿拉善盟', '150000', '阿拉善盟', '2', '750306', '中国,内蒙古自治区,阿拉善盟', '105.706422', '38.844814', 'Alxa', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('210000', '辽宁省', '100000', '辽宁', '1', NULL, '中国,辽宁省', '123.429096', '41.796767', 'Liaoning', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('210100', '沈阳市', '210000', '沈阳', '2', '110013', '中国,辽宁省,沈阳市', '123.429096', '41.796767', 'Shenyang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('210200', '大连市', '210000', '大连', '2', '116011', '中国,辽宁省,大连市', '121.618622', '38.91459', 'Dalian', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('210300', '鞍山市', '210000', '鞍山', '2', '114001', '中国,辽宁省,鞍山市', '122.995632', '41.110626', 'Anshan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('210400', '抚顺市', '210000', '抚顺', '2', '113008', '中国,辽宁省,抚顺市', '123.921109', '41.875956', 'Fushun', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('210500', '本溪市', '210000', '本溪', '2', '117000', '中国,辽宁省,本溪市', '123.770519', '41.297909', 'Benxi', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('210600', '丹东市', '210000', '丹东', '2', '118000', '中国,辽宁省,丹东市', '124.383044', '40.124296', 'Dandong', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('210700', '锦州市', '210000', '锦州', '2', '121000', '中国,辽宁省,锦州市', '121.135742', '41.119269', 'Jinzhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('210800', '营口市', '210000', '营口', '2', '115003', '中国,辽宁省,营口市', '122.235151', '40.667432', 'Yingkou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('210900', '阜新市', '210000', '阜新', '2', '123000', '中国,辽宁省,阜新市', '121.648962', '42.011796', 'Fuxin', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('211000', '辽阳市', '210000', '辽阳', '2', '111000', '中国,辽宁省,辽阳市', '123.18152', '41.269402', 'Liaoyang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('211100', '盘锦市', '210000', '盘锦', '2', '124010', '中国,辽宁省,盘锦市', '122.06957', '41.124484', 'Panjin', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('211200', '铁岭市', '210000', '铁岭', '2', '112000', '中国,辽宁省,铁岭市', '123.844279', '42.290585', 'Tieling', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('211300', '朝阳市', '210000', '朝阳', '2', '122000', '中国,辽宁省,朝阳市', '120.451176', '41.576758', 'Chaoyang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('211400', '葫芦岛市', '210000', '葫芦岛', '2', '125000', '中国,辽宁省,葫芦岛市', '120.856394', '40.755572', 'Huludao', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('211500', '金普新区', '210000', '金普新区', '2', '116100', '中国,辽宁省,金普新区', '121.789627', '39.055451', 'jinpuxinqu', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('220000', '吉林省', '100000', '吉林', '1', NULL, '中国,吉林省', '125.3245', '43.886841', 'Jilin', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('220100', '长春市', '220000', '长春', '2', '130022', '中国,吉林省,长春市', '125.3245', '43.886841', 'Changchun', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('220200', '吉林市', '220000', '吉林', '2', '132011', '中国,吉林省,吉林市', '126.55302', '43.843577', 'Jilin', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('220300', '四平市', '220000', '四平', '2', '136000', '中国,吉林省,四平市', '124.370785', '43.170344', 'Siping', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('220400', '辽源市', '220000', '辽源', '2', '136200', '中国,吉林省,辽源市', '125.145349', '42.902692', 'Liaoyuan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('220500', '通化市', '220000', '通化', '2', '134001', '中国,吉林省,通化市', '125.936501', '41.721177', 'Tonghua', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('220600', '白山市', '220000', '白山', '2', '134300', '中国,吉林省,白山市', '126.427839', '41.942505', 'Baishan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('220700', '松原市', '220000', '松原', '2', '138000', '中国,吉林省,松原市', '124.823608', '45.118243', 'Songyuan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('220800', '白城市', '220000', '白城', '2', '137000', '中国,吉林省,白城市', '122.841114', '45.619026', 'Baicheng', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('222400', '延边朝鲜族自治州', '220000', '延边', '2', '133000', '中国,吉林省,延边朝鲜族自治州', '129.513228', '42.904823', 'Yanbian', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('230000', '黑龙江省', '100000', '黑龙江', '1', NULL, '中国,黑龙江省', '126.642464', '45.756967', 'Heilongjiang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('230100', '哈尔滨市', '230000', '哈尔滨', '2', '150010', '中国,黑龙江省,哈尔滨市', '126.642464', '45.756967', 'Harbin', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('230200', '齐齐哈尔市', '230000', '齐齐哈尔', '2', '161005', '中国,黑龙江省,齐齐哈尔市', '123.953486', '47.348079', 'Qiqihar', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('230300', '鸡西市', '230000', '鸡西', '2', '158100', '中国,黑龙江省,鸡西市', '130.975966', '45.300046', 'Jixi', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('230400', '鹤岗市', '230000', '鹤岗', '2', '154100', '中国,黑龙江省,鹤岗市', '130.277487', '47.332085', 'Hegang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('230500', '双鸭山市', '230000', '双鸭山', '2', '155100', '中国,黑龙江省,双鸭山市', '131.157304', '46.643442', 'Shuangyashan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('230600', '大庆市', '230000', '大庆', '2', '163000', '中国,黑龙江省,大庆市', '125.11272', '46.590734', 'Daqing', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('230700', '伊春市', '230000', '伊春', '2', '153000', '中国,黑龙江省,伊春市', '128.899396', '47.724775', 'Yichun', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('230800', '佳木斯市', '230000', '佳木斯', '2', '154002', '中国,黑龙江省,佳木斯市', '130.361634', '46.809606', 'Jiamusi', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('230900', '七台河市', '230000', '七台河', '2', '154600', '中国,黑龙江省,七台河市', '131.015584', '45.771266', 'Qitaihe', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('231000', '牡丹江市', '230000', '牡丹江', '2', '157000', '中国,黑龙江省,牡丹江市', '129.618602', '44.582962', 'Mudanjiang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('231100', '黑河市', '230000', '黑河', '2', '164300', '中国,黑龙江省,黑河市', '127.499023', '50.249585', 'Heihe', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('231200', '绥化市', '230000', '绥化', '2', '152000', '中国,黑龙江省,绥化市', '126.99293', '46.637393', 'Suihua', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('232700', '大兴安岭地区', '230000', '大兴安岭', '2', '165000', '中国,黑龙江省,大兴安岭地区', '124.711526', '52.335262', 'DaXingAnLing', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('310000', '上海', '100000', '上海', '1', NULL, '中国,上海', '121.472644', '31.231706', 'Shanghai', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('310100', '上海市', '310000', '上海', '2', NULL, '中国,上海,上海市', '121.472644', '31.231706', 'Shanghai', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('320000', '江苏省', '100000', '江苏', '1', NULL, '中国,江苏省', '118.767413', '32.041544', 'Jiangsu', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('320100', '南京市', '320000', '南京', '2', '210008', '中国,江苏省,南京市', '118.767413', '32.041544', 'Nanjing', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('320200', '无锡市', '320000', '无锡', '2', '214000', '中国,江苏省,无锡市', '120.301663', '31.574729', 'Wuxi', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('320300', '徐州市', '320000', '徐州', '2', '221003', '中国,江苏省,徐州市', '117.184811', '34.261792', 'Xuzhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('320400', '常州市', '320000', '常州', '2', '221003', '中国,江苏省,常州市', '119.946973', '31.772752', 'Changzhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('320500', '苏州市', '320000', '苏州', '2', '215002', '中国,江苏省,苏州市', '120.619585', '31.299379', 'Suzhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('320600', '南通市', '320000', '南通', '2', '226001', '中国,江苏省,南通市', '120.864608', '32.016212', 'Nantong', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('320700', '连云港市', '320000', '连云港', '2', '222002', '中国,江苏省,连云港市', '119.178821', '34.600018', 'Lianyungang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('320800', '淮安市', '320000', '淮安', '2', '223001', '中国,江苏省,淮安市', '119.021265', '33.597506', 'Huai\'an', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('320900', '盐城市', '320000', '盐城', '2', '224005', '中国,江苏省,盐城市', '120.139998', '33.377631', 'Yancheng', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('321000', '扬州市', '320000', '扬州', '2', '225002', '中国,江苏省,扬州市', '119.421003', '32.393159', 'Yangzhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('321100', '镇江市', '320000', '镇江', '2', '212004', '中国,江苏省,镇江市', '119.452753', '32.204402', 'Zhenjiang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('321200', '泰州市', '320000', '泰州', '2', '225300', '中国,江苏省,泰州市', '119.915176', '32.484882', 'Taizhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('321300', '宿迁市', '320000', '宿迁', '2', '223800', '中国,江苏省,宿迁市', '118.293328', '33.945154', 'Suqian', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('330000', '浙江省', '100000', '浙江', '1', NULL, '中国,浙江省', '120.153576', '30.287459', 'Zhejiang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('330100', '杭州市', '330000', '杭州', '2', '310026', '中国,浙江省,杭州市', '120.153576', '30.287459', 'Hangzhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('330200', '宁波市', '330000', '宁波', '2', '315000', '中国,浙江省,宁波市', '121.549792', '29.868388', 'Ningbo', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('330300', '温州市', '330000', '温州', '2', '325000', '中国,浙江省,温州市', '120.672111', '28.000575', 'Wenzhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('330400', '嘉兴市', '330000', '嘉兴', '2', '314000', '中国,浙江省,嘉兴市', '120.750865', '30.762653', 'Jiaxing', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('330500', '湖州市', '330000', '湖州', '2', '313000', '中国,浙江省,湖州市', '120.102398', '30.867198', 'Huzhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('330600', '绍兴市', '330000', '绍兴', '2', '312000', '中国,浙江省,绍兴市', '120.582112', '29.997117', 'Shaoxing', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('330700', '金华市', '330000', '金华', '2', '321000', '中国,浙江省,金华市', '119.649506', '29.089524', 'Jinhua', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('330800', '衢州市', '330000', '衢州', '2', '324002', '中国,浙江省,衢州市', '118.87263', '28.941708', 'Quzhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('330900', '舟山市', '330000', '舟山', '2', '316000', '中国,浙江省,舟山市', '122.106863', '30.016028', 'Zhoushan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('331000', '台州市', '330000', '台州', '2', '318000', '中国,浙江省,台州市', '121.428599', '28.661378', 'Taizhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('331100', '丽水市', '330000', '丽水', '2', '323000', '中国,浙江省,丽水市', '119.921786', '28.451993', 'Lishui', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('331200', '舟山群岛新区', '330000', '舟山新区', '2', '316000', '中国,浙江省,舟山群岛新区', '122.317657', '29.813242', 'Zhoushan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('340000', '安徽省', '100000', '安徽', '1', NULL, '中国,安徽省', '117.283042', '31.86119', 'Anhui', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('340100', '合肥市', '340000', '合肥', '2', '230001', '中国,安徽省,合肥市', '117.283042', '31.86119', 'Hefei', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('340200', '芜湖市', '340000', '芜湖', '2', '241000', '中国,安徽省,芜湖市', '118.376451', '31.326319', 'Wuhu', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('340300', '蚌埠市', '340000', '蚌埠', '2', '233000', '中国,安徽省,蚌埠市', '117.36237', '32.934037', 'Bengbu', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('340400', '淮南市', '340000', '淮南', '2', '232001', '中国,安徽省,淮南市', '117.025449', '32.645947', 'Huainan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('340500', '马鞍山市', '340000', '马鞍山', '2', '243001', '中国,安徽省,马鞍山市', '118.507906', '31.689362', 'Ma\'anshan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('340600', '淮北市', '340000', '淮北', '2', '235000', '中国,安徽省,淮北市', '116.794664', '33.971707', 'Huaibei', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('340700', '铜陵市', '340000', '铜陵', '2', '244000', '中国,安徽省,铜陵市', '117.816576', '30.929935', 'Tongling', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('340800', '安庆市', '340000', '安庆', '2', '246001', '中国,安徽省,安庆市', '117.053571', '30.524816', 'Anqing', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('341000', '黄山市', '340000', '黄山', '2', '245000', '中国,安徽省,黄山市', '118.317325', '29.709239', 'Huangshan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('341100', '滁州市', '340000', '滁州', '2', '239000', '中国,安徽省,滁州市', '118.316264', '32.303627', 'Chuzhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('341200', '阜阳市', '340000', '阜阳', '2', '236033', '中国,安徽省,阜阳市', '115.819729', '32.896969', 'Fuyang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('341300', '宿州市', '340000', '宿州', '2', '234000', '中国,安徽省,宿州市', '116.984084', '33.633891', 'Suzhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('341500', '六安市', '340000', '六安', '2', '237000', '中国,安徽省,六安市', '116.507676', '31.752889', 'Lu\'an', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('341600', '亳州市', '340000', '亳州', '2', '236802', '中国,安徽省,亳州市', '115.782939', '33.869338', 'Bozhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('341700', '池州市', '340000', '池州', '2', '247100', '中国,安徽省,池州市', '117.489157', '30.656037', 'Chizhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('341800', '宣城市', '340000', '宣城', '2', '242000', '中国,安徽省,宣城市', '118.757995', '30.945667', 'Xuancheng', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('350000', '福建省', '100000', '福建', '1', NULL, '中国,福建省', '119.306239', '26.075302', 'Fujian', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('350100', '福州市', '350000', '福州', '2', '350001', '中国,福建省,福州市', '119.306239', '26.075302', 'Fuzhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('350200', '厦门市', '350000', '厦门', '2', '361003', '中国,福建省,厦门市', '118.11022', '24.490474', 'Xiamen', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('350300', '莆田市', '350000', '莆田', '2', '351100', '中国,福建省,莆田市', '119.007558', '25.431011', 'Putian', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('350400', '三明市', '350000', '三明', '2', '365000', '中国,福建省,三明市', '117.635001', '26.265444', 'Sanming', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('350500', '泉州市', '350000', '泉州', '2', '362000', '中国,福建省,泉州市', '118.589421', '24.908853', 'Quanzhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('350600', '漳州市', '350000', '漳州', '2', '363005', '中国,福建省,漳州市', '117.661801', '24.510897', 'Zhangzhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('350700', '南平市', '350000', '南平', '2', '353000', '中国,福建省,南平市', '118.178459', '26.635627', 'Nanping', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('350800', '龙岩市', '350000', '龙岩', '2', '364000', '中国,福建省,龙岩市', '117.02978', '25.091603', 'Longyan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('350900', '宁德市', '350000', '宁德', '2', '352100', '中国,福建省,宁德市', '119.527082', '26.65924', 'Ningde', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('360000', '江西省', '100000', '江西', '1', NULL, '中国,江西省', '115.892151', '28.676493', 'Jiangxi', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('360100', '南昌市', '360000', '南昌', '2', '330008', '中国,江西省,南昌市', '115.892151', '28.676493', 'Nanchang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('360200', '景德镇市', '360000', '景德镇', '2', '333000', '中国,江西省,景德镇市', '117.214664', '29.29256', 'Jingdezhen', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('360300', '萍乡市', '360000', '萍乡', '2', '337000', '中国,江西省,萍乡市', '113.852186', '27.622946', 'Pingxiang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('360400', '九江市', '360000', '九江', '2', '332000', '中国,江西省,九江市', '115.992811', '29.712034', 'Jiujiang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('360500', '新余市', '360000', '新余', '2', '338025', '中国,江西省,新余市', '114.930835', '27.810834', 'Xinyu', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('360600', '鹰潭市', '360000', '鹰潭', '2', '335000', '中国,江西省,鹰潭市', '117.033838', '28.238638', 'Yingtan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('360700', '赣州市', '360000', '赣州', '2', '341000', '中国,江西省,赣州市', '114.940278', '25.85097', 'Ganzhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('360800', '吉安市', '360000', '吉安', '2', '343000', '中国,江西省,吉安市', '114.986373', '27.111699', 'Ji\'an', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('360900', '宜春市', '360000', '宜春', '2', '336000', '中国,江西省,宜春市', '114.391136', '27.8043', 'Yichun', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('361000', '抚州市', '360000', '抚州', '2', '344000', '中国,江西省,抚州市', '116.358351', '27.98385', 'Fuzhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('361100', '上饶市', '360000', '上饶', '2', '334000', '中国,江西省,上饶市', '117.971185', '28.44442', 'Shangrao', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('370000', '山东省', '100000', '山东', '1', NULL, '中国,山东省', '117.000923', '36.675807', 'Shandong', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('370100', '济南市', '370000', '济南', '2', '250001', '中国,山东省,济南市', '117.000923', '36.675807', 'Jinan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('370200', '青岛市', '370000', '青岛', '2', '266001', '中国,山东省,青岛市', '120.369557', '36.094406', 'Qingdao', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('370300', '淄博市', '370000', '淄博', '2', '255039', '中国,山东省,淄博市', '118.047648', '36.814939', 'Zibo', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('370400', '枣庄市', '370000', '枣庄', '2', '277101', '中国,山东省,枣庄市', '117.557964', '34.856424', 'Zaozhuang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('370500', '东营市', '370000', '东营', '2', '257093', '中国,山东省,东营市', '118.4963', '37.461266', 'Dongying', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('370600', '烟台市', '370000', '烟台', '2', '264010', '中国,山东省,烟台市', '121.391382', '37.539297', 'Yantai', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('370700', '潍坊市', '370000', '潍坊', '2', '261041', '中国,山东省,潍坊市', '119.107078', '36.70925', 'Weifang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('370800', '济宁市', '370000', '济宁', '2', '272119', '中国,山东省,济宁市', '116.587245', '35.415393', 'Jining', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('370900', '泰安市', '370000', '泰安', '2', '271000', '中国,山东省,泰安市', '117.129063', '36.194968', 'Tai\'an', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('371000', '威海市', '370000', '威海', '2', '264200', '中国,山东省,威海市', '122.116394', '37.509691', 'Weihai', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('371100', '日照市', '370000', '日照', '2', '276800', '中国,山东省,日照市', '119.461208', '35.428588', 'Rizhao', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('371200', '莱芜市', '370000', '莱芜', '2', '271100', '中国,山东省,莱芜市', '117.677736', '36.214397', 'Laiwu', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('371300', '临沂市', '370000', '临沂', '2', '253000', '中国,山东省,临沂市', '118.326443', '35.065282', 'Linyi', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('371400', '德州市', '370000', '德州', '2', '253000', '中国,山东省,德州市', '116.307428', '37.453968', 'Dezhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('371500', '聊城市', '370000', '聊城', '2', '252052', '中国,山东省,聊城市', '115.980367', '36.456013', 'Liaocheng', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('371600', '滨州市', '370000', '滨州', '2', '256619', '中国,山东省,滨州市', '118.016974', '37.383542', 'Binzhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('371700', '菏泽市', '370000', '菏泽', '2', '274020', '中国,山东省,菏泽市', '115.469381', '35.246531', 'Heze', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('410000', '河南省', '100000', '河南', '1', NULL, '中国,河南省', '113.665412', '34.757975', 'Henan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('410100', '郑州市', '410000', '郑州', '2', '450000', '中国,河南省,郑州市', '113.665412', '34.757975', 'Zhengzhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('410200', '开封市', '410000', '开封', '2', '475001', '中国,河南省,开封市', '114.341447', '34.797049', 'Kaifeng', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('410300', '洛阳市', '410000', '洛阳', '2', '471000', '中国,河南省,洛阳市', '112.434468', '34.663041', 'Luoyang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('410400', '平顶山市', '410000', '平顶山', '2', '467000', '中国,河南省,平顶山市', '113.307718', '33.735241', 'Pingdingshan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('410500', '安阳市', '410000', '安阳', '2', '455000', '中国,河南省,安阳市', '114.352482', '36.103442', 'Anyang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('410600', '鹤壁市', '410000', '鹤壁', '2', '458030', '中国,河南省,鹤壁市', '114.295444', '35.748236', 'Hebi', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('410700', '新乡市', '410000', '新乡', '2', '453000', '中国,河南省,新乡市', '113.883991', '35.302616', 'Xinxiang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('410800', '焦作市', '410000', '焦作', '2', '454002', '中国,河南省,焦作市', '113.238266', '35.23904', 'Jiaozuo', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('410900', '濮阳市', '410000', '濮阳', '2', '457000', '中国,河南省,濮阳市', '115.041299', '35.768234', 'Puyang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('411000', '许昌市', '410000', '许昌', '2', '461000', '中国,河南省,许昌市', '113.826063', '34.022956', 'Xuchang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('411100', '漯河市', '410000', '漯河', '2', '462000', '中国,河南省,漯河市', '114.026405', '33.575855', 'Luohe', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('411200', '三门峡市', '410000', '三门峡', '2', '472000', '中国,河南省,三门峡市', '111.194099', '34.777338', 'Sanmenxia', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('411300', '南阳市', '410000', '南阳', '2', '473002', '中国,河南省,南阳市', '112.540918', '32.999082', 'Nanyang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('411400', '商丘市', '410000', '商丘', '2', '476000', '中国,河南省,商丘市', '115.650497', '34.437054', 'Shangqiu', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('411500', '信阳市', '410000', '信阳', '2', '464000', '中国,河南省,信阳市', '114.075031', '32.123274', 'Xinyang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('411600', '周口市', '410000', '周口', '2', '466000', '中国,河南省,周口市', '114.649653', '33.620357', 'Zhoukou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('411700', '驻马店市', '410000', '驻马店', '2', '463000', '中国,河南省,驻马店市', '114.024736', '32.980169', 'Zhumadian', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('419000', '直辖县级', '410000', ' ', '2', NULL, '中国,河南省,直辖县级', '113.665412', '34.757975', '', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('420000', '湖北省', '100000', '湖北', '1', NULL, '中国,湖北省', '114.298572', '30.584355', 'Hubei', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('420100', '武汉市', '420000', '武汉', '2', '430014', '中国,湖北省,武汉市', '114.298572', '30.584355', 'Wuhan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('420200', '黄石市', '420000', '黄石', '2', '435003', '中国,湖北省,黄石市', '115.077048', '30.220074', 'Huangshi', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('420300', '十堰市', '420000', '十堰', '2', '442000', '中国,湖北省,十堰市', '110.785239', '32.647017', 'Shiyan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('420500', '宜昌市', '420000', '宜昌', '2', '443000', '中国,湖北省,宜昌市', '111.290843', '30.702636', 'Yichang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('420600', '襄阳市', '420000', '襄阳', '2', '441021', '中国,湖北省,襄阳市', '112.144146', '32.042426', 'Xiangyang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('420700', '鄂州市', '420000', '鄂州', '2', '436000', '中国,湖北省,鄂州市', '114.890593', '30.396536', 'Ezhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('420800', '荆门市', '420000', '荆门', '2', '448000', '中国,湖北省,荆门市', '112.204251', '31.03542', 'Jingmen', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('420900', '孝感市', '420000', '孝感', '2', '432100', '中国,湖北省,孝感市', '113.926655', '30.926423', 'Xiaogan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('421000', '荆州市', '420000', '荆州', '2', '434000', '中国,湖北省,荆州市', '112.23813', '30.326857', 'Jingzhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('421100', '黄冈市', '420000', '黄冈', '2', '438000', '中国,湖北省,黄冈市', '114.879365', '30.447711', 'Huanggang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('421200', '咸宁市', '420000', '咸宁', '2', '437000', '中国,湖北省,咸宁市', '114.328963', '29.832798', 'Xianning', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('421300', '随州市', '420000', '随州', '2', '441300', '中国,湖北省,随州市', '113.37377', '31.717497', 'Suizhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('422800', '恩施土家族苗族自治州', '420000', '恩施', '2', '445000', '中国,湖北省,恩施土家族苗族自治州', '109.48699', '30.283114', 'Enshi', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('429000', '直辖县级', '420000', ' ', '2', NULL, '中国,湖北省,直辖县级', '114.298572', '30.584355', '', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('430000', '湖南省', '100000', '湖南', '1', NULL, '中国,湖南省', '112.982279', '28.19409', 'Hunan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('430100', '长沙市', '430000', '长沙', '2', '410005', '中国,湖南省,长沙市', '112.982279', '28.19409', 'Changsha', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('430200', '株洲市', '430000', '株洲', '2', '412000', '中国,湖南省,株洲市', '113.151737', '27.835806', 'Zhuzhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('430300', '湘潭市', '430000', '湘潭', '2', '411100', '中国,湖南省,湘潭市', '112.925083', '27.846725', 'Xiangtan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('430400', '衡阳市', '430000', '衡阳', '2', '421001', '中国,湖南省,衡阳市', '112.607693', '26.900358', 'Hengyang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('430500', '邵阳市', '430000', '邵阳', '2', '422000', '中国,湖南省,邵阳市', '111.46923', '27.237842', 'Shaoyang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('430600', '岳阳市', '430000', '岳阳', '2', '414000', '中国,湖南省,岳阳市', '113.132855', '29.37029', 'Yueyang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('430700', '常德市', '430000', '常德', '2', '415000', '中国,湖南省,常德市', '111.691347', '29.040225', 'Changde', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('430800', '张家界市', '430000', '张家界', '2', '427000', '中国,湖南省,张家界市', '110.479921', '29.127401', 'Zhangjiajie', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('430900', '益阳市', '430000', '益阳', '2', '413000', '中国,湖南省,益阳市', '112.355042', '28.570066', 'Yiyang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('431000', '郴州市', '430000', '郴州', '2', '423000', '中国,湖南省,郴州市', '113.032067', '25.793589', 'Chenzhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('431100', '永州市', '430000', '永州', '2', '425000', '中国,湖南省,永州市', '111.608019', '26.434516', 'Yongzhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('431200', '怀化市', '430000', '怀化', '2', '418000', '中国,湖南省,怀化市', '109.97824', '27.550082', 'Huaihua', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('431300', '娄底市', '430000', '娄底', '2', '417000', '中国,湖南省,娄底市', '112.008497', '27.728136', 'Loudi', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('433100', '湘西土家族苗族自治州', '430000', '湘西', '2', '416000', '中国,湖南省,湘西土家族苗族自治州', '109.739735', '28.314296', 'Xiangxi', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('440000', '广东省', '100000', '广东', '1', NULL, '中国,广东省', '113.280637', '23.125178', 'Guangdong', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('440100', '广州市', '440000', '广州', '2', '510032', '中国,广东省,广州市', '113.280637', '23.125178', 'Guangzhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('440200', '韶关市', '440000', '韶关', '2', '512002', '中国,广东省,韶关市', '113.591544', '24.801322', 'Shaoguan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('440300', '深圳市', '440000', '深圳', '2', '518035', '中国,广东省,深圳市', '114.085947', '22.547', 'Shenzhen', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('440400', '珠海市', '440000', '珠海', '2', '519000', '中国,广东省,珠海市', '113.552724', '22.255899', 'Zhuhai', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('440500', '汕头市', '440000', '汕头', '2', '515041', '中国,广东省,汕头市', '116.708463', '23.37102', 'Shantou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('440600', '佛山市', '440000', '佛山', '2', '528000', '中国,广东省,佛山市', '113.122717', '23.028762', 'Foshan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('440700', '江门市', '440000', '江门', '2', '529000', '中国,广东省,江门市', '113.094942', '22.590431', 'Jiangmen', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('440800', '湛江市', '440000', '湛江', '2', '524047', '中国,广东省,湛江市', '110.405529', '21.195338', 'Zhanjiang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('440900', '茂名市', '440000', '茂名', '2', '525000', '中国,广东省,茂名市', '110.919229', '21.659751', 'Maoming', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('441200', '肇庆市', '440000', '肇庆', '2', '526040', '中国,广东省,肇庆市', '112.472529', '23.051546', 'Zhaoqing', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('441300', '惠州市', '440000', '惠州', '2', '516000', '中国,广东省,惠州市', '114.412599', '23.079404', 'Huizhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('441400', '梅州市', '440000', '梅州', '2', '514021', '中国,广东省,梅州市', '116.117582', '24.299112', 'Meizhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('441500', '汕尾市', '440000', '汕尾', '2', '516600', '中国,广东省,汕尾市', '115.364238', '22.774485', 'Shanwei', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('441600', '河源市', '440000', '河源', '2', '517000', '中国,广东省,河源市', '114.697802', '23.746266', 'Heyuan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('441700', '阳江市', '440000', '阳江', '2', '529500', '中国,广东省,阳江市', '111.975107', '21.859222', 'Yangjiang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('441800', '清远市', '440000', '清远', '2', '511500', '中国,广东省,清远市', '113.036779', '23.704188', 'Qingyuan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('441900', '东莞市', '440000', '东莞', '2', '523888', '中国,广东省,东莞市', '113.760234', '23.048884', 'Dongguan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('442000', '中山市', '440000', '中山', '2', '528403', '中国,广东省,中山市', '113.382391', '22.521113', 'Zhongshan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('445100', '潮州市', '440000', '潮州', '2', '521000', '中国,广东省,潮州市', '116.632301', '23.661701', 'Chaozhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('445200', '揭阳市', '440000', '揭阳', '2', '522000', '中国,广东省,揭阳市', '116.355733', '23.543778', 'Jieyang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('445300', '云浮市', '440000', '云浮', '2', '527300', '中国,广东省,云浮市', '112.044439', '22.929801', 'Yunfu', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('450000', '广西壮族自治区', '100000', '广西', '1', NULL, '中国,广西壮族自治区', '108.320004', '22.82402', 'Guangxi', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('450100', '南宁市', '450000', '南宁', '2', '530028', '中国,广西壮族自治区,南宁市', '108.320004', '22.82402', 'Nanning', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('450200', '柳州市', '450000', '柳州', '2', '545001', '中国,广西壮族自治区,柳州市', '109.411703', '24.314617', 'Liuzhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('450300', '桂林市', '450000', '桂林', '2', '541100', '中国,广西壮族自治区,桂林市', '110.299121', '25.274215', 'Guilin', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('450400', '梧州市', '450000', '梧州', '2', '543002', '中国,广西壮族自治区,梧州市', '111.316229', '23.472309', 'Wuzhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('450500', '北海市', '450000', '北海', '2', '536000', '中国,广西壮族自治区,北海市', '109.119254', '21.473343', 'Beihai', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('450600', '防城港市', '450000', '防城港', '2', '538001', '中国,广西壮族自治区,防城港市', '108.345478', '21.614631', 'Fangchenggang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('450700', '钦州市', '450000', '钦州', '2', '535099', '中国,广西壮族自治区,钦州市', '108.624175', '21.967127', 'Qinzhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('450800', '贵港市', '450000', '贵港', '2', '537100', '中国,广西壮族自治区,贵港市', '109.602146', '23.0936', 'Guigang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('450900', '玉林市', '450000', '玉林', '2', '537000', '中国,广西壮族自治区,玉林市', '110.154393', '22.63136', 'Yulin', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('451000', '百色市', '450000', '百色', '2', '533000', '中国,广西壮族自治区,百色市', '106.616285', '23.897742', 'Baise', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('451100', '贺州市', '450000', '贺州', '2', '542800', '中国,广西壮族自治区,贺州市', '111.552056', '24.414141', 'Hezhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('451200', '河池市', '450000', '河池', '2', '547000', '中国,广西壮族自治区,河池市', '108.062105', '24.695899', 'Hechi', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('451300', '来宾市', '450000', '来宾', '2', '546100', '中国,广西壮族自治区,来宾市', '109.229772', '23.733766', 'Laibin', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('451400', '崇左市', '450000', '崇左', '2', '532299', '中国,广西壮族自治区,崇左市', '107.353926', '22.404108', 'Chongzuo', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('460000', '海南省', '100000', '海南', '1', NULL, '中国,海南省', '110.33119', '20.031971', 'Hainan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('460100', '海口市', '460000', '海口', '2', '570000', '中国,海南省,海口市', '110.33119', '20.031971', 'Haikou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('460200', '三亚市', '460000', '三亚', '2', '572000', '中国,海南省,三亚市', '109.508268', '18.247872', 'Sanya', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('460300', '三沙市', '460000', '三沙', '2', '573199', '中国,海南省,三沙市', '112.34882', '16.831039', 'Sansha', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('469000', '直辖县级', '460000', ' ', '2', NULL, '中国,海南省,直辖县级', '109.503479', '18.739906', '', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('500000', '重庆', '100000', '重庆', '1', NULL, '中国,重庆', '106.504962', '29.533155', 'Chongqing', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('500100', '重庆市', '500000', '重庆', '2', NULL, '中国,重庆,重庆市', '106.504962', '29.533155', 'Chongqing', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('500300', '两江新区', '500000', '两江新区', '2', '400000', '中国,重庆,两江新区', '106.463344', '29.729153', 'liangjiangxinqu', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('510000', '四川省', '100000', '四川', '1', NULL, '中国,四川省', '104.065735', '30.659462', 'Sichuan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('510100', '成都市', '510000', '成都', '2', '610015', '中国,四川省,成都市', '104.065735', '30.659462', 'Chengdu', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('510300', '自贡市', '510000', '自贡', '2', '643000', '中国,四川省,自贡市', '104.773447', '29.352765', 'Zigong', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('510400', '攀枝花市', '510000', '攀枝花', '2', '617000', '中国,四川省,攀枝花市', '101.716007', '26.580446', 'Panzhihua', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('510500', '泸州市', '510000', '泸州', '2', '646000', '中国,四川省,泸州市', '105.443348', '28.889138', 'Luzhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('510600', '德阳市', '510000', '德阳', '2', '618000', '中国,四川省,德阳市', '104.398651', '31.127991', 'Deyang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('510700', '绵阳市', '510000', '绵阳', '2', '621000', '中国,四川省,绵阳市', '104.741722', '31.46402', 'Mianyang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('510800', '广元市', '510000', '广元', '2', '628000', '中国,四川省,广元市', '105.829757', '32.433668', 'Guangyuan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('510900', '遂宁市', '510000', '遂宁', '2', '629000', '中国,四川省,遂宁市', '105.571331', '30.513311', 'Suining', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('511000', '内江市', '510000', '内江', '2', '641000', '中国,四川省,内江市', '105.066138', '29.58708', 'Neijiang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('511100', '乐山市', '510000', '乐山', '2', '614000', '中国,四川省,乐山市', '103.761263', '29.582024', 'Leshan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('511300', '南充市', '510000', '南充', '2', '637000', '中国,四川省,南充市', '106.082974', '30.795281', 'Nanchong', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('511400', '眉山市', '510000', '眉山', '2', '620020', '中国,四川省,眉山市', '103.831788', '30.048318', 'Meishan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('511500', '宜宾市', '510000', '宜宾', '2', '644000', '中国,四川省,宜宾市', '104.630825', '28.760189', 'Yibin', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('511600', '广安市', '510000', '广安', '2', '638000', '中国,四川省,广安市', '106.633369', '30.456398', 'Guang\'an', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('511700', '达州市', '510000', '达州', '2', '635000', '中国,四川省,达州市', '107.502262', '31.209484', 'Dazhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('511800', '雅安市', '510000', '雅安', '2', '625000', '中国,四川省,雅安市', '103.001033', '29.987722', 'Ya\'an', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('511900', '巴中市', '510000', '巴中', '2', '636000', '中国,四川省,巴中市', '106.753669', '31.858809', 'Bazhong', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('512000', '资阳市', '510000', '资阳', '2', '641300', '中国,四川省,资阳市', '104.641917', '30.122211', 'Ziyang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('513200', '阿坝藏族羌族自治州', '510000', '阿坝', '2', '624000', '中国,四川省,阿坝藏族羌族自治州', '102.221374', '31.899792', 'Aba', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('513300', '甘孜藏族自治州', '510000', '甘孜', '2', '626000', '中国,四川省,甘孜藏族自治州', '101.963815', '30.050663', 'Garze', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('513400', '凉山彝族自治州', '510000', '凉山', '2', '615000', '中国,四川省,凉山彝族自治州', '102.258746', '27.886762', 'Liangshan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('520000', '贵州省', '100000', '贵州', '1', NULL, '中国,贵州省', '106.713478', '26.578343', 'Guizhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('520100', '贵阳市', '520000', '贵阳', '2', '550001', '中国,贵州省,贵阳市', '106.713478', '26.578343', 'Guiyang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('520200', '六盘水市', '520000', '六盘水', '2', '553400', '中国,贵州省,六盘水市', '104.846743', '26.584643', 'Liupanshui', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('520300', '遵义市', '520000', '遵义', '2', '563000', '中国,贵州省,遵义市', '106.937265', '27.706626', 'Zunyi', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('520400', '安顺市', '520000', '安顺', '2', '561000', '中国,贵州省,安顺市', '105.932188', '26.245544', 'Anshun', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('520500', '毕节市', '520000', '毕节', '2', '551700', '中国,贵州省,毕节市', '105.28501', '27.301693', 'Bijie', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('520600', '铜仁市', '520000', '铜仁', '2', '554300', '中国,贵州省,铜仁市', '109.191555', '27.718346', 'Tongren', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('522300', '黔西南布依族苗族自治州', '520000', '黔西南', '2', '562400', '中国,贵州省,黔西南布依族苗族自治州', '104.897971', '25.08812', 'Qianxinan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('522600', '黔东南苗族侗族自治州', '520000', '黔东南', '2', '556000', '中国,贵州省,黔东南苗族侗族自治州', '107.977488', '26.583352', 'Qiandongnan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('522700', '黔南布依族苗族自治州', '520000', '黔南', '2', '558000', '中国,贵州省,黔南布依族苗族自治州', '107.517156', '26.258219', 'Qiannan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('530000', '云南省', '100000', '云南', '1', NULL, '中国,云南省', '102.712251', '25.040609', 'Yunnan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('530100', '昆明市', '530000', '昆明', '2', '650500', '中国,云南省,昆明市', '102.712251', '25.040609', 'Kunming', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('530300', '曲靖市', '530000', '曲靖', '2', '655000', '中国,云南省,曲靖市', '103.797851', '25.501557', 'Qujing', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('530400', '玉溪市', '530000', '玉溪', '2', '653100', '中国,云南省,玉溪市', '102.543907', '24.350461', 'Yuxi', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('530500', '保山市', '530000', '保山', '2', '678000', '中国,云南省,保山市', '99.167133', '25.111802', 'Baoshan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('530600', '昭通市', '530000', '昭通', '2', '657000', '中国,云南省,昭通市', '103.717216', '27.336999', 'Zhaotong', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('530700', '丽江市', '530000', '丽江', '2', '674100', '中国,云南省,丽江市', '100.233026', '26.872108', 'Lijiang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('530800', '普洱市', '530000', '普洱', '2', '665000', '中国,云南省,普洱市', '100.972344', '22.777321', 'Pu\'er', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('530900', '临沧市', '530000', '临沧', '2', '677000', '中国,云南省,临沧市', '100.08697', '23.886567', 'Lincang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('532300', '楚雄彝族自治州', '530000', '楚雄', '2', '675000', '中国,云南省,楚雄彝族自治州', '101.546046', '25.041988', 'Chuxiong', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('532500', '红河哈尼族彝族自治州', '530000', '红河', '2', '661400', '中国,云南省,红河哈尼族彝族自治州', '103.384182', '23.366775', 'Honghe', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('532600', '文山壮族苗族自治州', '530000', '文山', '2', '663000', '中国,云南省,文山壮族苗族自治州', '104.24401', '23.36951', 'Wenshan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('532800', '西双版纳傣族自治州', '530000', '西双版纳', '2', '666100', '中国,云南省,西双版纳傣族自治州', '100.797941', '22.001724', 'Xishuangbanna', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('532900', '大理白族自治州', '530000', '大理', '2', '671000', '中国,云南省,大理白族自治州', '100.240037', '25.592765', 'Dali', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('533100', '德宏傣族景颇族自治州', '530000', '德宏', '2', '678400', '中国,云南省,德宏傣族景颇族自治州', '98.578363', '24.436694', 'Dehong', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('533300', '怒江傈僳族自治州', '530000', '怒江', '2', '673100', '中国,云南省,怒江傈僳族自治州', '98.854304', '25.850949', 'Nujiang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('533400', '迪庆藏族自治州', '530000', '迪庆', '2', '674400', '中国,云南省,迪庆藏族自治州', '99.706463', '27.826853', 'Deqen', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('540000', '西藏自治区', '100000', '西藏', '1', NULL, '中国,西藏自治区', '91.132212', '29.660361', 'Tibet', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('540100', '拉萨市', '540000', '拉萨', '2', '850000', '中国,西藏自治区,拉萨市', '91.132212', '29.660361', 'Lhasa', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('540200', '日喀则市', '540000', '日喀则', '2', '857000', '中国,西藏自治区,日喀则市', '88.884874', '29.263792', 'rikaze', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('540300', '昌都市', '540000', '昌都', '2', '854000', '中国,西藏自治区,昌都市', '97.178452', '31.136875', 'Qamdo', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('542200', '山南地区', '540000', '山南', '2', '856000', '中国,西藏自治区,山南地区', '91.766529', '29.236023', 'Shannan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('542400', '那曲地区', '540000', '那曲', '2', '852000', '中国,西藏自治区,那曲地区', '92.060214', '31.476004', 'Nagqu', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('542500', '阿里地区', '540000', '阿里', '2', '859000', '中国,西藏自治区,阿里地区', '80.105498', '32.503187', 'Ngari', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('542600', '林芝地区', '540000', '林芝', '2', '850400', '中国,西藏自治区,林芝地区', '94.362348', '29.654693', 'Nyingchi', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('610000', '陕西省', '100000', '陕西', '1', NULL, '中国,陕西省', '108.948024', '34.263161', 'Shaanxi', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('610100', '西安市', '610000', '西安', '2', '710003', '中国,陕西省,西安市', '108.948024', '34.263161', 'Xi\'an', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('610200', '铜川市', '610000', '铜川', '2', '727100', '中国,陕西省,铜川市', '108.963122', '34.90892', 'Tongchuan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('610300', '宝鸡市', '610000', '宝鸡', '2', '721000', '中国,陕西省,宝鸡市', '107.14487', '34.369315', 'Baoji', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('610400', '咸阳市', '610000', '咸阳', '2', '712000', '中国,陕西省,咸阳市', '108.705117', '34.333439', 'Xianyang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('610500', '渭南市', '610000', '渭南', '2', '714000', '中国,陕西省,渭南市', '109.502882', '34.499381', 'Weinan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('610600', '延安市', '610000', '延安', '2', '716000', '中国,陕西省,延安市', '109.49081', '36.596537', 'Yan\'an', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('610700', '汉中市', '610000', '汉中', '2', '723000', '中国,陕西省,汉中市', '107.028621', '33.077668', 'Hanzhong', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('610800', '榆林市', '610000', '榆林', '2', '719000', '中国,陕西省,榆林市', '109.741193', '38.290162', 'Yulin', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('610900', '安康市', '610000', '安康', '2', '725000', '中国,陕西省,安康市', '109.029273', '32.6903', 'Ankang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('611000', '商洛市', '610000', '商洛', '2', '726000', '中国,陕西省,商洛市', '109.939776', '33.868319', 'Shangluo', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('611100', '西咸新区', '610000', '西咸', '2', '712000', '中国,陕西省,西咸新区', '108.810654', '34.307144', 'xixian', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('620000', '甘肃省', '100000', '甘肃', '1', NULL, '中国,甘肃省', '103.823557', '36.058039', 'Gansu', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('620100', '兰州市', '620000', '兰州', '2', '730030', '中国,甘肃省,兰州市', '103.823557', '36.058039', 'Lanzhou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('620200', '嘉峪关市', '620000', '嘉峪关', '2', '735100', '中国,甘肃省,嘉峪关市', '98.277304', '39.786529', 'Jiayuguan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('620300', '金昌市', '620000', '金昌', '2', '737100', '中国,甘肃省,金昌市', '102.187888', '38.514238', 'Jinchang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('620400', '白银市', '620000', '白银', '2', '730900', '中国,甘肃省,白银市', '104.173606', '36.54568', 'Baiyin', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('620500', '天水市', '620000', '天水', '2', '741000', '中国,甘肃省,天水市', '105.724998', '34.578529', 'Tianshui', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('620600', '武威市', '620000', '武威', '2', '733000', '中国,甘肃省,武威市', '102.634697', '37.929996', 'Wuwei', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('620700', '张掖市', '620000', '张掖', '2', '734000', '中国,甘肃省,张掖市', '100.455472', '38.932897', 'Zhangye', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('620800', '平凉市', '620000', '平凉', '2', '744000', '中国,甘肃省,平凉市', '106.684691', '35.54279', 'Pingliang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('620900', '酒泉市', '620000', '酒泉', '2', '735000', '中国,甘肃省,酒泉市', '98.510795', '39.744023', 'Jiuquan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('621000', '庆阳市', '620000', '庆阳', '2', '745000', '中国,甘肃省,庆阳市', '107.638372', '35.734218', 'Qingyang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('621100', '定西市', '620000', '定西', '2', '743000', '中国,甘肃省,定西市', '104.626294', '35.579578', 'Dingxi', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('621200', '陇南市', '620000', '陇南', '2', '746000', '中国,甘肃省,陇南市', '104.929379', '33.388598', 'Longnan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('622900', '临夏回族自治州', '620000', '临夏', '2', '731100', '中国,甘肃省,临夏回族自治州', '103.212006', '35.599446', 'Linxia', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('623000', '甘南藏族自治州', '620000', '甘南', '2', '747000', '中国,甘肃省,甘南藏族自治州', '102.911008', '34.986354', 'Gannan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('630000', '青海省', '100000', '青海', '1', NULL, '中国,青海省', '101.778916', '36.623178', 'Qinghai', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('630100', '西宁市', '630000', '西宁', '2', '810000', '中国,青海省,西宁市', '101.778916', '36.623178', 'Xining', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('630200', '海东市', '630000', '海东', '2', '810700', '中国,青海省,海东市', '102.10327', '36.502916', 'haidong', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('632200', '海北藏族自治州', '630000', '海北', '2', '812200', '中国,青海省,海北藏族自治州', '100.901059', '36.959435', 'Haibei', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('632300', '黄南藏族自治州', '630000', '黄南', '2', '811300', '中国,青海省,黄南藏族自治州', '102.019988', '35.517744', 'Huangnan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('632500', '海南藏族自治州', '630000', '海南', '2', '813000', '中国,青海省,海南藏族自治州', '100.619542', '36.280353', 'Hainan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('632600', '果洛藏族自治州', '630000', '果洛', '2', '814000', '中国,青海省,果洛藏族自治州', '100.242143', '34.4736', 'Golog', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('632700', '玉树藏族自治州', '630000', '玉树', '2', '815000', '中国,青海省,玉树藏族自治州', '97.008522', '33.004049', 'Yushu', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('632800', '海西蒙古族藏族自治州', '630000', '海西', '2', '817000', '中国,青海省,海西蒙古族藏族自治州', '97.370785', '37.374663', 'Haixi', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('640000', '宁夏回族自治区', '100000', '宁夏', '1', NULL, '中国,宁夏回族自治区', '106.278179', '38.46637', 'Ningxia', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('640100', '银川市', '640000', '银川', '2', '750004', '中国,宁夏回族自治区,银川市', '106.278179', '38.46637', 'Yinchuan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('640200', '石嘴山市', '640000', '石嘴山', '2', '753000', '中国,宁夏回族自治区,石嘴山市', '106.376173', '39.01333', 'Shizuishan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('640300', '吴忠市', '640000', '吴忠', '2', '751100', '中国,宁夏回族自治区,吴忠市', '106.199409', '37.986165', 'Wuzhong', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('640400', '固原市', '640000', '固原', '2', '756000', '中国,宁夏回族自治区,固原市', '106.285241', '36.004561', 'Guyuan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('640500', '中卫市', '640000', '中卫', '2', '751700', '中国,宁夏回族自治区,中卫市', '105.189568', '37.514951', 'Zhongwei', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('650000', '新疆维吾尔自治区', '100000', '新疆', '1', NULL, '中国,新疆维吾尔自治区', '87.617733', '43.792818', 'Xinjiang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('650100', '乌鲁木齐市', '650000', '乌鲁木齐', '2', '830002', '中国,新疆维吾尔自治区,乌鲁木齐市', '87.617733', '43.792818', 'Urumqi', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('650200', '克拉玛依市', '650000', '克拉玛依', '2', '834000', '中国,新疆维吾尔自治区,克拉玛依市', '84.873946', '45.595886', 'Karamay', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('652100', '吐鲁番地区', '650000', '吐鲁番', '2', '838000', '中国,新疆维吾尔自治区,吐鲁番地区', '89.184078', '42.947613', 'Turpan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('652200', '哈密地区', '650000', '哈密', '2', '839000', '中国,新疆维吾尔自治区,哈密地区', '93.51316', '42.833248', 'Hami', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('652300', '昌吉回族自治州', '650000', '昌吉', '2', '831100', '中国,新疆维吾尔自治区,昌吉回族自治州', '87.304012', '44.014577', 'Changji', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('652700', '博尔塔拉蒙古自治州', '650000', '博尔塔拉', '2', '833400', '中国,新疆维吾尔自治区,博尔塔拉蒙古自治州', '82.074778', '44.903258', 'Bortala', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('652800', '巴音郭楞蒙古自治州', '650000', '巴音郭楞', '2', '841000', '中国,新疆维吾尔自治区,巴音郭楞蒙古自治州', '86.150969', '41.768552', 'Bayingol', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('652900', '阿克苏地区', '650000', '阿克苏', '2', '843000', '中国,新疆维吾尔自治区,阿克苏地区', '80.265068', '41.170712', 'Aksu', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('653000', '克孜勒苏柯尔克孜自治州', '650000', '克孜勒苏', '2', '845350', '中国,新疆维吾尔自治区,克孜勒苏柯尔克孜自治州', '76.172825', '39.713431', 'Kizilsu', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('653100', '喀什地区', '650000', '喀什', '2', '844000', '中国,新疆维吾尔自治区,喀什地区', '75.989138', '39.467664', 'Kashgar', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('653200', '和田地区', '650000', '和田', '2', '848000', '中国,新疆维吾尔自治区,和田地区', '79.92533', '37.110687', 'Hotan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('654000', '伊犁哈萨克自治州', '650000', '伊犁', '2', '835100', '中国,新疆维吾尔自治区,伊犁哈萨克自治州', '81.317946', '43.92186', 'Ili', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('654200', '塔城地区', '650000', '塔城', '2', '834700', '中国,新疆维吾尔自治区,塔城地区', '82.985732', '46.746301', 'Qoqek', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('654300', '阿勒泰地区', '650000', '阿勒泰', '2', '836500', '中国,新疆维吾尔自治区,阿勒泰地区', '88.13963', '47.848393', 'Altay', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('659000', '直辖县级', '650000', ' ', '2', NULL, '中国,新疆维吾尔自治区,直辖县级', '91.132212', '29.660361', '', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('710000', '台湾', '100000', '台湾', '1', NULL, '中国,台湾', '121.509062', '25.044332', 'Taiwan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('710100', '台北市', '710000', '台北', '2', '1', '中国,台湾,台北市', '121.56517', '25.037798', 'Taipei', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('710200', '高雄市', '710000', '高雄', '2', '8', '中国,台湾,高雄市', '120.311922', '22.620856', 'Kaohsiung', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('710300', '基隆市', '710000', '基隆', '2', '2', '中国,台湾,基隆市', '121.746248', '25.130741', 'Keelung', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('710400', '台中市', '710000', '台中', '2', '4', '中国,台湾,台中市', '120.67904', '24.13862', 'Taichung', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('710500', '台南市', '710000', '台南', '2', '7', '中国,台湾,台南市', '120.279363', '23.172478', 'Tainan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('710600', '新竹市', '710000', '新竹', '2', '3', '中国,台湾,新竹市', '120.968798', '24.806738', 'Hsinchu', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('710700', '嘉义市', '710000', '嘉义', '2', '6', '中国,台湾,嘉义市', '120.452538', '23.481568', 'Chiayi', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('710800', '新北市', '710000', '新北', '2', '2', '中国,台湾,新北市', '121.465746', '25.012366', 'New Taipei', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('712200', '宜兰县', '710000', '宜兰', '2', '2', '中国,台湾,宜兰县', '121.5', '24.6', 'Yilan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('712300', '桃园县', '710000', '桃园', '2', '3', '中国,台湾,桃园县', '121.083', '25', 'Taoyuan', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('712400', '新竹县', '710000', '新竹', '2', '3', '中国,台湾,新竹县', '121.16', '24.6', 'Hsinchu', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('712500', '苗栗县', '710000', '苗栗', '2', '3', '中国,台湾,苗栗县', '120.75', '24.5', 'Miaoli', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('712700', '彰化县', '710000', '彰化', '2', '5', '中国,台湾,彰化县', '120.416', '24', 'Changhua', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('712800', '南投县', '710000', '南投', '2', '5', '中国,台湾,南投县', '120.83', '23.83', 'Nantou', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('712900', '云林县', '710000', '云林', '2', '6', '中国,台湾,云林县', '120.25', '23.75', 'Yunlin', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('713000', '嘉义县', '710000', '嘉义', '2', '6', '中国,台湾,嘉义县', '120.3', '23.5', 'Chiayi', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('713300', '屏东县', '710000', '屏东', '2', '9', '中国,台湾,屏东县', '120.487928', '22.682802', 'Pingtung', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('713400', '台东县', '710000', '台东', '2', '9', '中国,台湾,台东县', '120.916', '23', 'Taitung', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('713500', '花莲县', '710000', '花莲', '2', '9', '中国,台湾,花莲县', '121.3', '23.83', 'Hualien', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('713600', '澎湖县', '710000', '澎湖', '2', '8', '中国,台湾,澎湖县', '119.566417', '23.569733', 'Penghu', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('713700', '金门县', '710000', '金门', '2', '8', '中国,台湾,金门县', '118.317089', '24.432706', 'jinmen', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('713800', '连江县', '710000', '连江', '2', '2', '中国,台湾,连江县', '119.539704', '26.197364', 'Lienchiang', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('810000', '香港特别行政区', '100000', '香港', '1', NULL, '中国,香港特别行政区', '114.173355', '22.320048', 'Hong Kong', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('810100', '香港岛', '810000', '香港岛', '2', '999077', '中国,香港特别行政区,香港岛', '114.177314', '22.266416', 'Hong Kong Island', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('810200', '九龙', '810000', '九龙', '2', '999077', '中国,香港特别行政区,九龙', '114.17495', '22.327115', 'Kowloon', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('810300', '新界', '810000', '新界', '2', '999077', '中国,香港特别行政区,新界', '114.202408', '22.341766', 'New Territories', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('820000', '澳门特别行政区', '100000', '澳门', '1', NULL, '中国,澳门特别行政区', '113.54909', '22.198951', 'Macau', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('820100', '澳门半岛', '820000', '澳门半岛', '2', '999078', '中国,澳门特别行政区,澳门半岛', '113.549134', '22.198751', 'MacauPeninsula', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('820200', '氹仔岛', '820000', '氹仔岛', '2', '999078', '中国,澳门特别行政区,氹仔岛', '113.577669', '22.156838', 'Taipa', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('820300', '路环岛', '820000', '路环岛', '2', '999078', '中国,澳门特别行政区,路环岛', '113.564857', '22.116226', 'Coloane', NULL);
INSERT INTO `bore`.`address` (`address_id`, `name`, `parent_address_id`, `short_name`, `address_level`, `zip_code`, `merger_name`, `lng`, `lat`, `pinyin`, `sort_flag`) VALUES ('900000', '钓鱼岛', '100000', '钓鱼岛', '1', NULL, '中国,钓鱼岛', '123.478088', '25.742385', 'DiaoyuDao', NULL);

-- 2021/11/29
INSERT INTO `bore`.`sys_config`(`module`, `key`, `value`, `desc`, `user_id`, `app_version`, `channel`, `client`, `priority`, `create_time`) VALUES ('sys', 'notify_fee', '298', '触发通知管理员短信事件的订单金额阀值', NULL, NULL, NULL, NULL, 0, now());

-- 2022/02/14
ALTER TABLE `bore`.`temple_activity`
ADD COLUMN `notice` varchar(128) NULL COMMENT '通告' AFTER `sort_flag`;

ALTER TABLE `bore`.`temple_activity`
MODIFY COLUMN `notice` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '通告' AFTER `sort_flag`;