Wordpressで全国駅マスタが必要になった
汎用コードはどこにも転がってなかった。ただ、駅マスタを公開しているサイトはあった。
駅データ.jpである。
https://ekidata.jp/faq.php
このサイト、faqを見れば分かるようにかなりデータの扱いが柔軟ぽい。無償であれば有償データも第3者に提供してよいとなっている。
メンテナンスは素人には出来ないであろう、、というプロの余裕を感じるし、実際その通りだと思う。なかなか至れる境地ではなく、感服しきりである。
ありがたくデータを使わせてもらい、出来れば読者諸兄にも有償データを購入していただき、メンテナンスを応援してもらいたい。
マスタコード
都道府県番号からorder順を生成するので、最低限は順番通りに並ぶはず。
県レベル→路線レベル→駅レベル
という3レベル構造です。
https://github.com/obwebsys/obwebsys/blob/master/create-ekidata202209.php
生成コード（おまけ）
https://ekidata.jp/api/
こちらからAPIデータを取得し、ローカルに実行環境を整えて、そのうえで走らせるコードです。
有償データを前提に、駅名をslug名ローマ字に変換しています。
https://github.com/kuuuuuuuuuuma/convert_kana_to_hebon
20231127
・47都道府県をループで連続取得に改編
・新幹線を含むデータ取得に修正
・ローマ字を駅名だけはDBに含まれるものを使うコードに
index.php
<?php
include ("class-convert-kana-to-hebon.php");
$ary_todofuken = array(
"01"=>"北海道","02"=>"青森県","03"=>"岩手県","04"=>"宮城県","05"=>"秋田県","06"=>"山形県","07"=>"福島県","08"=>"茨城県","09"=>"栃木県","10"=>"群馬県","11"=>"埼玉県","12"=>"千葉県","13"=>"東京都","14"=>"神奈川県","15"=>"新潟県","16"=>"富山県","17"=>"石川県","18"=>"福井県","19"=>"山梨県","20"=>"長野県","21"=>"岐阜県","22"=>"静岡県","23"=>"愛知県","24"=>"三重県","25"=>"滋賀県","26"=>"京都府","27"=>"大阪府","28"=>"兵庫県","29"=>"奈良県","30"=>"和歌山県","31"=>"鳥取県","32"=>"島根県","33"=>"岡山県","34"=>"広島県","35"=>"山口県","36"=>"徳島県","37"=>"香川県","38"=>"愛媛県","39"=>"高知県","40"=>"福岡県","41"=>"佐賀県","42"=>"長崎県","43"=>"熊本県","44"=>"大分県","45"=>"宮崎県","46"=>"鹿児島県","47"=>"沖縄県");
$ary_todofuken_k = array(
"01"=>"hokkaido","02"=>"aomori","03"=>"iwate","04"=>"miyagi","05"=>"akita","06"=>"yamagata","07"=>"fukushima","08"=>"ibaraki","09"=>"tochigi","10"=>"gumma","11"=>"saitama","12"=>"chiba","13"=>"tokyo","14"=>"kanagawa","15"=>"niigata","16"=>"toyama","17"=>"ishikawa","18"=>"fukui","19"=>"yamanashi","20"=>"nagano","21"=>"gifu","22"=>"shizuoka","23"=>"aichi","24"=>"mie","25"=>"shiga","26"=>"kyoto","27"=>"osaka","28"=>"hyogo","29"=>"nara","30"=>"wakayama","31"=>"tottori","32"=>"shimane","33"=>"okayama","34"=>"hiroshima","35"=>"yamaguchi","36"=>"tokushima","37"=>"kagawa","38"=>"ehime","39"=>"kochi","40"=>"fukuoka","41"=>"saga","42"=>"nagasaki","43"=>"kumamoto","44"=>"oita","45"=>"miyazaki","46"=>"kagoshima","47"=>"okinawa");
$out_str1 = "";
// 「路線 - 駅」形式で出力する
$lcount = 0;
$scount = 0;
echo('<pre>');
foreach ($ary_todofuken as $pacode=>$pakanji) {
// $pref_id = 2;
$pref_id = intval($pacode);
echo '$_area_parent2 = $_func_lvx_create($_area_parent1,$_post_param,"'.$ary_todofuken_k[$pacode].'","'.$ary_todofuken[$pacode].'",'.intval($pacode).',$updateym);'."<br>";
$sql = "SELECT distinct SQL_CALC_FOUND_ROWS m_line.line_cd,m_line.line_name,m_line.line_name_k,m_line.lon,m_line.lat,m_line.zoom FROM m_line inner JOIN m_station ON m_line.line_cd = m_station.line_cd WHERE m_station.pref_cd = ".$pref_id." AND m_line.e_status = 0 ORDER BY m_line.e_sort,m_line.line_cd";
$stmt = $pdo->prepare($sql);
$stmt -> execute();
$csth = $pdo->query("SELECT FOUND_ROWS()");
$resultNumRows = $csth->fetchColumn();
$counter = 0;
$line_name_k_pre1 = array();
$station_name_k_pre1 = array();
$ary_slug1 = array();
$ary_slug2 = array();
if($resultNumRows>0){
foreach($stmt as $row){
$line_cd = $row['line_cd'];
$line_name = $row['line_name'];
$line_name_k = $row['line_name_k'];
$line_name_k = new Convert_Kana_To_Hebon( $line_name_k );
$line_name_k = strtolower($line_name_k->get_hebon()[0]);
if (in_array($line_name_k,$line_name_k_pre1)) {
$line_name_k_pre1[] = $line_name_k;
$line_name_k = $line_name_k.array_count_values($line_name_k_pre1)[$line_name_k];
} else {
$line_name_k_pre1[] = $line_name_k;
}
$line_lon = $row['lon'];
$line_lat = $row['lat'];
$line_zoom = $row['zoom'];
//駅一覧
$sql2 = "SELECT SQL_CALC_FOUND_ROWS station_cd,station_g_cd,station_name,station_name_r,lon,lat";
$sql2 .= " FROM m_station";
// $sql2 .= " WHERE e_status = 0 AND station_cd > 1000000 AND line_cd = " . $line_cd . " AND pref_cd = ".$pref_id;
$sql2 .= " WHERE e_status = 0 AND line_cd = " . $line_cd . " AND pref_cd = ".$pref_id; // 新幹線も含む
$sql2 .= " ORDER BY e_sort,station_cd";
$stmt2 = $pdo->prepare($sql2);
$stmt2 -> execute();
$csth2 = $pdo->query("SELECT FOUND_ROWS()");
$resultNumRows2 = $csth2->fetchColumn();
if($resultNumRows2>0){
$ary_slug_tmp = array();
$ary_slug_tmp["parent"] = array();
$ary_slug_tmp["parent"][$line_name_k] = $line_name;
$ary_slug_tmp["child"] = array();
$out_str1 .= "<br>".$line_name.$line_name_k."<br>";
$ii=0;
foreach($stmt2 as $row2){
$station_cd = $row2['station_cd'];
$station_g_cd = $row2['station_g_cd'];
$lon = $row2['lon'];
$lat = $row2['lat'];
$station_name = $row2['station_name'];
// $station_name_k = $row2['station_name_k'];
// $station_name_k = new Convert_Kana_To_Hebon( $station_name_k );
// $station_name_k = strtolower($station_name_k->get_hebon()[0]);
$station_name_k = $row2['station_name_r']; // dbにローマ字があるのでそれを使う
$station_name_k = strtolower($station_name_k);
if (in_array($station_name_k,$station_name_k_pre1)) {
$station_name_k_pre1[] = $station_name_k;
$station_name_k = $station_name_k.array_count_values($station_name_k_pre1)[$station_name_k];
} else {
$station_name_k_pre1[] = $station_name_k;
}
$ii++;
$out_str1 .= $station_name.$station_name_k."<br>";
$ary_slug_tmp["child"][$station_name_k] = $station_name; // 出力用
}
$ary_slug1[] = $ary_slug_tmp;
$station_name_k_pre1 = array();
$counter++;
}
}
// 整形
foreach ($ary_slug1 as $key=>$val) {
foreach ($val["parent"] as $line_name_k => $line_name) {
echo '$_area_parent3 = $_func_lvx_create($_area_parent2,$_post_param,"'.$line_name_k.'","'.$line_name.'","'.sprintf("%02d",$pref_id).sprintf("%05d",$_pi++)."0".'",$updateym);'."<br>";
$lcount++;
}
foreach ($val["child"] as $station_name_k=>$station_name) {
echo '$_area_parent4 = $_func_lvx_create($_area_parent3,$_post_param,"'.$station_name_k.'","'.$station_name.'","'.sprintf("%02d",$pref_id).sprintf("%05d",$_pi++)."0".'",$updateym);'."<br>";
$scount++;
}
}
}
}
echo('</pre>');
echo "station count = ".$scount."<br>";
echo "line count = ".$lcount."<br>";
?>