prod_group_bg/common-cloud/tool-modules/collect-weather/sql/dim_ga_weather.sql

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for dim_ga_weather
-- ----------------------------
DROP TABLE IF EXISTS `dim_ga_weather`;
CREATE TABLE `dim_ga_weather` (
  `key` varchar(8) NOT NULL COMMENT '代码',
  `value` varchar(64) NOT NULL COMMENT '名称',
  `desc` varchar(256) DEFAULT NULL COMMENT '说明',
  PRIMARY KEY (`key`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='天气状况代码表';

-- ----------------------------
-- Records of dim_ga_weather
-- ----------------------------
BEGIN;
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('1000', '天空状况', NULL);
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('1100', '云量', '天空中云遮蔽的量');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('1101', '晴', '天空无云，或有零星云层，天空云量小于天空面积的1/10');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('1103', '多云', '天空有4~7成的中、低云或6~10成的高云');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('1106', '阴天', '天空阴暗，密布云层，或天空虽有云隙而仍感到阴暗（总云量8成以上），偶尔从云缝中可见到微弱阳光');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('2000', '降水现象', NULL);
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('2100', '雨', NULL);
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('2101', '小雨', '日降雨量不足10mm');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('2102', '中雨', '日降雨总量为10.0mm ~ 24.9mm');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('2103', '大雨', '日降雨总量为25.0mm ~ 49.9mm');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('2104', '暴雨', '日降雨总量在50.0mm以上');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('2111', '阵雨', '开始和停止都比较突然、强度变化大的液态降水');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('2121', '雷阵雨', '开始和停止都比较突然、强度变化大的液态降水，并伴有雷暴或闪电现象');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('2131', '冬雨', '由过冷水滴组成的，与温度低于0℃的物体');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('2200', '雪', NULL);
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('2201', '小雪', '降雪融化成水相当0.1mm ~ 2.4mm降水量');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('2202', '中雪', '降雪融化成水相当2.5mm ~ 4.9mm降水量');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('2203', '大雪', '降雪融化成水相当5.0mm ~ 9.9mm降水量');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('2204', '暴雪', '降雪融化成水相当10mm降水量以上');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('2211', '雨夹雪', '半融化的雪（湿雪）或雨和雪同时下降');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('2300', '冰雹', '坚硬的球状、锥状或形状不规则的固态降水');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('2900', '其他降水现象', NULL);
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('3000', '水汽凝结现象', '云除外');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('3100', '露', '空气中水汽在地面及近地面物体上凝结而成的水珠');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('3200', '霜冻', '空气中水汽在地面和近地面物体上凝华而成的白色松脆的冰晶，或由露冻结而成的水珠');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('3900', '其他水气凝结现象', NULL);
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('4000', '视程障碍现象', NULL);
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('4100', '雾', '悬浮在贴近地面的大气中的大量微细水滴（或冰晶）的可见集合体');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('4101', '轻雾', '能见度在1km ~ 10km，又称霭');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('4102', '大雾', '能见度在1km以下');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('4103', '浓雾', '能见度在500m以下');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('4200', '霾', '空气中的灰尘、硫酸、硝酸、有机碳氢化合物等粒子非水成物组成的气溶胶系统造成的视程障碍，如果水平能见度小于10km时称为霾或灰霾');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('4300', '沙尘', NULL);
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('4301', '浮尘', '尘沙浮游在空中，使水平能见度小于10km');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('4302', '扬沙', '风将地面尘、沙吹起，使空气相当浑浊水平能见度在1km ~ 10km');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('4303', '沙尘暴', '强风将地面尘、沙吹起，使空气相当浑浊水平能见度小于1km');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('4304', '强沙尘暴', '大风将地面尘、沙吹起，使空气相当浑浊水平能见度小于500m');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('4305', '特强沙尘暴', '狂风将地面尘、沙吹起，使空气相当浑浊水平能见度小于50m');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('4900', '其他视程障碍现象', NULL);
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('5000', '雷电现象', NULL);
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('5100', '雷电', NULL);
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('5101', '雷暴', '积雨云云中、云间或云地之间产生的放电现象。表现为闪电兼有雷声，有时亦可只闻雷声而不见闪电');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('5105', '闪电', '积雨云云中、云间或云地之间产生放电时伴随的电光，但不闻雷声');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('5900', '其他雷电现象', NULL);
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('9000', '其他天气现象', NULL);
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('9100', '风', '风力等级为薄福风力等级');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('9101', '1级（软风）', '烟稍斜，风速0.3m/s ~ 1.5m/s');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('9102', '2级（轻风）', '感觉有风树叶响，风速1.6m/s ~ 3.3m/s');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('9103', '3级（微风）', '旌旗展开树枝摇晃，风速3.4m/s ~ 5.4m/s');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('9104', '4级（和风）', '吹起尘土，风速 5.5m/s ~ 7.9m/s');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('9105', '5级（清劲风）', '小树摇摆水起波，风速8.0m/s ~ 10.7m/s');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('9106', '6级（强风）', '电线有声大树摇，风中撑伞难行，风速10.8m/s~13.8m/s');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('9107', '7级（疾风）', '逆风步行困难，风速13.9m/s ~ 17.1m/s');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('9108', '8级（大风）', '折毁树枝，迎风差点走不动，风速17.2m/s ~ 20.7m/s');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('9109', '9级（烈风）', '小损房屋，风速20.8m/s ~ 24.4m/s');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('9110', '10级（狂风）', '拔起树木，风速24.5m/s ~ 28.4m/s');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('9111', '11级（暴风）', '水面波峰全呈飞沫，风速28.5m/s ~ 32.6m/s');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('9112', '12级（飓风、台风）', '水面波浪滔天，风速 32.7m/s ~ 36.9m/s');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('9113', '13级', '风速37.0m/s ~ 41.4m/s');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('9114', '14级', '风速41.5m/s ~ 46.1m/s');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('9115', '15级', '风速46.2m/s ~ 50.9m/s');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('9116', '16级', '风速51.0m/s ~ 56.0m/s');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('9117', '17级', '风速56.1m/s ~ 61.2m/s');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('9191', '0级（无风）', '静，烟直上，风速0.0m/s ~ 0.2m/s');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('9192', '1-6级', '适用于笼统描述1级（含1级）到6级（不含6级）之间的风');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('9193', '6-12级', '适用于笼统描述6级（含6级）到12级（不含12级）之间的风');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('9194', '12-17级', '适用于笼统描述12级（含12级）到17级（不含17级）之间的风');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('9201', '飑', '风向突变，风速剧增的天气现象');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('9301', '龙卷', '一种小范围强烈旋风，风速一般为50m/s ~ 150m/s');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('9401', '积雪', '雪覆盖地面达到观测点四周能见面积一半以上');
INSERT INTO `dim_ga_weather` (`key`, `value`, `desc`) VALUES ('9501', '结冰', '露天水冻结成冰');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;