PrepperPrepper Open Data Bank

MESH_1KM_G_PEOPLEFLOW_MONTHLY

truestar inc.  population statistics  irregular

Summary

This dataset includes the people flow data per 1km mesh, which is edited and integrated by truestar based on the people flow open data provided by AIGID – Association for Promotion of Infrastructure Geospatial Information Distribution.

Sample Data

Features/Usages

This is the monthly people flow data per 1km mesh in 2019 and 2020, and this data has aggregated sections such as weekday and holiday or day and night.
People flow data is the average of every month. We translated prefectural and municipal name from municipal code that the original data has. And we also translated 1km mesh from mesh code that the original data has.
You can easily extract the necessary data when filtering by prefectural name or municipal name.
Because the size of this dataset is very large, we strongly recommend filtering by “PREF_NAME” at first.

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

Edited by truestar based on the following 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

Because the size of this dataset is very large, we strongly recommend filtering by “PREF_NAME” at first.
Please use following query to create the view of the particular prefecture which you need.
※The number should be changed to the pref_code of the prefecture which you need.
 

   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 : Rename 1KM_MESH_G_PEOPLEFLOW_MONTHLY_BETA to MESH_1KM_G_PEOPLEFLOW_MONTHLY