Queria
DatasetsShowcaseAI chatArea analysis
⌘K
All datasetsG空間情報センター
Project LINKS47
全国の人流オープンデータ11
  • 都道府県・市区町村と地方区分
  • 市区町村単位発地別の滞在人口(月別)
  • 1km メッシュ
  • 1km メッシュ別の滞在人口(月別)
  • 元のファイル
  • stg_city_master_2019
  • stg_city_master_2020
  • stg_city_population_by_origin
  • stg_mesh_attribute_2020
  • stg_people_flow_source_file
  • stg_region_master_2020
登記所備付地図3
About QueriaPricingGeocoderCompany ResolverTerms of ServicePrivacy PolicyCommercial TransactionsContactCommunity (Discord)

© 2026 FLOPS

geospatial/people_flow/stg_mesh_attribute_2020

Description

No description

Columns

No columns

Type
View
License
  • 公共データ利用規約(第1.0版)
  • 全国の人流オープンデータ利用規約(国土交通省、政府標準利用規約 2.0 準拠・CC BY 4.0 互換)
  • 登記所備付地図データ利用規約(法務省)
Original data
https://www.geospatial.jp/ckan/organization/sosei-joho

SQL definition

SELECT mesh1kmid AS mesh_code, prefcode AS prefecture_code, citycode AS city_code, CASE  WHEN (regexp_full_match(citycode, '[0-9]{5}')) THEN ((citycode || CAST(((11 - ((((((6 * CAST(substr(citycode, 1, 1) AS INTEGER)) + (5 * CAST(substr(citycode, 2, 1) AS INTEGER))) + (4 * CAST(substr(citycode, 3, 1) AS INTEGER))) + (3 * CAST(substr(citycode, 4, 1) AS INTEGER))) + (2 * CAST(substr(citycode, 5, 1) AS INTEGER))) % 11)) % 10) AS VARCHAR))) ELSE NULL END AS lg_code, ((((100 + CAST(substr(mesh_code, 3, 2) AS double)) + (CAST(substr(mesh_code, 6, 1) AS double) / 8)) + (CAST(substr(mesh_code, 8, 1) AS double) / 80)) + (1.0 / 160)) AS lng, ((((CAST(substr(mesh_code, 1, 2) AS double) / 1.5) + (CAST(substr(mesh_code, 5, 1) AS double) / 12)) + (CAST(substr(mesh_code, 7, 1) AS double) / 120)) + (1.0 / 240)) AS lat, st_makeenvelope((((100 + CAST(substr(mesh_code, 3, 2) AS double)) + (CAST(substr(mesh_code, 6, 1) AS double) / 8)) + (CAST(substr(mesh_code, 8, 1) AS double) / 80)), (((CAST(substr(mesh_code, 1, 2) AS double) / 1.5) + (CAST(substr(mesh_code, 5, 1) AS double) / 12)) + (CAST(substr(mesh_code, 7, 1) AS double) / 120)), ((((100 + CAST(substr(mesh_code, 3, 2) AS double)) + (CAST(substr(mesh_code, 6, 1) AS double) / 8)) + (CAST(substr(mesh_code, 8, 1) AS double) / 80)) + (1.0 / 80)), ((((CAST(substr(mesh_code, 1, 2) AS double) / 1.5) + (CAST(substr(mesh_code, 5, 1) AS double) / 12)) + (CAST(substr(mesh_code, 7, 1) AS double) / 120)) + (1.0 / 120))) AS geometry FROM people_flow.raw_mesh_attribute_2020
Tables61Reports1LineageHistoryIssuesChange requests
queria/geospatialG空間情報センター
Star0