fastadmin地区表 fa-area 带省市区行政区划编码

/* Navicat MySQL Data Transfer Source Server : 测试60.205.106.66-灵活用工 Source Server Version : 50505 Source Host : 60.205.106.66:3306 Source Database : bxtest Target Server Type : MYSQL Target Server Version : 50505 File Encoding : 65001 Date: 2021-09-01 16:22:56 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for fa_area -- ---------------------------- DROP TABLE IF EXISTS `fa_area`; CREATE TABLE `fa_area` ( `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'ID', `pid` int(10) DEFAULT NULL COMMENT '父id', `shortname` varchar(100) DEFAULT NULL COMMENT '简称', `name` varchar(100) DEFAULT NULL COMMENT '名称', `num` varchar(50) DEFAULT NULL COMMENT '编码', `mergename` varchar(255) DEFAULT NULL COMMENT '全称', `level` tinyint(4) DEFAULT NULL COMMENT '层级 0 1 2 省市区县', `pinyin` varchar(100) DEFAULT NULL COMMENT '拼音', `code` varchar(100) DEFAULT NULL COMMENT '长途区号', `zip` varchar(100) DEFAULT NULL COMMENT '邮编', `first` varchar(50) DEFAULT NULL COMMENT '首字母', `lng` varchar(100) DEFAULT NULL COMMENT '经度', `lat` varchar(100) DEFAULT NULL COMMENT '纬度', PRIMARY KEY (`id`), KEY `pid` (`pid`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=3749 DEFAULT CHARSET=utf8 COMMENT='地区表'; -- ---------------------------- -- Records of fa_area -- ---------------------------- INSERT INTO `fa_area` VALUES ('1', '0', '北京', '北京', '110000', '中国,北京', '1', 'beijing', '', '', 'B', '116.405285', '39.904989'); INSERT INTO `fa_area` VALUES ('2', '1', '北京', '北京市', '110100', '中国,北京,北京市', '2', 'beijing', '010', '100000', 'B', '116.405285', '39.904989'); INSERT INTO `fa_area` VALUES ('3', '2', '东城', '东城区', '110101', '中国,北京,北京市,东城区', '3', 'dongcheng', '010', '100010', 'D', '116.41005', '39.93157'); INSERT INTO `fa_area` VALUES ('4', '2', '西城', '西城区', '110102', '中国,北京,北京市,西城区', '3', 'xicheng', '010', '100032', 'X', '116.36003', '39.9305'); INSERT INTO `fa_area` VALUES ('5', '2', '朝阳', '朝阳区', '110105', '中国,北京,北京市,朝阳区', '3', 'chaoyang', '010', '100020', 'C', '116.48548', '39.9484'); INSERT INTO `fa_area` VALUES ('6', '2', '丰台', '丰台区', '110106', '中国,北京,北京市,丰台区', '3', 'fengtai', '010', '100071', 'F', '116.28625', '39.8585'); INSERT INTO `fa_area` VALUES ('7', '2', '石景山', '石景山区', '110107', '中国,北京,北京市,石景山区', '3', 'shijingshan', '010', '100043', 'S', '116.2229', '39.90564'); INSERT INTO `fa_area` VALUES ('8', '2', '海淀', '海淀区', '110108', '中国,北京,北京市,海淀区', '3', 'haidian', '010', '100089', 'H', '116.29812', '39.95931'); INSERT INTO `fa_area` VALUES ('9', '2', '门头沟', '门头沟区', '110109', '中国,北京,北京市,门头沟区', '3', 'mentougou', '010', '102300', 'M', '116.10137', '39.94043'); INSERT INTO `fa_area` VALUES ('10', '2', '房山', '房山区', '110111', '中国,北京,北京市,房山区', '3', 'fangshan', '010', '102488', 'F', '116.14257', '39.74786'); INSERT INTO `fa_area` VALUES ('11', '2', '通州', '通州区', '110112', '中国,北京,北京市,通州区', '3', 'tongzhou', '010', '101149', 'T', '116.65716', '39.90966'); INSERT INTO `fa_area` VALUES ('12', '2', '顺义', '顺义区', '110113', '中国,北京,北京市,顺义区', '3', 'shunyi', '010', '101300', 'S', '116.65417', '40.1302'); INSERT INTO `fa_area` VALUES ('13', '2', '昌平', '昌平区', '110114', '中国,北京,北京市,昌平区', '3', 'changping', '010', '102200', 'C', '116.2312', '40.22072'); INSERT INTO `fa_area` VALUES ('14', '2', '大兴', '大兴区', '110115', '中国,北京,北京市,大兴区', '3', 'daxing', '010', '102600', 'D', '116.34149', '39.72668'); INSERT INTO `fa_area` VALUES ('15', '2', '怀柔', '怀柔区', '110116', '中国,北京,北京市,怀柔区', '3', 'huairou', '010', '101400', 'H', '116.63168', '40.31602'); INSERT INTO `fa_area` VALUES ('16', '2', '平谷', '平谷区', '110117', '中国,北京,北京市,平谷区', '3', 'pinggu', '010', '101200', 'P', '117.12133', '40.14056'); INSERT INTO `fa_area` VALUES ('17', '2', '密云', '密云县', '110228', '中国,北京,北京市,密云县', '3', 'miyun', '010', '101500', 'M', '116.84295', '40.37618'); INSERT INTO `fa_area` VALUES ('18', '2', '延庆', '延庆县', '110229', '中国,北京,北京市,延庆县', '3', 'yanqing', '010', '102100', 'Y', '115.97494', '40.45672'); INSERT INTO `fa_area` VALUES ('19', '0', '天津', '天津', '120000', '中国,天津', '1', 'tianjin', '', '', 'T', '117.190182', '39.125596'); INSERT INTO `fa_area` VALUES ('20', '19', '天津', '天津市', '120100', '中国,天津,天津市', '2', 'tianjin', '022', '300000', 'T', '117.190182', '39.125596'); INSERT INTO `fa_area` VALUES ('21', '20', '和平', '和平区', '120101', '中国,天津,天津市,和平区', '3', 'heping', '022', '300041', 'H', '117.21456', '39.11718'); INSERT INTO `fa_area` VALUES ('22', '20', '河东', '河东区', '120102', '中国,天津,天津市,河东区', '3', 'hedong', '022', '300171', 'H', '117.22562', '39.12318'); INSERT INTO `fa_area` VALUES ('23', '20', '河西', '河西区', '120103', '中国,天津,天津市,河西区', '3', 'hexi', '022', '300202', 'H', '117.22327', '39.10959'); INSERT INTO `fa_area` VALUES ('24', '20', '南开', '南开区', '120104', '中国,天津,天津市,南开区', '3', 'nankai', '022', '300110', 'N', '117.15074', '39.13821'); INSERT INTO `fa_area` VALUES ('25', '20', '河北', '河北区', '120105', '中国,天津,天津市,河北区', '3', 'hebei', '022', '300143', 'H', '117.19697', '39.14816'); INSERT INTO `fa_area` VALUES ('26', '20', '红桥', '红桥区', '120106', '中国,天津,天津市,红桥区', '3', 'hongqiao', '022', '300131', 'H', '117.15145', '39.16715'); INSERT INTO `fa_area` VALUES ('27', '20', '东丽', '东丽区', '120110', '中国,天津,天津市,东丽区', '3', 'dongli', '022', '300300', 'D', '117.31436', '39.0863'); INSERT INTO `fa_area` VALUES ('28', '20', '西青', '西青区', '120111', '中国,天津,天津市,西青区', '3', 'xiqing', '022', '300380', 'X', '117.00927', '39.14123'); INSERT INTO `fa_area` VALUES ('29', '20', '津南', '津南区', '120112', '中国,天津,天津市,津南区', '3', 'jinnan', '022', '300350', 'J', '117.38537', '38.99139'); INSERT INTO `fa_area` VALUES ('30', '20', '北辰', '北辰区', '120113', '中国,天津,天津市,北辰区', '3', 'beichen', '022', '300400', 'B', '117.13217', '39.22131'); INSERT INTO `fa_area` VALUES ('31', '20', '武清', '武清区', '120114', '中国,天津,天津市,武清区', '3', 'wuqing', '022', '301700', 'W', '117.04443', '39.38415'); INSERT INTO `fa_area` VALUES ('32', '20', '宝坻', '宝坻区', '120115', '中国,天津,天津市,宝坻区', '3', 'baodi', '022', '301800', 'B', '117.3103', '39.71761'); INSERT INTO `fa_area` VALUES ('33', '20', '滨海新区', '滨海新区', null, '中国,天津,天津市,滨海新区', '3', 'binhaixinqu', '022', '300451', 'B', '117.70162', '39.02668'); INSERT INTO `fa_area` VALUES ('34', '20', '宁河', '宁河县', '120221', '中国,天津,天津市,宁河县', '3', 'ninghe', '022', '301500', 'N', '117.8255', '39.33048'); INSERT INTO `fa_area` VALUES ('35', '20', '静海', '静海县', '120223', '中国,天津,天津市,静海县', '3', 'jinghai', '022', '301600', 'J', '116.97436', '38.94582'); INSERT INTO `fa_area` VALUES ('36', '20', '蓟县', '蓟县', '120225', '中国,天津,天津市,蓟县', '3', 'jixian', '022', '301900', 'J', '117.40799', '40.04567'); INSERT INTO `fa_area` VALUES ('37', '0', '河北', '河北省', '130000', '中国,河北省', '1', 'hebei', '', '', 'H', '114.502461', '38.045474'); INSERT INTO `fa_area` VALUES ('38', '37', '石家庄', '石家庄市', '130100', '中国,河北省,石�