説明はありません
列はありません
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