Topik ini menjelaskan fungsi ST_Transform, yang digunakan untuk mentransformasikan lintasan antara referensi spasial.
Sintaksis
lintasan ST_Transform(lintasan traj, int srid);Parameter
| Parameter | Deskripsi |
| traj | Lintasan yang ingin Anda transformasikan. |
| srid | Pengenal referensi spasial (SRID) dari lintasan dalam referensi spasial ke mana Anda ingin mentransformasikan. |
Catatan Lintasan hanya dapat ditransformasikan ke referensi spasial tertentu jika memiliki SRID.
Contoh
select ST_Transform('{"lintasan":{"versi":1,"tipe":"STPOINT","jumlah_daun":4,"waktu_mulai":"2020-11-03 08:00:00","waktu_akhir":"2020-11-03 18:03:20","spasial":"SRID=4326;LINESTRING(114.49211 37.97999,114.49211 37.97521,114.49191 37.98021,124 37)","garis_waktu":["2020-11-03 08:00:00","2020-11-03 08:01:40","2020-11-03 08:03:20","2020-11-03 18:03:20"]}}'::lintasan, 2401);
st_transform
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
{"lintasan":{"versi":1,"tipe":"STPOINT","jumlah_daun":4,"waktu_mulai":"2020-11-03 08:00:00","waktu_akhir":"2020-11-03 18:03:20","spasial":"SRID=2401;LINESTRING(29019418.8397 5025539.47515,29019696.5878 5024992.53808,29019387.9428 5025555.44863,29954166.377 5430882.06455)","garis_waktu":["2020-11-03 08:00:00","2020-11-03 08:01:40","2020-11-03 08:03:20","2020-11-03 18:03:20"]}}
(1 baris)