/*
Navicat Premium Data Transfer
Source Server : 183.129.226.68(25库)
Source Server Type : MySQL
Source Server Version : 50650
Source Host : 183.129.226.68:8011
Source Schema : data_pipeline
Target Server Type : MySQL
Target Server Version : 50650
File Encoding : 65001
Date: 26/05/2021 13:46:16
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for zsj_district
-- ----------------------------
DROP TABLE IF EXISTS `zsj_district`;
CREATE TABLE `zsj_district` (
`id` int(11) NOT NULL,
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`level` tinyint(4) NULL DEFAULT NULL,
`parent_id` int(11) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '中国省市区划\n数据时间:2020.11\n数据源:http://www.mca.gov.cn/article/sj/xzqh/2020/' ROW_FORMAT = Compact;
-- ----------------------------
-- Records of zsj_district
-- ----------------------------
INSERT INTO `zsj_district` VALUES (110000, '北京市', 1, 0);
INSERT INTO `zsj_district` VALUES (110100, '北京市', 2, 110000);
INSERT INTO `zsj_district` VALUES (110101, '东城区', 3, 110100);
INSERT INTO `zsj_district` VALUES (110102, '西城区', 3, 110100);
INSERT INTO `zsj_district` VALUES (110105, '朝阳区', 3, 110100);
INSERT INTO `zsj_district` VALUES (110106, '丰台区', 3, 110100);
INSERT INTO `zsj_district` VALUES (110107, '石景山区', 3, 110100);
INSERT INTO `zsj_district` VALUES (110108, '海淀区', 3, 110100);
INSERT INTO `zsj_district` VALUES (110109, '门头沟区', 3, 110100);
INSERT INTO `zsj_district` VALUES (110111, '房山区', 3, 110100);
INSERT INTO `zsj_district` VALUES (110112, '通州区', 3, 110100);
INSERT INTO `zsj_district` VALUES (110113, '顺义区', 3, 110100);
INSERT INTO `zsj_district` VALUES (110114, '昌平区', 3, 110100);
INSERT INTO `zsj_district` VALUES (110115, '大兴区', 3, 110100);
INSERT INTO `zsj_district` VALUES (110116, '怀柔区', 3, 110100);
INSERT INTO `zsj_district` VALUES (110117, '平谷区', 3, 110100);
INSERT INTO `zsj_district` VALUES (110118, '密云区', 3, 110100);
INSERT INTO `zsj_district` VALUES (110119, '延庆区', 3, 110100);
INSERT INTO `zsj_district` VALUES (120000, '天津市', 1, 0);
INSERT INTO `zsj_district` VALUES (120100, '天津市', 2, 120000);
INSERT INTO `zsj_district` VALUES (120101, '和平区', 3, 120100);
INSERT INTO `zsj_district` VALUES (120102, '河东区', 3, 120100);
INSERT INTO `zsj_district` VALUES (120103, '河西区', 3, 120100);
INSERT INTO `zsj_district` VALUES (120104, '南开区', 3, 120100);
INSERT INTO `zsj_district` VALUES (120105, '河北区', 3, 120100);
INSERT INTO `zsj_district` VALUES (120106, '红桥区', 3, 120100);
INSERT INTO `zsj_district` VALUES (120110, '东丽区', 3, 120100);
INSERT INTO `zsj_district` VALUES (120111, '西青区', 3, 120100);
INSERT INTO `zsj_district` VALUES (120112, '津南区', 3, 120100);
INSERT INTO `zsj_district` VALUES (120113, '北辰区', 3, 120100);
INSERT INTO `zsj_district` VALUES (120114, '武清区', 3, 120100);
INSERT INTO `zsj_district` VALUES (120115, '宝坻区', 3, 120100);
INSERT INTO `zsj_district` VALUES (120116, '滨海新区', 3, 120100);
INSERT INTO `zsj_district` VALUES (120117, '宁河区', 3, 120100);
INSERT INTO `zsj_district` VALUES (120118, '静海区', 3, 120100);
INSERT INTO `zsj_district` VALUES (120119, '蓟州区', 3, 120100);
INSERT INTO `zsj_district` VALUES (130000, '河北省', 1, 0);
INSERT INTO `zsj_district` VALUES (130100, '石家庄市', 2, 130000);
INSERT INTO `zsj_district` VALUES (130102, '长安区', 3, 130100);
INSERT INTO `zsj_district` VALUES (130104, '桥西区', 3, 130100);
INSERT INTO `zsj_district` VALUES (130105, '新华区', 3, 130100);
INSERT INTO `zsj_district` VALUES (130107, '井陉矿区', 3, 130100);
INSERT INTO `zsj_district` VALUES (130108, '裕华区', 3, 130100);
INSERT INTO `zsj_district` VALUES (130109, '藁城区', 3, 130100);
INSERT INTO `zsj_district` VALUES (130110, '鹿泉区', 3, 130100);
INSERT INTO `zsj_district` VALUES (130111, '栾城区', 3, 130100);
INSERT INTO `zsj_district` VALUES (130121, '井陉县', 3, 130100);
INSERT INTO `zsj_district` VALUES (130123, '正定县', 3, 130100);
INSERT INTO `zsj_district` VALUES (130125, '行唐县', 3, 130100);
INSERT INTO `zsj_district` VALUES (130126, '灵寿县', 3, 130100);
INSERT INTO `zsj_district` VALUES (130127, '高邑县', 3, 130100);
INSERT INTO `zsj_district` VALUES (130128, '深泽县', 3, 130100);
INSERT INTO `zsj_district` VALUES (130129, '赞皇县', 3, 130100);
INSERT INTO `zsj_district` VALUES (130130, '无极县', 3, 130100);
INSERT INTO `zsj_district` VALUES (130131, '平山县', 3, 130100);
INSERT INTO `zsj_district` VALUES (130132, '元氏县', 3, 130100);
INSERT INTO `zsj_district` VALUES (130133, '赵县', 3, 130100);
INSERT INTO `zsj_district` VALUES (130181, '辛集市', 3, 130100);
INSERT INTO `zsj_district` VALUES (130183, '晋州市', 3, 130100);
INSERT INTO `zsj_district` VALUES (130184, '新乐市', 3, 130100);
INSERT INTO `zsj_district` VALUES (130200, '唐山市', 2, 130000);
INSERT INTO `zsj_district` VALUES (130202, '路南区', 3, 130200);
INSERT INTO `zsj_district` VALUES (130203, '路北区', 3, 130200);
INSERT INTO `zsj_district` VALUES (130204, '古冶区', 3, 130200);
INSERT INTO `zsj_district` VALUES (130205, '开平区', 3, 130200);
INSERT INTO `zsj_district` VALUES (130207, '丰南区', 3, 130200);
INSERT INTO `zsj_district` VALUES (130208, '丰润区', 3, 130200);
INSERT INTO `zsj_district` VALUES (130209, '曹妃甸区', 3, 130200);
INSERT INTO `zsj_district` VALUES (130224, '滦南县', 3, 130200);
INSERT INTO `zsj_district` VALUES (130225, '乐亭县', 3, 130200);
INSERT INTO `zsj_district` VALUES (130227, '迁西县', 3, 130200);
INSERT INTO `zsj_district` VALUES (130229, '玉田县', 3, 130200);
INSERT INTO `zsj_district` VALUES (130281, '遵化市', 3, 130200);
INSERT INTO `zsj_district` VALUES (130283, '迁安市', 3, 130200);
INSERT INTO `zsj_district` VALUES (130284, '滦州市', 3, 130200);
INSERT INTO `zsj_district` VALUES (130300, '秦皇岛市', 2, 130000);
INSERT INTO `zsj_district` VALUES (130302, '海港区', 3, 130300);
INSERT INTO `zsj_district` VALUES (130303, '山海关区', 3, 130300);
INSERT INTO `zsj_district` VALUES (130304, '北戴河区', 3, 130300);
INSERT INTO `zsj_district` VALUES (130306, '抚宁区', 3, 130300);
INSERT INTO `zsj_district` VALUES (130321, '青龙满族自治县', 3, 130300);
INSERT INTO `zsj_district` VALUES (130322, '昌黎县', 3, 130300);
INSERT INTO `zsj_district` VALUES (130324, '卢龙县', 3, 130300);
INSERT INTO `zsj_district` VALUES (130400, '邯郸市', 2, 130000);
INSERT INTO `zsj_district` VALUES (130402, '邯山区', 3, 130400);
INSERT INTO `zsj_district` VALUES (130403, '丛台区', 3, 130400);
INSERT INTO `zsj_district` VALUES (130404, '复兴区', 3, 130400);
INSERT INTO `zsj_district` VALUES (130406, '峰峰矿区', 3, 130400);
INSERT INTO `zsj_district` VALUES (130407, '肥乡区', 3, 130400);
INSERT INTO `zsj_district` VALUES (130408, '永年区', 3, 130400);
INSERT INTO `zsj_district` VALUES (130423, '临漳县', 3, 130400);
INSERT INTO `zsj_district` VALUES (130424, '成安县', 3, 130400);
INSERT INTO `zsj_district` VALUES (130425, '大名县', 3, 130400);
INSERT INTO `zsj_district` VALUES (130426, '涉县', 3, 130400);
INSERT INTO `zsj_district` VALUES (130427, '磁县', 3, 130400);
INSERT INTO `zsj_district` VALUES (130430, '邱县', 3, 130400);
INSERT INTO `zsj_district` VALUES (130431, '鸡泽县', 3, 130400);
INSERT INTO `zsj_district` VALUES (130432, '广平县', 3, 130400);
INSERT INTO `zsj_district` VALUES (130433, '馆陶县', 3, 130400);
INSERT INTO `zsj_district` VALUES
评论0