$ curl "https://api-anorm.mapfan.com/v1/$(echo -n 長野県長野市大字長野旭町1108 | jq -sRr @uri).json" \
    -H 'x-api-key: <api-key>' \
    -H 'Content-Type: application/json' | jq -r
{
  "type": "FeatureCollection",
  "query": [
    "長野県長野市大字長野旭町1108"
  ],
  "features": [
    {
      "type": "Feature",
      "geometry": null,
      "properties": {
        "query": "長野県長野市大字長野旭町1108",
        "place_name": "長野県長野市長野旭町 1108",
        "pref": "長野県",
        "pref_kana": "ナガノケン",
        "city": "長野市",
        "city_kana": "ナガノシ",
        "area": "長野",
        "area_kana": "ナガノ",
        "koaza_chome": "旭町",
        "koaza_chome_kana": "アサヒマチ",
        "banchi_go": "1108",
        "building": "",
        "building_number": "",
        "zipcode": "3800846",
        "geocoding_level": 5,
        "geocoding_level_desc": "番地（番）レベルでマッチしました(5)",
        "log": "RM002:[大字(字)]の文字を除去しました",
        "not_normalized": ""
      }
    }
  ],
  "attribution": "(c) INCREMENT P CORPORATION"
}

$ curl "https://api-anorm.mapfan.com/v1/$(echo -n 長野県長野市旭町1108 | jq -sRr @uri).json" \
    -H 'x-api-key: <api-key>' \
    -H 'Content-Type: application/json' | jq -r
{
  "type": "FeatureCollection",
  "query": [
    "長野県長野市旭町1108"
  ],
  "features": [
    {
      "type": "Feature",
      "geometry": null,
      "properties": {
        "query": "長野県長野市旭町1108",
        "place_name": "長野県長野市旭町",
        "pref": "長野県",
        "pref_kana": "ナガノケン",
        "city": "長野市",
        "city_kana": "ナガノシ",
        "area": "旭町",
        "area_kana": "アサヒマチ",
        "koaza_chome": "",
        "koaza_chome_kana": "",
        "banchi_go": "",
        "building": "",
        "building_number": "",
        "zipcode": "3800846",
        "geocoding_level": 3,
        "geocoding_level_desc": "町域レベルでマッチしました(3)",
        "log": "NT001:正規化処理状況が建物名正規化処理の必要条件を満たさないので建物名正規化は行われません",
        "not_normalized": "1108"
      }
    }
  ],
  "attribution": "(c) INCREMENT P CORPORATION"
}

$ {
    curl -sSL http://jusyo.jp/downloads/new/csv/csv_zenkoku.zip -o csv_zenkoku.zip;
    unzip -p csv_zenkoku.zip | nkf -w;
    rm csv_zenkoku.zip
} >zenkoku.csv
$ brew install noborus/tap/trdsql

$ trdsql "
    SELECT COUNT(*)
    FROM zenkoku.csv
    WHERE c21 <> ''
"
22431

$ trdsql -otbln "
    SELECT c8, count(*) cn
    FROM zenkoku.csv
    WHERE c21 != ''
    GROUP BY c8
    ORDER BY cn DESC"
| 都道府県 | count(*) |
| --- | --- |
| 東京都 | 4734 |
| 愛知県 | 1541 |
| 北海道 | 1251 |
| 大阪府 | 884 |
| 福岡県 | 845 |
| 神奈川県 | 820 |
[..]
| 長野県 | 594 |
[..]
| 京都府 | 255 |
[..]
| 青森県 | 216 |

$ for p in 東京都 愛知県 北海道 大阪府 福岡県 神奈川県 青森県 京都府 長野県; do
    for a in $(trdsql "
        SELECT c8||c10||c21
        FROM zenkoku.csv
        WHERE c21 != '' AND c8 = '$p'
        ORDER BY RANDOM()
        LIMIT 100
    "); do
        curl -w'\n' "https://api-anorm.mapfan.com/v1/$(echo -n $a | jq -sRr @uri).json" \
            -H 'x-api-key: <api-key>' \
            -H 'Content-Type: application/json' >>output.jsonl;
    done &
done &

$ cat output.jsonl \
    | jq -r '[
        .features[].properties.pref,
        .features[].properties.query,
        .features[].properties.geocoding_level,
        .features[].properties.log
    ] | @csv' \
    | trdsql -otbln "
        SELECT c1, COUNT(*) cn
        FROM -
        WHERE c3 >= 5
        GROUP BY c1
        ORDER BY cn DESC
    "