Is it possible to search for objects by coordinates?

Question

PHP

There is a table of objects in the database, each has latitude / longitude coordinates. One object is taken, and you need to find other objects that are within a radius of 500 meters from it. Is it possible to make such a search by coordinates?
ps I don't mean search using api maps, namely the database, using coordinates

Answer 1

Под PostgreSQL существует PostGIS, который создан для рения задач, подобных вашей.
На русском о нем мало материалов, но кое-какие примеры есть тут и тут

Answer 2

I won’t say about the radius, but in a square of 500 meters you can

Answer 3

can. there is a formula for calculating the distance between two geocoordinates. Find on the internet. But the request to the database will be complicated habrahabr.ru/post/179157