--
-- 表的结构 `area`
--
DROP TABLE IF EXISTS `area`;
CREATE TABLE IF NOT EXISTS `area` (
`id` int(11) NOT NULL auto_increment,
`areaid` int(11) NOT NULL,
`area` varchar(20) character set gbk NOT NULL,
`fatherid` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312 AUTO_INCREMENT=3145 ;
--
-- 导出表中的数据 `area`
--
INSERT INTO `area` (`id`, `areaid`, `area`, `fatherid`) VALUES
(1, 110101, '东城区', 110100),
(2, 110102, '西城区', 110100),
(3, 110103, '崇文区', 110100),
(4, 110104, '宣武区', 110100),
(5, 110105, '朝阳区', 110100),
(6, 110106, '丰台区', 110100),
(7, 110107, '石景山区', 110100),
(8, 110108, '海淀区', 110100),
(9, 110109, '门头沟区', 110100),
(10, 110111, '房山区', 110100),
(11, 110112, '通州区', 110100),
(12, 110113, '顺义区', 110100),
(13, 110114, '昌平区', 110100),
(14, 110115, '大兴区', 110100),
(15, 110116, '怀柔区', 110100),
(16, 110117, '平谷区', 110100),
(17, 110228, '密云县', 110200),
(18, 110229, '延庆县', 110200),
(19, 120101, '和平区', 120100),
(20, 120102, '河东区', 120100),
(21, 120103, '河西区', 120100),
(22, 120104, '南开区', 120100),
(23, 120105, '河北区', 120100),
(24, 120106, '红桥区', 120100),
(25, 120107, '塘沽区', 120100),
(26, 120108, '汉沽区', 120100),
(27, 120109, '大港区', 120100),
(28, 120110, '东丽区', 120100),
(29, 120111, '西青区', 120100),
(30, 120112, '津南区', 120100),
(31, 120113, '北辰区', 120100),
(32, 120114, '武清区', 120100),
(33, 120115, '宝坻区', 120100),
(34, 120221, '宁河县', 120200),
(35, 120223, '静海县', 120200),
(36, 120225, '蓟 县', 120200),
(37, 130101, '市辖区', 130100),
(38, 130102, '长安区', 130100),
(39, 130103, '桥东区', 130100),
(40, 130104, '桥西区', 130100),
(41, 130105, '新华区', 130100),
(42, 130107, '井陉矿区', 130100),
(43, 130108, '裕华区', 130100),
(44, 130121, '井陉县', 130100),
(45, 130123, '正定县', 130100),
(46, 130124, '栾城县', 130100),
(47, 130125, '行唐县', 130100),
(48, 130126, '灵寿县', 130100),
(49, 130127, '高邑县', 130100),
(50, 130128, '深泽县', 130100),
(51, 130129, '赞皇县', 130100),
(52, 130130, '无极县', 130100),
(53, 130131, '平山县', 130100),
(54, 130132, '元氏县', 130100),
(55, 130133, '赵 县', 130100),
(56, 130181, '辛集市', 130100),
(57, 130182, '藁城市', 130100),
(58, 130183, '晋州市', 130100),
(59, 130184, '新乐市', 130100),
(60, 130185, '鹿泉市', 130100),
(61, 130201, '市辖区', 130200),
(62, 130202, '路南区', 130200),
(63, 130203, '路北区', 130200),
(64, 130204, '古冶区', 130200),
(65, 130205, '开平区', 130200),
(66, 130207, '丰南区', 130200),
(67, 130208, '丰润区', 130200),
(68, 130223, '滦 县', 130200),
(69, 130224, '滦南县', 130200),
(70, 130225, '乐亭县', 130200),
(71, 130227, '迁西县', 130200),
(72, 130229, '玉田县', 130200),
(73, 130230, '唐海县', 130200),
(74, 130281, '遵化市', 130200),
(75, 130283, '迁安市', 130200),
(76, 130301, '市辖区', 130300),
(77, 130302, '海港区', 130300),
(78, 130303, '山海关区', 130300),
(79, 130304, '北戴河区', 130300),
(80, 130321, '青龙满族自治县', 130300),
(81, 130322, '昌黎县', 130300),
(82, 130323, '抚宁县', 130300),
(83, 130324, '卢龙县', 130300),
(84, 130401, '市辖区', 130400),
(85, 130402, '邯山区', 130400),
(86, 130403, '丛台区', 130400),
(87, 130404, '复兴区', 130400),
(88, 130406, '峰峰矿区', 130400),
(89, 130421, '邯郸县', 130400),
(90, 130423, '临漳县', 130400),
(91, 130424, '成安县', 130400),
(92, 130425, '大名县', 130400),
(93, 130426, '涉 县', 130400),
(94, 130427, '磁 县', 130400),
(95, 130428, '肥乡县', 130400),
(96, 130429, '永年县', 130400),
(97, 130430, '邱 县', 130400),
(98, 130431, '鸡泽县', 130400),
(99, 130432, '广平县', 130400),
(100, 130433, '馆陶县', 130400),
(101, 130434, '魏 县', 130400),
(102, 130435, '曲周县', 130400),
(103, 130481, '武安市', 130400),
(104, 130501, '市辖区', 130500),
(105, 130502, '桥东区', 130500),
(106, 130503, '桥西区', 130500),
(107, 130521, '邢台县', 130500),
(108, 130522, '临城县', 130500),
(109, 130523, '内丘县', 130500),
(110, 130524, '柏乡县', 130500),
(111, 130525, '隆尧县', 130500),
(112, 130526, '任 县', 130500),
(113, 130527, '南和县', 130500),
(114, 130528, '宁晋县', 130500),
(115, 130529, '巨鹿县', 130500),
(116, 130530, '新河县', 130500),
(117, 130531, '广宗县', 130500),
(118, 130532, '平乡县', 130500),
(119, 130533, '威 县', 130500),
(120, 130534, '清河县', 130500),
(121, 130535, '临西县', 130500),
(122, 130581, '南宫市', 130500),
(123, 130582, '沙河市', 130500),
(124, 130601, '市辖区', 130600),
(125, 130602, '新市区', 130600),
(126, 130603, '北市区', 130600),
(127, 130604, '南市区', 130600),
(128, 130621, '满城县', 130600),
(129, 130622, '清苑县', 130600),
(130, 130623, '涞水县', 130600),
(131, 130624, '阜平县', 130600),
(132, 130625, '徐水县', 130600),
(133, 130626, '定兴县', 130600),
(134, 130627, '唐 县', 130600),
(135, 130628, '高阳县', 130600),
(136, 130629, '容城县', 130600),
(137, 130630, '涞源县', 130600),
(138, 130631, '望都县', 130600),
(139, 130632, '安新县', 130600),
(140, 130633, '易 县', 130600),
(141, 130634, '曲阳县', 130600),
(142, 130635, '蠡 县', 130600),
(143, 130636, '顺平县', 130600),
(144, 130637, '博野县', 130600),
(145, 130638, '雄 县', 130600),
(146, 130681, '涿州市', 130600),
(147, 130682, '定州市', 130600),
(148, 130683, '安国市', 130600),
(149, 130684, '高碑店市', 130600),
(150, 130701, '市辖区', 130700),
(151, 130702, '桥东区', 130700),
(152, 130703, '桥西区', 130700),
(153, 130705, '宣化区', 130700),
(154, 130706, '下花园区', 130700),
(155, 130721, '宣化县', 130700),
(156, 130722, '张北县', 130700),
(157, 130723, '康保县', 130700),
(158, 130724, '沽源县', 130700),
(159, 130725, '尚义县', 130700),
(160, 130726, '蔚 县', 130700),
(161, 130727, '阳原县', 130700),
(162, 130728, '怀安县', 130700),
(163, 130729, '万全县', 130700),
(164, 130730, '怀来县', 130700),
(165, 130731, '涿鹿县', 130700),
(166, 130732, '赤城县', 130700),
(167, 130733, '崇礼县', 130700),
(168, 130801, '市辖区', 130800),
(169, 130802, '双桥区', 130800),
(170, 130803, '双滦区', 130800),
(171, 130804, '鹰手营子矿区', 130800),
(172, 130821, '承德县', 130800),
(173, 130822, '兴隆县', 130800),
(174, 130823, '平泉县', 130800),
(175, 130824, '滦平县', 130800),
(176, 130825, '隆化县', 130800),
(177, 130826, '丰宁满族自治县', 130800),
(178, 130827, '宽城满族自治县', 130800),
(179, 130828, '围场满族蒙古族自治县', 130800),
(180, 130901, '市辖区', 130900),
(181, 130902, '新华区', 130900),
(182, 130903, '运河区', 130900),
(183, 130921, '沧 县', 130900),
(184, 130922, '青 县', 130900),
(185, 130923, '东光县', 130900),
(186, 130924, '海兴县', 130900),
(187, 130925, '盐山县', 130900),
(188, 130926, '肃宁县', 130900),
(189, 130927, '南皮县', 130900),
(190, 130928, '吴桥县', 130900),
(191, 130929, '献 县', 130900),
(192, 130930, '孟村回族自治县', 130900),
(193, 130981, '泊头市', 130900),
(194, 130982, '任丘市', 130900),
(195, 130983, '黄骅市', 130900),
(196, 130984, '河间市', 130900),
(197, 131001, '市辖区', 131000),
(198, 131002, '安次区', 131000),
(199, 131003, '广阳区', 131000),
(200, 131022, '固安县', 131000),
(201, 131023, '永清县', 131000),
(202, 131024, '香河县', 131000),
(203, 131025, '大城县', 131000),
(204, 131026, '文安县', 131000),
(205, 131028, '大厂回族自治县', 131000),
(206, 131081, '霸州市', 131000),
(207, 131082, '三河市', 131000),
(208, 131101, '市辖区', 131100),
(209, 131102, '桃城区', 131100),
(210, 131121, '枣强县', 131100),
- 1
- 2
前往页