location based data storage and query.
Could you please find out how Oracle can help in location based data storage and query.
The expectations are:
- To store location based data with longitude and latitude.
- Query database to find out records which are within X range of radius of a certain longitude and latitude, say for example within 5KM radius.
Consider a table (MY_LOCATION) with following data:
SrNum | Latitude/Longitude | |
1 |
| |
2 |
| |
3 |
| |
4 |
| |
5 |
|
Now I want to query the table with something like this:
SELECT * FROM MY_LOCATION WHERE (LATITUDE IS 28.625452 WITH +5KM AND LONGITUDE IS 77.218386 WITH +5KM)
Note: The query is bracket is sudo query, I need actual sql statement to query the table.