truestar inc. population statistics irregular
Summary
This dataset is designed for analysis and has been processed and integrated by truestar based on 1km mesh population data published by the G-Spatial Information Center.
Please note that this dataset is no longer being updated.
Sample Data
Please select the table you wish to view from the data dictionary in the snowflake marketplace.
Click here to view sample data from Japanese Mesh 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);