PrepperPrepper Open Data Bank

ST_CS20_MST

Summary

This dataset is a master data of town block based on the 2020 national census published by the government statistics e-Stat, collected and processed by truestar.

ST_CS20_MST: Table with column names that are easy to handle for analysis and system integration in SQL.

E_ST_CS20_MST: View with English column names that are easy to use in BI tools such as Tableau.

J_ST_CS20_MST: View with Japanese column names that are easy to use in BI tools such as Tableau.

Sample Data

Data Fields

Example

The following Youtube video introduces an actual visualization example using Tableau.

References

eStat Census/2020 Edition/World Geodetic System Latitude-Longitude Shapefile Version

https://www.e-stat.go.jp/gis/statmap-search?page=1&type=2&aggregateUnitForBoundary=A&toukeiCode=00200521&toukeiYear=2020&serveyId=A002005212020&coordsys=1&format=shape&datum=2000

 

Prepared by truestar based on the above source.

Special Notes

※Processing of small area data

Regarding the processing of small area data, we determine whether the records are held at the “Oaza-cho” level or the “Aza-chome” level based on the statistical information contained in the original data. We then apply the necessary processing to ensure that each record represents a polygon with the appropriate granularity.

■ The basic logic is the following three patterns:

① The case where the original data does not contain records at the “Aza-chome” level.

Adopted because there is no record at the level of “Aza-chome”.

  

② The case where the original data contains records at the “Aza-chome” level and has statistical value.

Adopted: Records at the “Aza-chome” level.

Not adopted: Becase there is a record at the “Aza-chome” level.

③The case where the original data contains records at the “Aza-chome” level but does not contain statistics.

Adopted: Records at the “Aza-chome” level are available, but there are no statistics ⇒ Polygon integration occurs

Not adopted: Because there are no statistics, records at the “Oaza-cho” levels are adopted.