1 Star 0 Fork 33

sue/district

forked from 腾勇/district 
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
文件
克隆/下载
CHANGES 31.33 KB
一键复制 编辑 原始数据 按行查看 历史
eduosi 提交于 2020-04-29 00:24 . 更新 2019 年区、县、市调整数据
Changes 18.0
28 Apr 2020
更新数据详见:
http://xzqh.mca.gov.cn/description?dcpid=2019
http://www.mca.gov.cn/article/sj/xzqh/2020/2020/202003061536.html
Changes 17.0
01 Sep 2019
更新数据详见:
http://xzqh.mca.gov.cn/description?dcpid=2016
http://xzqh.mca.gov.cn/description?dcpid=2017
http://xzqh.mca.gov.cn/description?dcpid=2018
Changes 16.0
25 Jan 2019
*) 纠正”长子“的拼音
*) 那曲地区改名那曲市
*) 那曲地区那曲县改名那曲市色尼区
*) 修改那曲市所属区县行政编码及其排序
更新脚本:
UPDATE `district` SET `initial` = 'z' ,`initials` = 'zz' ,`pinyin` = 'zhangzi' WHERE `id` = '739';
UPDATE `district` SET `suffix` = '市' ,`code` = '540600' WHERE `id` = '425';
UPDATE `district` SET `name` = '色尼' ,`initial` = 's' ,`initials` = 'sn' ,`pinyin` = 'seni' ,`suffix` = '区' ,`code` = '540602' ,`order` = '1' WHERE `id` = '2895';
UPDATE `district` SET `code` = '540621' ,`order` = '2' WHERE `id` = '2896';
UPDATE `district` SET `code` = '540622' ,`order` = '3' WHERE `id` = '2897';
UPDATE `district` SET `code` = '540623' ,`order` = '4' WHERE `id` = '2898';
UPDATE `district` SET `code` = '540624' ,`order` = '5' WHERE `id` = '2899';
UPDATE `district` SET `code` = '540625' ,`order` = '6' WHERE `id` = '2900';
UPDATE `district` SET `code` = '540626' ,`order` = '7' WHERE `id` = '2901';
UPDATE `district` SET `code` = '540627' ,`order` = '8' WHERE `id` = '2902';
UPDATE `district` SET `code` = '540628' ,`order` = '9' WHERE `id` = '2903';
UPDATE `district` SET `code` = '540629' ,`order` = '10' WHERE `id` = '2904';
UPDATE `district` SET `code` = '540630' ,`order` = '11' WHERE `id` = '2894';
Changes 15.0
24 Jan 2019
*) 纠正”长“的拼音
更新脚本:
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cn' ,`pinyin` = 'changning' WHERE `id` = '72';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cs', `pinyin` = 'changshou' WHERE `id` = '101';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cz' ,`pinyin` = 'changzhi' WHERE `id` = '139';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cc' ,`pinyin` = 'changchun' WHERE `id` = '173';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cs' ,`pinyin` = 'changsha' WHERE `id` = '307';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'ca' ,`pinyin` = 'changan' WHERE `id` = '533';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cz' ,`pinyin` = 'changzhi' WHERE `id` = '733';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cz' ,`pinyin` = 'changzi' WHERE `id` = '739';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'ch' ,`pinyin` = 'changhai' WHERE `id` = '944';
UPDATE `district` SET `initials` = 'gcl' ,`pinyin` = 'gongchangling' WHERE `id` = '997';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cb' ,`pinyin` = 'changbai' WHERE `id` = '1065';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cl' ,`pinyin` = 'changling' WHERE `id` = '1069';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cx' ,`pinyin` = 'changxing' WHERE `id` = '1362';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cf' ,`pinyin` = 'changfeng' WHERE `id` = '1411';
UPDATE `district` SET `initials` = 'tc' ,`pinyin` = 'tianchang' WHERE `id` = '1475';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cl' ,`pinyin` = 'changle' WHERE `id` = '1524';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'ct' ,`pinyin` = 'changtai' WHERE `id` = '1565';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'ct' ,`pinyin` = 'changting' WHERE `id` = '1582';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cq' ,`pinyin` = 'changqing' WHERE `id` = '1702';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cd' ,`pinyin` = 'changdao' WHERE `id` = '1740';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cy' ,`pinyin` = 'changyuan' WHERE `id` = '1905';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cg' ,`pinyin` = 'changge' WHERE `id` = '1929';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cy' ,`pinyin` = 'changyang' WHERE `id` = '2028';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cs' ,`pinyin` = 'changsha' WHERE `id` = '2097';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cz' ,`pinyin` = 'changzhou' WHERE `id` = '2375';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cn' ,`pinyin` = 'changning' WHERE `id` = '2546';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cs' ,`pinyin` = 'changshun' WHERE `id` = '2712';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'ca' ,`pinyin` = 'changan' WHERE `id` = '2927';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cw' ,`pinyin` = 'changwu' WHERE `id` = '2957';
UPDATE `district` SET `initials` = 'yc' ,`pinyin` = 'yanchang' WHERE `id` = '2974';
UPDATE `district` SET `initials` = 'zc' ,`pinyin` = 'zichang' WHERE `id` = '2976';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cc' ,`pinyin` = 'changcheng' WHERE `id` = '3035';
UPDATE `district` SET `initials` = 'yc' ,`pinyin` = 'yuanchang' WHERE `id` = '3487';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cz' ,`pinyin` = 'changzhi' WHERE `id` = '3514';
UPDATE `district` SET `initial` = 'c' ,`initials` = 'cb' ,`pinyin` = 'changbin' WHERE `id` = '3549';
Changes 14.0
22 Jan 2019
*) 山东莱芜整体并入济南
更新脚本:
UPDATE `district` SET `name` = '莱芜' WHERE `id` = '1786';
UPDATE `district` SET `parent_id` = '255', `initials` = 'lw', `pinyin` = 'laiwu' WHERE `id` = '1786';
UPDATE `district` SET `parent_id` = '255' WHERE `id` = '1787';
DELETE FROM `district` WHERE `id` = '266';
Changes 13.0
17 Dec 2018
*) 漠河县更改为漠河市和行政代码
*)纠正“蚌埠”拼音
更新脚本:
UPDATE `district` SET `suffix` = '市' ,`code` = '232701' WHERE `id` = '1216';
UPDATE `district` SET `pinyin` = 'bengbu' WHERE `id` = '221';
Changes 12.0
16 Oct 2018
*)济南市济阳县更名为济阳区
*)纠正吕梁拼音
*)福州市长乐县更新为长乐区,并更新行政代码
*)更新哈密市巴里坤哈萨克自治县行政代码
*)更新厦门市错误拼音
*)删除北京市宣武区、崇文区
更新脚本:
UPDATE `district` SET `suffix` = '区' WHERE `id` = '1704';
UPDATE `district` SET `pinyin` = 'lvliang' WHERE `id` = '146';
UPDATE `district` SET `suffix` = '区', `code` = 350112, `order` = 6 WHERE `id` = '1524';
UPDATE `district` SET `order` = '7' WHERE `id` = '1517';
UPDATE `district` SET `order` = '8' WHERE `id` = '1518';
UPDATE `district` SET `order` = '9' WHERE `id` = '1519';
UPDATE `district` SET `order` = '10' WHERE `id` = '1520';
UPDATE `district` SET `order` = '11' WHERE `id` = '1521';
UPDATE `district` SET `order` = '12' WHERE `id` = '1522';
UPDATE `district` SET `order` = '13' WHERE `id` = '1523';
UPDATE `district` SET `code` = '650521' WHERE `id` = '3198';
UPDATE `district` SET `initial` = 'x' ,`initials` = 'xm' ,`pinyin` = 'xiamen' WHERE `id` = '236';
DELETE FROM `district` WHERE `id` = '38';
DELETE FROM `district` WHERE `id` = '39';
Changes 11.0
*)纠正“都”拼音
Changes 10.0
01 Mar 2017
*) 更新若干城市数据
Changes 9.0
28 Apr 2015
*) 杭州市富阳市更名为杭州市富阳区
*) 更新杭州市下级行政区域排序
*) 西安市高陵县更名为西安市高陵区,行政代码更新为 610117
*) 更新西安市下级行政区域排序
*) 龙岩市永定县更名为龙岩市永定区,行政代码更新为 350803
*) 更新龙岩市下级行政区域排序,行政代码更新为 520403
*) 迪庆市香格里拉县更名为迪庆市香格里拉市
*) 南宁市武鸣县更名为南宁市武鸣区
*) 海东市平安县更名为海东市平安区
*) 更新海东市平乐都区行政代码为 630202
*) 三门峡市陕县更名为三门峡市陕州区
*) 更新三门峡市下级行政区域排序
*) 甘孜州康定县更名为甘孜州康定市,行政代码更新为 513301
*) 海南市县级市儋州市升级为地级市,行政代码更新为 460400
*) 吐鲁番地区更名为吐鲁番市
*) 吐鲁番地区吐鲁番市更名为吐鲁番市高昌区
*) 新疆维吾尔自治区设立直辖县级市可克达拉市
*) 林芝地区更名为林芝市
*) 林芝地区林芝市更名为林芝市巴宜区
*) 上饶市广丰县更名为上饶市广丰区
*) 更新上饶市下级行政区域排序
更新脚本:
UPDATE `district` SET `suffix` = '区' WHERE `id` = '1328';
UPDATE `district` SET `order` = '10' WHERE `id` = '1328';
UPDATE `district` SET `order` = '11' WHERE `id` = '1326';
UPDATE `district` SET `order` = '12' WHERE `id` = '1327';
UPDATE `district` SET `suffix` = '区', `code` = '610117' WHERE `id` = '2931';
UPDATE `district` SET `order` = '10' WHERE `id` = '2931';
UPDATE `district` SET `order` = '11' WHERE `id` = '2928';
UPDATE `district` SET `order` = '12' WHERE `id` = '2929';
UPDATE `district` SET `order` = '13' WHERE `id` = '2930';
UPDATE `district` SET `suffix` = '区', `code` = '350803' WHERE `id` = '1583';
UPDATE `district` SET `order` = '2' WHERE `id` = '1583';
UPDATE `district` SET `order` = '3' WHERE `id` = '1582';
UPDATE `district` SET `suffix` = '区', `code` = '520403' WHERE `id` = '2657';
UPDATE `district` SET `suffix` = '市' WHERE `id` = '2837';
UPDATE `district` SET `suffix` = '区' WHERE `id` = '2340';
UPDATE `district` SET `suffix` = '区' WHERE `id` = '3123';
UPDATE `district` SET `code` = '630202' WHERE `id` = '3122';
UPDATE `district` SET `name` = '陕州' ,`initials` = 'sz' ,`pinyin` = 'shanzhou' ,`suffix` = '区' WHERE `id` = '1937';
UPDATE `district` SET `order` = '3' WHERE `id` = '1936';
UPDATE `district` SET `order` = '2' WHERE `id` = '1937';
UPDATE `district` SET `suffix` = '市', `code` = '513301' WHERE `id` = '2593';
UPDATE `district` SET `code` = '460400' WHERE `id` = '361';
UPDATE `district` SET `suffix` = '市' WHERE `id` = '467';
UPDATE `district` SET `name` = '高昌' ,`initial` = 'g' ,`initials` = 'gc' ,`pinyin` = 'gaochang' ,`suffix` = '区' WHERE `id` = '3194';
INSERT INTO `district` (`name`, `parentid`, `initial`, `initials`, `pinyin`, `extra`, `suffix`, `code`, `area_code`, `order`) VALUES ('可克达拉', '31', 'k', 'kdkl', 'kedakela', '', '市', '659008', '0999', '22');
UPDATE `district` SET `suffix` = '市' ,`code` = '540400' WHERE `id` = '427';
UPDATE `district` SET `name` = '巴宜' ,`initial` = 'b' ,`initials` = 'by' ,`pinyin` = 'bayi' ,`code` = '540402' WHERE `id` = '2912';
UPDATE `district` SET `suffix` = '区' WHERE `id` = '1687';
UPDATE `district` SET `order` = '3' WHERE `id` = '1686';
UPDATE `district` SET `order` = '2' WHERE `id` = '1687';
Changes 8.0
13 Dec 2014
*) 撤销昌都地区,设立昌都市
*) 撤销原昌都地区昌都县,设立昌都市卡若区
*) 长春市九台市更名为九台区,行政代码更新为 220113
*) 更新长春市下级行政区域排序
*) 阳江市阳东县更名为阳东区
*) 眉山市彭山县更名为彭山区
*) 德州市陵县更名为陵城区,行政代码更新为 371403
*) 撤销石家庄市桥东区
*) 石家庄市藁城市更名为藁城县,更新行政代码为 130109
*) 石家庄市鹿泉市更名为鹿泉区,更新行政代码为 130110
*) 石家庄栾城县更名为栾城区,更新行政代码为 130111
*) 重排石家庄市下级行政区域顺序
*) 撤销开封市金明区
*) 重排开封市下级行政区域顺序
*) 更新云浮市云安区行政代码为 445302
*) 重排云浮市下级行政区域顺序
*) 十堰市郧县更名为郧阳区,行政代码更新为 420304
*) 重庆市璧山区行政代码更新为 500120
*) 重庆市铜梁区行政代码更新为 500151
*) 重排重庆市下级行政区域顺序
*) 南平市建阳区行政代码更新为 350703
*) 重排南平市下级行政区域顺序
*) 威海市文登区行政代码更新为 371003
*) 茂名市电白区行政代码更新为 440904
*) 广州市从化区行政代码更新为 440117
*) 广州市增城区行政代码更新为 440118
*) 重排广州市下级行政区域顺序
--- 以下感谢 @黄盛 同学纠正错误和提供信息
*) 修正福绵错误拼音和,增加行政代码
*) 吉林市蛟河市行政代码更新为 220281
*) 更新那曲地区双湖县行政代码为 542431
*) 更新嘉峪关市镜铁区行政代码为 620201
*) 更新白城市通榆县行政代码为 220822
*) 重排白城市下级行政区域排序
更新脚本:
UPDATE `district` SET `suffix` = '市' WHERE `id` = '422';
UPDATE `district` SET `name` = '卡若' , `initial` = 'k' , `initials` = 'kr' , `pinyin` = 'karuo' , `suffix` = '区' WHERE `id` = '2853';
UPDATE `district` SET `suffix` = '区' , `code` = '220113' , `order` = '7' WHERE `id` = '1032';
UPDATE `district` SET `order` = '8' WHERE `id` = '1031';
UPDATE `district` SET `suffix` = '区' WHERE `id` = '2311';
UPDATE `district` SET `suffix` = '区' WHERE `id` = '2538';
UPDATE `district` SET `name` = '陵城' , `initials` = 'lc' , `pinyin` = 'lingcheng' , `suffix` = '区' , `code` = '371403' WHERE `id` = '1801';
DELETE FROM `district` WHERE `id` = '534';
UPDATE `district` SET `suffix` = '区' , `code` = '130109' WHERE `id` = '552';
UPDATE `district` SET `suffix` = '区' , `code` = '130110' WHERE `id` = '555';
UPDATE `district` SET `suffix` = '区' , `code` = '130111' WHERE `id` = '541';
UPDATE `district` SET `order` = '2' WHERE `id` = '535';
UPDATE `district` SET `order` = '3' WHERE `id` = '536';
UPDATE `district` SET `order` = '4' WHERE `id` = '537';
UPDATE `district` SET `order` = '5' WHERE `id` = '538';
UPDATE `district` SET `order` = '6' WHERE `id` = '552';
UPDATE `district` SET `order` = '7' WHERE `id` = '555';
UPDATE `district` SET `order` = '8' WHERE `id` = '541';
UPDATE `district` SET `order` = '9' WHERE `id` = '539';
UPDATE `district` SET `order` = '10' WHERE `id` = '540';
UPDATE `district` SET `order` = '11' WHERE `id` = '542';
UPDATE `district` SET `order` = '12' WHERE `id` = '543';
UPDATE `district` SET `order` = '13' WHERE `id` = '544';
UPDATE `district` SET `order` = '14' WHERE `id` = '545';
UPDATE `district` SET `order` = '15' WHERE `id` = '546';
UPDATE `district` SET `order` = '16' WHERE `id` = '547';
UPDATE `district` SET `order` = '17' WHERE `id` = '548';
UPDATE `district` SET `order` = '18' WHERE `id` = '549';
UPDATE `district` SET `order` = '19' WHERE `id` = '550';
UPDATE `district` SET `order` = '20' WHERE `id` = '551';
UPDATE `district` SET `order` = '21' WHERE `id` = '553';
UPDATE `district` SET `order` = '22' WHERE `id` = '554';
DELETE FROM `district` WHERE `id` = '1851';
UPDATE `district` SET `order` = '5' WHERE `id` = '1855';
UPDATE `district` SET `order` = '6' WHERE `id` = '1852';
UPDATE `district` SET `order` = '7' WHERE `id` = '1853';
UPDATE `district` SET `order` = '8' WHERE `id` = '1854';
UPDATE `district` SET `order` = '9' WHERE `id` = '1856';
UPDATE `district` SET `code` = '445302' WHERE `id` = '2332';
UPDATE `district` SET `order` = '2' WHERE `id` = '2332';
UPDATE `district` SET `order` = '3' WHERE `id` = '2330';
UPDATE `district` SET `order` = '4' WHERE `id` = '2331';
UPDATE `district` SET `name` = '郧阳' , `initials` = 'yy' , `pinyin` = 'yunyang' , `suffix` = '区' , `code` = '420304' WHERE `id` = '2014';
UPDATE `district` SET `code` = '500120' WHERE `id` = '109';
UPDATE `district` SET `code` = '500151' WHERE `id` = '107';
UPDATE `district` SET `order` = '20' WHERE `id` = '109';
UPDATE `district` SET `order` = '22' WHERE `id` = '106';
UPDATE `district` SET `order` = '23' WHERE `id` = '108';
UPDATE `district` SET `code` = '350703' WHERE `id` = '1580';
UPDATE `district` SET `order` = '2' WHERE `id` = '1580';
UPDATE `district` SET `order` = '3' WHERE `id` = '1572';
UPDATE `district` SET `order` = '4' WHERE `id` = '1573';
UPDATE `district` SET `order` = '5' WHERE `id` = '1574';
UPDATE `district` SET `order` = '6' WHERE `id` = '1575';
UPDATE `district` SET `order` = '7' WHERE `id` = '1576';
UPDATE `district` SET `order` = '8' WHERE `id` = '1577';
UPDATE `district` SET `order` = '9' WHERE `id` = '1578';
UPDATE `district` SET `order` = '10' WHERE `id` = '1579';
UPDATE `district` SET `code` = '371003' WHERE `id` = '1779';
UPDATE `district` SET `code` = '440904' WHERE `id` = '2274';
UPDATE `district` SET `code` = '440117' WHERE `id` = '2224';
UPDATE `district` SET `code` = '440118' WHERE `id` = '2223';
UPDATE `district` SET `order` = '11' WHERE `id` = '2224';
UPDATE `district` SET `order` = '12' WHERE `id` = '2223';
UPDATE `district` SET `initials` = 'fm' , `pinyin` = 'fumian' , `code` = '450903' WHERE `id` = '3584';
UPDATE `district` SET `code` = '220281' WHERE `id` = '1040';
UPDATE `district` SET `code` = '542431' WHERE `id` = '2894';
UPDATE `district` SET `code` = '620201' WHERE `id` = '3034';
UPDATE `district` SET `code` = '220822' WHERE `id` = '1076';
UPDATE `district` SET `order` = '3' WHERE `id` = '1076';
UPDATE `district` SET `order` = '4' WHERE `id` = '1074';
UPDATE `district` SET `order` = '5' WHERE `id` = '1075';
Changes 7.0
14 Oct 2014
*) 删除河南省开封市开封县
*) 新增河南省开封市祥符区
*) 河南省开封市下级行政区重新排序
*) 云浮市云安县更名为云安区
*) 滨州市沾化县更名为沾化区
更新脚本:
UPDATE `district` SET `initial` = 'x' , `initials` = 'xf' , `suffix` = '区' , `code` = '410212' WHERE `id` = '1855';
UPDATE `district` SET `order` = '6' WHERE `id` = '1855';
UPDATE `district` SET `order` = '7' WHERE `id` = '1852';
UPDATE `district` SET `order` = '8' WHERE `id` = '1853';
UPDATE `district` SET `order` = '9' WHERE `id` = '1854';
UPDATE `district` SET `suffix` = '区' WHERE `id` = '2332';
UPDATE `district` SET `suffix` = '区' WHERE `id` = '1823';
Changes 6.0
24 Sep 2014
*) 删除石家庄市河东区
*) 石家庄市下级行政区重新排序
更新脚本:
DELETE FROM `district` WHERE `id` = '534';
UPDATE `district` SET `order` = `order` - 1 WHERE `parentid` = 125 AND `order` > 1;
Changes 5.1
15 Sep 2014
*) 修正错误的内蒙古行政区级别为:自治区
*) 修正错误的辽宁行政区级别为:省
更新脚本:
UPDATE `district` SET `suffix` = '自治区' WHERE `id` = '7';
UPDATE `district` SET `suffix` = '省' WHERE `id` = '8';
感谢:@wwb-dev( https://github.com/wwb-dev ) 对错误数据的纠正
Changes 5.0
11 Sep 2014
*) 更新三亚市下级行政区排序
*) 删除更新脚本中 SQL 中的库名
*) STANDARD 版和 SIMPLE 版保留行政代码
更新脚本:
UPDATE `district` SET `order` = '1' WHERE `id` = '3578';
UPDATE `district` SET `order` = '2' WHERE `id` = '3579';
UPDATE `district` SET `order` = '3' WHERE `id` = '3580';
UPDATE `district` SET `order` = '4' WHERE `id` = '3581';
Changes 4.0
09 Sep 2014
*) 临沂市苍山县更名为临沂市兰陵县
*) 山东省撤销县级文登市,设立威海市文登区
*) 新疆维吾尔族自治区新增县级双河市
*) 更新阿克苏区号
*) 更新新疆维吾尔族自治区北屯市行政代码
*) 更新新疆维吾尔族自治区铁门关市行政代码和区号
*) 更新新疆维吾尔族自治区数据
*) 修改喀什拼音 kashen 为 kashi
*) 删除茂名市茂港区
*) 茂名市电白县更新为茂名市电白区
*) 更新茂名市下辖行政区排序
*) 三亚市新增海棠、吉阳、天涯、崖州四区
*) 哈尔滨市双城市更名为双城区
*) 删除连云港市新浦区
*) 更新连云港市下辖行政区排序
*) 连云港市赣榆县更名为连云港市赣榆区
*) 南平市建阳市更名为南平市建阳区
*) 重庆市璧山县更名为重庆市璧山区
*) 重庆市铜梁县更名为重庆市铜梁区
*) 沈阳市东陵区更名为沈阳市浑南区
*) 日喀则地区更名日喀则市
*) 原日喀则地区日喀则市更名为日喀则市桑珠孜区
*) 伊犁哈萨克自治州新增县级市霍尔果斯市
*) 更新伊犁哈萨克自治州下级行政区域排序
*) 桂林市临桂县更名为临桂区
*) 广安市新增前锋区
*) 更新广安市区号
*) 更新广安市下辖行政区区号和排序
*) 达州市达县更名为达州市大川区
*) 潮州市潮安县更名为潮州市潮安区
*) 玉林市新增福绵区
*) 更新玉林市下辖行政区排序
*) 删除绍兴市绍兴县,新增绍兴市柯桥区
*) 绍兴市上虞市更名为上虞区,同时更新行政代码
*) 更新绍兴市下辖行政区排序
*) 删除潮州市梅县,新增梅州市梅县区
*) 赣州市南康市更名为赣州市南康区
*) 删除济宁市市中区
*) 删除济宁市兖州市,新增济宁市兖州区
*) 更新济宁市下辖区排序
*) 修正巴音郭楞蒙古自治州博湖县行政代码
更新脚本:
UPDATE `district` SET `name` = '兰陵' , `initial` = 'l' , `initials` = 'll' , `pinyin` = 'lanling' WHERE `id` = '1794';
UPDATE `district` SET `suffix` = '区' WHERE `id` = '1779';
INSERT INTO `district` (`name`, `parentid`, `initial`, `initials`, `pinyin`, `suffix`, `code`, `area_code`, `order`) VALUES ('双河', '31', 's', 'sh', 'shuanghe', '市', '659007', '0909', '21');
UPDATE `district` SET `area_code` = '0997' WHERE `id` = '474';
UPDATE `district` SET `code` = '659005' WHERE `id` = '466';
UPDATE `district` SET `code` = '659006' , `area_code` = '0996' WHERE `id` = '465';
UPDATE `district` SET `name` = '乌鲁木齐', `initial` = 'w', `initials` = 'wlmq', `pinyin` = 'wulumuqi', `code` = '650100', `code` = '0996 0991' WHERE `id` = '465';
UPDATE `district` SET `parentid` = 465 WHERE `parentid` = 467;
UPDATE `district` SET `name` = '克拉玛依', `initial` = 'k', `initials` = 'klmy', `pinyin` = 'kelamayi', `code` = '650200', `area_code` = '0990' WHERE `id` = '466';
UPDATE `district` SET `parentid` = 466 WHERE `parentid` = 468;
UPDATE `district` SET `name` = '吐鲁番', initial` = 't', `initials` = 'tlf', `pinyin` = 'tulufan', `suffix` = '地区', `code` = '652100', `area_code` = '0995' WHERE `id` = '467';
UPDATE `district` SET `parentid` = 467 WHERE `parentid` = 469;
UPDATE `district` SET `name` = '哈密', `initial` = 'h', `initials` = 'hm', `pinyin` = 'hami', `extra` = '回族', `suffix` = '地区', `code` = '652200', `area_code` = '0902' WHERE `id` = '468';
UPDATE `district` SET `parentid` = 468 WHERE `parentid` = 470;
UPDATE `district` SET `name` = '昌吉', `initial` = 'c', `initials` = 'cj', `pinyin` = 'changji', `suffix` = '自治州', `code` = '652300', `area_code` = '0994' WHERE `id` = '469';
UPDATE `district` SET `parentid` = 469 WHERE `parentid` = 471;
UPDATE `district` SET `name` = '博尔塔拉', `initial` = 'b', initials` = 'betl', `pinyin` = 'boertala', `extra` = '蒙古', `suffix` = '自治州', `code` = '652700', `area_code` = '0909' WHERE `id` = '470';
UPDATE `district` SET `parentid` = 470 WHERE `parentid` = 472;
UPDATE `district` SET `name` = '巴音郭楞', `initial` = 'b', `initials` = 'bygl', `pinyin` = 'bayinguoleng', `extra` = '蒙古', `suffix` = '自治州', `code` = '652800', `area_code` = '0996' WHERE `id` = '471';
UPDATE `district` SET `parentid` = 471 WHERE `parentid` = 473;
UPDATE `district` SET `name` = '阿克苏', `initial` = 'a', `initials` = 'aks', `pinyin` = 'akesu', `extra` = '柯尔克孜', `suffix` = '地区', `code` = '652900', `area_code` = '0997' WHERE `id` = '472';
UPDATE `district` SET `parentid` = 472 WHERE `parentid` = 474;
UPDATE `district` SET `name` = '克孜勒苏', `initial` = 'k', `initials` = 'kzls', `pinyin` = 'kezilesu', `suffix` = '自治州', `code` = '653000', `area_code` = '0908' WHERE `id` = '473';
UPDATE `district` SET `parentid` = 473 WHERE `parentid` = 475;
UPDATE `district` SET `name` = '喀什', `initial` = 'k', `initials` = 'ks', `pinyin` = 'kashi', `suffix` = '地区', `code` = '653100', `area_code` = '0998' WHERE `id` = '474';
UPDATE `district` SET `parentid` = 474 WHERE `parentid` = 476;
UPDATE `district` SET `name` = '和田', initial` = 'h', `initials` = 'ht', `pinyin` = 'hetian', `extra` = '哈萨克', `suffix` = '地区', `code` = '653200', `area_code` = '0903' WHERE `id` = '475';
UPDATE `district` SET `parentid` = 475 WHERE `parentid` = 477;
UPDATE `district` SET `name` = '伊犁', `initial` = 'y', `initials` = 'yl', `pinyin` = 'yili', `suffix` = '自治州', `code` = '654000', `area_code` = '0999' WHERE `id` = '476';
UPDATE `district` SET `parentid` = 476 WHERE `parentid` = 478;
UPDATE `district` SET `name` = '塔城', `initial` = 't', `initials` = 'tc', `pinyin` = 'tacheng', `suffix` = '地区', `code` = '654200', `area_code` = '0901' WHERE `id` = '477';
UPDATE `district` SET `parentid` = 477 WHERE `parentid` = 479;
UPDATE `district` SET `name` = '阿勒泰', `initial` = 'a', `initials` = 'alt', `pinyin` = 'aletai', `suffix` = '地区', `code` = '654300', `area_code` = '0906' WHERE `id` = '478';
UPDATE `district` SET `parentid` = 478 WHERE `parentid` = 480;
UPDATE `district` SET `name` = '石河子', `initial` = 's', `initials` = 'shz', `pinyin` = 'shihezi', `suffix` = '市', `code` = '659001', `area_code` = '0993' WHERE `id` = '479';
UPDATE `district` SET `name` = '阿拉尔', `initial` = 'a', `initials` = 'ale', `pinyin` = 'alaer', `suffix` = '市', `code` = '659002', `area_code` = '0997' WHERE `id` = '480';
UPDATE `district` SET `name` = '图木舒克', `initial` = 't', `initials` = 'tmsk', `pinyin` = 'tumushuke', `suffix` = '市', `code` = '659003', `area_code` = '0998' WHERE `id` = '481';
UPDATE `district` SET `name` = '五家渠', `initial` = 'w', `initials` = 'wjq', `pinyin` = 'wujiaqu', `suffix` = '市', `code` = '659004', `area_code` = '0994' WHERE `id` = '482';
UPDATE `district` SET `name` = '北屯', `initial` = 'b', `initials` = 'bt', `pinyin` = 'beitun', `suffix` = '市', `code` = '659005', `area_code` = '0906' WHERE `id` = '483';
UPDATE `district` SET `name` = '铁门关', `initial` = 't', `initials` = 'tmg', `pinyin` = 'tiemenguan', `suffix` = '市', `code` = '659006', `area_code` = '0996' WHERE `id` = '484';
DELETE FROM `district` WHERE `id` = '2273';
UPDATE `district` SET `suffix` = '区', `order` = '2' WHERE `id` = '2274';
UPDATE `district` SET `order` = '3' WHERE `id` = '2275';
UPDATE `district` SET `order` = '4' WHERE `id` = '2276';
UPDATE `district` SET `order` = '5' WHERE `id` = '2277';
INSERT INTO `district` (`name`, `parentid`, `initial`, `initials`, `pinyin`, `suffix`, `area_code`) VALUES ('海棠', '357', 'h', 'ht', 'haitang', '区', '0898');
INSERT INTO `district` (`name`, `parentid`, `initial`, `initials`, `pinyin`, `suffix`, `area_code`) VALUES ('吉阳', '357', 'j', 'jy', 'jiyang', '区', '0898');
INSERT INTO `district` (`name`, `parentid`, `initial`, `initials`, `pinyin`, `suffix`, `area_code`) VALUES ('天涯', '357', 't', 'ty', 'tianya', '区', '0898');
INSERT INTO `district` (`name`, `parentid`, `initial`, `initials`, `pinyin`, `suffix`, `area_code`) VALUES ('崖州', '357', 'y', 'yz', 'yazhou', '区', '0898');
UPDATE `district` SET `suffix` = '区' WHERE `id` = '1100';
DELETE FROM `district` WHERE `id` = '1271';
UPDATE `district` SET `order` = '2' WHERE `id` = '1272';
UPDATE `district` SET `order` = '3' WHERE `id` = '1273';
UPDATE `district` SET `order` = '4' WHERE `id` = '1274';
UPDATE `district` SET `order` = '5' WHERE `id` = '1275';
UPDATE `district` SET `order` = '6' WHERE `id` = '1276';
UPDATE `district` SET `suffix` = '区' WHERE `id` = '1273';
UPDATE `district` SET `suffix` = '区' WHERE `id` = '1580';
UPDATE `district` SET `suffix` = '区' WHERE `id` = '109';
UPDATE `district` SET `suffix` = '区' WHERE `id` = '107';
UPDATE `district` SET `name` = '浑南' , `initial` = 'h' , `initials` = 'hn' , `pinyin` = 'hunnan' WHERE `id` = '931';
UPDATE `district` SET `suffix` = '市' WHERE `id` = '424';
UPDATE `district` SET `name` = '桑珠孜' , `initial` = 's' , `initials` = 'szz' , `pinyin` = 'sangzhuzi' , `suffix` = '区' WHERE `id` = '2876';
INSERT INTO `district` (`name`, `parentid`, `initial`, `initials`, `pinyin`, `suffix`, `code`, `area_code`, `order`) VALUES ('霍尔果斯', '476', 'h', 'hegs', 'huoerguosi', '市', '654004', '0999', 3);
UPDATE `district` SET `order` = '4' WHERE `id` = '3255';
UPDATE `district` SET `order` = '5' WHERE `id` = '3256';
UPDATE `district` SET `order` = '6' WHERE `id` = '3257';
UPDATE `district` SET `order` = '7' WHERE `id` = '3258';
UPDATE `district` SET `order` = '8' WHERE `id` = '3259';
UPDATE `district` SET `order` = '9' WHERE `id` = '3260';
UPDATE `district` SET `order` = '10' WHERE `id` = '3261';
UPDATE `district` SET `order` = '11' WHERE `id` = '3262';
UPDATE `district` SET `suffix` = '区' WHERE `id` = '2362';
INSERT INTO `district` (`name`, `parentid`, `initial`, `initials`, `pinyin`, `suffix`, `area_code`, `order`) VALUES ('前锋', '388', 'q', 'qf', 'qianfeng', '区', '0826', '2');
UPDATE `district` SET `area_code` = '0826' WHERE `id` = '388';
UPDATE `district` SET `area_code` = '0826' WHERE `id` = '2552';
UPDATE `district` SET `area_code` = '0826' , `order` = '3' WHERE `id` = '2553';
UPDATE `district` SET `area_code` = '0826' , `order` = '4' WHERE `id` = '2554';
UPDATE `district` SET `area_code` = '0826' , `order` = '5' WHERE `id` = '2555';
UPDATE `district` SET `area_code` = '0826' , `order` = '6' WHERE `id` = '2556';
UPDATE `district` SET `name` = '达川' , `initials` = 'dc' , `pinyin` = 'dachuan' , `suffix` = '区' WHERE `id` = '2558';
UPDATE `district` SET `suffix` = '区' WHERE `id` = '2322';
INSERT INTO `district` (`name`, `parentid`, `initial`, `initials`, `pinyin`, `suffix`, `order`) VALUES ('福绵', '350', 'f', 'fj', 'fujin', '区', 2);
UPDATE `district` SET `order` = '3' WHERE `id` = '2398';
UPDATE `district` SET `order` = '4' WHERE `id` = '2399';
UPDATE `district` SET `order` = '5' WHERE `id` = '2400';
UPDATE `district` SET `order` = '6' WHERE `id` = '2401';
UPDATE `district` SET `order` = '7' WHERE `id` = '2402';
UPDATE `district` SET `name` = '柯桥' , `initial` = 'k' , `initials` = 'kq' , `pinyin` = 'keqiao' , `suffix` = '区' , `code` = '330603' WHERE `id` = '1365';
UPDATE `district` SET `suffix` = '区' , `code` = '330604' , `order` = '3' WHERE `id` = '1368';
UPDATE `district` SET `order` = '4' WHERE `id` = '1366';
UPDATE `district` SET `order` = '5' WHERE `id` = '1367';
UPDATE `district` SET `suffix` = '区' , `code` = '441403' WHERE `id` = '2292';
UPDATE `district` SET `suffix` = '区' WHERE `id` = '1650';
DELETE FROM `district` WHERE `id` = '1760';
UPDATE `district` SET `suffix` = '区' , `code` = '370812', `order` = 2 WHERE `id` = '1770';
UPDATE `district` SET `order` = '1' WHERE `id` = '1761';
UPDATE `district` SET `order` = '3' WHERE `id` = '1762';
UPDATE `district` SET `order` = '4' WHERE `id` = '1763';
UPDATE `district` SET `order` = '5' WHERE `id` = '1764';
UPDATE `district` SET `order` = '6' WHERE `id` = '1765';
UPDATE `district` SET `order` = '7' WHERE `id` = '1766';
UPDATE `district` SET `order` = '8' WHERE `id` = '1767';
UPDATE `district` SET `order` = '9' WHERE `id` = '1768';
UPDATE `district` SET `order` = '10' WHERE `id` = '1769';
UPDATE `district` SET `order` = '11' WHERE `id` = '1771';
UPDATE `district` SET `code` = '652829' WHERE `id` = '3219';
Changes 3.0
13 Feb 2014
*) 删除广州市萝岗区
*) 广州市从化市更名为广州市从化区
*) 广州市增城市更名为广州市增城区
更新脚本:
DELETE FROM `district` WHERE `id`='2222';
UPDATE `district` SET `suffix`='区' WHERE `id`='2223';
UPDATE `district` SET `suffix`='区' WHERE `id`='2224';
Changes 2.0.
*)
Changes 1.0
*) The first public version.
Loading...
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
1
https://gitee.com/mikr/district.git
git@gitee.com:mikr/district.git
mikr
district
district
master

搜索帮助

0d507c66 1850385 C8b1a773 1850385