1
I need to list a group of coordinates in a radius of 500m.
I have a name table TB_COORDENADAS
, with the columns LATITUDE
and LONGITUDE
.
I wish to point out a coordinate (lat, lng) and list all coordinates in the table that are in a radius of 500m.
What would be the best solution to my problem?
I have found solutions that would work in Mysql, but in Oracle 11g do not run. I need the result to be a list of latitude and longitude and not the distance between one point and another.