HTN20190109 https://blog.hatena.ne.jp/HTN20190109/ HTN20190109の日記 https://htn20190109.hatenablog.com/ DB MySQL (8.0.26)https://note.com/moli9ma/n/n3b530e3ad1d5https://qiita.com/onunu/items/59ef2c050b35773ced0d 追加インストールは不要 drop table tab1;create table tab1 ( col1 int primary key, col2 varchar(255), col3 geometry SRID 4326); -- point(緯度 経度)★insert into tab1 values (1, 'PointA', st_geomfromtext('point(12.… 190 <iframe src="https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhtn20190109.hatenablog.com%2Fentry%2F2021%2F11%2F06%2F231516" title="地理空間情報 - HTN20190109の日記" class="embed-card embed-blogcard" scrolling="no" frameborder="0" style="display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;"></iframe> Hatena Blog https://hatena.blog 2021-11-06 23:15:16 rich https://htn20190109.hatenablog.com/entry/2021/11/06/231516 1.0 100%