Slide 25
Slide 25 text
例:GIS機能活用例
25 Copyright © 2025, Oracle and/or its affiliates
東京タワーから5km圏内にある店舗を特定する
店舗位置情報
id INT PRIMARY KEY
name VARCHAR(100)
location POINT SRID 4326 SPATIAL INDEX
サンプルデータ
INSERT INTO shops (name, location) VALUES
('Tokyo Station', ST_GeomFromText('POINT(35.6812 139.7671)', 4326)),
('Shibuya', ST_GeomFromText('POINT(35.6896 139.7004)', 4326)),
('Shinjuku', ST_GeomFromText('POINT(35.6895 139.7003)', 4326)),
('Ikebukuro', ST_GeomFromText('POINT(35.7289 139.7100)', 4326));
5km