PrepperPrepper Open Data Bank

MESH_1KM_G_PEOPLEFLOW_MONTHLY【MS_PF18_1KM】

truestar inc.  population statistics  irregular

Summary

This dataset is for analysis processed and integrated by truestar based on the population data by 1km mesh released by G-Spatial Information Center.

Sample Data

Features/Usages

This is a monthly staying population data from 2019 to 2021 by 1km mesh. The data includes weekday/holiday and daytime/nighttime categories, and the staying population is the average value per day for a month.

The original data includes prefecture name, municipality name, and 1km mesh code based on the municipality code, and by filtering by prefecture and municipality name, you can easily extract only the necessary information.

The data can be analyzed on a large or small scale for differences in human flow between daytime and nighttime, as well as seasonal changes in human flow, and can be used for selecting store locations and predicting customer visits for existing stores.

Please note that this data is very heavy, so we strongly recommend that you first narrow down to one prefecture using the prefecture name (PREF_NAME) when mapping.

Data Fields

MESH_CODE
PREF_CODE
PREF_NAME
PREF_CODE_NAME
CITY_CODE
CITY_NAME
CITY_CODE_NAME
YEAR
MONTH
DAY_2TYPES
TIMEZONE
POPULATION_STAY
MESH_1KM

References

The data is prepared by truestar, based on the follwing data.

AIGID – Association for Promotion of Infrastructure Geospatial Information Distribution people flow data
https://www.geospatial.jp/ckan/dataset/mlit-1km-fromto

 

MLIT (Ministry of Land, Infrastructure, Transport and Tourism) digital national land information
https://nlftp.mlit.go.jp/ksj/gml/datalist/KsjTmplt-N03-v3_0.html

Special Notes

Precautions when using Tableau

This dataset is very heavy, so we strongly recommend analyzing it in a view narrowed down to the prefecture level when using Tableau.

Please create a view of the necessary prefectures with the following query and use it.

※ Please change the numbers to the code of the necessary prefectures.

CREATE OR REPLACE VIEW “PREPPER_OPEN_DATA_BANK”.”PUBLIC”.”1KM_MESH_G_PEOPLEFLOW_MONTHLY_BETA”

AS SELECT * FROM “PREPPER_OPEN_DATA_BANK”.”PUBLIC”.”1KM_MESH_G_PEOPLEFLOW_MONTHLY_BETA”

WHERE PREF_CODE In(14);

Update History

2022/1/28: Renamed from 1KM_MESH_G_PEOPLEFLOW_MONTHLY_BETA to MESH_1KM_G_PEOPLEFLOW_MONTHLY and officially released.

2022/4/28: MESH_1KM_G_PEOPLEFLOW_MONTHLY_2021 released as beta version.

2022/5/31: Released as production version under the name MESH_1KM_G_PEOPLEFLOW_MONTHLY.