1.创建app->areas
class Area(models.Model):"""行政区划"""# 创建 name 字段, 用户保存名称name = models.CharField(max_length=20,verbose_name='名称')# 自关联字段 parent# 第一个参数是 self : parent关联自己.# on_delete=models.SET_NULL: 如果省删掉了,省内其他的信息为 NULL# related_name='subs': 设置之后# 我们就这样调用获取市: area.area_set.all() ==> area.subs.all()parent = models.ForeignKey('self',on_delete=models.SET_NULL,related_name='subs',null=True, #表示数据库创建时该字段可不填,用NULL填充blank=True, # 表示代码中创建数据库记录时该字段可传空白(空串,空字符串).verbose_name='上级行政区划')class Meta:db_table = 'tb_areas'verbose_name = '行政区划'verbose_name_plural = '行政区划'def __str__(self):return self.name
3.迁移，提交模型
-- MySQL dump 10.13 Distrib 5.7.24, for Linux (x86_64)---- Host: localhost Database: meiduo_mis_db-- -------------------------------------------------------- Server version 5.7.24-0ubuntu0.16.04.1-log/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;/*!40101 SET NAMES utf8 */;/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;/*!40103 SET TIME_ZONE='+00:00' */;/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;---- Table structure for table `tb_areas`--DROP TABLE IF EXISTS `tb_areas`;/*!40101 SET @saved_cs_client = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `tb_areas` (`id` int(11) NOT NULL AUTO_INCREMENT,`name` varchar(20) NOT NULL,`parent_id` int(11) DEFAULT NULL,PRIMARY KEY (`id`),KEY `tb_areas_parent_id_bae67575_fk_tb_areas_id` (`parent_id`),CONSTRAINT `tb_areas_parent_id_bae67575_fk_tb_areas_id` FOREIGN KEY (`parent_id`) REFERENCES `tb_areas` (`id`)) ENGINE=InnoDB AUTO_INCREMENT=820001 DEFAULT CHARSET=utf8;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `tb_areas`--LOCK TABLES `tb_areas` WRITE;/*!40000 ALTER TABLE `tb_areas` DISABLE KEYS */;INSERT INTO `tb_areas` VALUES (110000,'北京市',NULL),(110100,'北京市',110000),(110101,'东城区',110100),(110102,'西城区',110100),(110105,'朝阳区',110100),(110106,'丰台区',110100),(110107,'石景山区',110100),(110108,'海淀区',110100),(110109,'门头沟区',110100),(110111,'房山区',110100),(110112,'通州区',110100),(110113,'顺义区',110100),(110114,'昌平区',110100),(110115,'大兴区',110100),(110116,'怀柔区',110100),(110117,'平谷区',110100),(110118,'密云区',110100),(110119,'延庆区',110100),(120000,'天津市',NULL),(120100,'天津市',120000),(120101,'和平区',120100),(120102,'河东区',120100),(120103,'河西区',120100),(120104,'南开区',120100),(120105,'河北区',120100),(120106,'红桥区',120100),(120110,'东丽区',120100),(120111,'西青区',120100),(120112,'津南区',120100),(120113,'北辰区',120100),(120114,'武清区',120100),(120115,'宝坻区',120100),(120116,'滨海新区',120100),(120117,'宁河区',120100),(120118,'静海区',120100),(120119,'蓟州区',120100),(130000,'河北省',NULL),(130100,'石家庄市',130000),(130102,'长安区',130100),(130104,'桥西区',130100),(130105,'新华区',130100),(130107,'井陉矿区',130100),(130108,'裕华区',130100),(130109,'藁城区',130100),(130110,'鹿泉区',130100),(130111,'栾城区',130100),(130121,'井陉县',130100),(130123,'正定县',130100),(130125,'行唐县',130100),(130126,'灵寿县',130100),(130127,'高邑县',130100),(130128,'深泽县',130100),(130129,'赞皇县',130100),(130130,'无极县',130100),(130131,'平山县',130100),(130132,'元氏县',130100),(130133,'赵县',130100),(130183,'晋州市',130100),(130184,'新乐市',130100),(130200,'唐山市',130000),(130202,'路南区',130200),(130203,'路北区',130200),(130204,'古冶区',130200),(130205,'开平区',130200),(130207,'丰南区',130200),(130208,'丰润区',130200),(130209,'曹妃甸区',130200),(130223,'滦县',130200),(130224,'滦南县',130200),(130225,'乐亭县',130200),(130227,'迁西县',130200),(130229,'玉田县',130200),(130281,'遵化市',130200),(130283,'迁安市',130200),(130300,'秦皇岛市',130000),(130302,'海港区',130300),(130303,'山海关区',130300),(130304,'北戴河区',130300),(130306,'抚宁区',130300),(130321,'青龙满族自治县',130300),(130322,'昌黎县',130300),(130324,'卢龙县',130300),(130400,'邯郸市',130000),(130402,'邯山区',130400),(130403,'丛台区',130400),(130404,'复兴区',130400),(130406,'峰峰矿区',130400),(130421,'邯郸县',130400),(130423,'临漳县',130400),(130424,'成安县',130400),(130425,'大名县',130400),(130426,'涉县',130400),(130427,'磁县',130400),(130428,'肥乡县',130400),(130429,'永年县',130400),(130430,'邱县',130400),(130431,'鸡泽县',130400),(130432,'广平县',130400),(130433,'馆陶县',130400),(130434,'魏县',130400),(130435,'曲周县',130400),(130481,'武安市',130400),(130500,'邢台市',130000),(130502,'桥东区',130500),(130503,'桥西区',130500),(130521,'邢台县',130500),(130522,'临城县',130500),(130523,'内丘县',130500),(130524,'柏乡县',130500),(130525,'隆尧县',130500),(130526,'任县',130500),(130527,'南和县',130500),(130528,'宁晋县',130500),(130529,'巨鹿县',130500),(130530,'新河县',130500),(130531,'广宗县',130500),(130532,'平乡县',130500),(130533,'威县',130500),(130534,'清河县',130500),(130535,'临西县',130500),(130581,'南宫市',130500),(130582,'沙河市',130500),(130600,'保定市',130000),(130602,'竞秀区',130600),(130606,'莲池区',130600),(130607,'满城区',130600),(130608,'清苑区',130600),(130609,'徐水区',130600),(130623,'涞水县',130600),(130624,'阜平县',130600),(130626,'定兴县',130600),(130627,'唐县',130600),(130628,'高阳县',130600),(130629,'容城县',130600),(130630,'涞源县',130600),(130631,'望都县',130600),(130632,'安新县',130600),(130633,'易县',130600),(130634,'曲阳县',130600),(130635,'蠡县',130600),(130636,'顺平县',130600),(130637,'博野县',130600),(130638,'雄县',130600),(130681,'涿州市',130600),(130683,'安国市',130600),(130684,'高碑店市',130600),(130700,'张家口市',130000),(130702,'桥东区',130700),(130703,'桥西区',130700),(130705,'宣化区',130700),(130706,'下花园区',130700),(130708,'万全区',130700),(130709,'崇礼区',130700),(130722,'张北县',130700),(130723,'康保县',130700),(130724,'沽源县',130700),(130725,'尚义县',130700),(130726,'蔚县',130700),(130727,'阳原县',130700),(130728,'怀安县',130700),(130730,'怀来县',130700),(130731,'涿鹿县',130700),(130732,'赤城县',130700),(130800,'承德市',130000),(130802,'双桥区',130800),(130803,'双滦区',130800),(130804,'鹰手营子矿区',130800),(130821,'承德县',130800),(130822,'兴隆县',130800),(130823,'平泉县',130800),(130824,'滦平县',130800),(130825,'隆化县',130800),(130826,'丰宁满族自治县',130800),(130827,'宽城满族自治县',130800),(130828,'围场满族蒙古族自治县',130800),(130900,'沧州市',130000),(130902,'新华区',130900),(130903,'运河区',130900),(130921,'沧县',130900),(130922,'青县',130900),(130923,'东光县',130900),(130924,'海兴县',130900),(130925,'盐山县',130900),(130926,'肃宁县',130900),(130927,'南皮县',130900),(130928,'吴桥县',130900),(130929,'献县',130900),(130930,'孟村回族自治县',130900),(130981,'泊头市',130900),(130982,'任丘市',130900),(130983,'黄骅市',130900),(130984,'河间市',130900),(131000,'廊坊市',130000),(131002,'安次区',131000),(131003,'广阳区',131000),(131022,'固安县',131000),(131023,'永清县',131000),(131024,'香河县',131000),(131025,'大城县',131000),(131026,'文安县',131000),(131028,'大厂回族自治县',131000),(131081,'霸州市',131000),(131082,'三河市',131000),(131100,'衡水市',130000),(131102,'桃城区',131100),(131103,'冀州区',131100),(131121,'枣强县',131100),(131122,'武邑县',131100),(131123,'武强县',131100),(131124,'饶阳县',131100),(131125,'安平县',131100),(131126,'故城县',131100),(131127,'景县',131100),(131128,'阜城县',131100),(131182,'深州市',131100),(139000,'省直辖县级行政区划',130000),(139001,'定州市',139000),(139002,'辛集市',139000),(140000,'山西省',NULL),(140100,'太原市',140000),(140105,'小店区',140100),(140106,'迎泽区',140100),(140107,'杏花岭区',140100),(140108,'尖草坪区',140100),(140109,'万柏林区',140100),(140110,'晋源区',140100),(140121,'清徐县',140100),(140122,'阳曲县',140100),(140123,'娄烦县',140100),(140181,'古交市',140100),(140200,'大同市',140000),(140202,'城区',140200),(140203,'矿区',140200),(140211,'南郊区',140200),(140212,'新荣区',140200),(140221,'阳高县',140200),(140222,'天镇县',140200),(140223,'广灵县',140200),(140224,'灵丘县',140200),(140225,'浑源县',140200),(140226,'左云县',140200),(140227,'大同县',140200),(140300,'阳泉市',140000),(140302,'城区',140300),(140303,'矿区',140300),(140311,'郊区',140300),(140321,'平定县',140300),(140322,'盂县',140300),(140400,'长治市',140000),(140402,'城区',140400),(140411,'郊区',140400),(140421,'长治县',140400),(140423,'襄垣县',140400),(140424,'屯留县',140400),(140425,'平顺县',140400),(140426,'黎城县',140400),(140427,'壶关县',140400),(140428,'长子县',140400),(140429,'武乡县',140400),(140430,'沁县',140400),(140431,'沁源县',140400),(140481,'潞城市',140400),(140500,'晋城市',140000),(140502,'城区',140500),(140521,'沁水县',140500),(140522,'阳城县',140500),(140524,'陵川县',140500),(140525,'泽州县',140500),(140581,'高平市',140500),(140600,'朔州市',140000),(140602,'朔城区',140600),(140603,'平鲁区',140600),(140621,'山阴县',140600),(140622,'应县',140600),(140623,'右玉县',140600),(140624,'怀仁县',140600),(140700,'晋中市',140000),(140702,'榆次区',140700),(140721,'榆社县',140700),(140722,'左权县',140700),(140723,'和顺县',140700),(140724,'昔阳县',140700),(140725,'寿阳县',140700),(140726,'太谷县',140700),(140727,'祁县',140700),(140728,'平遥县',140700),(140729,'灵石县',140700),(140781,'介休市',140700),(140800,'运城市',140000),(140802,'盐湖区',140800),(140821,'临猗县',140800),(140822,'万荣县',140800),(140823,'闻喜县',140800),(140824,'稷山县',140800),(140825,'新绛县',140800),(140826,'绛县',140800),(140827,'垣曲县',140800),(140828,'夏县',140800),(140829,'平陆县',140800),(140830,'芮城县',140800),(140881,'永济市',140800),(140882,'河津市',140800),(140900,'忻州市',140000),(140902,'忻府区',140900),(140921,'定襄县',140900),(140922,'五台县',140900),(140923,'代县',140900),(140924,'繁峙县',140900),(140925,'宁武县',140900),(140926,'静乐县',140900),(140927,'神池县',140900),(140928,'五寨县',140900),(140929,'岢岚县',140900),(140930,'河曲县',140900),(140931,'保德县',140900),(140932,'偏关县',140900),(140981,'原平市',140900),(141000,'临汾市',140000),(141002,'尧都区',141000),(141021,'曲沃县',141000),(141022,'翼城县',141000),(141023,'襄汾县',141000),(141024,'洪洞县',141000),(141025,'古县',141000),(141026,'安泽县',141000),(141027,'浮山县',141000),(141028,'吉县',141000),(141029,'乡宁县',141000),(141030,'大宁县',141000),(141031,'隰县',141000),(141032,'永和县',141000),(141033,'蒲县',141000),(141034,'汾西县',141000),(141081,'侯马市',141000),(141082,'霍州市',141000),(141100,'吕梁市',140000),(141102,'离石区',141100),(141121,'文水县',141100),(141122,'交城县',141100),(141123,'兴县',141100),(141124,'临县',141100),(141125,'柳林县',141100),(141126,'石楼县',141100),(141127,'岚县',141100),(141128,'方山县',141100),(141129,'中阳县',141100),(141130,'交口县',141100),(141181,'孝义市',141100),(141182,'汾阳市',141100),(150000,'内蒙古自治区',NULL),(150100,'呼和浩特市',150000),(150102,'新城区',150100),(150103,'回民区',150100),(150104,'玉泉区',150100),(150105,'赛罕区',150100),(150121,'土默特左旗',150100),(150122,'托克托县',150100),(150123,'和林格尔县',150100),(150124,'清水河县',150100),(150125,'武川县',150100),(150200,'包头市',150000),(150202,'东河区',150200),(150203,'昆都仑区',150200),(150204,'青山区',150200),(150205,'石拐区',150200),(150206,'白云鄂博矿区',150200),(150207,'九原区',150200),(150221,'土默特右旗',150200),(150222,'固阳县',150200),(150223,'达尔罕茂明安联合旗',150200),(150300,'乌海市',150000),(150302,'海勃湾区',150300),(150303,'海南区',150300),(150304,'乌达区',150300),(150400,'赤峰市',150000),(150402,'红山区',150400),(150403,'元宝山区',150400),(150404,'松山区',150400),(150421,'阿鲁科尔沁旗',150400),(150422,'巴林左旗',150400),(150423,'巴林右旗',150400),(150424,'林西县',150400),(150425,'克什克腾旗',150400),(150426,'翁牛特旗',150400),(150428,'喀喇沁旗',150400),(150429,'宁城县',150400),(150430,'敖汉旗',150400),(150500,'通辽市',150000),(150502,'科尔沁区',150500),(150521,'科尔沁左翼中旗',150500),(150522,'科尔沁左翼后旗',150500),(150523,'开鲁县',150500),(150524,'库伦旗',150500),(150525,'奈曼旗',150500),(150526,'扎鲁特旗',150500),(150581,'霍林郭勒市',150500),(150600,'鄂尔多斯市',150000),(150602,'东胜区',150600),(150603,'康巴什区',150600),(150621,'达拉特旗',150600),(150622,'准格尔旗',150600),(150623,'鄂托克前旗',150600),(150624,'鄂托克旗',150600),(150625,'杭锦旗',150600),(150626,'乌审旗',150600),(150627,'伊金霍洛旗',150600),(150700,'呼伦贝尔市',150000),(150702,'海拉尔区',150700),(150703,'扎赉诺尔区',150700),(150721,'阿荣旗',150700),(150722,'莫力达瓦达斡尔族自治旗',150700),(150723,'鄂伦春自治旗',150700),(150724,'鄂温克族自治旗',150700),(150725,'陈巴尔虎旗',150700),(150726,'新巴尔虎左旗',150700),(150727,'新巴尔虎右旗',150700),(150781,'满洲里市',150700),(150782,'牙克石市',150700),(150783,'扎兰屯市',150700),(150784,'额尔古纳市',150700),(150785,'根河市',150700),(150800,'巴彦淖尔市',150000),(150802,'临河区',150800),(150821,'五原县',150800),(150822,'磴口县',150800),(150823,'乌拉特前旗',150800),(150824,'乌拉特中旗',150800),(150825,'乌拉特后旗',150800),(150826,'杭锦后旗',150800),(150900,'乌兰察布市',150000),(150902,'集宁区',150900),(150921,'卓资县',150900),(150922,'化德县',150900),(150923,'商都县',150900),(150924,'兴和县',150900),(150925,'凉城县',150900),(150926,'察哈尔右翼前旗',150900),(150927,'察哈尔右翼中旗',150900),(150928,'察哈尔右翼后旗',150900),(150929,'四子王旗',150900),(150981,'丰镇市',150900),(152200,'兴安盟',150000),(152201,'乌兰浩特市',152200),(152202,'阿尔山市',152200),(152221,'科尔沁右翼前旗',152200),(152222,'科尔沁右翼中旗',152200),(152223,'扎赉特旗',152200),(152224,'突泉县',152200),(152500,'锡林郭勒盟',150000),(152501,'二连浩特市',152500),(152502,'锡林浩特市',152500),(152522,'阿巴嘎旗',152500),(152523,'苏尼特左旗',152500),(152524,'苏尼特右旗',152500),(152525,'东乌珠穆沁旗',152500),(152526,'西乌珠穆沁旗',152500),(152527,'太仆寺旗',152500),(152528,'镶黄旗',152500),(152529,'正镶白旗',152500),(152530,'正蓝旗',152500),(152531,'多伦县',152500),(152900,'阿拉善盟',150000),(152921,'阿拉善左旗',152900),(152922,'阿拉善右旗',152900),(152923,'额济纳旗',152900),(210000,'辽宁省',NULL),(210100,'沈阳市',210000),(210102,'和平区',210100),(210103,'沈河区',210100),(210104,'大东区',210100),(210105,'皇姑区',210100),(210106,'铁西区',210100),(210111,'苏家屯区',210100),(210112,'浑南区',210100),(210113,'沈北新区',210100),(210114,'于洪区',210100),(210115,'辽中区',210100),(210123,'康平县',210100),(210124,'法库县',210100),(210181,'新民市',210100),(210200,'大连市',210000),(210202,'中山区',210200),(210203,'西岗区',210200),(210204,'沙河口区',210200),(210211,'甘井子区',210200),(210212,'旅顺口区',210200),(210213,'金州区',210200),(210214,'普兰店区',210200),(210224,'长海县',210200),(210281,'瓦房店市',210200),(210283,'庄河市',210200),(210300,'鞍山市',210000),(210302,'铁东区',210300),(210303,'铁西区',210300),(210304,'立山区',210300),(210311,'千山区',210300),(210321,'台安县',210300),(210323,'岫岩满族自治县',210300),(210381,'海城市',210300),(210400,'抚顺市',210000),(210402,'新抚区',210400),(210403,'东洲区',210400),(210404,'望花区',210400),(210411,'顺城区',210400),(210421,'抚顺县',210400),(210422,'新宾满族自治县',210400),(210423,'清原满族自治县',210400),(210500,'本溪市',210000),(210502,'平山区',210500),(210503,'溪湖区',210500),(210504,'明山区',210500),(210505,'南芬区',210500),(210521,'本溪满族自治县',210500),(210522,'桓仁满族自治县',210500),(210600,'丹东市',210000),(210602,'元宝区',210600),(210603,'振兴区',210600),(210604,'振安区',210600),(210624,'宽甸满族自治县',210600),(210681,'东港市',210600),(210682,'凤城市',210600),(210700,'锦州市',210000),(210702,'古塔区',210700),(210703,'凌河区',210700),(210711,'太和区',210700),(210726,'黑山县',210700),(210727,'义县',210700),(210781,'凌海市',210700),(210782,'北镇市',210700),(210800,'营口市',210000),(210802,'站前区',210800),(210803,'西市区',210800),(210804,'鲅鱼圈区',210800),(210811,'老边区',210800),(210881,'盖州市',210800),(210882,'大石桥市',210800),(210900,'阜新市',210000),(210902,'海州区',210900),(210903,'新邱区',210900),(210904,'太平区',210900),(210905,'清河门区',210900),(210911,'细河区',210900),(210921,'阜新蒙古族自治县',210900),(210922,'彰武县',210900),(211000,'辽阳市',210000),(211002,'白塔区',211000),(211003,'文圣区',211000),(211004,'宏伟区',211000),(211005,'弓长岭区',211000),(211011,'太子河区',211000),(211021,'辽阳县',211000),(211081,'灯塔市',211000),(211100,'盘锦市',210000),(211102,'双台子区',211100),(211103,'兴隆台区',211100),(211104,'大洼区',211100),(211122,'盘山县',211100),(211200,'铁岭市',210000),(211202,'银州区',211200),(211204,'清河区',211200),(211221,'铁岭县',211200),(211223,'西丰县',211200),(211224,'昌图县',211200),(211281,'调兵山市',211200),(211282,'开原市',211200),(211300,'朝阳市',210000),(211302,'双塔区',211300),(211303,'龙城区',211300),(211321,'朝阳县',211300),(211322,'建平县',211300),(211324,'喀喇沁左翼蒙古族自治县',211300),(211381,'北票市',211300),(211382,'凌源市',211300),(211400,'葫芦岛市',210000),(211402,'连山区',211400),(211403,'龙港区',211400),(211404,'南票区',211400),(211421,'绥中县',211400),(211422,'建昌县',211400),(211481,'兴城市',211400),(220000,'吉林省',NULL),(220100,'长春市',220000),(220102,'南关区',220100),(220103,'宽城区',220100),(220104,'朝阳区',220100),(220105,'二道区',220100),(220106,'绿园区',220100),(220112,'双阳区',220100),(220113,'九台区',220100),(220122,'农安县',220100),(220182,'榆树市',220100),(220183,'德惠市',220100),(220200,'吉林市',220000),(220202,'昌邑区',220200),(220203,'龙潭区',220200),(220204,'船营区',220200),(220211,'丰满区',220200),(220221,'永吉县',220200),(220281,'蛟河市',220200),(220282,'桦甸市',220200),(220283,'舒兰市',220200),(220284,'磐石市',220200),(220300,'四平市',220000),(220302,'铁西区',220300),(220303,'铁东区',220300),(220322,'梨树县',220300),(220323,'伊通满族自治县',220300),(220381,'公主岭市',220300),(220382,'双辽市',220300),(220400,'辽源市',220000),(220402,'龙山区',220400),(220403,'西安区',220400),(220421,'东丰县',220400),(220422,'东辽县',220400),(220500,'通化市',220000),(220502,'东昌区',220500),(220503,'二道江区',220500),(220521,'通化县',220500),(220523,'辉南县',220500),(220524,'柳河县',220500),(220581,'梅河口市',220500),(220582,'集安市',220500),(220600,'白山市',220000),(220602,'浑江区',220600),(220605,'江源区',220600),(220621,'抚松县',220600),(220622,'靖宇县',220600),(220623,'长白朝鲜族自治县',220600),(220681,'临江市',220600),(220700,'松原市',220000),(220702,'宁江区',220700),(220721,'前郭尔罗斯蒙古族自治县',220700),(220722,'长岭县',220700),(220723,'乾安县',220700),(220781,'扶余市',220700),(220800,'白城市',220000),(220802,'洮北区',220800),(220821,'镇赉县',220800),(220822,'通榆县',220800),(220881,'洮南市',220800),(220882,'大安市',220800),(222400,'延边朝鲜族自治州',220000),(222401,'延吉市',222400),(222402,'图们市',222400),(222403,'敦化市',222400),(222404,'珲春市',222400),(222405,'龙井市',222400),(222406,'和龙市',222400),(222424,'汪清县',222400),(222426,'安图县',222400),(230000,'黑龙江省',NULL),(230100,'哈尔滨市',230000),(230102,'道里区',230100),(230103,'南岗区',230100),(230104,'道外区',230100),(230108,'平房区',230100),(230109,'松北区',230100),(230110,'香坊区',230100),(230111,'呼兰区',230100),(230112,'阿城区',230100),(230113,'双城区',230100),(230123,'依兰县',230100),(230124,'方正县',230100),(230125,'宾县',230100),(230126,'巴彦县',230100),(230127,'木兰县',230100),(230128,'通河县',230100),(230129,'延寿县',230100),(230183,'尚志市',230100),(230184,'五常市',230100),(230200,'齐齐哈尔市',230000),(230202,'龙沙区',230200),(230203,'建华区',230200),(230204,'铁锋区',230200),(230205,'昂昂溪区',230200),(230206,'富拉尔基区',230200),(230207,'碾子山区',230200),(230208,'梅里斯达斡尔族区',230200),(230221,'龙江县',230200),(230223,'依安县',230200),(230224,'泰来县',230200),(230225,'甘南县',230200),(230227,'富裕县',230200),(230229,'克山县',230200),(230230,'克东县',230200),(230231,'拜泉县',230200),(230281,'讷河市',230200),(230300,'鸡西市',230000),(230302,'鸡冠区',230300),(230303,'恒山区',230300),(230304,'滴道区',230300),(230305,'梨树区',230300),(230306,'城子河区',230300),(230307,'麻山区',230300),(230321,'鸡东县',230300),(230381,'虎林市',230300),(230382,'密山市',230300),(230400,'鹤岗市',230000),(230402,'向阳区',230400),(230403,'工农区',230400),(230404,'南山区',230400),(230405,'兴安区',230400),(230406,'东山区',230400),(230407,'兴山区',230400),(230421,'萝北县',230400),(230422,'绥滨县',230400),(230500,'双鸭山市',230000),(230502,'尖山区',230500),(230503,'岭东区',230500),(230505,'四方台区',230500),(230506,'宝山区',230500),(230521,'集贤县',230500),(230522,'友谊县',230500),(230523,'宝清县',230500),(230524,'饶河县',230500),(230600,'大庆市',230000),(230602,'萨尔图区',230600),(230603,'龙凤区',230600),(230604,'让胡路区',230600),(230605,'红岗区',230600),(230606,'大同区',230600),(230621,'肇州县',230600),(230622,'肇源县',230600),(230623,'林甸县',230600),(230624,'杜尔伯特蒙古族自治县',230600),(230700,'伊春市',230000),(230702,'伊春区',230700),(230703,'南岔区',230700),(230704,'友好区',230700),(230705,'西林区',230700),(230706,'翠峦区',230700),(230707,'新青区',230700),(230708,'美溪区',230700),(230709,'金山屯区',230700),(230710,'五营区',230700),(230711,'乌马河区',230700),(230712,'汤旺河区',230700),(230713,'带岭区',230700),(230714,'乌伊岭区',230700),(230715,'红星区',230700),(230716,'上甘岭区',230700),(230722,'嘉荫县',230700),(230781,'铁力市',230700),(230800,'佳木斯市',230000),(230803,'向阳区',230800),(230804,'前进区',230800),(230805,'东风区',230800),(230811,'郊区',230800),(230822,'桦南县',230800),(230826,'桦川县',230800),(230828,'汤原县',230800),(230881,'同江市',230800),(230882,'富锦市',230800),(230883,'抚远市',230800),(230900,'七台河市',230000),(230902,'新兴区',230900),(230903,'桃山区',230900),(230904,'茄子河区',230900),(230921,'勃利县',230900),(231000,'牡丹江市',230000),(231002,'东安区',231000),(231003,'阳明区',231000),(231004,'爱民区',231000),(231005,'西安区',231000),(231025,'林口县',231000),(231081,'绥芬河市',231000),(231083,'海林市',231000),(231084,'宁安市',231000),(231085,'穆棱市',231000),(231086,'东宁市',231000),(231100,'黑河市',230000),(231102,'爱辉区',231100),(231121,'嫩江县',231100),(231123,'逊克县',231100),(231124,'孙吴县',231100),(231181,'北安市',231100),(231182,'五大连池市',231100),(231200,'绥化市',230000),(231202,'北林区',231200),(231221,'望奎县',231200),(231222,'兰西县',231200),(231223,'青冈县',231200),(231224,'庆安县',231200),(231225,'明水县',231200),(231226,'绥棱县',231200),(231281,'安达市',231200),(231282,'肇东市',231200),(231283,'海伦市',231200),(232700,'大兴安岭地区',230000),(232721,'呼玛县',232700),(232722,'塔河县',232700),(232723,'漠河县',232700),(310000,'上海市',NULL),(310100,'上海市',310000),(310101,'黄浦区',310100),(310104,'徐汇区',310100),(310105,'长宁区',310100),(310106,'静安区',310100),(310107,'普陀区',310100),(310109,'虹口区',310100),(310110,'杨浦区',310100),(310112,'闵行区',310100),(310113,'宝山区',310100),(310114,'嘉定区',310100),(310115,'浦东新区',310100),(310116,'金山区',310100),(310117,'松江区',310100),(310118,'青浦区',310100),(310120,'奉贤区',310100),(310151,'崇明区',310100),(320000,'江苏省',NULL),(320100,'南京市',320000),(320102,'玄武区',320100),(320104,'秦淮区',320100),(320105,'建邺区',320100),(320106,'鼓楼区',320100),(320111,'浦口区',320100),(320113,'栖霞区',320100),(320114,'雨花台区',320100),(320115,'江宁区',320100),(320116,'六合区',320100),(320117,'溧水区',320100),(320118,'高淳区',320100),(320200,'无锡市',320000),(320205,'锡山区',320200),(320206,'惠山区',320200),(320211,'滨湖区',320200),(320213,'梁溪区',320200),(320214,'新吴区',320200),(320281,'江阴市',320200),(320282,'宜兴市',320200),(320300,'徐州市',320000),(320302,'鼓楼区',320300),(320303,'云龙区',320300),(320305,'贾汪区',320300),(320311,'泉山区',320300),(320312,'铜山区',320300),(320321,'丰县',320300),(320322,'沛县',320300),(320324,'睢宁县',320300),(320381,'新沂市',320300),(320382,'邳州市',320300),(320400,'常州市',320000),(320402,'天宁区',320400),(320404,'钟楼区',320400),(320411,'新北区',320400),(320412,'武进区',320400),(320413,'金坛区',320400),(320481,'溧阳市',320400),(320500,'苏州市',320000),(320505,'虎丘区',320500),(320506,'吴中区',320500),(320507,'相城区',320500),(320508,'姑苏区',320500),(320509,'吴江区',320500),(320581,'常熟市',320500),(320582,'张家港市',320500),(320583,'昆山市',320500),(320585,'太仓市',320500),(320600,'南通市',320000),(320602,'崇川区',320600),(320611,'港闸区',320600),(320612,'通州区',320600),(320621,'海安县',320600),(320623,'如东县',320600),(320681,'启东市',320600),(320682,'如皋市',320600),(320684,'海门市',320600),(320700,'连云港市',320000),(320703,'连云区',320700),(320706,'海州区',320700),(320707,'赣榆区',320700),(320722,'东海县',320700),(320723,'灌云县',320700),(320724,'灌南县',320700),(320800,'淮安市',320000),(320803,'淮安区',320800),(320804,'淮阴区',320800),(320812,'清江浦区',320800),(320813,'洪泽区',320800),(320826,'涟水县',320800),(320830,'盱眙县',320800),(320831,'金湖县',320800),(320900,'盐城市',320000),(320902,'亭湖区',320900),(320903,'盐都区',320900),(320904,'大丰区',320900),(320921,'响水县',320900),(320922,'滨海县',320900),(320923,'阜宁县',320900),(320924,'射阳县',320900),(320925,'建湖县',320900),(320981,'东台市',320900),(321000,'扬州市',320000),(321002,'广陵区',321000),(321003,'邗江区',321000),(321012,'江都区',321000),(321023,'宝应县',321000),(321081,'仪征市',321000),(321084,'高邮市',321000),(321100,'镇江市',320000),(321102,'京口区',321100),(321111,'润州区',321100),(321112,'丹徒区',321100),(321181,'丹阳市',321100),(321182,'扬中市',321100),(321183,'句容市',321100),(321200,'泰州市',320000),(321202,'海陵区',321200),(321203,'高港区',321200),(321204,'姜堰区',321200),(321281,'兴化市',321200),(321282,'靖江市',321200),(321283,'泰兴市',321200),(321300,'宿迁市',320000),(321302,'宿城区',321300),(321311,'宿豫区',321300),(321322,'沭阳县',321300),(321323,'泗阳县',321300),(321324,'泗洪县',321300),(330000,'浙江省',NULL),(330100,'杭州市',330000),(330102,'上城区',330100),(330103,'下城区',330100),(330104,'江干区',330100),(330105,'拱墅区',330100),(330106,'西湖区',330100),(330108,'滨江区',330100),(330109,'萧山区',330100),(330110,'余杭区',330100),(330111,'富阳区',330100),(330122,'桐庐县',330100),(330127,'淳安县',330100),(330182,'建德市',330100),(330185,'临安市',330100),(330200,'宁波市',330000),(330203,'海曙区',330200),(330204,'江东区',330200),(330205,'江北区',330200),(330206,'北仑区',330200),(330211,'镇海区',330200),(330212,'鄞州区',330200),(330225,'象山县',330200),(330226,'宁海县',330200),(330281,'余姚市',330200),(330282,'慈溪市',330200),(330283,'奉化市',330200),(330300,'温州市',330000),(330302,'鹿城区',330300),(330303,'龙湾区',330300),(330304,'瓯海区',330300),(330305,'洞头区',330300),(330324,'永嘉县',330300),(330326,'平阳县',330300),(330327,'苍南县',330300),(330328,'文成县',330300),(330329,'泰顺县',330300),(330381,'瑞安市',330300),(330382,'乐清市',330300),(330400,'嘉兴市',330000),(330402,'南湖区',330400),(330411,'秀洲区',330400),(330421,'嘉善县',330400),(330424,'海盐县',330400),(330481,'海宁市',330400),(330482,'平湖市',330400),(330483,'桐乡市',330400),(330500,'湖州市',330000),(330502,'吴兴区',330500),(330503,'南浔区',330500),(330521,'德清县',330500),(330522,'长兴县',330500),(330523,'安吉县',330500),(330600,'绍兴市',330000),(330602,'越城区',330600),(330603,'柯桥区',330600),(330604,'上虞区',330600),(330624,'新昌县',330600),(330681,'诸暨市',330600),(330683,'嵊州市',330600),(330700,'金华市',330000),(330702,'婺城区',330700),(330703,'金东区',330700),(330723,'武义县',330700),(330726,'浦江县',330700),(330727,'磐安县',330700),(330781,'兰溪市',330700),(330782,'义乌市',330700),(330783,'东阳市',330700),(330784,'永康市',330700),(330800,'衢州市',330000),(330802,'柯城区',330800),(330803,'衢江区',330800),(330822,'常山县',330800),(330824,'开化县',330800),(330825,'龙游县',330800),(330881,'江山市',330800),(330900,'舟山市',330000),(330902,'定海区',330900),(330903,'普陀区',330900),(330921,'岱山县',330900),(330922,'嵊泗县',330900),(331000,'台州市',330000),(331002,'椒江区',331000),(331003,'黄岩区',331000),(331004,'路桥区',331000),(331021,'玉环县',331000),(331022,'三门县',331000),(331023,'天台县',331000),(331024,'仙居县',331000),(331081,'温岭市',331000),(331082,'临海市',331000),(331100,'丽水市',330000),(331102,'莲都区',331100),(331121,'青田县',331100),(331122,'缙云县',331100),(331123,'遂昌县',331100),(331124,'松阳县',331100),(331125,'云和县',331100),(331126,'庆元县',331100),(331127,'景宁畲族自治县',331100),(331181,'龙泉市',331100),(340000,'安徽省',NULL),(340100,'合肥市',340000),(340102,'瑶海区',340100),(340103,'庐阳区',340100),(340104,'蜀山区',340100),(340111,'包河区',340100),(340121,'长丰县',340100),(340122,'肥东县',340100),(340123,'肥西县',340100),(340124,'庐江县',340100),(340181,'巢湖市',340100),(340200,'芜湖市',340000),(340202,'镜湖区',340200),(340203,'弋江区',340200),(340207,'鸠江区',340200),(340208,'三山区',340200),(340221,'芜湖县',340200),(340222,'繁昌县',340200),(340223,'南陵县',340200),(340225,'无为县',340200),(340300,'蚌埠市',340000),(340302,'龙子湖区',340300),(340303,'蚌山区',340300),(340304,'禹会区',340300),(340311,'淮上区',340300),(340321,'怀远县',340300),(340322,'五河县',340300),(340323,'固镇县',340300),(340400,'淮南市',340000),(340402,'大通区',340400),(340403,'田家庵区',340400),(340404,'谢家集区',340400),(340405,'八公山区',340400),(340406,'潘集区',340400),(340421,'凤台县',340400),(340422,'寿县',340400),(340500,'马鞍山市',340000),(340503,'花山区',340500),(340504,'雨山区',340500),(340506,'博望区',340500),(340521,'当涂县',340500),(340522,'含山县',340500),(340523,'和县',340500),(340600,'淮北市',340000),(340602,'杜集区',340600),(340603,'相山区',340600),(340604,'烈山区',340600),(340621,'濉溪县',340600),(340700,'铜陵市',340000),(340705,'铜官区',340700),(340706,'义安区',340700),(340711,'郊区',340700),(340722,'枞阳县',340700),(340800,'安庆市',340000),(340802,'迎江区',340800),(340803,'大观区',340800),(340811,'宜秀区',340800),(340822,'怀宁县',340800),(340824,'潜山县',340800),(340825,'太湖县',340800),(340826,'宿松县',340800),(340827,'望江县',340800),(340828,'岳西县',340800),(340881,'桐城市',340800),(341000,'黄山市',340000),(341002,'屯溪区',341000),(341003,'黄山区',341000),(341004,'徽州区',341000),(341021,'歙县',341000),(341022,'休宁县',341000),(341023,'黟县',341000),(341024,'祁门县',341000),(341100,'滁州市',340000),(341102,'琅琊区',341100),(341103,'南谯区',341100),(341122,'来安县',341100),(341124,'全椒县',341100),(341125,'定远县',341100),(341126,'凤阳县',341100),(341181,'天长市',341100),(341182,'明光市',341100),(341200,'阜阳市',340000),(341202,'颍州区',341200),(341203,'颍东区',341200),(341204,'颍泉区',341200),(341221,'临泉县',341200),(341222,'太和县',341200),(341225,'阜南县',341200),(341226,'颍上县',341200),(341282,'界首市',341200),(341300,'宿州市',340000),(341302,'埇桥区',341300),(341321,'砀山县',341300),(341322,'萧县',341300),(341323,'灵璧县',341300),(341324,'泗县',341300),(341500,'六安市',340000),(341502,'金安区',341500),(341503,'裕安区',341500),(341504,'叶集区',341500),(341522,'霍邱县',341500),(341523,'舒城县',341500),(341524,'金寨县',341500),(341525,'霍山县',341500),(341600,'亳州市',340000),(341602,'谯城区',341600),(341621,'涡阳县',341600),(341622,'蒙城县',341600),(341623,'利辛县',341600),(341700,'池州市',340000),(341702,'贵池区',341700),(341721,'东至县',341700),(341722,'石台县',341700),(341723,'青阳县',341700),(341800,'宣城市',340000),(341802,'宣州区',341800),(341821,'郎溪县',341800),(341822,'广德县',341800),(341823,'泾县',341800),(341824,'绩溪县',341800),(341825,'旌德县',341800),(341881,'宁国市',341800),(350000,'福建省',NULL),(350100,'福州市',350000),(350102,'鼓楼区',350100),(350103,'台江区',350100),(350104,'仓山区',350100),(350105,'马尾区',350100),(350111,'晋安区',350100),(350121,'闽侯县',350100),(350122,'连江县',350100),(350123,'罗源县',350100),(350124,'闽清县',350100),(350125,'永泰县',350100),(350128,'平潭县',350100),(350181,'福清市',350100),(350182,'长乐市',350100),(350200,'厦门市',350000),(350203,'思明区',350200),(350205,'海沧区',350200),(350206,'湖里区',350200),(350211,'集美区',350200),(350212,'同安区',350200),(350213,'翔安区',350200),(350300,'莆田市',350000),(350302,'城厢区',350300),(350303,'涵江区',350300),(350304,'荔城区',350300),(350305,'秀屿区',350300),(350322,'仙游县',350300),(350400,'三明市',350000),(350402,'梅列区',350400),(350403,'三元区',350400),(350421,'明溪县',350400),(350423,'清流县',350400),(350424,'宁化县',350400),(350425,'大田县',350400),(350426,'尤溪县',350400),(350427,'沙县',350400),(350428,'将乐县',350400),(350429,'泰宁县',350400),(350430,'建宁县',350400),(350481,'永安市',350400),(350500,'泉州市',350000),(350502,'鲤城区',350500),(350503,'丰泽区',350500),(350504,'洛江区',350500),(350505,'泉港区',350500),(350521,'惠安县',350500),(350524,'安溪县',350500),(350525,'永春县',350500),(350526,'德化县',350500),(350527,'金门县',350500),(350581,'石狮市',350500),(350582,'晋江市',350500),(350583,'南安市',350500),(350600,'漳州市',350000),(350602,'芗城区',350600),(350603,'龙文区',350600),(350622,'云霄县',350600),(350623,'漳浦县',350600),(350624,'诏安县',350600),(350625,'长泰县',350600),(350626,'东山县',350600),(350627,'南靖县',350600),(350628,'平和县',350600),(350629,'华安县',350600),(350681,'龙海市',350600),(350700,'南平市',350000),(350702,'延平区',350700),(350703,'建阳区',350700),(350721,'顺昌县',350700),(350722,'浦城县',350700),(350723,'光泽县',350700),(350724,'松溪县',350700),(350725,'政和县',350700),(350781,'邵武市',350700),(350782,'武夷山市',350700),(350783,'建瓯市',350700),(350800,'龙岩市',350000),(350802,'新罗区',350800),(350803,'永定区',350800),(350821,'长汀县',350800),(350823,'上杭县',350800),(350824,'武平县',350800),(350825,'连城县',350800),(350881,'漳平市',350800),(350900,'宁德市',350000),(350902,'蕉城区',350900),(350921,'霞浦县',350900),(350922,'古田县',350900),(350923,'屏南县',350900),(350924,'寿宁县',350900),(350925,'周宁县',350900),(350926,'柘荣县',350900),(350981,'福安市',350900),(350982,'福鼎市',350900),(360000,'江西省',NULL),(360100,'南昌市',360000),(360102,'东湖区',360100),(360103,'西湖区',360100),(360104,'青云谱区',360100),(360105,'湾里区',360100),(360111,'青山湖区',360100),(360112,'新建区',360100),(360121,'南昌县',360100),(360123,'安义县',360100),(360124,'进贤县',360100),(360200,'景德镇市',360000),(360202,'昌江区',360200),(360203,'珠山区',360200),(360222,'浮梁县',360200),(360281,'乐平市',360200),(360300,'萍乡市',360000),(360302,'安源区',360300),(360313,'湘东区',360300),(360321,'莲花县',360300),(360322,'上栗县',360300),(360323,'芦溪县',360300),(360400,'九江市',360000),(360402,'濂溪区',360400),(360403,'浔阳区',360400),(360421,'九江县',360400),(360423,'武宁县',360400),(360424,'修水县',360400),(360425,'永修县',360400),(360426,'德安县',360400),(360428,'都昌县',360400),(360429,'湖口县',360400),(360430,'彭泽县',360400),(360481,'瑞昌市',360400),(360482,'共青城市',360400),(360483,'庐山市',360400),(360500,'新余市',360000),(360502,'渝水区',360500),(360521,'分宜县',360500),(360600,'鹰潭市',360000),(360602,'月湖区',360600),(360622,'余江县',360600),(360681,'贵溪市',360600),(360700,'赣州市',360000),(360702,'章贡区',360700),(360703,'南康区',360700),(360721,'赣县',360700),(360722,'信丰县',360700),(360723,'大余县',360700),(360724,'上犹县',360700),(360725,'崇义县',360700),(360726,'安远县',360700),(360727,'龙南县',360700),(360728,'定南县',360700),(360729,'全南县',360700),(360730,'宁都县',360700),(360731,'于都县',360700),(360732,'兴国县',360700),(360733,'会昌县',360700),(360734,'寻乌县',360700),(360735,'石城县',360700),(360781,'瑞金市',360700),(360800,'吉安市',360000),(360802,'吉州区',360800),(360803,'青原区',360800),(360821,'吉安县',360800),(360822,'吉水县',360800),(360823,'峡江县',360800),(360824,'新干县',360800),(360825,'永丰县',360800),(360826,'泰和县',360800),(360827,'遂川县',360800),(360828,'万安县',360800),(360829,'安福县',360800),(360830,'永新县',360800),(360881,'井冈山市',360800),(360900,'宜春市',360000),(360902,'袁州区',360900),(360921,'奉新县',360900),(360922,'万载县',360900),(360923,'上高县',360900),(360924,'宜丰县',360900),(360925,'靖安县',360900),(360926,'铜鼓县',360900),(360981,'丰城市',360900),(360982,'樟树市',360900),(360983,'高安市',360900),(361000,'抚州市',360000),(361002,'临川区',361000),(361021,'南城县',361000),(361022,'黎川县',361000),(361023,'南丰县',361000),(361024,'崇仁县',361000),(361025,'乐安县',361000),(361026,'宜黄县',361000),(361027,'金溪县',361000),(361028,'资溪县',361000),(361029,'东乡县',361000),(361030,'广昌县',361000),(361100,'上饶市',360000),(361102,'信州区',361100),(361103,'广丰区',361100),(361121,'上饶县',361100),(361123,'玉山县',361100),(361124,'铅山县',361100),(361125,'横峰县',361100),(361126,'弋阳县',361100),(361127,'余干县',361100),(361128,'鄱阳县',361100),(361129,'万年县',361100),(361130,'婺源县',361100),(361181,'德兴市',361100),(370000,'山东省',NULL),(370100,'济南市',370000),(370102,'历下区',370100),(370103,'市中区',370100),(370104,'槐荫区',370100),(370105,'天桥区',370100),(370112,'历城区',370100),(370113,'长清区',370100),(370124,'平阴县',370100),(370125,'济阳县',370100),(370126,'商河县',370100),(370181,'章丘市',370100),(370200,'青岛市',370000),(370202,'市南区',370200),(370203,'市北区',370200),(370211,'黄岛区',370200),(370212,'崂山区',370200),(370213,'李沧区',370200),(370214,'城阳区',370200),(370281,'胶州市',370200),(370282,'即墨市',370200),(370283,'平度市',370200),(370285,'莱西市',370200),(370300,'淄博市',370000),(370302,'淄川区',370300),(370303,'张店区',370300),(370304,'博山区',370300),(370305,'临淄区',370300),(370306,'周村区',370300),(370321,'桓台县',370300),(370322,'高青县',370300),(370323,'沂源县',370300),(370400,'枣庄市',370000),(370402,'市中区',370400),(370403,'薛城区',370400),(370404,'峄城区',370400),(370405,'台儿庄区',370400),(370406,'山亭区',370400),(370481,'滕州市',370400),(370500,'东营市',370000),(370502,'东营区',370500),(370503,'河口区',370500),(370505,'垦利区',370500),(370522,'利津县',370500),(370523,'广饶县',370500),(370600,'烟台市',370000),(370602,'芝罘区',370600),(370611,'福山区',370600),(370612,'牟平区',370600),(370613,'莱山区',370600),(370634,'长岛县',370600),(370681,'龙口市',370600),(370682,'莱阳市',370600),(370683,'莱州市',370600),(370684,'蓬莱市',370600),(370685,'招远市',370600),(370686,'栖霞市',370600),(370687,'海阳市',370600),(370700,'潍坊市',370000),(370702,'潍城区',370700),(370703,'寒亭区',370700),(370704,'坊子区',370700),(370705,'奎文区',370700),(370724,'临朐县',370700),(370725,'昌乐县',370700),(370781,'青州市',370700),(370782,'诸城市',370700),(370783,'寿光市',370700),(370784,'安丘市',370700),(370785,'高密市',370700),(370786,'昌邑市',370700),(370800,'济宁市',370000),(370811,'任城区',370800),(370812,'兖州区',370800),(370826,'微山县',370800),(370827,'鱼台县',370800),(370828,'金乡县',370800),(370829,'嘉祥县',370800),(370830,'汶上县',370800),(370831,'泗水县',370800),(370832,'梁山县',370800),(370881,'曲阜市',370800),(370883,'邹城市',370800),(370900,'泰安市',370000),(370902,'泰山区',370900),(370911,'岱岳区',370900),(370921,'宁阳县',370900),(370923,'东平县',370900),(370982,'新泰市',370900),(370983,'肥城市',370900),(371000,'威海市',370000),(371002,'环翠区',371000),(371003,'文登区',371000),(371082,'荣成市',371000),(371083,'乳山市',371000),(371100,'日照市',370000),(371102,'东港区',371100),(371103,'岚山区',371100),(371121,'五莲县',371100),(371122,'莒县',371100),(371200,'莱芜市',370000),(371202,'莱城区',371200),(371203,'钢城区',371200),(371300,'临沂市',370000),(371302,'兰山区',371300),(371311,'罗庄区',371300),(371312,'河东区',371300),(371321,'沂南县',371300),(371322,'郯城县',371300),(371323,'沂水县',371300),(371324,'兰陵县',371300),(371325,'费县',371300),(371326,'平邑县',371300),(371327,'莒南县',371300),(371328,'蒙阴县',371300),(371329,'临沭县',371300),(371400,'德州市',370000),(371402,'德城区',371400),(371403,'陵城区',371400),(371422,'宁津县',371400),(371423,'庆云县',371400),(371424,'临邑县',371400),(371425,'齐河县',371400),(371426,'平原县',371400),(371427,'夏津县',371400),(371428,'武城县',371400),(371481,'乐陵市',371400),(371482,'禹城市',371400),(371500,'聊城市',370000),(371502,'东昌府区',371500),(371521,'阳谷县',371500),(371522,'莘县',371500),(371523,'茌平县',371500),(371524,'东阿县',371500),(371525,'冠县',371500),(371526,'高唐县',371500),(371581,'临清市',371500),(371600,'滨州市',370000),(371602,'滨城区',371600),(371603,'沾化区',371600),(371621,'惠民县',371600),(371622,'阳信县',371600),(371623,'无棣县',371600),(371625,'博兴县',371600),(371626,'邹平县',371600),(371700,'菏泽市',370000),(371702,'牡丹区',371700),(371703,'定陶区',371700),(371721,'曹县',371700),(371722,'单县',371700),(371723,'成武县',371700),(371724,'巨野县',371700),(371725,'郓城县',371700),(371726,'鄄城县',371700),(371728,'东明县',371700),(410000,'河南省',NULL),(410100,'郑州市',410000),(410102,'中原区',410100),(410103,'二七区',410100),(410104,'管城回族区',410100),(410105,'金水区',410100),(410106,'上街区',410100),(410108,'惠济区',410100),(410122,'中牟县',410100),(410181,'巩义市',410100),(410182,'荥阳市',410100),(410183,'新密市',410100),(410184,'新郑市',410100),(410185,'登封市',410100),(410200,'开封市',410000),(410202,'龙亭区',410200),(410203,'顺河回族区',410200),(410204,'鼓楼区',410200),(410205,'禹王台区',410200),(410211,'金明区',410200),(410212,'祥符区',410200),(410221,'杞县',410200),(410222,'通许县',410200),(410223,'尉氏县',410200),(410225,'兰考县',410200),(410300,'洛阳市',410000),(410302,'老城区',410300),(410303,'西工区',410300),(410304,'瀍河回族区',410300),(410305,'涧西区',410300),(410306,'吉利区',410300),(410311,'洛龙区',410300),(410322,'孟津县',410300),(410323,'新安县',410300),(410324,'栾川县',410300),(410325,'嵩县',410300),(410326,'汝阳县',410300),(410327,'宜阳县',410300),(410328,'洛宁县',410300),(410329,'伊川县',410300),(410381,'偃师市',410300),(410400,'平顶山市',410000),(410402,'新华区',410400),(410403,'卫东区',410400),(410404,'石龙区',410400),(410411,'湛河区',410400),(410421,'宝丰县',410400),(410422,'叶县',410400),(410423,'鲁山县',410400),(410425,'郏县',410400),(410481,'舞钢市',410400),(410482,'汝州市',410400),(410500,'安阳市',410000),(410502,'文峰区',410500),(410503,'北关区',410500),(410505,'殷都区',410500),(410506,'龙安区',410500),(410522,'安阳县',410500),(410523,'汤阴县',410500),(410526,'滑县',410500),(410527,'内黄县',410500),(410581,'林州市',410500),(410600,'鹤壁市',410000),(410602,'鹤山区',410600),(410603,'山城区',410600),(410611,'淇滨区',410600),(410621,'浚县',410600),(410622,'淇县',410600),(410700,'新乡市',410000),(410702,'红旗区',410700),(410703,'卫滨区',410700),(410704,'凤泉区',410700),(410711,'牧野区',410700),(410721,'新乡县',410700),(410724,'获嘉县',410700),(410725,'原阳县',410700),(410726,'延津县',410700),(410727,'封丘县',410700),(410728,'长垣县',410700),(410781,'卫辉市',410700),(410782,'辉县市',410700),(410800,'焦作市',410000),(410802,'解放区',410800),(410803,'中站区',410800),(410804,'马村区',410800),(410811,'山阳区',410800),(410821,'修武县',410800),(410822,'博爱县',410800),(410823,'武陟县',410800),(410825,'温县',410800),(410882,'沁阳市',410800),(410883,'孟州市',410800),(410900,'濮阳市',410000),(410902,'华龙区',410900),(410922,'清丰县',410900),(410923,'南乐县',410900),(410926,'范县',410900),(410927,'台前县',410900),(410928,'濮阳县',410900),(411000,'许昌市',410000),(411002,'魏都区',411000),(411023,'许昌县',411000),(411024,'鄢陵县',411000),(411025,'襄城县',411000),(411081,'禹州市',411000),(411082,'长葛市',411000),(411100,'漯河市',410000),(411102,'源汇区',411100),(411103,'郾城区',411100),(411104,'召陵区',411100),(411121,'舞阳县',411100),(411122,'临颍县',411100),(411200,'三门峡市',410000),(411202,'湖滨区',411200),(411203,'陕州区',411200),(411221,'渑池县',411200),(411224,'卢氏县',411200),(411281,'义马市',411200),(411282,'灵宝市',411200),(411300,'南阳市',410000),(411302,'宛城区',411300),(411303,'卧龙区',411300),(411321,'南召县',411300),(411322,'方城县',411300),(411323,'西峡县',411300),(411324,'镇平县',411300),(411325,'内乡县',411300),(411326,'淅川县',411300),(411327,'社旗县',411300),(411328,'唐河县',411300),(411329,'新野县',411300),(411330,'桐柏县',411300),(411381,'邓州市',411300),(411400,'商丘市',410000),(411402,'梁园区',411400),(411403,'睢阳区',411400),(411421,'民权县',411400),(411422,'睢县',411400),(411423,'宁陵县',411400),(411424,'柘城县',411400),(411425,'虞城县',411400),(411426,'夏邑县',411400),(411481,'永城市',411400),(411500,'信阳市',410000),(411502,'浉河区',411500),(411503,'平桥区',411500),(411521,'罗山县',411500),(411522,'光山县',411500),(411523,'新县',411500),(411524,'商城县',411500),(411525,'固始县',411500),(411526,'潢川县',411500),(411527,'淮滨县',411500),(411528,'息县',411500),(411600,'周口市',410000),(411602,'川汇区',411600),(411621,'扶沟县',411600),(411622,'西华县',411600),(411623,'商水县',411600),(411624,'沈丘县',411600),(411625,'郸城县',411600),(411626,'淮阳县',411600),(411627,'太康县',411600),(411628,'鹿邑县',411600),(411681,'项城市',411600),(411700,'驻马店市',410000),(411702,'驿城区',411700),(411721,'西平县',411700),(411722,'上蔡县',411700),(411723,'平舆县',411700),(411724,'正阳县',411700),(411725,'确山县',411700),(411726,'泌阳县',411700),(411727,'汝南县',411700),(411728,'遂平县',411700),(411729,'新蔡县',411700),(419000,'省直辖县级行政区划',410000),(419001,'济源市',419000),(420000,'湖北省',NULL),(420100,'武汉市',420000),(420102,'江岸区',420100),(420103,'江汉区',420100),(420104,'硚口区',420100),(420105,'汉阳区',420100),(420106,'武昌区',420100),(420107,'青山区',420100),(420111,'洪山区',420100),(420112,'东西湖区',420100),(420113,'汉南区',420100),(420114,'蔡甸区',420100),(420115,'江夏区',420100),(420116,'黄陂区',420100),(420117,'新洲区',420100),(420200,'黄石市',420000),(420202,'黄石港区',420200),(420203,'西塞山区',420200),(420204,'下陆区',420200),(420205,'铁山区',420200),(420222,'阳新县',420200),(420281,'大冶市',420200),(420300,'十堰市',420000),(420302,'茅箭区',420300),(420303,'张湾区',420300),(420304,'郧阳区',420300),(420322,'郧西县',420300),(420323,'竹山县',420300),(420324,'竹溪县',420300),(420325,'房县',420300),(420381,'丹江口市',420300),(420500,'宜昌市',420000),(420502,'西陵区',420500),(420503,'伍家岗区',420500),(420504,'点军区',420500),(420505,'猇亭区',420500),(420506,'夷陵区',420500),(420525,'远安县',420500),(420526,'兴山县',420500),(420527,'秭归县',420500),(420528,'长阳土家族自治县',420500),(420529,'五峰土家族自治县',420500),(420581,'宜都市',420500),(420582,'当阳市',420500),(420583,'枝江市',420500),(420600,'襄阳市',420000),(420602,'襄城区',420600),(420606,'樊城区',420600),(420607,'襄州区',420600),(420624,'南漳县',420600),(420625,'谷城县',420600),(420626,'保康县',420600),(420682,'老河口市',420600),(420683,'枣阳市',420600),(420684,'宜城市',420600),(420700,'鄂州市',420000),(420702,'梁子湖区',420700),(420703,'华容区',420700),(420704,'鄂城区',420700),(420800,'荆门市',420000),(420802,'东宝区',420800),(420804,'掇刀区',420800),(420821,'京山县',420800),(420822,'沙洋县',420800),(420881,'钟祥市',420800),(420900,'孝感市',420000),(420902,'孝南区',420900),(420921,'孝昌县',420900),(420922,'大悟县',420900),(420923,'云梦县',420900),(420981,'应城市',420900),(420982,'安陆市',420900),(420984,'汉川市',420900),(421000,'荆州市',420000),(421002,'沙市区',421000),(421003,'荆州区',421000),(421022,'公安县',421000),(421023,'监利县',421000),(421024,'江陵县',421000),(421081,'石首市',421000),(421083,'洪湖市',421000),(421087,'松滋市',421000),(421100,'黄冈市',420000),(421102,'黄州区',421100),(421121,'团风县',421100),(421122,'红安县',421100),(421123,'罗田县',421100),(421124,'英山县',421100),(421125,'浠水县',421100),(421126,'蕲春县',421100),(421127,'黄梅县',421100),(421181,'麻城市',421100),(421182,'武穴市',421100),(421200,'咸宁市',420000),(421202,'咸安区',421200),(421221,'嘉鱼县',421200),(421222,'通城县',421200),(421223,'崇阳县',421200),(421224,'通山县',421200),(421281,'赤壁市',421200),(421300,'随州市',420000),(421303,'曾都区',421300),(421321,'随县',421300),(421381,'广水市',421300),(422800,'恩施土家族苗族自治州',420000),(422801,'恩施市',422800),(422802,'利川市',422800),(422822,'建始县',422800),(422823,'巴东县',422800),(422825,'宣恩县',422800),(422826,'咸丰县',422800),(422827,'来凤县',422800),(422828,'鹤峰县',422800),(429000,'省直辖县级行政区划',420000),(429004,'仙桃市',429000),(429005,'潜江市',429000),(429006,'天门市',429000),(429021,'神农架林区',429000),(430000,'湖南省',NULL),(430100,'长沙市',430000),(430102,'芙蓉区',430100),(430103,'天心区',430100),(430104,'岳麓区',430100),(430105,'开福区',430100),(430111,'雨花区',430100),(430112,'望城区',430100),(430121,'长沙县',430100),(430124,'宁乡县',430100),(430181,'浏阳市',430100),(430200,'株洲市',430000),(430202,'荷塘区',430200),(430203,'芦淞区',430200),(430204,'石峰区',430200),(430211,'天元区',430200),(430221,'株洲县',430200),(430223,'攸县',430200),(430224,'茶陵县',430200),(430225,'炎陵县',430200),(430281,'醴陵市',430200),(430300,'湘潭市',430000),(430302,'雨湖区',430300),(430304,'岳塘区',430300),(430321,'湘潭县',430300),(430381,'湘乡市',430300),(430382,'韶山市',430300),(430400,'衡阳市',430000),(430405,'珠晖区',430400),(430406,'雁峰区',430400),(430407,'石鼓区',430400),(430408,'蒸湘区',430400),(430412,'南岳区',430400),(430421,'衡阳县',430400),(430422,'衡南县',430400),(430423,'衡山县',430400),(430424,'衡东县',430400),(430426,'祁东县',430400),(430481,'耒阳市',430400),(430482,'常宁市',430400),(430500,'邵阳市',430000),(430502,'双清区',430500),(430503,'大祥区',430500),(430511,'北塔区',430500),(430521,'邵东县',430500),(430522,'新邵县',430500),(430523,'邵阳县',430500),(430524,'隆回县',430500),(430525,'洞口县',430500),(430527,'绥宁县',430500),(430528,'新宁县',430500),(430529,'城步苗族自治县',430500),(430581,'武冈市',430500),(430600,'岳阳市',430000),(430602,'岳阳楼区',430600),(430603,'云溪区',430600),(430611,'君山区',430600),(430621,'岳阳县',430600),(430623,'华容县',430600),(430624,'湘阴县',430600),(430626,'平江县',430600),(430681,'汨罗市',430600),(430682,'临湘市',430600),(430700,'常德市',430000),(430702,'武陵区',430700),(430703,'鼎城区',430700),(430721,'安乡县',430700),(430722,'汉寿县',430700),(430723,'澧县',430700),(430724,'临澧县',430700),(430725,'桃源县',430700),(430726,'石门县',430700),(430781,'津市市',430700),(430800,'张家界市',430000),(430802,'永定区',430800),(430811,'武陵源区',430800),(430821,'慈利县',430800),(430822,'桑植县',430800),(430900,'益阳市',430000),(430902,'资阳区',430900),(430903,'赫山区',430900),(430921,'南县',430900),(430922,'桃江县',430900),(430923,'安化县',430900),(430981,'沅江市',430900),(431000,'郴州市',430000),(431002,'北湖区',431000),(431003,'苏仙区',431000),(431021,'桂阳县',431000),(431022,'宜章县',431000),(431023,'永兴县',431000),(431024,'嘉禾县',431000),(431025,'临武县',431000),(431026,'汝城县',431000),(431027,'桂东县',431000),(431028,'安仁县',431000),(431081,'资兴市',431000),(431100,'永州市',430000),(431102,'零陵区',431100),(431103,'冷水滩区',431100),(431121,'祁阳县',431100),(431122,'东安县',431100),(431123,'双牌县',431100),(431124,'道县',431100),(431125,'江永县',431100),(431126,'宁远县',431100),(431127,'蓝山县',431100),(431128,'新田县',431100),(431129,'江华瑶族自治县',431100),(431200,'怀化市',430000),(431202,'鹤城区',431200),(431221,'中方县',431200),(431222,'沅陵县',431200),(431223,'辰溪县',431200),(431224,'溆浦县',431200),(431225,'会同县',431200),(431226,'麻阳苗族自治县',431200),(431227,'新晃侗族自治县',431200),(431228,'芷江侗族自治县',431200),(431229,'靖州苗族侗族自治县',431200),(431230,'通道侗族自治县',431200),(431281,'洪江市',431200),(431300,'娄底市',430000),(431302,'娄星区',431300),(431321,'双峰县',431300),(431322,'新化县',431300),(431381,'冷水江市',431300),(431382,'涟源市',431300),(433100,'湘西土家族苗族自治州',430000),(433101,'吉首市',433100),(433122,'泸溪县',433100),(433123,'凤凰县',433100),(433124,'花垣县',433100),(433125,'保靖县',433100),(433126,'古丈县',433100),(433127,'永顺县',433100),(433130,'龙山县',433100),(440000,'广东省',NULL),(440100,'广州市',440000),(440103,'荔湾区',440100),(440104,'越秀区',440100),(440105,'海珠区',440100),(440106,'天河区',440100),(440111,'白云区',440100),(440112,'黄埔区',440100),(440113,'番禺区',440100),(440114,'花都区',440100),(440115,'南沙区',440100),(440117,'从化区',440100),(440118,'增城区',440100),(440200,'韶关市',440000),(440203,'武江区',440200),(440204,'浈江区',440200),(440205,'曲江区',440200),(440222,'始兴县',440200),(440224,'仁化县',440200),(440229,'翁源县',440200),(440232,'乳源瑶族自治县',440200),(440233,'新丰县',440200),(440281,'乐昌市',440200),(440282,'南雄市',440200),(440300,'深圳市',440000),(440303,'罗湖区',440300),(440304,'福田区',440300),(440305,'南山区',440300),(440306,'宝安区',440300),(440307,'龙岗区',440300),(440308,'盐田区',440300),(440400,'珠海市',440000),(440402,'香洲区',440400),(440403,'斗门区',440400),(440404,'金湾区',440400),(440500,'汕头市',440000),(440507,'龙湖区',440500),(440511,'金平区',440500),(440512,'濠江区',440500),(440513,'潮阳区',440500),(440514,'潮南区',440500),(440515,'澄海区',440500),(440523,'南澳县',440500),(440600,'佛山市',440000),(440604,'禅城区',440600),(440605,'南海区',440600),(440606,'顺德区',440600),(440607,'三水区',440600),(440608,'高明区',440600),(440700,'江门市',440000),(440703,'蓬江区',440700),(440704,'江海区',440700),(440705,'新会区',440700),(440781,'台山市',440700),(440783,'开平市',440700),(440784,'鹤山市',440700),(440785,'恩平市',440700),(440800,'湛江市',440000),(440802,'赤坎区',440800),(440803,'霞山区',440800),(440804,'坡头区',440800),(440811,'麻章区',440800),(440823,'遂溪县',440800),(440825,'徐闻县',440800),(440881,'廉江市',440800),(440882,'雷州市',440800),(440883,'吴川市',440800),(440900,'茂名市',440000),(440902,'茂南区',440900),(440904,'电白区',440900),(440981,'高州市',440900),(440982,'化州市',440900),(440983,'信宜市',440900),(441200,'肇庆市',440000),(441202,'端州区',441200),(441203,'鼎湖区',441200),(441204,'高要区',441200),(441223,'广宁县',441200),(441224,'怀集县',441200),(441225,'封开县',441200),(441226,'德庆县',441200),(441284,'四会市',441200),(441300,'惠州市',440000),(441302,'惠城区',441300),(441303,'惠阳区',441300),(441322,'博罗县',441300),(441323,'惠东县',441300),(441324,'龙门县',441300),(441400,'梅州市',440000),(441402,'梅江区',441400),(441403,'梅县区',441400),(441422,'大埔县',441400),(441423,'丰顺县',441400),(441424,'五华县',441400),(441426,'平远县',441400),(441427,'蕉岭县',441400),(441481,'兴宁市',441400),(441500,'汕尾市',440000),(441502,'城区',441500),(441521,'海丰县',441500),(441523,'陆河县',441500),(441581,'陆丰市',441500),(441600,'河源市',440000),(441602,'源城区',441600),(441621,'紫金县',441600),(441622,'龙川县',441600),(441623,'连平县',441600),(441624,'和平县',441600),(441625,'东源县',441600),(441700,'阳江市',440000),(441702,'江城区',441700),(441704,'阳东区',441700),(441721,'阳西县',441700),(441781,'阳春市',441700),(441800,'清远市',440000),(441802,'清城区',441800),(441803,'清新区',441800),(441821,'佛冈县',441800),(441823,'阳山县',441800),(441825,'连山壮族瑶族自治县',441800),(441826,'连南瑶族自治县',441800),(441881,'英德市',441800),(441882,'连州市',441800),(441900,'东莞市',440000),(442000,'中山市',440000),(445100,'潮州市',440000),(445102,'湘桥区',445100),(445103,'潮安区',445100),(445122,'饶平县',445100),(445200,'揭阳市',440000),(445202,'榕城区',445200),(445203,'揭东区',445200),(445222,'揭西县',445200),(445224,'惠来县',445200),(445281,'普宁市',445200),(445300,'云浮市',440000),(445302,'云城区',445300),(445303,'云安区',445300),(445321,'新兴县',445300),(445322,'郁南县',445300),(445381,'罗定市',445300),(450000,'广西壮族自治区',NULL),(450100,'南宁市',450000),(450102,'兴宁区',450100),(450103,'青秀区',450100),(450105,'江南区',450100),(450107,'西乡塘区',450100),(450108,'良庆区',450100),(450109,'邕宁区',450100),(450110,'武鸣区',450100),(450123,'隆安县',450100),(450124,'马山县',450100),(450125,'上林县',450100),(450126,'宾阳县',450100),(450127,'横县',450100),(450200,'柳州市',450000),(450202,'城中区',450200),(450203,'鱼峰区',450200),(450204,'柳南区',450200),(450205,'柳北区',450200),(450206,'柳江区',450200),(450222,'柳城县',450200),(450223,'鹿寨县',450200),(450224,'融安县',450200),(450225,'融水苗族自治县',450200),(450226,'三江侗族自治县',450200),(450300,'桂林市',450000),(450302,'秀峰区',450300),(450303,'叠彩区',450300),(450304,'象山区',450300),(450305,'七星区',450300),(450311,'雁山区',450300),(450312,'临桂区',450300),(450321,'阳朔县',450300),(450323,'灵川县',450300),(450324,'全州县',450300),(450325,'兴安县',450300),(450326,'永福县',450300),(450327,'灌阳县',450300),(450328,'龙胜各族自治县',450300),(450329,'资源县',450300),(450330,'平乐县',450300),(450331,'荔浦县',450300),(450332,'恭城瑶族自治县',450300),(450400,'梧州市',450000),(450403,'万秀区',450400),(450405,'长洲区',450400),(450406,'龙圩区',450400),(450421,'苍梧县',450400),(450422,'藤县',450400),(450423,'蒙山县',450400),(450481,'岑溪市',450400),(450500,'北海市',450000),(450502,'海城区',450500),(450503,'银海区',450500),(450512,'铁山港区',450500),(450521,'合浦县',450500),(450600,'防城港市',450000),(450602,'港口区',450600),(450603,'防城区',450600),(450621,'上思县',450600),(450681,'东兴市',450600),(450700,'钦州市',450000),(450702,'钦南区',450700),(450703,'钦北区',450700),(450721,'灵山县',450700),(450722,'浦北县',450700),(450800,'贵港市',450000),(450802,'港北区',450800),(450803,'港南区',450800),(450804,'覃塘区',450800),(450821,'平南县',450800),(450881,'桂平市',450800),(450900,'玉林市',450000),(450902,'玉州区',450900),(450903,'福绵区',450900),(450921,'容县',450900),(450922,'陆川县',450900),(450923,'博白县',450900),(450924,'兴业县',450900),(450981,'北流市',450900),(451000,'百色市',450000),(451002,'右江区',451000),(451021,'田阳县',451000),(451022,'田东县',451000),(451023,'平果县',451000),(451024,'德保县',451000),(451026,'那坡县',451000),(451027,'凌云县',451000),(451028,'乐业县',451000),(451029,'田林县',451000),(451030,'西林县',451000),(451031,'隆林各族自治县',451000),(451081,'靖西市',451000),(451100,'贺州市',450000),(451102,'八步区',451100),(451103,'平桂区',451100),(451121,'昭平县',451100),(451122,'钟山县',451100),(451123,'富川瑶族自治县',451100),(451200,'河池市',450000),(451202,'金城江区',451200),(451221,'南丹县',451200),(451222,'天峨县',451200),(451223,'凤山县',451200),(451224,'东兰县',451200),(451225,'罗城仫佬族自治县',451200),(451226,'环江毛南族自治县',451200),(451227,'巴马瑶族自治县',451200),(451228,'都安瑶族自治县',451200),(451229,'大化瑶族自治县',451200),(451281,'宜州市',451200),(451300,'来宾市',450000),(451302,'兴宾区',451300),(451321,'忻城县',451300),(451322,'象州县',451300),(451323,'武宣县',451300),(451324,'金秀瑶族自治县',451300),(451381,'合山市',451300),(451400,'崇左市',450000),(451402,'江州区',451400),(451421,'扶绥县',451400),(451422,'宁明县',451400),(451423,'龙州县',451400),(451424,'大新县',451400),(451425,'天等县',451400),(451481,'凭祥市',451400),(460000,'海南省',NULL),(460100,'海口市',460000),(460105,'秀英区',460100),(460106,'龙华区',460100),(460107,'琼山区',460100),(460108,'美兰区',460100),(460200,'三亚市',460000),(460202,'海棠区',460200),(460203,'吉阳区',460200),(460204,'天涯区',460200),(460205,'崖州区',460200),(460300,'三沙市',460000),(460400,'儋州市',460000),(469000,'省直辖县级行政区划',460000),(469001,'五指山市',469000),(469002,'琼海市',469000),(469005,'文昌市',469000),(469006,'万宁市',469000),(469007,'东方市',469000),(469021,'定安县',469000),(469022,'屯昌县',469000),(469023,'澄迈县',469000),(469024,'临高县',469000),(469025,'白沙黎族自治县',469000),(469026,'昌江黎族自治县',469000),(469027,'乐东黎族自治县',469000),(469028,'陵水黎族自治县',469000),(469029,'保亭黎族苗族自治县',469000),(469030,'琼中黎族苗族自治县',469000),(500000,'重庆市',NULL),(500100,'重庆市',500000),(500101,'万州区',500100),(500102,'涪陵区',500100),(500103,'渝中区',500100),(500104,'大渡口区',500100),(500105,'江北区',500100),(500106,'沙坪坝区',500100),(500107,'九龙坡区',500100),(500108,'南岸区',500100),(500109,'北碚区',500100),(500110,'綦江区',500100),(500111,'大足区',500100),(500112,'渝北区',500100),(500113,'巴南区',500100),(500114,'黔江区',500100),(500115,'长寿区',500100),(500116,'江津区',500100),(500117,'合川区',500100),(500118,'永川区',500100),(500119,'南川区',500100),(500120,'璧山区',500100),(500151,'铜梁区',500100),(500152,'潼南区',500100),(500153,'荣昌区',500100),(500154,'开州区',500100),(500200,'县',500000),(500228,'梁平县',500200),(500229,'城口县',500200),(500230,'丰都县',500200),(500231,'垫江县',500200),(500232,'武隆县',500200),(500233,'忠县',500200),(500235,'云阳县',500200),(500236,'奉节县',500200),(500237,'巫山县',500200),(500238,'巫溪县',500200),(500240,'石柱土家族自治县',500200),(500241,'秀山土家族苗族自治县',500200),(500242,'酉阳土家族苗族自治县',500200),(500243,'彭水苗族土家族自治县',500200),(510000,'四川省',NULL),(510100,'成都市',510000),(510104,'锦江区',510100),(510105,'青羊区',510100),(510106,'金牛区',510100),(510107,'武侯区',510100),(510108,'成华区',510100),(510112,'龙泉驿区',510100),(510113,'青白江区',510100),(510114,'新都区',510100),(510115,'温江区',510100),(510116,'双流区',510100),(510121,'金堂县',510100),(510124,'郫县',510100),(510129,'大邑县',510100),(510131,'蒲江县',510100),(510132,'新津县',510100),(510181,'都江堰市',510100),(510182,'彭州市',510100),(510183,'邛崃市',510100),(510184,'崇州市',510100),(510185,'简阳市',510100),(510300,'自贡市',510000),(510302,'自流井区',510300),(510303,'贡井区',510300),(510304,'大安区',510300),(510311,'沿滩区',510300),(510321,'荣县',510300),(510322,'富顺县',510300),(510400,'攀枝花市',510000),(510402,'东区',510400),(510403,'西区',510400),(510411,'仁和区',510400),(510421,'米易县',510400),(510422,'盐边县',510400),(510500,'泸州市',510000),(510502,'江阳区',510500),(510503,'纳溪区',510500),(510504,'龙马潭区',510500),(510521,'泸县',510500),(510522,'合江县',510500),(510524,'叙永县',510500),(510525,'古蔺县',510500),(510600,'德阳市',510000),(510603,'旌阳区',510600),(510623,'中江县',510600),(510626,'罗江县',510600),(510681,'广汉市',510600),(510682,'什邡市',510600),(510683,'绵竹市',510600),(510700,'绵阳市',510000),(510703,'涪城区',510700),(510704,'游仙区',510700),(510705,'安州区',510700),(510722,'三台县',510700),(510723,'盐亭县',510700),(510725,'梓潼县',510700),(510726,'北川羌族自治县',510700),(510727,'平武县',510700),(510781,'江油市',510700),(510800,'广元市',510000),(510802,'利州区',510800),(510811,'昭化区',510800),(510812,'朝天区',510800),(510821,'旺苍县',510800),(510822,'青川县',510800),(510823,'剑阁县',510800),(510824,'苍溪县',510800),(510900,'遂宁市',510000),(510903,'船山区',510900),(510904,'安居区',510900),(510921,'蓬溪县',510900),(510922,'射洪县',510900),(510923,'大英县',510900),(511000,'内江市',510000),(511002,'市中区',511000),(511011,'东兴区',511000),(511024,'威远县',511000),(511025,'资中县',511000),(511028,'隆昌县',511000),(511100,'乐山市',510000),(511102,'市中区',511100),(511111,'沙湾区',511100),(511112,'五通桥区',511100),(511113,'金口河区',511100),(511123,'犍为县',511100),(511124,'井研县',511100),(511126,'夹江县',511100),(511129,'沐川县',511100),(511132,'峨边彝族自治县',511100),(511133,'马边彝族自治县',511100),(511181,'峨眉山市',511100),(511300,'南充市',510000),(511302,'顺庆区',511300),(511303,'高坪区',511300),(511304,'嘉陵区',511300),(511321,'南部县',511300),(511322,'营山县',511300),(511323,'蓬安县',511300),(511324,'仪陇县',511300),(511325,'西充县',511300),(511381,'阆中市',511300),(511400,'眉山市',510000),(511402,'东坡区',511400),(511403,'彭山区',511400),(511421,'仁寿县',511400),(511423,'洪雅县',511400),(511424,'丹棱县',511400),(511425,'青神县',511400),(511500,'宜宾市',510000),(511502,'翠屏区',511500),(511503,'南溪区',511500),(511521,'宜宾县',511500),(511523,'江安县',511500),(511524,'长宁县',511500),(511525,'高县',511500),(511526,'珙县',511500),(511527,'筠连县',511500),(511528,'兴文县',511500),(511529,'屏山县',511500),(511600,'广安市',510000),(511602,'广安区',511600),(511603,'前锋区',511600),(511621,'岳池县',511600),(511622,'武胜县',511600),(511623,'邻水县',511600),(511681,'华蓥市',511600),(511700,'达州市',510000),(511702,'通川区',511700),(511703,'达川区',511700),(511722,'宣汉县',511700),(511723,'开江县',511700),(511724,'大竹县',511700),(511725,'渠县',511700),(511781,'万源市',511700),(511800,'雅安市',510000),(511802,'雨城区',511800),(511803,'名山区',511800),(511822,'荥经县',511800),(511823,'汉源县',511800),(511824,'石棉县',511800),(511825,'天全县',511800),(511826,'芦山县',511800),(511827,'宝兴县',511800),(511900,'巴中市',510000),(511902,'巴州区',511900),(511903,'恩阳区',511900),(511921,'通江县',511900),(511922,'南江县',511900),(511923,'平昌县',511900),(512000,'资阳市',510000),(512002,'雁江区',512000),(512021,'安岳县',512000),(512022,'乐至县',512000),(513200,'阿坝藏族羌族自治州',510000),(513201,'马尔康市',513200),(513221,'汶川县',513200),(513222,'理县',513200),(513223,'茂县',513200),(513224,'松潘县',513200),(513225,'九寨沟县',513200),(513226,'金川县',513200),(513227,'小金县',513200),(513228,'黑水县',513200),(513230,'壤塘县',513200),(513231,'阿坝县',513200),(513232,'若尔盖县',513200),(513233,'红原县',513200),(513300,'甘孜藏族自治州',510000),(513301,'康定市',513300),(513322,'泸定县',513300),(513323,'丹巴县',513300),(513324,'九龙县',513300),(513325,'雅江县',513300),(513326,'道孚县',513300),(513327,'炉霍县',513300),(513328,'甘孜县',513300),(513329,'新龙县',513300),(513330,'德格县',513300),(513331,'白玉县',513300),(513332,'石渠县',513300),(513333,'色达县',513300),(513334,'理塘县',513300),(513335,'巴塘县',513300),(513336,'乡城县',513300),(513337,'稻城县',513300),(513338,'得荣县',513300),(513400,'凉山彝族自治州',510000),(513401,'西昌市',513400),(513422,'木里藏族自治县',513400),(513423,'盐源县',513400),(513424,'德昌县',513400),(513425,'会理县',513400),(513426,'会东县',513400),(513427,'宁南县',513400),(513428,'普格县',513400),(513429,'布拖县',513400),(513430,'金阳县',513400),(513431,'昭觉县',513400),(513432,'喜德县',513400),(513433,'冕宁县',513400),(513434,'越西县',513400),(513435,'甘洛县',513400),(513436,'美姑县',513400),(513437,'雷波县',513400),(520000,'贵州省',NULL),(520100,'贵阳市',520000),(520102,'南明区',520100),(520103,'云岩区',520100),(520111,'花溪区',520100),(520112,'乌当区',520100),(520113,'白云区',520100),(520115,'观山湖区',520100),(520121,'开阳县',520100),(520122,'息烽县',520100),(520123,'修文县',520100),(520181,'清镇市',520100),(520200,'六盘水市',520000),(520201,'钟山区',520200),(520203,'六枝特区',520200),(520221,'水城县',520200),(520222,'盘县',520200),(520300,'遵义市',520000),(520302,'红花岗区',520300),(520303,'汇川区',520300),(520304,'播州区',520300),(520322,'桐梓县',520300),(520323,'绥阳县',520300),(520324,'正安县',520300),(520325,'道真仡佬族苗族自治县',520300),(520326,'务川仡佬族苗族自治县',520300),(520327,'凤冈县',520300),(520328,'湄潭县',520300),(520329,'余庆县',520300),(520330,'习水县',520300),(520381,'赤水市',520300),(520382,'仁怀市',520300),(520400,'安顺市',520000),(520402,'西秀区',520400),(520403,'平坝区',520400),(520422,'普定县',520400),(520423,'镇宁布依族苗族自治县',520400),(520424,'关岭布依族苗族自治县',520400),(520425,'紫云苗族布依族自治县',520400),(520500,'毕节市',520000),(520502,'七星关区',520500),(520521,'大方县',520500),(520522,'黔西县',520500),(520523,'金沙县',520500),(520524,'织金县',520500),(520525,'纳雍县',520500),(520526,'威宁彝族回族苗族自治县',520500),(520527,'赫章县',520500),(520600,'铜仁市',520000),(520602,'碧江区',520600),(520603,'万山区',520600),(520621,'江口县',520600),(520622,'玉屏侗族自治县',520600),(520623,'石阡县',520600),(520624,'思南县',520600),(520625,'印江土家族苗族自治县',520600),(520626,'德江县',520600),(520627,'沿河土家族自治县',520600),(520628,'松桃苗族自治县',520600),(522300,'黔西南布依族苗族自治州',520000),(522301,'兴义市',522300),(522322,'兴仁县',522300),(522323,'普安县',522300),(522324,'晴隆县',522300),(522325,'贞丰县',522300),(522326,'望谟县',522300),(522327,'册亨县',522300),(522328,'安龙县',522300),(522600,'黔东南苗族侗族自治州',520000),(522601,'凯里市',522600),(522622,'黄平县',522600),(522623,'施秉县',522600),(522624,'三穗县',522600),(522625,'镇远县',522600),(522626,'岑巩县',522600),(522627,'天柱县',522600),(522628,'锦屏县',522600),(522629,'剑河县',522600),(522630,'台江县',522600),(522631,'黎平县',522600),(522632,'榕江县',522600),(522633,'从江县',522600),(522634,'雷山县',522600),(522635,'麻江县',522600),(522636,'丹寨县',522600),(522700,'黔南布依族苗族自治州',520000),(522701,'都匀市',522700),(522702,'福泉市',522700),(522722,'荔波县',522700),(522723,'贵定县',522700),(522725,'瓮安县',522700),(522726,'独山县',522700),(522727,'平塘县',522700),(522728,'罗甸县',522700),(522729,'长顺县',522700),(522730,'龙里县',522700),(522731,'惠水县',522700),(522732,'三都水族自治县',522700),(530000,'云南省',NULL),(530100,'昆明市',530000),(530102,'五华区',530100),(530103,'盘龙区',530100),(530111,'官渡区',530100),(530112,'西山区',530100),(530113,'东川区',530100),(530114,'呈贡区',530100),(530122,'晋宁县',530100),(530124,'富民县',530100),(530125,'宜良县',530100),(530126,'石林彝族自治县',530100),(530127,'嵩明县',530100),(530128,'禄劝彝族苗族自治县',530100),(530129,'寻甸回族彝族自治县',530100),(530181,'安宁市',530100),(530300,'曲靖市',530000),(530302,'麒麟区',530300),(530303,'沾益区',530300),(530321,'马龙县',530300),(530322,'陆良县',530300),(530323,'师宗县',530300),(530324,'罗平县',530300),(530325,'富源县',530300),(530326,'会泽县',530300),(530381,'宣威市',530300),(530400,'玉溪市',530000),(530402,'红塔区',530400),(530403,'江川区',530400),(530422,'澄江县',530400),(530423,'通海县',530400),(530424,'华宁县',530400),(530425,'易门县',530400),(530426,'峨山彝族自治县',530400),(530427,'新平彝族傣族自治县',530400),(530428,'元江哈尼族彝族傣族自治县',530400),(530500,'保山市',530000),(530502,'隆阳区',530500),(530521,'施甸县',530500),(530523,'龙陵县',530500),(530524,'昌宁县',530500),(530581,'腾冲市',530500),(530600,'昭通市',530000),(530602,'昭阳区',530600),(530621,'鲁甸县',530600),(530622,'巧家县',530600),(530623,'盐津县',530600),(530624,'大关县',530600),(530625,'永善县',530600),(530626,'绥江县',530600),(530627,'镇雄县',530600),(530628,'彝良县',530600),(530629,'威信县',530600),(530630,'水富县',530600),(530700,'丽江市',530000),(530702,'古城区',530700),(530721,'玉龙纳西族自治县',530700),(530722,'永胜县',530700),(530723,'华坪县',530700),(530724,'宁蒗彝族自治县',530700),(530800,'普洱市',530000),(530802,'思茅区',530800),(530821,'宁洱哈尼族彝族自治县',530800),(530822,'墨江哈尼族自治县',530800),(530823,'景东彝族自治县',530800),(530824,'景谷傣族彝族自治县',530800),(530825,'镇沅彝族哈尼族拉祜族自治县',530800),(530826,'江城哈尼族彝族自治县',530800),(530827,'孟连傣族拉祜族佤族自治县',530800),(530828,'澜沧拉祜族自治县',530800),(530829,'西盟佤族自治县',530800),(530900,'临沧市',530000),(530902,'临翔区',530900),(530921,'凤庆县',530900),(530922,'云县',530900),(530923,'永德县',530900),(530924,'镇康县',530900),(530925,'双江拉祜族佤族布朗族傣族自治县',530900),(530926,'耿马傣族佤族自治县',530900),(530927,'沧源佤族自治县',530900),(532300,'楚雄彝族自治州',530000),(532301,'楚雄市',532300),(532322,'双柏县',532300),(532323,'牟定县',532300),(532324,'南华县',532300),(532325,'姚安县',532300),(532326,'大姚县',532300),(532327,'永仁县',532300),(532328,'元谋县',532300),(532329,'武定县',532300),(532331,'禄丰县',532300),(532500,'红河哈尼族彝族自治州',530000),(532501,'个旧市',532500),(532502,'开远市',532500),(532503,'蒙自市',532500),(532504,'弥勒市',532500),(532523,'屏边苗族自治县',532500),(532524,'建水县',532500),(532525,'石屏县',532500),(532527,'泸西县',532500),(532528,'元阳县',532500),(532529,'红河县',532500),(532530,'金平苗族瑶族傣族自治县',532500),(532531,'绿春县',532500),(532532,'河口瑶族自治县',532500),(532600,'文山壮族苗族自治州',530000),(532601,'文山市',532600),(532622,'砚山县',532600),(532623,'西畴县',532600),(532624,'麻栗坡县',532600),(532625,'马关县',532600),(532626,'丘北县',532600),(532627,'广南县',532600),(532628,'富宁县',532600),(532800,'西双版纳傣族自治州',530000),(532801,'景洪市',532800),(532822,'勐海县',532800),(532823,'勐腊县',532800),(532900,'大理白族自治州',530000),(532901,'大理市',532900),(532922,'漾濞彝族自治县',532900),(532923,'祥云县',532900),(532924,'宾川县',532900),(532925,'弥渡县',532900),(532926,'南涧彝族自治县',532900),(532927,'巍山彝族回族自治县',532900),(532928,'永平县',532900),(532929,'云龙县',532900),(532930,'洱源县',532900),(532931,'剑川县',532900),(532932,'鹤庆县',532900),(533100,'德宏傣族景颇族自治州',530000),(533102,'瑞丽市',533100),(533103,'芒市',533100),(533122,'梁河县',533100),(533123,'盈江县',533100),(533124,'陇川县',533100),(533300,'怒江傈僳族自治州',530000),(533301,'泸水市',533300),(533323,'福贡县',533300),(533324,'贡山独龙族怒族自治县',533300),(533325,'兰坪白族普米族自治县',533300),(533400,'迪庆藏族自治州',530000),(533401,'香格里拉市',533400),(533422,'德钦县',533400),(533423,'维西傈僳族自治县',533400),(540000,'西藏自治区',NULL),(540100,'拉萨市',540000),(540102,'城关区',540100),(540103,'堆龙德庆区',540100),(540121,'林周县',540100),(540122,'当雄县',540100),(540123,'尼木县',540100),(540124,'曲水县',540100),(540126,'达孜县',540100),(540127,'墨竹工卡县',540100),(540200,'日喀则市',540000),(540202,'桑珠孜区',540200),(540221,'南木林县',540200),(540222,'江孜县',540200),(540223,'定日县',540200),(540224,'萨迦县',540200),(540225,'拉孜县',540200),(540226,'昂仁县',540200),(540227,'谢通门县',540200),(540228,'白朗县',540200),(540229,'仁布县',540200),(540230,'康马县',540200),(540231,'定结县',540200),(540232,'仲巴县',540200),(540233,'亚东县',540200),(540234,'吉隆县',540200),(540235,'聂拉木县',540200),(540236,'萨嘎县',540200),(540237,'岗巴县',540200),(540300,'昌都市',540000),(540302,'卡若区',540300),(540321,'江达县',540300),(540322,'贡觉县',540300),(540323,'类乌齐县',540300),(540324,'丁青县',540300),(540325,'察雅县',540300),(540326,'八宿县',540300),(540327,'左贡县',540300),(540328,'芒康县',540300),(540329,'洛隆县',540300),(540330,'边坝县',540300),(540400,'林芝市',540000),(540402,'巴宜区',540400),(540421,'工布江达县',540400),(540422,'米林县',540400),(540423,'墨脱县',540400),(540424,'波密县',540400),(540425,'察隅县',540400),(540426,'朗县',540400),(540500,'山南市',540000),(540502,'乃东区',540500),(540521,'扎囊县',540500),(540522,'贡嘎县',540500),(540523,'桑日县',540500),(540524,'琼结县',540500),(540525,'曲松县',540500),(540526,'措美县',540500),(540527,'洛扎县',540500),(540528,'加查县',540500),(540529,'隆子县',540500),(540530,'错那县',540500),(540531,'浪卡子县',540500),(542400,'那曲地区',540000),(542421,'那曲县',542400),(542422,'嘉黎县',542400),(542423,'比如县',542400),(542424,'聂荣县',542400),(542425,'安多县',542400),(542426,'申扎县',542400),(542427,'索县',542400),(542428,'班戈县',542400),(542429,'巴青县',542400),(542430,'尼玛县',542400),(542431,'双湖县',542400),(542500,'阿里地区',540000),(542521,'普兰县',542500),(542522,'札达县',542500),(542523,'噶尔县',542500),(542524,'日土县',542500),(542525,'革吉县',542500),(542526,'改则县',542500),(542527,'措勤县',542500),(610000,'陕西省',NULL),(610100,'西安市',610000),(610102,'新城区',610100),(610103,'碑林区',610100),(610104,'莲湖区',610100),(610111,'灞桥区',610100),(610112,'未央区',610100),(610113,'雁塔区',610100),(610114,'阎良区',610100),(610115,'临潼区',610100),(610116,'长安区',610100),(610117,'高陵区',610100),(610122,'蓝田县',610100),(610124,'周至县',610100),(610125,'户县',610100),(610200,'铜川市',610000),(610202,'王益区',610200),(610203,'印台区',610200),(610204,'耀州区',610200),(610222,'宜君县',610200),(610300,'宝鸡市',610000),(610302,'渭滨区',610300),(610303,'金台区',610300),(610304,'陈仓区',610300),(610322,'凤翔县',610300),(610323,'岐山县',610300),(610324,'扶风县',610300),(610326,'眉县',610300),(610327,'陇县',610300),(610328,'千阳县',610300),(610329,'麟游县',610300),(610330,'凤县',610300),(610331,'太白县',610300),(610400,'咸阳市',610000),(610402,'秦都区',610400),(610403,'杨陵区',610400),(610404,'渭城区',610400),(610422,'三原县',610400),(610423,'泾阳县',610400),(610424,'乾县',610400),(610425,'礼泉县',610400),(610426,'永寿县',610400),(610427,'彬县',610400),(610428,'长武县',610400),(610429,'旬邑县',610400),(610430,'淳化县',610400),(610431,'武功县',610400),(610481,'兴平市',610400),(610500,'渭南市',610000),(610502,'临渭区',610500),(610503,'华州区',610500),(610522,'潼关县',610500),(610523,'大荔县',610500),(610524,'合阳县',610500),(610525,'澄城县',610500),(610526,'蒲城县',610500),(610527,'白水县',610500),(610528,'富平县',610500),(610581,'韩城市',610500),(610582,'华阴市',610500),(610600,'延安市',610000),(610602,'宝塔区',610600),(610603,'安塞区',610600),(610621,'延长县',610600),(610622,'延川县',610600),(610623,'子长县',610600),(610625,'志丹县',610600),(610626,'吴起县',610600),(610627,'甘泉县',610600),(610628,'富县',610600),(610629,'洛川县',610600),(610630,'宜川县',610600),(610631,'黄龙县',610600),(610632,'黄陵县',610600),(610700,'汉中市',610000),(610702,'汉台区',610700),(610721,'南郑县',610700),(610722,'城固县',610700),(610723,'洋县',610700),(610724,'西乡县',610700),(610725,'勉县',610700),(610726,'宁强县',610700),(610727,'略阳县',610700),(610728,'镇巴县',610700),(610729,'留坝县',610700),(610730,'佛坪县',610700),(610800,'榆林市',610000),(610802,'榆阳区',610800),(610803,'横山区',610800),(610821,'神木县',610800),(610822,'府谷县',610800),(610824,'靖边县',610800),(610825,'定边县',610800),(610826,'绥德县',610800),(610827,'米脂县',610800),(610828,'佳县',610800),(610829,'吴堡县',610800),(610830,'清涧县',610800),(610831,'子洲县',610800),(610900,'安康市',610000),(610902,'汉滨区',610900),(610921,'汉阴县',610900),(610922,'石泉县',610900),(610923,'宁陕县',610900),(610924,'紫阳县',610900),(610925,'岚皋县',610900),(610926,'平利县',610900),(610927,'镇坪县',610900),(610928,'旬阳县',610900),(610929,'白河县',610900),(611000,'商洛市',610000),(611002,'商州区',611000),(611021,'洛南县',611000),(611022,'丹凤县',611000),(611023,'商南县',611000),(611024,'山阳县',611000),(611025,'镇安县',611000),(611026,'柞水县',611000),(620000,'甘肃省',NULL),(620100,'兰州市',620000),(620102,'城关区',620100),(620103,'七里河区',620100),(620104,'西固区',620100),(620105,'安宁区',620100),(620111,'红古区',620100),(620121,'永登县',620100),(620122,'皋兰县',620100),(620123,'榆中县',620100),(620200,'嘉峪关市',620000),(620300,'金昌市',620000),(620302,'金川区',620300),(620321,'永昌县',620300),(620400,'白银市',620000),(620402,'白银区',620400),(620403,'平川区',620400),(620421,'靖远县',620400),(620422,'会宁县',620400),(620423,'景泰县',620400),(620500,'天水市',620000),(620502,'秦州区',620500),(620503,'麦积区',620500),(620521,'清水县',620500),(620522,'秦安县',620500),(620523,'甘谷县',620500),(620524,'武山县',620500),(620525,'张家川回族自治县',620500),(620600,'武威市',620000),(620602,'凉州区',620600),(620621,'民勤县',620600),(620622,'古浪县',620600),(620623,'天祝藏族自治县',620600),(620700,'张掖市',620000),(620702,'甘州区',620700),(620721,'肃南裕固族自治县',620700),(620722,'民乐县',620700),(620723,'临泽县',620700),(620724,'高台县',620700),(620725,'山丹县',620700),(620800,'平凉市',620000),(620802,'崆峒区',620800),(620821,'泾川县',620800),(620822,'灵台县',620800),(620823,'崇信县',620800),(620824,'华亭县',620800),(620825,'庄浪县',620800),(620826,'静宁县',620800),(620900,'酒泉市',620000),(620902,'肃州区',620900),(620921,'金塔县',620900),(620922,'瓜州县',620900),(620923,'肃北蒙古族自治县',620900),(620924,'阿克塞哈萨克族自治县',620900),(620981,'玉门市',620900),(620982,'敦煌市',620900),(621000,'庆阳市',620000),(621002,'西峰区',621000),(621021,'庆城县',621000),(621022,'环县',621000),(621023,'华池县',621000),(621024,'合水县',621000),(621025,'正宁县',621000),(621026,'宁县',621000),(621027,'镇原县',621000),(621100,'定西市',620000),(621102,'安定区',621100),(621121,'通渭县',621100),(621122,'陇西县',621100),(621123,'渭源县',621100),(621124,'临洮县',621100),(621125,'漳县',621100),(621126,'岷县',621100),(621200,'陇南市',620000),(621202,'武都区',621200),(621221,'成县',621200),(621222,'文县',621200),(621223,'宕昌县',621200),(621224,'康县',621200),(621225,'西和县',621200),(621226,'礼县',621200),(621227,'徽县',621200),(621228,'两当县',621200),(622900,'临夏回族自治州',620000),(622901,'临夏市',622900),(622921,'临夏县',622900),(622922,'康乐县',622900),(622923,'永靖县',622900),(622924,'广河县',622900),(622925,'和政县',622900),(622926,'东乡族自治县',622900),(622927,'积石山保安族东乡族撒拉族自治县',622900),(623000,'甘南藏族自治州',620000),(623001,'合作市',623000),(623021,'临潭县',623000),(623022,'卓尼县',623000),(623023,'舟曲县',623000),(623024,'迭部县',623000),(623025,'玛曲县',623000),(623026,'碌曲县',623000),(623027,'夏河县',623000),(630000,'青海省',NULL),(630100,'西宁市',630000),(630102,'城东区',630100),(630103,'城中区',630100),(630104,'城西区',630100),(630105,'城北区',630100),(630121,'大通回族土族自治县',630100),(630122,'湟中县',630100),(630123,'湟源县',630100),(630200,'海东市',630000),(630202,'乐都区',630200),(630203,'平安区',630200),(630222,'民和回族土族自治县',630200),(630223,'互助土族自治县',630200),(630224,'化隆回族自治县',630200),(630225,'循化撒拉族自治县',630200),(632200,'海北藏族自治州',630000),(632221,'门源回族自治县',632200),(632222,'祁连县',632200),(632223,'海晏县',632200),(632224,'刚察县',632200),(632300,'黄南藏族自治州',630000),(632321,'同仁县',632300),(632322,'尖扎县',632300),(632323,'泽库县',632300),(632324,'河南蒙古族自治县',632300),(632500,'海南藏族自治州',630000),(632521,'共和县',632500),(632522,'同德县',632500),(632523,'贵德县',632500),(632524,'兴海县',632500),(632525,'贵南县',632500),(632600,'果洛藏族自治州',630000),(632621,'玛沁县',632600),(632622,'班玛县',632600),(632623,'甘德县',632600),(632624,'达日县',632600),(632625,'久治县',632600),(632626,'玛多县',632600),(632700,'玉树藏族自治州',630000),(632701,'玉树市',632700),(632722,'杂多县',632700),(632723,'称多县',632700),(632724,'治多县',632700),(632725,'囊谦县',632700),(632726,'曲麻莱县',632700),(632800,'海西蒙古族藏族自治州',630000),(632801,'格尔木市',632800),(632802,'德令哈市',632800),(632821,'乌兰县',632800),(632822,'都兰县',632800),(632823,'天峻县',632800),(640000,'宁夏回族自治区',NULL),(640100,'银川市',640000),(640104,'兴庆区',640100),(640105,'西夏区',640100),(640106,'金凤区',640100),(640121,'永宁县',640100),(640122,'贺兰县',640100),(640181,'灵武市',640100),(640200,'石嘴山市',640000),(640202,'大武口区',640200),(640205,'惠农区',640200),(640221,'平罗县',640200),(640300,'吴忠市',640000),(640302,'利通区',640300),(640303,'红寺堡区',640300),(640323,'盐池县',640300),(640324,'同心县',640300),(640381,'青铜峡市',640300),(640400,'固原市',640000),(640402,'原州区',640400),(640422,'西吉县',640400),(640423,'隆德县',640400),(640424,'泾源县',640400),(640425,'彭阳县',640400),(640500,'中卫市',640000),(640502,'沙坡头区',640500),(640521,'中宁县',640500),(640522,'海原县',640500),(650000,'新疆维吾尔自治区',NULL),(650100,'乌鲁木齐市',650000),(650102,'天山区',650100),(650103,'沙依巴克区',650100),(650104,'新市区',650100),(650105,'水磨沟区',650100),(650106,'头屯河区',650100),(650107,'达坂城区',650100),(650109,'米东区',650100),(650121,'乌鲁木齐县',650100),(650200,'克拉玛依市',650000),(650202,'独山子区',650200),(650203,'克拉玛依区',650200),(650204,'白碱滩区',650200),(650205,'乌尔禾区',650200),(650400,'吐鲁番市',650000),(650402,'高昌区',650400),(650421,'鄯善县',650400),(650422,'托克逊县',650400),(650500,'哈密市',650000),(650502,'伊州区',650500),(650521,'巴里坤哈萨克自治县',650500),(650522,'伊吾县',650500),(652300,'昌吉回族自治州',650000),(652301,'昌吉市',652300),(652302,'阜康市',652300),(652323,'呼图壁县',652300),(652324,'玛纳斯县',652300),(652325,'奇台县',652300),(652327,'吉木萨尔县',652300),(652328,'木垒哈萨克自治县',652300),(652700,'博尔塔拉蒙古自治州',650000),(652701,'博乐市',652700),(652702,'阿拉山口市',652700),(652722,'精河县',652700),(652723,'温泉县',652700),(652800,'巴音郭楞蒙古自治州',650000),(652801,'库尔勒市',652800),(652822,'轮台县',652800),(652823,'尉犁县',652800),(652824,'若羌县',652800),(652825,'且末县',652800),(652826,'焉耆回族自治县',652800),(652827,'和静县',652800),(652828,'和硕县',652800),(652829,'博湖县',652800),(652900,'阿克苏地区',650000),(652901,'阿克苏市',652900),(652922,'温宿县',652900),(652923,'库车县',652900),(652924,'沙雅县',652900),(652925,'新和县',652900),(652926,'拜城县',652900),(652927,'乌什县',652900),(652928,'阿瓦提县',652900),(652929,'柯坪县',652900),(653000,'克孜勒苏柯尔克孜自治州',650000),(653001,'阿图什市',653000),(653022,'阿克陶县',653000),(653023,'阿合奇县',653000),(653024,'乌恰县',653000),(653100,'喀什地区',650000),(653101,'喀什市',653100),(653121,'疏附县',653100),(653122,'疏勒县',653100),(653123,'英吉沙县',653100),(653124,'泽普县',653100),(653125,'莎车县',653100),(653126,'叶城县',653100),(653127,'麦盖提县',653100),(653128,'岳普湖县',653100),(653129,'伽师县',653100),(653130,'巴楚县',653100),(653131,'塔什库尔干塔吉克自治县',653100),(653200,'和田地区',650000),(653201,'和田市',653200),(653221,'和田县',653200),(653222,'墨玉县',653200),(653223,'皮山县',653200),(653224,'洛浦县',653200),(653225,'策勒县',653200),(653226,'于田县',653200),(653227,'民丰县',653200),(654000,'伊犁哈萨克自治州',650000),(654002,'伊宁市',654000),(654003,'奎屯市',654000),(654004,'霍尔果斯市',654000),(654021,'伊宁县',654000),(654022,'察布查尔锡伯自治县',654000),(654023,'霍城县',654000),(654024,'巩留县',654000),(654025,'新源县',654000),(654026,'昭苏县',654000),(654027,'特克斯县',654000),(654028,'尼勒克县',654000),(654200,'塔城地区',650000),(654201,'塔城市',654200),(654202,'乌苏市',654200),(654221,'额敏县',654200),(654223,'沙湾县',654200),(654224,'托里县',654200),(654225,'裕民县',654200),(654226,'和布克赛尔蒙古自治县',654200),(654300,'阿勒泰地区',650000),(654301,'阿勒泰市',654300),(654321,'布尔津县',654300),(654322,'富蕴县',654300),(654323,'福海县',654300),(654324,'哈巴河县',654300),(654325,'青河县',654300),(654326,'吉木乃县',654300),(659000,'自治区直辖县级行政区划',650000),(659001,'石河子市',659000),(659002,'阿拉尔市',659000),(659003,'图木舒克市',659000),(659004,'五家渠市',659000),(659006,'铁门关市',659000),(710000,'台湾省',NULL),(810000,'香港特别行政区',NULL),(820000,'澳门特别行政区',NULL);/*!40000 ALTER TABLE `tb_areas` ENABLE KEYS */;UNLOCK TABLES;/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;-- Dump completed on 2020-07-24 21:45:53
from django.views import Viewfrom django.http import JsonResponsefrom .models import Areafrom django.core.cache import cache# 获取可选省份信息class ProvinceAreasView(View):def get(self, request):# 优先判断缓存中有没有数据p_list = cache.get('province_list')if not p_list:# 把省信息按照格式返回# 1、读取模型类查询集provinces = Area.objects.filter(parent=None)# 2、把所有的模型类对象，转化成字典{id, name}，json不认模型对象p_list = []for province in provinces:# province: 是省模型类对象p_list.append({'id': province.id,'name': province.name})# 读取mysql省数据之后，写入缓存# cache模块写入缓存是key-value形式cache.set('province_list', p_list, 3600)# 3、构建响应返回return JsonResponse({'code': 0,'errmsg': 'ok','province_list': p_list})# 获取可选市区信息class SubAreasView(View):def get(self, request, pk):# 路径中传入的pk# 1、pk是省的主键，请求所有市信息# 2、pk是市的主键，请求所有区信息sub_data = cache.get('sub_area_%s'%pk)if not sub_data:# 当前pk过滤出的父级行政区对象p_area = Area.objects.get(pk=pk)# 当前父级行政区对象关联的多个子级行政区subs = Area.objects.filter(parent_id=pk)sub_list = []for sub in subs:# sub是子级行政区对象sub_list.append({'id': sub.id,'name': sub.name})sub_data = {'id': p_area.id,'name': p_area.name,'subs': sub_list}cache.set('sub_area_%s'%pk, sub_data, 3600)return JsonResponse({'code': 0,'errmsg': 'ok','sub_data': sub_data})
from django.urls import re_pathfrom . import viewsurlpatterns = [re_path(r'^areas/$', views.ProvinceAreasView.as_view()),re_path(r'^areas/(?P<pk>[1-9]\d+)/$', views.SubAreasView.as_view()),]
修改11、214、252行limit: '10',location.href = 'http://82.156.189.83:8080/user_center_site.html'location.href = 'http://82.156.189.83:8080/user_center_site.html'
from shop.utils.BaseModel import BaseModelclass Address(BaseModel):"""用户地址"""user = models.ForeignKey(User,on_delete=models.CASCADE,related_name='addresses',verbose_name='用户')province = models.ForeignKey('areas.Area',on_delete=models.PROTECT,related_name='province_addresses',verbose_name='省')city = models.ForeignKey('areas.Area',on_delete=models.PROTECT,related_name='city_addresses',verbose_name='市')district = models.ForeignKey('areas.Area',on_delete=models.PROTECT,related_name='district_addresses',verbose_name='区')title = models.CharField(max_length=20, verbose_name='地址名称')receiver = models.CharField(max_length=20, verbose_name='收货人')place = models.CharField(max_length=50, verbose_name='地址')mobile = models.CharField(max_length=11, verbose_name='手机')tel = models.CharField(max_length=20,null=True,blank=True,default='',verbose_name='固定电话')email = models.CharField(max_length=30,null=True,blank=True,default='',verbose_name='电子邮箱')is_deleted = models.BooleanField(default=False, verbose_name='逻辑删除')class Meta:db_table = 'tb_addresses'verbose_name = '用户地址'verbose_name_plural = verbose_name# 定义默认查询集排序方式ordering = ['-update_time']
mobile = models.CharField(unique=True,verbose_name='手机号',null=True,max_length=11)# 新增 email_active 字段# 用于记录邮箱是否激活, 默认为 False: 未激活email_active = models.BooleanField(default=False,verbose_name='邮箱验证状态')# 外间关联字段，表示当前用户，采用的默认的收货地址是哪个default_address = models.ForeignKey('Address',related_name='users',null=True,blank=True,on_delete=models.SET_NULL,verbose_name='默认地址')
from .models import Addressclass CreateAddressView(View):def post(self, request):# 1、提取参数data = json.loads(request.body.decode())receiver = data.get('receiver')province_id = data.get('province_id')city_id = data.get('city_id')district_id = data.get('district_id')place = data.get('place') # 详细地址mobile = data.get('mobile')tel = data.get('tel')email = data.get('email')# 判断用户地址数量是否超过10个user = request.usercount = Address.objects.filter(user=user).count()if count >= 10:return JsonResponse({'code': 400, 'errmsg': '数量超限'})# 2、校验参数if not all([receiver, province_id, city_id, district_id, place, mobile]):return JsonResponse({"code": 400, 'errmsg': '缺少参数！'})if not re.match(r'^1[3-9]\d{9}$', mobile):return JsonResponse({'code': 400,'errmsg': '参数mobile有误'})if tel:if not re.match(r'^(0[0-9]{2,3}-)?([2-9][0-9]{6,7})+(-[0-9]{1,4})?$', tel):return JsonResponse({'code': 400,'errmsg': '参数tel有误'})if email:if not re.match(r'^[a-z0-9][\w\.\-]*@[a-z0-9\-]+(\.[a-z]{2,5}){1,2}$', email):return JsonResponse({'code': 400,'errmsg': '参数email有误'})# 3、新建用户地址try:address = Address.objects.create(user=user,province_id=province_id,city_id=city_id,district_id=district_id,title=receiver, # 当前地址的标题，默认收货人名称就作为地址标题receiver=receiver,place=place,mobile=mobile,tel=tel)# 如果当前新增地址的时候，用户没有设置默认地址，那么# 我们把当前新增的地址设置为用户的默认地址if not user.default_address:user.default_address = addressuser.save()except Exception as e:print(e)return JsonResponse({'code': 400, 'errmsg': '新增地址失败！'})address_info = {"id": address.id,"title": address.title,"receiver": address.receiver,"province": address.province.name,"city": address.city.name,"district": address.district.name,"place": address.place,"mobile": address.mobile,"tel": address.tel,"email": address.email}# 4、返回响应return JsonResponse({'code': 0,'errmsg': 'ok','address': address_info})
re_path(r'^addresses/create/$', CreateAddressView.as_view()),
class AddressView(View):def get(self, request):# 1、根据用户，过滤出当前用户的所有地址user = request.useraddresses = Address.objects.filter(user=user,is_deleted=False # 没有逻辑删除的地址)# 2、把地址转化成字典address_list = []for address in addresses:if address.id != user.default_address_id:# address：每一个地址对象address_list.append({'id': address.id,'title': address.title,'receiver': address.receiver,'province': address.province.name,'city': address.city.name,'district': address.district.name,'place': address.place,'mobile': address.mobile,'tel': address.tel,'email': address.email})else:address_list.insert(0, {'id': address.id,'title': address.title,'receiver': address.receiver,'province': address.province.name,'city': address.city.name,'district': address.district.name,'place': address.place,'mobile': address.mobile,'tel': address.tel,'email': address.email})# 3、构建响应返回return JsonResponse({'code': 0,'errmsg': 'ok','default_address_id': user.default_address_id,'addresses': address_list})
re_path(r'^addresses/$', AddressView.as_view()),
class UpdateDestroyAddressView(View):# 删除地址def delete(self, request, address_id):# 1、根据路径中的地址主键，获取地址对象try:address = Address.objects.get(pk=address_id)except Address.DoesNotExist as e:print(e)return JsonResponse({'code': 400, 'errmsg': '地址不存在'}, status=404)# 2、通过对象删除(真删除，逻辑删除)# 真删除: address.delete()# 逻辑删除address.is_deleted = Trueaddress.save()# 3、构建响应return JsonResponse({'code': 0,'errmsg': 'ok'})# 更新地址接口def put(self, request, address_id):# 1、获取被更新的地址try:address = Address.objects.get(pk=address_id)except Address.DoesNotExist as e:print(e)return JsonResponse({'code': 400, 'errmsg': '资源未找到！'})# 2、提取参数data = json.loads(request.body.decode())receiver = data.get('receiver')province_id = data.get('province_id')city_id = data.get('city_id')district_id = data.get('district_id')place = data.get('place') # 详细地址mobile = data.get('mobile')tel = data.get('tel')email = data.get('email')# 3、校验参数if not all([receiver, province_id, city_id, district_id, place, mobile]):return JsonResponse({"code": 400, 'errmsg': '缺少参数！'})if not re.match(r'^1[3-9]\d{9}$', mobile):return JsonResponse({'code': 400,'errmsg': '参数mobile有误'})if tel:if not re.match(r'^(0[0-9]{2,3}-)?([2-9][0-9]{6,7})+(-[0-9]{1,4})?$', tel):return JsonResponse({'code': 400,'errmsg': '参数tel有误'})if email:if not re.match(r'^[a-z0-9][\w\.\-]*@[a-z0-9\-]+(\.[a-z]{2,5}){1,2}$', email):return JsonResponse({'code': 400,'errmsg': '参数email有误'})# 构造数据存储address.receiver = receiveraddress.province_id = province_idaddress.city_id = city_idaddress.district_id = district_idaddress.place = placeaddress.mobile = mobileaddress.tel = teladdress.email = emailaddress.save()# 构造返回前端数据address_info = {"id": address.id,"title": address.title,"receiver": address.receiver,"province": address.province.name,"city": address.city.name,"district": address.district.name,"place": address.place,"mobile": address.mobile,"tel": address.tel,"email": address.email}return JsonResponse({'code': 0,'errmsg': 'ok','address': address_info})
re_path(r'^addresses/(?P<address_id>\d+)/$', UpdateDestroyAddressView.as_view()),
class DefaultAddressView(View):def put(self, request, address_id):# 修改当前登陆用户对象的default_address指向address_id的地址user = request.user# default_address是ForeignKey类型，是Address对象# user.default_address = <Address对象># user.default_address = Address.objects.get(pk=address_id)# user.default_address_id = <Address对象的主键>user.default_address_id = address_iduser.save()return JsonResponse({'code': 0,'errmsg': 'ok'})
re_path(r'^addresses/(?P<address_id>\d+)/default/$', DefaultAddressView.as_view()),
class UpdateTitleAddressView(View):def put(self, request, address_id):# 1、获取更新数据data = json.loads(request.body.decode())title = data.get('title')# 2、获取被修改的地址对象address = Address.objects.get(pk=address_id)# 3、修改并返回响应address.title = titleaddress.save()return JsonResponse({'code': 0, 'errmsg': 'ok'})
re_path(r'^addresses/(?P<address_id>\d+)/title/$', UpdateTitleAddressView.as_view()),
class ChangePasswordView(View):def put(self, request):# 1、提取参数data = json.loads(request.body.decode())old_password = data.get('old_password')new_password = data.get('new_password')new_password2 = data.get('new_password2')# 2、校验参数if not all([old_password, new_password, new_password2]):return JsonResponse({'code':400, 'errmsg': '参数缺失'})# 新密码格式校验if not re.match(r'^[0-9A-Za-z]{8,20}$', new_password):return JsonResponse({'code': 400,'errmsg': '密码最少8位,最长20位'})# 两次输入是否一致校验if new_password != new_password2:return JsonResponse({'code': 400,'errmsg': '两次输入密码不一致'})# 旧密码校验# User.set_password()# User.check_password()user = request.userif not user.check_password(old_password):return JsonResponse({'code': 400, 'errmsg': '旧密码有误！'}, status=400)# 3、更新数据user.set_password(new_password)user.save()# 补充逻辑：清楚登陆状态logout(request)# 4、返回响应response = JsonResponse({'code': 0, 'errmsg': 'ok'})response.delete_cookie('username')return response
re_path(r'^password/$', ChangePasswordView.as_view()),
若有收获，就点个赞吧
0 人点赞
