省市区行政区划.zip资源-CSDN文库

共1个文件

sql：1个

行政区划

mysql

需积分: 8 34 浏览量 2021-12-24 15:40:47 上传评论收藏 88KB ZIP 举报

资源详情

资源评论

资源推荐

收起资源包目录

area-20211224.zip （1个子文件）

area-20211224.sql 654KB

/* Navicat MySQL Data Transfer Source Server : 192.168.23.216 Source Server Version : 100122 Source Host : 192.168.23.216:3306 Source Database : unifyUser Target Server Type : MYSQL Target Server Version : 100122 File Encoding : 65001 Date: 2021-12-24 15:11:52 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for area -- ---------------------------- DROP TABLE IF EXISTS `area`; CREATE TABLE `area` ( `id` varchar(32) NOT NULL COMMENT '行政区划编码', `pid` varchar(32) NOT NULL COMMENT '父编码', `level` varchar(10) NOT NULL COMMENT '层级-1省 2市 3区', `name` varchar(32) DEFAULT NULL COMMENT '简称', `full_name` varchar(64) NOT NULL COMMENT '全称', `pinyin` varchar(100) DEFAULT NULL COMMENT '拼音', `lng` varchar(32) NOT NULL COMMENT '经度', `lat` varchar(32) NOT NULL COMMENT '纬度', `create_user` varchar(32) NOT NULL COMMENT '创建人', `update_user` varchar(32) NOT NULL COMMENT '修改人', `create_time` datetime NOT NULL COMMENT '创建时间', `update_time` datetime NOT NULL COMMENT '修改时间', PRIMARY KEY (`id`), KEY `pid` (`pid`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='行政区划表'; -- ---------------------------- -- Records of area -- ---------------------------- INSERT INTO `area` VALUES ('110000', '0', '1', '北京', '北京市', 'beijing', '116.40717', '39.90469', 'admin', 'admin', '2021-12-23 14:45:02', '2021-12-23 14:45:02'); INSERT INTO `area` VALUES ('110101', '110000', '3', '东城', '东城区', 'dongcheng', '116.41637', '39.92855', 'admin', 'admin', '2021-12-23 17:17:29', '2021-12-23 17:17:29'); INSERT INTO `area` VALUES ('110102', '110000', '3', '西城', '西城区', 'xicheng', '116.366216', '39.912238', 'admin', 'admin', '2021-12-23 17:17:29', '2021-12-23 17:17:29'); INSERT INTO `area` VALUES ('110105', '110000', '3', '朝阳', '朝阳区', 'chaoyang', '116.443619', '39.921141', 'admin', 'admin', '2021-12-23 17:17:29', '2021-12-23 17:17:29'); INSERT INTO `area` VALUES ('110106', '110000', '3', '丰台', '丰台区', 'fengtai', '116.286251', '39.858481', 'admin', 'admin', '2021-12-23 17:17:29', '2021-12-23 17:17:29'); INSERT INTO `area` VALUES ('110107', '110000', '3', '石景山', '石景山区', 'shijingshan', '116.223011', '39.90659', 'admin', 'admin', '2021-12-23 17:17:29', '2021-12-23 17:17:29'); INSERT INTO `area` VALUES ('110108', '110000', '3', '海淀', '海淀区', 'haidian', '116.29845', '39.95933', 'admin', 'admin', '2021-12-23 17:17:29', '2021-12-23 17:17:29'); INSERT INTO `area` VALUES ('110109', '110000', '3', '门头沟', '门头沟区', 'mentougou', '116.1016', '39.94046', 'admin', 'admin', '2021-12-23 17:17:29', '2021-12-23 17:17:29'); INSERT INTO `area` VALUES ('110111', '110000', '3', '房山', '房山区', 'fangshan', '116.14329', '39.749041', 'admin', 'admin', '2021-12-23 17:17:29', '2021-12-23 17:17:29'); INSERT INTO `area` VALUES ('110112', '110000', '3', '通州', '通州区', 'tongzhou', '116.72894', '39.9164', 'admin', 'admin', '2021-12-23 17:17:29', '2021-12-23 17:17:29'); INSERT INTO `area` VALUES ('110113', '110000', '3', '顺义', '顺义区', 'shunyi', '116.66113', '40.14968', 'admin', 'admin', '2021-12-23 17:17:29', '2021-12-23 17:17:29'); INSERT INTO `area` VALUES ('110114', '110000', '3', '昌平', '昌平区', 'changping', '116.23128', '40.22077', 'admin', 'admin', '2021-12-23 17:17:29', '2021-12-23 17:17:29'); INSERT INTO `area` VALUES ('110115', '110000', '3', '大兴', '大兴区', 'daxing', '116.34139', '39.72682', 'admin', 'admin', '2021-12-23 17:17:29', '2021-12-23 17:17:29'); INSERT INTO `area` VALUES ('110116', '110000', '3', '怀柔', '怀柔区', 'huairou', '116.631964', '40.316053', 'admin', 'admin', '2021-12-23 17:17:29', '2021-12-23 17:17:29'); INSERT INTO `area` VALUES ('110117', '110000', '3', '平谷', '平谷区', 'pinggu', '117.121219', '40.14062', 'admin', 'admin', '2021-12-23 17:17:29', '2021-12-23 17:17:29'); INSERT INTO `area` VALUES ('110118', '110000', '3', '密云', '密云区', 'miyun', '116.84294', '40.37627', 'admin', 'admin', '2021-12-23 17:17:29', '2021-12-23 17:17:29'); INSERT INTO `area` VALUES ('110119', '110000', '3', '延庆', '延庆区', 'yanqing', '115.974764', '40.457199', 'admin', 'admin', '2021-12-23 17:17:29', '2021-12-23 17:17:29'); INSERT INTO `area` VALUES ('120000', '0', '1', '天津', '天津市', 'tianjin', '117.19937', '39.0851', 'admin', 'admin', '2021-12-23 14:45:02', '2021-12-23 14:45:02'); INSERT INTO `area` VALUES ('120101', '120000', '3', '和平', '和平区', 'heping', '117.2148', '39.11715', 'admin', 'admin', '2021-12-23 17:17:30', '2021-12-23 17:17:30'); INSERT INTO `area` VALUES ('120102', '120000', '3', '河东', '河东区', 'hedong', '117.25167', '39.128306', 'admin', 'admin', '2021-12-23 17:17:30', '2021-12-23 17:17:30'); INSERT INTO `area` VALUES ('120103', '120000', '3', '河西', '河西区', 'hexi', '117.22336', '39.10954', 'admin', 'admin', '2021-12-23 17:17:30', '2021-12-23 17:17:30'); INSERT INTO `area` VALUES ('120104', '120000', '3', '南开', '南开区', 'nankai', '117.15065', '39.13822', 'admin', 'admin', '2021-12-23 17:17:30', '2021-12-23 17:17:30'); INSERT INTO `area` VALUES ('120105', '120000', '3', '河北', '河北区', 'hebei', '117.19674', '39.14784', 'admin', 'admin', '2021-12-23 17:17:30', '2021-12-23 17:17:30'); INSERT INTO `area` VALUES ('120106', '120000', '3', '红桥', '红桥区', 'hongqiao', '117.15161', '39.16734', 'admin', 'admin', '2021-12-23 17:17:30', '2021-12-23 17:17:30'); INSERT INTO `area` VALUES ('120110', '120000', '3', '东丽', '东丽区', 'dongli', '117.31439', '39.08655', 'admin', 'admin', '2021-12-23 17:17:30', '2021-12-23 17:17:30'); INSERT INTO `area` VALUES ('120111', '120000', '3', '西青', '西青区', 'xiqing', '117.00867', '39.141431', 'admin', 'admin', '2021-12-23 17:17:30', '2021-12-23 17:17:30'); INSERT INTO `area` VALUES ('120112', '120000', '3', '津南', '津南区', 'jinnan', '117.3571', '38.9375', 'admin', 'admin', '2021-12-23 17:17:30', '2021-12-23 17:17:30'); INSERT INTO `area` VALUES ('120113', '120000', '3', '北辰', '北辰区', 'beichen', '117.13544', '39.22393', 'admin', 'admin', '2021-12-23 17:17:30', '2021-12-23 17:17:30'); INSERT INTO `area` VALUES ('120114', '120000', '3', '武清', '武清区', 'wuqing', '117.0443', '39.38408', 'admin', 'admin', '2021-12-23 17:17:30', '2021-12-23 17:17:30'); INSERT INTO `area` VALUES ('120115', '120000', '3', '宝坻', '宝坻区', 'baodi', '117.309858', '39.717694', 'admin', 'admin', '2021-12-23 17:17:30', '2021-12-23 17:17:30'); INSERT INTO `area` VALUES ('120116', '120000', '3', '滨海', '滨海新区', 'binhai', '117.696356', '39.017564', 'admin', 'admin', '2021-12-23 17:17:30', '2021-12-23 17:17:30'); INSERT INTO `area` VALUES ('120117', '120000', '3', '宁河', '宁河区', 'ninghe', '117.82682', '39.32992', 'admin', 'admin', '2021-12-23 17:17:30', '2021-12-23 17:17:30'); INSERT INTO `area` VALUES ('120118', '120000', '3', '静海', '静海区', 'jinghai', '116.97428', '38.94737', 'admin', 'admin', '2021-12-23 17:17:30', '2021-12-23 17:17:30'); INSERT INTO `area` VALUES ('120119', '120000', '3', '蓟州', '蓟州区', 'jizhou', '117.40829', '40.04577', 'admin', 'admin', '2021-12-23 17:17:30', '2021-12-23 17:17:30'); INSERT INTO `area` VALUES ('130000', '0', '1', '河北', '河北省', 'hebei', '114.46979', '38.03599', 'admin', 'admin', '2021-12-23 14:45:02', '2021-12-23 14:45:02'); INSERT INTO `area` VALUES ('130100', '130000', '2', '石家庄', '石家庄市', 'shijiazhuang', '114.5143', '38.04276', 'admin', 'admin', '2021-12-23 16:02:06', '2021-12-23 16:02:06'); INSERT INTO `area` VALUES ('130102', '130100', '3', null, '长安区', '', '114.5393', '38.03626', 'admin', 'admin', '2021-12-23 17:17:31', '2021-12-23 17:17:31'); INSERT INTO `area` VALUES ('130104', '130100', '3', null, '