省级行政区、地级市数据,不含县级行政区
一、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": "香港特别行政区"
}
]
}
]