府県予報区ごとの短期予報の地点別の予想気温です。地点はアメダスの観測所です。
SELECT office_code, CAST(report_datetime AS "TIMESTAMP WITH TIME ZONE") AS report_datetime, area_code AS station_id, area_name AS station_name, CAST(forecast_datetime AS "TIMESTAMP WITH TIME ZONE") AS forecast_datetime, TRY_CAST("nullif"("temp", '') AS INTEGER) AS temp_c FROM {DUCKLAKE_CATALOG}.main.raw_jma_forecast_temps