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.