mandel59

-- erq <matsudo-population-density.erq > matsudo-population-density.svg
topojson_feature(readfile('r2ka12207.topojson'), 'town')
  {*, unpack properties {KEY_CODE, AREA, JINKO}}
  {*, population_density: JINKO / AREA * 1000000}
  output vega lite svg with
    projection mercator,
    mark geoshape,
    encoding {
      color: population_density q {title: "人口密度[人/km²]"}
    },

mandel59

{
  "$schema": "https://vega.github.io/schema/vega-lite/v5.json",
  "width": 500,
  "height": 300,
  "data": {
    "url": "https://geoshape.ex.nii.ac.jp/ka/topojson/2020/12/r2ka12207.topojson",
    "format": {
      "type": "topojson",
      "feature": "town"
    }

mandel59

-- erq <jazh-consonants.erq >jazh-consonants.svg
attach '/Users/mandel59/ws/mojidata/packages/mojidata/dist/moji.db' as mojidata;;
with ja as (k: unihan_kJapaneseOn join o: string_split(k.value, ' ') {UCS, ja_c: ifnull(regexp_substr(lower(o.value), '^(ch|ts|sh|[hfbmtdnrszjkgwy])'), '∅') })
with zh as (k: unihan_kMandarin join p: string_split(k.value, ' ') {UCS, zh_c: ifnull(regexp_substr(p.value, '^(zh|ch|sh|[bpmfdtnlzcsrjqxgkhwy])'), '∅') })
joyo { UCS: 漢字 } join ja using (UCS) join zh using (UCS) { ja_c, zh_c => count: count(distinct UCS) }
output vega lite svg with
  encoding {
    x: ja_c n sort['h','f','b','m','t','ch','ts','d','n','r','s','sh','z','j','k','g','w','y','∅'],
    y: zh_c n sort['b','p','m','f','d','t','n','l','zh','ch','sh','z','c','s','j','q','x','r','g','k','h','w','y','∅']
  },

mandel59

mandel59

mandel59

mandel59

From 5744eee9f8eae1f499d024631eedddea114d64e6 Mon Sep 17 00:00:00 2001
From: Ryusei Yamaguchi <mandel59@gmail.com>
Date: Sun, 7 Aug 2022 04:06:49 +0900
Subject: [PATCH] Fix 7 entries

U+5448, U+59C9, U+8821, U+947D, U+9855, U+20957, U+2BAA2
---
 IDS.TXT | 14 +++++++-------
 1 file changed, 7 insertions(+), 7 deletions(-)

mandel59

-- 常用漢字と規範字の対応表
with joyo_itaiji (常用漢字, 異体字) as (joyo_kangxi {漢字, 康熙字典体}; joyo {漢字, 漢字} distinct)
with joyo_zvar (常用漢字, 異体字) as (
    j: joyo_itaiji
        join u: unihan_variant on u.property = 'kZVariant' and u.UCS = j.異体字
        {常用漢字, 異体字};
    j: joyo_itaiji
        join m: mjsm_JIS包摂規準UCS統合規則 on j.異体字 = m.縮退UCS
        join mji on mji.MJ文字図形名 = m.MJ文字図形名
        [実装したUCS is not null]

mandel59

-- SQLite
WITH
    joyo_itaiji (常用漢字, 異体字) AS (
        SELECT DISTINCT joyo_kangxi.漢字 AS 常用漢字, joyo_kangxi.康熙字典体 AS 異体字
            FROM joyo_kangxi
        UNION
        SELECT DISTINCT joyo.漢字, joyo.漢字
            FROM joyo
    ),
    joyo_zvar (常用漢字, 異体字) AS (

mandel59

マインクラフト 染料のレシピ

flowchart LR
    white_dye[白色の染料]
        bone_meal[骨粉] --> white_dye
        lily_of_the_valley[スズラン] --> white_dye

    light_gray_dye[薄灰色の染料]
        black_dye --> bw_light_gray_dye