PrepperPrepper Open Data Bank

JMA_METEOROLOGICAL_DAILY【WT_MD】

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 6:45 am every morning

Sample 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

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 follwing 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