全国省市数据 sql语句+json格式数据

省级行政区、地级市数据,不含县级行政区

一、sql语句

一共两张表,一个省份province表、一个地级市city表(pid字段为外键)
部分数据截图:
在这里插入图片描述
在这里插入图片描述

sql语句(包含建表语句、insert语句):

CREATE TABLE `province` (
  `pid` int(11) NOT NULL default '0',
  `province` varchar(50) default NULL,
  PRIMARY KEY  (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


insert  into `province`(`pid`,`province`) values (1,'北京市'),(2,'天津市'),(3,'上海市'),(4,'重庆市'),(5,'河北省'),(6,'山西省'),(7,'台湾省'),(8,'辽宁省'),(9,'吉林省'),(10,'黑龙江省'),(11,'江苏省'),(12,'浙江省'),(13,'安徽省'),(14,'福建省'),(15,'江西省'),(16,'山东省'),(17,'河南省'),(18,'湖北省'),(19,'湖南省'),(20,'广东省'),(21,'甘肃省'),(22,'四川省'),(23,'贵州省'),(24,'海南省'),(25,'云南省'),(26,'青海省'),(27,'陕西省'),(28,'广西壮族自治区'),(29,'西藏自治区'),(30,'宁夏回族自治区'),(31,'新疆维吾尔自治区'),(32,'内蒙古自治区'),(33,'澳门特别行政区'),(34,'香港特别行政区');


CREATE TABLE `city` (
  `cid` int(11) NOT NULL auto_increment,
  `city` varchar(50) NOT NULL,
  `pid` int(11) default NULL,
  PRIMARY KEY  (`cid`),
  KEY `FKjay3jcl43wv9syyki45snd6dx` (`pid`),
  CONSTRAINT `FKjay3jcl43wv9syyki45snd6dx` FOREIGN KEY (`pid`) REFERENCES `province` (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


insert  into `city`(`cid`,`city`,`pid`) values (1,'七台河市',10),(2,'万宁市',24),(3,'三亚市',24),(4,'三明市',14),(5,'三门峡市',17),(6,'上海市',3),(7,'上饶市',15),(8,'东方市',24),(9,'东莞市',20),(10,'东营市',16),(11,'中卫市',30),(12,'中山市',20),(13,'临夏回族自治州',21),(14,'临汾市',6),(15,'临沂市',16),(16,'临沧市',25),(17,'临高县',24),(18,'丹东市',8),(19,'丽水市',12),(20,'丽江市',25),(21,'乌兰察布市',32),(22,'乌海市',32),(23,'乌苏市',31),(24,'乌鲁木齐市',31),(25,'乐东黎族自治县',24),(26,'乐山市',22),(27,'九江市',15),(28,'云林县',7),(29,'云浮市',20),(30,'五家渠市',31),(31,'五指山市',24),(32,'亳州市',13),(33,'仙桃市',18),(34,'伊春市',10),(35,'伊宁市',31),(36,'佛山市',20),(37,'佳木斯市',10),(38,'保亭黎族苗族自治县',24),(39,'保定市',5),(40,'保山市',25),(41,'信阳市',17),(42,'儋州市',24),(43,'克拉玛依市',31),(44,'六安市',13),(45,'六盘水市',23),(46,'兰州市',21),(47,'兴安盟',32),(48,'内江市',22),(49,'凉山彝族自治州',22),(50,'包头市',32),(51,'北京市',1),(52,'北海市',28),(53,'十堰市',18),(54,'南京市',11),(55,'南充市',22),(56,'南宁市',28),(57,'南平市',14),(58,'南投县',7),(59,'南昌市',15),(60,'南通市',11),(61,'南阳市',17),(62,'博乐市',31),(63,'厦门市',14),(64,'双鸭山市',10),(65,'台东县',7),(66,'台中县',7),(67,'台中市',7),(68,'台北县',7),(69,'台北市',7),(70,'台南县',7),(71,'台南市',7),(72,'台州市',12),(73,'合肥市',13),(74,'吉安市',15),(75,'吉林市',9),(76,'吐鲁番市',31),(77,'吕梁市',6),(78,'吴忠市',30),(79,'周口市',17),(80,'呼伦贝尔市',32),(81,'呼和浩特市',32),(82,'和田市',31),(83,'咸宁市',18),(84,'咸阳市',27),(85,'哈密市',31),(86,'哈尔滨市',10),(87,'唐山市',5),(88,'商丘市',17),(89,'商洛市',27),(90,'喀什市',31),(91,'嘉义县',7),(92,'嘉义市',7),(93,'嘉兴市',12),(94,'嘉峪关市',21),(95,'四平市',9),(96,'固原市',30),(97,'图木舒克市',31),(98,'基隆市',7),(99,'塔城市',31),(100,'大庆市',10),(101,'大兴安岭地区',10),(102,'大同市',6),(103,'大理白族自治州',25),(104,'大连市',8),(105,'天水市',21),(106,'天津市',2),(107,'天门市',18),(108,'太原市',6),(109,'奎屯市',31),(110,'威海市',16),(111,'娄底市',19),(112,'孝感市',18),(113,'宁德市',14),(114,'宁波市',12),(115,'安庆市',13),(116,'安康市',27),(117,'安阳市',17),(118,'安顺市',23),(119,'定安县',24),(120,'定西市',21),(121,'宜兰县',7),(122,'宜宾市',22),(123,'宜昌市',18),(124,'宜春市',15),(125,'宝鸡市',27),(126,'宣城市',13),(127,'宿州市',13),(128,'宿迁市',11),(129,'屏东县',7),(130,'屯昌县',24),(131,'山南地区',29),(132,'岳阳市',19),(133,'崇左市',28),(134,'巢湖市',13),(135,'巴中市',22),(136,'巴彦淖尔市',32),(137,'常州市',11),(138,'常德市',19),(139,'平凉市',21),(140,'平顶山市',17),(141,'广元市',22),(142,'广安市',22),(143,'广州市',20),(144,'庆阳市',21),(145,'库尔勒市',31),(146,'廊坊市',5),(147,'延安市',27),(148,'延边朝鲜族自治州',9),(149,'开封市',17),(150,'张家口市',5),(151,'张家界市',19),(152,'张掖市',21),(153,'彰化县',7),(154,'徐州市',11),(155,'德宏傣族景颇族自治州',25),(156,'德州市',16),(157,'德阳市',22),(158,'忻州市',6),(159,'怀化市',19),(160,'怒江傈傈族自治州',25),(161,'思茅市',25),(162,'恩施土家族苗族自治州',18),(163,'惠州市',20),(164,'成都市',22),(165,'扬州市',11),(166,'承德市',5),(167,'抚州市',15),(168,'抚顺市',8),(169,'拉萨市',29),(170,'揭阳市',20),(171,'攀枝花市',22),(172,'文山壮族苗族自治州',25),(173,'文昌市',24),(174,'新乡市',17),(175,'新余市',15),(176,'新竹县',7),(177,'新竹市',7),(178,'无锡市',11),(179,'日喀则地区',29),(180,'日照市',16),(181,'昆明市',25),(182,'昌吉市 ',31),(183,'昌江黎族自治县',24),(184,'昌都地区',29),(185,'昭通市',25),(186,'晋中市',6),(187,'晋城市',6),(188,'景德镇市',15),(189,'曲靖市',25),(190,'朔州市',6),(191,'朝阳市',8),(192,'本溪市',8),(193,'来宾市',28),(194,'杭州市',12),(195,'松原市',9),(196,'林芝地区',29),(197,'果洛藏族自治州',26),(198,'枣庄市',16),(199,'柳州市',28),(200,'株洲市',19),(201,'桂林市',28),(202,'桃园县',7),(203,'梅州市',20),(204,'梧州市',28),(205,'楚雄彝族自治州',25),(206,'榆林市',27),(207,'武威市',21),(208,'武汉市',18),(209,'毕节地区',23),(210,'永州市',19),(211,'汉中市',27),(212,'汕头市',20),(213,'汕尾市',20),(214,'江门市',20),(215,'池州市',13),(216,'沈阳市',8),(217,'沧州市',5),(218,'河池市',28),(219,'河源市',20),(220,'泉州市',14),(221,'泰安市',16),(222,'泰州市',11),(223,'泸州市',22),(224,'洛阳市',17),(225,'济南市',16),(226,'济宁市',16),(227,'济源市',17),(228,'海东地区',26),(229,'海北藏族自治州',26),(230,'海南藏族自治州',26),(231,'海口市',24),(232,'海西蒙古族藏族自治州',26),(233,'淄博市',16),(234,'淮北市',13),(235,'淮南市',13),(236,'淮安市',11),(237,'深圳市',20),(238,'清远市',20),(239,'温州市',12),(240,'渭南市',27),(241,'湖州市',12),(242,'湘潭市',19),(243,'湘西土家族苗族自治州',19),(244,'湛江市',20),(245,'滁州市',13),(246,'滨州市',16),(247,'漯河市',17),(248,'漳州市',14),(249,'潍坊市',16),(250,'潜江市',18),(251,'潮州市',20),(252,'澄迈县',24),(253,'澎湖县',7),(254,'澳门特别行政区',33),(255,'濮阳市',17),(256,'烟台市',16),(257,'焦作市',17),(258,'牡丹江市',10),(259,'玉林市',28),(260,'玉树藏族自治州',26),(261,'玉溪市',25),(262,'珠海市',20),(263,'琼中黎族苗族自治县',24),(264,'琼海市',24),(265,'甘南藏族自治州',21),(266,'甘孜藏族自治州',22),(267,'白城市',9),(268,'白山市',9),(269,'白沙黎族自治县',24),(270,'白银市',21),(271,'百色市',28),(272,'益阳市',19),(273,'盐城市',11),(274,'盘锦市',8),(275,'眉山市',22),(276,'石嘴山市',30),(277,'石家庄市',5),(278,'石河子市 ',31),(279,'神农架林区',18),(280,'福州市',14),(281,'秦皇岛市',5),(282,'米泉市',31),(283,'红河哈尼族彝族自治州',25),(284,'绍兴市',12),(285,'绥化市',10),(286,'绵阳市',22),(287,'聊城市',16),(288,'肇庆市',20),(289,'自贡市',22),(290,'舟山市',12),(291,'芜湖市',13),(292,'花莲县',7),(293,'苏州市',11),(294,'苗栗县',7),(295,'茂名市',20),(296,'荆州市',18),(297,'荆门市',18),(298,'莆田市',14),(299,'莱芜市',16),(300,'菏泽市',16),(301,'萍乡市',15),(302,'营口市',8),(303,'葫芦岛市',8),(304,'蚌埠市',13),(305,'衡水市',5),(306,'衡阳市',19),(307,'衢州市',12),(308,'襄樊市',18),(309,'西双版纳傣族自治州',25),(310,'西宁市',26),(311,'西安市',27),(312,'许昌市',17),(313,'贵港市',28),(314,'贵阳市',23),(315,'贺州市',28),(316,'资阳市',22),(317,'赣州市',15),(318,'赤峰市',32),(319,'辽源市',9),(320,'辽阳市',8),(321,'达州市',22),(322,'运城市',6),(323,'连云港市',11),(324,'迪庆藏族自治州',25),(325,'通化市',9),(326,'通辽市',32),(327,'遂宁市',22),(328,'遵义市',23),(329,'邢台市',5),(330,'那曲地区',29),(331,'邯郸市',5),(332,'邵阳市',19),(333,'郑州市',17),(334,'郴州市',19),(335,'鄂尔多斯市',32),(336,'鄂州市',18),(337,'酒泉市',21),(338,'重庆市',4),(339,'金华市',12),(340,'金昌市',21),(341,'钦州市',28),(342,'铁岭市',8),(343,'铜仁地区',23),(344,'铜川市',27),(345,'铜陵市',13),(346,'银川市',30),(347,'锡林郭勒盟',32),(348,'锦州市',8),(349,'镇江市',11),(350,'长春市',9),(351,'长沙市',19),(352,'长治市',6),(353,'阜康市',31),(354,'阜新市',8),(355,'阜阳市',13),(356,'防城港市',28),(357,'阳江市',20),(358,'阳泉市',6),(359,'阿克苏市',31),(360,'阿勒泰市',31),(361,'阿图什市',31),(362,'阿坝藏族羌族自治州',22),(363,'阿拉善盟',32),(364,'阿拉尔市',31),(365,'阿里地区',29),(366,'陇南市',21),(367,'陵水黎族自治县',24),(368,'随州市',18),(369,'雅安市',22),(370,'青岛市',16),(371,'鞍山市',8),(372,'韶关市',20),(373,'香港特别行政区',34),(374,'马鞍山市',13),(375,'驻马店市',17),(376,'高雄县',7),(377,'高雄市',7),(378,'鸡西市',10),(379,'鹤岗市',10),(380,'鹤壁市',17),(381,'鹰潭市',15),(382,'黄冈市',18),(383,'黄南藏族自治州',26),(384,'黄山市',13),(385,'黄石市',18),(386,'黑河市',10),(387,'黔东南苗族侗族自治州',23),(388,'黔南布依族苗族自治州',23),(389,'黔西南布依族苗族自治州',23),(390,'齐齐哈尔市',10),(391,'龙岩市',14);


二、json数据

[
        {
            "pid": 1,
            "province": "北京市",
            "citySet": [
                {
                    "cid": "51",
                    "city": "北京市"
                }
            ]
        },
        {
            "pid": 2,
            "province": "天津市",
            "citySet": [
                {
                    "cid": "106",
                    "city": "天津市"
                }
            ]
        },
        {
            "pid": 3,
            "province": "上海市",
            "citySet": [
                {
                    "cid": "6",
                    "city": "上海市"
                }
            ]
        },
        {
            "pid": 4,
            "province": "重庆市",
            "citySet": [
                {
                    "cid": "338",
                    "city": "重庆市"
                }
            ]
        },
        {
            "pid": 5,
            "province": "河北省",
            "citySet": [
                {
                    "cid": "39",
                    "city": "保定市"
                },
                {
                    "cid": "87",
                    "city": "唐山市"
                },
                {
                    "cid": "146",
                    "city": "廊坊市"
                },
                {
                    "cid": "150",
                    "city": "张家口市"
                },
                {
                    "cid": "166",
                    "city": "承德市"
                },
                {
                    "cid": "217",
                    "city": "沧州市"
                },
                {
                    "cid": "277",
                    "city": "石家庄市"
                },
                {
                    "cid": "281",
                    "city": "秦皇岛市"
                },
                {
                    "cid": "305",
                    "city": "衡水市"
                },
                {
                    "cid": "329",
                    "city": "邢台市"
                },
                {
                    "cid": "331",
                    "city": "邯郸市"
                }
            ]
        },
        {
            "pid": 6,
            "province": "山西省",
            "citySet": [
                {
                    "cid": "14",
                    "city": "临汾市"
                },
                {
                    "cid": "77",
                    "city": "吕梁市"
                },
                {
                    "cid": "102",
                    "city": "大同市"
                },
                {
                    "cid": "108",
                    "city": "太原市"
                },
                {
                    "cid": "158",
                    "city": "忻州市"
                },
                {
                    "cid": "186",
                    "city": "晋中市"
                },
                {
                    "cid": "187",
                    "city": "晋城市"
                },
                {
                    "cid": "190",
                    "city": "朔州市"
                },
                {
                    "cid": "322",
                    "city": "运城市"
                },
                {
                    "cid": "352",
                    "city": "长治市"
                },
                {
                    "cid": "358",
                    "city": "阳泉市"
                }
            ]
        },
        {
            "pid": 7,
            "province": "台湾省",
            "citySet": [
                {
                    "cid": "28",
                    "city": "云林县"
                },
                {
                    "cid": "58",
                    "city": "南投县"
                },
                {
                    "cid": "65",
                    "city": "台东县"
                },
                {
                    "cid": "66",
                    "city": "台中县"
                },
                {
                    "cid": "67",
                    "city": "台中市"
                },
                {
                    "cid": "68",
                    "city": "台北县"
                },
                {
                    "cid": "69",
                    "city": "台北市"
                },
                {
                    "cid": "70",
                    "city": "台南县"
                },
                {
                    "cid": "71",
                    "city": "台南市"
                },
                {
                    "cid": "91",
                    "city": "嘉义县"
                },
                {
                    "cid": "92",
                    "city": "嘉义市"
                },
                {
                    "cid": "98",
                    "city": "基隆市"
                },
                {
                    "cid": "121",
                    "city": "宜兰县"
                },
                {
                    "cid": "129",
                    "city": "屏东县"
                },
                {
                    "cid": "153",
                    "city": "彰化县"
                },
                {
                    "cid": "176",
                    "city": "新竹县"
                },
                {
                    "cid": "177",
                    "city": "新竹市"
                },
                {
                    "cid": "202",
                    "city": "桃园县"
                },
                {
                    "cid": "253",
                    "city": "澎湖县"
                },
                {
                    "cid": "292",
                    "city": "花莲县"
                },
                {
                    "cid": "294",
                    "city": "苗栗县"
                },
                {
                    "cid": "376",
                    "city": "高雄县"
                },
                {
                    "cid": "377",
                    "city": "高雄市"
                }
            ]
        },
        {
            "pid": 8,
            "province": "辽宁省",
            "citySet": [
                {
                    "cid": "18",
                    "city": "丹东市"
                },
                {
                    "cid": "104",
                    "city": "大连市"
                },
                {
                    "cid": "168",
                    "city": "抚顺市"
                },
                {
                    "cid": "191",
                    "city": "朝阳市"
                },
                {
                    "cid": "192",
                    "city": "本溪市"
                },
                {
                    "cid": "216",
                    "city": "沈阳市"
                },
                {
                    "cid": "274",
                    "city": "盘锦市"
                },
                {
                    "cid": "302",
                    "city": "营口市"
                },
                {
                    "cid": "303",
                    "city": "葫芦岛市"
                },
                {
                    "cid": "320",
                    "city": "辽阳市"
                },
                {
                    "cid": "342",
                    "city": "铁岭市"
                },
                {
                    "cid": "348",
                    "city": "锦州市"
                },
                {
                    "cid": "354",
                    "city": "阜新市"
                },
                {
                    "cid": "371",
                    "city": "鞍山市"
                }
            ]
        },
        {
            "pid": 9,
            "province": "吉林省",
            "citySet": [
                {
                    "cid": "75",
                    "city": "吉林市"
                },
                {
                    "cid": "95",
                    "city": "四平市"
                },
                {
                    "cid": "148",
                    "city": "延边朝鲜族自治州"
                },
                {
                    "cid": "195",
                    "city": "松原市"
                },
                {
                    "cid": "267",
                    "city": "白城市"
                },
                {
                    "cid": "268",
                    "city": "白山市"
                },
                {
                    "cid": "319",
                    "city": "辽源市"
                },
                {
                    "cid": "325",
                    "city": "通化市"
                },
                {
                    "cid": "350",
                    "city": "长春市"
                }
            ]
        },
        {
            "pid": 10,
            "province": "黑龙江省",
            "citySet": [
                {
                    "cid": "1",
                    "city": "七台河市"
                },
                {
                    "cid": "34",
                    "city": "伊春市"
                },
                {
                    "cid": "37",
                    "city": "佳木斯市"
                },
                {
                    "cid": "64",
                    "city": "双鸭山市"
                },
                {
                    "cid": "86",
                    "city": "哈尔滨市"
                },
                {
                    "cid": "101",
                    "city": "大兴安岭地区"
                },
                {
                    "cid": "100",
                    "city": "大庆市"
                },
                {
                    "cid": "258",
                    "city": "牡丹江市"
                },
                {
                    "cid": "285",
                    "city": "绥化市"
                },
                {
                    "cid": "378",
                    "city": "鸡西市"
                },
                {
                    "cid": "379",
                    "city": "鹤岗市"
                },
                {
                    "cid": "386",
                    "city": "黑河市"
                },
                {
                    "cid": "390",
                    "city": "齐齐哈尔市"
                }
            ]
        },
        {
            "pid": 11,
            "province": "江苏省",
            "citySet": [
                {
                    "cid": "54",
                    "city": "南京市"
                },
                {
                    "cid": "60",
                    "city": "南通市"
                },
                {
                    "cid": "128",
                    "city": "宿迁市"
                },
                {
                    "cid": "137",
                    "city": "常州市"
                },
                {
                    "cid": "154",
                    "city": "徐州市"
                },
                {
                    "cid": "165",
                    "city": "扬州市"
                },
                {
                    "cid": "178",
                    "city": "无锡市"
                },
                {
                    "cid": "222",
                    "city": "泰州市"
                },
                {
                    "cid": "236",
                    "city": "淮安市"
                },
                {
                    "cid": "273",
                    "city": "盐城市"
                },
                {
                    "cid": "293",
                    "city": "苏州市"
                },
                {
                    "cid": "323",
                    "city": "连云港市"
                },
                {
                    "cid": "349",
                    "city": "镇江市"
                }
            ]
        },
        {
            "pid": 12,
            "province": "浙江省",
            "citySet": [
                {
                    "cid": "19",
                    "city": "丽水市"
                },
                {
                    "cid": "72",
                    "city": "台州市"
                },
                {
                    "cid": "93",
                    "city": "嘉兴市"
                },
                {
                    "cid": "114",
                    "city": "宁波市"
                },
                {
                    "cid": "194",
                    "city": "杭州市"
                },
                {
                    "cid": "239",
                    "city": "温州市"
                },
                {
                    "cid": "241",
                    "city": "湖州市"
                },
                {
                    "cid": "284",
                    "city": "绍兴市"
                },
                {
                    "cid": "290",
                    "city": "舟山市"
                },
                {
                    "cid": "307",
                    "city": "衢州市"
                },
                {
                    "cid": "339",
                    "city": "金华市"
                }
            ]
        },
        {
            "pid": 13,
            "province": "安徽省",
            "citySet": [
                {
                    "cid": "32",
                    "city": "亳州市"
                },
                {
                    "cid": "44",
                    "city": "六安市"
                },
                {
                    "cid": "73",
                    "city": "合肥市"
                },
                {
                    "cid": "115",
                    "city": "安庆市"
                },
                {
                    "cid": "126",
                    "city": "宣城市"
                },
                {
                    "cid": "127",
                    "city": "宿州市"
                },
                {
                    "cid": "134",
                    "city": "巢湖市"
                },
                {
                    "cid": "215",
                    "city": "池州市"
                },
                {
                    "cid": "234",
                    "city": "淮北市"
                },
                {
                    "cid": "235",
                    "city": "淮南市"
                },
                {
                    "cid": "245",
                    "city": "滁州市"
                },
                {
                    "cid": "291",
                    "city": "芜湖市"
                },
                {
                    "cid": "304",
                    "city": "蚌埠市"
                },
                {
                    "cid": "345",
                    "city": "铜陵市"
                },
                {
                    "cid": "355",
                    "city": "阜阳市"
                },
                {
                    "cid": "374",
                    "city": "马鞍山市"
                },
                {
                    "cid": "384",
                    "city": "黄山市"
                }
            ]
        },
        {
            "pid": 14,
            "province": "福建省",
            "citySet": [
                {
                    "cid": "4",
                    "city": "三明市"
                },
                {
                    "cid": "57",
                    "city": "南平市"
                },
                {
                    "cid": "63",
                    "city": "厦门市"
                },
                {
                    "cid": "113",
                    "city": "宁德市"
                },
                {
                    "cid": "220",
                    "city": "泉州市"
                },
                {
                    "cid": "248",
                    "city": "漳州市"
                },
                {
                    "cid": "280",
                    "city": "福州市"
                },
                {
                    "cid": "298",
                    "city": "莆田市"
                },
                {
                    "cid": "391",
                    "city": "龙岩市"
                }
            ]
        },
        {
            "pid": 15,
            "province": "江西省",
            "citySet": [
                {
                    "cid": "7",
                    "city": "上饶市"
                },
                {
                    "cid": "27",
                    "city": "九江市"
                },
                {
                    "cid": "59",
                    "city": "南昌市"
                },
                {
                    "cid": "74",
                    "city": "吉安市"
                },
                {
                    "cid": "124",
                    "city": "宜春市"
                },
                {
                    "cid": "167",
                    "city": "抚州市"
                },
                {
                    "cid": "175",
                    "city": "新余市"
                },
                {
                    "cid": "188",
                    "city": "景德镇市"
                },
                {
                    "cid": "301",
                    "city": "萍乡市"
                },
                {
                    "cid": "317",
                    "city": "赣州市"
                },
                {
                    "cid": "381",
                    "city": "鹰潭市"
                }
            ]
        },
        {
            "pid": 16,
            "province": "山东省",
            "citySet": [
                {
                    "cid": "10",
                    "city": "东营市"
                },
                {
                    "cid": "15",
                    "city": "临沂市"
                },
                {
                    "cid": "110",
                    "city": "威海市"
                },
                {
                    "cid": "156",
                    "city": "德州市"
                },
                {
                    "cid": "180",
                    "city": "日照市"
                },
                {
                    "cid": "198",
                    "city": "枣庄市"
                },
                {
                    "cid": "221",
                    "city": "泰安市"
                },
                {
                    "cid": "225",
                    "city": "济南市"
                },
                {
                    "cid": "226",
                    "city": "济宁市"
                },
                {
                    "cid": "233",
                    "city": "淄博市"
                },
                {
                    "cid": "246",
                    "city": "滨州市"
                },
                {
                    "cid": "249",
                    "city": "潍坊市"
                },
                {
                    "cid": "256",
                    "city": "烟台市"
                },
                {
                    "cid": "287",
                    "city": "聊城市"
                },
                {
                    "cid": "299",
                    "city": "莱芜市"
                },
                {
                    "cid": "300",
                    "city": "菏泽市"
                },
                {
                    "cid": "370",
                    "city": "青岛市"
                }
            ]
        },
        {
            "pid": 17,
            "province": "河南省",
            "citySet": [
                {
                    "cid": "5",
                    "city": "三门峡市"
                },
                {
                    "cid": "41",
                    "city": "信阳市"
                },
                {
                    "cid": "61",
                    "city": "南阳市"
                },
                {
                    "cid": "79",
                    "city": "周口市"
                },
                {
                    "cid": "88",
                    "city": "商丘市"
                },
                {
                    "cid": "117",
                    "city": "安阳市"
                },
                {
                    "cid": "140",
                    "city": "平顶山市"
                },
                {
                    "cid": "149",
                    "city": "开封市"
                },
                {
                    "cid": "174",
                    "city": "新乡市"
                },
                {
                    "cid": "224",
                    "city": "洛阳市"
                },
                {
                    "cid": "227",
                    "city": "济源市"
                },
                {
                    "cid": "247",
                    "city": "漯河市"
                },
                {
                    "cid": "255",
                    "city": "濮阳市"
                },
                {
                    "cid": "257",
                    "city": "焦作市"
                },
                {
                    "cid": "312",
                    "city": "许昌市"
                },
                {
                    "cid": "333",
                    "city": "郑州市"
                },
                {
                    "cid": "375",
                    "city": "驻马店市"
                },
                {
                    "cid": "380",
                    "city": "鹤壁市"
                }
            ]
        },
        {
            "pid": 18,
            "province": "湖北省",
            "citySet": [
                {
                    "cid": "33",
                    "city": "仙桃市"
                },
                {
                    "cid": "53",
                    "city": "十堰市"
                },
                {
                    "cid": "83",
                    "city": "咸宁市"
                },
                {
                    "cid": "107",
                    "city": "天门市"
                },
                {
                    "cid": "112",
                    "city": "孝感市"
                },
                {
                    "cid": "123",
                    "city": "宜昌市"
                },
                {
                    "cid": "162",
                    "city": "恩施土家族苗族自治州"
                },
                {
                    "cid": "208",
                    "city": "武汉市"
                },
                {
                    "cid": "250",
                    "city": "潜江市"
                },
                {
                    "cid": "279",
                    "city": "神农架林区"
                },
                {
                    "cid": "296",
                    "city": "荆州市"
                },
                {
                    "cid": "297",
                    "city": "荆门市"
                },
                {
                    "cid": "308",
                    "city": "襄樊市"
                },
                {
                    "cid": "336",
                    "city": "鄂州市"
                },
                {
                    "cid": "368",
                    "city": "随州市"
                },
                {
                    "cid": "382",
                    "city": "黄冈市"
                },
                {
                    "cid": "385",
                    "city": "黄石市"
                }
            ]
        },
        {
            "pid": 19,
            "province": "湖南省",
            "citySet": [
                {
                    "cid": "111",
                    "city": "娄底市"
                },
                {
                    "cid": "132",
                    "city": "岳阳市"
                },
                {
                    "cid": "138",
                    "city": "常德市"
                },
                {
                    "cid": "151",
                    "city": "张家界市"
                },
                {
                    "cid": "159",
                    "city": "怀化市"
                },
                {
                    "cid": "200",
                    "city": "株洲市"
                },
                {
                    "cid": "210",
                    "city": "永州市"
                },
                {
                    "cid": "242",
                    "city": "湘潭市"
                },
                {
                    "cid": "243",
                    "city": "湘西土家族苗族自治州"
                },
                {
                    "cid": "272",
                    "city": "益阳市"
                },
                {
                    "cid": "306",
                    "city": "衡阳市"
                },
                {
                    "cid": "332",
                    "city": "邵阳市"
                },
                {
                    "cid": "334",
                    "city": "郴州市"
                },
                {
                    "cid": "351",
                    "city": "长沙市"
                }
            ]
        },
        {
            "pid": 20,
            "province": "广东省",
            "citySet": [
                {
                    "cid": "9",
                    "city": "东莞市"
                },
                {
                    "cid": "12",
                    "city": "中山市"
                },
                {
                    "cid": "29",
                    "city": "云浮市"
                },
                {
                    "cid": "36",
                    "city": "佛山市"
                },
                {
                    "cid": "143",
                    "city": "广州市"
                },
                {
                    "cid": "163",
                    "city": "惠州市"
                },
                {
                    "cid": "170",
                    "city": "揭阳市"
                },
                {
                    "cid": "203",
                    "city": "梅州市"
                },
                {
                    "cid": "212",
                    "city": "汕头市"
                },
                {
                    "cid": "213",
                    "city": "汕尾市"
                },
                {
                    "cid": "214",
                    "city": "江门市"
                },
                {
                    "cid": "219",
                    "city": "河源市"
                },
                {
                    "cid": "237",
                    "city": "深圳市"
                },
                {
                    "cid": "238",
                    "city": "清远市"
                },
                {
                    "cid": "244",
                    "city": "湛江市"
                },
                {
                    "cid": "251",
                    "city": "潮州市"
                },
                {
                    "cid": "262",
                    "city": "珠海市"
                },
                {
                    "cid": "288",
                    "city": "肇庆市"
                },
                {
                    "cid": "295",
                    "city": "茂名市"
                },
                {
                    "cid": "357",
                    "city": "阳江市"
                },
                {
                    "cid": "372",
                    "city": "韶关市"
                }
            ]
        },
        {
            "pid": 21,
            "province": "甘肃省",
            "citySet": [
                {
                    "cid": "13",
                    "city": "临夏回族自治州"
                },
                {
                    "cid": "46",
                    "city": "兰州市"
                },
                {
                    "cid": "94",
                    "city": "嘉峪关市"
                },
                {
                    "cid": "105",
                    "city": "天水市"
                },
                {
                    "cid": "120",
                    "city": "定西市"
                },
                {
                    "cid": "139",
                    "city": "平凉市"
                },
                {
                    "cid": "144",
                    "city": "庆阳市"
                },
                {
                    "cid": "152",
                    "city": "张掖市"
                },
                {
                    "cid": "207",
                    "city": "武威市"
                },
                {
                    "cid": "265",
                    "city": "甘南藏族自治州"
                },
                {
                    "cid": "270",
                    "city": "白银市"
                },
                {
                    "cid": "337",
                    "city": "酒泉市"
                },
                {
                    "cid": "340",
                    "city": "金昌市"
                },
                {
                    "cid": "366",
                    "city": "陇南市"
                }
            ]
        },
        {
            "pid": 22,
            "province": "四川省",
            "citySet": [
                {
                    "cid": "26",
                    "city": "乐山市"
                },
                {
                    "cid": "48",
                    "city": "内江市"
                },
                {
                    "cid": "49",
                    "city": "凉山彝族自治州"
                },
                {
                    "cid": "55",
                    "city": "南充市"
                },
                {
                    "cid": "122",
                    "city": "宜宾市"
                },
                {
                    "cid": "135",
                    "city": "巴中市"
                },
                {
                    "cid": "141",
                    "city": "广元市"
                },
                {
                    "cid": "142",
                    "city": "广安市"
                },
                {
                    "cid": "157",
                    "city": "德阳市"
                },
                {
                    "cid": "164",
                    "city": "成都市"
                },
                {
                    "cid": "171",
                    "city": "攀枝花市"
                },
                {
                    "cid": "223",
                    "city": "泸州市"
                },
                {
                    "cid": "266",
                    "city": "甘孜藏族自治州"
                },
                {
                    "cid": "275",
                    "city": "眉山市"
                },
                {
                    "cid": "286",
                    "city": "绵阳市"
                },
                {
                    "cid": "289",
                    "city": "自贡市"
                },
                {
                    "cid": "316",
                    "city": "资阳市"
                },
                {
                    "cid": "321",
                    "city": "达州市"
                },
                {
                    "cid": "327",
                    "city": "遂宁市"
                },
                {
                    "cid": "362",
                    "city": "阿坝藏族羌族自治州"
                },
                {
                    "cid": "369",
                    "city": "雅安市"
                }
            ]
        },
        {
            "pid": 23,
            "province": "贵州省",
            "citySet": [
                {
                    "cid": "45",
                    "city": "六盘水市"
                },
                {
                    "cid": "118",
                    "city": "安顺市"
                },
                {
                    "cid": "209",
                    "city": "毕节地区"
                },
                {
                    "cid": "314",
                    "city": "贵阳市"
                },
                {
                    "cid": "328",
                    "city": "遵义市"
                },
                {
                    "cid": "343",
                    "city": "铜仁地区"
                },
                {
                    "cid": "387",
                    "city": "黔东南苗族侗族自治州"
                },
                {
                    "cid": "388",
                    "city": "黔南布依族苗族自治州"
                },
                {
                    "cid": "389",
                    "city": "黔西南布依族苗族自治州"
                }
            ]
        },
        {
            "pid": 24,
            "province": "海南省",
            "citySet": [
                {
                    "cid": "2",
                    "city": "万宁市"
                },
                {
                    "cid": "3",
                    "city": "三亚市"
                },
                {
                    "cid": "8",
                    "city": "东方市"
                },
                {
                    "cid": "17",
                    "city": "临高县"
                },
                {
                    "cid": "25",
                    "city": "乐东黎族自治县"
                },
                {
                    "cid": "31",
                    "city": "五指山市"
                },
                {
                    "cid": "38",
                    "city": "保亭黎族苗族自治县"
                },
                {
                    "cid": "42",
                    "city": "儋州市"
                },
                {
                    "cid": "119",
                    "city": "定安县"
                },
                {
                    "cid": "130",
                    "city": "屯昌县"
                },
                {
                    "cid": "173",
                    "city": "文昌市"
                },
                {
                    "cid": "183",
                    "city": "昌江黎族自治县"
                },
                {
                    "cid": "231",
                    "city": "海口市"
                },
                {
                    "cid": "252",
                    "city": "澄迈县"
                },
                {
                    "cid": "263",
                    "city": "琼中黎族苗族自治县"
                },
                {
                    "cid": "264",
                    "city": "琼海市"
                },
                {
                    "cid": "269",
                    "city": "白沙黎族自治县"
                },
                {
                    "cid": "367",
                    "city": "陵水黎族自治县"
                }
            ]
        },
        {
            "pid": 25,
            "province": "云南省",
            "citySet": [
                {
                    "cid": "16",
                    "city": "临沧市"
                },
                {
                    "cid": "20",
                    "city": "丽江市"
                },
                {
                    "cid": "40",
                    "city": "保山市"
                },
                {
                    "cid": "103",
                    "city": "大理白族自治州"
                },
                {
                    "cid": "155",
                    "city": "德宏傣族景颇族自治州"
                },
                {
                    "cid": "160",
                    "city": "怒江傈傈族自治州"
                },
                {
                    "cid": "161",
                    "city": "思茅市"
                },
                {
                    "cid": "172",
                    "city": "文山壮族苗族自治州"
                },
                {
                    "cid": "181",
                    "city": "昆明市"
                },
                {
                    "cid": "185",
                    "city": "昭通市"
                },
                {
                    "cid": "189",
                    "city": "曲靖市"
                },
                {
                    "cid": "205",
                    "city": "楚雄彝族自治州"
                },
                {
                    "cid": "261",
                    "city": "玉溪市"
                },
                {
                    "cid": "283",
                    "city": "红河哈尼族彝族自治州"
                },
                {
                    "cid": "309",
                    "city": "西双版纳傣族自治州"
                },
                {
                    "cid": "324",
                    "city": "迪庆藏族自治州"
                }
            ]
        },
        {
            "pid": 26,
            "province": "青海省",
            "citySet": [
                {
                    "cid": "197",
                    "city": "果洛藏族自治州"
                },
                {
                    "cid": "228",
                    "city": "海东地区"
                },
                {
                    "cid": "229",
                    "city": "海北藏族自治州"
                },
                {
                    "cid": "230",
                    "city": "海南藏族自治州"
                },
                {
                    "cid": "232",
                    "city": "海西蒙古族藏族自治州"
                },
                {
                    "cid": "260",
                    "city": "玉树藏族自治州"
                },
                {
                    "cid": "310",
                    "city": "西宁市"
                },
                {
                    "cid": "383",
                    "city": "黄南藏族自治州"
                }
            ]
        },
        {
            "pid": 27,
            "province": "陕西省",
            "citySet": [
                {
                    "cid": "84",
                    "city": "咸阳市"
                },
                {
                    "cid": "89",
                    "city": "商洛市"
                },
                {
                    "cid": "116",
                    "city": "安康市"
                },
                {
                    "cid": "125",
                    "city": "宝鸡市"
                },
                {
                    "cid": "147",
                    "city": "延安市"
                },
                {
                    "cid": "206",
                    "city": "榆林市"
                },
                {
                    "cid": "211",
                    "city": "汉中市"
                },
                {
                    "cid": "240",
                    "city": "渭南市"
                },
                {
                    "cid": "311",
                    "city": "西安市"
                },
                {
                    "cid": "344",
                    "city": "铜川市"
                }
            ]
        },
        {
            "pid": 28,
            "province": "广西壮族自治区",
            "citySet": [
                {
                    "cid": "52",
                    "city": "北海市"
                },
                {
                    "cid": "56",
                    "city": "南宁市"
                },
                {
                    "cid": "133",
                    "city": "崇左市"
                },
                {
                    "cid": "193",
                    "city": "来宾市"
                },
                {
                    "cid": "199",
                    "city": "柳州市"
                },
                {
                    "cid": "201",
                    "city": "桂林市"
                },
                {
                    "cid": "204",
                    "city": "梧州市"
                },
                {
                    "cid": "218",
                    "city": "河池市"
                },
                {
                    "cid": "259",
                    "city": "玉林市"
                },
                {
                    "cid": "271",
                    "city": "百色市"
                },
                {
                    "cid": "313",
                    "city": "贵港市"
                },
                {
                    "cid": "315",
                    "city": "贺州市"
                },
                {
                    "cid": "341",
                    "city": "钦州市"
                },
                {
                    "cid": "356",
                    "city": "防城港市"
                }
            ]
        },
        {
            "pid": 29,
            "province": "西藏自治区",
            "citySet": [
                {
                    "cid": "131",
                    "city": "山南地区"
                },
                {
                    "cid": "169",
                    "city": "拉萨市"
                },
                {
                    "cid": "179",
                    "city": "日喀则地区"
                },
                {
                    "cid": "184",
                    "city": "昌都地区"
                },
                {
                    "cid": "196",
                    "city": "林芝地区"
                },
                {
                    "cid": "330",
                    "city": "那曲地区"
                },
                {
                    "cid": "365",
                    "city": "阿里地区"
                }
            ]
        },
        {
            "pid": 30,
            "province": "宁夏回族自治区",
            "citySet": [
                {
                    "cid": "11",
                    "city": "中卫市"
                },
                {
                    "cid": "78",
                    "city": "吴忠市"
                },
                {
                    "cid": "96",
                    "city": "固原市"
                },
                {
                    "cid": "276",
                    "city": "石嘴山市"
                },
                {
                    "cid": "346",
                    "city": "银川市"
                }
            ]
        },
        {
            "pid": 31,
            "province": "新疆维吾尔自治区",
            "citySet": [
                {
                    "cid": "23",
                    "city": "乌苏市"
                },
                {
                    "cid": "24",
                    "city": "乌鲁木齐市"
                },
                {
                    "cid": "30",
                    "city": "五家渠市"
                },
                {
                    "cid": "35",
                    "city": "伊宁市"
                },
                {
                    "cid": "43",
                    "city": "克拉玛依市"
                },
                {
                    "cid": "62",
                    "city": "博乐市"
                },
                {
                    "cid": "76",
                    "city": "吐鲁番市"
                },
                {
                    "cid": "82",
                    "city": "和田市"
                },
                {
                    "cid": "85",
                    "city": "哈密市"
                },
                {
                    "cid": "90",
                    "city": "喀什市"
                },
                {
                    "cid": "97",
                    "city": "图木舒克市"
                },
                {
                    "cid": "99",
                    "city": "塔城市"
                },
                {
                    "cid": "109",
                    "city": "奎屯市"
                },
                {
                    "cid": "145",
                    "city": "库尔勒市"
                },
                {
                    "cid": "182",
                    "city": "昌吉市 "
                },
                {
                    "cid": "278",
                    "city": "石河子市 "
                },
                {
                    "cid": "282",
                    "city": "米泉市"
                },
                {
                    "cid": "353",
                    "city": "阜康市"
                },
                {
                    "cid": "359",
                    "city": "阿克苏市"
                },
                {
                    "cid": "360",
                    "city": "阿勒泰市"
                },
                {
                    "cid": "361",
                    "city": "阿图什市"
                },
                {
                    "cid": "364",
                    "city": "阿拉尔市"
                }
            ]
        },
        {
            "pid": 32,
            "province": "内蒙古自治区",
            "citySet": [
                {
                    "cid": "21",
                    "city": "乌兰察布市"
                },
                {
                    "cid": "22",
                    "city": "乌海市"
                },
                {
                    "cid": "47",
                    "city": "兴安盟"
                },
                {
                    "cid": "50",
                    "city": "包头市"
                },
                {
                    "cid": "80",
                    "city": "呼伦贝尔市"
                },
                {
                    "cid": "81",
                    "city": "呼和浩特市"
                },
                {
                    "cid": "136",
                    "city": "巴彦淖尔市"
                },
                {
                    "cid": "318",
                    "city": "赤峰市"
                },
                {
                    "cid": "326",
                    "city": "通辽市"
                },
                {
                    "cid": "335",
                    "city": "鄂尔多斯市"
                },
                {
                    "cid": "347",
                    "city": "锡林郭勒盟"
                },
                {
                    "cid": "363",
                    "city": "阿拉善盟"
                }
            ]
        },
        {
            "pid": 33,
            "province": "澳门特别行政区",
            "citySet": [
                {
                    "cid": "254",
                    "city": "澳门特别行政区"
                }
            ]
        },
        {
            "pid": 34,
            "province": "香港特别行政区",
            "citySet": [
                {
                    "cid": "373",
                    "city": "香港特别行政区"
                }
            ]
        }
    ]

  • 1
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值