Check a lat long in particular radius?

Question

1.00/5 (1 vote)

See more:

We are developing location based application. here we are having set of lat,long in database. Now we need to collect all lat long in particular area.

Eg.
Table1
a-->10.20321,45.12364
b-->10.20321,12.12345
c-->10.20321,45.12378

From above details i need to collect persons who are all in particular area(around 15 Kms in a place).

What I have tried:

We are using google maps to get latitude and longitude of a person and wil be stored in DB.

Can anyone help to sort out?

Posted 30-Aug-16 6:32am

Balasubramanian T

Updated 30-Aug-16 10:44am

Add a Solution

Comments

Richard Deeming 30-Aug-16 15:04pm

Google has lots of suggestions for you - for example:
* Calculate distance, bearing and more between Latitude/Longitude points[^]
* Selecting points within a bounding circle[^]
* Finding Points Within a Distance of a Latitude/Longitude Using Bounding Coordinates[^]

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Patrice T · Answer 1 · 2016-08-30T10:44:00

Solution 1

Computing the distance between 2 points on earth is a classical problem, its name is Great Circle Distance.
Great-circle distance - Wikipedia, the free encyclopedia[^]

Richard's links are worth a look too.

Posted 30-Aug-16 10:44am

Patrice T

Check a lat long in particular radius?

1 solution

Solution 1

Add your solution here

Preview 0

Check a lat long in particular radius?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us