世界省市县sql直接下载就可以用

/* Navicat MySQL Data Transfer Source Server : localhost_3306 Source Server Version : 50717 Source Host : localhost:3306 Source Database : recipe Target Server Type : MYSQL Target Server Version : 50717 File Encoding : 65001 Date: 2017-02-20 17:02:06 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `rec_area` -- ---------------------------- DROP TABLE IF EXISTS `rec_area`; CREATE TABLE `rec_area` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `pid` int(11) NOT NULL DEFAULT '0', `name` varchar(25) NOT NULL, `short_name` varchar(25) NOT NULL, `longitude` float DEFAULT NULL, `latitude` float DEFAULT NULL, `level` smallint(4) DEFAULT NULL, `sort` int(11) NOT NULL DEFAULT '1', `status` smallint(2) NOT NULL DEFAULT '1', `source` smallint(2) NOT NULL DEFAULT '1' COMMENT '来源 1系统 2 用户添加', `code` varchar(25) DEFAULT NULL, PRIMARY KEY (`id`), KEY `id` (`id`) USING BTREE, KEY `pid` (`pid`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=659007928 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of rec_area -- ---------------------------- INSERT INTO `rec_area` VALUES ('110100', '11099', '北京市', '北京', '116.405', '39.905', '2', '1', '1', '1', null); INSERT INTO `rec_area` VALUES ('110101', '110100', '东城区', '东城', '116.419', '39.9175', '3', '3', '1', '1', null); INSERT INTO `rec_area` VALUES ('110102', '110100', '西城区', '西城', '116.367', '39.9153', '3', '15', '1', '1', null); INSERT INTO `rec_area` VALUES ('110105', '110100', '朝阳区', '朝阳', '116.486', '39.9215', '3', '2', '1', '1', null); INSERT INTO `rec_area` VALUES ('110106', '110100', '丰台区', '丰台', '116.287', '39.8636', '3', '6', '1', '1', null); INSERT INTO `rec_area` VALUES ('110107', '110100', '石景山区', '石景山', '116.195', '39.9146', '3', '12', '1', '1', null); INSERT INTO `rec_area` VALUES ('110108', '110100', '海淀区', '海淀', '116.31', '39.9561', '3', '7', '1', '1', null); INSERT INTO `rec_area` VALUES ('110109', '110100', '门头沟区', '门头沟', '116.105', '39.9372', '3', '9', '1', '1', null); INSERT INTO `rec_area` VALUES ('110111', '110100', '房山区', '房山', '116.139', '39.7355', '3', '5', '1', '1', null); INSERT INTO `rec_area` VALUES ('110112', '110100', '通州区', '通州', '116.659', '39.9025', '3', '14', '1', '1', null); INSERT INTO `rec_area` VALUES ('110113', '110100', '顺义区', '顺义', '116.654', '40.1289', '3', '13', '1', '1', null); INSERT INTO `rec_area` VALUES ('110114', '110100', '昌平区', '昌平', '116.236', '40.2181', '3', '1', '1', '1', null); INSERT INTO `rec_area` VALUES ('110115', '110100', '大兴区', '大兴', '116.338', '39.7289', '3', '4', '1', '1', null); INSERT INTO `rec_area` VALUES ('110116', '110100', '怀柔区', '怀柔', '116.637', '40.3243', '3', '8', '1', '1', null); INSERT INTO `rec_area` VALUES ('110117', '110100', '平谷区', '平谷', '117.112', '40.1448', '3', '11', '1', '1', null); INSERT INTO `rec_area` VALUES ('110228', '110100', '密云县', '密云', '116.843', '40.3774', '3', '10', '1', '1', null); INSERT INTO `rec_area` VALUES ('110229', '110100', '延庆县', '延庆', '115.985', '40.4653', '3', '16', '1', '1', null); INSERT INTO `rec_area` VALUES ('120000', '1', '天津', '天津', '117.19', '39.1256', '1', '2', '1', '1', null); INSERT INTO `rec_area` VALUES ('120100', '120000', '天津市', '天津', '117.19', '39.1256', '2', '1', '1', '1', null); INSERT INTO `rec_area` VALUES ('120101', '120100', '和平区', '和平', '117.196', '39.1183', '3', '7', '1', '1', null); INSERT INTO `rec_area` VALUES ('120102', '120100', '河东区', '河东', '117.227', '39.1221', '3', '6', '1', '1', null); INSERT INTO `rec_area` VALUES ('120103', '120100', '河西区', '河西', '117.218', '39.1019', '3', '8', '1', '1', null); INSERT INTO `rec_area` VALUES ('120104', '120100', '南开区', '南开', '117.164', '39.1205', '3', '13', '1', '1', null); INSERT INTO `rec_area` VALUES ('120105', '120100', '河北区', '河北', '117.202', '39.1566', '3', '5', '1', '1', null); INSERT INTO `rec_area` VALUES ('120106', '120100', '红桥区', '红桥', '117.163', '39.1751', '3', '9', '1', '1', null); INSERT INTO `rec_area` VALUES ('120110', '120100', '东丽区', '东丽', '117.314', '39.0878', '3', '4', '1', '1', null); INSERT INTO `rec_area` VALUES ('120111', '120100', '西青区', '西青', '117.012', '39.1394', '3', '16', '1', '1', null); INSERT INTO `rec_area` VALUES ('120112', '120100', '津南区', '津南', '117.383', '38.9896', '3', '11', '1', '1', null); INSERT INTO `rec_area` VALUES ('120113', '120100', '北辰区', '北辰', '117.135', '39.2256', '3', '2', '1', '1', null); INSERT INTO `rec_area` VALUES ('120114', '120100', '武清区', '武清', '117.058', '39.3769', '3', '15', '1', '1', null); INSERT INTO `rec_area` VALUES ('120115', '120100', '宝坻区', '宝坻', '117.308', '39.717', '3', '1', '1', '1', null); INSERT INTO `rec_area` VALUES ('120116', '120100', '滨海新区', '滨海', '117.654', '39.0328', '3', '3', '1', '1', null); INSERT INTO `rec_area` VALUES ('120221', '120100', '宁河县', '宁河', '117.828', '39.3289', '3', '14', '1', '1', null); INSERT INTO `rec_area` VALUES ('120223', '120100', '静海县', '静海', '116.925', '38.9357', '3', '10', '1', '1', null); INSERT INTO `rec_area` VALUES ('120225', '120100', '蓟县', '蓟县', '117.407', '40.0453', '3', '12', '1', '1', null); INSERT INTO `rec_area` VALUES ('130000', '1', '河北省', '河北', '114.502', '38.0455', '1', '3', '1', '1', null); INSERT INTO `rec_area` VALUES ('130100', '130000', '石家庄市', '石家庄', '114.502', '38.0455', '2', '8', '1', '1', null); INSERT INTO `rec_area` VALUES ('130102', '130100', '长安区', '长安', '114.548', '38.0475', '3', '1', '1', '1', null); INSERT INTO `rec_area` VALUES ('130103', '130100', '桥东区', '桥东', '114.503', '38.0402', '3', '11', '1', '1', null); INSERT INTO `rec_area` VALUES ('130104', '130100', '桥西区', '桥西', '114.463', '38.0284', '3', '12', '1', '1', null); INSERT INTO `rec_area` VALUES ('130105', '130100', '新华区', '新华', '114.466', '38.0671', '3', '16', '1', '1', null); INSERT INTO `rec_area` VALUES ('130107', '130100', '井陉矿区', '井陉矿', '114.058', '38.0697', '3', '4', '1', '1', null); INSERT INTO `rec_area` VALUES ('130108', '130100', '裕华区', '裕华', '114.533', '38.0277', '3', '20', '1', '1', null); INSERT INTO `rec_area` VALUES ('130121', '130100', '井陉县', '井陉', '114.144', '38.0336', '3', '5', '1', '1', null); INSERT INTO `rec_area` VALUES ('130123', '130100', '正定县', '正定', '114.57', '38.1478', '3', '23', '1', '1', null); INSERT INTO `rec_area` VALUES ('130124', '130100', '栾城县', '栾城', '114.654', '37.8869', '3', '8', '1', '1', null); INSERT INTO `rec_area` VALUES ('130125', '130100', '行唐县', '行唐', '114.553', '38.4374', '3', '15', '1', '1', null); INSERT INTO `rec_area` VALUES ('130126', '130100', '灵寿县', '灵寿', '114.379', '38.3065', '3', '7', '1', '1', null); INSERT INTO `rec_area` VALUES ('130127', '130100', '高邑县', '高邑', '114.611', '37.6057', '3', '3', '1', '1', null); INSERT INTO `rec_area` VALUES ('130128', '130100', '深泽县', '深泽', '115.2', '38.1845', '3', '13', '1', '1', null); INSERT INTO `rec_area` VALUES ('130129', '130100', '赞皇县', '赞皇', '114.388', '37.6602', '3', '21', '1', '1', null); INSERT INTO `rec_area` VALUES ('130130', '130100', '无极县', '无极', '114.978', '38.1764', '3', '14', '1', '1', null); INSERT INTO `rec_area` VALUES ('130131', '130100', '平山县', '平山', '114.184', '38.2593', '3', '10', '1', '1', null); INSERT INTO `rec_area` VALUES ('130132', '130100', '元氏县', '元氏', '114.526', '37.7625', '3', '19', '1', '1', null); INSERT INTO `rec_area` VALUES ('130133', '130100', '赵县', '