世界行政区域，全国省市区镇 数据 sql文件

-- phpMyAdmin SQL Dump -- version 3.4.5 -- http://www.phpmyadmin.net -- -- 主机: localhost -- 生成日期: 2013 年 04 月 02 日 01:55 -- 服务器版本: 5.0.45 -- PHP 版本: 5.2.5 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- 数据库: `yxss` -- -- -------------------------------------------------------- -- -- 表的结构 `china` -- CREATE TABLE IF NOT EXISTS `china` ( `id` int(10) unsigned NOT NULL auto_increment, `gid` int(10) unsigned default '0', `zid` int(10) unsigned default '0', `shengid` int(10) unsigned default '0', `shid` int(10) unsigned default '0', `quid` int(10) unsigned default '0', `ming` varchar(50) default NULL, PRIMARY KEY (`id`), KEY `shengid` (`shengid`), KEY `zid` (`gid`,`zid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=48699 ; -- -- 转存表中的数据 `china` -- INSERT INTO `china` (`id`, `gid`, `zid`, `shengid`, `shid`, `quid`, `ming`) VALUES (1, 45055, 45048, 0, 0, 0, '北京'), (2, 45055, 45048, 0, 0, 0, '天津'), (3, 45055, 45048, 0, 0, 0, '河北'), (4, 45055, 45048, 0, 0, 0, '山西'), (5, 45055, 45048, 0, 0, 0, '内蒙古'), (6, 45055, 45049, 0, 0, 0, '辽宁'), (7, 45055, 45049, 0, 0, 0, '吉林'), (8, 45055, 45049, 0, 0, 0, '黑龙江'), (9, 45055, 45050, 0, 0, 0, '上海'), (10, 45055, 45050, 0, 0, 0, '江苏'), (11, 45055, 45050, 0, 0, 0, '浙江'), (12, 45055, 45050, 0, 0, 0, '安徽'), (13, 45055, 45050, 0, 0, 0, '福建'), (14, 45055, 45050, 0, 0, 0, '江西'), (15, 45055, 45050, 0, 0, 0, '山东'), (16, 45055, 45051, 0, 0, 0, '河南'), (17, 45055, 45051, 0, 0, 0, '湖北'), (18, 45055, 45051, 0, 0, 0, '湖南'), (19, 45055, 45052, 0, 0, 0, '广东'), (20, 45055, 45052, 0, 0, 0, '广西'), (21, 45055, 45052, 0, 0, 0, '海南'), (22, 45055, 45053, 0, 0, 0, '重庆'), (23, 45055, 45053, 0, 0, 0, '四川'), (24, 45055, 45053, 0, 0, 0, '贵州'), (25, 45055, 45053, 0, 0, 0, '云南'), (26, 45055, 45053, 0, 0, 0, '西藏'), (27, 45055, 45054, 0, 0, 0, '陕西'), (28, 45055, 45054, 0, 0, 0, '甘肃'), (29, 45055, 45054, 0, 0, 0, '青海'), (30, 45055, 45054, 0, 0, 0, '宁夏'), (31, 45055, 45054, 0, 0, 0, '新疆'), (32, 45055, 45052, 0, 0, 0, '香港'), (33, 45055, 45052, 0, 0, 0, '澳门'), (34, 45055, 45050, 0, 0, 0, '台湾'), (35, 45055, 45048, 1, 0, 0, '东城区'), (36, 45055, 45048, 1, 0, 0, '西城区'), (37, 45055, 45048, 1, 0, 0, '崇文区'), (38, 45055, 45048, 1, 0, 0, '宣武区'), (39, 45055, 45048, 1, 0, 0, '朝阳区'), (40, 45055, 45048, 1, 0, 0, '丰台区'), (41, 45055, 45048, 1, 0, 0, '石景山区'), (42, 45055, 45048, 1, 0, 0, '海淀区'), (43, 45055, 45048, 1, 0, 0, '门头沟区'), (44, 45055, 45048, 1, 0, 0, '房山区'), (45, 45055, 45048, 1, 0, 0, '通州区'), (46, 45055, 45048, 1, 0, 0, '顺义区'), (47, 45055, 45048, 1, 0, 0, '昌平区'), (48, 45055, 45048, 1, 0, 0, '大兴区'), (49, 45055, 45048, 1, 0, 0, '怀柔区'), (50, 45055, 45048, 1, 0, 0, '平谷区'), (51, 45055, 45048, 1, 0, 0, '密云县'), (52, 45055, 45048, 1, 0, 0, '延庆县'), (53, 45055, 45048, 1, 35, 0, '东华门'), (54, 45055, 45048, 1, 35, 0, '景山'), (55, 45055, 45048, 1, 35, 0, '交道口'), (56, 45055, 45048, 1, 35, 0, '安定门'), (57, 45055, 45048, 1, 35, 0, '北新桥'), (58, 45055, 45048, 1, 35, 0, '东四'), (59, 45055, 45048, 1, 35, 0, '朝阳门'), (60, 45055, 45048, 1, 35, 0, '建国门'), (61, 45055, 45048, 1, 35, 0, '东直门'), (62, 45055, 45048, 1, 35, 0, '和平里'), (63, 45055, 45048, 1, 36, 0, '西长安街'), (64, 45055, 45048, 1, 36, 0, '新街口'), (65, 45055, 45048, 1, 36, 0, '月坛'), (66, 45055, 45048, 1, 36, 0, '展览路'), (67, 45055, 45048, 1, 36, 0, '德胜'), (68, 45055, 45048, 1, 36, 0, '金融街'), (69, 45055, 45048, 1, 36, 0, '什刹海'), (70, 45055, 45048, 1, 37, 0, '前门'), (71, 45055, 45048, 1, 37, 0, '崇文门外'), (72, 45055, 45048, 1, 37, 0, '东花'), (73, 45055, 45048, 1, 37, 0, '龙潭'), (74, 45055, 45048, 1, 37, 0, '体育馆路'), (75, 45055, 45048, 1, 37, 0, '天坛'), (76, 45055, 45048, 1, 37, 0, '永定门外'), (77, 45055, 45048, 1, 38, 0, '大栅栏'), (78, 45055, 45048, 1, 38, 0, '天桥'), (79, 45055, 45048, 1, 38, 0, '椿树'), (80, 45055, 45048, 1, 38, 0, '陶然亭'), (81, 45055, 45048, 1, 38, 0, '广安门内'), (82, 45055, 45048, 1, 38, 0, '牛街'), (83, 45055, 45048, 1, 38, 0, '白纸坊'), (84, 45055, 45048, 1, 38, 0, '广安门外'), (85, 45055, 45048, 1, 39, 0, '建国门外'), (86, 45055, 45048, 1, 39, 0, '朝阳门外'), (87, 45055, 45048, 1, 39, 0, '呼家楼'), (88, 45055, 45048, 1, 39, 0, '三里屯'), (89, 45055, 45048, 1, 39, 0, '左家庄'), (90, 45055, 45048, 1, 39, 0, '香河园'), (91, 45055, 45048, 1, 39, 0, '和平街'), (92, 45055, 45048, 1, 39, 0, '安贞'), (93, 45055, 45048, 1, 39, 0, '亚运村'), (94, 45055, 45048, 1, 39, 0, '小关'), (95, 45055, 45048, 1, 39, 0, '酒仙桥'), (96, 45055, 45048, 1, 39, 0, '麦子店'), (97, 45055, 45048, 1, 39, 0, '团结湖'), (98, 45055, 45048, 1, 39, 0, '六里屯'), (99, 45055, 45048, 1, 39, 0, '八里庄'), (100, 45055, 45048, 1, 39, 0, '双井'), (101, 45055, 45048, 1, 39, 0, '劲松'), (102, 45055, 45048, 1, 39, 0, '潘家园'), (103, 45055, 45048, 1, 39, 0, '垡头'), (104, 45055, 45048, 1, 39, 0, '南磨房'), (105, 45055, 45048, 1, 39, 0, '高碑店'), (106, 45055, 45048, 1, 39, 0, '将台'), (107, 45055, 45048, 1, 39, 0, '太阳宫'), (108, 45055, 45048, 1, 39, 0, '大屯'), (109, 45055, 45048, 1, 39, 0, '望京'), (110, 45055, 45048, 1, 39, 0, '小红门'), (111, 45055, 45048, 1, 39, 0, '十八里店'), (112, 45055, 45048, 1, 39, 0, '平房'), (113, 45055, 45048, 1, 39, 0, '东风'), (114, 45055, 45048, 1, 39, 0, '奥运村'), (115, 45055, 45048, 1, 39, 0, '来广营'), (116, 45055, 45048, 1, 39, 0, '常营回族'), (117, 45055, 45048, 1, 39, 0, '三间房'), (118, 45055, 45048, 1, 39, 0, '管庄'), (119, 45055, 45048, 1, 39, 0, '金盏'), (120, 45055, 45048, 1, 39, 0, '孙河'), (121, 45055, 45048, 1, 39, 0, '崔各庄'), (122, 45055, 45048, 1, 39, 0, '东坝'), (123, 45055, 45048, 1, 39, 0, '黑庄户'), (124, 45055, 45048, 1, 39, 0, '豆各庄'), (125, 45055, 45048, 1, 39, 0, '王四营'), (126, 45055, 45048, 1, 39, 0, '首都机场'), (127, 45055, 45048, 1, 39, 0, '望京开发'), (128, 45055, 45048, 1, 40, 0, '右安门'), (129, 45055, 45048, 1, 40, 0, '太平桥'), (130, 45055, 45048, 1, 40, 0, '西罗园'), (131, 45055, 45048, 1, 40, 0, '大红门'), (132, 45055, 45048, 1, 40, 0, '南苑'), (133, 45055, 45048, 1, 40, 0, '东高地'), (134, 45055, 45048, 1, 40, 0, '东铁匠营'), (135, 45055, 45048, 1, 40, 0, '卢沟桥'), (136, 45055, 45048, 1, 40, 0, '丰台'), (137, 45055, 45048, 1, 40, 0, '新村'), (138, 45055, 45048, 1, 40, 0, '长辛店'), (139, 45055, 45048, 1, 40, 0, '云岗'), (140, 45055, 45048, 1, 40, 0, '方庄'), (141, 45055, 45048, 1, 40, 0, '宛平城'), (142, 45055, 45048, 1, 40, 0, '马家堡'), (143, 45055, 45048, 1, 40, 0, '和义'), (144, 45055, 45048, 1, 40, 0, '长辛店镇'), (145, 45055, 45048, 1, 40, 0, '王佐镇'), (146, 45055, 45048, 1, 40, 0, '卢沟桥乡'), (147, 45055, 45048, 1, 40, 0, '花乡乡'), (148, 45055, 45048, 1, 40, 0, '南苑乡'), (149, 45055, 45048, 1, 41, 0, '八宝山'), (150, 45055, 45048, 1, 41, 0, '老山'), (151, 45055, 45048, 1, 41, 0, '八角'), (152, 45055, 45048, 1, 41, 0, '古城'), (153, 45055, 45048, 1, 41, 0, '苹果园'), (154, 45055, 45048, 1, 41, 0, '金顶街'), (155, 45055, 45048, 1, 41, 0, '北辛安'), (156, 45055, 45048, 1, 41, 0, '广宁'), (157, 45055, 45048, 1, 41, 0, '五里坨'), (158, 45055, 45048, 1, 41, 0, '鲁谷'), (159, 45055, 45048, 1, 42, 0, '万寿路'), (160, 45055, 45048, 1, 42, 0, '永定路'), (161, 45055, 45048, 1, 42, 0, '羊坊店'), (162, 45055, 45048, 1, 42, 0, '甘家口'), (16