how to generate a query for bring points in a radius in postgis -


my question how calculate radius point locations in radius? trying query finds locations out site radius. example:

radius query

the query using is:

select * "property" "property"."deletedat" null     , ((st_dwithin(st_setsrid(st_point(43.628123412124616, -116.19140625), 4326)::geography, st_setsrid(st_point("latitude", "longitude"), 4326)::geography, 25730.9, true))) 

st_point takes longitude latitude, should swap 2 parameters. see doc


Comments

Popular posts from this blog

Is there a better way to structure post methods in Class Based Views -

reflection - How to access the object-members of an object declaration in kotlin -

php - Doctrine Query Builder Error on Join: [Syntax Error] line 0, col 87: Error: Expected Literal, got 'JOIN' -