Find latitude longitude within 100 km radius

Question

1.00/5 (1 vote)

See more:

Hello All.......

I am new in Asp.Net WCF REST Web Service development..........

I am working on Asp.Net WCF REST Web Service application which is using c# and MS SQL Server 2008 R2 as database. I want to have a list of locations within 100 km radius from a specified location. I do have a list of latitude and longitude stored in a table of database. I want to have one method in service which finds out the list of lat long within 100 km radius from a specified lat long.

As this is the Web service, so I think the code must be written in c# or sql stored procedure.

Can anybody help me to perform this?.

Thanks in advance.

- Regards

Posted 25-Dec-15 0:54am

Member 3153152

Updated 2-Oct-17 1:46am

Add a Solution

Comments

OriginalGriff 25-Dec-15 7:13am

And?
What have you tried?
Where are you stuck?
What help do you need?

Member 3153152 25-Dec-15 7:47am

I do not know how to do calculations for 100 km radius for a particular lat long.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

OriginalGriff · Answer 1 · 2015-12-25T02:34:00

Solution 1

"I do not know how to do calculations for 100 km radius for a particular lat long."

Then start with Google: radius for a particular lat long - Google Search[^]

In future, please try to do at least basic research yourself - otherwise you are wasting your (and our) time.

Posted 25-Dec-15 2:34am

OriginalGriff

Comments

Member 14150300 22-Feb-19 7:22am

---------------------------------------------------------
Quote
otherwise you are wasting your (and our) time.
------------------------------------------
I think the member is new to ASP.If you know means explain or neglect,Dont give any harsh reply here.

OriginalGriff 22-Feb-19 7:32am

Trust me, that's not harsh. I can do that, if you want?

When people are too lazy to use Google - and the google search I did used part of his question verbatim and found the solution - they need to be reminded that it's quicker to start with google, and that it wastes the time of others, which is plain rude. If you had checked, you would have seen that when he posted that question he had been here longer than I had - two whole years longer - and did not appear to have learned anything in the interim. Certainly long enough to have learned to find and use google himself...

Now, I know you are new here, but we aren't here to do your work for you - we are here to help those who are stuck. And if you want to be "the google fairy" then that's your business - it's your time, not mine - but the rest of us have work to do as well as voluntarily answering questions here.