中国行政区数据库 省市区

-- phpMyAdmin SQL Dump -- http://www.phpmyadmin.net -- -- 主机: localhost -- 生成日期: 2015 年 01 月 22 日 11:48 -- 服务器版本: 5.5.40 -- PHP 版本: 5.3.29 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 */; -- -- 表的结构 `nation` -- CREATE TABLE IF NOT EXISTS `nation` ( `id` int(11) NOT NULL AUTO_INCREMENT, `code` varchar(40) NOT NULL, `province` varchar(40) NOT NULL, `city` varchar(40) NOT NULL, `district` varchar(40) NOT NULL, `parent` varchar(40) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3924 ; -- -- 转存表中的数据 `nation` -- INSERT INTO `nation` (`id`, `code`, `province`, `city`, `district`, `parent`) VALUES (1, '000000', '中华人民共和国', '', '', '0'), (2, '110000', '北京市', '北京市', '', '1'), (3, '110101', '', '', '东城区', '2'), (4, '110102', '', '', '西城区', '2'), (5, '110105', '', '', '朝阳区', '2'), (6, '110106', '', '', '丰台区', '2'), (7, '110107', '', '', '石景山区', '2'), (8, '110108', '', '', '海淀区', '2'), (9, '110109', '', '', '门头沟区', '2'), (10, '110111', '', '', '房山区', '2'), (11, '110112', '', '', '通州区', '2'), (12, '110113', '', '', '顺义区', '2'), (13, '110114', '', '', '昌平区', '2'), (14, '110115', '', '', '大兴区', '2'), (15, '110116', '', '', '怀柔区', '2'), (16, '110117', '', '', '平谷区', '2'), (17, '110228', '', '', '密云县', '2'), (18, '110229', '', '', '延庆县', '2'), (19, '120000', '天津市', '天津市', '', '1'), (20, '120101', '', '', '和平区', '19'), (21, '120102', '', '', '河东区', '19'), (22, '120103', '', '', '河西区', '19'), (23, '120104', '', '', '南开区', '19'), (24, '120105', '', '', '河北区', '19'), (25, '120106', '', '', '红桥区', '19'), (26, '120110', '', '', '东丽区', '19'), (27, '120111', '', '', '西青区', '19'), (28, '120112', '', '', '津南区', '19'), (29, '120113', '', '', '北辰区', '19'), (30, '120114', '', '', '武清区', '19'), (31, '120115', '', '', '宝坻区', '19'), (32, '120116', '', '', '滨海新区', '19'), (33, '120221', '', '', '宁河县', '19'), (34, '120223', '', '', '静海县', '19'), (35, '120225', '', '', '蓟县', '19'), (36, '130000', '河北省', '', '', '1'), (37, '130100', '', '石家庄市', '', '36'), (38, '130101', '', '', '市辖区', '37'), (39, '130102', '', '', '长安区', '37'), (40, '130104', '', '', '桥西区', '37'), (41, '130105', '', '', '新华区', '37'), (42, '130107', '', '', '井陉矿区', '37'), (43, '130108', '', '', '裕华区', '37'), (44, '130109', '', '', '藁城区', '37'), (45, '130110', '', '', '鹿泉区', '37'), (46, '130111', '', '', '栾城区', '37'), (47, '130121', '', '', '井陉县', '37'), (48, '130123', '', '', '正定县', '37'), (49, '130125', '', '', '行唐县', '37'), (50, '130126', '', '', '灵寿县', '37'), (51, '130127', '', '', '高邑县', '37'), (52, '130128', '', '', '深泽县', '37'), (53, '130129', '', '', '赞皇县', '37'), (54, '130130', '', '', '无极县', '37'), (55, '130131', '', '', '平山县', '37'), (56, '130132', '', '', '元氏县', '37'), (57, '130133', '', '', '赵县', '37'), (58, '130181', '', '', '辛集市', '37'), (59, '130183', '', '', '晋州市', '37'), (60, '130184', '', '', '新乐市', '37'), (61, '130200', '', '唐山市', '', '36'), (62, '130201', '', '', '市辖区', '61'), (63, '130202', '', '', '路南区', '61'), (64, '130203', '', '', '路北区', '61'), (65, '130204', '', '', '古冶区', '61'), (66, '130205', '', '', '开平区', '61'), (67, '130207', '', '', '丰南区', '61'), (68, '130208', '', '', '丰润区', '61'), (69, '130209', '', '', '曹妃甸区', '61'), (70, '130223', '', '', '滦县', '61'), (71, '130224', '', '', '滦南县', '61'), (72, '130225', '', '', '乐亭县', '61'), (73, '130227', '', '', '迁西县', '61'), (74, '130229', '', '', '玉田县', '61'), (75, '130281', '', '', '遵化市', '61'), (76, '130283', '', '', '迁安市', '61'), (77, '130300', '', '秦皇岛市', '', '36'), (78, '130301', '', '', '市辖区', '77'), (79, '130302', '', '', '海港区', '77'), (80, '130303', '', '', '山海关区', '77'), (81, '130304', '', '', '北戴河区', '77'), (82, '130321', '', '', '青龙满族自治县', '77'), (83, '130322', '', '', '昌黎县', '77'), (84, '130323', '', '', '抚宁县', '77'), (85, '130324', '', '', '卢龙县', '77'), (86, '130400', '', '邯郸市', '', '36'), (87, '130401', '', '', '市辖区', '86'), (88, '130402', '', '', '邯山区', '86'), (89, '130403', '', '', '丛台区', '86'), (90, '130404', '', '', '复兴区', '86'), (91, '130406', '', '', '峰峰矿区', '86'), (92, '130421', '', '', '邯郸县', '86'), (93, '130423', '', '', '临漳县', '86'), (94, '130424', '', '', '成安县', '86'), (95, '130425', '', '', '大名县', '86'), (96, '130426', '', '', '涉县', '86'), (97, '130427', '', '', '磁县', '86'), (98, '130428', '', '', '肥乡县', '86'), (99, '130429', '', '', '永年县', '86'), (100, '130430', '', '', '邱县', '86'), (101, '130431', '', '', '鸡泽县', '86'), (102, '130432', '', '', '广平县', '86'), (103, '130433', '', '', '馆陶县', '86'), (104, '130434', '', '', '魏县', '86'), (105, '130435', '', '', '曲周县', '86'), (106, '130481', '', '', '武安市', '86'), (107, '130500', '', '邢台市', '', '36'), (108, '130501', '', '', '市辖区', '107'), (109, '130502', '', '', '桥东区', '107'), (110, '130503', '', '', '桥西区', '107'), (111, '130521', '', '', '邢台县', '107'), (112, '130522', '', '', '临城县', '107'), (113, '130523', '', '', '内丘县', '107'), (114, '130524', '', '', '柏乡县', '107'), (115, '130525', '', '', '隆尧县', '107'), (116, '130526', '', '', '任县', '107'), (117, '130527', '', '', '南和县', '107'), (118, '130528', '', '', '宁晋县', '107'), (119, '130529', '', '', '巨鹿县', '107'), (120, '130530', '', '', '新河县', '107'), (121, '130531', '', '', '广宗县', '107'), (122, '130532', '', '', '平乡县', '107'), (123, '130533', '', '', '威县', '107'), (124, '130534', '', '', '清河县', '107'), (125, '130535', '', '', '临西县', '107'), (126, '130581', '', '', '南宫市', '107'), (127, '130582', '', '', '沙河市', '107'), (128, '130600', '', '保定市', '', '36'), (129, '130601', '', '', '市辖区', '128'), (130, '130602', '', '', '新市区', '128'), (131, '130603', '', '', '北市区', '128'), (132, '130604', '', '', '南市区', '128'), (133, '130621', '', '', '满城县', '128'), (134, '130622', '', '', '清苑县', '128'), (135, '130623', '', '', '涞水县', '128'), (136, '130624', '', '', '阜平县', '128'), (137, '130625', '', '', '徐水县', '128'), (138, '130626', '', '', '定兴县', '128'), (139, '130627', '', '', '唐县', '128'), (140, '130628', '', '', '高阳县', '128'), (141, '130629', '', '', '容城县', '128'), (142, '130630', '', '', '涞源县', '128'), (143, '130631', '', '', '望都县', '128'), (144, '130632', '', '', '安新县', '128'), (145, '130633', '', '', '易县', '128'), (146, '130634', '', '', '曲阳县', '128'), (147, '130635', '', '', '蠡县', '128'), (148, '130636', '', '', '顺平县', '128'), (149, '130637', '', '', '博野县', '128'), (150, '130638', '', '', '雄县', '128'), (151, '130681', '', '', '涿州市', '128'), (152, '130682', '', '', '定州市', '128'), (153, '130683', '', '', '安国市', '128'), (154, '130684', '', '', '高碑店市', '128'), (155, '130700', '', '张家口市', '', '36'), (156, '130701', '', '', '市辖区', '155'), (157, '130702', '', '', '桥东区', '155'), (158, '130703', '', '', '桥西区', '155'), (159, '130705', '', '', '宣化区', '155'), (160, '130706', '', '', '下花园区', '155'), (161, '130721', '', '', '宣化县', '155'),