--**************************************************************
CREATE TABLE common_Area
(
AreaID INTPRIMARYKEY,
AreaName NVARCHAR(50) NOTNULL,
RootID INT,
ChildAmount INT,
Depth INT,
Sort INT,
IsOpen BIT
)
--中国(2007年:24个省,5个自治区,4个直辖市,2个特别行政区)
INSERTINTO common_Area VALUES(1,'北京市',0,0,1,1,1)
INSERTINTO common_Area VALUES(2,'天津市',0,0,1,2,1)
INSERTINTO common_Area VALUES(3,'上海市',0,0,1,3,1)
INSERTINTO common_Area VALUES(4,'重庆市',0,0,1,4,1)
INSERTINTO common_Area VALUES(5,'河北省',0,0,1,5,1)
INSERTINTO common_Area VALUES(6,'山西省',0,0,1,6,1)
INSERTINTO common_Area VALUES(7,'台湾省',0,0,1,7,1)
INSERTINTO common_Area VALUES(8,'辽宁省',0,0,1,8,1)
INSERTINTO common_Area VALUES(9,'吉林省',0,0,1,9,1)
INSERTINTO common_Area VALUES(10,'黑龙江省',0,0,1,10,1)
INSERTINTO common_Area VALUES(11,'江苏省',0,0,1,11,1)
INSERTINTO common_Area VALUES(12,'浙江省',0,0,1,12,1)
INSERTINTO common_Area VALUES(13,'安徽省',0,0,1,13,1)
INSERTINTO common_Area VALUES(14,'福建省',0,0,1,14,1)
INSERTINTO common_Area VALUES(15,'江西省',0,0,1,15,1)
INSERTINTO common_Area VALUES(16,'山东省',0,0,1,16,1)
INSERTINTO common_Area VALUES(17,'河南省',0,0,1,17,1)
INSERTINTO common_Area VALUES(18,'湖北省',0,0,1,18,1)
INSERTINTO common_Area VALUES(19,'湖南省',0,0,1,19,1)
INSERTINTO common_Area VALUES(20,'广东省',0,0,1,20,1)
INSERTINTO common_Area VALUES(21,'甘肃省',0,0,1,21,1)
INSERTINTO common_Area VALUES(22,'四川省',0,0,1,22,1)
INSERTINTO common_Area VALUES(23,'贵州省',0,0,1,23,1)
INSERTINTO common_Area VALUES(24,'海南省',0,0,1,24,1)
INSERTINTO common_Area VALUES(25,'云南省',0,0,1,25,1)
INSERTINTO common_Area VALUES(26,'青海省',0,0,1,26,1)
INSERTINTO common_Area VALUES(27,'陕西省',0,0,1,27,1)
INSERTINTO common_Area VALUES(28,'广西壮族自治区',0,0,1,28,1)
INSERTINTO common_Area VALUES(29,'西藏自治区',0,0,1,29,1)
INSERTINTO common_Area VALUES(30,'宁夏回族自治区',0,0,1,30,1)
INSERTINTO common_Area VALUES(31,'新疆维吾尔自治区',0,0,1,31,1)
INSERTINTO common_Area VALUES(32,'内蒙古自治区',0,0,1,32,1)
INSERTINTO common_Area VALUES(33,'澳门特别行政区',0,0,1,33,1)
INSERTINTO common_Area VALUES(34,'香港特别行政区',0,0,1,34,1)
--1北京市
INSERTINTO common_Area VALUES(61,'东城区',1,0,2,1,0)
INSERTINTO common_Area VALUES(62,'西城区',1,0,2,2,0)
INSERTINTO common_Area VALUES(63,'崇文区',1,0,2,3,0)
INSERTINTO common_Area VALUES(64,'宣武区',1,0,2,4,0)
INSERTINTO common_Area VALUES(65,'朝阳区',1,0,2,5,0)
INSERTINTO common_Area VALUES(66,'丰台区',1,0,2,6,0)
INSERTINTO common_Area VALUES(67,'石景山区',1,0,2,7,0)
INSERTINTO common_Area VALUES(68,'海淀区',1,0,2,8,0)
INSERTINTO common_Area VALUES(69,'门头沟区',1,0,2,9,0)
INSERTINTO common_Area VALUES(70,'房山区',1,0,2,10,0)
INSERTINTO common_Area VALUES(71,'通州区',1,0,2,11,0)
INSERTINTO common_Area VALUES(72,'顺义区',1,0,2,12,0)
INSERTINTO common_Area VALUES(73,'昌平区',1,0,2,13,0)
INSERTINTO common_Area VALUES(74,'大兴区',1,0,2,14,0)
INSERTINTO common_Area VALUES(75,'怀柔区',1,0,2,15,0)
INSERTINTO common_Area VALUES(76,'平谷区',1,0,2,16,0)
INSERTINTO common_Area VALUES(77,'延庆县',1,0,2,17,0)
INSERTINTO common_Area VALUES(78,'密云县',1,0,2,18,0)
UPDATE common_Area SET ChildAmount = 18 WHERE AreaID = 1
--5河北省(2005年辖:11个地级市,36个市辖区、22个县级市、108个县、6个自治县,1)
INSERTINTO common_Area VALUES(101,'石家庄市',5,0,2,1,1)
INSERTINTO common_Area VALUES(102,'唐山市',5,0,2,2,1)
INSERTINTO common_Area VALUES(103,'秦皇岛市',5,0,2,3,1)
INSERTINTO common_Area VALUES(104,'邯郸市',5,0,2,4,1)
INSERTINTO common_Area VALUES(105,'邢台市',5,0,2,5,1)
INSERTINTO common_Area VALUES(106,'保定市',5,0,2,6,1)
INSERTINTO common_Area VALUES(107,'张家口市',5,0,2,7,1)
INSERTINTO common_Area VALUES(108,'承德市',5,0,2,8,1)
INSERTINTO common_Area VALUES(109,'沧州市',5,0,2,9,1)
INSERTINTO common_Area VALUES(110,'廊坊市',5,0,2,10,1)
INSERTINTO common_Area VALUES(111,'衡水市',5,0,2,11,1)
UPDATE common_Area SET ChildAmount = 11 WHERE AreaID = 5
--6山西省11个城市
INSERTINTO common_Area VALUES(121,'太原市',6,0,2,1,1)
INSERTINTO common_Area VALUES(122,'大同市',6,0,2,2,1)
INSERTINTO common_Area VALUES(123,'阳泉市',6,0,2,3,1)
INSERTINTO common_Area VALUES(124,'长治市',6,0,2,4,1)
INSERTINTO common_Area VALUES(125,'晋城市',6,0,2,5,1)
INSERTINTO common_Area VALUES(126,'朔州市',6,0,2,6,1)
INSERTINTO common_Area VALUES(127,'晋中市',6,0,2,7,1)
INSERTINTO common_Area VALUES(128,'运城市',6,0,2,8,1)
INSERTINTO common_Area VALUES(129,'忻州市',6,0,2,9,1)
INSERTINTO common_Area VALUES(130,'临汾市',6,0,2,10,1)
INSERTINTO common_Area VALUES(131,'吕梁市',6,0,2,11,1)
UPDATE common_Area SET ChildAmount = 11 WHERE AreaID = 6
---7台湾省(台湾本岛和澎湖共设7市、16县,其中台北市和高雄市为“院辖市”,直属“行政院”,其余属台湾省;市下设区,县下设市(县辖市)、镇、乡,合称区市镇乡。,1)
INSERTINTO common_Area VALUES(141,'台北市',7,0,2,1,1)
INSERTINTO common_Area VALUES(142,'高雄市',7,0,2,2,1)
INSERTINTO common_Area VALUES(143,'基隆市',7,0,2,3,1)
INSERTINTO common_Area VALUES(144,'台中市',7,0,2,4,1)
INSERTINTO common_Area VALUES(145,'台南市',7,0,2,5,1)
INSERTINTO common_Area VALUES(146,'新竹市',7,0,2,6,1)
INSERTINTO common_Area VALUES(147,'嘉义市',7,0,2,7,1)
INSERTINTO common_Area VALUES(148,'台北县',7,0,2,8,1)
INSERTINTO common_Area VALUES(149,'宜兰县',7,0,2,9,1)
INSERTINTO common_Area VALUES(150,'桃园县',7,0,2,10,1)
INSERTINTO common_Area VALUES(151,'新竹县',7,0,2,11,1)
INSERTINTO common_Area VALUES(152,'苗栗县',7,0,2,12,1)
INSERTINTO common_Area VALUES(153,'台中县',7,0,2,13,1)
INSERTINTO common_Area VALUES(154,'彰化县',7,0,2,14,1)
INSERTINTO common_Area VALUES(155,'南投县',7,0,2,15,1)
INSERTINTO common_Area VALUES(156,'云林县',7,0,2,16,1)
INSERTINTO common_Area VALUES(157,'嘉义县',7,0,2,17,1)
INSERTINTO common_Area VALUES(158,'台南县',7,0,2,18,1)
INSERTINTO common_Area VALUES(159,'高雄县',7,0,2,19,1)
INSERTINTO common_Area VALUES(160,'屏东县',7,0,2,20,1)
INSERTINTO common_Area VALUES(161,'澎湖县',7,0,2,21,1)
INSERTINTO common_Area VALUES(162,'台东县',7,0,2,22,1)
INSERTINTO common_Area VALUES(163,'花莲县',7,0,2,23,1)
UPDATE common_Area SET ChildAmount = 23 WHERE AreaID = 7
--8辽宁省(2006年,辖:14个地级市;56个市辖区、17个县级市、19个县、8个自治县。,1)
INSERTINTO common_Area VALUES(181,'沈阳市',8,0,2,1,1)
INSERTINTO common_Area VALUES(182,'大连市',8,0,2,2,1)
INSERTINTO common_Area VALUES(183,'鞍山市',8,0,2,3,1)
INSERTINTO common_Area VALUES(184,'抚顺市',8,0,2,4,1)
INSERTINTO common_Area VALUES(185,'本溪市',8,0,2,5,1)
INSERTINTO common_Area VALUES(186,'丹东市',8,0,2,6,1)
INSERTINTO common_Area VALUES(187,'锦州市',8,0,2,7,1)
INSERTINTO common_Area VALUES(188,'营口市',8,0,2,8,1)
INSERTINTO common_Area VALUES(189,'阜新市',8,0,2,9,1)
INSERTINTO common_Area VALUES(190,'辽阳市',8,0,2,10,1)
INSERTINTO common_Area VALUES(191,'盘锦市',8,0,2,11,1)
INSERTINTO common_Area VALUES(192,'铁岭市',8,0,2,12,1)
INSERTINTO common_Area VALUES(193,'朝阳市',8,0,2,13,1)
INSERTINTO common_Area VALUES(194,'葫芦岛市',8,0,2,14,1)
UPDATE common_Area SET ChildAmount = 14 WHERE AreaID = 8
--9吉林省(2006年,辖:8个地级市、1个自治州;20个市辖区、20个县级市、17个县、3个自治县。,1)
INSERTINTO common_Area VALUES(201,'长春市',9,0,2,1,1)
INSERTINTO common_Area VALUES(202,'吉林市',9,0,2,2,1)
INSERTINTO common_Area VALUES(203,'四平市',9,0,2,3,1)
INSERTINTO common_Area VALUES(204,'辽源市',9,0,2,4,1)
INSERTINTO common_Area VALUES(205,'通化市',9,0,2,5,1)
INSERTINTO common_Area VALUES(206,'白山市',9,0,2,6,1)
INSERTINTO common_Area VALUES(207,'松原市',9,0,2,7,1)
INSERTINTO common_Area VALUES(208,'白城市',9,0,2,8,1)
INSERTINTO common_Area VALUES(209,'延边朝鲜族自治州',9,0,2,9,1)
UPDATE common_Area SET ChildAmount = 9 WHERE AreaID = 9
--10黑龙江省(2006年,辖:12地级市、1地区;64市辖区、18县级市、45县、1自治县,1)
INSERTINTO common_Area VALUES(221,'哈尔滨市',10,0,2,1,1)
INSERTINTO common_Area VALUES(222,'齐齐哈尔市',10,0,2,2,1)
INSERTINTO common_Area VALUES(223,'鹤 岗 市',10,0,2,3,1)
INSERTINTO common_Area VALUES(224,'双鸭山市',10,0,2,4,1)
INSERTINTO common_Area VALUES(225,'鸡 西 市',10,0,2,5,1)
INSERTINTO common_Area VALUES(226,'大 庆 市',10,0,2,6,1)
INSERTINTO common_Area VALUES(227,'伊 春 市',10,0,2,7,1)
INSERTINTO common_Area VALUES(228,'牡丹江市',10,0,2,8,1)
INSERTINTO common_Area VALUES(229,'佳木斯市',10,0,2,9,1)
INSERTINTO common_Area VALUES(230,'七台河市',10,0,2,10,1)
INSERTINTO common_Area VALUES(231,'黑 河 市',10,0,2,11,1)
INSERTINTO common_Area VALUES(232,'绥 化 市',10,0,2,12,1)
INSERTINTO common_Area VALUES(233,'大兴安岭地区',10,0,2,13,1)
UPDATE common_Area SET ChildAmount = 13 WHERE AreaID = 10
--11江苏省(2005年辖:13个地级市;54个市辖区、27个县级市、25个县,1)
INSERTINTO common_Area VALUES(241,'南京市',11,0,2,1,1)
INSERTINTO common_Area VALUES(242,'无锡市',11,0,2,2,1)
INSERTINTO common_Area VALUES(243,'徐州市',11,0,2,3,1)
INSERTINTO common_Area VALUES(244,'常州市',11,0,2,4,1)
INSERTINTO common_Area VALUES(245,'苏州市',11,0,2,5,1)
INSERTINTO common_Area VALUES(246,'南通市',11,0,2,6,1)
INSERTINTO common_Area VALUES(247,'连云港市',11,0,2,7,1)
INSERTINTO common_Area VALUES(248,'淮安市',11,0,2,8,1)
INSERTINTO common_Area VALUES(249,'盐城市',11,0,2,9,1)
INSERTINTO common_Area VALUES(250,'扬州市',11,0,2,10,1)
INSERTINTO common_Area VALUES(251,'镇江市',11,0,2,11,1)
INSERTINTO common_Area VALUES(252,'泰州市',11,0,2,12,1)
INSERTINTO common_Area VALUES(253,'宿迁市',11,0,2,13,1)
UPDATE common_Area SET ChildAmount = 13 WHERE AreaID = 11
--12浙江省(2006年,辖:11个地级市;32个市辖区、22个县级市、35个县、1个自治县。,1)
INSERTINTO common_Area VALUES(281,'杭州市',12,0,2,1,1)
INSERTINTO common_Area VALUES(282,'宁波市',12,0,2,2,1)
INSERTINTO common_Area VALUES(283,'温州市',12,0,2,3,1)
INSERTINTO common_Area VALUES(284,'嘉兴市',12,0,2,4,1)
INSERTINTO common_Area VALUES(285,'湖州市',12,0,2,5,1)
INSERTINTO common_Area VALUES(286,'绍兴市',12,0,2,6,1)
INSERTINTO common_Area VALUES(287,'金华市',12,0,2,7,1)
INSERTINTO common_Area VALUES(288,'衢州市',12,0,2,8,1)
INSERTINTO common_Area VALUES(289,'舟山市',12,0,2,9,1)
INSERTINTO common_Area VALUES(290,'台州市',12,0,2,10,1)
INSERTINTO common_Area VALUES(291,'丽水市',12,0,2,11,1)
UPDATE common_Area SET ChildAmount = 11 WHERE AreaID = 12
--13安徽省(2005年辖:17个地级市;44个市辖区、5县个级市、56个县。,1)
INSERTINTO common_Area VALUES(301,'合肥市',13,0,2,1,1)
INSERTINTO common_Area VALUES(302,'芜湖市',13,0,2,2,1)
INSERTINTO common_Area VALUES(303,'蚌埠市',13,0,2,3,1)
INSERTINTO common_Area VALUES(304,'淮南市',13,0,2,4,1)
INSERTINTO common_Area VALUES(305,'马鞍山市',13,0,2,5,1)
INSERTINTO common_Area VALUES(306,'淮北市',13,0,2,6,1)
INSERTINTO common_Area VALUES(307,'铜陵市',13,0,2,7,1)
INSERTINTO common_Area VALUES(308,'安庆市',13,0,2,8,1)
INSERTINTO common_Area VALUES(309,'黄山市',13,0,2,9,1)
INSERTINTO common_Area VALUES(310,'滁州市',13,0,2,10,1)
INSERTINTO common_Area VALUES(311,'阜阳市',13,0,2,11,1)
INSERTINTO common_Area VALUES(312,'宿州市',13,0,2,12,1)
INSERTINTO common_Area VALUES(313,'巢湖市',13,0,2,13,1)
INSERTINTO common_Area VALUES(314,'六安市',13,0,2,14,1)
INSERTINTO common_Area VALUES(315,'亳州市',13,0,2,15,1)
INSERTINTO common_Area VALUES(316,'池州市',13,0,2,16,1)
INSERTINTO common_Area VALUES(317,'宣城市',13,0,2,17,1)
UPDATE common_Area SET ChildAmount = 17 WHERE AreaID = 13
--14福建省(2006年辖:9个地级市;26个市辖区、14个县级市、45个县。,1)
INSERTINTO common_Area VALUES(321,'福州市',14,0,2,1,1)
INSERTINTO common_Area VALUES(322,'厦门市',14,0,2,2,1)
INSERTINTO common_Area VALUES(323,'莆田市',14,0,2,3,1)
INSERTINTO common_Area VALUES(324,'三明市',14,0,2,4,1)
INSERTINTO common_Area VALUES(325,'泉州市',14,0,2,5,1)
INSERTINTO common_Area VALUES(326,'漳州市',14,0,2,6,1)
INSERTINTO common_Area VALUES(327,'南平市',14,0,2,7,1)
INSERTINTO common_Area VALUES(328,'龙岩市',14,0,2,8,1)
INSERTINTO common_Area VALUES(329,'宁德市',14,0,2,9,1)
UPDATE common_Area SET ChildAmount = 9 WHERE AreaID = 14
--15江西省(2006年全省辖:11个地级市;19个市辖区、10个县级市、70个县。,1)
INSERTINTO common_Area VALUES(341,'南昌市',15,0,2,1,1)
INSERTINTO common_Area VALUES(342,'景德镇市',15,0,2,2,1)
INSERTINTO common_Area VALUES(343,'萍乡市',15,0,2,3,1)
INSERTINTO common_Area VALUES(344,'九江市',15,0,2,4,1)
INSERTINTO common_Area VALUES(345,'新余市',15,0,2,5,1)
INSERTINTO common_Area VALUES(346,'鹰潭市',15,0,2,6,1)
INSERTINTO common_Area VALUES(347,'赣州市',15,0,2,7,1)
INSERTINTO common_Area VALUES(348,'吉安市',15,0,2,8,1)
INSERTINTO common_Area VALUES(349,'宜春市',15,0,2,9,1)
INSERTINTO common_Area VALUES(350,'抚州市',15,0,2,10,1)
INSERTINTO common_Area VALUES(351,'上饶市',15,0,2,11,1)
UPDATE common_Area SET ChildAmount = 11 WHERE AreaID = 15
--16山东省(2005年,辖:17个地级市;49个市辖区、31个县级市、60个县。,1)
INSERTINTO common_Area VALUES(361,'济南市',16,0,2,1,1)
INSERTINTO common_Area VALUES(362,'青岛市',16,0,2,2,1)
INSERTINTO common_Area VALUES(363,'淄博市',16,0,2,3,1)
INSERTINTO common_Area VALUES(364,'枣庄市',16,0,2,4,1)
INSERTINTO common_Area VALUES(365,'东营市',16,0,2,5,1)
INSERTINTO common_Area VALUES(366,'烟台市',16,0,2,6,1)
INSERTINTO common_Area VALUES(367,'潍坊市',16,0,2,7,1)
INSERTINTO common_Area VALUES(368,'济宁市',16,0,2,8,1)
INSERTINTO common_Area VALUES(369,'泰安市',16,0,2,9,1)
INSERTINTO common_Area VALUES(370,'威海市',16,0,2,10,1)
INSERTINTO common_Area VALUES(371,'日照市',16,0,2,11,1)
INSERTINTO common_Area VALUES(372,'莱芜市',16,0,2,12,1)
INSERTINTO common_Area VALUES(373,'临沂市',16,0,2,13,1)
INSERTINTO common_Area VALUES(374,'德州市',16,0,2,14,1)
INSERTINTO common_Area VALUES(375,'聊城市',16,0,2,15,1)
INSERTINTO common_Area VALUES(376,'滨州市',16,0,2,16,1)
INSERTINTO common_Area VALUES(377,'菏泽市',16,0,2,17,1)
UPDATE common_Area SET ChildAmount = 17 WHERE AreaID = 16
--17河南省(2005年辖:17个地级市;50个市辖区、21个县级市、88个县。)
INSERTINTO common_Area VALUES(401,'郑州市',17,0,2,1,1)
INSERTINTO common_Area VALUES(402,'开封市',17,0,2,2,1)
INSERTINTO common_Area VALUES(403,'洛阳市',17,0,2,3,1)
INSERTINTO common_Area VALUES(404,'平顶山市',17,0,2,4,1)
INSERTINTO common_Area VALUES(405,'安阳市',17,0,2,5,1)
INSERTINTO common_Area VALUES(406,'鹤壁市',17,0,2,6,1)
INSERTINTO common_Area VALUES(407,'新乡市',17,0,2,7,1)
INSERTINTO common_Area VALUES(408,'焦作市',17,0,2,8,1)
INSERTINTO common_Area VALUES(409,'濮阳市',17,0,2,9,1)
INSERTINTO common_Area VALUES(410,'许昌市',17,0,2,10,1)
INSERTINTO common_Area VALUES(411,'漯河市',17,0,2,11,1)
INSERTINTO common_Area VALUES(412,'三门峡市',17,0,2,12,1)
INSERTINTO common_Area VALUES(413,'南阳市',17,0,2,13,1)
INSERTINTO common_Area VALUES(414,'商丘市',17,0,2,14,1)
INSERTINTO common_Area VALUES(415,'信阳市',17,0,2,15,1)
INSERTINTO common_Area VALUES(416,'周口市',17,0,2,16,1)
INSERTINTO common_Area VALUES(417,'驻马店市',17,0,2,17,1)
INSERTINTO common_Area VALUES(418,'济源市',17,0,2,18,1)
UPDATE common_Area SET ChildAmount = 18 WHERE AreaID = 17
--18湖北省(截至2005年12月31日,全省辖13个地级单位(12个地级市、1个自治州);102县级单位(38个市辖区、24个县级市、37个县、2个自治县、1个林区),共有1220个乡级单位(277个街道、733个镇、210个乡)。)
INSERTINTO common_Area VALUES(421,'武汉市',18,0,2,1,1)
INSERTINTO common_Area VALUES(422,'黄石市',18,0,2,2,1)
INSERTINTO common_Area VALUES(423,'十堰市',18,0,2,3,1)
INSERTINTO common_Area VALUES(424,'荆州市',18,0,2,4,1)
INSERTINTO common_Area VALUES(425,'宜昌市',18,0,2,5,1)
INSERTINTO common_Area VALUES(426,'襄樊市',18,0,2,6,1)
INSERTINTO common_Area VALUES(427,'鄂州市',18,0,2,7,1)
INSERTINTO common_Area VALUES(428,'荆门市',18,0,2,8,1)
INSERTINTO common_Area VALUES(429,'孝感市',18,0,2,9,1)
INSERTINTO common_Area VALUES(430,'黄冈市',18,0,2,10,1)
INSERTINTO common_Area VALUES(431,'咸宁市',18,0,2,11,1)
INSERTINTO common_Area VALUES(432,'随州市',18,0,2,12,1)
INSERTINTO common_Area VALUES(433,'仙桃市',18,0,2,13,1)
INSERTINTO common_Area VALUES(434,'天门市',18,0,2,14,1)
INSERTINTO common_Area VALUES(435,'潜江市',18,0,2,15,1)
INSERTINTO common_Area VALUES(436,'神农架林区',18,0,2,16,1)
INSERTINTO common_Area VALUES(437,'恩施土家族苗族自治州',18,0,2,17,1)
UPDATE common_Area SET ChildAmount = 17 WHERE AreaID = 18
--19湖南省(2005年辖:13个地级市、1个自治州;34个市辖区、16个县级市、65个县、7个自治县。)
INSERTINTO common_Area VALUES(441,'长沙市',19,0,2,1,1)
INSERTINTO common_Area VALUES(442,'株洲市',19,0,2,2,1)
INSERTINTO common_Area VALUES(443,'湘潭市',19,0,2,3,1)
INSERTINTO common_Area VALUES(444,'衡阳市',19,0,2,4,1)
INSERTINTO common_Area VALUES(445,'邵阳市',19,0,2,5,1)
INSERTINTO common_Area VALUES(446,'岳阳市',19,0,2,6,1)
INSERTINTO common_Area VALUES(447,'常德市',19,0,2,7,1)
INSERTINTO common_Area VALUES(448,'张家界市',19,0,2,8,1)
INSERTINTO common_Area VALUES(449,'益阳市',19,0,2,9,1)
INSERTINTO common_Area VALUES(450,'郴州市',19,0,2,10,1)
INSERTINTO common_Area VALUES(451,'永州市',19,0,2,11,1)
INSERTINTO common_Area VALUES(452,'怀化市',19,0,2,12,1)
INSERTINTO common_Area VALUES(453,'娄底市',19,0,2,13,1)
INSERTINTO common_Area VALUES(454,'湘西土家族苗族自治州',19,0,2,14,1)
UPDATE common_Area SET ChildAmount = 14 WHERE AreaID = 19
--20广东省(截至2005年12月31日,广东省辖:21个地级市,54个市辖区、23个县级市、41个县、3个自治县,429个街道办事处、1145个镇、4个乡、7个民族乡。)
INSERTINTO common_Area VALUES(455,'广州市',20,0,2,1,1)
INSERTINTO common_Area VALUES(456,'深圳市',20,0,2,2,1)
INSERTINTO common_Area VALUES(457,'珠海市',20,0,2,3,1)
INSERTINTO common_Area VALUES(458,'汕头市',20,0,2,4,1)
INSERTINTO common_Area VALUES(459,'韶关市',20,0,2,5,1)
INSERTINTO common_Area VALUES(460,'佛山市',20,0,2,6,1)
INSERTINTO common_Area VALUES(461,'江门市',20,0,2,7,1)
INSERTINTO common_Area VALUES(462,'湛江市',20,0,2,8,1)
INSERTINTO common_Area VALUES(463,'茂名市',20,0,2,9,1)
INSERTINTO common_Area VALUES(464,'肇庆市',20,0,2,10,1)
INSERTINTO common_Area VALUES(465,'惠州市',20,0,2,11,1)
INSERTINTO common_Area VALUES(466,'梅州市',20,0,2,12,1)
INSERTINTO common_Area VALUES(467,'汕尾市',20,0,2,13,1)
INSERTINTO common_Area VALUES(468,'河源市',20,0,2,14,1)
INSERTINTO common_Area VALUES(469,'阳江市',20,0,2,15,1)
INSERTINTO common_Area VALUES(470,'清远市',20,0,2,16,1)
INSERTINTO common_Area VALUES(485,'东莞市',20,0,2,17,1)
INSERTINTO common_Area VALUES(486,'中山市',20,0,2,18,1)
INSERTINTO common_Area VALUES(487,'潮州市',20,0,2,19,1)
INSERTINTO common_Area VALUES(488,'揭阳市',20,0,2,20,1)
INSERTINTO common_Area VALUES(489,'云浮市',20,0,2,21,1)
UPDATE common_Area SET ChildAmount = 21 WHERE AreaID = 20
--21甘肃省(2006年辖:12个地级市、2个自治州;17个市辖区、4个县级市、58个县、7个自治县。)
INSERTINTO common_Area VALUES(471,'兰州市',21,0,2,1,1)
INSERTINTO common_Area VALUES(472,'金昌市',21,0,2,2,1)
INSERTINTO common_Area VALUES(473,'白银市',21,0,2,3,1)
INSERTINTO common_Area VALUES(474,'天水市',21,0,2,4,1)
INSERTINTO common_Area VALUES(475,'嘉峪关市',21,0,2,5,1)
INSERTINTO common_Area VALUES(476,'武威市',21,0,2,6,1)
INSERTINTO common_Area VALUES(477,'张掖市',21,0,2,7,1)
INSERTINTO common_Area VALUES(478,'平凉市',21,0,2,8,1)
INSERTINTO common_Area VALUES(479,'酒泉市',21,0,2,9,1)
INSERTINTO common_Area VALUES(480,'庆阳市',21,0,2,10,1)
INSERTINTO common_Area VALUES(481,'定西市',21,0,2,11,1)
INSERTINTO common_Area VALUES(482,'陇南市',21,0,2,12,1)
INSERTINTO common_Area VALUES(483,'临夏回族自治州',21,0,2,13,1)
INSERTINTO common_Area VALUES(484,'甘南藏族自治州',21,0,2,14,1)
UPDATE common_Area SET ChildAmount = 14 WHERE AreaID = 21
--22四川省(2006年辖:18个地级市、3个自治州;43个市辖区、14个县级市、120个县、4个自治县。)
INSERTINTO common_Area VALUES(491,'成都市',22,0,2,1,1)
INSERTINTO common_Area VALUES(492,'自贡市',22,0,2,2,1)
INSERTINTO common_Area VALUES(493,'攀枝花市',22,0,2,3,1)
INSERTINTO common_Area VALUES(494,'泸州市',22,0,2,4,1)
INSERTINTO common_Area VALUES(495,'德阳市',22,0,2,5,1)
INSERTINTO common_Area VALUES(496,'绵阳市',22,0,2,6,1)
INSERTINTO common_Area VALUES(497,'广元市',22,0,2,7,1)
INSERTINTO common_Area VALUES(498,'遂宁市',22,0,2,8,1)
INSERTINTO common_Area VALUES(499,'内江市',22,0,2,9,1)
INSERTINTO common_Area VALUES(500,'乐山市',22,0,2,10,1)
INSERTINTO common_Area VALUES(501,'南充市',22,0,2,11,1)
INSERTINTO common_Area VALUES(502,'眉山市',22,0,2,12,1)
INSERTINTO common_Area VALUES(503,'宜宾市',22,0,2,13,1)
INSERTINTO common_Area VALUES(504,'广安市',22,0,2,14,1)
INSERTINTO common_Area VALUES(505,'达州市',22,0,2,15,1)
INSERTINTO common_Area VALUES(506,'雅安市',22,0,2,16,1)
INSERTINTO common_Area VALUES(507,'巴中市',22,0,2,17,1)
INSERTINTO common_Area VALUES(508,'资阳市',22,0,2,18,1)
INSERTINTO common_Area VALUES(509,'阿坝藏族羌族自治州',22,0,2,19,1)
INSERTINTO common_Area VALUES(510,'甘孜藏族自治州',22,0,2,20,1)
INSERTINTO common_Area VALUES(511,'凉山彝族自治州',22,0,2,21,1)
UPDATE common_Area SET ChildAmount = 21 WHERE AreaID = 22
--23贵州省(2006年辖:4个地级市、2个地区、3个自治州;10个市辖区、9个县级市、56个县、11个自治县、2个特区。,1)
INSERTINTO common_Area VALUES(521,'贵阳市',23,0,2,1,1)
INSERTINTO common_Area VALUES(522,'六盘水市',23,0,2,2,1)
INSERTINTO common_Area VALUES(523,'遵义市',23,0,2,3,1)
INSERTINTO common_Area VALUES(524,'安顺市',23,0,2,4,1)
INSERTINTO common_Area VALUES(525,'铜仁地区',23,0,2,5,1)
INSERTINTO common_Area VALUES(526,'毕节地区',23,0,2,6,1)
INSERTINTO common_Area VALUES(527,'黔西南布依族苗族自治州',23,0,2,7,1)
INSERTINTO common_Area VALUES(528,'黔东南苗族侗族自治州',23,0,2,8,1)
INSERTINTO common_Area VALUES(529,'黔南布依族苗族自治州',23,0,2,9,1)
UPDATE common_Area SET ChildAmount = 9 WHERE AreaID = 23
--24海南省(2003-2005年 全省有2个地级市,6个县级市,4个县,6个民族自治县,4个市辖区,1个办事处(西南中沙群岛办事处,县级)。,1)
INSERTINTO common_Area VALUES(541,'海口市',24,0,2,1,1)
INSERTINTO common_Area VALUES(542,'三亚市',24,0,2,2,1)
INSERTINTO common_Area VALUES(543,'五指山市',24,0,2,3,1)
INSERTINTO common_Area VALUES(544,'琼海市',24,0,2,4,1)
INSERTINTO common_Area VALUES(545,'儋州市',24,0,2,5,1)
INSERTINTO common_Area VALUES(546,'文昌市',24,0,2,6,1)
INSERTINTO common_Area VALUES(547,'万宁市',24,0,2,7,1)
INSERTINTO common_Area VALUES(548,'东方市',24,0,2,8,1)
INSERTINTO common_Area VALUES(549,'澄迈县',24,0,2,9,1)
INSERTINTO common_Area VALUES(550,'定安县',24,0,2,10,1)
INSERTINTO common_Area VALUES(551,'屯昌县',24,0,2,11,1)
INSERTINTO common_Area VALUES(552,'临高县',24,0,2,12,1)
INSERTINTO common_Area VALUES(553,'白沙黎族自治县',24,0,2,13,1)
INSERTINTO common_Area VALUES(554,'昌江黎族自治县',24,0,2,14,1)
INSERTINTO common_Area VALUES(555,'乐东黎族自治县',24,0,2,15,1)
INSERTINTO common_Area VALUES(556,'陵水黎族自治县',24,0,2,16,1)
INSERTINTO common_Area VALUES(557,'保亭黎族苗族自治县',24,0,2,17,1)
INSERTINTO common_Area VALUES(558,'琼中黎族苗族自治县',24,0,2,18,1)
UPDATE common_Area SET ChildAmount = 18 WHERE AreaID = 24
--25云南省(2006年辖:8个地级市、8个自治州;12个市辖区、9个县级市、79个县、29个自治县。,1)
INSERTINTO common_Area VALUES(571,'昆明市',25,0,2,1,1)
INSERTINTO common_Area VALUES(572,'曲靖市',25,0,2,2,1)
INSERTINTO common_Area VALUES(573,'玉溪市',25,0,2,3,1)
INSERTINTO common_Area VALUES(574,'保山市',25,0,2,4,1)
INSERTINTO common_Area VALUES(575,'昭通市',25,0,2,5,1)
INSERTINTO common_Area VALUES(576,'丽江市',25,0,2,6,1)
INSERTINTO common_Area VALUES(577,'思茅市',25,0,2,7,1)
INSERTINTO common_Area VALUES(578,'临沧市',25,0,2,8,1)
INSERTINTO common_Area VALUES(579,'文山壮族苗族自治州',25,0,2,9,1)
INSERTINTO common_Area VALUES(580,'红河哈尼族彝族自治州',25,0,2,10,1)
INSERTINTO common_Area VALUES(581,'西双版纳傣族自治州',25,0,2,11,1)
INSERTINTO common_Area VALUES(582,'楚雄彝族自治州',25,0,2,12,1)
INSERTINTO common_Area VALUES(583,'大理白族自治州',25,0,2,13,1)
INSERTINTO common_Area VALUES(584,'德宏傣族景颇族自治州',25,0,2,14,1)
INSERTINTO common_Area VALUES(585,'怒江傈傈族自治州',25,0,2,15,1)
INSERTINTO common_Area VALUES(586,'迪庆藏族自治州',25,0,2,16,1)
UPDATE common_Area SET ChildAmount = 16 WHERE AreaID = 25
--26青海省(2006年辖:1个地级市、1个地区、6个自治州;4个市辖区、2个县级市、30个县、7个自治县。,1)
INSERTINTO common_Area VALUES(601,'西宁市',26,0,2,1,1)
INSERTINTO common_Area VALUES(602,'海东地区',26,0,2,2,1)
INSERTINTO common_Area VALUES(603,'海北藏族自治州',26,0,2,3,1)
INSERTINTO common_Area VALUES(604,'黄南藏族自治州',26,0,2,4,1)
INSERTINTO common_Area VALUES(605,'海南藏族自治州',26,0,2,5,1)
INSERTINTO common_Area VALUES(606,'果洛藏族自治州',26,0,2,6,1)
INSERTINTO common_Area VALUES(607,'玉树藏族自治州',26,0,2,7,1)
INSERTINTO common_Area VALUES(608,'海西蒙古族藏族自治州',26,0,2,8,1)
UPDATE common_Area SET ChildAmount = 8 WHERE AreaID = 26
--27陕西省(2006年辖:10个地级市;24个市辖区、3个县级市、80个县。,1)
INSERTINTO common_Area VALUES(621,'西安市',27,0,2,1,1)
INSERTINTO common_Area VALUES(622,'铜川市',27,0,2,2,1)
INSERTINTO common_Area VALUES(623,'宝鸡市',27,0,2,3,1)
INSERTINTO common_Area VALUES(624,'咸阳市',27,0,2,4,1)
INSERTINTO common_Area VALUES(625,'渭南市',27,0,2,5,1)
INSERTINTO common_Area VALUES(626,'延安市',27,0,2,6,1)
INSERTINTO common_Area VALUES(627,'汉中市',27,0,2,7,1)
INSERTINTO common_Area VALUES(628,'榆林市',27,0,2,8,1)
INSERTINTO common_Area VALUES(629,'安康市',27,0,2,9,1)
INSERTINTO common_Area VALUES(630,'商洛市',27,0,2,10,1)
UPDATE common_Area SET ChildAmount = 10 WHERE AreaID = 27
--28广西壮族自治区(2005年辖:14个地级市;34个市辖区、7个县级市、56个县、12个自治县。,1)
INSERTINTO common_Area VALUES(641,'南宁市',28,0,2,1,1)
INSERTINTO common_Area VALUES(642,'柳州市',28,0,2,2,1)
INSERTINTO common_Area VALUES(643,'桂林市',28,0,2,3,1)
INSERTINTO common_Area VALUES(644,'梧州市',28,0,2,4,1)
INSERTINTO common_Area VALUES(645,'北海市',28,0,2,5,1)
INSERTINTO common_Area VALUES(646,'防城港市',28,0,2,6,1)
INSERTINTO common_Area VALUES(647,'钦州市',28,0,2,7,1)
INSERTINTO common_Area VALUES(648,'贵港市',28,0,2,8,1)
INSERTINTO common_Area VALUES(649,'玉林市',28,0,2,9,1)
INSERTINTO common_Area VALUES(650,'百色市',28,0,2,10,1)
INSERTINTO common_Area VALUES(651,'贺州市',28,0,2,11,1)
INSERTINTO common_Area VALUES(652,'河池市',28,0,2,12,1)
INSERTINTO common_Area VALUES(653,'来宾市',28,0,2,13,1)
INSERTINTO common_Area VALUES(654,'崇左市',28,0,2,14,1)
UPDATE common_Area SET ChildAmount = 14 WHERE AreaID = 28
--29西藏自治区(2005年辖:1个地级市、6个地区;1个市辖区、1个县级市、71个县。,1)
INSERTINTO common_Area VALUES(671,'拉萨市',29,0,2,1,1)
INSERTINTO common_Area VALUES(672,'那曲地区',29,0,2,2,1)
INSERTINTO common_Area VALUES(673,'昌都地区',29,0,2,3,1)
INSERTINTO common_Area VALUES(674,'山南地区',29,0,2,4,1)
INSERTINTO common_Area VALUES(675,'日喀则地区',29,0,2,5,1)
INSERTINTO common_Area VALUES(676,'阿里地区',29,0,2,6,1)
INSERTINTO common_Area VALUES(677,'林芝地区',29,0,2,7,1)
UPDATE common_Area SET ChildAmount = 7 WHERE AreaID = 29
--30宁夏回族自治区
INSERTINTO common_Area VALUES(681,'银川市',30,0,2,1,1)
INSERTINTO common_Area VALUES(682,'石嘴山市',30,0,2,2,1)
INSERTINTO common_Area VALUES(683,'吴忠市',30,0,2,3,1)
INSERTINTO common_Area VALUES(684,'固原市',30,0,2,4,1)
INSERTINTO common_Area VALUES(685,'中卫市',30,0,2,5,1)
UPDATE common_Area SET ChildAmount = 5 WHERE AreaID = 30
--31新疆维吾尔自治区(2005年辖:2个地级市、7个地区、5个自治州;11个市辖区、20个县级市、62个县、6个自治县,1)
INSERTINTO common_Area VALUES(691,'乌鲁木齐市',31,0,2,1,1)
INSERTINTO common_Area VALUES(692,'克拉玛依市',31,0,2,2,1)
INSERTINTO common_Area VALUES(693,'石河子市 ',31,0,2,3,1)
INSERTINTO common_Area VALUES(694,'阿拉尔市',31,0,2,4,1)
INSERTINTO common_Area VALUES(695,'图木舒克市',31,0,2,5,1)
INSERTINTO common_Area VALUES(696,'五家渠市',31,0,2,6,1)
INSERTINTO common_Area VALUES(697,'吐鲁番市',31,0,2,7,1)
INSERTINTO common_Area VALUES(698,'阿克苏市',31,0,2,8,1)
INSERTINTO common_Area VALUES(699,'喀什市',31,0,2,9,1)
INSERTINTO common_Area VALUES(700,'哈密市',31,0,2,10,1)
INSERTINTO common_Area VALUES(701,'和田市',31,0,2,11,1)
INSERTINTO common_Area VALUES(702,'阿图什市',31,0,2,12,1)
INSERTINTO common_Area VALUES(703,'库尔勒市',31,0,2,13,1)
INSERTINTO common_Area VALUES(704,'昌吉市 ',31,0,2,14,1)
INSERTINTO common_Area VALUES(705,'阜康市',31,0,2,15,1)
INSERTINTO common_Area VALUES(706,'米泉市',31,0,2,16,1)
INSERTINTO common_Area VALUES(707,'博乐市',31,0,2,17,1)
INSERTINTO common_Area VALUES(708,'伊宁市',31,0,2,18,1)
INSERTINTO common_Area VALUES(709,'奎屯市',31,0,2,19,1)
INSERTINTO common_Area VALUES(710,'塔城市',31,0,2,20,1)
INSERTINTO common_Area VALUES(711,'乌苏市',31,0,2,21,1)
INSERTINTO common_Area VALUES(712,'阿勒泰市',31,0,2,22,1)
UPDATE common_Area SET ChildAmount = 22 WHERE AreaID = 31
--33内蒙古自治区(2006年,辖:9个地级市、3个盟;21个市辖区、11个县级市、17个县、49个旗、3个自治旗。,1)
INSERTINTO common_Area VALUES(721,'呼和浩特市',32,0,2,1,1)
INSERTINTO common_Area VALUES(722,'包头市',32,0,2,2,1)
INSERTINTO common_Area VALUES(723,'乌海市',32,0,2,3,1)
INSERTINTO common_Area VALUES(724,'赤峰市',32,0,2,4,1)
INSERTINTO common_Area VALUES(725,'通辽市',32,0,2,5,1)
INSERTINTO common_Area VALUES(726,'鄂尔多斯市',32,0,2,6,1)
INSERTINTO common_Area VALUES(727,'呼伦贝尔市',32,0,2,7,1)
INSERTINTO common_Area VALUES(728,'巴彦淖尔市',32,0,2,8,1)
INSERTINTO common_Area VALUES(729,'乌兰察布市',32,0,2,9,1)
INSERTINTO common_Area VALUES(730,'锡林郭勒盟',32,0,2,10,1)
INSERTINTO common_Area VALUES(731,'兴安盟',32,0,2,11,1)
INSERTINTO common_Area VALUES(732,'阿拉善盟',32,0,2,12,1)
UPDATE common_Area SET ChildAmount = 12 WHERE AreaID = 32
转载于:https://www.cnblogs.com/nianshi/archive/2008/01/14/1037770.html