Administrative Address Code

INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (811, ' 230811 ', ' suburbs ', 2, ' 230800 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (1965, ' 421321 ', ' with County ', 2, ' 421300 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (2243, ' 441502 ', ' urban ', 2, ' 441500 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (3045, ' 542427 ', ' Suo County ', 2, ' 542400 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (1, ' 110000 ', ' Beijing ', 0, ' 0 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (2, ' 110100 ', ' Municipal District ', 1, ' 110000 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (3, ' 110101 ', ' Dongcheng District ', 2, ' 110100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (4, ' 110102 ', ' Xicheng ', 2, ' 110100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (5, ' 110105 ', ' Chaoyang District ', 2, ' 110100 '); INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (6, ' 110106 ', ' Fengtai District ', 2, ' 110100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (7, ' 110107 ', ' Shijingshan District ', 2, ' 110100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (8, ' 110108 ', ' Haidian ', 2, ' 110100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (9, ' 110109 ', ' Mentougou district ', 2, ' 110100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (10, ' 110111 ', ' Fangshan ', 2, ' 110100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (11, ' 110112 ', ' Tongzhou District ', 2, ' 110100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (12, ' 110113 ', ' Shunyi District ', 2, ' 110100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (13, ' 110114 ', ' Changping District ', 2, ' 110100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (14, ' 110115 ', ' Daxing District ', 2, ' 110100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (15, ' 110116 ', ' Huairou ', 2, ' 110100 '); INSERT into Address_code (id, codE, name, level, Parentcode VALUES (16, ' 110117 ', ' Pinggu District ', 2, ' 110100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (17, ' 110200 ', ' County ', 1, ' 110000 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (18, ' 110228 ', ' Miyun County ', 2, ' 110200 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (19, ' 110229 ', ' Yanqing County ', 2, ' 110200 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (20, ' 120000 ', ' Tianjin ', 0, ' 0 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (21, ' 120100 ', ' Municipal District ', 1, ' 120000 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (22, ' 120101 ', ' Zone of Peace ', 2, ' 120100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (23, ' 120102 ', ' Hedong District ', 2, ' 120100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (24, ' 120103 ', ' Hexi District ', 2, ' 120100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (25, ' 120104 ', ' Nankai District ', 2, ' 120100 ');INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (26, ' 120105 ', ' Hebei District ', 2, ' 120100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (27, ' 120106 ', ' Hongqiao District ', 2, ' 120100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (28, ' 120110 ', ' Dongli District ', 2, ' 120100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (29, ' 120111 ', ' Xiqing District ', 2, ' 120100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (30, ' 120112 ', ' Jinnan District ', 2, ' 120100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (31, ' 120113 ', ' Beichen district ', 2, ' 120100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (32, ' 120114 ', ' Wuqing District ', 2, ' 120100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (33, ' 120115 ', ' Baochi District ', 2, ' 120100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (34, ' 120116 ', ' Binhai New zone ', 2, ' 120100 '); INSERT into Address_code (IDs, code, name, level, Parentcode) VALues (35, ' 120200 ', ' County ', 1, ' 120000 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (36, ' 120221 ', ' Ninghe County ', 2, ' 120200 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (37, ' 120223 ', ' Jinghai County ', 2, ' 120200 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (38, ' 120225 ', ' Jixian ', 2, ' 120200 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (39, ' 130000 ', ' Hebei province ', 0, ' 0 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (40, ' 130100 ', ' Shijiazhuang City ', 1, ' 130000 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (41, ' 130101 ', ' Municipal District ', 2, ' 130100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (42, ' 130102 ', ' Changan District ', 2, ' 130100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (43, ' 130104 ', ' Qiaoxi District ', 2, ' 130100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (44, ' 130105 ', ' Xinhua District ', 2, ' 130100 '); INSERT into Address_code (ID,Code, name, level, Parentcode VALUES (45, ' 130107 ', ' jingxing mining area ', 2, ' 130100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (46, ' 130108 ', ' Yuhua District ', 2, ' 130100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (47, ' 130109 ', ' Gaocheng area ', 2, ' 130100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (48, ' 130110 ', ' Luquan area ', 2, ' 130100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (49, ' 130111 ', ' Luancheng area ', 2, ' 130100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (50, ' 130121 ', ' Jingxing County ', 2, ' 130100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (51, ' 130123 ', ' Zhengding County ', 2, ' 130100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (52, ' 130125 ', ' Hangtang County ', 2, ' 130100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (53, ' 130126 ', ' Lingshou County ', 2, ' 130100 '); INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (54, ' 130127 ', ' Gaoyi County ', 2,' 130100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (55, ' 130128 ', ' Shenze County ', 2, ' 130100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (56, ' 130129 ', ' Zanhuang County ', 2, ' 130100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (57, ' 130130 ', ' Wuji County ', 2, ' 130100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (58, ' 130131 ', ' Pingshan ', 2, ' 130100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (59, ' 130132 ', ' Yuanshi County ', 2, ' 130100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (60, ' 130133 ', ' Zhao Xian ', 2, ' 130100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (61, ' 130181 ', ' Xinji ', 2, ' 130100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (62, ' 130183 ', ' Jinju ', 2, ' 130100 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (63, ' 130184 ', ' Xinle ', 2, ' 130100 '); INSERT into Address_code (ID, code, name, level, ParenTcode) VALUES (64, ' 130200 ', ' Tangshan ', 1, ' 130000 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (65, ' 130201 ', ' Municipal District ', 2, ' 130200 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (66, ' 130202 ', ' Lunan District ', 2, ' 130200 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (67, ' 130203 ', ' Lubei District ', 2, ' 130200 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (68, ' 130204 ', ' Guzhi District ', 2, ' 130200 ');
INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (69, ' 130205 ', ' Kaiping District ', 2, ' 130200 ');
 INSERT into Address_code (IDs, code, name, level, Parentcode) VALUES (70, ' 130207 ', ' Fengnan District ', 2, ' 130200 ');