So how do I write a query to get all rows within X meters of a certain lat/long coordinate?
I tried looking into the docs, but it's super confusing, ideally I just want to write
SELECT * FROM locdat WHERE ST_DWithin(ST_MakePoint(-71.1043443253471, 42.3150676015829),2000, true )
but I don't understand anything of the syntax they use in the docs or something like
select ST_MakePoint(loc_point) from locdat won't work either.
loc_point is data like
(54.66965,20.64888) of type