search for road data using coordinates.?

Asked Jun 04 '18 at 02:38

Active Jun 04 '18 at 02:38

Viewed 14 times

I have the path data labeled tabel_roads, I want to find the nearest road using coordinates. this is the script I have, but it does not work.

                            select id from tabel_roads ORDER BY geom <-> st_makepoint(-6.1688009873927925,106.8256151676178) LIMIT 1

asked Jun 04 '18 at 02:38

Nurul Hidayat

please give me link :) – Nurul Hidayat Jun 04 '18 at 03:26
btw., in ST_MakePoint, x is longitude, y is latitude - switch the ordinates! – geozelot Jun 06 '18 at 08:40

0 Answers0