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