soil: 天気予報の移植

[duri0214]

https://qiita.com/YoshitakaOkada/items/1046fd83ef5c295491f1

• [x] import_weather_master
• [x] fetch_weather_forecast
• [x] fetch_weather_warning

select 
    sajw.reporting_date,
    sajp.code pref_code,
    sajp.name pref_name,
    sajr.code region_code,
    sajr.name pref_name,
    sajwc.code weather_code,
    sajwc.name weather_name,
    sajw.weather_text,
    sajw.wind_text,
    sajw.wave_text,
    sajw.avg_rain_probability,
    sajw.avg_min_temperature,
    sajw.avg_max_temperature,
    sajw.avg_max_wind_speed
from soil_analysis_jmaweather sajw 
    inner join soil_analysis_jmaregion sajr on sajw.jma_region_id = sajr.id
    inner join soil_analysis_jmaprefecture sajp on sajr.jma_prefecture_id = sajp.id
    inner join soil_analysis_jmaweathercode sajwc on sajw.jma_weather_code_id = sajwc.id
order by sajr.id, sajw.reporting_date