IOT/Doc/协议文档/org.sql

/*
Navicat MySQL Data Transfer

Source Server         : 192.168.0.101
Source Server Version : 50730
Source Host           : 192.168.0.101:3306
Source Database       : dcdsm

Target Server Type    : MYSQL
Target Server Version : 50730
File Encoding         : 65001

Date: 2022-02-23 19:49:20
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for org
-- ----------------------------
DROP TABLE IF EXISTS `org`;
CREATE TABLE `org` (
  `org_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '机构id',
  `name` varchar(100) NOT NULL COMMENT '机构名称',
  `parent_id` int(11) NOT NULL COMMENT '父类机构id',
  `code` varchar(10) DEFAULT NULL,
  `code_path` varchar(100) DEFAULT NULL,
  `province` int(20) DEFAULT NULL,
  `city` int(20) DEFAULT NULL,
  `district` int(20) DEFAULT NULL,
  `simple_name` varchar(20) NOT NULL COMMENT '机构名称简写',
  `description` varchar(500) DEFAULT NULL COMMENT '描述',
  `is_del` int(1) NOT NULL COMMENT '是否删除，0：未删除；1：已删除。',
  PRIMARY KEY (`org_id`),
  UNIQUE KEY `code_path` (`code_path`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=230 DEFAULT CHARSET=utf8 COMMENT='机构表';

-- ----------------------------
-- Records of org
-- ----------------------------
INSERT INTO `org` VALUES ('1', '建邺区', '8', '01', '01-01-01-01', '320000', '320100', '320105', '建邺区', '', '0');
INSERT INTO `org` VALUES ('2', '莫愁湖街道', '1', '01', '01-01-01-01-01', '320000', '320100', '320105', '莫愁湖街道', '', '0');
INSERT INTO `org` VALUES ('3', '兴隆街道', '1', '02', '01-01-01-01-02', '320000', '320100', '320105', '兴隆街道', '', '0');
INSERT INTO `org` VALUES ('4', '南苑街道', '1', '03', '01-01-01-01-03', '320000', '320100', '320105', '南苑街道', '', '0');
INSERT INTO `org` VALUES ('5', '沙洲街道', '1', '04', '01-01-01-01-04', '320000', '320100', '320105', '沙洲街道', '', '0');
INSERT INTO `org` VALUES ('6', '双闸街道', '1', '05', '01-01-01-01-05', '320000', '320100', '320105', '双闸街道', '', '0');
INSERT INTO `org` VALUES ('7', '江心洲街道', '1', '06', '01-01-01-01-06', '320000', '320100', '320105', '江心洲街道', '', '0');
INSERT INTO `org` VALUES ('8', '南京市', '117', '01', '01-01-01', '320000', '320100', null, '南京市', '', '0');
INSERT INTO `org` VALUES ('9', '江宁区', '8', '02', '01-01-01-02', '320000', '320100', '320115', '江宁区', '', '0');
INSERT INTO `org` VALUES ('10', '东山街道', '9', '01', '01-01-01-02-01', '320000', '320100', '320115', '东山街道', '', '1');
INSERT INTO `org` VALUES ('11', '秣陵街道', '9', '02', '01-01-01-02-02', '320000', '320100', '320115', '秣陵街道', '', '1');
INSERT INTO `org` VALUES ('12', '汤山街道', '9', '03', '01-01-01-02-03', '320000', '320100', '320115', '汤山街道', '', '1');
INSERT INTO `org` VALUES ('13', '淳化街道', '9', '04', '01-01-01-02-04', '320000', '320100', '320115', '淳化街道', '', '1');
INSERT INTO `org` VALUES ('14', '禄口街道', '9', '05', '01-01-01-02-05', '320000', '320100', '320115', '禄口街道', '', '1');
INSERT INTO `org` VALUES ('15', '江宁街道', '9', '06', '01-01-01-02-06', '320000', '320100', '320115', '江宁街道', '', '1');
INSERT INTO `org` VALUES ('16', '谷里街道', '9', '07', '01-01-01-02-07', '320000', '320100', '320115', '谷里街道', '', '1');
INSERT INTO `org` VALUES ('17', '湖熟街道', '9', '08', '01-01-01-02-08', '320000', '320100', '320115', '湖熟街道', '', '1');
INSERT INTO `org` VALUES ('18', '横溪街道', '9', '09', '01-01-01-02-09', '320000', '320100', '320115', '横溪街道', '', '1');
INSERT INTO `org` VALUES ('19', '麒麟街道', '9', '10', '01-01-01-02-10', '320000', '320100', '320115', '麒麟街道', '', '1');
INSERT INTO `org` VALUES ('20', '玄武区', '8', '03', '01-01-01-03', '320000', '320100', '320102', '玄武区', '', '0');
INSERT INTO `org` VALUES ('21', '梅园新村街道', '20', '01', '01-01-01-03-01', '320000', '320100', '320102', '梅园新村街道', '  ', '1');
INSERT INTO `org` VALUES ('22', '新街口街道', '20', '02', '01-01-01-03-02', '320000', '320100', '320102', '新街口街道', ' ', '1');
INSERT INTO `org` VALUES ('23', '玄武门街道', '20', '03', '01-01-01-03-03', '320000', '320100', '320102', '玄武门街道', ' ', '1');
INSERT INTO `org` VALUES ('24', '锁金村街道', '20', '04', '01-01-01-03-04', '320000', '320100', '320102', '锁金村街道', ' ', '1');
INSERT INTO `org` VALUES ('25', '红山街道', '20', '05', '01-01-01-03-05', '320000', '320100', '320102', '红山街道', ' ', '1');
INSERT INTO `org` VALUES ('26', '孝陵卫街道', '20', '06', '01-01-01-03-06', '320000', '320100', '320102', '孝陵卫街道', ' ', '1');
INSERT INTO `org` VALUES ('27', '玄武湖街道', '20', '07', '01-01-01-03-07', '320000', '320100', '320102', '玄武湖街道', ' ', '1');
INSERT INTO `org` VALUES ('28', '秦淮区', '8', '04', '01-01-01-04', '320000', '320100', '320104', '秦淮区', ' ', '0');
INSERT INTO `org` VALUES ('29', '秦虹街道', '28', '01', '01-01-01-04-01', '320000', '320100', '320104', '秦虹街道', ' ', '1');
INSERT INTO `org` VALUES ('30', '夫子庙街道', '28', '02', '01-01-01-04-02', '320000', '320100', '320104', '夫子庙街道', ' ', '1');
INSERT INTO `org` VALUES ('31', '红花街道', '28', '03', '01-01-01-04-03', '320000', '320100', '320104', '红花街道', ' ', '1');
INSERT INTO `org` VALUES ('32', '双塘街道', '28', '04', '01-01-01-04-04', '320000', '320100', '320104', '双塘街道', ' ', '1');
INSERT INTO `org` VALUES ('33', '中华门街道', '28', '05', '01-01-01-04-05', '320000', '320100', '320104', '中华门街道', ' ', '1');
INSERT INTO `org` VALUES ('34', '五老村街道', '28', '06', '01-01-01-04-06', '320000', '320100', '320104', '五老村街道', ' ', '1');
INSERT INTO `org` VALUES ('35', '洪武路街道', '28', '07', '01-01-01-04-07', '320000', '320100', '320104', '洪武路街道', ' ', '1');
INSERT INTO `org` VALUES ('36', '大光路街道', '28', '08', '01-01-01-04-08', '320000', '320100', '320104', '大光路街道', ' ', '1');
INSERT INTO `org` VALUES ('37', '瑞金路街道', '28', '09', '01-01-01-04-09', '320000', '320100', '320104', '瑞金路街道', ' ', '1');
INSERT INTO `org` VALUES ('38', '月牙湖街道', '20', '10', '01-01-01-03-10', '320000', '320100', '320104', '月牙湖街道', ' ', '1');
INSERT INTO `org` VALUES ('39', '光华路街道', '28', '11', '01-01-01-04-11', '320000', '320100', '320104', '光华路街道', ' ', '1');
INSERT INTO `org` VALUES ('40', '月牙湖街道', '28', '10', '01-01-01-04-10', '320000', '320100', '320104', '月牙湖街道', ' ', '1');
INSERT INTO `org` VALUES ('41', '朝天宫街道', '28', '12', '01-01-01-04-12', '320000', '320100', '320104', '朝天宫街道', ' ', '1');
INSERT INTO `org` VALUES ('42', '鼓楼区', '8', '05', '01-01-01-05', '320000', '320100', '320106', '鼓楼区', ' ', '0');
INSERT INTO `org` VALUES ('43', '宁海路街道', '42', '01', '01-01-01-05-01', '320000', '320100', '320106', '宁海路街道', ' ', '1');
INSERT INTO `org` VALUES ('44', '华侨路街道', '42', '02', '01-01-01-05-02', '320000', '320100', '320106', '华侨路街道', ' ', '1');
INSERT INTO `org` VALUES ('45', '湖南路街道', '42', '03', '01-01-01-05-03', '320000', '320100', '320106', '湖南路街道', ' ', '1');
INSERT INTO `org` VALUES ('46', '中央门街道', '42', '04', '01-01-01-05-04', '320000', '320100', '320106', '中央门街道', ' ', '1');
INSERT INTO `org` VALUES ('47', '挹江门街道', '42', '05', '01-01-01-05-05', '320000', '320100', '320106', '挹江门街道', ' ', '1');
INSERT INTO `org` VALUES ('48', '江东街道', '42', '06', '01-01-01-05-06', '320000', '320100', '320106', '江东街道', ' ', '1');
INSERT INTO `org` VALUES ('49', '凤凰街道', '42', '07', '01-01-01-05-07', '320000', '320100', '320106', '凤凰街道', ' ', '1');
INSERT INTO `org` VALUES ('50', '阅江楼街道', '42', '08', '01-01-01-05-08', '320000', '320100', '320106', '阅江楼街道', ' ', '1');
INSERT INTO `org` VALUES ('51', '热河南路街道', '42', '09', '01-01-01-05-09', '320000', '320100', '320106', '热河南路街道', ' ', '1');
INSERT INTO `org` VALUES ('52', '幕府山街道', '42', '10', '01-01-01-05-10', '320000', '320100', '320106', '幕府山街道', ' ', '1');
INSERT INTO `org` VALUES ('53', '建宁路街道', '42', '11', '01-01-01-05-11', '320000', '320100', '320106', '建宁路街道', ' ', '1');
INSERT INTO `org` VALUES ('54', '宝塔桥街道', '42', '12', '01-01-01-05-12', '320000', '320100', '320106', '宝塔桥街道', ' ', '1');
INSERT INTO `org` VALUES ('55', '小市街道', '42', '13', '01-01-01-05-13', '320000', '320100', '320106', '小市街道', ' ', '1');
INSERT INTO `org` VALUES ('56', '栖霞区', '8', '06', '01-01-01-06', '320000', '320100', '320113', '栖霞区', ' ', '0');
INSERT INTO `org` VALUES ('57', '尧化街道', '56', '01', '01-01-01-06-01', '320000', '320100', '320113', '尧化街道', ' ', '1');
INSERT INTO `org` VALUES ('58', '马群街道', '56', '02', '01-01-01-06-02', '320000', '320100', '320113', '马群街道', ' ', '1');
INSERT INTO `org` VALUES ('59', '迈皋桥街道', '56', '03', '01-01-01-06-03', '320000', '320100', '320113', '迈皋桥街道', ' ', '1');
INSERT INTO `org` VALUES ('60', '燕子矶街道', '56', '04', '01-01-01-06-04', '320000', '320100', '320113', '燕子矶街道', ' ', '1');
INSERT INTO `org` VALUES ('61', '栖霞街道', '56', '05', '01-01-01-06-05', '320000', '320100', '320113', '栖霞街道', ' ', '1');
INSERT INTO `org` VALUES ('62', '龙潭街道', '56', '06', '01-01-01-06-06', '320000', '320100', '320113', '龙潭街道', ' ', '1');
INSERT INTO `org` VALUES ('63', '仙林街道', '56', '07', '01-01-01-06-07', '320000', '320100', '320113', '仙林街道', ' ', '1');
INSERT INTO `org` VALUES ('64', '八卦洲街道', '56', '08', '01-01-01-06-08', '320000', '320100', '320113', '八卦洲街道', ' ', '1');
INSERT INTO `org` VALUES ('65', '西岗街道', '56', '09', '01-01-01-06-09', '320000', '320100', '320113', '西岗街道', ' ', '1');
INSERT INTO `org` VALUES ('66', '雨花台区', '8', '07', '01-01-01-07', '320000', '320100', '320114', '雨花台区', ' ', '0');
INSERT INTO `org` VALUES ('67', '雨花街道', '66', '01', '01-01-01-07-01', '320000', '320100', '320114', '雨花街道', ' ', '0');
INSERT INTO `org` VALUES ('68', '赛虹桥街道', '66', '02', '01-01-01-07-02', '320000', '320100', '320114', '赛虹桥街道', ' ', '0');
INSERT INTO `org` VALUES ('69', '西善桥街道', '66', '03', '01-01-01-07-03', '320000', '320100', '320114', '西善桥街道', ' ', '0');
INSERT INTO `org` VALUES ('70', '板桥街道', '66', '04', '01-01-01-07-04', '320000', '320100', '320114', '板桥街道', ' ', '0');
INSERT INTO `org` VALUES ('71', '铁心桥街道', '66', '05', '01-01-01-07-05', '320000', '320100', '320114', '铁心桥街道', ' ', '0');
INSERT INTO `org` VALUES ('72', '梅山街道', '66', '06', '01-01-01-07-06', '320000', '320100', '320114', '梅山街道', ' ', '0');
INSERT INTO `org` VALUES ('73', '雨花经济开发区', '66', '07', '01-01-01-07-07', '320000', '320100', '320114', '雨花经济开发区', ' ', '0');
INSERT INTO `org` VALUES ('74', '板桥新城', '66', '08', '01-01-01-07-08', '320000', '320100', '320114', '板桥新城', ' ', '0');
INSERT INTO `org` VALUES ('75', '浦口区', '8', '08', '01-01-01-08', '320000', '320100', '320111', '浦口区', ' ', '0');
INSERT INTO `org` VALUES ('76', '泰山街道', '75', '01', '01-01-01-08-01', '320000', '320100', '320111', '泰山街道', ' ', '1');
INSERT INTO `org` VALUES ('77', '顶山街道', '75', '02', '01-01-01-08-02', '320000', '320100', '320111', '顶山街道', ' ', '1');
INSERT INTO `org` VALUES ('78', '沿江街道', '75', '03', '01-01-01-08-03', '320000', '320100', '320111', '沿江街道', ' ', '1');
INSERT INTO `org` VALUES ('79', '江浦街道', '75', '04', '01-01-01-08-04', '320000', '320100', '320111', '江浦街道', ' ', '1');
INSERT INTO `org` VALUES ('80', '桥林街道', '75', '05', '01-01-01-08-05', '320000', '320100', '320111', '桥林街道', ' ', '1');
INSERT INTO `org` VALUES ('81', '汤泉街道', '75', '06', '01-01-01-08-06', '320000', '320100', '320111', '汤泉街道', ' ', '1');
INSERT INTO `org` VALUES ('82', '盘城街道', '75', '07', '01-01-01-08-07', '320000', '320100', '320111', '盘城街道', ' ', '1');
INSERT INTO `org` VALUES ('83', '星甸街道', '75', '08', '01-01-01-08-08', '320000', '320100', '320111', '星甸街道', ' ', '1');
INSERT INTO `org` VALUES ('84', '永宁街道', '75', '09', '01-01-01-08-09', '320000', '320100', '320111', '永宁街道', ' ', '1');
INSERT INTO `org` VALUES ('85', '六合区', '8', '09', '01-01-01-09', '320000', '320100', '320116', '六合区', ' ', '0');
INSERT INTO `org` VALUES ('86', '大厂街道', '85', '01', '01-01-01-09-01', '320000', '320100', '320116', '大厂街道', ' ', '1');
INSERT INTO `org` VALUES ('87', '葛塘街道', '85', '02', '01-01-01-09-02', '320000', '320100', '320116', '葛塘街道', ' ', '1');
INSERT INTO `org` VALUES ('88', '长芦街道', '85', '03', '01-01-01-09-03', '320000', '320100', '320116', '长芦街道', ' ', '1');
INSERT INTO `org` VALUES ('89', '雄州街道', '85', '04', '01-01-01-09-04', '320000', '320100', '320116', '雄州街道', ' ', '1');
INSERT INTO `org` VALUES ('90', '龙池街道', '85', '05', '01-01-01-09-05', '320000', '320100', '320116', '龙池街道', ' ', '1');
INSERT INTO `org` VALUES ('91', '程桥街道', '85', '06', '01-01-01-09-06', '320000', '320100', '320116', '程桥街道', ' ', '1');
INSERT INTO `org` VALUES ('92', '金牛湖街道', '85', '07', '01-01-01-09-07', '320000', '320100', '320116', '金牛湖街道', ' ', '1');
INSERT INTO `org` VALUES ('93', '横梁街道', '85', '08', '01-01-01-09-08', '320000', '320100', '320116', '横梁街道', ' ', '1');
INSERT INTO `org` VALUES ('94', '龙袍街道', '85', '09', '01-01-01-09-09', '320000', '320100', '320116', '龙袍街道', ' ', '1');
INSERT INTO `org` VALUES ('95', '马鞍街道', '85', '10', '01-01-01-09-10', '320000', '320100', '320116', '马鞍街道', ' ', '1');
INSERT INTO `org` VALUES ('96', '冶山街道', '85', '11', '01-01-01-09-11', '320000', '320100', '320116', '冶山街道', ' ', '1');
INSERT INTO `org` VALUES ('97', '竹镇镇', '85', '12', '01-01-01-09-12', '320000', '320100', '320116', '竹镇镇', ' ', '1');
INSERT INTO `org` VALUES ('98', '溧水区', '8', '10', '01-01-01-10', '320000', '320100', '320117', '溧水区', ' ', '0');
INSERT INTO `org` VALUES ('99', '永阳街道', '98', '01', '01-01-01-10-01', '320000', '320100', '320117', '永阳街道', ' ', '1');
INSERT INTO `org` VALUES ('100', '白马镇', '98', '02', '01-01-01-10-02', '320000', '320100', '320117', '白马镇', ' ', '1');
INSERT INTO `org` VALUES ('101', '东屏街道', '98', '03', '01-01-01-10-03', '320000', '320100', '320117', '东屏街道', ' ', '1');
INSERT INTO `org` VALUES ('102', '柘塘街道', '98', '04', '01-01-01-10-04', '320000', '320100', '320117', '柘塘街道', ' ', '1');
INSERT INTO `org` VALUES ('103', '石湫街道', '98', '05', '01-01-01-10-05', '320000', '320100', '320117', '石湫街道', ' ', '1');
INSERT INTO `org` VALUES ('104', '洪蓝街道', '98', '06', '01-01-01-10-06', '320000', '320100', '320117', '洪蓝街道', ' ', '1');
INSERT INTO `org` VALUES ('105', '晶桥镇', '98', '07', '01-01-01-10-07', '320000', '320100', '320117', '晶桥镇', ' ', '1');
INSERT INTO `org` VALUES ('106', '和凤镇', '98', '08', '01-01-01-10-08', '320000', '320100', '320117', '和凤镇', ' ', '1');
INSERT INTO `org` VALUES ('107', '高淳区', '8', '11', '01-01-01-11', '320000', '320100', '320118', '高淳区', ' ', '0');
INSERT INTO `org` VALUES ('108', '淳溪街道', '107', '01', '01-01-01-11-01', '320000', '320100', '320118', '淳溪街道', ' ', '1');
INSERT INTO `org` VALUES ('109', '古柏街道', '107', '02', '01-01-01-11-02', '320000', '320100', '320118', '古柏街道', ' ', '1');
INSERT INTO `org` VALUES ('110', '阳江镇', '107', '03', '01-01-01-11-03', '320000', '320100', '320118', '阳江镇', ' ', '1');
INSERT INTO `org` VALUES ('111', '砖墙镇', '107', '04', '01-01-01-11-04', '320000', '320100', '320118', '砖墙镇', ' ', '1');
INSERT INTO `org` VALUES ('112', '固城街道', '107', '05', '01-01-01-11-05', '320000', '320100', '320118', '固城街道', ' ', '1');
INSERT INTO `org` VALUES ('113', '漆桥街道', '107', '06', '01-01-01-11-06', '320000', '320100', '320118', '漆桥街道', ' ', '1');
INSERT INTO `org` VALUES ('114', '东坝街道', '107', '07', '01-01-01-11-07', '320000', '320100', '320118', '东坝街道', ' ', '1');
INSERT INTO `org` VALUES ('115', '桠溪街道', '107', '08', '01-01-01-11-08', '320000', '320100', '320118', '桠溪街道', ' ', '1');
INSERT INTO `org` VALUES ('116', '全国', '0', '01', '01', '320000', '320100', '320102', '全国', '', '0');
INSERT INTO `org` VALUES ('117', '江苏省', '116', '01', '01-01', '320000', '320100', null, '江苏', '', '0');
INSERT INTO `org` VALUES ('118', '苏州市', '117', '02', '01-01-02', '320000', '320500', null, '苏州', '', '0');
INSERT INTO `org` VALUES ('119', '相城区', '118', '01', '01-01-02-01', '320000', '320500', '320507', '相城区', '', '0');
INSERT INTO `org` VALUES ('120', '假日街道', '119', '01', '01-01-02-01-01', '320000', '320500', '320507', '美京假日', '', '0');
INSERT INTO `org` VALUES ('121', '广东省', '116', '02', '01-02', '440000', '440100', null, '广东', '', '0');
INSERT INTO `org` VALUES ('122', '东莞市', '121', '01', '01-02-01', '440000', '441900', null, '东莞', '', '0');
INSERT INTO `org` VALUES ('123', '莞城', '122', '01', '01-02-01-01', '440000', '441900', null, '莞城', '', '0');
INSERT INTO `org` VALUES ('124', '石龙', '122', '02', '01-02-01-02', '440000', '441900', null, '石龙', '', '0');
INSERT INTO `org` VALUES ('125', '虎门', '122', '03', '01-02-01-03', '440000', '441900', null, '虎门', '', '0');
INSERT INTO `org` VALUES ('126', '东城', '122', '04', '01-02-01-04', '440000', '441900', null, '东城', '', '0');
INSERT INTO `org` VALUES ('127', '万江', '122', '05', '01-02-01-05', '440000', '441900', null, '万江', '', '0');
INSERT INTO `org` VALUES ('128', '南城', '122', '06', '01-02-01-06', '440000', '441900', null, '南城', '', '0');
INSERT INTO `org` VALUES ('129', '中堂', '122', '07', '01-02-01-07', '440000', '441900', null, '中堂', '', '0');
INSERT INTO `org` VALUES ('130', '望牛墩', '122', '08', '01-02-01-08', '440000', '441900', null, '望牛墩', '', '0');
INSERT INTO `org` VALUES ('131', '麻涌', '122', '09', '01-02-01-09', '440000', '441900', null, '麻涌', '', '0');
INSERT INTO `org` VALUES ('132', '石碣', '122', '10', '01-02-01-10', '440000', '441900', null, '石碣', '', '0');
INSERT INTO `org` VALUES ('133', '高埗', '122', '11', '01-02-01-11', '440000', '441900', null, '高埗', '', '0');
INSERT INTO `org` VALUES ('134', '洪梅', '122', '12', '01-02-01-12', '440000', '441900', null, '洪梅', '', '0');
INSERT INTO `org` VALUES ('135', '道滘', '122', '13', '01-02-01-13', '440000', '441900', null, '道滘', '', '0');
INSERT INTO `org` VALUES ('136', '厚街', '122', '14', '01-02-01-14', '440000', '441900', null, '厚街', '', '0');
INSERT INTO `org` VALUES ('137', '沙田', '122', '15', '01-02-01-15', '440000', '441900', null, '沙田', '', '0');
INSERT INTO `org` VALUES ('138', '长安', '122', '16', '01-02-01-16', '440000', '441900', null, '长安', '', '0');
INSERT INTO `org` VALUES ('139', '寮步', '122', '17', '01-02-01-17', '440000', '441900', null, '寮步', '', '0');
INSERT INTO `org` VALUES ('140', '大岭山', '122', '18', '01-02-01-18', '440000', '441900', null, '大岭山', '', '0');
INSERT INTO `org` VALUES ('141', '大朗', '122', '19', '01-02-01-19', '440000', '441900', null, '大朗', '', '0');
INSERT INTO `org` VALUES ('142', '黄江', '122', '20', '01-02-01-20', '440000', '441900', null, '黄江', '', '0');
INSERT INTO `org` VALUES ('143', '樟木头', '122', '21', '01-02-01-21', '440000', '441900', null, '樟木头', '', '0');
INSERT INTO `org` VALUES ('144', '凤岗', '122', '22', '01-02-01-22', '440000', '441900', null, '凤岗', '', '0');
INSERT INTO `org` VALUES ('145', '塘厦', '122', '23', '01-02-01-23', '440000', '441900', null, '塘厦', '', '0');
INSERT INTO `org` VALUES ('146', '谢岗', '122', '24', '01-02-01-24', '440000', '441900', null, '谢岗', '', '0');
INSERT INTO `org` VALUES ('147', '清溪', '122', '25', '01-02-01-25', '440000', '441900', null, '清溪', '', '0');
INSERT INTO `org` VALUES ('148', '常平', '122', '26', '01-02-01-26', '440000', '441900', null, '常平', '', '0');
INSERT INTO `org` VALUES ('149', '桥头', '122', '27', '01-02-01-27', '440000', '441900', null, '桥头', '', '0');
INSERT INTO `org` VALUES ('150', '横沥', '122', '28', '01-02-01-28', '440000', '441900', null, '横沥', '', '0');
INSERT INTO `org` VALUES ('151', '东坑', '122', '29', '01-02-01-29', '440000', '441900', null, '东坑', '', '0');
INSERT INTO `org` VALUES ('152', '企石', '122', '30', '01-02-01-30', '440000', '441900', null, '企石', '', '0');
INSERT INTO `org` VALUES ('153', '石排', '122', '31', '01-02-01-31', '440000', '441900', null, '石排', '', '0');
INSERT INTO `org` VALUES ('154', '茶山', '122', '32', '01-02-01-32', '440000', '441900', null, '茶山', '', '0');
INSERT INTO `org` VALUES ('155', '盐城市', '117', '03', '01-01-03', '320000', '320900', null, '盐城市', '', '0');
INSERT INTO `org` VALUES ('156', '亭湖区', '155', '01', '01-01-03-01', '320000', '320900', '320902', '亭湖', '', '0');
INSERT INTO `org` VALUES ('157', '河南省', '116', '03', '01-03', '410000', '410100', null, '河南', '', '0');
INSERT INTO `org` VALUES ('158', '洛阳市', '157', '01', '01-03-01', '410000', '410300', null, '洛阳', '', '0');
INSERT INTO `org` VALUES ('159', '涧西区', '158', '01', '01-03-01-01', '410000', '410300', '410305', '涧西区', '', '0');
INSERT INTO `org` VALUES ('160', '西工区', '158', '02', '01-03-01-02', '410000', '410300', '410303', '西工区', '', '0');
INSERT INTO `org` VALUES ('161', '老城区', '158', '03', '01-03-01-03', '410000', '410300', '410302', '老城区', '', '0');
INSERT INTO `org` VALUES ('162', '瀍河回族区', '158', '04', '01-03-01-04', '410000', '410300', '410304', '瀍河回族区', '', '0');
INSERT INTO `org` VALUES ('163', '洛龙区', '158', '05', '01-03-01-05', '410000', '410300', '410311', '洛龙区 	', '', '0');
INSERT INTO `org` VALUES ('164', '偃师区', '158', '06', '01-03-01-06', '410000', '410300', '410381', '偃师区', '', '0');
INSERT INTO `org` VALUES ('165', '孟津区', '158', '07', '01-03-01-07', '410000', '410300', '410322', '孟津区', '', '0');
INSERT INTO `org` VALUES ('166', '新安县', '158', '08', '01-03-01-08', '410000', '410300', '410323', '新安县', '', '0');
INSERT INTO `org` VALUES ('167', '宜阳县', '158', '09', '01-03-01-09', '410000', '410300', '410327', '宜阳县', '', '0');
INSERT INTO `org` VALUES ('168', '伊川县', '158', '10', '01-03-01-10', '410000', '410300', '410329', '伊川县', '', '0');
INSERT INTO `org` VALUES ('169', '洛宁县', '158', '11', '01-03-01-11', '410000', '410300', '410328', '洛宁县', '', '0');
INSERT INTO `org` VALUES ('170', '嵩县', '158', '12', '01-03-01-12', '410000', '410300', '410325', '嵩县', '', '0');
INSERT INTO `org` VALUES ('171', '栾川县', '158', '13', '01-03-01-13', '410000', '410300', '410324', '栾川县', '', '0');
INSERT INTO `org` VALUES ('172', '汝阳县', '158', '14', '01-03-01-14', '410000', '410300', '410326', '汝阳县', '', '0');
INSERT INTO `org` VALUES ('173', '盐都区', '155', '02', '01-01-03-02', '320000', '320900', '320903', '盐都', '', '0');
INSERT INTO `org` VALUES ('174', '湖北省', '116', '04', '01-04', '420000', '420100', null, '湖北', '111', '0');
INSERT INTO `org` VALUES ('175', '武汉市', '174', '01', '01-04-01', '420000', '420100', null, '武汉', '', '0');
INSERT INTO `org` VALUES ('176', '江岸区', '175', '01', '01-04-01-01', '420000', '420100', '420102', '江岸区', '', '0');
INSERT INTO `org` VALUES ('177', '广州市', '121', '02', '01-02-02', '440000', '440100', null, '广州', '', '0');
INSERT INTO `org` VALUES ('178', '越秀区', '177', '01', '01-02-02-01', '440000', '440100', '440104', '越秀区', '', '0');
INSERT INTO `org` VALUES ('179', '荔湾区', '177', '02', '01-02-02-02', '440000', '440100', '440103', '荔湾区', '', '0');
INSERT INTO `org` VALUES ('180', '海珠区', '177', '03', '01-02-02-03', '440000', '440100', '440105', '海珠区', '', '0');
INSERT INTO `org` VALUES ('181', '天河区', '177', '04', '01-02-02-04', '440000', '440100', '440106', '天河区', '', '0');
INSERT INTO `org` VALUES ('182', '白云区', '177', '05', '01-02-02-05', '440000', '440100', '440111', '白云区', '', '0');
INSERT INTO `org` VALUES ('183', '黄埔区', '177', '06', '01-02-02-06', '440000', '440100', '440112', '黄埔区', '', '0');
INSERT INTO `org` VALUES ('184', '番禺区', '177', '07', '01-02-02-07', '440000', '440100', '440113', '番禺区', '', '0');
INSERT INTO `org` VALUES ('185', '花都区', '177', '08', '01-02-02-08', '440000', '440100', '440114', '花都区', '', '0');
INSERT INTO `org` VALUES ('186', '南沙区', '177', '09', '01-02-02-09', '440000', '440100', '440115', '南沙区', '', '0');
INSERT INTO `org` VALUES ('187', '增城区', '177', '10', '01-02-02-10', '440000', '440100', '440118', '增城区', '', '0');
INSERT INTO `org` VALUES ('188', '从化区', '177', '11', '01-02-02-11', '440000', '440100', '440117', '从化区', '', '0');
INSERT INTO `org` VALUES ('189', '江汉区', '175', '02', '01-04-01-02', '420000', '420100', '420103', '江汉区', '', '0');
INSERT INTO `org` VALUES ('190', '硚口区', '175', '03', '01-04-01-03', '420000', '420100', '420104', '硚口区', '', '0');
INSERT INTO `org` VALUES ('191', '汉阳区', '175', '04', '01-04-01-04', '420000', '420100', '420105', '汉阳区', '', '0');
INSERT INTO `org` VALUES ('192', '武昌区', '175', '05', '01-04-01-05', '420000', '420100', '420106', '武昌区', '', '0');
INSERT INTO `org` VALUES ('193', '青山区', '175', '06', '01-04-01-06', '420000', '420100', '420107', '青山区', '', '0');
INSERT INTO `org` VALUES ('194', '洪山区', '175', '07', '01-04-01-07', '420000', '420100', '420111', '洪山区', '', '0');
INSERT INTO `org` VALUES ('195', '东西湖区', '175', '08', '01-04-01-08', '420000', '420100', '420112', '东西湖区', '', '0');
INSERT INTO `org` VALUES ('196', '汉南区', '175', '09', '01-04-01-09', '420000', '420100', '420113', '汉南区', '', '0');
INSERT INTO `org` VALUES ('197', '蔡甸区', '175', '10', '01-04-01-10', '420000', '420100', '420114', '蔡甸区', '', '0');
INSERT INTO `org` VALUES ('198', '江夏区', '175', '11', '01-04-01-11', '420000', '420100', '420115', '江夏区', '', '0');
INSERT INTO `org` VALUES ('199', '黄陂区', '175', '12', '01-04-01-12', '420000', '420100', '420116', '黄陂区', '', '0');
INSERT INTO `org` VALUES ('200', '新洲区', '175', '13', '01-04-01-13', '420000', '420100', '420117', '新洲区', '', '0');
INSERT INTO `org` VALUES ('201', '泰州市', '117', '04', '01-01-04', '320000', '321200', null, '泰州', '', '0');
INSERT INTO `org` VALUES ('202', '姜堰区', '201', '01', '01-01-04-01', '320000', '321200', '321204', '姜堰区', '', '0');
INSERT INTO `org` VALUES ('206', '安徽省', '116', '05', '01-05', '340000', '340100', null, '安徽', '', '0');
INSERT INTO `org` VALUES ('207', '滁州市', '206', '01', '01-05-01', '340000', '341100', null, '滁州', '', '0');
INSERT INTO `org` VALUES ('208', '琅琊区', '207', '01', '01-05-01-01', '340000', '341100', '341102', '琅琊区', '', '0');
INSERT INTO `org` VALUES ('209', '琅琊街道', '208', '01', '01-05-01-01-01', '340000', '341100', '341102', '琅琊街道', '', '0');
INSERT INTO `org` VALUES ('211', '清流街道', '208', '02', '01-05-01-01-02', '340000', '341100', '341102', '清流街道', '', '0');
INSERT INTO `org` VALUES ('213', '宿迁市', '117', '05', '01-01-05', '320000', '321300', null, '宿迁', '', '0');