週間予報の地点別の予想最低気温・最高気温と予測範囲(7 日分)です。平年値と 7 日間合計降水量の平年並の範囲も持ちます。
SELECT office_code, CAST(report_datetime AS "TIMESTAMP WITH TIME ZONE") AS report_datetime, station_id, station_name, CAST("left"(forecast_datetime, 10) AS "DATE") AS forecast_date, TRY_CAST("nullif"(temp_min, '') AS INTEGER) AS temp_min_c, TRY_CAST("nullif"(temp_min_lower, '') AS INTEGER) AS temp_min_lower_c, TRY_CAST("nullif"(temp_min_upper, '') AS INTEGER) AS temp_min_upper_c, TRY_CAST("nullif"(temp_max, '') AS INTEGER) AS temp_max_c, TRY_CAST("nullif"(temp_max_lower, '') AS INTEGER) AS temp_max_lower_c, TRY_CAST("nullif"(temp_max_upper, '') AS INTEGER) AS temp_max_upper_c, TRY_CAST("nullif"(normal_temp_min, '') AS "DOUBLE") AS normal_temp_min_c, TRY_CAST("nullif"(normal_temp_max, '') AS "DOUBLE") AS normal_temp_max_c, TRY_CAST("nullif"(normal_precip_lower, '') AS "DOUBLE") AS normal_precip_lower_mm, TRY_CAST("nullif"(normal_precip_upper, '') AS "DOUBLE") AS normal_precip_upper_mm FROM {DUCKLAKE_CATALOG}.main.raw_jma_weekly_forecast_temps