How to list a group of coordinates(latitude, longitude) in an Oracle 11g SQL table in a radius

Asked

Viewed 99 times

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.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.