mysql省市区县街道

ypp91zr
已于 2022-11-02 09:33:10 修改
阅读量1.1k
点赞数 1
分类专栏： java mysql 文章标签： java mysql
于 2022-11-02 09:32:56 首次发布
本文链接：https://blog.csdn.net/ypp91zr/article/details/127638390
版权
java 同时被 2 个专栏收录
193 篇文章 3 订阅
订阅专栏
mysql
45 篇文章 0 订阅
订阅专栏
数据都是在一张表，包含地理位置等。通过parent_code匹配上下级联动
提取链接:百度网盘请输入提取码
提取码:m0nf
下面是部分数据，所有数据在上面链接里
/*
Navicat MySQL Data Transfer
Target Server Type    : MYSQL
Target Server Version : 50732
File Encoding         : 65001

Date: 2022-11-01 17:53:35
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for t_area
-- ----------------------------
DROP TABLE IF EXISTS `t_area`;
CREATE TABLE `t_area` (
  `id` bigint(20) NOT NULL,
  `code` varchar(40) NOT NULL COMMENT 'code代码',
  `name` varchar(50) NOT NULL COMMENT '名称',
  `short_name` varchar(50) NOT NULL COMMENT '简称',
  `type` int(1) NOT NULL COMMENT '1-省份 2-城市 3-区县 4-街道',
  `parent_code` varchar(255) DEFAULT NULL,
  `lng` varchar(20) DEFAULT NULL COMMENT '经度',
  `lat` varchar(20) DEFAULT NULL COMMENT '纬度',
  `sort` int(6) DEFAULT NULL COMMENT '排序',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `delete_status` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='地理位置设置';

-- ----------------------------
-- Records of t_area
-- ----------------------------
INSERT INTO `t_area` VALUES ('1667291008900000', '110000', '北京', '北京', '1', '000000', '116.405289', '39.904987', '1', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008900001', '120000', '天津', '天津', '1', '000000', '117.190186', '39.125595', '2', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008900002', '130000', '河北省', '河北', '1', '000000', '114.502464', '38.045475', '3', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008900003', '140000', '山西省', '山西', '1', '000000', '112.549248', '37.857014', '4', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008900004', '150000', '内蒙古自治区', '内蒙古', '1', '000000', '111.670799', '40.81831', '5', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008900005', '210000', '辽宁省', '辽宁', '1', '000000', '123.429092', '41.796768', '6', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008900006', '220000', '吉林省', '吉林', '1', '000000', '125.324501', '43.886841', '7', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008900007', '230000', '黑龙江省', '黑龙江', '1', '000000', '126.642464', '45.756966', '8', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008900008', '310000', '上海', '上海', '1', '000000', '121.472641', '31.231707', '9', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008900009', '320000', '江苏省', '江苏', '1', '000000', '118.76741', '32.041546', '10', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008901000', '330000', '浙江省', '浙江', '1', '000000', '120.15358', '30.287458', '11', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008901001', '340000', '安徽省', '安徽', '1', '000000', '117.283043', '31.861191', '12', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008901002', '350000', '福建省', '福建', '1', '000000', '119.306236', '26.075302', '13', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008901003', '360000', '江西省', '江西', '1', '000000', '115.892151', '28.676493', '14', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008901004', '370000', '山东省', '山东', '1', '000000', '117.000923', '36.675808', '15', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008901005', '410000', '河南省', '河南', '1', '000000', '113.665413', '34.757977', '16', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008901006', '420000', '湖北省', '湖北', '1', '000000', '114.298569', '30.584354', '17', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008901007', '430000', '湖南省', '湖南', '1', '000000', '112.982277', '28.19409', '18', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008901008', '440000', '广东省', '广东', '1', '000000', '113.28064', '23.125177', '19', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008901009', '450000', '广西壮族自治区', '广西', '1', '000000', '108.320007', '22.82402', '20', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008905000', '460000', '海南省', '海南', '1', '000000', '110.331192', '20.031971', '21', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008905001', '500000', '重庆', '重庆', '1', '000000', '106.504959', '29.533155', '22', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008905002', '510000', '四川省', '四川', '1', '000000', '104.065735', '30.659462', '23', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008905003', '520000', '贵州省', '贵州', '1', '000000', '106.713478', '26.578342', '24', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008905004', '530000', '云南省', '云南', '1', '000000', '102.71225', '25.040609', '25', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008905005', '540000', '西藏自治区', '西藏', '1', '000000', '91.13221', '29.66036', '26', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008905006', '610000', '陕西省', '陕西', '1', '000000', '108.948021', '34.263161', '27', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008905007', '620000', '甘肃省', '甘肃', '1', '000000', '103.823555', '36.058041', '28', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008905008', '630000', '青海省', '青海', '1', '000000', '101.778915', '36.623177', '29', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008905009', '640000', '宁夏回族自治区', '宁夏', '1', '000000', '106.278175', '38.46637', '30', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008906000', '650000', '新疆维吾尔自治区', '新疆', '1', '000000', '87.617729', '43.792816', '31', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008906001', '710000', '台湾', '台湾', '1', '000000', '121.509064', '25.044333', '34', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008906002', '810000', '香港特别行政区', '香港', '1', '000000', '114.173355', '22.320047', '32', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008906003', '820000', '澳门特别行政区', '澳门', '1', '000000', '113.549088', '22.198952', '33', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008906004', '110100', '北京市', '北京', '2', '110000', '116.405289', '39.904987', '1', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008906005', '120100', '天津市', '天津', '2', '120000', '117.190186', '39.125595', '1', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008906006', '130100', '石家庄市', '石家庄', '2', '130000', '114.502464', '38.045475', '8', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008906007', '130200', '唐山市', '唐山', '2', '130000', '118.175392', '39.635113', '9', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008906008', '130300', '秦皇岛市', '秦皇岛', '2', '130000', '119.586578', '39.942532', '7', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291008906009', '130400', '邯郸市', '邯郸', '2', '130000', '114.490685', '36.612274', '4', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009059000', '130500', '邢台市', '邢台', '2', '130000', '114.50885', '37.068199', '10', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009059001', '130600', '保定市', '保定', '2', '130000', '115.48233', '38.867657', '1', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009059002', '130700', '张家口市', '张家口', '2', '130000', '114.884094', '40.811901', '11', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009059003', '130800', '承德市', '承德', '2', '130000', '117.939156', '40.976204', '3', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009059004', '130900', '沧州市', '沧州', '2', '130000', '116.85746', '38.310581', '2', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009059005', '131000', '廊坊市', '廊坊', '2', '130000', '116.704437', '39.523926', '6', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009059006', '131100', '衡水市', '衡水', '2', '130000', '115.665993', '37.735096', '5', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009059007', '140100', '太原市', '太原', '2', '140000', '112.549248', '37.857014', '8', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009059008', '140200', '大同市', '大同', '2', '140000', '113.295258', '40.090309', '2', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009059009', '140300', '阳泉市', '阳泉', '2', '140000', '113.583282', '37.861187', '10', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009061000', '140400', '长治市', '长治', '2', '140000', '113.113556', '36.191113', '1', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009061001', '140500', '晋城市', '晋城', '2', '140000', '112.851273', '35.497555', '3', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009061002', '140600', '朔州市', '朔州', '2', '140000', '112.433388', '39.331261', '7', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009061003', '140700', '晋中市', '晋中', '2', '140000', '112.736465', '37.696495', '4', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009061004', '140800', '运城市', '运城', '2', '140000', '111.00396', '35.022778', '11', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009061005', '140900', '忻州市', '忻州', '2', '140000', '112.733536', '38.41769', '9', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009061006', '141000', '临汾市', '临汾', '2', '140000', '111.517975', '36.084148', '5', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009061007', '141100', '吕梁市', '吕梁', '2', '140000', '111.134338', '37.524364', '6', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009061008', '150100', '呼和浩特市', '呼和浩特', '2', '150000', '111.670799', '40.81831', '6', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009061009', '150200', '包头市', '包头', '2', '150000', '109.840408', '40.658169', '2', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009063000', '150300', '乌海市', '乌海', '2', '150000', '106.825562', '39.673733', '9', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009063001', '150400', '赤峰市', '赤峰', '2', '150000', '118.956802', '42.275318', '4', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009063002', '150500', '通辽市', '通辽', '2', '150000', '122.263123', '43.617428', '8', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009063003', '150600', '鄂尔多斯市', '鄂尔多斯', '2', '150000', '109.990288', '39.817181', '5', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009063004', '150700', '呼伦贝尔市', '呼伦贝尔', '2', '150000', '119.758171', '49.215332', '7', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009063005', '150800', '巴彦淖尔市', '巴彦淖尔', '2', '150000', '107.416962', '40.757401', '3', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009063006', '150900', '乌兰察布市', '乌兰察布', '2', '150000', '113.11454', '41.034126', '10', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009063007', '152200', '兴安盟', '兴安', '2', '150000', '122.07032', '46.076267', '12', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009063008', '152500', '锡林郭勒盟', '锡林郭勒', '2', '150000', '116.090996', '43.944019', '11', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009063009', '152900', '阿拉善盟', '阿拉善', '2', '150000', '105.706421', '38.844814', '1', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009065000', '210100', '沈阳市', '沈阳', '2', '210000', '123.429092', '41.796768', '12', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009065001', '210200', '大连市', '大连', '2', '210000', '121.618622', '38.914589', '4', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009065002', '210300', '鞍山市', '鞍山', '2', '210000', '122.995628', '41.110626', '1', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009065003', '210400', '抚顺市', '抚顺', '2', '210000', '123.921112', '41.875957', '6', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009065004', '210500', '本溪市', '本溪', '2', '210000', '123.770515', '41.297909', '2', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009065005', '210600', '丹东市', '丹东', '2', '210000', '124.383041', '40.124294', '5', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009065006', '210700', '锦州市', '锦州', '2', '210000', '121.135742', '41.11927', '9', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009065007', '210800', '营口市', '营口', '2', '210000', '122.235153', '40.667431', '14', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009065008', '210900', '阜新市', '阜新', '2', '210000', '121.648964', '42.011795', '7', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009065009', '211000', '辽阳市', '辽阳', '2', '210000', '123.181519', '41.269402', '10', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009067000', '211100', '盘锦市', '盘锦', '2', '210000', '122.069572', '41.124485', '11', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009067001', '211200', '铁岭市', '铁岭', '2', '210000', '123.844276', '42.290585', '13', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009067002', '211300', '朝阳市', '朝阳', '2', '210000', '120.45118', '41.576759', '3', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009067003', '211400', '葫芦岛市', '葫芦岛', '2', '210000', '120.856392', '40.755573', '8', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009067004', '220100', '长春市', '长春', '2', '220000', '125.324501', '43.886841', '3', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009067005', '220200', '吉林市', '吉林', '2', '220000', '126.553017', '43.843578', '4', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009067006', '220300', '四平市', '四平', '2', '220000', '124.370789', '43.170345', '6', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009067007', '220400', '辽源市', '辽源', '2', '220000', '125.145348', '42.902691', '5', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009067008', '220500', '通化市', '通化', '2', '220000', '125.936501', '41.721176', '8', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009067009', '220600', '白山市', '白山', '2', '220000', '126.427841', '41.942505', '2', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009069000', '220700', '松原市', '松原', '2', '220000', '124.823608', '45.118244', '7', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');
INSERT INTO `t_area` VALUES ('1667291009069001', '220800', '白城市', '白城', '2', '220000', '122.84111', '45.619026', '1', '2022-11-01 03:23:29', '2022-11-01 03:23:29', '0');