JMA_METEOROLOGICAL_DAILY【WT_MD】

言語:

英語

プロダクト種別:

データ

親プロダクト:

JAPANESE WEATHER DATA(日本の天気データ)

truestar inc. point everyday

Summary

This dataset is a collection of weather information processed by truestar based on past weather data publicly released by the Japan Meteorological Agency. It provides various weather data such as temperature and precipitation on a daily basis.

※Update time: around 11:00 – 11:30 am every morning

Sample Data

Please select the table you wish to view from the data dictionary in the snowflake marketplace.

Click here for sample data from Japanese Weather Data

Features/Usages

We provide weather open data on temperature, precipitation, wind and sunshine hours at JMA stations from January 1, 2015 to the most recent date (two days ago). We have cleansed the original data by removing text data in numerical columns and added latitude/longitude, and prefecture information for the stations, so that the data can be analyzed immediately.

Data Fields

Field Name

BLOCK_CODE

OBSERVATORY_NAME

OBSERVATORY_TYPE

OBSERVATION_DATA

PREF_CODE

PREF_NAME

PREF_CODE_NAME

JMA_AREA_CODE

JMA_AREA_NAME

LATITUDE

LONGITUDE

DATE

AIR_PRESSURE

AIR_PRESSURE_SEA_LEVEL

AIR_PRESSURE_SEA_LEVEL_MIN

AIR_PRESSURE_SEA_LEVEL_MIN_TIME

RAINFALL

RAINFALL_MAX_1H

RAINFALL_MAX_1H_TIME

RAINFALL_MAX_10MIN

RAINFALL_MAX_10MIN_TIME

AIR_TEMPERATURE

AIR_TEMPERATURE_MAX

AIR_TEMPERATURE_MAX_TIME

AIR_TEMPERATURE_MIN

AIR_TEMPERATURE_MIN_TIME

VAPOR_PRESSURE

HUMIDITY

HUMIDITY_MIN

HUMIDITY_MIN_TIME

WIND_SPEED

WIND_SPEED_MAX

WIND_SPEED_MAX_DIRECTION

WIND_SPEED_MAX_TIME

WIND_SPEED_INSTANTANEOUS_MAX

WIND_SPEED_INSTANTANEOUS_MAX_DIRECTION

WIND_SPEED_INSTANTANEOUS_MAX_TIME

WIND_DIRECTION_MAX

SUNLIGHT_HOURS

GLOBAL_SOLAR_RADIATION

SNOWFALL

SNOWFALL_DEEPEST

SNOWFALL_DEEPEST_TIME

CLOUDAGE

WEATHER_DAYTIME

WEATHER_NIGHTTIME

POINT_OBSERVATORY

References

The data is prepared by truestar, based on the following data.
JMA (Japan Meteorological Agency) meteorological observation data

https://www.data.jma.go.jp/obd/stats/etrn/

Special Notes

Points to note when visualizing with Tableau
This dataset includes point data of weather stations and observatories called “POINT_OBSERVATORY”, but because of large number of records, visualization including mapping may take some time to draw.

Countermeasure 1: On Tableau, point data can be generated quickly from latitude and longitude information, which is a numerical type. Point data can be created using the “makepoint([LATITUDE], [LONGITUDE])” function in the Tableau calculation field.

Countermeasure 2: By extracting data from Snowflake in Tableau, it can be drawn quickly. In this case, the extraction file needs to be updated as necessary.

About each statistical value
For each data value, statistic = 0 includes those less than 0.5.
Also, the statistical values that are null are either not observable or observable but unobservable values. Null does not equal 0.

Discrepancies between daily and monthly aggregate values
In some data, the daily monthly aggregate values and monthly aggregate values may not match because there are missing data in the daily data due to changes in observation locations or equipment.

The table below shows precipitation data for Niimi Observatory in 2016, but since there was a change in observation location, etc. between August 23-24 and the before and after data are not homogeneous, the monthly value in August is the sum of the 25th through the 31st.

Update History

2022/1/28: Rename JMA_METEOROLOGICAL_DATA_DAILY to JMA_METEOROLOGICAL_DAILY