Skip to main content
Geographic Information Systems

Return to Question

Question Protected by CommunityBot
Title changed, Content structured, One tag added
Source Link
Taras ♦
Taras ♦
  • 34k
  • 4
  • 73
  • 148

Find pointsfeatures within agiven coordinates and distance using MySQL

I have a mySQLMySQL table with user name, latitude and longitude of the user. 

I would like to get a list of userusers who are inside the circle or square of a given latitude and longitude with given distance. For example, my input Lat=Lat = 78.3232 and Long = 65.3234 and distance = 30 miles. I would like to get the list of users who are inside 30 miles distance from the point 78.3232 and 65.3234. 

Is it possible to solve this with single query? Or can you give me a hint start solving this query? I am new to the geo based information.

Find points within a distance using MySQL

I have a mySQL table with user name, latitude and longitude of the user. I would like to get a list of user who are inside the circle or square of a given latitude and longitude with given distance. For example my input Lat= 78.3232 and Long = 65.3234 and distance = 30 miles. I would like to get the list of users who are inside 30 miles distance from the point 78.3232 and 65.3234. Is it possible to solve this with single query? Or can you give me a hint start solving this query? I am new to the geo based information.

Find features within given coordinates and distance using MySQL

I have a MySQL table with user name, latitude and longitude of the user. 

I would like to get a list of users who are inside the circle or square of a given latitude and longitude with given distance. For example, my input Lat = 78.3232 and Long = 65.3234 and distance = 30 miles. I would like to get the list of users who are inside 30 miles distance from the point 78.3232 and 65.3234. 

Is it possible to solve this with single query? Or can you give me a hint start solving this query?

Tweeted twitter.com/StackGIS/status/1053345178755493889
made the title reflect the question
Link
RyanKDalton
RyanKDalton
  • 23.2k
  • 17
  • 112
  • 180

mysql geo based doubt Find points within a distance using MySQL

edited body
Source Link
Mapperz ♦
Mapperz ♦
  • 50.2k
  • 9
  • 75
  • 133

I have a mysqlmySQL table with user name, latitude and longitude of the user. I would like to get a list of user who are inside the circle or squiresquare of a given latitude and longitude with given distance. For example my input Lat= 78.3232 and Long = 65.3234 and distance = 30 miles. I would like to get the list of users who are inside 30 miles distance from the point 78.3232 and 65.3234. Is it possible to solve this with single query? Or can you give me a hint start solving this query? I am new to the geo based information.

I have a mysql table with user name, latitude and longitude of the user. I would like to get a list of user who are inside the circle or squire of a given latitude and longitude with given distance. For example my input Lat= 78.3232 and Long = 65.3234 and distance = 30 miles. I would like to get the list of users who are inside 30 miles distance from the point 78.3232 and 65.3234. Is it possible to solve this with single query? Or can you give me a hint start solving this query? I am new to the geo based information.

I have a mySQL table with user name, latitude and longitude of the user. I would like to get a list of user who are inside the circle or square of a given latitude and longitude with given distance. For example my input Lat= 78.3232 and Long = 65.3234 and distance = 30 miles. I would like to get the list of users who are inside 30 miles distance from the point 78.3232 and 65.3234. Is it possible to solve this with single query? Or can you give me a hint start solving this query? I am new to the geo based information.

Source Link
shihab K
shihab K
  • 361
  • 1
  • 4
  • 4