INSERT INTO
INSERT INTO new_t(
id,
geom
)
VALUES
(
'7cbe6b84-34d5-4fde-b42f-306e0adbe4b9',
ST_GeomFromText('POINT(38.86498478900006 -76.97811568899994)',4326)
)
PostGIS 點對點的距離換算,參考資料
https://postgis.net/docs/ST_Distance.html
SELECT ST_Distance(
ST_GeomFromText('POINT(38.86509976200006 -76.97663465999995)',4326),
point
) from city_table;
沒有留言:
張貼留言