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