全国省市区县乡镇数据库

/* SQLyog Enterprise - MySQL GUI v6.03 Host - 5.1.54-community : Database - awebprice ********************************************************************* Server version : 5.1.54-community */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; create database if not exists `awebprice`; USE `awebprice`; /*!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' */; /*Data for the table `aweb_price_area` */ insert into `aweb_price_area`(`id`,`area_name`,`parent_id`,`area_rangeid`,`level`,`pinyin`) values (1,'上海',100000,1,1,'sh,shanghai'),(2,'上海',1,NULL,2,'sh,shanghai'),(3,'长宁区',2,NULL,3,'znq,zhangningqu'),(10,'新泾镇',3,NULL,4,'xjz,xinjingzhen'),(14,'闵行区',2,NULL,3,'mxq,minxingqu'),(15,'七宝镇',14,NULL,4,'qbz,qibaozhe'),(16,'华漕镇',14,NULL,4,'hcz,huacaozhe'),(18,'吴泾镇',14,NULL,4,'wjz,wujingzhe'),(19,'梅陇镇',14,NULL,4,'mlz,meilongzhe'),(21,'浦江镇',14,NULL,4,'pjz,pujiangzhe'),(22,'莘庄镇',14,NULL,4,'xzz,xinzhuangzhe'),(23,'虹桥镇',14,NULL,4,'hqz,hongqiaozhe'),(24,'颛桥镇',14,NULL,4,'zqz,zhuanqiaozhe'),(25,'马桥镇',14,NULL,4,'mqz,maqiaozhe'),(27,'宝山区(上海市)',2,NULL,3,'bsq,baoshanqu'),(30,'大场镇',27,NULL,4,'dcz,dachangzhe'),(31,'庙行镇',27,NULL,4,'mxz,miaoxingzhe'),(33,'月浦镇',27,NULL,4,'ypz,yuepuzhe'),(34,'杨行镇',27,NULL,4,'yxz,yangxingzhe'),(35,'淞南镇',27,NULL,4,'snz,songnanzhe'),(36,'罗店镇',27,NULL,4,'ldz,luodianzhe'),(37,'罗泾镇',27,NULL,4,'ljz,luojingzhe'),(38,'顾村镇',27,NULL,4,'gcz,gucunzhe'),(39,'高境镇',27,NULL,4,'gjz,gaojingzhe'),(40,'黄浦区',2,NULL,3,'hpq,huangpuqu'),(47,'徐汇区',2,NULL,3,'xhq,xuhuiqu'),(49,'华泾镇',47,NULL,4,'hjz,huajingzhe'),(61,'浦东新区',2,NULL,3,'pdxq,pudongxinqu'),(62,'三林镇',61,NULL,4,'slz,sanlinzhe'),(65,'北蔡镇',61,NULL,4,'bcz,beicaizhe'),(67,'合庆镇',61,NULL,4,'hqz,heqingzhe'),(68,'唐镇',61,NULL,4,'tz,tangzhe'),(69,'川沙新镇',61,NULL,4,'csxz,chuanshaxinzhe'),(70,'张江镇',61,NULL,4,'zjz,zhangjiangzhe'),(71,'曹路镇',61,NULL,4,'clz,caoluzhe'),(81,'金桥镇',61,NULL,4,'jqz,jinqiaozhe'),(82,'高东镇',61,NULL,4,'gdz,gaodongzhe'),(83,'高桥镇',61,NULL,4,'gqz,gaoqiaozhe'),(84,'高行镇',61,NULL,4,'gxz,gaoxingzhe'),(85,'闸北区',2,NULL,3,'zbq,zhabeiqu'),(93,'彭浦镇',85,NULL,4,'ppz,pengpuzhe'),(95,'普陀区(上海市)',2,NULL,3,'ptq,putuoqu'),(98,'桃浦镇',95,NULL,4,'tpz,taopuzhe'),(100,'真如镇',95,NULL,4,'zrz,zhenruzhe'),(103,'长征镇',95,NULL,4,'zzz,zhangzhengzhe'),(105,'南汇区',2,NULL,3,'nhq,nanhuiqu'),(106,'惠南镇',105,NULL,4,'hnz,huinanzhe'),(107,'新场镇',105,NULL,4,'xcz,xinchangzhe'),(108,'大团镇',105,NULL,4,'dtz,datuanzhe'),(109,'周浦镇',105,NULL,4,'zpz,zhoupuzhe'),(110,'航头镇',105,NULL,4,'htz,hangtouzhe'),(111,'芦潮港镇',105,NULL,4,'lcgz,luchaogangzhe'),(112,'康桥镇',105,NULL,4,'kqz,kangqiaozhe'),(113,'宣桥镇',105,NULL,4,'xqz,xuanqiaozhe'),(114,'六灶镇',105,NULL,4,'lzz,liuzaozhe'),(115,'祝桥镇',105,NULL,4,'zqz,zhuqiaozhe'),(116,'泥城镇',105,NULL,4,'ncz,nichengzhe'),(117,'书院镇',105,NULL,4,'syz,shuyuanzhe'),(118,'万祥镇',105,NULL,4,'wxz,wanxiangzhe'),(119,'老港镇',105,NULL,4,'lgz,laogangzhe'),(120,'嘉定区',2,NULL,3,'jdq,jiadingqu'),(121,'华亭镇',120,NULL,4,'htz,huatingzhe'),(122,'南翔镇',120,NULL,4,'nxz,nanxiangzhe'),(125,'外冈镇',120,NULL,4,'wgz,waigangzhe'),(126,'安亭镇',120,NULL,4,'atz,antingzhe'),(127,'徐行镇',120,NULL,4,'xxz,xuxingzhe'),(129,'江桥镇',120,NULL,4,'jqz,jiangqiaozhe'),(132,'马陆镇',120,NULL,4,'mlz,maluzhe'),(133,'黄渡镇',120,NULL,4,'hdz,huangduzhe'),(134,'崇明县',2,NULL,3,'cmx,chongmingxia'),(135,'三星镇',134,NULL,4,'sxz,sanxingzhe'),(136,'中兴镇',134,NULL,4,'zxz,zhongxingzhe'),(137,'向化镇',134,NULL,4,'xhz,xianghuazhe'),(138,'城桥镇',134,NULL,4,'cqz,chengqiaozhe'),(139,'堡镇',134,NULL,4,'bz,baozhe'),(140,'庙镇',134,NULL,4,'mz,miaozhe'),(141,'建设镇',134,NULL,4,'jsz,jianshezhe'),(142,'新村乡',134,NULL,4,'xcx,xincunxiang'),(143,'新河镇',134,NULL,4,'xhz,xinhezhe'),(144,'横沙乡',134,NULL,4,'hsx,hengshaxiang'),(145,'港沿镇',134,NULL,4,'gyz,gangyanzhe'),(146,'港西镇',134,NULL,4,'gxz,gangxizhe'),(147,'竖新镇',134,NULL,4,'sxz,shuxinzhe'),(148,'绿华镇',134,NULL,4,'lhz,lu:huazhe'),(149,'长兴乡',134,NULL,4,'zxx,zhangxingxiang'),(150,'陈家镇',134,NULL,4,'cjz,chenjiazhe'),(151,'松江区',2,NULL,3,'sjq,songjiangqu'),(154,'九亭镇',151,NULL,4,'jtz,jiutingzhe'),(157,'佘山镇',151,NULL,4,'ssz,sheshanzhe'),(158,'叶榭镇',151,NULL,4,'yxz,yexiezhe'),(160,'新桥镇',151,NULL,4,'xqz,xinqiaozhe'),(161,'新浜镇',151,NULL,4,'xbz,xinbangzhe'),(165,'泖港镇',151,NULL,4,'mgz,maogangzhe'),(166,'泗泾镇',151,NULL,4,'sjz,sijingzhe'),(167,'洞泾镇',151,NULL,4,'djz,dongjingzhe'),(168,'石湖荡镇',151,NULL,4,'shdz,shihudangzhe'),(169,'车墩镇',151,NULL,4,'cdz,chedunzhe'),(170,'金山区',2,NULL,3,'jsq,jinshanqu'),(171,'亭林镇',170,NULL,4,'tlz,tinglinzhe'),(172,'吕巷镇',170,NULL,4,'lxz,lu:xiangzhe'),(173,'山阳镇',170,NULL,4,'syz,shanyangzhe'),(174,'廊下镇',170,NULL,4,'lxz,langxiazhe'),(175,'张堰镇',170,NULL,4,'zyz,zhangyanzhe'),(176,'朱泾镇',170,NULL,4,'zjz,zhujingzhe'),(177,'枫泾镇',170,NULL,4,'fjz,fengjingzhe'),(178,'漕泾镇',170,NULL,4,'cjz,caojingzhe'),(180,'金山卫镇',170,NULL,4,'jswz,jinshanweizhe'),(181,'卢湾区',2,NULL,3,'lwq,luwanqu'),(186,'虹口区',2,NULL,3,'hkq,hongkouqu'),(197,'青浦区',2,NULL,3,'qpq,qingpuqu'),(198,'华新镇',197,NULL,4,'hxz,huaxinzhe'),(200,'徐泾镇',197,NULL,4,'xjz,xujingzhe'),(201,'朱家角镇',197,NULL,4,'zjjz,zhujiajiaozhe'),(202,'白鹤镇',197,NULL,4,'bhz,baihezhe'),(204,'练塘镇',197,NULL,4,'ltz,liantangzhe'),(205,'赵巷镇',197,NULL,4,'zxz,zhaoxiangzhe'),(206,'重固镇',197,NULL,4,'zgz,zhongguzhe'),(207,'金泽镇',197,NULL,4,'jzz,jinzezhe'),(209,'静安区',2,NULL,3,'jaq,jinganqu'),(215,'杨浦区',2,NULL,3,'ypq,yangpuqu'),(217,'五角场镇',215,NULL,4,'wjcz,wujiaochangzhe'),(228,'奉贤区',2,NULL,3,'fxq,fengxianqu'),(229,'南桥镇',228,NULL,4,'nqz,nanqiaozhe'),(230,'四团镇',228,NULL,4,'stz,situanzhe'),(231,'奉城镇',228,NULL,4,'fcz,fengchengzhe'),(232,'庄行镇',228,NULL,4,'zxz,zhuangxingzhe'),(233,'柘林镇',228,NULL,4,'zlz,zhelinzhe'),(234,'海湾镇',228,NULL,4,'hwz,haiwanzhe'),(235,'金汇镇',228,NULL,4,'jhz,jinhuizhe'),(236,'青村镇',228,NULL,4,'qcz,qingcunzhe'),(237,'云南',100000,6,1,'yn,yunnan'),(238,'临沧',237,NULL,2,'lc,lincang'),(239,'云县',238,NULL,3,'yx,yunxian'),(240,'爱华镇',239,NULL,4,'ahz,aihuazhe'),(241,'漫湾镇',239,NULL,4,'mwz,manwanzhe'),(242,'大朝山西镇',239,NULL,4,'dcsxz,dachaoshanxizhe'),(243,'涌宝镇',239,NULL,4,'ybz,yongbaozhe'),(244,'茂兰镇',239,NULL,4,'mlz,maolanzhe'),(245,'幸福镇',239,NULL,4,'xfz,xingfuzhe'),(246,'大寨镇',239,NULL,4,'dzz,dazhaizhe'),(247,'忙怀彝族布朗族乡',239,NULL,4,'mhyzblzx,manghuaiyizubulangzuxiang'),(248,'晓街乡',239,NULL,4,'xjx,xiaojiexiang'),(249,'茶房乡',239,NULL,4,'cfx,chafangxiang'),(250,'栗树彝族傣族乡',239,NULL,4,'lsyzdzx,lishuyizudaizuxiang'),(251,'后箐彝族乡',239,NULL,4,'hqyzx,houqingyizuxiang'),(252,'临翔区',238,NULL,3,'lxq,linxiangqu'),(255,'博尚镇',252,NULL,4,'bsz,boshangzhe'),(256,'南美拉祜族乡',252,NULL,4,'nmlhzx,nanmeilahuzuxiang'),(257,'蚂蚁堆乡',252,NULL,4,'mydx,mayiduixiang'),(258,'章驮乡',252,NULL,4,'ztx,zhangtuoxiang'),(259,'圈内乡',252,NULL,4,'qnx,quanneixiang'),(260,'马台乡',252,NULL,4,'mtx,mataixiang'),(261,'邦东乡',252,NULL,4,'bdx,bangdongxiang'),(262,'平村彝族傣族乡',252,NULL,4,'pcyzdzx,pingcunyizudaizuxiang'),(263,'双江拉祜族佤族布朗族傣族自治县',238,NULL,3,'sjlhzwzblzdzzzx,shuangjianglahuzuwazubulangzudaizuzizhixia'),(264,'勐勐镇',263,NULL,4,'mmz,mengmengzhe'),(265,'勐库镇',263,NULL,4,'mkz,mengkuzhe'),(266,'沙河乡',263,NULL,4,'shx,shahexia