最新-中国城市编码sql版上篇

最新推荐文章于 2022-10-18 11:01:19 发布
派森先生
最新推荐文章于 2022-10-18 11:01:19 发布
阅读量1k
点赞数
分类专栏： Mysql数据库
本文链接：https://blog.csdn.net/qq_44846224/article/details/112381973
版权
Mysql数据库专栏收录该内容
6 篇文章 0 订阅
订阅专栏
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for dict_area
-- ----------------------------
DROP TABLE IF EXISTS `dict_area`;
CREATE TABLE `dict_area`  (
  `id` int(11) NOT NULL,
  `name` varchar(48) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '名称',
  `parent_id` int(11) DEFAULT NULL COMMENT '父节点',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '区县行政编码字典表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of dict_area
-- ----------------------------
INSERT INTO `dict_area` VALUES (110000, '北京市', NULL);
INSERT INTO `dict_area` VALUES (110101, '东城区', 110000);
INSERT INTO `dict_area` VALUES (110102, '西城区', 110000);
INSERT INTO `dict_area` VALUES (110105, '朝阳区', 110000);
INSERT INTO `dict_area` VALUES (110106, '丰台区', 110000);
INSERT INTO `dict_area` VALUES (110107, '石景山区', 110000);
INSERT INTO `dict_area` VALUES (110108, '海淀区', 110000);
INSERT INTO `dict_area` VALUES (110109, '门头沟区', 110000);
INSERT INTO `dict_area` VALUES (110111, '房山区', 110000);
INSERT INTO `dict_area` VALUES (110112, '通州区', 110000);
INSERT INTO `dict_area` VALUES (110113, '顺义区', 110000);
INSERT INTO `dict_area` VALUES (110114, '昌平区', 110000);
INSERT INTO `dict_area` VALUES (110115, '大兴区', 110000);
INSERT INTO `dict_area` VALUES (110116, '怀柔区', 110000);
INSERT INTO `dict_area` VALUES (110117, '平谷区', 110000);
INSERT INTO `dict_area` VALUES (110118, '密云区', 110000);
INSERT INTO `dict_area` VALUES (110119, '延庆区', 110000);
INSERT INTO `dict_area` VALUES (120000, '天津市', NULL);
INSERT INTO `dict_area` VALUES (120101, '和平区', 120000);
INSERT INTO `dict_area` VALUES (120102, '河东区', 120000);
INSERT INTO `dict_area` VALUES (120103, '河西区', 120000);
INSERT INTO `dict_area` VALUES (120104, '南开区', 120000);
INSERT INTO `dict_area` VALUES (120105, '河北区', 120000);
INSERT INTO `dict_area` VALUES (120106, '红桥区', 120000);
INSERT INTO `dict_area` VALUES (120110, '东丽区', 120000);
INSERT INTO `dict_area` VALUES (120111, '西青区', 120000);
INSERT INTO `dict_area` VALUES (120112, '津南区', 120000);
INSERT INTO `dict_area` VALUES (120113, '北辰区', 120000);
INSERT INTO `dict_area` VALUES (120114, '武清区', 120000);
INSERT INTO `dict_area` VALUES (120115, '宝坻区', 120000);
INSERT INTO `dict_area` VALUES (120116, '滨海新区', 120000);
INSERT INTO `dict_area` VALUES (120117, '宁河区', 120000);
INSERT INTO `dict_area` VALUES (120118, '静海区', 120000);
INSERT INTO `dict_area` VALUES (120119, '蓟州区', 120000);
INSERT INTO `dict_area` VALUES (130000, '河北省', NULL);
INSERT INTO `dict_area` VALUES (130100, '石家庄市', 130000);
INSERT INTO `dict_area` VALUES (130102, '长安区', 130100);
INSERT INTO `dict_area` VALUES (130104, '桥西区', 130100);
INSERT INTO `dict_area` VALUES (130105, '新华区', 130100);
INSERT INTO `dict_area` VALUES (130107, '井陉矿区', 130100);
INSERT INTO `dict_area` VALUES (130108, '裕华区', 130100);
INSERT INTO `dict_area` VALUES (130109, '藁城区', 130100);
INSERT INTO `dict_area` VALUES (130110, '鹿泉区', 130100);
INSERT INTO `dict_area` VALUES (130111, '栾城区', 130100);
INSERT INTO `dict_area` VALUES (130121, '井陉县', 130100);
INSERT INTO `dict_area` VALUES (130123, '正定县', 130100);
INSERT INTO `dict_area` VALUES (130125, '行唐县', 130100);
INSERT INTO `dict_area` VALUES (130126, '灵寿县', 130100);
INSERT INTO `dict_area` VALUES (130127, '高邑县', 130100);
INSERT INTO `dict_area` VALUES (130128, '深泽县', 130100);
INSERT INTO `dict_area` VALUES (130129, '赞皇县', 130100);
INSERT INTO `dict_area` VALUES (130130, '无极县', 130100);
INSERT INTO `dict_area` VALUES (130131, '平山县', 130100);
INSERT INTO `dict_area` VALUES (130132, '元氏县', 130100);
INSERT INTO `dict_area` VALUES (130133, '赵县', 130100);
INSERT INTO `dict_area` VALUES (130183, '晋州市', 130100);
INSERT INTO `dict_area` VALUES (130184, '新乐市', 130100);
INSERT INTO `dict_area` VALUES (130200, '唐山市', 130000);
INSERT INTO `dict_area` VALUES (130202, '路南区', 130200);
INSERT INTO `dict_area` VALUES (130203, '路北区', 130200);
INSERT INTO `dict_area` VALUES (130204, '古冶区', 130200);
INSERT INTO `dict_area` VALUES (130205, '开平区', 130200);
INSERT INTO `dict_area` VALUES (130207, '丰南区', 130200);
INSERT INTO `dict_area` VALUES (130208, '丰润区', 130200);
INSERT INTO `dict_area` VALUES (130209, '曹妃甸区', 130200);
INSERT INTO `dict_area` VALUES (130223, '滦县', 130200);
INSERT INTO `dict_area` VALUES (130224, '滦南县', 130200);
INSERT INTO `dict_area` VALUES (130225, '乐亭县', 130200);
INSERT INTO `dict_area` VALUES (130227, '迁西县', 130200);
INSERT INTO `dict_area` VALUES (130229, '玉田县', 130200);
INSERT INTO `dict_area` VALUES (130281, '遵化市', 130200);
INSERT INTO `dict_area` VALUES (130283, '迁安市', 130200);
INSERT INTO `dict_area` VALUES (130300, '秦皇岛市', 130000);
INSERT INTO `dict_area` VALUES (130302, '海港区', 130300);
INSERT INTO `dict_area` VALUES (130303, '山海关区', 130300);
INSERT INTO `dict_area` VALUES (130304, '北戴河区', 130300);
INSERT INTO `dict_area` VALUES (130306, '抚宁区', 130300);
INSERT INTO `dict_area` VALUES (130321, '青龙满族自治县', 130300);
INSERT INTO `dict_area` VALUES (130322, '昌黎县', 130300);
INSERT INTO `dict_area` VALUES (130324, '卢龙县', 130300);
INSERT INTO `dict_area` VALUES (130400, '邯郸市', 130000);
INSERT INTO `dict_area` VALUES (130402, '邯山区', 130400);
INSERT INTO `dict_area` VALUES (130403, '丛台区', 130400);
INSERT INTO `dict_area` VALUES (130404, '复兴区', 130400);
INSERT INTO `dict_area` VALUES (130406, '峰峰矿区', 130400);
INSERT INTO `dict_area` VALUES (130407, '肥乡区', 130400);
INSERT INTO `dict_area` VALUES (130408, '永年区', 130400);
INSERT INTO `dict_area` VALUES (130423, '临漳县', 130400);
INSERT INTO `dict_area` VALUES (130424, '成安县', 130400);
INSERT INTO `dict_area` VALUES (130425, '大名县', 130400);
INSERT INTO `dict_area` VALUES (130426, '涉县', 130400);
INSERT INTO `dict_area` VALUES (130427, '磁县', 130400);
INSERT INTO `dict_area` VALUES (130430, '邱县', 130400);
INSERT INTO `dict_area` VALUES (130431, '鸡泽县', 130400);
INSERT INTO `dict_area` VALUES (130432, '广平县', 130400);
INSERT INTO `dict_area` VALUES (130433, '馆陶县', 130400);
INSERT INTO `dict_area` VALUES (130434, '魏县', 130400);
INSERT INTO `dict_area` VALUES (130435, '曲周县', 130400);
INSERT INTO `dict_area` VALUES (130481, '武安市', 130400);
INSERT INTO `dict_area` VALUES (130500, '邢台市', 130000);
INSERT INTO `dict_area` VALUES (130502, '桥东区', 130500);
INSERT INTO `dict_area` VALUES (130503, '桥西区', 130500);
INSERT INTO `dict_area` VALUES (130521, '邢台县', 130500);
INSERT INTO `dict_area` VALUES (130522, '临城县', 130500);
INSERT INTO `dict_area` VALUES (130523, '内丘县', 130500);
INSERT INTO `dict_area` VALUES (130524, '柏乡县', 130500);
INSERT INTO `dict_area` VALUES (130525, '隆尧县', 130500);
INSERT INTO `dict_area` VALUES (130526, '任县', 130500);
INSERT INTO `dict_area` VALUES (130527, '南和县', 130500);
INSERT INTO `dict_area` VALUES (130528, '宁晋县', 130500);
INSERT INTO `dict_area` VALUES (130529, '巨鹿县', 130500);
INSERT INTO `dict_area` VALUES (130530, '新河县', 130500);
INSERT INTO `dict_area` VALUES (130531, '广宗县', 130500);
INSERT INTO `dict_area` VALUES (130532, '平乡县', 130500);
INSERT INTO `dict_area` VALUES (130533, '威县', 130500);
INSERT INTO `dict_area` VALUES (130534, '清河县', 130500);
INSERT INTO `dict_area` VALUES (130535, '临西县', 130500);
INSERT INTO `dict_area` VALUES (130581, '南宫市', 130500);
INSERT INTO `dict_area` VALUES (130582, '沙河市', 130500);
INSERT INTO `dict_area` VALUES (130600, '保定市', 130000);
INSERT INTO `dict_area` VALUES (130602, '竞秀区', 130600);
INSERT INTO `dict_area` VALUES (130606, '莲池区', 130600);
INSERT INTO `dict_area` VALUES (130607, '满城区', 130600);
INSERT INTO `dict_area` VALUES (130608, '清苑区', 130600);
INSERT INTO `dict_area` VALUES (130609, '徐水区', 130600);
INSERT INTO `dict_area` VALUES (130623, '涞水县', 130600);
INSERT INTO `dict_area` VALUES (130624, '阜平县', 130600);
INSERT INTO `dict_area` VALUES (130626, '定兴县', 130600);
INSERT INTO `dict_area` VALUES (130627, '唐县', 130600);
INSERT INTO `dict_area` VALUES (130628, '高阳县', 130600);
INSERT INTO `dict_area` VALUES (130629, '容城县', 130600);
INSERT INTO `dict_area` VALUES (130630, '涞源县', 130600);
INSERT INTO `dict_area` VALUES (130631, '望都县', 130600);
INSERT INTO `dict_area` VALUES (130632, '安新县', 130600);
INSERT INTO `dict_area` VALUES (130633, '易县', 130600);
INSERT INTO `dict_area` VALUES (130634, '曲阳县', 130600);
INSERT INTO `dict_area` VALUES (130635, '蠡县', 130600);
INSERT INTO `dict_area` VALUES (130636, '顺平县', 130600);
INSERT INTO `dict_area` VALUES (130637, '博野县', 130600);
INSERT INTO `dict_area` VALUES (130638, '雄县', 130600);
INSERT INTO `dict_area` VALUES (130681, '涿州市', 130600);
INSERT INTO `dict_area` VALUES (130683, '安国市', 130600);
INSERT INTO `dict_area` VALUES (130684, '高碑店市', 130600);
INSERT INTO `dict_area` VALUES (130700, '张家口市', 130000);
INSERT INTO `dict_area` VALUES (130702, '桥东区', 130700);
INSERT INTO `dict_area` VALUES (130703, '桥西区', 130700);
INSERT INTO `dict_area` VALUES (130705, '宣化区', 130700);
INSERT INTO `dict_area` VALUES (130706, '下花园区', 130700);
INSERT INTO `dict_area` VALUES (130708, '万全区', 130700);
INSERT INTO `dict_area` VALUES (130709, '崇礼区', 130700);
INSERT INTO `dict_area` VALUES (130722, '张北县', 130700);
INSERT INTO `dict_area` VALUES (130723, '康保县', 130700);
INSERT INTO `dict_area` VALUES (130724, '沽源县', 130700);
INSERT INTO `dict_area` VALUES (130725, '尚义县', 130700);
INSERT INTO `dict_area` VALUES (130726, '蔚县', 130700);
INSERT INTO `dict_area` VALUES (130727, '阳原县', 130700);
INSERT INTO `dict_area` VALUES (130728, '怀安县', 130700);
INSERT INTO `dict_area` VALUES (130730, '怀来县', 130700);
INSERT INTO `dict_area` VALUES (130731, '涿鹿县', 130700);
INSERT INTO `dict_area` VALUES (130732, '赤城县', 130700);
INSERT INTO `dict_area` VALUES (130800, '承德市', 130000);
INSERT INTO `dict_area` VALUES (130802, '双桥区', 130800);
INSERT INTO `dict_area` VALUES (130803, '双滦区', 130800);
INSERT INTO `dict_area` VALUES (130804, '鹰手营子矿区', 130800);
INSERT INTO `dict_area` VALUES (130821, '承德县', 130800);
INSERT INTO `dict_area` VALUES (130822, '兴隆县', 130800);
INSERT INTO `dict_area` VALUES (130824, '滦平县', 130800);
INSERT INTO `dict_area` VALUES (130825, '隆化县', 130800);
INSERT INTO `dict_area` VALUES (130826, '丰宁满族自治县', 130800);
INSERT INTO `dict_area` VALUES (130827, '宽城满族自治县', 130800);
INSERT INTO `dict_area` VALUES (130828, '围场满族蒙古族自治县', 130800);
INSERT INTO `dict_area` VALUES (130881, '平泉市', 130800);
INSERT INTO `dict_area` VALUES (130900, '沧州市', 130000);
INSERT INTO `dict_area` VALUES (130902, '新华区', 130900);
INSERT INTO `dict_area` VALUES (130903, '运河区', 130900);
INSERT INTO `dict_area` VALUES (130921, '沧县', 130900);
INSERT INTO `dict_area` VALUES (130922, '青县', 130900);
INSERT INTO `dict_area` VALUES (130923, '东光县', 130900);
INSERT INTO `dict_area` VALUES (130924, '海兴县', 130900);
INSERT INTO `dict_area` VALUES (130925, '盐山县', 130900);
INSERT INTO `dict_area` VALUES (130926, '肃宁县', 130900);
INSERT INTO `dict_area` VALUES (130927, '南皮县', 130900);
INSERT INTO `dict_area` VALUES (130928, '吴桥县', 130900);
INSERT INTO `dict_area` VALUES (130929, '献县', 130900);
INSERT INTO `dict_area` VALUES (130930, '孟村回族自治县', 130900);
INSERT INTO `dict_area` VALUES (130981, '泊头市', 130900);
INSERT INTO `dict_area` VALUES (130982, '任丘市', 130900);
INSERT INTO `dict_area` VALUES (130983, '黄骅市', 130900);
INSERT INTO `dict_area` VALUES (130984, '河间市', 130900);
INSERT INTO `dict_area` VALUES (131000, '廊坊市', 130000);
INSERT INTO `dict_area` VALUES (131002, '安次区', 131000);
INSERT INTO `dict_area` VALUES (131003, '广阳区', 131000);
INSERT INTO `dict_area` VALUES (131022, '固安县', 131000);
INSERT INTO `dict_area` VALUES (131023, '永清县', 131000);
INSERT INTO `dict_area` VALUES (131024, '香河县', 131000);
INSERT INTO `dict_area` VALUES (131025, '大城县', 131000);
INSERT INTO `dict_area` VALUES (131026, '文安县', 131000);
INSERT INTO `dict_area` VALUES (131028, '大厂回族自治县', 131000);
INSERT INTO `dict_area` VALUES (131081, '霸州市', 131000);
INSERT INTO `dict_area` VALUES (131082, '三河市', 131000);
INSERT INTO `dict_area` VALUES (131100, '衡水市', 130000);
INSERT INTO `dict_area` VALUES (131102, '桃城区', 131100);
INSERT INTO `dict_area` VALUES (131103, '冀州区', 131100);
INSERT INTO `dict_area` VALUES (131121, '枣强县', 131100);
INSERT INTO `dict_area` VALUES (131122, '武邑县', 131100);
INSERT INTO `dict_area` VALUES (131123, '武强县', 131100);
INSERT INTO `dict_area` VALUES (131124, '饶阳县', 131100);
INSERT INTO `dict_area` VALUES (131125, '安平县', 131100);
INSERT INTO `dict_area` VALUES (131126, '故城县', 131100);
INSERT INTO `dict_area` VALUES (131127, '景县', 131100);
INSERT INTO `dict_area` VALUES (131128, '阜城县', 131100);
INSERT INTO `dict_area` VALUES (131182, '深州市', 131100);
INSERT INTO `dict_area` VALUES (131200, '定州市', 130000);
INSERT INTO `dict_area` VALUES (131300, '辛集市', 130000);
INSERT INTO `dict_area` VALUES (140000, '山西省', NULL);
INSERT INTO `dict_area` VALUES (140100, '太原市', 140000);
INSERT INTO `dict_area` VALUES (140105, '小店区', 140100);
INSERT INTO `dict_area` VALUES (140106, '迎泽区', 140100);
INSERT INTO `dict_area` VALUES (140107, '杏花岭区', 140100);
INSERT INTO `dict_area` VALUES (140108, '尖草坪区', 140100);
INSERT INTO `dict_area` VALUES (140109, '万柏林区', 140100);
INSERT INTO `dict_area` VALUES (140110, '晋源区', 140100);
INSERT INTO `dict_area` VALUES (140121, '清徐县', 140100);
INSERT INTO `dict_area` VALUES (140122, '阳曲县', 140100);
INSERT INTO `dict_area` VALUES (140123, '娄烦县', 140100);
INSERT INTO `dict_area` VALUES (140181, '古交市', 140100);
INSERT INTO `dict_area` VALUES (140200, '大同市', 140000);
INSERT INTO `dict_area` VALUES (140202, '城区', 140200);
INSERT INTO `dict_area` VALUES (140203, '矿区', 140200);
INSERT INTO `dict_area` VALUES (140211, '南郊区', 140200);
INSERT INTO `dict_area` VALUES (140212, '新荣区', 140200);
INSERT INTO `dict_area` VALUES (140221, '阳高县', 140200);
INSERT INTO `dict_area` VALUES (140222, '天镇县', 140200);
INSERT INTO `dict_area` VALUES (140223, '广灵县', 140200);
INSERT INTO `dict_area` VALUES (140224, '灵丘县', 140200);
INSERT INTO `dict_area` VALUES (140225, '浑源县', 140200);
INSERT INTO `dict_area` VALUES (140226, '左云县', 140200);
INSERT INTO `dict_area` VALUES (140227, '大同县', 140200);
INSERT INTO `dict_area` VALUES (140300, '阳泉市', 140000);
INSERT INTO `dict_area` VALUES (140302, '城区', 140300);
INSERT INTO `dict_area` VALUES (140303, '矿区', 140300);
INSERT INTO `dict_area` VALUES (140311, '郊区', 140300);
INSERT INTO `dict_area` VALUES (140321, '平定县', 140300);
INSERT INTO `dict_area` VALUES (140322, '盂县', 140300);
INSERT INTO `dict_area` VALUES (140400, '长治市', 140000);
INSERT INTO `dict_area` VALUES (140402, '城区', 140400);
INSERT INTO `dict_area` VALUES (140411, '郊区', 140400);
INSERT INTO `dict_area` VALUES (140421, '长治县', 140400);
INSERT INTO `dict_area` VALUES (140423, '襄垣县', 140400);
INSERT INTO `dict_area` VALUES (140424, '屯留县', 140400);
INSERT INTO `dict_area` VALUES (140425, '平顺县', 140400);
INSERT INTO `dict_area` VALUES (140426, '黎城县', 140400);
INSERT INTO `dict_area` VALUES (140427, '壶关县', 140400);
INSERT INTO `dict_area` VALUES (140428, '长子县', 140400);
INSERT INTO `dict_area` VALUES (140429, '武乡县', 140400);
INSERT INTO `dict_area` VALUES (140430, '沁县', 140400);
INSERT INTO `dict_area` VALUES (140431, '沁源县', 140400);
INSERT INTO `dict_area` VALUES (140481, '潞城市', 140400);
INSERT INTO `dict_area` VALUES (140500, '晋城市', 140000);
INSERT INTO `dict_area` VALUES (140502, '城区', 140500);
INSERT INTO `dict_area` VALUES (140521, '沁水县', 140500);
INSERT INTO `dict_area` VALUES (140522, '阳城县', 140500);
INSERT INTO `dict_area` VALUES (140524, '陵川县', 140500);
INSERT INTO `dict_area` VALUES (140525, '泽州县', 140500);
INSERT INTO `dict_area` VALUES (140581, '高平市', 140500);
INSERT INTO `dict_area` VALUES (140600, '朔州市', 140000);
INSERT INTO `dict_area` VALUES (140602, '朔城区', 140600);
INSERT INTO `dict_area` VALUES (140603, '平鲁区', 140600);
INSERT INTO `dict_area` VALUES (140621, '山阴县', 140600);
INSERT INTO `dict_area` VALUES (140622, '应县', 140600);
INSERT INTO `dict_area` VALUES (140623, '右玉县', 140600);
INSERT INTO `dict_area` VALUES (140624, '怀仁县', 140600);
INSERT INTO `dict_area` VALUES (140700, '晋中市', 140000);
INSERT INTO `dict_area` VALUES (140702, '榆次区', 140700);
INSERT INTO `dict_area` VALUES (140721, '榆社县', 140700);
INSERT INTO `dict_area` VALUES (140722, '左权县', 140700);
INSERT INTO `dict_area` VALUES (140723, '和顺县', 140700);
INSERT INTO `dict_area` VALUES (140724, '昔阳县', 140700);
INSERT INTO `dict_area` VALUES (140725, '寿阳县', 140700);
INSERT INTO `dict_area` VALUES (140726, '太谷县', 140700);
INSERT INTO `dict_area` VALUES (140727, '祁县', 140700);
INSERT INTO `dict_area` VALUES (140728, '平遥县', 140700);
INSERT INTO `dict_area` VALUES (140729, '灵石县', 140700);
INSERT INTO `dict_area` VALUES (140781, '介休市', 140700);
INSERT INTO `dict_area` VALUES (140800, '运城市', 140000);
INSERT INTO `dict_area` VALUES (140802, '盐湖区', 140800);
INSERT INTO `dict_area` VALUES (140821, '临猗县', 140800);
INSERT INTO `dict_area` VALUES (140822, '万荣县', 140800);
INSERT INTO `dict_area` VALUES (140823, '闻喜县', 140800);
INSERT INTO `dict_area` VALUES (140824, '稷山县', 140800);
INSERT INTO `dict_area` VALUES (140825, '新绛县', 140800);
INSERT INTO `dict_area` VALUES (140826, '绛县', 140800);
INSERT INTO `dict_area` VALUES (140827, '垣曲县', 140800);
INSERT INTO `dict_area` VALUES (140828, '夏县', 140800);
INSERT INTO `dict_area` VALUES (140829, '平陆县', 140800);
INSERT INTO `dict_area` VALUES (140830, '芮城县', 140800);
INSERT INTO `dict_area` VALUES (140881, '永济市', 140800);
INSERT INTO `dict_area` VALUES (140882, '河津市', 140800);
INSERT INTO `dict_area` VALUES (140900, '忻州市', 140000);
INSERT INTO `dict_area` VALUES (140902, '忻府区', 140900);
INSERT INTO `dict_area` VALUES (140921, '定襄县', 140900);
INSERT INTO `dict_area` VALUES (140922, '五台县', 140900);
INSERT INTO `dict_area` VALUES (140923, '代县', 140900);
INSERT INTO `dict_area` VALUES (140924, '繁峙县', 140900);
INSERT INTO `dict_area` VALUES (140925, '宁武县', 140900);
INSERT INTO `dict_area` VALUES (140926, '静乐县', 140900);
INSERT INTO `dict_area` VALUES (140927, '神池县', 140900);
INSERT INTO `dict_area` VALUES (140928, '五寨县', 140900);
INSERT INTO `dict_area` VALUES (140929, '岢岚县', 140900);
INSERT INTO `dict_area` VALUES (140930, '河曲县', 140900);
INSERT INTO `dict_area` VALUES (140931, '保德县', 140900);
INSERT INTO `dict_area` VALUES (140932, '偏关县', 140900);
INSERT INTO `dict_area` VALUES (140981, '原平市', 140900);
INSERT INTO `dict_area` VALUES (141000, '临汾市', 140000);
INSERT INTO `dict_area` VALUES (141002, '尧都区', 141000);
INSERT INTO `dict_area` VALUES (141021, '曲沃县', 141000);
INSERT INTO `dict_area` VALUES (141022, '翼城县', 141000);
INSERT INTO `dict_area` VALUES (141023, '襄汾县', 141000);
INSERT INTO `dict_area` VALUES (141024, '洪洞县', 141000);
INSERT INTO `dict_area` VALUES (141025, '古县', 141000);
INSERT INTO `dict_area` VALUES (141026, '安泽县', 141000);
INSERT INTO `dict_area` VALUES (141027, '浮山县', 141000);
INSERT INTO `dict_area` VALUES (141028, '吉县', 141000);
INSERT INTO `dict_area` VALUES (141029, '乡宁县', 141000);
INSERT INTO `dict_area` VALUES (141030, '大宁县', 141000);
INSERT INTO `dict_area` VALUES (141031, '隰县', 141000);
INSERT INTO `dict_area` VALUES (141032, '永和县', 141000);
INSERT INTO `dict_area` VALUES (141033, '蒲县', 141000);
INSERT INTO `dict_area` VALUES (141034, '汾西县', 141000);
INSERT INTO `dict_area` VALUES (141081, '侯马市', 141000);
INSERT INTO `dict_area` VALUES (141082, '霍州市', 141000);
INSERT INTO `dict_area` VALUES (141100, '吕梁市', 140000);
INSERT INTO `dict_area` VALUES (141102, '离石区', 141100);
INSERT INTO `dict_area` VALUES (141121, '文水县', 141100);
INSERT INTO `dict_area` VALUES (141122, '交城县', 141100);
INSERT INTO `dict_area` VALUES (141123, '兴县', 141100);
INSERT INTO `dict_area` VALUES (141124, '临县', 141100);
INSERT INTO `dict_area` VALUES (141125, '柳林县', 141100);
INSERT INTO `dict_area` VALUES (141126, '石楼县', 141100);
INSERT INTO `dict_area` VALUES (141127, '岚县', 141100);
INSERT INTO `dict_area` VALUES (141128, '方山县', 141100);
INSERT INTO `dict_area` VALUES (141129, '中阳县', 141100);
INSERT INTO `dict_area` VALUES (141130, '交口县', 141100);
INSERT INTO `dict_area` VALUES (141181, '孝义市', 141100);
INSERT INTO `dict_area` VALUES (141182, '汾阳市', 141100);
INSERT INTO `dict_area` VALUES (150000, '内蒙古自治区', NULL);
INSERT INTO `dict_area` VALUES (150100, '呼和浩特市', 150000);
INSERT INTO `dict_area` VALUES (150102, '新城区', 150100);
INSERT INTO `dict_area` VALUES (150103, '回民区', 150100);
INSERT INTO `dict_area` VALUES (150104, '玉泉区', 150100);
INSERT INTO `dict_area` VALUES (150105, '赛罕区', 150100);
INSERT INTO `dict_area` VALUES (150121, '土默特左旗', 150100);
INSERT INTO `dict_area` VALUES (150122, '托克托县', 150100);
INSERT INTO `dict_area` VALUES (150123, '和林格尔县', 150100);
INSERT INTO `dict_area` VALUES (150124, '清水河县', 150100);
INSERT INTO `dict_area` VALUES (150125, '武川县', 150100);
INSERT INTO `dict_area` VALUES (150200, '包头市', 150000);
INSERT INTO `dict_area` VALUES (150202, '东河区', 150200);
INSERT INTO `dict_area` VALUES (150203, '昆都仑区', 150200);
INSERT INTO `dict_area` VALUES (150204, '青山区', 150200);
INSERT INTO `dict_area` VALUES (150205, '石拐区', 150200);
INSERT INTO `dict_area` VALUES (150206, '白云鄂博矿区', 150200);
INSERT INTO `dict_area` VALUES (150207, '九原区', 150200);
INSERT INTO `dict_area` VALUES (150221, '土默特右旗', 150200);
INSERT INTO `dict_area` VALUES (150222, '固阳县', 150200);
INSERT INTO `dict_area` VALUES (150223, '达尔罕茂明安联合旗', 150200);
INSERT INTO `dict_area` VALUES (150300, '乌海市', 150000);
INSERT INTO `dict_area` VALUES (150302, '海勃湾区', 150300);
INSERT INTO `dict_area` VALUES (150303, '海南区', 150300);
INSERT INTO `dict_area` VALUES (150304, '乌达区', 150300);
INSERT INTO `dict_area` VALUES (150400, '赤峰市', 150000);
INSERT INTO `dict_area` VALUES (150402, '红山区', 150400);
INSERT INTO `dict_area` VALUES (150403, '元宝山区', 150400);
INSERT INTO `dict_area` VALUES (150404, '松山区', 150400);
INSERT INTO `dict_area` VALUES (150421, '阿鲁科尔沁旗', 150400);
INSERT INTO `dict_area` VALUES (150422, '巴林左旗', 150400);
INSERT INTO `dict_area` VALUES (150423, '巴林右旗', 150400);
INSERT INTO `dict_area` VALUES (150424, '林西县', 150400);
INSERT INTO `dict_area` VALUES (150425, '克什克腾旗', 150400);
INSERT INTO `dict_area` VALUES (150426, '翁牛特旗', 150400);
INSERT INTO `dict_area` VALUES (150428, '喀喇沁旗', 150400);
INSERT INTO `dict_area` VALUES (150429, '宁城县', 150400);
INSERT INTO `dict_area` VALUES (150430, '敖汉旗', 150400);
INSERT INTO `dict_area` VALUES (150500, '通辽市', 150000);
INSERT INTO `dict_area` VALUES (150502, '科尔沁区', 150500);
INSERT INTO `dict_area` VALUES (150521, '科尔沁左翼中旗', 150500);
INSERT INTO `dict_area` VALUES (150522, '科尔沁左翼后旗', 150500);
INSERT INTO `dict_area` VALUES (150523, '开鲁县', 150500);
INSERT INTO `dict_area` VALUES (150524, '库伦旗', 150500);
INSERT INTO `dict_area` VALUES (150525, '奈曼旗', 150500);
INSERT INTO `dict_area` VALUES (150526, '扎鲁特旗', 150500);
INSERT INTO `dict_area` VALUES (150581, '霍林郭勒市', 150500);
INSERT INTO `dict_area` VALUES (150600, '鄂尔多斯市', 150000);
INSERT INTO `dict_area` VALUES (150602, '东胜区', 150600);
INSERT INTO `dict_area` VALUES (150603, '康巴什区', 150600);
INSERT INTO `dict_area` VALUES (150621, '达拉特旗', 150600);
INSERT INTO `dict_area` VALUES (150622, '准格尔旗', 150600);
INSERT INTO `dict_area` VALUES (150623, '鄂托克前旗', 150600);
INSERT INTO `dict_area` VALUES (150624, '鄂托克旗', 150600);
INSERT INTO `dict_area` VALUES (150625, '杭锦旗', 150600);
INSERT INTO `dict_area` VALUES (150626, '乌审旗', 150600);
INSERT INTO `dict_area` VALUES (150627, '伊金霍洛旗', 150600);
INSERT INTO `dict_area` VALUES (150700, '呼伦贝尔市', 150000);
INSERT INTO `dict_area` VALUES (150702, '海拉尔区', 150700);
INSERT INTO `dict_area` VALUES (150703, '扎赉诺尔区', 150700);
INSERT INTO `dict_area` VALUES (150721, '阿荣旗', 150700);
INSERT INTO `dict_area` VALUES (150722, '莫力达瓦达斡尔族自治旗', 150700);
INSERT INTO `dict_area` VALUES (150723, '鄂伦春自治旗', 150700);
INSERT INTO `dict_area` VALUES (150724, '鄂温克族自治旗', 150700);
INSERT INTO `dict_area` VALUES (150725, '陈巴尔虎旗', 150700);
INSERT INTO `dict_area` VALUES (150726, '新巴尔虎左旗', 150700);
INSERT INTO `dict_area` VALUES (150727, '新巴尔虎右旗', 150700);
INSERT INTO `dict_area` VALUES (150781, '满洲里市', 150700);
INSERT INTO `dict_area` VALUES (150782, '牙克石市', 150700);
INSERT INTO `dict_area` VALUES (150783, '扎兰屯市', 150700);
INSERT INTO `dict_area` VALUES (150784, '额尔古纳市', 150700);
INSERT INTO `dict_area` VALUES (150785, '根河市', 150700);
INSERT INTO `dict_area` VALUES (150800, '巴彦淖尔市', 150000);
INSERT INTO `dict_area` VALUES (150802, '临河区', 150800);
INSERT INTO `dict_area` VALUES (150821, '五原县', 150800);
INSERT INTO `dict_area` VALUES (150822, '磴口县', 150800);
INSERT INTO `dict_area` VALUES (150823, '乌拉特前旗', 150800);
INSERT INTO `dict_area` VALUES (150824, '乌拉特中旗', 150800);
INSERT INTO `dict_area` VALUES (150825, '乌拉特后旗', 150800);
INSERT INTO `dict_area` VALUES (150826, '杭锦后旗', 150800);
INSERT INTO `dict_area` VALUES (150900, '乌兰察布市', 150000);
INSERT INTO `dict_area` VALUES (150902, '集宁区', 150900);
INSERT INTO `dict_area` VALUES (150921, '卓资县', 150900);
INSERT INTO `dict_area` VALUES (150922, '化德县', 150900);
INSERT INTO `dict_area` VALUES (150923, '商都县', 150900);
INSERT INTO `dict_area` VALUES (150924, '兴和县', 150900);
INSERT INTO `dict_area` VALUES (150925, '凉城县', 150900);
INSERT INTO `dict_area` VALUES (150926, '察哈尔右翼前旗', 150900);
INSERT INTO `dict_area` VALUES (150927, '察哈尔右翼中旗', 150900);
INSERT INTO `dict_area` VALUES (150928, '察哈尔右翼后旗', 150900);
INSERT INTO `dict_area` VALUES (150929, '四子王旗', 150900);
INSERT INTO `dict_area` VALUES (150981, '丰镇市', 150900);
INSERT INTO `dict_area` VALUES (152200, '兴安盟', 150000);
INSERT INTO `dict_area` VALUES (152201, '乌兰浩特市', 152200);
INSERT INTO `dict_area` VALUES (152202, '阿尔山市', 152200);
INSERT INTO `dict_area` VALUES (152221, '科尔沁右翼前旗', 152200);
INSERT INTO `dict_area` VALUES (152222, '科尔沁右翼中旗', 152200);
INSERT INTO `dict_area` VALUES (152223, '扎赉特旗', 152200);
INSERT INTO `dict_area` VALUES (152224, '突泉县', 152200);
INSERT INTO `dict_area` VALUES (152500, '锡林郭勒盟', 150000);
INSERT INTO `dict_area` VALUES (152501, '二连浩特市', 152500);
INSERT INTO `dict_area` VALUES (152502, '锡林浩特市', 152500);
INSERT INTO `dict_area` VALUES (152522, '阿巴嘎旗', 152500);
INSERT INTO `dict_area` VALUES (152523, '苏尼特左旗', 152500);
INSERT INTO `dict_area` VALUES (152524, '苏尼特右旗', 152500);
INSERT INTO `dict_area` VALUES (152525, '东乌珠穆沁旗', 152500);
INSERT INTO `dict_area` VALUES (152526, '西乌珠穆沁旗', 152500);
INSERT INTO `dict_area` VALUES (152527, '太仆寺旗', 152500);
INSERT INTO `dict_area` VALUES (152528, '镶黄旗', 152500);
INSERT INTO `dict_area` VALUES (152529, '正镶白旗', 152500);
INSERT INTO `dict_area` VALUES (152530, '正蓝旗', 152500);
INSERT INTO `dict_area` VALUES (152531, '多伦县', 152500);
INSERT INTO `dict_area` VALUES (152900, '阿拉善盟', 150000);
INSERT INTO `dict_area` VALUES (152921, '阿拉善左旗', 152900);
INSERT INTO `dict_area` VALUES (152922, '阿拉善右旗', 152900);
INSERT INTO `dict_area` VALUES (152923, '额济纳旗', 152900);
INSERT INTO `dict_area` VALUES (210000, '辽宁省', NULL);
INSERT INTO `dict_area` VALUES (210100, '沈阳市', 210000);
INSERT INTO `dict_area` VALUES (210102, '和平区', 210100);
INSERT INTO `dict_area` VALUES (210103, '沈河区', 210100);
INSERT INTO `dict_area` VALUES (210104, '大东区', 210100);
INSERT INTO `dict_area` VALUES (210105, '皇姑区', 210100);
INSERT INTO `dict_area` VALUES (210106, '铁西区', 210100);
INSERT INTO `dict_area` VALUES (210111, '苏家屯区', 210100);
INSERT INTO `dict_area` VALUES (210112, '浑南区', 210100);
INSERT INTO `dict_area` VALUES (210113, '沈北新区', 210100);
INSERT INTO `dict_area` VALUES (210114, '于洪区', 210100);
INSERT INTO `dict_area` VALUES (210115, '辽中区', 210100);
INSERT INTO `dict_area` VALUES (210123, '康平县', 210100);
INSERT INTO `dict_area` VALUES (210124, '法库县', 210100);
INSERT INTO `dict_area` VALUES (210181, '新民市', 210100);
INSERT INTO `dict_area` VALUES (210200, '大连市', 210000);
INSERT INTO `dict_area` VALUES (210202, '中山区', 210200);
INSERT INTO `dict_area` VALUES (210203, '西岗区', 210200);
INSERT INTO `dict_area` VALUES (210204, '沙河口区', 210200);
INSERT INTO `dict_area` VALUES (210211, '甘井子区', 210200);
INSERT INTO `dict_area` VALUES (210212, '旅顺口区', 210200);
INSERT INTO `dict_area` VALUES (210213, '金州区', 210200);
INSERT INTO `dict_area` VALUES (210214, '普兰店区', 210200);
INSERT INTO `dict_area` VALUES (210224, '长海县', 210200);
INSERT INTO `dict_area` VALUES (210281, '瓦房店市', 210200);
INSERT INTO `dict_area` VALUES (210283, '庄河市', 210200);
INSERT INTO `dict_area` VALUES (210300, '鞍山市', 210000);
INSERT INTO `dict_area` VALUES (210302, '铁东区', 210300);
INSERT INTO `dict_area` VALUES (210303, '铁西区', 210300);
INSERT INTO `dict_area` VALUES (210304, '立山区', 210300);
INSERT INTO `dict_area` VALUES (210311, '千山区', 210300);
INSERT INTO `dict_area` VALUES (210321, '台安县', 210300);
INSERT INTO `dict_area` VALUES (210323, '岫岩满族自治县', 210300);
INSERT INTO `dict_area` VALUES (210381, '海城市', 210300);
INSERT INTO `dict_area` VALUES (210400, '抚顺市', 210000);
INSERT INTO `dict_area` VALUES (210402, '新抚区', 210400);
INSERT INTO `dict_area` VALUES (210403, '东洲区', 210400);
INSERT INTO `dict_area` VALUES (210404, '望花区', 210400);
INSERT INTO `dict_area` VALUES (210411, '顺城区', 210400);
INSERT INTO `dict_area` VALUES (210421, '抚顺县', 210400);
INSERT INTO `dict_area` VALUES (210422, '新宾满族自治县', 210400);
INSERT INTO `dict_area` VALUES (210423, '清原满族自治县', 210400);
INSERT INTO `dict_area` VALUES (210500, '本溪市', 210000);
INSERT INTO `dict_area` VALUES (210502, '平山区', 210500);
INSERT INTO `dict_area` VALUES (210503, '溪湖区', 210500);
INSERT INTO `dict_area` VALUES (210504, '明山区', 210500);
INSERT INTO `dict_area` VALUES (210505, '南芬区', 210500);
INSERT INTO `dict_area` VALUES (210521, '本溪满族自治县', 210500);
INSERT INTO `dict_area` VALUES (210522, '桓仁满族自治县', 210500);
INSERT INTO `dict_area` VALUES (210600, '丹东市', 210000);
INSERT INTO `dict_area` VALUES (210602, '元宝区', 210600);
INSERT INTO `dict_area` VALUES (210603, '振兴区', 210600);
INSERT INTO `dict_area` VALUES (210604, '振安区', 210600);
INSERT INTO `dict_area` VALUES (210624, '宽甸满族自治县', 210600);
INSERT INTO `dict_area` VALUES (210681, '东港市', 210600);
INSERT INTO `dict_area` VALUES (210682, '凤城市', 210600);
INSERT INTO `dict_area` VALUES (210700, '锦州市', 210000);
INSERT INTO `dict_area` VALUES (210702, '古塔区', 210700);
INSERT INTO `dict_area` VALUES (210703, '凌河区', 210700);
INSERT INTO `dict_area` VALUES (210711, '太和区', 210700);
INSERT INTO `dict_area` VALUES (210726, '黑山县', 210700);
INSERT INTO `dict_area` VALUES (210727, '义县', 210700);
INSERT INTO `dict_area` VALUES (210781, '凌海市', 210700);
INSERT INTO `dict_area` VALUES (210782, '北镇市', 210700);
INSERT INTO `dict_area` VALUES (210800, '营口市', 210000);
INSERT INTO `dict_area` VALUES (210802, '站前区', 210800);
INSERT INTO `dict_area` VALUES (210803, '西市区', 210800);
INSERT INTO `dict_area` VALUES (210804, '鲅鱼圈区', 210800);
INSERT INTO `dict_area` VALUES (210811, '老边区', 210800);
INSERT INTO `dict_area` VALUES (210881, '盖州市', 210800);
INSERT INTO `dict_area` VALUES (210882, '大石桥市', 210800);
INSERT INTO `dict_area` VALUES (210900, '阜新市', 210000);
INSERT INTO `dict_area` VALUES (210902, '海州区', 210900);
INSERT INTO `dict_area` VALUES (210903, '新邱区', 210900);
INSERT INTO `dict_area` VALUES (210904, '太平区', 210900);
INSERT INTO `dict_area` VALUES (210905, '清河门区', 210900);
INSERT INTO `dict_area` VALUES (210911, '细河区', 210900);
INSERT INTO `dict_area` VALUES (210921, '阜新蒙古族自治县', 210900);
INSERT INTO `dict_area` VALUES (210922, '彰武县', 210900);
INSERT INTO `dict_area` VALUES (211000, '辽阳市', 210000);
INSERT INTO `dict_area` VALUES (211002, '白塔区', 211000);
INSERT INTO `dict_area` VALUES (211003, '文圣区', 211000);
INSERT INTO `dict_area` VALUES (211004, '宏伟区', 211000);
INSERT INTO `dict_area` VALUES (211005, '弓长岭区', 211000);
INSERT INTO `dict_area` VALUES (211011, '太子河区', 211000);
INSERT INTO `dict_area` VALUES (211021, '辽阳县', 211000);
INSERT INTO `dict_area` VALUES (211081, '灯塔市', 211000);
INSERT INTO `dict_area` VALUES (211100, '盘锦市', 210000);
INSERT INTO `dict_area` VALUES (211102, '双台子区', 211100);
INSERT INTO `dict_area` VALUES (211103, '兴隆台区', 211100);
INSERT INTO `dict_area` VALUES (211104, '大洼区', 211100);
INSERT INTO `dict_area` VALUES (211122, '盘山县', 211100);
INSERT INTO `dict_area` VALUES (211200, '铁岭市', 210000);
INSERT INTO `dict_area` VALUES (211202, '银州区', 211200);
INSERT INTO `dict_area` VALUES (211204, '清河区', 211200);
INSERT INTO `dict_area` VALUES (211221, '铁岭县', 211200);
INSERT INTO `dict_area` VALUES (211223, '西丰县', 211200);
INSERT INTO `dict_area` VALUES (211224, '昌图县', 211200);
INSERT INTO `dict_area` VALUES (211281, '调兵山市', 211200);
INSERT INTO `dict_area` VALUES (211282, '开原市', 211200);
INSERT INTO `dict_area` VALUES (211300, '朝阳市', 210000);
INSERT INTO `dict_area` VALUES (211302, '双塔区', 211300);
INSERT INTO `dict_area` VALUES (211303, '龙城区', 211300);
INSERT INTO `dict_area` VALUES (211321, '朝阳县', 211300);
INSERT INTO `dict_area` VALUES (211322, '建平县', 211300);
INSERT INTO `dict_area` VALUES (211324, '喀喇沁左翼蒙古族自治县', 211300);
INSERT INTO `dict_area` VALUES (211381, '北票市', 211300);
INSERT INTO `dict_area` VALUES (211382, '凌源市', 211300);
INSERT INTO `dict_area` VALUES (211400, '葫芦岛市', 210000);
INSERT INTO `dict_area` VALUES (211402, '连山区', 211400);
INSERT INTO `dict_area` VALUES (211403, '龙港区', 211400);
INSERT INTO `dict_area` VALUES (211404, '南票区', 211400);
INSERT INTO `dict_area` VALUES (211421, '绥中县', 211400);
INSERT INTO `dict_area` VALUES (211422, '建昌县', 211400);
INSERT INTO `dict_area` VALUES (211481, '兴城市', 211400);
INSERT INTO `dict_area` VALUES (220000, '吉林省', NULL);
INSERT INTO `dict_area` VALUES (220100, '长春市', 220000);
INSERT INTO `dict_area` VALUES (220102, '南关区', 220100);
INSERT INTO `dict_area` VALUES (220103, '宽城区', 220100);
INSERT INTO `dict_area` VALUES (220104, '朝阳区', 220100);
INSERT INTO `dict_area` VALUES (220105, '二道区', 220100);
INSERT INTO `dict_area` VALUES (220106, '绿园区', 220100);
INSERT INTO `dict_area` VALUES (220112, '双阳区', 220100);
INSERT INTO `dict_area` VALUES (220113, '九台区', 220100);
INSERT INTO `dict_area` VALUES (220122, '农安县', 220100);
INSERT INTO `dict_area` VALUES (220182, '榆树市', 220100);
INSERT INTO `dict_area` VALUES (220183, '德惠市', 220100);
INSERT INTO `dict_area` VALUES (220200, '吉林市', 220000);
INSERT INTO `dict_area` VALUES (220202, '昌邑区', 220200);
INSERT INTO `dict_area` VALUES (220203, '龙潭区', 220200);
INSERT INTO `dict_area` VALUES (220204, '船营区', 220200);
INSERT INTO `dict_area` VALUES (220211, '丰满区', 220200);
INSERT INTO `dict_area` VALUES (220221, '永吉县', 220200);
INSERT INTO `dict_area` VALUES (220281, '蛟河市', 220200);
INSERT INTO `dict_area` VALUES (220282, '桦甸市', 220200);
INSERT INTO `dict_area` VALUES (220283, '舒兰市', 220200);
INSERT INTO `dict_area` VALUES (220284, '磐石市', 220200);
INSERT INTO `dict_area` VALUES (220300, '四平市', 220000);
INSERT INTO `dict_area` VALUES (220302, '铁西区', 220300);
INSERT INTO `dict_area` VALUES (220303, '铁东区', 220300);
INSERT INTO `dict_area` VALUES (220322, '梨树县', 220300);
INSERT INTO `dict_area` VALUES (220323, '伊通满族自治县', 220300);
INSERT INTO `dict_area` VALUES (220381, '公主岭市', 220300);
INSERT INTO `dict_area` VALUES (220382, '双辽市', 220300);
INSERT INTO `dict_area` VALUES (220400, '辽源市', 220000);
INSERT INTO `dict_area` VALUES (220402, '龙山区', 220400);
INSERT INTO `dict_area` VALUES (220403, '西安区', 220400);
INSERT INTO `dict_area` VALUES (220421, '东丰县', 220400);
INSERT INTO `dict_area` VALUES (220422, '东辽县', 220400);
INSERT INTO `dict_area` VALUES (220500, '通化市', 220000);
INSERT INTO `dict_area` VALUES (220502, '东昌区', 220500);
INSERT INTO `dict_area` VALUES (220503, '二道江区', 220500);
INSERT INTO `dict_area` VALUES (220521, '通化县', 220500);
INSERT INTO `dict_area` VALUES (220523, '辉南县', 220500);
INSERT INTO `dict_area` VALUES (220524, '柳河县', 220500);
INSERT INTO `dict_area` VALUES (220581, '梅河口市', 220500);
INSERT INTO `dict_area` VALUES (220582, '集安市', 220500);
INSERT INTO `dict_area` VALUES (220600, '白山市', 220000);
INSERT INTO `dict_area` VALUES (220602, '浑江区', 220600);
INSERT INTO `dict_area` VALUES (220605, '江源区', 220600);
INSERT INTO `dict_area` VALUES (220621, '抚松县', 220600);
INSERT INTO `dict_area` VALUES (220622, '靖宇县', 220600);
INSERT INTO `dict_area` VALUES (220623, '长白朝鲜族自治县', 220600);
INSERT INTO `dict_area` VALUES (220681, '临江市', 220600);
INSERT INTO `dict_area` VALUES (220700, '松原市', 220000);
INSERT INTO `dict_area` VALUES (220702, '宁江区', 220700);
INSERT INTO `dict_area` VALUES (220721, '前郭尔罗斯蒙古族自治县', 220700);
INSERT INTO `dict_area` VALUES (220722, '长岭县', 220700);
INSERT INTO `dict_area` VALUES (220723, '乾安县', 220700);
INSERT INTO `dict_area` VALUES (220781, '扶余市', 220700);
INSERT INTO `dict_area` VALUES (220800, '白城市', 220000);
INSERT INTO `dict_area` VALUES (220802, '洮北区', 220800);
INSERT INTO `dict_area` VALUES (220821, '镇赉县', 220800);
INSERT INTO `dict_area` VALUES (220822, '通榆县', 220800);
INSERT INTO `dict_area` VALUES (220881, '洮南市', 220800);
INSERT INTO `dict_area` VALUES (220882, '大安市', 220800);
INSERT INTO `dict_area` VALUES (222400, '延边朝鲜族自治州', 220000);
INSERT INTO `dict_area` VALUES (222401, '延吉市', 222400);
INSERT INTO `dict_area` VALUES (222402, '图们市', 222400);
INSERT INTO `dict_area` VALUES (222403, '敦化市', 222400);
INSERT INTO `dict_area` VALUES (222404, '珲春市', 222400);
INSERT INTO `dict_area` VALUES (222405, '龙井市', 222400);
INSERT INTO `dict_area` VALUES (222406, '和龙市', 222400);
INSERT INTO `dict_area` VALUES (222424, '汪清县', 222400);
INSERT INTO `dict_area` VALUES (222426, '安图县', 222400);
INSERT INTO `dict_area` VALUES (230000, '黑龙江省', NULL);
INSERT INTO `dict_area` VALUES (230100, '哈尔滨市', 230000);
INSERT INTO `dict_area` VALUES (230102, '道里区', 230100);
INSERT INTO `dict_area` VALUES (230103, '南岗区', 230100);
INSERT INTO `dict_area` VALUES (230104, '道外区', 230100);
INSERT INTO `dict_area` VALUES (230108, '平房区', 230100);
INSERT INTO `dict_area` VALUES (230109, '松北区', 230100);
INSERT INTO `dict_area` VALUES (230110, '香坊区', 230100);
INSERT INTO `dict_area` VALUES (230111, '呼兰区', 230100);
INSERT INTO `dict_area` VALUES (230112, '阿城区', 230100);
INSERT INTO `dict_area` VALUES (230113, '双城区', 230100);
INSERT INTO `dict_area` VALUES (230123, '依兰县', 230100);
INSERT INTO `dict_area` VALUES (230124, '方正县', 230100);
INSERT INTO `dict_area` VALUES (230125, '宾县', 230100);
INSERT INTO `dict_area` VALUES (230126, '巴彦县', 230100);
INSERT INTO `dict_area` VALUES (230127, '木兰县', 230100);
INSERT INTO `dict_area` VALUES (230128, '通河县', 230100);
INSERT INTO `dict_area` VALUES (230129, '延寿县', 230100);
INSERT INTO `dict_area` VALUES (230183, '尚志市', 230100);
INSERT INTO `dict_area` VALUES (230184, '五常市', 230100);
INSERT INTO `dict_area` VALUES (230200, '齐齐哈尔市', 230000);
INSERT INTO `dict_area` VALUES (230202, '龙沙区', 230200);
INSERT INTO `dict_area` VALUES (230203, '建华区', 230200);
INSERT INTO `dict_area` VALUES (230204, '铁锋区', 230200);
INSERT INTO `dict_area` VALUES (230205, '昂昂溪区', 230200);
INSERT INTO `dict_area` VALUES (230206, '富拉尔基区', 230200);
INSERT INTO `dict_area` VALUES (230207, '碾子山区', 230200);
INSERT INTO `dict_area` VALUES (230208, '梅里斯达斡尔族区', 230200);
INSERT INTO `dict_area` VALUES (230221, '龙江县', 230200);
INSERT INTO `dict_area` VALUES (230223, '依安县', 230200);
INSERT INTO `dict_area` VALUES (230224, '泰来县', 230200);
INSERT INTO `dict_area` VALUES (230225, '甘南县', 230200);
INSERT INTO `dict_area` VALUES (230227, '富裕县', 230200);
INSERT INTO `dict_area` VALUES (230229, '克山县', 230200);
INSERT INTO `dict_area` VALUES (230230, '克东县', 230200);
INSERT INTO `dict_area` VALUES (230231, '拜泉县', 230200);
INSERT INTO `dict_area` VALUES (230281, '讷河市', 230200);
INSERT INTO `dict_area` VALUES (230300, '鸡西市', 230000);
INSERT INTO `dict_area` VALUES (230302, '鸡冠区', 230300);
INSERT INTO `dict_area` VALUES (230303, '恒山区', 230300);
INSERT INTO `dict_area` VALUES (230304, '滴道区', 230300);
INSERT INTO `dict_area` VALUES (230305, '梨树区', 230300);
INSERT INTO `dict_area` VALUES (230306, '城子河区', 230300);
INSERT INTO `dict_area` VALUES (230307, '麻山区', 230300);
INSERT INTO `dict_area` VALUES (230321, '鸡东县', 230300);
INSERT INTO `dict_area` VALUES (230381, '虎林市', 230300);
INSERT INTO `dict_area` VALUES (230382, '密山市', 230300);
INSERT INTO `dict_area` VALUES (230400, '鹤岗市', 230000);
INSERT INTO `dict_area` VALUES (230402, '向阳区', 230400);
INSERT INTO `dict_area` VALUES (230403, '工农区', 230400);
INSERT INTO `dict_area` VALUES (230404, '南山区', 230400);
INSERT INTO `dict_area` VALUES (230405, '兴安区', 230400);
INSERT INTO `dict_area` VALUES (230406, '东山区', 230400);
INSERT INTO `dict_area` VALUES (230407, '兴山区', 230400);
INSERT INTO `dict_area` VALUES (230421, '萝北县', 230400);
INSERT INTO `dict_area` VALUES (230422, '绥滨县', 230400);
INSERT INTO `dict_area` VALUES (230500, '双鸭山市', 230000);
INSERT INTO `dict_area` VALUES (230502, '尖山区', 230500);
INSERT INTO `dict_area` VALUES (230503, '岭东区', 230500);
INSERT INTO `dict_area` VALUES (230505, '四方台区', 230500);
INSERT INTO `dict_area` VALUES (230506, '宝山区', 230500);
INSERT INTO `dict_area` VALUES (230521, '集贤县', 230500);
INSERT INTO `dict_area` VALUES (230522, '友谊县', 230500);
INSERT INTO `dict_area` VALUES (230523, '宝清县', 230500);
INSERT INTO `dict_area` VALUES (230524, '饶河县', 230500);
INSERT INTO `dict_area` VALUES (230600, '大庆市', 230000);
INSERT INTO `dict_area` VALUES (230602, '萨尔图区', 230600);
INSERT INTO `dict_area` VALUES (230603, '龙凤区', 230600);
INSERT INTO `dict_area` VALUES (230604, '让胡路区', 230600);
INSERT INTO `dict_area` VALUES (230605, '红岗区', 230600);
INSERT INTO `dict_area` VALUES (230606, '大同区', 230600);
INSERT INTO `dict_area` VALUES (230621, '肇州县', 230600);
INSERT INTO `dict_area` VALUES (230622, '肇源县', 230600);
INSERT INTO `dict_area` VALUES (230623, '林甸县', 230600);
INSERT INTO `dict_area` VALUES (230624, '杜尔伯特蒙古族自治县', 230600);
INSERT INTO `dict_area` VALUES (230700, '伊春市', 230000);
INSERT INTO `dict_area` VALUES (230702, '伊春区', 230700);
INSERT INTO `dict_area` VALUES (230703, '南岔区', 230700);
INSERT INTO `dict_area` VALUES (230704, '友好区', 230700);
INSERT INTO `dict_area` VALUES (230705, '西林区', 230700);
INSERT INTO `dict_area` VALUES (230706, '翠峦区', 230700);
INSERT INTO `dict_area` VALUES (230707, '新青区', 230700);
INSERT INTO `dict_area` VALUES (230708, '美溪区', 230700);
INSERT INTO `dict_area` VALUES (230709, '金山屯区', 230700);
INSERT INTO `dict_area` VALUES (230710, '五营区', 230700);
INSERT INTO `dict_area` VALUES (230711, '乌马河区', 230700);
INSERT INTO `dict_area` VALUES (230712, '汤旺河区', 230700);
INSERT INTO `dict_area` VALUES (230713, '带岭区', 230700);
INSERT INTO `dict_area` VALUES (230714, '乌伊岭区', 230700);
INSERT INTO `dict_area` VALUES (230715, '红星区', 230700);
INSERT INTO `dict_area` VALUES (230716, '上甘岭区', 230700);
INSERT INTO `dict_area` VALUES (230722, '嘉荫县', 230700);
INSERT INTO `dict_area` VALUES (230781, '铁力市', 230700);
INSERT INTO `dict_area` VALUES (230800, '佳木斯市', 230000);
INSERT INTO `dict_area` VALUES (230803, '向阳区', 230800);
INSERT INTO `dict_area` VALUES (230804, '前进区', 230800);
INSERT INTO `dict_area` VALUES (230805, '东风区', 230800);
INSERT INTO `dict_area` VALUES (230811, '郊区', 230800);
INSERT INTO `dict_area` VALUES (230822, '桦南县', 230800);
INSERT INTO `dict_area` VALUES (230826, '桦川县', 230800);
INSERT INTO `dict_area` VALUES (230828, '汤原县', 230800);
INSERT INTO `dict_area` VALUES (230881, '同江市', 230800);
INSERT INTO `dict_area` VALUES (230882, '富锦市', 230800);
INSERT INTO `dict_area` VALUES (230883, '抚远市', 230800);
INSERT INTO `dict_area` VALUES (230900, '七台河市', 230000);
INSERT INTO `dict_area` VALUES (230902, '新兴区', 230900);
INSERT INTO `dict_area` VALUES (230903, '桃山区', 230900);
INSERT INTO `dict_area` VALUES (230904, '茄子河区', 230900);
INSERT INTO `dict_area` VALUES (230921, '勃利县', 230900);
INSERT INTO `dict_area` VALUES (231000, '牡丹江市', 230000);
INSERT INTO `dict_area` VALUES (231002, '东安区', 231000);
INSERT INTO `dict_area` VALUES (231003, '阳明区', 231000);
INSERT INTO `dict_area` VALUES (231004, '爱民区', 231000);
INSERT INTO `dict_area` VALUES (231005, '西安区', 231000);
INSERT INTO `dict_area` VALUES (231025, '林口县', 231000);
INSERT INTO `dict_area` VALUES (231081, '绥芬河市', 231000);
INSERT INTO `dict_area` VALUES (231083, '海林市', 231000);
INSERT INTO `dict_area` VALUES (231084, '宁安市', 231000);
INSERT INTO `dict_area` VALUES (231085, '穆棱市', 231000);
INSERT INTO `dict_area` VALUES (231086, '东宁市', 231000);
INSERT INTO `dict_area` VALUES (231100, '黑河市', 230000);
INSERT INTO `dict_area` VALUES (231102, '爱辉区', 231100);
INSERT INTO `dict_area` VALUES (231121, '嫩江县', 231100);
INSERT INTO `dict_area` VALUES (231123, '逊克县', 231100);
INSERT INTO `dict_area` VALUES (231124, '孙吴县', 231100);
INSERT INTO `dict_area` VALUES (231181, '北安市', 231100);
INSERT INTO `dict_area` VALUES (231182, '五大连池市', 231100);
INSERT INTO `dict_area` VALUES (231200, '绥化市', 230000);
INSERT INTO `dict_area` VALUES (231202, '北林区', 231200);
INSERT INTO `dict_area` VALUES (231221, '望奎县', 231200);
INSERT INTO `dict_area` VALUES (231222, '兰西县', 231200);
INSERT INTO `dict_area` VALUES (231223, '青冈县', 231200);
INSERT INTO `dict_area` VALUES (231224, '庆安县', 231200);
INSERT INTO `dict_area` VALUES (231225, '明水县', 231200);
INSERT INTO `dict_area` VALUES (231226, '绥棱县', 231200);
INSERT INTO `dict_area` VALUES (231281, '安达市', 231200);
INSERT INTO `dict_area` VALUES (231282, '肇东市', 231200);
INSERT INTO `dict_area` VALUES (231283, '海伦市', 231200);
INSERT INTO `dict_area` VALUES (232700, '大兴安岭地区', 230000);
INSERT INTO `dict_area` VALUES (232701, '加格达奇区', 232700);
INSERT INTO `dict_area` VALUES (232721, '呼玛县', 232700);
INSERT INTO `dict_area` VALUES (232722, '塔河县', 232700);
INSERT INTO `dict_area` VALUES (232723, '漠河县', 232700);
INSERT INTO `dict_area` VALUES (310000, '上海市', NULL);
INSERT INTO `dict_area` VALUES (310101, '黄浦区', 310000);
INSERT INTO `dict_area` VALUES (310104, '徐汇区', 310000);
INSERT INTO `dict_area` VALUES (310105, '长宁区', 310000);
INSERT INTO `dict_area` VALUES (310106, '静安区', 310000);
INSERT INTO `dict_area` VALUES (310107, '普陀区', 310000);
INSERT INTO `dict_area` VALUES (310109, '虹口区', 310000);
INSERT INTO `dict_area` VALUES (310110, '杨浦区', 310000);
INSERT INTO `dict_area` VALUES (310112, '闵行区', 310000);
INSERT INTO `dict_area` VALUES (310113, '宝山区', 310000);
INSERT INTO `dict_area` VALUES (310114, '嘉定区', 310000);
INSERT INTO `dict_area` VALUES (310115, '浦东新区', 310000);
INSERT INTO `dict_area` VALUES (310116, '金山区', 310000);
INSERT INTO `dict_area` VALUES (310117, '松江区', 310000);
INSERT INTO `dict_area` VALUES (310118, '青浦区', 310000);
INSERT INTO `dict_area` VALUES (310120, '奉贤区', 310000);
INSERT INTO `dict_area` VALUES (310151, '崇明区', 310000);
INSERT INTO `dict_area` VALUES (320000, '江苏省', NULL);
INSERT INTO `dict_area` VALUES (320100, '南京市', 320000);
INSERT INTO `dict_area` VALUES (320102, '玄武区', 320100);
INSERT INTO `dict_area` VALUES (320104, '秦淮区', 320100);
INSERT INTO `dict_area` VALUES (320105, '建邺区', 320100);
INSERT INTO `dict_area` VALUES (320106, '鼓楼区', 320100);
INSERT INTO `dict_area` VALUES (320111, '浦口区', 320100);
INSERT INTO `dict_area` VALUES (320113, '栖霞区', 320100);
INSERT INTO `dict_area` VALUES (320114, '雨花台区', 320100);
INSERT INTO `dict_area` VALUES (320115, '江宁区', 320100);
INSERT INTO `dict_area` VALUES (320116, '六合区', 320100);
INSERT INTO `dict_area` VALUES (320117, '溧水区', 320100);
INSERT INTO `dict_area` VALUES (320118, '高淳区', 320100);
INSERT INTO `dict_area` VALUES (320200, '无锡市', 320000);
INSERT INTO `dict_area` VALUES (320205, '锡山区', 320200);
INSERT INTO `dict_area` VALUES (320206, '惠山区', 320200);
INSERT INTO `dict_area` VALUES (320211, '滨湖区', 320200);
INSERT INTO `dict_area` VALUES (320213, '梁溪区', 320200);
INSERT INTO `dict_area` VALUES (320214, '新吴区', 320200);
INSERT INTO `dict_area` VALUES (320281, '江阴市', 320200);
INSERT INTO `dict_area` VALUES (320282, '宜兴市', 320200);
INSERT INTO `dict_area` VALUES (320300, '徐州市', 320000);
INSERT INTO `dict_area` VALUES (320302, '鼓楼区', 320300);
INSERT INTO `dict_area` VALUES (320303, '云龙区', 320300);
INSERT INTO `dict_area` VALUES (320305, '贾汪区', 320300);
INSERT INTO `dict_area` VALUES (320311, '泉山区', 320300);
INSERT INTO `dict_area` VALUES (320312, '铜山区', 320300);
INSERT INTO `dict_area` VALUES (320321, '丰县', 320300);
INSERT INTO `dict_area` VALUES (320322, '沛县', 320300);
INSERT INTO `dict_area` VALUES (320324, '睢宁县', 320300);
INSERT INTO `dict_area` VALUES (320381, '新沂市', 320300);
INSERT INTO `dict_area` VALUES (320382, '邳州市', 320300);
INSERT INTO `dict_area` VALUES (320400, '常州市', 320000);
INSERT INTO `dict_area` VALUES (320402, '天宁区', 320400);
INSERT INTO `dict_area` VALUES (320404, '钟楼区', 320400);
INSERT INTO `dict_area` VALUES (320411, '新北区', 320400);
INSERT INTO `dict_area` VALUES (320412, '武进区', 320400);
INSERT INTO `dict_area` VALUES (320413, '金坛区', 320400);
INSERT INTO `dict_area` VALUES (320481, '溧阳市', 320400);
INSERT INTO `dict_area` VALUES (320500, '苏州市', 320000);
INSERT INTO `dict_area` VALUES (320505, '虎丘区', 320500);
INSERT INTO `dict_area` VALUES (320506, '吴中区', 320500);
INSERT INTO `dict_area` VALUES (320507, '相城区', 320500);
INSERT INTO `dict_area` VALUES (320508, '姑苏区', 320500);
INSERT INTO `dict_area` VALUES (320509, '吴江区', 320500);
INSERT INTO `dict_area` VALUES (320581, '常熟市', 320500);
INSERT INTO `dict_area` VALUES (320582, '张家港市', 320500);
INSERT INTO `dict_area` VALUES (320583, '昆山市', 320500);
INSERT INTO `dict_area` VALUES (320585, '太仓市', 320500);
INSERT INTO `dict_area` VALUES (320600, '南通市', 320000);
INSERT INTO `dict_area` VALUES (320602, '崇川区', 320600);
INSERT INTO `dict_area` VALUES (320611, '港闸区', 320600);
INSERT INTO `dict_area` VALUES (320612, '通州区', 320600);
INSERT INTO `dict_area` VALUES (320621, '海安县', 320600);
INSERT INTO `dict_area` VALUES (320623, '如东县', 320600);
INSERT INTO `dict_area` VALUES (320681, '启东市', 320600);
INSERT INTO `dict_area` VALUES (320682, '如皋市', 320600);
INSERT INTO `dict_area` VALUES (320684, '海门市', 320600);
INSERT INTO `dict_area` VALUES (320700, '连云港市', 320000);
INSERT INTO `dict_area` VALUES (320703, '连云区', 320700);
INSERT INTO `dict_area` VALUES (320706, '海州区', 320700);
INSERT INTO `dict_area` VALUES (320707, '赣榆区', 320700);
INSERT INTO `dict_area` VALUES (320722, '东海县', 320700);
INSERT INTO `dict_area` VALUES (320723, '灌云县', 320700);
INSERT INTO `dict_area` VALUES (320724, '灌南县', 320700);
INSERT INTO `dict_area` VALUES (320800, '淮安市', 320000);
INSERT INTO `dict_area` VALUES (320803, '淮安区', 320800);
INSERT INTO `dict_area` VALUES (320804, '淮阴区', 320800);
INSERT INTO `dict_area` VALUES (320812, '清江浦区', 320800);
INSERT INTO `dict_area` VALUES (320813, '洪泽区', 320800);
INSERT INTO `dict_area` VALUES (320826, '涟水县', 320800);
INSERT INTO `dict_area` VALUES (320830, '盱眙县', 320800);
INSERT INTO `dict_area` VALUES (320831, '金湖县', 320800);
INSERT INTO `dict_area` VALUES (320900, '盐城市', 320000);
INSERT INTO `dict_area` VALUES (320902, '亭湖区', 320900);
INSERT INTO `dict_area` VALUES (320903, '盐都区', 320900);
INSERT INTO `dict_area` VALUES (320904, '大丰区', 320900);
INSERT INTO `dict_area` VALUES (320921, '响水县', 320900);
INSERT INTO `dict_area` VALUES (320922, '滨海县', 320900);
INSERT INTO `dict_area` VALUES (320923, '阜宁县', 320900);
INSERT INTO `dict_area` VALUES (320924, '射阳县', 320900);
INSERT INTO `dict_area` VALUES (320925, '建湖县', 320900);
INSERT INTO `dict_area` VALUES (320981, '东台市', 320900);
INSERT INTO `dict_area` VALUES (321000, '扬州市', 320000);
INSERT INTO `dict_area` VALUES (321002, '广陵区', 321000);
INSERT INTO `dict_area` VALUES (321003, '邗江区', 321000);
INSERT INTO `dict_area` VALUES (321012, '江都区', 321000);
INSERT INTO `dict_area` VALUES (321023, '宝应县', 321000);
INSERT INTO `dict_area` VALUES (321081, '仪征市', 321000);
INSERT INTO `dict_area` VALUES (321084, '高邮市', 321000);
INSERT INTO `dict_area` VALUES (321100, '镇江市', 320000);
INSERT INTO `dict_area` VALUES (321102, '京口区', 321100);
INSERT INTO `dict_area` VALUES (321111, '润州区', 321100);
INSERT INTO `dict_area` VALUES (321112, '丹徒区', 321100);
INSERT INTO `dict_area` VALUES (321181, '丹阳市', 321100);
INSERT INTO `dict_area` VALUES (321182, '扬中市', 321100);
INSERT INTO `dict_area` VALUES (321183, '句容市', 321100);
INSERT INTO `dict_area` VALUES (321200, '泰州市', 320000);
INSERT INTO `dict_area` VALUES (321202, '海陵区', 321200);
INSERT INTO `dict_area` VALUES (321203, '高港区', 321200);
INSERT INTO `dict_area` VALUES (321204, '姜堰区', 321200);
INSERT INTO `dict_area` VALUES (321281, '兴化市', 321200);
INSERT INTO `dict_area` VALUES (321282, '靖江市', 321200);
INSERT INTO `dict_area` VALUES (321283, '泰兴市', 321200);
INSERT INTO `dict_area` VALUES (321300, '宿迁市', 320000);
INSERT INTO `dict_area` VALUES (321302, '宿城区', 321300);
INSERT INTO `dict_area` VALUES (321311, '宿豫区', 321300);
INSERT INTO `dict_area` VALUES (321322, '沭阳县', 321300);
INSERT INTO `dict_area` VALUES (321323, '泗阳县', 321300);
INSERT INTO `dict_area` VALUES (321324, '泗洪县', 321300);
INSERT INTO `dict_area` VALUES (330000, '浙江省', NULL);
INSERT INTO `dict_area` VALUES (330100, '杭州市', 330000);
INSERT INTO `dict_area` VALUES (330102, '上城区', 330100);
INSERT INTO `dict_area` VALUES (330103, '下城区', 330100);
INSERT INTO `dict_area` VALUES (330104, '江干区', 330100);
INSERT INTO `dict_area` VALUES (330105, '拱墅区', 330100);
INSERT INTO `dict_area` VALUES (330106, '西湖区', 330100);
INSERT INTO `dict_area` VALUES (330108, '滨江区', 330100);
INSERT INTO `dict_area` VALUES (330109, '萧山区', 330100);
INSERT INTO `dict_area` VALUES (330110, '余杭区', 330100);
INSERT INTO `dict_area` VALUES (330111, '富阳区', 330100);
INSERT INTO `dict_area` VALUES (330122, '桐庐县', 330100);
INSERT INTO `dict_area` VALUES (330127, '淳安县', 330100);
INSERT INTO `dict_area` VALUES (330182, '建德市', 330100);
INSERT INTO `dict_area` VALUES (330185, '临安市', 330100);
INSERT INTO `dict_area` VALUES (330200, '宁波市', 330000);
INSERT INTO `dict_area` VALUES (330203, '海曙区', 330200);
INSERT INTO `dict_area` VALUES (330205, '江北区', 330200);
INSERT INTO `dict_area` VALUES (330206, '北仑区', 330200);
INSERT INTO `dict_area` VALUES (330211, '镇海区', 330200);
INSERT INTO `dict_area` VALUES (330212, '鄞州区', 330200);
INSERT INTO `dict_area` VALUES (330213, '奉化区', 330200);
INSERT INTO `dict_area` VALUES (330225, '象山县', 330200);
INSERT INTO `dict_area` VALUES (330226, '宁海县', 330200);
INSERT INTO `dict_area` VALUES (330281, '余姚市', 330200);
INSERT INTO `dict_area` VALUES (330282, '慈溪市', 330200);
INSERT INTO `dict_area` VALUES (330300, '温州市', 330000);
INSERT INTO `dict_area` VALUES (330302, '鹿城区', 330300);
INSERT INTO `dict_area` VALUES (330303, '龙湾区', 330300);
INSERT INTO `dict_area` VALUES (330304, '瓯海区', 330300);
INSERT INTO `dict_area` VALUES (330305, '洞头区', 330300);
INSERT INTO `dict_area` VALUES (330324, '永嘉县', 330300);
INSERT INTO `dict_area` VALUES (330326, '平阳县', 330300);
INSERT INTO `dict_area` VALUES (330327, '苍南县', 330300);
INSERT INTO `dict_area` VALUES (330328, '文成县', 330300);
INSERT INTO `dict_area` VALUES (330329, '泰顺县', 330300);
INSERT INTO `dict_area` VALUES (330381, '瑞安市', 330300);
INSERT INTO `dict_area` VALUES (330382, '乐清市', 330300);
INSERT INTO `dict_area` VALUES (330400, '嘉兴市', 330000);
INSERT INTO `dict_area` VALUES (330402, '南湖区', 330400);
INSERT INTO `dict_area` VALUES (330411, '秀洲区', 330400);
INSERT INTO `dict_area` VALUES (330421, '嘉善县', 330400);
INSERT INTO `dict_area` VALUES (330424, '海盐县', 330400);
INSERT INTO `dict_area` VALUES (330481, '海宁市', 330400);
INSERT INTO `dict_area` VALUES (330482, '平湖市', 330400);
INSERT INTO `dict_area` VALUES (330483, '桐乡市', 330400);
INSERT INTO `dict_area` VALUES (330500, '湖州市', 330000);
INSERT INTO `dict_area` VALUES (330502, '吴兴区', 330500);
INSERT INTO `dict_area` VALUES (330503, '南浔区', 330500);
INSERT INTO `dict_area` VALUES (330521, '德清县', 330500);
INSERT INTO `dict_area` VALUES (330522, '长兴县', 330500);
INSERT INTO `dict_area` VALUES (330523, '安吉县', 330500);
INSERT INTO `dict_area` VALUES (330600, '绍兴市', 330000);
INSERT INTO `dict_area` VALUES (330602, '越城区', 330600);
INSERT INTO `dict_area` VALUES (330603, '柯桥区', 330600);
INSERT INTO `dict_area` VALUES (330604, '上虞区', 330600);
INSERT INTO `dict_area` VALUES (330624, '新昌县', 330600);
INSERT INTO `dict_area` VALUES (330681, '诸暨市', 330600);
INSERT INTO `dict_area` VALUES (330683, '嵊州市', 330600);
INSERT INTO `dict_area` VALUES (330700, '金华市', 330000);
INSERT INTO `dict_area` VALUES (330702, '婺城区', 330700);
INSERT INTO `dict_area` VALUES (330703, '金东区', 330700);
INSERT INTO `dict_area` VALUES (330723, '武义县', 330700);
INSERT INTO `dict_area` VALUES (330726, '浦江县', 330700);
INSERT INTO `dict_area` VALUES (330727, '磐安县', 330700);
INSERT INTO `dict_area` VALUES (330781, '兰溪市', 330700);
INSERT INTO `dict_area` VALUES (330782, '义乌市', 330700);
INSERT INTO `dict_area` VALUES (330783, '东阳市', 330700);
INSERT INTO `dict_area` VALUES (330784, '永康市', 330700);
INSERT INTO `dict_area` VALUES (330800, '衢州市', 330000);
INSERT INTO `dict_area` VALUES (330802, '柯城区', 330800);
INSERT INTO `dict_area` VALUES (330803, '衢江区', 330800);
INSERT INTO `dict_area` VALUES (330822, '常山县', 330800);
INSERT INTO `dict_area` VALUES (330824, '开化县', 330800);
INSERT INTO `dict_area` VALUES (330825, '龙游县', 330800);
INSERT INTO `dict_area` VALUES (330881, '江山市', 330800);
INSERT INTO `dict_area` VALUES (330900, '舟山市', 330000);
INSERT INTO `dict_area` VALUES (330902, '定海区', 330900);
INSERT INTO `dict_area` VALUES (330903, '普陀区', 330900);
INSERT INTO `dict_area` VALUES (330921, '岱山县', 330900);
INSERT INTO `dict_area` VALUES (330922, '嵊泗县', 330900);
INSERT INTO `dict_area` VALUES (331000, '台州市', 330000);
INSERT INTO `dict_area` VALUES (331002, '椒江区', 331000);
INSERT INTO `dict_area` VALUES (331003, '黄岩区', 331000);
INSERT INTO `dict_area` VALUES (331004, '路桥区', 331000);
INSERT INTO `dict_area` VALUES (331022, '三门县', 331000);
INSERT INTO `dict_area` VALUES (331023, '天台县', 331000);
INSERT INTO `dict_area` VALUES (331024, '仙居县', 331000);
INSERT INTO `dict_area` VALUES (331081, '温岭市', 331000);
INSERT INTO `dict_area` VALUES (331082, '临海市', 331000);
INSERT INTO `dict_area` VALUES (331083, '玉环市', 331000);
INSERT INTO `dict_area` VALUES (331100, '丽水市', 330000);
INSERT INTO `dict_area` VALUES (331102, '莲都区', 331100);
INSERT INTO `dict_area` VALUES (331121, '青田县', 331100);
INSERT INTO `dict_area` VALUES (331122, '缙云县', 331100);
INSERT INTO `dict_area` VALUES (331123, '遂昌县', 331100);
INSERT INTO `dict_area` VALUES (331124, '松阳县', 331100);
INSERT INTO `dict_area` VALUES (331125, '云和县', 331100);
INSERT INTO `dict_area` VALUES (331126, '庆元县', 331100);
INSERT INTO `dict_area` VALUES (331127, '景宁畲族自治县', 331100);
INSERT INTO `dict_area` VALUES (331181, '龙泉市', 331100);
INSERT INTO `dict_area` VALUES (340000, '安徽省', NULL);
INSERT INTO `dict_area` VALUES (340100, '合肥市', 340000);
INSERT INTO `dict_area` VALUES (340102, '瑶海区', 340100);
INSERT INTO `dict_area` VALUES (340103, '庐阳区', 340100);
INSERT INTO `dict_area` VALUES (340104, '蜀山区', 340100);
INSERT INTO `dict_area` VALUES (340111, '包河区', 340100);
INSERT INTO `dict_area` VALUES (340121, '长丰县', 340100);
INSERT INTO `dict_area` VALUES (340122, '肥东县', 340100);
INSERT INTO `dict_area` VALUES (340123, '肥西县', 340100);
INSERT INTO `dict_area` VALUES (340124, '庐江县', 340100);
INSERT INTO `dict_area` VALUES (340181, '巢湖市', 340100);
INSERT INTO `dict_area` VALUES (340200, '芜湖市', 340000);
INSERT INTO `dict_area` VALUES (340202, '镜湖区', 340200);
INSERT INTO `dict_area` VALUES (340203, '弋江区', 340200);
INSERT INTO `dict_area` VALUES (340207, '鸠江区', 340200);
INSERT INTO `dict_area` VALUES (340208, '三山区', 340200);
INSERT INTO `dict_area` VALUES (340221, '芜湖县', 340200);
INSERT INTO `dict_area` VALUES (340222, '繁昌县', 340200);
INSERT INTO `dict_area` VALUES (340223, '南陵县', 340200);
INSERT INTO `dict_area` VALUES (340225, '无为县', 340200);
INSERT INTO `dict_area` VALUES (340300, '蚌埠市', 340000);
INSERT INTO `dict_area` VALUES (340302, '龙子湖区', 340300);
INSERT INTO `dict_area` VALUES (340303, '蚌山区', 340300);
INSERT INTO `dict_area` VALUES (340304, '禹会区', 340300);
INSERT INTO `dict_area` VALUES (340311, '淮上区', 340300);
INSERT INTO `dict_area` VALUES (340321, '怀远县', 340300);
INSERT INTO `dict_area` VALUES (340322, '五河县', 340300);
INSERT INTO `dict_area` VALUES (340323, '固镇县', 340300);
INSERT INTO `dict_area` VALUES (340400, '淮南市', 340000);
INSERT INTO `dict_area` VALUES (340402, '大通区', 340400);
INSERT INTO `dict_area` VALUES (340403, '田家庵区', 340400);
INSERT INTO `dict_area` VALUES (340404, '谢家集区', 340400);
INSERT INTO `dict_area` VALUES (340405, '八公山区', 340400);
INSERT INTO `dict_area` VALUES (340406, '潘集区', 340400);
INSERT INTO `dict_area` VALUES (340421, '凤台县', 340400);
INSERT INTO `dict_area` VALUES (340422, '寿县', 340400);
INSERT INTO `dict_area` VALUES (340500, '马鞍山市', 340000);
INSERT INTO `dict_area` VALUES (340503, '花山区', 340500);
INSERT INTO `dict_area` VALUES (340504, '雨山区', 340500);
INSERT INTO `dict_area` VALUES (340506, '博望区', 340500);
INSERT INTO `dict_area` VALUES (340521, '当涂县', 340500);
INSERT INTO `dict_area` VALUES (340522, '含山县', 340500);
INSERT INTO `dict_area` VALUES (340523, '和县', 340500);
INSERT INTO `dict_area` VALUES (340600, '淮北市', 340000);
INSERT INTO `dict_area` VALUES (340602, '杜集区', 340600);
INSERT INTO `dict_area` VALUES (340603, '相山区', 340600);
INSERT INTO `dict_area` VALUES (340604, '烈山区', 340600);
INSERT INTO `dict_area` VALUES (340621, '濉溪县', 340600);
INSERT INTO `dict_area` VALUES (340700, '铜陵市', 340000);
INSERT INTO `dict_area` VALUES (340705, '铜官区', 340700);
INSERT INTO `dict_area` VALUES (340706, '义安区', 340700);
INSERT INTO `dict_area` VALUES (340711, '郊区', 340700);
INSERT INTO `dict_area` VALUES (340722, '枞阳县', 340700);
INSERT INTO `dict_area` VALUES (340800, '安庆市', 340000);
INSERT INTO `dict_area` VALUES (340802, '迎江区', 340800);
INSERT INTO `dict_area` VALUES (340803, '大观区', 340800);
INSERT INTO `dict_area` VALUES (340811, '宜秀区', 340800);
INSERT INTO `dict_area` VALUES (340822, '怀宁县', 340800);
INSERT INTO `dict_area` VALUES (340824, '潜山县', 340800);
INSERT INTO `dict_area` VALUES (340825, '太湖县', 340800);
INSERT INTO `dict_area` VALUES (340826, '宿松县', 340800);
INSERT INTO `dict_area` VALUES (340827, '望江县', 340800);
INSERT INTO `dict_area` VALUES (340828, '岳西县', 340800);
INSERT INTO `dict_area` VALUES (340881, '桐城市', 340800);
INSERT INTO `dict_area` VALUES (341000, '黄山市', 340000);
INSERT INTO `dict_area` VALUES (341002, '屯溪区', 341000);
INSERT INTO `dict_area` VALUES (341003, '黄山区', 341000);
INSERT INTO `dict_area` VALUES (341004, '徽州区', 341000);
INSERT INTO `dict_area` VALUES (341021, '歙县', 341000);
INSERT INTO `dict_area` VALUES (341022, '休宁县', 341000);
INSERT INTO `dict_area` VALUES (341023, '黟县', 341000);
INSERT INTO `dict_area` VALUES (341024, '祁门县', 341000);
INSERT INTO `dict_area` VALUES (341100, '滁州市', 340000);
INSERT INTO `dict_area` VALUES (341102, '琅琊区', 341100);
INSERT INTO `dict_area` VALUES (341103, '南谯区', 341100);
INSERT INTO `dict_area` VALUES (341122, '来安县', 341100);
INSERT INTO `dict_area` VALUES (341124, '全椒县', 341100);
INSERT INTO `dict_area` VALUES (341125, '定远县', 341100);
INSERT INTO `dict_area` VALUES (341126, '凤阳县', 341100);
INSERT INTO `dict_area` VALUES (341181, '天长市', 341100);
INSERT INTO `dict_area` VALUES (341182, '明光市', 341100);
INSERT INTO `dict_area` VALUES (341200, '阜阳市', 340000);
INSERT INTO `dict_area` VALUES (341202, '颍州区', 341200);
INSERT INTO `dict_area` VALUES (341203, '颍东区', 341200);
INSERT INTO `dict_area` VALUES (341204, '颍泉区', 341200);
INSERT INTO `dict_area` VALUES (341221, '临泉县', 341200);
INSERT INTO `dict_area` VALUES (341222, '太和县', 341200);
INSERT INTO `dict_area` VALUES (341225, '阜南县', 341200);
INSERT INTO `dict_area` VALUES (341226, '颍上县', 341200);
INSERT INTO `dict_area` VALUES (341282, '界首市', 341200);
INSERT INTO `dict_area` VALUES (341300, '宿州市', 340000);
INSERT INTO `dict_area` VALUES (341302, '埇桥区', 341300);
INSERT INTO `dict_area` VALUES (341321, '砀山县', 341300);
INSERT INTO `dict_area` VALUES (341322, '萧县', 341300);
INSERT INTO `dict_area` VALUES (341323, '灵璧县', 341300);
INSERT INTO `dict_area` VALUES (341324, '泗县', 341300);
INSERT INTO `dict_area` VALUES (341500, '六安市', 340000);
INSERT INTO `dict_area` VALUES (341502, '金安区', 341500);
INSERT INTO `dict_area` VALUES (341503, '裕安区', 341500);
INSERT INTO `dict_area` VALUES (341504, '叶集区', 341500);
INSERT INTO `dict_area` VALUES (341522, '霍邱县', 341500);
INSERT INTO `dict_area` VALUES (341523, '舒城县', 341500);
INSERT INTO `dict_area` VALUES (341524, '金寨县', 341500);
INSERT INTO `dict_area` VALUES (341525, '霍山县', 341500);
INSERT INTO `dict_area` VALUES (341600, '亳州市', 340000);
INSERT INTO `dict_area` VALUES (341602, '谯城区', 341600);
INSERT INTO `dict_area` VALUES (341621, '涡阳县', 341600);
INSERT INTO `dict_area` VALUES (341622, '蒙城县', 341600);
INSERT INTO `dict_area` VALUES (341623, '利辛县', 341600);
INSERT INTO `dict_area` VALUES (341700, '池州市', 340000);
INSERT INTO `dict_area` VALUES (341702, '贵池区', 341700);
INSERT INTO `dict_area` VALUES (341721, '东至县', 341700);
INSERT INTO `dict_area` VALUES (341722, '石台县', 341700);
INSERT INTO `dict_area` VALUES (341723, '青阳县', 341700);
INSERT INTO `dict_area` VALUES (341800, '宣城市', 340000);
INSERT INTO `dict_area` VALUES (341802, '宣州区', 341800);
INSERT INTO `dict_area` VALUES (341821, '郎溪县', 341800);
INSERT INTO `dict_area` VALUES (341822, '广德县', 341800);
INSERT INTO `dict_area` VALUES (341823, '泾县', 341800);
INSERT INTO `dict_area` VALUES (341824, '绩溪县', 341800);
INSERT INTO `dict_area` VALUES (341825, '旌德县', 341800);
INSERT INTO `dict_area` VALUES (341881, '宁国市', 341800);
INSERT INTO `dict_area` VALUES (350000, '福建省', NULL);
INSERT INTO `dict_area` VALUES (350100, '福州市', 350000);
INSERT INTO `dict_area` VALUES (350102, '鼓楼区', 350100);
INSERT INTO `dict_area` VALUES (350103, '台江区', 350100);
INSERT INTO `dict_area` VALUES (350104, '仓山区', 350100);
INSERT INTO `dict_area` VALUES (350105, '马尾区', 350100);
INSERT INTO `dict_area` VALUES (350111, '晋安区', 350100);
INSERT INTO `dict_area` VALUES (350121, '闽侯县', 350100);
INSERT INTO `dict_area` VALUES (350122, '连江县', 350100);
INSERT INTO `dict_area` VALUES (350123, '罗源县', 350100);
INSERT INTO `dict_area` VALUES (350124, '闽清县', 350100);
INSERT INTO `dict_area` VALUES (350125, '永泰县', 350100);
INSERT INTO `dict_area` VALUES (350128, '平潭县', 350100);
INSERT INTO `dict_area` VALUES (350181, '福清市', 350100);
INSERT INTO `dict_area` VALUES (350182, '长乐市', 350100);
INSERT INTO `dict_area` VALUES (350200, '厦门市', 350000);
INSERT INTO `dict_area` VALUES (350203, '思明区', 350200);
INSERT INTO `dict_area` VALUES (350205, '海沧区', 350200);
INSERT INTO `dict_area` VALUES (350206, '湖里区', 350200);
INSERT INTO `dict_area` VALUES (350211, '集美区', 350200);
INSERT INTO `dict_area` VALUES (350212, '同安区', 350200);
INSERT INTO `dict_area` VALUES (350213, '翔安区', 350200);
INSERT INTO `dict_area` VALUES (350300, '莆田市', 350000);
INSERT INTO `dict_area` VALUES (350302, '城厢区', 350300);
INSERT INTO `dict_area` VALUES (350303, '涵江区', 350300);
INSERT INTO `dict_area` VALUES (350304, '荔城区', 350300);
INSERT INTO `dict_area` VALUES (350305, '秀屿区', 350300);
INSERT INTO `dict_area` VALUES (350322, '仙游县', 350300);
INSERT INTO `dict_area` VALUES (350400, '三明市', 350000);
INSERT INTO `dict_area` VALUES (350402, '梅列区', 350400);
INSERT INTO `dict_area` VALUES (350403, '三元区', 350400);
INSERT INTO `dict_area` VALUES (350421, '明溪县', 350400);
INSERT INTO `dict_area` VALUES (350423, '清流县', 350400);
INSERT INTO `dict_area` VALUES (350424, '宁化县', 350400);
INSERT INTO `dict_area` VALUES (350425, '大田县', 350400);
INSERT INTO `dict_area` VALUES (350426, '尤溪县', 350400);
INSERT INTO `dict_area` VALUES (350427, '沙县', 350400);
INSERT INTO `dict_area` VALUES (350428, '将乐县', 350400);
INSERT INTO `dict_area` VALUES (350429, '泰宁县', 350400);
INSERT INTO `dict_area` VALUES (350430, '建宁县', 350400);
INSERT INTO `dict_area` VALUES (350481, '永安市', 350400);
INSERT INTO `dict_area` VALUES (350500, '泉州市', 350000);
INSERT INTO `dict_area` VALUES (350502, '鲤城区', 350500);
INSERT INTO `dict_area` VALUES (350503, '丰泽区', 350500);
INSERT INTO `dict_area` VALUES (350504, '洛江区', 350500);
INSERT INTO `dict_area` VALUES (350505, '泉港区', 350500);
INSERT INTO `dict_area` VALUES (350521, '惠安县', 350500);
INSERT INTO `dict_area` VALUES (350524, '安溪县', 350500);
INSERT INTO `dict_area` VALUES (350525, '永春县', 350500);
INSERT INTO `dict_area` VALUES (350526, '德化县', 350500);
INSERT INTO `dict_area` VALUES (350527, '金门县', 350500);
INSERT INTO `dict_area` VALUES (350581, '石狮市', 350500);
INSERT INTO `dict_area` VALUES (350582, '晋江市', 350500);
INSERT INTO `dict_area` VALUES (350583, '南安市', 350500);
INSERT INTO `dict_area` VALUES (350600, '漳州市', 350000);
INSERT INTO `dict_area` VALUES (350602, '芗城区', 350600);
INSERT INTO `dict_area` VALUES (350603, '龙文区', 350600);
INSERT INTO `dict_area` VALUES (350622, '云霄县', 350600);
INSERT INTO `dict_area` VALUES (350623, '漳浦县', 350600);
INSERT INTO `dict_area` VALUES (350624, '诏安县', 350600);
INSERT INTO `dict_area` VALUES (350625, '长泰县', 350600);
INSERT INTO `dict_area` VALUES (350626, '东山县', 350600);
INSERT INTO `dict_area` VALUES (350627, '南靖县', 350600);
INSERT INTO `dict_area` VALUES (350628, '平和县', 350600);
INSERT INTO `dict_area` VALUES (350629, '华安县', 350600);
INSERT INTO `dict_area` VALUES (350681, '龙海市', 350600);
INSERT INTO `dict_area` VALUES (350700, '南平市', 350000);
INSERT INTO `dict_area` VALUES (350702, '延平区', 350700);
INSERT INTO `dict_area` VALUES (350703, '建阳区', 350700);
INSERT INTO `dict_area` VALUES (350721, '顺昌县', 350700);
INSERT INTO `dict_area` VALUES (350722, '浦城县', 350700);
INSERT INTO `dict_area` VALUES (350723, '光泽县', 350700);
INSERT INTO `dict_area` VALUES (350724, '松溪县', 350700);
INSERT INTO `dict_area` VALUES (350725, '政和县', 350700);
INSERT INTO `dict_area` VALUES (350781, '邵武市', 350700);
INSERT INTO `dict_area` VALUES (350782, '武夷山市', 350700);
INSERT INTO `dict_area` VALUES (350783, '建瓯市', 350700);
INSERT INTO `dict_area` VALUES (350800, '龙岩市', 350000);
INSERT INTO `dict_area` VALUES (350802, '新罗区', 350800);
INSERT INTO `dict_area` VALUES (350803, '永定区', 350800);
INSERT INTO `dict_area` VALUES (350821, '长汀县', 350800);
INSERT INTO `dict_area` VALUES (350823, '上杭县', 350800);
INSERT INTO `dict_area` VALUES (350824, '武平县', 350800);
INSERT INTO `dict_area` VALUES (350825, '连城县', 350800);
INSERT INTO `dict_area` VALUES (350881, '漳平市', 350800);
INSERT INTO `dict_area` VALUES (350900, '宁德市', 350000);
INSERT INTO `dict_area` VALUES (350902, '蕉城区', 350900);
INSERT INTO `dict_area` VALUES (350921, '霞浦县', 350900);
INSERT INTO `dict_area` VALUES (350922, '古田县', 350900);
INSERT INTO `dict_area` VALUES (350923, '屏南县', 350900);
INSERT INTO `dict_area` VALUES (350924, '寿宁县', 350900);
INSERT INTO `dict_area` VALUES (350925, '周宁县', 350900);
INSERT INTO `dict_area` VALUES (350926, '柘荣县', 350900);
INSERT INTO `dict_area` VALUES (350981, '福安市', 350900);
INSERT INTO `dict_area` VALUES (350982, '福鼎市', 350900);
INSERT INTO `dict_area` VALUES (360000, '江西省', NULL);
INSERT INTO `dict_area` VALUES (360100, '南昌市', 360000);
INSERT INTO `dict_area` VALUES (360102, '东湖区', 360100);
INSERT INTO `dict_area` VALUES (360103, '西湖区', 360100);
INSERT INTO `dict_area` VALUES (360104, '青云谱区', 360100);
INSERT INTO `dict_area` VALUES (360105, '湾里区', 360100);
INSERT INTO `dict_area` VALUES (360111, '青山湖区', 360100);
INSERT INTO `dict_area` VALUES (360112, '新建区', 360100);
INSERT INTO `dict_area` VALUES (360121, '南昌县', 360100);
INSERT INTO `dict_area` VALUES (360123, '安义县', 360100);
INSERT INTO `dict_area` VALUES (360124, '进贤县', 360100);
INSERT INTO `dict_area` VALUES (360200, '景德镇市', 360000);
INSERT INTO `dict_area` VALUES (360202, '昌江区', 360200);
INSERT INTO `dict_area` VALUES (360203, '珠山区', 360200);
INSERT INTO `dict_area` VALUES (360222, '浮梁县', 360200);
INSERT INTO `dict_area` VALUES (360281, '乐平市', 360200);
INSERT INTO `dict_area` VALUES (360300, '萍乡市', 360000);
INSERT INTO `dict_area` VALUES (360302, '安源区', 360300);
INSERT INTO `dict_area` VALUES (360313, '湘东区', 360300);
INSERT INTO `dict_area` VALUES (360321, '莲花县', 360300);
INSERT INTO `dict_area` VALUES (360322, '上栗县', 360300);
INSERT INTO `dict_area` VALUES (360323, '芦溪县', 360300);
INSERT INTO `dict_area` VALUES (360400, '九江市', 360000);
INSERT INTO `dict_area` VALUES (360402, '濂溪区', 360400);
INSERT INTO `dict_area` VALUES (360403, '浔阳区', 360400);
INSERT INTO `dict_area` VALUES (360421, '九江县', 360400);
INSERT INTO `dict_area` VALUES (360423, '武宁县', 360400);
INSERT INTO `dict_area` VALUES (360424, '修水县', 360400);
INSERT INTO `dict_area` VALUES (360425, '永修县', 360400);
INSERT INTO `dict_area` VALUES (360426, '德安县', 360400);
INSERT INTO `dict_area` VALUES (360428, '都昌县', 360400);
INSERT INTO `dict_area` VALUES (360429, '湖口县', 360400);
INSERT INTO `dict_area` VALUES (360430, '彭泽县', 360400);
INSERT INTO `dict_area` VALUES (360481, '瑞昌市', 360400);
INSERT INTO `dict_area` VALUES (360482, '共青城市', 360400);
INSERT INTO `dict_area` VALUES (360483, '庐山市', 360400);
INSERT INTO `dict_area` VALUES (360500, '新余市', 360000);
INSERT INTO `dict_area` VALUES (360502, '渝水区', 360500);
INSERT INTO `dict_area` VALUES (360521, '分宜县', 360500);
INSERT INTO `dict_area` VALUES (360600, '鹰潭市', 360000);
INSERT INTO `dict_area` VALUES (360602, '月湖区', 360600);
INSERT INTO `dict_area` VALUES (360622, '余江县', 360600);
INSERT INTO `dict_area` VALUES (360681, '贵溪市', 360600);
INSERT INTO `dict_area` VALUES (360700, '赣州市', 360000);
INSERT INTO `dict_area` VALUES (360702, '章贡区', 360700);
INSERT INTO `dict_area` VALUES (360703, '南康区', 360700);
INSERT INTO `dict_area` VALUES (360704, '赣县区', 360700);
INSERT INTO `dict_area` VALUES (360722, '信丰县', 360700);
INSERT INTO `dict_area` VALUES (360723, '大余县', 360700);
INSERT INTO `dict_area` VALUES (360724, '上犹县', 360700);
INSERT INTO `dict_area` VALUES (360725, '崇义县', 360700);
INSERT INTO `dict_area` VALUES (360726, '安远县', 360700);
INSERT INTO `dict_area` VALUES (360727, '龙南县', 360700);
INSERT INTO `dict_area` VALUES (360728, '定南县', 360700);
INSERT INTO `dict_area` VALUES (360729, '全南县', 360700);
INSERT INTO `dict_area` VALUES (360730, '宁都县', 360700);
INSERT INTO `dict_area` VALUES (360731, '于都县', 360700);
INSERT INTO `dict_area` VALUES (360732, '兴国县', 360700);
INSERT INTO `dict_area` VALUES (360733, '会昌县', 360700);
INSERT INTO `dict_area` VALUES (360734, '寻乌县', 360700);
INSERT INTO `dict_area` VALUES (360735, '石城县', 360700);
INSERT INTO `dict_area` VALUES (360781, '瑞金市', 360700);
INSERT INTO `dict_area` VALUES (360800, '吉安市', 360000);
INSERT INTO `dict_area` VALUES (360802, '吉州区', 360800);
INSERT INTO `dict_area` VALUES (360803, '青原区', 360800);
INSERT INTO `dict_area` VALUES (360821, '吉安县', 360800);
INSERT INTO `dict_area` VALUES (360822, '吉水县', 360800);
INSERT INTO `dict_area` VALUES (360823, '峡江县', 360800);
INSERT INTO `dict_area` VALUES (360824, '新干县', 360800);
INSERT INTO `dict_area` VALUES (360825, '永丰县', 360800);
INSERT INTO `dict_area` VALUES (360826, '泰和县', 360800);
INSERT INTO `dict_area` VALUES (360827, '遂川县', 360800);
INSERT INTO `dict_area` VALUES (360828, '万安县', 360800);
INSERT INTO `dict_area` VALUES (360829, '安福县', 360800);
INSERT INTO `dict_area` VALUES (360830, '永新县', 360800);
INSERT INTO `dict_area` VALUES (360881, '井冈山市', 360800);
INSERT INTO `dict_area` VALUES (360900, '宜春市', 360000);
INSERT INTO `dict_area` VALUES (360902, '袁州区', 360900);
INSERT INTO `dict_area` VALUES (360921, '奉新县', 360900);
INSERT INTO `dict_area` VALUES (360922, '万载县', 360900);
INSERT INTO `dict_area` VALUES (360923, '上高县', 360900);
INSERT INTO `dict_area` VALUES (360924, '宜丰县', 360900);
INSERT INTO `dict_area` VALUES (360925, '靖安县', 360900);
INSERT INTO `dict_area` VALUES (360926, '铜鼓县', 360900);
INSERT INTO `dict_area` VALUES (360981, '丰城市', 360900);
INSERT INTO `dict_area` VALUES (360982, '樟树市', 360900);
INSERT INTO `dict_area` VALUES (360983, '高安市', 360900);
INSERT INTO `dict_area` VALUES (361000, '抚州市', 360000);
INSERT INTO `dict_area` VALUES (361002, '临川区', 361000);
INSERT INTO `dict_area` VALUES (361003, '东乡区', 361000);
INSERT INTO `dict_area` VALUES (361021, '南城县', 361000);
INSERT INTO `dict_area` VALUES (361022, '黎川县', 361000);
INSERT INTO `dict_area` VALUES (361023, '南丰县', 361000);
INSERT INTO `dict_area` VALUES (361024, '崇仁县', 361000);
INSERT INTO `dict_area` VALUES (361025, '乐安县', 361000);
INSERT INTO `dict_area` VALUES (361026, '宜黄县', 361000);
INSERT INTO `dict_area` VALUES (361027, '金溪县', 361000);
INSERT INTO `dict_area` VALUES (361028, '资溪县', 361000);
INSERT INTO `dict_area` VALUES (361030, '广昌县', 361000);
INSERT INTO `dict_area` VALUES (361100, '上饶市', 360000);
INSERT INTO `dict_area` VALUES (361102, '信州区', 361100);
INSERT INTO `dict_area` VALUES (361103, '广丰区', 361100);
INSERT INTO `dict_area` VALUES (361121, '上饶县', 361100);
INSERT INTO `dict_area` VALUES (361123, '玉山县', 361100);
INSERT INTO `dict_area` VALUES (361124, '铅山县', 361100);
INSERT INTO `dict_area` VALUES (361125, '横峰县', 361100);
INSERT INTO `dict_area` VALUES (361126, '弋阳县', 361100);
INSERT INTO `dict_area` VALUES (361127, '余干县', 361100);
INSERT INTO `dict_area` VALUES (361128, '鄱阳县', 361100);
INSERT INTO `dict_area` VALUES (361129, '万年县', 361100);
INSERT INTO `dict_area` VALUES (361130, '婺源县', 361100);
INSERT INTO `dict_area` VALUES (361181, '德兴市', 361100);
INSERT INTO `dict_area` VALUES (370000, '山东省', NULL);
INSERT INTO `dict_area` VALUES (370100, '济南市', 370000);
INSERT INTO `dict_area` VALUES (370102, '历下区', 370100);
INSERT INTO `dict_area` VALUES (370103, '市中区', 370100);
INSERT INTO `dict_area` VALUES (370104, '槐荫区', 370100);
INSERT INTO `dict_area` VALUES (370105, '天桥区', 370100);
INSERT INTO `dict_area` VALUES (370112, '历城区', 370100);
INSERT INTO `dict_area` VALUES (370113, '长清区', 370100);
INSERT INTO `dict_area` VALUES (370114, '章丘区', 370100);
INSERT INTO `dict_area` VALUES (370124, '平阴县', 370100);
INSERT INTO `dict_area` VALUES (370125, '济阳县', 370100);
INSERT INTO `dict_area` VALUES (370126, '商河县', 370100);
INSERT INTO `dict_area` VALUES (370200, '青岛市', 370000);
INSERT INTO `dict_area` VALUES (370202, '市南区', 370200);
INSERT INTO `dict_area` VALUES (370203, '市北区', 370200);
INSERT INTO `dict_area` VALUES (370211, '黄岛区', 370200);
INSERT INTO `dict_area` VALUES (370212, '崂山区', 370200);
INSERT INTO `dict_area` VALUES (370213, '李沧区', 370200);
INSERT INTO `dict_area` VALUES (370214, '城阳区', 370200);
INSERT INTO `dict_area` VALUES (370281, '胶州市', 370200);
INSERT INTO `dict_area` VALUES (370282, '即墨市', 370200);
INSERT INTO `dict_area` VALUES (370283, '平度市', 370200);
INSERT INTO `dict_area` VALUES (370285, '莱西市', 370200);
INSERT INTO `dict_area` VALUES (370300, '淄博市', 370000);
INSERT INTO `dict_area` VALUES (370302, '淄川区', 370300);
INSERT INTO `dict_area` VALUES (370303, '张店区', 370300);
INSERT INTO `dict_area` VALUES (370304, '博山区', 370300);
INSERT INTO `dict_area` VALUES (370305, '临淄区', 370300);
INSERT INTO `dict_area` VALUES (370306, '周村区', 370300);
INSERT INTO `dict_area` VALUES (370321, '桓台县', 370300);
INSERT INTO `dict_area` VALUES (370322, '高青县', 370300);
INSERT INTO `dict_area` VALUES (370323, '沂源县', 370300);
INSERT INTO `dict_area` VALUES (370400, '枣庄市', 370000);
INSERT INTO `dict_area` VALUES (370402, '市中区', 370400);
INSERT INTO `dict_area` VALUES (370403, '薛城区', 370400);
INSERT INTO `dict_area` VALUES (370404, '峄城区', 370400);
INSERT INTO `dict_area` VALUES (370405, '台儿庄区', 370400);
INSERT INTO `dict_area` VALUES (370406, '山亭区', 370400);
INSERT INTO `dict_area` VALUES (370481, '滕州市', 370400);
INSERT INTO `dict_area` VALUES (370500, '东营市', 370000);
INSERT INTO `dict_area` VALUES (370502, '东营区', 370500);
INSERT INTO `dict_area` VALUES (370503, '河口区', 370500);
INSERT INTO `dict_area` VALUES (370505, '垦利区', 370500);
INSERT INTO `dict_area` VALUES (370522, '利津县', 370500);
INSERT INTO `dict_area` VALUES (370523, '广饶县', 370500);
INSERT INTO `dict_area` VALUES (370600, '烟台市', 370000);
INSERT INTO `dict_area` VALUES (370602, '芝罘区', 370600);
INSERT INTO `dict_area` VALUES (370611, '福山区', 370600);
INSERT INTO `dict_area` VALUES (370612, '牟平区', 370600);
INSERT INTO `dict_area` VALUES (370613, '莱山区', 370600);
INSERT INTO `dict_area` VALUES (370634, '长岛县', 370600);
INSERT INTO `dict_area` VALUES (370681, '龙口市', 370600);
INSERT INTO `dict_area` VALUES (370682, '莱阳市', 370600);
INSERT INTO `dict_area` VALUES (370683, '莱州市', 370600);
INSERT INTO `dict_area` VALUES (370684, '蓬莱市', 370600);
INSERT INTO `dict_area` VALUES (370685, '招远市', 370600);
INSERT INTO `dict_area` VALUES (370686, '栖霞市', 370600);
INSERT INTO `dict_area` VALUES (370687, '海阳市', 370600);
INSERT INTO `dict_area` VALUES (370700, '潍坊市', 370000);
INSERT INTO `dict_area` VALUES (370702, '潍城区', 370700);
INSERT INTO `dict_area` VALUES (370703, '寒亭区', 370700);
INSERT INTO `dict_area` VALUES (370704, '坊子区', 370700);
INSERT INTO `dict_area` VALUES (370705, '奎文区', 370700);
INSERT INTO `dict_area` VALUES (370724, '临朐县', 370700);
INSERT INTO `dict_area` VALUES (370725, '昌乐县', 370700);
INSERT INTO `dict_area` VALUES (370781, '青州市', 370700);
INSERT INTO `dict_area` VALUES (370782, '诸城市', 370700);
INSERT INTO `dict_area` VALUES (370783, '寿光市', 370700);
INSERT INTO `dict_area` VALUES (370784, '安丘市', 370700);
INSERT INTO `dict_area` VALUES (370785, '高密市', 370700);
INSERT INTO `dict_area` VALUES (370786, '昌邑市', 370700);
INSERT INTO `dict_area` VALUES (370800, '济宁市', 370000);
INSERT INTO `dict_area` VALUES (370811, '任城区', 370800);
INSERT INTO `dict_area` VALUES (370812, '兖州区', 370800);
INSERT INTO `dict_area` VALUES (370826, '微山县', 370800);
INSERT INTO `dict_area` VALUES (370827, '鱼台县', 370800);
INSERT INTO `dict_area` VALUES (370828, '金乡县', 370800);
INSERT INTO `dict_area` VALUES (370829, '嘉祥县', 370800);
INSERT INTO `dict_area` VALUES (370830, '汶上县', 370800);
INSERT INTO `dict_area` VALUES (370831, '泗水县', 370800);
INSERT INTO `dict_area` VALUES (370832, '梁山县', 370800);
INSERT INTO `dict_area` VALUES (370881, '曲阜市', 370800);
INSERT INTO `dict_area` VALUES (370883, '邹城市', 370800);
INSERT INTO `dict_area` VALUES (370900, '泰安市', 370000);
INSERT INTO `dict_area` VALUES (370902, '泰山区', 370900);
INSERT INTO `dict_area` VALUES (370911, '岱岳区', 370900);
INSERT INTO `dict_area` VALUES (370921, '宁阳县', 370900);
INSERT INTO `dict_area` VALUES (370923, '东平县', 370900);
INSERT INTO `dict_area` VALUES (370982, '新泰市', 370900);
INSERT INTO `dict_area` VALUES (370983, '肥城市', 370900);
INSERT INTO `dict_area` VALUES (371000, '威海市', 370000);
INSERT INTO `dict_area` VALUES (371002, '环翠区', 371000);
INSERT INTO `dict_area` VALUES (371003, '文登区', 371000);
INSERT INTO `dict_area` VALUES (371082, '荣成市', 371000);
INSERT INTO `dict_area` VALUES (371083, '乳山市', 371000);
INSERT INTO `dict_area` VALUES (371100, '日照市', 370000);
INSERT INTO `dict_area` VALUES (371102, '东港区', 371100);
INSERT INTO `dict_area` VALUES (371103, '岚山区', 371100);
INSERT INTO `dict_area` VALUES (371121, '五莲县', 371100);
INSERT INTO `dict_area` VALUES (371122, '莒县', 371100);
INSERT INTO `dict_area` VALUES (371200, '莱芜市', 370000);
INSERT INTO `dict_area` VALUES (371202, '莱城区', 371200);
INSERT INTO `dict_area` VALUES (371203, '钢城区', 371200);
INSERT INTO `dict_area` VALUES (371300, '临沂市', 370000);
INSERT INTO `dict_area` VALUES (371302, '兰山区', 371300);
INSERT INTO `dict_area` VALUES (371311, '罗庄区', 371300);
INSERT INTO `dict_area` VALUES (371312, '河东区', 371300);
INSERT INTO `dict_area` VALUES (371321, '沂南县', 371300);
INSERT INTO `dict_area` VALUES (371322, '郯城县', 371300);
INSERT INTO `dict_area` VALUES (371323, '沂水县', 371300);
INSERT INTO `dict_area` VALUES (371324, '兰陵县', 371300);
INSERT INTO `dict_area` VALUES (371325, '费县', 371300);
INSERT INTO `dict_area` VALUES (371326, '平邑县', 371300);
INSERT INTO `dict_area` VALUES (371327, '莒南县', 371300);
INSERT INTO `dict_area` VALUES (371328, '蒙阴县', 371300);
INSERT INTO `dict_area` VALUES (371329, '临沭县', 371300);
INSERT INTO `dict_area` VALUES (371400, '德州市', 370000);
INSERT INTO `dict_area` VALUES (371402, '德城区', 371400);
INSERT INTO `dict_area` VALUES (371403, '陵城区', 371400);
INSERT INTO `dict_area` VALUES (371422, '宁津县', 371400);
INSERT INTO `dict_area` VALUES (371423, '庆云县', 371400);
INSERT INTO `dict_area` VALUES (371424, '临邑县', 371400);
INSERT INTO `dict_area` VALUES (371425, '齐河县', 371400);
INSERT INTO `dict_area` VALUES (371426, '平原县', 371400);
INSERT INTO `dict_area` VALUES (371427, '夏津县', 371400);
INSERT INTO `dict_area` VALUES (371428, '武城县', 371400);
INSERT INTO `dict_area` VALUES (371481, '乐陵市', 371400);
INSERT INTO `dict_area` VALUES (371482, '禹城市', 371400);
INSERT INTO `dict_area` VALUES (371500, '聊城市', 370000);
INSERT INTO `dict_area` VALUES (371502, '东昌府区', 371500);
INSERT INTO `dict_area` VALUES (371521, '阳谷县', 371500);
INSERT INTO `dict_area` VALUES (371522, '莘县', 371500);
INSERT INTO `dict_area` VALUES (371523, '茌平县', 371500);
INSERT INTO `dict_area` VALUES (371524, '东阿县', 371500);
INSERT INTO `dict_area` VALUES (371525, '冠县', 371500);
INSERT INTO `dict_area` VALUES (371526, '高唐县', 371500);
INSERT INTO `dict_area` VALUES (371581, '临清市', 371500);
INSERT INTO `dict_area` VALUES (371600, '滨州市', 370000);
INSERT INTO `dict_area` VALUES (371602, '滨城区', 371600);
INSERT INTO `dict_area` VALUES (371603, '沾化区', 371600);
INSERT INTO `dict_area` VALUES (371621, '惠民县', 371600);
INSERT INTO `dict_area` VALUES (371622, '阳信县', 371600);
INSERT INTO `dict_area` VALUES (371623, '无棣县', 371600);
INSERT INTO `dict_area` VALUES (371625, '博兴县', 371600);
INSERT INTO `dict_area` VALUES (371626, '邹平县', 371600);
INSERT INTO `dict_area` VALUES (371700, '菏泽市', 370000);
INSERT INTO `dict_area` VALUES (371702, '牡丹区', 371700);
INSERT INTO `dict_area` VALUES (371703, '定陶区', 371700);
INSERT INTO `dict_area` VALUES (371721, '曹县', 371700);
INSERT INTO `dict_area` VALUES (371722, '单县', 371700);
INSERT INTO `dict_area` VALUES (371723, '成武县', 371700);
INSERT INTO `dict_area` VALUES (371724, '巨野县', 371700);
INSERT INTO `dict_area` VALUES (371725, '郓城县', 371700);
INSERT INTO `dict_area` VALUES (371726, '鄄城县', 371700);
INSERT INTO `dict_area` VALUES (371728, '东明县', 371700);
INSERT INTO `dict_area` VALUES (410000, '河南省', NULL);
INSERT INTO `dict_area` VALUES (410100, '郑州市', 410000);
INSERT INTO `dict_area` VALUES (410102, '中原区', 410100);
INSERT INTO `dict_area` VALUES (410103, '二七区', 410100);
INSERT INTO `dict_area` VALUES (410104, '管城回族区', 410100);
INSERT INTO `dict_area` VALUES (410105, '金水区', 410100);
INSERT INTO `dict_area` VALUES (410106, '上街区', 410100);
INSERT INTO `dict_area` VALUES (410108, '惠济区', 410100);
INSERT INTO `dict_area` VALUES (410122, '中牟县', 410100);
INSERT INTO `dict_area` VALUES (410181, '巩义市', 410100);
INSERT INTO `dict_area` VALUES (410182, '荥阳市', 410100);
INSERT INTO `dict_area` VALUES (410183, '新密市', 410100);
INSERT INTO `dict_area` VALUES (410184, '新郑市', 410100);
INSERT INTO `dict_area` VALUES (410185, '登封市', 410100);
INSERT INTO `dict_area` VALUES (410200, '开封市', 410000);
INSERT INTO `dict_area` VALUES (410202, '龙亭区', 410200);
INSERT INTO `dict_area` VALUES (410203, '顺河回族区', 410200);
INSERT INTO `dict_area` VALUES (410204, '鼓楼区', 410200);
INSERT INTO `dict_area` VALUES (410205, '禹王台区', 410200);
INSERT INTO `dict_area` VALUES (410212, '祥符区', 410200);
INSERT INTO `dict_area` VALUES (410221, '杞县', 410200);
INSERT INTO `dict_area` VALUES (410222, '通许县', 410200);
INSERT INTO `dict_area` VALUES (410223, '尉氏县', 410200);
INSERT INTO `dict_area` VALUES (410225, '兰考县', 410200);
INSERT INTO `dict_area` VALUES (410300, '洛阳市', 410000);
INSERT INTO `dict_area` VALUES (410302, '老城区', 410300);
INSERT INTO `dict_area` VALUES (410303, '西工区', 410300);
INSERT INTO `dict_area` VALUES (410304, '瀍河回族区', 410300);
INSERT INTO `dict_area` VALUES (410305, '涧西区', 410300);
INSERT INTO `dict_area` VALUES (410306, '吉利区', 410300);
INSERT INTO `dict_area` VALUES (410311, '洛龙区', 410300);
INSERT INTO `dict_area` VALUES (410322, '孟津县', 410300);
INSERT INTO `dict_area` VALUES (410323, '新安县', 410300);
INSERT INTO `dict_area` VALUES (410324, '栾川县', 410300);
INSERT INTO `dict_area` VALUES (410325, '嵩县', 410300);
INSERT INTO `dict_area` VALUES (410326, '汝阳县', 410300);
INSERT INTO `dict_area` VALUES (410327, '宜阳县', 410300);
INSERT INTO `dict_area` VALUES (410328, '洛宁县', 410300);
INSERT INTO `dict_area` VALUES (410329, '伊川县', 410300);
INSERT INTO `dict_area` VALUES (410381, '偃师市', 410300);
INSERT INTO `dict_area` VALUES (410400, '平顶山市', 410000);
INSERT INTO `dict_area` VALUES (410402, '新华区', 410400);
INSERT INTO `dict_area` VALUES (410403, '卫东区', 410400);
INSERT INTO `dict_area` VALUES (410404, '石龙区', 410400);
INSERT INTO `dict_area` VALUES (410411, '湛河区', 410400);
INSERT INTO `dict_area` VALUES (410421, '宝丰县', 410400);
INSERT INTO `dict_area` VALUES (410422, '叶县', 410400);
INSERT INTO `dict_area` VALUES (410423, '鲁山县', 410400);
INSERT INTO `dict_area` VALUES (410425, '郏县', 410400);
派森先生
关注
0
点赞
踩
1

收藏

觉得还不错? 一键收藏
1
评论
最新-中国城市编码sql版上篇

SET FOREIGN_KEY_CHECKS = 0;-- ------------------------------ Table structure for dict_area-- ----------------------------DROP TABLE IF EXISTS `dict_area`;CREATE TABLE `dict_area` ( `id` int(11) NOT NULL, `name` varchar(48) CHARACTER SET utf8 COL
复制链接

扫一扫