ST_CS20_MST
言語：
英語
プロダクト種別：
データ
親プロダクト：
JAPANESE STREET DATA(日本の町丁目データ)
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
Please select the table you wish to view from the data dictionary in the Snowflake Marketplace.
Click here for sample data from Japanese Street Data
Data Fields
RAW_NAME | E_NAME | J_NAME | COMMENT |
|---|---|---|---|
ST_CS20_MST_001 | Address code | 11桁住所コード | CITY_CODE＋STREET_CODE |
ST_CS20_MST_002 | Pref code | 都道府県コード | 出典：e-Stat 令和2年国勢調査 |
ST_CS20_MST_003 | Pref name | 都道府県名 | 出典：e-Stat 令和2年国勢調査 |
ST_CS20_MST_004 | Pref code and name | 都道府県名コード付 | |
ST_CS20_MST_005 | City code | 市区町村コード | 出典：e-Stat 令和2年国勢調査 |
ST_CS20_MST_006 | City name | 市区町村名 | 出典：e-Stat 令和2年国勢調査 |
ST_CS20_MST_007 | City code name | 市区町村名コード付 | |
ST_CS20_MST_008 | Street code | 町丁目コード | 出典：e-Stat 令和2年国勢調査 |
ST_CS20_MST_009 | Street name | 町丁目名 | 出典：e-Stat 令和2年国勢調査 |
ST_CS20_MST_010 | Street code and name | 町丁目名コード付 | |
ST_CS20_MST_011 | Research year | 調査年度 | |
ST_CS20_MST_012 | Population | 人口【人】 | 出典：e-Stat 令和2年国勢調査 |
ST_CS20_MST_013 | Number of households | 世帯数【世帯】 | 出典：e-Stat 令和2年国勢調査 |
ST_CS20_MST_014 | Area | 面積（参考）【km2】 | 出典：e-Stat 令和2年国勢調査 | truestar加工あり（単位変更） |
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: Because 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" level are adopted.