Database Administration (MOSC)

MOSC Banner

location based data storage and query.

edited Jun 8, 2015 2:28AM in Database Administration (MOSC) 3 commentsAnswered ✓

Could you please find out how Oracle can help in location based data storage and query.

The expectations are:

  1. To store location based data with longitude and latitude.
  2. 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

  1. 28.625452/
  2. 77.218386

2

  1. 28.613925/
  2. 77.242246

3

  1. 28.601925/
  2. 77.273939

4

  1. 28.628579/
  2. 77.271429

5

  1. 28.660668/
  2. 77.271837

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center