/*
 Navicat Premium Data Transfer

 Source Server         : mysql5.7
 Source Server Type    : MySQL
 Source Server Version : 50733
 Source Host           : localhost:3306
 Source Schema         : yssh

 Target Server Type    : MySQL
 Target Server Version : 50733
 File Encoding         : 65001

 Date: 31/10/2022 17:06:29
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for yssh_location
-- ----------------------------
DROP TABLE IF EXISTS `yssh_location`;
CREATE TABLE `yssh_location`  (
  `id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '序号',
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '名称',
  `type` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '类型',
  `longitude` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '经度',
  `latitude` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '纬度',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of yssh_location
-- ----------------------------
INSERT INTO `yssh_location` VALUES ('1', '裂解炉BA1103', '有组织排放', '115.9704', '39.73071944');
INSERT INTO `yssh_location` VALUES ('10', '烧焦尾气', '有组织排放', '115.9663306', '39.73056944');
INSERT INTO `yssh_location` VALUES ('100', '高压聚乙烯树脂装置聚乙烯料仓计量斗2H101D', '有组织排放', '115.9720306', '39.72956944');
INSERT INTO `yssh_location` VALUES ('101', '高压聚乙烯树脂装置聚乙烯料仓掺合器1H102A', '有组织排放', '115.9720111', '39.72968056');
INSERT INTO `yssh_location` VALUES ('102', '高压聚乙烯树脂装置聚乙烯料仓掺合器1H102B', '有组织排放', '115.9720111', '39.72963889');
INSERT INTO `yssh_location` VALUES ('103', '高压聚乙烯树脂装置聚乙烯料仓掺合器2H102A', '有组织排放', '115.9719694', '39.72976111');
INSERT INTO `yssh_location` VALUES ('104', '高压聚乙烯树脂装置聚乙烯料仓掺合器2H102B', '有组织排放', '115.9720306', '39.72961111');
INSERT INTO `yssh_location` VALUES ('105', '高压聚乙烯树脂装置离心分离器Z101', '有组织排放', '115.9720306', '39.7297');
INSERT INTO `yssh_location` VALUES ('106', '高压聚乙烯树脂装置离心分离器Z102', '有组织排放', '115.9719889', '39.72968056');
INSERT INTO `yssh_location` VALUES ('107', '高压聚乙烯树脂装置离心分离器Z104', '有组织排放', '115.9720306', '39.72968056');
INSERT INTO `yssh_location` VALUES ('108', '高压聚乙烯树脂装置离心分离器Z105', '有组织排放', '115.9720111', '39.72963889');
INSERT INTO `yssh_location` VALUES ('109', '第三聚丙烯装置F502B', '有组织排放', '115.9581306', '39.74366944');
INSERT INTO `yssh_location` VALUES ('11', '烧焦尾气', '有组织排放', '115.9663389', '39.73031944');
INSERT INTO `yssh_location` VALUES ('110', '第三聚丙烯装置F502C', '有组织排放', '115.9581306', '39.74368889');
INSERT INTO `yssh_location` VALUES ('111', '第三聚丙烯装置F502D', '有组织排放', '115.9581889', '39.74375');
INSERT INTO `yssh_location` VALUES ('112', '第三聚丙烯装置F503A', '有组织排放', '115.9587889', '39.74351944');
INSERT INTO `yssh_location` VALUES ('113', '第三聚丙烯装置F503B', '有组织排放', '115.9586611', '39.74356111');
INSERT INTO `yssh_location` VALUES ('114', '第三聚丙烯装置F503C', '有组织排放', '115.9586194', '39.74353889');
INSERT INTO `yssh_location` VALUES ('115', '第三聚丙烯装置F503D', '有组织排放', '115.9585111', '39.74351944');
INSERT INTO `yssh_location` VALUES ('116', '第三聚丙烯装置F503E', '有组织排放', '115.9587694', '39.7436');
INSERT INTO `yssh_location` VALUES ('117', '第三聚丙烯装置F503F', '有组织排放', '115.9586389', '39.74363056');
INSERT INTO `yssh_location` VALUES ('118', '第三聚丙烯装置F503G', '有组织排放', '115.9586194', '39.74363056');
INSERT INTO `yssh_location` VALUES ('119', '第三聚丙烯装置F503H', '有组织排放', '115.9585111', '39.74366944');
INSERT INTO `yssh_location` VALUES ('12', '烧焦尾气', '有组织排放', '115.9661', '39.73028056');
INSERT INTO `yssh_location` VALUES ('120', '第三聚丙烯装置F503J', '有组织排放', '115.9588111', '39.74373056');
INSERT INTO `yssh_location` VALUES ('121', '第三聚丙烯装置F503K', '有组织排放', '115.9586611', '39.74375');
INSERT INTO `yssh_location` VALUES ('122', '第三聚丙烯装置F503L', '有组织排放', '115.9585806', '39.74378056');
INSERT INTO `yssh_location` VALUES ('123', '第三聚丙烯装置F503M', '有组织排放', '115.9584694', '39.74381944');
INSERT INTO `yssh_location` VALUES ('124', '高压聚乙烯树脂装置聚乙烯料仓计量斗1H101A', '有组织排放', '115.9719694', '39.72976111');
INSERT INTO `yssh_location` VALUES ('125', '高压聚乙烯树脂装置聚乙烯料仓计量斗1H101B', '有组织排放', '115.9719389', '39.72976111');
INSERT INTO `yssh_location` VALUES ('126', '高压聚乙烯树脂装置聚乙烯料仓计量斗1H101C', '有组织排放', '115.9719389', '39.72973889');
INSERT INTO `yssh_location` VALUES ('127', '高压聚乙烯树脂装置聚乙烯料仓计量斗1H101D', '有组织排放', '115.9719889', '39.72973889');
INSERT INTO `yssh_location` VALUES ('128', '高压聚乙烯树脂装置聚乙烯料仓掺合器1H102A', '有组织排放', '115.9720111', '39.72968056');
INSERT INTO `yssh_location` VALUES ('129', '高压聚乙烯树脂装置聚乙烯料仓掺合器2H102B', '有组织排放', '115.9720306', '39.72961111');
INSERT INTO `yssh_location` VALUES ('13', '烧焦尾气', '有组织排放', '115.9661611', '39.73115');
INSERT INTO `yssh_location` VALUES ('130', '高压聚乙烯树脂装置聚乙烯料仓计量斗2H101A', '有组织排放', '115.9719694', '39.72976111');
INSERT INTO `yssh_location` VALUES ('131', '高压聚乙烯树脂装置聚乙烯料仓计量斗2H101B', '有组织排放', '115.9720111', '39.72966111');
INSERT INTO `yssh_location` VALUES ('132', '高压聚乙烯树脂装置聚乙烯料仓计量斗2H101C', '有组织排放', '115.9720111', '39.72961111');
INSERT INTO `yssh_location` VALUES ('133', '高压聚乙烯树脂装置聚乙烯料仓计量斗2H101D', '有组织排放', '115.9720306', '39.72956944');
INSERT INTO `yssh_location` VALUES ('134', '高压聚乙烯树脂装置聚乙烯料仓掺合器1H102B', '有组织排放', '115.9720111', '39.72963889');
INSERT INTO `yssh_location` VALUES ('135', '高压聚乙烯树脂装置聚乙烯料仓掺合器2H102A', '有组织排放', '115.9719694', '39.72976111');
INSERT INTO `yssh_location` VALUES ('136', '高压聚乙烯树脂装置聚乙烯料包装料仓3H201', '有组织排放', '115.97235', '39.72983056');
INSERT INTO `yssh_location` VALUES ('137', '高压聚乙烯树脂装置聚乙烯次品料仓OH-153', '有组织排放', '115.9720889', '39.72985');
INSERT INTO `yssh_location` VALUES ('138', '高压聚乙烯树脂装置聚乙烯次品料仓OH-161-2', '有组织排放', '115.9721806', '39.72978889');
INSERT INTO `yssh_location` VALUES ('139', '高压聚乙烯树脂装置聚乙烯次品料仓OH-161-3', '有组织排放', '115.9722389', '39.72983056');
INSERT INTO `yssh_location` VALUES ('14', '烧焦尾气', '有组织排放', '115.9705389', '39.73046944');
INSERT INTO `yssh_location` VALUES ('140', '高压聚乙烯树脂装置聚乙烯次品料仓OH-161-4', '有组织排放', '115.9722694', '39.72978889');
INSERT INTO `yssh_location` VALUES ('141', '高压聚乙烯树脂装置聚乙烯次品料仓OH-161-5', '有组织排放', '115.9722889', '39.72983056');
INSERT INTO `yssh_location` VALUES ('142', '高压聚乙烯树脂装置离心分离器Z101', '有组织排放', '115.9720306', '39.7297');
INSERT INTO `yssh_location` VALUES ('143', '高压聚乙烯树脂装置离心分离器Z102', '有组织排放', '115.9719889', '39.72968056');
INSERT INTO `yssh_location` VALUES ('144', '高压聚乙烯树脂装置离心分离器Z104', '有组织排放', '115.9720306', '39.72968056');
INSERT INTO `yssh_location` VALUES ('145', '高压聚乙烯树脂装置离心分离器Z105', '有组织排放', '115.9720111', '39.72963889');
INSERT INTO `yssh_location` VALUES ('146', '乙苯-苯乙烯装置挥发性有机液体常压储罐呼吸', '有组织排放', '115.9703111', '39.72676111');
INSERT INTO `yssh_location` VALUES ('147', 'TA020', '有组织排放', '115.9534889', '39.74453056');
INSERT INTO `yssh_location` VALUES ('148', 'PIA装置北罐区，母液缓冲罐', '有组织排放', '115.9758111', '39.72835');
INSERT INTO `yssh_location` VALUES ('149', 'PIA装置第一、第二、第三、第四结晶器排汽、一级母液罐排汽、闪蒸罐排汽(TA022）', '有组织排放', '115.9764889', '39.72843056');
INSERT INTO `yssh_location` VALUES ('15', '烧焦尾气', '有组织排放', '115.9705889', '39.73076111');
INSERT INTO `yssh_location` VALUES ('150', 'PIA干燥机', '有组织排放', '115.9764306', '39.72813889');
INSERT INTO `yssh_location` VALUES ('151', '1-己烯储罐＋装车栈台', '有组织排放', '115.9781694', '39.7253');
INSERT INTO `yssh_location` VALUES ('152', '挥发性有机液体常压储罐呼吸', '有组织排放', '115.9294806', '39.75241944');
INSERT INTO `yssh_location` VALUES ('153', 'TA042', '有组织排放', '115.9742', '39.73636944');
INSERT INTO `yssh_location` VALUES ('154', '储运部东区渣油储罐废气治理设施出口', '有组织排放', '115.9775', '39.73406111');
INSERT INTO `yssh_location` VALUES ('155', 'TA047', '有组织排放', '115.94175', '39.75526944');
INSERT INTO `yssh_location` VALUES ('156', 'TA050', '有组织排放', '115.9333111', '39.73655');
INSERT INTO `yssh_location` VALUES ('157', '装卸车间洗槽油气回收设施TA054（原为膜分离，储存介质为污油：汽油）', '有组织排放', '115.9353889', '39.73698056');
INSERT INTO `yssh_location` VALUES ('158', '高压RTO炉', '有组织排放', '115.9726111', '39.72956944');
INSERT INTO `yssh_location` VALUES ('159', '粉末橡胶干燥塔A(TA062旋风分离）', '有组织排放', '115.96375', '39.74203889');
INSERT INTO `yssh_location` VALUES ('16', '工艺加热炉烟气', '有组织排放', '115.9708', '39.72615');
INSERT INTO `yssh_location` VALUES ('160', '粉末橡胶干燥塔B(TA063旋风分离）', '有组织排放', '115.9637306', '39.74201944');
INSERT INTO `yssh_location` VALUES ('161', '新废碱二期', '有组织排放', '115.9701389', '39.72961111');
INSERT INTO `yssh_location` VALUES ('162', '新废碱一期', '有组织排放', '115.9705694', '39.72961944');
INSERT INTO `yssh_location` VALUES ('163', '乙烯生产装置挥发性有机液体常压储罐呼吸', '有组织排放', '115.96965', '39.73048889');
INSERT INTO `yssh_location` VALUES ('164', '苯生产装置挥发性有机液体常压储罐呼吸', '有组织排放', '115.9681389', '39.72751944');
INSERT INTO `yssh_location` VALUES ('165', '4#苯酚氧化尾气', '有组织排放', '115.9539389', '39.74151111');
INSERT INTO `yssh_location` VALUES ('166', '5#苯酚氧化第一反应器', '有组织排放', '115.95875', '39.7367');
INSERT INTO `yssh_location` VALUES ('167', '间二甲苯再沸炉L-201', '有组织排放', '115.9698611', '39.72848056');
INSERT INTO `yssh_location` VALUES ('168', '西罐区', '有组织排放', '115.9758889', '39.72835');
INSERT INTO `yssh_location` VALUES ('169', '氧化反应器，内浮顶罐，2015D', '有组织排放', '115.9756806', '39.72841111');
INSERT INTO `yssh_location` VALUES ('17', '工艺加热炉烟气', '有组织排放', '115.9657889', '39.72788889');
INSERT INTO `yssh_location` VALUES ('170', '洗涤塔鼓风机排气', '有组织排放', '115.9758111', '39.72831111');
INSERT INTO `yssh_location` VALUES ('171', '沉淀池风机排气（TA078，吸收法）', '有组织排放', '115.9758111', '39.72828056');
INSERT INTO `yssh_location` VALUES ('172', 'PIA装置有机固体物料料仓JF-501', '有组织排放', '115.9758306', '39.72831111');
INSERT INTO `yssh_location` VALUES ('173', '螺旋筛排气', '有组织排放', '115.9215611', '39.73818889');
INSERT INTO `yssh_location` VALUES ('174', '重整催化剂再生烟气', '有组织排放', '115.93935', '39.75428889');
INSERT INTO `yssh_location` VALUES ('175', 'XSDJ901', '有组织排放', '115.9189111', '39.73223889');
INSERT INTO `yssh_location` VALUES ('176', 'XSDJ902', '有组织排放', '115.9189111', '39.73218889');
INSERT INTO `yssh_location` VALUES ('177', 'XSDJ903', '有组织排放', '115.9188694', '39.73213056');
INSERT INTO `yssh_location` VALUES ('178', 'XSDJ904', '有组织排放', '115.9232306', '39.73271944');
INSERT INTO `yssh_location` VALUES ('179', 'XSDJ905', '有组织排放', '115.92325', '39.73285');
INSERT INTO `yssh_location` VALUES ('18', '焚烧炉', '有组织排放', '115.9758194', '39.72843056');
INSERT INTO `yssh_location` VALUES ('180', 'XSXH001', '有组织排放', '115.9198694', '39.73151111');
INSERT INTO `yssh_location` VALUES ('181', 'XSXH002', '有组织排放', '115.9200194', '39.73153056');
INSERT INTO `yssh_location` VALUES ('182', 'XSDJ906', '有组织排放', '115.9231611', '39.73233889');
INSERT INTO `yssh_location` VALUES ('183', 'XSDJ907', '有组织排放', '115.92325', '39.73248889');
INSERT INTO `yssh_location` VALUES ('184', 'XSDJ908', '有组织排放', '115.92325', '39.73268889');
INSERT INTO `yssh_location` VALUES ('185', 'XSDJ909', '有组织排放', '115.92325', '39.7328');
INSERT INTO `yssh_location` VALUES ('186', 'XSDJ910', '有组织排放', '115.9232306', '39.73288056');
INSERT INTO `yssh_location` VALUES ('187', 'XSXTYW001', '有组织排放', '115.9199194', '39.73228056');
INSERT INTO `yssh_location` VALUES ('188', 'XSSD001', '有组织排放', '115.9217111', '39.73481111');
INSERT INTO `yssh_location` VALUES ('189', 'XSSD002', '有组织排放', '115.9217611', '39.7346');
INSERT INTO `yssh_location` VALUES ('19', '间二甲苯加热炉L-102', '有组织排放', '115.9698611', '39.72811111');
INSERT INTO `yssh_location` VALUES ('190', 'XSDB002', '有组织排放', '115.9232889', '39.73658889');
INSERT INTO `yssh_location` VALUES ('191', 'XSXTSD001', '有组织排放', '115.91925', '39.7323');
INSERT INTO `yssh_location` VALUES ('192', 'XSDB001', '有组织排放', '115.9222111', '39.73606111');
INSERT INTO `yssh_location` VALUES ('193', 'XSYB001', '有组织排放', '115.97015', '39.72583889');
INSERT INTO `yssh_location` VALUES ('194', 'DA138', '有组织排放', '115.9666389', '39.72566111');
INSERT INTO `yssh_location` VALUES ('195', 'XSDJ008', '有组织排放', '115.9191', '39.73211111');
INSERT INTO `yssh_location` VALUES ('196', 'XSDJ911', '有组织排放', '115.9216', '39.72998056');
INSERT INTO `yssh_location` VALUES ('197', 'XSDJ007', '有组织排放', '115.9185889', '39.73163056');
INSERT INTO `yssh_location` VALUES ('198', 'XSDJ001', '有组织排放', '115.92065', '39.73221111');
INSERT INTO `yssh_location` VALUES ('199', '', '有组织排放', '115.92065', '39.73221111');
INSERT INTO `yssh_location` VALUES ('2', '裂解炉BA1104', '有组织排放', '115.9703806', '39.73075');
INSERT INTO `yssh_location` VALUES ('20', '间二甲苯再沸炉L-202', '有组织排放', '115.9698611', '39.72848056');
INSERT INTO `yssh_location` VALUES ('200', '', '有组织排放', '115.9207306', '39.73218056');
INSERT INTO `yssh_location` VALUES ('201', '', '有组织排放', '115.92075', '39.73221944');
INSERT INTO `yssh_location` VALUES ('202', '', '有组织排放', '115.9208', '39.73218889');
INSERT INTO `yssh_location` VALUES ('203', '', '有组织排放', '115.9207389', '39.73216944');
INSERT INTO `yssh_location` VALUES ('204', 'AI-01', '监控点', '115.9375', '39.761');
INSERT INTO `yssh_location` VALUES ('205', 'AI-02', '监控点', '115.942', '39.7585');
INSERT INTO `yssh_location` VALUES ('206', 'AI-03', '监控点', '115.9386', '39.7563');
INSERT INTO `yssh_location` VALUES ('207', 'AI-04', '监控点', '115.9348', '39.7524');
INSERT INTO `yssh_location` VALUES ('208', 'AI-05', '监控点', '115.9304', '39.7495');
INSERT INTO `yssh_location` VALUES ('209', 'AI-06', '监控点', '115.9296', '39.7488');
INSERT INTO `yssh_location` VALUES ('21', '第一聚丙烯装置TK507ABCD', '有组织排放', '115.9568389', '39.74541111');
INSERT INTO `yssh_location` VALUES ('210', 'AI-07', '监控点', '115.926', '39.7443');
INSERT INTO `yssh_location` VALUES ('211', 'AI-08', '监控点', '115.9263', '39.7395');
INSERT INTO `yssh_location` VALUES ('212', 'AI-09', '监控点', '115.9357', '39.7367');
INSERT INTO `yssh_location` VALUES ('213', 'AI-10', '监控点', '115.9187', '39.7352');
INSERT INTO `yssh_location` VALUES ('214', 'AI-11', '监控点', '115.9204', '39.7352');
INSERT INTO `yssh_location` VALUES ('215', 'AI-12', '监控点', '115.9232', '39.7349');
INSERT INTO `yssh_location` VALUES ('216', 'AI-13', '监控点', '115.9242', '39.7318');
INSERT INTO `yssh_location` VALUES ('217', 'AI-14', '监控点', '115.9216', '39.7334');
INSERT INTO `yssh_location` VALUES ('218', 'AI-15', '监控点', '115.922', '39.7299');
INSERT INTO `yssh_location` VALUES ('219', 'AI-16', '监控点', '115.9181', '39.7293');
INSERT INTO `yssh_location` VALUES ('22', '第一聚丙烯装置TK2507ABCD', '有组织排放', '115.9569694', '39.74546944');
INSERT INTO `yssh_location` VALUES ('220', 'AI-17', '监控点', '115.9534', '39.7463');
INSERT INTO `yssh_location` VALUES ('221', 'AI-18', '监控点', '115.9501', '39.7432');
INSERT INTO `yssh_location` VALUES ('222', 'AI-19', '监控点', '115.9551', '39.7418');
INSERT INTO `yssh_location` VALUES ('223', 'AI-20', '监控点', '115.9521', '39.7388');
INSERT INTO `yssh_location` VALUES ('224', 'AI-21', '监控点', '115.9582', '39.7407');
INSERT INTO `yssh_location` VALUES ('225', 'AI-22', '监控点', '115.9581', '39.7387');
INSERT INTO `yssh_location` VALUES ('226', 'AI-23', '监控点', '115.9588', '39.7359');
INSERT INTO `yssh_location` VALUES ('227', 'AI-24', '监控点', '115.9622', '39.7293');
INSERT INTO `yssh_location` VALUES ('228', 'AI-25', '监控点', '115.9671', '39.725');
INSERT INTO `yssh_location` VALUES ('229', 'AI-26', '监控点', '115.9527', '39.7283');
INSERT INTO `yssh_location` VALUES ('23', '第一聚丙烯装置A线成品料仓风分离器M509', '有组织排放', '115.95605', '39.74583889');
INSERT INTO `yssh_location` VALUES ('230', 'AI-27', '监控点', '115.9748', '39.7246');
INSERT INTO `yssh_location` VALUES ('231', 'AI-28', '监控点', '115.9676', '39.7289');
INSERT INTO `yssh_location` VALUES ('232', 'AI-29', '监控点', '115.9672', '39.728');
INSERT INTO `yssh_location` VALUES ('233', 'AI-30', '监控点', '115.9786', '39.7245');
INSERT INTO `yssh_location` VALUES ('234', 'AI-31', '监控点', '115.9674', '39.7263');
INSERT INTO `yssh_location` VALUES ('235', 'AI-32', '监控点', '115.9706', '39.7255');
INSERT INTO `yssh_location` VALUES ('236', 'AI-33', '监控点', '115.9702', '39.7275');
INSERT INTO `yssh_location` VALUES ('237', 'AI-34', '监控点', '115.9718', '39.728');
INSERT INTO `yssh_location` VALUES ('238', 'AI-35', '监控点', '115.9717', '39.7291');
INSERT INTO `yssh_location` VALUES ('239', 'AI-36', '监控点', '115.9708', '39.7315');
INSERT INTO `yssh_location` VALUES ('24', '第一聚丙烯装置B线成品料仓风分离器M-2508', '有组织排放', '115.9560389', '39.74566111');
INSERT INTO `yssh_location` VALUES ('240', 'AI-37', '监控点', '115.9706', '39.733');
INSERT INTO `yssh_location` VALUES ('241', 'AI-38', '监控点', '115.9718', '39.7405');
INSERT INTO `yssh_location` VALUES ('242', 'AI-39', '监控点', '115.976', '39.7308');
INSERT INTO `yssh_location` VALUES ('243', 'AI-40', '监控点', '115.978', '39.7326');
INSERT INTO `yssh_location` VALUES ('244', 'AI-41', '监控点', '115.9749', '39.7278');
INSERT INTO `yssh_location` VALUES ('245', 'AI-42', '监控点', '115.9555', '39.7006');
INSERT INTO `yssh_location` VALUES ('246', 'AI-43', '监控点', '115.9692', '39.732');
INSERT INTO `yssh_location` VALUES ('247', 'AI-44', '监控点', '115.9661', '39.7314');
INSERT INTO `yssh_location` VALUES ('248', 'AI-45', '监控点', '115.955', '39.7375');
INSERT INTO `yssh_location` VALUES ('249', 'AI-46', '监控点', '115.9237', '39.7379');
INSERT INTO `yssh_location` VALUES ('25', '第二聚丙烯装置TK505ABCD', '有组织排放', '115.9563', '39.74428889');
INSERT INTO `yssh_location` VALUES ('250', 'YF', '监控点', '115.944', '39.738');
INSERT INTO `yssh_location` VALUES ('251', 'CJZ_YF', '超级站', '115.94375', '39.73817');
INSERT INTO `yssh_location` VALUES ('252', 'CJZ_DF', '超级站', '115.9470833', '39.78063611');
INSERT INTO `yssh_location` VALUES ('253', 'CJZ_XC', '超级站', '116.0577611', '39.73488333');
INSERT INTO `yssh_location` VALUES ('254', '裂解炉BA1101', '实时排放', '115.9703806', '39.73045');
INSERT INTO `yssh_location` VALUES ('255', '裂解炉BA1102', '实时排放', '115.9703889', '39.73053056');
INSERT INTO `yssh_location` VALUES ('256', '裂解炉BA106', '实时排放', '115.96645', '39.7308');
INSERT INTO `yssh_location` VALUES ('257', '裂解炉BA107', '实时排放', '115.96645', '39.73071111');
INSERT INTO `yssh_location` VALUES ('258', '裂解炉BA108', '实时排放', '115.96645', '39.73058056');
INSERT INTO `yssh_location` VALUES ('259', '裂解炉BA109', '实时排放', '115.9664611', '39.73051111');
INSERT INTO `yssh_location` VALUES ('26', '第二聚丙烯装置成品料仓风分离器TK602', '有组织排放', '115.9560111', '39.74583889');
INSERT INTO `yssh_location` VALUES ('260', '裂解炉BA110', '实时排放', '115.9664694', '39.73045');
INSERT INTO `yssh_location` VALUES ('261', '裂解炉BA111', '实时排放', '115.9664389', '39.73023889');
INSERT INTO `yssh_location` VALUES ('262', '二催化', '实时排放', '115.9386194', '39.75978056');
INSERT INTO `yssh_location` VALUES ('263', '三催化', '实时排放', '115.9340111', '39.75548889');
INSERT INTO `yssh_location` VALUES ('264', '丁苯橡胶装置后处理1、2、3线尾气', '实时排放', '115.9222111', '39.73606111');
INSERT INTO `yssh_location` VALUES ('265', '溴化丁基RTO', '实时排放', '115.9191', '39.73211111');
INSERT INTO `yssh_location` VALUES ('266', '丁基后处理排口', '实时排放', '115.9185889', '39.73163056');
INSERT INTO `yssh_location` VALUES ('267', '裂解炉BA1101', '实时排放', '115.9703806', '39.73045');
INSERT INTO `yssh_location` VALUES ('268', '裂解炉BA1102', '实时排放', '115.9703889', '39.73053056');
INSERT INTO `yssh_location` VALUES ('269', '裂解炉BA106', '实时排放', '115.96645', '39.7308');
INSERT INTO `yssh_location` VALUES ('27', '第三聚丙烯装置F502A', '有组织排放', '115.9581', '39.74356111');
INSERT INTO `yssh_location` VALUES ('270', '裂解炉BA107', '实时排放', '115.96645', '39.73071111');
INSERT INTO `yssh_location` VALUES ('271', '裂解炉BA108', '实时排放', '115.96645', '39.73058056');
INSERT INTO `yssh_location` VALUES ('272', '裂解炉BA109', '实时排放', '115.9664611', '39.73051111');
INSERT INTO `yssh_location` VALUES ('273', '裂解炉BA110', '实时排放', '115.9664694', '39.73045');
INSERT INTO `yssh_location` VALUES ('274', '裂解炉BA111', '实时排放', '115.9664389', '39.73023889');
INSERT INTO `yssh_location` VALUES ('275', '二催化', '实时排放', '115.9386194', '39.75978056');
INSERT INTO `yssh_location` VALUES ('276', '三催化', '实时排放', '115.9340111', '39.75548889');
INSERT INTO `yssh_location` VALUES ('277', '丁苯橡胶装置后处理1、2、3线尾气', '实时排放', '115.9222111', '39.73606111');
INSERT INTO `yssh_location` VALUES ('278', '溴化丁基RTO', '实时排放', '115.9191', '39.73211111');
INSERT INTO `yssh_location` VALUES ('279', '丁基后处理排口', '实时排放', '115.9185889', '39.73163056');
INSERT INTO `yssh_location` VALUES ('28', '高压聚乙烯料包装料仓3H201', '有组织排放', '115.9729306', '39.72996111');
INSERT INTO `yssh_location` VALUES ('280', NULL, NULL, NULL, NULL);
INSERT INTO `yssh_location` VALUES ('281', NULL, NULL, NULL, NULL);
INSERT INTO `yssh_location` VALUES ('29', '高压离心分离器OZ252', '有组织排放', '115.9728', '39.72976111');
INSERT INTO `yssh_location` VALUES ('3', '裂解炉BA105', '有组织排放', '115.9664', '39.73096111');
INSERT INTO `yssh_location` VALUES ('30', '二高压RTO炉', '有组织排放', '115.9724111', '39.72578889');
INSERT INTO `yssh_location` VALUES ('31', '二高压BN-1830', '有组织排放', '115.9733194', '39.72398889');
INSERT INTO `yssh_location` VALUES ('32', '高压RTO-2炉高压RTO-1炉', '有组织排放', '115.9726111', '39.72956944');
INSERT INTO `yssh_location` VALUES ('33', '低压聚乙烯装置M454(A)', '有组织排放', '115.9787889', '39.73066111');
INSERT INTO `yssh_location` VALUES ('34', '低压聚乙烯装置M2454(B)', '有组织排放', '115.9788694', '39.73066944');
INSERT INTO `yssh_location` VALUES ('35', '低压聚乙烯 1M-517A', '有组织排放', '115.9792306', '39.73086111');
INSERT INTO `yssh_location` VALUES ('36', '低压聚乙烯 1M-517B', '有组织排放', '115.9793111', '39.73083889');
INSERT INTO `yssh_location` VALUES ('37', '低压聚乙烯 2M-517A', '有组织排放', '115.9794', '39.73086111');
INSERT INTO `yssh_location` VALUES ('38', '低压聚乙烯 2M-517B', '有组织排放', '115.9794889', '39.73085');
INSERT INTO `yssh_location` VALUES ('39', '牛口峪罐区有机热载体炉（501A）', '有组织排放', '115.9589194', '39.68976944');
INSERT INTO `yssh_location` VALUES ('4', '裂解炉BA112', '有组织排放', '115.9661889', '39.73025');
INSERT INTO `yssh_location` VALUES ('40', '牛口峪罐区有机热载体炉（501B）', '有组织排放', '115.9589806', '39.68983889');
INSERT INTO `yssh_location` VALUES ('41', '牛口峪罐区有机热载体炉（502）', '有组织排放', '115.9589889', '39.68976944');
INSERT INTO `yssh_location` VALUES ('42', '苯酚丙酮罐区TO炉', '有组织排放', '115.9534889', '39.74453056');
INSERT INTO `yssh_location` VALUES ('43', '化工罐区TO炉', '有组织排放', '115.9742', '39.73636944');
INSERT INTO `yssh_location` VALUES ('44', '联合罐区RTO炉', '有组织排放', '115.94175', '39.75526944');
INSERT INTO `yssh_location` VALUES ('45', '装油栈台RTO炉', '有组织排放', '115.9333111', '39.73655');
INSERT INTO `yssh_location` VALUES ('46', '粉末橡胶干燥塔A排口', '有组织排放', '115.96375', '39.74203889');
INSERT INTO `yssh_location` VALUES ('47', '粉末橡胶干燥塔B排口', '有组织排放', '115.9637306', '39.74201944');
INSERT INTO `yssh_location` VALUES ('48', '粉末橡胶除尘器排口', '有组织排放', '115.9637306', '39.74191111');
INSERT INTO `yssh_location` VALUES ('49', '工艺加热炉烟气', '有组织排放', '115.9394389', '39.75416111');
INSERT INTO `yssh_location` VALUES ('5', '裂解炉BA113', '有组织排放', '115.9661694', '39.73106111');
INSERT INTO `yssh_location` VALUES ('50', '工艺加热炉烟气', '有组织排放', '115.9388611', '39.75401111');
INSERT INTO `yssh_location` VALUES ('51', '工艺加热炉烟气', '有组织排放', '115.93965', '39.75316944');
INSERT INTO `yssh_location` VALUES ('52', '工艺加热炉烟气', '有组织排放', '115.9396694', '39.75293889');
INSERT INTO `yssh_location` VALUES ('53', '工艺加热炉烟气', '有组织排放', '115.9396694', '39.75793889');
INSERT INTO `yssh_location` VALUES ('54', '工艺加热炉烟气', '有组织排放', '115.9372306', '39.76321944');
INSERT INTO `yssh_location` VALUES ('55', '工艺加热炉烟气', '有组织排放', '115.9764', '39.72818056');
INSERT INTO `yssh_location` VALUES ('56', '工艺加热炉烟气', '有组织排放', '115.9323889', '39.75298889');
INSERT INTO `yssh_location` VALUES ('57', '工艺加热炉烟气', '有组织排放', '115.9290111', '39.74961111');
INSERT INTO `yssh_location` VALUES ('58', '工艺加热炉烟气', '有组织排放', '115.9285389', '39.74903056');
INSERT INTO `yssh_location` VALUES ('59', '工艺加热炉烟气', '有组织排放', '115.9231889', '39.74188889');
INSERT INTO `yssh_location` VALUES ('6', '裂解炉BA114', '有组织排放', '115.9662389', '39.73103056');
INSERT INTO `yssh_location` VALUES ('60', '工艺加热炉烟气', '有组织排放', '115.9217806', '39.74318056');
INSERT INTO `yssh_location` VALUES ('61', '工艺加热炉烟气', '有组织排放', '115.9248694', '39.74268056');
INSERT INTO `yssh_location` VALUES ('62', '工艺加热炉烟气', '有组织排放', '115.9258111', '39.7426');
INSERT INTO `yssh_location` VALUES ('63', '工艺加热炉烟气', '有组织排放', '115.9274806', '39.73773056');
INSERT INTO `yssh_location` VALUES ('64', '工艺加热炉烟气', '有组织排放', '115.9251694', '39.74006111');
INSERT INTO `yssh_location` VALUES ('65', '催化裂化催化剂再生尾气', '有组织排放', '115.9386194', '39.75978056');
INSERT INTO `yssh_location` VALUES ('66', '催化裂化催化剂再生尾气', '有组织排放', '115.9340111', '39.75548889');
INSERT INTO `yssh_location` VALUES ('67', '焚烧炉烟气 ', '有组织排放', '115.9253611', '39.74075');
INSERT INTO `yssh_location` VALUES ('68', '焚烧炉烟气 ', '有组织排放', '115.9380611', '39.76313889');
INSERT INTO `yssh_location` VALUES ('69', '丁基氯甲烷焚烧炉', '有组织排放', '115.9703889', '39.73053056');
INSERT INTO `yssh_location` VALUES ('7', '裂解炉BA115', '有组织排放', '115.96645', '39.73101111');
INSERT INTO `yssh_location` VALUES ('70', '湿氯甲烷罐焚烧炉', '有组织排放', '115.9703806', '39.73045');
INSERT INTO `yssh_location` VALUES ('71', 'RTO', '有组织排放', '115.9664694', '39.73045');
INSERT INTO `yssh_location` VALUES ('72', '第三聚丙烯装置F502B', '有组织排放', '115.9581306', '39.74366944');
INSERT INTO `yssh_location` VALUES ('73', '第三聚丙烯装置F502C', '有组织排放', '115.9581306', '39.74368889');
INSERT INTO `yssh_location` VALUES ('74', '第三聚丙烯装置F502D', '有组织排放', '115.9581889', '39.74375');
INSERT INTO `yssh_location` VALUES ('75', '第三聚丙烯装置F503A', '有组织排放', '115.9587889', '39.74351944');
INSERT INTO `yssh_location` VALUES ('76', '第三聚丙烯装置F503B', '有组织排放', '115.9586611', '39.74356111');
INSERT INTO `yssh_location` VALUES ('77', '第三聚丙烯装置F503C', '有组织排放', '115.9586194', '39.74353889');
INSERT INTO `yssh_location` VALUES ('78', '第三聚丙烯装置F503D', '有组织排放', '115.9585111', '39.74351944');
INSERT INTO `yssh_location` VALUES ('79', '第三聚丙烯装置F503E', '有组织排放', '115.9587694', '39.7436');
INSERT INTO `yssh_location` VALUES ('8', '烧焦尾气', '有组织排放', '115.9663389', '39.73081944');
INSERT INTO `yssh_location` VALUES ('80', '第三聚丙烯装置F503F', '有组织排放', '115.9586389', '39.74363056');
INSERT INTO `yssh_location` VALUES ('81', '第三聚丙烯装置F503G', '有组织排放', '115.9586194', '39.74363056');
INSERT INTO `yssh_location` VALUES ('82', '第三聚丙烯装置F503H', '有组织排放', '115.9585111', '39.74366944');
INSERT INTO `yssh_location` VALUES ('83', '第三聚丙烯装置F503J', '有组织排放', '115.9588111', '39.74373056');
INSERT INTO `yssh_location` VALUES ('84', '第三聚丙烯装置F503K', '有组织排放', '115.9586611', '39.74375');
INSERT INTO `yssh_location` VALUES ('85', '第三聚丙烯装置F503L', '有组织排放', '115.9585806', '39.74378056');
INSERT INTO `yssh_location` VALUES ('86', '第三聚丙烯装置F503M', '有组织排放', '115.9584694', '39.74381944');
INSERT INTO `yssh_location` VALUES ('87', '高压聚乙烯树脂装置聚乙烯次品料仓OH-161-1', '有组织排放', '115.9720889', '39.72985');
INSERT INTO `yssh_location` VALUES ('88', '高压聚乙烯树脂装置聚乙烯次品料仓OH-161-2', '有组织排放', '115.9721806', '39.72978889');
INSERT INTO `yssh_location` VALUES ('89', '高压聚乙烯树脂装置聚乙烯次品料仓OH-161-3', '有组织排放', '115.9722389', '39.72983056');
INSERT INTO `yssh_location` VALUES ('9', '烧焦尾气', '有组织排放', '115.9663694', '39.73068056');
INSERT INTO `yssh_location` VALUES ('90', '高压聚乙烯树脂装置聚乙烯次品料仓OH-161-4', '有组织排放', '115.9722694', '39.72978889');
INSERT INTO `yssh_location` VALUES ('91', '高压聚乙烯树脂装置聚乙烯次品料仓OH-161-5', '有组织排放', '115.9722889', '39.72983056');
INSERT INTO `yssh_location` VALUES ('92', '高压聚乙烯树脂装置聚乙烯次品料仓OH-153', '有组织排放', '115.97235', '39.72983056');
INSERT INTO `yssh_location` VALUES ('93', '高压聚乙烯树脂装置聚乙烯料仓计量斗1H101A', '有组织排放', '115.9719694', '39.72976111');
INSERT INTO `yssh_location` VALUES ('94', '高压聚乙烯树脂装置聚乙烯料仓计量斗1H101B', '有组织排放', '115.9719389', '39.72976111');
INSERT INTO `yssh_location` VALUES ('95', '高压聚乙烯树脂装置聚乙烯料仓计量斗1H101C', '有组织排放', '115.9719389', '39.72973889');
INSERT INTO `yssh_location` VALUES ('96', '高压聚乙烯树脂装置聚乙烯料仓计量斗1H101D', '有组织排放', '115.9719889', '39.72973889');
INSERT INTO `yssh_location` VALUES ('97', '高压聚乙烯树脂装置聚乙烯料仓计量斗2H101A', '有组织排放', '115.9719694', '39.72976111');
INSERT INTO `yssh_location` VALUES ('98', '高压聚乙烯树脂装置聚乙烯料仓计量斗2H101B', '有组织排放', '115.9720111', '39.72966111');
INSERT INTO `yssh_location` VALUES ('99', '高压聚乙烯树脂装置聚乙烯料仓计量斗2H101C', '有组织排放', '115.9720111', '39.72961111');

-- ----------------------------
-- Table structure for yssh_qxsh
-- ----------------------------
DROP TABLE IF EXISTS `yssh_qxsh`;
CREATE TABLE `yssh_qxsh`  (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `lon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `lat` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of yssh_qxsh
-- ----------------------------
INSERT INTO `yssh_qxsh` VALUES (1, 'AI-01', '115.9375', '39.761', '0.006504', '2021010111');
INSERT INTO `yssh_qxsh` VALUES (2, 'AI-01', '115.9375', '39.761', '0.006504', '2021010112');
INSERT INTO `yssh_qxsh` VALUES (3, 'AI-01', '115.9375', '39.761', '0.006504', '2021010113');
INSERT INTO `yssh_qxsh` VALUES (4, 'AI-01', '115.9375', '39.761', '0.006504', '2021010114');

-- ----------------------------
-- Table structure for yssh_weather
-- ----------------------------
DROP TABLE IF EXISTS `yssh_weather`;
CREATE TABLE `yssh_weather`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `wind_speed` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '风速',
  `wind_direction` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '风向',
  `weather_condition` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '天气状况',
  `temperature` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '气温',
  `Time` datetime(0) DEFAULT NULL COMMENT '时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of yssh_weather
-- ----------------------------
INSERT INTO `yssh_weather` VALUES (1, '1.6606903', '-37.36917279', 'Sunny', '18.67852173', '2022-06-09 00:00:00');
INSERT INTO `yssh_weather` VALUES (2, '2.3000946', '-34.85764501', 'Sunny', '20.02852783', '2022-06-09 01:00:00');
INSERT INTO `yssh_weather` VALUES (3, '2.220361', '-21.7608174', 'Sunny', '21.10244141', '2022-06-09 02:00:00');
INSERT INTO `yssh_weather` VALUES (4, '2.4532719', '1.975298781', 'Sunny', '22.42849121', '2022-06-09 03:00:00');
INSERT INTO `yssh_weather` VALUES (5, '2.6328425', '-10.81110265', 'Sunny', '23.87706909', '2022-06-09 04:00:00');
INSERT INTO `yssh_weather` VALUES (6, '2.8903959', '10.41233254', 'Sunny', '25.5901123', '2022-06-09 05:00:00');
INSERT INTO `yssh_weather` VALUES (7, '2.6537676', '-3.78964701', 'Sunny', '27.06917725', '2022-06-09 06:00:00');
INSERT INTO `yssh_weather` VALUES (8, '3.584292', '-0.156918839', 'Sunny', '28.57085571', '2022-06-09 07:00:00');
INSERT INTO `yssh_weather` VALUES (9, '4.0909286', '-9.870895472', 'Sunny', '29.43380127', '2022-06-09 08:00:00');
INSERT INTO `yssh_weather` VALUES (10, '4.0052896', '6.743501944', 'Sunny', '30.17376099', '2022-06-09 09:00:00');
INSERT INTO `yssh_weather` VALUES (11, '4.9829335', '9.916120827', 'Sunny', '30.43081055', '2022-06-09 10:00:00');
INSERT INTO `yssh_weather` VALUES (12, '6.0891695', '-27.50747788', 'Sunny', '28.35561523', '2022-06-09 11:00:00');
INSERT INTO `yssh_weather` VALUES (13, '2.7050424', '-41.13738755', 'Sunny', '26.38317261', '2022-06-09 12:00:00');
INSERT INTO `yssh_weather` VALUES (14, '3.8534396', '-50.71786025', 'Sunny', '24.66573486', '2022-06-09 13:00:00');
INSERT INTO `yssh_weather` VALUES (15, '2.640932', '-49.23998198', 'Sunny', '23.39299927', '2022-06-09 14:00:00');
INSERT INTO `yssh_weather` VALUES (16, '3.1090274', '-33.89205967', 'Sunny', '22.34920654', '2022-06-09 15:00:00');
INSERT INTO `yssh_weather` VALUES (17, '0.7601', '-22.87815265', 'Sunny', '21.65392456', '2022-06-09 16:00:00');
INSERT INTO `yssh_weather` VALUES (18, '1.8830016', '-59.5228175', 'Sunny', '21.15450439', '2022-06-09 17:00:00');
INSERT INTO `yssh_weather` VALUES (19, '3.2440696', '87.44033642', 'Sunny', '20.46929321', '2022-06-09 18:00:00');
INSERT INTO `yssh_weather` VALUES (20, '2.3817253', '76.50832968', 'Sunny', '20.01668701', '2022-06-09 19:00:00');
INSERT INTO `yssh_weather` VALUES (21, '1.7793565', '54.93034988', 'Sunny', '19.72109375', '2022-06-09 20:00:00');
INSERT INTO `yssh_weather` VALUES (22, '1.965144', '41.95216742', 'Sunny', '19.1680542', '2022-06-09 21:00:00');
INSERT INTO `yssh_weather` VALUES (23, '2.1007524', '47.87392077', 'Sunny', '19.24825439', '2022-06-09 22:00:00');
INSERT INTO `yssh_weather` VALUES (24, '1.5549664', '46.22177348', 'Sunny', '19.97744141', '2022-06-09 23:00:00');

SET FOREIGN_KEY_CHECKS = 1;
